|
Page 3 of 5
<br />(A) (B) ICJ (D) = (A) -(8)-(C)
<br />Appropriation YTD Expenditures PTO Expenditures Encumbrances Available Balance
<br />Pooled Interest Rate in FY 2010-11
<br />Pooled Interest Rate in FY 2011-12
<br />Pool&d Interest Rate in FY 2012-13
<br />Pooled Interest Rate in FY 2013-14
<br />Estimated Pooled Interest Rate in FY 2014-15 (as of March 31, 2015}
<br />Interest Amount in FY 2010-11
<br />Interest Amount in FY 2011-12
<br />Interest Amount in FY 2012-13
<br />Interest Amount in FY 2013-14
<br />Estimated Interest Amount in FY 2014-15 (as of March 31, 2015}
<br />(DDD1)
<br />(DDD2)
<br />(DDD3)
<br />(DDD4)
<br />(DDD5)
<br />ClassifiCiltion
<br />(EEEl) = (CCC} x (DDD1)
<br />(EEE2) = (CCC} x (DDD2)
<br />(EEE3) = (CCC} x (DDD3)
<br />(EEE4) = (CCC) x (DDD4)
<br />(EEE5) = (CCC) x (DDD5)
<br />As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009
<br />Balance due from Wholesale Customers (FFF) =(CCC}+ (EEEl) + (EEE2) + (EEE3) + (EEE4) + (EEE5)
<br />1 Total expenditure only included amount up to the Unused Balance.
<br />2 Expenditures under projects CUW392 and CUW710 were re-allocated to various projects. As a resutt, there are zero balance in expenditures for these projects.
<br />3 Project CUW690 -Customer Care & Billing System will be specially allocated due to limit to Customer Services % (2%} in WSA contract section S.OSE.
<br />4 There is a difference in Appropriation Balance as of March 31, 2009 vs. June 30, 2009.
<br />5 Actual expenditures exceed available fund balance, assume the exc..d expenditures are from encumbrances.
<br />6 This project has been closed out as of June 6, 2013.
<br />7 This project is split 64.3%/35. 7%, Joint/City} per Revised Attachment K-2.
<br />8 This project has been closed out as of June 30, 2012.
<br />9 Project is included as part of the revenue funded capital project.
<br />10 Project is included as part of the Water Enterprise revenue bond funded capital project.
<br />(E) = (El) + (E 2) +
<br />�-�(E_1�) ----�(E_2)�---�(�E3�)----�(E_4�)----�(E _5�) ----�(E_6�) -� (E3)+(E4)+(ES) + (E6)
<br />Expenditures in
<br />FY 2009-10 ��-_;FY�2�0�1;;0-;,:1,:.l _ _;F,;,Y,,:2;;0=11�-=12:,_L_l _,:,FY,:,,:,20;;;1�2;;;-13:;;,__JIL;,.FY;,.2;;;0;,:1;;;3-;;;1;;:4'"""11_,YT=D=FY=2=014-==1=5:..I Tot.I Expenditures
<br />1.24%
<br />1.11% 1.11%
<br />0.85% 0.85% 0.85%
<br />0.663% 0.663% 0.663% 0.663%
<br />0.499% 0.499% 0.499% 0.499% 0.499% 0.499%
<br />$ 25,884 $ $ $ $ $ $ 25,884
<br />$ 23,171 $ 5,978 $ $ $ $ $ 29,148
<br />$ 17,743 $ 4,577 $ 1,006 $ $ $ $ 23,327
<br />$ 13,840 $ 3,570 $ 785 $ 277 $ $ $ 18,195
<br />$ 10,416 $ 2,687 $ 591 $ 209 $ 106 $ 27 $ 13,694
<br />$ 2,178,506 $ 555,338 $ 120,777 42,279 $ 21,384 $ 5,538 $ 2,923,204
<br />(F) = (C) + (D) -(E)
<br />Unused Balance
<br />11 Projects CUH975 and CUH977 were funded by revenue in FY 2009-10 and FY 2010-11. However, starting: in FY 2011-12, these two projects were funded by Water Revenue Bond Series 20118. As a result, Wholesale Customers were refunded $10,838,326 ($10,519,682 collected in FY 2009-10 and FY 2010-11 plus interest of $318,644) in FY 2011-12.
<br />12 Intentionally left blank.
<br />13 There is a difference in Appropriation Balance as of March 31, 2009 vs. June 30, 2009.
<br />14 Per discussion with Carlos Jacobo, project CUH810 is a custom work project and should be "POWER" not "JOINT'. These custom works are mainfy for street light maintenance.
<br />(G)
<br />Encumbrances
<br />(H)
<br />Appropriation
<br />Transfer Out
<br />through Closeout
<br />Process
<br />(I)
<br />DEOBLIGATE/
<br />OBLIGATION
<br />As of June 30, 2015 As of June 30, 2015 As of June 30, 2015
<br />(J) = (A) -(B)-(E)-(G)
<br />(H)-(1) Unexpended
<br />Balances of
<br />Appropriation after
<br />Closeout and
<br />Deobligate
<br />As of June 30, 2015
<br />REVISED ATTACHMENT K-5
|