Question

In: Finance

St. John’s Healthcare was established in 1917 by a group of philanthropists and concerned citizens with...

St. John’s Healthcare was established in 1917 by a group of philanthropists and concerned citizens with two goals in mind: To make healthcare services readily available to all people, regardless of race, color or creed, or their ability to pay, and to create a hospital where physicians would be allowed to practice medicine without fear of discrimination. More than 100 years later, it remained a not-forprofit hospital that provides vital health care services to all citizens. Through the years, they have steadily gained the expertise, resources and facilities necessary to serve an ever-expanding population of people in need.

St John’s includes 10 acute care and specialty (heart, children’s, orthopedic and rehab) hospitals, more than 200 physician practices and outpatient facilities, 10,000 co-workers and more than 500 Clinic physicians in Kansa Kansas, Missouri and Louisiana.

St. John’s Virtual Care Center is dedicated to care outside its own walls, monitoring patients 24/7/365 across the country, using high-speed data and video connections and medically intervening when and where patients need it with a comprehensive team approach.

St. John’s Healthcare’s ten outpatient diagnostic centers provide convenient access to some of the most common outpatient services. Offering advanced technology for same-day screening and diagnosis.

Much has been written about the impact that healthcare industry reform is having on hospitals and health systems. And with the challenge of reduced reimbursements looming, Finance teams understand that realizing the bottom-line benefits of cost containment and process improvement initiatives is becoming a business imperative. However, as organizations critically evaluate their financial management capabilities, many realize they have ineffective approaches designed around antiquated tools that aren’t up to the task.

In addition, hospitals have seen their prices growing at a slower rate than inflation. Revenues from private insurance have not fully offset the reductions in Medicare payments stemming from the Affordable Care Act and federal budget sequestration initiated in 2012. Many hospitals and health systems strove to gain market share at the expense of competitors by deeply discounting their rates for new “narrow network” health plans targeted at public and private health exchanges, enrollments from which have far underperformed expectations.

Mr. John Smith, CFO of the St. John’s Healthcare system is concerned about the future of St. John’s financial stability with all the recent changes including ACA and sequestration cut in 2012. Although financially System is doing well but they have fallen short of budgeted results. The main cause of the variance has been organizations’ lack of discipline in managing the size of their workforces, which account for roughly half of all hospital expenses. While budget variance inherently looks at past performance, the insights gathered provide guidance for future decisions.

He knows when done effectively, variance reporting can provide each Manager visibility and reasons for the variance between actual and budgeted performance. Budget variance is the difference between budgeted and actual expenses and revenue. Budget variance provides a quick picture of how an entity or a department is performing in comparison to your budget. For example, when actual revenue is higher than budgeted, it’s on a positive trend. When your actual expenses are more than what budgeted, it’s a clear indicator that there is a need to reduce spending unless it helped, or it will help to generate more revenue.

Mr. Smith has recently hired you as a Budget Manager and would like to develop ‘Department Budget variance Report’ to manage the financials better in the future. You have decided to use one of their Outpatient Diagnostic Center report for the last year and develop Budget-Variance report for that department. Your plan is that if CFO approves the new budget variance report then you will roll out that to all the departments in the System.

Actual FY 2017 Budget FY 2017
Gross Patient Service Revenue $        5,981,250 $        6,375,000
Contractual Allowance $        3,093,750 $        3,375,000
Charity Care $ 275,000 $ 225,000
Bad Debt $ 55,000 $ 75,000
Units of Service (Total # of Imaging Services) $ 13,750 $ 5,000
Net Patient Service Revenue $        2,557,500 $        2,700,000
(Net Revenue=Gross Rev-Contractual allowance-Charity care-Bad Debt)
Expenses: Variable
Salaries & Benefits-Diagnostic Imaging Tech $            618,292 $            540,000
Supplies $              59,813 $              60,000
Expenses: Fixed
Salaries & Benefits- Management $ 175,000 $ 165,000
Purchased Services $ 36,500 $ 22,500
Rent $ 240,000 $ 240,000
Utilities $ 156,000 $ 144,000
Maintenance $ 25,500 $ 28,000
Administrative $ 32,500 $ 30,000
Depreciation $ 600,000 $ 600,000
Additional Information on Diagnostic Imaging Techs
Productive Hours 14896 13750
Non-Productive Hours 1375 1250
Total Hours 16274 15000
Full Time Staff Work Hours 2080

Contractual Allowance is the difference between what hospitals bill and what they receive in payment from third party payers, including government programs; also known as contractual adjustment. St. John’s Healthcare offers Financial Assistance (Charity care) program that allows persons to receive medically necessary care at no charge or at a reduced charge when they meet financial eligibility requirements. This program provides financial relief to patients who qualify based on a comparison of their financial resources and/or income to the Federal Poverty Guidelines. 4 | P a g e Under existing GAAP, a healthcare service provider records revenue using the amount it bills for a service, even if it does not expect to collect that amount; the difference is recorded on the income statement as a provision for bad debt expense and helps calculate net revenue.

1. Using the information given above, develop a budget variance report for the FY 2017 for the Outpatient Diagnostic center.

2. Using the units of Service, calculate the revenue and expense for per unit of service for both actual and budget. Also, show the variance between actual and budget.

3. An FTE is the hours worked by one employee on a full-time basis. The concept is used to convert the hours worked by several part-time employees into the hours worked by full-time employees. On an annual basis, an FTE is considered to be 2,080 hours, which is calculated as: 8 hours per day. x 5 work days per week. Using this information, how many Technician FTEs were budgeted and worked in FY 2017?

4. What are some of the reasons for the budget variance for variable salaries and supplies?

Solutions

Expert Solution

Answer 1.

Based on the information given, we have developed a budget variance report for the FY 2017 for the Outpatient Diagnostic center as below.

Budget Variance : The budget variance is defined as the varinace / differences between the yearly planned budget value and the yearly actual budget value.

Budget Variance = Actual Budget - Planned Budget

We made the variance report by finding the differences between the last two columns in the table which shows the planned budget and the actual budget as below.

Heads Actual Budget
FY - 2017
Planned Budget
FY - 2017
Variance / Differences
FY-2017
Gross Patient Service Revenue $   5,981,250.00 $      6,375,000.00 $        (393,750)
Contractual Allowance $   3,093,750.00 $      3,375,000.00 $        (281,250)
Charity Care $     275,000.00 $        225,000.00 $            50,000
Bad Debt $       55,000.00 $          75,000.00 $          (20,000)
Units of Service (Total # of Imaging Services) $       13,750.00 $            5,000.00 $              8,750
Net Patient Service Revenue $   2,557,500.00 $      2,700,000.00 $        (142,500)
(Net Revenue=Gross Rev-Contractual allowance-Charity care-Bad Debt)
Expenses: Variable
Salaries & Benefits-Diagnostic Imaging Tech $     618,292.00 $        540,000.00 $            78,292
Supplies $       59,813.00 $          60,000.00 $                (187)
Expenses: Fixed
Salaries & Benefits- Management $     175,000.00 $        165,000.00 $            10,000
Purchased Services $       36,500.00 $          22,500.00 $            14,000
Rent $     240,000.00 $        240,000.00 $                     -  
Utilities $     156,000.00 $        144,000.00 $            12,000
Maintenance $       25,500.00 $          28,000.00 $            (2,500)
Administrative $       32,500.00 $          30,000.00 $              2,500
Depreciation $     600,000.00 $        600,000.00 $                     -  
Additional Information on Diagnostic Imaging Techs
Productive Hours 14896 13750 1146
Non-Productive Hours 1375 1250 125
Total Hours 16274 15000 1274
Full Time Staff Work Hours 2080 2080

Summary of Variances as below

Heads Actual Budget
FY - 2017
Planned Budget
FY - 2017
Variance / Differences
FY-2017
Net Patient Service Revenue $   2,557,500.00 $      2,700,000.00 $        (142,500)

--------------------------------------------------------------------------------------------------------------------------------------------

Heads Actual Budget
FY - 2017
Planned Budget
FY - 2017
Variance / Differences
FY-2017
Expenses: Variable
Salaries & Benefits-Diagnostic Imaging Tech $     618,292.00 $        540,000.00 $            78,292
Supplies $       59,813.00 $          60,000.00 $                (187)

-----------------------------------------------------------------------------------------------------------------------------------------

Heads Actual Budget
FY - 2017
Planned Budget
FY - 2017
Variance / Differences
FY-2017
Expenses: Fixed
Salaries & Benefits- Management $     175,000.00 $        165,000.00 $            10,000
Purchased Services $       36,500.00 $          22,500.00 $            14,000
Rent $     240,000.00 $        240,000.00 $                     -  
Utilities $     156,000.00 $        144,000.00 $            12,000
Maintenance $       25,500.00 $          28,000.00 $            (2,500)
Administrative $       32,500.00 $          30,000.00 $              2,500
Depreciation $     600,000.00 $        600,000.00 $                     -  
Total $            36,000

---------------------------------------------------------------------------------------------------------------------------------------------


Related Solutions

A group of concerned citizens in a local community is seeking to foster ventures that provide...
A group of concerned citizens in a local community is seeking to foster ventures that provide affordable places for both adults and children to socialize and build a stronger sense of community involvement. A local café that had long been a place where people gathered to talk or work over hot beverages and snacks was recently sold to a new owner who eliminated the late evening hours and put a one hour limit on laptop usage. The owner’s rationale was...
A local group of concerned citizens is dissatisfied with what it calls outrageous rate hikes by...
A local group of concerned citizens is dissatisfied with what it calls outrageous rate hikes by the electric utility company. Its solution is to have the elected city council operate an electric utility company instead of using the private one. Suppose the group gets its wish—the city council now runs the utility. Cite and discuss 2 externalities which might arise from this situation. Include a clear statemen of the primary activity from the city council. Keep this simple—ignore ownership transfer...
A study of the effectiveness of using extracts of St. John’s Wort in treating depression was...
A study of the effectiveness of using extracts of St. John’s Wort in treating depression was reported in the Journal of the American Medical Association in April, 2001. Patients were randomly divided into two groups. Of the 98 patients in group 1 who received St. John’s Wort, 14 were in remission at the end of the study period. Of the 102 patients in group 2 who received a placebo, 5 were in remission at the end of the study period....
Extracts of St. John’s Wort are widely used to treat depression. An article in the Journal...
Extracts of St. John’s Wort are widely used to treat depression. An article in the Journal of American Medical Association, April 2001, compared the efficacy of a standard extract of St. John’s Wort with a Placebo in 200 outpatients diagnosed with major depression. Patients were randomly assigned to two groups, each with 100 patients; one group received St. John’s Wort, and the other group received Placebo. After 8 weeks, 19 of the Placebo-treated patients showed improvements, whereas 27 of those...
The proportion of U.S. of citizens lacking healthcare insurance is known to be 25%. A healthcare...
The proportion of U.S. of citizens lacking healthcare insurance is known to be 25%. A healthcare economist suspects the rate of uninsured in Louisiana is higher than the national average. A survey was conducted of 200 Louisiana residents who were asked if they had healthcare insurance. Seventy-two responded that they did not have healthcare insurance. Based on the results of the survey, construct a 95% CI for p, the population proportion of Louisiana residents who do not have healthcare insurance....
Your clinical group has been asked to speak to a group of senior citizens on the...
Your clinical group has been asked to speak to a group of senior citizens on the topic of osteoporosis. Your group needs to develop an outline that will be reviewed by your instructor before the presentation takes place. Include teaching methods in your answers to the following questions. Question 1: Why should this particular audience be concerned with the prevention and development of osteoporosis? Question 2: What can you tell the group about raloxifene therapy?
Resource Usage, Special Order St. John’s Medical Center (SJMC) has five medical technicians who are responsible...
Resource Usage, Special Order St. John’s Medical Center (SJMC) has five medical technicians who are responsible for conducting cardiac catheterization testing in SJMC’s Cath Lab. Each technician is paid a salary of $36,000 and is capable of conducting 1,000 procedures per year. The cardiac catheterization equipment is one year old and was purchased for $250,000. It is expected to last five years. The equipment’s capacity is 25,000 procedures over its life. Depreciation is computed on a straight-line basis, with no...
It is found that 60% of American victims of healthcare fraud are senior citizens. Suppose that...
It is found that 60% of American victims of healthcare fraud are senior citizens. Suppose that I have randomly sampled 100 victims, and I am looking at the count, x, of how many of those victims were senior citizens. Find the following: a. the mean, variance and standard deviation of the distribution b. the probability that at least 50 are senior citizens c. the probability that 75 of them are senior citizens d. the probability that less than 55 of...
Hospital Administration and Management 1-Healthcare cost Many Americans are concerned with the topic of healthcare costs,...
Hospital Administration and Management 1-Healthcare cost Many Americans are concerned with the topic of healthcare costs, but not many understand the complexity of the topic. Write a two-page paper that addresses the following: Explain the factors that are driving healthcare costs and discuss the effects they have on both inpatient and outpatient facilities. Do some research on a hospital or healthcare setting where you would like to work. Outline their financial structure; are they a nonprofit, for-profit, or government facility?...
Outline the contents of an exercise education program for a group of healthy senior citizens.
Outline the contents of an exercise education program for a group of healthy senior citizens.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT