Import f9d88567-d2cd-4c41-a817-70e7c9807e55
Download
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
MAYOR AND COUNCIL
=================
EXPENDITURES
____________
5200-01 OFFICE SUPPLIES 1,113 299 1,250 0 0 1,250 ____________
5202-01 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-01 FURNITURE & FIXTURES 1,381 0 0 0 0 0 ____________
5208-01 ALL OTHER SUPPLIES 97 0 0 0 0 0 ____________
5220-01 INSURANCE-BONDS 372 476 500 498 0 500 ____________
5271-01 BUSINESS TRAVEL 127 0 1,500 0 0 1,500 ____________
7186-01 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 3,090 774 3,250 498 0 3,250
REVENUE OVER/(UNDER) EXPENDITURES ( 3,090) ( 774) ( 3,250) ( 498) 0 ( 3,250)
SECRETARY/TREASURER
===================
EXPENDITURES
____________
5160-02 REGULAR MAINTENANCE 0 0 0 0 0 0 ____________
5170-02 EQUIPMENT MAINTENANCE 146 0 0 0 0 0 ____________
5185-02 DUES & MEMBERSHIPS 0 25 150 0 0 150 ____________
5200-02 OFFICE SUPPLIES 246 413 500 266 0 500 ____________
5202-02 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5208-02 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5270-02 TRAINING 0 0 1,500 1,227 0 1,500 ____________
5271-02 BUSINESS TRAVEL 0 0 1,000 0 0 1,000 ____________
6020-02 CODIFICATION OF ORDINANCES 2,429 1,295 2,500 395 0 2,500 ____________
6021-02 MINUTE BOOK PRESERVATION 0 0 3,000 0 0 3,000 ____________
6030-02 CERTIFICATION/ASSOC. EXPENSE 1,524 1,285 1,000 0 0 1,000 ____________
6400-02 CAPITAL OUTLAY 0 0 0 0 0 0 ____________
7186-02 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 4,346 3,018 9,650 1,887 0 9,650
REVENUE OVER/(UNDER) EXPENDITURES ( 4,346) ( 3,018) ( 9,650) ( 1,887) 0 ( 9,650)
CITY MANAGER
============
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 2
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
5160-03 REGULAR MAINTENANCE 0 1 0 0 0 0 ____________
5185-03 ASSOCIATION DUES 736 872 1,500 564 0 1,500 ____________
5200-03 OFFICE SUPPLIES 597 558 750 230 0 750 ____________
5202-03 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-03 FURNITURE & FIXTURES 0 0 0 1,619 0 0 ____________
5208-03 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5270-03 WORKSHOPS AND TRAINING 1,161 2,905 5,150 1,868 0 5,150 ____________
5271-03 BUSINESS TRAVEL 1,207 761 1,500 153 0 1,500 ____________
5272-03 MEETINGS 0 0 0 0 0 0 ____________
6400-03 CAPITAL OUTLAY 0 0 0 0 0 0 ____________
6430-03 MOVING ALLOWANCE 0 0 0 0 0 0 ____________
7186-03 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 3,701 5,098 8,900 4,433 0 8,900
REVENUE OVER/(UNDER) EXPENDITURES ( 3,701) ( 5,098) ( 8,900) ( 4,433) 0 ( 8,900)
PUBLIC SAFETY OTHER
===================
REVENUES
________
3380-04 EMERGENCY NOTIFY PARTICIPATI 0 0 2,500 0 0 2,500 ____________
3388-04 CRF GRANT REVENUE 182,930 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 182,930 0 2,500 0 0 2,500
EXPENDITURES
____________
5195-04 EMERGENCY NOTIFICATIONS 4,950 4,950 4,950 4,950 0 4,950 ____________
5199-04 AMBULANCE SERVICE 99,996 99,996 100,000 66,664 0 100,000 ____________
7186-04 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 104,946 104,946 104,950 71,614 0 104,950
REVENUE OVER/(UNDER) EXPENDITURES 77,984 ( 104,946) ( 102,450) ( 71,614) 0 ( 102,450)
GENERAL OPERATIONS
==================
REVENUES
________
3100-05 SALES TAX COLLECTIONS 475,075 513,379 850,000 922,705 0 850,000 ____________
3121-05 PROPERTY TAXES (M&O) 336,500 364,029 377,429 339,478 0 377,429 ____________
3122-05 DELINQUENT M&O TAXES 19,439 18,331 15,500 7,002 0 15,500 ____________
3123-05 P & I - PROPERTY TAXES (M&O) 10,961 0 0 0 0 0 ____________
3125-05 DEBT SERVICE TAX (I&S) 178,977 193,566 196,783 1,026 0 196,783 ____________
3126-05 DELINQUENT DEBT TAXES 14,725 11,748 2,500 0 0 2,500 ____________
3127-05 P & I - DEBT SERVICE TAX (I& 8,143 6,742 5,000 0 0 5,000 ____________
3129-05 OTHER REVENUES-TAX COLLECTOR 1,145 0 0 0 0 0 ____________
3130-05 PAYMENT IN LIEU OF TAXES ( 2,864) 11,924 2,500 4,739 0 2,500 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 3
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
3131-05 PAYMENT IN LIEU OF TAXES 4,579 0 0 0 0 0 ____________
3150-05 FRANCHISE TAX RECEIPTS 78,758 84,913 90,000 82,493 0 90,000 ____________
3160-05 BAD DEBT COLLECTIONS 0 0 0 0 0 0 ____________
3162-05 A/R BAD DEBT COLLECTIONS 0 0 0 0 0 0 ____________
3164-05 GRANT FROM 4A CORP 3,365 0 5,000 0 0 5,000 ____________
3165-05 GRANT FROM 4B CORP 3,365 0 5,000 0 0 5,000 ____________
3260-05 COUNTY TO CIVIL DEFENSE 0 0 0 0 0 0 ____________
3270-05 REIMB. OF SERVICES 0 0 0 20 0 0 ____________
3300-05 TOWER RENTAL 24,744 24,744 24,744 20,244 0 24,744 ____________
3310-05 INTEREST INCOME-GENERAL 553 588 550 605 0 550 ____________
3311-05 INTEREST-TDEM COVID GRANT 2 90 0 0 0 0 ____________
3312-05 INTEREST-CDBG GRANT 0 0 0 0 0 0 ____________
3330-05 MISC INCOME 1,770 571 2,000 70,891 0 2,000 ____________
3340-05 SR. CENTER GRANT REVENUE 0 0 0 0 0 0 ____________
3342-05 SR CENTER INSURANCE COLLECTE 0 0 0 0 0 0 ____________
3350-05 GENERAL SERVICES FEES (4%) 239,846 243,265 256,647 182,500 0 256,647 ____________
3360-05 A/R ADMIN. FEE-GEN.(LATE FEE 1,116 1,504 1,500 169 0 1,500 ____________
3370-05 INTERNAL FRANCHISE FEES (4%) 239,846 243,265 256,647 182,500 0 256,647 ____________
3375-05 REVENUE - FEMA ICE STORM 0 149,818 0 0 0 0 ____________
3376-05 TEMAP GRANT 0 27,687 400,000 992 0 400,000 ____________
3377-05 TDEM COVID-19 RELIEF GRANT 0 195,008 0 42,922 0 0 ____________
3381-05 OCCUPANCY TAX 32,603 0 ( 42,150) 0 0 ( 42,150) ____________
3382-05 SALES TAX FOR EDC 4A 234,320 256,690 0 0 0 0 ____________
3383-05 SALES TAX FOR EDC 4B 234,320 256,690 0 0 0 0 ____________
3384-05 MIXED BEVERAGE TAXES 5,920 12,262 10,500 13,964 0 10,500 ____________
3385-05 TRANSFER FROM UTILIT FUND 30,450 0 0 0 0 0 ____________
3387-05 COMMUNITY ENHANCEMENT 4B 0 0 0 0 0 0 ____________
3388-05 SURPLUS PROPERTY 0 36,100 0 0 0 0 ____________
3390-05 INSURANCE COLLECTED-GENERAL 18,022 12,151 9,500 0 0 9,500 ____________
3391-05 PAYPHONE COMMISSION/P. D. 0 0 0 0 0 0 ____________
3392-05 PLANNING & ZONING FEES 400 600 500 100 0 500 ____________
3393-05 REIMB. OF ELECTION EXPENSES 0 0 0 0 0 0 ____________
3394-05 ELLEN BECK KNOX MKB/FT FUND 0 0 10,000 0 0 10,000 ____________
3395-05 CREDIT CARD PROCESSING FEE 17,510 21,706 15,000 17,658 0 15,000 ____________
3397-05 CDBG GRANT PLANNING REVENUE 0 0 0 0 0 0 ____________
3400-05 AIR EVAC EMS 5,846 5,895 6,500 6,278 0 6,500 ____________
3401-05 AIR EVAC EMS-CITY FEE 650 655 650 698 0 650 ____________
3405-05 AMBULANCE 0 0 0 0 0 0 ____________
3620-05 AVAILABLE ACCOUNT 0 0 0 0 0 0 ____________
4610-05 TRANSFER IN(NO LONGER USED) 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 2,220,088 2,693,919 2,502,300 1,896,984 0 2,502,300
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 4
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
5100-05 LEGAL EXPENSE 49,973 28,739 30,000 9,034 0 30,000 ____________
5136-05 AIR EVAC EMS EXPENSE 5,793 5,648 6,000 5,397 0 6,000 ____________
5145-05 PROFESSIONAL SERVICES 29,861 2,651 15,000 1,588 0 15,000 ____________
5150-05 ELECTION EXPENSES 2,420 15,014 7,500 0 0 7,500 ____________
5151-05 ENGINEERING - GIS SYSTEM 1,500 1,125 2,500 1,125 0 2,500 ____________
5155-05 COUNTY TAX APPRAISAL 23,349 25,729 27,500 27,392 0 27,500 ____________
5160-05 SUPPLIES & MAINT./CITY HALL 9,169 10,889 7,500 8,631 0 7,500 ____________
5165-05 JANITORIAL SUPPLIES 0 0 0 0 0 0 ____________
5170-05 EQUIPMENT MAINTENANCE 201 569 250 66 0 250 ____________
5171-05 VEHICLE MAINTENANCE 1,055 805 750 653 0 750 ____________
5175-05 TOWER MAINTENANCE 890 1,089 1,000 669 0 1,000 ____________
5177-05 BUILDING MAINTENANCE 9,989 434 7,500 2,791 0 7,500 ____________
5178-05 SR CENTER BLDG MAINTENANCE 0 0 0 337 0 0 ____________
5180-05 LEGAL NOTICES 140 898 750 204 0 750 ____________
5185-05 ASSOCIATION DUES 2,361 2,615 2,500 1,533 0 2,500 ____________
5190-05 CHAMBER DUES 600 600 600 200 0 600 ____________
5191-05 CREDIT CARD CHARGES 0 275 0 1,556 0 0 ____________
5196-05 PLANNING & ZONING EXPENSES 0 0 100 0 0 100 ____________
5200-05 CITY TO THE ARK 4,000 4,000 4,000 4,000 0 4,000 ____________
5206-05 SAFETY SUPPLIES 0 295 350 0 0 350 ____________
5210-05 CHAPS-MUSEUM 2,000 2,000 2,000 2,000 0 2,000 ____________
5220-05 INSURANCE-BONDS 6,351 5,144 6,250 1,124 0 6,250 ____________
5250-05 SENIOR CENTER UTILITY BILL 8,098 7,714 7,250 4,719 0 7,250 ____________
5255-05 ANNUAL AUDIT SERVICES 0 14,385 10,000 5,388 0 10,000 ____________
5270-05 WORKSHOPS,TML MEETS 5,245 4,773 10,500 7,825 0 10,500 ____________
5311-05 COPY MACHINCE USAGE 3,139 3,390 2,500 1,591 0 2,500 ____________
5315-05 FUEL-ADMIN VEHICLE 60 305 500 411 0 500 ____________
6000-05 CERTIFICATE OF OBLIGATIONS 0 0 806 0 0 806 ____________
6010-05 ADMIN EXP.(CELL,GAS,UTILITIE 7,255 6,886 9,000 4,227 0 9,000 ____________
6012-05 SERVICE PINS, AND MEALS 983 1,711 2,000 1,725 0 2,000 ____________
6200-05 BAD DEBT WRITE OFF 0 0 0 0 0 0 ____________
6201-05 A/R BAD DEBT WRITE-OFF 0 0 0 0 0 0 ____________
6205-05 INSURANCE REPAIR 798 750 0 1,500 0 0 ____________
6206-05 ZESCH & PICKETT INS. 8,792 9,341 10,300 6,205 0 10,300 ____________
6410-05 CAPITAL OUTLAY-CITY HALL 46,405 24,954 5,000 5,204 0 5,000 ____________
6520-05 LEASE PAYMENTS-EXPLORER ( 0) 7,754 7,775 5,815 0 7,775 ____________
7105-05 SENIOR CENTER INSURANCE REPA 0 0 0 0 0 0 ____________
7170-05 OCPNCY TAX-TOURISM PROJECTS 4,000 0 ( 28,100) 0 0 ( 28,100) ____________
7171-05 OCCUPANCY TAX DUE TO CHAMBER 7,918 0 ( 14,050) 0 0 ( 14,050) ____________
7172-05 SALES TAX TO EDC 4A 253,354 256,690 212,500 230,676 0 212,500 ____________
7173-05 SALES TAX TO EDC 4B 253,355 256,690 212,500 230,676 0 212,500 ____________
7174-05 SR. CENTER INSURANCE 3,270 2,605 3,000 2,990 0 3,000 ____________
7175-05 SR. CENTER AUDIT 0 277 0 0 0 0 ____________
7177-05 MISCELLANEOUS EXPENSE 2,309 2,048 2,500 3,029 0 2,500 ____________
7178-05 SENIOR CENTER SUPPORT 24,499 28,568 24,000 16,000 0 24,000 ____________
7179-05 MEALS ON WHEELS 0 0 0 0 0 0 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 5
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
7180-05 COMPREHENSIVE PLAN PROJECT 0 75 0 0 0 0 ____________
7181-05 COMMUNITY ENHANCEMENT 0 8,759 10,000 11,115 0 10,000 ____________
7182-05 SR CENTER GRANT EXPENSE 0 0 0 0 0 0 ____________
7185-05 AVAILABLE FOR USE 1,905 96,682 0 128 0 0 ____________
7186-05 ICE STORM 2021 EXPENSES 0 107 0 0 0 0 ____________
7187-05 TEMAP GRANT EXPENSE 0 27,687 400,000 18,992 0 400,000 ____________
7500-05 TRANSFERS 0 0 0 0 0 0 ____________
8605-05 GRANT APPLICATION EXPENSE 0 0 0 0 0 0 ____________
8610-05 CDBG GRANT EXPENSE/PLANNING 0 0 0 0 0 0 ____________
8611-05 HEALTH REIMB. EXPENSE 0 0 0 0 0 0 ____________
8612-05 CDBG GRANT PLANNININ EXP CIT 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 781,036 870,669 1,010,031 626,516 0 1,010,031
REVENUE OVER/(UNDER) EXPENDITURES 1,439,051 1,823,250 1,492,269 1,270,468 0 1,492,269
TELECOMMUNICATIONS
==================
REVENUES
________
3387-06 REIMBURSEMENT FOR TELECOMM 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
5100-06 TELECOMMUNICATIONS/SALARY 0 0 0 0 0 0 ____________
5102-06 OVERTIME WAGES 0 0 0 0 0 0 ____________
5104-06 LONGEVITY PAY 0 0 0 0 0 0 ____________
5110-06 WORKERS COMP/TELECOMM. 0 0 0 0 0 0 ____________
5115-06 EMPLOYEE HEALTH/TELECOMM. 0 0 0 0 0 0 ____________
5120-06 UNEMPLOYMENT INS./TELECOMM. 0 0 0 0 0 0 ____________
5125-06 FICA & MEDICARE/TELECOMM. 0 0 0 0 0 0 ____________
5130-06 RETIREMENT BENEFITS/TELECOM. 0 0 0 0 0 0 ____________
5131-06 LIFE INS/TELECOMM. 0 0 0 0 0 0 ____________
5150-06 LEGAL SERVICES 0 0 0 0 0 0 ____________
5160-06 REGULAR MAINTENANCE-TELECOM 0 0 0 0 0 0 ____________
5170-06 EQUIPMENT MAINT. -TELECOM. 0 0 0 0 0 0 ____________
5180-06 LEGAL NOTICES 0 0 0 0 0 0 ____________
5270-06 TRAINING MATERIALS & SCHOOLS 0 0 0 0 0 0 ____________
5310-06 COPIER LEASE 0 0 0 0 0 0 ____________
6400-06 CAPITAL OUTLAY/TELECOMMUNICA 0 0 0 0 0 0 ____________
6700-06 TELEPHONE EXPENSE 0 0 0 0 0 0 ____________
6750-06 ATMOS EXPENSE 0 0 0 0 0 0 ____________
6760-06 CITY TO COUNTY 0 0 0 0 0 0 ____________
7173-06 INTERNET 0 0 0 0 0 0 ____________
7186-06 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 0 0 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 0 0 0
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 6
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
POLICE DEPARTMENT
=================
REVENUES
________
3250-07 COUNTY TO 911 DISPATCH FEE 0 0 0 0 0 0 ____________
3265-07 VOLUNTARY WITHHOLDINGS TMPA 0 0 0 0 0 0 ____________
3270-07 FEE FOR HOUSING PRISONERS 0 0 0 0 0 0 ____________
3330-07 MISC INCOME - POLICE 22 540 500 1,681 0 500 ____________
3331-07 GUN REIMBURSEMENT FROM OFFIC 0 0 0 0 0 0 ____________
3335-07 GUN REIMBURSEMENT 2,503 1,226 2,500 110 0 2,500 ____________
3340-07 ADJUDICATED 59 FORFEITURES 18,630 0 0 0 0 0 ____________
3350-07 DONATIONS TO POLICE DEPT 625 40 0 100 0 0 ____________
3380-07 SANTA ANNA DISPATCH FEE 0 0 0 0 0 0 ____________
3384-07 STEP PROGRAM REVENUE 0 0 0 0 0 0 ____________
3385-07 BODY CAMERAS FOR PD 0 0 0 0 0 0 ____________
3387-07 GOVERNMENT GRANTS 0 0 0 0 0 0 ____________
3388-07 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3394-07 HEALTH INS. REIMBURSED - P.D 0 1,174 0 0 0 0 ____________
3395-07 INSURANCE COLLECTED- POLICE 6,350 0 0 0 0 0 ____________
3396-07 LEASE PURCHASE 0 0 0 0 0 0 ____________
3397-07 LEASE PURCHASE/PHONE 0 0 0 0 0 0 ____________
3950-07 REVENUE PROCEEDS 0 250,000 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 28,130 252,980 3,000 1,891 0 3,000
EXPENDITURES
____________
5100-07 SALARIES/PD 404,632 354,748 476,595 220,680 0 476,595 ____________
5102-07 OVERTIME WAGES 69,400 66,102 52,560 39,809 0 52,560 ____________
5104-07 LONGEVITY PAY 2,449 2,240 2,143 1,408 0 2,143 ____________
5110-07 WORKERS COMP. INS./PD 10,783 15,939 14,595 9,136 0 14,595 ____________
5115-07 EMPLOYEE HEALTH INS./PD 54,008 36,518 86,215 29,459 0 86,215 ____________
5116-07 DENTAL INS (HEALTHCARE DISC) 0 180 0 0 0 0 ____________
5120-07 UNEMPLOYMENT INS./ PD 1,156 864 0 12,034 0 0 ____________
5125-07 FICA AND MEDICARE/PD 34,970 32,060 40,644 19,784 0 40,644 ____________
5130-07 RETIREMENT BENEFITS/PD 81,435 71,154 90,293 43,070 0 90,293 ____________
5131-07 LIFE INS/PD 0 0 1,010 295 0 1,010 ____________
5134-07 POLICE CONTRACT LABOR 4,400 69,572 0 54,441 0 0 ____________
5150-07 LEGAL SERVICES 17,472 3,133 5,000 896 0 5,000 ____________
5160-07 REGULAR MAINTENANCE/ p. d. 10,895 8,814 10,000 4,291 0 10,000 ____________
5161-07 FORFEITURE EXPENSES 0 23,258 0 0 0 0 ____________
5162-07 SOFTWARE MAINTENANCE SRVCS 3,480 2,739 3,480 4,380 0 3,480 ____________
5165-07 JANITORIAL SUPPLIES 51 56 500 207 0 500 ____________
5166-07 JAIL EXPENSE- PRISONER SUPPL 0 2,025 5,000 800 0 5,000 ____________
5170-07 EQUIPMENT MAINTENANCE 19,447 14,159 15,000 3,215 0 15,000 ____________
5171-07 VEHICLE MAINTENANCE 362 3,594 500 1,424 0 500 ____________
5177-07 BUILDING MAINTENANCE 1,598 3,870 3,500 28 0 3,500 ____________
5180-07 LEGAL NOTICES 0 0 50 0 0 50 ____________
5185-07 ASSOCIATION DUES 0 0 0 0 0 0 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 7
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5200-07 OFFICE SUPPLIES 0 39 100 441 0 100 ____________
5202-07 MINOR TOOLS & EQUPMENT 0 0 200 0 0 200 ____________
5203-07 AMMUNITION 0 0 0 0 0 0 ____________
5204-07 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5205-07 BODY/CAR CAMERAS 0 0 0 0 0 0 ____________
5206-07 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5208-07 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-07 INSURANCE 16,142 17,859 22,000 27,875 0 22,000 ____________
5250-07 UTILITIES - POLICE DEPT 10,445 8,711 13,000 4,599 0 13,000 ____________
5260-07 DETECTIVE EXPENSE 0 100 250 0 0 250 ____________
5270-07 TRAINING MATERIALS & SCHOOLS 687 1,591 8,000 5,254 0 8,000 ____________
5290-07 UNIFORM ALLOWANCE 3,416 3,939 5,500 1,573 0 5,500 ____________
5310-07 COPIER LEASE 2,434 0 0 584 0 0 ____________
5315-07 FUEL EXPENSE 15,595 16,470 18,000 13,181 0 18,000 ____________
5400-07 DONATIONS EXPENDED 300 724 0 0 0 0 ____________
6205-07 INSURANCE REPAIR- PD 0 0 0 0 0 0 ____________
6265-07 VOLUNTARY TMPA EXPENSE 0 0 0 0 0 0 ____________
6400-07 CAPITAL OUTLAY 52,200 293,421 8,011 5,730 0 8,011 ____________
6450-07 GUN PURCHASES TO BE REIMBURS 1,777 1,420 2,500 1,191 0 2,500 ____________
6510-07 DEBT SERVICE/ COPsyn EQUIP 0 0 0 0 0 0 ____________
6520-07 DEBT SERVICE/PHONE 0 0 0 0 0 0 ____________
6530-07 DEBT SERVICE/POLICE CARS ( 14,489) 54,174 54,174 14,489 0 54,174 ____________
6700-07 TELEPHONE EXPENSE 18,442 6,795 6,350 3,342 0 6,350 ____________
6750-07 ATMOS EXPENSE/ POLICE STATIO 668 1,018 950 937 0 950 ____________
6760-07 COUNTY DISPATCH SERVICES 107,542 99,269 100,000 57,907 0 100,000 ____________
6800-07 TOBACCO GRANT EXPENSES 0 0 0 0 0 0 ____________
7173-07 INTERNET/ P. D. 4,944 5,984 5,200 3,520 0 5,200 ____________
7174-07 P. D. RENOVATIONS 0 0 0 0 0 0 ____________
7175-07 GOVERNMENT GRANT EXPENSE 0 0 0 0 0 0 ____________
7186-07 ICE STORM 2021 EXPENSES 0 2,825 2,825 0 0 2,825 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 936,643 1,225,365 1,054,145 585,977 0 1,054,145
REVENUE OVER/(UNDER) EXPENDITURES ( 908,512) ( 972,385) ( 1,051,145) ( 584,087) 0 ( 1,051,145)
STREET MAINTENANCE
==================
REVENUES
________
3160-08 BAD DEBT COLLECTIONS 0 0 0 0 0 0 ____________
3164-08 GRANT FROM 4A CORP 2,000 0 0 0 0 0 ____________
3220-08 EQUIPMENT HIRE - STREET 0 0 0 0 0 0 ____________
3230-08 PAVING COLLECTIONS 0 0 0 0 0 0 ____________
3240-08 STREET REPAIR FEES 147,889 147,716 ( 141,000) 0 0 ( 141,000) ____________
3241-08 PENALTIES ON UTILITIES 851 679 650 634 0 650 ____________
3270-08 REIMB. OF SERVICES-STREET 54 0 75,000 0 0 75,000 ____________
3274-08 4A&4B SIDEWALK MATCH GRANTS 0 0 0 ( 20,229) 0 0 ____________
3320-08 DOWNTOWN REVITALIZATION GRAN 0 0 0 106,166 0 0 ____________
3385-08 FEMA GRANTS 0 0 0 0 0 0 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 8
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
3386-08 PRIVATE GRANT 15,000 0 0 0 0 0 ____________
3390-08 INSURANCE COLLECTED 0 5,375 0 0 0 0 ____________
3396-08 LEASE PURCHASE 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 165,794 153,771 ( 65,350) 86,571 0 ( 65,350)
EXPENDITURES
____________
5100-08 SALARIES/STREET 135,292 143,539 134,778 82,866 0 134,778 ____________
5102-08 OVERTIME WAGES 2,264 6,525 6,000 1,962 0 6,000 ____________
5104-08 LONGEVITY PAY 1,820 904 1,204 872 0 1,204 ____________
5110-08 WORKERS COMPENSATION INS./ST 4,749 10,920 7,703 5,843 0 7,703 ____________
5115-08 EMPLOYEE HEALTH/STREET 27,686 25,942 34,486 18,286 0 34,486 ____________
5116-08 DENTAL INS (HEALTHCARE DISC) 0 417 0 0 0 0 ____________
5120-08 UNEMPLOYMENT INS./STREET 584 626 0 0 0 0 ____________
5125-08 FICA AND MEDICARE/STREET 10,536 11,263 10,862 6,544 0 10,862 ____________
5130-08 RETIREMENT BENEFITS/STREET 24,246 25,676 24,422 14,951 0 24,422 ____________
5131-08 LIFE INS/STREET 0 0 290 140 0 290 ____________
5132-08 CISD CONTRACT WORK 0 0 0 0 0 0 ____________
5134-08 STREET CONTRACT LABOR 388 0 0 0 0 0 ____________
5150-08 ENGINEERING 0 0 0 1,675 0 0 ____________
5151-08 LEGAL SERVICES 1,000 0 0 63 0 0 ____________
5160-08 REGULAR MAINTENANCE 9,387 20,017 10,000 5,019 0 10,000 ____________
5165-08 JANITORIAL EXPENSE 187 0 200 0 0 200 ____________
5170-08 EQUIPMENT MAINTENANCE 13,695 10,205 15,000 9,535 0 15,000 ____________
5171-08 VEHICLE MAINTENANCE 18,602 2,873 2,500 1,920 0 2,500 ____________
5173-08 DITCH MAINTENANCE 54 3,694 7,500 0 0 7,500 ____________
5177-08 STATION 2 MAINTENANCE 1 14 250 0 0 250 ____________
5180-08 LEGAL NOTICES 0 0 50 0 0 50 ____________
5200-08 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-08 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5203-08 STREET SIGNS 0 2,645 15,000 297 0 15,000 ____________
5204-08 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-08 SAFETY SUPPLIES 0 668 750 0 0 750 ____________
5208-08 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5212-08 EDC 4A 380 STEPS MAINTENANCE 2,000 0 0 0 0 0 ____________
5220-08 INSURANCE - TML 7,304 10,349 10,350 10,317 0 10,350 ____________
5270-08 WORKSHOPS AND TRAINING 761 0 500 0 0 500 ____________
5290-08 UNIFORM EXPENSE 600 1,101 1,250 459 0 1,250 ____________
5315-08 FUEL EXPENSE / STREET 10,225 10,493 16,000 11,546 0 16,000 ____________
6010-08 INJECTION- STREET IMPROVEMEN 159,332 135,953 34,000 30,372 0 34,000 ____________
6200-08 BAD DEBT WRITE-OFF 120 83 150 15 0 150 ____________
6205-08 INSURANCE REPAIR 0 0 0 4,942 0 0 ____________
6400-08 CAPITAL OUTLAY 246,452 0 9,000 0 0 9,000 ____________
6401-08 CAPITAL IMPROVEMENT 0 0 0 0 0 0 ____________
6510-08 DEBT SERVICE/ STREET SWEEPE( 25,444) 25,444 25,444 12,722 0 25,444 ____________
6515-08 DEBT SERVICE/SOUTHSIDE BANK 0 10,846 10,846 10,846 0 10,846 ____________
6520-08 LEASE PAYMENTS-PICKUPS ( 0) 32,181 34,777 24,687 0 34,777 ____________
6620-08 CATERPILLAR LEASE 0 11,194 0 0 0 0 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 9
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
6700-08 TELEPHONE EXPENSE 937 914 1,200 435 0 1,200 ____________
6750-08 ATMOS EXPENSE 793 667 800 457 0 800 ____________
7173-08 INTERNET - STREET 112 117 140 73 0 140 ____________
7174-08 CITY MATCH DOWNTOWN REVITAL 0 0 0 0 0 0 ____________
7175-08 DOWNTOWN REVITALIZATION 243 286 75,000 75,878 0 75,000 ____________
7176-08 IN KIND FOR SIDEWALKS PROJEC 0 0 0 0 0 0 ____________
7186-08 ICE STORM 2021 EXPENSES 0 7,521 0 0 0 0 ____________
8615-08 FEMA FUNDS DE-OBLIGATED 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 653,929 513,075 490,452 332,721 0 490,452
REVENUE OVER/(UNDER) EXPENDITURES ( 488,135) ( 359,304) ( 555,802) ( 246,150) 0 ( 555,802)
HEALTH AND SANITATION
=====================
REVENUES
________
3388-09 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
5150-09 LEGAL SERVICES 0 0 0 38 0 0 ____________
5160-09 REGULAR MAINTENANCE 4,108 2,341 8,000 6,167 0 8,000 ____________
5170-09 EQUIPMENT MAINTENANCE 315 350 2,500 0 0 2,500 ____________
5171-09 VEHICLE MAINTENANCE 40 133 120 54 0 120 ____________
5180-09 LEGAL NOTICES 0 0 0 0 0 0 ____________
5185-09 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5202-09 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5206-09 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5207-09 CHEMICAL SUPPLIES 0 0 0 0 0 0 ____________
5208-09 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-09 INSURANCE - TML 557 407 450 449 0 450 ____________
5270-09 TRAINING MATERIALS & SCHOOLS 520 235 600 188 0 600 ____________
5315-09 FUEL EXPENSE / HEALTH & SANI 0 488 400 123 0 400 ____________
7186-09 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 5,540 3,954 12,070 7,018 0 12,070
REVENUE OVER/(UNDER) EXPENDITURES ( 5,540) ( 3,954) ( 12,070) ( 7,018) 0 ( 12,070)
EDC 4A & 4B
===========
REVENUES
________
3100-10 OFFICE RENT INCOME 7,500 15,000 7,500 7,500 0 7,500 ____________
3110-10 SALARY REIMBRSEMENT 31,386 87,581 96,454 81,441 0 96,454 ____________
3120-10 MAINTENANCE REIMBURSEMENT 0 0 1,500 0 0 1,500 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 38,886 102,581 105,454 88,941 0 105,454
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 10
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
5100-10 SALARIES/EDC 16,642 68,923 70,000 51,154 0 70,000 ____________
5102-10 OVERTIME 0 0 0 0 0 0 ____________
5104-10 LONGEVITY/EDC 144 188 244 240 0 244 ____________
5110-10 WORKERS COMP INS 2,024 170 225 271 0 225 ____________
5115-10 EMPLOYEE HEALTH INS 2,203 6,703 8,622 6,107 0 8,622 ____________
5120-10 UNEMPLOYMENT INSURANCE 135 144 0 0 0 0 ____________
5125-10 FICA AND MEDICARE/EDC 1,321 5,320 5,374 3,913 0 5,374 ____________
5130-10 RETIREMENT BENEFITS 4,032 11,871 12,186 8,895 0 12,186 ____________
5131-10 LIFE INS/EDC ( 9) 0 153 91 0 153 ____________
5160-10 REGULAR MAINTENANCE ( 776) 48 1,500 965 0 1,500 ____________
5208-10 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
7186-10 ICE STORM 2021 EXPENSES 0 1,077 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 25,718 94,444 98,304 71,637 0 98,304
REVENUE OVER/(UNDER) EXPENDITURES 13,167 8,137 7,150 17,304 0 7,150
FIRE DEPARTMENT
===============
REVENUES
________
3240-11 COUNTY TO FIRE DEPT. 1,600 1,600 1,600 1,200 0 1,600 ____________
3250-11 GRANT PROCEEDS 5,321 0 10,000 2,107 0 10,000 ____________
3260-11 FIRE PREVENTION DONATIONS 0 4,045 0 ( 4,045) 0 0 ____________
3265-11 VOLUNTARY WITHHOLDINGS/INT 1,365 1,560 1,500 1,390 0 1,500 ____________
3270-11 PERMIT TO BURN 10 0 0 0 0 0 ____________
3280-11 COLEMAN VOL. F.D. INC. 0 0 0 0 0 0 ____________
3330-11 MISC. INCOME FD 469 431 0 2,984 0 0 ____________
3385-11 FEMA GRANTS 0 0 0 0 0 0 ____________
3386-11 TIFMAS/IMT REIMBURSEMENT 0 0 0 24,750 0 0 ____________
3388-11 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3390-11 INSURANCE COLLECTED F.D. 27,022 5,041 0 11,715 0 0 ____________
3396-11 LEASE PURCHASE/PHONE 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 35,788 12,677 13,100 40,102 0 13,100
EXPENDITURES
____________
5100-11 SALARIES/FIRE DEPT. 232,890 237,166 237,113 192,518 0 237,113 ____________
5101-11 COVID 19 CONTACT TRACER 0 7,208 7,208 15 0 7,208 ____________
5102-11 OVERTIME WAGES 8,754 12,474 10,000 11,160 0 10,000 ____________
5103-11 OVERTIME 2 WAGES 9,736 10,694 16,545 4,384 0 16,545 ____________
5104-11 LONGEVITY PAY 1,324 1,616 2,088 1,864 0 2,088 ____________
5110-11 WORKERS' COMP. INS./FIRE DEP 6,961 11,400 9,309 7,037 0 9,309 ____________
5115-11 EMPLOYEE HEALTH INS./FIRE DE 29,816 32,012 43,108 30,535 0 43,108 ____________
5116-11 DENTAL INS (HEALTHCARE DISC) 0 156 0 0 0 0 ____________
5120-11 UNEMPLOYMENT INS./FIRE DEPT. 919 1,068 0 0 0 0 ____________
5125-11 FICA AND MEDICARE/FIRE DEPT. 19,054 21,042 20,330 15,837 0 20,330 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 11
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5130-11 RETIREMENT BENEFITS/FIRE DEP 37,322 43,400 40,235 34,657 0 40,235 ____________
5131-11 LIFE INS/FIRE DEPT. 0 0 477 263 0 477 ____________
5140-11 VOLUNTEER FIREMAN EXPENSES 2,775 3,600 3,600 2,400 0 3,600 ____________
5145-11 VOLUNTEER FIREMAN MAINTENANC 11,175 9,900 27,000 6,150 0 27,000 ____________
5150-11 VOLUNTEER WORKERS COMP. 0 536 2,254 147 0 2,254 ____________
5151-11 LEGAL SERVICES 600 463 2,000 138 0 2,000 ____________
5152-11 FIRE MANUAL & PROCEDURES 4,549 4,686 0 0 0 0 ____________
5155-11 VOLUNTEER F.D. INC. 0 0 0 0 0 0 ____________
5160-11 REGULAR MAINTENANCE 5,771 7,954 6,000 4,520 0 6,000 ____________
5165-11 JANITORIAL SUPPLIES 0 337 500 922 0 500 ____________
5170-11 EQUIPMENT MAINTENANCE 16,795 16,730 15,000 10,050 0 15,000 ____________
5171-11 VEHICLE MAINTENANCE 40 72 100 100 0 100 ____________
5177-11 BUILDING MAINTENANCE 5,397 5,615 11,186 8,093 0 11,186 ____________
5180-11 LEGAL NOTICES 0 0 50 0 0 50 ____________
5185-11 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5200-11 OFFICE SUPPLIES 0 49 100 0 0 100 ____________
5202-11 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-11 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-11 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5207-11 HAZMAT & FOAM SUPPLIES 0 0 0 0 0 0 ____________
5208-11 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-11 INSURANCE/BUILDING 5,316 4,533 4,500 4,486 0 4,500 ____________
5221-11 VEHICLE INSURANCE 5,569 13,023 13,000 12,959 0 13,000 ____________
5250-11 UTILITIES/CITY OF COLEMAN 7,025 6,635 6,200 3,848 0 6,200 ____________
5260-11 PROTECTIVE/SAFETY GEAR 3,788 3,110 5,500 252 0 5,500 ____________
5270-11 TRAINING MATERIALS AND SCHOO 9,103 8,729 10,000 5,829 0 10,000 ____________
5280-11 FIRE PREVENTION EXPENSES 0 1,911 500 ( 1,867) 0 500 ____________
5285-11 FIRE MARSHALL EXPENSE 751 286 750 165 0 750 ____________
5290-11 UNIFORM ALLOWANCE 1,812 1,511 2,200 2,119 0 2,200 ____________
5315-11 FUEL EXPSENSE / FIRE DEPT. 4,318 4,148 8,500 5,675 0 8,500 ____________
6205-11 INSURANCE REPAIR - FD 0 0 0 2,960 0 0 ____________
6400-11 CAPITAL OUTLAY 17,850 40,912 0 100 0 0 ____________
6401-11 CAPITAL IMPROVEMENT 0 4,000 0 60,298 0 0 ____________
6450-11 INTERNET SERVICE 1,051 1,135 1,860 557 0 1,860 ____________
6700-11 TELEPHONE EXPENSE 3,890 4,025 3,500 1,885 0 3,500 ____________
6750-11 ATMOS (GAS) BLDG. 1,532 2,687 1,900 2,760 0 1,900 ____________
7173-11 INTERNET - FIRE DEPT. 112 117 140 73 0 140 ____________
7174-11 F.D. PHONE IMPROVEMENT 0 0 0 0 0 0 ____________
7177-11 MISCELLANEOUS EXPENDITURE 2,762 0 0 0 0 0 ____________
7186-11 ICE STORM 2021 EXPENSES 0 12,815 0 0 0 0 ____________
8610-11 GRANT EXPENSE 0 159,203 10,000 2,105 0 10,000 ____________
8615-11 FEMA/TIFMUS EXPENSE 0 0 0 0 0 0 ____________
8950-11 FIRE PREVENTION DONATIONS EX 0 55 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 458,756 697,013 522,753 434,991 0 522,753
REVENUE OVER/(UNDER) EXPENDITURES ( 422,969) ( 684,335) ( 509,653) ( 394,889) 0 ( 509,653)
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 12
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
CITY PARKS
==========
REVENUES
________
3164-12 GRANT FROM 4A CORP 0 10,000 15,000 2,667 0 15,000 ____________
3165-12 GRANT FROM 4B CORP 0 10,883 15,000 2,667 0 15,000 ____________
3330-12 CITY PARK GRANT FUNDS 0 5,000 0 11,000 0 0 ____________
3335-12 PAVILION REVENUE 3,700 4,750 4,000 4,250 0 4,000 ____________
3340-12 HOUSE CLEAN-UP/CITY 0 0 0 0 0 0 ____________
3388-12 SURPLUS PROPERTY 0 0 0 4,500 0 0 ____________
3390-12 INSURANCE COLLECTED-PARK 0 0 0 0 0 0 ____________
3396-12 LEASE PURCHASE/MOWER 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 3,700 30,633 34,000 25,083 0 34,000
EXPENDITURES
____________
5100-12 SALARIES/CITY PARK 104,387 91,047 104,454 57,980 0 104,454 ____________
5102-12 OVERTIME WAGES 3,003 2,370 500 1,155 0 500 ____________
5104-12 LONGEVITY PAY 1,576 1,816 1,889 1,668 0 1,889 ____________
5110-12 WORKERS COMP. INSURANCE/PARK 3,082 1,924 2,724 1,988 0 2,724 ____________
5115-12 EMPLOYEE HEALTH INS./PARK 21,851 17,102 25,865 12,018 0 25,865 ____________
5116-12 DENTAL INS (HEALTHCARE DISC) 0 94 0 0 0 0 ____________
5120-12 UNEMPLOYMENT INSURANCE/PARK 432 364 0 0 0 0 ____________
5125-12 FICA AND MEDICARE/PARK 8,277 7,227 8,174 4,662 0 8,174 ____________
5130-12 RETIREMENT BENEFITS/PARK 18,896 16,165 18,431 10,585 0 18,431 ____________
5131-12 LIFE INS/PARK 0 0 227 110 0 227 ____________
5150-12 LEGAL SERVICES 0 0 0 0 0 0 ____________
5151-12 ENGINEERING 4,026 0 0 0 0 0 ____________
5160-12 REGULAR MAINTENANCE 6,332 9,416 6,000 4,585 0 6,000 ____________
5165-12 JANITORIAL EXPENSE 76 0 500 438 0 500 ____________
5170-12 EQUIPMENT MAINTENANCE 2,711 3,971 5,000 833 0 5,000 ____________
5171-12 VEHICLE MAINTENANCE 897 624 2,000 475 0 2,000 ____________
5177-12 STATION 2 MAINTENANCE 145 14 200 0 0 200 ____________
5180-12 LEGAL NOTICES 0 0 50 0 0 50 ____________
5185-12 PAVILION DEPOSIT REIMBURSEME 2,900 3,110 2,500 1,980 0 2,500 ____________
5200-12 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-12 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-12 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-12 SAFETY SUPPLIES 0 403 500 0 0 500 ____________
5207-12 WEED & PEST CONTROL SUPPLIES 0 0 0 0 0 0 ____________
5208-12 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5210-12 HOUSE CLEAN-UP EXP/CITY 0 0 0 0 0 0 ____________
5220-12 INSURANCE - TML 4,552 3,761 3,761 3,749 0 3,761 ____________
5250-12 UTILITIES 0 0 0 0 0 0 ____________
5260-12 YOUTH SUMMER PROGRAMS 0 0 0 0 0 0 ____________
5270-12 FAMILY CENTER EXP./UTILITIES 4,423 4,332 3,700 2,900 0 3,700 ____________
5290-12 UNIFORM EXPENSE 450 654 600 480 0 600 ____________
5315-12 FUEL EXPENSE / PARK 3,884 4,944 4,500 3,102 0 4,500 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 13
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
6010-12 YTH SPORTS COMPLEX UTILITIE 0 22,718 10,000 13,598 0 10,000 ____________
6205-12 INSURANCE REPAIR -PARK 0 0 0 0 0 0 ____________
6400-12 CAPITAL OUTLAY 24,295 30,000 0 19,000 0 0 ____________
6415-12 CAPITAL IMPROVEMENT 0 9,399 5,000 0 0 5,000 ____________
6510-12 DEBT SERVICE/MOWER 0 0 0 0 0 0 ____________
6520-12 LEASE PAYMENTS-PICKUP 0 8,409 8,926 6,306 0 8,926 ____________
6700-12 TELEPHONE EXPENSE 539 518 500 315 0 500 ____________
7173-12 INTERNET/PARK 112 117 150 73 0 150 ____________
7174-12 MEMORY LAKE EXPENSES 0 883 0 220 0 0 ____________
7186-12 ICE STORM 2021 EXPENSES 0 564 0 0 0 0 ____________
8610-12 GRANT EXPENSE PARK 0 20,000 20,000 0 0 20,000 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 216,848 261,947 236,151 148,221 0 236,151
REVENUE OVER/(UNDER) EXPENDITURES ( 213,148) ( 231,314) ( 202,151) ( 123,138) 0 ( 202,151)
CITY PARK POOL
==============
REVENUES
________
3180-13 SWIM POOL FEES 10,157 16,612 10,000 14,302 0 10,000 ____________
3190-13 SWIM POOL CONCESSIONS 1,187 2,972 3,000 1,761 0 3,000 ____________
3342-13 GRANT FUNDS-CITY PARK POOL 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 11,344 19,584 13,000 16,063 0 13,000
EXPENDITURES
____________
5100-13 SALARIES/POOL 7,205 16,146 14,350 6,187 0 14,350 ____________
5110-13 WORKERS COMP. INS./POOL 2,196 2,041 368 273 0 368 ____________
5115-13 EMPLOYEE HEALTH INS/POOL 0 39 0 7 0 0 ____________
5120-13 UNEMPLOYMENT INS/SWIM POOL 1 0 0 0 0 0 ____________
5125-13 FICA & MEDICARE/SWIM POOL 551 1,235 1,098 443 0 1,098 ____________
5130-13 RETIREMENT BENEFIT/POOL 0 35 0 8 0 0 ____________
5150-13 LEGAL SERVICES 0 5,684 0 0 0 0 ____________
5160-13 REGULAR MAINTENANCE 6,978 10,185 9,000 8,463 0 9,000 ____________
5170-13 EQUIPMENT MAINTENANCE 0 155 3,200 389 0 3,200 ____________
5180-13 LEGAL NOTICES 0 0 50 0 0 50 ____________
5195-13 CONCESSIONS 615 1,118 2,500 618 0 2,500 ____________
5250-13 UTILITIES 5,930 8,308 4,250 4,060 0 4,250 ____________
5270-13 SCHOOLS, WORKSHOPS 0 320 500 0 0 500 ____________
6205-13 INSURANCE REPAIR - POOL 0 0 0 0 0 0 ____________
6400-13 CAPITAL OUTLAY 0 5,008 0 0 0 0 ____________
6700-13 TELEPH0NE EXPENSE/POOL 0 0 0 0 0 0 ____________
7186-13 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 23,476 50,273 35,316 20,447 0 35,316
REVENUE OVER/(UNDER) EXPENDITURES ( 12,132) ( 30,689) ( 22,316) ( 4,384) 0 ( 22,316)
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 14
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
INSPECTIONS & PERMITS
=====================
REVENUES
________
3170-14 BLDG,ELEC,PLMBG PERMITS 12,774 18,572 15,000 10,115 0 15,000 ____________
3300-14 PROPERTY BID/HOUSE DEMO 0 2,250 0 4,167 0 0 ____________
3305-14 HOUSE DEMO SCRAP SALES 228 369 0 0 0 0 ____________
3345-14 4A&4B HOUSE DEMO GRANTS 0 0 20,000 0 0 20,000 ____________
3387-14 ECONOMIC DEV AGREEMENTS 0 2,000 0 0 0 0 ____________
3388-14 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 13,002 23,191 35,000 14,281 0 35,000
EXPENDITURES
____________
5145-14 PROFESSIONAL SERVICES 3,755 3,166 3,000 413 0 3,000 ____________
5150-14 LEGAL SERVICES 1,575 4,288 5,000 1,697 0 5,000 ____________
5155-14 SOFTWARE/GIS 3,250 3,250 3,500 3,466 0 3,500 ____________
5160-14 REGULAR MAINTENANCE 2,753 2,530 2,000 1,068 0 2,000 ____________
5170-14 EQUIPMENT MAINTENANCE 0 0 0 0 0 0 ____________
5171-14 VEHICLE MAINTENANCE 0 0 0 33 0 0 ____________
5180-14 PUBLIC NOTIFICATIONS 0 0 100 0 0 100 ____________
5181-14 LEGAL NOTICES 4,723 3,314 5,000 260 0 5,000 ____________
5185-14 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5201-14 POSTAGE & DELIVERY 0 3 500 0 0 500 ____________
5208-14 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-14 INSURANCE 806 0 850 847 0 850 ____________
5250-14 UTILITIES 0 0 0 0 0 0 ____________
5270-14 SCHOOLS, WORKSHOPS 900 213 2,500 0 0 2,500 ____________
5280-14 HOUSE DEMOLITIONS 527 1,272 20,000 507 0 20,000 ____________
5315-14 FUEL EXPENSE 1,305 3,271 1,500 1,869 0 1,500 ____________
6400-14 CAPITAL OUTLAY 0 0 0 0 0 0 ____________
6600-14 SAFETY COMMITTEE 0 0 0 0 0 0 ____________
6700-14 TELEPHONE EXPENSE 648 383 750 221 0 750 ____________
7173-14 INTERNET EXPENSE 112 117 150 73 0 150 ____________
7186-14 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 20,354 21,807 44,850 10,454 0 44,850
REVENUE OVER/(UNDER) EXPENDITURES ( 7,352) 1,384 ( 9,850) 3,827 0 ( 9,850)
ANIMAL CONTROL
==============
REVENUES
________
3160-15 POUND FEES,DOG LICENSE 371 232 300 191 0 300 ____________
3388-15 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 371 232 300 191 0 300
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 15
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
5100-15 ANIMAL CONTROL-SALARY 33,337 33,178 45,531 25,074 0 45,531 ____________
5102-15 OVERTIME WAGES 119 95 320 548 0 320 ____________
5104-15 LONGEVITY PAY 924 972 1,139 1,020 0 1,139 ____________
5110-15 WORKERS COMP/ANIMAL CONTROL 877 1,847 1,555 1,137 0 1,555 ____________
5115-15 EMPLOYEE HEALTH/ANIMAL CONTR 7,284 6,703 12,932 6,107 0 12,932 ____________
5120-15 UNEMPLOYMENT INS./ANIMAL CON 144 123 0 0 0 0 ____________
5125-15 FICA & MEDICARE/ANIMAL CONTR 2,603 2,573 3,595 2,025 0 3,595 ____________
5130-15 RETIREMENT BENEFITS/A.C. 5,969 5,797 7,059 4,611 0 7,059 ____________
5131-15 LIFE INS/ANIMAL CONTROL 0 0 86 48 0 86 ____________
5150-15 LEGAL SERVICES 0 0 0 830 0 0 ____________
5155-15 EUTHANSIA EXPENSES 1,537 1,093 1,500 1,144 0 1,500 ____________
5160-15 REGULAR MAINTENACE/ACO 1,445 1,101 1,500 782 0 1,500 ____________
5170-15 EQUIPMENT MAINTENANCE-ACO 43 202 500 113 0 500 ____________
5171-15 VEHICLE MAINTENANCE 40 72 100 54 0 100 ____________
5180-15 LEGAL NOTICES 0 0 50 0 0 50 ____________
5185-15 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5200-15 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-15 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-15 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-15 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5208-15 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5270-15 SCHOOLS & WORKSHOPS 0 0 500 0 0 500 ____________
5290-15 UNIFORMS- ACO 150 234 100 84 0 100 ____________
5315-15 FUEL EXPENSE / ANIMAL CONTRO 981 931 1,100 1,019 0 1,100 ____________
6400-15 CAPITAL OUTLAY/ACO 4,350 0 5,000 0 0 5,000 ____________
6700-15 TELEPHONE EXPENSE 345 343 750 210 0 750 ____________
6750-15 ATMOS EXPENSE/ANIMAL CONTROL 1,553 2,103 1,500 1,907 0 1,500 ____________
7173-15 INTERNET EXPENSE - A.C. 112 117 150 73 0 150 ____________
7186-15 ICE STORM 2021 EXPENSES 0 32 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 61,814 57,516 84,967 46,785 0 84,967
REVENUE OVER/(UNDER) EXPENDITURES ( 61,443) ( 57,284) ( 84,667) ( 46,594) 0 ( 84,667)
MUNICIPAL COURT
===============
REVENUES
________
3200-16 MC FINES KEPT BY CITY ( 2,229) 11,792 15,000 4,180 0 15,000 ____________
3201-16 MC FINES SPLIT WITH STATE 0 0 0 0 0 0 ____________
3210-16 MC COSTS KEPT BY CITY 6,768 11,561 7,500 4,723 0 7,500 ____________
3211-16 COURT COST TO STATE COLLECTE 12,688 14,224 15,000 6,068 0 15,000 ____________
3215-16 COURT TECHNOLOGY FEES 356 177 600 0 0 600 ____________
3220-16 BUILDING SECURITY FEE 267 133 600 0 0 600 ____________
3325-16 MC JUVENILE TRUANCY FEES 0 0 200 0 0 200 ____________
3330-16 INTEREST - COURT 3 5 20 1 0 20 ____________
3340-16 MC OMNIBASE FEES COLLECTED 260 405 500 119 0 500 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 16
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
3350-16 MC PRIVATE COLLECTION FEES 3,915 5,889 4,500 1,826 0 4,500 ____________
3360-16 MC RESTITUTION FEES COLLECTE 141 1,108 0 127 0 0 ____________
3388-16 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 22,169 45,294 43,920 17,045 0 43,920
EXPENDITURES
____________
5100-16 SALARIES/MUNICIPAL COURT 32,493 36,125 37,336 25,824 0 37,336 ____________
5102-16 OVERTIME WAGES 90 155 0 74 0 0 ____________
5104-16 LONGEVITY PAY 0 248 304 300 0 304 ____________
5110-16 WORKERS COMP. INS/MUN. CT 798 212 121 82 0 121 ____________
5115-16 EMPLOYEE HEALTH/MUN. COURT 6,252 6,952 8,622 5,313 0 8,622 ____________
5120-16 UNEMPLOYMENT INS./MUN. COURT 144 124 0 0 0 0 ____________
5125-16 FICA AND MEDICARE/MUN. COURT 2,136 2,777 2,879 2,000 0 2,879 ____________
5130-16 RETIREMENT BENEFITS/MUN. COU 4,793 6,232 6,530 4,532 0 6,530 ____________
5131-16 LIFE INS/MUNICIPAL COURT 0 0 82 38 0 82 ____________
5134-16 MUNICIPAL JUDGE CONTRACT 5,600 9,600 9,600 2,667 0 9,600 ____________
5135-16 BUILDING SECURITY EXPENSE 0 0 500 0 0 500 ____________
5145-16 PROFESSIONAL LEGAL SERVICES 1,950 3,675 3,500 4,688 0 3,500 ____________
5150-16 MC OMNIBASE EXPENSE 0 0 500 47 0 500 ____________
5152-16 MC RESTITUTION EXPENSE 100 1,112 0 0 0 0 ____________
5160-16 REGULAR MAINTENANCE 1,439 647 1,000 634 0 1,000 ____________
5162-16 SOFTWARE MAINTENANCE SRVCS 4,935 4,935 5,000 0 0 5,000 ____________
5170-16 EQUIPMENT MAINTENANCE 225 0 0 0 0 0 ____________
5180-16 COURT COSTS TO STATE 11,751 14,358 15,000 1,406 0 15,000 ____________
5181-16 LEGAL NOTICES 0 0 200 0 0 200 ____________
5182-16 COLLECTION AGENCY EXPENSE 4,205 6,452 5,100 1,484 0 5,100 ____________
5183-16 JUVENILE TRUACY COURT EXPENS 0 0 200 0 0 200 ____________
5185-16 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5186-16 REIMBURSEMENT 60 0 0 0 0 0 ____________
5190-16 CREDIT CARD CHARGES 531 221 500 154 0 500 ____________
5197-16 COURT TECHNOLOGY EXPENSE 635 0 500 0 0 500 ____________
5200-16 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-16 POSTAGE & DELIVERY 0 114 50 166 0 50 ____________
5202-16 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5208-16 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5270-16 TRAINING, WORKSHOPS 1,193 600 3,000 857 0 3,000 ____________
6400-16 CAPITAL OUTLAY 0 0 0 0 0 0 ____________
6700-16 TELEPHONE EXPENSE 1,323 1,259 1,200 673 0 1,200 ____________
7173-16 INTERNET EXPENSE 112 117 150 73 0 150 ____________
7186-16 ICE STORM 2021 EXPENSES 0 319 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 80,766 96,234 101,874 51,011 0 101,874
REVENUE OVER/(UNDER) EXPENDITURES ( 58,597) ( 50,940) ( 57,954) ( 33,966) 0 ( 57,954)
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 17
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
CEMETERY
========
REVENUES
________
3230-17 OPEN CLOSE FOR BURIALS 49,405 71,350 50,000 47,075 0 50,000 ____________
3300-17 CEMETERY PROPERTY RENT 364 900 900 400 0 900 ____________
3310-17 CEMETERY INTEREST INCOME 1,174 531 1,000 382 0 1,000 ____________
3330-17 CEMETERY MISC INCOME 50 0 250 483 0 250 ____________
3340-17 CEMETERY BEAUTIFICATION 8,453 300 300 100 0 300 ____________
3350-17 SALE OF ASSETS/CEM. LOTS ETC 12,750 32,650 15,000 11,275 0 15,000 ____________
3388-17 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 72,196 105,731 67,450 59,715 0 67,450
EXPENDITURES
____________
5100-17 SALARIES/CEMETERY 90,293 71,063 85,188 59,478 0 85,188 ____________
5102-17 OVERTIME WAGES 5,952 9,280 6,000 2,702 0 6,000 ____________
5104-17 LONGEVITY PAY 2,180 496 737 624 0 737 ____________
5110-17 WORKERS COMP. INS./CEMETERY 2,830 5,280 4,529 2,556 0 4,529 ____________
5115-17 EMPLOYEE HEALTH INS/CEMETERY 18,938 15,059 25,865 18,424 0 25,865 ____________
5116-17 DENTAL INS(HEALTHCARE DISC) 0 1 0 0 0 0 ____________
5120-17 UNEMPLOYMENT INS./CEMETERY 432 356 0 0 0 0 ____________
5125-17 FICA AND MEDICARE/CEMETERY 7,453 5,744 7,032 4,348 0 7,032 ____________
5130-17 RETIREMENT BENEFITS/CEMETERY 17,062 13,642 15,947 10,867 0 15,947 ____________
5131-17 LIFE INS/CEMETERY 0 0 186 73 0 186 ____________
5132-17 CISD CONTRACT WORK 0 0 0 0 0 0 ____________
5134-17 CONTRACT LABOR 450 900 900 600 0 900 ____________
5150-17 LEGAL SERVICES 113 0 500 0 0 500 ____________
5160-17 REGULAR MAINTENANCE 3,339 4,387 5,000 2,986 0 5,000 ____________
5170-17 EQUIPMENT MAINTENANCE 1,367 3,737 2,500 3,934 0 2,500 ____________
5171-17 VEHICLE MAINTENANCE 1,015 812 2,000 539 0 2,000 ____________
5180-17 LEGAL NOTICES 0 0 0 0 0 0 ____________
5185-17 ASSOCIATION DUES 0 0 0 0 0 0 ____________
5220-17 INSURANCE 2,103 2,931 2,931 2,922 0 2,931 ____________
5250-17 UTILITIES 554 1,776 1,500 935 0 1,500 ____________
5260-17 CEMETERY BEAUTIFICATION EXPE 16,843 1,742 200 268 0 200 ____________
5290-17 UNIFORM EXPENSE 300 945 500 830 0 500 ____________
5315-17 FUEL EXPSENSE / CEMETERY 3,378 3,988 3,500 3,264 0 3,500 ____________
6400-17 CAPITAL OUTLAY 35,746 10,700 0 0 0 0 ____________
6410-17 CAPITAL OUTLAY -CEM. ENDOWME 0 0 0 0 0 0 ____________
6415-17 CAPITAL IMPROVEMENTS 0 0 0 0 0 0 ____________
6420-17 ROAD REPAIR EXPENSE 0 0 0 0 0 0 ____________
6520-17 LEASE PAYMENTS-PICKUP ( 0) 11,650 11,340 8,052 0 11,340 ____________
6700-17 TELEPHONE EXPENSE 1,484 1,445 1,200 749 0 1,200 ____________
6750-17 ATMOS EXPENSE 683 1,389 1,200 1,465 0 1,200 ____________
7150-17 CEMETERY END. CURBING 0 0 0 41 0 0 ____________
7173-17 INTERNET-CEMETERY 0 0 0 0 0 0 ____________
7186-17 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 212,516 167,323 178,755 125,658 0 178,755
REVENUE OVER/(UNDER) EXPENDITURES ( 140,319) ( 61,591) ( 111,305) ( 65,943) 0 ( 111,305)
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 18
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
LIBRARY
=======
REVENUES
________
3160-18 COPY MACHINE REVENUE 1,558 1,612 2,000 1,274 0 2,000 ____________
3170-18 FINES, FEES, BOOKS, ETC. 264 141 500 170 0 500 ____________
3180-18 LOST ITEM REVENUE 125 40 25 0 0 25 ____________
3190-18 LAMINATION 22 31 25 34 0 25 ____________
3191-18 COMMUNITY ROOM REVENUE 2,080 1,160 1,500 1,580 0 1,500 ____________
3240-18 COUNTY TO LIBRARY 4,000 4,067 4,000 5,626 0 4,000 ____________
3310-18 INVESTMENT INCOME-LIBRARY 726 230 650 228 0 650 ____________
3320-18 MISC. INCOME 101 290 150 25 0 150 ____________
3330-18 LIBRARY/FAXES SENT 192 258 150 235 0 150 ____________
3340-18 TOCKER GRANT 0 0 0 6,463 0 0 ____________
3341-18 TEXAS BROADBAND SUBSIDY 0 0 0 0 0 0 ____________
3342-18 LONE STAR LIB. GRANT 0 0 0 0 0 0 ____________
3343-18 FRIENDS OF COLEMAN CO. FOUND 0 0 0 0 0 0 ____________
3344-18 DOLLAR GENERAL GRANT 0 0 0 0 0 0 ____________
3345-18 BTOP GRANT FUNDS REVENUE 0 0 0 0 0 0 ____________
3346-18 COLEMAN CO. FOUNDATION 0 350 0 6,996 0 0 ____________
3347-18 PEARL GRANT 0 0 0 0 0 0 ____________
3348-18 GRANT PROCEEDS 0 0 45,000 16,603 0 45,000 ____________
3349-18 TX LIB&ARC COM (IMLS-FEDERAL 174 174 0 0 0 0 ____________
3350-18 DONATIONS, UNSPECIFIED 0 0 0 0 0 0 ____________
3351-18 HANCHER LIBRARY GRANT FOUND. 6,660 0 0 0 0 0 ____________
3353-18 TX BOOK FESTIVAL GRANT 0 0 0 0 0 0 ____________
3354-18 INTER-LIBRARY POSTAGE 351 0 300 0 0 300 ____________
3360-18 SPECIFIED DONATIONS 215 376 300 265 0 300 ____________
3386-18 PRIVATE ACU CENSUS GRANT 600 0 0 0 0 0 ____________
3388-18 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3390-18 INSURANCE COLLECTED-LIBRARY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 17,068 8,728 54,600 39,499 0 54,600
EXPENDITURES
____________
5100-18 SALARIES/LIBRARY 58,779 69,419 71,760 51,312 0 71,760 ____________
5104-18 LONGEVITY PAY 2,764 2,904 3,068 2,820 0 3,068 ____________
5110-18 WORKERS COMP. INS./LIBRARY 1,892 230 293 234 0 293 ____________
5115-18 EMPLOYEE HEALTH INS./LIBRARY 14,567 13,406 17,243 12,214 0 17,243 ____________
5120-18 UNEMPLOYMENT INS./LIBRARY 368 286 0 0 0 0 ____________
5125-18 FICA AND MEDICARE/LIBRARY 3,984 5,306 5,724 4,086 0 5,724 ____________
5130-18 RETIREMENT BENEFITS/LIBRARY 8,949 10,530 10,775 7,983 0 10,775 ____________
5131-18 LIFE INS/LIBRARY 0 0 130 78 0 130 ____________
5150-18 LEGAL SERVICES 0 0 0 0 0 0 ____________
5160-18 REGULAR MAINTENANCE 4,405 4,613 4,000 4,029 0 4,000 ____________
5162-18 SOFTWARE MAINTENANCE SRVCS 0 0 500 0 0 500 ____________
5165-18 JANITORIAL EXPENSE 127 689 2,250 648 0 2,250 ____________
5170-18 EQUIPMENT MAINTENANCE 928 3,591 3,000 1,983 0 3,000 ____________
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 19
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5177-18 BUILDING MAINTENANCE 1,161 954 1,000 160 0 1,000 ____________
5180-18 LEGAL NOTICES 0 0 0 0 0 0 ____________
5185-18 ASSOCIATION DUES/LIBRARY 300 300 500 462 0 500 ____________
5186-18 COMMUNITY RM REIMBURSEMENT 1,272 800 0 1,000 0 0 ____________
5200-18 OFFICE SUPPLIES 0 0 0 94 0 0 ____________
5201-18 POSTAGE & DELIVERY 0 8 0 10 0 0 ____________
5206-18 SAFETY SUPPLIES 0 0 0 154 0 0 ____________
5208-18 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5209-18 LIBRARY EVENTS 0 0 0 558 0 0 ____________
5220-18 INSURANCE 4,685 4,920 4,920 4,904 0 4,920 ____________
5250-18 UTILITIES 10,208 12,694 11,500 8,082 0 11,500 ____________
5260-18 SUMMER READING PROGRAM 0 0 0 0 0 0 ____________
5270-18 WORKSHOPS, TRAINING 66 30 2,000 1,263 0 2,000 ____________
5310-18 COPIER RENTAL 2,578 2,909 2,500 2,184 0 2,500 ____________
5320-18 LIBRARY EXPANSION/CONSTRUCTI 0 0 0 0 0 0 ____________
6020-18 BOOKS,PERIODICALS 8,821 8,851 9,000 6,861 0 9,000 ____________
6205-18 INSURANCE REPAIR- LIBRARY 0 0 0 0 0 0 ____________
6400-18 CAPITAL OUTLAY 0 0 3,000 2,432 0 3,000 ____________
6415-18 CAPITAL IMPROVEMENTS 0 0 3,800 0 0 3,800 ____________
6700-18 TELEPHONE EXPENSES 2,497 2,727 2,250 1,957 0 2,250 ____________
7173-18 INTERNET EXPENSE 648 702 850 375 0 850 ____________
7186-18 ICE STORM 2021 EXPENSES 0 472 0 0 0 0 ____________
8609-18 COUNTY TO LIBRARY EXPENSE 3,953 3,852 4,000 4,822 0 4,000 ____________
8610-18 TOCKER GRANT EXPENSE 0 0 0 0 0 0 ____________
8612-18 PRIVATE ACU CENSUS GRANT 600 0 0 0 0 0 ____________
8617-18 COLEMAN CO. FOUNDATION EXPEN 0 350 0 6,996 0 0 ____________
8618-18 GRANT EXPENSE 0 0 45,000 16,264 0 45,000 ____________
8619-18 J FRANK DOBIE AWARD EXPENSE 0 0 0 0 0 0 ____________
8620-18 HANCHER LIBRARY GRANT EXPENS 6,660 0 0 0 0 0 ____________
8622-18 TX BOOK FESTIVAL GRANT EXPEN 0 0 0 0 0 0 ____________
8623-18 INTER-LIBRARY POSTAGE 325 0 300 0 0 300 ____________
8950-18 DONATIONS EXPENDED 0 0 1,200 0 0 1,200 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 140,537 150,540 210,563 143,965 0 210,563
REVENUE OVER/(UNDER) EXPENDITURES ( 123,469) ( 141,812) ( 155,963) ( 104,466) 0 ( 155,963)
CODE COMPLIANCE
===============
REVENUES
________
3388-19 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 20
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
5100-19 CODE COMPLIANCE SALARY 38,352 21,129 50,981 5,400 0 50,981 ____________
5102-19 OVERTIME WAGES 0 0 500 0 0 500 ____________
5104-19 LONGEVITY PAY 108 156 224 0 0 224 ____________
5110-19 WORKERS COMP/CODE COMPLIANCE 1,046 146 114 284 0 114 ____________
5115-19 EMPLOYEE HEALTH/CODECOMPLIAN 6,756 4,147 12,932 0 0 12,932 ____________
5120-19 UNEMPLOYMENT/CODE COMPLIANCE 153 142 0 0 0 0 ____________
5125-19 FICA/MEDIARE-CODE COMPLIANCE 2,865 1,558 3,955 413 0 3,955 ____________
5130-19 TMRS/CODE COMPLIANCE 6,570 3,599 7,877 944 0 7,877 ____________
5131-19 LIFE INS/CODE COMPLIANCE 0 0 97 0 0 97 ____________
5150-19 LEGAL SERVICES 988 350 2,500 0 0 2,500 ____________
5160-19 REGULAR MAINT/CODE COMPLIANC 4,993 528 2,000 306 0 2,000 ____________
5170-19 EQUIPMENT MAINTENANCE 119 0 500 0 0 500 ____________
5171-19 VEHICLE MAINTENANCE 756 474 350 423 0 350 ____________
5180-19 LEGAL NOTICES 3,803 207 1,000 0 0 1,000 ____________
5185-19 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5200-19 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-19 POSTAGE & DELIVERY 0 848 0 165 0 0 ____________
5202-19 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-19 FURNITURE & FIXTURES 0 0 1,000 0 0 1,000 ____________
5206-19 SAFETY SUPPLIES 0 139 150 0 0 150 ____________
5208-19 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5210-19 HOUSE DEMOLITION 0 0 0 0 0 0 ____________
5270-19 TRAINING MATERIALS & SCHOOLS 1,783 50 1,500 0 0 1,500 ____________
5290-19 UNIFORM ALLOWANCE 150 0 200 126 0 200 ____________
5315-19 FUEL EXPENSE-CODE COMPLIANCE 313 330 500 925 0 500 ____________
6400-19 CAPITAL OUTLAY 28,645 0 0 0 0 0 ____________
6520-19 LEASE PAYMENTS-PICKUP ( 0) 7,828 8,346 5,871 0 8,346 ____________
6700-19 TELEPHONE EXP/CODE COMPLIANC 358 343 350 170 0 350 ____________
6750-19 ATMOS EXPENSE 0 0 0 0 0 0 ____________
7173-19 INTERNET / CODE COMPLIANCE 112 117 150 73 0 150 ____________
7186-19 ICE STORM 2021 EXPENSES 0 19 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 97,870 42,109 95,226 15,102 0 95,226
REVENUE OVER/(UNDER) EXPENDITURES ( 97,870) ( 42,109) ( 95,226) ( 15,102) 0 ( 95,226)
OTHER FINANCING SOURCES
=======================
REVENUES
________
3940-96 LOANS FOR EQUIPMENT 90,910 0 0 0 0 0 ____________
3950-96 LEASES FOR EQUIPMENT 204,887 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 295,797 0 0 0 0 0
REVENUE OVER/(UNDER) EXPENDITURES 295,797 0 0 0 0 0
7-06-2022 11:21 AM CITY OF COLEMAN PAGE: 21
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
100-General Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
INTERFUND TRANSFERS
===================
REVENUES
________
4300-98 TRANSFER FROM EWS FUND 1,485,537 1,485,537 1,532,537 1,149,403 0 1,532,537 ____________
4320-98 TRANSFER FROM SOLID WASTE 0 0 30,500 22,875 0 30,500 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 1,485,537 1,485,537 1,563,037 1,172,278 0 1,563,037
EXPENDITURES
____________
9323-98 GF DEBT SERVICE TO WATER 20,374 806 19,726 14,794 0 19,726 ____________
9325-98 GF DEBT SERVICE TO SEWER 46,807 0 47,186 35,390 0 47,186 ____________
9329-98 GF DEBT SERVICE TO ELECTRIC 127,364 0 128,395 96,296 0 128,395 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 194,545 806 195,307 146,480 0 195,307
REVENUE OVER/(UNDER) EXPENDITURES 1,290,993 1,484,731 1,367,730 1,025,798 0 1,367,730
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 4,592,800 4,934,859 4,372,311 3,458,644 0 4,372,311
FUND TOTAL EXPENDITURES 4,026,431 4,366,910 4,497,514 2,845,415 0 4,497,514
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 566,369 567,949 ( 125,203) 613,229 0 ( 125,203)
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
210-Law Enforcement Standards
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
LAW ENFORCEMENT STANDARDS REV.
==============================
REVENUES
________
3310-78 INTEREST EARNED 3 3 0 0 0 0 ____________
3330-78 POLICE TRAINING GRANTS 1,814 1,727 1,000 0 0 1,000 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 1,817 1,731 1,000 0 0 1,000
REVENUE OVER/(UNDER) EXPENDITURES 1,817 1,731 1,000 0 0 1,000
LAW ENFORCEMENT STANDARDS EXP.
==============================
EXPENDITURES
____________
8610-79 LAW ENFORCEMENT STND. EXPENS 185 1,021 1,000 1,250 0 1,000 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 185 1,021 1,000 1,250 0 1,000
REVENUE OVER/(UNDER) EXPENDITURES ( 185) ( 1,021) ( 1,000) ( 1,250) 0 ( 1,000)
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 1,817 1,731 1,000 0 0 1,000
FUND TOTAL EXPENDITURES 185 1,021 1,000 1,250 0 1,000
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 1,632 710 0 ( 1,249) 0 0
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
215-Lake Coleman Law Enforcem
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
225-General Debt Service
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
TAX
===
REVENUES
________
3125-05 PROPERTY TAXES (I&S) 0 0 0 46,003 0 0 ____________
3126-05 DELINQUENT PROP TAXES (I&S) 0 0 0 4,372 0 0 ____________
3127-05 P&I DEBT SERVICE TAX (I&S) 0 0 0 2,452 0 0 ____________
3130-05 PAYMENT IN LIEU OF TAXES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 52,827 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 52,827 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 52,827 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 52,827 0 0
*** END OF REPORT ***
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
250-Occupancy Tax
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
TAX
===
REVENUES
________
3110-05 HOT - INTEREST INCOME 0 19 0 11 0 0 ____________
3381-05 OCCUPANY TAX REVENUES 0 41,879 78,150 35,624 0 78,150 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 41,898 78,150 35,635 0 78,150
EXPENDITURES
____________
7170-05 OCCPY TAX-TOURISM PROJECTS 0 30,820 52,100 22,750 0 52,100 ____________
7171-05 OCCUPANCY TAX TO CHAMBER 0 17,962 26,050 7,576 0 26,050 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 48,782 78,150 30,326 0 78,150
REVENUE OVER/(UNDER) EXPENDITURES 0 ( 6,884) 0 5,310 0 0
MISCELLANEOUS
=============
EXPENDITURES
____________
7177-95 MISC EXP 0 0 0 8 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 0 8 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 ( 8) 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 41,898 78,150 35,635 0 78,150
FUND TOTAL EXPENDITURES 0 48,782 78,150 30,333 0 78,150
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 ( 6,884) 0 5,302 0 0
*** END OF REPORT ***
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
265-Court Technology
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
270-Court Security
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
275-Street Improvement Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENSES
========
REVENUES
________
3240-08 Street Improvement Fee 0 0 282,000 111,577 0 282,000 ____________
3310-08 Investment Earnings 0 0 0 0 0 0 ____________
3620-08 General Fund Injection 0 0 34,000 25,500 0 34,000 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 316,000 137,077 0 316,000
EXPENDITURES
____________
6010-08 Materials and Supplies 0 0 175,000 58,577 0 175,000 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 175,000 58,577 0 175,000
REVENUE OVER/(UNDER) EXPENDITURES 0 0 141,000 78,501 0 141,000
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 316,000 137,077 0 316,000
FUND TOTAL EXPENDITURES 0 0 175,000 58,577 0 175,000
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 141,000 78,501 0 141,000
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
280-Cemetery Beautification
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
REVENUES
________
4300-98 TRANSFER FROM OTHER FUNDS 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
290-Fire Prevention Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
FIRE PREVENTION EXPESES
=======================
REVENUES
________
3260-11 FIRE PREVENTION DONATIONS 0 0 0 4,320 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 4,320 0 0
EXPENDITURES
____________
5280-11 FIRE PREVENTION EXPENSES 0 0 0 1,911 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 0 1,911 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 2,409 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 4,320 0 0
FUND TOTAL EXPENDITURES 0 0 0 1,911 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 2,409 0 0
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
UTILITY OFFICE
==============
REVENUES
________
3388-20 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
5125-20 FICA/MEDICARE-JANITORIAL 0 0 0 0 0 0 ____________
5145-20 PROFESSIONAL SERVICES 0 563 0 88 0 0 ____________
5150-20 LEGAL SERVICES 575 88 1,250 0 0 1,250 ____________
5151-20 ENGINEERING-GIS SYSTEM 0 0 2,250 348 0 2,250 ____________
5160-20 REGULAR MAINTENANCE 22,059 5,303 9,000 8,244 0 9,000 ____________
5162-20 SOFTWARE MAINTENANCE SRVCS 29,341 33,029 30,000 28,916 0 30,000 ____________
5165-20 JANITORIAL EXPENSE 0 0 100 112 0 100 ____________
5170-20 EQUIP. MAINT. VEHICLES 985 129 1,000 91 0 1,000 ____________
5171-20 VEHICLE MAINTENANCE 558 723 500 450 0 500 ____________
5177-20 BUILDING MAINTENANCE 1,396 0 0 1,615 0 0 ____________
5180-20 COPIER LEASE 2,292 2,576 3,500 1,891 0 3,500 ____________
5181-20 LEGAL NOTICES 0 74 100 0 0 100 ____________
5182-20 UTILITY COLLECTION FEES 2,282 1,293 2,000 931 0 2,000 ____________
5185-20 CREDIT CARD CHARGES 10,849 13,687 10,000 4,429 0 10,000 ____________
5200-20 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-20 POSTAGE & DELIVERY 0 9,893 15,000 8,417 0 15,000 ____________
5202-20 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-20 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-20 SAFETY SUPPLIES 0 250 500 0 0 500 ____________
5208-20 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-20 INSURANCE 765 2,380 2,380 2,372 0 2,380 ____________
5230-20 INCODE UPGRADES 0 0 0 0 0 0 ____________
5250-20 UTILITIES - CITY HALL 6,908 8,792 7,200 5,651 0 7,200 ____________
5270-20 SCHOOLS,WORKSHOPS 0 0 2,000 0 0 2,000 ____________
5290-20 UNIFORM EXPENSE 673 1,100 1,000 650 0 1,000 ____________
5315-20 VEHICLE FUEL 1,987 2,547 2,500 2,320 0 2,500 ____________
6000-20 INTEREST EXPENSE 0 0 0 0 0 0 ____________
6012-20 SERVICE PINS/MEALS 0 0 0 0 0 0 ____________
6400-20 CAPITAL OUTLAY 2,700 5,666 0 3,200 0 0 ____________
6402-20 ELECTRIC METER EXPENSE 2,375 2,599 2,600 2,565 0 2,600 ____________
6500-20 DEPRECIATION 6,464 0 0 0 0 0 ____________
6520-20 LEASE PAYMENT-PICKUP ( 224) 7,760 8,311 5,820 0 8,311 ____________
6700-20 TELEPHONE - CITY HALL 3,400 2,931 6,000 1,838 0 6,000 ____________
6750-20 ATMOS GAS 0 0 0 0 0 0 ____________
7173-20 INTERNET - CITY HALL 337 351 440 219 0 440 ____________
7177-20 MISCELLANEOUS ( 544) 1,021 275 0 0 275 ____________
7180-20 COMPREHENSIVE PLAN 0 0 0 0 0 0 ____________
7186-20 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
7500-20 AVAILABLE ACCOUNT 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 95,177 102,753 107,906 80,168 0 107,906
REVENUE OVER/(UNDER) EXPENDITURES ( 95,177) ( 102,753) ( 107,906) ( 80,168) 0 ( 107,906)
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 2
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
UTILITY SHOP
============
REVENUES
________
3388-22 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
5150-22 LEGAL SERVICES 238 0 0 0 0 0 ____________
5160-22 REGULAR MAINTENANCE 1,608 2,128 2,500 1,703 0 2,500 ____________
5170-22 EQUIPMENT MAINTENANCE 1,437 2,422 3,100 349 0 3,100 ____________
5171-22 VEHICLE MAINTENANCE 40 14 75 8 0 75 ____________
5176-22 PARTS-ALL UNITS 5,830 4,874 6,500 4,310 0 6,500 ____________
5177-22 BUILDING MAINTENANCE 30 246 2,000 82 0 2,000 ____________
5180-22 LEGAL NOTICES 0 0 50 0 0 50 ____________
5220-22 INSURANCE 2,496 2,733 2,733 2,724 0 2,733 ____________
5230-22 RAG SERVICE 539 453 500 327 0 500 ____________
5240-22 LONG DISTANCE TELEPHONE 0 0 0 0 0 0 ____________
5290-22 UNIFORM EXPENSE 150 867 600 1,035 0 600 ____________
5315-22 FUEL EXPENSE 628 1,248 1,200 1,853 0 1,200 ____________
6400-22 CAPITAL OUTLAY 0 0 0 0 0 0 ____________
6500-22 DEPRECIATION 0 0 0 0 0 0 ____________
6520-22 LEASE PAYMENT-PICKUPS 0 0 0 0 0 0 ____________
6750-22 ELECTRIC/SHOP & CAR WASH 5,189 4,951 4,800 2,964 0 4,800 ____________
6755-22 ATMOS/ GAS-SHOP & CAR WASH 1,121 1,753 2,400 1,803 0 2,400 ____________
6760-22 TELEPHONE/SHOP 400 367 700 216 0 700 ____________
7173-22 INTERNET EXPENSE 112 117 142 73 0 142 ____________
7186-22 ICE STORM 2021 EXPENSES 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 19,819 22,172 27,300 17,446 0 27,300
REVENUE OVER/(UNDER) EXPENDITURES ( 19,819) ( 22,172) ( 27,300) ( 17,446) 0 ( 27,300)
WATER REVENUE
=============
REVENUES
________
3100-23 AMP REVENUE ( 16,369) 4,135 45,000 9,208 0 45,000 ____________
3110-23 WATER BILLED 1,861,513 1,987,002 2,005,564 1,500,917 0 2,005,564 ____________
3116-23 COLEMAN S.U.D. WATER BILLED 99,784 97,398 88,000 21,166 0 88,000 ____________
3117-23 WATER PLANT/USDA LOAN 0 0 0 0 0 0 ____________
3118-23 LAKE RAW WATER SALES 56,603 30,039 30,000 11,912 0 30,000 ____________
3120-23 WASTEWATER REUSE WATER 361 270 210 209 0 210 ____________
3125-23 WATER TAPS 1,900 3,450 3,500 3,950 0 3,500 ____________
3150-23 LAW ENF. CENTER PROJ./WTR 0 0 0 0 0 0 ____________
3190-23 WATER TOWER IMPROVEMENTS 0 0 0 0 0 0 ____________
3250-23 GRANT PROCEEDS 14,256 0 0 0 0 0 ____________
3388-23 SURPLUS PROPERTY 0 75,677 0 0 0 0 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 3
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
3390-23 INSURANCE COLLECTED-WATER 0 0 0 0 0 0 ____________
3396-23 LEASE PURCHASE/PHONE 0 0 0 0 0 0 ____________
3410-23 MISC INCOME 2,962 20,483 2,500 947 0 2,500 ____________
3430-23 REIMB. OF SERVICES/WATER 0 0 0 0 0 0 ____________
3510-23 INTEREST INCOME 942 279 750 244 0 750 ____________
3612-23 PROCEEDS FROM 2008 C. O. 0 0 0 0 0 0 ____________
3620-23 TRANSFER CASH RESERVES 0 0 0 0 0 0 ____________
3625-23 CAPITAL DEVELOPMENT FUND 0 0 0 0 0 0 ____________
3630-23 HORDS CREEK PHASE I 0 0 0 0 0 0 ____________
3635-23 HORDS CREEK PHASE II 0 0 0 0 0 0 ____________
3640-23 TRANSFER IN / TWBD 0 0 0 0 0 0 ____________
3641-23 TRANSFER IN USDA-CONST. RES. 0 0 0 0 0 0 ____________
3642-23 USDA ENG 0 0 0 0 0 0 ____________
3643-23 2019-19A C/O PROCEEDS-USDA ( 0) 2,522,000 1,000,000 867,000 0 1,000,000 ____________
3950-23 LEASE FOR PICKUP TRUCKS 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 2,021,950 4,740,733 3,175,524 2,415,552 0 3,175,524
REVENUE OVER/(UNDER) EXPENDITURES 2,021,950 4,740,733 3,175,524 2,415,552 0 3,175,524
SEWER REVENUE
=============
REVENUES
________
3110-25 SEWER BILLED 686,889 689,478 726,485 528,032 0 726,485 ____________
3125-25 SEWER TAPS 1,575 1,550 1,500 3,100 0 1,500 ____________
3150-25 LAW ENF. CENTER PROJ./SEW 0 0 0 0 0 0 ____________
3300-25 SEWER FARM RENT 6,414 2,755 3,536 4,965 0 3,536 ____________
3388-25 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3390-25 INSURANCE COLLECTED-SEWER 1,491 0 0 0 0 0 ____________
3396-25 LEASE PURCHASE/PHONE 0 0 0 0 0 0 ____________
3410-25 MISC. INCOME-SEWER 0 8,821 1,500 0 0 1,500 ____________
3510-25 INTEREST INCOME 262 75 300 100 0 300 ____________
3625-25 CAPITAL DEVELOPMENT FUND-SWR 0 0 0 0 0 0 ____________
3950-25 LEASE FOR PICKUP TRUCKS ( 0) 0 0 0 0 0 ____________
3951-25 LOAN FOR CAT BACKHOE 0 0 250,000 0 0 250,000 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 696,632 702,678 983,321 536,197 0 983,321
REVENUE OVER/(UNDER) EXPENDITURES 696,632 702,678 983,321 536,197 0 983,321
ELECTRICITY REVENUE
===================
REVENUES
________
3100-29 ELECTRICITY BILLED 2,655,139 2,606,946 2,801,600 1,937,912 0 2,801,600 ____________
3110-29 POWER COST RECOVERY FEE 1,454,100 1,597,123 1,667,063 1,070,358 0 1,667,063 ____________
3115-29 DEMAND/INDUSTRIAL RATE 128,769 112,264 130,000 80,670 0 130,000 ____________
3120-29 LAKE COLEMAN ELEC HOOK-UP 0 0 0 0 0 0 ____________
3130-29 TSF FEES-SERVICE CHGES 29,010 27,454 25,000 20,795 0 25,000 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 4
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
3135-29 LEGAL FEES - EDC 0 0 0 0 0 0 ____________
3137-29 ENGINEERING FEES - EDC 0 0 0 0 0 0 ____________
3140-29 PENALTIES ON UTILITIES 74,038 55,886 65,000 45,769 0 65,000 ____________
3160-29 BAD DEBT COLLECTIONS 632 219 0 ( 2) 0 0 ____________
3161-29 BAD DEBT COLLECTION FEE - 3 2,186 1,103 2,000 1,305 0 2,000 ____________
3162-29 A/R BAD DEBT COLLECTIONS 0 0 0 0 0 0 ____________
3170-29 SALE OF ASSETS 17,501 0 0 0 0 0 ____________
3220-29 EQUIPMENT HIRE-LIGHTS 0 0 0 0 0 0 ____________
3264-29 GRANT FROM 4A CORP 0 0 0 0 0 0 ____________
3388-29 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3395-29 INSURANCE COLLECTED-LIGHTS 0 0 0 0 0 0 ____________
3396-29 LEASE PURCHASE/PHONE/MOWER 0 0 0 0 0 0 ____________
3397-29 LEASE PURCHASE/ OCR 0 0 0 0 0 0 ____________
3410-29 MISC INCOME 5,949 19,721 15,000 9,689 0 15,000 ____________
3415-29 LIGHT PLANT CASH PERFORMANCE 0 0 0 0 0 0 ____________
3420-29 LIGHT PLANT PENALTY 0 0 0 0 0 0 ____________
3510-29 INTEREST INCOME 17,530 2,103 20,000 4,030 0 20,000 ____________
3610-29 A/R ADMIN. FEE-LWS 3 145 250 0 0 250 ____________
3612-29 PROCEEDS FROM 2010 C.O. 0 0 0 0 0 0 ____________
3630-29 CDBG GRANT MASTER PLANNING R 0 0 0 0 0 0 ____________
3645-29 GOVERNMENT CAPITAL LOAN 0 0 0 0 0 0 ____________
3950-29 LEASE FOR PICKUP TRUCKS 0 0 0 0 0 0 ____________
3955-29 DEBT FOR EQUIPMENT ( 0) 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 4,384,858 4,422,963 4,725,913 3,170,524 0 4,725,913
REVENUE OVER/(UNDER) EXPENDITURES 4,384,858 4,422,963 4,725,913 3,170,524 0 4,725,913
ELECTRICITY ACQUISITION
=======================
EXPENDITURES
____________
5144-30 LEGAL SERVICES 0 0 2,000 611 0 2,000 ____________
5145-30 PROFESSIONAL SERVICES 0 0 2,000 0 0 2,000 ____________
5150-30 ENGINEERING 0 25,000 0 0 0 0 ____________
5160-30 REGULAR MAINTENANCE 31,874 21,809 35,000 2,697 0 35,000 ____________
5180-30 LEGAL NOTICES 0 0 0 0 0 0 ____________
5210-30 HAZARDOUS WASTE 0 0 0 0 0 0 ____________
5220-30 INSURANCE 0 0 0 0 0 0 ____________
6000-30 INTEREST ON BONDED DEBT 0 0 0 0 0 0 ____________
6010-30 POWER PURCHASED-CONSTELLATIO 1,540,890 1,663,317 1,596,500 1,033,829 0 1,596,500 ____________
6060-30 NO LONGER USED 0 0 0 0 0 0 ____________
6201-30 A/R BAD DEBT WRITE-OFF 0 0 0 0 0 0 ____________
6205-30 ZESCH & PICKETT INS. 9,590 10,091 9,000 7,364 0 9,000 ____________
6310-30 INTERNAL FRANCHISE FEE (4%) 106,206 104,278 112,064 75,378 0 112,064 ____________
6320-30 GENERAL SERVICES FEE (4%) 106,206 104,278 112,064 75,378 0 112,064 ____________
6600-30 CERT. OF OBLIG. 2010 PRINCIP 0 0 0 0 0 0 ____________
6650-30 CERT OF OBLIG. 2010 INTERES 0 0 0 0 0 0 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 5
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
6675-30 PRINCIPAL2013(NO LONGER USED 0 0 0 0 0 0 ____________
7500-30 TRANSFERS(NO LONGER USED) ( 516) 0 0 25,703 0 0 ____________
7525-30 MISC. EXPENSES 0 0 0 0 0 0 ____________
7535-30 WIRE CHARGE/FUEL DISTRIBUTIO 68,508 68,508 68,508 45,672 0 68,508 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 1,862,757 1,997,281 1,937,136 1,266,633 0 1,937,136
REVENUE OVER/(UNDER) EXPENDITURES ( 1,862,757) ( 1,997,281) ( 1,937,136) ( 1,266,633) 0 ( 1,937,136)
ELECTRICITY DISTRIBUTION
========================
REVENUES
________
3388-31 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
5100-31 SALARIES/LT. DIST. 161,292 187,604 258,440 141,674 0 258,440 ____________
5102-31 OVERTIME WAGES 18,443 20,214 15,000 9,445 0 15,000 ____________
5103-31 STAND-BY PAY 26,316 25,516 17,500 22,974 0 17,500 ____________
5104-31 LONGEVITY PAY 1,356 1,776 2,289 1,948 0 2,289 ____________
5110-31 WORKERS COMP. INS./LT. DIST. 3,036 5,898 7,746 5,603 0 7,746 ____________
5115-31 EMPLOYEE HEALTH INS. 21,338 21,577 51,729 20,887 0 51,729 ____________
5116-31 DENTAL INS (HEALTHCARE DISC) 0 402 0 0 0 0 ____________
5120-31 UNEMPLOYMENT INSURANCE/LT. D 576 432 0 0 0 0 ____________
5125-31 FICA & MEDICARE/LT. DIST. 16,141 18,334 22,432 13,342 0 22,432 ____________
5130-31 RETIREMENT BENEFITS/LT. DIST 43,312 40,715 50,868 30,455 0 50,868 ____________
5131-31 LIFE INS/ LT. DIST. 0 0 562 207 0 562 ____________
5145-31 LEGAL SERVICES 800 1,175 5,000 400 0 5,000 ____________
5151-31 ENGINEERING - GIS SYSTEM 1,350 1,350 1,350 1,350 0 1,350 ____________
5160-31 REGULAR MAINTENANCE 26,620 52,009 45,000 21,549 0 45,000 ____________
5165-31 JANITORIAL SUPPLIES 0 0 0 0 0 0 ____________
5170-31 EQUIPMENT MAINTENANCE 24,323 14,003 20,000 6,439 0 20,000 ____________
5171-31 VEHICLE MAINTENANCE 46 81 75 141 0 75 ____________
5179-31 ELECTRIC SYSTEM MAINTENANCE 52,000 87,729 55,000 31,675 0 55,000 ____________
5180-31 LEGAL NOTICES 0 0 0 0 0 0 ____________
5200-31 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-31 MINOR TOOLS & EQUIPMENT 0 0 0 25,717 0 0 ____________
5204-31 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-31 SAFETY SUPPLIES 0 403 500 0 0 500 ____________
5208-31 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-31 INSURANCE 2,815 9,933 10,000 9,968 0 10,000 ____________
5250-31 UTILITIES 1,954 2,016 1,500 2,819 0 1,500 ____________
5260-31 PROTECTIVE/SAFETY GEAR/TESTI 217 5,797 5,000 0 0 5,000 ____________
5270-31 SCHOOLS/WORKSHOPS 10,121 6,794 17,500 7,454 0 17,500 ____________
5290-31 UNIFORM EXPENSE 1,109 1,929 2,500 990 0 2,500 ____________
5315-31 FUEL EXPENSE 4,031 6,512 7,500 4,910 0 7,500 ____________
6000-31 INTEREST ON BONDED DEBT 2,316 3,489 1,173 0 0 1,173 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 6
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
6100-31 LAW ENF. CENTER PROJ. EXP/EL 0 0 0 0 0 0 ____________
6200-31 BAD DEBT WRITE-OFF 10,869 7,221 11,275 3,934 0 11,275 ____________
6210-31 BAD DEBT WRITE-OFF 0 0 0 0 0 0 ____________
6211-31 CDBG PLANNING GRANT 0 0 0 0 0 0 ____________
6220-31 BAD DEBT WRITE-OFF 0 0 0 0 0 0 ____________
6400-31 CAPITAL OUTLAY 16,193 874,755 0 26,091 0 0 ____________
6401-31 HEAVY EQUIP-GOV CAP LOAN 0 0 0 0 0 0 ____________
6402-31 ELECTRIC METER EXPENSE 2,386 0 0 0 0 0 ____________
6403-31 CCMC HOSPITAL EXPANSION 0 0 0 0 0 0 ____________
6404-31 CCMC - CLINIC EXPANSION 0 0 0 14,370 0 0 ____________
6415-31 CAPITAL IMPROVEMENTS 88 0 50,000 0 0 50,000 ____________
6500-31 DEPRECIATION 557,458 0 0 0 0 0 ____________
6515-31 DEBT SERVICE/SOUTHSIDE BANK 0 134,210 134,210 134,210 0 134,210 ____________
6516-31 DEBT SERVICE/OCR 0 0 0 0 0 0 ____________
6675-31 PRINCIPAL-2013 GO REFUND BON 0 124,906 128,193 0 0 128,193 ____________
6700-31 TELEPHONE EXPENSE 2,201 2,329 2,000 1,064 0 2,000 ____________
6750-31 ATMOS/GAS 0 279 400 511 0 400 ____________
7173-31 INTERNET-LT. DIST. 0 299 500 453 0 500 ____________
7186-31 ICE STORM 2021 EXPENSES 0 6,004 0 0 0 0 ____________
7525-31 MISCELLANEOUS EXPENSE 0 0 0 0 0 0 ____________
8610-31 CDBG PLANNING GRANT EXP. 0 0 0 0 0 0 ____________
8611-31 CITY CDBG PLANNING GRANT EXP 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 1,008,707 1,665,690 925,242 540,581 0 925,242
REVENUE OVER/(UNDER) EXPENDITURES ( 1,008,707) ( 1,665,690) ( 925,242) ( 540,581) 0 ( 925,242)
WATER PRODUCTION
================
REVENUES
________
3388-40 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
5100-40 SALARIES/WATER PROD. 148,954 173,106 167,757 119,744 0 167,757 ____________
5102-40 OVERTIME WAGES 3,346 2,021 2,000 18,642 0 2,000 ____________
5104-40 LONGEVITY PAY 2,088 2,504 2,873 2,748 0 2,873 ____________
5110-40 WORKERS COMP. INS./WTR. PROD 3,726 7,586 5,666 5,634 0 5,666 ____________
5115-40 EMPLOYEE HEALTH/WTR PROD. 30,141 33,315 43,108 27,731 0 43,108 ____________
5116-40 DENTAL INS (HEALTHCARE DISC) 0 178 0 0 0 0 ____________
5120-40 UNEMPLOYMENT INS./WTR PROD. 660 780 0 0 0 0 ____________
5125-40 FICA AND MEDICARE/WTR. PROD. 11,503 13,708 13,206 10,612 0 13,206 ____________
5130-40 RETIREMENT BENEFITS/WTR. PRO 36,950 30,951 29,427 24,422 0 29,427 ____________
5131-40 LIFE INS/WATER PROD. 0 0 360 203 0 360 ____________
5140-40 LEGAL SERVICES 0 0 0 63 0 0 ____________
5145-40 PROFESSIONAL SERVICES 1,900 4,100 3,500 3,586 0 3,500 ____________
5150-40 ENGINEERING 200 0 0 240 0 0 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 7
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5151-40 ENGINEERING FEE USDA 0 0 0 0 0 0 ____________
5152-40 ACCOUNT AVAILABLE 0 0 0 0 0 0 ____________
5160-40 REGULAR MAINTENANCE 111,232 144,440 100,000 119,005 0 100,000 ____________
5165-40 JANITORIAL SUPPLIES 0 0 0 484 0 0 ____________
5170-40 EQUIPMENT MAINTENANCE 25,847 17,968 4,000 7,055 0 4,000 ____________
5171-40 VEHICLE MAINTENANCE 258 592 500 541 0 500 ____________
5180-40 LEGAL NOTICES 0 0 0 0 0 0 ____________
5200-40 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-40 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-40 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-40 SAFETY SUPPLIES 0 551 500 0 0 500 ____________
5207-40 CHEMICAL SUPPLIES 0 0 0 0 0 0 ____________
5208-40 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-40 INSURANCE 23,696 24,062 25,000 24,921 0 25,000 ____________
5226-40 LAB TESTING 0 0 0 0 0 0 ____________
5230-40 PERMITS 13,576 1,733 15,000 1,733 0 15,000 ____________
5270-40 SCHOOLS & WORKSHOPS 4,104 5,347 5,000 519 0 5,000 ____________
5290-40 UNIFORM EXPENSE 750 1,354 1,200 580 0 1,200 ____________
5315-40 FUEL EXPENSE 1,586 2,214 1,700 1,639 0 1,700 ____________
6000-40 INTEREST ON BONDED DEBT 51,923 43,366 137,274 0 0 137,274 ____________
6010-40 POWER FOR PUMPING WTR 48,181 47,126 50,000 42,301 0 50,000 ____________
6205-40 INSURANCE REPAIR 0 0 0 0 0 0 ____________
6310-40 INTERNAL FRANCHISE FEE (4%) 74,354 79,480 80,223 61,333 0 80,223 ____________
6320-40 GENERAL SERVICES FEE (4%) 74,354 79,480 80,223 61,333 0 80,223 ____________
6400-40 CAPITAL OUTLAY 0 0 0 0 0 0 ____________
6415-40 CAPITAL IMPROVEMENT 0 0 0 0 0 0 ____________
6500-40 DEPRECIATION 36,145 0 0 0 0 0 ____________
6520-40 LEASE PAYMENT-PICKUP 164 8,879 9,426 6,624 0 9,426 ____________
6660-40 2019-19A COs PRINCIPAL 0 178,000 181,000 208,946 0 181,000 ____________
6675-40 PRINCIPAL 2001 C0'S 0 0 0 0 0 0 ____________
6700-40 TELEPHONE EXPENSE 1,347 1,302 1,250 805 0 1,250 ____________
6750-40 ATMOS EXPENSE 838 1,043 1,200 828 0 1,200 ____________
6770-40 2008 C.O. EXPENSES/HORDS CRE 0 0 0 0 0 0 ____________
7173-40 INTERNET-WATER PROD. 112 117 142 73 0 142 ____________
7186-40 ICE STORM 2021 EXPENSES 0 18,897 0 0 0 0 ____________
7530-40 ACCOUNT AVAILABLE 0 0 0 0 0 0 ____________
7535-40 2019 WTP IMPROVEMENTS USDA ( 1,316,973) 2,084,526 1,000,000 862,816 0 1,000,000 ____________
7536-40 2019 & 19A CLOSING COSTS ( 50,000) 0 0 0 0 0 ____________
7900-40 DISPOSITION LOSS-WATERASSETS 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES ( 659,038) 3,008,726 1,961,535 1,615,159 0 1,961,535
REVENUE OVER/(UNDER) EXPENDITURES 659,038 ( 3,008,726) ( 1,961,535) ( 1,615,159) 0 ( 1,961,535)
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 8
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
WATER DISTRIBUTION
==================
REVENUES
________
3388-41 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3389-41 CLFRF EXPENSE 0 0 ( 250,000) 0 0 ( 250,000) ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 ( 250,000) 0 0 ( 250,000)
EXPENDITURES
____________
5100-41 SALARIES/WTR. DIST. 128,994 129,276 140,548 102,444 0 140,548 ____________
5102-41 OVERTIME WAGES 10,619 11,570 6,600 5,938 0 6,600 ____________
5103-41 STAND-BY PAY 11,584 11,553 10,380 5,623 0 10,380 ____________
5104-41 LONGEVITY PAY 2,056 2,020 2,295 2,164 0 2,295 ____________
5110-41 WORKERS COMP. INS. 4,261 7,307 5,246 5,403 0 5,246 ____________
5115-41 EMPLOYEE HEALTH INS. 34,388 24,958 34,486 22,601 0 34,486 ____________
5116-41 DENTAL INS (HEALTHCARE DISC) 0 166 0 0 0 0 ____________
5120-41 UNEMPLOYMENT INSURANCE 591 437 0 0 0 0 ____________
5125-41 FICA AND MEDICARE 11,497 12,139 12,226 8,843 0 12,226 ____________
5130-41 RETIREMENT BENEFITS 35,426 27,188 27,465 20,206 0 27,465 ____________
5131-41 LIFE INS/WTR. DIST. 0 0 303 155 0 303 ____________
5140-41 LEGAL SERVICES 25 0 0 0 0 0 ____________
5145-41 PROFESSIONAL SERVICES 0 0 1,000 0 0 1,000 ____________
5150-41 ENGINEERING EXPENSE 2,200 0 7,500 0 0 7,500 ____________
5151-41 ENGINEERING - GIS SYSTEM 1,125 1,125 1,125 1,125 0 1,125 ____________
5160-41 REGULAR MAINTENANCE 27,418 53,653 65,000 30,804 0 65,000 ____________
5161-41 CDBG GRANT IN-KIND 0 0 0 0 0 0 ____________
5162-41 CDBG GRAY STREET EXPENSE 0 0 0 0 0 0 ____________
5165-41 JANITORIAL EXPENSE 120 9 150 31 0 150 ____________
5170-41 EQUIPMENT MAINTENANCE 7,564 10,577 15,000 7,547 0 15,000 ____________
5171-41 VEHICLE MAINTENANCE 832 1,257 950 1,081 0 950 ____________
5175-41 LAKE LINE REPAIR 93 3,834 5,000 230 0 5,000 ____________
5177-41 STATION 2 MAINTENANCE 1 91 250 54 0 250 ____________
5180-41 LEGAL NOTICES 0 0 50 0 0 50 ____________
5200-41 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-41 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-41 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-41 SAFETY SUPPLIES 0 403 450 0 0 450 ____________
5208-41 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-41 INSURANCE 1,912 5,381 5,381 5,364 0 5,381 ____________
5270-41 WORKSHOP AND TRAINING 424 1,245 2,500 63 0 2,500 ____________
5290-41 UNIFORM EXPENSE 608 1,112 1,250 439 0 1,250 ____________
5315-41 FUEL EXPENSE 14,767 16,903 15,000 16,734 0 15,000 ____________
6000-41 INTEREST ON BONDED DEBT 883 536 180 54,193 0 180 ____________
6001-41 CO PAYING AGENT FEES 806 0 0 806 0 0 ____________
6002-41 AMORTIZE 2008 CO DISCOUNT 9,281 0 0 0 0 0 ____________
6100-41 LAW ENF. CENTER PROJ. EXP/WT 0 0 0 0 0 0 ____________
6200-41 BAD DEBT WRITE-OFF 8,425 5,997 3,000 2,152 0 3,000 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 9
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
6205-41 INSURANCE REPAIR 0 0 0 0 0 0 ____________
6400-41 CAPITAL OUTLAY ( 236,590) 0 0 0 0 0 ____________
6415-41 CAPITAL IMPROVEMENT EXPENSE 311 0 0 0 0 0 ____________
6500-41 DEPRECIATION EXPENSE 553,290 0 0 0 0 0 ____________
6514-41 RR ROW EXPENSE-WATERLINE 1,711 1,762 1,762 1,815 0 1,762 ____________
6515-41 DEBT SERVICE/PHONE 0 0 0 0 0 0 ____________
6516-41 DEBT SERVICE/TRAILER & BUCKE 0 0 0 0 0 0 ____________
6520-41 LEASE PAYMENT-PICKUPS 2,469 20,792 22,871 16,280 0 22,871 ____________
6650-41 2008 C.O. PRINCIPAL PAYMENT 0 170,000 170,000 399,375 0 170,000 ____________
6675-41 PRINCIPAL-2013 GO REFUND BON 18,685 19,190 19,695 0 0 19,695 ____________
6700-41 TELEPHONE 937 915 750 541 0 750 ____________
7100-41 MATERIALS/VULCAN SUPPLY 21,626 18,314 20,000 17,250 0 20,000 ____________
7173-41 INTERNET-WATER DIST. 56 58 70 36 0 70 ____________
7186-41 ICE STORM 2021 EXPENSES 0 16,946 0 0 0 0 ____________
7187-41 CLFRF REVENUE 0 ( 264,759) ( 250,000) 0 0 ( 250,000) ____________
7200-41 HWY 283 ROAD REPAIR EXPENSES 0 0 0 0 0 0 ____________
7525-41 MISCELLANEOUS EXPENSE 0 0 800 2,416 0 800 ____________
7540-41 EXPEND & TRANSFER TO TWDB 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 678,392 311,956 349,283 731,712 0 349,283
REVENUE OVER/(UNDER) EXPENDITURES ( 678,392) ( 311,956) ( 599,283) ( 731,712) 0 ( 599,283)
LAKE COLEMAN
============
REVENUES
________
3250-42 STATE CJD GRANT 30,000 0 68,000 0 0 68,000 ____________
3265-42 GRANTS FROM EDC CORPS 5,000 0 0 0 0 0 ____________
3386-42 PRIVATE GRANT 2,353 0 0 0 0 0 ____________
3388-42 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3390-42 INSURANCE COLLECTED 0 0 0 0 0 0 ____________
3410-42 MISC INCOME- LAKE COLEMAN 14,665 15,516 12,000 10,647 0 12,000 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 52,018 15,516 80,000 10,647 0 80,000
EXPENDITURES
____________
5100-42 SALARIES/LAKE COLEMAN 44,818 44,385 48,110 33,245 0 48,110 ____________
5102-42 OVERTIME WAGES 0 0 0 0 0 0 ____________
5104-42 LONGEVITY PAY 696 744 799 792 0 799 ____________
5110-42 WORKERS COMP. INS./LAKE COLE 1,191 1,426 1,507 2,414 0 1,507 ____________
5115-42 EMPLOYEE HEALTH INS./LAKE CO 604 6,523 8,622 6,123 0 8,622 ____________
5116-42 DENTAL INS (HEALTHCARE DISC) 0 180 0 0 0 0 ____________
5120-42 UNEMPLOYMENT INS./LAKE COLEM 144 144 0 0 0 0 ____________
5125-42 FICA AND MEDICARE/LAKE COLEM 3,423 3,461 3,742 2,544 0 3,742 ____________
5130-42 RETIREMENT BENEFITS/LAKE COL 10,246 7,749 7,943 5,889 0 7,943 ____________
5131-42 LIFE INS/LAKE COLEMAN 0 0 98 65 0 98 ____________
5134-42 CONTRACT LABOR 156 1,836 1,000 588 0 1,000 ____________
5140-42 LEGAL SERVICES 25 0 150 0 0 150 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 10
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5145-42 PROFESSIONAL SERVICES 5,000 39,400 0 0 0 0 ____________
5150-42 ENGINEERING 0 0 0 0 0 0 ____________
5160-42 REGULAR MAINTENANCE 1,937 1,612 5,750 1,245 0 5,750 ____________
5170-42 EQUIPMENT MAINTENANCE 2,461 1,953 4,000 545 0 4,000 ____________
5180-42 LEGAL NOTICES 0 0 0 0 0 0 ____________
5200-42 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-42 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-42 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-42 SAFETY SUPPLIES 0 139 150 0 0 150 ____________
5208-42 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-42 INSURANCE 2,382 4,453 4,453 4,752 0 4,453 ____________
5250-42 UTILITIES USED 2,585 2,968 4,000 1,137 0 4,000 ____________
5290-42 UNIFORM EXPENSE 168 160 200 768 0 200 ____________
5315-42 FUEL EXPENSE 1,499 1,317 1,500 1,311 0 1,500 ____________
6205-42 INSURANCE REPAIR 0 0 0 0 0 0 ____________
6400-42 CAPITAL OUTLAY ( 4,090) 10,000 68,000 0 0 68,000 ____________
6500-42 DEPRECIATION 17,985 0 0 0 0 0 ____________
6700-42 TELEPHONE EXPENSE 556 911 750 432 0 750 ____________
6710-42 CELL PHONE/LAKE COLEMAN 0 0 0 0 0 0 ____________
7173-42 INTERNET/ LAKE COLEMAN 469 642 470 552 0 470 ____________
7186-42 ICE STORM 2021 EXPENSES 0 1,349 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 92,256 131,351 161,244 62,402 0 161,244
REVENUE OVER/(UNDER) EXPENDITURES ( 40,238) ( 115,835) ( 81,244) ( 51,755) 0 ( 81,244)
SEWER COLLECTION
================
REVENUES
________
3388-50 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
3389-50 CLFRF EXPENSE 0 0 ( 250,000) 0 0 ( 250,000) ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 ( 250,000) 0 0 ( 250,000)
EXPENDITURES
____________
5100-50 SALARIES/SEWER 94,714 89,628 92,848 40,898 0 92,848 ____________
5102-50 OVERTIME WAGES 7,152 7,777 8,250 5,944 0 8,250 ____________
5103-50 STAND-BY PAY 3,596 3,776 8,870 5,640 0 8,870 ____________
5104-50 LONGEVITY PAY 2,784 2,880 2,048 1,160 0 2,048 ____________
5110-50 WORKERS COMP. INS./SEWER 2,745 2,801 3,677 165 0 3,677 ____________
5115-50 EMPLOYEE HEALTH INS./SEWER 15,055 11,263 25,865 8,520 0 25,865 ____________
5116-50 DENTAL INS (HEALTHCARE DISC) 0 173 0 0 0 0 ____________
5120-50 UNEMPLOYMENT INS./SEWER 288 288 0 0 0 0 ____________
5125-50 FICA AND MEDICARE/SEWER 8,134 7,975 8,569 4,015 0 8,569 ____________
5130-50 RETIREMENT BENEFITS/SEWER 24,105 17,798 19,328 9,190 0 19,328 ____________
5131-50 LIFE INS/SEWER 0 0 201 60 0 201 ____________
5145-50 PROFESSIONAL SERVICES 0 0 0 0 0 0 ____________
5150-50 LEGAL SERVICES 0 0 0 0 0 0 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 11
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5151-50 ENGINEERING - GIS SYSTEM 900 900 900 900 0 900 ____________
5160-50 REGULAR MAINTENANCE 16,945 18,362 22,000 18,814 0 22,000 ____________
5165-50 JANITORIAL EXPENSE 0 9 100 76 0 100 ____________
5170-50 EQUIPMENT MAINTENANCE 5,423 26,050 20,000 3,885 0 20,000 ____________
5177-50 STATION 2 MAINTENANCE 0 36 250 38 0 250 ____________
5180-50 LEGAL NOTICES 0 0 50 0 0 50 ____________
5200-50 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-50 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-50 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-50 SAFETY SUPPLIES 0 265 300 0 0 300 ____________
5208-50 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-50 INSURANCE 3,506 4,179 4,180 4,167 0 4,180 ____________
5230-50 LIFT STATION MAINTENANCE 11,557 3,818 15,000 7,455 0 15,000 ____________
5270-50 SCHOOLS & WORKSHOPS/SEWER 1,172 209 2,400 169 0 2,400 ____________
5280-50 DEBT SERVICE/BACKHOE 0 2,474 14,843 12,492 0 14,843 ____________
5290-50 UNIFORM EXPENSE 300 463 400 757 0 400 ____________
5315-50 FUEL EXPENSE 4,642 1,734 4,000 1,151 0 4,000 ____________
6000-50 INTEREST ON BONDED DEBT 291 438 147 0 0 147 ____________
6100-50 LAW ENF. CENTER PROJ. EXP/SE 0 0 0 0 0 0 ____________
6200-50 BAD DEBT WRITE-OFF 2,157 1,922 1,500 731 0 1,500 ____________
6205-50 INSURANCE REPAIR 0 0 0 0 0 0 ____________
6400-50 CAPITAL OUTLAY 0 0 250,000 0 0 250,000 ____________
6415-50 CAPITAL IMPROVEMENT 1,429 0 0 0 0 0 ____________
6500-50 DEPRECIATION 12,627 0 0 0 0 0 ____________
6520-50 LEASE PAYMENT-PICKUPS 0 0 0 0 0 0 ____________
6530-50 DEBT SERVICE/EQUIPMENT 3,149 0 0 0 0 0 ____________
6675-50 PRINCIPAL-2013 GO REFUND BO( 18,685) 15,694 16,107 0 0 16,107 ____________
6700-50 TELEPHONE EXPENSE 400 367 375 216 0 375 ____________
7100-50 MATERIALS/VULCAN SUPPLY 5,136 19,205 24,000 2,080 0 24,000 ____________
7173-50 INTERNET/SEWER 56 58 70 36 0 70 ____________
7186-50 ICE STORM 2021 EXPENSES 0 1,305 0 0 0 0 ____________
7187-50 CLFRF REVENUE 0 ( 264,759) ( 250,000) 0 0 ( 250,000) ____________
7525-50 MISCELLANEOUS EXPENSE 300 0 0 0 0 0 ____________
7530-50 SEWER/ INFRASTRUCTURE 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 209,877 ( 22,913) 296,278 128,558 0 296,278
REVENUE OVER/(UNDER) EXPENDITURES ( 209,877) 22,913 ( 546,278) ( 128,558) 0 ( 546,278)
SEWER TREATMENT
===============
REVENUES
________
3388-51 SURPLUS PROPERTY 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 12
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
5100-51 SALARIES/SEWER TREATMENT 45,016 48,194 52,446 35,098 0 52,446 ____________
5102-51 OVERTIME WAGES 0 255 4,000 1,296 0 4,000 ____________
5104-51 LONGEVITY PAY 900 948 1,728 1,000 0 1,728 ____________
5110-51 WORKERS COMP. INS./SWR.TRTM. 1,181 2,259 1,624 1,841 0 1,624 ____________
5115-51 EMPLOYEE HEALTH/SWR TRTMT 7,284 6,748 8,622 4,440 0 8,622 ____________
5116-51 DENTAL INS (HEALTHCARE DISC) 0 0 0 0 0 0 ____________
5120-51 UNEMPLOYMENT INS./SWR. TRTM. 144 144 0 0 0 0 ____________
5125-51 FICA AND MEDICARE/SWR.TRTMNT 3,315 3,726 4,450 2,831 0 4,450 ____________
5130-51 RETIREMENT BENEFITS/SWR. TRT 9,918 8,423 9,988 5,213 0 9,988 ____________
5131-51 LIFE INS/SEWER TREATMENT 0 0 112 37 0 112 ____________
5140-51 LEGAL SERVICES 0 0 0 0 0 0 ____________
5150-51 ENGINEERING 0 0 0 0 0 0 ____________
5160-51 REGULAR MAINTENANCE 18,977 23,566 20,000 37,100 0 20,000 ____________
5165-51 JANITORIAL SUPPLIES 0 0 0 0 0 0 ____________
5170-51 EQUIPMENT MAINTENANCE 7,159 4,054 7,150 5,300 0 7,150 ____________
5171-51 VEHICLE MAINTENANCE 291 582 500 507 0 500 ____________
5180-51 LEGAL NOTICES 0 302 75 145 0 75 ____________
5200-51 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5202-51 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-51 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-51 SAFETY SUPPLIES 0 126 150 0 0 150 ____________
5207-51 CHEMICAL SUPPLIES 0 0 0 0 0 0 ____________
5208-51 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5220-51 INSURANCE 2,993 4,024 4,024 4,011 0 4,024 ____________
5226-51 LAB TESTING 0 0 0 0 0 0 ____________
5230-51 PERMIT FEES 2,885 205 4,600 125 0 4,600 ____________
5235-51 ROTOR MAINTENANCE 1,850 771 3,000 0 0 3,000 ____________
5240-51 PUMP MAINTENANCE 345 983 5,000 629 0 5,000 ____________
5245-51 SLUDGE DISPOSAL 2,620 7,860 15,000 9,170 0 15,000 ____________
5270-51 SCHOOLS & WORKSHOPS 811 0 1,200 0 0 1,200 ____________
5290-51 UNIFORM EXPENSE 150 118 250 606 0 250 ____________
5315-51 FUEL EXPENSE 2,151 2,147 2,500 2,133 0 2,500 ____________
6000-51 INTEREST ON BONDED DEBT 560 844 284 0 0 284 ____________
6010-51 POWER FOR PUMPING SWR 52,448 54,500 55,000 33,707 0 55,000 ____________
6310-51 INTERNAL FRANCHISE FEE (4%) 27,476 27,579 29,059 21,136 0 29,059 ____________
6320-51 GENERAL SERVICES FEE (4%) 27,476 27,579 29,059 21,136 0 29,059 ____________
6400-51 CAPITAL OUTLAY ( 55,339) 0 0 0 0 0 ____________
6401-51 LEASE PURCHASE/SKIDLOADER 0 0 0 0 0 0 ____________
6415-51 CAPITAL IMPROVEMENTS 1,127 0 0 0 0 0 ____________
6500-51 DEPRECIATION 79,940 0 0 0 0 0 ____________
6515-51 DEBT SERVICE/PHONE 0 0 0 0 0 0 ____________
6520-51 LEASE PAYMENT-PICKUP 1,979 11,115 11,594 8,275 0 11,594 ____________
6600-51 PRINCIPAL 2001 CO-S 0 0 0 0 0 0 ____________
6650-51 INTEREST 2001 CO'S 0 0 0 0 0 0 ____________
6675-51 PRINCIPAL-2013 GO REFUND BON 0 30,210 31,005 0 0 31,005 ____________
6700-51 TELEPHONE EXPENSE 412 309 200 143 0 200 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 13
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
7173-51 INTERNET/SWR. TRTMNT. 136 138 140 73 0 140 ____________
7186-51 ICE STORM 2021 EXPENSES 0 2,404 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 244,204 270,111 302,760 195,952 0 302,760
REVENUE OVER/(UNDER) EXPENDITURES ( 244,204) ( 270,111) ( 302,760) ( 195,952) 0 ( 302,760)
SEWER ADMINISTRATION
====================
EXPENDITURES
____________
5100-70 SEWER ADMINISTRATION PAY 24,333 19,996 26,724 15,756 0 26,724 ____________
5102-70 OVERTIME WAGES 2 73 0 24 0 0 ____________
5104-70 LONGEVITY PAY 248 167 151 129 0 151 ____________
5110-70 WORKERS COMP/SEWER ADMIN. 604 224 211 17 0 211 ____________
5115-70 EMPLOYEE HEALTH/SEWER ADM. 2,771 2,085 4,828 2,656 0 4,828 ____________
5116-70 DENTAL INS (HEALTHCARE DISC) 0 14 0 0 0 0 ____________
5117-70 VISION INS (HEALTHCARE DISC) 0 7 0 0 0 0 ____________
5120-70 UNEMPLOYMENT INS/SEWER ADM. 84 991 0 0 0 0 ____________
5125-70 FICA & MEDICARE/SEWER ADMIN. 1,771 1,504 2,056 1,195 0 2,056 ____________
5130-70 RETIREMENT BENEFIT/SEWER ADM 6,278 3,441 4,600 2,755 0 4,600 ____________
5131-70 LIFE INS BENEFIT/SEWER ADMIN 0 0 57 25 0 57 ____________
5134-70 ADMIN CONTRACT LABOR 0 14,813 0 8,188 0 0 ____________
5160-70 REGULAR MAINTENANCE 95 103 100 46 0 100 ____________
5185-70 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5200-70 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-70 POSTAGE & DELIVERY 0 66 100 18 0 100 ____________
5202-70 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-70 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-70 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5208-70 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5255-70 ANNUAL AUDIT SERVICES 4,067 1,742 1,200 647 0 1,200 ____________
5270-70 TRAINING 0 20 100 0 0 100 ____________
5271-70 BUSINESS TRAVEL 0 0 0 0 0 0 ____________
5315-70 FUEL-ADMIN VEHICLE 0 0 0 0 0 0 ____________
6400-70 CAPITAL OUTLAY 0 0 916 0 0 916 ____________
6700-70 CELL PHONES 0 0 0 45 0 0 ____________
7177-70 MISCELLANEOUS EXPENSE 13 92 100 0 0 100 ____________
7186-70 ICE STORM 2021 EXPENSES 0 110 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 40,267 45,446 41,143 31,500 0 41,143
REVENUE OVER/(UNDER) EXPENDITURES ( 40,267) ( 45,446) ( 41,143) ( 31,500) 0 ( 41,143)
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 14
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
WATER ADMINISTRATION
====================
EXPENDITURES
____________
5100-71 WATER ADMINISTRATON PAY 103,415 84,981 113,579 66,961 0 113,579 ____________
5102-71 OVERTIME WAGES 8 311 0 100 0 0 ____________
5104-71 LONGEVITY PAY 1,055 711 642 547 0 642 ____________
5110-71 WORKERS COMP/WATER ADMIN 3,442 680 897 72 0 897 ____________
5115-71 EMPLOYEE HEALTH/WATER ADMIN 15,018 8,862 20,519 11,286 0 20,519 ____________
5116-71 DENTAL INS (HEALTHCARE DISC) 0 61 0 0 0 0 ____________
5117-71 VISION INS (HEALTHCARE DISC) 0 30 0 0 0 0 ____________
5120-71 UNEMPLOYMENT INS./WATER ADM 336 231 0 0 0 0 ____________
5125-71 FICA & MEDICARE/WATER ADM 7,524 6,391 8,738 5,080 0 8,738 ____________
5130-71 RETIREMENT BENEFIT/WATER ADM 23,341 14,624 19,549 11,705 0 19,549 ____________
5131-71 LIFE INS BENEFIT/WATER ADMIN 0 0 244 108 0 244 ____________
5134-71 ADMIN CONTRACT LABOR 0 8,263 0 1,955 0 0 ____________
5160-71 REGULAR MAINTENANCE 300 378 500 200 0 500 ____________
5185-71 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5200-71 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-71 POSTAGE & DELIVERY 0 280 0 76 0 0 ____________
5202-71 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-71 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-71 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5208-71 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5255-71 ANNUAL AUDIT SERVICES 17,285 6,954 5,100 2,784 0 5,100 ____________
5270-71 TRAINING 0 83 100 0 0 100 ____________
5271-71 BUSINESS TRAVEL 0 0 0 0 0 0 ____________
5315-71 FUEL-ADMIN VEHICLE 0 0 0 0 0 0 ____________
6400-71 CAPITAL OUTLAY 0 0 3,892 0 0 3,892 ____________
6700-71 CELL PHONES 0 0 0 192 0 0 ____________
7177-71 MISCELLANEOUS EXPENSE 45 22 50 0 0 50 ____________
7186-71 ICE STORM 2021 EXPENSES 0 466 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 171,768 133,328 173,810 101,067 0 173,810
REVENUE OVER/(UNDER) EXPENDITURES ( 171,768) ( 133,328) ( 173,810) ( 101,067) 0 ( 173,810)
ELECTRIC ADMINISTRATION
=======================
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 15
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
5100-72 ELECTRIC ADMINISTRATION PAY 438,275 364,916 487,720 287,539 0 487,720 ____________
5102-72 OVERTIME WAGES 5,833 1,337 0 431 0 0 ____________
5104-72 LONGEVITY PAY 4,613 3,054 2,758 2,348 0 2,758 ____________
5110-72 WORKERS COMP/ELECTRIC ADMIN. 14,949 2,934 3,851 310 0 3,851 ____________
5115-72 EMPLOYEE HEALTH/ELECTRIC ADM 65,257 38,057 88,112 48,461 0 88,112 ____________
5116-72 DENTAL INS (HEALTHCARE DISC) 0 262 0 0 0 0 ____________
5117-72 VISION INS (HEALTHCARE DISC) 0 130 0 0 0 0 ____________
5120-72 UNEMPLOYMENT INS./ELECTRIC A 1,435 54 0 0 0 0 ____________
5125-72 FICA & MEDICARE/ELECTRIC ADM 32,316 27,476 37,522 21,814 0 37,522 ____________
5130-72 RETIREMNT BENEFIT/ELECTRIC A 99,455 62,797 83,946 50,263 0 83,946 ____________
5131-72 LIFE INS BENEFIT/ELECTRIC AD 0 0 1,046 465 0 1,046 ____________
5134-72 ADMIN CONTRACT LABOR 0 22,613 0 667 0 0 ____________
5160-72 REGULAR MAINTENANCE 1,263 1,525 1,500 851 0 1,500 ____________
5185-72 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5200-72 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-72 POSTAGE & DELIVERY 0 1,201 1,201 327 0 1,201 ____________
5202-72 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-72 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-72 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5208-72 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5255-72 ANNUAL AUDIT SERVICES 74,223 32,110 21,900 11,853 0 21,900 ____________
5270-72 TRAINING 0 356 450 0 0 450 ____________
5271-72 BUSINESS TRAVEL 0 0 0 0 0 0 ____________
5315-72 FUEL-ADMIN VEHICLE 0 0 0 0 0 0 ____________
6400-72 CAPITAL OUTLAY 0 0 16,713 0 0 16,713 ____________
6700-72 CELL PHONES 0 0 0 825 0 0 ____________
7177-72 MISCELLANEOUS EXPENSE 184 33 0 1,261 0 0 ____________
7186-72 ICE STORM 2021 EXPENSES 0 1,999 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 737,803 560,853 746,719 427,416 0 746,719
REVENUE OVER/(UNDER) EXPENDITURES ( 737,803) ( 560,853) ( 746,719) ( 427,416) 0 ( 746,719)
INTERFUND TRANSFERS
===================
REVENUES
________
4123-98 GF DEBT SERVICE TO WATER 20,374 0 19,726 14,794 0 19,726 ____________
4125-98 GF DEBT SERVICE TO SEWER 46,807 0 47,186 35,390 0 47,186 ____________
4129-98 GF DEBT SERVICE TO ELECTRIC 127,364 0 128,395 96,296 0 128,395 ____________
4329-98 TRANSFER FROM SOLID WASTE 0 0 0 0 0 0 ____________
4610-98 TRANSFER FROM CDBG FUND 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 194,545 0 195,307 146,480 0 195,307
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 16
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
300-Utility EWS Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EXPENDITURES
____________
9100-98 TRANSFER TO GENERAL FUND 1,515,987 1,485,537 1,532,537 1,149,403 0 1,532,537 ____________
9310-98 TRANSFER TO AIRPORT FUND 28,834 0 21,850 16,388 0 21,850 ____________
9320-98 TRANSFER TO SOLID WASTE 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 1,544,821 1,485,537 1,554,387 1,165,790 0 1,554,387
REVENUE OVER/(UNDER) EXPENDITURES ( 1,350,277) ( 1,485,537) ( 1,359,080) ( 1,019,310) 0 ( 1,359,080)
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 7,350,002 9,881,890 8,660,065 6,279,401 0 8,660,065
FUND TOTAL EXPENDITURES 6,046,810 9,712,291 8,584,743 6,364,385 0 8,584,743
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 1,303,191 169,600 75,322 ( 84,984) 0 75,322
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
310-Municipal Airport Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
AIRPORT
=======
REVENUES
________
3162-75 A/R BAD DEBT COLLECTIONS 0 0 0 0 0 0 ____________
3220-75 GASOLINE,OIL SALES 38,476 50,488 40,000 40,941 0 40,000 ____________
3225-75 JET FUEL SALES 709 0 0 0 0 0 ____________
3300-75 HANGER RENTAL 9,540 8,910 10,000 7,785 0 10,000 ____________
3310-75 INTEREST INCOME 1,804 221 250 538 0 250 ____________
3330-75 MISC INCOME 0 0 0 0 0 0 ____________
3340-75 CROP RENTAL 4,750 4,750 4,750 0 0 4,750 ____________
3355-75 CAPITOL IMPROVEMENTS 0 0 0 0 0 0 ____________
3360-75 A/R ADMIN. FEE-AIRPORT 38 0 0 7 0 0 ____________
3369-75 TXDOT - RAMP GRANT 50/50 0 0 10,000 0 0 10,000 ____________
3375-75 TXDOT GRANT 90/10 0 0 0 0 0 0 ____________
3376-75 RAMP GRANT REVIENUE 0 0 0 0 0 0 ____________
3377-75 TDEM COVID-19 RELIEF GRANT 30,000 0 0 0 0 0 ____________
3380-75 MCIVER HANGER - RAMP 0 0 0 0 0 0 ____________
3390-75 INSURANCE COLLECTED 1,041 170,928 0 39,458 0 0 ____________
3395-75 CONTRIBUTION 500 0 0 500 0 0 ____________
3410-75 EDC 4A-EXCESS RENTALS-TXDOT 6,889 29,561 20,000 0 0 20,000 ____________
3620-75 TRANSFER DEPRECIATION 0 0 0 0 0 0 ____________
3925-75 FAA TXDOT 90% CAPITAL CONTR( 161,136) 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE ( 67,389) 264,859 85,000 89,229 0 85,000
REVENUE OVER/(UNDER) EXPENDITURES ( 67,389) 264,859 85,000 89,229 0 85,000
AIRPORT
=======
EXPENDITURES
____________
5134-76 AIRPORT SERVICES CONTRACT 9,600 9,600 9,600 6,400 0 9,600 ____________
5145-76 LEGAL SERVICES - AIRPORT 0 0 150 0 0 150 ____________
5150-76 ENGINEERING 0 0 0 0 0 0 ____________
5160-76 REGULAR MAINTENANCE 2,442 1,196 5,000 1,217 0 5,000 ____________
5165-76 AIRPORT ADVISORY BOARD 0 0 0 0 0 0 ____________
5170-76 EQUIPMENT MAINTENANCE 1,119 929 2,000 ( 3) 0 2,000 ____________
5171-76 VEHICLE MAINTENANCE 40 72 50 54 0 50 ____________
5177-76 APARTMENT MAINTENANCE 131 751 1,000 0 0 1,000 ____________
5180-76 LEGAL NOTICES 0 0 0 0 0 0 ____________
5220-76 INSURANCE 22,989 11,021 11,050 15,553 0 11,050 ____________
5230-76 PERMIT FEES 200 303 200 400 0 200 ____________
5250-76 UTILITIES 10,340 10,643 12,000 5,881 0 12,000 ____________
5270-76 TRAINING MATERIALS & SCHOOLS 0 518 1,000 701 0 1,000 ____________
6010-76 GASOLINE-OIL 34,673 41,563 25,000 38,349 0 25,000 ____________
6015-76 JET FUEL EXPENSE 0 0 0 0 0 0 ____________
6201-76 A/R BAD DEBT WRITE-OFF 0 0 0 0 0 0 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 2
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
310-Municipal Airport Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
6205-76 INSURANCE REPAIR 1,320 0 0 0 0 0 ____________
6400-76 CAPITOL OUTLAY ( 13,850) 231,833 0 0 0 0 ____________
6415-76 CAPITOL IMPROVEMENTS 0 0 0 0 0 0 ____________
6500-76 DEPRECIATION EXPENSE 300,684 0 0 0 0 0 ____________
6700-76 TELEPHONE/AIRPORT 3,129 2,941 2,500 2,433 0 2,500 ____________
6750-76 ATMOS/AIRPORT 723 826 600 674 0 600 ____________
7177-76 MISCELLANEOUS EXPENSE 879 0 0 0 0 0 ____________
8600-76 GRANT EXPENSE 90/10 0 0 0 0 0 0 ____________
8610-76 TX DOT - RAMP EXPENSES 6,890 10,839 20,000 6,214 0 20,000 ____________
8630-76 CREDIT CARD SYSTEM 1,675 1,675 2,000 1,675 0 2,000 ____________
8640-76 RAMP GRANT EXPENSE 50/50 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 382,983 324,707 92,150 79,549 0 92,150
REVENUE OVER/(UNDER) EXPENDITURES ( 382,983) ( 324,707) ( 92,150) ( 79,549) 0 ( 92,150)
REVENUES
________
4300-98 TRANSFER FROM EWS FUND 28,834 0 0 16,388 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 28,834 0 0 16,388 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES ( 67,389) 264,859 85,000 89,229 0 85,000
FUND TOTAL EXPENDITURES 382,983 324,707 92,150 79,549 0 92,150
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) ( 450,372) ( 59,848) ( 7,150) 9,680 0 ( 7,150)
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
320-Sanitation Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
SOLID WASTE REMOVAL
===================
REVENUES
________
3110-46 ROLL OFF DEPOSITS 19 0 0 0 0 0 ____________
3112-46 WASTE REMOVAL SALES (VENDOR) 546,161 545,592 587,000 421,705 0 587,000 ____________
3113-46 WASTE REMOVAL SALES (CITY) 260,586 252,599 295,535 194,606 0 295,535 ____________
3120-46 LANDFILL COLLECTIONS 0 0 0 0 0 0 ____________
3155-46 ALLIED FRANCHISE FEE (OLD) 0 0 0 0 0 0 ____________
3156-46 WASTE REMOVAL FRANCHISE FEE 30,672 32,657 30,000 23,178 0 30,000 ____________
3162-46 A/R BAD DEBT COLLCETIONS 0 0 0 1,553 0 0 ____________
3300-46 ALLIED WASTE LEASE PAYMENT 0 0 0 0 0 0 ____________
3310-46 INTEREST INCOME-GARBAGE 134 134 100 29 0 100 ____________
3315-46 INTEREST INCOME 0 ( 4) 0 18 0 0 ____________
3316-46 GATE FEE - CONVENIENCE CENTE 5,260 5,980 5,000 3,740 0 5,000 ____________
3317-46 DEPOSIT FOR ROLL-OFF CONTAIN 0 0 0 0 0 0 ____________
3320-46 TIRE REMOVAL 452 324 400 719 0 400 ____________
3321-46 ANNUAL CLEAN UP COST 0 0 0 0 0 0 ____________
3330-46 4A/4B WASTE REMOVAL GRANTS 0 0 0 0 0 0 ____________
3360-46 ADMINISTRATIVE FEE 0 0 0 0 0 0 ____________
3390-46 INSURANCE COLLECTED 0 0 0 0 0 0 ____________
3396-46 LEASE PURCHASE 0 0 0 0 0 0 ____________
3410-46 MISCELLANEOUS INCOME 933 0 0 2,607 0 0 ____________
3450-46 LANDFILL FARM LEASE 0 0 0 0 0 0 ____________
3460-46 CONVENIENCE CENTER REVENUE 11,494 14,241 12,000 9,034 0 12,000 ____________
3470-46 USED OIL RECYCLING 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 855,712 851,524 930,035 657,190 0 930,035
EXPENDITURES
____________
5100-46 SALARIES/GARBAGE 6,120 10,752 10,000 7,837 0 10,000 ____________
5102-46 OVERTIME WAGES 0 2,689 300 0 0 300 ____________
5104-46 LONGEVITY PAY 424 352 1,728 0 0 1,728 ____________
5110-46 WORKERS COMP/GARBAGE 1,273 1,705 695 191 0 695 ____________
5115-46 EMPLOYEE HEALTH/GARBAGE 4,313 199 0 127 0 0 ____________
5120-46 UNEMPLOYMENT INS./GARBAGE 115 29 0 0 0 0 ____________
5125-46 FICA & MEDICARE/GARBAGE 1,996 1,055 920 604 0 920 ____________
5130-46 RETIREMENT BENEFITS/GARBAGE 4,276 658 0 118 0 0 ____________
5131-46 LIFE INS (SANI) 0 0 0 1 0 0 ____________
5134-46 ADMIN CONTRACT LABOR 0 2,917 0 690 0 0 ____________
5140-46 LEGAL SERVICES 450 0 150 0 0 150 ____________
5145-46 PROFESSIONAL SERVICES - GARB 1,000 0 250 0 0 250 ____________
5150-46 ALLIED WASTE (NO LONGER USED 0 0 0 0 0 0 ____________
5151-46 WASTE CONNECTIONS LONE STAR 545,819 544,787 587,000 374,591 0 587,000 ____________
5160-46 REGULAR MAINTENANCE 3,197 2,786 4,000 1,881 0 4,000 ____________
5165-46 ENGINEERING 6,520 5,150 5,000 2,243 0 5,000 ____________
5170-46 EQUIPMENT MAINTENANCE 29,226 1,674 5,000 2,524 0 5,000 ____________
5180-46 SF DEBT SERVICE/CHIPPER 685 0 0 0 0 0 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 2
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
320-Sanitation Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5181-46 LEGAL NOTICES 0 0 0 0 0 0 ____________
5200-46 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-46 POSTAGE & DELIVERY 0 0 0 0 0 0 ____________
5202-46 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-46 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-46 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5220-46 INSURANCE 990 1,235 1,235 1,231 0 1,235 ____________
5230-46 PERMIT FEES 0 0 0 0 0 0 ____________
5250-46 UTILITIES 0 0 0 0 0 0 ____________
5270-46 SCHOOLS & WORKSHOPS 0 0 1,200 560 0 1,200 ____________
5290-46 UNIFORM EXPENSE 0 150 0 651 0 0 ____________
5315-46 VEHICLE FUEL 0 0 500 1,253 0 500 ____________
6200-46 BAD DEBT WRITE OFF 549 164 500 ( 3) 0 500 ____________
6201-46 A/R BAD DEBT WRITE-OFF 0 0 0 0 0 0 ____________
6205-46 INSURANCE REPAIRS 0 0 0 0 0 0 ____________
6310-46 INTERNAL FRANCHISE FEE (4%) 31,810 31,928 35,301 24,653 0 35,301 ____________
6320-46 GENERAL SERVICES FEE (4%) 31,810 31,928 35,301 24,653 0 35,301 ____________
6330-46 USED OIL RECYCLING 0 0 0 0 0 0 ____________
6400-46 CAPITAL OUTLAY-GARBAGE 0 0 0 0 0 0 ____________
6500-46 DEPRECIATION EXPENSE 13,312 0 0 0 0 0 ____________
6530-46 DEBT SERVICE/CHIPPER ( 0) 5,459 5,459 5,459 0 5,459 ____________
6700-46 TELEPHONE EXPENSE 0 0 0 0 0 0 ____________
6705-46 CONVENIENCE CENTER EXPENSES 64,952 77,417 90,000 50,715 0 90,000 ____________
6706-46 TIRE REMOVAL EXPENSE 0 0 750 641 0 750 ____________
6707-46 ANNUAL CLEAN UP EXPENSE 0 1,208 20,000 831 0 20,000 ____________
6750-46 ATMOS GAS UTILITIES 745 993 900 855 0 900 ____________
6770-46 LANDFILL CLOS/POSTCLOS COSTS 1,253 0 0 0 0 0 ____________
7177-46 MISCELLANEOUS EXPENSE 0 0 1,000 0 0 1,000 ____________
7530-46 NOT AN ACTIVE ACCOUNT 0 0 0 0 0 0 ____________
8611-46 HEALTH REIMB. EXPENSE 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 750,837 725,234 807,189 502,307 0 807,189
REVENUE OVER/(UNDER) EXPENDITURES 104,875 126,290 122,846 154,883 0 122,846
SOLIDWASTE ADMINISTRATION
=========================
EXPENDITURES
____________
5100-74 SOLID WASTE ADM PAY 36,500 29,993 26,721 23,634 0 26,721 ____________
5102-74 OVERTIME WAGES 2 110 0 35 0 0 ____________
5104-74 LONGEVITY PAY 0 251 151 193 0 151 ____________
5110-74 WORKERS COMP/SOLIDWASTE ADM 394 162 211 ( 51) 0 211 ____________
5115-74 EMPLOYEE HEALTH/SLDWASTE ADM 2,076 3,128 4,828 3,983 0 4,828 ____________
5116-74 DENTAL INS (HEALTHCARE DISC) 0 22 0 0 0 0 ____________
5117-74 VISION INS (HEALTHCARE DISC) 0 11 0 0 0 0 ____________
5120-74 UNEMPLOYMENT INS/SLDWST ADM 118 81 0 0 0 0 ____________
5125-74 FICA & MEDICARE/SOLIDWASTE A 1,227 2,255 2,056 1,793 0 2,056 ____________
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 3
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
320-Sanitation Fund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
5130-74 RETIREMENT BENEFIT/SLDWST AD 2,498 5,161 4,600 4,131 0 4,600 ____________
5131-74 LIFE INS BENEFIT/SLDWST ADM 0 0 52 38 0 52 ____________
5160-74 REGULAR MAINTENANCE 106 409 500 59 0 500 ____________
5185-74 DUES & SUBSCRIPTIONS 0 0 0 0 0 0 ____________
5200-74 OFFICE SUPPLIES 0 0 0 0 0 0 ____________
5201-74 POSTAGE & DELIVERY 0 99 150 27 0 150 ____________
5202-74 MINOR TOOLS & EQUIPMENT 0 0 0 0 0 0 ____________
5204-74 FURNITURE & FIXTURES 0 0 0 0 0 0 ____________
5206-74 SAFETY SUPPLIES 0 0 0 0 0 0 ____________
5208-74 ALL OTHER SUPPLIES 0 0 0 0 0 0 ____________
5255-74 ANNUAL AUDIT SERVICES 6,101 2,896 1,800 880 0 1,800 ____________
5270-74 TRAINING 0 29 0 0 0 0 ____________
5271-74 BUSINESS TRAVEL 0 0 0 0 0 0 ____________
5315-74 FUEL-ADMIN VEHICLE 0 0 0 0 0 0 ____________
6400-74 CAPITAL OUTLAY 0 0 1,374 0 0 1,374 ____________
6700-74 CELL PHONES 0 0 0 68 0 0 ____________
7177-74 MISCELLANEOUS EXPENSE 6 0 0 0 0 0 ____________
7186-74 ICE STORM EXPENSES 0 164 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 49,028 44,772 42,443 34,789 0 42,443
REVENUE OVER/(UNDER) EXPENDITURES ( 49,028) ( 44,772) ( 42,443) ( 34,789) 0 ( 42,443)
INTERFUND TRANSFERS
===================
REVENUES
________
4300-98 TRANSFER FROM EWS FUND 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
9100-98 TRANSFER TO GENERAL FUND 0 0 30,500 22,875 0 30,500 ____________
9300-98 TRANSFER TO EWS FUND 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 30,500 22,875 0 30,500
REVENUE OVER/(UNDER) EXPENDITURES 0 0 ( 30,500) ( 22,875) 0 ( 30,500)
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 855,712 851,524 930,035 657,190 0 930,035
FUND TOTAL EXPENDITURES 799,865 770,005 880,132 559,971 0 880,132
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 55,847 81,518 49,903 97,219 0 49,903
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
340-TWDB/Water Grant
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
TWDB/Water Grant
================
REVENUES
________
3070-23 TRANSFER IN 0 0 0 0 0 0 ____________
3510-23 INTEREST INCOME 0 0 0 0 0 0 ____________
3612-23 PROCEEDS FROM 2008 CO 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
EXPENDITURES
____________
5145-23 CONSULTING/ENGINEERING 0 0 0 0 0 0 ____________
6770-23 2008 C.O. EXPENSE/HORDS CREE 0 0 0 0 0 0 ____________
6780-23 PHASE I 0 0 0 0 0 0 ____________
6785-23 PHASE II 0 0 0 0 0 0 ____________
7500-23 INNER FUND TRANSFER 0 0 0 0 0 0 ____________
7520-23 TRANSFER OUT - LWS 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 0 0 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 0 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
400-Cemetery Endowment
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
550-ENTERPRISE CAPITAL PROJEC
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
610-Community DevelopmentFund
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
COMMUNITY DEVELOPMENT
=====================
REVENUES
________
3330-85 TRANSFER FROM LWS 0 0 0 0 0 0 ____________
3510-85 INTEREST EARNED 0 0 0 0 0 0 ____________
3515-85 GRANT FUNDS 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 0 0 0
COMMUNITY DEV. EXPENSES
=======================
EXPENDITURES
____________
5145-86 PROFESSIONAL SERVICES 0 0 0 0 0 0 ____________
5150-86 ENGINEERING 0 0 0 0 0 0 ____________
5160-86 CONTRACTOR EXPENSES 0 0 0 0 0 0 ____________
5180-86__COMMUNITY DEV. 2000 EXPENSES 0 0 0 0 0 0 ____________
5810-86 COMMUNITY DEV. EXPENSES 0 0 0 0 0 0 ____________
7525-86 MISC. EXPENSES/FORCE ACCT. 0 0 0 0 0 0 ____________
7530-86 CLARIFIER PROJECT 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 0 0 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 0 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
710-Health Reimbursement Acct
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
EMPLOYEE HEALTH REVENUE
=======================
REVENUES
________
3120-80 HEALTH REIMBURSEMENT 0 0 0 0 0 0 ____________
3510-80 INTEREST INCOME 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 0 0 0 0 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 0 0 0
EMPLOYEE HEALTH
===============
EXPENDITURES
____________
5220-81 HEALTH CLAIMS PAID 0 0 0 0 0 0 ____________
7500-81 TRANSFER TO GENERAL FUND 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 0 0 0 0 0 0
REVENUE OVER/(UNDER) EXPENDITURES 0 0 0 0 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
810-Payroll AP Tracking Acct
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
DEPARTMENT 90
=============
REVENUES
________
3295-90 LOAN FROM GENERAL 53 60 0 ( 60) 0 0 ____________
3310-90 INTEREST EARNED 32 32 0 15 0 0 ____________
3330-90 MISC INCOME 0 291 0 1,659 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 85 384 0 1,614 0 0
EXPENDITURES
____________
7177-90 MISC. EXPENSES/AJE 29 30 0 9 0 0 ____________
7500-90 TRANSFERS 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES 29 30 0 9 0 0
REVENUE OVER/(UNDER) EXPENDITURES 56 354 0 1,605 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 85 384 0 1,614 0 0
FUND TOTAL EXPENDITURES 29 30 0 9 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 56 354 0 1,605 0 0
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
820-AP Disbursement Tracking
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
DEPT 95
=======
REVENUES
________
3310-95 INTEREST INCOME 100 80 0 92 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL REVENUE 100 80 0 92 0 0
EXPENDITURES
____________
7177-95 MISC. EXP/AJE ( 0) 1,227 0 519 0 0 ____________
7500-95 TRANSFER TO GENERAL 0 0 0 0 0 0 ____________
___________ ___________ ___________ ___________ ___________
____________ ____________
TOTAL EXPENDITURES ( 0) 1,227 0 519 0 0
REVENUE OVER/(UNDER) EXPENDITURES 100 ( 1,148) 0 ( 428) 0 0
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 100 80 0 92 0 0
FUND TOTAL EXPENDITURES ( 0) 1,227 0 519 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 100 ( 1,148) 0 ( 428) 0 0
*** END OF REPORT ***
*** END OF REPORT ***
*** END OF REPORT ***
7-06-2022 11:22 AM CITY OF COLEMAN PAGE: 1
PROPOSED BDUGET WORKSHEET
AS OF: JUNE 30TH, 2022
999-Consolidated Cash
(-------------- 2021-2022 ---------------)(------- 2022-2023 --------)
2019-2020 2020-2021 CURRENT Y-T-D PROJECTED DEPARTMENT PROPOSED
ACCOUNT# ACCOUNT NAME ACTUAL ACTUAL BUDGET ACTUAL TO YEAR END REQUESTED BUDGET
_________________________________________________________________________________________________________________________________________
______________________________________________________________________________
___________________________________________________________
FUND TOTAL REVENUES 0 0 0 0 0 0
FUND TOTAL EXPENDITURES 0 0 0 0 0 0
___________ ___________ ___________ ___________ ___________
____________ ____________
FUND TOTAL PROFIT (LOSS) 0 0 0 0 0 0
*** END OF REPORT ***