Total $=55$ points: Productivity Calculation Tab $(30$ points$)+$ What$-$If Analysis Tab $(25$ points$)$

$7.$ Provide one possible explanation how the Parent can be more productive when considering labor productivity in units per hour, but the subsidiary is more productive in units per dollar.$)$ Costs to $\backslash (\backslash$$ $1,248,000\backslash )$ with all other costs remaining the same. Change the appropriate values in column F above. Answer the questions below by comparing the new productivity value in cells D$18$ through D$23$ to the values you calculated on the "Productivity Calculations" worksheet. choose "decreased" arent Equipment Purchase

Part $\backslash$#$1)$ Costs to $\backslash (\backslash$$ $1,248,000\backslash )$ with all other costs remaining the same. Change the appropriate values in column Fabove. Answer the questions below by comparing the new productivity value in cells D$18$ through D$23$ to the values you calculated on the "Productivity Calculations" worksheet. choose "decreased"

$\backslash$begin$\{$tabular$\}\{|$r$|$c$|\}$

$\backslash$hline Productivity Measure & $\backslash$begin$\{$tabular$\}\{$r$\}$

Choose the correct answer $\backslash \backslash$

for each productivity $\backslash \backslash$

calculation

$\backslash$end$\{$tabular$\}\backslash \backslash$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$r$\}$

Labor Productivity in terms of $\backslash \backslash$

units$/$labor hour

$\backslash$end$\{$tabular$\}$ & decreased $\backslash \backslash$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$r$\}$

Labor Productivity in terms of $\backslash \backslash$

units$/$labor $\backslash$$

$\backslash$end$\{$tabular$\}$ & increased $\backslash \backslash$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$r$\}$

Materials Productivity in terms of $\backslash \backslash$

units$/$Materials Cost $(\backslash$$$)$

$\backslash$end$\{$tabular$\}$ & stayed the same $\backslash \backslash$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$r$\}$

Equipment Productivity in terms $\backslash \backslash$

of units$/$hour

$\backslash$end$\{$tabular$\}$ & decreased $\backslash \backslash$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$r$\}$

Equipment Productivity in terms $\backslash \backslash$

of units$/\backslash$$

$\backslash$end$\{$tabular$\}$ & increased $\backslash \backslash$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$r$\}$

Total Factor Productivity in terms $\backslash \backslash$

of units$/\backslash$$

$\backslash$end$\{$tabular$\}$ & increased $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ Parent Equipment Purchase

$($Part $\backslash$#$2)$

$9.$ Calculate Total Revenue prior to any equipment changes using data in cells C$6$ through C$14$ above.

The formula for Profit is Total Revenue $-$ Total Costs

The formula for Total Revenue is Total Units Sold $*$ Selling Price per Unit

$\backslash$begin$\{$tabular$\}\{|$r$|$r$|\}$

$\backslash$hline Pre Equipment Purchase Total & $\backslash \backslash$

Profit & $\backslash \backslash$

$\backslash$hline Post Equipment Purchase Total & $\backslash \backslash$

Profit & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ provide supporting evidence for your recommendation.