Can some please help me to complete part C which has empty tables. Also please guide me if other parts have some mistake. Thanks

In preparing the MRP example, Phil planned to use the worksheets shown the below and to make the following assumptions:

1. Eighteen gear boxes are on hand at the beginning of Week 1, and four gear boxes are currently on order to be delivered at the start of Week 2.
2. Forty input shafts are on hand at the start of Week 1, and 24 are scheduled for delivery at the beginning of Week 1.

Model 1000 Master Schedule
Week	1	2	3	4	5	6	7	8	9	10	11	12
Demand	16	6	8	10	13	15	20	10	9	8	3	15

Question: a. 1 2 3 6 10 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, what lot sizing technique would you recommend Phill to use? Fill out the MRP explosion according to your suggested lot sizing technique. Week 0 45 7 8 9 11 12 Gear Box Gross requirements 16 6 8 10 9 8 15 OH: 4(2) Scheduled receipts 0 4 0 0 0 0 0 0 0 0 LT:2 Projected available balance 18 2 0 0 SS: Net requirements 0 8 10 13 15 9 8 3 15 Q: Planned order receipts 8 10 15 10 9 3 15 Planned order releases 8 10 13 15 20 10 9 3 15 0 0 10 13 15 20 3 0 0 0 0 0 0 0 0 0 0 0 18181 0 0 13 lololo 8 0 3 6 8 12 Input Shaft 26 20 11 0 0 Week Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 2 20 0 28 0 OH: 24(1) LT: 1 SS: Q: 40 1 16 24 48 0 0 0 0 2 0 4 30 0 0 28 28 40 5 40 0 0 40 40 20 7 18 0 0 18 18 16 0 0 20 20 18 16 0 0 16 16 9 6 0 0 6 6 30 0 10 30 0 0 30 30 0 0 0 0 0 0 0 0 0 0 0 0 0 28 6 b. Phill would like to consider the cost that his accountants are currently using for inventory carrying and set up for the gear boxed and input shafts. These costs are as follows: Part Gear Box Cost Setup = $80/order Inventory carrying cost = $3/unit/week Setup = $50/order Inventory carrying cost = $2/unit/week Input Shaft Calculate the total cost of assembling model 1000 engine over 12 weeks by using your recommended lot sizing technique. 1 2 3 4 5 6 7 9 10 11 12 Total 8 0 0 0 0 0 0 0 0 0 0 6 Gear Box Inventory holding cost Set-up Cost Total Cost 6 80 0 80 80 80 80 80 80 80 0 0 80 80 80 80 800 806 86 80 80 80 80 80 80 80 0 0 4 5 8 9 11 Total 10 0 96 56 4 0 0 0 0 0 0 0 0 Input Shaft Inventory holding cost Set-up Cost Total Cost 0 0 50 50 50 0 0 50 50 50 50 50 50 50 50 0 0 156 350 506 96 56 54 50 0 0 c. To reduce the total cost of assembling engine 1000 in these 12 weeks, Phill considers implementing EOQ as the lot-sizing method for Gear Box schedule and L4L technique for Input Shaft schedule. Please conduct a new ERP explosion and calculate the associated total cost. Would Phil reduce the total cost by using this new schedule? If so, report the saving amount. 0 Week 0 1 2 3 4 5 6 12 Total BUAD3020-004, 2020 Fall 7 8 9 10 11 20 10 9 8 3 0 0 0 0 0 16 6 15 Gear Box OH: 4(2) 8 0 10 0 13 0 15 0 0 4 0 LT: 2 18 2 0 16 6 17 2 6 20 11 3 oooooo 0 0 8 0 0 18 4 0 15 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Inventory holding cost Set-up Cost Total Cost SS: Q: EOQ 0 0 0 0 0 0 24 7 24 24 0 0 24 24 0 15 24 24 0 24 0 0 0 15 0 649 Week 0 1 2 3 4 5 6 7 9 10 11 12 Total 8 . 48 0 48 48 0 0 0 30 0 0 0 Input Shaft OH:24(1) 48 0 oo 24 0 0 0 0 0 0 0 0 0 0 LT:1 40 16 16 0 0 0 0 0 0 0 0 0 0 SS: Q: EOQ 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Inventory holding cost Set-up Cost Total Cost 0 0 32 32 0 48 48 48 48 48 ololol 0 32 0 0 0 0 0 0 0 0 0 0 0 0 48 0 30 0 264 Question: a. 1 2 3 6 10 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, what lot sizing technique would you recommend Phill to use? Fill out the MRP explosion according to your suggested lot sizing technique. Week 0 45 7 8 9 11 12 Gear Box Gross requirements 16 6 8 10 9 8 15 OH: 4(2) Scheduled receipts 0 4 0 0 0 0 0 0 0 0 LT:2 Projected available balance 18 2 0 0 SS: Net requirements 0 8 10 13 15 9 8 3 15 Q: Planned order receipts 8 10 15 10 9 3 15 Planned order releases 8 10 13 15 20 10 9 3 15 0 0 10 13 15 20 3 0 0 0 0 0 0 0 0 0 0 0 18181 0 0 13 lololo 8 0 3 6 8 12 Input Shaft 26 20 11 0 0 Week Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 2 20 0 28 0 OH: 24(1) LT: 1 SS: Q: 40 1 16 24 48 0 0 0 0 2 0 4 30 0 0 28 28 40 5 40 0 0 40 40 20 7 18 0 0 18 18 16 0 0 20 20 18 16 0 0 16 16 9 6 0 0 6 6 30 0 10 30 0 0 30 30 0 0 0 0 0 0 0 0 0 0 0 0 0 28 6 b. Phill would like to consider the cost that his accountants are currently using for inventory carrying and set up for the gear boxed and input shafts. These costs are as follows: Part Gear Box Cost Setup = $80/order Inventory carrying cost = $3/unit/week Setup = $50/order Inventory carrying cost = $2/unit/week Input Shaft Calculate the total cost of assembling model 1000 engine over 12 weeks by using your recommended lot sizing technique. 1 2 3 4 5 6 7 9 10 11 12 Total 8 0 0 0 0 0 0 0 0 0 0 6 Gear Box Inventory holding cost Set-up Cost Total Cost 6 80 0 80 80 80 80 80 80 80 0 0 80 80 80 80 800 806 86 80 80 80 80 80 80 80 0 0 4 5 8 9 11 Total 10 0 96 56 4 0 0 0 0 0 0 0 0 Input Shaft Inventory holding cost Set-up Cost Total Cost 0 0 50 50 50 0 0 50 50 50 50 50 50 50 50 0 0 156 350 506 96 56 54 50 0 0 c. To reduce the total cost of assembling engine 1000 in these 12 weeks, Phill considers implementing EOQ as the lot-sizing method for Gear Box schedule and L4L technique for Input Shaft schedule. Please conduct a new ERP explosion and calculate the associated total cost. Would Phil reduce the total cost by using this new schedule? If so, report the saving amount. 0 Week 0 1 2 3 4 5 6 12 Total BUAD3020-004, 2020 Fall 7 8 9 10 11 20 10 9 8 3 0 0 0 0 0 16 6 15 Gear Box OH: 4(2) 8 0 10 0 13 0 15 0 0 4 0 LT: 2 18 2 0 16 6 17 2 6 20 11 3 oooooo 0 0 8 0 0 18 4 0 15 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Inventory holding cost Set-up Cost Total Cost SS: Q: EOQ 0 0 0 0 0 0 24 7 24 24 0 0 24 24 0 15 24 24 0 24 0 0 0 15 0 649 Week 0 1 2 3 4 5 6 7 9 10 11 12 Total 8 . 48 0 48 48 0 0 0 30 0 0 0 Input Shaft OH:24(1) 48 0 oo 24 0 0 0 0 0 0 0 0 0 0 LT:1 40 16 16 0 0 0 0 0 0 0 0 0 0 SS: Q: EOQ 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Inventory holding cost Set-up Cost Total Cost 0 0 32 32 0 48 48 48 48 48 ololol 0 32 0 0 0 0 0 0 0 0 0 0 0 0 48 0 30 0 264