Document Douglas_doc_0406128bdd

CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2024 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 18,438,527.99 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 80,872.88 01-10000106 CASH - XPRESS DEPOSIT ACCOUNT 33,407.53 01-10000113 CASH ON HAND 575.00 TOTAL COMBINED CASH 18,553,383.40 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 18,553,383.40) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND 9,594,044.78 11 ALLOCATION TO IMPACT ASSISTANCE FUND 1,779,769.63 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND ( 25,463.52) 31 ALLOCATION TO WATER FUND 722,865.65 32 ALLOCATION TO SEWER FUND ( 493,338.23) 33 ALLOCATION TO SANITATION FUND 540,847.37 34 ALLOCATION TO LANDFILL FUND 261,325.76 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 18,842.44 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 45,746.05 41 ALLOCATION TO ECONOMIC DEVELOPMENT 1,944,666.67 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE 224,353.98 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 1,089,389.44 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 7,321.66 54 ALLOCATION TO TRAIN CAR RESTORATION 74,339.90 55 ALLOCATION TO POOL IMPROVEMENTS FUND 304,574.98 56 ALLOCATION TO STREET IMPROVEMENT FUND 1,086,415.59 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 117,929.61 65 ALLOCATION TO CAPTL PROJ-PARK FUND 1,221,277.80 90 ALLOCATION TO PERPETUAL CARE FUND 4,358.90 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 105.39 92 ALLOCATION TO HISTORIC CMSN FUND 22,672.15 96 ALLOCATION TO UTILITY DEPOSIT FUND 11,297.79 97 ALLOCATION TO DEFERRED COMP TRUST FUND 39.61 TOTAL ALLOCATIONS TO OTHER FUNDS 18,553,383.40 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 18,553,383.40) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:2 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 9,594,044.78 TOTAL CASH 9,594,044.78 INVESTMENTS: 10-10000120 INVESTMENT POOL 15,778,591.72 10-10000122 TIME DEPOSITS - SHORT TERM 28,925,425.50 TOTAL INVESTMENTS 44,704,017.22 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 134,423.79 10-10000131 ACCOUNTS RECEIVABLE - GENERAL ( 4,336.15) 10-10000132 ACCOUNTS REC - PROPERTY TAX 55,310.02 10-10000133 ACCOUNTS CRT 2,407.00 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 3,219,895.23 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 432.76 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE 1,467.44 10-10000139 ACCRUED INTEREST RECEIVABLE 20,226.52 TOTAL ACCOUNTS RECEIVABLE 3,429,826.61 TOTAL CURRENT ASSETS 57,727,888.61 NON-CURRENT ASSETS: INVESTMENTS: 10-10000170 PREPAID EXPENSE 35,854.00 TOTAL INVESTMENTS 35,854.00 TOTAL NON-CURRENT ASSETS 35,854.00 TOTAL ASSETS 57,763,742.61 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:3 ACCOUNTS PAYABLE: 10-20000201 ALLOCATION FROM AP FUND 496,543.90 10-20000204 ACCOUNTS PAYABLE - EOY ( 27,901.21) 10-20000206 FUNDS PAYABLE - DUE TO OTHERS 207.27 10-20000208 SURCHARGE PAYABLE 3,244.00 10-20000212 SURCHARGE - CITY - E CITATION 4,745.00 10-20000213 DONATION-POLICE DEPARTMENT USE ( 207.41) 10-20000215 WAGES PAYABLE 66,050.80 10-20000217 DUE TO OTHERS 40.00 TOTAL ACCOUNTS PAYABLE 542,722.35 PAYROLL DEDUCTIONS PAYABLE: 10-20000223 FICA PAYABLE ( .51) 10-20000224 DEFERRED COMPENSATION PAYABLE 66,385.59 10-20000227 WORKERS COMP INS PAYABLE 28,842.12 TOTAL PAYROLL DEDUCTIONS PAYABLE 95,227.20 OTHER LIABILITIES PAYABLE: 10-20000228 UNCLAIMED PROPERTY 17,563.37 TOTAL OTHER LIABILITIES PAYABLE 17,563.37 DUE TO OTHER FUNDS: 10-20000245 DUE TO OTHER FUNDS 27,901.21 TOTAL DUE TO OTHER FUNDS 27,901.21 DEFERRED REVENUE: 10-20000300 DEFERRED REVENUE 1,105,117.04 TOTAL DEFERRED REVENUE 1,105,117.04 TOTAL CURRENT LIABILITIES 1,788,531.17 TOTAL LIABILITIES 1,788,531.17 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 38,273,225.86 10-30000301 FUND BALANCE RESERVE 4,070,000.00 10-30000302 RESERVE FOR SEWER LIFT STATION 840,000.00 TOTAL CAPITAL ASSETS 43,183,225.86 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:4 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 12,791,985.58 BALANCE - CURRENT DATE 55,975,211.44 TOTAL NET ASSETS 55,975,211.44 TOTAL LIABILITIES AND NET ASSETS 57,763,742.61 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:5 GENERAL - REVENUE REVENUE: 10-4100-0160 GAIN ON INVESTMENTS 14,311.22 120,893.13 .00 ( 120,893.13) .0 TOTAL REVENUE 14,311.22 120,893.13 .00 ( 120,893.13) .0 MISC LOCAL REVENUE: 10-4100-1101 REIMBURSEMENT - CCSD 8,119.55 73,075.95 73,076.00 .05 100.0 10-4100-1107 OTHER 324.00 56,434.36 10,000.00 ( 46,434.36) 564.3 10-4100-1108 COPY FEES/VIN CHECKS 750.00 6,667.50 5,000.00 ( 1,667.50) 133.4 10-4100-1109 REIMBURSEMENTS 9,787.93 59,632.87 .00 ( 59,632.87) .0 10-4100-1112 CONTRIBUTIONS .00 13,030.85 14,500.00 1,469.15 89.9 10-4100-1115 LEASES/RENT 850.00 6,275.00 6,200.00 ( 75.00) 101.2 10-4100-1120 FINES/FORFEITS 1,984.00 20,483.00 22,500.00 2,017.00 91.0 10-4100-1130 CASH LONG/SHORT .00 ( 80.01) .00 80.01 .0 10-4100-1140 INTEREST INCOME 269,668.91 1,598,308.93 1,015,000.00 ( 583,308.93) 157.5 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 22,210.00 30,000.00 7,790.00 74.0 TOTAL MISC LOCAL REVENUE 291,484.39 1,856,038.45 1,176,276.00 ( 679,762.45) 157.8 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 250.00 19,995.00 21,300.00 1,305.00 93.9 TOTAL LIQUOR LICENSES 250.00 19,995.00 21,300.00 1,305.00 93.9 OTHER LICENSES/PERMITS: 10-4100-1232 TRANSIENT MERCHANTS .00 200.00 .00 ( 200.00) .0 TOTAL OTHER LICENSES/PERMITS .00 200.00 .00 ( 200.00) .0 CONTRACTORS LICENSES: 10-4100-1241 LICENSES - CONTRACTORS 105.00 13,990.00 15,000.00 1,010.00 93.3 TOTAL CONTRACTORS LICENSES 105.00 13,990.00 15,000.00 1,010.00 93.3 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 6,399.09 75,518.71 21,750.00 ( 53,768.71) 347.2 TOTAL BUILDING PERMITS 6,399.09 75,518.71 21,750.00 ( 53,768.71) 347.2 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 75.00 4,620.38 2,000.00 ( 2,620.38) 231.0 TOTAL ZONING/CONDITIONAL USE 75.00 4,620.38 2,000.00 ( 2,620.38) 231.0 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:6 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 139,043.46 570,048.79 464,500.00 ( 105,548.79) 122.7 10-4100-1321 PROPERTY TAX - PRIOR YEARS 77.56 1,130.41 2,000.00 869.59 56.5 10-4100-1322 PROPERTY TAX - AUTO 20,779.95 195,832.80 183,900.00 ( 11,932.80) 106.5 10-4100-1323 PROPERTY TAX - INTEREST 227.36 2,855.16 2,100.00 ( 755.16) 136.0 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 800.64) ( 3,844.28) ( 3,000.00) 844.28 ( 128.1) TOTAL PROPERTY TAXES 159,327.69 766,022.88 649,500.00 ( 116,522.88) 117.9 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 19,082.84 243,124.16 225,000.00 ( 18,124.16) 108.1 10-4100-1331 FRANCHISE FEES - CABLE TV .00 8,059.45 10,000.00 1,940.55 80.6 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 34,631.71 36,000.00 1,368.29 96.2 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 6,548.75 6,300.00 ( 248.75) 104.0 TOTAL FRANCHISE FEES 19,082.84 292,364.07 277,300.00 ( 15,064.07) 105.4 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 26,343.75 105,375.00 105,375.00 .00 100.0 10-4100-1421 MANAGEMENT FEES - WATER 73,762.75 295,051.00 295,051.00 .00 100.0 10-4100-1422 MANAGEMENT FEES - SEWER 36,222.75 144,891.00 144,891.00 .00 100.0 10-4100-1423 MANAGEMENT FEES - SANITATION 36,486.25 145,945.00 145,945.00 .00 100.0 TOTAL MANAGEMENT FEES 172,815.50 691,262.00 691,262.00 .00 100.0 WEED ABATEMENT: 10-4100-1430 WEED MOWING CHARGES 334.41 1,462.92 .00 ( 1,462.92) .0 10-4100-1431 PEST CONTROL .00 14,768.70 14,700.00 ( 68.70) 100.5 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 134,423.79 39,000.00 ( 95,423.79) 344.7 TOTAL WEED ABATEMENT 334.41 150,655.41 53,700.00 ( 96,955.41) 280.6 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 2,850.00 20,800.00 15,000.00 ( 5,800.00) 138.7 TOTAL BURIAL FEES 2,850.00 20,800.00 15,000.00 ( 5,800.00) 138.7 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 400.00 5,150.00 7,500.00 2,350.00 68.7 TOTAL LOT SALES 400.00 5,150.00 7,500.00 2,350.00 68.7 POOL: 10-4100-1650 POOL - USER FEES .00 .00 22,000.00 22,000.00 .0 TOTAL POOL .00 .00 22,000.00 22,000.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:7 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 459,294.64 459,295.00 .36 100.0 10-4100-3111 SEVERENCE TAX - 2% 57,760.41 250,333.59 228,573.00 ( 21,760.59) 109.5 10-4100-3112 MINERAL ROYALTIES 77,052.36 304,148.33 325,000.00 20,851.67 93.6 TOTAL MINERAL EXTRACTION 134,812.77 1,013,776.56 1,012,868.00 ( 908.56) 100.1 SALES TAX: 10-4100-3241 SALES TAX - STATE 1,118,893.50 10,988,460.28 5,500,000.00 ( 5,488,460.28) 199.8 10-4100-3245 SALES TAX - LOCAL OPTION 909,380.10 8,959,023.56 4,500,000.00 ( 4,459,023.56) 199.1 TOTAL SALES TAX 2,028,273.60 19,947,483.84 10,000,000.00 ( 9,947,483.84) 199.5 GAS TAX: 10-4100-3250 LOTTERY .00 54,961.44 48,000.00 ( 6,961.44) 114.5 10-4100-3251 HISTORIC HORSE RACING .00 177,677.85 .00 ( 177,677.85) .0 10-4100-3257 GAS TAX 15,231.80 228,533.49 240,000.00 11,466.51 95.2 10-4100-3258 SPECIAL FUELS 4,996.68 66,274.78 65,000.00 ( 1,274.78) 102.0 TOTAL GAS TAX 20,228.48 527,447.56 353,000.00 ( 174,447.56) 149.4 OTHER: 10-4100-3262 CIGARETTE TAX 3,281.87 39,148.02 45,000.00 5,851.98 87.0 TOTAL OTHER 3,281.87 39,148.02 45,000.00 5,851.98 87.0 STATE REVENUE: 10-4100-3374 SLIB .00 22,819.72 .00 ( 22,819.72) .0 TOTAL STATE REVENUE .00 22,819.72 .00 ( 22,819.72) .0 TOTAL GENERAL - REVENUE 2,854,031.86 25,568,185.73 14,363,456.00 ( 11,204,729.73) 178.0 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 1,098.11 5,949.52 6,500.00 550.48 91.5 TOTAL OPERATING TRANSFERS IN 1,098.11 5,949.52 6,500.00 550.48 91.5 TOTAL OPERATING TRANSFERS - IN 1,098.11 5,949.52 6,500.00 550.48 91.5 TOTAL FUND REVENUE 2,855,129.97 25,574,135.25 14,369,956.00 ( 11,204,179.25) 178.0 GENERAL GOVT - NON DEPARTMENTL ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:8 CASH FUND APPROPRIATION: 10-5100-0150 REPLACEMENT RESERVE 75,000.00 300,000.00 300,000.00 .00 100.0 TOTAL CASH FUND APPROP 75,000.00 300,000.00 300,000.00 .00 100.0 EMPLOYEE BENEFITS: 10-5100-1021 EMPLOYEE BENEFITS - SCL 1.53 58.65 50.00 ( 8.65) 117.3 10-5100-1023 EMPLOYEE BENEFITS - HEALTH INS 2,467.60 29,799.67 27,225.00 ( 2,574.67) 109.5 10-5100-1025 EMPLOYEE BENEFITS - COMP 9,071.38 9,083.57 .00 ( 9,083.57) .0 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 20.00 1,775.10 2,750.00 974.90 64.6 TOTAL EMPLOYEE BENEFITS 11,560.51 40,716.99 30,025.00 ( 10,691.99) 135.6 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT 1,000.00 8,301.18 6,000.00 ( 2,301.18) 138.4 10-5100-2115 PUBLISHING/ADVERTISING 6,289.42 39,705.03 41,200.00 1,494.97 96.4 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS ( 14,268.00) .00 200.00 200.00 .0 10-5100-2122 TRAINING/DEVELOPMENT .00 3,378.00 27,500.00 24,122.00 12.3 10-5100-2123 MEALS/LODGING/TRAVEL ( 803.00) 1,276.41 500.00 ( 776.41) 255.3 TOTAL PURCHASED SERVICES ( 7,781.58) 52,660.62 75,400.00 22,739.38 69.8 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 15,099.30 87,699.88 80,000.00 ( 7,699.88) 109.6 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 500.09 3,043.36 2,500.00 ( 543.36) 121.7 10-5100-2133 UTILITY SERVICES - NATURAL GAS 194.62 4,216.37 6,200.00 1,983.63 68.0 10-5100-2134 TELECOMMUNICATIONS 1,153.86 12,280.46 10,000.00 ( 2,280.46) 122.8 10-5100-2141 EQUIPMENT - RENT .00 207.36 215.00 7.64 96.5 TOTAL PROPERTY SERVICES 16,947.87 107,447.43 98,915.00 ( 8,532.43) 108.6 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 5,383.31 41,460.85 40,000.00 ( 1,460.85) 103.7 10-5100-2152 ACCOUNTING/AUDITING .00 45,460.00 75,000.00 29,540.00 60.6 10-5100-2153 ARCHITECHT/ENGINEERING/SURVEY .00 202.50 .00 ( 202.50) .0 10-5100-2155 REPAIRS/MAINTENANCE 260.00 11,970.22 5,000.00 ( 6,970.22) 239.4 10-5100-2156 MAINTENANCE AGREEMENT 1,198.56 6,275.69 6,980.00 704.31 89.9 10-5100-2157 INSURANCE 10,686.00 128,889.00 94,250.00 ( 34,639.00) 136.8 10-5100-2158 MISC CONTRACTUAL SERVICES 26,717.22 884,890.54 825,369.00 ( 59,521.54) 107.2 10-5100-2166 COLLECTION FEES .00 .00 75.00 75.00 .0 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE 100.00 930.00 300.00 ( 630.00) 310.0 TOTAL PROFESSIONAL SERVICES 44,345.09 1,120,078.80 1,046,974.00 ( 73,104.80) 107.0 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 3,335.43 17,367.79 12,000.00 ( 5,367.79) 144.7 10-5100-3210 OPERATING SUPPLIES 1,332.12 24,526.69 20,580.00 ( 3,946.69) 119.2 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 7,583.43 .00 ( 7,583.43) .0 10-5100-3230 REFRESHMENT SUPPLIES 333.34 29,438.81 14,400.00 ( 15,038.81) 204.4 10-5100-3235 FUEL 407.06 1,527.29 1,500.00 ( 27.29) 101.8 TOTAL SUPPLIES 5,407.95 80,444.01 48,480.00 ( 31,964.01) 165.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:9 CLAIMS & CONTINGENCY: 10-5100-7601 CLAIMS AGAINST CITY 5,000.00 5,000.00 5,000.00 .00 100.0 10-5100-7606 UNEMPLOYMENT CLAIMS 2,975.00 2,975.00 1,000.00 ( 1,975.00) 297.5 TOTAL CLAIMS & CONTINGENCY 7,975.00 7,975.00 6,000.00 ( 1,975.00) 132.9 HOMELAND SECURITY: 10-5100-9000 CONTINGENCY .00 .00 200,000.00 200,000.00 .0 TOTAL HOMELAND SECURITY .00 .00 200,000.00 200,000.00 .0 TOTAL GENERAL GOVT - NON DEPARTMENTL 153,454.84 1,709,322.85 1,805,794.00 96,471.15 94.7 GENERAL GOVT - CITY COUNCIL PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 1,500.00 18,000.00 18,000.00 .00 100.0 TOTAL PERSONNEL SERVICES 1,500.00 18,000.00 18,000.00 .00 100.0 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 114.77 1,377.24 1,377.00 ( .24) 100.0 10-5101-1025 EMPLOYEE BENEFITS - COMP 26.05 320.42 421.00 100.58 76.1 TOTAL EMPLOYEE BENEFITS 140.82 1,697.66 1,798.00 100.34 94.4 PURCHASED SERVICES: 10-5101-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 8,000.00 8,000.00 .0 10-5101-2122 TRAINING/DEVELOPMENT .00 1,840.00 2,500.00 660.00 73.6 10-5101-2123 MEALS/LODGING/TRAVEL 1,259.94 3,249.83 3,000.00 ( 249.83) 108.3 TOTAL PURCHASED SERVICES 1,259.94 5,089.83 13,500.00 8,410.17 37.7 SUPPLIES: 10-5101-3210 OPERATING SUPPLIES .00 .00 500.00 500.00 .0 TOTAL SUPPLIES .00 .00 500.00 500.00 .0 TOTAL GENERAL GOVT - CITY COUNCIL 2,900.76 24,787.49 33,798.00 9,010.51 73.3 GENERAL GOVT - ADMIN SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:10 PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 40,193.02 471,066.89 514,222.00 43,155.11 91.6 10-5102-1002 SALARIES/WAGES - OVERTIME .00 1,255.69 1,500.00 244.31 83.7 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,203.54 1,294.00 90.46 93.0 10-5102-1006 SALARIES/WAGES - ALLOWANCES 175.00 2,100.00 2,100.00 .00 100.0 TOTAL PERSONNEL SERVICES 40,368.02 475,626.12 519,116.00 43,489.88 91.6 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 3,136.46 37,073.57 40,391.00 3,317.43 91.8 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 11,726.44 131,073.15 170,704.00 39,630.85 76.8 10-5102-1025 EMPLOYEE BENEFITS - COMP 779.10 9,370.38 13,528.00 4,157.62 69.3 10-5102-1026 EMPLOYEE BENEFITS - COMP 631.26 8,996.52 7,661.00 ( 1,335.52) 117.4 10-5102-1029 EMPLOYEE BENEFITS - WY 7,068.02 82,106.76 90,750.00 8,643.24 90.5 TOTAL EMPLOYEE BENEFITS 23,341.28 268,620.38 323,034.00 54,413.62 83.2 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,426.00 3,310.00 1,884.00 43.1 10-5102-2122 TRAINING/DEVELOPMENT 810.00 2,637.86 10,000.00 7,362.14 26.4 10-5102-2123 MEALS/LODGING/TRAVEL 1,753.69 5,524.54 10,600.00 5,075.46 52.1 TOTAL PURCHASED SERVICES 2,563.69 9,588.40 23,910.00 14,321.60 40.1 PROPERTY SERVICES: 10-5102-2134 TELECOMMUNICATIONS 112.94 830.14 .00 ( 830.14) .0 TOTAL PROPERTY SERVICES 112.94 830.14 .00 ( 830.14) .0 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 36.00 250.00 214.00 14.4 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,701.39 1,000.00 ( 701.39) 170.1 TOTAL SUPPLIES .00 1,737.39 1,250.00 ( 487.39) 139.0 TOTAL GENERAL GOVT - ADMIN SERVICES 66,385.93 756,402.43 867,310.00 110,907.57 87.2 GENERAL GOVT - IT PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 111.00 1,061.90 .00 ( 1,061.90) .0 TOTAL PURCHASED SERVICES 111.00 1,061.90 .00 ( 1,061.90) .0 PROFESSIONAL SERVICES: 10-5103-2155 REPAIRS/MAINTENANCE .00 .00 7,600.00 7,600.00 .0 10-5103-2156 MAINTENANCE AGREEMENT .00 19,110.00 38,500.00 19,390.00 49.6 10-5103-2158 MISC CONTRACTUAL SERVICES 1,697.12 103,840.87 189,064.00 85,223.13 54.9 TOTAL PROFESSIONAL SERVICES 1,697.12 122,950.87 235,164.00 112,213.13 52.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:50PM PAGE:11 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 2,371.98 2,400.00 28.02 98.8 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 12,000.00 91,132.38 271,375.00 180,242.62 33.6 TOTAL SUPPLIES 12,000.00 93,504.36 273,775.00 180,270.64 34.2 TOTAL GENERAL GOVT - IT 13,808.12 217,517.13 508,939.00 291,421.87 42.7 GENERAL GOVT - MUNICIPAL COURT PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 4,574.34 57,575.81 56,276.00 ( 1,299.81) 102.3 10-5105-1005 SALARIES/WAGES - LONGEVITY .00 498.73 499.00 .27 100.0 TOTAL PERSONNEL SERVICES 4,574.34 58,074.54 56,775.00 ( 1,299.54) 102.3 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 359.95 4,571.39 14,092.00 9,520.61 32.4 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS 634.01 7,605.48 7,648.00 42.52 99.4 10-5105-1025 EMPLOYEE BENEFITS - COMP 88.29 1,143.53 1,432.00 288.47 79.9 10-5105-1026 EMPLOYEE BENEFITS - COMP 130.98 1,683.12 1,683.00 ( .12) 100.0 10-5105-1029 EMPLOYEE BENEFITS - WY 563.20 7,237.11 7,237.00 ( .11) 100.0 TOTAL EMPLOYEE BENEFITS 1,776.43 22,240.63 32,092.00 9,851.37 69.3 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 195.00 195.00 .0 10-5105-2122 TRAINING/DEVELOPMENT .00 245.00 420.00 175.00 58.3 10-5105-2123 MEALS/LODGING/TRAVEL .00 336.25 540.00 203.75 62.3 TOTAL PURCHASED SERVICES .00 581.25 1,155.00 573.75 50.3 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 5,108.00 32,598.76 32,700.00 101.24 99.7 10-5105-2156 MAINTENANCE AGREEMENT .00 2,598.00 2,400.00 ( 198.00) 108.3 10-5105-2162 COURT SURCHARGES .00 .00 750.00 750.00 .0 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 .00 250.00 250.00 .0 TOTAL PROFESSIONAL SERVICES 5,108.00 35,196.76 36,100.00 903.24 97.5 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES .00 38.90 500.00 461.10 7.8 10-5105-3233 UNIFORMS/CARE .00 .00 150.00 150.00 .0 TOTAL SUPPLIES .00 38.90 650.00 611.10 6.0 TOTAL GENERAL GOVT - MUNICIPAL COURT 11,458.77 116,132.08 126,772.00 10,639.92 91.6 GENERAL GOVT - ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:12 PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 22,255.39 288,999.37 288,151.00 ( 848.37) 100.3 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 944.58 944.00 ( .58) 100.1 10-5106-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 TOTAL PERSONNEL SERVICES 22,330.39 290,843.95 289,995.00 ( 848.95) 100.3 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,754.57 22,879.18 22,817.00 ( 62.18) 100.3 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 3,067.72 36,812.07 37,189.00 376.93 99.0 10-5106-1025 EMPLOYEE BENEFITS - COMP 431.00 5,726.70 7,540.00 1,813.30 76.0 10-5106-1026 EMPLOYEE BENEFITS - COMP 642.49 8,265.48 8,265.00 ( .48) 100.0 10-5106-1029 EMPLOYEE BENEFITS - WY 3,185.44 41,442.47 41,296.00 ( 146.47) 100.4 TOTAL EMPLOYEE BENEFITS 9,081.22 115,125.90 117,107.00 1,981.10 98.3 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 335.00 1,537.00 1,550.00 13.00 99.2 10-5106-2122 TRAINING/DEVELOPMENT .00 1,944.97 2,500.00 555.03 77.8 10-5106-2123 MEALS/LODGING/TRAVEL 1,142.49 3,701.60 6,000.00 2,298.40 61.7 TOTAL PURCHASED SERVICES 1,477.49 7,183.57 10,050.00 2,866.43 71.5 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 199.80 1,247.72 1,250.00 2.28 99.8 TOTAL PROPERTY SERVICES 199.80 1,247.72 1,250.00 2.28 99.8 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 2,595.00 11,793.70 10,000.00 ( 1,793.70) 117.9 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT 179.02 4,199.32 3,150.00 ( 1,049.32) 133.3 10-5106-2158 MISC CONTRACTUAL SERVICES 8,784.14 42,363.07 72,000.00 29,636.93 58.8 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 .00 750.00 750.00 .0 TOTAL PROFESSIONAL SERVICES 11,558.16 58,356.09 86,900.00 28,543.91 67.2 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 332.80 1,946.52 6,600.00 4,653.48 29.5 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5106-3235 FUEL 220.69 800.50 2,000.00 1,199.50 40.0 TOTAL SUPPLIES 553.49 2,747.02 9,600.00 6,852.98 28.6 TOTAL GENERAL GOVT - 45,200.55 475,504.25 514,902.00 39,397.75 92.4 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:13 GOVERNMENTAL ASSISTANCE: 10-5110-8701 COMM PLA .00 .00 100,000.00 100,000.00 .0 10-5110-8702 COMM CLUB/GEN 10,000.00 60,000.00 60,000.00 .00 100.0 10-5110-8703 COMM RCREATN .00 30,000.00 30,000.00 .00 100.0 10-5110-8705 COMM COUNTRY .00 .00 30,000.00 30,000.00 .0 10-5110-8707 COMM DVL 833.34 4,999.92 5,000.00 .08 100.0 10-5110-8709 COMM 3,333.32 19,999.92 20,000.00 .08 100.0 10-5110-8714 COMM ENTERPRIS 35,416.65 84,999.96 85,000.00 .04 100.0 10-5110-8723 COMM HOCKEY 24,000.00 24,000.00 24,000.00 .00 100.0 10-5110-8730 COMM INC 1,521.33 11,703.71 .00 ( 11,703.71) .0 10-5110-8734 COMM PEAK 16,270.97 84,646.84 85,000.00 353.16 99.6 10-5110-8746 COMM & GIRLS 4,166.66 24,999.96 25,000.00 .04 100.0 10-5110-8750 COMM ADVOC .00 3,000.00 4,000.00 1,000.00 75.0 10-5110-8755 COMM HANDS .00 8,000.00 20,000.00 12,000.00 40.0 10-5110-8757 COMM SERV-KINGS PORTION .00 ( 3,272.64) 25,000.00 28,272.64 ( 13.1) 10-5110-8759 COMM SRVC CENTER 13,389.66 20,000.00 20,000.00 .00 100.0 10-5110-8763 COMM SRVC 608.10 6,113.11 35,250.00 29,136.89 17.3 TOTAL GOVERNMENTAL ASSISTANCE 109,540.03 379,190.78 568,250.00 189,059.22 66.7 HOMELAND SECURITY: 10-5110-9000 CONTINGENCY .00 .00 10,000.00 10,000.00 .0 TOTAL HOMELAND SECURITY .00 .00 10,000.00 10,000.00 .0 TOTAL COMMUNITY SERVICE CONTRACTS 109,540.03 379,190.78 578,250.00 199,059.22 65.6 PUBLIC SERVICE CONTRACTS GOVERNMENTAL ASSISTANCE: 10-5111-8744 COMM 80,490.26 264,691.87 407,100.00 142,408.13 65.0 10-5111-8760 COMM SRVC JUSTICE 80,711.25 831,278.68 1,000,000.00 168,721.32 83.1 TOTAL GOVERNMENTAL ASSISTANCE 161,201.51 1,095,970.55 1,407,100.00 311,129.45 77.9 TOTAL PUBLIC SERVICE CONTRACTS 161,201.51 1,095,970.55 1,407,100.00 311,129.45 77.9 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 14,209.76 180,858.13 175,335.00 ( 5,523.13) 103.2 10-5201-1002 SALARIES/WAGES - OVERTIME .00 303.92 100.00 ( 203.92) 303.9 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 250.71 250.00 ( .71) 100.3 10-5201-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 TOTAL PERSONNEL SERVICES 14,284.76 182,312.76 176,585.00 ( 5,727.76) 103.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:14 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 1,096.14 13,989.95 13,552.00 ( 437.95) 103.2 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 3,226.33 38,700.93 39,358.00 657.07 98.3 10-5201-1025 EMPLOYEE BENEFITS - COMP ( 2,699.31) 3,885.23 4,928.00 1,042.77 78.8 10-5201-1026 EMPLOYEE BENEFITS - COMP 43.66 561.00 561.00 .00 100.0 10-5201-1029 EMPLOYEE BENEFITS - WY 2,417.50 30,985.60 30,175.00 ( 810.60) 102.7 TOTAL EMPLOYEE BENEFITS 4,084.32 88,122.71 88,574.00 451.29 99.5 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 540.00 680.00 140.00 79.4 10-5201-2122 TRAINING/DEVELOPMENT .00 1,740.00 1,480.00 ( 260.00) 117.6 10-5201-2123 MEALS/LODGING/TRAVEL ( 1.36) 3,931.11 3,810.00 ( 121.11) 103.2 TOTAL PURCHASED SERVICES ( 1.36) 6,211.11 5,970.00 ( 241.11) 104.0 PROPERTY SERVICES: 10-5201-2131 UTILITY SERVICES - ELECTRICITY 282.63 1,654.25 2,000.00 345.75 82.7 10-5201-2134 TELECOMMUNICATIONS 40.01 480.12 494.00 13.88 97.2 TOTAL PROPERTY SERVICES 322.64 2,134.37 2,494.00 359.63 85.6 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 250.00 250.00 .0 10-5201-2156 MAINTENANCE AGREEMENT 238.91 1,343.65 1,200.00 ( 143.65) 112.0 10-5201-2158 MISC CONTRACTUAL SERVICES 100.00 2,400.00 4,550.00 2,150.00 52.8 10-5201-2161 INCARCERATION CONTRACT 277.50 1,710.00 2,500.00 790.00 68.4 TOTAL PROFESSIONAL SERVICES 616.41 5,453.65 8,500.00 3,046.35 64.2 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 2,646.16 5,456.93 8,550.00 3,093.07 63.8 10-5201-3233 UNIFORMS/CARE .00 129.37 600.00 470.63 21.6 10-5201-3235 FUEL 124.06 931.49 650.00 ( 281.49) 143.3 TOTAL SUPPLIES 2,770.22 6,517.79 9,800.00 3,282.21 66.5 TOTAL POLICE DEPT - ADMINISTRATION 22,076.99 290,752.39 291,923.00 1,170.61 99.6 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 99,878.93 1,240,519.64 1,345,245.00 104,725.36 92.2 10-5202-1002 SALARIES/WAGES - OVERTIME 9,137.07 68,723.36 65,000.00 ( 3,723.36) 105.7 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 2,357.89 2,359.00 1.11 100.0 10-5202-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 10-5202-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 4,455.00 4,455.00 .0 TOTAL PERSONNEL SERVICES 109,066.00 1,312,200.89 1,417,659.00 105,458.11 92.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:15 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 8,396.63 101,392.69 109,547.00 8,154.31 92.6 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 31,349.22 363,270.45 406,212.00 42,941.55 89.4 10-5202-1025 EMPLOYEE BENEFITS - COMP 2,104.96 25,821.58 36,743.00 10,921.42 70.3 10-5202-1026 EMPLOYEE BENEFITS - COMP 684.58 13,476.63 14,330.00 853.37 94.0 10-5202-1029 EMPLOYEE BENEFITS - WY 18,520.12 222,980.27 241,076.00 18,095.73 92.5 TOTAL EMPLOYEE BENEFITS 61,055.51 726,941.62 807,908.00 80,966.38 90.0 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 50.00 515.00 1,154.00 639.00 44.6 10-5202-2122 TRAINING/DEVELOPMENT 500.00 15,428.00 18,000.00 2,572.00 85.7 10-5202-2123 MEALS/LODGING/TRAVEL 1,871.58 11,939.36 16,000.00 4,060.64 74.6 TOTAL PURCHASED SERVICES 2,421.58 27,882.36 35,154.00 7,271.64 79.3 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,531.23 18,421.01 18,390.00 ( 31.01) 100.2 TOTAL PROPERTY SERVICES 1,531.23 18,421.01 18,390.00 ( 31.01) 100.2 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE 653.37 13,680.81 8,000.00 ( 5,680.81) 171.0 10-5202-2156 MAINTENANCE AGREEMENT 218.54 17,270.89 13,838.00 ( 3,432.89) 124.8 10-5202-2158 MISC CONTRACTUAL SERVICES .00 1,850.00 4,372.00 2,522.00 42.3 TOTAL PROFESSIONAL SERVICES 871.91 32,801.70 26,210.00 ( 6,591.70) 125.2 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 .00 300.00 300.00 .0 10-5202-3210 OPERATING SUPPLIES 2,300.01 39,100.18 39,600.00 499.82 98.7 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 13,780.70 13,206.00 ( 574.70) 104.4 10-5202-3233 UNIFORMS/CARE .00 19,528.05 18,500.00 ( 1,028.05) 105.6 10-5202-3235 FUEL 5,714.85 34,330.32 16,995.00 ( 17,335.32) 202.0 TOTAL SUPPLIES 8,014.86 106,739.25 88,601.00 ( 18,138.25) 120.5 TOTAL POLICE DEPT - PATROL 182,961.09 2,224,986.83 2,393,922.00 168,935.17 92.9 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 14,535.15 185,992.05 183,794.00 ( 2,198.05) 101.2 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,401.71 1,402.00 .29 100.0 10-5301-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 TOTAL PERSONNEL SERVICES 14,610.15 188,293.76 186,096.00 ( 2,197.76) 101.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:16 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 1,120.42 14,442.01 14,296.00 ( 146.01) 101.0 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 3,047.67 36,560.26 36,951.00 390.74 98.9 10-5301-1025 EMPLOYEE BENEFITS - COMP 281.97 3,706.07 4,859.00 1,152.93 76.3 10-5301-1029 EMPLOYEE BENEFITS - WY 2,500.06 31,990.73 31,613.00 ( 377.73) 101.2 TOTAL EMPLOYEE BENEFITS 6,950.12 86,699.07 87,719.00 1,019.93 98.8 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 239.00 315.00 76.00 75.9 10-5301-2122 TRAINING/DEVELOPMENT .00 395.00 665.00 270.00 59.4 10-5301-2123 MEALS/LODGING/TRAVEL .00 316.42 600.00 283.58 52.7 TOTAL PURCHASED SERVICES .00 950.42 1,580.00 629.58 60.2 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 1,224.52 9,378.24 10,700.00 1,321.76 87.7 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 892.85 4,552.65 5,000.00 447.35 91.1 10-5301-2133 UTILITY SERVICES - NATURAL GAS 402.66 11,452.37 9,500.00 ( 1,952.37) 120.6 10-5301-2134 TELECOMMUNICATIONS 77.79 927.75 650.00 ( 277.75) 142.7 TOTAL PROPERTY SERVICES 2,597.82 26,311.01 25,850.00 ( 461.01) 101.8 PROFESSIONAL SERVICES: 10-5301-2153 ARCHITECT/ENGINEERING/SURVEING .00 .00 2,000.00 2,000.00 .0 10-5301-2155 REPAIRS/MAINTENANCE .00 105.00 1,500.00 1,395.00 7.0 10-5301-2156 MAINTENANCE AGREEMENT 84.17 471.63 400.00 ( 71.63) 117.9 TOTAL PROFESSIONAL SERVICES 84.17 576.63 3,900.00 3,323.37 14.8 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 345.76 2,951.08 7,400.00 4,448.92 39.9 10-5301-3230 REFRESHMENT SUPPLIES .00 220.50 1,250.00 1,029.50 17.6 10-5301-3235 FUEL 218.69 1,193.90 1,500.00 306.10 79.6 TOTAL SUPPLIES 564.45 4,365.48 10,150.00 5,784.52 43.0 TOTAL PUBLIC WORKS - ADMINISTRATION 24,806.71 307,196.37 315,295.00 8,098.63 97.4 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 17,661.92 208,316.59 230,300.00 21,983.41 90.5 10-5302-1002 SALARIES/WAGES - OVERTIME .00 806.97 500.00 ( 306.97) 161.4 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 740.85 741.00 .15 100.0 10-5302-1006 SALARIES/WAGES-ALLOWANCE 50.00 600.00 600.00 .00 100.0 10-5302-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 452.00 452.00 .0 TOTAL PERSONNEL SERVICES 17,711.92 210,464.41 232,593.00 22,128.59 90.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:17 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,359.54 16,164.09 17,853.00 1,688.91 90.5 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 8,640.84 82,366.79 88,154.00 5,787.21 93.4 10-5302-1025 EMPLOYEE BENEFITS - COMP 341.85 4,130.06 6,056.00 1,925.94 68.2 10-5302-1026 EMPLOYEE BENEFITS - COMP .00 51.65 .00 ( 51.65) .0 10-5302-1029 EMPLOYEE BENEFITS - WY 3,037.86 35,969.27 39,698.00 3,728.73 90.6 TOTAL EMPLOYEE BENEFITS 13,380.09 138,681.86 151,761.00 13,079.14 91.4 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 4,336.40 4,350.00 13.60 99.7 10-5302-2122 TRAINING/DEVELOPMENT .00 4,020.00 2,400.00 ( 1,620.00) 167.5 TOTAL PURCHASED SERVICES .00 8,356.40 6,750.00 ( 1,606.40) 123.8 PROPERTY SERVICES: 10-5302-2141 EQUIPMENT RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES .00 .00 200.00 200.00 .0 PROFESSIONAL SERVICES: 10-5302-2155 REPAIRS/MAINTENANCE .00 852.00 2,500.00 1,648.00 34.1 TOTAL PROFESSIONAL SERVICES .00 852.00 2,500.00 1,648.00 34.1 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 520.71 16,504.85 16,000.00 ( 504.85) 103.2 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 2,583.44 12,422.47 13,925.00 1,502.53 89.2 10-5302-3235 FUEL 369.20 2,292.68 1,500.00 ( 792.68) 152.9 10-5302-3237 OIL/LUBE/FLUIDS 5.99 12,217.65 14,000.00 1,782.35 87.3 TOTAL SUPPLIES 3,479.34 43,437.65 45,425.00 1,987.35 95.6 TOTAL PUBLIC WORKS - SHOP 34,571.35 401,792.32 439,229.00 37,436.68 91.5 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 20,135.17 258,135.16 257,700.00 ( 435.16) 100.2 10-5304-1002 SALARIES/WAGES - OVERTIME 165.82 798.66 2,000.00 1,201.34 39.9 10-5304-1004 SALARIES/WAGES - TEMPORARY 15,478.19 44,201.91 84,000.00 39,798.09 52.6 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 1,111.05 1,111.00 ( .05) 100.0 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 35,804.18 304,546.78 345,111.00 40,564.22 88.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:18 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 2,741.33 23,426.87 26,431.00 3,004.13 88.6 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 9,721.91 116,982.42 116,920.00 ( 62.42) 100.1 10-5304-1025 EMPLOYEE BENEFITS - COMP 690.99 6,014.16 8,983.00 2,968.84 67.0 10-5304-1026 EMPLOYEE BENEFITS - COMP .00 1,290.20 .00 ( 1,290.20) .0 10-5304-1029 EMPLOYEE BENEFITS - WY 3,491.78 44,456.80 44,668.00 211.20 99.5 TOTAL EMPLOYEE BENEFITS 16,646.01 192,170.45 197,002.00 4,831.55 97.6 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 33.75 602.75 750.00 147.25 80.4 10-5304-2122 TRAINING/DEVELOPMENT 230.00 1,658.73 1,900.00 241.27 87.3 10-5304-2123 MEALS/LODGING/TRAVEL .00 491.65 1,500.00 1,008.35 32.8 TOTAL PURCHASED SERVICES 263.75 2,753.13 4,150.00 1,396.87 66.3 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 3,180.98 21,814.83 20,000.00 ( 1,814.83) 109.1 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 20,890.03 75,869.38 95,000.00 19,130.62 79.9 10-5304-2133 NATURAL GAS, PROPANE 68.52 474.36 500.00 25.64 94.9 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 24,139.53 98,158.57 116,500.00 18,341.43 84.3 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE .00 4,378.21 5,000.00 621.79 87.6 10-5304-2156 MAINTENANCE AGREEMENT .00 1,608.00 7,340.00 5,732.00 21.9 10-5304-2158 MISC CONTRACTUAL SERVICES 440.00 36,502.50 45,000.00 8,497.50 81.1 TOTAL PROFESSIONAL SERVICES 440.00 42,488.71 57,340.00 14,851.29 74.1 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 2,067.60 46,397.68 45,000.00 ( 1,397.68) 103.1 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,348.72 2,500.00 1,151.28 54.0 10-5304-3235 FUEL 2,605.25 12,448.59 10,000.00 ( 2,448.59) 124.5 TOTAL SUPPLIES 4,672.85 60,194.99 57,500.00 ( 2,694.99) 104.7 TOTAL PUBLIC WORKS - PARKS 81,966.32 700,312.63 777,603.00 77,290.37 90.1 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 24,651.16 313,479.95 314,029.00 549.05 99.8 10-5305-1002 SALARIES/WAGES - OVERTIME .00 2,672.45 4,000.00 1,327.55 66.8 10-5305-1004 SALARIES/WAGES - TEMPORARY 2,360.56 13,536.71 16,800.00 3,263.29 80.6 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 1,273.31 1,273.00 ( .31) 100.0 10-5305-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 27,036.72 331,262.42 336,402.00 5,139.58 98.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:19 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 2,070.60 25,371.16 25,765.00 393.84 98.5 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 8,434.37 101,176.48 127,118.00 25,941.52 79.6 10-5305-1025 EMPLOYEE BENEFITS - COMP 521.82 6,532.48 8,757.00 2,224.52 74.6 10-5305-1029 EMPLOYEE BENEFITS - WY 4,239.99 54,378.25 54,701.00 322.75 99.4 TOTAL EMPLOYEE BENEFITS 15,266.78 187,458.37 216,341.00 28,882.63 86.7 PURCHASED SERVICES: 10-5305-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 229.00 .00 ( 229.00) .0 10-5305-2122 TRAINING/DEVELOPMENT .00 1,910.23 2,400.00 489.77 79.6 TOTAL PURCHASED SERVICES .00 2,139.23 2,400.00 260.77 89.1 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 4,560.02 34,480.64 60,000.00 25,519.36 57.5 10-5305-2158 MISC CONTRACTUAL SERVICES 14,319.20 13,059.27 64,700.00 51,640.73 20.2 TOTAL PROFESSIONAL SERVICES 18,879.22 47,539.91 124,700.00 77,160.09 38.1 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 22,041.91 71,106.78 73,900.00 2,793.22 96.2 10-5305-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,294.69 2,400.00 105.31 95.6 10-5305-3235 FUEL 4,540.82 32,955.30 25,000.00 ( 7,955.30) 131.8 TOTAL SUPPLIES 26,582.73 106,356.77 101,300.00 ( 5,056.77) 105.0 TOTAL PUBLIC WORKS - STREETS/ALLEYS 87,765.45 674,756.70 781,143.00 106,386.30 86.4 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 12,457.60 160,789.64 161,031.00 241.36 99.9 10-5306-1002 SALARIES/WAGES - OVERTIME .00 608.52 1,500.00 891.48 40.6 10-5306-1004 SALARIES/WAGES - TEMPORARY .00 8,160.00 16,800.00 8,640.00 48.6 10-5306-1005 SALARIES/WAGES - LONGEVITY .00 1,220.75 1,221.00 .25 100.0 10-5306-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5306-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 449.00 449.00 .0 TOTAL PERSONNEL SERVICES 12,482.60 171,078.91 181,301.00 10,222.09 94.4 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 955.03 13,295.20 13,899.00 603.80 95.7 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 5,406.88 64,873.99 65,032.00 158.01 99.8 10-5306-1025 EMPLOYEE BENEFITS - COMP 240.90 3,378.22 4,712.00 1,333.78 71.7 10-5306-1026 EMPLOYEE BENEFITS - COMP .00 2,667.61 .00 ( 2,667.61) .0 10-5306-1029 EMPLOYEE BENEFITS - WY 2,142.69 27,760.42 27,955.00 194.58 99.3 TOTAL EMPLOYEE BENEFITS 8,745.50 111,975.44 111,598.00 ( 377.44) 100.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:20 PURCHASED SERVICES: 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 100.00 100.00 .00 100.0 10-5306-2122 TRAINING/DEVELOPMENT .00 350.00 400.00 50.00 87.5 TOTAL PURCHASED SERVICES .00 450.00 500.00 50.00 90.0 PROPERTY SERVICES: 10-5306-2131 UTILITY SERVICES - ELECTRICITY 448.90 3,028.99 3,500.00 471.01 86.5 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 14,394.24 47,328.46 60,000.00 12,671.54 78.9 10-5306-2133 UTILITY SERVICES - NATURAL GAS 90.08 1,782.93 1,600.00 ( 182.93) 111.4 10-5306-2134 TELECOMMUNICATIONS 71.78 624.46 1,000.00 375.54 62.5 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 15,005.00 52,764.84 66,300.00 13,535.16 79.6 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE 677.34 917.08 1,500.00 582.92 61.1 10-5306-2156 MAINTENANCE AGREEMENT .00 981.00 1,000.00 19.00 98.1 10-5306-2158 MISC CONTRACTUAL SERVICES .00 7,000.00 8,500.00 1,500.00 82.4 TOTAL PROFESSIONAL SERVICES 677.34 8,898.08 11,000.00 2,101.92 80.9 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 2,697.84 9,892.63 11,500.00 1,607.37 86.0 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 315.98 1,000.00 684.02 31.6 10-5306-3235 FUEL 575.18 3,295.81 2,500.00 ( 795.81) 131.8 TOTAL SUPPLIES 3,273.02 13,504.42 15,000.00 1,495.58 90.0 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND .00 250.00 .00 ( 250.00) .0 TOTAL CAPITALIZED EXPENDITURES .00 250.00 .00 ( 250.00) .0 TOTAL PUBLIC WORKS - CEMETERY 40,183.46 358,921.69 385,699.00 26,777.31 93.1 PUBLIC WORKS - SWIM POOL PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 1,020.71 6,532.13 7,000.00 467.87 93.3 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 1,654.01 5,872.33 13,000.00 7,127.67 45.2 10-5307-2133 UTILITY SERVICES - NATURAL GAS 2,123.34 8,566.28 10,000.00 1,433.72 85.7 10-5307-2134 TELECOMMUNICATIONS .00 345.69 1,500.00 1,154.31 23.1 TOTAL PROPERTY SERVICES 4,798.06 21,316.43 31,500.00 10,183.57 67.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:21 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE 171.48 984.18 5,000.00 4,015.82 19.7 10-5307-2158 MISC CONTRACTUAL SERVICES .00 76,664.28 134,500.00 57,835.72 57.0 TOTAL PROFESSIONAL SERVICES 171.48 77,648.46 139,500.00 61,851.54 55.7 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 12,155.38 17,065.19 12,000.00 ( 5,065.19) 142.2 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 2,500.00 2,500.00 .0 TOTAL SUPPLIES 12,155.38 17,065.19 14,500.00 ( 2,565.19) 117.7 TOTAL PUBLIC WORKS - SWIM POOL 17,124.92 116,030.08 185,500.00 69,469.92 62.6 OPERATING TRANSFERS - OUT FINANCIAL: 10-5998-4342 TRANSFER TO BROWNFIELD GRANT 956.10 956.10 2,496.00 1,539.90 38.3 TOTAL FINANCIAL 956.10 956.10 2,496.00 1,539.90 38.3 OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE 125,000.00 500,000.00 500,000.00 .00 100.0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ 7,454.25 29,817.00 29,817.00 .00 100.0 10-5998-4332 TRANSFER TO SEWER .00 .00 820,000.00 820,000.00 .0 10-5998-4341 TRANSFER TO ECONOMIC DEVELOPME 468,750.00 1,875,000.00 1,875,000.00 .00 100.0 10-5998-4350 TRANSFER TO FIRE EQUIPMENT 62,500.00 250,000.00 250,000.00 .00 100.0 10-5998-4354 TRANSFER TO TRAIN CAR RESTORAT 6,250.00 25,000.00 25,000.00 .00 100.0 10-5998-4355 TRANSFER TO POOL IMPROVEMENT 62,500.00 250,000.00 250,000.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 450.00 1,800.00 1,800.00 .00 100.0 TOTAL OPERATING TRANSFERS 732,904.25 2,931,617.00 3,751,617.00 820,000.00 78.1 TOTAL OPERATING TRANSFERS - OUT 733,860.35 2,932,573.10 3,754,113.00 821,539.90 78.1 TOTAL FUND EXPENDITURES 1,789,267.15 12,782,149.67 15,167,292.00 2,385,142.33 84.3 NET REVENUE OVER EXPENDITURES 1,065,862.82 12,791,985.58 ( 797,336.00) ( 13,589,321.58) 1604.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:22 ASSETS CURRENT ASSETS: CASH: 11-10000116 CASH ALLOC FR COMBINED FUND 1,779,769.63 TOTAL CASH 1,779,769.63 ACCOUNTS RECEIVABLE: 11-10000139 ACCRUED INTEREST RECEIVABLE 2,197.43 TOTAL ACCOUNTS RECEIVABLE 2,197.43 TOTAL CURRENT ASSETS 1,781,967.06 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,781,967.06 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 11-30000300 FUND BALANCE/BEGINNING OF YEAR ( 1,025,007.06) 11-30000301 RESERVE FOR 4TH STREET PROJECT 2,622,126.12 TOTAL CAPITAL ASSETS 1,597,119.06 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 184,848.00 BALANCE - CURRENT DATE 1,781,967.06 TOTAL NET ASSETS 1,781,967.06 TOTAL LIABILITIES AND NET ASSETS 1,781,967.06 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 IMPACT ASSISTANCE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:51PM PAGE:23 IMPACT ASSISTANCE - REVENUE MISC LOCAL REVENUE: 11-4110-1140 INTEREST INCOME .00 15,524.68 .00 ( 15,524.68) .0 TOTAL MISC LOCAL REVENUE .00 15,524.68 .00 ( 15,524.68) .0 STATE REVENUE: 11-4110-3239 IMPACT ASST-CEDAR SPRINGS 29,411.76 205,882.32 .00 ( 205,882.32) .0 TOTAL STATE REVENUE 29,411.76 205,882.32 .00 ( 205,882.32) .0 TOTAL IMPACT ASSISTANCE - REVENUE 29,411.76 221,407.00 .00 ( 221,407.00) .0 TOTAL FUND REVENUE 29,411.76 221,407.00 .00 ( 221,407.00) .0 IMPACT ASSISTANCE - EXPENDITUR OPERATING TRANSFERS: 11-5110-4347 TRANSFER TO EQUIPMENT RESERVE 36,559.00 36,559.00 36,559.00 .00 100.0 11-5110-4356 TRANSFER TO STREET IMPROVEMENT .00 .00 1,545,110.00 1,545,110.00 .0 TOTAL OPERATING TRANSFERS 36,559.00 36,559.00 1,581,669.00 1,545,110.00 2.3 TOTAL IMPACT ASSISTANCE - EXPENDITUR 36,559.00 36,559.00 1,581,669.00 1,545,110.00 2.3 TOTAL FUND EXPENDITURES 36,559.00 36,559.00 1,581,669.00 1,545,110.00 2.3 NET REVENUE OVER EXPENDITURES ( 7,147.24) 184,848.00 ( 1,581,669.00) ( 1,766,517.00) 11.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:52PM PAGE:24 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND ( 25,463.52) TOTAL CASH ( 25,463.52) ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 57,499.18 TOTAL ACCOUNTS RECEIVABLE 57,499.18 TOTAL CURRENT ASSETS 32,035.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 32,035.66 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 120.00 TOTAL ACCOUNTS PAYABLE 120.00 TOTAL CURRENT LIABILITIES 120.00 TOTAL LIABILITIES 120.00 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 38,359.52 TOTAL CAPITAL ASSETS 38,359.52 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 6,443.86) BALANCE - CURRENT DATE 31,915.66 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:52PM PAGE:25 TOTAL NET ASSETS 31,915.66 TOTAL LIABILITIES AND NET ASSETS 32,035.66 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:52PM PAGE:26 RURAL VIOLENT CRIME GRANT-REV FEDERAL REVENUE SOURCES: 13-4820-4294 RURAL VIOLENT CRIME REDUCTION .00 81,145.20 100,129.00 18,983.80 81.0 TOTAL FEDERAL REVENUE SOURCES .00 81,145.20 100,129.00 18,983.80 81.0 TOTAL RURAL VIOLENT CRIME GRANT-REV .00 81,145.20 100,129.00 18,983.80 81.0 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 572.21 572.21 7,769.00 7,196.79 7.4 TOTAL FEDERAL REVENUE SOURCES 572.21 572.21 7,769.00 7,196.79 7.4 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 572.21 572.21 7,769.00 7,196.79 7.4 SRO PROGRAM - REVENUE MISC LOCAL REVENUE: 13-4830-1001 REIMBURSEMENT-CCSD#1-SRO 3,163.66 28,472.94 28,473.00 .06 100.0 TOTAL MISC LOCAL REVENUE 3,163.66 28,472.94 28,473.00 .06 100.0 FEDERAL REVENUE SOURCES: 13-4830-4283 FED BUREAU JUSTICE ADMIN - SRO 16,980.20 55,511.86 56,087.00 575.14 99.0 TOTAL FEDERAL REVENUE SOURCES 16,980.20 55,511.86 56,087.00 575.14 99.0 TRANSFERS IN: 13-4830-5510 TRANSFER FROM GENERAL FUND 28,473.00 28,473.00 28,473.00 .00 100.0 TOTAL TRANSFERS IN 28,473.00 28,473.00 28,473.00 .00 100.0 TOTAL SRO PROGRAM - REVENUE 48,616.86 112,457.80 113,033.00 575.20 99.5 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 2,550.00 8,917.41 8,603.00 ( 314.41) 103.7 TOTAL STATE REVENUE 2,550.00 8,917.41 8,603.00 ( 314.41) 103.7 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:53PM PAGE:27 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE 2,550.00 8,917.41 8,603.00 ( 314.41) 103.7 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 .00 1,344.00 1,344.00 .0 TOTAL FEDERAL REVENUE SOURCES .00 .00 1,344.00 1,344.00 .0 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND ( 21,018.75) 1,344.00 1,344.00 .00 100.0 TOTAL TRANSFERS IN ( 21,018.75) 1,344.00 1,344.00 .00 100.0 TOTAL BULLET PROOF VEST - REVENUE ( 21,018.75) 1,344.00 2,688.00 1,344.00 50.0 DEPT OF JUSTICE-BODY CAMS FEDERAL REVENUE SOURCES: 13-4898-4288 WY DEPT OF HOMELAND SECURITY 47,135.98 47,135.98 47,136.00 .02 100.0 TOTAL FEDERAL REVENUE SOURCES 47,135.98 47,135.98 47,136.00 .02 100.0 TOTAL DEPT OF JUSTICE-BODY CAMS 47,135.98 47,135.98 47,136.00 .02 100.0 TOTAL FUND REVENUE 77,856.30 251,572.60 279,358.00 27,785.40 90.1 RURAL VIOLENT CRIME REDUCTION PERSONNEL SERVICES: 13-5820-1001 SALARIES/WAGES - REGULAR .00 .00 26,986.00 26,986.00 .0 13-5820-1002 SALARIES/WAGES - OVERTIME .00 5,871.47 .00 ( 5,871.47) .0 TOTAL PERSONNEL SERVICES .00 5,871.47 26,986.00 21,114.53 21.8 EMPLOYEE BENEFITS: 13-5820-1021 EMPLOYEES BENEFITS - SCL .00 449.16 2,064.00 1,614.84 21.8 13-5820-1023 EMPLOYEE BENEFITS - HEALTH INS .00 375.10 701.00 325.90 53.5 13-5820-1025 EMPLOYEE BENEFITS - COMP .00 121.86 702.00 580.14 17.4 13-5820-1029 EMPLOYEE BENEFITS - WY .00 267.88 4,642.00 4,374.12 5.8 TOTAL EMPLOYEE BENEFITS .00 1,214.00 8,109.00 6,895.00 15.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:53PM PAGE:28 PURCHASED SERVICES: 13-5820-2122 TRAINING/DEVELOPMENT .00 .00 9,084.00 9,084.00 .0 TOTAL PURCHASED SERVICES .00 .00 9,084.00 9,084.00 .0 SUPPLIES: 13-5820-3220 EQUIPMENT/TOOLS NON CAPITALIZE .00 44,000.00 21,950.00 ( 22,050.00) 200.5 TOTAL SUPPLIES .00 44,000.00 21,950.00 ( 22,050.00) 200.5 CAPITALIZED EXPENDITURES: 13-5820-6547 EQUIPMENT/FURNITURE .00 37,336.32 34,000.00 ( 3,336.32) 109.8 TOTAL CAPITALIZED EXPENDITURES .00 37,336.32 34,000.00 ( 3,336.32) 109.8 TOTAL RURAL VIOLENT CRIME REDUCTION .00 88,421.79 100,129.00 11,707.21 88.3 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR 173.14 4,289.70 6,095.00 1,805.30 70.4 TOTAL PERSONNEL SERVICES 173.14 4,289.70 6,095.00 1,805.30 70.4 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL 13.24 328.01 467.00 138.99 70.2 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS 104.08 634.60 .00 ( 634.60) .0 13-5821-1025 EMPLOYEE BENEFITS - COMP 3.34 88.10 159.00 70.90 55.4 13-5821-1029 EMPLOYEE BENEFITS - WY 29.78 700.68 1,048.00 347.32 66.9 TOTAL EMPLOYEE BENEFITS 150.44 1,751.39 1,674.00 ( 77.39) 104.6 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE 323.58 6,041.09 7,769.00 1,727.91 77.8 SCHOOL RESOURCE OFFICER PERSONNEL SERVICES: 13-5830-1001 SALARIES/WAGES - REGULAR 4,596.29 65,447.45 66,219.00 771.55 98.8 13-5830-1002 SALARIES/WAGES - OVERTIME 559.01 1,515.01 2,500.00 984.99 60.6 13-5830-1005 SALARIES/WAGES - LONGEVITY .00 130.82 131.00 .18 99.9 TOTAL PERSONNEL SERVICES 5,155.30 67,093.28 68,850.00 1,756.72 97.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:53PM PAGE:29 EMPLOYEE BENEFITS: 13-5830-1021 EMPLOYEE BENEFITS - SCL 394.38 5,132.63 5,267.00 134.37 97.5 13-5830-1023 EMPLOYEE BENEFITS - HEALTH INS 2,140.00 25,680.00 25,736.00 56.00 99.8 13-5830-1025 EMPLOYEE BENEFITS - COMP 99.50 1,320.86 1,790.00 469.14 73.8 13-5830-1029 EMPLOYEE BENEFITS - WY 886.71 11,565.63 11,390.00 ( 175.63) 101.5 TOTAL EMPLOYEE BENEFITS 3,520.59 43,699.12 44,183.00 483.88 98.9 TOTAL SCHOOL RESOURCE OFFICER 8,675.89 110,792.40 113,033.00 2,240.60 98.0 OJJDP-UNDERAGE ENFORCEMENT PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 247.29 1,057.29 6,750.00 5,692.71 15.7 TOTAL PERSONNEL SERVICES 247.29 1,057.29 6,750.00 5,692.71 15.7 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 18.92 80.98 516.00 435.02 15.7 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS 173.81 308.25 .00 ( 308.25) .0 13-5831-1025 EMPLOYEE BENEFITS - COMP 4.77 20.85 176.00 155.15 11.9 13-5831-1029 EMPLOYEE BENEFITS - WY 42.53 181.83 1,161.00 979.17 15.7 TOTAL EMPLOYEE BENEFITS 240.03 591.91 1,853.00 1,261.09 31.9 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 120.00 1,288.00 .00 ( 1,288.00) .0 TOTAL SUPPLIES 120.00 1,288.00 .00 ( 1,288.00) .0 TOTAL OJJDP-UNDERAGE ENFORCEMENT 607.32 2,937.20 8,603.00 5,665.80 34.1 BULLET PROOF VEST PROTECTION SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 2,688.00 2,687.50 ( .50) 100.0 TOTAL SUPPLIES .00 2,688.00 2,687.50 ( .50) 100.0 TOTAL BULLET PROOF VEST PROTECTION .00 2,688.00 2,687.50 ( .50) 100.0 DEPT OF JUSTICE-BODY CAMS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:53PM PAGE:30 SUPPLIES: 13-5898-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 47,135.98 47,136.00 .02 100.0 TOTAL SUPPLIES .00 47,135.98 47,136.00 .02 100.0 TOTAL DEPT OF JUSTICE-BODY CAMS .00 47,135.98 47,136.00 .02 100.0 TOTAL FUND EXPENDITURES 9,606.79 258,016.46 279,357.50 21,341.04 92.4 NET REVENUE OVER EXPENDITURES 68,249.51 ( 6,443.86) .50 6,444.36 (128877 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:31 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 722,865.65 31-10000118 MONEY MARKET ACCOUNT 124,559.75 TOTAL CASH 847,425.40 INVESTMENTS: 31-10000120 INVESTMENT POOL 4,254,046.58 31-10000122 TIME DEPOSITS - SHORT TERM 8,153,430.14 TOTAL INVESTMENTS 12,407,476.72 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 8,821.03 31-10000132 ACCOUNTS RECEIVABLE - EOY ( 29,140.02) 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 355,423.76 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,619.15) 31-10000139 ACCRUED INTEREST RECEIVABLE 5,884.60 31-10000156 DUE FROM OTHER FUNDS 29,140.02 TOTAL ACCOUNTS RECEIVABLE 367,510.24 TOTAL CURRENT ASSETS 13,622,412.36 FIXED ASSETS: 31-10000181 BUILDINGS 13,467,917.78 31-10000182 ACCUMULATED - BUILDINGS ( 7,519,578.55) 31-10000183 VEHICLES 356,773.40 31-10000184 ACCUMULATED - VEHICLES ( 350,845.89) 31-10000185 EQUIPMENT 759,576.13 31-10000186 ACCUMULATED - EQUIPMENT ( 502,955.52) 31-10000188 IMPROVEMENTS OTHER THAN BLDG 21,841,673.60 31-10000189 ACCUMULATED OT BLDG ( 4,913,867.44) TOTAL FIXED ASSETS 23,138,693.51 OTHER ASSETS: 31-10000190 ACCUMULATED ( 1,850,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 1,610,008.63 31-10006100 DEFERRED OUTFLOW OF RESOURCES 41,937.70 TOTAL OTHER ASSETS ( 198,053.67) TOTAL NON-CURRENT ASSETS 22,940,639.84 TOTAL ASSETS 36,563,052.20 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:32 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 371,258.99 31-20000204 ACCOUNTS PAYABLE - EOY ( 431.48) 31-20000210 RETAINAGE PAYABLE 23,817.53 31-20000215 WAGES PAYABLE 9,133.82 TOTAL ACCOUNTS PAYABLE 403,778.86 DUE TO OTHER FUNDS: 31-20000245 DUE TO OTHER FUNDS 431.48 TOTAL DUE TO OTHER FUNDS 431.48 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 168,008.14 31-20005411 DEFERRED INFLOWS OF RESOURCES 144,785.74 TOTAL OTHER PAYABLES 312,793.88 TOTAL CURRENT LIABILITIES 717,004.22 NON-CURRENT LIABILITIES: 31-20000265 COMPENSATED ABSENCES PAYABLE 67,749.97 TOTAL NON-CURRENT LIABILITIES 67,749.97 TOTAL LIABILITIES 784,754.19 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 4,872,179.49 31-30000305 RESERVE FOR REPLACEMENT 4,857,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 834,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 135,000.00 TOTAL CAPITAL ASSETS 11,274,420.18 RESTRICTED ASSETS: 31-30000310 RESERVE FOR EQUIPMENT 90,000.00 TOTAL RESTRICTED ASSETS 90,000.00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:33 OTHER NET ASSETS: 31-30000320 CAPITAL ASSETS NET OF DEBT 24,748,702.16 TOTAL OTHER NET ASSETS 24,748,702.16 REVENUE OVER EXPENDITURES - YTD ( 334,824.33) BALANCE - CURRENT DATE 35,778,298.01 TOTAL NET ASSETS 35,778,298.01 TOTAL LIABILITIES AND NET ASSETS 36,563,052.20 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:34 WATER - REVENUE REVENUE: 31-4310-0160 GAIN ON INVESTMENTS 7,155.62 60,446.63 .00 ( 60,446.63) .0 TOTAL REVENUE 7,155.62 60,446.63 .00 ( 60,446.63) .0 MISC LOCAL REVENUE: 31-4310-1107 OTHER 1,890.00 24,978.23 1,500.00 ( 23,478.23) 1665.2 31-4310-1140 INTEREST INCOME 74,756.54 368,879.78 260,000.00 ( 108,879.78) 141.9 TOTAL MISC LOCAL REVENUE 76,646.54 393,858.01 261,500.00 ( 132,358.01) 150.6 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 324,520.12 2,512,005.20 2,800,000.00 287,994.80 89.7 31-4310-1705 UTILITY SERVICE FEES 1,725.00 21,627.50 20,000.00 ( 1,627.50) 108.1 31-4310-1706 WATER PLANT INVESTMENT FEES .00 29,250.00 31,250.00 2,000.00 93.6 31-4310-1707 UTILITY LATE FEES 1,395.00 15,415.00 15,500.00 85.00 99.5 31-4310-1710 BULK WATER 6,418.60 58,908.25 50,000.00 ( 8,908.25) 117.8 TOTAL UTILITIES REVENUE 334,058.72 2,637,205.95 2,916,750.00 279,544.05 90.4 TOTAL WATER - REVENUE 417,860.88 3,091,510.59 3,178,250.00 86,739.41 97.3 TOTAL FUND REVENUE 417,860.88 3,091,510.59 3,178,250.00 86,739.41 97.3 WATER - ADMINISTRATION DEPRECIATION: 31-5400-1150 DEPRECIATION 212,500.00 850,000.00 850,000.00 .00 100.0 TOTAL DEPRECIATION 212,500.00 850,000.00 850,000.00 .00 100.0 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 1,859.14 15,655.92 12,000.00 ( 3,655.92) 130.5 31-5400-2166 COLLECTION FEES 186.62 862.87 500.00 ( 362.87) 172.6 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 816.13 500.00 ( 316.13) 163.2 TOTAL PROFESSIONAL SERVICES 2,045.76 17,334.92 13,000.00 ( 4,334.92) 133.4 OPERATING TRANSFERS: 31-5400-4347 MANAGEMENT FEES 73,762.75 295,051.00 295,051.00 .00 100.0 TOTAL OPERATING TRANSFERS 73,762.75 295,051.00 295,051.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:35 HOMELAND SECURITY: 31-5400-9000 CONTINGENCY .00 .00 50,000.00 50,000.00 .0 TOTAL HOMELAND SECURITY .00 .00 50,000.00 50,000.00 .0 TOTAL WATER - ADMINISTRATION 288,308.51 1,162,385.92 1,208,051.00 45,665.08 96.2 WATER - TREATMENT CASH FUND APPROPRIATION: 31-5401-0150 REPLACEMENT RESERVE-SAND FILTE 18,750.00 75,000.00 75,000.00 .00 100.0 TOTAL CASH FUND APPROP 18,750.00 75,000.00 75,000.00 .00 100.0 PERSONNEL SERVICES: 31-5401-1001 SALARIES/WAGES - REGULAR 10,033.32 126,370.64 115,856.00 ( 10,514.64) 109.1 31-5401-1002 SALARIES/WAGES - OVERTIME 943.88 7,760.12 6,000.00 ( 1,760.12) 129.3 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 678.65 678.00 ( .65) 100.1 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 .00 ( 300.00) .0 31-5401-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 2,526.00 2,526.00 .0 TOTAL PERSONNEL SERVICES 11,002.20 135,109.41 125,060.00 ( 10,049.41) 108.0 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 843.98 10,591.15 9,620.00 ( 971.15) 110.1 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 3,242.10 38,715.50 39,102.00 386.50 99.0 31-5401-1025 EMPLOYEE BENEFITS - COMP 212.34 2,659.26 3,204.00 544.74 83.0 31-5401-1026 EMPLOYEE BENEFITS - COMP .00 2,944.90 .00 ( 2,944.90) .0 31-5401-1029 EMPLOYEE BENEFITS - WY 1,888.08 23,070.62 20,959.00 ( 2,111.62) 110.1 TOTAL EMPLOYEE BENEFITS 6,186.50 77,981.43 72,885.00 ( 5,096.43) 107.0 PURCHASED SERVICES: 31-5401-2122 TRAINING/DEVELOPMENT .00 219.00 2,570.00 2,351.00 8.5 31-5401-2123 MEALS/LODGING/TRAVEL .00 .00 800.00 800.00 .0 TOTAL PURCHASED SERVICES .00 219.00 3,370.00 3,151.00 6.5 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 11,671.34 48,970.66 58,000.00 9,029.34 84.4 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 1,060.68 5,417.66 12,000.00 6,582.34 45.2 31-5401-2133 UTILITY SERVICES - NATURAL GAS 337.88 7,511.84 7,500.00 ( 11.84) 100.2 31-5401-2134 TELECOMMUNICATIONS 15.87 189.90 200.00 10.10 95.0 31-5401-2140 RENT - LAND/BUILDINGS .00 10,210.22 12,000.00 1,789.78 85.1 TOTAL PROPERTY SERVICES 13,085.77 72,300.28 89,700.00 17,399.72 80.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:36 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 1,322.25 4,500.00 3,177.75 29.4 31-5401-2155 REPAIRS/MAINTENANCE 967.50 8,261.43 45,000.00 36,738.57 18.4 31-5401-2156 MAINTENANCE AGREEMENT .00 9,257.00 10,000.00 743.00 92.6 31-5401-2158 MISC CONTRACTUAL SERVICES 4,942.40 21,287.45 40,000.00 18,712.55 53.2 TOTAL PROFESSIONAL SERVICES 5,909.90 40,128.13 99,500.00 59,371.87 40.3 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 9,665.66 45,322.46 40,000.00 ( 5,322.46) 113.3 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 4,126.80 24,550.00 20,423.20 16.8 31-5401-3235 FUEL 324.37 1,535.55 1,200.00 ( 335.55) 128.0 TOTAL SUPPLIES 9,990.03 50,984.81 65,750.00 14,765.19 77.5 CAPITALIZED EXPENDITURES: 31-5401-6542 TO BLDG 11,870.00 11,870.00 24,000.00 12,130.00 49.5 31-5401-6544 OTHER THAN BLDG .00 24,374.00 55,000.00 30,626.00 44.3 31-5401-6547 EQUIPMENT/FURNITURE .00 5,128.51 15,500.00 10,371.49 33.1 31-5401-6548 VEHICLES .00 24,319.00 32,500.00 8,181.00 74.8 TOTAL CAPITALIZED EXPENDITURES 11,870.00 65,691.51 127,000.00 61,308.49 51.7 TOTAL WATER - TREATMENT 76,794.40 517,414.57 658,265.00 140,850.43 78.6 WATER - DISTRIBUTION/MAINTNCE CASH FUND APPROPRIATION: 31-5402-0150 REPLACEMENT RESERVE 7,500.00 30,000.00 30,000.00 .00 100.0 TOTAL CASH FUND APPROP 7,500.00 30,000.00 30,000.00 .00 100.0 PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 18,749.81 240,672.87 236,420.00 ( 4,252.87) 101.8 31-5402-1002 SALARIES/WAGES - OVERTIME 293.76 10,220.77 7,500.00 ( 2,720.77) 136.3 31-5402-1004 SALARIES/WAGES - TEMPORARY .00 1,657.50 4,200.00 2,542.50 39.5 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 879.57 879.00 ( .57) 100.1 31-5402-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 19,068.57 253,730.71 249,299.00 ( 4,431.71) 101.8 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,461.05 19,440.31 19,101.00 ( 339.31) 101.8 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 7,571.35 90,856.16 91,093.00 236.84 99.7 31-5402-1025 EMPLOYEE BENEFITS - COMP 368.03 5,000.70 6,492.00 1,491.30 77.0 31-5402-1029 EMPLOYEE BENEFITS - WY 3,275.51 43,153.80 41,954.00 ( 1,199.80) 102.9 TOTAL EMPLOYEE BENEFITS 12,675.94 158,450.97 158,640.00 189.03 99.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:37 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 345.75 1,720.37 1,700.00 ( 20.37) 101.2 31-5402-2122 TRAINING/DEVELOPMENT .00 3,783.50 2,400.00 ( 1,383.50) 157.7 TOTAL PURCHASED SERVICES 345.75 5,503.87 4,100.00 ( 1,403.87) 134.2 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 3,411.65 17,864.41 17,000.00 ( 864.41) 105.1 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 4,545.45 24,917.83 30,000.00 5,082.17 83.1 31-5402-2133 UTILITY SERVICES - NATURAL GAS 56.70 1,685.60 1,300.00 ( 385.60) 129.7 31-5402-2134 TELECOMMUNICATIONS 53.37 219.88 200.00 ( 19.88) 109.9 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 8,067.17 44,687.72 48,900.00 4,212.28 91.4 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 456.48 2,000.00 1,543.52 22.8 31-5402-2155 REPAIRS/MAINTENANCE .00 520.00 30,000.00 29,480.00 1.7 31-5402-2156 MAINTENANCE AGREEMENT .00 .00 1,100.00 1,100.00 .0 31-5402-2158 MISC CONTRACTUAL SERVICES .00 .00 13,000.00 13,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 976.48 46,100.00 45,123.52 2.1 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 2,964.76 51,395.90 45,000.00 ( 6,395.90) 114.2 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,625.05 3,500.00 1,874.95 46.4 31-5402-3235 FUEL 1,499.64 7,949.85 7,000.00 ( 949.85) 113.6 TOTAL SUPPLIES 4,464.40 60,970.80 55,500.00 ( 5,470.80) 109.9 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 .00 350.00 350.00 .0 TOTAL FINANCIAL .00 .00 350.00 350.00 .0 CAPITALIZED EXPENDITURES: 31-5402-6544 OTHER THAN BLDG .00 5,785.00 200,000.00 194,215.00 2.9 31-5402-6547 EQUIPMENT/FURNITURE .00 11,772.58 16,450.00 4,677.42 71.6 31-5402-6548 VEHICLES .00 68,242.00 31,000.00 ( 37,242.00) 220.1 TOTAL CAPITALIZED EXPENDITURES .00 85,799.58 247,450.00 161,650.42 34.7 TOTAL WATER - DISTRIBUTION/MAINTNCE 52,121.83 640,120.13 840,339.00 200,218.87 76.2 WATER - CUSTOMER SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:38 PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 4,536.81 58,671.78 58,672.00 .22 100.0 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 569.18 569.00 ( .18) 100.0 TOTAL PERSONNEL SERVICES 4,536.81 59,240.96 59,241.00 .04 100.0 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 334.36 4,379.49 4,532.00 152.51 96.6 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 25.08 301.66 252.00 ( 49.66) 119.7 31-5403-1025 EMPLOYEE BENEFITS - COMP 87.56 1,166.00 1,540.00 374.00 75.7 31-5403-1029 EMPLOYEE BENEFITS - WY 780.33 10,091.58 10,092.00 .42 100.0 TOTAL EMPLOYEE BENEFITS 1,227.33 15,938.73 16,416.00 477.27 97.1 PROPERTY SERVICES: 31-5403-2134 TELECOMMUNICATIONS 17.23 206.37 200.00 ( 6.37) 103.2 TOTAL PROPERTY SERVICES 17.23 206.37 200.00 ( 6.37) 103.2 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 31-5403-2156 MAINTENANCE AGREEMENT .00 2,294.05 2,500.00 205.95 91.8 TOTAL PROFESSIONAL SERVICES .00 2,294.05 4,000.00 1,705.95 57.4 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES ( 5,507.20) 2,021.58 2,000.00 ( 21.58) 101.1 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 6,407.20 20,326.85 30,000.00 9,673.15 67.8 31-5403-3235 FUEL 182.67 1,105.62 2,000.00 894.38 55.3 TOTAL SUPPLIES 1,082.67 23,454.05 34,000.00 10,545.95 69.0 CAPITALIZED EXPENDITURES: 31-5403-6547 EQUIPMENT .00 12,932.63 15,000.00 2,067.37 86.2 TOTAL CAPITALIZED EXPENDITURES .00 12,932.63 15,000.00 2,067.37 86.2 TOTAL WATER - CUSTOMER SERVICES 6,864.04 114,066.79 128,857.00 14,790.21 88.5 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 29,057.16 129,037.78 387,000.00 257,962.22 33.3 TOTAL PROFESSIONAL SERVICES 29,057.16 129,037.78 387,000.00 257,962.22 33.3 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG 238,393.11 560,435.00 2,655,000.00 2,094,565.00 21.1 TOTAL CAPITALIZED EXPENDITURES 238,393.11 560,435.00 2,655,000.00 2,094,565.00 21.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:39 TOTAL WATER MAIN REPLACEMENTS 267,450.27 689,472.78 3,042,000.00 2,352,527.22 22.7 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 3,383.75 40,119.73 139,000.00 98,880.27 28.9 31-5856-2158 MISC CONTRACTUAL .00 .00 25,000.00 25,000.00 .0 TOTAL PROFESSIONAL SERVICES 3,383.75 40,119.73 164,000.00 123,880.27 24.5 CAPITALIZED EXPENDITURES: 31-5856-6544 OTHER THAN BLDG 51,655.00 262,755.00 835,000.00 572,245.00 31.5 TOTAL CAPITALIZED EXPENDITURES 51,655.00 262,755.00 835,000.00 572,245.00 31.5 TOTAL WATER IMPROVEMENTS 55,038.75 302,874.73 999,000.00 696,125.27 30.3 TOTAL FUND EXPENDITURES 746,577.80 3,426,334.92 6,876,512.00 3,450,177.08 49.8 NET REVENUE OVER EXPENDITURES ( 328,716.92) ( 334,824.33) ( 3,698,262.00) ( 3,363,437.67) ( 9.1) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:40 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND ( 493,338.23) 32-10000118 MONEY MARKET ACCOUNT 124,559.74 TOTAL CASH ( 368,778.49) INVESTMENTS: 32-10000120 INVESTMENT POOL 1,238,230.76 32-10000122 TIME DEPOSITS - SHORT TERM 1,887,856.17 TOTAL INVESTMENTS 3,126,086.93 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 67,723.50 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 2,616.96) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 146,858.04 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE 1,055.88 32-10000139 ACCRUED INTEREST RECEIVABLE 1,951.45 32-10000156 DUE FROM OTHER FUNDS 2,616.96 TOTAL ACCOUNTS RECEIVABLE 217,588.87 TOTAL CURRENT ASSETS 2,974,897.31 FIXED ASSETS: 32-10000181 BUILDINGS 2,395,876.90 32-10000182 ACCUMULATED - BUILDINGS ( 2,127,183.40) 32-10000183 VEHICLES 494,651.26 32-10000184 ACCUMULATED - VEHICLES ( 488,723.75) 32-10000185 MACHINERY/EQUIPMENT 947,901.51 32-10000186 ACCUMULATED - EQUIPMENT ( 634,660.24) 32-10000188 IMPROVEMENTS OTHER THAN BLDG 13,794,365.45 32-10000189 ACCUMULATED OT BLDG ( 3,689,391.04) TOTAL FIXED ASSETS 10,692,836.69 OTHER ASSETS: 32-10000190 ACCUMULATED ( 322,000.00) 32-10000195 CONSTRUCTION IN PROGRESS 863,111.34 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 14,423.85 TOTAL OTHER ASSETS 555,535.19 TOTAL NON-CURRENT ASSETS 11,248,371.88 TOTAL ASSETS 14,223,269.19 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:41 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 88,011.84 32-20000204 ACCOUNTS PAYABLE - EOY ( 7,513.85) 32-20000210 RETAINAGE PAYABLE 34,162.73 32-20000215 WAGES PAYABLE 5,392.27 TOTAL ACCOUNTS PAYABLE 120,052.99 DUE TO OTHER FUNDS: 32-20000245 DUE TO OTHER FUNDS 5,063.85 TOTAL DUE TO OTHER FUNDS 5,063.85 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 68,062.58 32-20005411 DEFERRED INFLOWS OF RESOURCES 117,393.84 TOTAL OTHER PAYABLES 185,456.42 TOTAL CURRENT LIABILITIES 310,573.26 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 46,471.46 TOTAL NON-CURRENT LIABILITIES 46,471.46 TOTAL LIABILITIES 357,044.72 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS ( 2,107,508.57) 32-30000305 RESERVE FOR REPLACEMENT 4,075,882.31 32-30000306 RESERVE FOR OPERATING 195,913.00 32-30000307 RESERVE FOR SLUDGE REMOVAL 470,000.00 TOTAL CAPITAL ASSETS 2,634,286.74 RESTRICTED ASSETS: 32-30000310 RESERVE FOR EQUIPMENT 60,000.00 TOTAL RESTRICTED ASSETS 60,000.00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:42 OTHER NET ASSETS: 32-30000320 CAPITAL ASSETS NET OF DEBT 11,555,948.05 TOTAL OTHER NET ASSETS 11,555,948.05 REVENUE OVER EXPENDITURES - YTD ( 384,010.32) BALANCE - CURRENT DATE 13,866,224.47 TOTAL NET ASSETS 13,866,224.47 TOTAL LIABILITIES AND NET ASSETS 14,223,269.19 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:43 SEWER - REVENUE REVENUE: 32-4320-0160 GAIN ON INVESTMENTS 3,066.69 25,905.70 .00 ( 25,905.70) .0 TOTAL REVENUE 3,066.69 25,905.70 .00 ( 25,905.70) .0 MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 5,405.64 1,200.00 ( 4,205.64) 450.5 32-4320-1140 INTEREST INCOME 12,551.33 114,426.16 77,000.00 ( 37,426.16) 148.6 TOTAL MISC LOCAL REVENUE 12,551.33 119,831.80 78,200.00 ( 41,631.80) 153.2 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 123,136.01 1,326,829.49 1,375,000.00 48,170.51 96.5 32-4320-1706 SEWER PLANT INVESTMENT FEES .00 9,020.00 12,500.00 3,480.00 72.2 TOTAL UTILITIES REVENUE 123,136.01 1,335,849.49 1,387,500.00 51,650.51 96.3 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 8,930.00 60,005.00 165,000.00 104,995.00 36.4 TOTAL SEPTIC WASTE DISPOSAL 8,930.00 60,005.00 165,000.00 104,995.00 36.4 TOTAL SEWER - REVENUE 147,684.03 1,541,591.99 1,630,700.00 89,108.01 94.5 SEWER LINE REPLACEMENTS - REV FEDERAL REVENUE SOURCES: 32-4852-4288 APRA 59,986.00 59,986.00 1,455,000.00 1,395,014.00 4.1 TOTAL FEDERAL REVENUE SOURCES 59,986.00 59,986.00 1,455,000.00 1,395,014.00 4.1 TRANSFERS IN: 32-4852-5513 TRANSFER FROM GENERAL FUND .00 .00 820,000.00 820,000.00 .0 TOTAL TRANSFERS IN .00 .00 820,000.00 820,000.00 .0 TOTAL SEWER LINE REPLACEMENTS - REV 59,986.00 59,986.00 2,275,000.00 2,215,014.00 2.6 TOTAL FUND REVENUE 207,670.03 1,601,577.99 3,905,700.00 2,304,122.01 41.0 SEWER - ADMINISTRATION ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:44 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 1,200.69 10,111.11 5,000.00 ( 5,111.11) 202.2 TOTAL PROFESSIONAL SERVICES 1,200.69 10,111.11 5,000.00 ( 5,111.11) 202.2 OPERATING TRANSFERS: 32-5500-4347 MANAGEMENT FEES 36,222.75 144,891.00 144,891.00 .00 100.0 TOTAL OPERATING TRANSFERS 36,222.75 144,891.00 144,891.00 .00 100.0 HOMELAND SECURITY: 32-5500-9000 CONTINGENCY .00 .00 50,000.00 50,000.00 .0 TOTAL HOMELAND SECURITY .00 .00 50,000.00 50,000.00 .0 TOTAL SEWER - ADMINISTRATION 37,423.44 155,002.11 199,891.00 44,888.89 77.5 SEWER - TREATMENT PERSONNEL SERVICES: 32-5501-1001 SALARIES/WAGES - REGULAR 9,106.38 116,108.02 107,068.00 ( 9,040.02) 108.4 32-5501-1002 SALARIES/WAGES - OVERTIME .00 1,319.24 5,000.00 3,680.76 26.4 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 428.03 428.00 ( .03) 100.0 32-5501-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 32-5501-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 858.00 858.00 .0 TOTAL PERSONNEL SERVICES 9,131.38 118,155.29 113,654.00 ( 4,501.29) 104.0 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 700.83 9,138.78 8,724.00 ( 414.78) 104.8 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 3,248.43 38,972.07 39,064.00 91.93 99.8 32-5501-1025 EMPLOYEE BENEFITS - COMP 176.24 2,325.45 2,943.00 617.55 79.0 32-5501-1026 EMPLOYEE BENEFITS - COMP .00 918.75 .00 ( 918.75) .0 32-5501-1029 EMPLOYEE BENEFITS - WY 1,566.30 20,197.43 19,276.00 ( 921.43) 104.8 TOTAL EMPLOYEE BENEFITS 5,691.80 71,552.48 70,007.00 ( 1,545.48) 102.2 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 .00 2,570.00 2,570.00 .0 32-5501-2123 MEALS/LODGING/TRAVEL .00 .00 800.00 800.00 .0 TOTAL PURCHASED SERVICES .00 .00 3,370.00 3,370.00 .0 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 10,239.41 63,262.75 80,000.00 16,737.25 79.1 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 1,861.97 27,689.56 75,000.00 47,310.44 36.9 32-5501-2134 TELECOMMUNICATIONS 171.33 2,041.05 1,700.00 ( 341.05) 120.1 TOTAL PROPERTY SERVICES 12,272.71 92,993.36 156,700.00 63,706.64 59.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:45 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY 3,710.00 4,744.75 4,500.00 ( 244.75) 105.4 32-5501-2155 REPAIRS/MAINTENANCE 3,340.15 13,218.92 30,000.00 16,781.08 44.1 32-5501-2158 MISC CONTRACTUAL SERVICES 1,498.00 9,823.50 20,000.00 10,176.50 49.1 TOTAL PROFESSIONAL SERVICES 8,548.15 27,787.17 54,500.00 26,712.83 51.0 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 4,497.07 32,539.88 40,000.00 7,460.12 81.4 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 11,681.95 12,550.00 868.05 93.1 32-5501-3235 FUEL 324.35 1,535.48 1,200.00 ( 335.48) 128.0 TOTAL SUPPLIES 4,821.42 45,757.31 53,750.00 7,992.69 85.1 CAPITALIZED EXPENDITURES: 32-5501-6544 OTHER THAN BLDG .00 14,919.71 49,500.00 34,580.29 30.1 32-5501-6548 VEHICLES .00 24,140.00 32,500.00 8,360.00 74.3 TOTAL CAPITALIZED EXPENDITURES .00 39,059.71 82,000.00 42,940.29 47.6 TOTAL SEWER - TREATMENT 40,465.46 395,305.32 533,981.00 138,675.68 74.0 SEWER - COLLECTION PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 16,888.80 207,147.09 223,219.00 16,071.91 92.8 32-5502-1002 SALARIES/WAGES - OVERTIME 772.80 6,420.47 4,500.00 ( 1,920.47) 142.7 32-5502-1004 SALARIES/WAGES - TEMPORARY .00 1,657.50 4,200.00 2,542.50 39.5 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 582.20 2,483.00 1,900.80 23.5 32-5502-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 17,686.60 216,107.26 234,702.00 18,594.74 92.1 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 1,355.32 16,561.93 17,985.00 1,423.07 92.1 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 6,251.27 72,931.84 91,036.00 18,104.16 80.1 32-5502-1025 EMPLOYEE BENEFITS - COMP 341.37 4,246.47 6,112.00 1,865.53 69.5 32-5502-1029 EMPLOYEE BENEFITS - WY 3,037.79 36,733.52 39,168.00 2,434.48 93.8 TOTAL EMPLOYEE BENEFITS 10,985.75 130,473.76 154,301.00 23,827.24 84.6 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 345.75 1,684.38 1,700.00 15.62 99.1 32-5502-2122 TRAINING/DEVELOPMENT 106.00 3,391.50 1,825.00 ( 1,566.50) 185.8 TOTAL PURCHASED SERVICES 451.75 5,075.88 3,525.00 ( 1,550.88) 144.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:46 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 1,562.74 11,590.48 12,000.00 409.52 96.6 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 50.97 294.69 350.00 55.31 84.2 32-5502-2133 UTILITY SERVICES - NATURAL GAS 252.60 3,162.34 2,500.00 ( 662.34) 126.5 32-5502-2134 TELECOMMUNICATIONS 116.79 980.89 1,000.00 19.11 98.1 TOTAL PROPERTY SERVICES 1,983.10 16,028.40 15,850.00 ( 178.40) 101.1 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 2,500.00 2,500.00 .0 32-5502-2155 REPAIRS/MAINTENANCE .00 4,321.39 15,000.00 10,678.61 28.8 32-5502-2158 MISC CONTRACTUAL SERVICES .00 .00 13,000.00 13,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 4,321.39 30,500.00 26,178.61 14.2 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 173.28 53,173.26 35,000.00 ( 18,173.26) 151.9 32-5502-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 3,500.00 3,500.00 .0 32-5502-3235 FUEL 1,499.55 7,949.37 6,000.00 ( 1,949.37) 132.5 TOTAL SUPPLIES 1,672.83 61,122.63 44,500.00 ( 16,622.63) 137.4 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 344.67 350.00 5.33 98.5 TOTAL FINANCIAL .00 344.67 350.00 5.33 98.5 CAPITALIZED EXPENDITURES: 32-5502-6542 TO BLDG .00 2,450.00 .00 ( 2,450.00) .0 32-5502-6547 EQUIPMENT/FURNITURE .00 6,577.00 10,250.00 3,673.00 64.2 32-5502-6548 VEHICLES .00 .00 31,000.00 31,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 9,027.00 41,250.00 32,223.00 21.9 TOTAL SEWER - COLLECTION 32,780.03 442,500.99 524,978.00 82,477.01 84.3 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 9,475.86 53,007.49 157,000.00 103,992.51 33.8 TOTAL PROFESSIONAL SERVICES 9,475.86 53,007.49 157,000.00 103,992.51 33.8 CAPITALIZED EXPENDITURES: 32-5850-6544 OTHER THAN BLDG .00 .00 1,046,000.00 1,046,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 1,046,000.00 1,046,000.00 .0 TOTAL WASTEWATER PLANT REHAB 9,475.86 53,007.49 1,203,000.00 1,149,992.51 4.4 SEWER MAIN REPLACEMENTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:47 PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 33,414.13 136,860.91 410,000.00 273,139.09 33.4 TOTAL PROFESSIONAL SERVICES 33,414.13 136,860.91 410,000.00 273,139.09 33.4 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG 10,466.68 802,911.49 2,585,000.00 1,782,088.51 31.1 TOTAL CAPITALIZED EXPENDITURES 10,466.68 802,911.49 2,585,000.00 1,782,088.51 31.1 TOTAL SEWER MAIN REPLACEMENTS 43,880.81 939,772.40 2,995,000.00 2,055,227.60 31.4 TOTAL FUND EXPENDITURES 164,025.60 1,985,588.31 5,456,850.00 3,471,261.69 36.4 NET REVENUE OVER EXPENDITURES 43,644.43 ( 384,010.32) ( 1,551,150.00) ( 1,167,139.68) ( 24.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:48 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 540,847.37 TOTAL CASH 540,847.37 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 698,075.36 TOTAL INVESTMENTS 698,075.36 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 100.00 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 1,634.56) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 138,847.23 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 372.87) 33-10000139 ACCRUED INTEREST RECEIVABLE 938.16 33-10000156 DUE FROM OTHER FUNDS 2,992.88 TOTAL ACCOUNTS RECEIVABLE 140,870.84 TOTAL CURRENT ASSETS 1,379,793.57 FIXED ASSETS: 33-10000183 VEHICLES 684,806.00 33-10000184 ACCUMULATED - VEHICLES ( 397,474.87) 33-10000185 EQUIPMENT 33,437.00 33-10000186 ACCUMULATED - EQUIPMENT ( 33,437.00) TOTAL FIXED ASSETS 287,331.13 OTHER ASSETS: 33-10000190 ACCUMULATED ( 138,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 9,907.22 TOTAL OTHER ASSETS ( 128,092.78) TOTAL NON-CURRENT ASSETS 159,238.35 TOTAL ASSETS 1,539,031.92 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:49 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 151,177.55 33-20000204 ACCOUNTS PAYBLE - EOY ( 111,375.00) 33-20000215 WAGES PAYABLE 2,983.00 TOTAL ACCOUNTS PAYABLE 42,785.55 DUE TO OTHER FUNDS: 33-20000245 DUE TO OTHER FUNDS 111,375.00 TOTAL DUE TO OTHER FUNDS 111,375.00 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 38,908.21 33-20005411 DEFERRED INFLOWS OF RESOURCES 62,610.05 TOTAL OTHER PAYABLES 101,518.26 TOTAL CURRENT LIABILITIES 255,678.81 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 33,522.66 TOTAL NON-CURRENT LIABILITIES 33,522.66 TOTAL LIABILITIES 289,201.47 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 10,723.93) 33-30000305 RESERVE FOR REPLACEMENT 911,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 977,020.61 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 287,331.13 TOTAL OTHER NET ASSETS 287,331.13 REVENUE OVER EXPENDITURES - YTD ( 14,521.29) BALANCE - CURRENT DATE 1,249,830.45 TOTAL NET ASSETS 1,249,830.45 TOTAL LIABILITIES AND NET ASSETS 1,539,031.92 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:55PM PAGE:50 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1140 INTEREST INCOME 4,431.82 28,553.90 25,000.00 ( 3,553.90) 114.2 TOTAL MISC LOCAL REVENUE 4,431.82 28,553.90 25,000.00 ( 3,553.90) 114.2 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 124,898.74 1,395,684.89 1,385,000.00 ( 10,684.89) 100.8 33-4330-1709 SANITATION ACTIVATION FEE .00 375.00 1,250.00 875.00 30.0 TOTAL UTILITIES REVENUE 124,898.74 1,396,059.89 1,386,250.00 ( 9,809.89) 100.7 TOTAL SANITATION - REVENUE 129,330.56 1,424,613.79 1,411,250.00 ( 13,363.79) 101.0 TOTAL FUND REVENUE 129,330.56 1,424,613.79 1,411,250.00 ( 13,363.79) 101.0 SANITATION PERSONNEL SERVICES: 33-5600-1001 SALARIES/WAGES - REGULAR 12,249.87 156,592.71 157,271.00 678.29 99.6 33-5600-1002 SALARIES/WAGES - OVERTIME .00 .00 600.00 600.00 .0 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 978.56 978.00 ( .56) 100.1 33-5600-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 33-5600-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 864.00 864.00 .0 TOTAL PERSONNEL SERVICES 12,274.87 157,871.27 160,013.00 2,141.73 98.7 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 941.28 12,226.88 12,271.00 44.12 99.6 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 5,406.15 64,862.02 65,016.00 153.98 99.8 33-5600-1025 EMPLOYEE BENEFITS - COMP 236.93 3,107.42 4,148.00 1,040.58 74.9 33-5600-1026 EMPLOYEE BENEFITS - COMP .00 1,570.20 .00 ( 1,570.20) .0 33-5600-1027 LONGEVITY .00 .00 12,271.00 12,271.00 .0 33-5600-1029 EMPLOYEE BENEFITS - WY 2,106.96 26,933.77 27,154.00 220.23 99.2 TOTAL EMPLOYEE BENEFITS 8,691.32 108,700.29 120,860.00 12,159.71 89.9 DEPRECIATION: 33-5600-1150 DEPRECIATION 17,500.00 70,000.00 70,000.00 .00 100.0 TOTAL DEPRECIATION 17,500.00 70,000.00 70,000.00 .00 100.0 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE 492.52 2,854.76 4,200.00 1,345.24 68.0 33-5600-2158 MISC CONTRACTUAL SERVICES 145,378.87 860,880.45 1,003,000.00 142,119.55 85.8 TOTAL PROFESSIONAL SERVICES 145,871.39 863,735.21 1,007,200.00 143,464.79 85.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:51 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 1,970.02 33,176.03 30,000.00 ( 3,176.03) 110.6 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 30,956.92 30,000.00 ( 956.92) 103.2 33-5600-3235 FUEL 3,610.77 25,726.36 22,000.00 ( 3,726.36) 116.9 TOTAL SUPPLIES 5,580.79 89,859.31 82,000.00 ( 7,859.31) 109.6 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 36,486.25 145,945.00 145,945.00 .00 100.0 TOTAL OPERATING TRANSFERS 36,486.25 145,945.00 145,945.00 .00 100.0 HOMELAND SECURITY: 33-5600-9000 CONTINGENCY .00 3,024.00 25,000.00 21,976.00 12.1 TOTAL HOMELAND SECURITY .00 3,024.00 25,000.00 21,976.00 12.1 TOTAL SANITATION 226,404.62 1,439,135.08 1,611,018.00 171,882.92 89.3 TOTAL FUND EXPENDITURES 226,404.62 1,439,135.08 1,611,018.00 171,882.92 89.3 NET REVENUE OVER EXPENDITURES ( 97,074.06) ( 14,521.29) ( 199,768.00) ( 185,246.71) ( 7.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:52 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 261,325.76 TOTAL CASH 261,325.76 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,973,991.60 TOTAL INVESTMENTS 1,973,991.60 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 187,095.70 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 111,375.00) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY ( 2,776.50) 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,695.72) 34-10000139 ACCRUED INTEREST RECEIVABLE 4,223.62 34-10000156 DUE FROM OTHER FUNDS 111,375.00 TOTAL ACCOUNTS RECEIVABLE 185,847.10 TOTAL CURRENT ASSETS 2,421,164.46 FIXED ASSETS: 34-10000180 LAND 153,289.58 34-10000181 BUILDINGS 1,700,526.30 34-10000182 ACCUMULATED - BUILDINGS ( 482,505.71) 34-10000183 VEHICLES 97,705.76 34-10000184 ACCUMULATED - VEHICLE ( 67,788.36) 34-10000185 EQUIPMENT 1,320,336.03 34-10000186 ACCUMULATED - EQUIPMENT ( 1,052,518.83) 34-10000188 IMPROVEMENTS OTHER THAN BLDG 417,030.94 34-10000189 ACCUMULATED OT BLDG ( 75,457.58) TOTAL FIXED ASSETS 2,010,618.13 OTHER ASSETS: 34-10000190 ACCUMULATED ( 205,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 17,494.06 TOTAL OTHER ASSETS ( 187,505.94) TOTAL NON-CURRENT ASSETS 1,823,112.19 TOTAL ASSETS 4,244,276.65 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:53 ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 125,025.48 34-20000204 ACCOUNTS PAYABLE- EOY ( 7,482.69) 34-20000215 WAGES PAYABLE 4,982.97 TOTAL ACCOUNTS PAYABLE 122,525.76 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 81,784.75 34-20005411 DEFERRED INFLOWS OF RESOURCES 66,523.17 TOTAL OTHER PAYABLES 148,307.92 TOTAL CURRENT LIABILITIES 270,833.68 NON-CURRENT LIABILITIES: 34-20000260 SLIB NOTES PAYABLE 64,712.75 34-20000265 COMPENSATED ABSENCES PAYABLE 18,628.43 34-20000290 LANDFILL LIABILITY 471,942.60 TOTAL NON-CURRENT LIABILITIES 555,283.78 TOTAL LIABILITIES 826,117.46 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS ( 224,828.40) 34-30000305 RESERVE FOR REPLACEMENT 1,256,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,164,342.37 OTHER NET ASSETS: 34-30000320 CAPITAL ASSETS NET OF DEBT 2,482,560.72 TOTAL OTHER NET ASSETS 2,482,560.72 REVENUE OVER EXPENDITURES - YTD ( 228,743.90) BALANCE - CURRENT DATE 3,418,159.19 TOTAL NET ASSETS 3,418,159.19 TOTAL LIABILITIES AND NET ASSETS 4,244,276.65 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:54 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER .00 9,218.80 .00 ( 9,218.80) .0 34-4340-1109 REIMBURSEMENTS .00 6,518.41 .00 ( 6,518.41) .0 34-4340-1140 INTEREST INCOME 7,018.75 65,242.26 62,000.00 ( 3,242.26) 105.2 TOTAL MISC LOCAL REVENUE 7,018.75 80,979.47 62,000.00 ( 18,979.47) 130.6 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 205,101.84 1,246,914.70 1,000,000.00 ( 246,914.70) 124.7 TOTAL UTILITIES REVENUE 205,101.84 1,246,914.70 1,000,000.00 ( 246,914.70) 124.7 TOTAL LANDFILL - REVENUE 212,120.59 1,327,894.17 1,062,000.00 ( 265,894.17) 125.0 TOTAL FUND REVENUE 212,120.59 1,327,894.17 1,062,000.00 ( 265,894.17) 125.0 LANDFILL PERSONNEL SERVICES: 34-5340-1001 SALARIES/WAGES - REGULAR 20,003.35 257,151.32 248,273.00 ( 8,878.32) 103.6 34-5340-1002 SALARIES/WAGES - OVERTIME .00 2,576.87 1,500.00 ( 1,076.87) 171.8 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,230.10 1,230.00 ( .10) 100.0 34-5340-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 TOTAL PERSONNEL SERVICES 20,053.35 261,558.29 251,603.00 ( 9,955.29) 104.0 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,584.04 20,703.70 20,056.00 ( 647.70) 103.2 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 6,489.70 77,869.80 78,031.00 161.20 99.8 34-5340-1025 EMPLOYEE BENEFITS - COMP 387.05 5,150.32 6,562.00 1,411.68 78.5 34-5340-1026 EMPLOYEE BENEFITS - COMP 795.07 10,781.80 9,785.00 ( 996.80) 110.2 34-5340-1029 EMPLOYEE BENEFITS - WY 2,645.52 33,823.04 33,176.00 ( 647.04) 102.0 TOTAL EMPLOYEE BENEFITS 11,901.38 148,328.66 147,610.00 ( 718.66) 100.5 DEPRECIATION: 34-5340-1150 DEPRECIATION 35,000.00 140,000.00 140,000.00 .00 100.0 TOTAL DEPRECIATION 35,000.00 140,000.00 140,000.00 .00 100.0 PURCHASED SERVICES: 34-5340-2122 TRAINING/DEVELOPMENT .00 700.00 800.00 100.00 87.5 34-5340-2123 MEALS/LODGING/TRAVEL .00 729.97 1,000.00 270.03 73.0 TOTAL PURCHASED SERVICES .00 1,429.97 1,800.00 370.03 79.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:55 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 1,207.92 7,463.48 10,000.00 2,536.52 74.6 34-5340-2133 UTILITY SERVICES - NATURAL GAS 329.16 6,017.47 11,500.00 5,482.53 52.3 34-5340-2134 TELECOMMUNICATIONS .00 .00 250.00 250.00 .0 TOTAL PROPERTY SERVICES 1,537.08 13,480.95 21,750.00 8,269.05 62.0 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY 3,790.00 3,790.00 1,000.00 ( 2,790.00) 379.0 34-5340-2155 REPAIRS/MAINTENANCE 19,530.60 22,451.19 15,000.00 ( 7,451.19) 149.7 34-5340-2156 MAINTENANCE AGREEMENT .00 6,662.34 11,500.00 4,837.66 57.9 34-5340-2157 INSURANCE .00 4,402.91 .00 ( 4,402.91) .0 34-5340-2158 MISC CONTRACTUAL SERVICES 72,763.25 615,077.94 510,000.00 ( 105,077.94) 120.6 34-5340-2166 COLLECTION FEES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 96,083.85 652,384.38 537,800.00 ( 114,584.38) 121.3 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 1,801.97 36,171.00 50,000.00 13,829.00 72.3 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 7,187.49 23,523.88 20,000.00 ( 3,523.88) 117.6 34-5340-3235 FUEL 3,461.74 26,346.14 25,000.00 ( 1,346.14) 105.4 TOTAL SUPPLIES 12,451.20 86,041.02 95,000.00 8,958.98 90.6 FINANCIAL: 34-5340-4343 DEBT PAYMENT - PRINCIPAL .00 13,141.02 13,141.02 .00 100.0 TOTAL FINANCIAL .00 13,141.02 13,141.02 .00 100.0 OPERATING TRANSFERS: 34-5340-4347 MANAGEMENT FEES 26,343.75 105,375.00 105,375.00 .00 100.0 TOTAL OPERATING TRANSFERS 26,343.75 105,375.00 105,375.00 .00 100.0 CAPITALIZED EXPENDITURES: 34-5340-6547 EQUIPMENT/FURNITURE .00 5,614.26 10,500.00 4,885.74 53.5 TOTAL CAPITALIZED EXPENDITURES .00 5,614.26 10,500.00 4,885.74 53.5 HOMELAND SECURITY: 34-5340-9000 CONTINGENCY .00 .00 550,000.00 550,000.00 .0 TOTAL HOMELAND SECURITY .00 .00 550,000.00 550,000.00 .0 TOTAL LANDFILL 203,370.61 1,427,353.55 1,874,579.02 447,225.47 76.1 LANDFILL - CAPITAL ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:56 PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 9,319.78 26,970.10 40,000.00 13,029.90 67.4 TOTAL PROFESSIONAL SERVICES 9,319.78 26,970.10 40,000.00 13,029.90 67.4 CAPITALIZED EXPENDITURES: 34-5895-6542 BUILDINGS/IMPROVEMENTS .00 28,752.10 50,000.00 21,247.90 57.5 34-5895-6544 OTHER THAN BLDG .00 7,482.69 .00 ( 7,482.69) .0 34-5895-6547 EQUIPMENT/FURNITURE 5,633.57 66,079.63 81,500.00 15,420.37 81.1 TOTAL CAPITALIZED EXPENDITURES 5,633.57 102,314.42 131,500.00 29,185.58 77.8 TOTAL LANDFILL - CAPITAL 14,953.35 129,284.52 171,500.00 42,215.48 75.4 TOTAL FUND EXPENDITURES 218,323.96 1,556,638.07 2,046,079.02 489,440.95 76.1 NET REVENUE OVER EXPENDITURES ( 6,203.37) ( 228,743.90) ( 984,079.02) ( 755,335.12) ( 23.2) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:57 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 18,842.44 TOTAL CASH 18,842.44 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 419,133.41 TOTAL INVESTMENTS 419,133.41 ACCOUNTS RECEIVABLE: 39-10000132 ACCOUNTS REC - EOY 131,699.22 39-10000139 ACCRUED INTEREST RECEIVABLE 1,567.61 39-10000156 DUE FROM OTHER FUNDS ( 5.99) TOTAL ACCOUNTS RECEIVABLE 133,260.84 TOTAL CURRENT ASSETS 571,236.69 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 571,236.69 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 39-20000210 IBNR LIABILITY 284,000.00 TOTAL ACCOUNTS PAYABLE 284,000.00 DUE TO OTHER FUNDS: 39-20000245 DUE TO OTHER FUNDS 115,087.31 TOTAL DUE TO OTHER FUNDS 115,087.31 TOTAL CURRENT LIABILITIES 399,087.31 TOTAL LIABILITIES 399,087.31 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:58 CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 918,262.50) 39-30000301 FUND BALANCE RESERVE 1,300,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 488,737.50 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 316,588.12) BALANCE - CURRENT DATE 172,149.38 TOTAL NET ASSETS 172,149.38 TOTAL LIABILITIES AND NET ASSETS 571,236.69 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:56PM PAGE:59 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 202,185.16 1,018,789.35 1,315,000.00 296,210.65 77.5 39-4390-0111 INSURANCE PREMIUMS 46,961.84 544,566.89 553,900.00 9,333.11 98.3 39-4390-0112 INSURANCE ASSESSMENTS 75,413.12 876,161.80 1,000,000.00 123,838.20 87.6 TOTAL REVENUE 324,560.12 2,439,518.04 2,868,900.00 429,381.96 85.0 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 102.57 18,215.12 22,000.00 3,784.88 82.8 TOTAL MISC LOCAL REVENUE 102.57 18,215.12 22,000.00 3,784.88 82.8 TOTAL EMPLOYEE HEALTH CARE - REVENUE 324,662.69 2,457,733.16 2,890,900.00 433,166.84 85.0 TOTAL FUND REVENUE 324,662.69 2,457,733.16 2,890,900.00 433,166.84 85.0 EMPLOYEE HEALTH CARE EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM .00 458,226.84 459,600.00 1,373.16 99.7 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 169,668.26 2,220,638.94 2,215,000.00 ( 5,638.94) 100.3 39-5390-1058 HEALTH CARE - FEE .00 95,455.50 94,300.00 ( 1,155.50) 101.2 TOTAL EMPLOYEE BENEFITS 169,668.26 2,774,321.28 2,768,900.00 ( 5,421.28) 100.2 TOTAL EMPLOYEE HEALTH CARE 169,668.26 2,774,321.28 2,768,900.00 ( 5,421.28) 100.2 TOTAL FUND EXPENDITURES 169,668.26 2,774,321.28 2,768,900.00 ( 5,421.28) 100.2 NET REVENUE OVER EXPENDITURES 154,994.43 ( 316,588.12) 122,000.00 438,588.12 ( 259.5) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:57PM PAGE:60 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 45,746.05 TOTAL CASH 45,746.05 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 325,548.52 TOTAL INVESTMENTS 325,548.52 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 1,031.61 TOTAL ACCOUNTS RECEIVABLE 1,031.61 TOTAL CURRENT ASSETS 372,326.18 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 372,326.18 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 361,428.94 TOTAL CAPITAL ASSETS 361,428.94 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 10,897.24 BALANCE - CURRENT DATE 372,326.18 TOTAL NET ASSETS 372,326.18 TOTAL LIABILITIES AND NET ASSETS 372,326.18 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:57PM PAGE:61 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 625.77 10,897.24 10,475.00 ( 422.24) 104.0 TOTAL MISC LOCAL REVENUE 625.77 10,897.24 10,475.00 ( 422.24) 104.0 TOTAL CAPITAL IMP RESERVE - REVENUE 625.77 10,897.24 10,475.00 ( 422.24) 104.0 TOTAL FUND REVENUE 625.77 10,897.24 10,475.00 ( 422.24) 104.0 NET REVENUE OVER EXPENDITURES 625.77 10,897.24 10,475.00 ( 422.24) 104.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:57PM PAGE:62 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 1,944,666.67 TOTAL CASH 1,944,666.67 INVESTMENTS: 41-10000122 TIME DEPOSITS-SHORT TERM 192,593.45 TOTAL INVESTMENTS 192,593.45 ACCOUNTS RECEIVABLE: 41-10000139 ACCRUED INTEREST RECEIVABLE 22.91 TOTAL ACCOUNTS RECEIVABLE 22.91 TOTAL CURRENT ASSETS 2,137,283.03 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,137,283.03 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 41-30000300 FUND BALANCE/BEGINNING OF YEAR 372,462.88 TOTAL CAPITAL ASSETS 372,462.88 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,764,820.15 BALANCE - CURRENT DATE 2,137,283.03 TOTAL NET ASSETS 2,137,283.03 TOTAL LIABILITIES AND NET ASSETS 2,137,283.03 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:57PM PAGE:63 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 3,198.80 18,479.41 7,785.00 ( 10,694.41) 237.4 TOTAL MISC LOCAL REVENUE 3,198.80 18,479.41 7,785.00 ( 10,694.41) 237.4 TRANSFERS IN: 41-4410-5510 TRANSFER FROM GENERAL FUND 468,750.00 1,875,000.00 1,875,000.00 .00 100.0 TOTAL TRANSFERS IN 468,750.00 1,875,000.00 1,875,000.00 .00 100.0 TOTAL ECONOMIC DEVELOPMENT 471,948.80 1,893,479.41 1,882,785.00 ( 10,694.41) 100.6 TOTAL FUND REVENUE 471,948.80 1,893,479.41 1,882,785.00 ( 10,694.41) 100.6 ECONOMIC DEVELOPMENT PURCHASED SERVICES: 41-5410-2115 PUBLISHING/ADVERTISING .00 .00 10,000.00 10,000.00 .0 41-5410-2122 TRAINING/DEVELOPMENT .00 .00 75,000.00 75,000.00 .0 TOTAL PURCHASED SERVICES .00 .00 85,000.00 85,000.00 .0 PROFESSIONAL SERVICES: 41-5410-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,750.00 1,750.00 .0 41-5410-2158 MISC CONTRACTUAL SERVICES .00 62,000.00 55,000.00 ( 7,000.00) 112.7 TOTAL PROFESSIONAL SERVICES .00 62,000.00 56,750.00 ( 5,250.00) 109.3 SUPPLIES: 41-5410-3210 OPERATING SUPPLIES .00 .00 500.00 500.00 .0 TOTAL SUPPLIES .00 .00 500.00 500.00 .0 HOMELAND SECURITY: 41-5410-9000 CONTINGENCY 61,209.26 66,659.26 1,675,000.00 1,608,340.74 4.0 TOTAL HOMELAND SECURITY 61,209.26 66,659.26 1,675,000.00 1,608,340.74 4.0 TOTAL ECONOMIC DEVELOPMENT 61,209.26 128,659.26 1,817,250.00 1,688,590.74 7.1 TOTAL FUND EXPENDITURES 61,209.26 128,659.26 1,817,250.00 1,688,590.74 7.1 NET REVENUE OVER EXPENDITURES 410,739.54 1,764,820.15 65,535.00 ( 1,699,285.15) 2692.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 BROWNFIELD GRANT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:57PM PAGE:64 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 42-30000300 FUND BALANCE/BEGINNING OF YEAR 1,317.93 TOTAL CAPITAL ASSETS 1,317.93 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1,317.93) BALANCE - CURRENT DATE .00 TOTAL NET ASSETS .00 TOTAL LIABILITIES AND NET ASSETS .00 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:57PM PAGE:65 BROWNFIELD HAZARDOUS - REVENUE FEDERAL REVENUE SOURCES: 42-4870-4281 EPA .00 221.12 6,032.00 5,810.88 3.7 TOTAL FEDERAL REVENUE SOURCES .00 221.12 6,032.00 5,810.88 3.7 TRANSFERS IN: 42-4870-5510 TRANSFER FROM GENERAL FUND 956.10 956.10 2,496.00 1,539.90 38.3 TOTAL TRANSFERS IN 956.10 956.10 2,496.00 1,539.90 38.3 TOTAL BROWNFIELD HAZARDOUS - REVENUE 956.10 1,177.22 8,528.00 7,350.78 13.8 BROWNFIELD PETROLEUM - REVENUE FEDERAL REVENUE SOURCES: 42-4871-4281 EPA .00 .00 4,145.00 4,145.00 .0 TOTAL FEDERAL REVENUE SOURCES .00 .00 4,145.00 4,145.00 .0 TOTAL BROWNFIELD PETROLEUM - REVENUE .00 .00 4,145.00 4,145.00 .0 FEDERAL REVENUE SOURCES: 42-4872-4281 EPA .00 .00 1,000,000.00 1,000,000.00 .0 TOTAL FEDERAL REVENUE SOURCES .00 .00 1,000,000.00 1,000,000.00 .0 .00 .00 1,000,000.00 1,000,000.00 .0 TOTAL FUND REVENUE 956.10 1,177.22 1,012,673.00 1,011,495.78 .1 BROWNFIELD HAZARDOUS PURCHASED SERVICES: 42-5870-2123 MEALS/LODGING/TRAVEL .00 .00 1,107.54 1,107.54 .0 TOTAL PURCHASED SERVICES .00 .00 1,107.54 1,107.54 .0 PROFESSIONAL SERVICES: 42-5870-2158 MISC CONTRACTUAL SERVICES .00 2,495.15 4,924.88 2,429.73 50.7 TOTAL PROFESSIONAL SERVICES .00 2,495.15 4,924.88 2,429.73 50.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:57PM PAGE:66 TOTAL BROWNFIELD HAZARDOUS .00 2,495.15 6,032.42 3,537.27 41.4 BROWNFIELD PETROLEUM PURCHASED SERVICES: 42-5871-2123 MEALS/LODGING/TRAVEL .00 .00 1,107.53 1,107.53 .0 TOTAL PURCHASED SERVICES .00 .00 1,107.53 1,107.53 .0 PROFESSIONAL SERVICES: 42-5871-2158 MISC CONTRACTUAL SERVICES .00 .00 3,037.10 3,037.10 .0 TOTAL PROFESSIONAL SERVICES .00 .00 3,037.10 3,037.10 .0 TOTAL BROWNFIELD PETROLEUM .00 .00 4,144.63 4,144.63 .0 NEW FRONTIER INITIATIV PROFESSIONAL SERVICES: 42-5872-2158 MISC CONTRACTUAL SERVICES .00 .00 1,000,000.00 1,000,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 1,000,000.00 1,000,000.00 .0 TOTAL NEW FRONTIER INITIATIV .00 .00 1,000,000.00 1,000,000.00 .0 TOTAL FUND EXPENDITURES .00 2,495.15 1,010,177.05 1,007,681.90 .3 NET REVENUE OVER EXPENDITURES 956.10 ( 1,317.93) 2,495.95 3,813.88 ( 52.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:58PM PAGE:67 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND 224,353.98 TOTAL CASH 224,353.98 TOTAL CURRENT ASSETS 224,353.98 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 224,353.98 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 47-20000201 ALLOCATION FROM AP FUND 62,941.38 TOTAL ACCOUNTS PAYABLE 62,941.38 TOTAL CURRENT LIABILITIES 62,941.38 TOTAL LIABILITIES 62,941.38 NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR ( 258,166.18) 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS ( 36,925.31) OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 198,337.91 BALANCE - CURRENT DATE 161,412.60 TOTAL NET ASSETS 161,412.60 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:58PM PAGE:68 TOTAL LIABILITIES AND NET ASSETS 224,353.98 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:58PM PAGE:69 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME 86.28 432.06 .00 ( 432.06) .0 TOTAL MISC LOCAL REVENUE 86.28 432.06 .00 ( 432.06) .0 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND 125,000.00 500,000.00 500,000.00 .00 100.0 47-4470-5511 TRANSFER FROM IMPACT ASSISTANC 36,559.00 36,559.00 36,559.00 .00 100.0 TOTAL TRANSFERS IN 161,559.00 536,559.00 536,559.00 .00 100.0 TOTAL GENERAL FUND EQUIP RES-REVENUE 161,645.28 536,991.06 536,559.00 ( 432.06) 100.1 TOTAL FUND REVENUE 161,645.28 536,991.06 536,559.00 ( 432.06) 100.1 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE 62,941.38 141,918.15 250,807.00 108,888.85 56.6 47-5470-6548 VEHICLES .00 196,735.00 436,263.00 239,528.00 45.1 TOTAL CAPITALIZED EXPENDITURES 62,941.38 338,653.15 687,070.00 348,416.85 49.3 TOTAL GENERAL FUND EQUIPMENT RESERVE 62,941.38 338,653.15 687,070.00 348,416.85 49.3 TOTAL FUND EXPENDITURES 62,941.38 338,653.15 687,070.00 348,416.85 49.3 NET REVENUE OVER EXPENDITURES 98,703.90 198,337.91 ( 150,511.00) ( 348,848.91) 131.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:59PM PAGE:70 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 1,089,389.44 TOTAL CASH 1,089,389.44 INVESTMENTS: 50-10000120 INVESTMENT POOL ( 8.10) TOTAL INVESTMENTS ( 8.10) TOTAL CURRENT ASSETS 1,089,381.34 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,089,381.34 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 50-20000201 ALLOCATION FROM AP FUND 170,404.35 TOTAL ACCOUNTS PAYABLE 170,404.35 TOTAL CURRENT LIABILITIES 170,404.35 TOTAL LIABILITIES 170,404.35 NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR 405,817.83 50-30000301 RESERVED FUND BALANCE 255,959.63 TOTAL CAPITAL ASSETS 661,777.46 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:59PM PAGE:71 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 257,199.53 BALANCE - CURRENT DATE 918,976.99 TOTAL NET ASSETS 918,976.99 TOTAL LIABILITIES AND NET ASSETS 1,089,381.34 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 02:59PM PAGE:72 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1107 OTHER .00 467,227.04 .00 ( 467,227.04) .0 50-4500-1140 INTEREST INCOME 1,480.74 11,177.12 5,500.00 ( 5,677.12) 203.2 TOTAL MISC LOCAL REVENUE 1,480.74 478,404.16 5,500.00 ( 472,904.16) 8698.3 TRANSFERS IN: 50-4500-5510 TRANSFER FROM GENERAL FUND 62,500.00 250,000.00 250,000.00 .00 100.0 TOTAL TRANSFERS IN 62,500.00 250,000.00 250,000.00 .00 100.0 TOTAL FIRE EQUIPMENT - REVENUE 63,980.74 728,404.16 255,500.00 ( 472,904.16) 285.1 TOTAL FUND REVENUE 63,980.74 728,404.16 255,500.00 ( 472,904.16) 285.1 FIRE EQUIPMENT CAPITALIZED EXPENDITURES: 50-5500-6548 BUILDINGS 170,404.35 471,204.63 300,800.00 ( 170,404.63) 156.7 TOTAL CAPITALIZED EXPENDITURES 170,404.35 471,204.63 300,800.00 ( 170,404.63) 156.7 TOTAL FIRE EQUIPMENT 170,404.35 471,204.63 300,800.00 ( 170,404.63) 156.7 TOTAL FUND EXPENDITURES 170,404.35 471,204.63 300,800.00 ( 170,404.63) 156.7 NET REVENUE OVER EXPENDITURES ( 106,423.61) 257,199.53 ( 45,300.00) ( 302,499.53) 567.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:00PM PAGE:73 ASSETS CURRENT ASSETS: CASH: 53-10000116 CASH ALLOC FR COMBINED FUND 7,321.66 TOTAL CASH 7,321.66 TOTAL CURRENT ASSETS 7,321.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 7,321.66 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 53-30000300 FUND BALANCE/BEGINNING OF YEAR 7,321.66 TOTAL CAPITAL ASSETS 7,321.66 TOTAL NET ASSETS 7,321.66 TOTAL LIABILITIES AND NET ASSETS 7,321.66 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:00PM PAGE:74 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 74,339.90 TOTAL CASH 74,339.90 TOTAL CURRENT ASSETS 74,339.90 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 74,339.90 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 54-20000201 ALLOCATION FROM AP FUND 1,825.00 TOTAL ACCOUNTS PAYABLE 1,825.00 TOTAL CURRENT LIABILITIES 1,825.00 TOTAL LIABILITIES 1,825.00 NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 65,574.90 TOTAL CAPITAL ASSETS 65,574.90 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 6,940.00 BALANCE - CURRENT DATE 72,514.90 TOTAL NET ASSETS 72,514.90 TOTAL LIABILITIES AND NET ASSETS 74,339.90 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:00PM PAGE:75 TRAIN CAR RESTORATION TRANSFERS IN: 54-4540-5510 TRANSFER FROM GENERAL FUND 6,250.00 25,000.00 25,000.00 .00 100.0 TOTAL TRANSFERS IN 6,250.00 25,000.00 25,000.00 .00 100.0 TOTAL TRAIN CAR RESTORATION 6,250.00 25,000.00 25,000.00 .00 100.0 TOTAL FUND REVENUE 6,250.00 25,000.00 25,000.00 .00 100.0 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE 1,825.00 18,060.00 40,000.00 21,940.00 45.2 TOTAL PROFESSIONAL SERVICES 1,825.00 18,060.00 40,000.00 21,940.00 45.2 TOTAL TRAIN CAR RESTORATION 1,825.00 18,060.00 40,000.00 21,940.00 45.2 TOTAL FUND EXPENDITURES 1,825.00 18,060.00 40,000.00 21,940.00 45.2 NET REVENUE OVER EXPENDITURES 4,425.00 6,940.00 ( 15,000.00) ( 21,940.00) 46.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:00PM PAGE:76 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 304,574.98 TOTAL CASH 304,574.98 INVESTMENTS: 55-10000122 TIME DEPOSITS - SHORT TERM 251,161.98 TOTAL INVESTMENTS 251,161.98 ACCOUNTS RECEIVABLE: 55-10000139 ACCRUED INTEREST RECEIVABLE 229.81 TOTAL ACCOUNTS RECEIVABLE 229.81 TOTAL CURRENT ASSETS 555,966.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 555,966.77 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 55-20000201 ACCOUNTS PAY ALLOC TO FUNDS 50,715.30 TOTAL ACCOUNTS PAYABLE 50,715.30 TOTAL CURRENT LIABILITIES 50,715.30 TOTAL LIABILITIES 50,715.30 NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 406,505.02 TOTAL CAPITAL ASSETS 406,505.02 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:00PM PAGE:77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 98,746.45 BALANCE - CURRENT DATE 505,251.47 TOTAL NET ASSETS 505,251.47 TOTAL LIABILITIES AND NET ASSETS 555,966.77 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:00PM PAGE:78 POOL IMPROVEMENTS - REVENUE MISC LOCAL REVENUE: 55-4550-1140 INTEREST INCOME 765.49 6,110.83 .00 ( 6,110.83) .0 TOTAL MISC LOCAL REVENUE 765.49 6,110.83 .00 ( 6,110.83) .0 TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND 62,500.00 250,000.00 250,000.00 .00 100.0 TOTAL TRANSFERS IN 62,500.00 250,000.00 250,000.00 .00 100.0 TOTAL POOL IMPROVEMENTS - REVENUE 63,265.49 256,110.83 250,000.00 ( 6,110.83) 102.4 TOTAL FUND REVENUE 63,265.49 256,110.83 250,000.00 ( 6,110.83) 102.4 POOL IMPROVEMENTS PROFESSIONAL SERVICES: 55-5550-2153 ARCHITECT/ENGINEERING/SURVEY 36,600.00 50,000.00 50,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES 36,600.00 50,000.00 50,000.00 .00 100.0 CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG 14,115.30 107,364.38 200,000.00 92,635.62 53.7 TOTAL CAPITALIZED EXPENDITURES 14,115.30 107,364.38 200,000.00 92,635.62 53.7 HOMELAND SECURITY: 55-5550-9000 CONTINGENCY .00 .00 250,000.00 250,000.00 .0 TOTAL HOMELAND SECURITY .00 .00 250,000.00 250,000.00 .0 TOTAL POOL IMPROVEMENTS 50,715.30 157,364.38 500,000.00 342,635.62 31.5 TOTAL FUND EXPENDITURES 50,715.30 157,364.38 500,000.00 342,635.62 31.5 NET REVENUE OVER EXPENDITURES 12,550.19 98,746.45 ( 250,000.00) ( 348,746.45) 39.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:01PM PAGE:79 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 1,086,415.59 TOTAL CASH 1,086,415.59 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 16,025,971.75 TOTAL INVESTMENTS 16,025,971.75 ACCOUNTS RECEIVABLE: 56-10000131 ACCOUNTS RECEIVABLE - GENERAL 7,383.98 56-10000139 ACCRUED INTEREST RECEIVABLE 24,195.15 TOTAL ACCOUNTS RECEIVABLE 31,579.13 TOTAL CURRENT ASSETS 17,143,966.47 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 17,143,966.47 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 56,419.20 56-20000210 RETAINAGE PAYABLE 58,606.72 TOTAL ACCOUNTS PAYABLE 115,025.92 TOTAL CURRENT LIABILITIES 115,025.92 TOTAL LIABILITIES 115,025.92 NET ASSETS CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 18,913,673.53 TOTAL CAPITAL ASSETS 18,913,673.53 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:01PM PAGE:80 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1,884,732.98) BALANCE - CURRENT DATE 17,028,940.55 TOTAL NET ASSETS 17,028,940.55 TOTAL LIABILITIES AND NET ASSETS 17,143,966.47 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:01PM PAGE:81 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1140 INTEREST INCOME 105,431.75 505,455.64 360,000.00 ( 145,455.64) 140.4 TOTAL MISC LOCAL REVENUE 105,431.75 505,455.64 360,000.00 ( 145,455.64) 140.4 FEDERAL REVENUE SOURCES: 56-4560-4289 WYDOT 108,364.03 123,888.94 .00 ( 123,888.94) .0 TOTAL FEDERAL REVENUE SOURCES 108,364.03 123,888.94 .00 ( 123,888.94) .0 TRANSFERS IN: 56-4560-5511 TRANSFER FROM IMPACT ASSISTANC .00 .00 1,545,110.00 1,545,110.00 .0 TOTAL TRANSFERS IN .00 .00 1,545,110.00 1,545,110.00 .0 TOTAL STREET IMPROVEMENTS-REVENUE 213,795.78 629,344.58 1,905,110.00 1,275,765.42 33.0 TOTAL FUND REVENUE 213,795.78 629,344.58 1,905,110.00 1,275,765.42 33.0 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 22,081.86 394,484.60 879,500.00 485,015.40 44.9 56-5560-2158 MISC CONTRACTUAL SERVICES 21,675.00 355,095.75 340,605.00 ( 14,490.75) 104.3 TOTAL PROFESSIONAL SERVICES 43,756.86 749,580.35 1,220,105.00 470,524.65 61.4 CAPITALIZED EXPENDITURES: 56-5560-6544 OTHER THAN BLDG 32,917.41 1,764,497.21 5,861,500.00 4,097,002.79 30.1 56-5560-6547 EQUIPMENT/FURNITURE .00 .00 20,000.00 20,000.00 .0 TOTAL CAPITALIZED EXPENDITURES 32,917.41 1,764,497.21 5,881,500.00 4,117,002.79 30.0 TOTAL STREET IMPROVEMENTS 76,674.27 2,514,077.56 7,101,605.00 4,587,527.44 35.4 TOTAL FUND EXPENDITURES 76,674.27 2,514,077.56 7,101,605.00 4,587,527.44 35.4 NET REVENUE OVER EXPENDITURES 137,121.51 ( 1,884,732.98) ( 5,196,495.00) ( 3,311,762.02) ( 36.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:01PM PAGE:82 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 117,929.61 TOTAL CASH 117,929.61 INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 3,276,917.87 TOTAL INVESTMENTS 3,276,917.87 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 2,371.30 TOTAL ACCOUNTS RECEIVABLE 2,371.30 TOTAL CURRENT ASSETS 3,397,218.78 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,397,218.78 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 197,326.22 57-20000210 RETAINAGE PAYABLE 11,143.82 TOTAL ACCOUNTS PAYABLE 208,470.04 TOTAL CURRENT LIABILITIES 208,470.04 TOTAL LIABILITIES 208,470.04 NET ASSETS CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 3,552,447.07 TOTAL CAPITAL ASSETS 3,552,447.07 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:01PM PAGE:83 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 363,698.33) BALANCE - CURRENT DATE 3,188,748.74 TOTAL NET ASSETS 3,188,748.74 TOTAL LIABILITIES AND NET ASSETS 3,397,218.78 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:01PM PAGE:84 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME 27,445.57 81,289.20 31,500.00 ( 49,789.20) 258.1 TOTAL MISC LOCAL REVENUE 27,445.57 81,289.20 31,500.00 ( 49,789.20) 258.1 TOTAL CAPITAL IMP - FACILITIES REV 27,445.57 81,289.20 31,500.00 ( 49,789.20) 258.1 TOTAL FUND REVENUE 27,445.57 81,289.20 31,500.00 ( 49,789.20) 258.1 CAPITAL IMP -FACILITIES PROFESSIONAL SERVICES: 57-5570-2153 ARCHITECT/ENGINEERING/SURVEY 13,166.50 72,824.00 70,000.00 ( 2,824.00) 104.0 TOTAL PROFESSIONAL SERVICES 13,166.50 72,824.00 70,000.00 ( 2,824.00) 104.0 CAPITALIZED EXPENDITURES: 57-5570-6542 BUILDINGS/IMPROVEMENTS 81,113.03 158,071.55 297,700.00 139,628.45 53.1 57-5570-6544 OTHER THAN BLDG 91,000.00 159,200.00 420,000.00 260,800.00 37.9 57-5570-6547 EQUIPMENT/FURNITURE .00 54,891.98 100,000.00 45,108.02 54.9 TOTAL CAPITALIZED EXPENDITURES 172,113.03 372,163.53 817,700.00 445,536.47 45.5 HOMELAND SECURITY: 57-5570-9000 CONTINGENCY ( 55,209.26) .00 650,000.00 650,000.00 .0 TOTAL HOMELAND SECURITY ( 55,209.26) .00 650,000.00 650,000.00 .0 TOTAL CAPITAL IMP -FACILITIES 130,070.27 444,987.53 1,537,700.00 1,092,712.47 28.9 TOTAL FUND EXPENDITURES 130,070.27 444,987.53 1,537,700.00 1,092,712.47 28.9 NET REVENUE OVER EXPENDITURES ( 102,624.70) ( 363,698.33) ( 1,506,200.00) ( 1,142,501.67) ( 24.2) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:02PM PAGE:85 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 1,221,277.80 TOTAL CASH 1,221,277.80 INVESTMENTS: 65-10000120 INVESTMENT POOL 607,666.34 65-10000122 TIME DEPOSITS - SHORT TERM 1,864,627.82 TOTAL INVESTMENTS 2,472,294.16 ACCOUNTS RECEIVABLE: 65-10000139 ACCRUED INTEREST RECEIVABLE 5,122.59 TOTAL ACCOUNTS RECEIVABLE 5,122.59 TOTAL CURRENT ASSETS 3,698,694.55 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,698,694.55 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 135,437.20 65-20000210 RETAINAGE PAYABLE 5,982.38 TOTAL ACCOUNTS PAYABLE 141,419.58 TOTAL CURRENT LIABILITIES 141,419.58 TOTAL LIABILITIES 141,419.58 NET ASSETS CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 3,809,900.63 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 3,832,816.52 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:02PM PAGE:86 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 275,541.55) BALANCE - CURRENT DATE 3,557,274.97 TOTAL NET ASSETS 3,557,274.97 TOTAL LIABILITIES AND NET ASSETS 3,698,694.55 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:02PM PAGE:87 PARK - REVE REVENUE: 65-4650-0160 GAIN ON INVESTMENTS 1,022.23 8,635.24 .00 ( 8,635.24) .0 TOTAL REVENUE 1,022.23 8,635.24 .00 ( 8,635.24) .0 MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME 7,756.89 86,507.95 72,500.00 ( 14,007.95) 119.3 TOTAL MISC LOCAL REVENUE 7,756.89 86,507.95 72,500.00 ( 14,007.95) 119.3 TOTAL PARK - REVE 8,779.12 95,143.19 72,500.00 ( 22,643.19) 131.2 TOTAL FUND REVENUE 8,779.12 95,143.19 72,500.00 ( 22,643.19) 131.2 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY .00 2,147.50 77,000.00 74,852.50 2.8 65-5650-2158 MISC CONTRACTUAL SERVICES 30,000.00 30,000.00 .00 ( 30,000.00) .0 TOTAL PROFESSIONAL SERVICES 30,000.00 32,147.50 77,000.00 44,852.50 41.8 OPERATING TRANSFERS: 65-5650-4345 INVESTMENT FEES .00 .00 500.00 500.00 .0 TOTAL OPERATING TRANSFERS .00 .00 500.00 500.00 .0 CAPITALIZED EXPENDITURES: 65-5650-6542 BUILDINGS/IMPROVEMENTS 8,296.76 8,296.76 18,800.00 10,503.24 44.1 65-5650-6544 OTHER THAN BLDG 98,187.44 330,240.48 876,000.00 545,759.52 37.7 TOTAL CAPITALIZED EXPENDITURES 106,484.20 338,537.24 894,800.00 556,262.76 37.8 HOMELAND SECURITY: 65-5650-9000 CONTINGENCY .00 .00 350,000.00 350,000.00 .0 TOTAL HOMELAND SECURITY .00 .00 350,000.00 350,000.00 .0 TOTAL PARK IMPROVEMENTS 136,484.20 370,684.74 1,322,300.00 951,615.26 28.0 TOTAL FUND EXPENDITURES 136,484.20 370,684.74 1,322,300.00 951,615.26 28.0 NET REVENUE OVER EXPENDITURES ( 127,705.08) ( 275,541.55) ( 1,249,800.00) ( 974,258.45) ( 22.1) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:88 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 4,358.90 TOTAL CASH 4,358.90 INVESTMENTS: 90-10000120 INVESTMENT POOL 115,258.56 90-10000122 TIME DEPOSITS - SHORT TERM 66,036.30 TOTAL INVESTMENTS 181,294.86 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 75.79 TOTAL ACCOUNTS RECEIVABLE 75.79 TOTAL CURRENT ASSETS 185,729.55 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 185,729.55 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 41,717.36 TOTAL CAPITAL ASSETS 41,717.36 RESTRICTED ASSETS: 90-30000315 FUND BALANCE RESTRICTED 141,610.40 TOTAL RESTRICTED ASSETS 141,610.40 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,401.79 BALANCE - CURRENT DATE 185,729.55 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:89 TOTAL NET ASSETS 185,729.55 TOTAL LIABILITIES AND NET ASSETS 185,729.55 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:90 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES 125.00 1,750.00 3,000.00 1,250.00 58.3 TOTAL REVENUE 125.00 1,750.00 3,000.00 1,250.00 58.3 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 651.79 6,601.31 6,500.00 ( 101.31) 101.6 TOTAL MISC LOCAL REVENUE 651.79 6,601.31 6,500.00 ( 101.31) 101.6 TOTAL PERPETUAL CARE - REVENUE 776.79 8,351.31 9,500.00 1,148.69 87.9 TOTAL FUND REVENUE 776.79 8,351.31 9,500.00 1,148.69 87.9 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 1,098.11 5,949.52 6,500.00 550.48 91.5 TOTAL TRANSFERS TO OTHER FUNDS 1,098.11 5,949.52 6,500.00 550.48 91.5 TOTAL PERPETUAL CARE 1,098.11 5,949.52 6,500.00 550.48 91.5 TOTAL FUND EXPENDITURES 1,098.11 5,949.52 6,500.00 550.48 91.5 NET REVENUE OVER EXPENDITURES ( 321.32) 2,401.79 3,000.00 598.21 80.1 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:91 ASSETS CURRENT ASSETS: CASH: 91-10000116 CASH ALLOC FR COMBINED FUND 105.39 TOTAL CASH 105.39 TOTAL CURRENT ASSETS 105.39 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 105.39 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 91-20000400 SPECIFIED MEMORIALS 100.00 91-20000401 ONGOING MEMORIAL FUND 5.39 TOTAL OTHER PAYABLES 105.39 TOTAL CURRENT LIABILITIES 105.39 TOTAL LIABILITIES 105.39 TOTAL LIABILITIES AND NET ASSETS 105.39 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:92 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 22,672.15 TOTAL CASH 22,672.15 TOTAL CURRENT ASSETS 22,672.15 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 22,672.15 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 1,028.03 92-20000406 HISTORIC PRESERVATION 3,401.20 92-20000407 HISTORIC PRESERVATION-KIOSK 16,776.53 92-20000408 HISTORIC PRESERVATION - MOVIE 615.38 TOTAL OTHER PAYABLES 21,821.14 TOTAL CURRENT LIABILITIES 21,821.14 TOTAL LIABILITIES 21,821.14 NET ASSETS CAPITAL ASSETS: 92-30000300 FUND BALANCE/BEGINNING OF YEAR ( 485.07) TOTAL CAPITAL ASSETS ( 485.07) OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,336.08 BALANCE - CURRENT DATE 851.01 TOTAL NET ASSETS 851.01 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:93 TOTAL LIABILITIES AND NET ASSETS 22,672.15 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:94 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 450.00 1,800.00 1,800.00 .00 100.0 TOTAL TRANSFERS IN 450.00 1,800.00 1,800.00 .00 100.0 TOTAL HISTORIC CMSN - REVENU 450.00 1,800.00 1,800.00 .00 100.0 TOTAL FUND REVENUE 450.00 1,800.00 1,800.00 .00 100.0 HISTORIC PRESERVATION PROFESSIONAL SERVICES: 92-5920-2158 MISC CONTRACTUAL SERVICES .00 463.92 1,800.00 1,336.08 25.8 TOTAL PROFESSIONAL SERVICES .00 463.92 1,800.00 1,336.08 25.8 TOTAL HISTORIC PRESERVATION .00 463.92 1,800.00 1,336.08 25.8 TOTAL FUND EXPENDITURES .00 463.92 1,800.00 1,336.08 25.8 NET REVENUE OVER EXPENDITURES 450.00 1,336.08 .00 ( 1,336.08) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:04PM PAGE:95 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 11,297.79 TOTAL CASH 11,297.79 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 93,640.36 TOTAL INVESTMENTS 93,640.36 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 118.04 TOTAL ACCOUNTS RECEIVABLE 118.04 TOTAL CURRENT ASSETS 105,056.19 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 105,056.19 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 93.71 TOTAL ACCOUNTS PAYABLE 93.71 OTHER LIABILITIES PAYABLE: 96-20000229 UTILITY DEPOSITS 91,149.09 TOTAL OTHER LIABILITIES PAYABLE 91,149.09 TOTAL CURRENT LIABILITIES 91,242.80 TOTAL LIABILITIES 91,242.80 NET ASSETS CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 11,469.67 TOTAL CAPITAL ASSETS 11,469.67 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:05PM PAGE:96 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,343.72 BALANCE - CURRENT DATE 13,813.39 TOTAL NET ASSETS 13,813.39 TOTAL LIABILITIES AND NET ASSETS 105,056.19 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2024 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:05PM PAGE:97 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME 275.58 2,343.72 .00 ( 2,343.72) .0 TOTAL MISC LOCAL REVENUE 275.58 2,343.72 .00 ( 2,343.72) .0 TOTAL UTILITY DEPOSITS - REVENUE 275.58 2,343.72 .00 ( 2,343.72) .0 TOTAL FUND REVENUE 275.58 2,343.72 .00 ( 2,343.72) .0 NET REVENUE OVER EXPENDITURES 275.58 2,343.72 .00 ( 2,343.72) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2024 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 07/25/2024 03:05PM PAGE:98 ASSETS CURRENT ASSETS: CASH: 97-10000116 CASH ALLOC FR COMBINED FUND 39.61 TOTAL CASH 39.61 TOTAL CURRENT ASSETS 39.61 NON-CURRENT ASSETS: INVESTMENTS: 97-10000173 SECURITIES - LONG TERM 5,373,403.49 97-10000174 INVESTMENTS - RHSA 504,804.41 TOTAL INVESTMENTS 5,878,207.90 TOTAL NON-CURRENT ASSETS 5,878,207.90 TOTAL ASSETS 5,878,247.51 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 97-30000300 FUND BALANCE/BEGINNING OF YEAR 5,878,247.51 TOTAL CAPITAL ASSETS 5,878,247.51 TOTAL NET ASSETS 5,878,247.51 TOTAL LIABILITIES AND NET ASSETS 5,878,247.51