The Wildcat Company has provided the following information for the factory overhead cost pool:
Units of Output 30,000 Units 42,000
Units Indirect materials $180,000 $252,000
Indirect labour 1,080,000 1,512,000
Supervisors' salaries 312,000 312,000
Equipment depreciation 151,200 151,200
Maintenance 81,600 110,400
Utilities 384,000 528,000
Total $2,188,800 $2,865,600
Required: Using the high-low method and the information provided above,
1. identify the linear cost function equation and
2. estimate the total cost at 36,000 units of output.
3. Wildcat is now budgeting overhead costs of next year. It expects indirect material costs will increase by 6%, supervisor salaries will be 5% higher and that the variable portion of maintenance costs will increase by 4%. All other costs will remain at this year’s level. What is the expected cost function for next year if the company expects to produce 40,000 units?
1)
VC= ($2,865,600 - $2,188,800) / (42,000 - 30,000) = 676,800 / 12,000 = $56.40
FC= $2,865,600 - ($56.40 * 42,000) = $496,800
Thus cost function:
Y = $496,800 + $56.40X
2) Total cost at 36,000 units of output:
= $496,800 + ($56.40 X 36,000)
= $2,527,200
3)
Indirect material: 180,000 * .06 = 10,800; 252,000 * 0.06 = 15,120
Salary of supervisor: 312,000 * 0.05 = 15,600
Maintenance: 81,600*0.04 = 3,264; 110,400*0.04 = 4,416
($2,900,736 - $2,218,464) ÷ (42,000-30,000) = $56.856
FC = $2,900,736 - $56.856 * 42,000 = $512,784
Expected cost function for next year when expecting a production of 40,000 units
Y= $512,784 + 56.856X
Total cost: $512,784 + ($56.856 * 40,000) = $2,787,024
Get Answers For Free
Most questions answered within 1 hours.