Here, the high level of activity was in the month of June when they treated 1460 patients and the low level of activity was in the month of March when they treated 1010 patients
| Total treatment cost | Number of patients | |
| High level of activity | $4,232 | 1460 |
| Less : Low level of activity | ( $3,467 ) | ( 1010 ) |
| Difference | $765 | 450 |
Variable cost per patient = Difference in total treatment cost / difference in number of patients = $765 / 450 patients = $1.7 per patient.
Now let us calculate fixed cost from the data of June month
Total treatment cost = Total variable cost + Total fixed cost
$4,232 = ( 1460 patients * $1.7 per patient ) + Total fixed cost
$4,232 = $2,482 + Total fixed cost
Total fixed cost = $1,750
Cost function, y = a + bx
where, y = total treatment cost, a = total fixed cost, b = variable cost per patient, x = number of patients
So, here the cost function will be, y = $1,750 + ( $1.7 * x )
Let us now calculate estimated total treatment cost when 1706 patients are treated in a month
y = $1,750 + ( $1.7 * 1706 patients )
y = $4,650.2
So, the estimated total treatment cost of treating 1706 patients in a month is $4,650.2
If you have any doubts, please ask in the comments section.
Falls Creek Community Health Clinic uses the high-low method to analyze cost behavior and has determined...
Jungemann Company, which uses the high-low method to analyze
cost behavior, has determined that machine hours best predict the
company's total utilities cost. The company's cost and machine
hour usage data for the first six months of the year
follow:
Jungemann Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow:...
Coughlin Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow: (Click the icon to view the data.) Requirements Using the high-low method, answer the following questions 1. What is the variable utilities cost per machine hour? 2. What is the fixed cost of utilities each month? 3. If Coughlin Company...
Question Help Tran Company, which uses the high-low method to analyze cost behaviour, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow Click the icon to view the data.) Requirements Using the high-low method, answer the following questions: 1. What is the variable utilities cost per machine hour? 2. What is the fixed cost of utilities each month? 3. If...
Coughlin Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utlities cost. The company's cost and machine hour usage data for the first six months of the year follow (Click the icon to view the data.) Requirements Using the high-low method, answer the following questions: 1. What is the variable utilities cost per machine hour? 2. What is the fixed cost of utilities each month? 3. If Coughlin Company...
E6-23 (similar to) Chen Company, which uses the High-Low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow: Month Machine Hours January 1,090 Total Costs $ 3,400 $ 3,760 $ 3,532 February 1,190 March 1,080 April $3,760 1,260 May $ 4,400 1,380 June $ 4,192 1,480 Requirements: Using the High-Low method to predict the total...
Coughlin Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow: (Click the icon to view the data.) i Data Table Requirements Using the high-low method, answer the following questions: 1. What is the variable utilities cost per machine hour? 2. What is the fixed cost of utilities each month? 3....
1. ker Corporation uses the high-low method to analyze cost behavior. You as controller have determined that machine hours best explain the company's utilities cost. The company's relevant range of activity varies from a low of 600 machine hours to a high of 1,100 machine hours, with the following data being available for the first six months of the year: Month Utilities Machine Hours January $8,700 800 February 8,360 720 March 8,950 810 April 9,360 920 May 9,625 950 June...