$3$ Exercise $21-3($Algo$)$ Preparing flexible budgets LO P$10\mathrm{.}88$ points eBook References Tempo Company's fixed budget $($based on sales of $14,000$ units$)$ folllows. $\backslash$begin$\{$tabular$\}\{|$l$|$l$|\}\backslash$hline $\backslash$multicolumn$\{2\}\{|$c$|\}\{$Fixed Budget$\}\backslash \backslash \backslash$hline Sales $(14,000$ units $\backslash (\backslash$times $\backslash$$ $219\backslash )$ per unit$)$ & $3,066,000\backslash \backslash \backslash$hline $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Costs$\}\backslash \backslash \backslash$hline Direct materials & $350,000\backslash \backslash \backslash$hline Direct labor & $602,000\backslash \backslash \backslash$hline Indirect materials & $378,000\backslash \backslash \backslash$hline Supervisor salary & $150,000\backslash \backslash \backslash$hline Sales commissions & $126,000\backslash \backslash \backslash$hline Shipping & $224,000\backslash \backslash \backslash$hline Administrative salaries & $200,000\backslash \backslash \backslash$hline Depreciation$-$Office equipment & $170,000\backslash \backslash \backslash$hline Insurance & $140,000\backslash \backslash \backslash$hline Office rent & $150,000\backslash \backslash \backslash$hline Income & $576,000\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}1.$ Compute total variable cost per unit. $2.$ Compute total fixed costs. $3.$ Prepare a flexible budget at activity levels of $12,000$ units and $16,000$ units. Complete this question by entering your answers in the tabs below. Required $1$ Required $2$ Required $3$ Prepare a flexible budget at activity levels of $12,000$ units and $16,000$ units. $\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|\}\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$TEMPO COMPANY$\}\backslash \backslash \backslash$hline & $\backslash$multicolumn$\{2\}\{|$c$|\}\{$Flexible Budget$\}$ & $\backslash$multicolumn$\{2\}\{|$c$|\}\{$Flexible Budget for:$\}\backslash \backslash \backslash$hline & Variable Amount per Unit & Total Fixed Cost & Units Sales of $12,000$ & Unit Sales of $16,000\backslash \backslash \backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Sales$\}\backslash \backslash \backslash$hline Variable costs & & & & $\backslash \backslash \backslash$hline Direct labor & & & & $\backslash \backslash \backslash$hline Direct materials & & & & $\backslash \backslash \backslash$hline Indirect materials & & & & $\backslash \backslash \backslash$hline Sales commissions & & & & $\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}$ Complete this question by entering your answers in the tabs below.

Required $3$

Prepare a flexible budget at activity levels of $12,000$ units and $16,000$ units.

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

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$TEMPO COMPANY$\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{2\}\{|$c$|\}\{$Flexible Budget$\}$ & $\backslash$multicolumn$\{2\}\{|$c$|\}\{$Flexible Budget for:$\}\backslash \backslash$

$\backslash$hline & Variable Amount per Unit & Total Fixed Cost & Units Sales of $12,000$ & Unit Sales of $16,000\backslash \backslash$

$\backslash$hline Sales & & & & $\backslash \backslash$

$\backslash$hline Variable costs & & & & $\backslash \backslash$

$\backslash$hline Direct labor & & & & $\backslash \backslash$

$\backslash$hline Direct materials & & & & $\backslash \backslash$

$\backslash$hline Indirect materials & & & & $\backslash \backslash$

$\backslash$hline Sales commissions & & & & $\backslash \backslash$

$\backslash$hline Shipping & & & & $\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline & $0\mathrm{.}00$ & & $0$ & $0\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline Fixed costs & & & & $\backslash \backslash$

$\backslash$hline Administration salaries & & & & $\backslash \backslash$

$\backslash$hline Depreciation$-$Office equipment & & & & $\backslash \backslash$

$\backslash$hline Insurance & & & & $\backslash \backslash$

$\backslash$hline Office rent & & & & $\backslash \backslash$

$\backslash$hline Supervisor salary & & & & $\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline & & $\backslash$$ $0$ & $\backslash$$ $0$ & $\backslash$$ $0\backslash \backslash$

$\backslash$hline Income & & & & $\backslash \backslash$

$\backslash$hline

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