Question

The following selected data were taken from the accounting records of Colorado Enterprises:

Month	Machine Hours				Manufacturing Overhead
May		47,500			$	904,000
June		60,600				1,136,000
July		71,000				1,306,300
August		53,500				983,000

Manufacturing overhead consists of three different costs; (1) machine supplies (variable), (2) property taxes (fixed), and (3) plant maintenance (semivariable). July's overhead costs were $172,000 for machine supplies, $24,300 for property taxes, and $1,110,000 for plant maintenance.

Required:

1. Determine the machine supplies and property taxes for May.
2. By using the high-low method, analyze Colorado’s plant maintenance cost and calculate the monthly fixed portion and the variable cost per machine hour.
3. Assume that present cost behavior patterns continue into future months. Estimate the total amount of manufacturing overhead the company can expect in September if 56,600 machine hours are worked.

For all requirements, round intermediate rate calculations to 2 decimal places and all other intermediate calculations to the nearest whole dollar. Round your final answers for "Variable plant maintenance" to 2 decimal places and all other calculations to the nearest whole dollar.

The following selected data were taken from the accounting records of Colorado Enterprises:

Month	Machine Hours				Manufacturing Overhead
May		47,500			$	904,000
June		60,600				1,136,000
July		71,000				1,306,300
August		53,500				983,000

Manufacturing overhead consists of three different costs; (1) machine supplies (variable), (2) property taxes (fixed), and (3) plant maintenance (semivariable). July's overhead costs were $172,000 for machine supplies, $24,300 for property taxes, and $1,110,000 for plant maintenance.

Required:

1. Determine the machine supplies and property taxes for May.
2. By using the high-low method, analyze Colorado’s plant maintenance cost and calculate the monthly fixed portion and the variable cost per machine hour.
3. Assume that present cost behavior patterns continue into future months. Estimate the total amount of manufacturing overhead the company can expect in September if 56,600 machine hours are worked.

For all requirements, round intermediate rate calculations to 2 decimal places and all other intermediate calculations to the nearest whole dollar. Round your final answers for "Variable plant maintenance" to 2 decimal places and all other calculations to the nearest whole dollar.

	A. Machine supplies Property taxes B. Plant maintenance in May Variable plant maintenance per hour Fixed plant maintenance C. Manufacturing overhead

Answer 1