You have five physician-practice clients for your World Outpatient clinic. Each physician practice sends you all of their clients.??? For the purposes of budgeting, we will assume the va
You have five physician-practice clients for your World Outpatient clinic. Each physician practice sends you all of their clients. For the purposes of budgeting, we will assume the varying amounts of listed gross revenue for each month a client sends patients to the clinic. Please note that each client starts with the clinic at different times during the year.
Complete the revenue part of the budget worksheet by calculating the monthly totals and totals for each client.
- The expenses are divided into labor and non-labor sections.
- For the labor expenses, you are given the needed information to calculate total individual and clinic labor costs. Use 2,080 as the number of hours a full-time employee works.
- For the non-labor expenses, you are given the total available to budget. Allocate those total dollars to each non-labor expense with the percentages your manager has provided.
- Note, in all cases, any calculations must be shown in the Excel file.
CFO Project Presentation
Scenario
You are the CFO of a hospital or health care organization assigned by the instructor. You are tasked with giving a comprehensive presentation to the local business community.
The purpose of the presentation is to provide you with a chance to concisely present your report on your assigned hospital’s financial and economic situation. The ‘fictional president’ of your hospital has given you precisely 6-8 minutes to present. You are expected to be inside that time frame. Anything shorter or longer will be penalized with a deduction of points. The use of visual aids is your decision. Your grade will be based on content, conciseness, and analysis of your hospital’s situation and opportunities. The instructor will provide a template to help organize the presentation – along with a grading rubric. For an online version of the course, you will submit your presentation with a Powerpoint file and audio voice-over. (Instructions below.)
Objectives
- Demonstrate a basic understanding and application of health care financial statements and ratios.
- Provide concise verbal presentation
Parts of the report
- Introduction
- Histories of 2 leaders of the organization (ex. CEO, CFO, Board Chair, etc.)
- Listing and analysis of ONLY 5 financial ratios. Choose the five you want to use.
- A conclusion that provides your outlook for the next 5-10 years for your hospital or healthcare organization.
Sheet1
Stocker & Associates World Outpatient Clinic | |||||||||||||
Summer 2018 | |||||||||||||
January | February | March | April | May | June | July | August | September | October | November | December | Total | |
Revenues | |||||||||||||
Client 1 | |||||||||||||
Client 2 | |||||||||||||
Client 3 | |||||||||||||
Client 4 | |||||||||||||
Client 5 | |||||||||||||
TOTALS | |||||||||||||
Client Monthly Revenue Estimate | Start Month | ||||||||||||
Client 1 | $15,000 | January | |||||||||||
Client 2 | $18,000 | January | |||||||||||
Client 3 | $22,000 | April | |||||||||||
Client 4 | $28,000 | June | |||||||||||
Client 5 | $31,000 | September | |||||||||||
Labor Expenses | Hourly Wage | Status | # of positions | TOTAL ANNUAL COST | |||||||||
Staff Positions | |||||||||||||
Intake Coordinator | $ 12.50 | Fulltime | 2 | ||||||||||
Intake Assistant | $ 10.00 | Halftime | 1 | ||||||||||
Physicians | $ 68.00 | Fulltime | 2 | ||||||||||
Advanced Nurse Practitioner | $ 46.00 | Fulltime | 1 | ||||||||||
Registered Nurse | $ 28.00 | Fulltime | 3.5 | ||||||||||
Laboratory Scientist | $ 31.00 | Fulltime | 2 | ||||||||||
Radiology Technician | $ 21.00 | Fulltime | 1 | ||||||||||
TOTAL LABOR EXPENSE | |||||||||||||
Non-labor Operating Expenses | |||||||||||||
Fringe Benefits | 35.0% | ||||||||||||
Equipment leases | 6.5% | ||||||||||||
Materials and Supplies | 16.0% | ||||||||||||
Travel | 9.5% | ||||||||||||
Marketing | 33.0% | ||||||||||||
TOTAL Non-labor Expenses | $655,000 | 100.0% | |||||||||||
TOTAL Labor Expenses | |||||||||||||
TOTAL EXPENSES | |||||||||||||
NET Revenue Projected for Budget Year | |||||||||||||
Ratios | |||||||||||||
Salary as percent of total expense | |||||||||||||
Salary as percent of total revenue | |||||||||||||
Percentage of labor expense from physician and advanced nurse practitioner |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.