Loading...
HomeMy Public PortalAbout2024 BudgetPage 1 of 10 November 21, 2023 The Honorable Dean Katerndahl, Mayor Members of the Board of Aldermen Citizens of Parkville, Missouri RE: 2024 Budget Message from the City Administrator Dear Mayor Katerndahl and Board of Aldermen: It is my pleasure to formally present the City of Parkville’s Adopted Fiscal Year 2024 Budget for your review and consideration. The 5-year forecast, by fund, reflects an average annual 3% growth in sales tax and property tax revenue (all other revenue remains flat), and an average annual 3% growth in operating costs. This entire document serves as a resource allocation plan that meets the requirements of the City of Parkville by being balanced and prepared under the principles, and rules, of the City’s Fiscal Reserve Policy currently in effect. The budget is a product of a comprehensive team effort, which benefits the entire city of Parkville. The City’s fiscal year runs from January 1 through December 31 and provides a transparent spending plan that represents the Board of Aldermen’s priorities and reflects expected revenue and expenditures. State law requires that cities operate under a balanced budget. Unlike the federal government, local governments are not allowed to end a year with a deficit balance. BUDGET PROCESS, PRIORITIES and CAPITAL IMPROVEMENT PLAN for 2024 Budget development began in April when the Mayor, Board of Aldermen and Leadership Team held a planning session and retreat led by Strategic Government Resources (SGR) to review established strategic goals, priorities and to discuss issues heard from, and facing, the community. A refreshed overview of the principles of Servant Leadership were re- reviewed. This earlier preparation along with prior planning by presenting, reviewing, and approving the Capital Improvement Plan (CIP), October 17, 2023, prior to budget development, resulted in a better budgetary process. Preparing the annual budget involves a team effort from the City Administrator, Deputy City Administrator/Finance Director, Assistant City Administrator, and senior leadership to ensure government resources deliver the greatest service in accordance with community needs, the Strategic Plan, and the goals and objectives of the Mayor and Board of Aldermen. The Strategic Planning Goals and Objectives, part of your 2024 Budget Binder, are also found here, (https://parkvillemo.gov/download/StrategicGoals2023-2024.pdf). Also, the Strategic Planning Goals and Objectives serve as a guide when staff worked to develop the proposed Capital Improvement Plan (CIP), also included in your 2024 Budget Binder, and found here: https://parkvillemo.gov/download/2024-2028CIP.pdf The City’s budget has consistently satisfied nationally recognized guidelines designed to assess how well the budget serves as a policy document, a financial plan, an operations guide, and a communications device. We will submit our budget for this recognition again in 2024. Page 2 of 10 BUDGET DOCUMENT: NEW IN 2024, DIFFERENCES and FEATURES Further improvements and additions have been made in the 2024 budget document, including:  Utilization of a financial accounting system, INCODE, for budget preparation and reporting  Reclassification of major and non-major funds. Moving non-major funds with independent funding and personnel expenses: Parks, Public Safety/Police, and Transportation moved into major fund category  Citizen approval of Public Safety/Police sales tax (April 2023), new major fund (#42). o Restricted to public safety/police related purposes  Citizen approval of Marijuana Sales Tax (November 2023), non-major fund (#47) o Essential needs including storm-water related planning and repairs  Citizen approval of Use Tax (November 2023), non-major fund (#48) o Restricted to Transportation and Trails  Reserve Policy, no less than 5%, met for General Fund appropriations and no less than 90 days operations (25%) for Sewer Fund operations in order to provide cash flow and emergency cash funding (Res. 12-01-13)  The Fund Summary document is amended from the proposed presented materials on November 7, 2023 and reflects the two (2) new funds as well as corrections to formula miscalculations  As best practice, apply the same percentage reserve policy as the General Fund to other major funds by applying the percentage reserve to only the operating and personnel related expenses 2024 marks notable transfers out of the General Fund to continue to support departments originally placed in the General Fund, yet now have their own independent sales tax. They include: From General Fund to: Amount: Transportation $242,000 Park/Nature Sanctuary $426,000 Public Safety/Police Department $1,500,000 The 2025-2028 financial forecast continues these transfers, and are budgeted to increase for future years by 50% of the consumer price index (CPI). BALANCED BUDGET: The budget, as presented, is balanced and reflective of the action-based items previously discussed during strategic planning and work sessions in April, August, October and November. The budget has expenses totaling $13,513,420 (net of transfers), across all funds, allocated as follows: Page 3 of 10 The City Clerk has posted a budget summary for public viewing on the city’s website at: https://parkvillemo.gov/government/city-budget. Capital Improvement Plan: As a brief outline, the city continues to invest in infrastructure maintenance. Over the next five years, the budget proposes more than $10 million in CIP projects, with an additional $5 million in grant funding to address highway improvements – of which nearly $2.7 million is designated for 2024. The CIP proposes major public construction projects in the categories of General (Technology & Fleet), Parks, Nature Sanctuary, Transportation, Sanitary Sewer, and Police. The Community Land and Recreation Board (CLARB) reviewed the 2024-2028 CIP and related budget(s) on August 9th. The Planning and Zoning Commission on September 11th. The Board of Aldermen approved the CIP on October 17, 2023. This budget directs which major construction projects the city will undertake in fiscal year 2024. Moreover, the CIP is funded through several different operating and capital funds. Revenues for these funds come from multiple sources, including sales taxes, building fees, permits and transfers from other funds according to pre-established formulas or funding needs. An outline of the major project proposals for fiscal year 2024 include:  9 Highway Improvement(s): $7,000,000 (pending approval of Platte County Grant)  Farmers Market: $1,600,000 (pending approval of Platte County Grant, $1 million requested)  Platte Landing Park Pedestrian Bridge: $125,000  Police Substation (west location): $100,000  Police Annual Vehicle, Lease/Turnover: $50,000  Transportation: $380,000. Note: The Use Tax will provide approximately $50,000 additional dollars toward streets maintenance in 2024. New Total: $430,000  Sanitary Sewer (Pump/Lift Station, Treatment, Replacements): $709,000  Storm Sewer needs including repairs, and commence Assessment/Master Plan: $50,000 - $100,000  City Hall Maintenance/Improvements: $200,000 BUDGET FUND OVERVIEW and HIGHLIGHTS The budget includes six (6) major governmental funds, one (1) enterprise fund, and multiple non-major governmental/ special revenue funds. Major Governmental Funds:  General Fund: (#10), an unrestricted fund, which is the main operating fund of the City, finances departments, such as: Public Safety (Police), Public Works (Engineering and Construction Inspections), Community Development (Building Inspections and Code Enforcement), MIS/IT, Finance, Human Resources, City Clerk, Administration, and Board of Aldermen.  Transportation Sales Tax: (#40), the city’s half-percent transportation sales tax is restricted for transportation purposes, and a Platte County one-quarter percent tax distribution equivalent for capital improvements and related expenses.  Parks and Recreation: (#41), the city’s half-percent Park Sales Tax that is restricted for park related purposes.  Police Sales Tax/Public Safety: (#42), the city’s half-percent Public Safety Sales Tax that is restricted for police related purposes.  Capital Projects: (#95), is used to account for major capital improvement and significant maintenance projects.  Debt Service Funds, accounts for the accumulation of resources for payment of principal and interest on long- term obligations of the city. Non-major Governmental Funds/Special Revenue Funds:  Marijuana Sales Tax: (#47), to meet city essential needs including storm-water related planning and repairs.  Use Tax: (#48), restricted for transportation (80%) and trails (20%). Page 4 of 10  Parkville Nature Sanctuary (PNS): (#60), restricted for PNS use resulting from donation received from the Erik and Anna Andersen Trust (2006). Once proceeds are spent down (planned in 2025), PNS related expenses will be within the Parks and Recreation Fund.  Economic Development (ED)/Tourism: (#46), restricted for ED purposes including the related hotel-motel tax (in accordance with State law and development incentive terms).  ARPA: (#68), funding for financial relief has been received the final report issued. These funds will be used to address IT related equipment and services in 2024.  Others include: Emergency Reserve: (#50), Fewson Fund: (#45), and Veterans Memorial: (#66). Enterprise/Proprietary Fund: Sewer Fund: (#30), The Sewer Utility Enterprise Fund includes the city’s Wastewater Treatment Plant (WWTP), sewer pumping stations, meter services, billing and collections, and funds the maintenance under a proposed contract, new in 2024, with the Platte County Regional Sewer District (PCRSD), who will maintain the WWTP and all sewer infrastructure throughout the City. RESERVE POLICY The Reserve Policy, in accordance with Policy Number 100-06 (Resolution No. 12-01-13), has been met. It states: “…the general fund balance should be no less than 5% of general fund appropriations for the succeeding fiscal year”, and “The City will endeavor to grow a general fund balance of 15% of general fund appropriations for the succeeding fiscal year.” For the 2024 budget year, the General Fund reserve sits at 37% of expenditures. As a best practice, new in 2024, this same percentage policy is applied to other independent funds with operating and personnel related expenses and are also recipients of sales tax proceeds. General Fund Overview: Revenues: There are many revenues within the General Fund and they are in categories of Taxes: Property and Sales, Licenses, Permits, Franchise Fees, Court Revenues, and Miscellaneous/Other (including continued “Transfers In” from the Sewer Fund for the annual overhead allocation). Sales Tax Revenues in 2023 have outpaced the projected 5% growth, with the city experiencing, to date (9/2023), a 15% growth – 10% above projected – in sales tax. Much of this is attributed to local shopping, a positive pull-factor (Parkville attracts tourism/shoppers from outside the city), as well as continued growth of new retail development. It is noteworthy to mention Parkville is a major tourism destination with over 1 million visitors a year. Sales Taxes are distributed from the State of Missouri, Department of Revenue, to municipalities. Sales taxes are estimated at $1,703,000 and continue to reflect a strong growth of retail in Parkville. For 2024, Property Tax and Sales Tax revenues are estimated to rise, projecting an incremental 3% growth, all other revenues remain flat. Additionally, there are two revenue areas of interest, Court Revenue and Building Permits that require further explanation:  Court Revenue continues to decline. A 3-year history shows the regression in revenues of more than 50%. In 2023 the city reduced the revenue forecast by 10% from 2022, and 38% from 2021. This continued sharp decline in revenues appears to have levelled off, and the city has projected the 2024 revenue to remain flat at the same rate as 2023. It is important to note, this municipal service, which previously retained revenues consistent with expenses, has reversed its performance, mostly due to SB 572 / SB 5 (2015), which modified various provisions regarding municipal courts by limiting fines/fees and reduced penalties for lack of adherence. These mandates now place a burden on municipalities resulting in a liability to city finances. Page 5 of 10 While funded in 2024, the Board of Aldermen may wish to consider moving this service from city services to the state of Missouri, Circuit Court of Platte County, in 2025.  Building Permits declined in 2023 from a budget forecast of $420,000 to an estimated $200,000. The reason for the reduced amount is due to unexpected delay in development(s); however, those areas that were delayed are now moving forward. Areas such as Thousand Oaks (Plats 23/24), The Cliffs of Parkville (Platte 38), Sanctuary at Riss Lake, Woods at Creekside, and Creekside West Apartments have broken ground, or will do so soon. Accordingly, the projection for building permits is forecast to be $420,000 -- the same as 2023. Property Tax revenue is a source of revenue completely controlled by the City. Only the Mayor and Board of Aldermen has the authority to establish a property tax rate, as approved on August 29, 2023 via Ordinance #3195, and no other governmental unit may appropriate the funds for their own use. It includes real property, personal property (including vehicles, machinery, and equipment). Platte County collects the tax on behalf of Parkville as part of an inter-local agreement. These taxes are estimated at $1,467,000 (formerly $1,346,000) based on a mill levy of $.5983 (formerly .6097 in 2023) per $100 assessed valuation. Further, the General Levy is .4341, and the Temporary General Levy (ends 2026) is .1642. The temporary general levy was used to pay for capital purchases including the building of City Hall in 2007. Parkville’s property tax collection rate is 99-100%. The total taxable valuation of all property in the City of Parkville is $352,696,782, after BOE (formerly $353,531,980). Expenditures: Personnel It should come as no surprise that city staff continue to evolve and deliver high levels of performance for the community. The 2024 budget reflects our commitment to maintain public safety and stability while investing in creative and progressive strategies to recruit, reskill, and retain workers. City operations deliver critical services that are often taken for granted by providing, operating and overseeing our infrastructure, land management, code(s) enforcement, public safety, parks/quality of life, and more. A well-trained and qualified workforce is critical to achieving our strategic goals, and developing and maintaining valued services that impact the wellbeing, health and welfare of visitors and citizens of Parkville. Last year’s 2023 adopted budget included increased salaries for police positions, prior approved new positions, and current staff adjustments, to attract officers – and retain existing officers – in this very competitive market. The citizens validated the need to focus on the importance of public safety and in April 2023 approved a half-percent public safety sales tax for the Police Department, with collection commencing October 1, 2023. This now allows the city to meet the goal of being structurally balanced to provide organizational excellence that our citizens desire and expect. During strategic planning, the Mayor and Board of Aldermen continually expressed the desire for organizational excellence, pointing Parkville toward a strategic decision to set pay levels relative to our contiguous and competing northland markets of North Kansas City and Riverside (peers). Additionally, they shared concerns about increased costs of living, and the importance of Parkville remaining competitive by ensuring salaries and benefits are comparable within the region. The 2024 budget reflects the direction to Administration for “action over words” by continuing the developed plan instituted in 2023 that addresses these concerns. The 2024 budget addresses all positions within all departments***; however, of utmost importance was to address the highly competitive and sometimes unpredictable nature of Police Department positions/salaries. Consequently, the salary schedule now reflects a separate schedule for police department positions thereby providing a better range that relates specifically to these positions and provides leadership with tools to correlate pay by experience, education, and skillset. The new starting pay for a Police Officer is $62,400 – a $10,000 (20%) increase from 2023 at $52,700. Also, within the new Police Department classification by position schedule, there are five grades of positions within the Police Department, and there is a 20% differential between each grade. Both Classification Schedules reflect an 8% cost-of-living-adjustment (COLA) for every position in order to be in-line with our peers. It is important to state, while the frontline workforce was adjusted to meet 100% of the average minimums of Page 6 of 10 these communities; the Department Head classifications were adjusted to only 85% of the average minimums of these peer, northland communities in order to be financially sustainable. Also, the following table demonstrates how the city of Parkville has not kept pace, nor matched, cost of living needs: The budget also includes a compression adjustment strategy, which allows a 1% adjustment per year of experience – up to a maximum of 7% for 7 or more years of service. Another note of interest is the hourly entry wage that will increase from $17.00 to $18.36 for the City’s beginning entry positions. Increases also apply to part-time and seasonal workers. New Positions/Position Adjustments For 2024, there are no new positions proposed apart from hiring an in-house City Attorney as a full-time employee with a minimal impact to the budget as Legal/Professional Services have been reduced accordingly. There are no positions frozen, and there are no anticipated furloughs this coming year. Benefit Adjustments The 2024 budget includes another major change to the Local Area Government Employees Retirement System (LAGERS) by adjusting the 4% employee contributory element of the plan to non-contributory; meaning, the city will now be employer fully contributory, or employee non-contributory. You will recall in FY 2023 the city adjusted the benefit plan from L-12 (1.75) plan to the L-6 (2.0) plan. By going to non-contributory for employees, this evens the playing field in recruitment and retention of employees as our neighboring communities are already employee non-contributory. In due course, this increases the amount of take home pay received by employees. While the department budget requests calculated a 15% Employee Health benefit increase, the city saw an increase of 5.9% for our health care plans. This reduction is reflected in the adopted budget. (National Avg. 8.5% (Source: Aon) 2024 Salary and Benefits Overview  Cost of Living Adjustment: 8%  No annual merit increases, due to overall position adjustment(s)  LAGERS: Employee Non-contributory/City contributory (4%)  Employee Health Benefits: 5.9%  Positions address compression strategy: Adjust 1% per year of experience (up to 7%) Sustainability  No new FTE  Retail sales tax progression  Continued new business growth Operating Expenses: The 2024 General Fund budgeted expenses are $136,029 less than 2023. This is due to the transition of the Police Department to its own independent fund. Transfers from the General Fund account for 44% of the fund’s total expenses. Social Security Administration (SSA): COLA City of Parkville Annual Difference January 2022 -- 5.9% No COLA, 3% Merit 2.9% less than SSA adjustment January 2023 -- 8.7% 1.5% COLA, 2% Merit 5.2% less than SSA adjustment January 2024 -- 3.2% 8% COLA 4.8% more than SSA adjustment; Total 2022-2024 = 17.8% 14.5% 3.3% less than Total SSA adjustment Page 7 of 10 From General Fund to: Amount: Transportation $242,000 Park/Nature Sanctuary $426,000 Public Safety/Police Department $1,500,000 Total Transfers Out $2,168,000 Personnel related expenses account for 67% of General Fund expenses, after Transfers to other funds. Also included in the 2024 budget is the annual allocations to PACE: Parkville Area Chamber & EDC ($40,000), Northland Chamber ($350), and the Platte County Economic Development Council ($2,100) – all coming from the General Fund. It is noteworthy to mention that these are eligible expenses that could come from the city’s Economic Development/Tourism fund. Furthermore, in 2024, the Main Street Parkville Association will again receive $15,000 for the annual 4h of July fireworks, which is budgeted in the Economic Development/Tourism Fund. The General Fund still retains a healthy ending fund balance, and would be used to support the city should other revenue streams not come to fruition as planned, or an emergency situation occur. Emergency Reserve Fund In recent years, the Board had strategically grown reserves beyond the minimum target in order to prepare for development NID payments that have since been rectified; although there is still small support to debt service from other funds. With a transfer of $118,000, the city’s Emergency Reserve Fund balance remains at 25%, or $1,450,108 for 2024. Debt Service Fund Related debt service expenses, by fund, are centralized and listed, starting on page 86 of the proposed Adopted Budget. The total debt service is 12% of expenditures. The remaining debt service balance, as of December 31, 2024 will be $7,976,263. It is important to note that both Brush Creek Neighborhood Improvement District (NID) and Brink Meyer NID payments, are covered and paid for via a land purchase agreement worth $500,000 per year, and have zero net impact on the General Fund. Sewer Enterprise Fund The Board of Aldermen’s policy related to the Sewer fund is to maintain working capital equal to at least 90 days (25%) of operating expenses plus the current annual debt service payment, the 2024 Sewer Fund estimated ending fund balance of $529,005 is above the working capital target. The city provides utility services to both residential and non-residential customers within the southern portion of the city limits. Separately, to meet the minimum objectives of focusing on maintained public infrastructure, the proposed rates for sewer/wastewater services will increase 3% in 2024 or an approximate $57,000 increase in revenue – as previously discussed and planned by the Board of Aldermen. Based on the proposed rates, a customer with typical monthly flow of 5,000 gallons per month will experience an increase of $1.99 in their wastewater bill per month, or about $24 per year. Revenue in this fund remains slightly elevated due to the proposed rate increase. Of the total revenue of $2,587,505, $682,355 is the beginning fund balance rolling over from 2023. Debt Service: there is a debt service payment of $179,000 for Sewer Plant upgrades. The final payment will be in 2025, and is $31,350. The City had an agreement with Alliance Water Resources, Inc. to maintain our Waste Water Treatment Facility (WWTF). Annually, the city paid $330,631 for this service. For 2024, Platte County Regional Sewer District will assume responsibility Page 8 of 10 to maintain the city WWTF as well as related city infrastructure. The contract is currently being negotiated but is projected to be about $300,500/year. Contracting the maintenance of the WWTF and city infrastructure with PCRSD is part of an outlined plan to address the possibility of the City to transition and centralize services of Parkville residents within one service provider. NOTE: This will require a vote of Parkville citizens, and is projected to occur in either November 2024 or April 2025. The option to move in this direction is based upon the results of the commissioned Sewer/Wastewater Business Analysis Study that analyzed operational business practice and options for providing wastewater collection and treatment services. Those options include: a. Continued outsource of maintenance of facilities and infrastructure, b. Consider bringing maintenance of facilities and infrastructure in-house, c. Partner with Platte County Sewer District, d. Transition services to private sector. In future years, should the Board of Aldermen consider retaining ownership of the sewer system infrastructure and WWTF, Administration recommends the city commission an additional sewer/wastewater rate study regarding rate structure(s), as well as related administrative sewer services charges and expenditures of the utility system related to allocation. The deliverable will be to provide recommendations for proposed best business practices to meet the financial, administrative goals and objectives of consumers within the City. The primary objectives of a rate study include:  Full cost recovery (i.e. operating costs, debt and other expenditure requirements),  Cost-based rate structure,  Consistency with industry standards,  Equity among customer classes,  Administrative efficiency (i.e. easy to understand and implement), and  5-Year capital funding plan. Transportation Fund The Transportation Fund now contains all associated costs from the former Streets Department that was located in the General Fund. There is a General Fund transfer to the Transportation Fund in the amount of $243,000 to address those services and expenses handled by the Streets Department staff, yet are not directly transportation related costs i.e., the annual bulky item pick-up and other similar programs. Infrastructure has been a citywide focus - from citizens to the Board of Aldermen - for the past several years. In 2023, the city saw one of the phases of the Route 9 project, from Highway 45 to Lakeview Drive, mostly completed. The Transportation Budget is taking a big step in 2024 as we introduce a pavement management and preservation process; now expanded to include curbs and sidewalks. This will help the city leverage industry standards, expertise, artificial intelligence, and high definition streaming video to convey the condition of Parkville’s pavement in these areas. This report will help guide maintenance by determining the right treatment, to the right pavement, and at the right time – while maximizing annual maintenance dollars and extending the life of our roadway and related curbs and sidewalk network. Also of great assistance to the city of Parkville, was the passage of the Platte County Transportation one-quarter percent sales tax in November 2022. These allocations help ensure that basic funds are available for infrastructure maintenance needs. The 2024 budget includes $239,000 in estimated revenues from this source. Parks and Recreation, and Nature Sanctuary Fund The Parks and Recreation Fund now contains all appropriate revenues and expenditures along with 2024 personnel related expenses from the Nature Sanctuary; thus, the General Fund transfer is adjusted to include both allotted amounts totaling $426,000. Page 9 of 10 The overall total revenues, including the transfer is $2,716,920. This reflects a very positive performance of the half cent park sales tax of $975,000; along with the beginning fund balance of $1,277,920. Parks projects are outlined in the CIP, yet it is important to note the ending fund balance of 2024 is projected to be $1,221,920. This will allow for planning projects that will ultimately come from the renewal of Parks Master Plan scheduled to commence in January 2024. Also, in 2024, will be addressing the rebuilding of the Farmers Market. Much of this rebuild will be contingent upon the issuance of the pending Platte County Partnership Grant the city applied for in October 2023. Grant awards are expected in November/December 2023. Moreover, other projects, part of the 2023 budget and carried over to 2024 include: Gateway Park construction, Veterans Memorial planning at the new site near the Train Depot and Spirit Fountain, Train Depot building utilization, trail maintenance, and an automated facility reservation system. The Parkville Nature Sanctuary (PNS) projects will address the Boardwalk/Outlook area and the Sullivan Observation Deck. There will be small projects designated in 2025 that will complete the improvements that are being made as a result of the substantial donation received in 2006 from Erik and Anna Andersen. Police/Public Safety Sales Tax Fund In April 2023 the citizens of Parkville approved a one-half percent Public Safety sales tax to assist in funding the Parkville Police Department (PPD). With this approval, the 2024 budget reflects an independent fund, #42, that contains related revenues and expenses of the PPD. The sales tax is expected to generate approximately $966,000 with a beginning fund balance, due to collection commencement October 1, 2023, of $229,929. Also, as previously stated, the General Fund will transfer $1,500,000 that conveys slightly more than a 3-year average of actual police department expenses. Making available revenues $2,698,929. The majority of expenditures, 87%, are personnel related; currently, there are six (6) vacant positions within the department, and one (1) military leave position. The City and the Department have invested in expansive recruitment efforts in 2023, and plan to continue the push in 2024. Unfortunately, police officer vacancies are not a situation found solely in Parkville – it is nationwide. The Bureau of Justice states: “It is no secret that recruitment and retention are serious obstacles facing law enforcement today. The profession, by its very nature, challenges law enforcement professionals both physically and mentally. Society’s ever-changing nature, needs, and expectations add another complex layer to policing. In recent years, several significant events have led to rapid changes and shifts in community expectations of what people want from their police and other public servants. These changes and accompanying challenges have played a part in departments’ struggles to attract potential applicants to fill positions left vacant by retirement and to reduce or prevent the increasing number of resignations. Law enforcement is at a crossroads as more officers are leaving the field through resignation or retirement and fewer qualified applicants are considering policing as a career. Individual agencies must carefully examine how their mission, values, culture, and employees meet the changing needs of the communities they serve. As part of this, the profession must reconsider its current hiring and retention practices to modernize the workforce”. The PPD has been a proactive department for a number of years with the positive performance of a strong community policing program. Also, as previously addressed, personnel adjustments – raising starting pay for police officers from $52,700 to $62,400 – along with additional benefit enhancements, demonstrates that Parkville is a dynamic, enterprising, and progressive organization, and a true leader in the northland and regional Kansas City area for law enforcement professionals. Page 10 of 10 Economic Development Fund The Economic Development Fund generates revenues from a 5% per night guest room tax – mostly from the Creekside hotel. It is noteworthy to mention, per the terms of the Tax Increment Financing (TIF) agreement, that 50% of this revenue is conveyed to the developer, and of the 50% that comes to the city, an additional 75% of funds received are returned back to the developer for completed infrastructure related expenses. These expenses are associated and in accordance with the development agreement. The revenue from the fund, while appearing high, is mostly used to pay for those infrastructure costs, thereby leaving a small amount for advertising and Main Street’s 4th of July event. The Economic Development Fund is projected to have approximately $23,000 available in 2024. While there are numerous organizations that provide economic support to the city – and should be associated with this fund – only one (1) specific organization is receiving funds in the amount of a $15,000 allocation to the Main Street Parkville Association (MSPA) for annual fireworks on the 4th of July. All others are funded from the General Fund. Support of the July 4 fireworks display in 2024 will be the second year the City sponsors this event, and it was positively received by citizens in 2023. PLANNING FOR THE FUTURE: Plans and Projects With the passage of the Public Safety Sales Tax in April, and the Marijuana Sales Tax and Use Tax in November 2023, the citizens of Parkville have shared their focus of importance: these dollars will aid our Police Department, Trails, Transportation, and Storm-water: The Use Tax is restricted as follows: Transportation Capital Projects: 64% Transportation Maintenance: 16% Trails: 20% With certification of the Use Tax votes, the city projects collecting in January 2024. Immediate uses for these funds include two (2) projects:  Next phase of 9 Highway: Triangle/Main Street,  Sidewalks along Bell Road, and  Additional maintenance of the City’s roads. Immediate planning for these grants and coordination of streets maintenance is imminent as the city addresses our citizen’s desire for transportation improvements. CONCLUSION The total combined, recommended budget expenditures for fiscal year 2024 for all City personnel, operations, equipment, capital improvements and debt service is $13,513,420. This is the sum of 15 funds. I would like to thank the Mayor and Board of Aldermen, Leadership Team, and staff for their hard work and support while developing this budget. The leadership and administrative staff spent many hours working on related documents – and all within a new system – their assistance and willingness to move to this new system is commendable. I especially want to thank Bryan Kidney, Deputy City Administrator/Finance Director and Jeffery Rhodes, Assistant City Administrator, whose assistance and attention to detail has resulted in a fully informational and transparent budget document. The many hours of work they have undertaken to ensure the accuracy and completeness of this budget document is extraordinary – many thanks to this awesome Leadership Team! City of Parkville 2024 Operating Budget Adopted Budget Presented: November 21, 2023 Table of Contents 1.General Fund (10)………………………………………………………………………………………………………………………………………………………………………………………..Page 3 a.Forecast…………………………………………………………………………………………………………………………………………………………………………………………..Page 3 b.Financial Summary…………………………………………………………………………………………………………………………………………………………………………..Page 4 c.Revenues………………………………………………………………………………………………………………………………………………………………………………………...Page 5 d.Administration…………………………………………………………………………………………………………………………………………………………………………………Page 7 e.Police (2021-2023)…………………………………………………………………………………………………………………………………………………………………………..Page 9 f.Municipal Court……………………………………………………………………………………………………………………………………………………………………………….Page 11 g.Public Works……………………………………………………………………………………………………………………………………………………………………………………Page 12 h.Community Development………………………………………………………………………………………………………………………………………………………………..Page 13 i.Streets Department (2021-2022)……………………………………………………………………………………………………………………………………………………..Page 15 j.Parks Department (2021-2022)………………………………………………………………………………………………………………………………………………………..Page 17 k.Nature Sanctuary (2021-2022)………………………………………………………………………………………………………………………………………………………….Page 19 l.Public Information (PIO)……………………………………………………………………………………………………………………………………………………………………Page 20 m.Transfers Out…………………………………………………………………………………………………………………………………………………………………………………… Page 21 n.Information Technology (IT)………………………………………………………………………………………………………………………………………………………………Page 22 o.Capital Outlay…………………………………………………………………………………………………………………………………………………………………………………….Page 23 2.Sewer Services Fund (30)………………………………………………………………………………………………………………………………………………………………………………..Page 24 3.Transportation Fund (40)………………………………………………………………………………………………………………………………………………………………………………..Page 29 4.Parks Sales Tax Fun (41)………………………………………………………………………………………………………………………………………………………………………………….Page 35 5.Public Safety / Police Sales Tax Fund (42)………………………………………………………………………………………………………………………………………………………..Page 42 6.Fewson Fund (45)……………………………………………………………………………………………………………………………………………………………………………………………Page 47 7.Economic Development / Tourism Fund (46)………………………………………………………………………………………………………………………………………………….Page 51 8.Marijuana Sales Tax Fund (47) – New in 2024…………………………………………………………………………………………………………………………………………………Page 55 9.Use Tax Fund (48) – New in 2024……………………………………………………………………………………………………………………………………………………………………Page 59 10.Emergency Reserve Fund (50)………………………………………………………………………………………………………………………………………………………………………..Page 63 11.Parkville Nature Sanctuary Fund (60)……………………………………………………………………………………………………………………………………………………………..Page 65 12.Parkville Veterans Memorial Fund (66)…………………………………………………………………………………………………………………………………………………………..Page 71 13.American Rescue Plan Act (ARPA) Fund (68)…………………………………………………………………………………………………………………………………………………..Page 75 14.Capital Projects Fund (95)……………………………………………………………………………………………………………………………………………………………………………….Page 80 15.Debt Service Summary……………………………………………………………………………………………………………………………………………………………………………………Page 86 16.Temporary Special Levy / Certificates of Participation (COPs) Fund (22)…………………………………………………………………………………………………………Page 88 17.Brush Creek NID Debt Service Fund (23)…………………………………………………………………………………………………………………………………………………………Page 92 18.Brink Meyer NIC Debt Service Fund (24)…………………………………………………………………………………………………………………………………………………………Page 96 19.Capital Projects / Highway 9 Debt Service Fund (96)……………………………………………………………………………………………………………………………………….Page 100 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Property Taxes 1,475,441$ 1,560,000$ 1,624,400$ 1,740,000$ 1,812,000$ 1,890,000$ 1,973,000$ 2,060,000$ Licenses 66,279 76,800 73,900 80,400 81,000 81,000 81,000 81,000 Permits 480,504 505,300 304,800 518,000 505,000 505,000 505,000 505,000 Franchise 894,394 898,000 885,000 940,000 902,000 908,000 914,000 914,000 Sales Tax 1,437,419 1,452,000 1,653,000 1,703,000 1,751,270 1,800,988 1,852,198 1,904,944 Other 37,417 - - - - - - - Court 47,578 41,000 24,400 25,000 25,000 25,000 25,000 25,000 Interest 71,800 13,000 100,300 95,500 95,500 95,500 95,500 95,500 Miscellaneous 882,327 570,000 627,000 513,000 520,000 640,000 640,000 640,000 Grant 32,750 33,000 - - - - - - Transfers 667,436 860,500 860,500 370,000 185,000 92,500 46,250 23,125 Total Revenues 6,093,345 6,009,600 6,153,300 5,984,900 5,876,770 6,037,988 6,131,948 6,248,569 Administration 1,865,544 1,733,968 1,733,968 1,873,000 1,929,190 1,987,066 2,046,678 2,108,078 Police 1,555,264 2,002,650 2,002,650 - Court 132,456 163,379 163,379 173,000 50,000 51,500 53,045 54,636 Public Works 334,603 289,440 289,440 433,000 445,990 459,370 473,151 487,345 Community Development 383,943 493,959 493,959 578,000 595,340 613,200 631,596 650,544 Streets 528,174 Parks 487,653 Nature Sanctuary 69,785 Public Information 34,204 35,660 35,660 49,000 50,470 51,984 53,544 55,150 Transfers Out - 935,575 935,575 2,578,000 2,537,340 2,613,460 2,691,864 2,772,620 Information Technology 73,311 98,304 98,304 194,000 199,820 205,815 211,989 218,349 Capital Outlay 141,323 261,094 261,094 - - - - - Total Expenditures 5,606,260 6,014,029 6,014,029 5,878,000 5,808,150 5,982,395 6,161,866 6,346,722 Increase (decrease)487,085 (4,429) 139,271 106,900 68,620 55,594 (29,919) (98,154) Beginning Fund Balance 1,458,401 1,945,486 1,945,486 2,084,757 2,191,657 2,260,277 2,315,871 2,285,952 Ending Fund Balance 1,945,486 1,941,057 2,084,757 2,191,657 2,260,277 2,315,871 2,285,952 2,187,798 Reserve Fund Balance %35%32%35%37%39%39%37%34% Plus: Emergency Fund Balance 1,332,108 1,332,108 1,332,109 1,450,108 1,450,108 1,450,108 1,450,108 1,450,108 Total Fund Balance 3,277,594$ 3,273,165$ 3,416,866$ 3,641,765$ 3,710,385$ 3,765,979$ 3,736,060$ 3,637,906$ City of Parkville, Missouri General Fund (10) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Moved to Parkville Nature Sanctuary - Fund 60 Expenditures Revenues Moved to Public Safety Sales Tax - Fund 42 Moved to Transportation Sales Tax - Fund 40 Moved to Parks Sales Tax - Fund 41 Department M:\Budgets\2024\working folder\Financial forecast\10 general fund 11.13.23_FINAL 11/14/2023 3 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TAXES 1,402,592 1,475,442 1,560,000 1,658,897 1,624,400 1,740,000 1,740,000 LICENSES 70,583 66,279 76,800 62,365 73,900 80,400 80,400 PERMITS 518,981 480,504 505,300 243,933 304,800 518,000 518,000 FRANCHISE FEES 812,268 894,393 898,000 570,106 885,000 940,000 940,000 SALES TAXES 1,259,956 1,437,419 1,452,000 1,280,621 1,653,000 1,703,000 1,703,000 OTHER REVENUE 30,885 37,417 0 0 0 0 0 COURT REVENUE 66,310 47,578 41,000 23,015 24,400 25,000 25,000 INTEREST INCOME 5,531 71,799 13,000 36,580 100,300 95,500 95,500 MISCELLANEOUS REVENUE 306,884 915,076 603,000 596,761 627,000 513,000 513,000 TRANSFERS IN 566,200 667,436 860,500 770,375 860,500 370,000 370,000 TOTAL REVENUES 5,040,191 6,093,343 6,009,600 5,242,653 6,153,300 5,984,900 5,984,900 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY ADMINISTRATION 1,817,537 1,865,544 1,733,968 1,218,752 1,733,968 1,873,000 1,873,000 POLICE 1,453,788 1,555,264 2,002,650 1,150,288 2,002,650 0 0 MUNICIPAL COURT 127,785 132,456 163,379 98,853 163,379 173,000 173,000 PUBLIC WORKS 284,998 334,603 289,440 212,085 289,440 433,000 433,000 COMMUNITY DEVELOPMENT 344,954 383,943 493,959 360,336 493,959 578,000 578,000 STREET DEPARTMENT 494,323 528,174 0 0 0 0 0 PARKS DEPARTMENT 436,432 487,653 0 0 0 0 0 NATURE SANCTUARY 58,549 69,785 0 0 0 0 0 PUBLIC INFORMATION 34,293 34,204 35,660 14,807 35,660 49,000 49,000 TRANSFERS OUT 0 0 935,575 773,325 935,575 2,578,000 2,578,000 INFORMATION TECHNOLOGY 75,281 73,311 98,304 85,669 98,304 194,000 194,000 CAPITAL OUTLAY 160,868 141,323 261,094 123,115 261,094 0 0 TOTAL EXPENDITURES 5,288,806 5,606,260 6,014,029 4,037,230 6,014,029 5,878,000 5,878,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES ( 248,615) 487,083 ( 4,429) 1,205,423 139,271 106,900 106,900 =========== =========== =========== =========== =========== ============ ============ 4 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TAXES 41001-00 Real & Personal Property Tax 1,194,935 1,264,069 1,346,000 1,409,728 1,409,000 1,500,000 1,500,000 41002-00 Penalties 4,298 4,632 6,000 7,359 7,400 7,000 7,000 41003-00 Corp Merchants & Manufacturing 172,306 174,394 175,000 208,515 175,000 200,000 200,000 41004-00 Financial Institution Tax 3 126 0 25 0 0 0 41005-00 Vehicle Tax 31,050 32,220 33,000 33,270 33,000 33,000 33,000 TOTAL TAXES 1,402,592 1,475,442 1,560,000 1,658,897 1,624,400 1,740,000 1,740,000 LICENSES 41101-00 Dog License (Tags)2,285 1,840 2,000 870 1,000 1,000 1,000 41102-00 Occupational License 49,519 39,508 50,000 30,328 43,000 50,000 50,000 41102-02 Late Fees on Occ Licenses 0 0 0 213 0 0 0 41103-00 Peddler's Licenses 1,450 200 500 850 500 1,000 1,000 41104-00 Liquor Licenses 14,510 21,311 21,000 26,629 26,000 25,000 25,000 41105-00 Golf Cart Registration Fees 2,820 3,420 3,300 3,630 3,400 3,400 3,400 41111-00 Credit Card Processing Fees 0 0 0 ( 154) 0 0 0 TOTAL LICENSES 70,583 66,279 76,800 62,365 73,900 80,400 80,400 PERMITS 41201-00 Building Permits 455,921 410,815 420,000 162,126 200,000 420,000 420,000 41201-01 Occupancy Permit 2,175 2,425 3,000 1,150 2,000 3,000 3,000 41202-00 Sign Permits 1,900 2,025 2,000 2,210 2,200 2,000 2,000 41205-00 Development Permits 2,925 3,755 3,000 1,625 2,000 3,000 3,000 41205-01 CD-Public Improvement Fees 34,909 15,599 20,000 11,223 15,000 20,000 20,000 41205-03 PW-Public Improv Fees 12,942 29,024 50,000 34,363 50,000 50,000 50,000 41206-00 Rezoning Permits 300 900 1,000 1,000 1,000 1,000 1,000 41207-00 Subdivision Permit Fees 5,175 1,470 2,000 1,615 1,600 2,000 2,000 41208-00 BZA-Application Fees 300 0 0 0 0 0 0 41209-00 Conditional Use Permits 300 1,900 1,300 700 1,000 1,000 1,000 41210-00 Grading/PW Use Permits 295 580 1,000 0 0 1,000 1,000 41210-01 Right of Way Permit Fees 1,840 12,011 2,000 27,920 30,000 15,000 15,000 TOTAL PERMITS 518,981 480,504 505,300 243,933 304,800 518,000 518,000 FRANCHISE FEES 41301-00 Telecom Franchise 93,379 73,684 85,000 52,343 70,000 75,000 75,000 41302-00 Spire 112,546 179,400 200,000 202,702 210,000 215,000 215,000 41303-00 Missouri American Water 117,125 132,946 127,000 90,312 135,000 140,000 140,000 41304-00 Evergy 422,219 441,652 444,000 177,173 400,000 450,000 450,000 41306-00 Cable/Video Service Franchise 66,999 66,712 42,000 47,578 70,000 60,000 60,000 TOTAL FRANCHISE FEES 812,268 894,393 898,000 570,106 885,000 940,000 940,000 5 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ SALES TAXES 41401-00 Sales Tax-General Revenue 1,172,035 1,351,046 1,359,000 1,198,286 1,560,000 1,609,000 1,609,000 41402-00 Motor Vehicle Sales Tax 60,570 58,589 67,000 56,816 67,000 68,000 68,000 41403-00 Motor Vehicle Fee 27,351 27,784 26,000 25,520 26,000 26,000 26,000 TOTAL SALES TAXES 1,259,956 1,437,419 1,452,000 1,280,621 1,653,000 1,703,000 1,703,000 OTHER REVENUE 41501-00 Farmers Market 1,230 1,267 0 0 0 0 0 41504-00 Park Shelter Reservations 15,000 12,565 0 0 0 0 0 41504-01 Sports Fields Reservations 2,840 5,130 0 0 0 0 0 41504-02 Special Event Reservations 11,815 18,455 0 0 0 0 0 TOTAL OTHER REVENUE 30,885 37,417 0 0 0 0 0 COURT REVENUE 41601-00 Fines 63,181 44,307 38,000 19,947 20,000 25,000 25,000 41602-00 CVC Reports 124 131 0 53 100 0 0 41603-00 Police Reports 3,005 3,140 3,000 3,015 4,300 0 0 TOTAL COURT REVENUE 66,310 47,578 41,000 23,015 24,400 25,000 25,000 INTEREST INCOME 41701-00 Interest Income 4,623 8,323 8,000 22,104 25,000 25,000 25,000 41702-00 Marketplace CID Admin Fee 908 1,036 1,000 770 1,000 1,000 1,000 41703-00 Marketplace TIF Admin Fee 0 2,441 1,000 1,394 2,400 1,000 1,000 41704-00 Creekside CID Admin Fee 0 1,175 1,000 1,286 1,200 1,000 1,000 41705-00 Creekside TDD Admin Fee 0 1,175 1,000 1,286 1,200 1,000 1,000 41706-00 Creekside TIF Admin Fee 0 57,650 1,000 1,964 58,000 55,000 55,000 41707-00 Creekside Surplus Pilots 0 0 0 7,774 11,500 11,500 11,500 TOTAL INTEREST INCOME 5,531 71,799 13,000 36,580 100,300 95,500 95,500 MISCELLANEOUS REVENUE 41801-00 Miscellaneous Revenue 75,498 24,207 100,000 3,994 25,000 50,000 50,000 41801-02 Meeting Videos 0 0 0 1,709 0 0 0 41802-00 Leased/Owned Properties 70,551 60,881 68,000 56,415 68,000 61,000 61,000 41803-99 FEMA Flood Reparations 63,294 0 0 105,293 105,000 0 0 41804-05 Stormwater Grant 50,061 0 0 0 0 0 0 41804-09 Other Grants 10,820 32,750 33,000 0 0 0 0 41805-00 Sale of Vehicles/Equipment 36,660 2,180 2,000 3,040 3,000 2,000 2,000 41807-01 Insurance Claim Reimb.0 268,704 0 26,311 26,000 0 0 41809-01 Land Sales 0 526,355 400,000 400,000 400,000 400,000 400,000 TOTAL MISCELLANEOUS REVENUE 306,884 915,076 603,000 596,761 627,000 513,000 513,000 TRANSFERS IN 41901-00 Transfer f Transportation Fund 175,000 225,000 0 0 0 0 0 41903-00 Sewer Administration Fee 350,000 350,000 360,500 270,375 360,500 370,000 370,000 41911-00 Tfr from Park Sales Tax Fund 41,200 92,436 0 0 0 0 0 41914-00 TRSF TO GF FROM ARPA 0 0 500,000 500,000 500,000 0 0 TOTAL TRANSFERS IN 566,200 667,436 860,500 770,375 860,500 370,000 370,000 TOTAL REVENUES 5,040,191 6,093,343 6,009,600 5,242,653 6,153,300 5,984,900 5,984,900 =========== =========== =========== =========== =========== ============ ============ 6 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund ADMINISTRATION EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 501.01-01-00 Salaries 421,287 489,281 553,000 416,924 553,000 836,000 836,000 501.01-03-00 Overtime 69 936 0 1,146 0 10,000 10,000 501.01-11-00 Mayor and Aldermen 57,602 59,817 58,752 42,301 58,752 58,000 58,000 501.01-21-00 FICA & Medicare 34,068 40,146 47,000 34,447 47,000 64,000 64,000 501.01-22-00 Retirement 49,732 47,927 79,000 63,016 79,000 156,000 156,000 501.01-32-00 Exp Allowance-Bd of Alde 0 (45)0 0 0 0 0 501.01-33-00 Auto Allowance 1,800 3,050 1,836 3,000 1,836 0 0 501.01-40-00 Membership Fees & Dues - 1,235 6,151 5,000 5,278 5,000 6,000 6,000 501.01-41-00 Membership Fees & Dues - 2,722 3,969 5,000 3,278 5,000 7,000 7,000 501.01-41-02 Professional Dev - Staff 6,561 10,783 20,000 8,584 20,000 30,000 30,000 501.01-41-03 Professional Dev - Board 352 22,194 30,000 19,427 30,000 20,000 20,000 501.01-43-00 Tuition Reimbursement 0 0 10,000 1,500 10,000 14,000 14,000 TOTAL PERSONNEL 575,426 684,208 809,588 598,900 809,588 1,201,000 1,201,000 INSURANCE 501.02-01-00 Liability Insurance 117,917 122,296 140,000 128,434 140,000 175,000 175,000 501.02-01-01 Insurance Deductible 8,818 11,104 20,000 500 20,000 25,000 25,000 501.02-02-00 Health, Life & Dental 49,317 41,359 67,000 43,967 67,000 66,000 66,000 501.02-03-00 Workers Compensation 3,415 1,045 1,020 3,309 1,020 5,000 5,000 501.02-04-00 Unemployment 2,406 0 0 0 0 0 0 501.02-05-00 Property Insurance 19,879 21,446 25,000 33,480 25,000 0 0 501.02-33-00 Auto Allowance 0 0 0 0 0 20,000 20,000 TOTAL INSURANCE 201,752 197,251 253,020 209,690 253,020 291,000 291,000 UTILITIES 501.03-01-00 Telephone & Voicemail 5,493 5,712 6,000 5,662 6,000 6,000 6,000 501.03-02-00 Electricity 64,303 54,416 50,000 41,535 50,000 50,000 50,000 501.03-04-00 Water 5,863 5,958 5,000 4,841 5,000 5,000 5,000 501.03-05-00 Mobile Phones & Pagers 314 120 500 60 500 1,000 1,000 501.03-07-00 Train Depot Utilities 0 0 0 0 0 10,000 10,000 501.03-08-00 Cable 2,582 2,517 4,500 755 4,500 3,000 3,000 501.03-09-00 Trash Hauling/Recycling 690 300 500 225 500 1,000 1,000 TOTAL UTILITIES 79,245 69,024 66,500 53,077 66,500 76,000 76,000 CAPITAL EXPENDITURES 501.04-22-00 Lease Purchase-Office Eq 495 896 660 495 660 1,000 1,000 501.04-51-00 Facility Improvements ( 100) 0 0 0 0 0 0 TOTAL CAPITAL EXPENDITURES 395 896 660 495 660 1,000 1,000 OTHER PURCHASES 501.05-01-00 Office Supplies & Consum 4,347 4,661 5,000 4,751 5,000 5,000 5,000 501.05-02-00 Postage 1,156 1,031 1,500 878 1,500 2,000 2,000 501.05-03-00 Computer Equip/Access/Pr 0 63 0 0 0 0 0 501.05-04-00 Printing 1,199 1,501 200 335 200 1,000 1,000 501.05-05-00 Publications 68 171 250 412 250 1,000 1,000 7 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund ADMINISTRATION EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ 501.05-20-00 Small Office Equipment 0 (32) 0 0 0 0 0 TOTAL OTHER PURCHASES 6,769 7,395 6,950 6,377 6,950 9,000 9,000 MAINTENANCE 501.06-01-00 Building Maint & Repair 18,475 16,704 25,000 19,785 25,000 25,000 25,000 501.06-01-01 HVAC Maintenance & Repai 5,117 8,394 10,000 4,022 10,000 10,000 10,000 501.06-02-00 Janitorial Services/Supp 10,739 14,962 15,000 11,628 15,000 15,000 15,000 501.06-02-01 Carpet Cleaning & Rug Se 111 0 0 0 0 0 0 501.06-11-00 Train Depot Maint 5,396 314 0 1,299 0 0 0 501.06-34-00 Office Equipment Mainten 1,656 2,275 1,500 947 1,500 2,000 2,000 TOTAL MAINTENANCE 41,494 42,649 51,500 37,682 51,500 52,000 52,000 CITY SERVICES 501.07-01-00 Elections 10,497 5,126 12,000 4,339 12,000 5,000 5,000 501.07-02-00 Advertising/Public Notic 1,969 956 1,000 0 1,000 1,000 1,000 501.07-04-00 Credit Card Processing F 331 19 0 0 0 0 0 501.07-99-00 FOPAS - Animal Control 6,000 6,000 6,000 6,000 6,000 6,000 6,000 TOTAL CITY SERVICES 18,796 12,101 19,000 10,339 19,000 12,000 12,000 PROFESSIONAL FEES 501.08-01-00 Attorney/Legal Fees 78,371 106,280 165,000 47,125 165,000 15,000 15,000 501.08-01-01 Litigation (New)303,332 82,079 75,000 27,023 75,000 30,000 30,000 501.08-02-00 Auditor Fees 18,800 27,250 20,000 0 20,000 45,000 45,000 501.08-02-02 Professional Services 114,561 139,804 180,000 179,164 180,000 90,000 90,000 501.08-02-03 Professional Svcs-Creeks 0 75,706 30,000 24,464 30,000 0 0 501.08-03-00 Engineering & Planning F 0 3,131 0 0 0 0 0 TOTAL PROFESSIONAL FEES 515,065 434,249 470,000 277,775 470,000 180,000 180,000 OTHER EXPENDITURES 501.09-01-00 Festivals & Events 196 120 0 8,116 0 10,000 10,000 501.09-04-00 Holiday Decorations 820 598 15,000 489 15,000 15,000 15,000 501.09-11-00 Cemetery Maintenance 5,655 4,997 5,000 4,565 5,000 5,000 5,000 501.09-13-00 Hiring Expenses 523 1,258 2,500 777 2,500 3,000 3,000 501.09-20-02 Meeting Food 2,035 4,302 3,000 2,308 3,000 2,000 2,000 501.09-20-07 Meeting Supplies 270 950 750 1,770 750 1,000 1,000 501.09-21-00 Misc-Other 7,187 16,639 12,000 3,337 12,000 0 0 501.09-21-02 Contingency 0 0 10,000 0 10,000 0 0 501.09-21-03 Employee Appreciation 2,488 1,371 6,000 3,054 6,000 15,000 15,000 501.09-25-00 Flood Management 0 94,672 2,500 0 2,500 0 0 TOTAL OTHER EXPENDITURES 19,174 124,906 56,750 24,416 56,750 51,000 51,000 TRANSFERS-OTHER SOURCES 501.20-26-00 Tfr to BC NID Bond Debt 112,357 60,881 0 0 0 0 0 501.20-27-00 Tfr to BM NID Bond Debt 247,063 231,982 0 0 0 0 0 TOTAL TRANSFERS-OTHER SOURCES 359,420 292,863 0 0 0 0 0 TOTAL ADMINISTRATION 1,817,537 1,865,544 1,733,968 1,218,752 1,733,968 1,873,000 1,873,000 8 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund POLICE EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 505.01-01-00 Salaries 933,199 993,428 1,250,000 693,991 1,250,000 0 0 505.01-03-00 Overtime 27,471 46,690 40,000 49,204 40,000 0 0 505.01-21-00 FICA & Medicare 69,816 77,378 96,000 55,551 96,000 0 0 505.01-22-00 Retirement 125,651 131,248 207,000 132,459 207,000 0 0 505.01-41-00 Membership Fees & Dues 705 450 950 490 950 0 0 505.01-41-02 Professional Development 3,851 3,177 4,500 580 4,500 0 0 505.01-43-00 Tuition Reimbursement 2,625 3,375 0 1,500 0 0 0 TOTAL PERSONNEL 1,163,318 1,255,746 1,598,450 933,774 1,598,450 0 0 INSURANCE 505.02-02-00 Health, Life & Dental 150,104 141,665 205,000 105,423 205,000 0 0 505.02-03-00 Workers Compensation 69,721 85,825 80,000 49,562 80,000 0 0 TOTAL INSURANCE 219,825 227,490 285,000 154,985 285,000 0 0 UTILITIES 505.03-01-00 Telephone & Voicemail 1,881 2,378 2,000 817 2,000 0 0 505.03-05-00 Mobile Phone & Pagers 2,189 1,583 4,500 1,696 4,500 0 0 TOTAL UTILITIES 4,070 3,961 6,500 2,513 6,500 0 0 OTHER PURCHASES 505.05-01-00 Office Supplies & Consum 2,328 1,748 2,800 1,832 2,800 0 0 505.05-02-00 Postage 100 152 250 103 250 0 0 505.05-04-00 Printing 141 416 750 0 750 0 0 505.05-20-00 Small Office Equipment 173 0 1,000 50 1,000 0 0 505.05-21-00 Equipment and Handtools 9,817 5,478 10,000 3,910 10,000 0 0 505.05-22-01 Terminal - Rejis 2,113 2,032 4,000 1,699 4,000 0 0 505.05-22-02 Terminal - Platte Co 2,266 2,266 2,700 2,266 2,700 0 0 505.05-31-00 Uniforms 3,365 3,459 7,000 1,654 7,000 0 0 505.05-99-00 Other Purchases 0 75 500 0 500 0 0 TOTAL OTHER PURCHASES 20,303 15,626 29,000 11,513 29,000 0 0 MAINTENANCE 505.06-21-00 Vehicle Repair & Mainten 13,727 17,598 20,000 12,618 20,000 0 0 505.06-21-01 Equipment Repair & Maint 3,086 2,947 5,000 2,040 5,000 0 0 505.06-22-00 Vehicle Gas & Oil 24,555 28,598 45,000 28,217 45,000 0 0 505.06-32-02 Crimestar Maintenance 1,500 1,750 1,750 0 1,750 0 0 505.06-34-00 Office Equipment/Mainten 384 422 900 0 900 0 0 TOTAL MAINTENANCE 43,252 51,316 72,650 42,874 72,650 0 0 9 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund POLICE EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CITY SERVICES 505.07-56-00 Hiring Expenses 1,129 240 3,500 2,031 3,500 0 0 505.07-57-00 Crime Commission 500 500 1,000 1,000 1,000 0 0 505.07-81-00 Lab Work 869 0 2,000 934 2,000 0 0 505.07-90-00 Contractual Service Agre 360 385 2,000 488 2,000 0 0 505.07-99-00 Other City Services 0 0 700 0 700 0 0 TOTAL CITY SERVICES 2,858 1,125 9,200 4,454 9,200 0 0 OTHER EXPENDITURES 505.09-21-00 Miscellaneous 162 0 350 174 350 0 0 505.09-21-04 Harvester Deer Donation 0 0 1,500 0 1,500 0 0 TOTAL OTHER EXPENDITURES 162 0 1,850 174 1,850 0 0 TRANSFERS-OTHER SOURCES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL POLICE 1,453,788 1,555,264 2,002,650 1,150,288 2,002,650 0 0 10 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund MUNICIPAL COURT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 510.01-01-00 Salaries 48,803 51,131 69,000 37,309 69,000 65,000 65,000 510.01-03-00 Overtime 379 1,118 1,000 1,280 1,000 2,000 2,000 510.01-11-00 Judge 18,000 18,692 18,000 13,154 18,000 18,000 18,000 510.01-21-00 FICA & Medicare 5,386 5,794 5,000 4,042 5,000 6,000 6,000 510.01-22-00 Retirement 6,681 6,581 10,000 6,434 10,000 14,000 14,000 510.01-32-00 Expense Allow - Judge 540 585 540 405 540 1,000 1,000 510.01-41-00 Memberships, Fees & Dues 0 0 300 60 300 600 600 510.01-41-02 Professional Development 1,597 3,775 5,000 3,670 5,000 7,000 7,000 510.01-42-00 Membership Fees 40 0 0 0 0 0 0 510.01-51-00 Prosecutor/Assistant 15,000 15,000 15,000 8,750 15,000 15,000 15,000 510.01-51-02 Public Defender 7,200 7,200 7,200 5,400 7,200 8,000 8,000 TOTAL PERSONNEL 103,627 109,876 131,040 80,504 131,040 136,600 136,600 INSURANCE 510.02-02-00 Health, Life & Dental 11,473 11,668 12,000 9,858 12,000 13,000 13,000 510.02-03-00 Workers Compensation 859 1,058 1,000 607 1,000 1,000 1,000 TOTAL INSURANCE 12,332 12,726 13,000 10,466 13,000 14,000 14,000 UTILITIES 510.03-05-00 Mobile Phone & Pagers 120 120 120 120 120 200 200 TOTAL UTILITIES 120 120 120 120 120 200 200 CAPITAL EXPENDITURES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL OTHER PURCHASES 510.05-01-00 Office Supplies & Consum 99 395 500 0 500 1,000 1,000 510.05-02-00 Postage 115 93 100 122 100 200 200 510.05-04-00 Printing 1,388 0 1,000 0 1,000 1,000 1,000 510.05-05-00 Publications 478 521 500 574 500 1,000 1,000 TOTAL OTHER PURCHASES 2,080 1,009 2,100 696 2,100 3,200 3,200 MAINTENANCE 510.06-33-00 Software Support Agreeme 2,907 1,454 2,769 3,053 2,769 3,000 3,000 510.06-34-00 Office Equipment Mainten 425 567 700 904 700 1,000 1,000 TOTAL MAINTENANCE 3,332 2,020 3,469 3,957 3,469 4,000 4,000 CITY SERVICES 510.07-80-00 Boarding of Prisoners 0 0 5,000 0 5,000 5,000 5,000 510.07-82-00 Bailiff 5,761 6,362 7,500 3,111 7,500 8,000 8,000 510.07-82-01 Translator 278 249 650 0 650 1,000 1,000 TOTAL CITY SERVICES 6,039 6,610 13,150 3,111 13,150 14,000 14,000 OTHER EXPENDITURES 255 94 500 0 500 1,000 1,000 510.09-21-00 Miscellaneous TOTAL OTHER EXPENDITURES 255 94 500 0 500 1,000 1,000 TOTAL MUNICIPAL COURT 127,785 132,456 163,379 98,853 163,379 173,000 173,000 11 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund PUBLIC WORKS EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 515.01-01-00 Salaries 194,967 216,045 136,510 127,061 136,510 231,000 231,000 515.01-21-00 FICA & Medicare 13,947 16,141 10,000 9,470 10,000 18,000 18,000 515.01-22-00 Retirement 14,640 15,092 19,000 16,652 19,000 43,000 43,000 515.01-33-00 Auto Allow-Public Wks Di 3,000 3,250 3,000 1,750 3,000 3,000 3,000 515.01-41-00 Membership Fees & Dues 430 772 830 0 830 2,000 2,000 515.01-41-02 Professional Development 2,702 5,438 4,500 416 4,500 9,000 9,000 515.01-42-00 Membership Fees 355 0 0 0 0 0 0 TOTAL PERSONNEL 230,041 256,737 173,840 155,350 173,840 306,000 306,000 INSURANCE 515.02-02-00 Health, Life & Dental 31,893 36,043 36,000 24,046 36,000 40,000 40,000 515.02-03-00 Workers Compensation 1,711 2,094 2,000 1,188 2,000 3,000 3,000 TOTAL INSURANCE 33,604 38,137 38,000 25,234 38,000 43,000 43,000 UTILITIES 515.03-01-00 Telephone & Voicemail 141 46 0 0 0 0 0 515.03-05-00 Mobile Phones & Pagers 659 686 850 666 850 1,000 1,000 TOTAL UTILITIES 799 733 850 666 850 1,000 1,000 CAPITAL EXPENDITURES 515.04-01-00 Vehicle 0 38 0 (38)0 0 0 515.04-21-00 Office Equipment 0 0 0 57 0 0 0 TOTAL CAPITAL EXPENDITURES 0 38 0 19 0 0 0 OTHER PURCHASES 515.05-01-00 Office Supplies & Consum 65 540 850 267 850 1,000 1,000 515.05-02-00 Postage 50 87 150 28 150 1,000 1,000 515.05-04-00 Printing 21 246 150 19 150 500 500 515.05-31-00 Uniforms 180 238 600 0 600 500 500 TOTAL OTHER PURCHASES 316 1,111 1,750 314 1,750 3,000 3,000 MAINTENANCE 515.06-36-00 Tornado Siren 4,577 5,238 5,500 3,418 5,500 5,500 5,500 TOTAL MAINTENANCE 4,577 5,238 5,500 3,418 5,500 5,500 5,500 CITY SERVICES 515.07-43-00 Spring/Fall Cleanup 0 0 0 1,065 0 28,500 28,500 TOTAL CITY SERVICES 0 0 0 1,065 0 28,500 28,500 PROFESSIONAL FEES 515.08-01-01 Construction Observation 0 0 0 3,265 0 0 0 515.08-03-00 Engineer & Planning Fees 15,550 31,528 40,000 21,816 40,000 45,000 45,000 TOTAL PROFESSIONAL FEES 15,550 31,528 40,000 25,081 40,000 45,000 45,000 OTHER EXPENDITURES 110 1,082 29,500 939 29,500 1,000 1,000 515.09-21-00 Miscellaneous TOTAL OTHER EXPENDITURES 110 1,082 29,500 939 29,500 1,000 1,000 TOTAL PUBLIC WORKS 284,998 334,603 289,440 212,085 289,440 433,000 433,000 12 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund COMMUNITY DEVELOPMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 518.01-01-00 Salaries 245,475 260,827 328,434 246,177 328,434 378,000 378,000 518.01-03-00 Overtime 0 137 500 0 500 1,000 1,000 518.01-21-00 FICA & Medicare 17,972 19,750 25,000 18,653 25,000 29,000 29,000 518.01-22-00 Retirement 25,718 27,012 47,000 36,179 47,000 70,000 70,000 518.01-31-00 Auto Allowance - CD Dire 2,400 2,600 2,400 1,800 2,400 2,500 2,500 518.01-41-00 Membership Fees & Dues 1,194 1,945 1,575 1,030 1,575 3,000 3,000 518.01-41-02 Professional Development 475 4,735 8,500 2,346 8,500 12,000 12,000 TOTAL PERSONNEL 293,234 317,007 413,409 306,184 413,409 495,500 495,500 INSURANCE 518.02-02-00 Health, Life & Dental 28,876 37,459 48,000 36,969 48,000 53,000 53,000 518.02-03-00 Workers Compensation 2,137 2,547 4,000 1,496 4,000 5,000 5,000 518.02-04-00 Unemployment 808 0 0 0 0 0 0 TOTAL INSURANCE 31,821 40,007 52,000 38,466 52,000 58,000 58,000 UTILITIES 518.03-01-00 Telephone & Voicemail 355 45 0 0 0 0 0 518.03-05-00 Mobile Phones & Pagers 554 317 1,500 244 1,500 1,500 1,500 TOTAL UTILITIES 909 362 1,500 244 1,500 1,500 1,500 CAPITAL EXPENDITURES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL OTHER PURCHASES 518.05-01-00 Office Supplies & Consum 343 296 500 3,509 500 500 500 518.05-02-00 Postage 895 328 500 125 500 500 500 518.05-04-00 Printing 45 68 100 475 100 500 500 518.05-05-00 Publications 0 0 0 0 0 1,000 1,000 518.05-20-00 Small Office Equipment 0 0 2,000 0 2,000 1,000 1,000 518.05-21-00 Equipment & Handtools 36 50 200 10 200 500 500 518.05-31-00 Uniforms 128 605 200 0 200 1,000 1,000 TOTAL OTHER PURCHASES 1,447 1,347 3,500 4,120 3,500 5,000 5,000 MAINTENANCE 518.06-21-00 Vehicle Repair & Mainten 660 5,718 500 329 500 500 500 518.06-22-00 Vehicle Gas & Oil 1,052 1,533 1,000 1,767 1,000 1,500 1,500 TOTAL MAINTENANCE 1,712 7,251 1,500 2,095 1,500 2,000 2,000 CITY SERVICES 518.07-02-01 Public Notices 1,036 1,300 1,000 583 1,000 1,000 1,000 518.07-04-00 Code Enforcement 2,412 619 3,000 ( 323) 3,000 1,000 1,000 TOTAL CITY SERVICES 3,448 1,919 4,000 260 4,000 2,000 2,000 13 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund COMMUNITY DEVELOPMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PROFESSIONAL FEES 518.08-03-00 Engineering & Planning F 11,325 14,075 6,000 8,727 6,000 10,000 10,000 518.08-03-02 NPDES II / Arcview 250 1,885 1,700 250 1,700 3,000 3,000 518.08-03-03 PROFESSIONAL SERVICES 0 0 10,000 0 10,000 0 0 TOTAL PROFESSIONAL FEES 11,575 15,960 17,700 8,977 17,700 13,000 13,000 OTHER EXPENDITURES 518.09-20-00 Planning Com. Meeting Su 90 39 200 0 200 500 500 518.09-21-00 Miscellaneous 719 51 150 (9) 150 500 500 TOTAL OTHER EXPENDITURES 808 90 350 (9)350 1,000 1,000 BOND/LEASE PAYMENTS ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL COMMUNITY DEVELOPMENT 344,954 383,943 493,959 360,336 493,959 578,000 578,000 14 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund STREET DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 520.01-01-00 Salaries 283,582 295,526 0 0 0 0 0 520.01-03-00 Overtime 16,062 18,426 0 0 0 0 0 520.01-21-00 FICA & Medicare 21,727 23,533 0 0 0 0 0 520.01-22-00 Retirement 35,752 28,620 0 0 0 0 0 520.01-41-02 Professional Development 0 391 0 0 0 0 0 TOTAL PERSONNEL 357,123 366,497 0 0 0 0 0 INSURANCE 520.02-02-00 Health, Life & Dental 58,422 49,870 0 0 0 0 0 520.02-03-00 Workers Compensation 33,197 40,642 0 0 0 0 0 TOTAL INSURANCE 91,619 90,512 0 0 0 0 0 UTILITIES 520.03-01-00 Telephone & Voicemail 1,993 3,114 0 0 0 0 0 520.03-02-00 Electricity 2,066 2,447 0 0 0 0 0 520.03-03-00 Gas 1,528 2,497 0 0 0 0 0 520.03-04-00 Water 3,772 6,828 0 0 0 0 0 520.03-05-00 Mobile Phones & Pagers 1,037 453 0 0 0 0 0 520.03-09-00 Trash Hauling 475 1,086 0 0 0 0 0 TOTAL UTILITIES 10,871 16,425 0 0 0 0 0 CAPITAL EXPENDITURES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL OTHER PURCHASES 520.05-01-00 Office Supplies & Consum 240 1,506 0 0 0 0 0 520.05-20-00 Small Office Equipment 0 433 0 0 0 0 0 520.05-21-00 Shop Supplies & Material 6,040 6,180 0 0 0 0 0 520.05-31-00 Uniforms 1,960 2,494 0 0 0 0 0 TOTAL OTHER PURCHASES 8,240 10,613 0 0 0 0 0 MAINTENANCE 520.06-01-00 Building Maint & Repair 151 1,316 0 0 0 0 0 520.06-21-00 Vehicle Repair & Mainten 281 55 0 0 0 0 0 520.06-21-01 Equipment Repair & Maint 0 25 0 0 0 0 0 520.06-34-00 Office Equipment Mainten 0 44 0 0 0 0 0 TOTAL MAINTENANCE 433 1,440 0 0 0 0 0 CITY SERVICES 520.07-32-00 Storm Sewers-General Rep 200 0 0 0 0 0 0 520.07-33-00 Street Repair Materials 0 86 0 0 0 0 0 520.07-41-00 Street Lights-Electricit 1,136 (43)0 0 0 0 0 520.07-43-00 Cleanup & Recycling Expe 15,723 20,409 0 0 0 0 0 520.07-43-02 HHW Collection Event 7,435 16,526 0 0 0 0 0 520.07-44-00 Street Signs 0 152 0 0 0 0 0 15 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund STREET DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ 520.07-51-00 Mosquito & Weed Control 1,542 2,682 0 0 0 0 0 520.07-52-00 Tree Trimming & Removal 0 2,875 0 0 0 0 0 TOTAL CITY SERVICES 26,037 42,687 0 0 0 0 0 PROFESSIONAL FEES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL OTHER EXPENDITURES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL STREET DEPARTMENT 494,323 528,174 0 0 0 0 0 16 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund PARKS DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 525.01-01-00 Salaries 142,113 181,787 0 0 0 0 0 525.01-03-00 Overtime 7,806 10,961 0 0 0 0 0 525.01-05-00 Seasonal Landscape Maint 38,927 34,907 0 0 0 0 0 525.01-21-00 FICA & Medicare 13,782 16,853 0 0 0 0 0 525.01-22-00 Retirement 17,822 21,143 0 0 0 0 0 525.01-41-00 Membership Fees & Dues 0 380 0 0 0 0 0 525.01-41-02 Professional Development 0 20 0 0 0 0 0 TOTAL PERSONNEL 220,450 266,051 0 0 0 0 0 INSURANCE 525.02-02-00 Health, Life & Dental 38,395 40,469 0 0 0 0 0 525.02-03-00 Workers Compensation 14,359 17,314 0 0 0 0 0 TOTAL INSURANCE 52,753 57,783 0 0 0 0 0 UTILITIES 525.03-01-00 Telephone & Voicemail 2,627 4,252 0 0 0 0 0 525.03-02-00 Electricity 11,447 5,911 0 0 0 0 0 525.03-04-00 Water 3,299 4,450 0 0 0 0 0 525.03-05-00 Mobile Phones & Pagers 459 151 0 0 0 0 0 525.03-09-00 Trash Hauling 615 1,115 0 0 0 0 0 TOTAL UTILITIES 18,447 15,879 0 0 0 0 0 CAPITAL EXPENDITURES 525.04-31-00 Equipment & Machinery 579 0 0 0 0 0 0 TOTAL CAPITAL EXPENDITURES 579 0 0 0 0 0 0 OTHER PURCHASES 525.05-01-00 Office Supplies & Consum 359 587 0 0 0 0 0 525.05-02-00 Postage 1 669 0 0 0 0 0 525.05-04-00 Printing 658 1,021 0 0 0 0 0 525.05-20-00 Small Office Equipment 0 22 0 0 0 0 0 525.05-21-00 Equipment & Handtools 6,701 7,845 0 0 0 0 0 525.05-31-00 Uniforms 1,092 1,090 0 0 0 0 0 525.05-41-01 Restroom Supplies 3,894 3,921 0 0 0 0 0 525.05-41-02 Trash Bags 3,026 4,569 0 0 0 0 0 525.05-41-03 Park Enhancements 7,329 18,031 0 0 0 0 0 525.05-42-00 Grass Seed & Fertilizer 6,039 4,339 0 0 0 0 0 525.05-99-00 Other Purchases 55 756 0 0 0 0 0 TOTAL OTHER PURCHASES 29,154 42,849 0 0 0 0 0 MAINTENANCE 525.06-01-00 Buildings Maint & Repair 10,296 13,955 0 0 0 0 0 525.06-03-00 Restrooms 7,213 17,938 0 0 0 0 0 525.06-05-02 Ballfield Maintenance 1,796 2,616 0 0 0 0 0 525.06-05-03 Trail Maintenance 477 1,238 0 0 0 0 0 525.06-12-00 Playground Equipment Rep 2,515 54 0 0 0 0 0 17 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund PARKS DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ 525.06-13-00 Spirit Fountain 1,508 1,124 0 0 0 0 0 525.06-14-00 Retention Pond Maintenan 325 0 0 0 0 0 0 525.06-21-00 Vehicle Repair & Mainten 5,177 8,611 0 0 0 0 0 525.06-21-01 Equipment Repair & Maint 3,063 4,700 0 0 0 0 0 525.06-21-02 Tractor Mowing Equipment 9,192 7,874 0 0 0 0 0 525.06-22-00 Vehicle Gas & Oil 3,356 4,221 0 0 0 0 0 525.06-22-01 Equipment Gas & Oil 3,396 3,882 0 0 0 0 0 TOTAL MAINTENANCE 48,313 66,213 0 0 0 0 0 CITY SERVICES 525.07-20-00 Rental of Portable Toile 9,532 12,155 0 0 0 0 0 525.07-51-00 Mosquito & Weed Control 7,007 10,052 0 0 0 0 0 525.07-51-01 Landscaping 325 1,769 0 0 0 0 0 525.07-52-00 Tree Trimming & Removal 35,794 10,640 0 0 0 0 0 525.07-53-00 Tree Planting 13,642 2,895 0 0 0 0 0 525.07-60-00 Rental Equipment 435 1,126 0 0 0 0 0 TOTAL CITY SERVICES 66,735 38,638 0 0 0 0 0 TOTAL PARKS DEPARTMENT 436,432 487,653 0 0 0 0 0 18 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund NATURE SANCTUARY EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 535.01-01-00 Salaries 40,744 47,420 0 0 0 0 0 535.01-03-00 Overtime Pay 876 624 0 0 0 0 0 535.01-21-00 FICA & Medicare 3,177 3,654 0 0 0 0 0 535.01-22-00 Retirement 3,032 3,669 0 0 0 0 0 535.01-41-02 Professional Development 313 1,299 0 0 0 0 0 TOTAL PERSONNEL 48,142 56,666 0 0 0 0 0 INSURANCE 535.02-02-00 Health 3,973 4,230 0 0 0 0 0 TOTAL INSURANCE 3,973 4,230 0 0 0 0 0 UTILITIES 535.03-02-00 Electricity 19 231 0 0 0 0 0 TOTAL UTILITIES 19 231 0 0 0 0 0 OTHER PURCHASES 535.05-01-00 Office Supplies & Consum 120 167 0 0 0 0 0 535.05-02-00 Postage 20 6 0 0 0 0 0 535.05-04-00 Printing 0 47 0 0 0 0 0 535.05-21-00 Equipment & Handtools 1,190 1,323 0 0 0 0 0 535.05-41-00 Materials 1,597 1,176 0 0 0 0 0 535.05-42-00 Program Expenses 0 55 0 0 0 0 0 535.05-43-00 Volunteer Acknowledgemen 505 945 0 0 0 0 0 TOTAL OTHER PURCHASES 3,432 3,720 0 0 0 0 0 MAINTENANCE 535.06-01-00 Building Maintenance & R 6 45 0 0 0 0 0 535.06-05-03 Trail Maintenance 2,665 3,150 0 0 0 0 0 535.06-21-00 Vehicle Repair & Mainten 326 196 0 0 0 0 0 535.06-21-01 Equipment Repair & Maint 2 105 0 0 0 0 0 535.06-22-00 Vehicle Gas & Oil ( 263) 522 0 0 0 0 0 TOTAL MAINTENANCE 2,736 4,018 0 0 0 0 0 CITY SERVICES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL OTHER EXPENDITURES 535.09-21-00 Miscellaneous 247 920 0 0 0 0 0 TOTAL OTHER EXPENDITURES 247 920 0 0 0 0 0 TOTAL NATURE SANCTUARY 58,549 69,785 0 0 0 0 0 19 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund PUBLIC INFORMATION EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 540.01-52-00 Technical Consultant/Int 10,500 10,200 10,200 4,250 10,200 11,000 11,000 540.01-53-00 Production Assistant/Int 1,325 3,319 3,000 1,338 3,000 3,500 3,500 TOTAL PERSONNEL 11,825 13,519 13,200 5,588 13,200 14,500 14,500 CAPITAL EXPENDITURES 540.04-11-00 Computers & Programming 0 0 0 0 0 300 300 540.04-21-00 Office Equipment 0 0 100 0 100 500 500 TOTAL CAPITAL EXPENDITURES 0 0 100 0 100 800 800 OTHER PURCHASES 540.05-03-00 Computer Equip/Access/Pr 329 403 300 0 300 300 300 540.05-05-00 Publications 4,263 0 7,000 0 7,000 7,000 7,000 TOTAL OTHER PURCHASES 4,591 403 7,300 0 7,300 7,300 7,300 MAINTENANCE 540.06-31-00 Computer Maintenance 60 60 60 60 60 100 100 TOTAL MAINTENANCE 60 60 60 60 60 100 100 CITY SERVICES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL OTHER EXPENDITURES 540.09-05-00 Newsletter/Website 17,817 20,223 15,000 9,159 15,000 26,000 26,000 540.09-21-00 Miscellaneous 0 0 0 0 0 300 300 TOTAL OTHER EXPENDITURES 17,817 20,223 15,000 9,159 15,000 26,300 26,300 TOTAL PUBLIC INFORMATION 34,293 34,204 35,660 14,807 35,660 49,000 49,000 20 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund TRANSFERS OUT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TRANSFERS-OTHER SOURCES 550.20-01-00 TRANSFER TO TRANSPORTATI 0 0 236,000 177,000 236,000 243,000 243,000 550.20-02-00 TRANSFER TO POLICE FUND 0 0 0 0 0 1,500,000 1,500,000 550.20-04-00 TRANSFER TO NIDS 0 0 286,575 286,575 286,575 291,000 291,000 550.20-20-00 Transfer to Emergency Re 0 0 0 0 0 118,000 118,000 550.20-60-00 TRANSFER TO NATURE SANCT 0 0 63,000 47,250 63,000 0 0 550.20-63-00 TRANSFER TO PARKS FUND 0 0 350,000 262,500 350,000 426,000 426,000 TOTAL TRANSFERS-OTHER SOURCES 0 0 935,575 773,325 935,575 2,578,000 2,578,000 TOTAL TRANSFERS OUT 0 0 935,575 773,325 935,575 2,578,000 2,578,000 21 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund INFORMATION TECHNOLOGY EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 555.01-52-00 Information Technology S 30,196 37,502 35,000 15,899 35,000 40,000 40,000 TOTAL PERSONNEL 30,196 37,502 35,000 15,899 35,000 40,000 40,000 INSURANCE 555.02-01-00 Equipment 17,311 8,280 15,000 8,973 15,000 20,000 20,000 555.02-02-00 Software 24,488 24,243 35,000 52,766 35,000 97,000 97,000 555.02-04-00 Domain Registrations 1,835 454 1,304 210 1,304 2,000 2,000 555.02-05-00 Cyber Security 0 0 7,000 7,821 7,000 25,000 25,000 TOTAL INSURANCE 43,633 32,977 58,304 69,770 58,304 144,000 144,000 MAINTENANCE 555.06-01-00 Maintenance & Repair 1,451 2,832 5,000 0 5,000 10,000 10,000 TOTAL MAINTENANCE 1,451 2,832 5,000 0 5,000 10,000 10,000 TOTAL INFORMATION TECHNOLOGY 75,281 73,311 98,304 85,669 98,304 194,000 194,000 22 of 103 11-14-2023 01:00 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 10 -General Fund CAPITAL OUTLAY EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY 560.50-10-00 Administration CIP 7,750 1,659 15,000 0 15,000 0 0 560.50-50-00 Police Capital Outlay 84,107 73,646 139,303 80,199 139,303 0 0 TOTAL CAPITAL OUTLAY 91,857 75,305 154,303 80,199 154,303 0 0 CAPITAL OUTLAY 560.51-00-00 Court Capital Outlay 1,295 0 0 0 0 0 0 560.51-50-00 Public Works Capital Out 22,041 41,636 48,041 37,915 48,041 0 0 560.51-80-00 Com Development Capital 39,528 10,000 50,000 5,000 50,000 0 0 TOTAL CAPITAL OUTLAY 62,864 51,636 98,041 42,915 98,041 0 0 CAPITAL OUTLAY 560.52-50-00 Parks Capital Outlay 0 799 0 0 0 0 0 TOTAL CAPITAL OUTLAY 0 799 0 0 0 0 0 CAPITAL OUTLAY 560.55-50-00 IT Capital Outlay 6,146 13,584 8,750 0 8,750 0 0 TOTAL CAPITAL OUTLAY 6,146 13,584 8,750 0 8,750 0 0 TOTAL CAPITAL OUTLAY 160,868 141,323 261,094 123,115 261,094 0 0 TOTAL EXPENDITURES 5,288,806 5,606,260 6,014,029 4,037,230 6,014,029 5,878,000 5,878,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES ( 248,615) 487,083 ( 4,429) 1,205,423 139,271 106,900 106,900 =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 23 of 103 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Sewer Charges 1,706,404$ 1,760,193$ 1,760,193$ 1,813,000$ 1,867,388$ 1,923,410$ 1,981,112$ 2,040,546$ Sewer Tap Fees 14,000 30,450 30,450 30,000 30,450 30,907 31,370 31,841 Sewer Impact Fees 14,850 50,750 50,750 51,500 52,273 53,057 53,852 54,660 MOAW Bill Collection Payment 267 550 550 550 550 550 550 550 Grinder Pump Admin Fee 4,620 4,620 4,620 4,600 4,600 4,600 4,600 4,600 Interest Income 1,413 5,050 5,050 5,500 5,555 5,611 5,667 5,723 Transfer from Sewer CIP (34)- 187,500 - - - - - - Miscellaneous 16,714 - 28,067 - - - - - Total Revenues 1,758,268 2,039,113 1,879,680 1,905,150 1,960,816 2,018,134 2,077,152 2,137,920 Operating Expenses 935,830 812,758 812,758 800,500 1,009,515 1,039,800 1,070,994 1,103,124 Capital Expenses 460,720 627,450 627,450 709,000 723,000 766,000 824,000 824,000 Additional Capital: MDNR - - - - - 200,000 276,000 276,000 Debt Service (Transfer to 34)178,944 182,500 182,500 179,000 31,350 - - - Transfer to General Fund 350,000 360,500 360,500 370,000 185,000 92,500 46,250 46,250 Other Transfers - - - - - - - - Total Expenses 1,925,494 1,983,208 1,983,208 2,058,500 1,948,865 2,098,300 2,217,244 2,249,374 Increase (Decrease)(167,226) 55,905 (103,528) (153,350) 11,951 (80,167) (140,093) (111,454) Beginning Fund Balance 953,110 785,884 785,884 682,355 529,005 540,956 460,790 320,697 Ending Fund Balance 785,884$ 841,789$ 682,355$ 529,005$ 540,956$ 460,790$ 320,697$ 209,243$ Fund Balance %41%42%34%26%28%22%14%9% City of Parkville, Missouri Sewer Services Fund (30) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Revenues Expenses M:\Budgets\2024\working folder\Financial forecast\30 Sewer Fund Forecast 2024 11.13.23_FINAL 11/14/2023 24 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 30 -Sewer Service Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY OTHER REVENUE 1,633,592 1,740,141 1,846,563 528,217 1,846,563 1,899,650 1,899,650 INTEREST INCOME 1,440 1,413 5,050 260 5,050 5,500 5,500 MISCELLANEOUS REVENUE 924 16,714 0 28,067 28,067 0 0 TRANSFERS IN 0 0 187,500 0 0 0 0 TOTAL REVENUES 1,635,956 1,758,268 2,039,113 556,544 1,879,680 1,905,150 1,905,150 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY ADMINISTRATIVE 1,851,537 1,925,494 1,983,208 1,077,566 1,983,208 2,058,500 2,058,500 TOTAL EXPENDITURES 1,851,537 1,925,494 1,983,208 1,077,566 1,983,208 2,058,500 2,058,500 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES ( 215,581) ( 167,226) 55,905 ( 521,022) ( 103,528) ( 153,350) ( 153,350) =========== =========== =========== =========== =========== ============ ============ 25 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 30 -Sewer Service Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ OTHER REVENUE 41501-00 Sewer Charges 83,240 97,833 1,760,193 77,313 1,760,193 1,813,000 1,813,000 41501-01 Sewer Charges - Data Tech 1,490,930 1,608,572 0 426,772 0 30,000 30,000 41502-00 Sewer Tap Fees 28,000 14,000 30,450 12,150 30,450 0 0 41502-01 Sewer Impact Fees 26,400 14,850 50,750 8,517 50,750 51,500 51,500 41503-00 Mo Am Bill Collection pymt 402 267 550 0 550 550 550 41504-00 Grinder Pump Admin Fee 4,620 4,620 4,620 3,465 4,620 4,600 4,600 TOTAL OTHER REVENUE 1,633,592 1,740,141 1,846,563 528,217 1,846,563 1,899,650 1,899,650 INTEREST INCOME 41701-00 Interest Income 1,440 1,413 5,050 260 5,050 5,500 5,500 TOTAL INTEREST INCOME 1,440 1,413 5,050 260 5,050 5,500 5,500 MISCELLANEOUS REVENUE 41804-00 Miscellaneous Revenue 924 16,714 0 28,067 28,067 0 0 TOTAL MISCELLANEOUS REVENUE 924 16,714 0 28,067 28,067 0 0 TRANSFERS IN 41901-00 Transfer from Sewer Fund 0 0 187,500 0 0 0 0 TOTAL TRANSFERS IN 0 0 187,500 0 0 0 0 TOTAL REVENUES 1,635,956 1,758,268 2,039,113 556,544 1,879,680 1,905,150 1,905,150 =========== =========== =========== =========== =========== ============ ============ 26 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 30 -Sewer Service Fund ADMINISTRATIVE EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 501.01-01-00 Salaries 37,128 36,870 47,902 33,790 47,902 54,000 54,000 501.01-03-00 Overtime 177 68 0 0 0 1,000 1,000 501.01-21-00 FICA & Medicare 2,819 2,709 2,970 2,474 2,970 4,000 4,000 501.01-22-00 Retirement 0 0 6,802 241 6,802 10,000 10,000 501.01-41-00 Professional Development 0 0 1,000 0 1,000 2,000 2,000 TOTAL PERSONNEL 40,124 39,647 58,674 36,505 58,674 71,000 71,000 INSURANCE 501.02-02-00 Health, Life & Dental 5,051 10,397 13,003 9,323 13,003 14,000 14,000 TOTAL INSURANCE 5,051 10,397 13,003 9,323 13,003 14,000 14,000 UTILITIES 501.03-01-00 Telephone & Voicemail 1,869 1,356 1,000 1,742 1,000 1,000 1,000 501.03-02-00 Electricity 47,644 58,978 54,000 49,385 54,000 54,000 54,000 501.03-04-00 Water 551 3,391 2,500 2,042 2,500 2,500 2,500 501.03-06-00 Wi-Fi 64 0 0 0 0 0 0 501.03-09-00 Trash Hauling 500 805 600 155 600 1,000 1,000 TOTAL UTILITIES 50,627 64,530 58,100 53,324 58,100 58,500 58,500 CAPITAL EXPENDITURES 501.04-31-00 Equipment & Machinery 14,628 19,171 0 1,949 0 0 0 501.04-51-00 Sewer Plant Improvements 29,734 62,433 206,000 44,079 206,000 137,000 137,000 501.04-61-00 Pump Station Improvement 8,217 191,191 23,750 13,552 23,750 468,000 468,000 TOTAL CAPITAL EXPENDITURES 52,579 272,795 229,750 59,580 229,750 605,000 605,000 OTHER PURCHASES 501.05-01-00 Office Supplies 39 377 250 362 250 500 500 501.05-02-00 Postage 6,082 6,850 8,000 4,646 8,000 8,000 8,000 501.05-04-00 Printing 1,717 105 1,500 1,666 1,500 1,500 1,500 501.05-06-00 Delinquencies 2,081 941 2,200 2,399 2,200 2,000 2,000 TOTAL OTHER PURCHASES 9,919 8,271 11,950 9,072 11,950 12,000 12,000 MAINTENANCE 501.06-01-00 Building Main & Repair 70,742 53,961 35,000 28,856 35,000 50,000 50,000 501.06-12-00 Pump Stations Maintenanc 23,943 34,498 30,000 33,604 30,000 35,000 35,000 501.06-21-00 Vehicle Repair & Mainten 1,678 1,410 1,500 973 1,500 1,500 1,500 501.06-21-02 Tractor/Lawn Mowing Equi 11 0 1,000 0 1,000 15,000 15,000 501.06-22-00 Vehicle Gas & Oil 575 2,090 2,500 1,953 2,500 2,500 2,500 501.06-22-01 Equipment Gas & Oil 1 2,457 2,000 1,100 2,000 2,000 2,000 501.06-33-00 Software Support Agreeme 3,088 3,384 3,200 0 3,200 3,500 3,500 501.06-42-00 Line Maintenance 346,342 348,133 397,700 104,999 397,700 104,000 104,000 501.06-99-00 Other Maintenance 0 0 69,000 10,439 69,000 24,000 24,000 TOTAL MAINTENANCE 446,379 445,934 541,900 181,924 541,900 237,500 237,500 27 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 30 -Sewer Service Fund ADMINISTRATIVE EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CITY SERVICES 501.07-34-00 Line Repairs 30,637 78,399 40,000 19,801 40,000 50,000 50,000 501.07-42-00 One Call Utility Locatin 3,053 3,185 3,000 817 3,000 3,000 3,000 501.07-82-00 KC Water Depart 33,174 36,094 33,000 19,294 33,000 33,000 33,000 501.07-83-00 Platte Co Regional Sewer 17,759 17,759 18,000 4,681 18,000 18,000 18,000 501.07-91-00 Odor Control 29,302 59,485 57,000 441 57,000 57,000 57,000 TOTAL CITY SERVICES 113,924 194,922 151,000 45,033 151,000 161,000 161,000 PROFESSIONAL FEES 501.08-03-00 Engineering Fees 19,165 14,535 30,000 32,600 30,000 35,000 35,000 501.08-04-00 Management Contract 304,550 307,991 330,631 245,978 330,631 300,500 300,500 501.08-06-00 Administration Fee 350,000 350,000 360,500 270,375 360,500 370,000 370,000 501.08-07-00 Credit Card Fees 10,148 11,992 10,500 3,991 10,500 10,000 10,000 501.08-08-00 Sewer Billing Refunds 747 481 500 426 500 500 500 TOTAL PROFESSIONAL FEES 684,610 684,999 732,131 553,371 732,131 716,000 716,000 OTHER EXPENDITURES 501.09-21-00 Miscellaneous 0 23,019 2,000 1,011 2,000 2,000 2,000 501.09-21-01 Depreciation/Amortizatio 267,918 0 0 0 0 0 0 501.09-22-00 DNR Fees 2,001 2,027 2,200 0 2,200 2,500 2,500 TOTAL OTHER EXPENDITURES 269,919 25,046 4,200 1,011 4,200 4,500 4,500 BOND/LEASE PAYMENTS 501.10-02-00 Sewer Revenue Bond Inter 0 10 0 0 0 0 0 TOTAL BOND/LEASE PAYMENTS 0 10 0 0 0 0 0 SYSTEM RENEWAL PROJECT 501.12-11-00 SRF Principal-Transfer t 165,878 170,000 165,000 127,500 165,000 170,000 170,000 501.12-11-01 SRF Interest-Transfer to 9,646 7,056 12,500 922 12,500 9,000 9,000 501.12-11-02 SRF Admin Fee-Transfer t 2,880 1,888 5,000 0 5,000 0 0 TOTAL SYSTEM RENEWAL PROJECT 178,403 178,944 182,500 128,422 182,500 179,000 179,000 TRANSFERS-OTHER SOURCES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ADMINISTRATIVE 1,851,537 1,925,494 1,983,208 1,077,566 1,983,208 2,058,500 2,058,500 TOTAL EXPENDITURES 1,851,537 1,925,494 1,983,208 1,077,566 1,983,208 2,058,500 2,058,500 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES ( 215,581) ( 167,226) 55,905 ( 521,022) ( 103,528) ( 153,350) ( 153,350) =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 28 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Taxes 1,214,798$ 1,281,000$ 1,343,107$ 1,363,000$ 1,399,000$ 1,435,000$ 1,472,000$ 1,510,000$ Other 19,566 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Transfers - 236,000 236,000 243,000 250,000 258,000 266,000 274,000 Total Revenues 1,234,364 1,532,000 1,594,107 1,621,000 1,664,000 1,708,000 1,753,000 1,799,000 Salary and Benefits - 538,988 538,988 618,000 637,000 656,000 676,000 696,000 Operating 393,602 552,200 552,500 610,000 628,000 647,000 666,000 686,000 Capital 317,075 585,000 470,000 380,000 425,000 348,000 377,000 436,000 Transfers Out 447,762 66,229 66,229 - - - - - Total Expenditures 1,158,439 1,742,417 1,627,717 1,608,000 1,690,000 1,651,000 1,719,000 1,818,000 Increase (decrease)75,925 (210,417) (33,610) 13,000 (26,000) 57,000 34,000 (19,000) Beginning FB 169,272 353,260 245,197 211,587 224,587 198,587 255,587 289,587 Ending FB 245,197$ 142,843$ 211,587$ 224,587$ 198,587$ 255,587$ 289,587$ 270,587$ Fund Balance % (of OPS)29%12%18%18%16%20%22%20% Total CIP Request - - - 685,000 825,000 798,000 827,000 886,000 CIP $ Not Included Above - - - 305,000 400,000 450,000 450,000 450,000 Net Capital in Forecast - - - 380,000 425,000 348,000 377,000 436,000 City of Parkville, Missouri Transportation Fund (40) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Revenues Expenditures M:\Budgets\2024\working folder\Financial forecast\40 Transportation forecast 11.13.23_FINAL 11/14/2023 29 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 40 -Transportation Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TAXES 168,250 175,903 180,000 182,366 182,000 184,000 184,000 SALES TAXES 908,305 1,048,681 1,111,000 881,182 1,171,107 1,189,000 1,189,000 OTHER REVENUE 16,425 5,325 5,000 4,970 5,000 5,000 5,000 MISCELLANEOUS REVENUE 1,292 4,454 0 2,620 0 0 0 TRANSFERS 200,000 0 236,000 177,000 236,000 243,000 243,000 TOTAL REVENUES 1,294,273 1,234,364 1,532,000 1,248,138 1,594,107 1,621,000 1,621,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY STREET DEPARTMENT 699,245 710,678 1,676,188 583,117 1,561,188 1,608,000 1,608,000 TRANSFERS 400,065 447,762 66,229 66,229 66,229 0 0 TOTAL EXPENDITURES 1,099,310 1,158,440 1,742,417 649,346 1,627,417 1,608,000 1,608,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 194,963 75,923 ( 210,417) 598,792 ( 33,310) 13,000 13,000 =========== =========== =========== =========== =========== ============ ============ 30 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 40 -Transportation Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TAXES 41006-00 Parkville Special Rd District 168,250 175,903 180,000 182,366 182,000 184,000 184,000 TOTAL TAXES 168,250 175,903 180,000 182,366 182,000 184,000 184,000 LICENSE S ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL SALES TAXES 41404-00 City Transportation Sales Tax 552,320 629,500 689,000 566,312 736,107 758,000 758,000 41405-00 Motor Fuel Tax 152,240 186,238 178,000 186,062 186,000 182,000 182,000 41406-00 County Trans Sales Tax 194,102 223,157 234,000 128,808 239,000 239,000 239,000 41407-00 Marketplace TIF Fund Tfr 9,643 9,787 10,000 0 10,000 10,000 10,000 TOTAL SALES TAXES 908,305 1,048,681 1,111,000 881,182 1,171,107 1,189,000 1,189,000 OTHER REVENUE 41504-00 Project Cost Share 16,425 5,325 5,000 4,970 5,000 5,000 5,000 TOTAL OTHER REVENUE 16,425 5,325 5,000 4,970 5,000 5,000 5,000 INTEREST INCOME ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL MISCELLANEOUS REVENUE 41804-01 POTMCID Grants 1,292 0 0 0 0 0 0 41805-00 Sale of Transportation Equip.0 0 0 2,620 0 0 0 41805-02 City Capital Cost Payments 0 4,454 0 0 0 0 0 TOTAL MISCELLANEOUS REVENUE 1,292 4,454 0 2,620 0 0 0 TRANSFERS I N ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL TRANSFERS 42001-00 Transfers from Other Funds 200,000 0 0 0 0 0 0 42010-00 Transfer from General Fund 0 0 236,000 177,000 236,000 243,000 243,000 TOTAL TRANSFERS 200,000 0 236,000 177,000 236,000 243,000 243,000 TOTAL REVENUES 1,294,273 1,234,364 1,532,000 1,248,138 1,594,107 1,621,000 1,621,000 =========== =========== =========== =========== =========== ============ ============ 31 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 40 -Transportation Fund STREET DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 520.01-01-00 SALARIES 0 0 333,650 214,041 333,650 381,000 381,000 520.01-03-00 OVERTIME 0 0 25,000 5,936 25,000 30,000 30,000 520.01-21-00 FICA & MEDICARE 0 0 25,524 16,359 25,524 29,000 29,000 520.01-22-00 RETIREMENT 0 0 47,378 33,775 47,378 71,000 71,000 520.01-41-02 PROFESSIONAL DEVELOPMENT 0 0 0 350 0 8,000 8,000 TOTAL PERSONNEL 0 0 431,552 270,460 431,552 519,000 519,000 INSURANCE 520.02-02-00 HEALTH & UNEMPLOYMENT IN 0 0 67,436 41,782 67,436 67,000 67,000 520.02-03-00 WORKERS COMPENSATION 0 0 40,000 23,545 40,000 40,000 40,000 TOTAL INSURANCE 0 0 107,436 65,327 107,436 107,000 107,000 UTILITIES 520.03-01-00 OFFICE PHONES 0 0 2,800 2,405 2,800 3,000 3,000 520.03-02-00 ELECTRICITY 0 26 3,500 2,013 3,500 3,500 3,500 520.03-03-00 NATURAL GAS 0 0 2,500 2,042 2,500 3,500 3,500 520.03-04-00 WATER SERVICE / DRINKING 0 0 6,000 3,319 6,000 5,500 5,500 520.03-05-00 MOBILE PHONES / DATA 0 0 3,000 527 3,000 3,000 3,000 520.03-08-00 CABLE / INTERNET 0 0 0 321 0 0 0 520.03-09-00 SOLID WASTE / RECYCLING 0 0 1,200 4,489 1,200 2,000 2,000 TOTAL UTILITIES 0 26 19,000 15,115 19,000 20,500 20,500 CAPITAL EXPENDITURES 520.04-71-00 STREET PROGRAMS 0 0 0 2,497 0 0 0 520.04-81-00 CRACK SEAL - ANNUAL PROJ 0 8,610 15,000 0 0 0 0 520.04-83-00 STREET STRIPING - ANNUAL 1,757 35,623 20,000 5,350 5,000 20,000 20,000 520.04-85-00 MILL & OVERLAY PROG - AN 222,455 223,758 350,000 3,056 295,000 285,000 285,000 520.04-85-01 EQUIPMENT - TRANSPORTATI 35 7,108 100,000 6,377 70,000 25,000 25,000 520.04-90-00 CURB & SIDEWALK PROG - A 69,576 63,576 100,000 2,870 100,000 50,000 50,000 TOTAL CAPITAL EXPENDITURES 293,823 338,674 585,000 20,150 470,000 380,000 380,000 OTHER PURCHASES 520.05-01-00 OFFICE SUPPLIES/CONSUMAB 0 0 1,000 974 1,000 1,000 1,000 520.05-20-00 SMALL OFFICE EQUIPMENT 0 0 700 249 700 1,000 1,000 520.05-21-00 EQUIP/MATERIALS/TOOLS 0 0 7,000 3,237 7,000 7,000 7,000 520.05-31-00 UNIFORMS / CLOTHING 0 0 4,500 301 4,500 4,500 4,500 TOTAL OTHER PURCHASES 0 0 13,200 4,760 13,200 13,500 13,500 MAINTENANCE 520.06-01-00 Building Maintenance & R 2,087 3,635 10,000 762 10,000 10,000 10,000 520.06-21-00 Vehicle & Equipment Main 12,083 17,595 15,000 4,511 15,000 20,000 20,000 520.06-22-00 Vehicle & Equipment Gas 15,397 31,685 35,000 12,516 35,000 35,000 35,000 TOTAL MAINTENANCE 29,567 52,916 60,000 17,789 60,000 65,000 65,000 32 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 40 -Transportation Fund STREET DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CITY SERVICES 520.07-20-00 Emergency Snow Removal 49,746 47,915 70,000 7,500 70,000 70,000 70,000 520.07-32-00 Storm Sewers - General R 6,246 2,980 15,000 ( 2,200) 15,000 50,000 50,000 520.07-33-00 Street Repair Materials 8,065 4,917 15,000 1,841 15,000 20,000 20,000 520.07-41-00 Street Lights - Electric 285,378 231,264 300,000 168,847 300,000 300,000 300,000 520.07-44-00 Street Signs 2,388 5,107 12,000 11,435 12,000 15,000 15,000 520.07-45-00 Street Sweeping 17,786 14,360 25,000 0 25,000 25,000 25,000 520.07-51-00 MOSQUITO & WEED CONTROL 0 0 0 660 0 0 0 520.07-52-00 Tree Trimming & Removal 6,045 10,327 20,000 485 20,000 20,000 20,000 520.07-60-00 Rental Equipment 126 207 2,000 0 2,000 2,000 2,000 TOTAL CITY SERVICES 375,781 317,076 459,000 188,567 459,000 502,000 502,000 OTHER EXPENDITURES 520.09-21-00 Miscellaneous 75 1,987 1,000 948 1,000 1,000 1,000 TOTAL OTHER EXPENDITURES 75 1,987 1,000 948 1,000 1,000 1,000 TOTAL STREET DEPARTMENT 699,245 710,678 1,676,188 583,117 1,561,188 1,608,000 1,608,000 33 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 40 -Transportation Fund TRANSFERS EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TRANSFERS ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL TRANSFERS-OTHER SOURCES 550.20-10-00 Transfer to General Fund 175,000 225,000 0 0 0 0 0 550.20-22-00 Tfr to Debt Svc Fund -20 210,765 222,762 66,229 66,229 0 0 0 550.20-43-00 Transfer to Cap Projects 14,300 0 0 0 66,229 0 0 TOTAL TRANSFERS-OTHER SOURCES 400,065 447,762 66,229 66,229 66,229 0 0 TOTAL TRANSFERS 400,065 447,762 66,229 66,229 66,229 0 0 TOTAL EXPENDITURES 1,099,310 1,158,440 1,742,417 649,346 1,627,417 1,608,000 1,608,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 194,963 75,923 ( 210,417) 598,792 ( 33,310) 13,000 13,000 =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 34 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Taxes 775,713$ 770,000$ 947,000$ 975,000$ 1,004,000$ 1,034,000$ 1,065,000$ 1,097,000$ Program Revenue 40,000 40,000 37,000 37,700 38,400 39,100 39,800 Other 14,570 - - - - - - Grants/Donations 52,563 1,000 402,743 1,000 1,000 1,000 1,000 1,000 Transfers - 350,000 350,000 426,000 439,000 452,000 466,000 480,000 Total Revenues 842,846 1,161,000 1,739,743 1,439,000 1,481,700 1,525,400 1,571,100 1,617,800 Salary and Benefits - 541,496 541,496 771,000 870,000 896,000 923,000 951,000 Operating 21,475 227,575 227,575 228,000 253,000 261,000 269,000 277,000 Capital 486,965 478,500 478,500 496,000 962,000 645,000 350,000 350,000 Transfers Out 92,436 - - - - - - - Total Expenditures 600,877 1,247,571 1,247,571 1,495,000 2,085,000 1,802,000 1,542,000 1,578,000 Increase (decrease)241,969 (86,571) 492,172 (56,000) (603,300) (276,600) 29,100 39,800 Beginning FB 543,779 772,097 785,748 1,277,920 1,221,920 618,620 342,020 371,120 Ending FB 785,748$ 685,526$ 1,277,920$ 1,221,920$ 618,620$ 342,020$ 371,120$ 410,920$ Fund Balance % (of OPS)690%89%166%122%55%30%31%33% Expenditures City of Parkville, Missouri Parks Sales Tax Fund (41) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Revenues M:\Budgets\2024\working folder\Financial forecast\41 Parks forecast 11.13.23_FINAL 11/14/2023 35 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 41 -Park Sales Tax Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY SALES TAXES 672,672 775,714 770,000 700,241 947,000 975,000 975,000 OTHER REVENUE 0 0 40,000 30,110 40,000 37,000 37,000 MISCELLANEOUS REVENUE 0 67,133 1,000 402,743 402,743 1,000 1,000 TRANSFERS 0 0 350,000 262,500 350,000 426,000 426,000 TOTAL REVENUES 672,672 842,847 1,161,000 1,395,594 1,739,743 1,439,000 1,439,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY ADMIN 94,633 18,587 20,000 2,700 20,000 0 0 PARKS 0 2,888 749,071 429,494 749,071 999,000 999,000 TRANSFERS OUT 41,200 92,436 0 0 0 0 0 CAPITAL OUTLAY 218,667 486,965 478,500 190,524 478,500 496,000 496,000 TOTAL EXPENDITURES 354,499 600,877 1,247,571 622,718 1,247,571 1,495,000 1,495,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 318,173 241,970 ( 86,571) 772,875 492,172 ( 56,000) ( 56,000) =========== =========== =========== =========== =========== ============ ============ 36 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 41 -Park Sales Tax Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ SALES TAXES 41404-00 Park Sales Tax Revenue 672,672 775,714 770,000 700,241 947,000 975,000 975,000 TOTAL SALES TAXES 672,672 775,714 770,000 700,241 947,000 975,000 975,000 OTHER REVENUE 41501-00 Farmers Market 0 0 1,500 0 1,500 1,500 1,500 41504-00 Park Shelter Reservations 0 0 15,000 13,650 15,000 14,000 14,000 41504-01 Sports Field Reservations 0 0 6,000 7,060 6,000 6,500 6,500 41504-02 Special Event Permit 0 0 17,500 9,400 17,500 15,000 15,000 TOTAL OTHER REVENUE 0 0 40,000 30,110 40,000 37,000 37,000 MISCELLANEOUS REVENUE 41801-00 Miscellaneous 0 14,570 0 0 0 1,000 1,000 41804-08 Platte County Outreach Grant 0 0 1,000 0 402,743 0 0 41807-01 Insurance Claim Reimbursements 0 52,563 0 402,743 0 0 0 TOTAL MISCELLANEOUS REVENUE 0 67,133 1,000 402,743 402,743 1,000 1,000 TRANSFERS IN ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL TRANSFERS 42001-00 Transfers from Other Funds 0 0 350,000 262,500 350,000 426,000 426,000 TOTAL TRANSFERS 0 0 350,000 262,500 350,000 426,000 426,000 TOTAL REVENUES 672,672 842,847 1,161,000 1,395,594 1,739,743 1,439,000 1,439,000 =========== =========== =========== =========== =========== ============ ============ 37 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 41 -Park Sales Tax Fund ADMIN EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PROFESSIONAL FEES 501.08-03-00 Engineer & Planning Fees 94,633 18,587 20,000 2,700 20,000 0 0 TOTAL PROFESSIONAL FEES 94,633 18,587 20,000 2,700 20,000 0 0 TOTAL ADMIN 94,633 18,587 20,000 2,700 20,000 0 0 38 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 41 -Park Sales Tax Fund PARKS EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 525.01-01-00 SALARIES 0 0 354,612 186,515 354,612 479,000 479,000 525.01-03-00 OVERTIME 0 0 15,000 3,002 15,000 20,000 20,000 525.01-05-00 SEASONAL WAGES 0 0 0 24,173 0 50,000 50,000 525.01-21-00 FICA & MEDICARE 0 0 27,128 16,650 27,128 37,000 37,000 525.01-22-00 RETIREMENT 0 0 50,355 27,406 50,355 81,000 81,000 525.01-41-00 MEMBERSHIPS / SUBSCRIPTI 0 0 500 74 500 1,000 1,000 525.01-41-02 PROFESSIONAL DEVELOPMENT 0 0 3,500 2,996 3,500 4,000 4,000 TOTAL PERSONNEL 0 0 451,095 260,815 451,095 672,000 672,000 INSURANCE 525.02-02-00 HEALTH & UNEMPLOY INSURA 0 0 64,401 37,588 64,401 73,000 73,000 525.02-04-00 WORKERS COMPENSATION 0 0 30,000 10,113 30,000 31,000 31,000 TOTAL INSURANCE 0 0 94,401 47,701 94,401 104,000 104,000 UTILITIES 525.03-01-00 OFFICE PHONES 0 0 1,200 2,458 1,200 2,000 2,000 525.03-02-00 ELECTRICITY 0 0 8,000 4,614 8,000 8,000 8,000 525.03-04-00 WATER SERVICE / DRINKING 0 0 3,500 13,591 3,500 4,000 4,000 525.03-05-00 MOBILE PHONES / DATA 0 0 1,000 175 1,000 1,000 1,000 525.03-08-00 CABLE / INTERNET 0 0 0 0 0 1,000 1,000 525.03-09-00 SOLID WASTE / RECYCLING 0 0 1,000 932 1,000 1,000 1,000 TOTAL UTILITIES 0 0 14,700 21,771 14,700 17,000 17,000 CAPITAL EXPENDITURES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL OTHER PURCHASES 525.05-01-00 OFFICE SUPPLIES/CONSUMAB 0 0 500 473 500 2,000 2,000 525.05-02-00 POSTAGE 0 0 75 35 75 1,000 1,000 525.05-04-00 Printing 0 0 1,500 1,527 1,500 2,000 2,000 525.05-05-00 PUBLICATIONS 0 0 0 119 0 0 0 525.05-20-00 SMALL OFFICE EQUIPMENT 0 0 250 331 250 1,000 1,000 525.05-21-00 EQUIP/MATERIALS/TOOLS 0 0 7,500 2,988 7,500 8,000 8,000 525.05-31-00 UNIFORMS / CLOTHING 0 0 2,000 978 2,000 2,000 2,000 525.05-41-01 PARK RESTROOM SUPPLIES 0 0 4,000 2,570 4,000 4,000 4,000 525.05-41-02 PARKS TRASH BAGS 0 0 4,000 2,788 4,000 4,000 4,000 525.05-41-03 PARK ENHANCEMENTS 0 2,888 15,000 6,891 15,000 15,000 15,000 525.05-42-00 PARKS GRASS SEED&FERTILI 0 0 7,000 2,095 7,000 7,000 7,000 525.05-99-00 MISC/OTHER PURCHASES 0 0 250 2,140 250 1,000 1,000 TOTAL OTHER PURCHASES 0 2,888 42,075 22,935 42,075 47,000 47,000 39 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 41 -Park Sales Tax Fund PARKS EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ MAINTENANCE 525.06-01-00 BUILDING MAINT & REPAIR 0 0 10,000 9,357 10,000 10,000 10,000 525.06-02-00 JANITORIAL / CLEANING SE 0 0 0 0 0 2,000 2,000 525.06-03-00 PARKS RESTROOM MAINTENAN 0 0 8,000 2,985 8,000 7,000 7,000 525.06-05-01 PARKS STAGE MAINTENANCE 0 0 300 0 300 1,000 1,000 525.06-05-02 PARKS BALLFIELD MAINTENA 0 0 6,000 302 6,000 6,000 6,000 525.06-05-03 PARKS TRAIL MAINTENANCE 0 0 5,000 5,114 5,000 6,000 6,000 525.06-11-00 TRAIN DEPOT MAINTENANCE 0 0 5,000 0 5,000 10,000 10,000 525.06-12-00 PLAYGROUND EQUIPMENT&REP 0 0 3,000 5,176 3,000 3,000 3,000 525.06-13-00 PARKS SPIRIT FOUNTAIN MA 0 0 2,500 3,080 2,500 3,000 3,000 525.06-21-00 VEHICLE MAINT & REPAIR 0 0 8,000 4,208 8,000 8,000 8,000 525.06-21-01 EQIUPMENT MAINT & REPAIR 0 0 3,500 3,538 3,500 4,000 4,000 525.06-21-02 PARKS-TRACTOR/MOWING EQU 0 0 9,000 1,432 9,000 9,000 9,000 525.06-22-00 VEHICLE GAS & OIL 0 0 4,000 3,124 4,000 4,000 4,000 525.06-22-01 EQUIPMENT GAS & OIL 0 0 3,000 3,041 3,000 3,000 3,000 TOTAL MAINTENANCE 0 0 67,300 41,356 67,300 76,000 76,000 CITY SERVICES 525.07-20-00 PARKS-PORTABLE TOILET RE 0 0 13,000 9,429 13,000 13,000 13,000 525.07-51-00 PARKS-MOSQUITO&WEED CONT 0 0 10,000 13,349 10,000 10,000 10,000 525.07-51-01 PARKS LANDSCAPING SUPPLI 0 0 4,000 693 4,000 5,000 5,000 525.07-52-00 PARKS TREE TRIMMING&REMO 0 0 25,000 4,350 25,000 25,000 25,000 525.07-53-00 PARKS-TREE PLANTING 0 0 6,000 2,242 6,000 6,000 6,000 525.07-60-00 PARKS-RENTAL EQUIPMENT 0 0 500 886 500 1,000 1,000 TOTAL CITY SERVICES 0 0 58,500 30,948 58,500 60,000 60,000 PROFESSIONAL FEES 525.08-03-00 ENGINEERING & PLANNING F 0 0 20,000 3,500 20,000 20,000 20,000 TOTAL PROFESSIONAL FEES 0 0 20,000 3,500 20,000 20,000 20,000 OTHER EXPENDITURES 525.09-21-00 PARKS - MISCELLANEOUS EX 0 0 1,000 468 1,000 3,000 3,000 TOTAL OTHER EXPENDITURES 0 0 1,000 468 1,000 3,000 3,000 TOTAL PARKS 0 2,888 749,071 429,494 749,071 999,000 999,000 TRANSFERS-OTHER SOURCES 550.20-10-00 Transfer to General Fund 41,200 92,436 0 0 0 0 0 TOTAL TRANSFERS-OTHER SOURCES 41,200 92,436 0 0 0 0 0 TOTAL TRANSFERS OUT 41,200 92,436 0 0 0 0 0 40 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 41 -Park Sales Tax Fund CAPITAL OUTLAY EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY 560.52-50-00 Parks Projects Capital O 218,667 486,965 478,500 190,524 478,500 496,000 496,000 TOTAL CAPITAL OUTLAY 218,667 486,965 478,500 190,524 478,500 496,000 496,000 TOTAL CAPITAL OUTLAY 218,667 486,965 478,500 190,524 478,500 496,000 496,000 TOTAL EXPENDITURES 354,499 600,877 1,247,571 622,718 1,247,571 1,495,000 1,495,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 318,173 241,970 ( 86,571) 772,875 492,172 ( 56,000) ( 56,000) =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 41 of 103 Category 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Taxes -$ 229,929$ 966,000$ 995,000$ 1,025,000$ 1,056,000$ 1,088,000$ Other - - 3,000 3,000 4,000 4,000 4,000 Transfers - - 1,500,000 1,545,000 1,591,000 1,639,000 1,688,000 Total Revenues - 229,929 2,469,000 2,543,000 2,620,000 2,699,000 2,780,000 Salary and Benefits - - 2,099,500 2,183,000 2,227,000 2,272,000 2,317,000 Operating - - 214,000 218,000 222,000 226,000 231,000 Leases - - 86,500 50,000 50,000 50,000 50,000 Capital - - - - - - - Total Expenditures - - 2,400,000 2,451,000 2,499,000 2,548,000 2,598,000 Increase (decrease)- 229,929 69,000 92,000 121,000 151,000 182,000 Beginning Fund Balance - - 229,929 298,929 390,929 511,929 662,929 Ending Fund Balance -$ 229,929$ 298,929$ 390,929$ 511,929$ 662,929$ 844,929$ Fund Balance % (of OPS)0%0%12%16%20%26%33% Revenues Expenditures City of Parkville, Missouri Public Safety Sales Tax (42) 2024 Adopted Budget 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\42 Police fund forecast 11.13.23_FINAL 11/14/2023 42 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 42 -POLICE SALES TAX FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY SALES TAXES 0 0 0 0 229,929 966,000 966,000 COURT REVENUE 0 0 0 0 0 3,000 3,000 TRANSFERS IN 0 0 0 0 0 1,500,000 1,500,000 TOTAL REVENUES 0 0 0 0 229,929 2,469,000 2,469,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY POLICE DEPARTMENT 0 0 0 0 0 2,400,000 2,400,000 TOTAL EXPENDITURES 0 0 0 0 0 2,400,000 2,400,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 0 0 0 0 229,929 69,000 69,000 =========== =========== =========== =========== =========== ============ ============ 43 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 42 -POLICE SALES TAX FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ SALES TAXES 41404-00 POLICE SALES TAX 0 0 0 0 229,929 966,000 966,000 TOTAL SALES TAXES 0 0 0 0 229,929 966,000 966,000 COURT REVENUE 41603-00 POLICE REPORTS 0 0 0 0 0 3,000 3,000 TOTAL COURT REVENUE 0 0 0 0 0 3,000 3,000 INTEREST INCOME ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL MISCELLANEOUS REVENUE ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL TRANSFERS IN 41901-00 TRANSFER FROM GENERAL FUND 0 0 0 0 0 1,500,000 1,500,000 TOTAL TRANSFERS IN 0 0 0 0 0 1,500,000 1,500,000 TRANSFERS ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL REVENUES 0 0 0 0 229,929 2,469,000 2,469,000 =========== =========== =========== =========== =========== ============ ============ 44 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 42 -POLICE SALES TAX POLICE DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 505.01-01-00 SALARIES 0 0 0 0 0 1,352,000 1,352,000 505.01-03-00 POLICE OVERTIME 0 0 0 0 0 50,000 50,000 TOTAL PERSONNEL 0 0 0 0 0 1,402,000 1,402,000 INSURANCE 505.02-02-00 HEALTH LIFE DENTAL INSUR 0 0 0 0 0 225,000 225,000 505.02-03-00 WORKERS COMPENSATION 0 0 0 0 0 80,000 80,000 505.02-21-00 FICA & MEDICARE 0 0 0 0 0 100,000 100,000 505.02-22-00 RETIREMENT 0 0 0 0 0 291,000 291,000 505.02-34-00 PHONE ALLOWANCE 0 0 0 0 0 1,500 1,500 505.02-41-00 MEMBERSHIP FEES/DUES 0 0 0 0 0 1,000 1,000 505.02-42-00 PROFESSIONAL DEVELOPMENT 0 0 0 0 0 5,000 5,000 TOTAL INSURANCE 0 0 0 0 0 703,500 703,500 UTILITIES 505.03-01-00 TELEPHONE SERVICES 0 0 0 0 0 2,500 2,500 505.03-02-00 ELECTRICITY SERVICES 0 0 0 0 0 1,500 1,500 505.03-04-00 WATER SERVICE 0 0 0 0 0 600 600 505.03-05-00 MOBILE PHONES & DATA SER 0 0 0 0 0 5,000 5,000 505.03-06-00 INTERNET SERVICE 0 0 0 0 0 2,000 2,000 TOTAL UTILITIES 0 0 0 0 0 11,600 11,600 CAPITAL EXPENDITURES 505.04-01-00 Vehicle 0 0 0 0 0 67,000 67,000 TOTAL CAPITAL EXPENDITURES 0 0 0 0 0 67,000 67,000 OTHER PURCHASES 505.05-01-00 OFFICE SUPPLIES/CONSUMAB 0 0 0 0 0 3,000 3,000 505.05-02-00 POSTAGE & PRINTING 0 0 0 0 0 2,000 2,000 505.05-20-00 SMALL OFFICE EQUIPMENT 0 0 0 0 0 1,000 1,000 505.05-21-00 EQUIPMENT & HANDTOOLS 0 0 0 0 0 23,400 23,400 505.05-22-00 DATA TERMINAL 0 0 0 0 0 7,000 7,000 505.05-30-00 UNIFORMS 0 0 0 0 0 7,000 7,000 505.05-99-00 OTHER/MISC PURCHASES 0 0 0 0 0 1,000 1,000 TOTAL OTHER PURCHASES 0 0 0 0 0 44,400 44,400 MAINTENANCE 505.06-00-00 Lease/Rent Payments 0 0 0 0 0 17,500 17,500 505.06-20-00 VEHICLE REPAIR & MAINTEN 0 0 0 0 0 20,000 20,000 505.06-21-00 EQUIPMENT REPAIR & MAINT 0 0 0 0 0 5,000 5,000 505.06-22-00 VEHICLE GAS & OIL 0 0 0 0 0 45,000 45,000 505.06-32-00 CRIMESTAR MAINTENANCE 0 0 0 0 0 2,000 2,000 505.06-34-00 OFFICE EQUIP MAINTENANCE 0 0 0 0 0 1,000 1,000 TOTAL MAINTENANCE 0 0 0 0 0 90,500 90,500 45 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 42 -POLICE SALES TAX POLICE DEPARTMENT EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CITY SERVICES 505.07-01-00 HIRING EXPENSES / RECRUI 0 0 0 0 0 20,000 20,000 505.07-02-00 CRIME COMMISSION 0 0 0 0 0 2,000 2,000 505.07-03-00 LAB WORK / CRIME SCENE 0 0 0 0 0 2,000 2,000 505.07-04-00 CONTRACTUAL SERVICE AGRE 0 0 0 0 0 2,000 2,000 505.07-05-00 OTHER/MISC CITY SERVICES 0 0 0 0 0 2,000 2,000 TOTAL CITY SERVICES 0 0 0 0 0 28,000 28,000 OTHER EXPENDITURES 505.09-21-00 MISCELLANEOUS 0 0 0 0 0 51,000 51,000 505.09-22-00 HARVESTER DEER DONATIONS 0 0 0 0 0 2,000 2,000 TOTAL OTHER EXPENDITURES 0 0 0 0 0 53,000 53,000 TOTAL POLICE DEPARTMENT 0 0 0 0 0 2,400,000 2,400,000 TOTAL EXPENDITURES 0 2,400,000 2,400,0000 =========== 0 =========== 0 =========== 0 =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 229,929 69,000 69,0000 =========== 0 =========== 0 =========== 0 =========== =========== ============ ============ *** END OF REPORT *** 46 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Program Revenue - - - - - - - - Donations/Grants - - - - - - - - Interest 1,399$ 1,500$ 1,500$ 5,000$ 5,000$ 5,000$ 5,000$ 5,000$ Total Revenues 1,399 1,500 1,500 5,000 5,000 5,000 5,000 5,000 Operating 144 - 118 150 150 150 150 150 Capital - 24,019 23,937 28,355 - - - - Transfers Out - - - - - - - - Total Expenditures 144 24,019 24,055 28,505 150 150 150 150 Increase (decrease)1,255 (22,519) (22,555) (23,505) 4,850 4,850 4,850 4,850 Beginning Fund Balance 601,173 602,673 602,428 579,873 556,368 561,218 566,068 570,918 Ending Fund Balance 602,428$ 580,154$ 579,873$ 556,368$ 561,218$ 566,068$ 570,918$ 575,768$ Required Minimum 525,000$ 525,000$ 525,000$ 525,000$ 525,000$ 525,000$ 525,000$ 525,000$ Fund % of Required Minimum 115%111%110%106%107%108%109%110% Expenditures Revenues City of Parkville, Missouri Fewson Fund (45) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\Minor Funds Forecast_11.13.2023_FINAL 11/14/2023 47 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 45 -Fewson Project Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY INTEREST INCOME 3,843 1,399 1,500 3,373 1,500 5,000 5,000 TOTAL REVENUES 3,843 1,399 1,500 3,373 1,500 5,000 5,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 1,900 144 24,019 118 24,055 28,505 28,505 TOTAL EXPENDITURES 1,900 144 24,019 118 24,055 28,505 28,505 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 1,943 1,255 ( 22,519) 3,255 ( 22,555) ( 23,505) ( 23,505) =========== =========== =========== =========== =========== ============ ============ 48 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 45 -Fewson Project Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ INTEREST INCOME 41701-01 Interest Income 3,843 1,399 1,500 3,373 1,500 5,000 5,000 TOTAL INTEREST INCOME 3,843 1,399 1,500 3,373 1,500 5,000 5,000 TOTAL REVENUES 3,843 1,399 1,500 3,373 1,500 5,000 5,000 =========== =========== =========== =========== =========== ============ ============ 49 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E PAGE: 3 ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 45 -Fewson Project Fund GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL EXPENDITURES 501.04-01-00 Capital Expenditures 0 0 0 0 24,055 28,355 28,355 TOTAL CAPITAL EXPENDITURES 0 0 0 0 24,055 28,355 28,355 OTHER EXPENDITURES 501.09-50-00 Loss on Investment 1,728 0 0 0 0 0 0 501.09-50-01 Trust Fees 172 144 0 118 0 150 150 TOTAL OTHER EXPENDITURES 1,900 144 0 118 0 150 150 TRANSFERS-OTHER SOURCES 501.20-01-00 Transfer to General Fund 0 0 24,019 0 0 0 0 TOTAL TRANSFERS-OTHER SOURCES 0 0 24,019 0 0 0 0 TOTAL GENERAL 1,900 144 24,019 118 24,055 28,505 28,505 TOTAL EXPENDITURES 1,900 144 24,019 118 24,055 28,505 28,505 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 1,943 1,255 ( 22,519) 3,255 ( 22,555) ( 23,505) ( 23,505) =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 50 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Guest Room Tax 56,738$ 58,000$ 65,000$ 68,000$ 69,000$ 70,000$ 71,000$ 72,000$ Interest - - - - - - - - Total Revenues 56,738 58,000 65,000 68,000 69,000 70,000 71,000 72,001 Operating 6,875 35,000 35,000 23,000 23,000 23,000 23,000 23,000 Developer Reimbursement 37,936 40,000 40,000 45,000 52,000 53,000 53,000 54,000 Total Expenditures 44,811 75,000 75,000 68,000 75,000 76,000 76,000 77,000 Increase (decrease)11,927 (17,000) (10,000) - (6,000) (6,000) (5,000) (4,999) Net Change to FB 11,927 (17,000) (10,000) - (6,000) (6,000) (5,000) (4,999) Beginning FB 8,946 17,546 20,873 10,873 10,873 4,873 (1,127) (6,127) Ending FB 20,873$ 546$ 10,873$ 10,873$ 4,873$ (1,127)$ (6,127)$ (11,126)$ Revenues Expenditures City of Parkville, Missouri Economic Development Fund (46) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\Minor Funds Forecast_11.13.2023_FINAL 11/14/2023 51 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 46 -Guest Room Tax Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TAXES 6,410 56,738 58,000 61,889 65,000 68,000 68,000 TOTAL REVENUES 6,410 56,738 58,000 61,889 65,000 68,000 68,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 1,000 44,811 75,000 51,085 75,000 68,000 68,000 TOTAL EXPENDITURES 1,000 44,811 75,000 51,085 75,000 68,000 68,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 5,410 11,926 ( 17,000) 10,804 ( 10,000)0 0 =========== =========== =========== =========== =========== ============ ============ 52 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 46 -Guest Room Tax Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TAXES 41001-00 Guest Room Tax 6,410 56,738 58,000 61,889 65,000 68,000 68,000 TOTAL TAXES 6,410 56,738 58,000 61,889 65,000 68,000 68,000 PERMITS ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL REVENUES 6,410 56,738 58,000 61,889 65,000 68,000 68,000 =========== =========== =========== =========== =========== ============ ============ 53 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 46 -Guest Room Tax Fund GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CITY SERVICES 501.07-02-00 Advertising 1,000 1,875 10,000 0 0 8,000 8,000 501.07-03-00 Economic Development 0 5,000 25,000 15,000 35,000 60,000 60,000 TOTAL CITY SERVICES 1,000 6,875 35,000 15,000 35,000 68,000 68,000 TRANSFERS-OTHER SOURCES 501.20-00-00 Tfr to TIF Special Alloc 0 37,936 40,000 36,085 40,000 0 0 TOTAL TRANSFERS-OTHER SOURCES 0 37,936 40,000 36,085 40,000 0 0 TOTAL GENERAL 1,000 44,811 75,000 51,085 75,000 68,000 68,000 TOTAL EXPENDITURES 1,000 44,811 75,000 51,085 75,000 68,000 68,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 5,410 11,926 ( 17,000) 10,804 ( 10,000)0 0 =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 54 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Taxes 112,500$ 115,875$ 119,000$ 123,000$ 127,000$ Other Total Revenues - - - 112,500 115,875 119,000 123,000 127,000 Projects (Storm-water, etc)50,000 50,000 50,000 50,000 50,000 Transfers out - 128,000 69,000 73,000 77,000 Total Expenditures - - - 50,000 178,000 119,000 123,000 127,000 Increase (decrease)- - - 62,500 (62,125) - - - Beginning FB - - - - 62,500 375 375 375 Ending FB -$ -$ -$ 62,500$ 375$ 375$ 375$ 375$ Fund Balance % (of OPS)0%0%0%0%0%1%1%0% Expenditures City of Parkville, Missouri Marijuana Sales Tax (47) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Revenues M:\Budgets\2024\working folder\Financial forecast\47 Weed Fund 11.13.23_FINAL 11/14/2023 55 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 47 -Marijuana Sales Tax FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY SALES TAXES 0 0 0 0 0 112,500 112,500 TOTAL REVENUES 0 0 0 0 0 112,500 112,500 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY Administration 0 0 0 0 0 50,000 50,000 TOTAL EXPENDITURES 0 0 0 0 0 50,000 50,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 0 0 0 0 0 62,500 62,500 =========== =========== =========== =========== =========== ============ ============ 56 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 47 -Marijuana Sales Tax FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ SALES TAXES 41401-03 Sales Tax - Marijuana 0 0 0 0 0 112,500 112,500 TOTAL SALES TAXES 0 0 0 0 0 112,500 112,500 TOTAL REVENUES 0 0 0 0 0 112,500 112,500 =========== =========== =========== =========== =========== ============ ============ 57 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 47 -Marijuana Sales Tax Administration EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL EXPENDITURES 501.04-01-00 Capital Projects 0 0 0 0 0 50,000 50,000 TOTAL CAPITAL EXPENDITURES 0 0 0 0 0 50,000 50,000 TRANSFERS-OTHER SOURCES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL Administration 0 0 0 0 0 50,000 50,000 TOTAL EXPENDITURES 0 0 0 0 0 50,000 50,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 0 0 0 0 0 62,500 62,500 =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 58 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Taxes 350,000$ 361,000$ 372,000$ 383,000$ 394,000$ Other Total Revenues - - - 350,000 361,000 372,000 383,000 394,000 Park Trail Maint & Capital 70,000 72,200 74,400 76,600 78,800 Street Capital 224,000 231,000 238,100 245,100 252,200 Street Maintenance 56,000 57,800 59,500 61,300 63,000 Total Expenditures - - - 350,000 361,000 372,000 383,000 394,000 Increase (decrease)- - - - - - - - Beginning FB - - - - - - - - Ending FB -$ -$ -$ -$ -$ -$ -$ -$ Fund Balance % (of OPS)0%0%0%0%0%0%0%0% Expenditures City of Parkville, Missouri Use Tax Fund (48) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Revenues M:\Budgets\2024\working folder\Financial forecast\48 Use Tax Fund 11.13.23_FINAL 11/14/2023 59 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 48 -Use Tax FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY SALES TAXES 0 0 0 0 0 262,500 262,500 TOTAL REVENUES 0 0 0 0 0 262,500 262,500 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY Administration 0 0 0 0 0 262,500 262,500 TOTAL EXPENDITURES 0 0 0 0 0 262,500 262,500 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER =========== =========== =========== =========== =========== ============ ============ 60 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 48 -Use Tax FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ SALES TAXES 41401-04 Use Tax Received 0 0 0 0 0 262,500 262,500 TOTAL SALES TAXES 0 0 0 0 0 262,500 262,500 TOTAL REVENUES 0 0 0 0 0 262,500 262,500 =========== =========== =========== =========== =========== ============ ============ 61 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 48 -Use Tax Administration EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL EXPENDITURES 501.04-01-00 Capital Projects - Use T 0 0 0 0 0 262,500 262,500 TOTAL CAPITAL EXPENDITURES 0 0 0 0 0 262,500 262,500 TRANSFERS-OTHER SOURCES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL Administration 0 0 0 0 0 262,500 262,500 TOTAL EXPENDITURES 0 0 0 0 0 262,500 262,500 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 62 of 103 Category 2022 Unaudited 2023 Budget 2023 revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Transfers -$ -$ -$ 118,000$ -$ -$ -$ -$ Total Revenues - - - 118,000 - - - - Transfers Out - - - - - - - - Total Expenditures - - - - - - - - Increase (decrease)- - - 118,000 - - - - Net Change to FB - - - 118,000 - - - - Beginning FB 1,332,108 1,332,108 1,332,108 1,332,108 1,450,108 1,450,108 1,450,108 1,450,108 Ending FB 1,332,108 1,332,108 1,332,108 1,450,108 1,450,108 1,450,108 1,450,108 1,450,108 General Fund Expenditures 5,606,260$ 6,014,029$ 6,014,029$ 5,878,000$ 5,808,150$ 5,982,395$ 6,161,866$ 6,346,722$ Fund Balance % of Gen. Fund 24%22%22%25%25%24%24%23% Revenues Expenditures City of Parkville, Missouri Emergency Reserve Fund (50) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\Minor Funds Forecast_11.13.2023_FINAL 11/14/2023 63 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 50 -Emergency Reserve Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TRANSFERS 0 0 0 0 0 118,000 118,000 TOTAL REVENUES 0 0 0 0 0 118,000 118,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY ___________ ___________ ___________ ___________ ___________ ____________ ____________ =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 0 0 0 0 0 118,000 118,000 =========== =========== =========== =========== =========== ============ ============ 64 of 103 ` Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Program Revenue 6,890$ 5,500$ 5,500$ 5,500$ 5,500$ -$ -$ -$ Donations/Grants - 4,500 4,500 4,500 4,500 - - - Transfers - 63,000 63,000 - - - - - Total Revenues 6,890 73,000 73,000 10,000 10,000 - - - Salary and Benefits - 74,119 74,000 - - - - - Operating 8,261 13,135 17,200 26,000 - - - - Equipment - - - - - - - - Capital - 94,000 90,000 46,000 102,814 - - - Total Expenditures 8,261 181,254 181,200 72,000 102,814 - - - Increase (decrease)(1,371) (108,254) (108,200) (62,000) (92,814) - - - Beginning FB 264,385 142,832 263,014 154,814 92,814 - - - Ending FB 263,014$ 34,578$ 154,814$ 92,814$ 0$ -$ -$ -$ Revenues Expenditures City of Parkville, Missouri Parkville Nature Sanctuary (60) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\60 Parkville Nature Sanctuary forecast 11.13.23_FINAL 11/14/2023 65 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 60 -Nature Sanctuary Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY DONATIONS 10,854 6,890 10,000 3,467 10,000 10,000 10,000 TRANSFERS 0 0 63,000 47,250 63,000 0 0 TOTAL REVENUES 10,854 6,890 73,000 50,717 73,000 10,000 10,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 4,190 8,261 94,000 55 94,000 0 0 NATURE SANCTUARY 0 0 87,254 67,984 87,254 72,000 72,000 TOTAL EXPENDITURES 4,190 8,261 181,254 68,039 181,254 72,000 72,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 6,664 ( 1,372) ( 108,254) ( 17,321) ( 108,254) ( 62,000) ( 62,000) =========== =========== =========== =========== =========== ============ ============ 66 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 60 -Nature Sanctuary Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ DONATIONS 40901-00 Donations 5,486 6,928 4,500 4,171 4,500 0 0 40903-00 Programs 4,414 ( 1,308) 5,500 ( 809) 5,500 5,500 5,500 40906-00 Girl Scout Cabin Rental 310 140 0 105 0 0 0 40910-00 Grants 644 1,130 0 0 0 4,500 4,500 TOTAL DONATIONS 10,854 6,890 10,000 3,467 10,000 10,000 10,000 TRANSFERS 42001-00 TRSF TO PNS FROM GF 0 0 63,000 47,250 63,000 0 0 TOTAL TRANSFERS 0 0 63,000 47,250 63,000 0 0 TOTAL REVENUES 10,854 6,890 73,000 50,717 73,000 10,000 10,000 =========== =========== =========== =========== =========== ============ ============ 67 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 60 -Nature Sanctuary Fund GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL EXPENDITURES 501.04-31-00 CIP Equipment 0 0 0 0 90,000 0 0 501.04-41-00 CIP Projects 0 0 90,000 0 0 0 0 TOTAL CAPITAL EXPENDITURES 0 0 90,000 0 90,000 0 0 OTHER PURCHASES 501.05-42-00 Program Expenses 4,190 8,261 4,000 55 4,000 0 0 TOTAL OTHER PURCHASES 4,190 8,261 4,000 55 4,000 0 0 TOTAL GENERAL 4,190 8,261 94,000 55 94,000 0 0 68 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 60 -Nature Sanctuary Fund NATURE SANCTUARY EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 535.01-01-00 SALARIES 0 0 52,104 45,406 52,104 0 0 535.01-03-00 OVERTIME 0 0 3,600 173 3,600 0 0 535.01-21-00 FICA & MEDICARE 0 0 3,986 3,457 3,986 0 0 535.01-22-00 RETIREMENT 0 0 7,399 5,422 7,399 0 0 535.01-41-00 MEMBERSHIPS / SUBSCRIPTI 0 0 0 0 0 1,000 1,000 535.01-41-02 PROFESSIONAL DEVELOPMENT 0 0 0 212 0 2,000 2,000 TOTAL PERSONNEL 0 0 67,089 54,669 67,089 3,000 3,000 INSURANCE 535.02-02-00 HEALTH & UNEMPLOY INSURA 0 0 6,030 4,763 6,030 0 0 535.02-04-00 WORKERS COMPENSATION 0 0 1,000 0 1,000 0 0 TOTAL INSURANCE 0 0 7,030 4,763 7,030 0 0 UTILITIES 535.03-02-00 ELECTRICITY 0 0 250 134 250 500 500 535.03-05-00 MOBILE PHONES & PAGERS 0 0 0 251 0 500 500 TOTAL UTILITIES 0 0 250 384 250 1,000 1,000 OTHER PURCHASES 535.05-01-00 OFFICE SUPPLIES/CONSUMAB 0 0 250 164 250 500 500 535.05-02-00 POSTAGE 0 0 35 10 35 500 500 535.05-04-00 PRINTING 0 0 200 0 200 500 500 535.05-21-00 EQUIP/MATERIALS/TOOLS 0 0 2,000 1,013 2,000 2,500 2,500 535.05-31-00 UNIFORMS / CLOTHING 0 0 0 0 0 1,000 1,000 535.05-41-00 MATERIALS 0 0 2,000 559 2,000 2,000 2,000 535.05-42-00 PROGRAM EXPENSE 0 0 0 96 0 5,000 5,000 535.05-43-00 VOLUNTEER ACKNOWLEDGEMEN 0 0 1,500 438 1,500 2,000 2,000 535.05-99-00 MISC/OTHER PURCHASES 0 0 0 18 0 0 0 TOTAL OTHER PURCHASES 0 0 5,985 2,299 5,985 14,000 14,000 MAINTENANCE 535.06-01-00 BUILDING MAINT & REPAIR 0 0 500 594 500 500 500 535.06-05-03 TRAIL MAINTENANCE 0 0 3,500 4,208 3,500 3,500 3,500 535.06-21-00 VEHICLE MAINT & REPAIR 0 0 1,000 440 1,000 1,000 1,000 535.06-21-01 EQIUPMENT MAINT & REPAIR 0 0 1,000 0 1,000 1,000 1,000 535.06-22-00 VEHICLE GAS & OIL 0 0 400 540 400 500 500 TOTAL MAINTENANCE 0 0 6,400 5,782 6,400 6,500 6,500 OTHER EXPENDITURES 535.09-21-00 MISCELLANEOUS 0 0 500 86 500 1,500 1,500 TOTAL OTHER EXPENDITURES 0 0 500 86 500 1,500 1,500 69 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 60 -Nature Sanctuary Fund NATURE SANCTUARY EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY 535.53-50-00 Nature Sanctuary CIP 0 0 0 0 0 46,000 46,000 TOTAL CAPITAL OUTLAY 0 0 0 0 0 46,000 46,000 TOTAL NATURE SANCTUARY 0 0 87,254 67,984 87,254 72,000 72,000 TOTAL EXPENDITURES 4,190 8,261 181,254 68,039 181,254 72,000 72,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 6,664 ( 1,372) ( 108,254) ( 17,321) ( 108,254) ( 62,000) ( 62,000) =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 70 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Donations 31,688$ 40,000$ 40,000$ 59,483$ -$ -$ -$ -$ Total Revenues 31,688 40,000 40,000 59,483 - - - - Operating 5,600 40,000 40,000 100,000 - - - - Capital - 84,829 40,000 - - - - - Total Expenditures 5,600 124,829 80,000 100,000 - - - - Increase (decrease)26,088 (84,829) (40,000) (40,517) - - - - Net Change to FB 26,088 (84,829) (40,000) (40,517) - - - - Beginning FB 54,429 84,829 80,517 40,517 - - - -$ Ending FB 80,517$ -$ 40,517$ -$ -$ -$ -$ -$ Revenues Expenditures City of Parkville, Missouri Veterans Memorial Fund (66) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\Minor Funds Forecast_11.13.2023_FINAL 11/14/2023 71 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 66 -Veterans Memorial Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY DONATIONS 41,781 31,688 40,000 15,028 40,000 59,483 59,483 TOTAL REVENUES 41,781 31,688 40,000 15,028 40,000 59,483 59,483 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 3,350 5,600 124,829 10,249 80,000 100,000 100,000 TOTAL EXPENDITURES 3,350 5,600 124,829 10,249 80,000 100,000 100,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 38,431 26,088 ( 84,829) 4,779 ( 40,000) ( 40,517) ( 40,517) =========== =========== =========== =========== =========== ============ ============ 72 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 66 -Veterans Memorial Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ DONATIONS 40901-00 Donations 41,781 31,688 40,000 15,028 40,000 59,483 59,483 TOTAL DONATIONS 41,781 31,688 40,000 15,028 40,000 59,483 59,483 TOTAL REVENUES 41,781 31,688 40,000 15,028 40,000 59,483 59,483 =========== =========== =========== =========== =========== ============ ============ 73 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 66 -Veterans Memorial Fund GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL EXPENDITURES 501.04-24-00 CAPITAL IMPROVEMENTS 0 0 84,829 0 40,000 0 0 TOTAL CAPITAL EXPENDITURES 0 0 84,829 0 40,000 0 0 PROFESSIONAL FEES 501.08-03-00 Engineer & Planning Fees 2,750 0 0 0 0 0 0 TOTAL PROFESSIONAL FEES 2,750 0 0 0 0 0 0 EXPENDITURES 501.15-00-00 Expenditures 600 5,600 40,000 10,249 40,000 100,000 100,000 TOTAL EXPENDITURES 600 5,600 40,000 10,249 40,000 100,000 100,000 TOTAL GENERAL 3,350 5,600 124,829 10,249 80,000 100,000 100,000 TOTAL EXPENDITURES 3,350 5,600 124,829 10,249 80,000 100,000 100,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 38,431 26,088 ( 84,829) 4,779 ( 40,000) ( 40,517) ( 40,517) =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 74 of 103 Category 2022Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Grants 736,520$ -$ -$ -$ -$ -$ -$ Total Revenues 736,520 - - - - - - Capital - - - 359,114 - - - Transfers Out 325,000 500,000 500,000 - - - - Total Expenditures 325,000 500,000 500,000 359,114 - - - Increase (decrease)411,520 (500,000) (500,000) (359,114) - - - Beginning FB 447,594 859,114 859,114 359,114 - - - Ending FB 859,114$ 359,114$ 359,114$ -$ -$ -$ -$ Expenditures Revenues City of Parkville, Missouri American Rescue Plan Act (ARPA) Fund (68) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\Minor Funds Forecast_11.13.2023_FINAL 11/14/2023 75 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 68 -American Rescue Plan FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY MISCELLANEOUS REVENUE 275,000 736,520 0 0 0 0 0 TOTAL REVENUES 275,000 736,520 0 0 0 0 0 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 200,000 325,000 500,000 500,000 500,000 0 0 CITY HALL RECEPTION 0 0 0 0 0 359,114 359,114 TOTAL EXPENDITURES 200,000 325,000 500,000 500,000 500,000 359,114 359,114 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 75,000 411,520 ( 500,000) ( 500,000) ( 500,000) ( 359,114) ( 359,114) =========== =========== =========== =========== =========== ============ ============ 76 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 68 -American Rescue Plan FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ MISCELLANEOUS REVENUE 41801-06 ARPA Funds Received 275,000 736,520 0 0 0 0 0 TOTAL MISCELLANEOUS REVENUE 275,000 736,520 0 0 0 0 0 TOTAL REVENUES 275,000 736,520 0 0 0 0 0 =========== =========== =========== =========== =========== ============ ============ 77 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 68 -American Rescue Plan GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TRANSFERS-OTHER SOURCES 501.20-10-00 TRSF ANNUAL APRA TO GF 0 0 500,000 500,000 500,000 0 0 501.20-20-00 Tfr to Transportation Fu 200,000 0 0 0 0 0 0 501.20-22-00 Transfer to Projects Fun 0 325,000 0 0 0 0 0 TOTAL TRANSFERS-OTHER SOURCES 200,000 325,000 500,000 500,000 500,000 0 0 TOTAL GENERAL 200,000 325,000 500,000 500,000 500,000 0 0 78 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 68 -American Rescue Plan CITY HALL RECEPTION EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY 560.50-10-00 Capital Outlay 0 0 0 0 0 359,114 359,114 TOTAL CAPITAL OUTLAY 0 0 0 0 0 359,114 359,114 TOTAL CITY HALL RECEPTION 0 0 0 0 0 359,114 359,114 TOTAL EXPENDITURES 200,000 325,000 500,000 500,000 500,000 359,114 359,114 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 75,000 411,520 ( 500,000) ( 500,000) ( 500,000) ( 359,114) ( 359,114) =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 79 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Bond Proceeds -$ -$ -$ -$ -$ -$ -$ - Grants - 500,000 1,398,582 - - - - - Miscellaneous - - - - - - - - Transfers 325,000 - - - - - - - Total Revenues 325,000 500,000 1,398,582 - - - - - Route 9 Project (Hwy 45)1,504,399 - 23,580 340,880 - - - - Downtown Entryway 1,649 - - - - - - - Quiet Zone - - 8,484 29,000 - - - - Transfers Out - - - - - - - - Total Expenditures 1,506,048 - 32,064 369,880 - - - - Increase (decrease)(1,181,048) 500,000 1,366,518 (369,880) - - - - Beginning FB 272,410 (365,390) (908,638) 457,880 88,000$ 88,000 88,000 - Ending FB (908,638)$ 134,610$ 457,880$ 88,000$ 88,000$ 88,000$ 88,000$ -$ Revenues Expenditures City of Parkville, Missouri Capital Projects Fund (95) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\Minor Funds Forecast_11.13.2023_FINAL 11/14/2023 80 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 95 -Capital Projects Fund FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY OTHER REVENUE 4,683,962 1,310,918 0 1,398,582 1,398,582 0 0 COURT REVENUE 89,300 325,000 500,000 0 0 0 0 MISCELLANEOUS REVENUE 16,000 0 0 0 0 0 0 TOTAL REVENUES 4,789,262 1,635,918 500,000 1,398,582 1,398,582 0 0 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 1,000,538 1,649 0 8,484 32,064 29,000 29,000 PUBLIC WORKS 3,121,974 1,504,399 0 23,580 0 340,880 340,880 STREETS 6,650 0 0 0 0 0 0 TOTAL EXPENDITURES 4,129,162 1,506,048 0 32,064 32,064 369,880 369,880 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 660,100 129,870 500,000 1,366,518 1,366,518 ( 369,880) ( 369,880) =========== =========== =========== =========== =========== ============ ============ 81 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 95 -Capital Projects Fund FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ OTHER REVENUE 41501-00 Money Recvd from Hwy 9 Project 0 1,310,918 0 1,398,582 1,398,582 0 0 41502-00 Money recd Hwy9 proj-6th St 1,591,180 0 0 0 0 0 0 41503-00 Bond Proceeds-Hwy 9 Project 2,985,000 0 0 0 0 0 0 41503-01 Bond Premium-Hwy 9 Project 107,782 0 0 0 0 0 0 TOTAL OTHER REVENUE 4,683,962 1,310,918 0 1,398,582 1,398,582 0 0 COURT REVENUE 41601-00 Trans from Park Donation Fund 14,300 0 0 0 0 0 0 41651-00 Transfer from ARPA Funds 75,000 325,000 500,000 0 0 0 0 TOTAL COURT REVENUE 89,300 325,000 500,000 0 0 0 0 MISCELLANEOUS REVENUE 41801-00 Miscellaneous Revenue 16,000 0 0 0 0 0 0 TOTAL MISCELLANEOUS REVENUE 16,000 0 0 0 0 0 0 TOTAL REVENUES 4,789,262 1,635,918 500,000 1,398,582 1,398,582 0 0 =========== =========== =========== =========== =========== ============ ============ 82 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 95 -Capital Projects Fund GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ PERSONNEL 501.01-00-00 COI Expenses 86,664 0 0 0 0 0 0 TOTAL PERSONNEL 86,664 0 0 0 0 0 0 CAPITAL EXPENDITURES 501.04-11-00 Grants/ Donations Expend 913,874 1,649 0 0 0 0 0 501.04-17-00 Community Development Pr 0 0 0 8,484 8,484 0 0 501.04-51-00 Capital Projects Expendi 0 0 0 0 0 29,000 29,000 TOTAL CAPITAL EXPENDITURES 913,874 1,649 0 8,484 8,484 29,000 29,000 TRANSFERS-OTHER SOURCES 501.20-10-00 Transfer to General Fund 0 0 0 0 23,580 0 0 TOTAL TRANSFERS-OTHER SOURCES 0 0 0 0 23,580 0 0 TOTAL GENERAL 1,000,538 1,649 0 8,484 32,064 29,000 29,000 83 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 95 -Capital Projects Fund PUBLIC WORKS EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ CAPITAL EXPENDITURES 515.04-15-00 Rt 9 Project Expenses 3,121,974 1,504,399 0 23,580 0 340,880 340,880 TOTAL CAPITAL EXPENDITURES 3,121,974 1,504,399 0 23,580 0 340,880 340,880 TOTAL PUBLIC WORKS 3,121,974 1,504,399 0 23,580 0 340,880 340,880 TOTAL EXPENDITURES 32,064 369,880 369,8804,129,162 =========== 1,506,048 =========== 0 ========== 32,064 ========== =========== =========== ========== EXCESS REVENUES OVER (UNDER) EXPENDITURES 1,366,518 ( 369,880) ( 369,880)660,100 =========== 129,870 =========== 500,000 ========== 1,366,518 ========== =========== =========== ========== *** END OF REPORT *** 84 of 103 Debt Service Summary & Individual Debt Service Fund Forecasts 85 of 103 Category 2022 Unaudit 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Fund 22 - Special Levy Property Taxes 478,386$ 509,300$ 535,300$ 527,300$ 546,300$ 300$ 300$ -$ Fund 23 - Brush Creek Special Assessments & General Fund Transfer 344,122 340,111 340,111 339,833 338,833 338,833 338,833 338,833 Fund 24 - Brink Meyer Special Assessments & General Fund Transfer 233,644 231,975 231,975 236,662 236,662 236,662 236,662 236,662 Fund 30 - Sewer Fees 178,163 192,550 192,550 184,500 2,901 - - - Fund 96 - HY 9 CID Payments and transfer 438,578 281,229 281,229 263,000 175,000 175,000 175,000 175,000 Total Revenue 1,672,893 1,555,165 1,581,165 1,551,295 1,299,696 750,795 750,795 750,495 Fund 22 - City Hall DS 427,564 553,801 463,801 658,507 337,548 127,631 150,704 - Fund 23 -Brush Creek DS 341,361 344,204 344,204 341,739 343,959 340,788 342,141 342,980 Fund 24 - Brink Meyer DS 233,665 232,202 232,202 235,545 238,668 236,489 238,978 236,123 Fund 30 - Sewer DS 178,944 182,500 177,000 179,000 30,675 - - - Fund 96 - HYW 9 DS 440,328 212,200 212,103 209,000 210,800 207,500 204,200 200,900 Total Expenditures 1,621,862 1,524,907 1,429,310 1,624,421 1,161,650 912,408 936,023 780,003 Fund 22 -City Hall Debt Svc 77,869 130,605 128,691 200,190 68,983 277,735 150,404 - Fund 23 - Brush Creek NID 19,964 17,623 22,725 18,632 16,726 11,600 9,645 6,337 Fund 24 - Brink Meyer NID 5,702 5,681 5,681 5,454 6,571 4,565 4,738 2,422 Fund 30 - Sewer Debt Svc 5,005 85 4,224 19,774 27,774 (0) (0) (0) Fund 96 - Hwy 9 Debt Svc (67,279) (69,029) (0) 69,126 123,126 87,326 54,826 25,626 Total Beginning Fund Bal.41,261 84,965 161,321 313,176 243,180 381,226 219,613 34,385 Beginning Fund Balance City of Parkville, Missouri City of Parkville Debt Service Summary - 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Revenues Expenditures 86 of 103 Debt Issue Final Maturity Source of Funds 12/31/2023 Balance 2024 Principal Payment 2024 Interest Payment 2024 Total Payment 12/31/2024 Balance Series 2015 -City Hall COP 2027 Special Prop. Tax Levy 831,135$ 444,872$ 13,635$ 458,507$ 386,263$ Series 2020A - Brush Creek 2034 Property Taxes / Spec. Assess 3,420,000 290,000 51,739 341,739 3,130,000 Series 2020B - Brink Meyer 2034 Property Taxes / Spec. Assess 2,340,000 200,000 35,545 235,545 2,140,000 Series 2021 - Hwy 9 COP 2037 Highway 9 CID 2,450,000 160,000 49,000 209,000 2,290,000 Sewer Revenue Bonds 2025 Sewer Fees 200,000 170,000 9,000 179,000 30,000 9,241,135$ 1,264,872$ 158,919$ 1,423,791$ 7,976,263$ City of Parkville, Missouri City of Parkville 2024 Debt Service Final Maturity, 2023 Balance, 2024 Principal, 2024 Interest, 2024 Total Payment, 2024 Balance Totals M:\Budgets\2024\working folder\Financial forecast\2024 Debt Service Forecast_11.13.2023_FINAL 11/14/2023 87 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Property Taxes 478,048$ 509,000$ 535,000$ 527,000$ 546,000$ -$ -$ -$ Interest Income 338 300 300 300 300 300 300 - 478,386 509,300 535,300 527,300 546,300 300 300 - Loss on Investments - - - - - - - - Bond Principal 395,103 420,474 420,474 444,872 123,277 123,119 139,867 - Bond Interest 32,461 23,327 23,327 13,635 7,271 4,512 1,567 - 2006/2015 COPS Bond Fees - - - - - - - - City Hall Capital - 110,000 20,000 200,000 207,000 - 9,270 - 427,564 553,801 463,801 658,507 337,548 127,631 150,704 - Increase (decrease)50,822 (44,501) 71,499 (131,207) 208,752 (127,331) (150,404) - Beginning Fund Balance 77,869 130,605 128,691 200,190 68,983 277,735 150,404 - Ending Fund Balance 128,691$ 86,104$ 200,190$ 68,983$ 277,735$ 150,404$ -$ -$ Total Revenue Total Expenditures Revenues Expenditures City of Parkville, Missouri Temporary Levy / 2006 Certificates of Participation (COPs) Fund (22) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\2024 Debt Service Forecast_11.13.2023_FINAL 11/14/2023 88 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 22 -Capital Project Bonds FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TAXES 451,816 478,048 509,000 533,108 535,000 527,000 527,000 INTEREST INCOME 256 338 300 0 300 300 300 TOTAL REVENUES 452,072 478,386 509,300 533,108 535,300 527,300 527,300 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 430,050 427,565 443,801 443,800 443,801 458,507 458,507 transfers 0 0 110,000 0 20,000 200,000 200,000 TOTAL EXPENDITURES 430,050 427,565 553,801 443,800 463,801 658,507 658,507 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 22,022 50,822 ( 44,501) 89,307 71,499 ( 131,207) ( 131,207) =========== =========== =========== =========== =========== ============ ============ 89 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 22 -Capital Project Bonds FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TAXES 41001-00 Property Taxes 451,816 478,048 509,000 533,108 535,000 527,000 527,000 TOTAL TAXES 451,816 478,048 509,000 533,108 535,000 527,000 527,000 INTEREST INCOME 41701-00 Interest Income 256 338 300 0 300 300 300 TOTAL INTEREST INCOME 256 338 300 0 300 300 300 TOTAL REVENUES 452,072 478,386 509,300 533,108 535,300 527,300 527,300 =========== =========== =========== =========== =========== ============ ============ 90 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 22 -Capital Project Bonds GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ BOND/LEASE PAYMENTS 501.10-01-00 2006 COPS Bond Principal 388,809 395,103 420,474 420,474 420,474 444,872 444,872 501.10-02-00 2006 COPS Bond Interest 41,241 32,461 23,327 23,327 23,327 13,635 13,635 TOTAL BOND/LEASE PAYMENTS 430,050 427,565 443,801 443,800 443,801 458,507 458,507 TOTAL GENERAL 430,050 427,565 443,801 443,800 443,801 458,507 458,507 TRANSFERS 550.00-01-00 Other Financing Sources/0 0 110,000 0 20,000 200,000 200,000 TOTAL TRANSFERS 0 0 110,000 0 20,000 200,000 200,000 TOTAL transfers 0 0 110,000 0 20,000 200,000 200,000 TOTAL EXPENDITURES 463,801 658,507 658,507430,050 =========== 427,565 =========== 553,801 =========== 443,800 =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 131,207)71,499 ( 131,207) (22,022 =========== 50,822 ( =========== 44,501) =========== 89,307 =========== =========== ============ ============ *** END OF REPORT *** 91 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Special Assessment 283,241$ 283,833$ 283,833$ 283,833$ 283,833$ 283,833$ 283,833$ 283,833$ Penalties - - - - - - - - Transfer from General 60,881 56,278 56,278 56,000 55,000 55,000 55,000 55,000 Total Revenues 344,122 340,111 340,111 339,833 338,833 338,833 338,833 338,833 Bond Principal 285,000 290,000 290,000 290,000 295,000 295,000 300,000 305,000 Bond Interest 56,061 53,904 53,904 51,439 48,659 45,488 41,841 37,680 Bond Fees 300 300 300 300 300 300 300 300 Total Expenditures 341,361 344,204 344,204 341,739 343,959 340,788 342,141 342,980 Increase (decrease)2,761 (4,093) (4,093) (1,906) (5,126) (1,955) (3,308) (4,147) Beginning Fund Balance 19,964 17,623 22,725 18,632 16,726 11,600 9,645 6,337 Ending Fund Balance 22,725$ 13,530$ 18,632$ 16,726$ 11,600$ 9,645$ 6,337$ 2,190$ Revenues Expenditures City of Parkville, Missouri Brush Creek NID Debt Service Fund (23) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast M:\Budgets\2024\working folder\Financial forecast\2024 Debt Service Forecast_11.13.2023_FINAL 11/14/2023 92 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 23 -Brush Creek NID FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TAXES 234,674 283,241 283,833 267,895 283,833 283,833 283,833 TRANSFERS IN 112,357 60,881 56,278 56,278 56,278 56,000 56,000 TOTAL REVENUES 347,031 344,122 340,111 324,173 340,111 339,833 339,833 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY Brush Creek NID 4,644,663 341,361 344,204 344,204 344,204 341,739 341,739 TOTAL EXPENDITURES 4,644,663 341,361 344,204 344,204 344,204 341,739 341,739 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES ( 4,297,632)2,760 ( 4,093) ( 20,030) ( 4,093) ( 1,906) ( 1,906) =========== =========== =========== =========== =========== ============ ============ 93 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E PAGE: 2 ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 23 -Brush Creek NID FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TAXES 41001-00 Brush Creek NID Spec Assess 234,674 283,241 283,833 267,895 283,833 283,833 283,833 TOTAL TAXES 234,674 283,241 283,833 267,895 283,833 283,833 283,833 TRANSFERS IN 41901-00 Transfers In 0 0 56,278 0 56,278 0 0 41901-01 Tfr from Gen Fd-Property Sale 112,357 60,881 0 56,278 0 56,000 56,000 TOTAL TRANSFERS IN 112,357 60,881 56,278 56,278 56,278 56,000 56,000 TOTAL REVENUES 347,031 344,122 340,111 324,173 340,111 339,833 339,833 =========== =========== =========== =========== =========== ============ ============ 94 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 23 -Brush Creek NID Brush Creek NID EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ BOND/LEASE PAYMENTS 501.10-01-00 Bond Principal 4,500,000 285,000 290,000 290,000 290,000 290,000 290,000 501.10-02-00 Bond Interest 144,363 56,061 53,904 53,904 53,904 51,439 51,439 501.10-03-00 Bond Fees 300 300 300 300 300 300 300 TOTAL BOND/LEASE PAYMENTS 4,644,663 341,361 344,204 344,204 344,204 341,739 341,739 TRANSFERS-OTHER SOURCES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL Brush Creek NID 4,644,663 341,361 344,204 344,204 344,204 341,739 341,739 TOTAL EXPENDITURES 344,204 341,739 341,7394,644,663 =========== 341,361 =========== 344,204 =========== 344,204 =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 4,093) ( 1,906) ( 1,906)( 4,297,632) =========== 2,760 ( =========== 4,093) ( =========== 20,030) ( =========== =========== ============ ============ *** END OF REPORT *** 95 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast Special Assessment 1,662$ 1,678$ 1,678$ 1,662$ 1,662$ 1,662$ 1,662$ 1,662$ Transfers 231,982 230,297 230,297 235,000 235,000 235,000 235,000 235,000 Total Revenues 233,644 231,975 231,975 236,662 236,662 236,662 236,662 236,662 Bond Principal 195,000 195,000 195,000 200,000 205,000 205,000 210,000 210,000 Bond Interest 38,365 36,902 36,902 35,245 33,368 31,189 28,678 25,823 Bond Fees 300 300 300 300 300 300 300 300 Total Expenditures 233,665 232,202 232,202 235,545 238,668 236,489 238,978 236,123 Increase (decrease)(21) (227) (227) 1,117 (2,006) 173 (2,316) 539 Beginning Fund Balance 5,702 5,681 5,681 5,454 6,571 4,565 4,738 2,422 Ending Fund Balance 5,681$ 5,454$ 5,454$ 6,571$ 4,565$ 4,738$ 2,422$ 2,961$ City of Parkville, Missouri Brink Meyer NID Debt Service Fund (24) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Expenditures Revenues 96 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 24 -Brink Meyer Road NID FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TAXES 1,683 1,662 1,678 1,662 1,678 1,662 1,662 TRANSFERS IN 247,063 231,982 230,297 230,297 230,297 235,000 235,000 TOTAL REVENUES 248,746 233,644 231,975 231,959 231,975 236,662 236,662 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY Brink Meyer Road NID 3,194,195 233,665 232,202 232,203 232,203 235,545 235,545 TOTAL EXPENDITURES 3,194,195 233,665 232,202 232,203 232,203 235,545 235,545 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES ( 2,945,449) (21)( 227) ( 244) ( 228) 1,117 1,117 =========== =========== =========== =========== =========== ============ ============ 97 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E PAGE: 2 ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 24 -Brink Meyer Road NID FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TAXES 41001-00 Brink Meyer Rd NID Spec Assess 1,683 1,662 1,678 1,662 1,678 1,662 1,662 TOTAL TAXES 1,683 1,662 1,678 1,662 1,678 1,662 1,662 TRANSFERS IN 41901-01 Tfr from Gen Fd-Property Sale 247,063 231,982 0 230,297 230,297 235,000 235,000 41902-00 Transfers In from Other Funds 0 0 230,297 0 0 0 0 TOTAL TRANSFERS IN 247,063 231,982 230,297 230,297 230,297 235,000 235,000 TOTAL REVENUES 248,746 233,644 231,975 231,959 231,975 236,662 236,662 =========== =========== =========== =========== =========== ============ ============ 98 of 103 11-14-2023 01:01 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 24 -Brink Meyer Road NID Brink Meyer Road NID EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ BOND/LEASE PAYMENTS 501.10-01-00 Bond Principal 3,085,000 195,000 195,000 195,000 195,000 200,000 200,000 501.10-02-00 Bond Interest 108,895 38,365 36,902 36,903 36,903 35,245 35,245 501.10-03-00 Bond Fees 300 300 300 300 300 300 300 TOTAL BOND/LEASE PAYMENTS 3,194,195 233,665 232,202 232,203 232,203 235,545 235,545 TRANSFERS-OTHER SOURCES ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL ___________ ___________ ___________ ___________ ___________ ____________ ____________ TOTAL Brink Meyer Road NID 3,194,195 233,665 232,202 232,203 232,203 235,545 235,545 TOTAL EXPENDITURES 3,194,195 233,665 232,202 232,203 232,203 235,545 235,545 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES ( 2,945,449) (21)( 227) ( 244) ( 228) 1,117 1,117 =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 99 of 103 Category 2022 Unaudited 2023 Budget 2023 Revised 2024 Adopted 2025 Forecast 2026 Forecast 2027 Forecast 2028 Forecast 9 Highway CID Proceeds 215,816$ 215,000$ 215,000$ 175,000$ 175,000$ 175,000$ 175,000$ 175,000$ Lease Purchase Proceeds - - - - - - - - Transfers From Projects 222,762 66,229 66,229 88,000 - - - - Transfers From Transportation - - - - - - - - Total Revenues 438,578 281,229 281,229 263,000 175,000 175,000 175,000 175,000 Bond Principal 375,000 160,000 160,000 160,000 165,000 165,000 165,000 165,000 Bond Interest 63,578 52,200 50,353 49,000 45,800 42,500 39,200 35,900 Bond Fees 1,750 - 1,750 - - - - - Debt Refinance - - - - - - - - Total Expenditures 440,328 212,200 212,103 209,000 210,800 207,500 204,200 200,900 Increase (decrease)(1,750) 69,029 69,126 54,000 (35,800) (32,500) (29,200) (25,900) Beginning Fund Balance (67,279) (69,029) (0) 69,126 123,126 87,326 54,826 25,626 Ending Fund Balance (69,029)$ (0)$ 69,126$ 123,126$ 87,326$ 54,826$ 25,626$ (274)$ City of Parkville, Missouri Highway 9 Debt (2021 COPs) Service Fund (96) 2024 Adopted Budget 2022 Unaudited, 2023 Budget, 2023 Revised, 2024 Adopted, 2025-2028 Forecast Expenditures Revenues 100 of 103 11-14-2023 01:02 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 96 -Major Project in Progress FINANCIAL SUMMARY (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ REVENUE SUMMARY TAXES 125,505 215,816 215,000 171,253 215,000 175,000 175,000 TRANSFERS IN 1,534,566 222,762 66,229 66,229 66,229 88,000 88,000 TOTAL REVENUES 1,660,071 438,578 281,229 237,482 281,229 263,000 263,000 =========== =========== =========== =========== =========== ============ ============ EXPENDITURE SUMMARY GENERAL 1,660,071 440,328 212,200 212,103 212,103 209,000 209,000 TOTAL EXPENDITURES 1,660,071 440,328 212,200 212,103 212,103 209,000 209,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 0 ( 1,750) 69,029 25,379 69,126 54,000 54,000 =========== =========== =========== =========== =========== ============ ============ 101 of 103 11-14-2023 01:02 PM C I T Y O F P A R K V I L L E ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 96 -Major Project in Progress FINANCIAL SUMMARY REVENUES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ TAXES 41001-00 9 Hwy CID Payments 125,505 215,816 215,000 171,253 215,000 175,000 175,000 TOTAL TAXES 125,505 215,816 215,000 171,253 215,000 175,000 175,000 TRANSFERS IN 41901-00 Transfers 1,534,566 222,762 66,229 66,229 66,229 88,000 88,000 TOTAL TRANSFERS IN 1,534,566 222,762 66,229 66,229 66,229 88,000 88,000 TOTAL REVENUES 1,660,071 438,578 281,229 237,482 281,229 263,000 263,000 =========== =========== =========== =========== =========== ============ ============ 102 of 103 11-14-2023 01:02 PM C I T Y O F P A R K V I L L E PAGE: 3 ADOPTED BUDGET AS OF: SEPTEMBER 30TH, 2023 96 -Major Project in Progress GENERAL EXPENDITURES (----------------- 2023 -----------------)(--------- 2024 ----------) 2021 2022 CURRENT Y-T-D PROJECTED PROPOSED ADOPTED ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END BUDGET BUDGET _________________________________________________________________________________________________________________________________________ BOND/LEASE PAYMENTS 501.10-01-00 Bond Principal 1,626,900 375,000 160,000 160,000 160,000 160,000 160,000 501.10-02-00 Bond Interest 33,171 63,578 52,200 50,353 50,353 49,000 49,000 501.10-03-00 Bond Fees 0 1,750 0 1,750 1,750 0 0 TOTAL BOND/LEASE PAYMENTS 1,660,071 440,328 212,200 212,103 212,103 209,000 209,000 TOTAL GENERAL 1,660,071 440,328 212,200 212,103 212,103 209,000 209,000 TOTAL EXPENDITURES 1,660,071 440,328 212,200 212,103 212,103 209,000 209,000 =========== =========== =========== =========== =========== ============ ============ EXCESS REVENUES OVER (UNDER) EXPENDITURES 0 ( 1,750) 69,029 25,379 69,126 54,000 54,000 =========== =========== =========== =========== =========== ============ ============ *** END OF REPORT *** 103 of 103