Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. You have just been promoted to the Administrative Manager for Post Internal Medicine. Your predecessor left on a bad note and did not complete

image text in transcribed
image text in transcribed
6. You have just been promoted to the Administrative Manager for Post Internal Medicine. Your predecessor left on a bad note and did not complete the budgets in time. Submission is due in a week and it's up to you to complete the 2020 final budget and the 2021 draft budget. You are given a copy of 2019 actual, budget and variance. The V.P. states the service line budgets off of Actuals for the prior year. Based on the information below create the 2020 and 2021 budget. 2019 The office currently has 4 physicians and 5 clerical staff Assume for each year that: All staff are paid the same amount. . All physicians are paid the same amount Each physician generates the same amount of revenue each year. Base estimates off of the actual 2019 numbers 2020 At the tail end of 2019 the department recruited 2 new physicians. They will start Jan 1 2020. Luckily they thought ahead and have already enrolled them in insurance plans so they can bill day one. They also increased the clerical FTE count by 1 to support the new providers. Update your budget for 2020 Add one more staff. 2019 clerical staff receive 3% COLA. New person in 2020 is hired on at the 2019 rate +COLA so all staff are paid the same amount in 2020 Patient volume increases 20%: update your supply expense to reflect this. Affil-Miscellaneous Income stays the same Affil-Billing & Collection OH increases 2% each year 2021 If all goes to plan, you will have two physicians finishing their residency who will be hired into the office Jan 1 2021. They are expected to increase volume by 20%. Update salaries, malpractice and associated revenue. One of these physicians has a contract with an outside company to provide consult services. This is anticipated to bring in additional revenue of $20k for 2021. Due to space constraints with the new physicians you will be outsourcing the Lab and all associated fees. You also have to hire on 1 additional clerical staff member the same salary as the existing staff. Money is a bit tight this year so there will be no COLA. Update your budget for 2021. POST INTERNAL MEDICINE MONTHLY RECAP OF REVENUES & EXPENDITURES 2019 ANNUAL REVENUE AND EXPENSE BUDGET 2019 ANNUAL 2020 ledge 2021 Budget ACTUAL BUDGET VARIANCE S 1.658.2005 S 1.658,200 1.670,000 1,670,000 S S (11.800) (11 800) REVENUES 52100 IDX Cash Collection Total Net Patient Revenues Other Revenue 55130 Affil Miscellaneous Income Total Contracts and Other $ $ 60,000 60,000 $ S 63,337 63.337 S S (3.337) (337) Total Revenues S 1,718,200 $ 1,733,337 S (15,137) EXPENSES 60010 Salaries And Was Overtime 60050 Physician Salaries Tatal Faculty & Support Staff Salary 60020 $ 550,000 $ 447,000 $ 103.000 396 S S 396 $ 840,000 S 840,000 $ S 1,390,396 S 1.287,000 S 103.396 (2.166) (350) (1.900) 128 192 63000 Supplies - Laboratory 63030 Supplies - Medical 63080 Supplies - Surgical 63300 Rx - All Other Supplies - Hotel Services 64020 Supplies - Office 64510 Dietary 65000 Electricity 650SO Telephone 65505 Equipment Service Contracts 65510 Freight 65517 Software Maint and Support 65525 Maintenance And Repairs 65565 Purchases Services Linen 66000 Dues Postage Printing And Duplication Total Supplies and Expenses $ $ $ $ $ $ s $ $ S $ $ S $ $ $ $ 6,234 $ 8.000 $ $400 S 10,500 S 780 $ 990 $ 574 3.500 $ 1.250 $ 6195 3995 5,400 $ 200 $ 1.170S 1.50$ $ 500 $ 52,124 $ 8,400 $ 8,350 S 7300 S 10.500 5 6525 798 $ 475 $ 8,500 $ 1.164 5 647 S 4255 5,028 5 171 5 693 $ 1.$ 576 S 55,236 $ (28) (26) 372 29 477 0 (76) 3.162) 040 Affil-Contra Insurance Total Malpractice $ $ 45,000 45,000 $ $ 45,000 45,000 $ $ 10 Affil-Billing & Collection OH Total Overhead and Billing $ $ 72.817 72,817 S S 80,628 5 80,628 $ 7811 7,811 Total Expenses S 1.560.336 S 1,467,914 $ 108,044 evenues / Over (Expenditures) $ 157,864 S 265,424 S (123,182)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Modeling Using Excel And VBA

Authors: Chandan Sengupta

1st Edition

0471267686, 978-0471267683

More Books

Students also viewed these Finance questions

Question

What are their resources?

Answered: 1 week ago

Question

What impediments deal with customers?

Answered: 1 week ago