Use the Excel skills learned in this chapter to answer the following questions and problems. When submitting your answers on the Armond Dalton site, please round unit amounts to the nearest penny and other amounts to the nearest dollar or whole unit. When submitting your work as an Excel file, use reasonable formatting. Identifying and Computing the DM and DL Applied to the Job Q$-1.$ Use the information from Josey$$s spreadsheet and the purchase order for the first specialty candle job to calculate the total DM costs for the job. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline G & H & J & & & & L & M & N & $0$ & & & Q & R & S & T & U & V $\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{6\}\{|$c$|\}\{$Direct Materials$\}$ & & Lids & & $\backslash$$ & $0\mathrm{.}14$ & & & & & & $\backslash \backslash$

$\backslash$hline te & Input & & Per & Cost & & al Cost & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline $3$ & Wax & & $\backslash$$ & $1\mathrm{.}25$ & $\backslash$$ & $150\mathrm{.}00$ & & $\backslash$multicolumn$\{7\}\{|$c$|\}\{$DL Costs $($for Q$1$ to Q$8)\}$ & & & $\backslash \backslash$

$\backslash$hline & Wicks & & $\backslash$$ & $0\mathrm{.}05$ & $\backslash$$ & $6\mathrm{.}00$ & & $\backslash$multicolumn$\{4\}\{|$c$|\}\{$Pouring Department:$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$Finishing Department$\}$ & & & $\backslash \backslash$

$\backslash$hline $\backslash$multirow$[$b$]\{2\}\{*\}\{$Jivision Total$\}$ & Coloring & & $\backslash$$ & $0\mathrm{.}10$ & $\backslash$$ & $12\mathrm{.}00$ & & Labor Type & $\backslash$begin$\{$tabular$\}\{$l$\}$

Hours per Batch $\backslash \backslash$

$(12)$

$\backslash$end$\{$tabular$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Wage per hour$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{\backslash$begin$\{$tabular$\}\{$c$|$c$\}$

& Hours $\backslash \backslash$

per Batch $\backslash \backslash$

Labor Type & $\backslash ((12)\backslash )\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}\}$ & Wage per hour & & & $\backslash \backslash$

$\backslash$hline & Scent & & $\backslash$$ & $0\mathrm{.}29$ & $\backslash$$ & $34\mathrm{.}80$ & & Apprentice & $0\mathrm{.}12$ & $\backslash$$ & $15\mathrm{.}25$ & Apprentice & NA & NA & & & $\backslash \backslash$

$\backslash$hline $\backslash$multirow$[$t$]\{5\}\{*\}\{\backslash$$$170\mathrm{.}64\}$ & Clips & & $\backslash$$ & $0\mathrm{.}01$ & $\backslash$$ & $1\mathrm{.}20$ & & Candlemaker & $0\mathrm{.}07$ & $\backslash$$ & $26\mathrm{.}25$ & Candlemaker & $0\mathrm{.}05$ & $\backslash$$ $26\mathrm{.}25$ & & & $\backslash \backslash$

$\backslash$hline & Cellophane & & $\backslash$$ & $0\mathrm{.}01$ & $\backslash$$ & $1\mathrm{.}20$ & & Candle Master & $0\mathrm{.}02$ & $\backslash$$ & $32\mathrm{.}25$ & Candle Master & $0\mathrm{.}03$ & $\backslash$$ $32\mathrm{.}25$ & & & $\backslash \backslash$

$\backslash$hline & Information Stickers & & $\backslash$$ & $0\mathrm{.}02$ & $\backslash$$ & $2\mathrm{.}40$ & & $\backslash$multicolumn$\{4\}\{|$l$|\}\{$Additional DL for Specialty Candles$\}$ & & & & & & $\backslash \backslash$

$\backslash$hline & Packaging Boxes & & $\backslash$$ & $0\mathrm{.}02$ & $\backslash$$ & $1\mathrm{.}80$ & & Candle Master & $0\mathrm{.}04$ & $\backslash$$ & $32\mathrm{.}25$ & & & & & & $\backslash \backslash$

$\backslash$hline & Total DM & & & & $\backslash$$ & $209\mathrm{.}40$ & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$$$170\mathrm{.}64$ & & & & & & & & & MOH Cos & ts & to Q$8)$ & & & & & & $\backslash \backslash$

$\backslash$hline Exembt & & & & & & & & & Drivers & & ted & & & & & & $\backslash \backslash$

$\backslash$hline

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