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:
Economic Debate- Progressive Income Tax For this Economic Debate, we are going to discuss the…
TOPIC: Going Global Discussion Thread 1 (initial post due Wednesday for full credit) Please note:…
Assignment Topic This week will culminate in the creation of a narrated PowerPoint to create…
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted…
you need to post your 2-page information flier to share with your Final Project Group.…
discussion: Discuss the methods used at your company to measure and ensure quality products and…