Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions