Loading...
HomeMy Public PortalAbout08222022 City Council Budget Workshop Agenda PacketCITY COUNCIL BUDGET WORKSHOP AGENDA August 22, 2022 4:00 p.m. Council Chambers The Public is invited to view our meetings on the City of Crestview Live stream at https://www.cityofcrestview.org or the City of Crestview Facebook Page. You may submit questions on any agenda item in advance by 3:00 p.m. the day of the meeting to cityclerk@cityofcrestview.org. 1.Call to Order 2.Pledge of Allegiance 3.Open Workshop 4.Approve Agenda 5.Presentation 5.1.Budget Review 6.Comments from the Audience 7.Comments from the Mayor and Council 8.Adjournment The Presentations section is for items that were submitted by a citizen or group of Citizens no later than the Wednesday 2 weeks prior to the meeting to the Clerk's office for approval. These items will be scheduled under the section titles Presentations and Reports. Supporting documents must be submitted at this time to be on the regular agenda. All Action Items are for staff and elected officials only and must be submitted for approval no later than the Wednesday 10 days prior to the meeting. Those not listed on the regular agenda who wish to address the council should fill out a yellow card. The card must be submitted to the City Clerk. Speaking time should be three minutes or less, large groups may designate a spokesperson. All remarks should be addressed to the Council as a whole and not to individual members. All meeting procedures are outlined in the Meeting Rules and Procedures brochure available outside the Chambers. Florida Statute 286.0105. Notices of meetings and hearings must advise that a record is required to appeal. Each board, commission, or agency of this state or of any political subdivision thereof shall include in the notice of any meeting or hearing, if notice of the meeting or hearing is required, of such board, commission, or agency, conspicuously on such notice, the advice that, if a person decides to appeal any decision made by the board, agency, or commission with respect to any matter considered at such meeting or hearing, he or she will need a record of the proceedings, and that, for such purpose, he or she may need to ensure that a verbatim record of the proceedings is made, which record includes the testimony and evidence upon which the appeal is to be based. The requirements of this section do not apply to the notice provided in s. 200.065(3). In accordance with Section 286.26, F.S., persons with disabilities needing special accommodations, please contact Maryanne Schrader, City Clerk at cityclerk@cityofcrestview.org or 850- 628-1560 option2 within 48 hours of the scheduled meeting. Page 1 of 79 Division Revenue Carry Forward/ Reserve/ Restricted Grants & Aide Debt Proceeds From Restricted Funding Source Personnel Expenses Operating Expenses Capital Expenses Debt Contingency Transfers Total 0012- Mayor -$ -$ -$ -$ -$ 86,767$ 10,097$ -$ -$ (96,864)$ 0213-Clerk -$ -$ -$ -$ -$ 146,568$ 53,660$ -$ -$ (200,228)$ 0311-G&A 21,451,422$ 3,299,707$ -$ -$ 1,454,002$ 81,773$ 599,660$ 549,088$ 2,774,316$ 22,200,294$ 0412-City Manager -$ -$ -$ -$ -$ 286,101$ 30,159$ 5,816$ -$ (322,076)$ 0413-Human Resources -$ -$ -$ -$ -$ 264,190$ 108,250$ -$ -$ (372,440)$ 0416- Information -$ -$ -$ -$ -$ 280,378$ 613,546$ 13,536$ -$(907,460)$ 0419-Public Info Officer -$ -$ -$ -$ -$ 149,716$ 19,204$ -$ -$ (168,920)$ 0420-Special Events 12,000$ -$ -$ -$ -$ 64,206$ 44,250$ -$ -$ (96,456)$ 0510-PS Administration -$ -$ -$ -$ -$ 241,298$ 113,451$ 154,936$ -$(509,685)$ 001-0610-Fleet -$ -$ -$ -$ -$ 231,532$ 59,643$ 6,795$ -$ (297,970)$ 001-0721-Police 296,100$ -$ -$ -$ 4,000$ 5,344,360$ 1,094,942$ 399,056$ -$ (6,538,258)$ 001-0822-Fire 10,950$ -$ -$ -$ 261,885$ 4,731,633$ 486,238$ 6,852$ 261,885$ (5,213,773)$ 001-0829 Dispatch -$ -$ -$ -$ -$ 1,064,031$ 137,523$ -$ -$ (1,201,554)$ 001-1141-Streets 548,019$ -$ -$ -$ 834,656$ 894,741$ 739,852$ 1,239,414$ -$ (1,491,332)$ 001-1142-1/2 Sales Tax -$ -$ -$ -$ 3,159,539$ -$ -$ -$ 3,159,539$ -$ 001-1424-Code Enforcement 100,000$ -$ -$ -$ -$ 122,706$ 45,184$ -$ -$ (67,890)$ 001-1562-Animal Services 24,000$ -$ -$ -$ -$ 173,273$ 86,950$ -$ 5,000$ (241,223)$ 001-2319-Facilities -$ -$ -$ -$ -$ 923,727$ 378,421$ 27,652$ -$ (1,329,800)$ 001-2413-Finance -$ -$ -$ -$ -$ 648,564$ 37,979$ -$ -$ (686,543)$ 001-2515-Planning 136,000$ -$ -$ -$ -$ 618,467$ 201,468$ 7,171$ -$ (691,106)$ 001-2772-Parks & Rec 52,000$ -$ -$ -$ -$ 267,085$ 68,346$ -$ -$ (283,431)$ 001-2773-Athletics 201,500$ -$ -$ -$ -$ 351,284$ 458,239$ 40,163$ -$ (648,186)$ 001-2774-Library 118,500$ -$ -$ -$ -$ 641,075$ 187,177$ 49,875$ -$ (759,628)$ 001-2776-Cultural Services 5,000$ -$ -$ -$ -$ 66,375$ 14,095$ -$ -$ (75,470)$ Totals 22,955,491$ 3,299,707$ -$ -$ 5,714,082$ 17,679,852$ 5,588,334$ 2,500,354$ 6,200,740$ 0$ 125-2624 Permitting 651,430$ 105,646$ -$ -$ -$ 461,114$ 120,329$ 89,430$ 86,203$ (0)$ Totals 651,430$ 105,646$ -$ -$ -$ 461,114$ 120,329$ 89,430$ 86,203$ (0)$ 150-2854 CDBG -$ 79,890$ 157,584$ -$ -$ -$ 237,474$ -$ -$ -$ Totals -$ 79,890$ 157,584$ -$ -$ -$ 237,474$ -$-$-$ 220-0213 Debt Service 285,541$ -$ -$ -$ -$ 285,541$ -$ -$ -$ Totals 285,541$ -$ -$ -$ -$ -$ 285,541$ -$-$-$ 301 - Capital Projects 72,238$ 5,547,186$ 1,000,000$ 3,750,000$ 1,758,329$ -$ -$ 12,127,753$ -$ -$ Totals 72,238$ 5,547,186$ 1,000,000$ 3,750,000$ 1,758,329$ -$ -$ 12,127,753$ -$ -$ 440-0311 G&A 589,671$ 445,992$ -$ -$ 465,000$ -$ 333,829$ -$ 3,420,163$ (2,253,329)$ 440-0510 PS Admin -$ -$ -$ -$ -$ 668,133$ 227,797$ 354,936$ -$(1,250,866)$ 440-1513 Cust. Service -$ -$ -$ -$ 408,650$ 93,950$ -$-$(502,600)$ 440-1633 Water 3,402,000$ -$ -$ -$ -$ 773,457$ 731,211$ 40,441$ -$ 1,856,892$ 440-1735 Sewer 4,787,000$ -$ -$ -$ -$ 792,215$ 603,149$ 20,323$ 3,371,313$ 440-1935 Wastewater Plant -$ -$ -$ -$ -$ -$ 1,221,409$ -$ -$ (1,221,409)$ Totals 8,778,671$ 445,992$ -$ -$ 465,000$ 2,642,455$ 3,211,345$ 415,700$ 3,420,163$ 0$ 441- Sanitation 4,485,000$ -$ -$ -$ -$ -$ 4,003,000$ 190,000$ 292,000$ -$ Totals 4,485,000$ -$ -$ -$ -$ -$ 4,003,000$ 190,000$ 292,000$ -$ 442- Stormwater 461,743$ -$ -$ -$ 300,000$ 321,289$ 126,600$ 313,854$ -$ 0$ Totals 461,743$ -$ -$ -$ 300,000$ 321,289$ 126,600$ 313,854$ -$0$ 443 - Crestview Unlimited 1,821,600$ -$ -$ -$ -$ 549,430$ 1,149,338$ 122,832$ -$ -$ Totals 1,821,600$ -$ -$ -$ -$ 549,430$ 1,149,338$ 122,832$ -$ -$ 670-0311 CRA 309,760$ 500,000$ -$ -$ -$ -$ 139,123$ 316,637$ 354,000$ -$ Totals 309,760$ 500,000$ -$ -$ -$ -$ 139,123$ 316,637$ 354,000$ -$ Totals 39,821,474$ 9,978,421$ 1,157,584$ 3,750,000$ 8,237,411$ 21,654,140$ 14,861,084$ 16,076,559$ 10,353,106$ 0$ Revised 8/11/2022 Total Budget 62,944,890$ 8/11/2022 2023 City of Crestview Budget Summary General Fund Summary Building & Permitting Special Revenue Summary Community Development Block Grant Utility Fund Summary Community Redevelopment Agency Sanitation Fund Stormwater Utility Debt Service Fund Capital Improvements Fund Crestview Unlimited Budget Summary DR A F T Page 2 of 79 *Revenue Carry Forward Grants & Aide *Debt Proceeds From Restricted Funding Source Personnel Expenses Operating Expenses Capital Expenses Debt, Contingency & Transfers Total 0012- Mayor -$ -$ -$ -$ -$ 86,767$ 10,097$ -$ -$ (96,864)$ 0213-Clerk -$ -$ -$ -$ -$ 146,568$ 53,660$ -$ (200,228)$ 0311-G&A 19,562,717$ 3,299,707$ -$ -$ 3,342,707$ 81,773$ 599,660$ 549,088$ 2,774,316$ 22,200,294$ 0412-City Manager -$ -$ -$ -$ -$ 286,101$ 30,159$ 5,816$ -$ (322,076)$ 0413-Human Resources -$ -$ -$ -$ -$ 264,190$ 108,250$ -$ -$ (372,440)$ 0416- Information Tech -$ -$ -$ -$ -$ 280,378$ 613,546$ 13,536$ -$ (907,460)$ 0419-PIO -$ -$ -$ -$ -$ 149,716$ 19,204$ -$ -$ (168,920)$ 0420-Special Events 12,000$ -$ -$ -$ -$ 64,206$ 44,250$ -$ -$ (96,456)$ 0510-PS Administration -$ -$ -$ -$ -$ 241,298$ 113,451$ 154,936$ -$ (509,685)$ 0610-Fleet -$ -$ -$ -$ -$ 231,532$ 59,643$ 6,795$ -$ (297,970)$ 0721-Police 296,100$ -$ -$ -$ 4,000$ 5,344,360$ 1,094,942$ 399,056$ -$ (6,538,258)$ 0822-Fire 10,950$ -$ -$ -$ 261,885$ 4,731,633$ 486,238$ 6,852$ 261,885$ (5,213,773)$ 0829-Dispatch -$ -$ -$ -$ -$ 1,064,031$ 137,523$ -$ -$ (1,201,554)$ 1141-Streets 120,000$ -$ -$ -$ 1,262,675$ 894,741$ 739,852$ 1,239,414$ -$ (1,491,332)$ 1142-1/2 Sales Tax -$ -$ -$ -$ 3,159,539$ -$ -$ -$ 3,159,539$ -$ 1424-Code Enforcement 100,000$ -$ -$ -$ -$ 122,706$ 45,184$ -$ -$ (67,890)$ 1562-Animal Services 24,000$ -$ -$ -$ -$ 173,273$ 86,950$ -$ 5,000$ (241,223)$ 2319-Facilities -$ -$ -$ -$ -$ 923,727$ 378,421$ 27,652$ -$ (1,329,800)$ 2413-Finance -$ -$ -$ -$ -$ 648,564$ 37,979$ -$ -$ (686,543)$ 2515-Planning 136,000$ -$ -$ -$ -$ 618,467$ 201,468$ 7,171$ -$ (691,106)$ 2772-Parks & Rec 52,000$ -$ -$ -$ -$ 267,085$ 68,346$ -$ -$ (283,431)$ 2773-Athletics 201,500$ -$ -$ -$ -$ 351,284$ 458,239$ 40,163$ -$ (648,186)$ 2774-Library 118,500$ -$ -$ -$ -$ 641,075$ 187,177$ 49,875$ -$ (759,628)$ 2776-Cultural Serv.5,000$ -$ -$ -$ -$ 66,375$ 14,095$ -$ -$ (75,470)$ Totals 20,638,767$ 3,299,707$ -$ -$ 8,030,806$ 17,679,852$ 5,588,334$ 2,500,354$ 6,200,740$ 0$ Total Operating & Capital 8,088,688$ Total Expenses 31,969,280$ 279,417$ -$ 20%25% 30% 279,417$ Reserve Calculation 4,653,637$ 5,817,047$ 6,980,456$ General Fund Summary Contingency Calculation- 5% Operating minus .5 Cent 001-Summary Requested DR A F T Page 3 of 79 Actual 2021 Adopted Budget 2022 Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $8,738,844 $9,358,717 311 0000 Ad Valorem Taxes $10,570,346 $10,570,346 13% $63,893 $3,500 311 3000 Ad Valorem Penalties $4,500 $4,500 29% $3,344,829 $3,225,000 314 0000 Service Taxes $3,400,000 $3,400,000 5% $1,935,655 $1,500,000 323 0000 Franchise Fees $1,725,000 $1,725,000 15% $4,511,132 $4,376,424 335 0000 Revenue Sharing $4,639,059 $4,639,059 6% $0 $52,000 339 0000 Payment in Lieu of Tax $52,000 $52,000 0% $275,351 $200,000 369 0000 Miscellaneous fees $200,000 $200,000 0% $3,600 $7,500 324 1200 Public Safety Impact Fee Com $3,000 $3,000 -60% $36,400 $31,500 324 1100 Public Safety Impact Fee Res $40,000 $40,000 27% $85,000 $85,000 381 0100 Permitting Cost Allocation $85,000 $85,000 0% $39,600 $19,000 381 0200 CRA Cost Allocation $19,000 $19,000 0% $0 $0 381 0300 Stormwater Cost Allocation $0 $0 0% $625,000 $625,000 381 0400 Utility Cost Allocation $625,000 $625,000 0% $100,000 $100,000 381 0500 Solid Waste Allocation $100,000 $100,000 0% $32,900 $34,005 381 0600 CDBG Admin Allocation $31,517 $31,517 -7% $0 $1,880,909 389 9001 Cash Carry Forward $3,299,707 $3,299,707 75% $0 $0 389 9002 Recreation Reserve Funds $0 $0 0% $0 $0 389 9003 Fire Education Reserve $0 $0 0% $0 $0 334 7000 State Grant Revenue $0 $0 0% $0 $1,186,386 Transfer from 1/2 Cent Tax *$1,411,002 $1,411,002 19% $19,792,204 $22,684,941 Total Revenues $26,205,131 32% Full Time Equivalent Employees 5 $24,150 $25,200 511 1100 Executive Salaries $25,200 0% $31,000 $31,000 511 1300 Other Salaries and Wages $31,000 0% $3,326 $4,299 511 2100 FICA Taxes $4,299 0% $46,044 $18,779 511 2300 Life & Health Insurance $21,014 12% $22 $45 511 2400 Workers Compensation $260 477% $104,542 $79,323 Total Personnel Expenses $81,773 3% $57,696 $65,000 511 3101 Legal Fees $75,000 15% $59,025 $60,000 511 3200 Auditing Fees $60,000 0% $346,548 $123,736 511 3400 Contractual Services $38,740 -69% $462 $528 511 3402 Pest Control $0 -100% $10,505 $31,955 511 4000 Travel and Per Diem $31,955 0% 001-0311 General Administrative Account Number Revenues Personnel Expenses Operating Expenses 001-0311-G&A DR A F T Page 4 of 79 Actual 2021 Adopted Budget 2022 Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-0311 General Administrative Account Number $9,065 $11,558 511 4100 Communications $11,558 0% $6,264 $8,400 511 4300 Utilities $8,400 0% $2,164 $9,920 511 4400 Rentals & Leases $9,920 0% $171,030 $168,999 511 4500 Insurance $176,679 5% $0 $500 511 4600 Repairs & Maintenance $500 0% $105,491 $25,000 511 4900 Other Current Charges $25,000 0% $11,203 $300 511 5100 Office Supplies $300 0% $11,203 $4,796 511 5200 Operating Supplies $2,540 -47% $3,593 $2,500 511 5203 Advertising $2,500 0% $14,793 $12,768 511 5400 Dues & Subscriptions $39,768 211% $2,746 $2,700 511 5402 Dinners, Events, ETC $2,700 0% $3,054 $43,100 511 5600 Training $114,100 165% $814,842 $571,760 Total Operating Expenses $599,660 5% $0 $75,000 511 6100 Land $75,000 0% $0 $0 511 6400 Capital Equipment $450,000 0% $0 $10,552 511 6401 Capital Lease $24,088 128% $0 $0 511 6500 CIP $0 0% $0 $85,552 Capital Expenses $549,088 542% $1,186,386 511 6700 Debt Service *$1,161,002 $0 2021 Series CIP Revenue Bonds $198,708 $0 $20,000 $35,000 511 8200 Aid to Private Organizations $35,000 0% $480,547 $615,107 581 9000 Transfers $561,917 -9% Debt, Grants and Transfers Capital Expenses 001-0311-G&A DR A F T Page 5 of 79 Actual 2021 Adopted Budget 2022 Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-0311 General Administrative Account Number $285,000 $321,616 511 9500 Contingencies $279,417 -13% $16,061 $39,000 511 9900 Reserves $538,272 1280% Com Public Safety Impact 1 $3,000 $3,000 Res Public Safety Impact 1 $40,000 $40,000 Reserve Funds 1 $495,272 $495,272 $801,608 $2,197,109 Total Debt, Grants and Transfers $2,774,316 26% $1,720,992 $2,933,744 Total Expenses $4,004,837 37% $18,071,212 $19,751,197 Net Revenue / Expenses $22,200,294 12% * Restricted Funds Public Safety Impact Fee Indicates 1/2 Cent Sales Tax Items 001-0311-G&A DR A F T Page 6 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 $0 Total Revenues 0% Full Time Equivalent Employees 2 $20,000 $20,000 512 1100 Executive Salaries $20,000 0% $46,844 $47,282 512 1200 Regular Wages $41,074 -13% $0 $977 512 Sick Leave Buy Back $0 -100% $2,234 $3,517 512 1201 Holiday Pay $3,330 -5% $0 $0 512 1400 Overtime pay $0 0% $44 $0 512 1700 Compensation Time $0 0% $5,139 $5,491 512 2100 FICA Taxes $4,927 -10% $6,079 $6,576 512 2200 Retirement Contributions $6,039 -8% $9,512 $9,590 512 2300 Life & Health Insurance $10,733 12% $116 $129 512 2400 Workers Compensation $663 414% 512 2500 Unemployment $89,968 $93,562 Total Personnel Expenses $86,767 -7% $1,269 $2,150 512 4000 Travel and Per Diem $2,300 7% $2,170 $1,810 512 4100 Communications $1,810 0% $50 $50 512 4200 Postage $50 0% $2,428 $2,700 512 4300 Utilities $2,700 0% $2,396 $400 512 4400 Rentals & Leases $500 25% $112 $1,000 512 4800 Promotional Activities $1,000 0% $33 $250 512 5100 Office Supplies $250 0% $0 $325 512 5201 Uniforms $325 0% $150 $410 512 5203 Advertising $410 0% $703 $652 512 5400 Dues & Subscriptions $752 15% 001-0112 Mayor Account Number Personnel Expenses Operating Expenses 001-0112-Mayor DR A F T Page 7 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-0112 Mayor Account Number $9,311 $9,747 Total Operating Expenses $10,097 4% $0 $0 Capital Expenses $0 0% $99,279 $103,309 Total Expenses $96,864 -2% -$99,279 -$103,309 Net Revenue / Expenses -$96,864 -2% Capital Expenses 001-0112-Mayor DR A F T Page 8 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 Total Revenues 0% Full Time Equivalent Employees 2 $61,268 $58,511 513 1100 Executive Salaries $66,378 13% $34,560 $40,632 513 1200 Regular Wages $44,405 9% $0 $781 513 Sick Leave Buy Back $854 9% $1,731 $7,165 513 1201 Holiday Pay $7,953 11% $7 $0 513 1400 Overtime pay $0 0% $7,748 $7,977 513 2100 FICA Taxes $8,894 11% $4,713 $5,259 513 2200 Retirement Contributions $6,155 17% $18,840 $9,590 513 2300 Life & Health Insurance $10,733 12% $175 $188 513 2400 Workers Compensation $1,197 537% $129,042 $130,103 Total Personnel Expenses $146,568 13% $0 $0 513 3101 Legal Fees $4,000 0% $0 $1,145 513 4000 Travel and Per Diem $6,145 437% $5,364 $2,075 513 4100 Communications $2,075 0% $2,607 $4,700 513 4200 Postage $4,700 0% $3,384 $2,660 513 4300 Utilities $2,660 0% $1,769 $2,400 513 4400 Rentals & Leases $2,400 0% $0 $500 513 4600 Repairs & Maintenance $500 0% $0 $100 513 4611 Repairs Auto $100 0% $7,560 $8,500 513 4603 Software $15,700 85% $1,200 $1,200 513 4700 Printing $1,200 0% $570 $1,500 513 4800 Special Events $1,500 0% $8,181 $500 513 5100 Office Supplies $2,000 300% Account Number 001-0213 City Clerk Personnel Expenses Operating Expenses 001-0213-Clerk DR A F T Page 9 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 001-0213 City Clerk $2,775 $8,000 513 5200 Operating Supplies $8,000 0% $0 $200 513 5201 Uniforms $200 0% $10 $240 513 5202 Fuel $240 0% $382 $500 513 5203 Advertising $800 60% $33,808 $250 513 5400 Dues & Subscriptions $1,140 356% $0 $180 513 5600 Training $300 67% $67,610 $34,650 Total Operating Expenses $53,660 55% $0 $0 Capital Expenses $0 0% $196,652 $164,753 Total Expenses $200,228 22% -$196,652 -$164,753 Net Revenue / Expenses -$200,228 22% 001-0213-Clerk DR A F T Page 10 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 Total Revenue 0% Full Time Equivalent Employees 2 $113,922 $117,341 512 1100 Executive Salaries $126,145 8% $6,923 $8,728 512 1101 Executive Holiday Pay $10,348 19% $38,892 $47,217 512 1200 Regular Wages $44,791 -5% $0 $3,400 512 Sick Leave Buy Back $3,554 5% $8,474 $3,512 512 1201 Holiday Pay $5,132 46% $0 $0 512 1400 Overtime pay $0 0% $12,740 $13,785 512 2100 FICA Taxes $14,409 5% $36,619 $38,818 512 2200 Retirement Contributions $41,600 7% $38,239 $34,569 512 2300 Life & Health Insurance $38,183 10% $300 $324 512 2400 Workers Compensation $1,940 499% $256,109 $267,694 Total Personnel Expenses $286,101 7% $3,222 $0 512 3400 Contractual Services $0 0% $800 $3,225 512 4000 Travel and Per Diem $3,225 0% $4,843 $2,700 512 4100 Communications $4,450 65% $0 $400 512 4400 Rentals & Leases $400 0% $0 $450 512 4500 Insurance $509 13% $814 $750 512 4611 Repairs - Auto $750 0% $0 $4,000 512 4800 Promotional Activities $4,000 0% $499 $500 512 5100 Office Supplies $500 0% $3,052 $300 512 5200 Operating Supplies $300 0% $0 $200 512 5201 Uniforms $200 0% Account Number 001-0412 City Manager Revenues Operating Expenses Personnel Expenses 001-0412-City Manager DR A F T Page 11 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 001-0412 City Manager $1,182 $1,250 512 5202 Fuel $1,250 0% $3,180 $3,250 512 5218 Rewards & Recognition $3,250 0% $1,313 $1,825 512 5400 Dues & Subscriptions $1,825 0% $9,500 $9,500 512 5600 Training $9,500 0% $28,405 $28,350 Total Operating Expenses $30,159 6% $0 $0 512 6400 Equipment $0 0% $0 512 64-01 Capital Lease $5,816 0% $0 $0 Capital Expenses $5,816 0% $284,514 $296,044 Total Expenses $322,076 9% -$284,514 -$296,044 Net Revenue / Expenses -$322,076 9% Capital Expenses 001-0412-City Manager DR A F T Page 12 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY 2023 Department Totals % o f C h a n g e $0 Total Revenues 0% Full Time Equivalent Employees 3 $118,922 $162,844 512 1200 Regular Wages $172,928 6% $0 $3,365 512 Sick Leave Buy Back $3,595 7% $5,594 $12,112 512 1201 Holiday Pay $14,021 16% $0 $0 512 1400 Overtime pay $0 0% $0 $0 512 1500 Incentive Pay $0 0% $8,949 $13,642 512 2100 FICA Taxes $14,577 7% $15,219 $22,647 512 2200 Retirement Contributions $25,914 14% $20,602 $27,814 512 2300 Life & Health Insurance $31,193 12% $205 $321 512 2400 Workers Compensation $1,963 511% 512 2500 Unemployment $169,491 $242,745 Total Personnel Expenses $264,190 9% $0 $885 512 4000 Travel and Per Diem $1,260 42% $2,148 $3,955 512 4100 Communications $5,065 28% $535 $450 4400 Rentals & Leases $300 -33% $2,419 $4,000 512 4500 Insurance $4,000 0% $0 $50 512 4700 Printing $250 400% $293 $300 512 5100 Office Supplies $1,000 233% $5,400 $8,500 512 5200 Operating Supplies $11,150 31% $0 $375 512 5201 Uniforms $500 33% $225 $1,500 512 5203 Advertising $1,000 -33% $7,331 $14,000 512 5205 Employee Events $21,500 54% $11,006 $27,775 512 5206 Medical $25,675 -8% $60 $2,000 512 5218 Rewards & Recognition $7,000 250% 001-0413 Human Resources Account Number Revenues Operating Expenses Personnel Expenses 001-0413-Human Resources DR A F T Page 13 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY 2023 Department Totals % o f C h a n g e 001-0413 Human Resources Account Number $6,638 $8,250 512 5400 Dues & Subscriptions $8,250 0% $23,795 $21,300 512 5600 Training $21,300 0% $63,050 $93,340 Total Operating Expenses $108,250 16% $0 $0 512 6400 Equipment $0 $0 0% $0 $0 Capital Expenses $0 0% $232,541 $336,085 Total Expenses $372,440 11% -$232,541 -$336,085 Net Revenue / Expenses -$372,440 11% Capital Expenses 001-0413-Human Resources DR A F T Page 14 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 Total Revenue 0% Full Time Equivalent Employees 4 $123,002 $126,779 512 1200 Regular Wages $185,205 46% $0 $1,840 512 Sick Leave Buy Back $2,011 9% $5,982 $9,430 512 1201 Holiday Pay $15,017 59% $313 $1,111 512 1400 Overtime pay $1,955 76% $0 $0 512 1500 Incentive Pay $0 0% $9,367 $10,561 512 2100 FICA Taxes $15,471 46% $16,013 $17,532 512 2200 Retirement Contributions $27,504 57% $10,334 $13,667 512 2300 Life & Health Insurance $31,134 128% $216 $248 512 2400 Workers Compensation $2,083 740% $165,227 $181,168 Total Personnel Expenses $280,378 55% $60,000 $60,775 512 3400 Contractual Services $85,200 40% $1,945 $3,325 512 4000 Travel and Per Diem $4,400 32% $2,925 $3,055 512 4100 Communications $7,550 147% $267 $300 4500 Insurance $500 67% $2,100 $211,943 512 4603 Software $339,266 60% $300 $600 512 5100 Office Supplies $800 33% $2,750 $133,920 512 5200 Operating Supplies $134,320 0% $240 $600 512 5201 Uniforms $700 17% $204 $240 512 5202 Fuel $240 0% $47,025 $0 512 5400 Dues & Subscriptions $0 0% $2,260 $2,495 512 5600 Training $2,570 3% $0 512 9900 Reserve $38,000 0% 001-0416 Information Technology Account Number Operating Expenses Revenues Personnel Expenses 001-0416- IT DR A F T Page 15 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-0416 Information Technology Account Number $122,116 $418,953 Total Operating Expenses $613,546 402% $27,762 $98,600 512 6400 Equipment $0 -100% $0 512 64-01 Capital Lease $13,536 0% $27,762 $98,600 Capital Expenses $13,536 -51% $315,105 $698,721 Total Expenses $907,460 30% -$315,105 -$698,721 Net Revenue / Expenses -$907,460 30% Capital Expenses 001-0416- IT DR A F T Page 16 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 Total Revenues 0% Full Time Equivalent Employees 2 $41,510 $84,917 512 1200 Regular Wages $99,962 18% $0 $0 512 Sick Leave Buy Back $0 0% $1,920 $6,316 512 1201 Holiday Pay $4,881 -23% $0 $914 512 1400 Overtime pay $1 -100% $0 $0 512 1500 Incentive Pay $0 0% $3,218 $6,979 512 2100 FICA Taxes $8,267 18% $5,343 $11,587 512 2200 Retirement Contributions $14,697 27% $9,271 $18,543 512 2300 Life & Health Insurance $20,795 12% $72 $164 512 2400 Workers Compensation $1,113 579% $61,334 $129,420 Total Personnel Expenses $149,716 144% $0 $3,000 512 3400 Contractual Services $316 -89% $250 $250 512 4000 Travel and Per Diem $4,800 1820% $1,135 $2,330 512 4100 Communications $2,330 0% $0 $0 512 4700 Printing $550 0% $0 $1,300 512 4800 Promotional Activities $3,000 131% $100 $150 512 5100 Office Supplies $150 0% $100 $4,300 512 5200 Operating Supplies $2,793 -35% $100 $250 512 5201 Uniforms $0 -100% $0 $0 512 5203 Advertising $2,158 0% $2,360 $3,125 512 5400 Dues & Subscriptions $3,107 -1% $0 $250 512 5600 Training $2,000 700% 001-0419 Public Information Officer Account Number Operating Expenses Revenues Personnel Expenses 001-0419- PIO DR A F T Page 17 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-0419 Public Information Officer Account Number $4,045 $14,955 Total Operating Expenses $19,204 28% $3,500 $0 512 6400 Equipment $0 0% $3,500 $0 Capital Expenses $0 0% $68,879 $144,375 Total Expenses $168,920 17% -$68,879 -$144,375 Net Revenue / Expenses -$168,920 17% Capital Expenses 001-0419- PIO DR A F T Page 18 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $26,925 $0 369 2014 Sponsorships $12,000 $12,000 0% $44,370 $0 Total Revenues $12,000 0% Full Time Equivalent Employees 1 $36,054 $33,526 2774 1200 Regular Wages $39,766 19% $0 $0 2774 Sick Leave Buy Back $0 0% $1,582 $2,909 2774 1201 Holiday Pay $3,224 11% $0 $0 2774 1400 Overtime pay $1,240 0% $0 $0 2774 1500 Incentive Pay $0 0% $2,724 $2,787 2774 2100 FICA Taxes $3,289 18% $4,744 $4,627 2774 2200 Retirement Contributions $5,847 26% $10,987 $9,271 2774 2300 Life & Health Insurance $10,398 12% $1,602 $66 2774 2400 Workers Compensation $443 566% $57,693 $53,186 Total Personnel Expenses $64,206 21% $11,500 $10,000 572 3400 Contractual Services $15,000 50% $264 $264 572 3402 Pest Control $0 -100% $0 $415 572 4000 Travel and Per Diem $415 0% $20,191 $17,895 572 4100 Communications $525 -97% $21,765 $20,904 572 4300 Utilities $0 -100% $115 $3,500 572 4400 Rentals & Leases $0 -100% $7,391 $9,700 572 4500 Insurance $0 -100% $0 $2,200 572 4600 Repairs & Maintenance $0 -100% $0 $0 572 4900 Other Current Charges $0 0% $0 $200 572 4611 Repairs Auto $0 -100% $0 $0 572 4801 Promotional Activities City- Wide $15,000 0% 001-2775 Special Events Account Number Revenues Personnel Expenses Operating Expenses 001-0420 Special Events DR A F T Page 19 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2775 Special Events Account Number $0 $0 572 4802 Promotional Activities Mayor $6,000 0% $0 $150 572 5100 Office Supplies $150 0% $4,889 $12,500 572 5200 Operating Supplies $250 -98% $0 $60 572 5201 Uniforms $60 0% $1,750 $6,000 572 5217 Special Events - $6,000 0% $0 $850 572 5600 Training $850 0% $67,865 $84,638 Total Operating Expenses $44,250 -48% $0 $0 572 6400 Equipment $0 0% $0 $0 Capital Expenses $0 0% $125,558 $137,824 Total Expenses $108,456 -21% -$81,188 -$137,824 Net Revenue / Expenses -$96,456 -30% Capital Expenses 001-0420 Special Events DR A F T Page 20 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 Total Revenue 0% Full Time Equivalent Employees 3 $211,846 $151,258 519 1200 Regular Wages $165,982 10% $0 $1,509 519 Sick Leave Buy Back $1,518 1% $8,649 $11,251 519 1201 Holiday Pay $17 -100% $151 $0 519 1400 Overtime pay $0 0% $0 $0 519 1500 Incentive Pay $0 0% $16,187 $12,547 519 2100 FICA Taxes $13,843 10% $9,367 $20,830 519 2200 Retirement Contributions $24,610 18% $40,679 $27,814 519 2300 Life & Health Insurance $31,193 12% $3,145 $2,195 519 2400 Workers Compensation $4,135 88% $290,024 $227,404 Total Personnel Costs $241,298 6% $7,400 $50,000 519 3103 Engineering Fees $50,000 0% $275 $264 519 3402 Pest Control $0 -100% $13,152 $13,575 519 4100 Communications $14,325 6% $0 $300 519 4200 Postage $250 -17% $13,878 $12,700 519 4300 Utilities $12,700 0% $1,772 $4,807 519 4400 Rentals & Leases $6,207 29% $6,115 $8,925 519 4500 Insurance $8,925 0% $5,614 $6,564 519 4600 Repairs & Maintenance $6,564 0% $2,342 $2,500 519 4611 Repairs Auto $2,420 -3% $0 $250 519 4612 Repairs - Small Equipment $250 0% $0 $250 519 4613 Repairs - Heavy Equipment $250 0% Account Number 001-0510 Public Services Administration Operating Expenses Personnel Expenses Revenues 001-0510-PS Administration DR A F T Page 21 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 001-0510 Public Services Administration $733 $1,850 519 5100 Office Supplies $850 -54% $9,206 $4,850 519 5200 Operating Supplies $4,850 0% $890 $1,180 519 5201 Uniforms $1,610 36% $3,328 $3,750 519 5202 Fuel $3,750 0% $635 $700 519 5203 Advertising $500 -29% $65,820 $112,465 Total Operating Expenses $113,451 1% $0 $0 519 6300 Improvements/Not buildings $145,000 0% $0 $0 519 6401 Capital Leases $9,936 0% $0 $0 Capital Expenses $154,936 0% $355,844 $339,869 Total Expenses $509,685 50% -$355,844 -$339,869 Net Revenue / Expenses -$509,685 50% Capital Expenses 001-0510-PS Administration DR A F T Page 22 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e (Non Revenue Division) Total Revenues Full Time Equivalent Employees 3 $126,823 $129,657 519 1200 Regular Wages $140,236 8% $0 $2,679 Sick Leave Buy Back $2,916 9% $5,994 $9,644 519 1201 Holiday Pay $11,370 18% $328 $265 519 1400 Overtime pay $288 9% $0 $0 519 1500 Incentive Pay $0 0% $9,576 $10,861 519 2100 FICA Taxes $11,821 9% $16,349 $18,031 519 2200 Retirement Contributions $21,015 17% $31,354 $31,534 519 2300 Life & Health Insurance $36,253 15% $3,723 $5,807 519 2400 Workers Compensation $7,633 31% $194,148 $208,478 Total Personnel Expenses $231,532 11% $4,026 $3,525 519 4100 Communications $3,725 6% $9,559 $9,750 519 4300 Utilities $9,750 0% $3,808 $2,875 519 4500 Insurance $4,068 41% $2,210 $7,000 519 4600 Repairs & Maintenance $7,000 0% $422 $2,100 519 4611 Repairs Auto $2,100 0% $20,015 $22,600 519 5200 Operating Supplies $22,600 0% $910 $1,100 519 5201 Uniforms $1,100 0% $3,472 $6,400 519 5202 Fuel $6,400 0% $0 $2,900 519 5400 Dues & Subscriptions $2,900 0% Account Number 001-0610 Fleet Maintenance Operating Expenses Personnel Expenses Revenues 001-0610- Fleet DR A F T Page 23 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 001-0610 Fleet Maintenance $44,422 $58,250 Total Operating Expenses $59,643 2% $0 $38,200 519 6400 Equipment $0 -100% $0 $6,913 519 6401 Capital Leases $6,795 -2% $0 $45,113 Capital Expenses $6,795 -85% $238,570 $311,841 Total Expenses $297,970 -4% -$238,570 -$311,841 Net Revenue / Expenses -$297,970 -4% Capital Expenses 001-0610- Fleet DR A F T Page 24 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $63,937 $50,000 351 0000 Police Fines $60,000 $60,000 20% $943 $1,500 342 1000 Fingerprinting $1,100 $1,100 -27% $171,607 $235,000 354 0100 Red Light Violations $235,000 $235,000 0% $0 $0 354 0600 Local PA $4,000 $4,000 0% $236,487 $286,500 Total Revenues $300,100 5% Full Time Equivalent Employees 61 $2,179,237 $2,697,647 521 1200 Regular Wages $3,100,232 15% $0 $36,090 521 1200 Sick Leave Buy Back $40,547 12% $105,023 $317,885 521 1201 Holiday Pay $384,663 21% $174,097 $160,908 521 1400 Overtime pay $186,195 16% $22,990 $35,000 521 1500 Incentive Pay $35,000 0% $180,475 $234,982 521 2100 FICA Taxes $271,229 15% $310,540 $351,214 521 2200 Retirement Contributions $479,036 36% $456,976 $576,964 521 2300 Life & Health Insurance $688,759 19% $76,379 $110,949 521 2400 Workers Compensation $158,699 43% $3,505,717 $4,521,639 Total Personnel Expenses $5,344,360 18% $0 521 3100 Legal $6,000 0% $769,615 $48,780 521 3400 Contractual Services $48,995 0% $202,754 $208,560 521 34-03 Red Light Camera $208,560 0% $550 $550 521 34-02 Pest Control $550 0% $10,796 $20,350 521 4000 Travel and Per Diem $20,830 2% $87,666 $79,869 521 4100 Communications $91,764 15% $946 $2,500 521 4200 Postage $2,500 0% $25,345 $42,600 521 4300 Utilities $42,600 0% $4,738 $5,860 521 4400 Rentals & Leases $8,360 43% $31,131 $37,681 521 4500 Insurance $38,081 1% 001 0721 Police Account Number Operating Expenses Personnel Expenses Revenues 001-0721-Police DR A F T Page 25 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001 0721 Police Account Number $4,149 $21,270 521 4600 Repairs & Maintenance $21,270 0% $52,941 $42,363 521 4603 Software $18,728 -56% $17,040 $22,000 521 4604 Vehicle Striping $17,250 -22% $13,761 $90,800 521 4611 Repairs Auto $90,800 0% $479 $3,495 521 4700 Printing $3,795 9% $13,167 $20,800 521 5100 Office Supplies $20,800 0% $112,500 $58,734 521 5200 Operating Supplies $82,485 40% $51,932 $51,932 521 5201 Uniforms $54,445 5% $122,176 $200,360 521 5202 Fuel $221,260 81% $0 $700 521 5203 Advertising $700 0% $18,604 $10,090 521 5204 Ammunition $12,582 25% $0 $9,825 521 5208 SWAT $21,491 119% $6,561 $4,100 521 5210 Investigations $5,800 41% $8,143 $16,520 521 5211 Canine $16,520 0% $0 $4,200 521 5212 Community Outreach $4,400 5% $973 $28,975 521 5400 Books, Dues & Subscriptions $6,356 -78% $40,778 $39,020 521 5600 Training $34,020 -17% $1,596,745 $1,071,934 Total Operating Expenses $1,094,942 2% $0 $0 521 6300 Improvements $0 0% $310,811 $264,140 521 6400 Equipment $241,140 -22% $161,007 $155,127 Capital Leases $157,916 -2% $471,819 $419,267 Capital Expenses $399,056 -5% Capital Expenses 001-0721-Police DR A F T Page 26 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001 0721 Police Account Number $5,574,281 $6,012,840 Total Expenses $6,838,358 14% -$5,337,794 -$5,726,340 Net Revenue / Expenses -$6,538,258 14% 001-0721-Police DR A F T Page 27 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $6,500 $6,500 329 0400 Fire Safety Code $2,750 $2,750 -58% $7,200 $7,200 335 2100 Fire Fighter Supplemental Comp $7,200 $7,200 0% $1,800 $1,800 369 2013 Fire CPR Training $1,000 $1,000 -44% $110,000 $772,016 Transfer from 1/2 Cent *$261,885 $261,885 -66% $125,510 $787,516 Total Revenues $272,835 -65% Full Time Equivalent Employees 49 $2,741,540 $2,266,225 522 1200 Regular Wages $2,451,209 8% $0 $32,574 522 Sick Leave Buy Back $35,350 9% $154,428 $254,202 522 1201 Holiday Pay $288,935 14% $3,600 $3,546 522 1202 Out of Class Pay $3,872 9% $324,999 $366,209 522 1400 Unscheduled Overtime Pay $399,893 9% $110,825 $128,546 522 1500 Incentive Pay $128,872 0% $246,746 $215,943 522 2100 FICA Taxes $234,090 8% $375,463 $300,251 522 2200 Retirement Contributions $379,785 26% $676,069 $565,629 522 2300 Life & Health Insurance $627,863 11% $133,801 $143,680 522 2400 Workers Compensation $181,764 27% $4,767,471 $4,276,805 Total Personnel Expenses $4,731,633 11% $51,312 $0 522 3400 Contractual Services $25,578 0% $1,188 $1,200 522 3402 Pest Control $0 -100% $469 $4,455 522 4000 Travel and Per Diem $4,455 0% $56,006 $51,600 522 4100 Communications $72,968 41% $401 $1,000 522 4200 Postage $1,000 0% $44,068 $38,400 522 4300 Utilities $38,400 0% $22,877 $25,646 522 4400 Rentals & Leases $26,246 2% $14,090 $21,135 522 4500 Insurance $23,738 12% $15,659 $19,920 522 4600 Repairs & Maintenance $19,920 0% 001-0822 Fire Department Account Number Operating Expenses Personnel Expenses Revenues 001-0822- Fire DR A F T Page 28 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-0822 Fire Department Account Number $69,621 $11,882 522 4603 Software $15,780 33% $18,725 $40,000 522 4611 Repairs - Auto $40,000 0% $258 $1,000 522 4612 Repairs - Small Equipment $1,000 0% $0 $0 522 4613 Repairs - Heavy Equipment $0 0% $1,369 $3,000 522 5100 Office Supplies $2,500 -17% $127,794 $82,848 522 5200 Operating Supplies $76,146 -8% $39,991 $49,800 522 5201 Uniforms $56,100 13% $26,322 $34,200 522 5202 Fuel $34,200 0% $0 $4,500 522 5212 Community Outreach $4,500 0% $1,300 $5,000 522 5400 Dues & Subscriptions $5,000 0% $18,189 $38,707 522 5600 Training $38,707 0% $0 $0 522 9900 Reserve $0 0% $600,951 $434,293 Total Operating Costs $486,238 12% $52,310 $0 522 6400 Equipment $0 0% $0 $0 522 6401 Captial Lease $6,852 0% $131,196 $0 Total Capital Costs $6,852 0% $94,091 $96,205 522 6800 Principal $261,261 172% $15,499 $13,385 512 6801 Interest $624 -95% $109,590 $109,590 $261,885 139% $ 5,478,012 $ 4,820,688 Total Expenses $5,486,608 14% -$5,352,502 -$4,033,172 Net Revenue / Expenses -$5,213,773 29% *Funded or Partially Funded by 1/2 Cent Sales Tax Total Debt Grants and Transfers Debt, Grants and Transfers Capital Costs 001-0822- Fire DR A F T Page 29 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 Total Revenues $0 0% Full Time Equivalent Employees 16 $0 $596,817 529 1200 Regular Wages $644,481 8% $0 $8,353 529 Sick Leave Buy Back $9,095 9% $0 $4,672 529 1201 Holiday Pay $5,098 9% $0 $0 529 1202 Out of Class Pay $0 0% $0 $27,607 529 1400 Unscheduled Overtime Pay $29,968 9% $0 $6,844 529 1500 Incentive Pay $9,853 44% $0 $0 529 1600 Scheduled Overtime (combined with unscheduled)0% $0 $57,059 529 2100 FICA Taxes $63,206 11% $0 $94,726 529 2200 Retirement Contributions $112,366 19% $0 $160,698 529 2300 Life & Health Insurance $181,453 13% $0 $1,343 529 2400 Workers Compensation $8,510 534% $0 $958,119 Total Personnel Expenses $1,064,031 11% $0 $51,312 529 3400 Contractual Services $51,312 0% $0 $792 529 3402 Pest Control $0 -100% $0 $1,075 529 4000 Travel and Per Diem $1,075 0% $0 $16,926 529 4100 Communications $16,926 0% $0 $0 529 4200 Postage 0%0% $0 $8,400 529 4300 Utilities $8,400 0% $0 $1,200 529 4400 Rentals & Leases $1,200 0% $0 $50,875 529 4603 Software $50,875 0% $0 $2,400 529 5200 Operating Supplies $2,400 0% $0 $4,000 529 5201 Uniforms $4,000 0% Account Number 001-0829 DISPATCH Revenues Operating Expenses Personnel Expenses 001-0829- DISPATCH DR A F T Page 30 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 001-0829 DISPATCH $0 $1,335 529 5600 Training $1,335 0% $0 $138,315 Total Operating Costs $137,523 -1% $0 $0 Total Capital Costs $0 0% $0 $1,096,434 Total Expenses $1,201,554 10% $0 -$1,096,434 Net Revenue / Expenses -$1,201,554 10% Capital Expenses 001-0829- DISPATCH DR A F T Page 31 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $715,000 $732,269 312 4000 Local Option Gas Tax $834,656 $834,656 14% $120,000 $120,000 335 4900 FDOT Lighting/Maintenance $120,000 $120,000 0% $0 381 0000 Transfer from 1/2 Cent *$428,019 $428,019 0% $835,000 $852,269 Total Revenues $1,382,675 62% Full Time Equivalent Employees 13 $416,998 $437,704 541 1200 Regular Wages $511,747 17% $0 $4,056 Sick Leave Buy Back $4,561 12% $20,064 $32,556 541 1201 Holiday Pay $41,493 27% $7,281 $7,611 541 1400 Overtime pay $9,023 19% $0 $7,200 541 1500 Incentive Pay $7,200 0% $686 $0 541 1700 Compensation Time $0 0% $32,638 $36,836 541 2100 FICA Taxes $43,223 17% $55,908 $61,153 541 2200 Retirement Contributions $76,840 26% $121,345 $135,519 541 2300 Life & Health Insurance $140,199 3% $38,385 $47,429 541 2400 Workers Compensation $60,455 27% $693,305 $770,064 Total Personnel Costs $894,741 16% $264,258 $195,000 541 3400 Contractual Services $130,000 -33% $0 $40 541 4000 Travel and Per Diem $0 -100% $7,001 $4,875 541 4100 Communications $4,875 0% $257,303 $315,120 541 4300 Utilities $315,120 0% $0 $20,000 541 4400 Rentals & Leases $20,000 0% $13,185 $8,540 541 4500 Insurance $9,127 7% $59,981 $30,000 541 4600 Repairs & Maintenance $30,000 0% $5,080 $20,000 541 4611 Repairs - Auto $20,000 0% 001-1141 Streets Account Number Revenues Personnel Expenses Operating Expenses 001-1141-Streets DR A F T Page 32 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-1141 Streets Account Number $3,716 $5,000 4612 Repairs - Small Equipment $5,000 0% $9,519 $10,000 4613 Repairs - Heavy Equipment $10,000 0% $31,100 $36,000 541 5200 Operating Supplies $36,000 0% $3,744 $4,440 541 5201 Uniforms $4,480 1% $30,871 $35,400 541 5202 Fuel $50,400 42% $93,089 $102,000 541 5300 Materials $102,000 0% $703 $2,850 541 5600 Training $2,850 0% $779,550 $789,265 Total Operating Expenses $739,852 -6% $0 $746,900 541 6300 Improvements/Not buildings $834,656 12% Street Resurfacing 1 $834,656 $834,656 $10,639 $0 541 6400 Equipment $363,019 0% $0 $20,739 541 6401 Capital Leases $41,739 101% $10,639 $767,639 Capital Expenses $1,239,414 61% $1,483,494 $2,326,968 Total Expenses $2,874,007 24% -$648,494 -$1,474,699 Net Revenue / Expenses -$1,491,332 1% *Indicates 1/2 Cent Sales Tax Items Indicates Local Option Gas Tax Items Capital Expenses 001-1141-Streets DR A F T Page 33 of 79 Actual Budget 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $3,008,322 $2,921,908 335 1900 1/2 Cent Sales Tax $3,159,539 $3,159,539 5% $3,008,322 $2,921,908 Total Revenues $3,159,539 5% Full Time Equivalent Employees 0 $0 $0 Total Personnel Costs $0 0% $1,271,439 $2,523,802 581 9000 Transfer $2,451,577 -3% $0 $218,371 511 9500 Contingencies $707,962 224% $1,271,439 Total Transfers & Contingencies $3,159,539 149% $254,854 $228,729 541 6300 Improvements $0 -100% $254,854 $228,729 Capital Expenses $0 -100% $1,526,293 $228,729 Total Expenses $3,159,539 107% $1,482,029 $2,693,179 Net Revenue / Expenses $0 -100% Account Number 001-1142 1/2 Sales Tax Capital Expenses Personnel Expenses Revenues Transfers & Contingencies 001-1142-.05 Sales Tax DR A F T Page 34 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $15,000 $15,000 354 0000 Code Violations $15,000 $15,000 0% $0 349 1000 Lien Searches $70,000 $70,000 0% $0 Foreclosure/Nuisance Abatement $15,000 $15,000 0% $15,000 $15,000 Total Revenues $100,000 567% Full Time Equivalent Employees 2 $60,156 $71,243 524 1200 Regular Wages $75,693 6% $0 $0 Sick Leave Buy Back $0 0% $3,222 $5,299 524 1201 Holiday Pay $6,137 16% $0 $0 524 1400 Overtime pay $0 0% $0 $0 524 1500 Incentive Pay $0 0% $4,900 $5,855 524 2100 FICA Taxes $6,260 7% $7,946 $9,721 524 2200 Retirement Contributions $11,129 14% $14,545 $18,543 524 2300 Life & Health Insurance $20,795 12% $1,730 $1,868 524 2400 Workers Compensation $2,692 44% $92,499 $112,529 Total Personnel Expenses $122,706 9% $1,800 $5,400 524 3101 Legal Fees $5,400 0% $1,383 $4,410 524 4000 Travel and Per Diem $4,410 0% $6,875 $3,200 524 4100 Communications $6,800 112% $0 $400 524 4200 Postage $400 0% $327 $875 524 4500 Insurance $820 -6% $330 $120 524 4611 Repairs - Auto $620 417% $76 $810 524 4700 Printing $810 0% $207 $1,000 524 5100 Office Supplies $1,000 0% $144 $1,000 524 5200 Operating Supplies $1,000 0% 001-1424 Code Enforcement Account Number Operating Expenses Personnel Expenses Revenues 001-1424- Code Enforcement DR A F T Page 35 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-1424 Code Enforcement Account Number $984 $775 524 5201 Uniforms $775 0% $85 $2,640 524 5202 Fuel $3,564 35% $0 524 5218 Nuisance Abatement $15,000 0% $240 $585 524 5400 Dues & Subscriptions $585 0% $3,743 $4,000 524 5600 Training $4,000 0% $16,194 $25,215 Total Operating Expenses $45,184 79% $3,471 $0 524 6400 Equipment $0 $0 0% $3,471 $0 Capital Expenses $0 0% $112,164 $137,744 Total Expenses $167,890 22% -$97,164 -$122,744 Net Revenue / Expenses -$67,890 -45% Capital Expenses 001-1424- Code Enforcement DR A F T Page 36 of 79 Actual 2021 Adopted 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f Ch a n g e $0 $5,000 346 2000 Fines 1 $5,200 $5,200 $5,200 4% $0 $1,000 346 3000 Adoption Fee - Spay/Neuter 1 $12,900 $12,900 $12,900 1190% $0 $1,000 346 4000 Impound / Vaccinations / Fees 1 $4,900 $4,900 $4,900 390% $0 $0 354 0700 Violation of Local Ordinance 1 $1,000 $1,000 $1,000 0% 0 $7,000 Total Revenues $24,000 243% Full Time Equivalent Employees 3 $0 $40,011 562 1200 Regular Wages $105,528 164% $0 $0 562 Sick Leave Buy Back $0 0% $0 $2,771 562 1201 Holiday Pay $8,556 209% $0 $3,500 562 1400 Overtime pay $0 -100% $0 $0 562 1500 Incentive Pay $0 0% $0 $3,062 562 2100 FICA Taxes $8,727 185% $0 $5,083 562 2200 Retirement Contributions $15,515 205% $0 $9,271 562 2300 Life & Health Insurance $31,193 236% $0 $1,020 562 2400 Workers Compensation $3,753 268% $0 $64,718 Total Personnel Expenses $173,273 167% $0 $72,747 562 3400 Contractual Services $24,000 -67% $0 $2,705 562 4000 Travel and Per Diem $2,705 0% $0 $1,985 562 4100 Communications $5,435 174% $0 $240 562 4200 Postage $240 0% $0 $6,600 562 4300 Utilities $19,800 200% $0 $3,300 562 4400 Rentals & Leases $2,700 -18% $0 $3,396 562 4500 Insurance $2,173 -36% $0 $1,100 562 4600 Repairs & Maintenance $1,100 0% $3,300 562 4603 Software $4,540 38% $0 $740 562 4611 Repairs - Auto $1,240 68% 001-1562 Animal Services Account Number Revenues Personnel Expenses Operating Expenses DR A F T Page 37 of 79 $0 $360 562 4700 Printing $1,040 189% $0 $500 562 5100 Office Supplies $900 80% $0 $10,783 562 5200 Operating Supplies $10,101 -6% $0 $2,600 562 5202 Fuel $5,200 100% $0 $848 562 5201 Uniforms $1,876 121% $0 $700 562 5400 Dues & Subscriptions $1,400 100% $0 $7,200 562 5600 Training $2,500 -65% $0 $124,104 Total Operating Expenses $86,950 -30% $35,000 562 6300 Improvements $0 -100% $0 $7,920 562 6400 Equipment $0 -100% $0 $0 562 6401 Capital Leases $0 0% $0 $42,920 Capital Expenses $0 -100% $0 $0 562 9500 Contingencies $5,000 0% $0 $0 Total Transfers & Contingencies $5,000 0% $0 $231,742 Total Expenses $265,223 14% $0 -$231,742 Net Revenue / Expenses -$241,223 4% Capital Expenses Transfers & Contingencies DR A F T Page 38 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Non Revenue Division 0% Total Revenues 0% Full Time Equivalent Employees 15.2 $439,914 $498,576 519 1200 Regular Wages $518,549 4% $0 $6,178 Sick Leave Buy Back $6,530 6% $20,916 $39,695 519 1201 Holiday Pay $56,751 43% $18,815 $14,125 519 1400 Overtime pay $15,563 10% $0 $14,400 519 1500 Incentive Pay $14,400 0% $36,479 $42,752 519 2100 FICA Taxes $45,612 7% $42,700 $53,017 519 2200 Retirement Contributions $78,346 48% $115,808 $136,733 519 2300 Life & Health Insurance $160,037 17% $25,124 $21,434 519 2400 Workers Compensation $27,938 30% $699,756 $826,910 Total Personnel Costs $923,727 12% $0 3402 Pest Control $5,696 0% $4,805 $6,081 519 4100 Communications $6,081 0% $4,642 $9,500 519 4400 Rentals & Leases $23,190 144% $4,748 $7,450 519 4500 Insurance $7,450 0% $27,224 $38,000 519 4600 Repairs & Maintenance $38,000 0% $150,023 $167,000 519 4602 Repairs - Building $170,252 2% $4,410 $9,500 519 4611 R&M - Auto $9,500 0% $52,655 $103,199 519 5200 Operating Supplies $92,348 -11% $2,809 $5,000 519 5201 Uniforms $5,297 6% 001-2319 Building Facilities Account Number Revenues Personnel Expenses Operating Expenses 001-2319- Facilities DR A F T Page 39 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2319 Building Facilities Account Number $558 $25,000 519 5202 Fuel $24,703 -1% $25 $800 519 5600 Training $1,600 100% $251,899 $371,530 Total Operating Expenses $378,421 2% $0 $9,949 519 6400 Equipment $0 -100% $0 $27,652 524 6401 Capital Leases $27,652 0% $36,330 $37,601 Capital Expenses $27,652 -26% $987,985 $1,236,041 Total Expenses $1,329,800 8% -$987,985 -$1,236,041 Net Revenue / Expenses -$1,329,800 8% Capital Expenses 001-2319- Facilities DR A F T Page 40 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Non Revenue Division $0 Total Revenues 0% Full Time Equivalent Employees 6 $300,949 $324,768 513 1200 Regular Wages $363,933 12% $0 $5,498 Sick Leave Buy Back $6,073 10% $14,410 $24,156 513 1201 Holiday Pay $29,508 22% $0 $0 513 1400 Overtime pay $0 0% $0 $0 513 1500 Incentive Pay $0 0% $21,695 $27,113 513 2100 FICA Taxes $30,563 13% $33,929 $45,012 513 2200 Retirement Contributions $54,334 21% $64,570 $136,733 513 2300 Life & Health Insurance $160,037 17% $528 $638 513 2400 Workers Compensation $4,115 545% $436,081 $563,918 Total Personnel Costs $648,564 15% $0 $400 513 4000 Travel and Per Diem $4,614 1054% $5,586 $4,465 513 4100 Communications $6,340 42% $344 $780 513 4300 Utilities $780 0% $3,142 $3,940 513 4400 Rentals & Leases $7,000 78% $333 $8,920 513 4603 Software $8,920 0% $68 $3,000 513 5100 Office Supplies $3,000 0% $344 $2,125 513 5200 Operating Supplies $2,125 0% $0 $150 513 5202 Fuel $150 0% $2,102 $650 513 5400 Dues & Subscriptions $850 31% 001-2413 Finance Account Number Operating Expenses Personnel Expenses Revenues 001-2413-Finance DR A F T Page 41 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2413 Finance Account Number $135 $4,200 513 5600 Training $4,200 0% $12,874 $28,630 Total Operating Expenses $37,979 33% $0 $0 513 6400 Equipment $0 0% $0 $0 Capital Expenses $0 0% $448,955 $592,548 Total Expenses $686,543 16% -$448,955 -$592,548 Net Revenue / Expenses -$686,543 16% Capital Expenses 001-2413-Finance DR A F T Page 42 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $125,000 $125,000 316 0000 Business Tax Receipt $125,000 $125,000 0% $2,391 $0 316 1000 Business Tax Penalties $1,000 $1,000 0% $0 $0 349 3000 Planning Review Fee 400 $25 $10,000 $10,000 0% $127,391 $125,000 Total Revenues $136,000 9% Full Time Equivalent Employees 6 $340,009 $420,324 515 1200 Regular Wages $425,935 1% $0 $6,551 Sick Leave Buy Back $6,256 -5% $16,664 $26,823 515 1201 Holiday Pay $29,277 9% $0 $0 515 1400 Overtime pay $0 0% $0 $0 515 1500 Incentive Pay $0 0% $27,799 $35,048 515 2100 FICA Taxes $35,704 2% $45,063 $58,184 515 2200 Retirement Contributions $50,800 -13% $56,248 $67,942 515 2300 Life & Health Insurance $55,140 -19% $6,648 $11,179 515 2400 Workers Compensation $15,355 37% $492,431 $626,051 Total Personnel Expenses $618,467 26% $0 $120,000 515 3400 Contractual Services $120,000 0% $0 $2,480 515 4000 Travel and Per Diem $2,480 0% $9,225 $4,140 515 4100 Communications $8,640 109% $6,380 $16,000 515 4200 Postage $16,000 0% $6,260 $5,106 515 4300 Utilities $6,128 20% $2,732 $2,200 515 4400 Rentals & Leases $2,500 14% $659 $525 4500 Insurance $525 0% $970 $1,000 515 4600 Repairs & Maintenance $1,000 0% $1,620 $5,000 515 4603 Software $5,000 0% 001-2515 Planning & Zoning Account Number Operating Expenses Personnel Expenses Revenues 001-2515-Planning DR A F T Page 43 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2515 Planning & Zoning Account Number $0 $60 515 4611 Repairs - Auto $60 0% $1,098 $19,360 515 4700 Printing $19,360 0% $543 $1,200 515 5100 Office Supplies $1,200 0% $5,049 $5,800 515 5200 Operating Supplies $5,800 0% $0 $1,050 5201 Uniforms $1,050 0% $134 $500 515 5202 Fuel $675 35% $7,748 $8,000 515 5203 Advertising $8,000 0% $90 $800 515 5400 Dues & Subscriptions $800 0% $1,523 $2,250 515 5600 Training $2,250 0% $44,031 $195,471 Total Operating Expenses $201,468 3% $2,161 $0 515 6400 Equipment $0 0% $0 $7,171 515 6401 Capital Leases $7,171 0% $2,161 $7,171 Capital Expenses $7,171 0% $538,623 $828,693 Total Expenses $827,106 0% -$411,232 -$703,693 Net Revenue / Expenses -$691,106 -2% Capital Expenses 001-2515-Planning DR A F T Page 44 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $25,000 369 2201 Community Center $28,000 $28,000 12% $12,000 369 2202 Warriors Hall $14,000 $14,000 17% $5,000 369 2203 Park Rentals $10,000 $10,000 100% $0 Total Revenues $52,000 0% Full Time Equivalent Employees 3 $170,696 $134,236 572 1200 Regular Wages $176,587 32% $0 $2,773 Sick Leave Buy Back $2,914 5% $8,087 $10,528 572 1201 Holiday Pay $15,367 46% $0 $0 572 1400 Overtime pay $0 0% $0 $0 572 1500 Incentive Pay $0 0% $12,576 $11,287 572 2100 FICA Taxes $14,907 32% $16,950 $6,172 572 2200 Retirement Contributions $12,639 105% $31,172 $22,661 572 2300 Life & Health Insurance $42,663 88% $4,051 $266 572 2400 Workers Compensation $2,007 655% $243,532 $187,923 Total Personnel Costs $267,085 42% $146 $1,725 572 4100 Communications $19,625 1038% $0 $1,440 572 4300 Utilities $22,380 1454% $856 $1,000 572 4400 Rentals & Leases $2,500 150% $484 $450 572 4500 Insurance $10,441 2220% $0 572 4600 Repairs & Maintenance $2,200 0% $160 $500 572 4611 Repairs Auto $700 40% $0 $5,000 572 4901 Refunds $5,000 0% $895 $1,000 519 5100 Office Supplies $1,000 12% $2,301 $3,000 572 5200 Operating Supplies $3,000 30% 001-2772 Parks and Recreation Account Number Operating Expenses Personnel Expenses Revenues 001-2772-Parks & Rec DR A F T Page 45 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2772 Parks and Recreation Account Number $0 $300 572 5201 Uniforms $300 0% $0 $900 572 5202 Fuel $900 0% $0 $300 572 5400 Dues & Subscriptions $300 0% $20,842 $15,615 Total Operating Costs $68,346 338% $343,927 $0 572 6500 Construction in Progress 0 $0 $0 $0 0% $343,927 $0 Capital Expenses $0 0% $608,301 $203,538 Total Expenses $335,431 65% -$608,301 -$203,538 Net Revenue / Expenses -$283,431 39% Capital Expenses 001-2772-Parks & Rec DR A F T Page 46 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $83,840 $10,000 347 2000 Charges for Services $20,000 $20,000 100% $5,646 $35,000 347 2100 Football $35,000 $35,000 0% $45,300 $45,300 347 2200 Soccer $35,000 $35,000 -23% $3,810 $6,000 347 2300 Cheerleading $6,500 $6,500 8% $16,715 $16,700 347 2400 Baseball $35,000 $35,000 110% $10,562 $10,000 347 2500 Basketball $35,000 $35,000 250% $0 $0 347 2800 Sponsor Fees $20,000 $20,000 0% $0 347 2900 Adult Sports $5,000 $5,000 0% $6,388 $7,500 369 2000 Concession $10,000 $10,000 33% $172,261 $130,500 Total Revenues $201,500 54% Full Time Equivalent Employees 6.4 $184,599 $216,269 572 1200 Regular Wages $238,295 10% $0 $2,570 Sick Leave Buy Back $2,821 10% $8,348 $13,273 572 1201 Holiday Pay $16,018 21% $153 $895 572 1400 Overtime pay $1,007 13% $0 $0 572 1500 Incentive Pay $0 0% $13,914 $17,757 572 2100 FICA Taxes $19,671 11% $8,837 $11,073 572 2200 Retirement Contributions $13,424 21% $40,570 $41,620 572 2300 Life & Health Insurance $47,037 13% $6,983 $9,772 572 2400 Workers Compensation $13,011 33% $263,404 $313,229 Total Personnel Costs $351,284 12% $0 $25,000 572 3103 Engineering Fees $25,000 0% $62,933 $117,175 572 3400 Contractual Services $117,175 0% $1,914 $1,848 572 3402 Pest Control $0 -100% $752 $1,155 572 4000 Travel and Per Diem $1,155 0% $7,416 $27,794 572 4100 Communications $27,794 0% $110,434 $101,840 572 4300 Utilities $111,840 10% $11,222 $6,700 572 4400 Rentals & Leases $2,500 -63% 001-2773 Athletics Account Number Operating Expenses Personnel Expenses Revenues 001-2773-Athletics DR A F T Page 47 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2773 Athletics Account Number $71,593 $56,916 572 4500 Insurance $60,725 7% $0 $750 572 4600 Repairs & Maintenance $750 0% $15 $750 572 4611 Repairs Auto $750 0% $1,920 $4,800 572 4901 Refunds $4,800 0% $743 $1,950 519 5100 Office Supplies $1,950 0% $54,249 $66,000 572 5200 Operating Supplies $81,000 23% $1,160 $1,050 572 5201 Uniforms $1,050 0% $0 $1,440 572 5202 Fuel $1,440 0% $7,118 $17,300 572 5206 Background Checks $17,300 0% $100 $1,500 572 5203 Advertising $1,500 0% $0 $510 572 5400 Dues & Subscriptions $510 0% $744 $1,000 572 5600 Training $1,000 0% $332,313 $435,478 Total Operating Expenses $458,239 5% $2,041,556 $33,250 572 6300 Improvements/Not buildings $33,250 0% $0 $0 572 6400 Equipment $0 0% $0 $6,913 524 6401 Capital Leases $6,913 0% $2,041,556 $40,163 Capital Expenses $40,163 0% $2,637,273 $788,870 Total Expenses $849,686 8% -$2,465,012 -$658,370 Net Revenue / Expenses -$648,186 -2% Capital Expenses 001-2773-Athletics DR A F T Page 48 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $114,659 $116,000 347 1000 Library Fees $116,000 $116,000 0% $1,844 $10,000 352 0000 Library Fines $2,500 $2,500 -75% $116,503 $126,000 Total Revenues $118,500 -6% Full Time Equivalent Employees 12.8 $358,124 $424,751 572 1200 Regular Wages $460,087 8% $0 $4,850 Sick Leave Buy Back $5,303 9% $14,989 $26,397 572 1201 Holiday Pay $31,227 18% $0 $0 572 1400 Overtime pay 0% $0 $0 572 1500 Incentive Pay 0% $28,013 $34,884 572 2100 FICA Taxes $37,991 9% $33,852 $40,765 572 2200 Retirement Contributions $47,724 17% $38,139 $47,965 572 2300 Life & Health Insurance $53,629 12% $634 $821 572 2400 Workers Compensation $5,115 523% $473,751 $580,433 Total Personnel Expenses $641,075 10% $264 $264 572 3402 Pest Control $0 -100% $267 $855 572 4000 Travel and Per Diem $1,978 131% $11,657 $15,560 572 4100 Communications $15,560 0% $683 $400 572 4200 Postage $400 0% $63,576 $65,700 572 4300 Utilities $65,700 0% $34,647 $33,355 572 4400 Rentals & Leases $3,355 -90% $8,063 $11,350 572 4500 Insurance $12,372 9% $855 $4,100 572 4600 Repairs & Maintenance $4,100 0% $2,358 $2,960 572 5100 Office Supplies $2,960 0% 001-2774 Library Account Number Operating Expenses Personnel Expenses Revenues 001-2774- Library DR A F T Page 49 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2774 Library Account Number $38,980 $28,970 572 5200 Operating Supplies $34,692 20% $0 $420 572 5201 Uniforms $420 0% $0 $1,500 572 5202 Fuel $1,500 0% $50 $250 572 5206 Background Checks $250 0% $18,767 $20,235 572 5400 Dues & Subscriptions $43,090 113% $195 $500 572 5600 Training $800 60% $180,362 $186,419 Total Operating Expenses $187,177 0% $0 $0 572 6300 Improvements/Not buildings $0 0% $90,537 $0 572 6400 Equipment $0 0% $42,659 $36,500 572 6600 Library Books $49,875 37% $133,196 $36,500 Capital Expenses $49,875 37% $787,309 $803,352 Total Expenses $878,128 9% -$670,806 -$677,352 Net Revenue / Expenses -$759,628 12% Capital Expenses 001-2774- Library DR A F T Page 50 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 $0 366 2000 Donations - Museum $5,000 $5,000 0% $0 $0 Total Revenues $5,000 0% Full Time Equivalent Employees 1 $0 $40,707 573 1200 Regular Wages $44,206 9% $0 $841 573 Sick Leave Buy Back $919 9% $0 $0 573 1201 Holiday Pay $0 0% $0 $0 573 1400 Overtime pay $0 0% $0 $0 573 1500 Incentive Pay $0 0% $0 $3,410 573 2100 FICA Taxes $3,726 9% $0 $5,661 573 2200 Retirement Contributions $6,624 17% $0 $9,271 573 2300 Life & Health Insurance $10,398 12% $0 $80 573 2400 Workers Compensation $502 527% $0 $59,970 Total Personnel Expenses $66,375 11% $0 $3,000 3400 Contractual Services $3,000 0% $0 $250 573 4000 Travel and Per Diem $250 0% $0 $1,385 573 4100 Communications $3,885 181% $0 4500 Insurance $2,000 0% $0 $150 573 5100 Office Supplies $150 0% $0 $4,300 573 5200 Operating Supplies $2,800 -35% $0 $125 573 5201 Uniforms $125 0% $0 5203 Advertising $500 0% $0 $2,385 573 5400 Dues & Subscriptions $1,385 -42% $0 $11,595 Total Operating Expenses $14,095 22% 001-2776 Cultural Services Account Number Operating Expenses Personnel Expenses Revenues 001-2776-Cultural Services DR A F T Page 51 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 001-2776 Cultural Services Account Number $0 $0 573 6300 Improvements/Not buildings $0 0% $0 $0 573 6400 Equipment $0 0% $0 $0 Capital Expenses $0 0% $0 $71,565 Total Expenses $80,470 12% $0 -$71,565 Net Revenue / Expenses -$75,470 5% Capital Expenses 001-2776-Cultural Services DR A F T Page 52 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $191,819 $185,000 322 0000 Building Permits Fee $210,000 $210,000 14% $27,960 $68,430 322 0400 Application Fees $68,430 $68,430 0% $155,100 $155,000 322 0500 Subcontractor Permits $175,000 $175,000 13% $96,388 $40,000 322 0600 Misc Permits $55,000 $55,000 38% $103,687 $115,000 322 0700 Misc Fees $125,000 $125,000 9% $17,273 $16,000 322 0100 Surcharge $18,000 $18,000 13% $0 $0 381 0000 Interfund Transfer $0 $0 0% $81,296 $163,898 389 9001 Transfer From Reserve $105,646 $105,646 -36% $673,523 $743,328 Total Revenues $757,076 $757,076 2% Full Time Equivalent Employees 6 $217,850 $294,468 524 1200 Regular Wages $301,580 2% $0 $4,741 Sick Leave Buy Back $4,194 -12% $9,695 $20,294 524 1201 Holiday Pay $20,179 -1% $1,238 $5,326 524 1400 Overtime pay $6,351 19% $0 $3,600 524 1500 Incentive Pay $3,600 0% $16,663 $24,708 524 2100 FICA Taxes $25,647 4% $27,030 $37,830 524 2200 Retirement Contributions $37,162 -2% $44,420 $55,767 524 2300 Life & Health Insurance $52,265 -6% $4,015 $7,000 524 2400 Workers Compensation $10,136 45% $320,911 $453,734 Total Personnel Costs $461,114 2% $0 $0 3400 Contractual Services $0 0% $1,618 $4,720 524 4000 Travel and Per Diem $4,720 0% $6,834 $8,460 524 4100 Communications $8,460 0% $6,344 $6,600 524 4300 Utilities $7,920 20% $1,879 $1,800 524 4400 Rentals & Leases $1,800 0% $3,985 $6,341 524 4500 Insurance $7,934 25% $1,868 $0 524 4600 Repairs & Maintenance $0 0% 125- 2624 Permitting Account Number Operating Expenses Personnel Expenses Revenues 125-2624 Permitting DR A F T Page 53 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 125- 2624 Permitting Account Number $2,484 $39,000 524 4603 Software $39,000 0% $0 $500 524 4610 Repairs - Miscellaneous $500 0% $3 $480 524 4611 Repairs - Auto $480 0% $38 $2,360 524 4700 Printing $2,360 0% $17,939 $8,000 524 4900 Other Current Charges $16,000 100% $241 $3,000 524 5100 Office Supplies $3,000 0% $7,260 $9,000 524 5200 Operating Supplies $6,000 -33% $1,045 $1,600 524 5201 Uniforms $1,600 0% $1,351 $4,630 524 5202 Fuel $6,250 35% $180 $1,320 524 5214 Inspection Tools $1,320 0% $0 $2,000 524 5215 Building Code Software $500 -75% $894 $1,625 524 5216 Personnel Safety Equip.$1,625 0% $1,220 $3,035 524 5400 Dues & Subscriptions $3,035 0% $2,118 $2,500 524 5401 Code Books & Subscriptions $2,500 0% $1,268 $5,325 524 5600 Training $5,325 0% $58,569 $112,296 Total Operating Expenses $120,329 7% $0 $75,000 524 6300 Improvements $75,000 0% $1,898 $0 524 6400 Equipment $0 0% $13,776 $14,430 524 6401 Capital Leases $14,430 0% $15,674 $89,430 Capital Expenses $89,430 0% $0 $85,000 524 9000 Transfers $85,000 0% Transfers and Contingencies Capital Expenses 125-2624 Permitting DR A F T Page 54 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 125- 2624 Permitting Account Number $0 $2,868 524 9500 Contingencies $1,203 -58% $0 $87,868 $86,203 -2% $395,154 $743,328 Total Expenses $757,076 2% $278,369 $0 Net Revenue / Expenses $0 0% Total Transfers and Contingencies 125-2624 Permitting DR A F T Page 55 of 79 Actual 2021 Adopted 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $110,678 $170,025 331 6200 Annual Entitlement Grant $157,584 $157,584 42% $44,000 389 9001 C/F Carryforward from FY22 $79,890 $79,890 0% $207,513 $214,025 Total Revenue $237,474 14% Full Time Equivalent Employees 0 Total Personal Costs $23,005 $80,230 554 8302 Grants & Aide $111,737 39% $54,754 $55,790 554 5218 Public Projects $94,220 69% $32,900 $34,005 554 9000 Transfers $31,517 -7% $110,681 $170,025 Total Operating Costs $237,474 $0 $44,000 554 6300 Infrastructure Projects $0 $0 $0 0% $0 $44,000 Capital Expenses $0 0% $110,681 $214,025 Total Expenses $237,474 $96,832 $0 Net Revenue / Expenses $0 -100% 150-2854 Community Development Block Grant Account Number Capital Costs Revenues Personal Expenses Operating Expenses 150-2625-CDBG DR A F T Page 56 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $325,547 $283,741 Transfer from General Fund $285,541 $285,541 1% $325,547 $283,741 Total Revenue $285,541 1% Full Time Equivalent Employees 0 $0 $0 Total Personal Costs $0 0% $286,741 $283,741 2015 Public Imp Refunding $285,541 1% $573,482 $567,482 Total Operating Costs $285,541 -50% $0 $0 Capital Expenses $0 0% $573,482 $567,482 Total Expenses $285,541 -50% -$247,935 -$283,741 Net Revenue / Expenses $0 -100% 220-0213 Debt Service Account Number Capital Costs Operating Expenses Personal Expenses Revenues 220-0213 Debt Service DR A F T Page 57 of 79 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 312 5000 Tourist Development Tax $650,115 $650,115 0% $1,695,570 334 0000 State Grant Apropriations $1,000,000 $1,000,000 -41% $1,007,896 381 0000 Transfer from 1/2 Cent *$0 $0 -100% $150,809 381 0000 Transfer from General Fund $72,238 $72,238 -52% $1,671,796 381 0000 Transfer from Water Dept $0 $0 -100% $185,000 381 0000 Transfer from Impact Fees $0 $0 -100% $7,800,000 384 0000 SRF Loan Proceeds $3,750,000 $3,750,000 -52% $527,814 331 3000 Federal Grant - ARPA $0 $0 -100% $0 389 9001 Cash Carryforward (Impact Fees)$185,000 $185,000 0% $0 389 9001 Cash Carryforward (1/2 Cent)$395,400 $395,400 0% $0 389 9001 Cash Carryforward ARPA)$527,814 $527,814 0% $0 389 9001 Cash Carryforward $5,547,186 $5,547,186 0% $13,771,154 Total Revenues $12,127,753 -12% Full Time Equivalent Employees 0 $0 Total Personnel Expenses $0 0% $0 Total Operating Expenses $0 0% $1,307,996 522 6400 Equipment $0 -100% *Fire Training Tower 0 $1,307,996 $0 $1,395,400 541 6300 Improvements/Not buildings $1,395,400 0% *E. Redstone (Brookemeade to Okaloosa Lane) 1 $395,400 $395,400 Main Street Project 1 $1,000,000 $1,000,000 332 - Capital Improvements Account Number Revenues Personnel Expenses Operating Expenses Capital Expenses 0822 - Fire Department 1141 - Streets DR A F T Page 58 of 79 $150,809 519 6300 Improvements $722,353 379% LED Lighting Replacement 1 $21,838 $21,838 Twin Hills Tennis Cts Fence 1 $25,400 $25,400 Downtown Christmas Décor 1 $25,000 $25,000 Restricted Reserve TDT 1 $650,115 $650,115 $300,000 533 6300 Improvements $2,950,000 883% Arena Road Water Tower (Design/Construction)1 $2,750,000 $2,750,000 PJ Phase 4 relocate 1 $200,000 $200,000 $2,562,884 533 6301 Improvements $2,710,000 6% CIPP Lining Program 1 $50,000 $50,000 Low-Pressure Sewer Program 1 $25,000 $25,000 Benjamin Sewer Expansion 1 $135,000 $135,000 Manhole Lining Program 1 $50,000 $50,000 Split Creek Engineering Study 1 $50,000 $50,000 Foxwood Estates Septic to Sewer 1 $2,200,000 $2,200,000 PJ Phase 4 relocate 1 $200,000 $200,000 $5,700,000 535 6300 Improvements $4,350,000 -24% Phase 1 PD&E 1 $100,000 $100,000 Rapid Infiltration (RIB)1 $500,000 $500,000 Rib 6 Design 1 $650,000 $650,000 Rib 6 Construction 1 $3,100,000 $3,100,000 $250,000 538 6301 Improvements $0 -100% $10,359,093 Capital Expenses $12,127,753 17% $10,359,093 Total Expenses $12,127,753 17% $3,412,061 Net Revenue / Expenses $0 -100% Impact Fees Funded Project *1/2 Cent Sales Tax Funded Local Option Gas Tax 1735 - Sewer 1935 - Wastewater 2238 - Stormwater 2319 - Facilities 1633 - Water DR A F T Page 59 of 79 *Revenue Carry Forward *Debt Proceeds Grants & Aid Impact Fees From Fund Balance Restricted Funds Personnel Expenses Operating Expenses Capital Expenses Debt Contingency Transfers Total G&A 539,000$ 445,992$ -$ -$ 515,671$ -$ 333,829$ -$ 3,420,163$ (2,253,329)$ Administration -$ 668,133$ 227,797$ 354,936$ -$ (1,250,866)$ Customer Service -$ 408,650$ 93,950$ -$ -$ (502,600)$ Water 3,402,000$ 773,457$ 731,211$ 40,441$ -$ 1,856,892$ Sewer 4,787,000$ -$ 792,215$ 603,149$ 20,323$ -$ 3,371,313$ Wastewater Plant -$ -$ 1,221,409$ -$ -$ (1,221,409)$ Totals 8,728,000$ 445,992$ -$ -$ -$ 515,671$ 2,642,455$ 3,211,345$ 415,700$ 3,420,163$ 0$ Total Expenses 6,269,499$ Total operating and Capital Expenses 3,627,044$ Total Budget 20% 25% 30%9,689,663$ Reserve Calculation 1,170,760$ 1,463,450$ 1,756,140$ Contingency 10% of Operating 321,134$ + or - Excess 440 Utility Fund Summary *The revenue in this summary is based on the projections found in the proforma from the 2020 utility rate study 440-Summary Requested DR A F T Page 60 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $91,200 $85,000 324 2101 Impact Fees - Water Res $150,000 $150,000 76% $4,200 $50,000 324 2201 Impact Fees - Water Comm $25,000 $25,000 -50% $204,000 $220,000 324 2102 Impact Fees - Sewer Res $275,000 $275,000 25% $12,800 $75,000 324 2202 Impact Fees - Sewer Comm $15,000 $15,000 -80% $223,643 $300,000 343 0000 Connection Fees $350,000 $350,000 17% $192,000 $199,680 343 9000 Special Fees/ Penalties $134,000 $134,000 -33% $0 $0 343 3001 Delinquent Service Charge $28,000 $28,000 0% $0 $0 369 1000 Write Offs $17,000 $17,000 0% $25,499 $20,000 369 0000 Misc. Revenues $10,000 $10,000 -50% $0 $0 384 0000 SRF Loan Proceeds $0 $0 0% $56,608 $57,856 335 1900 1/2 Cent Sales Tax *$50,671 $50,671 -12% $1,936,085 $1,408,271 331 3000 Federal Grants - ARPA $0 $0 -100% $720,105 389 9001 Cash Carryforward $445,992 $445,992 -38% $10,124,888 $3,135,912 Total Revenues $1,500,663 -52% Full Time Equivalent Employees 0 $22,824 Total Personnel Costs $0 $8,120 $8,950 511 3400 Contractual Services $8,950 0% $397,333 $295,570 511 4500 Insurance $310,779 5% $0 $0 511 4600 Repairs & Maintenance $0 0% $304,739 $4,800 511 4900 Other Current Charges $4,800 0% $3,013 $7,500 511 4904 Collection Agency Exp $7,500 0% $0 $800 511 5100 Office Supplies $800 0% $163 $500 511 5200 Operating Supplies $500 0% $0 $500 511 5203 Advertising $500 0% $713,367 $318,620 Total Operating Expenses $333,829 5% $0 $0 511 6400 Equipment $0 0% Account Number 440-0311 General & Administrative Revenues Personnel Expenses Operating Expenses Capital Expenses 440-0311 Utility G&A DR A F T Page 61 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 440-0311 General & Administrative $0 $0 Total Capital Expenses $0 0% $440,568 $460,346 2008- State Revolving Fund $460,345 0% $58,972 $58,972 SRF 2010 $58,971 0% $456,971 $456,971 SRF 13/14 $456,970 0% $279,351 $282,986 2015 W&S Refunding $501,516 77% $389,087 $389,488 2016 W&S Refunding $169,488 -56% $56,608 $57,856 *2020 Capital Imp. Bond $50,671 -12% $0 $370,560 2021 W&S Revenue Bond Series $311,068 -16% $703 $477,229 511 9000 Transfers $465,000 -3% $112,000 $1,713,407 511 9500 Contingencies $321,134 -81% $625,000 $625,000 511 9700 Transfer to General Fund (cost allocation) $625,000 0% $0 $0 511 9900 Reserve Funds $0 0% $3,660,249 $6,509,648 $3,420,163 -47% $4,396,440 $6,828,268 Total Expenses $3,753,992 -45% $5,728,448 -$3,692,356 Net Revenue / Expenses -$2,253,329 -39% Impact Fees Funded *1/2 Cent Sales Tax Funded Debt, Contingencies and Transfers Total Debt, Contingencies & Transfers 440-0311 Utility G&A DR A F T Page 62 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Non Revenue Division $0 Total Revenues Full Time Equivalent Employees 6 $221,999 $402,774 519 1200 Regular Wages $454,742 13% $0 $7,586 Sick Leave Buy Back $6,451 -15% $11,768 $29,958 519 1201 Holiday Pay $36,871 23% $363 $2,837 519 1400 Overtime pay $0 -100% $0 $3,600 519 1500 Incentive Pay $4,800 33% $16,928 $33,960 519 2100 FICA Taxes $38,469 13% $28,215 $41,052 519 2200 Retirement Contributions $52,760 29% $38,455 $70,043 519 2300 Life & Health Insurance $58,427 -17% $6,394 $10,206 519 2400 Workers Compensation $15,612 53% $324,122 $602,016 Total Personnel Costs $668,133 11% $19,050 $50,000 519 3103 Engineering Fees $130,000 160% $0 $7,000 519 3400 Contractual Services $7,000 0% $275 $264 519 3402 Pest Control $264 0% $430 $0 519 4000 Travel and Per Diem $0 0% $5,860 $11,050 519 4100 Communications $11,050 0% $6 $300 519 4200 Postage $250 -17% $8,887 $12,700 519 4300 Utilities $12,700 0% $1,861 $4,907 519 4400 Rentals & Leases $5,827 19% $1,680 $4,353 519 4500 Insurance $7,037 62% $5,083 $6,564 519 4600 Repairs & Maintenance $6,564 0% $2,160 $2,500 519 4611 Repairs - Auto $2,500 0% Account Number 440-0510 Utility Administration Revenues Personnel Expenses Operating Expenses 440-0510 Utility Administration DR A F T Page 63 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 440-0510 Utility Administration $0 $250 519 4612 Repairs - Small Equipment $250 0% $0 $250 519 4613 Repairs - Heavy Equipment $250 0% $745 $1,850 519 5100 Office Supplies $850 -54% $8,161 $12,050 519 5200 Operating Supplies $12,050 0% $933 $1,180 519 5201 Uniforms $1,610 36% $3,337 $3,750 519 5202 Fuel $3,800 1% $497 $700 519 5203 Advertising $500 -29% $11,274 $23,795 519 5400 Dues & Subscriptions $23,795 0% $754 $1,600 519 5600 Training $1,500 -6% $70,993 $145,063 Total Operating Expenses $227,797 57% $0 $0 533 6300 Improvements $345,000 0% $0 $0 519 6401 Capital Leases $9,936 0% $0 $0 Capital Expenses $354,936 0% $395,115 $747,079 Total Expenses $1,250,866 67% -$395,115 -$747,079 Net Revenue / Expenses -$1,250,866 67% Capital Expenses 440-0510 Utility Administration DR A F T Page 64 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Non Revenue Division 0% Total Revenue 0% Full Time Equivalent Employees 7 $237,776 $239,492 513 1200 Regular Wages $257,245 7% $0 $4,358 Sick Leave Buy Back $4,711 8% $11,121 $15,274 513 1201 Holiday Pay $18,049 18% $2,882 $3,693 513 1400 Overtime pay $3,892 5% $18,207 $19,823 513 2100 FICA Taxes $21,420 8% $23,854 $24,655 513 2200 Retirement Contributions $28,421 15% $63,332 $65,795 513 2300 Life & Health Insurance $69,160 5% $2,641 $3,188 513 2400 Workers Compensation $5,751 80% $359,813 $376,278 Total Personnel Expenses $408,650 9% $0 $0 513 3400 Contractual Services $0 0% $7,745 $6,600 513 4100 Communications $6,600 0% $73,719 $72,000 513 4200 Postage $72,000 0% $2,444 $2,400 513 4300 Utilities $2,400 0% $2,069 $2,000 513 4400 Rentals & Leases $2,000 0% $806 $600 513 4500 Insurance $2,000 233% $0 $3,000 513 5100 Office Supplies $3,000 0% $2,728 $3,250 513 5200 Operating Supplies $3,250 0% $0 $700 513 5201 Uniforms $700 0% $10 $200 513 5202 Fuel $200 0% Account Number 440-1513 Customer Service Revenues Personal Expenses Operating Expenses 440-1513 Customer Service DR A F T Page 65 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e Account Number 440-1513 Customer Service $1,284 $1,300 513 5400 Dues & Subscriptions $1,300 0% $0 $500 513 5600 Training $500 0% $90,805 $92,550 Total Operating Expenses $93,950 2% $0 $0 Capital Expenses $0 0% $450,618 $468,828 Total Expenses $502,600 7% -$450,618 -$468,828 Net Revenue / Expenses -$502,600 7% 440-1513 Customer Service DR A F T Page 66 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $2,909,365 $3,314,327 343 3000 Water Revenue $3,402,000 $3,402,000 3% $2,909,365 $3,314,327 Total Revenues $3,402,000 3% Full Time Equivalent Employees 8 $377,499 $354,614 533 1200 Regular Wages $402,201 13% $0 $7,327 Sick Leave Buy Back $8,362 14% $17,020 $26,376 533 1201 Holiday Pay $32,611 24% $67,588 $53,793 533 1400 Overtime pay $61,620 15% $0 $24,000 533 1500 Incentive Pay $24,000 0% $30,540 $31,542 533 2100 FICA Taxes $35,739 13% $57,138 $52,364 533 2200 Retirement Contributions $55,328 6% $118,132 $120,806 533 2300 Life & Health Insurance $131,265 9% $13,951 $16,204 533 2400 Workers Compensation $22,331 38% $681,867 $687,026 Total Personnel Expenses $773,457 13% $109,219 $111,300 533 3400 Contractual Services $111,300 0% $4,762 $7,875 533 4100 Communications $7,875 0% $0 $900 533 4200 Postage $900 0% $219,486 $252,600 533 4300 Utilities $252,600 0% $10,066 $11,460 533 4400 Rentals & Leases $11,460 0% $31,273 $25,626 533 4500 Insurance $33,186 30% $62,364 $117,000 533 4600 Repairs & Maintenance $117,000 0% $6,105 $6,565 533 4611 Repairs - Auto $6,565 0% $286 $500 533 4612 Repairs - Small Equipment $500 0% 440-1633 Water Account Number Personnel Expenses Revenues Operating Expenses 440-1633 Water DR A F T Page 67 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 440-1633 Water Account Number $430 $6,000 533 4613 Repairs - Heavy Equipment $6,000 0% $0 $250 533 5100 Office Supplies $250 0% $112,348 $137,400 533 5200 Operating Supplies $135,074 -2% $3,475 $3,500 533 5201 Uniforms $3,500 0% $31,112 $26,000 533 5202 Fuel $37,000 42% $5,210 $4,000 533 5400 Dues & Subscriptions $4,000 0% $2,179 $1,675 533 5600 Training $4,001 139% $598,315 $712,651 Total Operating Expenses $731,211 3% $2,200,000 $0 533 6300 Improvements $0 0% $0 $113,588 533 6400 Equipment $0 -100% $16,080 $26,882 533 6401 Capital Leases $40,441 50% $2,216,080 $140,470 Capital Expenses $40,441 -71% $0 $300,000 581 9000 Transfers $0 -100% $0 $300,000 $0 -100% $3,496,262 $1,840,147 Total Expenses $1,545,108 -16% -$586,897 $1,474,180 Net Revenue / Expenses $1,856,892 26% Debt, Contingencies and Transfers Total Debt, Contingencies and Transfers Capital Expenses 440-1633 Water DR A F T Page 68 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $4,248,541 $4,359,680 343 5000 Sewer Revenue $4,787,000 $4,787,000 10% $4,248,541 $4,359,680 Total Revenues $4,787,000 $4,787,000 10% Full Time Equivalent Employees 11 $422,052 $382,294 533 1200 Regular Wages $469,084 23% $0 $4,608 Sick Leave Buy Back $5,193 13% $19,743 $28,435 533 1201 Holiday Pay $38,034 34% $15,897 $9,668 533 1400 Overtime pay $12,174 26% $0 $14,400 533 1500 Incentive Pay $15,600 8% $32,937 $32,875 533 2100 FICA Taxes $40,385 23% $56,710 $49,626 533 2200 Retirement Contributions $71,796 45% $93,306 $95,936 533 2300 Life & Health Insurance $119,207 24% $17,633 $13,254 533 2400 Workers Compensation $20,742 56% $658,278 $631,096 Total Personnel Expenses $792,215 26% $11,598 $15,904 533 3400 Contractual Services $16,500 4% $0 $0 533 4000 Travel and Per Diem $0 0% $7,727 $7,575 533 4100 Communications $7,575 0% $185,833 $204,480 533 4300 Utilities $204,480 0% $30,539 $35,000 533 4400 Rentals & Leases $38,460 10% $37,088 $38,175 533 4500 Insurance $32,800 -14% $117,933 $135,500 533 4600 Repairs & Maintenance $135,500 0% $23,080 $23,960 533 4611 Repairs - Auto $23,960 0% $163 $5,000 533 4612 Repairs - Small Equipment $5,000 0% $2,993 $22,000 533 4613 Repairs - Heavy Equipment $22,000 0% 440-1735 Sewer Account Number Revenues Personnel Expenses Operating Expenses 440-1735 Sewer DR A F T Page 69 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 440-1735 Sewer Account Number $62,323 $45,000 533 5200 Operating Supplies $45,000 0% $4,141 $3,759 533 5201 Uniforms $3,759 0% $41,522 $37,200 533 5202 Fuel $60,200 62% $2,770 $11,971 533 5600 Training $7,915 -34% $530,350 $585,524 Total Operating Expenses $603,149 3% $0 $0 533 6300 Improvements/Not buildings $0 0% $2,538,456 $0 533 6301 Improvements $0 0% $24,120 $79,250 533 6400 Equipment $0 790% $24,120 $35,866 533 6401 Vehicle Leases $20,323 -43% $2,586,696 $115,116 Capital Expenses $20,323 -82% $3,775,324 $1,331,736 Total Expenses $1,415,687 6% $473,217 $3,027,944 Net Revenue / Expenses $3,371,313 -13% * Impact Fee Funded Projects Capital Expenses 440-1735 Sewer DR A F T Page 70 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 Total Revenues Personnel Expenses Full Time Equivalent Employees 0 Total Personnel Expenses $1,102,766 $1,098,324 535 3400 Contractual Services $1,098,324 0% $0 $0 4100 Communications $7,224 0% $50,811 $38,175 535 4500 Insurance $45,861 20% $13,579 $20,000 535 4600 Repairs & Maintenance $20,000 0% $31,865 $58,000 535 5200 Operating Supplies $50,000 -14% $1,199,021 $1,214,499 Total Operating Expenses $1,221,409 1% $488,723 $0 535 6300 Improvements/Not buildings $0 0% $0 $0 535 6400 Equipment $0 0% $488,723 $0 Capital Expenses $0 0% $1,687,744 $1,214,499 Total Expenses $1,221,409 1% -$1,687,744 -$1,214,499 Net Revenue / Expenses -$1,221,409 1% Account Number 440-1935 Wastewater Treatment Plant Revenues Operating Expenses Capital Expenses 440-1935 Wastewater Plant DR A F T Page 71 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $3,999,295 $4,000,000 343 4000 Garbage Fees $4,200,000 $4,200,000 5% $61,787 $55,000 343 9000 Penalties $60,000 $60,000 9% $234,479 $208,000 343 9001 Franchise Fees $225,000 $225,000 8% $0 $0 389 9001 Cash Carry Forward $0 $0 0% $4,295,561 $4,263,000 Total Revenue $4,485,000 $4,485,000 5% Full Time Equivalent Employees 0 Total Personal Costs $3,828,524 $3,948,000 534 3400 Contractual Services $3,948,000 0% $67,516 $50,000 534 3900 Landfill Charges $50,000 0% $22,650 $5,000 534 4903 Bad Debt $5,000 0% $4,145,400 $4,003,000 Total Operating Costs $4,003,000 0% $0 $0 6400 Equipment $190,000 0% $0 $0 Total Capital Expenses $190,000 0% $0 $260,000 534 9100 Transfers $292,000 12% $0 $260,000 $292,000 0% $4,145,400 $4,263,000 Total Expenses $4,485,000 5% $0 $0 Net Revenue / Expenses $0 0% 441- 1834 Sanitation Fund Debt, Contingencies and Transfers Capital Costs Total Debt, Contingencies and Transfers Account Number Revenues Personal Expenses Operating Expenses 441-1834 Sanitation DR A F T Page 72 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $302,773 $310,000 343 70-01 Residential $330,000 $330,000 6% $85,013 $85,100 343 70-02 Commercial $90,000 $90,000 6% $0 $220,000 381 00-00 Transfer from 1/2 Cent Tax *$300,000 $300,000 36% $7,271 $18,162 381 00-00 Transfer from General Fund $41,743 $41,743 130% $395,056 $633,262 Total Revenue $761,743 Full Time Equivalent Employees 6 $136,745 $174,060 538 1200 Regular Wages $187,376 8% $0 $1,277 538 Sick Leave Buy Back $1,396 9% $6,416 $12,947 538 1201 Holiday Pay $15,193 17% $2,992 $3,550 538 1400 Overtime pay $3,853 9% $0 $2,400 Incentive Pay $2,400 0% $10,475 $14,587 538 2100 FICA Taxes $15,787 8% $18,446 $24,217 538 2200 Retirement Contributions $28,066 16% $40,303 $50,794 538 2300 Life & Health Insurance $57,354 13% $9,219 $7,494 538 2400 Workers Compensation $9,864 32% $224,596 $291,326 Total Personal Costs $321,289 0% $0 $2,500 538 3103 Engineering Fees $2,500 0% $197 $1,275 538 4100 Communications $1,275 0% $17,098 $12,633 538 4500 Insurance $13,665 8% $4,416 $12,500 538 4600 Repairs & Maintenance $12,500 0% $5,566 $6,000 538 4611 Repairs - Auto $6,000 0% $900 $0 538 4612 Repairs - Small Equipment $0 0% $13,608 $7,500 538 4613 Repairs - Heavy Equipment $7,500 0% $1,007 $5,000 538 5200 Operating Supplies $5,000 0% $1,531 $2,700 538 5201 Uniforms $2,700 0% 442-2238 Stormwater Account Number Revenues Personal Expenses Operating Expenses 442-2238 Stormwater DR A F T Page 73 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 442-2238 Stormwater Account Number $19,460 $16,980 538 5202 Fuel $29,980 77% $9,192 $40,085 538 5400 Materials $40,085 0% $0 $4,895 538 5400 Dues & Subscriptions $4,895 0% $478 $500 538 5600 Training $500 0% $73,453 $112,568 Total Operating Costs $126,600 12% $0 $0 538 6301 Improvements/Not buildings $0 0% $0 $220,000 538 6400 Equipment $300,000 36% $0 $9,369 538 6401 Capital Leases $13,854 48% $0 $229,369 Capital Expenses $313,854 37% $298,049 $633,263 Total Expenses $761,743 20% $97,007 -$1 Net Revenue / Expenses $0 -111% *Indicates 1/2 Cent Sales Tax Items Capital Costs 442-2238 Stormwater DR A F T Page 74 of 79 Actual 2021 Adopted 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $0 $0 Membership Dues 12 $48,000 $576,000 $576,000 0% $0 $0 Green Fees 12 $60,000 $720,000 $720,000 0% $0 $0 Driving Range 12 $30,000 $360,000 $360,000 0% $0 $0 Golf Shop 12 $3,700 $44,400 $44,400 0% $0 $0 Rental Clubs 12 $100 $1,200 $1,200 0% $0 $0 Event Rentals 12 $10,000 $120,000 $120,000 0% $0 Total Revenues $1,821,600 0% Full Time Equivalent Employees 1 $0 $0 1200 Regular Wages $477,700 0% $0 $0 2100 FICA Taxes $38,130 0% $0 $0 2200 Retirement Contributions $0 0% $0 $0 2300 Life & Health Insurance $8,600 0% $0 $0 2400 Workers Compensation $25,000 0% $0 $0 Total Personnel Expenses $549,430 0% $0 $0 3400 Contractual Services $58,985 0% $0 $0 4000 Travel and Per Diem $18,000 0% $0 $0 4100 Communications $13,200 0% $0 $0 4300 Utilities $80,700 0% $0 $0 4400 Rentals & Leases $207,444 0% $0 $0 4500 Insurance $70,000 0% $0 $0 4600 Repairs & Maintenance $41,100 0% $0 $0 4603 Software $5,700 0% 443 - Crestview Unlimited Account Number Revenues Personnel Expenses Operating Expenses Crestview Unlimited DR A F T Page 75 of 79 Actual 2021 Adopted 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 443 - Crestview Unlimited Account Number $0 $0 4900 Other Current Charges $28,860 0% $0 $0 5100 Office Supplies $1,200 0% $0 $0 5200 Operating Supplies $156,160 0% $0 $0 5201 Uniforms $1,750 0% $0 $0 5202 Fuel $46,400 0% $0 $0 5203 Advertising $12,000 0% $0 $0 5400 Dues & Subscriptions $832 0% $0 $0 9900 Reserve $407,007 $0 $0 Total Operating Expenses $1,149,338 0% $0 $0 6400 Equipment $0 0% $0 $0 6401 Capital Leases $122,832 0% $0 $0 Capital Expenses $122,832 0% $0 $0 $0 0% $0 $0 Total Expenses $1,821,600 0% $0 $0 Net Revenue / Expenses $0 0% Debt, Contingencies & Transfers Total Debt, Contingencies & Transfers Capital Expenses Crestview Unlimited DR A F T Page 76 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e $82,570 $89,555 County 1 $110,058 $110,058 23% $155,000 $162,395 City 1 $196,702 $196,702 21% $0 $831,677 Carry Forward 1 $927,107 $500,000 -40% $1,814 $3,000 361 0000 Interest 12 $340 $3,000 0% $0 $250,000 334 7000 State Grant Revenue 1 $250,000 $0 -100% $239,385 $1,336,627 Total Revenue $809,760 -39% Total Personal Costs $0 0% $5,000 $5,000 511 3101 Legal Fees $5,000 0% $140,000 $380,000 511 3103 Engineering Fees $0 -100% $0 $5,000 511 3200 Auditing Fees $6,000 20% $50,000 $86,000 511 3400 Contractual Services $86,000 0% $255 $2,050 511 4000 Travel and Per Diem $2,050 0% $0 $500 511 4100 Communications $650 30% $975 $3,000 511 4400 Rentals & Leases $1,500 -50% $1,540 $1,700 511 4500 Insurance $1,846 9% $0 $100 511 4700 Printing $100 0% $444 $500 511 5100 Office Supplies $750 50% $0 $1,000 511 5200 Operating Supplies $1,800 80% $0 $300 511 5201 Uniforms $300 0% $2,775 $19,500 511 5203 Advertising $30,127 54% $0 $500 511 5218 Rewards & Recognition $500 0% $1,340 $1,500 511 5400 Dues & Subscriptions $1,500 0% 670-0311 Community Redevelopment Agency Account Number Revenues Operating Expenses 670-0311 CRA DR A F T Page 77 of 79 Actual 2021 Adopted Budget 2022 Description Qu a n t i t y Unit Cost De p a r t m e n t FY2023 Department Totals % o f C h a n g e 670-0311 Community Redevelopment Agency Account Number $865 $1,000 511 5600 Training $1,000 0% $203,194 $507,650 Total Operating Costs $139,123 -73% $6,836 $507,977 512 6300 Improvements $314,637 -38% $0 $2,000 512 6400 Equipment $2,000 0% $6,836 $509,977 Capital Expenses $316,637 -38% $113,000 $300,000 512 8201 Grants $335,000 12% $39,600 $19,000 512 9000 Transfers $19,000 0% $152,600 $319,000 Total Grants & Transfers $354,000 11% $362,630 $1,336,627 Total Expenses $809,760 -39% -$123,245 $0 Net Revenue / Expenses $0 0% Grants & Transfers Capital Costs 670-0311 CRA DR A F T Page 78 of 79 39,821,474$ 63.26%62,944,890$ 9,978,421$ 15.85%(561,917)$ 1,157,584$ 1.84%(2,451,577)$ 3,750,000$ 5.96%(85,000)$ 8,237,411$ 13.09%(465,000)$ 62,944,890$ 100%(625,000)$ -$ (19,000)$ 21,654,140$ 34.40%58,737,396$ 14,861,084$ 23.61%(12,127,753)$ 16,076,559$ 25.54%(1,821,600)$ 10,353,106$ 16.45%44,788,043$ 62,944,890$ 100% Cash Carry Forward (Less General Fund G&A Transfers Out) FY 2023 Budget Reconciliation Revenues FY2022 Budget (less transfers and capital projects) General Revenue Total Budget Grants & Aide (Less 1/2 Cent Sales Tax Transfers Out) Debt Proceeds (Less Permitting Fund Transfers Out) Restricted Source Revenue (Less Utility Fund G&ATransfers Out) Debt, Contingency & Transfers (Less Utility Fund Cost Allocation xfr) (Less Water Transfer to Capital Impr) Expenses (Less CRA Fund Cost Allocation xfr) Personnel Operating (Less Capital Projects Fund) Capital Adjusted Total Budget (Less Crestview Unlimited Budget) This budget reconciliation takes into consideration how transfers between funds can increase the overall budget total for the fiscal year. When a revenue is received in one fund and transferred to another, this in turn causes a necessary increase in the budget. It also reflects the current budgeted capital projects to improve infrastructure and citywide objectives for the citizens. The adjusted budget total represents the actual expenditures, less all scheduled transfers between funds, Crestview Unlimited budget, and the Capital Projects Fund. DR A F T Page 79 of 79