Find Your Local Water Agency

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.

Part 1:

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

Part 2:

CFO Part 2  

8-1_Board_Letter_and_Attachments.pdf

48,801 KB

2014 March Public Hearing Notice - Rates correct.pdf

35 KB

Alt B.pdf

4,659 KB

Att 3_Biennial Budget Summary.pdf

8,185 KB

Att 4 FY2014-15 COS opt 1.pdf`

3,103 KB

Att 5 FY2015-16 COS opt 1.pdf

1,680 KB

Att 6 FY2014-15 COS opt 2.pdf

3,138 KB

Att 7 FY2015-16 COS opt 2.pdf

1,691 KB

Att 8 FY2014-15 COS opt 3.pdf

3,159 KB

Att 9 FY2015-16 COS opt 3.pdf

1,676 KB

Att 10_ Budget Ten Year Forecast.pdf

8,750 KB

Att 11 EngRep (2of2).xlsx

149 KB

Att 11 RatesReso 2015_16.pdf

558 KB

Att 12 EngRep (2of2).pdf

3,162 KB

Att 12 EngRep (2of2).xlsx

148 KB

Att 12 RTS2015 (1of2).pdf

2,349 KB

Att 13 CC2015.pdf

1,704 KB

Budget Link -v121m.xlsx

2,102 KB

Budget-Rate Calendar FY15-FY16 140227.pdf

284 KB

Budget-Rate Calendar FY15-FY16 140320.pdf

227 KB

CEQA.pdf

28 KB

Engineer's seal.pdf

604KB

FPM - v764m - 0.75% & 1.25%.xlsx

14,721 KB

FPM - v766m - April Proposed.xlsx

14,926 KB

MAM 031414.pdf

9,522 KB

March 11 Public Hearing.pdf

2,755 KB

March 11 Suspending the tax rate limitations.pdf

6,473 KB

O&M Budget Tool - v31 - updated additive rate.xlsx

1,973 KB

PH ad 2-28-14 LAtimes.pdf

1,523 KB

PH ad correct.pdf

1,331 KB

Rate Link - v51m - 2015 - opt 3.xlsx

120 KB

Rate Link - v51m - 2016 - opt 3.xlsx

120 KB

Script - Public Hearing Mar 2014.pdf

80 KB

table rate options.xlsx

15 KB

table revreq options.xlsx

16 KB

TR-RTS-CC 2014 v2.xlsx

124 KB

updated slides 3-11-14.pdf

1,368 KB

   
F&I Board Letter 8-1 dated 2014-04-08  

Board Letter 8-1 2014-04-08.pdf

61,885 KB

Underlying Materials