Problem $13-6($Static$)$

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. Leard 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 separate orders on the same day. Leave no cells blank $-$ be certain to enter $"$O$"$ wherever required.$)$

$\backslash$table$[[$Quantity$,$Lead Time$],[1-200,1],[201-550,2],[551-999,3]]$

Click here for the Excel Data File

Master Schedule

$\backslash$tableAnswer i$,$mplete a$,$orrect.,,$],[$Day$,$Beg. Inv.,$1,2,3,4,5,6,7],[$Quantity$,00,0,00,0,100>,150,00,200]]$

Answer is not complete.

$\backslash$table$[[$Wood Sections $(2),$Beg. Inv.,$1,2,3,4,5,6,7],[$Lot size: Lot$-$for$-$Lot$],[$Gross requirements,$0,0,0,0,100,150,0,200x$

$\backslash$table$[[$Braces $(3),$Beg. Inv.,$1,2,3,4,5,6,7],[$Lot size: Lot$-$for$-$Lot$],[$Gross requirements,,,,,,,,$8],[$Scheduled receipts,,,,,,,,$],[$Projected on hand,,,,,,,,$],[$Net requirements,,,,,,,,$],[$Planned$-$order receipts,,,,,,,,$],[$Planned$-$order releases,,,,,,,,$]]$

Answer is not complete.

$\backslash$table$[[\backslash$table$[[$Legs $(4)],[$Lot size: Lot$-$for$-$Lot$]],$Beg. Inv.,$1,2,3,4,5,6,7],[$Gross requirements,$0,00,0vv,28x,,0vv,,0$