2024-28 Capital Improvement Plan

CITY OF SHAKOPEE, MINNESOTA Information Technology Internal Service Fund (7806) Cash Flows

40,000 Change in rent

Updated 7/20/2023

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2028 Projected

2022 Actual

Sources

Rental Charges

$ 612,000 $ 612,000 $ 652,000 $ 678,080 $ 705,203 $ 733,411 $ 762,748

Investment Income

(50,500) 561,500

11,463 623,463

15,302 667,302

12,168 690,248

10,473 715,676

10,426 743,837

10,703 773,451

Total Revenue

Uses

Supplies

(1,069) 38,770

-

-

-

-

-

-

IT Operational Expenses Computer Replacements

40,000 115,000 235,000 90,000 50,000 20,000 50,000 35,000

40,000 135,000 245,000 191,000 55,000 20,000 20,000 70,000 18,000 30,000 -

40,000 110,000 245,000 195,000 55,000 20,000 50,000 20,000

40,000 100,000 250,000 198,000 60,000 20,000

40,000 100,000 255,000 205,000 60,000 20,000

40,000 100,000 260,000 210,000 65,000 20,000

245,076 73,266 84,770 30,170 11,776

Software Purchases and Maintenance

Logis Services

General Consulting Services

Printer Replacement

Fiber Redundancy Improvements

-

-

-

-

Building Security

21,606

20,000

20,000

20,000

- -

-

- -

- -

Wireless Access Upgrades Surveillance Camera Upgrades Network Device Replacement

- -

- -

10,000 30,000

56,383

30,000 100,000 250,000

30,000

30,000

30,000

Internal Phone Upgrade Server/SAN Replacement

- -

- -

- -

- -

- -

- -

Total Expenditures

560,748 1,015,000

824,000

775,000

718,000

730,000

745,000

Net

$

752

$ (391,537) $ (156,698) $

(84,752)

$

(2,324)

$

13,837 $

28,451

Cash Balance- January 1

$ 1,146,280 1,156,632 $ $ 765,095 $ 608,397 $ 523,645 $ 521,321 $ 521,321

9,600

Change in Accruals

Cash Balance December 31

$ 1,156,632 $ 765,095 $ 608,397 $ 523,645 $ 521,321 $ 535,159 $ 549,772

150