Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

1 HLTH5193 Assignment 3: Case Study Weighting 45% in total Presentation Professional report (with academic references), plus a video presentation Context Location: The Light Square...

1 answer below »
1
HLTH5193 Assignment 3: Case Study

Weighting 45% in total
Presentation Professional report (with academic references), plus a video presentation
Context

Location: The Light Square General Hospital

Light Square General Hospital has appointed a new business manager, Ms Jones, to work
closely with staff in its Heart and Lung Division to develop and implement its 2023 budget.

While Ms Jones is an experienced business manager, this is her first appointment in the health
industry.

At the end of her first week on the job, Ms Jones discussed with the Chief Operating Officer
(COO) her experience in the hospital:

“To develop this budget, I will need to make some assumptions. However, I do not feel
comfortable doing so given the knowledge I have about how hospital divisions run.”

The COO suggested that it would be helpful for Ms Jones to work closely with the Clinical
Director of the Heart and Lung Division to start the engagement process with clinical staff.

The COO reminded Ms Jones that clinical staff had not been in favour of additional
administrative overheads (e.g. the appointment of the business manager) being incu
ed
during a period of budget restraint. The hospital’s executives hope that the appointment of
Ms Jones will demonstrate the benefit of establishing a close working relationship between
administrative and clinical staff. Consequently, the clinicians will have greater trust in the
udget process and participate in identifying cost-saving strategies in the coming years.
Failure could set relationships between the clinicians and corporate services back
considerably.
In previous years, the Administrative Department has determined divisional budgets without
the significant involvement of the clinical directors. Additionally, the budgets have only shown
the costs but not the income for providing services.
For this assignment, you are required to put yourself in Ms Jones’ shoes, developing various
udget models and providing a valuable report to hospital executives.
Ms Jones’ Approach

Having had a chance to reflect on the COO’s words, Ms Jones decided to create a draft budget
as a means of helping to show the potential of what the Administration Department could
support the clinicians to achieve – namely, a better understanding of the budget and how
they might control it.
2
Ms Jones has investigated the Division’s inpatient activity levels in the previous year and
decided to use it as a basis to form next year’s budget. The underlying information has been
included in the following table.
DRG Description
Average Length
of Stay (Days)
Last Year
Number of
Patients Last Year Inlier Weight
E62A Respiratory Infections and Inflammations, Major Complexity XXXXXXXXXX
E62B Respiratory Infections and Inflammations, Minor Complexity XXXXXXXXXX
E65A Chronic Obstructive Airways Disease, Major Complexity XXXXXXXXXX
E65B Chronic Obstructive Airways Disease, Minor Complexity XXXXXXXXXX
E66B Major Chest Trauma, Minor Complexity XXXXXXXXXX
F42B Circulatory Dsrds, Not Adm for AMI W Invasive Cardiac Inves Int, Minor Comp XXXXXXXXXX
F62B Heart Failure and Shock, Minor Complexity XXXXXXXXXX
F73B Syncope and Collapse, Minor Complexity XXXXXXXXXX
F74A Chest Pain, Major Complexity XXXXXXXXXX
F74B Chest Pain, Minor Complexity XXXXXXXXXX
F76B A
hythmia, Cardiac A
est and Conduction Disorders, Minor Complexity XXXXXXXXXX
In addition, she discovered the following services were used for each DRG with a particular
frequency:
DRG Description No. of X-Rays No. of Pathology Tests No. of Scripts
E62A Respiratory Infections and Inflammations, Major Complexity 4 5 3
E62B Respiratory Infections and Inflammations, Minor Complexity 2 3 5
E65A Chronic Obstructive Airways Disease, Major Complexity 2 5 4
E65B Chronic Obstructive Airways Disease, Minor Complexity 4 5 5
E66B Major Chest Trauma, Minor Complexity 2 5 4
F42B Circulatory Dsrds, Not Adm for AMI W Invasive Cardiac Inves Int, Minor Comp 2 6 5
F62B Heart Failure and Shock, Minor Complexity 4 5 2
F73B Syncope and Collapse, Minor Complexity 3 3 3
F74A Chest Pain, Major Complexity 3 5 4
F74B Chest Pain, Minor Complexity 2 2 1
F76B A
hythmia, Cardiac A
est and Conduction Disorders, Minor Complexity 1 4 4
3
Ms Jones has applied her costing assumptions and determined that it is appropriate to use an
average cost of service. From looking at the budgets for Hospital Stays, Imaging, Pathology
and Pharmacy, she has determined that the average cost for any patient for each DRG is:
DRG Description
Cost of
Stay per
Day ($)
Cost of
each X-
Ray ($)
Cost of each
Pathology
Test ($)
Cost of each
Script ($)
E62A Respiratory Infections and Inflammations, Major Complexity XXXXXXXXXX
E62B Respiratory Infections and Inflammations, Minor Complexity XXXXXXXXXX
E65A Chronic Obstructive Airways Disease, Major Complexity XXXXXXXXXX
E65B Chronic Obstructive Airways Disease, Minor Complexity XXXXXXXXXX
E66B Major Chest Trauma, Minor Complexity XXXXXXXXXX
F42B Circulatory Dsrds, Not Adm for AMI W Invasive Cardiac Inves Int, Minor Comp XXXXXXXXXX
F62B Heart Failure and Shock, Minor Complexity XXXXXXXXXX
F73B Syncope and Collapse, Minor Complexity XXXXXXXXXX
F74A Chest Pain, Major Complexity XXXXXXXXXX
F74B Chest Pain, Minor Complexity XXXXXXXXXX
F76B A
hythmia, Cardiac A
est and Conduction Disorders, Minor Complexity XXXXXXXXXX

While the Division may have more patients than covered by these DRGs, Ms Jones has
determined that the tables above were sufficient to build a budget, and she could commence
the engagement process with the Clinical Director of the Division. Looking at the Division’s
costs for the cu
ent year, Ms Jones believed that the fixed costs for next year can be
apportioned across the Division’s activities. She estimated that the fixed costs relating to the
above work should be $2,750,000.

Ms Jones understood that the national efficient price is $5,597 and that the inlier weight was
used to determine how much funding the hospital will get for any patient for a given DRG. Ms
Jones was assured that all patients would stay within the inlier range at the Light Square
General Hospital.

Task 1
Prepare a budget for the Heart and Lung Division based on the material made available to Ms
Jones and her assumptions. Provide a na
ative on the budget.

The budget does not need to be cash-flowed across the year but should be presented in a
manner that the Clinical Director will find easy to understand and helpful.

It should be prepared in Excel and use appropriate formulae wherever possible. (Note: you
can insert tables or graphs into a Word document for presentation purposes, but you should
still submit the Excel spreadsheet. This instruction applies to subsequent tasks in this
assignment that require computation).
4
When Ms Jones met the Clinical Director to discuss the draft budget, the Director was highly
concerned. She believed Ms Jones’s patient number assumptions were unrealistic. Based on
the trend of actual patient activity over the last three years, the Clinical Director believed a
30% increase in Chest Pain patients (DRGs F74A and F74B) would likely occur next year.

Task 2
Update the budget to reflect the change in forecasted patient activity.

Explain how the increased activity would affect the bottom line of the Division’s budget.

Is it essential to engage clinical staff when preparing budgets? Describe your reasons.

Ms Jones believed she could convince the Clinical Director that there were means to reduce
costs and improve the bottom line. She felt that lowering the cost of stay per day (which
incorporated nursing, clinical staff and other stay costs) was possible.

Task 3
Create a series of budget outcomes based on a reduction of cost of stay per day of between
1% and 10% using the activity levels from Task 2.

Provide advice to the Clinical Director based on the outcomes you obtained.

Heart and Lung Division staff have already experienced many reforms over the last decade.
They believed the service is already at maximum efficiency, based on the changes they have
implemented and the cost of stay savings they have achieved in the past. The Clinical Director
would have to lead the change process if Ms Jones’ idea to reduce cost of stay per day was
implemented.

Task 4
Should the Clinical Director invest significant effort to engage a reform-weary staff to
implement the budget saving measure proposed in Task 3? Justify your answer.

(Hint: Should other opportunities for savings be considered? If so, present the possible options
and their impact using appropriate tables or graphs.)

The COO has found this new budget development process useful and was in favour of its
implemention across the entire hospital. He sought Ms Jones’ advice on the potential issues
he might face and the available strategies to resolve these issues.

Task 5
Discuss the potential issues of implementing change in the budgeting process.

Develop strategies the COO can adopt to minimise the consequences these issues will cause.

In an unexpected new development, through enterprise bargaining, staff salaries and benefits
were expected to rise in 2023, resulting in a modest increase in fixed costs to $2,800,000.
5
Fortunately, the national efficient price for 2023, released almost simultaneously, has also
shown an increase to $5,797.

Task 6

Using the activity levels from Task 2 as a basis for your computations, revise the budget based
on the new developments.

Based on the updated budget, what advice should Ms Jones provide to the Clinical Director?

After Ms Jones had completed the final draft of her budget documentation, the COO was
about to travel overseas for a business meeting. Ms Jones was asked to submit a short, 5-
minute video report to accompany her documentation.

Task 7

You should submit this task as a recorded video. You can record the video with a smartphone,
iPad, laptop etc., and submit the
Answered Same Day Nov 04, 2022

Solution

Dr Shweta answered on Nov 05 2022
37 Votes
Sheet1
    Description     Average Length of Stay (Days)Last Year    Last Year Number of Patients    Inlier Weight    No. of X-rays    No. of Pathology Tests    No. of Scripts    Cost of Stay per Day ($)    Cost of each XRay ($)    Cost of each Pathology Test ($)    Cost of each Script ($)
    Respiratory Infections and Inflammations, Major Complexity     8    350    1.5534    4    5    3    685    120    110    90
    Respiratory Infections and Inflammations, Minor Complexity    5    530    0.8202    2    3    5    685    100    90    80
    Chronic Obstructive Airways Disease, Major Complexity    6    400    1.4738    2    5    4    685    100    90    65
    Chronic Obstructive Airways Disease, Minor Complexity    3    450    0.6734    4    5    5    685    150    100    110
    Major Chest Trauma, Minor Complexity    4    320    0.6624    2    5    4    685    120    100    115
    Circulatory Dsrds, Not Adm for AMI W Invasive Cardiac Inves Int, Minor Comp    5    580    1.5485    2    6    5    685    140    180    80
    Heart Failure and Shock, Minor Complexity    5    500    0.9512    4    5    2    685    100    90    80
    Syncope and Collapse, Minor Complexity    2    450    0.3149    3    3    3    685    100    90    75
    Chest Pain, Major Complexity    4    300    0.4375    3    5    4    685    160    95    80
    Chest Pain, Minor Complexity    2    900    0.1416    2    2    1    685    100    85    95
    A
hythmia, Cardiac A
est and Conduction Disorders, Minor Complexity    2    400    0.3242    1    4    4    685    120    100    75
    Total funding received     cost of patient stay    cost from X-ray    cost from pathology tests    cost of Scripts    Total cost
    543.69    1918000    168000    192500    94500
    434.706    1815250    106000    143100    212000
    589.52    1644000    80000    180000    104000
    303.03    924750    270000    225000    247500
    211.968    876800    76800    160000    147200
    898.13    1986500    162400    626400    232000
    475.6    1712500    200000    225000    80000
    141.705    616500    135000    121500    101250
    131.25    822000    144000    142500    96000
    127.44    1233000    180000    153000    85500
    129.68    548000    48000    160000    120000
    3986.719    14097300    1570200    2329000    1519950    19516450
    22313666.243                fixed costs relating to the above work should be         2750000
    national efficient price $ 5597
                    fixed cost of previous year     2797216.243
                    Difference in her calculations     -47216.242999997    $ 47216.243
Sheet2
    Description     Average Length of Stay (Days)Last Year    Next Year Number of Patients with 30 % increase in chest patients     Inlier Weight    No. of X-rays    No. of Pathology Tests    No. of Scripts    Cost of Stay per Day ($)    Cost of each XRay ($)    Cost of each Pathology Test ($)    Cost of each Script ($)
    Respiratory Infections and Inflammations, Major Complexity     8    350    1.5534    4    5    3    685    120    110    90
    Respiratory Infections and Inflammations,...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here