Full Text
CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2022 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 22,589,836.14 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 105,693.53 01-10000106 CASH - XPRESS DEPOSIT ACCOUNT 96,877.04 01-10000113 CASH ON HAND 575.00 TOTAL COMBINED CASH 22,792,981.71 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 22,792,981.71) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 3 ALLOCATION TO ACCOUNTS PAYABLE FUND 2,639.64 10 ALLOCATION TO GENERAL FUND 4,710,998.62 11 ALLOCATION TO IMPACT ASSISTANCE FUND 566,636.38 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 25,645.37 31 ALLOCATION TO WATER FUND 4,395,136.80 32 ALLOCATION TO SEWER FUND 176,728.55 33 ALLOCATION TO SANITATION FUND 584,367.71 34 ALLOCATION TO LANDFILL FUND 701,082.99 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 500,333.98 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 25,123.91 41 ALLOCATION TO ECONOMIC DEVELOPMENT 168,630.66 42 ALLOCATION TO BROWNFIELD GRANT ( 27,489.55) 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE 33,997.55 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 585,008.17 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 5,851.66 54 ALLOCATION TO TRAIN CAR RESTORATION 38,119.90 55 ALLOCATION TO POOL IMPROVEMENTS FUND 35,914.06 56 ALLOCATION TO STREET IMPROVEMENT FUND 6,821,503.79 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 2,252,034.99 65 ALLOCATION TO CAPTL PROJ-PARK FUND 1,155,735.17 90 ALLOCATION TO PERPETUAL CARE FUND 8,708.90 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 2.75 92 ALLOCATION TO HISTORIC CMSN FUND 21,871.24 96 ALLOCATION TO UTILITY DEPOSIT FUND 4,358.86 97 ALLOCATION TO DEFERRED COMP TRUST FUND 39.61 TOTAL ALLOCATIONS TO OTHER FUNDS 22,792,981.71 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 22,792,981.71) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS PAYABLES CLEARING FUND ALLOCATIONS JUNE 30, 2022 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:2 PAYROLL PAYABLES 03-20000215 WAGES PAYABLE - CLEARING 2,639.64 TOTAL PAYROLL PAYABLES 2,639.64 TOTAL UNALLOCATED PAYROLL PAYABLES 2,639.64 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, 2022 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:3 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 4,710,998.62 TOTAL CASH 4,710,998.62 INVESTMENTS: 10-10000120 INVESTMENT POOL 9,910,832.46 10-10000122 TIME DEPOSITS - SHORT TERM 19,121,748.02 TOTAL INVESTMENTS 29,032,580.48 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 45,131.90 10-10000131 ACCOUNTS RECEIVABLE - GENERAL 70,692.68 10-10000132 ACCOUNTS REC - PROPERTY TAX 528,320.87 10-10000133 ACCOUNTS CRT 2,767.55 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 1,309,792.36 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 626.08 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 5,877.98) 10-10000139 ACCRUED INTEREST RECEIVABLE 41,977.72 10-10000159 DUE FROM OTHER FUNDS 86,899.12 TOTAL ACCOUNTS RECEIVABLE 2,080,330.30 TOTAL CURRENT ASSETS 35,823,909.40 NON-CURRENT ASSETS: INVESTMENTS: 10-10000170 PREPAID EXPENSE 29,630.00 10-10000172 TIME DEPOSITS - EOY 27,502.60 TOTAL INVESTMENTS 57,132.60 TOTAL NON-CURRENT ASSETS 57,132.60 TOTAL ASSETS 35,881,042.00 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:4 ACCOUNTS PAYABLE: 10-20000200 DEFERRED INFLOW 476,366.90 10-20000201 ALLOCATION FROM AP FUND 498,710.28 10-20000204 ACCOUNTS PAYABLE - EOY ( 86,676.15) 10-20000208 SURCHARGE PAYABLE 1,210.00 10-20000212 SURCHARGE - CITY - E CITATION 2,575.00 10-20000213 DONATION-POLICE DEPARTMENT USE 1,085.65 10-20000215 WAGES PAYABLE 124,954.64 10-20000216 WAGES PAYABLE - EOY 23,554.58 TOTAL ACCOUNTS PAYABLE 1,041,780.90 PAYROLL DEDUCTIONS PAYABLE: 10-20000222 FEDERAL WITHOLDING PAYABLE 630.71 10-20000223 FICA PAYABLE 3,421.08 10-20000224 DEFERRED COMPENSATION PAYABLE 53,567.52 10-20000225 INSURANCE PAYABLE 193.86 10-20000226 OTHER DEDUCTIONS PAYABLE 652.42 10-20000227 WORKERS COMP INS PAYABLE 25,781.98 TOTAL PAYROLL DEDUCTIONS PAYABLE 84,247.57 OTHER LIABILITIES PAYABLE: 10-20000228 UNCLAIMED PROPERTY 17,737.46 TOTAL OTHER LIABILITIES PAYABLE 17,737.46 DUE TO OTHER FUNDS: 10-20000245 DUE TO OTHER FUNDS 75,881.88 TOTAL DUE TO OTHER FUNDS 75,881.88 DEFERRED REVENUE: 10-20000300 DEFERRED REVENUE 551,880.73 TOTAL DEFERRED REVENUE 551,880.73 TOTAL CURRENT LIABILITIES 1,771,528.54 TOTAL LIABILITIES 1,771,528.54 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 30,353,233.21 10-30000301 FUND BALANCE RESERVE 3,470,000.00 TOTAL CAPITAL ASSETS 33,823,233.21 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:5 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 286,280.25 BALANCE - CURRENT DATE 34,109,513.46 TOTAL NET ASSETS 34,109,513.46 TOTAL LIABILITIES AND NET ASSETS 35,881,042.00 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:6 GENERAL - REVENUE REVENUE: 10-4100-0160 GAIN ON INVESTMENTS ( 63,388.48) ( 371,345.78) .00 371,345.78 .0 TOTAL REVENUE ( 63,388.48) ( 371,345.78) .00 371,345.78 .0 MISC LOCAL REVENUE: 10-4100-1101 REIMBURSEMENT - CCSD .00 61,902.99 61,109.00 ( 793.99) 101.3 10-4100-1107 OTHER 634.27 47,335.67 51,350.00 4,014.33 92.2 10-4100-1108 COPY FEES/VIN CHECKS 695.00 6,014.21 5,000.00 ( 1,014.21) 120.3 10-4100-1109 REIMBURSEMENTS 10,534.45 85,492.36 100,000.00 14,507.64 85.5 10-4100-1112 CONTRIBUTIONS 14,992.94 14,992.94 14,992.00 ( .94) 100.0 10-4100-1115 LEASES/RENT 850.00 6,625.00 4,500.00 ( 2,125.00) 147.2 10-4100-1120 FINES/FORFEITS 3,107.00 26,970.00 25,000.00 ( 1,970.00) 107.9 10-4100-1140 INTEREST INCOME 27,748.83 536,818.65 400,000.00 ( 136,818.65) 134.2 10-4100-1145 GAIN ON SALE OF FIXED ASSETS 4,049.99 33,931.99 .00 ( 33,931.99) .0 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 15,532.26 3,500.00 ( 12,032.26) 443.8 TOTAL MISC LOCAL REVENUE 62,612.48 835,616.07 665,451.00 ( 170,165.07) 125.6 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 300.00 20,240.00 20,000.00 ( 240.00) 101.2 TOTAL LIQUOR LICENSES 300.00 20,240.00 20,000.00 ( 240.00) 101.2 CONTRACTORS LICENSES: 10-4100-1241 LICENSES - CONTRACTORS 204.90 15,980.90 15,000.00 ( 980.90) 106.5 TOTAL CONTRACTORS LICENSES 204.90 15,980.90 15,000.00 ( 980.90) 106.5 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 2,845.76 23,545.54 30,000.00 6,454.46 78.5 TOTAL BUILDING PERMITS 2,845.76 23,545.54 30,000.00 6,454.46 78.5 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 335.00 1,890.00 2,500.00 610.00 75.6 TOTAL ZONING/CONDITIONAL USE 335.00 1,890.00 2,500.00 610.00 75.6 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 91,376.65 471,185.39 450,000.00 ( 21,185.39) 104.7 10-4100-1321 PROPERTY TAX - PRIOR YEARS 363.03 3,717.88 1,000.00 ( 2,717.88) 371.8 10-4100-1322 PROPERTY TAX - AUTO 15,687.22 189,278.89 170,000.00 ( 19,278.89) 111.3 10-4100-1323 PROPERTY TAX - INTEREST 192.58 1,536.52 1,000.00 ( 536.52) 153.7 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 538.05) ( 3,328.04) ( 2,500.00) 828.04 ( 133.1) TOTAL PROPERTY TAXES 107,081.43 662,390.64 619,500.00 ( 42,890.64) 106.9 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:7 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 16,882.23 222,639.80 225,000.00 2,360.20 99.0 10-4100-1331 FRANCHISE FEES - CABLE TV .00 11,305.62 14,000.00 2,694.38 80.8 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 33,556.24 35,000.00 1,443.76 95.9 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 7,045.95 6,500.00 ( 545.95) 108.4 TOTAL FRANCHISE FEES 16,882.23 274,547.61 280,500.00 5,952.39 97.9 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 57,361.50 114,723.00 82,019.00 ( 32,704.00) 139.9 10-4100-1421 MANAGEMENT FEES - WATER 131,931.50 263,863.00 229,654.00 ( 34,209.00) 114.9 10-4100-1422 MANAGEMENT FEES - SEWER 78,587.00 157,174.00 155,836.00 ( 1,338.00) 100.9 10-4100-1423 MANAGEMENT FEES - SANITATION 41,009.50 82,019.00 82,019.00 .00 100.0 TOTAL MANAGEMENT FEES 308,889.50 617,779.00 549,528.00 ( 68,251.00) 112.4 WEED ABATEMENT: 10-4100-1430 WEED MOWING CHARGES .00 619.60 .00 ( 619.60) .0 10-4100-1431 PEST CONTROL .00 14,700.30 14,000.00 ( 700.30) 105.0 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 34,717.83 35,000.00 282.17 99.2 TOTAL WEED ABATEMENT .00 50,037.73 49,000.00 ( 1,037.73) 102.1 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 2,400.00 23,700.00 15,000.00 ( 8,700.00) 158.0 TOTAL BURIAL FEES 2,400.00 23,700.00 15,000.00 ( 8,700.00) 158.0 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 1,000.00 7,600.00 7,500.00 ( 100.00) 101.3 TOTAL LOT SALES 1,000.00 7,600.00 7,500.00 ( 100.00) 101.3 POOL: 10-4100-1650 POOL - USER FEES .00 28,991.80 15,000.00 ( 13,991.80) 193.3 TOTAL POOL .00 28,991.80 15,000.00 ( 13,991.80) 193.3 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 200,159.46 200,490.00 330.54 99.8 10-4100-3111 SEVERENCE TAX - 2% 57,468.21 229,872.84 200,000.00 ( 29,872.84) 114.9 10-4100-3112 MINERAL ROYALTIES 76,968.10 322,872.40 275,000.00 ( 47,872.40) 117.4 TOTAL MINERAL EXTRACTION 134,436.31 752,904.70 675,490.00 ( 77,414.70) 111.5 SALES TAX: 10-4100-3241 SALES TAX - STATE 693,364.32 5,908,596.66 4,000,000.00 ( 1,908,596.66) 147.7 10-4100-3245 SALES TAX - LOCAL OPTION 565,725.95 4,843,771.16 3,500,000.00 ( 1,343,771.16) 138.4 TOTAL SALES TAX 1,259,090.27 10,752,367.82 7,500,000.00 ( 3,252,367.82) 143.4 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:8 GAS TAX: 10-4100-3250 LOTTERY 61,580.05 103,922.21 45,000.00 ( 58,922.21) 230.9 10-4100-3257 GAS TAX 19,662.18 265,577.15 225,000.00 ( 40,577.15) 118.0 10-4100-3258 SPECIAL FUELS 5,200.03 66,802.46 60,000.00 ( 6,802.46) 111.3 TOTAL GAS TAX 86,442.26 436,301.82 330,000.00 ( 106,301.82) 132.2 OTHER: 10-4100-3262 CIGARETTE TAX 3,537.13 43,872.62 50,000.00 6,127.38 87.8 TOTAL OTHER 3,537.13 43,872.62 50,000.00 6,127.38 87.8 STATE REVENUE: 10-4100-3374 SLIB 63,323.44 507,055.00 21,352.00 ( 485,703.00) 2374.7 TOTAL STATE REVENUE 63,323.44 507,055.00 21,352.00 ( 485,703.00) 2374.7 FEDERAL REVENUE SOURCES: 10-4100-4288 ARPA FUNDS 553,236.31 553,236.31 .00 ( 553,236.31) .0 TOTAL FEDERAL REVENUE SOURCES 553,236.31 553,236.31 .00 ( 553,236.31) .0 TOTAL GENERAL - REVENUE 2,539,228.54 15,236,711.78 10,845,821.00 ( 4,390,890.78) 140.5 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 696.09 1,659.04 1,000.00 ( 659.04) 165.9 TOTAL OPERATING TRANSFERS IN 696.09 1,659.04 1,000.00 ( 659.04) 165.9 TOTAL OPERATING TRANSFERS - IN 696.09 1,659.04 1,000.00 ( 659.04) 165.9 TOTAL FUND REVENUE 2,539,924.63 15,238,370.82 10,846,821.00 ( 4,391,549.82) 140.5 GENERAL GOVT - NON DEPARTMENTL CASH FUND APPROPRIATION: 10-5100-0150 REPLACEMENT RESERVE 150,000.00 300,000.00 300,000.00 .00 100.0 TOTAL CASH FUND APPROP 150,000.00 300,000.00 300,000.00 .00 100.0 EMPLOYEE BENEFITS: 10-5100-1021 EMPLOYEE BENEFITS - SCL 3.82 48.91 50.00 1.09 97.8 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 180.00 5,309.64 2,750.00 ( 2,559.64) 193.1 TOTAL EMPLOYEE BENEFITS 183.82 5,358.55 2,800.00 ( 2,558.55) 191.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:9 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT 29.39 6,648.85 6,000.00 ( 648.85) 110.8 10-5100-2115 PUBLISHING/ADVERTISING 4,926.00 28,995.80 35,000.00 6,004.20 82.9 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 201.60 231.60 500.00 268.40 46.3 10-5100-2122 TRAINING/DEVELOPMENT .00 .00 5,000.00 5,000.00 .0 TOTAL PURCHASED SERVICES 5,156.99 35,876.25 46,500.00 10,623.75 77.2 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 13,132.50 80,776.99 75,000.00 ( 5,776.99) 107.7 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 721.93 2,835.47 3,000.00 164.53 94.5 10-5100-2133 UTILITY SERVICES - NATURAL GAS 368.66 3,970.16 3,000.00 ( 970.16) 132.3 10-5100-2134 TELECOMMUNICATIONS 203.19 11,267.52 9,000.00 ( 2,267.52) 125.2 10-5100-2141 EQUIPMENT - RENT .00 192.00 250.00 58.00 76.8 TOTAL PROPERTY SERVICES 14,426.28 99,042.14 90,250.00 ( 8,792.14) 109.7 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 3,132.00 28,254.00 50,000.00 21,746.00 56.5 10-5100-2152 ACCOUNTING/AUDITING .00 47,750.00 55,000.00 7,250.00 86.8 10-5100-2155 REPAIRS/MAINTENANCE 3,021.95 27,088.49 5,000.00 ( 22,088.49) 541.8 10-5100-2156 MAINTENANCE AGREEMENT 313.66 10,778.09 11,000.00 221.91 98.0 10-5100-2157 INSURANCE .00 92,230.50 86,000.00 ( 6,230.50) 107.2 10-5100-2158 MISC CONTRACTUAL SERVICES 3,860.92 50,209.76 94,452.00 44,242.24 53.2 10-5100-2166 COLLECTION FEES .00 .00 100.00 100.00 .0 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE 136.91 936.91 250.00 ( 686.91) 374.8 TOTAL PROFESSIONAL SERVICES 10,465.44 257,247.75 301,802.00 44,554.25 85.2 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 1,819.36 10,731.93 12,000.00 1,268.07 89.4 10-5100-3210 OPERATING SUPPLIES 219.16 9,350.90 15,000.00 5,649.10 62.3 10-5100-3230 REFRESHMENT SUPPLIES .00 863.37 .00 ( 863.37) .0 10-5100-3235 FUEL 21,965.53 131,466.79 100,000.00 ( 31,466.79) 131.5 TOTAL SUPPLIES 24,004.05 152,412.99 127,000.00 ( 25,412.99) 120.0 OPERATING TRANSFERS: 10-5100-4345 INVESTMENT FEES 697.18 6,333.41 5,000.00 ( 1,333.41) 126.7 TOTAL OPERATING TRANSFERS 697.18 6,333.41 5,000.00 ( 1,333.41) 126.7 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 TOTAL GENERAL GOVT - NON DEPARTMENTL 204,933.76 856,271.09 879,352.00 23,080.91 97.4 GENERAL GOVT - CITY COUNCIL ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:10 PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 1,500.00 18,000.00 18,000.00 .00 100.0 TOTAL PERSONNEL SERVICES 1,500.00 18,000.00 18,000.00 .00 100.0 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 114.77 1,377.24 1,377.00 ( .24) 100.0 10-5101-1025 EMPLOYEE BENEFITS - COMP 35.10 458.60 462.00 3.40 99.3 TOTAL EMPLOYEE BENEFITS 149.87 1,835.84 1,839.00 3.16 99.8 PURCHASED SERVICES: 10-5101-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 8,099.28 8,000.00 ( 99.28) 101.2 10-5101-2122 TRAINING/DEVELOPMENT 240.00 240.00 7,500.00 7,260.00 3.2 10-5101-2123 MEALS/LODGING/TRAVEL 593.25 1,324.00 2,500.00 1,176.00 53.0 TOTAL PURCHASED SERVICES 833.25 9,663.28 18,000.00 8,336.72 53.7 SUPPLIES: 10-5101-3210 OPERATING SUPPLIES .00 .00 500.00 500.00 .0 TOTAL SUPPLIES .00 .00 500.00 500.00 .0 TOTAL GENERAL GOVT - CITY COUNCIL 2,483.12 29,499.12 38,339.00 8,839.88 76.9 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 31,565.85 344,935.89 354,748.00 9,812.11 97.2 10-5102-1002 SALARIES/WAGES - OVERTIME .00 19.84 1,500.00 1,480.16 1.3 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,107.80 1,108.00 .20 100.0 10-5102-1006 SALARIES/WAGES - ALLOWANCES 175.00 12,924.47 1,800.00 ( 11,124.47) 718.0 10-5102-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 665.60 1,100.00 434.40 60.5 TOTAL PERSONNEL SERVICES 31,740.85 359,653.60 360,256.00 602.40 99.8 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,472.08 27,155.76 28,050.00 894.24 96.8 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 11,249.60 126,750.14 130,734.00 3,983.86 97.0 10-5102-1025 EMPLOYEE BENEFITS - COMP 860.40 9,884.50 10,236.00 351.50 96.6 10-5102-1026 EMPLOYEE BENEFITS - COMP 574.11 6,607.27 6,413.00 ( 194.27) 103.0 10-5102-1029 EMPLOYEE BENEFITS - WY 5,576.79 58,988.16 61,275.00 2,286.84 96.3 TOTAL EMPLOYEE BENEFITS 20,732.98 229,385.83 236,708.00 7,322.17 96.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:11 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 739.00 2,000.00 1,261.00 37.0 10-5102-2122 TRAINING/DEVELOPMENT 1,000.00 3,123.00 3,600.00 477.00 86.8 10-5102-2123 MEALS/LODGING/TRAVEL 925.08 3,124.62 5,500.00 2,375.38 56.8 TOTAL PURCHASED SERVICES 1,925.08 6,986.62 11,100.00 4,113.38 62.9 PROFESSIONAL SERVICES: 10-5102-2158 MISC CONTRACTUAL SERVICES .00 6,886.36 .00 ( 6,886.36) .0 TOTAL PROFESSIONAL SERVICES .00 6,886.36 .00 ( 6,886.36) .0 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 550.06 250.00 ( 300.06) 220.0 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 189.99 536.21 1,000.00 463.79 53.6 TOTAL SUPPLIES 189.99 1,086.27 1,250.00 163.73 86.9 TOTAL GENERAL GOVT - ADMIN SERVICES 54,588.90 603,998.68 609,314.00 5,315.32 99.1 GENERAL GOVT - IT PERSONNEL SERVICES: 10-5103-1001 SALARIES/WAGES - REGULAR .00 91,319.16 81,313.00 ( 10,006.16) 112.3 10-5103-1005 SALARIES/WAGES - LONGEVITY .00 461.18 461.00 ( .18) 100.0 10-5103-1006 SALARIES/WAGES - ALLOWANCES .00 600.00 900.00 300.00 66.7 10-5103-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 790.40 1,626.00 835.60 48.6 TOTAL PERSONNEL SERVICES .00 93,170.74 84,300.00 ( 8,870.74) 110.5 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL .00 7,197.16 6,352.00 ( 845.16) 113.3 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS .00 15,193.29 26,030.00 10,836.71 58.4 10-5103-1025 EMPLOYEE BENEFITS - COMP .00 2,665.62 2,366.00 ( 299.62) 112.7 10-5103-1029 EMPLOYEE BENEFITS - WY .00 10,327.88 13,986.00 3,658.12 73.8 TOTAL EMPLOYEE BENEFITS .00 35,383.95 48,734.00 13,350.05 72.6 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,370.00 2,500.00 1,130.00 54.8 TOTAL PURCHASED SERVICES .00 1,370.00 2,500.00 1,130.00 54.8 PROFESSIONAL SERVICES: 10-5103-2156 MAINTENANCE AGREEMENT 886.73 26,836.71 34,100.00 7,263.29 78.7 10-5103-2158 MISC CONTRACTUAL SERVICES 5,250.00 39,732.82 53,300.00 13,567.18 74.6 TOTAL PROFESSIONAL SERVICES 6,136.73 66,569.53 87,400.00 20,830.47 76.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:12 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 .00 800.00 800.00 .0 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 601.62 9,770.80 59,000.00 49,229.20 16.6 TOTAL SUPPLIES 601.62 9,770.80 59,800.00 50,029.20 16.3 TOTAL GENERAL GOVT - IT 6,738.35 206,265.02 282,734.00 76,468.98 73.0 GENERAL GOVT - MUNICIPAL COURT PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 3,871.08 49,107.56 50,016.00 908.44 98.2 10-5105-1002 SALARIES/WAGES - OVERTIME .00 37.45 .00 ( 37.45) .0 10-5105-1005 SALARIES/WAGES - LONGEVITY .00 462.83 463.00 .17 100.0 10-5105-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 780.00 780.00 .00 100.0 TOTAL PERSONNEL SERVICES 3,871.08 50,387.84 51,259.00 871.16 98.3 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 304.30 3,960.89 3,921.00 ( 39.89) 101.0 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS 633.86 7,606.32 7,574.00 ( 32.32) 100.4 10-5105-1025 EMPLOYEE BENEFITS - COMP 103.97 1,429.61 1,425.00 ( 4.61) 100.3 10-5105-1026 EMPLOYEE BENEFITS - COMP 106.85 1,388.40 1,385.00 ( 3.40) 100.3 10-5105-1029 EMPLOYEE BENEFITS - 459.43 5,976.17 5,954.00 ( 22.17) 100.4 TOTAL EMPLOYEE BENEFITS 1,608.41 20,361.39 20,259.00 ( 102.39) 100.5 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 300.00 160.00 ( 140.00) 187.5 10-5105-2122 TRAINING/DEVELOPMENT .00 409.00 200.00 ( 209.00) 204.5 10-5105-2123 MEALS/LODGING/TRAVEL .00 .00 860.00 860.00 .0 TOTAL PURCHASED SERVICES .00 709.00 1,220.00 511.00 58.1 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 2,232.00 10,856.50 14,000.00 3,143.50 77.6 10-5105-2156 MAINTENANCE AGREEMENT .00 .00 180.00 180.00 .0 10-5105-2162 COURT SURCHARGES .00 550.00 .00 ( 550.00) .0 10-5105-2166 COLLECTION FEES .00 .00 500.00 500.00 .0 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 38.00 500.00 462.00 7.6 TOTAL PROFESSIONAL SERVICES 2,232.00 11,444.50 15,180.00 3,735.50 75.4 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES .00 118.93 500.00 381.07 23.8 10-5105-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 9,800.00 9,800.00 .00 100.0 10-5105-3233 UNIFORMS/CARE .00 .00 50.00 50.00 .0 TOTAL SUPPLIES .00 9,918.93 10,350.00 431.07 95.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:13 TOTAL GENERAL GOVT - MUNICIPAL COURT 7,711.49 92,821.66 98,268.00 5,446.34 94.5 GENERAL GOVT - PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 18,164.00 237,985.64 236,060.00 ( 1,925.64) 100.8 10-5106-1002 SALARIES/WAGES - OVERTIME .00 6.93 .00 ( 6.93) .0 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 753.11 753.00 ( .11) 100.0 10-5106-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 TOTAL PERSONNEL SERVICES 18,239.00 239,645.68 237,713.00 ( 1,932.68) 100.8 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,437.06 18,870.28 18,722.00 ( 148.28) 100.8 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 2,712.20 36,252.37 36,795.00 542.63 98.5 10-5106-1025 EMPLOYEE BENEFITS - COMP 496.92 6,807.10 6,775.00 ( 32.10) 100.5 10-5106-1026 EMPLOYEE BENEFITS - COMP 545.94 7,022.95 7,014.00 ( 8.95) 100.1 10-5106-1029 EMPLOYEE BENEFITS - WY 2,578.28 33,911.91 33,588.00 ( 323.91) 101.0 TOTAL EMPLOYEE BENEFITS 7,770.40 102,864.61 102,894.00 29.39 100.0 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 50.00 1,177.00 1,485.00 308.00 79.3 10-5106-2122 TRAINING/DEVELOPMENT .00 726.00 2,160.00 1,434.00 33.6 10-5106-2123 MEALS/LODGING/TRAVEL 707.02 707.02 3,660.00 2,952.98 19.3 TOTAL PURCHASED SERVICES 757.02 2,610.02 7,305.00 4,694.98 35.7 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 99.74 1,198.12 1,250.00 51.88 95.9 TOTAL PROPERTY SERVICES 99.74 1,198.12 1,250.00 51.88 95.9 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 3,177.50 9,998.50 10,000.00 1.50 100.0 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT 93.31 2,014.17 2,100.00 85.83 95.9 10-5106-2158 MISC CONTRACTUAL SERVICES 988.00 3,857.00 6,000.00 2,143.00 64.3 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 25.00 750.00 725.00 3.3 TOTAL PROFESSIONAL SERVICES 4,258.81 15,894.67 19,850.00 3,955.33 80.1 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 1,581.71 4,132.93 6,350.00 2,217.07 65.1 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 599.00 895.22 1,000.00 104.78 89.5 10-5106-3235 FUEL 78.18 519.67 2,000.00 1,480.33 26.0 TOTAL SUPPLIES 2,258.89 5,547.82 9,350.00 3,802.18 59.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:14 TOTAL GENERAL GOVT - 33,383.86 367,760.92 378,362.00 10,601.08 97.2 COMMUNITY SERVICE CONTRACTS GOVERNMENTAL ASSISTANCE: 10-5110-8702 COMM CLUB/GEN 10,000.00 60,000.00 60,000.00 .00 100.0 10-5110-8703 COMM RCREATN .00 30,000.00 30,000.00 .00 100.0 10-5110-8705 COMM COUNTRY 5,000.00 30,000.00 30,000.00 .00 100.0 10-5110-8707 COMM DVL 416.63 5,000.00 5,000.00 .00 100.0 10-5110-8709 COMM 1,250.00 15,000.00 15,000.00 .00 100.0 10-5110-8714 COMM ENTERPRIS 12,500.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 9,180.00 80,680.00 85,000.00 4,320.00 94.9 10-5110-8746 COMM & GIRLS 1,875.00 22,500.00 22,500.00 .00 100.0 10-5110-8750 COMM ADVOC 1,000.00 4,000.00 4,000.00 .00 100.0 10-5110-8753 COMM SRVC BLK ( 1,776.19) 7,000.00 12,000.00 5,000.00 58.3 10-5110-8757 COMM SERV-KINGS PORTION 2,271.51 20,000.00 20,000.00 .00 100.0 10-5110-8759 COMM SRVC CENTER 1,250.00 15,000.00 15,000.00 .00 100.0 TOTAL GOVERNMENTAL ASSISTANCE 66,966.95 388,180.00 397,500.00 9,320.00 97.7 TOTAL COMMUNITY SERVICE CONTRACTS 66,966.95 388,180.00 397,500.00 9,320.00 97.7 PUBLIC SERVICE CONTRACTS GOVERNMENTAL ASSISTANCE: 10-5111-8744 COMM 176,812.61 362,898.20 249,619.00 ( 113,279.20) 145.4 10-5111-8760 COMM SRVC JUSTICE 45,523.48 628,919.59 529,302.00 ( 99,617.59) 118.8 TOTAL GOVERNMENTAL ASSISTANCE 222,336.09 991,817.79 778,921.00 ( 212,896.79) 127.3 TOTAL PUBLIC SERVICE CONTRACTS 222,336.09 991,817.79 778,921.00 ( 212,896.79) 127.3 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 31,736.70 184,625.26 184,766.00 140.74 99.9 10-5201-1002 SALARIES/WAGES - OVERTIME 7.28 29.68 100.00 70.32 29.7 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 892.90 893.00 .10 100.0 10-5201-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 10-5201-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,549.60 1,550.00 .40 100.0 TOTAL PERSONNEL SERVICES 31,818.98 187,997.44 188,209.00 211.56 99.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:15 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 2,443.34 14,578.81 14,598.00 19.19 99.9 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 5,350.51 79,718.51 56,586.00 ( 23,132.51) 140.9 10-5201-1025 EMPLOYEE BENEFITS - COMP 892.30 5,950.43 5,952.00 1.57 100.0 10-5201-1026 EMPLOYEE BENEFITS - COMP 843.89 3,302.66 3,312.00 9.34 99.7 10-5201-1029 EMPLOYEE BENEFITS - WY 2,312.13 28,273.63 28,281.00 7.37 100.0 TOTAL EMPLOYEE BENEFITS 11,842.17 131,824.04 108,729.00 ( 23,095.04) 121.2 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,075.00 1,075.00 .00 100.0 10-5201-2122 TRAINING/DEVELOPMENT .00 1,494.00 680.00 ( 814.00) 219.7 10-5201-2123 MEALS/LODGING/TRAVEL .00 448.83 1,195.00 746.17 37.6 TOTAL PURCHASED SERVICES .00 3,017.83 2,950.00 ( 67.83) 102.3 PROPERTY SERVICES: 10-5201-2131 UTILITY SERVICES - ELECTRICITY 199.74 1,171.30 2,000.00 828.70 58.6 10-5201-2134 TELECOMMUNICATIONS 40.03 480.18 494.00 13.82 97.2 TOTAL PROPERTY SERVICES 239.77 1,651.48 2,494.00 842.52 66.2 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 250.00 250.00 .0 10-5201-2156 MAINTENANCE AGREEMENT 116.87 919.72 1,100.00 180.28 83.6 10-5201-2158 MISC CONTRACTUAL SERVICES 750.00 5,264.00 5,500.00 236.00 95.7 10-5201-2161 INCARCERATION CONTRACT 157.50 1,402.50 2,500.00 1,097.50 56.1 TOTAL PROFESSIONAL SERVICES 1,024.37 7,586.22 9,350.00 1,763.78 81.1 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 1,109.06 3,032.84 3,000.00 ( 32.84) 101.1 10-5201-3233 UNIFORMS/CARE .00 165.90 600.00 434.10 27.7 10-5201-3235 FUEL .00 538.70 600.00 61.30 89.8 TOTAL SUPPLIES 1,109.06 3,737.44 4,200.00 462.56 89.0 TOTAL POLICE DEPT - ADMINISTRATION 46,034.35 335,814.45 315,932.00 ( 19,882.45) 106.3 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 72,333.66 987,260.58 1,093,944.00 106,683.42 90.3 10-5202-1002 SALARIES/WAGES - OVERTIME 7,755.30 98,215.85 50,000.00 ( 48,215.85) 196.4 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 3,097.06 3,305.00 207.94 93.7 10-5202-1006 SALARIES/WAGES - ALLOWANCES 50.00 6,600.00 600.00 ( 6,000.00) 1100.0 10-5202-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 915.20 6,659.00 5,743.80 13.7 TOTAL PERSONNEL SERVICES 80,138.96 1,096,088.69 1,154,508.00 58,419.31 94.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:14PM PAGE:16 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 6,190.19 86,609.60 89,405.00 2,795.40 96.9 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 30,213.12 358,990.98 431,130.00 72,139.02 83.3 10-5202-1025 EMPLOYEE BENEFITS - COMP 2,180.46 31,759.75 32,714.00 954.25 97.1 10-5202-1026 EMPLOYEE BENEFITS - COMP 849.72 13,364.80 14,190.00 825.20 94.2 10-5202-1029 EMPLOYEE BENEFITS - WY 13,775.30 177,563.89 194,183.00 16,619.11 91.4 TOTAL EMPLOYEE BENEFITS 53,208.79 668,289.02 761,622.00 93,332.98 87.8 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 405.00 849.00 444.00 47.7 10-5202-2122 TRAINING/DEVELOPMENT 1,129.00 9,342.00 20,455.00 11,113.00 45.7 10-5202-2123 MEALS/LODGING/TRAVEL 687.00 6,286.59 15,905.00 9,618.41 39.5 TOTAL PURCHASED SERVICES 1,816.00 16,033.59 37,209.00 21,175.41 43.1 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,368.42 16,179.96 17,430.00 1,250.04 92.8 TOTAL PROPERTY SERVICES 1,368.42 16,179.96 17,430.00 1,250.04 92.8 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE .00 5,645.79 7,500.00 1,854.21 75.3 10-5202-2156 MAINTENANCE AGREEMENT 206.00 10,387.44 15,766.00 5,378.56 65.9 10-5202-2158 MISC CONTRACTUAL SERVICES 936.50 2,328.50 2,500.00 171.50 93.1 TOTAL PROFESSIONAL SERVICES 1,142.50 18,361.73 25,766.00 7,404.27 71.3 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 48.84 300.00 251.16 16.3 10-5202-3210 OPERATING SUPPLIES 3,234.71 29,170.04 30,350.00 1,179.96 96.1 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 9,122.34 10,042.00 919.66 90.8 10-5202-3233 UNIFORMS/CARE 604.29 13,474.59 19,100.00 5,625.41 70.6 10-5202-3235 FUEL 2,248.02 13,247.74 16,500.00 3,252.26 80.3 TOTAL SUPPLIES 6,087.02 65,063.55 76,292.00 11,228.45 85.3 TOTAL POLICE DEPT - PATROL 143,761.69 1,880,016.54 2,072,827.00 192,810.46 90.7 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 11,907.87 154,736.36 154,724.00 ( 12.36) 100.0 10-5301-1002 SALARIES/WAGES - OVERTIME .00 9.00 .00 ( 9.00) .0 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,305.97 1,306.00 .03 100.0 10-5301-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 10-5301-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 582.40 998.00 415.60 58.4 TOTAL PERSONNEL SERVICES 11,982.87 157,533.73 157,928.00 394.27 99.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM PAGE:17 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 919.44 12,088.93 12,109.00 20.07 99.8 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 3,046.01 36,553.37 36,637.00 83.63 99.8 10-5301-1025 EMPLOYEE BENEFITS - COMP 326.44 4,474.63 4,483.00 8.37 99.8 10-5301-1029 EMPLOYEE BENEFITS - WY 2,048.15 26,616.16 26,613.00 ( 3.16) 100.0 TOTAL EMPLOYEE BENEFITS 6,340.04 79,733.09 79,842.00 108.91 99.9 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 225.00 501.00 276.00 44.9 10-5301-2122 TRAINING/DEVELOPMENT .00 204.00 905.00 701.00 22.5 TOTAL PURCHASED SERVICES .00 429.00 1,406.00 977.00 30.5 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 1,071.75 8,538.55 10,700.00 2,161.45 79.8 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 961.36 4,875.64 5,000.00 124.36 97.5 10-5301-2133 UTILITY SERVICES - NATURAL GAS 614.72 9,308.00 9,500.00 192.00 98.0 10-5301-2134 TELECOMMUNICATIONS 65.53 600.47 500.00 ( 100.47) 120.1 TOTAL PROPERTY SERVICES 2,713.36 23,322.66 25,700.00 2,377.34 90.8 PROFESSIONAL SERVICES: 10-5301-2153 ARCHITECT/ENGINEERING/SURVEING .00 962.50 1,000.00 37.50 96.3 10-5301-2155 REPAIRS/MAINTENANCE .00 184.50 1,500.00 1,315.50 12.3 10-5301-2156 MAINTENANCE AGREEMENT 50.08 2,649.74 2,750.00 100.26 96.4 TOTAL PROFESSIONAL SERVICES 50.08 3,796.74 5,250.00 1,453.26 72.3 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 38.40 1,240.09 2,000.00 759.91 62.0 10-5301-3230 REFRESHMENT SUPPLIES .00 341.89 750.00 408.11 45.6 10-5301-3235 FUEL 59.55 542.19 1,500.00 957.81 36.2 TOTAL SUPPLIES 97.95 2,124.17 4,250.00 2,125.83 50.0 TOTAL PUBLIC WORKS - ADMINISTRATION 21,184.30 266,939.39 274,376.00 7,436.61 97.3 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 15,694.97 201,719.91 201,530.00 ( 189.91) 100.1 10-5302-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 1,303.15 1,303.00 ( .15) 100.0 10-5302-1006 SALARIES/WAGES-ALLOWANCE 50.00 600.00 600.00 .00 100.0 10-5302-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 2,403.00 2,403.00 .0 TOTAL PERSONNEL SERVICES 15,744.97 203,623.06 206,336.00 2,712.94 98.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM PAGE:18 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,257.53 16,251.82 16,504.00 252.18 98.5 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 6,022.62 72,252.97 72,027.00 ( 225.97) 100.3 10-5302-1025 EMPLOYEE BENEFITS - COMP 428.78 5,783.21 5,870.00 86.79 98.5 10-5302-1026 EMPLOYEE BENEFITS - COMP 682.14 8,627.10 8,617.00 ( 10.10) 100.1 10-5302-1029 EMPLOYEE BENEFITS - WY 2,699.54 34,695.82 34,749.00 53.18 99.9 TOTAL EMPLOYEE BENEFITS 11,090.61 137,610.92 137,767.00 156.08 99.9 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 3,190.00 4,100.00 910.00 77.8 10-5302-2122 TRAINING/DEVELOPMENT .00 .00 300.00 300.00 .0 TOTAL PURCHASED SERVICES .00 3,190.00 4,400.00 1,210.00 72.5 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 6,679.84 7,575.00 895.16 88.2 TOTAL PROFESSIONAL SERVICES .00 6,679.84 7,575.00 895.16 88.2 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 3,070.95 13,194.60 14,000.00 805.40 94.3 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 2,084.88 11,999.58 12,500.00 500.42 96.0 10-5302-3235 FUEL 241.38 1,317.36 2,000.00 682.64 65.9 10-5302-3237 OIL/LUBE/FLUIDS 2,280.00 51,184.63 12,500.00 ( 38,684.63) 409.5 TOTAL SUPPLIES 7,677.21 77,696.17 41,000.00 ( 36,696.17) 189.5 TOTAL PUBLIC WORKS - SHOP 34,512.79 428,799.99 397,278.00 ( 31,521.99) 107.9 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 17,053.85 219,341.71 219,138.00 ( 203.71) 100.1 10-5304-1002 SALARIES/WAGES - OVERTIME 130.37 745.70 5,000.00 4,254.30 14.9 10-5304-1004 SALARIES/WAGES - TEMPORARY 6,426.60 19,948.28 59,640.00 39,691.72 33.5 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 895.63 896.00 .37 100.0 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5304-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 702.00 702.00 .0 TOTAL PERSONNEL SERVICES 23,635.82 241,231.32 285,676.00 44,444.68 84.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM PAGE:19 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 1,812.51 18,486.36 21,655.00 3,168.64 85.4 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 9,730.45 116,757.22 116,502.00 ( 255.22) 100.2 10-5304-1025 EMPLOYEE BENEFITS - COMP 642.97 6,844.45 8,047.00 1,202.55 85.1 10-5304-1026 EMPLOYEE BENEFITS - COMP 27.02 27.02 .00 ( 27.02) .0 10-5304-1029 EMPLOYEE BENEFITS - WY 2,955.69 37,855.10 38,036.00 180.90 99.5 TOTAL EMPLOYEE BENEFITS 15,168.64 179,970.15 184,240.00 4,269.85 97.7 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 30.00 324.92 550.00 225.08 59.1 10-5304-2122 TRAINING/DEVELOPMENT 230.00 1,585.00 940.00 ( 645.00) 168.6 10-5304-2123 MEALS/LODGING/TRAVEL .00 .00 1,145.00 1,145.00 .0 TOTAL PURCHASED SERVICES 260.00 1,909.92 2,635.00 725.08 72.5 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 3,819.49 19,704.99 18,000.00 ( 1,704.99) 109.5 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 24,233.44 90,471.17 90,000.00 ( 471.17) 100.5 10-5304-2141 EQUIPMENT - RENT .00 75.00 1,000.00 925.00 7.5 TOTAL PROPERTY SERVICES 28,052.93 110,251.16 109,000.00 ( 1,251.16) 101.2 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE .00 3,517.87 5,000.00 1,482.13 70.4 10-5304-2156 MAINTENANCE AGREEMENT .00 1,175.00 1,250.00 75.00 94.0 10-5304-2158 MISC CONTRACTUAL SERVICES 500.00 17,960.00 25,000.00 7,040.00 71.8 TOTAL PROFESSIONAL SERVICES 500.00 22,652.87 31,250.00 8,597.13 72.5 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 14,101.45 43,020.53 45,000.00 1,979.47 95.6 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 969.92 1,000.00 30.08 97.0 10-5304-3235 FUEL 1,012.94 5,216.14 10,000.00 4,783.86 52.2 TOTAL SUPPLIES 15,114.39 49,206.59 56,000.00 6,793.41 87.9 TOTAL PUBLIC WORKS - PARKS 82,731.78 605,222.01 668,801.00 63,578.99 90.5 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 21,386.44 273,611.82 272,677.00 ( 934.82) 100.3 10-5305-1002 SALARIES/WAGES - OVERTIME .00 2,475.22 4,000.00 1,524.78 61.9 10-5305-1004 SALARIES/WAGES - TEMPORARY .00 .00 11,928.00 11,928.00 .0 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 1,518.59 1,519.00 .41 100.0 10-5305-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5305-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,456.00 1,880.00 424.00 77.5 TOTAL PERSONNEL SERVICES 21,411.44 279,361.63 292,304.00 12,942.37 95.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM PAGE:20 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,644.87 21,460.50 22,450.00 989.50 95.6 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 8,440.71 101,257.16 101,004.00 ( 253.16) 100.3 10-5305-1025 EMPLOYEE BENEFITS - COMP 583.15 7,934.45 7,972.00 37.55 99.5 10-5305-1026 EMPLOYEE BENEFITS - COMP 59.58 774.54 774.00 ( .54) 100.1 10-5305-1029 EMPLOYEE BENEFITS - WY 3,678.45 47,464.20 47,588.00 123.80 99.7 TOTAL EMPLOYEE BENEFITS 14,406.76 178,890.85 179,788.00 897.15 99.5 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT .00 475.00 790.00 315.00 60.1 TOTAL PURCHASED SERVICES .00 475.00 790.00 315.00 60.1 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 3,652.34 21,249.06 60,000.00 38,750.94 35.4 10-5305-2158 MISC CONTRACTUAL SERVICES 31,414.20 42,182.05 48,200.00 6,017.95 87.5 TOTAL PROFESSIONAL SERVICES 35,066.54 63,431.11 108,200.00 44,768.89 58.6 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 4,499.25 72,643.56 71,900.00 ( 743.56) 101.0 10-5305-3235 FUEL 1,984.28 13,519.70 25,000.00 11,480.30 54.1 TOTAL SUPPLIES 6,483.53 86,163.26 96,900.00 10,736.74 88.9 TOTAL PUBLIC WORKS - STREETS/ALLEYS 77,368.27 608,321.85 677,982.00 69,660.15 89.7 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 10,989.23 139,677.02 140,021.00 343.98 99.8 10-5306-1002 SALARIES/WAGES - OVERTIME 431.77 1,852.53 1,500.00 ( 352.53) 123.5 10-5306-1004 SALARIES/WAGES - TEMPORARY .00 2,866.70 11,928.00 9,061.30 24.0 10-5306-1005 SALARIES/WAGES - LONGEVITY .00 1,101.08 1,101.00 ( .08) 100.0 10-5306-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5306-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,081.60 2,800.00 1,718.40 38.6 TOTAL PERSONNEL SERVICES 11,446.00 146,878.93 157,650.00 10,771.07 93.2 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 883.96 11,317.19 12,166.00 848.81 93.0 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 5,411.82 64,941.87 64,802.00 ( 139.87) 100.2 10-5306-1025 EMPLOYEE BENEFITS - COMP 312.12 4,172.04 4,424.00 251.96 94.3 10-5306-1026 EMPLOYEE BENEFITS - COMP 107.61 1,009.54 998.00 ( 11.54) 101.2 10-5306-1029 EMPLOYEE BENEFITS - WY 1,964.40 24,342.92 24,342.00 ( .92) 100.0 TOTAL EMPLOYEE BENEFITS 8,679.91 105,783.56 106,732.00 948.44 99.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM PAGE:21 PURCHASED SERVICES: 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 100.00 100.00 .00 100.0 10-5306-2122 TRAINING/DEVELOPMENT .00 300.00 300.00 .00 100.0 TOTAL PURCHASED SERVICES .00 400.00 400.00 .00 100.0 PROPERTY SERVICES: 10-5306-2131 UTILITY SERVICES - ELECTRICITY 361.01 2,757.88 3,000.00 242.12 91.9 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 14,316.98 54,012.73 52,500.00 ( 1,512.73) 102.9 10-5306-2133 UTILITY SERVICES - NATURAL GAS 127.20 1,494.08 1,500.00 5.92 99.6 10-5306-2134 TELECOMMUNICATIONS 49.43 606.91 1,000.00 393.09 60.7 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 14,854.62 58,871.60 58,200.00 ( 671.60) 101.2 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE .00 299.00 1,500.00 1,201.00 19.9 10-5306-2156 MAINTENANCE AGREEMENT .00 905.00 1,000.00 95.00 90.5 10-5306-2158 MISC CONTRACTUAL SERVICES .00 7,435.00 7,000.00 ( 435.00) 106.2 TOTAL PROFESSIONAL SERVICES .00 8,639.00 9,500.00 861.00 90.9 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 2,307.32 8,386.16 10,000.00 1,613.84 83.9 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 668.89 1,000.00 331.11 66.9 10-5306-3235 FUEL 224.17 1,314.86 2,500.00 1,185.14 52.6 TOTAL SUPPLIES 2,531.49 10,369.91 13,500.00 3,130.09 76.8 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND .00 250.00 1,000.00 750.00 25.0 TOTAL CAPITALIZED EXPENDITURES .00 250.00 1,000.00 750.00 25.0 TOTAL PUBLIC WORKS - CEMETERY 37,512.02 331,193.00 346,982.00 15,789.00 95.5 PUBLIC WORKS - SWIM POOL PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 1,333.19 6,532.54 7,000.00 467.46 93.3 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 4,174.98 12,718.62 13,000.00 281.38 97.8 10-5307-2133 UTILITY SERVICES - NATURAL GAS 7,206.27 11,572.47 6,000.00 ( 5,572.47) 192.9 10-5307-2134 TELECOMMUNICATIONS 565.83 971.53 1,500.00 528.47 64.8 TOTAL PROPERTY SERVICES 13,280.27 31,795.16 27,500.00 ( 4,295.16) 115.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM PAGE:22 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE 4,651.68 4,651.68 5,000.00 348.32 93.0 10-5307-2158 MISC CONTRACTUAL SERVICES .00 103,986.46 123,535.00 19,548.54 84.2 TOTAL PROFESSIONAL SERVICES 4,651.68 108,638.14 128,535.00 19,896.86 84.5 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 3,240.54 12,418.04 10,000.00 ( 2,418.04) 124.2 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 326.72 575.72 2,500.00 1,924.28 23.0 TOTAL SUPPLIES 3,567.26 12,993.76 12,500.00 ( 493.76) 104.0 TOTAL PUBLIC WORKS - SWIM POOL 21,499.21 153,427.06 168,535.00 15,107.94 91.0 OPERATING TRANSFERS - OUT OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE .00 .00 53,662.00 53,662.00 .0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ 800.00 800.00 10,571.00 9,771.00 7.6 10-5998-4339 TRANSFER TO HEALTH INS RESERVE 50,000.00 100,000.00 100,000.00 .00 100.0 10-5998-4350 TRANSFER TO FIRE EQUIPMENT 50,000.00 100,000.00 100,000.00 .00 100.0 10-5998-4353 TRANSFER TO CLG GRANT 2,150.00 4,300.00 4,300.00 .00 100.0 10-5998-4354 TRANSFER TO TRAIN CAR RESTORAT 12,500.00 25,000.00 25,000.00 .00 100.0 10-5998-4355 TRANSFER TO POOL IMPROVEMENT 81,250.00 162,500.00 162,500.00 .00 100.0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT 2,950,000.00 5,900,000.00 5,900,000.00 .00 100.0 10-5998-4357 TRANSFER TO PUBLIC FACILITIES 109,000.00 218,000.00 218,000.00 .00 100.0 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS 175,092.00 291,342.00 291,342.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 1,900.00 3,800.00 3,800.00 .00 100.0 TOTAL OPERATING TRANSFERS 3,432,692.00 6,805,742.00 6,869,175.00 63,433.00 99.1 TOTAL OPERATING TRANSFERS - OUT 3,432,692.00 6,805,742.00 6,869,175.00 63,433.00 99.1 TOTAL FUND EXPENDITURES 4,496,438.93 14,952,090.57 15,254,678.00 302,587.43 98.0 NET REVENUE OVER EXPENDITURES ( 1,956,514.30) 286,280.25 ( 4,407,857.00) ( 4,694,137.25) 6.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM 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,010,033.42 TOTAL INVESTMENTS 1,010,033.42 ACCOUNTS RECEIVABLE: 11-10000139 ACCRUED INTEREST RECEIVABLE 499.49 TOTAL ACCOUNTS RECEIVABLE 499.49 TOTAL CURRENT ASSETS 1,577,169.29 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,577,169.29 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 11-30000300 FUND BALANCE/BEGINNING OF YEAR ( 1,051,496.79) 11-30000301 RESERVE FOR 4TH STREET PROJECT 2,622,126.12 TOTAL CAPITAL ASSETS 1,570,629.33 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 6,539.96 BALANCE - CURRENT DATE 1,577,169.29 TOTAL NET ASSETS 1,577,169.29 TOTAL LIABILITIES AND NET ASSETS 1,577,169.29 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 IMPACT ASSISTANCE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:15PM PAGE:24 IMPACT ASSISTANCE - REVENUE MISC LOCAL REVENUE: 11-4110-1140 INTEREST INCOME 1,525.19 6,539.96 5,000.00 ( 1,539.96) 130.8 TOTAL MISC LOCAL REVENUE 1,525.19 6,539.96 5,000.00 ( 1,539.96) 130.8 TOTAL IMPACT ASSISTANCE - REVENUE 1,525.19 6,539.96 5,000.00 ( 1,539.96) 130.8 TOTAL FUND REVENUE 1,525.19 6,539.96 5,000.00 ( 1,539.96) 130.8 NET REVENUE OVER EXPENDITURES 1,525.19 6,539.96 5,000.00 ( 1,539.96) 130.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:23PM PAGE:25 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 25,645.37 TOTAL CASH 25,645.37 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 823.40 TOTAL ACCOUNTS RECEIVABLE 823.40 TOTAL CURRENT ASSETS 26,468.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 26,468.77 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 482.38 TOTAL ACCOUNTS PAYABLE 482.38 TOTAL CURRENT LIABILITIES 482.38 TOTAL LIABILITIES 482.38 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 24,621.82 TOTAL CAPITAL ASSETS 24,621.82 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,364.57 BALANCE - CURRENT DATE 25,986.39 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:23PM PAGE:26 TOTAL NET ASSETS 25,986.39 TOTAL LIABILITIES AND NET ASSETS 26,468.77 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:24PM PAGE:27 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 823.40 3,193.89 11,730.00 8,536.11 27.2 TOTAL FEDERAL REVENUE SOURCES 823.40 3,193.89 11,730.00 8,536.11 27.2 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 823.40 3,193.89 11,730.00 8,536.11 27.2 SRO PROGRAM - REVENUE FEDERAL REVENUE SOURCES: 13-4830-4283 FED BUREAU JUSTICE ADMIN - SRO .00 .00 125,000.00 125,000.00 .0 TOTAL FEDERAL REVENUE SOURCES .00 .00 125,000.00 125,000.00 .0 TOTAL SRO PROGRAM - REVENUE .00 .00 125,000.00 125,000.00 .0 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 2,898.74 6,778.56 8,253.00 1,474.44 82.1 TOTAL STATE REVENUE 2,898.74 6,778.56 8,253.00 1,474.44 82.1 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE 2,898.74 6,778.56 8,253.00 1,474.44 82.1 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 800.00 1,425.00 625.00 56.1 TOTAL FEDERAL REVENUE SOURCES .00 800.00 1,425.00 625.00 56.1 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND 800.00 800.00 1,425.00 625.00 56.1 TOTAL TRANSFERS IN 800.00 800.00 1,425.00 625.00 56.1 TOTAL BULLET PROOF VEST - REVENUE 800.00 1,600.00 2,850.00 1,250.00 56.1 DEPT OF JUSTICE-BODY CAMS ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:24PM PAGE:28 FEDERAL REVENUE SOURCES: 13-4898-4288 WY DEPT OF HOMELAND SECURITY .00 .00 46,000.00 46,000.00 .0 13-4898-4292 US DEPARTMENT OF JUSTICE .00 .00 38,000.00 38,000.00 .0 TOTAL FEDERAL REVENUE SOURCES .00 .00 84,000.00 84,000.00 .0 TRANSFERS IN: 13-4898-5510 TRANSFER FROM GENERAL FUND .00 .00 9,146.00 9,146.00 .0 TOTAL TRANSFERS IN .00 .00 9,146.00 9,146.00 .0 TOTAL DEPT OF JUSTICE-BODY CAMS .00 .00 93,146.00 93,146.00 .0 TOTAL FUND REVENUE 4,522.14 11,572.45 240,979.00 229,406.55 4.8 ASSET SEIZURE SUPPLIES: 13-5130-3210 OPERATING SUPPLIES 388.98 388.98 1,255.00 866.02 31.0 TOTAL SUPPLIES 388.98 388.98 1,255.00 866.02 31.0 TOTAL ASSET SEIZURE 388.98 388.98 1,255.00 866.02 31.0 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR 338.47 1,961.98 7,995.00 6,033.02 24.5 TOTAL PERSONNEL SERVICES 338.47 1,961.98 7,995.00 6,033.02 24.5 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL 25.83 149.79 612.00 462.21 24.5 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS 42.07 460.88 1,500.00 1,039.12 30.7 13-5821-1025 EMPLOYEE BENEFITS - COMP 9.41 55.67 247.00 191.33 22.5 13-5821-1029 EMPLOYEE BENEFITS - WY 58.22 337.48 1,376.00 1,038.52 24.5 TOTAL EMPLOYEE BENEFITS 135.53 1,003.82 3,735.00 2,731.18 26.9 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE 474.00 2,965.80 11,730.00 8,764.20 25.3 SCHOOL RESOURCE OFFICER ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:25PM PAGE:29 PERSONNEL SERVICES: 13-5830-1001 SALARIES/WAGES - REGULAR .00 .00 125,000.00 125,000.00 .0 TOTAL PERSONNEL SERVICES .00 .00 125,000.00 125,000.00 .0 TOTAL SCHOOL RESOURCE OFFICER .00 .00 125,000.00 125,000.00 .0 OJJDP-UNDERAGE ENFORCEMENT PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 356.97 2,372.26 3,871.00 1,498.74 61.3 TOTAL PERSONNEL SERVICES 356.97 2,372.26 3,871.00 1,498.74 61.3 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 27.28 181.30 296.00 114.70 61.3 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS ( 18.71) 561.72 700.00 138.28 80.3 13-5831-1025 EMPLOYEE BENEFITS - COMP 10.28 69.68 120.00 50.32 58.1 13-5831-1029 EMPLOYEE BENEFITS - WY 61.41 408.03 666.00 257.97 61.3 TOTAL EMPLOYEE BENEFITS 80.26 1,220.73 1,782.00 561.27 68.5 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES .00 991.35 1,300.00 308.65 76.3 TOTAL PROFESSIONAL SERVICES .00 991.35 1,300.00 308.65 76.3 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 93.40 668.76 1,300.00 631.24 51.4 TOTAL SUPPLIES 93.40 668.76 1,300.00 631.24 51.4 TOTAL OJJDP-UNDERAGE ENFORCEMENT 530.63 5,253.10 8,253.00 2,999.90 63.7 BULLET PROOF VEST PROTECTION SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 1,600.00 2,850.00 1,250.00 56.1 TOTAL SUPPLIES .00 1,600.00 2,850.00 1,250.00 56.1 TOTAL BULLET PROOF VEST PROTECTION .00 1,600.00 2,850.00 1,250.00 56.1 DEPT OF JUSTICE-BODY CAMS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:25PM PAGE:30 SUPPLIES: 13-5898-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 93,146.00 93,146.00 .0 TOTAL SUPPLIES .00 .00 93,146.00 93,146.00 .0 TOTAL DEPT OF JUSTICE-BODY CAMS .00 .00 93,146.00 93,146.00 .0 TOTAL FUND EXPENDITURES 1,393.61 10,207.88 242,234.00 232,026.12 4.2 NET REVENUE OVER EXPENDITURES 3,128.53 1,364.57 ( 1,255.00) ( 2,619.57) 108.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:38PM PAGE:31 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 4,395,136.80 31-10000118 MONEY MARKET ACCOUNT 121,692.16 TOTAL CASH 4,516,828.96 INVESTMENTS: 31-10000120 INVESTMENT POOL 4,066,735.06 31-10000122 TIME DEPOSITS - SHORT TERM 3,447,642.70 TOTAL INVESTMENTS 7,514,377.76 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 4,605.10 31-10000132 ACCOUNTS RECEIVABLE - EOY 140,452.28 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 356,603.25 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 7,713.68) 31-10000139 ACCRUED INTEREST RECEIVABLE 19,784.99 31-10000140 DUE FROM OTHER FUNDS 19,985.36 31-10000156 DUE FROM OTHER FUNDS 47,168.22 TOTAL ACCOUNTS RECEIVABLE 580,885.52 TOTAL CURRENT ASSETS 12,612,092.24 NON-CURRENT ASSETS: INVESTMENTS: 31-10000172 TIME DEPOSITS - EOY 1,231.76 TOTAL INVESTMENTS 1,231.76 FIXED ASSETS: 31-10000181 BUILDINGS 13,451,463.98 31-10000182 ACCUMULATED - BUILDINGS ( 7,240,326.93) 31-10000183 VEHICLES 361,051.97 31-10000184 ACCUMULATED - VEHICLES ( 348,092.08) 31-10000185 EQUIPMENT 739,643.13 31-10000186 ACCUMULATED - EQUIPMENT ( 451,191.47) 31-10000188 IMPROVEMENTS OTHER THAN BLDG 21,781,824.50 31-10000189 ACCUMULATED OT BLDG ( 4,414,149.97) TOTAL FIXED ASSETS 23,880,223.13 OTHER ASSETS: 31-10000190 ACCUMULATED ( 485,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 154,690.77 31-10006100 DEFERRED OUTFLOW OF RESOURCES 41,522.86 TOTAL OTHER ASSETS ( 288,786.37) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:38PM PAGE:32 TOTAL NON-CURRENT ASSETS 23,592,668.52 TOTAL ASSETS 36,204,760.76 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 211,925.60 31-20000204 ACCOUNTS PAYABLE - EOY ( 388.69) 31-20000210 RETAINAGE PAYABLE 59,738.50 31-20000215 WAGES PAYABLE 17,183.92 TOTAL ACCOUNTS PAYABLE 288,459.33 DUE TO OTHER FUNDS: 31-20000245 DUE TO OTHER FUNDS 388.69 TOTAL DUE TO OTHER FUNDS 388.69 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 307,025.58 31-20005411 DEFERRED INFLOWS OF RESOURCES 68,059.91 TOTAL OTHER PAYABLES 375,085.49 TOTAL CURRENT LIABILITIES 663,933.51 NON-CURRENT LIABILITIES: 31-20000265 COMPENSATED ABSENCES PAYABLE 64,729.59 TOTAL NON-CURRENT LIABILITIES 64,729.59 TOTAL LIABILITIES 728,663.10 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 5,763,201.59 31-30000305 RESERVE FOR REPLACEMENT 4,857,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 684,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 120,000.00 TOTAL CAPITAL ASSETS 12,000,442.28 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:38PM PAGE:33 RESTRICTED ASSETS: 31-30000310 RESERVE FOR EQUIPMENT 30,000.00 TOTAL RESTRICTED ASSETS 30,000.00 OTHER NET ASSETS: 31-30000320 CAPITAL ASSETS NET OF DEBT 24,034,913.92 TOTAL OTHER NET ASSETS 24,034,913.92 REVENUE OVER EXPENDITURES - YTD ( 589,258.54) BALANCE - CURRENT DATE 35,476,097.66 TOTAL NET ASSETS 35,476,097.66 TOTAL LIABILITIES AND NET ASSETS 36,204,760.76 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:34 WATER - REVENUE REVENUE: 31-4310-0160 GAIN ON INVESTMENTS ( 55,390.85) ( 209,369.49) .00 209,369.49 .0 TOTAL REVENUE ( 55,390.85) ( 209,369.49) .00 209,369.49 .0 MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 1,512.40 2,000.00 487.60 75.6 31-4310-1140 INTEREST INCOME 2,251.62 161,764.14 145,000.00 ( 16,764.14) 111.6 TOTAL MISC LOCAL REVENUE 2,251.62 163,276.54 147,000.00 ( 16,276.54) 111.1 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 308,107.00 2,566,394.89 2,800,000.00 233,605.11 91.7 31-4310-1705 UTILITY SERVICE FEES 2,220.00 25,817.50 15,000.00 ( 10,817.50) 172.1 31-4310-1706 WATER PLANT INVESTMENT FEES .00 39,900.00 2,000.00 ( 37,900.00) 1995.0 31-4310-1707 UTILITY LATE FEES 1,270.00 15,660.00 15,000.00 ( 660.00) 104.4 31-4310-1710 BULK WATER 9,038.91 85,675.01 50,000.00 ( 35,675.01) 171.4 TOTAL UTILITIES REVENUE 320,635.91 2,733,447.40 2,882,000.00 148,552.60 94.9 TOTAL WATER - REVENUE 267,496.68 2,687,354.45 3,029,000.00 341,645.55 88.7 TOTAL FUND REVENUE 267,496.68 2,687,354.45 3,029,000.00 341,645.55 88.7 WATER - ADMINISTRATION DEPRECIATION: 31-5400-1150 DEPRECIATION 242,500.00 485,000.00 485,000.00 .00 100.0 TOTAL DEPRECIATION 242,500.00 485,000.00 485,000.00 .00 100.0 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 853.11 10,041.23 5,400.00 ( 4,641.23) 186.0 31-5400-2166 COLLECTION FEES 6.84 374.51 250.00 ( 124.51) 149.8 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 35.00 500.00 465.00 7.0 TOTAL PROFESSIONAL SERVICES 859.95 10,450.74 6,150.00 ( 4,300.74) 169.9 OPERATING TRANSFERS: 31-5400-4345 INVESTMENT FEES 348.59 3,166.70 .00 ( 3,166.70) .0 31-5400-4347 MANAGEMENT FEES 131,931.50 263,863.00 263,863.00 .00 100.0 TOTAL OPERATING TRANSFERS 132,280.09 267,029.70 263,863.00 ( 3,166.70) 101.2 TOTAL WATER - ADMINISTRATION 375,640.04 762,480.44 755,013.00 ( 7,467.44) 101.0 WATER - TREATMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:35 CASH FUND APPROPRIATION: 31-5401-0150 REPLACEMENT RESERVE-SAND FILTE 37,500.00 75,000.00 75,000.00 .00 100.0 31-5401-0153 REPLACEMENT RESERVE-SMW REHA 7,500.00 15,000.00 15,000.00 .00 100.0 TOTAL CASH FUND APPROP 45,000.00 90,000.00 90,000.00 .00 100.0 PERSONNEL SERVICES: 31-5401-1001 SALARIES/WAGES - REGULAR 7,741.44 101,302.18 101,302.00 ( .18) 100.0 31-5401-1002 SALARIES/WAGES - OVERTIME 721.62 6,079.13 6,000.00 ( 79.13) 101.3 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 606.86 607.00 .14 100.0 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 31-5401-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 2,026.00 2,026.00 .0 TOTAL PERSONNEL SERVICES 8,488.06 108,288.17 110,235.00 1,946.83 98.2 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 663.48 8,468.92 8,618.00 149.08 98.3 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 3,251.64 39,019.67 38,956.00 ( 63.67) 100.2 31-5401-1025 EMPLOYEE BENEFITS - COMP 230.45 3,074.87 3,095.00 20.13 99.4 31-5401-1026 EMPLOYEE BENEFITS - COMP 154.84 2,026.19 2,026.00 ( .19) 100.0 31-5401-1029 EMPLOYEE BENEFITS - WY 1,455.65 18,469.69 18,456.00 ( 13.69) 100.1 TOTAL EMPLOYEE BENEFITS 5,756.06 71,059.34 71,151.00 91.66 99.9 PURCHASED SERVICES: 31-5401-2122 TRAINING/DEVELOPMENT .00 338.00 2,570.00 2,232.00 13.2 TOTAL PURCHASED SERVICES .00 338.00 2,570.00 2,232.00 13.2 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 11,969.59 54,407.51 50,000.00 ( 4,407.51) 108.8 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 1,119.01 7,774.55 7,000.00 ( 774.55) 111.1 31-5401-2133 UTILITY SERVICES - NATURAL GAS 605.64 5,547.89 6,000.00 452.11 92.5 31-5401-2134 TELECOMMUNICATIONS .00 169.63 200.00 30.37 84.8 31-5401-2140 RENT - LAND/BUILDINGS .00 10,183.62 10,000.00 ( 183.62) 101.8 TOTAL PROPERTY SERVICES 13,694.24 78,083.20 73,200.00 ( 4,883.20) 106.7 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 1,592.50 2,000.00 407.50 79.6 31-5401-2155 REPAIRS/MAINTENANCE 1,722.37 6,519.37 15,000.00 8,480.63 43.5 31-5401-2156 MAINTENANCE AGREEMENT .00 7,350.00 7,000.00 ( 350.00) 105.0 31-5401-2158 MISC CONTRACTUAL SERVICES 3,070.50 12,638.60 20,000.00 7,361.40 63.2 TOTAL PROFESSIONAL SERVICES 4,792.87 28,100.47 44,000.00 15,899.53 63.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:36 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 1,503.10 30,149.03 25,000.00 ( 5,149.03) 120.6 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 5,705.00 8,235.75 11,500.00 3,264.25 71.6 31-5401-3235 FUEL 133.30 708.38 2,000.00 1,291.62 35.4 TOTAL SUPPLIES 7,341.40 39,093.16 38,500.00 ( 593.16) 101.5 CAPITALIZED EXPENDITURES: 31-5401-6542 TO BLDG 10,453.80 16,453.80 91,000.00 74,546.20 18.1 31-5401-6544 OTHER THAN BLDG .00 661,975.00 .00 ( 661,975.00) .0 31-5401-6547 EQUIPMENT/FURNITURE .00 .00 90,000.00 90,000.00 .0 TOTAL CAPITALIZED EXPENDITURES 10,453.80 678,428.80 181,000.00 ( 497,428.80) 374.8 TOTAL WATER - TREATMENT 95,526.43 1,093,391.14 610,656.00 ( 482,735.14) 179.1 WATER - DISTRIBUTION/MAINTNCE CASH FUND APPROPRIATION: 31-5402-0150 REPLACEMENT RESERVE 15,000.00 30,000.00 30,000.00 .00 100.0 TOTAL CASH FUND APPROP 15,000.00 30,000.00 30,000.00 .00 100.0 PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 13,771.75 177,304.95 173,693.00 ( 3,611.95) 102.1 31-5402-1002 SALARIES/WAGES - OVERTIME .00 4,279.62 7,500.00 3,220.38 57.1 31-5402-1004 SALARIES/WAGES - TEMPORARY .00 .00 2,982.00 2,982.00 .0 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 667.65 668.00 .35 100.0 31-5402-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 13,796.75 182,552.22 185,143.00 2,590.78 98.6 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,057.75 13,995.02 14,193.00 197.98 98.6 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 6,255.64 75,061.07 74,847.00 ( 214.07) 100.3 31-5402-1025 EMPLOYEE BENEFITS - COMP 375.83 5,185.37 5,288.00 102.63 98.1 31-5402-1029 EMPLOYEE BENEFITS - WY 2,368.74 31,232.68 31,165.00 ( 67.68) 100.2 TOTAL EMPLOYEE BENEFITS 10,057.96 125,474.14 125,493.00 18.86 100.0 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 78.00 1,266.12 1,700.00 433.88 74.5 31-5402-2122 TRAINING/DEVELOPMENT 390.00 2,225.00 2,450.00 225.00 90.8 TOTAL PURCHASED SERVICES 468.00 3,491.12 4,150.00 658.88 84.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:37 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 2,143.85 16,607.20 13,500.00 ( 3,107.20) 123.0 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 5,373.18 27,901.44 30,000.00 2,098.56 93.0 31-5402-2133 UTILITY SERVICES - NATURAL GAS 81.70 1,177.07 1,300.00 122.93 90.5 31-5402-2134 TELECOMMUNICATIONS 32.89 196.93 350.00 153.07 56.3 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 7,631.62 45,882.64 45,550.00 ( 332.64) 100.7 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,190.00 2,000.00 810.00 59.5 31-5402-2155 REPAIRS/MAINTENANCE .00 17,482.57 10,000.00 ( 7,482.57) 174.8 31-5402-2156 MAINTENANCE AGREEMENT .00 1,095.00 900.00 ( 195.00) 121.7 31-5402-2158 MISC CONTRACTUAL SERVICES .00 4,000.00 5,000.00 1,000.00 80.0 TOTAL PROFESSIONAL SERVICES .00 23,767.57 17,900.00 ( 5,867.57) 132.8 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 1,068.64 40,920.17 35,000.00 ( 5,920.17) 116.9 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 9,000.00 9,000.00 .0 31-5402-3235 FUEL 1,067.97 4,755.17 8,000.00 3,244.83 59.4 TOTAL SUPPLIES 2,136.61 45,675.34 52,000.00 6,324.66 87.8 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 313.34 350.00 36.66 89.5 TOTAL FINANCIAL .00 313.34 350.00 36.66 89.5 CAPITALIZED EXPENDITURES: 31-5402-6544 OTHER THAN BLDG 3,494.00 3,494.00 8,000.00 4,506.00 43.7 TOTAL CAPITALIZED EXPENDITURES 3,494.00 3,494.00 8,000.00 4,506.00 43.7 TOTAL WATER - DISTRIBUTION/MAINTNCE 52,584.94 460,650.37 468,586.00 7,935.63 98.3 WATER - CUSTOMER SERVICES PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 3,861.95 49,977.42 49,893.00 ( 84.42) 100.2 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 521.31 521.00 ( .31) 100.1 31-5403-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 873.60 998.00 124.40 87.5 TOTAL PERSONNEL SERVICES 3,861.95 51,372.33 51,412.00 39.67 99.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:38 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 282.74 3,777.56 14,193.00 10,415.44 26.6 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 22.55 270.60 266.00 ( 4.60) 101.7 31-5403-1025 EMPLOYEE BENEFITS - COMP 105.26 1,459.29 1,437.00 ( 22.29) 101.6 31-5403-1029 EMPLOYEE BENEFITS - WY 664.25 8,596.01 8,582.00 ( 14.01) 100.2 TOTAL EMPLOYEE BENEFITS 1,074.80 14,103.46 24,478.00 10,374.54 57.6 PROPERTY SERVICES: 31-5403-2134 TELECOMMUNICATIONS .00 208.14 200.00 ( 8.14) 104.1 TOTAL PROPERTY SERVICES .00 208.14 200.00 ( 8.14) 104.1 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 1,436.54 1,500.00 63.46 95.8 31-5403-2156 MAINTENANCE AGREEMENT .00 250.00 .00 ( 250.00) .0 TOTAL PROFESSIONAL SERVICES .00 1,686.54 1,500.00 ( 186.54) 112.4 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES .00 1,972.12 2,000.00 27.88 98.6 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 375.00 18,889.31 25,000.00 6,110.69 75.6 31-5403-3235 FUEL 89.12 521.99 2,000.00 1,478.01 26.1 TOTAL SUPPLIES 464.12 21,383.42 29,000.00 7,616.58 73.7 TOTAL WATER - CUSTOMER SERVICES 5,400.87 88,753.89 106,590.00 17,836.11 83.3 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 20,506.69 113,207.02 250,515.00 137,307.98 45.2 TOTAL PROFESSIONAL SERVICES 20,506.69 113,207.02 250,515.00 137,307.98 45.2 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG 131,066.72 696,435.20 1,531,802.00 835,366.80 45.5 TOTAL CAPITALIZED EXPENDITURES 131,066.72 696,435.20 1,531,802.00 835,366.80 45.5 TOTAL WATER MAIN REPLACEMENTS 151,573.41 809,642.22 1,782,317.00 972,674.78 45.4 LITTLE BOX ELDER SPRING REHAB PROFESSIONAL SERVICES: 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY .00 6,138.50 50,000.00 43,861.50 12.3 TOTAL PROFESSIONAL SERVICES .00 6,138.50 50,000.00 43,861.50 12.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:39 TOTAL LITTLE BOX ELDER SPRING REHAB .00 6,138.50 50,000.00 43,861.50 12.3 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 9,372.50 55,556.43 185,000.00 129,443.57 30.0 TOTAL PROFESSIONAL SERVICES 9,372.50 55,556.43 185,000.00 129,443.57 30.0 CAPITALIZED EXPENDITURES: 31-5856-6544 OTHER THAN BLDG .00 .00 1,150,000.00 1,150,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 1,150,000.00 1,150,000.00 .0 TOTAL WATER IMPROVEMENTS 9,372.50 55,556.43 1,335,000.00 1,279,443.57 4.2 TOTAL FUND EXPENDITURES 690,098.19 3,276,612.99 5,108,162.00 1,831,549.01 64.1 NET REVENUE OVER EXPENDITURES ( 422,601.51) ( 589,258.54) ( 2,079,162.00) ( 1,489,903.46) ( 28.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:40 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 176,728.55 32-10000118 MONEY MARKET ACCOUNT 121,692.15 TOTAL CASH 298,420.70 INVESTMENTS: 32-10000120 INVESTMENT POOL 1,136,053.58 32-10000122 TIME DEPOSITS - SHORT TERM 1,824,748.56 TOTAL INVESTMENTS 2,960,802.14 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 37,862.50 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 8,567.44) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 157,210.86 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,401.44) 32-10000139 ACCRUED INTEREST RECEIVABLE 7,896.65 32-10000140 DUE FROM OTHER FUNDS 22,817.06 32-10000156 DUE FROM OTHER FUNDS 2,109.59 TOTAL ACCOUNTS RECEIVABLE 216,927.78 TOTAL CURRENT ASSETS 3,476,150.62 NON-CURRENT ASSETS: INVESTMENTS: 32-10000172 TIME DEPOSITS - EOY 3,695.27 TOTAL INVESTMENTS 3,695.27 FIXED ASSETS: 32-10000181 BUILDINGS 2,388,172.45 32-10000182 ACCUMULATED - BUILDINGS ( 2,067,698.59) 32-10000183 VEHICLES 498,929.82 32-10000184 ACCUMULATED - VEHICLES ( 485,969.93) 32-10000185 MACHINERY/EQUIPMENT 931,846.44 32-10000186 ACCUMULATED - EQUIPMENT ( 571,383.14) 32-10000188 IMPROVEMENTS OTHER THAN BLDG 12,395,719.90 32-10000189 ACCUMULATED OT BLDG ( 3,404,991.50) TOTAL FIXED ASSETS 9,684,625.45 OTHER ASSETS: 32-10000190 ACCUMULATED ( 290,000.00) 32-10000195 CONSTRUCTION IN PROGRESS 821,313.19 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 14,087.50 TOTAL OTHER ASSETS 545,400.69 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:41 TOTAL NON-CURRENT ASSETS 10,233,721.41 TOTAL ASSETS 13,709,872.03 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 214,303.46 32-20000204 ACCOUNTS PAYABLE - EOY ( 3,921.70) 32-20000210 RETAINAGE PAYABLE 20,791.93 32-20000215 WAGES PAYABLE 13,725.50 TOTAL ACCOUNTS PAYABLE 244,899.19 DUE TO OTHER FUNDS: 32-20000245 DUE TO OTHER FUNDS 3,921.70 TOTAL DUE TO OTHER FUNDS 3,921.70 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 180,779.45 32-20005411 DEFERRED INFLOWS OF RESOURCES 55,183.71 TOTAL OTHER PAYABLES 235,963.16 TOTAL CURRENT LIABILITIES 484,784.05 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 47,377.35 TOTAL NON-CURRENT LIABILITIES 47,377.35 TOTAL LIABILITIES 532,161.40 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS ( 807,339.84) 32-30000305 RESERVE FOR REPLACEMENT 4,075,882.31 32-30000306 RESERVE FOR OPERATING 195,913.00 32-30000307 RESERVE FOR SLUDGE REMOVAL 385,000.00 TOTAL CAPITAL ASSETS 3,849,455.47 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:42 RESTRICTED ASSETS: 32-30000310 RESERVE FOR EQUIPMENT 30,000.00 TOTAL RESTRICTED ASSETS 30,000.00 OTHER NET ASSETS: 32-30000320 CAPITAL ASSETS NET OF DEBT 10,505,938.66 TOTAL OTHER NET ASSETS 10,505,938.66 REVENUE OVER EXPENDITURES - YTD ( 1,207,683.50) BALANCE - CURRENT DATE 13,177,710.63 TOTAL NET ASSETS 13,177,710.63 TOTAL LIABILITIES AND NET ASSETS 13,709,872.03 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:43 SEWER - REVENUE REVENUE: 32-4320-0160 GAIN ON INVESTMENTS ( 23,738.94) ( 89,729.77) .00 89,729.77 .0 TOTAL REVENUE ( 23,738.94) ( 89,729.77) .00 89,729.77 .0 MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 1,237.41 1,000.00 ( 237.41) 123.7 32-4320-1140 INTEREST INCOME 1,146.84 69,564.94 100,000.00 30,435.06 69.6 TOTAL MISC LOCAL REVENUE 1,146.84 70,802.35 101,000.00 30,197.65 70.1 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 120,184.63 1,325,475.13 1,900,000.00 574,524.87 69.8 32-4320-1706 SEWER PLANT INVESTMENT FEES .00 6,600.00 1,000.00 ( 5,600.00) 660.0 TOTAL UTILITIES REVENUE 120,184.63 1,332,075.13 1,901,000.00 568,924.87 70.1 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 34,575.00 249,975.00 150,000.00 ( 99,975.00) 166.7 TOTAL SEPTIC WASTE DISPOSAL 34,575.00 249,975.00 150,000.00 ( 99,975.00) 166.7 TOTAL SEWER - REVENUE 132,167.53 1,563,122.71 2,152,000.00 588,877.29 72.6 TOTAL FUND REVENUE 132,167.53 1,563,122.71 2,152,000.00 588,877.29 72.6 SEWER - ADMINISTRATION DEPRECIATION: 32-5500-1150 DEPRECIATION 145,000.00 290,000.00 290,000.00 .00 100.0 TOTAL DEPRECIATION 145,000.00 290,000.00 290,000.00 .00 100.0 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 550.96 6,484.95 3,900.00 ( 2,584.95) 166.3 TOTAL PROFESSIONAL SERVICES 550.96 6,484.95 3,900.00 ( 2,584.95) 166.3 OPERATING TRANSFERS: 32-5500-4345 INVESTMENT FEES 149.40 1,357.16 .00 ( 1,357.16) .0 32-5500-4347 MANAGEMENT FEES 78,587.00 157,174.00 157,174.00 .00 100.0 TOTAL OPERATING TRANSFERS 78,736.40 158,531.16 157,174.00 ( 1,357.16) 100.9 TOTAL SEWER - ADMINISTRATION 224,287.36 455,016.11 451,074.00 ( 3,942.11) 100.9 SEWER - TREATMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:44 CASH FUND APPROPRIATION: 32-5501-0150 SLUDGE REMOVAL RESERVE 42,500.00 85,000.00 85,000.00 .00 100.0 TOTAL CASH FUND APPROP 42,500.00 85,000.00 85,000.00 .00 100.0 PERSONNEL SERVICES: 32-5501-1001 SALARIES/WAGES - REGULAR 7,061.36 91,042.21 90,589.00 ( 453.21) 100.5 32-5501-1002 SALARIES/WAGES - OVERTIME 478.71 1,979.68 5,000.00 3,020.32 39.6 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 356.22 356.00 ( .22) 100.1 32-5501-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 32-5501-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 .00 813.00 813.00 .0 TOTAL PERSONNEL SERVICES 7,565.07 93,678.11 97,058.00 3,379.89 96.5 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 585.81 7,258.42 7,517.00 258.58 96.6 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 3,248.22 38,974.75 38,910.00 ( 64.75) 100.2 32-5501-1025 EMPLOYEE BENEFITS - COMP 205.54 2,659.85 2,754.00 94.15 96.6 32-5501-1026 EMPLOYEE BENEFITS - COMP 62.54 813.02 813.00 ( .02) 100.0 32-5501-1029 EMPLOYEE BENEFITS - WY 1,296.88 15,999.54 16,441.00 441.46 97.3 TOTAL EMPLOYEE BENEFITS 5,398.99 65,705.58 66,435.00 729.42 98.9 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 169.00 2,570.00 2,401.00 6.6 TOTAL PURCHASED SERVICES .00 169.00 2,570.00 2,401.00 6.6 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 8,360.25 54,411.67 95,000.00 40,588.33 57.3 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 14,565.20 71,247.31 60,000.00 ( 11,247.31) 118.8 32-5501-2134 TELECOMMUNICATIONS 130.84 1,364.62 1,700.00 335.38 80.3 TOTAL PROPERTY SERVICES 23,056.29 127,023.60 156,700.00 29,676.40 81.1 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY 945.85 2,588.35 2,000.00 ( 588.35) 129.4 32-5501-2155 REPAIRS/MAINTENANCE 8,169.45 24,318.11 30,000.00 5,681.89 81.1 32-5501-2158 MISC CONTRACTUAL SERVICES 606.00 9,622.00 10,000.00 378.00 96.2 TOTAL PROFESSIONAL SERVICES 9,721.30 36,528.46 42,000.00 5,471.54 87.0 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 2,539.35 29,832.47 25,000.00 ( 4,832.47) 119.3 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 12,800.00 12,800.00 .0 32-5501-3235 FUEL 133.28 708.26 1,200.00 491.74 59.0 TOTAL SUPPLIES 2,672.63 30,540.73 39,000.00 8,459.27 78.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:45 CAPITALIZED EXPENDITURES: 32-5501-6544 OTHER THAN BLDG 11,133.55 12,584.23 15,000.00 2,415.77 83.9 TOTAL CAPITALIZED EXPENDITURES 11,133.55 12,584.23 15,000.00 2,415.77 83.9 TOTAL SEWER - TREATMENT 102,047.83 451,229.71 503,763.00 52,533.29 89.6 SEWER - COLLECTION CASH FUND APPROPRIATION: 32-5502-0150 REPLACEMENT RESERVE 15,000.00 30,000.00 30,000.00 .00 100.0 TOTAL CASH FUND APPROP 15,000.00 30,000.00 30,000.00 .00 100.0 PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 14,283.08 181,844.35 181,290.00 ( 554.35) 100.3 32-5502-1002 SALARIES/WAGES - OVERTIME 189.79 6,916.23 4,500.00 ( 2,416.23) 153.7 32-5502-1004 SALARIES/WAGES - TEMPORARY .00 .00 2,982.00 2,982.00 .0 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 851.63 852.00 .37 100.0 32-5502-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 14,497.87 189,912.21 189,924.00 11.79 100.0 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 1,102.96 14,457.40 14,331.00 ( 126.40) 100.9 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 7,572.89 90,859.20 90,660.00 ( 199.20) 100.2 32-5502-1025 EMPLOYEE BENEFITS - COMP 395.28 5,394.46 5,424.00 29.54 99.5 32-5502-1029 EMPLOYEE BENEFITS - WY 2,489.33 32,466.74 31,956.00 ( 510.74) 101.6 TOTAL EMPLOYEE BENEFITS 11,560.46 143,177.80 142,371.00 ( 806.80) 100.6 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 78.00 1,266.13 1,700.00 433.87 74.5 32-5502-2122 TRAINING/DEVELOPMENT 390.00 1,040.00 1,825.00 785.00 57.0 TOTAL PURCHASED SERVICES 468.00 2,306.13 3,525.00 1,218.87 65.4 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 1,377.32 9,862.52 12,000.00 2,137.48 82.2 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 49.12 283.61 350.00 66.39 81.0 32-5502-2133 UTILITY SERVICES - NATURAL GAS 293.32 2,504.79 1,800.00 ( 704.79) 139.2 32-5502-2134 TELECOMMUNICATIONS 96.37 958.65 715.00 ( 243.65) 134.1 TOTAL PROPERTY SERVICES 1,816.13 13,609.57 14,865.00 1,255.43 91.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:46 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY .00 960.00 2,500.00 1,540.00 38.4 32-5502-2155 REPAIRS/MAINTENANCE .00 11,644.32 10,000.00 ( 1,644.32) 116.4 32-5502-2158 MISC CONTRACTUAL SERVICES .00 4,000.00 4,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 16,604.32 16,500.00 ( 104.32) 100.6 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 718.95 20,913.81 25,000.00 4,086.19 83.7 32-5502-3235 FUEL 1,067.92 4,754.66 7,000.00 2,245.34 67.9 TOTAL SUPPLIES 1,786.87 25,668.47 32,000.00 6,331.53 80.2 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 284.85 250.00 ( 34.85) 113.9 TOTAL FINANCIAL .00 284.85 250.00 ( 34.85) 113.9 TOTAL SEWER - COLLECTION 45,129.33 421,563.35 429,435.00 7,871.65 98.2 SEWER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 19,785.25 179,142.44 289,811.00 110,668.56 61.8 TOTAL PROFESSIONAL SERVICES 19,785.25 179,142.44 289,811.00 110,668.56 61.8 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG 143,542.99 1,263,854.60 2,173,732.00 909,877.40 58.1 TOTAL CAPITALIZED EXPENDITURES 143,542.99 1,263,854.60 2,173,732.00 909,877.40 58.1 TOTAL SEWER MAIN REPLACEMENTS 163,328.24 1,442,997.04 2,463,543.00 1,020,545.96 58.6 TOTAL FUND EXPENDITURES 534,792.76 2,770,806.21 3,847,815.00 1,077,008.79 72.0 NET REVENUE OVER EXPENDITURES ( 402,625.23) ( 1,207,683.50) ( 1,695,815.00) ( 488,131.50) ( 71.2) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:47 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 584,367.71 TOTAL CASH 584,367.71 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 427,235.45 TOTAL INVESTMENTS 427,235.45 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 417.84 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 1,562.15) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 131,529.08 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 979.26) 33-10000139 ACCRUED INTEREST RECEIVABLE 755.48 33-10000156 DUE FROM OTHER FUNDS 9,940.63 TOTAL ACCOUNTS RECEIVABLE 140,101.62 TOTAL CURRENT ASSETS 1,151,704.78 FIXED ASSETS: 33-10000183 VEHICLES 684,806.00 33-10000184 ACCUMULATED - VEHICLES ( 329,844.27) 33-10000185 EQUIPMENT 33,437.00 33-10000186 ACCUMULATED - EQUIPMENT ( 33,437.00) TOTAL FIXED ASSETS 354,961.73 OTHER ASSETS: 33-10000190 ACCUMULATED ( 41,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 9,727.83 TOTAL OTHER ASSETS ( 31,272.17) TOTAL NON-CURRENT ASSETS 323,689.56 TOTAL ASSETS 1,475,394.34 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:48 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 92,464.09 33-20000204 ACCOUNTS PAYBLE - EOY ( 157,140.00) 33-20000215 WAGES PAYABLE 7,232.37 TOTAL ACCOUNTS PAYABLE ( 57,443.54) DUE TO OTHER FUNDS: 33-20000245 DUE TO OTHER FUNDS 157,140.00 TOTAL DUE TO OTHER FUNDS 157,140.00 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 99,023.88 33-20005411 DEFERRED INFLOWS OF RESOURCES 29,431.30 TOTAL OTHER PAYABLES 128,455.18 TOTAL CURRENT LIABILITIES 228,151.64 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 39,199.93 TOTAL NON-CURRENT LIABILITIES 39,199.93 TOTAL LIABILITIES 267,351.57 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 56,034.49) 33-30000305 RESERVE FOR REPLACEMENT 861,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 881,710.05 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 354,961.73 TOTAL OTHER NET ASSETS 354,961.73 REVENUE OVER EXPENDITURES - YTD ( 28,629.01) BALANCE - CURRENT DATE 1,208,042.77 TOTAL NET ASSETS 1,208,042.77 TOTAL LIABILITIES AND NET ASSETS 1,475,394.34 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:49 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1140 INTEREST INCOME 159.97 10,118.11 7,500.00 ( 2,618.11) 134.9 TOTAL MISC LOCAL REVENUE 159.97 10,118.11 7,500.00 ( 2,618.11) 134.9 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 116,233.78 1,319,577.28 1,000,000.00 ( 319,577.28) 132.0 33-4330-1709 SANITATION ACTIVATION FEE 125.00 36,299.98 35,674.00 ( 625.98) 101.8 TOTAL UTILITIES REVENUE 116,358.78 1,355,877.26 1,035,674.00 ( 320,203.26) 130.9 TOTAL SANITATION - REVENUE 116,518.75 1,365,995.37 1,043,174.00 ( 322,821.37) 131.0 TOTAL FUND REVENUE 116,518.75 1,365,995.37 1,043,174.00 ( 322,821.37) 131.0 SANITATION CASH FUND APPROPRIATION: 33-5600-0150 REPLACEMENT RESERVE 25,000.00 50,000.00 50,000.00 .00 100.0 TOTAL CASH FUND APPROP 25,000.00 50,000.00 50,000.00 .00 100.0 PERSONNEL SERVICES: 33-5600-1001 SALARIES/WAGES - REGULAR 11,038.16 143,609.41 143,496.00 ( 113.41) 100.1 33-5600-1002 SALARIES/WAGES - OVERTIME .00 264.45 600.00 335.55 44.1 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 1,367.44 1,367.00 ( .44) 100.0 33-5600-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 33-5600-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 1,664.00 2,928.00 1,264.00 56.8 TOTAL PERSONNEL SERVICES 11,063.16 147,205.30 148,691.00 1,485.70 99.0 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 859.36 11,430.63 11,544.00 113.37 99.0 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 5,412.11 64,945.31 64,817.00 ( 128.31) 100.2 33-5600-1025 EMPLOYEE BENEFITS - COMP 301.45 4,181.53 4,189.00 7.47 99.8 33-5600-1026 EMPLOYEE BENEFITS - COMP 140.16 1,823.70 1,822.00 ( 1.70) 100.1 33-5600-1029 EMPLOYEE BENEFITS - WY 1,898.58 24,746.47 24,785.00 38.53 99.8 TOTAL EMPLOYEE BENEFITS 8,611.66 107,127.64 107,157.00 29.36 100.0 DEPRECIATION: 33-5600-1150 DEPRECIATION 20,500.00 41,000.00 41,000.00 .00 100.0 TOTAL DEPRECIATION 20,500.00 41,000.00 41,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:50 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 33-5600-2158 MISC CONTRACTUAL SERVICES 90,334.22 851,022.75 503,000.00 ( 348,022.75) 169.2 TOTAL PROFESSIONAL SERVICES 90,334.22 851,022.75 504,000.00 ( 347,022.75) 168.9 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 349.29 54,489.99 27,000.00 ( 27,489.99) 201.8 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 50,458.22 62,624.00 12,165.78 80.6 33-5600-3235 FUEL 1,936.72 11,301.48 22,000.00 10,698.52 51.4 TOTAL SUPPLIES 2,286.01 116,249.69 111,624.00 ( 4,625.69) 104.1 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 41,009.50 82,019.00 82,019.00 .00 100.0 TOTAL OPERATING TRANSFERS 41,009.50 82,019.00 82,019.00 .00 100.0 TOTAL SANITATION 198,804.55 1,394,624.38 1,044,491.00 ( 350,133.38) 133.5 TOTAL FUND EXPENDITURES 198,804.55 1,394,624.38 1,044,491.00 ( 350,133.38) 133.5 NET REVENUE OVER EXPENDITURES ( 82,285.80) ( 28,629.01) ( 1,317.00) 27,312.01 (2173.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:51 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 701,082.99 TOTAL CASH 701,082.99 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,692,412.25 TOTAL INVESTMENTS 1,692,412.25 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 112,715.30 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 157,140.00) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY ( 1,511.85) 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 1,986.69) 34-10000139 ACCRUED INTEREST RECEIVABLE 2,885.85 34-10000156 DUE FROM OTHER FUNDS 167,557.10 TOTAL ACCOUNTS RECEIVABLE 122,519.71 TOTAL CURRENT ASSETS 2,516,014.95 FIXED ASSETS: 34-10000180 LAND 153,289.58 34-10000181 BUILDINGS 1,689,609.46 34-10000182 ACCUMULATED - BUILDINGS ( 445,126.96) 34-10000183 VEHICLES 97,705.76 34-10000184 ACCUMULATED - VEHICLE ( 61,182.64) 34-10000185 EQUIPMENT 1,306,030.57 34-10000186 ACCUMULATED - EQUIPMENT ( 970,757.27) 34-10000188 IMPROVEMENTS OTHER THAN BLDG 417,030.94 34-10000189 ACCUMULATED OT BLDG ( 65,031.80) TOTAL FIXED ASSETS 2,121,567.64 OTHER ASSETS: 34-10000190 ACCUMULATED ( 155,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 17,303.45 TOTAL OTHER ASSETS ( 137,696.55) TOTAL NON-CURRENT ASSETS 1,983,871.09 TOTAL ASSETS 4,499,886.04 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:52 ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 75,608.77 34-20000204 ACCOUNTS PAYABLE- EOY 34,811.09 34-20000215 WAGES PAYABLE 10,153.42 TOTAL ACCOUNTS PAYABLE 120,573.28 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 145,657.65 34-20005411 DEFERRED INFLOWS OF RESOURCES 31,270.76 TOTAL OTHER PAYABLES 176,928.41 TOTAL CURRENT LIABILITIES 297,501.69 NON-CURRENT LIABILITIES: 34-20000260 SLIB NOTES PAYABLE 90,994.79 34-20000265 COMPENSATED ABSENCES PAYABLE 34,128.14 34-20000290 LANDFILL LIABILITY 438,718.20 TOTAL NON-CURRENT LIABILITIES 563,841.13 TOTAL LIABILITIES 861,342.82 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS ( 339,737.68) 34-30000305 RESERVE FOR REPLACEMENT 1,256,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,049,433.09 OTHER NET ASSETS: 34-30000320 CAPITAL ASSETS NET OF DEBT 2,560,285.83 TOTAL OTHER NET ASSETS 2,560,285.83 REVENUE OVER EXPENDITURES - YTD 28,824.30 BALANCE - CURRENT DATE 3,638,543.22 TOTAL NET ASSETS 3,638,543.22 TOTAL LIABILITIES AND NET ASSETS 4,499,886.04 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:53 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER .00 10,314.50 .00 ( 10,314.50) .0 34-4340-1140 INTEREST INCOME 186.30 30,166.42 25,000.00 ( 5,166.42) 120.7 TOTAL MISC LOCAL REVENUE 186.30 40,480.92 25,000.00 ( 15,480.92) 161.9 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 138,633.81 1,128,448.04 1,000,000.00 ( 128,448.04) 112.8 TOTAL UTILITIES REVENUE 138,633.81 1,128,448.04 1,000,000.00 ( 128,448.04) 112.8 TOTAL LANDFILL - REVENUE 138,820.11 1,168,928.96 1,025,000.00 ( 143,928.96) 114.0 TOTAL FUND REVENUE 138,820.11 1,168,928.96 1,025,000.00 ( 143,928.96) 114.0 LANDFILL PERSONNEL SERVICES: 34-5340-1001 SALARIES/WAGES - REGULAR 16,022.97 205,852.62 203,290.00 ( 2,562.62) 101.3 34-5340-1002 SALARIES/WAGES - OVERTIME .00 596.63 1,500.00 903.37 39.8 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,549.97 1,550.00 .03 100.0 34-5340-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 34-5340-1007 SALARIES/WAGES-INCENTIVE/BONUS .00 607.44 632.00 24.56 96.1 TOTAL PERSONNEL SERVICES 16,072.97 209,206.66 207,572.00 ( 1,634.66) 100.8 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,282.60 16,708.36 16,583.00 ( 125.36) 100.8 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 6,490.00 77,872.42 77,704.00 ( 168.42) 100.2 34-5340-1025 EMPLOYEE BENEFITS - COMP 438.03 5,942.37 5,938.00 ( 4.37) 100.1 34-5340-1026 EMPLOYEE BENEFITS - COMP 665.49 8,808.67 8,423.00 ( 385.67) 104.6 34-5340-1029 EMPLOYEE BENEFITS - WY 2,090.47 26,655.37 25,979.00 ( 676.37) 102.6 TOTAL EMPLOYEE BENEFITS 10,966.59 135,987.19 134,627.00 ( 1,360.19) 101.0 DEPRECIATION: 34-5340-1150 DEPRECIATION 77,500.00 155,000.00 155,000.00 .00 100.0 TOTAL DEPRECIATION 77,500.00 155,000.00 155,000.00 .00 100.0 PURCHASED SERVICES: 34-5340-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 300.00 300.00 .0 34-5340-2122 TRAINING/DEVELOPMENT .00 .00 600.00 600.00 .0 34-5340-2123 MEALS/LODGING/TRAVEL .00 .00 750.00 750.00 .0 TOTAL PURCHASED SERVICES .00 .00 1,650.00 1,650.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:54 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 1,044.16 7,195.20 9,000.00 1,804.80 80.0 34-5340-2133 UTILITY SERVICES - NATURAL GAS 1,136.47 9,427.78 9,000.00 ( 427.78) 104.8 34-5340-2134 TELECOMMUNICATIONS .00 5.34 250.00 244.66 2.1 TOTAL PROPERTY SERVICES 2,180.63 16,628.32 18,250.00 1,621.68 91.1 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 34-5340-2155 REPAIRS/MAINTENANCE 135.00 14,833.79 15,000.00 166.21 98.9 34-5340-2156 MAINTENANCE AGREEMENT 614.00 4,405.20 6,100.00 1,694.80 72.2 34-5340-2158 MISC CONTRACTUAL SERVICES 52,047.92 375,956.11 422,120.00 46,163.89 89.1 34-5340-2166 COLLECTION FEES .00 21.00 300.00 279.00 7.0 TOTAL PROFESSIONAL SERVICES 52,796.92 395,216.10 444,520.00 49,303.90 88.9 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 1,812.20 32,906.99 50,000.00 17,093.01 65.8 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,270.23 17,500.00 16,229.77 7.3 34-5340-3235 FUEL 5,528.59 23,749.30 20,000.00 ( 3,749.30) 118.8 TOTAL SUPPLIES 7,340.79 57,926.52 87,500.00 29,573.48 66.2 FINANCIAL: 34-5340-4343 DEBT PAYMENT - PRINCIPAL .00 13,141.02 13,141.00 ( .02) 100.0 TOTAL FINANCIAL .00 13,141.02 13,141.00 ( .02) 100.0 OPERATING TRANSFERS: 34-5340-4347 MANAGEMENT FEES 57,361.50 114,723.00 114,723.00 .00 100.0 TOTAL OPERATING TRANSFERS 57,361.50 114,723.00 114,723.00 .00 100.0 TOTAL LANDFILL 224,219.40 1,097,828.81 1,176,983.00 79,154.19 93.3 LANDFILL - CAPITAL PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 10,054.53 29,084.60 40,000.00 10,915.40 72.7 TOTAL PROFESSIONAL SERVICES 10,054.53 29,084.60 40,000.00 10,915.40 72.7 CAPITALIZED EXPENDITURES: 34-5895-6542 BUILDINGS/IMPROVEMENTS .00 .00 20,000.00 20,000.00 .0 34-5895-6547 EQUIPMENT/FURNITURE 3,235.90 13,191.25 21,500.00 8,308.75 61.4 TOTAL CAPITALIZED EXPENDITURES 3,235.90 13,191.25 41,500.00 28,308.75 31.8 TOTAL LANDFILL - CAPITAL 13,290.43 42,275.85 81,500.00 39,224.15 51.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:55 TOTAL FUND EXPENDITURES 237,509.83 1,140,104.66 1,258,483.00 118,378.34 90.6 NET REVENUE OVER EXPENDITURES ( 98,689.72) 28,824.30 ( 233,483.00) ( 262,307.30) 12.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:56 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 500,333.98 TOTAL CASH 500,333.98 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 426,163.81 TOTAL INVESTMENTS 426,163.81 ACCOUNTS RECEIVABLE: 39-10000131 ACCOUNTS RECEIVABLE - GENERAL 29,465.58 39-10000139 ACCRUED INTEREST RECEIVABLE 855.11 TOTAL ACCOUNTS RECEIVABLE 30,320.69 TOTAL CURRENT ASSETS 956,818.48 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 956,818.48 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 39-20000210 IBNR LIABILITY 265,000.00 TOTAL ACCOUNTS PAYABLE 265,000.00 DUE TO OTHER FUNDS: 39-20000245 DUE TO OTHER FUNDS 119,144.81 TOTAL DUE TO OTHER FUNDS 119,144.81 TOTAL CURRENT LIABILITIES 384,144.81 TOTAL LIABILITIES 384,144.81 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:57 CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 478,575.56) 39-30000301 FUND BALANCE RESERVE 1,200,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 828,424.44 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 255,750.77) BALANCE - CURRENT DATE 572,673.67 TOTAL NET ASSETS 572,673.67 TOTAL LIABILITIES AND NET ASSETS 956,818.48 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:39PM PAGE:58 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 14,362.04 208,648.62 50,000.00 ( 158,648.62) 417.3 39-4390-0111 INSURANCE PREMIUMS 41,167.78 501,310.17 375,000.00 ( 126,310.17) 133.7 39-4390-0112 INSURANCE ASSESSMENTS 73,919.53 902,989.65 1,100,000.00 197,010.35 82.1 39-4390-0113 COBRA PAYMENTS .00 777.18 .00 ( 777.18) .0 TOTAL REVENUE 129,449.35 1,613,725.62 1,525,000.00 ( 88,725.62) 105.8 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 140.67 8,799.00 5,500.00 ( 3,299.00) 160.0 TOTAL MISC LOCAL REVENUE 140.67 8,799.00 5,500.00 ( 3,299.00) 160.0 TRANSFERS IN: 39-4390-5510 TRANSFER FROM GENERAL FUND 50,000.00 100,000.00 .00 ( 100,000.00) .0 TOTAL TRANSFERS IN 50,000.00 100,000.00 .00 ( 100,000.00) .0 TOTAL EMPLOYEE HEALTH CARE - REVENUE 179,590.02 1,722,524.62 1,530,500.00 ( 192,024.62) 112.6 TOTAL FUND REVENUE 179,590.02 1,722,524.62 1,530,500.00 ( 192,024.62) 112.6 EMPLOYEE HEALTH CARE CASH FUND APPROPRIATION: 39-5390-0150 REPLACEMENT RESERVE 50,000.00 100,000.00 100,000.00 .00 100.0 TOTAL CASH FUND APPROP 50,000.00 100,000.00 100,000.00 .00 100.0 EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM 32,826.10 415,158.44 275,000.00 ( 140,158.44) 151.0 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 143,036.42 1,372,852.22 1,100,000.00 ( 272,852.22) 124.8 39-5390-1058 HEALTH CARE - FEE 7,116.45 90,264.73 100,000.00 9,735.27 90.3 TOTAL EMPLOYEE BENEFITS 182,978.97 1,878,275.39 1,475,000.00 ( 403,275.39) 127.3 TOTAL EMPLOYEE HEALTH CARE 232,978.97 1,978,275.39 1,575,000.00 ( 403,275.39) 125.6 TOTAL FUND EXPENDITURES 232,978.97 1,978,275.39 1,575,000.00 ( 403,275.39) 125.6 NET REVENUE OVER EXPENDITURES ( 53,388.95) ( 255,750.77) ( 44,500.00) 211,250.77 ( 574.7) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:40PM PAGE:59 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 25,123.91 TOTAL CASH 25,123.91 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 327,837.41 TOTAL INVESTMENTS 327,837.41 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 591.35 TOTAL ACCOUNTS RECEIVABLE 591.35 TOTAL CURRENT ASSETS 353,552.67 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 353,552.67 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 348,487.28 TOTAL CAPITAL ASSETS 348,487.28 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 5,065.39 BALANCE - CURRENT DATE 353,552.67 TOTAL NET ASSETS 353,552.67 TOTAL LIABILITIES AND NET ASSETS 353,552.67 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:40PM PAGE:60 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 6.41 5,065.39 4,500.00 ( 565.39) 112.6 TOTAL MISC LOCAL REVENUE 6.41 5,065.39 4,500.00 ( 565.39) 112.6 TOTAL CAPITAL IMP RESERVE - REVENUE 6.41 5,065.39 4,500.00 ( 565.39) 112.6 TOTAL FUND REVENUE 6.41 5,065.39 4,500.00 ( 565.39) 112.6 NET REVENUE OVER EXPENDITURES 6.41 5,065.39 4,500.00 ( 565.39) 112.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:40PM PAGE:61 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 168,630.66 TOTAL CASH 168,630.66 INVESTMENTS: 41-10000122 TIME DEPOSITS-SHORT TERM 183,487.69 TOTAL INVESTMENTS 183,487.69 TOTAL CURRENT ASSETS 352,118.35 NON-CURRENT ASSETS: INVESTMENTS: 41-10000172 TIME DEPOSITS - EOY 862.23 TOTAL INVESTMENTS 862.23 TOTAL NON-CURRENT ASSETS 862.23 TOTAL ASSETS 352,980.58 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 41-30000300 FUND BALANCE/BEGINNING OF YEAR 357,548.24 TOTAL CAPITAL ASSETS 357,548.24 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 4,567.66) BALANCE - CURRENT DATE 352,980.58 TOTAL NET ASSETS 352,980.58 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:40PM PAGE:62 TOTAL LIABILITIES AND NET ASSETS 352,980.58 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:40PM PAGE:63 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 43.03 3,972.84 3,000.00 ( 972.84) 132.4 TOTAL MISC LOCAL REVENUE 43.03 3,972.84 3,000.00 ( 972.84) 132.4 TOTAL ECONOMIC DEVELOPMENT 43.03 3,972.84 3,000.00 ( 972.84) 132.4 TOTAL FUND REVENUE 43.03 3,972.84 3,000.00 ( 972.84) 132.4 ECONOMIC DEVELOPMENT PROFESSIONAL SERVICES: 41-5410-2158 MISC CONTRACTUAL SERVICES .00 8,540.50 43,869.00 35,328.50 19.5 TOTAL PROFESSIONAL SERVICES .00 8,540.50 43,869.00 35,328.50 19.5 TOTAL ECONOMIC DEVELOPMENT .00 8,540.50 43,869.00 35,328.50 19.5 TOTAL FUND EXPENDITURES .00 8,540.50 43,869.00 35,328.50 19.5 NET REVENUE OVER EXPENDITURES 43.03 ( 4,567.66) ( 40,869.00) ( 36,301.34) ( 11.2) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 BROWNFIELD GRANT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:41PM PAGE:64 ASSETS CURRENT ASSETS: CASH: 42-10000116 CASH ALLOC FR COMBINED FUND ( 27,489.55) TOTAL CASH ( 27,489.55) ACCOUNTS RECEIVABLE: 42-10000131 ACCOUNTS RECEIVABLE - GENERAL 36,499.34 TOTAL ACCOUNTS RECEIVABLE 36,499.34 TOTAL CURRENT ASSETS 9,009.79 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 9,009.79 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 42-20000201 ACCOUNTS PAY ALLOC TO FUNDS 9,009.79 TOTAL ACCOUNTS PAYABLE 9,009.79 TOTAL CURRENT LIABILITIES 9,009.79 TOTAL LIABILITIES 9,009.79 TOTAL LIABILITIES AND NET ASSETS 9,009.79 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:41PM PAGE:65 BROWNFIELD HAZARDOUS - REVENUE FEDERAL REVENUE SOURCES: 42-4870-4281 EPA 24,673.03 41,276.06 60,429.00 19,152.94 68.3 TOTAL FEDERAL REVENUE SOURCES 24,673.03 41,276.06 60,429.00 19,152.94 68.3 TOTAL BROWNFIELD HAZARDOUS - REVENUE 24,673.03 41,276.06 60,429.00 19,152.94 68.3 BROWNFIELD PETROLEUM - REVENUE FEDERAL REVENUE SOURCES: 42-4871-4281 EPA 11,826.31 23,238.07 53,524.00 30,285.93 43.4 TOTAL FEDERAL REVENUE SOURCES 11,826.31 23,238.07 53,524.00 30,285.93 43.4 TOTAL BROWNFIELD PETROLEUM - REVENUE 11,826.31 23,238.07 53,524.00 30,285.93 43.4 TOTAL FUND REVENUE 36,499.34 64,514.13 113,953.00 49,438.87 56.6 BROWNFIELD HAZARDOUS PURCHASED SERVICES: 42-5870-2123 MEALS/LODGING/TRAVEL .00 .00 1,970.00 1,970.00 .0 TOTAL PURCHASED SERVICES .00 .00 1,970.00 1,970.00 .0 PROFESSIONAL SERVICES: 42-5870-2158 MISC CONTRACTUAL SERVICES 1,314.58 41,276.06 58,459.00 17,182.94 70.6 TOTAL PROFESSIONAL SERVICES 1,314.58 41,276.06 58,459.00 17,182.94 70.6 TOTAL BROWNFIELD HAZARDOUS 1,314.58 41,276.06 60,429.00 19,152.94 68.3 BROWNFIELD PETROLEUM PURCHASED SERVICES: 42-5871-2123 MEALS/LODGING/TRAVEL .00 .00 1,970.00 1,970.00 .0 TOTAL PURCHASED SERVICES .00 .00 1,970.00 1,970.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:41PM PAGE:66 PROFESSIONAL SERVICES: 42-5871-2158 MISC CONTRACTUAL SERVICES 7,695.21 23,238.07 51,554.00 28,315.93 45.1 TOTAL PROFESSIONAL SERVICES 7,695.21 23,238.07 51,554.00 28,315.93 45.1 TOTAL BROWNFIELD PETROLEUM 7,695.21 23,238.07 53,524.00 30,285.93 43.4 TOTAL FUND EXPENDITURES 9,009.79 64,514.13 113,953.00 49,438.87 56.6 NET REVENUE OVER EXPENDITURES 27,489.55 .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:41PM PAGE:67 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND 33,997.55 TOTAL CASH 33,997.55 ACCOUNTS RECEIVABLE: 47-10000139 ACCRUED INTEREST RECEIVABLE 213.78 TOTAL ACCOUNTS RECEIVABLE 213.78 TOTAL CURRENT ASSETS 34,211.33 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 34,211.33 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR ( 22,214.07) 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS 199,026.80 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 164,815.47) BALANCE - CURRENT DATE 34,211.33 TOTAL NET ASSETS 34,211.33 TOTAL LIABILITIES AND NET ASSETS 34,211.33 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:41PM PAGE:68 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME .00 1,912.25 1,000.00 ( 912.25) 191.2 TOTAL MISC LOCAL REVENUE .00 1,912.25 1,000.00 ( 912.25) 191.2 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND .00 .00 353,662.00 353,662.00 .0 TOTAL TRANSFERS IN .00 .00 353,662.00 353,662.00 .0 TOTAL GENERAL FUND EQUIP RES-REVENUE .00 1,912.25 354,662.00 352,749.75 .5 TOTAL FUND REVENUE .00 1,912.25 354,662.00 352,749.75 .5 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE .00 166,727.72 256,133.00 89,405.28 65.1 47-5470-6548 VEHICLES .00 .00 160,856.00 160,856.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 166,727.72 416,989.00 250,261.28 40.0 TOTAL GENERAL FUND EQUIPMENT RESERVE .00 166,727.72 416,989.00 250,261.28 40.0 TOTAL FUND EXPENDITURES .00 166,727.72 416,989.00 250,261.28 40.0 NET REVENUE OVER EXPENDITURES .00 ( 164,815.47) ( 62,327.00) 102,488.47 ( 264.4) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:46PM PAGE:69 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 585,008.17 TOTAL CASH 585,008.17 INVESTMENTS: 50-10000120 INVESTMENT POOL ( 8.10) TOTAL INVESTMENTS ( 8.10) TOTAL CURRENT ASSETS 585,000.07 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 585,000.07 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR 227,462.14 50-30000301 RESERVED FUND BALANCE 255,959.63 TOTAL CAPITAL ASSETS 483,421.77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 101,578.30 BALANCE - CURRENT DATE 585,000.07 TOTAL NET ASSETS 585,000.07 TOTAL LIABILITIES AND NET ASSETS 585,000.07 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:46PM PAGE:70 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1140 INTEREST INCOME 136.53 1,578.30 300.00 ( 1,278.30) 526.1 TOTAL MISC LOCAL REVENUE 136.53 1,578.30 300.00 ( 1,278.30) 526.1 TRANSFERS IN: 50-4500-5510 TRANSFER FROM GENERAL FUND 50,000.00 100,000.00 100,000.00 .00 100.0 TOTAL TRANSFERS IN 50,000.00 100,000.00 100,000.00 .00 100.0 TOTAL FIRE EQUIPMENT - REVENUE 50,136.53 101,578.30 100,300.00 ( 1,278.30) 101.3 TOTAL FUND REVENUE 50,136.53 101,578.30 100,300.00 ( 1,278.30) 101.3 FIRE EQUIPMENT CAPITALIZED EXPENDITURES: 50-5500-6548 BUILDINGS .00 .00 100,000.00 100,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 100,000.00 100,000.00 .0 TOTAL FIRE EQUIPMENT .00 .00 100,000.00 100,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 100,000.00 100,000.00 .0 NET REVENUE OVER EXPENDITURES 50,136.53 101,578.30 300.00 ( 101,278.30) 33859.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:53PM PAGE:71 ASSETS CURRENT ASSETS: CASH: 53-10000116 CASH ALLOC FR COMBINED FUND 5,851.66 TOTAL CASH 5,851.66 TOTAL CURRENT ASSETS 5,851.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 5,851.66 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 53-30000300 FUND BALANCE/BEGINNING OF YEAR 2,811.66 TOTAL CAPITAL ASSETS 2,811.66 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,040.00 BALANCE - CURRENT DATE 5,851.66 TOTAL NET ASSETS 5,851.66 TOTAL LIABILITIES AND NET ASSETS 5,851.66 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 CPTL PROJ - CLG PROJECTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:53PM PAGE:72 HISTORIC DISTRICT - REVENUE STATE REVENUE: 53-4809-3973 CERTIFIED LOCAL GOVERNMENT .00 1,740.00 5,700.00 3,960.00 30.5 TOTAL STATE REVENUE .00 1,740.00 5,700.00 3,960.00 30.5 TRANSFERS IN: 53-4809-5510 TRANSFER FROM GENERAL FUND 2,150.00 4,300.00 4,300.00 .00 100.0 TOTAL TRANSFERS IN 2,150.00 4,300.00 4,300.00 .00 100.0 TOTAL HISTORIC DISTRICT - REVENUE 2,150.00 6,040.00 10,000.00 3,960.00 60.4 TOTAL FUND REVENUE 2,150.00 6,040.00 10,000.00 3,960.00 60.4 HISTORIC DISTRICT PROFESSIONAL SERVICES: 53-5809-2158 MISC CONTRACTUAL SERVICES .00 3,000.00 10,000.00 7,000.00 30.0 TOTAL PROFESSIONAL SERVICES .00 3,000.00 10,000.00 7,000.00 30.0 TOTAL HISTORIC DISTRICT .00 3,000.00 10,000.00 7,000.00 30.0 TOTAL FUND EXPENDITURES .00 3,000.00 10,000.00 7,000.00 30.0 NET REVENUE OVER EXPENDITURES 2,150.00 3,040.00 .00 ( 3,040.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:54PM PAGE:73 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 38,119.90 TOTAL CASH 38,119.90 TOTAL CURRENT ASSETS 38,119.90 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 38,119.90 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 38,979.90 TOTAL CAPITAL ASSETS 38,979.90 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 860.00) BALANCE - CURRENT DATE 38,119.90 TOTAL NET ASSETS 38,119.90 TOTAL LIABILITIES AND NET ASSETS 38,119.90 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:54PM PAGE:74 TRAIN CAR RESTORATION TRANSFERS IN: 54-4540-5510 TRANSFER FROM GENERAL FUND 12,500.00 25,000.00 25,000.00 .00 100.0 TOTAL TRANSFERS IN 12,500.00 25,000.00 25,000.00 .00 100.0 TOTAL TRAIN CAR RESTORATION 12,500.00 25,000.00 25,000.00 .00 100.0 TOTAL FUND REVENUE 12,500.00 25,000.00 25,000.00 .00 100.0 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE .00 25,860.00 25,000.00 ( 860.00) 103.4 TOTAL PROFESSIONAL SERVICES .00 25,860.00 25,000.00 ( 860.00) 103.4 TOTAL TRAIN CAR RESTORATION .00 25,860.00 25,000.00 ( 860.00) 103.4 TOTAL FUND EXPENDITURES .00 25,860.00 25,000.00 ( 860.00) 103.4 NET REVENUE OVER EXPENDITURES 12,500.00 ( 860.00) .00 860.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:55PM PAGE:75 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 35,914.06 TOTAL CASH 35,914.06 INVESTMENTS: 55-10000122 TIME DEPOSITS - SHORT TERM 239,008.09 TOTAL INVESTMENTS 239,008.09 ACCOUNTS RECEIVABLE: 55-10000139 ACCRUED INTEREST RECEIVABLE 229.38 TOTAL ACCOUNTS RECEIVABLE 229.38 TOTAL CURRENT ASSETS 275,151.53 NON-CURRENT ASSETS: INVESTMENTS: 55-10000172 TIME DEPOSITS - EOY 615.88 TOTAL INVESTMENTS 615.88 TOTAL NON-CURRENT ASSETS 615.88 TOTAL ASSETS 275,767.41 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 257,040.61 TOTAL CAPITAL ASSETS 257,040.61 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:55PM PAGE:76 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 18,726.80 BALANCE - CURRENT DATE 275,767.41 TOTAL NET ASSETS 275,767.41 TOTAL LIABILITIES AND NET ASSETS 275,767.41 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:55PM PAGE:77 POOL IMPROVEMENTS - REVENUE MISC LOCAL REVENUE: 55-4550-1140 INTEREST INCOME .00 4,960.80 2,000.00 ( 2,960.80) 248.0 TOTAL MISC LOCAL REVENUE .00 4,960.80 2,000.00 ( 2,960.80) 248.0 TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND 81,250.00 162,500.00 162,500.00 .00 100.0 TOTAL TRANSFERS IN 81,250.00 162,500.00 162,500.00 .00 100.0 TOTAL POOL IMPROVEMENTS - REVENUE 81,250.00 167,460.80 164,500.00 ( 2,960.80) 101.8 TOTAL FUND REVENUE 81,250.00 167,460.80 164,500.00 ( 2,960.80) 101.8 POOL IMPROVEMENTS PROFESSIONAL SERVICES: 55-5550-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 10,000.00 10,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 10,000.00 10,000.00 .0 CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG .00 148,734.00 152,500.00 3,766.00 97.5 TOTAL CAPITALIZED EXPENDITURES .00 148,734.00 152,500.00 3,766.00 97.5 TOTAL POOL IMPROVEMENTS .00 148,734.00 162,500.00 13,766.00 91.5 TOTAL FUND EXPENDITURES .00 148,734.00 162,500.00 13,766.00 91.5 NET REVENUE OVER EXPENDITURES 81,250.00 18,726.80 2,000.00 ( 16,726.80) 936.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:57PM PAGE:78 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 6,821,503.79 TOTAL CASH 6,821,503.79 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 11,712,551.82 TOTAL INVESTMENTS 11,712,551.82 ACCOUNTS RECEIVABLE: 56-10000139 ACCRUED INTEREST RECEIVABLE 6,447.50 TOTAL ACCOUNTS RECEIVABLE 6,447.50 TOTAL CURRENT ASSETS 18,540,503.11 NON-CURRENT ASSETS: INVESTMENTS: 56-10000172 TIME DEPOSITS - EOY 17,965.11 TOTAL INVESTMENTS 17,965.11 TOTAL NON-CURRENT ASSETS 17,965.11 TOTAL ASSETS 18,558,468.22 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 841,365.09 56-20000210 RETAINAGE PAYABLE 40,968.82 TOTAL ACCOUNTS PAYABLE 882,333.91 TOTAL CURRENT LIABILITIES 882,333.91 TOTAL LIABILITIES 882,333.91 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:57PM PAGE:79 CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 14,145,615.81 TOTAL CAPITAL ASSETS 14,145,615.81 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,530,518.50 BALANCE - CURRENT DATE 17,676,134.31 TOTAL NET ASSETS 17,676,134.31 TOTAL LIABILITIES AND NET ASSETS 18,558,468.22 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 04:57PM PAGE:80 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1140 INTEREST INCOME 5,749.60 128,978.17 65,000.00 ( 63,978.17) 198.4 TOTAL MISC LOCAL REVENUE 5,749.60 128,978.17 65,000.00 ( 63,978.17) 198.4 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND 2,950,000.00 5,900,000.00 5,850,000.00 ( 50,000.00) 100.9 TOTAL TRANSFERS IN 2,950,000.00 5,900,000.00 5,850,000.00 ( 50,000.00) 100.9 TOTAL STREET IMPROVEMENTS-REVENUE 2,955,749.60 6,028,978.17 5,915,000.00 ( 113,978.17) 101.9 TOTAL FUND REVENUE 2,955,749.60 6,028,978.17 5,915,000.00 ( 113,978.17) 101.9 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 49,566.56 247,458.51 897,000.00 649,541.49 27.6 56-5560-2158 MISC CONTRACTUAL SERVICES .00 48,364.84 55,000.00 6,635.16 87.9 TOTAL PROFESSIONAL SERVICES 49,566.56 295,823.35 952,000.00 656,176.65 31.1 CAPITALIZED EXPENDITURES: 56-5560-6540 LAND .00 40,814.00 .00 ( 40,814.00) .0 56-5560-6544 OTHER THAN BLDG 806,345.53 2,161,822.32 4,986,540.00 2,824,717.68 43.4 TOTAL CAPITALIZED EXPENDITURES 806,345.53 2,202,636.32 4,986,540.00 2,783,903.68 44.2 TOTAL STREET IMPROVEMENTS 855,912.09 2,498,459.67 5,938,540.00 3,440,080.33 42.1 TOTAL FUND EXPENDITURES 855,912.09 2,498,459.67 5,938,540.00 3,440,080.33 42.1 NET REVENUE OVER EXPENDITURES 2,099,837.51 3,530,518.50 ( 23,540.00) ( 3,554,058.50) 14998.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:00PM PAGE:81 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 2,252,034.99 TOTAL CASH 2,252,034.99 INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 1,288,112.03 TOTAL INVESTMENTS 1,288,112.03 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 2,250.10 TOTAL ACCOUNTS RECEIVABLE 2,250.10 TOTAL CURRENT ASSETS 3,542,397.12 NON-CURRENT ASSETS: INVESTMENTS: 57-10000172 TIME DEPOSITS - EOY 985.41 TOTAL INVESTMENTS 985.41 TOTAL NON-CURRENT ASSETS 985.41 TOTAL ASSETS 3,543,382.53 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 30,828.45 57-20000210 RETAINAGE PAYABLE 10,782.37 TOTAL ACCOUNTS PAYABLE 41,610.82 TOTAL CURRENT LIABILITIES 41,610.82 TOTAL LIABILITIES 41,610.82 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:00PM PAGE:82 CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 3,440,400.25 TOTAL CAPITAL ASSETS 3,440,400.25 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 61,371.46 BALANCE - CURRENT DATE 3,501,771.71 TOTAL NET ASSETS 3,501,771.71 TOTAL LIABILITIES AND NET ASSETS 3,543,382.53 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:00PM PAGE:83 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME .00 28,702.73 10,000.00 ( 18,702.73) 287.0 TOTAL MISC LOCAL REVENUE .00 28,702.73 10,000.00 ( 18,702.73) 287.0 TRANSFERS IN: 57-4570-5510 TRANSFER FROM GENERAL FUND 109,000.00 218,000.00 218,000.00 .00 100.0 TOTAL TRANSFERS IN 109,000.00 218,000.00 218,000.00 .00 100.0 TOTAL CAPITAL IMP - FACILITIES REV 109,000.00 246,702.73 228,000.00 ( 18,702.73) 108.2 TOTAL FUND REVENUE 109,000.00 246,702.73 228,000.00 ( 18,702.73) 108.2 CAPITAL IMP -FACILITIES CAPITALIZED EXPENDITURES: 57-5570-6544 OTHER THAN BLDG 32,451.00 185,331.27 218,000.00 32,668.73 85.0 TOTAL CAPITALIZED EXPENDITURES 32,451.00 185,331.27 218,000.00 32,668.73 85.0 TOTAL CAPITAL IMP -FACILITIES 32,451.00 185,331.27 218,000.00 32,668.73 85.0 TOTAL FUND EXPENDITURES 32,451.00 185,331.27 218,000.00 32,668.73 85.0 NET REVENUE OVER EXPENDITURES 76,549.00 61,371.46 10,000.00 ( 51,371.46) 613.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:10PM PAGE:84 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 1,155,735.17 TOTAL CASH 1,155,735.17 INVESTMENTS: 65-10000120 INVESTMENT POOL 580,907.54 65-10000122 TIME DEPOSITS - SHORT TERM 1,855,824.71 TOTAL INVESTMENTS 2,436,732.25 ACCOUNTS RECEIVABLE: 65-10000131 ACCOUNTS RECEIVABLE 11,000.00 65-10000139 ACCRUED INTEREST RECEIVABLE 3,360.39 TOTAL ACCOUNTS RECEIVABLE 14,360.39 TOTAL CURRENT ASSETS 3,606,827.81 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,606,827.81 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 59,885.85 TOTAL ACCOUNTS PAYABLE 59,885.85 TOTAL CURRENT LIABILITIES 59,885.85 TOTAL LIABILITIES 59,885.85 NET ASSETS CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 3,413,690.98 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 3,436,606.87 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:10PM PAGE:85 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 110,335.09 BALANCE - CURRENT DATE 3,546,941.96 TOTAL NET ASSETS 3,546,941.96 TOTAL LIABILITIES AND NET ASSETS 3,606,827.81 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:10PM PAGE:86 PARK - REVE REVENUE: 65-4650-0160 GAIN ON INVESTMENTS ( 7,967.63) ( 29,964.57) .00 29,964.57 .0 TOTAL REVENUE ( 7,967.63) ( 29,964.57) .00 29,964.57 .0 MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME 1,469.55 26,656.86 10,000.00 ( 16,656.86) 266.6 TOTAL MISC LOCAL REVENUE 1,469.55 26,656.86 10,000.00 ( 16,656.86) 266.6 STATE REVENUE: 65-4650-3370 WY BUSINESS COUNCIL 11,000.00 11,000.00 11,000.00 .00 100.0 TOTAL STATE REVENUE 11,000.00 11,000.00 11,000.00 .00 100.0 TRANSFERS IN: 65-4650-5510 TRANSFER FROM GENERAL FUND 175,092.00 291,342.00 191,342.00 ( 100,000.00) 152.3 TOTAL TRANSFERS IN 175,092.00 291,342.00 191,342.00 ( 100,000.00) 152.3 TOTAL PARK - REVE 179,593.92 299,034.29 212,342.00 ( 86,692.29) 140.8 TOTAL FUND REVENUE 179,593.92 299,034.29 212,342.00 ( 86,692.29) 140.8 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY .00 15,000.00 15,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 15,000.00 15,000.00 .00 100.0 OPERATING TRANSFERS: 65-5650-4345 INVESTMENT FEES 49.80 452.38 500.00 47.62 90.5 TOTAL OPERATING TRANSFERS 49.80 452.38 500.00 47.62 90.5 CAPITALIZED EXPENDITURES: 65-5650-6544 OTHER THAN BLDG 59,885.85 173,246.82 411,893.00 238,646.18 42.1 TOTAL CAPITALIZED EXPENDITURES 59,885.85 173,246.82 411,893.00 238,646.18 42.1 TOTAL PARK IMPROVEMENTS 59,935.65 188,699.20 427,393.00 238,693.80 44.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:11PM PAGE:87 TOTAL FUND EXPENDITURES 59,935.65 188,699.20 427,393.00 238,693.80 44.2 NET REVENUE OVER EXPENDITURES 119,658.27 110,335.09 ( 215,051.00) ( 325,386.09) 51.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:29PM PAGE:88 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 8,708.90 TOTAL CASH 8,708.90 INVESTMENTS: 90-10000120 INVESTMENT POOL 107,164.98 90-10000122 TIME DEPOSITS - SHORT TERM 63,543.46 TOTAL INVESTMENTS 170,708.44 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 59.28 TOTAL ACCOUNTS RECEIVABLE 59.28 TOTAL CURRENT ASSETS 179,476.62 NON-CURRENT ASSETS: INVESTMENTS: 90-10000172 TIME DEPOSITS - EOY 172.45 TOTAL INVESTMENTS 172.45 TOTAL NON-CURRENT ASSETS 172.45 TOTAL ASSETS 179,649.07 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 34,163.67 TOTAL CAPITAL ASSETS 34,163.67 RESTRICTED ASSETS: 90-30000315 FUND BALANCE RESTRICTED 141,610.40 TOTAL RESTRICTED ASSETS 141,610.40 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:29PM PAGE:89 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,875.00 BALANCE - CURRENT DATE 179,649.07 TOTAL NET ASSETS 179,649.07 TOTAL LIABILITIES AND NET ASSETS 179,649.07 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:29PM PAGE:90 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES 500.00 3,875.00 1,500.00 ( 2,375.00) 258.3 TOTAL REVENUE 500.00 3,875.00 1,500.00 ( 2,375.00) 258.3 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 85.42 1,659.04 1,000.00 ( 659.04) 165.9 TOTAL MISC LOCAL REVENUE 85.42 1,659.04 1,000.00 ( 659.04) 165.9 TOTAL PERPETUAL CARE - REVENUE 585.42 5,534.04 2,500.00 ( 3,034.04) 221.4 TOTAL FUND REVENUE 585.42 5,534.04 2,500.00 ( 3,034.04) 221.4 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 696.09 1,659.04 .00 ( 1,659.04) .0 TOTAL TRANSFERS TO OTHER FUNDS 696.09 1,659.04 .00 ( 1,659.04) .0 TOTAL PERPETUAL CARE 696.09 1,659.04 .00 ( 1,659.04) .0 TOTAL FUND EXPENDITURES 696.09 1,659.04 .00 ( 1,659.04) .0 NET REVENUE OVER EXPENDITURES ( 110.67) 3,875.00 2,500.00 ( 1,375.00) 155.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:29PM PAGE:91 ASSETS CURRENT ASSETS: CASH: 91-10000116 CASH ALLOC FR COMBINED FUND 2.75 TOTAL CASH 2.75 TOTAL CURRENT ASSETS 2.75 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2.75 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 91-20000401 ONGOING MEMORIAL FUND 2.75 TOTAL OTHER PAYABLES 2.75 TOTAL CURRENT LIABILITIES 2.75 TOTAL LIABILITIES 2.75 TOTAL LIABILITIES AND NET ASSETS 2.75 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:30PM PAGE:92 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 21,871.24 TOTAL CASH 21,871.24 TOTAL CURRENT ASSETS 21,871.24 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 21,871.24 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 92-20000201 ACCOUNTS PAY ALLOC TO FUNDS 276.48 TOTAL ACCOUNTS PAYABLE 276.48 OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 3,878.33 92-20000406 HISTORIC PRESERVATION 3,301.20 92-20000407 HISTORIC PRESERVATION-KIOSK 16,789.30 92-20000408 HISTORIC PRESERVATION - MOVIE 615.38 TOTAL OTHER PAYABLES 24,584.21 TOTAL CURRENT LIABILITIES 24,860.69 TOTAL LIABILITIES 24,860.69 NET ASSETS CAPITAL ASSETS: 92-30000300 FUND BALANCE/BEGINNING OF YEAR ( 6,512.97) TOTAL CAPITAL ASSETS ( 6,512.97) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:30PM PAGE:93 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,523.52 BALANCE - CURRENT DATE ( 2,989.45) TOTAL NET ASSETS ( 2,989.45) TOTAL LIABILITIES AND NET ASSETS 21,871.24 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:30PM PAGE:94 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 1,900.00 3,800.00 3,800.00 .00 100.0 TOTAL TRANSFERS IN 1,900.00 3,800.00 3,800.00 .00 100.0 TOTAL HISTORIC CMSN - REVENU 1,900.00 3,800.00 3,800.00 .00 100.0 TOTAL FUND REVENUE 1,900.00 3,800.00 3,800.00 .00 100.0 HISTORIC PRESERVATION PROFESSIONAL SERVICES: 92-5920-2158 MISC CONTRACTUAL SERVICES 276.48 276.48 3,800.00 3,523.52 7.3 TOTAL PROFESSIONAL SERVICES 276.48 276.48 3,800.00 3,523.52 7.3 TOTAL HISTORIC PRESERVATION 276.48 276.48 3,800.00 3,523.52 7.3 TOTAL FUND EXPENDITURES 276.48 276.48 3,800.00 3,523.52 7.3 NET REVENUE OVER EXPENDITURES 1,623.52 3,523.52 .00 ( 3,523.52) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:30PM PAGE:95 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 4,358.86 TOTAL CASH 4,358.86 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 90,150.06 TOTAL INVESTMENTS 90,150.06 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 92.38 TOTAL ACCOUNTS RECEIVABLE 92.38 TOTAL CURRENT ASSETS 94,601.30 NON-CURRENT ASSETS: INVESTMENTS: 96-10000172 TIME DEPOSITS - EOY 221.72 TOTAL INVESTMENTS 221.72 TOTAL NON-CURRENT ASSETS 221.72 TOTAL ASSETS 94,823.02 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 686.17 TOTAL ACCOUNTS PAYABLE 686.17 OTHER LIABILITIES PAYABLE: 96-20000229 UTILITY DEPOSITS 84,736.09 TOTAL OTHER LIABILITIES PAYABLE 84,736.09 TOTAL CURRENT LIABILITIES 85,422.26 TOTAL LIABILITIES 85,422.26 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:30PM PAGE:96 CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 7,621.04 TOTAL CAPITAL ASSETS 7,621.04 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,779.72 BALANCE - CURRENT DATE 9,400.76 TOTAL NET ASSETS 9,400.76 TOTAL LIABILITIES AND NET ASSETS 94,823.02 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:30PM PAGE:97 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME .00 1,779.72 .00 ( 1,779.72) .0 TOTAL MISC LOCAL REVENUE .00 1,779.72 .00 ( 1,779.72) .0 TOTAL UTILITY DEPOSITS - REVENUE .00 1,779.72 .00 ( 1,779.72) .0 TOTAL FUND REVENUE .00 1,779.72 .00 ( 1,779.72) .0 NET REVENUE OVER EXPENDITURES .00 1,779.72 .00 ( 1,779.72) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2022 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:31PM 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 6,330,574.12 97-10000174 INVESTMENTS - RHSA 543,468.41 TOTAL INVESTMENTS 6,874,042.53 TOTAL NON-CURRENT ASSETS 6,874,042.53 TOTAL ASSETS 6,874,082.14 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 97-30000300 FUND BALANCE/BEGINNING OF YEAR 6,874,042.53 TOTAL CAPITAL ASSETS 6,874,042.53 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 39.61 BALANCE - CURRENT DATE 6,874,082.14 TOTAL NET ASSETS 6,874,082.14 TOTAL LIABILITIES AND NET ASSETS 6,874,082.14 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2022 DEFERRED COMP TRUST FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/16/2022 05:31PM PAGE:99 MISC LOCAL REVENUE: 97-4970-1140 INVESTMENT INCOME - 457 .00 39.61 .00 ( 39.61) .0 TOTAL MISC LOCAL REVENUE .00 39.61 .00 ( 39.61) .0 .00 39.61 .00 ( 39.61) .0 TOTAL FUND REVENUE .00 39.61 .00 ( 39.61) .0 NET REVENUE OVER EXPENDITURES .00 39.61 .00 ( 39.61) .0