Loading...
HomeMy WebLinkAbout042523 agenda packetWORK SESSION AGENDA Date: Tuesday, April 25, 2023 Time: 9:00 a.m. Location: Commissioners Meeting Room Harnett County Resource Center & Library 455 McKinney Parkway, Lillington Harnett County Board of Commissioners Page | 1 1.Call to order – Chairman Matt Nicol 2.Pledge of Allegiance and Invocation – Commissioner Lewis Weatherspoon 3.Sandhills Program Update and Budget Request; Victoria Whitt, CEO with Sandhills Center 4.Good Hope Behavioral Hospital Update; Mark Morris, Executive Director 5.Mental Health Month Proclamation 6.Discuss System Development Fees; Steve Ward, Harnett Regional Water Director 7.Riverside Community Drainage Improvement Project Update; Lynn Lambert, Natural Resources Director/Conservation Education Coordinator 8.Update on Opioid Task Force; Christopher Appel, Senior Staff Attorney and Coley Price, Deputy County Manager 9.Discuss revocation of offer to sale for Monroe Lane; Christopher Appel, Senior Staff Attorney 10.Compensation Study Update; Janice Lane, HR Director and Pontifex 11.Discuss proposed changes to Article III - The Pay Plan Section 8; Brent Trout, County Manager 12.Finance Quarterly Update; Kimberly Honeycutt, Finance Officer 13.Review applications to serve on Boards and Committees. 14.County Manager’s Report - Brent Trout, County Manager •May 1, 2023 Regular Meeting Agenda Review •Upcoming meetings and invitations 15.Closed Session 16.Adjourn CONDUCT OF THE APRIL 25, 2023 MEETING Live audio of the meeting will be streamed on the Harnett County Government’s YouTube Channel at https://www.youtube.com/channel/UCU7mTF6HTD65x_98EhAMeMg/featured. 042523 ws Pg. 1 Item 3042523 ws Pg. 2 042523 ws Pg. 3 042523 ws Pg. 4 Harnett County Members Served April 2023 Highest Serving Behavioral Health Providers Last Year Provider (297 providers serving local members) Members Served Daymark Recovery Services 816 Best Day Psychiatry and Counseling, PC 200 Harnett Health System, Inc.165 Morse Clinic of Dunn, PC 115 Coastal Carolina Neuropsychiatric Center 104 The Carolinas Emergency Group, LLC 100 Cumberland County Hospital System 96 Most Frequent Behavioral Health Services Received Last Year Service ($27,686,792 total) Amount Paid Innovations Services $6,337,423 Intermediate Care Facilities $6,104,492 Psychiatric Residential Treatment Facility $2,350,404 Inpatient Hospitalization $1,859,601 Outpatient Services $1,801,114 Behavioral Health Long Term Residential $1,779,832 Multi-Systemic Therapy $668,079 Assertive Community Treatment Team $501,758 042523 ws Pg. 5 HARNETT COUNTY 2022 – 2023 Crisis Intervention Team (CIT) Training – Harnett County • 40-hour class held June 13-17, 2022 • Host Officer: Lt. Scott Jefferies, Harnett County Sheriff’s Office • 17 officers graduated representing Harnett County Sherriff’s Office, Dunn Police Department, NC DPS- Probation Parole, and Harnett County EMS • Next class: June 19-23, 2023 Total Cumulative Classes = 6 in Harnett Total Cumulative Students = 108 in Harnett Community Involvement  Sandhills Center has representation on more than a dozen committees and collaborations in Harnett County, including: o Child Fatality Taskforce/Community Child Protection Team o Children’s Collaborative o Community Care of North Carolina Collaborative o Crisis Collaborative o DOJ/RDT Committee Meetings o Juvenile Crime Prevention Council o Local Interagency Coordinating Council (JCPC) o (Housing) Region 7 Continuum of Care o School Health Advisory Council o Crisis Solutions Committee, NAMI –Harnett, Lee & Cumberland o Harnett County Transportation Advisory Board (TAB) o Harnett Co Leadership Resilience Collaborative  Harnett-Lee Community Collaborative: The collaborative brings together community partners to discuss and address service delivery to develop a strong family, youth, and provider partnership. The Collaborative is facilitated by Sandhills Center Staff and meets monthly. Member representation: Area schools, DJJ, DSS, Providers, Faith Based, Non-Profits, Family Advocate, Guardian Ad Litem, Partnership for Children, State SOC (DHHS), CFAC, Hospital Social Worker.  NC MedAssist Pharmacy Give-Away Program Sandhills Center is part of the planning committee for an event on May 5, 2023. Trainings offered to Harnett County • Mental Health First Aid continues to be taught at Campbell University (most recently students enrolled in the pharmacy program) • Family partners provided training such as Parenting the Empathic Child 042523 ws Pg. 6 20222022 ANNUAL REPORT A publication for our community partners and stakeholders Serving Anson, Davidson, Guilford, Harnett, Hoke, Lee, Montgomery, Moore, Randolph, Richmond and Rockingham counties in central North Carolina 042523 ws Pg. 7 2 Sandhills Center manages mental health, substance use disorder and intellectual/developmental disabilities (I/DD) services in 11 central North Carolina counties. Our mission is to develop, manage and support quality services that meet the needs of our members and their families for the overall well-being of our communities. Sandhills Center is a Local Management Entity-Managed Care Organization (LME-MCO). As such, we operate as a publicly-funded agent of the North Carolina Department of Health and Human Services to oversee the administra- tion of services by a qualified network of providers. The successful administration of behavioral health services is made possible through a collaborative approach with individuals, families, local leaders, policy makers and other community stakeholders. CALL US FOR ASSISTANCE - Sandhills Center is available 24 hours a day, 7 days per week. Qualified professionals can answer questions and help set appointments: 1-800-256-2452 TTY: 1-866-518-6778 IN TIMES OF CRISIS - A toll-free Behavioral Health Crisis Line exists to help people during emergencies. Dedicated licensed clinicians are available to talk and connect individ- uals and families to assistance in their communities. Call any time of the day or night, including holidays: 1-833-600-2054 IF SOMEONE IS IN IMMEDIATE DANGER, DIAL 911 THE SANDHILLS CENTER SERVICE REGION ABOUTABOUT SANDHILLS CENTER 042523 ws Pg. 8 3 Sandhills Center’s Board of Directors represents each community within the 11-county region. The Board is made up of dedicated people who guide our mission, values and goals. The Board’s main focus is on improving care standards and services while offering oversight of programs. During monthly meetings, the Board accepts feedback from the public, individuals and families served, the Sandhills Center Consumer and Family Advisory Committee, various subcommittees, the provider network, and community partners. Meeting notices are published in the calendar section of the Sandhills Center website. SANDHILLS CENTER LEADERSHIPLEADERSHIP 2022 BOARD OF DIRECTORS - MEMBERS ANSON COUNTY • Commissioner Priscilla Little • Commissioner Robert Mims DAVIDSON COUNTY • Commissioner Karen Watford • Trish Baker • Billy Louya (continued on page 4) CHIEF EXECUTIVE OFFICER - Victoria Whitt 2022 BOARD OF DIRECTORS - OFFICERS CHAIR • Commissioner Harry Southerland (Hoke County) • Thad Ussery (Richmond County) - term ended 9/2022 VICE CHAIR • Commissioner Harry Southerland (Hoke County) - through 9/2022 SECRETARY • Commissioner Priscilla Little (Anson County) 042523 ws Pg. 9 4 RANDOLPH COUNTY y Commissioner David Allen y Mike Ayers y Ann Shaw RICHMOND COUNTY y Commissioner Rick Watkins - joined 10/2022 y Dr. Tommy Jarrell y Thad Ussery - term ended 9/2022 ROCKINGHAM COUNTY y Commissioner Mark Richardson y Keith Duncan PROVIDER REPRESENTATIVE y Jan Herring, RHA Health Services - joined 8/2022 y Jerry Earnhardt, Daymark Recovery Services - term ended 6/2022 HOSPITAL REPRESENTATIVE y Vacant LEADERSHIPLEADERSHIP (continued from page 3) GUILFORD COUNTY y Commissioner Alan Perdue y Dr. Alvin Keyes y Dr. Walter Salinger y Gart Evans - term ended 9/2022 HARNETT COUNTY y Commissioner Matt Nicol y Tonya Gray - service ended 9/2022 HOKE COUNTY y Commissioner Harry Southlerland y Jackie McLean LEE COUNTY y Commissioner Kirk Smith y Walter Ferguson MONTGOMERY COUNTY y Commissioner Mary Hassell y Carol Whitaker - term ended 9/2022 MOORE COUNTY y Commissioner Catherine Graham - service ended 11/2022 y Matthew Rothbeind 042523 ws Pg. 10 5 Victoria Whitt Chief Executive Officer Sandhills Center y Recognizing and celebrating Crisis Intervention Team training partners at the state and international levels. At the close of 2022, we completed our 10th year as a Local Management Entity-Managed Care Organization. We wish to express our sincerest gratitude to the counties we serve, and our members and families, for the enduring trust they continue to place in us. Sandhills Center appreciates the outstanding leadership from our Board of Directors and Consumer & Family Advisory Committee. We also extend many thanks to our staff and provider network for their unwavering commitment to our mission. Finally, we wish to thank the North Carolina General Assembly and Department of Health and Human Services (NCDHHS) for their steadfast responsiveness and guidance. Sandhills Center is excited to embark on 2023. Soon we will embrace our new role as an NC Medicaid Behavioral Health and Intellectual/Developmental Disabilities Tailored Plan, supporting integrated physical and behavioral health for members with complex needs. We appreciate your support now and in the future. Each year, Sandhills Center publishes an Annual Report to highlight the many ways in which we strive to improve the lives of people experiencing mental health challenges, substance use disorders and intellectual/ developmental disabilities. A predominant theme throughout 2022 focused on the partnerships Sandhills Center has forged with our provider network and other community stakeholders throughout the 11-county region. Our collaborative approach allows Sandhills Center to tap into a variety of outside resources to find creative strategies and solutions to meet the unique needs of each community. We understand that addressing behavioral health concerns is a team effort. Some of Sandhills Center’s highlights in 2022 included: y Extending and making permanent the enhanced reimbursement rates to providers that first started during the early days of the COVID-19 pandemic. y Earning high marks on the annual Provider Satis- faction Survey. y Launching a monthly Health Matters physical health- focused newsletter for providers. y Engaging the community and our stakeholders in a variety of activities intended to improve access and outcomes for the individuals we serve. MESSAGEMESSAGE FROM THE CEO 042523 ws Pg. 11 6 Innovations Residential Services (Residential Supports 1-4, Supported Living 1-3, and Supported Living Periodic); Assertive Community Treatment Team; Community Support Team; Psychosocial Rehabilitation Services; and Community-Based Intermediate Care Facilities. In addition, Sandhills Center announced a perma- nent continuation of the 5 percent rate increase for all other Medicaid services. Enhanced $50.02 per-person/per-day reimbursement rates to community-based Intermediate Care Facilities (ICFs) for individuals with intellectual/developmental disabilities were maintained utilizing funding initially directed by the North Carolina General Assembly. ICF services provided by state-operated facilities have an alternative reimbursement arrangement and were not subject to the permanent funding extension announced by Sandhills Center. Also in 2022, Sandhills Center increased rates by 10 percent to providers of services subject to Electronic Visit Verification (EVV) compliance. These included specific Innovations and 1915 (b)(3) Waiver services. The rate increases were applied to specific procedural codes for: Personal Care/Individual Support services; Innovations Community Living and Supports; In-Home Skill Building; and Innovations Supported Living Periodic services. (continued on page 7) Sandhills Center acknowledges that our provider network has faced many challenges during the last several years as a result of the global pandemic. In late 2022, Sandhills Center announced a permanent extension of the rate enhancements that have been in place since COVID-19 began to spread throughout our region. In April 2020, reimbursement rate increases to providers were extended on a quarterly basis. They were initially intended to be temporary. Our decision to make the rates permanent was made to strengthen the network in preparation for the Tailored Plan launch. In making the announcement, Sandhills Center also acknowledged the persistence of COVID-19 as another deciding factor to make the rates permanent. Providers are likely to continue facing staffing challenges and increased expenses. The additional revenue from making these rates permanent served to support our network’s efforts. The extension affects reimbursement rates for these services: Psychiatric and Residential Treatment Facilities; Behavioral Health Long-Term Residential; RATERATE INCREASESINCREASES TO CONTINUE PERMANENTLY 042523 ws Pg. 12 7 RATE INCREASESRATE INCREASES (continued from page 6) As part of the 21st Century Cures Act, the U.S. Centers for Medicare and Medicaid Services required that North Carolina start using an EVV system for a number of in-home personal care services within NC Innovations and Traumatic Brain Injury Waiver programs, and some B3 services. EVV is a method used to verify visit activity for services delivered as part of Home and Community-Based service programs. It offers accountability so that individuals authorized to receive services, in fact, get them in the approved location, on the correct dates, and for the full length of time allowed. PROVIDER PROVIDER SATISFACTIONSATISFACTION SURVEY RESULTS ANNOUNCED Sandhills Center was proud to announce the release of the annual Provider Satisfaction Survey, commis- sioned by the NCDHHS. Each year, the survey measures provider satisfaction among each of the state’s Local Management Entities-Managed Care Organizations (LME-MCOs). The survey results indicated that Sandhills Center maintained strong relationships with providers while successfully conducting oversight and management of mental health, substance use disorder and intellectual/ developmental disabilities services in our region. Some of the highlights of the survey results included: y Sandhills Center received the highest scores among the LME-MCOs on 9 of the 17 questions, the most of any of our peer organizations. Our score was 96.5 percent for the question that rates overall LME-MCO satisfaction. This was the highest score among our peers, and is a score statistically significantly higher than the overall average score for 2021. (continued on page 8) 042523 ws Pg. 13 HEALTHHEALTH MATTERSMATTERS PROVIDER NEWSLETTER LAUNCHED PROVIDER SATISFACTIONPROVIDER SATISFACTION (continued from page 7) y Sandhills Center also scored the highest in other areas, including: response time for provider needs; accurate and consistent information about claims; informative and helpful communication; knowledgeable provider network staff; informative training to meet providers’ needs; a useful website to assist providers with the tools and materials needed to offer services; and timely credentialing/ recredentialing by friendly and knowledgeable staff. y Sandhills Center had eight results that were statis- tically higher than the 2021 NC Overall result, which was significantly more than the two achieved by the next-highest scoring LME-MCOs. The feedback we receive from the annual Provider Satisfaction Survey helps Sandhills Center identify and prioritize opportunities for improvement. The information we glean also solidifies the aspects of our work that are positively identified. We believe the survey results reaffirm our commitment to helping give providers the resources, tools and support they need to offer quality, evidence-based and appropriate solutions for individuals and families within the communities we serve. 8 As Sandhills Center moves to an integrated approach to providing behavioral and physical health under the Tailored Plan, we recently developed and launched a monthly newsletter for our provider network that focuses on physical health and wellness topics. Health Matters offers evidence-based and practical information for the prevention and treatment of disease among our members. We understand that treating both the mental and physical health needs of children, adolescents and adults will improve patient outcomes and satisfaction. The November 2022 inaugural edition of Health Matters focused on the topic of diabetes in children and adolescents. In December, the newsletter covered the new U.S. Centers for Disease Control and Prevention guidance for opioid use and prescribing. In addition to a main monthly topic, Health Matters features health equity subject matter and links to resources for additional information, as well as health awareness month observances. (continued on page 9) 042523 ws Pg. 14 9 COMMUNITY AND STAKEHOLDER ENGAGEMENTENGAGEMENT HEALTH MATTERSHEALTH MATTERS (continued from page 8) In developing the newsletter, Sandhills Center assembled a team of communications, quality management, and physical health staff. The deputy chief medical officer authors each edition with content determined, in part, by analyses of population health data and other emerging factors. It is our hope that providers find the newsletter useful in improving and maintaining good health among our members. Health Matters is distributed to the provider network electronically. RIGHT: A SNAPSHOT OF THE COVER OF THE NOVEMBER 2022 EDITION OF HEALTH MATTERS, A NEWLETTER FOR PROVIDERS IN THE SANDHILLS CENTER NETWORK. Sandhills Center strives to engage stakeholders through meaningful educational activities, effective communication and other community relations efforts. Stakeholder engagement is an important step toward creating awareness and empathy to reduce stigma often associated with behavioral health. We want stakeholders and community part- ners to get timely information that is important to our members and each unique community. Through our efforts, Sandhills Center increasingly seeks ways to: y Expand opportunities to reach stakeholders to offer educational materials and other information about current services and the role Sandhills Center will play in the future as a Tailored Plan. y Build upon an already successful Crisis Interven- tion Team (CIT) training program for law enforcement and other first responders. CIT is a 40-hour training program that is held at least once a year in each county in the Sandhills Center region. CIT training gives first responders resources, educational tools and de-escalation skills to help them in behavioral health crisis situations. (continued on page 10) 042523 ws Pg. 15 10 Sandhills Center is proud of our involvement in the North Carolina School Mental Health Initiative (NC SMHI), a partnership of providers, educators, advocates, lawyers and parents who offer services, resources and support to students and their families. Sandhills Center became involved with the NC SMHI at its inception in 2015. The partnership takes pride in offering policy and legislative support to improve access and the coordination of mental health services. It also promotes physical health development, as well as healthy social, emotional and behavioral functions. It also works to prevent problems and respond to issues parents and students have. In addition, the NC SMHI focuses on equitable access to care, as well as treating substance use disorders. The NC SMHI meets regularly and has eight regional networks that align with the North Carolina Board of Education districts to support school mental health efforts at the local level. The regional approach guides implementation planning and practices, and addresses challenges or barriers to implementation. The partners share best practices, local capacity-building strategies and health literacy training for school personnel. Sandhills Center has taken the lead in coordinating the regional network for the Sandhills district for more than four years, making it the longest consistently- running network within the initiative. The Sandhills Regional Network was recognized in 2022 for its efforts to bring families and communities together to gain feedback for improvements to school mental health services and supports. ENGAGEMENTENGAGEMENT (continued from page 9) y Participate in community events, health fairs, exhibits and speaking engagements through which Sandhills Center can share behavioral health information and expertise with our stakeholders. For many years, Sandhills Center has hosted commu- nity breakfasts once a year in each of our counties. These gatherings are among the most visible ways in which Sandhills Center’s executive leadership team engages with community leaders such as members of the Boards of County Commissioners, state elected officials, county managers, city leaders, social services directors, public health officials, school superinten- dents, law enforcement leaders and local health systems representatives. During the gatherings, we offer programmatic updates and county-specific data about service utilization, community outreach and engagement efforts, and CIT training. Network crisis providers present local utilization data and trends. Also, there are opportunities to have discussions about strategies and solutions unique to each county. Sandhills Center recognizes the importance of engag- ing community partners and stakeholders. We know that they are critical ambassadors within each county to share our mission and availability of resources with constituents. 042523 ws Pg. 16 11 In addition, the SORC has: y Developed a network of Peer Support Specialists who share their lived experiences while working directly with partner organizations, agencies and clinics to link people to needed treatment and support. y Created internal referrals for an opioid use dis- order specialist to provide inpatient consultation for linkage to treatment, recovery and harm reduction resources. y Distributed harm reduction kits and naloxone to first responders. The kits contain information about the Peer Support program, the Good Sam- aritan law, how to recognize overdose signs and symptoms, and Rapid Response Team contact information. y Implemented successful media and social media campaigns to promote harm reduction strategies. y Hosted law enforcement training. y Coordinated community awareness activities. As a partner in the fight against the opioid use crisis, Sandhills Center contributes by helping to coordinate awareness events, providing Mental Health First Aid and other training to the Peer Support Specialists, and conducting data analysis and strategic planning. Participation in these initiatives is a high priority. Sandhills Center shares information across our county borders to leverage resources and connect our communities. We support each county to reach its goals while aligning with the objectives of the North Carolina Opioid and Substance Use Action Plan. Sandhills Center takes very seriously our role in reducing the opioid use crisis. We are committed to several partnerships that strive to make a positive impact, including: the Sandhills Opioid Response Consortium; Hope-N-Hoke Overdose Coalition, Drug- Free Moore County; Project Lazarus; the Randolph County Opioid Collaborative; the Randolph Community College Substance Abuse Symposium; and the Rockingham County Opioid Task Force. The Sandhills Opioid Response Consortium (SORC), for example, formed more than five years ago under the leadership of FirstHealth of the Carolinas. Its member- ship includes more than 75 partner organizations in Hoke, Lee, Montgomery, Moore and Richmond counties. The SORC has established a central website for regional information, stories of personal recovery success and a podcast. It can be found here: www.firsthealth.org/recoveryresources 042523 ws Pg. 17 12 their local CIT program. It also acknowledges the recipient’s advocacy of issues specific to behavioral health stigma reduction while promoting high-quality treatment and services for people living with mental illness. Reynolds became involved as a CIT partner early -- before the first CIT training class was ever held in the Sandhills Center region in 2008. He has been active in curriculum plan- ning and training logistics since then. As a NAMI- Moore County representative, he has coordinated with families to share the concerns and challenges they face while caring for loved ones who are exper- iencing mental illness. For many years, Reynolds has sought ways to expand behavioral health training to local schools using an instructional model similar to that of CIT. He helped develop a two-day mental health crisis prevention/intervention training pro- gram for school personnel that has expanded in recent years. He also has been a part of the develop- ment and delivery of CIT training in four counties outside of Moore, and has been an instrumental volunteer for the Sandhills Center/UNC System CIT training that began in 2021 to educate campus police officers from across the state. (continued on page 13) In 2022, thirteen 40-hour Crisis Intervention Team (CIT) training classes were held with 244 graduates representing all 11 counties within the Sandhills Center region. Each year, we are fortunate to partner with dozens of volunteers, advocates, providers, instructors, community colleges, law enforcement agencies and local organizations to conduct CIT training for first responders. Among them, three very deserving individuals were honored in 2022 at the state and international levels for their outstanding contributions. Sandhills Center is grateful to every- one who contributes to making CIT a success in our region. We especially wish to thank and congratulate these award honorees for their dedication: CIT International Advocate of the Year - George E. Reynolds Jr., NAMI-Moore County Reynolds was honored with this exceptional honor during the CIT International Conference, held in Pittsburgh, PA, in August 2022. He was nominated by Sandhills Center. The award is given to an individual who demonstrates exemplary active involvement in CIT PARTNERS CIT PARTNERS HONOREDHONORED AT STATE AND INTERNATIONAL LEVELS PICTURED: GEORGE E. REYNOLDS JR. 042523 ws Pg. 18 CIT PARTNERS HONOREDCIT PARTNERS HONORED (continued from page 12) “George’s commitment represents an extraordinary belief in the importance of crisis training for first responders,” said Victoria Whitt, CEO of Sandhills Center. “He makes great use of every opportunity to provide first responders with relevant, valuable insights about interactions with people experiencing mental illness. He desires for all first responders to be CIT trained. While he is truly concerned for the safety of people in crisis, he also is highly concerned about officer safety.” In February 2022, two Sandhills Center CIT partners were recognized with awards during the North Carolina CIT Conference. Recipients were selected by the NC CIT Committee, which consists of health care professionals, behavioral health agency represent- atives and law enforcement leaders from across the state. Both of the award recipients were proudly nominated by Sandhills Center. CIT Trainer of the Year — Jerry Earnhardt, MS, regional operations manager for Daymark Recovery Services: This award recognizes exemplary professionals and provider agencies that demonstrate leadership in advancing CIT in their communities. Earnhardt has served as a CIT instructor for more than 10 years, and has taught hundreds of participants. ABOVE: JERRY EARNHARDT (RIGHT) WITH GARRY CRITES, EXECUTIVE DIRECTOR OF NAMI-NORTH CAROLINA. He often enlists key Daymark staff to serve on plan- ning committees and as instructors on topics such as substance use, co-occurring disorders, post-traumatic stress disorder and child/adolescent issues. He and his staff also have taken active roles in scenario- based exercises and professional panels. Earnhardt is the lead instructor for QPR, a suicide prevention training in several counties. He also facilitates Behavioral Health System presentations, offering an overview of the region’s crisis centers. Sandhills Center is appreciative of Earnhardt’s know- ledge, engaging teaching style and established rapport with CIT participants. (continued on page 14) 13042523 ws Pg. 19 CIT PARTNERS HONOREDCIT PARTNERS HONORED (continued from page 12) CIT Champion of the Year — Capt. James Kerney, Montgomery County Sheriff’s Office* This award is the North Carolina CIT Committee’s highest honor. It is given to the person who has done the most in the state to improve the quality of life for people with mental illness through championing CIT with innovative approaches to decriminalizing mental illness. Sandhills Center proudly nominated Capt. Kerney for this recognition. Capt. Kerney completed CIT training in Montgomery County in 2019, and was named host officer soon after. He has regularly recruited first responders to attend CIT training. He insists that “CIT helps on calls, decreases physical restraints, and outcomes are much better.” Despite competing priorities that often come with having a high rank, Capt. Kerney remained active in CIT planning meetings, assisted with securing training locations and made connections with instructors and scenario-based training evaluators. He strongly believes that CIT trained officers have increased compassion for people in crisis, and a greater understanding that jail diversion is an important effort. Capt. Kerney credits his CIT training for his ability to avert four instances of attempted suicide. Sandhills Center is grateful for Capt. Kerney’s enthu- siasm for CIT and his ability to engage the community to gain support for this important educational effort. Sandhills Center appreciates NAMI-NC and the NC CIT Committee for recognizing Earnhardt and Kerney’s outstanding contributions to CIT training in our region. * When accepting the award, Capt. Kerney was employed by the Montgomery County Sheriff’s Office. He has since joined the Davidson County Sheriff’s Office. LEFT: CAPT. JAMES KERNEY EARNS THE STATE’S HIGHEST HONOR OF CIT CHAMPION OF THE YEAR IN 2022. CAPT. KERNEY SERVED AS HOST OFFICER FOR MONTGOMERY COUNTY CIT TRAINING. 14042523 ws Pg. 20 Administrative Offices: P.O. Box 9 West End, NC 27376 24/7/365 CALL CENTER — 1-800-256-2452 (TTY: 1-866-518-6778) BEHAVIORAL HEALTH CRISIS LINE —1-833-600-2054 Visit us online — SandhillsCenter.org For free and confidential, web-based behavioral health screenings, go to — SandhillsCenterAccess2Care.org This Annual Report to our Community Stakeholders is brought to you by: SANDHILLS CENTER IS NATIONALLY ACCREDITED 15042523 ws Pg. 21 QUARTERLY REPORT January 2023 Serving Anson, Davidson, Guilford, Harnett, Hoke, Lee, Montgomery, Moore Randolph, Richmond and Rockingham counties in central North Carolina TO OUR COMMUNITY PARTNERS AND STAKEHOLDERS 042523 ws Pg. 22 Montgomery County Commissioner Mary Hassell Vacant Moore County Matthew Rothbeind Vacant Randolph County Commissioner David Allen Mike Ayers Ann Shaw Richmond County Commissioner Rick Watkins Dr. Tommy Jarell Rockingham County Commissioner Mark Richardson Keith Duncan Provider Council Representative Jan Herring, RHA Health Services Hospital Representative Vacant LEADERSHIP Chief Executive Officer Victoria Whitt Board Chair Commissioner Harry Southerland, Hoke County Vice Chair Vacant Secretary Commissioner Priscilla Little, Anson County Anson County Commissioner Priscilla Little Commissioner Robert Mims Davidson County Commissioner Karen Watford Trish Baker Billy Louya Guilford County Commissioner Alan Perdue Dr. Alvin Keyes Dr. Walter Salinger Vacant Harnett County Commissioner Matt Nicol Vacant Hoke County Commissioner Harry Southerland Jackie McLean Lee County Commissioner Kirk Smith Walter Ferguson 2 * This membership roster is reflective of Board of Directors service during October, November and December 2022.042523 ws Pg. 23 A MESSAGE FROM THE CEO Victoria Whitt, Chief Executive Officer Sandhills Center 3 •Permanently extending reimbursement rate increases to providers to build strength in our network. As Sandhills Center enters a new year and approaches a new era of Medicaid Managed Care service delivery, rest assured that we vow to never lose sight of what is most important -- producing better outcomes for individuals and families who need our care. We appreciate your continued partnership and support. As Sandhills Center prepares to become an NC Medicaid Behavioral Health and Intellectual/Developmental Disabilities Tailored Plan, we want to impress on our community stakeholders that we will continue to remain steadfast in our mission. In times of change, we will always maintain our efforts to reach our established goals. Sandhills Center’s ultimate objective is to improve the quality of life for individuals and families who need our assistance in Anson, Davidson, Guilford, Harnett, Hoke, Lee, Montgomery, Moore, Randolph, Richmond and Rockingham counties. In this Quarterly Report to our community stakeholders, we reflect on some of the ways in which we demonstrate our commitment to our objectives, including: •Offering stakeholder engagement opportunities throughout the region. •Creating educational and informational support to our provider network through the Health Matters newsletter that focuses on physical health and health equity. 042523 ws Pg. 24 COMMUNITY SANDHILLS CENTER FOCUSES ON STAKEHOLDER ENGAGEMENT 4 Sandhills Center strives to engage stake- holders in our region through meaningful educational initiatives, effective communi- cation and other community relations efforts. We believe that stakeholder engagement is an important step toward creating awareness and empathy to reduce stigma often associated with mental illness, substance use disorder and intellectual/ developmental disabilities. Sandhills Center assures that stakeholders and community partners receive current and timely information that is important to our members and each unique community. Through our stakeholder engagement efforts, Sandhills Center increasingly seeks ways to: • Expand opportunities to reach stakeholders to offer educational materials and other information about current Sandhills Center services and the role Sandhills Center will play in the future as an an NC Medicaid Behavioral Health and Intellectual/Developmental Disabilities Tailored Plan. (continued on page 5) 042523 ws Pg. 25 5 (continued from page 4) • Build upon an already successful Crisis Intervention Team (CIT) training program for law enforce- ment and other first responders. CIT is a 40-hour training program that is held at least once a year in each of the counties within the the Sandhills Center region. CIT training gives first responders resources, educational tools and de-escalation skills to help them in behavioral health crisis situations. • Participate in community events, health fairs, exhibits and speaking engagements through which Sandhills Center can share behav- ioral health information and expertise with our stakeholders. For many years, Sandhills Center has hosted community breakfasts once a year in each of our counties. These events are among the most visible ways in which we engage community leaders. The community breakfasts give Sandhills Center’s executive leadership team an opportunity to meet directly with members of the Boards of County Commissioners, state elected officials, county managers, city leaders, social services directors, public health officials, school superintendents, law enforce- ment leaders, and local health systems representatives. During these meetings, Sandhills Center provides programmatic updates and county-specific data about service utilization, community outreach and engagement efforts, and CIT training. Network crisis providers present local utilization data and trends. Also, there are opportunities to have discussions about strategies and solutions unique to each county. Sandhills Center is proud of our commun- ity engagement approach. We recognize that our community partners and stake- holders are critical ambassadors within each county to share information about our mission and availability of resources with their constituents. 5 042523 ws Pg. 26 SANDHILLS CENTER LAUNCHES PHYSICAL HEALTH NEWSLETTER Sandhills Center recognizes that treating both the mental health and physical needs of children, adolescents, and adults will improve patient outcomes and satisfaction. As we move to an integrated approach of providing behavioral and physical health care, Sandhills Center has developed a monthly newsletter for our network of providers that focuses on topics related to physical health and wellness. Health Matters was launched on Nov. 1, 2022, as an effort to offer practical health information for the prevention and treat- ment of disease among our members. It is distributed by email through the provider network listserv. A team of Sandhills Center communica- tions, quality management and population health staff developed the concept for Health Matters. Our Deputy Chief Medical Officer authors the main content in each edition. The diabetes information in November was summarized from the clinical practice recommendations of the American Diabetes Association. In December 2022, Health Matters featured the new U.S. Centers for Disease Control and Prevention guidelines for opioid misuse and prescribing. Future topics will be chosen, in part, by analyses of population health data and other emerging factors. Health Matters serves as a great oppor- tunity for Sandhills Center to connect further with our providers, offering additional support and resources they need, and thereby strengthening our relationship. It is our hope that our network will find Health Matters helpful in their work to improve and maintain good health within our communities. NETWORK 6 Right: A snapshot of the new provider newsletter Health Matters 042523 ws Pg. 27 7 SERVICES SANDHILLS CENTER PERMANENTLY EXTENDS COVID-19 RATE ENHANCEMENTS Sandhills Center has permanently extended the rate enhancements that have been in place since the COVID-19 pandemic began to spread throughout the region. Previously, rate increases for specific services were determined on a quarterly basis and were intended to be temporary. Because they have been available since April 2020, Sandhills Center believes that removing or decreasing the rate enhancements would lead to provider instability at a time when we are working to expand and strengthen the network in preparation for the Tailored Plan launch. Additionally, the virus has persistently produced variants that show no signs of ending soon. Providers likely will continue to have increased expenses and challenges with maintaining staffing levels. Therefore, it is expected that they will need the additional revenue from those enhanced rates. As a reminder, these residential and other service offerings will maintain 15 percent rate increases: Psychiatric Residential Treatment Facilities; Behavioral Health Long-Term Residential; Innovations Residential Services (Residential Supports 1-4, Supported Living 1-3 and Supported Living Periodic); Assertive Community Treatment Team; Community Support Team; Psychosocial Rehabilitation Services; and Community-Based Inter- mediate Care Facilities. Sandhills Center also has continued the 5 percent rate increases for all other Medicaid services. Enhanced $50.02 per-person/per-day reimbursement rates to community-based Intermediate Care Facilities (ICFs) for individuals with intellectual/developmental disabilities also were maintained utilizing funding initially directed by the North Carolina General Assembly. ICF services provided through state-operated facilities have an alternative reimbursement arrangement and are not subject to the funding extension announced by Sandhills Center. “We appreciate the support to our members that the provider network has demonstrated both before and during the pandemic,” said Sandhills Center CEO Victoria Whitt. “A continued focus on meeting the needs of those served is a key element as we collectively make the transition to the Tailored Plan environment.”7 042523 ws Pg. 28 OPERATING BUDGET FY 2022-2023 FINANCIALS 10 REVENUES Medicaid Service Contracts 449,143,139 75.4% State, Federal Service Funds and Medicaid Flow 58,917,345 9.9% County General and Other Local 13,263,679 2.2% I/DD Treatment Planning Administration and MH/SA Treatment Planning 16,448,272 2.7% Medicaid Administration General and LME Administration 35,525,733 6.0% Medicaid Reserve Funds 6,414,454 1.1% Fund Balance 15,934,883 2.7% TOTAL 595,647,505 100% 75.4 9.9 6.02.7 1.1 2.2 2.7 EXPENSES Contracts 533,297,648 89.5% Personnel 52,572,405 8.8% Materials and Supplies 436,787 0.1% Current Obligations/Services 7,050,495 1.2% Fixed Charges and Capital 2,290,170 0.4% TOTAL 595,647,505 100%89.5 8.8 0.1 1.2 0.4 042523 ws Pg. 29 Administrative Office: P.O. Box 9 West End, NC 27376 For free, confidential and anonymous behavioral health screenings, visit: SandhillsCenterAccess2Care.org 24/7 CALL CENTER 1-800-256-2452 (TTY - 1-866-518-6778) 24/7 BEHAVIORAL HEALTH CRISIS LINE 1-833-600-2054 Sandhills Center is nationally accredited. SandhillsCenter.org 042523 ws Pg. 30 PROCLAMATION RECOGNIZING MENTAL HEALTH AWARENESS MONTH 2023 WHEREAS, since 1949, May has been observed as Mental Health Awareness Month to increase awareness of the importance of mental health and its impact on physical, emotional, and mental well-being of children, adults, families, and communities; and WHEREAS, nearly one in five adults in North Carolina live with a mental health condition; and WHEREAS, suicide is the second leading cause of death for youth in North Carolina ages 10-18 and the third leading cause of death for those ages 19-34; and WHEREAS, stigma and the resulting discrimination is a primary obstacle to early identification and effective treatment of individuals with mental illness and their ability to recover to lead full, productive lives; and WHEREAS, less than half of adults in North Carolina struggling with mental illness receive needed and necessary treatment; and WHEREAS, with early and effective interventions, those individuals with mental health conditions can recover and lead full, productive lives; and WHEREAS, promoting mental health and wellness leads to higher overall productivity, better educational outcomes, lower crime rates, stronger economies, and improved quality of life; and WHEREAS, through public education, working together to raise awareness, and promoting support prevention efforts, everyone can reduce the stigma and assist in the improvement of the lives of individuals and families affected by mental illness. NOW THEREFORE, the Harnett County Board of Commissioners does hereby proclaim the month of May 2023 as “MENTAL HEALTH AWARENESS MONTH” in Harnett County. The Board of Commissioners calls upon all citizens, government agencies, public and private institutions, businesses, and schools to recommit the community to increasing awareness and understanding of mental illness, reducing stigma and discrimination, and promoting appropriate and accessible services for all people with mental illnesses. DECLARED This the 25th day of April, 2023. HARNETT COUNTY BOARD OF COMMISSIONERS ___________________________________ Matthew Nicol, Chairman ________________________________ ________________________________ William Morris, Vice-Chairman Barbara McKoy ________________________________ ________________________________ W. Brooks Matthews Lewis W. Weatherspoon Item 5 042523 ws Pg. 31 S:\Clerk to the Board docs\AGENDAS\2023\042523 ws\9 Monore Lane revocation agenda memo 4.11.23.docx Page 1 of 1 Board Meeting Agenda Item MEETING DATE: May 1, 2023 TO: HARNETT COUNTY BOARD OF COMMISSIONERS SUBJECT: Revocation of Offer to Sell Property REQUESTED BY: Christopher Appel - Legal Department REQUEST: Legal Department requests the revocation of the Offer to Convey Certain Real Property located on Monroe Lane. A Resolution was adopted on September 6, 2022 to sell the real property located on Monroe Lane for $14,520.00. On October 5, 2022, Ms. White made a deposit in the amount of $726.00 in compliance with the upset bid process. No upset bids were recevied by the October 24, 2022 deadline and Ms. White's offer was accepted. Ms. White was given a deadline to receive the final amount due by March 15, 2023. She was also made aware that she would forfeit her deposit if she did not pay the final amount due. To this date, Ms. White has not paid the remaining balance. FINANCE OFFICER’S RECOMMENDATION: COUNTY MANAGER’S RECOMMENDATION: Item 9 042523 ws Pg. 32 S:\Clerk to the Board docs\AGENDAS\2023\042523 ws\11.1 agendaform2023 - Updated Pay Plan.docx Page 1 of 2 Board Meeting Agenda Item MEETING DATE: May 1, 2023 TO: HARNETT COUNTY BOARD OF COMMISSIONERS SUBJECT: Proposed Changes to Article III - The Pay Plan Section 8 REQUESTED BY: Janice Lane, Human Resources Director REQUEST: The HR Department was asked to review this section of the Personnel Ordinance to update the section regarding promotions and to consider adding a policy for retention purposes. The current promotion policy is set for a salary increase of 5% of the employee's current salary or the minimum of the new pay grade (whichever is greater). In addition, a Department Head can make a request of a 6% - 10% increase with written justification to the County Manager for approval. The current policy puts constraints on the amounts of increases the County is able to provide an existing employee, putting the current maximum increase at 10%. Recently, the County has been made aware that due to the current labor market and local competitive salaries and has been faced with the need to offer a starting salary amount somewhere between the minimum rate and job rate; sometimes even midpoint, to attract and secure external candidates. Unfortunately, this amount is more than the 10% the County is able to offer qualified internal County employees. Human Resources is proposing to make an addition to this section to allow the County Manager to have the authority to approve a salary increase of up to 20% in special instances where the current employee's professional experience, training, certifications, complexity of the job duties, tenure and competitive job market supports a higher salary increase. The HR Department also recommends adding a Retention Policy to the Personnel Ordinance. Recently, some of our Departments such as HRW and Development Services lost talented employees who decided to leave the County to take a position at neighboring municipalities for a considerable increase in salary. The Retention Policy will allow the County Manager to have the authority to approve an increase up to 15% for non-probationary period employees for retention purposes for key positions (definition added to Personnel Ordinance) when the County is in danger of losing talented staff members. Per the County's adopted Strategic Plan, one of the Goal Objective (2.1) within Organizational Excellence identified by the Board is to attract, retain and grow high performing employees. HR believes the above proposed changes will assist in retention Item 11 042523 ws Pg. 33 S:\Clerk to the Board docs\AGENDAS\2023\042523 ws\11.1 agendaform2023 - Updated Pay Plan.docx Page 2 of 2 of County employees who are willing to take on the added responsibilities and job duties to work towards a promotion as well as in situations of the County potentially being in danger of losing talented employees. FINANCE OFFICER’S RECOMMENDATION: COUNTY MANAGER’S RECOMMENDATION: The County Manager recommends approval of these changes to the Personnel Ordinance to assist in providing appropriate pay for promotions and to retain talented staff members with the County. 042523 ws Pg. 34 Section 3. Definitions (Listed Alphabetically) Key Position: A position whose decision-making authority and related responsibilities significantly influence organizational policies, strategic goals, business operations, or mission-critical projects. A key position can be a department head or a supervisor or a position that requires specialized knowledge, expertise, or skills. Section 8. Promotions, Demotions, Transfers, Reclassifications, & Revisions At the beginning of the fiscal year, any promotions, salary adjustments, reclassifications, or revisions will be applied before any cost of living adjustments. When an employee is promoted, demoted, transferred, or reclassified, the rate of pay for the new position shall be established in accordance with the following rules: Promotion: Any employee who receives a promotion will receive a minimum of a five percent (5%) increase but not to exceed ten percent (10%). For any increase between six percent (6%) and ten percent (10%), the Department Head must provide written justification unless that percentage is the beginning of the new grade. In some special instances such as the employee’s professional experience, training, certifications, complexity of the job duties of the new position, tenure, and other job-related factors and/or to ensure the salary is competitive in comparable job markets, the County Manager has authority to approve a salary increase of up to twenty percent (20%) with written justification from the Department Head. Movement within the same salary grade is considered lateral and there will not be a salary change. Interim Promotion: Any employee who is promoted to an interim position in a higher pay grade will receive a pay increase of five percent (5%) or the beginning of the interim position pay grade, whichever is greater while performing the interim duties; however, if the position is a Department Head position or higher, he or she shall receive a ten percent (10%) pay increase while performing the interim duties or the beginning position grade whichever is higher. An interim assignment shall not exceed six months. At the conclusion, if the employee returns to his or her former position they will return to his or her former salary before the interim assignment. Demotion: An employee who is voluntarily or involuntarily demoted shall have his or her salary or hourly wage left the same, reduced five percent (5%) or reduced to anywhere in the lower grade pay range, depending on the circumstances of the demotion and Department Head recommendation. Transfers: An employee who transfers from a position in one grade to a position in another grade assigned to the same pay range shall continue to receive the same salary or hourly wage. Reclassifications/Revisions: A. Any employee who is currently at the minimum pay rate of their current position and the position is then reclassified to a grade having a higher salary or hourly pay range, that employee shall receive a five percent (5%) pay increase or an increase to the minimum pay rate of the new pay range, whichever is higher. B. Any employee who is currently above the minimum pay rate of their current position and the position is then reclassified to a grade having a higher salary or hourly pay range, that employee’s salary or hourly wage shall be appropriately adjusted to the same percentage above the minimum pay rate in the new pay range. C. If a position is reclassified to a grade having a lower salary or hourly pay range than that positions current grade, any employee’s salary or hourly wage that is above the maximum rate of the newly established pay range shall remain the same. 042523 ws Pg. 35 Retention: The County Manager has authority to approve a salary increase of up to fifteen percent (15%) for non- probationary employees for retention purposes for key positions when the County may be in danger of losing talented staff members. However, an employee’s salary shall not exceed the maximum rate for that pay grade and an employee shall not receive more than a fifteen percent (15%) retention salary increase every two years. When determining appropriate salary adjustments, the County Manager shall take into consideration relevant factors including salaries paid in comparable and competitive job market and the impact of losing the employee on the organization. 042523 ws Pg. 36 Quarterly Financial Reports As of March 31, 2023 Item 12 042523 ws Pg. 37 Table of Contents General Fund ................................................................................................ 1 Harnett Regional Jetport Fund ..................................................................... 6 American Rescue Plan Act Fund ................................................................. 10 Harnett Regional Water Fund .................................................................... 11 Solid Waste Fund ....................................................................................... 13 Worker’s Compensation Fund .................................................................... 15 Unemployment Insurance Fund ................................................................. 17 Employee Clinic Fund ................................................................................. 19 Medical Self Insurance Fund ...................................................................... 21 Dental Self Insurance Fund ........................................................................ 23 Retiree Self Insurance Fund ....................................................................... 25 Fleet Services Fund ..................................................................................... 27 Information Technology Fund .................................................................... 29 Veteran’s Treatment Court Fund ............................................................... 31 Monthly Sales Tax Analysis by Article ........................................................ 33 042523 ws Pg. 38 Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 66,850,000 70,991,210.26 72,701,330 73,709,701.88 77,645,000 75,772,000.73 69,138,593.70 31 - TAXES - SALES 18,400,000 23,875,039.72 22,300,000 26,539,012.42 21,416,000 14,452,163.98 12,674,117.66 32 - TAXES - OTHER 530,000 1,012,526.63 730,000 1,565,634.08 1,164,000 1,087,223.95 1,120,550.58 33 - RESTRICTED REVENUE 21,619,089 19,260,581.08 21,618,923 19,448,221.74 22,529,102 15,393,236.82 11,619,728.32 34 - RESTRICTED REVENUE 2,220,000 4,843,663.02 3,700,000 5,550,492.66 3,110,000 6,367,851.94 5,225,953.18 35 - SERVICE CHARGES 15,319,535 13,778,720.42 13,334,288 15,145,099.60 14,230,204 13,181,521.79 9,510,952.90 36 - ENTERPRISE CHARGES 3,000 1,672.35 1,600 2,927.17 0 4,014.22 2,197.29 38 - MISCELLANEOUS INCOME 1,551,807 1,803,513.67 1,737,467 1,704,613.93 1,861,459 1,117,733.53 1,440,862.60 39 - NON-REVENUE RECEIPTS 11,942,137 2,185,791.26 9,131,314 781,184.62 17,078,285 1,123,259.00 59,932.00 110 - GENERAL FUND REVENUE $138,435,568 $137,752,718.41 $145,254,922 $144,446,888.10 $159,034,050 $128,499,005.96 $110,792,888.23 Expense Function Department Budget Actual Budget Actual Budget Actual 110 - GENERAL 00 - GENERAL GOVERNMENT 4110 - GOVERNING BODY 788,447 777,246.30 1,097,890 700,681.26 898,315 585,911.90 358,280.12 4120 - COUNTY ADMINISTRATION 1,036,614 967,139.30 1,168,511 1,084,649.28 1,159,110 730,557.53 774,551.00 4130 - FINANCE 1,306,824 1,302,523.38 1,575,325 1,446,970.66 1,619,115 1,036,458.50 1,026,240.16 4131 - RETIREE INSURANCE 882,000 836,451.90 882,000 881,998.48 944,351 574,502.33 597,921.56 4140 - TAX 1,551,703 1,375,145.61 1,858,149 1,638,278.00 1,999,758 1,233,495.54 1,097,176.81 4150 - LEGAL SERVICES 363,565 317,124.91 348,564 335,989.02 387,682 259,532.14 229,945.92 4160 - HUMAN RESOURCES 505,151 485,996.12 812,570 765,241.54 954,498 683,175.27 573,375.69 4170 - BOARD OF ELECTIONS 597,465 524,487.82 611,967 486,986.66 557,932 465,539.07 231,152.74 4180 - CLERK OF COURT 26,083 13,338.15 22,283 15,003.96 28,233 13,119.78 12,659.64 4190 - REGISTER OF DEEDS 889,071 731,345.62 764,991 733,004.63 810,075 560,020.92 458,190.75 4210 - GENERAL SERVICES 227,775 226,379.33 243,609 238,037.30 254,727 180,982.85 169,848.73 4230 - FACILITIES MAINTENANCE 3,610,387 3,370,988.28 3,218,002 3,169,355.98 3,595,150 2,189,176.14 1,974,570.18 4250 - FLEET MAINTENANCE 629,738 605,175.27 780,677 777,916.82 871,274 589,773.85 537,114.72 4270 - INFORMATION TECHNOLOGY 2,554,198 2,498,933.29 2,545,738 2,522,795.76 2,735,530 1,944,282.52 1,690,642.32 4290 - GIS 700,709 667,520.21 793,447 725,435.75 845,487 585,757.16 485,168.98 9800 - INTERFUND TRANSFERS 21,454,238 21,454,238.00 18,418,352 18,418,352.00 23,543,813 17,046,294.00 14,374,297.00 9910 - CONTINGENCY 454,020 0.00 126,644 0.00 635,387 0.00 0.00 00 - GENERAL GOVERNMENT Total $37,577,988 $36,154,033.49 $35,268,719 $33,940,697.10 $41,840,437 $28,678,579.50 $24,591,136.32 FY 2023 FY 2023FY 2021 FY 2021 Same Period Last Year Same Period Last Year FY 2022 FY 2022 General Fund as of March 31, 2023 General Fund 110 1 of 33 03.2023 Monthly Master042523 ws Pg. 39 Expense Function Department Budget Actual Budget Actual Budget Actual FY 2023FY 2021 Same Period Last Year FY 2022 10 - PUBLIC SAFETY 4300 - PUBLIC SAFETY 0 0.00 0 0.00 0 0.00 0.00 4310 - SHERIFF 12,192,507 11,767,113.14 13,182,650 12,698,552.66 13,793,740 9,335,085.99 8,685,305.58 4330 - CAMPBELL DEPUTIES 477,204 462,180.48 540,424 505,786.76 550,430 414,799.32 372,234.08 4350 - SCHOOL RESOURCE OFFICER 2,254,482 1,636,706.45 2,104,893 1,780,756.12 2,105,533 1,082,655.67 1,277,825.31 4370 - CHILD SUPPORT ENFORCEMENT 71,676 69,418.10 92,371 85,148.89 85,907 60,814.79 57,103.76 4390 - JAIL 5,836,177 5,714,088.79 6,871,307 6,274,841.72 7,272,542 4,600,746.69 3,621,141.51 4410 - EMERGENCY MANAGEMENT 1,004,854 917,365.40 1,072,232 1,024,568.72 1,178,382 815,008.85 704,734.14 4411 - EMERGENCY SERVICES GRANTS 208,975 206,851.32 109,718 81,595.82 442,695 246,514.47 20,333.27 4450 - EMERGENCY MEDICAL SERVICE 9,162,453 8,307,576.45 9,424,313 8,874,222.88 10,491,853 6,801,855.67 6,117,818.34 4451 - EMS TRANSPORTS 0 0.00 0 0.00 0 0.00 0.00 4470 - RESCUE DISTRICTS 3,673,427 3,673,427.00 3,783,630 3,749,400.37 5,403,151 4,359,476.04 2,837,722.68 4510 - FIELD SERVICES 321,672 304,222.75 370,958 320,814.44 423,264 263,577.84 215,963.37 4512 - ANIMAL SHELTER 359,570 253,890.05 357,920 238,345.89 436,416 230,527.19 145,039.92 4530 - MEDICAL EXAMINER 95,000 87,000.00 488,580 99,550.00 100,000 57,750.00 75,650.00 4570 - COMMUNICATIONS 1,762,248 1,678,534.79 2,038,639 1,754,234.23 2,118,351 1,273,638.92 1,130,619.31 4590 - EMERG TELEPHONE SYSTEM 0 0.00 0 0.00 0 0.00 0.00 4591 - RADIO SYSTEM 0 0.00 0 0.00 0 0.00 0.00 4915 - INSPECTIONS 0 0.00 1,061,034 894,169.11 1,152,661 732,261.89 586,013.88 10 - PUBLIC SAFETY Total $37,420,245 $35,078,374.72 $41,498,669 $38,381,987.61 $45,554,925 $30,274,713.33 $25,847,505.15 20 - TRANSPORTATION 4610 - TRANSPORTATION 1,513,691 1,029,779.25 1,733,673 1,012,934.33 1,493,881 700,977.14 713,177.09 4630 - TRANSPORTATION - ADMIN 739,696 706,044.94 606,006 261,355.74 963,989 323,853.15 189,864.48 4650 - HARNETT REGIONAL JETPORT 509,520 417,451.00 0 0.00 0 0.00 0.00 20 - TRANSPORTATION Total $2,762,907 $2,153,275.19 $2,339,679 $1,274,290.07 $2,457,870 $1,024,830.29 $903,041.57 30 - ENVIRONMENTAL PROTECTION 4710 - SOIL & WATER 237,233 218,946.11 261,378 254,800.08 309,461 209,177.42 174,593.49 4730 - FORESTRY PROGRAM 138,026 135,320.77 130,722 126,844.67 152,709 86,537.55 82,691.66 4750 - ENVIROMENTAL PROT ALLOC 6,000 6,000.00 12,000 11,000.00 12,000 11,900.00 11,000.00 30 - ENVIRONMENTAL PROTECTION Total $381,259 $360,266.88 $404,100 392,644.75 $474,170 $307,614.97 $268,285.15 40 - ECONOMIC & PHYSICAL DEVELOPMNT 4910 - DEVELOPMENT SERVICES 1,665,394 1,644,998.81 995,192 983,246.49 1,119,722 736,214.06 705,502.94 4930 - ECONOMIC DEVELOPMENT 777,877 675,911.43 1,046,120 860,876.07 1,111,354 736,984.73 714,862.12 4950 - COMMUNITY DEVELOPMENT 925 554.81 455 82.59 457 74.61 24.79 4951 - ABANDONED MFG HOME 0 0.00 0 0.00 0 0.00 0.00 4990 - COOPERATIVE EXTENSION 405,145 334,915.00 426,907 418,943.43 427,722 252,851.95 275,488.79 4995 - COOPERATIVE EXT SPECIAL PROG 170,152 80,618.74 135,332 105,558.83 147,729 82,463.59 77,750.09 40 - ECONOMIC & PHYSICAL DEVELOPMNT Total $3,019,493 $2,736,998.79 $2,604,006 $2,368,707.41 $2,806,984 $1,808,588.94 $1,773,628.73 General Fund 110 2 of 33 03.2023 Monthly Master042523 ws Pg. 40 Expense Function Department Budget Actual Budget Actual Budget Actual FY 2023FY 2021 Same Period Last Year FY 2022 50 - HUMAN SERVICES 5110 - GENERAL ADMINISTRATION 7,370,852 5,797,516.31 9,432,669 6,312,375.88 9,637,063 5,156,477.00 4,416,594.51 5120 - CHILD HEALTH 0 0.00 0 0.00 0 0.00 0.00 5130 - ADULT HEALTH 0 0.00 0 0.00 0 0.00 0.00 5140 - HEALTH EDUCATION 0 0.00 0 0.00 0 0.00 0.00 5150 - WIC - ADMINISTRATION 0 0.00 0 0.00 0 0.00 0.00 5170 - BIOTERRORISM 0 0.00 0 0.00 0 0.00 0.00 5180 - ENVIRONMENTAL SERVICES 0 0.00 0 0.00 0 0.00 0.00 5210 - MENTAL HEALTH 605,679 605,679.00 605,679 605,679.00 605,679 454,259.25 605,679.00 5260 - HEALTH - SENIOR SERVICES 1,679,594 1,460,031.51 1,724,938 $1,432,025.35 1,725,503 1,002,988.42 1,034,362.38 5310 - DSS - ADMINISTRATION 2,436,585 2,255,368.91 2,177,621 2,068,015.24 2,394,520 1,670,333.20 1,510,552.11 5311 - DSS - FRAUD PREVENTION 297,397 293,135.82 359,970 355,120.19 386,272 268,675.09 246,886.27 5320 - DSS - ADULT SERVICES 888,982 851,855.81 1,079,763 933,879.69 1,156,856 779,893.02 632,968.89 5321 - DSS - WORKFIRST 303,231 281,561.51 370,509 300,623.74 378,470 222,094.97 217,670.67 5322 - DSS - ENERGY PROGRAMS 1,374,286 1,220,383.03 2,472,707 2,054,900.57 1,567,034 752,064.55 1,209,028.93 5330 - DSS - CHILD CARE SUBSIDY 376,627 366,092.70 439,779 422,234.66 448,367 322,375.23 297,068.58 5331 - DSS - CHILD PROTECTIVE SRVCS 2,127,436 2,016,036.47 2,231,213 2,128,536.64 2,330,626 1,448,997.72 1,494,851.04 5332 - DSS - FOSTER CARE 2,711,023 2,504,118.07 3,053,187 2,898,902.18 3,405,459 2,501,901.86 1,940,838.36 5333 - DSS - ADOPTION 397,847 290,006.27 395,295 321,147.43 562,400 246,260.40 219,696.12 5334 - DSS - DAY CARE 22,315 10,488.00 0 0.00 0 0.00 0.00 5340 - DSS - CHILD SUPPORT 1,331,417 1,229,087.03 1,559,968 1,427,942.69 1,598,976 994,070.91 975,995.92 5350 - DSS - MEDICAID 0 0.00 0 0.00 0 0.00 0.00 5351 - DSS - ADULT MEDICAID 2,215,437 2,065,004.64 2,349,386 1,941,026.61 2,462,325 1,486,295.59 1,367,671.61 5352 - DSS - FAMILY & CHLDRN MEDICAID 1,541,975 1,503,778.69 1,754,283 1,557,853.10 1,790,273 1,189,279.06 1,122,963.66 5353 - DSS - MEDICAID TRANSPORTATION 211,078 190,776.42 224,629 204,783.19 258,052 157,530.38 136,872.29 5360 - DSS - TEMPORARY RESOURCES 124 0.00 0 0.00 0 0.00 0.00 5370 - DSS - FOOD STAMPS 1,498,504 1,473,856.97 1,702,309 1,614,919.33 1,973,883 1,294,733.49 1,132,533.38 5390 - DSS - TRUST ACCOUNTS 0 0.00 0 0.00 0 0.00 0.00 5810 - VETERANS SERVICES 304,997 273,925.29 331,193 307,382.90 355,753 233,839.93 199,322.81 5870 - RESTITUTION 82,712 79,168.66 88,706 85,044.76 107,250 66,515.39 59,740.46 5895 - HUMAN SERVICES APPROPRIATIONS 32,000 0.00 0 0.00 0 0.00 0.00 50 - HUMAN SERVICES Total $27,810,098 $24,767,871.11 $32,353,804 $26,972,393.15 $33,144,761 $20,248,585.46 $18,821,296.99 70 - EDUCATION 5910 - BOARD OF EDUCATION 24,680,603 24,680,603.00 25,532,777 25,532,776.55 26,121,589 19,766,191.75 21,419,341.73 5920 - CCCC 1,621,978 1,359,842.33 1,835,077 1,502,947.48 1,752,605 1,139,818.74 1,056,767.73 70 - EDUCATION Total $26,302,581 $26,040,445.33 $27,367,854 $27,035,724.03 $27,874,194 $20,906,010.49 $22,476,109.46 80 - CULTURAL & RECREATION 6110 - PARKS & RECREATION 1,399,432 1,255,861.31 1,530,087 1,402,144.12 1,739,937 1,063,930.07 1,011,363.54 6170 - MAIN LIBRARY 1,542,378 1,325,297.41 1,703,348 1,530,381.73 2,040,861 1,224,145.37 983,846.65 6172 - ANGIER BRANCH LIBRARY 0 0.00 0 0.00 252,777 137,666.73 0.00 General Fund 110 3 of 33 03.2023 Monthly Master042523 ws Pg. 41 Expense Function Department Budget Actual Budget Actual Budget Actual FY 2023FY 2021 Same Period Last Year FY 2022 6175 - COATS BRANCH LIBRARY 0 0.00 0 0.00 151,658 66,030.83 0.00 6176 - DUNN BRANCH LIBRARY 0 0.00 0 0.00 278,839 152,050.04 0.00 6177 - ERWIN BRANCH LIBRARY 0 0.00 0 0.00 156,084 83,828.06 0.00 6199 - CULTURAL & REC APPROP 219,187 184,589.00 184,656 184,656.00 260,553 213,331.00 170,656.00 80 - CULTURAL & RECREATION Total $3,160,997 $2,765,747.72 $3,418,091 $3,117,181.85 $4,880,709 $2,940,982.10 $2,165,866.19 110 - GENERAL FUND EXPENSE $138,435,568 $130,057,013.23 $145,254,922 $133,483,625.97 $159,034,050 $106,189,905.08 $96,846,869.56 110 - GENERAL FUND REVENUE (OVER) / UNDER EXPENSES $0 $7,695,705.18 $0 $10,963,262.13 $0 $22,309,100.88 $13,946,018.67 General Fund 110 4 of 33 03.2023 Monthly Master042523 ws Pg. 42 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $33,238,397.31 $42,138,468.69 $54,311,107.96 August $30,766,642.59 $27,193,882.75 $50,946,347.51 September $31,436,740.68 $28,797,031.28 $53,304,998.95 October $32,621,237.60 $29,562,531.87 $53,251,081.77 November $55,768,728.62 $53,048,249.28 $84,604,102.48 December $52,233,891.79 $62,382,452.13 $98,702,814.61 January $49,307,366.28 $53,864,998.95 $66,631,763.25 $103,812,695.04 February $46,553,686.81 $52,435,487.27 $64,815,294.91 $95,670,335.84 March $48,087,241.40 $54,340,963.07 $68,066,131.09 April $45,974,675.17 $53,068,500.85 $67,511,156.89 May $41,927,274.60 $52,229,820.40 $63,702,091.44 June $40,106,511.08 $45,039,854.80 $57,596,531.97 General Fund as of March 31, 2023 CASH General Fund Cash 5 of 33 03.2023 Monthly Master042523 ws Pg. 43 Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 0 0.00 0 0.00 31,413 82,000.00 0.00 35 - SERVICE CHARGES 0 0.00 916,253 818,441.42 1,086,377 658,574.67 594,886.22 38 - MISCELLANEOUS INCOME 0 0.00 60,412 64,174.05 74,329 68,832.99 32,422.97 120 - HR JETPORT FUND REVENUE $0 $0.00 $976,665 $882,615.47 $1,192,119 $809,407.66 $627,309.19 Expense Function Department Budget Actual Budget Actual Budget Actual 120 - HARNETT REGIONAL JETPORT 4650 - HARNETT REGIONAL JETPORT 50 - SALARIES & BENEFITS 0 0.00 192,671 189,277.02 310,165 127,248.39 134,671.58 51 - PROFESSIONAL SRVCS 0 0.00 0 0.00 8,234 8,234.00 0.00 52 - SUPPLIES & MATERIALS 0 0.00 655,687 599,651.47 730,900 520,813.17 394,711.44 53 - CURRENT SRVCS 0 0.00 47,361 42,861.13 84,473 28,698.39 23,622.98 54 - FIXED CHARGES 0 0.00 46,049 42,341.22 58,347 46,302.68 36,770.24 55 - CAPITAL OUTLAY 0 0.00 15,971 15,971.00 0 0.00 0.00 58 - NON-CAPTALIZED ASSTS 0 0.00 18,926 17,927.33 0 0.00 0.00 70 - PCARD ENCUMBRANCE 0 0.00 0 0.00 0 0.00 0.00 120 - HR JETPORT FUND EXPENSE $0 $0.00 $976,665 $908,029.17 $1,192,119 $731,296.63 $589,776.24 120 - HR JETPORT FUND REVENUE (OVER) / UNDER EXPENSES $0 $0.00 $0 $25,413.70 $0 $78,111.03 $37,532.95 FY 2023 Same Period Last Year FY 2021 FY 2021 FY 2023 Harnett Regional Jetport Fund as of March 31, 2023 Same Period Last Year FY 2022 FY 2022 HRJetport Fund 120 6 of 33 03.2023 Monthly Master042523 ws Pg. 44 Airport Avgas 12/26 JetA 12/26 Avgas 01/30 JetA 01/30 Avgas 02/27 JetA 02/27 Avgas 03/27 JetA 03/27 Harnett Regional Jetport 5.40$ 5.15$ 5.40$ 5.15$ 5.15$ 5.40$ 5.15$ 5.40$ Clinton 6.26$ 6.98$ 6.26$ 6.98$ 5.65$ 5.75$ 5.65$ 5.75$ Duplin County 5.59$ 5.04$ 5.45$ 5.47$ 5.47$ 5.41$ 5.47$ 5.34$ Elizabethtown 4.75$ 4.65$ 4.75$ 4.65$ 4.30$ 4.20$ 4.70$ 4.20$ Fayetteville 6.56$ 7.39$ 6.22$ 8.25$ 6.22$ 7.33$ 6.22$ 7.28$ Gray's Creek 5.80$ NA 5.80$ NA 5.80$ NA 5.80$ NA Johnston County 6.12$ 6.22$ 6.12$ 6.22$ 6.12$ 6.22$ 6.12$ 6.22$ Lauringburg-Maxton 6.20$ 5.69$ 6.23$ 6.38$ 5.99$ 6.38$ 5.74$ 5.90$ Lumberton 6.42$ 5.44$ 4.82$ 4.71$ 4.82$ 4.71$ 5.20$ 4.71$ Moore County 5.90$ 6.70$ 5.60$ 6.70$ 5.60$ 6.70$ 5.90$ 6.80$ Mount Olive 4.90$ 5.29$ 5.20$ 5.19$ 5.26$ 5.19$ 5.30$ 4.76$ Raleigh Exec 5.56$ 5.76$ 6.08$ 6.84$ 5.70$ 5.76$ 5.88$ 5.77$ Rocky Mount- Wilson 5.35$ 5.77$ 5.15$ 5.29$ 4.95$ 5.91$ 4.95$ 5.91$ Siler City 6.09$ 6.59$ 6.09$ 6.59$ 5.99$ 5.99$ 5.99$ 5.99$ Triangle North 6.19$ 5.99$ 5.59$ 5.39$ 6.49$ 6.49$ 6.19$ 6.39$ Wayne Executive (Goldsboro)5.37$ 4.88$ 5.37$ 4.88$ 5.37$ 4.88$ 5.37$ 4.88$ Whiteville 4.85$ 4.75$ 5.10$ 4.75$ 4.40$ 4.30$ 5.25$ 4.30$ Average of All Others 5.74$ 5.81$ 5.61$ 5.89$ 5.51$ 5.68$ 5.61$ 5.61$ HRJ Fuel Price Comparison with Surrounding Airports By Date & Types (AvGas - JetA) Jetport Fuel Price Comp 7 of 33 03.2023 Monthly Master042523 ws Pg. 45 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $0.00 ($10,408.95) $58,373.33 August $0.00 $38,091.69 $15,679.56 September $0.00 $36,352.20 ($18,164.21) October $0.00 $21,459.01 $19,438.98 November $0.00 $16,092.97 $20,417.68 December $0.00 ($6,777.19)$28,902.77 January $0.00 $0.00 ($13,727.75)$52,597.97 February $0.00 $0.00 $13,226.32 $135,754.85 March $0.00 $0.00 ($31,248.47)$114,275.75 April $0.00 $0.00 $26,128.75 May $0.00 $0.00 $21,848.15 June $0.00 $0.00 $0.38 CASH Harnett Regional Jetport as of March 31, 2023 HRJetport Fund Cash 8 of 33 03.2023 Monthly Master042523 ws Pg. 46 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $0.00 $59,505.03 $51,698.20 August $0.00 $29,721.24 $67,748.43 September $0.00 $33,441.27 $60,548.35 October $0.00 $50,458.29 $48,640.25 November $0.00 $47,552.93 $59,025.04 December $0.00 $48,472.67 $38,546.58 January $0.00 $0.00 $65,652.06 $49,149.97 February $0.00 $0.00 $58,787.79 $52,832.84 March $0.00 $0.00 $42,570.99 $35,356.34 April $0.00 $0.00 $65,608.49 May $0.00 $0.00 $35,441.10 June $0.00 $0.00 $51,698.20 INVENTORY Harnett Regional Jetport as of March 31, 2023 HRJetport Fund Inventory 9 of 33 03.2023 Monthly Master042523 ws Pg. 47 Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 0 0.00 6,003,877 6,003,877.00 10,015,000 0.00 0.00 35 - SERVICE CHARGES 0 0.00 0 20,997.06 0 549,338.45 1,543.26 38 - MISCELLANEOUS INCOME 0 0.00 0 0.00 0 0.00 0.00 292 - ARPA FUND REVENUE $0 $0.00 $0 $0.00 $0 $0.00 $0.00 Revenue Category Budget Actual Budget Actual Budget Actual 292 - AMERICAN RESCUE PLAN ACT SRF 9990 - NON-DEPARTMENTAL 0 $0.00 0 $0.00 15,000 $11,250.00 $0.00 4120 - COUNTY ADMINISTRATION 0 $0.00 0 $0.00 0 $0.00 $0.00 4450 - EMERGENCY MEDICAL SERVICE 0 $0.00 0 $0.00 0 $0.00 $0.00 4591 - RADIO SYSTEM 0 $0.00 6,003,877 $6,003,877.00 10,000,000 $1,043,259.00 $0.00 292 - ARPA FUND EXPENSE $0 $0.00 $6,003,877 $6,003,877.00 $10,015,000 $1,054,509.00 $0.00 292 - ARPA FUND REVENUE (OVER) / UNDER EXPENSES $0 $0.00 $0 $20,997.06 $10,015,000 $549,338.45 $1,543.26 American Rescue Plan Act Fund as of March 31, 2023 FY 2021 FY 2022 FY 2023 FY 2023FY 2021 FY 2022 Same Period Last Year Same Period Last Year ARPA Fund 292 10 of 33 03.2023 Monthly Master042523 ws Pg. 48 Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 3,703 325,618.70 3,703 0.00 0 0.00 0.00 35 - SERVICE CHARGES 10,581 2,561.90 10,000 1,148.84 10,000 261,571.68 1,020.87 36 - ENTERPRISE CHARGES 1,583,500 1,663,356.41 1,384,000 2,379,865.25 1,761,500 1,771,110.01 1,731,702.22 37 - FACILITY FEES 34,600,000 39,100,367.08 35,875,000 39,966,546.68 37,564,650 28,229,633.92 26,562,731.71 38 - MISCELLANEOUS INCOME 710,000 4,045,071.83 552,094 9,532,429.38 320,000 595,427.71 1,136,262.95 39 - NON-REVENUE RECEIPTS 14,305,000 0.00 2,217,039 2,208,738.19 25,359,677 0.00 0.00 610 - HRW FUND REVENUE $51,212,784 $45,136,975.92 $40,041,836 $54,088,728.34 $65,015,827 $30,857,743.32 $29,431,717.75 Expense Function Department Budget Actual Budget Actual Budget Actual 610 - HARNETT REGIONAL WATER 91 - WATER & SEWER 7111 - HRW ADMINISTRATION 5,695,304 4,190,297.32 5,192,369 4,579,044.21 6,266,658 3,250,118.03 2,847,972.56 7113 - WATER TREATMENT PLANT 5,966,684 4,988,907.10 6,785,996 5,848,978.24 8,435,578 4,813,366.81 3,722,675.18 7115 - WASTEWATER TREATMENT PLANT 3,385,564 2,245,476.78 3,715,242 2,911,906.21 3,583,141 2,021,727.19 1,582,452.89 7117 - SOUTH HARNETT WASTEWATER PLANT 2,975,213 2,442,340.96 3,622,758 3,156,372.31 3,737,799 1,912,282.23 1,869,581.42 7119 - WATER DISTRIBUTION 5,065,366 4,372,934.46 5,449,739 4,790,103.03 6,368,171 3,282,340.64 3,276,471.47 7121 - SEWER COLLECTIONS 5,446,344 4,305,290.43 5,773,595 4,806,693.91 5,712,678 2,837,874.99 2,770,756.41 7131 - RETIREE INSURANCE HRW 0 0.00 60,807 65,678.76 63,829 45,074.34 43,684.12 9990 - NON-DEPARTMENTAL 22,678,309 $31,241,868.35 9,441,330 19,160,759.58 30,847,973 28,806,408.00 7,103.05 610 - HRW FUND EXPENSE $51,212,784 $53,787,115.40 $40,041,836 $45,319,536.25 $65,015,827 $46,969,192.23 $16,120,697.10 610 - HRW FUND REVENUE (OVER) / UNDER EXPENSES $0 $8,650,139.48 $0 $8,769,192.09 $0 $16,111,448.91 $13,311,020.65 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023FY 2022 FY 2022 FY 2023 Harnett Regional Water Fund as of March 31, 2023 HRW Fund 610 11 of 33 03.2023 Monthly Master042523 ws Pg. 49 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $56,308,485.60 $51,396,573.71 $69,906,540.92 August $57,887,471.15 $53,478,105.50 $71,395,812.59 September $53,052,496.69 $54,740,839.35 $72,918,273.72 October $41,972,645.61 $57,802,598.49 $74,956,217.38 November $44,623,020.08 $59,929,869.87 $77,010,360.42 December $46,244,526.10 $61,433,187.37 $78,805,658.04 January $57,818,912.12 $47,842,388.74 $63,336,473.21 $79,769,987.45 February $58,911,946.79 $49,655,875.28 $65,045,521.23 $56,832,826.21 March $60,961,613.87 $51,249,479.82 $62,345,519.84 $53,956,930.95 April $60,643,544.18 $52,788,896.94 $62,323,826.87 May $61,748,714.89 $55,026,201.87 $57,960,361.56 June $55,307,862.26 $48,531,475.46 $58,710,523.48 Harnett Regional Water Fund as of March 31, 2023 CASH HRW Fund Cash 12 of 33 03.2023 Monthly Master042523 ws Pg. 50 Revenue Category Budget Actual Budget Actual Budget Actual 30 - TAXES - AD VALOREM 0 0.00 0 0.00 0 0.00 0.00 33 - RESTRICTED REVENUE 282,000 299,010.13 335,000 333,365.11 260,000 195,155.20 168,933.47 35 - SERVICE CHARGES 553 2,072.25 0 410.26 0 11,224.12 273.41 36 - ENTERPRISE CHARGES 1,910,200 3,114,682.13 3,116,088 3,455,130.23 3,111,334 2,746,235.18 2,303,786.45 37 - FACILITY FEES 4,581,020 4,648,605.96 4,745,000 4,722,829.38 4,520,000 4,725,200.04 4,644,899.68 38 - MISCELLANEOUS INCOME 100,733 138,848.24 45,000 124,396.71 226,981 250,009.27 94,658.93 39 - NON-REVENUE RECEIPTS 0 0.00 397,860 0.00 0 0.00 0.00 660 - SOLID WASTE FUND REVENUE $6,874,506 $8,203,218.71 $8,638,948 $8,636,131.69 $8,118,315 $7,927,823.81 $7,212,551.94 Expense Function Department Budget Actual Budget Actual Budget Actual 660 - SOLID WASTE MANAGEMENT 96 - SOLID WASTE 7410 - SOLID WASTE MANAGEMENT 5,382,988 5,135,026.60 6,472,964 5,698,296.50 7,300,387 3,891,100.23 3,525,344.27 7431 - RETIREE INSURANCE SW 0 0.00 20,000 20,448.00 20,000 17,801.00 14,407.92 9990 - NON-DEPARTMENTAL 1,491,518 1,939,858.33 2,145,984 2,459,955.28 797,928 797,928.00 0.00 610 - SOLID WASTE FUND EXPENSE $6,874,506 $7,074,884.93 $8,638,948 $8,178,699.78 $8,118,315 $4,706,829.23 $3,539,752.19 660 - SOLID WASTE FUND REVENUE (OVER) / UNDER EXPENSES $0 $1,128,333.78 $0 $457,431.91 $0 $3,220,994.58 $3,672,799.75 FY 2021 Same Period Last Year FY 2021 FY 2023 FY 2023FY 2022 FY 2022 Solid Waste Fund as of March 31, 2023 Same Period Last Year Solid Waste Fund 660 13 of 33 03.2023 Monthly Master042523 ws Pg. 51 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $3,387,995.72 $4,457,425.74 $5,242,053.75 August $3,375,944.64 $4,647,598.39 $5,341,058.08 September $3,607,274.52 $4,882,131.66 $5,547,560.45 October $3,759,678.53 $5,029,336.00 $5,661,414.55 November $5,581,197.69 $6,828,615.40 $7,650,032.21 December $6,451,303.81 $7,686,623.97 $8,441,890.85 January $4,616,721.91 $5,784,640.53 $8,071,097.98 $8,957,335.18 February $4,751,271.26 $5,844,033.09 $8,201,845.59 $9,072,796.26 March $4,565,672.41 $5,773,139.20 $8,188,060.38 $8,162,094.29 April $4,268,648.15 $5,713,193.95 $7,697,878.34 May $4,194,405.45 $5,677,132.65 $7,291,803.85 June $3,590,915.49 $4,646,306.54 $5,409,762.66 Solid Waste Fund as of March 31, 2023 CASH Solid Waste Fund Cash 14 of 33 03.2023 Monthly Master042523 ws Pg. 52 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,200,000 1,134,569.36 760,000 1,322,417.89 850,000 410,325.48 925,179.68 38 - MISCELLANEOUS INCOME 0 1,350.81 0 0.00 0 1,792.57 1,655.65 39 - NON-REVENUE RECEIPTS 11,700 0.00 0 0.00 0 0.00 0.00 810 - WORKER'S COMP FUND REVENUE $1,211,700 $1,135,920.17 $760,000 $1,322,417.89 $850,000 $412,118.05 $926,835.33 Expense Function Department Budget Actual Budget Actual Budget Actual 810 - WORKERS COMPENSATION FUND 00 - GENERAL GOVERNMENT 9301 - WORKER'S COMPENSATION 1,211,700 180,454.06 760,000 349,599.73 850,000 $532,330.63 357,489.06 810 - WORKER'S COMP FUND EXPENSE $1,211,700 $180,454.06 $760,000 $349,599.73 $850,000 $532,330.63 $357,489.06 810 - WORKERS'S COMP FUND REVENUE (OVER) / UNDER EXPENSES $0 $955,466.11 $0 $972,818.16 $0 $120,212.58 $569,346.27 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 FY 2022 FY 2022 Worker's Compensation Fund as of March 31, 2023 Worker's Comp Fund 810 15 of 33 03.2023 Monthly Master042523 ws Pg. 53 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $4,629,563.32 $5,397,537.95 $6,198,476.66 August $4,708,459.01 $5,246,986.87 $5,963,212.81 September $4,785,314.35 $5,461,742.83 $5,986,205.95 October $4,844,771.48 $5,445,463.58 $6,015,973.71 November $4,925,635.39 $5,542,243.37 $6,011,959.38 December $4,982,050.03 $5,731,380.38 $6,036,954.24 January $3,318,944.43 $5,056,960.44 $5,816,058.20 $6,008,286.38 February $3,402,272.55 $5,098,194.24 $5,865,374.15 $6,023,150.11 March $4,462,485.39 $5,134,695.99 $5,944,781.80 $6,034,359.79 April $4,544,990.12 $5,193,817.86 $6,032,017.52 May $4,545,144.92 $5,139,295.68 $6,116,497.62 June $4,627,680.64 $5,380,269.92 $6,163,362.66 Worker's Compensation Fund as of March 31, 2023 CASH Worker's Comp Fund Cash 16 of 33 03.2023 Monthly Master042523 ws Pg. 54 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 250,000 221,464.63 250,000 108,674.91 250,000 95,275.50 69,202.73 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 820 - UNEMPLOYMENT FUND REVENUE $250,000 $221,464.63 $250,000 $108,674.91 $250,000 $95,275.50 $69,202.73 Expense Function Department Budget Actual Budget Actual Budget Actual 820 - UNEMPLOYMENT INSURANCE 00 - GENERAL GOVERNMENT 9305 - UNEMPLOYMENT INSURANCE 250,000 19,734.22 250,000 16,813.26 250,000 $31,606.81 16,813.26 820 - UNEMPLOYMENT FUND EXPENSE $250,000 $19,734.22 $250,000 $16,813.26 $250,000 $31,606.81 $16,813.26 820 - UNEMPLOYMENT FUND REVENUE (OVER) / UNDER EXPENSES $0 $201,730.41 $0 $91,861.65 $0 $63,668.69 $52,389.47 Same Period Last Year Same Period Last Year FY 2023FY 2021 FY 2021 FY 2023 FY 2022 FY 2022 Unemployment Insurance Fund as of March 31, 2023 Unemployment Ins Fund 820 17 of 33 03.2023 Monthly Master042523 ws Pg. 55 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $1,564,861.07 $1,753,400.43 $1,850,881.89 August $1,582,832.12 $1,762,410.64 $1,861,008.73 September $1,600,689.65 $1,780,727.76 $1,871,494.58 October $1,618,305.74 $1,780,727.76 $1,881,948.64 November $1,638,946.38 $1,789,872.72 $1,892,577.25 December $1,657,035.68 $1,782,256.94 $1,871,937.68 January $1,474,589.24 $1,675,333.87 $1,791,497.73 $1,882,907.21 February $1,475,924.07 $1,673,523.80 $1,801,313.49 $1,893,735.82 March $1,493,866.97 $1,691,308.04 $1,811,113.56 $1,904,454.36 April $1,511,420.05 $1,709,071.02 $1,820,978.24 May $1,511,420.05 $1,709,071.02 $1,830,806.28 June $1,529,156.27 $1,748,924.02 $1,840,785.67 Unemployment Insurance Fund as of March 31, 2023 CASH Unemployment Ins Fund Cash 18 of 33 03.2023 Monthly Master042523 ws Pg. 56 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 174,690 158,707.77 180,900 157,395.13 191,875 115,500.00 104,677.23 38 - MISCELLANEOUS INCOME 0 0.00 0 0.00 0 0.00 0.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 830 - EMPLOYEE CLINIC FUND REVENUE $174,690 $158,707.77 $180,900 $157,395.13 $191,875 $115,500.00 $104,677.23 Expense Function Department Budget Actual Budget Actual Budget Actual 830 - EMPLOYEE CLINIC 00 - GENERAL GOVERNMENT 9302 - EMPLOYEE CLINIC 174,690 166,113.38 180,900 127,581.04 191,875 124,494.77 81,597.75 830 - EMPLOYEE CLINIC FUND EXPENSE $174,690 $166,113.38 $180,900 $127,581.04 $191,875 $124,494.77 $81,597.75 830 - EMPLOYEE CLINIC FUND REVENUE (OVER) / UNDER EXPENSES $0 $7,405.61 $0 $29,814.09 $0 $8,994.77 $23,079.48 FY 2023 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 Employee Clinic Fund as of March 31, 2023 FY 2022 FY 2022 Employee Clinic Fund 830 19 of 33 03.2023 Monthly Master042523 ws Pg. 57 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $700,090.56 $692,061.11 $723,019.23 August $697,900.58 $703,376.13 $723,881.09 September $697,339.53 $723,948.07 $723,117.23 October $696,760.57 $714,556.04 $721,661.50 November $695,238.45 $715,794.77 $722,166.94 December $697,288.04 $714,986.69 $722,572.03 January $653,534.82 $696,374.16 $709,565.30 $712,125.82 February $653,489.63 $691,759.00 $709,021.02 $715,311.33 March $655,093.01 $690,369.37 $708,705.76 $706,441.27 April $655,094.11 $691,478.87 $709,557.47 May $639,617.51 $679,723.63 $703,692.41 June $668,125.25 $688,250.11 $720,716.69 Employee Clinic Fund as of March 31, 2023 CASH Employee Clinic Fund Cash 20 of 33 03.2023 Monthly Master042523 ws Pg. 58 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 11,296,710 10,509,741.05 10,000,000 10,001,728.55 11,253,500 7,938,898.06 6,980,781.63 38 - MISCELLANEOUS INCOME 17,875 12,867.15 512,000 352,486.51 650,000 614,263.23 0.00 39 - NON-REVENUE RECEIPTS 1,000,000 0.00 300,000 0.00 323,000 0.00 0.00 841 - MEDICAL SELF INS FUND REVENUE $12,314,585 $10,522,608.20 $10,812,000 $10,354,215.06 $12,226,500 $8,553,161.29 $6,980,781.63 Expense Function Department Budget Actual Budget Actual Budget Actual 841 - MEDICAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9303 - MEDICAL INSURANCE - SELF 12,314,585 8,815,520.42 10,812,000 9,499,014.57 12,226,500 7,374,643.40 7,592,728.89 841 - MEDICAL SELF INS FUND EXPENSE $12,314,585 $8,815,520.42 $10,812,000 $9,499,014.57 $12,226,500 $7,374,643.40 $7,592,728.89 841 - MEDICAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $1,707,087.78 $0 $855,200.49 $0 $1,178,517.89 $611,947.26 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 FY 2022 FY 2022 Medical Self Insurance Fund as of March 31, 2023 Medical Self Ins Fund 841 21 of 33 03.2023 Monthly Master042523 ws Pg. 59 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $8,394,410.05 $9,936,719.25 $11,349,904.41 August $8,309,827.07 $9,558,799.23 $10,768,815.17 September $8,147,930.01 $10,182,610.45 $10,928,333.21 October $8,437,620.01 $9,335,253.68 $11,370,700.94 November $8,763,538.51 $9,233,189.07 $11,135,597.77 December $9,045,130.83 $9,259,586.30 $11,221,624.97 January $7,007,592.83 $8,831,273.60 $9,612,099.50 $11,189,119.32 February $7,354,736.35 $9,169,687.18 $9,498,226.66 $11,364,307.86 March $7,342,921.96 $8,848,785.68 $9,065,970.50 $11,660,274.02 April $7,508,905.85 $9,411,546.73 $9,200,399.34 May $7,195,825.04 $8,592,344.42 $9,240,938.82 June $6,837,286.28 $9,752,219.84 $10,485,775.01 Medical Self Insurance Fund as of March 31, 2023 CASH Medical Self Ins Fund Cash 22 of 33 03.2023 Monthly Master042523 ws Pg. 60 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 633,500 543,514.52 550,000 520,837.10 650,000 388,475.00 356,055.74 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 843 - DENTAL SELF INS FUND REVENUE $633,500 $543,514.52 $550,000 $520,837.10 $650,000 $388,475.00 $356,055.74 Expense Function Department Budget Actual Budget Actual Budget Actual 843 - DENTAL INSURANCE - SELF 00 - GENERAL GOVERNMENT 9307 - DENTAL INSURANCE - SELF 633,500 433,314.63 550,000 445,343.87 650,000 336,500.79 332,233.88 843 - DENTAL SELF INS FUND EXPENSE $633,500 $433,314.63 $550,000 $445,343.87 $650,000 $336,500.79 $332,233.88 843 - DENTAL SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $110,199.89 $0 $75,493.23 $0 $51,974.21 $23,821.86 Same Period Last Year FY 2021 FY 2021 FY 2023 Same Period Last Year FY 2023 FY 2022 FY 2022 Dental Self Insurance Fund as of March 31, 2023 Dental Self Ins Fund 843 23 of 33 03.2023 Monthly Master042523 ws Pg. 61 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $612,444.32 $724,520.63 $822,532.24 August $602,629.10 $696,545.18 $790,185.12 September $609,678.56 $734,630.02 $797,437.93 October $603,363.16 $695,046.20 $795,743.33 November $620,268.72 $701,911.17 $804,974.47 December $653,169.60 $711,856.70 $812,872.25 January $536,850.80 $657,824.44 $731,212.41 $832,304.92 February $547,206.22 $665,545.09 $737,896.84 $837,835.80 March $544,639.17 $673,523.14 $739,863.15 $832,355.91 April $551,952.84 $676,078.18 $739,741.66 May $551,708.84 $605,182.75 $738,936.50 June $544,280.85 $703,042.49 $780,381.70 Dental Self Insurance Fund as of March 31, 2023 CASH Dental Self Ins Fund Cash 24 of 33 03.2023 Monthly Master042523 ws Pg. 62 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,965,000 913,653.88 1,500,000 1,496,197.47 1,500,000 358,070.59 304,726.91 36 - ENTERPRISE CHARGES 0 0.00 0 25.00 0 200.00 25.00 39 - NON-REVENUE RECEIPTS 0 0.00 0 0.00 0 0.00 0.00 845 - RETIREE SELF INS FUND REVENUE $1,965,000 $913,653.88 $1,500,000 $1,496,222.47 $1,500,000 $358,270.59 $304,751.91 Expense Function Department Budget Actual Budget Actual Budget Actual 845 - MEDICAL INSURANCE RETIREE 00 - GENERAL GOVERNMENT 9304 - MEDICAL INSURANCE - RETIREE 1,965,000 1,122,842.12 1,500,000 1,117,497.44 1,500,000 918,880.55 225,257.16 845 - RETIREE SELF INS FUND EXPENSE $1,965,000 $1,122,842.12 $1,500,000 $1,117,497.44 $1,500,000 $918,880.55 $225,257.16 845 - RETIREE SELF INS FUND REVENUE (OVER) / UNDER EXPENSES $0 $209,188.24 $0 $378,725.03 $0 $560,609.96 $79,494.75 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 FY 2022 FY 2022 Retiree Self Insurance Fund as of March 31, 2023 Retiree Self Ins Fund 845 25 of 33 03.2023 Monthly Master042523 ws Pg. 63 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $646,924.11 $433,059.43 $829,677.64 August $590,241.30 $433,709.18 $770,327.59 September $489,464.41 $465,741.89 $736,325.28 October $466,294.49 $453,817.31 $706,499.95 November $396,067.66 $466,968.91 $641,611.83 December $334,887.79 $476,600.30 $599,142.27 January ($315,453.19)$206,371.20 $490,226.98 $445,630.08 February ($386,583.22)$180,684.24 $500,421.34 $318,834.16 March ($530,399.34)$35,718.25 $509,125.50 $246,480.73 April ($611,564.54)$93,954.23 $519,585.17 May ($622,617.07)$594,052.00 $532,894.99 June ($625,264.03)$428,365.66 $807,090.69 Retiree Self Insurance Fund as of March 31, 2023 CASH Retiree Self Ins Fund Cash 26 of 33 03.2023 Monthly Master042523 ws Pg. 64 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 89,508 203,985.55 113,111 217,546.85 119,160 95,820.00 69,271.00 38 - MISCELLANEOUS INCOME 27,600 108,493.81 45,546 62,469.00 12,000 23,539.72 45,546.00 39 - NON-REVENUE RECEIPTS 150,000 150,000.00 203,823 100,000.00 100,000 100,000.00 100,000.00 880 - FLEET SERVICES FUND REVENUE $267,108 $462,479.36 $362,480 $380,015.85 $231,160 $219,359.72 $214,817.00 Expense Function Department Budget Actual Budget Actual Budget Actual 880 - FLEET SERVICES 00 - GENERAL GOVERNMENT 9410 - FLEET SERVICES 267,108 34,981.61 280,215 277,136.77 168,930 57,916.00 125,914.00 9910 - CONTINGENCY 0 0.00 82,265 0.00 62,230 0.00 0.00 880 - FLEET SERVICES FUND EXPENSE $267,108 $34,981.61 $362,480 $277,136.77 $231,160 $57,916.00 $125,914.00 880 - FLEET SERVICES FUND REVENUE (OVER) / UNDER EXPENSES $0 $427,497.75 $0 $102,879.08 $0 $161,443.72 $88,903.00 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 FY 2022 FY 2022 Fleet Services Fund as of March 31, 2023 Fleet Services Fund 880 27 of 33 03.2023 Monthly Master042523 ws Pg. 65 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $601,279.16 $1,090,458.91 $1,203,969.99 August $609,506.58 $1,184,866.91 $1,199,951.99 September $615,658.56 $1,229,825.91 $1,167,317.99 October $624,166.20 $1,229,825.91 $1,199,618.20 November $632,714.95 $1,214,819.91 $1,212,931.71 December $791,230.55 $1,236,861.91 $1,223,968.71 January $565,853.83 $799,782.08 $1,244,772.91 $1,232,852.73 February $572,455.44 $808,107.96 $1,170,235.91 $1,245,938.71 March $573,647.74 $816,344.80 $1,179,361.91 $1,354,781.71 April $574,877.57 $823,803.80 $1,188,487.91 May $616,138.99 $831,262.80 $1,110,625.14 June $571,361.34 $1,090,458.91 $1,193,337.99 Fleet Services Fund as of March 31, 2023 CASH Fleet Services Fund Cash 28 of 33 03.2023 Monthly Master042523 ws Pg. 66 Revenue Category Budget Actual Budget Actual Budget Actual 35 - SERVICE CHARGES 1,413,384 1,794,850.94 1,568,420 1,788,955.15 1,748,415 633,288.82 1,018,385.64 38 - MISCELLANEOUS INCOME 0 2,205.00 0 0.00 0 577,124.58 0.00 39 - NON-REVENUE RECEIPTS 607,000 350,000.00 350,000 350,000.00 1,234,295 1,624,009.00 350,000.00 890 - INFO TECHNOLOGY FUND REVENUE $2,020,384 $2,147,055.94 $1,918,420 $2,138,955.15 $2,982,710 $2,834,422.40 $1,368,385.64 Expense Function Department Budget Actual Budget Actual Budget Actual 890 - INFORMATION TECHNOLOGY 00 - GENERAL GOVERNMENT 9420 - TECHNOLOGY 2,020,384 1,730,021.57 1,918,420 1,711,368.67 2,982,710 1,879,599.89 1,111,046.18 890 - INFO TECHNOLOGY FUND EXPENSE $2,020,384 $1,730,021.57 $1,918,420 $1,711,368.67 $2,982,710 $1,879,599.89 $1,111,046.18 890 - INFO TECHNOLOGY FUND REVENUE (OVER) / UNDER EXPENSES $0 $417,034.37 $0 $427,586.48 $0 $954,822.51 $257,339.46 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 FY 2022 FY 2022 Information Technology Fund as of March 31, 2023 Info Technology Fund 890 29 of 33 03.2023 Monthly Master042523 ws Pg. 67 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $852,093.02 $1,491,852.27 $2,011,076.10 August $804,366.93 $1,558,798.40 $2,089,994.83 September $800,161.86 $1,577,002.07 $1,729,069.00 October $902,530.92 $1,729,919.23 $1,725,039.53 November $889,233.88 $1,765,161.46 $894,683.88 December $1,046,992.00 $1,751,059.99 $906,874.68 January $515,312.48 $1,189,759.12 $1,792,688.16 $1,055,166.45 February $534,562.33 $1,297,161.54 $1,843,447.45 $1,128,314.64 March $536,134.58 $1,426,825.09 $1,790,864.84 $2,862,057.47 April $570,566.56 $1,207,565.76 $1,763,694.03 May $612,977.73 $973,972.46 $1,845,823.82 June $798,424.51 $1,492,175.30 $1,924,106.94 Information Technology Fund as of March 31, 2023 CASH Info Technology Fund Cash 30 of 33 03.2023 Monthly Master042523 ws Pg. 68 Revenue Category Budget Actual Budget Actual Budget Actual 33 - RESTRICTED REVENUE 313,368 168,677.61 681,954 443,960.42 884,546 163,682.09 78,573.87 38 - MISCELLANEOUS INCOME 155,840 47,990.21 101,068 31,562.93 73,000 18,979.50 24,422.09 39 - NON-REVENUE RECEIPTS 57,484 57,484.00 0 0.00 195,350 0.00 0.00 250 - VET TREATMENT COURT REVENUE $526,692 $274,151.82 $783,022 $475,523.35 $1,152,896 $182,661.59 $102,995.96 Expense Function Department Budget Actual Budget Actual Budget Actual 250 - VETERANS SERVICE SRF 00 - GENERAL GOVERNMENT 4185 - VETERANS TREATMENT COURT 526,692 269,609.26 783,022 286,462.47 1,152,896 270,312.68 180,407.06 250 - VET TREATMENT COURT EXPENSE $526,692 $269,609.26 $783,022 $286,462.47 $1,152,896 $270,312.68 $180,407.06 250 - VET TREATMENT COURT REVENUE (OVER) / UNDER EXPENSES $0 $4,542.56 $0 $189,060.88 $0 $87,651.09 $77,411.10 Same Period Last Year Same Period Last Year FY 2021 FY 2021 FY 2023 FY 2023 FY 2022 FY 2022 Veteran's Treatment Court as of March 31, 2023 Veteran's Treatment Court 250 31 of 33 03.2023 Monthly Master042523 ws Pg. 69 Fiscal Year Fiscal Year Fiscal Year Fiscal Year 2020 2021 2022 2023 July $3,916.48 $26,014.22 $106,617.08 August ($19.11)$6,936.02 $197,695.62 September ($5,847.89)$1,617.01 $170,316.49 October ($52,239.74)($48,042.22)$236,136.83 November ($55,209.63)($67,669.08)$228,538.41 December ($10,827.18)($74,565.51)$144,375.79 January $7,582.66 ($54,087.90)($93,893.26)$120,098.68 February $35,756.46 ($60,437.65)($36,255.36)$154,587.98 March $19,011.14 ($63,403.68)($66,528.04)$113,762.06 April $30,146.67 ($63,500.51)($80,604.24) May $42,612.59 ($72,985.76)$162,839.31 June $28,305.11 $36,571.92 $127,852.90 Veteran's Treatment Court as of March 31, 2023 CASH Veteran's Treatment Court Cash 32 of 33 03.2023 Monthly Master042523 ws Pg. 70 as of December 31, 2020 1. Current year activity :City Hold Harmless School Hold Harmless Fiscal Year 2023as of October 31, 2022Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2022 1,157,314.97$ 749,270.84$ 353,464.82$ 260,035.43$ 520,070.87$ 13.76$ 532,789.40$ 351,044.51$ (137,020.83)$ (182,627.83)$ 320,851.18$ 3,925,207.12$ August, 2022 1,056,359.97$ 766,939.47$ 325,450.70$ 269,441.55$ 538,883.10$ 20.65$ 532,789.40$ 316,994.86$ (146,156.14)$ (222,408.85)$ 294,360.22$ 3,732,674.93$ September, 2022 1,164,761.44$ 753,374.63$ 355,098.87$ 261,963.22$ 523,926.43$ -$ 532,789.40$ 354,728.83$ (137,991.78)$ (183,490.36)$ 322,725.75$ 3,947,886.43$ October, 2022 917,997.69$ 724,950.21$ 289,874.24$ 253,815.32$ 507,630.64$ 2.97$ 532,789.40$ 274,165.86$ (140,568.23)$ (229,808.62)$ 258,353.54$ 3,389,203.02$ November, 2022 1,016,485.39$ 714,540.62$ 321,630.62$ 245,037.79$ 490,075.58$ 73.90$ 532,880.23$ 303,440.76$ (132,132.55)$ (193,176.81)$ 285,632.12$ 3,584,487.65$ December, 2022 1,371,351.32$ 838,394.41$ 416,287.26$ 290,002.96$ 580,005.92$ (4.12)$ 532,880.23$ 417,354.23$ (149,779.40)$ (183,247.31)$ 379,151.96$ 4,492,397.46$ January, 2023 1,072,630.12$ 704,166.18$ 330,379.47$ 243,446.33$ 486,892.67$ -$ 532,880.23$ 325,443.92$ (129,021.26)$ (174,394.75)$ 298,254.82$ 3,690,677.73$ February, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ March, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ April, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ May, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ June, 2023 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 7,756,900.90$ 5,251,636.36$ 2,392,185.98$ 1,823,742.60$ 3,647,485.21$ 107.16$ 3,729,798.29$ 2,343,172.97$ (972,670.19)$ (1,369,154.53)$ 2,159,329.59$ 26,762,534.34$ Year over Year Change 11.46%10.87%14.69%9.24%9.24%45.99%16.03%15.46%6.69%2.59%51.53%15.29% 2. Comparison to prior year :City Hold Harmless School Hold Harmless Fiscal Year 2022 Article 39 Article 40 Article 42 Article 40 Article 42 Article 44 Article 44 *524 Article 46 Article 39 Article 39 Special Total July, 2021 873,616.34$ 696,818.04$ 270,497.04$ 246,763.14$ 493,526.29$ -$ 459,092.34$ 250,664.40$ (139,686.11)$ (236,809.36)$ 180,905.28$ 3,095,387.40$ August, 2021 774,746.17$ 653,135.22$ 241,332.11$ 232,372.88$ 464,745.77$ 3.78$ 459,092.34$ 221,450.95$ (133,268.57)$ (234,850.37)$ 160,727.74$ 2,839,488.02$ September, 2021 1,051,674.97$ 652,833.31$ 307,490.95$ 230,720.67$ 461,441.34$ 13.64$ 459,092.34$ 310,685.98$ (123,042.19)$ (160,389.43)$ 213,535.76$ 3,404,057.34$ October, 2021 1,126,998.11$ 651,080.78$ 328,641.02$ 228,015.77$ 456,031.55$ -$ 459,092.34$ 333,701.55$ (118,932.77)$ (136,907.67)$ 228,643.57$ 3,556,364.25$ November, 2021 1,088,994.29$ 698,504.12$ 321,030.17$ 246,651.41$ 493,302.82$ 41.85$ 459,387.16$ 319,912.01$ (132,476.80)$ (180,957.98)$ 221,757.41$ 3,536,146.46$ December, 2021 1,074,826.03$ 783,676.83$ 320,376.48$ 280,256.10$ 560,512.19$ 14.13$ 459,387.16$ 311,921.86$ (155,027.09)$ (245,023.06)$ 219,744.73$ 3,610,665.36$ January, 2022 968,615.63$ 600,615.11$ 296,437.34$ 204,757.61$ 409,515.22$ -$ 459,387.16$ 281,008.13$ (109,278.67)$ (139,702.03)$ 199,713.26$ 3,171,068.76$ February, 2022 903,340.13$ 581,568.36$ 270,796.29$ 202,883.40$ 405,766.80$ 31.11$ 459,387.16$ 263,985.99$ (109,685.16)$ (149,168.58)$ 184,913.43$ 3,013,818.93$ March, 2022 1,222,316.18$ 750,716.35$ 355,015.11$ 266,376.44$ 532,752.89$ -$ 459,387.16$ 360,461.30$ (141,070.39)$ (181,726.84)$ 247,713.35$ 3,871,941.55$ April, 2022 1,206,125.87$ 741,653.28$ 351,887.62$ 262,111.29$ 524,222.58$ (239.47)$ 459,387.16$ 354,731.88$ (138,875.50)$ (179,275.68)$ 244,751.74$ 3,826,480.77$ May, 2022 1,159,362.11$ 735,933.72$ 343,084.43$ 258,389.36$ 516,778.73$ 57.16$ 460,511.00$ 338,917.88$ (135,539.79)$ (185,629.67)$ 236,844.68$ 3,728,709.61$ June, 2022 1,223,057.57$ 793,226.38$ 358,882.36$ 281,292.80$ 562,585.61$ -$ 532,789.41$ 359,193.01$ (148,795.52)$ (209,689.10)$ 249,125.50$ 4,001,668.02$ 6,959,471.54$ 4,736,663.41$ 2,085,805.11$ 1,669,537.58$ 3,339,075.18$ 73.40$ 3,214,530.84$ 2,029,344.88$ (911,712.20)$ (1,334,639.90)$ 1,425,027.75$ 23,213,177.59$ AnnualizedBudget % Collected(7 months)to Date 1103100 310231 5,415,076.18$ 8,455,000$ (3,039,923.82)$ 4,932,083$ 482,992.85$ 64.05%NC Sales Tax - Article 39 1103100 310233 5,251,636.36$ 6,673,000$ (1,421,363.64)$ 3,892,583$ 1,359,053.03$ 78.70%NC Sales Tax - Article 40 (General Fund) 1103100 310235 2,392,185.98$ 979,000$ 1,413,185.98$ 571,083$ 1,821,102.65$ 244.35%NC Sales Tax - Article 42 (General Fund) 1103100 310237 3,729,905.45$ 5,309,000$ (1,579,094.55)$ 3,096,917$ 632,988.78$ 70.26%NC Sales Tax - Article 44 & Article 44 *524 16,788,803.97$ 21,416,000.00$ (4,627,196.03)$ 12,492,666.67$ 4,296,137.30$ 78.39% 2118401 - 380892 2,159,329.59$ 2,348,424.00$ (189,094.41)$ 1,369,914.00$ 789,415.59$ 91.95%NC Sales Tax Special Districts 3003100 310233 1,823,742.60$ 2,550,000$ (726,257.40)$ 1,487,500$ 336,242.60$ 71.52%NC Sales Tax - Article 40 (Education) 3003100 310235 3,647,485.21$ 5,544,917$ (1,897,431.79)$ 3,234,535$ 412,950.29$ 65.78%NC Sales Tax - Article 42 (Education) 3003100 310239 2,343,172.97$ 3,300,000$ (956,827.03)$ 1,925,000$ 418,172.97$ 71.01%NC Sales Tax - Article 46 7,814,400.78$ 11,394,917.00$ (3,580,516.22)$ 6,647,034.92$ 1,167,365.86$ 68.58% 3. Reconciliation to general ledger :Over/(Under) Annualized BudgetBalance to Tyler Activity Budget Over/(Under) Budget HARNETT COUNTY SALES TAX ANALYSIS BY ARTICLE General Fund Board of Education General Fund Board of Education Monthly Sales Tax 33 of 33 03.2023 Monthly Master042523 ws Pg. 71 Item 13 042523 ws Pg. 72 042523 ws Pg. 73 042523 ws Pg. 74 042523 ws Pg. 75