In the employee scheduling example, suppose that each full-time employee works eight hours per day. Thus, Monday's
Question:
In the employee scheduling example, suppose that each full-time employee works eight hours per day. Thus, Monday's requirement of 17 workers can be viewed as a requirement of 8(17) = 136 hours. The post office can meet its daily labor requirements by using both full-time and part-time employees. During each week a full-time employee works eight hours a day for five consecutive days, and a part-time employee works four hours a day for five consecutive days. A full-time employee costs the post office $15 per hour, whereas a part-time employee (with reduced fringe benefits) costs the post office only $10 per hour. Union requirements limit parttime labor to 25% of weekly labor requirements.
a. Modify the model as necessary, and then use Solver to minimize the post office's weekly labor costs.
b. Use SolverTable to determine how a change in the part-time labor limitation (currently 25%) influences the optimal solution.
Step by Step Answer:
Business Analytics Data Analysis And Decision Making
ISBN: 1209
6th Edition
Authors: S. Christian Albright, Wayne L. Winston