B C D E F G H I J K L M N Q1. Prestige, Inc. needs an aggregate plan for its product line. As part of trying to maintain a lean production system, management prefers a constant workforce, no overtime, and constant production level. Relevant data follows: 3 Item Data Units Data Item Data Units Production time required Units % of monthly forecast 4.5 labor hours per unit 0% Hiring cost $10,000 per person 4 Straight time labor $24 per hour $75 per unit $20,000 Item Ending inventory target Shortage cost Inventory holding cost Overtime labor cost Laying off charge 5 per person cost Workday 9 hours per $10 per unit per month Number of workers 72 people day Beginning inventory 0 units $36 per hour 9 The sales forecast for next year is: 11 Month Forecast 2000 1500 2000 2500 3000 3500 Month Jul Aug Sep Oct Nov Dec Forecast 4000 4500 4000 3000 2500 1500 Other assumptions: Even though the workday is 9 hours per day, workers are paid for 10 hours per day. Worker hires or layoffs take effect on the first day of the plan month. Backorders are carried over month-to-month 20 working days per month part A What is the total cost for this plan? (HINT: use a similar format for your spreadsheet as on S&OP lecture part I slide 18 "Level Strategy with backorders")