HomeMy WebLinkAbout4. Internal Service Funds 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 SHAKOPEE, 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 Total
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
2008 2009 2010 2011 2012
Actual Actual Budget Proposed Proposed
Sources
Miscellaneous
Rentals $ 1,048,560 $ 856,164 $ 688,650 $ 690,210 $ 646,980
Sale of Assets 101,239 54,162 12,000 15,000 12,000
Interest 276,583 218,355 100,000 125,000 125,000
Note repaid 115,000 80,000 85,000 90,000
Total Revenue 1,426,382 1,243,681 880,650 915,210 873,980
Uses
Capital Equipment 380,818 390,109 366,000 297,000 378,000
Total Expenditures 380,818 390,109 366,000 297,000 378,000
Excess (deficiency) of
Sources over Uses $ 1,045,564 $ 853,572 $ 514,650 $ 618,210 $ 495,980
Cash Balance December3l $ 4,780,811 $ 5,634,383 $ 6,149,033 $ 6,767,243 $ 7,263,223
Accumulated Depreciation 3,451,889 3,344,211
Outstanding Note 560,000 445,000 365,000 280,000 190,000
7 -5
O 00 O O O O O O O '
CD 300 O 00 CD 0)
O
07 d . O O O O O C 01
N 1 DD ( ff t
e- O) V U) r
O LO
N V u> u)
64 68
O O O o O O O 0 0
N. ca 0 o 0 0 O 0 0) 0
O O N O N O) M '0 to
T y- CO r 0 (0 V' 10 '0
N tl' V' V
64 68
0 0 0 0 O 0 o 0 O
0) CO O0 CO ON N N.
11 0) O O O 0 0 .1 V
O N 0) vN- cr d' CO M ,s 5;
W
T LO CO 00 CO
(NI CO N v -a .d.
64 64
0 O O 0 0 0 O 0 0 0 CD 03 0 CI CD CD
LO • CD 0 0 0) 0 0 'd' V'
r N 0 'Cr '1' N N
T N CO CO O v LO u)
N u) 14) Cf)
64 6
O 3 0 0 O 0 0 O O
1M 0 O O CO O O1 1) CO
tt] M O <- V CO C0 N N
T CC) CO 00 CO T.
O
64 64
0 0 0 0 0 0 O 0 0
IC) CA O O 1 0) O O 10 CC)
,I 1 j 1 O 0 ) v.- { 'Cr N N CO CO
T '- CO CO 0 v CO CO
c. N 11 r LC) lt)
68 6
0 0 0 0 0 0 0 O 0 1 O
L) 0 0 0 001 O O 1 4 ) C
ell p V csi e 0 W 0 N co C
T CO CO 0) 0 N N
N r CO u) u)
64 68
O 0 0 0 0 0 O O O O O
CA NC700 CO O00 N O N
11 0) 0 0 0 0) 0 Ern 11 O 11
Ch GD C0 N (C) (0 0 CCU C) N CCU N
T C — r(A CO 0 N I` W 0 0 0
N (.0 CO 0
64 69
O 00 0 0 0 0 0 CO 0 0 0
0)
CO 0)000 CA O0) o 0 IC)
N 6 N aid oi W 1C) 00 O 06
N N CO 00 M V' h 0) CO
T
O 0 CO CO
N
69 E9.
O 0 0 0 0 0 0 0 O O O_
O e- 0 0 0 y- O -- O
✓ N O O O N O N CO O 0
T M 0 r CV 0) 0 co 10 00 0)
T CO CO 0) N C0 N N CO
N CO CO CO
64 69
O w
0) )
0 °) E ° co CJ
o N N 0 N C d.
4 n. c ._ ,
1 R m N O t Z) C7
L1! y . Q N rn Z 0 i n m Y
Q�v_) QQ CI 2 en co N C > O
a rF - I— C ` — ° . yM 3 4. o1 ° U CD
N NU W a) a c -0 m o a) a) O m m
LL m a a s acn5mx w w N m -J m
O_ N N L L 'C7
0 CO W
0 1- - w 0 U L i 7-6
•
-
0 0 0 0
0 °0 0 0 0 0 0 0 0
0 0 m . 0 0 o
N d
VT co
o O O O O O O
o O O O O O
AI 6,1 ci
co V O
N co co N
fR <»
0 0 0
0 co O 0 o
E l o O V� co
O N
N N
69 N
o 0 O o o O O o 0
r V V M - c M ` V
p l N O
N
fR 69
0 0 0 O O O O O O O
N� CD N co � .M V M V M , N V, _
co
H 69.
0 0 0 0 0 o 0 O 0
C I <- N CO N co o o
N
oo. N
O O O
o 0 O O
1 m N O co o
N c - co
(A yj
O O O O O 8 o
o 0 O O O o 0 0 O O o 0 0 O
1 O N o N M M - co O 8 O to O
N M C CO CO N
64
0 0 0 0 0 0 C O O
0 0 0 0 O O O O O
N O - C m 0 m N CO
O. 0
0 N
N
f• so.
o 0 O O O O 0 0 0 O
N I O N M N 0 66
69 yj
C
J G
O
m a
to d Y Q 3
Y 0 m R 0 3 g v a o
o y 6 V E W
m E m (� 1 3 3 2s-. `m n
1'4 U nv n� t a'ci m m m ° K x1 c N m ° 'va E N
� W: V 0 u u v vo 0 �m �xc� m
1 5. > lQ 7 T) m 7. y L L N(� Y Y Y 24 N E E` . 4 7 m p m
> Y- V U O m m m d x U U ry d U Y U U Y LL p T a L p
IQ .i0 U d c i N X L U> > > m N p V 7 7 ` d' U m 7 Y N m � .m_. � U y ... m -.°-"
m` c m d v m m Ti; o o x o p a 't Y U m E Y o 3
m.:20 N m I- � 4'3 1- C� O. C O O x �� i- I- O O I- N N O m 2 S 7 C O m N U ... R W ? O U t O N
Vg corm cYiE o mct p c� d dU' m Bm 230moyEomF -rn 0 0 .aE- ' ,,
`._vim �°- �� o m i F" ; - m . m -aY co m F . m g%lsg2ErnmmcYav
E J .p 'C m . m +-� m d O l U OI Y Y 2 2 E Q C
m V x O 0 6 t , 2 m c t L N W..(41-0-¢c0 _ U V U E .O E m 0 Sd O m w m C LL >i 3 0 U 0 d :01-0E02
o
��Q <tU N W I- F -OU IL Q � c � 15...! Y JailmF-�/J UJ C7U ti 2 rG H yJ(n W ca E
~ -. -� (qa(q (q fq
2 0 'el 2 v 3
E
° iZ m w m 7 -7 y w
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE PARK FUND BUDGET SUMMARY
•
2008 2009 2010 2011 2012
Actual Actual Proposed Proposed Proposed
Sources
Miscellaneous
Rentals $ 110,003 $ 78,120 $ 171,680 $ 171,680 $ 221,680
Interest 1,865 7,172 8,000 9,000 10,000
Total Revenue 111,868 85,292 179,680 180,680 231,680
Uses
Capital
Lion's shelter #2 roof 15,000
Tahpah shelter roof 20,000
Trail Overlay O'dowd 30,000
Trail Overlay Sarazin - Alysheba 20,000
Fencing Tahpah #8 15,000
Fencing Tahpah #7 15,000
Total Expenditures 60,000 55,000
Excess (deficiency) of
Sources over Uses $ 111,868 $ 85,292 $ 179,680 $ 120,680 $ 176,680
Cash Balance December 31 $ 111,598 $ 195,974 $ 375,654 $ 496,334 $ 673,014
Accumulated Depreciation 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
2008 2009 2010 2011 2012
Actual Actual Proposed Proposed Proposed
Sources
Miscellaneous
Rentals $ 260,000 $ 280,000
Interest 1,000 2,000 2,000
Miscellanous
Gain (loss) on asset disposal
Total Revenue 1,000 262,000 282,000
Uses
Supplies 3,740 38,910 33,790
Services 14,760 15,000 15,000
Software 170,500 166,200
Capital 61,030 71,010
Total Expenditures 18,500 285,440 286,000
Excess (deficiency) of
Sources over Uses - - (17,500) (23,440) (4,000)
Transfer In 125,000
Net $ - $ - $ 107,500 $ (23,440) $ (4,000)
Cash Balance December 31 $ 107,500 $ 84,060 $ 80,060
Accumulated Depreciation
7 -11
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 -12
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE BUILDING FUND BUDGET SUMMARY
2008 2009 2010 2011 2012
Actual Actual Proposed Proposed Proposed
Sources
Miscellaneous
Rentals $ 917,340 $ 1,079,676 $ 1,282,030 $ 1,204,700 $ 1,281,210
Interest 113,793 78,899 50,000 50,000 35,000
Miscellaneous 7,742
Gain (loss) on asset disposal 33,530
Total Revenue 1,064,663 1,166,317 1,332,030 1,254,700 1,316,210
Uses
Capital Construction
Aquatic Building 90,072
Water Slide 543,829
Fire Station 4 Site 300,000 300,000
Fire Station 5 Site 200,000 200,000
Community Center Water Problem 179,565
Community Center Cooling Tower 34,180
Community Center Chillers 95,000
Community Center Roof 300,000
City Hall boiler 56,548
City Hall HVAC South side 20,000
Fire Station 1 HVAC 80,000
Energy Items 20,000 20,000 20,000
Total Expenditures 813,466 90,728 615,000 520,000 420,000
Excess (deficiency) of
Sources over Uses 251,197 1,075,589 717,030 734,700 896,210
Transfer In 1,094,988
Transfer Out Debt Service (465,497) (415,497) (465,000) (465,000) (465,000)
Net $ (214,300) $ 1,755,080 $ 252,030 $ 269,700 $ 431,210
Cash Balance December31 $ 1,771,027 $ 3,509,433 $ 3,761,463 $ 4,031,163 $ 4,462,373
Accumulated Depreciation 6,194,695 6,979,892 7,734,632
7 -13
•
City of Shakopee
BuiIidng Maintenance projects
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
City Hall
Roof 250,000
HVAC south 20,000
HVAC north
Boiler
Lighting 100,000
Elevator upgrade 30,000
Police Station
Roof 300,000
HVAC 200,000
Boiler
Lighting
Fire Station 1
Roof 250,000
HVAC 80,000
Boiler 75,000
Lighting
Elevator upgrade 40,000
Fire Station 2
Roof 250,000
HVAC 50,000
Bailer 25,000
Lighting
Engineering Bldg
Roof 250,000
HVAC
Lighting
pW Building
Roof
HVAC
Boiler
Lighting 30,000
Library
Roof 250,000
HVAC 200,000
Boiler
Lighting
Elevator upgrade
Community Center
Roof 300,000 •
Air Handlers
Boiler 100,000
Chiller 95,000
Lighting
Elevator upgrade 50,000
Acquatic Center
Roof
HVAC
Boiler
Lighting
Slide
Pool liner
Filter building 75,000
$ 120,000 $ - $ 500,000 $ 350,000 $ 200,000 $ 130,000 $ 325,000 $ 365,000 $ 730,000 $ 300,000 $
7--14
2021 2022 2023 2024 2025 2026 2027 2028 2029 Cost Year
146,000 2001 replacement/insulate
13,000 2004 replacement
75,000 93,000 2008 replacement/duct/controis
100,000 2009
1994 City purchase remodel
1994 City purchase remodel
2003 New
2003 New
75,000 2003 New
100,000 2003 New
1997 New
1997 New
1997 New
1997 New
1997 New
170,000 2004
1956 New
4956 New
1956 New
415,000 2002 replacement/insulate /skylight:
75,000 49,000 2007
1975 New
300,000 2006 New
2006 New
2006 New
2006 New
2003 New
2003 New
2003 New
2003 New
40,000 2003 New
1995 New
1995 New
1995 New
2010
1995 New
1997 New
2008 New
2008 New
2008 New
2008 New
750,000 500,000 2008 Total slide replacement
2000
915,000 2000 pool bottom /filter media /plumb
$ 300,000 $ 75,000 $ 215,000 $ 75,000 $ - $ - $ - $ 850,000
7--15
CITY OF SHAKOPEE, MINNESOTA
2011 - 2012 BUDGET
INTERNAL SERVICE BENEFITS FUND BUDGET SUMMARY
2008 2009 2010 2011 2012
Actual Actual Budget Proposed Proposed
Sources
Miscellaneous
Receipts from Users $ 642,483 $ 740,869 $ 750,000 $ 750,000 $ 750,000
Interest 87,578 68,062 70,000 60,000 60,000
OPEB Charges 80,061 127,600 163,153 - -
Total Revenue 810,122 936,531 983,153 810,000 810,000
Uses
Payment to Employees 608,645 868,469 650,000 750,000 750,000
Payment for Interfund Services
Total Expenditures 608,645 868,469 650,000 750,000 750,000
Excess (deficiency) of
Sources over Uses $ 201,477 $ 68,062 $ 333,153 $ 60,000 $ 60,000
Cash Balance December3l $ 1,500,487 $ 2,075,357 $ 2,408,510 $ 2,468,510 $ 2,528,510
Compensated Absence Liability $ 1,434,766 , $ 1,562,320
OPEB Liability 233,153 420,884
OPEB contribution discontinued 2011
7 -17