2022-2026 Capital Improvement Plan (Final)

CITY OF SHAKOPEE, MINNESOTA Information Technology Internal Service Fund (7806) Cash Flows Updated 7/30/2021

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2019 Actual 2020 Actual

Sources

Rental Charges Federal Grants

$

420,900

$

611,300 106,492 27,443 745,235

$

612,000

$

612,000

$

618,120

$

624,301

$

624,301

$

630,544

-

-

-

-

-

-

-

Investment Income

25,816 446,716

8,053

8,066

10,425 628,545

10,746 635,047

10,746 635,047

8,721

Total Revenue

620,053

620,066

639,265

Uses IT Operational Expenses Computer Replacements

33,304 69,637 219,177 41,154 24,500 18,917

122,313 85,694 207,697 57,898 27,083 32,840

37,000 65,000 225,000 75,000 40,000 25,000

38,000 100,000 235,000 85,000 45,000 25,000

39,000 127,000 235,000 90,000 50,000 25,000 35,000 30,000 200,000 831,000 -

40,000 75,000 240,000 90,000 55,000 25,000

40,000 75,000 240,000 95,000 55,000 25,000

42,000 85,000 240,000 96,000 60,000 25,000

Software Purchases and Maintenance

Logis Services

General Consulting Services

Printer Replacement

Fiber Redundancy Improvements

4,210

- -

-

-

-

-

-

- - -

30,000 30,000

30,000 30,000

35,000 30,000

35,000 30,000

35,000 45,000

Building Security

Network Device Replacement Server/SAN Replacement

28,412

-

-

-

-

-

-

Total Expenditures

410,899

561,937

527,000

588,000

590,000

595,000

628,000

Net

$

35,817

$

183,298

$

93,053

$

32,066

(202,455) $

$

45,047

$

40,047

$

11,265

Cash Balance- January 1

$

703,142

$

738,959

$

949,456

1,042,509 $

1,074,575 $

$

872,120

$

917,167

$

957,214

27,199 949,456

Change in Accruals

Cash Balance December 31

$

738,959

$

1,042,509 $

1,074,575 $

$

872,120

$

917,167

$

957,214

$

968,480

140