Loading...
Recreation Fiscal Year 2023 Budget PresentationCopyrighted March 10, 2022 City of Dubuque Special Meeting Public Hearings # 4. IT E M T I T L E:Recreation F iscal Year 2023 Budget P resentation S UM M ARY: S UG G E S T E D D I S P O S I T I O N: AT TAC H ME N TS: Description Type Staff Memo_Added 3.10.22 Staff Memo Updated Recreation Policy Budget Book_Added 3.10.22 Supporting Documentation Recreation Policy Budget Book Supporting Documentation Presentation_Uploaded 3.10.22 Supporting Documentation TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Director of Finance and Budget SUBJECT: Fiscal Year 2023 Policy Budget Volume 4 and Resident’s Guide Replacement Pages DATE: March 10, 2022 Leisure Services Manager Marie Ware has updated improvement package #2 in the Recreation Division for AmeriCorps to clearly describe the benefit changes being recommended. Part of those changes included increasing the AmeriCorps Coordinator position from 0.278 FTE to 1.0 FTE and adding two additional AmeriCorps grants that were received to offset the cost. The increased cost to the Fiscal Year recommended budget is $45,569, which is offset by an increase in AmeriCorps grant revenue of $45,569. These changes were missed in the budget documents and now have been added. In addition, the description of the recommended improvement package for a full-time administrative position in the Recreation Division for AmeriCorps was inadvertently omitted from Policy Budget Volume 4 and has been added as improvement package #3. The impacted pages resulting from these changes are as follows: Policy Budget Volume 4  Recreation Pages 35-72 Resident’s Guide:  Budget Message Page 39 (FY23 Total operating budget was increased $45,569); Page 42 (recommended personnel changes updated for AmeriCorps Coordinator);  Budget in Brief Pages 94-95 and 98-100  Fact Sheet Page 133  Summary of Total Revenue and Expenditures Page 135  Summary of All Decision Packages Page 175  Full-Time Equivalent (FTE) Personnel Changes Recommended Page 186  Personnel Complement – Full-Time 1981-2023 Page 189  Financial Schedules Pages 193-228 Recreation -33- This page intentionally left blank. -34- RECREATION DIVISION Budget Highlights FY 2021 Actual FY 2022 Budget FY 2023 Requested % Change From FY 2022 Budget Expenses Employee Expense 1,402,745 1,915,442 2,040,783 6.5 % Supplies and Services 710,330 1,191,334 1,458,380 22.4 % Machinery and Equipment 54,584 104,020 104,080 0.1 % Debt Service 74,136 16,931 14,789 -12.7 % Total Expenses 2,241,795 3,227,727 3,618,032 12.1 % Resources Operating Revenue 1,274,598 1,746,801 1,698,588 -2.8 % CDBG Funds 43,597 132,754 134,717 1.5 % Sales Tax 20% for Debt Abatement 74,182 16,931 14,789 -12.7 % Total Resources 1,392,377 1,896,486 1,848,094 -2.6 % Property Tax Support 849,418 1,331,241 1,769,938 438,697 Percent Increase (Decrease) 33.0 % Percent Self Supporting 62.1 % 58.8 % 51.1 % Personnel - Authorized FTE 42.95 42.75 42.75 AMERICORPS Budget Highlights FY 2021 Actual FY 2022 Budget FY 2023 Requested % Change From FY 2022 Budget Expenses Employee Expense 321,504 407,360 615,987 51.2 % Supplies and Services 39,102 29,370 36,106 22.9 % Machinery and Equipment 1,871 4,220 350 (91.7) % Total Expenses 362,477 440,950 652,443 48.0 % Resources AmeriCorps Grant 288,502 203,761 267,913 31.5 % Private Participant 66,500 158,594 149,791 (5.6) % Total Resources 355,002 362,355 417,704 15.3 % Property Tax Support 7,475 78,595 234,739 156,144 Percent Increase (Decrease) 198.7 % Percent Self Supporting 97.9 % 82.2 % 64.0 % Personnel - Authorized FTE 1.00 2.28 5.00 -35- Improvement Package Summary Recreation Division: 1 of 4 This improvement request is for funding to offset lifeguard certification costs currently charged to the prospective employee. For individuals to become lifeguards, they are required to have the appropriate lifeguard certifications prior to working. These certifications range in cost from $30 for renewals to $200 for new certifications. As a seasonal summer position, these out of pocket fees can be both a deterrent and/or a barrier for individuals wanting to apply. This is especially true for low/moderate income youth. Having the funding to provide and market these certifications being included as part of the hiring process, will open these job opportunities to the entire community. This improvement level request directly relates to Council Goal(s):Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery Related Cost:$ 6,000 Tax Funds Recurring Recommend - Yes Net Cost:$ 6,000 Property Tax Impact:$ 0.0024 0.02% Activity: Swimming 2 of 4 This improvement request is for the purchase of 2 additional laptops for the Department. There were 2 laptops up for replacement in FY22. These were the Leisure Services Department laptop and the AmeriCorps office laptop. A memo was submitted and approved to recycle these laptops through FY22 for use at the Miracle League and for the AmeriCorps Coordinator. The Miracle League field scoreboard requires the use of a laptop to operate to capacity. In order to use the scoreboard for the grand opening event on August 10th, software was installed onto the laptop linking it to the proper online platform that is mirrored onto the scoreboard. Essentially, the scoreboard is a very large computer screen. The AmeriCorps Coordinator does not have a PC in the office and must use a VPN process to work remotely. However, this method is currently very slow when accessing key files and documents, and often prevents them from working as efficiently as they can. The use of the retired laptop will allow the AmeriCorps Coordinator to have a PC located within the Bunker Hill Administration offices and will allow the coordinator to connect remotely with ease, as well as easy transition to working back in the office. This improvement level request directly relates to Council Goal(s): Connected Community: Equitable Transportation, Technology Infrastructure, and Mobility Related Cost:$ 5,600 Tax Funds Non-Recurring Recommend - Yes Total Cost:$ 5,600 Property Tax Impact:$ 0.0022 0.02% Activity: Recreation Administration 3 of 4 This improvement request is for funding to purchase equipment and furnishings for the Comiskey Park Building. Throughout the Re-Imagine Comiskey engagement process for the park renovations, community members expressed the need to also re-think and re-use the indoor space at Comiskey by making it more accessible to the community. With the addition of the Teen Coordinator position in FY22 as well as staff development of potential new programs services in that space, there will be a need to make this space more desirable and functional for both local youth and adults. This funding will help to equip this space with amenities to further City services, through recreational outlets like table tennis, billiards, electronics, etc as well as amenities for community meetings and programs with projectors/ screens, computers and internet access. This improvement package directly relates to the Council -36- Goals: Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery Related Cost:$ 20,000 Tax Funds Non-Recurring Recommend - Yes Total Cost:$ 20,000 Property Tax Impact:$ 0.0079 0.08% Activity: Recreation Classes 4 of 4 This improvement request is for an increase in operating revenue for the Bunker Hill Golf Course through increases in the following fees: $10 increase on all annual passes. The sum of these fee increases would equate to $1,290 in additional revenue based on the FY23 usage estimates. This request supports the City Council goal of Financially Responsible, High-Performance City Organization. Related Cost:$ — Tax Funds Recurring Recommend - Yes Related Revenue:$ 1,290 Program Fees Recurring Net Cost:$ (1,290) Property Tax Impact:$ (0.0005) (0.01)% Activity: Golf Maintenance AmeriCorps: 1 of 3 This improvement request is to provide for $100,000 in grant cash match funding. This allows AmeriCorps to allocate cash match on an annual basis to the grants in the following ways: 1. Increase staffing capacity for program implementation. Human capacity is maxed out currently. The AmeriCorps Coordinator implements the programs effectively and addresses compliance directed from both the state and federal levels. All resources of cash match and in-kind match from the city are currently maxed out for the reading and teen grants. There are 53 AmeriCorps members (15 FTE) for grade level reading serving across 15 host sites and 20 members (10 FTE) for the teen grant serving across 7 host sites. The Director recruits, interviews, onboards, trains, retains and exits 73 members plus maintains compliance with grant requirements, reaching performance measure outcomes, and writing the annual grants to continue the program. This package provides benefits and .216 FTE to make the AmeriCorps Coordinator full-time and adds part time clerical support (.7 FTE). 2. Living allowance increase & match funding to leverage increased federal grant funding. This increase would maintain ARPA-based increases to the AmeriCorps Member living allowances. Members currently receive a stipend equal to $11.50/hr that would be raised to approx $13/hr. This is needed when the match waiver expires in FY23. 3. Development and implementation of a new Youth AmeriCorps Program - With increased staffing capacity, implementation of a Youth program, focused on community and civic career exploration and skill development and expansion of the current teen grant could happen. The focus would be at-risk and underrepresented minority teens successfully completing AmeriCorps requirements and learn employment skills. $10,000 would be for living stipends for approximately 10-15 Youth AmeriCorps members (ages 17-19). The youth will be eligible for an AmeriCorps Education Award. There would be active training and development for the adult AmeriCorps members to effectively work with and mentor teens and young adults (ages 12-19). The expansions above would positively affect the MFC, Four Mounds HEART and other partnering organizations and placements. This request supports the City Council goals of Diverse Arts, Culture, Parks, and Recreation Experiences and Activities, Partnership for a Better Dubuque, and Vibrant Community. It also supports the equity efforts of Leisure Services and City. This request is connected to the City Council goals & priorities of racial equity. -37- Related Cost:$ 100,000 Tax Funds Recurring Recommend - No Net Cost:$ 100,000 Property Tax Impact:$ 0.0393 0.40% Activity: AmeriCorps 2 of 3 This improvement request is to provide benefits for the AmeriCorps Coordinator and AmeriCorps Director/Community Impact Manager. These would be city funded benefits vs. grant funded requests. In FY 22 the AmeriCorps Coordinator was budgeted at .278 FTE. As additional grants were received the FTE during FY 22, the FTE was increased via council approval of grant agreements and grant funding for the position and amended into Budget Amendment number 2. The FY 23 proposal reflects 1.0 FTE which includes receiving three separate AmeriCorps grants. This threshold becomes a benefited position. It is a grant funded limited term position. In the past two of the three AmeriCorps grants were in Budget Amendment #2 thus the FTE in past budget approvals is lower than actual hours (FTE) due to grant approval timing and the federal fiscal year not aligning with the city fiscal year. The Coordinator is 97% grant funded for hours with only 3% city funding as grant writing and research cannot be covered in the grant. The Coordinator position frees hours and moves some grant responsibilities from the Coordinator to the AmeriCorps Director. This allows the Director to take on duties as the Community Impact Division Manager. The city funded benefits package will be used to match any future expansion of AmeriCorps grants. This improvement package request also moves the AmeriCorps Director/ Community Impact Division Manager’s benefits package to city funded vs. current grant funded benefits. This allows the Director to take on more duties as the Community Impact Division Manager that are not AmeriCorps grant funded duties. This request supports the City Council goals of Diverse Arts, Culture, Parks, and Recreation Experiences and Activities, Partnership for a Better Dubuque, and Vibrant Community. It also supports the equity efforts of the Department and City. Related Cost:$ 91,772 Tax Funds Recurring Recommend - Yes Related Revenue:$ 45,569 AmeriCorps Net Cost:$ 46,203 Property Tax Impact:$ 0.0182 0.19% Activity: AmeriCorps 3 of 3 This improvement request is for an additional full-time administrative assistant position (GE-25) to support the new division. This position will provide support to all projects within the division to ensure equitable, efficient, and effective program implementation. Some grant funded responsibilities of the AmeriCorps Coordinator will be transferred to this position allowing the AmeriCorps Coordinator to take on some grant responsibilities of the AmeriCorps Director. Examples include federal and state grant compliance, onboarding and exiting Members, support activities of the Volunteer DBQ Volunteer Center, support communication and coordination of community service projects and the Volunteer Reception Centers in times of disaster, communication efforts between collaborative partnerships, and supporting the research and best practices utilized within other communities. This request supports the City Council goals of Diverse Arts, Culture, Parks, and Recreation Experiences and Activities, Partnership for a Better Dubuque, and Vibrant Community. It also supports the equity efforts of the Department and City. Related Cost:$ 60,753 Tax Funds Recurring Recommend - Yes Property Tax Impact:$ 0.0239 0.25% Activity: AmeriCorps Significant Line Items Employee Expense 1.FY 2023 employee expense reflects a 3.25% wage package increase. -38- 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2022 The employee contribution of 6.29% is unchanged from FY 2022. 3.The City portion of health insurance expense increased from $1,086 in FY 2022 to $1,119 in FY 2023 per month per contract which results in an annual cost increase of $3,883 or 3.00%. 4.Five-Year Retiree Sick leave payout increased from $0 in FY 2022 to $4,575 in FY 2023. 5.Workers Compensation increased from $28,287 in FY 2022 to $29,816 in FY 2023. FY 2021 actual was $32,822. 6.During Fiscal Year 2022, the following personnel changes were approved: a.0.60 FTE Full-Time Lead Secretary position (GE-26) was changed to Lead Administrative Assistant (GE-28) which resulted in a cost increase of $4,039. b.1.04 FTE Seasonal Laborer Golf Course Groundskeeper (NA-12) pay rate was increased from $11.24 to $13.40 which resulted in a cost increase of $5,049. Depending on seasonal hires, this can range from 2-4 seasonal positions. c.1.16 FTE Seasonal Laborer Golf Course Operator (NA-08) pay rate was increased from $11.24 to $14.40 which resulted in a cost increase of $7,913. d.8.63 FTE Seasonal Lifeguard (NA-17) pay rate was increased from $10.13 to $12.50 which resulted in a cost increase of $46,440. Depending on seasonal hires, this can range from 15-20 seasonal positions. e.1.35 FTE Seasonal Swimming Pool Manager (NA-43) pay rate was increased from $14.61 to $18.00 which resulted in a cost increase of $10,512. Depending on seasonal hires, this can range from 2-4 seasonal positions. Supplies & Services 7.Sales Tax collected on goods and services decreased from $45,140 in FY 2022 to $44,177 in FY 2023. This line item is based on and off-set by the revenue for sales tax collected. 8.Electrical Utility Expense decreased from $86,246 in FY 2022 to $84,221 in FY 2023 based on FY 2019 actual. 9.Natural Gas Utility Expense increased from $26,386 in FY 2022 to $30,339 in FY 2023 based on FY 2019 actual plus 8.6%. 10.Property Maintenance increased from $38,310 in FY 2022 to $55,330 in FY 2023. This line item traditionally represents payments towards swimming pool maintenance, golf course grounds maintenance, Marina Maintenance and Allison Henderson/Comiskey Park maintenance. The FY 2023 increase is mostly due to a 50% payment of $15,000 per the Viking Dock Winterization contract. 11.Off Road Vehicle Fuel increased from $82,000 in FY 2022 to $97,255 to FY 2023 and Diesel Fuel increased from $15,000 in FY 2022 to $15,750 in FY 2023. This expenditure represents fuel sold to boaters at the Port of Dubuque Marina and is offset by $152,000 in revenue from the sale of fuel. FY2022 was an unusually high year due to low water levels which limited boat access to other marinas and it is projected that FY 2023 to be at more normal levels. 12.Turf Chemicals is unchanged from $31,000 in FY 2022 to $31,000 in FY 2023 which is utilized for golf course maintenance: fertilizer, pesticides, and anti-fungal products. FY 2021 actual was $29,574. -39- 13.Food Products increased from $48,051 in FY 2022 to $50,870 in FY 2023 based on current year's sales. FY 2021 actual was unusually low at $18,874 due to the closure of pool and adult athletic concessions, as well as the marina store closure due to the pandemic. This budget is offset by the revenue from sales of this product. 14.Beer Products increased from $46,012 in FY 2022 to $52,100 in FY 2023 based on current year's sales. FY 2021 actual of $41,462 was unusually low due to the closure of adult athletic concessions, as well as the marina store closure due to the pandemic. This budget is offset by the revenue from sales of this product. 15.Beverage and Ice decreased from $20,316 in FY 2022 to $19,816 in FY 2023 based on FY 2022 year-to-date. FY 2021 actual of $11,417 was unusually low due to the closure of pools and adult athletic concessions, as well as the marina store closure due to the pandemic. This budget is offset by the revenue from sales of this product. 16.Credit Card Charges increased from $25,172 in FY 2022 to $31,369 in FY 2023. FY 2021 actual was $25,006. Included in the budget is Golf Operations for $15,984 which is based on a three- year average. Also included is $2,800 for the Port of Dubuque dock, which was zero last year, and is based on 2% of fuel sales. 17.Program Equipment and Supplies increased from $65,344 in FY 2022 to $83,675 in FY 2023, due to a decrease in youth sports. This budget line item is for concession supplies, bases, basketballs, volleyballs, nets, first-aid supplies, trophies, community engagement Rec & Roll events, and other playground equipment. 18.Pro Shop Merchandise increased from $37,328 in FY 2022 to $38,641 in FY 2023 based on current demand for special order through the golf course. FY 2021 actual was $36,141. This budget is offset by the revenue from Pro Shop Sales, golf fee revenue, event revenue, and certificates. 19.Game Officiating Services decreased from $36,670 in FY 2022 to $26,870 in FY 2023. FY 2021 actual of $3,040 was unusually low due to the pandemic. There has been a decline in softball and basketball participation since the pandemic. 20.Machinery and Equipment Rental is unchanged from $42,351 in FY 2022 to $42,351 in FY 2023 based on FY 2021 actual. This line item is for the lease payments on sixty golf carts, tournament golf carts, beverage carts and cart maintenance, and portable restroom rentals. 21.Pay to Other Agency is increased from $161,810 in FY 2022 to $361,810 in FY 2023. This line item represents payments to local partners to provide equitable programs and unique experiences for low-income youth and underrepresented populations. These include but are not limited to: the Four Mounds Day Camp ($50,000), ice rental ($10,000), AmeriCorps 3rd Grade Reading ($20,000), AmeriCorps Playground Programs ($21,986), Hills and Dales Senior Center ($18,200), Recreation Classes (Arts programming, Creative Adventure Labs Partnership, Montessori Cooperative classes, Dubuque County Extension Contracted Classes) ($20,000). 22.Instructors decreased from $92,162 in FY 2022 to $89,099 in FY 2023. FY 2021 actual was $20,845 due to a reduction in programming which resulted from the pandemic. This line item represents after school sports coaches, sports camps, LEAP program, dance instructors, and other recreational class/program instructors. 23.Machinery and Equipment Maintenance decreased from $21,112 in FY 2022 to $20,987 FY 2023 and is based on FY 2022 budget, with some small adjustments in the Administrative and Golf -40- Operations areas. This line item represents marina machinery and equipment maintenance, fire suppression replacements, golf course equipment maintenance and repairs, swimming pool equipment maintenance, concession stand equipment replacements, and scoreboard maintenance. 24.Promotion is unchanged from $18,266 in FY 2022 to $18,266 in FY 2023. This line item represents print and digital marketing for recreational programs, events, and classes, brochures and mailings, and radio and print advertisements. 25.General Liability Insurance increased from $23,402 in FY 2022 to $29,004 in FY 2023 based on FY 2022 actual plus 12%. 26.Property Insurance increased from $8,184 in FY 2022 to $12,534 in FY 2023 based on FY 2022 actual plus 9.5%. Previous year was under budgeted due to Bunker Hill and the two pools being inadvertently omitted from the budget allocation. 27.Golf Specialty Supplies decreased from $14,563 in FY 2022 to $12,471 in FY 2023 due to a decrease in special equipment orders and related to revenues. The amount is based on FY 2021 actual of $12,370. 28.Motor Vehicle Gas increased from $12,978 in FY 2022 to $13,628 in FY 2023. FY 2021 actual was $18,136. Increase is due to the increased potential for single rider requirements on golf carts but less than FY 2021 with more two-rider carts being allowed. 29.Diesel Fuel increased from $15,000 in FY 2022 to $15,750 in FY 2023. FY 2021 actual was $13,833. Much like off road vehicle fuel, FY2022 was an unusually good year and expect FY 2023 to be at more normal levels. 30.Telephone increased from $9,667 in FY 2022 to $13,476 in FY 2023. FY 2021 actual was $13,476. Increase is in the Recreation Admin area which increased from $2,916 to $6,837 due to the addition of six smartphones for staff. -41- Machinery & Equipment 31.Equipment replacement items include ($104,430): Recreation Administration Smart Phone $ 1,680 Defibrillator $ 1,500 File Cabinets $ 2,800 Golf Operations Flat Screen TV $ 3,200 Golf Maintenance Greens Mower $ 53,000 Sand Trap Rake $ 19,000 Swimming Defibrillator $ 3,000 McAleece Concessions Concession Equipment $ 1,000 Recreation Classes Movie Projector $ 1,300 Movie Screen $ 4,500 Port of Dubuque Marina Cameras $ 7,500 AmeriCorps Smartphone $ 350 Recommended Improvement Packages $ 5,600 Total Equipment $ 104,430 Debt Service 32.FY 2023 Annual debt service is as follows ($14,789): Amount Debt Series Payment Source Purpose Final Payment Year Call Date $ 1,190 2021A (2012E) G.O.Sales Tax 20%Recreation Improvements 2022 2022 $ 13,599 2021A (2014B) G.O.Sales Tax 20%Recreation Improvements 2034 2028 $ 14,789 Total Recreation Annual Debt Service Revenue 33.Total revenue for Golf Operations and Maintenance decreased from $936,808 in FY 2022 to $929,407 in FY 2023. a.Golf Cart Rentals increased from $227,850 in FY 2022 to $232,950 in FY 2023 based on FY 2023 cart rental estimates of: 6,900 18-Hole Half Carts at $16 each; 7,200 9-Hole Half Carts at $10 each; 130 punch cards at $230 each; 31 season passes at $650 each, and 100 pull carts at $5 each. FY 2021 Actual was $233,088. -42- b.Golf Beer Sales decreased from $130,501 in FY 2022 to $118,440 in FY 2023 due to a decrease in large events. FY 2021 actual was $109,963. c.Pro Shop Sales decreased from $68,795 in FY 2022 to $68,452 in FY 2023 due to a decrease in large events. FY 2021 Actual was $68,452. d.Golf Fees increased from $355,500 in FY 2022 to $367,690 in FY 2023 based on the number of rounds played and passes sold during FY 2020. FY 2021 Actual was $373,709, but budget is slightly lower due to seeing less events/large group activities. e.Golf event revenue unchanged from $40,698 in FY 2022 to $40,698 in FY 2023 based on FY 2019 actual. 34.Swimming revenue decreased from $330,486 in FY 2022 to $290,310 in FY 2023. a.Swimming Annual Passes decreased from $78,143 in FY 2022 to $66,448 in FY 2023. FY 2021 actual was $740. FY23 is based on June 2019 through August 2019 numbers. b.Flora Daily Fees is decreased from $82,050 in FY 2022 to $65,690 in FY 2023. FY 2021 actual was $36,796. FY23 is based on June 2019 through August 2019 numbers. c.Sutton Daily Fees is decreased from $28,214 in FY 2022 to $22,610 in FY 2023. FY 2021 actual was $2,674. FY23 is based on June 2019 through August 2019 numbers. d.Pool Concessions is unchanged from $51,000 in FY 2022 to $51,000 in FY 2023 based on estimated gross sales of $36,000 at Flora Pool and $15,000 at Sutton Pool. FY 2021 actual was $13,825. FY23 is based on June 2019 through August 2019 numbers. e.Swim Lesson Registrations decreased from $73,789 in FY 2022 to $66,412 in FY 2023 based on registration estimates. FY 2021 actual was $37,357 because of pool closure with the pandemic. FY23 is based on June 2019 through August 2019 numbers. 35.Adult Athletics revenue decreased from $96,142 in FY 2022 to $64,044 in FY 2023 and is based on FY 2022 participant numbers. a.Softball Entry Fees is decreased from $49,208 in FY 2022 to $29,250 in FY 2023. FY 2021 actual was $25,025. FY23 is based on registration trends from both FY 2020 and FY2021 seasons. b.Basketball Entry Fees is decreased from $26,400 in FY 2022 to $13,200 in FY 2023. FY23 is based on registration trends from both FY 2020 and FY2021 seasons. c.Adult Winter Volleyball Leagues is increased from $12,800 in FY 2022 to $13,860 in FY 2023. FY23 is based on registration trends from both FY 2020 and FY2021 seasons. 36.Youth Sports revenue decreased from $50,030 in FY 2022 to $47,564 in FY 2023 and is based on FY 2022 participant numbers. a.After School Sports increased from $22,060 in FY 2022 to $29,760 in FY 2023, increase is due to the increase in sport offerings. FY 2021 actual was $11,017. 37.Port of Dubuque Marina revenue increased from $181,026 in FY 2022 to $208,926 in FY 2023. a.Marina Fuel Sales is increased from $125,000 in FY 2022 to $152,000 in FY 2023. This line item is based on the expense budget. FY 2022 actual is $173,424. FY2022 was an unusually high year due to low water levels which limited boat access to other marinas and it is projected that FY 2023 will be at more normal levels. b.Marina Dock Fees is decreased from $31,250 in FY 2022 $28,500 in FY 2023. This line item is based on the current year's sales as well as the current interest in seasonal slip rentals. FY 2021 actual was $25,398 and FY 2020 was $19,837. -43- c.Marina Beverage and Ice Sales is unchanged from $5,775 in FY 2022 to $5,775 in FY 2023. This line item is based on the current year's sales and on average a 65% mark-up on the cost of the product. FY 2021 actual was $706 and FY 2020 was $4,302. 38.The following chart shows the history of property tax support for the Port of Dubuque Marina: *POD Marina opened June 2013 Port of Dubuque Marina Property Tax Support $183,285 $152,082 $106,537 $73,629 $73,629 $48,235 $65,080 $42,502 $101,892 $120,726 FY 14 FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 Adopt e d FY 23 Req u e st e d $0 $50,000 $100,000 $150,000 $200,000 The decreases in tax support funding in FY17 through FY19 include operational changes in staffing due to a frozen full time Facilities Supervisor position which is budgeted in the Marina and Recreation Administration budgets. The Facilities Supervisor was replaced with temporary seasonal managerial staff. FY20 is a combination of these staff changes and two month of operation where the docks were opened due to COVID-19. Weather conditions and Mississippi River levels as well as flood gate closures affect the property tax support each year. Both the FY22 Adopted and FY23 Recommended budgets are based off of full operations which includes the frozen full time position. The increase from FY22 to FY23 is largely due to replacement of camera related equipment needed and a 50% payment of Viking Dock Winterization per the contract. Miscellaneous 39.The FY 2023 percent self-supporting for the various Recreation Activities compared to FY 2022 percent self-supporting is as follows: Activity FY 2023 FY 2022 Adult Athletics 50.8 % 71.4 % McAleece Concessions 133.2 % 144.0 % Youth Programs 19.0 % 19.1 % Therapeutic Recreation 30.4 % 31.4 % Recreation Classes 44.2 % 41.7 % Swimming 47.5 % 53.5 % Golf 100.3 % 106.1 % Port of Dubuque Marina 63.3 % 64.0 % -44- LEISURE SERVICES RECREATION DIVISION The Recreation Division encourages community participation by providing equitable, progressive, accessible, and affordable opportunities through our parks, facilities, and recreation programming. Vision: Creating equitable OPPORTUNITIES to enhance and improve the QUALITY OF LIFE for the residents of Dubuque. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -45- LEISURE SERVICES RECREATION DIVISION FY 2021 FY 2022 FY 2023 Full-Time Equivalent 42.95 42.75 42.75 Resources and Property Tax Support FY 2021 FY 2022 FY 2023 Operating Revenue CDBG Funds Property Tax Support 0 500000 1000000 1500000 2000000 The Recreation Division is supported by 42.75 full-time equivalent employees, which accounts for 56.41% of the department expense as seen below. Overall, the department's expenses are expected to increase by 12.09% in FY 2023 compared to FY 2022. Expenditures by Category by Fiscal Year $1,402,745 $710,330 $54,584 $74,136 $1,915,442 $1,191,334 $104,020 $16,931 $2,040,783 $1,458,380 $104,080 $14,789 FY 2021 FY 2022 FY 2023 Employee Expense Supplies and Services Machinery and Equipment Debt Service $0 $500,000 $1,000,000 $1,500,000 -46- RECREATION DIVISION Recreation Programming Mission & Services The Recreation Division develops a variety of recreational activities and job opportunities to provide the citizens of Dubuque equitable, safe, wholesome, healthy and enjoyable use of leisure time. Recreation programs include early childhood enrichment programs for children ages 18 months to 6 years old, youth and adult programs such as swim, karate, dance, athletics and music, as well as Therapeutic and Neighborhood recreation programs. Recreation Programming Funding Summary 0 FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $1,117,754 $2,027,058 $2,128,776 Resources $240,611 $633,737 $565,025 Recreation Programming Position Summary FY 2023 Lead Administrative Assistant 0.60 Facilities Supervisor 0.33 Customer Service Assistant - FT 1.00 Recreation Program Supervisor 2.00 Aquatic/Therapy Supervisor 1.00 Leisure Services Manager 0.33 Recreation Division Manager 1.00 Clerical Assistant 0.22 Recreation Leader 6.32 Recreation Field Supv 1.26 Recreation Field Supv. - CDBG 0.61 Recreation Leader Jr.0.92 Playground Coordinator 0.20 Assist. Playground Coordinator 0.10 Pre-School Instructor 0.12 Pre-School Instructor - CDBG 0.72 Swimming Pool Manager 1.35 Head Lifeguard 0.44 Lifeguard 8.63 Pool Cashier 1.01 Communications Assistant 0.50 Concession Worker - Pools 1.04 Concession Worker- McAleece 0.19 Concession Manager 0.40 Snack Bar Manager 0.20 Laborer - Youth Sports 0.09 Laborer - Swimming 0.48 Laborer - Adult Athletics 0.75 Total FT Equivalent Employees 31.81 -47- RECREATION DIVISION Recreation Programming Performance Measures City Council Goal: Diverse Arts, Culture, Parks, and Recreation Performance Measure (KPI)Target FY20 Actual FY21 Actual FY 2022 Estimated Performance Indicator 1 Activity Objective: Improve quality of life for residents by expanding and enhancing organized recreation activities. # of program opportunities offered through registration system N/A 258 448 600 N/A # average total of participation per program offered annually +.25 14.23 5.72 9 % of annual programs offered running (i.e. not canceled)+1%62%53%75% # of Rec & Roll trailer deployments N/A 34 77 55 N/A City Council Goal: Partnerships for a Better Dubuque 2 Activity Objective: Develop, increase, and retain partnerships in order to provide quality and affordable program opportunities for residents. # of partnerships resulting in a program 40+20 30 40 City Council Goal: Robust Local Economy 3 Activity Objective: Develop and provide quality entry-level job opportunities for youth and adults in the community. $ in salary costs for seasonal employees only (not including IPERS or SS) N/A $476,735 $340,469 $739,791 N/A 4 Activity Objective: Provide accessible, affordable, educational, and positive programming for those who many not have the financial resources to participate. # of free programs provided to those who qualified as low-income (does not incl. drop-in ex. playground, open gym, etc.) 60 9 56 60 % of total Recreation program low- income registrants who were served by free programs 70%99%50%70% # available scholarships for recreational programming 200 150 200 200 % of awarded scholarship credits that were redeemed for recreational programs 100%14%36%100 % of total swim passes issued that were purchased by low-income residents 50%0%0%50% -48- LEISURE SERVICES RECREATION DIVISION Bunker Hill Golf Course Mission & Services Bunker Hill Golf Course located in the rolling hills of Central Dubuque is a fun and challenging 18 - hole golf course. Visitors will be greeted daily by a warm and friendly staff ensuring high customer service levels along with many programs and offerings available for enjoyment. Bunker Hill Golf Course functions as an Enterprise Fund utilizing user fees to support operational costs and capital improvements. Income includes regular green fees, cart rentals, season passes, league fees, and concession sales. Bunker Hill Golf Course Funding Summary =FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $792,308 882,620 926,353 Resources $863,452 936,808 929,407 Bunker Hill Golf Course Position Summary FY 2023 Golf Course Supervisor 1.00 Golf Professional 0.94 Assistant Golf Professional 1.36 Pro Shop Attendant 0.80 Golf Course Technician - FT 1.00 Golf Course Technician - PT 0.72 Laborer 2.20 Concession Worker - Golf 0.84 Total FT Equivalent Employees 8.86 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure (KPI)Target FY20 Actual FY21 Actual FY 2022 Estimated Performance Indicator 1 Activity Objective: Expand upon golf lesson programs offered to grow the game of golf and promote hospitality through quality customer service practices. # of Youth participating in free golf lessons +5%10 0 12 Youth Camp Participation +5%37 34 40 Participation by Women +5%27 29 32 Couples League +5%22 28 32 -49- LEISURE SERVICES RECREATION DIVISION Port of Dubuque Marina Mission & Services The Port of Dubuque Marina is a 78-slip transient marina drawing visitors to Dubuque from as far North as Minneapolis, Minnesota, as far South as Fort Lauderdale, Florida and many places in-between. The marina operates as a hotel on water, providing visiting boats with dock space, electricity, clean showers, laundry, guest Wi-Fi and concierge service from staff. From the marina, visitors are within walking distance of dining, lodging, a casino, shopping, entertainment, the National Mississippi River Museum & Aquarium and Dubuque’s Mississippi Riverwalk. The marina amenities building operates as the guest check-in desk for visiting boaters, as well as a convenience store along the river. Port of Dubuque Marina Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $218,534 $282,918 $329,914 Resources $176,033 $181,026 $208,926 Port of Dubuque Marina Position Summary FY 2023 Facilities Supervisor - Dock 0.33 Facilities Supervisor - C-Store 0.34 Marina Cashier/Clerk 0.83 Dock Worker 0.58 Total FT Equivalent Employees 2.08 Performance Measures City Council Goal: Diverse Arts, Culture, Parks, and Recreation Performance Measure (KPI)Target FY20 Actual FY21 Actual FY 2022 Estimated Performance Indicator 1 Activity Objective: Become a more visible and high-traffic docking location. increase # of docking customers 600 277 363 400 City Council Goal: Financially Responsible, High-Performance Organization 2 Activity Objective: Increase overall sales at the convenience store and additional revenue opportunities through programs and partnerships. decrease % of property-tax support <20%30%19%40% -50- LEISURE SERVICES RECREATION DIVISION AmeriCorps Mission & Services AmeriCorps is a national service program which awards communities federal funding to implement an AmeriCorps program in their community designed to meet a community's critical need. The City of Dubuque AmeriCorps Program focuses on the community's education needs and is sponsored by the City of Dubuque. The program's Partners in Learning grant is focused around Dubuque's Campaign for Grade-Level Reading. The program's Creating Opportunities grant is focused efforts in the areas of teen programming, mentorship and workforce and life skill development. The Volunteer DBQ Program is a Volunteer Generation Fund grant focused on strengthening Dubuque's Volunteer Infrastructure. AmeriCorps Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $362,477 $440,950 $652,443 Resources $355,002.43 $362,355 $417,704 AmeriCorps Position Summary FY 2023 AmeriCorps Coordinator 1.00 Community Outreach Coordinator 1.00 Comm Diversion/Prevention Coordinator 1.00 Secretary 1.00 AmeriCorps Program Director 1.00 Total FT Equivalent Employees 5.00 Performance Measures City Council Goal: Diverse Arts, Culture, Parks, and Recreation Program Year (Sept - Aug)Performance IndicatorPerformance Measure (KPI)Target 2020 - 2021 Actual 2021 - 2022 Actual 2022 - 2023 Estimated 1 Activity Objective: Ensure all students read at grade-level by third grade through reading tutoring for K - 3rd grade students. # of students supported through AmeriCorps Partners in Learning Program 500 15*250 300 % of students participating in the AmeriCorps Campaign for Grade- Level Reading who improved literacy risk levels. 90%6%*70%80% *2020-2021 Program implementation and data collection was severely impacted by COVID-19. Only 15 of the 249 students served, only 15 student reached program dosage requirements. Only 1 student improved by a risk level. -51- City Council Goal: Diverse Arts, Culture, Parks, and Recreation Program Year (Sept - Aug)Performance IndicatorPerformance Measure (KPI)Target 2020 - 2021 Actual 2021 - 2022 Actual 2022 - 2023 Estimated 2 Activity Objective: Provide Dubuque Teens with safe, caring, adult role models so youth want to attend school, after-school programs, and summer programs. % of participating teens who successfully graduated from the MFC's Summer Teen Empowerment Program 90%85%87.5%90% City Council Goal: Partnerships for a Better Dubuque 3 Activity Objective: Keep youth engaged in stimulating, educational activities and surrounded by positive role models during the summer months. # of youth served by AmeriCorps summer learning opportunities and events 500 818 2427 3,000 -52- 100 43243 CAMPING FEES 18,522 19,837 31,250 31,250 100 43249 RENT,SLATTERY CENTER 13,739 13,968 13,987 14,113 100 43250 GOLF CART RENTALS 207,340 195,465 227,850 227,850 43 USE OF MONEY AND PROPERTY - Total 239,601 229,270 273,087 273,213 100 51190 CUSTOMER CREDITS 58 (468) 0 0 100 51516 DIESEL FUEL SALES 11,572 16,265 25,000 25,000 100 51536 FUEL SALES MARINA 62,565 94,725 100,000 100,000 100 51927 LOTTERY SALES 3 0 0 0 100 51930 SWIMMING-FLORA POOL 76,962 63,976 82,050 82,050 100 51931 SWIMMING-HEMP POOL 336 0 0 0 100 51932 SWIMMING-SUTTON POOL 27,949 26,450 28,214 28,214 100 51933 SWIMMING ANNUAL PASSES 66,483 14,347 74,118 78,143 100 51934 SWIM LESSON REGISTRATION 65,906 11,954 72,589 73,789 100 51935 SWIMMING POOL RENTAL 15,638 6,744 20,580 17,290 100 51936 SWIM POOL CONCESSIONS 41,605 29,198 50,000 51,000 100 51937 GOLF FEES 330,952 316,079 356,172 357,987 100 51938 GIFT CERTIFICATES-GOLF (41,601) (27,874) 0 0 100 51939 TENNIS FEES 6,047 646 6,635 6,575 100 51940 TENNIS COURT RESERVATIONS 34 94 34 34 100 51942 SOFTBALL ENTRY FEES 48,765 22,809 49,208 49,208 100 51943 FIELD RENTAL FEES 6,690 2,829 7,500 7,500 100 51944 BASKETBALL ENTRY FEES 25,700 21,852 26,400 26,400 100 51945 VOLLEYBALL ENTRY FEES 10,200 12,512 12,800 12,800 100 51946 AFTER SCHOOL SPORTS 24,433 10,620 17,500 22,060 100 51949 ART FEES 54,278 23,281 63,462 61,652 100 51950 VARIOUS PROGRAM FEES 6,682 3,462 11,942 13,142 260 51950 VARIOUS PROGRAM FEES 5,869 120 4,770 4,770 100 51951 CHILDRENS ATHLETIC FEES 5,519 475 4,200 4,195 100 51953 MEETING ROOM FEES 2,034 3,039 2,055 2,505 100 51954 PLAYGROUND REG FEES 2,280 (63) 2,000 1,900 100 51955 OTHER RENTS/CONCESSIONS 346 224 346 346 100 51959 BEER 166,971 126,867 168,701 171,993 100 51960 FOOD 45,014 27,684 47,301 48,111 100 51962 LIQUOR 28,346 26,677 28,346 28,346 100 51963 CATERING 3,100 1,279 3,100 3,100 100 51965 EVENTS REVENUE 40,689 40,698 40,689 40,698 100 51966 PRO SHOP SALES 72,880 53,207 73,295 73,295 100 51967 BEVERAGES/ICE 35,613 27,527 36,492 38,942 100 51968 CIGARETTE SALES 1,271 725 1,040 1,040 100 51989 GIFT CARD-GOLF 12,306 8,294 12,306 12,306 51 CHARGES FOR SERVICES - Total 1,263,494 966,253 1,428,845 1,444,391 100 53102 PRIVATE PARTICIPANT 6,600 5,000 7,300 5,700 100 53201 REFUNDS 0 300 0 0 100 53204 IOWA FUEL TAX REFUND 558 867 558 867 Recommended Operating Revenue Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Revenue FY21 Actual Revenue FY22 Adopted Budget FY23 Recomm'd Budget -53- 100 53530 SPECIALIZED SERVICES 96 21 300 300 100 53605 MISCELLANEOUS REVENUE 922 1,464 21,375 15,600 100 53615 DAMAGE CLAIMS (49) 0 0 0 100 53620 REIMBURSEMENTS-GENERAL 2,267 366,355 0 7,500 53 MISCELLANEOUS - Total 10,393 374,006 29,533 29,967 100 54106 EQUIPMENT SALES 0 0 4,000 4,000 100 54109 SALVAGE SALES 0 480 0 0 54 OTHER FINANCING SOURCES - Total 0 480 4,000 4,000 400 59350 FR SALES TAX CONSTRUCTION 17,270 15,355 16,484 16,931 59 TRANSFER IN AND INTERNAL - Total 17,270 15,355 16,484 16,931 RECREATION DIVISION - Total 1,530,758 1,585,364 1,751,949 1,768,502 Recommended Operating Revenue Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Revenue FY21 Actual Revenue FY22 Adopted Budget FY23 Recomm'd Budget -54- Recommended Operating Revenue Budget - Department Total 31 - AMERICORPS Fund Account Account Title FY20 Actual Revenue FY21 Actual Revenue FY22 Adopted Budget FY23 Recomm'd Budget 100 45771 FED PASS THRU STATE GRANT 215,743 288,502 203,761 267,913 45 STATE GRANTS - Total 215,743 288,502 203,761 267,913 100 53102 PRIVATE PARTICIPANT 19,880 66,500 158,594 149,791 100 53201 REFUNDS 0 358 0 0 100 53620 REIMBURSEMENTS-GENERAL 0 47 0 0 53 MISCELLANEOUS - Total 19,880 66,905 158,594 149,791 AMERICORPS - Total 235,623 355,407 362,355 417,704 -55- 100 61010 FULL-TIME EMPLOYEES 562,609 565,080 648,500 668,342 100 61020 PART-TIME EMPLOYEES 130,460 131,465 130,852 135,188 260 61020 PART-TIME EMPLOYEES 30 15,267 0 0 261 61020 PART-TIME EMPLOYEES 0 9,204 0 0 100 61030 SEASONAL EMPLOYEES 444,045 319,814 694,148 776,953 260 61030 SEASONAL EMPLOYEES 32,689 15,392 45,643 47,123 261 61030 SEASONAL EMPLOYEES 0 8,995 0 0 100 61050 OVERTIME PAY 2,961 4,524 3,800 3,800 100 61091 SICK LEAVE PAYOFF 2,770 2,770 0 4,575 100 61096 50% SICK LEAVE PAYOUT 323 398 323 398 100 61310 IPERS 74,950 74,597 97,960 102,547 260 61310 IPERS 2,438 2,730 2,712 2,800 261 61310 IPERS 0 1,688 0 0 100 61320 SOCIAL SECURITY 85,305 76,007 113,034 121,577 260 61320 SOCIAL SECURITY 2,503 2,345 3,492 3,605 261 61320 SOCIAL SECURITY 0 1,392 0 0 100 61410 HEALTH INSURANCE 129,274 126,159 129,409 133,292 100 61415 WORKMENS' COMPENSATION 31,141 31,563 26,748 28,202 260 61415 WORKMENS' COMPENSATION 1,412 0 1,539 1,614 261 61415 WORKMENS' COMPENSATION 0 1,260 0 0 100 61416 LIFE INSURANCE 447 445 578 453 100 61417 UNEMPLOYMENT INSURANCE 11,688 9,596 15,540 7,316 100 61620 UNIFORM ALLOWANCE 0 304 0 0 100 61640 SAFETY EQUIPMENT 3,850 331 900 900 260 61640 SAFETY EQUIPMENT 143 0 0 0 100 61660 EMPLOYEE PHYSICALS 134 1,420 264 2,098 61 - WAGES AND BENEFITS 1,519,171 1,402,745 1,915,442 2,040,783 100 62010 OFFICE SUPPLIES 2,419 2,031 5,745 2,446 260 62010 OFFICE SUPPLIES 186 95 186 186 100 62011 UNIFORM PURCHASES 1,109 1,153 6,310 6,296 100 62030 POSTAGE AND SHIPPING 6,424 1,761 5,773 5,847 260 62030 POSTAGE AND SHIPPING 1,000 0 1,020 1,020 100 62061 DP EQUIP. MAINT CONTRACTS 6,448 9,232 9,232 10,981 100 62062 JANITORIAL SUPPLIES 4,877 7,331 10,500 10,733 260 62062 JANITORIAL SUPPLIES 333 0 340 340 100 62063 SAFETY RELATED SUPPLIES 0 227 0 102 100 62090 PRINTING & BINDING 5,211 419 11,094 9,248 260 62090 PRINTING & BINDING 0 0 195 195 100 62110 COPYING/REPRODUCTION 1,489 1,045 2,044 1,973 100 62130 LEGAL NOTICES & ADS 0 17 0 0 100 62140 PROMOTION 11,027 5,760 18,266 18,266 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 317 18 379 379 100 62190 DUES & MEMBERSHIPS 1,612 2,398 2,423 2,784 100 62204 REFUNDS 41,426 120 0 0 100 62205 DRAM SHOP INSURANCE 7,861 6,432 9,268 8,668 Recommended Operating Expenditure Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget -56- 100 62206 PROPERTY INSURANCE 11,206 7,556 8,184 12,534 100 62208 GENERAL LIABILITY INSURAN 22,130 21,841 22,991 28,386 260 62208 GENERAL LIABILITY INSURAN 396 0 411 618 261 62208 GENERAL LIABILITY INSURAN 0 389 0 0 100 62210 SALES TAX 38,476 29,046 45,140 44,177 100 62211 PROPERTY TAX 1,932 1,980 1,971 2,020 100 62310 TRAVEL-CONFERENCES 5,639 90 7,140 7,140 100 62320 TRAVEL-CITY BUSINESS 950 0 1,113 1,113 100 62340 MILEAGE/LOCAL TRANSP 4,869 3,283 6,563 6,563 100 62360 EDUCATION & TRAINING 7,445 855 7,431 14,201 100 62411 UTILITY EXP-ELECTRICITY 91,034 49,712 86,246 84,221 100 62412 UTILITY EXP-GAS 16,720 7,948 26,386 30,339 100 62418 UTILITY EXP-REFUSE 1,443 1,335 1,466 1,398 100 62421 TELEPHONE 9,668 13,476 9,667 13,476 100 62431 PROPERTY MAINTENANCE 48,404 71,730 38,310 55,330 100 62433 CUSTODIAL SERVICES 4,888 4,460 5,073 5,165 260 62433 CUSTODIAL SERVICES 2,646 0 2,646 2,646 100 62436 RENTAL OF SPACE 220 660 220 660 100 62511 FUEL, MOTOR VEHICLE 11,105 18,136 12,978 13,628 100 62512 FUEL, OFF ROAD VEHICLE 57,456 97,255 82,000 97,255 100 62513 FUEL, DIESEL 9,600 13,833 15,000 15,750 100 62602 CIGARETTES 348 0 800 800 100 62611 MACH/EQUIP MAINTENANCE 39,776 12,182 21,112 20,987 100 62614 EQUIP MAINT CONTRACT 3,563 4,333 3,151 4,685 100 62624 GOLF SPECIALTY SUPPLIES 12,060 12,370 14,563 12,471 100 62627 CAMERA MAINTENANCE 672 0 897 897 100 62633 CHLORINE 11,023 4,571 12,216 12,216 100 62634 POOL CHEMICALS 2,651 2,186 12,163 12,163 100 62635 TURF CHEMICALS 29,781 29,574 31,000 31,000 100 62642 FOOD PRODUCTS 34,697 18,874 48,051 50,870 100 62643 BEER PRODUCTS 38,783 41,462 46,012 52,100 100 62644 LIQUOR PRODUCTS 2,994 5,329 6,000 6,000 100 62649 BEVERAGE/ICE 16,176 11,417 20,316 19,816 100 62663 SOFTWARE LICENSE EXP 5,628 6,593 13,622 11,817 100 62664 LICENSE/PERMIT FEES 4,496 4,636 5,864 5,853 100 62666 CREDIT CARD CHARGE 24,107 25,006 25,172 31,369 100 62667 DATA SERVICES 6,349 1,751 2,430 2,434 100 62668 PROGRAM EQUIP/SUPPLIES 32,135 19,845 45,574 63,905 260 62668 PROGRAM EQUIP/SUPPLIES 999 1,196 19,770 19,770 261 62668 PROGRAM EQUIP/SUPPLIES 0 812 0 0 100 62669 PROGRAMMING 0 (653) 0 0 100 62670 PRO SHOP MERCHANDISE 37,209 36,141 37,328 38,641 100 62678 EDUCATIONAL MATERIALS 1,368 2,391 2,434 2,434 100 62683 FIELD OPERATIONS SUPPLIES 332 506 1,000 1,500 100 62699 CASH SHORT AND OVER 340 655 0 0 Recommended Operating Expenditure Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget -57- 100 62710 CONTRACTOR SERVICES 0 25 0 0 100 62716 CONSULTANT SERVICES 4,533 1,047 4,500 4,500 100 62717 CRIMINAL BACKGROUND CHECK 2,266 1,083 5,800 1,083 400 62721 FINANCIAL CONSULTANT 0 107 0 0 100 62731 MISCELLANEOUS SERVICES 0 0 6,250 6,250 260 62731 MISCELLANEOUS SERVICES 0 0 3,000 3,000 100 62732 TEMP HELPCONTRACT SERV. 0 0 1,935 1,935 100 62735 GAME OFFICIATING SERVICES 23,814 3,040 34,870 25,070 260 62735 GAME OFFICIATING SERVICES 1,800 0 1,800 1,800 100 62736 CATERING SERVICES 2,085 479 3,170 3,170 100 62747 MACH/EQUIPMENT RENTAL 43,721 37,674 42,351 42,351 100 62751 INSTRUCTORS 44,880 20,845 92,162 89,099 100 62761 PAY TO OTHER AGENCY 452,008 16,580 111,810 311,810 260 62761 PAY TO OTHER AGENCY 63,571 6,572 50,000 50,000 100 62767 ENVIRON. TESTING/MON. 200 80 500 500 62 - SUPPLIES AND SERVICES 1,382,329 710,330 1,191,334 1,458,380 100 63311 ADMIN. OVERHEAD 0 85,043 85,043 85,043 100 63312 LESS ADMIN. RECHARGES 0 (85,043) (85,043) (85,043) 63 - ADMIN/OVERHEAD/STORES GAR 0 0 0 0 100 71118 PROJECTOR/CAMERA 0 0 0 1,300 100 71120 PERIPHERALS, COMPUTER 0 148 0 0 100 71124 COMPUTER 0 0 0 5,600 100 71214 FILES 0 0 0 2,800 100 71310 AUTO/JEEP REPLACEMENT 0 0 35,000 0 100 71410 SHOP EQUIPMENT 221 80 0 0 100 71521 REFRIGERATOR 0 0 0 500 100 71522 TRUCKSTER 0 0 9,000 0 100 71550 MISCELLANEOUS EQUIPMENT 5,277 0 1,500 500 100 71611 MOWING EQUIPMENT 26,000 45,634 52,000 53,000 100 71613 TRIMMERS 234 0 500 0 100 71617 AERATOR 7,875 0 0 0 100 71619 OTHER MAINT. EQUIPMENT 7,995 0 0 19,000 100 72414 TELEVISION 0 0 0 3,200 100 72416 VIDEO EQUIPMENT 0 0 0 4,500 100 72417 CAMERA RELATED EQUIPMENT 0 8,722 2,800 7,500 100 72418 TELEPHONE RELATED 214 0 3,220 1,680 100 72610 DEFIBRILLATOR 0 0 0 4,500 71 - EQUIPMENT 47,815 54,584 104,020 104,080 400 74111 PRINCIPAL PAYMENT 12,865 72,005 15,162 13,882 400 74112 INTEREST PAYMENT 2,490 2,132 1,769 907 74 - DEBT SERVICE 15,355 74,136 16,931 14,789 34 - RECREATION DIVISION TOTAL 2,964,671 2,241,795 3,227,727 3,618,032 Recommended Operating Expenditure Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget -58- Recommended Operating Expenditure Budget - Department Total 31 - AMERICORPS Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget 100 61010 FULL-TIME EMPLOYEES 63,083 68,024 115,688 274,594 100 61020 PART-TIME EMPLOYEES 8,563 18,369 0 0 100 61030 SEASONAL EMPLOYEES 160,439 170,056 209,425 196,385 100 61310 IPERS 6,763 8,156 12,361 25,922 100 61320 SOCIAL SECURITY 17,544 19,413 24,871 36,030 100 61410 HEALTH INSURANCE 13,988 24,547 26,064 67,134 100 61415 WORKMENS' COMPENSATION 8,137 12,235 14,041 10,893 100 61416 LIFE INSURANCE 73 73 110 229 100 61665 OTHER MEDICAL COSTS 0 630 4,800 4,800 61 - WAGES AND BENEFITS 278,591 321,504 407,360 615,987 100 62010 OFFICE SUPPLIES 4,271 697 120 120 100 62011 UNIFORM PURCHASES 6,251 1,569 1,530 1,500 100 62070 OFFICE EQUIP RENTAL 2,826 505 0 1,824 100 62110 COPYING/REPRODUCTION 151 1,903 1,824 0 100 62190 DUES & MEMBERSHIPS 0 1,258 0 0 100 62204 REFUNDS 11,531 2,892 0 0 100 62240 MISCELLANEOUS 3,137 332 0 0 100 62310 TRAVEL-CONFERENCES 3,897 0 4,339 4,194 100 62320 TRAVEL-CITY BUSINESS 710 36 0 0 100 62340 MILEAGE/LOCAL TRANSP 0 23 1,080 1,080 100 62360 EDUCATION & TRAINING 1,855 1,917 3,000 3,145 100 62421 TELEPHONE 668 666 1,344 720 100 62661 MISC. OPER. EXPENS 1,230 0 0 0 100 62663 SOFTWARE LICENSE EXP 74 2,014 784 784 100 62667 DATA SERVICES 980 8,540 6,120 6,244 100 62716 CONSULTANT SERVICES 0 218 0 0 100 62717 CRIMINAL BACKGROUND CHECK 1,426 1,092 2,916 2,862 100 62755 LEADERSHIP TRAINING 0 150 0 0 100 62761 PAY TO OTHER AGENCY 0 3,292 6,313 13,633 261 62765 GRANTS 0 12,000 0 0 62 - SUPPLIES AND SERVICES 39,009 39,102 29,370 36,106 100 71120 PERIPHERALS, COMPUTER 16,471 0 920 0 100 71124 COMPUTER 0 1,871 2,800 0 100 72418 TELEPHONE RELATED 0 0 500 350 71 - EQUIPMENT 16,471 1,871 4,220 350 31 - AMERICORPS TOTAL 334,071 362,477 440,950 652,443 -59- POD CSTORE OPERATION - 30550 FUNDING SOURCE: GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT — — 7,500 SUPPLIES AND SERVICES 49,948 75,825 78,848 WAGES AND BENEFITS 13,635 51,984 53,606 POD CSTORE OPERATION 63,583 127,809 139,954 POD DOCK MAINTENANCE - 30560 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 135,659 111,356 144,869 WAGES AND BENEFITS 19,293 43,753 45,091 POD DOCK MAINTENANCE 154,952 155,109 189,960 RECREATION ADMIN. - 34100 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR (85,043) (85,043) (85,043) EQUIPMENT 148 3,220 11,580 SUPPLIES AND SERVICES 51,516 143,988 149,136 WAGES AND BENEFITS 611,009 664,242 693,205 RECREATION ADMIN. 577,630 726,407 768,878 GOLF OPERATIONS - 34200 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — — 3,200 SUPPLIES AND SERVICES 190,256 200,333 209,969 WAGES AND BENEFITS 169,590 187,662 191,816 GOLF OPERATIONS 359,846 387,995 404,985 GOLF MAINTENANCE - 34250 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 29,155 29,155 29,155 EQUIPMENT — 2,800 3,000 SUPPLIES AND SERVICES 47,143 176,790 185,238 Recommended Expenditure Budget Report by Activity & Funding Sounce 34 - RECREATION DIVISION -60- WAGES AND BENEFITS 125,580 333,469 394,159 GOLF MAINTENANCE 201,878 542,214 611,552 SWIMMING - 34300 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 29,155 29,155 29,155 EQUIPMENT — 2,800 3,000 SUPPLIES AND SERVICES 47,143 176,790 185,238 WAGES AND BENEFITS 125,580 333,469 394,159 SWIMMING 201,878 542,214 611,552 ADULT ATHLETICS - 34400 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 25,129 25,129 25,129 EQUIPMENT — 1,500 0 SUPPLIES AND SERVICES 25,820 66,485 53,566 WAGES AND BENEFITS 8,407 41,563 47,464 ADULT ATHLETICS 59,356 134,677 126,159 MCALEECE CONCESSIONS - 34410 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — — 1,000 SUPPLIES AND SERVICES 14,678 25,227 27,069 WAGES AND BENEFITS 7,334 11,623 11,769 MCALEECE CONCESSIONS 22,012 36,850 39,838 YOUTH SPORTS/AFTER SCHOOL- 34420 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 25,501 73,971 67,991 WAGES AND BENEFITS 113,239 175,687 182,345 YOUTH SPORTS/AFTER SCHOOL 138,740 249,658 250,336 THERAPEUTIC/SENIOR PROG - 34430 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 8,722 — 0 Recommended Expenditure Budget Report by Activity & Funding Sounce 34 - RECREATION DIVISION -61- SUPPLIES AND SERVICES 27,613 14,962 15,504 WAGES AND BENEFITS 1,422 30,926 31,947 THERAPEUTIC/SENIOR PROG 37,758 45,888 47,451 RECREATION CLASSES - 34460 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — 35,000 5,800 SUPPLIES AND SERVICES 35,417 110,984 131,001 WAGES AND BENEFITS 5,916 12,626 13,044 RECREATION CLASSES 41,334 158,610 149,845 CD TARGET AREA PROG. - 34500 FUNDING SOURCE: COMMUNITY DEVELOPMENT Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 4,513 79,368 79,575 WAGES AND BENEFITS 58,273 53,386 55,142 CD TARGET AREA PROG. 62,786 132,754 134,717 DEBT SERVICE - 34700 FUNDING SOURCE: DEBT SERVICE Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget DEBT SERVICE 74,136 16,931 14,789 DEBT SERVICE 74,243 16,931 14,789 SENIOR CENTER - 79180 FUNDING SOURCE: COMMUNITY DEVELOPMENT Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 15,216 18,200 18,200 SENIOR CENTER $ 15,216.00 $ 18,200.00 18,200 RECREATION DIVISION TOTAL $2,241,795 $3,227,727 $3,418,032 Recommended Expenditure Budget Report by Activity & Funding Sounce 34 - RECREATION DIVISION -62- AMERICORP FORMULA 2021 - 34910 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 3,128 — — WAGES AND BENEFITS 86,226 — — AMERICORP FORMULA 2021 89,354 — — AMERICORP NONGRANT - 34911 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — 4,220 350 SUPPLIES AND SERVICES — 3,134 3,134 WAGES AND BENEFITS 6,648 71,953 239,787 AMERICORP NONGRANT 6,648 79,307 243,271 AMERICORP COMP 2021 - 34912 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 1,871 — — SUPPLIES AND SERVICES 18,368 — — WAGES AND BENEFITS 159,283 — — AMERICORP COMP 2021 179,523 — — AMERICORP FORM 21/22 - 34913 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGES AND BENEFITS — 20,235 — AMERICORP FORM 21/22 — 20,235 — AMERICORP AARA - 34914 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — — — SUPPLIES AND SERVICES 14,254 — 32,972 WAGES AND BENEFITS 46,952 — 319,451 AMERICORP REGULAR 18/19 61,206 — 352,423 AMERICORP SUPP 10/11 - 34916 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 130 — — Recommended Expenditure Budget Report by Activity & Funding Sounce 31 - AMERICORPS -63- WAGES AND BENEFITS 12,615 — — AMERICORP PLANNING 18/19 12,745 — — AMERICORP 3 - 34917 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 3,223 — — WAGES AND BENEFITS 9,779 — 56,749 AMERICORP SUMMER 18/19 13,002 — 56,749 AMERICORP COMP 21/22 - 34918 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES — 26,236 — WAGES AND BENEFITS — 315,172 — AMERICORP COMP 21/22 — 341,408 — AMERICORPS TOTAL $ 362,477 $ 440,950 $ 652,443 Recommended Expenditure Budget Report by Activity & Funding Sounce 31 - AMERICORPS -64- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 61010 Full Time Employee Expense 100 3375 GE-41 LEISURE SERVICES MANAGER 0.33 $ 42,992 0.33 $ 45,948 0.33 $ 47,841 100 5075 GE-36 RECREATION DIVISION MANAGER 1.00 $ 89,269 1.00 $ 90,577 1.00 $ 93,529 100 2975 GE-33 GOLF COURSE SUPERVISOR 1.00 $ 79,015 1.00 $ 80,198 1.00 $ 78,864 100 GE-33 AQUATIC/THERAP REC SUPV 1.00 $ 77,510 1.00 $ 78,670 1.00 $ 81,230 100 GE-33 FACILITIES SUPERVISOR 1.00 $ 60,636 1.00 $ 61,533 1.00 $ 63,537 100 5000 GE-33 RECREATION PROGRAM SUPV 2.00 $ 152,010 2.00 $ 154,286 2.00 $ 159,572 100 200 GE-26 LEAD SECRETARY 0.60 $ 27,888 0.60 $ 28,896 0.60 $ 33,925 100 225 GE-25 SECRETARY 1.00 $ 51,009 1.00 $ 51,747 1.00 $ 51,365 100 GD-06 GOLF COURSE TECHNICIAN 1.00 $ 55,674 1.00 $ 56,645 1.00 $ 58,479 TOTAL FULL TIME EMPLOYEES 8.93 $ 636,003 8.93 $ 648,500 8.93 $ 668,342 61020 Part Time Employee Expense 100 225 GE-25 COMMUNICATIONS ASST 0.50 $ 18,874 0.50 $ 20,087 0.50 $ 20,744 100 GD-33 GOLF PROFESSIONAL 0.94 $ 70,736 0.94 $ 71,796 0.94 $ 74,132 100 GD-06 GOLF COURSE TECHNICIAN 0.72 $ 37,340 0.72 $ 38,969 0.72 $ 40,312 TOTAL PART TIME EMPLOYEES 2.16 $ 126,950 2.16 $ 130,852 2.16 $ 135,188 61030 Seasonal Employee Expense 100 3675 NA-31 HEAD LIFE GUARD 0.44 $ 6,661 0.44 $ 6,661 0.44 $ 6,661 100 3450 NA-25 RECREATION FIELD SUPERVISOR 1.26 $ 39,986 1.26 $ 40,587 1.26 $ 41,905 260 3450 NA-25 RECREATION FIELD SUPERVISOR CDBG 0.61 $ 16,660 0.61 $ 16,914 0.61 $ 17,462 100 NA-23 MARINA CASHIER/CLERK 0.83 $ 18,611 0.83 $ 18,882 0.83 $ 18,882 100 NA-23 DOCK WORKER 0.58 $ 12,358 0.58 $ 12,546 0.58 $ 12,546 100 3700 NA-19 SWIMMING POOL MANAGER 1.35 $ 41,803 1.35 $ 42,423 1.35 $ 50,738 100 3650 NA-17 LIFE GUARD 8.63 $ 179,864 8.63 $ 182,512 8.63 $ 225,243 100 3525 NA-15 JUNIOR RECREATION LEADER 0.92 $ 15,656 0.92 $ 15,886 0.92 $ 16,405 100 890 NA-03 LABORER I —$ — 1.32 $ 29,010 1.32 $ 36,932 100 890 NA-01 LABORER TE 2 1.16 $ 29,452 1.16 $ 29,864 1.16 $ 36,695 100 890 NA-03 LABORER TE 1 2.36 $ 51,133 1.04 $ 22,910 1.04 $ 29,098 100 3550 NA-14 RECREATION LEADER 6.11 $ 131,366 6.32 $ 137,861 6.32 $ 142,347 260 3585 NA-35 PRE-SCHOOL INSTRUCTOR CDBG 0.72 $ 28,308 0.72 $ 28,729 0.72 $ 29,661 100 NA-35 PRE-SCHOOL INSTRUCTOR 0.12 $ 3,907 0.12 $ 3,967 0.12 $ 4,096 100 3625 NA-07 POOL CASHIER 1.01 $ 19,781 1.01 $ 20,077 1.01 $ 20,730 100 NA-45 ASSISTANT PRO 1.36 $ 45,780 1.36 $ 46,464 1.36 $ 47,986 100 NA-45 SNACK BAR MANAGER 0.20 $ 6,009 0.20 $ 6,009 0.20 $ 6,009 100 NA-36 CONCESSION MANAGER 0.40 $ 10,689 0.40 $ 10,846 0.40 $ 11,200 100 NA-18 CONCESSION WORKER II 2.07 $ 36,616 2.07 $ 36,958 2.07 $ 37,738 100 NA-28 CLERICAL ASSISTANT 0.22 $ 5,191 0.22 $ 5,264 0.22 $ 5,434 100 NA-45 AFTER SCHOOL SPORTS COORD 0.41 $ 14,142 —$ — —$ — 34 RECREATION DIVISION FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -65- 100 NA-27 PLAYGROUND COORDINATOR 0.20 $ 5,707 0.20 $ 5,791 0.20 $ 5,978 100 NA-27 ASSIST PLAYGROUND COORD 0.10 $ 2,506 0.10 $ 2,542 0.10 $ 2,624 100 NA-18 PRO SHOP ATTENDANT 0.80 $ 16,905 0.80 $ 17,154 0.80 $ 17,706 TOTAL SEASONAL EMPLOYEES 31.86 $ 739,091 31.66 $ 739,857 31.66 $ 824,076 TOTAL RECREATION DIVISION 42.95 $ 1,502,044 42.75 $ 1,519,209 42.75 $ 1,627,606 31 AMERICORPS 61010 Full Time Employee Expense 100 1185 AMERICORPS PROGRAM DIRECTOR 1.00 $ 63,099 1.00 $ 70,601 1.00 $ 72,830 100 GE-33 COMM DIVERSION/PREVENT COORD —$ — —$ — 1.00 $ 67,108 100 GE-25 SECRETARY —$ — —$ — 1.00 $ 40,378 100 NA-28 AMERICORPS COORDINATOR —$ — —$ — 1.00 $ 51,329 100 GE-28 COMMUNITY OUTREACH COORD —$ — 1.00 $ 44,641 1.00 $ 46,082 TOTAL FULL TIME EMPLOYEES 1.00 $ 63,099 2.00 $ 115,242 5.00 $ 277,727 61020 Part Time Employee Expense 100 NA-28 AMERICORPS COORDINATOR —$ — 0.28 $ 13,007 —$ — TOTAL PART TIME EMPLOYEES —$ — 0.28 $ 13,007 —$ — TOTAL AMERICORPS DIVISION 1.00 $ 63,099 2.28 $ 128,249 5.00 $ 277,727 TOTAL RECREATION AND AMERICORPS 43.95 $ 1,565,143 45.03 $ 1,647,458 47.75 $ 1,905,333 34 RECREATION DIVISION FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -66- Recreation Administration-FT 10034100 61010 100 200 GE-28 LEAD SECRETARY 0.60 $ 27,888 0.60 $ 28,896 0.60 $ 33,925 10034100 61010 100 GE-33 FACILITIES SUPERVISOR 0.33 $ 20,010 0.33 $ 20,306 0.33 $ 20,967 10034100 61010 100 225 GE-25 SECRETARY 1.00 $ 51,009 1.00 $ 51,747 1.00 $ 51,365 10034100 61010 100 4,280 GE-33 RECREATION PROGRAM SUPV 2.00 $ 152,010 2.00 $ 154,286 2.00 $ 159,572 10034100 61010 100 1,080 GE-33 AQUATIC/THERAP REC SUPV 1.00 $ 77,510 1.00 $ 78,670 1.00 $ 81,230 10034100 61010 100 3375 GE-44 LEISURE SERVICES MANAGER 0.33 $ 42,992 0.33 $ 45,948 0.33 $ 47,841 10034100 61010 100 5075 GE-36 RECREATION DIVISION MANAGER 1.00 $ 89,269 1.00 $ 90,577 1.00 $ 93,529 Total 6.26 $ 460,688 6.26 $ 470,430 6.26 $ 488,429 Recreation Administration-PT 10034100 61020 100 225 GE-25 COMMUNICATIONS ASST 0.50 $ 18,874 0.50 $ 20,087 0.50 $ 20,744 Total 0.50 $ 18,874 0.50 $ 20,087 0.50 $ 20,744 Recreation Administration-Seasonal 10034100 61030 100 NA-28 CLERICAL ASSISTANT 0.22 $ 5,191 0.22 $ 5,264 0.22 $ 5,434 Total 0.22 $ 5,191 0.22 $ 5,264 0.22 $ 5,434 Golf Operations-Seasonal 10034200 61030 100 NA-45 ASSISTANT PRO 1.36 $ 45,780 1.36 $ 46,464 1.36 $ 47,986 10034200 61030 100 NA-39 CONCESSION WORKER II 0.84 $ 12,716 0.84 $ 12,716 0.84 $ 12,716 10034200 61030 100 NA-18 PRO SHOP ATTENDANT 0.80 $ 16,905 0.80 $ 17,154 0.80 $ 17,706 Total 3.00 $ 75,401 3.00 $ 76,334 3.00 $ 78,408 Golf Operations-PT 10034200 61020 100 2,625 GE-33 GOLF PROFESSIONAL 0.94 $ 70,736 0.94 $ 71,796 0.94 $ 74,132 Total 0.94 $ 70,736 0.94 $ 71,796 0.94 $ 74,132 Golf Maintenance-FT 10034250 61010 100 2975 GE-33 GOLF COURSE SUPERVISOR 1.00 $ 79,015 1.00 $ 80,198 1.00 $ 78,864 10034250 61010 100 2622 GD-06 GOLF COURSE TECHNICIAN 1.00 $ 55,674 1.00 $ 56,645 1.00 $ 58,479 Total 2.00 $ 134,689 2.00 $ 136,843 2.00 $ 137,343 Golf Maintenance-PT 10034250 61020 100 GOLF COURSE TECHNICIAN 0.72 $ 37,340 0.72 $ 38,969 0.72 $ 40,312 Total 0.72 $ 37,340 0.72 $ 38,969 0.72 $ 40,312 Golf Maintenance-Seasonal 10034250 61030 100 890 NA-08 LABORER TE 2 1.16 $ 29,452 1.16 $ 29,864 1.16 $ 36,695 10034250 61030 100 890 NA-12 LABORER TE 1 1.04 $ 22,562 1.04 $ 22,910 1.04 $ 29,098 Total 2.20 $ 52,014 2.20 $ 52,774 2.20 $ 65,793 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -67- Swimming-Seasonal 10034300 61030 100 3675 NA-39 HEAD LIFE GUARD 0.44 $ 6,661 0.44 $ 6,661 0.44 $ 6,661 10034300 61030 100 NA-36 CONCESSION MANAGER 0.40 $ 10,689 0.40 $ 10,846 0.40 $ 11,200 10034300 61030 100 NA-18 CONCESSION WORKER II 1.04 $ 20,016 1.04 $ 20,299 1.04 $ 20,952 10034300 61030 100 3650 NA-17 LIFE GUARD 8.63 $ 179,864 8.63 $ 182,512 8.63 $ 225,243 10034300 61030 100 3625 NA-07 POOL CASHIER 1.01 $ 19,781 1.01 $ 20,077 1.01 $ 20,730 10034300 61030 100 890 NA-12 LABORER I 0.48 $ 10,413 0.48 $ 10,574 0.48 $ 13,430 10034300 61030 100 3700 NA-43 SWIMMING POOL MANAGER 1.35 $ 41,803 1.35 $ 42,423 1.35 $ 50,738 Total 13.35 $ 289,227 13.35 $ 293,392 13.35 $ 348,954 Adult Athletics-Seasonal 10034400 61030 100 3450 NA-25 RECREATION FIELD SUPERVISOR 0.43 $ 11,607 0.43 $ 11,785 0.43 $ 12,166 10034400 61030 100 890 NA-12 LABORER I 0.75 $ 16,271 0.75 $ 16,521 0.75 $ 20,984 10034400 61030 100 3550 NA-14 RECREATION LEADER 0.35 $ 7,527 0.35 $ 7,637 0.35 $ 7,885 Total 1.53 $ 35,405 1.53 $ 35,943 1.53 $ 41,035 McAleece Concessions-Seasonal 10034410 61030 100 NA-42 SNACK BAR MANAGER 0.20 $ 6,009 0.20 $ 6,009 0.20 $ 6,009 10034410 61030 100 NA-18 CONCESSION WORKER II 0.19 $ 3,884 0.19 $ 3,943 0.19 $ 4,070 Total 0.39 $ 9,893 0.39 $ 9,952 0.39 $ 10,079 Youth Sports-Seasonal 10034420 61030 100 3525 NA-15 JUNIOR RECREATION LEADER 0.92 $ 15,656 0.92 $ 15,886 0.92 $ 16,405 10034420 61030 100 NA-27 PLAYGROUND COORDINATOR 0.20 $ 5,707 0.20 $ 5,791 0.20 $ 5,978 10034420 61030 100 NA-27 ASSIST PLAYGROUND COORD 0.10 $ 2,506 0.10 $ 2,542 0.10 $ 2,624 10034420 61030 100 NA-45 AFTER SCHOOL SPORTS COORD 0.41 $ 14,142 —$ — —$ — 10034420 61030 100 NA-12 LABORER I 0.09 $ 1,887 0.09 $ 1,915 0.09 $ 2,518 10034420 61030 100 3450 NA-25 RECREATION FIELD SUPERVISOR 0.45 $ 16,192 0.45 $ 16,432 0.45 $ 16,967 10034420 61030 100 3550 NA-14 RECREATION LEADER 4.85 $ 104,306 5.06 $ 110,407 5.06 $ 113,999 Total 7.02 $ 160,396 6.82 $ 152,973 6.82 $ 158,491 Therapeutic Activity-Seasonal 10034430 61030 100 NA-25 RECREATION FIELD SUPERVISOR 0.15 $ 5,769 0.15 $ 5,854 0.15 $ 6,045 10034430 61030 100 NA-14 RECREATION LEADER 0.91 $ 19,533 0.91 $ 19,817 0.91 $ 20,463 Total 1.06 $ 25,302 1.06 $ 25,671 1.06 $ 26,508 Recreation Classes-Seasonal CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -68- 10034460 $ 61,030 100. 00 $ 3,585 NA-35 PRE-SCHOOL INSTRUCTOR 0.12 $ 3,907 0.12 $ 3,967 0.12 $ 4,096 10034460 61030 100 NA-25 RECREATION FIELD SUPERVISOR 0.24 $ 6,418 0.24 $ 6,516 0.24 $ 6,727 Total 0.36 $ 10,325 0.36 $ 10,483 0.36 $ 10,823 Port of Dubuque Marina Dock Maintenance-FT 10030560 61010 100 GE-33 FACILITIES SUPERVISOR 0.33 $ 20,010 0.33 $ 20,306 0.33 $ 20,967 Total 0.33 $ 20,010 0.33 $ 20,306 0.33 $ 20,967 Port of Dubuque Marina Dock Maintenance- Seasonal 10030560 61030 100 NA-23 DOCK WORKER 0.58 $ 12,358 0.58 $ 12,546 0.58 $ 12,546 Total 0.58 $ 12,358 0.58 $ 12,546 0.58 $ 12,546 Port of Dubuque Marina Convenience Store -FT 10030550 61010 100 GE-33 FACILITIES SUPERVISOR 0.34 $ 20,616 0.34 $ 20,921 0.34 $ 21,603 Total 0.34 $ 20,616 0.34 $ 20,921 0.34 $ 21,603 Port of Dubuque Marina Convenience Store- Seasonal 10030550 61030 100 NA-23 MARINA CASHIER/CLERK 0.83 $ 18,611 0.83 $ 18,882 0.83 $ 18,882 Total 0.83 $ 18,611 0.83 $ 18,882 0.83 $ 18,882 CD Target Area Programs-Seasonal 26034500 61030 260 3585 NA-35 PRE-SCHOOL INSTRUCTOR CDBG 0.72 $ 28,308 0.72 $ 28,729 0.72 $ 29,661 26034500 61030 260 3450 NA-25 RECREATION FIELD SUPERVISOR CDBG 0.61 $ 16,660 0.61 $ 16,914 0.61 $ 17,462 Total 1.33 $ 44,968 1.33 $ 45,643 1.33 $ 47,123 AmeriCorps - FT 10034910 61010 100 1185 AMERICORPS PROGRAM DIRECTOR 0.10 $ 6,310 —$ — —$ — 10034911 61010 100 1185 AMERICORPS PROGRAM DIRECTOR 0.06 $ 3,786 0.06 $ 4,223 0.07 $ 5,372 10034911 61010 100 COMMUNITY OUTREACH COORD —$ — 1.00 $ 44,641 1.00 $ 46,082 10034911 61010 COMM DIVERSION/ PREVENT COORD —$ — —$ — 1.00 $ 67,108 10034911 61010 SECRETARY —$ — —$ — 1.00 $ 40,378 10034911 61010 100 1185 AMERICORPS COORDINATOR —$ — —$ — 0.15 $ 10,344 10034912 61010 100 1185 AMERICORPS PROGRAM DIRECTOR 0.84 $ 53,003 —$ — —$ — 10034913 61010 100 1185 AMERICORPS COORDINATOR —$ — —$ — 0.20 $ 9,652 10034913 61010 100 1185 AMERICORPS PROGRAM DIRECTOR —$ — —$ — 0.81 $ 59,122 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -69- 10034918 61010 100 1185 AMERICORPS COORDINATOR —$ — 0.12 $ 8,580 0.65 $ 31,333 10034918 61010 100 1185 AMERICORPS PROGRAM DIRECTOR —$ — 0.82 $ 57,798 0.11 $ 8,336 Total 1.00 $ 63,099 2.00 $ 115,242 5.00 $ 277,727 AmeriCorps - PT 10034913 61010 100 1185 AMERICORPS COORDINATOR —$ — 0.11 $ 5,136 —$ — 10034918 61010 100 1185 AMERICORPS COORDINATOR —$ — 0.17 $ 7,871 —$ — Total —$ — 0.28 $ 13,007 —$ — TOTAL RECREATION DIVISION 43.95 $ 1,565,143 45.03 $ 1,647,458 47.75 $ 1,905,333 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -70- Capital Improvement Projects by Department/Division RECREATION DIVISION CIP Number Capital Improvement Project Title FY 20 Actual Expense FY 21 Actual Expense FY 22 Adopted Budget FY 23 Recomm'd Budget 1012886 LS DEFERRED MAINT ASSESS — — 90,000 — 1021456 SUTTON ZERO DEPTH SURVEY — — — 1,500 1021530 GOLF COURSE IRRIGATION 12,983 1,793 — — 1021563 FLORA-WATERSLIDE PUMP — — — 2,000 1021890 F&S ANNUAL MAINTENANCE — 46,196 30,000 135,000 1022120 FLORA POOL-SAND PLAYGRND — — — — 1022648 F&S POOL ASSESSMENTS — — — — 1022832 BUNKER HILL IMPROVEMENTS — — — — 1022834 REC OPERATING SYSTEM — — — — 1022885 POD DOCK MAINTENANCE — — 10,000 — 1022887 QUALITY OF LIFE ASSESS — — 40,000 — 1022888 EB LYONS SLOPE STABILIZE — — 49,500 — 3501058 BUNKER HILL REMODELING — — 30,000 — 3501446 FLORA/SUTTON POOL HEATERS — — — — 3701527 GOLF TEE IMPROVEMENTS — — 10,000 — 3701530 GOLF COURSE IRRIGATION — — — — 3702001 BUNKER CART PATHS — — 10,000 — RECREATION DIVISION TOTAL 12,983 47,989 269,500 138,500 -71- PROGRAM/ DEPT PROJECT DESCRIPTION FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 TOTAL PAGE RECREATION DIVISION Culture and Recreation Swimming Pools Flora and Sutton Pools Annual Maintenance $ 135,000 $ — $ — $ — $ — $ 135,000 90 Flora & Sutton Filter Tank Replacement $ — $ 200,000 $ — $ — $ — $ 200,000 91 Flora - Water Playground $ — $ — $ — $ 150,000 $ 150,000 $ 300,000 92 Flora & Sutton Admissions Counter Reconstruction - ADA $ — $ — $ — $ — $ 10,000 $ 10,000 93 Flora & Sutton Renovate Locker Rooms $ — $ — $ — $ — $ 60,000 $ 60,000 94 Sutton Pool Zero Depth Survey & Remediation $ 1,500 $ — $ — $ — $ 40,000 $ 41,500 95 Flora Pool Water Slide Assessment & Repairs $ 2,000 $ — $ — $ — $ 50,000 $ 52,000 96 Bunker Hill Golf Course Bunker Hill-Construct Cart Paths $ — $ — $ 10,000 $ — $ 10,000 $ 20,000 97 Bunker Hill Range Project $ — $ — $ 72,170 $ — $ — $ 72,170 98 Bunker Hill Golf Course - Tee Improvements $ — $ 10,000 $ — $ 10,000 $ — $ 20,000 99 Bunker Hill-Material Storage Reno $ — $ — $ — $ 15,000 $ — $ 15,000 100 Port of Dubuque Port of Dubuque Marina - Dock Maintenance $ — $ 10,000 $ 10,000 $ — $ — $ 20,000 101 Port of Dubuque Flood Wall Dubuque Welcome Sign $ — $ — $ — $ 30,000 $ — $ 30,000 102 TOTAL $ 138,500 $ 220,000 $ 92,170 $ 205,000 $ 320,000 $ 975,670 -72- Recreation -33- This page intentionally left blank. -34- RECREATION DIVISION Budget Highlights FY 2021 Actual FY 2022 Budget FY 2023 Requested % Change From FY 2022 Budget Expenses Employee Expense 1,402,745 1,915,442 2,040,783 6.5 % Supplies and Services 710,330 1,191,334 1,458,380 22.4 % Machinery and Equipment 54,584 104,020 104,080 0.1 % Debt Service 74,136 16,931 14,789 -12.7 % Total Expenses 2,241,795 3,227,727 3,618,032 12.1 % Resources Operating Revenue 1,274,598 1,746,801 1,698,588 -2.8 % CDBG Funds 43,597 132,754 134,717 1.5 % Sales Tax 20% for Debt Abatement 74,182 16,931 14,789 -12.7 % Total Resources 1,392,377 1,896,486 1,848,094 -2.6 % Property Tax Support 849,418 1,331,241 1,769,938 438,697 Percent Increase (Decrease) 33.0 % Percent Self Supporting 62.1 % 58.8 % 51.1 % Personnel - Authorized FTE 42.95 42.75 42.75 AMERICORPS Budget Highlights FY 2021 Actual FY 2022 Budget FY 2023 Requested % Change From FY 2022 Budget Expenses Employee Expense 321,504 407,360 570,418 40.0 % Supplies and Services 39,102 29,370 36,106 22.9 % Machinery and Equipment 1,871 4,220 350 (91.7) % Total Expenses 362,477 440,950 606,874 37.6 % Resources AmeriCorps Grant 288,502 203,761 222,344 9.1 % Private Participant 66,500 158,594 149,791 (5.6) % Total Resources 355,002 362,355 372,135 2.7 % Property Tax Support 7,475 78,595 234,739 156,144 Percent Increase (Decrease) 198.7 % Percent Self Supporting 97.9 % 82.2 % 61.3 % Personnel - Authorized FTE 1.00 2.28 4.40 -35- Improvement Package Summary Recreation Division: 1 of 4 This improvement request is for funding to offset lifeguard certification costs currently charged to the prospective employee. For individuals to become lifeguards, they are required to have the appropriate lifeguard certifications prior to working. These certifications range in cost from $30 for renewals to $200 for new certifications. As a seasonal summer position, these out of pocket fees can be both a deterrent and/or a barrier for individuals wanting to apply. This is especially true for low/moderate income youth. Having the funding to provide and market these certifications being included as part of the hiring process, will open these job opportunities to the entire community. This improvement level request directly relates to Council Goal(s):Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery Related Cost:$ 6,000 Tax Funds Recurring Recommend - Yes Net Cost:$ 6,000 Property Tax Impact:$ 0.0024 0.02% Activity: Swimming 2 of 4 This improvement request is for the purchase of 2 additional laptops for the Department. There were 2 laptops up for replacement in FY22. These were the Leisure Services Department laptop and the AmeriCorps office laptop. A memo was submitted and approved to recycle these laptops through FY22 for use at the Miracle League and for the AmeriCorps Coordinator. The Miracle League field scoreboard requires the use of a laptop to operate to capacity. In order to use the scoreboard for the grand opening event on August 10th, software was installed onto the laptop linking it to the proper online platform that is mirrored onto the scoreboard. Essentially, the scoreboard is a very large computer screen. The AmeriCorps Coordinator does not have a PC in the office and must use a VPN process to work remotely. However, this method is currently very slow when accessing key files and documents, and often prevents them from working as efficiently as they can. The use of the retired laptop will allow the AmeriCorps Coordinator to have a PC located within the Bunker Hill Administration offices and will allow the coordinator to connect remotely with ease, as well as easy transition to working back in the office. This improvement level request directly relates to Council Goal(s): Connected Community: Equitable Transportation, Technology Infrastructure, and Mobility Related Cost:$ 5,600 Tax Funds Non-Recurring Recommend - Yes Total Cost:$ 5,600 Property Tax Impact:$ 0.0022 0.02% Activity: Recreation Administration 3 of 4 This improvement request is for funding to purchase equipment and furnishings for the Comiskey Park Building. Throughout the Re-Imagine Comiskey engagement process for the park renovations, community members expressed the need to also re-think and re-use the indoor space at Comiskey by making it more accessible to the community. With the addition of the Teen Coordinator position in FY22 as well as staff development of potential new programs services in that space, there will be a need to make this space more desirable and functional for both local youth and adults. This funding will help to equip this space with amenities to further City services, through recreational outlets like table tennis, billiards, electronics, etc as well as amenities for community meetings and programs with projectors/ screens, computers and internet access. This improvement package directly relates to the Council -36- Goals: Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery Related Cost:$ 20,000 Tax Funds Non-Recurring Recommend - Yes Total Cost:$ 20,000 Property Tax Impact:$ 0.0079 0.08% Activity: Recreation Classes 4 of 4 This improvement request is for an increase in operating revenue for the Bunker Hill Golf Course through increases in the following fees: $10 increase on all annual passes. The sum of these fee increases would equate to $1,290 in additional revenue based on the FY23 usage estimates. This request supports the City Council goal of Financially Responsible, High-Performance City Organization. Related Cost:$ — Tax Funds Recurring Recommend - Yes Related Revenue:$ 1,290 Program Fees Recurring Net Cost:$ (1,290) Property Tax Impact:$ (0.0005) (0.01)% Activity: Golf Maintenance AmeriCorps: 1 of 2 This improvement request is to provide for $100,000 in grant cash match funding. This allows AmeriCorps to allocate cash match on an annual basis to the grants in the following ways: 1. Increase staffing capacity for program implementation. Human capacity is maxed out currently. The AmeriCorps Coordinator implements the programs effectively and addresses compliance directed from both the state and federal levels. All resources of cash match and in-kind match from the city are currently maxed out for the reading and teen grants. There are 53 AmeriCorps members (15 FTE) for grade level reading serving across 15 host sites and 20 members (10 FTE) for the teen grant serving across 7 host sites. The Director recruits, interviews, onboards, trains, retains and exits 73 members plus maintains compliance with grant requirements, reaching performance measure outcomes, and writing the annual grants to continue the program. This package provides benefits and .216 FTE to make the AmeriCorps Coordinator full-time and adds part time clerical support (.7 FTE). 2. Living allowance increase & match funding to leverage increased federal grant funding. This increase would maintain ARPA-based increases to the AmeriCorps Member living allowances. Members currently receive a stipend equal to $11.50/hr that would be raised to approx $13/hr. This is needed when the match waiver expires in FY23. 3. Development and implementation of a new Youth AmeriCorps Program - With increased staffing capacity, implementation of a Youth program, focused on community and civic career exploration and skill development and expansion of the current teen grant could happen. The focus would be at-risk and underrepresented minority teens successfully completing AmeriCorps requirements and learn employment skills. $10,000 would be for living stipends for approximately 10-15 Youth AmeriCorps members (ages 17-19). The youth will be eligible for an AmeriCorps Education Award. There would be active training and development for the adult AmeriCorps members to effectively work with and mentor teens and young adults (ages 12-19). The expansions above would positively affect the MFC, Four Mounds HEART and other partnering organizations and placements. This request supports the City Council goals of Diverse Arts, Culture, Parks, and Recreation Experiences and Activities, Partnership for a Better Dubuque, and Vibrant Community. It also supports the equity efforts of Leisure Services and City. This request is connected to the City Council goals & priorities of racial equity. -37- Related Cost:$ 100,000 Tax Funds Recurring Recommend - No Net Cost:$ 100,000 Property Tax Impact:$ 0.0393 0.40% Activity: AmeriCorps 2 of 2 This improvement request is to provide funding coverage of the benefits packages for the AmeriCorps Director and AmeriCorps Coordinator using City funding. Currently, the AmeriCorps grants cover the benefits packages for the FT Director and PT Coordinator. The program is at human capacity and there is a need for full time hours to implement the programs more effectively and to address of compliance directed from both the state and federal levels. All match from the city is maxed out in the reading and teen grants. There are 53 members (nearly 15 FTE) for grade level reading serving across 15 host sites and 20 members (nearly 10 FTE) for the teen grant servings across 7 host sites. The AmeriCorps Director is responsible for the recruitment, interviewing, onboarding, training, retention and exiting of all 73 AmeriCorps members, while ensuring that the program is maintaining compliance with grant requirements, reaching performance measure outcomes, and writing the annual grants to continue the program. If the city takes on the benefits of both staff, this allows a grant match allowing the coordinator to become full-time position, while also creating much-needed match funding to leverage increased federal funding. Any increases in federal funds can allow the program to maintain ARPA-based increases to the AmeriCorps Member living allowances. Currently, AmeriCorps Members receive a stipend equal to an hourly wage of $11.50. The program will need to match the additional ARPA funding allocations beginning in FY23 to maintain the increased stipend ($13/hr) when the FY22 match waiver expires. This request supports the City Council goals of Diverse Arts, Culture, Parks, and Recreation Experiences and Activities, Partnership for a Better Dubuque, and Vibrant Community. It also supports the equity efforts of the Department and City. Related Cost:$ 46,203 Tax Funds Recurring Recommend - Yes Property Tax Impact:$ 0.0182 0.19% Activity: AmeriCorps Significant Line Items Employee Expense 1.FY 2023 employee expense reflects a 3.25% wage package increase. 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2022 The employee contribution of 6.29% is unchanged from FY 2022. 3.The City portion of health insurance expense increased from $1,086 in FY 2022 to $1,119 in FY 2023 per month per contract which results in an annual cost increase of $3,883 or 3.00%. 4.Five-Year Retiree Sick leave payout increased from $0 in FY 2022 to $4,575 in FY 2023. 5.Workers Compensation increased from $28,287 in FY 2022 to $29,816 in FY 2023. FY 2021 actual was $32,822. 6.During Fiscal Year 2022, the following personnel changes were approved: a.0.60 FTE Full-Time Lead Secretary position (GE-26) was changed to Lead Administrative Assistant (GE-28) which resulted in a cost increase of $4,039. -38- b.1.04 FTE Seasonal Laborer Golf Course Groundskeeper (NA-12) pay rate was increased from $11.24 to $13.40 which resulted in a cost increase of $5,049. Depending on seasonal hires, this can range from 2-4 seasonal positions. c.1.16 FTE Seasonal Laborer Golf Course Operator (NA-08) pay rate was increased from $11.24 to $14.40 which resulted in a cost increase of $7,913. d.8.63 FTE Seasonal Lifeguard (NA-17) pay rate was increased from $10.13 to $12.50 which resulted in a cost increase of $46,440. Depending on seasonal hires, this can range from 15-20 seasonal positions. e.1.35 FTE Seasonal Swimming Pool Manager (NA-43) pay rate was increased from $14.61 to $18.00 which resulted in a cost increase of $10,512. Depending on seasonal hires, this can range from 2-4 seasonal positions. Supplies & Services 7.Sales Tax collected on goods and services decreased from $45,140 in FY 2022 to $44,177 in FY 2023. This line item is based on and off-set by the revenue for sales tax collected. 8.Electrical Utility Expense decreased from $86,246 in FY 2022 to $84,221 in FY 2023 based on FY 2019 actual. 9.Natural Gas Utility Expense increased from $26,386 in FY 2022 to $30,339 in FY 2023 based on FY 2019 actual plus 8.6%. 10.Property Maintenance increased from $38,310 in FY 2022 to $55,330 in FY 2023. This line item traditionally represents payments towards swimming pool maintenance, golf course grounds maintenance, Marina Maintenance and Allison Henderson/Comiskey Park maintenance. The FY 2023 increase is mostly due to a 50% payment of $15,000 per the Viking Dock Winterization contract. 11.Off Road Vehicle Fuel increased from $82,000 in FY 2022 to $97,255 to FY 2023 and Diesel Fuel increased from $15,000 in FY 2022 to $15,750 in FY 2023. This expenditure represents fuel sold to boaters at the Port of Dubuque Marina and is offset by $152,000 in revenue from the sale of fuel. FY2022 was an unusually high year due to low water levels which limited boat access to other marinas and it is projected that FY 2023 to be at more normal levels. 12.Turf Chemicals is unchanged from $31,000 in FY 2022 to $31,000 in FY 2023 which is utilized for golf course maintenance: fertilizer, pesticides, and anti-fungal products. FY 2021 actual was $29,574. 13.Food Products increased from $48,051 in FY 2022 to $50,870 in FY 2023 based on current year's sales. FY 2021 actual was unusually low at $18,874 due to the closure of pool and adult athletic concessions, as well as the marina store closure due to the pandemic. This budget is offset by the revenue from sales of this product. 14.Beer Products increased from $46,012 in FY 2022 to $52,100 in FY 2023 based on current year's sales. FY 2021 actual of $41,462 was unusually low due to the closure of adult athletic concessions, as well as the marina store closure due to the pandemic. This budget is offset by the revenue from sales of this product. 15.Beverage and Ice decreased from $20,316 in FY 2022 to $19,816 in FY 2023 based on FY 2022 year-to-date. FY 2021 actual of $11,417 was unusually low due to the closure of pools and adult athletic concessions, as well as the marina store closure due to the pandemic. This budget is offset by the revenue from sales of this product. -39- 16.Credit Card Charges increased from $25,172 in FY 2022 to $31,369 in FY 2023. FY 2021 actual was $25,006. Included in the budget is Golf Operations for $15,984 which is based on a three- year average. Also included is $2,800 for the Port of Dubuque dock, which was zero last year, and is based on 2% of fuel sales. 17.Program Equipment and Supplies increased from $65,344 in FY 2022 to $83,675 in FY 2023, due to a decrease in youth sports. This budget line item is for concession supplies, bases, basketballs, volleyballs, nets, first-aid supplies, trophies, community engagement Rec & Roll events, and other playground equipment. 18.Pro Shop Merchandise increased from $37,328 in FY 2022 to $38,641 in FY 2023 based on current demand for special order through the golf course. FY 2021 actual was $36,141. This budget is offset by the revenue from Pro Shop Sales, golf fee revenue, event revenue, and certificates. 19.Game Officiating Services decreased from $36,670 in FY 2022 to $26,870 in FY 2023. FY 2021 actual of $3,040 was unusually low due to the pandemic. There has been a decline in softball and basketball participation since the pandemic. 20.Machinery and Equipment Rental is unchanged from $42,351 in FY 2022 to $42,351 in FY 2023 based on FY 2021 actual. This line item is for the lease payments on sixty golf carts, tournament golf carts, beverage carts and cart maintenance, and portable restroom rentals. 21.Pay to Other Agency is increased from $161,810 in FY 2022 to $361,810 in FY 2023. This line item represents payments to local partners to provide equitable programs and unique experiences for low-income youth and underrepresented populations. These include but are not limited to: the Four Mounds Day Camp ($50,000), ice rental ($10,000), AmeriCorps 3rd Grade Reading ($20,000), AmeriCorps Playground Programs ($21,986), Hills and Dales Senior Center ($18,200), Recreation Classes (Arts programming, Creative Adventure Labs Partnership, Montessori Cooperative classes, Dubuque County Extension Contracted Classes) ($20,000). 22.Instructors decreased from $92,162 in FY 2022 to $89,099 in FY 2023. FY 2021 actual was $20,845 due to a reduction in programming which resulted from the pandemic. This line item represents after school sports coaches, sports camps, LEAP program, dance instructors, and other recreational class/program instructors. 23.Machinery and Equipment Maintenance decreased from $21,112 in FY 2022 to $20,987 FY 2023 and is based on FY 2022 budget, with some small adjustments in the Administrative and Golf Operations areas. This line item represents marina machinery and equipment maintenance, fire suppression replacements, golf course equipment maintenance and repairs, swimming pool equipment maintenance, concession stand equipment replacements, and scoreboard maintenance. 24.Promotion is unchanged from $18,266 in FY 2022 to $18,266 in FY 2023. This line item represents print and digital marketing for recreational programs, events, and classes, brochures and mailings, and radio and print advertisements. 25.General Liability Insurance increased from $23,402 in FY 2022 to $29,004 in FY 2023 based on FY 2022 actual plus 12%. 26.Property Insurance increased from $8,184 in FY 2022 to $12,534 in FY 2023 based on FY 2022 actual plus 9.5%. Previous year was under budgeted due to Bunker Hill and the two pools being inadvertently omitted from the budget allocation. -40- 27.Golf Specialty Supplies decreased from $14,563 in FY 2022 to $12,471 in FY 2023 due to a decrease in special equipment orders and related to revenues. The amount is based on FY 2021 actual of $12,370. 28.Motor Vehicle Gas increased from $12,978 in FY 2022 to $13,628 in FY 2023. FY 2021 actual was $18,136. Increase is due to the increased potential for single rider requirements on golf carts but less than FY 2021 with more two-rider carts being allowed. 29.Diesel Fuel increased from $15,000 in FY 2022 to $15,750 in FY 2023. FY 2021 actual was $13,833. Much like off road vehicle fuel, FY2022 was an unusually good year and expect FY 2023 to be at more normal levels. 30.Telephone increased from $9,667 in FY 2022 to $13,476 in FY 2023. FY 2021 actual was $13,476. Increase is in the Recreation Admin area which increased from $2,916 to $6,837 due to the addition of six smartphones for staff. Machinery & Equipment 31.Equipment replacement items include ($104,430): Recreation Administration Smart Phone $ 1,680 Defibrillator $ 1,500 File Cabinets $ 2,800 Golf Operations Flat Screen TV $ 3,200 Golf Maintenance Greens Mower $ 53,000 Sand Trap Rake $ 19,000 Swimming Defibrillator $ 3,000 McAleece Concessions Concession Equipment $ 1,000 Recreation Classes Movie Projector $ 1,300 Movie Screen $ 4,500 Port of Dubuque Marina Cameras $ 7,500 AmeriCorps Smartphone $ 350 Recommended Improvement Packages $ 5,600 Total Equipment $ 104,430 -41- Debt Service 32.FY 2023 Annual debt service is as follows ($14,789): Amount Debt Series Payment Source Purpose Final Payment Year Call Date $ 1,190 2021A (2012E) G.O.Sales Tax 20%Recreation Improvements 2022 2022 $ 13,599 2021A (2014B) G.O.Sales Tax 20%Recreation Improvements 2034 2028 $ 14,789 Total Recreation Annual Debt Service Revenue 33.Total revenue for Golf Operations and Maintenance decreased from $936,808 in FY 2022 to $929,407 in FY 2023. a.Golf Cart Rentals increased from $227,850 in FY 2022 to $232,950 in FY 2023 based on FY 2023 cart rental estimates of: 6,900 18-Hole Half Carts at $16 each; 7,200 9-Hole Half Carts at $10 each; 130 punch cards at $230 each; 31 season passes at $650 each, and 100 pull carts at $5 each. FY 2021 Actual was $233,088. b.Golf Beer Sales decreased from $130,501 in FY 2022 to $118,440 in FY 2023 due to a decrease in large events. FY 2021 actual was $109,963. c.Pro Shop Sales decreased from $68,795 in FY 2022 to $68,452 in FY 2023 due to a decrease in large events. FY 2021 Actual was $68,452. d.Golf Fees increased from $355,500 in FY 2022 to $367,690 in FY 2023 based on the number of rounds played and passes sold during FY 2020. FY 2021 Actual was $373,709, but budget is slightly lower due to seeing less events/large group activities. e.Golf event revenue unchanged from $40,698 in FY 2022 to $40,698 in FY 2023 based on FY 2019 actual. 34.Swimming revenue decreased from $330,486 in FY 2022 to $290,310 in FY 2023. a.Swimming Annual Passes decreased from $78,143 in FY 2022 to $66,448 in FY 2023. FY 2021 actual was $740. FY23 is based on June 2019 through August 2019 numbers. b.Flora Daily Fees is decreased from $82,050 in FY 2022 to $65,690 in FY 2023. FY 2021 actual was $36,796. FY23 is based on June 2019 through August 2019 numbers. c.Sutton Daily Fees is decreased from $28,214 in FY 2022 to $22,610 in FY 2023. FY 2021 actual was $2,674. FY23 is based on June 2019 through August 2019 numbers. d.Pool Concessions is unchanged from $51,000 in FY 2022 to $51,000 in FY 2023 based on estimated gross sales of $36,000 at Flora Pool and $15,000 at Sutton Pool. FY 2021 actual was $13,825. FY23 is based on June 2019 through August 2019 numbers. e.Swim Lesson Registrations decreased from $73,789 in FY 2022 to $66,412 in FY 2023 based on registration estimates. FY 2021 actual was $37,357 because of pool closure with the pandemic. FY23 is based on June 2019 through August 2019 numbers. 35.Adult Athletics revenue decreased from $96,142 in FY 2022 to $64,044 in FY 2023 and is based on FY 2022 participant numbers. a.Softball Entry Fees is decreased from $49,208 in FY 2022 to $29,250 in FY 2023. FY 2021 actual was $25,025. FY23 is based on registration trends from both FY 2020 and FY2021 seasons. b.Basketball Entry Fees is decreased from $26,400 in FY 2022 to $13,200 in FY 2023. FY23 is based on registration trends from both FY 2020 and FY2021 seasons. -42- c.Adult Winter Volleyball Leagues is increased from $12,800 in FY 2022 to $13,860 in FY 2023. FY23 is based on registration trends from both FY 2020 and FY2021 seasons. 36.Youth Sports revenue decreased from $50,030 in FY 2022 to $47,564 in FY 2023 and is based on FY 2022 participant numbers. a.After School Sports increased from $22,060 in FY 2022 to $29,760 in FY 2023, increase is due to the increase in sport offerings. FY 2021 actual was $11,017. 37.Port of Dubuque Marina revenue increased from $181,026 in FY 2022 to $208,926 in FY 2023. a.Marina Fuel Sales is increased from $125,000 in FY 2022 to $152,000 in FY 2023. This line item is based on the expense budget. FY 2022 actual is $173,424. FY2022 was an unusually high year due to low water levels which limited boat access to other marinas and it is projected that FY 2023 will be at more normal levels. b.Marina Dock Fees is decreased from $31,250 in FY 2022 $28,500 in FY 2023. This line item is based on the current year's sales as well as the current interest in seasonal slip rentals. FY 2021 actual was $25,398 and FY 2020 was $19,837. c.Marina Beverage and Ice Sales is unchanged from $5,775 in FY 2022 to $5,775 in FY 2023. This line item is based on the current year's sales and on average a 65% mark-up on the cost of the product. FY 2021 actual was $706 and FY 2020 was $4,302. 38.The following chart shows the history of property tax support for the Port of Dubuque Marina: *POD Marina opened June 2013 Port of Dubuque Marina Property Tax Support $183,285 $152,082 $106,537 $73,629 $73,629 $48,235 $65,080 $42,502 $101,892 $120,726 FY 14 FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 Ado pt e d FY 23 Req u e st e d $0 $50,000 $100,000 $150,000 $200,000 The decreases in tax support funding in FY17 through FY19 include operational changes in staffing due to a frozen full time Facilities Supervisor position which is budgeted in the Marina and Recreation Administration budgets. The Facilities Supervisor was replaced with temporary seasonal managerial staff. FY20 is a combination of these staff changes and two month of operation where the docks were opened due to COVID-19. Weather conditions and Mississippi River levels as well as flood gate closures affect the property tax support each year. Both the FY22 Adopted and FY23 Recommended budgets are based off of full operations which includes the frozen full time position. The increase from FY22 to FY23 is largely due to replacement of camera related equipment needed and a 50% payment of Viking Dock Winterization per the contract. -43- Miscellaneous 39.The FY 2023 percent self-supporting for the various Recreation Activities compared to FY 2022 percent self-supporting is as follows: Activity FY 2023 FY 2022 Adult Athletics 50.8 % 71.4 % McAleece Concessions 133.2 % 144.0 % Youth Programs 19.0 % 19.1 % Therapeutic Recreation 30.4 % 31.4 % Recreation Classes 44.2 % 41.7 % Swimming 47.5 % 53.5 % Golf 100.3 % 106.1 % Port of Dubuque Marina 63.3 % 64.0 % -44- LEISURE SERVICES RECREATION DIVISION The Recreation Division encourages community participation by providing equitable, progressive, accessible, and affordable opportunities through our parks, facilities, and recreation programming. Vision: Creating equitable OPPORTUNITIES to enhance and improve the QUALITY OF LIFE for the residents of Dubuque. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -45- LEISURE SERVICES RECREATION DIVISION FY 2021 FY 2022 FY 2023 Full-Time Equivalent 42.95 42.75 42.75 Resources and Property Tax Support FY 2021 FY 2022 FY 2023 Operating Revenue CDBG Funds Property Tax Support 0 500000 1000000 1500000 2000000 The Recreation Division is supported by 42.75 full-time equivalent employees, which accounts for 56.41% of the department expense as seen below. Overall, the department's expenses are expected to increase by 12.09% in FY 2023 compared to FY 2022. Expenditures by Category by Fiscal Year $1,402,745 $710,330 $54,584 $74,136 $1,915,442 $1,191,334 $104,020 $16,931 $2,040,783 $1,458,380 $104,080 $14,789 FY 2021 FY 2022 FY 2023 Employee Expense Supplies and Services Machinery and Equipment Debt Service $0 $500,000 $1,000,000 $1,500,000 -46- RECREATION DIVISION Recreation Programming Mission & Services The Recreation Division develops a variety of recreational activities and job opportunities to provide the citizens of Dubuque equitable, safe, wholesome, healthy and enjoyable use of leisure time. Recreation programs include early childhood enrichment programs for children ages 18 months to 6 years old, youth and adult programs such as swim, karate, dance, athletics and music, as well as Therapeutic and Neighborhood recreation programs. Recreation Programming Funding Summary 0 FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $1,117,754 $2,027,058 $2,128,776 Resources $240,611 $633,737 $565,025 Recreation Programming Position Summary FY 2023 Lead Administrative Assistant 0.60 Facilities Supervisor 0.33 Customer Service Assistant - FT 1.00 Recreation Program Supervisor 2.00 Aquatic/Therapy Supervisor 1.00 Leisure Services Manager 0.33 Recreation Division Manager 1.00 Clerical Assistant 0.22 Recreation Leader 6.32 Recreation Field Supv 1.26 Recreation Field Supv. - CDBG 0.61 Recreation Leader Jr.0.92 Playground Coordinator 0.20 Assist. Playground Coordinator 0.10 Pre-School Instructor 0.12 Pre-School Instructor - CDBG 0.72 Swimming Pool Manager 1.35 Head Lifeguard 0.44 Lifeguard 8.63 Pool Cashier 1.01 Communications Assistant 0.50 Concession Worker - Pools 1.04 Concession Worker- McAleece 0.19 Concession Manager 0.40 Snack Bar Manager 0.20 Laborer - Youth Sports 0.09 Laborer - Swimming 0.48 Laborer - Adult Athletics 0.75 Total FT Equivalent Employees 31.81 -47- RECREATION DIVISION Recreation Programming Performance Measures City Council Goal: Diverse Arts, Culture, Parks, and Recreation Performance Measure (KPI)Target FY20 Actual FY21 Actual FY 2022 Estimated Performance Indicator 1 Activity Objective: Improve quality of life for residents by expanding and enhancing organized recreation activities. # of program opportunities offered through registration system N/A 258 448 600 N/A # average total of participation per program offered annually +.25 14.23 5.72 9 % of annual programs offered running (i.e. not canceled)+1%62%53%75% # of Rec & Roll trailer deployments N/A 34 77 55 N/A City Council Goal: Partnerships for a Better Dubuque 2 Activity Objective: Develop, increase, and retain partnerships in order to provide quality and affordable program opportunities for residents. # of partnerships resulting in a program 40+20 30 40 City Council Goal: Robust Local Economy 3 Activity Objective: Develop and provide quality entry-level job opportunities for youth and adults in the community. $ in salary costs for seasonal employees only (not including IPERS or SS) N/A $476,735 $340,469 $739,791 N/A 4 Activity Objective: Provide accessible, affordable, educational, and positive programming for those who many not have the financial resources to participate. # of free programs provided to those who qualified as low-income (does not incl. drop-in ex. playground, open gym, etc.) 60 9 56 60 % of total Recreation program low- income registrants who were served by free programs 70%99%50%70% # available scholarships for recreational programming 200 150 200 200 % of awarded scholarship credits that were redeemed for recreational programs 100%14%36%100 % of total swim passes issued that were purchased by low-income residents 50%0%0%50% -48- LEISURE SERVICES RECREATION DIVISION Bunker Hill Golf Course Mission & Services Bunker Hill Golf Course located in the rolling hills of Central Dubuque is a fun and challenging 18 - hole golf course. Visitors will be greeted daily by a warm and friendly staff ensuring high customer service levels along with many programs and offerings available for enjoyment. Bunker Hill Golf Course functions as an Enterprise Fund utilizing user fees to support operational costs and capital improvements. Income includes regular green fees, cart rentals, season passes, league fees, and concession sales. Bunker Hill Golf Course Funding Summary =FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $792,308 882,620 926,353 Resources $863,452 936,808 929,407 Bunker Hill Golf Course Position Summary FY 2023 Golf Course Supervisor 1.00 Golf Professional 0.94 Assistant Golf Professional 1.36 Pro Shop Attendant 0.80 Golf Course Technician - FT 1.00 Golf Course Technician - PT 0.72 Laborer 2.20 Concession Worker - Golf 0.84 Total FT Equivalent Employees 8.86 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure (KPI)Target FY20 Actual FY21 Actual FY 2022 Estimated Performance Indicator 1 Activity Objective: Expand upon golf lesson programs offered to grow the game of golf and promote hospitality through quality customer service practices. # of Youth participating in free golf lessons +5%10 0 12 Youth Camp Participation +5%37 34 40 Participation by Women +5%27 29 32 Couples League +5%22 28 32 -49- LEISURE SERVICES RECREATION DIVISION Port of Dubuque Marina Mission & Services The Port of Dubuque Marina is a 78-slip transient marina drawing visitors to Dubuque from as far North as Minneapolis, Minnesota, as far South as Fort Lauderdale, Florida and many places in-between. The marina operates as a hotel on water, providing visiting boats with dock space, electricity, clean showers, laundry, guest Wi-Fi and concierge service from staff. From the marina, visitors are within walking distance of dining, lodging, a casino, shopping, entertainment, the National Mississippi River Museum & Aquarium and Dubuque’s Mississippi Riverwalk. The marina amenities building operates as the guest check-in desk for visiting boaters, as well as a convenience store along the river. Port of Dubuque Marina Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $218,534 $282,918 $329,914 Resources $176,033 $181,026 $208,926 Port of Dubuque Marina Position Summary FY 2023 Facilities Supervisor - Dock 0.33 Facilities Supervisor - C-Store 0.34 Marina Cashier/Clerk 0.83 Dock Worker 0.58 Total FT Equivalent Employees 2.08 Performance Measures City Council Goal: Diverse Arts, Culture, Parks, and Recreation Performance Measure (KPI)Target FY20 Actual FY21 Actual FY 2022 Estimated Performance Indicator 1 Activity Objective: Become a more visible and high-traffic docking location. increase # of docking customers 600 277 363 400 City Council Goal: Financially Responsible, High-Performance Organization 2 Activity Objective: Increase overall sales at the convenience store and additional revenue opportunities through programs and partnerships. decrease % of property-tax support <20%30%19%40% -50- LEISURE SERVICES RECREATION DIVISION AmeriCorps Mission & Services AmeriCorps is a national service program which awards communities federal funding to implement an AmeriCorps program in their community designed to meet a community's critical need. The City of Dubuque AmeriCorps Program focuses on the community's education needs and is sponsored by the City of Dubuque. The program's Partners in Learning grant is focused around Dubuque's Campaign for Grade-Level Reading. The program's Creating Opportunities grant is focused efforts in the areas of teen programming, mentorship and workforce and life skill development. The Volunteer DBQ Program is a Volunteer Generation Fund grant focused on strengthening Dubuque's Volunteer Infrastructure. AmeriCorps Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $362,477 $440,950 $606,874 Resources $355,002.43 $362,355 $372,135 AmeriCorps Position Summary FY 2023 AmeriCorps Coordinator 1.00 Community Outreach Coordinator 1.00 Comm Diversion/Prevention Coordinator 1.00 Secretary 1.00 AmeriCorps Program Director 1.00 Total FT Equivalent Employees 5.00 Performance Measures City Council Goal: Diverse Arts, Culture, Parks, and Recreation Program Year (Sept - Aug)Performance IndicatorPerformance Measure (KPI)Target 2020 - 2021 Actual 2021 - 2022 Actual 2022 - 2023 Estimated 1 Activity Objective: Ensure all students read at grade-level by third grade through reading tutoring for K - 3rd grade students. # of students supported through AmeriCorps Partners in Learning Program 500 15*250 300 % of students participating in the AmeriCorps Campaign for Grade- Level Reading who improved literacy risk levels. 90%6%*70%80% *2020-2021 Program implementation and data collection was severely impacted by COVID-19. Only 15 of the 249 students served, only 15 student reached program dosage requirements. Only 1 student improved by a risk level. -51- City Council Goal: Diverse Arts, Culture, Parks, and Recreation Program Year (Sept - Aug)Performance IndicatorPerformance Measure (KPI)Target 2020 - 2021 Actual 2021 - 2022 Actual 2022 - 2023 Estimated 2 Activity Objective: Provide Dubuque Teens with safe, caring, adult role models so youth want to attend school, after-school programs, and summer programs. % of participating teens who successfully graduated from the MFC's Summer Teen Empowerment Program 90%85%87.5%90% City Council Goal: Partnerships for a Better Dubuque 3 Activity Objective: Keep youth engaged in stimulating, educational activities and surrounded by positive role models during the summer months. # of youth served by AmeriCorps summer learning opportunities and events 500 818 2427 3,000 -52- 100 43243 CAMPING FEES 18,522 19,837 31,250 31,250 100 43249 RENT,SLATTERY CENTER 13,739 13,968 13,987 14,113 100 43250 GOLF CART RENTALS 207,340 195,465 227,850 227,850 43 USE OF MONEY AND PROPERTY - Total 239,601 229,270 273,087 273,213 100 51190 CUSTOMER CREDITS 58 (468) 0 0 100 51516 DIESEL FUEL SALES 11,572 16,265 25,000 25,000 100 51536 FUEL SALES MARINA 62,565 94,725 100,000 100,000 100 51927 LOTTERY SALES 3 0 0 0 100 51930 SWIMMING-FLORA POOL 76,962 63,976 82,050 82,050 100 51931 SWIMMING-HEMP POOL 336 0 0 0 100 51932 SWIMMING-SUTTON POOL 27,949 26,450 28,214 28,214 100 51933 SWIMMING ANNUAL PASSES 66,483 14,347 74,118 78,143 100 51934 SWIM LESSON REGISTRATION 65,906 11,954 72,589 73,789 100 51935 SWIMMING POOL RENTAL 15,638 6,744 20,580 17,290 100 51936 SWIM POOL CONCESSIONS 41,605 29,198 50,000 51,000 100 51937 GOLF FEES 330,952 316,079 356,172 357,987 100 51938 GIFT CERTIFICATES-GOLF (41,601) (27,874) 0 0 100 51939 TENNIS FEES 6,047 646 6,635 6,575 100 51940 TENNIS COURT RESERVATIONS 34 94 34 34 100 51942 SOFTBALL ENTRY FEES 48,765 22,809 49,208 49,208 100 51943 FIELD RENTAL FEES 6,690 2,829 7,500 7,500 100 51944 BASKETBALL ENTRY FEES 25,700 21,852 26,400 26,400 100 51945 VOLLEYBALL ENTRY FEES 10,200 12,512 12,800 12,800 100 51946 AFTER SCHOOL SPORTS 24,433 10,620 17,500 22,060 100 51949 ART FEES 54,278 23,281 63,462 61,652 100 51950 VARIOUS PROGRAM FEES 6,682 3,462 11,942 13,142 260 51950 VARIOUS PROGRAM FEES 5,869 120 4,770 4,770 100 51951 CHILDRENS ATHLETIC FEES 5,519 475 4,200 4,195 100 51953 MEETING ROOM FEES 2,034 3,039 2,055 2,505 100 51954 PLAYGROUND REG FEES 2,280 (63) 2,000 1,900 100 51955 OTHER RENTS/CONCESSIONS 346 224 346 346 100 51959 BEER 166,971 126,867 168,701 171,993 100 51960 FOOD 45,014 27,684 47,301 48,111 100 51962 LIQUOR 28,346 26,677 28,346 28,346 100 51963 CATERING 3,100 1,279 3,100 3,100 100 51965 EVENTS REVENUE 40,689 40,698 40,689 40,698 100 51966 PRO SHOP SALES 72,880 53,207 73,295 73,295 100 51967 BEVERAGES/ICE 35,613 27,527 36,492 38,942 100 51968 CIGARETTE SALES 1,271 725 1,040 1,040 100 51989 GIFT CARD-GOLF 12,306 8,294 12,306 12,306 51 CHARGES FOR SERVICES - Total 1,263,494 966,253 1,428,845 1,444,391 100 53102 PRIVATE PARTICIPANT 6,600 5,000 7,300 5,700 100 53201 REFUNDS 0 300 0 0 100 53204 IOWA FUEL TAX REFUND 558 867 558 867 Recommended Operating Revenue Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Revenue FY21 Actual Revenue FY22 Adopted Budget FY23 Recomm'd Budget -53- 100 53530 SPECIALIZED SERVICES 96 21 300 300 100 53605 MISCELLANEOUS REVENUE 922 1,464 21,375 15,600 100 53615 DAMAGE CLAIMS (49) 0 0 0 100 53620 REIMBURSEMENTS-GENERAL 2,267 366,355 0 7,500 53 MISCELLANEOUS - Total 10,393 374,006 29,533 29,967 100 54106 EQUIPMENT SALES 0 0 4,000 4,000 100 54109 SALVAGE SALES 0 480 0 0 54 OTHER FINANCING SOURCES - Total 0 480 4,000 4,000 400 59350 FR SALES TAX CONSTRUCTION 17,270 15,355 16,484 16,931 59 TRANSFER IN AND INTERNAL - Total 17,270 15,355 16,484 16,931 RECREATION DIVISION - Total 1,530,758 1,585,364 1,751,949 1,768,502 Recommended Operating Revenue Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Revenue FY21 Actual Revenue FY22 Adopted Budget FY23 Recomm'd Budget -54- Recommended Operating Revenue Budget - Department Total 31 - AMERICORPS Fund Account Account Title FY20 Actual Revenue FY21 Actual Revenue FY22 Adopted Budget FY23 Recomm'd Budget 100 45771 FED PASS THRU STATE GRANT 215,743 288,502 203,761 222,344 45 STATE GRANTS - Total 215,743 288,502 203,761 222,344 100 53102 PRIVATE PARTICIPANT 19,880 66,500 158,594 149,791 100 53201 REFUNDS 0 358 0 0 100 53620 REIMBURSEMENTS-GENERAL 0 47 0 0 53 MISCELLANEOUS - Total 19,880 66,905 158,594 149,791 AMERICORPS - Total 235,623 355,407 362,355 372,135 -55- 100 61010 FULL-TIME EMPLOYEES 562,609 565,080 648,500 668,342 100 61020 PART-TIME EMPLOYEES 130,460 131,465 130,852 135,188 260 61020 PART-TIME EMPLOYEES 30 15,267 0 0 261 61020 PART-TIME EMPLOYEES 0 9,204 0 0 100 61030 SEASONAL EMPLOYEES 444,045 319,814 694,148 776,953 260 61030 SEASONAL EMPLOYEES 32,689 15,392 45,643 47,123 261 61030 SEASONAL EMPLOYEES 0 8,995 0 0 100 61050 OVERTIME PAY 2,961 4,524 3,800 3,800 100 61091 SICK LEAVE PAYOFF 2,770 2,770 0 4,575 100 61096 50% SICK LEAVE PAYOUT 323 398 323 398 100 61310 IPERS 74,950 74,597 97,960 102,547 260 61310 IPERS 2,438 2,730 2,712 2,800 261 61310 IPERS 0 1,688 0 0 100 61320 SOCIAL SECURITY 85,305 76,007 113,034 121,577 260 61320 SOCIAL SECURITY 2,503 2,345 3,492 3,605 261 61320 SOCIAL SECURITY 0 1,392 0 0 100 61410 HEALTH INSURANCE 129,274 126,159 129,409 133,292 100 61415 WORKMENS' COMPENSATION 31,141 31,563 26,748 28,202 260 61415 WORKMENS' COMPENSATION 1,412 0 1,539 1,614 261 61415 WORKMENS' COMPENSATION 0 1,260 0 0 100 61416 LIFE INSURANCE 447 445 578 453 100 61417 UNEMPLOYMENT INSURANCE 11,688 9,596 15,540 7,316 100 61620 UNIFORM ALLOWANCE 0 304 0 0 100 61640 SAFETY EQUIPMENT 3,850 331 900 900 260 61640 SAFETY EQUIPMENT 143 0 0 0 100 61660 EMPLOYEE PHYSICALS 134 1,420 264 2,098 61 - WAGES AND BENEFITS 1,519,171 1,402,745 1,915,442 2,040,783 100 62010 OFFICE SUPPLIES 2,419 2,031 5,745 2,446 260 62010 OFFICE SUPPLIES 186 95 186 186 100 62011 UNIFORM PURCHASES 1,109 1,153 6,310 6,296 100 62030 POSTAGE AND SHIPPING 6,424 1,761 5,773 5,847 260 62030 POSTAGE AND SHIPPING 1,000 0 1,020 1,020 100 62061 DP EQUIP. MAINT CONTRACTS 6,448 9,232 9,232 10,981 100 62062 JANITORIAL SUPPLIES 4,877 7,331 10,500 10,733 260 62062 JANITORIAL SUPPLIES 333 0 340 340 100 62063 SAFETY RELATED SUPPLIES 0 227 0 102 100 62090 PRINTING & BINDING 5,211 419 11,094 9,248 260 62090 PRINTING & BINDING 0 0 195 195 100 62110 COPYING/REPRODUCTION 1,489 1,045 2,044 1,973 100 62130 LEGAL NOTICES & ADS 0 17 0 0 100 62140 PROMOTION 11,027 5,760 18,266 18,266 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 317 18 379 379 100 62190 DUES & MEMBERSHIPS 1,612 2,398 2,423 2,784 100 62204 REFUNDS 41,426 120 0 0 100 62205 DRAM SHOP INSURANCE 7,861 6,432 9,268 8,668 Recommended Operating Expenditure Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget -56- 100 62206 PROPERTY INSURANCE 11,206 7,556 8,184 12,534 100 62208 GENERAL LIABILITY INSURAN 22,130 21,841 22,991 28,386 260 62208 GENERAL LIABILITY INSURAN 396 0 411 618 261 62208 GENERAL LIABILITY INSURAN 0 389 0 0 100 62210 SALES TAX 38,476 29,046 45,140 44,177 100 62211 PROPERTY TAX 1,932 1,980 1,971 2,020 100 62310 TRAVEL-CONFERENCES 5,639 90 7,140 7,140 100 62320 TRAVEL-CITY BUSINESS 950 0 1,113 1,113 100 62340 MILEAGE/LOCAL TRANSP 4,869 3,283 6,563 6,563 100 62360 EDUCATION & TRAINING 7,445 855 7,431 14,201 100 62411 UTILITY EXP-ELECTRICITY 91,034 49,712 86,246 84,221 100 62412 UTILITY EXP-GAS 16,720 7,948 26,386 30,339 100 62418 UTILITY EXP-REFUSE 1,443 1,335 1,466 1,398 100 62421 TELEPHONE 9,668 13,476 9,667 13,476 100 62431 PROPERTY MAINTENANCE 48,404 71,730 38,310 55,330 100 62433 CUSTODIAL SERVICES 4,888 4,460 5,073 5,165 260 62433 CUSTODIAL SERVICES 2,646 0 2,646 2,646 100 62436 RENTAL OF SPACE 220 660 220 660 100 62511 FUEL, MOTOR VEHICLE 11,105 18,136 12,978 13,628 100 62512 FUEL, OFF ROAD VEHICLE 57,456 97,255 82,000 97,255 100 62513 FUEL, DIESEL 9,600 13,833 15,000 15,750 100 62602 CIGARETTES 348 0 800 800 100 62611 MACH/EQUIP MAINTENANCE 39,776 12,182 21,112 20,987 100 62614 EQUIP MAINT CONTRACT 3,563 4,333 3,151 4,685 100 62624 GOLF SPECIALTY SUPPLIES 12,060 12,370 14,563 12,471 100 62627 CAMERA MAINTENANCE 672 0 897 897 100 62633 CHLORINE 11,023 4,571 12,216 12,216 100 62634 POOL CHEMICALS 2,651 2,186 12,163 12,163 100 62635 TURF CHEMICALS 29,781 29,574 31,000 31,000 100 62642 FOOD PRODUCTS 34,697 18,874 48,051 50,870 100 62643 BEER PRODUCTS 38,783 41,462 46,012 52,100 100 62644 LIQUOR PRODUCTS 2,994 5,329 6,000 6,000 100 62649 BEVERAGE/ICE 16,176 11,417 20,316 19,816 100 62663 SOFTWARE LICENSE EXP 5,628 6,593 13,622 11,817 100 62664 LICENSE/PERMIT FEES 4,496 4,636 5,864 5,853 100 62666 CREDIT CARD CHARGE 24,107 25,006 25,172 31,369 100 62667 DATA SERVICES 6,349 1,751 2,430 2,434 100 62668 PROGRAM EQUIP/SUPPLIES 32,135 19,845 45,574 63,905 260 62668 PROGRAM EQUIP/SUPPLIES 999 1,196 19,770 19,770 261 62668 PROGRAM EQUIP/SUPPLIES 0 812 0 0 100 62669 PROGRAMMING 0 (653) 0 0 100 62670 PRO SHOP MERCHANDISE 37,209 36,141 37,328 38,641 100 62678 EDUCATIONAL MATERIALS 1,368 2,391 2,434 2,434 100 62683 FIELD OPERATIONS SUPPLIES 332 506 1,000 1,500 100 62699 CASH SHORT AND OVER 340 655 0 0 Recommended Operating Expenditure Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget -57- 100 62710 CONTRACTOR SERVICES 0 25 0 0 100 62716 CONSULTANT SERVICES 4,533 1,047 4,500 4,500 100 62717 CRIMINAL BACKGROUND CHECK 2,266 1,083 5,800 1,083 400 62721 FINANCIAL CONSULTANT 0 107 0 0 100 62731 MISCELLANEOUS SERVICES 0 0 6,250 6,250 260 62731 MISCELLANEOUS SERVICES 0 0 3,000 3,000 100 62732 TEMP HELPCONTRACT SERV. 0 0 1,935 1,935 100 62735 GAME OFFICIATING SERVICES 23,814 3,040 34,870 25,070 260 62735 GAME OFFICIATING SERVICES 1,800 0 1,800 1,800 100 62736 CATERING SERVICES 2,085 479 3,170 3,170 100 62747 MACH/EQUIPMENT RENTAL 43,721 37,674 42,351 42,351 100 62751 INSTRUCTORS 44,880 20,845 92,162 89,099 100 62761 PAY TO OTHER AGENCY 452,008 16,580 111,810 311,810 260 62761 PAY TO OTHER AGENCY 63,571 6,572 50,000 50,000 100 62767 ENVIRON. TESTING/MON. 200 80 500 500 62 - SUPPLIES AND SERVICES 1,382,329 710,330 1,191,334 1,458,380 100 63311 ADMIN. OVERHEAD 0 85,043 85,043 85,043 100 63312 LESS ADMIN. RECHARGES 0 (85,043) (85,043) (85,043) 63 - ADMIN/OVERHEAD/STORES GAR 0 0 0 0 100 71118 PROJECTOR/CAMERA 0 0 0 1,300 100 71120 PERIPHERALS, COMPUTER 0 148 0 0 100 71124 COMPUTER 0 0 0 5,600 100 71214 FILES 0 0 0 2,800 100 71310 AUTO/JEEP REPLACEMENT 0 0 35,000 0 100 71410 SHOP EQUIPMENT 221 80 0 0 100 71521 REFRIGERATOR 0 0 0 500 100 71522 TRUCKSTER 0 0 9,000 0 100 71550 MISCELLANEOUS EQUIPMENT 5,277 0 1,500 500 100 71611 MOWING EQUIPMENT 26,000 45,634 52,000 53,000 100 71613 TRIMMERS 234 0 500 0 100 71617 AERATOR 7,875 0 0 0 100 71619 OTHER MAINT. EQUIPMENT 7,995 0 0 19,000 100 72414 TELEVISION 0 0 0 3,200 100 72416 VIDEO EQUIPMENT 0 0 0 4,500 100 72417 CAMERA RELATED EQUIPMENT 0 8,722 2,800 7,500 100 72418 TELEPHONE RELATED 214 0 3,220 1,680 100 72610 DEFIBRILLATOR 0 0 0 4,500 71 - EQUIPMENT 47,815 54,584 104,020 104,080 400 74111 PRINCIPAL PAYMENT 12,865 72,005 15,162 13,882 400 74112 INTEREST PAYMENT 2,490 2,132 1,769 907 74 - DEBT SERVICE 15,355 74,136 16,931 14,789 34 - RECREATION DIVISION TOTAL 2,964,671 2,241,795 3,227,727 3,618,032 Recommended Operating Expenditure Budget - Department Total 34 - RECREATION DIVISION Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget -58- Recommended Operating Expenditure Budget - Department Total 31 - AMERICORPS Fund Account Account Title FY20 Actual Expense FY21 Actual Expense FY22 Adopted Budget FY 23 Recomm'd Budget 100 61010 FULL-TIME EMPLOYEES 63,083 68,024 115,688 226,398 100 61020 PART-TIME EMPLOYEES 8,563 18,369 0 20,781 100 61030 SEASONAL EMPLOYEES 160,439 170,056 209,425 196,385 100 61310 IPERS 6,763 8,156 12,361 23,333 100 61320 SOCIAL SECURITY 17,544 19,413 24,871 33,933 100 61410 HEALTH INSURANCE 13,988 24,547 26,064 53,712 100 61415 WORKMENS' COMPENSATION 8,137 12,235 14,041 10,893 100 61416 LIFE INSURANCE 73 73 110 183 100 61665 OTHER MEDICAL COSTS 0 630 4,800 4,800 61 - WAGES AND BENEFITS 278,591 321,504 407,360 570,418 100 62010 OFFICE SUPPLIES 4,271 697 120 120 100 62011 UNIFORM PURCHASES 6,251 1,569 1,530 1,500 100 62070 OFFICE EQUIP RENTAL 2,826 505 0 1,824 100 62110 COPYING/REPRODUCTION 151 1,903 1,824 0 100 62190 DUES & MEMBERSHIPS 0 1,258 0 0 100 62204 REFUNDS 11,531 2,892 0 0 100 62240 MISCELLANEOUS 3,137 332 0 0 100 62310 TRAVEL-CONFERENCES 3,897 0 4,339 4,194 100 62320 TRAVEL-CITY BUSINESS 710 36 0 0 100 62340 MILEAGE/LOCAL TRANSP 0 23 1,080 1,080 100 62360 EDUCATION & TRAINING 1,855 1,917 3,000 3,145 100 62421 TELEPHONE 668 666 1,344 720 100 62661 MISC. OPER. EXPENS 1,230 0 0 0 100 62663 SOFTWARE LICENSE EXP 74 2,014 784 784 100 62667 DATA SERVICES 980 8,540 6,120 6,244 100 62716 CONSULTANT SERVICES 0 218 0 0 100 62717 CRIMINAL BACKGROUND CHECK 1,426 1,092 2,916 2,862 100 62755 LEADERSHIP TRAINING 0 150 0 0 100 62761 PAY TO OTHER AGENCY 0 3,292 6,313 13,633 261 62765 GRANTS 0 12,000 0 0 62 - SUPPLIES AND SERVICES 39,009 39,102 29,370 36,106 100 71120 PERIPHERALS, COMPUTER 16,471 0 920 0 100 71124 COMPUTER 0 1,871 2,800 0 100 72418 TELEPHONE RELATED 0 0 500 350 71 - EQUIPMENT 16,471 1,871 4,220 350 31 - AMERICORPS TOTAL 334,071 362,477 440,950 606,874 -59- POD CSTORE OPERATION - 30550 FUNDING SOURCE: GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT — — 7,500 SUPPLIES AND SERVICES 49,948 75,825 78,848 WAGES AND BENEFITS 13,635 51,984 53,606 POD CSTORE OPERATION 63,583 127,809 139,954 POD DOCK MAINTENANCE - 30560 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 135,659 111,356 144,869 WAGES AND BENEFITS 19,293 43,753 45,091 POD DOCK MAINTENANCE 154,952 155,109 189,960 RECREATION ADMIN. - 34100 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR (85,043) (85,043) (85,043) EQUIPMENT 148 3,220 11,580 SUPPLIES AND SERVICES 51,516 143,988 149,136 WAGES AND BENEFITS 611,009 664,242 693,205 RECREATION ADMIN. 577,630 726,407 768,878 GOLF OPERATIONS - 34200 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — — 3,200 SUPPLIES AND SERVICES 190,256 200,333 209,969 WAGES AND BENEFITS 169,590 187,662 191,816 GOLF OPERATIONS 359,846 387,995 404,985 GOLF MAINTENANCE - 34250 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 29,155 29,155 29,155 EQUIPMENT — 2,800 3,000 SUPPLIES AND SERVICES 47,143 176,790 185,238 Recommended Expenditure Budget Report by Activity & Funding Sounce 34 - RECREATION DIVISION -60- WAGES AND BENEFITS 125,580 333,469 394,159 GOLF MAINTENANCE 201,878 542,214 611,552 SWIMMING - 34300 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 29,155 29,155 29,155 EQUIPMENT — 2,800 3,000 SUPPLIES AND SERVICES 47,143 176,790 185,238 WAGES AND BENEFITS 125,580 333,469 394,159 SWIMMING 201,878 542,214 611,552 ADULT ATHLETICS - 34400 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 25,129 25,129 25,129 EQUIPMENT — 1,500 0 SUPPLIES AND SERVICES 25,820 66,485 53,566 WAGES AND BENEFITS 8,407 41,563 47,464 ADULT ATHLETICS 59,356 134,677 126,159 MCALEECE CONCESSIONS - 34410 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — — 1,000 SUPPLIES AND SERVICES 14,678 25,227 27,069 WAGES AND BENEFITS 7,334 11,623 11,769 MCALEECE CONCESSIONS 22,012 36,850 39,838 YOUTH SPORTS/AFTER SCHOOL- 34420 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 25,501 73,971 67,991 WAGES AND BENEFITS 113,239 175,687 182,345 YOUTH SPORTS/AFTER SCHOOL 138,740 249,658 250,336 THERAPEUTIC/SENIOR PROG - 34430 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 8,722 — 0 Recommended Expenditure Budget Report by Activity & Funding Sounce 34 - RECREATION DIVISION -61- SUPPLIES AND SERVICES 27,613 14,962 15,504 WAGES AND BENEFITS 1,422 30,926 31,947 THERAPEUTIC/SENIOR PROG 37,758 45,888 47,451 RECREATION CLASSES - 34460 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — 35,000 5,800 SUPPLIES AND SERVICES 35,417 110,984 131,001 WAGES AND BENEFITS 5,916 12,626 13,044 RECREATION CLASSES 41,334 158,610 149,845 CD TARGET AREA PROG. - 34500 FUNDING SOURCE: COMMUNITY DEVELOPMENT Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 4,513 79,368 79,575 WAGES AND BENEFITS 58,273 53,386 55,142 CD TARGET AREA PROG. 62,786 132,754 134,717 DEBT SERVICE - 34700 FUNDING SOURCE: DEBT SERVICE Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget DEBT SERVICE 74,136 16,931 14,789 DEBT SERVICE 74,243 16,931 14,789 SENIOR CENTER - 79180 FUNDING SOURCE: COMMUNITY DEVELOPMENT Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 15,216 18,200 18,200 SENIOR CENTER $ 15,216.00 $ 18,200.00 18,200 RECREATION DIVISION TOTAL $2,241,795 $3,227,727 $3,418,032 Recommended Expenditure Budget Report by Activity & Funding Sounce 34 - RECREATION DIVISION -62- AMERICORP FORMULA 2021 - 34910 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 3,128 — — WAGES AND BENEFITS 86,226 — — AMERICORP FORMULA 2021 89,354 — — AMERICORP NONGRANT - 34911 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — 4,220 350 SUPPLIES AND SERVICES — 3,134 3,134 WAGES AND BENEFITS 6,648 71,953 230,950 AMERICORP NONGRANT 6,648 79,307 234,434 AMERICORP COMP 2021 - 34912 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 1,871 — — SUPPLIES AND SERVICES 18,368 — — WAGES AND BENEFITS 159,283 — — AMERICORP COMP 2021 179,523 — — AMERICORP FORM 21/22 - 34913 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGES AND BENEFITS — 20,235 — AMERICORP FORM 21/22 — 20,235 — AMERICORP AARA - 34914 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT — — — SUPPLIES AND SERVICES 14,254 — 32,972 WAGES AND BENEFITS 46,952 — 316,806 AMERICORP REGULAR 18/19 61,206 — 349,778 AMERICORP SUPP 10/11 - 34916 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 130 — — Recommended Expenditure Budget Report by Activity & Funding Sounce 31 - AMERICORPS -63- WAGES AND BENEFITS 12,615 — — AMERICORP PLANNING 18/19 12,745 — — AMERICORP 3 - 34917 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 3,223.00 — — WAGES AND BENEFITS 9,779 — 22,657 AMERICORP SUMMER 18/19 13,002 — 22,657 AMERICORP COMP 21/22 - 34918 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES — 26,236 — WAGES AND BENEFITS — 315,172.00 — AMERICORP COMP 21/22 — 341,408 — AMERICORPS TOTAL $ 362,477 $ 440,950 $ 606,874 Recommended Expenditure Budget Report by Activity & Funding Sounce 31 - AMERICORPS -64- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 61010 Full Time Employee Expense 100 3375 GE-41 LEISURE SERVICES MANAGER 0.33 $ 42,992 0.33 $ 45,948 0.33 $ 47,841 100 5075 GE-36 RECREATION DIVISION MANAGER 1.00 $ 89,269 1.00 $ 90,577 1.00 $ 93,529 100 2975 GE-33 GOLF COURSE SUPERVISOR 1.00 $ 79,015 1.00 $ 80,198 1.00 $ 78,864 100 GE-33 AQUATIC/THERAP REC SUPV 1.00 $ 77,510 1.00 $ 78,670 1.00 $ 81,230 100 GE-33 FACILITIES SUPERVISOR 1.00 $ 60,636 1.00 $ 61,533 1.00 $ 63,537 100 5000 GE-33 RECREATION PROGRAM SUPV 2.00 $ 152,010 2.00 $ 154,286 2.00 $ 159,572 100 200 GE-26 LEAD SECRETARY 0.60 $ 27,888 0.60 $ 28,896 0.60 $ 33,925 100 225 GE-25 SECRETARY 1.00 $ 51,009 1.00 $ 51,747 1.00 $ 51,365 100 GD-06 GOLF COURSE TECHNICIAN 1.00 $ 55,674 1.00 $ 56,645 1.00 $ 58,479 TOTAL FULL TIME EMPLOYEES 8.93 $ 636,003 8.93 $ 648,500 8.93 $ 668,342 61020 Part Time Employee Expense 100 225 GE-25 COMMUNICATIONS ASST 0.50 $ 18,874 0.50 $ 20,087 0.50 $ 20,744 100 GD-33 GOLF PROFESSIONAL 0.94 $ 70,736 0.94 $ 71,796 0.94 $ 74,132 100 GD-06 GOLF COURSE TECHNICIAN 0.72 $ 37,340 0.72 $ 38,969 0.72 $ 40,312 TOTAL PART TIME EMPLOYEES 2.16 $ 126,950 2.16 $ 130,852 2.16 $ 135,188 61030 Seasonal Employee Expense 100 3675 NA-31 HEAD LIFE GUARD 0.44 $ 6,661 0.44 $ 6,661 0.44 $ 6,661 100 3450 NA-25 RECREATION FIELD SUPERVISOR 1.26 $ 39,986 1.26 $ 40,587 1.26 $ 41,905 260 3450 NA-25 RECREATION FIELD SUPERVISOR CDBG 0.61 $ 16,660 0.61 $ 16,914 0.61 $ 17,462 100 NA-23 MARINA CASHIER/CLERK 0.83 $ 18,611 0.83 $ 18,882 0.83 $ 18,882 100 NA-23 DOCK WORKER 0.58 $ 12,358 0.58 $ 12,546 0.58 $ 12,546 100 3700 NA-19 SWIMMING POOL MANAGER 1.35 $ 41,803 1.35 $ 42,423 1.35 $ 50,738 100 3650 NA-17 LIFE GUARD 8.63 $ 179,864 8.63 $ 182,512 8.63 $ 225,243 100 3525 NA-15 JUNIOR RECREATION LEADER 0.92 $ 15,656 0.92 $ 15,886 0.92 $ 16,405 100 890 NA-03 LABORER I —$ — 1.32 $ 29,010 1.32 $ 36,932 100 890 NA-01 LABORER TE 2 1.16 $ 29,452 1.16 $ 29,864 1.16 $ 36,695 100 890 NA-03 LABORER TE 1 2.36 $ 51,133 1.04 $ 22,910 1.04 $ 29,098 100 3550 NA-14 RECREATION LEADER 6.11 $ 131,366 6.32 $ 137,861 6.32 $ 142,347 260 3585 NA-35 PRE-SCHOOL INSTRUCTOR CDBG 0.72 $ 28,308 0.72 $ 28,729 0.72 $ 29,661 100 NA-35 PRE-SCHOOL INSTRUCTOR 0.12 $ 3,907 0.12 $ 3,967 0.12 $ 4,096 100 3625 NA-07 POOL CASHIER 1.01 $ 19,781 1.01 $ 20,077 1.01 $ 20,730 100 NA-45 ASSISTANT PRO 1.36 $ 45,780 1.36 $ 46,464 1.36 $ 47,986 100 NA-45 SNACK BAR MANAGER 0.20 $ 6,009 0.20 $ 6,009 0.20 $ 6,009 100 NA-36 CONCESSION MANAGER 0.40 $ 10,689 0.40 $ 10,846 0.40 $ 11,200 100 NA-18 CONCESSION WORKER II 2.07 $ 36,616 2.07 $ 36,958 2.07 $ 37,738 100 NA-28 CLERICAL ASSISTANT 0.22 $ 5,191 0.22 $ 5,264 0.22 $ 5,434 100 NA-45 AFTER SCHOOL SPORTS COORD 0.41 $ 14,142 —$ — —$ — 34 RECREATION DIVISION FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -65- 100 NA-27 PLAYGROUND COORDINATOR 0.20 $ 5,707 0.20 $ 5,791 0.20 $ 5,978 100 NA-27 ASSIST PLAYGROUND COORD 0.10 $ 2,506 0.10 $ 2,542 0.10 $ 2,624 100 NA-18 PRO SHOP ATTENDANT 0.80 $ 16,905 0.80 $ 17,154 0.80 $ 17,706 TOTAL SEASONAL EMPLOYEES 31.86 $ 739,091 31.66 $ 739,857 31.66 $ 824,076 TOTAL RECREATION DIVISION 42.95 $ 1,502,044 42.75 $ 1,519,209 42.75 $ 1,627,606 31 AMERICORPS 61010 Full Time Employee Expense 100 1185 AMERICORPS PROGRAM DIRECTOR 1.00 $ 63,099 1.00 $ 70,601 1.00 $ 72,830 100 GE-33 COMM DIVERSION/PREVENT COORD —$ — —$ — 1.00 $ 67,108 100 GE-25 SECRETARY —$ — —$ — 1.00 $ 40,378 100 GE-28 COMMUNITY OUTREACH COORD —$ — 1.00 $ 44,641 1.00 $ 46,082 TOTAL FULL TIME EMPLOYEES 1.00 $ 63,099 2.00 $ 115,242 4.00 $ 226,398 61020 Part Time Employee Expense 100 NA-28 AMERICORPS COORDINATOR —$ — 0.28 $ 13,007 0.40 $ 20,781 TOTAL PART TIME EMPLOYEES —$ — 0.28 $ 13,007 0.40 $ 20,781 TOTAL AMERICORPS DIVISION 1.00 $ 63,099 2.28 $ 128,249 4.40 $ 247,179 TOTAL RECREATION, MFC AMERICORPS 43.95 $ 1,565,143 45.03 $ 1,647,458 47.15 $ 1,874,785 34 RECREATION DIVISION FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -66- Recreation Administration-FT 10034100 61010 100 200 GE-28 LEAD SECRETARY 0.60 $ 27,888 0.60 $ 28,896 0.60 $ 33,925 10034100 61010 100 GE-33 FACILITIES SUPERVISOR 0.33 $ 20,010 0.33 $ 20,306 0.33 $ 20,967 10034100 61010 100 225 GE-25 SECRETARY 1.00 $ 51,009 1.00 $ 51,747 1.00 $ 51,365 10034100 61010 100 4,280 GE-33 RECREATION PROGRAM SUPV 2.00 $ 152,010 2.00 $ 154,286 2.00 $ 159,572 10034100 61010 100 1,080 GE-33 AQUATIC/THERAP REC SUPV 1.00 $ 77,510 1.00 $ 78,670 1.00 $ 81,230 10034100 61010 100 3375 GE-44 LEISURE SERVICES MANAGER 0.33 $ 42,992 0.33 $ 45,948 0.33 $ 47,841 10034100 61010 100 5075 GE-36 RECREATION DIVISION MANAGER 1.00 $ 89,269 1.00 $ 90,577 1.00 $ 93,529 Total 6.26 $ 460,688 6.26 $ 470,430 6.26 $ 488,429 Recreation Administration-PT 10034100 61020 100 225 GE-25 COMMUNICATIONS ASST 0.50 $ 18,874 0.50 $ 20,087 0.50 $ 20,744 Total 0.50 $ 18,874 0.50 $ 20,087 0.50 $ 20,744 Recreation Administration-Seasonal 10034100 61030 100 NA-28 CLERICAL ASSISTANT 0.22 $ 5,191 0.22 $ 5,264 0.22 $ 5,434 Total 0.22 $ 5,191 0.22 $ 5,264 0.22 $ 5,434 Golf Operations-Seasonal 10034200 61030 100 NA-45 ASSISTANT PRO 1.36 $ 45,780 1.36 $ 46,464 1.36 $ 47,986 10034200 61030 100 NA-39 CONCESSION WORKER II 0.84 $ 12,716 0.84 $ 12,716 0.84 $ 12,716 10034200 61030 100 NA-18 PRO SHOP ATTENDANT 0.80 $ 16,905 0.80 $ 17,154 0.80 $ 17,706 Total 3.00 $ 75,401 3.00 $ 76,334 3.00 $ 78,408 Golf Operations-PT 10034200 61020 100 2,625 GE-33 GOLF PROFESSIONAL 0.94 $ 70,736 0.94 $ 71,796 0.94 $ 74,132 Total 0.94 $ 70,736 0.94 $ 71,796 0.94 $ 74,132 Golf Maintenance-FT 10034250 61010 100 2975 GE-33 GOLF COURSE SUPERVISOR 1.00 $ 79,015 1.00 $ 80,198 1.00 $ 78,864 10034250 61010 100 2622 GD-06 GOLF COURSE TECHNICIAN 1.00 $ 55,674 1.00 $ 56,645 1.00 $ 58,479 Total 2.00 $ 134,689 2.00 $ 136,843 2.00 $ 137,343 Golf Maintenance-PT 10034250 61020 100 GOLF COURSE TECHNICIAN 0.72 $ 37,340 0.72 $ 38,969 0.72 $ 40,312 Total 0.72 $ 37,340 0.72 $ 38,969 0.72 $ 40,312 Golf Maintenance-Seasonal 10034250 61030 100 890 NA-08 LABORER TE 2 1.16 $ 29,452 1.16 $ 29,864 1.16 $ 36,695 10034250 61030 100 890 NA-12 LABORER TE 1 1.04 $ 22,562 1.04 $ 22,910 1.04 $ 29,098 Total 2.20 $ 52,014 2.20 $ 52,774 2.20 $ 65,793 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -67- Swimming-Seasonal 10034300 61030 100 3675 NA-39 HEAD LIFE GUARD 0.44 $ 6,661 0.44 $ 6,661 0.44 $ 6,661 10034300 61030 100 NA-36 CONCESSION MANAGER 0.40 $ 10,689 0.40 $ 10,846 0.40 $ 11,200 10034300 61030 100 NA-18 CONCESSION WORKER II 1.04 $ 20,016 1.04 $ 20,299 1.04 $ 20,952 10034300 61030 100 3650 NA-17 LIFE GUARD 8.63 $ 179,864 8.63 $ 182,512 8.63 $ 225,243 10034300 61030 100 3625 NA-07 POOL CASHIER 1.01 $ 19,781 1.01 $ 20,077 1.01 $ 20,730 10034300 61030 100 890 NA-12 LABORER I 0.48 $ 10,413 0.48 $ 10,574 0.48 $ 13,430 10034300 61030 100 3700 NA-43 SWIMMING POOL MANAGER 1.35 $ 41,803 1.35 $ 42,423 1.35 $ 50,738 Total 13.35 $ 289,227 13.35 $ 293,392 13.35 $ 348,954 Adult Athletics-Seasonal 10034400 61030 100 3450 NA-25 RECREATION FIELD SUPERVISOR 0.43 $ 11,607 0.43 $ 11,785 0.43 $ 12,166 10034400 61030 100 890 NA-12 LABORER I 0.75 $ 16,271 0.75 $ 16,521 0.75 $ 20,984 10034400 61030 100 3550 NA-14 RECREATION LEADER 0.35 $ 7,527 0.35 $ 7,637 0.35 $ 7,885 Total 1.53 $ 35,405 1.53 $ 35,943 1.53 $ 41,035 McAleece Concessions-Seasonal 10034410 61030 100 NA-42 SNACK BAR MANAGER 0.20 $ 6,009 0.20 $ 6,009 0.20 $ 6,009 10034410 61030 100 NA-18 CONCESSION WORKER II 0.19 $ 3,884 0.19 $ 3,943 0.19 $ 4,070 Total 0.39 $ 9,893 0.39 $ 9,952 0.39 $ 10,079 Youth Sports-Seasonal 10034420 61030 100 3525 NA-15 JUNIOR RECREATION LEADER 0.92 $ 15,656 0.92 $ 15,886 0.92 $ 16,405 10034420 61030 100 NA-27 PLAYGROUND COORDINATOR 0.20 $ 5,707 0.20 $ 5,791 0.20 $ 5,978 10034420 61030 100 NA-27 ASSIST PLAYGROUND COORD 0.10 $ 2,506 0.10 $ 2,542 0.10 $ 2,624 10034420 61030 100 NA-45 AFTER SCHOOL SPORTS COORD 0.41 $ 14,142 —$ — —$ — 10034420 61030 100 NA-12 LABORER I 0.09 $ 1,887 0.09 $ 1,915 0.09 $ 2,518 10034420 61030 100 3450 NA-25 RECREATION FIELD SUPERVISOR 0.45 $ 16,192 0.45 $ 16,432 0.45 $ 16,967 10034420 61030 100 3550 NA-14 RECREATION LEADER 4.85 $ 104,306 5.06 $ 110,407 5.06 $ 113,999 Total 7.02 $ 160,396 6.82 $ 152,973 6.82 $ 158,491 Therapeutic Activity-Seasonal 10034430 61030 100 NA-25 RECREATION FIELD SUPERVISOR 0.15 $ 5,769 0.15 $ 5,854 0.15 $ 6,045 10034430 61030 100 NA-14 RECREATION LEADER 0.91 $ 19,533 0.91 $ 19,817 0.91 $ 20,463 Total 1.06 $ 25,302 1.06 $ 25,671 1.06 $ 26,508 Recreation Classes-Seasonal CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -68- 10034460 $ 61,030 100. 00 $ 3,585 NA-35 PRE-SCHOOL INSTRUCTOR 0.12 $ 3,907 0.12 $ 3,967 0.12 $ 4,096 10034460 61030 100 NA-25 RECREATION FIELD SUPERVISOR 0.24 $ 6,418 0.24 $ 6,516 0.24 $ 6,727 Total 0.36 $ 10,325 0.36 $ 10,483 0.36 $ 10,823 Port of Dubuque Marina Dock Maintenance-FT 10030560 61010 100 GE-33 FACILITIES SUPERVISOR 0.33 $ 20,010 0.33 $ 20,306 0.33 $ 20,967 Total 0.33 $ 20,010 0.33 $ 20,306 0.33 $ 20,967 Port of Dubuque Marina Dock Maintenance- Seasonal 10030560 61030 100 NA-23 DOCK WORKER 0.58 $ 12,358 0.58 $ 12,546 0.58 $ 12,546 Total 0.58 $ 12,358 0.58 $ 12,546 0.58 $ 12,546 Port of Dubuque Marina Convenience Store -FT 10030550 61010 100 GE-33 FACILITIES SUPERVISOR 0.34 $ 20,616 0.34 $ 20,921 0.34 $ 21,603 Total 0.34 $ 20,616 0.34 $ 20,921 0.34 $ 21,603 Port of Dubuque Marina Convenience Store- Seasonal 10030550 61030 100 NA-23 MARINA CASHIER/CLERK 0.83 $ 18,611 0.83 $ 18,882 0.83 $ 18,882 Total 0.83 $ 18,611 0.83 $ 18,882 0.83 $ 18,882 CD Target Area Programs-Seasonal 26034500 61030 260 3585 NA-35 PRE-SCHOOL INSTRUCTOR CDBG 0.72 $ 28,308 0.72 $ 28,729 0.72 $ 29,661 26034500 61030 260 3450 NA-25 RECREATION FIELD SUPERVISOR CDBG 0.61 $ 16,660 0.61 $ 16,914 0.61 $ 17,462 Total 1.33 $ 44,968 1.33 $ 45,643 1.33 $ 47,123 AmeriCorps - FT 10034910 61010 100 1185 AMERICORPS PROGRAM DIRECTOR 0.10 $ 6,310 —$ — —$ — 10034911 61010 100 1185 AMERICORPS PROGRAM DIRECTOR 0.06 $ 3,786 0.06 $ 4,223 0.07 $ 5,372 10034911 61010 100 COMMUNITY OUTREACH COORD —$ — 1.00 $ 44,641 1.00 $ 46,082 10034911 61010 COMM DIVERSION/ PREVENT COORD —$ — —$ — 1.00 $ 67,108 10034911 61010 SECRETARY —$ — —$ — 1.00 $ 40,378 10034912 61010 100 1185 AMERICORPS PROGRAM DIRECTOR 0.84 $ 53,003 —$ — —$ — 10034913 61010 100 1185 AMERICORPS PROGRAM DIRECTOR —$ — 0.12 $ 8,580 0.81 $ 59,122 10034918 61010 100 1185 AMERICORPS PROGRAM DIRECTOR —$ — 0.82 $ 57,798 0.11 $ 8,336 Total 1.00 $ 63,099 2.00 $ 115,242 4.00 $ 226,398 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -69- AmeriCorps - PT 10034910 61010 100 1185 AMERICORPS COORDINATOR —$ — —$ — —$ — 10034911 61010 100 1185 AMERICORPS COORDINATOR —$ — —$ — 0.03 $ 1,385 10034912 61010 100 1185 AMERICORPS COORDINATOR —$ — —$ — —$ — 10034913 61010 100 1185 AMERICORPS COORDINATOR —$ — 0.11 $ 5,136 0.17 $ 9,698 10034918 61010 100 1185 AMERICORPS COORDINATOR —$ — 0.17 $ 7,871 0.20 $ 9,698 Total —$ — 0.28 $ 13,007 0.40 $ 20,781 TOTAL RECREATION DIVISION 43.95 $ 1,565,143 45.03 $ 1,647,458 47.15 $ 1,874,785 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -70- Capital Improvement Projects by Department/Division RECREATION DIVISION CIP Number Capital Improvement Project Title FY 20 Actual Expense FY 21 Actual Expense FY 22 Adopted Budget FY 23 Recomm'd Budget 1012886 LS DEFERRED MAINT ASSESS — — 90,000 — 1021456 SUTTON ZERO DEPTH SURVEY — — — 1,500 1021530 GOLF COURSE IRRIGATION 12,983 1,793 — — 1021563 FLORA-WATERSLIDE PUMP — — — 2,000 1021890 F&S ANNUAL MAINTENANCE — 46,196 30,000 135,000 1022120 FLORA POOL-SAND PLAYGRND — — — — 1022648 F&S POOL ASSESSMENTS — — — — 1022832 BUNKER HILL IMPROVEMENTS — — — — 1022834 REC OPERATING SYSTEM — — — — 1022885 POD DOCK MAINTENANCE — — 10,000 — 1022887 QUALITY OF LIFE ASSESS — — 40,000 — 1022888 EB LYONS SLOPE STABILIZE — — 49,500 — 3501058 BUNKER HILL REMODELING — — 30,000 — 3501446 FLORA/SUTTON POOL HEATERS — — — — 3701527 GOLF TEE IMPROVEMENTS — — 10,000 — 3701530 GOLF COURSE IRRIGATION — — — — 3702001 BUNKER CART PATHS — — 10,000 — RECREATION DIVISION TOTAL 12,983 47,989 269,500 138,500 -71- PROGRAM/ DEPT PROJECT DESCRIPTION FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 TOTAL PAGE RECREATION DIVISION Culture and Recreation Swimming Pools Flora and Sutton Pools Annual Maintenance $ 135,000 $ — $ — $ — $ — $ 135,000 90 Flora & Sutton Filter Tank Replacement $ — $ 200,000 $ — $ — $ — $ 200,000 91 Flora - Water Playground $ — $ — $ — $ 150,000 $ 150,000 $ 300,000 92 Flora & Sutton Admissions Counter Reconstruction - ADA $ — $ — $ — $ — $ 10,000 $ 10,000 93 Flora & Sutton Renovate Locker Rooms $ — $ — $ — $ — $ 60,000 $ 60,000 94 Sutton Pool Zero Depth Survey & Remediation $ 1,500 $ — $ — $ — $ 40,000 $ 41,500 95 Flora Pool Water Slide Assessment & Repairs $ 2,000 $ — $ — $ — $ 50,000 $ 52,000 96 Bunker Hill Golf Course Bunker Hill-Construct Cart Paths $ — $ — $ 10,000 $ — $ 10,000 $ 20,000 97 Bunker Hill Range Project $ — $ — $ 72,170 $ — $ — $ 72,170 98 Bunker Hill Golf Course - Tee Improvements $ — $ 10,000 $ — $ 10,000 $ — $ 20,000 99 Bunker Hill-Material Storage Reno $ — $ — $ — $ 15,000 $ — $ 15,000 100 Port of Dubuque Port of Dubuque Marina - Dock Maintenance $ — $ 10,000 $ 10,000 $ — $ — $ 20,000 101 Port of Dubuque Flood Wall Dubuque Welcome Sign $ — $ — $ — $ 30,000 $ — $ 30,000 102 TOTAL $ 138,500 $ 220,000 $ 92,170 $ 205,000 $ 320,000 $ 975,670 -72- FISCAL YEAR 2023 BUDGET PRESENTATION RECREATION DIVISION MISSION STATEMENT Recreation Division To provide the citizens of Dubuque with equitable, high-quality, and inclusive opportunities that will create impactful experiences. RECREATION DIVISION (42.75 Full-Time Equivalents) Recreation Supervisor Brian Feldott Golf Course Supervisor Vacant Recreation Supervisor Tony Elskamp Recreation Supervisor Janna Beau PGA Professional Mike Sullivan Facilities Supervisor Vacant-Frozen Customer Service Assistant Lenisha West Support Staff 34.81 FTE Golf Course Technician Steve Schilling Lead Admin Assistant Kristen Dietz What We Do Programs •Youth & Adult Athletics •Neighborhood •Playgrounds •Swim Lessons •Therapeutic Recreation •Early Childhood •Golf Lessons •Rec & Roll •Active Adult Facilities •Flora & Sutton Pool •Port of Dubuque Marina •Bunker Hill Golf Course •Allison Henderson •Comiskey Park Building •MFC Services •Customer Service •Scholarships •Rentals Partnerships •Food Distribution •Support Services •Planning •Programming •Instruction •Community Engagement •Facilities PRIOR YEAR HIGHLIGHTS •Increase in Mobile / Accessible Programming •Build-Out of New Operating System •Miracle League Partnership www.cityofdubuque.org/miracle-league-special-populations ◦Grand Opening Event ◦Over $100,000 spent on Complex improvements PRIOR YEAR HIGHLIGHTS •Increased Online Connection ◦54,000+ page visits (just over 25% of all City) ◦Summer 2021 Brochure Facebook post had 13,000 views. •New Brochure Format Reaching every household. PRIOR YEAR HIGHLIGHTS •Over 27,000 Golf Rounds ◦16% Increase from 3-year Average pre-Covid •Why Significant? ◦Still includes procedural changes due to COVID-19. ▪Less Events ▪Less Available Tee Times ADVANCING EQUITABLE SERVICE •Department Customer Service Relocated to MFC •Filling a need with over 4,800 meals served in the summer. •Increasing Accessibility •More Equipped Frontline Staff ADVANCING EQUITABLE SERVICE •Removing/Reducing Financial Barriers through: ◦Scholarship Funding for 200 Families ◦Over 30 Free Programs ◦50% discount on Pool Passes and select programs ◦Revised Refund Policy ◦Free Certifications FUTURE INITIATIVES •Long Term Infrastructure Plan •Recruitment & Workforce Development •Expand Active Adult Programming •Ancillary Revenue Generation •Continued Growth in Golf Recreation Division FY2023 REQUESTED PROPERTY TAX SUPPORT $1,769,938 $26.25 Net Operating Property Tax Support Average homeowner’s* property tax cost for the Recreation Division (*Avg. home value of $159,503) COMMUNITY INVESTMENT -WAGES OUTPUT •Over 25% of Division Operating Budget is put back into the community in the form of wages and payouts. ◦Seasonal Wages = $824,076 ◦Instructors = $89,099 ◦Officials = $26,870 OUTCOMES •Local Economic Impact •Experience •Community Engagement Flora & Sutton Pools •30 years old •Total operating property tax subsidy for Flora & Sutton Pools: $321,242 •Property tax cost per average homeowner: $4.76 Port of Dubuque Marina •Total operating property tax subsidy for marina: $120,988 •Property tax cost per average homeowner: $1.79 COMMUNITY INVESTMENT -FACILITIES RETURN ON INVESTMENT -IMPACT Port of Dubuque Marina 517 Overnight Reservations = Estimated $109,000 in Economic Impact Season Highs for 2021 •7 Seasonal Slip Renters •40% Increase in Reservations •57% Increase Fuel Revenue FY2023 RECOMMENDED IMPROVEMENT REQUESTS 1. Lifeguard Certifications Recurring | $6,000 2. Comiskey Building Furnishings/Equipment Non-Recurring Cost | $20,000 3. 2 Laptops (1 for Miracle League & 1 for AmeriCorps) Non-Recurring | $5,600 4. $10 increase in all annual passes for Bunker Hill Golf Course Recurring Revenue | $1,290 Project FY 23 Cost Total Project Cost Flora and Sutton Pools Annual Maintenance $135,000 $135,000 Flora Water Slide Assessment and Repair $2,000 $52,000 Sutton Zero Depth Survey & Remediation $1,500 $41,500 FY 23 CAPITAL IMPROVEMENT PROJECTS RECREATION DIVISION PERFORMANCE MEASURES THANK YOU www.cityofdubuque.org/recreation