Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
can you tell me if this is correct? if not could you show me how to fix it with excel formulas included. X=44 3. A
can you tell me if this is correct? if not could you show me how to fix it with excel formulas included. X=44 3. A production manager has constructed the following (partial) time-phased MPS record (Chapter 7) Lot size =50+X. Complete the record. What is the projected available balance at period 6 ? \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 4) & A & B & C & D & E & F & G & H & 1 \\ \hline 1 & Week & & 1 & 2 & 3 & 4 & 5 & 6 & \\ \hline 2 & Forecast & & 20 & 45 & 20 & 45 & 35 & 46 & \\ \hline 3 & Orders & & 24 & 17 & 8 & 0 & 0 & 0 & \\ \hline 4 & Projected Available Balance & 5 & 75 & 30 & 10 & 59 & 24 & 72 & \\ \hline 5 & Available to Promise & & 50 & & & 94 & 0 & 94 & \\ \hline 6 & MPS & & 94 & & & 94 & & 94 & \\ \hline 7 & Lot size =44+50 & 94 & & & & & & & \\ \hline 8 & 8 & & & & & & & & \\ \hline 9 & & & & & & & & & \\ \hline 10 & & & & & & & & & \\ \hline 11 & & & & & & & & & \\ \hline 12 & & & & & & & & & \\ \hline 13 & & & & & & & & & \\ \hline 14 & & & & i & & & & & \\ \hline 15 & & & & & & & & & \\ \hline \end{tabular}
can you tell me if this is correct? if not could you show me how to fix it with excel formulas included.
X=44
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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