2._Exhibit_D_Cost_Worksheets.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- Satellite Data Purchase Project
- Solicitation number
- 0000027246
- Issued by
- Sacramento County, Sacramento City, California
About this file
This document contains a Cost Worksheet for a Satellite Data Purchase Project solicitation issued by the State of California. The project seeks to procure services and methane data and other environmental indicators derived from earth-orbiting, small satellite constellations. The state is requesting cost proposals for various deliverables, including project management, requirements analysis, operationalizing an initial baseline observation deck, training, continuous data feed, feedback meetings, and an annual report. Bidders must provide pricing for the minimum value of the contract as well as optional methane data services outside of California.
The cost worksheet provides detailed instructions and a template for bidders to input their proposed pricing. Pricing is required for specific tasks and deliverables, with some items designated as one-time costs and others as no-cost updates. The total costs will be evaluated, with the minimum value of the contract weighted at 400 points and the optional methane data services weighted at 50 points out of a total of 450 points.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1.Satellite_Data_Purchase_Project_RFP.pdf | ||
| 3._CA_Methane_Example_Deck_2026.zip | ZIP file | |
| Satellite_Data_Purchase_Project_Addendum_2_Clean.pdf | ||
| State_Response_to_Vendor_Questions_CARB.xlsx | XLSX spreadsheet | |
| Satellite_Data_Purchase_Project_Addendum_2_Redline.pdf | ||
| 4._Observational_Capacity_Simulation_Results_Table.xlsx | XLSX spreadsheet | |
| 5._Global_Observation_Deck_Example.zip | ZIP file | |
| SDPP-2023_Addendum_1.zip | ZIP file |
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
1. Instructions
COST WORKSHEET INSTRUCTIONS
| a) The Cost Worksheets shall be completed in accordance with the instructions in Section 3.2: COST WORKSHEET INSTRUCTIONS. |
| b) The Cost Worksheets shall be submitted with the Bidder’s Final Proposal. |
| c) Bidders must fill in all cells highlighted in yellow on each tab |
| 2) Minimum Value of Contract |
| This is the minimum value of the contract. Cost worksheet Tab #2 lists the required deliverables that must be priced and included with the Bidder's proposal response. The State has populated some of the cells with formulas, however it is the responsibility of the Bidder to ensure worksheets and calculations are correct and accurate. The State will not assume responsibility for any cost figures that do not calculate properly. |
| Rows 1-2 contains the header for the worksheet where the Bidder will enter the Bidder name in Box C2. | |
| Column A, Payment Milestone: For reference only. This column lists a payment milestone number. | |
| Column B-C, Scope of work: For reference only. This column lists a brief name for the scope of work associated with each payment milestone. | |
| Column D, Proposed Tasks: For reference only. This column lists sub-deliverables or additional task information for each payment milestone where applicable. | |
| Column E, Payment Milestone Cost: Bidder shall complete this column for any cell that is highlighted in yellow. | |
| Column F, Payment Structure: For reference only. This column lists a brief description of payment frequency. | |
| For the Methane Plume Data - Deliverable: | |
| a) Please use the results of the methane observational capacity simulations described in Section 4.2.2 (and provided by the bidder in Attachment 24) to estimate the annual cost of acquiring a methane target deck for an entire year. | |
| Please use the following target deck simulations to calculate cost for the following years: | |
| CA_methane_example_deck_2026: Apply the results of this simulation for the entirety of 2025, 2026, and the period of Jan 1 – June 30, 2027. | |
| Please note that the cost estimates are for methane data products only. Methane data products include "quick view" (i.e. delivered generally within 48 hours) and final methane data products (see the functional requirements for full description). | |
| The six-month simulations (Jan 1 - Jun 30) described in Section 4.2.2 - California Methane Observational Capacity Simulation and presented in Attachment 24 can be extrapolated to an annual basis (multiply by 2.0166), and results from the 2026 simulation can be applied to 2025 and 2027. | |
| 3) Mandatory Optional | |
| Cost worksheet Tab #3 are the Mandatory Optional items. These are mandatory for the Bidder to respond to but it is at the State's option/discretion on whether to utilize the option in the Contract. | |
| For MO #1, Methane Data Outside of California: | |
| a) Bidders to provide the cost of observing this global observation deck once during the year 2026. | |
| b) Bidders should provide a cost estimate using the assumptions in Section 5.2.1.1 - Methane Data Outside of California. | |
| 4) Total Costs | |
| Cost worksheet Tab #4 rolls up the costs from Tab #2 - Minimum Value of Contract and Tab #3 - Mandatory Optional Items. Bidder do not need to modify this tab as the cells have formulas. For reference only. |
2. Minimum Value of Contract
| Minimum Value of Contract for Payment Milestones (Deliverables-Based Costs) |
| Bidder Name: |
Enter Total Payment Milestones (Tasks & Deliverables) Cost:
| Payment Milestone | Scope of work | Proposed Tasks | Payment Milestone Cost | Payment Structure |
| Deliverable# 1 - Project Management | ||||
| 1 | Project Management | 1.1 Project Schedule | $- | One-Time Cost for initial schedule and plans; Updates are no cost |
| 1.2 Project Status Reports | $- | One-Time Cost for initial report; Updates are no cost | ||
| 1.3 Change Management Plan | $- | One-Time Cost for initial plans; Updates are no cost | ||
| 1.4 Risk Management Plan | $- | One-Time Cost for initial plans; Updates are no cost | ||
| 1.5 Issue Management Plan | $- | One-Time Cost for initial plans; Updates are no cost | ||
| Deliverable# 2 - Requirements Analysis | ||||
| 2 | Requirements Analysis | 2.1 Detailed Functional Requirements | No Cost | No Cost |
| 2.2 Detailed Non-Functional Requirements | No Cost | No Cost | ||
| 2.3 Requirement Traceability Matrix | $- | One-Time Cost for initial approved matrix; Updates are no cost | ||
| Deliverable# 3 - Operationalize an Initial Baseline Observation Deck | ||||
| 3 | Operationalize an Initial Baseline Observation Deck | 3.1 Operationalize Initial Baseline Observation Deck | $- | One-Time Cost |
| 3.2 Portal for successfully submitting proposed observation decks for validation before submittal | $- | One-Time Cost | ||
| 3.3 Updates of Observation Deck | No Cost | No Cost | ||
| Deliverable# 4 - Training and Knowledge Transfer | ||||
| 4 | Training and Knowledge Transfer | 4.1 Interactive training and written documentation (user guides and technical documentation) on usage of the observation deck submittal web portal and API | $- | One-Time Cost |
| 4.2 Interactive training and written documentation (user guides and technical documentation) on usage of the data product download/transfer web portal and API | $- | One-Time Cost | ||
| 4.3 Interactive training and written documentation (user guides and technical documentation) on usage of non-methane data products | $- | One-Time Cost | ||
| 4.4 Interactive training and written documentation (user guides and technical documentation) on the request and use of Raw Data Archives | $- | One-Time Cost | ||
| 4.5 Additional training, written documentation (user guides and technical documentation), and knowledge transfer sessions as determined by recurring Feedback Meetings referenced in Task 6 | No Cost | No Cost | ||
| Deliverable# 5 - Continuous Data Feed | ||||
| 5 | Continuous Data Feed | 5.1 Data feed initiated | No Cost | No Cost |
| 5.2 Necessary maintenance as needed to ensure availability of AOI submittal and data product download portals | No Cost | No Cost | ||
| Deliverable# 6 - Recurring Feedback Meetings | ||||
| 6 | Recurring Feedback Meetings | 6.1 Initial rollout feedback meetings | No Cost | No Cost |
| 6.2 Stabilization period feedback meetings | No Cost | No Cost | ||
| Deliverable# 7 - Development - Annual Report | ||||
| 7 | Annual Report | 7.1 Draft Annual Report | No Cost | No Cost |
| 7.2 Final Annual Report | $- | One-Time Cost | ||
| Methane Plume Data - Deliverable | ||||
| Methane Plume Data | Cost of Methane Plume Data for the entire year of 2025 | $- | ||
| Cost of Methane Plume Data for the entire year of 2026 | $- | |||
| Cost of Methane Plume Data for January 1, 2027 - June 30, 2027 | $- | |||
| TOTAL PAYMENT MILESTONE COSTS | ERROR:#VALUE! |
| Unanticipated Tasks | |||
| 9 | Unanticipated Tasks | CARB Approved Using DED Process (Not a guaranteed payment) | ERROR:#VALUE! |
| Total Payment Milestone Costs + Unanticipated Tasks = Minimum Value of the Contract | ERROR:#VALUE! |
3. Mandatory Optional
| Mandatory Optional (MO) Item - (Deliverables-Based Costs) |
| Bidder Name: |
Enter Total Mandatory Optional Cost
| Mandatory Optional | Scope of work | Proposed Tasks | Payment Milestone Cost | Weight (For Evaluation Purposes Only) |
| MO #1 | Methane Data Outside of California | Cost of Methane Data Outside of California for the entire year of 2026 | $- | x 50 points |
| TOTAL MANDATORY OPTIONAL COSTS | $- |
4. Total Costs
| Total Costs | ||
| Bidder Name: | ||
| Tab | Cost | Weight (For Evaluation Purposes Only) |
| Tab #2 - Minimum Value of Contract | ERROR:#VALUE! | x 400 points |
| Tab #3 - Mandatory Optional | $- | x 50 points |
| Total Costs | ERROR:#VALUE! | x 450 points |
File details come from the government source that posted it. Updated .