9. Caloulate Total Revenue prier te any eqeipment changes using data in cella C6 through C14 above. The formulo for Mofit is Jotid Nrwenin - Total Costs The farmude for Fotal Revenue is totat Units sold * Solling Pike per Unit \begin{tabular}{|l|c|c|} \hline \multicolumn{1}{|c|}{} & \multicolumn{2}{|c|}{ Current Values } \\ \hline Data: & 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 UsecolumnFforquestion8 \\ \hline Parent (Domestic) \\ \hline 1,850,000 \\ \hline 1,425,000 \\ \hline 30,000 \\ \hline$18,56 \\ \hline$400,259 \\ \hline 100,000 \\ \hline$1,248,000 \\ \hline$3,500,000 \\ \hline$19.99 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline \multicolumn{2}{|c|}{ What If Productivity Values Based on New Data Entered in Column F } \\ \hline \multicolumn{1}{|c|}{ Measure } & Parent Organization \\ \hline Labor Productivity (units/labor hour) & 47.50 \\ \hline Labor Productivity (units/labor \$) & 2.56 \\ \hline Materials Productivity (units/\$) & 3.56 \\ \hline Equipment Productivity (units/hour) & 14.25 \\ \hline Equipment Productivity (units/\$) & 1.14 \\ \hline Total-Factor Productivity (units/\$) & 0.25 \\ \hline \end{tabular}