| Expenses Category Staffing Total Staffing Cos Consumables Total Consumabl Overheads Total Overheads Depreceation Total Depreceati Grand Total Expe Revenue Category Income Grand Total Reve Break Even Calcu Total Income Less Total Expens Profit/Loss Additional Notes: Break-Even Lithgow Hos |
| 1. The above info 2. Break even ana 3. The Hospital in 4. The proposed s |
Item Total Annual Cost ($) Explanatory Notes
Registered Nurse 336,865.86 $
Nurses to be the primary staff for service delivery. Registered Nurse staffing requirements based on a nurse-to-patient ratio of 1 full-time equivalent (FTE) nurse for every 6 patients. Annual
expense based on 3.5 FTE Registered Nurses to treat 21 patients per day with an average consultation time of 1-hour per patient. Hourly rate based on median of NSW State Award (hourly rate)
for Registered Nurses: $31.5816 (1st year), $33.2974 (2nd year), $35.0158 (3rd year), $36.8579 (4th year), $38.6895 (5th year), $40.5079 (6th year), $42.5921 (7th year) and $44.3447 (8th year
and onwards) (NSW Nurses and Midwives Association, 2018). Service operation of 7-days per week selected to meet NSW Health guidelines for Hospital in the Home (HITH) which requires daily
review of HITH patients (NSW Health, 2018). Assumed expense of 7-hours per day based on 8-hour shift (9:00am to 5:00pm) with a 1-hour lunch break, 7-days per week, 52-weeks of the year.
Nursing Assistant 60,608.89 $
Assumed requirement of 1 Nursing Assistant to support Registered Nurses. Costs derived from median of NSW State Award (hourly rate) for Assistant in Nursing/Midwifery: $22.692 (1st year),
$23.4184 (2nd year), $24.1553 (3rd year), $24.9000 (4th year) (NSW Nurses and Midwives Association, 2018). Service operation of 7-days per week selected to meet NSW Health guidelines for
HITH which requires daily review of HITH patients (NSW Health, 2018). Assumed expense of 7-hours per day based on 8-hour shift (9:00am to 5:00pm) with a 1-hour lunch break, 7-days per
week, 52-weeks of the year.
Registrar 44,790.60 $
Registrars will work across both Lithgow Hospital and the HITH service. Cost based on annual budgeted rate of 0.4 FTE (equates to approximately 15-hours per week based on an assumed
working week of 38-hours). As nurses are the primary source of service delivery Registrars are assumed to not be required on a full-time basis. Annual salary based on median of NSW State
Award for Registrars 2018: $99,218 p.a. (1st year registrar), $107,713 (2nd year), $116,240 (3rd year) and $124,218 p.a. (4th year) (Industrial Relations Commission of New South Wales, 2018a).
Hourly rate was not used to calculate annual expense as cost of Registrars will be a fixed budgeted rate. Service from Registrars may be provided across multiple days (within budget) based on
demand.
Allied Health Professional 41,401.20 $
Allied Health staff will work across both Lithgow Hospital and the HITH service. Cost based on annual budgeted rate of 0.4 FTE (equates to approximately 15-hours per week based on an
assumed working week of 38-hours). As nurses are the primary source of service delivery Allied Health staff are assumed to not be required on a full-time basis. Annual salary based on median
of NSW State Award for Health Service Health Professionals 2018 for Level 3 and Level 4 staff. Salary range of $97,708 (Level 3, 1st year), $100,979 (Level 3, 2nd year), $106,027 (Level 4, 1st year)
and $108,667 (Level 4, 2nd year) (Industrial Relations Commission of New South Wales, 2018b). This level was chosen as the service requires practitioners who do not require direct supervision
when attending to patients (not a competency of Level 1 and 2 staff). Staff at levels above 3 and 4 were not seen as required for the service. Hourly rate was not used to calculate annual
expense as cost of Allied Health professionals will be a fixed budgeted rate. Services from Allied Health professionals may be provided across multiple days (within budget) based on demand.
Oncosts
| $ $ |
72,549.98 Oncosts to account for additional staffing costs incurred such as superannuation, calculated at 15% of total staffing costs 556,216.53 |
Pharmaceuticals 229,320.00 $
Total cost of pharmaceuticals based on estimated fixed cost of $30 per patient (assumed approximate value, indicative only). Total annual actual cost depends on number of patients seen per
day. Indicative annual cost based on target volume of patients per day over 7-days per week, 52 weeks per year. Upper limit of actual cost assumed, not all patients will require pharmaceuticals,
some may require more expensive pharmaceuticals than others.
Consumable Medical Supplies 76,440.00 $
Total cost of consumable medical supplies including gauze, bandages, swabs, disposable gloves, hand sanitizer and other general items based on estimated fixed cost of $10 per patient
(assumed approximate value, indicative only). Total annual actual cost depends on actual number of patients seen per day. Total annual cost based on target volume patients per day over 7-
days per week, 52 weeks per year.
$
Vehicle Insurance & Registration 5,000.00 $ Annual cost based on estimated weekly cost of $96.15 including insurance, registration and other maintenance for two vehicles.
Petrol 10,400.00 $ Based on fixed weekly cost of $100 for each motor vehicle ($200 total for two vehicles).
Administration Staff 127,881.78 $
Based on median cost of 1 level 5 adminstration officer ($1248.13 to $1277.86 per week) to coordinate service, pay rates based on NSW State Award for health employee administration staff
2018 and median cost of 1 level 4 adminstration officer ($1182.03 to $1210.51 per week) pay rates based on NSW State Award rates for health employee administration staff state award 2018
(Industrial Relations Commission of New South Wales, 2018c). Level 4 staff selected to support level 5 administration officer.
$
Motor Vehicle 12,500.00 $
Assumed requirement of 2 motor vehicles. Assumed motor vehicle cost of $50,000 each ($100,000 total). Total depreciation calculated using ‘Prime cost (straight line)’ method where fixed
amount of depreciation is claimed per year (Australian Taxation Office, n.d.). Depreciation rate of 8-years used based on Australian Taxation Office taxation ruling for income tax for motor
vehicles (Australian Taxation Office 2018). Total annual cost indicates total cost of depreciation per year.
IT Equipment 2,500.00 $
Assumed computer/other technology cost of $10,000 (including computers required for mobile access and data entry of patient records). Total depreciation calculated using ‘Prime cost
(straight line)’ method where fixed amount of depreciation is claimed per year (Australian Taxation Office, n.d.). Depreciation rate of 4-years used based on Australian Taxation Office taxation
ruling for income tax for computers and computer equipment (Australian Taxation Office 2018). Total annual cost indicates total cost of depreciation per year.
| 15,000.00 1,020,258.31 |
$ $ |
Product/Service Total Annual Revenue ($) Explanatory Notes
Patient Revenue 1,020,258.31 $
Total patient revenue per year based on patient revenue of $133.47 per patient per day with a target of 21 patients per day, 7 days per week, 52 weeks per year. Patient revenue determined to
be $133.47 per patient per day based on a patient volume of 21 patients per day, required staffing levels (1 Registered Nurse for every 6 patients, equivalent to 3.5 FTE Registered Nurses) and
additional service costs (all other other expenses). Target patient volume of 21 patients per day, over an 8-hour shift (including 1-hour break), 7-days per week, 52 weeks per year based on
average consultation time of approximately 1-hour per patient (including travel time, set-up, pack-up and any relevant administration tasks).
$
$
$
-$
5. Staff resources and expenses are based on service operating hours of 9:00am to 5:00pm 7-days per week to meet NSW Guidelines for Hospital in the Home which specifies that patients should receive daily care. The service will also operate a 24-hour call line for patients through Lithgow Hospital
6. All expenses and revenues are indicative only, no information has been identified in the literature for specific staffing levels (including staff to patient ratios), relevant expenses and operating revenues for Hospital in the Home services in New South Wales
| References & Assumptions for Break Even Analysis: Optimal Budget | ||
| Staff Resources | ||
| Staff Type | Number (FTE) | Annual Salary ($) |
| Registered Nurse | 3.5 | NA |
| Nursing Assistant | 1 | NA |
| Registrar | 0.4 | 111,976.50 $ |
| Allied Health Professional | 0.4 | 103,503.00 $ |
| Service Activity Targets | ||
| Target Patients Per Day (Count) | 21 | |
| Patients per Registered Nurse | 6 | |
| Hours of Operation per Day | 8 | |
| Days of Operation per Week | 7 | |
| Weeks per Year | 52 | |
| Revenue per Patient ($) | $ 133.47 | |
| Consumables Costs | ||
| Type | Average Unit Cost ($) | Frequency of Use (per patient) |
| Pharmaceuticals | 30.00 $ | 1 |
| Consumable Medical Supplies | 10.00 $ | 1 |
| Overheads | ||
| Type | Total Weekly Cost | |
| Vehicle Insurance and Registration | 96.15 $ | |
| Petrol | 200.00 $ | |
| Administration Staff – Level 5 | 1,263.00 $ | |
| Administration Staff – Level 4 | 1,196.27 $ | |
| Depreceation Costs | ||
| Type | Cost ($) | Years Depreceated |
| IT Equipment | 10,000.00 $ | 4 |
| Motor Vehicles | 100,000.00 $ | 8 |
| Hourly Rate ($) | Hours per Day | Total Hours per Week |
| $ 37.77 | 7 | 171.5 |
| $ 23.79 | 7 | 49 |
| NA | NA | 15.2 |
| NA | NA | 15.2 |
| Formula | ||
| Cost x (days held/365) x (100%/assets effective life) | ||
| Cost x (days held/365) x (100%/assets effective life) |
Micaela Hogan
Student Number: 17649038
| Expenses Break-Even Analysis for Hospital in the Home Service: Contingency Budget Lithgow Hospital, Nepean Blue Mountains Local Health District |
|||
| Category Staffing Total Staffing Costs Consumables Total Consumable Costs Overheads Total Overheads Depreceation Total Depreceation Grand Total Expenses Revenue |
Item/Costs Registered Nurse Nursing Assistant Registrar Allied Health Professional Oncosts Pharmaceuticals Consumable Medical Supplies Vehicle Insurance & Registration Petrol Administration Staff Motor Vehicle IT Equipment |
Total Annual Cost ($) $ 287,282.45 60,608.89 $ 44,790.60 $ 41,401.20 $ $ 195,566.31 $ 65,188.77 260,755.08 $ 5,000.00 $ $ 10,400.00 127,881.78 $ 143,281.78 $ 12,500.00 $ 2,500.00 $ |
Explanatory Notes Annual cost of Registered Nurses based on staffing requirement of 3.0 FTE Registered Nurses. Requirement of 3.0 FTE Registered Nurses based on patient volume of 18 patients per day, a nurse to patient ratio of 1 Registered Nurse for every 6 patients and an average consultation time of 1-hour per patient. Hourly rate based on median of NSW State Award (hourly rate) for Registered Nurses: $31.5816 (1st year), $33.2974 (2nd year), $35.0158 (3rd year), $36.8579 (4th year), $38.6895 (5th year), $40.5079 (6th year), $42.5921 (7th year) and $44.3447 (8th year and onwards) (NSW Nurses and Midwives Association, 2018). Service operation of 7-days per week selected to meet NSW Health guidelines for Hospital in the Home (HITH) which requires daily review of HITH patients (NSW Health, 2018). Assumed expense of 7-hours per day based on 8-hour shift (9:00am to 5:00pm) with a 1-hour lunch break, 7-days per week, 52-weeks of the year. Assumed requirement of 1 Nursing Assistant to support Registered Nurses. Costs derived from median of NSW State Award (hourly rate) for Assistant in Nursing/Midwifery: $22.692 (1st year), $23.4184 (2nd year), $24.1553 (3rd year), $24.9000 (4th year) (NSW Nurses and Midwives Association, 2018). Service operation of 7-days per week selected to meet NSW Health guidelines for HITH which requires daily review of HITH patients (NSW Health, 2018). Assumed expense of 7-hours per day based on 8-hour shift (9:00am to 5:00pm) with a 1-hour lunch break, 7-days per week, 52-weeks of the year. Registrars will work across both Lithgow Hospital and the HITH service. Cost based on annual budgeted rate of 0.4 FTE (equates to approximately 15-hours per week based on an assumed working week of 38-hours). As nurses are the primary source of service delivery Registrars are assumed to not be required on a full time basis. Annual salary based on median of NSW State Award for Registrars 2018: $99,218 p.a. (1st year registrar), $107,713 (2nd year), $116,240 (3rd year) and $124,218 p.a. (4th year) (Industrial Relations Commission of New South Wales, 2018a). Houlry rate was not used to calculate annual expense as cost of Registrars will be a fixed budgeted rate. Service from Registrars may be provided across multiple days (within budget) based on demand. Allied Health staff will work across both Lithgow Hospital and the HITH service. Cost based on annual budgeted rate of 0.4 FTE (equates to approximately 15- hours per week based on an assumed working week of 38-hours). As nurses are the primary source of service delivery Allied Health staff are assumed to not be required on a full-time basis. Annual salary based on median of NSW State Award for Health Service Health Professionals 2018 for Level 3 and Level 4 staff. Salary range of $97,708 (Level 3, 1st year), $100,979 (Level 3, 2nd year), $106,027 (Level 4, 1st year) and $108,667 (Level 4, 2nd year) (Industrial Relations Commission of New South Wales, 2018b). This level was chosen as the service requires practitioners who do not require direct supervision when attending to patients (not a competency of Level 1 and 2 staff). Staff at levels above 3 and 4 were not seen as required for the service. Houlry rate was not used to calculate annual expense as cost of Allied Health professionals will be a fixed budgeted rate. Services from Allied Health professionals may be provided across multiple days (within budget) based on demand. Oncosts to account for additional staffing costs incurred such as superannuation, calculated at 15% of total staffing costs Total cost of pharmaceuticals based on estimated fixed cost of $30 per patient (assumed approximate value, indicative only). Total annual actual cost depends on number of patients seen per day. Indicative annual cost based on target volume of patients per day over 7-days per week. Upper limit of actual cost assumed, not all patients will require pharmaceuticals, some may require more expensive pharmaceuticals than others. Total cost of consumable medical supplies including gauze, bandages, swabs, disposable gloves, hand sanitizer and other general items based on estimated fixed cost of $10 per patient (assumed approximate value, indicative only). Total annual actual cost depends on actual number of patients seen per day. Total annual cost based on target volume patients per day over 7-days per week. Annual cost based on weekly cost of $96.15 including insurance, registration and other maintenance for two vehicles. Based on fixed weekly cost of $100 for each motor vehicle ($200 total for two vehicles). Based on median cost of 1 level 5 adminstration officer ($1248.13 to $1277.86 per week) to coordinate service, pay rates based on NSW State Award for health employee administration staff 2018 and median cost of 1 level 4 adminstration officer ($1182.03 to $1210.51 per week) pay rates based on NSW State Award rates for health employee administration staff state award 2018 (Industrial Relations Commission of New South Wales, 2018c). Level 4 staff selected to support level 5 administration officer. Assumed requirement of 2 motor vehicles. Assumed motor vehicle cost of $50,000 each ($100,000 total). Total depreciation calculated using ‘Prime cost (straight line)’ method where fixed amount of depreciation is claimed per year (Australian Taxation Office, n.d.). Depreciation rate of 8-years used based on Australian Taxation Office taxation ruling for income tax for motor vehicles (Australian Taxation Office 2018). Total annual cost indicates total cost of depreciation per year. Assumed computer/other technology cost of $10,000 (including computers required for mobile access and data entry of patient records). Total depreciation calculated using ‘Prime cost (straight line)’ method where fixed amount of depreciation is claimed per year (Australian Taxation Office, n.d.). Depreciation rate of 4-years used based on Australian Taxation Office taxation ruling for income tax for computers and computer equipment (Australian Taxation Office 2018). Total annual cost indicates total cost of depreciation per year. |
| Category Income |
Product/Service Patient Revenue |
Total Annual Revenue ($) $ 918,232.48 $ |
Explanatory Notes Total patient revenue per year based on patient revenue of $140.86 per patient per day with a target of 18 patients per day, 7 days per week, 52 weeks per year. Patient revenue determined to be $140.86 per patient per day based on a patient volume of 18 patients per day, required staffing levels (1 Registered Nurse for every 6 patients, equivalent to 3.0 FTE Registered Nurses) and additional service costs (all other other expenses). Target patient volume of 18 patients per day, over an 8-hour shift (including 1-hour break), 7-days per week, 52 weeks per year based on average consultation time of approximately 1-hour per patient (including travel time, set-up, pack-up and any relevant administration tasks). |
| Break Even Calculation | |||
| Original (Optimal) Budget Contingency Budget % Change Total Income $ 1,020,258.31 $ 918,232.48 -10% Less Total Annual Expenses $ 1,020,258.31 $ 918,232.48 -10% Profit/Loss -$ 0.00 $ 0.00 – Additional Notes: 3. Break even analysis is based on an annual zero-based activity budget where operating expenses are equal to operating revenues of $918,232.48 per year 4. The Hospital in the Home service is designed to target selected acute and sub-acute adult patients in the Lithgow Hospital catchment area 5. The proposed staffing model is based on a shared staffing model where qualified/selected staff are employed by Nepean Blue Mountains Local Health District and work across Lithgow Hospital and the Hospital in the Home service 6 7 1. The above table provides a break-even analysis for a proposed new Hospital in the Home Service to be operated from Lithgow Hospital within the Nepean Blue Mountains Local Health District based on a 10% below optimal budget (contingency budget) 2 N a f |
$ 65,112.47 499,195.62 $
$ 15,000.00
918,232.48 $
Grand Total Revenue 918,232.48
| References & Assumptions for Break Even Analysis: Contingency Budget | ||
| Staff Resources | ||
| Staff Type | Number (FTE) | Annual Salary ($) |
| Registered Nurse | 3.0 | NA |
| Nursing Assistant | 1 | NA |
| Registrar | 0.4 | 111,976.50 $ |
| Allied Health Professional | 0.4 | 103,503.00 $ |
| Service Activity Targets | ||
| Target Patients Per Day (Count) | 18 | |
| Patients per Registered Nurse | 6 | |
| Hours of Operation per Day | 8 | |
| Days of Operation per Week | 7 | |
| Weeks per Year | 52 | |
| Revenue per Patient Service ($) | $ 140.86 | |
| Consumables Costs | ||
| Type | Average Unit Cost ($) | Frequency of Use (per patient) |
| Pharmaceuticals | 30.00 $ | 1 |
| Consumable Medical Supplies | 10.00 $ | 1 |
| Overheads | ||
| Type | Total Weekly Cost | |
| Vehicle Insurance and Registration | 96.15 $ | |
| Petrol | 200.00 $ | |
| Administration Staff – Level 5 | 1,263.00 $ | |
| Administration Staff – Level 4 | 1,196.27 $ | |
| Depreceation Costs | ||
| Type | Cost ($) | Years Depreceated |
| IT Equipment | 10,000.00 $ | 4 |
| Motor Vehicles | 100,000.00 $ | 8 |
| Hourly Rate ($) | Hours per Day | Total Hours per Week |
| $ 37.77 | 7 | 146.3 |
| $ 23.79 | 7 | 49 |
| NA | NA | 15.2 |
| NA | NA | 15.2 |
| Formula | ||
| Cost x (days held/365) x (100%/assets effective life) | ||
| Cost x (days held/365) x (100%/assets effective life) |
References
Australian Taxation Office. (n.d.) Prime cost (straight line) and diminishing value methods. Retrieved from https://www.ato.gov.au/Business/Depreciation-and-capital-expenses-andallowances/General-depreciation-rules—capital-allowances/Prime-cost-(straight-line)-and-diminishing-value-methods/
Australian Taxation Office. (2018). Taxation Ruling Income tax: effective life of depreciating assets (applicable from 1 July 2018). Retrieved from
https://www.ato.gov.au/law/view/document?LocID=%22TXR%2FTR20172%2FNAT%2FATO%22&PiT=99991231235958
Industrial Relations Commission of New South Wales. (2018a). Health Professionals and Medical Salaries (State) Award 2018. Retrieved from
https://www.health.nsw.gov.au/careers/conditions/Awards/he-profmed-salaries.pdf
Industrial Relations Commission of New South Wales. (2018b). NSW Health Service Health Professionals (State) Award 2018. Retrieved from
https://www.health.nsw.gov.au/careers/conditions/Awards/health-professional.pdf
Industrial Relations Commission of New South Wales. (2018c). Health Employees Administrative Staff (State) Award 2018. Retrieved from
https://www.health.nsw.gov.au/careers/conditions/Awards/hsu-he-administrative.pdf
NSW Health. (2018). Adult and Paediatric Hospital in the Home. Retrieved from https://www1.health.nsw.gov.au/pds/ActivePDSDocuments/GL2018_020.pdf
NSW Nurses and Midwives Association. (2018). Public Health System Nurses’ & Midwives’ (State) Award 2018. Retrieved from http://www.nswnma.asn.au/wp-content/uploads/2018/08/PHSWage-Calculator-1st-july-2018.pdf
The post Expenses Category Staffing appeared first on My Assignment Online.