|
6.G. - Page 191 of 238
<br />1 Total expenditure only included amount up to the Unused Balance.
<br />2 Expenditures under projects CUW392 and CU W710 were re -allocated to various projects. As a result, 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 5.05E.
<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 exceed 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 lune 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 />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 2011B. Asa 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 mainly for street light maintenance.
<br />Page 3 of 5
<br />REVISED ATTACHMENT K-5 522
<br />(E)=(El)+(Ea)+
<br />(1)=(A) -(e) -(E)- IG)
<br />(A, (B) (D)=(A)-(B)-(C)
<br />(El)
<br />(E2)
<br />(E3)
<br />(E4)
<br />(ES)
<br />E6)
<br />(E3)+(E4)+(ES)+(E6)
<br />(F)=(C)+(D)-(E) (G) (H)
<br />(1)
<br />(H)-(1)
<br />Unexpended
<br />Appropriation
<br />Balances of
<br />Transfer Out
<br />Appropriation after
<br />through Closeout
<br />DEOBLIGATE /
<br />Closeout and
<br />Appropriation YTD Expenditures PTD Expenditures Encumbrances Available Balance
<br />Expenditures
<br />in
<br />Encumbrances Process
<br />OBLIGATION
<br />Deobligate
<br />Project Praiett Title Fund Tyne
<br />5ubfund Classification As of lune 30, 2009 As of lune 30, 2009 As of June 30, 20119 As of June 30, 2009 As of lune 30, 2009
<br />FY 2009-10
<br />FY 2010.11
<br />FY 201L 12Y
<br />2012-13
<br />FY 2013-14
<br />YTD FY 2014-15
<br />Total Expenditures
<br />Unused Balance As of lune 30, 2015 As of June 30, 2015
<br />As of June 30, 2015
<br />As of lune 30, 2015
<br />Pooled Interest Rate in FY 2010-11
<br />(DDD3)
<br />1.249.
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Pooled Interest Rate in FY 2011.12
<br />(DDD2)
<br />1.11%
<br />1.119,
<br />-
<br />-
<br />-
<br />Pooled Interest Rate in FY 2012-13
<br />(DDD3)
<br />0.859/0
<br />0.859K
<br />0.85%
<br />Pooled Interest Rate in FY 2013-14
<br />(DDD4)
<br />0.663%
<br />0.663%
<br />0.663%
<br />0.663%
<br />Estimated Pooled Interest Rate in FY 2014-15 (as of March 31, 2015)
<br />(DDDS)
<br />0.499%
<br />0-499%
<br />0-49991
<br />0-499%
<br />0-499%
<br />0-499%
<br />Interest Amount in FY 2010-11
<br />(EEE3) _ (CCC) x (DDD3)
<br />$
<br />25,884
<br />$ - $
<br />- $
<br />-
<br />$ -
<br />$
<br />$ 25,884
<br />Interest Amount in FY 2011.12
<br />(EEE2) _ (CCC) x (DDD2)
<br />$
<br />23,171
<br />$ 5,978 $
<br />- $
<br />-
<br />$ -
<br />$ -
<br />$ 29,148
<br />Interest Amount in FY 2012-13
<br />(EEE3) _ (CCC) x (DDD3)
<br />$
<br />17,743
<br />$ 4,577 $
<br />1,006 $
<br />-
<br />$ -
<br />$ -
<br />$ 23,327
<br />InterestAmount in FY 2013-14
<br />(EEE4) a (CCC) x (DDD4)
<br />$
<br />13,840
<br />$ 3,570 $
<br />785 $
<br />277
<br />$ -
<br />$ -
<br />$ 18,195
<br />Estimated Interest Amount in FY2014-15 (as of March 31, 2015)
<br />(EEES) _ (CCC) x (DDDS)
<br />$
<br />10,416
<br />$ 2,687 $
<br />591 $
<br />209
<br />$ 106
<br />$ 27
<br />$ 13,694
<br />Balance due from Wholesale Customers
<br />(FFF)=(CCC)+(EEE3)+(EEE2)+(EEE3)+(EEE4)+(EEES)
<br />$
<br />2,178,506
<br />$ 555,338 $
<br />120,777 $
<br />42,279
<br />$ 21,384
<br />$ 5,538
<br />$ 2,923,204
<br />Notes:
<br />1 Total expenditure only included amount up to the Unused Balance.
<br />2 Expenditures under projects CUW392 and CU W710 were re -allocated to various projects. As a result, 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 5.05E.
<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 exceed 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 lune 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 />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 2011B. Asa 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 mainly for street light maintenance.
<br />Page 3 of 5
<br />REVISED ATTACHMENT K-5 522
<br />
|