HomeMy WebLinkAbout2024-08-19 - Agendas - Final Board of Trustees August 19, 2024 4 pm AGENDA Regular Meeting – Walker Room Sallie Overbey, President Apr 2028 Rob Qualls Apr 2026 Stan Rodgers, Vice-President Apr 2027 Bret Park Apr 2028 Ann Wilbourn, Treasurer Apr 2027 Carla Davis Apr 2025 Barry Bryan, Secretary Apr 2029 Our mission is to strengthen our community and empower our citizens through free and public access to knowledge. I. Call to Order II. Roll Call III. Minutes: Approval of minutes from June 17, 2024 – pages 1-2 IV. Reports A. Key Upcoming Events – page 3 B. Mission Moment C. Library Administration 1. Management Reports a. Performance Measures – pages 4-5 b. Strategic Plan progress through July 2024 – pages 6-8 2. Financial reports – pages 9-20 3. Informational a. FOIA report b. Bookmobile report c. Act 372 update d. Salary survey report e. Summer Reading report f. HVAC replacement g. 2025 Budget progress – page 21 h. Health benefits update i. Deli update j. Oct/Nov Board retreat k. Friends donation l. Staff & professional development m. New staff & recognition D. Fayetteville Public Library Foundation: monthly report – pages 22-28 E. Friends of the Fayetteville Public Library V. New business A. Consent items 1. Approve 2025 Closed Days – pages 29-30 2. Resolution updating the Accounting staff contacts – page 31 3. New Foundation Board Directors – pages 32-34 B. Discussion items 1. Bylaws review – pages 35-37 2. Acceptance of new health benefits – pages 38-41 3. Compensation study plan – pages 42-43 4. Compensation policy – pages 44-52 VI. Public Comment Adjournment 1 2 Maker Faire NWA 2024 Saturday, September 7, 9am–5pm Maker Faire NWA is returning for its third year! Maker Faire NWA brings together makers from all over the region for demonstrations, workshops, performances and more. This event is for all ages, and there will be a little something for everyone. Yoga in the Glade Monday, September 9 & 16, 6pm Enjoy yoga in the fresh air of the library’s Gathering Glade! This class is suitable for all levels of yoga practitioners. In the event of rain or excessive heat, these yoga sessions will be offered inside. Pollinator Talks Saturday, September 14, 1pm Sara Wittenberg, Eric Fuselier, and Coleman Little, local pollinator experts, will present talks on various components of planning a bee friendly garden. Topics include healthy soil, plant choices, garden design and more. Banned Books Week Celebration – Art Reveal & Reception Wednesday, September 18, 6pm In honor of Banned Books Week, artists submitted original art representing books or authors who have been challenged, censored or banned. Their submissions represent the ongoing struggle for intellectual freedom and the dangers of censorship. At this celebration, winners of the 2024 Banned Books Week Open Artist Call will be recognized, and their winning artwork will be revealed. Story Time at the Park (Ages 0–6) Monday, September 23, 10am at Walker Park Wednesday, September 25, 10am at Gulley Park Friday, September 27, 10am at Wilson Park While the library is closed for scheduled building maintenance, we’re bringing the Bookmobile and story times to Fayetteville Parks! Join us for three special story times at Walker, Gulley and Wilson Parks. Bring a blanket and enjoy some library fun with us. History of the Fayetteville Square – Downtown Walking Tour with JB Hogan Saturday, September 28, 12:30pm Take a tour of the Fayetteville Square with JB Hogan, prolific writer and historian. Wear comfortable shoes, bring water, and be ready to absorb a lot of entertaining Fayetteville history that you might not have heard about! True Lit: An Evening with Nic Stone Tuesday, October 15, 6pm Join us for an evening with acclaimed author Nic Stone as part of the library’s True Lit Literary Festival. Nic Stone burst onto the literary scene with her debut novel, “Dear Martin,” which quickly became a New York Times bestseller and earned widespread acclaim for its candid exploration of race relations in America. Her subsequent works, including “Dear Justyce” and “Jackpot,” have continued to captivate readers with their authentic characters and timely storytelling. Pearl’s Books will be on- site to sell books, and a signing will follow the presentation. True Lit is in collaboration with the Fayetteville Public Library, Fayetteville Public Schools, Fayetteville Public Education Foundation, and University of Arkansas Program in Creative Writing and Translation. faylib.org / 401 W. Mountain St., Fayetteville, AR 72701 Key Upcoming Events 3 FPL Performance Report: July 2024 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 24YTD 23YTD CHANGE Circulation 100,145 96,883 91,467 85,451 88,490 103,179 109,050 0 0 0 0 0 674,665 668,051 0.99% Physical Checkouts 69,169 68,564 62,390 57,530 59,622 73,423 77,699 0 0 0 0 0 468,397 499,249 -6.18% Digital Checkouts 30,976 28,319 29,077 27,921 28,868 29,756 31,351 0 0 0 0 0 206,268 168,802 22.20% Reference Queries 5,539 6,031 6,486 4,858 7,181 8,958 8,612 0 0 0 0 0 47,665 40,540 17.58% Total Collection Size 360,022 359,176 353,103 352,632 352,462 353,188 352,646 0 0 0 0 0 352,646 406,822 -13.32% Physical Collection 286,668 285,888 279,664 279,611 279,486 279,820 278,929 0 0 0 0 0 278,929 336,092 -17.01% Digital Collection 73,354 73,288 73,439 73,021 72,976 73,368 73,717 0 0 0 0 0 73,717 70,730 4.22% Total Items Added 1,490 1,913 659 1,931 1,964 1,646 2,240 0 0 0 0 0 11,843 21,858 -45.82% New Card Registrations 875 841 1,646 993 926 1,235 1,165 0 0 0 0 0 7,681 5,230 46.86% Cardholders 79,423 80,298 81,884 82,411 83,079 84,102 85,054 0 0 0 0 0 85,054 84,403 0.77% Visits 44,587 45,709 38,021 43,024 42,543 0 0 0 0 0 0 0 213,884 336,550 Library Programs 179 276 225 207 221 178 209 0 0 0 0 0 1,495 1,108 34.93% Library Attendance 3,830 5,503 5,222 4,222 3,330 12,368 8,104 0 0 0 0 0 42,579 43,651 -2.46% Outreach Attendance 426 755 962 1,218 1,847 1,423 250 0 0 0 0 0 6,881 7,200 -4.43% Online Views 7,296 10,790 11,367 9,671 9,032 11,989 9,583 0 0 0 0 0 69,728 54,206 28.64% Meeting Room Usage 140 226 184 186 245 140 111 0 0 0 0 0 1,232 414 197.58% Study Room Usage 844 1,137 994 1,024 949 780 855 0 0 0 0 0 6,583 6,117 7.62% Event Center Usage 11 14 21 26 13 31 24 0 0 0 0 0 140 55 154.55% Teaching Kitchen Usage 34 33 32 35 33 17 14 0 0 0 0 0 198 107 85.05% CFI Room/Suite Usage 458 481 430 479 560 548 576 0 0 0 0 0 3,532 3,555 -0.65% Volunteers 303 265 285 285 315 321 322 0 0 0 0 0 322 300 7.33%' Volunteer Hours 747 839 805 950 1,057 1,639 1,405 0 0 0 0 0 7.442 5,007 48.63% Computer Sessions 2,334 2,610 2,602 2,289 2,430 2,647 3,303 0 0 0 0 0 18,215 18,380 -0,90% Holds Filled 3,366 3,742, 2,205 3,542 3,547 3,928 4,856 0 0 0 0 0 25,186 34,718 -27.46% eFPL Usage 52,459 49,837 23,630 13,256 43,425 46,480 49,188 0 0 0 0 0 278,275 359,174 -22.52% Bandwidth Consumed 8,950 12,490 9,570 12,,040 11,060 9,860 12,240 0 0 0 0 0 76,210 48,890 55.88% Unique Users 7,767 9,849 8,557 8,700 8,765 7,725 7,259 0 0 0 0 0 58,622 60,210 -2.64% Deli Statistics Guests/orders 1,792 1,949 1,878 1,583 1,843 2,074 1,883 0 0 0 0 0 13,002 15,269 -14.85% Gross sales $15,721.64 $16,220.16 $16,566.66 $13,383.18 $15,563.34 $17,833.64 $16,317.17 $111,605,79 $142,919.69 -21.91% 4 5 6 7 8 9 10 11 Preliminary: Subject to Audit Year Ending Year To Date Period Ending Month Ending 12/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 ANNUAL BUDGET ORIGINAL BUDGET IN-YEAR BUDGET ADJ Amended Budget YTD Budget YTD ACTUAL ACTUAL ENCUMBRANCES REMAINING BUDGET % Used/Rec'd Revenue Local Tax Support 4882 - Ext. Transfer from City - Millage 5,734,097.00 0.00 5,734,097.00 2,745,237.00 2,787,803.31 163,558.72 0.00 2,946,294 48.6 % Local Tax Support 5,734,097.00 0.00 5,734,097.00 2,745,237.00 2,787,803.31 163,558.72 0.00 2,946,294 48.6 % City of Fayetteville Transfers 4880 - Ext. Transfer from City - Operations 1,812,401.00 0.00 1,812,401.00 1,057,236.00 1,057,233.90 151,033.42 0.00 755,167 58.3 % 4884 - Ext. Transfer from City - Books 654,000.00 0.00 654,000.00 381,500.00 381,500.00 54,500.00 0.00 272,500 58.3 % 4886 - Ext. Transfer from City - Computers 152,000.00 0.00 152,000.00 152,000.00 152,000.00 0.00 0.00 0 100.0 % City of Fayetteville Transfers 2,618,401.00 0.00 2,618,401.00 1,590,736.00 1,590,733.90 205,533.42 0.00 1,027,667 60.8 % State Aid & Grant Revenue 4010 - State Library Turnback 141,150.00 2.00 141,152.00 70,576.00 83,611.00 0.00 0.00 57,541 59.2 % State Aid & Grant Revenue 141,150.00 2.00 141,152.00 70,576.00 83,611.00 0.00 0.00 57,541 59.2 % Charges for Services 4202 - Rental Income 28,500.00 0.00 28,500.00 16,625.00 6,707.57 957.07 0.00 21,792 23.5 % 4203 - Nontaxable Rental Fees 0.00 0.00 0.00 0.00 20,015.64 4,505.00 0.00 (20,016)0.0 % 4205 - Copier & Printer Income 3,000.00 0.00 3,000.00 1,750.00 3,164.20 451.31 0.00 (164) 105.5 % 4220 - Merchandise Sales 0.00 0.00 0.00 0.00 660.96 119.00 0.00 (661)0.0 % 4240 - Discounts 0.00 0.00 0.00 0.00 (159.77)10.00 0.00 160 0.0 % 4302 - Fees 62,500.00 0.00 62,500.00 36,460.00 52,488.33 8,724.04 0.00 10,012 84.0 % 4995 - Cash Over and Short 0.00 0.00 0.00 0.00 5.34 (2.54)0.00 (5)0.0 % Charges for Services 94,000.00 0.00 94,000.00 54,835.00 82,882.27 14,763.88 0.00 11,118 88.2 % Contributions & Donations 4650 - Contributions - Undesignated 0.00 0.00 0.00 0.00 649.36 250.40 0.00 (649)0.0 % Contributions & Donations 0.00 0.00 0.00 0.00 649.36 250.40 0.00 (649)0.0 % Miscellaneous Revenue 4992 - Misc. Revenue 0.00 0.00 0.00 0.00 (1,442.17)0.00 0.00 1,442 0.0 % 4993 - Insurance Proceeds 0.00 1,040,000.00 1,040,000.00 1,040,000.00 439,060.18 256,086.61 0.00 600,940 42.2 % Miscellaneous Revenue 0.00 1,040,000.00 1,040,000.00 1,040,000.00 437,618.01 256,086.61 0.00 602,382 42.1 % Transfers In 4899 - Ext. Transfer In 118,246.00 0.00 118,246.00 59,123.00 0.00 0.00 0.00 118,246 0.0 % Library Operations Fayetteville Public Library Budget to Actual (Unrestricted) As of July 31, 2024 This report reflects only unrestricted funds within Fund 10.12 Preliminary: Subject to Audit Year Ending Year To Date Period Ending Month Ending 12/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 ANNUAL BUDGET ORIGINAL BUDGET IN-YEAR BUDGET ADJ Amended Budget YTD Budget YTD ACTUAL ACTUAL ENCUMBRANCES REMAINING BUDGET % Used/Rec'd Transfers In 118,246.00 0.00 118,246.00 59,123.00 0.00 0.00 0.00 118,246 0.0 % Investment Earnings Investment Income 0.00 0.00 0.00 0.00 31,489.61 5,772.96 0.00 (31,490)0.0 % Total Investment Earnings 0.00 0.00 0.00 0.00 31,489.61 5,772.96 0.00 (31,490)0.0 % Use of Reserves 39,000.00 0.00 39,000.00 39,000.00 0.00 0.00 0.00 39,000 0.0 % Total Revenue 8,744,894.00 1,040,002.00 9,784,896.00 5,599,507.00 5,014,787.46 645,965.99 0.00 4,770,109 51.3 % Expenditures Personnel Services Salary & Wages 5100 - Salaries 1,980,456.00 0.00 1,980,456.00 1,155,273.00 1,205,363.04 182,172.50 0.00 775,093 60.9 % 5102 - Hourly Wages 2,066,897.00 (55,538.00) 2,011,359.00 1,173,291.00 931,175.86 135,752.79 0.00 1,080,183 46.3 % 5103 - Overtime 0.00 0.00 0.00 0.00 14,657.24 1,421.92 0.00 (14,657)0.0 % 5105 - Vacation Pay 0.00 0.00 0.00 0.00 100,781.73 11,865.80 0.00 (100,782)0.0 % 5106 - Sick Pay 0.00 0.00 0.00 0.00 44,488.15 6,402.40 0.00 (44,488)0.0 % 5112 - Holiday Pay 0.00 0.00 0.00 0.00 54,735.54 9,163.32 0.00 (54,736)0.0 % 5113 - Social Security Taxes 307,259.00 2,364.00 309,623.00 180,621.00 168,729.16 24,915.38 0.00 140,894 54.5 % 5115 - Unemployment 7,130.00 0.00 7,130.00 7,130.00 6,799.12 159.13 0.00 331 95.4 % 5116 - Workers Compensation 23,000.00 15,400.00 38,400.00 38,400.00 38,368.00 0.00 0.00 32 99.9 % Total Salary & Wages 4,384,742.00 (37,774.00)4,346,968.00 2,554,715.00 2,565,097.84 371,853.24 0.00 1,781,870 59.0 % Employee Benefits 5109 - LT Disability 12,030.00 0.00 12,030.00 7,021.00 (252.26) (38.76)0.00 12,282 (2.1) % 5110 - Salary Contingency 94,040.00 0.00 94,040.00 94,040.00 0.00 0.00 0.00 94,040 0.0 % 5120 - Health Insurance 405,404.00 0.00 405,404.00 236,488.00 205,332.07 30,314.87 0.00 200,072 50.6 % 5121 - Health Savings Account 58,735.00 0.00 58,735.00 34,265.00 29,900.66 4,311.98 0.00 28,834 50.9 % 5122 - Life Insurance 11,812.00 0.00 11,812.00 6,895.00 11,613.68 1,763.24 0.00 198 98.3 % 5125 - AD&D 1,970.00 0.00 1,970.00 1,155.00 1,335.27 198.63 0.00 635 67.8 % 5135 - Retirement Saving Plan 339,941.00 0.00 339,941.00 198,310.00 185,856.20 27,198.02 0.00 154,085 54.7 % Employee Benefits 923,932.00 0.00 923,932.00 578,174.00 433,785.62 63,747.98 0.00 490,146 46.9 % Total Personnel Services 5,308,674.00 (37,774.00)5,270,900.00 3,132,889.00 2,998,883.46 435,601.22 0.00 2,272,017 56.9 % Library Operations Fayetteville Public Library Budget to Actual (Unrestricted) As of July 31, 2024 This report reflects only unrestricted funds within Fund 10.13 Preliminary: Subject to Audit Year Ending Year To Date Period Ending Month Ending 12/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 ANNUAL BUDGET ORIGINAL BUDGET IN-YEAR BUDGET ADJ Amended Budget YTD Budget YTD ACTUAL ACTUAL ENCUMBRANCES REMAINING BUDGET % Used/Rec'd Materials & Supplies 5200 - Office Supplies & Printing 89,660.00 0.00 89,660.00 58,213.00 33,782.55 4,523.78 0.00 55,877 37.7 % 5201 - Small Tools & Equipment 16,500.00 0.00 16,500.00 8,750.00 14,297.20 1,010.01 0.00 2,203 86.6 % 5203 - Medical Supplies 4,000.00 0.00 4,000.00 2,200.00 615.59 0.00 0.00 3,384 15.4 % 5210 - Food & Catering for Events 7,465.00 0.00 7,465.00 4,535.00 1,422.46 117.86 0.00 6,043 19.1 % 5218 - Cleaning Supplies 58,000.00 0.00 58,000.00 35,500.00 19,706.13 362.75 5,401.61 32,892 34.0 % 5220 - Tech Supplies 18,280.00 0.00 18,280.00 12,055.00 9,972.89 682.40 0.00 8,307 54.6 % 5224 - Landscape Materials 10,000.00 0.00 10,000.00 5,000.00 1,166.10 0.00 9,947.00 (1,113) 11.7 % 5226 - Merchandise for Resale 500.00 0.00 500.00 500.00 0.00 0.00 0.00 500 0.0 % 5230 - Computer Hardware Supplies 51,000.00 0.00 51,000.00 31,750.00 41,918.28 3,613.03 0.00 9,082 82.2 % 5235 - Signage 9,340.00 0.00 9,340.00 6,960.00 1,407.75 187.54 0.00 7,932 15.1 % 5236 - Computer Software - Application 0.00 0.00 0.00 0.00 0.00 0.00 2,000.00 (2,000)0.0 % 5250 - On-line Database 0.00 0.00 0.00 0.00 16,685.95 3,560.95 (256.12) (16,430)0.0 % 5251 - Programming Materials & Supplies 90,470.00 0.00 90,470.00 59,604.00 53,862.11 18,429.66 14,033.03 22,575 59.5 % 5252 - Repair Parts & Damaged Repairs 3,250.00 0.00 3,250.00 2,375.00 477.37 0.00 0.00 2,773 14.7 % 5255 - Circulating Equipment 0.00 0.00 0.00 0.00 27.43 27.43 0.00 (27)0.0 % 5258 - Parenting Kit 2,000.00 0.00 2,000.00 1,274.00 1,931.00 764.54 0.00 69 96.6 % 5260 - Print Books 376,996.00 1,711.00 378,707.00 249,763.00 157,213.07 41,230.30 0.00 221,494 41.5 % 5265 - E-Book 138,491.00 0.00 138,491.00 88,491.00 100,072.17 24,516.59 0.00 38,419 72.3 % 5270 - E-Book Consortium 0.00 0.00 0.00 0.00 6,505.55 0.00 0.00 (6,506)0.0 % 5280 - Periodicals 7,500.00 0.00 7,500.00 7,500.00 7,113.73 29.58 0.00 386 94.8 % 5285 - Film/DVD 40,260.00 142.00 40,402.00 27,939.00 16,542.28 2,380.30 0.00 23,860 40.9 % 5287 - Audio 10,300.00 51.00 10,351.00 6,607.00 6,871.14 1,351.64 0.00 3,480 66.4 % 5290 - Music 1,800.00 0.00 1,800.00 1,148.00 449.83 0.00 0.00 1,350 25.0 % 5295 - Gaming Supplies 1,500.00 0.00 1,500.00 956.00 553.37 24.99 0.00 947 36.9 % 5900 - Miscellaneous Expense 0.00 0.00 0.00 0.00 3,178.80 0.00 0.00 (3,179)0.0 % 5904 - Incident Repair or Replacement 0.00 1,040,000.00 1,040,000.00 1,040,000.00 183,098.59 103,879.19 96,223.38 760,678 17.6 % Materials & Supplies 937,312.00 1,041,904.00 1,979,216.00 1,651,120.00 678,871.34 206,692.54 127,348.90 1,172,996 34.3 % Services & Charges 5301 - Advertisement 15,970.00 0.00 15,970.00 11,290.00 4,197.60 0.00 0.00 11,772 26.3 % 5303 - Subscriptions, Publications and Dues 103,852.00 14,106.00 117,958.00 75,823.00 38,467.71 6,460.98 62,208.96 17,281 32.6 % 5305 - Postage 20,000.00 0.00 20,000.00 11,670.00 11,225.31 0.00 0.00 8,775 56.1 % 5346 - Drop Box Services 16,800.00 0.00 16,800.00 9,800.00 8,700.00 0.00 8,600.00 (500) 51.8 % 5350 - Programming Services 200,744.00 14,000.00 214,744.00 162,819.00 92,936.37 8,056.58 21,600.00 100,208 43.3 % 5358 - Hospitality 1,400.00 0.00 1,400.00 700.00 0.00 0.00 0.00 1,400 0.0 % Library Operations Fayetteville Public Library Budget to Actual (Unrestricted) As of July 31, 2024 This report reflects only unrestricted funds within Fund 10.14 Preliminary: Subject to Audit Year Ending Year To Date Period Ending Month Ending 12/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 ANNUAL BUDGET ORIGINAL BUDGET IN-YEAR BUDGET ADJ Amended Budget YTD Budget YTD ACTUAL ACTUAL ENCUMBRANCES REMAINING BUDGET % Used/Rec'd 5360 - Mileage Reimbursement 2,100.00 0.00 2,100.00 1,188.00 526.84 0.00 0.00 1,573 25.1 % 5361 - Training & Development 53,947.00 10,000.00 63,947.00 51,007.00 20,421.24 2,800.00 0.00 43,526 31.9 % 5362 - Travel 52,778.00 0.00 52,778.00 45,253.00 30,810.96 3,831.85 0.00 21,967 58.4 % 5375 - Employee Recognition 8,200.00 0.00 8,200.00 4,600.00 4,185.32 0.00 0.00 4,015 51.0 % 5385 - Board & Volunteer Recognition 4,000.00 0.00 4,000.00 1,100.00 377.69 0.00 0.00 3,622 9.4 % 5390 - Uniform Expense 12,600.00 0.00 12,600.00 7,350.00 5,624.21 1,188.56 0.00 6,976 44.6 % 5424 - Equipment Lease/Rental 181,824.00 0.00 181,824.00 105,895.00 89,911.98 0.00 0.00 91,912 49.5 % 5421 - Insurance - Building 234,200.00 0.00 234,200.00 229,200.00 197,190.23 0.00 0.00 37,010 84.2 % 5422 - Insurance - Liability 22,700.00 0.00 22,700.00 22,700.00 19,391.00 6,832.00 0.00 3,309 85.4 % 5423 - Other Rental 13,200.00 0.00 13,200.00 7,700.00 7,840.00 980.00 0.00 5,360 59.4 % 5394 - Admin & Management Fees 32,800.00 0.00 32,800.00 16,400.00 13,250.25 0.00 0.00 19,550 40.4 % 5395 - Bank Service Charges 28,010.00 0.00 28,010.00 19,010.00 13,891.57 1,682.43 0.00 14,118 49.6 % 5905 - Operating Contingency 120,000.00 0.00 120,000.00 120,000.00 0.00 0.00 0.00 120,000 0.0 % Total Services & Charges 1,125,125.00 38,106.00 1,163,231.00 903,505.00 558,948.28 31,832.40 92,408.96 511,874 48.1 % 5340 - Audit 62,400.00 0.00 62,400.00 62,400.00 40,000.00 0.00 10,000.00 12,400 64.1 % 5341 - Legal 8,000.00 0.00 8,000.00 8,000.00 9,559.50 2,202.00 0.00 (1,560) 119.5 % 5344 - Contract Services 285,804.00 21,221.00 307,025.00 247,756.00 106,467.64 (59.35) 120,824.00 79,733 34.7 % Purchased Professional and Technical Ser- vices 356,204.00 21,221.00 377,425.00 318,156.00 156,027.14 2,142.65 130,824.00 90,574 41.3 % 5310 - Telecommunications 30,000.00 0.00 30,000.00 17,500.00 19,804.04 2,764.41 0.00 10,196 66.0 % 5312 - Natural Gas 57,500.00 0.00 57,500.00 43,000.00 14,604.77 467.37 0.00 42,895 25.4 % 5314 - Electricity 262,000.00 0.00 262,000.00 148,000.00 141,164.59 27,212.86 0.00 120,835 53.9 % 5316 - Municipal Water 13,900.00 0.00 13,900.00 7,950.00 11,236.22 3,966.60 0.00 2,664 80.8 % Utilities 363,400.00 0.00 363,400.00 216,450.00 186,809.62 34,411.24 0.00 176,590 51.4 % Services & Charges 1,844,729.00 59,327.00 1,904,056.00 1,438,111.00 901,785.04 68,386.29 223,232.96 779,038 47.4 % Maintenance 5401 - Building Maintenance 57,000.00 3,612.00 60,612.00 38,112.00 40,898.08 8,542.16 0.00 19,714 67.5 % 5405 - Landscape Maintenance 4,000.00 0.00 4,000.00 3,500.00 15,396.26 5,285.56 0.00 (11,396) 384.9 % 5410 - Equipment Maintenance 89,455.00 0.00 89,455.00 86,355.00 62,074.24 195.50 0.00 27,381 69.4 % 5415 - Software Maintenance 1,000.00 0.00 1,000.00 1,000.00 571.22 0.00 0.00 429 57.1 % Maintenance 151,455.00 3,612.00 155,067.00 128,967.00 118,939.80 14,023.22 0.00 36,127 76.7 % Transfers Out 6020 - Int. Transfer Out 0.00 75,000.00 75,000.00 37,500.00 0.00 0.00 0.00 75,000 0.0 % Transfers Out 0.00 75,000.00 75,000.00 37,500.00 0.00 0.00 0.00 75,000 0.0 % Library Operations Fayetteville Public Library Budget to Actual (Unrestricted) As of July 31, 2024 This report reflects only unrestricted funds within Fund 10.15 Preliminary: Subject to Audit Year Ending Year To Date Period Ending Month Ending 12/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 ANNUAL BUDGET ORIGINAL BUDGET IN-YEAR BUDGET ADJ Amended Budget YTD Budget YTD ACTUAL ACTUAL ENCUMBRANCES REMAINING BUDGET % Used/Rec'd Capital Outlay 534,435.00 44,427.00 578,862.00 514,016.00 329,849.44 61,996.12 4,947.10 244,065 57.0 % Total Expenditures 8,776,605.00 1,186,496.00 9,963,101.00 6,902,603.00 5,028,329.08 786,699.39 355,528.96 4,579,243 50.5 % Change in Net Assets (31,711.00)(146,494.00)(178,205.00)(1,303,096.00)(13,541.62)(140,733.40)(355,528.96)190,866 7.6 % Library Operations Fayetteville Public Library Budget to Actual (Unrestricted) As of July 31, 2024 This report reflects only unrestricted funds within Fund 10.16 Preliminary: Subject to Audit 10--Library Operations 15--Expansion - Operations 20--Long Term - Reserve 30--Facility Reserve 40--Furniture & Equipment Reserve 50--Technology Equipment Reserve 70--Bond Debt Service Fund 80--Food Services 85--Events All Funds Year Ending Year To Date 12/31/2024 Remaining Budget Amended Budget YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual Includes Encumbrance Revenue Local Tax Support 8,543,097.00 2,787,803.31 0.00 0.00 0.00 0.00 0.00 1,338,143.51 0.00 0.00 4,125,946.82 4,417,150.18 City of Fayetteville Transfers 2,618,401.00 1,590,733.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,590,733.90 1,027,667.10 State Aid & Grant Revenue 601,584.00 549,301.29 0.00 0.00 0.00 0.00 0.00 0.00 26,253.18 0.00 575,554.47 26,029.53 Charges for Services 702,000.00 82,882.27 0.00 0.00 0.00 0.00 0.00 0.00 127,702.03 160,992.22 371,576.52 330,423.48 Contributions & Donations 4,000.00 91,400.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 91,400.39 (87,400.39) Miscellaneous Revenue 1,040,000.00 437,773.96 0.00 0.00 0.00 0.00 0.00 0.00 372.95 3.67 438,150.58 601,849.42 Transfers In 468,246.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 468,246.00 Investment Earnings Investment Income 0.00 31,489.61 15,792.64 27,483.11 18,194.70 6,112.91 6,505.43 0.00 236.87 0.00 105,815.27 (105,815.27) Gain/Loss - Realized 0.00 0.00 0.00 0.00 0.00 (2.26)0.00 0.00 0.00 0.00 (2.26)2.26 Gain/Loss - Unrealized 0.00 0.00 0.00 18,373.03 16,553.49 1,056.91 3,936.58 0.00 0.00 0.00 39,920.01 (39,920.01) Investment Management Fees & Expenses 0.00 0.00 0.00 (3,205.00)(2,419.00)(510.00)(811.00)0.00 0.00 0.00 (6,945.00)6,945.00 Total Investment Earnings 0.00 31,489.61 15,792.64 42,651.14 32,329.19 6,657.56 9,631.01 0.00 236.87 0.00 138,788.02 (138,788.02) Use of Reserves 189,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 189,000.00 Total Revenue 14,166,328.00 5,571,384.73 15,792.64 42,651.14 32,329.19 6,657.56 9,631.01 1,338,143.51 154,565.03 160,995.89 7,332,150.70 6,834,177.30 Expenditures Personnel Services Salary & Wages 4,913,854.00 2,655,627.28 0.00 0.00 0.00 0.00 0.00 0.00 108,277.56 53,790.74 2,817,695.58 2,096,158.42 Employee Benefits 1,013,771.00 446,776.00 0.00 0.00 0.00 0.00 0.00 0.00 18,892.05 6,443.03 472,111.08 541,659.92 Total Personnel Services 5,927,625.00 3,102,403.28 0.00 0.00 0.00 0.00 0.00 0.00 127,169.61 60,233.77 3,289,806.66 2,637,818.34 Materials & Supplies 2,504,580.00 724,602.64 0.00 0.00 0.00 0.00 2,141.22 0.00 116,842.35 189.58 843,775.79 1,502,931.82 Services & Charges 2,241,953.00 1,065,217.43 0.00 0.00 0.00 0.00 0.00 0.00 17,692.30 9,398.25 1,092,307.98 920,577.06 Maintenance 161,545.00 124,799.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 124,799.68 36,745.32 Transfers Out 3,084,000.00 0.00 0.00 0.00 0.00 0.00 0.00 1,338,143.51 0.00 0.00 1,338,143.51 1,745,856.49 Capital Outlay 2,064,835.00 494,982.43 0.00 0.00 159,104.78 0.00 243,569.92 0.00 89,973.17 1,480.80 989,111.10 264,902.41 Total Expenditures 15,984,538.00 5,512,005.46 0.00 0.00 159,104.78 0.00 245,711.14 1,338,143.51 351,677.43 71,302.40 7,677,944.72 7,108,831.44 Change in Net Assets (1,818,210.00)59,379.27 15,792.64 42,651.14 (126,775.59)6,657.56 (236,080.13)0.00 (197,112.40)89,693.49 (345,794.02)(274,654.14) Library Fayetteville Public Library Summarized Budget to Actual As of July 31, 2024 Filter tab and prompt selections: As of date: 07/31/2024 ; Department: All; Include subdimensions: Off; Hide inactives: Off ; Fund: Library; Include subdimensions: Off; Hide inactives: Off ; Client or Donor: All; Include subdimensions: Off ; Client or Donor type: All; Include subdimensions: Off ; Vendor: All; Include subdimensions: Off ; Vendor type: All; Include subdimensions: Off ; Employee: All; Include subdimensions: Off ; Employee type: All; Include subdimensions: Off ; Item: All ; Product line: All; Include subdimensions: Off ; Restriction: All; Include subdimensions: Off ; Project: All; Include subdimensions: Off ; Project type: All; Include subdimensions: Off ; Created on 08/08/2024, 5:23 AM PST Page 1 17 Preliminary: Subject to Audit 10--Library Operations 15--Expansion - Operations 20--Long Term - Reserve 30--Facility Reserve 40--Furniture & Equipment Reserve 50--Technology Equipment Reserve 60--Capital Construction Fund 70--Bond Debt Service Fund 80--Food Services 85--Events All Funds Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 Assets Cash & Investments 1003 - Petty Cash 3,074 0 0 0 0 0 0 0 675 0 3,749 1009 - Bank of Fayetteville - FPL 74,032 0 0 0 0 0 0 0 0 (274)73,757 1020 - Arvest - Library Operations 794,800 0 0 0 0 0 0 0 0 1,333 796,133 1030 - First Security - FPL 265,940 0 0 0 0 0 0 0 0 0 265,940 1050 - Arvest - Food Services 0 0 0 0 0 0 0 0 60,699 0 60,700 1099 - Datapath Held Deposit 1,200 0 0 0 0 0 0 0 0 0 1,200 1100 - Schwab FPL - Operating 1,486,729 0 0 0 0 0 0 0 0 0 1,486,729 1105 - Schwab FPL - Expansion O&M 0 636,003 0 0 0 0 0 0 0 0 636,003 1110 - Schwab FPL - Long Term 0 0 1,748,059 0 0 0 0 0 0 0 1,748,059 1115 - Schwab FPL - Facilities Replace- ment 0 0 0 1,230,075 0 0 0 0 0 0 1,230,075 1120 - Schwab FPL - Furniture & Equip.0 0 0 0 278,167 0 0 0 0 0 278,167 1125 - Schwab FPL - Technology 0 0 0 0 0 258,613 0 0 0 0 258,613 1130 - Schwab FPL - Expansion Capital 0 0 0 0 0 0 4 0 0 0 4 Total Cash & Investment 2,625,775 636,003 1,748,059 1,230,075 278,167 258,613 4 0 61,374 1,059 6,839,129 Receivables 1240 - Accounts Receivable 6,916 0 0 0 0 0 0 0 13,696 112,063 132,676 1243 - Grants Receivable 82,511 0 0 0 0 0 0 0 9,291 0 91,802 1260 - Payroll Tax Refund Receivable (793)0 0 0 0 0 0 0 0 0 (793) 1265 - Sales Tax Rebate Receivable 1,511 0 0 0 0 0 0 0 0 0 1,511 1270 - Due From Other Funds 238,767 0 76,241 4,802 0 128,726 0 0 2,293 49 450,876 1271 - Due From Other Governments (Millage & Debt Service) 6,308,340 0 0 0 0 0 0 3,028,003 0 0 9,336,343 1275 - 10 Due From 91 345,896 0 0 0 0 0 0 0 0 0 345,896 1277 - 10 Due From 96 2,660 0 0 0 0 0 0 0 0 0 2,660 1279 - 10 Due From 80 495,721 0 0 0 0 0 0 0 0 0 495,721 1280 - 80 Due From 10 0 0 0 0 0 0 0 0 110,274 0 110,275 1281 - 10 Due From 85 393,461 0 0 0 0 0 0 0 0 0 393,460 1282 - 85 Due From 10 0 0 0 0 0 0 0 0 0 568,697 568,697 1285 - 80 Due From 85 0 0 0 0 0 0 0 0 1,347 0 1,346 1286 - 85 Due From 80 0 0 0 0 0 0 0 0 0 8,521 8,521 1400 - Interfund (1,232,239) 3,899,883 (1,115,401)3,787 43,381 365,371 (192,504) (1,772,279)0 0 0 Total Receivables 6,642,751 3,899,883 (1,039,160)8,589 43,381 494,097 (192,504)1,255,724 136,901 689,330 11,938,991 Prepaid Expenses 1500 - Prepaid Expenses 127,081 0 0 0 0 0 0 0 0 0 127,082 Prepaid Expenses 127,081 0 0 0 0 0 0 0 0 0 127,082 Fixed Assets Depreciable Assets 1801 - Building 22,179,728 0 0 0 0 0 0 0 0 0 22,179,727 1802 - Vehicles 83,458 0 0 0 0 0 0 0 0 0 83,458 1805 - Software 312,124 0 0 0 0 0 0 0 0 0 312,125 1811 - Books & Publications 7,001,438 0 0 0 0 0 0 0 0 0 7,001,437 1813 - Equipment 3,386,541 0 0 0 0 0 0 0 0 0 3,386,541 1815 - Furniture & Fixtures 66,652 0 0 0 0 0 0 0 0 60,681 127,334 1890 - Construction In Progress (CIP)93,116 0 0 0 0 0 0 0 0 0 93,115 1999 - Accumulated Depreciation (16,982,630)0 0 0 0 0 0 0 0 (12,281) (16,994,910) Total Depreciable Assets 16,140,427 0 0 0 0 0 0 0 0 48,400 16,188,827 Non Depreciable Assets 1,605,676 0 0 0 0 0 0 0 0 0 1,605,676 Library Balance Sheet Fayetteville Public Library Created on 08/08/2024, 5:37 AM PST Page 1 18 Preliminary: Subject to Audit 10--Library Operations 15--Expansion - Operations 20--Long Term - Reserve 30--Facility Reserve 40--Furniture & Equipment Reserve 50--Technology Equipment Reserve 60--Capital Construction Fund 70--Bond Debt Service Fund 80--Food Services 85--Events All Funds Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 Total Fixed Assets, Net 17,746,103 0 0 0 0 0 0 0 0 48,400 17,794,503 Total Assets $ 27,141,710 $ 4,535,886 $ 708,899 $ 1,238,664 $ 321,548 $ 752,710 $ (192,500)$ 1,255,724 $ 198,275 $ 738,789 $ 36,699,705 Liabilities and Fund Balances Liabilities Accounts Payable 2001 - Accounts Payable 187,887 0 0 0 0 0 0 0 47,929 0 235,816 2004 - Friends of FPL Pass through 7 0 0 0 0 0 0 0 0 0 8 2005 - FDN Designated Pass Through to FPL (189,264)0 0 0 0 0 0 0 0 0 (189,264) 2007 - FPL CentreSuite (2,440)0 0 0 0 0 0 0 0 0 (2,440) 2099 - AR State Library Scholarship Pass Through 793 0 0 0 0 0 0 0 0 0 793 2415 - Security Deposits 5,198 0 0 0 0 0 0 0 0 46,400 51,598 2414 - Convenience Fee 46 0 0 0 0 0 0 0 0 0 46 2020 - Accrued Accounts Payable 126,098 0 0 0 0 0 0 0 0 0 126,097 Total Accounts Payable 128,325 0 0 0 0 0 0 0 47,929 46,400 222,654 Salaries & Benefits Payable 2125 - Accrued Salaries & Wages 91,558 0 0 0 0 0 0 0 3,764 1,645 96,966 2130 - Vision Insurance 9 0 0 0 0 0 0 0 0 0 9 2135 - Life, AD&D and LTD 4,693 0 0 0 0 0 0 0 0 0 4,693 2140 - Voluntary Life, STD & AD&D (422)0 0 0 0 0 0 0 0 0 (422) 2145 - Accrued Vacation 262,782 0 0 0 0 0 0 0 3,661 2,246 268,690 2148 - Supplemental Insurance - EE paid 60 0 0 0 0 0 0 0 0 0 60 2150 - Retirement Contributions 84 0 0 0 0 0 0 0 0 0 84 2154 - Federal Withholding Payable 1,068 0 0 0 0 0 0 0 0 0 1,068 2155 - Voluntary Dental Insurance (337)0 0 0 0 0 0 0 0 0 (337) 2160 - Accrued Sick Time 110,771 0 0 0 0 0 0 0 0 819 111,590 2165 - FICA Payable (1,106)0 0 0 0 0 0 0 0 0 (1,106) 2175 - Health Insurance Liability 1,491 0 0 0 0 0 0 0 0 0 1,492 2178 - State Withholding Payable 526 0 0 0 0 0 0 0 0 0 525 2183 - State Unemployment 426 0 0 0 0 0 0 0 0 0 426 2194 - AD&D Insurance (1,171)0 0 0 0 0 0 0 0 0 (1,171) 2196 - Caring Committee (2,512)0 0 0 0 0 0 0 0 0 (2,512) 2197 - Healthy Habits 4,270 0 0 0 0 0 0 0 0 0 4,270 Total Salaries & Benefits Payable 472,190 0 0 0 0 0 0 0 7,425 4,710 484,325 Other Payables 2056 - HMR Tax 0 0 0 0 0 0 0 0 508 51 560 2057 - Sales Tax (23)0 0 0 0 0 0 0 1,612 (80)1,508 Total Other Payables (23)0 0 0 0 0 0 0 2,120 (29)2,068 Deferred Revenue 2410 - Deferred Revenue 366,255 0 0 0 0 0 0 0 0 0 366,254 2411 - Gift Cards 0 0 0 0 0 0 0 0 1,167 0 1,168 Total Deferred Revenue 366,255 0 0 0 0 0 0 0 1,167 0 367,422 Library Balance Sheet Fayetteville Public Library Created on 08/08/2024, 5:37 AM PST Page 2 19 Preliminary: Subject to Audit 10--Library Operations 15--Expansion - Operations 20--Long Term - Reserve 30--Facility Reserve 40--Furniture & Equipment Reserve 50--Technology Equipment Reserve 60--Capital Construction Fund 70--Bond Debt Service Fund 80--Food Services 85--Events All Funds Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 07/31/2024 Due to Other Funds Due to Foundation 37,188 0 0 0 0 0 0 0 0 0 37,188 Due to Library 0 0 0 0 0 0 0 0 495,721 393,460 889,181 Due to Others 206,595 0 0 68,517 0 92,671 77,580 0 3,160 12 448,535 Due to Food Services 110,275 0 0 0 0 0 0 0 0 1,347 111,621 Internal Due To 568,696 0 0 0 0 0 0 0 8,521 0 577,217 Total Due to Other Funds 922,754 0 0 68,517 0 92,671 77,580 0 507,402 394,819 2,063,742 Total Liabilities 1,889,501 0 0 68,517 0 92,671 77,580 0 566,043 445,900 3,140,211 Fund Balance 25,252,209 4,535,886 708,899 1,170,147 321,548 660,039 (270,080)1,255,724 (367,768)292,889 33,559,494 Total Liabilities and Fund Balances $ 27,141,710 $ 4,535,886 $ 708,899 $ 1,238,664 $ 321,548 $ 752,710 $ (192,500)$ 1,255,724 $ 198,275 $ 738,789 $ 36,699,705 Library Balance Sheet Fayetteville Public Library Created on 08/08/2024, 5:37 AM PST Page 3 20 Fayetteville Public Library Budget Planning Timeline 2025 Activity July Budget Packet distributed to Department Managers and Directors. Target budgets set for each department (excludes new personnel requests). July - August Department Managers and Directors return budgets, including capital requests, to Finance for review. August - September Analysis of proposed budgets, which includes meetings with Directors and Managers, to determine additions and cuts. September - October Proposed budget is presented to Executive Director, Department Directors, and Managers. November / December Proposed budget is presented to Executive Director. Consideration and approval of the budget. January Implementation of newly adopted budget. 21 Fayetteville Public Library Foundation General Fund Highlight of Revenue and Expenditures (Preliminary: Subject to Audit) For Month Ended June 30, 2024 This is a summary report focused primarily on Fund 91 (Operations) and Fund 96 (Capital Campaign). Budget Threshold: The percentage of revenue collected, and budget spent should be approximately 50%. Operating (Fund 91) Unrestricted Revenue: • Revenue collected in the month of June 2024 was $248,442. • Revenue collected YTD through June 30, 2024 totals $493,437, which is significantly above target (by $231,804 or 89%), due to $239,060 in insurance proceeds received related to the fire. Without the insurance proceeds, revenue collected YTD totals $254,377, which is $7,256 or 3% below target. Annual fund and event revenue are approx. $11k over budget, bolstering event sponsorships, which are approx. $18k under budget. Chart reflects actual revenue collection compared to year-to-date budget. Chart reflects only annual renewals and outright gifts revenue recorded in GL account 4012 (Annual Fund). Lease Income, $89,912 Annual Fund, $94,091 Event Revenue, $7,925 Event Sponsorship, $43,107 Miscellaneous Revenue, $239,060 0 50,000 100,000 150,000 200,000 250,000 300,000 Lease Income Annual Fund Event Revenue Event Sponsorship Miscellaneous Revenue Revenue Collection: YTD Budget to Actual YTD Budget YTD Actual Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2020 $7,005 $11,105 $2,247 $2,837 ($1,772)$643 $6,483 $2,358 $1,983 $2,388 $1,653 $9,993 2021 $8,038 $2,063 $5,013 $1,250 $11,747 $6,882 $1,567 $3,350 $5,902 $4,393 $7,976 $31,072 2022 $13,360 $1,404 $9,764 $16,257 $6,781 $7,462 $18,638 $5,729 $4,571 $8,076 $17,826 $30,429 2023 $7,793 $15,688 $5,068 $41,386 $9,790 $5,720 $35,208 $4,015 $17,143 $14,332 $22,078 $50,744 2024 $21,419 $3,493 $22,151 $28,930 $14,345 $3,753 ($10,000) $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 Annual Renewals and Outright Gifts 5-Year Trend 22 Chart reflects a 3-year trend of unrestricted operating revenue (excludes lease income and transfers). Foundation Operating (Fund 91) Unrestricted Expenditures: • Year-to-date expenses through May 31, 2024, total $441,391.13. • Overall, spending is more than planned (by $134,717 or 44%). However, this includes $183,208 in fire-related expenditures for the pass-through of insurance proceeds to the library (these revenues received and expenditures recorded should and will agree, but due to a timing difference of when the funds were transferred, the remaining approx. $56k will pass through and hit expenditures in July). Without the fire-related expenditures, spending is less than planned (by $48,491 or 16%). Balance Sheet Highlights (Capital Campaign): • Pledge receivable balance decreased by $320 compared to last month due to pledge payments collected. • Long-term debt balance remained consistent with prior month as no principal payments were made. 0.00 10,000.00 20,000.00 30,000.00 40,000.00 50,000.00 60,000.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Operating Revenue: 4-Year Trend 2021 2022 2023 2024 $113,508 $5,700 $60,850 $36,706 $89,910 $112,127 $184,890 $45,036 $15,252 $84,086 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 200,000 Personnel Materials & Supplies Services & Charges Maintenance Capital Outlay Debt Service Expenses YTD Budget vs. Actual YTD Budget YTD Actual 23 Chart 6: Shows the shortfall between Long term debt and pledge receivables designated to the building expansion. Roof Fire Financial Update: • The Foundation has received $23,420.94 in donations toward the fire through June 30, 2024. • The Foundation has also received $239,060.18 in insurance proceeds through June 30, 2024, and has passed $182,973.57 of those funds to the Library. • Fire-related expenses incurred by the Foundation through June 30, 2024 total $714.08 (excluding bank fees on the donations). 3,774,387 1,196,050 -2,578,337($3,000,000) ($2,000,000) ($1,000,000) $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 Jun-2024 Capital Campaign Shortfall Comparison: LT Debt vs. Pledge Receivable Note : Chart does not reflects revenue received from land sale, $544,700, as this revenue will be collected over a 5-year span LT Debt Balances Pledge Receivable (Fund 96) Short Fall 24 Preliminary: Subject to Audit 06/30/2024 ANNUAL BUDGET ORIGINAL BUDGET IN-YEAR BUDGET ADJ Amended Budget YTD Budget YTD ACTUAL CURRENT MONTH ACTUAL REMAINING BUDGET % COLLECTED/ SPENT Revenue 4201 - Lease Income 179,824.00 0.00 179,824.00 89,914.00 89,911.98 0.00 89,912 50.0 % Operating Revenue 4012 - Annual Fund 176,120.00 0.00 176,120.00 88,062.00 94,090.65 3,752.51 82,029 53.4 % 4019 - Event Revenue 2,755.00 0.00 2,755.00 2,755.00 7,924.56 0.00 (5,170) 287.6 % 4020 - Event Sponsorships 60,925.00 0.00 60,925.00 60,925.00 43,107.41 0.00 17,818 70.8 % Miscellaneous Revenue 0.00 0.00 0.00 0.00 239,060.18 239,060.18 (239,060)0.0 % Investment Earnings 39,949.00 0.00 39,949.00 19,977.00 19,342.12 5,629.67 20,607 48.4 % Total Revenue 459,573.00 0.00 459,573.00 261,633.00 493,436.90 248,442.36 (33,864)107.4 % Expenditures Salary & Wages 182,056.00 0.00 182,056.00 91,026.00 92,047.07 15,158.08 90,009 50.6 % Employee Benefits 44,963.00 0.00 44,963.00 22,482.00 20,080.04 3,511.81 24,883 44.7 % Total Personnel Services 227,019.00 0.00 227,019.00 113,508.00 112,127.11 18,669.89 114,892 49.4 % Materials & Supplies 5200 - Office Supplies & Printing 1,500.00 0.00 1,500.00 950.00 870.51 0.00 629 58.0 % 5210 - Food & Catering for Events 3,250.00 0.00 3,250.00 2,750.00 536.85 0.00 2,713 16.5 % 5235 - Signage 2,000.00 0.00 2,000.00 2,000.00 273.91 0.00 1,726 13.7 % 5904 - Incident Repair or Replacement 0.00 0.00 0.00 0.00 183,208.44 182,973.57 (183,208)0.0 % Materials & Supplies 6,750.00 0.00 6,750.00 5,700.00 184,889.71 182,973.57 (178,140)2,739.1 % Services & Charges 5301 - Advertisement 7,200.00 0.00 7,200.00 2,850.00 2,898.50 0.00 4,302 40.3 % 5303 - Subscriptions, Publications and Dues 1,300.00 0.00 1,300.00 800.00 363.00 0.00 937 27.9 % FDN Operations Fayetteville Public Library Foundation Summarized Unrestricted Budget to Actual As of June 30, 2024 All Projects Filter tab and prompt selections: As of date: 06/30/2024 ; Department: All; Include subdimensions: Off; Hide inactives: Off ; Fund: FDN Operations; Include subdimensions: Off; Hide inactives: Off ; Client or Donor: All; Include subdimensions: Off ; Client or Donor type: All; Include subdimensions: Off ; Vendor: All; Include subdimensions: Off ; Vendor type: All; Include subdimensions: Off ; Employee: All; Include subdimensions: Off ; Employee type: All; Include subdimensions: Off ; Item: All ; Product line: All; Include subdimensions: Off ; Restriction: U--Unrestricted; Include subdimensions: Off ; Project: All Projects--All Projects; Include subdimensions: Off ; Project type: All; Include subdimensions: Off ; 25 Preliminary: Subject to Audit 06/30/2024 ANNUAL BUDGET ORIGINAL BUDGET IN-YEAR BUDGET ADJ Amended Budget YTD Budget YTD ACTUAL CURRENT MONTH ACTUAL REMAINING BUDGET % COLLECTED/ SPENT 5305 - Postage 20,000.00 0.00 20,000.00 5,000.00 714.61 714.61 19,285 3.6 % 5357 - Donor Cultivation 3,700.00 0.00 3,700.00 1,700.00 963.44 30.00 2,737 26.0 % 5361 - Training & Development 6,000.00 0.00 6,000.00 3,500.00 4,229.48 134.00 1,771 70.5 % 5362 - Travel 4,500.00 0.00 4,500.00 4,500.00 5,487.60 0.00 (988) 121.9 % 5368 - Event Cost 25,000.00 0.00 25,000.00 20,000.00 11,279.27 133.84 13,721 45.1 % 5385 - Board & Volunteer Recognition 1,500.00 0.00 1,500.00 0.00 0.00 0.00 1,500 0.0 % 5422 - Insurance - Liability 4,500.00 0.00 4,500.00 2,000.00 4,383.50 0.00 117 97.4 % 5423 - Other Rental 9,000.00 0.00 9,000.00 4,500.00 4,500.00 0.00 4,500 50.0 % 5395 - Bank Service Charges 3,000.00 0.00 3,000.00 1,500.00 1,472.45 62.91 1,528 49.1 % 5340 - Audit 12,800.00 0.00 12,800.00 10,500.00 8,499.52 0.00 4,300 66.4 % 5341 - Legal 2,000.00 0.00 2,000.00 1,000.00 0.00 0.00 2,000 0.0 % 5344 - Contract Services 2,500.00 0.00 2,500.00 1,500.00 245.03 0.00 2,255 9.8 % 5310 - Telecommunications 3,000.00 0.00 3,000.00 1,500.00 0.00 0.00 3,000 0.0 % Services & Charges 106,000.00 0.00 106,000.00 60,850.00 45,036.40 1,075.36 60,964 42.5 % Debt Service 179,824.00 0.00 179,824.00 89,910.00 84,085.55 12,838.16 95,738 46.8 % Misc. Expense 294,245.00 (294,245.00)0.00 0.00 0.00 0.00 0 0.0 % Capital Outlay 5828 - Software Expense (Capitalized)44,260.00 0.00 44,260.00 36,706.00 15,252.36 0.00 29,008 34.5 % Capital Outlay 44,260.00 0.00 44,260.00 36,706.00 15,252.36 0.00 29,008 34.5 % Total Expenditures 858,098.00 (294,245.00)563,853.00 306,674.00 441,391.13 215,556.98 122,462 78.3 % Change in Net Assets (398,525.00)294,245.00 (104,280.00)(45,041.00)52,045.77 32,885.38 (156,326)(49.9) % FDN Operations Fayetteville Public Library Foundation Summarized Unrestricted Budget to Actual As of June 30, 2024 All Projects Filter tab and prompt selections: As of date: 06/30/2024 ; Department: All; Include subdimensions: Off; Hide inactives: Off ; Fund: FDN Operations; Include subdimensions: Off; Hide inactives: Off ; Client or Donor: All; Include subdimensions: Off ; Client or Donor type: All; Include subdimensions: Off ; Vendor: All; Include subdimensions: Off ; Vendor type: All; Include subdimensions: Off ; Employee: All; Include subdimensions: Off ; Employee type: All; Include subdimensions: Off ; Item: All ; Product line: All; Include subdimensions: Off ; Restriction: U--Unrestricted; Include subdimensions: Off ; Project: All Projects--All Projects; Include subdimensions: Off ; Project type: All; Include subdimensions: Off ; 26 Preliminary: Subject to Audit 90--FDN Shively 91--FDN Operations 92--FDN Otwell 93--FDN NEH 94--FDN Walker/Tyson 95--FDN Anonymous 96--FDN Capital Campaign All Funds Year Ending 12/31/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 Board Approved Amended Budget Current Month Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual YTD Actual Revenue State Aid & Grant Revenue 0.00 0.00 0.00 0.00 234,286.30 0.00 0.00 0.00 0.00 0.00 234,286.30 Charges for Services 179,824.00 179,824.00 0.00 0.00 89,911.98 0.00 0.00 0.00 0.00 0.00 89,911.98 Contributions & Donations 0.00 0.00 53,730.19 0.00 0.00 0.00 0.00 0.00 0.00 166,484.67 166,484.67 Operating Revenue 239,800.00 239,800.00 3,752.51 0.00 145,122.62 0.00 0.00 0.00 0.00 0.00 145,122.62 Miscellaneous Revenue 0.00 0.00 239,060.18 0.00 239,060.18 0.00 0.00 0.00 0.00 0.00 239,060.18 Investment Earnings 54,338.00 54,338.00 89,976.38 123.49 19,342.12 11,448.58 138,896.71 16,124.16 31,496.77 29,993.32 247,425.15 Total Revenue 473,962.00 473,962.00 386,519.26 123.49 727,723.20 11,448.58 138,896.71 16,124.16 31,496.77 196,477.99 1,122,290.90 Expenditures Personnel Services Salary & Wages 182,056.00 182,056.00 15,158.08 0.00 92,047.07 0.00 0.00 0.00 0.00 0.00 92,047.07 Employee Benefits 44,963.00 44,963.00 3,511.81 0.00 20,080.04 0.00 0.00 0.00 0.00 0.00 20,080.04 Total Personnel Services 227,019.00 227,019.00 18,669.89 0.00 112,127.11 0.00 0.00 0.00 0.00 0.00 112,127.11 Materials & Supplies 6,750.00 6,750.00 182,973.57 0.00 184,889.71 0.00 0.00 0.00 0.00 0.00 184,889.71 Services & Charges 131,390.00 131,390.00 1,121.66 0.00 47,214.19 2,502.39 11,253.59 0.00 2,744.50 225.00 63,939.67 Debt Service 179,824.00 179,824.00 12,838.16 0.00 84,085.55 0.00 0.00 0.00 0.00 0.00 84,085.55 Misc. Expense 294,245.00 294,245.00 161,586.30 0.00 309,513.13 0.00 0.00 0.00 0.00 0.00 309,513.13 Transfers Out 118,246.32 118,246.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Capital Outlay 74,494.00 74,494.00 0.00 0.00 15,252.36 0.00 0.00 0.00 0.00 27,867.55 43,119.91 Total Expenditures 1,031,968.32 1,031,968.00 377,189.58 0.00 753,082.05 2,502.39 11,253.59 0.00 2,744.50 28,092.55 797,675.08 Change in Net Assets (558,006.32)(558,006.00)9,329.68 123.49 (25,358.85)8,946.19 127,643.12 16,124.16 28,752.27 168,385.44 324,615.82 Foundation Fayetteville Public Library Foundation Summarized Budget to Actual As of June 30, 2024 Created on 07/10/2024, 10:38 AM CDT Page 1 27 Preliminary: Subject to Audit 90--FDN Shively 91--FDN Operations 92--FDN Otwell 93--FDN NEH 94--FDN Walker/Tyson 95--FDN Anonymous 96--FDN Capital Campaign All Funds Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 06/30/2024 Assets Cash & Investments 4,682 886,908 550,976 3,200,704 838,363 602,575 1,407,782 7,491,991 Receivables 1240 - Accounts Receivable 0 5 0 0 0 0 1 6 1243 - Grants Receivable 0 11,726 0 0 0 0 0 11,725 1245 - Pledge Receivable 0 5,660 0 0 0 0 1,196,050 1,201,710 1248 - Long Term Receivable 0 0 0 0 0 0 463,986 463,986 1250 - Allowance Present Value Discount 0 (75)0 0 0 0 (10,344) (10,419) 1255 - Allowance for Uncollectable 0 (164)0 0 0 0 (34,685) (34,849) 1265 - Sales Tax Rebate Receivable 0 0 0 0 0 0 4,544 4,544 1270 - Due From Other Funds 0 128,745 0 329 51,813 0 0 180,887 1276 - 91 Due From 10 0 36,468 0 0 0 0 0 36,468 1283 - 96 Due From 91 0 0 0 0 0 0 154,623 154,623 1284 - 91 Due From 96 0 87,144 0 0 0 0 0 87,144 1400 - Interfund (23,603)68,201 28,913 46,485 (138,270)1,952 16,322 0 Total Receivables (23,603)337,710 28,913 46,814 (86,457)1,952 1,790,497 2,095,825 Fixed Assets 0 15,331,645 0 0 0 0 0 15,331,644 Total Assets $ (18,921)$ 16,556,263 $ 579,889 $ 3,247,518 $ 751,906 $ 604,527 $ 3,198,279 $ 24,919,460 Liabilities and Fund Balances Liabilities 2001 - Accounts Payable 0 144,652 0 0 0 0 0 144,652 2005 - FDN Designated Pass Through to FPL 0 136,389 0 0 0 0 0 136,389 2006 - FDN CentreSuite 0 268 0 0 0 0 0 268 2020 - Accrued Accounts Payable 0 0 0 0 0 0 30,234 30,234 Salaries & Benefits Payable 0 8,809 0 0 0 0 0 8,809 Other Payables 2015 - Notes Payable 0 0 0 0 0 0 3,774,387 3,774,387 Due to Other Funds 6,321 497,484 18,305 58,088 28,445 64,162 95,041 767,845 Total Liabilities 6,321 787,602 18,305 58,088 28,445 64,162 3,899,662 4,862,584 Fund Balance (25,242)15,768,661 561,584 3,189,430 723,461 540,365 (701,383)20,056,876 Total Liabilities and Fund Balances $ (18,921)$ 16,556,263 $ 579,889 $ 3,247,518 $ 751,906 $ 604,527 $ 3,198,279 $ 24,919,460 Foundation Fayetteville Public Library Foundation Consolidated Funds: Balance Sheet As of June 30, 2024 Created on 07/10/2024, 10:18 AM CDT Page 1 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52