Question

BE10.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. 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, Actual direct labor cost $ 55,000 Budgeted direct labor cost $ 63,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.50 Actual Unnamed Flexible Budget

          BE10.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.
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,
Actual direct labor cost
$ 55,000
Budgeted direct labor cost
$ 63,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.50
Actual
Unnamed
Flexible Budget

BE10.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.
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,
Actual direct labor cost
55,000
Budgeted direct labor cost 63,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.50
Actual
Unnamed
Flexible Budget

Added by Eduardo C.

Question

Please give Ace some feedback