Document Name: Beaver Mountain Budget "What-If"(BMBUDGT2)
Software: Spreadsheet

Comments:

At Beaver Mountain Bike Tours we have been working on a yearly budget. Using the budget created earlier, we need you to make some "What-If" projections.

Information:

      Account               Monthly         Yearly
Income
     Tours                   6300             ?
     Rentals                 1700           _____
     Total Income              ?              ?

Expenses
     Rent                     400             ?
     Wages                   2900             ?
     Bike Repairs             200             ?
     Advertising               90             ?
     Utilities                145             ?
     Insurance                280             ?   
     Total Expenses            ?              ?

Net Income                     ?              ?

Instructions:

1. Load your BMBUDGET spreadsheet.
2. Change the title to "Beaver Mountain Bike Tours Budget—'What-If'"
3. Make the following changes: Rentals Income to 1700, Tours Income to 6300, Advertising to 90, Wages to 2900, and Insurance to 280.
4. Save as BMBUDGT2.
5. Make any adjustments as needed.
6. Preview, proofread, save, and print.