Question

NSF Lube is a fast-growing chain of oil-change stores. The following data are available for last year's services. NSF Lube performed 468,200 oil changes last year. It had budgeted 434,800 oil changes, averaging 12 minutes each. Standard variable labor and support costs per oil change were as follows Direct oil specialist services: 12 minutes at $23 per hour Variable support staff and overhead: 12.0 minutes at $17 per hour $4.60 3.40 Fixed overhead costs: Annual budget $1,038,800 Fixed overhead is applied at the rate of $2.40 per oil change. Actual oil change costs: Direct oil specialist services: 468,200 changes averaging 21 minutes at $26 per hour Variable support staff and overhead: 0.21 labor-hours at $16 per hour x 468,200 changes Fixed overhead $4,260,620 1,573,152 1,410,000 Required: a. Prepare a cost variance analysis for each variable cost for last year. b. Prepare a fixed overhead cost variance analysis

Answer 1

Particular	Price Variance	F/U	Efficiency variance	F/U	Total variance	F/U
Oil Specialist	$ 491,610	U	$ 1,615,290.00	U	$ 2,106,900.00	U
Variable overhead	$ 98,322	F	$ 79,594	U	$ 18,728	F

Fixed overhead cost variance
Particular	Amount	F/U
Price Variance	$ 371,200	U
Production volume variance	$ 84,880	F
Fixed Overhead cost variance	$ 286,320	U

Particular	Price Variance	F/U	Efficiency variance	F/U	Total variance	F/U
Oil Specialist	=(26-23)*(468200*21/60)	U	=-((468200*12/60)-(468200*21/60))*23	U	=C3+E3	U
Variable overhead	=-(16-17)*468200*(0.21*60)/60	F	=((468200*(0.21*60)/60)-(468200*12/60))*17	U	=C4-E4	F
Fixed overhead cost variance
Particular	Amount	F/U
Price Variance	=-(1038800-1410000)	U
Production volume variance	=(2.4*468200)-1038800	F
Fixed Overhead cost variance	=-((2.4*468200)-1410000)	U