Question: please complete problem and show excel formulas in yellow cells Show your work in the yellow cells in the same manner the work is shown

Show your work in the yellow cells in the same manner the work is shown in the Reading Guide (Ereel fie) when completing the input/output document below. 8. The following input-output data were gathered at the end of week 8 for a work center: \begin{tabular}{lcccccccc} \hline & \multicolumn{8}{c}{ Week } \\ \cline { 2 - 8 } & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline Planned input & 60 & 60 & 60 & 60 & 60 & 60 & 60 & 60 \\ Actual input & 68 & 70 & 75 & 70 & 68 & 60 & 55 & 55 \\ Planned output & 65 & 65 & 65 & 65 & 65 & 65 & 65 & 65 \\ Actual output & 60 & 62 & 63 & 63 & 64 & 65 & 63 & 60 \\ \hline \end{tabular} Beginning backlog =50 hours . a. Complete the input/output document. b. What was the planned objective? c. Was it met? d. What recommendations would you make
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
