Separately posted on this site are the relevant materials supporting the proposed Metropolitan budget for fiscal years 2014/15 and 2015/16, and the proposed Metropolitan rates and charges for calendar years 2015 and 2016. Metropolitan has received a Public Records Act (PRA) request for the “database, inputs, outputs, spreadsheets, and reports used or prepared by Metropolitan staff or consultants in the development of the recommended rates, charges, surcharges, or fees.” Posted in this link are records responsive to this request (with proprietary formulas/code and employee-specific information removed), to the extent they are not already posted on this site. The link contains staff working materials, including drafts and calculations. Metropolitan’s budget-setting and rate-setting process is still in progress; additional records responsive to the PRA request will be added to the link in the future.
| Budget15_16 |
|
| Budget15_16.pdf |
5,170 KB |
| mjob001.xlsx |
95.1 KB |
| mjob002.xlsx.xlsx |
28.1 KB |
| MPAX808G.xlsx.xlsx |
32.7 KB |
| mpos001.xlsx.xlsx |
77.1 KB |
| RLAH228.xlsx.xlsx |
123.8 KB |
| |
|
Budget15_16\Budget_Notes |
|
| Budget15_16-Budget_Notes.pdf |
294,077 KB |
| |
|
Budget15_16\Test |
|
| Budget15_16-Test.pdf |
11,323 KB |
| |
|
FY2015 & FY2016 Budget |
|
| 6-30-13 Plant Assets Info _SK.xls.xlsx |
210.6 KB |
| Capacity Charge CY2015 Dec'13.xls.xlsx |
37.8 KB |
| Capacity Charge CY2015 Mar'14.xls.xlsx |
37.8 KB |
| CC_Tool_CY2015_Dec'13 temp.xlsx.xlsx |
7272.0 KB |
| CC_Tool_CY2015_Dec'13.xlsx.xlsx |
7264.6 KB |
| CC_Tool_CY2015_Mar'14.xlsx.xlsx |
7261.8 KB |
| CIP Jan 2014.xlsx.xlsx |
227.8 KB |
| Class_comp between budget yrs.xlsx |
47.1 KB |
| Conveyance Monthly PeakCoincidents 2013.xlsx.xlsx |
267.2 KB |
| Copy of CC-Data-Dec2013.xlsx.xlsx |
6208.5 KB |
| Copy of CC-Data-Mar2014.xlsx.xlsx |
6210.1 KB |
| Copy of FY1415-MWD-ER Table 5 Estimated Standby Charge to Dennis.xlsx.xlsx |
22.7 KB |
| Copy of RTS-Mar2014.xlsx.xlsx |
13.1 KB |
| FY2015 & FY2016 Budget.pdf |
26,023 KB |
| HR PCN data as of 09_11_13.xlsx.xlsx |
226.6 KB |
| New NBV Model 2013 v2.xlsx.xlsx |
5336.8 KB |
| New NBV Model 2013.xlsx.xlsx |
5237.6 KB |
| New NBV Model 2014 Jan 1a.xlsx.xlsx |
5106.8 KB |
| New NBV Model 2014 Jan.xlsx.xlsx |
4857.5 KB |
| peak factors 2013.xlsx.xlsx |
10.9 KB |
| RTS MASTER - 2015_dec'13.xls.xlsx |
117.5 KB |
| RTS MASTER 2015_Mar14.xls.xlsx |
117.5 KB |
| RTS-Dec2013.xlsx.xlsx |
11.5 KB |
| Team_Budgeting_EList_130903.xlsx.xlsx |
42.3 KB |
| Team_Budgeting_EList_130925.xlsx.xlsx |
29.0 KB |
| Team_Budgeting_EList_130925_r1.xlsx.xlsx |
29.1 KB |
| Team_Budgeting_EList_131014.xlsx.xlsx |
29.2 KB |
| Team_Budgeting_EList_131106.xlsx.xlsx |
29.0 KB |
| Team_Budgeting_EList_140129.xlsx.xlsx |
29.1 KB |
| |
|
FY2015 & FY2016 Budget\Proposed and Final |
|
| Actual FTEs for 1314.xls.xlsx |
138.7 KB |
| Additive Calc FY2014 from Controller.xlsx.xlsx |
28.8 KB |
| Budget by Group - Review.xlsx.xlsx |
119.0 KB |
| COLA est.xlsx.xlsx |
8.0 KB |
| Dept O&M Pivo5 2014 2015 2016 v2.xlsx.xlsx |
1969.0 KB |
| FY 14 & 15 additive analysis.xlsx.xlsx |
141.8 KB |
| FY 15 O&M increase explanation.xlsx.xlsx |
8.6 KB |
| I drive Access.xlsx.xlsx |
12.9 KB |
| IBMS Access.xlsx.xlsx |
25.1 KB |
| IT Reorg.xlsx.xlsx |
9.5 KB |
| Labor Estimate as of Aug 2013.xlsx.xlsx |
276.8 KB |
| OM Budget FY 2015 2016 v3.xlsx.xlsx |
336.5 KB |
| OM Budget FY 2015 2016 v4.xlsx.xlsx |
345.7 KB |
| OM Budget FY 2015 2016 v5.xlsx.xlsx |
744.0 KB |
| Scorecard_Proposed.xls.xlsx |
25.3 KB |
| WSO_OE_Unidentifed.xlsx.xlsx |
11.7 KB |
| |
|
FY2015 & FY2016 Budget\Proposed and Final\CIP |
|
| FY2015 & FY2016 Budget-Proposed and Final-CIP.pdf |
19,525 KB |
| |
|
FY2015 & FY2016 Budget\Proposed and Final\Communications |
|
| FY2015 & FY2016 Budget-Proposed and Final-Communications.pdf |
21,219 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Departmental Data |
|
| BA MWDSoCal 13-09-18 OPEB 6-30-11 Val Final Results.pdf |
13,817 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Departmental Data\GDR |
|
| FY2015 & FY2016 Budget-Proposed and Final--Departmental Data-GDR.pdf |
77,695 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Docs |
|
| Capital Financial Summary 1516.xlsx.xlsx |
10.8 KB |
| Capital Financial Summary 1516_ES rev.xlsx.xlsx |
11.7 KB |
| FY2015 & FY2016 Budget-Proposed and Final-Docs.pdf |
26,134 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Extracts |
|
| Capital Labor.xlsx.xlsx |
72.9 KB |
| Departmental OM 2015_16-v01.xls.xls |
9455.5 KB |
| Departmental OM 2015_16-v02.xls.xls |
9476.5 KB |
| PCN Extracts.xlsx |
2993.6 KB |
| RJ Query.xlsx.xlsx |
6728.6 KB |
| Template.xlsx.xlsx |
725.6 KB |
| Vacancy Factors.xlsx.xlsx |
31.6 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data |
|
| BDCP Budget (high case from v14) - v2.xlsx.xlsx |
44.5 KB |
| BDCP Budget (high case from v14) - v3.xlsx.xlsx |
140.5 KB |
| Leases.xlsx.xlsx |
13.7 KB |
| Sales Data.xlsx.xlsx |
8.6 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data\CFO |
|
| Debt Serive changes from Eric G on 9-30-13 -- FY 2014_2015 Budget-Debt Changes.xlsx.xlsx |
11.4 KB |
| Interest rate from Eileen on 10-2-13 -- budgproj.xls.xlsx |
132.1 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data\ES |
|
| Final CIP from Tobin on 1-8-14 -- Prioritized CIP - for Finance - v2.xlsx.xlsx |
94.9 KB |
| Final CIP from Tobin on 1-8-14 -- Prioritized CIP - for Finance.xlsx.xlsx |
92.8 KB |
| FINAL FY2015 FY2016 CIP 1-15-2014 -with FY2024.xlsx.xlsx |
2832.8 KB |
| FINAL FY2015 & FY2016 CIP 1-15-2014.xlsx.xlsx |
2833.7 KB |
| Prelim CIP from Kim on 12-30-14 - v2.xlsx.xlsx |
160.5 KB |
| UPDATED - Final CIP from Tobin on 1-8-14 -- Prioritized CIP - for Finance - v2.xlsx.xlsx |
114.8 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data\WRM |
|
| CVWD 35 TAF PwrRate for-2014-2030.xlsx.xlsx |
134.1 KB |
| FY2015 & FY2016 Budget-Proposed and Final-GDR Data-WRM.pdf |
8,467 KB |
| Lib_SWP with Variance Explanation.xlsx.xlsx |
194.9 KB |
| LRP from Frances Kwan on 10-10-13 - 2013 LRP Projections Workbook Budget Summary 100713 - for REVENUE REQUIREMENTS - FINAL.xlsx.xlsx |
28.2 KB |
| Oct 21_2013_CR Program_Matusak Yu Hasencamp jpm comments.xlsx.xlsx |
2236.2 KB |
| Rev by DCR to Copy of Lib_SWP with Variance Explanation for the CFO.xlsx.xlsx |
256.7 KB |
| Sales from Mike T on 10-10-13 - Sales Model 23 Total 1-yr inc 2050 NO GROWTH 101013 - v2.xlsx.xlsx |
472.6 KB |
| Sales from Mike T on 10-10-13 - Sales Model 23 Total 1-yr inc 2050 NO GROWTH 101013.xlsx.xlsx |
16.0 KB |
| SWP from Ayo on 10-10-13 - FY 2015 and FY2016 SWP Prelim Budget & Rev Req Accrual Basis for Arnout (RJ) - v2.xlsx.xlsx |
152.5 KB |
| SWP from Ayo on 10-10-13 - FY 2015 and FY2016 SWP Prelim Budget & Rev Req Accrual Basis for Arnout (RJ).xlsx.xlsx |
84.3 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data\WRM\detailed sales from Mike Ti on 12-12-13 |
| All MAs Sales Model 23 Rev Req 1-yr inc 2050 FINAL REV REQ.xlsx.xlsx |
246.1 KB |
| ForecastedMonthlyDeliveries_byProgram_RevenueRqmts_2013-10_v2 - v2.xlsx.xlsx |
472.6 KB |
| ForecastedMonthlyDeliveries_byProgram_RevenueRqmts_2013-10_v2.xlsx.xlsx |
474.5 KB |
| Revenue Requirements IRPSIM Base Case 10-14-13.xls.xlsx |
2658.3 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data\WSO |
|
| 2013 WSO actuals + forecast.xlsx.xlsx |
2611.0 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data\WSO\10-1-2013 runs |
|
| Monthly Normal CY 2014 Router CRA 915 TAF 50% SWP 20130910 (Scenario 2) Budget.xlsm.xlsx |
273.0 KB |
| Monthly Normal CY 2015 Router CRA 915 TAF 50% SWP 20130910 (Scenario 2) Budget.xlsm.xlsx |
273.3 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\GDR Data\WSO\10-2-2013 runs |
|
| CY 2014 and CY 2015 for Finance - v2.xlsx.xlsx |
26.4 KB |
| CY 2014 and CY 2015 for Finance.xlsx.xlsx |
25.3 KB |
| Monthly Normal CY 2014 Router CRA 915 TAF 50% SWP 20130910 (Scenario 2) Budget.xlsm.xlsx |
273.1 KB |
| Monthly Normal CY 2015 Router CRA 915 TAF 50% SWP 20130910 (Scenario 2) Budget.xlsm.xlsx |
273.3 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Labor |
|
| Additive Rate 10 Yr Est to 2024_v1.xlsx.xlsx |
26.4 KB |
| Additive Rate 10 Yr Est to 2024_v2 jms.xlsx.xlsx |
26.7 KB |
| Additive Rate Est 2012_13_14_v3.xlsx.xlsx |
26.5 KB |
| Additive Rate Est 2014_15_16_v1.xlsx.xlsx |
28.8 KB |
| Additive Rate Est 2014_15_16_v2.xlsx.xlsx |
28.8 KB |
| Additive Rate Est 2014_15_16_v3.xlsx.xlsx |
28.9 KB |
| Additve change check for OPEB chg.xlsx.xlsx |
9.8 KB |
| Capital Labor Dist check.xlsx.xlsx |
67.1 KB |
| Class_Comp FYE 14 vs 15.xlsx |
140.3 KB |
| Medicare and PERS 7 perc pickup info.xlsx.xlsx |
8.9 KB |
| PCN's in Labor Hist by PPE.xlsx.xlsx |
27.9 KB |
| Personal Summary check v2.xlsx.xlsx |
69.9 KB |
| Personal Summary check.xlsx.xlsx |
48.8 KB |
| Team_Budgeting_Data_Master_Prelim_DB.XLSX |
911.9 KB |
| Vacancies 12_09_13 (2) from HR.xlsx.xlsx |
161.1 KB |
| Vacant PCN to be added.xlsx.xlsx |
15.1 KB |
| WSO Labor Alloc chgs 12_18_13.xlsx.xlsx |
12.8 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\models |
|
| 1.8MAF sales forecast from SM - v170.xlsx.xlsx |
918.7 KB |
| BACKUP COPY -- FPM - v738m.xlsm.xlsx |
8,504 KB |
| Budget Link -v118m.xlsm.xlsx |
736.3 KB |
| Budget Link -v119m Proposed.xlsm.xlsx |
740.0 KB |
| Budget Link -v120m.xlsm.xlsx |
740.4 KB |
| Change in required Reserves from FPM754m.xlsx.xlsx |
10.6 KB |
| Change in Reserve Display.xlsx.xlsx |
19.2 KB |
| Change in supply rate FPM-764.xlsx.xlsx |
33.7 KB |
| Copy of Budget Link -v118m temp.xlsm.xlsx |
722.5 KB |
| Copy of FPM - v727m SK.xlsm.xlsx |
8187.8 KB |
| Draft Supply Program inc from Deven 2-26-2014.xlsx.xlsx |
27.8 KB |
| DSM - v69.xlsm.xlsx |
2352.5 KB |
| DSM - v70.xlsm.xlsx |
2351.3 KB |
| DSM - v71.xlsm.xlsx |
2348.5 KB |
| FPM - v761m.xlsm.xlsx |
14363.6 KB |
| FPM - v762m.xlsm.xlsx |
14111.7 KB |
| FPM - v763m - 0% & 1.5% with details.xlsm.xlsx |
13899.3 KB |
| FPM - v763m - 3% increase.xlsm.xlsx |
13899.1 KB |
| FPM - v763m - no fixed Ptax - v2 with detailed rates.xlsm.xlsx |
13891.7 KB |
| FPM - v763m - no fixed Ptax.xlsm.xlsx |
13894.9 KB |
| FPM - v763m - zero increase.xlsm.xlsx |
13895.1 KB |
| FPM - v763m Proposed.xlsm.xlsx |
13895.8 KB |
| FPM - v764m - 0% & 1.5%, lower SWP wo WMF.xlsm.xlsx |
13910.4 KB |
| FPM - v764m - 0% & 1.5%, lower SWP.xlsm.xlsx |
14047.5 KB |
| FPM - v764m - 0% & 1.5%.xlsm.xlsx |
13908.9 KB |
| FPM - v764m - no fixed Ptax - 1.5% & 1.5%.xlsm.xlsx |
13904.1 KB |
| FPM - v764m - no fixed Ptax.xlsm.xlsx |
13907.7 KB |
| FPM - v764m.xlsm.xlsx |
13918.3 KB |
| FY2015 & FY2016 Budget-Proposed and Final-models.pdf |
24,966 KB |
| O&M Budget Tool - v23 used for Overhead Calc.xlsx.xlsx |
2139.3 KB |
| O&M Budget Tool - v28.xlsx.xlsx |
2154.4 KB |
| O&M Budget Tool - v29.xlsx.xlsx |
2082.4 KB |
| O&M Budget Tool - v30 used for Proposed.xlsx.xlsx |
22800.8 KB |
| O&M Budget Tool - v31 - updated additive rate.xlsx.xlsx |
2100.0 KB |
| Rate Link - v50m - 2015.xlsx.xlsx |
133.2 KB |
| Rate Link - v50m - 2016.xlsx.xlsx |
98.7 KB |
| Rate Link - v50m.xlsx.xlsx |
139.4 KB |
| SM - v171.xlsm.xlsx |
5858.0 KB |
| SM - v172 - 1.75MAF - v2 - used for Proposed - temp for treated by month.xlsm.xlsx |
5856.7 KB |
| SM - v172 - 1.75MAF - v2 - used for Proposed.xlsm.xlsx |
5846.4 KB |
| SM - v172 - 1.75MAF.xlsm.xlsx |
5847.3 KB |
| Supply Programs from VCM - v285 1.75MAF used for proposed.xlsx.xlsx |
5445.7 KB |
| SWP from FPM-762m.xlsx.xlsx |
44.0 KB |
| TR-RTS-CC 2014.xlsx.xlsx |
110.7 KB |
| VCM - v284.xlsm.xlsx |
5103.1 KB |
| VCM - v285 1.75MAF - power only.xlsm.xlsx |
962.4 KB |
| VCM - v285 1.75MAF used for proposed.xlsm.xlsx |
5100.8 KB |
| VCM - v286 scenario E (JS).xlsm.xlsx |
5093.5 KB |
| VCM - v286.xlsm.xlsx |
5098.0 KB |
| VCM - v287 - lower SWP alloc.xlsm.xlsx |
5115.3 KB |
| WRM Sales Forecast - v1.xlsx.xlsx |
10.1 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\models\6 Scenarios for 1-2-14 |
|
| FPM - v753m - 1a.xlsm.xlsx |
8582.5 KB |
| FPM - v753m - 1b.xlsm.xlsx |
8579.1 KB |
| FPM - v753m - 2a.xlsm.xlsx |
8580.5 KB |
| FPM - v753m - 2b.xlsm.xlsx |
8584.9 KB |
| FPM - v753m - 3a.xlsm.xlsx |
8582.7 KB |
| FPM - v753m - 3b.xlsm.xlsx |
8581.3 KB |
| FY2015 & FY2016 Budget & Rates 1-2-14 - v2.pdf |
5,587 KB |
| SM - v171.xlsm.xlsx |
5858.3 KB |
| SM - v172 - 1.75MAF.xlsm.xlsx |
5847.0 KB |
| VCM - v284.xlsm.xlsx |
5103.1 KB |
| VCM - v285 1.75MAF.xlsm.xlsx |
5101.1 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Presentations |
|
| FY2015 & FY2016 Budget-Proposed and Final-Presentations.pdf |
36,892 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Presentations\February 10 Workshop #1 |
| FI Feb 2014 8-1 Biennial Budget v2.pdf |
25,238 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Presentations\February 25 Workshop #2 |
| FY2015 & FY2016 Budget-Proposed and Final-Presentations-February 25 Workshop #2.pdf |
30,483 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Presentations\March 10 Workshop #3 |
| FY2015 & FY2016 Budget-Proposed and Final-Presentations-March 10 Workshop #3.pdf |
34,152 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Presentations\March 11 Public Hearing |
| FY2015 & FY2016 Budget-Proposed and Final-Presentations-March 11 Public Hearing.pdf |
16,816 KB |
| |
|
| FY2015 & FY2016 Budget\Proposed and Final\Presentations\old |
| FY2015 & FY2016 Budget-Proposed and Final-Presentations-old.pdf |
159,303 KB |
