Business, 08.02.2021 18:30 adyenamaie02

Air-Express is an express shipping service that guarantees overnight delivery of packages anywhere in the continental United States. The company has various operations centers, called hubs, at airports in major cities across the country. Packages are received at hubs from other locations and then shipped to intermediate hubs or to their final destinations. The manager of the Air-Express hub in Baltimore, Maryland, is concerned about labor costs at the hub and is interested in determining the most effective way to schedule workers. The hub operates seven days a week, and the number of packages it handles each day varies from one day to the next. Using historical data on the average number of packages received each day, the manager estimates the number of workers needed to handle packages as: Day of Week Workers Required
Sunday 18
Monday 27
Tuesday 22
Wednesday 26
Thursday 25
Friday 21
Saturday 19

The package handlers working for Air-Express are unionized and are guaranteed a five-day work week with two consecutive days off. The base wage for handlers is $655 per week. Because most workers prefer to have Saturday or Sunday off, the union has negotiated bonuses of $25 per day for its members who work on these days. The possible shifts and salaries for package handlers are:

Shift Days Off Wage
1 Sunday and Monday $680
2 Monday and Tuesday $705
3 Tuesday and Wednesday $705
4 Wednesday and Thursday $705
5 Thursday and Friday $705
6 Friday and Saturday $680
7 Saturday and Sunday $655

The manager wants to keep the total wage expense for the hub as low as possible. With this in mind, how many package handlers should be assigned to each shift if the manager wants to have a sufficient number of workers available each day? Would you please provide an algebraic formulation for each problem and explain how to use Excel Solver to optimize?

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 20:40

Maria am corporation uses the weighted-average method in its process costing system. the baking department is one of the processing departments in its strudel manufacturing facility. in june in the baking department, the cost of beginning work in process inventory was $4,880, the cost of ending work in process inventory was $1,150, and the cost added to production was $25,200. required: prepare a cost reconciliation report for the baking department for june.

Answers: 2

Answer

Business, 22.06.2019 00:40

Select the statement that indicates tina's company is a partnership. tina jones is a dancer specializing in latin dance styles. she always wanted to have her own dance studio where she could teach dancing to young and old alike. in 2006, she opened her first dance studio, electric diva, in madison triangle. it was a great choice as a business location because it's well-connected by highways to most places in the city. she leased the space for three years. her initial investment included a good sound system, cheerful interior design, and strong flooring. to raise capital for the business, tina turned to her brother-in-law, philip. philip made half the financial investment. he manages the accounts and social media needs of the business. he has a 30% share in trisha's business. together, they expanded the business to three dance studios in the city and plan to open franchises in other cities.

Answers: 1

Answer

Business, 22.06.2019 05:00

Personal financial planning is the process of creating and achieving financial goals? true or false

Answers: 1

Answer

Business, 22.06.2019 09:40

Catherine de bourgh has one child, anne, who is 18 years old at the end of the year. anne lived at home for seven months during the year before leaving home to attend state university for the rest of the year. during the year, anne earned $6,000 while working part time. catherine provided 80 percent of anne's support and anne provided the rest. which of the following statements regarding whether anne is catherine's qualifying child for the current year is correct? a.anne is a qualifying child of catherine.b.anne is not a qualifying child of catherine because she fails the gross income test.c.anne is not a qualifying child of catherine because she fails the residence test.d.anne is not a qualifying child of catherine because she fails the support test.

Answers: 2

Answer

You know the right answer?

Air-Express is an express shipping service that guarantees overnight delivery of packages anywhere i...

Questions