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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started