subject
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?

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 15:20
Table 1. shows the expected demand for the dvd at different suggested donation levels, and they can act as a single-price monopolist if they choose to. thereceipts will be used to fund gstcg supplies for their data collection and conservation work. at the end of each sea turtle nesting season, any excess funds are donated by the gstcg to a local non-profit sea turtle research and rehabilitation facility. table 1 suggested anticipated total marginal profit donation per number of dvd revenue revenue dvd request requests $19.00 0 $15.00 2 $9.50 4 $7.75 10 $3.00 15 $0.00 20 a. complete table 1 by computing the total revenue, marginal revenue, and profit columns. b. the president wants the gstcg to provide videos to generate the most possible donations (total revenue). what price, if any, is the president of the gstcg favoring and how many people will receive the dvd if this becomes the price of the suggested donation? explain your answer. c. the education outreach committee wants the gstcg to provide videos to the highest possible number of people. what price, if any, is the educational outreach committee favoring and how many people will receive the dvd if this becomes the price of the suggested donation? explain your answer. d. the treasurer of the gstcg wants the dvd program to be as efficient as possible so that the marginal revenue equals marginal cost. what price, if any, is the treasurer favoring and how many people will receive the dvd if this becomes the price of the suggested donation? explain your answer. e. the fundraising committee wants the dvd program to generate as much profit in donations as possible. what price, if any, is the fundraising committee favoring and how many people will receive the dvd if this becomes the price of the suggested donation? explain your answer.
Answers: 3
question
Business, 23.06.2019 02:40
German brothels recently began offering a monthly subscription service for multiple purchasers. if you thought that the brothels' encouragement of prostitution was immoral to begin with, would you consider this pricing plan to be even more immoral? suppose a particular patron at a german brothel has the following willingness-to-pay schedule for services at the brothel, per session. session willingness to pay 1st $84 2nd $72 3rd $60 4th $48 5th $36 6th $24 suppose this consumer would not demand any more sessions, even for free. also assume that the marginal cost to the brothel, per session, is constant at $12. at a price of $78.00 per session, the number of sessions demanded by this consumer would be . at this price and quantity, consumer surplus is $ and producer surplus is $ . suppose the brothel has devised a new pricing scheme for consumers who demand more than 1 session. this pricing scheme is a subscription service, whereby consumers can pay a flat fee of $259.20 and can have up to 6 sessions total. using this subscription pricing model, this consumer would demand sessions. under this scenario, consumer surplus is $ and producer surplus is $ . (hint: for consumer surplus, consider how much total value the consumer places on all sessions, versus the total price paid.)
Answers: 3
question
Business, 23.06.2019 04:00
Which of the following should be considered last when searching for financing
Answers: 2
question
Business, 23.06.2019 10:00
Vincent enjoys investing his money in ways that can generate a return. he realizes that also a chance that his investment will decrease in value. this chance is known as a. opportunity cost b. risk c. recession d. deterioration
Answers: 1
You know the right answer?
Air-Express is an express shipping service that guarantees overnight delivery of packages anywhere i...
Questions
question
Advanced Placement (AP), 02.02.2021 22:00
question
Mathematics, 02.02.2021 22:00
question
English, 02.02.2021 22:00
question
Mathematics, 02.02.2021 22:00
question
Mathematics, 02.02.2021 22:00
question
Biology, 02.02.2021 22:00