Question

Overhead variances, ethics. Zeller Company uses standard costing. The company has two manufacturing plants, one in Nevada and the other in Ohio. For the Nevada plant, Zeller has budgeted annual output of 4,000,000 units. Standard labor hours per unit are 0.25, and the variable overhead rate for the Nevada plant is $3.25 per direct labor hour. Fixed overhead for the Nevada plant is budgeted at $2,500,000 for the year. For the Ohio plant, Zeller has budgeted annual output of 4,200,000 units with standard labor hours also 0.25 per unit. However, the variable overhead rate for the Ohio plant is $3 per hour, and the budgeted fixed overhead for the year is only $2,310,000. Firm management has always used variance analysis as a performance measure for the two plants, and has compared the results of the two plants. Jack Jones has just been hired as a new controller for Zeller. Jack is good friends with the Ohio plant manager and wants him to get a favorable review. Jack suggests allocating the firm’s budgeted common fixed costs of $3,150,000 to the two plants, but on the basis of one-third to the Ohio plant and two-thirds to the Nevada plant. His explanation for this allocation base is that Nevada is a more expensive state than Ohio. At the end of the year, the Nevada plant reported the following actual results: output of 3,900,000 using 1,014,000 labor hours in total, at a cost of $3,244,800 in variable overhead and $2,520,000 in fixed overhead. Actual results for the Ohio plant are an output of 4,350,000 units using 1,218,000 labor hours with a variable cost of $3,775,800 and fixed overhead cost of $2,400,000. The actual common fixed costs for the year were $3,126,000.

1. Compute the budgeted fixed cost per labor hour for the fixed overhead separately for each plant:

Required a. Excluding allocated common fixed costs b. Including allocated common fixed costs

2. Compute the variable overhead spending variance and the variable overhead efficiency variance separately for each plant.

3. Compute the fixed overhead spending and volume variances for each plant:

a. Excluding allocated common fixed costs

b. Including allocated common fixed costs

4. Did Jack Jones’s attempt to make the Ohio plant look better than the Nevada plant by allocating common fixed costs work? Why or why not?

5. Should common fixed costs be allocated in general when variances are used as performance measures? Why or why not?

6. What do you think of Jack Jones’s behaviour overall?

i want complete calculations part 1 to part 6

Answer 1

1. a. Exlcluding allocated common FOH:
Nevada Plant = 2500000/(4000000*0.25) = $2.50 per labour hour
Ohio Plant = 2310000/(4200000*0.25) = $2.20 per labour hour

b. Including allocated common FOH:
Nevada Plant = (2500000+(3150000*2/3))/(4000000*0.25) = $4.60 per labour hour
Ohio Plant = (2310000+(3150000*1/3))/(4200000*0.25) = $3.20 per labour hour

2.
VOH spending Variance = (AH*AR)-(AH*SR)
VOH efficiency variance = (AH*SR)-(SH*SR), where:
AH=Actual Hours
AR = Actual rate per labour hour
SH = Standard Hours
SR = Standard Rate

Nevada Plant
AH	AR	SR	SH	AH*AR	AH*SR	SH*SR
1,014,000.00	=3244800/1014000=3.20	3.25	=4000000*0.25 = 1,000,000	3,244,800.00	3,295,500.00	3,250,000.00

VOH spending Variance = (AH*AR)-(AH*SR) = 3244800-3295500 = 50700(F)
VOH efficiency variance = (AH*SR)-(SH*SR) = 3295500 - 3250000 = 45500 (U)

Ohio Plant
AH	AR	SR	SH	AH*AR	AH*SR	SH*SR
1,218,000.00	=3775800/1218000 = 3.10	3.00	=4200000*0.25 = 1,050,000	3,775,800.00	3,654,000.00	3,150,000.00

VOH spending Variance = (AH*AR)-(AH*SR) = 3775800-3654000 =121800 (U)
VOH efficiency variance = (AH*SR)-(SH*SR) = 3654000-3150000 = 504000 (U)

3.
FOH Spending Variance = Actual Fixed OH - (AH*SFOR), where:
SFOR = Standard Fixed OH rate = Standard FOH/Actual hours

a. Excluding allocated Common FOH
SFOR Nevada Plant = 2500000/(4000000*0.25) = $2.50 per hour
SFOR Ohio Plant = 2310000/(4200000*0.25) = $2.20 per hour
Nevada Plant FOH spending Variance = 2520000 - (1014000*2.50) = 15000 (F)
Ohio Plant FOH spending Variance = 2400000 - (1218000*2.20) = 279,600 (F)
b. Including allocated Common FOH
SFOR Nevada Plant = (2500000+2100000)/(4000000*0.25) = $4.60 per hour
SFOR Ohio Plant = (2400000+1050000)/(4200000*0.25) = $3.20 per hour
Nevada Plant FOH spending Variance = (2520000+2084000) - (1014000*4.60) = 60,400 (U)
Ohio Plant FOH spending Variance = (2400000+1042000) - (1218000*3.20) = 455,600 (U)