M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

A B C D E F G H 

Delivered Water Unused Water Rescheduled Water 

Facility/Contractor

 CY PY 

Chargeable Chargeable Contract 

Acre Feet Acre Feet Charges

Chargeable Contract

Acre Feet Charges 

Chargeable Contract

Acre Feet Charges 

 O

Cha

Ref <WDR> <WDR> <WDR> <WDR> <WDR> <WDR> <W

Black Butte D & R

County of ColusaElk Creek CSDUS Forest Service - BBWhitney Const.

Clear Creek Unit

Clear Creek CSD

Contra Costa Canal

Contra Costa WD 

Cow Creek Unit

Bella Vista WD

Cross Valley Canal

County of FresnoCounty of Tulare

Total CV Canal

62

10

-

19

-

-

-

-

-

$ $ $ $ 

150.00

- 

454.07

- 

- $ -

- $ -- $ -

- $ -

- $ - $ - $ - $ 

- $ - $ - $ - $ 

29

2,425

117,748

6,126

-

-

-

-

(5,192)

132

--

$ $ $ $ $ $ 

604.07

111,001.15

1,943,237.11

244,658.82

- - 

- $ -

- $ -

- $ -

- $ -

- $ -- $ -

- $ - $ - $ - $ - $ - $ 

- $ - $ - $ - $ - $ - $ 

- - $ - - $ - - $ - $ 
M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

A B C D E F G H 

Delivered Water Unused Water Rescheduled Water 

Facility/Contractor

 CY PY 

Chargeable Chargeable Contract 

Acre Feet Acre Feet Charges

Chargeable Contract

Acre Feet Charges 

Chargeable Contract

Acre Feet Charges 

 O

Cha

Ref <WDR> <WDR> <WDR> <WDR> <WDR> <WDR> <W

Delta-Mendota Canal

Byron Bethany ID 831 - $ 18,140.78 - $ - - $ - $ 

City of Tracy 7,416 2,000 $ 284,457.36 - $ - - $ - $ 

Del Puerto WD 9 - $ 178.64 - $ - 2 $ 34.88 $ 

Department of VA 33 128 $ 8,486.31 - $ - - $ - $ 

Panoche WD - DMC 18 - $ 388.46 - $ - 6 $ 125.28 $ 

San Luis WD - DMC 3 - $ 45.00 - $ - 85 $ 1,275.00 $ 

Total DM Canal 8,310 2,128 $ 311,696.55 - $ - 93 $ 1,435.16 $ 

Folsom D & R

City of Roseville 31,486 - $ 472,754.68 - $ - - $ - $ 

El Dorado ID - FD&R 3,080 - $ 46,200.00 - $ - - $ - $ 

Placer County WA - - $ - - $ - - $ - $ 

Sacramento County WA 1,200 - $ 29,602.95 - $ - - $ - $ 

San Juan WD 749 - $ 12,606.99 - $ - - $ - $ 

Total Folsom D & R 36,515 - $ 561,164.62 - $ - - $ - $ 

Folsom-South Canal

East Bay MUD - - $ - - $ - - $ - $ 

Sacramento County WA-FSC - - $ - - $ - - $ - $ 

Sacramento MUD 295 - $ 5,510.60 24,593 $ 518,682.57 - $ - $ 

Total FS Canal 295 - $ 5,510.60 24,593 $ 518,682.57 $ - $ - $ 

Friant Dam

County of Madera - 7 $ 156.87 - $ - 21 $ 470.61 $ 

Fresno County WW #18

Total Friant Dam

95 (22) $ 1,095.00 - $ - - $ - $ 

95 (15) $ 1,251.87 - $ - 21 $ 470.61 $ 
M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

A B C D E F G H 

Delivered Water Unused Water Rescheduled Water 

Facility/Contractor

 CY PY 

Chargeable Chargeable Contract 

Acre Feet Acre Feet Charges

Chargeable Contract

Acre Feet Charges 

Chargeable Contract

Acre Feet Charges 

 O

Cha

Ref <WDR> <WDR> <WDR> <WDR> <WDR> <WDR> <W

Friant-Kern Canal

Arvin Edison WSDCity of FresnoCity of LindsayCity of Orange CoveDelano-Earlimart IDLindsay-Strathmore IDShafter-Wasco IDTerra Bella ID

571

32,545

934

915

298

441

379

1,029

-

-

-

85

---

-

$ $ $ $ $ $ $ $ 

9,420.98

1,313,823.29

20,171.38

19,268.99

4,470.006,615.005,685.00

15,435.00

-

-

--

---

-

$ $ $ $ $ $ $ $ 

- ---- - -- 

-

48

1,050

439

--

50

-

$ $ $ $ $ $ $ $ 

-

1,735.20

19,351.50

6,988.02

--

750.00

-

$ $ $ $ $ $ $ $ 

Total FK Canal

New Melones D & R

Stockton East

Sacramento River

City of Redding - SR City of West SacramentoLake California P.O.A.Meyer Crest Ltd.Riverview Golf & CC

37,112

40,540

1,5219,180

200

230

25

85

---

---

$ $ $ $ $ $ $ 

1,394,889.64

723,922.15

22,815.00

137,700.00

3,000.003,452.30

375.00

-

-

960

---

-

$ $ $ $ $ $ $ 

-- 

14,400.00

- - - - 

1,587

-

-

----

$ $ $ $ $ $ $ 

28,824.72

------

$ $ $ $ $ $ $ 

Total Sacramento River

San Felipe Unit

SB County WD - IBSC Valley WD - IB

Total SF Unit

11,156

5,996

94,927

---

$ $ $ 

167,342.30240,259.25

3,177,245.82

960

-

-

$ $ $ 

14,400.00

- - 

-

--

$ $ $ 

---

$ 

$ $ 672

 100,923 - $ 3,417,505.07 - $ - - $ - $ 672
M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

A B C D E F G H 

Delivered Water Unused Water Rescheduled Water 

Facility/Contractor

 CY PY 

Chargeable Chargeable Contract 

Acre Feet Acre Feet Charges

Chargeable Contract

Acre Feet Charges 

Chargeable Contract

Acre Feet Charges 

 O

Cha

Ref <WDR> <WDR> <WDR> <WDR> <WDR> <WDR> <W

San Luis Canal - Fresno

City of AvenalCity of CoalingaCity of HuronState of CA

2,002

4,2181,013

5

--

5

-

$ $ $ $ 

91,163.10

319,114.51102,057.12

96.92

- $ -- $ -- $ -- $ -

----

$ $ $ $ 

----

$ $ $ $ 

6

Westlands WD 2,204 - $ 68,955.16 - $ - - $ - $ 9

Total SLC - Fresno 9,442 5 $ 581,386.81 - $ - - $ - $ 16

San Luis Canal - Tracy

Pacheco WD - SLC 12 - $ 721.93 - $ - - $ - $ 

Panoche WD - SLC 64 - $ 1,687.89 - $ - 10 $ 237.10 $ 

San Luis WD - SLC 203 - $ 5,958.05 - $ - 381 $ 11,182.35 $ 

Total SLC - Tracy 279 - $ 8,367.87 - $ - 391 $ 11,419.45 $ 

Shasta Dam

Centerville CSD 875 - $ 21,953.11 - $ - - $ - $ 

Mountain Gate CSD 809 - $ 13,984.25 - $ - - $ - $ 

Shasta CWA 204 - $ 4,387.63 - $ - - $ - $ 

Total Shasta Dam 1,888 - $ 40,324.99 - $ - - $ - $ 

Spring Creek Conduit

City of Redding - SCC 5,478 - $ 93,289.36 - $ - - $ - $ 

Shasta CWA - SCC 185 - $ 4,354.30 - $ - - $ - $ 

Shasta CSD 669 - $ 10,593.33 - $ - - $ - $ 

Total SC Conduit 6,332 - $ 108,236.99 - $ - - $ - $ 

Tehama-Colusa Canal

Colusa County WD 177 - $ 4,762.87 - $ - - $ - $ 

Kanawha WD

Total Tehama-Colusa Canal

11 - $ 474.22 - $ - - $ - $ 

188 - $ 5,237.09 - $ - - $ - $ 
M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

A B C D E F G H 

Delivered Water Unused Water Rescheduled Water 

Facility/Contractor

 CY PY 

Chargeable Chargeable Contract 

Acre Feet Acre Feet Charges

Chargeable Contract

Acre Feet Charges 

Chargeable Contract

Acre Feet Charges 

 O

Cha

Ref <WDR> <WDR> <WDR> <WDR> <WDR> <WDR> <W

Toyon Pipeline

City of Redding - TP

City of Shasta Lake US Forest Service - TP

28

891

-

9

-

-

$ 555.00$ 29,628.63$ - 

-

-

-

$ $ $ 

- - - 

---

$ $ $ 

---

$ $ $ 

Total Toyon Pipeline 919 9 $ 30,183.63 - $ - - $ - $ 

Total Permanent Contractors 380,322 (2,848) $ 9,656,521.33 25,553 $ 533,082.57 2,092 $ 42,149.94 $ 689Temporary Rate RevenueWarren Act ContractorsSection 215 RevenueRescheduling Fee Incremental Revenue

44,765

25,097

919

-

--

-

-

$ 433,055.71$ 469,985.16$ 7,085.49

$ - 

4,120

--

-

$ $ $ $ 

37,080.00

- - -

8

---

$ $ $ $ 

168.72

--

15,325.14

$ 12$ 

$ $ 

Direct Pumping Capital

Conveyance CapitalConveyance Pumping O'NeillConveyance Pumping Dos AmigosDirect Pumping O&MConveyance Pumping O&M O&M

Non-Project Water Contractors

Los Vaqueros Water Right

Grand Total

-

-

- 

-

-

15,807

20,113

-----

-

5,180

$ 3,501.54

$ 810.12$ 1,024.26

$ 1,691.22

$ - 

$ 571.68$ 70,443.87$ 230,646.31

-

-

--

-

-

-

$ $ $ $ $ $ $ 

- - - - - - - 

-------

$ $ $ $ $ $ $ 

-------

$ $ $ $ $ $ $ 

487,023 2,332 $ 10,875,336.69 29,673 $ 570,162.57 2,100 $ 57,643.80 $ 701
M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

FY 2013 NET RESULTS OF OPERATIONS RECONCILIATION

Water Revenues

Total Revenues per Financial Statement Schedule 21 $ 

Less: Interest and Other Revenues (F/S Sch. 21)

Interest on Investment (0214) $ 1,497,467.44

Interest on Investment (0921) San Felipe Unit Repayment Contracts $ 8,010,886.15Mature Val Con-Not Def. San Felipe Unit $ 8,314,998.97San Luis Delta Mendota WA $ 1,344,886.56

$ 

Less:

Voluntary payments and Refunds included in prior year accounting plus voluntary payments for repayment contracts and ARRA 2 $ 159,106.65

FBMS Adjustments (Abnormal Balance in Advance Account) 2 $ (1,612,562.47)

Prior year adjustments included in prior year Sch. B-2 2 $ 1,109,447.51

Prior year adjustments included in prior year Sch. B-2 (not shown on current year WDR) 2 $ (2,294,220.04)

Incremental Revenues transferred o irrigation (Sch. B-2, Incremental Rev worksheet) $ 153,956.08

$ 

Less: 2013 Voluntary Payments (Sch. B-3A)

City of Roseville (Construction Repayment) - included in final accounting $ 126,294.39Sacramento County WA - FSC (PY O&M Deficit) - included in final accounting $ 860,853.73City of Shasta Lake - applied to 2013 O&M $ 16,462.83

$ 

Add:

Incremental revenues transferred from irrigation (Sch. B-2 Incremental Rev worksheet) $ 7,560.45Correction to PY charges included in CY accounting (Adj to BORWORKS/FBMS not needed) 2 $ 70,698.81

CY & PY charges and adjustments in CY accounting but will be recorded in FBMS in 2014 2 $ 812,898.83

Santa Clara Valley WD BDCP O&M Fund $ 672,570.54

$ 

Grand Total Revenues per Schedule B-2 $ 
M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

FY 2013 NET RESULTS OF OPERATIONS RECONCILIATION

Less:

Temporary Rate Revenues Applied to O&M Expense (see Page 5) $ 482,611.01

Warren Act Contractor Revenues (see Page 5) $ 469,985.16Rescheduling Fee Applied to Storage Capital (see Page 5) $ 15,325.14Non-Project Water Revenues (see Page 5) $ 70,443.87Los Vaqueros Water Right Revenues (see Page 5) $ 230,646.31Nonstorable Proj. 215 Water Revenues (see Page 5) $ 7,085.49Incremental Revenue Applied to Conveyance Pumping O&M (see page 5) $ 571.68Incremental Revenue Applied to Capital (see page 5) $ 7,027.14

$ 

Total Permanent Contractor Revenues $ Expenses

O&M Expenses Per Financial Statement, Schedule 22 (Schedule B-6, Page 6) $ 10,220,072.42Other Adjustments to Expense (See Sch B-6, Page 6) $ 994,609.84 Adjusted Total O&M Expenses $ 11,214,682.26Direct Billed Conveyance (Schedule B-6, Page 4) $ 245,146.26Direct Billed Conveyance Pumping (Schedule B-6, Page 5) $ 2,062,446.41

Total Direct Billed $ 2,307,592.67

Less: Net O&M Expense $ Less: Less: Interest on Investment (See Sch. B-1) $ FY 2013 Results of Operations $ Less: Charge Adjustments (See Sch. B-1) $ Add: Voluntary Payments (See Sch. B-3A) $ Less: Construction Recovery (See Sch. B-1) $ Less: Deficit Recovery (See Sch. B-1) $ Less: ARRA Repayment (See Sch. B-1) $ 

Net FY 2013 Results of Operations $ 
M&I 2013 Sch B-2 F.Z17.XLSM

12/17/2014

CENTRAL VALLEY PROJECT

SCHEDULE OF FY 2013 M&I WATER CHARGES

FY 2013 NET RESULTS OF OPERATIONS RECONCILIATION

Footnotes

1/ Other charges include transportation charges, BDCP O&M Fund (Santa Clara Valley WD), and incremental charges 

for Direct Pumping O&M cost incurred through the transfer of water in fiscal year 2013.

2/ See Excel file "2013 M&I Revenue Reconciliation to FFS".