Questions 3.16,3.18, 3.21, 3.36

the questions in the attachments folder are from the book MCgraw hill introduction to management science fourth edition. I also need you to solve it on excel spread sheet.
mcgraw hill connect

BUS 306

Spring 2012

H. Saber


Assignment #2

(Due April 12, 2012)

A. 1. Review chapters 3 from the textbook.

2. Go over the Solved Problems on the textbook’s CD-ROM for chapters 3 and 4.

B. 1. Provide complete solutions to problems 3.16, 3.18, 3.21, and 3.36 from the textbook (4th ed.) on pages 103 – 108

C. Refer to the Union Airways case on Personnel Scheduling in section 3.3 on page 75 to build your strategy

for dealing with the following case.

A bus company must provide drivers for buses. The schedule varies from hour to hour because of

customer demand as shown in the figure. Time 0 on the figure represents midnight, and times are shown

with a 24-hour clock starting at midnight. This is only an example schedule. You are to write a model for

a general problem with parameters describing the demand for the each four-hour period.

Driver requirements over a 24-hour period.

There are three classes of drivers: part time drivers who work four hour shifts, full time drivers who work a

continuous eight hour shifts, and split shift drivers who work four hours, are off four hours, and then return for

another four hours of work.

(a) Develop an algebraic model for the above situation that could be used to determine the minimum number
of drivers that should be used. Your model must include complete definitions/illustrations of (i) decision

variables, (ii) objective function, and (iii) the constraints.

(b) Set up a spreadsheet model for your algebraic model in (a) then use the SOLVER module on Ms-Excel to
solve it.

(c) Provide a summary report of your recommendations and observations based on your work in (b).

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?