PIP Budget Template.xlsx
XLSX spreadsheet 42 KB Posted
- Attached to
- Positive Indian Parenting State and local contract opportunity
- Solicitation number
- 25-DCYF-CW-096
- Issued by
- Adams County, Asotin County, Benton County, Chelan County, Clallam County, Clark County, Columbia County, Cowlitz County, Douglas County, Ferry County, Franklin County, Garfield County, Grant County, Grays Harbor County, Island County, Jefferson County, King County, Kitsap County, Kittitas County, Klickitat County, Lewis County, Lincoln County, Mason County, Okanogan County, Pacific County, Pend Oreille County, Pierce County, San Juan County, Skagit County, Skamania County, Snohomish County, Spokane County, Stevens County, Thurston County, Wahkiakum County, Walla Walla County, Whatcom County, Whitman County, Yakima County, Asotin City, Clarkston City, Clarkston Heights-Vineland CDP, West Clarkston-Highland CDP, Benton City, Chelan City, Chelan Falls CDP, Clallam Bay CDP, Lewisville CDP, Rock Island City, Pacific Beach CDP, Whidbey Island Station CDP, Mercer Island City, Pacific City, Bainbridge Island City, Kingston CDP, Kitsap Lake CDP, Kittitas City, Klickitat CDP, Okanogan City, Anderson Island CDP, Fort Lewis CDP, Fox Island CDP, Herron Island CDP, Ketron Island CDP, North Fort Lewis CDP, Pacific City, Raft Island CDP, Stevenson City, Hat Island CDP, Lake Stevens City, Snohomish City, Spokane City, Spokane Valley City, Puget Island CDP, Garfield Town, Yakima City, Washington
About this file
The PIP Budget Template.xlsx is a financial document related to the Washington State Department of Children, Youth, and Families (DCYF) Positive Indian Parenting services solicitation. The document appears to be a budget template for prospective bidders from Federally Recognized Tribes, Recognized American Indian Organizations (RAIOs), and other Native Serving Organizations seeking to provide parenting services. While specific budget line items and allocation details would be contained within the spreadsheet, the associated opportunity description indicates this is a competitive procurement targeting Native community-based organizations to deliver specialized parenting support programming.
The budget template likely includes standard financial planning elements such as personnel costs, direct program expenses, indirect costs, and potential pass-through funding allocations. The solicitation seems focused on culturally-specific parenting intervention services, with DCYF seeking providers who can deliver targeted support within Native communities. Funding appears to be state-level, potentially with federal pass-through resources, though the exact funding sources and total contract value are not fully discernible from the provided documents. The procurement appears designed to support culturally responsive child and family service interventions specifically tailored to Native American community needs in Washington State.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Attach B1 Small Business Self Cert.docx | DOCX document | |
| PIP Sample Contract.docx | DOCX document | |
| RFQQ 25-DCYF-CW-096 PIP.docx | DOCX document | |
| Attach B Certs & Assurances.docx | DOCX document | |
| PIP Tribal Agreement Sample.docx | DOCX document | |
| Attach C1 Admin Response.docx | DOCX document |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
1. Overview (start here)
| ATTACHMENT C-3: COST PROPOSAL RESPONSE |
| This excel sheet is the budget template for Positive Indian Parenting services for Native American children and families This document includes 4 tabs (included in this overview). |
Tab 2: Staffing Sheet The second tab is a staffing sheet, which is intended to a) provide additional information about the staff and roles involved in implementing this program and b) help you calculate personnel costs for tab 3. This information should be consistent with totals displayed on tab 3.
Tab 3: Costs after program launch The third tab is a line item budget that includes costs associated with your proposed program after the program launches. To determine the time period for these costs, subtract the number of months anticipated for program start-up from 12. For example, if you anticipate that there will be three months between signing the contract and serving clients, the timeframe reflected in this tab should be 9 months.
Tab 4: Start-up costs (before program launch) The fourth tab is a line item budget that asks for you to articulate anticipated start-up costs for launching the program. The time frame for these costs is the amount of time between when the contract is signed and when your agency begins to serve clients through this program. If your program is already serving clients, you can leave this tab blank.
| Total start-up costs | $ - 0 |
| direct | $ - 0 |
| indirect | $ - 0 |
| Total costs after program launch | $ - 0 |
| direct | $ - 0 |
| indirect | $ - 0 |
Total $ - 0
2. Staffing sheet Staffing list for services (please complete below)
| General Instructions |
| Please provide a list of staff roles that will contribute to the services. You can display information flexibly below to help you calculate the direct costs for personnel including making a list of individual roles See example rows completed below the table as a guide, including formulas. You do not need to provide individual employee names, and do not include sub-contracted agency staff. For any part-time staff, you should make sure to capture the appropriate wages for their position. Values in summary totals table at right should match what is provided in "direct costs: personnel costs" section of tab 3. |
| Role | Personnel category | Contribution to services | Annual salary ($) | Annual benefits ($) | # of staff with this role | Est. % of time spent on these services | Total personnel cost for services | |
| Provide name of role | Select from drop-down menu of categories in cells below | Provide brief one-sentence explanation of how this role contributes to the Positive Indian Parenting Program | Record typical value for role, if needed can include individual staff with different salaries in multiple rows | Enter "1" if row is for one person. If multiple staff included in this row, include # of people with the same role, salary & benefits, % of time spent on these services | This must be expressed as a percentage in cells below (i.e., 75% or 0.75). Please elaborate as needed in budget narrative | Calculate (see example formula in cells below). Can "copy/paste" the formula into other cells in this column to continue using, or adjust formula or type in values as needed. Total in this column should reflect appropriate direct alloction of staff costs to these services. | ||
| - 0 | << Cell uses example total formula | |||||||
| - 0 | << Cell uses example total formula | |||||||
| - 0 | << Cell uses example total formula | |||||||
| - 0 | ||||||||
| - 0 | ||||||||
| - 0 | ||||||||
| - 0 | ||||||||
| - 0 | ||||||||
| - 0 | ||||||||
| - 0 |
| Total | - 0 | |||||||
| Example rows | ||||||||
| Illustrative values only | ||||||||
| Role | Personnel category | Contribution to PIPprogram | Annual salary ($) | Annual benefits ($) | # of staff with this role | Est. % of time spent on PIP program | Total personnel cost | |
| PIP Facilitator | Frontline caseworkers | Serve families directly | $ 10,000.00 | $ 2,000.00 | 2 | 100% | 24,000 | << Column uses example total formula |
| Supervisor | Supervisors/managers | Manage facilitators | $ 20,000.00 | $ 2,000.00 | 2 | 100% | 44,000 | |
| HR recruiter/trainer | Other personnel costs | Responsible for hiring, recruiting, on-boarding new PIP staff | $ 15,000.00 | $ 2,000.00 | 1 | 30% | 5,100 |
3. Costs after program launch Budget (please complete below)
| General instructions |
| Please complete the budget tables below with your best estimates of annual costs after your agency begins to see clients for this program (do not include start-up costs from tab 4 in this sheet). Line item categories and sub-categories are designed to help you prepare a strong budget. However, you do not need to complete rows for items where you do not anticipate incurring costs, and can also add to "other" rows below. |
| Direct costs | ||||
| Line item | Amount requested | Instructions | Notes (if needed) | |
| Personnel costs | $ - 0 | << Cell uses formula to sum sub-items below | ||
| Supervisors/managers | Review tab 3 for staffing sheet which provides opportunity to add more information. Amount requested in cells at left should match totals for the same categories on tab 3, and include both salaries and benefits attributed to the program and services. | |||
| PIP Facilitators | ||||
| Coordination or administrative support | ||||
| Child-care | ||||
| Other personnel costs | ||||
| Program materials and supplies | $ - 0 | << Cell uses formula to sum sub-items below | ||
| Program model-specific materials | ||||
| Cultural Supplies | ||||
| Concrete goods | Use notes column at right to specify what concrete supports or services you plan to deliver to families (e.g. utilities, hygiene kits, cultural items, fire extinguisher) | |||
| Child-care supplies for Group Delivery | ||||
| Food for Group Delivery | ||||
| Program model-specific expenses | $ - 0 | << Cell uses formula to sum sub-items below | ||
| Program license or other fees | ||||
| Program training (ongoing) | ||||
| Other program model costs | Note that EBP materials are included in program materials/supplies category above | |||
| Systems costs related to program | $ - 0 | << Cell uses formula to sum sub-items below | ||
| Technology for data collection, reporting | ||||
| Other systems | ||||
| Consulting and sub-contracting | $ - 0 | << Cell uses formula to sum sub-items below | ||
| Consulting | ||||
| Cultural Consultation | Provide estimated total for reimbursements used to augment PIP with cultural consutlation and lived experts | |||
| Sub-contracting | Provide estimated total for sub-contractor cost if relevant. Further detail will be requested after submission if needed. | |||
| All other direct costs | $ - 0 | << Cell uses formula to sum sub-items below | ||
| [Please add as needed] | As needed, use notes column at right as well as budget narrative to provide additional detail | |||
| [Please add as needed] | ||||
| [Please add as needed] | ||||
| [Please add as needed] | ||||
| [Please add as needed] | ||||
| [Please add as needed] | << If more rows needed, please insert above black bar |
| Total direct costs | $ - 0 | << Cell uses total formula to sum each category above | |
| Indirect costs | |||
| Line item | Amount/rate requested | Instructions | Notes (if needed) |
| Indirect cost rate (applied to total direct costs) | DCYF will validate the number that you proposed in your application. | ||
| Total indirect costs | $ - 0 | << Cell uses formula to multiply DC with IDC rate, do not change |
Total Costs after program launch $ - 0
4. Start-up costs
| General instructions | |
| Please complete the table below with your best estimates of initial start-up costs to launch the services and programs, from when the contract is signed to when your agency begins to see clients through this program. Line item categories and sub-categories are designed to help you document these costs. However, you do not need to complete rows for items where you do not anticipate incurring costs, and can also add to "other" rows below. Please also included anticipated length of start-up period at right. | Start-up period |
| Anticipated length of start-up period (in months) |
| Start-up costs for services | |||
| Line item | Amount requested | Instructions | Notes (if needed) |
| Personnel costs | $ - 0 | << Cell uses formula to sum sub-items below | |
| Supervisors/managers | Please include a brief note at right and use budget narrative to explain rationale | ||
| PIP Facilitators | |||
| Coordination or administrative support | |||
| Child-care | |||
| Other personnel costs | |||
| Program materials and supplies | $ - 0 | << Cell uses formula to sum sub-items below | |
| Program model-specific materials | |||
| Recruitment, hiring, on-boarding materials | |||
| Other program materials/supplies | |||
| Program model-specific expenses | $ - 0 | << Cell uses formula to sum sub-items below | |
| Program license or other fees | |||
| Program training (initial) | Should reflect initial training needed rather than ongoing training | ||
| Other program model costs | Note that EBP materials are included in program materials/supplies category above | ||
| Systems costs related to program | $ - 0 | << Cell uses formula to sum sub-items below | |
| Technology for data collection, reporting | |||
| Other systems | |||
| Consulting and sub-contracting | $ - 0 | << Cell uses formula to sum sub-items below | |
| Consulting | |||
| Sub-contracting | |||
| All other start-up costs | $ - 0 | << Cell uses formula to sum sub-items below | |
| [Please add as needed] | As needed, use notes column at right as well as budget narrative to provide additional detail. | ||
| [Please add as needed] | |||
| [Please add as needed] | |||
| [Please add as needed] | |||
| [Please add as needed] | |||
| [Please add as needed] |
| Total start-up costs | $ - 0 | ||
| Indirect costs | |||
| Line item | Amount/rate requested | Instructions | Notes (if needed) |
| Indirect cost rate (applied to total direct costs) | DCYF will validate the number that you proposed in your application. | ||
| Total indirect costs | $ - 0 | ||
| Total start-up costs | $ - 0 | << Cell uses total formula to sum each category above | |
| Total must not exceed $15,000 |
drop down values
| Supervisors/managers |
| PIP Facilitators |
| Coordination or administrative support |
| Child-care |
| Other personnel costs |
File details come from the government source that posted it. Updated .