Crosshill Company's total overhead costs at various levels of activity are presented below. Month April May...

Transcribed Image Text:

Crosshill Company's total overhead costs at various levels of activity are presented below. Month April May June July Machine-Hours 70,000 60,000 80,000 90,000 Total Overhead Cost $204,000 $183,000 $225,000 $246,000 Assume that the overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 60,000-machine-hour level of activity in May is as follows: Utilities (variable) Supervisory salaries (fixed) Maintenance (mixed) Total overhead cost $ 54,000 21,000 108,000 $183,000 The company wants to break down the maintenance cost into its variable and fixed cost elements. Required: 1. Estimate how much of the $246,000 of overhead cost In July was maintenance cost. (Hint: To do this, first determine how much of the $246,000 consisted of utilities and supervisory salaries. Think about the behaviour of variable and fixed costs within the relevant range.) (Round the "Varlable cost per unit" to 2 decimal places.) Maintenance cost in July S 125,000 2. Using the high-low method, estimate a cost formula for maintenance. (Round the "Variable cost per unit" to 2 decimal places.) High activity level Machine- Hours Maintenance Cost Low activity level 90,000 $ 60,000 125,000 95,333 Change 30,000 $ 29,667 Variable cost element $ 1.31 per MH Fixed cost element $ 1.31 X 3. Express the company's total overhead cost in the form Y=a+bX. (Round the "Varlable cost per unit" to 2 decimal places.) Variable Cost per Machine-Hour Fixed Cost Utilities cost Supervisory salaries cost $ 118,007.00 $ 6,993 Maintenance cost Total overhead cost $ 78,671.33 196,678.33 $ 6,993 $ 6,993 $ 2.21 X 4. What total overhead cost would you expect to be incurred at an activity level of 75,000 machine-hours? (Round the "Variable cost per unit" to 2 decimal places.) Crosshill Company's total overhead costs at various levels of activity are presented below. Month April May June July Machine-Hours 70,000 60,000 80,000 90,000 Total Overhead Cost $204,000 $183,000 $225,000 $246,000 Assume that the overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 60,000-machine-hour level of activity in May is as follows: Utilities (variable) Supervisory salaries (fixed) Maintenance (mixed) Total overhead cost $ 54,000 21,000 108,000 $183,000 The company wants to break down the maintenance cost into its variable and fixed cost elements. Required: 1. Estimate how much of the $246,000 of overhead cost In July was maintenance cost. (Hint: To do this, first determine how much of the $246,000 consisted of utilities and supervisory salaries. Think about the behaviour of variable and fixed costs within the relevant range.) (Round the "Varlable cost per unit" to 2 decimal places.) Maintenance cost in July S 125,000 2. Using the high-low method, estimate a cost formula for maintenance. (Round the "Variable cost per unit" to 2 decimal places.) High activity level Machine- Hours Maintenance Cost Low activity level 90,000 $ 60,000 125,000 95,333 Change 30,000 $ 29,667 Variable cost element $ 1.31 per MH Fixed cost element $ 1.31 X 3. Express the company's total overhead cost in the form Y=a+bX. (Round the "Varlable cost per unit" to 2 decimal places.) Variable Cost per Machine-Hour Fixed Cost Utilities cost Supervisory salaries cost $ 118,007.00 $ 6,993 Maintenance cost Total overhead cost $ 78,671.33 196,678.33 $ 6,993 $ 6,993 $ 2.21 X 4. What total overhead cost would you expect to be incurred at an activity level of 75,000 machine-hours? (Round the "Variable cost per unit" to 2 decimal places.)