Document Douglas_doc_76f5f1c8ec

CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2023 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 34,076,881.91 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 58,190.42 01-10000106 CASH - XPRESS DEPOSIT ACCOUNT 264,457.13 01-10000113 CASH ON HAND 575.00 TOTAL COMBINED CASH 34,400,104.46 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 34,400,104.46) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 3 ALLOCATION TO ACCOUNTS PAYABLE FUND ( 28,661.69) 10 ALLOCATION TO GENERAL FUND 14,745,645.47 11 ALLOCATION TO IMPACT ASSISTANCE FUND 566,636.38 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 23,267.58 31 ALLOCATION TO WATER FUND 4,773,028.09 32 ALLOCATION TO SEWER FUND 19,954.07 33 ALLOCATION TO SANITATION FUND 735,535.52 34 ALLOCATION TO LANDFILL FUND 637,821.24 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 233,238.03 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 45,022.73 41 ALLOCATION TO ECONOMIC DEVELOPMENT 221,096.42 42 ALLOCATION TO BROWNFIELD GRANT ( 6,697.67) 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE ( 36,925.31) 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 661,785.56 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 7,321.66 54 ALLOCATION TO TRAIN CAR RESTORATION 66,539.90 55 ALLOCATION TO POOL IMPROVEMENTS FUND 167,134.06 56 ALLOCATION TO STREET IMPROVEMENT FUND 7,589,310.55 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 2,325,468.45 65 ALLOCATION TO CAPTL PROJ-PARK FUND 1,613,079.68 90 ALLOCATION TO PERPETUAL CARE FUND 8,450.84 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 103.74 92 ALLOCATION TO HISTORIC CMSN FUND 21,620.20 96 ALLOCATION TO UTILITY DEPOSIT FUND 10,289.35 97 ALLOCATION TO DEFERRED COMP TRUST FUND 39.61 TOTAL ALLOCATIONS TO OTHER FUNDS 34,400,104.46 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 34,400,104.46) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS PAYABLES CLEARING FUND ALLOCATIONS JUNE 30, 2023 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:2 PAYROLL PAYABLES 03-20000215 WAGES PAYABLE - CLEARING ( 28,661.69) TOTAL PAYROLL PAYABLES ( 28,661.69) TOTAL UNALLOCATED PAYROLL PAYABLES ( 28,661.69) PAYROLL PAYABLES ALLOCATION RECONCILIATION TOTAL ALLOCATIONS TO OTHER FUNDS .00 ALLOCATION FROM PAYABLES CLEARING FUND - 03-20000221 ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:3 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 14,745,645.47 TOTAL CASH 14,745,645.47 INVESTMENTS: 10-10000120 INVESTMENT POOL 10,096,515.71 10-10000122 TIME DEPOSITS - SHORT TERM 16,314,066.19 TOTAL INVESTMENTS 26,410,581.90 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 65,855.08 10-10000131 ACCOUNTS RECEIVABLE - GENERAL 162,913.81 10-10000132 ACCOUNTS REC - PROPERTY TAX 570,923.18 10-10000133 ACCOUNTS CRT 4,549.55 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 2,657,536.74 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 736.84 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 3,836.84) 10-10000139 ACCRUED INTEREST RECEIVABLE 34,829.68 10-10000159 DUE FROM OTHER FUNDS 115,087.31 TOTAL ACCOUNTS RECEIVABLE 3,608,595.35 TOTAL CURRENT ASSETS 44,764,822.72 NON-CURRENT ASSETS: INVESTMENTS: 10-10000170 PREPAID EXPENSE 29,539.00 TOTAL INVESTMENTS 29,539.00 TOTAL NON-CURRENT ASSETS 29,539.00 TOTAL ASSETS 44,794,361.72 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:4 ACCOUNTS PAYABLE: 10-20000200 DEFERRED INFLOW 519,050.46 10-20000201 ALLOCATION FROM AP FUND 466,603.05 10-20000204 ACCOUNTS PAYABLE - EOY ( 130,302.52) 10-20000206 FUNDS PAYABLE - DUE TO OTHERS ( 62.73) 10-20000208 SURCHARGE PAYABLE 2,405.00 10-20000212 SURCHARGE - CITY - E CITATION 3,665.00 10-20000213 DONATION-POLICE DEPARTMENT USE 188.59 10-20000215 WAGES PAYABLE 41,457.09 10-20000216 WAGES PAYABLE - EOY ( 9,480.27) 10-20000217 DUE TO OTHERS 40.00 TOTAL ACCOUNTS PAYABLE 893,563.67 PAYROLL DEDUCTIONS PAYABLE: 10-20000223 FICA PAYABLE ( 12,333.33) 10-20000224 DEFERRED COMPENSATION PAYABLE 52,787.22 10-20000227 WORKERS COMP INS PAYABLE 25,913.00 TOTAL PAYROLL DEDUCTIONS PAYABLE 66,366.89 OTHER LIABILITIES PAYABLE: 10-20000228 UNCLAIMED PROPERTY 17,368.37 TOTAL OTHER LIABILITIES PAYABLE 17,368.37 DUE TO OTHER FUNDS: 10-20000245 DUE TO OTHER FUNDS 121,947.29 TOTAL DUE TO OTHER FUNDS 121,947.29 DEFERRED REVENUE: 10-20000300 DEFERRED REVENUE 1,105,117.04 TOTAL DEFERRED REVENUE 1,105,117.04 TOTAL CURRENT LIABILITIES 2,204,363.26 TOTAL LIABILITIES 2,204,363.26 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 30,599,766.73 10-30000301 FUND BALANCE RESERVE 3,770,000.00 10-30000302 RESERVE FOR SEWER LIFT STATION 840,000.00 TOTAL CAPITAL ASSETS 35,209,766.73 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:5 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 7,380,231.73 BALANCE - CURRENT DATE 42,589,998.46 TOTAL NET ASSETS 42,589,998.46 TOTAL LIABILITIES AND NET ASSETS 44,794,361.72 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:6 GENERAL - REVENUE REVENUE: 10-4100-0160 GAIN ON INVESTMENTS ( 25,672.81) ( 110,030.05) .00 110,030.05 .0 TOTAL REVENUE ( 25,672.81) ( 110,030.05) .00 110,030.05 .0 MISC LOCAL REVENUE: 10-4100-1101 REIMBURSEMENT - CCSD ( 26,661.42) 61,848.54 .00 ( 61,848.54) .0 10-4100-1107 OTHER 370.00 3,930.70 5,000.00 1,069.30 78.6 10-4100-1108 COPY FEES/VIN CHECKS 565.00 5,495.00 5,000.00 ( 495.00) 109.9 10-4100-1109 REIMBURSEMENTS 1,320.00 106,957.05 80,000.00 ( 26,957.05) 133.7 10-4100-1112 CONTRIBUTIONS 10,449.06 37,949.06 14,000.00 ( 23,949.06) 271.1 10-4100-1115 LEASES/RENT 850.00 5,700.00 6,200.00 500.00 91.9 10-4100-1120 FINES/FORFEITS 2,662.00 19,635.00 25,000.00 5,365.00 78.5 10-4100-1130 CASH LONG/SHORT .00 .27 .00 ( .27) .0 10-4100-1140 INTEREST INCOME 122,751.99 905,018.97 350,000.00 ( 555,018.97) 258.6 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 .00 30,000.00 30,000.00 .0 TOTAL MISC LOCAL REVENUE 112,306.63 1,146,534.59 515,200.00 ( 631,334.59) 222.5 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 225.00 20,975.00 20,000.00 ( 975.00) 104.9 TOTAL LIQUOR LICENSES 225.00 20,975.00 20,000.00 ( 975.00) 104.9 OTHER LICENSES/PERMITS: 10-4100-1230 LICENSES - TRANSIENT MERCHANT .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 25.00 14,164.00 15,000.00 836.00 94.4 TOTAL CONTRACTORS LICENSES 25.00 14,164.00 15,000.00 836.00 94.4 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 819.26 21,442.01 30,000.00 8,557.99 71.5 TOTAL BUILDING PERMITS 819.26 21,442.01 30,000.00 8,557.99 71.5 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 450.00 2,430.00 2,000.00 ( 430.00) 121.5 TOTAL ZONING/CONDITIONAL USE 450.00 2,430.00 2,000.00 ( 430.00) 121.5 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:7 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 39,729.37 515,851.27 450,000.00 ( 65,851.27) 114.6 10-4100-1321 PROPERTY TAX - PRIOR YEARS 273.91 1,111.23 1,000.00 ( 111.23) 111.1 10-4100-1322 PROPERTY TAX - AUTO 17,842.10 191,842.14 175,000.00 ( 16,842.14) 109.6 10-4100-1323 PROPERTY TAX - INTEREST 291.34 3,457.22 1,000.00 ( 2,457.22) 345.7 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 290.02) ( 3,558.29) ( 2,500.00) 1,058.29 ( 142.3) TOTAL PROPERTY TAXES 57,846.70 708,703.57 624,500.00 ( 84,203.57) 113.5 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 16,683.21 234,825.39 225,000.00 ( 9,825.39) 104.4 10-4100-1331 FRANCHISE FEES - CABLE TV .00 10,118.49 14,000.00 3,881.51 72.3 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 37,321.57 35,000.00 ( 2,321.57) 106.6 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 6,440.64 7,500.00 1,059.36 85.9 TOTAL FRANCHISE FEES 16,683.21 288,706.09 281,500.00 ( 7,206.09) 102.6 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 26,214.25 104,857.00 104,857.00 .00 100.0 10-4100-1421 MANAGEMENT FEES - WATER 68,157.25 272,629.00 272,629.00 .00 100.0 10-4100-1422 MANAGEMENT FEES - SEWER 34,078.50 136,314.00 136,314.00 .00 100.0 10-4100-1423 MANAGEMENT FEES - SANITATION 26,214.25 104,857.00 104,857.00 .00 100.0 TOTAL MANAGEMENT FEES 154,664.25 618,657.00 618,657.00 .00 100.0 WEED ABATEMENT: 10-4100-1431 PEST CONTROL .00 14,751.60 14,500.00 ( 251.60) 101.7 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 45,974.89 35,000.00 ( 10,974.89) 131.4 TOTAL WEED ABATEMENT .00 60,726.49 49,500.00 ( 11,226.49) 122.7 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 1,950.00 15,900.00 15,000.00 ( 900.00) 106.0 TOTAL BURIAL FEES 1,950.00 15,900.00 15,000.00 ( 900.00) 106.0 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES .00 8,450.00 7,500.00 ( 950.00) 112.7 TOTAL LOT SALES .00 8,450.00 7,500.00 ( 950.00) 112.7 POOL: 10-4100-1650 POOL - USER FEES .00 26,590.00 20,000.00 ( 6,590.00) 133.0 TOTAL POOL .00 26,590.00 20,000.00 ( 6,590.00) 133.0 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 295,120.24 200,000.00 ( 95,120.24) 147.6 10-4100-3111 SEVERENCE TAX - 2% 57,143.34 228,573.36 225,000.00 ( 3,573.36) 101.6 10-4100-3112 MINERAL ROYALTIES 75,252.70 315,958.23 300,000.00 ( 15,958.23) 105.3 TOTAL MINERAL EXTRACTION 132,396.04 839,651.83 725,000.00 ( 114,651.83) 115.8 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:8 SALES TAX: 10-4100-3241 SALES TAX - STATE 800,825.10 9,062,593.09 4,500,000.00 ( 4,562,593.09) 201.4 10-4100-3245 SALES TAX - LOCAL OPTION 653,379.36 7,399,710.74 4,000,000.00 ( 3,399,710.74) 185.0 TOTAL SALES TAX 1,454,204.46 16,462,303.83 8,500,000.00 ( 7,962,303.83) 193.7 GAS TAX: 10-4100-3250 LOTTERY .00 134,521.99 45,000.00 ( 89,521.99) 298.9 10-4100-3257 GAS TAX 17,679.62 236,930.13 230,000.00 ( 6,930.13) 103.0 10-4100-3258 SPECIAL FUELS 4,838.14 65,572.06 65,000.00 ( 572.06) 100.9 TOTAL GAS TAX 22,517.76 437,024.18 340,000.00 ( 97,024.18) 128.5 OTHER: 10-4100-3262 CIGARETTE TAX 3,120.88 41,603.44 45,000.00 3,396.56 92.5 TOTAL OTHER 3,120.88 41,603.44 45,000.00 3,396.56 92.5 STATE REVENUE: 10-4100-3374 SLIB .00 467,822.01 467,822.00 ( .01) 100.0 TOTAL STATE REVENUE .00 467,822.01 467,822.00 ( .01) 100.0 TOTAL GENERAL - REVENUE 1,931,536.38 21,071,853.99 12,276,679.00 ( 8,795,174.99) 171.6 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 1,488.17 4,754.17 4,988.00 233.83 95.3 TOTAL OPERATING TRANSFERS IN 1,488.17 4,754.17 4,988.00 233.83 95.3 TOTAL OPERATING TRANSFERS - IN 1,488.17 4,754.17 4,988.00 233.83 95.3 TOTAL FUND REVENUE 1,933,024.55 21,076,608.16 12,281,667.00 ( 8,794,941.16) 171.6 GENERAL GOVT - NON DEPARTMENTL 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 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:9 EMPLOYEE BENEFITS: 10-5100-1021 EMPLOYEE BENEFITS - SCL 1.53 39.79 50.00 10.21 79.6 10-5100-1023 EMPLOYEE BENEFITS - HEALTH INS 29,160.00 29,177.96 23,847.00 ( 5,330.96) 122.4 10-5100-1025 EMPLOYEE BENEFITS - COMP .52 1.30 .00 ( 1.30) .0 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 620.00 4,045.00 2,750.00 ( 1,295.00) 147.1 TOTAL EMPLOYEE BENEFITS 29,782.05 33,264.05 26,647.00 ( 6,617.05) 124.8 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT .00 6,306.65 6,000.00 ( 306.65) 105.1 10-5100-2115 PUBLISHING/ADVERTISING 8,767.00 36,464.99 35,000.00 ( 1,464.99) 104.2 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 30.00 200.00 170.00 15.0 10-5100-2122 TRAINING/DEVELOPMENT .00 .00 5,000.00 5,000.00 .0 10-5100-2123 MEALS/LODGING/TRAVEL 480.97 1,800.97 .00 ( 1,800.97) .0 TOTAL PURCHASED SERVICES 9,247.97 44,602.61 46,200.00 1,597.39 96.5 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 13,480.97 82,546.72 80,000.00 ( 2,546.72) 103.2 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 534.86 2,717.99 3,000.00 282.01 90.6 10-5100-2133 UTILITY SERVICES - NATURAL GAS 203.81 5,637.03 3,500.00 ( 2,137.03) 161.1 10-5100-2134 TELECOMMUNICATIONS 219.87 11,757.53 .00 ( 11,757.53) .0 10-5100-2141 EQUIPMENT - RENT .00 207.36 200.00 ( 7.36) 103.7 TOTAL PROPERTY SERVICES 14,439.51 102,866.63 86,700.00 ( 16,166.63) 118.7 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 8,352.00 43,037.78 50,000.00 6,962.22 86.1 10-5100-2152 ACCOUNTING/AUDITING .00 40,000.00 55,000.00 15,000.00 72.7 10-5100-2155 REPAIRS/MAINTENANCE 1,418.95 5,884.88 5,000.00 ( 884.88) 117.7 10-5100-2156 MAINTENANCE AGREEMENT 1,233.53 7,519.03 6,700.00 ( 819.03) 112.2 10-5100-2157 INSURANCE 250.00 94,078.00 88,000.00 ( 6,078.00) 106.9 10-5100-2158 MISC CONTRACTUAL SERVICES 6,294.27 366,050.98 525,472.00 159,421.02 69.7 10-5100-2166 COLLECTION FEES .00 67.66 100.00 32.34 67.7 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE 400.00 658.67 250.00 ( 408.67) 263.5 TOTAL PROFESSIONAL SERVICES 17,948.75 557,297.00 730,522.00 173,225.00 76.3 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 1,289.87 11,739.85 12,000.00 260.15 97.8 10-5100-3210 OPERATING SUPPLIES 234.70 15,706.15 10,000.00 ( 5,706.15) 157.1 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,207.30 .00 ( 1,207.30) .0 10-5100-3230 REFRESHMENT SUPPLIES 186.04 3,211.07 4,000.00 788.93 80.3 10-5100-3235 FUEL ( 9,897.80) 111,970.02 105,000.00 ( 6,970.02) 106.6 TOTAL SUPPLIES ( 8,187.19) 143,834.39 131,000.00 ( 12,834.39) 109.8 CLAIMS & CONTINGENCY: 10-5100-7601 CLAIMS AGAINST CITY .00 .00 5,000.00 5,000.00 .0 10-5100-7606 UNEMPLOYMENT CLAIMS .00 .00 1,000.00 1,000.00 .0 TOTAL CLAIMS & CONTINGENCY .00 .00 6,000.00 6,000.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:10 TOTAL GENERAL GOVT - NON DEPARTMENTL 138,231.09 1,181,864.68 1,327,069.00 145,204.32 89.1 GENERAL GOVT - CITY COUNCIL PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR .00 16,125.00 18,000.00 1,875.00 89.6 TOTAL PERSONNEL SERVICES .00 16,125.00 18,000.00 1,875.00 89.6 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL .00 1,233.78 1,377.00 143.22 89.6 10-5101-1025 EMPLOYEE BENEFITS - COMP .00 379.08 421.00 41.92 90.0 TOTAL EMPLOYEE BENEFITS .00 1,612.86 1,798.00 185.14 89.7 PURCHASED SERVICES: 10-5101-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 8,027.00 8,000.00 ( 27.00) 100.3 10-5101-2122 TRAINING/DEVELOPMENT .00 1,640.00 2,500.00 860.00 65.6 10-5101-2123 MEALS/LODGING/TRAVEL 1,932.58 3,843.71 2,500.00 ( 1,343.71) 153.8 TOTAL PURCHASED SERVICES 1,932.58 13,510.71 13,000.00 ( 510.71) 103.9 SUPPLIES: 10-5101-3210 OPERATING SUPPLIES .00 33.00 500.00 467.00 6.6 TOTAL SUPPLIES .00 33.00 500.00 467.00 6.6 TOTAL GENERAL GOVT - CITY COUNCIL 1,932.58 31,281.57 33,298.00 2,016.43 93.9 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 32,236.90 397,421.50 453,397.00 55,975.50 87.7 10-5102-1002 SALARIES/WAGES - OVERTIME 531.06 571.52 1,500.00 928.48 38.1 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,155.67 1,156.00 .33 100.0 10-5102-1006 SALARIES/WAGES - ALLOWANCES .00 1,925.00 2,100.00 175.00 91.7 10-5102-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,963.76 8,180.00 6,216.24 24.0 TOTAL PERSONNEL SERVICES 32,767.96 403,037.45 466,333.00 63,295.55 86.4 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,544.94 32,744.35 36,192.00 3,447.65 90.5 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS .00 120,373.10 157,210.00 36,836.90 76.6 10-5102-1025 EMPLOYEE BENEFITS - COMP 851.96 10,478.99 12,074.00 1,595.01 86.8 10-5102-1026 EMPLOYEE BENEFITS - COMP 538.70 6,865.22 6,771.00 ( 94.22) 101.4 10-5102-1029 EMPLOYEE BENEFITS - WY 5,783.54 68,184.89 80,198.00 12,013.11 85.0 TOTAL EMPLOYEE BENEFITS 9,719.14 238,646.55 292,445.00 53,798.45 81.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:11 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,938.00 2,000.00 62.00 96.9 10-5102-2122 TRAINING/DEVELOPMENT 1,087.50 3,842.50 3,600.00 ( 242.50) 106.7 10-5102-2123 MEALS/LODGING/TRAVEL 2,668.55 6,151.52 5,500.00 ( 651.52) 111.9 TOTAL PURCHASED SERVICES 3,756.05 11,932.02 11,100.00 ( 832.02) 107.5 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 232.80 250.00 17.20 93.1 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 119.29 1,000.00 880.71 11.9 TOTAL SUPPLIES .00 352.09 1,250.00 897.91 28.2 TOTAL GENERAL GOVT - ADMIN SERVICES 46,243.15 653,968.11 771,128.00 117,159.89 84.8 GENERAL GOVT - IT PERSONNEL SERVICES: 10-5103-1001 SALARIES/WAGES - REGULAR .00 .00 82,939.00 82,939.00 .0 10-5103-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 1,002.00 1,002.00 .0 TOTAL PERSONNEL SERVICES .00 .00 83,941.00 83,941.00 .0 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL .00 .00 6,421.00 6,421.00 .0 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS .00 .00 26,088.00 26,088.00 .0 10-5103-1025 EMPLOYEE BENEFITS - COMP .00 .00 2,156.00 2,156.00 .0 10-5103-1029 EMPLOYEE BENEFITS - WY .00 .00 14,265.00 14,265.00 .0 TOTAL EMPLOYEE BENEFITS .00 .00 48,930.00 48,930.00 .0 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,980.00 3,500.00 1,520.00 56.6 TOTAL PURCHASED SERVICES .00 1,980.00 3,500.00 1,520.00 56.6 PROFESSIONAL SERVICES: 10-5103-2156 MAINTENANCE AGREEMENT .00 27,298.14 38,120.00 10,821.86 71.6 10-5103-2158 MISC CONTRACTUAL SERVICES 8,333.34 123,028.34 45,500.00 ( 77,528.34) 270.4 TOTAL PROFESSIONAL SERVICES 8,333.34 150,326.48 83,620.00 ( 66,706.48) 179.8 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 43.76 800.00 756.24 5.5 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 23,027.68 54,000.00 30,972.32 42.6 TOTAL SUPPLIES .00 23,071.44 54,800.00 31,728.56 42.1 TOTAL GENERAL GOVT - IT 8,333.34 175,377.92 274,791.00 99,413.08 63.8 GENERAL GOVT - MUNICIPAL COURT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:12 PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 2,888.65 52,425.33 52,426.00 .67 100.0 10-5105-1005 SALARIES/WAGES - LONGEVITY .00 480.79 481.00 .21 100.0 10-5105-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 2,456.00 2,456.00 .0 TOTAL PERSONNEL SERVICES 2,888.65 52,906.12 55,363.00 2,456.88 95.6 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 229.82 4,160.13 4,160.00 ( .13) 100.0 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS .00 6,991.31 7,627.00 635.69 91.7 10-5105-1025 EMPLOYEE BENEFITS - COMP 75.10 1,375.49 1,376.00 .51 100.0 10-5105-1026 EMPLOYEE BENEFITS - COMP 115.54 1,475.13 1,475.00 ( .13) 100.0 10-5105-1029 EMPLOYEE BENEFITS - WY 496.84 6,343.19 6,344.00 .81 100.0 TOTAL EMPLOYEE BENEFITS 917.30 20,345.25 20,982.00 636.75 97.0 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 160.00 160.00 .0 10-5105-2122 TRAINING/DEVELOPMENT .00 150.00 400.00 250.00 37.5 10-5105-2123 MEALS/LODGING/TRAVEL .00 317.95 860.00 542.05 37.0 TOTAL PURCHASED SERVICES .00 467.95 1,420.00 952.05 33.0 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 3,983.63 16,200.66 14,000.00 ( 2,200.66) 115.7 10-5105-2156 MAINTENANCE AGREEMENT 2,400.00 4,998.00 5,180.00 182.00 96.5 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 20.00 250.00 230.00 8.0 TOTAL PROFESSIONAL SERVICES 6,383.63 21,218.66 19,430.00 ( 1,788.66) 109.2 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES 37.95 69.85 500.00 430.15 14.0 10-5105-3233 UNIFORMS/CARE .00 .00 150.00 150.00 .0 TOTAL SUPPLIES 37.95 69.85 650.00 580.15 10.8 TOTAL GENERAL GOVT - MUNICIPAL COURT 10,227.53 95,007.83 97,845.00 2,837.17 97.1 GENERAL GOVT - PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 19,608.75 259,535.32 245,424.00 ( 14,111.32) 105.8 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 848.86 825.00 ( 23.86) 102.9 10-5106-1006 SALARIES/WAGES - ALLOWANCES .00 825.00 900.00 75.00 91.7 10-5106-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 4,796.00 4,796.00 .0 TOTAL PERSONNEL SERVICES 19,608.75 261,209.18 251,945.00 ( 9,264.18) 103.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:13 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,543.33 20,543.39 19,822.00 ( 721.39) 103.6 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS .00 33,286.37 36,901.00 3,614.63 90.2 10-5106-1025 EMPLOYEE BENEFITS - COMP 509.83 6,791.52 6,551.00 ( 240.52) 103.7 10-5106-1026 EMPLOYEE BENEFITS - COMP 565.60 7,331.66 7,164.00 ( 167.66) 102.3 10-5106-1029 EMPLOYEE BENEFITS - WY 2,807.10 35,451.55 35,049.00 ( 402.55) 101.2 TOTAL EMPLOYEE BENEFITS 5,425.86 103,404.49 105,487.00 2,082.51 98.0 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 150.00 1,177.00 1,480.00 303.00 79.5 10-5106-2122 TRAINING/DEVELOPMENT .00 1,506.00 2,735.00 1,229.00 55.1 10-5106-2123 MEALS/LODGING/TRAVEL 258.07 1,864.63 1,910.00 45.37 97.6 TOTAL PURCHASED SERVICES 408.07 4,547.63 6,125.00 1,577.37 74.3 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 99.56 1,196.18 1,250.00 53.82 95.7 TOTAL PROPERTY SERVICES 99.56 1,196.18 1,250.00 53.82 95.7 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 615.00 8,430.35 10,000.00 1,569.65 84.3 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT 253.73 2,968.70 2,700.00 ( 268.70) 110.0 10-5106-2158 MISC CONTRACTUAL SERVICES 25,000.00 25,580.00 32,000.00 6,420.00 79.9 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 1,143.40 750.00 ( 393.40) 152.5 TOTAL PROFESSIONAL SERVICES 25,868.73 38,122.45 46,450.00 8,327.55 82.1 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 925.62 2,045.57 6,350.00 4,304.43 32.2 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 114.94 1,000.00 885.06 11.5 10-5106-3235 FUEL 249.86 628.21 2,000.00 1,371.79 31.4 TOTAL SUPPLIES 1,175.48 2,788.72 9,350.00 6,561.28 29.8 TOTAL GENERAL GOVT - 52,586.45 411,268.65 420,607.00 9,338.35 97.8 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:14 GOVERNMENTAL ASSISTANCE: 10-5110-8702 COMM CLUB/GEN 5,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 12,500.00 30,000.00 17,500.00 41.7 10-5110-8707 COMM DVL 416.63 5,000.00 5,000.00 .00 100.0 10-5110-8709 COMM 1,666.66 19,999.92 20,000.00 .08 100.0 10-5110-8714 COMM ENTERPRIS 18,750.00 75,000.00 75,000.00 .00 100.0 10-5110-8723 COMM HOCKEY 24,000.00 24,000.00 24,000.00 .00 100.0 10-5110-8734 COMM PEAK 13,333.34 81,340.04 85,000.00 3,659.96 95.7 10-5110-8746 COMM & GIRLS .00 16,666.64 25,000.00 8,333.36 66.7 10-5110-8750 COMM ADVOC 2,000.00 4,000.00 4,000.00 .00 100.0 10-5110-8753 COMM SRVC BLK .00 6,199.44 10,000.00 3,800.56 62.0 10-5110-8757 COMM SERV-KINGS PORTION 3,272.64 20,000.00 20,000.00 .00 100.0 10-5110-8759 COMM SRVC CENTER 20,000.00 20,000.00 20,000.00 .00 100.0 TOTAL GOVERNMENTAL ASSISTANCE 88,439.27 374,706.04 408,000.00 33,293.96 91.8 TOTAL COMMUNITY SERVICE CONTRACTS 88,439.27 374,706.04 408,000.00 33,293.96 91.8 PUBLIC SERVICE CONTRACTS GOVERNMENTAL ASSISTANCE: 10-5111-8744 COMM 218,202.58 370,900.00 370,900.00 .00 100.0 10-5111-8760 COMM SRVC JUSTICE 63,529.36 838,691.67 905,500.00 66,808.33 92.6 TOTAL GOVERNMENTAL ASSISTANCE 281,731.94 1,209,591.67 1,276,400.00 66,808.33 94.8 TOTAL PUBLIC SERVICE CONTRACTS 281,731.94 1,209,591.67 1,276,400.00 66,808.33 94.8 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 12,290.94 161,899.36 161,908.00 8.64 100.0 10-5201-1002 SALARIES/WAGES - OVERTIME .00 701.02 100.00 ( 601.02) 701.0 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 160.26 160.00 ( .26) 100.2 10-5201-1006 SALARIES/WAGES - ALLOWANCES .00 825.00 900.00 75.00 91.7 10-5201-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 2,869.00 2,869.00 .0 TOTAL PERSONNEL SERVICES 12,290.94 163,585.64 165,937.00 2,351.36 98.6 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 943.23 12,551.84 12,553.00 1.16 100.0 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS ( 28,490.00) 35,521.12 40,889.00 5,367.88 86.9 10-5201-1025 EMPLOYEE BENEFITS - COMP 319.57 4,754.01 4,754.00 ( .01) 100.0 10-5201-1026 EMPLOYEE BENEFITS - COMP 38.52 491.76 493.00 1.24 99.8 10-5201-1029 EMPLOYEE BENEFITS - WY 2,105.00 26,821.31 26,564.00 ( 257.31) 101.0 TOTAL EMPLOYEE BENEFITS ( 25,083.68) 80,140.04 85,253.00 5,112.96 94.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:15 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 965.00 1,180.00 215.00 81.8 10-5201-2122 TRAINING/DEVELOPMENT .00 954.00 680.00 ( 274.00) 140.3 10-5201-2123 MEALS/LODGING/TRAVEL 504.17 1,093.83 1,195.00 101.17 91.5 TOTAL PURCHASED SERVICES 504.17 3,012.83 3,055.00 42.17 98.6 PROPERTY SERVICES: 10-5201-2131 UTILITY SERVICES - ELECTRICITY 230.48 1,530.06 2,000.00 469.94 76.5 10-5201-2134 TELECOMMUNICATIONS 40.01 480.12 494.00 13.88 97.2 TOTAL PROPERTY SERVICES 270.49 2,010.18 2,494.00 483.82 80.6 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 250.00 250.00 .0 10-5201-2156 MAINTENANCE AGREEMENT 97.02 1,036.57 1,200.00 163.43 86.4 10-5201-2158 MISC CONTRACTUAL SERVICES .00 3,290.00 5,500.00 2,210.00 59.8 10-5201-2161 INCARCERATION CONTRACT 225.00 2,010.00 2,000.00 ( 10.00) 100.5 TOTAL PROFESSIONAL SERVICES 322.02 6,336.57 8,950.00 2,613.43 70.8 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 1,579.38 2,615.73 3,300.00 684.27 79.3 10-5201-3233 UNIFORMS/CARE .00 .00 600.00 600.00 .0 10-5201-3235 FUEL 221.87 654.59 850.00 195.41 77.0 TOTAL SUPPLIES 1,801.25 3,270.32 4,750.00 1,479.68 68.9 TOTAL POLICE DEPT - ADMINISTRATION ( 9,894.81) 258,355.58 270,439.00 12,083.42 95.5 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 69,370.27 1,079,511.35 1,141,146.00 61,634.65 94.6 10-5202-1002 SALARIES/WAGES - OVERTIME 8,674.29 77,107.12 50,000.00 ( 27,107.12) 154.2 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 2,178.69 2,731.00 552.31 79.8 10-5202-1006 SALARIES/WAGES - ALLOWANCES .00 550.00 600.00 50.00 91.7 10-5202-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 29,943.00 29,943.00 .0 TOTAL PERSONNEL SERVICES 78,044.56 1,159,347.16 1,224,420.00 65,072.84 94.7 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 6,047.94 86,685.74 94,654.00 7,968.26 91.6 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS ( 5,004.98) 345,417.89 432,031.00 86,613.11 80.0 10-5202-1025 EMPLOYEE BENEFITS - COMP 2,029.15 30,094.64 31,598.00 1,503.36 95.2 10-5202-1026 EMPLOYEE BENEFITS - COMP 1,049.24 12,212.01 12,889.00 676.99 94.8 10-5202-1029 EMPLOYEE BENEFITS - WY 12,919.66 185,086.70 203,688.00 18,601.30 90.9 TOTAL EMPLOYEE BENEFITS 17,041.01 659,496.98 774,860.00 115,363.02 85.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:24AM PAGE:16 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 360.00 954.00 594.00 37.7 10-5202-2122 TRAINING/DEVELOPMENT 714.82 13,013.19 18,835.00 5,821.81 69.1 10-5202-2123 MEALS/LODGING/TRAVEL 6,863.41 23,586.20 15,815.00 ( 7,771.20) 149.1 TOTAL PURCHASED SERVICES 7,578.23 36,959.39 35,604.00 ( 1,355.39) 103.8 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,527.47 17,478.57 18,390.00 911.43 95.0 TOTAL PROPERTY SERVICES 1,527.47 17,478.57 18,390.00 911.43 95.0 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE .00 12,674.81 8,000.00 ( 4,674.81) 158.4 10-5202-2156 MAINTENANCE AGREEMENT 212.18 3,583.64 15,037.00 11,453.36 23.8 10-5202-2158 MISC CONTRACTUAL SERVICES .00 801.25 4,100.00 3,298.75 19.5 TOTAL PROFESSIONAL SERVICES 212.18 17,059.70 27,137.00 10,077.30 62.9 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 .00 300.00 300.00 .0 10-5202-3210 OPERATING SUPPLIES 5,115.96 34,570.39 34,000.00 ( 570.39) 101.7 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 19,834.41 8,656.00 ( 11,178.41) 229.1 10-5202-3233 UNIFORMS/CARE 24.00 18,089.02 19,673.00 1,583.98 92.0 10-5202-3235 FUEL 6,190.68 19,762.18 16,995.00 ( 2,767.18) 116.3 TOTAL SUPPLIES 11,330.64 92,256.00 79,624.00 ( 12,632.00) 115.9 TOTAL POLICE DEPT - PATROL 115,734.09 1,982,597.80 2,160,035.00 177,437.20 91.8 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 12,719.91 168,111.67 168,112.00 .33 100.0 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,353.83 1,354.00 .17 100.0 10-5301-1006 SALARIES/WAGES - ALLOWANCES .00 825.00 900.00 75.00 91.7 10-5301-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,781.19 5,107.00 3,325.81 34.9 TOTAL PERSONNEL SERVICES 12,719.91 172,071.69 175,473.00 3,401.31 98.1 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 976.74 13,201.97 13,201.00 ( .97) 100.0 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS .00 33,532.75 36,790.00 3,257.25 91.2 10-5301-1025 EMPLOYEE BENEFITS - COMP 330.72 4,473.91 4,355.00 ( 118.91) 102.7 10-5301-1029 EMPLOYEE BENEFITS - WY 2,187.83 27,827.11 27,789.00 ( 38.11) 100.1 TOTAL EMPLOYEE BENEFITS 3,495.29 79,035.74 82,135.00 3,099.26 96.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:17 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 232.00 576.00 344.00 40.3 10-5301-2122 TRAINING/DEVELOPMENT .00 350.00 550.00 200.00 63.6 10-5301-2123 MEALS/LODGING/TRAVEL .00 256.16 600.00 343.84 42.7 TOTAL PURCHASED SERVICES .00 838.16 1,726.00 887.84 48.6 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 889.46 8,248.87 10,700.00 2,451.13 77.1 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 829.06 4,810.34 5,000.00 189.66 96.2 10-5301-2133 UTILITY SERVICES - NATURAL GAS 269.50 14,546.47 14,910.00 363.53 97.6 10-5301-2134 TELECOMMUNICATIONS 73.06 842.78 843.00 .22 100.0 TOTAL PROPERTY SERVICES 2,061.08 28,448.46 31,453.00 3,004.54 90.5 PROFESSIONAL SERVICES: 10-5301-2153 ARCHITECT/ENGINEERING/SURVEING .00 1,000.00 1,000.00 .00 100.0 10-5301-2155 REPAIRS/MAINTENANCE ( 1,418.95) 1,550.40 1,500.00 ( 50.40) 103.4 10-5301-2156 MAINTENANCE AGREEMENT 146.40 2,886.61 2,750.00 ( 136.61) 105.0 TOTAL PROFESSIONAL SERVICES ( 1,272.55) 5,437.01 5,250.00 ( 187.01) 103.6 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 28.97 2,156.96 2,200.00 43.04 98.0 10-5301-3230 REFRESHMENT SUPPLIES 216.44 742.15 750.00 7.85 99.0 10-5301-3235 FUEL 199.26 615.92 1,000.00 384.08 61.6 TOTAL SUPPLIES 444.67 3,515.03 3,950.00 434.97 89.0 TOTAL PUBLIC WORKS - ADMINISTRATION 17,448.40 289,346.09 299,987.00 10,640.91 96.5 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 11,367.01 227,992.60 227,993.00 .40 100.0 10-5302-1002 SALARIES/WAGES - OVERTIME .00 540.71 500.00 ( 40.71) 108.1 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 1,374.96 1,375.00 .04 100.0 10-5302-1006 SALARIES/WAGES-ALLOWANCE .00 537.09 600.00 62.91 89.5 10-5302-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 7,454.00 7,454.00 .0 TOTAL PERSONNEL SERVICES 11,367.01 230,445.36 237,922.00 7,476.64 96.9 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 881.36 18,394.59 18,395.00 .41 100.0 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS .00 63,711.97 72,271.00 8,559.03 88.2 10-5302-1025 EMPLOYEE BENEFITS - COMP 295.56 5,991.74 5,992.00 .26 100.0 10-5302-1026 EMPLOYEE BENEFITS - COMP 94.16 9,653.57 9,653.00 ( .57) 100.0 10-5302-1029 EMPLOYEE BENEFITS - WY 1,955.14 33,029.72 36,360.00 3,330.28 90.8 TOTAL EMPLOYEE BENEFITS 3,226.22 130,781.59 142,671.00 11,889.41 91.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:18 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 4,145.00 4,200.00 55.00 98.7 10-5302-2122 TRAINING/DEVELOPMENT .00 570.00 300.00 ( 270.00) 190.0 TOTAL PURCHASED SERVICES .00 4,715.00 4,500.00 ( 215.00) 104.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 2,676.86 4,375.00 1,698.14 61.2 TOTAL PROFESSIONAL SERVICES .00 2,676.86 4,375.00 1,698.14 61.2 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 1,360.71 14,181.55 14,000.00 ( 181.55) 101.3 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 3,847.13 13,440.03 13,150.00 ( 290.03) 102.2 10-5302-3235 FUEL 739.57 1,651.25 2,000.00 348.75 82.6 10-5302-3237 OIL/LUBE/FLUIDS 2,702.83 12,922.38 12,500.00 ( 422.38) 103.4 TOTAL SUPPLIES 8,650.24 42,195.21 41,650.00 ( 545.21) 101.3 TOTAL PUBLIC WORKS - SHOP 23,243.47 410,814.02 431,318.00 20,503.98 95.3 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 17,770.29 240,693.49 228,978.00 ( 11,715.49) 105.1 10-5304-1002 SALARIES/WAGES - OVERTIME 293.60 563.89 2,000.00 1,436.11 28.2 10-5304-1004 SALARIES/WAGES - TEMPORARY 8,992.50 26,653.15 60,833.00 34,179.85 43.8 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 1,003.35 1,003.00 ( .35) 100.0 10-5304-1006 SALARIES/WAGES - ALLOWANCES .00 275.00 300.00 25.00 91.7 10-5304-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,781.19 8,479.00 6,697.81 21.0 TOTAL PERSONNEL SERVICES 27,056.39 270,970.07 301,593.00 30,622.93 89.9 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 2,083.22 20,820.71 23,102.00 2,281.29 90.1 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS .00 107,066.42 116,774.00 9,707.58 91.7 10-5304-1025 EMPLOYEE BENEFITS - COMP 703.47 7,045.14 7,773.00 727.86 90.6 10-5304-1026 EMPLOYEE BENEFITS - COMP 144.68 806.11 .00 ( 806.11) .0 10-5304-1029 EMPLOYEE BENEFITS - WY 3,106.97 39,398.70 39,728.00 329.30 99.2 TOTAL EMPLOYEE BENEFITS 6,038.34 175,137.08 187,377.00 12,239.92 93.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:19 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 40.50 608.50 750.00 141.50 81.1 10-5304-2122 TRAINING/DEVELOPMENT .00 975.00 1,900.00 925.00 51.3 10-5304-2123 MEALS/LODGING/TRAVEL .00 .00 1,500.00 1,500.00 .0 TOTAL PURCHASED SERVICES 40.50 1,583.50 4,150.00 2,566.50 38.2 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 3,985.20 21,481.91 18,000.00 ( 3,481.91) 119.3 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 15,174.40 88,673.50 95,000.00 6,326.50 93.3 10-5304-2133 NATURAL GAS, PROPANE 32.25 338.52 .00 ( 338.52) .0 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 19,191.85 110,493.93 114,000.00 3,506.07 96.9 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE 858.60 1,308.74 5,000.00 3,691.26 26.2 10-5304-2156 MAINTENANCE AGREEMENT .00 1,175.00 7,340.00 6,165.00 16.0 10-5304-2158 MISC CONTRACTUAL SERVICES .00 26,350.00 35,000.00 8,650.00 75.3 TOTAL PROFESSIONAL SERVICES 858.60 28,833.74 47,340.00 18,506.26 60.9 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 3,077.18 40,580.60 45,000.00 4,419.40 90.2 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 3,431.43 3,500.00 68.57 98.0 10-5304-3235 FUEL 3,028.38 6,737.81 10,000.00 3,262.19 67.4 TOTAL SUPPLIES 6,105.56 50,749.84 58,500.00 7,750.16 86.8 TOTAL PUBLIC WORKS - PARKS 59,291.24 637,768.16 712,960.00 75,191.84 89.5 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 21,572.08 304,015.74 284,933.00 ( 19,082.74) 106.7 10-5305-1002 SALARIES/WAGES - OVERTIME 314.02 4,657.95 4,000.00 ( 657.95) 116.5 10-5305-1004 SALARIES/WAGES - TEMPORARY 3,660.00 4,260.00 12,167.00 7,907.00 35.0 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 1,650.23 1,650.00 ( .23) 100.0 10-5305-1006 SALARIES/WAGES - ALLOWANCES .00 228.23 300.00 71.77 76.1 10-5305-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 3,252.57 10,329.00 7,076.43 31.5 TOTAL PERSONNEL SERVICES 25,546.10 318,064.72 313,379.00 ( 4,685.72) 101.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:20 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,956.58 24,412.54 24,064.00 ( 348.54) 101.5 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS ( 2,475.00) 91,762.92 101,235.00 9,472.08 90.6 10-5305-1025 EMPLOYEE BENEFITS - COMP 664.21 8,269.94 7,757.00 ( 512.94) 106.6 10-5305-1026 EMPLOYEE BENEFITS - COMP .00 699.37 790.00 90.63 88.5 10-5305-1029 EMPLOYEE BENEFITS - WY 3,764.41 48,882.67 49,696.00 813.33 98.4 TOTAL EMPLOYEE BENEFITS 3,910.20 174,027.44 183,542.00 9,514.56 94.8 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT .00 .00 790.00 790.00 .0 TOTAL PURCHASED SERVICES .00 .00 790.00 790.00 .0 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 12,255.60 42,858.48 60,000.00 17,141.52 71.4 10-5305-2158 MISC CONTRACTUAL SERVICES ( 14,137.00) 38,676.25 59,700.00 21,023.75 64.8 TOTAL PROFESSIONAL SERVICES ( 1,881.40) 81,534.73 119,700.00 38,165.27 68.1 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 8,315.69 93,531.54 71,900.00 ( 21,631.54) 130.1 10-5305-3235 FUEL 6,363.95 19,998.04 25,000.00 5,001.96 80.0 TOTAL SUPPLIES 14,679.64 113,529.58 96,900.00 ( 16,629.58) 117.2 TOTAL PUBLIC WORKS - STREETS/ALLEYS 42,254.54 687,156.47 714,311.00 27,154.53 96.2 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 11,084.15 150,493.57 142,822.00 ( 7,671.57) 105.4 10-5306-1002 SALARIES/WAGES - OVERTIME 110.10 1,660.70 1,500.00 ( 160.70) 110.7 10-5306-1004 SALARIES/WAGES - TEMPORARY 4,050.00 4,050.00 12,167.00 8,117.00 33.3 10-5306-1005 SALARIES/WAGES - LONGEVITY .00 1,160.92 1,161.00 .08 100.0 10-5306-1006 SALARIES/WAGES - ALLOWANCES .00 275.00 300.00 25.00 91.7 10-5306-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,963.76 8,627.00 6,663.24 22.8 TOTAL PERSONNEL SERVICES 15,244.25 159,603.95 166,577.00 6,973.05 95.8 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 1,189.18 12,399.43 11,920.00 ( 479.43) 104.0 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS .00 59,542.50 64,942.00 5,399.50 91.7 10-5306-1025 EMPLOYEE BENEFITS - COMP 396.35 4,149.66 4,211.00 61.34 98.5 10-5306-1026 EMPLOYEE BENEFITS - COMP 285.11 2,421.02 1,018.00 ( 1,403.02) 237.8 10-5306-1029 EMPLOYEE BENEFITS - WY 1,925.40 24,901.39 24,823.00 ( 78.39) 100.3 TOTAL EMPLOYEE BENEFITS 3,796.04 103,414.00 106,914.00 3,500.00 96.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:21 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 340.20 3,300.43 3,500.00 199.57 94.3 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 8,030.37 50,446.98 60,000.00 9,553.02 84.1 10-5306-2133 UTILITY SERVICES - NATURAL GAS 59.32 2,178.55 1,500.00 ( 678.55) 145.2 10-5306-2134 TELECOMMUNICATIONS 59.65 734.19 1,000.00 265.81 73.4 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 8,489.54 56,660.15 66,200.00 9,539.85 85.6 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE .00 60.00 1,500.00 1,440.00 4.0 10-5306-2156 MAINTENANCE AGREEMENT .00 905.00 1,000.00 95.00 90.5 10-5306-2158 MISC CONTRACTUAL SERVICES .00 7,000.00 8,500.00 1,500.00 82.4 TOTAL PROFESSIONAL SERVICES .00 7,965.00 11,000.00 3,035.00 72.4 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 387.85 8,937.48 11,500.00 2,562.52 77.7 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 507.98 657.97 1,000.00 342.03 65.8 10-5306-3235 FUEL 1,030.50 2,170.40 2,500.00 329.60 86.8 TOTAL SUPPLIES 1,926.33 11,765.85 15,000.00 3,234.15 78.4 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND .00 .00 1,000.00 1,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 1,000.00 1,000.00 .0 TOTAL PUBLIC WORKS - CEMETERY 29,456.16 339,858.95 367,191.00 27,332.05 92.6 PUBLIC WORKS - SWIM POOL PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 970.46 6,269.46 7,000.00 730.54 89.6 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 2,557.19 5,717.81 13,000.00 7,282.19 44.0 10-5307-2133 UTILITY SERVICES - NATURAL GAS 1,155.89 5,158.96 6,000.00 841.04 86.0 10-5307-2134 TELECOMMUNICATIONS .00 458.89 1,500.00 1,041.11 30.6 TOTAL PROPERTY SERVICES 4,683.54 17,605.12 27,500.00 9,894.88 64.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:22 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE .00 1,064.00 5,000.00 3,936.00 21.3 10-5307-2158 MISC CONTRACTUAL SERVICES .00 101,902.27 128,500.00 26,597.73 79.3 TOTAL PROFESSIONAL SERVICES .00 102,966.27 133,500.00 30,533.73 77.1 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 2,358.04 13,439.50 10,000.00 ( 3,439.50) 134.4 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 2,500.00 2,500.00 .0 TOTAL SUPPLIES 2,358.04 13,439.50 12,500.00 ( 939.50) 107.5 TOTAL PUBLIC WORKS - SWIM POOL 7,041.58 134,010.89 173,500.00 39,489.11 77.2 OPERATING TRANSFERS - OUT OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE 75,000.00 300,000.00 300,000.00 .00 100.0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ 6,685.50 26,742.00 26,742.00 .00 100.0 10-5998-4339 TRANSFER TO HEALTH INS RESERVE 25,000.00 100,000.00 100,000.00 .00 100.0 10-5998-4341 TRANSFER TO ECONOMIC DEVELOPME 12,500.00 50,000.00 50,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-4353 TRANSFER TO CLG GRANT 752.50 3,010.00 3,010.00 .00 100.0 10-5998-4354 TRANSFER TO TRAIN CAR RESTORAT 8,750.00 35,000.00 35,000.00 .00 100.0 10-5998-4355 TRANSFER TO POOL IMPROVEMENT 48,750.00 195,000.00 195,000.00 .00 100.0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT 750,000.00 3,000,000.00 3,000,000.00 .00 100.0 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS 215,000.00 860,000.00 860,000.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 912.50 3,650.00 3,650.00 .00 100.0 TOTAL OPERATING TRANSFERS 1,205,850.50 4,823,402.00 4,823,402.00 .00 100.0 TOTAL OPERATING TRANSFERS - OUT 1,205,850.50 4,823,402.00 4,823,402.00 .00 100.0 TOTAL FUND EXPENDITURES 2,118,150.52 13,696,376.43 14,562,281.00 865,904.57 94.1 NET REVENUE OVER EXPENDITURES ( 185,125.97) 7,380,231.73 ( 2,280,614.00) ( 9,660,845.73) 323.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:23 ASSETS CURRENT ASSETS: CASH: 11-10000116 CASH ALLOC FR COMBINED FUND 566,636.38 TOTAL CASH 566,636.38 INVESTMENTS: 11-10000122 TIME DEPOSITS - SHORT TERM 1,028,285.25 TOTAL INVESTMENTS 1,028,285.25 TOTAL CURRENT ASSETS 1,594,921.63 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,594,921.63 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 11-30000300 FUND BALANCE/BEGINNING OF YEAR ( 1,045,456.32) 11-30000301 RESERVE FOR 4TH STREET PROJECT 2,622,126.12 TOTAL CAPITAL ASSETS 1,576,669.80 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 18,251.83 BALANCE - CURRENT DATE 1,594,921.63 TOTAL NET ASSETS 1,594,921.63 TOTAL LIABILITIES AND NET ASSETS 1,594,921.63 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 IMPACT ASSISTANCE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:25AM PAGE:24 IMPACT ASSISTANCE - REVENUE MISC LOCAL REVENUE: 11-4110-1140 INTEREST INCOME 7,717.17 18,251.83 5,000.00 ( 13,251.83) 365.0 TOTAL MISC LOCAL REVENUE 7,717.17 18,251.83 5,000.00 ( 13,251.83) 365.0 TOTAL IMPACT ASSISTANCE - REVENUE 7,717.17 18,251.83 5,000.00 ( 13,251.83) 365.0 TOTAL FUND REVENUE 7,717.17 18,251.83 5,000.00 ( 13,251.83) 365.0 NET REVENUE OVER EXPENDITURES 7,717.17 18,251.83 5,000.00 ( 13,251.83) 365.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:32AM PAGE:25 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 23,267.58 TOTAL CASH 23,267.58 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 16,738.97 13-10000156 DUE FROM OTHER FUNDS 37.71 TOTAL ACCOUNTS RECEIVABLE 16,776.68 TOTAL CURRENT ASSETS 40,044.26 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 40,044.26 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 400.00 TOTAL ACCOUNTS PAYABLE 400.00 TOTAL CURRENT LIABILITIES 400.00 TOTAL LIABILITIES 400.00 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 26,024.10 TOTAL CAPITAL ASSETS 26,024.10 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:32AM PAGE:26 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 13,620.16 BALANCE - CURRENT DATE 39,644.26 TOTAL NET ASSETS 39,644.26 TOTAL LIABILITIES AND NET ASSETS 40,044.26 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:32AM PAGE:27 K9 PROGRAM CONTRIBUTIONS: 13-4804-1560 DONATIONS .00 .00 20,000.00 20,000.00 .0 TOTAL CONTRIBUTIONS .00 .00 20,000.00 20,000.00 .0 TOTAL K9 PROGRAM .00 .00 20,000.00 20,000.00 .0 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT .00 2,275.03 7,767.00 5,491.97 29.3 TOTAL FEDERAL REVENUE SOURCES .00 2,275.03 7,767.00 5,491.97 29.3 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN .00 2,275.03 7,767.00 5,491.97 29.3 SRO PROGRAM - REVENUE MISC LOCAL REVENUE: 13-4830-1001 REIMBURSEMENT-CCSD#1-SRO 26,661.42 26,661.42 25,317.00 ( 1,344.42) 105.3 TOTAL MISC LOCAL REVENUE 26,661.42 26,661.42 25,317.00 ( 1,344.42) 105.3 FEDERAL REVENUE SOURCES: 13-4830-4283 FED BUREAU JUSTICE ADMIN - SRO 8,334.08 38,308.14 50,635.00 12,326.86 75.7 TOTAL FEDERAL REVENUE SOURCES 8,334.08 38,308.14 50,635.00 12,326.86 75.7 TRANSFERS IN: 13-4830-5510 TRANSFER FROM GENERAL FUND 25,099.50 25,099.50 25,317.00 217.50 99.1 TOTAL TRANSFERS IN 25,099.50 25,099.50 25,317.00 217.50 99.1 TOTAL SRO PROGRAM - REVENUE 60,095.00 90,069.06 101,269.00 11,199.94 88.9 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 3,077.98 11,877.33 8,606.00 ( 3,271.33) 138.0 TOTAL STATE REVENUE 3,077.98 11,877.33 8,606.00 ( 3,271.33) 138.0 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:33AM PAGE:28 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE 3,077.98 11,877.33 8,606.00 ( 3,271.33) 138.0 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 1,612.50 1,882.00 269.50 85.7 TOTAL FEDERAL REVENUE SOURCES .00 1,612.50 1,882.00 269.50 85.7 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND ( 18,414.00) 1,642.50 1,882.00 239.50 87.3 TOTAL TRANSFERS IN ( 18,414.00) 1,642.50 1,882.00 239.50 87.3 TOTAL BULLET PROOF VEST - REVENUE ( 18,414.00) 3,255.00 3,764.00 509.00 86.5 TOTAL FUND REVENUE 44,758.98 107,476.42 141,406.00 33,929.58 76.0 ASSET SEIZURE SUPPLIES: 13-5130-3210 OPERATING SUPPLIES .00 405.00 1,255.00 850.00 32.3 TOTAL SUPPLIES .00 405.00 1,255.00 850.00 32.3 TOTAL ASSET SEIZURE .00 405.00 1,255.00 850.00 32.3 K9 PROGRAM CAPITALIZED EXPENDITURES: 13-5804-6547 EQUIPMENT/FURNITURE .00 .00 20,000.00 20,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 20,000.00 20,000.00 .0 TOTAL K9 PROGRAM .00 .00 20,000.00 20,000.00 .0 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR .00 1,791.14 6,095.00 4,303.86 29.4 TOTAL PERSONNEL SERVICES .00 1,791.14 6,095.00 4,303.86 29.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:33AM PAGE:29 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL .00 227.22 466.00 238.78 48.8 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS .00 690.22 .00 ( 690.22) .0 13-5821-1025 EMPLOYEE BENEFITS - COMP .00 77.36 158.00 80.64 49.0 13-5821-1029 EMPLOYEE BENEFITS - WY .00 511.66 1,048.00 536.34 48.8 TOTAL EMPLOYEE BENEFITS .00 1,506.46 1,672.00 165.54 90.1 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE .00 3,297.60 7,767.00 4,469.40 42.5 SCHOOL RESOURCE OFFICER PERSONNEL SERVICES: 13-5830-1001 SALARIES/WAGES - REGULAR 14,005.90 46,998.58 56,067.00 9,068.42 83.8 13-5830-1002 SALARIES/WAGES - OVERTIME 143.15 769.42 2,500.00 1,730.58 30.8 13-5830-1005 SALARIES/WAGES - LONGEVITY .00 106.89 .00 ( 106.89) .0 13-5830-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 1,201.00 1,201.00 .0 TOTAL PERSONNEL SERVICES 14,149.05 47,874.89 59,768.00 11,893.11 80.1 EMPLOYEE BENEFITS: 13-5830-1021 EMPLOYEE BENEFITS - SCL 1,082.42 3,662.43 4,572.00 909.57 80.1 13-5830-1023 EMPLOYEE BENEFITS - HEALTH INS 4,179.98 21,187.70 25,731.00 4,543.30 82.3 13-5830-1025 EMPLOYEE BENEFITS - COMP 367.88 1,244.79 1,554.00 309.21 80.1 13-5830-1029 EMPLOYEE BENEFITS - WY 2,433.63 7,958.07 9,644.00 1,685.93 82.5 TOTAL EMPLOYEE BENEFITS 8,063.91 34,052.99 41,501.00 7,448.01 82.1 TOTAL SCHOOL RESOURCE OFFICER 22,212.96 81,927.88 101,269.00 19,341.12 80.9 OJJDP-UNDERAGE ENFORCEMENT PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 106.71 1,880.08 6,750.00 4,869.92 27.9 TOTAL PERSONNEL SERVICES 106.71 1,880.08 6,750.00 4,869.92 27.9 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 8.15 143.61 518.00 374.39 27.7 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS .00 647.34 .00 ( 647.34) .0 13-5831-1025 EMPLOYEE BENEFITS - COMP 2.77 48.88 175.00 126.12 27.9 13-5831-1029 EMPLOYEE BENEFITS - WY 18.35 323.37 1,163.00 839.63 27.8 TOTAL EMPLOYEE BENEFITS 29.27 1,163.20 1,856.00 692.80 62.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:34AM PAGE:30 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES .00 410.00 .00 ( 410.00) .0 TOTAL PROFESSIONAL SERVICES .00 410.00 .00 ( 410.00) .0 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 400.00 1,010.00 .00 ( 1,010.00) .0 TOTAL SUPPLIES 400.00 1,010.00 .00 ( 1,010.00) .0 TOTAL OJJDP-UNDERAGE ENFORCEMENT 535.98 4,463.28 8,606.00 4,142.72 51.9 BULLET PROOF VEST PROTECTION SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 3,762.50 3,764.00 1.50 100.0 TOTAL SUPPLIES .00 3,762.50 3,764.00 1.50 100.0 TOTAL BULLET PROOF VEST PROTECTION .00 3,762.50 3,764.00 1.50 100.0 TOTAL FUND EXPENDITURES 22,748.94 93,856.26 142,661.00 48,804.74 65.8 NET REVENUE OVER EXPENDITURES 22,010.04 13,620.16 ( 1,255.00) ( 14,875.16) 1085.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:44AM PAGE:31 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 4,773,028.09 31-10000118 MONEY MARKET ACCOUNT 122,711.49 TOTAL CASH 4,895,739.58 INVESTMENTS: 31-10000120 INVESTMENT POOL 4,094,117.07 31-10000122 TIME DEPOSITS - SHORT TERM 3,435,553.19 TOTAL INVESTMENTS 7,529,670.26 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 4,112.23 31-10000132 ACCOUNTS RECEIVABLE - EOY 138,853.71 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 279,070.09 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 8,414.52) 31-10000139 ACCRUED INTEREST RECEIVABLE 5,690.81 31-10000140 DUE FROM OTHER FUNDS 9,211.29 31-10000156 DUE FROM OTHER FUNDS 60,750.70 TOTAL ACCOUNTS RECEIVABLE 489,274.31 TOTAL CURRENT ASSETS 12,914,684.15 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,000,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 1,610,008.63 31-10006100 DEFERRED OUTFLOW OF RESOURCES 41,937.70 TOTAL OTHER ASSETS 651,946.33 TOTAL NON-CURRENT ASSETS 23,790,639.84 TOTAL ASSETS 36,705,323.99 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:44AM PAGE:32 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 108,639.42 31-20000204 ACCOUNTS PAYABLE - EOY ( 507.40) 31-20000210 RETAINAGE PAYABLE ( 10,153.02) 31-20000215 WAGES PAYABLE 18,619.13 TOTAL ACCOUNTS PAYABLE 116,598.13 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 429,392.01 NON-CURRENT LIABILITIES: 31-20000265 COMPENSATED ABSENCES PAYABLE 58,546.13 TOTAL NON-CURRENT LIABILITIES 58,546.13 TOTAL LIABILITIES 487,938.14 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 5,712,088.21 31-30000305 RESERVE FOR REPLACEMENT 4,857,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 759,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 135,000.00 TOTAL CAPITAL ASSETS 12,039,328.90 RESTRICTED ASSETS: 31-30000310 RESERVE FOR EQUIPMENT 60,000.00 TOTAL RESTRICTED ASSETS 60,000.00 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 ( 630,645.21) BALANCE - CURRENT DATE 36,217,385.85 TOTAL NET ASSETS 36,217,385.85 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:44AM PAGE:33 TOTAL LIABILITIES AND NET ASSETS 36,705,323.99 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:44AM PAGE:34 WATER - REVENUE REVENUE: 31-4310-0160 GAIN ON INVESTMENTS ( 12,836.40) ( 55,015.03) .00 55,015.03 .0 TOTAL REVENUE ( 12,836.40) ( 55,015.03) .00 55,015.03 .0 MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 1,373.13 1,500.00 126.87 91.5 31-4310-1140 INTEREST INCOME 17,255.64 209,727.81 105,000.00 ( 104,727.81) 199.7 TOTAL MISC LOCAL REVENUE 17,255.64 211,100.94 106,500.00 ( 104,600.94) 198.2 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 236,855.34 2,626,137.61 2,800,000.00 173,862.39 93.8 31-4310-1705 UTILITY SERVICE FEES 280.00 19,847.50 15,000.00 ( 4,847.50) 132.3 31-4310-1706 WATER PLANT INVESTMENT FEES 1,100.00 31,850.00 2,750.00 ( 29,100.00) 1158.2 31-4310-1707 UTILITY LATE FEES 1,325.00 15,205.00 15,000.00 ( 205.00) 101.4 31-4310-1710 BULK WATER 5,186.04 70,352.07 50,000.00 ( 20,352.07) 140.7 TOTAL UTILITIES REVENUE 244,746.38 2,763,392.18 2,882,750.00 119,357.82 95.9 TOTAL WATER - REVENUE 249,165.62 2,919,478.09 2,989,250.00 69,771.91 97.7 TOTAL FUND REVENUE 249,165.62 2,919,478.09 2,989,250.00 69,771.91 97.7 WATER - ADMINISTRATION DEPRECIATION: 31-5400-1150 DEPRECIATION 250,000.00 1,000,000.00 1,000,000.00 .00 100.0 TOTAL DEPRECIATION 250,000.00 1,000,000.00 1,000,000.00 .00 100.0 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 1,015.64 12,054.43 10,000.00 ( 2,054.43) 120.5 31-5400-2166 COLLECTION FEES 136.99 622.84 250.00 ( 372.84) 249.1 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 227.11 500.00 272.89 45.4 TOTAL PROFESSIONAL SERVICES 1,152.63 12,904.38 10,750.00 ( 2,154.38) 120.0 OPERATING TRANSFERS: 31-5400-4347 MANAGEMENT FEES 68,157.25 272,629.00 272,629.00 .00 100.0 TOTAL OPERATING TRANSFERS 68,157.25 272,629.00 272,629.00 .00 100.0 TOTAL WATER - ADMINISTRATION 319,309.88 1,285,533.38 1,283,379.00 ( 2,154.38) 100.2 WATER - TREATMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:35 CASH FUND APPROPRIATION: 31-5401-0150 REPLACEMENT RESERVE-SAND FILTE 18,750.00 75,000.00 75,000.00 .00 100.0 31-5401-0153 REPLACEMENT RESERVE-SMW REHA 3,750.00 15,000.00 15,000.00 .00 100.0 TOTAL CASH FUND APPROP 22,500.00 90,000.00 90,000.00 .00 100.0 PERSONNEL SERVICES: 31-5401-1001 SALARIES/WAGES - REGULAR 7,948.32 107,805.23 103,328.00 ( 4,477.23) 104.3 31-5401-1002 SALARIES/WAGES - OVERTIME 44.61 4,271.39 6,000.00 1,728.61 71.2 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 642.76 643.00 .24 100.0 31-5401-1006 SALARIES/WAGES - ALLOWANCES .00 275.00 300.00 25.00 91.7 31-5401-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 5,739.00 5,739.00 .0 TOTAL PERSONNEL SERVICES 7,992.93 112,994.38 116,010.00 3,015.62 97.4 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 635.05 8,876.08 9,063.00 186.92 97.9 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS .00 35,755.36 39,041.00 3,285.64 91.6 31-5401-1025 EMPLOYEE BENEFITS - COMP 207.82 2,937.92 2,932.00 ( 5.92) 100.2 31-5401-1026 EMPLOYEE BENEFITS - COMP 278.20 2,641.26 2,067.00 ( 574.26) 127.8 31-5401-1029 EMPLOYEE BENEFITS - WY 1,374.79 18,525.11 18,804.00 278.89 98.5 TOTAL EMPLOYEE BENEFITS 2,495.86 68,735.73 71,907.00 3,171.27 95.6 PURCHASED SERVICES: 31-5401-2122 TRAINING/DEVELOPMENT .00 1,208.00 2,570.00 1,362.00 47.0 TOTAL PURCHASED SERVICES .00 1,208.00 2,570.00 1,362.00 47.0 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 8,352.07 49,701.38 55,000.00 5,298.62 90.4 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 865.38 8,761.04 7,500.00 ( 1,261.04) 116.8 31-5401-2133 UTILITY SERVICES - NATURAL GAS 142.30 7,869.09 6,000.00 ( 1,869.09) 131.2 31-5401-2134 TELECOMMUNICATIONS 15.66 126.53 200.00 73.47 63.3 31-5401-2140 RENT - LAND/BUILDINGS .00 10,196.76 12,000.00 1,803.24 85.0 TOTAL PROPERTY SERVICES 9,375.41 76,654.80 80,700.00 4,045.20 95.0 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 1,986.50 2,000.00 13.50 99.3 31-5401-2155 REPAIRS/MAINTENANCE .00 23,921.22 23,000.00 ( 921.22) 104.0 31-5401-2156 MAINTENANCE AGREEMENT .00 9,164.00 9,000.00 ( 164.00) 101.8 31-5401-2158 MISC CONTRACTUAL SERVICES 9,997.01 22,226.01 39,000.00 16,773.99 57.0 TOTAL PROFESSIONAL SERVICES 9,997.01 57,297.73 73,000.00 15,702.27 78.5 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 3,254.37 30,889.16 25,000.00 ( 5,889.16) 123.6 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 22,181.91 23,800.00 1,618.09 93.2 31-5401-3235 FUEL 270.85 827.05 2,000.00 1,172.95 41.4 TOTAL SUPPLIES 3,525.22 53,898.12 50,800.00 ( 3,098.12) 106.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:36 CAPITALIZED EXPENDITURES: 31-5401-6542 TO BLDG 17,728.75 17,728.75 22,000.00 4,271.25 80.6 31-5401-6544 OTHER THAN BLDG .00 64,795.00 83,000.00 18,205.00 78.1 31-5401-6547 EQUIPMENT/FURNITURE .00 58,230.00 48,000.00 ( 10,230.00) 121.3 31-5401-6548 VEHICLES .00 .00 20,000.00 20,000.00 .0 TOTAL CAPITALIZED EXPENDITURES 17,728.75 140,753.75 173,000.00 32,246.25 81.4 TOTAL WATER - TREATMENT 73,615.18 601,542.51 657,987.00 56,444.49 91.4 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 14,570.77 196,941.19 185,051.00 ( 11,890.19) 106.4 31-5402-1002 SALARIES/WAGES - OVERTIME .00 5,347.05 7,500.00 2,152.95 71.3 31-5402-1004 SALARIES/WAGES - TEMPORARY 896.25 896.25 3,042.00 2,145.75 29.5 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 727.47 727.00 ( .47) 100.1 31-5402-1006 SALARIES & WAGES - ALLOWANCES .00 275.00 300.00 25.00 91.7 31-5402-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 4,252.00 4,252.00 .0 TOTAL PERSONNEL SERVICES 15,467.02 204,186.96 200,872.00 ( 3,314.96) 101.7 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,185.52 15,649.84 15,397.00 ( 252.84) 101.6 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS .00 83,306.18 75,074.00 ( 8,232.18) 111.0 31-5402-1025 EMPLOYEE BENEFITS - COMP 402.12 5,308.74 5,233.00 ( 75.74) 101.5 31-5402-1029 EMPLOYEE BENEFITS - WY 2,506.18 33,159.28 33,119.00 ( 40.28) 100.1 TOTAL EMPLOYEE BENEFITS 4,093.82 137,424.04 128,823.00 ( 8,601.04) 106.7 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 273.38 2,993.25 1,700.00 ( 1,293.25) 176.1 31-5402-2122 TRAINING/DEVELOPMENT .00 394.00 2,450.00 2,056.00 16.1 TOTAL PURCHASED SERVICES 273.38 3,387.25 4,150.00 762.75 81.6 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 2,891.97 17,546.14 13,500.00 ( 4,046.14) 130.0 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 3,050.55 24,109.55 30,000.00 5,890.45 80.4 31-5402-2133 UTILITY SERVICES - NATURAL GAS 65.02 2,113.74 1,300.00 ( 813.74) 162.6 31-5402-2134 TELECOMMUNICATIONS 32.87 198.28 350.00 151.72 56.7 31-5402-2141 EQUIPMENT - RENT .00 200.00 400.00 200.00 50.0 TOTAL PROPERTY SERVICES 6,040.41 44,167.71 45,550.00 1,382.29 97.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:37 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 2,448.75 2,000.00 ( 448.75) 122.4 31-5402-2155 REPAIRS/MAINTENANCE .00 16,112.59 30,000.00 13,887.41 53.7 31-5402-2156 MAINTENANCE AGREEMENT .00 .00 1,095.00 1,095.00 .0 31-5402-2158 MISC CONTRACTUAL SERVICES .00 12,000.00 13,000.00 1,000.00 92.3 TOTAL PROFESSIONAL SERVICES .00 30,561.34 46,095.00 15,533.66 66.3 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 2,656.88 51,384.38 40,000.00 ( 11,384.38) 128.5 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 7,827.85 9,500.00 1,672.15 82.4 31-5402-3235 FUEL 1,658.21 5,855.26 7,000.00 1,144.74 83.7 TOTAL SUPPLIES 4,315.09 65,067.49 56,500.00 ( 8,567.49) 115.2 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 658.01 350.00 ( 308.01) 188.0 TOTAL FINANCIAL .00 658.01 350.00 ( 308.01) 188.0 CAPITALIZED EXPENDITURES: 31-5402-6544 OTHER THAN BLDG .00 .00 200,000.00 200,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 200,000.00 200,000.00 .0 TOTAL WATER - DISTRIBUTION/MAINTNCE 37,689.72 515,452.80 712,340.00 196,887.20 72.4 WATER - CUSTOMER SERVICES PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 3,914.71 53,923.24 50,891.00 ( 3,032.24) 106.0 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 545.25 545.00 ( .25) 100.1 31-5403-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,781.19 3,313.00 1,531.81 53.8 TOTAL PERSONNEL SERVICES 3,914.71 56,249.68 54,749.00 ( 1,500.68) 102.7 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 293.13 4,157.11 4,188.00 30.89 99.3 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS .00 252.37 219.00 ( 33.37) 115.2 31-5403-1025 EMPLOYEE BENEFITS - COMP 101.78 1,462.46 1,377.00 ( 85.46) 106.2 31-5403-1029 EMPLOYEE BENEFITS - WY 673.33 8,753.30 8,753.00 ( .30) 100.0 TOTAL EMPLOYEE BENEFITS 1,068.24 14,625.24 14,537.00 ( 88.24) 100.6 PROPERTY SERVICES: 31-5403-2134 TELECOMMUNICATIONS 17.05 91.10 220.00 128.90 41.4 TOTAL PROPERTY SERVICES 17.05 91.10 220.00 128.90 41.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:38 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 31-5403-2156 MAINTENANCE AGREEMENT .00 .00 2,500.00 2,500.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 4,000.00 4,000.00 .0 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES 15.48 1,715.83 2,000.00 284.17 85.8 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 32,549.17 32,600.00 50.83 99.8 31-5403-3235 FUEL 208.51 705.41 2,000.00 1,294.59 35.3 TOTAL SUPPLIES 223.99 34,970.41 36,600.00 1,629.59 95.6 TOTAL WATER - CUSTOMER SERVICES 5,223.99 105,936.43 110,106.00 4,169.57 96.2 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 50,075.85 175,238.58 296,250.00 121,011.42 59.2 TOTAL PROFESSIONAL SERVICES 50,075.85 175,238.58 296,250.00 121,011.42 59.2 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG .00 501,953.44 1,993,000.00 1,491,046.56 25.2 TOTAL CAPITALIZED EXPENDITURES .00 501,953.44 1,993,000.00 1,491,046.56 25.2 TOTAL WATER MAIN REPLACEMENTS 50,075.85 677,192.02 2,289,250.00 1,612,057.98 29.6 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 6,347.75 182,756.16 674,000.00 491,243.84 27.1 31-5856-2158 MISC CONTRACTUAL .00 .00 25,000.00 25,000.00 .0 TOTAL PROFESSIONAL SERVICES 6,347.75 182,756.16 699,000.00 516,243.84 26.2 CAPITALIZED EXPENDITURES: 31-5856-6544 OTHER THAN BLDG .00 181,710.00 75,000.00 ( 106,710.00) 242.3 TOTAL CAPITALIZED EXPENDITURES .00 181,710.00 75,000.00 ( 106,710.00) 242.3 TOTAL WATER IMPROVEMENTS 6,347.75 364,466.16 774,000.00 409,533.84 47.1 TOTAL FUND EXPENDITURES 492,262.37 3,550,123.30 5,827,062.00 2,276,938.70 60.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:39 NET REVENUE OVER EXPENDITURES ( 243,096.75) ( 630,645.21) ( 2,837,812.00) ( 2,207,166.79) ( 22.2) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:40 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 19,954.07 32-10000118 MONEY MARKET ACCOUNT 122,711.47 TOTAL CASH 142,665.54 INVESTMENTS: 32-10000120 INVESTMENT POOL 1,156,623.31 32-10000122 TIME DEPOSITS - SHORT TERM 1,832,206.90 TOTAL INVESTMENTS 2,988,830.21 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 11,312.50 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 18,476.73) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 149,940.96 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 6,403.02) 32-10000139 ACCRUED INTEREST RECEIVABLE 970.81 32-10000140 DUE FROM OTHER FUNDS 1,740.00 32-10000156 DUE FROM OTHER FUNDS 29,373.82 TOTAL ACCOUNTS RECEIVABLE 168,458.34 TOTAL CURRENT ASSETS 3,299,954.09 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,548,325.97 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:41 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 46,667.11 32-20000204 ACCOUNTS PAYABLE - EOY ( 6,369.45) 32-20000210 RETAINAGE PAYABLE ( 1,349.58) 32-20000215 WAGES PAYABLE 15,478.87 TOTAL ACCOUNTS PAYABLE 54,426.95 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 239,883.37 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 46,239.76 TOTAL NON-CURRENT LIABILITIES 46,239.76 TOTAL LIABILITIES 286,123.13 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS ( 1,686,771.39) 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 3,055,023.92 RESTRICTED ASSETS: 32-30000310 RESERVE FOR EQUIPMENT 60,000.00 TOTAL RESTRICTED ASSETS 60,000.00 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 ( 408,769.13) BALANCE - CURRENT DATE 14,262,202.84 TOTAL NET ASSETS 14,262,202.84 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:42 TOTAL LIABILITIES AND NET ASSETS 14,548,325.97 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:45AM PAGE:43 SEWER - REVENUE REVENUE: 32-4320-0160 GAIN ON INVESTMENTS ( 5,501.31) ( 23,577.87) .00 23,577.87 .0 TOTAL REVENUE ( 5,501.31) ( 23,577.87) .00 23,577.87 .0 MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 1,732.63 1,000.00 ( 732.63) 173.3 32-4320-1140 INTEREST INCOME 9,626.44 82,535.34 39,000.00 ( 43,535.34) 211.6 TOTAL MISC LOCAL REVENUE 9,626.44 84,267.97 40,000.00 ( 44,267.97) 210.7 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 118,488.54 1,324,304.64 1,375,000.00 50,695.36 96.3 32-4320-1706 SEWER PLANT INVESTMENT FEES 3,200.00 14,420.00 1,100.00 ( 13,320.00) 1310.9 TOTAL UTILITIES REVENUE 121,688.54 1,338,724.64 1,376,100.00 37,375.36 97.3 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 11,775.00 158,625.00 150,000.00 ( 8,625.00) 105.8 TOTAL SEPTIC WASTE DISPOSAL 11,775.00 158,625.00 150,000.00 ( 8,625.00) 105.8 TOTAL SEWER - REVENUE 137,588.67 1,558,039.74 1,566,100.00 8,060.26 99.5 TOTAL FUND REVENUE 137,588.67 1,558,039.74 1,566,100.00 8,060.26 99.5 SEWER - ADMINISTRATION DEPRECIATION: 32-5500-1150 DEPRECIATION 80,500.00 322,000.00 322,000.00 .00 100.0 TOTAL DEPRECIATION 80,500.00 322,000.00 322,000.00 .00 100.0 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 655.93 7,784.13 7,853.00 68.87 99.1 TOTAL PROFESSIONAL SERVICES 655.93 7,784.13 7,853.00 68.87 99.1 OPERATING TRANSFERS: 32-5500-4347 MANAGEMENT FEES 34,078.50 136,314.00 136,314.00 .00 100.0 TOTAL OPERATING TRANSFERS 34,078.50 136,314.00 136,314.00 .00 100.0 TOTAL SEWER - ADMINISTRATION 115,234.43 466,098.13 466,167.00 68.87 100.0 SEWER - TREATMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:46AM PAGE:44 CASH FUND APPROPRIATION: 32-5501-0150 SLUDGE REMOVAL RESERVE 21,250.00 85,000.00 85,000.00 .00 100.0 TOTAL CASH FUND APPROP 21,250.00 85,000.00 85,000.00 .00 100.0 PERSONNEL SERVICES: 32-5501-1001 SALARIES/WAGES - REGULAR 7,336.58 98,414.35 94,254.00 ( 4,160.35) 104.4 32-5501-1002 SALARIES/WAGES - OVERTIME .00 2,088.15 5,000.00 2,911.85 41.8 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 392.13 392.00 ( .13) 100.0 32-5501-1006 SALARIES/WAGES - ALLOWANCES .00 275.00 300.00 25.00 91.7 32-5501-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 3,324.00 3,324.00 .0 TOTAL PERSONNEL SERVICES 7,336.58 101,169.63 103,270.00 2,100.37 98.0 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 572.08 7,854.63 7,993.00 138.37 98.3 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS .00 35,737.75 39,002.00 3,264.25 91.6 32-5501-1025 EMPLOYEE BENEFITS - COMP 190.76 2,630.42 2,657.00 26.58 99.0 32-5501-1026 EMPLOYEE BENEFITS - COMP 111.64 1,116.44 829.00 ( 287.44) 134.7 32-5501-1029 EMPLOYEE BENEFITS - WY 1,261.88 16,577.10 17,072.00 494.90 97.1 TOTAL EMPLOYEE BENEFITS 2,136.36 63,916.34 67,553.00 3,636.66 94.6 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 614.00 2,570.00 1,956.00 23.9 TOTAL PURCHASED SERVICES .00 614.00 2,570.00 1,956.00 23.9 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 8,885.33 57,272.96 80,000.00 22,727.04 71.6 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 13,304.26 77,443.31 63,000.00 ( 14,443.31) 122.9 32-5501-2134 TELECOMMUNICATIONS 161.69 1,804.26 1,700.00 ( 104.26) 106.1 TOTAL PROPERTY SERVICES 22,351.28 136,520.53 144,700.00 8,179.47 94.4 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,565.00 2,000.00 435.00 78.3 32-5501-2155 REPAIRS/MAINTENANCE 99.72 17,749.60 30,000.00 12,250.40 59.2 32-5501-2158 MISC CONTRACTUAL SERVICES 1,524.00 11,948.75 10,000.00 ( 1,948.75) 119.5 TOTAL PROFESSIONAL SERVICES 1,623.72 31,263.35 42,000.00 10,736.65 74.4 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 1,901.48 30,909.29 25,000.00 ( 5,909.29) 123.6 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 17,800.88 20,500.00 2,699.12 86.8 32-5501-3235 FUEL 270.83 826.91 1,200.00 373.09 68.9 TOTAL SUPPLIES 2,172.31 49,537.08 46,700.00 ( 2,837.08) 106.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:46AM PAGE:45 CAPITALIZED EXPENDITURES: 32-5501-6544 OTHER THAN BLDG .00 7,350.45 14,000.00 6,649.55 52.5 32-5501-6548 VEHICLES .00 .00 20,000.00 20,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 7,350.45 34,000.00 26,649.55 21.6 TOTAL SEWER - TREATMENT 56,870.25 475,371.38 525,793.00 50,421.62 90.4 SEWER - COLLECTION CASH FUND APPROPRIATION: 32-5502-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: 32-5502-1001 SALARIES/WAGES - REGULAR 10,388.25 186,930.62 191,325.00 4,394.38 97.7 32-5502-1002 SALARIES/WAGES - OVERTIME 400.72 7,857.34 4,500.00 ( 3,357.34) 174.6 32-5502-1004 SALARIES/WAGES - TEMPORARY 896.25 896.25 3,042.00 2,145.75 29.5 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 935.41 935.00 ( .41) 100.0 32-5502-1006 SALARIES & WAGES - ALLOWANCES .00 275.00 300.00 25.00 91.7 32-5502-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 6,450.00 6,450.00 .0 TOTAL PERSONNEL SERVICES 11,685.22 196,894.62 206,552.00 9,657.38 95.3 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 896.18 15,018.70 15,831.00 812.30 94.9 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS .00 77,934.43 90,881.00 12,946.57 85.8 32-5502-1025 EMPLOYEE BENEFITS - COMP 303.81 5,119.14 5,327.00 207.86 96.1 32-5502-1029 EMPLOYEE BENEFITS - WY 1,855.69 31,845.74 33,682.00 1,836.26 94.6 TOTAL EMPLOYEE BENEFITS 3,055.68 129,918.01 145,721.00 15,802.99 89.2 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 273.37 1,658.25 1,700.00 41.75 97.5 32-5502-2122 TRAINING/DEVELOPMENT .00 394.00 1,825.00 1,431.00 21.6 32-5502-2123 MEALS/LODGING/TRAVEL .00 367.65 .00 ( 367.65) .0 TOTAL PURCHASED SERVICES 273.37 2,419.90 3,525.00 1,105.10 68.7 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 1,435.19 10,394.62 12,000.00 1,605.38 86.6 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 77.50 316.49 350.00 33.51 90.4 32-5502-2133 UTILITY SERVICES - NATURAL GAS 152.16 3,056.70 1,800.00 ( 1,256.70) 169.8 32-5502-2134 TELECOMMUNICATIONS 96.53 962.35 715.00 ( 247.35) 134.6 TOTAL PROPERTY SERVICES 1,761.38 14,730.16 14,865.00 134.84 99.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:46AM PAGE:46 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,748.75 2,500.00 751.25 70.0 32-5502-2155 REPAIRS/MAINTENANCE 243.00 1,709.90 15,000.00 13,290.10 11.4 32-5502-2158 MISC CONTRACTUAL SERVICES .00 12,000.00 13,000.00 1,000.00 92.3 TOTAL PROFESSIONAL SERVICES 243.00 15,458.65 30,500.00 15,041.35 50.7 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 4,017.08 24,761.19 30,000.00 5,238.81 82.5 32-5502-3235 FUEL 1,658.13 5,854.65 7,000.00 1,145.35 83.6 TOTAL SUPPLIES 5,675.21 30,615.84 37,000.00 6,384.16 82.8 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 .00 300.00 300.00 .0 TOTAL FINANCIAL .00 .00 300.00 300.00 .0 CAPITALIZED EXPENDITURES: 32-5502-6542 TO BLDG .00 .00 10,000.00 10,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 10,000.00 10,000.00 .0 TOTAL SEWER - COLLECTION 30,193.86 420,037.18 478,463.00 58,425.82 87.8 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 1,200.00 45,977.00 46,000.00 23.00 100.0 TOTAL PROFESSIONAL SERVICES 1,200.00 45,977.00 46,000.00 23.00 100.0 CAPITALIZED EXPENDITURES: 32-5850-6544 OTHER THAN BLDG .00 .00 308,000.00 308,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 308,000.00 308,000.00 .0 TOTAL WASTEWATER PLANT REHAB 1,200.00 45,977.00 354,000.00 308,023.00 13.0 SEWER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 10,990.63 141,202.80 417,500.00 276,297.20 33.8 TOTAL PROFESSIONAL SERVICES 10,990.63 141,202.80 417,500.00 276,297.20 33.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:46AM PAGE:47 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG .00 418,122.38 983,000.00 564,877.62 42.5 TOTAL CAPITALIZED EXPENDITURES .00 418,122.38 983,000.00 564,877.62 42.5 TOTAL SEWER MAIN REPLACEMENTS 10,990.63 559,325.18 1,400,500.00 841,174.82 39.9 TOTAL FUND EXPENDITURES 214,489.17 1,966,808.87 3,224,923.00 1,258,114.13 61.0 NET REVENUE OVER EXPENDITURES ( 76,900.50) ( 408,769.13) ( 1,658,823.00) ( 1,250,053.87) ( 24.6) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:46AM PAGE:48 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 735,535.52 TOTAL CASH 735,535.52 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 429,143.01 TOTAL INVESTMENTS 429,143.01 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 95.00 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 1,698.72) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 132,037.07 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 1,822.57) 33-10000139 ACCRUED INTEREST RECEIVABLE 774.33 33-10000156 DUE FROM OTHER FUNDS 10,063.32 TOTAL ACCOUNTS RECEIVABLE 139,448.43 TOTAL CURRENT ASSETS 1,304,126.96 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 ( 68,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 9,907.22 TOTAL OTHER ASSETS ( 58,092.78) TOTAL NON-CURRENT ASSETS 229,238.35 TOTAL ASSETS 1,533,365.31 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:46AM PAGE:49 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 118,381.38 33-20000204 ACCOUNTS PAYBLE - EOY ( 90,081.00) 33-20000215 WAGES PAYABLE 7,785.59 TOTAL ACCOUNTS PAYABLE 36,085.97 DUE TO OTHER FUNDS: 33-20000245 DUE TO OTHER FUNDS 90,081.00 TOTAL DUE TO OTHER FUNDS 90,081.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 227,685.23 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 38,968.51 TOTAL NON-CURRENT LIABILITIES 38,968.51 TOTAL LIABILITIES 266,653.74 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 17,707.33) 33-30000305 RESERVE FOR REPLACEMENT 911,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 970,037.21 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 287,331.13 TOTAL OTHER NET ASSETS 287,331.13 REVENUE OVER EXPENDITURES - YTD 9,343.23 BALANCE - CURRENT DATE 1,266,711.57 TOTAL NET ASSETS 1,266,711.57 TOTAL LIABILITIES AND NET ASSETS 1,533,365.31 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:46AM PAGE:50 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1140 INTEREST INCOME 1,111.12 17,862.81 7,000.00 ( 10,862.81) 255.2 TOTAL MISC LOCAL REVENUE 1,111.12 17,862.81 7,000.00 ( 10,862.81) 255.2 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 115,724.64 1,388,482.22 1,375,000.00 ( 13,482.22) 101.0 33-4330-1709 SANITATION ACTIVATION FEE 250.00 500.00 125.00 ( 375.00) 400.0 TOTAL UTILITIES REVENUE 115,974.64 1,388,982.22 1,375,125.00 ( 13,857.22) 101.0 TOTAL SANITATION - REVENUE 117,085.76 1,406,845.03 1,382,125.00 ( 24,720.03) 101.8 TOTAL FUND REVENUE 117,085.76 1,406,845.03 1,382,125.00 ( 24,720.03) 101.8 SANITATION CASH FUND APPROPRIATION: 33-5600-0150 REPLACEMENT RESERVE 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL CASH FUND APPROP 12,500.00 50,000.00 50,000.00 .00 100.0 PERSONNEL SERVICES: 33-5600-1001 SALARIES/WAGES - REGULAR 10,778.84 157,849.11 146,366.00 ( 11,483.11) 107.9 33-5600-1002 SALARIES/WAGES - OVERTIME .00 19.26 600.00 580.74 3.2 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 1,427.28 1,427.00 ( .28) 100.0 33-5600-1006 SALARIES/WAGES - ALLOWANCES .00 228.22 300.00 71.78 76.1 33-5600-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 3,252.56 9,017.00 5,764.44 36.1 TOTAL PERSONNEL SERVICES 10,778.84 162,776.43 157,710.00 ( 5,066.43) 103.2 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 837.84 12,630.99 12,237.00 ( 393.99) 103.2 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS .00 58,447.90 64,957.00 6,509.10 90.0 33-5600-1025 EMPLOYEE BENEFITS - COMP 280.26 4,232.28 3,977.00 ( 255.28) 106.4 33-5600-1026 EMPLOYEE BENEFITS - COMP 143.86 1,984.17 1,859.00 ( 125.17) 106.7 33-5600-1029 EMPLOYEE BENEFITS - WY 1,853.96 24,265.60 25,278.00 1,012.40 96.0 TOTAL EMPLOYEE BENEFITS 3,115.92 101,560.94 108,308.00 6,747.06 93.8 DEPRECIATION: 33-5600-1150 DEPRECIATION 17,000.00 68,000.00 68,000.00 .00 100.0 TOTAL DEPRECIATION 17,000.00 68,000.00 68,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:49AM PAGE:51 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE .00 3,105.17 4,200.00 1,094.83 73.9 33-5600-2158 MISC CONTRACTUAL SERVICES 111,729.36 840,830.05 1,000,000.00 159,169.95 84.1 TOTAL PROFESSIONAL SERVICES 111,729.36 843,935.22 1,004,200.00 160,264.78 84.0 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 1,707.82 22,741.25 27,000.00 4,258.75 84.2 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 26,979.52 29,700.00 2,720.48 90.8 33-5600-3235 FUEL 5,133.70 16,651.44 22,000.00 5,348.56 75.7 TOTAL SUPPLIES 6,841.52 66,372.21 78,700.00 12,327.79 84.3 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 26,214.25 104,857.00 104,857.00 .00 100.0 TOTAL OPERATING TRANSFERS 26,214.25 104,857.00 104,857.00 .00 100.0 TOTAL SANITATION 188,179.89 1,397,501.80 1,571,775.00 174,273.20 88.9 TOTAL FUND EXPENDITURES 188,179.89 1,397,501.80 1,571,775.00 174,273.20 88.9 NET REVENUE OVER EXPENDITURES ( 71,094.13) 9,343.23 ( 189,650.00) ( 198,993.23) 4.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:49AM PAGE:52 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 637,821.24 TOTAL CASH 637,821.24 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,667,651.20 TOTAL INVESTMENTS 1,667,651.20 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 162,161.10 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 90,081.00) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY ( 1,976.69) 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 4,318.00) 34-10000139 ACCRUED INTEREST RECEIVABLE 2,818.25 34-10000156 DUE FROM OTHER FUNDS 100,799.03 TOTAL ACCOUNTS RECEIVABLE 169,402.69 TOTAL CURRENT ASSETS 2,474,875.13 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 ( 65,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 17,494.06 TOTAL OTHER ASSETS ( 47,505.94) TOTAL NON-CURRENT ASSETS 1,963,112.19 TOTAL ASSETS 4,437,987.32 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:49AM PAGE:53 ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 80,705.04 34-20000204 ACCOUNTS PAYABLE- EOY 34,811.09 34-20000215 WAGES PAYABLE 11,349.30 TOTAL ACCOUNTS PAYABLE 126,865.43 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 275,173.35 NON-CURRENT LIABILITIES: 34-20000260 SLIB NOTES PAYABLE 77,853.77 34-20000265 COMPENSATED ABSENCES PAYABLE 36,070.73 34-20000290 LANDFILL LIABILITY 471,942.60 TOTAL NON-CURRENT LIABILITIES 585,867.10 TOTAL LIABILITIES 861,040.45 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS ( 185,646.51) 34-30000305 RESERVE FOR REPLACEMENT 1,256,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,203,524.26 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 ( 109,138.11) BALANCE - CURRENT DATE 3,576,946.87 TOTAL NET ASSETS 3,576,946.87 TOTAL LIABILITIES AND NET ASSETS 4,437,987.32 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:49AM PAGE:54 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER .00 9,292.50 .00 ( 9,292.50) .0 34-4340-1140 INTEREST INCOME 1,832.74 44,924.94 25,000.00 ( 19,924.94) 179.7 TOTAL MISC LOCAL REVENUE 1,832.74 54,217.44 25,000.00 ( 29,217.44) 216.9 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 171,738.10 1,111,852.60 1,000,000.00 ( 111,852.60) 111.2 TOTAL UTILITIES REVENUE 171,738.10 1,111,852.60 1,000,000.00 ( 111,852.60) 111.2 TOTAL LANDFILL - REVENUE 173,570.84 1,166,070.04 1,025,000.00 ( 141,070.04) 113.8 TOTAL FUND REVENUE 173,570.84 1,166,070.04 1,025,000.00 ( 141,070.04) 113.8 LANDFILL PERSONNEL SERVICES: 34-5340-1001 SALARIES/WAGES - REGULAR 17,411.09 260,562.30 212,413.00 ( 48,149.30) 122.7 34-5340-1002 SALARIES/WAGES - OVERTIME 18.89 816.22 1,500.00 683.78 54.4 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,747.08 1,747.00 ( .08) 100.0 34-5340-1006 SALARIES/WAGES - ALLOWANCES .00 533.33 600.00 66.67 88.9 34-5340-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 923.40 7,537.00 6,613.60 12.3 TOTAL PERSONNEL SERVICES 17,429.98 264,582.33 223,797.00 ( 40,785.33) 118.2 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,382.23 20,948.78 17,849.00 ( 3,099.78) 117.4 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS .00 68,141.90 77,888.00 9,746.10 87.5 34-5340-1025 EMPLOYEE BENEFITS - COMP 453.19 6,879.11 5,817.00 ( 1,062.11) 118.3 34-5340-1026 EMPLOYEE BENEFITS - COMP 709.19 9,299.19 8,739.00 ( 560.19) 106.4 34-5340-1029 EMPLOYEE BENEFITS - WY 2,288.75 28,477.19 28,054.00 ( 423.19) 101.5 TOTAL EMPLOYEE BENEFITS 4,833.36 133,746.17 138,347.00 4,600.83 96.7 DEPRECIATION: 34-5340-1150 DEPRECIATION 16,250.00 65,000.00 65,000.00 .00 100.0 TOTAL DEPRECIATION 16,250.00 65,000.00 65,000.00 .00 100.0 PURCHASED SERVICES: 34-5340-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 250.00 250.00 .0 34-5340-2122 TRAINING/DEVELOPMENT .00 700.00 800.00 100.00 87.5 34-5340-2123 MEALS/LODGING/TRAVEL .00 270.01 1,000.00 729.99 27.0 TOTAL PURCHASED SERVICES .00 970.01 2,050.00 1,079.99 47.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:50AM PAGE:55 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 787.38 6,511.78 9,000.00 2,488.22 72.4 34-5340-2133 UTILITY SERVICES - NATURAL GAS ( 677.77) 11,629.78 9,000.00 ( 2,629.78) 129.2 34-5340-2134 TELECOMMUNICATIONS .00 .00 250.00 250.00 .0 TOTAL PROPERTY SERVICES 109.61 18,141.56 18,250.00 108.44 99.4 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 34-5340-2155 REPAIRS/MAINTENANCE 893.58 3,576.50 15,000.00 11,423.50 23.8 34-5340-2156 MAINTENANCE AGREEMENT .00 4,058.95 9,000.00 4,941.05 45.1 34-5340-2158 MISC CONTRACTUAL SERVICES 60,383.78 392,246.53 465,000.00 72,753.47 84.4 34-5340-2166 COLLECTION FEES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 61,277.36 399,881.98 490,300.00 90,418.02 81.6 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 5,216.24 41,450.20 40,000.00 ( 1,450.20) 103.6 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,396.55 1,446.10 2,500.00 1,053.90 57.8 34-5340-3235 FUEL 3,678.65 19,365.78 20,000.00 634.22 96.8 TOTAL SUPPLIES 10,291.44 62,262.08 62,500.00 237.92 99.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,214.25 104,857.00 104,857.00 .00 100.0 TOTAL OPERATING TRANSFERS 26,214.25 104,857.00 104,857.00 .00 100.0 TOTAL LANDFILL 136,406.00 1,062,582.15 1,118,242.02 55,659.87 95.0 LANDFILL - CAPITAL PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 9,026.63 22,564.00 50,000.00 27,436.00 45.1 34-5895-2158 MISC CONTRACTUAL SERVICES .00 14,000.00 .00 ( 14,000.00) .0 TOTAL PROFESSIONAL SERVICES 9,026.63 36,564.00 50,000.00 13,436.00 73.1 CAPITALIZED EXPENDITURES: 34-5895-6544 OTHER THAN BLDG .00 176,062.00 200,000.00 23,938.00 88.0 TOTAL CAPITALIZED EXPENDITURES .00 176,062.00 200,000.00 23,938.00 88.0 TOTAL LANDFILL - CAPITAL 9,026.63 212,626.00 250,000.00 37,374.00 85.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:50AM PAGE:56 TOTAL FUND EXPENDITURES 145,432.63 1,275,208.15 1,368,242.02 93,033.87 93.2 NET REVENUE OVER EXPENDITURES 28,138.21 ( 109,138.11) ( 343,242.02) ( 234,103.91) ( 31.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:50AM PAGE:57 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 233,238.03 TOTAL CASH 233,238.03 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 406,232.64 TOTAL INVESTMENTS 406,232.64 ACCOUNTS RECEIVABLE: 39-10000132 ACCOUNTS REC - EOY 123,011.97 39-10000139 ACCRUED INTEREST RECEIVABLE 873.34 TOTAL ACCOUNTS RECEIVABLE 123,885.31 TOTAL CURRENT ASSETS 763,355.98 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 763,355.98 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, 2023 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:50AM PAGE:58 CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 655,704.21) 39-30000301 FUND BALANCE RESERVE 1,300,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 751,295.79 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 387,027.12) BALANCE - CURRENT DATE 364,268.67 TOTAL NET ASSETS 364,268.67 TOTAL LIABILITIES AND NET ASSETS 763,355.98 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:50AM PAGE:59 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 62,594.95 349,746.36 50,000.00 ( 299,746.36) 699.5 39-4390-0111 INSURANCE PREMIUMS ( 842.04) 500,535.36 375,000.00 ( 125,535.36) 133.5 39-4390-0112 INSURANCE ASSESSMENTS ( 1,787.96) 807,950.10 1,100,000.00 292,049.90 73.5 TOTAL REVENUE 59,964.95 1,658,231.82 1,525,000.00 ( 133,231.82) 108.7 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 625.54 17,177.27 16,500.00 ( 677.27) 104.1 TOTAL MISC LOCAL REVENUE 625.54 17,177.27 16,500.00 ( 677.27) 104.1 TRANSFERS IN: 39-4390-5510 TRANSFER FROM GENERAL FUND 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL TRANSFERS IN 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL EMPLOYEE HEALTH CARE - REVENUE 85,590.49 1,775,409.09 1,641,500.00 ( 133,909.09) 108.2 TOTAL FUND REVENUE 85,590.49 1,775,409.09 1,641,500.00 ( 133,909.09) 108.2 EMPLOYEE HEALTH CARE CASH FUND APPROPRIATION: 39-5390-0150 REPLACEMENT RESERVE 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL CASH FUND APPROP 25,000.00 100,000.00 100,000.00 .00 100.0 EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM .00 459,377.64 459,400.00 22.36 100.0 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 134,888.37 1,509,363.30 1,600,000.00 90,636.70 94.3 39-5390-1058 HEALTH CARE - FEE .00 93,695.27 94,000.00 304.73 99.7 TOTAL EMPLOYEE BENEFITS 134,888.37 2,062,436.21 2,153,400.00 90,963.79 95.8 TOTAL EMPLOYEE HEALTH CARE 159,888.37 2,162,436.21 2,253,400.00 90,963.79 96.0 TOTAL FUND EXPENDITURES 159,888.37 2,162,436.21 2,253,400.00 90,963.79 96.0 NET REVENUE OVER EXPENDITURES ( 74,297.88) ( 387,027.12) ( 611,900.00) ( 224,872.88) ( 63.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:53AM PAGE:60 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 45,022.73 TOTAL CASH 45,022.73 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 315,374.60 TOTAL INVESTMENTS 315,374.60 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 603.52 TOTAL ACCOUNTS RECEIVABLE 603.52 TOTAL CURRENT ASSETS 361,000.85 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 361,000.85 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 353,564.84 TOTAL CAPITAL ASSETS 353,564.84 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 7,436.01 BALANCE - CURRENT DATE 361,000.85 TOTAL NET ASSETS 361,000.85 TOTAL LIABILITIES AND NET ASSETS 361,000.85 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:53AM PAGE:61 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 189.09 7,436.01 2,900.00 ( 4,536.01) 256.4 TOTAL MISC LOCAL REVENUE 189.09 7,436.01 2,900.00 ( 4,536.01) 256.4 TOTAL CAPITAL IMP RESERVE - REVENUE 189.09 7,436.01 2,900.00 ( 4,536.01) 256.4 TOTAL FUND REVENUE 189.09 7,436.01 2,900.00 ( 4,536.01) 256.4 NET REVENUE OVER EXPENDITURES 189.09 7,436.01 2,900.00 ( 4,536.01) 256.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:55AM PAGE:62 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 221,096.42 TOTAL CASH 221,096.42 INVESTMENTS: 41-10000122 TIME DEPOSITS-SHORT TERM 188,365.15 TOTAL INVESTMENTS 188,365.15 ACCOUNTS RECEIVABLE: 41-10000139 ACCRUED INTEREST RECEIVABLE 917.12 TOTAL ACCOUNTS RECEIVABLE 917.12 TOTAL CURRENT ASSETS 410,378.69 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 410,378.69 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 41-20000201 ACCOUNTS PAY ALLOC TO FUNDS 37,021.60 TOTAL ACCOUNTS PAYABLE 37,021.60 TOTAL CURRENT LIABILITIES 37,021.60 TOTAL LIABILITIES 37,021.60 NET ASSETS CAPITAL ASSETS: 41-30000300 FUND BALANCE/BEGINNING OF YEAR 353,035.47 TOTAL CAPITAL ASSETS 353,035.47 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:55AM PAGE:63 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 20,321.62 BALANCE - CURRENT DATE 373,357.09 TOTAL NET ASSETS 373,357.09 TOTAL LIABILITIES AND NET ASSETS 410,378.69 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:55AM PAGE:64 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 1,326.38 7,343.22 1,900.00 ( 5,443.22) 386.5 TOTAL MISC LOCAL REVENUE 1,326.38 7,343.22 1,900.00 ( 5,443.22) 386.5 TRANSFERS IN: 41-4410-5510 TRANSFER FROM GENERAL FUND 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL TRANSFERS IN 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL ECONOMIC DEVELOPMENT 13,826.38 57,343.22 51,900.00 ( 5,443.22) 110.5 TOTAL FUND REVENUE 13,826.38 57,343.22 51,900.00 ( 5,443.22) 110.5 ECONOMIC DEVELOPMENT PROFESSIONAL SERVICES: 41-5410-2158 MISC CONTRACTUAL SERVICES 37,021.60 37,021.60 50,000.00 12,978.40 74.0 TOTAL PROFESSIONAL SERVICES 37,021.60 37,021.60 50,000.00 12,978.40 74.0 TOTAL ECONOMIC DEVELOPMENT 37,021.60 37,021.60 50,000.00 12,978.40 74.0 TOTAL FUND EXPENDITURES 37,021.60 37,021.60 50,000.00 12,978.40 74.0 NET REVENUE OVER EXPENDITURES ( 23,195.22) 20,321.62 1,900.00 ( 18,421.62) 1069.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 BROWNFIELD GRANT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:56AM PAGE:65 ASSETS CURRENT ASSETS: CASH: 42-10000116 CASH ALLOC FR COMBINED FUND ( 6,697.67) TOTAL CASH ( 6,697.67) ACCOUNTS RECEIVABLE: 42-10000131 ACCOUNTS RECEIVABLE - GENERAL 8,015.60 TOTAL ACCOUNTS RECEIVABLE 8,015.60 TOTAL CURRENT ASSETS 1,317.93 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,317.93 LIABILITIES AND EQUITY LIABILITIES NET ASSETS OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,317.93 BALANCE - CURRENT DATE 1,317.93 TOTAL NET ASSETS 1,317.93 TOTAL LIABILITIES AND NET ASSETS 1,317.93 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:56AM PAGE:66 BROWNFIELD HAZARDOUS - REVENUE FEDERAL REVENUE SOURCES: 42-4870-4281 EPA .00 20,786.60 34,680.00 13,893.40 59.9 TOTAL FEDERAL REVENUE SOURCES .00 20,786.60 34,680.00 13,893.40 59.9 TOTAL BROWNFIELD HAZARDOUS - REVENUE .00 20,786.60 34,680.00 13,893.40 59.9 BROWNFIELD PETROLEUM - REVENUE FEDERAL REVENUE SOURCES: 42-4871-4281 EPA 8,015.60 19,167.58 42,005.00 22,837.42 45.6 TOTAL FEDERAL REVENUE SOURCES 8,015.60 19,167.58 42,005.00 22,837.42 45.6 TOTAL BROWNFIELD PETROLEUM - REVENUE 8,015.60 19,167.58 42,005.00 22,837.42 45.6 TOTAL FUND REVENUE 8,015.60 39,954.18 76,685.00 36,730.82 52.1 BROWNFIELD HAZARDOUS PURCHASED SERVICES: 42-5870-2123 MEALS/LODGING/TRAVEL .00 1,041.72 1,968.00 926.28 52.9 TOTAL PURCHASED SERVICES .00 1,041.72 1,968.00 926.28 52.9 PROFESSIONAL SERVICES: 42-5870-2158 MISC CONTRACTUAL SERVICES .00 11,258.78 32,712.00 21,453.22 34.4 TOTAL PROFESSIONAL SERVICES .00 11,258.78 32,712.00 21,453.22 34.4 TOTAL BROWNFIELD HAZARDOUS .00 12,300.50 34,680.00 22,379.50 35.5 BROWNFIELD PETROLEUM PURCHASED SERVICES: 42-5871-2123 MEALS/LODGING/TRAVEL .00 1,041.73 1,968.00 926.27 52.9 TOTAL PURCHASED SERVICES .00 1,041.73 1,968.00 926.27 52.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 11:57AM PAGE:67 PROFESSIONAL SERVICES: 42-5871-2158 MISC CONTRACTUAL SERVICES .00 25,294.02 40,037.00 14,742.98 63.2 TOTAL PROFESSIONAL SERVICES .00 25,294.02 40,037.00 14,742.98 63.2 TOTAL BROWNFIELD PETROLEUM .00 26,335.75 42,005.00 15,669.25 62.7 TOTAL FUND EXPENDITURES .00 38,636.25 76,685.00 38,048.75 50.4 NET REVENUE OVER EXPENDITURES 8,015.60 1,317.93 .00 ( 1,317.93) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:01PM PAGE:68 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND ( 36,925.31) TOTAL CASH ( 36,925.31) TOTAL CURRENT ASSETS ( 36,925.31) TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS ( 36,925.31) LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR ( 187,243.32) 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS 33,997.55 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 70,922.86) BALANCE - CURRENT DATE ( 36,925.31) TOTAL NET ASSETS ( 36,925.31) TOTAL LIABILITIES AND NET ASSETS ( 36,925.31) ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:01PM PAGE:69 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME .00 66.78 1,000.00 933.22 6.7 TOTAL MISC LOCAL REVENUE .00 66.78 1,000.00 933.22 6.7 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND 75,000.00 300,000.00 300,000.00 .00 100.0 TOTAL TRANSFERS IN 75,000.00 300,000.00 300,000.00 .00 100.0 TOTAL GENERAL FUND EQUIP RES-REVENUE 75,000.00 300,066.78 301,000.00 933.22 99.7 TOTAL FUND REVENUE 75,000.00 300,066.78 301,000.00 933.22 99.7 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE .00 175,388.76 177,296.00 1,907.24 98.9 47-5470-6548 VEHICLES .00 195,600.88 193,642.00 ( 1,958.88) 101.0 TOTAL CAPITALIZED EXPENDITURES .00 370,989.64 370,938.00 ( 51.64) 100.0 TOTAL GENERAL FUND EQUIPMENT RESERVE .00 370,989.64 370,938.00 ( 51.64) 100.0 TOTAL FUND EXPENDITURES .00 370,989.64 370,938.00 ( 51.64) 100.0 NET REVENUE OVER EXPENDITURES 75,000.00 ( 70,922.86) ( 69,938.00) 984.86 ( 101.4) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:09PM PAGE:70 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 661,785.56 TOTAL CASH 661,785.56 INVESTMENTS: 50-10000120 INVESTMENT POOL ( 8.10) TOTAL INVESTMENTS ( 8.10) TOTAL CURRENT ASSETS 661,777.46 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 661,777.46 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR 329,040.44 50-30000301 RESERVED FUND BALANCE 255,959.63 TOTAL CAPITAL ASSETS 585,000.07 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 76,777.39 BALANCE - CURRENT DATE 661,777.46 TOTAL NET ASSETS 661,777.46 TOTAL LIABILITIES AND NET ASSETS 661,777.46 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:09PM PAGE:71 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1107 OTHER 93,046.68 93,046.68 .00 ( 93,046.68) .0 50-4500-1140 INTEREST INCOME 675.23 8,280.71 1,550.00 ( 6,730.71) 534.2 TOTAL MISC LOCAL REVENUE 93,721.91 101,327.39 1,550.00 ( 99,777.39) 6537.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 156,221.91 351,327.39 251,550.00 ( 99,777.39) 139.7 TOTAL FUND REVENUE 156,221.91 351,327.39 251,550.00 ( 99,777.39) 139.7 FIRE EQUIPMENT CAPITALIZED EXPENDITURES: 50-5500-6548 BUILDINGS .00 274,550.00 275,000.00 450.00 99.8 TOTAL CAPITALIZED EXPENDITURES .00 274,550.00 275,000.00 450.00 99.8 TOTAL FIRE EQUIPMENT .00 274,550.00 275,000.00 450.00 99.8 TOTAL FUND EXPENDITURES .00 274,550.00 275,000.00 450.00 99.8 NET REVENUE OVER EXPENDITURES 156,221.91 76,777.39 ( 23,450.00) ( 100,227.39) 327.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:15PM PAGE:72 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 5,851.66 TOTAL CAPITAL ASSETS 5,851.66 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,470.00 BALANCE - CURRENT DATE 7,321.66 TOTAL NET ASSETS 7,321.66 TOTAL LIABILITIES AND NET ASSETS 7,321.66 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 CPTL PROJ - CLG PROJECTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:15PM PAGE:73 HISTORIC DISTRICT - REVENUE STATE REVENUE: 53-4809-3973 CERTIFIED LOCAL GOVERNMENT .00 2,460.00 3,990.00 1,530.00 61.7 TOTAL STATE REVENUE .00 2,460.00 3,990.00 1,530.00 61.7 TRANSFERS IN: 53-4809-5510 TRANSFER FROM GENERAL FUND 752.50 3,010.00 3,010.00 .00 100.0 TOTAL TRANSFERS IN 752.50 3,010.00 3,010.00 .00 100.0 TOTAL HISTORIC DISTRICT - REVENUE 752.50 5,470.00 7,000.00 1,530.00 78.1 TOTAL FUND REVENUE 752.50 5,470.00 7,000.00 1,530.00 78.1 HISTORIC DISTRICT PROFESSIONAL SERVICES: 53-5809-2158 MISC CONTRACTUAL SERVICES .00 4,000.00 7,000.00 3,000.00 57.1 TOTAL PROFESSIONAL SERVICES .00 4,000.00 7,000.00 3,000.00 57.1 TOTAL HISTORIC DISTRICT .00 4,000.00 7,000.00 3,000.00 57.1 TOTAL FUND EXPENDITURES .00 4,000.00 7,000.00 3,000.00 57.1 NET REVENUE OVER EXPENDITURES 752.50 1,470.00 .00 ( 1,470.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:15PM PAGE:74 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 66,539.90 TOTAL CASH 66,539.90 TOTAL CURRENT ASSETS 66,539.90 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 66,539.90 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 54-20000201 ALLOCATION FROM AP FUND 965.00 TOTAL ACCOUNTS PAYABLE 965.00 TOTAL CURRENT LIABILITIES 965.00 TOTAL LIABILITIES 965.00 NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 38,119.90 TOTAL CAPITAL ASSETS 38,119.90 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 27,455.00 BALANCE - CURRENT DATE 65,574.90 TOTAL NET ASSETS 65,574.90 TOTAL LIABILITIES AND NET ASSETS 66,539.90 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:16PM PAGE:75 TRAIN CAR RESTORATION TRANSFERS IN: 54-4540-5510 TRANSFER FROM GENERAL FUND 8,750.00 35,000.00 35,000.00 .00 100.0 TOTAL TRANSFERS IN 8,750.00 35,000.00 35,000.00 .00 100.0 TOTAL TRAIN CAR RESTORATION 8,750.00 35,000.00 35,000.00 .00 100.0 TOTAL FUND REVENUE 8,750.00 35,000.00 35,000.00 .00 100.0 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE 965.00 7,545.00 35,000.00 27,455.00 21.6 TOTAL PROFESSIONAL SERVICES 965.00 7,545.00 35,000.00 27,455.00 21.6 TOTAL TRAIN CAR RESTORATION 965.00 7,545.00 35,000.00 27,455.00 21.6 TOTAL FUND EXPENDITURES 965.00 7,545.00 35,000.00 27,455.00 21.6 NET REVENUE OVER EXPENDITURES 7,785.00 27,455.00 .00 ( 27,455.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:16PM PAGE:76 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 167,134.06 TOTAL CASH 167,134.06 INVESTMENTS: 55-10000122 TIME DEPOSITS - SHORT TERM 245,051.15 TOTAL INVESTMENTS 245,051.15 ACCOUNTS RECEIVABLE: 55-10000139 ACCRUED INTEREST RECEIVABLE 877.48 TOTAL ACCOUNTS RECEIVABLE 877.48 TOTAL CURRENT ASSETS 413,062.69 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 413,062.69 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 55-20000201 ACCOUNTS PAY ALLOC TO FUNDS 5,910.00 TOTAL ACCOUNTS PAYABLE 5,910.00 TOTAL CURRENT LIABILITIES 5,910.00 TOTAL LIABILITIES 5,910.00 NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 275,799.63 TOTAL CAPITAL ASSETS 275,799.63 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:16PM PAGE:77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 131,353.06 BALANCE - CURRENT DATE 407,152.69 TOTAL NET ASSETS 407,152.69 TOTAL LIABILITIES AND NET ASSETS 413,062.69 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:16PM PAGE:78 POOL IMPROVEMENTS - REVENUE MISC LOCAL REVENUE: 55-4550-1140 INTEREST INCOME 748.68 6,043.06 3,400.00 ( 2,643.06) 177.7 TOTAL MISC LOCAL REVENUE 748.68 6,043.06 3,400.00 ( 2,643.06) 177.7 TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND 48,750.00 195,000.00 195,000.00 .00 100.0 TOTAL TRANSFERS IN 48,750.00 195,000.00 195,000.00 .00 100.0 TOTAL POOL IMPROVEMENTS - REVENUE 49,498.68 201,043.06 198,400.00 ( 2,643.06) 101.3 TOTAL FUND REVENUE 49,498.68 201,043.06 198,400.00 ( 2,643.06) 101.3 POOL IMPROVEMENTS PROFESSIONAL SERVICES: 55-5550-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,530.00 10,000.00 8,470.00 15.3 TOTAL PROFESSIONAL SERVICES .00 1,530.00 10,000.00 8,470.00 15.3 CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG 5,910.00 68,160.00 185,000.00 116,840.00 36.8 TOTAL CAPITALIZED EXPENDITURES 5,910.00 68,160.00 185,000.00 116,840.00 36.8 TOTAL POOL IMPROVEMENTS 5,910.00 69,690.00 195,000.00 125,310.00 35.7 TOTAL FUND EXPENDITURES 5,910.00 69,690.00 195,000.00 125,310.00 35.7 NET REVENUE OVER EXPENDITURES 43,588.68 131,353.06 3,400.00 ( 127,953.06) 3863.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:18PM PAGE:79 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 7,589,310.55 TOTAL CASH 7,589,310.55 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 11,651,945.97 TOTAL INVESTMENTS 11,651,945.97 ACCOUNTS RECEIVABLE: 56-10000139 ACCRUED INTEREST RECEIVABLE 20,614.47 TOTAL ACCOUNTS RECEIVABLE 20,614.47 TOTAL CURRENT ASSETS 19,261,870.99 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 19,261,870.99 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 343,640.78 56-20000210 RETAINAGE PAYABLE 8,137.36 TOTAL ACCOUNTS PAYABLE 351,778.14 TOTAL CURRENT LIABILITIES 351,778.14 TOTAL LIABILITIES 351,778.14 NET ASSETS CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 17,672,336.17 TOTAL CAPITAL ASSETS 17,672,336.17 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:18PM PAGE:80 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,237,756.68 BALANCE - CURRENT DATE 18,910,092.85 TOTAL NET ASSETS 18,910,092.85 TOTAL LIABILITIES AND NET ASSETS 19,261,870.99 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:18PM PAGE:81 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1140 INTEREST INCOME 47,597.05 225,863.82 76,600.00 ( 149,263.82) 294.9 TOTAL MISC LOCAL REVENUE 47,597.05 225,863.82 76,600.00 ( 149,263.82) 294.9 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND 750,000.00 3,000,000.00 3,000,000.00 .00 100.0 TOTAL TRANSFERS IN 750,000.00 3,000,000.00 3,000,000.00 .00 100.0 TOTAL STREET IMPROVEMENTS-REVENUE 797,597.05 3,225,863.82 3,076,600.00 ( 149,263.82) 104.9 TOTAL FUND REVENUE 797,597.05 3,225,863.82 3,076,600.00 ( 149,263.82) 104.9 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 85,896.37 333,623.17 603,250.00 269,626.83 55.3 56-5560-2158 MISC CONTRACTUAL SERVICES 29,207.00 52,017.25 60,000.00 7,982.75 86.7 TOTAL PROFESSIONAL SERVICES 115,103.37 385,640.42 663,250.00 277,609.58 58.1 TRANSFERS TO OTHER FUNDS: 56-5560-5510 TRANSFER TO OTHER FUNDS .00 .00 3,000,000.00 3,000,000.00 .0 TOTAL TRANSFERS TO OTHER FUNDS .00 .00 3,000,000.00 3,000,000.00 .0 CAPITALIZED EXPENDITURES: 56-5560-6544 OTHER THAN BLDG 245,770.41 1,602,466.72 5,049,500.00 3,447,033.28 31.7 TOTAL CAPITALIZED EXPENDITURES 245,770.41 1,602,466.72 5,049,500.00 3,447,033.28 31.7 TOTAL STREET IMPROVEMENTS 360,873.78 1,988,107.14 8,712,750.00 6,724,642.86 22.8 TOTAL FUND EXPENDITURES 360,873.78 1,988,107.14 8,712,750.00 6,724,642.86 22.8 NET REVENUE OVER EXPENDITURES 436,723.27 1,237,756.68 ( 5,636,150.00) ( 6,873,906.68) 22.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:20PM PAGE:82 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 2,325,468.45 TOTAL CASH 2,325,468.45 INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 1,319,033.64 TOTAL INVESTMENTS 1,319,033.64 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 3,339.39 TOTAL ACCOUNTS RECEIVABLE 3,339.39 TOTAL CURRENT ASSETS 3,647,841.48 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,647,841.48 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 91,242.50 57-20000210 RETAINAGE PAYABLE 3,183.82 TOTAL ACCOUNTS PAYABLE 94,426.32 TOTAL CURRENT LIABILITIES 94,426.32 TOTAL LIABILITIES 94,426.32 NET ASSETS CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 3,501,875.59 TOTAL CAPITAL ASSETS 3,501,875.59 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:20PM PAGE:83 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 51,539.57 BALANCE - CURRENT DATE 3,553,415.16 TOTAL NET ASSETS 3,553,415.16 TOTAL LIABILITIES AND NET ASSETS 3,647,841.48 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:20PM PAGE:84 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME 1,197.89 30,921.61 25,200.00 ( 5,721.61) 122.7 TOTAL MISC LOCAL REVENUE 1,197.89 30,921.61 25,200.00 ( 5,721.61) 122.7 TOTAL CAPITAL IMP - FACILITIES REV 1,197.89 30,921.61 25,200.00 ( 5,721.61) 122.7 TOTAL FUND REVENUE 1,197.89 30,921.61 25,200.00 ( 5,721.61) 122.7 CAPITAL IMP -FACILITIES CAPITALIZED EXPENDITURES: 57-5570-6542 BUILDINGS/IMPROVEMENTS 91,242.50 123,297.50 210,000.00 86,702.50 58.7 57-5570-6544 OTHER THAN BLDG .00 ( 143,915.46) .00 143,915.46 .0 TOTAL CAPITALIZED EXPENDITURES 91,242.50 ( 20,617.96) 210,000.00 230,617.96 ( 9.8) TOTAL CAPITAL IMP -FACILITIES 91,242.50 ( 20,617.96) 210,000.00 230,617.96 ( 9.8) TOTAL FUND EXPENDITURES 91,242.50 ( 20,617.96) 210,000.00 230,617.96 ( 9.8) NET REVENUE OVER EXPENDITURES ( 90,044.61) 51,539.57 ( 184,800.00) ( 236,339.57) 27.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:29PM PAGE:85 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 1,613,079.68 TOTAL CASH 1,613,079.68 INVESTMENTS: 65-10000120 INVESTMENT POOL 584,819.26 65-10000122 TIME DEPOSITS - SHORT TERM 1,836,141.67 TOTAL INVESTMENTS 2,420,960.93 ACCOUNTS RECEIVABLE: 65-10000139 ACCRUED INTEREST RECEIVABLE 911.21 TOTAL ACCOUNTS RECEIVABLE 911.21 TOTAL CURRENT ASSETS 4,034,951.82 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 4,034,951.82 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 192,169.30 65-20000210 RETAINAGE PAYABLE 14,177.38 TOTAL ACCOUNTS PAYABLE 206,346.68 TOTAL CURRENT LIABILITIES 206,346.68 TOTAL LIABILITIES 206,346.68 NET ASSETS CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 3,521,576.89 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 3,544,492.78 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:29PM PAGE:86 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 284,112.36 BALANCE - CURRENT DATE 3,828,605.14 TOTAL NET ASSETS 3,828,605.14 TOTAL LIABILITIES AND NET ASSETS 4,034,951.82 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:29PM PAGE:87 PARK - REVE REVENUE: 65-4650-0160 GAIN ON INVESTMENTS ( 1,833.77) ( 7,859.28) .00 7,859.28 .0 TOTAL REVENUE ( 1,833.77) ( 7,859.28) .00 7,859.28 .0 MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME 8,497.06 42,539.07 19,000.00 ( 23,539.07) 223.9 TOTAL MISC LOCAL REVENUE 8,497.06 42,539.07 19,000.00 ( 23,539.07) 223.9 TRANSFERS IN: 65-4650-5510 TRANSFER FROM GENERAL FUND 215,000.00 860,000.00 860,000.00 .00 100.0 TOTAL TRANSFERS IN 215,000.00 860,000.00 860,000.00 .00 100.0 TOTAL PARK - REVE 221,663.29 894,679.79 879,000.00 ( 15,679.79) 101.8 TOTAL FUND REVENUE 221,663.29 894,679.79 879,000.00 ( 15,679.79) 101.8 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY 27,291.40 102,639.96 131,750.00 29,110.04 77.9 TOTAL PROFESSIONAL SERVICES 27,291.40 102,639.96 131,750.00 29,110.04 77.9 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 .00 9,087.96 11,500.00 2,412.04 79.0 65-5650-6544 OTHER THAN BLDG 147,040.04 498,839.51 730,500.00 231,660.49 68.3 TOTAL CAPITALIZED EXPENDITURES 147,040.04 507,927.47 742,000.00 234,072.53 68.5 TOTAL PARK IMPROVEMENTS 174,331.44 610,567.43 874,250.00 263,682.57 69.8 TOTAL FUND EXPENDITURES 174,331.44 610,567.43 874,250.00 263,682.57 69.8 NET REVENUE OVER EXPENDITURES 47,331.85 284,112.36 4,750.00 ( 279,362.36) 5981.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:46PM PAGE:88 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 8,450.84 TOTAL CASH 8,450.84 INVESTMENTS: 90-10000120 INVESTMENT POOL 110,396.59 90-10000122 TIME DEPOSITS - SHORT TERM 64,404.54 TOTAL INVESTMENTS 174,801.13 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 238.62 TOTAL ACCOUNTS RECEIVABLE 238.62 TOTAL CURRENT ASSETS 183,490.59 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 183,490.59 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 38,045.56 TOTAL CAPITAL ASSETS 38,045.56 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 3,834.63 BALANCE - CURRENT DATE 183,490.59 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:47PM PAGE:89 TOTAL NET ASSETS 183,490.59 TOTAL LIABILITIES AND NET ASSETS 183,490.59 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:47PM PAGE:90 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES .00 3,625.00 3,000.00 ( 625.00) 120.8 TOTAL REVENUE .00 3,625.00 3,000.00 ( 625.00) 120.8 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 576.06 4,963.80 4,988.00 24.20 99.5 TOTAL MISC LOCAL REVENUE 576.06 4,963.80 4,988.00 24.20 99.5 TOTAL PERPETUAL CARE - REVENUE 576.06 8,588.80 7,988.00 ( 600.80) 107.5 TOTAL FUND REVENUE 576.06 8,588.80 7,988.00 ( 600.80) 107.5 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 1,488.17 4,754.17 4,988.00 233.83 95.3 TOTAL TRANSFERS TO OTHER FUNDS 1,488.17 4,754.17 4,988.00 233.83 95.3 TOTAL PERPETUAL CARE 1,488.17 4,754.17 4,988.00 233.83 95.3 TOTAL FUND EXPENDITURES 1,488.17 4,754.17 4,988.00 233.83 95.3 NET REVENUE OVER EXPENDITURES ( 912.11) 3,834.63 3,000.00 ( 834.63) 127.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:47PM PAGE:91 ASSETS CURRENT ASSETS: CASH: 91-10000116 CASH ALLOC FR COMBINED FUND 103.74 TOTAL CASH 103.74 TOTAL CURRENT ASSETS 103.74 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 103.74 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 91-20000400 SPECIFIED MEMORIALS 100.00 91-20000401 ONGOING MEMORIAL FUND 3.74 TOTAL OTHER PAYABLES 103.74 TOTAL CURRENT LIABILITIES 103.74 TOTAL LIABILITIES 103.74 TOTAL LIABILITIES AND NET ASSETS 103.74 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:47PM PAGE:92 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 21,620.20 TOTAL CASH 21,620.20 TOTAL CURRENT ASSETS 21,620.20 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 21,620.20 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 92-20000201 ACCOUNTS PAY ALLOC TO FUNDS 782.14 TOTAL ACCOUNTS PAYABLE 782.14 OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 685.02 92-20000406 HISTORIC PRESERVATION 3,246.20 92-20000407 HISTORIC PRESERVATION-KIOSK 16,776.53 92-20000408 HISTORIC PRESERVATION - MOVIE 615.38 TOTAL OTHER PAYABLES 21,323.13 TOTAL CURRENT LIABILITIES 22,105.27 TOTAL LIABILITIES 22,105.27 NET ASSETS CAPITAL ASSETS: 92-30000300 FUND BALANCE/BEGINNING OF YEAR ( 2,989.45) TOTAL CAPITAL ASSETS ( 2,989.45) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:47PM PAGE:93 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,504.38 BALANCE - CURRENT DATE ( 485.07) TOTAL NET ASSETS ( 485.07) TOTAL LIABILITIES AND NET ASSETS 21,620.20 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:47PM PAGE:94 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 912.50 3,650.00 3,650.00 .00 100.0 TOTAL TRANSFERS IN 912.50 3,650.00 3,650.00 .00 100.0 TOTAL HISTORIC CMSN - REVENU 912.50 3,650.00 3,650.00 .00 100.0 TOTAL FUND REVENUE 912.50 3,650.00 3,650.00 .00 100.0 HISTORIC PRESERVATION PROFESSIONAL SERVICES: 92-5920-2158 MISC CONTRACTUAL SERVICES 727.14 1,145.62 3,650.00 2,504.38 31.4 TOTAL PROFESSIONAL SERVICES 727.14 1,145.62 3,650.00 2,504.38 31.4 TOTAL HISTORIC PRESERVATION 727.14 1,145.62 3,650.00 2,504.38 31.4 TOTAL FUND EXPENDITURES 727.14 1,145.62 3,650.00 2,504.38 31.4 NET REVENUE OVER EXPENDITURES 185.36 2,504.38 .00 ( 2,504.38) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:48PM PAGE:95 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 10,289.35 TOTAL CASH 10,289.35 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 91,296.64 TOTAL INVESTMENTS 91,296.64 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 324.18 TOTAL ACCOUNTS RECEIVABLE 324.18 TOTAL CURRENT ASSETS 101,910.17 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 101,910.17 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 360.27 TOTAL ACCOUNTS PAYABLE 360.27 OTHER LIABILITIES PAYABLE: 96-20000229 UTILITY DEPOSITS 89,874.09 TOTAL OTHER LIABILITIES PAYABLE 89,874.09 TOTAL CURRENT LIABILITIES 90,234.36 TOTAL LIABILITIES 90,234.36 NET ASSETS CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 9,410.84 TOTAL CAPITAL ASSETS 9,410.84 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:48PM PAGE:96 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,264.97 BALANCE - CURRENT DATE 11,675.81 TOTAL NET ASSETS 11,675.81 TOTAL LIABILITIES AND NET ASSETS 101,910.17 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2023 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:48PM PAGE:97 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME 269.53 2,264.97 .00 ( 2,264.97) .0 TOTAL MISC LOCAL REVENUE 269.53 2,264.97 .00 ( 2,264.97) .0 TOTAL UTILITY DEPOSITS - REVENUE 269.53 2,264.97 .00 ( 2,264.97) .0 TOTAL FUND REVENUE 269.53 2,264.97 .00 ( 2,264.97) .0 NET REVENUE OVER EXPENDITURES 269.53 2,264.97 .00 ( 2,264.97) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2023 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2023 12:48PM 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,468,504.00 97-10000174 INVESTMENTS - RHSA 471,900.22 TOTAL INVESTMENTS 5,940,404.22 TOTAL NON-CURRENT ASSETS 5,940,404.22 TOTAL ASSETS 5,940,443.83 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 97-30000300 FUND BALANCE/BEGINNING OF YEAR 5,940,443.83 TOTAL CAPITAL ASSETS 5,940,443.83 TOTAL NET ASSETS 5,940,443.83 TOTAL LIABILITIES AND NET ASSETS 5,940,443.83