2024_IE_Reporting_Template.xlsx
XLSX spreadsheet 87 KB Posted
- Solicitation number
- 0000033649
- Issued by
- Sacramento County, San Diego City, California
About this file
This is an Independent Evaluator (IE) reporting template spreadsheet for electrical corporation Wildfire Mitigation Plan (WMP) initiative tracking and validation. The template consists of five tabs: Overview, Catalog of Initiatives, Data Requests, SME Interviews, and List of Failed-to-Fund Initiatives. The document includes a detailed example of pole replacement initiative WMP.972, which had a target of replacing 14,850 poles and achieved 15,850 replacements, exceeding the original goal by approximately 6.7%.
The financial aspects show a planned spend of $2,507,000 with actual spend of $1,435,000, resulting in a 43% underspend due to fewer resource hours charged to the program than initially anticipated in 2021. Despite exceeding the quantity target, the initiative did not meet its intended risk reduction goals, as poles were replaced in lower-risk areas, resulting in only 30% of the planned risk mitigation. The validation process included field inspection of 400 samples with a 97.50% sample validation rate, leading to an overall initiative validation rate of 104%.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 24-270_Q_and_A.pdf | ||
| 24-270_Addendum__1_Letter.pdf | ||
| 24-270_SB_Solicitation.pdf | ||
| 2024_IE_RFQ_Attachments_B_to_E.xlsx | XLSX spreadsheet | |
| 2024_IE_Sample_size_calculator.xlsx | XLSX spreadsheet | |
| 2024_IE_RFQ_Attachment_A.docx | DOCX document | |
| 2024_IE_RFQ.pdf | ||
| 2024_IE_ARC_Outline.pdf | ||
| 2024-12_Meeting_Notice_Independent_Evaluator_RFQ.pdf | ||
| 2024_IE_RFQ_Q_A_Summary.pdf | ||
| RFP_P_DRR24051_Solicitation_Link.docx | DOCX document | |
| 24-272_Addendum__1_Letter.pdf | ||
| 24-272_IFB_W_Adden__2.pdf | ||
| 24-272_Addendum__2_Letter.pdf | ||
| 24-272_IFB.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 .