PLEASE SHOW WORK

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 fotforlot ordering. (Note: Since the lead time varies based on order quantity it is possible to place two separate orders on the same day. Leave no cells blank be certain to enter "0" wherever required.) Quantity 1 - 200 201 - 550 551 - 999 Lead Tine 1 2 Click here for the Excel Dato File Table Wood sections (2) Braces (3) Legs (4) aster Schedule 4 Begin 150 200 DAY Quantity 0 100 Begime 1 0 1001 150 0 2001 Table Lot Lot-for-Lot size: Lot-for-Lot Scheduled receipts Projected on hand Not requirements Planned-order receipts Planned-order releases 0 0 0 0 o 0 0 0 100 0 o 150 02001 0 100 6 Bog, Inv Wood Sections (2) Lot size: Lot for Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg. In Braces (3) Lot wire: Lot for Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg Inv. 3 Legs (4) Loft Lot-for-Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases