In: Accounting
The number of blood tests performed and the related costs over the last nine months in Brentline Hospital are given below:
Month | Blood Tests Performed |
Blood Test Costs |
||
January | 5,120 | $ | 67,900 | |
February | 5,400 | $ | 70,530 | |
March | 4,695 | $ | 61,932 | |
April | 4,290 | $ | 56,782 | |
May | 4,425 | $ | 59,041 | |
June | 3,600 | $ | 48,570 | |
July | 4,020 | $ | 53,212 | |
August | 5,315 | $ | 69,419 | |
September | 5,245 | $ | 69,025 | |
Required:
1. Using the high–low method, estimate the cost formula for blood tests. (Round cost per unit answer to 2 decimal places.)
2. Using the cost formula you derived above, what blood test costs would you expect to be incurred during a month in which 4,410 blood tests are performed? (Round your intermediate calculations answer to 2 decimal places.)
Solution: 1 | ||||||
CALCULATION OF VARIABLE COST PER UNIT AND FIXED COST PER UNIT | ||||||
Variable Cost per unit = High Level Total Cost - Low Level Total Cost / Change in Units Produced | ||||||
High level month = | February | |||||
Low Level Month = | June | |||||
Change in Blood Test Cost = | February Cost | - | June Cost | = | Difference | |
Change in Blood Test Cost = | $ 70,530 | - | $ 48,570 | = | $ 21,960 | |
Divide By | "/" By | |||||
Change in Blood Test Performed = | 5,400 | - | 3,600 | = | 1,800 | |
= | ||||||
Equals to Variable Cost Per unit | = | $ 12.20 | ||||
Calculation of Fxed Cost | ||||||
For the month of February | 70530 | |||||
Fixed Cost = | Total Cost | "-" | Variable Cost | |||
Fixed Cost = | $ 70,530 | "-" | $ 65,880.00 | |||
(5,400 X $ 12.20) | ||||||
Fixed Cost = | $ 4,650 | |||||
Answer = | ||||||
Variable Cost Per Blood Test = $ 12.20 | ||||||
Fixed Cost Element = 4,650 | ||||||
Y = a + bx | ||||||
A =Fixed Cost = | $ 4,650 | |||||
bx = Variable Cost Per Unit X No. of Blood Test Performed | $ 12.20 X Blood Test Performed | |||||
Solution: 2 | ||||||
Calcuation of Total cost for 4,410 blood test Performed | ||||||
Variable Cost = 4,410 X $ 12.20 | $ 53,802 | |||||
Add: Fixed Cost | $ 4,650 | |||||
Total Cost | $ 58,452 | |||||
Answer = Total Cost = $ 58,452 | ||||||