In: Accounting
Kuwait Dental Clinic has incurred the following overhead costs during the past year.
Month |
Number of Dental tests |
Overhead costs (Y) |
Month |
Number of Dental tests |
Overhead costs (Y) |
January |
9,800 |
173,500 |
July |
13,000 |
190,200 |
February |
6,000 |
155,200 |
August |
9,500 |
171,900 |
March |
6,800 |
169,100 |
September |
9,500 |
173,400 |
April |
7,500 |
170,400 |
October |
8,700 |
170,800 |
May |
9,200 |
172,300 |
November |
14,000 |
195,200 |
June |
10,200 |
175,900 |
December |
13,500 |
198,800 |
Required: Use the high-low method,
please make sure to solve all parts clearly and it's correct 100%
Answer A: Calulation of Variable overhead costs per one test:-
As per High Low Method | ||||||
Variable Cost per unit | = | Highest Activity Cost - Lowest Activity Cost | ||||
Highest Dental Tests - Lowest Dental Tests | ||||||
= | 198800 - 155200 | |||||
14000 - 6000 | ||||||
= | 43600 | |||||
8,000 | ||||||
Variable Cost per one test | = | 5 | ||||
Answer B: Calulation of Total Fixed overhead costs of the clinic
= Total Overhead Cost (-) Total Variable Overhead Cost
= 2,116,700 {Refer Note 1} (-) 588,500 {Refer Note 2}
= 1528200
Note 1 :
As given in the question | ||
Month | Number of Dental Tests | Total Overhead Costs |
January | 9800 | 173,500 |
February | 6000 | 155,200 |
March | 6800 | 169,100 |
April | 7500 | 170,400 |
May | 9200 | 172,300 |
June | 10200 | 175,900 |
July | 13000 | 190,200 |
August | 9500 | 171,900 |
September | 9500 | 173,400 |
October | 8700 | 170,800 |
November | 14000 | 195,200 |
December | 13500 | 198,800 |
117,700 | 2,116,700 |
Note 2 : Total Variable Overhead Cost = Number of tests *Variable Cost per test
= 5* 117,700
= 588,500
Answer C: Level of Clinic’s overhead costs that would be incurred during a month when 17,000 tests are taken is between $209,400 to $2201,00
Calculations :
Month | Number of Dental Tests | Variable Cost Per unit | Total Variable OverheadCosts | Total Fixed OverheadCosts | Total Overhead Costs | |
(A) | (B) | C= (A)*(B) | (D) | (C)+(D) | ||
January | 17000 | 5 | 85000 | 124,500 | 209,500 | |
February | 17000 | 5 | 85000 | 125,200 | 210,200 | |
March | 17000 | 5 | 85000 | 135,100 | 220,100 | Highest |
April | 17000 | 5 | 85000 | 132,900 | 217,900 | |
May | 17000 | 5 | 85000 | 126,300 | 211,300 | |
June | 17000 | 5 | 85000 | 124,900 | 209,900 | |
July | 17000 | 5 | 85000 | 125,200 | 210,200 | |
August | 17000 | 5 | 85000 | 124,400 | 209,400 | Lowest |
September | 17000 | 5 | 85000 | 125,900 | 210,900 | |
October | 17000 | 5 | 85000 | 127,300 | 212,300 | |
November | 17000 | 5 | 85000 | 125,200 | 210,200 | |
December | 17000 | 5 | 85000 | 131,300 | 216,300 |