Chapter 10: Applying Excel
Data
Exhibit 10-1: 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
Main Example: Chapter 10
Exhibit 10-4: Standard Cost Variance AnalysisDirect Materials
Actual Quantity of Input, at Actual Price	?	pounds	?	per pound =	?
Actual Quantity of Input, at Standard Price	?	pounds	?	per pound =	?
Standard Quantity Allowed for the Actual Output, at Standard Price	?	pounds	?	per pound =	?
Direct materials variances:
Materials price variance	?
Materials quantity variance	?
Materials spending variance	?
Exhibit 10-6: Standard Cost Variance AnalysisDirect Labor
Actual Hours of Input, at Actual Rate	?	hours	?	per hour =	?
Actual Hours of Input, at Standard Rate	?	hours	?	per hour =	?
Standard Hours Allowed for the Actual Output, at Standard Rate	?	hours	?	per hour =	?
Direct labor variances:
Labor rate variance	?
Labor efficiency variance	?
Labor spending variance	?
Exhibit 10-8: Standard Cost Variance AnalysisVariable Manufacturing Overhead
Actual Hours of Input, at Actual Rate	?	hours	?	per hour =	?
Actual Hours of Input, at Standard Rate	?	hours	?	per hour =	?
Standard Hours Allowed for the Actual Output, at Standard Rate	?	hours	?	per hour =	?
Variable overhead variances:
Variable overhead rate variance	?
Variable overhead efficiency variance	?
Variable overhead spending variance	?