HomeMy WebLinkAbout4. 2009 Park and Recreation Proposed Budget
tf,
CITY OF SHAKOPEE
MEMORANDUM
To:
Mayor and City Council
Mark McNeill, City Administrator
From:
Jamie Polley, Parks, Recreation & Natural Resources Director
Meeting Date:
August 12, 2008
Subject:
2009 Recreation Fund Operating Budget Request
INTRODUCTION
This agenda item provides the first review of the Recreation Fund 2009 Budget Request.
DISCUSSION
Recreation Fund provides funding for the following services:
. Recreation Programs · Teen center
. Aquatics · Park Development (Reduced)
. Ice Arena · Development Review
. Community Center · Recreation Management
· Park Services
Much of the direct service is provided by a combination of approximately 95 ongoing and
seasonal part-time staff, as well as the following full-time positions:
. Recreation Supervisor - Athletic and Adult Activities
. Recreation Supervisor - Aquatics & Community Center
. Recreation Supervisor - Ice Arena
. Recreation Supervisor - Youth, Teen, and Senior Programs
. Park and Landscape Designer (eliminated in 2009)
· Office Service Worker
· Secretary
· Director
Continued level of Service Request
As directed, we have prepared the budget request with a reduced level of service (with
some limited growth in program participation and memberships) and no new
enhancements. The base budget request and history is as follows:
2006 Actual 2007 Actual 2008 2009 2008-2009
Reauest Request % Change
Revenue 980,528 1,040,810 1,072,830 1,100,600 2.59%
Exoenditures 2,116,434 2,206,295 2,217,840 2,334,270 5.25%
General Fund 1,287,110 1,108,770 1,145,010 1,233,670 7.74%
Transfer
End of Year 151,204 567,009 n/a n/a n/a
Fund Balance
The breakdown above includes the deduction of one full time employee. The
expenditures also include employee cost of living increases, a $72,000 increase in utilities
and an $110,450 increase in building rent. The revenue does not include an increase in
Parks and Recreation fees which will be discussed at an Advisory Board work session on
September 13th. The line items projected to have the most significant changes are as
follows:
Revenue
4635 Design Fees:
Decrease resulting from the reduction of the Landscape
Architect and a limited number of projects.
4762 Memberships:
Increase projected due to (1) additional Community Center
memberships resulting from health care fitness reimbursement
programs and (2) anticipated increased SandVenture
memberships with proposed waterslide enhancements.
4775 Ice Rental-Exempt: Increase projected due to increased hourly rates and a high
demand for ice time.
Expenditures
6002 Wages FT-Reg:
Decreased the full time wages by eliminating the Landscape
Architect position.
6202 Operating Supplies: Decrease attributed to eliminating funds to purchase new fitness
equipment for 2009.
6315 Building Maint:
Decrease based on expenses from previous years.
6360 Utilities:
Increase attributed to higher energy costs.
6430 Building Rent
Increase attributed to adjusting the rate charged to each
building to catch up to building value.
6336 Printing
Decrease attributed to condensing the brochure to three
brochures a year versus four.
Other Considerations
One item that Council and the Advisory Board may want to discuss is the amount of
building rent charged to each building. The rent for 2009 was adjusted to reflect the rent
that should be charged to each building based on the current costs of the facility. The
Community Center and Ice Arena's building rent increased by 33% and the Aquatic
Facility building rent increased by 51% (this increase includes the new slide but the rent
was increased in 2008 to account for the new building),
An increase is necessary but as we are looking at tighter budgeting should the building
rent be increased all in one year or should the increases come over the next couple of
years to spread out the impact? Neither the Community Center, Ice Arena nor Aquatic
facility is scheduled for replacement or renovation within the upcoming years.
Budget Improvement Packages
There are several budget improvement package options detailed on the attached sheets
that the Advisory Board and Council may want to consider. They include:
. Ice Arena Lighting Enhancements $35,000 Building Fund
. Community Center Lighting Enhancements $27,000 Building Fund
. Point of Sale Software $20,400 Telecom?
. Additional Cameras and Memory Upgrade $10,000
. Concrete Curb Work at SandVenture $5,000
. Increased Desk Coverage $15,000
As City Council moves through the budget process, further consideration will need to be
given to whether any of these requests are funded.
REQUESTED ACTION
Review and provide direction to staff.
Shakopee Parks and Recreation
2009 Budget Improvement Package
Project/Improvement:
Ice Arena lighting enhancements and Energy Savings
Prepared by:
Joshua Barrick
Arena Operations
Improvement Description:
To upgrade the lighting levels in the Ice Arena with brighter and more energy efficient T-5
lighting.
Description of Need:
Currently the Ice Arena has a lighting system that is 12yrs old and the type of lighting is a
400Watt metal halide technology. Although the current system is in working operation there is a
need to improve the efficiency of the lighting and the overall lighting levels. The chart below
indicates the lighting levels we currently have, the recommended lighting levels and the
proposed lighting levels. Lighting levels are measured in foot candles (FC) and recommend
lighting levels came form Illuminating Engineering Society of North America (IESNA).
Area Current Recommended Proposed
T -5 replacement
Ice Arena 52 FC 100 FC 100 FC
60 fixtures 60 fixtures
T -5 lamps are a very intense lighting source, which makes them a good choice for high-bay
direct lighting systems. The new T -5 technology is estimated at 50% more efficient than the
system we currently have. The T -5 fixtures hold eight amps and use ~ the kilowatts.
Costs:
To replace the sixty 400watt metal halide fixtures with sixty T-5 eight lamp fixtures with
installation included is $35,000. Rebates would likely be available but were not confirmed buy
SPUC at this time.
Anticipated Revenue:
There would be an energy saving of an estimated amount of $3,000-5,000 per year.
Impact on City Service Levels by Funding the Improvement:
The City would benefit form the energy savings and the increased lighting levels in Ice Arena.
The improved lighting would also help with video taping of high school games/youth games and
the over all appearance of the ice Arena.
Shakopee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5,000 or more, the following
information should be provided:
Project/Improvement:
Community Center lighting enhancements.
Prepared by:
Joshua Barrick
Improvement Description:
To upgrade the lighting levels in the gymnasium and fitness room/aerobics room with brighter
and more energy efficient T-5Iighting.
Description of Need:
Currently the gymnasium and fitness areas of the community center are poorly lit buy the
current lighting system. The poor lighting produces a dark unpleasant feeling in the effected
areas. The current system is 12yrs old and the type of lighting is a 400Watt metal halide
technology and although the current system is in working operation there is a need to improve
the efficiency of the lighting and the overall lighting levels. The chart below indicates the lighting
levels we currently have, the recommended lighting levels and the proposed lighting levels.
Lighting levels are measured in foot candles (FC) and recommend lighting levels came form
Illuminating Engineering Society of North America (IESNA).
Area Current Recommended Proposed
T -5 replacement
Gymnasium 20 FC 50 FC 52 FC
30 fixtures 30 fixtures
Aerobics / Fitness 16.5 FC 30 FC 34 FC
8 fixtures 9 fixtures
T-5lamps are a very intense lighting source, which makes them a good choice for high-bay
direct lighting systems. The new T -5 technology is estimated at 50% more efficient than the
system we currently have. The T-5 fixtures hold eight amps and use % the kilowatts.
Budget Division and Costs:
7754-6315: To replace the thirty-eight 400watt metal halide fixtures with thirty-nine T-5 eight
lamp fixtures is $27,000. This includes all installation costs.
Anticipated Revenue:
There would be an energy savings of an estimated amount of $3,000-5,000 per year, which
would result in a 4-6 year pay back. Rebates may be available from Public Utilities as well,
although we have not been able to get a response from Utilities on what rebates could be
available.
Impact on City Service Levels by Funding the Improvement:
The City would benefit form the energy savings and the increased lighting levels in both the
Gym and Fitness Room/Aerobics Room. The improvements would also help the overall
appearance of the Community Center.
Shakopee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5, 000 or more, the following
information should be provided:
Project/Improvement: MaxSolutions Point of Sale Module
Prepared by: Sherry Dvorak, Recreation Supervisor
Improvement Description:
MaxSolutions Point of Sale will integrate front desk, admissions, pro shop, concessions,
registrations, memberships and more into one system.
Point of Sale will be located at Community Center, SandVenture Aquatic Park and the Ice
Arena.
Description of Need:
The addition of this application will stream-line the financial reporting for our department and
give us better financial accountability.
Costs:
All costs to support the improvement (include salary, benefits, training, equipment, and any
other costs). Please identify costs by item:
Purchase of system: $9800.00
Training: $1000.00
Equipment
(3) Partner Tech 5500:
Supplies
Maintenance
$6300.00
$ 300.00
$3,000.00
Total Estimated Costs:
$20,400
We hope to present this software purchase to the Telecommunications Commission for potential
funding assistance.
Anticipated Revenue:
This is not anticipated to bring in additional revenue but will improve our financial accounting
records.
Impact on City Service levels by Funding the Improvement:
Staff will be able to print daily reports that will detail all types of income from each business day.
All revenue from admissions, programs, rentals, concessions and pro-shop sales will be
included. It will no longer require staff to compile hand written daily reports from each
department and manually transfer to a single report,
Shakopee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5,000 or more, the following
information should be provided:
Project/lmprovement:
Teen Center Carpet Replacement
Prepared by:
Brad Eller
Improvement Description:
Replace stained and worn Teen Center carpet.
Description of Need:
The Enigma Teen Center carpet (previously multi-purpose room) is permanently stained, is
worn and needs replacing. The room has been used as a wrestling practice space, as a
temporary library site and is currently a teen center. It has had significant public use and many
major furniture and fixture changes over time.
The room is utilized primarily as a teen drop in center and is open 7 days a week. It hosts live
band and DJ events every week. It also serves as an alternate program space for other
recreation programs and has become a staff meeting space. The room is available for private
rentals.
The maintenance staff has cleaned the carpets regularly, but stains and wear are evident.
Costs:
All costs to support the improvement (include salary, benefits, training, equipment, and any
other costs). Please identify costs by item:
$20,000 (based on an estimate of doubling the youth building carpet replacement).
Anticipated Revenue:
Anticipated additional revenue as a result of the improvement. Please identify additional
revenue by item:
The replaced carpet will provide a new clean look. Improving the appearance of the teen center
through carpet replacement will likely make it a more inviting location for alternative program
space, meetings and rentals. I believe that this may result in rental revenue increasing by $500-
$1500 per year.
Impact on City Service Levels by Funding the Improvement:
Facility will be presentable for users and will be in line with other flooring improvements that
have already been completed at the Community Center site in the past year or two,
Shakopee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5,000 or more, the following
information should be provided:
Project/Improvement: Additional Cameras and Memory Upgrade
Prepared by: Travis M. Karlen
Improvement Description: This project would add 2 additional cameras to the camera
network at the Shakopee Community Center. These cameras would cover the Skate Park
and area outside the Teen Center. Right now our recording time is about 4 days with our
system. With the addition of these cameras we will also need to upgrade that recording
time and memory to keep the quality of the recording.
Description of Need: The areas we are suggesting an upgrade for are our new problem
spots at the center. Because the service desk is so busy much of the evening, we are
unable to keep a constant monitor on the Skate Park. The same issue is apparent in the
area outside of the teen center. The police have had much success with the utilization of
our current system to identify individuals who are causing problems at the center
including the identification of a youth who stole a car from our parking lot.
Costs:
All costs to support the improvement (include salary, benefits, training, equipment, and any
other costs). Please identify costs by item:
$10,000
Anticipated Revenue:
Anticipated additional revenue as a result of the improvement. Please identify additional
revenue by item:
Revenue would not be increased, but customer safety would increase and we anticipate that
behavior issues may also be cut at the Community Center.
Impact on City Service levels by Funding the Improvement: City Service level would
increase by surveillance of some of our problem areas.
Shako pee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5,000 or more, the following
information should be provided:
Project/Improvement: Concrete Curb work around water area at SandVenture Aquatic
Park
Prepared by: Travis M. Karlen
Improvement Description: This project would take out old concrete areas around the
curb of the pool and replace with new curbs. There are some portions of the curb that
are cracked, missing, present tripping hazards, or safety concerns.
Description of Need: There are portions of the curb around the pool that need to be
replaced. The needs are anywhere from fixing cracked areas to completely replacing
sections.
Costs:
All costs to support the improvement (include salary, benefits, training, equipment, and any
other costs). Please identify costs by item:
$5,000.00
Anticipated Revenue:
Anticipated additional revenue as a result of the improvement. Please identify additional
revenue by item:
No added revenue, but a safer area for users.
Impact on City Service Levels by Funding the Improvement: Less maintenance in
regards to patching and fixing by City Staff.
Shakopee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5,000 or more, the following
information should be provided:
Project/Improvement: Desk Coverage at Shakopee Community Center during open
hours.
Prepared by: Travis M. Karlen
Improvement Description: Currently the desk is covered portions of the day by full time staff
that are pulled away from other duties to do so. Both of our administrative assistant staff have
many job duties that do not get accomplished or are delayed due to their receptionist duties at
the service desk.
Description of Need: Currently it is in the budget for a part time staff to cover a few of the AM
periods of opening, a % staff who covers the 8am - 12:00 shift and staff that cover the 4:30 -
10pm shift. We are still in need of a service desk staff who can cover some of the AM times and
cover the 12 - 4:30 times at the service desk.
Costs:
All costs to support the improvement (include salary, benefits, training, equipment, and any
other costs). Please identify costs by item:
$12, 300 (Cost of Afternoon Staff including training and other costs)
$2, 700 (Cost of AM Staff including training and other costs)
Total: $15,000
Anticipated Revenue:
Anticipated additional revenue as a result of the improvement. Please identify additional
revenue by item:
The revenue added would potentially increase because of the quality of coverage and marketing
this person could do at the service desk. The quality of customer service would also increase.
Impact on City Service Levels by Funding the Improvement: City service level would
increase. We would be able to help our customers more effectively.
'f.
CITY OF SHAKO PEE
RECREATION FUND
2009 BUDGET
MISSION STATEMENT:
To provide,
recreation
contribute
develop, protect, and enhance excellent park
services, open spaces, and natural resources
to a high-quality of life for our residents.
and
that
ACTIVITY:
The Recreation Fund provides resources for the administration of
comprehensive leisure services, recreation facilities, and park design
and construction administration. This includes the coordination and
scheduling of park and athletic field use; coordinating youth, adult,
and senior programs and special event activities; managing the
operation of the Community Center, Ice Arena, Aquatic Park, and Youth
Building; and conducting park land acquisition and development.
GOALS:
1. Effectively promote and coordinate park facilities, athletic
complexes, Aquatic Park, Ice Arena, and Community Center, ensuring
quality experiences while maximizing use potential.
2. Assess resident's recreation programming needs and focus continued
program development on meeting those needs.
3. Develop comprehensive preventative maintenance program to ensure
longevity of facilities and equipment.
4. Work with residents and developers to plan and design parks that
meet the needs of the neighborhood and the community.
MEASUREMENT OF GOALS:
1. Total use of the park facilities, Aquatic Park, Ice Arena, and
Community Center, with an increase of 15% use in each area for
2009.
2. Increase program participation for 2009 by 5% through increased
registration and new program development.
3. Develop comprehensive preventative maintenance and replacement
programs for Aquatic Park, Ice Arena, and Community Center.
OBJECT DESCRIPTION: Description of lines items:
Salaries (Full-Time):
Parks & Recreation Director; Recreation Supervisor Athletics,
Adult Activities, and Summer Programs; Recreation Supervisor
Aquatics and Community Center Operations; Recreation Supervisor -
Youth, Teen, and Senior Programs; Recreation Supervisor - Ice Arena
Operation; Facility Maintenance Worker (Mike-Aquatics, Ice Arena &
Community Center); Custodian (Russ- Community Center); Parks and
Recreation Secretary; and Office Service Worker, Park and Landscape
Designer (only in Rec09-updated-2) ($550,650).
Salaries (Part-Time):
Lifeguards and Water Safety Instructors (45); Recreation Program
Activity Leaders (25); Community Center Staff (15), Ice Arena Staff
(10); Teen Center Staff (10), and Outdoor Rink Attendants (10).
($424,810) .
Operating Supplies (6202):
Items used in the daily operation of the Aquatic Park, Ice Arena,
and Community Center, park development, natural resources
including: pool chemicals; paper products; uniform;: cleaning
supplies; cooling tower chemicals; fitness equipment; skates for
rental; park design materials; wristbands ($55,600).
Office Supplies (6210)
Office supplies; replacement
($11,250) .
computers
(3) ;
Arcview support
Recreation Supplies (6211):
Items used to conduct sports and recreation activities, including
sports equipment, arts and crafts supplies, teaching aids, etc.
($40,750)
Motor Fuels (6222)
Gasoline and propane ($6,750).
Building Maintenance Supplies (6230)
Pool filtration systems; doors and door closures;
supplies; TV replacements; arena glass and board
replacement arena flooring material; hockey goal;
fixtures; plumbing fixtures and mirrors; gym floor
materials ($32,700).
paints and
replacement;
lights and
resurfacing
Equipment Maintenance Supplies (6240):
Fitness and weight room equipment parts; volleyball net and pole
repairs; air filters; ice resurfacer parts and supplies; floor
scrubber/sweeper/extractor maintenance ($8,050).
Merchandise (6250):
Aquatic Park concessions; arena pro shop ($13,750).
Sales Tax (6290):
Tax on general admission, memberships, pro shop, concessions, and
facility rentals ($13,650)
Building Maintenance Professional Services (6315):
Ongoing maintenance and operation of buildings, including
mechanical service contracts for heating, cooling, electrical,
refrigeration equipment, elevators, rug service, rodent control,
fire alarm and security system monitoring and testing, seal coat
parking lot ($42,500).
Equipment Maintenance (6316)
Copier service contract ($4,000)
Transportation Professional Services (6324):
Bussing for youth trips, senior trips, and ski club ($9,000).
Performers Professional Services (6325):
Performers for Concerts in the Parks, Teen Center, and special
events ($26,900).
2
Other Professional Services (6327):
Admissions for senior and youth trips;
Sports camps contract fees; WSI fees; ADA
admission for ski club;
consulting ($28,900).
Postage (6332):
Postage for mailings ($5,250).
Telephone (6334):
Phone service for the Community Center, Ice Arena, Aquatic Park,
and Tahpah Park, and cellular for select staff ($6,450).
Printing/Publishing (6336):
publication of program catalog in conjunction with
Education; printing of flyers, forms, letterhead, maps,
and envelops for recreation programs, registration, and
center memberships; park development; special park and
and community center brochure ($26,000).
Community
brochures
community
trail map
Advertising (6338):
Advertising in newspaper and publications for department activities
and staff recruitment ($12,000).
Insurance (6352-6256):
Insurance for Recreation Programs, Community Center, Ice Arena, and
Aquatic Park ($56,800).
Utilities (6360)
Water, sewer, natural gas, electricity, and storm sewer for the
Aquatic Park, Ice Arena, and Community Center ($252,000).
Equipment Rental (IS Fund) (6425):
Rental for ice resurfacers (2)
($17,090) .
and department vehicles
(2)
Building Rentals (IS Fund) (6435) :
Building fund rental charges for Aquatic Park, Ice Arena, and
Community Center ($366,410)
Conferences/Schools/Training (6472):
Registration for association conferences, seminars, and training
sessions ($6,250).
Travel (6475):
Mileage for use of personal vehicles; travel expenses for attending
association meetings, conferences, and seminars ($2,300).
Dues (6480):
Professional association dues ($3,650).
Subscriptions and publications (6490):
Magazine, newspaper, and trade publication subscriptions ($400).
Credit Card Fees (6650):
Service charge for credit card fees ($6,750).
3
CITY OF SHAKOPEE
RECREATION FUND
2009 BUDGET
BUDGET SUMMARY
2006 2007 2008 2009
Actual Actual BudQet Proposed
Revenue
Taxes $ $ $ $
Licenses & Permits 2,420
Intergovernmental
State Aid
Charges for Service 922,564 972,113 1,030,330 1,019,600
Miscellaneous
Rentals 12,000 12,000 18,250 24,000
Interest 39,745 54,606 20,000 50,000
Contributions 654 2,086 1,000 2,500
Miscellaneous 3,116 5 3,250 16,500
Total Revenue 980,499 1,040,810 1,072,830 1,112,600
Expenditures
Personal Services 1,219,877 1,226,097 1,227,270 1,255,760
Supplies & Services 896,213 928,795 990,570 1,068,190
Capital 51,403
Total Expenditures 2,116,090 2,206,295 2,217,840 2,323,950
Excess(Deficiency) of
Revenues over Expenditures (1,135,591) (1,165,485) (1,145,010) (1,211,350)
Transfer In 1,287,110 1,108,770 1,145,010 1,211,350
Transfer Out
Asset Transfer Out
Excess (Deficiency) Of Revenues
and Other Sources Over
Expenditures and Other Uses 151,519 (56,715)
Fund Balance January 1 257,858 409,377 352,662 352,662
Fund Balance December 31 $ 409,377 $ 352,662 $ 352,662 $ 352,662
4
R5509BUD LOGIS005 CITY OF SHAKOPEE 8/6/2008 9:30:49
Fiscal Period: 6 I 8 Budget Report Page -
Level Of Rollup 7
2005 2006 2007 6/30/2008 2008 2009 2009 2009
Actual Actual Actual YTD Final Requested Approved Final
Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget
07500 RECREATION FUND
75 RECREATION PROGRAMS
6000 EXPENDITURES
6001 WAGES & BENEFITS
6002 WAGES 506,612 587,544 573.565 294,351 565,200 544,650 544,650 544,650
6005 OVERTIME-FT 7,033 7,799 9,755 2,005 5,250 4,000 4,000 4,000
6015 WAGES - PART TIMEITEMP 345,141 390,958 427,563 174,362 413,470 424,810 424,810 424,810
6017 OVERTIME-PART TIMEITEMP 7,546 8,236 9,012 2,541 6,500 3,000 3,000 3,000
6002 WAGES 866,334 994,538 1,019,895 473,259 990,420 976,460 976,460 976,460
6100 BENEFITS
6122 PERA 35,500 43,19B 42,722 23,390 50.700 51,480 51 ,480 51,480
6124 FICA 65,567 74,174 75,052 34,615 75,760 74,690 74,690 74,690
6135 HEALTH 58,236 61,376 60,679 30,240 56,450 74,200 74,200 74,200
6139 POST EMPLOYMENT HEALTH PLAN 3,096 3,348 3,086 1,415 2,850 2,700 2,700 2,700
6140 L1FE/L TO 2,455 2,783 2,607 1,231 2,690 2,750 2,750 2,750
01 6145 DENTAL 3,471 3,979 3,703 1,816 3,650 4,320 4,320 4,320
6160 UNEMPLOYMENT 22 3,150 3,780 11,000 11,000 11,000 11,000
6170 WORKERS COMPENSATION 18.287 21,965 24,592 7,422 20,350 27,560 27,560 27,560
6180 COMPENSATED ABSIOPEB 20,104 14,516 9,389- 13,400 30,600 30,600 30,600
6100 BENEFITS 206,739 225,340 206,202 103,908 236,850 279,300 279,300 279,300
-~
6001 WAGES & BENEFITS 1,073,073 1,219,877 1,226,097 577,167 1,227,270 1,255,760 1,255.760 1,255,760
6200 SUPPLIES AND SERVICES
6201 SUPPLIES & SERVICES
6202 OPERATING SUPPLIES 60,908 77 ,649 63,351 34,382 78,200 55,350 55,350 55,350
6210 OFFICE SUPPLIES 13,802 9,965 7,913 5,960 16,950 11,250 11,250 11,250
6211 RECREATION SUPPLIES 39,835 40,205 37,720 15,462 48,380 40,750 40,750 40,750
6212 UNIFORMSICLOTHING 1,493
6215 MATERIALS 1,156
6222 MOTOR FUELS & LUBRICANTS 4,002 6,300 6,144 3,555 5,750 6,750 6,750 6,750
6230 BUILDING MAINT SUPPLIES 31,830 39,526 21,194 14,650 40,250 32,700 32,700 32,700
6240 EQUIPMENT MAINTENANCE 2,891 4,555 9,208 487 7,650 6,050 8,050 8,050
6250 MERCHANDISE 12,596 11,916 21,124 7,686 16,000 13,750 13,750 13,750
6290 SALES TAX 14,150 13,650 13,650 13,650
6201 SUPPLIES & SERVICES 165,865 190,117 167,609 63,677 227,530 182,250 182,250 182,250
6300 PROFESSIONAL SERVICES
6310 ATTORNEY 1,582 3,484 6,340 1,977
R5509BUD LOGIS005 CITY OF SHAKOPEE 8/6/2008 9:30:49
Fiscal Period: 6 / 8 Budget Report Page - 2
Level Of Rollup 7
2005 2006 2007 6/30/2008 2008 2009 2009 2009
Actual Actual Actual YTD Final Requested Approved Final
Object Code I Description Amount Amount Amount Actual Budget Budget Budget Budget
6312 ENGINEERING CONSUL TNTS 11,015 2,690
6314 COMPUTER SERVICES 3,249 1,228 4,228 4,000 15,300 4,300 4,300 4,300
6315 BUILDING MAl NT. 54,679 83,310 45,751 15,316 64,600 42,500 42,500 42,500
6316 EQUIPMENT MAINTENANCE 4,538 3,316 1,002 4,157 4,600 4,000 4,000 4,000
6316 FILING FEES 146 116 613
6324 TRANSPORTATION 6,238 8,005 8,084 7,100 10,100 9,000 9,000 9,000
6325 PERFORMERS/INSTRUCTORS 5,454 13,270 40,388 24,633 19,700 26,900 26,900 26,900
6327 OTHER PROF SERVICES 49,176 59,450 68,744 22,006 29,050 28,900 28,900 28,900
6300 PROFESSIONAL SERVICES 124,916 183,226 177,344 79,801 143,350 115,600 115,600 115,600
6330 COMMUNICATIONS
6332 POSTAGE 6,916 5,453 5,707 1,991 6,230 5,250 5,250 5,250
6334 TELEPHONE 5,376 7,843 7,289 2,480 6,890 6,450 6,450 6,450
6336 PRINTING/PUBLISHING 13,945 13,268 23,494 8,194 31,000 26,000 26,000 26,000
6338 ADVERTISING 8,176 10,238 8,620 5,206 12,200 12,000 12,000 12,000
6330 COMMUNICATIONS 34,412 36,802 45,109 17,872 56,320 49,700 49,700 49,700
CD
6350 INSURANCE
6352 LIABILITY 22,883 22,253 26,614 28,500 33,500 33,500 33,500
6354 PROPERTY 7,812 7,342 12,098 18,350 23,000 23,000 23,000
6356 AUTO 1,152 990 772 800 300 300 300
6350 INSURANCE 31,847 30,585 39,484 47,650 56.800 56,800 56,800
6360 UTILITY SERVICE 90 180,000 252,000 252,000 252,000
6362 ELECTRIC 94,042 104,691 144,239 43,791
6364 WATER 9,859 12,311 4,232 1,182
6365 GAS 57,888 46.821 46,683 54,892
6366 SEWER 3,051 2,750 3,360 1,073
6368 STORM 3,721 3,802 3,702 1,690
6360 UTILITY SERVICE 168,561 170,374 202,305 102,629 180,000 252,000 252,000 252,000
6400 RENTALS
6410 LOGIS/SOFTWARE 16,822 10,986 10,892 1,890 4,500 4,500 4,500
6420 EQUIPMENT RENT 4,917 4,808 5,975 2,284 5,680 4,490 4,490 4,490
6425 EQUIPMENT RENT (IS FUND) 9,372 10,514 10,644 8,544 17,110 17,090 17,090 17,090
6430 BUILDING RENT (IS FUND) 237,024 244,322 253,740 143,640 267,280 366,410 366,410 366,410
6435 OTHER RENT 71 38 500
6400 RENTALS 268,206 270,667 281,751 156,358 310,070 392,490 392,490 392,490
6470 DUES/TRAININGITRAVEL
R5509BUD LOGIS005 CITY OF SHAKOPEE 8/6/2008 9:30:49
Fiscal Period: 6 / 8 Budget Report Page - 3
Level Of Rollup 7
2005 2006 2007 6/30/2008 2008 2009 2009 2009
Actual Actual Actual YTD Final Requested Approved Final
Object Code I Description Amount Amount Amount Actual Budget Budget Budget Budget
6472 CONFERENCE/SCHOOLfTRAINING 5,243 4,535 2,825 2,018 8,250 6,250 6,250 6,250
6475 TRAVEUSUBSISTENCE 1,295 1,268 1,362 301 5,000 2,300 2,300 2,300
6480 DUES 2,227 3,362 4,672 3,701 5,300 3,650 3,650 3,650
6490 SUBSCRIPTIONS/PUBLICATIONS 250 288 321 501 350 400 400 400
6470 DUES/TRAINING/TRAVEL 9,015 9,452 9,180 6,520 18,900 12,600 12,600 12,600
6200 SUPPLIES AND SERVICES 802,823 891,223 922,982 446,857 983,820 1,061,440 1,061,440 1,061,440
6500 DEPRECIATION
6501 DEPRECIATION EXPENSE
6600 MISCELLANEOUS
6640 DESIGNATED MISCELLANEOUS
6650 CREDIT CARD FEES 3,728 5,336 5,812 4,146 6,750 6,750 6,750 6,750
6660 CASH SHORT-OVR/BANK FEES 10 2- 1 86
6640 DESIGNATED MISCELLANEOUS 3,739 5,334 5,813 4,232 6,750 6,750 6,750 6,750
6600 MISCELLANEOUS 3,739 5,334 5,813 4,232 6,750 6,750 6,750 6.750
-....J
6700 CAPITAL OUTLAY
6740 EQUIPMENT 51,403 5,377
~- ~---~..~
6700 CAPITAL OUTLAY 51,403 5,377
6800 DEBT SERVICE
-~--
6000 EXPENDITURES 1.879,635 2,116,434 2,206,295 1,033,633 2,217,840 2,323,950 2,323,950 2,323,950
75 RECREATION PROGRAMS 1,879,635 2,116,434 2,206,295 1,033,633 2,217,840 2,323,950 2,323,950 2,323,950
07500 RECREATION FUND 1,879,635 2,116,434 2,206,295 1,033,633 2,217,840 2,323,950 2,323.950 2,323,950
Recreation
2009 Budget 7500 7751 7752 7753 7754 775S 7756 7757 7758 7761
Object Description Rec Fund Gen. Rec. Aquatics Ice Arena ClvCnt' Pk Services Teen Park Dev Facilities Rec Mgmt Total
Operating Revenue
4635 Design Fees
4762 Memberships 60,000 150,000 210,000
4766 Daily Admissions 55,000 4,000 30,000 6,000 25,000 120,000
4770 Lessons 90,000 25,000 115,000
4774 Ice Rental. Taxable 60,000 60,000
4775 Ice Rental - Exempt 186,000 188,000
4760 Youth Activities 164,500 164,500
4795 Adult Activities 46,000 10,000 56,000
4796 Room Rentals 10,000 2,000 12,000
4798 Park Facility Rental 17,000 17 ,000
4799 Park Field Rental 2,500 2,500
4800 Skate Sharpen,"g 2,000 2,000
4810 Concession Stand 32,000 1,500 2,000 35,500
4812 Vending Concession Commission 4,500 6,500 5,600 3,500 20,100
4814 Non-resident Fee 9,000 9,000
4816 Township Contributions 11,000 11,000
4817 Arena Advertising 5,000 5,000
4618 Other Rec. Fees 1,500 2,500 4,000
4833 Interest 50,000 50,000
4840 Rents 12,000 12,000
4845 Contributions 500 2,000 2,500
4850 Miscellaneous 500 12,000 1,000 3,000 16,500
Total Operating Revenue 50,000 232,000 237,500 292,500 230,500 26,000 37,600 6,500 1,112,600
Operating Expenses
6002 Wages FT - Reg 142,190 53,300 72,730 100,360 24,500 33,840 13,950 71,200 32,580 544,650
6005 Wages FT . aT 4,000 4,000
6015 Wages - PTlTemp 60,810 150,000 72,500 100,000 7,500 34,000 424,810
6017 Wages - PT - aT 1,000 1,000 1,000 3,000
6122 PERA 11,650 8,700 7,390 10,460 1,900 3,430 940 4,610 2,200 51,480
6124 FICA 15,530 15,630 11,180 15,710 2,440 5,190 1,070 5,450 2,490 74,690
6135 Health 74,200 74,200
6139 PEHP 2,700 2,700
6140 Life/LTD 2,750 2,750
6145 Dental 4,320 4,320
6,160 Unemployment 11,000 11,000
6170 Workers Comp 27,560 27,560
6180 Compensated Absences 30,600 30,600
Total Personnel 230,180 228,630 164,800 231,530 36,340 76,460 26,960 81,460 179,400 1,255,760
6202 Operating Supphes 1,000 17,000 13,750 20,000 2,500 500 250 350 55,350
6210 Office Supplies 2,500 2,500 1,000 4,500 250 250 250 11,250
6211 Recreation Supplies 26,700 3,000 500 1,500 7,000 50 40,750
6222 Motor Fuels 4,400 350 2,000 6,750
6230 Building Ma'"t Supplies 2,500 20,200 10,000 32,700
6240 Equipment Maintenance 500 2,550 5,000 8,050
6250 Merchandise 13,000 750 13,750
6290 Sales Tax 8,000 650 5,000 13,650
6314 Computer Services 300 4,000 4,300
6315 Building Maintenance 2,500 12,000 28,000 42,500
6316 Equipment Maintenance 1,500 400 400 1,500 200 4,000
6324 Transportation g,OOO 9,000
6325 Performers 11,400 1,500 12,000 2,000 26,900
6327 Other Prof Services 9,900 500 300 200 3,000 15,000 28,900
6332 Postage 1,000 750 500 2,000 300 200 500 5,250
6334 Telephone 2,000 1,300 750 1,000 600 300 500 6,450
6336 Printing/Publishing 4,000 1,500 2,000 3,500 1,000 500 1,000 12,500 26,000
6338 Advertising 1,500 2,500 500 5,000 1,500 1,000 12,000
6352 Liability Insurance 8,000 4,600 3,500 6,500 10,900 33,500
6354 Property Insurance 8,260 3,910 10,610 23,000
6356 Auto Insurance 300 300
6360 UtilitIes 22,000 115,000 115,000 252,000
6410 LOGIS/Software 2,250 2,250 4,500
6420 Equipmenl Rent 1,000 1,000 1,020 750 720 4,490
6425 Equipment Rent (IS Fund) 280 13,940 280 2,590 17,090
6430 Building Rent (IS Fund) 136,360 92,020 138,030 366,410
6472 Conference/SchoollTraining 1,000 750 750 1,750 2,000 6.250
6475 Travel/Subsistence 500 300 400 100 1,000 2,300
6460 Dues 400 200 650 1,650 750 3,650
6490 Subscriptions/Publications 50 150 200 400
6502 Depreciation
6650 Credit Card Fees 5,500 500 250 500 6,750
Total Supplies & Services 69,450 233,470 290,820 63,900 19,100 12,670 4,750 301,640 52,190 1,068,190
Capital Expenditures
Total Expenses 319,630 462,100 455,620 295,430 55,440 69,130 31,710 383,300 231,590 2,323,950
Net Income 50,000 (67,6301 (224,600) (163,120) (64,930) (29,440) (51,530) (31,7101 $ (383,300) (225,0901 (1,211,350)
8
Recreation Fund 2009 With COL Inc
Title/Description Step 3.0% FICA PERA
Facility & Rec Director E 89,428 $ 6,841 $ 6,036
Rec Supervisor A 67,684 5,178 4,569
Rec Supervisor A 67,684 5,178 4,569
Rec Supervisor A 67,684 5,178 4,569
Ice Area Supervisor A 67,684 5,178 4,569
Secretary A 50,768 3,884 3,427
Office Service Worker A 46,152 3,531 3,115
Landscape Designer A
Car Allowance N/A 3,600 275 243
Charge in Park Maint N/A 3,000 230 203
Charge In - Clerk 50% N/A 19,070 1 ,459 1,287
Charge In - Facilities N/A 71,200 5,447 4,806
Charge Out - Nat Res N/A (9,300) (711 ) (628)
Total Rec Fund (General) $ 544,654 $ 41,668 $ 36,765
9
Shakopee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5, 000 or more, the following
information should be provided:
Project/Improvement: MaxSolutions Point of Sale Module
Prepared by: Sherry Dvorak, Recreation Supervisor
Improvement Description:
MaxSolutions Point of Sale will integrate front desk, admissions, pro shop, concessions,
registrations, memberships and more into one system.
Point of Sale will be located at Community Center, SandVenture Aquatic Park and the Ice
Arena.
Description of Need:
The addition of this application will stream-line the financial reporting for our department and
give us better financial accountability.
Costs:
All costs to support the improvement (include salary, benefits, training, equipment, and any
other costs). Please identify costs by item:
Purchase of system: $9800.00
Training: $1000.00
Equipment
(3) Partner Tech 5500:
Supplies
Maintenance
$6300.00
$ 300.00
$3,000.00
Total Estimated Costs:
$20,400
We hope to present this software purchase to the Telecommunications Commission for potential
funding assistance.
Anticipated Revenue:
This is not anticipated to bring in additional revenue but will improve our financial accounting
records.
Impact on City Service Levels by Funding the Improvement:
Staff will be able to print daily reports that will detail all types of income from each business day.
All revenue from admissions, programs, rentals, concessions and pro-shop sales will be
included. It will no longer require staff to compile hand written daily reports from each
department and manually transfer to a single report.
10
Shakopee Parks and Recreation
2009 Budget Improvement Package
Instructions - for any improvement that results in an increase of $5,000 or more, the following
information should be provided:
Project/Improvement:
Community Center lighting enhancements.
Prepared by:
Joshua Barrick
Improvement Description:
To upgrade the lighting levels in the gymnasium and fitness room/aerobics room with brighter
and more energy efficient T-5 lighting.
Description of Need:
Currently the gymnasium and fitness areas of the community center are poorly lit buy the
current lighting system. The poor lighting produces a dark unpleasant feeling in the effected
areas. The current system is 12yrs old and the type of lighting is a 400Watt metal halide
technology and although the current system is in working operation there is a need to improve
the efficiency of the lighting and the overall lighting levels. The chart below indicates the lighting
levels we currently have, the recommended lighting levels and the proposed lighting levels,
Lighting levels are measured in foot candles (FC) and recommend lighting levels came form
Illuminating Engineering Society of North America (IESNA).
Area Current Recommended Proposed
T -5 replacement
Gymnasium 20 FC 50 FC 52 FC
30 fixtures 30 fixtures
Aerobics / Fitness 16.5 FC 30 FC 34 FC
8 fixtures 9 fixtures
T-5 lamps are a very intense lighting source, which makes them a good choice for high-bay
direct lighting systems. The new T -5 technology is estimated at 50% more efficient than the
system we currently have. The T-5 fixtures hold eight amps and use ~ the kilowatts.
Budget Division and Costs:
7754-6315: To replace the thirty-eight 400watt metal halide fixtures with thirty-nine T-5 eight
lamp fixtures is $27,000. This includes all installation costs.
Anticipated Revenue:
There would be an energy savings of an estimated amount of $3,000-5,000 per year, which
would result in a 4-6 year pay back. Rebates may be available from Public Utilities as well,
although we have not been able to get a response from Utilities on what rebates could be
available.
Impact on City Service Levels by Funding the Improvement:
The City would benefit form the energy savings and the increased lighting levels in both the
Gym and Fitness Room/Aerobics Room. The improvements would also help the overall
appearance of the Community Center.
11
Shakopee Parks and Recreation
2009 Budget Improvement Package
ProjecUlmprovement:
Ice Arena lighting enhancements and Energy Savings
Prepared by:
Joshua Barrick
Arena Operations
Improvement Description:
To upgrade the lighting levels in the Ice Arena with brighter and more energy efficient T-5
lighting.
Description of Need:
Currently the Ice Arena has a lighting system that is 12yrs old and the type of lighting is a
400Watt metal halide technology. Although the current system is in working operation there is a
need to improve the efficiency of the lighting and the overall lighting levels. The chart below
indicates the lighting levels we currently have, the recommended lighting levels and the
proposed lighting levels. Lighting levels are measured in foot candles (FC) and recommend
lighting levels came form Illuminating Engineering Society of North America (IESNA).
Area Current Recommended Proposed
T -5 replacement
Ice Arena 52 FC 100 FC 100 FC
60 fixtures 60 fixtures
T-5lamps are a very intense lighting source, which makes them a good choice for high-bay
direct lighting systems. The new T-5 technology is estimated at 50% more efficient than the
system we currently have. The T-5 fixtures hold eight amps and use 'Y:1 the kilowatts.
Costs:
To replace the sixty 400watt metal halide fixtures with sixty T-5 eight lamp fixtures with
installation included is $35,000. Rebates would likely be available but were not confirmed buy
SPUC at this time.
Anticipated Revenue:
There would be an energy saving of an estimated amount of $3,000-5,000 per year.
Impact on City Service Levels by Funding the Improvement:
The City would benefit form the energy savings and the increased lighting levels in Ice Arena.
The improved lighting would also help with video taping of high school games/youth games and
the over all appearance of the ice Arena.
12