In: Accounting
Lacourse Inc.'s inspection costs are listed below:
Units Produced | Inspection Costs | |||||
January | 428 | $ | 6,126 | |||
February | 378 | $ | 5,637 | |||
March | 447 | $ | 6,341 | |||
April | 462 | $ | 6,479 | |||
May | 404 | $ | 5,887 | |||
June | 379 | $ | 5,640 | |||
July | 454 | $ | 6,406 | |||
August | 405 | $ | 5,900 | |||
Management believes that inspection cost is a mixed cost that depends on units produced.
Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:
S.NO | UNITS PRODUCED | INSPECTION COST | XY | X^2 |
X | Y | |||
1 | 428 | 6126 | 2621928 | 183184 |
2 | 378 | 5637 | 2130786 | 142884 |
3 | 447 | 6341 | 2834427 | 199809 |
4 | 462 | 6479 | 2993298 | 213444 |
5 | 404 | 5887 | 2378348 | 163216 |
6 | 379 | 5640 | 2137560 | 143641 |
7 | 454 | 6406 | 2908324 | 206116 |
8 | 405 | 5900 | 2389500 | 164025 |
TOTAL | 3357 | 48416 | 20394171 | 1416319 |
y = a+bx
y = total cost
b= variable cost
x = level of activity
b = (8 (20394171) - (3357) (48416) ) / (8 (1416319) - (3357)^2)
b = (163153368 – 162532512 ) / (11330552-11269449)
= 620856 / 61103
= 10.161
Total fixed cost (a) can then be computed by substituting the computed b
a = |
∑y – b∑x |
n |
a = |
48416 – (10.161)(3357) |
8 |
|
a = (48416 – 34110.48) / 8
a = 1788.19