RFP 270-22-0573 Attachment 15 SAMPLE Summary of Costs and Hours Spreadsheet.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- National Center on Substance Abuse and Child Welfare (NCSACW) Technical Assistance and Training
- Solicitation number
- 270-22-0573
About this file
This document contains a sample template for a summary of costs and hours spreadsheet to be submitted in response to solicitation number 270-22-0573 from the Department of Health and Human Services Substance Abuse and Mental Health Services Administration. The solicitation seeks continuation of the National Center on Substance Abuse and Child Welfare Technical Assistance and Training contract to address priorities of improving systems and practices for families with substance use disorders, co-occurring mental health disorders, and child abuse and neglect involved with or at risk of involvement with the child welfare and family judicial systems. The work will include technical assistance, training, resource development, information dissemination, and maintenance of a website, as well as optional tasks as needed, to assist local, state and tribal agencies. The sample template provides a format for prime contractors and subcontractors to estimate costs by task for the base year and any option years without requiring actual cost or hour inputs.
View the file
Other files
Show all 22
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
PRIME
Summary of Cost and Hours Spreadsheet
| PRIME COSTS (to include subs) (*Subs separate costs on tab 2) | HOURS | |||||||
| BASE YEAR | Estimated Costs | Base Fee | Award Fee | Total | PRIME | Sub name | Sub name | TOTAL |
| CORE TASKS | $0.00 | $0.00 | ||||||
| Optional Task 7 | $0.00 | $0.00 | ||||||
| Optional Task 8 | $0.00 | $0.00 | ||||||
| Optional Task 9 | $0.00 | $0.00 | ||||||
| Optional Task 10 | $0.00 | $0.00 | ||||||
| Optional Task 11 | $0.00 | $0.00 | ||||||
| Optional Task 12 | $0.00 | $0.00 | ||||||
| Optional Task 13 | $0.00 | $0.00 | ||||||
| Optional Task 14 | $0.00 | $0.00 |
TOTAL BASE $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
| Option Year 1 | Estimated Costs | Base Fee | Award Fee | Total | PRIME | Sub name | Sub name | TOTAL |
| CORE TASKS | $0 | $0 | ||||||
| Optional Task 7 | $0 | $0 | ||||||
| Optional Task 8 | $0 | $0 | ||||||
| Optional Task 9 | $0 | $0 | ||||||
| Optional Task 10 | $0 | $0 | ||||||
| Optional Task 11 | $0 | $0 | ||||||
| Optional Task 12 | $0 | $0 | ||||||
| Optional Task 13 | $0 | $0 | ||||||
| Optional Task 14 | $0 | $0 |
TOTAL OPTION YEAR 1 $0 $0 $0 $0 $0 $0 $0 $0
| Option Year 2 | Estimated Costs | Base Fee | Award Fee | Total | PRIME | Sub name | Sub name | TOTAL |
| CORE TASKS | $0 | $0 | ||||||
| Optional Task 7 | $0 | $0 | ||||||
| Optional Task 8 | $0 | $0 | ||||||
| Optional Task 9 | $0 | $0 | ||||||
| Optional Task 10 | $0 | $0 | ||||||
| Optional Task 11 | $0 | $0 | ||||||
| Optional Task 12 | $0 | $0 | ||||||
| Optional Task 13 | $0 | $0 | ||||||
| Optional Task 14 | $0 | $0 |
TOTAL OPTION YEAR 2 $0 $0 $0 $0 $0 $0 $0 $0
| Option Year 3 | Estimated Costs | Base Fee | Award Fee | Total | PRIME | Sub name | Sub name | TOTAL |
| CORE TASKS | $0 | $0 | ||||||
| Optional Task 7 | $0 | $0 | ||||||
| Optional Task 8 | $0 | $0 | ||||||
| Optional Task 9 | $0 | $0 | ||||||
| Optional Task 10 | $0 | $0 | ||||||
| Optional Task 11 | $0 | $0 | ||||||
| Optional Task 12 | $0 | $0 | ||||||
| Optional Task 13 | $0 | $0 | ||||||
| Optional Task 14 | $0 | $0 |
TOTAL OPTION YEAR 3 $0 $0 $0 $0 $0 $0 $0 $0
| Option Year 4 | Estimated Costs | Base Fee | Award Fee | Total | PRIME | Sub name | Sub name | TOTAL |
| CORE TASKS | $0 | $0 | ||||||
| Optional Task 7 | $0 | $0 | ||||||
| Optional Task 8 | $0 | $0 | ||||||
| Optional Task 9 | $0 | $0 | ||||||
| Optional Task 10 | $0 | $0 | ||||||
| Optional Task 11 | $0 | $0 | ||||||
| Optional Task 12 | $0 | $0 | ||||||
| Optional Task 13 | $0 | $0 | ||||||
| Optional Task 14 | $0 | $0 |
TOTAL OPTION YEAR 4 $0 $0 $0 $0 $0 $0 $0 $0
| Summary | Estimated Costs | Base Fee | Award Fee | Total | PRIME | Sub name | Sub name | TOTAL |
| CORE TASKS | $0 | $0 | ||||||
| Optional Task 7 | $0 | $0 | ||||||
| Optional Task 8 | $0 | $0 | ||||||
| Optional Task 9 | $0 | $0 | ||||||
| Optional Task 10 | $0 | $0 | ||||||
| Optional Task 11 | $0 | $0 | ||||||
| Optional Task 12 | $0 | $0 | ||||||
| Optional Task 13 | $0 | $0 | ||||||
| Optional Task 14 | $0 | $0 |
TOTAL $0 $0 $0 $0 $0 $0 $0 $0
RFP No. 270-22-0573 Attachment 15: Summary of Cost & Hours
Subcontractors Summary of Cost and Hours Spreadsheet Summary of Cost and Hours Spreadsheet
| Subcontractor's #1 total costs (included in PRIMEs) | Subcontractor's #2 total costs (included in PRIMEs) | ||||||||
| BASE YEAR | Estimated Costs | Base Fee | Award Fee | Total | BASE YEAR | Estimated Costs | Base Fee | Award Fee | Total |
| CORE TASKS | $0.00 | CORE TASKS | $0.00 | ||||||
| Optional Task 7 | $0.00 | Optional Task 7 | $0.00 | ||||||
| Optional Task 8 | $0.00 | Optional Task 8 | $0.00 | ||||||
| Optional Task 9 | $0.00 | Optional Task 9 | $0.00 | ||||||
| Optional Task 10 | $0.00 | Optional Task 10 | $0.00 | ||||||
| Optional Task 11 | $0.00 | Optional Task 11 | $0.00 | ||||||
| Optional Task 12 | $0.00 | Optional Task 12 | $0.00 | ||||||
| Optional Task 13 | $0.00 | Optional Task 13 | $0.00 | ||||||
| Optional Task 14 | $0.00 | Optional Task 14 | $0.00 |
TOTAL BASE $0.00 $0.00 $0.00 $0.00 TOTAL BASE $0.00 $0.00 $0.00 $0.00
| Option Year 1 | Estimated Costs | Base Fee | Award Fee | Total | Option Year 1 | Estimated Costs | Base Fee | Award Fee | Total |
| CORE TASKS | $0 | CORE TASKS | $0 | ||||||
| Optional Task 7 | $0 | Optional Task 7 | $0 | ||||||
| Optional Task 8 | $0 | Optional Task 8 | $0 | ||||||
| Optional Task 9 | $0 | Optional Task 9 | $0 | ||||||
| Optional Task 10 | $0 | Optional Task 10 | $0 | ||||||
| Optional Task 11 | $0 | Optional Task 11 | $0 | ||||||
| Optional Task 12 | $0 | Optional Task 12 | $0 | ||||||
| Optional Task 13 | $0 | Optional Task 13 | $0 | ||||||
| Optional Task 14 | $0 | Optional Task 14 | $0 |
TOTAL OPTION YEAR 1 $0 $0 $0 $0 TOTAL OPTION YEAR 1 $0 $0 $0 $0
| Option Year 2 | Estimated Costs | Base Fee | Award Fee | Total | Option Year 2 | Estimated Costs | Base Fee | Award Fee | Total |
| CORE TASKS | $0 | CORE TASKS | $0 | ||||||
| Optional Task 7 | $0 | Optional Task 7 | $0 | ||||||
| Optional Task 8 | $0 | Optional Task 8 | $0 | ||||||
| Optional Task 9 | $0 | Optional Task 9 | $0 | ||||||
| Optional Task 10 | $0 | Optional Task 10 | $0 | ||||||
| Optional Task 11 | $0 | Optional Task 11 | $0 | ||||||
| Optional Task 12 | $0 | Optional Task 12 | $0 | ||||||
| Optional Task 13 | $0 | Optional Task 13 | $0 | ||||||
| Optional Task 14 | $0 | Optional Task 14 | $0 |
TOTAL OPTION YEAR 2 $0 $0 $0 $0 TOTAL OPTION YEAR 2 $0 $0 $0 $0
| Option Year 3 | Estimated Costs | Base Fee | Award Fee | Total | Option Year 3 | Estimated Costs | Base Fee | Award Fee | Total |
| CORE TASKS | $0 | CORE TASKS | $0 | ||||||
| Optional Task 7 | $0 | Optional Task 7 | $0 | ||||||
| Optional Task 8 | $0 | Optional Task 8 | $0 | ||||||
| Optional Task 9 | $0 | Optional Task 9 | $0 | ||||||
| Optional Task 10 | $0 | Optional Task 10 | $0 | ||||||
| Optional Task 11 | $0 | Optional Task 11 | $0 | ||||||
| Optional Task 12 | $0 | Optional Task 12 | $0 | ||||||
| Optional Task 13 | $0 | Optional Task 13 | $0 | ||||||
| Optional Task 14 | $0 | Optional Task 14 | $0 |
TOTAL OPTION YEAR 3 $0 $0 $0 $0 TOTAL OPTION YEAR 3 $0 $0 $0 $0
| Option Year 4 | Estimated Costs | Base Fee | Award Fee | Total | Option Year 4 | Estimated Costs | Base Fee | Award Fee | Total |
| CORE TASKS | $0 | CORE TASKS | $0 | ||||||
| Optional Task 7 | $0 | Optional Task 7 | $0 | ||||||
| Optional Task 8 | $0 | Optional Task 8 | $0 | ||||||
| Optional Task 9 | $0 | Optional Task 9 | $0 | ||||||
| Optional Task 10 | $0 | Optional Task 10 | $0 | ||||||
| Optional Task 11 | $0 | Optional Task 11 | $0 | ||||||
| Optional Task 12 | $0 | Optional Task 12 | $0 | ||||||
| Optional Task 13 | $0 | Optional Task 13 | $0 | ||||||
| Optional Task 14 | $0 | Optional Task 14 | $0 |
TOTAL OPTION YEAR 4 $0 $0 $0 $0 TOTAL OPTION YEAR 4 $0 $0 $0 $0
| Summary | Estimated Costs | Base Fee | Award Fee | Total | Summary | Estimated Costs | Base Fee | Award Fee | Total |
| CORE TASKS | $0 | CORE TASKS | $0 | ||||||
| Optional Task 7 | $0 | Optional Task 7 | $0 | ||||||
| Optional Task 8 | $0 | Optional Task 8 | $0 | ||||||
| Optional Task 9 | $0 | Optional Task 9 | $0 | ||||||
| Optional Task 10 | $0 | Optional Task 10 | $0 | ||||||
| Optional Task 11 | $0 | Optional Task 11 | $0 | ||||||
| Optional Task 12 | $0 | Optional Task 12 | $0 | ||||||
| Optional Task 13 | $0 | Optional Task 13 | $0 | ||||||
| Optional Task 14 | $0 | Optional Task 14 | $0 |
TOTAL $0 $0 $0 $0 TOTAL $0 $0 $0 $0
RFP No. 270-22-0573 Attachment 15: Summary of Cost & Hours
File details come from the government source that posted it. Updated .