The Riverhawk Health System

at
Categories
Tags

 

 

The Riverhawk Health System has revenue sources from operations, donations, and interest income. The revenue from operations is primarily received for services. RHS groups its revenue first by cost center. Within each cost center, the services revenue is then grouped by payer.

Set up an Excel worksheet with individual columns across the top for six revenue sources (payers): Medicare, Medicaid, Other Public Programs, Patients, Commercial Insurance, and Managed Care Contracts.
Set up six vertical row items on your worksheet, numbered (1) through (6).
Certain situations concerning the Intensive Care Unit and the Laboratory 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). The six situations are as follows:
ICU stay billed to employee’s insurance program. (Hint: should this be in the cost center Intensive Care Unit or laboratory)
Lab test paid for by an individual.
Pathology work performed for the state.
ICU stay billed to member’s health plan.
ICU stay billed for Medicare beneficiary.
Series of allergy tests run for eligible Medicaid beneficiary.
Place an X in the column(s) that represent(s) the correct revenue source(s) for the item
Headings for your worksheet:

Medicare Medicaid Other Public Programs Patients Commercial Insurance Managed Care Contracts
(1)
(2)
(3)
(4)
(5)
(6)
Save Excel spreadsheet as first initial last name Revenue (example: a Student Revenue)

View the Rubric for details on how the assignment will be graded.

See Chapter 2 of the Finkler textbook for more information on how to use Excel.

ASSIGNMENT SUBMISSION
1. POWERED BY TINY The Riverhawk Health System has revenue sources from operations, donations, and interest income. The revenue from operations is primarily received for services. RHS groups its revenue first by cost center. Within each cost center, the services revenue is then grouped by payer.
1. Set up an Excel worksheet with individual columns across the top for six revenue sources (payers): Medicare, Medicaid, Other Public Programs, Patients, Commercial Insurance, and Managed Care Contracts.
2. Set up six vertical row items on your worksheet, numbered (1) through (6).
3. Certain situations concerning the Intensive Care Unit and the Laboratory 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). The six situations are as follows:
1.
1. ICU stay billed to employee’s insurance program. (hint: should this be in the cost center Intensive Care Unit or Laboratory)
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.
4. Place an X in the column(s) that represent(s) the correct revenue source(s) for the item
Headings for your worksheet:
• Medicare Medicaid Other Public Programs Patients Commercial Insurance Managed Care Contracts
• (1)
• (2)
• (3)
• (4)
• (5)
• (6)
Save Excel spreadsheet as first initial last name Revenue (example: a Student Revenue)
Veiw the Rubric for details on how the assignment will be graded.
See Chapter 2 of the Finkler textbook for more information on how to use Excel.

Novice Competent Proficient
Column Set Up Points Range:0 (0.00%) – 10 (10.00%)
0 of the 6 columns are correct = 0 points. 1 of the 6 columns are correct = 5 points. 2 of the 6 columns are correct = 10 points Points Range:11 (11.00%) – 20 (20.00%)
3 of the 6 columns are correct = 15 points. 4 of the 6 columns are correct = 20 points Points Range:21 (21.00%) – 30 (30.00%)
5 of the 6 columns are correct = 25 points. All 6 columns are correct = 30 points
Row Set Up Points Range:0 (0.00%) – 10 (10.00%)
0 of the 6 row are correct = 0 points. 1 of the 6 row are correct = 5 points. 2 of the 6 row are correct = 10 points Points Range:11 (11.00%) – 20 (20.00%)
3 of the 6 rows are correct = 15 points. 4 of the 6 rows are correct = 20 points Points Range:21 (21.00%) – 30 (30.00%)
5 of the 6 row are correct = 25 points. All 6 rows are correct = 30 points
Answers to the 6 items Points Range:0 (0.00%) – 10 (10.00%)
0 of the 6 items are correctly identified with an X mark on the chart. 1 of the 6 items are correctly identified with an X mark on the chart. 2 of the 6 items are correctly identified with an X mark on the chart Points Range:11 (11.00%) – 20 (20.00%)
3 of the 6 items are correctly identified with an X mark on the chart. 4 of the 6 items are correctly identified with an X mark on the chart. 2 of the 6 items are correctly identified with an X mark on the chart Points Range:21 (21.00%) – 30 (30.00%)
5 of the 6 items are correctly identified with an X mark on the chart. All 6 items are correctly identified with an X mark on the chart
Formatting Points Range:0 (0.00%) – 3 (3.00%)
The table is missing two of the following: a title, guidelines, or appropriate font Points Range:4 (4.00%) – 7 (7.00%)
The table is missing one of the following: a title, guidelines, or appropriate font Points Range:6 (6.00%) – 10 (10.00%)
The table is properly formatted to show professional quality work which includes a title, gridlines, and font

 

 

 

 

Sample Solution

came to power in 1979 and represented for many, laissez-faire economics and individual self-determination (Steele, 2018). She believed in power of the market, utilizing it to restore the stagnant British economy and moving away from state provided services. In 1979, cuts resulted in reducing the standard rate of tax from 33% to 30%, the top rate from 83% to 60% and finally cutting public spending by 3% (Bolick, 1995). She reduced the amount of public spending, from 50% to 43%. Thatcher felt high taxes discouraged the incentive to work however, effects of tax cuts increased income inequality through as high earners saw ‘the top 10%- did far better, with their incomes increasing from the equivalent of £472.98 in 1979 to £694.83 in 1990’. The uneven distribution of wealth saw the poorest families receive the least. Reductions in public expenditure affected health, education and social services which created a knock-on effect with substantial loss of public sector jobs resulting in decreased spending on goods and services. Privatisation became Thatcher’s most important and long-lasting legacy. She revealed in her memoirs that it was crucial for ‘reversing the corrosive and corrupting effects of socialism’ Parker. In the 1980-90s, due to fiscal pressures, Thatcher’s conservative views on private ownership and public discontent with the current regime saw the privatisation of public owned entities. For example, the sale of just ‘over 50% of shares in BT and the sale of British Energy in 1996’ (Berrington, 1998). Other privatised industries included electricity, gas, British steel, public bus transportation and other public services. As a result, workforces declined as ‘employment in the electricity and gas industries was cut in half’(Edwards, 2017), problems arose in the regulation of private monopolies to prevent abuse of power, however improved ‘economic growth and improved living standards as privatised businesses cut costs, increased service quality’ (Edwards, 2017). Thatcher can be seen as the key instigator of the sweeping shift from traditional to ‘New Public Management’ initiated by public service reforms. NPM involved the adoption of private sector management ideas to improve structures and processes in the public sector. Thatcher who led the 1980s ‘New Right’ administrations, that put a ‘shrinking government and reduced taxation on the agenda’ (Ferlie, 2017). Thatcher also wanted to remove ‘inefficiency in the state bureaucracy and the deprivilege of the civil service’ as she concluded that the public sector was ‘wasteful, overbureaucratic and underperforming’ (Ferlie et al., 1996). Thatcher wanted to identify areas of waste and inefficiency in the government and ‘improve service quality and customer-orientated service’ (Pollitt, 1996) whilst reducin

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.
Hi, how can I help?