Flex Budget Analysis Assignment

Case 2 Flex budget analysis
The CFO of a Summit County Regional hospital has asked you as a hospital budget analyst to review the financials of a small substance counseling and services program. Summit County is a rural county, on the outskirts of a medium-sized Ohio city. The program, in its 5th year of existence, has never broken even. The program currently charges $78 per 30 minutes patient-visit. To prepare for the 2018 annual budget for this program, the 2017 annual results are shown:


Top Universities

The following program cost facts are as follows:
1. Materials and wages/salaries are variable based on the number of visits.
2. 92% of the admin/general expenses are fixed; the balance is variable based on the number of visits.
3. Variable overhead was equal to 22% of labor costs, with the balance fixed.
4. No change in cost behavior is expected, except it is expected that in 2017 variable overhead will increase to 25% of labor costs.
5. The CFO is under pressure to raise the hourly wages of hospital staff and projects a 3% across the board wage increase for 2018.

The manager of the program, under pressure to improve the bottom line performance of this program, has predicted that visits in 2018 will increase to an average of 1500 visits per month. The CFO is requiring that the program at a minimum will break even in 2018. She has asked for an analysis of the proposed 2018 budget and an estimate on the probability of the program reaching his required goal. She has also requested a recommendation on the continuance of this service, and the rationale for the recommendation.
In the prepared analysis, the CFO is asking for:

1. Prepare a contribution margin (CM) income statement for 2017. What is the CM% and the number of break-even visits for 2017?

Top Universities
2. The cost function for the program, based on the 2017 actual budget figures and 2018 expected cost changes listed above.
Hint: this is the linear cost function based on variable cost per patient visit and annual fixed.
3. A prepared contribution margin statement for 2018 using the program directors estimate of patient visits for 2018.
4. Prepare a CM flex-budget for 2018 for the following volume of patient visits:
a. No change in patient visits (use 2017 patient visits)
b. 17,500
c. 18,500
5. The CFO has asked you to provide a recommendation as to whether to continue this program or not. Provide a 400 to 500-word memo to include:
a. Your recommendation and why?
b. Discuss and support all relevant factors relating to your recommendation.
c. Besides the financial aspects of this analysis, what other relevant business-related factors and/or considerations will you present to the CFO for consideration?

Revenues: $78 16,800 patient-visits $1,310,400 Expenses: Wages/salaries, clinical Materials Wages/salaries, support staff Overhead Total direct cost of services Admin/general expenses Total expenses $215,000 $115,750 $156,500 $675,200 $1,162,450 $196,250 $1,358,700 Net operating profit/loss ($48,300)

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Human Resources Management (HRM)
Excellent combination.
Customer 462485, April 3rd, 2022
Always use Grammarly before submitting your papers.
Customer 460653, March 26th, 2022
Very good job
Customer 456821, May 11th, 2022
Business Studies
Great job!
Customer 462533, April 10th, 2022
Political science
Thank you
Customer 463987, March 30th, 2023
Thanks for the quick response to this assignment and great communication.
Customer 463875, April 29th, 2023
Heed to instructions and use Grammarly before submitting.
Customer 462827, April 7th, 2022
Thank you for following and revising all the comments. Keep it up
Customer 463249, February 28th, 2023
excellent work
Customer 456821, August 31st, 2022
Great job.
Customer 463301, November 14th, 2022
excellent job
Customer 456821, October 14th, 2022
Healthcare & Medical
Good work
Customer 463469, October 22nd, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat