Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Case 4 Budgeting and Variance Analysis It is January 2 nd and you are just finishing up your 3 rd month as the new Administrator

Case 4

Budgeting and Variance Analysis

It is January 2nd and you are just finishing up your 3rd month as the new Administrator of MedLab Medical Office, LLC.After spending your first few weeks getting settled and meeting with the providers and staff, you turned your attention to the practice's financials.You had a very difficult time finding any budget or budget tracking information, which may be why the person who was in this position for the past two years was let go.Determined to put your financial skills to work, you scoured the office files and found a handwritten notebook titled Budget.In the notebook you found the following information for the current year:

24,000 patient visits per year

Payer mix:

o58% Private insurance

o35% Medicare

o6% Medicaid

o1% Self-pay

Average reimbursement per visit by payer:

o$65 Private insurance

o$53 Medicare

o$32 Medicaid

o$50 Self-pay

Annual salaries:

oPhysicians: $380,000

oNurses: $145,000

oLaboratory Technician: $75,000

oAdministrator: $80,000

oSupport Staff: $40,000

Employee benefits rate: 26%

Rent: $96,000/year

Utilities: $12,000/year

General overhead: $45,000/year

Per patient costs:

oMedical supplies: $7.00

oOffice supplies: $1.50

1.Using information you found in the notebook, develop a budget for the current year in an Excel file.Use formulas for calculations whenever possible. [10 points]

Since you got back from the holiday break, you have been analyzing actual data for last year.You found actual data for (now) last year:

17,886 patient visits per year

Payer mix:

o56% Private insurance

o34% Medicare

o10% Medicaid

o2% Self-pay (after adjusting for patients who did not pay)

Average reimbursement per visit by payer:

o$63 Private insurance

o$52 Medicare

o$32 Medicaid

o$24 Self-pay

Annual salaries:

oPhysicians: $379,110

oNurses: $153,733

oLaboratory Technician: $72,225

oAdministrator: $75,533

oSupport Staff: $40,000

Employee benefits rate: 23.5%

Rent: $102,683/year

Utilities: $12,835/year

General overhead: $45,000/year

Per patient costs:

oMedical supplies: $8.25

oOffice supplies: $2.25

2.Develop the actual P&L for last year in your Excel file.Use formulas for calculations whenever possible. [10 points]

3.Conduct a budget variance analysis in your Excel file.Be sure to conduct your analysis on number of patients by payer and on each component of your budget and actual P&L.Use formulas for calculations whenever possible.What did your variance analysis tell you?Summarize the overall performance of the practice. [50 points]

4.Develop a forecasted P&L for next year in your Excel file, making assumptions for each of the revenue and expense lines.Use formulas for calculations whenever possible. [20 points]

5.What recommendations are you going to make to the owners of the clinic? [10 points]

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

Multinational Financial Management

Authors: Alan C Shapiro, Paul Hanouna

11th Edition

1119559901, 9781119559900

More Books

Students also viewed these Finance questions

Question

2. Ask questions, listen rather than attempt to persuade.

Answered: 1 week ago