Figure shows a partially completed inventory record for the real wheel subassemb

Question

Figure shows a partially completed inventory record for the real wheel subassembly. Gross requirements, scheduled receipts, lead time, and current on-hand inventory are shown. Complete the last three rows of the record for an FOQ of 200 units. Complete the last three rows of the record by using an FOQ of 100 units. Complete the last three rows of the record by using the L4L rule.

Explanation / Answer

Item = MQ-09 FOQ Lot Size = 200 units Item Description= Real Wheel Subassembly Week LT : 1 1 2 3 4 5 6 7 8 9 10 Gross Requirement 25 105 110 90 0 45 110 60 0 0 Scheduled Receipts 0 0 0 0 0 0 0 0 0 0 Projected On Hand 50 25 120 10 120 120 75 165 105 105 105 Net Requirements 0 80 0 80 0 0 35 0 0 0 Planned Receipts 0 200 0 200 0 0 200 0 0 0 Planned Order Release 200 0 200 0 0 200 0 0 0 0 Projected On Hand Calculation = Last Period Closing + Scheduled Receipt + Planned Receipt - Gross Requirement Net Requirement = Last Period Closing + Scheduled Receipt - Gross Requirement (If the above calculation results in negative amount, then such amount is taken as Net Requirement, else 0) Planned Receipt = If Net Requirement > 0, Planned Receipt as per Lot Size Planned Order Release = If Planned Receipt >0, Order as per Lead Time to be placed, Here 1 week before Item = MQ-09 FOQ Lot Size = 100 units Item Description= Real Wheel Subassembly Week LT : 1 1 2 3 4 5 6 7 8 9 10 Gross Requirement 25 105 110 90 0 45 110 60 0 0 Scheduled Receipts 0 0 0 0 0 0 0 0 0 0 Projected On Hand 50 25 20 10 20 20 75 65 5 5 5 Net Requirements 0 80 90 80 0 25 35 0 0 0 Planned Receipts 0 100 100 100 0 100 100 0 0 0 Planned Order Release 100 100 100 0 100 100 0 0 0 0 Projected On Hand Calculation = Last Period Closing + Scheduled Receipt + Planned Receipt - Gross Requirement Net Requirement = Last Period Closing + Scheduled Receipt - Gross Requirement (If the above calculation results in negative amount, then such amount is taken as Net Requirement, else 0) Planned Receipt = If Net Requirement > 0, Planned Receipt as per Lot Size Planned Order Release = If Planned Receipt >0, Order as per Lead Time to be placed, Here 1 week before Lot Size here is L4L which means order size will equal to Net Requirement Item = MQ-09 L4L Item Description= Real Wheel Subassembly Week LT : 1 1 2 3 4 5 6 7 8 9 10 Gross Requirement 25 105 110 90 0 45 110 60 0 0 Scheduled Receipts 0 0 0 0 0 0 0 0 0 0 Projected On Hand 50 25 0 0 0 0 0 0 0 0 0 Net Requirements 0 80 110 90 0 45 110 0 0 0 Planned Receipts 0 80 110 90 0 45 110 60 0 0 Planned Order Release 80 110 90 0 45 110 60 0 0 0 Projected On Hand Calculation = Last Period Closing + Scheduled Receipt + Planned Receipt - Gross Requirement Net Requirement = Last Period Closing + Scheduled Receipt - Gross Requirement (If the above calculation results in negative amount, then such amount is taken as Net Requirement, else 0) Planned Receipt = If Net Requirement > 0, Planned Receipt as per Lot Size Planned Order Release = If Planned Receipt >0, Order as per Lead Time to be placed, Here 1 week before

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.