Problem 12-6 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,200 units at the beginning of day 7. and there is no Inventory of tables is available at beginning. Receipts of 100 wood sections are scheduled at the beginning of day 2. There are 120 legs on hand. An additional 10 percent of the order size on legs is added for safety stock. There are 60 braces on hand with no safety stock requirement for braces. 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 varies based on order quantity it is possible to place two separte orders on the same day. Incorporate the safety stock for the legs by using the following formula: Planned order-receipts = Net Requirements *(1 + Safety Stock %). Round up any fractional values. Then carry the safety stock forward in subsequent on-hand Inventory calculations. Leave no cells blank - be certain to enter "0" wherever required.) Lead Time 1 - 200 201 - 55e 551 - 999 Table Wood sections (2) Braces (3) Legs (4) Master Schedule Day Quantity Table Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Wood Sections Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Braces Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases mo A A A Legs Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases