Loading...
HomeMy WebLinkAbout6.1 Accept the attached Monthly Financial Report for May 2023.Subject Monthly .4Report - May 2023 Meeting July 18, 2023 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - Fiscal Impact Dollar Amount Budget Source Category CONSENT AGENDA Type Consent Information Attached is the Monthly Financial Report for May 2023. Alternatives 1. Accept the Monthly Financial Report for May 2023. 2. Action at the discretion of the Village Board. Staff Recommendation Accept the attached Monthly Financial Report for May 2023. ATTACHMENTS: Month ly_Report_May_2023. pdf 05 May Board Reports for Upload .pdf 1 VILLAGE OF MOUNT PROSPECT MONTHLY FINANCIAL REPORT May 31, 2023 Prepared By Amit Thakkar, CPA Director of Finance TO: VILLAGE PRESIDENT, BOARD OF TRUSTEES, AND FINANCE COMMISSION FROM: AMIT THAKKAR, DIRECTOR OF FINANCE DATE: JUNE 26, 2023 SUBJECT: MONTHLY FINANCIAL REPORT FOR THE MONTH OF MAY 2023 In an effort to provide the most transparent and relevant financial information in a timely manner, we are submitting this report herewith. The report contains relevant data with analytical information for the Village's current financial affairs. The report is prepared based on the most recent available financial information (internal and external). The report is divided into five sections, including a) Cash and Investments, b) Revenues, c) Expenses, d) Fund Balance Analysis, and e) Other items that may contain relevant new issues and items representing and impacting the Village's financial interest and well-being. a) Cash and Investments The Village of Mount Prospect maintains a sufficient liquid cash balance at various banking and investment institutions for the smooth operation of the Village's day-to-day activities. The remainder of the cash assets are invested in multiple interest-earning accounts and investment options in accordance with the Village's Investment Policy. As of May 1, 2023, the beginning Cash and Cash Equivalents totaled $95.9 million. During the month of May, the Village collected cash receipts totaling $9.3 million. The investment income for the month totaled $395,180. The payroll cost for the month was $1.7 million, and accounts payable were paid in the amount of $10.2 million. The inter -fund activity increased the cash position by $9,984, while other disbursements totaled $15,029. As of May 31, 2023, the Village's Cash and Cash Equivalents totaled $103.9 million. GOVERNMENTAL AND ENTERPRISE FUNDS Balance at May 31 2023 103„884„935 15„605,290 119„490,225 As of May 31, the Village has a total of $15.6 million invested in long-term investment options, including U.S. Treasuries, AAA+ rated money market Funds, and FDIC insured CDs. The Cash, Cash Equivalents, and Investments totaled $119.5 million as of May 31, 2023. 2 Cash and Cash Total Cash and Equivalents Investments Investments Balance at May 1, 2023 95„887,797 25„799„914 121, 87„710 Cash receipts 9,,318,02:2 - 9,,310,02:2 Investment income 395„180 24„376 419„857 Transfers from investments to cash - (10„219-„000) (10„219„000) Transfers to investments from cash 10„219„000 10,219„000 Interfund activity 9,,.984 9,,.984 Disbursement&: Accounts payable (10„211,298) (10„211,298) Payroll (1„719„520) (1„719„520) Other (15„029) (15„029) Balance at May 31 2023 103„884„935 15„605,290 119„490,225 As of May 31, the Village has a total of $15.6 million invested in long-term investment options, including U.S. Treasuries, AAA+ rated money market Funds, and FDIC insured CDs. The Cash, Cash Equivalents, and Investments totaled $119.5 million as of May 31, 2023. 2 The below table summarizes the Cash and Cash Equivalents by Fund type as of May 31, 2023. Fund Details Amount General Fund 42,„483,.243 Special Revenue Funds 16,„000,,088 Debt Service Funds 2„288„817 Capital Projects Funds 13,79,6,388 Enterprise Funds 24,„817,,075 Internal Service Funds 6„40,0,324 Total Cash and Cash Equivalents 103,„884„935 In addition to the funds summarized above, the Village of Mount Prospect has $1,264,384 in Escrow Accounts under the umbrella of Other Trust and Agency Funds. b) Revenues The below data summarizes the revenue recognized by the Village through May 2023. Property Taxes 22,078,821 10,793,,984 48,.9% 11,198,486 (404,,502) -3.6 CtherTaxes 14"144".500 3,330,034 23.5% 316,72,328 (342,293), -'9.3" Rntergovernnnentall Revenue 49,689,008 12,375,268 24.9% 12"6 9,735 (2414,,467) -1.9' Licenses, IPermits, & 15ees 1,959,500 95,1„809 50.1% 2~287,787 (1„305,978) -57.1% Chanes 15or 5ervlices 40,,8,37,,772 16,415,643 40.2% 15,155,51Di4 1„260,,139 8.3” Fines & Forfeits 530,,140 221„4187 41.8:% 435,507 (214,020) -49.1% Investment Income 278,266, 1,983,479 715.0% X164,,280) 2,,153,759 -1311.0% Other Iriinanciing Sources 710,600,00o 1.1„051 0.1° 11"080 (29) +++ Oiher R3evenue 2,16,6,55, 1„0344,363 47.7% 937,206 97,158, 10.4% Reimbursements 203"000 210,858 103.9% 118,192 92,666 78,.4° Total Revenues 14214871.557 4713641977 33.2% 461272a545 1P092,43 2.4 The above amounts do not represent all the revenues to be recognized for the period under review. There are certain state taxes, such as sales tax, home rule sales tax, and a few other taxes, that will be received by the Village in June 2023 and later. Additionally, during the month of May 2023, the Village received the following revenues from the State, which relate to a period prior to May 2023. These amounts are distributed after the State administrative fee deductions of $8,639. 3 State Sales Tax Feb -23 May' -23 May -23 2,,481,990 Home Rule Sales Tax Feb -23 May -23 May -23 482,632 BusiJness, DlistrlictTax Feb -23 May -23 May -23 18,,.561 Auto Rental Tax Feb -23 May' -23 May -23 2,412 Telecom Tax Feb -23 May -23 May -23 99,994 Total Revenues 29,206, 32,,874 (3,659) 3�,075�,510 The actual revenue received by the Village totaled $47.3 million through May 2023. This amount represents 33.2 percent of the annual budget. The collected amount is tracking higher by $1.1 million compared to the 2022 collection for the same period. Property Taxes: The Village's total levy for the year is $20,443,677. The total property tax revenue budget, including TIF revenues, is $22.1 million. The Village has collected $10.8 million in property taxes so far for the tax year 2022. Due to a shift in the due date for the first installment, the collection is trailing lower by $404,502 or 3.6% compared to the previous year. Other Taxes: The category of Other Taxes includes all the taxes enacted per local ordinances and includes Home Rule Sales Tax, Hotel/Motel, Food and Beverage, Municipal Motor Fuel Tax, Utility Taxes, etc. As some of these taxes are collected by the State, there is a three-month lag between the actual sales and the remittance of the tax. In addition, all the local economic activities for the month of February are reported in March or later. The YTD tax collection under this category totals $3.3 million, and it is trailing lower by $342,293 or 9.3 percent compared to the previous year. Most of the revenue lines under Other Taxes are tracking higher compared to the previous year, except the real estate transfer tax. The YTD collection totals $305,578, while at the same time last year, the real estate transfer tax totaled $622,126. The higher interest rate environment and low inventory in the market for available homes have resulted in a lower collection of the real estate transfer tax. Intergovernmental Revenue: This category includes all the State shared taxes, including State Sales Tax, Income Tax, Use Tax, Motor Fuel Tax, and Grants. The Village is vigilantly tracking all intergovernmental revenues. As most of these taxes are collected by the State, there is a three- month lag between the actual sales and the remittance of the tax. The year-to-date collection totals $12.4 million and is trending lower by $244,467 or 1.9% compared to 2022 amounts. The below table summarizes the major taxes collected through May 2023. State SalIesTax 5,165,214 4,,641„39.8 523,816, 11% State IIncorneTax 4,343,315 4,558,157 (514,842) -11' State Use Tax ,826,447 79S, 6,58, 26,799 3"% State Motor Fuel Tax 738,,843 6,73,,542 6.5,300 10% Video Gaming Tax ^95,050 68„650 26,,401 38% Cannabis Education bund 29,206, 32,,874 (3,659) -11% Municipal Cannabis Tax 10,610 6,625 3,985' 60% During May 2023, the Village collected $1.4 million in income tax revenue, while during May 2022, 4 the Village had collected $1.8 million in income tax revenue. It is still the early part of the year, and the Village has yet to collect major state sales tax belonging to the year 2023. The sales tax collection is trending higher by $523,816 or 11 percent compared to the previous year. Licenses & Permits: The Village has collected $981,809 in License & Permit Fees through May 2023. The amount is trending lower by $1,305,978 or 57.1% compared to last year's collection at the same time, mainly due to the suspension of vehicle stickers. The Village had collected $1,236,082 in vehicle sticker revenues by this time last year. Charges for Services: The Village has received $16.4 million in charges for services through May 2023. The amount represents 40.2% of the annual budgeted amount for the category and it is trending higher by $1.3 million compared to last year's collection at the same time, mainly due to the increased water/sewer and refuse rates. Investment Income: The Village has earned $2.0 million in investment income through May 2023. The Village is currently earning anywhere from 3.5% to 5.1 % on its liquid investments. The Village's investments are in compliance with its Investment Policy and due to high federal rates, the Village is earning a higher amount in investment income. Last year at the same time, the Village's investments were marked to market and unrealized loss in the investment values were booked, which are now reversed and booked as a realized investment income. Other Categories: All other revenue categories have collectively generated $1.5 million through May 2023. The amount mainly includes $221,487 in fines and forfeitures, $1,034,363 in other revenues, and $210,858 in reimbursements. c) Expenditures The below data recaps the expenditures incurred through the month of May 2023. 10 IPublloc Representation 6,24,,596, 202,,'974 32.5% 1103,,14'9 '99,,8,25 20 Vlillllage Administration 5,193,6,01 1,729,016, 33.3% 1,,530,264 1919,752 30 Finance 2,501,247 8,23,028, 32.9% 5,17,118, 5,gos 410 Communlity Development 4,784,,744 1,68.5,995 3.5.2% 1,,235,114 45D,,8.81 50 Human Services 1,954,711 546,368 281.0% 520,58.5 25,783 6O IPoluce 22458„993 8„493,278, 37.8% 8„648„556, (155,279) 70 Fore 20,357,9,09 7,662,,463 37.69% 8,G20,341 (357,,878) &D IPublllicWorks 72,610,070 18„ 034,08,6, 24.8° 14,38,7,6,32 3,646,453 GG INon-Departmental 36,839,135 13,419,345 36f.4% 6,670,949 6,748,397 Total Expenditures 16713.25,1005 52596,„552 31.4% 41,,93,317091 10,662„843 The above amounts do not include the expenditures for the Pension Funds, as they are separate entities. The above amounts are unaudited and subject to change with accrual/audit adjustments. 5 Personnel 56,372,,557 21„431„948, 381.10 21,542,,379 X210,431), Contractuall Services 38,,233,,054 14,106,566f 35f.9 12,584,,3166 1,522,250 Commodities & Supplies 2,,504,,1,85 1„035,925 39.8% 930,,328, 10.5,.597 Capital Improvements 41,007,78+0 5,950,739 17.0% 4,535,553 2,,421,,18,56 Debt Service 9,037,425 2,,149,598, 23.8% 2,044,,542 105,157 Other Expenditures 20,059,905 5,915,575 34.5% 195,591 5,719,084 hotel Expenditures 16713251005 521596,1552 15.5' 41,,933,709 10,E+62,843 Personnel Costs: The year-to-date expenditures for Personnel Costs, including benefits, are $21.4 million or 38.0 percent of the annual budget for the category. The amount is trending lower by $210,431 compared to 2022. The overtime expense through May 2023 totals $902,400, while at the same time last year, the overtime expense totaled $866,971. Services: - This category covers most of the contractual services that include some large line items, including JAWA water purchases, budgeted and grant -funded engineering studies, and other contracts. The year-to-date expenditure is $14.1 million, and it equates to 36.9 percent of the annual budgeted amount for the category. The expenditure amount is trending higher by $1,522,250, mainly due to the inflationary and timing issues. Supplies: The Village has spent $1,035,925 in supplies through May 2023. The spending totals 39.8 percent of the approved budget. The Village is diligently tracking inflation. The recent inflation is at its highest in the last 40 years. So far, the Village has tracked inflation and its financial impacts successfully and the current budget and fund balance have the capacity to deal with short-term inflation impacts. The expenditures incurred are trending higher by $105,597 compared to last year's amount at the same time. The amount for the year 2022 includes some timing issues with recognition, while the 2023 amount is incurred as expected. Capital Improvements: The Village has $41.0 million in approved capital improvement projects for the year 2023. The Village has amended its budget to carry forward $12.7 million worth of projects from the year 2022 to 2023 (during March 2023). Many of the budgeted projects from the year 2022 will be completed in 2023. Since it is the early part of the year, the Village has not yet started on big projects. Most of the projects will be started in the summer and are expected to conclude in the fall of 2023. Through May 2023, the Village has spent $7.0 million on capital improvement projects. Debt Service: Per the established debt service schedules, the Village's bond payments are due on June 1 and December 1. The Village processes these debt service payments a few days prior to due dates and has sufficient funds on hand to execute the same. The Village has incurred and paid $2,149,698 in interest expenditures through May 2023. Other Expenditure: The Other Expenditure category includes all other expenditures not categorized above. The category includes $17.9 million in interfund transfers and $2.2 million in other expenditures. The YTD expenditure posted against this category totals $6.9 million. d) Fund Balance Analysis: The fund balance is an essential tool to check the fiscal health of any governmental organization. The below data summarizes the Village's monthly unassigned/unrestricted General fund reserves. The fund balance data is unaudited. 9 Revenues - Unaudited 2,2„318,1549 1„7471561 1,671„ 3,35 61384,2,5.3 91632„151 4,13191759 241254,1514 EXpenses- Unaud'Oted (101,'70 3,346) (1„934,10535) (4,548,145,3) (7,152,2;76) (5,8SO,2,99) (15,1933,1438) (3)d3,1453,,432,) Jet Mianthly SwrpIus/ (Deficit) 1.2,112,703 (237,019), (2,877,072)- (718,,319)- 3,751,921 (6,,113,729)- (6,1989131, As'% of Generalll Fund Budget 58% 57'2 54'% 53% 53% 50%, 55% 4.s t. of Generalll Fund Budget 39% 491' 501”. 52% 57% 4,9% 499 (Unaudited and Subject to Change) The above fund balance analysis is not audited, and it is subject to change. The unrestricted fund balance as of May 2023 is estimated at $38.0 million. Not all the revenues and expenditures for the fiscal period are recognized and the above amount will change as and when yearend accruals and adjustments are added to the same. Recently, the Village revised its Fund Balance Policy, and the new target is set to maintain the fund balance between 30 to 50 percent. Besides that, a new Economic Emergency Fund was established and a transfer of $6.5 million was executed as an initial funding from the General Fund reserves. During May 2023, this planned transfer was executed and deposited in the Economic Emergency Fund. This balance was invested in June 2023 in a AAA rated I -prime account. Economic Emergency Fund The Village Board authorized creation of a new Economic Emergency Fund in May 2023 and approved a budget amendment funding $6.5 million from the General Fund reserves as an initial funding amount for the Economic Emergency Fund. This transfer was executed in May 2023. The below table summarizes the Economic Emergency Fund activities for the month. Revenues 6,500,000 Expenditures - Net Monthly Surplus/Deficit 6,,500,1000 e) Other Items: During May 2023, the Village issued 108 real estate transfer tax stamps, of which 38 were exempt and 70 were non-exempt. During May 2023, the Village collected $91,416 in real estate transfer taxes. The average selling price for real estate was $435,229. At the same time last year (May 2022), the Village sold 152 transfer tax stamps, of which 45 were exempt and 107 were non-exempt. In the same month last year, the Village collected real estate transfer taxes of $270,405 and the average selling price was $377,345 (excluding a large value transaction). The year-to-date collection totals $305,964, while at the same time last year, the collection totaled $627,192. The Village concluded its annual audit in May 2022 and received its final audit report in early June 2023. The Village received the highest possible unqualified/clean opinion on its financial statements. The Village also won an award for Excellence in Finance Reporting from the Governmental Finance Officers' Association of US and Canada. The Village also became one of the 517 communities nationwide with a triple crown status. The Village Finance Department won the Budget Award, Financial Reporting Award and PAFR (Popular Financial Reporting Award). The Audit committee met on June 12, 2023, to review 7 the financial statement and the audit process with the Village's statutory auditors. The Audit Committee has accepted the audit report and will present the annual audit to the Village Board in July 2023. c. The Village has initiated its Capital Improvement Plan budget process in June 2023 and the Operating Budget is expected to kickoff at the end of June or early July. Respectfully Submitted, Amit Thakkar Director of Finance VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES May 1— May 31, 2023 10 REVENUE TOTALS $76,454,329.00 ($1,100,000.00) $75,354,329.00 $4,819,708.74 $0.00 $24,254,513.55 $51,099,815.45 32% $24,722,369.71 00 Gene_. _ ,u_ 's $76,454,329.00 ($1,100,000.00) $75,354,329.00 $4,819,708.74 $0.00 $24,254,513.55 $51,099,815.45 $24,722,369.71 1 11 Revenue Budget by Account Classification Report 0/J2 -a L_S._rl9 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD REVENUE rc —axes 17,970,571.00 .00 17,970,571.00 .00 .00 8,894,448.59 9,076,122.41 49 8,935,552.06 0 - 3xes 7,699,500.00 4,900,000.00 12,599,500.00 1,615,910.58 .00 2,861,087.66 9,738,412.34 23 2,248,319.89 c u.. -ees 1,958,500.00 .00 1,958,500.00 160,830.66 .00 981,539.08 976,960.92 50 1,051,705.94 -wee r _r a ev_�nwe 45,245,308.00 (6,000,000.00) 39,245,308.00 2,406,273.30 .00 9,015,358.47 30,229,949.53 23 11,136,013.29 _ _ _. s 2,732,000.00 .00 2,732,000.00 261,752.42 .00 975,512.14 1,756,487.86 36 1,028,808.07 e 307,300.00 .00 307,300.00 50,192.44 .00 124,190.94 183,109.06 40 108,248.82 126,000.00 .00 126,000.00 256,095.50 .00 1,068,888.28 (942,888.28) 848 17,583.61 Re _ e __ 177,000.00 .00 177,000.00 31,810.88 .00 127,943.44 49,056.56 72 75,904.04 Oz-er Revenue238,150.00 .00 238,150.00 36,842.96 .00 205,544.95 32,605.05 86 120,233.99 0 e- - n_ c ng Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $76,454,329.00 ($1,100,000.00) $75,354,329.00 $4,819,708.74 $0.00 $24,254,513.55 $51,099,815.45 32% $24,722,369.71 00 Gene_. _ ,u_ 's $76,454,329.00 ($1,100,000.00) $75,354,329.00 $4,819,708.74 $0.00 $24,254,513.55 $51,099,815.45 $24,722,369.71 1 11 REVENUE TOTALS nd 002 - Dere _ .E _ =__s ,- °al $4,681,906.00 $0.00 $4,681,906.00 $696,191.98 $0.00 $2,246,036.98 $2,435,869.02 48% $2,081,620.86 $4,681,906.00 $0.00 $4,681,906.00 $696,191.98 2 $0.00 $2,246,036.98 $2,435,869.02 $2,081,620.86 12 Revenue Budget by Account Classification Report 0/J2 =_a � _{ Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �I. r 002 - Dent Service = n REVENUE ry –axes 2,208,250.00 .00 2,208,250.00 .00 .00 1,216,808.45 991,441.55 55 1,510,515.10 0 - 3xes 923,656.00 (923,656.00) .00 (255,698.65) .00 .00 .00 +++ 501,545.88 e °t? _ -r.n 1-venu 145,000.00 923,656.00 1,068,656.00 948,186.56 .00 1,018,706.39 49,949.61 95 68,649.75 -:__Com 5,000.00 .00 5,000.00 3,704.07 .00 10,522.14 (5,522.14) 210 910.13 Corer ,,gnus .00 .00 .00 .00 .00 .00 .00 +++ .00 `,-,e `` ng Sources 1,400,000.00 .00 1,400,000.00 .00 .00 .00 1,400,000.00 0 .00 REVENUE TOTALS nd 002 - Dere _ .E _ =__s ,- °al $4,681,906.00 $0.00 $4,681,906.00 $696,191.98 $0.00 $2,246,036.98 $2,435,869.02 48% $2,081,620.86 $4,681,906.00 $0.00 $4,681,906.00 $696,191.98 2 $0.00 $2,246,036.98 $2,435,869.02 $2,081,620.86 12 REVENUE TOTALS -,d 020 - Genas. a [ rve e a _ r s . e=_s $2,508,000.00 $500,000.00 $3,008,000.00 $422,137.71 $0.00 $483,510.51 $2,524,489.49 16% $2,200.42 $2,508,000.00 $500,000.00 $3,008,000.00 $422,137.71 $0.00 $483,510.51 $2,524,489.49 $2,200.42 3 13 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 020 - Ca _ta_ imorovernent �nn REVENUE - _axe_ 1,500,000.00 (1,500,000.00) .00 .00 .00 .00 .00 +++ .00 mRevenue .00 2,000,000.00 2,000,000.00 400,000.00 .00 400,000.00 1,600,000.00 20 .00 erg, _ income 8,000.00 .00 8,000.00 22,137.71 .00 83,510.51 (75,510.51) 1044 2,200.42 ._.. e -e :_ .00 .00 .00 .00 .00 .00 .00 +++ .00 07-e07-er Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 `,-,e `` ng Sources 1,000,000.00 .00 1,000,000.00 .00 .00 .00 1,000,000.00 0 .00 REVENUE TOTALS -,d 020 - Genas. a [ rve e a _ r s . e=_s $2,508,000.00 $500,000.00 $3,008,000.00 $422,137.71 $0.00 $483,510.51 $2,524,489.49 16% $2,200.42 $2,508,000.00 $500,000.00 $3,008,000.00 $422,137.71 $0.00 $483,510.51 $2,524,489.49 $2,200.42 3 13 REVENUE TOTALS -..M 023 - Sae eeg improvement Const_ RE _ r_.e . ota s $4,123,000.00 $500,000.00 $4,623,000.00 $226,571.89 $0.00 $1,115,498.17 $3,507,501.83 24% $2,012,009.73 $4,123,000.00 $500,000.00 $4,623,000.00 $226,571.89 ALI $0.00 $1,115,498.17 $3,507,501.83 $2,012,009.73 14 Revenue Budget by Account Classification Report 0/J2 -a L_S._rl9 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �I. r 023 - Street imorovement Con true �n__-a REVENUE v _axe_ 2,150,000.00 (1,500,000.00) 650,000.00 (189,872.27) .00 233,445.56 416,554.44 36 730,424.44 _ce__es, u....__ & -ees .00 .00 .00 .00 .00 270.00 (270.00) +++ 1,236,081.50 irterracverrmerta Revenue 50,000.00 2,000,000.00 2,050,000.00 400,000.00 .00 821,840.00 1,228,160.00 40 31,000.00 _ea .00 .00 .00 .00 .00 .00 .00 +++ .00 i-Ve__.__n:irc rnz 8,000.00 .00 8,000.00 13,995.76 .00 46,432.11 38,432.11 580 1,533.34 Re _e __ .00 .00 .00 .00 .00 .00 .00 +++ .00 0_7rer Revenue 15,000.00 .00 15,000.00 2,448.40 .00 13,510.50 1,489.50 90 12,970.45 0- -v -g SourceS 1,900,000.00 .00 1,900,000.00 .00 .00 .00 1,900,000.00 0 .00 REVENUE TOTALS -..M 023 - Sae eeg improvement Const_ RE _ r_.e . ota s $4,123,000.00 $500,000.00 $4,623,000.00 $226,571.89 $0.00 $1,115,498.17 $3,507,501.83 24% $2,012,009.73 $4,123,000.00 $500,000.00 $4,623,000.00 $226,571.89 ALI $0.00 $1,115,498.17 $3,507,501.83 $2,012,009.73 14 REVENUE TOTALS 0 - nod Co_ er . a_� a_ _ r d , e= -s $2,390,000.00 $501,344.00 $2,891,344.00 $219,006.62 $0.00 $230,384.61 $2,660,959.39 8% $19,628.71 $2,390,000.00 $501,344.00 $2,891,344.00 $219,006.62 $0.00 $230,384.61 $2,660,959.39 $19,628.71 5 15 Revenue Budget by Account Classification Report 05131123 5c_ ea- AcriViry T-cluded Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 024 _ M000 Construction Fund REVENUE - _axe_ 575,000.00 (575,000.00) .00 .00 .00 .00 .00 +++ .00 mRevenue 788,000.00 1,076,344.00 1,864,344.00 215,268.80 .00 215,268.80 1,649,075.20 12 .00 __ t _u 10,000.00 .00 10,000.00 582.00 .00 5,902.00 4,098.00 59 4,413.00 2,000.00 .00 2,000.00 3,155.82 .00 9,213.81 (7,213.81) 461 496.49 me MDU-Sm—mrKS 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 14,719.22 `,-,e `` ng Sources 1,000,000.00 .00 1,000,000.00 .00 .00 .00 1,000,000.00 0 .00 REVENUE TOTALS 0 - nod Co_ er . a_� a_ _ r d , e= -s $2,390,000.00 $501,344.00 $2,891,344.00 $219,006.62 $0.00 $230,384.61 $2,660,959.39 8% $19,628.71 $2,390,000.00 $501,344.00 $2,891,344.00 $219,006.62 $0.00 $230,384.61 $2,660,959.39 $19,628.71 5 15 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 036 - Ru r - Dec_a_ Service Arec - _n REVENUE rcoe :y_axes 160,000.00 .00 160,000.00 .00 .00 .00 160,000.00 0 .00 REVENUE TOTALS and 03 Kura_ S ee_a= Service Area _ and _ , a s $160,000.00 $0.00 $160,000.00 $0.00 $0.00 $0.00 $160,000.00 0% $0.00 $160,000.00 $0.00 $160,000.00 $0.00 $0.00 $0.00 $160,000.00 $0.00 6 16 REVENUE TOTALS 037 1 - and . o_a U $155,100.00 $0.00 $155,100.00 $0.00 $0.00 $0.00 $155,100.00 0% $0.00 $155,100.00 $0.00 $155,100.00 7 $0.00 $0.00 $0.00 $155,100.00 $0.00 17 Revenue Budget by Account Classification Report 0/J2 -a L_S._rl9 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �I. r 037 - S _P - � �nn REVENUE rc-axes 155,100.00 .00 155,100.00 .00 .00 .00 155,100.00 0 .00 0-e- gnus .00 .00 .00 .00 .00 .00 .00 +++ .00 O_ er -I anc nci Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS 037 1 - and . o_a U $155,100.00 $0.00 $155,100.00 $0.00 $0.00 $0.00 $155,100.00 0% $0.00 $155,100.00 $0.00 $155,100.00 7 $0.00 $0.00 $0.00 $155,100.00 $0.00 17 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Ira - _ ____tion � _n REVENUE v 3 __s .00 6,500,000.00 6,500,000.00 6,500,000.00 .00 6,500,000.00 .00 100 .00 REVENUE TOTALS und 03 -con __ Economic Stab_zat_on _ and o a s $0.00 $6,500,000.00 $6,500,000.00 $6,500,000.00 $0.00 $6,500,000.00 $0.00 100% $0.00 $0.00 $6,500,000.00 $6,500,000.00 $6,500,000.00 $0.00 $6,500,000.00 $0.00 $0.00 8 18 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 039 - Pension t ___¢ _ � _n REVENUE v 3 __s 750,000.00 .00 750,000.00 .00 .00 .00 750,000.00 0 .00 REVENUE TOTALS 039 - Peng n Stabi_ation _ and _ ota s $750,000.00 $0.00 $750,000.00 $0.00 $0.00 $0.00 $750,000.00 0% $0.00 $750,000.00 $0.00 $750,000.00 $0.00 $0.00 $0.00 $750,000.00 $0.00 9 19 REVENUE TOTALS _ Refus . to $5,111,200.00 $0.00 $5,111,200.00 $351,758.06 $0.00 $2,018,398.49 $3,092,801.51 39% $1,911,497.36 $5,111,200.00 $0.00 $5,111,200.00 $351,758.06 $0.00 $2,018,398.49 $3,092,801.51 $1,911,497.36 10 20 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 0-_0 - Refuse Disoosa_ Fun REVENUE rvne :y_axes .00 .00 .00 .00 .00 .00 .00 +++ .00 - o-ServceS 4,927,500.00 .00 4,927,500.00 335,446.68 .00 1,916,802.53 3,010,697.47 39 1,854,270.78 _lnV & _ _.rs 36,100.00 .00 36,100.00 1,603.03 .00 15,758.18 20,341.82 44 17,227.26 1,000.00 .00 1,000.00 2,725.38 .00 11,235.67 (10,235.67) 1124 221.56 me MDU-Se—mrKS 1,000.00 .00 1,000.00 .00 .00 26,314.74 (25,314.74) 2631 .00 0er_-u 145,600.00 .00 145,600.00 11,982.97 .00 48,287.37 97,312.63 33 39,777.76 REVENUE TOTALS _ Refus . to $5,111,200.00 $0.00 $5,111,200.00 $351,758.06 $0.00 $2,018,398.49 $3,092,801.51 39% $1,911,497.36 $5,111,200.00 $0.00 $5,111,200.00 $351,758.06 $0.00 $2,018,398.49 $3,092,801.51 $1,911,497.36 10 20 REVENUE TOTALS ._-,- 041 -Moto- _ ue_ -�ax a s _ ota s $1,913,700.00 $0.00 $1,913,700.00 $226,061.35 $0.00 $795,275.64 $1,118,424.36 42% $1,276,653.15 $1,913,700.00 $0.00 $1,913,700.00 $226,061.35 11 $0.00 $795,275.64 $1,118,424.36 $1,276,653.15 21 Revenue Budget by Account Classification Report 0/J2 -a L-S.-rl9 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �I r 041 - Motor -sd_ Tax Fun REVENUE irteroeverrmerta Revenue 1,895,700.00 .00 1,895,700.00 201,984.02 .00 738,842.62 1,156,857.38 39 1,268,512.00 _-.ve__ , _ - come 8,000.00 .00 8,000.00 12,040.80 .00 44,396.49 (36,396.49) 555 2,031.65 Reimbursemems 10,000.00 .00 10,000.00 12,036.53 .00 12,036.53 (2,036.53) 120 6,109.50 0,-eve-ue .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS ._-,- 041 -Moto- _ ue_ -�ax a s _ ota s $1,913,700.00 $0.00 $1,913,700.00 $226,061.35 $0.00 $795,275.64 $1,118,424.36 42% $1,276,653.15 $1,913,700.00 $0.00 $1,913,700.00 $226,061.35 11 $0.00 $795,275.64 $1,118,424.36 $1,276,653.15 21 REVENUE TOTALS 04 CDBG —o_a U $480,000.00 $0.00 $480,000.00 $0.00 $0.00 $15,487.45 $464,512.55 3% $22,732.48 $480,000.00 $0.00 $480,000.00 12 $0.00 $0.00 $15,487.45 $464,512.55 $22,732.48 22 Revenue Budget by Account Classification Report 0/J2 -a L_S._rl9 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �I.r 042 - CDBG REVENUE irteroeverrmerta Revenue 430,000.00 .00 430,000.00 .00 .00 14,787.58 415,212.42 3 22,732.48 _-.ve__ , _ - come .00 .00 .00 .00 .00 .00 .00 +++ .00 011er Revenue 50,000.00 .00 50,000.00 .00 .00 699.87 49,300.13 1 .00 REVENUE TOTALS 04 CDBG —o_a U $480,000.00 $0.00 $480,000.00 $0.00 $0.00 $15,487.45 $464,512.55 3% $22,732.48 $480,000.00 $0.00 $480,000.00 12 $0.00 $0.00 $15,487.45 $464,512.55 $22,732.48 22 REVENUE TOTALS unc 043 - Asset Se_zu. e = ans . otals $1,150.00 $0.00 $1,150.00 $2,038.29 $0.00 $3,040.55 ($1,890.55) 264% $43.45 $1,150.00 $0.00 $1,150.00 $2,038.29 $0.00 $3,040.55 ($1,890.55) $43.45 13 23 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 043 - Asset S$_¢u_d = n REVENUE -Ines_.-- 1,000.00 .00 1,000.00 1,820.00 .00 2,125.50 (1,125.50) 213 .00 _.ve__._,.. _--come 150.00 .00 150.00 218.29 .00 915.05 (765.05) 610 43.45 REVENUE TOTALS unc 043 - Asset Se_zu. e = ans . otals $1,150.00 $0.00 $1,150.00 $2,038.29 $0.00 $3,040.55 ($1,890.55) 264% $43.45 $1,150.00 $0.00 $1,150.00 $2,038.29 $0.00 $3,040.55 ($1,890.55) $43.45 13 23 REVENUE TOTALS unc 044 _ x 3 _ Equ_t b_e Share _CFunds _ ovals $50,800.00 $0.00 $50,800.00 $604.38 $0.00 $18,885.25 $31,914.75 37% $253,221.70 $50,800.00 $0.00 $50,800.00 14 $604.38 $0.00 $18,885.25 $31,914.75 $253,221.70 24 Revenue Budget by Account Classification Report 0/J2 -a L-S.-rl9 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �I z _ _ - -eae- _ Egu_t E_e Share Funds REVENUE -Ines_.-- 50,500.00 .00 50,500.00 .00 .00 16,238.24 34,261.76 32 253,207.30 _-.ve__ , _ - come 300.00 .00 300.00 604.38 .00 2,647.01 (2,347.01) 882 14.40 REVENUE TOTALS unc 044 _ x 3 _ Equ_t b_e Share _CFunds _ ovals $50,800.00 $0.00 $50,800.00 $604.38 $0.00 $18,885.25 $31,914.75 37% $253,221.70 $50,800.00 $0.00 $50,800.00 14 $604.38 $0.00 $18,885.25 $31,914.75 $253,221.70 24 REVENUE TOTALS unc 45 DUs - _e = a__s = ovals $3,100.00 $0.00 $3,100.00 $173.75 $0.00 $774.09 $2,325.91 25% $4.62 $3,100.00 $0.00 $3,100.00 $173.75 $0.00 $774.09 $2,325.91 $4.62 15 25 Revenue Budget by Account Classification Report 05131123 5c_ ea- AcriViry T-cluded Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD =Ir OAS - DUI =_ d C REVENUE TOTALS . _, .d 046 - =or _an _ _re -�ax Board = a__m _ otal< $75,600.00 $0.00 $75,600.00 $1,433.19 $0.00 $5,647.90 $69,952.10 7% $160.57 $75,600.00 $0.00 $75,600.00 $1,433.19 $0.00 $5,647.90 $69,952.10 $160.57 16 26 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Ira Fo-eign Fire Boar4 Fund REVENUE - _axe_ 75,000.00 .00 75,000.00 .00 .00 .00 75,000.00 0 2.23 _.ve__._,.. _--come 600.00 .00 600.00 1,433.19 .00 5,647.90 (5,047.90) 941 158.34 07 a enue .00 .00 .00 .00 .00 .00 .00 +++ .00 0-er HnWcing SourceS .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS . _, .d 046 - =or _an _ _re -�ax Board = a__m _ otal< $75,600.00 $0.00 $75,600.00 $1,433.19 $0.00 $5,647.90 $69,952.10 7% $160.57 $75,600.00 $0.00 $75,600.00 $1,433.19 $0.00 $5,647.90 $69,952.10 $160.57 16 26 REVENUE TOTALS u -C! - Business D_stft = a s _ ovals $1,421,500.00 $0.00 $1,421,500.00 $23,707.89 $0.00 $396,193.22 $1,025,306.78 28% $285,333.48 $1,421,500.00 $0.00 $1,421,500.00 17 $23,707.89 $0.00 $396,193.22 $1,025,306.78 $285,333.48 27 Revenue Budget by Account Classification Report 0/J2 =_a � _{ Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �I. z 048 - Business District =un REVENUE v _axe_ 820,000.00 .00 820,000.00 74,235.47 .00 235,501.27 584,498.73 29 192,035.28 -ma Rvvvnue 600,000.00 .00 600,000.00 (53,664.49) .00 150,464.33 449,535.67 25 92,827.97 efe e.t_ 1,500.00 .00 1,500.00 3,136.91 .00 10,227.62 8,727.62 682 470.23 0--e 3: nc SourceS .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS u -C! - Business D_stft = a s _ ovals $1,421,500.00 $0.00 $1,421,500.00 $23,707.89 $0.00 $396,193.22 $1,025,306.78 28% $285,333.48 $1,421,500.00 $0.00 $1,421,500.00 17 $23,707.89 $0.00 $396,193.22 $1,025,306.78 $285,333.48 27 REVENUE TOTALS r..x049 - P3 neba d Ma _ _ a_ _ a _ a _ val $1,905,000.00 $0.00 $1,905,000.00 $4,100.17 $0.00 $697,188.20 $1,207,811.80 37% $756,226.79 $1,905,000.00 $0.00 $1,905,000.00 $4,100.17 $0.00 $697,188.20 $1,207,811.80 $756,226.79 18 28 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD =Ir 049 - DrosDect and Main -g� District REVENUE rvne :y_axes 1,900,000.00 .00 1,900,000.00 .00 .00 682,752.55 1,217,247.45 36 756,226.79 _.ve__._,.._--come .00 .00 .00 4,100.17 .00 14,435.65 (14,435.65) +++ .00 011er Revenue 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00 0—er HnWcing SourceS .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS r..x049 - P3 neba d Ma _ _ a_ _ a _ a _ val $1,905,000.00 $0.00 $1,905,000.00 $4,100.17 $0.00 $697,188.20 $1,207,811.80 37% $756,226.79 $1,905,000.00 $0.00 $1,905,000.00 $4,100.17 $0.00 $697,188.20 $1,207,811.80 $756,226.79 18 28 REVENUE TOTALS unci 5 este' end Sewer = u__- _ ota s $25,471,800.00 $0.00 $25,471,800.00 $1,646,901.44 $0.00 $8,434,869.99 $17,036,930.01 33% $7,353,250.32 $25,471,800.00 $0.00 $25,471,800.00 $1,646,901.44 $0.00 $8,434,869.99 $17,036,930.01 $7,353,250.32 19 29 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD z O5O - Water and Sewer - _n REVENUE rvne :y-axes .00 .00 .00 .00 .00 (25.88) 25.88 +++ 3,808.30 icer_ u.m.__ & -eeS 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 irterracverrmerta Revenue 535,000.00 .00 535,000.00 .00 .00 .00 535,000.00 0 .00 Ch c- Sery ces 19,444,600.00 .00 19,444,600.00 1,537,890.64 .00 7,887,936.25 11,556,663.75 41 7,262,792.95 is 131,200.00 .00 131,200.00 8,589.07 .00 63,174.41 68,025.59 48 56,785.62 -_.v3_...�. _-:.come 25,000.00 .00 25,000.00 94,601.73 .00 452,905.21 (427,905.21) 1812 14,785.62 } e- ent1- .00 .00 .00 .00 .00 .00 .00 +++ .00 0-e- Revenue 35,000.00 .00 35,000.00 5,820.00 .00 30,880.00 4,120.00 88 22,694.43 Oiser -inancinq SourceS 5,300,000.00 .00 5,300,000.00 .00 .00 .00 5,300,000.00 0 .00 REVENUE TOTALS unci 5 este' end Sewer = u__- _ ota s $25,471,800.00 $0.00 $25,471,800.00 $1,646,901.44 $0.00 $8,434,869.99 $17,036,930.01 33% $7,353,250.32 $25,471,800.00 $0.00 $25,471,800.00 $1,646,901.44 $0.00 $8,434,869.99 $17,036,930.01 $7,353,250.32 19 29 REVENUE TOTALS una 4151 _ Vfflage Parking System _ un- . b.ta $25,360.00 $0.00 $25,360.00 $3,098.11 $0.00 $13,878.72 $11,481.28 55% $8,437.00 $25,360.00 $0.00 $25,360.00 $3,098.11 $0.00 $13,878.72 $11,481.28 $8,437.00 20 30 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 05s - ___age Park=ng System =un REVENUE - _axe_ .00 .00 .00 .00 .00 .00 .00 +++ .00 - o-ServceS 24,400.00 .00 24,400.00 2,659.55 .00 12,045.04 12,354.96 49 8,205.26 erg, _ ircame 600.00 .00 600.00 354.21 .00 1,491.38 (891.38) 249 95.59 0-e ,je-ue 360.00 .00 360.00 84.35 .00 342.30 17.70 95 136.15 0 .er _ln n,_ _.a Sources. .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS una 4151 _ Vfflage Parking System _ un- . b.ta $25,360.00 $0.00 $25,360.00 $3,098.11 $0.00 $13,878.72 $11,481.28 55% $8,437.00 $25,360.00 $0.00 $25,360.00 $3,098.11 $0.00 $13,878.72 $11,481.28 $8,437.00 20 30 REVENUE TOTALS Parking yste Revenue r d eaS $87,336.00 $0.00 $87,336.00 $12,531.20 $0.00 $55,210.90 $32,125.10 63% $32,725.77 $87,336.00 $0.00 $87,336.00 $12,531.20 $0.00 $55,210.90 $32,125.10 $32,725.77 21 31 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -I r � - Parking _ tRevenue -u__ g REVENUE - _axe_ .00 .00 .00 .00 .00 .00 .00 +++ .00 mRevenue .00 .00 .00 .00 .00 .00 .00 +++ .00 __ t _u 85,200.00 .00 85,200.00 11,319.25 .00 50,371.40 34,828.60 59 31,763.60 216.00 .00 216.00 562.35 .00 2038.45 , .45 44 40.97 C _a ,t_�nuU 1,920.00 .00 1,920.00 649.60 .00 2,801.05 881.05 146 921.20 `,-,e `` ng Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Parking yste Revenue r d eaS $87,336.00 $0.00 $87,336.00 $12,531.20 $0.00 $55,210.90 $32,125.10 63% $32,725.77 $87,336.00 $0.00 $87,336.00 $12,531.20 $0.00 $55,210.90 $32,125.10 $32,725.77 21 31 REVENUE TOTALS r. x060 - �� _b_ Ma _na a E ata va - $2,579,592.00 $0.00 $2,579,592.00 $217,724.14 $0.00 $1,084,826.57 $1,494,765.43 42% $846,923.55 $2,579,592.00 $0.00 $2,579,592.00 $217,724.14 $0.00 $1,084,826.57 $1,494,765.43 $846,923.55 22 32 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 060 - Ve _c_d Maintenance � _n REVENUE _ _- v v ceF 2,577,792.00 .00 2,577,792.00 214,816.01 .00 1,074,080.05 1,503,711.95 42 846,829.50 _.ve__._,.. _--co. e 1,800.00 .00 1,800.00 2,908.13 .00 10,746.52 (8,946.52) 597 270.76 011er Revenue .00 .00 .00 .00 .00 .00 .00 +++ (176.71) 0—er HnWcing SourceS .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS r. x060 - �� _b_ Ma _na a E ata va - $2,579,592.00 $0.00 $2,579,592.00 $217,724.14 $0.00 $1,084,826.57 $1,494,765.43 42% $846,923.55 $2,579,592.00 $0.00 $2,579,592.00 $217,724.14 $0.00 $1,084,826.57 $1,494,765.43 $846,923.55 22 32 REVENUE TOTALS u -c! 061 - Veh c Reg_ ce e a - r s _ oe'_s $2,412,370.00 $0.00 $2,412,370.00 $209,587.96 $0.00 $1,184,990.10 $1,227,379.90 49% $371,041.30 $2,412,370.00 $0.00 $2,412,370.00 $209,587.96 $0.00 $1,184,990.10 $1,227,379.90 $371,041.30 23 33 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 0 s - e _c=d Re _acd bnt - _n REVENUE _ _- v v ceF 2,326,330.00 .00 2,326,330.00 193,860.83 .00 969,304.15 1,357,025.85 42 565,187.50 e nre is 1,040.00 .00 1,040.00 .00 .00 .00 1,040.00 0 38.07 imf _ income 85,000.00 .00 85,000.00 8,176.13 .00 204,634.94 (119,634.94) 241 (205,264.29) ._.. e -e :_ .00 .00 .00 .00 .00 .00 .00 +++ .00 Oo-er Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 `,-,e `` ng Sources .00 .00 .00 7,551.00 .00 11,051.01 REVENUE TOTALS u -c! 061 - Veh c Reg_ ce e a - r s _ oe'_s $2,412,370.00 $0.00 $2,412,370.00 $209,587.96 $0.00 $1,184,990.10 $1,227,379.90 49% $371,041.30 $2,412,370.00 $0.00 $2,412,370.00 $209,587.96 $0.00 $1,184,990.10 $1,227,379.90 $371,041.30 23 33 REVENUE TOTALS u.:_ 062 - ComDuter ReD_ac _rnegt _urea . z)ra s $181,000.00 $0.00 $181,000.00 $16,047.63 $0.00 $79,409.89 $101,590.11 44% $87,594.99 $181,000.00 $0.00 $181,000.00 $16,047.63 $0.00 $79,409.89 $101,590.11 $87,594.99 24 34 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 062 - Comouter Re _ace___bnt � _n REVENUE _ _- v v ceF 181,000.00 .00 181,000.00 15,083.34 .00 75,416.70 105,583.30 42 87,541.65 _.ve__._,.._--come .00 .00 .00 964.29 .00 3,993.19 (3,993.19) +++ 53.34 O _l-Inancinci res .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS u.:_ 062 - ComDuter ReD_ac _rnegt _urea . z)ra s $181,000.00 $0.00 $181,000.00 $16,047.63 $0.00 $79,409.89 $101,590.11 44% $87,594.99 $181,000.00 $0.00 $181,000.00 $16,047.63 $0.00 $79,409.89 $101,590.11 $87,594.99 24 34 REVENUE TOTALS x 06 Risk Baena = as _ ovals $10,209,470.00 $0.00 $10,209,470.00 $841,583.65 $0.00 $4,230,955.94 $5,978,514.06 41% $4,228,868.71 $10,209,470.00 $0.00 $10,209,470.00 $841,583.65 $0.00 $4,230,955.94 $5,978,514.06 $4,228,868.71 25 35 Revenue Budget by Account Classification Report 05131123 5c_ ea- AcriViry T-cluded Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 063 - Risk Management =nn REVENUE _ _- Lery ceF 8,528,950.00 .00 8,528,950.00 678,098.77 .00 3,449,272.66 5,079,677.34 40 3,466,691.59 _.ve__._,.. _--come 5,000.00 .00 5,000.00 758.67 .00 4,822.61 177.39 96 69.36 :e r _ e s .00 .00 .00 4,719.27 .00 44,563.61 (44,563.61) +++ 21,459.48 0—e ,je-ue 1,675,520.00 .00 1,675,520.00 158,006.94 .00 732,297.06 943,222.94 44 740,648.28 REVENUE TOTALS x 06 Risk Baena = as _ ovals $10,209,470.00 $0.00 $10,209,470.00 $841,583.65 $0.00 $4,230,955.94 $5,978,514.06 41% $4,228,868.71 $10,209,470.00 $0.00 $10,209,470.00 $841,583.65 $0.00 $4,230,955.94 $5,978,514.06 $4,228,868.71 25 35 Revenue Budget by Account Classification Report 05131123 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD =Ia 073 - Cscrow DeDosit Fun REVENUE i-ves_ ircome .00 .00 .00 593.83 .00 1,249.14 (1,249.14) +++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $593.83 $0.00 $1,249.14 ($1,249.14) +++ $0.00 _ $593.83 $0.00$1,249.14 ($1,249.14)0TH Escrow ?eors_t and o als $0.00 $0.00 $0.00 $0.00 `-a- to -s $143,151,313.00 $6,901,344.00 $150,052,657.00 $16,441,561.98 $0.00 $53,866,225.86 $96,186,431.14 $46,272,544.67 26 36 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS $76,503,153.00 $8,143,399.33 $84,646,552.33 $10,938,437.70 $2,386,033.59 $30,453,431.81 $51,807,086.93 39% $23,255,145.06 ,. d 00Genera. _ and ,.:_a a $76,503,153.00 $8,143,399.33 $84,646,552.33 $10,938,437.70 $2,386,033.59 $30,453,431.81 $51,807,086.93 $23,255,145.06 1 37 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD _Ia 001 - Genera_ �u EXPENSE _._ = Services, Sa arles Waaes32,829,630.00 211,850.00 33,041,480.00 2,427,960.10 .00 12,116,094.55 20,925,385.45 37 11,283,235.46 3,. e__ 17,106,395.00 59,174.00 17,165,569.00 625,229.60 .00 6,973,917.18 10,191,651.82 41 8,116,282.24 Oz °e- Emn o•v e . ts=a 577,818.00 151,030.00 728,848.00 78,429.70 34,960.96 229,935.67 463,951.37 36 176,247.46 _., Be -e- s 6,744.00 .00 6,744.00 562.12 .00 2,810.60 3,933.40 42 2,728.75 u. r- 10,700,008.00 (3,737.50) 10,696,270.50 878,064.16 869,573.68 3,544,949.79 6,281,747.03 41 2,707,246.63 Uy les 178,827.00 (400.00) 178,427.00 12,008.54 .00 36,582.28 141,844.72 21 41,814.24 E ince 796,814.00 .00 796,814.00 65,078.20 .00 325,266.25 471,547.75 41 346,227.70 crnmcciiiies & S DD _Ys 881,926.00 4,970.00 886,896.00 86,810.73 52,434.59 290,381.51 544,079.90 39 257,159.60 na s 99,305.00 .00 99,305.00 .00 .00 69,085.46 30,219.54 70 58,764.86 .'� n ov __ 4,000.00 .00 4,000.00 .00 .00 .00 4,000.00 0 433.74 Dmert 44,922.00 .00 44,922.00 324.80 .00 7,609.42 37,312.58 17 20,111.36 `= e - 300,074.00 636.00 300,710.00 37,571.23 138,326.25 95,095.59 67,288.16 78 83,336.71 Dist an Svstems .00 .00 .00 .00 .00 .00 .00 +++ .00 _ 1,626,690.00 1,219,876.83 2,846,566.83 226,398.52 1,290,738.11 261,703.51 1,294,125.21 55 161,556.31 ifte.u_a .-3`._._.S 11,350,000.00 6,500,000.00 17,850,000.00 6,500,000.00 .00 6,500,000.00 11,350,000.00 36 .00 EXPENSE TOTALS $76,503,153.00 $8,143,399.33 $84,646,552.33 $10,938,437.70 $2,386,033.59 $30,453,431.81 $51,807,086.93 39% $23,255,145.06 ,. d 00Genera. _ and ,.:_a a $76,503,153.00 $8,143,399.33 $84,646,552.33 $10,938,437.70 $2,386,033.59 $30,453,431.81 $51,807,086.93 $23,255,145.06 1 37 Expense Budget by Account Classification Report hrough 05/1-/-;3 calv-ACr -Il-ded Summary 1Sj-nCl EXPENSE TOTALS -und 002 - Debt Service and -ota Q_ $4,578,106.00 $0.00 $4,578,106.00 $1,051,470.00 $0.00 $1,052,798.00 $3,525,308.00 23% $1,152,223.63 $4,578,106.00 $0.00 $4,578,106.00 $1,051,470.00 $0.00 $1,052,798.00 $3,525,308.00 $1,152,223.63 38 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 002 - Deot Service EXPENSE Ct. :ractua S ceF .00 .00 .00 .00 .00 .00 .00 . . . .00 0 -re r _xPendiwre_- .00 .00 .00 .00 .00 .00 .00 ... .00 Bnrcl P- rc nln 2,385,000.00 .00 2,385,000.00 .00 .00 .00 2,385,000.00 0 .00 - rierest - xDe-e 2,191,156.00 .00 2,191,156.00 1,051,470.00 .00 1,051,470.00 1,139,686.00 48 1,150,445.63 B2rk & Rscc_� -ee-Q 1,950.00 .00 1,950.00 .00 .00 1,328.00 622.00 68 1,778.00 --te-una _w_,fe-_, .00 .00 .00 .00 .00 .00 .00 ... .00 tkrr - inRncing us - .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS -und 002 - Debt Service and -ota Q_ $4,578,106.00 $0.00 $4,578,106.00 $1,051,470.00 $0.00 $1,052,798.00 $3,525,308.00 23% $1,152,223.63 $4,578,106.00 $0.00 $4,578,106.00 $1,051,470.00 $0.00 $1,052,798.00 $3,525,308.00 $1,152,223.63 38 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS $3,888,831.00 $2,499,975.51 $6,388,806.51 $149,987.01 $2,126,842.16 $480,796.97 $3,781,167.38 41% $344,938.12 ,. 020 - Cad t _ imoro emen ung _t s $3,888,831.00 $2,499,975.51 $6,388,806.51 $149,987.01 $2,126,842.16 $480,796.97 $3,781,167.38 $344,938.12 3 39 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD - a 020 - Caolta_ imorovement Fund EXPENSE Cvn:ractua: Sery ceF .00 .00 .00 .00 .00 .00 .00 +++ 19,100.00 0 -re ,, end M-ev 891,000.00 18,600.00 909,600.00 .00 .00 18,600.00 891,000.00 2 .00 Lana -- -.ov .. e :s .00 .00 .00 .00 .00 .00 .00 +++ .00 'r c =- s 613,500.00 2,275,419.31 2,888,919.31 27,561.40 1,800,864.07 337,064.36 750,990.88 74 188,224.51 O 1 , : err 100,000.00 .00 100,000.00 .00 .00 .00 100,000.00 0 .00 -q .00 .00 .00 .00 .00 .00 .00 +++ .00 00 01T.er Eapmen-- 149,000.00 .00 149,000.00 .00 110,255.00 .00 38,745.00 74 101,700.00 f- _um 2,135,331.00 205,956.20 2,341,287.20 122,425.61 215,723.09 125,132.61 2,000,431.50 15 35,913.61 irte -_a ransfe-s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,888,831.00 $2,499,975.51 $6,388,806.51 $149,987.01 $2,126,842.16 $480,796.97 $3,781,167.38 41% $344,938.12 ,. 020 - Cad t _ imoro emen ung _t s $3,888,831.00 $2,499,975.51 $6,388,806.51 $149,987.01 $2,126,842.16 $480,796.97 $3,781,167.38 $344,938.12 3 39 Expense Budget by Account Classification Report r fig_ Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS $3,490,000.00 $2,841,003.80 $6,331,003.80 $1,200,381.87 $2,942,651.16 $1,275,303.76 $2,113,048.88 67% $830,081.11 023 - Street imorovement Construe and _ ota S $3,490,000.00 $2,841,003.80 $6,331,003.80 $1,200,381.87 $2,942,651.16 $1,275,303.76 $2,113,048.88 $830,081.11 4 40 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 023 - Street imorovement Construe �u__-a EXPENSE Cvn:ractua: ev ceF 40,000.00 .00 40,000.00 6,492.00 33,508.00 6,492.00 .00 100 .00 0 -re xDend Mrev .00 .00 .00 .00 .00 .00 .00 +++ .00 Lana _, -.ov .. e :s .00 .00 .00 .00 .00 .00 .00 +++ .00 ras-ructure 3,450,000.00 2,841,003.80 6,291,003.80 1,193,889.87 2,909,143.16 1,268,811.76 2,113,048.88 66 830,081.11 e.. er un .:a.-._ e .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,490,000.00 $2,841,003.80 $6,331,003.80 $1,200,381.87 $2,942,651.16 $1,275,303.76 $2,113,048.88 67% $830,081.11 023 - Street imorovement Construe and _ ota S $3,490,000.00 $2,841,003.80 $6,331,003.80 $1,200,381.87 $2,942,651.16 $1,275,303.76 $2,113,048.88 $830,081.11 4 40 Expense Budget by Account Classification Report 0-VU/23 Summary Isung EXPENSE TOTALS .._ _Mond Contro_ Construction _ and , ota Q_ $1,915,030.00 $0.00 $1,915,030.00 $2,954.39 $65,430.28 $17,367.75 $1,832,231.97 4% $138,370.59 $1,915,030.00 $0.00 $1,915,030.00 5 $2,954.39 $65,430.28 $17,367.75 $1,832,231.97 $138,370.59 41 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 024 _ - Construction Fund EXPENSE Ctn_. _ ctu _ `erviceF 229,840.00 .00 229,840.00 2,954.39 63,262.52 17,260.27 149,317.21 35 15,755.12 Ui eS 6,780.00 .00 6,780.00 .00 .00 107.48 6,672.52 2 .00 _.. =k_ & eS 5,410.00 .00 5,410.00 .00 .00 .00 5,410.00 0 255.47 _ _v �-xDen. , .00 , .00 .00 .00 , 0 .000- Ozrer Eapmert .00 .00 .00 .00 .00 .00 .00 +++ 113,010.00 _._e o 3 Sv ems .00 .00 .00 .00 .00 .00 .00 +++ .00 c u 1,668,000.00 .00 1,668,000.00 .00 2,167.76 .00 1,665,832.24 0 9,350.00 EXPENSE TOTALS .._ _Mond Contro_ Construction _ and , ota Q_ $1,915,030.00 $0.00 $1,915,030.00 $2,954.39 $65,430.28 $17,367.75 $1,832,231.97 4% $138,370.59 $1,915,030.00 $0.00 $1,915,030.00 5 $2,954.39 $65,430.28 $17,367.75 $1,832,231.97 $138,370.59 41 Expense Budget by Account Classification Report 0-VU/23 Summary _a_ -_sting EXPENSE TOTALS $155,100.00 $0.00 $155,100.00 $0.00 $0.00 $168.00 $154,932.00 0% $0.00 $155,100.00 $0.00 $155,100.00 L $0.00 $0.00 $168.00 $154,932.00 $0.00 42 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 037 - S _ - - Fund EXPENSE 071--i _. p ovee Cuss 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00 U..-.-. ____, Sery ce_ 100,000.00 .00 100,000.00 .00 .00 168.00 99,832.00 0 .00 _.. =k_ & S--,-, leS 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 . _ e -v _v-ev 50,000.00 .00 50,000.00 .00 .00 .00 50,000.00 0 .00 EXPENSE TOTALS $155,100.00 $0.00 $155,100.00 $0.00 $0.00 $168.00 $154,932.00 0% $0.00 $155,100.00 $0.00 $155,100.00 L $0.00 $0.00 $168.00 $154,932.00 $0.00 42 Expense Budget by Account Classification Report r 3g_ -b— Hs _ vear Actrvfty included Summary -_sting Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird =30 - Denton st b___¢at_on � _n EXPENSE Emp e M- ks 750,000.00 .00 750,000.00 .00 .00 .00 750,000.00 0 .00 -. _er.un, . s__�,.._ .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $750,000.00 $0.00 $750,000.00 $0.00 $0.00 $0.00 $750,000.00 0% $0.00 $750,000.00 $0.00 $750,000.00 $0.00 $0.00 $0.00 $750,000.00 $0.00 7 43 Expense Budget by Account Classification Report 0-VU/23 Summary _a_ -_sting EXPENSE TOTALS t Refuse Disoosa_ _ and . ota $5,044,137.00 $0.00 $5,044,137.00 $408,293.32 $12,497.98 $1,752,262.68 $3,279,376.34 35% $1,659,501.94 $5,044,137.00 $0.00 $5,044,137.00 $408,293.32 LIN $12,497.98 $1,752,262.68 $3,279,376.34 $1,659,501.94 44 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 0-_0 - Refuse Disoosa_ Fund EXPENSE _._ = Services,Sa arles Waces342,239.00 .00 342,239.00 25,147.47 .00 123,986.37 218,252.63 36 120,392.54 w; cvee Le. e __ 136,688.00 .00 136,688.00 9,185.27 .00 57,719.91 78,968.09 42 52,004.12 Oz_. ,D 0,ee, _S 1,636.00 .00 1,636.00 693.84 .00 693.84 942.16 42 .00 Ccn—adua Sery ces 4,502,935.00 .00 4,502,935.00 371,380.84 10,150.00 1,543,995.35 2,948,789.65 35 1,477,245.15 Ut . _ .00 .00 .00 .00 .00 .00 .00 +++ .00 _ 16,164.00 .00 16,164.00 1,347.00 .00 6,735.00 9,429.00 42 6,826.65 Cmmcu u & S,w , 44,475.00 .00 44,475.00 538.90 2,347.98 19,132.21 22,994.81 48 3,033.48 EXPENSE TOTALS t Refuse Disoosa_ _ and . ota $5,044,137.00 $0.00 $5,044,137.00 $408,293.32 $12,497.98 $1,752,262.68 $3,279,376.34 35% $1,659,501.94 $5,044,137.00 $0.00 $5,044,137.00 $408,293.32 LIN $12,497.98 $1,752,262.68 $3,279,376.34 $1,659,501.94 44 Expense Budget by Account Classification Report hrough 05/1-/23 calv-ACr -Il-ded Summary 1SI-nCl EXPENSE TOTALS $3,256,975.00 $0.00 $3,256,975.00 $1,084,850.43 $1,285,600.78 $1,439,713.49 $531,660.73 84% $2,296,354.82 041 - Motor ue _ax and -ota S $3,256,975.00 $0.00 $3,256,975.00 $1,084,850.43 $1,285,600.78 $1,439,713.49 $531,660.73 $2,296,354.82 45 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Ira 041 - Motor -se Tax F Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS C.DB t., $480,000.00 $0.00 $480,000.00 $205,657.17 $0.00 $214,466.64 $265,533.36 45% $42,499.85 $480,000.00 $0.00 $480,000.00 $205,657.17 $0.00 $214,466.64 $265,533.36 $42,499.85 10 46 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD - r 042 - CDBG EXPENSE _. _ = Services, va a .00 .00 .00 .00 .00 .00 .00 +++ .00 3, . e __ .00 .00 .00 .00 .00 .00 .00 +++ .00 Oz °e- Emn o•v e . ts=a .00 .00 .00 .00 .00 .00 .00 +++ .00 -� n --a__, a- __ery c s 480,000.00 .00 480,000.00 205,657.17 .00 214,466.64 265,533.36 45 42,499.85 u. �c les .00 .00 .00 .00 .00 .00 .00 +++ .00 < , e. -xDe-v tore .00 .00 .00 .00 .00 .00 .00 +++ .00 Lina o m .00 .00 .00 .00 .00 .00 .00 +++ .00 .'� n mp_ r ' -s .00 .00 .00 .00 .00 .00 .00 +++ .00 c w- .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS C.DB t., $480,000.00 $0.00 $480,000.00 $205,657.17 $0.00 $214,466.64 $265,533.36 45% $42,499.85 $480,000.00 $0.00 $480,000.00 $205,657.17 $0.00 $214,466.64 $265,533.36 $42,499.85 10 46 Expense Budget by Account Classification Report 0-VU/23 Summary _a_ -_sting EXPENSE TOTALS v -C! 043 - Asea Se_zu. = a_.m . to s $6,000.00 $0.00 $6,000.00 $0.00 $0.00 $3,188.00 $2,812.00 53% $246.00 $6,000.00 $0.00 $6,000.00 $0.00 $0.00 $3,188.00 $2,812.00 11 $246.00 47 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 043 - Asset Se_¢u_d EXPENSE 071--i _. p ovee Cuss 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 U..-.-. ____, Sery ce_ 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00 _. k_ & S--,-, leS .00 .00 .00 .00 .00 .00 .00 +++ .00 0- er _` 3mer_ 3,000.00 .00 3,000.00 .00 .00 3,188.00 (188.00) 106 246.00 EXPENSE TOTALS v -C! 043 - Asea Se_zu. = a_.m . to s $6,000.00 $0.00 $6,000.00 $0.00 $0.00 $3,188.00 $2,812.00 53% $246.00 $6,000.00 $0.00 $6,000.00 $0.00 $0.00 $3,188.00 $2,812.00 11 $246.00 47 Expense Budget by Account Classification Report hrough 05/1-/23 calv-ACr -Il-ded Summary 1SI-nCl EXPENSE TOTALS una 044 dera Eaultao e Snare unds ota $91,000.00 $0.00 $91,000.00 $44,450.00 $0.00 $52,535.00 $38,465.00 58% $0.00 $91,000.00 $0.00 $91,000.00 $44,450.00 $0.00 $52,535.00 $38,465.00 $0.00 12 48 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Im 044 Equita— e S --are Funds EXPENSE Ct. :ractua Se ceF 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 -rnprovemen-S .00 .00 .00 .00 .00 .00 .00 ... .00 Ozle- Equ pent 90,000.00 .00 90,000.00 44,450.00 .00 52,535.00 37,465.00 58 .00 EXPENSE TOTALS una 044 dera Eaultao e Snare unds ota $91,000.00 $0.00 $91,000.00 $44,450.00 $0.00 $52,535.00 $38,465.00 58% $0.00 $91,000.00 $0.00 $91,000.00 $44,450.00 $0.00 $52,535.00 $38,465.00 $0.00 12 48 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS and 04 DUs �___e _ and ,. a S $3,000.00 $0.00 $3,000.00 $0.00 $0.00 $0.00 $3,000.00 0% $10,054.00 $3,000.00 $0.00 $3,000.00 $0.00 $0.00 $0.00 $3,000.00 $10,054.00 13 49 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD �Ia OAS - DUI =_ d EXPENSE -M- -, p ,L, os:s 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Cz-.-. __.<_, _-,.rviceS 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 =ezo - -men: .00 .00 .00 .00 .00 .00 .00 +++ .00 0- er _` 3m er_ 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 10,054.00 e.. er un .-a.-._ e .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS and 04 DUs �___e _ and ,. a S $3,000.00 $0.00 $3,000.00 $0.00 $0.00 $0.00 $3,000.00 0% $10,054.00 $3,000.00 $0.00 $3,000.00 $0.00 $0.00 $0.00 $3,000.00 $10,054.00 13 49 Expense Budget by Account Classification Report hrough 05/1-/23 calv-ACr -Il-ded Summary 1SI-nCl EXPENSE TOTALS �d re �ax BoarA 0--6 � �-orelsn � und ota $70,000.00 $0.00 $70,000.00 $22,931.72 $16,137.50 $29,940.66 $23,921.84 66% $35,544.31 $70,000.00 $0.00 $70,000.00 $22,931.72 $16,137.50 $29,940.66 $23,921.84 $35,544.31 14 50 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Ira Fo-el-In Fire Boar4 Fund EXPENSE -M- -, p cve Cos:s .00 .00 .00 1,302.86 .00 1,302.86 (1,302.86) . . . 1,971.76 Cz---adua Sery ceS 5,000.00 9,000.00 14,000.00 4,843.17 .00 8,742.29 5,257.71 62 3,411.33 IrSaWce .00 .00 .00 .00 .00 .00 .00 ... .00 -=rncaiiies & S -m) izv 65,000.00 (9,000.00) 56,000.00 16,785.69 10,102.50 17,171.55 28,725.95 49 .00 EJ dinq zs .00 .00 .00 .00 .00 .00 .00 . . . .00 0- er -aDmr_.00 .00 .00 .00 6,035.00 2,723.96 (8,758.96) ... 30,161.22 EXPENSE TOTALS �d re �ax BoarA 0--6 � �-orelsn � und ota $70,000.00 $0.00 $70,000.00 $22,931.72 $16,137.50 $29,940.66 $23,921.84 66% $35,544.31 $70,000.00 $0.00 $70,000.00 $22,931.72 $16,137.50 $29,940.66 $23,921.84 $35,544.31 14 50 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD _Ia 0-- - Business District � _n EXPENSE Bor, _ rlr .00 .00 .00 .00 .00 .00 .00 +++ .00 _u __e 1,421,500.00 .00 1,421,500.00 47,790.16 .00 300,843.95 1,120,656.05 21 233,186.68 EXPENSE TOTALS unu 04 Business D _sar__ _ca - ad _ yalu $1,421,500.00 $0.00 $1,421,500.00 $47,790.16 $0.00 $300,843.95 $1,120,656.05 21% $233,186.68 $1,421,500.00 $0.00 $1,421,500.00 $47,790.16 $0.00 $300,843.95 $1,120,656.05 $233,186.68 15 51 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ 16 52 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD _Ia 049 - DrosDect and =lain -g� District EXPENSE -M- p,L, os:s 1,500.00 .00 1,500.00 .00 .00 .00 1,500.00 0 .00 .u.-._. __ua Sery c _ 80,000.00 .00 80,000.00 3,384.00 .00 7,746.08 72,253.92 10 30,326.02 -_ a _, S & ^ es 1,500.00 .00 1,500.00 .00 .00 .00 1,500.00 0 .00 _ �-xDen. , , .00 , , , .00 , 878,010.72 270- 137,826.18 Larim ove m s .00 .00 .00 .00 .00 .00 .00 +++ .00 _ring `nprov e : s .00 .00 .00 .00 .00 .00 .00 +++ .00 c u- .00 .00 .00 .00 .00 .00 .00 +++ .00 Rord DrirciDa 605,000.00 .00 605,000.00 .00 .00 .00 605,000.00 0 .00 irterest ExPerse 667,038.00 .00 667,038.00 333,518.88 .00 333,518.88 333,519.12 50 341,743.88 Rv rk s__, -eee 1,000.00 .00 1,000.00 .00 .00 900.00 100.00 90 900.00 e..a_.tna .-=-ssers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $2,562,038.00 $0.00 $2,562,038.00 $353,122.88 $0.00 $670,154.24 $1,891,883.76 26% $510,796.08 .r 049 Drustrectand Main =a�D_st__at . _ s $2,562,038.00 $0.00 $2,562,038.00 $353,122.88 $0.00 $670,154.24 $1,891,883.76 $510,796.08 16 52 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS $29,473,135.00 $5,806,774.56 $35,279,909.56 $2,948,245.69 $8,409,143.36 $8,739,705.92 $18,131,060.28 49% $5,763,698.39 and 050 ater and Sewer _ un -<ta Q- $29,473,135.00 $5,806,774.56 $35,279,909.56 $2,948,245.69 $8,409,143.36 $8,739,705.92 $18,131,060.28 $5,763,698.39 17 53 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD _Ia 050 - Water and Sewer EXPENSE _._ = Services, Sa arles Waaes2,555,299.00 .00 2,555,299.00 172,120.61 .00 934,674.42 1,620,624.58 37 875,017.47 3, . e __ 965,373.00 .00 965,373.00 60,941.24 .00 411,900.39 553,472.61 43 389,560.58 Oz °e_ Emn o•v e . ts=a 47,211.00 .00 47,211.00 5,140.04 3,351.80 23,286.20 20,573.00 56 22,399.74 -� n --a__, a- __ery ces 9,870,945.00 .00 9,870,945.00 830,517.87 480,828.48 3,150,764.40 6,239,352.12 37 3,060,096.56 Ut . _ 131,785.00 .00 131,785.00 11,834.72 .00 34,849.17 96,935.83 26 34,794.05 _ 208,340.00 .00 208,340.00 17,361.67 .00 86,808.35 121,531.65 42 71,096.25 _. u _ , 311,600.00 .00 311,600.00 58,141.89 66,398.39 151,705.61 93,496.00 70 111,255.67 0-.-.erxDen a -s .00 .00 .00 .00 .00 .00 .00 +++ .00 BJ qs .00 .00 .00 .00 .00 .00 .00 +++ .00 .'� n ov __ 5,500,000.00 .00 5,500,000.00 .00 76,295.00 50,750.00 5,372,955.00 2 109,179.98 Dmert 1,170.00 .00 1,170.00 .00 .00 .00 1,170.00 0 .00 `= e - 136,831.00 .00 136,831.00 16,334.85 37,105.15 36,715.76 63,010.09 54 33,610.30 DistIlDuJan Svstems 7,975,400.00 5,806,774.56 13,782,174.56 1,311,987.30 7,745,164.54 3,393,036.12 2,643,973.90 81 736,622.29 _ .00 .00 .00 .00 .00 .00 .00 +++ .00 BorDrinclPe 840,000.00 .00 840,000.00 .00 .00 .00 840,000.00 0 .00 ye . .._e 927,731.00 .00 927,731.00 463,865.50 .00 463,865.50 463,865.50 50 319,165.50 cc=e.. 1,450.00 .00 1,450.00 .00 .00 1,350.00 100.00 93 900.00 -. ie- _v ..,..._.e._ .00 .00 .00 .00 .00 .00 .00 +++ .00 __ c DO- .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $29,473,135.00 $5,806,774.56 $35,279,909.56 $2,948,245.69 $8,409,143.36 $8,739,705.92 $18,131,060.28 49% $5,763,698.39 and 050 ater and Sewer _ un -<ta Q- $29,473,135.00 $5,806,774.56 $35,279,909.56 $2,948,245.69 $8,409,143.36 $8,739,705.92 $18,131,060.28 $5,763,698.39 17 53 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ 18 54 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD - a 051 - __=a d Parking System � _n EXPENSE _. _ = Services, Sa arles Waaes.00 .00 .00 .00 .00 .00 .00 +++ 6,866.54 B . e __ .00 .00 .00 .00 .00 .00 .00 +++ 4,035.35 Cn:mcrua Servc a 51,002.00 .00 51,002.00 6,636.89 10,124.80 14,808.10 26,069.10 49 8,945.86 Uy .-s 10,400.00 .00 10,400.00 941.08 .00 4,833.56 5,566.44 46 5,689.13 IrU..rance 5,865.00 .00 5,865.00 488.75 .00 2,443.75 3,421.25 42 135.85 & S -DD ies 608.00 .00 608.00 .00 .00 607.88 .12 100 584.81 017rer ExpenalW u .00 .00 .00 .00 .00 .00 .00 +++ .00 . 'aings .00 .00 .00 .00 .00 .00 .00 +++ .00 13,1 q P -o ems .00 .00 .00 .00 .00 .00 .00 +++ .00 --f-aS--UdU-e U -e 75,000.00 .00 75,000.00 .00 25,112.00 2,019.40 47,868.60 36 2,489.17 irre tna -i -a-ssers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $142,875.00 $0.00 $142,875.00 $8,066.72 $35,236.80 $24,712.69 $82,925.51 42% $28,746.71 and 05 _a r Parsing System_ . _ s $142,875.00 $0.00 $142,875.00 $8,066.72 $35,236.80 $24,712.69 $82,925.51 $28,746.71 18 54 Expense Budget by Account Classification Report 0-VU/23 Summary Isung EXPENSE TOTALS $121,952.00 $0.00 $121,952.00 $6,308.96 $11,797.58 $22,229.39 $87,925.03 28% $30,792.29 rd _ _ g� $gig _ _als $121,952.00 $0.00 $121,952.00 $6,308.96 $11,797.58 $22,229.39 $87,925.03 $30,792.29 19 55 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -I a 5 - Parking _ t __ g Revenue -� EXPENSE _. _ = Services, va arles Waces.00 .00 .00 .00 .00 .00 .00 +++ 6,866.57 w; cvee Le. e __ .00 .00 .00 .00 .00 .00 .00 +++ 4,034.88 L_k a 98,005.00 .00 98,005.00 5,710.20 9,623.58 19,041.04 69,340.38 29 12,976.91 Uy .-s 10,764.00 .00 10,764.00 202.91 .00 1,317.09 9,446.91 12 1,197.65 �- .nce 1,502.00 .00 1,502.00 125.17 .00 625.85 876.15 42 781.25 & S Da ies 11,681.00 .00 11,681.00 270.68 2,174.00 1,245.41 8,261.59 29 4,935.03 017rer ExpenalW u .00 .00 .00 .00 .00 .00 .00 +++ .00 R,naings .00 .00 .00 .00 .00 .00 .00 +++ .00 13,1 dina 3-o ems .00 .00 .00 .00 .00 .00 .00 +++ .00 Cl . WS em .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $121,952.00 $0.00 $121,952.00 $6,308.96 $11,797.58 $22,229.39 $87,925.03 28% $30,792.29 rd _ _ g� $gig _ _als $121,952.00 $0.00 $121,952.00 $6,308.96 $11,797.58 $22,229.39 $87,925.03 $30,792.29 19 55 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS $2,578,756.00 $0.00 $2,578,756.00 $168,573.97 $354,000.63 $917,328.97 $1,307,426.40 49% $889,912.86 -gid 060 - e c e Maintenance un o_a s $2,578,756.00 $0.00 $2,578,756.00 $168,573.97 $354,000.63 $917,328.97 $1,307,426.40 $889,912.86 20 56 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD - a 060 - Vehic_d Maintenance Fund EXPENSE _. _ = Services, va arles Waaes1,085,980.00 .00 1,085,980.00 77,399.10 .00 398,959.25 687,020.75 37 398,118.64 3,. e__ 428,797.00 .00 428,797.00 27,091.43 .00 150,181.90 278,615.10 35 182,537.32 Ta °e_ Emn o•v e . ts=a 7,395.00 3,000.00 10,395.00 1,800.00 900.00 6,485.00 3,010.00 71 80.00 -� n --a__, a- __ery c s 174,386.00 (3,000.00) 171,386.00 9,141.59 14,395.92 24,369.88 132,620.20 23 20,177.61 U_.. _ 4,773.00 .00 4,773.00 536.14 .00 1,226.39 3,546.61 26 1,217.15 _ 13,819.00 .00 13,819.00 1,151.58 .00 5,757.90 8,061.10 42 5,872.10 Cmmcu u & S,w , 860,411.00 .00 860,411.00 51,391.20 338,704.71 329,889.67 191,816.62 78 281,910.04 0-.-.erxDe a -s .00 .00 .00 .00 .00 .00 .00 +++ .00 O�9ce Eaulpmen- 664.00 .00 664.00 62.93 .00 296.48 367.52 45 .00 0_,_ _ , er- 2,531.00 .00 2,531.00 .00 .00 162.50 2,368.50 6 .00 EXPENSE TOTALS $2,578,756.00 $0.00 $2,578,756.00 $168,573.97 $354,000.63 $917,328.97 $1,307,426.40 49% $889,912.86 -gid 060 - e c e Maintenance un o_a s $2,578,756.00 $0.00 $2,578,756.00 $168,573.97 $354,000.63 $917,328.97 $1,307,426.40 $889,912.86 20 56 Expense Budget by Account Classification Report 0VU/23 P -b_ Fscal vea- Acdvfty 1-duded Summary Isung EXPENSE TOTALS _ una 061 - Ve_lce ReD acernent ota S $1,295,000.00 $885,000.00 $2,180,000.00 $48,977.42 $34,844.05 $322,685.75 $1,822,470.20 16% $161,407.84 $1,295,000.00 $885,000.00 $2,180,000.00 21 $48,977.42 $34,844.05 $322,685.75 $1,822,470.20 $161,407.84 57 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ird 061-JehlceReoace mentC Expense Budget by Account Classification Report hrough 05/1-/23 calv-ACr -Il-ded Summary 1SI-nCl EXPENSE TOTALS una 062 - ComDuter ReD acement ug d —ota $401,000.00 $0.00 $401,000.00 $13,380.45 $0.00 $50,463.39 $350,536.61 13% $75,298.84 $401,000.00 $0.00 $401,000.00 $13,380.45 $0.00 $50,463.39 $350,536.61 $75,298.84 22 58 Adopted Budget Amended Current Month YTD YTD Budget - YTD G/o Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD -Ira 062 Comouter Reo acement Cund EXPENSE -.rei Expenaltures .00 .00 .00 .00 .00 .00 .00 . . . .00 -mprovemen-S 220,000.00 .00 220,000.00 .00 .00 .00 220,000.00 0 .00 0—ce Equ p -err 181,000.00 .00 181,000.00 13,380.45 .00 50,463.39 130,536.61 28 75,298.84 EXPENSE TOTALS una 062 - ComDuter ReD acement ug d —ota $401,000.00 $0.00 $401,000.00 $13,380.45 $0.00 $50,463.39 $350,536.61 13% $75,298.84 $401,000.00 $0.00 $401,000.00 $13,380.45 $0.00 $50,463.39 $350,536.61 $75,298.84 22 58 Expense Budget by Account Classification Report r 1g_2 Hca_ - CI-- __ .- Summary -_I_ EXPENSE TOTALS Adopted Budget Amended Current Month YTD YTD Budget - YTD °!o Used/ .,...y 06Risk1 n e_ ent _ and -o a S Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec"d Prior Year YTD _Ia 063 - Risk Management Fund $168,377,207.20 $19,601,132.69 $17,680,215.87 $52,596,719.80 $98,100,271.53 $41,933,708.85 EXPENSE Cvn:ractua: e v ceF 10,400.00 .00 10,400.00 .00 .00 .00 10,400.00 0 10,969.36 9,940,566.00 .00 9,940,566.00 896,425.53 .00 4,763,258.39 5,177,307.61 48 4,452,155.38 -„-, a _,eS & ^ es 22,500.00 .00 22,500.00 827.30 .00 13,364.35 9,135.65 59 11,784.99 0- e 3mer_ .00 .00 .00 .00 .00 .00 .00 +++ .00 e.. er un .:a.-._ e .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $9,973,466.00 $0.00 $9,973,466.00 $897,252.83 $0.00 $4,776,622.74 $5,196,843.26 48% $4,474,909.73 .,...y 06Risk1 n e_ ent _ and -o a S $9,973,466.00 $0.00 $9,973,466.00 $897,252.83 $0.00 $4,776,622.74 $5,196,843.26 $4,474,909.73 tas $148,201,054.00 $20,176,153.20 $168,377,207.20 $19,601,132.69 $17,680,215.87 $52,596,719.80 $98,100,271.53 $41,933,708.85 23 59