Question: Please complete the entire table A table is assembled using three components, as shown in the accompanying product structure tree. The company that makes the

Please complete the entire tablePlease complete the entire table A table isPlease complete the entire table A table is

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 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.) Click here for the Excel Data File Master Schedule \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Wood Sections (2) } & Beg. Inv. & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline \multicolumn{1}{|c|}{ Lot size: Lot-for-Lot } & & 1 & 3 & & \\ \hline Gross requirements & & & & & & & \\ \hline Scheduled receipts & & & & & & & \\ \hline Projected on hand & & & & & & \\ \hline Net requirements & & & & & & \\ \hline Planned-order receipts & & & & & & \\ \hline Planned-order releases & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Braces (3) } & Beg. Inv. & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline \multicolumn{1}{|c|}{ Lot size: Lot-for-Lot } & & & & & & & \\ \hline Gross requirements & & & & & & \\ \hline Scheduled receipts & & & & & & \\ \hline Projected on hand & & & & & & \\ \hline Net requirements & & & & & & \\ \hline Planned-order receipts & & & & & \\ \hline Planned-order releases & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!