2. Fifty input shafts are on hand at the start of Week 1, and 26 are scheduled for delivery at the beginning of Week 2. Model 1000 master schedule 2 3 4 5 6 7 8 5 12 10 20 25 13 | 9 9 | 10 | Week 1 Demand 18 11 | 12 10 6 4 13 Model 1000 product structure Engine assembly Crankcase Gear box Lead time = 2 weeks Used: 1 per engine Input shaft Lead time = 3 weeks Used: 2 per gear box a. Initially, assume that Phil wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using lot-for-lot (L4L). (Leave no cells blank - be certain to enter "O" wherever required.) Gear Box Requirements a. Initially, assume that Phil wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using lot-for-lot (L4L). (Leave no cells blank - be certain to enter "0" wherever required.) Gear Box Requirements 1 2 3 4 5 6 7 8 9 10 11 12 Week: Gross requirements I Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input Shaft Requirements 1 2 3 4 5 6 7 8 9 10 11 12 Week: Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release 2. Fifty input shafts are on hand at the start of Week 1, and 26 are scheduled for delivery at the beginning of Week 2. Model 1000 master schedule 2 3 4 5 6 7 8 5 12 10 20 25 13 | 9 9 | 10 | Week 1 Demand 18 11 | 12 10 6 4 13 Model 1000 product structure Engine assembly Crankcase Gear box Lead time = 2 weeks Used: 1 per engine Input shaft Lead time = 3 weeks Used: 2 per gear box a. Initially, assume that Phil wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using lot-for-lot (L4L). (Leave no cells blank - be certain to enter "O" wherever required.) Gear Box Requirements a. Initially, assume that Phil wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using lot-for-lot (L4L). (Leave no cells blank - be certain to enter "0" wherever required.) Gear Box Requirements 1 2 3 4 5 6 7 8 9 10 11 12 Week: Gross requirements I Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input Shaft Requirements 1 2 3 4 5 6 7 8 9 10 11 12 Week: Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release