Masters Gadgets Company (MGC) produces power supply units for the gamer desktop computers. You (production planner) are assigned the job of developing an aggregate production plan for the six months from January through June. Using the following data, prepare the aggregate production plans for the next two scenarios independently. Month Expected Demand (units) January 1459 The following planning parameters apply: February March 1121 972 Backorder cost Opening inventory Planning Parameters 38 Current number of workers Labor hours Required Regular time labour cost Overtime labour cost Maximum overtime hours allowed Hiring cost (including training) Layoff cost Inventory carrying cost Planned ending inventory (end of month 6) Number of regular time hours Number of working days Cost of Subcontracting Material Cost 8 hours/unit $16.00/hour $24.00/hour April 1655 12.50% of regular labour-hours/month $825 /worker $1,050/worker $3.25/unit/month $11.00/unit backordered 65 units 105 units 8 hours/day 22 days/month $150 per unit $18 per unit May 996 June 1149 Name: Periods Expected Demand Beginning Inventory Required Production Units Required Productions Hours Planned Regular Hours Planned Overtime Hours Actual Production Units Units Subcontracted Ending Inventory Excess Inventory Shortage Beginning Workforce (Previous Period's Workforce) Workers Hired Workers Laid-off Ending Workforce (Current Period's Workforce) Cost Calculations: Material Cost Straight-time Cost Overtime Labor cost Carrying Cost Backorder (Shortage) Cost Subcontracting Cost Hiring Cost Layoff Cost Total Cost: Student Number: Total