Home And Community Care Program In Western Australia - Giude To The Unit Costs Spreadsheet - 2012 Page 9
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15Guide to the Unit Costs Spreadsheet
Enter Staff Groups across the top of the spreadsheet; then enter the gross wages for each
group. Include superannuation and workers’ compensation in the gross wages or enter a
percentage figure in the ORANGE cells (column C), to automatically calculate super and
workers’ compensation. You can also delete the percentages and just enter amounts in the
blue cells. To reinstate the formulae delete and re-enter the percentages.
Next enter the total number of hours worked per week by each Staff Group.
Now enter, in hours, the time that each Staff Group spends in delivering each service across
the Unit Cost categories.
Note:
The figures shown in row 8, “Total Hours Entered Below”, are the total hours entered for
each staff group below and should equal the “Total Hours Worked per Week” shown in
Row 7.
The red “Hide/Show Unused Columns” button (see Figure 4 above) allows you to hide
unused staff group columns so that you can see the last 2 columns of the sheet:
o Staff Hours per Week and
o Units Delivered per Week by Staff.
(Also shown for information purposes is Units Delivered per Week by Sub-
Contractors)
The staff hours and units delivered columns allow for the easy comparison of the
number of staff hours being assigned to the direct delivery of a service against the
number of units of service being delivered.
For example, if you deliver 520 hours of domestic assistance in a week (according to
your MDS) then the same number of hours should have been worked by staff in
direct service delivery. If you deliver centre based day care with a ratio of 1 staff to 5
clients your direct staff hours should be around one fifth of the hours delivered.
In Figure 4: Hours Sheet above, staff worked 50.2 hours to deliver 98.8 hours of
social support per week. In this instance social support is mostly delivered at a ratio
of 1 staff to 2 clients.
Hours not assigned to direct service delivery need to be assigned to:
o Direct Travel
o Indirect Time Costs and/or
o Management and Administration Employee Costs.
You can then assess the reasonableness of the time allocated to these categories.
For example, what is a reasonable proportion of time for indirect work?
Units Delivered per Week by Sub-Contractors is shown to assist in assigning Indirect
Time Costs and Management and Administration Employee Costs to service types
delivered by sub-contractors.
7
ADVERTISEMENT
0 votes
Related Articles
Related forms
Home And Community Based Care - Adrd Education And Support - Alaska Commission On Aging - Quarterly Program Report - Sfy 2001
Legal
Home- And Community-based Services (hcbs) Waiver Application - California Department Of Health Care Services
Legal
Nhtd/sri Form 3 Home And Community Based Services Medicaid Waiver Nursing Home Transition And Diversion (nhtd)
Legal
Atf Form 487-b - Application And Permit To Ship Liquors And Articles Of Puerto Rican Manufacture Taxpaid To The United States
Financial
Form 5170.7 - Application And Permit To Ship Liquors And Articles Of Puerto Rican Manufacture Taxpaid To The United States - 2015
Legal
Schedule C Corporation And Partnership - Credit For Taxes Paid To The United States, Its Possessions And Foreign Countries
Financial
Related Categories
Parent category: Business