City of Roseville
<br />Cash Reserve Levels
<br />Operating Funds
<br />Fund
<br />Police Vehicles & Equipment
<br />Fire Vehicles & Equipment
<br />Parks & Rec Vehicles & Equipment
<br />Public Works Vehicles & Equipment
<br />Central Svcs. Equipment
<br />Vehicle Replacement
<br />Fire Vehicle Replacement
<br />Equipment Replacement
<br />Attachment B
<br />Target Actual $$ Over $$ Amount
<br />Pct. Pct. (Under) Unrestricted
<br />40% 48% $ 999,707 $ 5,864,386
<br />25% 9% (630,127) 346,089
<br />40% 16% (247,451)
<br />20% 145% 459,097 -
<br />20% 8% (148,447) 101,199
<br />20% 58% 431,286 657,391
<br />50% 0% (3,501,375) -
<br />50% 37% (626,546) -
<br />50% 136% 1,644,558 -
<br />50% 30% (105,104) -
<br />50% 91% $ 168,167 $ 375,242
<br />$ (1,556,234) $ 7,344,307
<br />Capital Replacement Funds
<br />Estimated
<br />Fund
<br />2011
<br />2012
<br />General
<br />$ 5,864,386
<br />$ 5,964,386
<br />Parks & Recreation
<br />321,089
<br />346,089
<br />Community Development
<br />163,163
<br />173,163
<br />Communications
<br />521,444
<br />532,444
<br />Information Technology
<br />109,199
<br />101,199
<br />License Center
<br />598,391
<br />657,391
<br />Water
<br />-
<br />-
<br />Sanitary Sewer
<br />1,694,303
<br />1,792,303
<br />Storm Sewer
<br />2,614,527
<br />2,599,527
<br />Recycling
<br />136,342
<br />157,342
<br />Golf Course
<br />$ 391,242
<br />$ 375,242
<br />$
<br />Total $ 12,414,086
<br />$ 12,699,086
<br />Fund
<br />Police Vehicles & Equipment
<br />Fire Vehicles & Equipment
<br />Parks & Rec Vehicles & Equipment
<br />Public Works Vehicles & Equipment
<br />Central Svcs. Equipment
<br />Vehicle Replacement
<br />Fire Vehicle Replacement
<br />Equipment Replacement
<br />Attachment B
<br />Target Actual $$ Over $$ Amount
<br />Pct. Pct. (Under) Unrestricted
<br />40% 48% $ 999,707 $ 5,864,386
<br />25% 9% (630,127) 346,089
<br />40% 16% (247,451)
<br />20% 145% 459,097 -
<br />20% 8% (148,447) 101,199
<br />20% 58% 431,286 657,391
<br />50% 0% (3,501,375) -
<br />50% 37% (626,546) -
<br />50% 136% 1,644,558 -
<br />50% 30% (105,104) -
<br />50% 91% $ 168,167 $ 375,242
<br />$ (1,556,234) $ 7,344,307
<br />Capital Replacement Funds
<br />$$ Amount
<br />(Under)
<br />Target
<br />Actual
<br />2011
<br />2012
<br />Pct.
<br />Pct.
<br />$ 133,242 $
<br />141,242
<br />n/a
<br />n/a
<br />368,041
<br />377,041
<br />n/a
<br />n/a
<br />25,358
<br />39,358
<br />n/a
<br />n/a
<br />204,329
<br />220,329
<br />n/a
<br />n/a
<br />93,928
<br />24,928
<br />n/a
<br />n/a
<br />n/a n/a
<br />n/a n/a
<br />n/a n/a
<br />Building Replacement 576,280 658,280 n/a n/a
<br />PIP 322,823 351,823 n/a n/a
<br />Street Replacement $ 12,829,107 $ 12,788,107 n/a n/a
<br />Total $ 14,553,108 $ 14,601,108
<br />Citywide Total $ 26,967,194 $ 27,300,194
<br />$$ Over
<br />$$ Amount
<br />(Under)
<br />Unrestricted
<br />n/a
<br />$
<br />141,242
<br />n/a
<br />$
<br />377,041
<br />n/a
<br />$
<br />39,358
<br />n/a
<br />$
<br />220,329
<br />n/a
<br />$
<br />24,928
<br />n/a
<br />$
<br />-
<br />n/a
<br />-
<br />n/a
<br />-
<br />n/a
<br />658,280
<br />n/a
<br />n/a
<br />$
<br />12,788,107
<br />$
<br />14,249,285
<br />$ 21,593,592
<br />
|