Brazilia Bus Tours has incurred the following bus maintenance costs during the recent tourist season. (The realis Brazil's national monetary unit. On the day of this exercise was written, the realwas equivalent in value to .5092 U.S. dollar.)
|
Month
|
Miles Traveled by Tour Buses
|
Maintenance Cost
|
|
November
|
12,750
|
17,100 real
|
|
December
|
15,900
|
17,400
|
|
January
|
19,050
|
17,550
|
|
February
|
22,500
|
18,000
|
|
March
|
30,000
|
18,750
|
|
April
|
12,000
|
16,500
|
Question:
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 32,000 miles traveled and the cost was 20,000 real.