Variance Analysis

ch10.xls

P10-15

	Student Name:
	Class:
		Problem 10-15
1.
HELIX COMPANY
Materials Price and Quantity Variance
						Standard
Actual	Actual	Standard	Standard	Actual quantity	Actual quantity	quantity
quantity	price	quantity	price	@ actual price	@ std. price	@ std. price
		Price Variance
		Quantity Variance
		Spending Variance
				0
2.
HELIX COMPANY
Labor Rate and Efficiency Variances
						Standard
Actual	Actual	Standard	Standard	Actual hours	Actual hours	hours
hours	rate	hours	rate	@ actual rate	@ std. rate	@ std. rate
		Rate Variance
		Efficiency Variance
		Spending Variance
				0
3.
HELIX COMPANY
Variable Manufacturing Overhead Rate and Efficiency Variances
						Standard
Actual	Actual	Standard	Standard	Actual hours	Actual hours	hours
hours	rate	hours	rate	@ actual rate	@ std. rate	@ std. rate
		Rate Variance
		Efficiency Variance
		Spending Variance
				0

Enter appropriate data in yellow cells. Your answers will be verified.

Given Data P10-15:
HELIX COMPANY
Direct labor-hours per month	780
Robes produced	1,950
Standard costs:		Per Unit
	Total	of Product
Direct materials	$ 35,490	$ 18.20
Direct labor	$ 7,020	3.60
Variable manufacturing overhead	$ 2,340	1.20
		$ 23.00
April production:
Direct labor-hours worked	760
Robes produced	2,000
Actual costs during April:		Per Unit
	Total	of Product
Direct materials	$ 36,000	$ 18.00
Direct labor	$ 7,600	3.80
Variable manufacturing overhead	$ 3,800	1.90
		$ 23.70
Yards of material used in April	6,000
Standard material requirement per Robe	2.8	yards

Chapter 9: Applying Excel
Data
Revenue			$16.50	q
Cost of ingredients			$6.25	q
Wages and salaries	$10,400
Utilities	$800	+	$0.20	q
Rent	$2,200
Miscellaneous	$600	+	$0.80	q
Actual results:
Revenue	$27,920
Cost of ingredients	$11,110
Wages and salaries	$10,130
Utilities	$1,080
Rent	$2,200
Miscellaneous	$2,240
Planning budget activity	1,800	meals served
Actual activity	1,700	meals served
Enter a formula into each of the cells marked with a ? below
Review Problem: Variance Analysis Using a Flexible Budget
Construct a flexible budget performance report
					Revenue
					and
	Planning	Activity		Flexible	Spending	Actual
	Budget	Variances		Budget	Variances	Results
Meals served	?			?		?
Revenue	?	?		?	?	?
Expenses:
Cost of ingredients	?	?		?	?	?
Wages and salaries	?	?		?	?	?
Utilities	?	?		?	?	?
Rent	?	?		?	?	?
Miscellaneous	?	?		?	?	?
Total expenses	?	?		?	?	?
Net operating income	?	?		?	?	?