Douglas_doc_3613be3bf0 - Public Records Archive

Full Text

CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2020 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:16AM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 20,343,464.91 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 198,311.24 01-10000113 CASH ON HAND 550.00 TOTAL COMBINED CASH 20,542,326.15 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 20,542,326.15) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND 3,401,666.95 11 ALLOCATION TO IMPACT ASSISTANCE FUND 677,058.02 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 23,763.92 31 ALLOCATION TO WATER FUND 3,752,965.44 32 ALLOCATION TO SEWER FUND 772,720.91 33 ALLOCATION TO SANITATION FUND 413,252.95 34 ALLOCATION TO LANDFILL FUND 552,935.59 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 501,971.31 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 29,935.10 41 ALLOCATION TO ECONOMIC DEVELOPMENT 187,156.49 42 ALLOCATION TO BROWNFIELD GRANT ( 1.80) 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE 65,650.62 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 481,804.28 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 2,811.66 54 ALLOCATION TO TRAIN CAR RESTORATION 52,677.77 55 ALLOCATION TO POOL IMPROVEMENTS FUND 34,108.86 56 ALLOCATION TO STREET IMPROVEMENT FUND 6,249,171.07 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 810,765.93 65 ALLOCATION TO CAPTL PROJ-PARK FUND 2,508,476.33 90 ALLOCATION TO PERPETUAL CARE FUND 4,424.29 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 2.75 92 ALLOCATION TO HISTORIC CMSN FUND 15,385.55 96 ALLOCATION TO UTILITY DEPOSIT FUND 3,622.16 TOTAL ALLOCATIONS TO OTHER FUNDS 20,542,326.15 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 20,542,326.15) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:2 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 3,401,666.95 TOTAL CASH 3,401,666.95 INVESTMENTS: 10-10000120 INVESTMENT POOL 8,039,011.71 10-10000122 TIME DEPOSITS - SHORT TERM 17,006,497.98 TOTAL INVESTMENTS 25,045,509.69 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 35,465.28 10-10000131 ACCOUNTS RECEIVABLE - GENERAL 14,887.72 10-10000132 ACCOUNTS REC - PROPERTY TAX 498,721.09 10-10000133 ACCOUNTS CRT 2,767.55 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 3,336,577.80 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 610.71 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE 3,132.72 10-10000139 ACCRUED INTEREST RECEIVABLE 105,245.66 TOTAL ACCOUNTS RECEIVABLE 3,997,408.53 TOTAL CURRENT ASSETS 32,444,585.17 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 32,444,585.17 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 10-20000200 DEFERRED INFLOW 454,021.87 10-20000201 ALLOCATION FROM AP FUND 359,039.27 10-20000204 ACCOUNTS PAYABLE - EOY ( 25,360.18) 10-20000206 FUNDS PAYABLE - DUE TO OTHERS 15,000.00 10-20000207 SALES TAX PAYABLE 74.27 10-20000215 WAGES PAYABLE 113,167.01 10-20000216 WAGES PAYABLE - EOY 26,220.91 TOTAL ACCOUNTS PAYABLE 942,163.15 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:3 PAYROLL DEDUCTIONS PAYABLE: 10-20000223 FICA PAYABLE 1.85 10-20000224 DEFERRED COMPENSATION PAYABLE 48,194.59 10-20000227 WORKERS COMP INS PAYABLE 21,733.22 TOTAL PAYROLL DEDUCTIONS PAYABLE 69,929.66 OTHER LIABILITIES PAYABLE: 10-20000228 UNCLAIMED PROPERTY 7,525.44 TOTAL OTHER LIABILITIES PAYABLE 7,525.44 DUE TO OTHER FUNDS: 10-20000245 DUE TO OTHER FUNDS 39,214.18 TOTAL DUE TO OTHER FUNDS 39,214.18 TOTAL CURRENT LIABILITIES 1,058,832.43 TOTAL LIABILITIES 1,058,832.43 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 30,153,888.72 10-30000301 FUND BALANCE RESERVE 2,570,000.00 TOTAL CAPITAL ASSETS 32,723,888.72 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1,338,135.98) BALANCE - CURRENT DATE 31,385,752.74 TOTAL NET ASSETS 31,385,752.74 TOTAL LIABILITIES AND NET ASSETS 32,444,585.17 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:4 GENERAL - REVENUE MISC LOCAL REVENUE: 10-4100-1101 REIMBURSEMENT - CCSD 4,705.39 30,111.57 122,709.00 92,597.43 24.5 10-4100-1107 OTHER 3,797.02 8,755.47 10,000.00 1,244.53 87.6 10-4100-1108 COPY FEES/VIN CHECKS 749.53 6,213.96 2,000.00 ( 4,213.96) 310.7 10-4100-1109 REIMBURSEMENTS 15,454.87 113,971.92 100,000.00 ( 13,971.92) 114.0 10-4100-1112 CONTRIBUTIONS .00 15,064.83 10,000.00 ( 5,064.83) 150.7 10-4100-1115 LEASES/RENT .00 5,170.00 4,500.00 ( 670.00) 114.9 10-4100-1120 FINES/FORFEITS 1,774.00 24,897.00 50,000.00 25,103.00 49.8 10-4100-1122 TECHNOLOGY SURCHARGE 425.00 6,925.00 10,000.00 3,075.00 69.3 10-4100-1130 CASH LONG/SHORT .58 .83 .00 ( .83) .0 10-4100-1140 INTEREST INCOME 48,022.38 386,396.59 435,000.00 48,603.41 88.8 10-4100-1145 GAIN ON SALE OF FIXED ASSETS .00 13,925.00 .00 ( 13,925.00) .0 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 6,813.75 12,000.00 5,186.25 56.8 TOTAL MISC LOCAL REVENUE 74,928.77 618,245.92 756,209.00 137,963.08 81.8 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 590.00 22,292.62 20,000.00 ( 2,292.62) 111.5 TOTAL LIQUOR LICENSES 590.00 22,292.62 20,000.00 ( 2,292.62) 111.5 OTHER LICENSES/PERMITS: 10-4100-1230 LICENSES - TRANSIENT MERCHANT .00 25.00 100.00 75.00 25.0 TOTAL OTHER LICENSES/PERMITS .00 25.00 100.00 75.00 25.0 CONTRACTORS LICENSES: 10-4100-1241 LICENSES - CONTRACTORS 275.00 15,250.63 13,500.00 ( 1,750.63) 113.0 TOTAL CONTRACTORS LICENSES 275.00 15,250.63 13,500.00 ( 1,750.63) 113.0 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 13,519.09 40,759.53 20,000.00 ( 20,759.53) 203.8 TOTAL BUILDING PERMITS 13,519.09 40,759.53 20,000.00 ( 20,759.53) 203.8 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 275.00 2,216.00 2,000.00 ( 216.00) 110.8 TOTAL ZONING/CONDITIONAL USE 275.00 2,216.00 2,000.00 ( 216.00) 110.8 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 46,417.06 458,164.72 450,000.00 ( 8,164.72) 101.8 10-4100-1321 PROPERTY TAX - PRIOR YEARS 408.53 1,613.62 500.00 ( 1,113.62) 322.7 10-4100-1322 PROPERTY TAX - AUTO 17,660.43 177,622.84 170,000.00 ( 7,622.84) 104.5 10-4100-1323 PROPERTY TAX - INTEREST ( 161.98) 766.37 1,000.00 233.63 76.6 10-4100-1324 PROPERTY TAX - HANDLING FEES .00 ( 2,834.94) ( 2,000.00) 834.94 ( 141.8) TOTAL PROPERTY TAXES 64,324.04 635,332.61 619,500.00 ( 15,832.61) 102.6 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:5 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 13,269.20 228,547.56 225,000.00 ( 3,547.56) 101.6 10-4100-1331 FRANCHISE FEES - CABLE TV .00 14,251.71 14,000.00 ( 251.71) 101.8 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 37,474.95 35,000.00 ( 2,474.95) 107.1 10-4100-1333 FRANCHISE FEES - TELEPHONE 2,149.67 6,996.71 5,000.00 ( 1,996.71) 139.9 TOTAL FRANCHISE FEES 15,418.87 287,270.93 279,000.00 ( 8,270.93) 103.0 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 26,060.75 104,243.00 104,243.00 .00 100.0 10-4100-1421 MANAGEMENT FEES - WATER 66,303.00 265,212.00 265,212.00 .00 100.0 10-4100-1422 MANAGEMENT FEES - SEWER 39,293.50 157,174.00 157,174.00 .00 100.0 10-4100-1423 MANAGEMENT FEES - SANITATION 12,847.00 51,388.00 51,388.00 .00 100.0 TOTAL MANAGEMENT FEES 144,504.25 578,017.00 578,017.00 .00 100.0 WEED ABATEMENT: 10-4100-1430 WEED MOWING CHARGES .00 521.70 .00 ( 521.70) .0 10-4100-1431 PEST CONTROL .00 14,535.00 14,000.00 ( 535.00) 103.8 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 33,343.24 35,000.00 1,656.76 95.3 TOTAL WEED ABATEMENT .00 48,399.94 49,000.00 600.06 98.8 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 1,600.00 13,900.00 10,000.00 ( 3,900.00) 139.0 TOTAL BURIAL FEES 1,600.00 13,900.00 10,000.00 ( 3,900.00) 139.0 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 2,100.00 8,900.00 5,000.00 ( 3,900.00) 178.0 TOTAL LOT SALES 2,100.00 8,900.00 5,000.00 ( 3,900.00) 178.0 POOL: 10-4100-1650 POOL - USER FEES .00 14,370.00 20,000.00 5,630.00 71.9 10-4100-1651 POOL - CONCESSION .00 10,990.92 12,500.00 1,509.08 87.9 TOTAL POOL .00 25,360.92 32,500.00 7,139.08 78.0 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 229,690.80 225,000.00 ( 4,690.80) 102.1 10-4100-3111 SEVERENCE TAX - 2% .00 113,371.00 227,000.00 113,629.00 49.9 10-4100-3112 MINERAL ROYALTIES 69,889.43 351,243.22 312,000.00 ( 39,243.22) 112.6 TOTAL MINERAL EXTRACTION 69,889.43 694,305.02 764,000.00 69,694.98 90.9 SALES TAX: 10-4100-3241 SALES TAX - STATE 559,161.87 10,768,207.01 7,500,000.00 ( 3,268,207.01) 143.6 10-4100-3245 SALES TAX - LOCAL OPTION 455,880.85 8,759,788.40 4,500,000.00 ( 4,259,788.40) 194.7 TOTAL SALES TAX 1,015,042.72 19,527,995.41 12,000,000.00 ( 7,527,995.41) 162.7 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:6 GAS TAX: 10-4100-3250 LOTTERY .00 45,857.23 60,000.00 14,142.77 76.4 10-4100-3257 GAS TAX 15,375.25 231,182.33 225,000.00 ( 6,182.33) 102.8 10-4100-3258 SPECIAL FUELS 4,957.81 65,856.89 55,000.00 ( 10,856.89) 119.7 TOTAL GAS TAX 20,333.06 342,896.45 340,000.00 ( 2,896.45) 100.9 OTHER: 10-4100-3262 CIGARETTE TAX 3,684.34 55,554.33 45,000.00 ( 10,554.33) 123.5 TOTAL OTHER 3,684.34 55,554.33 45,000.00 ( 10,554.33) 123.5 TOTAL GENERAL - REVENUE 1,426,484.57 22,916,722.31 15,533,826.00 ( 7,382,896.31) 147.5 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 504.61 2,657.71 1,000.00 ( 1,657.71) 265.8 TOTAL OPERATING TRANSFERS IN 504.61 2,657.71 1,000.00 ( 1,657.71) 265.8 TOTAL OPERATING TRANSFERS - IN 504.61 2,657.71 1,000.00 ( 1,657.71) 265.8 TOTAL FUND REVENUE 1,426,989.18 22,919,380.02 15,534,826.00 ( 7,384,554.02) 147.5 GENERAL GOVT - NON DEPARTMENTL CASH FUND APPROPRIATION: 10-5100-0150 REPLACEMENT RESERVE 300,000.00 300,000.00 300,000.00 .00 100.0 TOTAL CASH FUND APPROP 300,000.00 300,000.00 300,000.00 .00 100.0 EMPLOYEE BENEFITS: 10-5100-1021 EMPLOYEE BENEFITS - SCL 7.67 182.38 150.00 ( 32.38) 121.6 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 80.00 2,185.00 3,000.00 815.00 72.8 TOTAL EMPLOYEE BENEFITS 87.67 2,367.38 3,150.00 782.62 75.2 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT 838.88 5,941.46 6,000.00 58.54 99.0 10-5100-2115 PUBLISHING/ADVERTISING 4,769.38 36,696.88 35,000.00 ( 1,696.88) 104.9 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 500.00 500.00 .0 TOTAL PURCHASED SERVICES 5,608.26 42,638.34 41,500.00 ( 1,138.34) 102.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:7 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 6,769.64 80,669.80 90,000.00 9,330.20 89.6 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 468.58 3,230.38 4,000.00 769.62 80.8 10-5100-2133 UTILITY SERVICES - NATURAL GAS 227.68 3,759.70 3,000.00 ( 759.70) 125.3 10-5100-2134 TELECOMMUNICATIONS 920.24 10,621.96 9,250.00 ( 1,371.96) 114.8 10-5100-2141 EQUIPMENT - RENT .00 97.02 250.00 152.98 38.8 TOTAL PROPERTY SERVICES 8,386.14 98,378.86 106,500.00 8,121.14 92.4 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 3,466.60 40,073.70 50,000.00 9,926.30 80.2 10-5100-2152 ACCOUNTING/AUDITING .00 44,250.00 50,000.00 5,750.00 88.5 10-5100-2153 ARCHITECHT/ENGINEERING/SURVEY .00 747.50 2,500.00 1,752.50 29.9 10-5100-2155 REPAIRS/MAINTENANCE 683.77 11,916.54 7,300.00 ( 4,616.54) 163.2 10-5100-2156 MAINTENANCE AGREEMENT 115.73 7,960.93 11,500.00 3,539.07 69.2 10-5100-2157 INSURANCE .00 75,738.50 105,000.00 29,261.50 72.1 10-5100-2158 MISC CONTRACTUAL SERVICES 3,182.46 50,544.21 40,000.00 ( 10,544.21) 126.4 10-5100-2166 COLLECTION FEES .00 139.93 100.00 ( 39.93) 139.9 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE 165.00 290.00 500.00 210.00 58.0 TOTAL PROFESSIONAL SERVICES 7,613.56 231,661.31 266,900.00 35,238.69 86.8 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES .00 9,395.86 13,500.00 4,104.14 69.6 10-5100-3210 OPERATING SUPPLIES 1,111.36 8,439.50 26,000.00 17,560.50 32.5 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 14,795.00 14,795.00 1,000.00 ( 13,795.00) 1479.5 10-5100-3230 REFRESHMENT SUPPLIES 27.96 487.61 2,000.00 1,512.39 24.4 10-5100-3235 FUEL 6,694.76 95,921.63 150,000.00 54,078.37 64.0 TOTAL SUPPLIES 22,629.08 129,039.60 192,500.00 63,460.40 67.0 CLAIMS & CONTINGENCY: 10-5100-7601 CLAIMS AGAINST CITY .00 2,897.38 5,000.00 2,102.62 58.0 10-5100-7606 UNEMPLOYMENT CLAIMS .00 .00 6,000.00 6,000.00 .0 TOTAL CLAIMS & CONTINGENCY .00 2,897.38 11,000.00 8,102.62 26.3 TOTAL GENERAL GOVT - NON DEPARTMENTL 344,324.71 806,982.87 921,550.00 114,567.13 87.6 GENERAL GOVT - CITY COUNCIL PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 1,375.00 16,500.00 16,500.00 .00 100.0 TOTAL PERSONNEL SERVICES 1,375.00 16,500.00 16,500.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:8 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 105.20 1,262.40 1,262.00 ( .40) 100.0 10-5101-1025 EMPLOYEE BENEFITS - COMP 34.30 411.60 478.00 66.40 86.1 TOTAL EMPLOYEE BENEFITS 139.50 1,674.00 1,740.00 66.00 96.2 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 6,150.00 7,500.00 1,350.00 82.0 10-5101-2123 MEALS/LODGING/TRAVEL .00 1,435.95 17,350.00 15,914.05 8.3 TOTAL PURCHASED SERVICES .00 15,455.23 32,850.00 17,394.77 47.1 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,514.50 33,629.23 51,590.00 17,960.77 65.2 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 26,040.39 387,518.42 377,566.00 ( 9,952.42) 102.6 10-5102-1002 SALARIES/WAGES - OVERTIME .00 421.63 1,500.00 1,078.37 28.1 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,856.66 1,857.00 .34 100.0 10-5102-1006 SALARIES/WAGES - ALLOWANCES 150.00 1,800.00 1,800.00 .00 100.0 10-5102-1007 SALARIES/WAGES - INCENTIVE .00 1,539.20 998.00 ( 541.20) 154.2 TOTAL PERSONNEL SERVICES 26,190.39 393,135.91 383,721.00 ( 9,414.91) 102.5 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,038.82 30,642.92 30,018.00 ( 624.92) 102.1 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 8,317.78 104,588.45 109,490.00 4,901.55 95.5 10-5102-1025 EMPLOYEE BENEFITS - COMP 665.24 9,985.65 11,320.00 1,334.35 88.2 10-5102-1026 EMPLOYEE BENEFITS - COMP 460.54 7,456.46 7,666.00 209.54 97.3 10-5102-1029 EMPLOYEE BENEFITS - WY 4,478.94 65,467.51 64,896.00 ( 571.51) 100.9 TOTAL EMPLOYEE BENEFITS 15,961.32 218,140.99 223,390.00 5,249.01 97.7 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,063.00 3,000.00 1,937.00 35.4 10-5102-2122 TRAINING/DEVELOPMENT .00 2,135.00 4,250.00 2,115.00 50.2 10-5102-2123 MEALS/LODGING/TRAVEL .00 658.63 8,850.00 8,191.37 7.4 TOTAL PURCHASED SERVICES .00 3,856.63 16,100.00 12,243.37 24.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:9 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 190.43 500.00 309.57 38.1 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 20,500.00 20,500.00 .0 TOTAL SUPPLIES .00 190.43 21,000.00 20,809.57 .9 TOTAL GENERAL GOVT - ADMIN SERVICES 42,151.71 615,323.96 644,211.00 28,887.04 95.5 GENERAL GOVT - IT PERSONNEL SERVICES: 10-5103-1001 SALARIES/WAGES - REGULAR 6,254.82 81,236.38 81,309.00 72.62 99.9 10-5103-1005 SALARIES/WAGES - LONGEVITY .00 413.25 413.00 ( .25) 100.1 10-5103-1006 SALARIES/WAGES - ALLOWANCES 75.00 1,275.00 900.00 ( 375.00) 141.7 10-5103-1007 SALARIES/WAGES - INCENTIVE .00 707.20 1,626.00 918.80 43.5 TOTAL PERSONNEL SERVICES 6,329.82 83,631.83 84,248.00 616.17 99.3 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL 499.92 6,396.51 6,665.00 268.49 96.0 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS 2,065.47 24,785.64 24,770.00 ( 15.64) 100.1 10-5103-1025 EMPLOYEE BENEFITS - COMP 160.79 2,133.49 2,570.00 436.51 83.0 10-5103-1029 EMPLOYEE BENEFITS - WY 1,075.82 13,970.10 13,920.00 ( 50.10) 100.4 TOTAL EMPLOYEE BENEFITS 3,802.00 47,285.74 47,925.00 639.26 98.7 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 84.00 1,006.00 2,500.00 1,494.00 40.2 10-5103-2122 TRAINING/DEVELOPMENT .00 .00 2,500.00 2,500.00 .0 10-5103-2123 MEALS/LODGING/TRAVEL .00 .00 400.00 400.00 .0 TOTAL PURCHASED SERVICES 84.00 1,006.00 5,400.00 4,394.00 18.6 PROFESSIONAL SERVICES: 10-5103-2156 MAINTENANCE AGREEMENT 2,563.44 37,772.03 40,000.00 2,227.97 94.4 10-5103-2158 MISC CONTRACTUAL SERVICES 1,762.62 30,482.44 49,100.00 18,617.56 62.1 TOTAL PROFESSIONAL SERVICES 4,326.06 68,254.47 89,100.00 20,845.53 76.6 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 .00 800.00 800.00 .0 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 14,085.00 55,364.39 61,400.00 6,035.61 90.2 TOTAL SUPPLIES 14,085.00 55,364.39 62,200.00 6,835.61 89.0 TOTAL GENERAL GOVT - IT 28,626.88 255,542.43 288,873.00 33,330.57 88.5 GENERAL GOVT - MUNICIPAL COURT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:10 PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 3,489.18 40,256.84 43,412.00 3,155.16 92.7 10-5105-1005 SALARIES/WAGES - LONGEVITY .00 89.61 89.00 ( .61) 100.7 TOTAL PERSONNEL SERVICES 3,489.18 40,346.45 43,501.00 3,154.55 92.8 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 274.52 3,097.95 3,328.00 230.05 93.1 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS 604.20 14,470.53 18,446.00 3,975.47 78.5 10-5105-1025 EMPLOYEE BENEFITS - COMP 88.62 1,024.82 1,281.00 256.18 80.0 10-5105-1026 EMPLOYEE BENEFITS - COMP 99.56 149.34 .00 ( 149.34) .0 10-5105-1029 EMPLOYEE BENEFITS - PLC 428.14 4,838.61 5,206.00 367.39 92.9 TOTAL EMPLOYEE BENEFITS 1,495.04 23,581.25 28,261.00 4,679.75 83.4 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 150.00 150.00 .0 10-5105-2123 MEALS/LODGING/TRAVEL .00 .00 860.00 860.00 .0 TOTAL PURCHASED SERVICES .00 .00 1,010.00 1,010.00 .0 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 1,312.00 11,767.80 14,400.00 2,632.20 81.7 10-5105-2162 COURT SURCHARGES 365.00 8,150.00 11,235.00 3,085.00 72.5 10-5105-2166 COLLECTION FEES .00 .00 500.00 500.00 .0 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE 100.00 100.00 500.00 400.00 20.0 TOTAL PROFESSIONAL SERVICES 1,777.00 20,017.80 26,635.00 6,617.20 75.2 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES 49.16 171.60 450.00 278.40 38.1 10-5105-3233 UNIFORMS/CARE .00 .00 50.00 50.00 .0 TOTAL SUPPLIES 49.16 171.60 500.00 328.40 34.3 TOTAL GENERAL GOVT - MUNICIPAL COURT 6,810.38 84,117.10 99,907.00 15,789.90 84.2 GENERAL GOVT - PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 18,688.19 241,922.27 243,764.00 1,841.73 99.2 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 796.40 797.00 .60 99.9 10-5106-1006 SALARIES/WAGES - ALLOWANCES 75.00 1,275.00 900.00 ( 375.00) 141.7 10-5106-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,189.00 1,189.00 .0 TOTAL PERSONNEL SERVICES 18,763.19 243,993.67 246,650.00 2,656.33 98.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:17AM PAGE:11 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,477.88 19,173.71 19,711.00 537.29 97.3 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 3,709.50 44,513.21 44,449.00 ( 64.21) 100.1 10-5106-1025 EMPLOYEE BENEFITS - COMP 476.57 6,197.27 7,374.00 1,176.73 84.0 10-5106-1026 EMPLOYEE BENEFITS - COMP 599.42 7,169.08 6,517.00 ( 652.08) 110.0 10-5106-1029 EMPLOYEE BENEFITS - WY 2,704.74 35,063.16 35,215.00 151.84 99.6 TOTAL EMPLOYEE BENEFITS 8,968.11 112,116.43 113,266.00 1,149.57 99.0 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 50.00 1,192.00 1,320.00 128.00 90.3 10-5106-2122 TRAINING/DEVELOPMENT .00 1,610.88 4,125.00 2,514.12 39.1 10-5106-2123 MEALS/LODGING/TRAVEL .00 5,687.89 8,640.00 2,952.11 65.8 TOTAL PURCHASED SERVICES 50.00 8,490.77 14,085.00 5,594.23 60.3 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 130.34 1,122.47 1,000.00 ( 122.47) 112.3 TOTAL PROPERTY SERVICES 130.34 1,122.47 1,000.00 ( 122.47) 112.3 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 2,555.00 7,289.00 10,000.00 2,711.00 72.9 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT 82.73 2,101.07 2,100.00 ( 1.07) 100.1 10-5106-2158 MISC CONTRACTUAL SERVICES .00 6,050.00 6,050.00 .00 100.0 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE 50.00 2,730.00 750.00 ( 1,980.00) 364.0 TOTAL PROFESSIONAL SERVICES 2,687.73 18,170.07 19,900.00 1,729.93 91.3 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 1,387.78 2,507.29 5,300.00 2,792.71 47.3 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,239.96 1,000.00 ( 239.96) 124.0 10-5106-3235 FUEL 154.18 893.28 2,000.00 1,106.72 44.7 TOTAL SUPPLIES 1,541.96 4,640.53 8,300.00 3,659.47 55.9 TOTAL GENERAL GOVT - 32,141.33 388,533.94 403,201.00 14,667.06 96.4 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:12 GOVERNMENTAL ASSISTANCE: 10-5110-8701 COMM CITIZEN .00 49,999.98 50,000.00 .02 100.0 10-5110-8702 COMM CLUB/GEN 5,000.00 55,000.00 60,000.00 5,000.00 91.7 10-5110-8703 COMM RCREATN .00 15,460.67 30,000.00 14,539.33 51.5 10-5110-8705 COMM FOR LIF 1,250.00 15,000.00 15,000.00 .00 100.0 10-5110-8707 COMM DVL 416.63 5,000.00 5,000.00 .00 100.0 10-5110-8709 COMM 1,250.00 15,000.00 15,000.00 .00 100.0 10-5110-8714 COMM ENTERPRIS 7,083.33 84,999.96 85,000.00 .04 100.0 10-5110-8723 COMM HOCKEY 24,000.00 31,000.00 274,000.00 243,000.00 11.3 10-5110-8734 COMM PEAK 21,416.67 104,750.00 105,000.00 250.00 99.8 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 3,000.00 4,000.00 1,000.00 75.0 10-5110-8753 COMM SRVC BLK 9,831.63 13,000.00 13,000.00 .00 100.0 10-5110-8759 COMM SRVC CENTER 3,750.00 15,000.00 15,000.00 .00 100.0 10-5110-8761 COMM SRVC - HERE TO HEL .00 403.36 8,000.00 7,596.64 5.0 10-5110-8762 COMM SRVC MSUM .00 1,180.85 10,000.00 8,819.15 11.8 10-5110-8763 COMM SRVC 5,999.42 5,999.42 6,000.00 .58 100.0 TOTAL GOVERNMENTAL ASSISTANCE 83,080.94 439,794.24 720,000.00 280,205.76 61.1 TOTAL COMMUNITY SERVICE CONTRACTS 83,080.94 439,794.24 720,000.00 280,205.76 61.1 PUBLIC SERVICE CONTRACTS GOVERNMENTAL ASSISTANCE: 10-5111-8744 COMM 26,208.33 262,083.31 314,500.00 52,416.69 83.3 10-5111-8760 COMM SRVC JUSTICE 69,204.45 685,438.80 1,060,099.00 374,660.20 64.7 TOTAL GOVERNMENTAL ASSISTANCE 95,412.78 947,522.11 1,374,599.00 427,076.89 68.9 TOTAL PUBLIC SERVICE CONTRACTS 95,412.78 947,522.11 1,374,599.00 427,076.89 68.9 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 14,302.76 178,644.28 177,290.00 ( 1,354.28) 100.8 10-5201-1002 SALARIES/WAGES - OVERTIME .00 .00 100.00 100.00 .0 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 1,641.94 1,642.00 .06 100.0 10-5201-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 10-5201-1007 SALARIES/WAGES - INCENTIVE .00 1,206.40 1,206.00 ( .40) 100.0 TOTAL PERSONNEL SERVICES 14,377.76 182,392.62 181,138.00 ( 1,254.62) 100.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:13 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 1,154.98 14,638.41 14,533.00 ( 105.41) 100.7 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 4,330.61 54,374.05 55,644.00 1,269.95 97.7 10-5201-1025 EMPLOYEE BENEFITS - COMP 365.20 5,109.25 5,726.00 616.75 89.2 10-5201-1026 EMPLOYEE BENEFITS - COMP 720.06 8,958.81 8,839.00 ( 119.81) 101.4 10-5201-1029 EMPLOYEE BENEFITS - WY 2,354.30 30,310.39 30,459.00 148.61 99.5 TOTAL EMPLOYEE BENEFITS 8,925.15 113,390.91 115,201.00 1,810.09 98.4 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 540.00 540.00 .00 100.0 10-5201-2122 TRAINING/DEVELOPMENT .00 80.00 1,130.00 1,050.00 7.1 10-5201-2123 MEALS/LODGING/TRAVEL .00 .00 1,110.00 1,110.00 .0 TOTAL PURCHASED SERVICES .00 620.00 2,780.00 2,160.00 22.3 PROPERTY SERVICES: 10-5201-2131 UTILITY SERVICES - ELECTRICITY 259.60 1,630.59 2,000.00 369.41 81.5 10-5201-2134 TELECOMMUNICATIONS 40.01 572.18 494.00 ( 78.18) 115.8 TOTAL PROPERTY SERVICES 299.61 2,202.77 2,494.00 291.23 88.3 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5201-2156 MAINTENANCE AGREEMENT 55.62 706.01 1,000.00 293.99 70.6 10-5201-2158 MISC CONTRACTUAL SERVICES 138.00 4,902.00 2,500.00 ( 2,402.00) 196.1 10-5201-2161 INCARCERATION CONTRACT 135.00 1,140.00 2,500.00 1,360.00 45.6 TOTAL PROFESSIONAL SERVICES 328.62 6,748.01 7,000.00 251.99 96.4 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 477.72 3,112.04 5,000.00 1,887.96 62.2 10-5201-3233 UNIFORMS/CARE 475.75 475.75 500.00 24.25 95.2 10-5201-3235 FUEL 22.50 553.25 600.00 46.75 92.2 TOTAL SUPPLIES 975.97 4,141.04 6,100.00 1,958.96 67.9 TOTAL POLICE DEPT - ADMINISTRATION 24,907.11 309,495.35 314,713.00 5,217.65 98.3 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 60,999.78 846,736.32 1,121,155.00 274,418.68 75.5 10-5202-1002 SALARIES/WAGES - OVERTIME 5,939.60 70,683.73 53,000.00 ( 17,683.73) 133.4 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 2,816.59 3,557.00 740.41 79.2 10-5202-1006 SALARIES/WAGES - ALLOWANCES 50.00 3,379.58 1,200.00 ( 2,179.58) 281.6 10-5202-1007 SALARIES/WAGES - INCENTIVE .00 540.80 8,379.00 7,838.20 6.5 TOTAL PERSONNEL SERVICES 66,989.38 924,157.02 1,187,291.00 263,133.98 77.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:14 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 5,207.80 71,781.32 91,895.00 20,113.68 78.1 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 24,714.54 297,998.76 409,729.00 111,730.24 72.7 10-5202-1025 EMPLOYEE BENEFITS - COMP 1,701.52 23,473.33 34,778.00 11,304.67 67.5 10-5202-1026 EMPLOYEE BENEFITS - COMP 1,086.68 14,161.37 13,947.00 ( 214.37) 101.5 10-5202-1029 EMPLOYEE BENEFITS - WY 11,470.23 154,544.12 199,379.00 44,834.88 77.5 TOTAL EMPLOYEE BENEFITS 44,180.77 561,958.90 749,728.00 187,769.10 75.0 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 990.00 1,295.00 305.00 76.5 10-5202-2122 TRAINING/DEVELOPMENT .00 1,587.95 17,980.00 16,392.05 8.8 10-5202-2123 MEALS/LODGING/TRAVEL 61.40 2,527.12 10,470.00 7,942.88 24.1 TOTAL PURCHASED SERVICES 61.40 5,105.07 29,745.00 24,639.93 17.2 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,149.69 15,138.46 17,635.00 2,496.54 85.8 TOTAL PROPERTY SERVICES 1,149.69 15,138.46 17,635.00 2,496.54 85.8 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE .00 885.59 10,000.00 9,114.41 8.9 10-5202-2156 MAINTENANCE AGREEMENT .00 10,642.03 13,286.00 2,643.97 80.1 10-5202-2158 MISC CONTRACTUAL SERVICES .00 2,630.00 2,500.00 ( 130.00) 105.2 TOTAL PROFESSIONAL SERVICES .00 14,157.62 25,786.00 11,628.38 54.9 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES 130.46 154.34 300.00 145.66 51.5 10-5202-3210 OPERATING SUPPLIES 2,500.28 23,208.64 30,350.00 7,141.36 76.5 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 23,878.75 27,425.00 3,546.25 87.1 10-5202-3233 UNIFORMS/CARE 1,087.07 13,228.48 19,100.00 5,871.52 69.3 10-5202-3235 FUEL 2,517.08 19,743.77 16,500.00 ( 3,243.77) 119.7 TOTAL SUPPLIES 6,234.89 80,213.98 93,675.00 13,461.02 85.6 TOTAL POLICE DEPT - PATROL 118,616.13 1,600,731.05 2,103,860.00 503,128.95 76.1 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 11,365.72 147,491.54 147,750.00 258.46 99.8 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,210.10 1,210.00 ( .10) 100.0 10-5301-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 10-5301-1007 SALARIES/WAGES - INCENTIVE .00 499.20 998.00 498.80 50.0 TOTAL PERSONNEL SERVICES 11,440.72 150,100.84 150,858.00 757.16 99.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:15 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 877.96 11,520.27 11,541.00 20.73 99.8 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 2,898.83 34,785.96 34,841.00 55.04 99.8 10-5301-1025 EMPLOYEE BENEFITS - COMP 290.59 3,812.49 4,421.00 608.51 86.2 10-5301-1029 EMPLOYEE BENEFITS - WY 1,954.90 25,364.17 25,295.00 ( 69.17) 100.3 TOTAL EMPLOYEE BENEFITS 6,022.28 75,482.89 76,098.00 615.11 99.2 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 212.00 461.00 249.00 46.0 10-5301-2122 TRAINING/DEVELOPMENT .00 1,004.00 1,435.00 431.00 70.0 10-5301-2123 MEALS/LODGING/TRAVEL .00 240.77 1,150.00 909.23 20.9 TOTAL PURCHASED SERVICES .00 1,456.77 3,046.00 1,589.23 47.8 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 760.72 9,876.82 10,750.00 873.18 91.9 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 791.81 4,360.11 10,000.00 5,639.89 43.6 10-5301-2133 UTILITY SERVICES - NATURAL GAS 513.38 9,315.08 9,500.00 184.92 98.1 10-5301-2134 TELECOMMUNICATIONS 91.01 514.23 500.00 ( 14.23) 102.9 TOTAL PROPERTY SERVICES 2,156.92 24,066.24 30,750.00 6,683.76 78.3 PROFESSIONAL SERVICES: 10-5301-2153 ARCHITECT/ENGINEERING/SURVEING .00 830.00 1,000.00 170.00 83.0 10-5301-2155 REPAIRS/MAINTENANCE .00 160.00 1,500.00 1,340.00 10.7 10-5301-2156 MAINTENANCE AGREEMENT 57.21 2,732.93 3,880.00 1,147.07 70.4 TOTAL PROFESSIONAL SERVICES 57.21 3,722.93 6,380.00 2,657.07 58.4 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 225.00 2,145.33 3,000.00 854.67 71.5 10-5301-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 156.75 1,965.91 3,150.00 1,184.09 62.4 10-5301-3230 REFRESHMENT SUPPLIES 100.40 735.86 750.00 14.14 98.1 10-5301-3235 FUEL 74.48 995.19 2,500.00 1,504.81 39.8 TOTAL SUPPLIES 556.63 5,842.29 9,400.00 3,557.71 62.2 TOTAL PUBLIC WORKS - ADMINISTRATION 20,233.76 260,671.96 276,532.00 15,860.04 94.3 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 14,868.82 227,442.40 231,499.00 4,056.60 98.3 10-5302-1002 SALARIES/WAGES - OVERTIME .00 166.61 500.00 333.39 33.3 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 2,285.03 2,287.00 1.97 99.9 10-5302-1006 SALARIES/WAGES-ALLOWANCE 50.00 300.00 .00 ( 300.00) .0 10-5302-1007 SALARIES/WAGES - INCENTIVE .00 1,913.60 4,317.00 2,403.40 44.3 TOTAL PERSONNEL SERVICES 14,918.82 232,107.64 238,603.00 6,495.36 97.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:16 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,190.57 18,478.76 18,956.00 477.24 97.5 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 5,727.52 72,641.99 83,675.00 11,033.01 86.8 10-5302-1025 EMPLOYEE BENEFITS - COMP 378.94 5,895.58 7,028.00 1,132.42 83.9 10-5302-1026 EMPLOYEE BENEFITS - COMP 633.32 9,283.51 8,405.00 ( 878.51) 110.5 10-5302-1029 EMPLOYEE BENEFITS - WY 2,557.44 34,820.00 39,718.00 4,898.00 87.7 TOTAL EMPLOYEE BENEFITS 10,487.79 141,119.84 157,782.00 16,662.16 89.4 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 3,025.58 3,020.00 ( 5.58) 100.2 10-5302-2122 TRAINING/DEVELOPMENT .00 690.38 300.00 ( 390.38) 230.1 TOTAL PURCHASED SERVICES .00 3,715.96 3,320.00 ( 395.96) 111.9 PROPERTY SERVICES: 10-5302-2141 EQUIPMENT RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES .00 .00 200.00 200.00 .0 PROFESSIONAL SERVICES: 10-5302-2155 REPAIRS/MAINTENANCE .00 2,718.30 3,100.00 381.70 87.7 TOTAL PROFESSIONAL SERVICES .00 2,718.30 3,100.00 381.70 87.7 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 330.50 13,761.75 14,000.00 238.25 98.3 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 2,195.73 21,070.60 22,335.00 1,264.40 94.3 10-5302-3235 FUEL 292.10 1,721.79 2,000.00 278.21 86.1 10-5302-3237 OIL/LUBE/FLUIDS 3,621.28 10,830.94 12,500.00 1,669.06 86.7 TOTAL SUPPLIES 6,439.61 47,385.08 50,835.00 3,449.92 93.2 TOTAL PUBLIC WORKS - SHOP 31,846.22 427,046.82 453,840.00 26,793.18 94.1 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 18,153.66 231,518.33 230,741.00 ( 777.33) 100.3 10-5304-1002 SALARIES/WAGES - OVERTIME 138.81 1,218.39 2,000.00 781.61 60.9 10-5304-1004 SALARIES/WAGES - TEMPORARY 5,263.20 22,965.72 59,640.00 36,674.28 38.5 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 832.87 832.00 ( .87) 100.1 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5304-1007 SALARIES/WAGES - INCENTIVE .00 .00 541.00 541.00 .0 TOTAL PERSONNEL SERVICES 23,580.67 256,835.31 294,054.00 37,218.69 87.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:17 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 1,809.18 19,784.33 22,525.00 2,740.67 87.8 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 10,282.24 124,352.87 123,092.00 ( 1,260.87) 101.0 10-5304-1025 EMPLOYEE BENEFITS - COMP 598.94 6,549.60 8,686.00 2,136.40 75.4 10-5304-1026 EMPLOYEE BENEFITS - COMP 38.38 364.61 .00 ( 364.61) .0 10-5304-1029 EMPLOYEE BENEFITS - WY 3,146.32 40,199.18 39,845.00 ( 354.18) 100.9 TOTAL EMPLOYEE BENEFITS 15,875.06 191,250.59 194,148.00 2,897.41 98.5 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 400.00 550.00 150.00 72.7 10-5304-2122 TRAINING/DEVELOPMENT .00 825.00 940.00 115.00 87.8 10-5304-2123 MEALS/LODGING/TRAVEL .00 .00 1,655.00 1,655.00 .0 TOTAL PURCHASED SERVICES .00 1,225.00 3,145.00 1,920.00 39.0 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 1,089.14 15,737.04 18,000.00 2,262.96 87.4 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 25,206.52 96,082.04 80,000.00 ( 16,082.04) 120.1 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 26,295.66 111,819.08 99,000.00 ( 12,819.08) 113.0 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE .00 150.80 5,000.00 4,849.20 3.0 10-5304-2156 MAINTENANCE AGREEMENT .00 763.00 1,250.00 487.00 61.0 10-5304-2158 MISC CONTRACTUAL SERVICES 1,000.00 22,230.00 25,000.00 2,770.00 88.9 TOTAL PROFESSIONAL SERVICES 1,000.00 23,143.80 31,250.00 8,106.20 74.1 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 873.08 40,242.80 40,000.00 ( 242.80) 100.6 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5304-3235 FUEL 1,252.45 9,003.45 10,000.00 996.55 90.0 TOTAL SUPPLIES 2,125.53 49,246.25 51,000.00 1,753.75 96.6 TOTAL PUBLIC WORKS - PARKS 68,876.92 633,520.03 672,597.00 39,076.97 94.2 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 20,293.57 264,329.61 261,022.00 ( 3,307.61) 101.3 10-5305-1002 SALARIES/WAGES - OVERTIME .00 2,711.83 4,000.00 1,288.17 67.8 10-5305-1004 SALARIES/WAGES - TEMPORARY .00 7,255.31 11,928.00 4,672.69 60.8 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 1,254.95 1,255.00 .05 100.0 10-5305-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5305-1007 SALARIES/WAGES - INCENTIVE .00 1,331.20 2,637.00 1,305.80 50.5 TOTAL PERSONNEL SERVICES 20,318.57 277,182.90 281,142.00 3,959.10 98.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:18 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,561.26 21,293.84 21,596.00 302.16 98.6 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 8,021.82 96,251.75 120,432.00 24,180.25 79.9 10-5305-1025 EMPLOYEE BENEFITS - COMP 516.07 7,040.37 8,274.00 1,233.63 85.1 10-5305-1026 EMPLOYEE BENEFITS - COMP 59.58 773.81 774.00 .19 100.0 10-5305-1029 EMPLOYEE BENEFITS - WY 3,490.49 45,242.69 45,372.00 129.31 99.7 TOTAL EMPLOYEE BENEFITS 13,649.22 170,602.46 196,448.00 25,845.54 86.8 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT 425.00 750.00 1,040.00 290.00 72.1 10-5305-2123 MEALS/LODGING/TRAVEL .00 .00 675.00 675.00 .0 TOTAL PURCHASED SERVICES 425.00 750.00 1,715.00 965.00 43.7 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 8,403.62 32,969.58 66,000.00 33,030.42 50.0 10-5305-2158 MISC CONTRACTUAL SERVICES 15,049.26 19,301.22 53,200.00 33,898.78 36.3 TOTAL PROFESSIONAL SERVICES 23,452.88 52,270.80 119,200.00 66,929.20 43.9 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 3,089.73 76,821.85 70,700.00 ( 6,121.85) 108.7 10-5305-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5305-3235 FUEL 3,055.44 22,694.96 28,500.00 5,805.04 79.6 TOTAL SUPPLIES 6,145.17 99,516.81 100,200.00 683.19 99.3 TOTAL PUBLIC WORKS - STREETS/ALLEYS 63,990.84 600,322.97 698,705.00 98,382.03 85.9 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 9,066.31 115,127.30 114,007.00 ( 1,120.30) 101.0 10-5306-1002 SALARIES/WAGES - OVERTIME 68.49 1,974.10 1,500.00 ( 474.10) 131.6 10-5306-1004 SALARIES/WAGES - TEMPORARY .00 10,831.40 11,928.00 1,096.60 90.8 10-5306-1005 SALARIES/WAGES - LONGEVITY .00 828.33 828.00 ( .33) 100.0 10-5306-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5306-1007 SALARIES/WAGES - INCENTIVE .00 998.40 1,642.00 643.60 60.8 TOTAL PERSONNEL SERVICES 9,159.80 130,059.53 130,205.00 145.47 99.9 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 703.79 9,902.79 9,990.00 87.21 99.1 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 4,120.54 48,463.94 49,330.00 866.06 98.2 10-5306-1025 EMPLOYEE BENEFITS - COMP 232.65 3,277.55 3,820.00 542.45 85.8 10-5306-1026 EMPLOYEE BENEFITS - COMP 38.38 364.61 .00 ( 364.61) .0 10-5306-1029 EMPLOYEE BENEFITS - WY 1,571.18 19,962.53 19,775.00 ( 187.53) 101.0 TOTAL EMPLOYEE BENEFITS 6,666.54 81,971.42 82,915.00 943.58 98.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:18AM PAGE:19 PURCHASED SERVICES: 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 100.00 100.00 .00 100.0 10-5306-2122 TRAINING/DEVELOPMENT .00 300.00 300.00 .00 100.0 TOTAL PURCHASED SERVICES .00 400.00 400.00 .00 100.0 PROPERTY SERVICES: 10-5306-2131 UTILITY SERVICES - ELECTRICITY 275.84 3,272.19 3,000.00 ( 272.19) 109.1 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 17,427.13 49,916.91 50,000.00 83.09 99.8 10-5306-2133 UTILITY SERVICES - NATURAL GAS 77.36 1,265.22 1,500.00 234.78 84.4 10-5306-2134 TELECOMMUNICATIONS 132.80 1,002.42 1,650.00 647.58 60.8 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 17,913.13 55,456.74 56,350.00 893.26 98.4 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE 2,476.00 2,476.00 1,500.00 ( 976.00) 165.1 10-5306-2156 MAINTENANCE AGREEMENT .00 765.00 750.00 ( 15.00) 102.0 10-5306-2158 MISC CONTRACTUAL SERVICES .00 7,000.00 7,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES 2,476.00 10,241.00 9,250.00 ( 991.00) 110.7 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 1,419.30 12,932.79 13,000.00 67.21 99.5 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5306-3235 FUEL 542.26 2,290.37 2,500.00 209.63 91.6 TOTAL SUPPLIES 1,961.56 15,223.16 16,500.00 1,276.84 92.3 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND .00 800.00 1,000.00 200.00 80.0 TOTAL CAPITALIZED EXPENDITURES .00 800.00 1,000.00 200.00 80.0 TOTAL PUBLIC WORKS - CEMETERY 38,177.03 294,151.85 296,620.00 2,468.15 99.2 PUBLIC WORKS - SWIM POOL PERSONNEL SERVICES: 10-5307-1004 SALARIES/WAGES - TEMPORARY .00 60,371.33 75,000.00 14,628.67 80.5 TOTAL PERSONNEL SERVICES .00 60,371.33 75,000.00 14,628.67 80.5 EMPLOYEE BENEFITS: 10-5307-1021 EMPLOYEE BENEFITS - SCL .00 4,618.38 5,738.00 1,119.62 80.5 10-5307-1025 EMPLOYEE BENEFITS - COMP .00 1,533.47 2,213.00 679.53 69.3 TOTAL EMPLOYEE BENEFITS .00 6,151.85 7,951.00 1,799.15 77.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:19AM PAGE:20 PURCHASED SERVICES: 10-5307-2122 TRAINING/DEVELOPMENT .00 .00 1,000.00 1,000.00 .0 TOTAL PURCHASED SERVICES .00 .00 1,000.00 1,000.00 .0 PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 280.81 5,332.32 7,000.00 1,667.68 76.2 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 2,316.51 7,038.27 12,000.00 4,961.73 58.7 10-5307-2133 UTILITY SERVICES - NATURAL GAS 2,053.70 6,308.76 6,000.00 ( 308.76) 105.2 10-5307-2134 TELECOMMUNICATIONS 450.29 1,284.25 1,500.00 215.75 85.6 TOTAL PROPERTY SERVICES 5,101.31 19,963.60 26,500.00 6,536.40 75.3 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE 875.00 1,401.50 5,000.00 3,598.50 28.0 10-5307-2158 MISC CONTRACTUAL SERVICES .00 .00 6,000.00 6,000.00 .0 TOTAL PROFESSIONAL SERVICES 875.00 1,401.50 11,000.00 9,598.50 12.7 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 5,465.47 11,888.46 20,000.00 8,111.54 59.4 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 2,500.00 2,500.00 .0 TOTAL SUPPLIES 5,465.47 11,888.46 22,500.00 10,611.54 52.8 TOTAL PUBLIC WORKS - SWIM POOL 11,441.78 99,776.74 143,951.00 44,174.26 69.3 OPERATING TRANSFERS - OUT OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE 237,500.00 950,000.00 950,000.00 .00 100.0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ .00 .00 3,180.00 3,180.00 .0 10-5998-4331 TRANSFER TO WATER 2,234,553.35 2,234,553.35 1,650,000.00 ( 584,553.35) 135.4 10-5998-4339 TRANSFER TO HEALTH INS RESERVE .00 .00 100,000.00 100,000.00 .0 10-5998-4341 TRANSFER TO ECONOMIC DEVELOPME 43,750.00 175,000.00 175,000.00 .00 100.0 10-5998-4350 TRANSFER TO FIRE EQUIPMENT 150,000.00 600,000.00 600,000.00 .00 100.0 10-5998-4354 TRANSFER TO TRAIN CAR RESTORAT .00 .00 4,000.00 4,000.00 .0 10-5998-4355 TRANSFER TO POOL IMPROVEMENT 12,500.00 50,000.00 50,000.00 .00 100.0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT 1,625,000.00 6,500,000.00 6,500,000.00 .00 100.0 10-5998-4357 TRANSFER TO PUBLIC FACILITIES 2,450,000.00 2,450,000.00 2,450,000.00 .00 100.0 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS 875,000.00 3,500,000.00 3,500,000.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 200.00 800.00 800.00 .00 100.0 TOTAL OPERATING TRANSFERS 7,628,503.35 16,460,353.35 15,982,980.00 ( 477,373.35) 103.0 TOTAL OPERATING TRANSFERS - OUT 7,628,503.35 16,460,353.35 15,982,980.00 ( 477,373.35) 103.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:19AM PAGE:21 TOTAL FUND EXPENDITURES 8,640,656.37 24,257,516.00 25,447,729.00 1,190,213.00 95.3 NET REVENUE OVER EXPENDITURES ( 7,213,667.19) ( 1,338,135.98) ( 9,912,903.00) ( 8,574,767.02) ( 13.5) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:19AM PAGE:22 ASSETS CURRENT ASSETS: CASH: 11-10000116 CASH ALLOC FR COMBINED FUND 677,058.02 TOTAL CASH 677,058.02 TOTAL CURRENT ASSETS 677,058.02 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 677,058.02 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 11-30000300 FUND BALANCE/BEGINNING OF YEAR 21,526.49 TOTAL CAPITAL ASSETS 21,526.49 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 655,531.53 BALANCE - CURRENT DATE 677,058.02 TOTAL NET ASSETS 677,058.02 TOTAL LIABILITIES AND NET ASSETS 677,058.02 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 IMPACT ASSISTANCE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:19AM PAGE:23 IMPACT ASSISTANCE - REVENUE STATE REVENUE: 11-4110-3239 IMPACT ASST-CEDAR SPRINGS 104,731.53 655,531.53 .00 ( 655,531.53) .0 TOTAL STATE REVENUE 104,731.53 655,531.53 .00 ( 655,531.53) .0 TOTAL IMPACT ASSISTANCE - REVENUE 104,731.53 655,531.53 .00 ( 655,531.53) .0 TOTAL FUND REVENUE 104,731.53 655,531.53 .00 ( 655,531.53) .0 NET REVENUE OVER EXPENDITURES 104,731.53 655,531.53 .00 ( 655,531.53) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:28AM PAGE:24 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 23,763.92 TOTAL CASH 23,763.92 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 3,078.61 13-10000132 ACCOUNTS RECEIVABLE - EOY 43,269.72 TOTAL ACCOUNTS RECEIVABLE 46,348.33 TOTAL CURRENT ASSETS 70,112.25 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 70,112.25 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 853.99 13-20000215 WAGES PAYABLE - CLEARING 5,240.45 13-20000216 WAGES PAYABLE - EOY ( 5,240.45) TOTAL ACCOUNTS PAYABLE 853.99 TOTAL CURRENT LIABILITIES 853.99 TOTAL LIABILITIES 853.99 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 26,028.75 TOTAL CAPITAL ASSETS 26,028.75 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:28AM PAGE:25 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 43,229.51 BALANCE - CURRENT DATE 69,258.26 TOTAL NET ASSETS 69,258.26 TOTAL LIABILITIES AND NET ASSETS 70,112.25 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:28AM PAGE:26 ASSET SEIZURE - REVENUE FEDERAL REVENUE SOURCES: 13-4130-4286 SEIZURE FUNDS .00 628.56 .00 ( 628.56) .0 TOTAL FEDERAL REVENUE SOURCES .00 628.56 .00 ( 628.56) .0 TOTAL ASSET SEIZURE - REVENUE .00 628.56 .00 ( 628.56) .0 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 103.61 17,696.18 29,624.00 11,927.82 59.7 TOTAL FEDERAL REVENUE SOURCES 103.61 17,696.18 29,624.00 11,927.82 59.7 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 103.61 17,696.18 29,624.00 11,927.82 59.7 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 2,975.00 5,798.51 7,658.00 1,859.49 75.7 TOTAL STATE REVENUE 2,975.00 5,798.51 7,658.00 1,859.49 75.7 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE 2,975.00 5,798.51 7,658.00 1,859.49 75.7 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 1,233.75 3,180.00 1,946.25 38.8 TOTAL FEDERAL REVENUE SOURCES .00 1,233.75 3,180.00 1,946.25 38.8 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND .00 .00 3,180.00 3,180.00 .0 TOTAL TRANSFERS IN .00 .00 3,180.00 3,180.00 .0 TOTAL BULLET PROOF VEST - REVENUE .00 1,233.75 6,360.00 5,126.25 19.4 SCHOOL VIOLENCE PREVENTION-REV ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:30AM PAGE:27 FEDERAL REVENUE SOURCES: 13-4897-4292 DEPARTMENT OF JUSTICE .00 112,750.25 112,750.00 ( .25) 100.0 TOTAL FEDERAL REVENUE SOURCES .00 112,750.25 112,750.00 ( .25) 100.0 TOTAL SCHOOL VIOLENCE PREVENTION-REV .00 112,750.25 112,750.00 ( .25) 100.0 TOTAL FUND REVENUE 3,078.61 138,107.25 156,392.00 18,284.75 88.3 ASSET SEIZURE SUPPLIES: 13-5130-3210 OPERATING SUPPLIES .00 .00 3,376.00 3,376.00 .0 TOTAL SUPPLIES .00 .00 3,376.00 3,376.00 .0 TOTAL ASSET SEIZURE .00 .00 3,376.00 3,376.00 .0 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR 81.33 2,257.77 11,590.00 9,332.23 19.5 TOTAL PERSONNEL SERVICES 81.33 2,257.77 11,590.00 9,332.23 19.5 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL 6.22 172.71 887.00 714.29 19.5 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS 58.85 380.31 .00 ( 380.31) .0 13-5821-1025 EMPLOYEE BENEFITS - COMP 2.07 57.36 342.00 284.64 16.8 13-5821-1029 EMPLOYEE BENEFITS - WY 13.98 388.34 1,985.00 1,596.66 19.6 TOTAL EMPLOYEE BENEFITS 81.12 998.72 3,214.00 2,215.28 31.1 SUPPLIES: 13-5821-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 6,000.00 6,000.00 .00 100.0 TOTAL SUPPLIES .00 6,000.00 6,000.00 .00 100.0 CAPITALIZED EXPENDITURES: 13-5821-6547 EQUIPMENT/FURNITURE .00 8,820.00 8,820.00 .00 100.0 TOTAL CAPITALIZED EXPENDITURES .00 8,820.00 8,820.00 .00 100.0 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE 162.45 18,076.49 29,624.00 11,547.51 61.0 OJJDP-UNDERAGE ENFORCEMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:31AM PAGE:28 PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 452.10 1,865.03 3,616.00 1,750.97 51.6 TOTAL PERSONNEL SERVICES 452.10 1,865.03 3,616.00 1,750.97 51.6 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 34.58 142.70 277.00 134.30 51.5 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS 61.81 277.46 618.00 340.54 44.9 13-5831-1025 EMPLOYEE BENEFITS - COMP 11.47 47.37 107.00 59.63 44.3 13-5831-1029 EMPLOYEE BENEFITS - WY 77.76 300.26 620.00 319.74 48.4 TOTAL EMPLOYEE BENEFITS 185.62 767.79 1,622.00 854.21 47.3 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES 520.00 1,420.00 1,480.00 60.00 96.0 TOTAL PROFESSIONAL SERVICES 520.00 1,420.00 1,480.00 60.00 96.0 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 333.99 800.40 940.00 139.60 85.2 TOTAL SUPPLIES 333.99 800.40 940.00 139.60 85.2 TOTAL OJJDP-UNDERAGE ENFORCEMENT 1,491.71 4,853.22 7,658.00 2,804.78 63.4 BULLET PROOF VEST PROTECTION SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 2,467.50 6,360.00 3,892.50 38.8 TOTAL SUPPLIES .00 2,467.50 6,360.00 3,892.50 38.8 TOTAL BULLET PROOF VEST PROTECTION .00 2,467.50 6,360.00 3,892.50 38.8 SCHOOL VIOLENCE PREVENTION PRO CAPITALIZED EXPENDITURES: 13-5897-6547 EQUIPMENT/FURINITURE .00 69,480.53 69,481.00 .47 100.0 TOTAL CAPITALIZED EXPENDITURES .00 69,480.53 69,481.00 .47 100.0 TOTAL SCHOOL VIOLENCE PREVENTION PRO .00 69,480.53 69,481.00 .47 100.0 TOTAL FUND EXPENDITURES 1,654.16 94,877.74 116,499.00 21,621.26 81.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:31AM PAGE:29 NET REVENUE OVER EXPENDITURES 1,424.45 43,229.51 39,893.00 ( 3,336.51) 108.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:50AM PAGE:30 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 3,752,965.44 31-10000117 CASH WITH FISCAL AGENT 304,717.81 31-10000118 MONEY MARKET ACCOUNT 121,375.21 TOTAL CASH 4,179,058.46 INVESTMENTS: 31-10000120 INVESTMENT POOL 3,980,000.00 31-10000122 TIME DEPOSITS - SHORT TERM 3,345,755.39 TOTAL INVESTMENTS 7,325,755.39 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 459,195.01 31-10000132 ACCOUNTS RECEIVABLE - EOY 170,170.20 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 354,169.64 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 7,165.69) 31-10000139 ACCRUED INTEREST RECEIVABLE 44,721.34 31-10000140 DUE FROM OTHER FUNDS ( 4,458.98) 31-10000156 DUE FROM OTHER FUNDS 25,865.50 TOTAL ACCOUNTS RECEIVABLE 1,042,497.02 TOTAL CURRENT ASSETS 12,547,310.87 FIXED ASSETS: 31-10000181 BUILDINGS 13,391,701.48 31-10000182 ACCUMULATED - BUILDINGS ( 6,298,049.42) 31-10000183 VEHICLES 382,306.47 31-10000184 ACCUMULATED - VEHICLES ( 354,085.80) 31-10000185 EQUIPMENT 472,923.90 31-10000186 ACCUMULATED - EQUIPMENT ( 384,239.52) 31-10000188 IMPROVEMENTS OTHER THAN BLDG 12,683,503.95 31-10000189 ACCUMULATED OT BLDG ( 6,351,320.31) TOTAL FIXED ASSETS 13,542,740.75 OTHER ASSETS: 31-10000190 ACCUMULATED ( 500,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 4,963,103.07 31-10006100 DEFERRED OUTFLOW OF RESOURCES 140,920.03 TOTAL OTHER ASSETS 4,604,023.10 TOTAL NON-CURRENT ASSETS 18,146,763.85 TOTAL ASSETS 30,694,074.72 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:50AM PAGE:31 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 854,551.41 31-20000204 ACCOUNTS PAYABLE - EOY 39,553.15 31-20000210 RETAINAGE PAYABLE 334,743.25 31-20000215 WAGES PAYABLE 12,790.60 TOTAL ACCOUNTS PAYABLE 1,241,638.41 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 463,654.40 TOTAL OTHER PAYABLES 463,654.40 TOTAL CURRENT LIABILITIES 1,705,292.81 NON-CURRENT LIABILITIES: 31-20000250 LEASES PAYABLE 288.00 31-20000265 COMPENSATED ABSENCES PAYABLE 47,887.02 TOTAL NON-CURRENT LIABILITIES 48,175.02 TOTAL LIABILITIES 1,753,467.83 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 3,889,709.11 31-30000305 RESERVE FOR REPLACEMENT 4,357,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 484,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 75,000.00 TOTAL CAPITAL ASSETS 9,381,949.80 OTHER NET ASSETS: 31-30000320 CAPITAL ASSETS NET OF DEBT 18,505,556.00 TOTAL OTHER NET ASSETS 18,505,556.00 REVENUE OVER EXPENDITURES - YTD 1,053,101.09 BALANCE - CURRENT DATE 28,940,606.89 TOTAL NET ASSETS 28,940,606.89 TOTAL LIABILITIES AND NET ASSETS 30,694,074.72 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:50AM PAGE:32 WATER - REVENUE MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 5,523.11 2,000.00 ( 3,523.11) 276.2 31-4310-1140 INTEREST INCOME 4,795.16 71,069.74 175,000.00 103,930.26 40.6 TOTAL MISC LOCAL REVENUE 4,795.16 76,592.85 177,000.00 100,407.15 43.3 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 297,850.16 2,480,105.32 2,300,000.00 ( 180,105.32) 107.8 31-4310-1705 UTILITY SERVICE FEES 450.00 17,675.00 20,000.00 2,325.00 88.4 31-4310-1706 WATER PLANT INVESTMENT FEES 5,950.00 52,750.00 2,000.00 ( 50,750.00) 2637.5 31-4310-1707 UTILITY LATE FEES .00 12,285.00 20,000.00 7,715.00 61.4 31-4310-1710 BULK WATER 13,153.21 201,017.26 100,000.00 ( 101,017.26) 201.0 TOTAL UTILITIES REVENUE 317,403.37 2,763,832.58 2,442,000.00 ( 321,832.58) 113.2 TRANSFERS IN: 31-4310-5596 TRANSFER FROM UTILITY DEPOSIT 431.92 1,241.01 200.00 ( 1,041.01) 620.5 TOTAL TRANSFERS IN 431.92 1,241.01 200.00 ( 1,041.01) 620.5 TOTAL WATER - REVENUE 322,630.45 2,841,666.44 2,619,200.00 ( 222,466.44) 108.5 LITTLE BOX ELDER SPRING - REVE STATE REVENUE: 31-4855-3235 WWDC GRANT 548,389.73 3,009,587.50 3,350,000.00 340,412.50 89.8 TOTAL STATE REVENUE 548,389.73 3,009,587.50 3,350,000.00 340,412.50 89.8 TRANSFERS IN: 31-4855-5510 TRANSFER FROM GENERAL FUND 2,234,553.35 2,234,553.35 1,650,000.00 ( 584,553.35) 135.4 TOTAL TRANSFERS IN 2,234,553.35 2,234,553.35 1,650,000.00 ( 584,553.35) 135.4 TOTAL LITTLE BOX ELDER SPRING - REVE 2,782,943.08 5,244,140.85 5,000,000.00 ( 244,140.85) 104.9 TOTAL FUND REVENUE 3,105,573.53 8,085,807.29 7,619,200.00 ( 466,607.29) 106.1 WATER - ADMINISTRATION DEPRECIATION: 31-5400-1150 DEPRECIATION 125,000.00 500,000.00 500,000.00 .00 100.0 TOTAL DEPRECIATION 125,000.00 500,000.00 500,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:51AM PAGE:33 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 452.70 5,427.07 5,000.00 ( 427.07) 108.5 31-5400-2166 COLLECTION FEES 75.80 980.28 250.00 ( 730.28) 392.1 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE 20.28 13,887.94 13,618.00 ( 269.94) 102.0 TOTAL PROFESSIONAL SERVICES 548.78 20,295.29 18,868.00 ( 1,427.29) 107.6 FINANCIAL: 31-5400-4344 DEBT PAYMENT - CAPITAL LEASE .00 288.00 384.00 96.00 75.0 TOTAL FINANCIAL .00 288.00 384.00 96.00 75.0 OPERATING TRANSFERS: 31-5400-4347 MANAGEMENT FEES 66,303.00 265,212.00 265,212.00 .00 100.0 TOTAL OPERATING TRANSFERS 66,303.00 265,212.00 265,212.00 .00 100.0 TOTAL WATER - ADMINISTRATION 191,851.78 785,795.29 784,464.00 ( 1,331.29) 100.2 WATER - TREATMENT CASH FUND APPROPRIATION: 31-5401-0150 REPLACEMENT RESERVE-SAND FILTE 50,000.00 50,000.00 50,000.00 .00 100.0 31-5401-0153 REPLACEMENT RESERVE-SMW REHA 15,000.00 15,000.00 15,000.00 .00 100.0 TOTAL CASH FUND APPROP 65,000.00 65,000.00 65,000.00 .00 100.0 PERSONNEL SERVICES: 31-5401-1001 SALARIES/WAGES - REGULAR 7,792.46 101,265.48 101,310.00 44.52 100.0 31-5401-1002 SALARIES/WAGES - OVERTIME 1,049.64 5,947.93 6,000.00 52.07 99.1 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 534.95 536.00 1.05 99.8 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 31-5401-1007 SALARIES/WAGES - INCENTIVE .00 .00 2,026.00 2,026.00 .0 TOTAL PERSONNEL SERVICES 8,867.10 108,048.36 110,172.00 2,123.64 98.1 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 692.54 8,450.50 8,613.00 162.50 98.1 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 5,133.81 47,328.02 37,066.00 ( 10,262.02) 127.7 31-5401-1025 EMPLOYEE BENEFITS - COMP 225.23 2,744.54 3,202.00 457.46 85.7 31-5401-1026 EMPLOYEE BENEFITS - COMP 155.86 2,025.43 2,026.00 .57 100.0 31-5401-1029 EMPLOYEE BENEFITS - WY 1,520.84 18,437.78 18,371.00 ( 66.78) 100.4 TOTAL EMPLOYEE BENEFITS 7,728.28 78,986.27 69,278.00 ( 9,708.27) 114.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:51AM PAGE:34 PURCHASED SERVICES: 31-5401-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 300.00 300.00 .0 31-5401-2122 TRAINING/DEVELOPMENT .00 812.50 2,570.00 1,757.50 31.6 31-5401-2123 MEALS/LODGING/TRAVEL .00 .00 800.00 800.00 .0 TOTAL PURCHASED SERVICES .00 812.50 3,670.00 2,857.50 22.1 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 5,100.87 39,541.31 60,000.00 20,458.69 65.9 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 1,265.63 7,878.86 7,000.00 ( 878.86) 112.6 31-5401-2133 UTILITY SERVICES - NATURAL GAS 354.64 5,594.70 5,250.00 ( 344.70) 106.6 31-5401-2134 TELECOMMUNICATIONS 15.19 184.72 400.00 215.28 46.2 31-5401-2140 RENT - LAND/BUILDINGS .00 9,323.83 10,000.00 676.17 93.2 TOTAL PROPERTY SERVICES 6,736.33 62,523.42 82,650.00 20,126.58 75.7 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 1,112.49 2,500.00 1,387.51 44.5 31-5401-2155 REPAIRS/MAINTENANCE 1,269.13 15,591.88 15,000.00 ( 591.88) 104.0 31-5401-2156 MAINTENANCE AGREEMENT .00 5,766.00 6,750.00 984.00 85.4 31-5401-2158 MISC CONTRACTUAL SERVICES 6,037.26 20,749.49 30,000.00 9,250.51 69.2 TOTAL PROFESSIONAL SERVICES 7,306.39 43,219.86 54,250.00 11,030.14 79.7 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 2,409.81 29,648.00 25,000.00 ( 4,648.00) 118.6 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,129.30 27,791.91 34,500.00 6,708.09 80.6 31-5401-3235 FUEL 193.86 2,173.30 2,500.00 326.70 86.9 TOTAL SUPPLIES 3,732.97 59,613.21 62,000.00 2,386.79 96.2 CAPITALIZED EXPENDITURES: 31-5401-6542 TO BLDG .00 56,070.13 73,500.00 17,429.87 76.3 TOTAL CAPITALIZED EXPENDITURES .00 56,070.13 73,500.00 17,429.87 76.3 TOTAL WATER - TREATMENT 99,371.07 474,273.75 520,520.00 46,246.25 91.1 WATER - DISTRIBUTION/MAINTNCE PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 12,672.25 172,070.07 187,187.00 15,116.93 91.9 31-5402-1002 SALARIES/WAGES - OVERTIME 1,461.94 9,157.46 7,500.00 ( 1,657.46) 122.1 31-5402-1004 SALARIES/WAGES - TEMPORARY .00 2,272.40 2,982.00 709.60 76.2 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 848.14 848.00 ( .14) 100.0 31-5402-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 31-5402-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,011.00 1,011.00 .0 TOTAL PERSONNEL SERVICES 14,159.19 184,648.07 199,828.00 15,179.93 92.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:51AM PAGE:35 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,085.47 14,155.31 15,317.00 1,161.69 92.4 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 5,948.52 69,373.61 71,275.00 1,901.39 97.3 31-5402-1025 EMPLOYEE BENEFITS - COMP 359.66 4,690.17 5,877.00 1,186.83 79.8 31-5402-1029 EMPLOYEE BENEFITS - WY 2,431.09 30,964.56 33,330.00 2,365.44 92.9 TOTAL EMPLOYEE BENEFITS 9,824.74 119,183.65 125,799.00 6,615.35 94.7 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 254.63 1,769.73 1,700.00 ( 69.73) 104.1 31-5402-2122 TRAINING/DEVELOPMENT .00 765.00 2,625.00 1,860.00 29.1 31-5402-2123 MEALS/LODGING/TRAVEL .00 .00 750.00 750.00 .0 TOTAL PURCHASED SERVICES 254.63 2,534.73 5,075.00 2,540.27 50.0 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 1,375.10 15,329.83 13,500.00 ( 1,829.83) 113.6 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 5,457.84 51,194.79 38,000.00 ( 13,194.79) 134.7 31-5402-2133 UTILITY SERVICES - NATURAL GAS 50.72 1,114.29 1,500.00 385.71 74.3 31-5402-2134 TELECOMMUNICATIONS 32.31 193.51 350.00 156.49 55.3 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 6,915.97 67,832.42 53,750.00 ( 14,082.42) 126.2 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 2,375.00 2,500.00 125.00 95.0 31-5402-2155 REPAIRS/MAINTENANCE 7,800.12 18,122.66 10,000.00 ( 8,122.66) 181.2 31-5402-2156 MAINTENANCE AGREEMENT .00 .00 900.00 900.00 .0 31-5402-2158 MISC CONTRACTUAL SERVICES .00 .00 5,000.00 5,000.00 .0 TOTAL PROFESSIONAL SERVICES 7,800.12 20,497.66 18,400.00 ( 2,097.66) 111.4 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 3,933.63 38,762.89 35,000.00 ( 3,762.89) 110.8 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,728.03 4,000.00 1,271.97 68.2 31-5402-3235 FUEL 951.03 8,925.56 8,500.00 ( 425.56) 105.0 TOTAL SUPPLIES 4,884.66 50,416.48 47,500.00 ( 2,916.48) 106.1 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 258.95 350.00 91.05 74.0 TOTAL FINANCIAL .00 258.95 350.00 91.05 74.0 CAPITALIZED EXPENDITURES: 31-5402-6544 OTHER THAN BLDG .00 63,394.00 103,000.00 39,606.00 61.6 31-5402-6547 EQUIPMENT/FURNITURE 86,134.13 86,134.13 120,000.00 33,865.87 71.8 TOTAL CAPITALIZED EXPENDITURES 86,134.13 149,528.13 223,000.00 73,471.87 67.1 TOTAL WATER - DISTRIBUTION/MAINTNCE 129,973.44 594,900.09 673,702.00 78,801.91 88.3 WATER - CUSTOMER SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:51AM PAGE:36 PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 3,837.96 49,846.65 49,889.00 42.35 99.9 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 473.38 473.00 ( .38) 100.1 31-5403-1007 SALARIES/WAGES - INCENTIVE .00 790.40 998.00 207.60 79.2 TOTAL PERSONNEL SERVICES 3,837.96 51,110.43 51,360.00 249.57 99.5 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 280.90 3,757.51 3,929.00 171.49 95.6 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 22.55 270.60 266.00 ( 4.60) 101.7 31-5403-1025 EMPLOYEE BENEFITS - COMP 97.48 1,298.14 1,486.00 187.86 87.4 31-5403-1029 EMPLOYEE BENEFITS - WY 660.12 8,572.03 8,541.00 ( 31.03) 100.4 TOTAL EMPLOYEE BENEFITS 1,061.05 13,898.28 14,222.00 323.72 97.7 PURCHASED SERVICES: 31-5403-2122 TRAINING/DEVELOPMENT .00 .00 600.00 600.00 .0 TOTAL PURCHASED SERVICES .00 .00 600.00 600.00 .0 PROPERTY SERVICES: 31-5403-2134 TELECOMMUNICATIONS 16.52 200.88 200.00 ( .88) 100.4 TOTAL PROPERTY SERVICES 16.52 200.88 200.00 ( .88) 100.4 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 31-5403-2156 MAINTENANCE AGREEMENT .00 .00 17,050.00 17,050.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 18,550.00 18,550.00 .0 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES .00 1,521.93 2,000.00 478.07 76.1 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 25,183.55 31,000.00 5,816.45 81.2 31-5403-3235 FUEL 174.96 1,547.70 2,500.00 952.30 61.9 TOTAL SUPPLIES 174.96 28,253.18 35,500.00 7,246.82 79.6 TOTAL WATER - CUSTOMER SERVICES 5,090.49 93,462.77 120,432.00 26,969.23 77.6 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 36,041.52 71,882.56 210,000.00 138,117.44 34.2 TOTAL PROFESSIONAL SERVICES 36,041.52 71,882.56 210,000.00 138,117.44 34.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:51AM PAGE:37 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG 144,776.40 235,254.38 1,339,500.00 1,104,245.62 17.6 TOTAL CAPITALIZED EXPENDITURES 144,776.40 235,254.38 1,339,500.00 1,104,245.62 17.6 TOTAL WATER MAIN REPLACEMENTS 180,817.92 307,136.94 1,549,500.00 1,242,363.06 19.8 LITTLE BOX ELDER SPRING REHAB PROFESSIONAL SERVICES: 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY 93,415.17 393,531.36 300,000.00 ( 93,531.36) 131.2 TOTAL PROFESSIONAL SERVICES 93,415.17 393,531.36 300,000.00 ( 93,531.36) 131.2 CAPITALIZED EXPENDITURES: 31-5855-6544 OTHER THAN BLDG 401,268.00 4,290,486.87 5,000,000.00 709,513.13 85.8 TOTAL CAPITALIZED EXPENDITURES 401,268.00 4,290,486.87 5,000,000.00 709,513.13 85.8 TOTAL LITTLE BOX ELDER SPRING REHAB 494,683.17 4,684,018.23 5,300,000.00 615,981.77 88.4 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 10,522.50 15,500.00 15,000.00 ( 500.00) 103.3 31-5856-2158 MISC CONTRACTUAL .00 12,619.13 20,000.00 7,380.87 63.1 TOTAL PROFESSIONAL SERVICES 10,522.50 28,119.13 35,000.00 6,880.87 80.3 CAPITALIZED EXPENDITURES: 31-5856-6544 OTHER THAN BLDG 65,000.00 65,000.00 565,000.00 500,000.00 11.5 TOTAL CAPITALIZED EXPENDITURES 65,000.00 65,000.00 565,000.00 500,000.00 11.5 TOTAL WATER IMPROVEMENTS 75,522.50 93,119.13 600,000.00 506,880.87 15.5 TOTAL FUND EXPENDITURES 1,177,310.37 7,032,706.20 9,548,618.00 2,515,911.80 73.7 NET REVENUE OVER EXPENDITURES 1,928,263.16 1,053,101.09 ( 1,929,418.00) ( 2,982,519.09) 54.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:52AM PAGE:38 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 772,720.91 32-10000117 CASH WITH FISCAL AGENT 11,051.13 32-10000118 MONEY MARKET ACCOUNT 121,375.20 TOTAL CASH 905,147.24 INVESTMENTS: 32-10000120 INVESTMENT POOL 1,973,821.03 32-10000122 TIME DEPOSITS - SHORT TERM 3,297,303.68 TOTAL INVESTMENTS 5,271,124.71 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 11,423.10 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 2,500.40) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 136,187.34 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 8,340.45) 32-10000139 ACCRUED INTEREST RECEIVABLE 21,432.79 32-10000140 DUE FROM OTHER FUNDS 2,500.40 TOTAL ACCOUNTS RECEIVABLE 160,702.78 TOTAL CURRENT ASSETS 6,336,974.73 FIXED ASSETS: 32-10000181 BUILDINGS 2,388,172.45 32-10000182 ACCUMULATED - BUILDINGS ( 1,948,738.47) 32-10000183 VEHICLES 520,184.32 32-10000184 ACCUMULATED - VEHICLES ( 491,963.65) 32-10000185 MACHINERY/EQUIPMENT 572,351.47 32-10000186 ACCUMULATED - EQUIPMENT ( 467,920.14) 32-10000188 IMPROVEMENTS OTHER THAN BLDG 9,050,699.59 32-10000189 ACCUMULATED OT BLDG ( 3,043,466.57) TOTAL FIXED ASSETS 6,579,319.00 OTHER ASSETS: 32-10000190 ACCUMULATED ( 275,000.00) 32-10000195 CONSTRUCTION IN PROGRESS 98,433.68 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 92,723.69 TOTAL OTHER ASSETS ( 83,842.63) TOTAL NON-CURRENT ASSETS 6,495,476.37 TOTAL ASSETS 12,832,451.10 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:52AM PAGE:39 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 158,029.46 32-20000210 RETAINAGE PAYABLE 16,511.25 32-20000215 WAGES PAYABLE 9,597.01 TOTAL ACCOUNTS PAYABLE 184,137.72 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 305,103.65 TOTAL OTHER PAYABLES 305,103.65 TOTAL CURRENT LIABILITIES 489,241.37 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 35,460.97 TOTAL NON-CURRENT LIABILITIES 35,460.97 TOTAL LIABILITIES 524,702.34 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS 1,774,383.38 32-30000305 RESERVE FOR REPLACEMENT 3,800,882.31 32-30000306 RESERVE FOR OPERATING 195,913.00 32-30000307 RESERVE FOR SLUDGE REMOVAL 210,000.00 TOTAL CAPITAL ASSETS 5,981,178.69 OTHER NET ASSETS: 32-30000320 CAPITAL ASSETS NET OF DEBT 6,677,752.68 TOTAL OTHER NET ASSETS 6,677,752.68 REVENUE OVER EXPENDITURES - YTD ( 351,182.61) BALANCE - CURRENT DATE 12,307,748.76 TOTAL NET ASSETS 12,307,748.76 TOTAL LIABILITIES AND NET ASSETS 12,832,451.10 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:52AM PAGE:40 SEWER - REVENUE MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 1,319.81 2,000.00 680.19 66.0 32-4320-1140 INTEREST INCOME 6,331.21 71,759.42 100,000.00 28,240.58 71.8 TOTAL MISC LOCAL REVENUE 6,331.21 73,079.23 102,000.00 28,920.77 71.7 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 108,349.29 1,276,351.15 1,200,000.00 ( 76,351.15) 106.4 32-4320-1706 SEWER PLANT INVESTMENT FEES 2,000.00 24,000.00 1,000.00 ( 23,000.00) 2400.0 TOTAL UTILITIES REVENUE 110,349.29 1,300,351.15 1,201,000.00 ( 99,351.15) 108.3 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 8,550.00 357,202.50 250,000.00 ( 107,202.50) 142.9 TOTAL SEPTIC WASTE DISPOSAL 8,550.00 357,202.50 250,000.00 ( 107,202.50) 142.9 TOTAL SEWER - REVENUE 125,230.50 1,730,632.88 1,553,000.00 ( 177,632.88) 111.4 WASTEWATER REHAB-REVENU STATE REVENUE: 32-4850-3374 SLIB 4,804.80 17,382.77 500,000.00 482,617.23 3.5 TOTAL STATE REVENUE 4,804.80 17,382.77 500,000.00 482,617.23 3.5 TOTAL WASTEWATER REHAB-REVENU 4,804.80 17,382.77 500,000.00 482,617.23 3.5 TOTAL FUND REVENUE 130,035.30 1,748,015.65 2,053,000.00 304,984.35 85.1 SEWER - ADMINISTRATION DEPRECIATION: 32-5500-1150 DEPRECIATION 68,750.00 275,000.00 275,000.00 .00 100.0 TOTAL DEPRECIATION 68,750.00 275,000.00 275,000.00 .00 100.0 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 292.37 3,505.02 4,000.00 494.98 87.6 32-5500-2166 COLLECTION FEES .00 35.87 .00 ( 35.87) .0 TOTAL PROFESSIONAL SERVICES 292.37 3,540.89 4,000.00 459.11 88.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:52AM PAGE:41 OPERATING TRANSFERS: 32-5500-4347 MANAGEMENT FEES 39,293.50 157,174.00 157,174.00 .00 100.0 TOTAL OPERATING TRANSFERS 39,293.50 157,174.00 157,174.00 .00 100.0 TOTAL SEWER - ADMINISTRATION 108,335.87 435,714.89 436,174.00 459.11 99.9 SEWER - TREATMENT CASH FUND APPROPRIATION: 32-5501-0150 SLUDGE REMOVAL RESERVE 15,000.00 15,000.00 15,000.00 .00 100.0 TOTAL CASH FUND APPROP 15,000.00 15,000.00 15,000.00 .00 100.0 PERSONNEL SERVICES: 32-5501-1001 SALARIES/WAGES - REGULAR 6,794.08 87,187.73 87,264.00 76.27 99.9 32-5501-1002 SALARIES/WAGES - OVERTIME .00 .00 5,000.00 5,000.00 .0 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 284.33 285.00 .67 99.8 32-5501-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 32-5501-1007 SALARIES/WAGES - INCENTIVE .00 .00 813.00 813.00 .0 TOTAL PERSONNEL SERVICES 6,819.08 87,772.06 93,662.00 5,889.94 93.7 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 528.74 6,806.42 7,257.00 450.58 93.8 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 3,089.47 37,069.09 37,005.00 ( 64.09) 100.2 32-5501-1025 EMPLOYEE BENEFITS - COMP 173.22 2,229.52 2,751.00 521.48 81.0 32-5501-1026 EMPLOYEE BENEFITS - COMP 62.54 812.26 813.00 .74 99.9 32-5501-1029 EMPLOYEE BENEFITS - WY 1,168.56 14,993.48 15,796.00 802.52 94.9 TOTAL EMPLOYEE BENEFITS 5,022.53 61,910.77 63,622.00 1,711.23 97.3 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 417.50 2,570.00 2,152.50 16.3 32-5501-2123 MEALS/LODGING/TRAVEL .00 .00 800.00 800.00 .0 TOTAL PURCHASED SERVICES .00 417.50 3,370.00 2,952.50 12.4 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 6,940.15 92,621.37 95,000.00 2,378.63 97.5 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 9,797.08 60,483.86 70,000.00 9,516.14 86.4 32-5501-2134 TELECOMMUNICATIONS 261.24 1,625.18 400.00 ( 1,225.18) 406.3 TOTAL PROPERTY SERVICES 16,998.47 154,730.41 165,400.00 10,669.59 93.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:52AM PAGE:42 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 2,500.00 2,500.00 .0 32-5501-2155 REPAIRS/MAINTENANCE 2,869.85 23,316.30 32,000.00 8,683.70 72.9 32-5501-2158 MISC CONTRACTUAL SERVICES 587.00 8,232.00 15,000.00 6,768.00 54.9 TOTAL PROFESSIONAL SERVICES 3,456.85 31,548.30 49,500.00 17,951.70 63.7 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 4,210.65 32,549.40 25,000.00 ( 7,549.40) 130.2 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 9,754.13 25,900.00 16,145.87 37.7 32-5501-3235 FUEL 193.84 1,529.88 2,000.00 470.12 76.5 TOTAL SUPPLIES 4,404.49 43,833.41 52,900.00 9,066.59 82.9 CAPITALIZED EXPENDITURES: 32-5501-6544 OTHER THAN BLDG .00 15,287.48 25,000.00 9,712.52 61.2 TOTAL CAPITALIZED EXPENDITURES .00 15,287.48 25,000.00 9,712.52 61.2 TOTAL SEWER - TREATMENT 51,701.42 410,499.93 468,454.00 57,954.07 87.6 SEWER - COLLECTION PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 13,353.06 168,911.70 165,527.00 ( 3,384.70) 102.0 32-5502-1002 SALARIES/WAGES - OVERTIME 555.54 7,241.21 4,500.00 ( 2,741.21) 160.9 32-5502-1004 SALARIES/WAGES - TEMPORARY .00 2,272.40 2,982.00 709.60 76.2 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 621.83 622.00 .17 100.0 32-5502-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 13,933.60 179,347.14 173,931.00 ( 5,416.14) 103.1 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 1,059.85 13,649.24 13,336.00 ( 313.24) 102.4 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 7,201.53 86,392.16 86,182.00 ( 210.16) 100.2 32-5502-1025 EMPLOYEE BENEFITS - COMP 353.91 4,555.44 5,142.00 586.56 88.6 32-5502-1029 EMPLOYEE BENEFITS - WY 2,392.27 30,293.26 29,109.00 ( 1,184.26) 104.1 TOTAL EMPLOYEE BENEFITS 11,007.56 134,890.10 133,769.00 ( 1,121.10) 100.8 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 254.62 1,769.77 1,700.00 ( 69.77) 104.1 32-5502-2122 TRAINING/DEVELOPMENT .00 1,405.00 2,625.00 1,220.00 53.5 32-5502-2123 MEALS/LODGING/TRAVEL .00 .00 750.00 750.00 .0 TOTAL PURCHASED SERVICES 254.62 3,174.77 5,075.00 1,900.23 62.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:53AM PAGE:43 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 796.38 11,397.98 15,000.00 3,602.02 76.0 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 45.42 279.74 350.00 70.26 79.9 32-5502-2133 UTILITY SERVICES - NATURAL GAS 225.55 2,104.93 1,800.00 ( 304.93) 116.9 32-5502-2134 TELECOMMUNICATIONS 158.42 950.22 715.00 ( 235.22) 132.9 TOTAL PROPERTY SERVICES 1,225.77 14,732.87 17,865.00 3,132.13 82.5 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,265.00 2,500.00 1,235.00 50.6 32-5502-2155 REPAIRS/MAINTENANCE .00 4,976.10 10,000.00 5,023.90 49.8 32-5502-2158 MISC CONTRACTUAL SERVICES .00 .00 5,000.00 5,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 6,241.10 17,500.00 11,258.90 35.7 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 4,326.32 29,321.42 30,000.00 678.58 97.7 32-5502-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 3,500.00 3,500.00 .0 32-5502-3235 FUEL 950.91 8,180.47 8,500.00 319.53 96.2 TOTAL SUPPLIES 5,277.23 37,501.89 42,000.00 4,498.11 89.3 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 235.41 250.00 14.59 94.2 TOTAL FINANCIAL .00 235.41 250.00 14.59 94.2 CAPITALIZED EXPENDITURES: 32-5502-6544 OTHER THAN BLDG .00 21,237.45 21,250.00 12.55 99.9 32-5502-6547 EQUIPMENT/FURNITURE 86,134.13 286,780.82 220,000.00 ( 66,780.82) 130.4 TOTAL CAPITALIZED EXPENDITURES 86,134.13 308,018.27 241,250.00 ( 66,768.27) 127.7 TOTAL SEWER - COLLECTION 117,832.91 684,141.55 631,640.00 ( 52,501.55) 108.3 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 4,970.00 36,214.11 145,000.00 108,785.89 25.0 TOTAL PROFESSIONAL SERVICES 4,970.00 36,214.11 145,000.00 108,785.89 25.0 CAPITALIZED EXPENDITURES: 32-5850-6544 OTHER THAN BLDG .00 .00 1,200,000.00 1,200,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 1,200,000.00 1,200,000.00 .0 TOTAL WASTEWATER PLANT REHAB 4,970.00 36,214.11 1,345,000.00 1,308,785.89 2.7 SEWER MAIN REPLACEMENTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:53AM PAGE:44 PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 7,437.74 93,829.07 354,000.00 260,170.93 26.5 TOTAL PROFESSIONAL SERVICES 7,437.74 93,829.07 354,000.00 260,170.93 26.5 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG 30,610.45 438,798.71 1,705,000.00 1,266,201.29 25.7 TOTAL CAPITALIZED EXPENDITURES 30,610.45 438,798.71 1,705,000.00 1,266,201.29 25.7 TOTAL SEWER MAIN REPLACEMENTS 38,048.19 532,627.78 2,059,000.00 1,526,372.22 25.9 TOTAL FUND EXPENDITURES 320,888.39 2,099,198.26 4,940,268.00 2,841,069.74 42.5 NET REVENUE OVER EXPENDITURES ( 190,853.09) ( 351,182.61) ( 2,887,268.00) ( 2,536,085.39) ( 12.2) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:53AM PAGE:45 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 413,252.95 TOTAL CASH 413,252.95 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 410,495.69 TOTAL INVESTMENTS 410,495.69 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 66.33 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 617.78) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 49,292.59 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 1,143.92) 33-10000139 ACCRUED INTEREST RECEIVABLE 1,171.85 33-10000156 DUE FROM OTHER FUNDS 617.78 TOTAL ACCOUNTS RECEIVABLE 49,386.85 TOTAL CURRENT ASSETS 873,135.49 FIXED ASSETS: 33-10000183 VEHICLES 630,486.00 33-10000184 ACCUMULATED - VEHICLES ( 301,900.71) 33-10000185 EQUIPMENT 33,437.00 33-10000186 ACCUMULATED - EQUIPMENT ( 33,437.00) TOTAL FIXED ASSETS 328,585.29 OTHER ASSETS: 33-10000190 ACCUMULATED ( 35,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 51,667.14 TOTAL OTHER ASSETS 16,667.14 TOTAL NON-CURRENT ASSETS 345,252.43 TOTAL ASSETS 1,218,387.92 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:53AM PAGE:46 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 5,143.79 33-20000215 WAGES PAYABLE 5,409.47 TOTAL ACCOUNTS PAYABLE 10,553.26 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 165,330.12 TOTAL OTHER PAYABLES 165,330.12 TOTAL CURRENT LIABILITIES 175,883.38 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 36,603.28 TOTAL NON-CURRENT LIABILITIES 36,603.28 TOTAL LIABILITIES 212,486.66 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 44,019.74) 33-30000305 RESERVE FOR REPLACEMENT 696,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 728,724.80 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 328,585.29 TOTAL OTHER NET ASSETS 328,585.29 REVENUE OVER EXPENDITURES - YTD ( 51,408.83) BALANCE - CURRENT DATE 1,005,901.26 TOTAL NET ASSETS 1,005,901.26 TOTAL LIABILITIES AND NET ASSETS 1,218,387.92 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:53AM PAGE:47 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1140 INTEREST INCOME 180.39 11,927.31 12,500.00 572.69 95.4 33-4330-1145 GAIN ON SALE OF FIXED ASSETS .00 17,500.00 20,000.00 2,500.00 87.5 TOTAL MISC LOCAL REVENUE 180.39 29,427.31 32,500.00 3,072.69 90.6 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 41,751.05 500,062.28 475,000.00 ( 25,062.28) 105.3 33-4330-1709 SANITATION ACTIVATION FEE 250.00 2,100.00 250.00 ( 1,850.00) 840.0 TOTAL UTILITIES REVENUE 42,001.05 502,162.28 475,250.00 ( 26,912.28) 105.7 TOTAL SANITATION - REVENUE 42,181.44 531,589.59 507,750.00 ( 23,839.59) 104.7 TOTAL FUND REVENUE 42,181.44 531,589.59 507,750.00 ( 23,839.59) 104.7 SANITATION CASH FUND APPROPRIATION: 33-5600-0150 REPLACEMENT RESERVE 30,000.00 30,000.00 30,000.00 .00 100.0 TOTAL CASH FUND APPROP 30,000.00 30,000.00 30,000.00 .00 100.0 PERSONNEL SERVICES: 33-5600-1001 SALARIES/WAGES - REGULAR 11,038.15 143,361.47 143,510.00 148.53 99.9 33-5600-1002 SALARIES/WAGES - OVERTIME .00 .00 600.00 600.00 .0 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 1,247.60 1,248.00 .40 100.0 33-5600-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 33-5600-1007 SALARIES/WAGES - INCENTIVE .00 1,535.20 3,677.00 2,141.80 41.8 TOTAL PERSONNEL SERVICES 11,063.15 146,444.27 149,335.00 2,890.73 98.1 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 859.36 11,372.20 11,593.00 220.80 98.1 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 5,149.61 61,795.35 61,667.00 ( 128.35) 100.2 33-5600-1025 EMPLOYEE BENEFITS - COMP 281.01 3,719.77 4,355.00 635.23 85.4 33-5600-1026 EMPLOYEE BENEFITS - COMP 140.16 1,820.38 1,822.00 1.62 99.9 33-5600-1029 EMPLOYEE BENEFITS - WY 1,898.57 24,654.06 24,672.00 17.94 99.9 TOTAL EMPLOYEE BENEFITS 8,328.71 103,361.76 104,109.00 747.24 99.3 DEPRECIATION: 33-5600-1150 DEPRECIATION 8,750.00 35,000.00 35,000.00 .00 100.0 TOTAL DEPRECIATION 8,750.00 35,000.00 35,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:58AM PAGE:48 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE .00 1,899.92 1,000.00 ( 899.92) 190.0 33-5600-2158 MISC CONTRACTUAL SERVICES 198.06 2,374.39 3,000.00 625.61 79.2 33-5600-2175 REFUNDS/REIMBURSEMENTS .00 .00 125.00 125.00 .0 TOTAL PROFESSIONAL SERVICES 198.06 4,274.31 4,125.00 ( 149.31) 103.6 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 2,721.75 19,344.62 27,000.00 7,655.38 71.7 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 25,801.97 25,600.00 ( 201.97) 100.8 33-5600-3235 FUEL 2,223.98 18,016.49 22,000.00 3,983.51 81.9 TOTAL SUPPLIES 4,945.73 63,163.08 74,600.00 11,436.92 84.7 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 12,847.00 51,388.00 51,388.00 .00 100.0 TOTAL OPERATING TRANSFERS 12,847.00 51,388.00 51,388.00 .00 100.0 CAPITALIZED EXPENDITURES: 33-5600-6548 VEHICLES .00 149,367.00 205,000.00 55,633.00 72.9 TOTAL CAPITALIZED EXPENDITURES .00 149,367.00 205,000.00 55,633.00 72.9 TOTAL SANITATION 76,132.65 582,998.42 653,557.00 70,558.58 89.2 TOTAL FUND EXPENDITURES 76,132.65 582,998.42 653,557.00 70,558.58 89.2 NET REVENUE OVER EXPENDITURES ( 33,951.21) ( 51,408.83) ( 145,807.00) ( 94,398.17) ( 35.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:58AM PAGE:49 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 552,935.59 TOTAL CASH 552,935.59 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,635,505.08 TOTAL INVESTMENTS 1,635,505.08 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 23,095.50 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 1,000.48) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY 73,674.14 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 1,607.34) 34-10000139 ACCRUED INTEREST RECEIVABLE 2,557.58 34-10000140 DUE FROM OTHER FUNDS ( 4,219.06) 34-10000156 DUE FROM OTHER FUNDS 5,219.54 TOTAL ACCOUNTS RECEIVABLE 97,719.88 TOTAL CURRENT ASSETS 2,286,160.55 FIXED ASSETS: 34-10000180 LAND 153,289.58 34-10000181 BUILDINGS 1,689,609.46 34-10000182 ACCUMULATED - BUILDINGS ( 370,266.96) 34-10000183 VEHICLES 49,148.52 34-10000184 ACCUMULATED - VEHICLE ( 33,920.52) 34-10000185 EQUIPMENT 1,140,332.94 34-10000186 ACCUMULATED - EQUIPMENT ( 874,020.84) 34-10000188 IMPROVEMENTS OTHER THAN BLDG 417,030.94 34-10000189 ACCUMULATED OT BLDG ( 44,180.24) TOTAL FIXED ASSETS 2,127,022.88 OTHER ASSETS: 34-10000190 ACCUMULATED ( 90,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 59,451.45 TOTAL OTHER ASSETS ( 30,548.55) TOTAL NON-CURRENT ASSETS 2,096,474.33 TOTAL ASSETS 4,382,634.88 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:58AM PAGE:50 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 59,141.60 34-20000204 ACCOUNTS PAYABLE- EOY 35,885.09 34-20000205 INTEREST PAYABLE 195.26 34-20000215 WAGES PAYABLE 7,471.39 TOTAL ACCOUNTS PAYABLE 102,693.34 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 212,812.39 TOTAL OTHER PAYABLES 212,812.39 TOTAL CURRENT LIABILITIES 315,505.73 NON-CURRENT LIABILITIES: 34-20000260 SLIB NOTES PAYABLE 117,276.83 34-20000265 COMPENSATED ABSENCES PAYABLE 31,636.14 34-20000290 LANDFILL LIABILITY 374,207.91 TOTAL NON-CURRENT LIABILITIES 523,120.88 TOTAL LIABILITIES 838,626.61 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS 544,254.44 34-30000305 RESERVE FOR REPLACEMENT 1,086,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,763,425.21 OTHER NET ASSETS: 34-30000320 CAPITAL ASSETS NET OF DEBT 1,635,537.94 TOTAL OTHER NET ASSETS 1,635,537.94 REVENUE OVER EXPENDITURES - YTD 145,045.12 BALANCE - CURRENT DATE 3,544,008.27 TOTAL NET ASSETS 3,544,008.27 TOTAL LIABILITIES AND NET ASSETS 4,382,634.88 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:59AM PAGE:51 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER .00 .00 1,000.00 1,000.00 .0 34-4340-1140 INTEREST INCOME 175.31 30,616.33 29,000.00 ( 1,616.33) 105.6 TOTAL MISC LOCAL REVENUE 175.31 30,616.33 30,000.00 ( 616.33) 102.1 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 118,852.26 1,220,574.59 1,000,000.00 ( 220,574.59) 122.1 TOTAL UTILITIES REVENUE 118,852.26 1,220,574.59 1,000,000.00 ( 220,574.59) 122.1 TOTAL LANDFILL - REVENUE 119,027.57 1,251,190.92 1,030,000.00 ( 221,190.92) 121.5 TOTAL FUND REVENUE 119,027.57 1,251,190.92 1,030,000.00 ( 221,190.92) 121.5 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,731.89 194,794.42 191,460.00 ( 3,334.42) 101.7 34-5340-1002 SALARIES/WAGES - OVERTIME .00 209.36 1,500.00 1,290.64 14.0 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,305.31 1,305.00 ( .31) 100.0 34-5340-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 34-5340-1007 SALARIES/WAGES - INCENTIVE .00 582.48 558.00 ( 24.48) 104.4 TOTAL PERSONNEL SERVICES 15,781.89 197,491.57 195,423.00 ( 2,068.57) 101.1 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,267.41 15,806.67 15,631.00 ( 175.67) 101.1 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 6,171.74 74,047.48 73,879.00 ( 168.48) 100.2 34-5340-1025 EMPLOYEE BENEFITS - COMP 400.87 5,023.81 5,788.00 764.19 86.8 34-5340-1026 EMPLOYEE BENEFITS - COMP 757.75 8,739.00 8,121.00 ( 618.00) 107.6 34-5340-1029 EMPLOYEE BENEFITS - WY 1,948.12 24,759.60 24,914.00 154.40 99.4 TOTAL EMPLOYEE BENEFITS 10,545.89 128,376.56 128,333.00 ( 43.56) 100.0 DEPRECIATION: 34-5340-1150 DEPRECIATION 22,500.00 90,000.00 90,000.00 .00 100.0 TOTAL DEPRECIATION 22,500.00 90,000.00 90,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:59AM PAGE:52 PURCHASED SERVICES: 34-5340-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 250.00 300.00 50.00 83.3 34-5340-2122 TRAINING/DEVELOPMENT .00 560.00 600.00 40.00 93.3 34-5340-2123 MEALS/LODGING/TRAVEL .00 419.98 750.00 330.02 56.0 TOTAL PURCHASED SERVICES .00 1,229.98 1,650.00 420.02 74.5 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 584.80 8,449.22 9,000.00 550.78 93.9 34-5340-2133 UTILITY SERVICES - NATURAL GAS 407.98 9,025.02 15,000.00 5,974.98 60.2 34-5340-2134 TELECOMMUNICATIONS 18.51 224.01 250.00 25.99 89.6 34-5340-2141 EQUIPMENT - RENT .00 96.00 200.00 104.00 48.0 TOTAL PROPERTY SERVICES 1,011.29 17,794.25 24,450.00 6,655.75 72.8 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 34-5340-2155 REPAIRS/MAINTENANCE 1,863.33 11,888.08 20,000.00 8,111.92 59.4 34-5340-2156 MAINTENANCE AGREEMENT .00 4,022.37 9,000.00 4,977.63 44.7 34-5340-2157 INSURANCE .00 .00 1,500.00 1,500.00 .0 34-5340-2158 MISC CONTRACTUAL SERVICES 47,616.21 385,692.44 409,300.00 23,607.56 94.2 34-5340-2166 COLLECTION FEES 410.02 420.52 300.00 ( 120.52) 140.2 TOTAL PROFESSIONAL SERVICES 49,889.56 402,023.41 441,100.00 39,076.59 91.1 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 3,380.01 35,628.28 40,000.00 4,371.72 89.1 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 124.39 10,000.00 9,875.61 1.2 34-5340-3235 FUEL 1,637.66 13,996.54 30,000.00 16,003.46 46.7 TOTAL SUPPLIES 5,017.67 49,749.21 80,000.00 30,250.79 62.2 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 26,060.75 104,243.00 104,243.00 .00 100.0 TOTAL OPERATING TRANSFERS 26,060.75 104,243.00 104,243.00 .00 100.0 TOTAL LANDFILL 130,807.05 1,004,049.00 1,145,199.00 141,150.00 87.7 LANDFILL - CAPITAL PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY .00 30,883.48 50,000.00 19,116.52 61.8 TOTAL PROFESSIONAL SERVICES .00 30,883.48 50,000.00 19,116.52 61.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:59AM PAGE:53 CAPITALIZED EXPENDITURES: 34-5895-6542 BUILDINGS/IMPROVEMENTS 3,223.08 20,156.08 30,000.00 9,843.92 67.2 34-5895-6547 EQUIPMENT/FURNITURE .00 .00 7,000.00 7,000.00 .0 34-5895-6548 VEHICLES .00 51,057.24 70,000.00 18,942.76 72.9 TOTAL CAPITALIZED EXPENDITURES 3,223.08 71,213.32 107,000.00 35,786.68 66.6 TOTAL LANDFILL - CAPITAL 3,223.08 102,096.80 157,000.00 54,903.20 65.0 TOTAL FUND EXPENDITURES 134,030.13 1,106,145.80 1,302,199.00 196,053.20 84.9 NET REVENUE OVER EXPENDITURES ( 15,002.56) 145,045.12 ( 272,199.00) ( 417,244.12) 53.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:59AM PAGE:54 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 501,971.31 TOTAL CASH 501,971.31 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 411,947.47 TOTAL INVESTMENTS 411,947.47 ACCOUNTS RECEIVABLE: 39-10000131 ACCOUNTS RECEIVABLE - GENERAL 1,560.60 39-10000132 ACCOUNTS REC - EOY 87,015.83 39-10000139 ACCRUED INTEREST RECEIVABLE 516.27 TOTAL ACCOUNTS RECEIVABLE 89,092.70 TOTAL CURRENT ASSETS 1,003,011.48 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,003,011.48 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 39-20000210 IBNR LIABILITY 246,000.00 TOTAL ACCOUNTS PAYABLE 246,000.00 TOTAL CURRENT LIABILITIES 246,000.00 TOTAL LIABILITIES 246,000.00 NET ASSETS CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 244,477.99) 39-30000301 FUND BALANCE RESERVE 900,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 762,522.01 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:59AM PAGE:55 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 5,510.53) BALANCE - CURRENT DATE 757,011.48 TOTAL NET ASSETS 757,011.48 TOTAL LIABILITIES AND NET ASSETS 1,003,011.48 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 08:59AM PAGE:56 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 9,251.40 350,701.08 25,000.00 ( 325,701.08) 1402.8 39-4390-0111 INSURANCE PREMIUMS 33,352.62 400,390.09 500,000.00 99,609.91 80.1 39-4390-0112 INSURANCE ASSESSMENTS 74,278.32 893,771.14 985,000.00 91,228.86 90.7 39-4390-0113 COBRA PAYMENTS .00 7,183.35 .00 ( 7,183.35) .0 TOTAL REVENUE 116,882.34 1,652,045.66 1,510,000.00 ( 142,045.66) 109.4 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 221.51 8,372.95 5,500.00 ( 2,872.95) 152.2 TOTAL MISC LOCAL REVENUE 221.51 8,372.95 5,500.00 ( 2,872.95) 152.2 TRANSFERS IN: 39-4390-5510 TRANSFER FROM GENERAL FUND .00 .00 100,000.00 100,000.00 .0 TOTAL TRANSFERS IN .00 .00 100,000.00 100,000.00 .0 TOTAL EMPLOYEE HEALTH CARE - REVENUE 117,103.85 1,660,418.61 1,615,500.00 ( 44,918.61) 102.8 TOTAL FUND REVENUE 117,103.85 1,660,418.61 1,615,500.00 ( 44,918.61) 102.8 EMPLOYEE HEALTH CARE CASH FUND APPROPRIATION: 39-5390-0150 REPLACEMENT RESERVE 100,000.00 100,000.00 100,000.00 .00 100.0 TOTAL CASH FUND APPROP 100,000.00 100,000.00 100,000.00 .00 100.0 EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM 25,640.77 279,114.05 300,000.00 20,885.95 93.0 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 65,156.93 1,174,682.61 900,000.00 ( 274,682.61) 130.5 39-5390-1058 HEALTH CARE - FEE 7,080.10 112,132.48 200,000.00 87,867.52 56.1 TOTAL EMPLOYEE BENEFITS 97,877.80 1,565,929.14 1,400,000.00 ( 165,929.14) 111.9 TOTAL EMPLOYEE HEALTH CARE 197,877.80 1,665,929.14 1,500,000.00 ( 165,929.14) 111.1 TOTAL FUND EXPENDITURES 197,877.80 1,665,929.14 1,500,000.00 ( 165,929.14) 111.1 NET REVENUE OVER EXPENDITURES ( 80,773.95) ( 5,510.53) 115,500.00 121,010.53 ( 4.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:05AM PAGE:57 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 29,935.10 TOTAL CASH 29,935.10 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 317,765.85 TOTAL INVESTMENTS 317,765.85 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 432.92 TOTAL ACCOUNTS RECEIVABLE 432.92 TOTAL CURRENT ASSETS 348,133.87 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 348,133.87 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 341,497.10 TOTAL CAPITAL ASSETS 341,497.10 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 6,636.77 BALANCE - CURRENT DATE 348,133.87 TOTAL NET ASSETS 348,133.87 TOTAL LIABILITIES AND NET ASSETS 348,133.87 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:05AM PAGE:58 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 9.74 6,636.77 4,500.00 ( 2,136.77) 147.5 TOTAL MISC LOCAL REVENUE 9.74 6,636.77 4,500.00 ( 2,136.77) 147.5 TOTAL CAPITAL IMP RESERVE - REVENUE 9.74 6,636.77 4,500.00 ( 2,136.77) 147.5 TOTAL FUND REVENUE 9.74 6,636.77 4,500.00 ( 2,136.77) 147.5 NET REVENUE OVER EXPENDITURES 9.74 6,636.77 4,500.00 ( 2,136.77) 147.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:10AM PAGE:59 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 187,156.49 TOTAL CASH 187,156.49 INVESTMENTS: 41-10000122 TIME DEPOSITS-SHORT TERM 177,507.91 TOTAL INVESTMENTS 177,507.91 TOTAL CURRENT ASSETS 364,664.40 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 364,664.40 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 41-20000201 ACCOUNTS PAY ALLOC TO FUNDS 2,932.79 TOTAL ACCOUNTS PAYABLE 2,932.79 TOTAL CURRENT LIABILITIES 2,932.79 TOTAL LIABILITIES 2,932.79 NET ASSETS CAPITAL ASSETS: 41-30000300 FUND BALANCE/BEGINNING OF YEAR 186,409.13 TOTAL CAPITAL ASSETS 186,409.13 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 175,322.48 BALANCE - CURRENT DATE 361,731.61 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:10AM PAGE:60 TOTAL NET ASSETS 361,731.61 TOTAL LIABILITIES AND NET ASSETS 364,664.40 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:10AM PAGE:61 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 892.70 3,255.27 500.00 ( 2,755.27) 651.1 TOTAL MISC LOCAL REVENUE 892.70 3,255.27 500.00 ( 2,755.27) 651.1 TRANSFERS IN: 41-4410-5510 TRANSFER FROM GENERAL FUND 43,750.00 175,000.00 175,000.00 .00 100.0 TOTAL TRANSFERS IN 43,750.00 175,000.00 175,000.00 .00 100.0 TOTAL ECONOMIC DEVELOPMENT 44,642.70 178,255.27 175,500.00 ( 2,755.27) 101.6 TOTAL FUND REVENUE 44,642.70 178,255.27 175,500.00 ( 2,755.27) 101.6 ECONOMIC DEVELOPMENT PROFESSIONAL SERVICES: 41-5410-2158 MISC CONTRACTUAL SERVICES 2,932.79 2,932.79 175,000.00 172,067.21 1.7 TOTAL PROFESSIONAL SERVICES 2,932.79 2,932.79 175,000.00 172,067.21 1.7 TOTAL ECONOMIC DEVELOPMENT 2,932.79 2,932.79 175,000.00 172,067.21 1.7 TOTAL FUND EXPENDITURES 2,932.79 2,932.79 175,000.00 172,067.21 1.7 NET REVENUE OVER EXPENDITURES 41,709.91 175,322.48 500.00 ( 174,822.48) 35064.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 BROWNFIELD GRANT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:11AM PAGE:62 ASSETS CURRENT ASSETS: CASH: 42-10000116 CASH ALLOC FR COMBINED FUND ( 1.80) TOTAL CASH ( 1.80) ACCOUNTS RECEIVABLE: 42-10000131 ACCOUNTS RECEIVABLE - GENERAL 10,061.51 TOTAL ACCOUNTS RECEIVABLE 10,061.51 TOTAL CURRENT ASSETS 10,059.71 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 10,059.71 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 42-20000201 ACCOUNTS PAY ALLOC TO FUNDS 10,061.51 TOTAL ACCOUNTS PAYABLE 10,061.51 TOTAL CURRENT LIABILITIES 10,061.51 TOTAL LIABILITIES 10,061.51 NET ASSETS CAPITAL ASSETS: 42-30000300 FUND BALANCE/BEGINNING OF YEAR ( 1.80) TOTAL CAPITAL ASSETS ( 1.80) TOTAL NET ASSETS ( 1.80) TOTAL LIABILITIES AND NET ASSETS 10,059.71 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:11AM PAGE:63 BROWNFIELD HAZARDOUS - REVENUE FEDERAL REVENUE SOURCES: 42-4870-4281 EPA 13,687.38 43,684.26 265,100.00 221,415.74 16.5 TOTAL FEDERAL REVENUE SOURCES 13,687.38 43,684.26 265,100.00 221,415.74 16.5 TOTAL BROWNFIELD HAZARDOUS - REVENUE 13,687.38 43,684.26 265,100.00 221,415.74 16.5 BROWNFIELD PETROLEUM - REVENUE FEDERAL REVENUE SOURCES: 42-4871-4281 EPA 3,562.64 12,462.91 25,000.00 12,537.09 49.9 TOTAL FEDERAL REVENUE SOURCES 3,562.64 12,462.91 25,000.00 12,537.09 49.9 TOTAL BROWNFIELD PETROLEUM - REVENUE 3,562.64 12,462.91 25,000.00 12,537.09 49.9 TOTAL FUND REVENUE 17,250.02 56,147.17 290,100.00 233,952.83 19.4 BROWNFIELD HAZARDOUS PROFESSIONAL SERVICES: 42-5870-2158 MISC CONTRACTUAL SERVICES 7,597.60 43,684.26 265,100.00 221,415.74 16.5 TOTAL PROFESSIONAL SERVICES 7,597.60 43,684.26 265,100.00 221,415.74 16.5 TOTAL BROWNFIELD HAZARDOUS 7,597.60 43,684.26 265,100.00 221,415.74 16.5 BROWNFIELD PETROLEUM PROFESSIONAL SERVICES: 42-5871-2158 MISC CONTRACTUAL SERVICES 2,463.91 12,462.91 25,000.00 12,537.09 49.9 TOTAL PROFESSIONAL SERVICES 2,463.91 12,462.91 25,000.00 12,537.09 49.9 TOTAL BROWNFIELD PETROLEUM 2,463.91 12,462.91 25,000.00 12,537.09 49.9 TOTAL FUND EXPENDITURES 10,061.51 56,147.17 290,100.00 233,952.83 19.4 NET REVENUE OVER EXPENDITURES 7,188.51 .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:15AM PAGE:64 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND 65,650.62 TOTAL CASH 65,650.62 INVESTMENTS: 47-10000122 TIME DEPOSITS - SHORT TERM 102,986.87 TOTAL INVESTMENTS 102,986.87 ACCOUNTS RECEIVABLE: 47-10000139 ACCRUED INTEREST RECEIVABLE 129.07 TOTAL ACCOUNTS RECEIVABLE 129.07 TOTAL CURRENT ASSETS 168,766.56 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 168,766.56 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 47-20000201 ALLOCATION FROM AP FUND 42,256.70 TOTAL ACCOUNTS PAYABLE 42,256.70 TOTAL CURRENT LIABILITIES 42,256.70 TOTAL LIABILITIES 42,256.70 NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR ( 233,595.61) 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS ( 12,354.74) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:15AM PAGE:65 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 138,864.60 BALANCE - CURRENT DATE 126,509.86 TOTAL NET ASSETS 126,509.86 TOTAL LIABILITIES AND NET ASSETS 168,766.56 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:15AM PAGE:66 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME .00 1,587.00 5,500.00 3,913.00 28.9 TOTAL MISC LOCAL REVENUE .00 1,587.00 5,500.00 3,913.00 28.9 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND 237,500.00 950,000.00 950,000.00 .00 100.0 TOTAL TRANSFERS IN 237,500.00 950,000.00 950,000.00 .00 100.0 TOTAL GENERAL FUND EQUIP RES-REVENUE 237,500.00 951,587.00 955,500.00 3,913.00 99.6 TOTAL FUND REVENUE 237,500.00 951,587.00 955,500.00 3,913.00 99.6 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE 27,338.00 746,813.70 679,972.00 ( 66,841.70) 109.8 47-5470-6548 VEHICLES 14,918.70 65,908.70 272,130.00 206,221.30 24.2 TOTAL CAPITALIZED EXPENDITURES 42,256.70 812,722.40 952,102.00 139,379.60 85.4 TOTAL GENERAL FUND EQUIPMENT RESERVE 42,256.70 812,722.40 952,102.00 139,379.60 85.4 TOTAL FUND EXPENDITURES 42,256.70 812,722.40 952,102.00 139,379.60 85.4 NET REVENUE OVER EXPENDITURES 195,243.30 138,864.60 3,398.00 ( 135,466.60) 4086.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:16AM PAGE:67 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 481,804.28 TOTAL CASH 481,804.28 TOTAL CURRENT ASSETS 481,804.28 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 481,804.28 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR ( 139,656.66) 50-30000301 RESERVED FUND BALANCE 255,959.63 TOTAL CAPITAL ASSETS 116,302.97 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 365,501.31 BALANCE - CURRENT DATE 481,804.28 TOTAL NET ASSETS 481,804.28 TOTAL LIABILITIES AND NET ASSETS 481,804.28 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:16AM PAGE:68 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1140 INTEREST INCOME 107.95 882.72 250.00 ( 632.72) 353.1 TOTAL MISC LOCAL REVENUE 107.95 882.72 250.00 ( 632.72) 353.1 TRANSFERS IN: 50-4500-5510 TRANSFER FROM GENERAL FUND 150,000.00 600,000.00 600,000.00 .00 100.0 TOTAL TRANSFERS IN 150,000.00 600,000.00 600,000.00 .00 100.0 TOTAL FIRE EQUIPMENT - REVENUE 150,107.95 600,882.72 600,250.00 ( 632.72) 100.1 TOTAL FUND REVENUE 150,107.95 600,882.72 600,250.00 ( 632.72) 100.1 FIRE EQUIPMENT CAPITALIZED EXPENDITURES: 50-5500-6540 LAND .00 5,000.00 .00 ( 5,000.00) .0 50-5500-6548 BUILDINGS .00 230,381.41 600,000.00 369,618.59 38.4 TOTAL CAPITALIZED EXPENDITURES .00 235,381.41 600,000.00 364,618.59 39.2 TOTAL FIRE EQUIPMENT .00 235,381.41 600,000.00 364,618.59 39.2 TOTAL FUND EXPENDITURES .00 235,381.41 600,000.00 364,618.59 39.2 NET REVENUE OVER EXPENDITURES 150,107.95 365,501.31 250.00 ( 365,251.31) 146200. ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:18AM PAGE:69 ASSETS CURRENT ASSETS: CASH: 53-10000116 CASH ALLOC FR COMBINED FUND 2,811.66 TOTAL CASH 2,811.66 TOTAL CURRENT ASSETS 2,811.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,811.66 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 53-20000201 ALLOCATION FROM AP FUND 1,500.00 TOTAL ACCOUNTS PAYABLE 1,500.00 TOTAL CURRENT LIABILITIES 1,500.00 TOTAL LIABILITIES 1,500.00 NET ASSETS CAPITAL ASSETS: 53-30000300 FUND BALANCE/BEGINNING OF YEAR 2,811.66 TOTAL CAPITAL ASSETS 2,811.66 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1,500.00) BALANCE - CURRENT DATE 1,311.66 TOTAL NET ASSETS 1,311.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, 2020 CPTL PROJ - CLG PROJECTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:18AM PAGE:70 HISTORIC DISTRICT - REVENUE STATE REVENUE: 53-4809-3973 CERTIFIED LOCAL GOVERNMENT .00 .00 6,000.00 6,000.00 .0 TOTAL STATE REVENUE .00 .00 6,000.00 6,000.00 .0 TRANSFERS IN: 53-4809-5510 TRANSFER FROM GENERAL FUND .00 .00 4,000.00 4,000.00 .0 TOTAL TRANSFERS IN .00 .00 4,000.00 4,000.00 .0 TOTAL HISTORIC DISTRICT - REVENUE .00 .00 10,000.00 10,000.00 .0 TOTAL FUND REVENUE .00 .00 10,000.00 10,000.00 .0 HISTORIC DISTRICT PROFESSIONAL SERVICES: 53-5809-2158 MISC CONTRACTUAL SERVICES 1,500.00 1,500.00 10,000.00 8,500.00 15.0 TOTAL PROFESSIONAL SERVICES 1,500.00 1,500.00 10,000.00 8,500.00 15.0 TOTAL HISTORIC DISTRICT 1,500.00 1,500.00 10,000.00 8,500.00 15.0 TOTAL FUND EXPENDITURES 1,500.00 1,500.00 10,000.00 8,500.00 15.0 NET REVENUE OVER EXPENDITURES ( 1,500.00) ( 1,500.00) .00 1,500.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:18AM PAGE:71 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 52,677.77 TOTAL CASH 52,677.77 TOTAL CURRENT ASSETS 52,677.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 52,677.77 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 54-20000201 ALLOCATION FROM AP FUND 12,797.87 TOTAL ACCOUNTS PAYABLE 12,797.87 TOTAL CURRENT LIABILITIES 12,797.87 TOTAL LIABILITIES 12,797.87 NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 52,677.77 TOTAL CAPITAL ASSETS 52,677.77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 12,797.87) BALANCE - CURRENT DATE 39,879.90 TOTAL NET ASSETS 39,879.90 TOTAL LIABILITIES AND NET ASSETS 52,677.77 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:18AM PAGE:72 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE 12,797.87 12,797.87 15,000.00 2,202.13 85.3 TOTAL PROFESSIONAL SERVICES 12,797.87 12,797.87 15,000.00 2,202.13 85.3 TOTAL TRAIN CAR RESTORATION 12,797.87 12,797.87 15,000.00 2,202.13 85.3 TOTAL FUND EXPENDITURES 12,797.87 12,797.87 15,000.00 2,202.13 85.3 NET REVENUE OVER EXPENDITURES ( 12,797.87) ( 12,797.87) ( 15,000.00) ( 2,202.13) ( 85.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:18AM PAGE:73 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 34,108.86 TOTAL CASH 34,108.86 INVESTMENTS: 55-10000122 TIME DEPOSITS - SHORT TERM 229,794.91 TOTAL INVESTMENTS 229,794.91 ACCOUNTS RECEIVABLE: 55-10000139 ACCRUED INTEREST RECEIVABLE 213.72 TOTAL ACCOUNTS RECEIVABLE 213.72 TOTAL CURRENT ASSETS 264,117.49 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 264,117.49 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 55-20000201 ACCOUNTS PAY ALLOC TO FUNDS 11,173.30 TOTAL ACCOUNTS PAYABLE 11,173.30 TOTAL CURRENT LIABILITIES 11,173.30 TOTAL LIABILITIES 11,173.30 NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 228,119.91 TOTAL CAPITAL ASSETS 228,119.91 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:18AM PAGE:74 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 24,824.28 BALANCE - CURRENT DATE 252,944.19 TOTAL NET ASSETS 252,944.19 TOTAL LIABILITIES AND NET ASSETS 264,117.49 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:18AM PAGE:75 POOL IMPROVEMENTS - REVENUE MISC LOCAL REVENUE: 55-4550-1140 INTEREST INCOME 604.32 4,202.58 .00 ( 4,202.58) .0 TOTAL MISC LOCAL REVENUE 604.32 4,202.58 .00 ( 4,202.58) .0 TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL TRANSFERS IN 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL POOL IMPROVEMENTS - REVENUE 13,104.32 54,202.58 50,000.00 ( 4,202.58) 108.4 TOTAL FUND REVENUE 13,104.32 54,202.58 50,000.00 ( 4,202.58) 108.4 POOL IMPROVEMENTS CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG 11,173.30 29,378.30 42,500.00 13,121.70 69.1 TOTAL CAPITALIZED EXPENDITURES 11,173.30 29,378.30 42,500.00 13,121.70 69.1 TOTAL POOL IMPROVEMENTS 11,173.30 29,378.30 42,500.00 13,121.70 69.1 TOTAL FUND EXPENDITURES 11,173.30 29,378.30 42,500.00 13,121.70 69.1 NET REVENUE OVER EXPENDITURES 1,931.02 24,824.28 7,500.00 ( 17,324.28) 331.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:19AM PAGE:76 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 6,249,171.07 56-10000117 CASH WITH FISCAL AGENT 19,253.53 TOTAL CASH 6,268,424.60 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 8,461,826.77 TOTAL INVESTMENTS 8,461,826.77 ACCOUNTS RECEIVABLE: 56-10000139 ACCRUED INTEREST RECEIVABLE 7,624.65 56-10000156 DUE FROM OTHER FUNDS 49,588.59 TOTAL ACCOUNTS RECEIVABLE 57,213.24 TOTAL CURRENT ASSETS 14,787,464.61 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 14,787,464.61 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 411,194.86 56-20000204 ACCOUNTS PAYABLE - EOY 30,022.87 56-20000210 RETAINAGE PAYABLE 102,915.16 TOTAL ACCOUNTS PAYABLE 544,132.89 TOTAL CURRENT LIABILITIES 544,132.89 TOTAL LIABILITIES 544,132.89 NET ASSETS CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 8,006,643.09 TOTAL CAPITAL ASSETS 8,006,643.09 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:19AM PAGE:77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 6,236,688.63 BALANCE - CURRENT DATE 14,243,331.72 TOTAL NET ASSETS 14,243,331.72 TOTAL LIABILITIES AND NET ASSETS 14,787,464.61 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:19AM PAGE:78 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1109 REIMBURSEMENTS .00 1,433,797.82 .00 ( 1,433,797.82) .0 56-4560-1140 INTEREST INCOME 17,635.57 126,421.32 85,000.00 ( 41,421.32) 148.7 TOTAL MISC LOCAL REVENUE 17,635.57 1,560,219.14 85,000.00 ( 1,475,219.14) 1835.6 FEDERAL REVENUE SOURCES: 56-4560-4289 WYDOT .00 150,947.80 175,000.00 24,052.20 86.3 TOTAL FEDERAL REVENUE SOURCES .00 150,947.80 175,000.00 24,052.20 86.3 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND 1,625,000.00 6,500,000.00 6,500,000.00 .00 100.0 TOTAL TRANSFERS IN 1,625,000.00 6,500,000.00 6,500,000.00 .00 100.0 TOTAL STREET IMPROVEMENTS-REVENUE 1,642,635.57 8,211,166.94 6,760,000.00 ( 1,451,166.94) 121.5 TOTAL FUND REVENUE 1,642,635.57 8,211,166.94 6,760,000.00 ( 1,451,166.94) 121.5 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 66,272.84 294,527.28 836,000.00 541,472.72 35.2 56-5560-2158 MISC CONTRACTUAL SERVICES 13,548.00 40,558.50 55,000.00 14,441.50 73.7 TOTAL PROFESSIONAL SERVICES 79,820.84 335,085.78 891,000.00 555,914.22 37.6 CAPITALIZED EXPENDITURES: 56-5560-6544 OTHER THAN BLDG 359,221.11 1,639,392.53 6,710,000.00 5,070,607.47 24.4 TOTAL CAPITALIZED EXPENDITURES 359,221.11 1,639,392.53 6,710,000.00 5,070,607.47 24.4 TOTAL STREET IMPROVEMENTS 439,041.95 1,974,478.31 7,601,000.00 5,626,521.69 26.0 TOTAL FUND EXPENDITURES 439,041.95 1,974,478.31 7,601,000.00 5,626,521.69 26.0 NET REVENUE OVER EXPENDITURES 1,203,593.62 6,236,688.63 ( 841,000.00) ( 7,077,688.63) 741.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:19AM PAGE:79 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 810,765.93 TOTAL CASH 810,765.93 INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 1,232,316.14 TOTAL INVESTMENTS 1,232,316.14 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 2,118.68 TOTAL ACCOUNTS RECEIVABLE 2,118.68 TOTAL CURRENT ASSETS 2,045,200.75 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,045,200.75 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 325.65 57-20000204 ACCOUNTS PAYABLE - EOY 39.35 TOTAL ACCOUNTS PAYABLE 365.00 TOTAL CURRENT LIABILITIES 365.00 TOTAL LIABILITIES 365.00 NET ASSETS CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 1,163,178.19 57-30000305 FUND BALANCE RESERVE-PW FACILI 200,000.00 TOTAL CAPITAL ASSETS 1,363,178.19 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:19AM PAGE:80 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 681,657.56 BALANCE - CURRENT DATE 2,044,835.75 TOTAL NET ASSETS 2,044,835.75 TOTAL LIABILITIES AND NET ASSETS 2,045,200.75 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:19AM PAGE:81 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME 966.90 24,671.65 20,000.00 ( 4,671.65) 123.4 TOTAL MISC LOCAL REVENUE 966.90 24,671.65 20,000.00 ( 4,671.65) 123.4 TRANSFERS IN: 57-4570-5510 TRANSFER FROM GENERAL FUND 2,450,000.00 2,450,000.00 2,450,000.00 .00 100.0 TOTAL TRANSFERS IN 2,450,000.00 2,450,000.00 2,450,000.00 .00 100.0 TOTAL CAPITAL IMP - FACILITIES REV 2,450,966.90 2,474,671.65 2,470,000.00 ( 4,671.65) 100.2 TOTAL FUND REVENUE 2,450,966.90 2,474,671.65 2,470,000.00 ( 4,671.65) 100.2 CAPITAL IMP -FACILITIES PROFESSIONAL SERVICES: 57-5570-2153 ARCHITECT/ENGINEERING/SURVEY .00 6,917.25 50,000.00 43,082.75 13.8 TOTAL PROFESSIONAL SERVICES .00 6,917.25 50,000.00 43,082.75 13.8 CAPITALIZED EXPENDITURES: 57-5570-6542 BUILDINGS/IMPROVEMENTS .00 1,774,934.32 2,284,000.00 509,065.68 77.7 57-5570-6544 OTHER THAN BLDG 325.65 11,162.52 785,500.00 774,337.48 1.4 TOTAL CAPITALIZED EXPENDITURES 325.65 1,786,096.84 3,069,500.00 1,283,403.16 58.2 TOTAL CAPITAL IMP -FACILITIES 325.65 1,793,014.09 3,119,500.00 1,326,485.91 57.5 TOTAL FUND EXPENDITURES 325.65 1,793,014.09 3,119,500.00 1,326,485.91 57.5 NET REVENUE OVER EXPENDITURES 2,450,641.25 681,657.56 ( 649,500.00) ( 1,331,157.56) 105.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:20AM PAGE:82 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 2,508,476.33 TOTAL CASH 2,508,476.33 INVESTMENTS: 65-10000120 INVESTMENT POOL 490,000.00 65-10000122 TIME DEPOSITS - SHORT TERM 829,183.88 TOTAL INVESTMENTS 1,319,183.88 ACCOUNTS RECEIVABLE: 65-10000139 ACCRUED INTEREST RECEIVABLE 6,160.13 65-10000140 DUE FROM OTHER FUNDS 13,689.00 TOTAL ACCOUNTS RECEIVABLE 19,849.13 TOTAL CURRENT ASSETS 3,847,509.34 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,847,509.34 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 521,694.51 65-20000210 RETAINAGE PAYABLE 56,137.22 TOTAL ACCOUNTS PAYABLE 577,831.73 DUE TO OTHER FUNDS: 65-20000245 DUE TO OTHER FUND 49,588.59 TOTAL DUE TO OTHER FUNDS 49,588.59 TOTAL CURRENT LIABILITIES 627,420.32 TOTAL LIABILITIES 627,420.32 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:20AM PAGE:83 CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 1,142,057.92 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 1,164,973.81 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,055,115.21 BALANCE - CURRENT DATE 3,220,089.02 TOTAL NET ASSETS 3,220,089.02 TOTAL LIABILITIES AND NET ASSETS 3,847,509.34 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:21AM PAGE:84 PARK - REVE MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME .00 12,874.04 27,500.00 14,625.96 46.8 TOTAL MISC LOCAL REVENUE .00 12,874.04 27,500.00 14,625.96 46.8 TRANSFERS IN: 65-4650-5510 TRANSFER FROM GENERAL FUND 875,000.00 3,500,000.00 3,500,000.00 .00 100.0 TOTAL TRANSFERS IN 875,000.00 3,500,000.00 3,500,000.00 .00 100.0 TOTAL PARK - REVE 875,000.00 3,512,874.04 3,527,500.00 14,625.96 99.6 TOTAL FUND REVENUE 875,000.00 3,512,874.04 3,527,500.00 14,625.96 99.6 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY 21,348.60 78,481.40 525,000.00 446,518.60 15.0 65-5650-2158 MISC CONTRACTUAL SERVICES .00 .00 20,000.00 20,000.00 .0 TOTAL PROFESSIONAL SERVICES 21,348.60 78,481.40 545,000.00 466,518.60 14.4 CAPITALIZED EXPENDITURES: 65-5650-6544 OTHER THAN BLDG 504,575.48 1,379,277.43 2,867,000.00 1,487,722.57 48.1 TOTAL CAPITALIZED EXPENDITURES 504,575.48 1,379,277.43 2,867,000.00 1,487,722.57 48.1 TOTAL PARK IMPROVEMENTS 525,924.08 1,457,758.83 3,412,000.00 1,954,241.17 42.7 TOTAL FUND EXPENDITURES 525,924.08 1,457,758.83 3,412,000.00 1,954,241.17 42.7 NET REVENUE OVER EXPENDITURES 349,075.92 2,055,115.21 115,500.00 ( 1,939,615.21) 1779.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:23AM PAGE:85 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 4,424.29 TOTAL CASH 4,424.29 INVESTMENTS: 90-10000120 INVESTMENT POOL 107,067.25 90-10000122 TIME DEPOSITS - SHORT TERM 61,250.80 TOTAL INVESTMENTS 168,318.05 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 44.97 TOTAL ACCOUNTS RECEIVABLE 44.97 TOTAL CURRENT ASSETS 172,787.31 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 172,787.31 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 26,807.70 TOTAL CAPITAL ASSETS 26,807.70 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 4,369.21 BALANCE - CURRENT DATE 172,787.31 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:23AM PAGE:86 TOTAL NET ASSETS 172,787.31 TOTAL LIABILITIES AND NET ASSETS 172,787.31 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:23AM PAGE:87 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES 900.00 4,200.00 1,500.00 ( 2,700.00) 280.0 TOTAL REVENUE 900.00 4,200.00 1,500.00 ( 2,700.00) 280.0 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 237.76 2,826.92 1,000.00 ( 1,826.92) 282.7 TOTAL MISC LOCAL REVENUE 237.76 2,826.92 1,000.00 ( 1,826.92) 282.7 TOTAL PERPETUAL CARE - REVENUE 1,137.76 7,026.92 2,500.00 ( 4,526.92) 281.1 TOTAL FUND REVENUE 1,137.76 7,026.92 2,500.00 ( 4,526.92) 281.1 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 504.61 2,657.71 1,000.00 ( 1,657.71) 265.8 TOTAL TRANSFERS TO OTHER FUNDS 504.61 2,657.71 1,000.00 ( 1,657.71) 265.8 TOTAL PERPETUAL CARE 504.61 2,657.71 1,000.00 ( 1,657.71) 265.8 TOTAL FUND EXPENDITURES 504.61 2,657.71 1,000.00 ( 1,657.71) 265.8 NET REVENUE OVER EXPENDITURES 633.15 4,369.21 1,500.00 ( 2,869.21) 291.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:23AM PAGE:88 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, 2020 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:24AM PAGE:89 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 15,385.55 TOTAL CASH 15,385.55 TOTAL CURRENT ASSETS 15,385.55 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 15,385.55 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 3,763.21 92-20000406 HISTORIC PRESERVATION 5,330.63 92-20000407 HISTORIC PRESERVATION-KIOSK 16,789.30 92-20000408 HISTORIC PRESERVATION - MOVIE 615.38 TOTAL OTHER PAYABLES 26,498.52 TOTAL CURRENT LIABILITIES 26,498.52 TOTAL LIABILITIES 26,498.52 NET ASSETS CAPITAL ASSETS: 92-30000300 FUND BALANCE/BEGINNING OF YEAR ( 11,912.97) TOTAL CAPITAL ASSETS ( 11,912.97) OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 800.00 BALANCE - CURRENT DATE ( 11,112.97) TOTAL NET ASSETS ( 11,112.97) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:24AM PAGE:90 TOTAL LIABILITIES AND NET ASSETS 15,385.55 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:24AM PAGE:91 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 200.00 800.00 800.00 .00 100.0 TOTAL TRANSFERS IN 200.00 800.00 800.00 .00 100.0 TOTAL HISTORIC CMSN - REVENU 200.00 800.00 800.00 .00 100.0 TOTAL FUND REVENUE 200.00 800.00 800.00 .00 100.0 HISTORIC PRESERVATION PROFESSIONAL SERVICES: 92-5920-2158 MISC CONTRACTUAL SERVICES .00 .00 800.00 800.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 800.00 800.00 .0 TOTAL HISTORIC PRESERVATION .00 .00 800.00 800.00 .0 TOTAL FUND EXPENDITURES .00 .00 800.00 800.00 .0 NET REVENUE OVER EXPENDITURES 200.00 800.00 .00 ( 800.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:24AM PAGE:92 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 3,622.16 TOTAL CASH 3,622.16 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 86,843.80 TOTAL INVESTMENTS 86,843.80 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 72.79 TOTAL ACCOUNTS RECEIVABLE 72.79 TOTAL CURRENT ASSETS 90,538.75 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 90,538.75 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 265.00 TOTAL ACCOUNTS PAYABLE 265.00 OTHER LIABILITIES PAYABLE: 96-20000229 UTILITY DEPOSITS 82,894.02 TOTAL OTHER LIABILITIES PAYABLE 82,894.02 TOTAL CURRENT LIABILITIES 83,159.02 TOTAL LIABILITIES 83,159.02 NET ASSETS CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 7,162.18 TOTAL CAPITAL ASSETS 7,162.18 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:24AM PAGE:93 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 217.55 BALANCE - CURRENT DATE 7,379.73 TOTAL NET ASSETS 7,379.73 TOTAL LIABILITIES AND NET ASSETS 90,538.75 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2020 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:24AM PAGE:94 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME 217.55 1,458.56 .00 ( 1,458.56) .0 TOTAL MISC LOCAL REVENUE 217.55 1,458.56 .00 ( 1,458.56) .0 TOTAL UTILITY DEPOSITS - REVENUE 217.55 1,458.56 .00 ( 1,458.56) .0 TOTAL FUND REVENUE 217.55 1,458.56 .00 ( 1,458.56) .0 UTILITY DEPOSIT TRANSFERS TO OTHER FUNDS: 96-5960-5531 TRANSFER TO WATER 431.92 1,241.01 1,500.00 258.99 82.7 TOTAL TRANSFERS TO OTHER FUNDS 431.92 1,241.01 1,500.00 258.99 82.7 TOTAL UTILITY DEPOSIT 431.92 1,241.01 1,500.00 258.99 82.7 TOTAL FUND EXPENDITURES 431.92 1,241.01 1,500.00 258.99 82.7 NET REVENUE OVER EXPENDITURES ( 214.37) 217.55 ( 1,500.00) ( 1,717.55) 14.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2020 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/07/2020 09:24AM PAGE:95 ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS: INVESTMENTS: 97-10000173 SECURITIES - LONG TERM 4,982,901.11 97-10000174 INVESTMENTS - RHSA 447,069.42 TOTAL INVESTMENTS 5,429,970.53 TOTAL NON-CURRENT ASSETS 5,429,970.53 TOTAL ASSETS 5,429,970.53 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 97-30000300 FUND BALANCE/BEGINNING OF YEAR 5,429,970.53 TOTAL CAPITAL ASSETS 5,429,970.53 TOTAL NET ASSETS 5,429,970.53 TOTAL LIABILITIES AND NET ASSETS 5,429,970.53

Document Douglas_doc_3613be3bf0

Full Text