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.
Sheet3 Sheet2 Sheet1 INCOME Professional Fees Other Revenue Patient Refunds Refund Insurance Companies EXPENSES Salaries-Physician Owners Payroll Taxes-FICA Physician Payroll Taxes-FUTA Physcian Payroll Taxes-SUTA Physician Insurance-Physician Dues, Memberships, License Fees Meetings & Travel-Physician Meals & Entertainment-Physician Salaries-Primary Care Providers Salaries-Medical Support Salaries-Administrative Payroll Taxes-FICA Staff Payroll Taxes-FUTA Staff Payroll Taxes-SUTA Staff Insurance Staff Pension & Retirement Benefits Meetings & Travel-Staff Supplies-Drugs & Medications Supplies-Medical Supplies-Administrative Supplies-Medical Forms Supplies-Housekeeping/Maintenance Supplies-Computer Laboratory Services Rent-Buildings Utilities Rent/Lease-Furniture & Equipment Depreciation-Medical Equipment Depreciation-Laser Equipment Depreciation-Office Equipment Depreciation-Computer Equipment Property Taxes Maint/Repair-Furniture & Equipment Accounting Services Legal Services Recruitment Employee Development & Training Employee Relations Uniforms & Laundry General Liability Insurance-G&A Professional Liability Insurance Telephone/Internet Access Postage & Freight Printing Books & Subscriptions Marketing Amortization Bank Fees Interest Expense NET INCOME JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC TOTAL % Franchise Tax OPERATING BUDGET FOR 2001 Dividends Net Cash after Dividends Sample…
Attachments:
operating_bud….xls
family_practi….pdf