Problem:
Item Cost Formula
Utilities… $6,000 per year, plus $0.30 per machine hour (MH)
Supplies… $10,000 per year, plus $0.80 per machine hour
Depreciation… $25,000 per year
Indirect labor… $21,000 per year, plus $0.40 per machine hour
Using these cost formulas, complete the following flexible budget:
Machine Hours
Cost Formula
Overhead Costs (per MH) 8,000 10,000 12,000
Variable overhead costs:
Utilities 0.30 2,400 3,000 3,600
Supplies 0.80 6,400 8,000 9,600
Indirect labor 0.40 3,200 4,000 4,800
Total variable costs.... $1.50 $12,000 $15,000 $18,000
Fixed overhead costs:
Utilities 6,000 6,000 6,000
Supplies 10,000 10,000 10,000
Depreciation 25,000 25,000 25,000
Indirect labor 21,000 21,000 21,000
Total fixed overhead costs.... 62,000 62,000 62,000
Total overhead costs... $74,000 $77,000 $80,000
Refer to the flexible budget data above. The standard time to complete one unit of product is 1.6 machine hours. Last year the company planned to operate at the 10,000 machine hour level of activity. During the year the following actual activity took place:
Number of units produced…. 5,000 units
Actual machine hours worked… 8,500 hours
Prepare a performance report for the year using the format that appears below. Do not compute efficiency variances for variable overhead items.
Performance Report Hardball Corp.
Budgeted machine hours…. ________________
Actual machine hours… ________________
Standard machine hours… ________________
Cost Formula Actual Cost Flex budget Spending or (per MH) 8,500 MHS based on Budgeted
8,500 MHs Variance
Variable overhead costs:
____________________ $________ $________ $________ $________
____________________ _________ _________ _________ _________
____________________ _________ _________ _________ _________
Total variable costs…. $________ _________ _________ _________
Fixed overhead costs:
____________________ _________ _________ _________
____________________ _________ _________ _________
____________________ _________ _________ _________
____________________ _________ _________ _________
Total fixed costs…. _________ _________ _________
Total overhead costs… $________ $________ $________