Loading...
HomeMy WebLinkAbout2022-08-15 - Agendas - FinalFayetteville 401 et Mountain St. FayetEeville, AR 72701 408 Public Library 479.856.7000 questions@fayl i b.o rg faylib.org Board of Trustees August 15, 2022 4 pm AGENDA Regular Meeting — Event Center Rob Qualls, President Apr 2026 Stan Rodgers Apr 2027 Sallie Overbey, Secretary Apr 2023 Amy Wilbourn Apr 2027 Hershey Garner Apr 2024 Bret Park Apr 2027 Martha Sutherland Apr 2025 Our mission is to strengthen our community and empower our citizens through free and public access to knowledge. I. Call to order II. Minutes: Approval of minutes from June 20, 2022 — pages 1-4 III. Presentation to retired Trustee Janine Parry IV. New Trustee Bret Park sworn in by Judge Beth Storey Bryan V. Reports A. Key Upcoming Events— page 5 B. Mission Moment C. Library Administration 1. Management Reports a. Performance Measures — pages 6-7 b. Strategic Plan progress through July 2022 — pages 8-11 2. Financial reports a. Overview — pages 12-14 b. Budget to actual through July 2022 — pages 15-19 c. Balance sheet as of July 2022— pages 20-32 3. Informational a. Community Needs Assessment update b. SRC wrap-up report c. FPL's programming agreement with Fay Jones Park d. 2023 Budget timeline — page 33 e. SAGE financial software goes live f. Audit presentation meeting g. ARPA grant update h. Ramble Grand Opening i. Staff development & professional development Fayetteville 401 et Mountain St. FayetEeville, AR 72701 408 Public Library 479.856.7000 questions@fayl i b.o rg faylib.org j. New staff & staff recognition D. Fayetteville Public Library Foundation: monthly report — pages 34-38 E. Friends of the Fayetteville Public Library F. Art Committee VI. New business A. Consent Items 1. New Foundation Board members— page 39 B. Discussion items 1. Report of the Nominating Committee & Resolution — page 40 2. Bank documents for new slate of officers 3. BOK fiduciary memo — pages 41-42 4. Benefits cost -sharing memo — pages 43-44 5. City of Fayetteville & FPL Solar Proposal — pages 45-47 VI 1. Public Comment Adjournment Fayetteville Fa Mountain St. Fayetteville, AR 72701 Public Library 479.856.7000 400 questions@faylib.org faylib.org Board of Trustees June 20, 2022 4 pm AGENDA Regular Meeting — Pat Walker Community Room Trustees present: R. Qualls, S. Overbey, H. Garner, M. Sutherland, S. Rodgers, A. Wilbourn Staff present: D. Johnson, R. Duarte, W. Fitzgibbon, T. Ball, C. Karnatz, C. Moody, H. Robideaux, M. Eiler, S. McClure, J. Atha, C. Dennis, J. Askins, K. Wood, A. Easley, A. Taylor Attorney: V. Chadick Press: M.B. Kemp, S. Ryburn Public: M. Curtis, B. Park, M. Rice Our mission is to strengthen our community and empower our citizens through free and public access to knowledge. I. Call to order: R. Qualls called the meeting to order at 4:00 PM. 11. Minutes: Approval of minutes from April 18, 2022: H. Garner moved to approve the minutes. S. Overbey seconded the motion. All voted AYE. III. Reports A. Key Upcoming Events: Summer events include a library lock -in, Mountain Street Stage performances, coders' meet -up, Wild for Wednesday children's programming, and workshops with Visiting Artist A. Blevins. B. Mission Moment: H. Robideaux, Manager of Adult Services, reported on Adult Summer Reading. 730 adult participants are registered. Activities include film screenings, kitchen classes, art and movement classes, and adult LEGO classes. C. Library Administration 1. Management Reports a. Performance Measures: Programs and collections increased, with new registrations over 83,000. Once 2022 is completed, staff will be able to do real year-to-year comparisons. b. Strategic Plan progress through May 2022: FPL staff provided income tax assistance, weekly story times and book clubs, hosted early voting, and held community focus groups for the needs assessment. A billboard advertising FPL is now on 1-49 South. 2. Financial reports a. Overview: As of May 31St— General Fund and Property Tax revenue is trending 4% above YTD projections. 39.6% of overall budget expenditures Fayetteville 400 Public Library 401 W. Mountain St. Fayetteville, AR 72701 479.856.7000 questions@faylib.org faylib.org have been spent. Capital expenses increased over 300% compared to 2021 due to the bookmobile and accounting software implementation. b. Budget to actual through May 2022: Personnel expenditures are on target. The YTD revenue of Food Services is $61,000. Due to a decline in catering events, there is a May net loss of $11,000, totaling a YTD net loss of $59,900. Events revenue is $73,000 YTD, which is $77,000 less than projected revenue. Overall, Events expenditures increased 26.23% compared to April. c. Balance sheet as of May 2022: The General Fund holds $2.5 million, including the Schwab Operating Portfolio, and Food Services has $18,968. The Accounts Payable General Fund balance is $625,138, with Food Services at $4,829. 3. Informational a. Community Needs Assessment update: In the preliminary benchmark study by the Ivy Group, FPL ranked 15t or 2nd with comparable libraries but improvement can be made in benefits packages. A community survey is taking place through June, and interviews with community leaders regarding the future of FPL have begun. b. SRC kickoff update: Performers, food, and games drew 3,240 estimated attendees. 2,244 people have registered for the Summer Reading Club. With just 100 shy of 2021 attendance totals, staff suspect the number will be surpassed this year. c. Expansion project update: All lingering projects are complete except for the flickering Event Center lights. Manufacturers, installers, electricians all recognize that there is a problem. d. OCLC Early Adopter credit: FPL moved to OCLC Wise as an Early Adopter in early 2021. In acknowledgement, OCLC is going to give FPL a $10,000 credit for 2023. e. Roots Festival update: FPL will host the VIP Party at the Roots Festival, with free live music to follow on subsequent days. When FPL closes, Roots will move to the Town Center and Square. f. Ramble opening & south acre update: The City asked Nabholz to construct sidewalks along the street. In exchange for using the south acre, staff will try to get more infrastructure construction in exchange. The Ramble opening has been pushed until late July. g. Website redesign: The website has been simplified. It will be live at the end of June. 2 IV Fayetteville Public Library 401 W. Mountain St. Fayetteville, AR 72701 479.856.7000 questions@faylib.org faylib.org h. Deli pricing update: Starting this month, prices and portion sizes have been adjusted. The dollar -priced rice and bean bowl will not increase. i. Bookmobile update: Alterations should be ready August 1st. Scheduling stops, giveaways, and marketing materials are in development, with a street date set for early September. j. Line of credit conversion: The Foundation has successfully changed the line of credit to debt. The terms are 5 years, 3.95% interest rate, and $5,000 principal payment annually. k. Electrical charging station update: FPL has agreed to sign a contract with Blink, the company installing electrical charging stations for the City. The stations will be in the south lot, with a few possibly in the garage. Blink will cover the hardware and maintenance, and FPL will provide the power. This will allow revenue to come directly to the library. I. Budget 2023 calendar: FPL will start the 2023 budget process in July. The budget will be presented in November, with adoption in December. m. New staff & staff recognition: Five new staff members were hired, including a Marketing & Development intern, and J. Askins, the new Manager of Technical Services. K. Rolf, former scholarship recipient, has graduated with her MLS degree. D. Fayetteville Public Library Foundation - monthly report: Two events for autumn seek sponsorships: Be Aware! Halloween trick -or -treat food allergy event, and a Maker Fair hosted by the CFI. The Roberta Fulbright Society has raised twice the revenue from 2021. An upcoming meet -and -greet will unite potential Foundation Board members with current members. Staff are working with prospects in the Capital Campaign. E. Friends of the Fayetteville Public Library: The group meets next week with goals to plan a lobby book sale this summer. F. Art Committee: FPL is showcasing photographs of Fay Jones's architecture, watercolor by homeschool students, and E. Lorenzen's textile art. New business A. Consent items 1. Support scholarship application for Clara Davis: H. Garner moved to approve the scholarship application for Clara Davis. M Sutherland seconded the motion. All voted AYE. B. Discussion items 1. Report of the Nominating Committee: Postponed until there is a full Board. 2. Retirement and benefit changes: Changes include updated wording and definitions, and the ability to withdraw $5,000 after childbirth or adoption. This will go 3 Fayetteville 408 Public Library 401 W. Mountain St. Fayetteville, AR 72701 479.856.7000 questions@faylib.org faylib.org into effect July 1. H. Garner moved to accept the retirement and benefit changes as submitted. S. Overbey seconded the motion. All voted AYE. 3. Budget adjustment for ARPA funds: Approximately $54,000 was missed in the carryover process into 2022. The budget needs to be adjusted so the funds can be used. H. Garner approved budget adjustment for ARPA funds. M. Sutherland seconded the motion. All voted AYE. 4. Budget adjustment for Walton Family Foundation grant: The budget needs to be adjusted to accommodate the $22,000 that was not spent last year. H. Garner approved the budget adjustment for the Walton Family Foundation grant. A. Wilbourn seconded the motion. All voted AYE. 5. Event Center fee schedule: Currently, any adjustments to the prices must be approved by the Board. Staff wish to adjust prices without Board approval. H. Garner suggested that once a year, the changes to fees be reported to the Board. H. Garner moved to separate fee schedules as suggested and allowing the Board to review these changes on an annual basis. S. Overbey seconded the fee schedule separation. All voted AYE. V. Executive Session: Postponed. VI. Public Comment: None. Adjournment: H. Garner moved to adjourn the meeting. S. Rodgers seconded the motion. All voted AYE. The meeting was adjourned at 4:57 PM. I'A FA 4 41 Key Upcoming Events Libraries are Punk Rock: An Evening with Henry Rollins Friday, August 12, 6pm Our Innovation Speakers Series kicks off with someone who has done it all: music, film, podcasting, writing, spoken word and more. In this hour-long moderated conversation with punk rock legend Henry Rollins, we will explore topics relating to free speech, censorship, public libraries and technology. The conversation with Henry Rollins will be followed by a Q&A and book signing. "First River: How Arkansas Saved a National Treasure" - Ozark Society Film & Discussion Wednesday, August 17, 6pm Join us for a screening of the Ozark Society film, First River: How Arkansas Saved a National Treasure, directed and produced by Michelle West. A discussion with members of the Ozark Society will follow the screening. Deep Relaxation: Yoga Nidra with Robin Brucer Sundays in September, 2pm Yoga Nidra means yogic sleep, a state of being induced by guided meditation that soothes the nervous system and brings a state of deep relaxation. A majority of the practice is done lying on the back, so no previous experience with yoga is required. 0 Fayetteville Public Library Author Talk: Dr. Brooks Blevins - "The History of the Ozarks, Volume 3: The Ozarkers" Thursday, September 15, 6:30pm In "The History of the Ozarks, Volume 3: The Ozarkers", Blevins explores how people's disproportionate influence affected the creation of the idea of the Ozarks and reveals the truer idea that exists at the intersection of myth and reality. Banned Books Week Celebration Monday, September 19, 6pm Banned Books Week is the annual celebration of the freedom to read. FPL held a call for art representing a book or author that has been banned or challenged. The winning art pieces will be on display along with the opportunity to meet the artists. Enjoy refreshments and receive a pack of Banned Books Trading Cards. Cooking the Farmer's Market - Hearty Season Tuesday, October 4, 5pm Join Visiting Artist Amanda Arafat to learn more about how to prepare seasonal produce locally available at the Fayetteville Farmers Market! Students will leave the class with delicious inspiration and wholesome, straightforward recipes to make the most of the market and its bounty. 5 faylib.org / 401 W. Mountain St., Fayetteville, AR 72701 FPL Performance Report: July 2022 )AN FEB MAR APR MAY JUN JUL AUG SEP OCi' NOV DEC 22 YTD 21 YTD CHANGE Circulation 86,701 77,871 90,591 84,408 87,023 99,101 105,509 0 0 0 0 0 631,204 633,769 -0.40% Physical Checkouts 56,166 51,764 64,021 59,372 60,502 72,862 77.948 0 0 0 0 0 442,635 452,295 -2.14% Digital Checkouts 23,392 20,6621 21,447 20,529 22,2781 21,853 23,766 0 0 0 0 0 153,927 143,405 7.34% Streamed Accesses 7,143 5,4451 5,123 4,507 4,243 4,386 3,795 01 0 0 0 0 34,642 38,069 -9.00% Reference Queries 3,914 3,147 4,759 4,354 4,136 6,382 6,432 0 0 0 0 0 33,124 27,564 20.17% Total Collection Size 370,437 371,614 373,201 375,380 375,851 377,433 380,467 0 0 0 0 0 380,467 358,941 6.00% Physical Collection 302,324 302,779 304,777 307,090 307,453 308,861 311,944 0 0 0 0 0 311,944 291,594 6.98% Digital Collection 68,113 68,835 68,424 68,290 68,398 68,572 68,523 0 0 0 01 0 68,523 67,347 1.75% Total Items Added 2,136 2,462 3,977 2,762 1,938 2,269 2,116 0 0 0 0 0 17,660 7,327 141.03% New Card Registrations 775 625 808 571 593 918 841 0 0 0 0 0 5,131 4,000 28.28% Cardholders 81,862 82,475 83,045 83,316 83,948 84,898 85,838 0 0 0 0 O 85,838 75,272 14.04% Visits 24,974 22,364 35,790 32,324 35.590 45,200 43,909 0 0 0 0 0 240,151 193,575 24.06% Library Programs 114 157 206 187 137 199 210 0 0 0 0 0 1,210 450 168.89% Library Attendance 1,205 1,544 3,289 4,087 2,837 11,748 9,567 0 0 0 0 0 34,277 6,458 430.77% Outreach Attendance 0 8 22 198 62 642 500 0 0 0 0 0 1,432 326 339.26% Online Views 6,852 6,661 8,024 7,342 8,364 7,590 10,881 0 01 0 0 0 55,714 39,136 42.36% Meeting Room Usage 15 36 59 80 83 55 34 0 0 0 0 0 362 171 111.70% Study Room Usage 597 647 827 840 824 812 791 0 0 0 0 0 5,338 2,207 141.87% Event Center Usage 4 4 7 12 11 8 5 0 0 0 01 0 51 0 Teaching Kitchen Usage 1 20 26 26 141 4 2 0 0 0 0 0 93 0 CFI Room/Suite Usage 533 416 613 506 511 590 812 0 0 0 0 0 3,981 126 3059.52% Volunteers 229 240 240 250 252 281 259 0 0 0 0 0 2591 210 23.33% Volunteer Hours 523 499 754 707 570 929 678 0 0 0 0 0 4,660 2,370 96.62% Computer Sessions 1,460 1,288 2,085 1,952 1,767 2,454 3,337 0 0 0 0 0 14,343 5,187 176.52% Holds Filled 3,824 3,3581 4,222 3,512 3,374 3,600 4,409 O 0 0 0 0 26,299 39,342 -33.15% eFPL Usage 79,186 76,584 77,620 74,387 80,337 55,644 55,637 0 0 0 0 0 499,395 364,756 36.91% Bandwidth Consumed 2,630 2,600 3,740 4,200 4,130 4,1501 4,210 0 0 0 0 0 25,660 12,475 105.69% Unique Users 3,840 4,082 5,612 6,053 6,109 6,022 6,250 0 0 0 0 0 37,968 18,430 106.01% Deli Statistics Guests/orders 1,027 858 1,741 1,857 1,844 2,072 2,079 0 0 0 0 0 11,478• 0 Net sales 57,380.62 S6,147.971 $13,299.22 S14,645.051 $13,591.55 $16,805.21 $17,359.00 $0.004 $0.001 $0.00 $0.00 $0.00 $89,228.62 0 YTD Key Performance Measures 22 YTD 21 YTD 22 YTD Circulation YTD I I Circulation Distribution, 631,204 Cardholders YTD 21 YTD 75,272 Visits YTD 22 YTD 21 YTD 193,575 633,769 85,838 240,151 2022 6% 24% Q070% ■ Physical Checkouts ■ Digital Checkouts Streamed Accesses Program Attendance YTD Outreach Attendance �1,432 326 55,714 Online Attendance NEEMP3=9,136M Library Attendance 34,277 6,458 02022 02021 22 YTD 21 YTD I Wireless Unique Users YTD i 37,968 18,430 7 0 Fayetteville Public Library Strategic Plan Progress Report June 2022 - July 2022 Purpose: We inspire imagination and foster learning. Programs & Services: We offer inspiring and relevant programs and services that engage the community's curiosity, provide opportunities for education and self-improvement, and serve as the gateway to the library by addressing the diverse needs and interests of our community. a. Programs L Began "Mr. Mouse's Mail,"a preschool letter writing program. 99 letters from children have been received since June. ii. 3,240 attended the Summer Reading Kick -Off. iii. Summer Reading Registration totaled 2,522 - Youth: 1,304, Teen: 338, Adult and Staff.• 880. iv. The "Wild for Wednesday" series for children and families has had an average attendance of 305 and featured animals, science, Opera of the Ozarks, Bright Star Traveling Theatre, Music, and Circus Arts. Area daycares and school groups were invited to attend. v. Youth Services hosted 100 programs in June with an attendance of 9,567 people. Highlights included: Super Saturday magic and music, "Teen Cuisine" cooking classes, "Ocean in a Bottle" craft program, "Music and Movement, " the `BenAnna Band for Preschoolers," "Mr. Troy Songtime" on the Gathering Glade, Teen VR classes in CFI, writing classes for kids and teens, "Vintage Typewriter" and letter writing, various story times, 7-Up volunteer programs, "Teen Book Club," teen art classes, "Candy Sushi, " sensory programs, and Legos. vi. Hosted 5 summer field trips which included tours, story times, and crafts for children. vii. Welcomed nearly 500 attendees to Fulbright Author David Grann's author talk in June. viii. Finished the successful seven -week Mountain Street Stage concert series. As part of this event, Adult Services began a partnership with Chamber Music on the Mountain for Grooves. ix. Hosted movement programs such as Intro to "Yoga," "Learn Vintage Swing Dance," "Yoga @ FPL,"and "Explorative Dance" with Lela Besom along with art programs "Freeform Fiber Art," "Tattoo You: Design Your Own Tattoo," and "Sewing Class: Aprons." x. C. Williams and the Adult Services team continued Maker to Market programming. xi. "Introduction to Genealogy" and "The Extraction of Salt from Water by Caddo Indians" classes were taught by Genealogy staff N. Branon and A. Nelson -Lamont. xii. Hosted 89 Adult Services programs with 2,037 attendees. 820 adults registered for Summer Reading Club; 2,865 books were read. 60 staff registered, reading a total of 921 books. xiii. Held 201 programs for children and teens, with 17,315 total attendees. Listeners, kids, and teens read a total of 17,651 hours during June and July. b. Services i. Hosted 89 non -library meetings for communities, organizations, and clubs. ii. Received 156 unique library inquiries regarding FPL events and event booking. 1.1 iii. Accommodated the City of Fayetteville once, the Fayetteville Chamber of Commerce six times, Fayetteville Public Schools twice iv. Reserved FPL Study Rooms 812 times in June and 791 times in July. v. In June, the Event Center was rented to a variety of clients, including Fayetteville Chamber of Commerce, Ozark Literacy Council, and Williams Gymnastic and Dance. vi. In July, the Event Center clients included: University of Arkansas Walton College of Business and Fayetteville Public Schools Leadership. IL Collections: We will build and support collections that inspire the community with the resources they need to explore topics of personal interest and continue to learn throughout their lives. a. Satisfy your curiosity i. Implemented "Calming Kits for Sensory Issues" in Youth Services. Available by request for in-house use, these items can help patrons and children with sensory problems such as over -stimulation, excessive noise, frustration, etc. ii. Added a small batch of books with QR codes within the Read Aloud collection. The code links to Youth Services staff reading the book. Staff hope to grow this aspect of the collection to include videos of favorite books being read. 111. Access: We will build and expand the ease and convenience of the library experience through virtual and physical reach to all in the community, reflecting the FPL welcoming, convening and destination culture. a. Browsability i. Held OCLC Wise strategic partner meetings with FPL staff to discuss future developments in the online library catalog and database system. b. Outreach partnerships i. Conducted community leader interviews for Community Needs Assessment with leaders representing NWA Democrat Gazette, Veterans Affairs Hospital, Canopy, Arkansas United, University of Arkansas arts department, Walton Family Foundation, and UofA Economic Development. ii. Conducted community and staff surveys by Ivy Group for Community Needs Assessment. iii. Continued Books and Bites summer outreach programs with the Yvonne Richardson Center and LifeSource. Program partnerships included: First Security Bank, Cobblestone Farm, NWA Martial Arts Academy, City of Fayetteville Recycling, Washington County Extension Agency, and Day -by -Day. iv. Met with City of Fayetteville Parks and Recreation staff to discuss future programming in the Ramble/Fay Jones Woods. v. Continued Lending Hands outreach program. vi. Maintained monthly Tyson Pop -Up Library and issued 9 library cards and interacted with 75 team members. vi. Led community tours for Canopy NWA and Volunteer Action Center. vii. Attended Kidz Night at Gulley Park and interacted with 400 community members. viii. Visited CDBG in the Park at Walker Park, issued 4 library cards and interacted with 300 community members. ix. Began a new relationship with the University for "One Book, One Community" programming. x. Met with Arkansas United to share library resources and services for continued partnership. M xi. Discussed the possibility of a Bookmobile stop at the Boys and Girls Club. /V People: We create and maintain a culture of excellence by supporting and inspiring our staff, boards, and volunteers. a. Staff i J. Harris and L. McDonald accepted full-time LSG positions in Circulation. /iC. Williams represented FPL as a member of the Arkansas Library Association Library Advocacy Community of Interest. The group launched a Libraries Transform tab on the ArLA website, which can be found here: https.11www.arlib.or_q/Libraries-Transform-Arkansas. iii J. Settje accepted a full-time Bilingual Outreach Programmer position in Community Engagement. iv C. Dennis joined the Association of Bookmobile and Outreach Services organization. v Manager training included: Coaching and Developing Others, and Narcan training with Facilities staff. b. Volunteers i Provided 155 volunteer hours for Summer Reading Club Kickoff. /iPlaced nine volunteers in new volunteer opportunities and interviewed eight new applicants. //i First Security Bank volunteers provided 100 hours of support for Books and Bites programs in June and July. /v Supported outreach events, CDBG in the Park V. Facility: Our consumer -friendly, sustainable facility will be safe, accessible, clean and support the requirements for quality programs, services, and collections. i Unloaded construction debris left from south parking lot construction. ii Removed storage containers blocking West Street. /ii Established a post -construction vendor list. V/. Communication: We maximize ongoing communication to increase awareness of the library and understanding of its value and impact on the community. a. Marketing plan i Scheduled print advertising for the remainder of 2022. /ilncreased frequency of posts for Friends on social media. b. Public awareness campaign i Provided information for a story regarding continued fundraising efforts on KNWA. ii Updated internal best practices with media. //i Began developing "You are here" signage for main entrances. c. Operationalize brand i Developed a poster specifically for FPL's book clubs. ii Updated social media guidelines for consistency across accounts. d. Website i Updated the navigation and created new pages. /iContinued design work and branding updates. V//. Funding: As good stewards of the public trust, we will pursue diverse, sustainable funding. a. Secured a new major capital gift. b. Received 20% more Annual Fund donations than this time last year. 10 c. Worked with incoming board members to build prospect lists. d. Diversified funding streams by introducing fundraising dinners. e. Noted that the two ARPA requests to the City of Fayetteville are progressing. 11 Fayetteville Public Library FY 2022 Monthly Financial Update - through July 31, 2022 (Preliminary: Subject to Audit) This is an overview of the Fayetteville Public Library unaudited financial activity as of July 31, 2022, including revenue collections and expenditures. It compares revenues and expenditures for the first seven (7) months of fiscal year (FY) 2022 and prior years. This is an overview of the General Fund (Fund 10) and Enterprise Funds (Food Services and Events). Following this summary is a detailed report on all funds. As of July 31, 2022, 58.3% has completed; 41.7% of the year remains. General Fund Revenue: • Total Property Tax revenue is $2.38M, trending slightly better than expected compared to YTD projections. • Charges for Services revenue is 57.1% below YTD revenue projections, approximately $42k. This is primarily due to Fines & Fees below YTD projections by $36k due to a change in the fine threshold that blocks use of self -check machines. • Collectively, Year-to-date (YTD) total General Fund revenue collected is $4.8M, trending as expected. General Fund Expenditures: • Personnel expenses totals $2.78M YTD, which is 49.3% of budget, and trending as expected with YTD expenditure rate. • Maintenance expenses are trending above expected YTD expenditure rate, primarily due to multiple annual software subscriptions and licensing paid during Q2. However, no significant expenditure occurred that was unbudgeted or unexpected. • With 58.3% of year completed, a total of 52.6% of the overall budgeted general fund expenditures have been spent. Revenues Property Tax City Transfers Federal / State / Corporate Grants Charges for Services Foundation Transfers InternalTransfers Miscellaneus Revenue Total Revenues Expenses Personnel Services Materials & Supplies Services & Charges Maintenance Capital Expense I nterfund Transfers Transfers Out Depreciation Total Expenses Surplus / (Deficit) Target year-to-date percentage r956al Tear zvzz Adjusted Year -to -Date Year -to -Date Current Month Current Month Percent of Bud et 2022 Bud et Actual Bud et Actual Budget $ 4,833,241 $ 2,328,807 $ 2,383,119 $ 168,805 $ 129,381 49.3 % 2,759,401 1,776,738 1,776,734 196,534 196,533 64.4% 182,150 70,576 88,427 - 5,425 48.5% 170,500 99,463 56,841 14,209 7,417 33.3% 121,043 60,522 60,522 - - 50.0% 688,296 497,716 400,000 - - 58.1% Fiscal Year 2022 Adjusted Year -to -Date Year -to -Date Current Month Current Month Percent of Budget 2022 Budget Actual Budget Actual Budget $ 5,016,845 $ 2,957,382 $ 2,787,874 $ 398,063 $ 375,319 55.6% 1,236,991 795,211 524,353 129,747 69,958 42.4% 1,862,818 1,141,268 1,075,405 132,474 97,131 57.7% 403,323 332,674 267,286 15,654 10,923 66.3% 701,928 475,950 241,696 45,409 6,962 34.4% 492,700 287,658 214,950 - 120,950 43.6% - - 3,000 - - $ 9,714,605 $ 5,990,144 $ 5,114,565 $ 721,347 $ 681,244 52.6% $ (957,074) $(1,154,871) $ (302,706) $ (341,799) $ (340,065) 58.3% Fiscal Year 2021 Adjusted 2021 YTD Bud et Jan - Jul Actuals Jul-21 Actual Percent of Budget $ 4,350,000 $ 2,384,949 $ 181,110 54.8% 2,423,400 1,490,734 186,533 61.5% 744,461 199,178 15,953 26.8% 55,200 37,584 9,703 68.1% 105,500 53,851 - 51.0% 401:9660 - - 0.0% 6 000 r 41,789 r 32 912 696.5 $ 8,086,527 $ 4,208,085 $ 426,213 52.0% Adjusted Budget Fiscal Year 2021 2021 YTD Jan - Jul Actuals Jul-21 Actual Percent of Budget $4,734,925 $2,649,114 $378,243 55.9% 1,408,860 535,814 $67,742 38.0% 1,822,548 760,025 124,148 41.7% 236,372 140,229 15,354 59.3% 413,700 216,615 - 52.4% 225,000 - - 0.0% 589,082 93,705 $ 8,841,405 $ 4,890,881 $ 679,192 55.3% $ (754,878) $ (682,796) $ (252,979) 1% YTD Actual Revenue by Source YTD Actual Expenditures by Category S% 1% 1% • Property Tax 0% 0 2% • City Transfers • Personnel Services 5% • Materials & Supplies Federal /State /Corporate Grants • Services& Charges • Charges for Sam ces • Maintenance • Capital Expense • Foundation Transfers • Interfund Transfers • Transfers Out • Interfund Transfers . Depreciation • Miscellaneus Revenue 10% 12 General Fund Total Operating Expenditures General Fund Total Operating Revenue YrD Expend ores -Annual July Expend Aures YTD Revenue -Annual July Revenue 13,340,878 10,489,366 11,539,789 10,010,020 10,168,175 12,007,337 8,532,256 10,179,309 9654680 10,375,876 4,808,719 75,228 5,1■ 5,098.697 6,160,355 ■ 6,901,778 4761,11, 0 46■ 01,111 5,348,620 0 6,219,188 0 2018 2019 2021 2022' ■ 2018 2019 2020 2021 2022` *Annual Revenue & Events: Prior years reflect total actuals; current year reflects total approved budget YTD Expenditures Annual % of Annual YTD Revenue % of Annual Expenditures July Expenditures Expenditures Revenues July Annual Revenue Revenues 2018 4,808,719 8,532,256 56.4% 2018 4,768,981 10,489,366 45.5% 2019 5,175,228 10,179,309 50.8% 2019 4,996,434 11,539,789 43.3% 2020 5,098,697 9,654,680 52.8% 2020 4,606,978 10,010,020 46.0% 2021 6,160,355 10,375,876 59.4% 2021 5,348,620 10,168,175 52.6% 2022* 6,901,778 13,340,878 51.7% 2022* 6,299,888 12,007,337 52.5% Food Services Revenue: • YTD sales, which includes Deli and Catering sales, total $116,246. • In June, sales increased by approximately $21k compared to the prior month totaling $36,062. This was primarily due to an increase in catering sales (doubled from previous month) totaling approximately $16k. ■ In July, sales totaled $19,529. An internal transfer in the amount of $56,750 was received as supplemental revenue for personnel expenditures. Food Services Expenses: • YTD expenses total $173,059. ■ Cost of Goods Sold (COGS) continues to trend downward. In July, COGS totaled $9,802, which is a decrease of $2,625 from the prior month. Excluding transfers, YTD Food Services net loss totals $61,379. Including transfers, YTD Food Services net loss totals $4,629. Food Services: 2022 Sales and Expenses 40,000 3 5, 000 30,000 - 25,000 ■ IIIIIII� � 5 2 0, 000 15,455 13,062 10,505 02 ■ 15,000 11,032� 4,049 10,000 66 13, 886 12, 57 4 5,000 Jan Feb Mar Apr May Jun Jul Other Expenses 5,251 829 788 3,007 1,756 4,066 1,645 COGS 11,032 4,049 10,505 15,455 13,062 12,427 9,802 ■ Personnel 9,284 9,920 12,093 12,753 13,066 13,886 12,574 -Sales 7,811 6,149 14,720 17,365 14,610 36,062 19,529 13 Event Revenue: • YTD Events rental income revenue totals $91,004, which is below projection by approximately $163k. An internal transfer in the amount of $56,117 was received as supplemental revenue for personnel and operating expenditures. Event Services Expenditures: • YTD expenditures total $44,631 trending as expected with expenditure rate. • No significant expenditure occurred that was unbudgeted or unexpected. Events: 2022 Sales and Expenses 25,000 20,000 15,000 10,000 2,122 5,000 (5,000) Jan Feb Mar Apr May Jun Jul ,Other Expenses 664 - 513 2,122 (1,151) - �Personnel 4,526 5,938 7,903 6,077 6,04E 6,114 5,876 Sales 17,149 9,560 11,314 12,603 22,375 9,976 8,027 Balance Sheet Highlights - July 31, 2022: Receivables Due from Foundation Due from Events Due from Food Services Due from Other Funds Prepaid Expenses Assets Total Assets Liabilities Accounts Payable Other Liabilities Due to Foundation Due to Events Due to Food Services Due to other Funds Total Liabilities Fund Balance Total Liabilities & Fund Balance w v$3,491 v$3,525 $229,071 $222,507 $76,778 $70,502 $145,496 $132,823 ' $3,714,194 $3,714,194 $58,253 $54,165 $17,489,248 $17,489,248 $23,612,401 $24,056,334 $29,330 $141,871 ' $812,785' $814,072 $2,036 $1,364 $114,679 $106,252 ($27,622) ($27,812) $197,613 $196,964 $1,128,822 $1,232,712 $22,483,579 $22,823,622 + ($34) w $3,261 $6,564 $314,694 $6,276 $0 $0 ' $3,886,503 $4,088 $42,725 $0 $17,185,628 ($443,933) $23,543,860 ;85,( $76, $15528 $303:620 $68,541 ($112,541) $244,294 ($214,964) ($1,287) ' $981,042 ($168,257) $672 $3,355 ($1,319) $0 $0 $649 $194,016 $3,597 ($103,890) $1,422,708 ($293,886) ($340,044) $22,121,153 $362,426 14 Fayetteville Public Library Summarized Budget to Actual Preliminary: Subject to Audit - July 31, 2022 Revenues Local Tax Support 10-0-4882-00 Transfer for Operations - Mill LibraryLibrary 70-0-4883-00 Transfer for Debt Service - MiLibraryLibrary Total Local Tax Support City of Fayetteville Transfers 10-0-4880-00 Transfer for Operations - CityLibraryLibrary 10-0-4884-00 Transfer for Books - City of FLibraryLibrary 10-0-4886-00 Transfer for Computers - City LibraryLibrary 10-0-4887-00 Transfer for CIP - City of Fayetteville Total City of Fayetteville Transfers Current Year Adjusted Budget YTD 7/31/2022 Annual Budget Annual Budget Actual Remaining Remaining % $4,833,241.00 $2,383,119.41 ($2,450,121.59) (50.69%) $2,319,956.00 $1,143,895.63 ($1,176,060.37) (50.69%) $7,153,197.00 $3,527,015.04 ($3,626,181.96) (50.69%) $1,777,401.00 $1,036,817.28 ($740,583.72) $581,000.00 $338,916.62 ($242,083.38) $101,000.00 $101,000.00 $0.00 $300,000.00 $300,000.00 $0.00 07594n1 nn A1.776_7��9n (A)92.6671n1 (41.67%) (41.67%) 0.00% 0.00% �92" WAI Transfers from Foundation & Friends 10-0-4888-00 Transfer from FoundationLibraryLibrary $121,043.00 $60,522.00 ($60,521.00) (50.00%) Total Transfers from Foundation & Friends $121,043.00 $60,522.00 ($60,521.00) (50.00%) State Aid, Grants & Corporate Sponsorships 10-0-4010-00 State Library TurnbackLibraryLibrary $141,150.00 $80,502.00 ($60,648.00) (42.97%) 10-0-4050-00 Grants - StateLibraryLibrary $25,000.00 $0.00 ($25,000.00) (100.00%) 10-0-4055-00 Grants - Federal LibraryLibrary $16,000.00 $2,500.00 ($13,500.00) (84.38%) 10-0-4080-00 Grants - In Year AwardsLibraryLibrary $0.00 $0.00 $0.00 0.00% 10-0-4110-00 Contributed Services IncomeLibraryLibrary $0.00 $5,425.00 $5,425.00 0.00% Total State Aid & Grants $182,150.00 $88,427.00 ($93,723.00) (51.45%) Charges for Services 10-0-4201-00 Rent Income - Caf6LibraryLibrary $12,000.00 $5,500.00 ($6,500.00) (54.17%) 10-0-4202-00 Rent Income - Meeting RoomsLibraryLibrary $30,000.00 $10,960.00 ($19,040.00) (63.47%) 10-0-4205-00 Copier and Printer IncomeLibraryLibrary $3,000.00 $2,687.76 ($312.24) (10.41%) 10-0-4220-00 Merchandise SalesLibraryLibrary $300.00 $591.50 $291.50 97.17% 10-0-4300-00 Fees - Library CardsLibraryLibrary $200.00 $4.00 ($196.00) (98.00%) 10-0-4302-00 Fees - Fines & OverduesLibraryLibrary $125,000.00 $36,932.24 ($88,067.76) (70.45%) 10-0-4304-00 Fees - Lost MaterialsLibraryLibrary $100.00 $147.85 $47.85 47.85% 10-0-4306-00 Fees - Damaged MaterialsLibraryLibrary $0.00 $44.95 $44.95 0.00% 10-0-4310-00 Fees - Refunds to PatronsLibraryLibrary ($100.00) ($26.98) $73.02 73.02% 80-0-4225-00 Sales - FoodLibraryLibrary $213,000.00 $75,734.32 ($137,265.68) (64.44%) 80-0-4230-00 Sales - Non Alcoholic Beverage LibraryLibrary $0.00 $12,098.20 $12,098.20 0.00% 80-0-4235-00 Sales - Catering LibraryLibrary $130,000.00 $26,696.74 ($103,303.26) (79.46%) 80-0-4240-00 Sales - Internal Catering LibraryLibrary $0.00 $1,755.00 $1,755.00 0.00% 80-0-4405-00 Comps - Food LibraryLibrary $0.00 ($27.03) ($27.03) 0.00% 80-0-4410-00 Comps - Non -Alcoholic BeverageLibraryLi bra ry $0.00 ($10.81) ($10.81) 0.00% 85-0-4203-00 Rent Income - Teaching Kitchen LibraryLibrary $0.00 $5,200.00 $5,200.00 0.00% 15 08/05/2022 5:34:32 PM Page 1 Fayetteville Public Library Summarized Budget to Actual Preliminary: Subject to Audit - July 31, 2022 YTD 7/31/2022 Current Year Annual Budget Annual Budget Adjusted Budget Actual Remaining Remaining % 85-0-4204-00 Rent Income - Event CenterLibraryLibrary $340,000.00 $85,803.75 ($254,196.25) (74.76%) Total $853,500.00 $264,091.49 ($589,408.51) (69.06%) Contributions 10-0-4645-00 Donations to FPLLibraryLibrary $0.00 $529.64 $529.64 0.00% 10-0-4650-00 Contributions - UndesignatedLibraryLibrary $0.00 $259.92 $259.92 0.00% 10-0-4651-00 Contributions - Money JarLibraryLibrary $0.00 $221.69 $221.69 0.00% 10-0-4660-00 Contributions - DesignatedLibraryl-ibrary$0.00 $32,017.00 $32,017.00 0.00% 10-0-4662-00 Contributions - Designated YouLibraryLibrary $0.00 $2,077.56 $2,077.56 0.00% 10-0-4664-00 Contributions - Designated AduLibraryLibrary $0.00 $2,981.27 $2,981.27 0.00% 10-0-4666-00 Contributions - Designated MemLibraryLibrary $0.00 $0.00 $0.00 0.00% 85-0-4650-00 Contributions - UndesignatedLibraryLibrary $0.00 $0.00 $0.00 0.00% Total $0.00 $38,087.08 $38,087.08 0.00% Investment Earnings 10-0-4701-00 Interest - UnrestrictedLibraryLibrary $2,500.00 $453.40 ($2,046.60) (81.86%) 10-0-4703-00 Interest - Undesignated FundsLibraryLibrary $400.00 $132.67 ($267.33) (66.83%) 10-0-4772-00 Gain/Loss on Investments - UnrLibraryLibrary $0.00 $0.00 $0.00 0.00% 10-0-4990-00 Gain/(Loss) on Sale of AssetsLibraryLibrary $0.00 $23.00 $23.00 0.00% 10-0-4992-00 Miscellaneous RevenueLibraryLibrary $0.00 $7,519.00 $7,519.00 0.00% 15-0-4702-00 Interest - Designated Fund IncLibraryLibrary $100.00 $887.89 $787.89 787.89% 15-0-4770-00 Gain/Loss on Investments - ReaLibraryLibrary $0.00 $0.00 $0.00 0.00% 15-0-4772-00 Gain/Loss on Investments - UnrLibraryLibrary $0.00 $0.00 $0.00 0.00% 20-0-4702-00 Interest - Designated Fund IncLibraryLibrary $10,000.00 $3,595.21 ($6,404.79) (64.05%) 20-0-4770-00 Gain/Loss on Investments - ReaLibraryLibrary $0.00 $0.00 $0.00 0.00% 20-0-4772-00 Gain/Loss on Investments - UnrLibraryLibrary $3,000.00 $1,736.59 ($1,263.41) (42.11%) 20-0-4779-00 Investment Management FeesLibraryLibrary ($3,500.00) ($3,085.00) $415.00 11.86% 30-0-4702-00 Interest - Designated Fund IncLibraryLibrary $5,000.00 $2,187.67 ($2,812.33) (56.25%) 30-0-4770-00 Gain/Loss on Investments - ReaLibraryLibrary $0.00 $0.00 $0.00 0.00% 30-0-4772-00 Gain/Loss on Investments - UnrLibraryLibrary $0.00 ($4,105.04) ($4,105.04) 0.00% 30-0-4779-00 Investment Management FeesLibraryLibrary ($2,000.00) ($935.00) $1,065.00 53.25% 40-0-4702-00 Interest - Designated Fund IncLibraryLibrary $3,000.00 $184.02 ($2,815.98) (93.87%) 40-0-4770-00 Gain/Loss on Investments - ReaLibraryLibrary $0.00 $0.00 $0.00 0.00% 40-0-4772-00 Gain/Loss on Investments - UnrLibraryLibrary $0.00 $388.17 $388.17 0.00% 40-0-4779-00 Investment Management FeesLibraryLibrary ($600.00) ($464.00) $136.00 22.67% 50-0-4702-00 Interest - Designated Fund IncLibraryLibrary $5,000.00 $433.79 ($4,566.21) (91.32%) 50-0-4770-00 Gain/Loss on Investments - ReaLibraryLibrary $0.00 $0.00 $0.00 0.00% 50-0-4772-00 Gain/Loss on Investments - UnrLibraryLibrary $0.00 ($1,750.21) ($1,750.21) 0.00% 50-0-4779-00 Investment Management FeesLibraryLibrary ($850.00) ($503.00) $347.00 40.82% 80-0-4701-00 Interest - UnrestrictedLibraryLibrary $0.00 $62.74 $62.74 0.00% 80-0-4992-00 Miscellaneous RevenueLibraryLibrary $0.00 $0.00 $0.00 0.00% Total Contributions & Investment Earnings $22,050.00 $6,761.90 ($15,288.10) (69.33%) 16 08/05/2022 5:34:32 PM Page 2 Fayetteville Public Library Summarized Budget to Actual Preliminary: Subject to Audit - July 31, 2022 YTD 7/31/2022 Internal Transfers and Use of Reserves 10-0-4915-00 Transfer from Expansion FundLibraryLibrary 10-0-4999-00 Use of ReservesLibraryl-i bra ry 30-0-4910-00 Transfer from Operating - 10 40-0-4910-00 Transfer from OperationsLibraryl-ibrary 50-0-4910-00 Transfer from OperationsLibraryl-ibrary 80-0-4910-00 Transfer from FPL Operations-FLibraryLi bra ry 85-0-4910-00 Transfer from FPL Operations-FLibraryLi bra ry Total In Total Revenues Expenses Library Services Personnel Services Library Materials, Program Supplies Program Services Library Services - Maintenance Tota I Support Services Support Services - Personnel Services Internal Library - Materials & Supplies Internal Library - Services & Charges Internal Library - Maintenance Tota I Events Events - Personnel Services Events - Materials & Supplies Events - Services & Charges Tota I Food Services Food Services - Personnel Services Food Services - Materials & Supplies Food Services - Services & Charges Food Services - COGS Tota I Services & Charges Services & Charges for Funds 20, 30, 40, 50, 60 and 70 Current Year Adjusted Budget Actual Annual Budget Remaining Annual Budget Remaining % $400,000.00 $400,000.00 $0.00 0.00% $288,296.00 $0.00 ($288,296.00) (100.00%) $8,000.00 $34,000.00 $26,000.00 325.00% $0.00 $12,500.00 $12,500.00 0.00% $10,000.00 $35,000.00 $25,000.00 250.00% $113,500.00 $56,750.00 ($56,750.00) (50.00%) $96,200.00 $0.00 ($96,200.00) (100.00%) $915,996.00 $538,250.00 ($377,746.00) (41.24%) $12,007,337.00 $6,299,888.41 ($5,707,448.59) (47.53%) $2,809,212.00 $1,573,352.48 $1,235,859.52 43.99% $977,236.00 $410,816.34 $566,419.66 57.96% $382,578.00 $214,518.85 $168,059.15 43.93% $4,500.00 $113.84 $4,386.16 97.47% $4,173,526.00 $2,198,801.51 $1,974,724.49 47.32% $2,207,633.00 $1,214,521.85 $993,111.15 44.99% $259,755.00 $113,536.53 $146,218.47 56.29% $1,480,240.00 $860,886.15 $619,353.85 41.84% $398,823.00 $267,172.54 $131,650.46 33.01% $4,346,451.00 $2,456,117.07 $1,890,333.93 43.49% $111,929.00 $42,482.56 $69,446.44 62.05% $5,700.00 $192.45 $5,507.55 96.62% $34,500.00 $1,033.61 $33,466.39 97.00% $152,129.00 $43,708.62 $108,420.38 71.27% $267,080.00 $83,565.56 $183,514.44 68.71% $35,500.00 $10,018.85 $25,481.15 71.78% $19,200.00 $7,322.52 $11,877.48 61.86% $92,408.00 $76,332.38 $16,075.62 17.40% $414,188.00 $177,239.31 $236,948.69 57.21% $0.00 $0.00 $0.00 0.00% 17 08/05/2022 5:34:32 PM Page 3 Fayetteville Public Library Summarized Budget to Actual Preliminary: Subject to Audit - July 31, 2022 Total Depreciation 10-0-5990-00 Depreciation ExpenseLibra ryl-ibrary 10-1-5990-05 Depreciation ExpenseAdministrationAdministrati Tota I Financial Stabilty Transfers 10-1-5701-05 Transfer to Facility Reserves AdministrationAdmii 10-1-5715-05 Transfer to Furniture & EquipmAdministrationAd 10-1-5730-05 Transfer to Facility Reserve 10-1-5735-05 Transfer to EventsAdministrationAdministration 10-1-5740-05 Transfer to Furniture & EquipmAdministrationAd 10-1-5745-05 Transfer to Food ServicesAdministrationAdminisl 10-1-5750-05 Transfer to IT ReserveAdministrationAdministrati 15-1-5700-00 Transfer to OperatingAd mi nistrationLi bra ry 70-1-5770-05 Transfer to the City of FayettAdministrationAdmi Total Financial Stabilty Transfers Capital Reinvestment 10-1-5810-07 Computer & Technological EquipAdministrationf 10-1-5810-25 Computer & Technological EquipAdministrationf 10-1-5810-30 Computer & Technological EquipAdministrationf 10-1-5870-25 Furniture & Equipment (less thAdministrationFac 10-1-5871-25 Furniture & Equipment (greaterAdministrationFa 10-1-5873-25 VehiclesAdministrationFacilities 10-2-5810-09 Computer & Technological Equipl-ibrary Service( 30-1-5871-25 Furniture & Equipment (greaterAdministrationFa 40-1-5871-25 Furniture & Equipment (greaterAdministrationFa 50-1-5810-30 Computer & Technological EquipAdministrationf 80-3-5871-28 Furniture & Equipment (greaterEvents & Food Sr 85-3-5810-35 Computer & Technological EquipEvents & Food 85-3-5871-35 Furniture & Equipment (greaterEvents & Food S1 Total Capital Reinvestment & Depreciation Total Expenses Transfers Transfers to Foundation & Friends 10-1-6602-05 Transfer to Fayetteville PubliAdministrationAdmii Tota I YTD 7/31/2022 Current Year Annual Budget Annual Budget Adjusted Budget Actual Remaining Remaining % $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00% 0.00% $0.00 $0.00 $0.00 0.00% $120,000.00 $0.00 $120,000.00 100.00% $25,000.00 $12,500.00 $12,500.00 50.00% $8,000.00 $34,000.00 ($26,000.00) (325.00%) $96,200.00 $76,700.00 $19,500.00 20.27% $0.00 $0.00 $0.00 0.00% $113,500.00 $56,750.00 $56,750.00 50.00% $130,000.00 $35,000.00 $95,000.00 73.08% $400,000.00 $400,000.00 $0.00 0.00% $2,319,956.00 $1,143,895.63 $1,176,060.37 50.69% $3,212,656.00 $1,758,845.63 $1,453,810.37 45.25% $17,000.00 $2,009.60 $14,990.40 88.18% $6,000.00 $4,190.19 $1,809.81 30.16% $241,160.00 $142,485.59 $98,674.41 40.92% $0.00 $1,551.78 ($1,551.78) 0.00% $320,000.00 $0.00 $320,000.00 100.00% $100,000.00 $71,574.38 $28,425.62 28.43% $17,768.00 $19,884.59 ($2,116.59) (11.91%) $8,500.00 $0.00 $8,500.00 100.00% $32,500.00 $0.00 $32,500.00 100.00% $80,000.00 $23,999.00 $56,001.00 70.00% $0.00 $448.86 ($448.86) 0.00% $70,000.00 $921.89 $69,078.11 98.68% $149,000.00 $0.00 $149,000.00 100.00% $1,041,928.00 $267,065.88 $774,862.12 74.37% $13,340,878.00 $6,901,778.02 $6,439,099.98 48.27% $0.00 $3,000.00 ($3,000.00) 0.00% $0.00 $3,000.00 ($3,000.00) 0.00% Total Transfers $0.00 $3,000.00 ($3,000.00) 0.00% 18 08/05/2022 5:34:32 PM Page 4 Fayetteville Public Library Summarized Budget to Actual Preliminary: Subject to Audit - July 31, 2022 YTD 7/31/2022 Current Year Annual Budget Annual Budget Adjusted Budget Actual Remaining Remaining % NET SURPLUS/(DEFICIT) ($1,333,541.00) ($604,889.61) $728,651.39 54.64% 19 08/05/2022 5:34:32 PM Page 5 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 10 - Library Operations Assets Cash & Investments - Unrestricted 10-0-1001-00 Bank CreditLibraryLibrary 10-0-1002-00 Bank DebitLibraryLibrary 10-0-1003-00 Petty Cash LibraryLi bra ry 10-0-1010-00 Bank of FayettevilleLibraryLibrary 10-0-1020-00 ArvestLibraryLibrary 10-0-1030-00 1st SecurityLibraryLibrary 10-0-1120-00 Schwab Institutional -Operating LibraryLibrary Total Cash & Investments Accounts Receivable - Unrestricted As of July 31, 2022 2022 ($12,015.44) $1,171.88 $2,573.75 $86,829.63 $616,372.49 $300,060.73 $900,856.17 $1,895,849.21 10-0-1210-00 Due from Foundation $229,070.84 10-0-1215-00 Due from Friends LibraryLibrary $779.97 10-0-1225-00 Due From Other Gov. UnitsLibraryLibrary $4,771,642.40 10-0-1235-00 Due from Food ServicesLibraryLibrary $145,495.54 10-0-1236-00 Due from EventsLibraryLibrary $76,778.20 10-0-1240-00 Accounts ReceivableLibraryLibrary $2,539.91 10-0-1260-00 Payroll Tax Refund ReceivableLibraryLibrary ($793.54) 10-0-1270-00 Claim against credit card LibraryLibrary $634.88 10-0-1271-00 Less: Claim against credit card LibraryLibrary ($570.10) Total Acounts Receivable - Unrestricted $5,226,718.30 Accounts Receivable - Restricted 10-0-1150-00 DataPath Held DepositLibraryLibrary $1,200.00 10-0-1190-00 Claims PendingLibraryLibrary ($660.50) 10-0-1280-00 Prepaid ExpensesLibraryLibrary $58,252.92 Total Accounts Receivable - Restricted $58,792.42 Internal Due From 10-0-1221-00 Due From Expansion Operating Reserves - 15 ($0.13) 10-0-1223-00 Due From Facilities Reserve - 30 ($75,985.31) 10-0-1224-00 Due From Furniture & Equipment - 40 ($12,802.78) 10-0-1228-00 Due From Technology Reserve - 50 ($17,921.89) Total Internal Due From ($106,710.11) Interfund 10-0-1238-00 Due from Other Funds - InterfuLibraryLibrary $280,720.55 10-0-1400-00 InterfundLibraryLibrary ($1,232,238.97) Total Interfund ($951,518.42) Depreciable Assets 20 08/05/2022 5:40:24 PM Page 1 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 10-0-1801-00 BuildingsLibraryLibrary $21,080,384.43 10-0-1805-00 SoftwareLi bra ryLibrary $163,841.15 10-0-1811-00 Books & PublicationsLibraryLibrary $5,891,779.72 10-0-1813-00 EquipmentLibraryLibrary $2,978,184.26 10-0-1999-00 Accumulated Depreciation LibraryLi bra ry ($14,224,526.88) Total Depreciable Assets $15,889,662.68 Non -Depreciable Assets 10-0-1800-00 Land $1,449,585.02 10-0-1850-00 Library Owned ArtLibraryLibrary $150,000.00 10-1-1800-00 Fixed AssetAdministration Library $0.07 Total Non-Depeciable Assets $1,599,585.09 Total Assets $23,612,379.17 Liabilities and Fund Balance Liabilities - Accounts Payable 10-0-2001-00 Accounts PayableLibraryLibrary $29,330.47 10-0-2003-00 Security Bankcard Center, INC.LibraryLibrary $2,271.00 10-0-2025-00 Accrued Sales Tax PayableLibraryLibrary ($5,436.33) 10-0-2055-00 Federal Withholding PayableLibraryLibrary $1,068.09 10-0-2065-00 FICA PayableLibraryLibrary ($1,105.35) 10-0-2075-00 Health InsuranceLibraryLibrary $420.42 10-0-2080-00 State Withholding PayableLibraryLibrary $525.13 10-0-2082-00 State Unemployment PayableLibraryLibrary $426.15 10-0-2094-00 Accident Death & Disability InLibraryLibrary ($0.50) 10-0-2130-00 Vision InsuranceLibraryLibrary ($65.40) 10-0-2135-00 Life, AD&D and LTDLibraryLibrary $1,219.52 10-0-2140-00 Voluntary Life, STD & AD&DLibraryLibrary ($1,163.68) 10-0-2150-00 Retirement ContributionsLibraryLibrary $84.45 10-0-2155-00 Voluntary Dental Insurance ($500.42) 10-0-2180-00 Caring Com mitteeLi bra ryLibrary ($2,086.96) 10-0-2185-00 Healthy HabitsLibraryLibrary $4,819.88 10-0-2190-00 Arkansas State Library ScholarLi bra ryLibrary $793.12 10-0-2410-00 Deferred RevenueLibraryLibrary $488,558.53 Total Liabilities - Accounts Payable $519,158.12 Accrued Liabilities 10-0-2045-00 Vacation Accrual LibraryLi bra ry $235,988.14 10-0-2060-00 Sick Time Accrual LibraryLibrary $86,969.39 Total Accrued Liabilities $322,957.53 21 08/05/2022 5:40:24 PM Page 2 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 Internal Due To 10-0-2225-00 Due to Long Term - 20 $76,241.45 10-0-2228-00 Due to Food Services Libra ryLi bra ry ($27,621.60) 10-0-2230-00 Due to FriendsLibraryLibrary ($358.13) 10-0-2235-00 Due to Technology Reserve - 50 $103,000.10 10-0-2240-00 Due to FoundationLibraryLibrary $2,036.03 10-0-2270-00 Due to Debt Service Fund LibraryLibrary ($1.47) 10-0-2275-00 Due to EventsLibraryLibrary $114,678.75 Total Internal Due To $267,975.13 Interfund 10-0-2255-00 Due to Other Funds - InterfundLibraryLibrary $18,731.10 Total Interfund $18,731.10 Fund Balance 10-0-3001-00 U n restricted Libra ryl-i bra ry $2,254,777.43 10-0-3900-00 Fund Balance - Current Year NeLibraryLibrary $793,564.99 10-0-3950-00 Investment in Capital AssetsLibraryLibrary $19,435,214.87 Total Fund Balance $22,483,557.29 Total Liabilities and Fund Balance $23,612,379.17 22 08/05/2022 5:40:24 PM Page 3 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 15 - Expansion - Operations Assets Cash & Investments - Unrestricted 15-0-1123-00 Schwab Institutional -Expansion Libra ryLibrary $587,163.45 Total Cash & Investments $587,163.45 Interfund 15-0-1400-00 I nterfu nd Li bra ryLi bra ry $3,899,882.78 Total Interfund $3,899,882.78 Total Assets $4,487,046.23 Liabilities and Fund Balance Internal Due To 15-0-2220-00 Due To Operating-10LibraryLibrary ($0.13) Total Internal Due To ($0.13) Fund Balance 15-0-3001-00 U n restricted Libra ryLi bra ry $4,487,046.36 Total Fund Balance $4,487,046.36 Total Liabilities and Fund Balance $4,487,046.23 23 08/05/2022 5:40:24 PM Page 4 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 20 - Long Term- Reserve Assets Cash & Investments - Designated 20-0-1125-00 Schwab Institutional - Long-teLibraryLibrary $1,649,703.58 Total Cash & Investments - Designated $1,649,703.58 Internal Due From 20-0-1220-00 Due From Operating - 10 $76,241.45 20-0-1228-00 Due From Technology Reserve - 50 ($0.93) Total Internal Due From $76,240.52 Interfund 20-0-1400-00 I nterfu nd Li bra ryLi bra ry ($1,115,400.24) Total I nterfund ($1,115,400.24) Total Assets $610,543.86 Liabilities and Fund Balance Fund Balance 20-0-3015-00 Designated - Long Term Reserve Libra ryLibrary $652,458.29 20-0-3900-00 Fund Balance - Current Year NeLibraryl-ibrary ($41,914.43) Total Fund Balance $610,543.86 Total Liabilities and Fund Balance $610,543.86 24 08/05/2022 5:40:24 PM Page 5 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 30 - Facility Reserve Assets Cash & Investments - Designated 30-0-1126-00 Schwab - Facilities ReplacemenLibraryLibrary $540,034.06 Total Cash & Investments - Designated $540,034.06 Interfund 30-0-1238-00 Due from Other Funds - InterfuLibraryLibrary $29.60 30-0-1400-00 InterfundLibraryLibrary $3,787.37 Total Interfund $3,816.97 Total Assets $543,851.03 Liabilities and Fund Balance Internal Due To 30-0-2220-00 Due To Operating - 10 ($75,459.01) Total Internal Due To ($75,459.01) Interfund 30-0-2255-00 Due to Other Funds - InterfundLibraryLibrary $143,975.90 Total Interfund $143,975.90 Fund Balance 30-0-3020-00 Designated - Facility ReserveLibraryLibrary $505,129.66 30-0-3900-00 Fund Balance - Current Year NeLibraryl-ibrary ($29,795.52) Total Fund Balance $475,334.14 Total Liabilities and Fund Balance $543,851.03 25 08/05/2022 5:40:24 PM Page 6 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 40 - Furniture & Equipment Reserve Assets Cash & Investments - Designated 40-0-1127-00 Schwab - Furn. & Eq. 2100-3837Libraryl-ibra ry $261,863.54 Total Cash & Investments - Designated $261,863.54 Interfund 40-0-1400-00 InterfundLibraryLibrary $43,381.31 Total Interfund $43,381.31 Total Assets $305,244.85 Liabilities and Fund Balance Internal Due To 40-0-2220-00 Due To Operating - 10 ($12,802.78) Total Internal Due To ($12,802.78) Interfund 40-0-2255-00 Due to Other Funds - InterfundLibraryLibrary $12,802.78 Total Interfund $12,802.78 Fund Balance 40-0-3025-00 Designated - Furniture & EquipLibraryLibrary $313,993.59 40-0-3900-00 Fund Balance - Current Year NeLibraryLibrary ($8,748.74) Total Fund Balance $305,244.85 Total Liabilities and Fund Balance $305,244.85 26 08/05/2022 5:40:24 PM Page 7 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 50 - Technology Equipment Reserve Assets Cash & Investments - Designated 50-0-1128-00 Schwab - Technological EquipmeLibraryLibrary $310,293.60 Total Cash & Investments - Designated $310,293.60 Internal Due From 50-0-1220-00 Due From Operating - 10 $103,000.10 Total Internal Due From $103,000.10 Interfund 50-0-1238-00 Due from Other Funds - InterfuLibraryLibrary $18,500.00 50-0-1400-00 InterfundLibraryLibrary $365,371.12 Total Interfund $383,871.12 Total Assets $797,164.82 Liabilities and Fund Balance Internal Due To 50-0-2220-00 Due To Operating - 10 ($17,921.89) 50-0-2225-00 Due to Long Term - 20 ($0.93) Total Internal Due To ($17,922.82) Interfund 50-0-2255-00 Due to Other Funds - InterfundLibraryLibrary $46,160.56 Total Interfund $46,160.56 Fund Balance 50-0-3030-00 Designated - Technological EquLibraryLibrary $787,264.38 50-0-3900-00 Fund Balance - Current Year NeLibraryLibrary ($18,337.30) Total Fund Balance $768,927.08 Total Liabilities and Fund Balance $797,164.82 27 08/05/2022 5:40:24 PM Page 8 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 60 - Capital Construction Fund Assets Cash & Investments - Designated 60-0-1140-00 Schwab - Expansion Capitall - LibraryLibrary $4.36 Total Cash & Investments - Designated $4.36 Interfund 60-0-1400-00 InterfundLibraryLibrary ($192,503.91) Total Interfund ($192,503.91) Depreciable Assets 60-0-1890-00 Construction In Progress (CIP)LibraryLibrary $1,080,831.73 Total Depreciable Assets $1,080,831.73 Total Assets $888,332.18 Liabilities and Fund Balance Interfund 60-0-2255-00 Due to Other Funds - InterfundLibraryLibrary $77,579.81 Total Interfund $77,579.81 Fund Balance 60-0-3005-00 Restricted Fund BalanceLibraryLibrary $810,752.37 Total Fund Balance $810,752.37 Total Liabilities and Fund Balance $888,332.18 28 08/05/2022 5:40:24 PM Page 9 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 70 - Bond Debt Service Fund Assets Accounts Receivable - Restricted 70-0-1225-00 Due From Other Gov. UnitsLibraryLibrary $2,230,114.97 Total Accounts Receivable - Restricted $2,230,114.97 Internal Due From 70-0-1227-00 Due from UnreservedLibraryLibrary ($1.47) Total Internal Due From ($1.47) Interfund 70-0-1400-00 InterfundLibraryLibrary ($1,772,279.58) Total Interfund ($1,772,279.58) Total Assets $457,833.92 Liabilities and Fund Balance Fund Balance 70-0-3005-00 Restricted Fund BalanceLibraryLibrary $457,833.92 Total Fund Balance $457,833.92 Total Liabilities and Fund Balance $457,833.92 29 08/05/2022 5:40:24 PM Page 10 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 80 - Food Services Assets Cash & Investments - Unrestricted 80-0-1003-00 Petty Cash Libraryl-i bra ry $675.00 80-0-1050-00 Arvest - Food ServicesEvents & Food SFood Service $130,051.28 Total Cash & Investments $130,726.28 Internal Due From 80-0-1220-00 Due From Operating - 10LibraryLibrary ($27,621.60) Total Internal Due From ($27,621.60) Interfund 80-0-1238-00 Due from Other Funds - InterfuLibraryLibrary $201.50 Total Interfund $201.50 Total Assets $103,306.18 Liabilities and Fund Balance Liabilities - Accounts Payable 80-0-2001-00 Accounts PayableLibraryLibrary $2,247.06 80-0-2411-00 Gift CardsLibraryLibrary $317.53 Total Liabilities - Accounts Payable $2,564.59 Accrued Liabilities 80-0-2045-00 Vacation AccrualLibraryl-ibrary$1,334.45 80-0-2056-00 HMR TaxLibraryLibrary $592.13 80-0-2057-00 Sales TaxLibraryLibrary $2,122.96 Total Accrued Liabilities $4,049.54 Internal Due To 80-0-2220-00 Due to Operating-10LibraryLibrary $145,495.54 Total Internal Due To $145,495.54 Interfund 80-0-2255-00 Due to Other Funds - InterfundLibraryLibrary $201.50 Total Interfund $201.50 Fund Balance 80-0-3001-00 UnrestrictedLibraryl-ibrary($49,004.99) Total Fund Balance ($49,004.99) 30 08/05/2022 5:40:24 PM Page 11 Fayetteville Public Library Balance Sheet Total Liabilities and Fund Balance Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 $103,306.18 31 08/05/2022 5:40:24 PM Page 12 Fayetteville Public Library Balance Sheet Preliminary: Subject to Audit - July 31, 2022 As of July 31, 2022 2022 85 - Events Assets Internal Due From 85-0-1220-00 Due From Operating - 10LibraryLibrary $133,363.75 Total Internal Due From $133,363.75 Total Assets $133,363.75 Liabilities and Fund Balance Accrued Liabilities 85-0-2045-00 Vacation AccrualLibraryLibrary $1,480.88 85-0-2060-00 Sick Time Accrual LibraryLibrary $398.85 Total Accrued Liabilities $1,879.73 Internal Due To 85-0-2220-00 Due to Operating-10LibraryLibrary $76,778.20 Total Internal Due To $76,778.20 Fund Balance 85-0-3001-00 U n restricted Libra ryl-i bra ry $54,705.82 Total Fund Balance $54,705.82 Total Liabilities and Fund Balance $133,363.75 32 08/05/2022 5:40:24 PM Page 13 Fayetteville Public Library Budget 2023 Calendar D. o. Activity June through July Budget preparation Thursday, July 21, 2022 Budget kickoff meeting July through September Working sessions with departments September through October Internal review of combined budget proposal to discuss key issues and finalize budgetary decisions November / December Presentation / Adoption of budget January Fiscal year begins January 1 33 6/16/2022 - 7/15/2022 CAPITAL CAMPAIGN ACTIVITIES Meetings and Actions I Date Joutcome I Notes Event: Meet the Funders 6/16/2022 Strategy and networking Lauren attended the annual Meet the Funders event at FPL for networking, education, and strategy. Event: SONA Gala 6/16/2022 Cultivation David attended the event where many donors and prospective donors were present. Christina is working with Emory Solutions to revamp FPL's website. This meeting was a website redesign Meeting: Emory Solutions 6/17/2022 Strategy walkthrough. Development staff submitted a proposal to be reimbursed for $89k of utility payments to compensate Submission: City of Fayetteville ARPA proposal 6/17/2022 Funding opportunity for revenue lost to COVID-19 factors. Development staff met with implementation partners to continue learning the new donor management Meeting: WhiteRock 6/20/2022 Strategy software. Meeting: FPL Board of Trustees 6/20/2022 Reporting Development staff attended and reported on Foundation activities and financials. Meeting: Foundation Finance Committee 6/21/2022 Reporting Foundation finance committee met to discuss March financials and revenue priorities. Development staff sent an email to patrons marketing a 2:1 gift matching opportunity for Walmart Email: FPL patrons 6/22/2022 Cultivation associates. Chirstina spoke with this 7 Hills Homeless Shelter executive as part of FPL's community needs Meeting: Community partner 6/22/2022 Community building assesment. Meeting: Community partner 6/22/2022 Funding opportunity FPL's execitve director and development director met to discuss federal funding opporunities David toured with incoming Board of Trustees President. Christina stepped in to strategize about a Tour: Incoming Board of Trustees President 6/23/2022 Strategy major gift prospect. Event: Foundation Meet & Greet 6/24/2022 Strategy and cultivation Development staff and board officers hosted a meet and greet for Foundation board candidates. Development met with events staff to discuss an upcoming concert and fundraising opportunity in Meeting: FPL events staff 6/27/2022 Event planning partnership with Natural State Distributing. Christina is working with Emory Solutions to revamp FPL's website. This meeting was a website final Meeting: Emory Solutions 6/27/2022 Strategy review. Kelsey recorded and sent a Gratavid to FPL donors thanking for support and informing on library Email: FPL Donors 6/28/2022 Stewardship outreach activities. Meeting: FPL Foundation Board 6/28/2022 Strategy Foundation Board met to discuss Foundation activities, capital campaign strategy and action items. Lauren met to recruit this contact to the Foundation events committee. He is a licensed CPA, works for Meeting: Foundation committee prospect 6/28/2022 Cultivation Tyson and a library patron. David spoke with UA's Center for business and Economic Research executive as part of FPL's community Meeting: Community partner 6/29/2022 Community building needs asessment. Christina met with events staff to discuss partnership oppurtunities for an upcoming Collier and Meeting: FPL events staff 6/29/2022 Event planning Associates event at FPL. Proceeds will benefit FPLF. Development staff met with members of the dinner series committee to discuss the Midsummer Meeting: Dinner series committee 6/29/2022 Event planning Night's Dinner fundraiser on September 16. Christina is working with Emory Solutions to revamp FPL's website. This meeting was a website Meeting: Emory Solutions 6/29/2022 Strategy executive review. Development staff mailed summer postcards to donors thanking for support and informing on current Mailing: Foundation summer postcard 6/30/2022 Stewardship and upcoming events. Lauren attended Kidz Night at the Gulley Park concert series with outreach staff to market FPL and the Event: Kidz Night at Gulley Park 6/30/2022 Cultivation expansion to the community. Meeting: FPL marketing staff 6/30/2022 Strategy Christina met with marketing staff to review expansion signage and navigation needs at FPL. Lauren met to recruit this contact to the Foundation development committee. He works for Runway Meeting: Foundation committee prospect 7/1/2022 Cultivation Group and has experience in City planning. 34 Meeting: Foundation committee prospect Email: FPL Donors Event: Website Redesign Launch Meeting: Emory Solutions Meeting: donor Meeting: Incoming Foundation Board President Meeting: Wipfli and WhiteRock Meeting: FPL events staff Email: Foundation board Meeting: Emory Solutions Meeting: Incoming Foundation Board member Meeting: WhiteRock Meeting: WhiteRock Submission: Citv of Favetteville ARPA proposal 7/3/2022 Cultivation 7/6/2022 Stewardship 7/6/2022 Strategy 7/6/2022 Strategy 7/7/2022 Stewardship and Straegy 7/7/2022 Strategy 7/11/2022 Strategy 7/11/2022 Event planning 7/12/2022 Stewardship 7/13/2022 Strategy 7/14/2022 Strategy and event planning 7/14/2022 Strategy 7/15/2022 Strategy 7/15/2022 Funding opportunity Lauren met to recruit this contact to the Foundation events committee. She works for Canopy NWA and has nonprofit experience. Kelsey recorded and sent a Gratavid to FPL donors thanking for support and informing on library outreach activities. The website redesign, which strongly highlights library giving and the expansion, was released to the public. Christina met with website design partners to review the website redesign launch. Christina met with Susa, a long time donor to FPLF. She has been instrumental in securing capital gifts. Christina met with incoming Foundation board president to discuss duties and strategy. Development staff met with implementation partners to map accounts to donor management software. Development met with events staff to discuss changes to the Sink Sonic Band concert in partnership with Natural State Distributing. Christina emailed Foundation board and committee members with Foundation and library updates and action items. Christina met with Emory Solutions to review and make edits to FPL's updated website. Christina met with this incoming Foundation board member to discuss fundraising event strategy for 2023. Lauren met with implementation partners to review and edit volunteer management software. Lauren met with implementation partners to map accounts to donor management software. Development staff submitted a proposal to fund workforce development softwares, programs, and infrastructure. 35 H E111 YO N D WORDS CAMPAIGN GOAL: $23,000,000 Capital Campaign Pledge Summary Report 7/15/2022 Pledged To Date: $14,216,379 = 61.8% Of Goal Balance Required: $8,783,621 Campaign Summary by Gift Categories # of Percent to Balance Unique Goals Pledged Goal $$-To Go Total Paid Due Donors $250,000 & above Pacesetter $20,000,000 $11,337,463 = 56.7% $8,662,537 $5,887,463 $5,450,000 8 $50,000 - $249,999 Leadership 2,250,000 1,884,275 = 83.7% $365,725 $1,434,775 $449,500 21 $5,000 - $49,999 Major 650,000 867,820 133.5% ($217,820) $686,674 $181,146 64 Under$5,000 Community 100,000 126,821 = 126.8% ($26,821) $118,781 $8,041 324 TOTAL: $23,000,000 $14,216,379 61.8% $8,783,621 $8,127,694 $6,088,687 417 Meetings and Actions Meeting: FPLF Finance Committee Meeting: FPLF Events Committee Meeting: FPL Directors Meeting: Teresa Cornett Meeting: Melissa Terry Meeting: Michelle Glass and Bill Underwood Meeting: FPLF Officers Meeting: Wipfli and WhiteRock Email: FPL Donors Event: Spark of Hope gala Event: Dream Big Charity Gala Meeting: Holly Johnson Meeting: ARPA grant stakeholders Meeting: Wipfli and WhiteRock Meeting: Donor Meeting: Teresa Cornett and Kerri McMahon Meeting: Malone Consultants Group Meeting: FPLF Events Committee Email: FPL Donors Event: FPLF Board Orientation Interview: KNWA Event: Collier and Assoc. House Party Event: ARPA Council Workshop Email: FPL patrons Meeting: Teresa Cornett Date Outcome Notes 7/19/2022 Reporting Foundation finance committee met to discuss financials and revenue priorities. 7 new members joined the events committee. Development staff met with the committee to discuss 7/20/2022 Event planning upcoming events and areas in need of support. FPL Directors met to discuss the status of FPL+, the extended hours library included in the scope of the 7/20/2022 Strategy capital campaign. 7/20/2022 Strategy Christina met with incoming Foundation board president to discuss duties and strategy. 7/20/2022 Strategy Christina and David met with Melissa to discuss a USDA urban agriculture grant opportunity. Christina met with prospective donors about pledge and naming opportunities. Bill owns Underwood 7/22/2022 Cultivation Jewelers. Christina and current and incoming FPLF officers met to discuss the purpose and role of the events and 7/26/2022 Strategy development committees. 7/27/2022 Strategy Development staff met with implementation partners to map accounts to donor management software. 7/27/2022 Stewardship Christina sent an email to donors announcing early access to A Midsummer Night's Dinner tickets. Christina attended a fundraiser hosted by Single Parent Scholarship Fund with major donors. Several 7/28/2022 Cultivation and networking prospective donors were present. Christina attended a gala hosted by Children's Safety Center with board members. Several prospective 7/30/2022 Cultivation and networking donors were present. 8/1/2022 Stewardship and Straegy Holly is a donor and community connector. Christina met with her to discuss strategy and networking. FPL staff involved in a $2.5 mil ARPA grant submitted to the City of Fayetteville met to discuss 8/2/2022 Strategy presentation strategy. 8/2/2022 Strategy Development staff met with implementation partners to map accounts to donor management software. Margaret is a donor and community connector. Christina met with her to discuss strategy and 8/2/2022 Stewardship networking. 8/2/2022 Strategy Lauren met with current and incoming board members to prepare for the upcoming board orientation. 8/3/2022 Strategy Chirstina met with Alison for a leadership and career development coaching session. 8/3/2022 Event planning Development staff met with the committee to strategize upcoming events and areas in need of support. Kelsey recorded and sent a Gratavid to FPL donors thanking for support and informing on the upcoming 8/4/2022 Stewardship Henry Rollins talk. Development staff and board officers hosted an orientation and training for new and returning board 8/4/2022 Strategy members. 8/5/2022 Marketing Lauren was interviewed by KNWA about phase 2 of the capital campaign and the Center for Innovation. Lauren tabled at the Collier and Assoc. community event at FPL. Donations and raffle proceeds 8/5/2022 Marketing benefitted FPLF. FPL staff presented on a $2.5 mil ARPA funding proposal to the Fayetteville City Council. An $89k 8/6/2022 Potential funding proposal is also being considered. Development staff sent an email to patrons marketing the upcoming FPLF event, A Midsummer Night's 8/8/2022 Cultivation Dinner. Christina met with incoming Foundation board president to discuss follow-up items from the board 8/9/2022 Strategy orientation. 37 H E111 YO N D WORDS CAMPAIGN GOAL: $23,000,000 Capital Campaign Pledge Summary Report 8/10/2022 Pledged To Date: $14,252,412 = 62.0% Of Goal Balance Required: $8,747,588 Campaign Summary by Gift Categories # of Percent to Balance Unique Goals Pledged Goal $$-To Go Total Paid Due Donors $250,000 & above Pacesetter $20,000,000 $11,337,463 = 56.7% $8,662,537 $5,887,463 $5,450,000 8 $50,000 - $249,999 Leadership 2,250,000 1,894,275 = 84.2% $355,725 $1,444,775 $449,500 21 $5,000 - $49,999 Major 650,000 885,033 136.2% ($235,033) $706,254 $178,779 64 Under$5,000 Community 100,000 135,642 = 135.6% ($35,642) $123,962 $11,681 333 TOTAL: $23,000,000 $14,252,412 62.0% $8,747,588 $8,162,453 $6,089,960 426 38 FPL FOUNDATION BOARD CANDIDATES TERM 2022 - 2025 Name Description Title / Company Luke has a legal background. He's worked at Runway Group and has a connection to Walton Foundation. He currently works at Blue Acquisitions Associate / Blue Crane Luke Brasuell Crane and is the Co -Founder of NWA Daily. Co -Founder / NWA Daily Randy is currently serves as President on the Ozark Natural Foods board. He is an entrepreneur, consultant, leadership trainer, founder and podcaster at I Am Northwest Arkansas. He is a Entrepreneur, Founder, Host / I Am Randy Wilburn relationship and community builder. Northwest Arkansas Mike is a Partner at Daily & Woods Attorneys at Law. He and his wife live in Downtown Fayetteville, and are active in their Mike Daily community. They love the library and are well connected Partner / Daily & Woods t sue@Ri h level of community involvement, event planning, and is a connector to the business community. She currently serves on the Apple Seeds board and works at Signature Bank of Executive Assistant to CEO / Signature Jessica Gray Arkansas. Bank Teresa has served on the FPL Foundation board for several years, and is interested in returning. She has connections to other nonprofits and community members, and has remained engaged Teresa Cornett since rolling off. Retired teacher / Community Volunteer Rachel is a recent UA Law School graduate. She is the Assistant Director of the McMillon Innovation Studio for UA. She's a doer and Assistant Director, McMillon Innovation Rachel Sullivant a connector. Studio / University of Arkansas Eva is a loyal patron and donor. Eva has extensive fundrasing Development Director / Peace at Home Eva Terry experience and is a CFRE (Certified Fund Raising Executive). Family Shelter Hannah has an extensive background working in retail with Walmart and P&G. She recently made the move to A Street Ventures, a Walton Family company. She lives in Fayetteville with Hannah Duell Clark her husband and 3 kids. Operations / A Street Ventures 39 Resolution of Fayetteville Public Library to Open, Close, and Sign Accounts WHEREAS, the trustees of the Fayetteville Public Library determine it is in the best interest of the Library to designate certain trustees to administer the financial affairs of the Library, NOW, THEREFORE BE IT RESOLVED that. The Library Board of Trustees authorizes the trustees listed below to open, close, and sign Library accounts and transactions at First Security Bank, the Bank of Fayetteville (Farmers and Merchants Bank), Garrison Financial, Generations Bank, Arvest Bank, and any other banking institution located in Fayetteville, Arkansas. BE IT FURTHER RESOLVED that any persons not listed below be removed as signatories to Fayetteville Public Library accounts and transactions. Library Trustee and Office Signature Bret Park, President Sallie Overbey, Vice -President Stan Rodgers, Treasurer Martha Sutherland, Secretary Martha Sutherland, Secretary Date 40 FAYETTEVILLE PUBLIC LIBRARY Formal Record of Action The undersigned authorized representative of the Board of Trustees for the Fayetteville Public Library (the "Library'), hereby certifies that the Board of Trustees duly adopted the following resolutions on the date specified below and that the Board of Trustees has neither modified nor rescinded the following resolutions as of the date hereof; WHEREAS, the Library currently maintains retirement plans known as the Fayetteville Public Library 457(b) Plan (the "457(b) Plan") and the Fayetteville Public Library Employee Retirement Saving Plan (the "401(a) Plan"), collectively the "Plans"; WHEREAS, effective October 1, 2022 the Library ("Named Fiduciary") wishes to adopt Investment Management services, and herby appoints BOKF, NA (hereinafter referred to as "the Investment Manager"), to provide the investment management services described below. The Named Fiduciary represents that (a) it has the authority under the Plan to engage the services of an Investment Manager, and to grant such Investment Manager authority to make recommendations regarding Plan assets ("Included Assets"), and to direct the Trustee with respect to acquisition or disposition of Included Assets consistent with such recommendations, and (b) it has appointed no other investment advisor to perform the services described herein with regard to the Included Assets. Those responsible for the management and administration of the Plan's investments include, but are not limited to: A. The Named Fiduciary is responsible for selecting the trustees, hiring the record keeper, and selecting investment advisory consultants. The Named Fiduciary is also responsible for: 1) Establishing and maintaining the Investment Policy Statement. 2) Selecting and monitoring the 3(38) Investment Fiduciary. 3) Controlling and accounting for all investment, recordkeeping and administrative expenses associated with the Plan. 4) Providing Plan participants with investment education and communications. B. The Investment Manager is responsible for: 1) Assisting with the development and review of the Investment Policy Statement. 2) Selecting investment options. 3) Providing periodic performance reports and evaluating the investment performance of the options offered in the Plan and, if appropriate, making changes to the Plan's investment options. 4) Assist with controlling and accounting for all investment expenses associated with the Plan; and upon request, assist with the assessment of the recordkeeping and administrative expenses associated with the Plan. The Investment Manager is authorized to continue to work with and to provide information to a Named Fiduciary Representative until notified otherwise by the Board of Trustees in writing. NOW THEREFORE, IN CONSIDERATION OF THE FOREGOING PREMISES, IT IS: RESOLVED: that the Board has designated BOKF, NA to serve as the Investment Manager as defined under Article 2 of the Plan. 41 The undersigned authorized representative of the Board of Trustees for the Fayetteville Public Library hereby further certifies that the Plan Administrator under the Plans has been authorized by a named fiduciary under the Plans to engage the services of the Investment Manager in the foregoing resolutions. Signed: Title: Date: 42 0 Fayetteville Public Library MEMO To: Fayetteville Public Library Board of Trustees From: David Johnson, Executive Director Date: Monday, August 15, 2022 Re: 2023 Benefits Background: Gallagher Benefits Services, Inc., the Library's insurance broker, presented information related to the renewal of the library's health insurance plans. The City of Fayetteville City Council approved the continuation of The City's current medical benefit plans with Arkansas Blue Cross Blue Shield with a 16.8% premium increase in the city council meeting on Tuesday, August 2, 2022. FPL's benefit plans are a part of the City's benefit plans to ensure the most competitive benefit offerings for FPL staff. As a method to minimize the rate increase of the Medical-BCBS plan, Gallagher recommended that Vision insurance be bundled with medical insurance coverage and that the provider be changed from Superior Vision to VSP. This change allows the medical renewal to be reduced from 19.8% to 16.8% as well as the ability to offer staff the choice of two vision plans. Delta Dental renews with no plan changes at a 4.5% increase. Employee and FPL cost -share proposal is brought forward at this time to ensure that annual open enrollment may proceed according to schedule. Discussion: FPL currently offers two different medical plans to eligible staff members - a PPO Plan and a High Deductible Health Plan (HDHP). Both the PPO Plan and the High Deductible Health Plan (HDHP) will have a 16.8% premium increase in 2023. FPL is proposing to split the cost increase 50/50 between the employee and FPL. High Dedue bleHealth Plan At FPL in the current 2022 plan year, eligible employees contribute $69.97 toward the $374.16 premium for single coverage for the HDHP plan. This premium is increasing by 16.8% to $437.02 for the 2023 plan year. It is recommended that the premium increase be spilt 50/50 by the employee and FPL for the 2023 plan year. 43 High Deductible Health Plan (HDHP) Total Total Increased Monthly Monthly Monthly Monthly # EE Monthly Monthly Cost Employee Employee Employer Employer Rate Tier Plan Premium Premium Over Contribution Contribution Contribution Contribution 2022 2023 2022 2022 2023 2022 2023 Employee Only 34 $374.16 $437.02 $62.86 $69.97 $101.40 $304.19 $335.62 Employee + 2 $806.96 $942.52 $135.56 $157.25 $225.03 $649.71 $717.49 Spouse Employee + 4 $611.28 $713.98 $102.70 $119.11 $170.46 $492.17 $543.52 Child(ren) Employee + 7 $1,133.18 $1,323.54 $190.36 $220.81 $315.99 $912.37 $1,007.55 Family PPO Plan At FPL in the current 2022 plan year, eligible employees contribute $209.35 toward the $719.14 premium for single coverage for the PPO Plan. This premium is increasing by 16.8% to $839.96 for the 2023 plan year. It is recommended that the premium increase be spilt 50/50 by the employee and FPL for the 2023 plan year. PPO Plan Total Total Increased Monthly Monthly Monthly Monthly # EE Monthly Monthly PremiumEmployee Employee Employer Employer Rate Tier Plan Premium Premium Cost Contribution Contribution Contribution Contribution 2022 2023 Over 2022 2023 2022 2023 2022 Employee Only 9 $719.14 $839.96 $120.82 $209.35 $269.76 $509.79 $570.20 Employee + 1 $1,568.08 $1,831.52 $263.44 $627.26 $758.98 $940.82 $1,072.54 Spouse Employee + 1 $1,294.42 $1,511.88 $217.46 $517.78 $626.51 $776.64 $885.37 Child(ren) Employee + 2 $2,134.22 $2,492.76 $358.54 $853.72 $1,032.99 $1,280.50 $1,459.77 Family Recommendation: It is recommended The Board of Trustees approve the employee benefits cost -share proposal as outlined above. 44 0 Fayetteville Public Library MEMO To: Fayetteville Public Library Board of Trustees From: David Johnson, Executive Director Date: August 15, 2022 Re: City of Fayetteville & FPL Solar Proposal Background: The City of Fayetteville is evaluating an Energy Savings Performance Contract (ESPC) with Johnson Controls Inc. (JCI). The ESPC will address deferred maintenance projects and reduce energy consumption across nearly 50 buildings in the City's management portfolio. Included are upgrades to lighting, water conservation, HVAC, building weatherization, building automation controls, and rooftop solar. Four rooftop solar projects are proposed at: the new Police Headquarters, Recycling and Trash Center, Town Center, and Fayetteville Public Library. After nearly two years of research, energy audits, and project development, the ESPC is ready for final approval from all parties included in scope before moving forward for City Council Approval. Discussion: The project details recommended for the Fayetteville Public Library Rooftop Solar Array include: A project recommendation for a 176kW solar array that will last 25-30 years. The total project will cost is $625,000. This includes all project management costs which are 10% construction price. The City will pay for development of this project and be reimbursed by the Library through annual payments or deducts of $34,000 for 20 years at 0% interest Monitoring and maintenance of the array will be handled through SEAL solar under a 20-year contract already included in the project cost Estimated annual savings are $18,000- $24,000. Estimated total net -savings at end of the solar array life is $25,000. This a conservative estimate based on 2021 energy and financial models. A 2.3% annual utility cost escalation rate is incorporated into the savings model. 45 Fayetteville Public Library Rooftop Solar Array Location: Library Extension Roof Solar Array Size: 176kW Solar Array Productive Life: 25-30 years Ownership Model: Owned by client (building owner) Solar Developer: System Monitoring & Maintenance: SEAL Solar 20 year contract Project Cost: $ 624,879 Annual Payment $ 33,904 Loan Payment Period: 20 YEARS Project Management Cost (included): 10% Interest Rate: 0% Estimated Annual Utility Savings $18,000-$24,000 Estimated Project Net -Savings (@30yrs): $ 24,586 Please note that the City's current solar arrays are creating savings much higher than estimated due to increased energy costs and we anticipate this accelerated savings to continue for all solar projects due to increasing energy costs related to fuel price volatility and utility infi-astructure cost -recovery rate increases. Below is a graph of the savings generated from the two ground -mount solar arrays at the City's wastewater treatment plants. The Library rooftop solar savings profile will look differently, but we wanted to share the benefits we are seeing from solar. -0MMOO 351OW.00 30,000.00 25,900.00 d 4 �ouau.00 i isoaaoo W10W.00 5,00100 Total Solar Savings (VMPs) 1M 3% 1� 19 1% 4,9 •R9 -P -P 'IQ+ � 1� -P � 'IQ "I'RN a a 'J .n} tti IN 1% 1% a a 4 11 a 0 Months ■ Cumulative Emissions Saved 0CumulativeS5avings s �DgW0 i60q�00 $SOO,WO a SoW,Wa r+ N 5300.000 E V 5200,000 46 Recommendation: Library staff recommends monitoring the City's discussions as they evaluate the long term cost/benefits of the project. 47