Based on the information in the Budget Information for Year One document, complete theExcel spreadsheetthat demonstrates the following changes in income:

• There will be a 2% decrease in volume (volume = number of patients) annually over the next five years.
• Medical and office supplies will increase 2.5% annually.
• Salaries and benefit costs will increase 5% annually.
• Continuing education costs will remain steady each year.
• Overhead expenses will remain steady each year.

Once you have completed the Excel document, determine how the changes above will affect the annual income.

Next, address the following:

• Based on your calculations, evaluate the proposed budget and determine if the organization will be able to sustain itself for five years. Provide a rationale for your answer.
• Considering there is a significant loss in volume of patients each year, as the practice manager, you will need to make recommendations on where to cut expenditures. Include at least three recommendations for cutting expenses as well as in which year you believe the cuts will be most effective. Explain your rationale.