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 "O" wherever required.) Lead Time Quantity 1 - 200 201 - 550 551 - 999 WN Table Wood sections (2) Braces (3) Legs (4) Master Schedule Day Quantity 1 2 Beg. Inv. D D D D D D Beg. Inv. Begid Table Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg. Inv. Wood Sections Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg. Inv. Braces Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg. Iny. 4 Legs Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases