|
City of Roseville
<br />Cash Reserve Levels: Unrestricted Operating Funds
<br />12/31/21 Cash Reserves Updated 3/8/2022
<br />Cash Reserve Levels: Unrestricted Operating Funds
<br />12/31/202112/31/202112/31/202112/31/202112/31/2021
<br />Low Target High Target
<br />12/31/2021Less Available 12/31/2021AmountAmount2022
<br />CashFromCashReserve Above HighBelow Low OperatingTargetTargetReserveReserve
<br />Operating Fund ReservesDonationsReservesLevelTarget %Target %BudgetLowHighLevelLevel
<br />(1)General: Primary$ 8,875,026$ 8,795,223(79,803)$ 46%$ -$ -$ 19,049,75135%50%6,667,413$ $ 9,524,876
<br />(2)General: Cash Reserve Fund 2 66,054 - 266,054
<br />Parks & Recreation 2,003,435 (323,085) 1,680,35031%79,662 - 5,335,62820%30%1,067,125 1,600,688
<br />(3)Communications 94,362 - 94,36218% - - 516,99810%30%51,700 155,099
<br />(4)Information Technology 4 85,792 - 485,79258% 3 60,160 - 837,54910%15%83,755 125,632
<br />(5)License Center 2 43,267 - 243,26711% - - 2,151,63010%15%215,163 322,745
<br />$ 439,821$ -
<br />(1)Unrestricted cash only
<br />(2)See analysis below
<br />(3)The Communications Fund capital outlay was moved in 2020 to the facilities replacement fund.
<br />(4)Used $91,682 to balance 2022 budget and moved $50,000 of Tax levy from the Capital Fund to IT operations
<br />This excludes capital outlay which is in a separate fund.
<br />(5)$688,000 ARPA dollars transferred in to cover 2020 revenue loss- FB was deficit ($325,783) before the transfer
<br />Cash Reserve Target Levels
<br />TargetTarget
<br />Operating FundLowHigh
<br />General (unrestricted portion)35%50%
<br />Parks & Recreation20%30%
<br />Communications10%30%
<br />Information Technology10%15%
<br />License Center10%15%
<br />Percentages reflect the amount of cash holdings relative to the operating budget
<br />
<br />
|