BE$10\mathrm{.}8-$ Using Excel to Calculate Direct Labor Variances

PROBLEM

Rob, the production manager, was pleased at the company's income statement results, even though actual sales volume came in below original projections. Information concerning the budgeted and actual amounts for direct labor are provided here.

$\backslash$table$[[$Actual direct labor cost,$55,000,],[$Budgeted direct labor cost,$$3,000,],[$Actual direct labor hours used,$2,500,],[$Actual units produced and sold,$1,200,],[$Units below budget for sales volume,$200,],[$Budgeted direct labor hours per unit,,$2],[$Budgeted direct labor rate per hour,$$,22\mathrm{.}50]]$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated.

Calculate the company's DL price and DL efficiency variances.