ws6 A4

12.1_alhambka_problem.xlsx

PA09-01

Student Name:
Class:
	Problem 09-01
BARLEY HOPP, INC.
Requirement 1: Direct Materials Variance
AP x AQ			AQ x SP			SQ x SP
	Direct			Direct
	Materials			Materials
	Price			Quantity
	> Variance <			> Variance <
	$ -	F Jack Terry: Select the correct answer from the drop-down list.		$ -	U
	Try again!			Try again!
	> Total Direct Materials Spending Variance <
			$ -	U
			Try again!
Requirement 2: Direct Labor Variance
AH x AR			AH x SR			SH x SR
Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.	Direct			Direct
	Labor			Labor
	Rate			Efficiency
	> Variance <			> Variance <
		U Jack Terry: Select the correct answer from the drop-down list.		$ -	F
				Try again!
	> Total Direct Labor Spending Variance <
			$ -	U
			Try again!
Requirement 3: Variable Overhead Rate & Efficiency Variances
Actual						Applied
Variable						Variable
Overhead						Overhead
Cost			AH x SR			Cost
Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.	Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.		Jack Terry: Select the correct answer from the drop-down list.	Variable			Variable
	Overhead			Overhead
	Rate			Efficiency
	> Variance <			> Variance <
	$ -	U Jack Terry: Select the correct answer from the drop-down list.		$ -	F
	Try again!			Try again!
	Total Variance
	> Over/Underapplied Variable Overhead <
			$ -	Underapplied	U
			Try again!

Given Data PA09-01:
	BARLEY HOPP, INC.
	Standard cost information:
		Standard	Standard	Standard
		Quantity	Price (rate)	Unit Cost
	Direct costs:
	Clay (pounds)	1.5	$ 1.60	$ 2.40
	Direct labor (hours)	1.5	$ 12.00	$ 18.00
	Variable manufacturing overhead		$ 1.20	$ 1.80
	Fixed manufacturing overhead			$ 2.50
	Actual results from last year:
	Number of units produced and sold			110,000
	Number of pounds of clay used			178,200
	Cost of clay			$ 267,300
	Number of labor hours worked			150,000
	Direct labor cost			$ 2,025
	Variable overhead cost			$ 200,000
	Fixed overhead cost			$ 270,000

Student Name:
Class:
	Problem 09-05
BULLSEYE COMPANY
Requirement 1: Direct Materials Variance
AQ x AP			AQ x SP			SQ x SP
	Direct			Direct
	Materials			Materials
	Price			Quantity
	> Variance <			> Variance <
	$ -	U Jack Terry: Select the correct answer from the drop-down list.		$ -	U
	Try again!			Try again!
	> Total Direct Materials Spending Variance <
			$ -	U
			Try again!
Requirement 2: Direct Labor Variances
AH x AR			AH x SR			SH x SR
Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.	Direct			Direct
	Labor			Labor
	Rate			Efficiency
	> Variance <			> Variance <
	$ -	F Jack Terry: Select the correct answer from the drop-down list.		$ -	U
	Try again!			Try again!
	> Total Direct Labor Spending Variance <
			$ -	F
			Try again!
Requirement 3: Variable Overhead Rate & Efficiency Variances
Actual						Applied
Variable						Variable
Overhead						Overhead
Cost			AH x SR			Cost
$ 72,000 Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.	Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.		Jack Terry: Select the correct answer from the drop-down list.	Variable		$ 74,000	Variable	$ 70,000
Correct!	Overhead		Correct!	Overhead		Correct!
	Rate			Efficiency
	> Variance <			> Variance <
	$ 2,000	F Jack Terry: Select the correct answer from the drop-down list.		$ 4,000	U
	Correct!			Correct!
	Total Variance
	> Over/Underapplied Variable Overhead <
			$ 2,000	Underapplied	U
			Correct!

Given Data PA09-05:
	BULLSEYE COMPANY
	Standard cost information:
		Standard	Standard	Standard
		Quantity	Price (rate)	Unit Cost
	Direct costs:
	Cork board (square feet)	2.5	$ 2.00	$ 5.00
	Direct labor (hours)	1.0	$ 14.00	$ 14.00
	Variable manufacturing overhead (hours)	1.0	$ 0.50	$ 0.50
	Fixed Manufacturing overhead			$ 0.25
	Actual results for September:
	Number of units produced and sold			140,000
	Number of square feet of corkboard used			360,000
	Cost of corkboard used			$ 756,000
	Number of labor hours worked			148,000
	Direct labor cost			$ 1,938,800
	Variable overhead cost			$ 72,000
	Fixed overhead cost			$ 50,000

Student Name:
Class:
	Problem 09-09
RIP TIDE COMPANY
Requirement 1: Direct Materials Variances
AQ x AP			AQ x SP			SQ x SP
	Direct			Direct
	Materials			Materials
	Price			Quantity
	> Variance <			> Variance <
	$ -	U Jack Terry: Select the correct answer from the drop-down list.		$ -	U
	Try again!			Try again!
	> Total Direct Materials Spending Variance <
			$ -	U
			Try again!
Requirement 2: Direct Labor Variances
AH x AR			AH x SR			SH x SR
Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.	Jack Terry: Enter the correct formulas in the yellow cells. Your answers will be verified.	Direct			Direct
	Labor			Labor
	Rate			Efficiency
	> Variance <			> Variance <
	$ -	U Jack Terry: Select the correct answer from the drop-down list.		$ -	F
	Try again!			Try again!
	> Total Direct Labor Spending Variance <
			$ -	U
			Try again!

Given Data PA09-09:
	RIP TIDE COMPANY
	Standard cost information:
		Standard	Standard	Standard
		Quantity	Price (rate)	Unit Cost
	Direct costs:
	Fiberglass (square feet)	15.0	$ 5.00	$ 75.00
	Direct labor (hours)	10.0	$ 15.00	$ 150.00
	Variable manufacturing overhead (hours)	10.0	$ 6.00	$ 60.00
	Fixed manufacturing overhead			$ 80.00
	Actual results for June:
	Number of units produced and sold			312
	Number of square feet of fiberglass used			4,920
	Cost of fiberglass used			$ 27,552
	Number of labor hours worked			3,060
	Direct labor cost			$ 47,736
	Variable overhead cost			$ 14,790
	Fixed overhead cost			$ 20,500