Document Douglas_doc_51895c29ed

CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2021 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:48AM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 19,096,670.63 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 137,129.32 01-10000106 CASH - XPRESS DEPOSIT ACCOUNT 272,219.70 01-10000113 CASH ON HAND 575.00 TOTAL COMBINED CASH 19,506,594.65 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 19,506,594.65) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 3 ALLOCATION TO ACCOUNTS PAYABLE FUND 122,066.24 10 ALLOCATION TO GENERAL FUND 4,953,126.23 11 ALLOCATION TO IMPACT ASSISTANCE FUND 566,636.38 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 21,664.99 31 ALLOCATION TO WATER FUND 4,301,023.15 32 ALLOCATION TO SEWER FUND 440,933.60 33 ALLOCATION TO SANITATION FUND 605,401.80 34 ALLOCATION TO LANDFILL FUND 491,829.97 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 663,253.21 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 25,047.09 41 ALLOCATION TO ECONOMIC DEVELOPMENT 181,643.58 42 ALLOCATION TO BROWNFIELD GRANT ( 2,400.67) 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE 94,064.19 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 483,421.77 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 1,121.66 54 ALLOCATION TO TRAIN CAR RESTORATION 38,979.90 55 ALLOCATION TO POOL IMPROVEMENTS FUND 22,148.06 56 ALLOCATION TO STREET IMPROVEMENT FUND 4,283,592.61 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 755,863.82 65 ALLOCATION TO CAPTL PROJ-PARK FUND 1,425,729.91 90 ALLOCATION TO PERPETUAL CARE FUND 6,225.51 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 2.75 92 ALLOCATION TO HISTORIC CMSN FUND 17,826.56 96 ALLOCATION TO UTILITY DEPOSIT FUND 7,392.34 TOTAL ALLOCATIONS TO OTHER FUNDS 19,506,594.65 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 19,506,594.65) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS PAYABLES CLEARING FUND ALLOCATIONS JUNE 30, 2021 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:48AM PAGE:2 PAYROLL PAYABLES 03-20000215 WAGES PAYABLE - CLEARING 122,066.24 TOTAL PAYROLL PAYABLES 122,066.24 TOTAL UNALLOCATED PAYROLL PAYABLES 122,066.24 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, 2021 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:48AM PAGE:3 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 4,953,126.23 TOTAL CASH 4,953,126.23 INVESTMENTS: 10-10000120 INVESTMENT POOL 9,246,961.76 10-10000122 TIME DEPOSITS - SHORT TERM 18,717,964.42 TOTAL INVESTMENTS 27,964,926.18 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 121,450.99 10-10000131 ACCOUNTS RECEIVABLE - GENERAL 12,542.25 10-10000132 ACCOUNTS REC - PROPERTY TAX 519,714.53 10-10000133 ACCOUNTS CRT 2,767.55 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 1,400,361.24 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 585.24 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 6,177.05) 10-10000139 ACCRUED INTEREST RECEIVABLE 44,622.07 TOTAL ACCOUNTS RECEIVABLE 2,095,866.82 TOTAL CURRENT ASSETS 35,013,919.23 NON-CURRENT ASSETS: INVESTMENTS: 10-10000170 PREPAID EXPENSE 43,529.00 TOTAL INVESTMENTS 43,529.00 TOTAL NON-CURRENT ASSETS 43,529.00 TOTAL ASSETS 35,057,448.23 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:48AM PAGE:4 ACCOUNTS PAYABLE: 10-20000200 DEFERRED INFLOW 465,668.86 10-20000201 ALLOCATION FROM AP FUND 308,584.32 10-20000204 ACCOUNTS PAYABLE - EOY ( 62,910.25) 10-20000207 SALES TAX PAYABLE 60.96 10-20000208 SURCHARGE PAYABLE ( 330.00) 10-20000212 SURCHARGE - CITY - E CITATION 1,145.00 10-20000213 DONATION-POLICE DEPARTMENT USE 1,140.04 10-20000215 WAGES PAYABLE 133,092.07 TOTAL ACCOUNTS PAYABLE 846,451.00 PAYROLL DEDUCTIONS PAYABLE: 10-20000222 FEDERAL WITHOLDING PAYABLE 13,408.94 10-20000223 FICA PAYABLE 23,913.82 10-20000224 DEFERRED COMPENSATION PAYABLE 83,643.00 10-20000225 INSURANCE PAYABLE 250.72 10-20000226 OTHER DEDUCTIONS PAYABLE 773.23 10-20000227 WORKERS COMP INS PAYABLE 26,441.98 TOTAL PAYROLL DEDUCTIONS PAYABLE 148,431.69 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 77,112.97 TOTAL DUE TO OTHER FUNDS 77,112.97 TOTAL CURRENT LIABILITIES 1,089,733.12 TOTAL LIABILITIES 1,089,733.12 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 27,267,099.29 10-30000301 FUND BALANCE RESERVE 3,170,000.00 TOTAL CAPITAL ASSETS 30,437,099.29 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,530,615.82 BALANCE - CURRENT DATE 33,967,715.11 TOTAL NET ASSETS 33,967,715.11 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:48AM PAGE:5 TOTAL LIABILITIES AND NET ASSETS 35,057,448.23 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:48AM PAGE:6 GENERAL - REVENUE REVENUE: 10-4100-0160 GAIN ON INVESTMENTS ( 34,804.38) ( 291,634.08) .00 291,634.08 .0 TOTAL REVENUE ( 34,804.38) ( 291,634.08) .00 291,634.08 .0 MISC LOCAL REVENUE: 10-4100-1101 REIMBURSEMENT - CCSD 9,533.14 49,489.35 62,313.00 12,823.65 79.4 10-4100-1107 OTHER 297.00 23,024.57 5,000.00 ( 18,024.57) 460.5 10-4100-1108 COPY FEES/VIN CHECKS 645.00 6,127.70 2,000.00 ( 4,127.70) 306.4 10-4100-1109 REIMBURSEMENTS 11,525.98 86,508.43 130,000.00 43,491.57 66.5 10-4100-1112 CONTRIBUTIONS .00 15,595.96 10,000.00 ( 5,595.96) 156.0 10-4100-1115 LEASES/RENT .00 4,620.00 4,500.00 ( 120.00) 102.7 10-4100-1120 FINES/FORFEITS 1,090.00 23,788.00 25,000.00 1,212.00 95.2 10-4100-1140 INTEREST INCOME 109,606.16 693,435.65 500,205.00 ( 193,230.65) 138.6 10-4100-1145 GAIN ON SALE OF FIXED ASSETS 140,906.38 140,906.38 .00 ( 140,906.38) .0 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 2,500.00 3,500.00 1,000.00 71.4 TOTAL MISC LOCAL REVENUE 273,603.66 1,045,996.04 742,518.00 ( 303,478.04) 140.9 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 215.00 23,154.81 20,000.00 ( 3,154.81) 115.8 TOTAL LIQUOR LICENSES 215.00 23,154.81 20,000.00 ( 3,154.81) 115.8 CONTRACTORS LICENSES: 10-4100-1241 LICENSES - CONTRACTORS 168.84 16,360.00 13,000.00 ( 3,360.00) 125.9 TOTAL CONTRACTORS LICENSES 168.84 16,360.00 13,000.00 ( 3,360.00) 125.9 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 6,283.77 75,427.28 17,500.00 ( 57,927.28) 431.0 TOTAL BUILDING PERMITS 6,283.77 75,427.28 17,500.00 ( 57,927.28) 431.0 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 325.00 2,895.00 2,000.00 ( 895.00) 144.8 TOTAL ZONING/CONDITIONAL USE 325.00 2,895.00 2,000.00 ( 895.00) 144.8 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 100,432.05 466,957.27 450,000.00 ( 16,957.27) 103.8 10-4100-1321 PROPERTY TAX - PRIOR YEARS 596.56 1,302.04 500.00 ( 802.04) 260.4 10-4100-1322 PROPERTY TAX - AUTO 16,019.00 193,418.97 170,000.00 ( 23,418.97) 113.8 10-4100-1323 PROPERTY TAX - INTEREST 128.03 1,649.25 1,000.00 ( 649.25) 164.9 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 585.84) ( 3,315.06) ( 2,000.00) 1,315.06 ( 165.8) TOTAL PROPERTY TAXES 116,589.80 660,012.47 619,500.00 ( 40,512.47) 106.5 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:48AM PAGE:7 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 16,276.90 223,972.10 225,000.00 1,027.90 99.5 10-4100-1331 FRANCHISE FEES - CABLE TV .00 13,190.01 14,000.00 809.99 94.2 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 35,698.26 30,000.00 ( 5,698.26) 119.0 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 8,465.82 5,000.00 ( 3,465.82) 169.3 TOTAL FRANCHISE FEES 16,276.90 281,326.19 274,000.00 ( 7,326.19) 102.7 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 28,680.75 114,723.00 114,723.00 .00 100.0 10-4100-1421 MANAGEMENT FEES - WATER 65,965.75 263,863.00 263,863.00 .00 100.0 10-4100-1422 MANAGEMENT FEES - SEWER 34,417.00 137,668.00 137,668.00 .00 100.0 10-4100-1423 MANAGEMENT FEES - SANITATION 13,623.50 54,494.00 54,494.00 .00 100.0 TOTAL MANAGEMENT FEES 142,687.00 570,748.00 570,748.00 .00 100.0 WEED ABATEMENT: 10-4100-1430 WEED MOWING CHARGES .00 207.84 .00 ( 207.84) .0 10-4100-1431 PEST CONTROL .00 14,620.50 14,000.00 ( 620.50) 104.4 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 50,562.77 35,000.00 ( 15,562.77) 144.5 TOTAL WEED ABATEMENT .00 65,391.11 49,000.00 ( 16,391.11) 133.5 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 3,450.00 14,750.00 10,000.00 ( 4,750.00) 147.5 TOTAL BURIAL FEES 3,450.00 14,750.00 10,000.00 ( 4,750.00) 147.5 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 1,600.00 7,500.00 5,000.00 ( 2,500.00) 150.0 TOTAL LOT SALES 1,600.00 7,500.00 5,000.00 ( 2,500.00) 150.0 POOL: 10-4100-1650 POOL - USER FEES .00 15,922.00 .00 ( 15,922.00) .0 TOTAL POOL .00 15,922.00 .00 ( 15,922.00) .0 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 202,623.01 202,546.00 ( 77.01) 100.0 10-4100-3111 SEVERENCE TAX - 2% 56,438.63 225,754.52 225,000.00 ( 754.52) 100.3 10-4100-3112 MINERAL ROYALTIES 71,925.64 359,388.06 300,000.00 ( 59,388.06) 119.8 TOTAL MINERAL EXTRACTION 128,364.27 787,765.59 727,546.00 ( 60,219.59) 108.3 SALES TAX: 10-4100-3241 SALES TAX - STATE 303,956.37 6,755,728.86 4,000,000.00 ( 2,755,728.86) 168.9 10-4100-3245 SALES TAX - LOCAL OPTION 250,711.33 5,521,476.71 3,500,000.00 ( 2,021,476.71) 157.8 TOTAL SALES TAX 554,667.70 12,277,205.57 7,500,000.00 ( 4,777,205.57) 163.7 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:8 GAS TAX: 10-4100-3250 LOTTERY .00 49,923.12 30,000.00 ( 19,923.12) 166.4 10-4100-3257 GAS TAX 14,476.80 234,334.67 200,000.00 ( 34,334.67) 117.2 10-4100-3258 SPECIAL FUELS 3,988.81 60,354.46 55,000.00 ( 5,354.46) 109.7 TOTAL GAS TAX 18,465.61 344,612.25 285,000.00 ( 59,612.25) 120.9 OTHER: 10-4100-3262 CIGARETTE TAX 3,268.94 45,070.96 45,000.00 ( 70.96) 100.2 TOTAL OTHER 3,268.94 45,070.96 45,000.00 ( 70.96) 100.2 STATE REVENUE: 10-4100-3374 SLIB ( 1,674,304.56) 1,379,416.71 1,378,202.00 ( 1,214.71) 100.1 TOTAL STATE REVENUE ( 1,674,304.56) 1,379,416.71 1,378,202.00 ( 1,214.71) 100.1 FEDERAL REVENUE SOURCES: 10-4100-4288 ARPA FUNDS 551,880.73 551,880.73 551,881.00 .27 100.0 TOTAL FEDERAL REVENUE SOURCES 551,880.73 551,880.73 551,881.00 .27 100.0 TOTAL GENERAL - REVENUE 108,738.28 17,873,800.63 12,810,895.00 ( 5,062,905.63) 139.5 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 357.40 1,423.15 1,424.00 .85 99.9 TOTAL OPERATING TRANSFERS IN 357.40 1,423.15 1,424.00 .85 99.9 TOTAL OPERATING TRANSFERS - IN 357.40 1,423.15 1,424.00 .85 99.9 TOTAL FUND REVENUE 109,095.68 17,875,223.78 12,812,319.00 ( 5,062,904.78) 139.5 GENERAL GOVT - NON DEPARTMENTL CASH FUND APPROPRIATION: 10-5100-0150 REPLACEMENT RESERVE 75,000.00 300,000.00 300,000.00 .00 100.0 TOTAL CASH FUND APPROP 75,000.00 300,000.00 300,000.00 .00 100.0 EMPLOYEE BENEFITS: 10-5100-1021 EMPLOYEE BENEFITS - SCL 3.81 77.94 150.00 72.06 52.0 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 100.00 1,800.00 3,000.00 1,200.00 60.0 TOTAL EMPLOYEE BENEFITS 103.81 1,877.94 3,150.00 1,272.06 59.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:9 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT 250.00 5,757.26 6,000.00 242.74 96.0 10-5100-2115 PUBLISHING/ADVERTISING 6,620.00 29,902.02 25,000.00 ( 4,902.02) 119.6 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 720.00 720.00 500.00 ( 220.00) 144.0 TOTAL PURCHASED SERVICES 7,590.00 36,379.28 31,500.00 ( 4,879.28) 115.5 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 13,148.24 80,278.89 75,000.00 ( 5,278.89) 107.0 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 465.27 2,472.07 3,000.00 527.93 82.4 10-5100-2133 UTILITY SERVICES - NATURAL GAS 324.96 4,317.36 3,000.00 ( 1,317.36) 143.9 10-5100-2134 TELECOMMUNICATIONS 67.75 10,641.01 9,000.00 ( 1,641.01) 118.2 10-5100-2141 EQUIPMENT - RENT .00 192.00 250.00 58.00 76.8 TOTAL PROPERTY SERVICES 14,006.22 97,901.33 90,250.00 ( 7,651.33) 108.5 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 4,500.00 30,278.09 50,000.00 19,721.91 60.6 10-5100-2152 ACCOUNTING/AUDITING .00 40,000.00 45,000.00 5,000.00 88.9 10-5100-2155 REPAIRS/MAINTENANCE .00 4,479.72 5,000.00 520.28 89.6 10-5100-2156 MAINTENANCE AGREEMENT 107.25 9,380.60 11,000.00 1,619.40 85.3 10-5100-2157 INSURANCE .00 84,487.00 86,000.00 1,513.00 98.2 10-5100-2158 MISC CONTRACTUAL SERVICES 6,253.38 1,402,963.39 1,413,402.00 10,438.61 99.3 10-5100-2166 COLLECTION FEES .00 .00 100.00 100.00 .0 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE 700.00 800.00 250.00 ( 550.00) 320.0 TOTAL PROFESSIONAL SERVICES 11,560.63 1,572,388.80 1,610,752.00 38,363.20 97.6 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 89.33 10,546.39 12,000.00 1,453.61 87.9 10-5100-3210 OPERATING SUPPLIES 534.80 8,653.03 10,000.00 1,346.97 86.5 10-5100-3230 REFRESHMENT SUPPLIES .00 1,792.39 2,000.00 207.61 89.6 10-5100-3235 FUEL 13,160.06 97,954.57 115,000.00 17,045.43 85.2 TOTAL SUPPLIES 13,784.19 118,946.38 139,000.00 20,053.62 85.6 OPERATING TRANSFERS: 10-5100-4345 INVESTMENT FEES 706.33 8,469.93 .00 ( 8,469.93) .0 TOTAL OPERATING TRANSFERS 706.33 8,469.93 .00 ( 8,469.93) .0 CLAIMS & CONTINGENCY: 10-5100-7601 CLAIMS AGAINST CITY .00 1,470.00 5,000.00 3,530.00 29.4 10-5100-7606 UNEMPLOYMENT CLAIMS .00 888.85 5,000.00 4,111.15 17.8 TOTAL CLAIMS & CONTINGENCY .00 2,358.85 10,000.00 7,641.15 23.6 TOTAL GENERAL GOVT - NON DEPARTMENTL 122,751.18 2,138,322.51 2,184,652.00 46,329.49 97.9 GENERAL GOVT - CITY COUNCIL ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:10 PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 1,500.00 18,500.00 17,250.00 ( 1,250.00) 107.3 TOTAL PERSONNEL SERVICES 1,500.00 18,500.00 17,250.00 ( 1,250.00) 107.3 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 114.77 1,415.45 1,320.00 ( 95.45) 107.2 10-5101-1025 EMPLOYEE BENEFITS - COMP 38.50 449.70 499.00 49.30 90.1 TOTAL EMPLOYEE BENEFITS 153.27 1,865.15 1,819.00 ( 46.15) 102.5 PURCHASED SERVICES: 10-5101-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 7,869.28 8,000.00 130.72 98.4 10-5101-2122 TRAINING/DEVELOPMENT .00 .00 7,500.00 7,500.00 .0 10-5101-2123 MEALS/LODGING/TRAVEL .00 .00 7,500.00 7,500.00 .0 TOTAL PURCHASED SERVICES .00 7,869.28 23,000.00 15,130.72 34.2 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 1,653.27 28,234.43 42,569.00 14,334.57 66.3 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 26,878.92 354,470.57 382,493.00 28,022.43 92.7 10-5102-1002 SALARIES/WAGES - OVERTIME .00 32.55 1,500.00 1,467.45 2.2 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,135.48 1,729.00 593.52 65.7 10-5102-1006 SALARIES/WAGES - ALLOWANCES 150.00 1,950.00 1,800.00 ( 150.00) 108.3 10-5102-1007 SALARIES/WAGES - INCENTIVE .00 624.00 2,038.00 1,414.00 30.6 TOTAL PERSONNEL SERVICES 27,028.92 358,212.60 389,560.00 31,347.40 92.0 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,104.19 27,895.11 30,377.00 2,481.89 91.8 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 10,880.85 122,046.88 115,094.00 ( 6,952.88) 106.0 10-5102-1025 EMPLOYEE BENEFITS - COMP 724.63 9,037.32 11,968.00 2,930.68 75.5 10-5102-1026 EMPLOYEE BENEFITS - COMP 476.66 6,426.85 7,519.00 1,092.15 85.5 10-5102-1029 EMPLOYEE BENEFITS - WY 4,623.20 61,039.87 66,047.00 5,007.13 92.4 TOTAL EMPLOYEE BENEFITS 18,809.53 226,446.03 231,005.00 4,558.97 98.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:11 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 799.00 2,750.00 1,951.00 29.1 10-5102-2122 TRAINING/DEVELOPMENT 473.94 1,684.74 53,600.00 51,915.26 3.1 10-5102-2123 MEALS/LODGING/TRAVEL .00 68.15 5,000.00 4,931.85 1.4 TOTAL PURCHASED SERVICES 473.94 2,551.89 61,350.00 58,798.11 4.2 PROFESSIONAL SERVICES: 10-5102-2158 MISC CONTRACTUAL SERVICES 578.87 8,508.53 65,000.00 56,491.47 13.1 TOTAL PROFESSIONAL SERVICES 578.87 8,508.53 65,000.00 56,491.47 13.1 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 21.00 250.00 229.00 8.4 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 11,000.00 11,000.00 .0 TOTAL SUPPLIES .00 21.00 11,250.00 11,229.00 .2 TOTAL GENERAL GOVT - ADMIN SERVICES 46,891.26 595,740.05 758,165.00 162,424.95 78.6 GENERAL GOVT - IT PERSONNEL SERVICES: 10-5103-1001 SALARIES/WAGES - REGULAR 6,254.82 84,440.07 81,302.00 ( 3,138.07) 103.9 10-5103-1005 SALARIES/WAGES - LONGEVITY .00 437.25 437.00 ( .25) 100.1 10-5103-1006 SALARIES/WAGES - ALLOWANCES 75.00 975.00 1,260.00 285.00 77.4 10-5103-1007 SALARIES/WAGES - INCENTIVE .00 748.80 1,626.00 877.20 46.1 TOTAL PERSONNEL SERVICES 6,329.82 86,601.12 84,625.00 ( 1,976.12) 102.3 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL 488.82 6,686.94 6,349.00 ( 337.94) 105.3 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS 2,170.47 28,216.11 26,030.00 ( 2,186.11) 108.4 10-5103-1025 EMPLOYEE BENEFITS - COMP 169.77 2,193.63 2,556.00 362.37 85.8 10-5103-1029 EMPLOYEE BENEFITS - WY 1,075.82 14,539.20 13,984.00 ( 555.20) 104.0 TOTAL EMPLOYEE BENEFITS 3,904.88 51,635.88 48,919.00 ( 2,716.88) 105.6 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 86.00 1,132.00 3,500.00 2,368.00 32.3 TOTAL PURCHASED SERVICES 86.00 1,132.00 3,500.00 2,368.00 32.3 PROFESSIONAL SERVICES: 10-5103-2156 MAINTENANCE AGREEMENT .00 23,858.99 28,900.00 5,041.01 82.6 10-5103-2158 MISC CONTRACTUAL SERVICES 965.00 34,314.76 43,600.00 9,285.24 78.7 TOTAL PROFESSIONAL SERVICES 965.00 58,173.75 72,500.00 14,326.25 80.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:12 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 .00 800.00 800.00 .0 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 4,477.53 34,608.18 36,500.00 1,891.82 94.8 TOTAL SUPPLIES 4,477.53 34,608.18 37,300.00 2,691.82 92.8 TOTAL GENERAL GOVT - IT 15,763.23 232,150.93 246,844.00 14,693.07 94.1 GENERAL GOVT - MUNICIPAL COURT PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 3,662.77 48,079.51 44,464.00 ( 3,615.51) 108.1 10-5105-1005 SALARIES/WAGES - LONGEVITY .00 444.88 107.00 ( 337.88) 415.8 TOTAL PERSONNEL SERVICES 3,662.77 48,524.39 44,571.00 ( 3,953.39) 108.9 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 288.35 3,819.39 3,410.00 ( 409.39) 112.0 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS 633.86 8,240.21 19,395.00 11,154.79 42.5 10-5105-1025 EMPLOYEE BENEFITS - COMP 99.86 1,225.91 1,369.00 143.09 89.6 10-5105-1026 EMPLOYEE BENEFITS - COMP 106.52 1,403.22 .00 ( 1,403.22) .0 10-5105-1029 EMPLOYEE BENEFITS - PLC 458.00 6,039.93 5,412.00 ( 627.93) 111.6 TOTAL EMPLOYEE BENEFITS 1,586.59 20,728.66 29,586.00 8,857.34 70.1 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 150.00 150.00 .0 10-5105-2123 MEALS/LODGING/TRAVEL .00 151.72 860.00 708.28 17.6 TOTAL PURCHASED SERVICES .00 151.72 1,010.00 858.28 15.0 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 306.00 12,208.20 14,000.00 1,791.80 87.2 10-5105-2162 COURT SURCHARGES .00 .00 11,000.00 11,000.00 .0 10-5105-2166 COLLECTION FEES .00 .00 500.00 500.00 .0 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 120.00 500.00 380.00 24.0 TOTAL PROFESSIONAL SERVICES 306.00 12,328.20 26,000.00 13,671.80 47.4 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES .00 427.22 300.00 ( 127.22) 142.4 10-5105-3233 UNIFORMS/CARE .00 .00 50.00 50.00 .0 TOTAL SUPPLIES .00 427.22 350.00 ( 77.22) 122.1 TOTAL GENERAL GOVT - MUNICIPAL COURT 5,555.36 82,160.19 101,517.00 19,356.81 80.9 GENERAL GOVT - ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:13 PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 17,551.33 254,636.20 251,719.00 ( 2,917.20) 101.2 10-5106-1002 SALARIES/WAGES - OVERTIME .00 10.52 .00 ( 10.52) .0 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 892.40 893.00 .60 99.9 10-5106-1006 SALARIES/WAGES - ALLOWANCES 75.00 975.00 900.00 ( 75.00) 108.3 10-5106-1007 SALARIES/WAGES - INCENTIVE .00 457.60 1,167.00 709.40 39.2 TOTAL PERSONNEL SERVICES 17,626.33 256,971.72 254,679.00 ( 2,292.72) 100.9 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,388.76 20,214.61 19,521.00 ( 693.61) 103.6 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 3,063.59 45,598.97 46,658.00 1,059.03 97.7 10-5106-1025 EMPLOYEE BENEFITS - COMP 472.52 6,480.19 7,579.00 1,098.81 85.5 10-5106-1026 EMPLOYEE BENEFITS - COMP 527.48 7,579.38 7,944.00 364.62 95.4 10-5106-1029 EMPLOYEE BENEFITS - WY 2,491.36 36,144.70 35,237.00 ( 907.70) 102.6 TOTAL EMPLOYEE BENEFITS 7,943.71 116,017.85 116,939.00 921.15 99.2 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 50.00 1,219.00 1,335.00 116.00 91.3 10-5106-2122 TRAINING/DEVELOPMENT .00 1,507.19 3,525.00 2,017.81 42.8 10-5106-2123 MEALS/LODGING/TRAVEL .00 .00 4,330.00 4,330.00 .0 TOTAL PURCHASED SERVICES 50.00 2,726.19 9,190.00 6,463.81 29.7 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 100.04 1,388.87 1,720.00 331.13 80.8 TOTAL PROPERTY SERVICES 100.04 1,388.87 1,720.00 331.13 80.8 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 4,218.75 13,900.75 5,000.00 ( 8,900.75) 278.0 10-5106-2156 MAINTENANCE AGREEMENT 259.21 2,216.95 2,100.00 ( 116.95) 105.6 10-5106-2158 MISC CONTRACTUAL SERVICES 817.00 27,280.00 31,000.00 3,720.00 88.0 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE 1,926.32 3,453.47 750.00 ( 2,703.47) 460.5 TOTAL PROFESSIONAL SERVICES 7,221.28 46,851.17 38,850.00 ( 8,001.17) 120.6 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 952.06 5,183.02 5,300.00 116.98 97.8 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5106-3235 FUEL 91.56 538.59 2,000.00 1,461.41 26.9 TOTAL SUPPLIES 1,043.62 5,721.61 8,300.00 2,578.39 68.9 TOTAL GENERAL GOVT - 33,984.98 429,677.41 429,678.00 .59 100.0 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:14 GOVERNMENTAL ASSISTANCE: 10-5110-8702 COMM CLUB/GEN 15,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 FOR LIF 3,333.33 39,999.96 40,000.00 .04 100.0 10-5110-8707 COMM DVL 416.63 5,000.00 5,000.00 .00 100.0 10-5110-8709 COMM 3,750.00 15,000.00 15,000.00 .00 100.0 10-5110-8714 COMM ENTERPRIS 7,083.33 84,999.96 85,000.00 .04 100.0 10-5110-8723 COMM HOCKEY .00 24,000.00 274,000.00 250,000.00 8.8 10-5110-8734 COMM PEAK 19,568.67 102,902.00 105,000.00 2,098.00 98.0 10-5110-8746 COMM & GIRLS 2,083.26 25,000.00 25,000.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 4,002.00 14,000.00 14,000.00 .00 100.0 10-5110-8755 COMM HANDS .00 .00 6,000.00 6,000.00 .0 10-5110-8757 COMM SERV-KINGS PORTION 5,209.42 15,383.02 25,000.00 9,616.98 61.5 10-5110-8759 COMM SRVC CENTER 8,750.00 15,000.00 15,000.00 .00 100.0 10-5110-8761 COMM SRVC - HERE TO HEL ( 3,969.40) .00 .00 .00 .0 10-5110-8764 COMM SRVC .00 .00 5,000.00 5,000.00 .0 TOTAL GOVERNMENTAL ASSISTANCE 66,227.24 435,284.94 708,000.00 272,715.06 61.5 TOTAL COMMUNITY SERVICE CONTRACTS 66,227.24 435,284.94 708,000.00 272,715.06 61.5 PUBLIC SERVICE CONTRACTS GOVERNMENTAL ASSISTANCE: 10-5111-8744 COMM 24,994.73 250,000.00 250,000.00 .00 100.0 10-5111-8760 COMM SRVC JUSTICE 43,175.63 576,081.09 870,866.00 294,784.91 66.2 TOTAL GOVERNMENTAL ASSISTANCE 68,170.36 826,081.09 1,120,866.00 294,784.91 73.7 TOTAL PUBLIC SERVICE CONTRACTS 68,170.36 826,081.09 1,120,866.00 294,784.91 73.7 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 12,555.87 209,086.85 198,915.00 ( 10,171.85) 105.1 10-5201-1002 SALARIES/WAGES - OVERTIME .00 .00 100.00 100.00 .0 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 862.99 1,696.00 833.01 50.9 10-5201-1006 SALARIES/WAGES - ALLOWANCES 75.00 997.50 900.00 ( 97.50) 110.8 10-5201-1007 SALARIES/WAGES - INCENTIVE .00 1,248.00 1,248.00 .00 100.0 TOTAL PERSONNEL SERVICES 12,630.87 212,195.34 202,859.00 ( 9,336.34) 104.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:49AM PAGE:15 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 981.92 16,659.31 14,353.00 ( 2,306.31) 116.1 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 6,684.28 86,902.50 85,865.00 ( 1,037.50) 101.2 10-5201-1025 EMPLOYEE BENEFITS - COMP 341.22 5,817.75 5,908.00 90.25 98.5 10-5201-1026 EMPLOYEE BENEFITS - COMP 204.76 5,574.57 8,765.00 3,190.43 63.6 10-5201-1029 EMPLOYEE BENEFITS - WY 2,097.70 29,418.82 30,103.00 684.18 97.7 TOTAL EMPLOYEE BENEFITS 10,309.88 144,372.95 144,994.00 621.05 99.6 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 540.00 550.00 10.00 98.2 10-5201-2122 TRAINING/DEVELOPMENT .00 60.00 680.00 620.00 8.8 10-5201-2123 MEALS/LODGING/TRAVEL .00 71.20 1,220.00 1,148.80 5.8 TOTAL PURCHASED SERVICES .00 671.20 2,450.00 1,778.80 27.4 PROPERTY SERVICES: 10-5201-2131 UTILITY SERVICES - ELECTRICITY 221.89 1,419.87 2,000.00 580.13 71.0 10-5201-2134 TELECOMMUNICATIONS 40.01 480.16 494.00 13.84 97.2 TOTAL PROPERTY SERVICES 261.90 1,900.03 2,494.00 593.97 76.2 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 250.00 250.00 .0 10-5201-2156 MAINTENANCE AGREEMENT 64.75 937.57 1,000.00 62.43 93.8 10-5201-2158 MISC CONTRACTUAL SERVICES .00 3,178.00 5,500.00 2,322.00 57.8 10-5201-2161 INCARCERATION CONTRACT 127.50 1,305.00 2,500.00 1,195.00 52.2 TOTAL PROFESSIONAL SERVICES 192.25 5,420.57 9,250.00 3,829.43 58.6 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 1,902.09 2,350.74 3,000.00 649.26 78.4 10-5201-3233 UNIFORMS/CARE .00 388.33 2,000.00 1,611.67 19.4 10-5201-3235 FUEL 87.07 346.20 600.00 253.80 57.7 TOTAL SUPPLIES 1,989.16 3,085.27 5,600.00 2,514.73 55.1 TOTAL POLICE DEPT - ADMINISTRATION 25,384.06 367,645.36 367,647.00 1.64 100.0 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 73,494.00 907,202.89 1,289,974.00 382,771.11 70.3 10-5202-1002 SALARIES/WAGES - OVERTIME 5,944.03 78,235.87 70,000.00 ( 8,235.87) 111.8 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 3,089.90 3,089.00 ( .90) 100.0 10-5202-1006 SALARIES/WAGES - ALLOWANCES 50.00 650.00 600.00 ( 50.00) 108.3 10-5202-1007 SALARIES/WAGES - INCENTIVE .00 .00 5,002.00 5,002.00 .0 TOTAL PERSONNEL SERVICES 79,488.03 989,178.66 1,368,665.00 379,486.34 72.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:50AM PAGE:16 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 6,165.08 76,798.11 79,013.00 2,214.89 97.2 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 30,400.83 359,462.45 354,063.00 ( 5,399.45) 101.5 10-5202-1025 EMPLOYEE BENEFITS - COMP 2,124.22 24,947.50 31,221.00 6,273.50 79.9 10-5202-1026 EMPLOYEE BENEFITS - COMP 1,101.29 14,722.43 14,189.00 ( 533.43) 103.8 10-5202-1029 EMPLOYEE BENEFITS - WY 13,340.93 168,350.39 173,716.00 5,365.61 96.9 TOTAL EMPLOYEE BENEFITS 53,132.35 644,280.88 652,202.00 7,921.12 98.8 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 475.00 1,110.00 635.00 42.8 10-5202-2122 TRAINING/DEVELOPMENT 1,498.00 9,218.00 9,970.00 752.00 92.5 10-5202-2123 MEALS/LODGING/TRAVEL 691.72 3,415.19 10,685.00 7,269.81 32.0 TOTAL PURCHASED SERVICES 2,189.72 13,108.19 21,765.00 8,656.81 60.2 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,249.31 14,969.30 17,430.00 2,460.70 85.9 TOTAL PROPERTY SERVICES 1,249.31 14,969.30 17,430.00 2,460.70 85.9 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE 3,365.52 3,845.52 10,000.00 6,154.48 38.5 10-5202-2156 MAINTENANCE AGREEMENT .00 10,449.44 14,397.00 3,947.56 72.6 10-5202-2158 MISC CONTRACTUAL SERVICES 100.00 930.00 2,500.00 1,570.00 37.2 TOTAL PROFESSIONAL SERVICES 3,465.52 15,224.96 26,897.00 11,672.04 56.6 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 8.70 300.00 291.30 2.9 10-5202-3210 OPERATING SUPPLIES 1,159.33 23,700.71 30,350.00 6,649.29 78.1 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 6,245.61 10,862.00 4,616.39 57.5 10-5202-3233 UNIFORMS/CARE 631.83 16,155.07 19,100.00 2,944.93 84.6 10-5202-3235 FUEL 2,206.62 13,438.88 16,500.00 3,061.12 81.5 TOTAL SUPPLIES 3,997.78 59,548.97 77,112.00 17,563.03 77.2 TOTAL POLICE DEPT - PATROL 143,522.71 1,736,310.96 2,164,071.00 427,760.04 80.2 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 11,629.18 156,868.14 155,368.00 ( 1,500.14) 101.0 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,258.10 1,258.00 ( .10) 100.0 10-5301-1006 SALARIES/WAGES - ALLOWANCES 75.00 975.00 900.00 ( 75.00) 108.3 10-5301-1007 SALARIES/WAGES - INCENTIVE .00 540.80 998.00 457.20 54.2 TOTAL PERSONNEL SERVICES 11,704.18 159,642.04 158,524.00 ( 1,118.04) 100.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:50AM PAGE:17 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 898.12 12,251.61 13,117.00 865.39 93.4 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 3,044.76 39,525.84 36,561.00 ( 2,964.84) 108.1 10-5301-1025 EMPLOYEE BENEFITS - COMP 313.80 4,027.10 4,555.00 527.90 88.4 10-5301-1029 EMPLOYEE BENEFITS - WY 2,000.20 27,009.50 25,003.00 ( 2,006.50) 108.0 TOTAL EMPLOYEE BENEFITS 6,256.88 82,814.05 79,236.00 ( 3,578.05) 104.5 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 218.00 501.00 283.00 43.5 10-5301-2122 TRAINING/DEVELOPMENT .00 .00 1,185.00 1,185.00 .0 10-5301-2123 MEALS/LODGING/TRAVEL .00 .00 450.00 450.00 .0 TOTAL PURCHASED SERVICES .00 218.00 2,136.00 1,918.00 10.2 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 1,241.94 9,396.37 10,750.00 1,353.63 87.4 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 960.25 4,466.83 5,000.00 533.17 89.3 10-5301-2133 UTILITY SERVICES - NATURAL GAS 469.45 10,729.00 9,500.00 ( 1,229.00) 112.9 10-5301-2134 TELECOMMUNICATIONS .00 562.06 500.00 ( 62.06) 112.4 TOTAL PROPERTY SERVICES 2,671.64 25,154.26 25,750.00 595.74 97.7 PROFESSIONAL SERVICES: 10-5301-2153 ARCHITECT/ENGINEERING/SURVEING .00 172.50 1,000.00 827.50 17.3 10-5301-2155 REPAIRS/MAINTENANCE .00 472.65 1,500.00 1,027.35 31.5 10-5301-2156 MAINTENANCE AGREEMENT 39.57 2,555.84 2,720.00 164.16 94.0 TOTAL PROFESSIONAL SERVICES 39.57 3,200.99 5,220.00 2,019.01 61.3 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 173.91 3,218.01 2,000.00 ( 1,218.01) 160.9 10-5301-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 400.00 .00 ( 400.00) .0 10-5301-3230 REFRESHMENT SUPPLIES .00 329.81 750.00 420.19 44.0 10-5301-3235 FUEL 102.62 637.98 2,000.00 1,362.02 31.9 TOTAL SUPPLIES 276.53 4,585.80 4,750.00 164.20 96.5 TOTAL PUBLIC WORKS - ADMINISTRATION 20,948.80 275,615.14 275,616.00 .86 100.0 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 15,314.49 204,780.79 199,722.00 ( 5,058.79) 102.5 10-5302-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 1,231.35 1,231.00 ( .35) 100.0 10-5302-1006 SALARIES/WAGES-ALLOWANCE 50.00 650.00 600.00 ( 50.00) 108.3 10-5302-1007 SALARIES/WAGES - INCENTIVE .00 .00 2,403.00 2,403.00 .0 TOTAL PERSONNEL SERVICES 15,364.49 206,662.14 204,456.00 ( 2,206.14) 101.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:50AM PAGE:18 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,226.85 16,490.59 16,050.00 ( 440.59) 102.8 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 6,020.77 78,251.87 72,002.00 ( 6,249.87) 108.7 10-5302-1025 EMPLOYEE BENEFITS - COMP 411.85 5,213.46 6,169.00 955.54 84.5 10-5302-1026 EMPLOYEE BENEFITS - COMP 662.08 8,704.61 8,366.00 ( 338.61) 104.1 10-5302-1029 EMPLOYEE BENEFITS - WY 2,634.08 35,259.58 33,784.00 ( 1,475.58) 104.4 TOTAL EMPLOYEE BENEFITS 10,955.63 143,920.11 136,371.00 ( 7,549.11) 105.5 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 3,800.00 3,800.00 .0 10-5302-2122 TRAINING/DEVELOPMENT .00 .00 300.00 300.00 .0 TOTAL PURCHASED SERVICES .00 .00 4,100.00 4,100.00 .0 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 3,274.00 4,000.00 726.00 81.9 TOTAL PROFESSIONAL SERVICES .00 3,274.00 4,000.00 726.00 81.9 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 1,761.76 12,759.88 14,000.00 1,240.12 91.1 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 15,402.77 16,400.00 997.23 93.9 10-5302-3235 FUEL 187.22 1,276.88 2,000.00 723.12 63.8 10-5302-3237 OIL/LUBE/FLUIDS 1,796.53 10,730.40 12,500.00 1,769.60 85.8 TOTAL SUPPLIES 3,745.51 40,169.93 44,900.00 4,730.07 89.5 TOTAL PUBLIC WORKS - SHOP 30,065.63 394,026.18 394,027.00 .82 100.0 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 16,649.31 221,515.48 213,015.00 ( 8,500.48) 104.0 10-5304-1002 SALARIES/WAGES - OVERTIME 134.35 556.23 2,000.00 1,443.77 27.8 10-5304-1004 SALARIES/WAGES - TEMPORARY 6,036.95 26,471.20 59,640.00 33,168.80 44.4 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 787.95 787.00 ( .95) 100.1 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 690.00 365.00 47.1 10-5304-1007 SALARIES/WAGES - INCENTIVE .00 .00 704.00 704.00 .0 TOTAL PERSONNEL SERVICES 22,845.61 249,655.86 276,836.00 27,180.14 90.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:50AM PAGE:19 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 1,749.99 19,129.87 21,178.00 2,048.13 90.3 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 9,728.16 126,456.34 116,476.00 ( 9,980.34) 108.6 10-5304-1025 EMPLOYEE BENEFITS - COMP 611.76 6,304.35 8,505.00 2,200.65 74.1 10-5304-1029 EMPLOYEE BENEFITS - WY 2,886.80 38,084.01 36,983.00 ( 1,101.01) 103.0 TOTAL EMPLOYEE BENEFITS 14,976.71 189,974.57 183,142.00 ( 6,832.57) 103.7 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 550.00 550.00 .0 10-5304-2122 TRAINING/DEVELOPMENT .00 65.28 1,300.00 1,234.72 5.0 10-5304-2123 MEALS/LODGING/TRAVEL .00 .00 1,655.00 1,655.00 .0 TOTAL PURCHASED SERVICES .00 65.28 3,505.00 3,439.72 1.9 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 2,838.69 19,013.64 18,000.00 ( 1,013.64) 105.6 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 21,882.73 94,118.95 80,000.00 ( 14,118.95) 117.7 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 24,721.42 113,132.59 99,000.00 ( 14,132.59) 114.3 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE .00 968.56 5,000.00 4,031.44 19.4 10-5304-2156 MAINTENANCE AGREEMENT .00 1,175.00 1,250.00 75.00 94.0 10-5304-2158 MISC CONTRACTUAL SERVICES .00 18,865.00 25,000.00 6,135.00 75.5 TOTAL PROFESSIONAL SERVICES .00 21,008.56 31,250.00 10,241.44 67.2 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 637.56 39,338.42 40,000.00 661.58 98.4 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 69.50 1,000.00 930.50 7.0 10-5304-3235 FUEL 1,291.30 5,587.70 10,000.00 4,412.30 55.9 TOTAL SUPPLIES 1,928.86 44,995.62 51,000.00 6,004.38 88.2 TOTAL PUBLIC WORKS - PARKS 64,472.60 618,832.48 644,733.00 25,900.52 96.0 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 20,845.36 277,359.22 266,551.00 ( 10,808.22) 104.1 10-5305-1002 SALARIES/WAGES - OVERTIME 111.33 2,541.40 4,000.00 1,458.60 63.5 10-5305-1004 SALARIES/WAGES - TEMPORARY .00 .00 11,928.00 11,928.00 .0 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 1,386.95 1,387.00 .05 100.0 10-5305-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 300.00 ( 25.00) 108.3 10-5305-1007 SALARIES/WAGES - INCENTIVE .00 1,393.60 1,622.00 228.40 85.9 TOTAL PERSONNEL SERVICES 20,981.69 283,006.17 285,788.00 2,781.83 99.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:50AM PAGE:20 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,611.97 21,742.68 22,032.00 289.32 98.7 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 8,437.21 109,605.78 100,977.00 ( 8,628.78) 108.6 10-5305-1025 EMPLOYEE BENEFITS - COMP 562.56 7,139.05 8,814.00 1,674.95 81.0 10-5305-1026 EMPLOYEE BENEFITS - COMP 59.58 804.33 774.00 ( 30.33) 103.9 10-5305-1029 EMPLOYEE BENEFITS - WY 3,604.55 48,193.77 46,535.00 ( 1,658.77) 103.6 TOTAL EMPLOYEE BENEFITS 14,275.87 187,485.61 179,132.00 ( 8,353.61) 104.7 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT .00 125.28 1,040.00 914.72 12.1 10-5305-2123 MEALS/LODGING/TRAVEL .00 .00 675.00 675.00 .0 TOTAL PURCHASED SERVICES .00 125.28 1,715.00 1,589.72 7.3 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 3,631.20 22,654.66 66,000.00 43,345.34 34.3 10-5305-2158 MISC CONTRACTUAL SERVICES 16,700.00 24,253.42 53,200.00 28,946.58 45.6 TOTAL PROFESSIONAL SERVICES 20,331.20 46,908.08 119,200.00 72,291.92 39.4 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 6,521.07 105,843.48 80,700.00 ( 25,143.48) 131.2 10-5305-3235 FUEL 2,137.80 14,681.57 25,000.00 10,318.43 58.7 TOTAL SUPPLIES 8,658.87 120,525.05 105,700.00 ( 14,825.05) 114.0 TOTAL PUBLIC WORKS - STREETS/ALLEYS 64,247.63 638,050.19 691,535.00 53,484.81 92.3 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 10,794.89 145,682.22 145,131.00 ( 551.22) 100.4 10-5306-1002 SALARIES/WAGES - OVERTIME 566.70 1,606.90 1,500.00 ( 106.90) 107.1 10-5306-1004 SALARIES/WAGES - TEMPORARY 1,308.00 2,528.80 11,928.00 9,399.20 21.2 10-5306-1005 SALARIES/WAGES - LONGEVITY .00 1,041.25 1,041.00 ( .25) 100.0 10-5306-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 690.00 365.00 47.1 10-5306-1007 SALARIES/WAGES - INCENTIVE .00 1,040.00 1,682.00 642.00 61.8 TOTAL PERSONNEL SERVICES 12,694.59 152,224.17 161,972.00 9,747.83 94.0 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 977.17 11,728.29 12,085.00 356.71 97.1 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 5,411.82 70,353.53 69,452.00 ( 901.53) 101.3 10-5306-1025 EMPLOYEE BENEFITS - COMP 338.88 3,810.16 4,801.00 990.84 79.4 10-5306-1026 EMPLOYEE BENEFITS - COMP 77.24 1,036.74 998.00 ( 38.74) 103.9 10-5306-1029 EMPLOYEE BENEFITS - WY 1,954.19 25,360.45 24,360.00 ( 1,000.45) 104.1 TOTAL EMPLOYEE BENEFITS 8,759.30 112,289.17 111,696.00 ( 593.17) 100.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:50AM PAGE:21 PURCHASED SERVICES: 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 100.00 100.00 .0 10-5306-2122 TRAINING/DEVELOPMENT .00 .00 300.00 300.00 .0 TOTAL PURCHASED SERVICES .00 .00 400.00 400.00 .0 PROPERTY SERVICES: 10-5306-2131 UTILITY SERVICES - ELECTRICITY 442.96 3,261.91 3,000.00 ( 261.91) 108.7 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 19,782.34 61,344.99 45,000.00 ( 16,344.99) 136.3 10-5306-2133 UTILITY SERVICES - NATURAL GAS 85.72 1,504.56 1,500.00 ( 4.56) 100.3 10-5306-2134 TELECOMMUNICATIONS 51.05 820.39 1,000.00 179.61 82.0 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 20,362.07 66,931.85 50,700.00 ( 16,231.85) 132.0 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 10-5306-2156 MAINTENANCE AGREEMENT .00 905.00 1,000.00 95.00 90.5 10-5306-2158 MISC CONTRACTUAL SERVICES .00 7,000.00 7,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 7,905.00 9,500.00 1,595.00 83.2 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 880.48 6,754.24 10,000.00 3,245.76 67.5 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 895.52 1,000.00 104.48 89.6 10-5306-3235 FUEL 430.82 1,267.25 2,500.00 1,232.75 50.7 TOTAL SUPPLIES 1,311.30 8,917.01 13,500.00 4,582.99 66.1 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND 200.00 500.00 1,000.00 500.00 50.0 TOTAL CAPITALIZED EXPENDITURES 200.00 500.00 1,000.00 500.00 50.0 TOTAL PUBLIC WORKS - CEMETERY 43,327.26 348,767.20 348,768.00 .80 100.0 PUBLIC WORKS - SWIM POOL PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 1,265.94 6,168.14 7,000.00 831.86 88.1 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 2,008.62 13,384.59 12,000.00 ( 1,384.59) 111.5 10-5307-2133 UTILITY SERVICES - NATURAL GAS 1,905.10 5,169.39 6,000.00 830.61 86.2 10-5307-2134 TELECOMMUNICATIONS 516.10 1,217.25 1,500.00 282.75 81.2 TOTAL PROPERTY SERVICES 5,695.76 25,939.37 26,500.00 560.63 97.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:50AM PAGE:22 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE 1,080.00 1,080.00 5,000.00 3,920.00 21.6 10-5307-2158 MISC CONTRACTUAL SERVICES .00 70,696.76 116,000.00 45,303.24 61.0 TOTAL PROFESSIONAL SERVICES 1,080.00 71,776.76 121,000.00 49,223.24 59.3 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 6,893.22 13,474.93 10,000.00 ( 3,474.93) 134.8 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 490.68 490.68 2,500.00 2,009.32 19.6 TOTAL SUPPLIES 7,383.90 13,965.61 12,500.00 ( 1,465.61) 111.7 TOTAL PUBLIC WORKS - SWIM POOL 14,159.66 111,681.74 160,000.00 48,318.26 69.8 OPERATING TRANSFERS - OUT OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE 75,000.00 300,000.00 300,000.00 .00 100.0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ .00 .00 2,125.00 2,125.00 .0 10-5998-4331 TRANSFER TO WATER 272,127.16 272,127.16 1,056,000.00 783,872.84 25.8 10-5998-4339 TRANSFER TO HEALTH INS RESERVE 100,000.00 100,000.00 100,000.00 .00 100.0 10-5998-4353 TRANSFER TO CLG GRANT 5,300.00 5,300.00 4,000.00 ( 1,300.00) 132.5 10-5998-4355 TRANSFER TO POOL IMPROVEMENT ( 37,500.00) .00 .00 .00 .0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT 923,500.00 3,694,000.00 3,694,000.00 .00 100.0 10-5998-4357 TRANSFER TO PUBLIC FACILITIES 25,000.00 100,000.00 100,000.00 .00 100.0 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS 152,500.00 610,000.00 610,000.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 1,150.00 4,600.00 4,600.00 .00 100.0 TOTAL OPERATING TRANSFERS 1,517,077.16 5,086,027.16 5,870,725.00 784,697.84 86.6 TOTAL OPERATING TRANSFERS - OUT 1,517,077.16 5,086,027.16 5,870,725.00 784,697.84 86.6 TOTAL FUND EXPENDITURES 2,284,202.39 14,344,607.96 16,509,413.00 2,164,805.04 86.9 NET REVENUE OVER EXPENDITURES ( 2,175,106.71) 3,530,615.82 ( 3,697,094.00) ( 7,227,709.82) 95.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:51AM 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,003,493.46 TOTAL INVESTMENTS 1,003,493.46 ACCOUNTS RECEIVABLE: 11-10000132 ACCOUNTS RECEIVABLE - EOY 889,578.30 TOTAL ACCOUNTS RECEIVABLE 889,578.30 TOTAL CURRENT ASSETS 2,459,708.14 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,459,708.14 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 11-20000200 DEFERRED INFLOW 575,383.71 TOTAL ACCOUNTS PAYABLE 575,383.71 TOTAL CURRENT LIABILITIES 575,383.71 TOTAL LIABILITIES 575,383.71 NET ASSETS CAPITAL ASSETS: 11-30000300 FUND BALANCE/BEGINNING OF YEAR ( 319,810.45) 11-30000301 RESERVE FOR 4TH STREET PROJECT 1,311,063.06 TOTAL CAPITAL ASSETS 991,252.61 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:51AM PAGE:24 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 893,071.82 BALANCE - CURRENT DATE 1,884,324.43 TOTAL NET ASSETS 1,884,324.43 TOTAL LIABILITIES AND NET ASSETS 2,459,708.14 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 IMPACT ASSISTANCE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 11:51AM PAGE:25 IMPACT ASSISTANCE - REVENUE MISC LOCAL REVENUE: 11-4110-1140 INTEREST INCOME 1,767.43 3,493.46 .00 ( 3,493.46) .0 TOTAL MISC LOCAL REVENUE 1,767.43 3,493.46 .00 ( 3,493.46) .0 STATE REVENUE: 11-4110-3239 IMPACT ASST-CEDAR SPRINGS 12,931.53 889,578.36 700,000.00 ( 189,578.36) 127.1 TOTAL STATE REVENUE 12,931.53 889,578.36 700,000.00 ( 189,578.36) 127.1 TOTAL IMPACT ASSISTANCE - REVENUE 14,698.96 893,071.82 700,000.00 ( 193,071.82) 127.6 TOTAL FUND REVENUE 14,698.96 893,071.82 700,000.00 ( 193,071.82) 127.6 NET REVENUE OVER EXPENDITURES 14,698.96 893,071.82 700,000.00 ( 193,071.82) 127.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:06PM PAGE:26 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 21,664.99 TOTAL CASH 21,664.99 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 3,152.83 TOTAL ACCOUNTS RECEIVABLE 3,152.83 TOTAL CURRENT ASSETS 24,817.82 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 24,817.82 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 196.00 TOTAL ACCOUNTS PAYABLE 196.00 TOTAL CURRENT LIABILITIES 196.00 TOTAL LIABILITIES 196.00 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 25,988.54 TOTAL CAPITAL ASSETS 25,988.54 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1,366.72) BALANCE - CURRENT DATE 24,621.82 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:06PM PAGE:27 TOTAL NET ASSETS 24,621.82 TOTAL LIABILITIES AND NET ASSETS 24,817.82 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:07PM PAGE:28 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 545.65 4,868.02 14,827.00 9,958.98 32.8 TOTAL FEDERAL REVENUE SOURCES 545.65 4,868.02 14,827.00 9,958.98 32.8 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 545.65 4,868.02 14,827.00 9,958.98 32.8 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 2,607.18 8,253.58 8,254.00 .42 100.0 TOTAL STATE REVENUE 2,607.18 8,253.58 8,254.00 .42 100.0 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE 2,607.18 8,253.58 8,254.00 .42 100.0 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 411.25 2,125.00 1,713.75 19.4 TOTAL FEDERAL REVENUE SOURCES .00 411.25 2,125.00 1,713.75 19.4 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND .00 .00 2,125.00 2,125.00 .0 TOTAL TRANSFERS IN .00 .00 2,125.00 2,125.00 .0 TOTAL BULLET PROOF VEST - REVENUE .00 411.25 4,250.00 3,838.75 9.7 TOTAL FUND REVENUE 3,152.83 13,532.85 27,331.00 13,798.15 49.5 ASSET SEIZURE PROFESSIONAL SERVICES: 13-5130-2158 MISC CONTRACTUAL SERVICES .00 2,750.00 .00 ( 2,750.00) .0 TOTAL PROFESSIONAL SERVICES .00 2,750.00 .00 ( 2,750.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:09PM PAGE:29 SUPPLIES: 13-5130-3210 OPERATING SUPPLIES .00 .00 4,005.00 4,005.00 .0 TOTAL SUPPLIES .00 .00 4,005.00 4,005.00 .0 TOTAL ASSET SEIZURE .00 2,750.00 4,005.00 1,255.00 68.7 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR 126.20 3,520.02 11,590.00 8,069.98 30.4 TOTAL PERSONNEL SERVICES 126.20 3,520.02 11,590.00 8,069.98 30.4 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL 9.65 269.26 887.00 617.74 30.4 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS .00 486.58 .00 ( 486.58) .0 13-5821-1025 EMPLOYEE BENEFITS - COMP 3.17 88.35 357.00 268.65 24.8 13-5821-1029 EMPLOYEE BENEFITS - WY 21.71 605.46 1,993.00 1,387.54 30.4 TOTAL EMPLOYEE BENEFITS 34.53 1,449.65 3,237.00 1,787.35 44.8 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE 160.73 4,969.67 14,827.00 9,857.33 33.5 OJJDP-UNDERAGE ENFORCEMENT PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 413.87 3,419.94 3,750.00 330.06 91.2 TOTAL PERSONNEL SERVICES 413.87 3,419.94 3,750.00 330.06 91.2 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 31.67 261.66 277.00 15.34 94.5 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS .00 994.05 .00 ( 994.05) .0 13-5831-1025 EMPLOYEE BENEFITS - COMP 10.39 85.85 111.00 25.15 77.3 13-5831-1029 EMPLOYEE BENEFITS - WY 71.18 588.21 622.00 33.79 94.6 TOTAL EMPLOYEE BENEFITS 113.24 1,929.77 1,010.00 ( 919.77) 191.1 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES 100.00 830.00 1,480.00 650.00 56.1 TOTAL PROFESSIONAL SERVICES 100.00 830.00 1,480.00 650.00 56.1 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 96.00 1,000.19 940.00 ( 60.19) 106.4 TOTAL SUPPLIES 96.00 1,000.19 940.00 ( 60.19) 106.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:10PM PAGE:30 TOTAL OJJDP-UNDERAGE ENFORCEMENT 723.11 7,179.90 7,180.00 .10 100.0 BULLET PROOF VEST PROTECTION SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 .00 4,250.00 4,250.00 .0 TOTAL SUPPLIES .00 .00 4,250.00 4,250.00 .0 TOTAL BULLET PROOF VEST PROTECTION .00 .00 4,250.00 4,250.00 .0 TOTAL FUND EXPENDITURES 883.84 14,899.57 30,262.00 15,362.43 49.2 NET REVENUE OVER EXPENDITURES 2,268.99 ( 1,366.72) ( 2,931.00) ( 1,564.28) ( 46.6) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:33PM PAGE:31 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 4,301,023.15 31-10000117 CASH WITH FISCAL AGENT 398,144.21 31-10000118 MONEY MARKET ACCOUNT 121,570.55 TOTAL CASH 4,820,737.91 INVESTMENTS: 31-10000120 INVESTMENT POOL 4,183,389.69 31-10000122 TIME DEPOSITS - SHORT TERM 3,397,070.78 TOTAL INVESTMENTS 7,580,460.47 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 5,935.54 31-10000132 ACCOUNTS RECEIVABLE - EOY 138,358.48 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 361,982.40 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 8,805.54) 31-10000139 ACCRUED INTEREST RECEIVABLE 23,203.84 31-10000140 DUE FROM OTHER FUNDS 12,069.99 31-10000156 DUE FROM OTHER FUNDS 47,945.95 TOTAL ACCOUNTS RECEIVABLE 580,690.66 TOTAL CURRENT ASSETS 12,981,889.04 FIXED ASSETS: 31-10000181 BUILDINGS 13,440,578.18 31-10000182 ACCUMULATED - BUILDINGS ( 6,576,228.60) 31-10000183 VEHICLES 361,051.97 31-10000184 ACCUMULATED - VEHICLES ( 341,059.70) 31-10000185 EQUIPMENT 711,112.10 31-10000186 ACCUMULATED - EQUIPMENT ( 405,296.24) 31-10000188 IMPROVEMENTS OTHER THAN BLDG 12,683,503.95 31-10000189 ACCUMULATED OT BLDG ( 6,558,663.25) TOTAL FIXED ASSETS 13,314,998.41 OTHER ASSETS: 31-10000190 ACCUMULATED ( 485,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 9,922,963.97 31-10006100 DEFERRED OUTFLOW OF RESOURCES 49,244.47 TOTAL OTHER ASSETS 9,487,208.44 TOTAL NON-CURRENT ASSETS 22,802,206.85 TOTAL ASSETS 35,784,095.89 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:33PM PAGE:32 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 254,294.26 31-20000210 RETAINAGE PAYABLE 427,293.76 31-20000215 WAGES PAYABLE 14,731.32 TOTAL ACCOUNTS PAYABLE 696,319.34 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 338,420.04 31-20005411 DEFERRED INFLOWS OF RESOURCES 49,543.42 TOTAL OTHER PAYABLES 387,963.46 TOTAL CURRENT LIABILITIES 1,084,282.80 NON-CURRENT LIABILITIES: 31-20000265 COMPENSATED ABSENCES PAYABLE 51,226.81 TOTAL NON-CURRENT LIABILITIES 51,226.81 TOTAL LIABILITIES 1,135,509.61 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 5,186,628.02 31-30000305 RESERVE FOR REPLACEMENT 4,857,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 609,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 105,000.00 TOTAL CAPITAL ASSETS 11,333,868.71 OTHER NET ASSETS: 31-30000320 CAPITAL ASSETS NET OF DEBT 23,237,962.38 TOTAL OTHER NET ASSETS 23,237,962.38 REVENUE OVER EXPENDITURES - YTD 76,755.19 BALANCE - CURRENT DATE 34,648,586.28 TOTAL NET ASSETS 34,648,586.28 TOTAL LIABILITIES AND NET ASSETS 35,784,095.89 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:33PM PAGE:33 WATER - REVENUE REVENUE: 31-4310-0160 GAIN ON INVESTMENTS ( 17,402.19) ( 145,817.21) .00 145,817.21 .0 TOTAL REVENUE ( 17,402.19) ( 145,817.21) .00 145,817.21 .0 MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 2,047.20 2,000.00 ( 47.20) 102.4 31-4310-1109 REIMBURSEMENTS .00 395.00 .00 ( 395.00) .0 31-4310-1140 INTEREST INCOME ( 104,908.67) 112,807.88 145,000.00 32,192.12 77.8 TOTAL MISC LOCAL REVENUE ( 104,908.67) 115,250.08 147,000.00 31,749.92 78.4 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 328,794.35 2,482,913.25 2,000,000.00 ( 482,913.25) 124.2 31-4310-1705 UTILITY SERVICE FEES 1,360.00 20,625.00 20,499.00 ( 126.00) 100.6 31-4310-1706 WATER PLANT INVESTMENT FEES .00 37,330.00 2,000.00 ( 35,330.00) 1866.5 31-4310-1707 UTILITY LATE FEES 1,345.00 14,960.70 15,000.00 39.30 99.7 31-4310-1710 BULK WATER 10,761.93 80,996.33 50,000.00 ( 30,996.33) 162.0 TOTAL UTILITIES REVENUE 342,261.28 2,636,825.28 2,087,499.00 ( 549,326.28) 126.3 TRANSFERS IN: 31-4310-5596 TRANSFER FROM UTILITY DEPOSIT ( 1,090.56) .00 .00 .00 .0 TOTAL TRANSFERS IN ( 1,090.56) .00 .00 .00 .0 TOTAL WATER - REVENUE 218,859.86 2,606,258.15 2,234,499.00 ( 371,759.15) 116.6 LITTLE BOX ELDER SPRING - REVE STATE REVENUE: 31-4855-3235 WWDC GRANT 12,224.63 555,606.06 2,144,000.00 1,588,393.94 25.9 TOTAL STATE REVENUE 12,224.63 555,606.06 2,144,000.00 1,588,393.94 25.9 TRANSFERS IN: 31-4855-5510 TRANSFER FROM GENERAL FUND 272,127.16 272,127.16 1,056,000.00 783,872.84 25.8 TOTAL TRANSFERS IN 272,127.16 272,127.16 1,056,000.00 783,872.84 25.8 TOTAL LITTLE BOX ELDER SPRING - REVE 284,351.79 827,733.22 3,200,000.00 2,372,266.78 25.9 TOTAL FUND REVENUE 503,211.65 3,433,991.37 5,434,499.00 2,000,507.63 63.2 WATER - ADMINISTRATION ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:34PM PAGE:34 DEPRECIATION: 31-5400-1150 DEPRECIATION 121,250.00 485,000.00 485,000.00 .00 100.0 TOTAL DEPRECIATION 121,250.00 485,000.00 485,000.00 .00 100.0 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 458.57 5,494.20 5,494.00 ( .20) 100.0 31-5400-2166 COLLECTION FEES 7.98 952.45 952.00 ( .45) 100.1 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 .00 500.00 500.00 .0 TOTAL PROFESSIONAL SERVICES 466.55 6,446.65 6,946.00 499.35 92.8 OPERATING TRANSFERS: 31-5400-4345 INVESTMENT FEES 353.17 4,234.97 4,235.00 .03 100.0 31-5400-4347 MANAGEMENT FEES 65,965.75 263,863.00 263,863.00 .00 100.0 TOTAL OPERATING TRANSFERS 66,318.92 268,097.97 268,098.00 .03 100.0 TOTAL WATER - ADMINISTRATION 188,035.47 759,544.62 760,044.00 499.38 99.9 WATER - TREATMENT CASH FUND APPROPRIATION: 31-5401-0150 REPLACEMENT RESERVE-SAND FILTE 18,750.00 75,000.00 75,000.00 .00 100.0 31-5401-0153 REPLACEMENT RESERVE-SMW REHA 3,750.00 15,000.00 15,000.00 .00 100.0 TOTAL CASH FUND APPROP 22,500.00 90,000.00 90,000.00 .00 100.0 PERSONNEL SERVICES: 31-5401-1001 SALARIES/WAGES - REGULAR 7,792.48 105,271.32 101,309.00 ( 3,962.32) 103.9 31-5401-1002 SALARIES/WAGES - OVERTIME 962.17 5,794.88 6,000.00 205.12 96.6 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 570.95 572.00 1.05 99.8 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 690.00 365.00 47.1 31-5401-1007 SALARIES/WAGES - INCENTIVE .00 .00 2,026.00 2,026.00 .0 TOTAL PERSONNEL SERVICES 8,779.65 111,962.15 110,597.00 ( 1,365.15) 101.2 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 685.86 8,757.20 8,616.00 ( 141.20) 101.6 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 3,251.64 48,600.43 38,956.00 ( 9,644.43) 124.8 31-5401-1025 EMPLOYEE BENEFITS - COMP 236.98 2,826.98 3,344.00 517.02 84.5 31-5401-1026 EMPLOYEE BENEFITS - COMP 155.86 2,105.57 2,026.00 ( 79.57) 103.9 31-5401-1029 EMPLOYEE BENEFITS - WY 1,505.81 19,123.40 18,457.00 ( 666.40) 103.6 TOTAL EMPLOYEE BENEFITS 5,836.15 81,413.58 71,399.00 ( 10,014.58) 114.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:34PM PAGE:35 PURCHASED SERVICES: 31-5401-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 300.00 300.00 .0 31-5401-2122 TRAINING/DEVELOPMENT .00 1,366.00 2,570.00 1,204.00 53.2 31-5401-2123 MEALS/LODGING/TRAVEL .00 .00 800.00 800.00 .0 TOTAL PURCHASED SERVICES .00 1,366.00 3,670.00 2,304.00 37.2 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 11,360.32 54,510.88 55,000.00 489.12 99.1 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 1,671.89 6,799.85 7,000.00 200.15 97.1 31-5401-2133 UTILITY SERVICES - NATURAL GAS 482.77 6,405.48 6,000.00 ( 405.48) 106.8 31-5401-2134 TELECOMMUNICATIONS 15.82 187.12 200.00 12.88 93.6 31-5401-2140 RENT - LAND/BUILDINGS .00 9,336.33 10,000.00 663.67 93.4 TOTAL PROPERTY SERVICES 13,530.80 77,239.66 78,200.00 960.34 98.8 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 .00 2,000.00 2,000.00 .0 31-5401-2155 REPAIRS/MAINTENANCE 3,903.16 21,887.76 12,000.00 ( 9,887.76) 182.4 31-5401-2156 MAINTENANCE AGREEMENT .00 6,528.00 7,000.00 472.00 93.3 31-5401-2158 MISC CONTRACTUAL SERVICES 438.00 15,756.08 20,000.00 4,243.92 78.8 TOTAL PROFESSIONAL SERVICES 4,341.16 44,171.84 41,000.00 ( 3,171.84) 107.7 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 2,171.49 27,162.43 25,000.00 ( 2,162.43) 108.7 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 4,071.00 11,000.00 6,929.00 37.0 31-5401-3235 FUEL 131.88 988.92 2,000.00 1,011.08 49.5 TOTAL SUPPLIES 2,303.37 32,222.35 38,000.00 5,777.65 84.8 CAPITALIZED EXPENDITURES: 31-5401-6544 OTHER THAN BLDG 17,240.63 37,221.83 45,000.00 7,778.17 82.7 TOTAL CAPITALIZED EXPENDITURES 17,240.63 37,221.83 45,000.00 7,778.17 82.7 TOTAL WATER - TREATMENT 74,531.76 475,597.41 477,866.00 2,268.59 99.5 WATER - DISTRIBUTION/MAINTNCE PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 13,132.84 175,043.06 167,149.00 ( 7,894.06) 104.7 31-5402-1002 SALARIES/WAGES - OVERTIME .00 3,902.58 7,500.00 3,597.42 52.0 31-5402-1004 SALARIES/WAGES - TEMPORARY .00 .00 2,982.00 2,982.00 .0 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 607.81 608.00 .19 100.0 31-5402-1006 SALARIES & WAGES - ALLOWANCES 25.00 325.00 300.00 ( 25.00) 108.3 TOTAL PERSONNEL SERVICES 13,157.84 179,878.45 178,539.00 ( 1,339.45) 100.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:34PM PAGE:36 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,008.85 13,791.49 13,688.00 ( 103.49) 100.8 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 6,252.48 81,377.46 74,819.00 ( 6,558.46) 108.8 31-5402-1025 EMPLOYEE BENEFITS - COMP 352.70 4,537.52 5,419.00 881.48 83.7 31-5402-1029 EMPLOYEE BENEFITS - WY 2,258.86 30,810.39 30,040.00 ( 770.39) 102.6 TOTAL EMPLOYEE BENEFITS 9,872.89 130,516.86 123,966.00 ( 6,550.86) 105.3 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 291.38 1,572.13 1,700.00 127.87 92.5 31-5402-2122 TRAINING/DEVELOPMENT .00 866.56 2,450.00 1,583.44 35.4 31-5402-2123 MEALS/LODGING/TRAVEL .00 .00 50.00 50.00 .0 TOTAL PURCHASED SERVICES 291.38 2,438.69 4,200.00 1,761.31 58.1 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 2,702.98 15,761.06 13,500.00 ( 2,261.06) 116.8 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 3,879.40 22,891.49 40,000.00 17,108.51 57.2 31-5402-2133 UTILITY SERVICES - NATURAL GAS 40.29 1,490.21 1,300.00 ( 190.21) 114.6 31-5402-2134 TELECOMMUNICATIONS 33.32 197.86 350.00 152.14 56.5 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 6,655.99 40,340.62 55,550.00 15,209.38 72.6 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 661.25 2,000.00 1,338.75 33.1 31-5402-2155 REPAIRS/MAINTENANCE .00 27,868.67 10,000.00 ( 17,868.67) 278.7 31-5402-2156 MAINTENANCE AGREEMENT .00 795.00 900.00 105.00 88.3 31-5402-2158 MISC CONTRACTUAL SERVICES .00 .00 5,000.00 5,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 29,324.92 17,900.00 ( 11,424.92) 163.8 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 5,434.20 37,742.87 35,000.00 ( 2,742.87) 107.8 31-5402-3235 FUEL 910.45 5,079.16 8,500.00 3,420.84 59.8 TOTAL SUPPLIES 6,344.65 42,822.03 43,500.00 677.97 98.4 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 284.85 350.00 65.15 81.4 TOTAL FINANCIAL .00 284.85 350.00 65.15 81.4 CAPITALIZED EXPENDITURES: 31-5402-6544 OTHER THAN BLDG .00 .00 8,000.00 8,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 8,000.00 8,000.00 .0 TOTAL WATER - DISTRIBUTION/MAINTNCE 36,322.75 425,606.42 432,005.00 6,398.58 98.5 WATER - CUSTOMER SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:34PM PAGE:37 PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 3,837.95 51,818.44 49,894.00 ( 1,924.44) 103.9 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 497.38 497.00 ( .38) 100.1 31-5403-1007 SALARIES/WAGES - INCENTIVE .00 832.00 998.00 166.00 83.4 TOTAL PERSONNEL SERVICES 3,837.95 53,147.82 51,389.00 ( 1,758.82) 103.4 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 280.90 3,907.03 3,931.00 23.97 99.4 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 22.55 293.15 266.00 ( 27.15) 110.2 31-5403-1025 EMPLOYEE BENEFITS - COMP 102.86 1,340.62 1,552.00 211.38 86.4 31-5403-1029 EMPLOYEE BENEFITS - WY 660.12 8,922.25 8,582.00 ( 340.25) 104.0 TOTAL EMPLOYEE BENEFITS 1,066.43 14,463.05 14,331.00 ( 132.05) 100.9 PROPERTY SERVICES: 31-5403-2134 TELECOMMUNICATIONS 17.23 206.06 200.00 ( 6.06) 103.0 TOTAL PROPERTY SERVICES 17.23 206.06 200.00 ( 6.06) 103.0 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 250.00 1,500.00 1,250.00 16.7 TOTAL PROFESSIONAL SERVICES .00 250.00 1,500.00 1,250.00 16.7 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES .00 1,709.26 2,000.00 290.74 85.5 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 14,772.41 25,000.00 10,227.59 59.1 31-5403-3235 FUEL 104.42 660.37 2,500.00 1,839.63 26.4 TOTAL SUPPLIES 104.42 17,142.04 29,500.00 12,357.96 58.1 TOTAL WATER - CUSTOMER SERVICES 5,026.03 85,208.97 96,920.00 11,711.03 87.9 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 12,942.09 107,676.31 245,000.00 137,323.69 44.0 TOTAL PROFESSIONAL SERVICES 12,942.09 107,676.31 245,000.00 137,323.69 44.0 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG 205,268.43 658,863.89 1,655,000.00 996,136.11 39.8 TOTAL CAPITALIZED EXPENDITURES 205,268.43 658,863.89 1,655,000.00 996,136.11 39.8 TOTAL WATER MAIN REPLACEMENTS 218,210.52 766,540.20 1,900,000.00 1,133,459.80 40.3 LITTLE BOX ELDER SPRING REHAB ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:35PM PAGE:38 PROFESSIONAL SERVICES: 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY 4,255.00 239,268.54 200,000.00 ( 39,268.54) 119.6 TOTAL PROFESSIONAL SERVICES 4,255.00 239,268.54 200,000.00 ( 39,268.54) 119.6 CAPITALIZED EXPENDITURES: 31-5855-6544 OTHER THAN BLDG 1,059.40 604,810.02 3,000,000.00 2,395,189.98 20.2 TOTAL CAPITALIZED EXPENDITURES 1,059.40 604,810.02 3,000,000.00 2,395,189.98 20.2 TOTAL LITTLE BOX ELDER SPRING REHAB 5,314.40 844,078.56 3,200,000.00 2,355,921.44 26.4 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY .00 660.00 100,000.00 99,340.00 .7 TOTAL PROFESSIONAL SERVICES .00 660.00 100,000.00 99,340.00 .7 TOTAL WATER IMPROVEMENTS .00 660.00 100,000.00 99,340.00 .7 TOTAL FUND EXPENDITURES 527,440.93 3,357,236.18 6,966,835.00 3,609,598.82 48.2 NET REVENUE OVER EXPENDITURES ( 24,229.28) 76,755.19 ( 1,532,336.00) ( 1,609,091.19) 5.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:35PM PAGE:39 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 440,933.60 32-10000118 MONEY MARKET ACCOUNT 121,570.53 TOTAL CASH 562,504.13 INVESTMENTS: 32-10000120 INVESTMENT POOL 2,026,862.52 32-10000122 TIME DEPOSITS - SHORT TERM 1,797,031.49 TOTAL INVESTMENTS 3,823,894.01 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 29,765.98 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 8,338.69) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 134,950.85 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 9,202.53) 32-10000139 ACCRUED INTEREST RECEIVABLE 11,359.36 32-10000140 DUE FROM OTHER FUNDS 402.76 32-10000156 DUE FROM OTHER FUNDS 7,935.93 TOTAL ACCOUNTS RECEIVABLE 166,873.66 TOTAL CURRENT ASSETS 4,553,271.80 FIXED ASSETS: 32-10000181 BUILDINGS 2,388,172.45 32-10000182 ACCUMULATED - BUILDINGS ( 2,008,218.53) 32-10000183 VEHICLES 498,929.82 32-10000184 ACCUMULATED - VEHICLES ( 478,937.55) 32-10000185 MACHINERY/EQUIPMENT 886,884.61 32-10000186 ACCUMULATED - EQUIPMENT ( 514,663.18) 32-10000188 IMPROVEMENTS OTHER THAN BLDG 9,489,336.61 32-10000189 ACCUMULATED OT BLDG ( 3,206,352.04) TOTAL FIXED ASSETS 7,055,152.19 OTHER ASSETS: 32-10000190 ACCUMULATED ( 290,000.00) 32-10000195 CONSTRUCTION IN PROGRESS 224,456.99 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 20,348.26 TOTAL OTHER ASSETS ( 45,194.75) TOTAL NON-CURRENT ASSETS 7,009,957.44 TOTAL ASSETS 11,563,229.24 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:35PM PAGE:40 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 489,240.34 32-20000210 RETAINAGE PAYABLE 47,767.71 32-20000215 WAGES PAYABLE 12,638.30 TOTAL ACCOUNTS PAYABLE 549,646.35 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 206,234.42 32-20005411 DEFERRED INFLOWS OF RESOURCES 39,113.22 TOTAL OTHER PAYABLES 245,347.64 TOTAL CURRENT LIABILITIES 794,993.99 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 47,046.72 TOTAL NON-CURRENT LIABILITIES 47,046.72 TOTAL LIABILITIES 842,040.71 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS 1,501,738.78 32-30000305 RESERVE FOR REPLACEMENT 4,075,882.31 32-30000306 RESERVE FOR OPERATING 195,913.00 32-30000307 RESERVE FOR SLUDGE REMOVAL 300,000.00 TOTAL CAPITAL ASSETS 6,073,534.09 OTHER NET ASSETS: 32-30000320 CAPITAL ASSETS NET OF DEBT 7,279,609.20 TOTAL OTHER NET ASSETS 7,279,609.20 REVENUE OVER EXPENDITURES - YTD ( 2,631,954.76) BALANCE - CURRENT DATE 10,721,188.53 TOTAL NET ASSETS 10,721,188.53 TOTAL LIABILITIES AND NET ASSETS 11,563,229.24 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:35PM PAGE:41 SEWER - REVENUE REVENUE: 32-4320-0160 GAIN ON INVESTMENTS ( 7,458.08) ( 62,493.08) .00 62,493.08 .0 TOTAL REVENUE ( 7,458.08) ( 62,493.08) .00 62,493.08 .0 MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 1,173.58 1,000.00 ( 173.58) 117.4 32-4320-1109 REIMBURSEMENTS .00 395.00 .00 ( 395.00) .0 32-4320-1140 INTEREST INCOME ( 80,012.37) 44,129.41 100,000.00 55,870.59 44.1 TOTAL MISC LOCAL REVENUE ( 80,012.37) 45,697.99 101,000.00 55,302.01 45.3 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 110,081.59 1,224,827.97 1,224,000.00 ( 827.97) 100.1 32-4320-1706 SEWER PLANT INVESTMENT FEES .00 11,500.00 3,998.00 ( 7,502.00) 287.6 TOTAL UTILITIES REVENUE 110,081.59 1,236,327.97 1,227,998.00 ( 8,329.97) 100.7 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 27,600.00 105,337.50 150,000.00 44,662.50 70.2 TOTAL SEPTIC WASTE DISPOSAL 27,600.00 105,337.50 150,000.00 44,662.50 70.2 TOTAL SEWER - REVENUE 50,211.14 1,324,870.38 1,478,998.00 154,127.62 89.6 WASTEWATER REHAB-REVENU STATE REVENUE: 32-4850-3374 SLIB 66.00 482,683.23 500,000.00 17,316.77 96.5 TOTAL STATE REVENUE 66.00 482,683.23 500,000.00 17,316.77 96.5 TOTAL WASTEWATER REHAB-REVENU 66.00 482,683.23 500,000.00 17,316.77 96.5 TOTAL FUND REVENUE 50,277.14 1,807,553.61 1,978,998.00 171,444.39 91.3 SEWER - ADMINISTRATION DEPRECIATION: 32-5500-1150 DEPRECIATION 72,500.00 290,000.00 290,000.00 .00 100.0 TOTAL DEPRECIATION 72,500.00 290,000.00 290,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:36PM PAGE:42 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 296.16 3,548.34 3,549.00 .66 100.0 TOTAL PROFESSIONAL SERVICES 296.16 3,548.34 3,549.00 .66 100.0 OPERATING TRANSFERS: 32-5500-4345 INVESTMENT FEES 151.36 1,814.97 1,815.00 .03 100.0 32-5500-4347 MANAGEMENT FEES 34,417.00 137,668.00 137,668.00 .00 100.0 TOTAL OPERATING TRANSFERS 34,568.36 139,482.97 139,483.00 .03 100.0 TOTAL SEWER - ADMINISTRATION 107,364.52 433,031.31 433,032.00 .69 100.0 SEWER - TREATMENT CASH FUND APPROPRIATION: 32-5501-0150 SLUDGE REMOVAL RESERVE 18,750.00 75,000.00 75,000.00 .00 100.0 TOTAL CASH FUND APPROP 18,750.00 75,000.00 75,000.00 .00 100.0 PERSONNEL SERVICES: 32-5501-1001 SALARIES/WAGES - REGULAR 6,922.42 92,391.47 88,886.00 ( 3,505.47) 103.9 32-5501-1002 SALARIES/WAGES - OVERTIME .00 1,354.60 5,000.00 3,645.40 27.1 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 320.33 321.00 .67 99.8 32-5501-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 690.00 365.00 47.1 32-5501-1007 SALARIES/WAGES - INCENTIVE .00 .00 813.00 813.00 .0 TOTAL PERSONNEL SERVICES 6,947.42 94,391.40 95,710.00 1,318.60 98.6 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 538.56 7,316.51 7,384.00 67.49 99.1 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 3,247.57 42,214.11 38,902.00 ( 3,312.11) 108.5 32-5501-1025 EMPLOYEE BENEFITS - COMP 186.24 2,381.22 2,923.00 541.78 81.5 32-5501-1026 EMPLOYEE BENEFITS - COMP 62.54 844.30 813.00 ( 31.30) 103.9 32-5501-1029 EMPLOYEE BENEFITS - WY 1,190.64 16,141.07 16,148.00 6.93 100.0 TOTAL EMPLOYEE BENEFITS 5,225.55 68,897.21 66,170.00 ( 2,727.21) 104.1 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 683.00 1,500.00 817.00 45.5 32-5501-2123 MEALS/LODGING/TRAVEL .00 .00 800.00 800.00 .0 TOTAL PURCHASED SERVICES .00 683.00 2,300.00 1,617.00 29.7 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 8,477.18 71,026.85 95,000.00 23,973.15 74.8 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 10,336.85 58,282.84 60,000.00 1,717.16 97.1 32-5501-2134 TELECOMMUNICATIONS 15.82 1,550.36 1,700.00 149.64 91.2 TOTAL PROPERTY SERVICES 18,829.85 130,860.05 156,700.00 25,839.95 83.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:36PM PAGE:43 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 2,500.00 2,500.00 .0 32-5501-2155 REPAIRS/MAINTENANCE 180.06 22,856.92 30,000.00 7,143.08 76.2 32-5501-2158 MISC CONTRACTUAL SERVICES 474.00 7,561.00 10,000.00 2,439.00 75.6 TOTAL PROFESSIONAL SERVICES 654.06 30,417.92 42,500.00 12,082.08 71.6 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 2,273.84 23,209.67 25,000.00 1,790.33 92.8 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 8,638.34 10,000.00 1,361.66 86.4 32-5501-3235 FUEL 131.87 828.13 1,200.00 371.87 69.0 TOTAL SUPPLIES 2,405.71 32,676.14 36,200.00 3,523.86 90.3 CAPITALIZED EXPENDITURES: 32-5501-6544 OTHER THAN BLDG 21,731.50 22,841.45 25,000.00 2,158.55 91.4 TOTAL CAPITALIZED EXPENDITURES 21,731.50 22,841.45 25,000.00 2,158.55 91.4 TOTAL SEWER - TREATMENT 74,544.09 455,767.17 499,580.00 43,812.83 91.2 SEWER - COLLECTION PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 13,800.11 182,620.81 175,498.00 ( 7,122.81) 104.1 32-5502-1002 SALARIES/WAGES - OVERTIME 643.80 6,147.00 4,500.00 ( 1,647.00) 136.6 32-5502-1004 SALARIES/WAGES - TEMPORARY .00 .00 2,982.00 2,982.00 .0 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 767.86 768.00 .14 100.0 32-5502-1006 SALARIES & WAGES - ALLOWANCES 25.00 325.00 300.00 ( 25.00) 108.3 TOTAL PERSONNEL SERVICES 14,468.91 189,860.67 184,048.00 ( 5,812.67) 103.2 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 1,100.79 14,450.66 14,110.00 ( 340.66) 102.4 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 7,570.66 98,400.62 90,635.00 ( 7,765.62) 108.6 32-5502-1025 EMPLOYEE BENEFITS - COMP 386.70 4,789.14 5,681.00 891.86 84.3 32-5502-1029 EMPLOYEE BENEFITS - WY 2,484.34 32,503.89 30,960.00 ( 1,543.89) 105.0 TOTAL EMPLOYEE BENEFITS 11,542.49 150,144.31 141,386.00 ( 8,758.31) 106.2 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 1,088.89 2,369.64 1,700.00 ( 669.64) 139.4 32-5502-2122 TRAINING/DEVELOPMENT 100.00 1,130.00 1,825.00 695.00 61.9 TOTAL PURCHASED SERVICES 1,188.89 3,499.64 3,525.00 25.36 99.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:36PM PAGE:44 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 1,489.85 11,522.81 15,000.00 3,477.19 76.8 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 42.69 263.90 350.00 86.10 75.4 32-5502-2133 UTILITY SERVICES - NATURAL GAS 225.35 2,871.63 1,800.00 ( 1,071.63) 159.5 32-5502-2134 TELECOMMUNICATIONS 96.49 952.44 715.00 ( 237.44) 133.2 TOTAL PROPERTY SERVICES 1,854.38 15,610.78 17,865.00 2,254.22 87.4 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY .00 2,655.00 2,500.00 ( 155.00) 106.2 32-5502-2155 REPAIRS/MAINTENANCE 8,700.03 29,202.03 29,173.00 ( 29.03) 100.1 32-5502-2158 MISC CONTRACTUAL SERVICES .00 .00 4,000.00 4,000.00 .0 TOTAL PROFESSIONAL SERVICES 8,700.03 31,857.03 35,673.00 3,815.97 89.3 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 3,269.25 20,189.63 25,000.00 4,810.37 80.8 32-5502-3235 FUEL 910.38 4,917.96 8,500.00 3,582.04 57.9 TOTAL SUPPLIES 4,179.63 25,107.59 33,500.00 8,392.41 75.0 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 .00 250.00 250.00 .0 TOTAL FINANCIAL .00 .00 250.00 250.00 .0 TOTAL SEWER - COLLECTION 41,934.33 416,080.02 416,247.00 166.98 100.0 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 1,035.00 40,288.98 183,000.00 142,711.02 22.0 TOTAL PROFESSIONAL SERVICES 1,035.00 40,288.98 183,000.00 142,711.02 22.0 CAPITALIZED EXPENDITURES: 32-5850-6544 OTHER THAN BLDG 8,347.00 2,135,529.00 2,232,000.00 96,471.00 95.7 TOTAL CAPITALIZED EXPENDITURES 8,347.00 2,135,529.00 2,232,000.00 96,471.00 95.7 TOTAL WASTEWATER PLANT REHAB 9,382.00 2,175,817.98 2,415,000.00 239,182.02 90.1 SEWER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 32,590.68 136,026.67 233,000.00 96,973.33 58.4 TOTAL PROFESSIONAL SERVICES 32,590.68 136,026.67 233,000.00 96,973.33 58.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:37PM PAGE:45 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG 394,300.25 822,785.22 1,545,000.00 722,214.78 53.3 TOTAL CAPITALIZED EXPENDITURES 394,300.25 822,785.22 1,545,000.00 722,214.78 53.3 TOTAL SEWER MAIN REPLACEMENTS 426,890.93 958,811.89 1,778,000.00 819,188.11 53.9 TOTAL FUND EXPENDITURES 660,115.87 4,439,508.37 5,541,859.00 1,102,350.63 80.1 NET REVENUE OVER EXPENDITURES ( 609,838.73) ( 2,631,954.76) ( 3,562,861.00) ( 930,906.24) ( 73.9) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:37PM PAGE:46 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 605,401.80 TOTAL CASH 605,401.80 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 418,864.53 TOTAL INVESTMENTS 418,864.53 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 127.55 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 525.04) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 120,153.11 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 1,623.07) 33-10000139 ACCRUED INTEREST RECEIVABLE 584.23 33-10000156 DUE FROM OTHER FUNDS 525.04 TOTAL ACCOUNTS RECEIVABLE 119,241.82 TOTAL CURRENT ASSETS 1,143,508.15 FIXED ASSETS: 33-10000183 VEHICLES 684,806.00 33-10000184 ACCUMULATED - VEHICLES ( 262,213.67) 33-10000185 EQUIPMENT 33,437.00 33-10000186 ACCUMULATED - EQUIPMENT ( 33,437.00) TOTAL FIXED ASSETS 422,592.33 OTHER ASSETS: 33-10000190 ACCUMULATED ( 41,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 13,066.90 TOTAL OTHER ASSETS ( 27,933.10) TOTAL NON-CURRENT ASSETS 394,659.23 TOTAL ASSETS 1,538,167.38 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:37PM PAGE:47 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 160,017.75 33-20000215 WAGES PAYABLE 6,647.90 TOTAL ACCOUNTS PAYABLE 166,665.65 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 112,599.86 33-20005411 DEFERRED INFLOWS OF RESOURCES 20,860.38 TOTAL OTHER PAYABLES 133,460.24 TOTAL CURRENT LIABILITIES 300,125.89 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 38,577.26 TOTAL NON-CURRENT LIABILITIES 38,577.26 TOTAL LIABILITIES 338,703.15 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 136,438.11) 33-30000305 RESERVE FOR REPLACEMENT 811,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 751,306.43 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 422,592.33 TOTAL OTHER NET ASSETS 422,592.33 REVENUE OVER EXPENDITURES - YTD 25,565.47 BALANCE - CURRENT DATE 1,199,464.23 TOTAL NET ASSETS 1,199,464.23 TOTAL LIABILITIES AND NET ASSETS 1,538,167.38 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:37PM PAGE:48 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1107 OTHER .00 40.80 .00 ( 40.80) .0 33-4330-1140 INTEREST INCOME 133.89 9,955.78 7,500.00 ( 2,455.78) 132.7 TOTAL MISC LOCAL REVENUE 133.89 9,996.58 7,500.00 ( 2,496.58) 133.3 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 107,967.97 635,466.58 635,467.00 .42 100.0 33-4330-1709 SANITATION ACTIVATION FEE 375.00 2,000.00 250.00 ( 1,750.00) 800.0 TOTAL UTILITIES REVENUE 108,342.97 637,466.58 635,717.00 ( 1,749.58) 100.3 TOTAL SANITATION - REVENUE 108,476.86 647,463.16 643,217.00 ( 4,246.16) 100.7 TOTAL FUND REVENUE 108,476.86 647,463.16 643,217.00 ( 4,246.16) 100.7 SANITATION CASH FUND APPROPRIATION: 33-5600-0150 REPLACEMENT RESERVE 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL CASH FUND APPROP 12,500.00 50,000.00 50,000.00 .00 100.0 PERSONNEL SERVICES: 33-5600-1001 SALARIES/WAGES - REGULAR 11,038.16 149,052.92 143,494.00 ( 5,558.92) 103.9 33-5600-1002 SALARIES/WAGES - OVERTIME .00 28.33 600.00 571.67 4.7 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 1,307.60 1,308.00 .40 100.0 33-5600-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 300.00 ( 25.00) 108.3 33-5600-1007 SALARIES/WAGES - INCENTIVE .00 1,601.60 3,718.00 2,116.40 43.1 TOTAL PERSONNEL SERVICES 11,063.16 152,315.45 149,420.00 ( 2,895.45) 101.9 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 859.36 11,828.04 11,600.00 ( 228.04) 102.0 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 5,412.11 70,357.52 64,817.00 ( 5,540.52) 108.6 33-5600-1025 EMPLOYEE BENEFITS - COMP 296.53 3,841.77 4,550.00 708.23 84.4 33-5600-1026 EMPLOYEE BENEFITS - COMP 140.16 1,892.91 1,822.00 ( 70.91) 103.9 33-5600-1029 EMPLOYEE BENEFITS - WY 1,898.58 25,669.77 24,784.00 ( 885.77) 103.6 TOTAL EMPLOYEE BENEFITS 8,606.74 113,590.01 107,573.00 ( 6,017.01) 105.6 DEPRECIATION: 33-5600-1150 DEPRECIATION 10,250.00 41,000.00 41,000.00 .00 100.0 TOTAL DEPRECIATION 10,250.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, 2021 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:43PM PAGE:49 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 33-5600-2158 MISC CONTRACTUAL SERVICES 157,340.63 159,543.72 159,544.00 .28 100.0 TOTAL PROFESSIONAL SERVICES 157,340.63 159,543.72 160,544.00 1,000.28 99.4 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 766.15 15,325.75 27,000.00 11,674.25 56.8 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 24,561.23 26,000.00 1,438.77 94.5 33-5600-3235 FUEL 1,910.97 11,067.53 22,000.00 10,932.47 50.3 TOTAL SUPPLIES 2,677.12 50,954.51 75,000.00 24,045.49 67.9 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 13,623.50 54,494.00 54,494.00 .00 100.0 TOTAL OPERATING TRANSFERS 13,623.50 54,494.00 54,494.00 .00 100.0 TOTAL SANITATION 216,061.15 621,897.69 638,031.00 16,133.31 97.5 TOTAL FUND EXPENDITURES 216,061.15 621,897.69 638,031.00 16,133.31 97.5 NET REVENUE OVER EXPENDITURES ( 107,584.29) 25,565.47 5,186.00 ( 20,379.47) 493.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:44PM PAGE:50 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 491,829.97 TOTAL CASH 491,829.97 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,664,224.46 TOTAL INVESTMENTS 1,664,224.46 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 179,279.22 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 828.28) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY 2,366.00 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,615.29) 34-10000139 ACCRUED INTEREST RECEIVABLE 2,162.91 34-10000156 DUE FROM OTHER FUNDS 828.28 TOTAL ACCOUNTS RECEIVABLE 181,192.84 TOTAL CURRENT ASSETS 2,337,247.27 FIXED ASSETS: 34-10000180 LAND 153,289.58 34-10000181 BUILDINGS 1,689,609.46 34-10000182 ACCUMULATED - BUILDINGS ( 407,936.64) 34-10000183 VEHICLES 97,705.76 34-10000184 ACCUMULATED - VEHICLE ( 49,178.62) 34-10000185 EQUIPMENT 1,140,332.94 34-10000186 ACCUMULATED - EQUIPMENT ( 954,654.00) 34-10000188 IMPROVEMENTS OTHER THAN BLDG 417,030.94 34-10000189 ACCUMULATED OT BLDG ( 54,606.02) TOTAL FIXED ASSETS 2,031,593.40 OTHER ASSETS: 34-10000190 ACCUMULATED ( 155,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 20,851.21 TOTAL OTHER ASSETS ( 134,148.79) TOTAL NON-CURRENT ASSETS 1,897,444.61 TOTAL ASSETS 4,234,691.88 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:44PM PAGE:51 ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 98,449.06 34-20000204 ACCOUNTS PAYABLE- EOY 34,811.09 34-20000215 WAGES PAYABLE 9,363.15 TOTAL ACCOUNTS PAYABLE 142,623.30 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 160,082.13 34-20005411 DEFERRED INFLOWS OF RESOURCES 20,860.38 TOTAL OTHER PAYABLES 180,942.51 TOTAL CURRENT LIABILITIES 323,565.81 NON-CURRENT LIABILITIES: 34-20000260 SLIB NOTES PAYABLE 104,135.81 34-20000265 COMPENSATED ABSENCES PAYABLE 34,870.37 34-20000290 LANDFILL LIABILITY 406,155.17 TOTAL NON-CURRENT LIABILITIES 545,161.35 TOTAL LIABILITIES 868,727.16 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS 579,668.68 34-30000305 RESERVE FOR REPLACEMENT 1,256,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,968,839.45 OTHER NET ASSETS: 34-30000320 CAPITAL ASSETS NET OF DEBT 1,538,943.39 TOTAL OTHER NET ASSETS 1,538,943.39 REVENUE OVER EXPENDITURES - YTD ( 141,818.12) BALANCE - CURRENT DATE 3,365,964.72 TOTAL NET ASSETS 3,365,964.72 TOTAL LIABILITIES AND NET ASSETS 4,234,691.88 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:44PM PAGE:52 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER 16,898.50 39,801.29 .00 ( 39,801.29) .0 34-4340-1140 INTEREST INCOME 132.99 30,646.22 25,000.00 ( 5,646.22) 122.6 TOTAL MISC LOCAL REVENUE 17,031.49 70,447.51 25,000.00 ( 45,447.51) 281.8 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 132,203.50 1,121,262.38 1,000,000.00 ( 121,262.38) 112.1 TOTAL UTILITIES REVENUE 132,203.50 1,121,262.38 1,000,000.00 ( 121,262.38) 112.1 TOTAL LANDFILL - REVENUE 149,234.99 1,191,709.89 1,025,000.00 ( 166,709.89) 116.3 TOTAL FUND REVENUE 149,234.99 1,191,709.89 1,025,000.00 ( 166,709.89) 116.3 LANDFILL CASH FUND APPROPRIATION: 34-5340-0150 EQUIPMENT RESERVE .00 .00 80,000.00 80,000.00 .0 TOTAL CASH FUND APPROP .00 .00 80,000.00 80,000.00 .0 PERSONNEL SERVICES: 34-5340-1001 SALARIES/WAGES - REGULAR 15,476.05 206,227.08 197,285.00 ( 8,942.08) 104.5 34-5340-1002 SALARIES/WAGES - OVERTIME .00 7.53 1,500.00 1,492.47 .5 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,454.23 1,454.00 ( .23) 100.0 34-5340-1006 SALARIES/WAGES - ALLOWANCES 50.00 650.00 600.00 ( 50.00) 108.3 34-5340-1007 SALARIES/WAGES - INCENTIVE .00 607.44 582.00 ( 25.44) 104.4 TOTAL PERSONNEL SERVICES 15,526.05 208,946.28 201,421.00 ( 7,525.28) 103.7 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,239.18 16,684.23 16,102.00 ( 582.23) 103.6 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 6,488.62 84,338.55 77,681.00 ( 6,657.55) 108.6 34-5340-1025 EMPLOYEE BENEFITS - COMP 416.14 5,270.93 6,228.00 957.07 84.6 34-5340-1026 EMPLOYEE BENEFITS - COMP 644.70 8,742.75 8,289.00 ( 453.75) 105.5 34-5340-1029 EMPLOYEE BENEFITS - WY 2,017.18 26,757.86 25,902.00 ( 855.86) 103.3 TOTAL EMPLOYEE BENEFITS 10,805.82 141,794.32 134,202.00 ( 7,592.32) 105.7 DEPRECIATION: 34-5340-1150 DEPRECIATION 38,750.00 155,000.00 155,000.00 .00 100.0 TOTAL DEPRECIATION 38,750.00 155,000.00 155,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:45PM PAGE:53 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 TOTAL PURCHASED SERVICES .00 .00 900.00 900.00 .0 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 1,121.08 8,154.86 9,000.00 845.14 90.6 34-5340-2133 UTILITY SERVICES - NATURAL GAS 549.78 9,493.16 10,000.00 506.84 94.9 34-5340-2134 TELECOMMUNICATIONS 19.22 229.94 250.00 20.06 92.0 TOTAL PROPERTY SERVICES 1,690.08 17,877.96 19,250.00 1,372.04 92.9 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 34-5340-2155 REPAIRS/MAINTENANCE 170.00 13,273.56 14,000.00 726.44 94.8 34-5340-2156 MAINTENANCE AGREEMENT .00 3,238.42 4,500.00 1,261.58 72.0 34-5340-2157 INSURANCE .00 .00 1,500.00 1,500.00 .0 34-5340-2158 MISC CONTRACTUAL SERVICES 59,306.06 343,682.53 419,000.00 75,317.47 82.0 34-5340-2166 COLLECTION FEES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 59,476.06 360,194.51 440,300.00 80,105.49 81.8 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 15,279.96 30,581.54 55,000.00 24,418.46 55.6 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 17,500.00 17,500.00 .0 34-5340-3235 FUEL 3,094.38 15,124.80 20,000.00 4,875.20 75.6 TOTAL SUPPLIES 18,374.34 45,706.34 92,500.00 46,793.66 49.4 FINANCIAL: 34-5340-4343 DEBT PAYMENT - PRINCIPAL .00 13,141.02 .00 ( 13,141.02) .0 TOTAL FINANCIAL .00 13,141.02 .00 ( 13,141.02) .0 OPERATING TRANSFERS: 34-5340-4347 MANAGEMENT FEES 28,680.75 114,723.00 114,723.00 .00 100.0 TOTAL OPERATING TRANSFERS 28,680.75 114,723.00 114,723.00 .00 100.0 CAPITALIZED EXPENDITURES: 34-5340-6547 EQUIPMENT/FURNITURE 2,410.00 8,676.00 9,700.00 1,024.00 89.4 TOTAL CAPITALIZED EXPENDITURES 2,410.00 8,676.00 9,700.00 1,024.00 89.4 TOTAL LANDFILL 175,713.10 1,066,059.43 1,247,996.00 181,936.57 85.4 LANDFILL - CAPITAL ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:45PM PAGE:54 PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 16,498.58 40,074.58 50,000.00 9,925.42 80.2 TOTAL PROFESSIONAL SERVICES 16,498.58 40,074.58 50,000.00 9,925.42 80.2 CAPITALIZED EXPENDITURES: 34-5895-6542 BUILDINGS/IMPROVEMENTS .00 4,681.10 15,000.00 10,318.90 31.2 34-5895-6544 OTHER THAN BLDG .00 2,015.27 .00 ( 2,015.27) .0 34-5895-6547 EQUIPMENT/FURNITURE .00 9,918.75 11,000.00 1,081.25 90.2 34-5895-6548 VEHICLES .00 210,778.88 250,000.00 39,221.12 84.3 TOTAL CAPITALIZED EXPENDITURES .00 227,394.00 276,000.00 48,606.00 82.4 TOTAL LANDFILL - CAPITAL 16,498.58 267,468.58 326,000.00 58,531.42 82.1 TOTAL FUND EXPENDITURES 192,211.68 1,333,528.01 1,573,996.00 240,467.99 84.7 NET REVENUE OVER EXPENDITURES ( 42,976.69) ( 141,818.12) ( 548,996.00) ( 407,177.88) ( 25.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:45PM PAGE:55 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 663,253.21 TOTAL CASH 663,253.21 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 418,995.35 TOTAL INVESTMENTS 418,995.35 ACCOUNTS RECEIVABLE: 39-10000132 ACCOUNTS REC - EOY 298,660.83 39-10000139 ACCRUED INTEREST RECEIVABLE 837.10 TOTAL ACCOUNTS RECEIVABLE 299,497.93 TOTAL CURRENT ASSETS 1,381,746.49 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,381,746.49 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 39-20000210 IBNR LIABILITY 251,000.00 TOTAL ACCOUNTS PAYABLE 251,000.00 TOTAL CURRENT LIABILITIES 251,000.00 TOTAL LIABILITIES 251,000.00 NET ASSETS CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 143,022.69) 39-30000301 FUND BALANCE RESERVE 1,100,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 1,063,977.31 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:45PM PAGE:56 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 66,769.18 BALANCE - CURRENT DATE 1,130,746.49 TOTAL NET ASSETS 1,130,746.49 TOTAL LIABILITIES AND NET ASSETS 1,381,746.49 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:45PM PAGE:57 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 38,988.00 518,703.40 518,703.00 ( .40) 100.0 39-4390-0111 INSURANCE PREMIUMS 42,462.85 475,256.95 400,000.00 ( 75,256.95) 118.8 39-4390-0112 INSURANCE ASSESSMENTS 76,259.38 1,026,466.00 1,100,000.00 73,534.00 93.3 39-4390-0113 COBRA PAYMENTS .00 2,678.40 .00 ( 2,678.40) .0 TOTAL REVENUE 157,710.23 2,023,104.75 2,018,703.00 ( 4,401.75) 100.2 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 167.47 9,025.08 5,500.00 ( 3,525.08) 164.1 TOTAL MISC LOCAL REVENUE 167.47 9,025.08 5,500.00 ( 3,525.08) 164.1 TRANSFERS IN: 39-4390-5510 TRANSFER FROM GENERAL FUND 100,000.00 100,000.00 100,000.00 .00 100.0 TOTAL TRANSFERS IN 100,000.00 100,000.00 100,000.00 .00 100.0 TOTAL EMPLOYEE HEALTH CARE - REVENUE 257,877.70 2,132,129.83 2,124,203.00 ( 7,926.83) 100.4 TOTAL FUND REVENUE 257,877.70 2,132,129.83 2,124,203.00 ( 7,926.83) 100.4 EMPLOYEE HEALTH CARE CASH FUND APPROPRIATION: 39-5390-0150 REPLACEMENT RESERVE 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL CASH FUND APPROP 25,000.00 100,000.00 100,000.00 .00 100.0 EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM .00 339,558.89 340,000.00 441.11 99.9 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 120,781.29 1,545,286.34 1,545,287.00 .66 100.0 39-5390-1058 HEALTH CARE - FEE .00 80,515.42 80,074.00 ( 441.42) 100.6 TOTAL EMPLOYEE BENEFITS 120,781.29 1,965,360.65 1,965,361.00 .35 100.0 TOTAL EMPLOYEE HEALTH CARE 145,781.29 2,065,360.65 2,065,361.00 .35 100.0 TOTAL FUND EXPENDITURES 145,781.29 2,065,360.65 2,065,361.00 .35 100.0 NET REVENUE OVER EXPENDITURES 112,096.41 66,769.18 58,842.00 ( 7,927.18) 113.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:51PM PAGE:58 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 25,047.09 TOTAL CASH 25,047.09 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 322,848.84 TOTAL INVESTMENTS 322,848.84 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 597.53 TOTAL ACCOUNTS RECEIVABLE 597.53 TOTAL CURRENT ASSETS 348,493.46 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 348,493.46 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 348,298.48 TOTAL CAPITAL ASSETS 348,298.48 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 194.98 BALANCE - CURRENT DATE 348,493.46 TOTAL NET ASSETS 348,493.46 TOTAL LIABILITIES AND NET ASSETS 348,493.46 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:51PM PAGE:59 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 6.19 3,279.98 4,500.00 1,220.02 72.9 TOTAL MISC LOCAL REVENUE 6.19 3,279.98 4,500.00 1,220.02 72.9 TOTAL CAPITAL IMP RESERVE - REVENUE 6.19 3,279.98 4,500.00 1,220.02 72.9 TOTAL FUND REVENUE 6.19 3,279.98 4,500.00 1,220.02 72.9 CAPITAL IMP RESERVE FUND PROFESSIONAL SERVICES: 40-5400-2153 ARCHITECT/ENGINEERING/SURVEY .00 3,085.00 5,000.00 1,915.00 61.7 TOTAL PROFESSIONAL SERVICES .00 3,085.00 5,000.00 1,915.00 61.7 TOTAL CAPITAL IMP RESERVE FUND .00 3,085.00 5,000.00 1,915.00 61.7 TOTAL FUND EXPENDITURES .00 3,085.00 5,000.00 1,915.00 61.7 NET REVENUE OVER EXPENDITURES 6.19 194.98 ( 500.00) ( 694.98) 39.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:58PM PAGE:60 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 181,643.58 TOTAL CASH 181,643.58 INVESTMENTS: 41-10000122 TIME DEPOSITS-SHORT TERM 180,042.43 TOTAL INVESTMENTS 180,042.43 ACCOUNTS RECEIVABLE: 41-10000139 ACCRUED INTEREST RECEIVABLE 36.96 TOTAL ACCOUNTS RECEIVABLE 36.96 TOTAL CURRENT ASSETS 361,722.97 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 361,722.97 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 41-20000201 ACCOUNTS PAY ALLOC TO FUNDS 5,000.00 TOTAL ACCOUNTS PAYABLE 5,000.00 TOTAL CURRENT LIABILITIES 5,000.00 TOTAL LIABILITIES 5,000.00 NET ASSETS CAPITAL ASSETS: 41-30000300 FUND BALANCE/BEGINNING OF YEAR 361,768.57 TOTAL CAPITAL ASSETS 361,768.57 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:58PM PAGE:61 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 5,045.60) BALANCE - CURRENT DATE 356,722.97 TOTAL NET ASSETS 356,722.97 TOTAL LIABILITIES AND NET ASSETS 361,722.97 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:58PM PAGE:62 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 44.90 3,153.07 3,000.00 ( 153.07) 105.1 TOTAL MISC LOCAL REVENUE 44.90 3,153.07 3,000.00 ( 153.07) 105.1 TOTAL ECONOMIC DEVELOPMENT 44.90 3,153.07 3,000.00 ( 153.07) 105.1 TOTAL FUND REVENUE 44.90 3,153.07 3,000.00 ( 153.07) 105.1 ECONOMIC DEVELOPMENT PROFESSIONAL SERVICES: 41-5410-2158 MISC CONTRACTUAL SERVICES 5,000.00 8,198.67 8,199.00 .33 100.0 TOTAL PROFESSIONAL SERVICES 5,000.00 8,198.67 8,199.00 .33 100.0 TOTAL ECONOMIC DEVELOPMENT 5,000.00 8,198.67 8,199.00 .33 100.0 TOTAL FUND EXPENDITURES 5,000.00 8,198.67 8,199.00 .33 100.0 NET REVENUE OVER EXPENDITURES ( 4,955.10) ( 5,045.60) ( 5,199.00) ( 153.40) ( 97.1) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 BROWNFIELD GRANT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:59PM PAGE:63 ASSETS CURRENT ASSETS: CASH: 42-10000116 CASH ALLOC FR COMBINED FUND ( 2,400.67) TOTAL CASH ( 2,400.67) ACCOUNTS RECEIVABLE: 42-10000131 ACCOUNTS RECEIVABLE - GENERAL 7,157.15 TOTAL ACCOUNTS RECEIVABLE 7,157.15 TOTAL CURRENT ASSETS 4,756.48 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 4,756.48 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 42-20000201 ACCOUNTS PAY ALLOC TO FUNDS 4,756.48 TOTAL ACCOUNTS PAYABLE 4,756.48 TOTAL CURRENT LIABILITIES 4,756.48 TOTAL LIABILITIES 4,756.48 TOTAL LIABILITIES AND NET ASSETS 4,756.48 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 12:59PM PAGE:64 BROWNFIELD HAZARDOUS - REVENUE FEDERAL REVENUE SOURCES: 42-4870-4281 EPA 9,143.73 89,999.96 157,000.00 67,000.04 57.3 TOTAL FEDERAL REVENUE SOURCES 9,143.73 89,999.96 157,000.00 67,000.04 57.3 TOTAL BROWNFIELD HAZARDOUS - REVENUE 9,143.73 89,999.96 157,000.00 67,000.04 57.3 BROWNFIELD PETROLEUM - REVENUE FEDERAL REVENUE SOURCES: 42-4871-4281 EPA 120.90 21,386.64 81,000.00 59,613.36 26.4 TOTAL FEDERAL REVENUE SOURCES 120.90 21,386.64 81,000.00 59,613.36 26.4 TOTAL BROWNFIELD PETROLEUM - REVENUE 120.90 21,386.64 81,000.00 59,613.36 26.4 TOTAL FUND REVENUE 9,264.63 111,386.60 238,000.00 126,613.40 46.8 BROWNFIELD HAZARDOUS PURCHASED SERVICES: 42-5870-2123 MEALS/LODGING/TRAVEL .00 .00 2,000.00 2,000.00 .0 TOTAL PURCHASED SERVICES .00 .00 2,000.00 2,000.00 .0 PROFESSIONAL SERVICES: 42-5870-2158 MISC CONTRACTUAL SERVICES 4,756.48 89,999.96 155,000.00 65,000.04 58.1 TOTAL PROFESSIONAL SERVICES 4,756.48 89,999.96 155,000.00 65,000.04 58.1 TOTAL BROWNFIELD HAZARDOUS 4,756.48 89,999.96 157,000.00 67,000.04 57.3 BROWNFIELD PETROLEUM PURCHASED SERVICES: 42-5871-2123 MEALS/LODGING/TRAVEL .00 .00 2,000.00 2,000.00 .0 TOTAL PURCHASED SERVICES .00 .00 2,000.00 2,000.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:01PM PAGE:65 PROFESSIONAL SERVICES: 42-5871-2158 MISC CONTRACTUAL SERVICES .00 21,386.64 79,000.00 57,613.36 27.1 TOTAL PROFESSIONAL SERVICES .00 21,386.64 79,000.00 57,613.36 27.1 TOTAL BROWNFIELD PETROLEUM .00 21,386.64 81,000.00 59,613.36 26.4 TOTAL FUND EXPENDITURES 4,756.48 111,386.60 238,000.00 126,613.40 46.8 NET REVENUE OVER EXPENDITURES 4,508.15 .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:11PM PAGE:66 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND 94,064.19 TOTAL CASH 94,064.19 INVESTMENTS: 47-10000122 TIME DEPOSITS - SHORT TERM 104,748.83 TOTAL INVESTMENTS 104,748.83 ACCOUNTS RECEIVABLE: 47-10000130 ACCOUNTS RECEIVABLE - EOY 73,584.28 47-10000139 ACCRUED INTEREST RECEIVABLE 209.27 TOTAL ACCOUNTS RECEIVABLE 73,793.55 TOTAL CURRENT ASSETS 272,606.57 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 272,606.57 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR ( 21,066.53) 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS 200,174.34 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 72,432.23 BALANCE - CURRENT DATE 272,606.57 TOTAL NET ASSETS 272,606.57 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:11PM PAGE:67 TOTAL LIABILITIES AND NET ASSETS 272,606.57 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:11PM PAGE:68 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME 5.08 1,824.67 1,500.00 ( 324.67) 121.6 TOTAL MISC LOCAL REVENUE 5.08 1,824.67 1,500.00 ( 324.67) 121.6 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND 75,000.00 300,000.00 300,000.00 .00 100.0 TOTAL TRANSFERS IN 75,000.00 300,000.00 300,000.00 .00 100.0 TOTAL GENERAL FUND EQUIP RES-REVENUE 75,005.08 301,824.67 301,500.00 ( 324.67) 100.1 TOTAL FUND REVENUE 75,005.08 301,824.67 301,500.00 ( 324.67) 100.1 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE .00 31,723.54 101,261.00 69,537.46 31.3 47-5470-6548 VEHICLES .00 197,668.90 174,736.00 ( 22,932.90) 113.1 TOTAL CAPITALIZED EXPENDITURES .00 229,392.44 275,997.00 46,604.56 83.1 TOTAL GENERAL FUND EQUIPMENT RESERVE .00 229,392.44 275,997.00 46,604.56 83.1 TOTAL FUND EXPENDITURES .00 229,392.44 275,997.00 46,604.56 83.1 NET REVENUE OVER EXPENDITURES 75,005.08 72,432.23 25,503.00 ( 46,929.23) 284.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:29PM PAGE:69 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 483,421.77 TOTAL CASH 483,421.77 TOTAL CURRENT ASSETS 483,421.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 483,421.77 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR 225,844.65 50-30000301 RESERVED FUND BALANCE 255,959.63 TOTAL CAPITAL ASSETS 481,804.28 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,617.49 BALANCE - CURRENT DATE 483,421.77 TOTAL NET ASSETS 483,421.77 TOTAL LIABILITIES AND NET ASSETS 483,421.77 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:29PM PAGE:70 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1140 INTEREST INCOME 119.50 1,617.49 300.00 ( 1,317.49) 539.2 TOTAL MISC LOCAL REVENUE 119.50 1,617.49 300.00 ( 1,317.49) 539.2 TOTAL FIRE EQUIPMENT - REVENUE 119.50 1,617.49 300.00 ( 1,317.49) 539.2 TOTAL FUND REVENUE 119.50 1,617.49 300.00 ( 1,317.49) 539.2 NET REVENUE OVER EXPENDITURES 119.50 1,617.49 300.00 ( 1,317.49) 539.2 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:41PM PAGE:71 ASSETS CURRENT ASSETS: CASH: 53-10000116 CASH ALLOC FR COMBINED FUND 1,121.66 TOTAL CASH 1,121.66 ACCOUNTS RECEIVABLE: 53-10000131 ACCOUNTS RECEIVABLE - GENERAL 1,690.00 TOTAL ACCOUNTS RECEIVABLE 1,690.00 TOTAL CURRENT ASSETS 2,811.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,811.66 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 53-30000300 FUND BALANCE/BEGINNING OF YEAR 1,311.66 TOTAL CAPITAL ASSETS 1,311.66 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,500.00 BALANCE - CURRENT DATE 2,811.66 TOTAL NET ASSETS 2,811.66 TOTAL LIABILITIES AND NET ASSETS 2,811.66 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 CPTL PROJ - CLG PROJECTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:41PM PAGE:72 HISTORIC DISTRICT - REVENUE STATE REVENUE: 53-4809-3973 CERTIFIED LOCAL GOVERNMENT 7,200.00 7,200.00 7,200.00 .00 100.0 TOTAL STATE REVENUE 7,200.00 7,200.00 7,200.00 .00 100.0 TRANSFERS IN: 53-4809-5510 TRANSFER FROM GENERAL FUND 5,300.00 5,300.00 5,300.00 .00 100.0 TOTAL TRANSFERS IN 5,300.00 5,300.00 5,300.00 .00 100.0 TOTAL HISTORIC DISTRICT - REVENUE 12,500.00 12,500.00 12,500.00 .00 100.0 TOTAL FUND REVENUE 12,500.00 12,500.00 12,500.00 .00 100.0 HISTORIC DISTRICT PROFESSIONAL SERVICES: 53-5809-2158 MISC CONTRACTUAL SERVICES .00 11,000.00 11,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 11,000.00 11,000.00 .00 100.0 TOTAL HISTORIC DISTRICT .00 11,000.00 11,000.00 .00 100.0 TOTAL FUND EXPENDITURES .00 11,000.00 11,000.00 .00 100.0 NET REVENUE OVER EXPENDITURES 12,500.00 1,500.00 1,500.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:43PM PAGE:73 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 38,979.90 TOTAL CASH 38,979.90 TOTAL CURRENT ASSETS 38,979.90 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 38,979.90 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 39,879.90 TOTAL CAPITAL ASSETS 39,879.90 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 900.00) BALANCE - CURRENT DATE 38,979.90 TOTAL NET ASSETS 38,979.90 TOTAL LIABILITIES AND NET ASSETS 38,979.90 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:44PM PAGE:74 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE .00 900.00 5,000.00 4,100.00 18.0 TOTAL PROFESSIONAL SERVICES .00 900.00 5,000.00 4,100.00 18.0 TOTAL TRAIN CAR RESTORATION .00 900.00 5,000.00 4,100.00 18.0 TOTAL FUND EXPENDITURES .00 900.00 5,000.00 4,100.00 18.0 NET REVENUE OVER EXPENDITURES .00 ( 900.00) ( 5,000.00) ( 4,100.00) ( 18.0) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:44PM PAGE:75 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 22,148.06 TOTAL CASH 22,148.06 INVESTMENTS: 55-10000122 TIME DEPOSITS - SHORT TERM 234,047.29 TOTAL INVESTMENTS 234,047.29 ACCOUNTS RECEIVABLE: 55-10000139 ACCRUED INTEREST RECEIVABLE 28.63 TOTAL ACCOUNTS RECEIVABLE 28.63 TOTAL CURRENT ASSETS 256,223.98 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 256,223.98 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 252,759.10 TOTAL CAPITAL ASSETS 252,759.10 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,464.88 BALANCE - CURRENT DATE 256,223.98 TOTAL NET ASSETS 256,223.98 TOTAL LIABILITIES AND NET ASSETS 256,223.98 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:44PM PAGE:76 POOL IMPROVEMENTS - REVENUE MISC LOCAL REVENUE: 55-4550-1140 INTEREST INCOME .00 4,252.38 .00 ( 4,252.38) .0 TOTAL MISC LOCAL REVENUE .00 4,252.38 .00 ( 4,252.38) .0 TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND ( 37,500.00) .00 .00 .00 .0 TOTAL TRANSFERS IN ( 37,500.00) .00 .00 .00 .0 TOTAL POOL IMPROVEMENTS - REVENUE ( 37,500.00) 4,252.38 .00 ( 4,252.38) .0 TOTAL FUND REVENUE ( 37,500.00) 4,252.38 .00 ( 4,252.38) .0 POOL IMPROVEMENTS CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG .00 787.50 2,500.00 1,712.50 31.5 TOTAL CAPITALIZED EXPENDITURES .00 787.50 2,500.00 1,712.50 31.5 TOTAL POOL IMPROVEMENTS .00 787.50 2,500.00 1,712.50 31.5 TOTAL FUND EXPENDITURES .00 787.50 2,500.00 1,712.50 31.5 NET REVENUE OVER EXPENDITURES ( 37,500.00) 3,464.88 ( 2,500.00) ( 5,964.88) 138.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:44PM PAGE:77 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 4,283,592.61 TOTAL CASH 4,283,592.61 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 11,583,573.65 TOTAL INVESTMENTS 11,583,573.65 ACCOUNTS RECEIVABLE: 56-10000131 ACCOUNTS RECEIVABLE - GENERAL 204,443.25 56-10000139 ACCRUED INTEREST RECEIVABLE 6,522.80 56-10000156 DUE FROM OTHER FUNDS 7,405.02 TOTAL ACCOUNTS RECEIVABLE 218,371.07 TOTAL CURRENT ASSETS 16,085,537.33 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 16,085,537.33 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 460,603.20 56-20000210 RETAINAGE PAYABLE 63,410.31 TOTAL ACCOUNTS PAYABLE 524,013.51 DUE TO OTHER FUNDS: 56-20000245 DUE TO OTHER FUNDS 1,433,797.82 TOTAL DUE TO OTHER FUNDS 1,433,797.82 TOTAL CURRENT LIABILITIES 1,957,811.33 TOTAL LIABILITIES 1,957,811.33 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:44PM PAGE:78 CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 12,796,271.35 TOTAL CAPITAL ASSETS 12,796,271.35 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,331,454.65 BALANCE - CURRENT DATE 14,127,726.00 TOTAL NET ASSETS 14,127,726.00 TOTAL LIABILITIES AND NET ASSETS 16,085,537.33 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:44PM PAGE:79 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1140 INTEREST INCOME 12,454.26 121,746.88 65,000.00 ( 56,746.88) 187.3 TOTAL MISC LOCAL REVENUE 12,454.26 121,746.88 65,000.00 ( 56,746.88) 187.3 CONTRIBUTIONS: 56-4560-1550 CONTRIBUTIONS 204,443.25 204,443.25 .00 ( 204,443.25) .0 TOTAL CONTRIBUTIONS 204,443.25 204,443.25 .00 ( 204,443.25) .0 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND 923,500.00 3,694,000.00 3,694,000.00 .00 100.0 TOTAL TRANSFERS IN 923,500.00 3,694,000.00 3,694,000.00 .00 100.0 TOTAL STREET IMPROVEMENTS-REVENUE 1,140,397.51 4,020,190.13 3,759,000.00 ( 261,190.13) 107.0 TOTAL FUND REVENUE 1,140,397.51 4,020,190.13 3,759,000.00 ( 261,190.13) 107.0 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 17,489.13 285,265.08 770,000.00 484,734.92 37.1 56-5560-2158 MISC CONTRACTUAL SERVICES 6,305.30 49,667.00 30,000.00 ( 19,667.00) 165.6 TOTAL PROFESSIONAL SERVICES 23,794.43 334,932.08 800,000.00 465,067.92 41.9 CAPITALIZED EXPENDITURES: 56-5560-6540 LAND .00 16,428.78 .00 ( 16,428.78) .0 56-5560-6544 OTHER THAN BLDG 461,514.47 2,337,374.62 6,580,000.00 4,242,625.38 35.5 TOTAL CAPITALIZED EXPENDITURES 461,514.47 2,353,803.40 6,580,000.00 4,226,196.60 35.8 TOTAL STREET IMPROVEMENTS 485,308.90 2,688,735.48 7,380,000.00 4,691,264.52 36.4 TOTAL FUND EXPENDITURES 485,308.90 2,688,735.48 7,380,000.00 4,691,264.52 36.4 NET REVENUE OVER EXPENDITURES 655,088.61 1,331,454.65 ( 3,621,000.00) ( 4,952,454.65) 36.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:45PM PAGE:80 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 755,863.82 TOTAL CASH 755,863.82 INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 1,259,409.30 TOTAL INVESTMENTS 1,259,409.30 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 5,486.30 57-10000156 DUE FROM OTHER FUNDS 1,433,797.82 TOTAL ACCOUNTS RECEIVABLE 1,439,284.12 TOTAL CURRENT ASSETS 3,454,557.24 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,454,557.24 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000210 RETAINAGE PAYABLE 11,906.20 TOTAL ACCOUNTS PAYABLE 11,906.20 TOTAL CURRENT LIABILITIES 11,906.20 TOTAL LIABILITIES 11,906.20 NET ASSETS CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 3,482,040.54 TOTAL CAPITAL ASSETS 3,482,040.54 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:45PM PAGE:81 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 39,389.50) BALANCE - CURRENT DATE 3,442,651.04 TOTAL NET ASSETS 3,442,651.04 TOTAL LIABILITIES AND NET ASSETS 3,454,557.24 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 01:45PM PAGE:82 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME .00 28,992.44 .00 ( 28,992.44) .0 TOTAL MISC LOCAL REVENUE .00 28,992.44 .00 ( 28,992.44) .0 TRANSFERS IN: 57-4570-5510 TRANSFER FROM GENERAL FUND 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL TRANSFERS IN 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL CAPITAL IMP - FACILITIES REV 25,000.00 128,992.44 100,000.00 ( 28,992.44) 129.0 TOTAL FUND REVENUE 25,000.00 128,992.44 100,000.00 ( 28,992.44) 129.0 CAPITAL IMP -FACILITIES PROFESSIONAL SERVICES: 57-5570-2158 MISC CONTRACTUAL SERVICES .00 .00 11,000.00 11,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 11,000.00 11,000.00 .0 CAPITALIZED EXPENDITURES: 57-5570-6542 BUILDINGS/IMPROVEMENTS .00 119,062.00 .00 ( 119,062.00) .0 57-5570-6544 OTHER THAN BLDG .00 49,319.94 260,775.00 211,455.06 18.9 TOTAL CAPITALIZED EXPENDITURES .00 168,381.94 260,775.00 92,393.06 64.6 TOTAL CAPITAL IMP -FACILITIES .00 168,381.94 271,775.00 103,393.06 62.0 TOTAL FUND EXPENDITURES .00 168,381.94 271,775.00 103,393.06 62.0 NET REVENUE OVER EXPENDITURES 25,000.00 ( 39,389.50) ( 171,775.00) ( 132,385.50) ( 22.9) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:05PM PAGE:83 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 1,425,729.91 TOTAL CASH 1,425,729.91 INVESTMENTS: 65-10000120 INVESTMENT POOL 597,627.13 65-10000122 TIME DEPOSITS - SHORT TERM 1,842,865.21 TOTAL INVESTMENTS 2,440,492.34 ACCOUNTS RECEIVABLE: 65-10000139 ACCRUED INTEREST RECEIVABLE 3,218.42 TOTAL ACCOUNTS RECEIVABLE 3,218.42 TOTAL CURRENT ASSETS 3,869,440.67 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,869,440.67 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 377,675.93 65-20000210 RETAINAGE PAYABLE 41,097.12 TOTAL ACCOUNTS PAYABLE 418,773.05 TOTAL CURRENT LIABILITIES 418,773.05 TOTAL LIABILITIES 418,773.05 NET ASSETS CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 3,273,522.97 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 3,296,438.86 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:05PM PAGE:84 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 154,228.76 BALANCE - CURRENT DATE 3,450,667.62 TOTAL NET ASSETS 3,450,667.62 TOTAL LIABILITIES AND NET ASSETS 3,869,440.67 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:05PM PAGE:85 PARK - REVE REVENUE: 65-4650-0160 GAIN ON INVESTMENTS ( 2,486.03) ( 20,831.02) .00 20,831.02 .0 TOTAL REVENUE ( 2,486.03) ( 20,831.02) .00 20,831.02 .0 MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME 66,573.39 99,352.53 25,000.00 ( 74,352.53) 397.4 TOTAL MISC LOCAL REVENUE 66,573.39 99,352.53 25,000.00 ( 74,352.53) 397.4 CONTRIBUTIONS: 65-4650-1550 CONTRIBUTIONS .00 1,000.00 .00 ( 1,000.00) .0 TOTAL CONTRIBUTIONS .00 1,000.00 .00 ( 1,000.00) .0 TRANSFERS IN: 65-4650-5510 TRANSFER FROM GENERAL FUND 152,500.00 610,000.00 610,000.00 .00 100.0 TOTAL TRANSFERS IN 152,500.00 610,000.00 610,000.00 .00 100.0 TOTAL PARK - REVE 216,587.36 689,521.51 635,000.00 ( 54,521.51) 108.6 TOTAL FUND REVENUE 216,587.36 689,521.51 635,000.00 ( 54,521.51) 108.6 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY 17,062.00 52,922.50 50,000.00 ( 2,922.50) 105.9 TOTAL PROFESSIONAL SERVICES 17,062.00 52,922.50 50,000.00 ( 2,922.50) 105.9 OPERATING TRANSFERS: 65-5650-4345 INVESTMENT FEES 50.45 604.99 .00 ( 604.99) .0 TOTAL OPERATING TRANSFERS 50.45 604.99 .00 ( 604.99) .0 CAPITALIZED EXPENDITURES: 65-5650-6544 OTHER THAN BLDG 395,645.47 481,765.26 645,000.00 163,234.74 74.7 TOTAL CAPITALIZED EXPENDITURES 395,645.47 481,765.26 645,000.00 163,234.74 74.7 TOTAL PARK IMPROVEMENTS 412,757.92 535,292.75 695,000.00 159,707.25 77.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:07PM PAGE:86 TOTAL FUND EXPENDITURES 412,757.92 535,292.75 695,000.00 159,707.25 77.0 NET REVENUE OVER EXPENDITURES ( 196,170.56) 154,228.76 ( 60,000.00) ( 214,228.76) 257.1 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:41PM PAGE:87 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 6,225.51 TOTAL CASH 6,225.51 INVESTMENTS: 90-10000120 INVESTMENT POOL 107,016.61 90-10000122 TIME DEPOSITS - SHORT TERM 62,300.22 TOTAL INVESTMENTS 169,316.83 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 25.22 TOTAL ACCOUNTS RECEIVABLE 25.22 TOTAL CURRENT ASSETS 175,567.56 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 175,567.56 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 31,157.16 TOTAL CAPITAL ASSETS 31,157.16 RESTRICTED ASSETS: 90-30000315 FUND BALANCE RESTRICTED 141,610.40 TOTAL RESTRICTED ASSETS 141,610.40 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,800.00 BALANCE - CURRENT DATE 175,567.56 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:42PM PAGE:88 TOTAL NET ASSETS 175,567.56 TOTAL LIABILITIES AND NET ASSETS 175,567.56 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:42PM PAGE:89 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES .00 2,800.00 1,500.00 ( 1,300.00) 186.7 TOTAL REVENUE .00 2,800.00 1,500.00 ( 1,300.00) 186.7 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 18.23 1,423.15 1,424.00 .85 99.9 TOTAL MISC LOCAL REVENUE 18.23 1,423.15 1,424.00 .85 99.9 TOTAL PERPETUAL CARE - REVENUE 18.23 4,223.15 2,924.00 ( 1,299.15) 144.4 TOTAL FUND REVENUE 18.23 4,223.15 2,924.00 ( 1,299.15) 144.4 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 357.40 1,423.15 1,424.00 .85 99.9 TOTAL TRANSFERS TO OTHER FUNDS 357.40 1,423.15 1,424.00 .85 99.9 TOTAL PERPETUAL CARE 357.40 1,423.15 1,424.00 .85 99.9 TOTAL FUND EXPENDITURES 357.40 1,423.15 1,424.00 .85 99.9 NET REVENUE OVER EXPENDITURES ( 339.17) 2,800.00 1,500.00 ( 1,300.00) 186.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:42PM PAGE:90 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, 2021 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:43PM PAGE:91 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 17,826.56 TOTAL CASH 17,826.56 TOTAL CURRENT ASSETS 17,826.56 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 17,826.56 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 3,818.93 92-20000406 HISTORIC PRESERVATION 3,651.12 92-20000407 HISTORIC PRESERVATION-KIOSK 16,789.30 92-20000408 HISTORIC PRESERVATION - MOVIE 615.38 TOTAL OTHER PAYABLES 24,874.73 TOTAL CURRENT LIABILITIES 24,874.73 TOTAL LIABILITIES 24,874.73 NET ASSETS CAPITAL ASSETS: 92-30000300 FUND BALANCE/BEGINNING OF YEAR ( 11,112.97) TOTAL CAPITAL ASSETS ( 11,112.97) OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 4,064.80 BALANCE - CURRENT DATE ( 7,048.17) TOTAL NET ASSETS ( 7,048.17) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:43PM PAGE:92 TOTAL LIABILITIES AND NET ASSETS 17,826.56 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:43PM PAGE:93 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 1,150.00 4,064.80 4,600.00 535.20 88.4 TOTAL TRANSFERS IN 1,150.00 4,064.80 4,600.00 535.20 88.4 TOTAL HISTORIC CMSN - REVENU 1,150.00 4,064.80 4,600.00 535.20 88.4 TOTAL FUND REVENUE 1,150.00 4,064.80 4,600.00 535.20 88.4 HISTORIC PRESERVATION PROFESSIONAL SERVICES: 92-5920-2158 MISC CONTRACTUAL SERVICES .00 .00 4,600.00 4,600.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 4,600.00 4,600.00 .0 TOTAL HISTORIC PRESERVATION .00 .00 4,600.00 4,600.00 .0 TOTAL FUND EXPENDITURES .00 .00 4,600.00 4,600.00 .0 NET REVENUE OVER EXPENDITURES 1,150.00 4,064.80 .00 ( 4,064.80) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:44PM PAGE:94 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 7,392.34 TOTAL CASH 7,392.34 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 88,370.34 TOTAL INVESTMENTS 88,370.34 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 38.55 TOTAL ACCOUNTS RECEIVABLE 38.55 TOTAL CURRENT ASSETS 95,801.23 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 95,801.23 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 330.69 TOTAL ACCOUNTS PAYABLE 330.69 OTHER LIABILITIES PAYABLE: 96-20000229 UTILITY DEPOSITS 88,125.05 TOTAL OTHER LIABILITIES PAYABLE 88,125.05 TOTAL CURRENT LIABILITIES 88,455.74 TOTAL LIABILITIES 88,455.74 NET ASSETS CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 7,345.49 TOTAL CAPITAL ASSETS 7,345.49 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:44PM PAGE:95 TOTAL NET ASSETS 7,345.49 TOTAL LIABILITIES AND NET ASSETS 95,801.23 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2021 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:44PM PAGE:96 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME ( 1,526.54) .00 .00 .00 .0 TOTAL MISC LOCAL REVENUE ( 1,526.54) .00 .00 .00 .0 TOTAL UTILITY DEPOSITS - REVENUE ( 1,526.54) .00 .00 .00 .0 TOTAL FUND REVENUE ( 1,526.54) .00 .00 .00 .0 UTILITY DEPOSIT TRANSFERS TO OTHER FUNDS: 96-5960-5531 TRANSFER TO WATER ( 1,090.56) .00 .00 .00 .0 TOTAL TRANSFERS TO OTHER FUNDS ( 1,090.56) .00 .00 .00 .0 TOTAL UTILITY DEPOSIT ( 1,090.56) .00 .00 .00 .0 TOTAL FUND EXPENDITURES ( 1,090.56) .00 .00 .00 .0 NET REVENUE OVER EXPENDITURES ( 435.98) .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2021 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/17/2021 02:44PM PAGE:97 ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS: INVESTMENTS: 97-10000173 SECURITIES - LONG TERM 5,225,283.17 97-10000174 INVESTMENTS - RHSA 438,926.14 TOTAL INVESTMENTS 5,664,209.31 TOTAL NON-CURRENT ASSETS 5,664,209.31 TOTAL ASSETS 5,664,209.31 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 97-30000300 FUND BALANCE/BEGINNING OF YEAR 5,664,209.31 TOTAL CAPITAL ASSETS 5,664,209.31 TOTAL NET ASSETS 5,664,209.31 TOTAL LIABILITIES AND NET ASSETS 5,664,209.31