Question: In the post office 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 fulltime 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 part-time 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 Solver Table to determine how a change in the part-time labor limitation (currently 25%) influences the optimal solution.