2023-2027 Capital Improvement Plan

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

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2021 Actual

Sources

Rental Charges

$

612,000

$

612,000

$

612,000 11,712

$

618,120 12,032

$

618,120 12,032

$

618,120

$

624,301

Investment Income

(6,810)

8,066

8,119

7,821

Miscellaneous

3,209

-

-

-

-

-

-

Total Revenue

608,399

620,066

623,712

630,152

630,152

626,239

632,122

Uses IT Operational Expenses Computer Replacements

19,008 19,157 208,736 72,386 28,638

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

40,000 115,000 235,000 90,000 50,000 20,000 50,000 35,000 30,000 100,000 250,000

40,000 100,000 240,000 90,000 55,000 20,000 50,000 35,000

40,000 110,000 240,000 95,000 55,000 20,000

40,000 100,000 240,000 96,000 60,000 20,000

40,000 100,000 250,000 98,000 65,000 20,000

Software Purchases and Maintenance

Logis Services

General Consulting Services

Printer Replacement

300

Fiber Redundancy Improvements

- -

-

-

-

-

Building Security

30,000 30,000

35,000 30,000

35,000 90,000

100,000 100,000

Network Device Replacement Internal Phone Upgrade Server/SAN Replacement

15,306

30,000

- -

- -

- -

- -

- -

- -

Total Expenditures

363,531

588,000

1,015,000

660,000

625,000

681,000

773,000

Net

$

244,868

$

32,066

(391,288) $

$

(29,848)

$

5,152

$

(54,761)

(140,878) $

Cash Balance- January 1

$

949,456

1,171,164 $

1,203,230 $

$

811,942

$

782,094

$

787,246

$

732,485

(23,160)

Change in Accruals

Cash Balance December 31

1,171,164 $

1,203,230 $

$

811,942

$

782,094

$

787,246

$

732,485

$

591,607

158