BEAD_cost_sheet.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- 25NC0665 Broadband Equity, Access and Deployment (BEAD) Program Administration and Oversight
- Solicitation number
- 0000039982
- Issued by
- San Francisco County, San Francisco City, California
About this file
This is a cost sheet attachment for RFP 25NC0665, a Broadband Equity, Access, and Deployment (BEAD) grant administration and monitoring contract with the California Public Utilities Commission (CPUC). The contract encompasses 24 major task categories covering grant administration, compliance reporting, subgrant monitoring, milestone reimbursement processing, Buy American and Recovery Act (BABA) compliance monitoring, performance testing oversight, audit readiness assurance, contract administration, environmental and historic preservation, reporting support, risk management, subgrantee training, advisory services, grant management system alignment, guidance development, outreach events, GIS and broadband mapping, project planning reviews, field verification, broadband data validation, environmental compliance reviews, deployment activation, scope change management, and final reporting. Deliverables include semi-annual performance reports (12 required), quarterly desk reviews (480 required), monthly calls for high-risk subgrantees (576 required), final milestone disbursement processing (24 projects), compliance status reports (6 required), cybersecurity plan reviews (36 required), performance bond compliance support (24 subgrants), quarterly report reviews (864 required), subgrantee onboarding programs (20 required), deployment progress visualizations (24 quarters), and numerous hourly consulting services. The contract term is six years.
The cost sheet requires contractors to provide hourly rates for team members with specified job titles and to calculate total costs based on the required quantities for each deliverable. Specific hourly costs are not populated in the template, indicating bidders must propose their own rates. The spreadsheet includes placeholder amounts for travel budget and unanticipated tasks, with the latter set at $250,000.00 as a CPUC-determined amount that bidders cannot modify. This cost structure allows for flexible pricing while establishing fixed quantities for major deliverables and events, enabling the CPUC to evaluate proposals on both cost efficiency and resource allocation across the comprehensive six-year BEAD program administration.
View the file
Other files
Show all 11
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
Deliverable Cost Sheet
| RFP - 25NC0665 | |||||
| Attachment B-1 - Cost Sheet | |||||
| Instructions | Team Member | Team Member Name | Job Title | Hourly Rate | |
| Please refer to the details listed in the Scope of Work when completing this cost sheet. | |||||
| The Scope of Work contains any specific due dates and format requirements. | A | $ | |||
| B | $ | ||||
| AMOUNTS BASED ON A SIX YEAR TERM | C | $ | |||
| D | $ | ||||
| E | $ | ||||
| Task 1: Grant Administration, Compliance and Reporting | Unit of Measure | Cost Per Unit | Amount Required | Total Cost | |
| Deliverable 1.1 Semi-Annual Performance Report (SAR) Preparation | Per Report | 12 | |||
| Deliverable 1.2 Fraud, Waste and Abuse (FWA) Report Preparation | Per Report | 6 | |||
| Deliverable 1.3 Annual Comprehensive Report Prepartion | Per Report | 6 | |||
| Deliverable 1.4 Initial Report | Per Report | 1 |
| Task 2: Subgrant Monitoring and Oversight | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 2.1 Risk Assessment Development and Maintenance | Per Assessment | 480 | ||
| Deliverable 2.2 Quarterly Desk Reviews | Per Review | 480 | ||
| Deliverable 2.3 Monthly Conference Calls for Higher-Risk Subgrantees | Per Call | 576 | ||
| Deliverable 2.4 Corrective Action Plan Development and Tracking | Per Plan | 8 | ||
| Deliverable 2.5 Enforcement Actions Support | Per Hour |
| Task 3: Milestone Reimbursement Processing | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 3.1 Cost Reasonableness and Eligibility Validation | Per Hour | |||
| Deliverable 3.2 Payment Processing and GMS Workflow | Per Hour | |||
| Deliverable 3.3 Final Milestone Disbursement Processing | Per Project | 24 |
| Task 4: BABA Compliance Monitoring | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 4.1 Procurement Documentation Review | Per Hour | |||
| Deliverable 4.2 Manufacturer Certification Review | Per Hour | |||
| Deliverable 4.3 Waiver Request Evaluation and Coordination | Per Hour | |||
| Deliverable 4.4 Prohibited Equipment Screening | Per Hour |
| Task 5: Performance Measures and Testing Oversight | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 5.1 Performance Testing Framework Implementation | Per Framework | 1 | ||
| Deliverable 5.2 Remediation Plan Development | Per Hour |
| Task 6: Audit Readiness and Compliance Assurance | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 6.1 Monitoring of CPUC Internal Controls | Per Hour | |||
| Deliverable 6.2 BABA Audit Documentation | Per Hour | |||
| Deliverable 6.3 Compliance Status Report | Per Report | 6 | ||
| Deliverable 6.4 Subgrantee Audit Compliance Verification | Per Verification | 120 | ||
| Deliverable 6.5 Subgrantee Audit Tracking and Support | Per Hour | |||
| Deliverable 6.6 Cybersecurity and SCRM Plan Review | Per Review | 36 |
| Task 7: Subgrant Agreement and Contract Administration | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 7.1 Subgrant Agreement Development Support | Per Template | 1 | ||
| Deliverable 7.2 Letter of Credit and Performance Bond Compliance Support | Per Subgrant | 24 | ||
| Deliverable 7.3 Change Order Processing | Per Hour | |||
| Deliverable 7.4 Certification Collection and Tracking | Per Subgrant | 24 |
| Task 8: Environmental and Historic Preservation | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 8.1 NEPA/NHPA Compliance Program Plan | Per Plan | 1 | ||
| Deliverable 8.2 CEQA Compliance Support | Per Hour | |||
| Deliverable 8.3 Permitting Tracking and Agency Coordination | Per Hour | |||
| Deliverable 8.4 NEPA Project Area Division Support | Per Hour | |||
| Deliverable 8.5 Tribal Consent Tracking | Per Hour |
| Task 9: Reporting Support and Protocol Development | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 9.1 Reporting Protocol Development | Per Development | 1 | ||
| Deliverable 9.2 Subgrantee Reporting Package Development | Per Development | 1 | ||
| Deliverable 9.3 Quarterly and Monthly Report Review Support | Per Review | 864 | ||
| Deliverable 9.4 Federal Reporting Integration and Roll-Up | Per Report | 12 | ||
| Deliverable 9.5 Reporting Training | Per Hour |
| Task 10: Risk Management Implementation | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 10.1 Risk Management Implementation Guide | Per Guide | 1 | ||
| Deliverable 10.2 Risk Assessment Training | Per Training | 6 | ||
| Deliverable 10.3 Escalation and Decision Authority Matrix | Per Matrix | 1 |
| Task 11: Subgrantee Training and Technical Assistance | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 11.1 Subgrantee Onboarding Program | Per Onboarding | 20 | ||
| Deliverable 11.2 Ongoing Compliance Guidance | Per Hour | |||
| Deliverable 11.3 Technical Assistance for Award Administration | Per Hour | |||
| Deliverable 11.4 Subgrantee Communications and Scheduling | Per Hour |
| Task 12: Advisory Services | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 12.1 Policy and Regulatory Advisory | Per Hour | |||
| Deliverable 12.2 CPUC Proceedings Support | Per Hour | |||
| Deliverable 12.3 Post-Award Program Evaluation Report | Per Report | 1 |
| Task 13: GMS Alignment and Data Management | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 13.1 Grant Management System (GMS) development support and testing | Per Hour | |||
| Deliverable 13.2 Program Requirements Configuration | Per Hour | |||
| Deliverable 13.3 Broadband Mapping Data Coordination | Per Hour | |||
| Deliverable 13.4 Reporting Materials Production | Per Coordination | 12 | ||
| Deliverable 13.5 SAR Data Quality Assurance | Per Validation | 12 |
| Task 14: Grantee Guidance Enhancement and Development | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 14.1 Subgrantee-Facing Guidance Materials | Per Hour | |||
| Deliverable 14.2 Website and GMS Content Support | Per Hour | |||
| Deliverable 14.3 Subgrantee Guide to Oversight Monitoring and Reporting Maintanence | Per Hour |
| Task 15: Outreach and Events | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 15.1 In Person Events | Per Event | ? | ||
| Deliverable 15.2 Virtual Events | Per Event | ? |
| Task 16: GIS and Broadband Mapping | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 16.1 Location Analysis and Refinement | Per Hour | |||
| Deliverable 16.2 Deployment Progress Visualization | Per Quarter | 24 | ||
| Deliverable 16.3 Public Facing Maping Support | Per Hour |
| Task 17: Project Planing Desk Reviews | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 17.1 Perform engineering and programmatic reviews | Per Hour | |||
| Deliverable 17.2 Engineering review reports | Per Hour |
| Task 18: Field Verification, Development Monitoring and Technical Testing | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 18.1 On-Site Inspections | Per Inspection | ? | ||
| Deliverable 18.2 Site visit summaries | Per summary | ? | ||
| Deliverable 18.3 Oversee Subgrantee performance testing | Per Hour |
| Task 19: Broadband Location Data Validation | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 19.1 GIS analytics | Per Hour | |||
| Deliverable 19.2 Technical validation summaries | Per Hour |
| Task 20: NEPA Environmental Compliance Review | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 20.1 NEPA Review Reports | Per Hour | |||
| Deliverable 20.2 NEPA Compliance Assistance and Guidance | Per Hour | |||
| Deliverable 20.3 ESAPPT Coordination | Per Hour |
| Task 21: CEQA Environmental Compliance Review | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 21.1 CEQA Review Reports | Per Hour | |||
| Deliverable 21.2 CEQA Technical Assistance and Guidance | Per Hour |
| Task 22: Deployment Activation and Project Closeout Review | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 22.1 Documentation Review | Per Hour | |||
| Deliverable 22.2 Conduct Technical Field Verification of Completion | Per Hour | |||
| Deliverable 22.3 Project Closeout Report | Per Hour |
| Task 23: Post-Award Scope Changes | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 23.1 Change Support | Per Hour |
| Task 24: Final Report and Knowledge Transfer | Unit of Measure | Cost Per Unit | Amount Required | Total Cost |
| Deliverable 24.1 Final Report | Per Report | 1 |
| Travel Budget | CPUC Determined | Do Not Change | $ |
| Unanticipated Tasks | CPUC Determined | Do Not Change | $250,000.00 |
Total Proposal Cost:
File details come from the government source that posted it. Updated .