8 The partially completed inventory record shown below indicates gross requirements, scheduled receipts, and current on-hand inventory of a component. a) Complete the last three rows of the record by using the L4L lot-sizing rule. b) Complete the last three rows of the record for an FOQ of 90 units. c) Complete the last three rows of the record by using the POQ lot-sizing rule, with P = 2 weeks. Rotor Assembly Week 0 1 2 3 4 5 6 7 Sched. 65 50 60 80 90 60 80 Recpts 65 On-Hand 150 Invntory Planned Recpts Planned Orders NOTE: No submission will be made here for this question. Submit your Excel sheet on Canvas. 8 The partially completed inventory record shown below indicates gross requirements, scheduled receipts, and current on-hand inventory of a component. a) Complete the last three rows of the record by using the L4L lot-sizing rule. b) Complete the last three rows of the record for an FOQ of 90 units. c) Complete the last three rows of the record by using the POQ lot-sizing rule, with P = 2 weeks. Rotor Assembly Week 0 1 2 3 4 5 6 7 Sched. 65 50 60 80 90 60 80 Recpts 65 On-Hand 150 Invntory Planned Recpts Planned Orders NOTE: No submission will be made here for this question. Submit your Excel sheet on Canvas