\begin{tabular}{|l|c|c|} \hline Data: & \multicolumn{2}{|c|}{ Current vahics } \\ \hline Metric & Parent (Domestic) & Subsidiary (LDC) \\ \hline Sales (units) & 1,850,000 & 750,000 \\ \hline Units Produced & 1,425,000 & 479,586 \\ \hline Labor (hours) & 40,000 & 20,000 \\ \hline Labor Cost (\$) per hour & $14.56 & $5.51 \\ \hline Materials Cost (\$) & $400,259 & $201,378 \\ \hline Equipment (Hours) & 120,598 & 30,578 \\ \hline Equipment Cost (\$) & $1,359,600 & $225,000 \\ \hline Fixed Costs (\$) & $2,000,000 & $725.000 \\ \hline Selling Price per Unit & $19.99 & $19.99 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \begin{tabular}{|} Uke columin F for \\ guestion 8 \end{tabular} \\ \hline Parent (Dornesfic) \\ \hline 1.850,000 \\ \hline 1.425,000 \\ \hline 40,000 \\ \hline$14.56 \\ \hline$400,259 \\ \hline 120,598 \\ \hline$1.359.600 \\ \hline$2.000,000 \\ \hline$19.99 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline \multicolumn{2}{|c|}{ What-ff Productivity Values Based on New Data Entered in Column F } \\ \hline \multicolumn{1}{|c|}{ Measure } & Parent Organization \\ \hline Labor Productivity (units/labor hour) & 35.63 \\ \hline Labor Productivity (units/labor $ ) & 2.45 \\ \hline Materials Productivity (units/S) & 3.56 \\ \hline Equipment Productivity (units/hour) & 11.82 \\ \hline Equipment Productivity (units/S) & 1.05 \\ \hline rotal Factor Productivity (units/S) & 0.33 \\ \hline \end{tabular} warkshert. then ehoose "decienseit? worksheet, then choose "decreased" 9. Cakculate Total Pevenue prior to any equipment changes using data in cells C6 through c14 above. The formade for Prafit b Total Revenue - Total Costs The formado for Jotol Revenue is Jatal Units 5old "Sellina Avike yer Unit Hint: Use Excel formulas to calculate your answer. For Example: To caiculate the Parent's total labor dollars, you multiply labor hours " labor cost In Excel, you enter: =CC9 The "." sign tells Excel that you are entering a formula and then you multiply the two cells that contain your data