Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023 10-16 FCA
C IT Y C O UNC I L/F INANC I AL C O M M IS S IO N M E E T I NG Council Commission Room October 16, 2023 AGE NDA 1.Call to Order - 6:00 p.m. The City Council requests that attendees turn off cell phones and pagers during the meeting. A copy of the full City C ounc il packet is available to the public . The packet ring binder is loc ated at the entrance of the council chambers. 2.Roll Call 3.E nterprise F unds a.Utilities b.Central Garage c.Economic Development Authority (E D A) d.Tax Increment F inancing (T IF ) e.Debt 4.Future Budget Discussion/City Council M eetings a.October 30, 2023 - 5 p.m. - Audit Presentation Abdo - 6 p.m. - Special Revenue Funds 5.Adjournment COU N C IL ITEM MEMOR ANDUM DAT E:10/16/2023 TO :Dr. R eggie Edwards , C ity Manager T HR O UG H:N/A F R O M: S UBJ EC T:Utilities Background: AT TAC HME N T S: Desc ription Upload Date Type 2024 Utility R ecycling P ropos ed Budget 10/13/2023 Bac kup Material 2024 Utility S ewer P ropos ed Budget 10/13/2023 Bac kup Material 2024 Utility S torm S ewer P ropos ed Budget 10/13/2023 Bac kup Material 2024 Utility S treet Lights P roposed Budget 10/13/2023 Bac kup Material 2024 Utility Water P roposed Budget 10/13/2023 Bac kup Material Page 1 of 2 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 49311 - RECYCLING 4603 - INTEREST EARNINGS -2,104 -2,100 -2,200 -1,675 -2,047 -6.95%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -2,104 -2,100 -2,200 -1,675 -2,047 -6.95% 4605 - UNREALIZED INVESTMENT GAIN/LOS 2,563 8,485 0 TOTAL MISCELLANEOUS 2,563 8,485 0 4751 - RECYCLING SERVICE FEES -393,347 -401,337 -408,000 -203,883 -509,948 24.99% TOTAL OPERATING REVENUES -393,347 -401,337 -408,000 -203,883 -509,948 24.99% REVENUES -392,888 -394,951 -410,200 -205,558 -511,995 24.82% BLANK BLANK 1 6204 - STATIONARY SUPPLIES 0 0 0 0 6243 - MINOR COMPUTER EQUIPMENT 10 0 0 TOTAL SUPPLIES 10 0 0 0 BLANK 2 6307 - PROFESSIONAL SERVICES 36 31 0 0 TOTAL PROFESSIONAL SERVICES 36 31 0 0 BLANK 3 6322 - POSTAGE 0 0 0 0 6449 - OTHER CONTRACTUAL SERVICE 377,422 369,231 410,000 253,492 532,882 29.97%Increase in costs to City of Crystal of 21% 6423 - LOGIS CHARGES 6,354 6,184 7,263 3,180 7,639 5.18%8,020 LOGIS JDE Fina ncial, HR/PR, Hubble, Tungst en, GIS, IP Te lephony, Utili ty Billing/Inf inity.Mobile, Internet, 24/7 Support, Manag ed Service Bac k-up, Exchange , Virtual Serv ers and Email Archiving, and Network Wellne ss LOGIS JDE Fin ancial, HR/PR , Hubble, Tun gsten, GIS, IP Telephony, Utility Billi ng/Infinity.M obile, Intern et, 24/7 Supp ort, Managed Service Back- up, Exchange, Virtual Serve rs and Email Archiving, an d Network Wel lness LOGIS JDE Financial , HR/PR, Hubble, Tu ngsten, GIS, IP Tel ephony, Utility Bil ling/Infinity.Mobil e, Internet, 24/7 Support, Managed Se rvice Back-up, Exch ange, Virtual Serve rs and Email Archiv ing, and Network We llness TOTAL OTHER SERVICES & CHARGES 383,776 375,415 417,263 256,672 540,521 29.54%8,020 BLANK 4 Page 2 of 2 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6361 - GENERAL LIABILITY INSURANCE 1,404 1,097 1,418 1,372 3,156 122.57%Liability insurance increase due to claim history TOTAL INSURANCE 1,404 1,097 1,418 1,372 3,156 122.57% BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 BLANK 11 6471 - ADMINISTRATIVE SERVICE TRANSFE 17,831 18,211 20,838 10,422 22,063 5.88% TOTAL TRANSFERS OUT 17,831 18,211 20,838 10,422 22,063 5.88% BLANK 12 TOTAL BUSINESS UNIT EXPENSES 403,057 394,753 439,519 268,467 565,740 28.72%8,020 Page 1 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 49251 - SEWER UTILITY-OPERATIONS 4373 - OTHER GRANTS/AID 0 -72,999 0 LOCAL 0 -72,999 0 TOTAL INTERGOVERNMENTAL 0 -72,999 0 4603 - INTEREST EARNINGS -45,617 -47,267 -52,200 -36,042 -46,218 -11.46%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -45,617 -47,267 -52,200 -36,042 -46,218 -11.46% 4605 - UNREALIZED INVESTMENT GAIN/LOS 60,868 191,603 0 TOTAL MISCELLANEOUS 60,868 191,603 0 4721 - SEWER SERVICE -4,680,679 -5,117,729 -5,294,200 -2,593,789 -5,533,479 4.52% TOTAL OPERATING REVENUES -4,680,679 -5,117,729 -5,294,200 -2,593,789 -5,533,479 4.52% 4921 - REFUNDS & REIMBURSEMENTS -1,100 0 0 0 4931 - BOND SALES 0 0 0 0 -2,600,000 TOTAL OTHER FINANCING SOURCES -1,100 0 0 0 -2,600,000 REVENUES -4,666,528 -5,046,392 -5,346,400 -2,629,830 -8,179,697 52.99% BLANK 6101 - WAGES & SALARIES-FT EMPLOYEES 149,634 161,828 168,558 79,949 180,992 7.38% 6102 - OVERTIME-FT EMPLOYEES 20,050 24,072 18,000 12,687 18,000 0.00%Add $2K 6103 - WAGES-PART TIME EMPLOYEES 3,773 7,416 25,000 1,554 25,000 0.00%Same 6111 - SEVERANCE PAY 6,731 4,881 0 0 6122 - PERA COORDINATED PLAN 12,726 13,943 15,867 6,948 16,799 5.87% 6125 - FICA - SOCIAL SECURITY 11,197 12,510 13,117 6,068 13,888 5.88% 6126 - FICA - MEDICARE 2,619 2,926 3,069 1,419 3,248 5.83% 6131 - CAFETERIA PLAN CONTRIBUTIONS 30,360 33,264 39,401 17,136 41,317 4.86% 6151 - WORKER'S COMP INSURANCE 5,820 9,127 10,090 5,578 11,295 11.94% TOTAL PERSONAL SERVICES 242,912 269,966 293,102 131,339 310,539 5.95% BLANK 1 6201 - OFFICE SUPPLIES 100 42 2,600 1,519 1,000 -61.54%1,000 Add $2500 standing desk split w/water 6203 - BOOKS/REFERENCE MATERIALS 0 0 200 0 200 0.00%200 6204 - STATIONARY SUPPLIES 0 0 0 0 0 0 6214 - CLOTHING & PERSONAL EQUIPMENT 0 0 300 0 300 0.00%300 6216 - CHEMICALS/CHEMICAL PRODUCTS 10,139 3,825 11,500 0 11,500 0.00%11,500 Same Same Same 6217 - SAFETY SUPPLIES 13,091 1,561 10,000 293 10,000 0.00%10,000 4 Gas Monitors Same Same 6219 - GENERAL OPERATING SUPPLIES 693 6,045 3,500 749 18,500 428.57%3,500 Add $15k nozzle camera (Jetter) Page 2 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6223 - BUILDINGS & FACILITIES 0 9,985 40,000 483 10,000 -75.00%10,000 Need to install new Gen Set Plug at LS #1/clean LS. 6224 - STREET MAINT MATERIALS 861 0 7,500 0 7,500 0.00%7,500 6227 - PAINT SUPPLIES 667 936 1,000 221 2,000 100.00%2,000 More locates/projects More locates/projects 6239 - OTHER REPAIR & MAINT SUPPLIES 3,088 377 5,000 4,116 10,000 100.00%10,000 extra inventory 6241 - SMALL TOOLS 576 0 1,000 0 5,000 400.00%5,000 6242 - MINOR EQUIPMENT 925 685 2,600 521 2,000 -23.08%2,000 6243 - MINOR COMPUTER EQUIPMENT 70 4,305 0 0 0 0 No One Due No One Due TOTAL SUPPLIES 30,210 27,763 85,200 7,901 78,000 -8.45%63,000 BLANK 2 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,509 3,000 3,000 0 3,000 0.00% 6302 - ARCH, ENG & PLANNING 0 0 1,900 0 -100.00% 6307 - PROFESSIONAL SERVICES 6,786 3,124 55,000 1,259 55,000 0.00%10,000 Add $50k to install fiber LS#8 Add $50k to install fiber LS#4 TOTAL PROFESSIONAL SERVICES 9,294 6,124 59,900 1,259 58,000 -3.17%10,000 BLANK 3 6321 - TELEPHONE/PAGERS 1,298 522 1,500 91 660 -56.00%660 Smart Phones (3), Airwatch 2x T-Mobile Service $360, 1x iPad Data Service $300 2x T-Mobile Service $360, 1x iPad Data Service $300 6322 - POSTAGE 4,818 0 0 0 0 0 6441 - LICENSES, TAXES & FEES 0 0 300 0 300 0.00%300 6449 - OTHER CONTRACTUAL SERVICE 47,682 49,826 25,000 4,943 25,000 0.00%25,000 6351 - PRINTING 0 0 375 0 0 -100.00%0 6417 - UNIFORMS 800 0 1,000 0 1,000 0.00%1,000 6423 - LOGIS CHARGES 43,640 43,287 50,839 21,370 53,472 5.18%56,145 LOGIS JDE Fina ncial, HR/PR, Hubble, Tungst en, GIS, IP Te lephony, Utili ty Billing/Inf inity.Mobile, Internet, 24/7 Support, Manag ed Service Bac k-up, Exchange , Virtual Serv ers and Email Archiving, and Network Wellne ss LOGIS JDE Fin ancial, HR/PR , Hubble, Tun gsten, GIS, IP Telephony, Utility Billi ng/Infinity.M obile, Intern et, 24/7 Supp ort, Managed Service Back- up, Exchange, Virtual Serve rs and Email Archiving, an d Network Wel lness Page 3 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6432 - CONFERENCES AND SCHOOLS 3,801 1,671 4,000 260 4,000 0.00%4,000 6434 - DUES & SUBSCRIPTIONS 286 286 425 123 500 17.65%500 TOTAL OTHER SERVICES & CHARGES 102,325 95,592 83,439 26,788 84,932 1.79%87,605 BLANK 4 6361 - GENERAL LIABILITY INSURANCE 20,486 23,025 22,500 19,680 45,264 101.17% 6362 - PROPERTY INSURANCE 1,457 2,467 2,000 1,361 3,129 56.45% 6366 - MACHINERY BREAKDOWN INSURANCE 264 347 300 181 415 38.33% TOTAL INSURANCE 22,208 25,838 24,800 21,221 48,808 96.81% BLANK 5 6381 - ELECTRIC 34,630 69,026 40,300 289,901 60,000 48.88% 6391 - MET COUNCIL ENVIRON SVCS 2,554,790 2,591,885 3,019,710 1,474,913 3,266,661 8.18%3,266,661 14.1% Increase (per Met Council letter of $2,889,710) and BP estimate at $130k. 8.2% Increase (per Met Council letter of $3,126,661) and BP estimate at $140k. TOTAL UTILITY SERVICES 2,589,420 2,660,911 3,060,010 1,764,814 3,326,661 8.71%3,266,661 BLANK 6 6403 - BLDGS/FACILITIES MAINT SERVICE 3,765 2,109 7,000 4,526 7,000 0.00%7,000 6409 - OTHER REPAIR & MAINT SVCS 49,896 68,594 115,000 108,515 200,000 73.91%125,000 Add $30k maint on generators, $45k New cutter stack (MM) TOTAL REPAIRS & MAINTENANCE 53,660 70,702 122,000 113,041 207,000 69.67%132,000 BLANK 7 6461 - FUEL CHARGES 10,898 14,845 13,300 4,494 15,000 12.78%See allocation spreadsheet 6462 - FIXED CHARGES 19,650 17,462 23,114 9,547 23,114 0.00%See Central Garage Replacement Charge Allocation 6463 - REPAIR & MAINT CHARGES 11,622 19,512 15,000 6,751 15,000 0.00% 6465 - REPLACEMENT CHARGES 58,705 111,841 146,529 60,472 146,529 0.00%See Central Garage Replacement Charge Allocation TOTAL CENTRAL GARAGE CHARGES 100,875 163,660 197,943 81,265 199,643 0.86% BLANK 8 6494 - DEPRECIATION EXPENSE 1,030,919 1,092,596 1,030,919 533,840 1,067,680 3.57% TOTAL DEPRECIATION 1,030,919 1,092,596 1,030,919 533,840 1,067,680 3.57% Page 4 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget BLANK 9 6530 - IMPROVEMENTS 0 3,492 1,464,588 253,828 2,781,000 89.88% TOTAL CAPITAL OUTLAY 0 3,492 1,464,588 253,828 2,781,000 89.88% BLANK 10 6601 - BOND PRINCIPAL 0 0 833,213 833,213 833,213 0.00% 6611 - BOND INTEREST 176,581 187,776 246,569 92,438 184,876 -25.02% 6621 - PAYING AGENT/OTHER FEES -27,664 -42,605 0 0 TOTAL DEBT SERVICE 148,917 145,171 1,079,782 925,651 1,018,089 -5.71% BLANK 11 6471 - ADMINISTRATIVE SERVICE TRANSFE 166,744 167,842 255,907 127,956 251,710 -1.64% TOTAL TRANSFERS OUT 166,744 167,842 255,907 127,956 251,710 -1.64% BLANK 12 TOTAL BUSINESS UNIT EXPENSES 4,497,485 4,729,658 7,757,590 3,988,904 9,432,062 21.58%3,559,266 Page 1 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 49411 - STORM SEWER UTILITY-OPERATIONS 4373 - OTHER GRANTS/AID -50,000 0 0 0 LOCAL -50,000 0 0 0 TOTAL INTERGOVERNMENTAL -50,000 0 0 0 4603 - INTEREST EARNINGS -43,561 -54,490 -50,800 -39,718 -53,547 5.41%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -43,561 -54,490 -50,800 -39,718 -53,547 5.41% 4605 - UNREALIZED INVESTMENT GAIN/LOS 59,282 221,988 0 TOTAL MISCELLANEOUS 59,282 221,988 0 4731 - STORM DRAINAGE FEES -1,770,889 -1,887,218 -1,995,222 -995,554 -2,135,190 7.02% TOTAL OPERATING REVENUES -1,770,889 -1,887,218 -1,995,222 -995,554 -2,135,190 7.02% 4912 - CAPITAL CONTRIBUTIONS -485,710 -36,663 0 4931 - BOND SALES 0 0 0 0 -1,900,000 TOTAL OTHER FINANCING SOURCES -485,710 -36,663 0 0 -1,900,000 REVENUES -2,290,878 -1,756,382 -2,046,022 -1,035,272 -4,088,737 99.84% BLANK 6101 - WAGES & SALARIES-FT EMPLOYEES 224,053 232,967 244,098 114,924 258,749 6.00% 6102 - OVERTIME-FT EMPLOYEES 1,815 1,655 2,500 1,279 2,500 0.00% 6103 - WAGES-PART TIME EMPLOYEES 808 0 10,800 875 35,800 231.48%(1) 180 Day Employee 6111 - SEVERANCE PAY 5,650 4,393 0 0 0 6122 - PERA COORDINATED PLAN 16,940 17,597 19,305 8,715 22,280 15.41% 6125 - FICA - SOCIAL SECURITY 14,105 14,624 15,960 7,287 18,418 15.40% 6126 - FICA - MEDICARE 3,299 3,420 3,733 1,704 4,308 15.40% 6131 - CAFETERIA PLAN CONTRIBUTIONS 47,520 49,896 58,245 25,704 61,078 4.86% 6151 - WORKER'S COMP INSURANCE 14,055 15,098 20,991 9,506 25,763 22.73% TOTAL PERSONAL SERVICES 328,245 339,651 375,632 169,995 428,896 14.18% BLANK 1 6204 - STATIONARY SUPPLIES 0 0 0 0 6217 - SAFETY SUPPLIES 1,406 1,628 500 1,281 600 20.00% 6219 - GENERAL OPERATING SUPPLIES 48 526 6,000 1,855 31,000 416.67%Added 25k to support litter clean up initiatives 6224 - STREET MAINT MATERIALS 3,119 17 9,000 3,940 10,000 11.11% 6239 - OTHER REPAIR & MAINT SUPPLIES 20,091 28,932 36,000 2,716 36,000 0.00% 6241 - SMALL TOOLS 2,758 4,907 1,500 1,411 3,000 100.00% 6243 - MINOR COMPUTER EQUIPMENT 281 0 0 0 0 Page 2 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget TOTAL SUPPLIES 27,704 36,010 53,000 11,203 80,600 52.08% BLANK 2 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,509 3,000 3,000 0 3,000 0.00% 6302 - ARCH, ENG & PLANNING 55,554 26,258 20,000 0 -100.00% 6307 - PROFESSIONAL SERVICES 1,828 1,323 2,000 1,259 -100.00% TOTAL PROFESSIONAL SERVICES 59,890 30,581 25,000 1,259 3,000 -88.00% BLANK 3 6321 - TELEPHONE/PAGERS 600 -100.00% 6322 - POSTAGE 0 0 0 0 6329 - OTHER COMMUNICATION SERVICES 29 0 0 6331 - TRAVEL EXPENSE/MILEAGE 0 0 500 0 -100.00% 6342 - LEGAL NOTICES 0 0 150 0 -100.00% 6449 - OTHER CONTRACTUAL SERVICE 18,495 98,489 13,000 4,166 -100.00% 6351 - PRINTING 0 0 1,500 0 -100.00% 6417 - UNIFORMS 1,300 1,569 1,500 0 1,200 -20.00%Demand Pull of source materials 6423 - LOGIS CHARGES 24,996 24,735 29,051 12,277 30,556 5.18%32,083 LOGIS JDE Fina ncial, HR/PR, Hubble, Tungst en, GIS, IP Te lephony, Utili ty Billing/Inf inity.Mobile, Internet, 24/7 Support, Manag ed Service Bac k-up, Exchange , Virtual Serv ers and Email Archiving, and Network Wellne ss LOGIS JDE Fin ancial, HR/PR , Hubble, Tun gsten, GIS, IP Telephony, Utility Billi ng/Infinity.M obile, Intern et, 24/7 Supp ort, Managed Service Back- up, Exchange, Virtual Serve rs and Email Archiving, an d Network Wel lness LOGIS JDE Financial , HR/PR, Hubble, Tu ngsten, GIS, IP Tel ephony, Utility Bil ling/Infinity.Mobil e, Internet, 24/7 Support, Managed Se rvice Back-up, Exch ange, Virtual Serve rs and Email Archiv ing, and Network We llness 6432 - CONFERENCES AND SCHOOLS 390 0 700 0 800 14.29%M Jones & N Boehlke - National Pollutant Discharge Elimination System (NPDES) Training 6434 - DUES & SUBSCRIPTIONS 120,727 1,511 63,400 59,823 -100.00% TOTAL OTHER SERVICES & CHARGES 165,936 126,305 110,401 76,266 32,556 -70.51%32,083 BLANK 4 6361 - GENERAL LIABILITY INSURANCE 2,874 2,267 3,300 2,749 6,333 91.91% Page 3 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget TOTAL INSURANCE 2,874 2,267 3,300 2,749 6,333 91.91% BLANK 5 6384 - REFUSE DISPOSAL 1,843 2,560 5,000 680 8,000 60.00%Street Sweepings disposal Street Sweepings disposal TOTAL UTILITY SERVICES 1,843 2,560 5,000 680 8,000 60.00% BLANK 6 6409 - OTHER REPAIR & MAINT SVCS 21,629 8,542 100,000 21,768 140,000 40.00%Contract the weekly rain garden maintenance of weeding, fertlizing, planting & mulching of our 42 rain gardens. Shingle Creek wetland buffer, EBHC pond vegetation management and maintenance. Twin Lake Park wetland buffer maintenance, System repairs. Contract the weekly rain garden maintenance of weeding, fertlizing, planting & mulching of our 42 rain gardens. Shingle Creek wetland buffer, EBHC pond vegetation management and maintenance. Twin Lake Park wetland buffer maintenance, System repairs. TOTAL REPAIRS & MAINTENANCE 21,629 8,542 100,000 21,768 140,000 40.00% BLANK 7 6461 - FUEL CHARGES 10,631 9,633 10,400 3,851 10,400 0.00%See allocation spreadsheet 6462 - FIXED CHARGES 6,645 5,496 6,839 2,850 6,839 0.00%See Central Garage Replacement Charge Allocation 6463 - REPAIR & MAINT CHARGES 22,261 25,540 15,000 22,340 22,000 46.67% 6465 - REPLACEMENT CHARGES 46,778 59,234 63,473 26,447 63,473 0.00%See Central Garage Replacement Charge Allocation Page 4 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget TOTAL CENTRAL GARAGE CHARGES 86,314 99,903 95,712 55,487 102,712 7.31% BLANK 8 6494 - DEPRECIATION EXPENSE 1,444,192 1,493,669 1,450,000 744,474 1,496,891 3.23% TOTAL DEPRECIATION 1,444,192 1,493,669 1,450,000 744,474 1,496,891 3.23% BLANK 9 6530 - IMPROVEMENTS 0 -23,020 377,181 -9,740 2,988,000 692.19%Orchard Lane Improvements 6540 - EQUIPMENT & MACHINERY 0 0 52,000 5,850 27,500 -47.12%Companion piece of equipment for our Cargil Accubatch AccuBrine Blend V2 Truck Loading and Blending System for accurate mixing of deicing chemicals to our salt brine New tandem trailer orderd for 2024 - 72 week delivery. This trailer is to replace a worn out improperly weight rated trailer; 9,500 for new aerators at golf course stormwater ponds TOTAL CAPITAL OUTLAY 0 -23,020 429,181 -3,890 3,015,500 602.62% BLANK 10 6601 - BOND PRINCIPAL 0 0 515,000 515,000 547,000 6.21% 6611 - BOND INTEREST 141,011 174,202 194,106 86,225 194,106 0.00% 6621 - PAYING AGENT/OTHER FEES -10,324 -11,993 1,500 0 -100.00% TOTAL DEBT SERVICE 130,688 162,210 710,606 601,225 741,106 4.29% BLANK 11 6471 - ADMINISTRATIVE SERVICE TRANSFE 168,929 169,125 257,954 128,976 253,824 -1.60% TOTAL TRANSFERS OUT 168,929 169,125 257,954 128,976 253,824 -1.60% BLANK 12 TOTAL BUSINESS UNIT EXPENSES 2,438,244 2,447,801 3,615,786 1,810,192 6,309,418 74.50%32,083 Page 1 of 3 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 49571 - STREET LIGHT-OPERATIONS 4603 - INTEREST EARNINGS -12,018 -10,619 -12,800 -5,900 -10,544 -17.63%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -12,018 -10,619 -12,800 -5,900 -10,544 -17.63% 4605 - UNREALIZED INVESTMENT GAIN/LOS 14,912 43,713 0 TOTAL MISCELLANEOUS 14,912 43,713 0 4741 - STREET LIGHT SERVICE CHARGE -448,957 -467,021 -483,000 -235,890 -543,335 12.49% TOTAL OPERATING REVENUES -448,957 -467,021 -483,000 -235,890 -543,335 12.49% 4912 - CAPITAL CONTRIBUTIONS -15,069 10,836 0 4921 - REFUNDS & REIMBURSEMENTS -38,559 -45,278 -19,750 TOTAL OTHER FINANCING SOURCES -53,628 -34,442 -19,750 REVENUES -499,691 -468,368 -495,800 -261,540 -553,879 11.71% BLANK BLANK 1 6204 - STATIONARY SUPPLIES 0 0 0 0 0 6239 - OTHER REPAIR & MAINT SUPPLIES 0 997 138,750 149 150,000 8.11%150K Allocation to purchase stock of poles and fixtures as it is 6 to 8 months lead time to get these materials out of Canada 150K Allocation to purchase stock of poles and fixtures as it is 6 to 8 months lead time to get these materials out of Canada 6243 - MINOR COMPUTER EQUIPMENT 10 0 0 TOTAL SUPPLIES 10 997 138,750 149 150,000 8.11% BLANK 2 6307 - PROFESSIONAL SERVICES 23 19 200 0 -100.00% TOTAL PROFESSIONAL SERVICES 23 19 200 0 -100.00% BLANK 3 6322 - POSTAGE 0 0 0 0 6449 - OTHER CONTRACTUAL SERVICE 15,041 1,521 500 307 125,500 25,000.00 % Infosend (billing service); Add-On for 2024: lighting study 6351 - PRINTING 0 0 100 0 -100.00% Page 2 of 3 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6423 - LOGIS CHARGES 6,354 6,184 7,263 3,180 7,639 5.18%8,020 LOGIS JDE Fina ncial, HR/PR, Hubble, Tungst en, GIS, IP Te lephony, Utili ty Billing/Inf inity.Mobile, Internet, 24/7 Support, Manag ed Service Bac k-up, Exchange , Virtual Serv ers and Email Archiving, and Network Wellne ss LOGIS JDE Fin ancial, HR/PR , Hubble, Tun gsten, GIS, IP Telephony, Utility Billi ng/Infinity.M obile, Intern et, 24/7 Supp ort, Managed Service Back- up, Exchange, Virtual Serve rs and Email Archiving, an d Network Wel lness LOGIS JDE Financial , HR/PR, Hubble, Tu ngsten, GIS, IP Tel ephony, Utility Bil ling/Infinity.Mobil e, Internet, 24/7 Support, Managed Se rvice Back-up, Exch ange, Virtual Serve rs and Email Archiv ing, and Network We llness TOTAL OTHER SERVICES & CHARGES 21,395 7,705 7,863 3,487 133,139 1,593.23%8,020 BLANK 4 6361 - GENERAL LIABILITY INSURANCE 885 673 1,000 1,113 2,559 155.90% TOTAL INSURANCE 885 673 1,000 1,113 2,559 155.90% BLANK 5 6381 - ELECTRIC 185,253 216,370 220,000 110,073 225,000 2.27% TOTAL UTILITY SERVICES 185,253 216,370 220,000 110,073 225,000 2.27% BLANK 6 6409 - OTHER REPAIR & MAINT SVCS 33,242 104,801 25,000 2,173 40,000 60.00%Repair costs are up Repair costs & demand for electicians are at a premium TOTAL REPAIRS & MAINTENANCE 33,242 104,801 25,000 2,173 40,000 60.00% BLANK 7 BLANK 8 6494 - DEPRECIATION EXPENSE 101,115 162,806 101,115 96,616 193,232 91.10% TOTAL DEPRECIATION 101,115 162,806 101,115 96,616 193,232 91.10% BLANK 9 6530 - IMPROVEMENTS 0 0 20,000 0 0 -100.00% TOTAL CAPITAL OUTLAY 0 0 20,000 0 0 -100.00% BLANK 10 BLANK 11 6471 - ADMINISTRATIVE SERVICE TRANSFE 47,930 48,051 76,039 38,022 78,692 3.49% TOTAL TRANSFERS OUT 47,930 48,051 76,039 38,022 78,692 3.49% BLANK 12 Page 3 of 3 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget TOTAL BUSINESS UNIT EXPENSES 389,852 541,422 589,967 251,633 822,622 39.44%8,020 Page 1 of 6 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 49141 - WATER UTILITY-OPERATIONS 4320 - MISC FEDERAL GRANTS 0 -225 0 FEDERAL 0 -225 0 TOTAL INTERGOVERNMENTAL 0 -225 0 4601 - SPECIAL ASSESSMENTS -66,491 8,438 0 TOTAL SPECIAL ASSESSMENTS -66,491 8,438 0 0 4603 - INTEREST EARNINGS -25,584 -17,043 -31,800 -7,368 -18,177 -42.84%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -25,584 -17,043 -31,800 -7,368 -18,177 -42.84% 4604 - CHECK PROCESSING FEES -1,320 -1,860 -1,230 NSF Fees 4605 - UNREALIZED INVESTMENT GAIN/LOS 37,045 75,356 0 4606 - OTHER REVENUE -375 0 0 TOTAL MISCELLANEOUS 35,350 73,496 -1,230 4701 - WATER SALES -4,174,739 -4,040,332 -4,920,793 -1,881,552 -5,423,769 10.22% 4702 - FIRE LINES -9,122 -9,432 -10,000 -4,647 -10,000 0.00% 4703 - WATER METER SALES 15,803 15,262 10,000 5,327 10,000 0.00% 4704 - WATER METER RENTALS -6,500 -3,294 -5,000 -600 -5,000 0.00% 4705 - SERVICE RESTORATION FEES 0 -4,562 -1,000 -31 -1,000 0.00% 4706 - CONNECTION CHARGES -1,500 -12,500 -10,000 0 -7,000 -30.00% 4708 - TOWER RENTAL FEES -398,921 -432,786 -400,000 -9,494 -350,000 -12.50% 4709 - CERTIFICATION CHARGES -35,150 -62,600 -40,000 0 -40,000 0.00% TOTAL OPERATING REVENUES -4,610,128 -4,550,244 -5,376,793 -1,890,997 -5,826,769 8.37% 4921 - REFUNDS & REIMBURSEMENTS -1,840 0 0 0 4931 - BOND SALES 0 0 0 0 -5,878,000 TOTAL OTHER FINANCING SOURCES -1,840 0 0 0 -5,878,000 REVENUES -4,668,693 -4,485,578 -5,408,593 -1,899,595 -11,722,946 116.75% BLANK 6101 - WAGES & SALARIES-FT EMPLOYEES 396,041 428,644 437,933 208,555 468,628 7.01% 6102 - OVERTIME-FT EMPLOYEES 49,230 58,241 48,000 22,662 48,000 0.00% 6103 - WAGES-PART TIME EMPLOYEES 36,151 40,332 54,000 5,671 73,000 35.19%Add $19K for L/C Door Knocking (2) PT $19k for L/C Door Knocking 6111 - SEVERANCE PAY 15,692 12,598 0 0 0 6122 - PERA COORDINATED PLAN 33,396 36,516 40,495 17,341 44,223 9.21% 6125 - FICA - SOCIAL SECURITY 28,892 32,004 33,475 14,289 36,556 9.20% 6126 - FICA - MEDICARE 6,757 7,485 7,829 3,342 8,549 9.20% 6131 - CAFETERIA PLAN CONTRIBUTIONS 79,200 83,160 90,794 42,840 95,209 4.86% 6141 - UNEMPLOYMENT COMPENSATION 0 0 2,296 0 Page 2 of 6 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6151 - WORKER'S COMP INSURANCE 13,010 15,134 20,486 8,708 23,536 14.89% TOTAL PERSONAL SERVICES 658,368 714,114 733,012 325,704 797,701 8.83% BLANK 1 6201 - OFFICE SUPPLIES 1,566 855 4,300 4,388 5,500 27.91%5,500 Add $2500 standing desk split w/sewer Add $4k Folding Machine (annual lease) 6203 - BOOKS/REFERENCE MATERIALS 0 0 500 0 500 0.00%500 500 500 6204 - STATIONARY SUPPLIES 0 0 0 0 0 0 0 0 6212 - MOTOR FUELS 5,855 9,310 7,000 2,949 9,000 28.57%12,000 Increase fuel costs Add $2K Increase fuel costs 6214 - CLOTHING & PERSONAL EQUIPMENT 0 225 400 0 400 0.00%400 Same Same Same 6216 - CHEMICALS/CHEMICAL PRODUCTS 183,809 231,072 200,000 127,027 250,000 25.00%270,000 Increase costs/one vendor Add $50k Increase fuel costs/one vendor 6217 - SAFETY SUPPLIES 7,585 2,961 4,500 1,176 4,500 0.00%5,000 Same Same 6219 - GENERAL OPERATING SUPPLIES 21,339 16,159 32,000 21,807 50,000 56.25%40,000 Replace old equ ipment-DR9300 and CL17 Analyz er Add $12k (2)New Peristaltic pumps (CL2) 6223 - BUILDINGS & FACILITIES 1,132 2,364 10,000 1,228 10,000 0.00%10,000 Same Same 6224 - STREET MAINT MATERIALS 6,266 7,676 10,500 3,502 10,500 0.00%10,500 Same Same 6225 - PARK & LANDSCAPE MATERIALS 60 0 1,500 0 1,500 0.00%1,500 Same Same 6227 - PAINT SUPPLIES 2,655 2,723 3,500 1,089 4,500 28.57%4,500 Projects Add $1k Projects 6235 - UTILITY SYSTEM SUPPLIES 31,457 176,330 70,000 5,302 70,000 0.00%70,000 Same Same Same 6239 - OTHER REPAIR & MAINT SUPPLIES 33,746 72,822 70,000 10,822 70,000 0.00%70,000 Need inventory/ Hydrant/valve digs Same Same 6241 - SMALL TOOLS 2,218 4,466 5,000 1,923 5,000 0.00%7,000 Same Same Add $2k 6242 - MINOR EQUIPMENT 7,471 35,444 23,600 442 55,000 133.05%10,000 Add $5K New Metrotech Locator Add $45k SCADA Panel (PW) 6243 - MINOR COMPUTER EQUIPMENT 210 4,305 21,600 32,403 0 -100.00%0 6x ToughBooks CF-55 No One Due No One Due TOTAL SUPPLIES 305,370 566,712 464,400 214,058 546,400 17.66%516,900 BLANK 2 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,509 3,000 3,000 0 0 -100.00%0 Page 3 of 6 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6302 - ARCH, ENG & PLANNING 4,246 21,841 105,000 31,418 75,500 -28.10%100,000 $50k for Need s Study-Publi c Works/$30K- Eng Study WTP Connection/Du pont/694 Add $45k Full City Water Model Budget 2025 Master Water Plan unsure cost $50k+ 6307 - PROFESSIONAL SERVICES 93,327 101,363 75,000 53,949 345,000 360.00%325,000 Increase $15k for AMR/AMI agreement Add $250k Ferg uson/Neptune meter changeou ts Add $20k BS I on Tower #1 Warranty Same TOTAL PROFESSIONAL SERVICES 100,081 126,204 183,000 85,366 420,500 129.78%425,000 BLANK 3 6321 - TELEPHONE/PAGERS 2,327 2,874 3,500 1,300 4,318 23.37%2,760 6x Smartphone Service, CenturyLink, Allstream iPad Pro, LTE, KB Case, Pen, $1558, CENTURY LINK $960, 5X TMOBILE SERVICE $900, 3X IPAD DATA $900 CENTURY LINK $960, 5X TMOBILE SERVICE $900, 3X IPAD DATA $900 6322 - POSTAGE 4,818 43 0 0 0 0 6329 - OTHER COMMUNICATION SERVICES 4,949 3,247 5,000 1,155 2,880 -42.40%2,880 Field Network Data Communications (6)Utilities 6x VERIZON DATA $2880 6x VERIZON DATA $2880 6331 - TRAVEL EXPENSE/MILEAGE 0 0 200 0 0 -100.00%0 6333 - FREIGHT/DRAYAGE 43 132 50 45 200 300.00%200 6341 - PERSONNEL ADVERTISING 0 0 160 0 160 0.00%160 6342 - LEGAL NOTICES 0 0 100 0 100 0.00%100 6441 - LICENSES, TAXES & FEES 115,534 87,691 110,000 58,199 115,500 5.00%125,000 Add $5500 per State Summer surcharge 6443 - PRIZE AWARDS/EXPENSE REIMB 350 300 500 0 500 0.00%500 6449 - OTHER CONTRACTUAL SERVICE 322,721 261,052 170,000 34,523 273,000 60.59%193,000 Increase $20K due to more digs Add $50k PFAS Testing, $25k WTP Camera replacement, $25k Tower #1  Cleaning 20k Tower cleaning Tower #2? 6351 - PRINTING 52 28 500 57 500 0.00%500 6417 - UNIFORMS 2,410 2,545 2,000 1,456 3,000 50.00%3,000 6421 - SOFTWARE LICENSE 68 0 0 Page 4 of 6 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6422 - SOFTWARE MAINT 0 1,276 1,500 73 2,939 95.93%2,939 3x ESRI Creator, Adobe Acrobat 3x ESRI Creator $1580, 1x Viewer $103, 3x Mobile Worker $1176, 1x Acrobat Pro $80 3x ESRI Creator $1580, 1x Viewer $103, 3x Mobile Worker $1176, 1x Acrobat Pro $80 6423 - LOGIS CHARGES 50,463 51,235 58,265 24,797 61,175 4.99%64,233 LOGIS JDE Fina ncial, HR/PR, Hubble, Tungst en, GIS, IP Te lephony, Speci al Assessments /eWeb, Utility Billing/Infini ty.Mobile, Int ernet, 24/7 Su pport, Managed Service Back-u p, Exchange, Virtual Server s and Email Ar chiving, and Network Wellne ss LOGIS JDE Fin ancial, HR/PR , Hubble, Tun gsten, GIS, IP Telephony, Special Asses sments/eWeb, Utility Billi ng/Infinity.M obile, Intern et, 24/7 Supp ort, Managed Service Back- up, Exchange, Virtual Serve rs and Email Archiving, an d Network Wel lness LOGIS JDE Financial , HR/PR, Hubble, Tu ngsten, GIS, IP Tel ephony, Special Ass essments/eWeb, Util ity Billing/Infinit y.Mobile, Internet, 24/7 Support, Manag ed Service Back-up, Exchange, Virtual Servers and Email Archiving, and Netw ork Wellness 6432 - CONFERENCES AND SCHOOLS 5,247 6,484 8,000 2,658 8,000 0.00%8,000 Same Same Same 6434 - DUES & SUBSCRIPTIONS 3,557 4,084 4,000 558 4,000 0.00%4,000 Same Same Same 6435 - CREDIT CARD FEES 0 64,551 37,000 35,407 70,000 89.19% TOTAL OTHER SERVICES & CHARGES 512,539 485,542 400,775 160,229 546,272 36.30%407,272 BLANK 4 6361 - GENERAL LIABILITY INSURANCE 34,446 32,160 37,000 34,384 79,082 113.74% 6362 - PROPERTY INSURANCE 16,289 26,739 17,200 16,083 36,000 109.30% 6366 - MACHINERY BREAKDOWN INSURANCE 2,712 3,650 2,850 2,076 4,775 67.54% TOTAL INSURANCE 53,447 62,549 57,050 52,543 119,857 110.09% BLANK 5 6381 - ELECTRIC 193,404 238,851 190,000 98,970 200,000 5.26% 6382 - GAS 27,679 41,190 54,600 33,915 65,000 19.05% 6383 - WATER 13,739 19,944 9,500 -685 9,500 0.00% 6385 - SEWER 9,022 9,008 10,000 5,709 12,000 20.00% 6386 - STORM SEWER 9,617 9,985 8,800 3,057 10,000 13.64% 6389 - STREET LIGHTS 2,717 1,968 3,000 1,312 3,500 16.67% TOTAL UTILITY SERVICES 256,179 320,946 275,900 142,277 300,000 8.74% BLANK 6 6402 - EQUIPMENT SERVICES 1,300 4,007 6,000 125 6,000 0.00%6,000 Same Same Same Page 5 of 6 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6403 - BLDGS/FACILITIES MAINT SERVICE 23,575 15,170 10,000 6,607 10,000 0.00%10,000 Increased PM HVAC Wells/WTP No Change Same 6405 - PARK & LANDSCAPE SERVICES 6,106 7,335 10,000 2,095 10,000 0.00%10,000 Same 2023 Same Same 6406 - MULTI-FUNCTION MTNCE 119 126 250 74 180 -28.00%180 MFD Maintenance Water Treatment Plant MFD Maintenance Water Treatment Plant MFD Maintenance Water Treatment Plant 6409 - OTHER REPAIR & MAINT SVCS 12,531 36,708 40,200 7,429 40,000 -0.50%40,000 Add $16K (2) Hi-E Dris Add $19K (2) Hi-E Dris Add $20K (2) Hi-E Dris TOTAL REPAIRS & MAINTENANCE 43,631 63,346 66,450 16,330 66,180 -0.41%66,180 BLANK 7 6461 - FUEL CHARGES 3,887 5,892 4,700 3,107 4,700 0.00%See allocation spreadsheet 6462 - FIXED CHARGES 13,438 10,317 13,148 5,954 13,148 0.00%See Central Garage Replacement Charge Allocation 6463 - REPAIR & MAINT CHARGES 8,086 13,323 10,600 4,084 10,600 0.00% 6465 - REPLACEMENT CHARGES 22,520 32,267 45,183 19,408 45,183 0.00%See Central Garage Replacement Charge Allocation TOTAL CENTRAL GARAGE CHARGES 47,930 61,798 73,631 32,554 73,631 0.00% BLANK 8 6494 - DEPRECIATION EXPENSE 1,897,753 1,970,439 1,897,753 960,815 1,970,439 3.83% TOTAL DEPRECIATION 1,897,753 1,970,439 1,897,753 960,815 1,970,439 3.83% BLANK 9 6530 - IMPROVEMENTS 0 26,227 2,116,888 60,601 2,588,800 22.29% 6540 - EQUIPMENT & MACHINERY 0 0 66,000 23,807 10,000 -84.85%10,000 Add $36K Sup.truck,$20K Scissors Lift adn trailer, $10K Dump trailer Add $10k for truck accessories TOTAL CAPITAL OUTLAY 0 26,227 2,182,888 84,407 2,598,800 19.05%10,000 BLANK 10 6601 - BOND PRINCIPAL 0 0 2,253,250 1,241,250 2,433,250 7.99% 6611 - BOND INTEREST 465,927 464,929 617,093 226,299 444,173 -28.02% 6621 - PAYING AGENT/OTHER FEES -56,849 -66,068 0 0 TOTAL DEBT SERVICE 409,079 398,861 2,870,343 1,467,549 2,877,423 0.25% Page 6 of 6 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget BLANK 11 6471 - ADMINISTRATIVE SERVICE TRANSFE 183,696 184,625 283,188 141,594 271,527 -4.12% TOTAL TRANSFERS OUT 183,696 184,625 283,188 141,594 271,527 -4.12% BLANK 12 TOTAL BUSINESS UNIT EXPENSES 4,468,074 4,981,363 9,488,390 3,683,427 10,588,730 11.60%1,425,352 COU N C IL ITEM MEMOR ANDUM DAT E:10/16/2023 TO :Dr. R eggie Edwards , C ity Manager T HR O UG H:N/A F R O M: S UBJ EC T:C entral G arage Background: AT TAC HME N T S: Desc ription Upload Date Type 2024 C entral G arage P ropos ed Budget 10/13/2023 Bac kup Material Page 1 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 49951 - CENTRAL GARAGE OPERATIONS 4603 - INTEREST EARNINGS -41,107 -30,150 -39,700 -25,709 -28,935 -27.12%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -41,107 -30,150 -39,700 -25,709 -28,935 -27.12% 4605 - UNREALIZED INVESTMENT GAIN/LOS 46,239 119,954 0 4606 - OTHER REVENUE -173 -87 -87 TOTAL MISCELLANEOUS 46,066 119,867 -87 4862 - FUEL SALES-INTERNAL -158,725 -226,838 -435,000 -102,782 -435,000 0.00% 4862 - FUEL SALES-EXTERNAL -42,977 -29,676 0 -13,794 4863 - REPLACEMENT CHARGES -955,346 -1,334,541 -1,684,130 -707,706 -1,684,130 0.00% 4864 - OVERHEAD CHARGES -300,345 -263,535 -344,943 -144,238 -344,943 0.00% 4865 - REPAIR/MAINT CHARGES -428,578 -389,502 -400,000 -188,619 -400,000 0.00% TOTAL INTERNAL SERVICE CHARGES -1,885,972 -2,244,092 -2,864,073 -1,157,140 -2,864,073 0.00% 4911 - SALE OF PROPERTY -8,057 0 0 -22,000 4919 - GAIN ON FIXED ASSET DISPOSAL -99,450 -8,929 -50,000 0 -100.00% 4921 - REFUNDS & REIMBURSEMENTS -66,477 -45,007 -15,000 -20,780 -15,000 0.00% TOTAL OTHER FINANCING SOURCES -173,984 -53,936 -65,000 -42,780 -15,000 -76.92% REVENUES -2,054,997 -2,208,311 -2,968,773 -1,225,715 -2,908,008 -2.05% BLANK 6101 - WAGES & SALARIES-FT EMPLOYEES 331,676 411,825 477,500 168,317 500,900 4.90% 6102 - OVERTIME-FT EMPLOYEES 1,104 738 600 498 1,000 66.67%1,000 OT instead of downing equipment OT instead of downing equipment 6111 - SEVERANCE PAY 7,542 5,290 0 0 6122 - PERA COORDINATED PLAN 24,959 30,942 35,859 12,661 37,642 4.97% 6125 - FICA - SOCIAL SECURITY 20,389 25,217 29,642 10,456 31,118 4.98% 6126 - FICA - MEDICARE 4,769 5,898 6,934 2,445 7,278 4.96% 6131 - CAFETERIA PLAN CONTRIBUTIONS 67,615 80,700 102,786 36,444 107,784 4.86% 6151 - WORKER'S COMP INSURANCE 11,787 13,698 14,381 7,877 15,993 11.21% TOTAL PERSONAL SERVICES 469,841 574,307 667,702 238,699 701,715 5.09%1,000 BLANK 1 6201 - OFFICE SUPPLIES 419 530 500 699 500 0.00%500 6203 - BOOKS/REFERENCE MATERIALS 0 35 200 0 200 0.00%200 6212 - MOTOR FUELS 196,471 249,931 503,100 112,129 451,000 -10.36%464,730 Based on 130,000 gallons at a projected average of $3.87 per gallon Based on 130,000 gallons at a projected average of $3.76 per gallon 6213 - LUBRICANTS & ADDITIVES 16,253 16,433 19,000 7,821 19,000 0.00%19,000 Page 2 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6215 - SHOP MATERIALS 12,586 14,245 10,000 9,164 15,000 50.00%15,000 6217 - SAFETY SUPPLIES 2,878 1,291 3,000 833 3,000 0.00%3,000 6218 - WELDING SUPPLIES 5,393 3,403 5,000 1,976 5,000 0.00%5,000 6219 - GENERAL OPERATING SUPPLIES 1,309 302 1,500 180 1,500 0.00%1,500 6221 - MOTOR VEHICLES 108,745 108,242 100,000 76,198 145,000 45.00%149,350 6222 - TIRES 17,980 12,687 19,100 5,004 19,100 0.00%19,100 6227 - PAINT SUPPLIES 37 0 210 0 210 0.00%210 6239 - OTHER REPAIR & MAINT SUPPLIES 310 0 2,000 0 2,000 0.00%2,000 add 1200 for wifi hot spot 6241 - SMALL TOOLS 4,714 2,494 4,000 3,513 5,000 25.00%5,000 6242 - MINOR EQUIPMENT 17,529 45,007 17,500 11,024 10,000 -42.86%10,000 Add $3,000 for plasma cutter, $9000 for AC Unit, add $5500 for band saw 6243 - MINOR COMPUTER EQUIPMENT 4,945 1,009 0 0 1,300 7,675 HP EB840 LTE $1300 Cummins Diagnostic Laptop 1x EB840 $1200, 1x Dock $125, 2x Monitors $350 RANDERSON, 1x EB840 $1200, 1x Dock $125, 1x Monitor $175 SBOOS, 1x EB840 $1200, 1x Dock $125, 1x Monitor $175 JFABIAN, 1x EB840 $1200, 1x Dock $125, 1x Monitor $175 BBUNGE, 1x EB840 $1200, 1x Dock $125, 1x Monitor $175 BHALVORSON TOTAL SUPPLIES 389,569 455,608 685,110 228,540 677,810 -1.07%702,265 BLANK 2 6307 - PROFESSIONAL SERVICES 4,789 1,818 4,500 1,106 4,500 0.00%4,500 add 2k for professional staff development TOTAL PROFESSIONAL SERVICES 4,789 1,818 4,500 1,106 4,500 0.00%4,500 BLANK 3 6321 - TELEPHONE/PAGERS 347 215 1,100 63 360 -67.27%360 Smart Phone (2)2x T-Mobile Service $360 2x T-Mobile Service $360 6323 - RADIO COMMUNICATIONS 3,017 2,780 3,152 2,565 3,152 0.00%3,152 221/month 6333 - FREIGHT/DRAYAGE 28 183 620 17 620 0.00%620 6441 - LICENSES, TAXES & FEES 9,448 13,119 16,200 383 16,200 0.00%13,200 6447 - TOWING CHARGES 1,131 5,209 3,000 2,320 3,000 0.00%3,000 Page 3 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6449 - OTHER CONTRACTUAL SERVICE 5,580 4,133 5,000 1,376 5,000 0.00%5,000 6351 - PRINTING 0 0 340 0 340 0.00%340 6417 - UNIFORMS 3,642 2,422 3,979 1,137 4,000 0.53%4,000 add 3%add 3% 6421 - SOFTWARE LICENSE 136 770 0 73 80 80 1x Acrobat Pro $80 1x Acrobat Pro $80 6422 - SOFTWARE MAINT 6,924 10,533 8,500 10,844 12,620 48.47%12,620 Pubworks $5000, Scan Tool update $1700, Fuelmaster $600, cummins update $1200 Cummins Diagnostic Software $793, Autel Commercial Vehicle Diagnostic $1334, Autel Passenger Vehicle Diagnostic $901, Pubworks (GWorks) $9592 Cummins Diagnostic Software $793, Autel Commercial Vehicle Diagnostic $1334, Autel Passenger Vehicle Diagnostic $901, Pubworks (GWorks) $9592 6423 - LOGIS CHARGES 6,146 6,620 7,428 2,793 7,906 6.44%8,301 LOGIS JDE Financial, HR/PR, Hubble, Tungsten, IP Telephony, Internet, 24/7 Support, Managed Service Back-up, Exchange and Email Archiving, and Network Wellness LOGIS JDE Financial, HR/PR, Hubble, Tungsten, IP Telephony, Internet, 24/7 Support, Managed Service Back-up, Exchange and Email Archiving, and Network Wellness LOGIS JDE Financial, HR/PR, Hubble, Tungsten, IP Telephony, Internet, 24/7 Support, Managed Service Back-up, Exchange and Email Archiving, and Network Wellness 6432 - CONFERENCES AND SCHOOLS 1,244 1,076 3,000 0 3,000 0.00%3,000 6433 - MEETING EXPENSES 0 0 400 37 400 0.00%400 6434 - DUES & SUBSCRIPTIONS 1,245 896 1,000 745 1,000 0.00%1,000 TOTAL OTHER SERVICES & CHARGES 38,889 47,956 53,719 22,354 57,678 7.37%55,073 BLANK 4 6363 - MOTOR VEHICLE INSURANCE 55,729 54,970 60,000 30,345 60,690 1.15% 6367 - EQUIPMENT (INLAND MARINE)10,934 9,287 12,500 5,554 11,108 -11.14% TOTAL INSURANCE 66,663 64,257 72,500 35,899 71,798 -0.97% BLANK 5 6388 - HAZARDOUS WASTE DISPOSAL 3,614 1,460 800 471 1,500 87.50% TOTAL UTILITY SERVICES 3,614 1,460 800 471 1,500 87.50% BLANK 6 Page 4 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6401 - MOTOR VEHICLE SERVICES 170,524 103,313 85,000 49,329 85,000 0.00%85,000 Double check in 2022 6402 - EQUIPMENT SERVICES 618 913 5,950 685 5,950 0.00%5,950 6406 - MULTI-FUNCTION MTNCE 824 1,726 0 532 2,400 2,100 MFD Ricoh Printing TOTAL REPAIRS & MAINTENANCE 171,967 105,952 90,950 50,546 93,350 2.64%93,050 BLANK 7 6461 - FUEL CHARGES 1,847 3,028 0 1,188 See allocation spreadsheet 6462 - FIXED CHARGES 1,600 2,008 837 2,008 0.00% 6463 - REPAIR & MAINT CHARGES 6,378 12,112 4,000 3,996 4,000 0.00% 6465 - REPLACEMENT CHARGES 0 10,000 11,940 4,975 11,940 0.00% TOTAL CENTRAL GARAGE CHARGES 8,225 26,740 17,948 10,995 17,948 0.00% BLANK 8 6494 - DEPRECIATION EXPENSE 927,530 1,002,458 950,000 0 1,002,548 5.53% TOTAL DEPRECIATION 927,530 1,002,458 950,000 0 1,002,548 5.53% BLANK 9 6545 - OTHER EQUIPMENT 0 0 0 36,545 6550 - MOTOR VEHICLES 0 0 1,128,500 488,487 1,616,000 43.20%15 vehicles/pieces of equipment 18 vehicles/pieces of equipment 6496 - LOSS ON FIXED ASSET DISPOSAL 30,157 10,999 0 TOTAL CAPITAL OUTLAY 30,157 10,999 1,128,500 525,033 1,616,000 43.20% BLANK 10 BLANK 11 6471 - ADMINISTRATIVE SERVICE TRANSFE 57,132 56,658 75,684 37,842 70,279 -7.14% TOTAL TRANSFERS OUT 57,132 56,658 75,684 37,842 70,279 -7.14% BLANK 12 TOTAL BUSINESS UNIT EXPENSES 2,168,376 2,348,214 3,747,413 1,151,485 4,315,126 15.15%855,888 COU N C IL ITEM MEMOR ANDUM DAT E:10/16/2023 TO :Dr. R eggie Edwards , C ity Manager T HR O UG H:N/A F R O M: S UBJ EC T:Ec onomic Development Authority (EDA) Background: AT TAC HME N T S: Desc ription Upload Date Type 2024 HR A P ropos ed Budget 10/13/2023 Bac kup Material 2024 EDA P ropos ed Budget 10/13/2023 Bac kup Material Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46321 - HRA FUND 4101 - CURRENT AD VALOREM TAXES -447,187 -477,401 -508,633 0 -586,081 15.23% 4120 - DELINQUENT AD VALOREM TAXES -2,224 -1,490 0 4154 - PENALTIES & INT-DELINQ TAXES 0 -181 0 PROPERTY TAXES -449,411 -479,073 -508,633 0 -586,081 15.23% TOTAL TAXES -449,411 -479,073 -508,633 0 -586,081 15.23% REVENUES -449,411 -479,073 -508,633 0 -586,081 15.23% BLANK BLANK 1 BLANK 2 BLANK 3 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 BLANK 11 6481 - EDA FUND TRANSFER 450,180 482,206 508,633 0 586,081 15.23% TOTAL TRANSFERS OUT 450,180 482,206 508,633 0 586,081 15.23% BLANK 12 TOTAL BUSINESS UNIT EXPENSES 450,180 482,206 508,633 0 586,081 15.23% Page 1 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46310 - DEVELOPMENT/RE-DEVELOPMENT 4359 - OTHER STATE GRANTS/AID 0 0 -50,598 STATE 0 0 -50,598 4362 - COUNTY GRANTS/AID 0 -35,000 0 0 0 COUNTY 0 -35,000 0 0 0 TOTAL INTERGOVERNMENTAL 0 -35,000 -50,598 0 0 4603 - INTEREST EARNINGS -16,799 -17,205 -16,600 -12,972 -16,806 1.24% TOTAL INVESTMENT EARNINGS -16,799 -17,205 -16,600 -12,972 -16,806 1.24% 4605 - UNREALIZED INVESTMENT GAIN/LOS 20,487 69,721 0 TOTAL MISCELLANEOUS 20,487 69,721 0 0 4831 - OFFICE RENTALS -20,000 -15,737 0 TOTAL OPERATING REVENUES -20,000 -15,737 0 4921 - REFUNDS & REIMBURSEMENTS 20 0 0 TOTAL OTHER FINANCING SOURCES 20 0 0 4915 - TRANSFERS IN 0 -482,206 -508,633 0 -586,081 15.23%Per County Determination Per County Determination; transferred from HRA Fund 4915 - TRANSFERS IN FROM HRA FUND -450,180 0 0 0 6498 - INTERFUND EXPENSE ALLOCATION -229,324 -126,589 -200,000 0 -95,414 -52.29%From TIF Funds TOTAL TRANSFERS IN -679,504 -608,795 -708,633 0 -681,495 -3.83% REVENUES -695,795 -607,016 -725,233 -63,570 -698,301 -3.71%0 BLANK 6101 - WAGES & SALARIES-FT EMPLOYEES 156,309 242,344 202,023 103,752 256,392 26.91% 6103 - WAGES-PART TIME EMPLOYEES 0 0 0 0 0 0 6122 - PERA COORDINATED PLAN 11,726 18,132 15,152 7,658 19,229 26.91% 6125 - FICA - SOCIAL SECURITY 8,985 15,775 12,525 6,810 15,896 26.91% 6126 - FICA - MEDICARE 2,101 3,690 2,929 1,592 3,718 26.94% 6131 - CAFETERIA PLAN CONTRIBUTIONS 0 21,830 29,979 0 44,910 49.80% 6151 - WORKER'S COMP INSURANCE 1,108 1,754 1,495 932 2,000 33.78% TOTAL PERSONAL SERVICES 180,227 303,524 264,103 120,743 342,145 29.55%0 BLANK 1 6243 - MINOR COMPUTER EQUIPMENT 364 0 0 0 TOTAL SUPPLIES 364 0 0 0 BLANK 2 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,509 3,000 0 0 3,000 6302 - ARCH, ENG & PLANNING 11,364 12,500 10,000 0 -100.00% Page 2 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6303 - LEGAL SERVICES 10,898 11,129 10,000 10,323 10,000 0.00%10,000 Purchase and development agreements for EDA properties; Purchase and development agreements for EDA properties; 6307 - PROFESSIONAL SERVICES 31,576 38,328 50,000 60,373 80,000 60.00%60,000 EDA Ehlers Assitance EDA Ehlers Assistance TOTAL PROFESSIONAL SERVICES 56,347 64,957 70,000 70,696 93,000 32.86%70,000 BLANK 3 6321 - TELEPHONE/PAGERS 155 0 1,000 0 -100.00% 6331 - TRAVEL EXPENSE/MILEAGE 0 0 0 0 0 0 6333 - FREIGHT/DRAYAGE 0 0 0 0 0 0 6342 - LEGAL NOTICES 488 340 200 0 200 0.00%200 6441 - LICENSES, TAXES & FEES 8,711 8,716 10,000 1,116 5,000 -50.00%5,000 6449 - OTHER CONTRACTUAL SERVICE 236,084 229,419 72,000 46,406 52,000 -27.78%52,000 $30,000 to small business micro grants; $12,000 to local farmer's market; $10,000 Elevate HC Program. $30,000 to small business micro grants; $12,000 to local farmer's market; $10,000 Elevate HC Program. 6421 - SOFTWARE LICENSE 0 0 500 0 500 0.00%Adobe Licensing Adobe Licensing 6423 - LOGIS CHARGES 4,133 4,423 4,890 1,803 5,183 5.99%5,442 LOGIS JDE Financial, HR/PR, Hubble, Tungsten, IP Telephony, Internet, 24/7 Support, Managed Service Back-up, Exchange, Virtual Servers and Email Archiving, and Network Wellness LOGIS JDE Financial, HR/PR, Hubble, Tungsten, IP Telephony, Internet, 24/7 Support, Managed Service Back-up, Exchange, Virtual Servers and Email Archiving, and Network Wellness LOGIS JDE Financial, HR/PR, Hubble, Tungsten, IP Telephony, Internet, 24/7 Support, Managed Service Back-up, Exchange, Virtual Servers and Email Archiving, and Network Wellness 6432 - CONFERENCES AND SCHOOLS 3,287 1,745 2,000 1,575 2,000 0.00%2,000 6433 - MEETING EXPENSES 60 0 0 0 Page 3 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6434 - DUES & SUBSCRIPTIONS 10,370 2,210 11,000 500 2,200 -80.00%2,200 NAHRO $150, EDAM $500, , Fin. & Commerce $160, Sensible Land Use Coalition $250, ULI $810; I-94 West Chamber $300 NAHRO $150, EDAM $500, Fin. & Commerce $160, Sensible Land Use Coalition $250, ULI $810; I-94 West Chamber $300 TOTAL OTHER SERVICES & CHARGES 263,289 246,853 101,590 51,401 67,083 -33.97%66,842 BLANK 4 6361 - GENERAL LIABILITY INSURANCE 997 1,064 2,094 1,236 2,094 0.00% TOTAL INSURANCE 997 1,064 2,094 1,236 2,094 0.00% BLANK 5 6385 - SEWER 0 0 0 39 0 0 6386 - STORM SEWER 14,770 12,858 18,800 5,185 18,800 0.00%1,200 6389 - STREET LIGHTS 1,910 1,628 2,300 524 2,300 0.00%2,300 TOTAL UTILITY SERVICES 16,680 14,486 21,100 5,748 21,100 0.00%3,500 BLANK 6 6403 - BLDGS/FACILITIES MAINT SERVICE 10,070 9,783 12,000 5,507 8,000 -33.33%8,000 6405 - PARK & LANDSCAPE SERVICES 1,222 335 3,000 0 1,500 -50.00%1,500 6406 - MULTI-FUNCTION MTNCE 0 0 0 0 6409 - OTHER REPAIR & MAINT SVCS 425 0 0 0 0 0 TOTAL REPAIRS & MAINTENANCE 11,716 10,118 15,000 5,507 9,500 -36.67%9,500 BLANK 7 6461 - FUEL CHARGES 693 934 800 281 800 0.00%See allocation spreadsheet 6462 - FIXED CHARGES 2,977 1,314 1,789 745 1,789 0.00%See Central Garage Replacement Charge Allocation 6463 - REPAIR & MAINT CHARGES 477 0 500 0 500 0.00% 6465 - REPLACEMENT CHARGES 2,017 2,200 2,706 1,127 3,706 36.95%See Central Garage Replacement Charge Allocation. TOTAL CENTRAL GARAGE CHARGES 6,164 4,447 5,795 2,153 6,795 17.26% BLANK 8 BLANK 9 6510 - LAND 0 3,610 0 0 0 Page 4 of 4 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget TOTAL CAPITAL OUTLAY 0 3,610 0 0 0 BLANK 10 BLANK 11 6471 - ADMINISTRATIVE SERVICE TRANSFE 118,180 118,113 141,848 70,926 156,363 10.23% 6482 - MISC TRANSFER OUT 0 0 100,000 0 0 -100.00%0 No longer need transfer to revolving loan fund TOTAL TRANSFERS OUT 118,180 118,113 241,848 70,926 156,363 -35.35%0 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 653,965 767,172 721,530 328,410 698,080 -3.25%149,842 COU N C IL ITEM MEMOR ANDUM DAT E:10/16/2023 TO :Dr. R eggie Edwards , C ity Manager T HR O UG H:N/A F R O M: S UBJ EC T:Tax Increment F inancing (T I F ) Background: AT TAC HME N T S: Desc ription Upload Date Type 2024 T I F 3 P roposed Budget 10/13/2023 Bac kup Material 2024 T I F 5 P roposed Budget 10/13/2023 Bac kup Material 2024 T I F 6 P roposed Budget 10/13/2023 Bac kup Material 2024 T I F 7 P roposed Budget 10/13/2023 Bac kup Material 2024 T I F 8 P roposed Budget 10/13/2023 Bac kup Material 2024 T I F 9 P roposed Budget 10/13/2023 Bac kup Material Page 1 of 2 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46413 - TIF DISTRICT #3 4150 - TAX INCREMENTS -6,205,922 29,710 0 0 TAX INCREMENTS -6,205,922 29,710 0 0 TOTAL TAXES -6,205,922 29,710 0 0 4603 - INTEREST EARNINGS -57,588 -58,187 -67,000 -22,525 -60,556 -9.62% TOTAL INVESTMENT EARNINGS -57,588 -58,187 -67,000 -22,525 -60,556 -9.62% 4605 - UNREALIZED INVESTMENT GAIN/LOS 78,082 251,046 0 TOTAL MISCELLANEOUS 78,082 251,046 0 4831 - OFFICE RENTALS -77,732 -5,305 0 -2,087 0 Lease with Ocean Buffet terminated in 2023 TOTAL OPERATING REVENUES -77,732 -5,305 0 -2,087 0 4911 - SALE OF PROPERTY -27,276 0 0 0 4921 - REFUNDS & REIMBURSEMENTS -110 0 0 TOTAL OTHER FINANCING SOURCES -27,386 0 0 0 4915 - TRANSFERS IN -1,500 0 0 0 6498 - INTERFUND EXPENSE ALLOCATION 83,440 73,190 150,000 0 50,000 -66.67% TOTAL TRANSFERS IN 81,940 73,190 150,000 0 50,000 -66.67% REVENUES -6,208,606 290,455 83,000 -24,612 -10,556 -112.72% BLANK BLANK 1 6219 - GENERAL OPERATING SUPPLIES 0 92 0 0 0 TOTAL SUPPLIES 0 92 0 0 0 BLANK 2 6302 - ARCH, ENG & PLANNING 57,910 85,976 0 67,524 6303 - LEGAL SERVICES 1,418 7,916 5,000 617 5,000 0.00%5,000 6307 - PROFESSIONAL SERVICES 126,126 361,688 150,000 44,880 100,000 -33.33%100,000 Master Plan and TIF Services TOTAL PROFESSIONAL SERVICES 185,454 455,580 155,000 113,021 105,000 -32.26%105,000 BLANK 3 6342 - LEGAL NOTICES 161 0 0 0 6441 - LICENSES, TAXES & FEES 11,453 11,435 0 15,694 Page 2 of 2 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 6449 - OTHER CONTRACTUAL SERVICE 450,135 316,436 200,000 60,718 500,000 150.00%75,000 TIF Purchased EDA site Maintenance such as lawn and snow removal. Target Demo and TIF Purchased EDA site Maintenance such as lawn and snow removal. TOTAL OTHER SERVICES & CHARGES 461,748 327,871 200,000 76,412 500,000 150.00%75,000 BLANK 4 6361 - GENERAL LIABILITY INSURANCE 20,588 9,485 22,000 4,915 -100.00% TOTAL INSURANCE 20,588 9,485 22,000 4,915 -100.00% BLANK 5 6381 - ELECTRIC 40,518 32,161 38,700 7,023 10,000 -74.16%10,000 6382 - GAS 11,363 18,404 30,800 566 1,000 -96.75%1,000 6383 - WATER 346 525 400 173 400 0.00%400 6384 - REFUSE DISPOSAL 117 217 100 74 100 0.00%100 6385 - SEWER 499 1,034 1,000 206 1,000 0.00%1,000 6386 - STORM SEWER 52,844 59,583 70,500 14,294 30,000 -57.45%30,000 6389 - STREET LIGHTS 6,667 6,750 7,800 1,854 5,000 -35.90%5,000 TOTAL UTILITY SERVICES 112,354 118,674 149,300 24,191 47,500 -68.18%47,500 BLANK 6 6403 - BLDGS/FACILITIES MAINT SERVICE 0 485 0 0 0 6405 - PARK & LANDSCAPE SERVICES 27,554 38,463 30,000 1,254 30,000 0.00%30,000 TOTAL REPAIRS & MAINTENANCE 27,554 38,948 30,000 1,254 30,000 0.00%30,000 BLANK 7 BLANK 8 BLANK 9 6496 - LOSS ON FIXED ASSET DISPOSAL -1 0 0 0 TOTAL CAPITAL OUTLAY -1 0 0 0 BLANK 10 BLANK 11 6474 - DEBT SERVICE FUND TRANSFER 2,243,137 2,232,169 0 0 TOTAL TRANSFERS OUT 2,243,137 2,232,169 0 0 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 3,050,833 3,182,818 556,300 219,792 682,500 22.69%257,500 Page 1 of 2 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46415 - TIF DISTRICT #5 4150 - TAX INCREMENTS -524,564 -463,763 -453,841 0 -498,468 9.83%232739*2*.975 TAX INCREMENTS -524,564 -463,763 -453,841 0 -498,468 9.83% TOTAL TAXES -524,564 -463,763 -453,841 0 -498,468 9.83% 4603 - INTEREST EARNINGS -6,124 -5,827 -7,100 -5,557 -5,869 -17.34%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -6,124 -5,827 -7,100 -5,557 -5,869 -17.34% 4605 - UNREALIZED INVESTMENT GAIN/LOS 8,279 24,330 0 TOTAL MISCELLANEOUS 8,279 24,330 0 6498 - INTERFUND EXPENSE ALLOCATION 46,760 13,604 30,000 0 30,000 0.00% TOTAL TRANSFERS IN 46,760 13,604 30,000 0 30,000 0.00% REVENUES -475,649 -431,655 -430,941 -5,557 -474,337 10.07% BLANK BLANK 1 BLANK 2 6302 - ARCH, ENG & PLANNING 0 0 0 0 6303 - LEGAL SERVICES 43 0 0 0 6307 - PROFESSIONAL SERVICES 446 0 0 TOTAL PROFESSIONAL SERVICES 489 0 0 0 BLANK 3 6441 - LICENSES, TAXES & FEES 1,483 0 0 0 6449 - OTHER CONTRACTUAL SERVICE 0 0 0 0 TOTAL OTHER SERVICES & CHARGES 1,483 0 0 0 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6602 - OTHER DEBT-PRINCIPAL 0 0 104,641 0 -100.00%Principal on Advance (doesn't end up in expense) 6612 - OTHER DEBT-INTEREST 2,586 2,128 1,511 0 -100.00% TOTAL DEBT SERVICE 2,586 2,128 106,152 0 -100.00% BLANK 11 6474 - DEBT SERVICE FUND TRANSFER 352,283 355,011 358,333 0 373,525 4.24% Page 2 of 2 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget TOTAL TRANSFERS OUT 352,283 355,011 358,333 0 373,525 4.24% BLANK 12 TOTAL BUSINESS UNIT EXPENSES 356,841 357,139 464,485 0 373,525 -19.58% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46416 - TIF DISTRICT #6 4150 - TAX INCREMENTS -187,064 -174,039 -170,301 0 -133,878 -21.39%87334*2*.975 TAX INCREMENTS -187,064 -174,039 -170,301 0 -133,878 -21.39% TOTAL TAXES -187,064 -174,039 -170,301 0 -133,878 -21.39% 4603 - INTEREST EARNINGS 30 -114 0 0 TOTAL INVESTMENT EARNINGS 30 -114 0 0 4605 - UNREALIZED INVESTMENT GAIN/LOS 43 0 0 TOTAL MISCELLANEOUS 43 0 0 6498 - INTERFUND EXPENSE ALLOCATION 17,781 11,461 10,000 0 2,678 -73.22% TOTAL TRANSFERS IN 17,781 11,461 10,000 0 2,678 -73.22% REVENUES -169,209 -162,692 -160,301 0 -131,200 -18.15% BLANK BLANK 1 BLANK 2 6307 - PROFESSIONAL SERVICES 446 0 0 0 TOTAL PROFESSIONAL SERVICES 446 0 0 0 BLANK 3 6441 - LICENSES, TAXES & FEES 4,350 907 4,350 0 906 -79.17% TOTAL OTHER SERVICES & CHARGES 4,350 907 4,350 0 906 -79.17% BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6602 - OTHER DEBT-PRINCIPAL 91,193 176,037 166,043 84,844 130,531 -21.39% TOTAL DEBT SERVICE 91,193 176,037 166,043 84,844 130,531 -21.39% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 95,990 176,944 170,393 84,844 131,437 -22.86% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46417 - TIF DISTRICT #7 4150 - TAX INCREMENTS -161,996 -139,779 -136,783 0 -170,135 24.38%70145*2*.975 TAX INCREMENTS -161,996 -139,779 -136,783 0 -170,135 24.38% TOTAL TAXES -161,996 -139,779 -136,783 0 -170,135 24.38% 4603 - INTEREST EARNINGS -1,477 -2,911 -1,800 -2,977 -2,800 55.56% TOTAL INVESTMENT EARNINGS -1,477 -2,911 -1,800 -2,977 -2,800 55.56% 4605 - UNREALIZED INVESTMENT GAIN/LOS 2,049 11,610 0 TOTAL MISCELLANEOUS 2,049 11,610 0 6498 - INTERFUND EXPENSE ALLOCATION 72,552 38,373 5,000 0 5,104 2.08% TOTAL TRANSFERS IN 72,552 38,373 5,000 0 5,104 2.08% REVENUES -88,871 -92,707 -133,583 -2,977 -167,831 25.64% BLANK BLANK 1 BLANK 2 6303 - LEGAL SERVICES 1,425 0 6307 - PROFESSIONAL SERVICES 446 0 0 39,798 TOTAL PROFESSIONAL SERVICES 446 1,425 0 39,798 BLANK 3 6441 - LICENSES, TAXES & FEES 837 890 0 889 TOTAL OTHER SERVICES & CHARGES 837 890 0 889 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 1,283 2,315 0 40,687 Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46418 - TIF DISTRICT #8 4150 - TAX INCREMENTS -186,017 -275,000 0 -256,822 -6.61%Jason Aarsvold est. TAX INCREMENTS -186,017 -275,000 0 -256,822 -6.61% TOTAL TAXES -186,017 -275,000 0 -256,822 -6.61% 4603 - INTEREST EARNINGS -141 -27 -44 TOTAL INVESTMENT EARNINGS -141 -27 -44 4605 - UNREALIZED INVESTMENT GAIN/LOS 184 0 TOTAL MISCELLANEOUS 184 0 6498 - INTERFUND EXPENSE ALLOCATION 6,071 0 6,421 TOTAL TRANSFERS IN 6,071 0 6,421 REVENUES -179,903 -275,000 -27 -250,445 -8.93% BLANK BLANK 1 BLANK 2 6303 - LEGAL SERVICES 569 1,613 600 0 -100.00% 6307 - PROFESSIONAL SERVICES 446 550 600 0 -100.00% TOTAL PROFESSIONAL SERVICES 1,016 2,163 1,200 0 -100.00% BLANK 3 6441 - LICENSES, TAXES & FEES 534 909 0 909 TOTAL OTHER SERVICES & CHARGES 534 909 0 909 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6602 - OTHER DEBT-PRINCIPAL 110,411 247,500 57,214 231,140 -6.61% TOTAL DEBT SERVICE 110,411 247,500 57,214 231,140 -6.61% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 1,550 113,482 248,700 57,214 232,049 -6.70% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 46420 - TIF DISTRICT #9 4150 - TAX INCREMENTS -48,450 TAX INCREMENTS -48,450 TOTAL TAXES -48,450 6498 - INTERFUND EXPENSE ALLOCATION 1,211 TOTAL TRANSFERS IN 1,211 REVENUES -47,239 BLANK BLANK 1 BLANK 2 BLANK 3 6441 - LICENSES, TAXES & FEES 500 TOTAL OTHER SERVICES & CHARGES 500 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6602 - OTHER DEBT-PRINCIPAL 43,605 TOTAL DEBT SERVICE 43,605 BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 44,105 COU N C IL ITEM MEMOR ANDUM DAT E:10/16/2023 TO :Dr. R eggie Edwards , C ity Manager T HR O UG H:N/A F R O M: S UBJ EC T:Debt Background: AT TAC HME N T S: Desc ription Upload Date Type 2024 2015 G O Bond P roposed Budget 10/13/2023 Bac kup Material 2024 2016 G O Bond P roposed Budget 10/13/2023 Bac kup Material 2024 2017 G O Bond P roposed Budget 10/13/2023 Bac kup Material 2024 2019 G O Bond P roposed Budget 10/13/2023 Bac kup Material 2024 2020 G O Bond P roposed Budget 10/13/2023 Bac kup Material 2024 2021 G O Bond P roposed Budget 10/13/2023 Bac kup Material Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 47527 - GO IMPROVEMENT BONDS-2015A 4101 - CURRENT AD VALOREM TAXES -252,753 -253,818 -256,903 0 -260,396 1.36% 4154 - PENALTIES & INT-DELINQ TAXES -136 -91 0 PROPERTY TAXES -252,888 -253,909 -256,903 0 -260,396 1.36% TOTAL TAXES -252,888 -253,909 -256,903 0 -260,396 1.36% 4601 - SPECIAL ASSESSMENTS -115,198 -103,650 86,380 -1,257 -83,306 -196.44% TOTAL SPECIAL ASSESSMENTS -115,198 -103,650 86,380 -1,257 -83,306 -196.44% 4603 - INTEREST EARNINGS -2,970 -3,839 -3,500 -1,894 -3,585 2.43%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -2,970 -3,839 -3,500 -1,894 -3,585 2.43% 4605 - UNREALIZED INVESTMENT GAIN/LOS 4,136 14,861 0 TOTAL MISCELLANEOUS 4,136 14,861 0 REVENUES -366,921 -346,538 -174,023 -3,151 -347,287 99.56% BLANK BLANK 1 BLANK 2 BLANK 3 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6601 - BOND PRINCIPAL 339,017 342,277 345,537 345,537 348,796 0.94% 6611 - BOND INTEREST 42,842 36,029 29,151 16,303 21,771 -25.32% 6621 - PAYING AGENT/OTHER FEES 1,720 1,328 1,500 0 1,500 0.00% TOTAL DEBT SERVICE 383,579 379,633 376,188 361,840 372,067 -1.10% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 383,579 379,633 376,188 361,840 372,067 -1.10% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 47528 - GO IMPROVEMENT BONDS-2016A 4101 - CURRENT AD VALOREM TAXES -211,223 -212,706 -215,775 0 -211,785 -1.85% 4154 - PENALTIES & INT-DELINQ TAXES -114 -76 0 PROPERTY TAXES -211,338 -212,783 -215,775 0 -211,785 -1.85% TOTAL TAXES -211,338 -212,783 -215,775 0 -211,785 -1.85% 4603 - INTEREST EARNINGS -675 -1,228 -1,000 -463 -1,101 10.10%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -675 -1,228 -1,000 -463 -1,101 10.10% 4605 - UNREALIZED INVESTMENT GAIN/LOS 1,123 4,562 0 TOTAL MISCELLANEOUS 1,123 4,562 0 REVENUES -210,890 -209,448 -216,775 -463 -212,886 -1.79% BLANK BLANK 1 BLANK 2 BLANK 3 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6601 - BOND PRINCIPAL 180,000 180,000 185,000 185,000 190,000 2.70% 6611 - BOND INTEREST 24,600 21,000 17,350 9,600 13,600 -21.61% 6621 - PAYING AGENT/OTHER FEES 3,950 500 1,500 200 1,500 0.00% TOTAL DEBT SERVICE 208,550 201,500 203,850 194,800 205,100 0.61% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 208,550 201,500 203,850 194,800 205,100 0.61% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 47529 - GO IMPROVEMENT BONDS-2017A 4101 - CURRENT AD VALOREM TAXES -282,636 -281,263 -282,091 0 -285,759 1.30% 4154 - PENALTIES & INT-DELINQ TAXES -149 -100 0 PROPERTY TAXES -282,785 -281,363 -282,091 0 -285,759 1.30% TOTAL TAXES -282,785 -281,363 -282,091 0 -285,759 1.30% 4601 - SPECIAL ASSESSMENTS -188,928 -102,874 79,801 -6,605 -67,915 -185.11% TOTAL SPECIAL ASSESSMENTS -188,928 -102,874 79,801 -6,605 -67,915 -185.11% 4603 - INTEREST EARNINGS -4,769 -6,005 -5,500 -3,382 -5,695 3.55%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -4,769 -6,005 -5,500 -3,382 -5,695 3.55% 4605 - UNREALIZED INVESTMENT GAIN/LOS 6,413 23,609 0 TOTAL MISCELLANEOUS 6,413 23,609 0 REVENUES -470,069 -366,633 -207,790 -9,987 -359,369 72.95% BLANK BLANK 1 BLANK 2 BLANK 3 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6601 - BOND PRINCIPAL 355,000 365,000 370,000 370,000 375,000 1.35% 6611 - BOND INTEREST 80,263 69,463 58,438 31,994 47,263 -19.12% 6621 - PAYING AGENT/OTHER FEES 1,470 4,165 1,500 200 1,500 0.00% TOTAL DEBT SERVICE 436,733 438,628 429,938 402,194 423,763 -1.44% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 436,733 438,628 429,938 402,194 423,763 -1.44% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 47530 - GO IMPROVEMENT BONDS-2018A 4101 - CURRENT AD VALOREM TAXES -250,478 -244,858 -251,414 0 249,971 -199.43% 4154 - PENALTIES & INT-DELINQ TAXES -136 -87 0 PROPERTY TAXES -250,614 -244,944 -251,414 0 249,971 -199.43% TOTAL TAXES -250,614 -244,944 -251,414 0 249,971 -199.43% 4601 - SPECIAL ASSESSMENTS -207,551 -201,521 -189,055 -2,830 -125,973 -33.37% TOTAL SPECIAL ASSESSMENTS -207,551 -201,521 -189,055 -2,830 -125,973 -33.37% 4603 - INTEREST EARNINGS -5,465 -6,482 -6,200 -3,821 -6,133 -1.08%Allocation of $600,000 total interest income Allocation of $600,000 total interest income TOTAL INVESTMENT EARNINGS -5,465 -6,482 -6,200 -3,821 -6,133 -1.08% 4605 - UNREALIZED INVESTMENT GAIN/LOS 7,229 25,427 0 TOTAL MISCELLANEOUS 7,229 25,427 0 REVENUES -456,401 -427,520 -446,669 -6,650 117,865 -126.39% BLANK BLANK 1 BLANK 2 BLANK 3 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6601 - BOND PRINCIPAL 350,000 360,000 365,000 365,000 380,000 4.11% 6611 - BOND INTEREST 140,850 123,100 104,975 57,050 86,350 -17.74% 6621 - PAYING AGENT/OTHER FEES 1,793 1,343 1,500 200 1,500 0.00% TOTAL DEBT SERVICE 492,643 484,443 471,475 422,250 467,850 -0.77% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 492,643 484,443 471,475 422,250 467,850 -0.77% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 47532 - GO IMPROVEMENT BONDS-2020A 4101 - CURRENT AD VALOREM TAXES -84,629 -236,977 -240,030 0 -241,080 0.44% 4154 - PENALTIES & INT-DELINQ TAXES -18 -109 0 PROPERTY TAXES -84,647 -237,086 -240,030 0 -241,080 0.44% TOTAL TAXES -84,647 -237,086 -240,030 0 -241,080 0.44% 4601 - SPECIAL ASSESSMENTS 0 0 TOTAL SPECIAL ASSESSMENTS 0 0 4603 - INTEREST EARNINGS -58 -1,215 -100 -177 -1,009 909.00% TOTAL INVESTMENT EARNINGS -58 -1,215 -100 -177 -1,009 909.00% 4605 - UNREALIZED INVESTMENT GAIN/LOS 101 4,185 0 TOTAL MISCELLANEOUS 101 4,185 0 REVENUES -84,604 -234,115 -240,130 -177 -242,089 0.82% BLANK BLANK 1 BLANK 2 BLANK 3 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6601 - BOND PRINCIPAL 40,000 195,000 195,000 200,000 2.56% 6611 - BOND INTEREST 22,847 32,900 30,550 16,250 26,600 -12.93% 6621 - PAYING AGENT/OTHER FEES 1,400 1,143 1,500 200 1,500 0.00% TOTAL DEBT SERVICE 24,247 74,043 227,050 211,450 228,100 0.46% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 24,247 74,043 227,050 211,450 228,100 0.46% Page 1 of 1 Obj Acct 2021 Actual Amount 2022 Actual Amount 2023 Final Budget June YTD Actual 2024 Requested Budget 2024 Budget Increase 2025 Requested Budget Comments for 2023 Budget Comments for 2024 Budget Comments for 2025 Budget 47533 - GO IMPROVEMENT BONDS-2021A 4101 - CURRENT AD VALOREM TAXES -211,718 -209,443 0 213,382 -201.88% 4154 - PENALTIES & INT-DELINQ TAXES -109 0 PROPERTY TAXES -211,827 -209,443 0 213,382 -201.88% TOTAL TAXES -211,827 -209,443 0 213,382 -201.88% 4601 - SPECIAL ASSESSMENTS -328,543 -232,070 -155,146 -26,404 -151,481 -2.36% TOTAL SPECIAL ASSESSMENTS -328,543 -232,070 -155,146 -26,404 -151,481 -2.36% 4603 - INTEREST EARNINGS -328 -5,054 -4,000 -3,652 -4,650 16.25% TOTAL INVESTMENT EARNINGS -328 -5,054 -4,000 -3,652 -4,650 16.25% 4605 - UNREALIZED INVESTMENT GAIN/LOS 2,228 19,278 0 TOTAL MISCELLANEOUS 2,228 19,278 0 REVENUES -326,643 -429,674 -368,589 -30,057 57,251 -115.53% BLANK BLANK 1 BLANK 2 BLANK 3 BLANK 4 BLANK 5 BLANK 6 BLANK 7 BLANK 8 BLANK 9 BLANK 10 6601 - BOND PRINCIPAL 250,000 250,000 280,000 12.00% 6611 - BOND INTEREST 83,988 92,850 48,925 82,250 -11.42% 6621 - PAYING AGENT/OTHER FEES 600 400 1,500 200 1,500 0.00% TOTAL DEBT SERVICE 600 84,388 344,350 299,125 363,750 5.63% BLANK 11 BLANK 12 TOTAL BUSINESS UNIT EXPENSES 600 84,388 344,350 299,125 363,750 5.63%