Please help,

CHANDLER CORP. DATA SHEET Chandler Corp. solution template

$1)$ Compute the target cost for the two proposed products.

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

$\backslash$hline & Selling price & Desired Profit & Target cost $\backslash \backslash$

$\backslash$hline Target cost of Pool Shades & & & $\backslash \backslash$

$\backslash$hline Target cost of Trellises & & & $\backslash \backslash$

$\backslash$hline

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

$2$a$)$ Compute the current activity rates based on practical capacity

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

$\backslash$hline ABC $-$ Practical Capacity & $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ Pctivity $\}$ & Cost & Practical & Cost driver & Activity $\backslash \backslash$

Capacity & unit & Rate & $\backslash \backslash$

$\backslash$hline Design$/$Drafting & & & eg$.)$ design hrs & & eg$.)/$des$.$ hr $\backslash \backslash$

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

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

$\backslash$hline Powder coating & & & & & $\backslash \backslash$

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

$\backslash$hline General factory costs & & & & $\backslash \backslash$

$\backslash$hline

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

$2$b$)$ Compute the cost of unused capacity using practical capacity rates.

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

$\backslash$hline Cost of Unused Capacity & Practical & Used & Unused & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ Activity $\}$ & Capacity & Capacity & Capacity & Rate & Label & Total Cost $\backslash \backslash$

$\backslash$hline Design$/$Drafting & & & & & $\backslash \backslash$

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

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

$\backslash$hline Powder coating & & & & & $\backslash \backslash$

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

$\backslash$hline General factory & & & & $\backslash \backslash$

$\backslash$hline Total cost of unused capacity & & & & $\backslash \backslash$

$\backslash$hline

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

$2$c$)$ Compute the total and unit cost of making the full demand of pool shades assuming that Chandler bases its rates on practical capacity.