1 / 13

Excel Cost of Service Model

Excel Cost of Service Model. Detroit Edison Marty Heiser. Overview. Timeline Purpose of Cost of Service Unbundling Conventions Flow Diagram Features of the Model Overview of Reports Report Hierarchy Demonstration Questions. Timeline for COS Collaborative. Purpose of Cost of Service.

jkelvin
Download Presentation

Excel Cost of Service Model

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Cost of ServiceModel Detroit Edison Marty Heiser

  2. Overview • Timeline • Purpose of Cost of Service • Unbundling Conventions • Flow Diagram • Features of the Model • Overview of Reports • Report Hierarchy • Demonstration • Questions

  3. Timeline for COS Collaborative

  4. Purpose of Cost of Service • Allocate the Company’s revenue deficiency calculation to rate classes in a manner that reflects cost causation • Provide Jurisdictional split for ratemaking • Functionally split revenue requirement

  5. Unbundling Conventions • Model contains separate tabs for each function and one that totals results: • Production (includes transmission) • Distribution (includes customer service) • Total (sum of Production + Distribution) • Allocators • Production Excludes Electric Choice • Distribution Includes Electric Choice

  6. COS Flow Diagram 6

  7. Input 1 Worksheet

  8. Input 2 Worksheet

  9. Function Worksheet

  10. Features of the Model • Employs known and measurable (K&M) change approach for the test year. K&M changes are comprised of changes to Ratebase, Capital Structure, and Net Operating Income • WYSIWG (what you see is what you get) • Output from each tab (Total, Prod & Dist) consists of forty eight 4 page reports (192 pages each) • Standard Page size is 11 columns x 54 rows • Input cells are bold and shaded green in column D of the “Input1” tab • Internal allocation schedule calculations are performed in the Prod and Dist tabs • Rounding column checks to see that sum of allocated columns equals the total

  11. Overview of Reports 11

  12. Hierarchy of Reports 12

  13. Demonstration • Two versions • Section A Historic • Section B Test Year • Hypothetical Changes to Revenue Requirement • Ratebase • O&M

More Related