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

Names:

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).