2024_IE_Reporting_Template.xlsx
XLSX spreadsheet 87 KB Posted
- Attached to
- Job Order Contract Phase 39-41 (JOC)
- Solicitation number
- 0000033725
- Issued by
- Shasta County, California
About this file
This is a reporting template spreadsheet for Independent Evaluator (IE) assessments of electrical corporation Wildfire Mitigation Plan (WMP) initiatives. The template consists of five tabs: Overview, Catalog of Initiatives, Data Requests, SME Interviews, and List of Failed-to-Fund Initiatives. The document provides a structured format for tracking and evaluating various WMP initiatives, including their descriptions, targets, progress, validation methods, and financial details.
The example initiative shown demonstrates the tracking of a pole replacement program with a target of 14,850 poles. The initiative had an actual completion of 15,850 poles with a 97.50% sample validation rate based on 400 inspections. While the physical target was exceeded, the program was underspent at $1.435 million versus a planned $2.507 million budget (43% under budget). The initiative failed to meet its risk reduction goals as poles were replaced in lower-risk areas, resulting in only 30% of intended risk mitigation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Bid_Packet.pdf | ||
| RFQ_5PA4K00178.01_-_Redding_Training_Center_-_Fire_Props_2.pdf | ||
| STD_204.pdf | ||
| std1000.pdf | ||
| Bidder_Instructions.pdf | ||
| 2023Mar6Form74R3_(7).pdf | ||
| Darfur_Certification_CAL_FIRE-720_.pdf | ||
| gspd05-106.pdf | ||
| 2024_IE_ARC_Outline.pdf | ||
| 2024_IE_Sample_size_calculator.xlsx | XLSX spreadsheet | |
| 2024-12_Meeting_Notice_Independent_Evaluator_RFQ.pdf | ||
| 2024_IE_RFQ_Attachments_B_to_E.xlsx | XLSX spreadsheet | |
| 2024_IE_RFQ.pdf | ||
| 2024_IE_RFQ_Attachment_A.docx | DOCX document | |
| 2024_IE_RFQ_Q_A_Summary.pdf |
Show all 15
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
Tab 1 - Overview tab IE ARC Attachments
Independent Evaluator:
Electrical Corporation:
Legends
| Tab 1 | Overview Tab - Instructions and overview |
| Tab 2 | Catalog of Initiatives - Initiative review and funding compliance of all initiatives |
| Tab 3 | Data Requests - Comprehensive list of documents reviewed |
| Tab 4 | SME Interviews - Summary of interviews conducted |
| Tab 5 | List of Failed-to-Fund Initiatives - All initiatives funded less than 100% |
Tab 2 - Catalog of Initiatives Catalog of Initiatives
Independent Evaluator:
| Electrical Corporation: | ||||||||||||||||
| WMP Category | Initiative Tracking ID | WMP Section Number | Initiative Name | Initiative Type | WMP - Initiative Description | WMP - Initiative Target | EC-Claimed Progress (Q4 QDR) | EC-Claimed Progress (EC ARC) | EC-Claimed Progress | |||||||
| Kopunova, Sara: Number of "actuals" from which samples are selected | EC-Claimed Initiative Status | Target Not Met - Rationale | Sample Size (#) | Sample Validation Rate (%) | Verification Method | Initiative Validation Rate (%) | IE Finding on Initiative | WMP - Planned Spend ($) | EC-Claimed Actual Spend ($) | Variance (%) | Funding discrepancy - finding | Funding discrepancy - detail | Satisfied Risk Reduction Goal - finding | Satisfied Risk Reduction Goal - detail | ||
| Grid Design Operations and Maintenance | WMP.972 | 8.1.2.1 | Pole replacement | Focus & field verifiable | Replace 14850 poles | 14,850 | 15,850 | 15,840 | 15,850 | Target met | N/A | 400 | 97.50% | Field inspection | ||
| SAP notification (DR064) | 104% | Initiative validated | $ 2,507,000.00 | $ 1,435,000.00 | -43% | Underspend | Due to fewer resource hours charging to the program than initially anticipated in 2021, resulting in lower costs incurred | No | Poles were replaced in lower-risk areas, reducing overall risk mitigation | <-- Example | ||||||
| Grid Design Operations and Maintenance | WMP.550 | 8.1.5 | Lightning arrestor replacement | Focus & non-field verifiable | Replace 2216 arrestors | 2,216 | 1,500 | 1,490 | 1,490 | Target not met | Initiative faced delays in permit processing due to staff turnover | 120 | 83% | Field inspection | ||
| SAP work order (DR082) | 56% | Initiative not validated | $ 3,407,000.00 | $ 4,000,888.00 | 15% | Overspend | Due to lower remediations, driven by a lower find rate and execution limitations due to internal exceptions | No | EC did not meet its target by >30% and did not meet its intended risk reduction | <-- Example | ||||||
| Vegetation Management and Inspections | VM-04 | 8.2.3 | QA/QC for vegetation management inspections | Non-focus & non-field verifiable | Inspect 35 lines miles for vegetation | 35 | 35 | 35 | 35 | Target met | N/A | 35 | 100% | QA/QC documentation (DR034) | ||
| SME interview (SME02) | 100% | Initiative validated | $ 3,150,987.00 | $ 3,149,987.00 | 0% | No discrepancy | N/A | Yes | N/A | <-- Example |
Tab 3 - Data Requests Data Requests
Independent Evaluator:
| Electrical Corporation: | ||||||
| Date Sent | Date Response Received | Section / Initiative | Data Request Number | List of Documents Received | ||
| 5/1/24 | 5/3/24 | 8.1.2.1 - GH-01 | DRU 13535 | DRU13535 Redacted Attachments (ZIP) | ||
| DRU13535 Audit Independent | <-- Example |
Tab 4 - SME Interviews SME Interviews
Independent Evaluator:
| Electrical Corporation: | |||||
| Interview date | Section / Initiative | SME interview number | Positions interviewed | Summary of interview | |
| 5/1/24 | 8.1.2.1 - GH-01 | SME001 | Director of Wildfire Mitigation | Overview of funding verification with slide presentation covering financial assumptions; cost model assmption; major elements of cost models; planning order fields; and overview of 2023 spend high-level drivers | <-- Example |
Tab 5 - List of "Fail-to-Fund" List of Failed-to-Fund Initiatives
Independent Evaluator:
| Electrical Corporation: | |||
| WMP Category | WMP Section Number | WMP Page Number | Initiative Tracking ID |
Kopunova, Sara: Kopunova, Sara:
| If applicable since some commitments occur outside of initiatives | Initiative Name | WMP - Planned Spend ($) | EC-Claimed Actual Spend ($) | Variance (%) | ||||||
| Grid Design Operations and Maintenance | 8.1.2.3 | 87 | SH-01 | Pole replacement | $ 10,000.00 | $ 9,000.00 | 10% | <-- Example |
image1.jpeg image2.jpeg
File details come from the government source that posted it. Updated .