HSA 525 Complete Course

HSA 525 Week 2 Assignment,Assignment

Exercise 4–1: Contractual Allowances Assignment Exercise 4–1: Contractual Allowances Physician Office Revenue for Visit Code 99214 has a full established rate of $72.00. Of ten different payers, there are nine different contracted rates, as follows: Contracted Payer Rate FHP $35.70 HPHP 58.85 MC 54.90 UND 60.40 CCN 70.20 MO 70.75 CGN 10.00 PRU 54.90 PHCS 50.00 ANA 45.00 Rates for illustration only. Required 1. Set up a worksheet with four columns: Payer, Full Rate, Contracted Rate, and Contractual Allowance. 2. For each payer, enter the full rate and the contracted rate. 3. For each payer, compute the contractual allowance. The first payer has been computed below: Full Contracted Contractual Payer Rate (less) Rate = Allowance FHP $72.00 $35.70 $36.30

Assignment Exercise 4–2: Revenue Sources and Grouping Revenue The Metropolis Health System has revenue sources from operations, donations, and interest income. The revenue from operations is primarily received for services. MHS groups its rev-enue first by cost center. Within each cost center the services revenue is then grouped by payer. Required 1. Set up a worksheet with individual columns across the top for six revenue sources (pay-ers): Medicare, Medicaid, Other Public Programs, Patients, Commercial Insurance, and Managed Care Contracts. 2. Certain situations concerning the Intensive Care Unit and the Laboratory are described below. Set up six vertical line items on your worksheet, numbered (1) through (6). Six situa-tions are described below. For each of the six situations, indicate its number (1 through 6) and enter the appropriate cost center (either Intensive Care Unit or Laboratory). Then place an X in the column(s) that represents the correct revenue source(s) for the item. The six situations are as follows: (1) ICU stay billed to employee’s insurance program. (2) Lab test paid for by an individual. (3) Pathology work performed for the state. (4) ICU stay billed to member’s health plan. (5) ICU stay billed for Medicare beneficiary. (6) Series of allergy tests run for eligible Medicaid beneficiary.

Assignment Exercise 5–1: Grouping Expenses by Cost Center The Metropolis Health System’s Rehabilitation and Wellness Center offers outpatient therapy and return-to-work services plus cardiac and pulmonary rehabilitation to get people back to a normal way of living. The Rehabilitation and Wellness Center expenses include the following: • Nursing Salaries • Physical Therapist Supplies • Physical Therapist Salaries • Occupational Therapist Supplies • Occupational Therapist Salaries • Cardiac Rehab Supplies • Cardiac Rehab Salaries • Pulmonary Rehab Supplies • Pulmonary Rehab Salaries • Training Supplies • Patient Education Coordinator Salary • Clerical Office Supplies • Nursing Supplies • Employee Education Required 1. Decide how many cost centers should be used for the above expenses at the Center. 2. Set up a worksheet with individual columns across the top for the cost centers you have chosen. 3. For each of the expenses listed above, indicate to which of your cost centers it should be assigned.

http://hwacer.com/Tutorial/hsa-525-complete-course/

Assignment Exercise 5–2 Required Find a listing of expenses by diagnosis or by procedure. The source of the list can be internal (within a health care facility of some type) or external (such as a published article, report, or survey). Comment upon whether you believe the expense grouping used is appropriate. Would you have grouped the expenses in another way?

HSA 525 Week 3 Assignment

Solution 6.1

6.2

7.1

7.2

http://hwacer.com/Tutorial/hsa-525-complete-course/

HSA 525 Week 4 complete homework

Assignment 1: Financial Statement Analysis

Due Week 4 and worth 200 points

Select one (1) of the following publically traded health care organizations: Universal Health Services (NYSE: UHS) or Health Management Associates (NYSE: HMA).

Suppose you are a newly appointed CFO of your chosen health care organization. One of your first tasks is to conduct an internal financial analysis of the organization. Conduct a brief financial analysis and review of the chosen company’s financial statements for at least three (3) consecutive years. After conducting the analysis, interpret the data contained within the statements.

Write a three to four (3-4) page paper in which you:

1. Based on your review of the financial statements, suggest a key insight about the financial health of the company. Speculate on the likely reaction to the financial statements from various stakeholder groups (employee, investors, shareholders). Provide support for your rationale.

2. Identify the current industry trend that has the most significant impact on your chosen organization’s financial performance. Indicate the trend’s impact on the financial performance of the organization. As the CFO, suggest at least one (1) way that you might minimize the impact of the trend on the organization.

3. As the CFO, suggest one (1) key strategy that you might use in order to improve the financial performance of the organization. Recommend an approach to implement the suggested strategy. Provide support for your recommendation.

4. Use at least four (4) quality academic resources. Note: Wikipedia and other Websites do not qualify as academic resources.

Your assignment must follow these formatting requirements:

  Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

  Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. 
The specific course learning outcomes associated with this assignment are:

  Evaluate the financial statements and the financial position of health care institutions.

  Analyze the role of important financial reporting statements – income statement, balance sheet, and statement of cash flows – and explain how they relate to one another and to the underlying sources of data.

  Use technology and information resources to research issues in health financial management.

  Write clearly and concisely about health financial management using proper writing mechanics.

Solution 8.1-to-8.5

Solution 9.1-9.2

Week 4 analysis

HSA 525 Week 8,

CHAPTER 18 ~ignment Exercise 18-1: Estimate of Loss You are the practice manager for a four-physician office. You arrive on Monday morning to find the entire office suite flooded from overhead sprinklers that malfunctioned over the weekend. Water stands ankle-deep everywhere. The computers are fried and the contents of all the filing cabinets are soaked. Your own office, where most of the records were stored, has the worst damage. The practice carries valuable papers insurance coverage for an amount up to $250,000. It is your responsibility to prepare an estimate of the financial loss so that a claim can be filed with the insurance company. How would you go about it? What would your summary of the losses look like? ~gnment Exercise 18-2: Estimate of Replacement Cost The landlord carries contents insurance that should cover the damage to the furnishings, equipment, and to the computers, and the insurance company adjuster will come tomorrow to assess the furnishings and equipment damage. However, your boss is sure that the insurance settlement will not cover replacement costs. Consequently, you have been instructed to prepare an estimate of what has been lost and/ or damaged plus an estimate of what the replacement cost might be. How would you go about it? What would your summary of these losses look like? ~signment Exercise 18-3: Benchmarking Review the chapter text about benchmarking. Required 1. Select either the MHS case study in Chapter 25 or one of the organizations represented by a mini-case study in Chapters 27, 28, or 29. 2. Prepare a list of measures that could be benchmarked for this organization. Comment on why these items are important for benchmarking purposes. 3. Find another example of benchmarking for a healthcare organization. The example can be an organization report or it can be taken from a published source such as a journal article. Assignment Exercise 18-4: Pareto Rule Review the chapter text about the Pareto rule and examine Figure 18-4. Note that the text says Pareto diagrams are often drawn to reflect before and after results. Assume that Figure 18-4 is the before diagram for the Billing department. Further assume that the after results are as follows:

Assignment Exercise 17-1: Variance Analysis Greenview Hospital operated at 120% of normal capacity in two of its departments during the year. It operated 120% times 20,000 normal capacity direct labor nursing hours in routine services and it operated 120% times 20,000 normal capacity equipment hours in the laboratory. The lab allocates overhead by measuring minutes and hours the equipment is used; thus equipment hours. Assumptions: For Routine Services Nursing: • 20,000 hours X 120% = 24,000 direct labor nursing hours. • Budgeted Overhead at 24,000 hours = $42,000 fixed plus $6,000 variable = $48,000 total. • Actual Overhead at 24,000 hours = $42,000 fixed plus $7,000 variable = $49,000 total. • Applied Overhead for 24,000 hours at $2.35 = $56,400. For Laboratory: • 20,000 hours X 120% = 24,000 equipment hours. • Budgeted Overhead at 24,000 hours = $59,600 fixed plus $11,400 variable = $71,000 total. • Actual Overhead at 24,000 hours = $59,600 fixed plus $11,600 variable = $71,200 total. • Applied Overhead for 24,000 hours at $3.455 = $82,920. Required 1. Set up a worksheet for applied overhead costs and volume variance with a column for Routine Services Nursing and a second column for Laboratory. 2. Set up a worksheet for actual overhead costs and budget variance with a column for Routine Services Nursing and a second column for Laboratory. 3. Set up a worksheet for volume variance and budget variance totaling net variance with a column for Routine Services Nursing and a second column for Laboratory. 4. Insert input data from Assumptions. 5. Complete computations for all three worksheets. Example 17B Reviewthe "SensitivityAnalysisOverview" section and Figure 17-5in Chapter 17. Chapter 17 395 !f..Assignment Exercise 17-2: Three-Level Revenue Forecast Three eye-ear-nose-and-throat physicians decide to hire an experienced audiologist in order to add a new service line to their practice. * They ask the practice manager to prepare a three-level volume forecast as a first step in their decision-making. Assumptions: for the base level (most likely) revenue forecast, assume $200 per procedure times four procedures per day times five days equals 20 procedures per week times 50 weeks per year equals 1,000 potential procedures per year. For the best case revenue forecast, assume an increase in volume of one procedure per day average, for an annual increase of 250 procedures (5 days per week times 50 weeks equals 250). (The best case is if the practice gains a particular managed care contract.) For the worst case revenue forecast, assume a decrease in volume of two procedures per day average, for an annual decrease of 500 procedures. (The worst case is if the practice loses a major payer.) *Audiologists were designated as "eligible for physician and other prescriber incentives" as discussed in Chapter 20. Thus the new service line was a logical move. Required Using the above assumptions, prepare a three-level forecast similar to the example in Figure 17-5 and document your calculations. Practice Exercise 17-11 Closely study the chapter text concerning target operating income. The necessary inputs for target operating income include the following: • Desired (target) operating income amount = $20,000 • Unit price for sales = $500 • Variable cost per unit = $300 • Total fixed cost = $10,000 Compute the required revenue to achieve the target operating income and compute a contribution income statement to prove the totals. -psSignment Exercise 17-3: Target Operating Income Acme Medical Supply Company desires a target operating income amount of $100,000, with assumption inputs as follows: • Desired (target) operating income amount = $100,000 • Unit price for sales = $80 • Variable cost per unit = $60 • Total fixed cost = $60,000 Compute the required revenue to achieve the target operating income and compute a contribution income statement to prove the total

Assignment Exercises 17-1, 17-2, and 17-3 on page 395 Assignment Exercises 18-1, 18-2, and 18-3 on pages 396 through 397

Required Resources Baker, J. (2011.) Healthcare finance: Basic tools for nonfinancial managers (3rd ed.). Sudbury, MA: Jones and Bartlett

HSA 525 Week 6,

SOLUTION 14-2, 14-3

Solutions 13-3,13-4.1,13-4.2

HSA 525 Week_6_Assignment 2

HSA 525 Week 5

solution 10-1,10-2,10-3

11.1,11.2,11.3

12.1,12.2,12.3

HSA 525 WEEK 7 HOMEWORK,

Assignment Exercises 15-1, 15-2, 15-3, and 15-4 on pages 389 through 392
Assignment Exercises 16-1 on page 393

Required Resources
Baker, J. (2011.) Healthcare finance: Basic tools for nonfinancial managers (3rd ed.). Sudbury, MA: Jones and Bartlett.

HSA 525 WEEK 7 HOMEWORK

HSA 525 WEEK 9 HOMEWORK

PRODUCT DESCRIPTION

• Assignment Exercises 20-1 on pages 503 through 504
• Assignment Exercises 21-1, 21-2, and 21-3 on pages 504 through 506

HSA 525 Week 9 Assignment 3 – Post-Merger Analysis – Strayer Latest

In today’s uncertain economic and regulatory environment for the health services industry, many organizations may be presented with merger and acquisition opportunities to gain market share and drive financial and operational efficiencies. Given the current state of this market segment:
Write a five to six (5-6) page paper in which you:
1. Suggest the key financial drivers that most likely will cause health care organizations to merge. Provide support for your rationale.
2. Assuming that two (2) health care organizations have merged. Determine the evaluation criteria that a financial analyst would use to evaluate the financial performance of the organization post-merger, and identify the determinants that the analyst would use to decide whether or not the merger generated favorable financial results for the organization. Provide support for your evaluation.
3. Determine the key factors that will drive the financial planning process for most organizations in the post-merger phase, and examine the related impact to the organization process. Provide support for your rationale.
4. Create an argument to assert that the financial planning process is of high value to a health care organization. Provide support for your argument.
5. Predict the financial stability of the health care industry over the next five (5) years. Provide support for your prediction.
6. Use at least three (3) quality academic resources. Note: Wikipedia and other Websites do not qualify as academic resources.

HSA 525 Chapter 10 Homework Assignment Exercises

• Assignment Exercises 22-1 on page 400 
• Assignment Exercises 23-1, 23-2, and 23-3 on pages 400 through 402