The URL can be used to link to this page

Library Fiscal Year 2023 Budget Presentation Copyrighted March 3, 2022 City of Dubuque Public Hearings # 2. Special Meeting ITEM TITLE: Library Fiscal Year2023 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Library Policy Budget Book Supporting Documentation Presentation_Uploaded 3.3.22 Supporting Documentation Library -23- This page intentionally left blank. -24- LIBRARY DEPARTMENT FY 2021 FY 2022 FY 2023 Fro�m FY 022 Budget Highlights Actual Budget Requested Budget Expenses Employee Expense 2,283,002 2,665,902 2,730,555 2.4% Supplies and Services 1,013,046 1,128,433 1,197,754 6.1% Machinery and Equipment 59,494 81,259 67,472 -17.0% Subtotal 3,355,542 3,875,594 3,995,781 3.1% Debt Service 309,455 226,591 225,380 -0.5% Total Requirements 3,664,997 4,102,185 4,221,161 Resources Library Gift Trusts 66,365 77,402 35,650 -53.9% Sales Tax 20% for Debt Abatement 22,528 19,741 19,380 -1.8% TIF Revenue for DebtAbatement 202,400 206,850 206,000 -0.4% Operating Revenue 58,717 39,805 53,361 34.1% Total Revenue 350,010 343,798 314,391 -8.6% Property Tax Support 3,314,987 3,758,387 3,906,770 148,383 Percent Increase (Decrease) 3.9% Percent Self Supporting 1.8 % 1.0 % 1.3 % Personnel -Authorized FTE 35.64 35.64 35.15 Improvement Package Summary 1 of 2 This improvement request is for a part time (0.50 FTE) Marking Coordinator position in the Admin Department. The Library's mission is to improve the quality of life by providing resources for individual enjoyment, enlightenment, knowledge, and that enhance the literacy of youth. Libraries are consistently struggling to fight through the noise to reach community members and share all the fabulous resources available to them at their public library. Employing a part-time marketing coordinator that is skilled and trained to engage our citizens via social media, engage with staff to share resources with the community using a focused, consistent message and brand is a top priority. Previously, a marketing firm was used, with uninspiring results. Having a dedicated staff member in a permanent, general fund position and not on a temporary contract is a top priority for the Library Board of Trustees. The Library Board of Trustees has previously approved the temporary contract to provide these skills to our community through gift funds. To assure longevity and stability in the position the Carnegie-Stout Board of Trustees has a goal to see the position funded via the general fund. This would also free up gift funds to use for items that can impact the community in different ways. The request supports the City Council Goals of Diverse Arts, Culture, Parks, and Recreation Experiences and Activities by providing a consistent voice and brand for the Carnegie-Stout Public Library, the City of Dubuque, and sharing the wealth of resources and activities our residents can enjoy. Related Cost: $ 35,304 Tax Funds Recurring Recommend - No Property Tax Impact: $ 0.0139 0.14% Activity: Library Administration -25- 2 of 2 This improvement request is for a full-time position in the Information Technology Activity focusing on Maker Space programming and outreach. The Information Technology Activity oversees the collection in the Maker Space and facilitates public use during all Library hours as well as planned programs. The Library's mission is to improve the quality of life by providing resources for individual enjoyment, enlightenment, knowledge, and that enhance the literacy of youth. The Information Technology Activity currently serves this goal with two part-time Library Assistant (GE-25) positions in the Maker Space. The Maker Space collection includes high-tech equipment that is out of reach for most patrons but can be accessed and trained on in the Library. However, current staffing levels leave the space unattended for 34°/o of Library hours and limits our ability to provide off-site programs. The situation is compounded with the high level of skill that is needed to service and instruct patrons on the use of the equipment. The part-time positions do not attract applicants with the skills already and training takes over a year. Historically part-time staff leave the position not long after their training is complete starting the cycle over.As a result, the Maker Space has spent most of its existence without fully trained staff. Transitioning the two Library Assistants (GE-25) part-time 20 hour positions to one full-time Lead Library Assistant (GE-27) position would provide an anchor of knowledge in the space while reaching the goal of full staffing. With these hours available and the ability to retain talent we would be able to increase our monthly programs for patrons to at least 36 and would enable us to engage in off-site programs and outreach. This position would also free up time in the Information Technology Activity, which would be used to offer at least 24 more general technology courses for continuing education. There is a reoccurring cost increase and additional budget impact of$26,420 in creating this new GE-27 Library Lead Assistant full-time position with Health Benefits and eliminating the two GE-25 Library Assistant part-time positions. This request supports the City Council Goals of Diverse Arts, Culture, Parks, and Recreation Experiences and Activities, as well as being a High-Performance City Organization. Related Expense: $ 81,382 Tax Funds Recurring Recommend -Yes Related Savings: $ 54,962 Net Cost: $ 26,420 Property Tax Impact: $ 0.032 0.33% Activity: Information Technology Significant Line Items Employee Expense 1. FY 2023 employee expense reflects a 3.25% wage package increase. 2. The lowa 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 annual increase of$20,852 or 3.04%. 4. 50°/o Sick Leave Payout increased from $3,669 in FY 2022 to $5,882 in FY 2023 based on FY 2021 actual. Effective July 1, 2019, employees over the sick leave cap can convert 50% of the sick leave over the cap to vacation or be paid out. 5. Overtime is unchanged from $27,299 in FY 2022 to $27,299 in FY 2023. FY 2021 actual was $6,944. -26- 6. In FY 2022, two part-time Library Assistants were moved from Circulation to Information Technology (1.0 FTE) to meet the increased demand for Maker's Space services. In FY 2023, those positions are being returned to their previous activities. Supplies 8� Services 7. Data Processing Equipment Maintenance Contracts increased from $85,609 in FY 2022 to $104,561 in FY 2023. FY 2021 actual was $103,028. The items included are as follows: % Change Fiscal Year FY 2023 From FY 2022 Contract 2022 Budget Requested Budget Overdrive Platform for Digital Material $ 6,120 $ 6,319 3.25 % Websense Spam Filter (65 Licenses) $ 1,625 $ 1,625 - % Talking Tech Maintenance $ 4,500 $ 4,500 - % Techlogic Hardware & Software $ 8,514 $ 2,300 (72.99)% (a) Sophos Firewall Maintenance $ 3,051 $ 3,051 - % Bywater ILS Support & Development $ 28,600 $ 28,000 (2.10)% Catalog Updates $ 2,112 $ 2,112 - % Security System Patches/Updates $ 2,631 $ 2,631 - % Globalcom Security Contract $ 1,200 $ 1,800 50.00 % (b) GO Daddy Accounts 600 1,500 150.00 % (c) PC Res Upgrades 7,199 (d) Envisionware Internet Management 3,300 - (100.00)% (e) VM Ware $ 4,870 $ 4,774 (1.97)% Network Support $ 6,936 $ 11,922 71.89 % (f) Website Maintenance $ 5,600 $ - (100.00)% (g) Infrastructure Switches Support $ 9,360 $ 22,860 144.23 % (h) Various Small Contracts $ 1,086 $ 1,086 - % Veritas Backup Solution $ 1,468 $ 145 (90.12)% (i) Envisionware Credit Card Fees $ 1,188 $ 537 (54.80)% Meraki Wireless Gateway $ 1,818 $ 2,200 21.01 % GoToMyPC License $ 75 $ - (100.00)% Total $ 94,654 $ 104,561 22.14 % (a)Techlogic Hardware and Software decrease based on renegotiating the contract and dropping maintenance fees on a few products no longer needed. (b) Globalcom Security Contract fees increased due to an increase in security cameras. (c) GoDaddy increase due to new SSL certifications for Dubuque Wiki, The Bridge reading site, and the Carnegie Stout website. (d) PC Res Upgrades is new and required since the current vendor is no longer updating software. TBS will se servicing the library's needs. (e) Envisionware Internet Management decrease due to switching to TBS (f) Network Support - includes Faronics, library calendar, Remote PC, Proquest, Plimus, Adobee, and Avast Cloudcare (g) Website Maintenance contract was discontinued and maintenance is now being done by City staff. (h) Infrastructure switches support increased due to quoted cost to support SAN replacement. Cost includes barcode switch and set up, MC upgrades, and SAN support. (i) Veritas Backup Solution decreased based on savings from available discount. -27- 8. Office Supplies increased from $18,746 in FY 2022 to $20,203 in FY 2023. Increases due to needing new library cards in FY 2023. 9. Postage decreased from $19,749 in FY 2022 to $19,024 in FY 2023 based on FY21 budget. 10. Electricity increased from $83,217 in FY 2022 to $84,465 in FY 2023 based on FY 22 budget plus (1.5°/o)%. Reviewed prior three years usages for projected expenses. 11. Gas increased from $24,906 in FY 2022 to $25,372 in FY 2023 based on FY 2019 actual plus 8.6%. Reviewed prior three years usages for projected expenses. 12. Speakers and Programs increased from $17,229 in FY 2022 to $18,585 in FY 2023 based on FY 2021 Adopted Budget. 13. Property Maintenance increased from $30,793 in FY 2022 to $34,280 in FY 2023 based on FY 2021 plus 5°/a 14. HVAC Maintenance decreased from $22,918 in FY 2022 to $18,478 in FY 2023 based on FY 2021 actual. 15. Library Video Materials unchanged from $66,470 in FY 2022 to $66,470 in FY 2023 based on FY 2022 Budget. 16. Data Processing increased from $29,276 in FY 2022 to $30,413 in FY 2023 based on FY 2021 actual plus 5%. 17. Property Insurance increased from $30,748 in FY 2022 to 33,661 in FY 2023 based on an expected increase of 9.47% 18. Temporary Help Contract Services increased from $17,678 in FY 2022 to $28,050 in FY 2023. This line item represents the time having an Americorps member work in outreach in children's services. Funds have not been fully expended in years past, but expect to do so in FY2023. 19. Online Information Service increased from $52,262 in FY 2022 to $74,845 in FY 2023 based on FY 2021 of$64,500. This line item includes subscriptions to informational databases, online newspapers and periodicals, one subscription to Ingram Library Service software to assist with the selection and acquisition of new material, and one subscription to the homework help database "Tutor.com." 20. Library materials, excluding materials purchased by Library trust funds, increased from $426,214 in FY 2022 to $434,567 in FY 2023. Library materials are budgeted as follows: -28- Change Fiscal Year Fiscal Year From FY FY 2021 2021 2022 FY 2023 2022 Library Materials Actual Budget Budget Requested Budget Books $ 199,421 $ 202,276 $ 213,639 $ 213,639 - % Book Club $ 2,958 $ 2,114 $ 2,135 $ 2,135 - % Audiobooks $ 74,496 $ 71,580 $ 82,368 $ 85,580 3.90 % e-Books $ 57,581 $ 46,083 $ 52,223 $ 57,243 9.61 % Continuations $ 12,664 $ 33,187 $ 35,677 $ 35,677 - % Periodicals $ 34,220 $ 35,979 $ 40,172 $ 40,293 0.30 % Total 381,340 391,219 426,214 434,567 1.96 % The library reviews the total materials budget when purchasing and budgeting for the various formats of material and allocates the funds to meet demand. The Library and Trade Book Almanac (formerly The BowkerAnnual) and School Library Journal publishes a library materials price index each year. In planning for Fiscal Year 2023, hardcover books are projected to increase 1.5% for Adult and 6.14% for children, mass market paperback books are projected to increase 1.5%, library binding is projected to increase 25.74%, e-Books are projected to increase 6.5%, CD audio books are projected to increase 6.5%, serials/continuations are projected to increase 6%, periodicals are projected to increase 6.7%, and graphic novels/comics are projected to decrease 4%. 21. General Library Trust expense decreased from $77,402 in FY 2022 to $35,650 in FY 2023. The balance of the Expendable Library Gift Trust Fund as of October 31, 2021 was $1,109,732. The breakout of the balance by each Expendable Library Gift Trust Fund is as follows: 10/31/2021 Library Gift Trust Balance General Gift Trust $ 128,278 Walton Gift Trust $ 7,428 Maker Space Gift Trust $ 114 Mutschler Gift Trust $ 973,912 Total $ 1,109,732 Library Trust expenses budgeted include: Library Trust Fund Budget FY 2022 FY 2023 Part-Time Marketing Coordinator $ 33,300 $ - * Workers Compensation $ 71 $ 56 Office Supplies $ 500 $ 6,870 Printing & Binding $ 1,276 $ 1,072 Copying $ 800 $ - Program Supplies $ 4,357 $ 4,558 Speakers/Programs $ 8,000 $ 8,000 Promotion $ 6,000 $ 6,000 Online Info Service $ 6,000 $ 6,000 Library Books $ 1,000 $ 1,000 Property Maintenance $ 4,000 $ - Office Equipment $ 750 $ - -29- Library Trust Fund Budget FY 2022 FY 2023 Tablet $ 400 $ — Software $ 500 $ — Computer $ 8,000 $ — Catering $ 2,000 $ 2,000 Sales Tax $ 448 $ 94 Total $ 77,402 $ 35,650 * Part-time Marketing Coordinator is a two-year position thru Fiscal Year 2021. A continuation of that position is being requested in FY 2023 Machinery & Equipment 22. Equipment replacement items include ($67,472): Administration Microwave $ 300 Chairs $ 900 (2) Desk phones $ 500 Adult Services Chairs $ 4,500 Laminator $ 3,100 Circulation Services Book Carts (9) $ 1,000 Information Technoloav Security Cameras (7) and DVR $ 7,400 Coin Op - Copy Machine $ 2,545 Tech Logic Security Gate $ 20,000 Analog DVR $ 9,500 Technical Services Book Carts (2) $ 400 Label Printer for Barcodes $ 390 Maintenance Services Lighting Equipment (151) $ 2,718 Water Cooler $ 4,000 Side Chairs $ 10,219 Total Equipment $ 67,472 -30- Debt Service 23. FY 2023 annual debt service includes the following ($225,380) Final Call Amount Debt Series Source Purpose Payment Date $ 206,000 2016B GDTIF Renovation 2023 2023 , $ 4,087 2019C Sales Tax 20% Improvements 2027 2022 , $ 15,293 2021A(2012E) Sales Tax 20% Improvements 2027 2019 $ 225,380 Total Library Annual Debt Service Revenue 24. Book Fines increased from $600 in FY 2022 to $10,600 in FY 2023 and is based on FY2021 actual. For FY 2023, this line item is budgeted to include damaged and lost items which were not previously budgeted. 25. Nonresident Fees increased from $18,000 in FY 2022 to $24,603 in FY 2023 based on State legislature limits. 26. Copy Services Charges decreased from $12,000 in FY 2022 to $8,100 in FY 2023. There is an expectation that this revenue will decrease as more patrons use electronic devices. 27. County Payments increased from $2,300 in FY 2022 to $3,500 in FY 2023. This line item represents proceeds from the 28E agreement to provide library services to communities in the county that do not have libraries and are not covered by the County Library. The amount is based on circulation and a base. Miscellaneous 28. The Library is 1.3% self-supporting in FY 2023 as compared to 1.0% self-supporting in FY 2022. -31- This page intentionally left blank. -32- CARNEGIE-STOUT PUBLIC LIBRARY The Carnegie-Stout Public Library strives to improve the quality of life by providing resources that enhance and contribute to individual enjoyment, enlightenment, knowledge and that enhance the literacy of youth. ll Ilyd�y 94drd of irus[ees iitynnanager'sOffice LihraryAdministratio MdleKialSACquiS�liUn InformaCia�+ B�aildingManalenante AG�uI#SerYl��g Y��#h5.�ryi{�S MatCrl,l�h�k4u[ pyPm�sSin�S�rvlr�s iPflli50l[i1�SPN�iPi �p3�xri�u#ipo�f Md[Pfld�4 SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES People: Library staff members provide outreach through the delivery of materials to homebound residents, residential care facilities, nursing homes, Elm Street Correctional facility, and through the Bicycle Library. Services are provided at the Boys and Girls Club, Jefferson, Washington, and Eleanor Roosevelt Middle Schools, the Multicultural Family Center, and at pop-up locations via the Bike Library. Planning: The Library Board will create a new strategic plan, which will be implemented in FY 2021 Partnerships: • Educational organizations: Dubuque Community School District, local colleges and universities and the public libraries in Dubuque County. • Community non-profit organizations: Boys and Girls Club, Family History Center,AmeriCorps, AARP Foundation, lowa Workforce Development, Quilts of Valor Foundation, Parents as Teachers, and more. • Local businesses: Hy-Vee grocery stores, Kennedy Mall, KDTH Radio, Sedona Staffing, local credit unions and banks, and many retail businesses. -33- CARNEGIE-STOUT PUBLIC LIBRARY FY 2021 FY 2022 FY 2023 Full-Time Equivalent 35.64 35.64 35.15 Revenue and Property Tax Support $3,600,000 $3,300,000 $3,000,000 $2,700,000 $2,400,000 $2,100,000 $1,800,000 $1,500,000 $1,200,000 $900,000 $600,000 $300,000 $0 �bca�G\{��c�s�s a'�20°I°{ocOe�� e�er�e{o�Oeb� eta��rg�eJerJe e�y�a�s�ppo� �- Sa�es� .��F� OP QCoP ■ FY 2021 FY 2022 FY 2023 The Carnegie-Stout Public Library is supported by 35.15 full-time equivalent employees, which accounts for 64.69% of the department expense as seen below. Overall, the department expenses are expected to increase by 2.90% in FY 2023 compared to FY 2022. Expenditures by Category by Fiscal Year $2,283,002 Employee Expense $2,665,902 $2,730,555 $1,013,046 Supplies and Services $1,128,433 $1,197,754 $59,494 Machinery and Equipment $81,259 $67,472 $309,455 Debt Service $226,591 $225,380 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 FY 2021 FY 2022 � FY 2023 -34- CARNEGIE-STOUT PUBLIC LIBRARY Adult Services Mission & Services Provides and promotes Library services and collections for adult citizens of Dubuque for the purpose of supplying information, encouraging recreational reading, listening and viewing, and enhancing intellectual development. Adult Services Funding Summary FY 2022 FY 2023 FY 2021 Actual Budget Requested Expenditures $1,530,320 $1,786,691 $1,848,260 Resources $2,585 $2,375 $2,585 Adult Services Position Summary FY 2023 Librarian I -FT 4.00 Librarian I -PT 0.07 Library Director 1.00 Librarian II 1.00 Library Aide- FT 4.00 Library Aide- PT 1.00 Administrative Assistant 1.00 Custodian 0.13 Clerical Assistant 0.25 Confidential Account Clerk 0.63 Total FT Equivalent Employees 13.08 Performance Measures � Activity Objective: Provide users with convenient access to information, services, and entertainment through technology. Performance FY 2019 FY 2020 FY 2021 FY 2022 Performance Measure (KPI) Target Actual Actual Actual Estimated Indicator #of electronic informational g5,000 85,873 95,000 236,586 200,000 � resources accessed Total internet and 108,000 107,583 108,00 77,847 80,000 �� wireless use 2 Activity Objective: Provide materials that are relevant to the needs and interests of library users and the community + a wide range of informational/recreational programs to interest adults. #of check outs of digital materials (e- books, e-audio, 115,000 85,356 120,059 118,621 115,000 � streaming video, music) #of attendees to 4,600 4,604 4,300 999 2,500 a programs #of programs held for 130 138 65 57 45 a adults -35- CARNEGIE-STOUT PUBLIC LIBRARY Youth Services Mission & Services Provides and promotes Library services and collections for youth ages 0-17 to enhance early childhood literacy, encourage lifelong reading, and meet the informational and recreational needs for children and young adults. Youth Services Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $420,288 $619,535 $658,895 Resources $0 $0 $0 Youth Services Position Summary FY 2019 Librarian II 1.00 Administrative Assistant 1.00 Library Aide-FT 2.00 Library Aide-PT 0.69 Library Clerk 2.57 Total FT Equivalent Employees 7.26 Performance Measures � Activity Objective: Provide new informational and recreational material to youth to increase enjoyment of reading while maintaining and enhancing literacy skills. Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 FY 2022 Performance Actual Actual Actual Estimated Indicator #of children's items checked out 145,000 139,870 145,645 147,217 145,000 � #of young adult materials checked out 13,500 11,072 13,000 12,968 12,000 C�� City Council Goal: Partnerships for a Better Dubuque 2 Activity Objective: Partner with other agencies to bring library programs to underserved youth. #of programs provided to area child care 160 165 150 108 100 a centers through Americorps #of programs delivered for Leadership 24 21 24 0 0 C�� Enrichment After-School Program (LEAP) -36- CARNEGIE-STOUT PUBLIC LIBRARY Materials Check-Out and Distribution Mission & Services Enable residents of Dubuque to apply for and receive a library card and to borrow materials in an atmosphere of courteous and friendly attentiveness, maintain the borrower records for the Library, and provide outreach to facilities with home-bound residents. Materials Check-Out Funding Summary FY 2022 FY 2023 FY 2021 Actual Budget Requested Expenditures $853,073 $880,996 $925,810 Resources $56,132 $37,430 $50,776 Materials Check-Out Position Summary FY 2023 Circulation Manager 1.00 Library Lead Assistant 0.63 Custodian - FT 1.00 Custodian-PT 0.13 Clerical Assistant 0.25 Library Assistant 6.30 Library Clerk 1.00 Total FT Equivalent Employees 10.31 Performance Measures � Activity Objective: Accurately maintain library materials and records so every library user may fully enjoy all available resources 8� improve on-time returns. Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 FY 2022 Performance Actual Actual Actual Estimated Indicator #of items available for library users 255,000 254,057 255,000 183,553 185,000 [�� #of registered borrowers (as % of 41,000 44,205 41,000 40,152 42,000 [y� population) (71%) (75%) (71%) (69%) % of checked out items returned late 18% 19% 20% 25% 20% � 2 Activity Objective: Outreach and material delivery to nursing homes, residential care facilities, and remote drop- off and pick-up sites for residents unable to visit the library. #of visits to nursing homes/residential 9 g g 49 25 � care facilities #of deliveries to homebound residents 170 128 158 247 165 �� 3 Activity Objective: Provide users with access to a wealth of current information. #of times visitors accessed informational g0,000 85,873 90,000 79,716 80,000 �� databases #of issues of archived Telegraph Herald 167,000 162,730 130,390 156,870 160,000 �� newspapers viewed -37- CARNEGIE-STOUT PUBLIC LIBRARY Information Technology Services Mission & Services Information Technology Services provides a knowledgeable and competent staff offering direction and support for the entire scope of technology in the library and online for enhanced patron access. This scope includes the Maker Space, desktop support, database programming, network administration, and server maintenance. Information Technology Services Funding Summary FY 2022 FY 2023 FY 2021 Actual Budget Requested Expenditures $465,758 $487,046 $502,609 Resources $0 $0 $0 Information Technology Services Position Summary FY 2023 Lead Application Network Analyst 1.00 User Support Specialist 1.00 Makerspace Assistant 1.00 Maintenance Worker 1.00 Information Services Intern 0.50 Total FT Equivalent Employees 4.50 Performance Measures City Council Goal: Diverse Arts, Culture, Parks 8� Recreation � Activity Objective: Provide users with convenient access to information, services, and entertainment through technology. Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 FY 2022 Performance Actual Actual Actual Estimated Indicator #of one-on-one technology-based g0 70 156 47 60 �� classes offered #of technology troubleshooting sessions 225 223 66 48 60 � with individual library patrons MakerSpace: Did you know you can check out the following from MakerSpace in the library? iPads � Macbook Pro � 3D Printers �Apple TVs � Chromecast � Button Maker � Virtual Reality � VHS to DVD Converter � Slide & Film to DVD Converter � GoPro Cameras � Video Cameras � Makey Makey Controllers � Ozobots � Snap Circuits � Green Screen � Cricut Machine � Cuddlebug � Sewing Machines � Embroidery Machine �Adobe Creative Cloud Software � Raspberry Pi Mini-Computers � Crafting Supplies � Jewelry-Making Equipment � Kindles � Retro Gaming System � Hot Spots � Projector � Microphones � Digital Cameras � WhisperRoom...and more! -38- Recommended Operating Revenue Budget - Department Total 36-LIBRARY FY20 Actual FY21 Actual FY22 Adopted FY23 Recomm'd Fund Account Account TiUe Revenue Revenue Budget Budget 295 43110 INVESTMENT EARNINGS 21,743 9,318 21,743 9,318 550 43110 INVESTMENT EARNINUS 361 148 361 148 43 USE OF MONEY AND PROPERTY-Total 22,104 9,467 22,104 9,466 100 4(I I S COUNTY PAYMENT-LIBRARY 0 0 2,300 3,500 46 LOCAL GRANT AND REIMBURSE-Total 0 0 2,300 3,500 100 51921 INTERLIBRARY LOAN FEES 10,246 1,836 2,330 1,548 100 51922 NONRF.SIDF.NT FEF.S-LIBRARY 14,835 26,707 18,000 24,603 100 51924 RESIDENT FEES-LIBRARY 732 573 400 523 295 51949 ART FEES 8,976 3,558 7,536 3,558 100 51953 MEETING ROOM FEES 3,077 2,852 3,600 2,300 100 51981 COPY SERVICE CHARGES 8,525 8,397 12,000 8,100 51 CHARGES FOR SERVICES -Total 46,391 43,922 43,866 40,632 295 53103 CONTRIBUTiONS 460 36 460 36 100 53201 REFLTNDS 4,912 1,494 475 1,324 295 53201 REFiJNDS 98,997 32,572 300 32,572 550 53201 REFUNDS 158 247 158 247 100 53406 BOOK FINES 11,319 12,366 600 10,600 100 53605 MISCELLANEOUS REVENUE 339 4,042 100 412 ]00 53620 REIMBURSEMENTS-GENERAL 156 451 0 45 L 53 MISCELLANEOUS -Total 116,341 51,207 2,093 45,642 400 54210 GO BOND PROCEEDS 38,900 84,526 0 0 400 54220 BOND DISCOUNT 1,762 515 0 0 54 OTHER FINANCING SOURCES -Total 40,662 85,041 0 0 400 59240 FR DOWNTOWN TIF 202,800 202,400 206,850 206,000 400 59350 FR SALES TAX CONSTRUCTION 19,725 22,528 19,741 19,380 59 TRANSFER IN AND INTERNAL -Total 222,525 224,928 226,591 225,380 LIBRARY -Total 448,023 414,565 296,954 324,620 -39- Recommended Operating Expenditure Budget - Department Total 36-LIBRARY FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-T1ME EMPLOYEES 1,258,217 1,115,989 1,392,154 1,483,882 100 61020 PART-TIME EMPLOYEES 539,610 546,892 592,343 567,318 295 61020 PART-TIME EMPLOYEES 26,437 29,630 28,439 0 100 61030 SEASONAL EMPLOYEES 14,921 12,443 0 0 100 61050 OVERTIME PAY 12,921 6,944 27,299 27,299 100 61083 COVIDI9 EMP NON-WORK 10,694 0 0 0 100 61085 SELF QUARANTINE HEALTH 0 2,040 0 0 100 61086 SYMPTOMS SEEK DIAGNOSIS 0 30 0 0 100 61092 VACATION PAYOFF 1,741 8,603 0 0 100 61095 PARENTAL LEAVE 7,493 15,977 0 0 100 61096 50%SICK LEAVE PAYOUT 3,669 5,882 3,669 5,882 100 61310 IPERS 171,331 160,375 189,084 195,967 295 61310 IPERS 2,496 2,797 2,685 0 100 61320 SOCIAL SECURITY 134,941 126,270 154,185 158,613 295 61320 SOCIAL SECURITY 2,022 2,267 2,176 0 100 61410 HEALTH INSURANCE 205,884 233,624 260,640 281,492 100 61415 WORKMENS'COMPENSATION 11,460 11,673 9,141 8,516 295 61415 WORKMENS'COMPENSATION 0 88 71 56 100 61416 LIFEINSURANCE 1,034 913 1,100 966 100 61417 LTNEMPLOYMENT INSURANCE 0 0 1,158 0 100 61651 MEALS NO OVERNIGHT 15 0 0 0 100 61660 EMPLOYEE PHYSICALS 1,758 564 1,758 564 61-WAGES AND BENEFITS 2,406,645 2,283,002 2,665,902 2,730,555 100 62010 OFFICE SUPPLIES 16,633 15,236 18,746 20,203 295 62010 OFFICE SUPPLIES 3,ll7 6,870 500 6,870 100 62011 UNIFORM PURCHASES 253 200 288 200 100 62030 POSTAGE AND SHIPPING 12,241 18,651 19,749 19,024 100 62031 PROCESSING MATERIALS 14,666 14,157 18,276 18,276 100 62050 OFFICE EQUIPMENT MAINT 369 406 574 612 100 62060 O/E MAiNT CONTRACTS 4,785 7,083 5,390 7,225 100 62061 DP EQUIP.MAINT CONTRACTS 81,023 103,028 85,609 104,561 295 62061 DP EQUIP.MAINT CONTRACTS 0 5,485 0 0 100 62062 JANITORIAL SUPPLIES 4,787 4,420 4,940 4,509 100 62070 OFFICE EQUIP RENTAL 863 863 863 897 100 62090 PRINTING&BINDING 6,518 8,254 12,408 9,820 295 62090 PRINTING&BINDING 1,050 339 1,276 1,072 100 62091 LIBRARY BINDING 918 0 937 937 100 62110 COPYING/REPRODUCTION 6,206 6,009 6,571 10,280 295 62ll0 COPYING/REPRODUCTION 0 0 800 0 100 62130 LEGAL NOTICES&ADS 6,070 8,855 10,553 8,854 100 62140 PROMOTION 12,829 10,347 12,131 12,131 295 62140 PROMOTION 5,842 1,389 6,000 6,000 100 62190 DUES&MEMBERSHIPS 3,589 1,707 3,507 3,336 100 62204 REFLTNDS 287 166 0 166 100 62206 PROPERTY INSURANCE 25,956 28,391 30,748 33,661 100 62207 BOILER iNSURANCE 0 0 139 0 100 62208 GENERAL LIABILITY INSURAN ll,283 ll,573 12,243 16,159 295 62210 SALES TAX 448 94 448 94 100 62310 TRAVEL-CONFERENCES 11,297 140 18,520 16,831 100 62320 TRAVEL-CITY BUSINESS 1,096 239 2,356 2,356 -40- Recommended Operating Expenditure Budget - Department Total 36-LIBRARY FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 62340 MILEAGE/LOCAL TRANSP 235 36 897 897 100 62360 EDUCATION&TRAINING 7,343 0 13,425 13,425 295 62360 EDUCATION&TRAINING 0 539 0 0 100 62411 UTILITY EXP-ELECTRICITY 79,254 73,187 83,217 84,465 100 62412 UTILITY EXP-GAS 24,906 29,621 24,906 25,372 100 62415 UTILITY EXPENSE STORMWATR 0 77 0 84 100 62421 TELEPHONE 4,106 4,184 4,ll9 4,185 100 62431 PROPERTY MAINTENANCE 30,793 34,280 30,793 34,280 295 62431 PROPERTY MAINTENANCE 2,315 0 4,000 0 550 62431 PROPERTY MAINTENANCE 150 0 0 0 100 62433 CUSTODIAL SERVICES 3,027 3,317 3,027 3,317 100 62434 HVAC MAINTENANCE 22,918 18,478 22,918 18,478 100 62435 ELEVATOR MAINTENANCE 2,427 2,427 2,427 2,427 100 62436 RENTAL OF SPACE 378 441 504 441 100 62511 FUEL,MOTOR VEHICLE 750 739 861 947 100 62521 MOTOR VEHICLE MAINT. 301 2,492 307 2,542 100 62605 E-BOOKS 51,101 57,581 52,223 57,243 295 62605 E-BOOKS 8,354 0 0 0 100 62611 MACH/EQUIP MAINTENANCE 233 606 233 606 100 62614 EQUIP MAINT CONTRACT 4,852 4,284 5,843 4,284 100 62650 BOOK CLUB BOOKS 2,084 1,123 2,135 2,135 100 62651 LIBRARY BOOKS 191,803 199,421 213,639 213,639 295 62651 LIBRARY BOOKS 50,149 3,308 1,000 1,000 100 62652 LIBRARY AUDIO/VISUAL 77,911 74,496 82,368 85,580 295 62652 LIBRARY AUDIO/VISUAL 416 0 0 0 100 62653 LIBRARY PERIODICALS 37,294 34,220 40,172 40,293 100 62654 LIBRARY CONT/SERIALS 11,989 12,664 35,677 35,677 100 62655 ON LINE INFO SERVICE 75,479 64,500 52,262 74,845 295 62655 ON LINE INFO SERVICE 128 0 6,000 6,000 100 62656 INTERLIBRARY LOAN 76 0 769 769 100 62659 LIBRARY VIDEO MATERIALS 51,366 62,514 66,470 66,470 295 62659 LIBRARY VIDEO MATERIALS 1,898 1,708 0 0 100 62660 DATA PROCESSING 28,936 31,033 29,276 30,413 100 62664 LICENSE/PERMIT FEES 1,790 1,481 2,202 1,501 100 62666 CREDIT CARD CHARGE 1,455 1,417 1,770 1,417 100 62667 DATA SERVICES 11,022 11,006 10,980 11,078 295 62668 PROGRAM EQUIP/SUPPLIES 4,357 4,558 4,357 4,558 100 62699 CASH SHORT AND OVER 53 22 0 0 400 62713 LEGAL SERVICES 86 0 0 0 400 62721 FINANCIAL CONSULTANT 0 152 0 0 400 62731 MISCELLANEOUS SERVICES 237 224 0 0 100 62732 TEMP HELPCONTRACT SERV. 4,780 970 17,678 28,050 100 62734 SPEAKERS/PROGRAMS 12,924 17,388 17,229 18,585 295 62734 SPEAKERS/PROGRAMS 23,647 1,547 8,000 8,000 100 62736 CATERING SERVICES 2,701 91 7,770 5,270 295 62736 CATERING SERVICES 1,886 0 2,000 2,000 100 62740 MICROFORMS 3,407 3,000 3,407 3,407 62-SUPPLIES AND SERVICES 1,073,442 1,013,036 1,128,433 1,197,754 400 62724 BOND PAYING AGENT FEE 19 10 0 0 627-CONTRACTUAL SERVICES 19 10 0 0 -41- Recommended Operating Expenditure Budget - Department Total 36-LIBRARY FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 71110 M1SC.OFFICE EQUIPMENT 769 9,544 900 5,645 295 7ll 10 MISC.OFFICE EQUIPMENT 0 2,400 750 0 100 71118 PROJECTOR/CAMERA 0 0 14,432 0 100 71120 PERIPHERALS,COMPUTER 0 0 5,500 20,390 295 71120 PERIPHERALS,COMPUTER 600 2,545 400 0 295 71123 SOFTWARE 108 0 500 0 295 7ll24 COMPUTER 1,200 0 8,000 0 295 71156 FURNITURE 2,279 800 0 0 550 7ll56 FURNITURE 1,610 0 0 0 100 71211 DESKS/CHAIRS 0 0 0 5,400 100 71212 SIDE CHAIRS 0 0 9,290 10,219 100 71215 STORAGE CABINETS 0 0 11,000 0 100 71221 CARTS 3,169 0 3,000 1,400 100 71312 VAN/PICKUP/WAG REPL 0 28,280 0 0 100 71517 LIGHTING EQUiPMENT 2,000 2,925 2,775 2,718 100 71520 HVAC 0 0 500 0 100 71550 MISCELLANEOUS EQUIPMENT 1,163 0 2,800 4,300 100 71610 CUSTODIAL EQUIPMENT 0 0 9,335 0 100 71616 SNOW BLOWER 0 0 2,800 0 100 72416 VIDEO EQUIPMENT 0 0 6,475 7,400 100 72417 CAMERA RELATED EQUIPMENT 0 0 0 9,500 100 72418 TELEPHONE RELATED 14 0 0 500 100 72421 HEADSETS 0 0 2,802 0 71-EQUIPMENT 12,912 46,494 81,259 67,472 100 73210 CONST CONTRACT-BLDG 0 13,000 0 0 73-CIP EXPENDITURES 0 13,000 0 0 400 74111 PRINCIPAL PAYMENT 236,198 285,633 211,568 217,074 400 74112 INTEREST PAYMENT 26,647 23,822 15,023 8,306 74-DEBT SERVICE 262,846 309,455 226,591 225,380 36-LIBRARY TOTAL 3,755,864 3,664,997 4,102,185 4,221,16] -42- Recommended Expenditure Budget Report by Activity & Funding Source 36-LIBRARY LIBRARY ADMIN. -36100 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget CIP EXPENDITURES 13,000 EQUIPMENT 1,700 SUPPLIES AND SERVICES 41,684 65,795 55,594 WAGES AND BENEFITS 345,209 389,940 393,559 LIBRARY ADMIN. 399,893 455,735 450,853 ADULT SERVICES -36200 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 1,000 7,600 SUPPLIES AND SERVICES 428,578 468,457 501,850 WAGES AND BENEFITS 701,849 861,499 887,957 ADULT SERVICES 1,130,427 1,330,956 1,397,407 CHILDREN SERVICES -36210 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 1,000 SUPPLIES AND SERVICES 124,199 153,579 170,706 WAGF.S AND B6NFFITS 296,088 464,956 488,189 CHILDREN SERVICES 420,288 619,535 658,895 CIRCULATION SERVICES -36220 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 9,544 9,302 1,000 SUPPLIES AND SERVICES 10,673 18,440 20,209 WAGES AND BENEFITS 447,239 437,293 512,093 CIRCULATION SERVICES 467,455 465,035 533,302 LIBRARY RENOVATION DEBT -36240 FUNDING SOURCE:DEBT SERVICE Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget CONTRACTUAL SERVICES 10 DEBT SERVICE ]07,055 19,741 19,380 SUPPLIES AND SERVICES 377 DEBT SERVICE 107,442 19,741 19,380 MAINTENANCE SERVICES -36300 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 31,205 38,500 16,937 -43- Recommended Expenditure Budget Report by Activity & Funding Source 36-LIBRARY SUPPLIF,S AND SF,RVICF,S 204,018 212,285 217,080 WAGES AND BENEFITS 150,395 165,176 158,491 MAINTENANCE SERVICES 385,618 415,961 392,508 YOUTH SERVICES -36400 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adoptcd Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 19,351 23,924 24,557 YOUTH SERVICES 19,351 23,924 24,557 LULL LIBRARY TURST -36420 FUNDING SOURCE: LIBRARY GIFTS TRUST Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 21,807 39,445 SUPPLIES AND SERVICES 110,606 95,654 115,093 WAGES AND BENEFITS 183,912 311,179 288,773 INFORMATION TECHNOLOGY 294,518 428,640 443,311 GENERAL GIFT TRUST -36480 FUNDING SOURCE:EXPENDABLE LIBRARY GIFTS Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 5,745 9,650 SUPPLiES AND SF,RVICF,S 21,516 29,248 30,496 GENERAL GIFT TRUST 27,261 38,898 30,496 WALTON PRESERVATION TRUST-36490 FUNDING SOURCE:EXPENDABLE LIBRARY GIFTS Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT - SUPPLIES AND SERVICES 776 776 WALTON PRESERVATION TRUST - 776 776 JAMES MUTSCHLER TRUST -36496 FUNDING SOURCE:EXPENDABLE LIBRARY GIFTS Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAC'rES AND BENEFITS 34,782 33,371 56 JAMES MUTSCHLER TRUST 34,782 33,371 56 TECHNICAL SERVICES -36500 FUNDING SOURCE: EXPENDABLE LIBRARY GIFTS Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 4,322 4,357 4,322 SPACE MAKER OPERATIONS 4,322 4,357 4,322 -44- Recommended Expenditure Budget Report by Activity & Funding Source 36-LIBRARY EQUIPMENT 0 0 790 SUPPLIES AND SERVICES 47,712 55,918 57,071 WAGES AND BENEFITS 123,528 2,488 1,437 TECHNICAL SERVICES 171,240 58,406 59,298 LIBRARY RENOVATION DEBT -36600 FUNDING SOURCE:DEBT SERVICE Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget DEBT SERVICE 202,400 206,850 206,000 LIBRARY RENOVATION DEBT $ 202,400 $ 206,850 $ 206,000 LIBRARY TOTAL $ 3,664,997 $ 4,102,185 $ 4,221,161 -45- CITY OF DUBUQUE , IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 36 LIBRARY DEPARTMENT FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 8200 GE-41 LIBRARY DIRECTOR 1.00 $ 118,230 1.00 $ 120,758 1.00 $ 115,337 100 8100 GE-34 LIBRARIAN II 2.00 $ 160,931 2.00 $ 162,679 2.00 $ 169,614 100 GE-33 LEADAPPL/NETWORKANALY 1.00 $ 75,252 1.00 $ 77,143 1.00 $ 79,653 100 8020 GE-32 LIBRARIAN I 4.00 $ 288,187 4.00 $ 294,093 4.00 $ 301,602 100 GE-33 CIRCULATION MANAGER 1.00 $ 69,001 1.00 $ 74,507 1.00 $ 80,441 100 7900 GE-30 LIBRARYAIDE 7.00 $ 438,156 7.00 $ 438,334 7.00 $ 453,817 100 475 GE-30 ADMINISTRATIVE ASSISTANT 1.00 $ 65,960 1.00 $ 67,029 1.00 $ 69,792 100 2200 GE-27 MAINTENANCE WORKER-LIBRARY 1.00 $ 55,693 1.00 $ 56,503 1.00 $ 58,334 100 GE-27 MAKERSPACE ASSISTANT - $ - - $ - 1.00 $ 58,334 100 1400 GE-25 CUSTODIAN-LIBRARY 1.00 $ 50,028 1.00 $ 6,132 1.00 $ 42,122 100 3345 GE-29 USER SUPPORT SPECIALIST 1.00 $ 59,016 1.00 $ 50,356 1.00 $ 54,836 TOTAL FULL TIME EMPLOYEES 20.00 $1,380,454 20.00 $1,347,534 21.00 $1,483,882 61020 Part Time Employee Expense 100 8020 GE-32 LIBRARIAN I 0.07 $ 4,162 0.07 $ 3,996 0.07 $ 4,114 100 7900 GE-30 LIBRARYAIDE 1.69 $ 88,451 1.69 $ 90,531 1.69 $ 99,031 100 1400 GE-25 CUSTODIAN-LIBRARY 0.13 $ 5,844 0.13 $ 50,752 0.13 $ 6,464 100 GE-27 LEAD LIBRARYASSISTANT 0.63 $ 30,205 0.63 $ 31,347 0.63 $ 34,805 100 7850 GE-25 LIBRARYASSISTANT 7.30 $ 313,536 7.30 $ 324,042 6.30 $ 282,263 100 GE-25 CONFIDENTIALACCOUNT CLERK 0.63 $ 27,417 0.63 $ 28,095 0.63 $ 29,270 100 NA-38 INFORMATION SERVICES INTERN 0.50 $ 13,718 0.50 $ 13,926 0.50 $ 14,376 100 NA-28 CLERICALASSISTANT 0.25 $ 6,713 0.25 $ 6,812 0.25 $ 7,031 100 7750 NA-24 LIBRARY CLERK 3.95 $ 86,437 3.95 $ 87,462 3.95 $ 89,964 TOTAL PART TIME EMPLOYEES 15.14 $ 576,483 15.14 $ 636,963 14.15 $ 567,318 61020 Part Time Employee Expense 295 MARKETING COORDINATOR 0.50 $ 34,650 0.50 $ 28,439 - $ - TOTAL PART TIME EMPLOYEES 0.50 $ 34,650 0.50 $ 28,439 - $ - TOTAL LIBRARY 35.65 $1,991,587 35.65 $2,012,936 35.15 $2,051,200 -46- 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 Library Administration-FT 10036100 61010 100 8200 GE-41 LIBRARY DIRECTOR 1.00 $ 118,230 1.00 $ 120,758 1.00 $ 115,337 10036100 61010 100 GE-30 LIBRARYAIDE 1.00 $ 67,241 1.00 $ 68,249 1.00 $ 70,463 10036100 61010 100 475 GE-30 ADMINISTRATIVE ASSISTANT 1.00 $ 65,960 1.00 $ 67,029 1.00 $ 69,792 Total 3.00 $ 251,431 3.00 $ 256,036 3.00 $ 255,592 Library Administration-PT CONFIDENTIAL ACCOUNT 10036100 61020 100 3,300 GE-25 CLERK 0.63 $ 27,417 0.63 $ 28,095 0.63 $ 29,270 10036100 61020 NA-28 CLERICALASSISTANT 0.25 $ 6,713 0.25 $ 6,812 0.25 $ 7,031 Total 0.88 $ 34,130 0.88 $ 34,907 0.88 $ 36,301 Adult Services-FT 10036200 61010 100 7900 GE-30 LIBRARYAIDE 3.00 $ 194,199 3.00 $ 200,197 3.00 $ 199,301 10036200 61010 100 8020 GE-32 LIBRARIAN I 4.00 $ 288,187 4.00 $ 294,093 4.00 $ 301,602 10036200 61010 100 8100 GE-34 LIBRARIAN II 1.00 $ 80,159 1.00 $ 80,534 1.00 $ 84,807 Total 8.00 $ 562,545 8.00 $ 574,824 8.00 $ 585,710 Adult Services-PT 10036200 61020 100 8070 GE-32 LIBRARIAN I 0.07 $ 4,162 0.07 $ 3,996 0.07 $ 4,114 10036200 61020 100 NA-24 LIBRARY CLERK 0.38 $ 8,410 0.38 $ 8,529 0.38 $ 8,807 10036200 61020 100 7900 GE-30 LIBRARYAIDE 1.00 $ 51,109 1.00 $ 51,104 1.00 $ 58,539 Total 1.45 $ 63,681 1.45 $ 63,629 1.45 $ 71,460 Youth Services-FT 10036210 61010 100 8100 GE-34 LIBRARIAN II 1.00 $ 80,772 1.00 $ 82,145 1.00 $ 84,807 10036210 61010 100 7900 GE-30 LIBRARYAIDE 3.00 $ 176,716 3.00 $ 169,888 3.00 $ 184,053 Total 4.00 $ 257,488 4.00 $ 252,033 4.00 $ 268,860 Youth Services-PT 10036210 61020 100 7900 GE-30 LIBRARYAIDE 0.69 $ 37,342 0.69 $ 39,427 0.69 $ 40,492 10036210 61020 100 7750 NA-24 LIBRARY CLERK 2.57 $ 56,588 2.57 $ 57,014 2.57 $ 58,477 Total 3.26 $ 93,930 3.26 $ 96,441 3.26 $ 98,969 Circulation Services-FT 10036220 61010 100 GE-33 CIRCULATION MANAGER 1.00 $ 69,001 1.00 $ 74,507 1.00 $ 80,441 Total 1.00 $ 69,001 1.00 $ 74,507 1.00 $ 80,441 Circulation Services-PT 10036220 61020 100 7750 NA-24 LIBRARY CLERK 1.00 $ 21,439 1.00 $ 21,919 1.00 $ 22,680 10036220 61020 100 GE-27 LEAD LIBRARYASSISTANT 0.63 $ 30,205 0.63 $ 31,347 0.63 $ 34,805 10036220 61020 100 7850 GE-25 LIBRARYASSISTANT 6.30 $ 269,218 5.30 $ 227,237 6.30 $ 282,263 Total 7.93 $ 320,862 6.93 $ 280,503 7.93 $ 339,748 Information Technology-FT 10036440 61010 100 GE-33 LEADAPPL/NETWORKANALY 1.00 $ 75,252 1.00 $ 77,143 1.00 $ 79,653 10036440 61010 100 GE-27 MAKERSPACE ASSISTANT - $ - - $ - 1.00 $ 58,334 Total 1.00 $ 75,252 1.00 $ 77,143 2.00 $ 137,987 Information Technology-PT INFORMATION SERVICES 10036440 61020 100 NA-38 INTERN 0.50 $ 13,718 0.50 $ 13,926 0.50 $ 14,376 10036440 61020 100 GE-29 USER SUPPORT SPECIALIST 1.00 $ 59,016 1.00 $ 50,356 1.00 $ 54,836 10036440 61020 100 GE-25 LIBRARYASSISTANT 1.00 $ 44,318 2.00 $ 96,805 - $ - Total 2.50 $ 117,052 3.50 $ 161,087 1.50 $ 69,212 Maintenance-FT MAINTENANCE WORKER- 10036300 61010 100 2200 GE-27 LIBRARY 1.00 $ 55,693 1.00 $ 56,503 1.00 $ 58,334 10036300 61010 100 1400 GE-25 CUSTODIAN-LIBRARY 1.00 $ 50,028 1.00 $ 6,132 1.00 $ 42,122 Total 2.00 $ 105,721 2.00 $ 62,635 2.00 $ 100,456 -47- 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 Maintenance-PT 10036300 61020 100 1400 GE-25 CUSTODIAN-LIBRARY 0.13 $ 5,844 0.13 $ 50,752 0.13 $ 6,464 Total 0.13 $ 5,844 0.13 $ 50,752 0.13 $ 6,464 James Mutschler Trust-PT 29536496 61020 295 MARKETING COORDINATOR 0.50 $ 34,650 0.50 $ 28,439 — $ — Total 0.50 $ 34,650 0.50 $ 28,439 — $ — TOTAL LIBRARY DEPARTMENT 35.65 $1,991,587 35.65 $2,012,936 35.15 $2,051,200 -48- Capital Improvement Projects by Department/Division LIBRARY CIP FY 19 Actual FY 20 Actual FY 21 Adopted FY 22 Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 1022652 LIBRARY GENERATOR 150 1022712 REPLACE WATER LINE LIBRAR 48,667 115,671 71,835 — 3501187 LIBRARY ROOF REPLACEMENT 3501681 REPLACE SIDEWALK&STEPS 40,953 3501787 LIBRARY HVAC MAINT 3,455 3502006 LiBRARY LANDSCAPING 100,202 3502521 HVAC HANDLING LTNITS 3502712 REPLACE WATER LINES 26,033 25,367 3502743 LIMESTONE OVERHANG E&R 1,500 8,420 3502835 UNDERGROUND TANK LIBRARY 59,379 LIBRARY TOTAL 117,303 152,913 231,416 0 -49- This page intentionally left blank. -50- -_�� _ � :�_ +�1 " � � , � � � r 1 1 � � �.� � � ��° .��"� � � r`'. 5 � , � � . • � � � � t �. � �:� � /- � � j� � � ► �� .�- � ' ,F 0 � - ; ., '..9�' Y�..r , � ` ` �. � � � �/ � _ I � � � .��' /� `\ \• �:arneaie-5tout I� unlic Linrary The mission of the Carnegie-Stout Public Library is to improve the qualit of life by y providin resources for individual g enjoyment, enlightenment, knowledge, and that en hance the I iterac of outh . y v i � � ' � � � � i � � i � Library Board of Trustees . . � . . . Adult Information Materials Technolog cquisition & Building Maintenance & Material Youth Services Distribution of Materials heck-O Services Services essing Services � F�EATI IV � �I� * . . . . AHr�h-P�rf�r�a�� Dr��rr�t�an �a�rd ��m�u�r�#�� tl��t �s E � I T�� L E ��-Dri�r�r� �r�� ut��n��F��used �u��t �r� ��r� #��r pillar� �f: �� I� - . � � F � �I �I� E . . t � • • � . • � � � - { � __ _ _ � - •_ "�• . _ , � t , ,_ }�� _ �' � �_ _ � r * FISCAL YEAR HIGHLIGHTS �� T V ! 4 i • Vis it�rs 'I �� 4�3 � • � ard Hold+� rs 4� 'I �� • � ollection Use �� 4 � • Sto V11alk Bee Branch � re� k � reenwa rY Y .� FISCAL YEAR HIGHLIGHTS T � � � . � � � �� ut� �� t� � � � � m �teri � l � • 'I � � � item� a � �� to th � 8 � �� Ile �ti � n • N �� t� l � t� e�se �tr� n � se� r� l� i r� �f I i br� m �t� rials FISCAL YEAR HIGHLIGHTS . 1) The last thing he tald me: a nvvel T � � � .� AslihOf Ddve,Lu_.'�� $NfiBB RCeSe s�c'�"''---` Pub.Date �c�� . •' Lar►guege Erigl�� Appears on these I�sts Kelly Franco�s Favvr�tes � wYT-Auriio Fiction :'r'T-Corrk�ir�ed Print&E-Rook Fiction ��,�~ 43:..z�- --. -•' f� •��y F ♦ •.� � F :t�: l � :}' • 1 ." . . - - ShOvr Edition . ��-- �•--.��t Shovr Edition � � • Preview Fram the baok � F' � - Shas•r Edrtian Adult CD Audioboois- CD Audio � _ F :�,: , � — Public 5helvirly ; Book . U�r�Dus � 3;a:lablY Fictior� I 5hovr Edition �on thevvait l.-t � • � Fo r m a t s �� Preview Fram the �� ,,. � . . . � _ =.hovr Edi:icn •- . ..... .. . ... . . .. . � � r :..: � � Previevr Part 1 � � Show Edition - � 'Before Owen�A�chaels disappears.he smugg[es a rsote to n�s i�eloved w�`e of orie y�ar,Protect he:. Despite her cnnfus�on and fear.Ha nnah Hall knows exact[y to vvhom the note refers-O�ven's sixteen-year- �" Ava i I a b i I i ty �� ald daerghker Bailey.9ailey.who lost her mother tragically as a�hild.Bailey.who wants aGsolutely notheng o�.-� �;,t��..��.;,��...nt'wr r:_•Ftn^�� ,_.Fa��[;:��=�r�t��nl[�}�n...�;an :��a'is1:��.a�t�e �EI�. --•- -••_-.-�--- 3=aU`��^:�•_ .... SHARE �� 7 FISCAL YEAR HIGHLIGHTS �� T � s a i • 224 Pro rams for auth � v • 57 Pr� rams for adults � • 5 �D� Attendan �e t� all � prog rams • Diversit aud it �f I i bra y �v �o � � ection � - � FY21 Collection Use : - - � 662,554 ■ ■ . . . - . - ■ Print Materials � � � � • � � ■ Videa ��VD & Blu-rays� 1 111 • • • - - • � ■Audia Baaks & Music , � � ■ �igital materials �e-Boak, e-Audia, � • • • • � • streaming uidea, magazines� � � • • • • • ■ Retrieval electranic infarmatian �database use� � flther items �cake pans, games, � i • • . ' • � � equipment) � � � FISCAL YEAR HIGHLIGHTS 13% u nder bud et* � � � � � g FY �1 Librar� Expenditures � ■ St�ffing C��s ■ �perations � Materials *Frozen budget lines impacted primarily operations and staff expenditures � E�� i r� �� r r� � �� T�� r�� i � ��I � �� E��i �� i I ��i�� i ��a I ��i�r� �� r�� I� �� i �� r� �� I �-�� a� i�� I�� I�I ��i � � �� x�� i � �� x�� T�� I ��x�� 1� � � �� r� � r� i�� F�� I � i��r�i �� I� � � I � # I I� �r�� r� � � � �� I � � � � �� r� � � �� I� � �I� �� I� � � �� I � �� li � r�� r� �� r�� I� � � i �l��ir�� l li � r�� r� � r� �� r � I�� I I �� i� r�� i I� l� I� f� r� � F��I� � �� 1�1�r�� r-� �� r� I�i�� r�� I� i�� r� � ��! �i -Fi H�� Il��i � r� �� il � � l � f� r� �l� �� l� � �� • All hours curbside pick-up of librar y materials � � • Transition to virtual Stor times and y other programming , video recordings , podcasting , etc. • � . . • Take-and-make crafting and stem kits • Expanded outdoor youth programming at various Dubuque locations • " Programs to People" grant provided by DRA and C-SPL Foundation FUTURE . . - • . , , ,- , �__� � � � / . - o a � � Partnership with Dubuque Arboretum and Botanical Gardens ■ ■ �� p 5 �.Ji"l� ti�'s' * 'S, � f�i,�. �'l4:�;`�'}� +F� •�•-•_} ��y,,'�.f/ t i'�';�>�` �:�"#r 'fi: _' 'ud,.� . L: '1";�ii'+t�, `� ' • _ �,�..;.{ . - �:�1. '�'��` �•�..,:�,._e�,. ' �}�' �` ':,Y:�r.. �`_ _"��:=Rr.� ��' +�„ . ' ,�,�d� .r.ti�`��... }' ,�:. ryy_�',}'..•, �-`.,z;��Y:}} . ' G�"�-:r,`�-��•t3�'�'..• .tz r� }s` " .�T { ��ir'' . . �_�� _n . {,;�',i�,f.: Ir . ' - � '�"',�� ,_. .x' +� �' I y �-4 �."w'�'J��}'��`_�{ �ij�'� �'��'_'w�' _ Y�_ �t '��}+`�`r:+_;� . _. �t��t..:N .*a�-, i -:4. _7,r•,� '��I�h�-��k.. . .�, , � . . � �� A��s'�� } � '� .. �f_ .. �, , r- _ k, ' �4��' s• :.r� d � ��r�kiN•� - �� ' T� � �- F� _} :_.�'�' ''� I� � ` - • - .. * _��.. -1 . + ;._y�. t� '�.� � �. � ..��.+r1��~ ' �'}'Y`�( w+�{��Y 'sz� ..��' ��} �'f"_i �' �r.�i' ".�.`�'[tF'�� ' .�.-. ..'*� � � + - � � "4" 5 .� ��+M`i }�;•y�••''S+�l+ � — ?�� .� � ' �� y- 4 ' - ' '• - ,}- �� . � � `�:`�s— . . r� r •� ,'k•� - ';��`'`i��`+�4+, �3 �p��...��.�� ',M1 ., '_� ''Lrt` 'R Y�' v � �+� . � . �5- �'1'•�y� —�. ;� . :.,�#?�-•'— .-r.;.�: ��'�?�1'iFr- yi y,� }'�,k.,.,,�-y��'`::��a - :x�w ' i�€��'� -' -,;�:.'.��Ft �l' R. 'L^�,;.�.� .�. a4 _ _:�ti�*r.+M1k ' . 5._ _ _�Y ��t5��tv�' :y�.� yi t�' -~ ..,. . -� � ._ -., r• Y }`�x�: ': _ ,.(� . . +��.,��;!°�� •��.' �� ...��.��"�'"r~ -_�``- �� '" :��;�'�_4.x��.�y�,. {!'��:1 �.�,-�4' ��' �� 'i' � "�t''�d�'•,� .'i"R�r,'�;til�.� �,ju.` �.� ��*�� ~?'. � � � 'v f�"�._-�� r y r� ��f'�:�.r,',�'R:. y�'or:'_ .:.�'�$`� w,° '�i."'�i�`_�r��``� � .{e`�-tti-.:S�'r+i�'t,'�-- � J.. �' „n._ '��j - _ �x#'�'*�,#� Y 'f'+c.,yli-a�•s4�'fid-�r� _ k'i. o.+�.. -_ .� x�.ti�r ' Af{. f�' �a: �y.�.� ��,�.�^�`�:" ��'�.. . �:�.._�}.��?;� r��' _ �-��r��r' '.` ,`�`Y','^�h6"_ i' �" �+ �Yt_' �,�-_;1 . • . .'�'�. ,�.*"� :.'.`.�:yB•'"�� •} ��` •:�.2.•:�, . � - �. �s,��' �: , . . . �.�,� {�� n r - + "'.�r'� 1cti� �}3�i+�e.`3tiftT . ' • ' • � • • . 1 � , � � • � � � ■ � • � � - - 3 906 770 58 . 16 � � � * 1 109 732 Average homeowner s � � Net Property ro ert tax cost for Carne ie- Libra Gift Trusts' p p Y J rY Tax Support Stout Public Libra Balance rY (*Avg. home value of $159,503) Restricted G ift Trusts U n restricted G ift Trusts _ �� i;A,�7��. � James . � � sE��r.f:TGr�n�, � .. �. , Lacy Book M utsch ler Trust - Trust - -�� Educated $g67 975 �� A MEMOIR ■ � ' �� $13,366 f� �",�f� � ��, �'� 'i� � _ `�Y. � � �'[' r �� .. '.:\ ':: .. .. . .. . .. � � Walton Trust � �� . � �� 7 429 � _�-. ..� . ,� $ , � ,s _ _ ;� .�...�,:. . , ,� L u I I A rt x - . � �,-_ _�ti�� :` i��- � ��...�_ �� :`� �`" Trust � �^ � � � -- . � �: _ �`� :�. � -, . � �'+ ' � �� '� Carnegie-Stout � � � $5 097 � - � � ¢�� .� � � � -� {�� General Libra PUBLIC LIf3RARY ��r„- . :_ .�- �.•�- � �- =� �--#--T;�� &'The Frie�cls of'thil I_ihrar`� - 'r_:�` _ r q+�� ' y - _ �� I � J „ ' _ ��' �`�, �� Trust OiIBl7QVERACiNGASSOC��TIOr+ �. r: . $136,059 -�-�-�-_ - � � �� , �� :��;�� : . ., . „^.:.�>.��;�� r , U n restri cted General Gift Trust • State Funds (Materials = - • • enhancements) $13,404 = - - - '� • � ' • Strategic Plan $ 13,000 • Art appraisal/conservation $12,994 • - • ' • - • Foundation Grants $9,034 • '� • � � • • Informational databases $3,340 • Changing Lives Through Literature • • = - - - Grant $ 3,635 '� • � • • Marketi ng $2, 150 • Art �� yo u r I i b ra ry $ 1 ,346 • Youth summer reading $2,206 • G ivi n g Tree $828 � Re u est 61 724 f o r q � I m rove m e n ts - - • p . � ��. Request funding for: f • Full -time MakerS ace Lead p T � � � i Libra Assistant � • Part-time Marketing Coordinator � Full -time MakerS ace Lead p Libra Assistant - - • rY . � Related cost: $26,420 ��. Property tax impact: $0.032 f • Enable MakerS ace to have more p T � � � i robust pro rammin , includin g g g outreach • Better training on highly technical equipment � Part-ti me Marketi n Coord i nator g � • Related cost: $35 304 � ' �' Property tax impact: $0.0139 �� • Create a re ular osition , for oin f J p J J a temporary contract T � � � . • Conti n uous promotion of I i brary services, programming , and activities Carnegie-Stout Public Library PERFORMANCE MEASURES ■ ■ Youth Services • # of prog rams provided to area ch i Id care centers through AmeriCorps �� • # of prog rams provided for Leadersh i p EnrichmentAfter School Program ( LEAP) ��o��o, • # of Children 's items checked out 147,� � , Carnegie-Stout Public Library PERFORMANCE MEASURES ■ ■ Adult Services • # of electron ic i nformational resou rces accessed L r • # of check outs of di ital materials 109 , 872 g • # of attendees to programs ,� • # of programs held for adults 57 Carnegie-Stout Public Library PERFORMANCE MEASURES ■ ■ Materials Checkout & Distribution • # of items in collection for checkout � 83 , 553 • # of re istered borrowers as a % of popu lation 69 g • # of deliveries to home bound residents �47 • # of issues of TH newspaper archives viewed � �� R�n https://carneg iestout.org/