IRR 2018 Sch B-3A F.Z22.XLSM

12/13/2019

CENTRAL VALLEY PROJECT

SCHEDULE OF IRRIGATION VOLUNTARY PAYMENT AND SURPLUS APPLICATION FOR FISCAL YEAR 2018

A B C D E F G H I J K L

Voluntary Payments Applied to Adjustment to Revenue

Deficit Construction Grand Total Total

Facility/Contractor Prior Year Current Year 30-day window Total Repayment to Sch. B-1 PUE Deficit Refund Other To Sch B-1

ref (B+C+D) (E+F) (H+I+J+K)

Corning Canal

Corning WD 2/ $ 550,925.49 $ - $ - $ 550,925.49 $ 550,925.49 $ - $ - $ - $ - $ -

Corning WD 1/ $ - $ 969.90 $ - $ 969.90 $ 969.90 $ - $ - $ - $ - $ -

$ 550,925.49 $ 969.90 $ - $ 551,895.39 $ - $ 551,895.39 $ - $ - $ - $ - $ -

Cow Creek Unit

Bella Vista WD $ 35,377.70 $ - $ - $ 35,377.70 $ 35,377.70 $ - $ - $ - $ - $ -

Cross Valley Canal

Lower Tule River ID $ - $ - $ - $ - $ - $ - $ - $ (119,527.24) $ - $ (119,527.24)

Pixley ID $ - $ - $ - $ - $ - $ - $ (102,863.23) $ - $ (102,863.23)

$ - $ - $ - $ - $ - $ - $ - $ - $ (222,390.47) $ - $ (222,390.47)

Delta Mendota Canal

Banta-Carbona ID $ - $ - $ - $ - $ - $ - $ - $ (41,147.72) $ - $ (41,147.72)

Panoche WD $ - $ - $ - $ - $ - $ - $ - $ (25,687.54) $ - $ (25,687.54)

San Luis WD 8/ $ - $ - $ - $ - $ - $ - $ - $ - $ (21,660.39) $ (21,660.39)

West Stanislaus ID 7/ $ - $ 1,935.00 $ - $ 1,935.00 $ 1,935.00 $ - $ - $ - $ - $ -

West Stanislaus ID 7/ $ - $ 15,870.00 $ - $ 15,870.00 $ 15,870.00 $ - $ - $ - $ - $ -

West Stanislaus ID 7/ $ - $ 120.00 $ - $ 120.00 $ 120.00 $ - $ - $ - $ - $ -

West Stanislaus ID 6/ $ - $ - $ - $ - $ - $ - $ - $ - $ (1,876.38) $ (1,876.38)

Total Delta Mendota Canal $ - $ 17,925.00 $ - $ 17,925.00 $ - $ 17,925.00 $ - $ - $ (66,835.26) $ (23,536.77) $ (90,372.03)

Friant Kern Canal - Class 1

Exeter ID 2/ $ 104,920.60 $ - $ - $ 104,920.60 $ 104,920.60 $ - $ - $ - $ - $ -

Garfield WD 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Hills Valley ID 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Schedule B-3A

Page 1 of 4
IRR 2018 Sch B-3A F.Z22.XLSM

12/13/2019

CENTRAL VALLEY PROJECT

SCHEDULE OF IRRIGATION VOLUNTARY PAYMENT AND SURPLUS APPLICATION FOR FISCAL YEAR 2018

A B C D E F G H I J K L

Voluntary Payments Applied to Adjustment to Revenue

Deficit Construction Grand Total Total

Facility/Contractor Prior Year Current Year 30-day window Total Repayment to Sch. B-1 PUE Deficit Refund Other To Sch B-1

ref (B+C+D) (E+F) (H+I+J+K)

Ivanhoe ID 2/ $ 26,144.35 $ - $ - $ 26,144.35 $ 26,144.35 $ - $ - $ - $ - $ -

Lindmore ID 13/ $ - $ - $ - $ - $ - $ - $ - $ (353,869.37) $ (1,828.75) $ (355,698.12)

Lower Tule River ID $ - $ - $ - $ - $ - $ - $ - $ (687,294.18) $ - $ (687,294.18)

Kern Tulare WD 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Saucelito ID 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Southern San Joaquin MUD 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Tea Pot Dome WD $ - $ - $ - $ - $ - $ - $ - $ (56,993.65) $ - $ (56,993.65)

Terra Bella ID 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Tri-Valley ID 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Tulare ID $ - $ - $ - $ - $ - $ - $ - $ (318,641.55) $ - $ (318,641.55)

Total Friant Kern Canal - Class 1 $ 131,064.95 $ - $ - $ 131,064.95 $ - $ 131,064.95 $ - $ - $(1,416,798.75) $ (1,828.75) $(1,418,627.50)

Friant Kern Canal - Class 2

Fresno ID 9/ $ - $ - $ - $ - $ - $ - $ - - $ (19,036.05) $ (19,036.05)

Lindmore ID $ - $ - $ - $ - $ - $ - $ - (7,591.22) $ - $ (7,591.22)

Lower Tule River ID $ - $ - $ - $ - $ - $ - $ - (83,849.32) $ - $ (83,849.32)

Shafter-Wasco ID 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Southern San Joaquin MUD 2/ $ 66,401.45 $ - $ - $ 66,401.45 $ 66,401.45 $ - $ - - $ - $ -

Tulare ID $ - $ - $ - $ - $ - $ - $ - (48,937.20) $ - $ (48,937.20)

Total Friant Kern Canal - Class 2 $ 66,401.45 $ - $ - $ 66,401.45 $ - $ 66,401.45 $ - $ - $ (140,377.74) $ (19,036.05) $ (159,413.79)

Hidden Unit 

Madera ID - HU $ - $ - $ - $ - $ - $ - $ (289,780.31) $ - $ (289,780.31)

Total Hidden Unit $ - $ - $ - $ - $ - $ - $ - $ - $ (289,780.31) $ - $ (289,780.31)

Madera Canal - Class 1

Madera ID - MC $ - $ - $ - $ - $ - $ - $ (986,952.14) $ - $ (986,952.14)

Total Madera Canal - Class 1 $ - $ - $ - $ - $ - $ - $ - $ - $ (986,952.14) $ - $ (986,952.14)

Madera Canal - Class 2

Madera ID - MC $ - $ - $ - $ - $ - $ - $ - $ (64,610.71) $ - $ (64,610.71)

Sacramento River - Willows

Jansen, P & S $ 1,500.00 $ - $ - $ 1,500.00 $ - $ 1,500.00 $ - $ - $ - $ - $ -

Lomo CS & Micheli, J 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Natoma Central MWC 2/ $ 75,339.25 $ - $ - $ 75,339.25 $ 75,339.25 $ - $ - $ - $ - $ -

Pelger MWC 2/ $ 40,063.85 $ - $ - $ 40,063.85 $ 40,063.85 $ - $ - $ - $ - $ -

Pelger MWC 12/ $ - $ - $ - $ - $ - $ - $ - $ (13,653.51) $ (13.39) $ (13,666.90)

Pleasant Grove Verona MWC 2/ $ - $ - $ - $ - $ - $ - $ - $ (34,592.97) $ - $ (34,592.97)

Princeton-Codora-Glen ID 2/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Princeton-Codora-Glen ID 3/ $ - $ - $ - $ - $ - $ - $ - $ - $ (23,143.01) $ (23,143.01)

Reclamation 1004 $ - $ - $ - $ - $ - $ - $ - $ - $ (109,168.87) $ - $ (109,168.87)

Tisdale Irr & Drain Co $ 50,000.00 $ - $ - $ 50,000.00 $ - $ 50,000.00 $ - $ - $ - $ - $ -

Total Sacramento River - Willows $ 166,903.10 $ - $ - $ 166,903.10 $ - $ 166,903.10 $ - $ - $ (157,415.35) $ (23,156.40) $ (180,571.75)

Schedule B-3A

Page 2 of 4
IRR 2018 Sch B-3A F.Z22.XLSM

12/13/2019

CENTRAL VALLEY PROJECT

SCHEDULE OF IRRIGATION VOLUNTARY PAYMENT AND SURPLUS APPLICATION FOR FISCAL YEAR 2018

A B C D E F G H I J K L

Voluntary Payments Applied to Adjustment to Revenue

Deficit Construction Grand Total Total

Facility/Contractor Prior Year Current Year 30-day window Total Repayment to Sch. B-1 PUE Deficit Refund Other To Sch B-1

ref (B+C+D) (E+F) (H+I+J+K)

San Luis Canal - Fresno

Westlands WD $ - $ - $ - $ - $ - $ - $ - $ - $ (81,076.82) $ - $ (81,076.82)

Westlands DD#2 $ - $ - $ - $ - $ - $ - $ - $ - $ (21,869.81) $ - $ (21,869.81)

Total San Luis Canal - Fresno $ - $ - $ - $ - $ - $ - $ - $ - $ (102,946.63) $ - $ (102,946.63)

San Luis Canal - Tracy

Pacheco WD 10/ $ - $ - $ - $ - $ - $ - $ - $ - $ (51,132.72) $ (45.77) $ (51,178.49)

Panoche WD $ - $ - $ - $ - $ - $ - $ - $ - $ (72,776.00) $ - $ (72,776.00)

Total San Luis Canal - Tracy $ - $ - $ - $ - $ - $ - $ - $ - $ (123,908.72) $ (45.77) $ (123,954.49)

Tehama Colusa Canal

Colusa County WD $ - $ - $ - $ - $ 670,400.00 $ 670,400.00 $ - $ - $ - $ - $ -

Colusa County WD 11/ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 582,126.33 $ 582,126.33

Glide WD 4/ $ - $ - $ - $ - $ - $ - $ - $ - $ (103,959.07) $ (1,575.55) $ (105,534.62)

Kanawha WD 5/ $ - $ - $ - $ - $ - $ - $ - $ - $ (350,987.59) $ (29,592.46) $ (380,580.05)

Orlan-Artois WD $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ 670,400.00 $ 670,400.00 $ - $ - $ (454,946.66) $ 550,958.32 $ 96,011.66

 Grand Total $ 950,672.69 $ 18,894.90 $ - $ 969,567.59 $ 670,400.00 $ 1,639,967.59 $ - $ - $(4,026,962.74) $ 483,354.58 $(3,543,608.16)

Schedule B-3A

Page 3 of 4
IRR 2018 Sch B-3A F.Z22.XLSM

12/13/2019

CENTRAL VALLEY PROJECT

SCHEDULE OF IRRIGATION VOLUNTARY PAYMENT AND SURPLUS APPLICATION FOR FISCAL YEAR 2018

A B C D E F G H I J K L

Voluntary Payments Applied to Adjustment to Revenue

Deficit Construction Grand Total Total

Facility/Contractor Prior Year Current Year 30-day window Total Repayment to Sch. B-1 PUE Deficit Refund Other To Sch B-1

ref (B+C+D) (E+F) (H+I+J+K)

Footnotes:

1/ ARRA overpayment applied

2/ Overpayments can be refunded or applied to water charges.

Total Included in Applied to Applied to Applied to 

Payment FY 2018 Water Restoration TPUD Refund Overpayment

Corning WD $ 743,230.01 $ 550,925.49 $ 12,123.58 $ 711.96 $ 273.30 $ - $ 179,195.68

Kern Tulare WD $ 207,417.64 $ - $ - $ - $ - $ - $ 207,417.64

Exeter ID $ 121,525.00 $ 104,920.60 $ - $ - $ - $ - $ 16,604.40

Garfield WD $ 34,416.96 $ - $ - $ - $ - $ - $ 34,416.96

Hills Valley ID $ 355.00 $ - $ - $ - $ - $ - $ 355.00

Ivanhoe ID $ 60,465.00 $ 26,144.35 $ - $ - $ - $ - $ 34,320.65

Saucelito ID $ 52,812.00 $ - $ - $ - $ - $ - $ 52,812.00

So San Joaquin MUD $ 981,755.00 $ - $ - $ - $ - $ - $ 981,755.00

Terra Bella ID $ 60,328.00 $ - $ - $ - $ - $ - $ 60,328.00

Tri-Valley ID $ 977.00 $ - $ - $ - $ - $ - $ 977.00

Shafter- Wasco ID -CL2 $ 17,723.33 $ - $ - $ - $ - $ - $ 17,723.33

So San Joaquin MUD -CL2 $ 81,244.00 $ 66,401.45 $ - $ - $ - $ - $ 14,842.55

Lomo CS & Micheli, J $ 1,296.73 $ - $ - $ - $ - $ - $ 1,296.73

Natomas Central MCW $ 166,213.35 $ 75,339.25 $ - $ - $ - $ - $ 90,874.10

Pelger MWC $ 52,844.05 $ 40,063.85 $ - $ - $ - $ - $ 12,780.20

Pleasant Grove Verona MWC $ 1,826.91 $ - $ - $ - $ - $ - $ 1,826.91

Princeton Codora Glenn ID $ 60,000.00 $ - $ 60,000.00 $ - $ - $ - $ -

3/ Applied $23,143.01 surplus to Water and Restoration ($10,462.46 and $12,680.55 respectively).

4/ $ 1,575.55 is applied to water.

5/ $ 29,592.46 is applied to water.

6/ A portion of O&M surplus applied to water ($433.65), restoration ($1,441.23) and TPUD ($1.50).

7/ Included in FY 2018 Annual Accounting Analysis as CY VP but applied to PY deficit.

8/ Applied to water.

9/ Surplus applied to restoration ($19,036.05)

10/ $45.77 is applied to FY 2018 M&I O&M deficit.

11/ $633,946.75 (PUE DP surplus applied to capital repayment) minus $30,841.50 (O&M surplus applied to water) and $20,978.92 (O&M surplus applied to Irrigation Restoration)

12/ Surplus applied to water ($13.39)

13/ Surplus applied to water ($289.15) and restoration ($1,539.60)

Schedule B-3A

Page 4 of 4