FY23 Proposed Budget Summary — original pdf

Backup

Austin Public Library Fiscal Year 2022-23 Proposed Budget The Proposed Operating Budget of the Austin Public Library (APL) includes an increase of $2,031,203 or 3.4%. The Materials budget requested increase is $217,359, or 3.5% for inflation. Requirements: Revenues Full-Time Equivalents (FTEs): Materials Budget: FY 2021 Budget $58,868,376 $239,815 445.55 $5,896,218 FY 2022 Budget $60,487,260 $525,806 450.55 $6,210,270 FY 2023 Proposed $62,518,463 $188,153 450.55 $6,427,629 Proposed Operating Budget Highlights General Fund CITY-WIDE  Personnel Requirements FTEs Wage adjustments and accrued payroll $ 552,310 .00 Insurance – health/life/dental, increase in City cost Reduction for prior year one-time salary enhancement  Internal Support Services allocation changes Administrative Support Communications & Technology Management (CTM) Fleet Maintenance & Fuel DEPARTMENT-WIDE $ 463,700 ($ 419,028) $ 145,123 $ 652,907 $ 32,052  Materials Budget (Books, Subscriptions, and Hotspots) 3.5% increase for materials, due to inflation & population growth $ 217,359  IT software – increase for hardware & software licenses and contracts $ 301,100  One-time budget reallocations: Digital literacy training for older adults (Programs & Partnerships) $ 25,000  Vacancy savings funded expenditures – Contingent upon vacancy rate: Materials Budget Programs Furniture Security Cameras Internships - temporary employees Training $ 700,000 $ 275,384 $ 183,300 $ 100,000 $ 99,900 $ 27,950 Questions? Email us at Library-ACAOFinance@austintexas.gov 5/20/2022  Austin Public Library Fiscal Year 2022-23 Proposed Budget Library Facilities Maintenance and Improvements Fund The Operating Budget in the Library Facilities Maintenance and Improvements Fund (7LIB) is $644,445 in expenditures. This includes $448,945 in operating costs for the Central Library parking garage, gift shop, and facility rentals. Operating costs include a one-time expenditure of $90,000 for a parking garage gate. Support services expenditures consists of $195,500 in contingency for facility maintenance costs exceeding General Fund budget. Revenues from Central Library operations including parking garage, gift shop, facility rentals, and café rental are budgeted at $1,158,991. Historic Preservation Fund The Proposed Operating Budget in the Historic Preservation Fund (1160) for Austin Public Library is $33,299 to provide digital asset management for Austin History Center (AHC) collections. This is a continuation of annual funding that began in FY 2020 to provide Digital Services for Austin History Center (AHC) Historic Collections. Capital Improvement Program Funds APL continues work on renovations and repairs at various branches and locations across the city with planned spending of $15,779,863 in 2018 Bonds, 2012 Bonds, and Historic Preservation Funds. Buildings and Improvements Subproject 788.002 Yarborough Branch Library Roof Replacement and HVAC Upgrade 1289.002 Ruiz Branch (Roof Replacement) 1291.004 Spicew ood Springs Roof Replacement (Built Up Roof) 1292.002 Carver Branch Library Roof and Mechanical Replacement 5888.005 Faulk Building and History Center Renovation 6014.037 University Hills Branch Library Parking Lot Expansion 6014.041 Cepeda Branch Library Renovation 11981.001 Willie Mae Kirk Branch Library Renovation 11983.001 Old Quarry Branch Library Renovation 12700.001 Cepeda Branch Trail 12702.001 Little Walnut Creek Renovation 12703.001 St. John Branch (Renovation) 12704.001 Manchaca Branch (Roof Replacement / Renovation) 12705.001 Hampton Branch at Oak Hill Parking Lot Expansion 12706.001 How son Branch HVAC and Controls Upgrades Total 2023 476,637 0 0 604,890 9,377,409 244,289 800 581,145 458,280 252,600 1,253,976 1,156,215 866,748 150,000 356,874 15,779,863 Questions? Email us at Library-ACAOFinance@austintexas.gov 5/20/2022 Austin Public Library ‐ Operating Budget Summary EXPENDITURES, BY PROGRAM & ACTIVITY: General Fund Materials Management Services Cataloging Support Collection Support Public Services Austin History Center Circulation and Programs Reference and Information Services Homelessness Support Services Departmental Support Services Transfers & Other Requirements Other Requirements Transfers 3CAT 3CLL 2AHC 2CRC 2REF 6HML 9ADM 9REQ 9XFR Library Facilities Maintenance and Improvements Fund (7LIB) Central Library Operations NCL Parking Garage NCL Gift Shop NCL Facility Rentals Support Services Facilities Services FY23 Budget 62,518,463 8,292,688 $         $ 100.0% 13.3% 893,442 1.4% 7,399,246 11.8% $ 25,395,397 40.6% 1,505,893 2.4% 22,216,822 35.5% 1,516,081 2.4% 156,601 0.3% $ 17,341,825 27.7% 17,341,825 27.7% $ 11,488,553 18.4% 719,480 1.2% 10,769,073 17.2% $               $ 644,445 448,945 230,870 159,775 58,300 $ 195,500 195,500 FY23 Budget  ‐ General Fund, by Major Category Commodities,  $4,868,700 ,  8% Contractuals,  $20,422,447 ,  33% Personnel,  $37,257,879 ,  59% Austin Public Library  Expenditures, by Category and Unit General Fund Personnel Contractuals Commodities Non‐CIP Capital Expense Refunds Transfers EXPENDITURES, BY CATEGORY: FY20 FY21 FY22 Under/ % for FY FY23 Budget to  budget Budget to  budget FY22 CYE Actual $        34,151,838            15,765,588 2,385,238                                           ‐                (164,774)                 128,316 $        52,266,207 Actual 33,403,280 17,724,279 3,679,907 200,445 (118,679) 48,530 54,937,761 $                                                                                 $        Budget 36,528,232 19,146,895 4,807,861 210,000 (233,890) 28,162 60,487,260 $                                                            $     $                                                                   $      35,516,287 20,000,582 4,018,512 300,000 (326,610) 36,982 59,545,754 (Over) 1,011,945 (853,687) 789,349 (90,000) 92,720 (8,820) 941,506 $                                                                             $           Est. Spent 97.2% 104.5% 83.6% 142.9% 139.6% 131.3% 98.4% Budget 37,257,879 20,422,447 4,868,700 100,000 (216,986) 86,423 62,518,463 $                                                                 $      $ diff $                                                                              $       729,647 1,275,552 60,839 (110,000) 16,904 58,261 2,031,203 % diff 2.0% 6.7% 1.3% ‐52.4% ‐7.2% 206.9% 3.4% EXPENDITURES, BY UNIT: FY22 FY22 Under/ % for FY FY23 Budget to  budget Budget to  budget 2300 Central Circulation 2400 Reference 2600 Public Printing Services 2700 Community Services 3000 Branch Services 3100 Cataloging Support 3200 Collection Support 3300 Customer Service 3400 Delivery ‐ Circ. Support 5000 Austin History Center 8100 Youth Services 8770 Administration 8772 Mail Services 8773 Facilities Services 8774 Security 8775 Custodial 8781 Human Resources 8782 Training 8783 Financial Services 8784 Information Technology Support 8785 Communications 8787 Programs and Partnerships 8788 Outreach 8789 Vehicle Maintenance 8791 Sales and Event Services 9998 Other Requirements 9999 Transfers Out FY20 Actual                                                                                                                                                                                                                                                                                                                                                                                                                   $        2,049,147 1,606,636 (11,066) 150,032 14,780,191 715,914 6,195,793 698,500 542,467 1,513,117 904,668 1,916,552 5,789 3,221,394 2,047,842 2,059,992 852,681 195,437 744,120 3,519,333 401,676 812,853 439,076 127,453 529,075 (369,310) 6,616,845 52,266,207 FY21 Actual                                                                                                                                                                                                                                                                                                                                                                                                                          $        2,016,027 1,727,842 538 111,259 14,484,982 555,130 7,358,495 719,794 528,879 1,382,987 967,277 1,926,066 3,945 2,966,075 1,907,983 1,948,115 853,457 200,000 755,943 3,977,973 304,388 866,932 363,335 126,698 554,594 (947,888) 9,276,936 54,937,761 Budget 1,780,492 1,622,086 (69,800) 153,913 15,428,035 897,644 7,193,477 844,348 486,903 1,489,090 993,005 1,994,257 35,000 3,622,768 1,930,350 1,733,727 963,163 319,706 833,009 4,251,664 462,020 1,509,482 763,431 168,211 609,285 586,197 9,885,797 60,487,260                                                                                                                                                                                                                                                                                                                 $     CYE 2,115,392 1,643,610 (34,652) 90,866 15,114,331 844,973 7,781,428 772,078 438,979 1,377,936 1,030,358 2,261,779 13,214 3,169,219 2,199,278 2,071,354 875,129 346,115 893,770 4,144,419 424,212 606,261 643,970 146,728 522,039 167,170 9,885,797 59,545,754                                                                                                                                                                                                                                                                                                                                                         $      (Over) (334,900)             (21,524)               (35,148)               63,047                313,704              52,671                (587,951)             72,270                47,924                111,154              (37,353)               (267,522)             21,786                453,549              (268,928)             (337,627)             88,034                (26,409)               (60,761)               107,245              37,808                903,221              119,461              21,483                87,246                             419,027                           ‐ $           941,506 Est. Spent 118.8% 101.3% 49.6% 59.0% 98.0% 94.1% 108.2% 91.4% 90.2% 92.5% 103.8% 113.4% 37.8% 87.5% 113.9% 119.5% 90.9% 108.3% 107.3% 97.5% 91.8% 40.2% 84.4% 87.2% 85.7% 28.5% 100.0% 98.4% Budget 1,845,549 1,585,881 (69,800) 156,601 15,906,075 893,442 7,399,246 845,192 506,793 1,505,893 1,002,791 2,009,365 35,000 3,662,866 1,904,859 1,708,284 954,247 328,296 846,268 4,543,598 447,993 1,323,959 786,463 200,263 700,786 719,480 10,769,073 62,518,463                                                                                                                                                                                                                                                                                                                         $      $ diff                65,057 (36,205)                                         ‐                  2,688              478,040                 (4,202)              205,769                      844                19,890                16,803                  9,786                15,108                           ‐                40,098               (25,491)               (25,443)                 (8,916)                  8,590                13,259              291,934               (14,027)             (185,523)                23,032                32,052                91,501              133,283              883,276 2,031,203 $       % diff 3.7% ‐2.2% 0.0% 1.7% 3.1% ‐0.5% 2.9% 0.1% 4.1% 1.1% 1.0% 0.8% 0.0% 1.1% ‐1.3% ‐1.5% ‐0.9% 2.7% 1.6% 6.9% ‐3.0% ‐12.3% 3.0% 19.1% 15.0% 22.7% 8.9% 3.4% Library Facilities Maintenance and Improvements Fund EXPENDITURES, BY CATEGORY: FY21 Actual FY22 Budget FY22 CYE Under/ (Over) % for FY Est. Spent FY23 Budget Budget to  budget $ diff Budget to  budget % diff Personnel Contractuals Commodities Non‐CIP Capital EXPENDITURES, BY UNIT: 8771 NCL Parking Garage 8773 Facilities Services 8776 NCL Facility Rentals 8778 NCL Gift Shop 5,495 $                  6,036                                        18,878                              ‐ $                30,409 $                                                 $       153,986 683,575 179,000 228,000 1,244,561 150,004 $            485,375                             121,500                            ‐ $            756,879 $                                                        $           3,982 198,200 57,500 228,000 487,682 97.4% 71.0% 67.9% 0.0% 60.8% $                                                     $           190,870 184,575 179,000 90,000 644,445 $             36,884 (499,000)                                       ‐             (138,000) $         (600,116) 24.0% ‐73.0% 0.0% ‐60.5% ‐48.2% FY21 Actual FY22 Budget FY22 CYE Under/ (Over) % for FY Est. Spent FY23 Budget Budget to  budget $ diff Budget to  budget % diff 3,665 $                                               ‐                      6,521                   20,223 $                30,409 $                                                   $       361,986 695,500 27,300 159,775 1,244,561 $                                                        $            110,004 475,000 46,000 125,875 756,879 $                                                     $           251,982 220,500 (18,700) 33,900 487,682 30.4% 68.3% 168.5% 78.8% 60.8% $                                                     $           230,870 195,500 58,300 159,775 644,445 $         (131,116)             (500,000) 31,000                                          ‐ $         (600,116) ‐36.2% ‐71.9% 113.6% 0.0% ‐48.2% T:\Budget\FY23 Budget\EXPENDITURES\APL FY23 Proposed Budget and FY22 Current Year Estimate_052422.xlsx Summary 5/26/2022 1:21 PM Austin Public Library Revenues, by Category Budgeted Funds General Fund Revenue By Category Charges For Services/Goods General Government Passport Services Photocopies Recreation and Culture Non‐Resident Card Fee Fines, Forfeitures, Penalties Library Fines Other Revenue Austin History Center Over/Short Total Revenue Revenue By Category Use of Property NCL Parking Garage NCL Facility Rentals NCL Café Tenant Other Revenue NCL Gift Shop NCL Parking Garage NCL Facility Rentals NCL Café Tenant NCL Gift Shop Transfer from Special Revenue FY20 Actual FY21 Actual FY22 Budget FY22 CYE (Under)/ Over Est. % Coll. FY23 Proposed Budget to  budget $ diff Budget to  budget % diff $                   ‐ $               7,968 $               $                 16,853 1,403 $          $          41,000 14,754 $           $              72,175 4,028 $           $          31,175 (10,726) 176% 27% $            $              76,268 4,084 $            $           35,268 (10,670) 86% ‐72% $             41,508 $               46,410 $          73,945 $           55,098 $          (18,847) 75% $            55,870 $           (18,075) ‐24% $          260,498 $             141,384 $        376,622 $         126,576 $        (250,046) 34% $            43,402 $        (333,220) ‐88% $             $                     $          11,977 64 322,015 $               $                       $             10,604 55 216,709 $          19,485 $                 ‐ $        525,806 $              8,411 $                  ‐ $         266,288 $          (11,074) $                  ‐ $        (259,518) 43% 51% $              8,529 $                  ‐ $         188,153 $           (10,956) $                   ‐ $        (337,653) ‐56% ‐64% FY20 Actual FY21 Actual FY22 Budget FY22 CYE (Under)/ Over Est. % Coll. FY23 Budget Budget to  budget $ diff Budget to  budget % diff $                                      183,141 70,022 252,559 $                                             122,935 23,412 228,236 $                            450,960 313,700 148,468 294,827 $         $         307,826 $                  ‐ $        $            $        (156,133) (5,874) (148,468) 65% 98% 0% $                                 360,000 307,840 237,471 $           $             $            (90,960) (5,860) 89,003 ‐20% ‐2% 60%              157,042                  72,968           253,680 $         186,500 $          (67,180) 74%             253,680 $                   ‐ 0% Special Revenue Funds ‐ New Central Library (NCL) Total Revenue $          662,764 $    1,166,808 $         789,153 $        (377,655) 68% $      1,158,991 $             (7,817) ‐1%                                                          $         1,124,782 535,415 302,502 281,683 2,691,933 AUSTIN PUBLIC LIBRARY 2019-20 Actual 2020-21 Actual 2021-22 Estimated 2021-22 Amended 2022-23 Proposed Total by Strategic Outcome 52,266,207 54,937,761 59,545,743 60,487,260 62,518,464 46,018,672 (369,310) 6,616,845 46,608,713 0 8,329,048 49,492,776 0 10,052,967 50,015,266 0 10,471,994 51,029,911 0 11,488,553 6,911,707 23,485,622 15,621,342 7,913,625 23,169,853 15,525,236 8,626,401 23,799,126 17,067,249 8,091,121 25,000,985 16,923,160 8,292,688 25,395,397 17,341,826 6,247,535 8,329,048 10,052,967 10,471,994 11,488,553 52,266,207 54,937,761 59,545,743 60,487,260 62,518,464 322,015 322,015 443.55 216,709 216,709 445.55 266,288 266,288 450.55 525,806 525,806 450.55 188,153 188,153 450.55 Operating Budget Expenditures by Strategic Outcome Culture and Lifelong Learning Government that Works Transfers and Debt Service Expenditure by Program Materials Management Services Public Services Support Services Transfers, Debt Service, and Other Requirements Total by Program Funding Sources General Fund Total Revenue Civilian FTEs Library Facilities Maintenance and Improvements Beginning Balance Revenue Building Rental/Lease Parking Fees Other Revenue Total Revenue Transfers In Other Funds Total Transfers In Total Available Funds Program Requirements Support Services Total Program Requirements Excess (Deficiency) of Total Available Funds Over Total Requirements Adjustment to GAAP Ending Balance 2019-20 2020-21 2021-22 2021-22 2022-23 Actual Actual Estimated Amended Proposed 0 2,661,524 2,483,738 2,483,738 0 0 0 0 0 0 0 0 0 0 0 0 0 0 251,648 122,935 72,968 447,551 2,244,382 2,244,382 307,826 294,827 186,500 462,168 450,960 253,680 545,311 360,000 253,680 789,153 1,166,808 1,158,991 0 0 0 0 0 0 2,691,933 789,153 1,166,808 1,158,991 30,409 30,409 756,879 1,244,561 756,879 1,244,561 644,445 644,445 2,661,524 32,274 (77,753) 514,546 0 0 0 0 2,661,524 2,693,798 2,405,985 2,998,284 Total Requirements 30,409 756,879 1,244,561 644,445 Note: Numbers may not add due to rounding.