1,000 case unith. Forecast Demand Ending Inventory Target Planning Data initial number of employees Emplyees per Ine Standard production rate (each line) Employee pay rase Overtme pay rate Standard hours per stin Maximum overtime per day. inventory carry cost Stockout cost Employee Piring and training coet Employee tayoft cost Agoregate Pian Unes run Overtme hours per day Beginning inventory Probuction Expected Demand Ending inventory Deviation from inventory Target Employees Cost of Plan Labor Regular Thme Labor Overtime Hiring and Training Layof Inventory Carry Cost stockout Cost 1at(113) 2,000 Quarter (Woek Numbers) 2nd (14-26) 3rd (27-39) 4th (40-52) 1st (Next Year) 385 2,500 2,650 2.200 Each number is a 13 week forecast This is caloulated based on 2 weeks of Thure forecast dertand. Numbers Units of measure Notes 60 empioyees 450 Cases per hour $20.00 per hour $30.00 per hour 7.5 hours 2 nours $1.00 per case (per year) $2.40 per case $5,000.00 per enpioyee $3,000,00 per employee Quarter (Woek Numbers) 1st (1-13) and (14-26) 3rd (2739)4 th (4052) The costs need to be calculated to complete this spreadsheet. Employees are pald for 8 hrs work per day. 60 employees are empioyeed currently. Carying ooet per year, divided by 4, mulpoted by 1,000. Basic on negative deviation from target