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