Guide to the Unit Costs Spreadsheet
3.2 Services Worksheet
Enter your service information in this worksheet as follows:
Sponsor Name
Unit Costs Period - You can calculate your unit costs based on any combination of
quarters within the financial year. HACC only require Unit Costs on an annual basis.
Region – A separate Unit Costs spreadsheet is required for regions where the contracted
unit price varies for each project. An example would be if a service provider is
contracted to provide services in the metropolitan region and the Pilbara region – a
separate Unit Cost spreadsheet would need to be submitted for the Pilbara region.
Weeks in Unit Cost Period -This is automatically calculated based on the Unit Costs
Period selected.
Enter each service type you deliver. Tick a box for each service type. Only the service
types selected will show on other sheets.
For each service delivered fill out:
‐
HACC Funding for the Unit Cost Period (from the
HACC Service Specification Schedule - AFL).
IMPORTANT:
‐
Client Contributions for Each Service Type for the
Unit Cost Period (from Financial Reports)
If your Unit Cost period is less
than a year adjust this
‐
Contracted Outputs for the Unit Cost Period (from
information accordingly.
the HACC Service Specification Schedule)
‐
Delivered Outputs for the Unit Cost Period (from
MDS data reports)
‐
Units Delivered by Sub-contractors for Period (from your client management system)
‐
Fees Paid to Sub-contractors for Period (from your financial management system).
Figure 3: Services Sheet
5