Douglas_doc_57a35fbd67 - Public Records Archive

Full Text

CITY OF DOUGLAS COMBINED CASH INVESTMENT APRIL 30, 2020 FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 19,502,830.15 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 142,301.01 01-10000113 CASH ON HAND 550.00 TOTAL COMBINED CASH 19,645,681.16 01-20000201 ACCOUNTS PAY ALLOC TO FUNDS ( 192.97) 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 19,645,488.19) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND 9,202,367.26 11 ALLOCATION TO IMPACT ASSISTANCE FUND 480,526.49 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 23,234.77 31 ALLOCATION TO WATER FUND 1,389,819.63 32 ALLOCATION TO SEWER FUND 745,249.15 33 ALLOCATION TO SANITATION FUND 535,994.96 34 ALLOCATION TO LANDFILL FUND 507,230.03 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 443,049.34 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 27,142.92 41 ALLOCATION TO ECONOMIC DEVELOPMENT 143,308.40 42 ALLOCATION TO BROWNFIELD GRANT ( 5,998.53) 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE ( 89,836.62) 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 331,577.33 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 39,813.86 56 ALLOCATION TO STREET IMPROVEMENT FUND 4,768,071.01 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES ( 935,591.88) 65 ALLOCATION TO CAPTL PROJ-PARK FUND 1,960,179.76 90 ALLOCATION TO PERPETUAL CARE FUND 3,093.94 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 2.75 92 ALLOCATION TO HISTORIC CMSN FUND 15,175.16 96 ALLOCATION TO UTILITY DEPOSIT FUND 5,589.03 TOTAL ALLOCATIONS TO OTHER FUNDS 19,645,488.19 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 19,645,488.19) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 GENERAL FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:2 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 9,202,367.26 TOTAL CASH 9,202,367.26 INVESTMENTS: 10-10000120 INVESTMENT POOL 8,039,082.66 10-10000122 TIME DEPOSITS - SHORT TERM 16,941,052.25 TOTAL INVESTMENTS 24,980,134.91 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 35,465.28 10-10000131 ACCOUNTS RECEIVABLE - GENERAL ( 2,069.02) 10-10000132 ACCOUNTS REC - PROPERTY TAX 498,721.09 10-10000133 ACCOUNTS CRT 10,952.65 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 3,336,577.80 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 922.53 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 11,659.32) 10-10000139 ACCRUED INTEREST RECEIVABLE 105,245.66 TOTAL ACCOUNTS RECEIVABLE 3,974,156.67 TOTAL CURRENT ASSETS 38,156,658.84 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 38,156,658.84 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 10-20000200 DEFERRED INFLOW 454,021.87 10-20000201 ALLOCATION FROM AP FUND 155,045.06 10-20000204 ACCOUNTS PAYABLE - EOY ( 25,360.18) 10-20000206 FUNDS PAYABLE - DUE TO OTHERS 15,000.00 10-20000207 SALES TAX PAYABLE 12.25 10-20000215 WAGES PAYABLE 113,167.01 10-20000216 WAGES PAYABLE - EOY 26,220.91 TOTAL ACCOUNTS PAYABLE 738,106.92 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 GENERAL FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:3 PAYROLL DEDUCTIONS PAYABLE: 10-20000223 FICA PAYABLE 1.43 10-20000224 DEFERRED COMPENSATION PAYABLE 48,700.83 10-20000227 WORKERS COMP INS PAYABLE 7,074.67 TOTAL PAYROLL DEDUCTIONS PAYABLE 55,776.93 UTILITY DEPOSITS PAYABLE: 10-20000229 UNCLAIMED PROPERTY 7,525.44 TOTAL UTILITY DEPOSITS 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 840,623.47 TOTAL LIABILITIES 840,623.47 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 30,153,888.72 10-30000301 FUND BALANCE RESERVE 2,270,000.00 TOTAL CAPITAL ASSETS 32,423,888.72 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 4,892,146.65 BALANCE - CURRENT DATE 37,316,035.37 TOTAL NET ASSETS 37,316,035.37 TOTAL LIABILITIES AND NET ASSETS 38,156,658.84 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:4 GENERAL - REVENUE MISC LOCAL REVENUE: 10-4100-1101 REIMBURSEMENT - CCSD .00 16,016.36 122,709.00 106,692.64 13.1 10-4100-1107 OTHER 509.52 4,454.45 10,000.00 5,545.55 44.5 10-4100-1108 COPY FEES/VIN CHECKS 520.00 5,072.93 2,000.00 ( 3,072.93) 253.7 10-4100-1109 REIMBURSEMENTS 7,680.89 87,212.12 100,000.00 12,787.88 87.2 10-4100-1112 CONTRIBUTIONS 15,064.83 15,064.83 10,000.00 ( 5,064.83) 150.7 10-4100-1115 LEASES/RENT 335.00 4,835.00 4,500.00 ( 335.00) 107.4 10-4100-1120 FINES/FORFEITS 845.00 21,883.00 50,000.00 28,117.00 43.8 10-4100-1122 TECHNOLOGY SURCHARGE 245.00 5,995.00 10,000.00 4,005.00 60.0 10-4100-1130 CASH LONG/SHORT .00 .25 .00 ( .25) .0 10-4100-1140 INTEREST INCOME 22,473.18 282,857.73 435,000.00 152,142.27 65.0 10-4100-1145 GAIN ON SALE OF FIXED ASSETS 11,425.00 13,925.00 .00 ( 13,925.00) .0 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 6,713.75 12,000.00 5,286.25 56.0 TOTAL MISC LOCAL REVENUE 59,098.42 464,030.42 756,209.00 292,178.58 61.4 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR .00 21,627.62 20,000.00 ( 1,627.62) 108.1 TOTAL LIQUOR LICENSES .00 21,627.62 20,000.00 ( 1,627.62) 108.1 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 151.63 14,600.63 13,500.00 ( 1,100.63) 108.2 TOTAL CONTRACTORS LICENSES 151.63 14,600.63 13,500.00 ( 1,100.63) 108.2 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 3,439.04 25,743.55 20,000.00 ( 5,743.55) 128.7 TOTAL BUILDING PERMITS 3,439.04 25,743.55 20,000.00 ( 5,743.55) 128.7 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 30.00 1,866.00 2,000.00 134.00 93.3 TOTAL ZONING/CONDITIONAL USE 30.00 1,866.00 2,000.00 134.00 93.3 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 5,634.07 336,919.62 450,000.00 113,080.38 74.9 10-4100-1321 PROPERTY TAX - PRIOR YEARS 44.41 1,138.21 500.00 ( 638.21) 227.6 10-4100-1322 PROPERTY TAX - AUTO 16,255.24 143,720.25 170,000.00 26,279.75 84.5 10-4100-1323 PROPERTY TAX - INTEREST 106.16 727.18 1,000.00 272.82 72.7 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 109.95) ( 2,378.47) ( 2,000.00) 378.47 ( 118.9) TOTAL PROPERTY TAXES 21,929.93 480,126.79 619,500.00 139,373.21 77.5 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:5 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 19,643.13 195,849.50 225,000.00 29,150.50 87.0 10-4100-1331 FRANCHISE FEES - CABLE TV .00 10,708.09 14,000.00 3,291.91 76.5 10-4100-1332 FRANCHISE FEES - SOURCE GAS 15,785.55 37,474.95 35,000.00 ( 2,474.95) 107.1 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 4,847.04 5,000.00 152.96 96.9 TOTAL FRANCHISE FEES 35,428.68 248,879.58 279,000.00 30,120.42 89.2 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL .00 78,182.25 104,243.00 26,060.75 75.0 10-4100-1421 MANAGEMENT FEES - WATER .00 198,909.00 265,212.00 66,303.00 75.0 10-4100-1422 MANAGEMENT FEES - SEWER .00 117,880.50 157,174.00 39,293.50 75.0 10-4100-1423 MANAGEMENT FEES - SANITATION .00 38,541.00 51,388.00 12,847.00 75.0 TOTAL MANAGEMENT FEES .00 433,512.75 578,017.00 144,504.25 75.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 .00 11,450.00 10,000.00 ( 1,450.00) 114.5 TOTAL BURIAL FEES .00 11,450.00 10,000.00 ( 1,450.00) 114.5 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 800.00 5,200.00 5,000.00 ( 200.00) 104.0 TOTAL LOT SALES 800.00 5,200.00 5,000.00 ( 200.00) 104.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 126,574.93 281,353.79 312,000.00 30,646.21 90.2 TOTAL MINERAL EXTRACTION 126,574.93 624,415.59 764,000.00 139,584.41 81.7 SALES TAX: 10-4100-3241 SALES TAX - STATE 661,332.93 9,476,655.98 5,500,000.00 ( 3,976,655.98) 172.3 10-4100-3245 SALES TAX - LOCAL OPTION 538,861.14 7,707,830.45 4,500,000.00 ( 3,207,830.45) 171.3 TOTAL SALES TAX 1,200,194.07 17,184,486.43 10,000,000.00 ( 7,184,486.43) 171.8 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:6 GAS TAX: 10-4100-3250 LOTTERY 10,355.26 45,857.23 60,000.00 14,142.77 76.4 10-4100-3257 GAS TAX 17,382.96 200,076.86 225,000.00 24,923.14 88.9 10-4100-3258 SPECIAL FUELS 5,442.99 56,445.64 55,000.00 ( 1,445.64) 102.6 TOTAL GAS TAX 33,181.21 302,379.73 340,000.00 37,620.27 88.9 OTHER: 10-4100-3262 CIGARETTE TAX 3,675.90 47,315.99 45,000.00 ( 2,315.99) 105.2 TOTAL OTHER 3,675.90 47,315.99 45,000.00 ( 2,315.99) 105.2 TOTAL GENERAL - REVENUE 1,484,503.81 19,939,420.94 13,533,826.00 ( 6,405,594.94) 147.3 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE .00 2,153.10 1,000.00 ( 1,153.10) 215.3 TOTAL OPERATING TRANSFERS IN .00 2,153.10 1,000.00 ( 1,153.10) 215.3 TOTAL OPERATING TRANSFERS - IN .00 2,153.10 1,000.00 ( 1,153.10) 215.3 TOTAL FUND REVENUE 1,484,503.81 19,941,574.04 13,534,826.00 ( 6,406,748.04) 147.3 GENERAL GOVT - NON DEPARTMENTL CASH FUND APPROPRIATION: 10-5100-0150 REPLACEMENT RESERVE .00 .00 300,000.00 300,000.00 .0 TOTAL CASH FUND APPROP .00 .00 300,000.00 300,000.00 .0 EMPLOYEE BENEFITS: 10-5100-1021 EMPLOYEE BENEFITS - SCL 7.63 167.06 150.00 ( 17.06) 111.4 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 20.00 2,065.00 3,000.00 935.00 68.8 TOTAL EMPLOYEE BENEFITS 27.63 2,232.06 3,150.00 917.94 70.9 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT .00 4,753.79 6,000.00 1,246.21 79.2 10-5100-2115 PUBLISHING/ADVERTISING 2,118.29 29,719.87 35,000.00 5,280.13 84.9 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 500.00 500.00 .0 TOTAL PURCHASED SERVICES 2,118.29 34,473.66 41,500.00 7,026.34 83.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:7 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 6,530.35 67,372.86 90,000.00 22,627.14 74.9 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 165.40 2,580.14 4,000.00 1,419.86 64.5 10-5100-2133 UTILITY SERVICES - NATURAL GAS 462.37 3,203.47 3,000.00 ( 203.47) 106.8 10-5100-2134 TELECOMMUNICATIONS 759.31 9,541.01 9,250.00 ( 291.01) 103.2 10-5100-2141 EQUIPMENT - RENT .00 97.02 250.00 152.98 38.8 TOTAL PROPERTY SERVICES 7,917.43 82,794.50 106,500.00 23,705.50 77.7 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 3,237.60 34,120.00 50,000.00 15,880.00 68.2 10-5100-2152 ACCOUNTING/AUDITING .00 44,250.00 50,000.00 5,750.00 88.5 10-5100-2153 ARCHITECHT/ENGINEERING/SURVEY 747.50 747.50 2,500.00 1,752.50 29.9 10-5100-2155 REPAIRS/MAINTENANCE 8,405.83 11,125.31 7,300.00 ( 3,825.31) 152.4 10-5100-2156 MAINTENANCE AGREEMENT .00 7,804.17 11,500.00 3,695.83 67.9 10-5100-2157 INSURANCE 389.00 42,412.00 105,000.00 62,588.00 40.4 10-5100-2158 MISC CONTRACTUAL SERVICES 2,070.00 42,804.25 40,000.00 ( 2,804.25) 107.0 10-5100-2166 COLLECTION FEES .00 139.93 100.00 ( 39.93) 139.9 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 75.00 500.00 425.00 15.0 TOTAL PROFESSIONAL SERVICES 14,849.93 183,478.16 266,900.00 83,421.84 68.7 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 532.13 8,837.22 13,500.00 4,662.78 65.5 10-5100-3210 OPERATING SUPPLIES 641.96 6,805.06 26,000.00 19,194.94 26.2 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5100-3230 REFRESHMENT SUPPLIES .00 274.73 2,000.00 1,725.27 13.7 10-5100-3235 FUEL 5,711.09 83,070.28 150,000.00 66,929.72 55.4 TOTAL SUPPLIES 6,885.18 98,987.29 192,500.00 93,512.71 51.4 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 31,798.46 404,863.05 921,550.00 516,686.95 43.9 GENERAL GOVT - CITY COUNCIL PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 1,375.00 13,750.00 16,500.00 2,750.00 83.3 TOTAL PERSONNEL SERVICES 1,375.00 13,750.00 16,500.00 2,750.00 83.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:8 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 105.20 1,052.00 1,262.00 210.00 83.4 10-5101-1025 EMPLOYEE BENEFITS - COMP 34.30 343.00 478.00 135.00 71.8 TOTAL EMPLOYEE BENEFITS 139.50 1,395.00 1,740.00 345.00 80.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 30,600.23 51,590.00 20,989.77 59.3 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 29,343.06 333,873.11 377,566.00 43,692.89 88.4 10-5102-1002 SALARIES/WAGES - OVERTIME 32.55 332.10 1,500.00 1,167.90 22.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,500.00 1,800.00 300.00 83.3 10-5102-1007 SALARIES/WAGES - INCENTIVE .00 1,539.20 998.00 ( 541.20) 154.2 TOTAL PERSONNEL SERVICES 29,525.61 339,101.07 383,721.00 44,619.93 88.4 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,303.84 26,433.81 30,018.00 3,584.19 88.1 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 9,122.48 87,148.19 109,490.00 22,341.81 79.6 10-5102-1025 EMPLOYEE BENEFITS - COMP 749.96 8,613.16 11,320.00 2,706.84 76.1 10-5102-1026 EMPLOYEE BENEFITS - COMP 589.60 6,470.85 7,666.00 1,195.15 84.4 10-5102-1029 EMPLOYEE BENEFITS - WY 5,052.60 56,225.14 64,896.00 8,670.86 86.6 TOTAL EMPLOYEE BENEFITS 17,818.48 184,891.15 223,390.00 38,498.85 82.8 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 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:9 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 173.44 500.00 326.56 34.7 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 20,500.00 20,500.00 .0 TOTAL SUPPLIES .00 173.44 21,000.00 20,826.56 .8 TOTAL GENERAL GOVT - ADMIN SERVICES 47,344.09 528,022.29 644,211.00 116,188.71 82.0 GENERAL GOVT - IT PERSONNEL SERVICES: 10-5103-1001 SALARIES/WAGES - REGULAR 6,254.82 68,726.74 81,309.00 12,582.26 84.5 10-5103-1005 SALARIES/WAGES - LONGEVITY .00 413.25 413.00 ( .25) 100.1 10-5103-1006 SALARIES/WAGES - ALLOWANCES 75.00 1,125.00 900.00 ( 225.00) 125.0 10-5103-1007 SALARIES/WAGES - INCENTIVE .00 707.20 1,626.00 918.80 43.5 TOTAL PERSONNEL SERVICES 6,329.82 70,972.19 84,248.00 13,275.81 84.2 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL 483.29 5,413.30 6,665.00 1,251.70 81.2 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS 2,065.47 20,654.70 24,770.00 4,115.30 83.4 10-5103-1025 EMPLOYEE BENEFITS - COMP 160.79 1,811.91 2,570.00 758.09 70.5 10-5103-1029 EMPLOYEE BENEFITS - WY 1,075.82 11,818.46 13,920.00 2,101.54 84.9 TOTAL EMPLOYEE BENEFITS 3,785.37 39,698.37 47,925.00 8,226.63 82.8 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 88.00 838.00 2,500.00 1,662.00 33.5 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 88.00 838.00 5,400.00 4,562.00 15.5 PROFESSIONAL SERVICES: 10-5103-2156 MAINTENANCE AGREEMENT .00 24,708.59 40,000.00 15,291.41 61.8 10-5103-2158 MISC CONTRACTUAL SERVICES 402.62 24,749.83 49,100.00 24,350.17 50.4 TOTAL PROFESSIONAL SERVICES 402.62 49,458.42 89,100.00 39,641.58 55.5 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 .00 800.00 800.00 .0 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 41,279.39 61,400.00 20,120.61 67.2 TOTAL SUPPLIES .00 41,279.39 62,200.00 20,920.61 66.4 TOTAL GENERAL GOVT - IT 10,605.81 202,246.37 288,873.00 86,626.63 70.0 GENERAL GOVT - MUNICIPAL COURT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:10 PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 2,174.04 34,523.07 43,412.00 8,888.93 79.5 10-5105-1005 SALARIES/WAGES - LONGEVITY .00 89.61 89.00 ( .61) 100.7 TOTAL PERSONNEL SERVICES 2,174.04 34,612.68 43,501.00 8,888.32 79.6 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 166.31 2,647.92 3,328.00 680.08 79.6 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS .00 13,866.33 18,446.00 4,579.67 75.2 10-5105-1025 EMPLOYEE BENEFITS - COMP 55.22 879.19 1,281.00 401.81 68.6 10-5105-1029 EMPLOYEE BENEFITS - PLC 181.24 4,196.40 5,206.00 1,009.60 80.6 TOTAL EMPLOYEE BENEFITS 402.77 21,589.84 28,261.00 6,671.16 76.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 285.00 9,673.90 14,400.00 4,726.10 67.2 10-5105-2162 COURT SURCHARGES 280.00 7,315.00 11,235.00 3,920.00 65.1 10-5105-2166 COLLECTION FEES .00 .00 500.00 500.00 .0 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 .00 500.00 500.00 .0 TOTAL PROFESSIONAL SERVICES 565.00 16,988.90 26,635.00 9,646.10 63.8 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES .00 31.86 450.00 418.14 7.1 10-5105-3233 UNIFORMS/CARE .00 .00 50.00 50.00 .0 TOTAL SUPPLIES .00 31.86 500.00 468.14 6.4 TOTAL GENERAL GOVT - MUNICIPAL COURT 3,141.81 73,223.28 99,907.00 26,683.72 73.3 GENERAL GOVT - PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 18,688.19 204,545.90 243,764.00 39,218.10 83.9 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 796.40 797.00 .60 99.9 10-5106-1006 SALARIES/WAGES - ALLOWANCES 75.00 1,125.00 900.00 ( 225.00) 125.0 10-5106-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,189.00 1,189.00 .0 TOTAL PERSONNEL SERVICES 18,763.19 206,467.30 246,650.00 40,182.70 83.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:24AM PAGE:11 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,477.88 16,217.95 19,711.00 3,493.05 82.3 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 3,709.50 37,094.21 44,449.00 7,354.79 83.5 10-5106-1025 EMPLOYEE BENEFITS - COMP 476.57 5,244.13 7,374.00 2,129.87 71.1 10-5106-1026 EMPLOYEE BENEFITS - COMP 599.42 5,970.24 6,517.00 546.76 91.6 10-5106-1029 EMPLOYEE BENEFITS - WY 2,704.74 29,653.68 35,215.00 5,561.32 84.2 TOTAL EMPLOYEE BENEFITS 8,968.11 94,180.21 113,266.00 19,085.79 83.2 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,142.00 1,320.00 178.00 86.5 10-5106-2122 TRAINING/DEVELOPMENT .00 1,760.88 4,125.00 2,364.12 42.7 10-5106-2123 MEALS/LODGING/TRAVEL 1,664.00 5,687.89 8,640.00 2,952.11 65.8 TOTAL PURCHASED SERVICES 1,664.00 8,590.77 14,085.00 5,494.23 61.0 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 84.14 846.39 1,000.00 153.61 84.6 TOTAL PROPERTY SERVICES 84.14 846.39 1,000.00 153.61 84.6 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 215.00 3,645.00 10,000.00 6,355.00 36.5 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT .00 1,933.21 2,100.00 166.79 92.1 10-5106-2158 MISC CONTRACTUAL SERVICES 806.00 6,050.00 6,050.00 .00 100.0 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 2,680.00 750.00 ( 1,930.00) 357.3 TOTAL PROFESSIONAL SERVICES 1,021.00 14,308.21 19,900.00 5,591.79 71.9 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES .00 1,048.67 5,300.00 4,251.33 19.8 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 597.48 1,000.00 402.52 59.8 10-5106-3235 FUEL .00 661.32 2,000.00 1,338.68 33.1 TOTAL SUPPLIES .00 2,307.47 8,300.00 5,992.53 27.8 TOTAL GENERAL GOVT - 30,500.44 326,700.35 403,201.00 76,500.65 81.0 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM 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 .00 45,000.00 60,000.00 15,000.00 75.0 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 12,500.00 15,000.00 2,500.00 83.3 10-5110-8707 COMM DVL 416.67 4,166.70 5,000.00 833.30 83.3 10-5110-8709 COMM 1,250.00 12,500.00 15,000.00 2,500.00 83.3 10-5110-8714 COMM ENTERPRIS 7,083.33 70,833.30 85,000.00 14,166.70 83.3 10-5110-8723 COMM HOCKEY .00 .00 274,000.00 274,000.00 .0 10-5110-8734 COMM PEAK .00 75,000.00 105,000.00 30,000.00 71.4 10-5110-8744 COMM 26,208.33 209,666.65 314,500.00 104,833.35 66.7 10-5110-8746 COMM & GIRLS 2,083.34 20,833.40 25,000.00 4,166.60 83.3 10-5110-8750 COMM ADVOC .00 2,000.00 4,000.00 2,000.00 50.0 10-5110-8753 COMM SRVC BLK .00 3,168.37 13,000.00 9,831.63 24.4 10-5110-8759 COMM SRVC CENTER .00 11,250.00 15,000.00 3,750.00 75.0 10-5110-8760 COMM SRVC JUSTICE 58,426.25 571,008.73 1,060,099.00 489,090.27 53.9 10-5110-8761 COMM SRVC - HERE TO HEL .00 403.36 8,000.00 7,596.64 5.0 10-5110-8762 WY PIONEER MUSEUM .00 1,180.85 10,000.00 8,819.15 11.8 10-5110-8763 OUTDOOR ENTHUSIAST-CONV CO .00 .00 6,000.00 6,000.00 .0 TOTAL GOVERNMENTAL ASSISTANCE 96,717.92 1,104,972.01 2,094,599.00 989,626.99 52.8 TOTAL COMMUNITY SERVICE CONTRACTS 96,717.92 1,104,972.01 2,094,599.00 989,626.99 52.8 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 13,339.38 150,918.62 177,290.00 26,371.38 85.1 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 750.00 900.00 150.00 83.3 10-5201-1007 SALARIES/WAGES - INCENTIVE 1,206.40 1,206.40 1,206.00 ( .40) 100.0 TOTAL PERSONNEL SERVICES 14,620.78 154,516.96 181,138.00 26,621.04 85.3 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 1,171.03 12,397.03 14,533.00 2,135.97 85.3 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 4,129.21 45,914.23 55,644.00 9,729.77 82.5 10-5201-1025 EMPLOYEE BENEFITS - COMP 556.53 4,401.19 5,726.00 1,324.81 76.9 10-5201-1026 EMPLOYEE BENEFITS - COMP 686.86 7,535.29 8,839.00 1,303.71 85.3 10-5201-1029 EMPLOYEE BENEFITS - WY 2,272.00 25,673.15 30,459.00 4,785.85 84.3 TOTAL EMPLOYEE BENEFITS 8,815.63 95,920.89 115,201.00 19,280.11 83.3 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 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:13 PROPERTY SERVICES: 10-5201-2131 UTILITY SERVICES - ELECTRICITY 113.71 1,258.48 2,000.00 741.52 62.9 10-5201-2134 TELECOMMUNICATIONS 40.01 492.14 494.00 1.86 99.6 TOTAL PROPERTY SERVICES 153.72 1,750.62 2,494.00 743.38 70.2 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5201-2156 MAINTENANCE AGREEMENT ( 337.10) 597.36 1,000.00 402.64 59.7 10-5201-2158 MISC CONTRACTUAL SERVICES 938.00 4,664.00 2,500.00 ( 2,164.00) 186.6 10-5201-2161 INCARCERATION CONTRACT 30.00 1,005.00 2,500.00 1,495.00 40.2 TOTAL PROFESSIONAL SERVICES 630.90 6,266.36 7,000.00 733.64 89.5 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 214.59 822.74 5,000.00 4,177.26 16.5 10-5201-3233 UNIFORMS/CARE .00 .00 500.00 500.00 .0 10-5201-3235 FUEL .00 469.79 600.00 130.21 78.3 TOTAL SUPPLIES 214.59 1,292.53 6,100.00 4,807.47 21.2 TOTAL POLICE DEPT - ADMINISTRATION 24,435.62 260,367.36 314,713.00 54,345.64 82.7 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 67,953.24 720,337.42 1,121,155.00 400,817.58 64.3 10-5202-1002 SALARIES/WAGES - OVERTIME 3,419.14 61,463.25 53,000.00 ( 8,463.25) 116.0 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 2,816.59 3,557.00 740.41 79.2 10-5202-1006 SALARIES/WAGES - ALLOWANCES 2,618.29 3,279.58 1,200.00 ( 2,079.58) 273.3 10-5202-1007 SALARIES/WAGES - INCENTIVE .00 540.80 8,379.00 7,838.20 6.5 TOTAL PERSONNEL SERVICES 73,990.67 788,437.64 1,187,291.00 398,853.36 66.4 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 5,744.18 61,231.76 91,895.00 30,663.24 66.6 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 26,875.27 246,409.35 409,729.00 163,319.65 60.1 10-5202-1025 EMPLOYEE BENEFITS - COMP 1,879.35 20,026.10 34,778.00 14,751.90 57.6 10-5202-1026 EMPLOYEE BENEFITS - COMP 1,096.79 11,977.16 13,947.00 1,969.84 85.9 10-5202-1029 EMPLOYEE BENEFITS - WY 12,241.66 131,318.71 199,379.00 68,060.29 65.9 TOTAL EMPLOYEE BENEFITS 47,837.25 470,963.08 749,728.00 278,764.92 62.8 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 110.00 990.00 1,295.00 305.00 76.5 10-5202-2122 TRAINING/DEVELOPMENT 293.80 1,854.80 17,980.00 16,125.20 10.3 10-5202-2123 MEALS/LODGING/TRAVEL .00 2,465.72 10,470.00 8,004.28 23.6 TOTAL PURCHASED SERVICES 403.80 5,310.52 29,745.00 24,434.48 17.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:14 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 748.29 12,839.22 17,635.00 4,795.78 72.8 TOTAL PROPERTY SERVICES 748.29 12,839.22 17,635.00 4,795.78 72.8 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE .00 885.59 10,000.00 9,114.41 8.9 10-5202-2156 MAINTENANCE AGREEMENT 3,754.48 5,521.48 13,286.00 7,764.52 41.6 10-5202-2158 MISC CONTRACTUAL SERVICES .00 2,630.00 2,500.00 ( 130.00) 105.2 TOTAL PROFESSIONAL SERVICES 3,754.48 9,037.07 25,786.00 16,748.93 35.1 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 23.88 300.00 276.12 8.0 10-5202-3210 OPERATING SUPPLIES 1,250.43 14,663.13 30,350.00 15,686.87 48.3 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 24,318.20 27,425.00 3,106.80 88.7 10-5202-3233 UNIFORMS/CARE 1,657.06 11,820.41 19,100.00 7,279.59 61.9 10-5202-3235 FUEL .00 15,637.34 16,500.00 862.66 94.8 TOTAL SUPPLIES 2,907.49 66,462.96 93,675.00 27,212.04 71.0 TOTAL POLICE DEPT - PATROL 129,641.98 1,353,050.49 2,103,860.00 750,809.51 64.3 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 11,365.71 124,760.10 147,750.00 22,989.90 84.4 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,210.10 1,210.00 ( .10) 100.0 10-5301-1006 SALARIES/WAGES - ALLOWANCES 75.00 750.00 900.00 150.00 83.3 10-5301-1007 SALARIES/WAGES - INCENTIVE .00 499.20 998.00 498.80 50.0 TOTAL PERSONNEL SERVICES 11,440.71 127,219.40 150,858.00 23,638.60 84.3 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 877.96 9,764.35 11,541.00 1,776.65 84.6 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 2,898.83 28,988.30 34,841.00 5,852.70 83.2 10-5301-1025 EMPLOYEE BENEFITS - COMP 290.59 3,231.31 4,421.00 1,189.69 73.1 10-5301-1029 EMPLOYEE BENEFITS - WY 1,954.90 21,454.37 25,295.00 3,840.63 84.8 TOTAL EMPLOYEE BENEFITS 6,022.28 63,438.33 76,098.00 12,659.67 83.4 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 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:15 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 912.68 8,484.89 10,750.00 2,265.11 78.9 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 298.15 3,202.67 10,000.00 6,797.33 32.0 10-5301-2133 UTILITY SERVICES - NATURAL GAS 1,155.27 8,031.23 9,500.00 1,468.77 84.5 10-5301-2134 TELECOMMUNICATIONS 44.50 378.30 500.00 121.70 75.7 TOTAL PROPERTY SERVICES 2,410.60 20,097.09 30,750.00 10,652.91 65.4 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 .00 2,629.84 3,880.00 1,250.16 67.8 TOTAL PROFESSIONAL SERVICES .00 3,619.84 6,380.00 2,760.16 56.7 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 341.11 1,920.33 3,000.00 1,079.67 64.0 10-5301-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 82.74 1,809.16 3,150.00 1,340.84 57.4 10-5301-3230 REFRESHMENT SUPPLIES 50.94 599.52 750.00 150.48 79.9 10-5301-3235 FUEL .00 825.92 2,500.00 1,674.08 33.0 TOTAL SUPPLIES 474.79 5,154.93 9,400.00 4,245.07 54.8 TOTAL PUBLIC WORKS - ADMINISTRATION 20,348.38 220,986.36 276,532.00 55,545.64 79.9 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 14,790.78 197,782.80 231,499.00 33,716.20 85.4 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 200.00 .00 ( 200.00) .0 10-5302-1007 SALARIES/WAGES - INCENTIVE .00 1,913.60 4,317.00 2,403.40 44.3 TOTAL PERSONNEL SERVICES 14,840.78 202,348.04 238,603.00 36,254.96 84.8 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,183.89 16,104.30 18,956.00 2,851.70 85.0 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 5,727.52 61,186.95 83,675.00 22,488.05 73.1 10-5302-1025 EMPLOYEE BENEFITS - COMP 376.96 5,139.68 7,028.00 1,888.32 73.1 10-5302-1026 EMPLOYEE BENEFITS - COMP 623.96 8,026.23 8,405.00 378.77 95.5 10-5302-1029 EMPLOYEE BENEFITS - WY 2,544.02 29,718.54 39,718.00 9,999.46 74.8 TOTAL EMPLOYEE BENEFITS 10,456.35 120,175.70 157,782.00 37,606.30 76.2 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 2,270.00 3,020.00 750.00 75.2 10-5302-2122 TRAINING/DEVELOPMENT 520.38 690.38 300.00 ( 390.38) 230.1 TOTAL PURCHASED SERVICES 520.38 2,960.38 3,320.00 359.62 89.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:16 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 2,583.51 11,119.19 14,000.00 2,880.81 79.4 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 18,874.87 22,335.00 3,460.13 84.5 10-5302-3235 FUEL .00 1,250.77 2,000.00 749.23 62.5 10-5302-3237 OIL/LUBE/FLUIDS 628.05 6,484.22 12,500.00 6,015.78 51.9 TOTAL SUPPLIES 3,211.56 37,729.05 50,835.00 13,105.95 74.2 TOTAL PUBLIC WORKS - SHOP 29,029.07 365,931.47 453,840.00 87,908.53 80.6 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 18,449.26 195,176.45 230,741.00 35,564.55 84.6 10-5304-1002 SALARIES/WAGES - OVERTIME .00 1,079.58 2,000.00 920.42 54.0 10-5304-1004 SALARIES/WAGES - TEMPORARY .00 17,276.52 59,640.00 42,363.48 29.0 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 832.87 832.00 ( .87) 100.1 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 250.00 300.00 50.00 83.3 10-5304-1007 SALARIES/WAGES - INCENTIVE .00 .00 541.00 541.00 .0 TOTAL PERSONNEL SERVICES 18,474.26 214,615.42 294,054.00 79,438.58 73.0 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 1,418.57 16,543.97 22,525.00 5,981.03 73.5 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 10,281.84 103,788.78 123,092.00 19,303.22 84.3 10-5304-1025 EMPLOYEE BENEFITS - COMP 469.23 5,477.23 8,686.00 3,208.77 63.1 10-5304-1026 EMPLOYEE BENEFITS - COMP 38.38 287.85 .00 ( 287.85) .0 10-5304-1029 EMPLOYEE BENEFITS - WY 3,173.30 33,924.47 39,845.00 5,920.53 85.1 TOTAL EMPLOYEE BENEFITS 15,381.32 160,022.30 194,148.00 34,125.70 82.4 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 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:17 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 1,471.13 13,391.23 18,000.00 4,608.77 74.4 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 661.59 69,572.46 80,000.00 10,427.54 87.0 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 2,132.72 82,963.69 99,000.00 16,036.31 83.8 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 .00 21,230.00 25,000.00 3,770.00 84.9 TOTAL PROFESSIONAL SERVICES .00 22,143.80 31,250.00 9,106.20 70.9 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 645.78 37,242.54 40,000.00 2,757.46 93.1 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5304-3235 FUEL .00 7,299.27 10,000.00 2,700.73 73.0 TOTAL SUPPLIES 645.78 44,541.81 51,000.00 6,458.19 87.3 TOTAL PUBLIC WORKS - PARKS 36,634.08 525,512.02 672,597.00 147,084.98 78.1 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 20,236.24 223,799.83 261,022.00 37,222.17 85.7 10-5305-1002 SALARIES/WAGES - OVERTIME 399.55 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 250.00 300.00 50.00 83.3 10-5305-1007 SALARIES/WAGES - INCENTIVE 540.80 1,331.20 2,637.00 1,305.80 50.5 TOTAL PERSONNEL SERVICES 21,201.59 236,603.12 281,142.00 44,538.88 84.2 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,628.80 18,175.70 21,596.00 3,420.30 84.2 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 8,021.82 80,208.11 120,432.00 40,223.89 66.6 10-5305-1025 EMPLOYEE BENEFITS - COMP 538.50 6,009.69 8,274.00 2,264.31 72.6 10-5305-1026 EMPLOYEE BENEFITS - COMP 59.58 654.65 774.00 119.35 84.6 10-5305-1029 EMPLOYEE BENEFITS - WY 3,549.35 38,271.58 45,372.00 7,100.42 84.4 TOTAL EMPLOYEE BENEFITS 13,798.05 143,319.73 196,448.00 53,128.27 73.0 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT .00 325.00 1,040.00 715.00 31.3 10-5305-2123 MEALS/LODGING/TRAVEL .00 .00 675.00 675.00 .0 TOTAL PURCHASED SERVICES .00 325.00 1,715.00 1,390.00 19.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:18 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 2,036.96 23,113.06 66,000.00 42,886.94 35.0 10-5305-2158 MISC CONTRACTUAL SERVICES 14.78 4,251.96 53,200.00 48,948.04 8.0 TOTAL PROFESSIONAL SERVICES 2,051.74 27,365.02 119,200.00 91,834.98 23.0 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 537.28 69,807.57 70,700.00 892.43 98.7 10-5305-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5305-3235 FUEL .00 17,345.68 28,500.00 11,154.32 60.9 TOTAL SUPPLIES 537.28 87,153.25 100,200.00 13,046.75 87.0 TOTAL PUBLIC WORKS - STREETS/ALLEYS 37,588.66 494,766.12 698,705.00 203,938.88 70.8 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 9,282.58 97,039.43 114,007.00 16,967.57 85.1 10-5306-1002 SALARIES/WAGES - OVERTIME .00 1,727.10 1,500.00 ( 227.10) 115.1 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 250.00 300.00 50.00 83.3 10-5306-1007 SALARIES/WAGES - INCENTIVE .00 998.40 1,642.00 643.60 60.8 TOTAL PERSONNEL SERVICES 9,307.58 111,674.66 130,205.00 18,530.34 85.8 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 715.08 8,490.23 9,990.00 1,499.77 85.0 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 4,120.15 40,223.26 49,330.00 9,106.74 81.5 10-5306-1025 EMPLOYEE BENEFITS - COMP 236.41 2,810.58 3,820.00 1,009.42 73.6 10-5306-1026 EMPLOYEE BENEFITS - COMP 38.38 287.85 .00 ( 287.85) .0 10-5306-1029 EMPLOYEE BENEFITS - WY 1,596.60 16,808.94 19,775.00 2,966.06 85.0 TOTAL EMPLOYEE BENEFITS 6,706.62 68,620.86 82,915.00 14,294.14 82.8 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 256.43 2,804.31 3,000.00 195.69 93.5 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 78.33 32,386.45 50,000.00 17,613.55 64.8 10-5306-2133 UTILITY SERVICES - NATURAL GAS 144.29 1,080.38 1,500.00 419.62 72.0 10-5306-2134 TELECOMMUNICATIONS 84.39 825.45 1,650.00 824.55 50.0 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 563.44 37,096.59 56,350.00 19,253.41 65.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:19 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 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 .00 7,765.00 9,250.00 1,485.00 84.0 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 888.34 10,682.54 13,000.00 2,317.46 82.2 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5306-3235 FUEL .00 1,587.22 2,500.00 912.78 63.5 TOTAL SUPPLIES 888.34 12,269.76 16,500.00 4,230.24 74.4 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND .00 400.00 1,000.00 600.00 40.0 TOTAL CAPITALIZED EXPENDITURES .00 400.00 1,000.00 600.00 40.0 TOTAL PUBLIC WORKS - CEMETERY 17,465.98 238,226.87 296,620.00 58,393.13 80.3 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 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 243.55 4,893.77 7,000.00 2,106.23 69.9 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB .00 4,721.76 12,000.00 7,278.24 39.4 10-5307-2133 UTILITY SERVICES - NATURAL GAS .00 4,255.06 6,000.00 1,744.94 70.9 10-5307-2134 TELECOMMUNICATIONS 68.10 765.86 1,500.00 734.14 51.1 TOTAL PROPERTY SERVICES 311.65 14,636.45 26,500.00 11,863.55 55.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:20 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE .00 526.50 5,000.00 4,473.50 10.5 10-5307-2158 MISC CONTRACTUAL SERVICES .00 .00 6,000.00 6,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 526.50 11,000.00 10,473.50 4.8 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 150.00 6,422.99 20,000.00 13,577.01 32.1 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 2,500.00 2,500.00 .0 TOTAL SUPPLIES 150.00 6,422.99 22,500.00 16,077.01 28.6 TOTAL PUBLIC WORKS - SWIM POOL 461.65 88,109.12 143,951.00 55,841.88 61.2 OPERATING TRANSFERS - OUT OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE .00 712,500.00 950,000.00 237,500.00 75.0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ .00 .00 3,180.00 3,180.00 .0 10-5998-4331 TRANSFER TO WATER .00 .00 1,650,000.00 1,650,000.00 .0 10-5998-4339 TRANSFER TO HEALTH INS RESERVE .00 .00 100,000.00 100,000.00 .0 10-5998-4341 TRANSFER TO ECONOMIC DEVELOPME .00 131,250.00 175,000.00 43,750.00 75.0 10-5998-4350 TRANSFER TO FIRE EQUIPMENT .00 450,000.00 600,000.00 150,000.00 75.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 .00 37,500.00 50,000.00 12,500.00 75.0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT .00 4,875,000.00 6,500,000.00 1,625,000.00 75.0 10-5998-4357 TRANSFER TO PUBLIC FACILITIES .00 .00 750,000.00 750,000.00 .0 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS .00 2,625,000.00 3,500,000.00 875,000.00 75.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN .00 600.00 800.00 200.00 75.0 TOTAL OPERATING TRANSFERS .00 8,831,850.00 14,282,980.00 5,451,130.00 61.8 TOTAL OPERATING TRANSFERS - OUT .00 8,831,850.00 14,282,980.00 5,451,130.00 61.8 TOTAL FUND EXPENDITURES 517,228.45 15,049,427.39 23,747,729.00 8,698,301.61 63.4 NET REVENUE OVER EXPENDITURES 967,275.36 4,892,146.65 ( 10,212,903.00) ( 15,105,049.65) 47.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:21 ASSETS CURRENT ASSETS: CASH: 11-10000116 CASH ALLOC FR COMBINED FUND 480,526.49 TOTAL CASH 480,526.49 TOTAL CURRENT ASSETS 480,526.49 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 480,526.49 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 459,000.00 BALANCE - CURRENT DATE 480,526.49 TOTAL NET ASSETS 480,526.49 TOTAL LIABILITIES AND NET ASSETS 480,526.49 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 IMPACT ASSISTANCE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:25AM PAGE:22 IMPACT ASSISTANCE - REVENUE STATE REVENUE: 11-4110-3239 IMPACT ASST-CEDAR SPRINGS 91,800.00 459,000.00 .00 ( 459,000.00) .0 TOTAL STATE REVENUE 91,800.00 459,000.00 .00 ( 459,000.00) .0 TOTAL IMPACT ASSISTANCE - REVENUE 91,800.00 459,000.00 .00 ( 459,000.00) .0 TOTAL FUND REVENUE 91,800.00 459,000.00 .00 ( 459,000.00) .0 NET REVENUE OVER EXPENDITURES 91,800.00 459,000.00 .00 ( 459,000.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:39AM PAGE:23 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 23,234.77 TOTAL CASH 23,234.77 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 1,409.32 13-10000132 ACCOUNTS RECEIVABLE - EOY 43,269.72 TOTAL ACCOUNTS RECEIVABLE 44,679.04 TOTAL CURRENT ASSETS 67,913.81 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 67,913.81 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000215 WAGES PAYABLE - CLEARING 5,240.45 13-20000216 WAGES PAYABLE - EOY ( 5,240.45) TOTAL ACCOUNTS PAYABLE .00 TOTAL CURRENT LIABILITIES .00 TOTAL LIABILITIES .00 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 APRIL 30, 2020 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:39AM PAGE:24 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 41,885.06 BALANCE - CURRENT DATE 67,913.81 TOTAL NET ASSETS 67,913.81 TOTAL LIABILITIES AND NET ASSETS 67,913.81 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:39AM PAGE:25 ASSET SEIZURE - REVENUE FEDERAL REVENUE SOURCES: 13-4130-4286 SEIZURE FUNDS 628.56 628.56 .00 ( 628.56) .0 TOTAL FEDERAL REVENUE SOURCES 628.56 628.56 .00 ( 628.56) .0 TOTAL ASSET SEIZURE - REVENUE 628.56 628.56 .00 ( 628.56) .0 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 192.56 17,592.57 14,804.00 ( 2,788.57) 118.8 TOTAL FEDERAL REVENUE SOURCES 192.56 17,592.57 14,804.00 ( 2,788.57) 118.8 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 192.56 17,592.57 14,804.00 ( 2,788.57) 118.8 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH .00 2,823.51 7,658.00 4,834.49 36.9 TOTAL STATE REVENUE .00 2,823.51 7,658.00 4,834.49 36.9 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE .00 2,823.51 7,658.00 4,834.49 36.9 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 10 MONTHS ENDING APRIL 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:40AM PAGE:26 FEDERAL REVENUE SOURCES: 13-4897-4292 DEPARTMENT OF JUSTICE .00 112,750.25 .00 ( 112,750.25) .0 TOTAL FEDERAL REVENUE SOURCES .00 112,750.25 .00 ( 112,750.25) .0 TOTAL SCHOOL VIOLENCE PREVENTION-REV .00 112,750.25 .00 ( 112,750.25) .0 TOTAL FUND REVENUE 821.12 135,028.64 28,822.00 ( 106,206.64) 468.5 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 .00 2,176.44 11,590.00 9,413.56 18.8 TOTAL PERSONNEL SERVICES .00 2,176.44 11,590.00 9,413.56 18.8 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL .00 166.49 887.00 720.51 18.8 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS .00 321.46 .00 ( 321.46) .0 13-5821-1025 EMPLOYEE BENEFITS - COMP .00 55.29 342.00 286.71 16.2 13-5821-1029 EMPLOYEE BENEFITS - WY .00 374.36 1,985.00 1,610.64 18.9 TOTAL EMPLOYEE BENEFITS .00 917.60 3,214.00 2,296.40 28.6 SUPPLIES: 13-5821-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 6,000.00 .00 ( 6,000.00) .0 TOTAL SUPPLIES .00 6,000.00 .00 ( 6,000.00) .0 CAPITALIZED EXPENDITURES: 13-5821-6547 EQUIPMENT/FURNITURE .00 8,820.00 .00 ( 8,820.00) .0 TOTAL CAPITALIZED EXPENDITURES .00 8,820.00 .00 ( 8,820.00) .0 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE .00 17,914.04 14,804.00 ( 3,110.04) 121.0 OJJDP-UNDERAGE ENFORCEMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:42AM PAGE:27 PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR .00 1,412.93 3,616.00 2,203.07 39.1 TOTAL PERSONNEL SERVICES .00 1,412.93 3,616.00 2,203.07 39.1 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL .00 108.12 277.00 168.88 39.0 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS .00 215.65 618.00 402.35 34.9 13-5831-1025 EMPLOYEE BENEFITS - COMP .00 35.90 107.00 71.10 33.6 13-5831-1029 EMPLOYEE BENEFITS - WY .00 222.50 620.00 397.50 35.9 TOTAL EMPLOYEE BENEFITS .00 582.17 1,622.00 1,039.83 35.9 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES .00 820.00 1,480.00 660.00 55.4 TOTAL PROFESSIONAL SERVICES .00 820.00 1,480.00 660.00 55.4 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES .00 466.41 940.00 473.59 49.6 TOTAL SUPPLIES .00 466.41 940.00 473.59 49.6 TOTAL OJJDP-UNDERAGE ENFORCEMENT .00 3,281.51 7,658.00 4,376.49 42.9 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 .00 ( 69,480.53) .0 TOTAL CAPITALIZED EXPENDITURES .00 69,480.53 .00 ( 69,480.53) .0 TOTAL SCHOOL VIOLENCE PREVENTION PRO .00 69,480.53 .00 ( 69,480.53) .0 TOTAL FUND EXPENDITURES .00 93,143.58 32,198.00 ( 60,945.58) 289.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 08:42AM PAGE:28 NET REVENUE OVER EXPENDITURES 821.12 41,885.06 ( 3,376.00) ( 45,261.06) 1240.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 WATER FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:02AM PAGE:29 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 1,389,819.63 31-10000117 CASH WITH FISCAL AGENT 304,717.81 31-10000118 MONEY MARKET ACCOUNT 121,334.65 TOTAL CASH 1,815,872.09 INVESTMENTS: 31-10000120 INVESTMENT POOL 3,980,000.00 31-10000122 TIME DEPOSITS - SHORT TERM 3,369,076.99 TOTAL INVESTMENTS 7,349,076.99 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 158,737.85 31-10000132 ACCOUNTS RECEIVABLE - EOY 170,170.20 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 186,522.66 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 9,998.64) 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 571,559.93 TOTAL CURRENT ASSETS 9,736,509.01 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 ( 375,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 4,963,103.07 31-10006100 DEFERRED OUTFLOW OF RESOURCES 140,920.03 TOTAL OTHER ASSETS 4,729,023.10 TOTAL NON-CURRENT ASSETS 18,271,763.85 TOTAL ASSETS 28,008,272.86 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 WATER FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:02AM PAGE:30 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 181,638.93 31-20000204 ACCOUNTS PAYABLE - EOY 39,553.15 31-20000210 RETAINAGE PAYABLE 304,717.81 31-20000215 WAGES PAYABLE 12,790.60 TOTAL ACCOUNTS PAYABLE 538,700.49 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 463,654.40 TOTAL OTHER PAYABLES 463,654.40 TOTAL CURRENT LIABILITIES 1,002,354.89 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,050,529.91 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 434,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 60,000.00 TOTAL CAPITAL ASSETS 9,316,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 ( 864,762.85) BALANCE - CURRENT DATE 26,957,742.95 TOTAL NET ASSETS 26,957,742.95 TOTAL LIABILITIES AND NET ASSETS 28,008,272.86 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:02AM PAGE:31 WATER - REVENUE MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 5,273.11 2,000.00 ( 3,273.11) 263.7 31-4310-1140 INTEREST INCOME 638.77 52,401.03 175,000.00 122,598.97 29.9 TOTAL MISC LOCAL REVENUE 638.77 57,674.14 177,000.00 119,325.86 32.6 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 150,054.75 1,987,532.46 2,300,000.00 312,467.54 86.4 31-4310-1705 UTILITY SERVICE FEES 625.00 16,175.00 20,000.00 3,825.00 80.9 31-4310-1706 WATER PLANT INVESTMENT FEES .00 43,050.00 2,000.00 ( 41,050.00) 2152.5 31-4310-1707 UTILITY LATE FEES .00 12,285.00 20,000.00 7,715.00 61.4 31-4310-1710 BULK WATER 12,318.45 181,687.45 100,000.00 ( 81,687.45) 181.7 TOTAL UTILITIES REVENUE 162,998.20 2,240,729.91 2,442,000.00 201,270.09 91.8 TRANSFERS IN: 31-4310-5596 TRANSFER FROM UTILITY DEPOSIT .00 809.09 200.00 ( 609.09) 404.6 TOTAL TRANSFERS IN .00 809.09 200.00 ( 609.09) 404.6 TOTAL WATER - REVENUE 163,636.97 2,299,213.14 2,619,200.00 319,986.86 87.8 LITTLE BOX ELDER SPRING - REVE STATE REVENUE: 31-4855-3235 WWDC GRANT 153,382.85 2,256,877.50 3,350,000.00 1,093,122.50 67.4 TOTAL STATE REVENUE 153,382.85 2,256,877.50 3,350,000.00 1,093,122.50 67.4 TRANSFERS IN: 31-4855-5510 TRANSFER FROM GENERAL FUND .00 .00 1,650,000.00 1,650,000.00 .0 TOTAL TRANSFERS IN .00 .00 1,650,000.00 1,650,000.00 .0 TOTAL LITTLE BOX ELDER SPRING - REVE 153,382.85 2,256,877.50 5,000,000.00 2,743,122.50 45.1 TOTAL FUND REVENUE 317,019.82 4,556,090.64 7,619,200.00 3,063,109.36 59.8 WATER - ADMINISTRATION DEPRECIATION: 31-5400-1150 DEPRECIATION .00 375,000.00 500,000.00 125,000.00 75.0 TOTAL DEPRECIATION .00 375,000.00 500,000.00 125,000.00 75.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:03AM PAGE:32 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 447.99 4,524.06 5,000.00 475.94 90.5 31-5400-2166 COLLECTION FEES .00 847.87 250.00 ( 597.87) 339.2 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 13,617.66 .00 ( 13,617.66) .0 TOTAL PROFESSIONAL SERVICES 447.99 18,989.59 5,250.00 ( 13,739.59) 361.7 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 .00 198,909.00 265,212.00 66,303.00 75.0 TOTAL OPERATING TRANSFERS .00 198,909.00 265,212.00 66,303.00 75.0 TOTAL WATER - ADMINISTRATION 447.99 593,186.59 770,846.00 177,659.41 77.0 WATER - TREATMENT CASH FUND APPROPRIATION: 31-5401-0150 REPLACEMENT RESERVE-SAND FILTE .00 .00 50,000.00 50,000.00 .0 31-5401-0153 REPLACEMENT RESERVE-SMW REHA .00 .00 15,000.00 15,000.00 .0 TOTAL CASH FUND APPROP .00 .00 65,000.00 65,000.00 .0 PERSONNEL SERVICES: 31-5401-1001 SALARIES/WAGES - REGULAR 7,792.48 85,680.54 101,310.00 15,629.46 84.6 31-5401-1002 SALARIES/WAGES - OVERTIME 437.35 4,767.09 6,000.00 1,232.91 79.5 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 534.95 536.00 1.05 99.8 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 250.00 300.00 50.00 83.3 31-5401-1007 SALARIES/WAGES - INCENTIVE .00 .00 2,026.00 2,026.00 .0 TOTAL PERSONNEL SERVICES 8,254.83 91,232.58 110,172.00 18,939.42 82.8 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 645.71 7,135.67 8,613.00 1,477.33 82.9 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 9,213.15 37,060.40 37,066.00 5.60 100.0 31-5401-1025 EMPLOYEE BENEFITS - COMP 209.68 2,317.41 3,202.00 884.59 72.4 31-5401-1026 EMPLOYEE BENEFITS - COMP 155.86 1,713.71 2,026.00 312.29 84.6 31-5401-1029 EMPLOYEE BENEFITS - WY 1,415.54 15,554.06 18,371.00 2,816.94 84.7 TOTAL EMPLOYEE BENEFITS 11,639.94 63,781.25 69,278.00 5,496.75 92.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:03AM PAGE:33 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 905.44 33,053.34 60,000.00 26,946.66 55.1 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 296.83 6,317.62 7,000.00 682.38 90.3 31-5401-2133 UTILITY SERVICES - NATURAL GAS 733.81 4,681.40 5,250.00 568.60 89.2 31-5401-2134 TELECOMMUNICATIONS 15.19 154.12 400.00 245.88 38.5 31-5401-2140 RENT - LAND/BUILDINGS .00 9,323.83 10,000.00 676.17 93.2 TOTAL PROPERTY SERVICES 1,951.27 53,530.31 82,650.00 29,119.69 64.8 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 2,024.00 7,581.69 15,000.00 7,418.31 50.5 31-5401-2156 MAINTENANCE AGREEMENT .00 .00 6,750.00 6,750.00 .0 31-5401-2158 MISC CONTRACTUAL SERVICES 154.00 13,871.00 30,000.00 16,129.00 46.2 TOTAL PROFESSIONAL SERVICES 2,178.00 22,565.18 54,250.00 31,684.82 41.6 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 149.46 27,238.19 25,000.00 ( 2,238.19) 109.0 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 790.00 26,662.61 34,500.00 7,837.39 77.3 31-5401-3235 FUEL .00 1,802.76 2,500.00 697.24 72.1 TOTAL SUPPLIES 939.46 55,703.56 62,000.00 6,296.44 89.8 CAPITALIZED EXPENDITURES: 31-5401-6542 TO BLDG .00 44,793.43 73,500.00 28,706.57 60.9 TOTAL CAPITALIZED EXPENDITURES .00 44,793.43 73,500.00 28,706.57 60.9 TOTAL WATER - TREATMENT 24,963.50 332,418.81 520,520.00 188,101.19 63.9 WATER - DISTRIBUTION/MAINTNCE PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 15,165.53 146,793.32 187,187.00 40,393.68 78.4 31-5402-1002 SALARIES/WAGES - OVERTIME .00 7,040.75 7,500.00 459.25 93.9 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 250.00 300.00 50.00 83.3 31-5402-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,011.00 1,011.00 .0 TOTAL PERSONNEL SERVICES 15,190.53 157,204.61 199,828.00 42,623.39 78.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:03AM PAGE:34 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,164.36 12,051.31 15,317.00 3,265.69 78.7 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 7,999.21 57,477.81 71,275.00 13,797.19 80.6 31-5402-1025 EMPLOYEE BENEFITS - COMP 385.86 3,993.08 5,877.00 1,883.92 67.9 31-5402-1029 EMPLOYEE BENEFITS - WY 2,608.50 26,252.86 33,330.00 7,077.14 78.8 TOTAL EMPLOYEE BENEFITS 12,157.93 99,775.06 125,799.00 26,023.94 79.3 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 78.38 1,375.98 1,700.00 324.02 80.9 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 78.38 2,140.98 5,075.00 2,934.02 42.2 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 1,707.41 12,452.23 13,500.00 1,047.77 92.2 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 3,916.49 42,429.39 38,000.00 ( 4,429.39) 111.7 31-5402-2133 UTILITY SERVICES - NATURAL GAS 133.03 975.26 1,500.00 524.74 65.0 31-5402-2134 TELECOMMUNICATIONS 16.00 145.20 350.00 204.80 41.5 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 5,772.93 56,002.08 53,750.00 ( 2,252.08) 104.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 .00 10,322.54 10,000.00 ( 322.54) 103.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 .00 12,697.54 18,400.00 5,702.46 69.0 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 3,791.64 34,518.73 35,000.00 481.27 98.6 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,728.03 4,000.00 1,271.97 68.2 31-5402-3235 FUEL .00 7,037.87 8,500.00 1,462.13 82.8 TOTAL SUPPLIES 3,791.64 44,284.63 47,500.00 3,215.37 93.2 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 52,894.00 103,000.00 50,106.00 51.4 31-5402-6547 EQUIPMENT/FURNITURE .00 .00 120,000.00 120,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 52,894.00 223,000.00 170,106.00 23.7 TOTAL WATER - DISTRIBUTION/MAINTNCE 36,991.41 425,257.85 673,702.00 248,444.15 63.1 WATER - CUSTOMER SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:03AM PAGE:35 PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 3,837.96 42,170.73 49,889.00 7,718.27 84.5 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 43,434.51 51,360.00 7,925.49 84.6 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 280.90 3,195.71 3,929.00 733.29 81.3 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 22.55 225.50 266.00 40.50 84.8 31-5403-1025 EMPLOYEE BENEFITS - COMP 97.48 1,103.18 1,486.00 382.82 74.2 31-5403-1029 EMPLOYEE BENEFITS - WY 660.12 7,251.79 8,541.00 1,289.21 84.9 TOTAL EMPLOYEE BENEFITS 1,061.05 11,776.18 14,222.00 2,445.82 82.8 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 167.39 200.00 32.61 83.7 TOTAL PROPERTY SERVICES 16.52 167.39 200.00 32.61 83.7 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 645.12 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 .00 1,248.15 2,500.00 1,251.85 49.9 TOTAL SUPPLIES 645.12 27,953.63 35,500.00 7,546.37 78.7 TOTAL WATER - CUSTOMER SERVICES 5,560.65 83,331.71 120,432.00 37,100.29 69.2 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 7,366.36 31,339.61 210,000.00 178,660.39 14.9 TOTAL PROFESSIONAL SERVICES 7,366.36 31,339.61 210,000.00 178,660.39 14.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:04AM PAGE:36 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG .00 .00 1,339,500.00 1,339,500.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 1,339,500.00 1,339,500.00 .0 TOTAL WATER MAIN REPLACEMENTS 7,366.36 31,339.61 1,549,500.00 1,518,160.39 2.0 LITTLE BOX ELDER SPRING REHAB PROFESSIONAL SERVICES: 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY 28,069.54 300,116.19 300,000.00 ( 116.19) 100.0 TOTAL PROFESSIONAL SERVICES 28,069.54 300,116.19 300,000.00 ( 116.19) 100.0 CAPITALIZED EXPENDITURES: 31-5855-6544 OTHER THAN BLDG 127,841.72 3,650,225.23 5,000,000.00 1,349,774.77 73.0 TOTAL CAPITALIZED EXPENDITURES 127,841.72 3,650,225.23 5,000,000.00 1,349,774.77 73.0 TOTAL LITTLE BOX ELDER SPRING REHAB 155,911.26 3,950,341.42 5,300,000.00 1,349,658.58 74.5 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 2,540.00 4,977.50 15,000.00 10,022.50 33.2 31-5856-2158 MISC CONTRACTUAL .00 .00 20,000.00 20,000.00 .0 TOTAL PROFESSIONAL SERVICES 2,540.00 4,977.50 35,000.00 30,022.50 14.2 CAPITALIZED EXPENDITURES: 31-5856-6544 OTHER THAN BLDG .00 .00 565,000.00 565,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 565,000.00 565,000.00 .0 TOTAL WATER IMPROVEMENTS 2,540.00 4,977.50 600,000.00 595,022.50 .8 TOTAL FUND EXPENDITURES 233,781.17 5,420,853.49 9,535,000.00 4,114,146.51 56.9 NET REVENUE OVER EXPENDITURES 83,238.65 ( 864,762.85) ( 1,915,800.00) ( 1,051,037.15) ( 45.1) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 SEWER FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:04AM PAGE:37 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 745,249.15 32-10000117 CASH WITH FISCAL AGENT 11,051.13 32-10000118 MONEY MARKET ACCOUNT 121,334.64 TOTAL CASH 877,634.92 INVESTMENTS: 32-10000120 INVESTMENT POOL 1,973,659.63 32-10000122 TIME DEPOSITS - SHORT TERM 3,293,400.76 TOTAL INVESTMENTS 5,267,060.39 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 17,550.00 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 2,500.40) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 122,332.17 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 9,852.43) 32-10000139 ACCRUED INTEREST RECEIVABLE 21,432.79 32-10000140 DUE FROM OTHER FUNDS 2,500.40 TOTAL ACCOUNTS RECEIVABLE 151,462.53 TOTAL CURRENT ASSETS 6,296,157.84 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 ( 206,250.00) 32-10000195 CONSTRUCTION IN PROGRESS 98,433.68 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 92,723.69 TOTAL OTHER ASSETS ( 15,092.63) TOTAL NON-CURRENT ASSETS 6,564,226.37 TOTAL ASSETS 12,860,384.21 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 SEWER FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:04AM PAGE:38 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 37,665.00 32-20000210 RETAINAGE PAYABLE 11,051.13 32-20000215 WAGES PAYABLE 9,597.01 TOTAL ACCOUNTS PAYABLE 58,313.14 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 305,103.65 TOTAL OTHER PAYABLES 305,103.65 TOTAL CURRENT LIABILITIES 363,416.79 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 35,460.97 TOTAL NON-CURRENT LIABILITIES 35,460.97 TOTAL LIABILITIES 398,877.76 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 195,000.00 TOTAL CAPITAL ASSETS 5,966,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 ( 182,424.92) BALANCE - CURRENT DATE 12,461,506.45 TOTAL NET ASSETS 12,461,506.45 TOTAL LIABILITIES AND NET ASSETS 12,860,384.21 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:04AM PAGE:39 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 418.92 50,542.37 100,000.00 49,457.63 50.5 TOTAL MISC LOCAL REVENUE 418.92 51,862.18 102,000.00 50,137.82 50.9 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 92,679.92 1,074,797.25 1,200,000.00 125,202.75 89.6 32-4320-1706 SEWER PLANT INVESTMENT FEES .00 22,000.00 1,000.00 ( 21,000.00) 2200.0 TOTAL UTILITIES REVENUE 92,679.92 1,096,797.25 1,201,000.00 104,202.75 91.3 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 14,587.50 332,527.50 250,000.00 ( 82,527.50) 133.0 TOTAL SEPTIC WASTE DISPOSAL 14,587.50 332,527.50 250,000.00 ( 82,527.50) 133.0 TOTAL SEWER - REVENUE 107,686.34 1,481,186.93 1,553,000.00 71,813.07 95.4 WASTEWATER REHAB-REVENU STATE REVENUE: 32-4850-3374 SLIB .00 9,870.36 ( 500,000.00) ( 509,870.36) 2.0 TOTAL STATE REVENUE .00 9,870.36 ( 500,000.00) ( 509,870.36) 2.0 TOTAL WASTEWATER REHAB-REVENU .00 9,870.36 ( 500,000.00) ( 509,870.36) 2.0 TOTAL FUND REVENUE 107,686.34 1,491,057.29 1,053,000.00 ( 438,057.29) 141.6 SEWER - ADMINISTRATION DEPRECIATION: 32-5500-1150 DEPRECIATION .00 206,250.00 275,000.00 68,750.00 75.0 TOTAL DEPRECIATION .00 206,250.00 275,000.00 68,750.00 75.0 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 289.33 2,921.83 4,000.00 1,078.17 73.1 32-5500-2166 COLLECTION FEES .00 35.87 .00 ( 35.87) .0 TOTAL PROFESSIONAL SERVICES 289.33 2,957.70 4,000.00 1,042.30 73.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:05AM PAGE:40 OPERATING TRANSFERS: 32-5500-4347 MANAGEMENT FEES .00 117,880.50 157,174.00 39,293.50 75.0 TOTAL OPERATING TRANSFERS .00 117,880.50 157,174.00 39,293.50 75.0 TOTAL SEWER - ADMINISTRATION 289.33 327,088.20 436,174.00 109,085.80 75.0 SEWER - TREATMENT CASH FUND APPROPRIATION: 32-5501-0150 SLUDGE REMOVAL RESERVE .00 .00 15,000.00 15,000.00 .0 TOTAL CASH FUND APPROP .00 .00 15,000.00 15,000.00 .0 PERSONNEL SERVICES: 32-5501-1001 SALARIES/WAGES - REGULAR 6,794.08 73,599.57 87,264.00 13,664.43 84.3 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 250.00 300.00 50.00 83.3 32-5501-1007 SALARIES/WAGES - INCENTIVE .00 .00 813.00 813.00 .0 TOTAL PERSONNEL SERVICES 6,819.08 74,133.90 93,662.00 19,528.10 79.2 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 528.74 5,748.94 7,257.00 1,508.06 79.2 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 3,089.47 30,890.15 37,005.00 6,114.85 83.5 32-5501-1025 EMPLOYEE BENEFITS - COMP 173.22 1,883.08 2,751.00 867.92 68.5 32-5501-1026 EMPLOYEE BENEFITS - COMP 62.54 687.18 813.00 125.82 84.5 32-5501-1029 EMPLOYEE BENEFITS - WY 1,168.56 12,656.36 15,796.00 3,139.64 80.1 TOTAL EMPLOYEE BENEFITS 5,022.53 51,865.71 63,622.00 11,756.29 81.5 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 7,505.67 78,832.55 95,000.00 16,167.45 83.0 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 5,609.49 45,708.08 70,000.00 24,291.92 65.3 32-5501-2134 TELECOMMUNICATIONS 138.81 1,225.50 400.00 ( 825.50) 306.4 TOTAL PROPERTY SERVICES 13,253.97 125,766.13 165,400.00 39,633.87 76.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:05AM PAGE:41 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 2,500.00 2,500.00 .0 32-5501-2155 REPAIRS/MAINTENANCE 7,795.71 19,285.18 32,000.00 12,714.82 60.3 32-5501-2158 MISC CONTRACTUAL SERVICES 722.00 7,231.00 15,000.00 7,769.00 48.2 TOTAL PROFESSIONAL SERVICES 8,517.71 26,516.18 49,500.00 22,983.82 53.6 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 2,913.52 27,466.69 25,000.00 ( 2,466.69) 109.9 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 9,754.13 25,900.00 16,145.87 37.7 32-5501-3235 FUEL .00 1,159.38 2,000.00 840.62 58.0 TOTAL SUPPLIES 2,913.52 38,380.20 52,900.00 14,519.80 72.6 CAPITALIZED EXPENDITURES: 32-5501-6544 OTHER THAN BLDG .00 13,000.81 25,000.00 11,999.19 52.0 TOTAL CAPITALIZED EXPENDITURES .00 13,000.81 25,000.00 11,999.19 52.0 TOTAL SEWER - TREATMENT 36,526.81 330,080.43 468,454.00 138,373.57 70.5 SEWER - COLLECTION PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 10,564.35 142,295.38 165,527.00 23,231.62 86.0 32-5502-1002 SALARIES/WAGES - OVERTIME .00 6,095.11 4,500.00 ( 1,595.11) 135.5 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 250.00 300.00 50.00 83.3 TOTAL PERSONNEL SERVICES 10,589.35 151,534.72 173,931.00 22,396.28 87.1 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 804.02 11,533.73 13,336.00 1,802.27 86.5 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 5,148.32 71,990.38 86,182.00 14,191.62 83.5 32-5502-1025 EMPLOYEE BENEFITS - COMP 268.96 3,849.01 5,142.00 1,292.99 74.9 32-5502-1029 EMPLOYEE BENEFITS - WY 1,817.04 25,518.14 29,109.00 3,590.86 87.7 TOTAL EMPLOYEE BENEFITS 8,038.34 112,891.26 133,769.00 20,877.74 84.4 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 78.37 1,376.02 1,700.00 323.98 80.9 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 78.37 2,781.02 5,075.00 2,293.98 54.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:05AM PAGE:42 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 1,016.60 9,848.06 15,000.00 5,151.94 65.7 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 22.71 207.24 350.00 142.76 59.2 32-5502-2133 UTILITY SERVICES - NATURAL GAS 251.17 1,700.16 1,800.00 99.84 94.5 32-5502-2134 TELECOMMUNICATIONS 79.06 775.80 715.00 ( 60.80) 108.5 TOTAL PROPERTY SERVICES 1,369.54 12,531.26 17,865.00 5,333.74 70.1 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 3,105.84 22,890.97 30,000.00 7,109.03 76.3 32-5502-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 3,500.00 3,500.00 .0 32-5502-3235 FUEL .00 6,292.93 8,500.00 2,207.07 74.0 TOTAL SUPPLIES 3,105.84 29,183.90 42,000.00 12,816.10 69.5 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-6547 EQUIPMENT/FURNITURE .00 200,646.69 220,000.00 19,353.31 91.2 TOTAL CAPITALIZED EXPENDITURES .00 200,646.69 220,000.00 19,353.31 91.2 TOTAL SEWER - COLLECTION 23,181.44 516,045.36 610,390.00 94,344.64 84.5 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 5,040.00 31,244.11 145,000.00 113,755.89 21.6 TOTAL PROFESSIONAL SERVICES 5,040.00 31,244.11 145,000.00 113,755.89 21.6 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 5,040.00 31,244.11 1,345,000.00 1,313,755.89 2.3 SEWER MAIN REPLACEMENTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:05AM PAGE:43 PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 3,096.72 85,110.43 354,000.00 268,889.57 24.0 TOTAL PROFESSIONAL SERVICES 3,096.72 85,110.43 354,000.00 268,889.57 24.0 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG .00 383,913.68 1,705,000.00 1,321,086.32 22.5 TOTAL CAPITALIZED EXPENDITURES .00 383,913.68 1,705,000.00 1,321,086.32 22.5 TOTAL SEWER MAIN REPLACEMENTS 3,096.72 469,024.11 2,059,000.00 1,589,975.89 22.8 TOTAL FUND EXPENDITURES 68,134.30 1,673,482.21 4,919,018.00 3,245,535.79 34.0 NET REVENUE OVER EXPENDITURES 39,552.04 ( 182,424.92) ( 3,866,018.00) ( 3,683,593.08) ( 4.7) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 SANITATION FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:06AM PAGE:44 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 535,994.96 TOTAL CASH 535,994.96 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 410,126.19 TOTAL INVESTMENTS 410,126.19 ACCOUNTS RECEIVABLE: 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 617.78) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 48,707.33 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 1,946.70) 33-10000139 ACCRUED INTEREST RECEIVABLE 1,171.85 33-10000156 DUE FROM OTHER FUNDS 617.78 TOTAL ACCOUNTS RECEIVABLE 47,932.48 TOTAL CURRENT ASSETS 994,053.63 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 ( 26,250.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 51,667.14 TOTAL OTHER ASSETS 25,417.14 TOTAL NON-CURRENT ASSETS 354,002.43 TOTAL ASSETS 1,348,056.06 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 SANITATION FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:06AM PAGE:45 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 4,125.60 33-20000215 WAGES PAYABLE 5,409.47 TOTAL ACCOUNTS PAYABLE 9,535.07 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 165,330.12 TOTAL OTHER PAYABLES 165,330.12 TOTAL CURRENT LIABILITIES 174,865.19 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 36,603.28 TOTAL NON-CURRENT LIABILITIES 36,603.28 TOTAL LIABILITIES 211,468.47 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 44,019.74) 33-30000305 RESERVE FOR REPLACEMENT 666,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 698,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 109,277.50 BALANCE - CURRENT DATE 1,136,587.59 TOTAL NET ASSETS 1,136,587.59 TOTAL LIABILITIES AND NET ASSETS 1,348,056.06 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:06AM PAGE:46 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1140 INTEREST INCOME 175.73 9,364.24 12,500.00 3,135.76 74.9 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 175.73 26,864.24 32,500.00 5,635.76 82.7 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 41,622.59 416,768.68 475,000.00 58,231.32 87.7 33-4330-1709 SANITATION ACTIVATION FEE 225.00 1,725.00 250.00 ( 1,475.00) 690.0 TOTAL UTILITIES REVENUE 41,847.59 418,493.68 475,250.00 56,756.32 88.1 TOTAL SANITATION - REVENUE 42,023.32 445,357.92 507,750.00 62,392.08 87.7 TOTAL FUND REVENUE 42,023.32 445,357.92 507,750.00 62,392.08 87.7 SANITATION CASH FUND APPROPRIATION: 33-5600-0150 REPLACEMENT RESERVE .00 .00 30,000.00 30,000.00 .0 TOTAL CASH FUND APPROP .00 .00 30,000.00 30,000.00 .0 PERSONNEL SERVICES: 33-5600-1001 SALARIES/WAGES - REGULAR 11,038.16 121,285.16 143,510.00 22,224.84 84.5 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 250.00 300.00 50.00 83.3 33-5600-1007 SALARIES/WAGES - INCENTIVE .00 1,535.20 3,677.00 2,141.80 41.8 TOTAL PERSONNEL SERVICES 11,063.16 124,317.96 149,335.00 25,017.04 83.3 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 859.36 9,653.48 11,593.00 1,939.52 83.3 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 5,149.61 51,496.13 61,667.00 10,170.87 83.5 33-5600-1025 EMPLOYEE BENEFITS - COMP 281.01 3,157.75 4,355.00 1,197.25 72.5 33-5600-1026 EMPLOYEE BENEFITS - COMP 140.16 1,540.06 1,822.00 281.94 84.5 33-5600-1029 EMPLOYEE BENEFITS - WY 1,898.58 20,856.91 24,672.00 3,815.09 84.5 TOTAL EMPLOYEE BENEFITS 8,328.72 86,704.33 104,109.00 17,404.67 83.3 DEPRECIATION: 33-5600-1150 DEPRECIATION .00 26,250.00 35,000.00 8,750.00 75.0 TOTAL DEPRECIATION .00 26,250.00 35,000.00 8,750.00 75.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:12AM PAGE:47 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE .00 1,899.92 1,000.00 ( 899.92) 190.0 33-5600-2158 MISC CONTRACTUAL SERVICES 196.00 1,979.32 3,000.00 1,020.68 66.0 33-5600-2175 REFUNDS/REIMBURSEMENTS .00 .00 125.00 125.00 .0 TOTAL PROFESSIONAL SERVICES 196.00 3,879.24 4,125.00 245.76 94.0 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 2,515.30 16,161.25 27,000.00 10,838.75 59.9 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,414.30 25,801.97 25,600.00 ( 201.97) 100.8 33-5600-3235 FUEL .00 14,424.67 22,000.00 7,575.33 65.6 TOTAL SUPPLIES 3,929.60 56,387.89 74,600.00 18,212.11 75.6 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES .00 38,541.00 51,388.00 12,847.00 75.0 TOTAL OPERATING TRANSFERS .00 38,541.00 51,388.00 12,847.00 75.0 CAPITALIZED EXPENDITURES: 33-5600-6548 VEHICLES .00 .00 205,000.00 205,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 205,000.00 205,000.00 .0 TOTAL SANITATION 23,517.48 336,080.42 653,557.00 317,476.58 51.4 TOTAL FUND EXPENDITURES 23,517.48 336,080.42 653,557.00 317,476.58 51.4 NET REVENUE OVER EXPENDITURES 18,505.84 109,277.50 ( 145,807.00) ( 255,084.50) 75.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 LANDFILL FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:12AM PAGE:48 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 507,230.03 TOTAL CASH 507,230.03 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,638,707.42 TOTAL INVESTMENTS 1,638,707.42 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 15,435.00 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 1,000.48) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY 72,292.44 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,535.72) 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 87,749.30 TOTAL CURRENT ASSETS 2,233,686.75 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 ( 67,500.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 59,451.45 TOTAL OTHER ASSETS ( 8,048.55) TOTAL NON-CURRENT ASSETS 2,118,974.33 TOTAL ASSETS 4,352,661.08 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 LANDFILL FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:12AM PAGE:49 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 44,894.97 34-20000204 ACCOUNTS PAYABLE- EOY 35,885.09 34-20000205 INTEREST PAYABLE 195.26 34-20000215 WAGES PAYABLE 7,471.39 TOTAL ACCOUNTS PAYABLE 88,446.71 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 212,812.39 TOTAL OTHER PAYABLES 212,812.39 TOTAL CURRENT LIABILITIES 301,259.10 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 824,379.98 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 129,317.95 BALANCE - CURRENT DATE 3,528,281.10 TOTAL NET ASSETS 3,528,281.10 TOTAL LIABILITIES AND NET ASSETS 4,352,661.08 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:12AM PAGE:50 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER .00 .00 1,000.00 1,000.00 .0 34-4340-1140 INTEREST INCOME 162.92 22,536.41 29,000.00 6,463.59 77.7 TOTAL MISC LOCAL REVENUE 162.92 22,536.41 30,000.00 7,463.59 75.1 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 93,646.94 1,001,922.33 1,000,000.00 ( 1,922.33) 100.2 TOTAL UTILITIES REVENUE 93,646.94 1,001,922.33 1,000,000.00 ( 1,922.33) 100.2 TOTAL LANDFILL - REVENUE 93,809.86 1,024,458.74 1,030,000.00 5,541.26 99.5 TOTAL FUND REVENUE 93,809.86 1,024,458.74 1,030,000.00 5,541.26 99.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,103.66 163,906.36 191,460.00 27,553.64 85.6 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 500.00 600.00 100.00 83.3 34-5340-1007 SALARIES/WAGES - INCENTIVE .00 582.48 558.00 ( 24.48) 104.4 TOTAL PERSONNEL SERVICES 15,153.66 166,503.51 195,423.00 28,919.49 85.2 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,211.77 13,323.48 15,631.00 2,307.52 85.2 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 6,171.26 61,703.52 73,879.00 12,175.48 83.5 34-5340-1025 EMPLOYEE BENEFITS - COMP 384.91 4,236.70 5,788.00 1,551.30 73.2 34-5340-1026 EMPLOYEE BENEFITS - COMP 658.74 7,322.51 8,121.00 798.49 90.2 34-5340-1029 EMPLOYEE BENEFITS - WY 1,939.09 20,863.36 24,914.00 4,050.64 83.7 TOTAL EMPLOYEE BENEFITS 10,365.77 107,449.57 128,333.00 20,883.43 83.7 DEPRECIATION: 34-5340-1150 DEPRECIATION .00 67,500.00 90,000.00 22,500.00 75.0 TOTAL DEPRECIATION .00 67,500.00 90,000.00 22,500.00 75.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:13AM PAGE:51 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 685.30 7,264.34 9,000.00 1,735.66 80.7 34-5340-2133 UTILITY SERVICES - NATURAL GAS 995.64 8,000.36 15,000.00 6,999.64 53.3 34-5340-2134 TELECOMMUNICATIONS 18.51 186.99 250.00 63.01 74.8 34-5340-2141 EQUIPMENT - RENT .00 96.00 200.00 104.00 48.0 TOTAL PROPERTY SERVICES 1,699.45 15,547.69 24,450.00 8,902.31 63.6 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 34-5340-2155 REPAIRS/MAINTENANCE 5,100.00 10,024.75 20,000.00 9,975.25 50.1 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 27,196.60 310,184.65 409,300.00 99,115.35 75.8 34-5340-2166 COLLECTION FEES .00 10.50 300.00 289.50 3.5 TOTAL PROFESSIONAL SERVICES 32,296.60 324,242.27 441,100.00 116,857.73 73.5 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 10,147.85 31,097.25 40,000.00 8,902.75 77.7 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 124.39 10,000.00 9,875.61 1.2 34-5340-3235 FUEL 751.07 11,541.41 30,000.00 18,458.59 38.5 TOTAL SUPPLIES 10,898.92 42,763.05 80,000.00 37,236.95 53.5 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 .00 78,182.25 104,243.00 26,060.75 75.0 TOTAL OPERATING TRANSFERS .00 78,182.25 104,243.00 26,060.75 75.0 TOTAL LANDFILL 70,414.40 816,559.34 1,145,199.00 328,639.66 71.3 LANDFILL - CAPITAL PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY .00 10,591.21 50,000.00 39,408.79 21.2 TOTAL PROFESSIONAL SERVICES .00 10,591.21 50,000.00 39,408.79 21.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:13AM PAGE:52 CAPITALIZED EXPENDITURES: 34-5895-6542 BUILDINGS/IMPROVEMENTS .00 16,933.00 30,000.00 13,067.00 56.4 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 .00 67,990.24 107,000.00 39,009.76 63.5 TOTAL LANDFILL - CAPITAL .00 78,581.45 157,000.00 78,418.55 50.1 TOTAL FUND EXPENDITURES 70,414.40 895,140.79 1,302,199.00 407,058.21 68.7 NET REVENUE OVER EXPENDITURES 23,395.46 129,317.95 ( 272,199.00) ( 401,516.95) 47.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:13AM PAGE:53 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 443,049.34 TOTAL CASH 443,049.34 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 410,227.88 TOTAL INVESTMENTS 410,227.88 ACCOUNTS RECEIVABLE: 39-10000131 ACCOUNTS RECEIVABLE - GENERAL 1,858.95 39-10000132 ACCOUNTS REC - EOY 87,015.83 39-10000139 ACCRUED INTEREST RECEIVABLE 516.27 TOTAL ACCOUNTS RECEIVABLE 89,391.05 TOTAL CURRENT ASSETS 942,668.27 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 942,668.27 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 800,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 662,522.01 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:13AM PAGE:54 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 34,146.26 BALANCE - CURRENT DATE 696,668.27 TOTAL NET ASSETS 696,668.27 TOTAL LIABILITIES AND NET ASSETS 942,668.27 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:13AM PAGE:55 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 156,306.86 341,323.68 25,000.00 ( 316,323.68) 1365.3 39-4390-0111 INSURANCE PREMIUMS 35,150.82 333,087.75 500,000.00 166,912.25 66.6 39-4390-0112 INSURANCE ASSESSMENTS 78,594.84 743,775.66 985,000.00 241,224.34 75.5 39-4390-0113 COBRA PAYMENTS 1,078.65 6,104.70 .00 ( 6,104.70) .0 TOTAL REVENUE 271,131.17 1,424,291.79 1,510,000.00 85,708.21 94.3 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 169.36 6,217.24 5,500.00 ( 717.24) 113.0 TOTAL MISC LOCAL REVENUE 169.36 6,217.24 5,500.00 ( 717.24) 113.0 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 271,300.53 1,430,509.03 1,615,500.00 184,990.97 88.6 TOTAL FUND REVENUE 271,300.53 1,430,509.03 1,615,500.00 184,990.97 88.6 EMPLOYEE HEALTH CARE CASH FUND APPROPRIATION: 39-5390-0150 REPLACEMENT RESERVE .00 .00 100,000.00 100,000.00 .0 TOTAL CASH FUND APPROP .00 .00 100,000.00 100,000.00 .0 EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM .00 227,347.43 300,000.00 72,652.57 75.8 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 197,697.91 1,071,188.69 900,000.00 ( 171,188.69) 119.0 39-5390-1058 HEALTH CARE - FEE .00 97,826.65 200,000.00 102,173.35 48.9 TOTAL EMPLOYEE BENEFITS 197,697.91 1,396,362.77 1,400,000.00 3,637.23 99.7 TOTAL EMPLOYEE HEALTH CARE 197,697.91 1,396,362.77 1,500,000.00 103,637.23 93.1 TOTAL FUND EXPENDITURES 197,697.91 1,396,362.77 1,500,000.00 103,637.23 93.1 NET REVENUE OVER EXPENDITURES 73,602.62 34,146.26 115,500.00 81,353.74 29.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:19AM PAGE:56 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 27,142.92 TOTAL CASH 27,142.92 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 318,241.22 TOTAL INVESTMENTS 318,241.22 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 432.92 TOTAL ACCOUNTS RECEIVABLE 432.92 TOTAL CURRENT ASSETS 345,817.06 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 345,817.06 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 4,319.96 BALANCE - CURRENT DATE 345,817.06 TOTAL NET ASSETS 345,817.06 TOTAL LIABILITIES AND NET ASSETS 345,817.06 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:19AM PAGE:57 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 9.21 4,319.96 4,500.00 180.04 96.0 TOTAL MISC LOCAL REVENUE 9.21 4,319.96 4,500.00 180.04 96.0 TOTAL CAPITAL IMP RESERVE - REVENUE 9.21 4,319.96 4,500.00 180.04 96.0 TOTAL FUND REVENUE 9.21 4,319.96 4,500.00 180.04 96.0 NET REVENUE OVER EXPENDITURES 9.21 4,319.96 4,500.00 180.04 96.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:25AM PAGE:58 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 143,308.40 TOTAL CASH 143,308.40 INVESTMENTS: 41-10000122 TIME DEPOSITS-SHORT TERM 175,828.97 TOTAL INVESTMENTS 175,828.97 TOTAL CURRENT ASSETS 319,137.37 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 319,137.37 LIABILITIES AND EQUITY LIABILITIES 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 132,728.24 BALANCE - CURRENT DATE 319,137.37 TOTAL NET ASSETS 319,137.37 TOTAL LIABILITIES AND NET ASSETS 319,137.37 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:25AM PAGE:59 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 48.62 1,478.24 500.00 ( 978.24) 295.7 TOTAL MISC LOCAL REVENUE 48.62 1,478.24 500.00 ( 978.24) 295.7 TRANSFERS IN: 41-4410-5510 TRANSFER FROM GENERAL FUND .00 131,250.00 175,000.00 43,750.00 75.0 TOTAL TRANSFERS IN .00 131,250.00 175,000.00 43,750.00 75.0 TOTAL ECONOMIC DEVELOPMENT 48.62 132,728.24 175,500.00 42,771.76 75.6 TOTAL FUND REVENUE 48.62 132,728.24 175,500.00 42,771.76 75.6 ECONOMIC DEVELOPMENT PROFESSIONAL SERVICES: 41-5410-2158 MISC CONTRACTUAL SERVICES .00 .00 175,000.00 175,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 175,000.00 175,000.00 .0 TOTAL ECONOMIC DEVELOPMENT .00 .00 175,000.00 175,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 175,000.00 175,000.00 .0 NET REVENUE OVER EXPENDITURES 48.62 132,728.24 500.00 ( 132,228.24) 26545.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 BROWNFIELD GRANT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:26AM PAGE:60 ASSETS CURRENT ASSETS: CASH: 42-10000116 CASH ALLOC FR COMBINED FUND ( 5,998.53) TOTAL CASH ( 5,998.53) TOTAL CURRENT ASSETS ( 5,998.53) TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS ( 5,998.53) LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 42-30000300 FUND BALANCE/BEGINNING OF YEAR ( 1.80) TOTAL CAPITAL ASSETS ( 1.80) OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 5,996.73) BALANCE - CURRENT DATE ( 5,998.53) TOTAL NET ASSETS ( 5,998.53) TOTAL LIABILITIES AND NET ASSETS ( 5,998.53) ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:26AM PAGE:61 BROWNFIELD HAZARDOUS - REVENUE FEDERAL REVENUE SOURCES: 42-4870-4281 EPA 6,815.46 27,966.98 290,100.00 262,133.02 9.6 TOTAL FEDERAL REVENUE SOURCES 6,815.46 27,966.98 290,100.00 262,133.02 9.6 TOTAL BROWNFIELD HAZARDOUS - REVENUE 6,815.46 27,966.98 290,100.00 262,133.02 9.6 BROWNFIELD PETROLEUM - REVENUE FEDERAL REVENUE SOURCES: 42-4871-4281 EPA 329.95 4,933.44 .00 ( 4,933.44) .0 TOTAL FEDERAL REVENUE SOURCES 329.95 4,933.44 .00 ( 4,933.44) .0 TOTAL BROWNFIELD PETROLEUM - REVENUE 329.95 4,933.44 .00 ( 4,933.44) .0 TOTAL FUND REVENUE 7,145.41 32,900.42 290,100.00 257,199.58 11.3 BROWNFIELD HAZARDOUS PROFESSIONAL SERVICES: 42-5870-2158 MISC CONTRACTUAL SERVICES .00 29,996.88 290,100.00 260,103.12 10.3 TOTAL PROFESSIONAL SERVICES .00 29,996.88 290,100.00 260,103.12 10.3 TOTAL BROWNFIELD HAZARDOUS .00 29,996.88 290,100.00 260,103.12 10.3 BROWNFIELD PETROLEUM PROFESSIONAL SERVICES: 42-5871-2158 MISC CONTRACTUAL SERVICES .00 8,900.27 .00 ( 8,900.27) .0 TOTAL PROFESSIONAL SERVICES .00 8,900.27 .00 ( 8,900.27) .0 TOTAL BROWNFIELD PETROLEUM .00 8,900.27 .00 ( 8,900.27) .0 TOTAL FUND EXPENDITURES .00 38,897.15 290,100.00 251,202.85 13.4 NET REVENUE OVER EXPENDITURES 7,145.41 ( 5,996.73) .00 5,996.73 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:37AM PAGE:62 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND ( 89,836.62) TOTAL CASH ( 89,836.62) INVESTMENTS: 47-10000122 TIME DEPOSITS - SHORT TERM 102,556.97 TOTAL INVESTMENTS 102,556.97 ACCOUNTS RECEIVABLE: 47-10000139 ACCRUED INTEREST RECEIVABLE 129.07 TOTAL ACCOUNTS RECEIVABLE 129.07 TOTAL CURRENT ASSETS 12,849.42 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 12,849.42 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 47-20000201 ALLOCATION FROM AP FUND 13,650.57 TOTAL ACCOUNTS PAYABLE 13,650.57 TOTAL CURRENT LIABILITIES 13,650.57 TOTAL LIABILITIES 13,650.57 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 APRIL 30, 2020 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:37AM PAGE:63 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 11,553.59 BALANCE - CURRENT DATE ( 801.15) TOTAL NET ASSETS ( 801.15) TOTAL LIABILITIES AND NET ASSETS 12,849.42 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:37AM PAGE:64 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME 50.60 1,157.10 5,500.00 4,342.90 21.0 TOTAL MISC LOCAL REVENUE 50.60 1,157.10 5,500.00 4,342.90 21.0 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND .00 712,500.00 950,000.00 237,500.00 75.0 TOTAL TRANSFERS IN .00 712,500.00 950,000.00 237,500.00 75.0 TOTAL GENERAL FUND EQUIP RES-REVENUE 50.60 713,657.10 955,500.00 241,842.90 74.7 TOTAL FUND REVENUE 50.60 713,657.10 955,500.00 241,842.90 74.7 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE 13,650.57 683,481.51 679,972.00 ( 3,509.51) 100.5 47-5470-6548 VEHICLES .00 18,622.00 272,130.00 253,508.00 6.8 TOTAL CAPITALIZED EXPENDITURES 13,650.57 702,103.51 952,102.00 249,998.49 73.7 TOTAL GENERAL FUND EQUIPMENT RESERVE 13,650.57 702,103.51 952,102.00 249,998.49 73.7 TOTAL FUND EXPENDITURES 13,650.57 702,103.51 952,102.00 249,998.49 73.7 NET REVENUE OVER EXPENDITURES ( 13,599.97) 11,553.59 3,398.00 ( 8,155.59) 340.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:55AM PAGE:65 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 331,577.33 TOTAL CASH 331,577.33 TOTAL CURRENT ASSETS 331,577.33 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 331,577.33 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 215,274.36 BALANCE - CURRENT DATE 331,577.33 TOTAL NET ASSETS 331,577.33 TOTAL LIABILITIES AND NET ASSETS 331,577.33 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 09:55AM PAGE:66 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1140 INTEREST INCOME 112.48 655.77 250.00 ( 405.77) 262.3 TOTAL MISC LOCAL REVENUE 112.48 655.77 250.00 ( 405.77) 262.3 TRANSFERS IN: 50-4500-5510 TRANSFER FROM GENERAL FUND .00 450,000.00 600,000.00 150,000.00 75.0 TOTAL TRANSFERS IN .00 450,000.00 600,000.00 150,000.00 75.0 TOTAL FIRE EQUIPMENT - REVENUE 112.48 450,655.77 600,250.00 149,594.23 75.1 TOTAL FUND REVENUE 112.48 450,655.77 600,250.00 149,594.23 75.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 112.48 215,274.36 250.00 ( 215,024.36) 86109.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:09AM PAGE:67 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 NET ASSETS CAPITAL ASSETS: 53-30000300 FUND BALANCE/BEGINNING OF YEAR 2,811.66 TOTAL CAPITAL ASSETS 2,811.66 TOTAL NET ASSETS 2,811.66 TOTAL LIABILITIES AND NET ASSETS 2,811.66 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 CPTL PROJ - CLG PROJECTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:09AM PAGE:68 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 .00 .00 10,000.00 10,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 10,000.00 10,000.00 .0 TOTAL HISTORIC DISTRICT .00 .00 10,000.00 10,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 10,000.00 10,000.00 .0 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:11AM PAGE:69 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 NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 52,677.77 TOTAL CAPITAL ASSETS 52,677.77 TOTAL NET ASSETS 52,677.77 TOTAL LIABILITIES AND NET ASSETS 52,677.77 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:12AM PAGE:70 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE .00 .00 15,000.00 15,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 15,000.00 15,000.00 .0 TOTAL TRAIN CAR RESTORATION .00 .00 15,000.00 15,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 15,000.00 15,000.00 .0 NET REVENUE OVER EXPENDITURES .00 .00 ( 15,000.00) ( 15,000.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:13AM PAGE:71 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 39,813.86 TOTAL CASH 39,813.86 INVESTMENTS: 55-10000122 TIME DEPOSITS - SHORT TERM 227,982.58 TOTAL INVESTMENTS 227,982.58 ACCOUNTS RECEIVABLE: 55-10000139 ACCRUED INTEREST RECEIVABLE 213.72 TOTAL ACCOUNTS RECEIVABLE 213.72 TOTAL CURRENT ASSETS 268,010.16 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 268,010.16 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 228,119.91 TOTAL CAPITAL ASSETS 228,119.91 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 39,890.25 BALANCE - CURRENT DATE 268,010.16 TOTAL NET ASSETS 268,010.16 TOTAL LIABILITIES AND NET ASSETS 268,010.16 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:13AM PAGE:72 POOL IMPROVEMENTS - REVENUE MISC LOCAL REVENUE: 55-4550-1140 INTEREST INCOME .00 2,390.25 .00 ( 2,390.25) .0 TOTAL MISC LOCAL REVENUE .00 2,390.25 .00 ( 2,390.25) .0 TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND .00 37,500.00 50,000.00 12,500.00 75.0 TOTAL TRANSFERS IN .00 37,500.00 50,000.00 12,500.00 75.0 TOTAL POOL IMPROVEMENTS - REVENUE .00 39,890.25 50,000.00 10,109.75 79.8 TOTAL FUND REVENUE .00 39,890.25 50,000.00 10,109.75 79.8 POOL IMPROVEMENTS CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG .00 .00 42,500.00 42,500.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 42,500.00 42,500.00 .0 TOTAL POOL IMPROVEMENTS .00 .00 42,500.00 42,500.00 .0 TOTAL FUND EXPENDITURES .00 .00 42,500.00 42,500.00 .0 NET REVENUE OVER EXPENDITURES .00 39,890.25 7,500.00 ( 32,390.25) 531.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:18AM PAGE:73 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 4,768,071.01 56-10000117 CASH WITH FISCAL AGENT 19,253.53 TOTAL CASH 4,787,324.54 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 8,410,917.32 TOTAL INVESTMENTS 8,410,917.32 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 13,255,455.10 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 13,255,455.10 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 42,150.37 56-20000204 ACCOUNTS PAYABLE - EOY 30,022.87 56-20000210 RETAINAGE PAYABLE 64,475.53 TOTAL ACCOUNTS PAYABLE 136,648.77 TOTAL CURRENT LIABILITIES 136,648.77 TOTAL LIABILITIES 136,648.77 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 APRIL 30, 2020 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:18AM PAGE:74 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 5,112,163.24 BALANCE - CURRENT DATE 13,118,806.33 TOTAL NET ASSETS 13,118,806.33 TOTAL LIABILITIES AND NET ASSETS 13,255,455.10 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:18AM PAGE:75 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 .00 75,511.87 .00 ( 75,511.87) .0 TOTAL MISC LOCAL REVENUE .00 1,509,309.69 .00 ( 1,509,309.69) .0 FEDERAL REVENUE SOURCES: 56-4560-4289 WYDOT .00 150,947.80 .00 ( 150,947.80) .0 TOTAL FEDERAL REVENUE SOURCES .00 150,947.80 .00 ( 150,947.80) .0 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND .00 4,875,000.00 .00 ( 4,875,000.00) .0 TOTAL TRANSFERS IN .00 4,875,000.00 .00 ( 4,875,000.00) .0 TOTAL STREET IMPROVEMENTS-REVENUE .00 6,535,257.49 .00 ( 6,535,257.49) .0 TOTAL FUND REVENUE .00 6,535,257.49 .00 ( 6,535,257.49) .0 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 36,452.87 221,837.77 .00 ( 221,837.77) .0 56-5560-2158 MISC CONTRACTUAL SERVICES 5,697.50 27,010.50 .00 ( 27,010.50) .0 TOTAL PROFESSIONAL SERVICES 42,150.37 248,848.27 .00 ( 248,848.27) .0 CAPITALIZED EXPENDITURES: 56-5560-6544 OTHER THAN BLDG .00 1,174,245.98 .00 ( 1,174,245.98) .0 TOTAL CAPITALIZED EXPENDITURES .00 1,174,245.98 .00 ( 1,174,245.98) .0 TOTAL STREET IMPROVEMENTS 42,150.37 1,423,094.25 .00 ( 1,423,094.25) .0 TOTAL FUND EXPENDITURES 42,150.37 1,423,094.25 .00 ( 1,423,094.25) .0 NET REVENUE OVER EXPENDITURES ( 42,150.37) 5,112,163.24 .00 ( 5,112,163.24) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:23AM PAGE:76 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND ( 935,591.88) TOTAL CASH ( 935,591.88) INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 1,224,516.74 TOTAL INVESTMENTS 1,224,516.74 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 2,118.68 TOTAL ACCOUNTS RECEIVABLE 2,118.68 TOTAL CURRENT ASSETS 291,043.54 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 291,043.54 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 2,451.76 57-20000204 ACCOUNTS PAYABLE - EOY 39.35 TOTAL ACCOUNTS PAYABLE 2,491.11 TOTAL CURRENT LIABILITIES 2,491.11 TOTAL LIABILITIES 2,491.11 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 APRIL 30, 2020 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:23AM PAGE:77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1,074,625.76) BALANCE - CURRENT DATE 288,552.43 TOTAL NET ASSETS 288,552.43 TOTAL LIABILITIES AND NET ASSETS 291,043.54 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:23AM PAGE:78 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME .00 17,824.13 20,000.00 2,175.87 89.1 TOTAL MISC LOCAL REVENUE .00 17,824.13 20,000.00 2,175.87 89.1 TRANSFERS IN: 57-4570-5510 TRANSFER FROM GENERAL FUND .00 .00 750,000.00 750,000.00 .0 TOTAL TRANSFERS IN .00 .00 750,000.00 750,000.00 .0 TOTAL CAPITAL IMP - FACILITIES REV .00 17,824.13 770,000.00 752,175.87 2.3 TOTAL FUND REVENUE .00 17,824.13 770,000.00 752,175.87 2.3 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 2,172.26 1,074,934.32 584,000.00 ( 490,934.32) 184.1 57-5570-6544 OTHER THAN BLDG 279.50 10,598.32 785,500.00 774,901.68 1.4 TOTAL CAPITALIZED EXPENDITURES 2,451.76 1,085,532.64 1,369,500.00 283,967.36 79.3 TOTAL CAPITAL IMP -FACILITIES 2,451.76 1,092,449.89 1,419,500.00 327,050.11 77.0 TOTAL FUND EXPENDITURES 2,451.76 1,092,449.89 1,419,500.00 327,050.11 77.0 NET REVENUE OVER EXPENDITURES ( 2,451.76) ( 1,074,625.76) ( 649,500.00) 425,125.76 ( 165.5) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:31AM PAGE:79 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 1,960,179.76 TOTAL CASH 1,960,179.76 INVESTMENTS: 65-10000120 INVESTMENT POOL 490,000.00 65-10000122 TIME DEPOSITS - SHORT TERM 826,388.77 TOTAL INVESTMENTS 1,316,388.77 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,296,417.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,296,417.66 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 92,152.97 65-20000210 RETAINAGE PAYABLE 29,120.15 TOTAL ACCOUNTS PAYABLE 121,273.12 DUE TO OTHER FUNDS: 65-20000245 DUE TO OTHER FUND 49,588.59 TOTAL DUE TO OTHER FUNDS 49,588.59 TOTAL CURRENT LIABILITIES 170,861.71 TOTAL LIABILITIES 170,861.71 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:32AM PAGE:80 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 1,960,582.14 BALANCE - CURRENT DATE 3,125,555.95 TOTAL NET ASSETS 3,125,555.95 TOTAL LIABILITIES AND NET ASSETS 3,296,417.66 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:32AM PAGE:81 PARK - REVE MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME .00 10,078.93 27,500.00 17,421.07 36.7 TOTAL MISC LOCAL REVENUE .00 10,078.93 27,500.00 17,421.07 36.7 TRANSFERS IN: 65-4650-5510 TRANSFER FROM GENERAL FUND .00 2,625,000.00 3,500,000.00 875,000.00 75.0 TOTAL TRANSFERS IN .00 2,625,000.00 3,500,000.00 875,000.00 75.0 TOTAL PARK - REVE .00 2,635,078.93 3,527,500.00 892,421.07 74.7 TOTAL FUND REVENUE .00 2,635,078.93 3,527,500.00 892,421.07 74.7 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY 2,864.90 54,207.60 525,000.00 470,792.40 10.3 65-5650-2158 MISC CONTRACTUAL SERVICES .00 .00 20,000.00 20,000.00 .0 TOTAL PROFESSIONAL SERVICES 2,864.90 54,207.60 545,000.00 490,792.40 10.0 CAPITALIZED EXPENDITURES: 65-5650-6544 OTHER THAN BLDG 83,861.90 620,289.19 2,867,000.00 2,246,710.81 21.6 TOTAL CAPITALIZED EXPENDITURES 83,861.90 620,289.19 2,867,000.00 2,246,710.81 21.6 TOTAL PARK IMPROVEMENTS 86,726.80 674,496.79 3,412,000.00 2,737,503.21 19.8 TOTAL FUND EXPENDITURES 86,726.80 674,496.79 3,412,000.00 2,737,503.21 19.8 NET REVENUE OVER EXPENDITURES ( 86,726.80) 1,960,582.14 115,500.00 ( 1,845,082.14) 1697.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:82 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 3,093.94 TOTAL CASH 3,093.94 INVESTMENTS: 90-10000120 INVESTMENT POOL 107,086.78 90-10000122 TIME DEPOSITS - SHORT TERM 60,780.06 TOTAL INVESTMENTS 167,866.84 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 44.97 TOTAL ACCOUNTS RECEIVABLE 44.97 TOTAL CURRENT ASSETS 171,005.75 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 171,005.75 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 2,587.65 BALANCE - CURRENT DATE 171,005.75 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:83 TOTAL NET ASSETS 171,005.75 TOTAL LIABILITIES AND NET ASSETS 171,005.75 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:84 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES 400.00 2,500.00 1,500.00 ( 1,000.00) 166.7 TOTAL REVENUE 400.00 2,500.00 1,500.00 ( 1,000.00) 166.7 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 87.65 2,240.75 1,000.00 ( 1,240.75) 224.1 TOTAL MISC LOCAL REVENUE 87.65 2,240.75 1,000.00 ( 1,240.75) 224.1 TOTAL PERPETUAL CARE - REVENUE 487.65 4,740.75 2,500.00 ( 2,240.75) 189.6 TOTAL FUND REVENUE 487.65 4,740.75 2,500.00 ( 2,240.75) 189.6 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND .00 2,153.10 1,000.00 ( 1,153.10) 215.3 TOTAL TRANSFERS TO OTHER FUNDS .00 2,153.10 1,000.00 ( 1,153.10) 215.3 TOTAL PERPETUAL CARE .00 2,153.10 1,000.00 ( 1,153.10) 215.3 TOTAL FUND EXPENDITURES .00 2,153.10 1,000.00 ( 1,153.10) 215.3 NET REVENUE OVER EXPENDITURES 487.65 2,587.65 1,500.00 ( 1,087.65) 172.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:85 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 APRIL 30, 2020 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:86 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 15,175.16 TOTAL CASH 15,175.16 TOTAL CURRENT ASSETS 15,175.16 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 15,175.16 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 3,752.82 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,488.13 TOTAL CURRENT LIABILITIES 26,488.13 TOTAL LIABILITIES 26,488.13 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 600.00 BALANCE - CURRENT DATE ( 11,312.97) TOTAL NET ASSETS ( 11,312.97) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:87 TOTAL LIABILITIES AND NET ASSETS 15,175.16 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:88 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND .00 600.00 800.00 200.00 75.0 TOTAL TRANSFERS IN .00 600.00 800.00 200.00 75.0 TOTAL HISTORIC CMSN - REVENU .00 600.00 800.00 200.00 75.0 TOTAL FUND REVENUE .00 600.00 800.00 200.00 75.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 .00 600.00 .00 ( 600.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:89 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 5,589.03 TOTAL CASH 5,589.03 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 86,194.33 TOTAL INVESTMENTS 86,194.33 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 72.79 TOTAL ACCOUNTS RECEIVABLE 72.79 TOTAL CURRENT ASSETS 91,856.15 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 91,856.15 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 294.95 TOTAL ACCOUNTS PAYABLE 294.95 UTILITY DEPOSITS PAYABLE: 96-20000229 UTILITY DEPOSITS 84,399.02 TOTAL UTILITY DEPOSITS PAYABLE 84,399.02 TOTAL CURRENT LIABILITIES 84,693.97 TOTAL LIABILITIES 84,693.97 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 APRIL 30, 2020 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:90 TOTAL NET ASSETS 7,162.18 TOTAL LIABILITIES AND NET ASSETS 91,856.15 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 10 MONTHS ENDING APRIL 30, 2020 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:91 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME .00 809.09 .00 ( 809.09) .0 TOTAL MISC LOCAL REVENUE .00 809.09 .00 ( 809.09) .0 TOTAL UTILITY DEPOSITS - REVENUE .00 809.09 .00 ( 809.09) .0 TOTAL FUND REVENUE .00 809.09 .00 ( 809.09) .0 UTILITY DEPOSIT TRANSFERS TO OTHER FUNDS: 96-5960-5531 TRANSFER TO WATER .00 809.09 1,500.00 690.91 53.9 TOTAL TRANSFERS TO OTHER FUNDS .00 809.09 1,500.00 690.91 53.9 TOTAL UTILITY DEPOSIT .00 809.09 1,500.00 690.91 53.9 TOTAL FUND EXPENDITURES .00 809.09 1,500.00 690.91 53.9 NET REVENUE OVER EXPENDITURES .00 .00 ( 1,500.00) ( 1,500.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET APRIL 30, 2020 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 83 % OF THE FISCAL YEAR HAS ELAPSED 05/28/2020 10:35AM PAGE:92 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_57a35fbd67

Full Text