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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Data Analysis And Decision Making

ISBN: 1209

6th Edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: