HomeMy WebLinkAbout7. Internal Service Fund/.
INTERNAL SERVICE FUNDS
The Internal Service Funds are used to account for the financing of major
mobile equipment, major buildings, replacement of park assets and
Information Technology items. Also included is the Employee Benefits Fund.
7-1
CITY OF 5HAKOPEE, MINNESOTA
2011 BUDGET
INTERNAL SERVICE FUNDS BUDGET SUMMARY
2011 2012 2011 2012 2011 2012
Equipment Equipment Park Park IT IT
Fund Fund Fund Fund Fund Fund
Sources
Rentals $ 690,210 $ 646,980 $ 171,680 $ 221,680 $ 260,000 $ 280,000
Interest 125,000 125,000 9,000 . 10,000 2,000 2,000
Sale of Assets 15,000 .12,000
Note repayment 85,000 90,000
Total Revenue 915,210 873,980 180,680 231,680 262,000 282,000
Uses
Benefits
Capital Expenditures 297,000 378,000 60,000 55,000 38,910 33,790
IT Supplies/services 246,530 252,210
Total Expenditures 297,000_ _ _378,000 60,000 55,000 285;440 286,000
Transfers
Excess (deficiency) of
Sources over Uses $ 618,210 $ 495,980 $ 120,680 $ 176,680 $ (23,440) $ (4,000)
7-2
CITY OF SHAKOPEE, MINNE
2011 BUDGET
INTERNAL SERVICE FUNDS
2011 2012 2011 2012 2011 2012
Building Building Benefit Benefit
Fund Fund Fund Fund Total Tota!
Sources
Rentals $ 1,204,700 $ 1,281,210 $ 750,000 $ 750,000 $ 3,076,590 $ 3,179,870
Interest 50,000 35,000 60,000 60,000 246,000 232,000
Sale of Assets 15,000 12,000
Note repayment
Total Revenue 1,254,700 1,316,210 810,000 810,000 3,337,590 3,423,870
Uses
Benefits 750,000 750,000 750,000 750,000
Capital Expenditures 520,000 420,000 915,910 886,790
IT Supplies/services 246,530 252,210
Total Expenditures 520,000 420,000 750,000 750,000 1,912,440 1,889,000
Transfers (465,000) (465,000) (465,000) (465,000)
Excess (deficiency) of
Sources over Uses $ 269,700 $ 431,210 $ 60,000 $ 60,000 $ 960,150 $ 1,069,870
7-3
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE EQUIPMENT FUND BUDGET SUMMARY
Sources
Miscellaneous
Rentals
Sale of Assets
Interest
Note repaid
Total Revenue
Uses
Capital Equipment
Total Expenditures
Excess (deficiency) of
Sources over Uses
Cash Balance December 31
Accumulated Depreciation
Outstanding Note
2008 2009 2010 2011 2012
Actual Actual Budget Proposed Proposed
$ 1,048,560 $ 856,164 $ 688,650 $ 690,210 $ 646,980
101,239 54,162 12,000 15,000 12,000
276,583 218,355 100,000 125,000 125,000
115,000 80,000 85,000 90,000
1,426,382 1,243,681 880,650 915,210 873,980
380,818 390,109 366,000 297,000 378,000
380,818 390,109 366,000 297,000 378,000
$ 1,045,564 $ 853,572 $ 514,650 $ 618,210 $ 495,980
$ 4,780,811 $ 5,634,383 $ 6,149,033 $ 6,767,243 $ 7,263,223
3,451,889 3,344,211
560,000 445,000 365,000 280,000 190,000
7-5
0
°
rn °poo 0
O 0
O o
O rn
M
M ~ 0 0
C
N
r
~
~ W
O
r ~ ' ~ r
N
- V
~ ~
64
0 O N 0
0
~ N N i
6
V' 0OO O O O M
~ O ~ O N O M ~
_
N
V' V
M
0 W O N ~
i W O O
6
'V' 0OO 0 O O V'
~
r
O
o
{ ~ ~ M ~
t
C
O
O
N ~ N ~ 7
Fh?
O O O O O O O O
~ 0 0 O 0 0
I,[) O
i V'
ti
~ ~~ V
~ V <t 0 ~
l
f~ O M O N ~
N .n u)
FR
M W O O W O oD ~
IA 000 0 0 0 ~
~ M ~~~
~ ~ CNO W ~
~fJ CO W (O r I
N O ~
Efl
O O
~ W O M
W N
t l) 0 O O 1 0 O O ~
~
t!7 ~r ~
~ V h N M
I
I` _ CO
O CO O N ~
N ~ tCi
O 0 0 0 0 0 0 0 O ~
~
0 0 0 0 0 O O 0
~ N O~ O ~f1
~ r ~} ~ 0 M
W <Y
O O
N N
~
c r-, m ao rn o r
N c0 Cn
H3
0
0 0 o
~ W O W ~ O
0
0
t o 0 0 0 0 0 O 0 0 O
M
~ ~ ~ r ~
d. V.~~
T N
N m ~ ~ n
N CD O
O O O O O O 0 0 O O
X
C D
0 0 0 0 O 0 O O
r
~ ~
V
~ m
N r 0 <7' Cn
N CO W M ti' I~
N CO O
EA
O 0 0 0 0 0 O O O O
O O O O O O
V N O O O N O N O O
r
W ~
W O ~ O 0
~
~
M 0
0
l
~ O O 0 N CO N N
N t~7 CO
Efl
C
O
N
N
d
. _
~--
~ d
E
v
M
O
d ~
~ N
a O
C `~ ~ ~'
~
w d
m N
N O
O N
.L0
M
W} ~ N
Z Z
O I O. n ~ Y
O p N
r~ 03
= U t
p V'
N N N v
B > O ~
Y J L~ a 4 °~ ~ L L
w w~ ¢ ro
srF- I- °~ ~ o mY c aaw v $ v
snow w d c m~ ~ a~ y mp m ~ m
O ma off
~ ~cn ~m~ x x ~, m .° m
a, ~ ..
~ a ~ w w ~ _ ~ -a
W
~
~ U
U
U m I
it }
- W U li
7-6
o° o o
o o
o - o
o°
o
N o
N
M _ ~
fA
A
NI O
O
`
FA O O
- O
O
~
M O
O
C O
O
~
~
fA p
O
N
o
N
O
M O
O
O
N O
O
- O
O
_
~
~
N
t9
.r-
NI _00
a
N
f9 O
~°
-. O O
w° n ~ O
h °o O
~ 00
rn
O
ER ..
-
O O O O O O O O O O
rl
N ~ N t0
FA M r V rn V tN0
O
H} V
~O
NI N ~
c
f9 t00
M N i0 00 O~
O
Nd
.
O O O O. ~
T
NI ON N
~ 00
s- ~ o
T
~3
MI
p
N O
~ O
N N
N
FA
O
M
O
N
O O
mW
~
O O
M~
O
~
W
yi
O H
00 c.
O
O
NI
N 00
n
N3 .. O
O] O
C
V O
1~
M O O
r m
M M O
W
N p
~
M
U3 ~
~
N
{ h ~ - N M ~ O
I
NI ~
di ~
N
~ ~
C
> C
a t0
m
z ~ a a
U N
U
L~ N U N O N
m r °, m C7 ~ R
`m `m ~ ~ ~ ~ s t ~
U U ~ V ~ m ~
fU a E N O~ O> V U
N N N ~ - Q
~~U lia ~dF- d xt~> >
v N° U Y d E~ a' H O y N L p
Y=a" UO.YYa~srws~, d
E.p~ 200 .COy~Nm.,mO,
V ~LQ Vx'U NW rr QQ~QUU.Q~ C
d
a° ii m'
Q
O N O O
W
U O O
OQ
2 L
. j
~ ~
a °'
3
F ~ d a
°: 3
L 7 ~ ~~ y ~ ~ ~> > 7 7~ ~N 3 O N
> y
^ d~
a~~o'd'~23
X
CL
r F O o
~'2X'Y' 3~ vn `f0t
~ W
~ r
~
m d~ a y LL n a r o
u7i~ yUd~a°iEs v3"'
N N U? R N 3 0
U f
~
~~ ~p
~,.;
d d~m~~mm N
0 0 LO
S y C
am
~~m`mrU~
~3~m` O
~ 0
0 O
vd~o2aeh~ 20.1=~...
n
`mom
y
01 U y
m may ao
C y 0 U y C c
a
D) Y Y U a l0 n C 0 2' ~=
d U„m ~a°-- ~
~ V U> N Y E N L O N a+ N C `°
O
ca3~o~oO1~vocyi~QO,v_
LL 3
~~
' «yJ fAQQF-aQ(~ ~aamt-~n rn c7 c.~xLL`~~ I-o yJUJW~a ~JUJ O7 a~-n. rn aJ (n
rn
` ~ Y
' v 3 w
w ~'
in 7 - ~ ~ vi
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE PARK FUND BUDGET SUMMARY
Sources
Miscellaneous
Rentals
Interest
Total Revenue
Uses
Capital
Lion's shelter #2 roof
Tahpah shelter roof
Trail Overlay O'dowd
Trail Overlay Sarazin - Alysheba
Fencing Tahpah #8
Fencing Tahpah #7
Total Expenditures
Excess (deficiency) of
Sources over Uses
Cash Balance December 31
Accumulated Depreciation
2008 2009 2010 2011 2012
Actual Actual Proposed Proposed Proposed
$ 110,003 $ 78,120 $ 171,680 $ 171,680 $ 221,680
1,865 7,172 8,000 9,000 10,000
111,868 85,292 179,680 180,680 231,680
15, 000
20, 000
30, 000
20,000
15, 000
15, 000
60,000 55,000
$ 111,868 $ 85,292 $ 179,680 $ 120,680 $ 176,680
$ 111,598 $ 195,974 $ 375,654 $ 496,334 $ 673,014
1,522,614 1,895,608 2,267,608 2,639,608 3,011,608
7-9
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE INFORMATION TECHNOLOGY FUND BUDGET SUMMARY
Sources
Miscellaneous
Rentals
Interest
Miscellanous
Gain (loss} on asset disposal
Total Revenue
Uses
Supplies
Services
Software
Capital
Total Expenditures
Excess (deficiency) of
Sources over Uses
Transfer In
Net
Cash Balance December 31
Accumulated Depreciation
2008 2009 2010 2011 2012
Actual Actua{ Proposed Proposed Proposed
$ 260,000 $ 280,000
1,000 2,000 2,000
1,000 262,000 282,000
3,740 38,910 33,790
14, 760 15, 000 15, 000
170,500 166,200
61,030 71,010
18,500 285,440 286,000
- - (17,500) (23,440) (4,000)
125,000
$ - $ - $ 107,500 $ (23,440) $ (4,000)
$ 107,500 $ 84,060 $ 80,060
~-~~
Information Technology Fund
Five year Expenditure Plan
2011 2012 2013 2014 2015
Capital
Large copier (MFP) Police $ 16,030 $ 16,030
Large copier (MFP) City Hall
Large copier (MFP) Admin 21,380
Large copier (MFP) Recreation 16,030
Large copier (MFP) Fire
Medium copier (MFP) Public Works 10,690
Medium copier (MFP} Engineering 10,690
Engineering plotter 10,690
Servers 25,000 6,000 5,000 9,000 21,400
Storage capacity
SAN drive bay CH 20,000 26,400
SAN drive bay PD 25,550 25,550
SAN @ PD 67,330
SAN @ City Hall 67,400
Brocade 5100 18,080
Capital 61,030 71,010 139,730 57,100 89,380
Supplies
PC Replacement 37 $ - $ - $ - $ 31,640 $ -
PC Replacement 36 30,780 30,780
PC Replacement 27 23,090
PC Replacement 20 17,100
ENG Shared Laptop 2,140
Fire Laptop Training 2,140
ENG Workstation 4 5,990 5,990
ENG Workstation 2 3,000
CDEV Director Laptop 2,140 2,140
Park and Rec Director 2,140
CSO Laptop 2,140
ENG/PW Director 2,140
Fire Inspector 2,140
Police Chief 2,140
Crimefree Laptop 2,140
Checkout Laptop 1,070
Computers total 38,910 33,790 21,170 38,060 38,910
Printers total 3,210
Professional Services 15,000 15,000 15,000 15,000 15,000
Software
Licenses MS 148,100 148,100 148,100 148,100 148,100
Phone system 5,000 5,000 5,000 5,000 5,000
Network - LOGIS 2,600 2,600 2,600 2,600 2,600
Internet 3,000 3,000 3,000 3,000 3,000
Disaster Recovery 11,800 7,500 .7,500 -
Software total 170,500 166,200 166,200 158,700 158,700
Supplies total 209,410 199,990 190,580 196,760 197,610
Total $ 285,440 $ 286,000 $ 345,310 $ 268,860 $ 301,990
7-~ 2
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE BUILDING FUND BUDGET SUMMARY
Sources
Miscellaneous
Rentals
Interest
Miscellaneous
Gain (loss) on asset disposal
Tota! Revenue
Uses
Capital Construction
Aquatic Building
Water Slide
Fire Station 4 Site
Fire Station 5 Site
Community Center Water Problem
Community Center Cooling Tower
Community Center Chillers
Community Center Roof
City Hall boiler
City Hall HVAC South side
Fire Station 1 HVAC
Energy Items
Total Expenditures
Excess (deficiency) of
Sources over Uses
Transfer In
Transfer Out Debt Service
Net
Cash Balance December 31
Accumulated Depreciation
2008 2009 2010 2011 2012
Actual Actual Proposed Proposed Proposed
$ 917,340 $ 1,079,676 $ 1,282,030 $ 1,204,700 $ 1,281,210
113,793 78,899 50,000 50,000 35,000
7,742
33, 530
1,064,663 1,166,317 1, 332, 030 1,254,700 1, 316,210
90,072
543,829
300,000 300,000
200,000 200,000
179, 565
34,180
95, 000
300, 000
56, 548
20, 000
80,000
20,000 20,000 20,000
813,466 90,728 615,000 520,000 420,000
251,197 1,075,589 717,030 734,700 896,210
1,094,988
(465,497) (415,497) (465,000) (465,000) (465,000)
$ (214,300) $ 1,755,080 $ 252,030 $ 269,700 $ 431,210
$ 1,771,027 $ 3,509,433 $ 3,761,463 $ 4,031,163 $ 4,462,373
6,194,695 6,979,892. 7,734,632
7-~3
City of Shakopee
Builddng Maintenance projects
City Hall
Roof
HVAC south
HVAC north
Boiler
Lighting
Elevator upgrade
Police Station
Roof
HVAC
Boiler
Lighting
Fire Station 1
Roof
HVAC
Boiler
Lighting
Elevator upgrade
Fire Station 2
Roof
HVAC
~Beiler
Lighting
Engineering Bldg
Roof
HVAC
Lighting
PW Building
Roof
HVAC
Boiler
Lighting
Library
Roof
HVAC
Boiler
Lighting
Elevator upgrade
Community Center
Roof
Air Handlers
Boiler
Chiller
Lighting
Elevator upgrade
Acquatic Center
Roof
HVAC
Boiler
Lighting
Slide
Pool liner
Filter building
7-14
2021 2022 2023 2024 2025 2026 2027 2028 2029 Cost
146,000
13, 000
75,000 93,000
100,000
75, 000
100,000
75,000
300,000
40, 000
750,000
$ 300,000 $ 75,000 $ 215,000 $ 75,000 $ $ $ $ 850,000
170,000
415,000
49,000
500,000
915,000
Year
2001 replacement/insulate
2004 replacement
2008 replacement/duct/controls
2009
1994 City purchase remodel
1994 City purchase remodel
2003 New
2003 New
2003 New
2003 New
1997 New
1997 New
1997 New
1997 New
1997 New
2004
1956 New
4956 New
1956 New
2002 replacement/insulate/skylight:
2007
1975 New
2006 New
2006 New
2006 New
2006 New
2003 New
2003 New
2003 New
2003 New
2003 New
1995 New
1995 New
1995 New
2010
1995 New
1997 New
2008 New
2008 New
2008 New
2008 New
2008 Total slide replacement
2000
2000 pool bottom/filter media/plumb
7-15
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE BENEFITS FUND BUDGET SUMMARY
Sources
Miscellaneous
Receipts from Users
Interest
OPEB Charges
Total Revenue
Uses
Payment to Employees
Payment for Interfund Services
Total Expenditures
Excess (deficiency) of
Sources over Uses
Cash Balance December 31
Compensated Absence Liability
OPEB Liability
OPEB contribution discontinued 2011
2008 2009 2010 2011 2012
Actual Actual Budget Proposed Proposed
$ 642,483 $ 740,869 $ 750,000 $ 750,000 $ 750,000
87,578 68,062 70,000 60,000 60,000
80,061 127,600 163,153 - -
810,122 936,531 983,153 810,000 810,000
608,645 868,469 650,000 750,000 750,000
608,645 868,469 650,000 750,000 750,000
$ 201,477 $ 68,062 $ 333,153 $ 60,000 $ 60,000
$ 1,500,487 $ 2,075,357 $ 2,408,510 $ 2,468,510 $ 2,528,510
$ 1,434,766 $ 1,562,320
233,153 420,884
7-17