Aggregate Planning Exercise (October 2021] Student Name: Exercise If 6 Joshua's Materials Handling Supply Company manufactures pallet jacks {"Josh's lacks"} for warehouse operators. Joshua's Demand Planner has forecasted the requirements for a category of palletjacks for the coming year, and has included some of the information in the tables below. Assue that each month contains th same number of working days. 1. Using a level production strategy, calculate the ending inventory values by month in the chart bel Joshua has 500 units of inventory on hand to start the year, and he wants to end the year with about the sa me on har Starling Month values 1 2 3 4 5 6 7 a 9 1:} 11 12 Total Demand 950 1150 1200 1300 1350 1350 1300 1200 1100 1100 1050 900 13950 Production Inventory 2. If inventory carrying cost is $2.00 per unit per month' assessed at the end of each month, what would the total costs be with this level strategy? Starling Month values 1 2 3 4 5 6 i" B 9 10 11 12 Total Demand 950 1150 1200 1300 1350 1350 1300 1200 1100 1100 1050 900 Production Inventory Inventory cost 3. Joshua starts with 15 workers on staff. Each worker can produce 50 units per month. It costs $600 to hire a single new war Show the total hiring costs, and inventory costs, using the same production strategy as in Question 2 abut Starling Month values 1 2 3 a. 5 6 7 s 9 10 11 12 Total Demand 950 1150 1200 1300 1350 1350 1300 1200 1100 1100 1050 900 Production Inventory Inventory cost Number of workers New workers needed Hiring costs Grand Total Costs 4. Use the table below to illustrate a chase production plan. Joshua has 500 units on hand to start and he wants to end the year with about the s: Layoff costs are $600 per worker (cost of severance, paperwork, etc). It costs .Ioshua $600 each time he wants to hire a new \\. Starling Month values 1 2 3 4 5 6 7 8 9 10 11 12 Total Demand 950 1150 1200 1300 1350 1350 1300 1200 1100 1100 1050 900 Production Inventory Inventory cost Number of workers New workers needed or layed off Hiring and layoff costs Grand Total Costs 5.Analy2e the 2 pla ns. Comment about wh at plan you consider to be better