Rio Bus Tours has incurred the following bus maintenance costs during the recent tourist season. (The real is Brazil’s national monetary unit. On the day this exercise was written, the real was equivalent in value to .269 U.S. dollar.) Month Miles Traveled by Tour Buses Cost November ............................8,500 ......................................................11,400 realDecember ..........................10,600 .......................................................11,600January ................................12,700 .......................................................11,700February .............................15,000 ........................................................12,000March ..................................20,000 .........................................................12,500April .......................................8,000 ...........................................................11,000 Required:1. Use the high-low method to estimate the variable cost per tour mile traveled and the fixed cost per month.2. Develop a formula to express the cost behavior exhibited by the company’s maintenance cost.3. Predict the level of maintenance cost that would be incurred during a month when 22,000 tour miles are driven. (Remember to express your answer in terms of the real.)4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: in March there were 21,000 miles traveled and the cost was 12,430 real.
Rio Bus Tours has incurred the following bus maintenance costs during the recent tourist season. (The real is Brazil’s national monetary unit. On the day this exercise was written, the real was equivalent in value to .269 U.S. dollar.)
Month Miles Traveled by Tour Buses Cost
November ............................8,500 ......................................................11,400 real
December ..........................10,600 .......................................................11,600
January ................................12,700 .......................................................11,700
February .............................15,000 ........................................................12,000
March ..................................20,000 .........................................................12,500
April .......................................8,000 ...........................................................11,000
Required:
1. Use the high-low method to estimate the variable cost per tour mile traveled and the fixed cost per month.
2. Develop a formula to express the cost behavior exhibited by the company’s maintenance cost.
3. Predict the level of maintenance cost that would be incurred during a month when 22,000 tour miles are driven. (Remember to express your answer in terms of the real.)
4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: in March there were 21,000 miles traveled and the cost was 12,430 real.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
