In: Accounting
Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed "gross-ton miles," which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $530,900 224,000 February 591,900 250,000 March 418,300 162,000 April 567,500 242,000 May 476,000 195,000 June 610,200 263,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (Round to two decimal places.) $ per gross-ton mile Total fixed cost $
Variable cost= $ 1.90 per gross-ton mile
Total fixed cost= $ 110,500
Working
Cost | No. of activities | ||
A | High Level | $ 6,10,200.00 | 263000 |
B | Low Level | $ 4,18,300.00 | 162000 |
C=A-B | Difference | $ 1,91,900.00 | 101000 |
A | Cost difference | $ 1,91,900.00 | |
B | No. of Activities difference | 101000 | |
C=A/B | Variable cost per unit | $ 1.90 |
High Level | Low Level | ||
A | No. of activities | 263000 | 162000 |
B | Variable cost per unit | $ 1.90 | $ 1.90 |
C=AxB | Total Variable cost | $ 4,99,700.00 | $ 3,07,800.00 |
D | Total cost | $ 6,10,200.00 | $ 4,18,300.00 |
E=D-C | Total fixed cost | $ 1,10,500.00 | $ 1,10,500.00 |