Loading...
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