The URL can be used to link to this page

Carnegie-Stout Public Library FY22 Budget Presentation Copyrighted March 4, 2021 City of Dubuque Public Hearings # 3. Special Meeting ITEM TITLE: Carnegie-Stout Public Library FY22 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Carnegie-Stout Public Library FY22 Policy Budget Supporting Documentation Outline UPDATED 3/4/21 Budget Presentation_UPDATED 3/4/21 Supporting Documentation Library -39- This page intentionally left blank. -40- LIBRARY DEPARTMENT FY 2020 FY 2021 FY 2022 Fro�m FY 021 Budget Highlights Actual Budget Requested Budget Expenses Employee Expense 2,406,645 2,584,493 2,665,902 3.1% Supplies and Services 1,073,461 1,119,611 1,128,433 0.8% Machinery and Equipment 12,912 77,720 81,259 4.6% Subtotal 3,493,018 3,781,824 3,875,594 2.5% Debt Service 262,846 223,463 226,591 1.4% Total Requirements 3,755,864 4,005,287 4,102,185 Resources Library Gift Trusts 138,749 80,364 77,402 -3.7% Sales Tax 20% for Debt Abatement 19,725 21,063 19,741 -6.3% TIF Revenue for DebtAbatement 202,800 202,400 206,850 2.2% Operating Revenue 54,142 40,125 39,805 -0.8% Total Revenue 415,416 343,952 343,798 -% PropertyTaxSupport 3,340,448 3,661,335 3,758,387 97,052 Percent Increase (Decrease) 2.7% Percent Self Supporting 2.6 % 1.6 % 1.1 % Personnel -Authorized FTE 34.14 35.14 35.14 Significant Line Items Employee Expense 1. FY 2022 employee expense reflects a 3.0% wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2021 The employee contribution of 6.29% is unchanged from FY 2021. 3. The City portion of health insurance expense increased from $1,025 in FY 2021 to $1,086 in FY 2022 per month per contract which results in annual increase of$27,016 or 5.95%. 4. 50°/o Sick Leave Payout decreased from $5,814 in FY 2021 to $3,669 in FY 2022 based on FY 2020 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 2021 to $27,299 in FY 2022. FY 2020 actual was $12,921. 6. 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. Supplies 8� Services 7. Data Processing Equipment Maintenance Contracts decreased from $98,382 in FY 2021 to $85,609 in FY 2022. FY 2020 actual was $81,023. The items included are as follows: -41- % Change Fiscal Year FY 2022 From FY 2021 Contract 2021 Budget Requested Budget Overdrive Platform for Digital Material $ 6,120 $ 6,120 - % 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) Envisionware Internet Management 3,300 3,400 3.03 % (d) VM Ware $ 4,870 $ 4,774 (1.97)% Network Support -Alpha G-Deep Freeze $ 6,936 $ 8,281 19.39 % (e) Website Maintenance $ 5,600 $ - (100.00)% (f) Infrastructure Switches Support $ 9,360 $ 10,196 8.93 % (g) Various Small Contracts $ 1,086 $ 1,086 - % Veritas Backup Solution $ 1,468 $ 145 (90.12)% (h) Envisionware Credit Card Fees $ 1,188 $ 1,188 - % Meraki Wireless Gateway $ 1,818 $ 2,200 21.01 % (i) GoToMyPC License $ 75 $ 700 833.33 % (j) Total $ 94,654 $ 85,609 (12.98)% (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) Envisionware Internet Management increase due to mobile printing. (e) Network Support -Alpha G-Deep Freeze due to initial sign on discount expiring and additional licenses purchased to meet demand. (f) Website Maintenance contract was discontinued and maintenance is now being done by City staff. (g) Infrastructure switches support increased due to quoted cost to support SAN replacement. (h) Veritas Backup Solution decreased based on savings from available discount. (i) Meraki Wireless Gateway increase due to two additional AP licenses purchased to support additional Wi-Fi access points in the Library. (j) GoToMyPC License increase due to staff working from home in response to the Coronavirus and consequent facility closures. 8. Office Supplies decreased from $18,917 in FY 2021 to $18,746 in FY 2022. Based on FY 2021 Adopted Budget. 9. Postage increased from $19,362 in FY 2021 to $19,749 in FY 2022 based on FY 21 budget plus 2.00%. 10. Electricity increased from $64,897 in FY 2021 to $83,217 in FY 2022 based on FY 2020 actual $79,254 plus 5%. -42- 11. Gas increased from $23,363 in FY 2021 to $24,906 in FY 2022 based on FY 2020 actual $24,906. 12. Speakers and Programs unchanged from $17,229 in FY 2021 to $17,229 in FY 2022 based on FY 2021 Adopted Budget. 13. Property Maintenance decreased from $33,812 in FY 2021 to $30,793 in FY 2022 based on FY 2020 plus 5°/a 14. HVAC Maintenance increased from $19,127 in FY 2021 to $22,918 in FY 2022 based on FY 2020 actual. 15. Library Video Materials unchanged from $66,470 in FY 2021 to $66,470 in FY 2022 based on FY 2021 Budget. 16. Data Processing increased from $28,049 in FY 2021 to $29,276 in FY 2022 based on FY 2020 actual $28,936 plus 1%. 17. Online Information Service decreased from $53,494 in FY 2021 to $52,262 in FY 2022 based on FY 2020 actual plus 6.2% (Library Trade Almanac). 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." 18. Library materials, excluding materials purchased by Library trust funds, increased from $420,895 in FY 2021 to $426,214 in FY 2022. Library materials are budgeted as follows: Change Fiscal Year Fiscal Year From FY FY 2020 2020 2021 FY 2022 2021 Library Materials Actual Budget Budget Requested Budget Books $ 191,803 $ 202,276 $ 213,639 $ 213,639 - % Book Club $ 2,958 $ 2,114 $ 2,135 $ 2,135 - % Audiobooks $ 77,911 $ 71,580 $ 81,557 $ 82,368 0.99 % e-Books $ 51,101 $ 46,083 $ 51,792 $ 52,223 0.83 % Continuations $ 11,989 $ 33,187 $ 33,776 $ 35,677 5.63 % Periodicals $ 37,294 $ 35,979 $ 37,996 $ 40,172 5.73 % Total 373,056 391,219 420,895 426,214 1.26 % 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 and School Library Journal publishes a library materials price index each year. The library evaluates the information and selects the increase/decrease that is the lowest of the two indexes depending on whether the price is associated with Adult, Children's or the Teen collection. In planning for Fiscal Year 2022, hardcover books are projected to increase .9%, mass market paperback books are projected to increase 2.5%, trade paperback books are projected to decrease 15.6%, library binding is projected to increase 25.74%, e-Books are projected to increase .4%, CD audio books are projected to increase 1.6%, serials/continuations are projected to increase 6% to 6.2°/o, periodicals are projected to increase 6.7%, and graphic novels/comics are projected to decrease 3.08%. 19. General Library Trust expense decreased from $80,364 in FY 2021 to $77,402 in FY 2022. The balance of the Expendable Library Gift Trust Fund as of October 31, 2020 was $1,154,822. The breakout of the balance by each Expendable Library Gift Trust Fund is as follows: -43- 10/31/2020 Library Gift Trust Balance General Gift Trust $ 142,969 Walton Gift Trust $ 7,376 Maker Space Gift Trust $ 3,126 Mutschler Gift Trust $ 1,001,351 Total $ 1,154,822 Library Trust expenses budgeted include: Library Trust Fund Budget FY 2021 FY 2022 Part-Time Marketing Coordinator $ 40,600 $ 33,300 * Workers Compensation $ 78 $ 71 Office Supplies $ 657 $ 500 Printing & Binding $ 2,305 $ 1,276 Copying $ - $ 800 Program Supplies $ 5,500 $ 4,357 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 $ 3,000 $ 4,000 Contractor Services $ 5,000 $ - Office Equipment $ - $ 750 Tablet $ - $ 400 Software $ - $ 500 Computer $ - $ 8,000 Catering $ 2,000 $ 2,000 Sales Tax $ 224 $ 448 Total $ 80,364 $ 77,402 * Part-time Marketing Coordinator is a two-year position thru Fiscal Year 2021. After Fiscal Year 2021, a decision will need to be made in regard to the part-time position. Machinery & Equipment 20. Equipment replacement items include ($81,259): Administration Carts $1,000 Children Services Carts (3) $ 1,000 Circulation Services Self Check Machine $ 5,500 Book Carts (9) $ 1,000 Telephone Headsets (6) $ 2,802 Information Technoloav Security Cameras (7) and DVR $ 6,475 -44- Projector with Creston Panel $ 14,432 Coin Op - Copy Machine $ 900 Maintenance Services Carpet Cleaner $ 735 Riding Vacuum $ 8,600 Lighting Equipment (151) $ 2,775 Sump Pump $ 500 Water Cooler $ 2,800 Snowblower $ 2,800 Book Drop Boxes (4) $ 11,000 Side Chairs $ 9,290 Gift Trust Computer/Software/Construction $ 9,650 Total Equipment $ 81,259 Debt Service 21. FY 2022 annual debt service includes the following ($226,591) Final Call Amount Debt Series Source Purpose Payment Date $ 206,850 2016B GDTIF Library Renovation 2023 2023 $ 4,326 2019C Sales Tax 20% Library Improvements 2022 2022 $ 15,415 2012E Sales Tax 20% Library Improvements 2027 2019 $ 226,591 Total Library Annual Debt Service Revenue 22. Book Fines increased from $400 in FY 2021 to $600 in FY 2022. This line item represents reserved items not picked up ($0.50 fine) and fines for items returned through the book drop that must be returned to a Library Clerk. 23. Nonresident Fees decreased from $19,000 in FY 2021 to $18,000 in FY 2022 based on State legislature limits. Miscellaneous 24. The Library is 1.1% self-supporting in FY 2022 as compared to 1.6% self-supporting in FY 2021. -45- This page intentionally left blank. -46- 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 and 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. -47- CARNEGIE-STOUT PUBLIC LIBRARY FY 2020 FY 2021 FY 2022 Full-Time Equivalent 34.14 35.14 35.14 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 2020 FY 2021 FY 2022 The Carnegie-Stout Public Library is supported by 35.14 full-time equivalent employees, which accounts for 64.99% of the department expense as seen below. Overall, the department expenses are expected to increase by 2.42% in FY 2022 compared to FY 2021. Expenditures by Category by Fiscal Year $2,406,645 Employee Expense $2,584,493 �$2,665,90� $1,073,461 Supplies and Services $1,119,611 $1,128,433 $12,912 Machinery and Equipment $77,720 $81,259 $262,846 Debt Service $223,463 $226,591 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 FY 2020 FY 2021 � FY 2022 -48- 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 2021 FY 2022 FY 2020 Actual Budget Requested Expenditures $1,337,384 $1,739,105 $1,786,691 Resources $12,138 $1,400 $2,375 Adult Services Position Summary FY 2022 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 CLERICAL ASSISTANT 0.25 Confidential Account Clerk 0.63 Total FT Equivalent Employees 12.95 Performance Measures � Activity Objective: Provide users with convenient access to information, services, and entertainment through technology. Performance FY 2018 FY 2019 FY 2020 FY 2021 Performance Measure (KPI) Target Actual Actual Actual Estimated Indicator #of electronic informational g5,000 74,849 85,873 95,000 100,000 �� resources accessed Total internet and 108,000 105,085 107,583 108,000 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. % increase in check out of digital materials r�� (e-boOks, e-audio, 25% 22% 55% 15% 20% L streaming video, music) #of attendees to 4,600 3,350 4,604 4,300 2,500 � programs #of programs held for 130 123 138 136 45 � adults -49- 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 2020 Actual FY 2021 Budget FY 2022 Requested Expenditures $475,628 $616,364 $619,535 Resources $0 $0 $0 Youth Services Position Summary FY 2019 Librarian II 1.00 Administrative Assistant 1.00 Library Assistant 0.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 2018 FY 2019 FY 2020 FY 2021 Performance Actual Actual Actual Estimated Indicator #of children's items checked out 145,000 137,607 139,870 145,645 72,500 � #of young adult materials checked out 13,500 13,018 11,072 13,000 6,500 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 208 165 150 45 a centers through Americorps #of programs delivered for Leadership 24 12 21 24 0 C�� Enrichment After-School Program (LEAP) -50- 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 2021 FY 2022 FY 2020 Actual Budget Requested Expenditures $795,143 $884,560 $880,996 Resources $42,004 $38,725 $37,430 Materials Check-Out Position Summary FY 2022 Circulation Manager 1.00 Library Lead Assistant 0.63 Custodian - FT 1.00 Custodian-PT 0.13 Clerical Assistant 0.25 Library Assistant 5.30 Library Clerk 1.00 Total FT Equivalent Employees 9.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 2018 FY 2019 FY 2020 FY 2021 Performance Actual Actual Actual Estimated Indicator #of items available for library users 255,000 239,985 254,057 255,000 270,000 [�� #of registered borrowers (as % of 41,000 41,068 44,205 41,000 42,000 [y� population) (71%) (71%) (77%) % of checked out items returned late 18% N/A 19% 20% 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 g 13 9 9 9 � care facilities #of deliveries to homebound residents 170 N/A 128 158 165 �� 3 Activity Objective: Provide users with access to a wealth of current information. #of times visitors accessed informational g0,000 74,849 85,873 90,000 100,000 �� databases #of issues of archived Telegraph Herald 167,000 118,000 163,000 167,000 169,000 �� newspapers viewed -51- 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 2021 FY 2022 FY 2020 Actual Budget Requested Expenditures $724,002 $437,664 $487,046 Resources $0 $0 $0 Information Technology Services Position Summary FY 2022 Lead Application Network Analyst 1.00 User Support Specialist 1.00 Maintenance Worker 1.00 Librarian I 0.00 Library Assistant 0.00 Library Aide- FT 0.00 Library Aide- PT 0.00 Library Clerk 0.00 Information Services Intern 0.50 Total FT Equivalent Employees 3.50 Performance Measures � Activity Objective: Provide users with convenient access to information, services, and entertainment through technology. Performance Measure(KPI) Target FY 2018 FY 2019 FY 2020 FY 2021 Performance Actual Actual Actual Estimated Indicator #of one-on-one technology-based g0 N/A 70 156 60 �� classes offered #of technology troubleshooting sessions 225 N/A 223 66 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! -52- Recommended Operating Revenue Budget - Department Total 36-LIBRARY FYl9 Actual FY20 Actual FY21 Adopted FY22 Recomm'd Fund Account Account TiUe Revenue Revenue Budget Budget 295 43110 INVESTMENT EARNINGS 19,590 21,743 0 21,743 550 43110 INVESTMENT EARNINGS 324 361 0 361 43 USE OF MONEY AND PROPERTY-Total 19,914 22,104 0 22,104 100 46115 COUNTY PAYMENT-LIBRARY 2,324 0 2,300 2,300 46 LOCAL GRANT AND REIMBURSE-Total 2,324 0 2,300 2,300 100 51921 INTERLIBRARY LOAN FEES 3,909 10,246 2,220 2,330 100 51922 NONRF.SIDF.NT FEF.S-LIBRARY 19,668 14,835 19,000 18,000 100 51924 RESIDENT FEES-LIBRARY 684 732 300 400 295 51949 ART FEES 7,013 8,976 0 7,536 100 51953 MEETING ROOM FEES 3,447 3,077 3,447 3,600 100 51981 COPY SERVICE CHARGES 11,885 8,525 12,000 L2,000 51 CHARGES FOR SERVICES -Total 46,606 46,391 36,967 43,866 295 53103 CONTRIBUTiONS 467 460 0 460 100 53201 REFLTNDS (122) 4,912 180 475 295 53201 REFiJNDS 105,084 98,997 0 300 550 53201 REFUNDS 65 158 0 158 100 53406 BOOK FINES 47,463 11,319 400 600 100 53605 MISCELLANEOUS REVENUE 278 339 278 100 ]00 53620 REIMBURSEMENTS-GENERAL 9 156 0 0 53 MISCELLANEOUS -Total 153,244 116,341 858 2,093 400 54210 GO BOND PROCEEDS 395 38,900 0 0 400 54220 BOND DISCOUNT 18 1,762 0 0 54 OTHER FINANCING SOURCES -Total 413 40,662 0 0 400 59240 FR DOWNTOWN TIF 203,050 202,800 202,400 206,850 400 59350 FR SALES TAX CONSTRUCTION 21,112 19,725 21,063 19,741 59 TRANSFER IN AND INTERNAL -Total 224,162 222,525 223,463 226,591 LIBRARY -Total 446,663 448,023 263,588 296,954 -53- Recommended Operating Expenditure Budget - Department Total 36-LIBRARY FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-T1ME EMPLOYEES 1,252,971 1,258,217 1,360,105 1,392,154 100 61020 PART-TIME EMPLOYEES 547,ll0 539,610 567,916 592,343 295 61020 PART-TIME EMPLOYEES 8,867 26,437 34,650 28,439 100 61030 SEASONAL EMPLOYEES 16,046 14,921 0 0 100 61050 OVERTIME PAY 18,262 12,921 27,299 27,299 100 61083 COVIDI9 EMP NON-WORK 0 10,694 0 0 100 61091 SICK LEAVE PAYOFF 1,725 0 0 0 100 61092 VACATION PAYOFF 4,708 1,741 0 0 100 61095 PARENTAL LEAVE 0 7,493 0 0 100 61096 50%SICK LEAVE PAYOUT 0 3,669 5,814 3,669 100 61310 IPERS 171,366 171,331 184,202 189,084 295 61310 IPERS 837 2,496 3,200 2,685 100 61320 SOCIAL SECURITY 134,503 134,941 150,172 154,185 295 61320 SOCIAL SECURITY 678 2,022 2,750 2,176 100 61410 HEALTH INSURANCE 271,890 205,884 233,624 260,640 100 61415 WORKMENS'COMPENSATION 13,764 11,460 10,336 9,141 295 61415 WORKMENS'COMPENSATION 0 0 78 71 100 61416 LIFE INSURANCE 1,065 1,034 1,210 1,100 100 61417 UNEMPLOYMENTINSURANCE 2,316 0 1,158 1,158 100 61651 MEALS NO OVERNIGHT 0 15 0 0 100 61660 EMPLOYEE PHYSICALS 1,978 1,758 1,979 1,758 295 61660 EMPLOYEE PHYSICALS 134 0 0 0 61-WAGES AND BENEFITS 2,448,218 2,406,645 2,584,493 2,665,902 100 62010 OFFICE SUPPLIES 18,784 16,633 18,917 18,746 295 62010 OFFICE SUPPLIES 6,872 3,ll7 657 500 100 62011 UNIFORM PURCHASES 288 253 288 288 100 62030 POSTAGE AND SHIPPING 12,582 12,241 19,362 19,749 100 62031 PROCESSING MATERIALS 15,726 14,666 18,276 18,276 100 62050 OFFICE EQUIPMENT MAINT 335 369 540 574 100 62051 RADIO BATTERY/REPAIR 1,612 0 0 0 100 62060 O/E MAINT CONTRACTS 6,085 4,785 6,ll0 5,390 100 62061 DP EQUIP.MAINT CONTRACTS 80,875 81,023 98,382 85,609 100 62062 JANITORIAL SUPPLIES 4,681 4,787 4,940 4,940 100 62070 OFFICE EQUIP RENTAL 863 863 863 863 100 62090 PRINTING&BINDING 11,222 6,518 14,215 12,408 295 62090 PRINTING&BINDING 2,154 1,050 2,305 1,276 100 62091 LIBRARY BINDING 588 918 937 937 100 62110 COPYING/REPRODUCTION 6,252 6,206 6,486 6,571 295 62ll0 COPYING/REPRODUCTION 0 0 0 800 100 62130 LEGAL NOTICES&ADS 8,048 6,070 10,763 10,553 100 62140 PROMOTION 11,030 12,829 12,131 12,131 295 62140 PROMOTION 3,978 5,842 6,000 6,000 100 62190 DUES&MEMBERSHIPS 3,233 3,589 3,507 3,507 100 62204 REFLTNDS 0 287 0 0 100 62206 PROPERTY INSURANCE 23,555 25,956 24,733 30,748 100 62207 BOILER iNSURANCE 0 0 139 139 100 62208 GENERAL LIABILITY INSURAN ll,480 ll,283 12,055 12,243 295 62210 SALES TAX 224 448 224 448 100 62310 TRAVEL-CONFERENCES 11,673 11,297 16,804 18,520 100 62320 TRAVEL-CITY BUSINESS 1,617 1,096 2,356 2,356 -54- Recommended Operating Expenditure Budget - Department Total 36-LIBRARY FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 62340 MILEAGE/LOCAL TRANSP 124 235 897 897 100 62360 EDUCATION&TRAINING 8,373 7,343 13,425 13,425 100 62411 UTILITY EXP-ELECTRICITY 70,830 79,254 64,897 83,217 100 62412 UTILITY EXP-GAS 23,363 24,906 23,363 24,906 100 62421 TELEPHONE 4,467 4,106 4,467 4,119 100 62431 PROPERTY MAINTENANCE 33,812 30,793 33,812 30,793 295 62431 PROPERTY MAINTENANCE 4,479 2,315 3,000 4,000 550 62431 PROPERTY MAINTENANCE 0 150 0 150 100 62433 CUSTODIAL SERVICES 2,448 3,027 2,756 3,027 100 62434 HVAC MAINTENANCE 19,127 22,918 19,127 22,918 100 62435 ELEVATOR MAINTENANCE 2,427 2,427 2,427 2,427 100 62436 RENTAL OF SPACE 462 378 504 504 100 62511 FUEL,MOTOR VEHICLE 1,047 750 861 861 100 62521 MOTOR VEHICLE MAINT. 858 301 375 307 100 62605 E-BOOKS 54,942 51,101 51,792 52,223 295 62605 E-BOOKS 904 8,354 0 0 100 62611 MACH/EQUIP MAINTENANCE 375 233 1,125 233 100 62614 EQUIP MAINT CONTRACT 5,207 4,852 5,713 5,843 100 62650 BOOKCLUBBOOKS 2,148 2,084 2,135 2,135 100 62651 LIBRARY BOOKS 190,824 191,803 213,639 213,639 295 62651 LIBRARYBOOKS 7,093 50,149 1,000 1,000 100 62652 LIBRARY AUDIO/VISUAL 58,974 77,911 81,557 82,368 295 62652 LIBRARY AUDIO/VISUAL 532 416 0 0 100 62653 LIBRARY PERIODICALS 34,625 37,294 37,996 40,172 295 62653 LIBRARY PERIODICALS 277 0 0 0 100 62654 LIBRARY CONT/SERIALS 14,635 11,989 33,776 35,677 100 62655 ON LINE INFO SERVICE 73,471 75,479 53,494 52,262 295 62655 ON LINE INFO SERVICE 661 128 6,000 6,000 100 62656 INTERLIBRARY LOAN 739 76 769 769 100 62659 LIBRARY ViDEO MATERIALS 60,139 51,366 66,470 66,470 295 62659 LIBRARY VIDEO MATERIALS 5,130 1,898 0 0 100 62660 DATA PROCESSING 26,873 28,936 28,049 29,276 100 62664 LICENSE/PERMIT FEES 2,071 1,790 2,202 2,202 100 62666 CREDIT CARD CHARGE 1,770 1,455 1,770 1,770 100 62667 DATA SERVICES 10,994 11,022 10,980 10,980 295 62668 PROGRAM EQUIP/SUPPLIES 4,607 4,357 5,500 4,357 100 62699 CASH SHORT AND OVER 4 53 0 0 295 62710 CONTRACTOR SERVICES 0 0 5,000 0 400 62713 LEGAL SERVICES 0 86 0 0 100 62716 CONSULTANT SERVICES 11,000 0 0 0 295 62716 CONSULTANT SERVICES 14,479 0 0 0 100 62725 BILL COLLECTION SERVICES 3,490 0 0 0 400 62731 MISCELLANEOUS SERVICES 191 237 0 0 100 62732 TEMP HELPCONTRACT SERV. 13,645 4,780 18,837 17,678 100 62734 SPEAKERS/PROGRAMS 18,307 12,924 17,229 17,229 295 62734 SPEAKERS/PROGRAMS 18,410 23,647 8,000 8,000 100 62736 CATERING SERVICES 5,905 2,701 10,270 7,770 295 62736 CATERING SERVICES 2,833 1,886 2,000 2,000 100 62740 MICROFORMS 2,700 3,407 3,407 3,407 295 62785 GIFT CARDS 250 0 0 0 -55- Recommended Operating Expenditure Budget - Department Total 36-LIBRARY FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 62-SUPPLIES AND SERVICES 1,063,778 1,073,442 1,119,611 1,128,583 400 62724 BOND PAYING AGENT FEE 0 19 0 0 627-CONTRACTUAL SERVICES 0 19 0 0 100 71110 MiSC.OFFICE EQUIPMENT 13,361 769 8,190 900 295 71ll0 MISC.OFFICE EQUIPMENT 0 0 0 750 100 71 ll 5 MICROFILM EQUIPMENT 10,300 0 0 0 100 71ll8 PROJECTOR/CAMERA 14,432 0 0 14,432 100 7ll20 PERIPHERALS,COMPUTER 0 0 11,000 5,500 295 71120 PERIPHERALS,COMPUTER 2,334 600 0 400 295 71123 SOFTWARE 4,221 108 0 500 100 71124 COMPUTER 15,326 0 0 0 295 71124 COMPUTER 1,254 1,200 0 8,000 100 7ll56 FURNITURE 2,527 0 0 0 295 7ll56 FURNITURE 2,999 2,279 0 0 550 71156 FURNITURE 0 1,610 0 0 100 71212 SIDE CHAIRS 0 0 9,290 9,290 100 71215 STORAGE CABINETS 0 0 0 11,000 100 71221 CARTS 0 3,169 1,200 3,000 295 71222 WORKSTATIONS 18,190 0 0 0 100 71312 VAN/PICKUP/WAG REPL 0 0 26,520 0 100 71517 LIGHTING EQUiPMENT 2,775 2,000 2,775 2,775 100 71520 HVAC 0 0 500 500 100 71550 MISCELLANEOUS EQUIPMENT 0 1,163 0 2,800 295 71550 MISCELLANEOUS EQUIPMENT 277 0 0 0 100 71610 CUSTODIAL EQUIPMENT 0 0 11,270 9,335 100 71616 SNOW BLOWER 0 0 0 2,800 100 72416 VIDEO EQUIPMENT 16,375 0 6,475 6,475 100 72418 TELEPHONE RELATED 0 14 500 0 100 72421 HEADSETS 0 0 0 2,802 71-EQUIPMENT 104,371 12,912 77,720 81,259 295 73210 CONST CONTRACT-BLDG 19,477 0 0 0 73-CIP EXPENDITURES 19,477 0 0 0 400 74111 PRINCIPAL PAYMENT 191,786 236,198 201,106 211,568 400 74112 INTEREST PAYMENT 32,377 26,647 22,357 15,023 74-DEBT SERVICE 224,162 262,846 223,463 226,591 36-LIBRARY TOTAL 3,860,007 3,755,864 4,005,287 4,102,335 -56- Recommended Expenditure Budget Report by Activity & Funding Source 36-LIBRARY LIBRARY ADMIN. -36100 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 14 500 SUPPLIF,S AND SF,RVICF,S 43,468 66,010 65,795 WAGES AND BENEFITS 275,979 378,029 389,940 LIBRARY ADMIN. 319,461 444,539 455,735 ADULT SERVICES -36200 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 339 - 1,000 SUPPLIES AND SERVICES 425,789 464,074 468,457 WAC'rES AND BENEFITS 591,795 830,492 861,499 ADULT SERVICES 1,017,923 1,294,566 1,330,956 CHILDREN SERVICES -36210 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 430 400 1,000 SUPPLIES AND SERVICES 125,963 156,158 153,579 WACES AND BENEFITS 349,236 459,806 464,956 CHILDREN SERVICES 475,628 616,364 619,535 CIRCULATION SERVICES -36220 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget F,QU 1 PM F.NT 2,769 11,000 9,302 SUPPLIES AND SERVICES 13,649 18,729 18,440 WAGES AND BENEFITS 403,854 470,158 437,293 CIRCULATION SERVICES 420,272 499,887 465,035 LIBRARY RENOVATION DEBT -36240 FUNDING SOURCE:DEBT SERVICE Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CONTRACTUAL SERVICES 19 DEBT SERVICE 60,046 21,063 19,741 SUPPLIES AND SERVICES 323 DEBT SERVICE 60,387 21,063 19,741 MAINTENANCE SERVICES -36300 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 3,163 50,355 38,500 SUPPLIES AND SERVICES 201,875 186,145 212,285 -57- Recommended Expenditure Budget Report by Activity & Funding Source 36-LIBRARY WAGF.S AND BENFFITS 169,833 148,173 165,176 MAINTENANCE SERVICES 374,871 384,673 415,961 YOUTH SERVICES -36400 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES 20,010 23,767 23,924 YOUTH SERVICES 20,O10 23,767 23,924 LULL LIBRARY TURST -36420 FUNDING SOURCE:LIBRARY GIFTS TRUST Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 1,610 SUPPLIES AND SERVICES 150 - 150 LULL LIBRARY TRUST 1,760 - 150 INFORMATION TECHNOLOGY -36440 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 14,665 21,807 SUPPLIES AND SERVICES 89,904 108,434 95,654 WAGES AND BENEFITS 160,027 252,814 311,179 INFORMATION TECHNOLOGY 249,931 375,913 428,640 GENERAL GIFT TRUST -36480 FUNDING SOURCE:EXPENDABLE LIBRARY GIFTS Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES - - - EQUIPMENT 1,908 9,650 SUPPLIES AND SERVICES 98,490 32,229 29,248 GENERAL GIFT TRUST 100,398 32,229 38,898 WALTON PRESERVATION TRUST-36490 FUNDING SOURCE:EXPENDABLE LIBRARY GIFTS Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 2,279 SUPPLiES AND SERVICES 761 1,800 776 WALTON PRESERVATION TRUST 3,039 1,800 776 JAMES MUTSCHLER TRUST -36496 FUNDING SOURCE: EXPENDABLE LIBRARY GIFTS Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES -58- Recommended Expenditure Budget Report by Activity & Funding Source 36-LIBRARY WAGF.S AND BENFFITS 30,956 40,678 33,371 JAMES MUTSCHLER TRUST 30,956 40,678 33,371 TECHNICAL SERVICES -36500 FUNDING SOURCE:EXPENDABLE LIBRARY GIFTS Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES 4,357 5,657 4,357 SPACE MAKER OPERATIONS 4,357 5,657 4,357 EQUIPMENT 400 800 0 SUPPLIES AND SERVICES 48,705 56,608 55,918 WAGES AND BENEFITS 424,966 4,343 2,488 TECHNICAL SERVICES $ 474,071 $ 61,751.00 $ 58,406.00 LIBRARY RENOVATION DEBT -36600 FUNDING SOURCE:DEBT SERVICE Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget DEBT SERVICE 202,800 202,400 206,850 LIBRARY RENOVATION DEBT $ 202,800 $ 202,400.00 $ 206,850.00 LIBRARY TOTAL $ 3,755,863.99 $ 4,005,287.00 $ 4,102,335.00 -59- CITY OF DUBUQUE , IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 36 LIBRARY DEPARTMENT FY 2020 FY 2021 FY 2022 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 $ 116,538 1.00 $ 118,230 1.00 $ 120,758 100 8100 GE-34 LIBRARIAN II 2.00 $ 158,560 2.00 $ 160,931 2.00 $ 162,679 100 GE-32 LEADAPPL/NETWORKANALY 1.00 $ 70,530 1.00 $ 75,252 1.00 $ 77,143 100 8020 GE-32 LIBRARIAN I 5.00 $ 359,159 4.00 $ 288,187 4.00 $ 294,093 100 GE-33 CIRCULATION MANAGER 1.00 $ 64,663 1.00 $ 69,001 1.00 $ 74,507 100 7900 GE-30 LIBRARYAIDE 5.00 $ 310,275 7.00 $ 438,156 7.00 $ 438,334 100 475 GE-30 ADMINISTRATIVE ASSISTANT 1.00 $ 65,241 1.00 $ 65,960 1.00 $ 67,029 100 2200 GE-27 MAINTENANCE WORKER-LIBRARY 1.00 $ 54,533 1.00 $ 55,693 1.00 $ 56,503 100 1400 GE-25 CUSTODIAN-LIBRARY 1.00 $ 48,986 1.00 $ 50,028 1.00 $ 6,132 100 3345 GE-26 USER SUPPORT SPECIALIST 1.00 $ 55,158 1.00 $ 59,016 1.00 $ 50,356 TOTAL FULL TIME EMPLOYEES 19.00 $1,303,643 20.00 $1,380,454 20.00 $1,347,534 61020 Part Time Employee Expense 100 8020 GE-32 LIBRARIAN I 0.07 $ 4,241 0.07 $ 4,162 0.07 $ 3,996 100 7900 GE-30 LIBRARYAIDE 2.19 $ 116,385 1.69 $ 88,451 1.69 $ 90,531 100 1400 GE-26 CUSTODIAN-LIBRARY 0.13 $ 5,657 0.13 $ 5,844 0.13 $ 50,752 100 GE-25 LEAD LIBRARYASSISTANT 1.00 $ 44,813 0.63 $ 30,205 0.63 $ 31,347 100 7850 GE-25 LIBRARYASSISTANT 6.43 $ 268,531 7.30 $ 313,536 7.30 $ 324,042 100 4440 GE-25 LIBRARY SECRETARY - $ - - $ - - $ - 100 GE-25 CONFIDENTIALACCOUNT CLERK 0.63 $ 26,000 0.63 $ 27,417 0.63 $ 28,095 100 NA-38 INFORMATION SERVICES INTERN 0.50 $ 13,572 0.50 $ 13,718 0.50 $ 13,926 100 NA-28 CLERICALASSISTANT 0.25 $ 6,639 0.25 $ 6,713 0.25 $ 6,812 100 7750 NA-24 LIBRARY CLERK 3.95 $ 89,683 3.95 $ 86,437 3.95 $ 87,462 TOTAL PART TIME EMPLOYEES 15.14 $ 575,521 15.14 $ 576,483 15.14 $ 636,963 TOTAL LIBRARY 34.14 $ 1,879,164 35.14 $ 1,956,937 35.14 $ 1,984,497 -60- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2020 FY 2021 FY 2022 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 $ 116,538 1.00 $ 118,230 1.00 $ 120,758 10036100 61010 100 GE-30 LIBRARYAIDE - $ - 1.00 $ 67,241 1.00 $ 68,249 10036100 61010 100 475 GE-30 ADMINISTRATIVE ASSISTANT 1.00 $ 65,241 1.00 $ 65,960 1.00 $ 67,029 Total 2.00 $ 181,779 3.00 $ 251,431 3.00 $ 256,036 Library Administration-PT 10036100 61020 100 GE-25 LIBRARY SECRETARY - $ - - $ - - CONFIDENTIAL ACCOUNT 10036100 61020 100 3,300 GE-25 CLERK 0.63 $ 26,000 0.63 $ 27,417 0.63 $ 28,095 10036100 61020 NA-28 CLERICALASSISTANT 0.25 $ 6,639 0.25 $ 6,713 0.25 $ 6,812 Total 0.88 $ 32,639 0.88 $ 34,130 0.88 $ 34,907 Adult Services-FT 10036200 61010 100 7900 GE-30 LIBRARYAIDE 1.00 $ 57,848 3.00 $ 194,199 3.00 $ 200,197 10036200 61010 100 8020 GE-32 LIBRARIAN I 4.00 $ 285,102 4.00 $ 288,187 4.00 $ 294,093 10036200 61010 100 8100 GE-34 LIBRARIAN II 1.00 $ 79,280 1.00 $ 80,159 1.00 $ 80,534 Total 6.00 $ 422,230 8.00 $ 562,545 8.00 $ 574,824 Adult Services-PT 10036200 61020 100 8070 GE-32 LIBRARIAN I 0.07 $ 4,241 0.07 $ 4,162 0.07 $ 3,996 10036200 61020 100 NA-24 LIBRARY CLERK - $ - 0.38 $ 8,410 0.38 $ 8,529 10036200 61020 100 7900 GE-30 LIBRARYAIDE 1.00 $ 54,847 1.00 $ 51,109 1.00 $ 51,104 Total 1.07 $ 59,088 1.45 $ 63,681 1.45 $ 63,629 Youth Services-FT 10036210 61010 100 8100 GE-34 LIBRARIAN II 1.00 $ 79,280 1.00 $ 80,772 1.00 $ 82,145 10036210 61010 100 7900 GE-30 LIBRARYAIDE 2.00 $ 121,524 3.00 $ 176,716 3.00 $ 169,888 Total 3.00 $ 200,804 4.00 $ 257,488 4.00 $ 252,033 Youth Services-PT 10036210 61020 100 7800 GE-25 LIBRARYASSISTANT - $ - - $ - - 10036210 61020 100 7900 GE-30 LIBRARYAIDE 0.69 $ 36,802 0.69 $ 37,342 0.69 $ 39,427 10036210 61020 100 7750 NA-24 LIBRARY CLERK 2.57 $ 55,262 2.57 $ 56,588 2.57 $ 57,014 Total 3.26 $ 92,064 3.26 $ 93,930 3.26 $ 96,441 Circulation Services-FT 10036220 61010 100 GE-33 CIRCULATION MANAGER 1.00 $ 64,663 1.00 $ 69,001 1.00 $ 74,507 Total 1.00 $ 64,663 1.00 $ 69,001 1.00 $ 74,507 Circulation Services-PT 10036220 61020 100 7750 NA-24 LIBRARYCLERK 1.00 $ 26,106 1.00 $ 21,439 1.00 $ 21,919 10036220 61020 100 NA-24 LEAD LIBRARYASSISTANT 1.00 $ 44,813 0.63 $ 30,205 0.63 $ 31,347 10036220 61020 100 7850 GE-25 LIBRARYASSISTANT 3.43 $ 133,708 6.30 $ 269,218 5.30 $ 227,237 Total 5.43 $ 204,627 7.93 $ 320,862 6.93 $ 280,503 Technical Services-FT 10036500 61010 100 7900 GE-30 LIBRARYAIDE 2.00 $ 130,903 - $ - - 10036500 61010 100 GE-32 LIBRARIAN I 1.00 $ 74,057 - $ - - Total 3.00 $ 204,960 - $ - - $ - Technical Services-PT 10036500 61020 100 NA-24 LIBRARY CLERK 0.38 $ 8,315 - $ - - 10036500 61020 100 7850 GE-25 LIBRARYASSISTANT 3.00 $ 134,823 - $ - - 10036500 61020 100 7900 GE-30 LIBRARYAIDE 0.50 $ 24,736 - $ - - Total 3.88 $ 167,874 - $ - - $ - Information Technology-FT 10036440 61010 100 GE-32 LEADAPPL/NETWORKANALY 1.00 $ 70,530 1.00 $ 75,252 1.00 $ 77,143 Total 1.00 $ 70,530 1.00 $ 75,252 1.00 $ 77,143 -61- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2020 FY 2021 FY 2022 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Information Technology-PT INFORMATION SERVICES 10036440 61020 100 NA-38 INTERN 0.50 $ 13,572 0.50 $ 13,718 0.50 $ 13,926 10036440 61020 100 GE-26 USER SUPPORT SPECIALIST 1.00 $ 55,158 1.00 $ 59,016 1.00 $ 50,356 10036440 61020 100 GE-25 LIBRARYASSISTANT — $ — 1.00 $ 44,318 2.00 $ 96,805 Total 1.50 $ 68,730 2.50 $ 117,052 3.50 $ 161,087 Maintenance-FT MAINTENANCE WORKER- 10036300 61010 100 2200 GE-27 LIBRARY 1.00 $ 54,533 1.00 $ 55,693 1.00 $ 56,503 10036300 61010 100 1400 GE-25 CUSTODIAN-LIBRARY 1.00 $ 48,986 1.00 $ 50,028 1.00 $ 6,132 Total 2.00 $ 103,519 2.00 $ 105,721 2.00 $ 62,635 Maintenance-PT 10036300 61020 100 1400 GE-25 CUSTODIAN-LIBRARY 0.13 $ 5,657 0.13 $ 5,844 0.13 $ 50,752 Total 0.13 $ 5,657 0.13 $ 5,844 0.13 $ 50,752 TOTAL LIBRARY DEPARTMENT 34.14 $1,879,164 35.14 $1,956,937 35.14 $1,984,497 -62- 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 -63- -_�� _ � :�_ +�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 . . � . . . Materials . Material Acquisition & Adult Services Youth Services � Processing Services Infor n Building enance Technology & Distribution of Services Materials FISCAL YEAR HIGHLIGHTS � TC� . . . . . . Visitors 201 329 � . . . Card Holders 38 680 � . . . Check Outs 528 592 � FISCAL YEAR HIGHLIGHTS � TC� . . . . . . 5 438 Maker S ace visits , p . . . 88 865 check outs of d i ital materials � g . . . 18 129 items added to the collection � FISCAL YEAR HIGHLIGHTS .� � TC� . . . . . . 571 Pro rams for outh g y . . . 180 Pro rams for ad u Its g . . . 18 766Attendance to all ro rams � p g � - � FY20 CHECKOUTS : - - � 470,465 ■ ■ � I � � J.0��0 � - / I 1 , � - - 19.0% \ � • • • . ' � i � 43.0% • • • ' ' • • � 4.0% � � � � • • • • � • � , � • • • • • 31.0% � � � � � � � - � � Print Materials � Video{DVD& Blu-RaysJ � � Audio Books& Music � � Digital Books{e-book, e-audio, streaming video& magazines} Other Items{cake pan5, game5, equipment) FISCAL YEAR HIGHLIGHTS .� � 2% u nder budget TC� . . . FY2� Library Expenditures ! 13.Q% � ��.a�io � S.O�IO 67.0% � � Operatians � Materials Budget Freaze � Staffing Costs FI � CAL YEAR HI � HLI � HT� , Materials Budget as a °Io of all � � • � . Expenditures ��.aa��o 15.24°�0 0 . � 13.38°/a 1�.74°!0 11.4�°/u 10.95°/0 9.89°l0 10.D0°/o 9.11°/0 8.89°l0 8.58°/fl 8.13°/0 5.Q0°/o -��D -" Qubuque �es Ames Vlfest lawa City Cauncil Cedar �avenport V1laterlao Siaux Moines Des Bluffs Rapids City Moines Materials Budgat FISCAL YEAR HIGHLIGHTS ,, Promotion - Return on Investment 15 Electronic resources promoted - ROI is measured : �r c� . . . by the decrease i n cost per h it for each resou rce 89% decrease in cost 42% decrease in cost C�I I ��t�r� �I�'1#L��V��e��r , 90% decrease in cost for both �� T��n��r�n# �.��r�� rr��}�a {� �� 31% decrease in cost 42% decrease in cost (Libby) 16% decrease in cost ��I�� Nu��List Pl� o � r�� (�l �� 57 /o decrease in cost " �U��' ��1�- ,� s�� f 42% decrease in cost r�� ■ �� I � � � � - . � r ,�: . �' _ �r �� -� � � - ,+�J - r � '� � y � f t' � � �' � .�'/� t•�" • •; -, _"- "r�: � r. ,�, � -�� . . , � � .�; . . . ._ �1' � L r u � + - �r,i. °'' � 'r � I r. ,� -. F_� � a Y, 'A _� A'��-. � � 'a •,.��.I , , c, a.�.,.r� �� r'" �r } � � w .,�_ � �J ' �� ' 1� . � '�� t r - f �� '+C' � .f � .�+..� f ,�' - . � . .�,. i� .K� -4 ' ,{T �5 . , r . -� � � � 4 f� . .�,;� {.��r' - �' � t ' r ,� � j � �T 4 - i ��• r '�� '� ��I� + ' �� . ��y � `� t _ '��' 1 f�' P . . � � . . a • .� � �- 1 — - �: f� � r• E - � 1!� y` - � • I I '� 'i. � =, �r: �1.f. I f j + F � �` .+Y:� .a ,k .�5� ? lr .. � .� ,~x' I �,� I . � - � !1� i� �. 1lll:l"['��[. I.[F3i�[,1f;S' K � ' r} �+ � •ii�r�L�w�A�iMM�►� tw�1�IwM► �.�L�i►H�Mr Ol�a��l�p�1�M R�I��h\ � ` � �.� 2 �� '"r• '��'•�+� i f:- ! X - i I. t 4 s'x' � � • 2 FTE Youth Services • Com uter e u i ment . � p q p re lacement � • • p • E u i ment re lacement — q p p • . vacu u m cleaners chai rs , , tele hones secu rit p � y cameras self-check , mach i nes • CI P — roof and oil tank removal FUTURE _ . - , . , , , ,- �__, � � � / . , � - o a . ■ .. .T s� _ _ � _._ _��r� :_��. � -,� . _� �;_ .;. + < < _� ,;� Y "ti--:.�.. - , :�n ' .� � r� � •. , _` � , , .=�`- ' � ' ; : :Y;1 ; f�' � i. •_+f r'.e�,- +� �•��f,. {� Y. _ . ,.1 .��t=�".:j�. �� A.� . .,1��: � �.,�_��!� ��, ' . ' .. �'� . . . f . '�^ _ r �Ysr/�� -��..-:.a. '.,� - �_„� r �I r I�Yr..��'�}.r"�' � `�. -,i r � +�; ,��. � ,��. ; � � `'- :+�'��1+� _•�• ' - .r�. �:�d.;,; . �e,rt�? � • �.-:� � �' , ,# �'i``. _ . , ,� •�! ti � ,• - - �' •�. _a' ` - � �f�M! 'E��Q� ��._ �� • � . ' �� K.� '�• � 2 .1�F �"/�7s �� {, ,•� �.�� - �-¢ r„ f '� �� ' �"' '# �y� � '� . � �. . +� f �` ' 1 - , =r_;'. -"r,. r _.� f�� T 1'�`' _�'�� ~� -F'r".�`�'�"t..�t ,, ti;� -s�ir�►' ' . �l � t. r- -"'� �. .. "� - ."' �- �`r��17� �: �°•,." ��,o- '. - �.� t' f`f��.`•:\'�.�.". _�.. �k.��A y'Lf �..� a�' ■ ti , . :.�Tx:._t;�5��•.�•�;�_.M1��;�` r: .�,�, _ . - .-�:= :,;�=�`� '.. a� }� -t ' } : . , � .r ., . � - ' � '1�,ti�y ' .`' ' .�c. . '� �� i' .�:. �, : ,` . �•i,. �f�` �• _ .` ��(��r `�. �'. • 1.�'- . . . , 'j- �..� .��. � 'ti • - �` � - ./i�. yL'�` s'�. . ti a�-�•� . � '� '/�' •H:4� � � 'h� � ^.f�;�i'' � l�� ! f. '�� SS��` t 5 t��' Y `'1. o.+�►• ti��.- '�.'r �� Y�• l � ��]� { ,}�rr.� . �'A ".� � - 1'._ ' d �L .��:'.��y.f�r� +a�� T� �Ti.. 1�' �� ''Y ' ' �_;�� Fy'- " f}1�T,� 1 � ��1'ti- r:6y7• ��q '�'_ ].,r�~ , �.j�G.- _ I .,�1k�:{4 ';�r,'R -{� k �v� - _.,-u�� X '' Y w. �e Y; �� . ��✓ � � , � e - ui e our ■ ■ r� w'�1 � � ��`�� .:r�� '�....�-..�+�I�i�.-_ ��. _ .�. � _ � ;:�,'.. .,�;,,� , � .� � � '�. - ' .j� '.-_ - �� ►�t�,�.;.�� '�• F � �:,•�,�� "•�, .�` °•'•� � ; �i ��•. � • 1 , ��i � �� • � `t '-J �'I�r � r , "�%� �� . �� a �ii'.: I �•,�J ,.�n� .i_ , + fF '� r+t - � �', ,�' ' 1 f `y � ,*' . � ' . . ' • ' • � • • . 1 � , � � • � � � ■ � • � � - - 3 758 387 58 . 50 � � � * 1 154 822 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 $146,567) Restricted G ift Trusts U n restricted G ift Trusts - James � � �� Lacy Book ,31;:11171��; ,� . : . � Mutschler Trust � � � � Trust �t��..�T�.�:��, � �13■256 � - -�� Educated $995,071 - _ I A MEMOIR �'� �� f` �i' �' . : : . :':.f �� ._.�.� � � • _ _ , �� a.rnegi�-�tout L u l l A rt �� "�� G e n e ra l L i b ra � � � L ' � �. i � � � � � � -�.-��:. � �° � & r�,�e Fricxf�cls ��#'t��cx LY�rar� Tru st x - . ��.��.�_� - ��t Tru st �� ::� �� -- $5 050 � ; � �-�: � � � � �� -; $140 378 � 7 f. : . , � � 7 f � � � ¢�k. .• �:�� [� .' r��8�c2u��r,c�r�c;r,s5cx�,x,�c��+ �� i� _ ��m�} � � - a ::�- � . .+- ��_ .� �. :, �r# ^.- � x �_ - ';:� = - �..q�,�,� y -- �� "�.�� : �� 1 t_ ... . �J r . ., , � � ' . . . , i�'�x'".[��(}�Q .� � � �r �� 1 �� 1 I ��U;�;1�.-��+ I U n restri cted General Gift Trust • Foundation Grants $20,210 = - • • • Friends of the Library Grants $5, 160 = - - - '� � • • Changing Lives Through Literature Grant $ ,635 • - • ' • - • Strategic Plan $ 13,000 • '� � � • Appraisal and Preservation of Artworks $10,000 • • = - - - • Youth Summer Reading $ 2,500 '� � ' � • Informational Databases $ 4,620 • Art �� yo u r I i b ra ry $ 2,500 • Marketi ng $2,200 • State funds — restricted $23,493 � Re uest 0 for Im rovements q p ' � • No Im rovement Packa es Submitted p g � �' for FY22 . f �� Re uest fu nd i n for last ear's q J Y a roved IP : a full -time libra aide p p rY T � � � i to work with teens . And a request to thaw the frozen position of a separate full -time library aide to work with children . ' ■ ■ Re uest $0 � n New Ca �tal q p . Improvement Projects . � No capital improvement projects ��. su bm itted for FY22 . f Request fundin for CIPs from FY 2020 g T � � � . • e w ro 0 . • emova o o � an . • a n sca � n o aza area - ma � n en rance 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) � • # of Children 's items checked out 103, � �� Carnegie-Stout Public Library PERFORMANCE MEASURES ■ ■ Adult Services • # of electron ic i nformational resou rces accessed • % i ncrease i n check out of d i ital materials !3 . 5 g • # of attendees to programs , � « • # of programs held for adults " 80 Carnegie-Stout Public Library PERFORMANCE MEASURES ■ ■ Materials Checkout & Distribution • # of items i n col lection for checkout • # of reg istered borrowers as a % of popu lation �8 • # of del iveries to home bou nd residents • # of issues of TH newspaper archives viewed 130 , 390 http://www.dubuque.lib.ia.us/