Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started