Bequired:

Use Excel to create a FrO process$-$costrig tempibe

$2$ Calculate work in$-$process invertory and couls tiantented out far Ifratwood Cabinets

Aak the Question

Heartwood is compling morth$-$end linarcial dah Guen cost ellormysonfor March, how much cost whould be asigned to month end work in process invertory and how much cout ihowld be transfered out of prosuction?

Master the Date

Heartwood had $3000$ units in begirng woN$-$engocess eneenoey on Mech $1$ Conts incurned during February for theie unk totaled $$160\mathrm{.}000$ for drect materaph and $$5,000$ lar canversee cents.

During March, $5,000$ addiforal unts were eated and $N,000$ unts mere completed. Coss adied to the proceis in begienng work in proceis win $100$ percent complete with nespeat so deect materils and $30$ pevcent complete wh

You have been provided a iemplate for the HFO method ef process cosing

Open freelthe tob $72$ Detatu

Perform the Anslysis

Aefer bo the leat er eflook for mithuctoont and steps for sach of the lib path.

Lob $7\mathrm{.}2($Static$)$ Excel: Assessment Questions

Arwwet the folowing questome based on tre detals pepwedrat

$\backslash$table$[[$Turexike$,$Amen$-$ry$],[,2lo00$ inta$],[,],[,131$rsmater$],[,3$ ycos$],[,14\mathrm{.}1400]]$