Question: 1) Based on the information provided, what are the current Planned Releases for Product A for weeks 11-18. 2)Based on the information provided, what are

 1) Based on the information provided, what are the current Planned

1) Based on the information provided, what are the current Planned Releases for Product A for weeks 11-18.

2)Based on the information provided, what are the current Gross Requirements for Item D for weeks 11-18.

3) Based on the information provided, what are the current Gross Requirements for Item E for weeks 11-18.

4) Based on the information provided, what will we be seeing next week in the Scheduled Receipt row, when we come back and complete the Item C MRP table covering weeks 12-19.

5) Complete the ITEM B MRP table for weeks 11-18 in the Excel spreadsheet. Item B uses a fixed order quantity (FOQ = 150) lot sizing rule.

6) The Scheduled Receipt of 150 units in week 12 shown in the Item B MRP table (cell O24) probably originated as a Planned Release in week:

ITEM C SCHEDULED RECEIPTS NEXT WEEK \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline Week: & 12 & 13 & 14 & 15 & 16 & 17 & 18 & 19 \\ \hline Planned Pielease & & & & & & & & \\ \hline \end{tabular} ITEM D GROSS REQUIREMENTS \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|l|}{ WeM D GRUSS REQUIREMENTS } \\ \hline Gross Requirements & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 \\ \hline \end{tabular} ITEM E GRQSS REQUIREMENTS \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|l|}{ WEM E GROSS REQUIREMENIS } \\ \hline Wreek: Goss Requirements & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 \\ \hline \end{tabular} ITEM C SCHEDULED RECEIPTS NEXT WEEK \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline Week: & 12 & 13 & 14 & 15 & 16 & 17 & 18 & 19 \\ \hline Planned Pielease & & & & & & & & \\ \hline \end{tabular} ITEM D GROSS REQUIREMENTS \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|l|}{ WeM D GRUSS REQUIREMENTS } \\ \hline Gross Requirements & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 \\ \hline \end{tabular} ITEM E GRQSS REQUIREMENTS \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|l|}{ WEM E GROSS REQUIREMENIS } \\ \hline Wreek: Goss Requirements & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 \\ \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 Accounting Questions!