Cost Allocation Model Sensitivity to Changes in Inputs Unmetered Loads
This data provides insights into a cost allocation model's sensitivity to changes in inputs for unmetered loads, emphasizing key factors, background costs functionalization, input data on connection counts and demand, output revenue requirements, and scenario analyses. The visuals offer a clear overview and understanding of the model's dynamics.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Cost Allocation Model Sensitivity to Changes in Inputs Unmetered Loads
Overview Background Key Inputs in the as-filed model Key Outputs in the as-filed model Scenarios 3/12/2025 2
Background Costs are Functionalized at the Trial Balance level Within this assets are functionalized as providing bulk, primary or secondary service Each Trial Balance account has been assigned an allocator or pair of allocators Coincident Peak (CP) Non-Coincident Peak (NCP) Customer Count Connection Count Weighted Connection Count Composite Allocators Operating and Maintenance (O&M) Net Fixed Assets (NFA) 3/12/2025 3
Input Connection Counts Primary Secondary Residential 280,901 280,901 GS < 50 23,636 23,636 Large Use 12 0 3,703 3,703 Street Light (55,546 devices) (55,546 devices) USL 3,093 3,093 Total 314,809 311,415 3/12/2025 4
Input Weighting Factors Services Billing and Collecting Residential 1 1 GS < 50 2 2 Large Use 30 15 Street Light 1 1 USL 1 5 3/12/2025 5
Input Demand 4NCP 4CP Residential 2,109,703 1,901,782 GS < 50 636,235 600,259 Large Use 430,176 345,558 Street Light 54,445 9,539 USL 8,447 6,686 Total 6,054,862 5,449,865 3/12/2025 6
Output Revenue Requirement $ 94,436,258 19,093,962 5,754,313 1,183,502 470,639 168,173,609 Revenue To Cost Ratio 97.07% 114.37% 106.80% 74.82% 123.30% 100.00% Residential GS < 50 Large Use Street Light USL Total 3/12/2025 7
Scenario 1 - 55,546 SL connections (no daisy chain) Revenue Requirement $ 89,700,122 18,638,133 5,793,229 6,123,039 416,561 168,173,609 Revenue To Cost Ratio 101.96% 117.06% 106.10% 18.15% 138.73% 100.00% Residential GS < 50 Large Use Street Light USL Total 3/12/2025 8
Scenario 2 Zero SL services weighting factor Revenue Requirement $ 94,552,376 19,113,503 5,754,313 1,046,531 471,917 168,173,609 Revenue To Cost Ratio 96.96% 114.25% 106.80% 84.36% 123.33% 100.00% Residential GS < 50 Large Use Street Light USL Total 3/12/2025 9
Scenario 3 Zero SL billing and collecting weighting factor Revenue Requirement $ 94,437,329 19,094,141 5,754,314 1,182,072 470,639 168,173,609 Revenue To Cost Ratio 97.07% 114.36% 106.80% 74.89% 123.30% 100.00% Residential GS < 50 Large Use Street Light USL Total 3/12/2025 10
Scenario 4 50% SL Demand Reduction Revenue Requirement $ 94,569,736 19,141,244 5,778,675 789,254 470,949 168,173,609 Revenue : Cost 97.08% 114.25% 106.52% 80.91% 123.40% 100.00% Residential GS < 50 Large Use Street Light USL Total 3/12/2025 11
Scenario 5 55,546 SL connections (no daisy chain) and; 50% SL Demand Reduction Revenue Requirement $ 89,712,637 18,641,815 5,795,781 6,086,351 416,616 168,173,609 Revenue : Cost 102.09% 117.21% 106.21% 14.35% 138.92% 100.00% Residential GS < 50 Large Use Street Light USL Total 3/12/2025 12
Revenue Requirement allocated to Street Lighting (Total $168,173,609) Revenue Requirement $ Allocator Load Dispatching (Demand 12 CP and 4 NCP) Load Dispatching (Cust. Primary and Sec.) Overhead Lines ROW (Demand 4 NCP) Overhead Lines ROW (Cust. Pri. and Sec.) Administration (O&M) Administration (NFA) Depreciation PILS Interest Net Income Other Total 21,627 15,046 17,272 11,240 161,378 20,062 380,686 68,859 167,621 206,084 113,627 1,183,502 1815-1855D 1815-1855C 1830 & 1835 D 1830 & 1835 C O&M NFA ECC / NFA By assets NFA NFA NFA Various 3/12/2025 13
Distribution Plant Gross Assets allocated to Street Lighting (Total $1,121,693,636) Revenue Requirement $ 688,087 Allocator Distribution Station Equipment Primary Polls, towers (Demand) Primary Polls, towers (Customer) Primary UG Conduit (Demand) Primary UG Conduit (Customer) Primary UG Conductors (Demand) Primary UG Conductors (Customer) Line Transformers (Demand Related) Line Transformers (Customer Related) Services Other Distribution Plant PNCP4 PNCP4 CCP PNCP4 CCP PNCP4 CCP LTNCP4 CCLT CWCS Various 529,101 383,411 747,839 541,918 1,012,370 733,609 921,504 455,185 1,275,362 2,481,185 9,769,572 3/12/2025 14
