An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
Budget
(at Actual
Actual Production) Unfavorable (Favorable) Alternative Computation of Overhead Variances:
Variable costs:
Indirect factory wages
Power and light Actual costs Applied costs
Indirect materials Balance
Total variable cost
Fixed costs:
Supervisory salaries
Depreciation of plant and equip. Actual Factory Applied Factory
Insurance and property taxes Overhead Overhead
Total fixed cost Variable cost
Total factory overhead cost Fixed cost
Total controllable variances Total
Net controllable variance(favorable) unfavorable
Fixed Factory OH Rate
Volume variance(fav.) unfav. Controllable Volume
Total factory overhead cost variance(favorable) unfavorable Variance Variance
Total Factory
Overhead
Cost Variance
Supporting calculation:
Variable factory overhead rate:
Budgeted total variable cost
Budgeted hours
Variable factory overhead rate
Fixed factory overhead rate:
Total fixed costs
Productive capacity hours
Fixed factory overhead rate
Total
Actual hours
Applied costs
Idle (Excess) Hours
0%
Problem 23(9)-4B
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Factory Overhead
Budgeted Factory Overhead
for Amount Produced
Feeling Better Medical Inc.
Factory Overhead Cost Variance ReportAssembly Department
For the Month Ended October 31
Variances
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
Normal capacity for the month: 30,000 hours
Actual production for the month: 28,500 hours
Budget
(at Actual
Actual Production) Unfavorable (Favorable) Alternative Computation of Overhead Variances:
Variable costs:
$10,550 U
Total Factory
Overhead
Cost Variance
Supporting calculation:
Variable factory overhead rate:
Feeling Better Medical Inc.
Factory Overhead Cost Variance ReportAssembly Department
For the Month Ended October 31
Variances
Problem 23(9)-4B
Solution
Cells with non-gray backgrounds are protected and cannot be edited.
Instructions
Answers are entered in the cells with gray backgrounds.
ON