answer the whole question using Excel please

18. The partially completed inventory record for the drive- shaft subassembly in Figure 11.37 shows gross require- ments, scheduled receipts, lead time, and current on-hand inventory. a. Complete the last three rows of the record for an FOQ of 50 units. b. Complete the last three rows of the record by using the L4L lot-sizing rule. c. Complete the last three rows of the record by using the POQ lot-sizing rule, with P = 4. Item: Driveshaft subassembly Lot Size: Lead Time: 3 weeks Week 1 2 3 4 5 5 6 7 B 8 Gross requirements 35 25 15 20 40 40 50 50 Scheduled receipts 80 Projected on-hand inventory 10 Planned receipts Planned order releases