3 20 Doint A table is assembled using three components, as shown in the accompanying product structure tree. The company that makes the table wants to ship 100 units at the beginning of day 4, 150 units at the beginning of day 5, and 200 units at the beginning of day 7 Receipts of 100 wood sections are scheduled at the beginning of day 2 There are 120 legs on hand, and 60 braces on hand Lead times in days) for all items are shown in the following table Prepare a material requirements plan using lot for lot ordering (Note: Since the lead time varles based on order quantity it is possible to place two separate orders on the same day. Leave no cells blank - be certain to enter "o" wherever required.) Quantity Lead Time 1200 201 - 550 551 999 Click here for the Excel Data File Table Wood sections (2) Braces (3) Legs (4) Retences Master Schedule Quantity Table Beat tite Lollo Lot Scheduled receipts Projected on hand Net requirements Panned-order recipe Planned order 3 Begin Wood Sections 2 Lole Lotto-Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned order releases Pints Book Hint Print o Begin References Braces Letti Lot for Lot Gross requirements Scheduled receipts Projected on hand Not requiremento Planned-order receipt Planned-order releases Begin Loos (4) Lo Sicolor Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order reipts Planned-order releases