Use 2001 MSMG budget, see attached Summer Ville Family practice pdf, make the following adjustments and share results.

1. Patient Revenue is expected to grow by 3% due to the signing of a new managed care contract. What is the new dollar amount for patient revenue due to this increase?

2. The cost of expenses is expected to increase to 1.5%. What is the new dollar amount for the cost of expenses?

3. A new roof is needed which will cost $50,000. Prepare a new 12 month budget in Ms Excel, which reflects the 3% growth in patient revenue, the 1.5% in cost of expenses and the cost of the new roof.