B G H K M 1st (1-13) 2,000 338 D Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 2,200 2,500 385 408 4th (40-52) 2,650 338 1st (Next Year) Notes 2,200 Each number is a 13 week forecast. This is calculated based on 6 weeks of future forecast demand Notes Forecast Demand by Quarter (1,000 Case Units) 1 1,000 case units. 2 3 Forecast Demand 4 Ending Inventory Target 5 6 Planning Data 7 Initial number of employees 8 Emplyees per line 9 Standard production rate (each line) 10 Employee pay rate 11 Overtime pay rate 12 Standard hours per shift 13 Maximum overtime per day 14 Inventory carry cost 15 Stockout cost 16 Employee hiring and training cost 17 Employee layoff cost 18 19 Aggregate Plan 20 21 Lines run 22 Overtime hours per day 23 24 Beginning Inventory 25 Production 26 Expected Demand 27 Ending Inventory 28 29 Deviation from Inventory Target B0 Employees Numbers Units of measure 60 employees 6 450 Cases per hour $20.00 per hour $30.00 per hour 7.5 hours 2 hours $1.00 per case (per year) $2.40 per case $5,000.00 per employee $3,000.00 per employee 3,000 2,500 2.000 1,500 1,000 500 0 1st (1-13) 2nd (14-26) 3rd (27-39) 4th (40-52) 1st (Next Year) 1st (1-13) 10 0 Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 10 10 0 0 4th (40-52) 10 0 Notes Construct solution here. 200.0 2,193.8 2,000.0 393.8 393.8 2,193.8 2,200.0 387.5 387.5 2,193.8 2,500.0 81.3 81.3 2,193.8 2,650.0 -375.0 55.3 60 2.9 60 -326.4 60 -713.5 60 Activate Windo