Data: Standard Cost Card
Inputs	Standard Quantity		Standard Price
Direct materials	3.0	pounds	$4.00	per pound
Direct labor	0.50	hours	$22.00	per hour
Variable manufacturing overhead	0.50	hours	$6.00	per hour
Actual results:
Actual output	2,000	units
Actual variable manufacturing overhead cost	$7,140
	Actual Quantity		Actual price
Actual direct materials cost	6,500	pounds	$3.80	per pound
Actual direct labor cost	1,050	hours	$21.60	per hour
Enter a formula into each of the cells marked with a ? Below. The variances should be positive numbers so use =ABS() in
your formula. For example, the formula for cell B23 should be =ABS(F19-F20)
Don't change the green cells. Those formulas are 'good.'
Standard Cost Variance AnalysisDirect Materials
Standard Quantity Allowed for the Actual Output, at Standard Price	?	pounds	?	per pound =	?
Actual Quantity of Input, at Standard Price	?	pounds	?	per pound =	?
Actual Quantity of Input, at Actual Price	?	pounds	?	per pound =	?
Direct materials variances:
Materials quantity variance	?
Materials price variance	?
Materials spending variance	?
Standard Cost Variance AnalysisDirect Labor
Standard Hours Allowed for the Actual Output, at Standard Rate	?	hours	?	per hour =	?
Actual Hours of Input, at Standard Rate	?	hours	?	per hour =	?
Actual Hours of Input, at Actual Rate	?	hours	?	per hour =	?
Direct labor variances:
Labor efficiency variance	?
Labor rate variance	?
Labor spending variance	?
Standard Cost Variance AnalysisVariable Manufacturing Overhead
Standard Hours Allowed for the Actual Output, at Standard Rate	?	hours	?	per hour =	?
Actual Hours of Input, at Standard Rate	?	hours	?	per hour =	?
Actual Hours of Input, at Actual Rate	1,050	hours	$6.80	per hour =	$7,140
Variable overhead variances:
Variable overhead efficiency variance	?
Variable overhead rate variance	?	F
Variable overhead spending variance	?	F

A1 "X Standard Costs and Variances Data: Standard Cost Card Inputs Standard Price $4.00 per pound $22.00 per hour $6.00 per hour Standard Quantity Direct materials Direct labor Variable manufacturing overhead 3.0 pounds 0.50 hours 0.50 hours Actual results Actual output Actual variable manufacturing overhead cost 2,000 units $7,140 Actual Quantity Actual price $3.80 per pound $21.60 per hour Actual direct materials cost 6,500 pounds 1,050 hours Actual direct labor cost Enter a formula into each of the cells marked with a? Below. The variances should be positive numbers so use -ABS() in your formula. For example, the formula for cell B23 should be -ABS(F19-F20) Don't change the green cells. Those formulas are 'good. Standard Cost Variance Analysis-Direct Materials Standard Quantity Allowed for the Actual Output, at Standard Price Actual Quantity of Input, at Standard Price Actual Quantity of Input, at Actual Price Direct materials variances ? pounds x ? poundsx pounds x ? per pound ? per pound 20 per pound- Materials quantity variance Materials price variance Materials spending variance 23 24 25 26