Please use the information provided to complete requirements $1-5$ addressing standard costing. MOH is allocated using Machine hours.

$1$ & $2)...$ Show the entries for the variances for the direct manufacturing costs;

$3$ & $4)...$ Provide the entries for VMOH $($i$.$e$.,$ actual and allocated$)$;

$5).........$ Show the entries for the VMOH variances;

$6$ & $7)...$ Provide the entries for FMOH $($i$.$e$.,$ actual and allocated$)$;

$8).........$ Show the entries for the FMOH variances;

$9).........$ Provide the entry to make an adjustment to CGS$.$

The assignment should consist of four separate sheets, with labeled tabs for each, in the excel file:

A$.$ the input set of facts sheet with row and column headings

B$.$ requirements $1$ & $2($i$.$e$.,$ the computation of the direct cost variances with row and column headings$).$ Be sure to interpret and label variances as Favorable $($F$)$ or Unfavorable $($U$)$;

C$.$ requirements $5$ & $8($i$.$e$.,$ the computation of the indirect cost variances$)$ with row and column headings; Be sure to interpret and label variances as Favorable $($F$)$ or Unfavorable $($U$)$;

D$.$ the entries for requirements $1-9$ above.

Format the numbers in the sheets with numbers with comas $(1,000,000)$ and dollar signs if the unit of measure is in dollars

BUDGETED

Direct Materials $5\mathrm{.}00$ lbs$.$ per unit output $$30\mathrm{.}00$ per lbs$.$

Direct Labor $2\mathrm{.}00$ hours per unit output $$25\mathrm{.}00$ per hour

VMOH $$3,200,000$

FMOH $$5,600,000$

MHRS $80,000$ MHRS

Production volume $40,000$ Units output planned

Allocation base MHRS

ACTUAL

Direct Materials $4\mathrm{.}50$ lbs$.$ per unit output $$32\mathrm{.}00$ per lbs$.$

Direct Labor $2\mathrm{.}50$ hours per unit output $$22\mathrm{.}00$ per hour

VMOH $$3,192,000$

FMOH $$5,300,000$

MHRS $84,000$ Total actual MHRS

Production volume $35,000$ Units produced