2021-25 Capital Improvement Plan

CITY OF SHAKOPEE, MINNESOTA Information Technology Internal Service Fund Cash Flows Updated 8/18/2020

2020 Projected

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2018 Actual 2019 Actual

Sources

Rental Charges

$

400,900

$

420,900 25,816 446,716

$

611,300

$

612,000

$

624,240

$

636,725

$

649,459

$

662,448

Investment Income

9,375

7,390

8,053

8,066

8,997

9,840

8,657

Total Revenue

410,275

618,690

620,053

632,306

645,722

659,299

671,105

Uses IT Operationals Expenses Computer Replacements

-

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

36,000 65,000 200,000 80,000 35,000 25,000 50,000 30,000 30,000

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

38,000 70,000 235,000 75,000 45,000 25,000

39,000 70,000 235,000 80,000 50,000 25,000 35,000 30,000 200,000 764,000 -

40,000 75,000 240,000 80,000 55,000 25,000

40,000 75,000 240,000 85,000 55,000 25,000

227,840 188,926

Software Purchases and Maintenance

Logis Services

- -

General Consulting Services

Printer Replacement

20,004

Fiber Redundancy Improvements

- - - -

4,210

-

-

-

-

Building Security

- - -

30,000 30,000

30,000 30,000

35,000 30,000

35,000 30,000

Network Device Replacement Server/SAN Replacement

-

-

-

-

-

Total Expenditures

436,770

410,899

551,000

527,000

548,000

580,000

585,000

Net

$

(26,495)

$

35,817

$

67,690

$

93,053

$

84,306

(118,278) $

$

79,299

$

86,105

Cash Balance- January 1

$

729,637

$

703,142

$

738,959

$

806,649

$

899,702

$

984,008

$

865,730

$

945,029

Cash Balance December 31

$

703,142

$

738,959

$

806,649

$

899,702

$

984,008

$

865,730

$

945,029

1,031,135 $

124