Home And Community Care Program In Western Australia - Giude To The Unit Costs Spreadsheet - 2012 Page 11
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15Guide to the Unit Costs Spreadsheet
Entering Costs into the Worksheet
You can enter a total ($) amount in the ORANGE coloured cells and it will be distributed
across all services on the basis of the percentage of the total wages allocated to each
service (see row 4, ‘% of Wages and Sub-Contractor Costs in Each Service Type’).
Alternatively, you can manually distribute costs across services by entering them in the
BLUE cells. If you have previously entered a total ($) amount in the ORANGE coloured
cells then ‘Manual Edit Balance’ will show the difference between the current total (after
your manual edits), and the total ($) amount previously entered. This is useful as it
allows you to enter a target total and then adjust your entries to meet that target, i.e. if
‘Manual Edit Balance’ shows -$500 then you need to increase the entries for that row
by $500 to meet your expenditure figure.
A summary of costs is listed at the bottom of the worksheet starting in row 90. Use this
summary to check that your entries into the spreadsheet balance with your expenditure
statement.
Apportioned Costs
Categories 6, 7 and 8 include an item for Apportioned Costs. These are costs that can be
identified as HACC in total but cannot be, or are not easily, assigned to specific service
types. These costs can be apportioned across HACC service types (e.g. HACC has a
dedicated photocopier but no system to keep track of how many copies different service
types use).
3.5 Summary Worksheet
The Summary worksheet (shown in Figure 6 below) presents information for each service
type delivered including:
the Unit Cost of each service type (row 12)
the Unit Cost components (rows 5 - 11)
the Contracted Outputs (row 20) and
The Contracted Unit Price (row 21).
You cannot make entries into the Summary worksheet, as it is a summary of information in
other worksheets.
3.6 Cost Cats Worksheet
The Cost Cats worksheet contains a definition of each of the nine (9) cost categories that
comprise the Unit Cost.
3.7 Service Use Worksheet
Use this sheet for notes, calculations or any other uses you like.
9
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