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.
Business Studies
Customer 453413, April 26th, 2020
Film & Theater studies
Fairly articulated.
Customer 462929, May 4th, 2022
Business Studies
Great work again!
Customer 454345, May 10th, 2020
Keep it up
Customer 452441, April 26th, 2022
MGMT 221 Introduction to Management Information System
Great job!
Customer 457731, February 25th, 2022
Critical Reading and Writing
Excellent responses. Be keen on Grammar.
Customer 460653, April 4th, 2022
Very good job
Customer 456821, May 11th, 2022
Project Management
I gave a lower rating on the service because, a notification from the support team went out but it did not come to my email address. Had I not looked earlier on the website, then I would have been penalized for not turning in my paper on time. On my profile, I have a phone# and I also have an email address. Please set up a system to text or email new messages or notifications from the writer or support team. This will ensure that the order is processed in a timely manner. With the new and upcoming technology, this seems like it should be an easy fix to have a tool built in the website to email or text notifications of changes to orders. This is no reflection to the support team. I see this as a system issue and not a support team issue.
Customer 463323, September 26th, 2022
This week's order was phenomenally written and I did not have to request any revisions! Thank you to the writer for following all instructions as written and writing a phenomenal discussion paper.
Customer 452455, February 3rd, 2023
Great content. Thoroughly read all instructions.
Customer 462281, April 6th, 2022
good job
Customer 456821, February 28th, 2022
Excellent response.
Customer 462281, April 20th, 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