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, 22.06.2019 21:20

Suppose life expectancy in years (l) is a function of two inputs, health expenditures (h) and nutrition expenditures (n) in hundreds of dollars per year. the production function is upper l equals ch superscript 0.40 baseline upper n superscript 0.60l=ch0.40n0.60. beginning with c = 1, a health input of $400400 per year (hequals=44) and a nutrition input of $400400 per year (nequals=44), show that the marginal product of health expenditures and the marginal product of nutrition expenditures are both decreasing. the marginal product of health expenditures when h goes from 44 to 55 is nothing, and the marginal product of health when h goes from 66 to 77 is nothing. (round your answers to three decimal places.)

Answers: 2

Answer

Business, 23.06.2019 02:30

Driving would be more pleasant if we didn't have to put up with the bad habits of other drivers. a newspaper reported the results of a valvoline oil company survey of 500 drivers in which the drivers marked their complaints about other drivers. the top complaints turned out to be tailgating, marked by 24% of the respondents; not using turn signals, marked by 19%; being cut off, marked by 15%; other drivers driving too slowly, marked by 12%; and other drivers being inconsiderate marked by 5%.

Answers: 1

Answer

Business, 23.06.2019 07:30

Which of the following conditions might result in the best financial decisions? a. agreeableness b. openness c. conscientiousness d. extraversion

Answers: 1

Answer

Business, 23.06.2019 08:00

If consumers start to believe they need a product, what is likely to happen? a. the demand becomes less elastic. b. the demand becomes more elastic. c. the supply decreases. d. the price decreases.

Answers: 1

Answer

You know the right answer?

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

Questions