Document Douglas_doc_7b0edb9e8e

CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2018 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 10:59AM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 16,325,650.02 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 69,807.41 01-10000112 PETTY CASH 200.00 01-10000113 CASH ON HAND 550.00 01-11750000 UTILITY CLEARING 104.00 TOTAL COMBINED CASH 16,396,311.43 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 16,396,311.43) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND 4,955,645.71 11 ALLOCATION TO IMPACT ASSISTANCE FUND 21,526.49 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 1,854.72 31 ALLOCATION TO WATER FUND 5,210,956.16 32 ALLOCATION TO SEWER FUND 2,124,451.42 33 ALLOCATION TO SANITATION FUND 451,401.63 34 ALLOCATION TO LANDFILL FUND 228,746.42 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 274,714.21 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 25,880.08 41 ALLOCATION TO ECONOMIC DEVELOPMENT 83,659.69 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE 143,122.95 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 15,975.39 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 2,811.66 54 ALLOCATION TO TRAIN CAR RESTORATION 57,677.77 55 ALLOCATION TO POOL IMPROVEMENTS FUND 183,663.86 56 ALLOCATION TO STREET IMPROVEMENT FUND 153,203.04 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 2,639,055.19 65 ALLOCATION TO CAPTL PROJ-PARK FUND ( 241,587.15) 90 ALLOCATION TO PERPETUAL CARE FUND 17,185.05 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 2.75 92 ALLOCATION TO HISTORIC CMSN FUND 14,081.88 96 ALLOCATION TO UTILITY DEPOSIT FUND 32,282.51 TOTAL ALLOCATIONS TO OTHER FUNDS 16,396,311.43 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 16,396,311.43) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 10:59AM PAGE:2 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 4,955,645.71 TOTAL CASH 4,955,645.71 INVESTMENTS: 10-10000120 INVESTMENT POOL 389,261.27 10-10000122 TIME DEPOSITS - SHORT TERM 15,103,570.39 TOTAL INVESTMENTS 15,492,831.66 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 35,465.28 10-10000131 ACCOUNTS RECEIVABLE - GENERAL 40,702.63 10-10000132 ACCOUNTS REC - PROPERTY TAX 488,100.06 10-10000133 ACCOUNTS CRT 10,952.65 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 1,109,955.51 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 751.99 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 10,972.03) 10-10000139 ACCRUED INTEREST RECEIVABLE 4,579.71 TOTAL ACCOUNTS RECEIVABLE 1,679,535.80 TOTAL CURRENT ASSETS 22,128,013.17 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 22,128,013.17 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 10-20000200 DEFERRED INFLOW 443,535.91 10-20000201 ALLOCATION FROM AP FUND 290,484.31 10-20000204 ACCOUNTS PAYABLE - EOY ( 20,785.81) 10-20000207 SALES TAX PAYABLE 18.00 10-20000215 WAGES PAYABLE 113,167.01 TOTAL ACCOUNTS PAYABLE 826,419.42 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 10:59AM PAGE:3 PAYROLL DEDUCTIONS PAYABLE: 10-20000223 FICA PAYABLE 2.64 10-20000224 DEFERRED COMPENSATION PAYABLE 49,653.08 10-20000227 WORKERS COMP INS PAYABLE 32,181.06 TOTAL PAYROLL DEDUCTIONS PAYABLE 81,836.78 UTILITY DEPOSITS PAYABLE: 10-20000229 UNCLAIMED PROPERTY 1,660.67 TOTAL UTILITY DEPOSITS PAYABLE 1,660.67 DUE TO OTHER FUNDS: 10-20000245 DUE TO OTHER FUNDS 35,440.10 TOTAL DUE TO OTHER FUNDS 35,440.10 TOTAL CURRENT LIABILITIES 945,356.97 TOTAL LIABILITIES 945,356.97 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 13,632,177.47 10-30000301 FUND BALANCE RESERVE 1,670,000.00 TOTAL CAPITAL ASSETS 15,302,177.47 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 5,880,478.73 BALANCE - CURRENT DATE 21,182,656.20 TOTAL NET ASSETS 21,182,656.20 TOTAL LIABILITIES AND NET ASSETS 22,128,013.17 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 10:59AM PAGE:4 GENERAL - REVENUE MISC LOCAL REVENUE: 10-4100-1107 OTHER 1,001.50 16,110.87 14,500.00 ( 1,610.87) 111.1 10-4100-1108 COPY FEES/VIN CHECKS 215.00 2,017.00 1,500.00 ( 517.00) 134.5 10-4100-1109 REIMBURSEMENTS 33,762.63 188,741.55 135,000.00 ( 53,741.55) 139.8 10-4100-1112 CONTRIBUTIONS .00 13,689.00 13,500.00 ( 189.00) 101.4 10-4100-1115 LEASES/RENT 870.00 4,120.00 4,000.00 ( 120.00) 103.0 10-4100-1120 FINES/FORFEITS 9,304.00 51,159.00 42,500.00 ( 8,659.00) 120.4 10-4100-1122 TECHNOLOGY SURCHARGE 2,565.00 12,165.00 9,000.00 ( 3,165.00) 135.2 10-4100-1130 CASH LONG/SHORT .06 ( 1.84) .00 1.84 .0 10-4100-1140 INTEREST INCOME 8,304.60 97,326.54 100,000.00 2,673.46 97.3 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 3,482.38 3,500.00 17.62 99.5 TOTAL MISC LOCAL REVENUE 56,022.79 388,809.50 323,500.00 ( 65,309.50) 120.2 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 125.00 22,795.16 20,000.00 ( 2,795.16) 114.0 TOTAL LIQUOR LICENSES 125.00 22,795.16 20,000.00 ( 2,795.16) 114.0 OTHER LICENSES/PERMITS: 10-4100-1230 LICENSES - TRANSIENT MERCHANT .00 200.00 100.00 ( 100.00) 200.0 TOTAL OTHER LICENSES/PERMITS .00 200.00 100.00 ( 100.00) 200.0 CONTRACTORS LICENSES: 10-4100-1241 LICENSES - CONTRACTORS 675.00 13,965.00 12,000.00 ( 1,965.00) 116.4 TOTAL CONTRACTORS LICENSES 675.00 13,965.00 12,000.00 ( 1,965.00) 116.4 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 1,927.27 19,124.08 16,000.00 ( 3,124.08) 119.5 TOTAL BUILDING PERMITS 1,927.27 19,124.08 16,000.00 ( 3,124.08) 119.5 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES .00 2,275.00 1,000.00 ( 1,275.00) 227.5 TOTAL ZONING/CONDITIONAL USE .00 2,275.00 1,000.00 ( 1,275.00) 227.5 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 54,683.53 451,487.87 400,000.00 ( 51,487.87) 112.9 10-4100-1321 PROPERTY TAX - PRIOR YEARS 242.32 710.95 250.00 ( 460.95) 284.4 10-4100-1322 PROPERTY TAX - AUTO 17,774.42 170,878.12 160,000.00 ( 10,878.12) 106.8 10-4100-1323 PROPERTY TAX - INTEREST 295.51 1,122.73 500.00 ( 622.73) 224.6 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 364.87) ( 2,366.21) ( 2,000.00) 366.21 ( 118.3) TOTAL PROPERTY TAXES 72,630.91 621,833.46 558,750.00 ( 63,083.46) 111.3 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 10:59AM PAGE:5 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 16,898.22 225,458.37 210,000.00 ( 15,458.37) 107.4 10-4100-1331 FRANCHISE FEES - CABLE TV .00 14,746.41 15,000.00 253.59 98.3 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 37,585.63 37,500.00 ( 85.63) 100.2 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 5,182.11 6,000.00 817.89 86.4 TOTAL FRANCHISE FEES 16,898.22 282,972.52 268,500.00 ( 14,472.52) 105.4 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 22,030.25 88,121.00 88,121.00 .00 100.0 10-4100-1421 MANAGEMENT FEES - WATER 66,091.00 264,364.00 264,364.00 .00 100.0 10-4100-1422 MANAGEMENT FEES - SEWER 39,340.00 157,360.00 157,360.00 .00 100.0 10-4100-1423 MANAGEMENT FEES - SANITATION 11,015.25 44,061.00 44,061.00 .00 100.0 TOTAL MANAGEMENT FEES 138,476.50 553,906.00 553,906.00 .00 100.0 WEED ABATEMENT: 10-4100-1430 WEED MOWING CHARGES 206.56 206.56 .00 ( 206.56) .0 10-4100-1431 PEST CONTROL .00 14,489.40 14,000.00 ( 489.40) 103.5 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 35,151.65 35,000.00 ( 151.65) 100.4 TOTAL WEED ABATEMENT 206.56 49,847.61 49,000.00 ( 847.61) 101.7 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 1,550.00 11,312.00 7,500.00 ( 3,812.00) 150.8 TOTAL BURIAL FEES 1,550.00 11,312.00 7,500.00 ( 3,812.00) 150.8 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 600.00 5,900.00 2,500.00 ( 3,400.00) 236.0 TOTAL LOT SALES 600.00 5,900.00 2,500.00 ( 3,400.00) 236.0 POOL: 10-4100-1650 POOL - USER FEES 11,390.00 22,200.05 30,000.00 7,799.95 74.0 10-4100-1651 POOL - CONCESSION 8,463.80 14,904.80 10,000.00 ( 4,904.80) 149.1 TOTAL POOL 19,853.80 37,104.85 40,000.00 2,895.15 92.8 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 278,902.00 275,000.00 ( 3,902.00) 101.4 10-4100-3111 SEVERENCE TAX - 2% 56,740.46 226,977.12 225,000.00 ( 1,977.12) 100.9 10-4100-3112 MINERAL ROYALTIES 73,562.51 311,285.41 315,000.00 3,714.59 98.8 TOTAL MINERAL EXTRACTION 130,302.97 817,164.53 815,000.00 ( 2,164.53) 100.3 SALES TAX: 10-4100-3241 SALES TAX - STATE 562,549.12 5,827,430.14 5,500,000.00 ( 327,430.14) 106.0 10-4100-3245 SALES TAX - LOCAL OPTION 458,976.59 4,767,486.16 4,550,000.00 ( 217,486.16) 104.8 TOTAL SALES TAX 1,021,525.71 10,594,916.30 10,050,000.00 ( 544,916.30) 105.4 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:6 GAS TAX: 10-4100-3250 LOTTERY .00 28,745.12 25,000.00 ( 3,745.12) 115.0 10-4100-3257 GAS TAX 10,126.15 239,129.80 225,000.00 ( 14,129.80) 106.3 10-4100-3258 SPECIAL FUELS 3,277.78 54,393.48 50,000.00 ( 4,393.48) 108.8 TOTAL GAS TAX 13,403.93 322,268.40 300,000.00 ( 22,268.40) 107.4 OTHER: 10-4100-3262 CIGARETTE TAX 3,665.59 47,913.26 45,000.00 ( 2,913.26) 106.5 TOTAL OTHER 3,665.59 47,913.26 45,000.00 ( 2,913.26) 106.5 TOTAL GENERAL - REVENUE 1,477,864.25 13,792,307.67 13,062,756.00 ( 729,551.67) 105.6 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 521.67 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL OPERATING TRANSFERS IN 521.67 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL OPERATING TRANSFERS - IN 521.67 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL FUND REVENUE 1,478,385.92 13,793,948.82 13,064,056.00 ( 729,892.82) 105.6 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 13.07 182.85 200.00 17.15 91.4 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 410.00 3,085.00 3,000.00 ( 85.00) 102.8 TOTAL EMPLOYEE BENEFITS 423.07 3,267.85 3,200.00 ( 67.85) 102.1 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT 858.00 5,605.59 6,500.00 894.41 86.2 10-5100-2115 PUBLISHING/ADVERTISING 2,010.75 26,345.58 30,000.00 3,654.42 87.8 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 500.00 500.00 .0 TOTAL PURCHASED SERVICES 2,868.75 31,951.17 37,000.00 5,048.83 86.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:7 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 14,778.13 90,466.19 92,000.00 1,533.81 98.3 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 622.43 3,936.55 4,500.00 563.45 87.5 10-5100-2133 UTILITY SERVICES - NATURAL GAS 80.46 2,775.35 3,500.00 724.65 79.3 10-5100-2134 TELECOMMUNICATIONS 317.04 9,049.76 9,250.00 200.24 97.8 10-5100-2141 EQUIPMENT - RENT .00 189.96 250.00 60.04 76.0 TOTAL PROPERTY SERVICES 15,798.06 106,417.81 109,500.00 3,082.19 97.2 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 3,494.70 55,992.05 60,000.00 4,007.95 93.3 10-5100-2152 ACCOUNTING/AUDITING .00 39,000.00 39,000.00 .00 100.0 10-5100-2153 ARCHITECHT/ENGINEERING/SURVEY .00 .00 5,000.00 5,000.00 .0 10-5100-2155 REPAIRS/MAINTENANCE .00 2,728.31 7,300.00 4,571.69 37.4 10-5100-2156 MAINTENANCE AGREEMENT 160.28 9,241.56 11,500.00 2,258.44 80.4 10-5100-2157 INSURANCE 579.00 117,908.00 105,000.00 ( 12,908.00) 112.3 10-5100-2158 MISC CONTRACTUAL SERVICES 4,155.00 43,983.61 63,000.00 19,016.39 69.8 10-5100-2166 COLLECTION FEES .00 198.20 200.00 1.80 99.1 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 298.84 500.00 201.16 59.8 TOTAL PROFESSIONAL SERVICES 8,388.98 269,350.57 291,500.00 22,149.43 92.4 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 2,077.89 13,108.34 13,500.00 391.66 97.1 10-5100-3210 OPERATING SUPPLIES 1,528.38 6,279.01 11,000.00 4,720.99 57.1 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 411.65 1,000.00 588.35 41.2 10-5100-3230 REFRESHMENT SUPPLIES 62.15 2,000.39 2,500.00 499.61 80.0 10-5100-3235 FUEL 12,201.18 108,655.81 165,000.00 56,344.19 65.9 TOTAL SUPPLIES 15,869.60 130,455.20 193,000.00 62,544.80 67.6 CLAIMS & CONTINGENCY: 10-5100-7601 CLAIMS AGAINST CITY .00 327.56 5,000.00 4,672.44 6.6 10-5100-7606 UNEMPLOYMENT CLAIMS .00 .00 6,000.00 6,000.00 .0 TOTAL CLAIMS & CONTINGENCY .00 327.56 11,000.00 10,672.44 3.0 TOTAL GENERAL GOVT - NON DEPARTMENTL 43,348.46 541,770.16 945,200.00 403,429.84 57.3 GENERAL GOVT - CITY COUNCIL PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 750.00 9,000.00 9,000.00 .00 100.0 TOTAL PERSONNEL SERVICES 750.00 9,000.00 9,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:8 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 57.37 688.44 689.00 .56 99.9 10-5101-1025 EMPLOYEE BENEFITS - COMP 45.75 574.65 684.00 109.35 84.0 TOTAL EMPLOYEE BENEFITS 103.12 1,263.09 1,373.00 109.91 92.0 PURCHASED SERVICES: 10-5101-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 7,791.37 8,000.00 208.63 97.4 10-5101-2122 TRAINING/DEVELOPMENT .00 6,350.00 7,500.00 1,150.00 84.7 10-5101-2123 MEALS/LODGING/TRAVEL 1,375.97 5,366.82 17,350.00 11,983.18 30.9 TOTAL PURCHASED SERVICES 1,375.97 19,508.19 32,850.00 13,341.81 59.4 SUPPLIES: 10-5101-3210 OPERATING SUPPLIES .00 .00 500.00 500.00 .0 TOTAL SUPPLIES .00 .00 500.00 500.00 .0 TOTAL GENERAL GOVT - CITY COUNCIL 2,229.09 29,771.28 43,723.00 13,951.72 68.1 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 33,862.61 313,637.86 354,167.00 40,529.14 88.6 10-5102-1002 SALARIES/WAGES - OVERTIME 161.63 317.79 1,500.00 1,182.21 21.2 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,216.66 1,346.00 129.34 90.4 10-5102-1006 SALARIES/WAGES - ALLOWANCES 164.52 3,389.52 6,300.00 2,910.48 53.8 TOTAL PERSONNEL SERVICES 34,188.76 318,561.83 363,313.00 44,751.17 87.7 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,691.94 25,428.11 29,620.00 4,191.89 85.9 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 7,871.67 93,839.59 128,774.00 34,934.41 72.9 10-5102-1025 EMPLOYEE BENEFITS - COMP 1,159.00 11,518.59 15,332.00 3,813.41 75.1 10-5102-1026 EMPLOYEE BENEFITS - COMP 999.80 14,160.88 23,872.00 9,711.12 59.3 10-5102-1029 EMPLOYEE BENEFITS - WY 5,654.84 44,015.80 40,693.00 ( 3,322.80) 108.2 TOTAL EMPLOYEE BENEFITS 18,377.25 188,962.97 238,291.00 49,328.03 79.3 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,854.00 2,720.00 866.00 68.2 10-5102-2122 TRAINING/DEVELOPMENT .00 1,000.00 2,800.00 1,800.00 35.7 10-5102-2123 MEALS/LODGING/TRAVEL 518.04 5,327.30 6,900.00 1,572.70 77.2 TOTAL PURCHASED SERVICES 518.04 8,181.30 12,420.00 4,238.70 65.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:9 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES 112.86 307.86 500.00 192.14 61.6 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 TOTAL SUPPLIES 112.86 307.86 1,500.00 1,192.14 20.5 TOTAL GENERAL GOVT - ADMIN SERVICES 53,196.91 516,013.96 615,524.00 99,510.04 83.8 GENERAL GOVT - IT PERSONNEL SERVICES: 10-5103-1001 SALARIES/WAGES - REGULAR 6,102.26 79,329.38 79,326.00 ( 3.38) 100.0 10-5103-1005 SALARIES/WAGES - LONGEVITY .00 365.38 366.00 .62 99.8 10-5103-1006 SALARIES/WAGES - ALLOWANCES 450.00 5,400.00 5,400.00 .00 100.0 10-5103-1007 SALARIES/WAGES - INCENTIVE .00 624.00 1,587.00 963.00 39.3 TOTAL PERSONNEL SERVICES 6,552.26 85,718.76 86,679.00 960.24 98.9 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL 490.17 6,546.55 6,510.00 ( 36.55) 100.6 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS 1,785.43 21,422.46 21,435.00 12.54 99.9 10-5103-1025 EMPLOYEE BENEFITS - COMP 222.12 3,060.90 3,591.00 530.10 85.2 10-5103-1029 EMPLOYEE BENEFITS - WY 1,014.20 13,184.60 13,184.00 ( .60) 100.0 TOTAL EMPLOYEE BENEFITS 3,511.92 44,214.51 44,720.00 505.49 98.9 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 246.00 659.00 1,200.00 541.00 54.9 TOTAL PURCHASED SERVICES 246.00 659.00 1,200.00 541.00 54.9 PROFESSIONAL SERVICES: 10-5103-2156 MAINTENANCE AGREEMENT .00 23,060.44 34,700.00 11,639.56 66.5 10-5103-2158 MISC CONTRACTUAL SERVICES 17,683.99 42,332.42 50,400.00 8,067.58 84.0 TOTAL PROFESSIONAL SERVICES 17,683.99 65,392.86 85,100.00 19,707.14 76.8 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 687.50 800.00 112.50 85.9 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 230.00 48,442.39 50,000.00 1,557.61 96.9 TOTAL SUPPLIES 230.00 49,129.89 50,800.00 1,670.11 96.7 TOTAL GENERAL GOVT - IT 28,224.17 245,115.02 268,499.00 23,383.98 91.3 GENERAL GOVT - MUNICIPAL COURT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:10 PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 1,000.00 12,000.00 13,000.00 1,000.00 92.3 TOTAL PERSONNEL SERVICES 1,000.00 12,000.00 13,000.00 1,000.00 92.3 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 76.50 918.00 995.00 77.00 92.3 10-5105-1025 EMPLOYEE BENEFITS - COMP 33.90 426.01 549.00 122.99 77.6 TOTAL EMPLOYEE BENEFITS 110.40 1,344.01 1,544.00 199.99 87.1 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 150.00 150.00 .00 100.0 10-5105-2123 MEALS/LODGING/TRAVEL .00 512.25 810.00 297.75 63.2 TOTAL PURCHASED SERVICES .00 662.25 960.00 297.75 69.0 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 1,703.30 13,943.07 14,400.00 456.93 96.8 10-5105-2162 COURT SURCHARGES 5,400.00 11,470.00 7,500.00 ( 3,970.00) 152.9 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 7,103.30 25,413.07 22,900.00 ( 2,513.07) 111.0 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES .00 .00 450.00 450.00 .0 10-5105-3233 UNIFORMS/CARE .00 .00 50.00 50.00 .0 TOTAL SUPPLIES .00 .00 500.00 500.00 .0 TOTAL GENERAL GOVT - MUNICIPAL COURT 8,213.70 39,419.33 38,904.00 ( 515.33) 101.3 GENERAL GOVT - PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 16,854.73 217,756.30 217,890.00 133.70 99.9 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 604.92 607.00 2.08 99.7 10-5106-1006 SALARIES/WAGES - ALLOWANCES 450.00 5,400.00 5,400.00 .00 100.0 TOTAL PERSONNEL SERVICES 17,304.73 223,761.22 223,897.00 135.78 99.9 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,354.78 17,518.27 17,569.00 50.73 99.7 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 3,194.73 38,332.61 38,357.00 24.39 99.9 10-5106-1025 EMPLOYEE BENEFITS - COMP 586.63 7,958.87 9,448.00 1,489.13 84.2 10-5106-1026 EMPLOYEE BENEFITS - COMP 448.50 5,762.43 5,762.00 ( .43) 100.0 10-5106-1029 EMPLOYEE BENEFITS - WY 2,352.78 30,428.86 30,451.00 22.14 99.9 TOTAL EMPLOYEE BENEFITS 7,937.42 100,001.04 101,587.00 1,585.96 98.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:11 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,147.00 1,350.00 203.00 85.0 10-5106-2122 TRAINING/DEVELOPMENT 95.00 2,744.53 4,310.00 1,565.47 63.7 10-5106-2123 MEALS/LODGING/TRAVEL 9.08 3,488.58 5,975.00 2,486.42 58.4 TOTAL PURCHASED SERVICES 104.08 7,380.11 11,635.00 4,254.89 63.4 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 83.40 999.58 1,000.00 .42 100.0 TOTAL PROPERTY SERVICES 83.40 999.58 1,000.00 .42 100.0 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY 1,135.50 7,653.00 10,000.00 2,347.00 76.5 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT 104.48 2,028.18 2,100.00 71.82 96.6 10-5106-2158 MISC CONTRACTUAL SERVICES 2,062.50 4,912.50 6,000.00 1,087.50 81.9 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 862.00 750.00 ( 112.00) 114.9 TOTAL PROFESSIONAL SERVICES 3,302.48 15,455.68 19,850.00 4,394.32 77.9 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 104.25 3,935.98 4,500.00 564.02 87.5 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5106-3235 FUEL 288.33 982.13 2,000.00 1,017.87 49.1 TOTAL SUPPLIES 392.58 4,918.11 7,500.00 2,581.89 65.6 TOTAL GENERAL GOVT - 29,124.69 352,515.74 365,469.00 12,953.26 96.5 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:12 GOVERNMENTAL ASSISTANCE: 10-5110-8701 COMM CITIZEN 6,250.00 75,000.00 75,000.00 .00 100.0 10-5110-8702 COMM CLUB/GEN 3,333.33 40,000.00 40,000.00 .00 100.0 10-5110-8703 COMM RCREATN .00 12,000.00 12,000.00 .00 100.0 10-5110-8705 COMM FOR LIF 750.00 9,000.00 9,000.00 .00 100.0 10-5110-8707 COMM DVL .00 4,583.37 5,000.00 416.63 91.7 10-5110-8709 COMM 833.37 10,000.00 10,000.00 .00 100.0 10-5110-8714 COMM ENTERPRIS 6,666.66 39,999.96 40,000.00 .04 100.0 10-5110-8717 COMM FAIR .00 3,000.00 3,000.00 .00 100.0 10-5110-8723 COMM HOCKEY .00 13,778.24 15,000.00 1,221.76 91.9 10-5110-8734 COMM PEAK 11,833.33 87,000.00 87,000.00 .00 100.0 10-5110-8742 COMM IND LIVING 2,000.00 2,000.00 2,000.00 .00 100.0 10-5110-8744 COMM 41,816.61 250,900.00 250,900.00 .00 100.0 10-5110-8746 COMM & GIRLS 833.26 10,000.00 10,000.00 .00 100.0 10-5110-8750 COMM ADVOC 166.66 1,999.28 2,000.00 .72 100.0 10-5110-8753 COMM SRVC BLK 1,000.00 4,000.00 4,000.00 .00 100.0 10-5110-8755 COMM HANDS 2,500.00 5,000.00 5,000.00 .00 100.0 10-5110-8759 COMM SRVC CENTER 583.33 6,416.63 7,000.00 583.37 91.7 10-5110-8760 COMM SRVC JUSTICE 39,670.67 98,406.45 100,000.00 1,593.55 98.4 TOTAL GOVERNMENTAL ASSISTANCE 118,237.22 673,083.93 676,900.00 3,816.07 99.4 TOTAL COMMUNITY SERVICE CONTRACTS 118,237.22 673,083.93 676,900.00 3,816.07 99.4 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 11,984.81 155,669.68 155,801.00 131.32 99.9 10-5201-1002 SALARIES/WAGES - OVERTIME .00 .00 100.00 100.00 .0 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 1,516.33 1,517.00 .67 100.0 10-5201-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 10-5201-1007 SALARIES/WAGES - INCENTIVE .00 1,123.20 1,123.00 ( .20) 100.0 TOTAL PERSONNEL SERVICES 12,059.81 159,209.21 159,441.00 231.79 99.9 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 967.78 12,766.66 12,785.00 18.34 99.9 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 3,564.95 42,779.43 42,786.00 6.57 100.0 10-5201-1025 EMPLOYEE BENEFITS - COMP 408.83 5,674.11 6,728.00 1,053.89 84.3 10-5201-1026 EMPLOYEE BENEFITS - COMP 590.96 7,675.28 7,682.00 6.72 99.9 10-5201-1029 EMPLOYEE BENEFITS - WY 2,037.44 26,463.88 26,503.00 39.12 99.9 TOTAL EMPLOYEE BENEFITS 7,569.96 95,359.36 96,484.00 1,124.64 98.8 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 500.00 500.00 .00 100.0 10-5201-2122 TRAINING/DEVELOPMENT .00 434.00 680.00 246.00 63.8 10-5201-2123 MEALS/LODGING/TRAVEL 84.65 360.23 775.00 414.77 46.5 TOTAL PURCHASED SERVICES 84.65 1,294.23 1,955.00 660.77 66.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:00AM PAGE:13 PROPERTY SERVICES: 10-5201-2134 TELECOMMUNICATIONS 40.01 466.09 495.00 28.91 94.2 TOTAL PROPERTY SERVICES 40.01 466.09 495.00 28.91 94.2 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5201-2158 MISC CONTRACTUAL SERVICES 500.00 2,770.00 3,000.00 230.00 92.3 10-5201-2161 INCARCERATION CONTRACT 637.50 1,522.50 2,500.00 977.50 60.9 TOTAL PROFESSIONAL SERVICES 1,137.50 4,292.50 6,500.00 2,207.50 66.0 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 61.97 1,523.70 2,000.00 476.30 76.2 10-5201-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 199.20 200.00 .80 99.6 10-5201-3233 UNIFORMS/CARE .00 160.94 500.00 339.06 32.2 10-5201-3235 FUEL 142.66 381.54 600.00 218.46 63.6 TOTAL SUPPLIES 204.63 2,265.38 3,300.00 1,034.62 68.7 TOTAL POLICE DEPT - ADMINISTRATION 21,096.56 262,886.77 268,175.00 5,288.23 98.0 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 67,960.33 797,646.58 822,372.00 24,725.42 97.0 10-5202-1002 SALARIES/WAGES - OVERTIME 3,664.64 46,007.84 53,000.00 6,992.16 86.8 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 1,713.89 1,718.00 4.11 99.8 10-5202-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 10-5202-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,837.00 1,837.00 .0 TOTAL PERSONNEL SERVICES 71,674.97 845,968.31 879,527.00 33,558.69 96.2 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 5,534.05 65,378.53 69,718.00 4,339.47 93.8 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 21,513.54 251,006.67 290,451.00 39,444.33 86.4 10-5202-1025 EMPLOYEE BENEFITS - COMP 2,429.73 30,120.01 38,094.00 7,973.99 79.1 10-5202-1026 EMPLOYEE BENEFITS - COMP 665.44 8,650.72 6,814.00 ( 1,836.72) 127.0 10-5202-1029 EMPLOYEE BENEFITS - WY 11,196.19 138,757.71 143,028.00 4,270.29 97.0 TOTAL EMPLOYEE BENEFITS 41,338.95 493,913.64 548,105.00 54,191.36 90.1 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 575.00 575.00 .00 100.0 10-5202-2122 TRAINING/DEVELOPMENT 623.00 6,617.00 8,185.00 1,568.00 80.8 10-5202-2123 MEALS/LODGING/TRAVEL 84.65 4,873.63 7,550.00 2,676.37 64.6 TOTAL PURCHASED SERVICES 707.65 12,065.63 16,310.00 4,244.37 74.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:14 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,320.61 15,189.48 14,600.00 ( 589.48) 104.0 TOTAL PROPERTY SERVICES 1,320.61 15,189.48 14,600.00 ( 589.48) 104.0 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE .00 8,568.40 13,139.00 4,570.60 65.2 10-5202-2156 MAINTENANCE AGREEMENT .00 10,514.00 16,843.00 6,329.00 62.4 10-5202-2158 MISC CONTRACTUAL SERVICES 733.00 24,894.42 19,900.00 ( 4,994.42) 125.1 TOTAL PROFESSIONAL SERVICES 733.00 43,976.82 49,882.00 5,905.18 88.2 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 76.96 300.00 223.04 25.7 10-5202-3210 OPERATING SUPPLIES 1,018.02 30,387.63 30,350.00 ( 37.63) 100.1 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 13,524.60 4,992.00 ( 8,532.60) 270.9 10-5202-3233 UNIFORMS/CARE 290.87 10,189.95 13,000.00 2,810.05 78.4 10-5202-3235 FUEL 6,363.34 24,054.52 23,000.00 ( 1,054.52) 104.6 TOTAL SUPPLIES 7,672.23 78,233.66 71,642.00 ( 6,591.66) 109.2 TOTAL POLICE DEPT - PATROL 123,447.41 1,489,347.54 1,580,066.00 90,718.46 94.3 POLICE DEPT - COMMUNICATIONS PERSONNEL SERVICES: 10-5203-1001 SALARIES/WAGES - REGULAR 9,907.63 314,446.21 342,458.00 28,011.79 91.8 10-5203-1002 SALARIES/WAGES - OVERTIME .00 19,837.07 24,000.00 4,162.93 82.7 10-5203-1005 SALARIES/WAGES - LONGEVITY .00 1,127.93 1,037.00 ( 90.93) 108.8 10-5203-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 10-5203-1007 SALARIES/WAGES - INCENTIVE .00 873.60 1,040.00 166.40 84.0 TOTAL PERSONNEL SERVICES 9,957.63 336,884.81 369,135.00 32,250.19 91.3 EMPLOYEE BENEFITS: 10-5203-1021 EMPLOYEE BENEFITS - SCL 761.77 25,938.31 29,599.00 3,660.69 87.6 10-5203-1023 EMPLOYEE BENEFITS - HEALTH INS 3,527.25 99,745.42 108,636.00 8,890.58 91.8 10-5203-1025 EMPLOYEE BENEFITS - COMP 337.57 12,248.55 16,663.00 4,414.45 73.5 10-5203-1026 EMPLOYEE BENEFITS - COMP .00 2,157.26 1,779.00 ( 378.26) 121.3 10-5203-1029 EMPLOYEE BENEFITS - WY 1,646.64 53,125.95 58,880.00 5,754.05 90.2 TOTAL EMPLOYEE BENEFITS 6,273.23 193,215.49 215,557.00 22,341.51 89.6 PURCHASED SERVICES: 10-5203-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 591.00 812.00 221.00 72.8 10-5203-2122 TRAINING/DEVELOPMENT .00 975.00 2,000.00 1,025.00 48.8 10-5203-2123 MEALS/LODGING/TRAVEL .00 .00 1,000.00 1,000.00 .0 TOTAL PURCHASED SERVICES .00 1,566.00 3,812.00 2,246.00 41.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:15 PROPERTY SERVICES: 10-5203-2131 UTILITY SERVICES - ELECTRICITY 263.84 2,159.27 2,500.00 340.73 86.4 10-5203-2134 TELECOMMUNICATIONS 544.73 7,422.70 8,065.00 642.30 92.0 TOTAL PROPERTY SERVICES 808.57 9,581.97 10,565.00 983.03 90.7 PROFESSIONAL SERVICES: 10-5203-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5203-2156 MAINTENANCE AGREEMENT 41.16 569.13 1,000.00 430.87 56.9 10-5203-2158 MISC CONTRACTUAL SERVICES .00 .00 500.00 500.00 .0 TOTAL PROFESSIONAL SERVICES 41.16 569.13 2,500.00 1,930.87 22.8 SUPPLIES: 10-5203-3210 OPERATING SUPPLIES .00 28.25 500.00 471.75 5.7 10-5203-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 500.00 500.00 .0 10-5203-3233 UNIFORMS/CARE .00 275.00 450.00 175.00 61.1 TOTAL SUPPLIES .00 303.25 1,450.00 1,146.75 20.9 TOTAL POLICE DEPT - COMMUNICATIONS 17,080.59 542,120.65 603,019.00 60,898.35 89.9 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 10,473.55 135,367.42 135,492.00 124.58 99.9 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,114.36 1,116.00 1.64 99.9 10-5301-1006 SALARIES/WAGES - ALLOWANCES 450.00 5,400.00 5,400.00 .00 100.0 TOTAL PERSONNEL SERVICES 10,923.55 141,881.78 142,008.00 126.22 99.9 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 833.79 10,831.70 10,864.00 32.30 99.7 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 2,502.65 30,028.92 30,115.00 86.08 99.7 10-5301-1025 EMPLOYEE BENEFITS - COMP 370.31 5,045.19 5,993.00 947.81 84.2 10-5301-1029 EMPLOYEE BENEFITS - WY 1,740.70 22,498.07 22,519.00 20.93 99.9 TOTAL EMPLOYEE BENEFITS 5,447.45 68,403.88 69,491.00 1,087.12 98.4 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 206.00 337.00 435.00 98.00 77.5 10-5301-2122 TRAINING/DEVELOPMENT .00 919.00 1,155.00 236.00 79.6 10-5301-2123 MEALS/LODGING/TRAVEL .00 170.00 700.00 530.00 24.3 TOTAL PURCHASED SERVICES 206.00 1,426.00 2,290.00 864.00 62.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:16 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 1,266.20 9,330.52 10,000.00 669.48 93.3 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 1,166.50 5,486.84 4,500.00 ( 986.84) 121.9 10-5301-2133 UTILITY SERVICES - NATURAL GAS 293.59 9,456.06 9,700.00 243.94 97.5 10-5301-2134 TELECOMMUNICATIONS 84.59 509.31 500.00 ( 9.31) 101.9 TOTAL PROPERTY SERVICES 2,810.88 24,782.73 24,700.00 ( 82.73) 100.3 PROFESSIONAL SERVICES: 10-5301-2155 REPAIRS/MAINTENANCE 1,500.00 2,587.02 1,100.00 ( 1,487.02) 235.2 10-5301-2156 MAINTENANCE AGREEMENT 39.83 2,676.48 3,000.00 323.52 89.2 10-5301-2158 MISC CONTRACTUAL SERVICES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 1,539.83 5,263.50 4,400.00 ( 863.50) 119.6 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 144.22 2,063.40 2,000.00 ( 63.40) 103.2 10-5301-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,975.99 3,000.00 24.01 99.2 10-5301-3230 REFRESHMENT SUPPLIES .00 704.92 700.00 ( 4.92) 100.7 TOTAL SUPPLIES 144.22 5,744.31 5,700.00 ( 44.31) 100.8 TOTAL PUBLIC WORKS - ADMINISTRATION 21,071.93 247,502.20 248,589.00 1,086.80 99.6 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 17,147.04 222,812.06 223,122.00 309.94 99.9 10-5302-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 2,095.54 2,097.00 1.46 99.9 10-5302-1007 SALARIES/WAGES - INCENTIVE .00 3,411.20 2,999.00 ( 412.20) 113.7 TOTAL PERSONNEL SERVICES 17,147.04 228,318.80 228,718.00 399.20 99.8 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,360.84 18,110.65 18,098.00 ( 12.65) 100.1 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 6,025.88 72,310.14 72,338.00 27.86 100.0 10-5302-1025 EMPLOYEE BENEFITS - COMP 581.28 8,128.33 9,637.00 1,508.67 84.4 10-5302-1026 EMPLOYEE BENEFITS - COMP 630.84 8,200.92 7,073.00 ( 1,127.92) 116.0 10-5302-1029 EMPLOYEE BENEFITS - WY 2,849.82 37,031.14 37,166.00 134.86 99.6 TOTAL EMPLOYEE BENEFITS 11,448.66 143,781.18 144,312.00 530.82 99.6 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 3,020.00 3,020.00 .00 100.0 10-5302-2122 TRAINING/DEVELOPMENT .00 .00 200.00 200.00 .0 TOTAL PURCHASED SERVICES .00 3,020.00 3,220.00 200.00 93.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:17 PROPERTY SERVICES: 10-5302-2141 EQUIPMENT RENT .00 .00 1,100.00 1,100.00 .0 TOTAL PROPERTY SERVICES .00 .00 1,100.00 1,100.00 .0 PROFESSIONAL SERVICES: 10-5302-2155 REPAIRS/MAINTENANCE .00 344.00 600.00 256.00 57.3 TOTAL PROFESSIONAL SERVICES .00 344.00 600.00 256.00 57.3 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 2,415.64 13,287.44 13,500.00 212.56 98.4 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 359.40 1,717.72 2,127.00 409.28 80.8 10-5302-3235 FUEL 381.48 1,496.21 2,000.00 503.79 74.8 10-5302-3237 OIL/LUBE/FLUIDS 3,145.27 10,351.34 12,500.00 2,148.66 82.8 TOTAL SUPPLIES 6,301.79 26,852.71 30,127.00 3,274.29 89.1 TOTAL PUBLIC WORKS - SHOP 34,897.49 402,316.69 408,077.00 5,760.31 98.6 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 18,280.27 234,075.38 210,840.00 ( 23,235.38) 111.0 10-5304-1002 SALARIES/WAGES - OVERTIME 304.28 825.50 400.00 ( 425.50) 206.4 10-5304-1004 SALARIES/WAGES - TEMPORARY 6,736.60 29,684.54 47,712.00 18,027.46 62.2 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 650.89 652.00 1.11 99.8 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 25,346.15 265,536.31 259,904.00 ( 5,632.31) 102.2 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 1,941.30 20,343.56 19,920.00 ( 423.56) 102.1 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 9,748.67 116,889.95 106,352.00 ( 10,537.95) 109.9 10-5304-1025 EMPLOYEE BENEFITS - COMP 859.23 9,535.47 10,988.00 1,452.53 86.8 10-5304-1029 EMPLOYEE BENEFITS - WY 3,088.74 39,040.19 35,108.00 ( 3,932.19) 111.2 TOTAL EMPLOYEE BENEFITS 15,637.94 185,809.17 172,368.00 ( 13,441.17) 107.8 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 655.00 550.00 ( 105.00) 119.1 10-5304-2122 TRAINING/DEVELOPMENT .00 850.00 1,610.00 760.00 52.8 10-5304-2123 MEALS/LODGING/TRAVEL .00 1,307.58 1,970.00 662.42 66.4 TOTAL PURCHASED SERVICES .00 2,812.58 4,130.00 1,317.42 68.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:18 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 2,249.29 15,991.56 15,000.00 ( 991.56) 106.6 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 15,647.51 82,773.63 75,000.00 ( 7,773.63) 110.4 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 17,896.80 98,765.19 91,000.00 ( 7,765.19) 108.5 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE .00 1,204.83 5,000.00 3,795.17 24.1 10-5304-2156 MAINTENANCE AGREEMENT .00 470.00 1,250.00 780.00 37.6 10-5304-2158 MISC CONTRACTUAL SERVICES 1,000.00 21,580.00 25,000.00 3,420.00 86.3 TOTAL PROFESSIONAL SERVICES 1,000.00 23,254.83 31,250.00 7,995.17 74.4 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 2,111.60 38,710.08 40,000.00 1,289.92 96.8 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 353.68 1,000.00 646.32 35.4 10-5304-3235 FUEL 2,835.76 6,943.10 10,000.00 3,056.90 69.4 TOTAL SUPPLIES 4,947.36 46,006.86 51,000.00 4,993.14 90.2 TOTAL PUBLIC WORKS - PARKS 64,828.25 622,184.94 609,652.00 ( 12,532.94) 102.1 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 18,989.04 241,604.70 241,672.00 67.30 100.0 10-5305-1002 SALARIES/WAGES - OVERTIME .00 .00 4,000.00 4,000.00 .0 10-5305-1004 SALARIES/WAGES - TEMPORARY 1,363.20 6,786.55 11,928.00 5,141.45 56.9 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 873.70 875.00 1.30 99.9 10-5305-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 20,377.24 249,564.95 258,775.00 9,210.05 96.4 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,565.61 19,179.04 18,971.00 ( 208.04) 101.1 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 6,912.96 83,012.27 104,046.00 21,033.73 79.8 10-5305-1025 EMPLOYEE BENEFITS - COMP 690.80 8,898.35 10,937.00 2,038.65 81.4 10-5305-1026 EMPLOYEE BENEFITS - COMP 58.12 744.78 745.00 .22 100.0 10-5305-1029 EMPLOYEE BENEFITS - WY 3,155.98 40,154.77 40,831.00 676.23 98.3 TOTAL EMPLOYEE BENEFITS 12,383.47 151,989.21 175,530.00 23,540.79 86.6 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT .00 510.00 655.00 145.00 77.9 TOTAL PURCHASED SERVICES .00 510.00 655.00 145.00 77.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:19 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 537.60 10,148.42 10,000.00 ( 148.42) 101.5 10-5305-2158 MISC CONTRACTUAL SERVICES 12,066.00 24,611.56 34,700.00 10,088.44 70.9 TOTAL PROFESSIONAL SERVICES 12,603.60 34,759.98 44,700.00 9,940.02 77.8 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 6,475.77 79,564.46 70,000.00 ( 9,564.46) 113.7 10-5305-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 343.97 642.35 800.00 157.65 80.3 10-5305-3235 FUEL 6,135.00 22,293.26 23,500.00 1,206.74 94.9 TOTAL SUPPLIES 12,954.74 102,500.07 94,300.00 ( 8,200.07) 108.7 TOTAL PUBLIC WORKS - STREETS/ALLEYS 58,319.05 539,324.21 573,960.00 34,635.79 94.0 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 6,627.28 83,874.63 106,871.00 22,996.37 78.5 10-5306-1002 SALARIES/WAGES - OVERTIME 677.27 1,458.86 1,500.00 41.14 97.3 10-5306-1004 SALARIES/WAGES - TEMPORARY 2,598.00 9,504.20 11,928.00 2,423.80 79.7 10-5306-1005 SALARIES/WAGES - LONGEVITY .00 603.61 604.00 .39 99.9 10-5306-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 9,927.55 95,741.30 121,203.00 25,461.70 79.0 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 759.57 7,327.92 9,302.00 1,974.08 78.8 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 2,666.18 31,985.50 42,640.00 10,654.50 75.0 10-5306-1025 EMPLOYEE BENEFITS - COMP 336.52 3,431.02 5,131.00 1,699.98 66.9 10-5306-1029 EMPLOYEE BENEFITS - WY 1,214.01 14,182.46 18,011.00 3,828.54 78.7 TOTAL EMPLOYEE BENEFITS 4,976.28 56,926.90 75,084.00 18,157.10 75.8 PURCHASED SERVICES: 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 100.00 100.00 .00 100.0 10-5306-2122 TRAINING/DEVELOPMENT .00 280.00 280.00 .00 100.0 TOTAL PURCHASED SERVICES .00 380.00 380.00 .00 100.0 PROPERTY SERVICES: 10-5306-2131 UTILITY SERVICES - ELECTRICITY 252.16 2,620.76 3,000.00 379.24 87.4 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 5,185.76 37,710.65 45,000.00 7,289.35 83.8 10-5306-2133 UTILITY SERVICES - NATURAL GAS 38.08 1,088.23 1,500.00 411.77 72.6 10-5306-2134 TELECOMMUNICATIONS 97.24 1,097.66 1,150.00 52.34 95.5 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 5,573.24 42,517.30 50,850.00 8,332.70 83.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:20 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 10-5306-2156 MAINTENANCE AGREEMENT .00 470.00 500.00 30.00 94.0 10-5306-2158 MISC CONTRACTUAL SERVICES .00 7,000.00 7,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 7,470.00 9,000.00 1,530.00 83.0 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 1,481.82 4,877.06 10,000.00 5,122.94 48.8 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 709.26 1,000.00 290.74 70.9 10-5306-3235 FUEL 966.90 1,976.89 2,500.00 523.11 79.1 TOTAL SUPPLIES 2,448.72 7,563.21 13,500.00 5,936.79 56.0 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND .00 .00 1,000.00 1,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 1,000.00 1,000.00 .0 TOTAL PUBLIC WORKS - CEMETERY 22,925.79 210,598.71 271,017.00 60,418.29 77.7 PUBLIC WORKS - SWIM POOL PERSONNEL SERVICES: 10-5307-1004 SALARIES/WAGES - TEMPORARY 15,612.95 57,894.93 75,000.00 17,105.07 77.2 TOTAL PERSONNEL SERVICES 15,612.95 57,894.93 75,000.00 17,105.07 77.2 EMPLOYEE BENEFITS: 10-5307-1021 EMPLOYEE BENEFITS - SCL 1,194.37 4,429.00 5,738.00 1,309.00 77.2 10-5307-1025 EMPLOYEE BENEFITS - COMP 529.26 2,227.67 3,165.00 937.33 70.4 TOTAL EMPLOYEE BENEFITS 1,723.63 6,656.67 8,903.00 2,246.33 74.8 PURCHASED SERVICES: 10-5307-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 25.00 500.00 475.00 5.0 10-5307-2122 TRAINING/DEVELOPMENT .00 75.00 5,100.00 5,025.00 1.5 TOTAL PURCHASED SERVICES .00 100.00 5,600.00 5,500.00 1.8 PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 1,630.59 7,727.54 7,000.00 ( 727.54) 110.4 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 5,620.55 10,659.66 7,500.00 ( 3,159.66) 142.1 10-5307-2133 UTILITY SERVICES - NATURAL GAS 4,003.52 11,322.94 9,000.00 ( 2,322.94) 125.8 10-5307-2134 TELECOMMUNICATIONS 108.79 946.36 1,500.00 553.64 63.1 TOTAL PROPERTY SERVICES 11,363.45 30,656.50 25,000.00 ( 5,656.50) 122.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:21 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE 525.00 3,881.29 2,500.00 ( 1,381.29) 155.3 10-5307-2158 MISC CONTRACTUAL SERVICES .00 9,428.42 9,500.00 71.58 99.3 TOTAL PROFESSIONAL SERVICES 525.00 13,309.71 12,000.00 ( 1,309.71) 110.9 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 5,039.36 20,760.47 24,500.00 3,739.53 84.7 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 299.99 2,500.00 2,200.01 12.0 TOTAL SUPPLIES 5,039.36 21,060.46 27,000.00 5,939.54 78.0 TOTAL PUBLIC WORKS - SWIM POOL 34,264.39 129,678.27 153,503.00 23,824.73 84.5 OPERATING TRANSFERS - OUT OPERATING TRANSFERS: 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ 44,147.26 168,420.69 166,980.00 ( 1,440.69) 100.9 10-5998-4341 TRANSFER TO ECONOMIC DEVELOPME 25,000.00 100,000.00 100,000.00 .00 100.0 10-5998-4350 TRANSFER TO FIRE EQUIPMENT 12,500.00 50,000.00 50,000.00 .00 100.0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT 168,750.00 675,000.00 675,000.00 .00 100.0 10-5998-4357 TRANSFER TO PUBLIC FACILITIES 18,750.00 75,000.00 75,000.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 350.00 1,400.00 1,400.00 .00 100.0 TOTAL OPERATING TRANSFERS 269,497.26 1,069,820.69 1,068,380.00 ( 1,440.69) 100.1 TOTAL OPERATING TRANSFERS - OUT 269,497.26 1,069,820.69 1,068,380.00 ( 1,440.69) 100.1 TOTAL FUND EXPENDITURES 950,002.96 7,913,470.09 8,738,657.00 825,186.91 90.6 NET REVENUE OVER EXPENDITURES 528,382.96 5,880,478.73 4,325,399.00 ( 1,555,079.73) 136.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:01AM PAGE:22 ASSETS CURRENT ASSETS: CASH: 11-10000116 CASH ALLOC FR COMBINED FUND 21,526.49 TOTAL CASH 21,526.49 TOTAL CURRENT ASSETS 21,526.49 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 21,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 TOTAL NET ASSETS 21,526.49 TOTAL LIABILITIES AND NET ASSETS 21,526.49 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:13AM PAGE:23 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 1,854.72 TOTAL CASH 1,854.72 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 23,717.63 TOTAL ACCOUNTS RECEIVABLE 23,717.63 TOTAL CURRENT ASSETS 25,572.35 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 25,572.35 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 2,122.04 13-20000215 WAGES PAYABLE - CLEARING 5,240.45 TOTAL ACCOUNTS PAYABLE 7,362.49 TOTAL CURRENT LIABILITIES 7,362.49 TOTAL LIABILITIES 7,362.49 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 27,301.18 TOTAL CAPITAL ASSETS 27,301.18 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:13AM PAGE:24 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 9,091.32) BALANCE - CURRENT DATE 18,209.86 TOTAL NET ASSETS 18,209.86 TOTAL LIABILITIES AND NET ASSETS 25,572.35 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:14AM PAGE:25 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 2,907.10 13,257.36 16,936.00 3,678.64 78.3 TOTAL FEDERAL REVENUE SOURCES 2,907.10 13,257.36 16,936.00 3,678.64 78.3 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 2,907.10 13,257.36 16,936.00 3,678.64 78.3 SRO PROGRAM - REVENUE MISC LOCAL REVENUE: 13-4830-1001 REIMBURSEMENT-CCSD#1-SRO 15,085.50 60,342.00 60,342.00 .00 100.0 TOTAL MISC LOCAL REVENUE 15,085.50 60,342.00 60,342.00 .00 100.0 TRANSFERS IN: 13-4830-5510 TRANSFER FROM GENERAL FUND 8,174.94 53,431.44 60,342.00 6,910.56 88.6 TOTAL TRANSFERS IN 8,174.94 53,431.44 60,342.00 6,910.56 88.6 TOTAL SRO PROGRAM - REVENUE 23,260.44 113,773.44 120,684.00 6,910.56 94.3 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 3,794.51 10,660.25 6,975.00 ( 3,685.25) 152.8 TOTAL STATE REVENUE 3,794.51 10,660.25 6,975.00 ( 3,685.25) 152.8 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE 3,794.51 10,660.25 6,975.00 ( 3,685.25) 152.8 SRO - GRANT - REVENUE TRANSFERS IN: 13-4834-5510 TRANSFER FROM GENERAL FUND 34,770.32 109,020.32 99,000.00 ( 10,020.32) 110.1 TOTAL TRANSFERS IN 34,770.32 109,020.32 99,000.00 ( 10,020.32) 110.1 TOTAL SRO - GRANT - REVENUE 34,770.32 109,020.32 99,000.00 ( 10,020.32) 110.1 JUVENILE DIVERSION OFFICER-REV ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:14AM PAGE:26 TRANSFERS IN: 13-4835-5510 TRANSFER FROM GENERAL FUND 1,238.53 1,238.53 5,475.00 4,236.47 22.6 TOTAL TRANSFERS IN 1,238.53 1,238.53 5,475.00 4,236.47 22.6 TOTAL JUVENILE DIVERSION OFFICER-REV 1,238.53 1,238.53 5,475.00 4,236.47 22.6 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 2,420.00 2,162.00 ( 258.00) 111.9 TOTAL FEDERAL REVENUE SOURCES .00 2,420.00 2,162.00 ( 258.00) 111.9 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND ( 36.53) 4,730.40 2,163.00 ( 2,567.40) 218.7 TOTAL TRANSFERS IN ( 36.53) 4,730.40 2,163.00 ( 2,567.40) 218.7 TOTAL BULLET PROOF VEST - REVENUE ( 36.53) 7,150.40 4,325.00 ( 2,825.40) 165.3 TOTAL FUND REVENUE 65,934.37 255,100.30 253,395.00 ( 1,705.30) 100.7 ASSET SEIZURE SUPPLIES: 13-5130-3210 OPERATING SUPPLIES .00 .00 3,012.00 3,012.00 .0 TOTAL SUPPLIES .00 .00 3,012.00 3,012.00 .0 TOTAL ASSET SEIZURE .00 .00 3,012.00 3,012.00 .0 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR 1,431.37 9,849.99 13,180.00 3,330.01 74.7 TOTAL PERSONNEL SERVICES 1,431.37 9,849.99 13,180.00 3,330.01 74.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:16AM PAGE:27 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL 109.44 753.43 1,008.00 254.57 74.8 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS 526.53 3,338.38 3,000.00 ( 338.38) 111.3 13-5821-1025 EMPLOYEE BENEFITS - COMP 48.54 360.53 557.00 196.47 64.7 13-5821-1029 EMPLOYEE BENEFITS - WY 237.98 1,637.13 2,191.00 553.87 74.7 TOTAL EMPLOYEE BENEFITS 922.49 6,089.47 6,756.00 666.53 90.1 SUPPLIES: 13-5821-3220 EQUIPMENT/TOOLS-NON CAPITALIZE ( 939.00) .00 1,000.00 1,000.00 .0 TOTAL SUPPLIES ( 939.00) .00 1,000.00 1,000.00 .0 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE 1,414.86 15,939.46 20,936.00 4,996.54 76.1 SCHOOL RESOURCE OFFICER PERSONNEL SERVICES: 13-5830-1001 SALARIES/WAGES - REGULAR 5,581.10 72,554.30 72,639.00 84.70 99.9 13-5830-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 13-5830-1005 SALARIES/WAGES - LONGEVITY .00 276.59 277.00 .41 99.9 13-5830-1007 SALARIES/WAGES -INCENTIVE .00 .00 1,453.00 1,453.00 .0 TOTAL PERSONNEL SERVICES 5,581.10 72,830.89 74,869.00 2,038.11 97.3 EMPLOYEE BENEFITS: 13-5830-1021 EMPLOYEE BENEFITS - SCL 435.48 5,682.40 5,862.00 179.60 96.9 13-5830-1023 EMPLOYEE BENEFITS - HEALTH INS 1,757.00 19,327.00 21,084.00 1,757.00 91.7 13-5830-1025 EMPLOYEE BENEFITS - COMP 189.20 2,591.37 3,098.00 506.63 83.7 13-5830-1026 EMPLOYEE BENEFITS - COMP 111.62 1,451.06 1,453.00 1.94 99.9 13-5830-1029 EMPLOYEE BENEFITS - WY 927.58 12,058.54 12,073.00 14.46 99.9 TOTAL EMPLOYEE BENEFITS 3,420.88 41,110.37 43,570.00 2,459.63 94.4 PURCHASED SERVICES: 13-5830-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 50.00 50.00 .00 100.0 13-5830-2122 TRAINING/DEVELOPMENT .00 200.00 500.00 300.00 40.0 13-5830-2123 MEALS/LODGING/TRAVEL 225.27 225.27 500.00 274.73 45.1 TOTAL PURCHASED SERVICES 225.27 475.27 1,050.00 574.73 45.3 PROPERTY SERVICES: 13-5830-2134 TELECOMMUNICATIONS 131.48 1,126.44 495.00 ( 631.44) 227.6 TOTAL PROPERTY SERVICES 131.48 1,126.44 495.00 ( 631.44) 227.6 SUPPLIES: 13-5830-3233 UNIFORMS/CARE .00 678.64 700.00 21.36 97.0 TOTAL SUPPLIES .00 678.64 700.00 21.36 97.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:16AM PAGE:28 TOTAL SCHOOL RESOURCE OFFICER 9,358.73 116,221.61 120,684.00 4,462.39 96.3 OJJDP-UNDERAGE ENFORCEMENT PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 518.28 2,342.29 5,150.00 2,807.71 45.5 TOTAL PERSONNEL SERVICES 518.28 2,342.29 5,150.00 2,807.71 45.5 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 39.67 179.28 325.00 145.72 55.2 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS .00 454.43 650.00 195.57 69.9 13-5831-1025 EMPLOYEE BENEFITS - COMP 17.57 84.43 215.00 130.57 39.3 13-5831-1029 EMPLOYEE BENEFITS - WY 86.16 389.45 500.00 110.55 77.9 TOTAL EMPLOYEE BENEFITS 143.40 1,107.59 1,690.00 582.41 65.5 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES 70.00 820.00 1,500.00 680.00 54.7 TOTAL PROFESSIONAL SERVICES 70.00 820.00 1,500.00 680.00 54.7 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 2,384.00 3,091.55 3,000.00 ( 91.55) 103.1 TOTAL SUPPLIES 2,384.00 3,091.55 3,000.00 ( 91.55) 103.1 TOTAL OJJDP-UNDERAGE ENFORCEMENT 3,115.68 7,361.43 11,340.00 3,978.57 64.9 SRO - GRANT PERSONNEL SERVICES: 13-5834-1001 SALARIES/WAGES - REGULAR 5,534.94 71,954.22 72,629.00 674.78 99.1 13-5834-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 13-5834-1005 SALARIES/WAGES - LONGEVITY .00 598.56 599.00 .44 99.9 TOTAL PERSONNEL SERVICES 5,534.94 72,552.78 73,728.00 1,175.22 98.4 EMPLOYEE BENEFITS: 13-5834-1021 EMPLOYEE BENEFITS - SCL 436.12 5,660.24 5,862.00 201.76 96.6 13-5834-1023 EMPLOYEE BENEFITS - HEALTH INS 1,757.00 22,841.00 21,100.00 ( 1,741.00) 108.3 13-5834-1025 EMPLOYEE BENEFITS - COMP 187.64 2,581.78 3,111.00 529.22 83.0 13-5834-1026 EMPLOYEE BENEFITS - COMP 166.05 1,439.10 .00 ( 1,439.10) .0 13-5834-1029 EMPLOYEE BENEFITS - WY 919.90 11,958.70 12,071.00 112.30 99.1 TOTAL EMPLOYEE BENEFITS 3,466.71 44,480.82 42,144.00 ( 2,336.82) 105.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:16AM PAGE:29 PURCHASED SERVICES: 13-5834-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 40.00 65.00 25.00 61.5 13-5834-2122 TRAINING/DEVELOPMENT .00 200.00 500.00 300.00 40.0 13-5834-2123 MEALS/LODGING/TRAVEL 225.29 225.29 500.00 274.71 45.1 TOTAL PURCHASED SERVICES 225.29 465.29 1,065.00 599.71 43.7 PROPERTY SERVICES: 13-5834-2134 TELECOMMUNICATIONS .00 424.42 1,099.00 674.58 38.6 TOTAL PROPERTY SERVICES .00 424.42 1,099.00 674.58 38.6 SUPPLIES: 13-5834-3233 UNIFORMS/CARE .00 323.95 325.00 1.05 99.7 TOTAL SUPPLIES .00 323.95 325.00 1.05 99.7 TOTAL SRO - GRANT 9,226.94 118,247.26 118,361.00 113.74 99.9 JUVENILE DIVERSION OFFICER PERSONNEL SERVICES: 13-5835-1001 SALARIES/WAGES - REGULAR 375.00 1,290.00 1,600.00 310.00 80.6 TOTAL PERSONNEL SERVICES 375.00 1,290.00 1,600.00 310.00 80.6 EMPLOYEE BENEFITS: 13-5835-1021 EMPLOYEE BENEFITS - SCL 28.69 98.75 125.00 26.25 79.0 13-5835-1025 EMPLOYEE BENEFITS - COMP 12.71 266.18 300.00 33.82 88.7 TOTAL EMPLOYEE BENEFITS 41.40 364.93 425.00 60.07 85.9 PROFESSIONAL SERVICES: 13-5835-2158 MISC CONTRACTUAL SERVICES .00 .00 250.00 250.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 250.00 250.00 .0 SUPPLIES: 13-5835-3210 OPERATING SUPPLIES .00 .00 250.00 250.00 .0 TOTAL SUPPLIES .00 .00 250.00 250.00 .0 TOTAL JUVENILE DIVERSION OFFICER 416.40 1,654.93 2,525.00 870.07 65.5 BULLET PROOF VEST PROTECTION ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:16AM PAGE:30 SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 4,766.93 5,000.00 233.07 95.3 TOTAL SUPPLIES .00 4,766.93 5,000.00 233.07 95.3 TOTAL BULLET PROOF VEST PROTECTION .00 4,766.93 5,000.00 233.07 95.3 TOTAL FUND EXPENDITURES 23,532.61 264,191.62 281,858.00 17,666.38 93.7 NET REVENUE OVER EXPENDITURES 42,401.76 ( 9,091.32) ( 28,463.00) ( 19,371.68) ( 31.9) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:35AM PAGE:31 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 5,210,956.16 31-10000118 MONEY MARKET ACCOUNT 120,309.71 TOTAL CASH 5,331,265.87 INVESTMENTS: 31-10000122 TIME DEPOSITS - SHORT TERM 3,942,930.97 TOTAL INVESTMENTS 3,942,930.97 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 52,896.51 31-10000132 ACCOUNTS RECEIVABLE - EOY ( 31,643.46) 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 276,424.86 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 8,722.90) 31-10000139 ACCRUED INTEREST RECEIVABLE 2,815.50 31-10000156 DUE FROM OTHER FUNDS 33,530.34 TOTAL ACCOUNTS RECEIVABLE 325,300.85 TOTAL CURRENT ASSETS 9,599,497.69 FIXED ASSETS: 31-10000181 BUILDINGS 13,275,982.48 31-10000182 ACCUMULATED - BUILDINGS ( 5,748,068.61) 31-10000183 VEHICLES 347,144.56 31-10000184 ACCUMULATED - VEHICLES ( 329,534.55) 31-10000185 EQUIPMENT 413,803.40 31-10000186 ACCUMULATED - EQUIPMENT ( 356,206.04) 31-10000188 IMPROVEMENTS OTHER THAN BLDG 11,962,785.11 31-10000189 ACCUMULATED OT BLDG ( 5,869,654.73) TOTAL FIXED ASSETS 13,696,251.62 OTHER ASSETS: 31-10000190 ACCUMULATED ( 550,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 1,963,274.23 31-10006100 DEFERRED OUTFLOW OF RESOURCES 61,760.29 TOTAL OTHER ASSETS 1,475,034.52 TOTAL NON-CURRENT ASSETS 15,171,286.14 TOTAL ASSETS 24,770,783.83 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:35AM PAGE:32 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 67,354.55 31-20000204 ACCOUNTS PAYABLE - EOY 39,030.53 31-20000215 WAGES PAYABLE 11,584.61 TOTAL ACCOUNTS PAYABLE 117,969.69 DUE TO OTHER FUNDS: 31-20000245 DUE TO OTHER FUNDS 522.62 TOTAL DUE TO OTHER FUNDS 522.62 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 322,119.90 31-20005411 DEFERRED INFLOWS OF RESOURCES ( 13,146.83) TOTAL OTHER PAYABLES 308,973.07 TOTAL CURRENT LIABILITIES 427,465.38 NON-CURRENT LIABILITIES: 31-20000250 LEASES PAYABLE 1,056.00 31-20000265 COMPENSATED ABSENCES PAYABLE 40,217.62 TOTAL NON-CURRENT LIABILITIES 41,273.62 TOTAL LIABILITIES 468,739.00 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 2,963,796.83 31-30000305 RESERVE FOR REPLACEMENT 4,357,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 334,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 30,000.00 TOTAL CAPITAL ASSETS 8,261,037.52 OTHER NET ASSETS: 31-30000320 CAPITAL ASSETS NET OF DEBT 15,422,526.77 TOTAL OTHER NET ASSETS 15,422,526.77 REVENUE OVER EXPENDITURES - YTD 618,480.54 BALANCE - CURRENT DATE 24,302,044.83 TOTAL NET ASSETS 24,302,044.83 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:35AM PAGE:33 TOTAL LIABILITIES AND NET ASSETS 24,770,783.83 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:35AM PAGE:34 WATER - REVENUE MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 6,142.29 6,000.00 ( 142.29) 102.4 31-4310-1109 REIMBURSEMENTS .00 .65 .00 ( .65) .0 31-4310-1140 INTEREST INCOME 2,846.79 46,809.59 40,000.00 ( 6,809.59) 117.0 TOTAL MISC LOCAL REVENUE 2,846.79 52,952.53 46,000.00 ( 6,952.53) 115.1 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 236,265.03 2,297,604.11 2,000,000.00 ( 297,604.11) 114.9 31-4310-1705 UTILITY SERVICE FEES 1,800.00 22,550.00 21,000.00 ( 1,550.00) 107.4 31-4310-1706 WATER PLANT INVESTMENT FEES .00 250.00 250.00 .00 100.0 31-4310-1707 UTILITY LATE FEES ( 5.00) 20,395.00 20,000.00 ( 395.00) 102.0 31-4310-1710 BULK WATER 11,969.67 105,276.05 90,000.00 ( 15,276.05) 117.0 TOTAL UTILITIES REVENUE 250,029.70 2,446,075.16 2,131,250.00 ( 314,825.16) 114.8 TRANSFERS IN: 31-4310-5596 TRANSFER FROM UTILITY DEPOSIT 111.71 429.25 200.00 ( 229.25) 214.6 TOTAL TRANSFERS IN 111.71 429.25 200.00 ( 229.25) 214.6 TOTAL WATER - REVENUE 252,988.20 2,499,456.94 2,177,450.00 ( 322,006.94) 114.8 WATER MAIN REPLACEMENTS - REV STATE REVENUE: 31-4840-3374 SLIB 7,124.38 98,169.99 .00 ( 98,169.99) .0 TOTAL STATE REVENUE 7,124.38 98,169.99 .00 ( 98,169.99) .0 TOTAL WATER MAIN REPLACEMENTS - REV 7,124.38 98,169.99 .00 ( 98,169.99) .0 LITTLE BOX ELDER SPRING - REVE STATE REVENUE: 31-4855-3235 WWDC GRANT 42,092.97 53,730.13 11,500.00 ( 42,230.13) 467.2 TOTAL STATE REVENUE 42,092.97 53,730.13 11,500.00 ( 42,230.13) 467.2 TOTAL LITTLE BOX ELDER SPRING - REVE 42,092.97 53,730.13 11,500.00 ( 42,230.13) 467.2 TOTAL FUND REVENUE 302,205.55 2,651,357.06 2,188,950.00 ( 462,407.06) 121.1 WATER - ADMINISTRATION ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:37AM PAGE:35 DEPRECIATION: 31-5400-1150 DEPRECIATION 137,500.00 550,000.00 550,000.00 .00 100.0 TOTAL DEPRECIATION 137,500.00 550,000.00 550,000.00 .00 100.0 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 890.65 8,833.48 15,000.00 6,166.52 58.9 31-5400-2166 COLLECTION FEES .00 373.44 375.00 1.56 99.6 TOTAL PROFESSIONAL SERVICES 890.65 9,206.92 15,375.00 6,168.08 59.9 FINANCIAL: 31-5400-4344 DEBT PAYMENT - CAPITAL LEASE .00 384.00 384.00 .00 100.0 TOTAL FINANCIAL .00 384.00 384.00 .00 100.0 OPERATING TRANSFERS: 31-5400-4347 MANAGEMENT FEES 66,091.00 264,364.00 264,364.00 .00 100.0 TOTAL OPERATING TRANSFERS 66,091.00 264,364.00 264,364.00 .00 100.0 TOTAL WATER - ADMINISTRATION 204,481.65 823,954.92 830,123.00 6,168.08 99.3 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,602.41 98,831.28 98,839.00 7.72 100.0 31-5401-1002 SALARIES/WAGES - OVERTIME .00 4,224.13 6,000.00 1,775.87 70.4 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 463.15 464.00 .85 99.8 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 31-5401-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,977.00 1,977.00 .0 TOTAL PERSONNEL SERVICES 7,627.41 103,818.56 107,580.00 3,761.44 96.5 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 597.42 8,123.10 8,260.00 136.90 98.3 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 2,670.91 32,049.57 32,063.00 13.43 100.0 31-5401-1025 EMPLOYEE BENEFITS - COMP 258.56 3,696.04 4,473.00 776.96 82.6 31-5401-1026 EMPLOYEE BENEFITS - COMP 152.04 1,976.52 .00 ( 1,976.52) .0 31-5401-1029 EMPLOYEE BENEFITS - WY 1,263.52 17,127.81 17,424.00 296.19 98.3 TOTAL EMPLOYEE BENEFITS 4,942.45 62,973.04 62,220.00 ( 753.04) 101.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:37AM PAGE:36 PURCHASED SERVICES: 31-5401-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 300.00 300.00 .0 31-5401-2122 TRAINING/DEVELOPMENT .00 1,197.50 2,570.00 1,372.50 46.6 31-5401-2123 MEALS/LODGING/TRAVEL .00 .00 700.00 700.00 .0 TOTAL PURCHASED SERVICES .00 1,197.50 3,570.00 2,372.50 33.5 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 5,800.02 36,169.60 60,000.00 23,830.40 60.3 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 1,424.44 7,040.12 7,000.00 ( 40.12) 100.6 31-5401-2133 UTILITY SERVICES - NATURAL GAS 158.74 5,528.56 5,250.00 ( 278.56) 105.3 31-5401-2134 TELECOMMUNICATIONS 15.12 181.64 250.00 68.36 72.7 31-5401-2140 RENT - LAND/BUILDINGS .00 8,519.76 10,000.00 1,480.24 85.2 TOTAL PROPERTY SERVICES 7,398.32 57,439.68 82,500.00 25,060.32 69.6 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 1,199.50 2,500.00 1,300.50 48.0 31-5401-2155 REPAIRS/MAINTENANCE .00 .00 13,000.00 13,000.00 .0 31-5401-2156 MAINTENANCE AGREEMENT .00 6,345.00 6,250.00 ( 95.00) 101.5 31-5401-2158 MISC CONTRACTUAL SERVICES 258.00 19,472.69 25,000.00 5,527.31 77.9 TOTAL PROFESSIONAL SERVICES 258.00 27,017.19 46,750.00 19,732.81 57.8 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 4,098.37 23,006.49 20,000.00 ( 3,006.49) 115.0 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 5,125.61 9,465.01 15,900.00 6,434.99 59.5 31-5401-3235 FUEL 289.95 2,328.70 2,200.00 ( 128.70) 105.9 TOTAL SUPPLIES 9,513.93 34,800.20 38,100.00 3,299.80 91.3 CAPITALIZED EXPENDITURES: 31-5401-6548 VEHICLES .00 16,551.71 17,500.00 948.29 94.6 TOTAL CAPITALIZED EXPENDITURES .00 16,551.71 17,500.00 948.29 94.6 TOTAL WATER - TREATMENT 29,740.11 303,797.88 423,220.00 119,422.12 71.8 WATER - DISTRIBUTION/MAINTNCE PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 13,335.00 170,390.47 170,577.00 186.53 99.9 31-5402-1002 SALARIES/WAGES - OVERTIME .00 2,850.38 7,500.00 4,649.62 38.0 31-5402-1004 SALARIES/WAGES - TEMPORARY 582.40 2,870.40 2,982.00 111.60 96.3 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 680.59 682.00 1.41 99.8 31-5402-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 13,942.40 177,091.84 182,041.00 4,949.16 97.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:37AM PAGE:37 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,068.91 13,577.46 13,956.00 378.54 97.3 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 5,130.19 61,543.55 61,564.00 20.45 100.0 31-5402-1025 EMPLOYEE BENEFITS - COMP 472.65 6,316.38 7,699.00 1,382.62 82.0 31-5402-1029 EMPLOYEE BENEFITS - WY 2,216.28 28,792.63 29,596.00 803.37 97.3 TOTAL EMPLOYEE BENEFITS 8,888.03 110,230.02 112,815.00 2,584.98 97.7 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 245.62 741.10 1,600.00 858.90 46.3 31-5402-2122 TRAINING/DEVELOPMENT .00 2,106.00 2,450.00 344.00 86.0 31-5402-2123 MEALS/LODGING/TRAVEL .00 .00 400.00 400.00 .0 TOTAL PURCHASED SERVICES 245.62 2,847.10 4,450.00 1,602.90 64.0 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 2,081.76 11,600.70 13,500.00 1,899.30 85.9 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 6,377.69 31,471.97 24,000.00 ( 7,471.97) 131.1 31-5402-2133 UTILITY SERVICES - NATURAL GAS 20.64 986.02 1,500.00 513.98 65.7 31-5402-2134 TELECOMMUNICATIONS 31.67 196.92 600.00 403.08 32.8 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 8,511.76 44,255.61 40,000.00 ( 4,255.61) 110.6 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,867.00 2,500.00 633.00 74.7 31-5402-2155 REPAIRS/MAINTENANCE 424.76 2,082.34 2,500.00 417.66 83.3 31-5402-2156 MAINTENANCE AGREEMENT .00 795.00 900.00 105.00 88.3 31-5402-2158 MISC CONTRACTUAL SERVICES .00 23.00 1,000.00 977.00 2.3 TOTAL PROFESSIONAL SERVICES 424.76 4,767.34 6,900.00 2,132.66 69.1 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 849.02 30,491.75 35,000.00 4,508.25 87.1 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 3,600.55 3,300.00 ( 300.55) 109.1 31-5402-3235 FUEL 2,349.41 7,571.59 8,500.00 928.41 89.1 TOTAL SUPPLIES 3,198.43 41,663.89 46,800.00 5,136.11 89.0 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 214.01 350.00 135.99 61.2 TOTAL FINANCIAL .00 214.01 350.00 135.99 61.2 CAPITALIZED EXPENDITURES: 31-5402-6547 EQUIPMENT/FURNITURE .00 8,439.00 8,500.00 61.00 99.3 31-5402-6548 VEHICLES 19,638.82 19,638.82 20,000.00 361.18 98.2 TOTAL CAPITALIZED EXPENDITURES 19,638.82 28,077.82 28,500.00 422.18 98.5 TOTAL WATER - DISTRIBUTION/MAINTNCE 54,849.82 409,147.63 421,856.00 12,708.37 97.0 WATER - CUSTOMER SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:37AM PAGE:38 PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 3,744.34 48,676.39 48,672.00 ( 4.39) 100.0 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 425.51 433.00 7.49 98.3 31-5403-1007 SALARIES/WAGES - INCENTIVE .00 707.20 793.00 85.80 89.2 TOTAL PERSONNEL SERVICES 3,744.34 49,809.10 49,898.00 88.90 99.8 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 273.74 3,657.97 8,203.00 4,545.03 44.6 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 22.11 265.34 266.00 .66 99.8 31-5403-1025 EMPLOYEE BENEFITS - COMP 126.94 1,775.44 2,072.00 296.56 85.7 31-5403-1029 EMPLOYEE BENEFITS - WY 622.30 8,089.91 8,089.00 ( .91) 100.0 TOTAL EMPLOYEE BENEFITS 1,045.09 13,788.66 18,630.00 4,841.34 74.0 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.44 197.34 300.00 102.66 65.8 TOTAL PROPERTY SERVICES 16.44 197.34 300.00 102.66 65.8 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 31-5403-2156 MAINTENANCE AGREEMENT .00 1,949.94 2,000.00 50.06 97.5 TOTAL PROFESSIONAL SERVICES .00 1,949.94 3,500.00 1,550.06 55.7 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES .00 1,402.97 2,000.00 597.03 70.2 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 12,363.90 19,349.28 25,000.00 5,650.72 77.4 31-5403-3235 FUEL 305.83 972.37 2,500.00 1,527.63 38.9 TOTAL SUPPLIES 12,669.73 21,724.62 29,500.00 7,775.38 73.6 TOTAL WATER - CUSTOMER SERVICES 17,475.60 87,469.66 102,428.00 14,958.34 85.4 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 1,253.66 41,913.73 126,000.00 84,086.27 33.3 TOTAL PROFESSIONAL SERVICES 1,253.66 41,913.73 126,000.00 84,086.27 33.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:37AM PAGE:39 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG 902.68 196,301.71 1,065,000.00 868,698.29 18.4 TOTAL CAPITALIZED EXPENDITURES 902.68 196,301.71 1,065,000.00 868,698.29 18.4 TOTAL WATER MAIN REPLACEMENTS 2,156.34 238,215.44 1,191,000.00 952,784.56 20.0 LITTLE BOX ELDER SPRING REHAB PROFESSIONAL SERVICES: 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY .00 9,945.00 25,000.00 15,055.00 39.8 TOTAL PROFESSIONAL SERVICES .00 9,945.00 25,000.00 15,055.00 39.8 CAPITALIZED EXPENDITURES: 31-5855-6540 LAND .00 16,913.00 17,000.00 87.00 99.5 31-5855-6544 OTHER THAN BLDG .00 .00 5,000,000.00 5,000,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 16,913.00 5,017,000.00 5,000,087.00 .3 TOTAL LITTLE BOX ELDER SPRING REHAB .00 26,858.00 5,042,000.00 5,015,142.00 .5 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 2,431.75 11,595.25 40,000.00 28,404.75 29.0 31-5856-2158 MISC CONTRACTUAL .00 .00 30,000.00 30,000.00 .0 TOTAL PROFESSIONAL SERVICES 2,431.75 11,595.25 70,000.00 58,404.75 16.6 CAPITALIZED EXPENDITURES: 31-5856-6544 OTHER THAN BLDG .00 131,837.74 789,000.00 657,162.26 16.7 TOTAL CAPITALIZED EXPENDITURES .00 131,837.74 789,000.00 657,162.26 16.7 TOTAL WATER IMPROVEMENTS 2,431.75 143,432.99 859,000.00 715,567.01 16.7 TOTAL FUND EXPENDITURES 311,135.27 2,032,876.52 8,869,627.00 6,836,750.48 22.9 NET REVENUE OVER EXPENDITURES ( 8,929.72) 618,480.54 ( 6,680,677.00) ( 7,299,157.54) 9.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:37AM PAGE:40 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 2,124,451.42 32-10000118 MONEY MARKET ACCOUNT 120,309.70 TOTAL CASH 2,244,761.12 INVESTMENTS: 32-10000120 INVESTMENT POOL 225,527.64 32-10000122 TIME DEPOSITS - SHORT TERM 3,114,409.74 TOTAL INVESTMENTS 3,339,937.38 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 89,115.41 32-10000132 ACCOUNTS RECEIVABLE - EOY 2,193.87 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 145,929.69 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 9,239.84) 32-10000139 ACCRUED INTEREST RECEIVABLE 1,993.29 32-10000156 DUE FROM OTHER FUNDS 2,833.82 TOTAL ACCOUNTS RECEIVABLE 232,826.24 TOTAL CURRENT ASSETS 5,817,524.74 FIXED ASSETS: 32-10000181 BUILDINGS 2,388,172.45 32-10000182 ACCUMULATED - BUILDINGS ( 1,829,562.06) 32-10000183 VEHICLES 485,022.41 32-10000184 ACCUMULATED - VEHICLES ( 467,412.40) 32-10000185 MACHINERY/EQUIPMENT 510,395.97 32-10000186 ACCUMULATED - EQUIPMENT ( 378,743.64) 32-10000188 IMPROVEMENTS OTHER THAN BLDG 8,531,553.69 32-10000189 ACCUMULATED OT BLDG ( 2,727,183.79) TOTAL FIXED ASSETS 6,512,242.63 OTHER ASSETS: 32-10000190 ACCUMULATED ( 190,000.00) 32-10000195 CONSTRUCTION IN PROGRESS 33,288.48 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 36,809.54 TOTAL OTHER ASSETS ( 119,901.98) TOTAL NON-CURRENT ASSETS 6,392,340.65 TOTAL ASSETS 12,209,865.39 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:37AM PAGE:41 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 86,254.43 32-20000204 ACCOUNTS PAYABLE - EOY ( 2,466.25) 32-20000215 WAGES PAYABLE 9,124.58 TOTAL ACCOUNTS PAYABLE 92,912.76 DUE TO OTHER FUNDS: 32-20000245 DUE TO OTHER FUNDS 3,571.04 TOTAL DUE TO OTHER FUNDS 3,571.04 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 203,919.49 32-20005411 DEFERRED INFLOWS OF RESOURCES ( 8,997.03) TOTAL OTHER PAYABLES 194,922.46 TOTAL CURRENT LIABILITIES 291,406.26 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 31,790.48 TOTAL NON-CURRENT LIABILITIES 31,790.48 TOTAL LIABILITIES 323,196.74 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS 874,050.92 32-30000305 RESERVE FOR REPLACEMENT 3,800,882.31 32-30000306 RESERVE FOR OPERATING 195,913.00 32-30000307 RESERVE FOR SLUDGE REMOVAL 165,000.00 TOTAL CAPITAL ASSETS 5,035,846.23 OTHER NET ASSETS: 32-30000320 CAPITAL ASSETS NET OF DEBT 6,548,236.20 TOTAL OTHER NET ASSETS 6,548,236.20 REVENUE OVER EXPENDITURES - YTD 302,586.22 BALANCE - CURRENT DATE 11,886,668.65 TOTAL NET ASSETS 11,886,668.65 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:38AM PAGE:42 TOTAL LIABILITIES AND NET ASSETS 12,209,865.39 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:38AM PAGE:43 SEWER - REVENUE MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 1,073.69 1,000.00 ( 73.69) 107.4 32-4320-1140 INTEREST INCOME 1,929.50 34,437.29 30,000.00 ( 4,437.29) 114.8 TOTAL MISC LOCAL REVENUE 1,929.50 35,510.98 31,000.00 ( 4,510.98) 114.6 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 110,718.19 1,213,631.39 1,000,000.00 ( 213,631.39) 121.4 TOTAL UTILITIES REVENUE 110,718.19 1,213,631.39 1,000,000.00 ( 213,631.39) 121.4 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 54,645.00 288,075.00 225,000.00 ( 63,075.00) 128.0 TOTAL SEPTIC WASTE DISPOSAL 54,645.00 288,075.00 225,000.00 ( 63,075.00) 128.0 TOTAL SEWER - REVENUE 167,292.69 1,537,217.37 1,256,000.00 ( 281,217.37) 122.4 WASTEWATER REHAB-REVENU STATE REVENUE: 32-4850-3374 SLIB 38,970.41 103,960.70 .00 ( 103,960.70) .0 TOTAL STATE REVENUE 38,970.41 103,960.70 .00 ( 103,960.70) .0 TOTAL WASTEWATER REHAB-REVENU 38,970.41 103,960.70 .00 ( 103,960.70) .0 TOTAL FUND REVENUE 206,263.10 1,641,178.07 1,256,000.00 ( 385,178.07) 130.7 SEWER - ADMINISTRATION DEPRECIATION: 32-5500-1150 DEPRECIATION 47,500.00 190,000.00 190,000.00 .00 100.0 TOTAL DEPRECIATION 47,500.00 190,000.00 190,000.00 .00 100.0 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 575.22 6,494.54 14,500.00 8,005.46 44.8 TOTAL PROFESSIONAL SERVICES 575.22 6,494.54 14,500.00 8,005.46 44.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:38AM PAGE:44 OPERATING TRANSFERS: 32-5500-4347 MANAGEMENT FEES 39,340.00 157,360.00 157,360.00 .00 100.0 TOTAL OPERATING TRANSFERS 39,340.00 157,360.00 157,360.00 .00 100.0 TOTAL SEWER - ADMINISTRATION 87,415.22 353,854.54 361,860.00 8,005.46 97.8 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,277.59 88,990.84 99,309.00 10,318.16 89.6 32-5501-1002 SALARIES/WAGES - OVERTIME .00 453.72 5,000.00 4,546.28 9.1 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 431.93 433.00 1.07 99.8 32-5501-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 6,302.59 90,176.49 105,042.00 14,865.51 85.9 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 489.11 6,980.78 8,126.00 1,145.22 85.9 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 2,664.77 32,016.63 32,065.00 48.37 99.9 32-5501-1025 EMPLOYEE BENEFITS - COMP 213.66 3,218.64 4,449.00 1,230.36 72.4 32-5501-1026 EMPLOYEE BENEFITS - COMP 61.02 793.26 .00 ( 793.26) .0 32-5501-1029 EMPLOYEE BENEFITS - WY 1,043.34 14,865.71 17,336.00 2,470.29 85.8 TOTAL EMPLOYEE BENEFITS 4,471.90 57,875.02 61,976.00 4,100.98 93.4 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 1,257.50 2,570.00 1,312.50 48.9 32-5501-2123 MEALS/LODGING/TRAVEL .00 .00 700.00 700.00 .0 TOTAL PURCHASED SERVICES .00 1,257.50 3,270.00 2,012.50 38.5 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 15,080.38 90,928.76 95,000.00 4,071.24 95.7 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 10,259.68 59,713.52 52,000.00 ( 7,713.52) 114.8 32-5501-2134 TELECOMMUNICATIONS 247.55 1,576.33 2,000.00 423.67 78.8 TOTAL PROPERTY SERVICES 25,587.61 152,218.61 149,000.00 ( 3,218.61) 102.2 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 2,500.00 2,500.00 .0 32-5501-2155 REPAIRS/MAINTENANCE .00 .00 10,000.00 10,000.00 .0 32-5501-2158 MISC CONTRACTUAL SERVICES 554.00 10,446.47 10,000.00 ( 446.47) 104.5 TOTAL PROFESSIONAL SERVICES 554.00 10,446.47 22,500.00 12,053.53 46.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:39AM PAGE:45 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 3,772.02 25,122.11 22,000.00 ( 3,122.11) 114.2 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,941.99 4,300.00 1,358.01 68.4 32-5501-3235 FUEL 289.92 1,202.42 2,000.00 797.58 60.1 TOTAL SUPPLIES 4,061.94 29,266.52 28,300.00 ( 966.52) 103.4 CAPITALIZED EXPENDITURES: 32-5501-6548 VEHICLES .00 16,172.31 17,500.00 1,327.69 92.4 TOTAL CAPITALIZED EXPENDITURES .00 16,172.31 17,500.00 1,327.69 92.4 TOTAL SEWER - TREATMENT 40,978.04 357,412.92 402,588.00 45,175.08 88.8 SEWER - COLLECTION PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 11,839.39 152,990.10 160,225.00 7,234.90 95.5 32-5502-1002 SALARIES/WAGES - OVERTIME 89.45 1,597.21 4,500.00 2,902.79 35.5 32-5502-1004 SALARIES/WAGES - TEMPORARY 582.40 2,870.40 2,982.00 111.60 96.3 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 446.16 447.00 .84 99.8 32-5502-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 12,536.24 158,203.87 168,454.00 10,250.13 93.9 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 952.91 12,031.96 12,688.00 656.04 94.8 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 6,205.26 72,694.86 74,502.00 1,807.14 97.6 32-5502-1025 EMPLOYEE BENEFITS - COMP 424.95 5,649.12 7,125.00 1,475.88 79.3 32-5502-1029 EMPLOYEE BENEFITS - WY 1,982.57 25,692.28 27,377.00 1,684.72 93.9 TOTAL EMPLOYEE BENEFITS 9,565.69 116,068.22 121,692.00 5,623.78 95.4 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 93.38 588.90 1,600.00 1,011.10 36.8 32-5502-2122 TRAINING/DEVELOPMENT .00 1,100.00 2,450.00 1,350.00 44.9 32-5502-2123 MEALS/LODGING/TRAVEL .00 .00 400.00 400.00 .0 TOTAL PURCHASED SERVICES 93.38 1,688.90 4,450.00 2,761.10 38.0 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 2,209.52 15,029.33 12,800.00 ( 2,229.33) 117.4 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 41.05 257.89 350.00 92.11 73.7 32-5502-2133 UTILITY SERVICES - NATURAL GAS 119.62 1,745.46 1,800.00 54.54 97.0 32-5502-2134 TELECOMMUNICATIONS 94.52 951.20 1,200.00 248.80 79.3 TOTAL PROPERTY SERVICES 2,464.71 17,983.88 16,150.00 ( 1,833.88) 111.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:39AM PAGE:46 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY 402.50 1,035.00 2,500.00 1,465.00 41.4 32-5502-2155 REPAIRS/MAINTENANCE .00 5,096.77 5,250.00 153.23 97.1 32-5502-2158 MISC CONTRACTUAL SERVICES .00 .00 1,000.00 1,000.00 .0 TOTAL PROFESSIONAL SERVICES 402.50 6,131.77 8,750.00 2,618.23 70.1 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 2,217.25 20,998.67 25,000.00 4,001.33 84.0 32-5502-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,419.00 1,800.00 381.00 78.8 32-5502-3235 FUEL 2,349.26 7,788.55 8,500.00 711.45 91.6 TOTAL SUPPLIES 4,566.51 30,206.22 35,300.00 5,093.78 85.6 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 194.55 250.00 55.45 77.8 TOTAL FINANCIAL .00 194.55 250.00 55.45 77.8 CAPITALIZED EXPENDITURES: 32-5502-6547 EQUIPMENT/FURNITURE 3,778.24 3,778.24 10,000.00 6,221.76 37.8 32-5502-6548 VEHICLES 19,638.82 19,638.82 20,000.00 361.18 98.2 TOTAL CAPITALIZED EXPENDITURES 23,417.06 23,417.06 30,000.00 6,582.94 78.1 TOTAL SEWER - COLLECTION 53,046.09 353,894.47 385,046.00 31,151.53 91.9 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 17,742.50 27,054.58 101,300.00 74,245.42 26.7 TOTAL PROFESSIONAL SERVICES 17,742.50 27,054.58 101,300.00 74,245.42 26.7 CAPITALIZED EXPENDITURES: 32-5850-6544 OTHER THAN BLDG .00 .00 733,700.00 733,700.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 733,700.00 733,700.00 .0 TOTAL WASTEWATER PLANT REHAB 17,742.50 27,054.58 835,000.00 807,945.42 3.2 SEWER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 1,317.50 32,926.34 100,000.00 67,073.66 32.9 TOTAL PROFESSIONAL SERVICES 1,317.50 32,926.34 100,000.00 67,073.66 32.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:39AM PAGE:47 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG 5,971.50 213,449.00 800,000.00 586,551.00 26.7 TOTAL CAPITALIZED EXPENDITURES 5,971.50 213,449.00 800,000.00 586,551.00 26.7 TOTAL SEWER MAIN REPLACEMENTS 7,289.00 246,375.34 900,000.00 653,624.66 27.4 TOTAL FUND EXPENDITURES 206,470.85 1,338,591.85 2,884,494.00 1,545,902.15 46.4 NET REVENUE OVER EXPENDITURES ( 207.75) 302,586.22 ( 1,628,494.00) ( 1,931,080.22) 18.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:39AM PAGE:48 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 451,401.63 TOTAL CASH 451,401.63 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 401,765.53 TOTAL INVESTMENTS 401,765.53 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 800.00 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 569.45) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 49,510.35 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 1,713.48) 33-10000139 ACCRUED INTEREST RECEIVABLE 290.01 33-10000156 DUE FROM OTHER FUNDS 569.45 TOTAL ACCOUNTS RECEIVABLE 48,886.88 TOTAL CURRENT ASSETS 902,054.04 FIXED ASSETS: 33-10000183 VEHICLES 559,776.68 33-10000184 ACCUMULATED - VEHICLES ( 329,305.19) 33-10000185 EQUIPMENT 33,437.00 33-10000186 ACCUMULATED - EQUIPMENT ( 33,437.00) TOTAL FIXED ASSETS 230,471.49 OTHER ASSETS: 33-10000190 ACCUMULATED ( 35,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 20,266.83 TOTAL OTHER ASSETS ( 14,733.17) TOTAL NON-CURRENT ASSETS 215,738.32 TOTAL ASSETS 1,117,792.36 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:39AM PAGE:49 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 8,134.27 33-20000215 WAGES PAYABLE 4,826.81 TOTAL ACCOUNTS PAYABLE 12,961.08 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 108,074.76 33-20005411 DEFERRED INFLOWS OF RESOURCES ( 5,215.52) TOTAL OTHER PAYABLES 102,859.24 TOTAL CURRENT LIABILITIES 115,820.32 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 30,047.53 TOTAL NON-CURRENT LIABILITIES 30,047.53 TOTAL LIABILITIES 145,867.85 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 127,929.63) 33-30000305 RESERVE FOR REPLACEMENT 606,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 554,814.91 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 301,010.29 TOTAL OTHER NET ASSETS 301,010.29 REVENUE OVER EXPENDITURES - YTD 116,099.31 BALANCE - CURRENT DATE 971,924.51 TOTAL NET ASSETS 971,924.51 TOTAL LIABILITIES AND NET ASSETS 1,117,792.36 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:39AM PAGE:50 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1107 OTHER .00 774.27 .00 ( 774.27) .0 33-4330-1140 INTEREST INCOME 143.88 4,263.93 4,000.00 ( 263.93) 106.6 TOTAL MISC LOCAL REVENUE 143.88 5,038.20 4,000.00 ( 1,038.20) 126.0 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 41,644.84 493,797.38 475,000.00 ( 18,797.38) 104.0 33-4330-1709 SANITATION ACTIVATION FEE 375.00 875.00 500.00 ( 375.00) 175.0 TOTAL UTILITIES REVENUE 42,019.84 494,672.38 475,500.00 ( 19,172.38) 104.0 TOTAL SANITATION - REVENUE 42,163.72 499,710.58 479,500.00 ( 20,210.58) 104.2 TOTAL FUND REVENUE 42,163.72 499,710.58 479,500.00 ( 20,210.58) 104.2 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 10,768.95 139,456.01 139,473.00 16.99 100.0 33-5600-1002 SALARIES/WAGES - OVERTIME .00 .00 600.00 600.00 .0 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 1,127.93 1,129.00 1.07 99.9 33-5600-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 33-5600-1007 SALARIES/WAGES - INCENTIVE .00 665.60 2,045.00 1,379.40 32.6 TOTAL PERSONNEL SERVICES 10,793.95 141,549.54 143,547.00 1,997.46 98.6 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 838.48 10,933.18 11,068.00 134.82 98.8 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 4,442.67 53,309.70 53,326.00 16.30 100.0 33-5600-1025 EMPLOYEE BENEFITS - COMP 365.91 5,033.61 5,988.00 954.39 84.1 33-5600-1026 EMPLOYEE BENEFITS - COMP 136.76 980.59 745.00 ( 235.59) 131.6 33-5600-1029 EMPLOYEE BENEFITS - WY 1,789.78 23,177.38 23,280.00 102.62 99.6 TOTAL EMPLOYEE BENEFITS 7,573.60 93,434.46 94,407.00 972.54 99.0 DEPRECIATION: 33-5600-1150 DEPRECIATION 8,750.00 35,000.00 35,000.00 .00 100.0 TOTAL DEPRECIATION 8,750.00 35,000.00 35,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:45AM PAGE:51 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE 1,387.47 2,474.11 1,000.00 ( 1,474.11) 247.4 33-5600-2158 MISC CONTRACTUAL SERVICES 389.66 5,309.82 5,000.00 ( 309.82) 106.2 33-5600-2175 REFUNDS/REIMBURSEMENTS .00 .00 125.00 125.00 .0 TOTAL PROFESSIONAL SERVICES 1,777.13 7,783.93 6,125.00 ( 1,658.93) 127.1 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 180.58 20,820.05 25,000.00 4,179.95 83.3 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 19,965.00 20,000.00 35.00 99.8 33-5600-3235 FUEL 6,176.56 20,997.29 20,000.00 ( 997.29) 105.0 TOTAL SUPPLIES 6,357.14 61,782.34 65,000.00 3,217.66 95.1 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 11,015.25 44,061.00 44,061.00 .00 100.0 TOTAL OPERATING TRANSFERS 11,015.25 44,061.00 44,061.00 .00 100.0 CAPITALIZED EXPENDITURES: 33-5600-6547 EQUIPMENT/FURNITURE .00 .00 7,000.00 7,000.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 7,000.00 7,000.00 .0 TOTAL SANITATION 46,267.07 383,611.27 425,140.00 41,528.73 90.2 TOTAL FUND EXPENDITURES 46,267.07 383,611.27 425,140.00 41,528.73 90.2 NET REVENUE OVER EXPENDITURES ( 4,103.35) 116,099.31 54,360.00 ( 61,739.31) 213.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:45AM PAGE:52 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 228,746.42 TOTAL CASH 228,746.42 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,455,913.91 TOTAL INVESTMENTS 1,455,913.91 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 234,439.47 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 9,505.50) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY 73,843.37 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,141.96) 34-10000139 ACCRUED INTEREST RECEIVABLE 1,493.73 34-10000156 DUE FROM OTHER FUNDS 2,600.15 TOTAL ACCOUNTS RECEIVABLE 300,729.26 TOTAL CURRENT ASSETS 1,985,389.59 FIXED ASSETS: 34-10000180 LAND 153,289.58 34-10000181 BUILDINGS 1,689,609.46 34-10000182 ACCUMULATED - BUILDINGS ( 292,872.48) 34-10000183 VEHICLES 49,148.52 34-10000184 ACCUMULATED - VEHICLE ( 14,261.12) 34-10000185 EQUIPMENT 1,002,285.94 34-10000186 ACCUMULATED - EQUIPMENT ( 707,553.35) 34-10000188 IMPROVEMENTS OTHER THAN BLDG 417,030.94 34-10000189 ACCUMULATED OT BLDG ( 23,328.68) TOTAL FIXED ASSETS 2,273,348.81 OTHER ASSETS: 34-10000190 ACCUMULATED ( 40,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 27,500.62 TOTAL OTHER ASSETS ( 12,499.38) TOTAL NON-CURRENT ASSETS 2,260,849.43 TOTAL ASSETS 4,246,239.02 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:45AM PAGE:53 ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 135,949.66 34-20000204 ACCOUNTS PAYABLE- EOY 1,074.00 34-20000205 INTEREST PAYABLE 1,826.33 34-20000215 WAGES PAYABLE 9,355.00 TOTAL ACCOUNTS PAYABLE 148,204.99 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 154,940.41 34-20005411 DEFERRED INFLOWS OF RESOURCES ( 7,410.74) TOTAL OTHER PAYABLES 147,529.67 TOTAL CURRENT LIABILITIES 295,734.66 NON-CURRENT LIABILITIES: 34-20000250 LEASES PAYABLE 57,046.14 34-20000265 COMPENSATED ABSENCES PAYABLE 47,750.70 34-20000290 LANDFILL LIABILITY 668,650.97 34-20000295 NOTES PAYABLE 168,299.15 TOTAL NON-CURRENT LIABILITIES 941,746.96 TOTAL LIABILITIES 1,237,481.62 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS 329,771.19 34-30000305 RESERVE FOR REPLACEMENT 1,006,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,468,941.96 OTHER NET ASSETS: 34-30000320 CAPITAL ASSETS NET OF DEBT 2,004,319.95 TOTAL OTHER NET ASSETS 2,004,319.95 REVENUE OVER EXPENDITURES - YTD ( 464,504.51) BALANCE - CURRENT DATE 3,008,757.40 TOTAL NET ASSETS 3,008,757.40 TOTAL LIABILITIES AND NET ASSETS 4,246,239.02 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:45AM PAGE:54 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER 2,224.04 20,726.69 17,500.00 ( 3,226.69) 118.4 34-4340-1109 REIMBURSEMENTS .00 2,579.69 2,500.00 ( 79.69) 103.2 34-4340-1140 INTEREST INCOME 183.41 16,318.30 16,000.00 ( 318.30) 102.0 TOTAL MISC LOCAL REVENUE 2,407.45 39,624.68 36,000.00 ( 3,624.68) 110.1 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 100,764.96 991,611.51 900,000.00 ( 91,611.51) 110.2 TOTAL UTILITIES REVENUE 100,764.96 991,611.51 900,000.00 ( 91,611.51) 110.2 TOTAL LANDFILL - REVENUE 103,172.41 1,031,236.19 936,000.00 ( 95,236.19) 110.2 OPERATING TRANSFERS IN: 34-4895-1905 LOAN PROCEEDS 40,362.07 122,310.02 .00 ( 122,310.02) .0 TOTAL OPERATING TRANSFERS IN 40,362.07 122,310.02 .00 ( 122,310.02) .0 STATE REVENUE: 34-4895-2276 SLIB 161,448.27 489,240.06 1,440,000.00 950,759.94 34.0 TOTAL STATE REVENUE 161,448.27 489,240.06 1,440,000.00 950,759.94 34.0 201,810.34 611,550.08 1,440,000.00 828,449.92 42.5 TOTAL FUND REVENUE 304,982.75 1,642,786.27 2,376,000.00 733,213.73 69.1 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 16,497.90 257,786.54 265,231.00 7,444.46 97.2 34-5340-1002 SALARIES/WAGES - OVERTIME .00 91.60 1,500.00 1,408.40 6.1 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,161.70 2,029.00 867.30 57.3 34-5340-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 34-5340-1007 SALARIES/WAGES - INCENTIVE .00 507.60 2,006.00 1,498.40 25.3 TOTAL PERSONNEL SERVICES 16,547.90 260,147.44 271,366.00 11,218.56 95.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:46AM PAGE:55 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,313.04 20,541.89 21,390.00 848.11 96.0 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 6,007.77 83,500.97 106,394.00 22,893.03 78.5 34-5340-1025 EMPLOYEE BENEFITS - COMP 560.96 9,372.23 11,485.00 2,112.77 81.6 34-5340-1026 EMPLOYEE BENEFITS - COMP 588.11 8,015.76 7,463.00 ( 552.76) 107.4 34-5340-1029 EMPLOYEE BENEFITS - WY 2,153.84 30,100.12 36,868.00 6,767.88 81.6 TOTAL EMPLOYEE BENEFITS 10,623.72 151,530.97 183,600.00 32,069.03 82.5 DEPRECIATION: 34-5340-1150 DEPRECIATION 10,000.00 40,000.00 40,000.00 .00 100.0 TOTAL DEPRECIATION 10,000.00 40,000.00 40,000.00 .00 100.0 PURCHASED SERVICES: 34-5340-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 250.00 250.00 .0 34-5340-2122 TRAINING/DEVELOPMENT .00 .00 775.00 775.00 .0 34-5340-2123 MEALS/LODGING/TRAVEL .00 327.04 750.00 422.96 43.6 TOTAL PURCHASED SERVICES .00 327.04 1,775.00 1,447.96 18.4 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 1,136.88 8,116.97 9,000.00 883.03 90.2 34-5340-2133 UTILITY SERVICES - NATURAL GAS 200.69 8,301.68 7,800.00 ( 501.68) 106.4 34-5340-2134 TELECOMMUNICATIONS 18.43 221.07 200.00 ( 21.07) 110.5 TOTAL PROPERTY SERVICES 1,356.00 16,639.72 17,000.00 360.28 97.9 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 115.00 500.00 385.00 23.0 34-5340-2155 REPAIRS/MAINTENANCE 2,977.50 13,210.29 15,000.00 1,789.71 88.1 34-5340-2156 MAINTENANCE AGREEMENT .00 6,097.03 6,000.00 ( 97.03) 101.6 34-5340-2157 INSURANCE .00 .00 1,500.00 1,500.00 .0 34-5340-2158 MISC CONTRACTUAL SERVICES 36,833.86 331,786.05 431,300.00 99,513.95 76.9 34-5340-2166 COLLECTION FEES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 39,811.36 351,208.37 454,600.00 103,391.63 77.3 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 5,111.27 30,668.96 45,000.00 14,331.04 68.2 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 7,000.00 7,000.00 .0 34-5340-3235 FUEL 488.85 14,505.65 35,000.00 20,494.35 41.4 TOTAL SUPPLIES 5,600.12 45,174.61 87,000.00 41,825.39 51.9 FINANCIAL: 34-5340-4344 DEBT PAYMENT - CAPITAL LEASE .00 58,676.06 59,000.00 323.94 99.5 TOTAL FINANCIAL .00 58,676.06 59,000.00 323.94 99.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:46AM PAGE:56 OPERATING TRANSFERS: 34-5340-4347 MANAGEMENT FEES 22,030.25 88,121.00 88,121.00 .00 100.0 TOTAL OPERATING TRANSFERS 22,030.25 88,121.00 88,121.00 .00 100.0 CAPITALIZED EXPENDITURES: 34-5340-6547 EQUIPMENT/FURNITURE 285.36 7,215.36 7,500.00 284.64 96.2 TOTAL CAPITALIZED EXPENDITURES 285.36 7,215.36 7,500.00 284.64 96.2 TOTAL LANDFILL 106,254.71 1,019,040.57 1,289,962.00 270,921.43 79.0 LANDFILL - CAPITAL PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 13,433.73 119,975.52 147,000.00 27,024.48 81.6 34-5895-2158 MISC CONTRACTUAL SERVICES .00 87,200.00 87,200.00 .00 100.0 TOTAL PROFESSIONAL SERVICES 13,433.73 207,175.52 234,200.00 27,024.48 88.5 CAPITALIZED EXPENDITURES: 34-5895-6542 BUILDINGS/IMPROVEMENTS 7,902.00 7,902.00 10,000.00 2,098.00 79.0 34-5895-6544 OTHER THAN BLDG 34,811.09 749,957.69 1,920,000.00 1,170,042.31 39.1 34-5895-6547 EQUIPMENT/FURNITURE 32,750.00 123,215.00 130,000.00 6,785.00 94.8 TOTAL CAPITALIZED EXPENDITURES 75,463.09 881,074.69 2,060,000.00 1,178,925.31 42.8 TOTAL LANDFILL - CAPITAL 88,896.82 1,088,250.21 2,294,200.00 1,205,949.79 47.4 TOTAL FUND EXPENDITURES 195,151.53 2,107,290.78 3,584,162.00 1,476,871.22 58.8 NET REVENUE OVER EXPENDITURES 109,831.22 ( 464,504.51) ( 1,208,162.00) ( 743,657.49) ( 38.5) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:46AM PAGE:57 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 274,714.21 TOTAL CASH 274,714.21 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 402,085.45 TOTAL INVESTMENTS 402,085.45 ACCOUNTS RECEIVABLE: 39-10000132 ACCOUNTS REC - EOY 5,341.06 39-10000139 ACCRUED INTEREST RECEIVABLE 352.60 TOTAL ACCOUNTS RECEIVABLE 5,693.66 TOTAL CURRENT ASSETS 682,493.32 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 682,493.32 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 39-20000210 IBNR LIABILITY 213,000.00 TOTAL ACCOUNTS PAYABLE 213,000.00 TOTAL CURRENT LIABILITIES 213,000.00 TOTAL LIABILITIES 213,000.00 NET ASSETS CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 484,352.95) 39-30000301 FUND BALANCE RESERVE 800,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 422,647.05 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:46AM PAGE:58 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 46,846.27 BALANCE - CURRENT DATE 469,493.32 TOTAL NET ASSETS 469,493.32 TOTAL LIABILITIES AND NET ASSETS 682,493.32 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:46AM PAGE:59 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 91,507.60 915,618.13 800,000.00 ( 115,618.13) 114.5 39-4390-0111 INSURANCE PREMIUMS 30,887.84 386,374.60 480,000.00 93,625.40 80.5 39-4390-0112 INSURANCE ASSESSMENTS 69,610.28 876,319.79 940,000.00 63,680.21 93.2 39-4390-0113 COBRA PAYMENTS .00 1,358.17 1,350.00 ( 8.17) 100.6 TOTAL REVENUE 192,005.72 2,179,670.69 2,221,350.00 41,679.31 98.1 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 71.97 4,217.95 4,000.00 ( 217.95) 105.5 TOTAL MISC LOCAL REVENUE 71.97 4,217.95 4,000.00 ( 217.95) 105.5 TOTAL EMPLOYEE HEALTH CARE - REVENUE 192,077.69 2,183,888.64 2,225,350.00 41,461.36 98.1 TOTAL FUND REVENUE 192,077.69 2,183,888.64 2,225,350.00 41,461.36 98.1 EMPLOYEE HEALTH CARE EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM 22,937.78 283,103.37 278,400.00 ( 4,703.37) 101.7 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 44,210.82 1,758,678.36 1,750,000.00 ( 8,678.36) 100.5 39-5390-1058 HEALTH CARE - FEE 7,743.12 95,260.64 201,600.00 106,339.36 47.3 TOTAL EMPLOYEE BENEFITS 74,891.72 2,137,042.37 2,230,000.00 92,957.63 95.8 TOTAL EMPLOYEE HEALTH CARE 74,891.72 2,137,042.37 2,230,000.00 92,957.63 95.8 TOTAL FUND EXPENDITURES 74,891.72 2,137,042.37 2,230,000.00 92,957.63 95.8 NET REVENUE OVER EXPENDITURES 117,185.97 46,846.27 ( 4,650.00) ( 51,496.27) 1007.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:52AM PAGE:60 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 25,880.08 TOTAL CASH 25,880.08 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 311,355.54 TOTAL INVESTMENTS 311,355.54 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 272.46 TOTAL ACCOUNTS RECEIVABLE 272.46 TOTAL CURRENT ASSETS 337,508.08 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 337,508.08 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 334,694.91 TOTAL CAPITAL ASSETS 334,694.91 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,813.17 BALANCE - CURRENT DATE 337,508.08 TOTAL NET ASSETS 337,508.08 TOTAL LIABILITIES AND NET ASSETS 337,508.08 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:52AM PAGE:61 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 8.69 2,813.17 1,500.00 ( 1,313.17) 187.5 TOTAL MISC LOCAL REVENUE 8.69 2,813.17 1,500.00 ( 1,313.17) 187.5 TOTAL CAPITAL IMP RESERVE - REVENUE 8.69 2,813.17 1,500.00 ( 1,313.17) 187.5 TOTAL FUND REVENUE 8.69 2,813.17 1,500.00 ( 1,313.17) 187.5 NET REVENUE OVER EXPENDITURES 8.69 2,813.17 1,500.00 ( 1,313.17) 187.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:57AM PAGE:62 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 83,659.69 TOTAL CASH 83,659.69 TOTAL CURRENT ASSETS 83,659.69 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 83,659.69 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 41-20000201 ACCOUNTS PAY ALLOC TO FUNDS 11,519.70 TOTAL ACCOUNTS PAYABLE 11,519.70 TOTAL CURRENT LIABILITIES 11,519.70 TOTAL LIABILITIES 11,519.70 NET ASSETS OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 72,139.99 BALANCE - CURRENT DATE 72,139.99 TOTAL NET ASSETS 72,139.99 TOTAL LIABILITIES AND NET ASSETS 83,659.69 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 11:57AM PAGE:63 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 24.52 109.69 .00 ( 109.69) .0 TOTAL MISC LOCAL REVENUE 24.52 109.69 .00 ( 109.69) .0 TRANSFERS IN: 41-4410-5510 TRANSFER FROM GENERAL FUND 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL TRANSFERS IN 25,000.00 100,000.00 100,000.00 .00 100.0 TOTAL ECONOMIC DEVELOPMENT 25,024.52 100,109.69 100,000.00 ( 109.69) 100.1 TOTAL FUND REVENUE 25,024.52 100,109.69 100,000.00 ( 109.69) 100.1 ECONOMIC DEVELOPMENT PROFESSIONAL SERVICES: 41-5410-2158 MISC CONTRACTUAL SERVICES .00 3,250.00 .00 ( 3,250.00) .0 TOTAL PROFESSIONAL SERVICES .00 3,250.00 .00 ( 3,250.00) .0 CAPITALIZED EXPENDITURES: 41-5410-6547 EQUIPMENT/FURNITURE 11,519.70 24,719.70 .00 ( 24,719.70) .0 TOTAL CAPITALIZED EXPENDITURES 11,519.70 24,719.70 .00 ( 24,719.70) .0 TOTAL ECONOMIC DEVELOPMENT 11,519.70 27,969.70 .00 ( 27,969.70) .0 TOTAL FUND EXPENDITURES 11,519.70 27,969.70 .00 ( 27,969.70) .0 NET REVENUE OVER EXPENDITURES 13,504.82 72,139.99 100,000.00 27,860.01 72.1 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:08PM PAGE:64 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND 143,122.95 TOTAL CASH 143,122.95 INVESTMENTS: 47-10000122 TIME DEPOSITS - SHORT TERM 351,527.19 TOTAL INVESTMENTS 351,527.19 ACCOUNTS RECEIVABLE: 47-10000139 ACCRUED INTEREST RECEIVABLE 281.85 TOTAL ACCOUNTS RECEIVABLE 281.85 TOTAL CURRENT ASSETS 494,931.99 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 494,931.99 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 47-20000201 ALLOCATION FROM AP FUND 2,300.00 TOTAL ACCOUNTS PAYABLE 2,300.00 TOTAL CURRENT LIABILITIES 2,300.00 TOTAL LIABILITIES 2,300.00 NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR 500,665.15 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS 721,906.02 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:08PM PAGE:65 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 229,274.03) BALANCE - CURRENT DATE 492,631.99 TOTAL NET ASSETS 492,631.99 TOTAL LIABILITIES AND NET ASSETS 494,931.99 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:08PM PAGE:66 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME 69.41 4,279.50 1,500.00 ( 2,779.50) 285.3 TOTAL MISC LOCAL REVENUE 69.41 4,279.50 1,500.00 ( 2,779.50) 285.3 TOTAL GENERAL FUND EQUIP RES-REVENUE 69.41 4,279.50 1,500.00 ( 2,779.50) 285.3 TOTAL FUND REVENUE 69.41 4,279.50 1,500.00 ( 2,779.50) 285.3 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE 2,300.00 75,801.85 86,634.00 10,832.15 87.5 47-5470-6548 VEHICLES .00 157,751.68 236,448.00 78,696.32 66.7 TOTAL CAPITALIZED EXPENDITURES 2,300.00 233,553.53 323,082.00 89,528.47 72.3 TOTAL GENERAL FUND EQUIPMENT RESERVE 2,300.00 233,553.53 323,082.00 89,528.47 72.3 TOTAL FUND EXPENDITURES 2,300.00 233,553.53 323,082.00 89,528.47 72.3 NET REVENUE OVER EXPENDITURES ( 2,230.59) ( 229,274.03) ( 321,582.00) ( 92,307.97) ( 71.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:23PM PAGE:67 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 15,975.39 TOTAL CASH 15,975.39 TOTAL CURRENT ASSETS 15,975.39 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 15,975.39 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR 59,211.94 50-30000301 RESERVED FUND BALANCE 155,959.63 TOTAL CAPITAL ASSETS 215,171.57 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 199,196.18) BALANCE - CURRENT DATE 15,975.39 TOTAL NET ASSETS 15,975.39 TOTAL LIABILITIES AND NET ASSETS 15,975.39 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:23PM PAGE:68 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1140 INTEREST INCOME 1.19 803.82 500.00 ( 303.82) 160.8 TOTAL MISC LOCAL REVENUE 1.19 803.82 500.00 ( 303.82) 160.8 TRANSFERS IN: 50-4500-5510 TRANSFER FROM GENERAL FUND 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL TRANSFERS IN 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL FIRE EQUIPMENT - REVENUE 12,501.19 50,803.82 50,500.00 ( 303.82) 100.6 TOTAL FUND REVENUE 12,501.19 50,803.82 50,500.00 ( 303.82) 100.6 FIRE EQUIPMENT CASH FUND APPROPRIATION: 50-5500-0150 REPLACEMENT RESERVE .00 .00 50,000.00 50,000.00 .0 TOTAL CASH FUND APPROP .00 .00 50,000.00 50,000.00 .0 CAPITALIZED EXPENDITURES: 50-5500-6547 EQUIPMENT/FURNITURE .00 250,000.00 250,000.00 .00 100.0 TOTAL CAPITALIZED EXPENDITURES .00 250,000.00 250,000.00 .00 100.0 TOTAL FIRE EQUIPMENT .00 250,000.00 300,000.00 50,000.00 83.3 TOTAL FUND EXPENDITURES .00 250,000.00 300,000.00 50,000.00 83.3 NET REVENUE OVER EXPENDITURES 12,501.19 ( 199,196.18) ( 249,500.00) ( 50,303.82) ( 79.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:34PM PAGE:69 ASSETS CURRENT ASSETS: CASH: 53-10000116 CASH ALLOC FR COMBINED FUND 2,811.66 TOTAL CASH 2,811.66 TOTAL CURRENT ASSETS 2,811.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,811.66 LIABILITIES AND EQUITY LIABILITIES 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 BALANCE SHEET JUNE 30, 2018 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:36PM PAGE:70 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 57,677.77 TOTAL CASH 57,677.77 TOTAL CURRENT ASSETS 57,677.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 57,677.77 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 57,677.77 TOTAL CAPITAL ASSETS 57,677.77 TOTAL NET ASSETS 57,677.77 TOTAL LIABILITIES AND NET ASSETS 57,677.77 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:37PM PAGE:71 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE .00 .00 5,000.00 5,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 5,000.00 5,000.00 .0 TOTAL TRAIN CAR RESTORATION .00 .00 5,000.00 5,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 5,000.00 5,000.00 .0 NET REVENUE OVER EXPENDITURES .00 .00 ( 5,000.00) ( 5,000.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:37PM PAGE:72 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 183,663.86 TOTAL CASH 183,663.86 TOTAL CURRENT ASSETS 183,663.86 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 183,663.86 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 183,663.86 TOTAL CAPITAL ASSETS 183,663.86 TOTAL NET ASSETS 183,663.86 TOTAL LIABILITIES AND NET ASSETS 183,663.86 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:41PM PAGE:73 POOL IMPROVEMENTS CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG .00 .00 8,500.00 8,500.00 .0 TOTAL CAPITALIZED EXPENDITURES .00 .00 8,500.00 8,500.00 .0 TOTAL POOL IMPROVEMENTS .00 .00 8,500.00 8,500.00 .0 TOTAL FUND EXPENDITURES .00 .00 8,500.00 8,500.00 .0 NET REVENUE OVER EXPENDITURES .00 .00 ( 8,500.00) ( 8,500.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:41PM PAGE:74 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 153,203.04 TOTAL CASH 153,203.04 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 6,419,633.09 TOTAL INVESTMENTS 6,419,633.09 ACCOUNTS RECEIVABLE: 56-10000131 ACCOUNTS RECEIVABLE - GENERAL 133,260.91 56-10000139 ACCRUED INTEREST RECEIVABLE 4,494.95 56-10000156 DUE FROM OTHER FUNDS 10,588.59 TOTAL ACCOUNTS RECEIVABLE 148,344.45 TOTAL CURRENT ASSETS 6,721,180.58 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 6,721,180.58 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 640,027.61 56-20000204 ACCOUNTS PAYABLE - EOY 30,022.87 56-20000210 RETAINAGE PAYABLE 44,587.58 TOTAL ACCOUNTS PAYABLE 714,638.06 TOTAL CURRENT LIABILITIES 714,638.06 TOTAL LIABILITIES 714,638.06 NET ASSETS CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 7,169,084.13 TOTAL CAPITAL ASSETS 7,169,084.13 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:41PM PAGE:75 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1,162,541.61) BALANCE - CURRENT DATE 6,006,542.52 TOTAL NET ASSETS 6,006,542.52 TOTAL LIABILITIES AND NET ASSETS 6,721,180.58 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:41PM PAGE:76 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1140 INTEREST INCOME .00 55,647.54 39,500.00 ( 16,147.54) 140.9 TOTAL MISC LOCAL REVENUE .00 55,647.54 39,500.00 ( 16,147.54) 140.9 STATE REVENUE: 56-4560-3374 SLIB 133,260.91 300,152.98 165,000.00 ( 135,152.98) 181.9 TOTAL STATE REVENUE 133,260.91 300,152.98 165,000.00 ( 135,152.98) 181.9 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND .00 .00 675,000.00 675,000.00 .0 TOTAL TRANSFERS IN .00 .00 675,000.00 675,000.00 .0 TOTAL STREET IMPROVEMENTS-REVENUE 133,260.91 355,800.52 879,500.00 523,699.48 40.5 TOTAL FUND REVENUE 133,260.91 355,800.52 879,500.00 523,699.48 40.5 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 30,154.54 148,332.53 240,000.00 91,667.47 61.8 56-5560-2158 MISC CONTRACTUAL SERVICES 2,070.40 27,125.44 50,000.00 22,874.56 54.3 TOTAL PROFESSIONAL SERVICES 32,224.94 175,457.97 290,000.00 114,542.03 60.5 CAPITALIZED EXPENDITURES: 56-5560-6544 OTHER THAN BLDG 625,486.09 1,342,884.16 2,950,000.00 1,607,115.84 45.5 TOTAL CAPITALIZED EXPENDITURES 625,486.09 1,342,884.16 2,950,000.00 1,607,115.84 45.5 TOTAL STREET IMPROVEMENTS 657,711.03 1,518,342.13 3,240,000.00 1,721,657.87 46.9 TOTAL FUND EXPENDITURES 657,711.03 1,518,342.13 3,240,000.00 1,721,657.87 46.9 NET REVENUE OVER EXPENDITURES ( 524,450.12) ( 1,162,541.61) ( 2,360,500.00) ( 1,197,958.39) ( 49.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:45PM PAGE:77 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 2,639,055.19 TOTAL CASH 2,639,055.19 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 478.22 TOTAL ACCOUNTS RECEIVABLE 478.22 TOTAL CURRENT ASSETS 2,639,533.41 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,639,533.41 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 199,953.41 57-20000204 ACCOUNTS PAYABLE - EOY 402,514.04 TOTAL ACCOUNTS PAYABLE 602,467.45 TOTAL CURRENT LIABILITIES 602,467.45 TOTAL LIABILITIES 602,467.45 NET ASSETS CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 3,992,417.29 57-30000305 FUND BALANCE RESERVE-PW FACILI 200,000.00 TOTAL CAPITAL ASSETS 4,192,417.29 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:45PM PAGE:78 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 2,155,351.33) BALANCE - CURRENT DATE 2,037,065.96 TOTAL NET ASSETS 2,037,065.96 TOTAL LIABILITIES AND NET ASSETS 2,639,533.41 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 12:45PM PAGE:79 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME .00 19,305.32 19,000.00 ( 305.32) 101.6 TOTAL MISC LOCAL REVENUE .00 19,305.32 19,000.00 ( 305.32) 101.6 TRANSFERS IN: 57-4570-5510 TRANSFER FROM GENERAL FUND 187,500.00 750,000.00 75,000.00 ( 675,000.00) 1000.0 TOTAL TRANSFERS IN 187,500.00 750,000.00 75,000.00 ( 675,000.00) 1000.0 TOTAL CAPITAL IMP - FACILITIES REV 187,500.00 769,305.32 94,000.00 ( 675,305.32) 818.4 TOTAL FUND REVENUE 187,500.00 769,305.32 94,000.00 ( 675,305.32) 818.4 CAPITAL IMP -FACILITIES PROFESSIONAL SERVICES: 57-5570-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 10,000.00 10,000.00 .0 57-5570-2158 MISC CONTRACTUAL SERVICES .00 66,168.00 1,890,000.00 1,823,832.00 3.5 TOTAL PROFESSIONAL SERVICES .00 66,168.00 1,900,000.00 1,833,832.00 3.5 CAPITALIZED EXPENDITURES: 57-5570-6542 BUILDINGS/IMPROVEMENTS .00 7,949.00 137,200.00 129,251.00 5.8 57-5570-6544 OTHER THAN BLDG 199,953.41 2,850,539.65 20,000.00 ( 2,830,539.65) 14252.7 TOTAL CAPITALIZED EXPENDITURES 199,953.41 2,858,488.65 157,200.00 ( 2,701,288.65) 1818.4 TOTAL CAPITAL IMP -FACILITIES 199,953.41 2,924,656.65 2,057,200.00 ( 867,456.65) 142.2 TOTAL FUND EXPENDITURES 199,953.41 2,924,656.65 2,057,200.00 ( 867,456.65) 142.2 NET REVENUE OVER EXPENDITURES ( 12,453.41) ( 2,155,351.33) ( 1,963,200.00) 192,151.33 ( 109.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:02PM PAGE:80 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND ( 241,587.15) TOTAL CASH ( 241,587.15) INVESTMENTS: 65-10000122 TIME DEPOSITS - SHORT TERM 1,153,278.15 TOTAL INVESTMENTS 1,153,278.15 ACCOUNTS RECEIVABLE: 65-10000139 ACCRUED INTEREST RECEIVABLE 625.17 TOTAL ACCOUNTS RECEIVABLE 625.17 TOTAL CURRENT ASSETS 912,316.17 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 912,316.17 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 56,161.90 65-20000210 RETAINAGE PAYABLE 40,792.10 TOTAL ACCOUNTS PAYABLE 96,954.00 DUE TO OTHER FUNDS: 65-20000245 DUE TO OTHER FUND 10,588.59 TOTAL DUE TO OTHER FUNDS 10,588.59 TOTAL CURRENT LIABILITIES 107,542.59 TOTAL LIABILITIES 107,542.59 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:02PM PAGE:81 CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 1,287,559.43 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 1,310,475.32 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 505,701.74) BALANCE - CURRENT DATE 804,773.58 TOTAL NET ASSETS 804,773.58 TOTAL LIABILITIES AND NET ASSETS 912,316.17 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:02PM PAGE:82 PARK - REVE MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME .00 9,930.67 6,900.00 ( 3,030.67) 143.9 TOTAL MISC LOCAL REVENUE .00 9,930.67 6,900.00 ( 3,030.67) 143.9 CONTRIBUTIONS: 65-4650-1550 CONTRIBUTIONS .00 65,000.00 65,000.00 .00 100.0 TOTAL CONTRIBUTIONS .00 65,000.00 65,000.00 .00 100.0 TOTAL PARK - REVE .00 74,930.67 71,900.00 ( 3,030.67) 104.2 TOTAL FUND REVENUE .00 74,930.67 71,900.00 ( 3,030.67) 104.2 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY 11,489.40 55,476.40 60,000.00 4,523.60 92.5 TOTAL PROFESSIONAL SERVICES 11,489.40 55,476.40 60,000.00 4,523.60 92.5 CAPITALIZED EXPENDITURES: 65-5650-6544 OTHER THAN BLDG 48,975.00 525,156.01 594,500.00 69,343.99 88.3 TOTAL CAPITALIZED EXPENDITURES 48,975.00 525,156.01 594,500.00 69,343.99 88.3 TOTAL PARK IMPROVEMENTS 60,464.40 580,632.41 654,500.00 73,867.59 88.7 TOTAL FUND EXPENDITURES 60,464.40 580,632.41 654,500.00 73,867.59 88.7 NET REVENUE OVER EXPENDITURES ( 60,464.40) ( 505,701.74) ( 582,600.00) ( 76,898.26) ( 86.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:34PM PAGE:83 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 17,185.05 TOTAL CASH 17,185.05 INVESTMENTS: 90-10000120 INVESTMENT POOL 107,135.94 90-10000122 TIME DEPOSITS - SHORT TERM 40,052.14 TOTAL INVESTMENTS 147,188.08 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 38.21 TOTAL ACCOUNTS RECEIVABLE 38.21 TOTAL CURRENT ASSETS 164,411.34 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 164,411.34 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 20,150.94 TOTAL CAPITAL ASSETS 20,150.94 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,650.00 BALANCE - CURRENT DATE 164,411.34 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:34PM PAGE:84 TOTAL NET ASSETS 164,411.34 TOTAL LIABILITIES AND NET ASSETS 164,411.34 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:34PM PAGE:85 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES 200.00 2,650.00 2,350.00 ( 300.00) 112.8 TOTAL REVENUE 200.00 2,650.00 2,350.00 ( 300.00) 112.8 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 141.53 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL MISC LOCAL REVENUE 141.53 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL PERPETUAL CARE - REVENUE 341.53 4,291.15 3,650.00 ( 641.15) 117.6 TOTAL FUND REVENUE 341.53 4,291.15 3,650.00 ( 641.15) 117.6 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 521.67 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL TRANSFERS TO OTHER FUNDS 521.67 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL PERPETUAL CARE 521.67 1,641.15 1,300.00 ( 341.15) 126.2 TOTAL FUND EXPENDITURES 521.67 1,641.15 1,300.00 ( 341.15) 126.2 NET REVENUE OVER EXPENDITURES ( 180.14) 2,650.00 2,350.00 ( 300.00) 112.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:34PM PAGE:86 ASSETS CURRENT ASSETS: CASH: 91-10000116 CASH ALLOC FR COMBINED FUND 2.75 TOTAL CASH 2.75 TOTAL CURRENT ASSETS 2.75 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2.75 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 91-20000401 ONGOING MEMORIAL FUND 2.75 TOTAL OTHER PAYABLES 2.75 TOTAL CURRENT LIABILITIES 2.75 TOTAL LIABILITIES 2.75 TOTAL LIABILITIES AND NET ASSETS 2.75 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:35PM PAGE:87 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 14,081.88 TOTAL CASH 14,081.88 TOTAL CURRENT ASSETS 14,081.88 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 14,081.88 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 92-20000201 ACCOUNTS PAY ALLOC TO FUNDS 520.53 TOTAL ACCOUNTS PAYABLE 520.53 OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 3,559.54 92-20000406 HISTORIC PRESERVATION 4,947.13 92-20000407 HISTORIC PRESERVATION-KIOSK 16,789.30 92-20000408 HISTORIC PRESERVATION - MOVIE 615.38 TOTAL OTHER PAYABLES 25,911.35 TOTAL CURRENT LIABILITIES 26,431.88 TOTAL LIABILITIES 26,431.88 NET ASSETS CAPITAL ASSETS: 92-30000300 FUND BALANCE/BEGINNING OF YEAR ( 13,750.00) TOTAL CAPITAL ASSETS ( 13,750.00) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:35PM PAGE:88 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,400.00 BALANCE - CURRENT DATE ( 12,350.00) TOTAL NET ASSETS ( 12,350.00) TOTAL LIABILITIES AND NET ASSETS 14,081.88 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:35PM PAGE:89 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 350.00 1,400.00 1,400.00 .00 100.0 TOTAL TRANSFERS IN 350.00 1,400.00 1,400.00 .00 100.0 TOTAL HISTORIC CMSN - REVENU 350.00 1,400.00 1,400.00 .00 100.0 TOTAL FUND REVENUE 350.00 1,400.00 1,400.00 .00 100.0 NET REVENUE OVER EXPENDITURES 350.00 1,400.00 1,400.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:36PM PAGE:90 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 32,282.51 TOTAL CASH 32,282.51 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 55,078.21 TOTAL INVESTMENTS 55,078.21 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 52.42 TOTAL ACCOUNTS RECEIVABLE 52.42 TOTAL CURRENT ASSETS 87,413.14 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 87,413.14 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 225.58 TOTAL ACCOUNTS PAYABLE 225.58 UTILITY DEPOSITS PAYABLE: 96-20000229 UTILITY DEPOSITS 80,045.75 TOTAL UTILITY DEPOSITS PAYABLE 80,045.75 TOTAL CURRENT LIABILITIES 80,271.33 TOTAL LIABILITIES 80,271.33 NET ASSETS CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 7,141.81 TOTAL CAPITAL ASSETS 7,141.81 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:36PM PAGE:91 TOTAL NET ASSETS 7,141.81 TOTAL LIABILITIES AND NET ASSETS 87,413.14 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2018 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:36PM PAGE:92 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME .00 429.25 200.00 ( 229.25) 214.6 TOTAL MISC LOCAL REVENUE .00 429.25 200.00 ( 229.25) 214.6 TOTAL UTILITY DEPOSITS - REVENUE .00 429.25 200.00 ( 229.25) 214.6 TOTAL FUND REVENUE .00 429.25 200.00 ( 229.25) 214.6 UTILITY DEPOSIT TRANSFERS TO OTHER FUNDS: 96-5960-5531 TRANSFER TO WATER 111.71 429.25 200.00 ( 229.25) 214.6 TOTAL TRANSFERS TO OTHER FUNDS 111.71 429.25 200.00 ( 229.25) 214.6 TOTAL UTILITY DEPOSIT 111.71 429.25 200.00 ( 229.25) 214.6 TOTAL FUND EXPENDITURES 111.71 429.25 200.00 ( 229.25) 214.6 NET REVENUE OVER EXPENDITURES ( 111.71) .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2018 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/02/2018 01:36PM PAGE:93 ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS: INVESTMENTS: 97-10000173 SECURITIES - LONG TERM 4,521,399.12 97-10000174 INVESTMENTS - RHSA 417,406.75 TOTAL INVESTMENTS 4,938,805.87 TOTAL NON-CURRENT ASSETS 4,938,805.87 TOTAL ASSETS 4,938,805.87 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 97-30000300 FUND BALANCE/BEGINNING OF YEAR 4,938,805.87 TOTAL CAPITAL ASSETS 4,938,805.87 TOTAL NET ASSETS 4,938,805.87 TOTAL LIABILITIES AND NET ASSETS 4,938,805.87