Attachment_D_BIDDER_5_SECTION_COST_BREAKDOWN.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- School Apportionment System Modernization State and local contract opportunity
- Solicitation number
- RFP No. 2026-12
- 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
This document is a cost breakdown attachment (Attachment_D_BIDDER_5_SECTION_COST_BREAKDOWN.xlsx) for the Washington Office of Superintendent of Public Instruction (OSPI) School Apportionment System Modernization project. The project seeks to transform the School Apportionment Financial Systems (SAFS) into the School Apportionment System for Quality, Accountability, Transparency, and Calculations Hub (SASQUATCH), which is the primary tool for allocating operating revenue across Washington state's public K-12 education system. The contract spans six fiscal years, with three years of development and three years of maintenance and operations support, and allows for additional optional contracted years at OSPI's discretion.
The cost proposal includes a comprehensive scoring methodology where bidders can earn up to 120 points for cost factors and 80 points for non-cost factors. The lowest total evaluation price will receive the maximum 120 cost points, with other bids receiving proportional points based on a specific calculation formula. The cost breakdown covers various expense categories including development costs, hosting, processing, third-party products, user licenses, ongoing support, and optional services. The document also includes sections for subcontractor costs, in-kind OSPI staffing assumptions, human resource costs, and travel expenses, providing a detailed financial framework for potential bidders to complete.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Contract_Intake_Form_01.24.docx | DOCX document | |
| _Exhibit_A_Assurances_2026-12.docx | DOCX document | |
| Attachment_B_High-Level_As-Is_Workflows.pdf | ||
| Attachment_C_RFP_Demonstration_Scenarios.docx | DOCX document | |
| _Exhibit_F_Contract_Issues_List_2026-12.docx | DOCX document | |
| _Exhibit_B_Qualification_Affirmations_2026-12.docx | DOCX document | |
| Attachment_A_Sasquatch_System_Requirements.xlsx | XLSX spreadsheet | |
| RFP_2026-12_Sasquatch_Apportionment.pdf |
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
Scoring Criteria
| Cost Factors: up to 120 points |
| OSPI will evaluate and score Bidder’s cost factors, as provided by Bidder in Bidder’s Financial Proposal as follows: |
| The bid with the lowest total evaluation price will receive 120 points. Bids with a higher evaluation price will receive proportionately fewer evaluation points based upon the bid with the lowest total evaluation price, using the following formula: |
| Lowest total bid evaluation price divided by a higher total bid evaluation price (i.e., the bid that is being evaluated) multiplied by the total number of available points equals the cost factor evaluation points. Points will be rounded to three places to the right of the decimal point using standard rounding method. |
| Sample Calculation: |
| Using Bidder A = $100,000 (lowest total evaluation price) and Bidder B = $110,000 |
| Bid B calculation: $100,000 (Bidder A, lowest total evaluation price) / $110,000 (Bidder B’s evaluation price) = 0.909 x 120 (maximum points available) = 109.09 |
| Bidder A is the bid with the lowest total bid evaluation price, so it would be assigned the maximum available points, 120.00 points. Bidder B would be assigned 109.09 points based on the formula above. |
| Non-Cost Factors: up to 80 points |
| OSPI will evaluate and score Bidder’s non-cost factors, as provided by Bidder in Bidder’s Financial Proposal as follows: |
| Up to 80 points will be awarded to the proposal that shows: |
| Clearly addresses all sections of requested information in Section C7, including evidence that the cost proposal encompasses all costs to perform the services necessary to accomplish the objectives in the contract. |
| In Kind OSPI Staffing Title/Descriptions |
| <add in kind staff type here> |
| Subject Matter Expert Consulting |
| Business Analyst |
| App Architect |
| App Developer |
| Data Analyst |
| Data Architect |
| Data Management |
| Data Specialist |
| Network Specialist |
| Software Tester |
| Technical Coordinator |
| Technical Lead Developer |
Cost Proposal Breakdown
| Fiscal Year 1 | Fiscal Year 2 | Fiscal Year 3 | Development Totals | Fiscal Year 4 | Fiscal Year 5 | Fiscal Year 6 | Maint Totals | Total Project Costs | |||
| Your Description of/Comments Regarding Model/Services | Development | Development/Deployment | Support | Total Costs for Development Phase (Fiscal Years 1 - 3 ) | M&O Support (Additional contracted years at OSPI's Option) | M&O Support (Additional contracted years at OSPI's Option) | M&O Support (Additional contracted years at OSPI's Option) | Total Costs for 3 year post project costs | Total Costs for 3 year post project costs | ||
| Identify all costs including expenses to be charged for performing the services necessary to accomplish the objectives of the Contract | Development Costs | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |
| Hosting Costs (e.g., Cloud, Servers) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Processing Costs: (e.g., per packet, transaction, or MB) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Third-Party Products | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| User Licenses: Internal Admin (OSPI) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| User Licenses: Internal System User (OSPI) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| User Licenses: External | 0 | 0 | 0 | ||||||||
| User Licenses: Other Partners | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Ongoing Support (External) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Option Services: BA | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Optional Services: PM | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Optional Services: Training | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Optional Services: OCM | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |||
| 0 | 0 | 0 | |||||||||
| **Collaboration costs | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| 0 | 0 | 0 | |||||||||
| Applicable Sales Tax: | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| 0 | 0 | 0 | |||||||||
| $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |||
| 0 | 0 | 0 | |||||||||
| ANNUAL TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| **contractors must include in their proposal a section describing additional costs and staffing necessary to collaborate with other contractors employed to complete the remaining work section. These amounts will not be included in the final contract price if the contractor is awarded the work on all three work sections. |
SubContractor Breakdown
| Fiscal Year 1 | Fiscal Year 2 | Fiscal Year 3 | Development Totals | Fiscal Year 4 | Fiscal Year 5 | Fiscal Year 6 | Maint Totals | Total Project Costs | |||
| Indicate if Subcontractor is certified by the Office of Minority and Women’s Business Enterprises. | Development | Development/Deployment | Support | Total Subcontractor Costs for Development Phase (Fiscal Years 1 - 3 ) | M&O Support (Additional contracted years at OSPI's Option) | M&O Support (Additional contracted years at OSPI's Option) | M&O Support (Additional contracted years at OSPI's Option) | Total Subcontractor Costs for 3 year post project costs | Total Costs for Development and 3 year post project costs | ||
| Identify all expected Sub-Contractor costs included in your cost proposal to be charged for performing the services necessary to accomplish the objectives of the Contract | Development Costs | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |
| Hosting Costs (e.g., Cloud, Servers) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Processing Costs: (e.g., per packet, transaction, or MB) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Third-Party Products | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| User Licenses: Internal Admin (OSPI) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| User Licenses: Internal System User (OSPI) | |||||||||||
| User Licenses: External | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| User Licenses: Other Partners | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Ongoing Support (External) | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Option Services: BA | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Optional Services: PM | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Optional Services: Training | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| Additional, Optional Services: OCM | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |||
| $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |||
| **Collaboration costs | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |||
| Applicable Sales Tax | $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | ||
| $ | $ | $ | 0 | $ | $ | $ | 0 | 0 | |||
| ANNUAL TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
In Kind OSPI Assumptions
| Instructions: |
| This has to be Customize to the specific commodity and evaluation approach for the RFP propoal. Be sure to update the Evaluation workbook categories so that they match before publishing. For multiple categories/regions it may be helpful to have different sheets for each category/region for ease of use. |
| Goods and Services | Fiscal Year 1 | Fiscal Year 2 | Fiscal Year 3 | Development Totals | Fiscal Year 4 | Fiscal Year 5 | Fiscal Year 6 | Maint Totals | Total Project Costs | ||
| Your Description of/Comments Regarding Model/Services | Development | Development/Deployment | Support | Total Costs for Development Phase (Fiscal Years 1 - 3 ) | Support (Additional contracted years at OSPI's Option) | Support (Additional contracted years at OSPI's Option) | Support (Additional contracted years at OSPI's Option) | Total Costs for 3 year post project costs | Total Costs for 3 year post project costs | ||
| Provide a breakdown of any assumptions of costs or supports that your proposal expects OSPI's to fulfil during and after the project | Development Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Hosting Costs (e.g., Cloud, Servers) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Processing Costs: (e.g., per packet, transaction, or MB) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Third-Party Products | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Additional Costs for OSPI to Absorb (e.g., Update Support, hosting) - please specify | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Applicable Sales Tax | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| ANNUAL TOTALS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| In Kind Human Resource Costs | Fiscal Year 1 | Fiscal Year 2 | Fiscal Year 3 | Fiscal Year 4 | Fiscal Year 5 | Fiscal Year 6 | |
| Resource Description | Your Description of/Comments Regarding staff expectations | Expected FTE during project | Expected FTE during project | Expected FTE during project | Expected Ongoing FTE Support | Expected Ongoing FTE Support | Expected Ongoing FTE Support |
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> | |||||||
| <add in kind staff type here> |
ANNUAL TOTALS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Proposal Travel Expenses
| Fiscal Year 1 | Fiscal Year 2 | Fiscal Year 3 | Development Totals | Fiscal Year 4 | Fiscal Year 5 | Fiscal Year 6 | Maint Totals | Maint Totals | |||
| Categories | Multiplier - # of Staff/ Instances | Your Description of/Comments Regarding Travel Requirements | Development | Development/Deployment | Support | Total Travel Costs for Development Phase (Fiscal Years 1 - 3 ) | Maintenance & Operations Support | Maintenance & Operations Support | Maintenance & Operations Support | Total Travel Costs for 3 year post project costs | Total Costs for 3 year post project costs |
| Meals Per Diem | 1 | $0.00 | $0.00 | $0.00 | |||||||
| Lodging | $0.00 | $0.00 | $0.00 | ||||||||
| Travel | $0.00 | $0.00 | $0.00 | ||||||||
| Mileage | $0.00 | $0.00 | $0.00 | ||||||||
| Other (Please specify below) | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| $0.00 | $0.00 | $0.00 | |||||||||
| ANNUAL TOTALS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Instructions: |
| This has to be Customize to the specific commodity and evaluation approach for the RFP propoal. Be sure to update the Evaluation workbook categories so that they match before publishing. For multiple categories/regions it may be helpful to have different sheets for each category/region for ease of use. |
File details come from the government source that posted it. Updated .