8
<br />Revised Attachment B
<br />8
<br />0
<br />,
<br />7
<br />5
<br /> Target
<br />4
<br />
<br />Level
<br />160,317.00305,323.50
<br />7,582,729.50
<br />High
<br />
<br />$
<br /> Target
<br />Level
<br />w
<br />12/31/201912/31/2019
<br />Lo
<br />$ 1,277,697.50
<br />High
<br />Low
<br />25%25%1,277,697.50
<br />35%45%5,897,67910%30%53,43910%15%304,72510%15%203,549.00
<br />169,985124,947234,924778,996
<br />(918,583)
<br />1,667,105
<br />00
<br />00
<br />9959
<br />73
<br />24
<br />,,,,
<br />0475
<br />1343
<br />1500
<br />
<br />,
<br />,,
<br />2020
<br />Budget
<br />532
<br />
<br />
<br />16,850,510
<br />OperatingTargetTargetReserveReserve
<br />$
<br />----
<br />
<br />w
<br />918,583918,583
<br />Target %
<br />Below Lo$ $
<br /> From Parks & Rec From IT
<br />2020 Approved Transfers: From Communications From License Center249,140Balance *Application to minimumfund balance per policy
<br />-
<br />
<br />778,995
<br />4,979,0961,123,033
<br />Target %
<br />12/31/201912/31/2019
<br />
<br />$ $
<br />Above High
<br />General Funds without Transfers
<br />28%169,98553%124,94723%234,92427%249,140
<br />Level
<br />12/31/2019AmountAmount
<br />93413
<br />08616
<br />16204
<br />,,,,,
<br />85
<br />724
<br />84895
<br />82
<br />465
<br />
<br />,
<br />1
<br />Reserves
<br />
<br />Available
<br />
<br />12/31/2019
<br />$ 30%
<br />Cash Reserve Fund 105
<br />- - --
<br />
<br />00373
<br />5886
<br />4604
<br />,,,
<br />,
<br /> Funds Funds
<br />2,1094774
<br />81,000055
<br />gg 4
<br />635,000170,000886,000(After 2019 Approved Transfers)Transfers In888,10924285,26445
<br />
<br />,
<br />(311,607)
<br />
<br />
<br />1
<br />
<br />Donations
<br />
<br />
<br />$ 4,979,096$
<br />Balances after Transfers
<br />9913
<br />0816
<br />1204
<br />,,,,
<br /> Operatin Operatin
<br />82
<br />94
<br />8595
<br />8285,2646
<br />75
<br />CashFromCashReserve
<br />
<br />,
<br />
<br />
<br />5,035,3491
<br />Reserves
<br />
<br />
<br />
<br />12/31/2019Less
<br />$ (56,253)
<br /> Operating Funds
<br />UnrestrictedUnrestricted
<br />Operating Fund
<br />$601,000 reserved to bring the General Fund back to its minimum as of 12/31/18. Council didn't formally transfer.
<br />City of Roseville
<br />Cash Reserve Levels: Unrestricted Cash Reserve Levels: Cash Reserve Levels:
<br />12/31/19 Cash Reserves Updated 4/28/2020Parks & RecreationCommunications(1) Unrestricted cash only(2) $886,000 was originally transferred in, however the General Fund was below its minimum
<br /> target level.(3) The Communications Fund capital outlay was moved in 2020 to the facilities replacement fund.(4) Excludes $222K set aside for the 10-Year CIP(5) Excludes capital outlay
<br /> -accounted for in a separate fund 2019 Approved Transfers: From Parks & Rec From IT From License Center To General Fund12/31/2018 Balance2019 Interest Revenue12/31/2019 Balance*Pending
<br /> staff proposed transfers out* Balances after recommended transfers backGeneral: Primary 5,897,679General: Cash Reserve Fund Parks & RecreationCommunicationsInformation TechnologyLicense
<br /> Center
<br />(1)General: Primary (2)General: Cash Reserve Fund (3)
<br />(5)Information Technology(4)License Center
<br />
<br />
|