1.Prestige Plastics Corporation (PPC) has 35 thermoforming presses to produce plastic packaging. Each press requires one operator and can produce 500 pounds (lbs.) per hour. PPC currently employs 15 operators and has 500,000 lbs. of packaging on hand. Regular time production during a quarter is 8 hours per day, 5 days per week, and 13 weeks per quarter. Each press operator is paid $20 per hour and overtime is paid at 150% of the regular hourly rate. Each operator is limited to at most 60 hours of overtime per quarter.It costs $5,000 to layoff an operator and $3,000 to hire and train a new operator. It costs $150 to purchase 1,000 lbs. of plastic resin pellets to produce the packaging and it costs $7.50 to carry 1,000 lbs. of finished inventory for one quarter. The demand forecasts (in thousands of lbs.) for the next year are given in the worksheet labeled "PARTII-Q2." PPC does NOT plan to allow backorders, and does NOT use any subcontracting. Compute and enter the necessary parameters for the production planning spreadsheet and use it to find an optimal production plan for PPC.

Word File Edit View Insert Format Tools Table Window Help 100% 27 Thu 11:02 AM Q AutoSave OFF Prestige Plastics Corporation Home Insert Draw Design Layout References Mailings Review View Grammarly Acrobat Tell me LE Share Comments Intel Chips--Production Plan Objective Kw Ko Kwo Function Costs CW CH CL Co CI Cp Decision Variables D t Wt Lt Of It Cost (1000's) 15.00 500.0 Qtr. 1 5,920 2tr. 2 4, 100 Qtr. 3 4,770 Qtr. 4 12,880 Constraints Workforce Balance Inventory Balance Wt Wt-+HI-Lt It.1 + P +-Dt Qtr. 1 Qtr. 1 Qtr. 2 Qtr. 2 2tr. 3 Qtr. 3 Qtr. 4 Qtr. 4 Production Capacity Overtime Capacity