Full Text
CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2019 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:31AM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 12,643,387.67 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 127,934.91 01-10000113 CASH ON HAND 750.00 TOTAL COMBINED CASH 12,772,072.58 01-20000201 ACCOUNTS PAY ALLOC TO FUNDS ( 14.21) 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 12,772,058.37) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND 6,135,813.11 11 ALLOCATION TO IMPACT ASSISTANCE FUND 21,526.49 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 18,510.53 31 ALLOCATION TO WATER FUND 801,642.92 32 ALLOCATION TO SEWER FUND 1,111,804.97 33 ALLOCATION TO SANITATION FUND 207,915.43 34 ALLOCATION TO LANDFILL FUND 321,556.13 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 414,665.91 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 26,052.55 41 ALLOCATION TO ECONOMIC DEVELOPMENT 186,409.13 42 ALLOCATION TO BROWNFIELD GRANT ( 24,606.79) 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE ( 22,248.58) 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 116,302.97 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 2,811.66 54 ALLOCATION TO TRAIN CAR RESTORATION 52,677.77 55 ALLOCATION TO POOL IMPROVEMENTS FUND 127,313.86 56 ALLOCATION TO STREET IMPROVEMENT FUND 2,545,256.42 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 393,438.16 65 ALLOCATION TO CAPTL PROJ-PARK FUND 238,248.03 90 ALLOCATION TO PERPETUAL CARE FUND 35,874.46 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 2.75 92 ALLOCATION TO HISTORIC CMSN FUND 14,234.32 96 ALLOCATION TO UTILITY DEPOSIT FUND 46,856.17 TOTAL ALLOCATIONS TO OTHER FUNDS 12,772,058.37 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 12,772,058.37) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:31AM PAGE:2 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 6,135,813.11 TOTAL CASH 6,135,813.11 INVESTMENTS: 10-10000120 INVESTMENT POOL 8,039,681.97 10-10000122 TIME DEPOSITS - SHORT TERM 15,205,365.75 TOTAL INVESTMENTS 23,245,047.72 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 35,465.28 10-10000131 ACCOUNTS RECEIVABLE - GENERAL 37,968.10 10-10000132 ACCOUNTS REC - PROPERTY TAX 475,541.71 10-10000133 ACCOUNTS CRT 10,952.65 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 2,116,803.42 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 842.97 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 18,862.32) 10-10000139 ACCRUED INTEREST RECEIVABLE 20,460.18 TOTAL ACCOUNTS RECEIVABLE 2,679,171.99 TOTAL CURRENT ASSETS 32,060,032.82 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 32,060,032.82 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 10-20000200 DEFERRED INFLOW 435,239.26 10-20000201 ALLOCATION FROM AP FUND 294,198.70 10-20000204 ACCOUNTS PAYABLE - EOY 14,612.44 10-20000207 SALES TAX PAYABLE 208.36 10-20000215 WAGES PAYABLE 113,167.01 10-20000216 WAGES PAYABLE - EOY 9,798.12 TOTAL ACCOUNTS PAYABLE 867,223.89 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:31AM PAGE:3 PAYROLL DEDUCTIONS PAYABLE: 10-20000223 FICA PAYABLE 2.27 10-20000224 DEFERRED COMPENSATION PAYABLE 48,595.26 10-20000227 WORKERS COMP INS PAYABLE 18,962.99 TOTAL PAYROLL DEDUCTIONS PAYABLE 67,560.52 UTILITY DEPOSITS PAYABLE: 10-20000229 UNCLAIMED PROPERTY 1,854.97 TOTAL UTILITY DEPOSITS PAYABLE 1,854.97 DUE TO OTHER FUNDS: 10-20000245 DUE TO OTHER FUNDS 45,475.77 TOTAL DUE TO OTHER FUNDS 45,475.77 TOTAL CURRENT LIABILITIES 982,115.15 TOTAL LIABILITIES 982,115.15 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 20,168,000.55 10-30000301 FUND BALANCE RESERVE 1,970,000.00 TOTAL CAPITAL ASSETS 22,138,000.55 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 8,939,917.12 BALANCE - CURRENT DATE 31,077,917.67 TOTAL NET ASSETS 31,077,917.67 TOTAL LIABILITIES AND NET ASSETS 32,060,032.82 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:31AM PAGE:4 GENERAL - REVENUE MISC LOCAL REVENUE: 10-4100-1101 REIMBURSEMENT - CCSD 4,866.79 58,401.48 49,988.00 ( 8,413.48) 116.8 10-4100-1107 OTHER 997.85 14,763.71 14,250.00 ( 513.71) 103.6 10-4100-1108 COPY FEES/VIN CHECKS 485.00 5,020.00 4,725.00 ( 295.00) 106.2 10-4100-1109 REIMBURSEMENTS 32,264.45 147,238.86 115,000.00 ( 32,238.86) 128.0 10-4100-1112 CONTRIBUTIONS .00 14,454.37 14,250.00 ( 204.37) 101.4 10-4100-1115 LEASES/RENT 300.00 4,300.00 4,000.00 ( 300.00) 107.5 10-4100-1120 FINES/FORFEITS 2,949.00 41,431.50 41,000.00 ( 431.50) 101.1 10-4100-1122 TECHNOLOGY SURCHARGE 760.00 10,395.00 10,000.00 ( 395.00) 104.0 10-4100-1130 CASH LONG/SHORT 10.00 25.50 .00 ( 25.50) .0 10-4100-1140 INTEREST INCOME 78,364.15 355,622.98 275,000.00 ( 80,622.98) 129.3 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI 763.75 3,371.95 2,750.00 ( 621.95) 122.6 TOTAL MISC LOCAL REVENUE 121,760.99 655,025.35 530,963.00 ( 124,062.35) 123.4 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 300.00 20,325.00 20,000.00 ( 325.00) 101.6 TOTAL LIQUOR LICENSES 300.00 20,325.00 20,000.00 ( 325.00) 101.6 OTHER LICENSES/PERMITS: 10-4100-1230 LICENSES - TRANSIENT MERCHANT .00 .00 100.00 100.00 .0 TOTAL OTHER LICENSES/PERMITS .00 .00 100.00 100.00 .0 CONTRACTORS LICENSES: 10-4100-1241 LICENSES - CONTRACTORS 445.00 14,297.00 14,000.00 ( 297.00) 102.1 TOTAL CONTRACTORS LICENSES 445.00 14,297.00 14,000.00 ( 297.00) 102.1 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 3,141.57 30,446.86 27,500.00 ( 2,946.86) 110.7 TOTAL BUILDING PERMITS 3,141.57 30,446.86 27,500.00 ( 2,946.86) 110.7 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 150.00 3,040.00 3,000.00 ( 40.00) 101.3 TOTAL ZONING/CONDITIONAL USE 150.00 3,040.00 3,000.00 ( 40.00) 101.3 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 112,941.69 439,938.83 450,000.00 10,061.17 97.8 10-4100-1321 PROPERTY TAX - PRIOR YEARS 259.24 2,493.90 2,750.00 256.10 90.7 10-4100-1322 PROPERTY TAX - AUTO 17,597.40 182,414.91 182,000.00 ( 414.91) 100.2 10-4100-1323 PROPERTY TAX - INTEREST 15.28 1,200.88 1,500.00 299.12 80.1 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 653.99) ( 3,121.77) ( 3,200.00) ( 78.23) ( 97.6) TOTAL PROPERTY TAXES 130,159.62 622,926.75 633,050.00 10,123.25 98.4 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:31AM PAGE:5 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 17,189.99 229,567.33 225,000.00 ( 4,567.33) 102.0 10-4100-1331 FRANCHISE FEES - CABLE TV .00 14,650.19 15,000.00 349.81 97.7 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 35,516.77 35,000.00 ( 516.77) 101.5 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 4,872.64 6,000.00 1,127.36 81.2 TOTAL FRANCHISE FEES 17,189.99 284,606.93 281,000.00 ( 3,606.93) 101.3 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 24,469.50 97,878.00 97,878.00 .00 100.0 10-4100-1421 MANAGEMENT FEES - WATER 63,711.25 254,845.00 254,845.00 .00 100.0 10-4100-1422 MANAGEMENT FEES - SEWER 35,586.50 142,346.00 142,346.00 .00 100.0 10-4100-1423 MANAGEMENT FEES - SANITATION 13,692.25 54,769.00 54,769.00 .00 100.0 TOTAL MANAGEMENT FEES 137,459.50 549,838.00 549,838.00 .00 100.0 WEED ABATEMENT: 10-4100-1430 WEED MOWING CHARGES 104.08 290.64 .00 ( 290.64) .0 10-4100-1431 PEST CONTROL .00 14,517.90 14,000.00 ( 517.90) 103.7 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 35,947.02 35,000.00 ( 947.02) 102.7 TOTAL WEED ABATEMENT 104.08 50,755.56 49,000.00 ( 1,755.56) 103.6 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 2,050.00 14,050.00 13,000.00 ( 1,050.00) 108.1 TOTAL BURIAL FEES 2,050.00 14,050.00 13,000.00 ( 1,050.00) 108.1 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 600.00 8,300.00 7,500.00 ( 800.00) 110.7 TOTAL LOT SALES 600.00 8,300.00 7,500.00 ( 800.00) 110.7 POOL: 10-4100-1650 POOL - USER FEES 14,964.60 28,990.60 22,500.00 ( 6,490.60) 128.9 10-4100-1651 POOL - CONCESSION 8,383.50 17,466.46 13,500.00 ( 3,966.46) 129.4 TOTAL POOL 23,348.10 46,457.06 36,000.00 ( 10,457.06) 129.1 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 302,876.90 300,000.00 ( 2,876.90) 101.0 10-4100-3111 SEVERENCE TAX - 2% .00 170,056.50 227,000.00 56,943.50 74.9 10-4100-3112 MINERAL ROYALTIES 127,008.62 352,977.98 312,000.00 ( 40,977.98) 113.1 TOTAL MINERAL EXTRACTION 127,008.62 825,911.38 839,000.00 13,088.62 98.4 SALES TAX: 10-4100-3241 SALES TAX - STATE 837,428.12 8,985,091.43 8,900,000.00 ( 85,091.43) 101.0 10-4100-3245 SALES TAX - LOCAL OPTION 681,067.26 7,320,656.27 7,300,000.00 ( 20,656.27) 100.3 TOTAL SALES TAX 1,518,495.38 16,305,747.70 16,200,000.00 ( 105,747.70) 100.7 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:31AM PAGE:6 GAS TAX: 10-4100-3250 LOTTERY .00 79,370.57 79,000.00 ( 370.57) 100.5 10-4100-3257 GAS TAX 21,000.98 236,217.26 215,000.00 ( 21,217.26) 109.9 10-4100-3258 SPECIAL FUELS 5,054.14 65,643.04 60,000.00 ( 5,643.04) 109.4 TOTAL GAS TAX 26,055.12 381,230.87 354,000.00 ( 27,230.87) 107.7 OTHER: 10-4100-3262 CIGARETTE TAX 4,666.45 53,267.07 45,000.00 ( 8,267.07) 118.4 TOTAL OTHER 4,666.45 53,267.07 45,000.00 ( 8,267.07) 118.4 TOTAL GENERAL - REVENUE 2,112,934.42 19,866,225.53 19,602,951.00 ( 263,274.53) 101.3 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 912.33 3,033.01 2,150.00 ( 883.01) 141.1 TOTAL OPERATING TRANSFERS IN 912.33 3,033.01 2,150.00 ( 883.01) 141.1 TOTAL OPERATING TRANSFERS - IN 912.33 3,033.01 2,150.00 ( 883.01) 141.1 TOTAL FUND REVENUE 2,113,846.75 19,869,258.54 19,605,101.00 ( 264,157.54) 101.4 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 83.73 381.20 150.00 ( 231.20) 254.1 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 160.00 2,090.00 6,000.00 3,910.00 34.8 TOTAL EMPLOYEE BENEFITS 243.73 2,471.20 6,150.00 3,678.80 40.2 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT 810.19 4,988.87 6,500.00 1,511.13 76.8 10-5100-2115 PUBLISHING/ADVERTISING 10,146.75 34,973.00 40,000.00 5,027.00 87.4 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 170.00 500.00 330.00 34.0 TOTAL PURCHASED SERVICES 10,956.94 40,131.87 47,000.00 6,868.13 85.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:31AM PAGE:7 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 6,720.97 82,886.48 90,000.00 7,113.52 92.1 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 530.58 3,543.85 4,000.00 456.15 88.6 10-5100-2133 UTILITY SERVICES - NATURAL GAS 154.40 3,254.30 3,000.00 ( 254.30) 108.5 10-5100-2134 TELECOMMUNICATIONS 313.69 9,002.35 9,250.00 247.65 97.3 10-5100-2141 EQUIPMENT - RENT 189.96 189.96 250.00 60.04 76.0 TOTAL PROPERTY SERVICES 7,909.60 98,876.94 106,500.00 7,623.06 92.8 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 2,865.30 43,140.60 50,000.00 6,859.40 86.3 10-5100-2152 ACCOUNTING/AUDITING .00 37,750.00 40,000.00 2,250.00 94.4 10-5100-2153 ARCHITECHT/ENGINEERING/SURVEY .00 287.50 2,500.00 2,212.50 11.5 10-5100-2155 REPAIRS/MAINTENANCE 828.70 7,266.58 7,300.00 33.42 99.5 10-5100-2156 MAINTENANCE AGREEMENT 221.00 9,607.89 11,500.00 1,892.11 83.6 10-5100-2157 INSURANCE .00 74,803.00 75,000.00 197.00 99.7 10-5100-2158 MISC CONTRACTUAL SERVICES 35,274.58 80,566.68 47,750.00 ( 32,816.68) 168.7 10-5100-2166 COLLECTION FEES .00 .00 100.00 100.00 .0 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 7,465.00 7,465.00 .00 100.0 TOTAL PROFESSIONAL SERVICES 39,189.58 260,887.25 241,615.00 ( 19,272.25) 108.0 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 408.91 10,942.44 13,500.00 2,557.56 81.1 10-5100-3210 OPERATING SUPPLIES 1,834.81 10,944.98 15,000.00 4,055.02 73.0 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5100-3230 REFRESHMENT SUPPLIES 162.97 1,866.91 2,000.00 133.09 93.4 10-5100-3235 FUEL 10,226.32 114,372.30 150,000.00 35,627.70 76.3 TOTAL SUPPLIES 12,633.01 138,126.63 181,500.00 43,373.37 76.1 CLAIMS & CONTINGENCY: 10-5100-7601 CLAIMS AGAINST CITY .00 .00 5,000.00 5,000.00 .0 10-5100-7606 UNEMPLOYMENT CLAIMS .00 .00 6,000.00 6,000.00 .0 TOTAL CLAIMS & CONTINGENCY .00 .00 11,000.00 11,000.00 .0 TOTAL GENERAL GOVT - NON DEPARTMENTL 70,932.86 540,493.89 893,765.00 353,271.11 60.5 GENERAL GOVT - CITY COUNCIL PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 1,375.00 12,125.00 12,125.00 .00 100.0 TOTAL PERSONNEL SERVICES 1,375.00 12,125.00 12,125.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:8 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 105.20 927.59 930.00 2.41 99.7 10-5101-1025 EMPLOYEE BENEFITS - COMP 28.10 332.80 335.00 2.20 99.3 TOTAL EMPLOYEE BENEFITS 133.30 1,260.39 1,265.00 4.61 99.6 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,405.00 7,500.00 1,095.00 85.4 10-5101-2123 MEALS/LODGING/TRAVEL 1,855.63 5,245.70 7,350.00 2,104.30 71.4 TOTAL PURCHASED SERVICES 1,855.63 19,442.07 22,850.00 3,407.93 85.1 SUPPLIES: 10-5101-3210 OPERATING SUPPLIES .00 .00 500.00 500.00 .0 TOTAL SUPPLIES .00 .00 500.00 500.00 .0 TOTAL GENERAL GOVT - CITY COUNCIL 3,363.93 32,827.46 36,740.00 3,912.54 89.4 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 30,515.92 361,221.41 368,173.00 6,951.59 98.1 10-5102-1002 SALARIES/WAGES - OVERTIME .00 212.14 1,500.00 1,287.86 14.1 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,760.92 1,891.00 130.08 93.1 10-5102-1006 SALARIES/WAGES - ALLOWANCES 150.00 1,800.00 1,800.00 .00 100.0 10-5102-1007 SALARIES/WAGES - INCENTIVE .00 1,456.00 974.00 ( 482.00) 149.5 TOTAL PERSONNEL SERVICES 30,665.92 366,450.47 374,338.00 7,887.53 97.9 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,388.83 28,590.34 30,590.00 1,999.66 93.5 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 8,701.62 104,274.23 104,189.00 ( 85.23) 100.1 10-5102-1025 EMPLOYEE BENEFITS - COMP 637.86 7,593.33 7,486.00 ( 107.33) 101.4 10-5102-1026 EMPLOYEE BENEFITS - COMP 560.10 7,273.96 5,643.00 ( 1,630.96) 128.9 10-5102-1029 EMPLOYEE BENEFITS - WY 5,224.34 61,535.73 63,288.00 1,752.27 97.2 TOTAL EMPLOYEE BENEFITS 17,512.75 209,267.59 211,196.00 1,928.41 99.1 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 524.00 2,720.00 2,196.00 19.3 10-5102-2122 TRAINING/DEVELOPMENT 230.00 2,590.00 3,975.00 1,385.00 65.2 10-5102-2123 MEALS/LODGING/TRAVEL 780.77 3,083.80 9,050.00 5,966.20 34.1 TOTAL PURCHASED SERVICES 1,010.77 6,197.80 15,745.00 9,547.20 39.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:9 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 120.00 500.00 380.00 24.0 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 500.00 500.00 .0 TOTAL SUPPLIES .00 120.00 1,000.00 880.00 12.0 TOTAL GENERAL GOVT - ADMIN SERVICES 49,189.44 582,035.86 602,279.00 20,243.14 96.6 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 389.31 390.00 .69 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 665.60 1,587.00 921.40 41.9 TOTAL PERSONNEL SERVICES 6,552.26 85,784.29 86,703.00 918.71 98.9 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL 495.73 6,491.03 6,511.00 19.97 99.7 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS 1,968.90 23,626.80 23,561.00 ( 65.80) 100.3 10-5103-1025 EMPLOYEE BENEFITS - COMP 136.29 1,697.44 1,702.00 4.56 99.7 10-5103-1029 EMPLOYEE BENEFITS - WY 1,044.70 13,504.85 13,581.00 76.15 99.4 TOTAL EMPLOYEE BENEFITS 3,645.62 45,320.12 45,355.00 34.88 99.9 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 242.00 1,176.25 1,500.00 323.75 78.4 TOTAL PURCHASED SERVICES 242.00 1,176.25 1,500.00 323.75 78.4 PROFESSIONAL SERVICES: 10-5103-2156 MAINTENANCE AGREEMENT .00 21,377.96 37,900.00 16,522.04 56.4 10-5103-2158 MISC CONTRACTUAL SERVICES 5,294.49 14,277.42 35,700.00 21,422.58 40.0 TOTAL PROFESSIONAL SERVICES 5,294.49 35,655.38 73,600.00 37,944.62 48.4 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 826.00 1,000.00 174.00 82.6 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 17,305.67 54,539.21 62,100.00 7,560.79 87.8 TOTAL SUPPLIES 17,305.67 55,365.21 63,100.00 7,734.79 87.7 TOTAL GENERAL GOVT - IT 33,040.04 223,301.25 270,258.00 46,956.75 82.6 GENERAL GOVT - MUNICIPAL COURT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:10 PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 3,207.26 40,657.09 41,662.00 1,004.91 97.6 10-5105-1005 SALARIES/WAGES - LONGEVITY .00 71.65 72.00 .35 99.5 TOTAL PERSONNEL SERVICES 3,207.26 40,728.74 41,734.00 1,005.26 97.6 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 245.35 3,115.70 3,193.00 77.30 97.6 10-5105-1023 EMPLOYEE BENEFITS - HEALTH INS 1,465.64 17,587.68 17,507.00 ( 80.68) 100.5 10-5105-1025 EMPLOYEE BENEFITS - COMP 66.72 850.93 833.00 ( 17.93) 102.2 10-5105-1029 EMPLOYEE BENEFITS - PLC 377.88 4,878.65 4,907.00 28.35 99.4 TOTAL EMPLOYEE BENEFITS 2,155.59 26,432.96 26,440.00 7.04 100.0 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 150.00 150.00 .00 100.0 10-5105-2123 MEALS/LODGING/TRAVEL .00 872.76 860.00 ( 12.76) 101.5 TOTAL PURCHASED SERVICES .00 1,022.76 1,010.00 ( 12.76) 101.3 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 1,541.00 15,559.20 14,400.00 ( 1,159.20) 108.1 10-5105-2162 COURT SURCHARGES .00 10,145.00 12,500.00 2,355.00 81.2 10-5105-2166 COLLECTION FEES .00 .00 500.00 500.00 .0 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 315.00 500.00 185.00 63.0 TOTAL PROFESSIONAL SERVICES 1,541.00 26,019.20 27,900.00 1,880.80 93.3 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES .00 39.33 450.00 410.67 8.7 10-5105-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 227.84 250.00 22.16 91.1 10-5105-3233 UNIFORMS/CARE .00 .00 50.00 50.00 .0 TOTAL SUPPLIES .00 267.17 750.00 482.83 35.6 TOTAL GENERAL GOVT - MUNICIPAL COURT 6,903.85 94,470.83 97,834.00 3,363.17 96.6 GENERAL GOVT - PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 17,441.39 225,334.33 225,447.00 112.67 100.0 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 700.65 703.00 2.35 99.7 10-5106-1006 SALARIES/WAGES - ALLOWANCES 450.00 5,400.00 5,400.00 .00 100.0 TOTAL PERSONNEL SERVICES 17,891.39 231,434.98 231,550.00 115.02 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:11 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,401.91 18,131.93 18,184.00 52.07 99.7 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 3,525.23 42,299.31 42,185.00 ( 114.31) 100.3 10-5106-1025 EMPLOYEE BENEFITS - COMP 372.16 4,750.74 4,631.00 ( 119.74) 102.6 10-5106-1026 EMPLOYEE BENEFITS - COMP 478.16 6,109.60 6,143.00 33.40 99.5 10-5106-1029 EMPLOYEE BENEFITS - WY 2,507.82 32,253.63 32,453.00 199.37 99.4 TOTAL EMPLOYEE BENEFITS 8,285.28 103,545.21 103,596.00 50.79 100.0 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 50.00 1,197.00 1,435.00 238.00 83.4 10-5106-2122 TRAINING/DEVELOPMENT .00 2,589.45 4,450.00 1,860.55 58.2 10-5106-2123 MEALS/LODGING/TRAVEL .00 4,171.41 7,570.00 3,398.59 55.1 TOTAL PURCHASED SERVICES 50.00 7,957.86 13,455.00 5,497.14 59.1 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 83.64 1,003.46 1,000.00 ( 3.46) 100.4 TOTAL PROPERTY SERVICES 83.64 1,003.46 1,000.00 ( 3.46) 100.4 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY .00 687.50 10,000.00 9,312.50 6.9 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT 105.68 2,208.13 2,100.00 ( 108.13) 105.2 10-5106-2158 MISC CONTRACTUAL SERVICES 1,254.00 1,966.50 9,000.00 7,033.50 21.9 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE 125.00 482.70 750.00 267.30 64.4 TOTAL PROFESSIONAL SERVICES 1,484.68 5,344.83 22,850.00 17,505.17 23.4 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 657.85 2,248.16 4,500.00 2,251.84 50.0 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 1,000.00 1,000.00 .0 10-5106-3235 FUEL 302.94 941.56 2,000.00 1,058.44 47.1 TOTAL SUPPLIES 960.79 3,189.72 7,500.00 4,310.28 42.5 TOTAL GENERAL GOVT - 28,755.78 352,476.06 379,951.00 27,474.94 92.8 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:12 GOVERNMENTAL ASSISTANCE: 10-5110-8701 COMM CITIZEN 8,333.33 99,999.96 100,000.00 .04 100.0 10-5110-8702 COMM CLUB/GEN 4,583.33 55,000.00 55,000.00 .00 100.0 10-5110-8703 COMM RCREATN .00 15,000.00 15,000.00 .00 100.0 10-5110-8705 COMM FOR LIF 833.34 10,000.08 10,000.00 ( .08) 100.0 10-5110-8707 COMM DVL 416.67 5,416.55 5,000.00 ( 416.55) 108.3 10-5110-8709 COMM 833.37 10,000.00 10,000.00 .00 100.0 10-5110-8714 COMM ENTERPRIS 6,250.00 75,000.00 75,000.00 .00 100.0 10-5110-8723 COMM HOCKEY .00 20,000.00 20,000.00 .00 100.0 10-5110-8734 COMM PEAK 12,500.00 95,823.50 95,000.00 ( 823.50) 100.9 10-5110-8744 COMM 46,666.66 279,999.97 280,000.00 .03 100.0 10-5110-8746 COMM & GIRLS 1,250.00 15,000.00 15,000.00 .00 100.0 10-5110-8750 COMM ADVOC 166.66 1,999.74 2,000.00 .26 100.0 10-5110-8753 COMM SRVC BLK 5,000.00 9,999.98 10,000.00 .02 100.0 10-5110-8755 COMM HANDS 6,150.00 6,150.00 6,150.00 .00 100.0 10-5110-8757 COMM SERV-KINGS PORTION 1,063.33 2,219.88 5,000.00 2,780.12 44.4 10-5110-8759 COMM SRVC CENTER .00 9,166.63 10,000.00 833.37 91.7 10-5110-8760 COMM SRVC JUSTICE 10,904.06 551,090.59 755,500.00 204,409.41 72.9 10-5110-8761 COMM SRVC - HERE TO HEL .00 2,067.84 2,500.00 432.16 82.7 TOTAL GOVERNMENTAL ASSISTANCE 104,950.75 1,263,934.72 1,471,150.00 207,215.28 85.9 TOTAL COMMUNITY SERVICE CONTRACTS 104,950.75 1,263,934.72 1,471,150.00 207,215.28 85.9 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 12,995.55 169,827.18 172,930.00 3,102.82 98.2 10-5201-1002 SALARIES/WAGES - OVERTIME .00 .00 100.00 100.00 .0 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 1,588.08 1,589.00 .92 99.9 10-5201-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 10-5201-1007 SALARIES/WAGES - INCENTIVE .00 1,164.80 1,165.00 .20 100.0 TOTAL PERSONNEL SERVICES 13,070.55 173,480.06 176,684.00 3,203.94 98.2 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 1,049.34 13,905.68 14,119.00 213.32 98.5 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 4,417.02 53,004.24 52,881.00 ( 123.24) 100.2 10-5201-1025 EMPLOYEE BENEFITS - COMP 271.86 3,841.16 3,534.00 ( 307.16) 108.7 10-5201-1026 EMPLOYEE BENEFITS - COMP 646.52 8,295.66 7,876.00 ( 419.66) 105.3 10-5201-1029 EMPLOYEE BENEFITS - WY 2,231.34 28,920.90 29,022.00 101.10 99.7 TOTAL EMPLOYEE BENEFITS 8,616.08 107,967.64 107,432.00 ( 535.64) 100.5 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 500.00 500.00 .00 100.0 10-5201-2122 TRAINING/DEVELOPMENT .00 260.00 680.00 420.00 38.2 10-5201-2123 MEALS/LODGING/TRAVEL .00 231.29 1,200.00 968.71 19.3 TOTAL PURCHASED SERVICES .00 991.29 2,380.00 1,388.71 41.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:13 PROPERTY SERVICES: 10-5201-2131 UTILITY SERVICES - ELECTRICITY 122.71 1,369.23 .00 ( 1,369.23) .0 10-5201-2134 TELECOMMUNICATIONS 40.01 1,556.16 .00 ( 1,556.16) .0 TOTAL PROPERTY SERVICES 162.72 2,925.39 .00 ( 2,925.39) .0 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5201-2158 MISC CONTRACTUAL SERVICES .00 2,531.12 2,500.00 ( 31.12) 101.2 10-5201-2161 INCARCERATION CONTRACT 397.50 1,590.00 2,500.00 910.00 63.6 TOTAL PROFESSIONAL SERVICES 397.50 4,121.12 6,000.00 1,878.88 68.7 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 455.25 3,606.33 5,500.00 1,893.67 65.6 10-5201-3233 UNIFORMS/CARE .00 690.75 500.00 ( 190.75) 138.2 10-5201-3235 FUEL 223.46 631.19 600.00 ( 31.19) 105.2 TOTAL SUPPLIES 678.71 4,928.27 6,600.00 1,671.73 74.7 TOTAL POLICE DEPT - ADMINISTRATION 22,925.56 294,413.77 299,096.00 4,682.23 98.4 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 68,443.22 970,134.95 1,095,562.00 125,427.05 88.6 10-5202-1002 SALARIES/WAGES - OVERTIME 5,000.10 66,897.45 53,000.00 ( 13,897.45) 126.2 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 3,203.61 3,402.00 198.39 94.2 10-5202-1006 SALARIES/WAGES - ALLOWANCES 100.00 1,200.00 1,200.00 .00 100.0 10-5202-1007 SALARIES/WAGES - INCENTIVE .00 .00 8,169.00 8,169.00 .0 TOTAL PERSONNEL SERVICES 73,543.32 1,041,436.01 1,161,333.00 119,896.99 89.7 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 5,717.43 80,728.71 89,363.00 8,634.29 90.3 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 25,207.98 318,511.75 360,999.00 42,487.25 88.2 10-5202-1025 EMPLOYEE BENEFITS - COMP 1,529.68 21,423.31 23,063.00 1,639.69 92.9 10-5202-1026 EMPLOYEE BENEFITS - COMP 1,194.33 13,845.03 6,816.00 ( 7,029.03) 203.1 10-5202-1029 EMPLOYEE BENEFITS - WY 12,579.17 172,951.24 185,922.00 12,970.76 93.0 TOTAL EMPLOYEE BENEFITS 46,228.59 607,460.04 666,163.00 58,702.96 91.2 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 660.00 1,195.00 535.00 55.2 10-5202-2122 TRAINING/DEVELOPMENT 200.00 14,167.95 18,785.00 4,617.05 75.4 10-5202-2123 MEALS/LODGING/TRAVEL 510.83 4,429.96 9,100.00 4,670.04 48.7 TOTAL PURCHASED SERVICES 710.83 19,257.91 29,080.00 9,822.09 66.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:14 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,569.80 16,997.91 19,930.00 2,932.09 85.3 TOTAL PROPERTY SERVICES 1,569.80 16,997.91 19,930.00 2,932.09 85.3 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE 294.00 8,466.99 10,000.00 1,533.01 84.7 10-5202-2156 MAINTENANCE AGREEMENT .00 16,430.18 16,298.00 ( 132.18) 100.8 10-5202-2158 MISC CONTRACTUAL SERVICES .00 2,031.96 5,000.00 2,968.04 40.6 TOTAL PROFESSIONAL SERVICES 294.00 26,929.13 31,298.00 4,368.87 86.0 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 30.00 300.00 270.00 10.0 10-5202-3210 OPERATING SUPPLIES 1,577.31 22,654.49 30,350.00 7,695.51 74.6 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 13,847.30 16,025.00 2,177.70 86.4 10-5202-3233 UNIFORMS/CARE 1,272.23 12,355.91 15,700.00 3,344.09 78.7 10-5202-3235 FUEL 6,550.53 24,243.98 23,000.00 ( 1,243.98) 105.4 TOTAL SUPPLIES 9,400.07 73,131.68 85,375.00 12,243.32 85.7 TOTAL POLICE DEPT - PATROL 131,746.61 1,785,212.68 1,993,179.00 207,966.32 89.6 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 10,840.14 140,105.40 140,229.00 123.60 99.9 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,162.23 1,164.00 1.77 99.9 10-5301-1006 SALARIES/WAGES - ALLOWANCES 75.00 4,650.00 5,400.00 750.00 86.1 TOTAL PERSONNEL SERVICES 10,915.14 145,917.63 146,793.00 875.37 99.4 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 837.76 11,149.67 11,230.00 80.33 99.3 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 2,757.65 33,180.53 33,107.00 ( 73.53) 100.2 10-5301-1025 EMPLOYEE BENEFITS - COMP 227.04 2,995.16 2,936.00 ( 59.16) 102.0 10-5301-1029 EMPLOYEE BENEFITS - WY 1,855.84 23,852.76 24,007.00 154.24 99.4 TOTAL EMPLOYEE BENEFITS 5,678.29 71,178.12 71,280.00 101.88 99.9 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 150.00 461.00 311.00 32.5 10-5301-2122 TRAINING/DEVELOPMENT .00 681.93 1,155.00 473.07 59.0 10-5301-2123 MEALS/LODGING/TRAVEL .00 .00 700.00 700.00 .0 TOTAL PURCHASED SERVICES .00 831.93 2,316.00 1,484.07 35.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:32AM PAGE:15 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 795.39 9,859.01 10,750.00 890.99 91.7 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 737.72 10,299.49 10,000.00 ( 299.49) 103.0 10-5301-2133 UTILITY SERVICES - NATURAL GAS 430.33 9,555.16 9,500.00 ( 55.16) 100.6 10-5301-2134 TELECOMMUNICATIONS 84.83 505.16 500.00 ( 5.16) 101.0 TOTAL PROPERTY SERVICES 2,048.27 30,218.82 30,750.00 531.18 98.3 PROFESSIONAL SERVICES: 10-5301-2153 ARCHITECT/ENGINEERING/SURVEING .00 880.00 1,000.00 120.00 88.0 10-5301-2155 REPAIRS/MAINTENANCE .00 2,476.92 2,200.00 ( 276.92) 112.6 10-5301-2156 MAINTENANCE AGREEMENT 70.50 2,749.06 3,880.00 1,130.94 70.9 10-5301-2158 MISC CONTRACTUAL SERVICES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 70.50 6,105.98 7,380.00 1,274.02 82.7 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 333.72 2,109.23 2,500.00 390.77 84.4 10-5301-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,161.28 2,800.00 638.72 77.2 10-5301-3230 REFRESHMENT SUPPLIES 71.93 805.48 750.00 ( 55.48) 107.4 10-5301-3235 FUEL 286.70 286.70 .00 ( 286.70) .0 TOTAL SUPPLIES 692.35 5,362.69 6,050.00 687.31 88.6 TOTAL PUBLIC WORKS - ADMINISTRATION 19,404.55 259,615.17 264,569.00 4,953.83 98.1 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 17,276.86 224,469.31 225,730.00 1,260.69 99.4 10-5302-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 2,191.28 2,194.00 2.72 99.9 10-5302-1007 SALARIES/WAGES - INCENTIVE .00 3,036.80 4,205.00 1,168.20 72.2 TOTAL PERSONNEL SERVICES 17,276.86 229,697.39 232,629.00 2,931.61 98.7 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,377.39 18,223.74 18,483.00 259.26 98.6 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 6,651.56 79,818.12 79,571.00 ( 247.12) 100.3 10-5302-1025 EMPLOYEE BENEFITS - COMP 359.36 4,714.23 4,646.00 ( 68.23) 101.5 10-5302-1026 EMPLOYEE BENEFITS - COMP 717.54 8,330.97 8,200.00 ( 130.97) 101.6 10-5302-1029 EMPLOYEE BENEFITS - WY 2,957.82 38,213.96 38,731.00 517.04 98.7 TOTAL EMPLOYEE BENEFITS 12,063.67 149,301.02 149,631.00 329.98 99.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:33AM PAGE:16 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 10-5302-2123 MEALS/LODGING/TRAVEL .00 .00 250.00 250.00 .0 TOTAL PURCHASED SERVICES .00 3,020.00 3,470.00 450.00 87.0 PROFESSIONAL SERVICES: 10-5302-2155 REPAIRS/MAINTENANCE 1,494.12 1,631.62 950.00 ( 681.62) 171.8 TOTAL PROFESSIONAL SERVICES 1,494.12 1,631.62 950.00 ( 681.62) 171.8 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 1,121.35 14,025.93 14,000.00 ( 25.93) 100.2 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 273.84 3,626.06 3,675.00 48.94 98.7 10-5302-3235 FUEL 1,088.34 2,372.95 2,000.00 ( 372.95) 118.7 10-5302-3237 OIL/LUBE/FLUIDS 665.49 12,347.43 12,500.00 152.57 98.8 TOTAL SUPPLIES 3,149.02 32,372.37 32,175.00 ( 197.37) 100.6 TOTAL PUBLIC WORKS - SHOP 33,983.67 416,022.40 418,855.00 2,832.60 99.3 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR ( 5,208.21) 218,182.24 218,231.00 48.76 100.0 10-5304-1002 SALARIES/WAGES - OVERTIME 103.73 1,607.62 1,900.00 292.38 84.6 10-5304-1004 SALARIES/WAGES - TEMPORARY 5,365.60 33,209.00 47,712.00 14,503.00 69.6 10-5304-1005 SALARIES/WAGES - LONGEVITY ( 140.95) 713.18 716.00 2.82 99.6 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 145.17 254,012.04 268,859.00 14,846.96 94.5 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 13.41 19,461.75 20,483.00 1,021.25 95.0 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS ( 985.53) 117,367.64 117,038.00 ( 329.64) 100.3 10-5304-1025 EMPLOYEE BENEFITS - COMP 9.91 5,200.77 5,355.00 154.23 97.1 10-5304-1029 EMPLOYEE BENEFITS - WY ( 850.21) 37,417.95 37,430.00 12.05 100.0 TOTAL EMPLOYEE BENEFITS ( 1,812.42) 179,448.11 180,306.00 857.89 99.5 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 275.00 550.00 275.00 50.0 10-5304-2122 TRAINING/DEVELOPMENT .00 1,635.00 1,635.00 .00 100.0 10-5304-2123 MEALS/LODGING/TRAVEL .00 935.09 1,000.00 64.91 93.5 TOTAL PURCHASED SERVICES .00 2,845.09 3,185.00 339.91 89.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:33AM PAGE:17 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 1,121.70 16,098.91 16,000.00 ( 98.91) 100.6 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 11,865.45 83,143.59 77,000.00 ( 6,143.59) 108.0 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 12,987.15 99,242.50 94,000.00 ( 5,242.50) 105.6 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE .00 .00 5,000.00 5,000.00 .0 10-5304-2156 MAINTENANCE AGREEMENT .00 940.00 1,250.00 310.00 75.2 10-5304-2158 MISC CONTRACTUAL SERVICES 825.00 15,967.50 25,000.00 9,032.50 63.9 TOTAL PROFESSIONAL SERVICES 825.00 16,907.50 31,250.00 14,342.50 54.1 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 7,541.92 39,103.71 40,000.00 896.29 97.8 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 985.00 1,000.00 15.00 98.5 10-5304-3235 FUEL 2,568.78 8,475.67 10,000.00 1,524.33 84.8 TOTAL SUPPLIES 10,110.70 48,564.38 51,000.00 2,435.62 95.2 TOTAL PUBLIC WORKS - PARKS 22,255.60 601,019.62 628,600.00 27,580.38 95.6 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 19,259.86 246,064.37 247,981.00 1,916.63 99.2 10-5305-1002 SALARIES/WAGES - OVERTIME .00 27.99 4,000.00 3,972.01 .7 10-5305-1004 SALARIES/WAGES - TEMPORARY 2,939.41 13,195.71 11,928.00 ( 1,267.71) 110.6 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 1,123.33 1,126.00 2.67 99.8 10-5305-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 300.00 ( 25.00) 108.3 10-5305-1007 SALARIES/WAGES - INCENTIVE .00 1,268.80 2,571.00 1,302.20 49.4 TOTAL PERSONNEL SERVICES 22,224.27 262,005.20 267,906.00 5,900.80 97.8 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,706.90 20,132.19 20,386.00 253.81 98.8 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 7,631.78 91,566.50 114,496.00 22,929.50 80.0 10-5305-1025 EMPLOYEE BENEFITS - COMP 462.25 5,373.84 5,345.00 ( 28.84) 100.5 10-5305-1026 EMPLOYEE BENEFITS - COMP 58.12 755.56 756.00 .44 99.9 10-5305-1029 EMPLOYEE BENEFITS - WY 3,297.31 41,893.57 43,139.00 1,245.43 97.1 TOTAL EMPLOYEE BENEFITS 13,156.36 159,721.66 184,122.00 24,400.34 86.8 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT .00 750.00 1,725.00 975.00 43.5 TOTAL PURCHASED SERVICES .00 750.00 1,725.00 975.00 43.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:33AM PAGE:18 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE 500.00 3,835.99 5,000.00 1,164.01 76.7 10-5305-2158 MISC CONTRACTUAL SERVICES 14,524.13 28,834.17 45,700.00 16,865.83 63.1 TOTAL PROFESSIONAL SERVICES 15,024.13 32,670.16 50,700.00 18,029.84 64.4 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 1,384.34 74,751.55 70,000.00 ( 4,751.55) 106.8 10-5305-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,265.27 2,400.00 1,134.73 52.7 10-5305-3235 FUEL 6,282.86 23,172.84 28,500.00 5,327.16 81.3 TOTAL SUPPLIES 7,667.20 99,189.66 100,900.00 1,710.34 98.3 TOTAL PUBLIC WORKS - STREETS/ALLEYS 58,071.96 554,336.68 605,353.00 51,016.32 91.6 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 31,009.40 110,523.76 109,888.00 ( 635.76) 100.6 10-5306-1002 SALARIES/WAGES - OVERTIME 1,717.05 2,587.83 1,500.00 ( 1,087.83) 172.5 10-5306-1004 SALARIES/WAGES - TEMPORARY 4,395.60 13,453.93 11,928.00 ( 1,525.93) 112.8 10-5306-1005 SALARIES/WAGES - LONGEVITY 140.95 780.45 782.00 1.55 99.8 10-5306-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5306-1007 SALARIES/WAGES - INCENTIVE .00 956.80 1,074.00 117.20 89.1 TOTAL PERSONNEL SERVICES 37,288.00 128,602.77 125,472.00 ( 3,130.77) 102.5 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 2,852.63 9,841.71 9,628.00 ( 213.71) 102.2 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 14,688.88 46,952.33 46,913.00 ( 39.33) 100.1 10-5306-1025 EMPLOYEE BENEFITS - COMP 768.68 2,637.19 2,496.00 ( 141.19) 105.7 10-5306-1029 EMPLOYEE BENEFITS - WY 5,579.10 19,255.62 19,070.00 ( 185.62) 101.0 TOTAL EMPLOYEE BENEFITS 23,889.29 78,686.85 78,107.00 ( 579.85) 100.7 PURCHASED SERVICES: 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 100.00 100.00 .00 100.0 10-5306-2122 TRAINING/DEVELOPMENT .00 300.00 280.00 ( 20.00) 107.1 TOTAL PURCHASED SERVICES .00 400.00 380.00 ( 20.00) 105.3 PROPERTY SERVICES: 10-5306-2131 UTILITY SERVICES - ELECTRICITY 155.38 2,310.59 3,000.00 689.41 77.0 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 5,266.72 32,516.92 45,000.00 12,483.08 72.3 10-5306-2133 UTILITY SERVICES - NATURAL GAS 52.20 1,198.41 1,500.00 301.59 79.9 10-5306-2134 TELECOMMUNICATIONS 93.05 1,040.00 1,650.00 610.00 63.0 10-5306-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 5,567.35 37,065.92 51,350.00 14,284.08 72.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:33AM PAGE:19 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE 1,016.53 1,897.78 1,500.00 ( 397.78) 126.5 10-5306-2156 MAINTENANCE AGREEMENT .00 .00 500.00 500.00 .0 10-5306-2158 MISC CONTRACTUAL SERVICES .00 7,000.00 7,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES 1,016.53 8,897.78 9,000.00 102.22 98.9 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 630.59 7,809.86 10,000.00 2,190.14 78.1 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 74.99 1,000.00 925.01 7.5 10-5306-3235 FUEL 841.28 2,636.27 2,500.00 ( 136.27) 105.5 TOTAL SUPPLIES 1,471.87 10,521.12 13,500.00 2,978.88 77.9 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 69,233.04 264,174.44 278,809.00 14,634.56 94.8 PUBLIC WORKS - SWIM POOL PERSONNEL SERVICES: 10-5307-1004 SALARIES/WAGES - TEMPORARY 17,119.07 70,355.84 72,500.00 2,144.16 97.0 TOTAL PERSONNEL SERVICES 17,119.07 70,355.84 72,500.00 2,144.16 97.0 EMPLOYEE BENEFITS: 10-5307-1021 EMPLOYEE BENEFITS - SCL 1,309.63 5,382.28 5,500.00 117.72 97.9 10-5307-1025 EMPLOYEE BENEFITS - COMP 356.05 1,420.86 1,500.00 79.14 94.7 TOTAL EMPLOYEE BENEFITS 1,665.68 6,803.14 7,000.00 196.86 97.2 PURCHASED SERVICES: 10-5307-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 25.00 25.00 .00 100.0 10-5307-2122 TRAINING/DEVELOPMENT .00 85.00 100.00 15.00 85.0 TOTAL PURCHASED SERVICES .00 110.00 125.00 15.00 88.0 PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 997.74 6,737.13 7,000.00 262.87 96.2 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 2,644.32 14,588.40 13,500.00 ( 1,088.40) 108.1 10-5307-2133 UTILITY SERVICES - NATURAL GAS 1,634.80 4,648.17 7,500.00 2,851.83 62.0 10-5307-2134 TELECOMMUNICATIONS 133.78 831.83 1,500.00 668.17 55.5 TOTAL PROPERTY SERVICES 5,410.64 26,805.53 29,500.00 2,694.47 90.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:33AM PAGE:20 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE 3,988.46 5,068.46 5,000.00 ( 68.46) 101.4 10-5307-2158 MISC CONTRACTUAL SERVICES .00 5,500.00 6,000.00 500.00 91.7 TOTAL PROFESSIONAL SERVICES 3,988.46 10,568.46 11,000.00 431.54 96.1 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 5,429.79 19,092.40 20,000.00 907.60 95.5 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,138.72 2,500.00 361.28 85.6 TOTAL SUPPLIES 5,429.79 21,231.12 22,500.00 1,268.88 94.4 TOTAL PUBLIC WORKS - SWIM POOL 33,613.64 135,874.09 142,625.00 6,750.91 95.3 OPERATING TRANSFERS - OUT OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE .00 250,000.00 250,000.00 .00 100.0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ ( 367.50) 1,132.50 2,000.00 867.50 56.6 10-5998-4339 TRANSFER TO HEALTH INS RESERVE .00 .00 100,000.00 100,000.00 .0 10-5998-4341 TRANSFER TO ECONOMIC DEVELOPME 31,250.00 125,000.00 125,000.00 .00 100.0 10-5998-4350 TRANSFER TO FIRE EQUIPMENT 25,000.00 100,000.00 100,000.00 .00 100.0 10-5998-4355 TRANSFER TO POOL IMPROVEMENT 37,500.00 50,000.00 50,000.00 .00 100.0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT 500,000.00 2,000,000.00 2,000,000.00 .00 100.0 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS 250,000.00 1,000,000.00 1,000,000.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 750.00 3,000.00 3,000.00 .00 100.0 TOTAL OPERATING TRANSFERS 844,132.50 3,529,132.50 3,630,000.00 100,867.50 97.2 TOTAL OPERATING TRANSFERS - OUT 844,132.50 3,529,132.50 3,630,000.00 100,867.50 97.2 TOTAL FUND EXPENDITURES 1,532,503.78 10,929,341.42 12,013,063.00 1,083,721.58 91.0 NET REVENUE OVER EXPENDITURES 581,342.97 8,939,917.12 7,592,038.00 ( 1,347,879.12) 117.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:33AM PAGE:21 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, 2019 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:45AM PAGE:22 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 18,510.53 TOTAL CASH 18,510.53 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 7,648.22 TOTAL ACCOUNTS RECEIVABLE 7,648.22 TOTAL CURRENT ASSETS 26,158.75 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 26,158.75 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 43,399.72 13-20000215 WAGES PAYABLE - CLEARING 5,240.45 TOTAL ACCOUNTS PAYABLE 48,640.17 TOTAL CURRENT LIABILITIES 48,640.17 TOTAL LIABILITIES 48,640.17 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 18,209.86 TOTAL CAPITAL ASSETS 18,209.86 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:45AM PAGE:23 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 40,691.28) BALANCE - CURRENT DATE ( 22,481.42) TOTAL NET ASSETS ( 22,481.42) TOTAL LIABILITIES AND NET ASSETS 26,158.75 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:45AM PAGE:24 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 1,290.36 7,974.90 14,441.00 6,466.10 55.2 TOTAL FEDERAL REVENUE SOURCES 1,290.36 7,974.90 14,441.00 6,466.10 55.2 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 1,290.36 7,974.90 14,441.00 6,466.10 55.2 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 4,165.00 10,530.61 10,688.00 157.39 98.5 TOTAL STATE REVENUE 4,165.00 10,530.61 10,688.00 157.39 98.5 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE 4,165.00 10,530.61 10,688.00 157.39 98.5 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 1,192.50 2,000.00 807.50 59.6 TOTAL FEDERAL REVENUE SOURCES .00 1,192.50 2,000.00 807.50 59.6 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND ( 367.50) 1,132.50 2,000.00 867.50 56.6 TOTAL TRANSFERS IN ( 367.50) 1,132.50 2,000.00 867.50 56.6 TOTAL BULLET PROOF VEST - REVENUE ( 367.50) 2,325.00 4,000.00 1,675.00 58.1 SCHOOL VIOLENCE PREVENTION-REV FEDERAL REVENUE SOURCES: 13-4897-4292 DEPARTMENT OF JUSTICE .00 37,212.75 149,963.00 112,750.25 24.8 TOTAL FEDERAL REVENUE SOURCES .00 37,212.75 149,963.00 112,750.25 24.8 TOTAL SCHOOL VIOLENCE PREVENTION-REV .00 37,212.75 149,963.00 112,750.25 24.8 TOTAL FUND REVENUE 5,087.86 58,043.26 179,092.00 121,048.74 32.4 ASSET SEIZURE ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:47AM PAGE:25 SUPPLIES: 13-5130-3210 OPERATING SUPPLIES .00 .00 3,376.00 3,376.00 .0 TOTAL SUPPLIES .00 .00 3,376.00 3,376.00 .0 TOTAL ASSET SEIZURE .00 .00 3,376.00 3,376.00 .0 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR 238.08 6,301.64 11,436.00 5,134.36 55.1 TOTAL PERSONNEL SERVICES 238.08 6,301.64 11,436.00 5,134.36 55.1 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL 18.21 481.96 875.00 393.04 55.1 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS 149.41 1,430.71 .00 ( 1,430.71) .0 13-5821-1025 EMPLOYEE BENEFITS - COMP 4.96 129.18 229.00 99.82 56.4 13-5821-1029 EMPLOYEE BENEFITS - WY 40.79 1,070.25 1,901.00 830.75 56.3 TOTAL EMPLOYEE BENEFITS 213.37 3,112.10 3,005.00 ( 107.10) 103.6 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE 451.45 9,413.74 14,441.00 5,027.26 65.2 SCHOOL RESOURCE OFFICER PROPERTY SERVICES: 13-5830-2134 TELECOMMUNICATIONS ( 262.84) .00 .00 .00 .0 TOTAL PROPERTY SERVICES ( 262.84) .00 .00 .00 .0 TOTAL SCHOOL RESOURCE OFFICER ( 262.84) .00 .00 .00 .0 OJJDP-UNDERAGE ENFORCEMENT PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 424.34 3,042.98 6,636.00 3,593.02 45.9 TOTAL PERSONNEL SERVICES 424.34 3,042.98 6,636.00 3,593.02 45.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:47AM PAGE:26 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 32.48 232.84 508.00 275.16 45.8 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS 190.81 657.00 .00 ( 657.00) .0 13-5831-1025 EMPLOYEE BENEFITS - COMP 8.82 61.89 281.00 219.11 22.0 13-5831-1029 EMPLOYEE BENEFITS - WY 72.61 514.00 1,103.00 589.00 46.6 TOTAL EMPLOYEE BENEFITS 304.72 1,465.73 1,892.00 426.27 77.5 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES 80.00 1,030.00 1,270.00 240.00 81.1 TOTAL PROFESSIONAL SERVICES 80.00 1,030.00 1,270.00 240.00 81.1 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 50.00 974.62 890.00 ( 84.62) 109.5 TOTAL SUPPLIES 50.00 974.62 890.00 ( 84.62) 109.5 TOTAL OJJDP-UNDERAGE ENFORCEMENT 859.06 6,513.33 10,688.00 4,174.67 60.9 BULLET PROOF VEST PROTECTION SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 2,325.00 4,000.00 1,675.00 58.1 TOTAL SUPPLIES .00 2,325.00 4,000.00 1,675.00 58.1 TOTAL BULLET PROOF VEST PROTECTION .00 2,325.00 4,000.00 1,675.00 58.1 SCHOOL VIOLENCE PREVENTION PRO CAPITALIZED EXPENDITURES: 13-5897-6547 EQUIPMENT/FURINITURE 43,269.72 80,482.47 169,932.00 89,449.53 47.4 TOTAL CAPITALIZED EXPENDITURES 43,269.72 80,482.47 169,932.00 89,449.53 47.4 TOTAL SCHOOL VIOLENCE PREVENTION PRO 43,269.72 80,482.47 169,932.00 89,449.53 47.4 TOTAL FUND EXPENDITURES 44,317.39 98,734.54 202,437.00 103,702.46 48.8 NET REVENUE OVER EXPENDITURES ( 39,229.53) ( 40,691.28) ( 23,345.00) 17,346.28 ( 174.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:27 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 801,642.92 31-10000117 CASH WITH FISCAL AGENT 49,087.07 31-10000118 MONEY MARKET ACCOUNT 120,919.58 TOTAL CASH 971,649.57 INVESTMENTS: 31-10000120 INVESTMENT POOL 3,980,000.00 31-10000122 TIME DEPOSITS - SHORT TERM 3,496,900.08 TOTAL INVESTMENTS 7,476,900.08 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 1,980,252.58 31-10000132 ACCOUNTS RECEIVABLE - EOY ( 25,865.50) 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 253,686.94 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 10,424.45) 31-10000139 ACCRUED INTEREST RECEIVABLE 5,180.80 31-10000156 DUE FROM OTHER FUNDS 25,865.50 TOTAL ACCOUNTS RECEIVABLE 2,228,695.87 TOTAL CURRENT ASSETS 10,677,245.52 FIXED ASSETS: 31-10000181 BUILDINGS 13,391,701.48 31-10000182 ACCUMULATED - BUILDINGS ( 6,020,377.21) 31-10000183 VEHICLES 382,306.47 31-10000184 ACCUMULATED - VEHICLES ( 339,755.53) 31-10000185 EQUIPMENT 410,968.40 31-10000186 ACCUMULATED - EQUIPMENT ( 368,298.65) 31-10000188 IMPROVEMENTS OTHER THAN BLDG 11,962,785.11 31-10000189 ACCUMULATED OT BLDG ( 6,058,979.69) TOTAL FIXED ASSETS 13,360,350.38 OTHER ASSETS: 31-10000190 ACCUMULATED ( 550,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 2,248,809.90 31-10006100 DEFERRED OUTFLOW OF RESOURCES 43,678.85 TOTAL OTHER ASSETS 1,742,488.75 TOTAL NON-CURRENT ASSETS 15,102,839.13 TOTAL ASSETS 25,780,084.65 LIABILITIES AND EQUITY ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:28 LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 1,200,709.54 31-20000204 ACCOUNTS PAYABLE - EOY 39,553.15 31-20000210 RETAINAGE PAYABLE ( 31,836.07) 31-20000215 WAGES PAYABLE 13,779.73 TOTAL ACCOUNTS PAYABLE 1,222,206.35 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 285,590.64 31-20005411 DEFERRED INFLOWS OF RESOURCES 9,240.02 TOTAL OTHER PAYABLES 294,830.66 TOTAL CURRENT LIABILITIES 1,517,037.01 NON-CURRENT LIABILITIES: 31-20000250 LEASES PAYABLE 672.00 31-20000265 COMPENSATED ABSENCES PAYABLE 43,551.71 TOTAL NON-CURRENT LIABILITIES 44,223.71 TOTAL LIABILITIES 1,561,260.72 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 3,820,642.92 31-30000305 RESERVE FOR REPLACEMENT 4,357,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 384,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 45,000.00 TOTAL CAPITAL ASSETS 9,182,883.61 OTHER NET ASSETS: 31-30000320 CAPITAL ASSETS NET OF DEBT 15,608,488.28 TOTAL OTHER NET ASSETS 15,608,488.28 REVENUE OVER EXPENDITURES - YTD ( 572,547.96) BALANCE - CURRENT DATE 24,218,823.93 TOTAL NET ASSETS 24,218,823.93 TOTAL LIABILITIES AND NET ASSETS 25,780,084.65 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:29 WATER - REVENUE MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 1,787.12 2,000.00 212.88 89.4 31-4310-1109 REIMBURSEMENTS ( 382.50) 16,695.01 17,000.00 304.99 98.2 31-4310-1140 INTEREST INCOME 2,995.22 87,992.15 85,000.00 ( 2,992.15) 103.5 TOTAL MISC LOCAL REVENUE 2,612.72 106,474.28 104,000.00 ( 2,474.28) 102.4 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 213,238.30 2,293,675.62 2,225,000.00 ( 68,675.62) 103.1 31-4310-1705 UTILITY SERVICE FEES 950.00 16,585.00 15,000.00 ( 1,585.00) 110.6 31-4310-1706 WATER PLANT INVESTMENT FEES .00 34,200.00 34,000.00 ( 200.00) 100.6 31-4310-1707 UTILITY LATE FEES 1,330.00 14,635.00 15,000.00 365.00 97.6 31-4310-1710 BULK WATER 14,900.57 165,021.85 160,000.00 ( 5,021.85) 103.1 TOTAL UTILITIES REVENUE 230,418.87 2,524,117.47 2,449,000.00 ( 75,117.47) 103.1 TRANSFERS IN: 31-4310-5596 TRANSFER FROM UTILITY DEPOSIT 339.95 930.64 .00 ( 930.64) .0 TOTAL TRANSFERS IN 339.95 930.64 .00 ( 930.64) .0 TOTAL WATER - REVENUE 233,371.54 2,631,522.39 2,553,000.00 ( 78,522.39) 103.1 LITTLE BOX ELDER SPRING - REVE STATE REVENUE: 31-4855-3235 WWDC GRANT 1,978,847.01 1,978,309.34 3,350,000.00 1,371,690.66 59.1 TOTAL STATE REVENUE 1,978,847.01 1,978,309.34 3,350,000.00 1,371,690.66 59.1 TOTAL LITTLE BOX ELDER SPRING - REVE 1,978,847.01 1,978,309.34 3,350,000.00 1,371,690.66 59.1 TOTAL FUND REVENUE 2,212,218.55 4,609,831.73 5,903,000.00 1,293,168.27 78.1 WATER - ADMINISTRATION 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 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:30 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 442.71 8,044.72 8,000.00 ( 44.72) 100.6 31-5400-2166 COLLECTION FEES 223.01 579.72 400.00 ( 179.72) 144.9 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 275.82 10,000.00 9,724.18 2.8 TOTAL PROFESSIONAL SERVICES 665.72 8,900.26 18,400.00 9,499.74 48.4 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 63,711.25 254,845.00 254,845.00 .00 100.0 TOTAL OPERATING TRANSFERS 63,711.25 254,845.00 254,845.00 .00 100.0 TOTAL WATER - ADMINISTRATION 201,876.97 814,129.26 823,629.00 9,499.74 98.9 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.40 98,831.22 98,852.00 20.78 100.0 31-5401-1002 SALARIES/WAGES - OVERTIME 554.69 4,778.84 6,000.00 1,221.16 79.7 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 499.06 500.00 .94 99.8 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 31-5401-1007 SALARIES/WAGES - INCENTIVE .00 .00 2,000.00 2,000.00 .0 TOTAL PERSONNEL SERVICES 8,182.09 104,409.12 107,652.00 3,242.88 97.0 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 639.85 8,168.30 8,415.00 246.70 97.1 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 2,946.12 35,353.44 35,255.00 ( 98.44) 100.3 31-5401-1025 EMPLOYEE BENEFITS - COMP 170.18 2,142.89 2,121.00 ( 21.89) 101.0 31-5401-1026 EMPLOYEE BENEFITS - COMP 152.04 1,976.52 1,977.00 .48 100.0 31-5401-1029 EMPLOYEE BENEFITS - WY 1,396.50 17,636.91 17,951.00 314.09 98.3 TOTAL EMPLOYEE BENEFITS 5,304.69 65,278.06 65,719.00 440.94 99.3 PURCHASED SERVICES: 31-5401-2122 TRAINING/DEVELOPMENT .00 1,730.00 2,570.00 840.00 67.3 31-5401-2123 MEALS/LODGING/TRAVEL .00 .00 700.00 700.00 .0 TOTAL PURCHASED SERVICES .00 1,730.00 3,270.00 1,540.00 52.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:31 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 2,138.27 30,078.06 40,000.00 9,921.94 75.2 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 1,386.67 7,055.51 7,000.00 ( 55.51) 100.8 31-5401-2133 UTILITY SERVICES - NATURAL GAS 353.67 5,849.68 5,750.00 ( 99.68) 101.7 31-5401-2134 TELECOMMUNICATIONS 15.23 183.01 250.00 66.99 73.2 31-5401-2140 RENT - LAND/BUILDINGS .00 8,823.83 9,000.00 176.17 98.0 TOTAL PROPERTY SERVICES 3,893.84 51,990.09 62,000.00 10,009.91 83.9 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 345.00 500.00 155.00 69.0 31-5401-2155 REPAIRS/MAINTENANCE 1,153.00 11,387.42 13,000.00 1,612.58 87.6 31-5401-2156 MAINTENANCE AGREEMENT .00 6,328.00 6,750.00 422.00 93.8 31-5401-2158 MISC CONTRACTUAL SERVICES 3,121.00 18,821.16 30,000.00 11,178.84 62.7 TOTAL PROFESSIONAL SERVICES 4,274.00 36,881.58 50,250.00 13,368.42 73.4 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 6,434.59 29,909.38 25,000.00 ( 4,909.38) 119.6 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 7,437.60 15,400.00 7,962.40 48.3 31-5401-3235 FUEL 382.94 1,352.42 2,500.00 1,147.58 54.1 TOTAL SUPPLIES 6,817.53 38,699.40 42,900.00 4,200.60 90.2 CAPITALIZED EXPENDITURES: 31-5401-6544 OTHER THAN BLDG .00 4,762.84 6,000.00 1,237.16 79.4 TOTAL CAPITALIZED EXPENDITURES .00 4,762.84 6,000.00 1,237.16 79.4 TOTAL WATER - TREATMENT 28,472.15 303,751.09 402,791.00 99,039.91 75.4 WATER - DISTRIBUTION/MAINTNCE PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 13,801.69 176,704.13 176,547.00 ( 157.13) 100.1 31-5402-1002 SALARIES/WAGES - OVERTIME 1,464.30 11,019.93 11,250.00 230.07 98.0 31-5402-1004 SALARIES/WAGES - TEMPORARY 499.20 1,976.00 2,982.00 1,006.00 66.3 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 764.36 766.00 1.64 99.8 31-5402-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 15,790.19 190,764.42 191,845.00 1,080.58 99.4 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,210.26 14,623.42 14,419.00 ( 204.42) 101.4 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 5,665.77 67,969.95 67,749.00 ( 220.95) 100.3 31-5402-1025 EMPLOYEE BENEFITS - COMP 328.43 3,916.55 3,770.00 ( 146.55) 103.9 31-5402-1029 EMPLOYEE BENEFITS - WY 2,613.55 31,964.46 31,509.00 ( 455.46) 101.5 TOTAL EMPLOYEE BENEFITS 9,818.01 118,474.38 117,447.00 ( 1,027.38) 100.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:32 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 124.50 1,292.72 1,700.00 407.28 76.0 31-5402-2122 TRAINING/DEVELOPMENT .00 1,600.00 2,625.00 1,025.00 61.0 31-5402-2123 MEALS/LODGING/TRAVEL .00 .00 750.00 750.00 .0 TOTAL PURCHASED SERVICES 124.50 2,892.72 5,075.00 2,182.28 57.0 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 1,247.61 11,639.06 12,500.00 860.94 93.1 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 9,527.31 48,589.34 45,000.00 ( 3,589.34) 108.0 31-5402-2133 UTILITY SERVICES - NATURAL GAS 52.47 1,039.68 1,500.00 460.32 69.3 31-5402-2134 TELECOMMUNICATIONS 32.05 191.17 600.00 408.83 31.9 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 10,859.44 61,459.25 60,000.00 ( 1,459.25) 102.4 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,119.00 2,500.00 1,381.00 44.8 31-5402-2155 REPAIRS/MAINTENANCE 1,968.05 20,383.47 20,000.00 ( 383.47) 101.9 31-5402-2156 MAINTENANCE AGREEMENT .00 795.00 900.00 105.00 88.3 31-5402-2158 MISC CONTRACTUAL SERVICES .00 4,000.00 5,000.00 1,000.00 80.0 TOTAL PROFESSIONAL SERVICES 1,968.05 26,297.47 28,400.00 2,102.53 92.6 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 6,330.33 34,380.25 35,000.00 619.75 98.2 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,072.49 3,500.00 1,427.51 59.2 31-5402-3235 FUEL 2,463.56 9,413.97 8,500.00 ( 913.97) 110.8 TOTAL SUPPLIES 8,793.89 45,866.71 47,000.00 1,133.29 97.6 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 235.41 350.00 114.59 67.3 TOTAL FINANCIAL .00 235.41 350.00 114.59 67.3 CAPITALIZED EXPENDITURES: 31-5402-6542 TO BLDG .00 21,420.07 22,000.00 579.93 97.4 31-5402-6547 EQUIPMENT/FURNITURE .00 62,208.77 63,000.00 791.23 98.7 TOTAL CAPITALIZED EXPENDITURES .00 83,628.84 85,000.00 1,371.16 98.4 TOTAL WATER - DISTRIBUTION/MAINTNCE 47,354.08 529,619.20 535,117.00 5,497.80 99.0 WATER - CUSTOMER SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:33 PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 3,744.33 48,676.34 48,672.00 ( 4.34) 100.0 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 449.44 450.00 .56 99.9 31-5403-1007 SALARIES/WAGES - INCENTIVE .00 748.80 973.00 224.20 77.0 TOTAL PERSONNEL SERVICES 3,744.33 49,874.58 50,095.00 220.42 99.6 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 273.74 3,663.01 3,832.00 168.99 95.6 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 22.11 265.32 260.00 ( 5.32) 102.1 31-5403-1025 EMPLOYEE BENEFITS - COMP 77.88 1,023.27 982.00 ( 41.27) 104.2 31-5403-1029 EMPLOYEE BENEFITS - WY 641.03 8,286.60 8,333.00 46.40 99.4 TOTAL EMPLOYEE BENEFITS 1,014.76 13,238.20 13,407.00 168.80 98.7 PURCHASED SERVICES: 31-5403-2122 TRAINING/DEVELOPMENT .00 .00 600.00 600.00 .0 TOTAL PURCHASED SERVICES .00 .00 600.00 600.00 .0 PROPERTY SERVICES: 31-5403-2134 TELECOMMUNICATIONS 16.93 199.29 300.00 100.71 66.4 TOTAL PROPERTY SERVICES 16.93 199.29 300.00 100.71 66.4 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 31-5403-2156 MAINTENANCE AGREEMENT .00 .00 2,050.00 2,050.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 3,550.00 3,550.00 .0 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES .00 634.83 1,000.00 365.17 63.5 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,701.00 16,811.02 26,000.00 9,188.98 64.7 31-5403-3235 FUEL 536.99 1,662.63 2,500.00 837.37 66.5 TOTAL SUPPLIES 2,237.99 19,108.48 29,500.00 10,391.52 64.8 TOTAL WATER - CUSTOMER SERVICES 7,014.01 82,420.55 97,452.00 15,031.45 84.6 WATER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY .00 35,772.11 135,600.00 99,827.89 26.4 TOTAL PROFESSIONAL SERVICES .00 35,772.11 135,600.00 99,827.89 26.4 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:34 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG .00 147,240.01 958,500.00 811,259.99 15.4 TOTAL CAPITALIZED EXPENDITURES .00 147,240.01 958,500.00 811,259.99 15.4 TOTAL WATER MAIN REPLACEMENTS .00 183,012.12 1,094,100.00 911,087.88 16.7 LITTLE BOX ELDER SPRING REHAB PROFESSIONAL SERVICES: 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY 29,467.23 94,609.15 300,000.00 205,390.85 31.5 TOTAL PROFESSIONAL SERVICES 29,467.23 94,609.15 300,000.00 205,390.85 31.5 CAPITALIZED EXPENDITURES: 31-5855-6544 OTHER THAN BLDG 809,231.37 2,859,353.87 5,000,000.00 2,140,646.13 57.2 TOTAL CAPITALIZED EXPENDITURES 809,231.37 2,859,353.87 5,000,000.00 2,140,646.13 57.2 TOTAL LITTLE BOX ELDER SPRING REHAB 838,698.60 2,953,963.02 5,300,000.00 2,346,036.98 55.7 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY 20,000.00 35,145.62 95,000.00 59,854.38 37.0 TOTAL PROFESSIONAL SERVICES 20,000.00 35,145.62 95,000.00 59,854.38 37.0 CAPITALIZED EXPENDITURES: 31-5856-6544 OTHER THAN BLDG .00 280,338.83 300,000.00 19,661.17 93.5 TOTAL CAPITALIZED EXPENDITURES .00 280,338.83 300,000.00 19,661.17 93.5 TOTAL WATER IMPROVEMENTS 20,000.00 315,484.45 395,000.00 79,515.55 79.9 TOTAL FUND EXPENDITURES 1,143,415.81 5,182,379.69 8,648,089.00 3,465,709.31 59.9 NET REVENUE OVER EXPENDITURES 1,068,802.74 ( 572,547.96) ( 2,745,089.00) ( 2,172,541.04) ( 20.9) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:35 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 1,111,804.97 32-10000118 MONEY MARKET ACCOUNT 120,919.57 TOTAL CASH 1,232,724.54 INVESTMENTS: 32-10000120 INVESTMENT POOL 1,970,435.23 32-10000122 TIME DEPOSITS - SHORT TERM 2,836,325.07 TOTAL INVESTMENTS 4,806,760.30 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 85,305.00 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 4,335.92) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 141,105.79 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 10,209.26) 32-10000139 ACCRUED INTEREST RECEIVABLE 3,279.71 32-10000140 DUE FROM OTHER FUNDS 4,335.92 TOTAL ACCOUNTS RECEIVABLE 219,481.24 TOTAL CURRENT ASSETS 6,258,966.08 FIXED ASSETS: 32-10000181 BUILDINGS 2,388,172.45 32-10000182 ACCUMULATED - BUILDINGS ( 1,889,258.41) 32-10000183 VEHICLES 520,184.32 32-10000184 ACCUMULATED - VEHICLES ( 477,633.38) 32-10000185 MACHINERY/EQUIPMENT 510,395.97 32-10000186 ACCUMULATED - EQUIPMENT ( 425,242.31) 32-10000188 IMPROVEMENTS OTHER THAN BLDG 8,531,553.69 32-10000189 ACCUMULATED OT BLDG ( 2,888,246.81) TOTAL FIXED ASSETS 6,269,925.52 OTHER ASSETS: 32-10000190 ACCUMULATED ( 270,000.00) 32-10000195 CONSTRUCTION IN PROGRESS 306,718.40 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 23,614.96 TOTAL OTHER ASSETS 60,333.36 TOTAL NON-CURRENT ASSETS 6,330,258.88 TOTAL ASSETS 12,589,224.96 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:36 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND ( 27,063.78) 32-20000210 RETAINAGE PAYABLE 80,923.14 32-20000215 WAGES PAYABLE 9,555.01 TOTAL ACCOUNTS PAYABLE 63,414.37 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 177,263.00 32-20005411 DEFERRED INFLOWS OF RESOURCES 7,339.32 TOTAL OTHER PAYABLES 184,602.32 TOTAL CURRENT LIABILITIES 248,016.69 NON-CURRENT LIABILITIES: 32-20000265 COMPENSATED ABSENCES PAYABLE 30,653.46 TOTAL NON-CURRENT LIABILITIES 30,653.46 TOTAL LIABILITIES 278,670.15 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS 1,348,568.48 32-30000305 RESERVE FOR REPLACEMENT 3,800,882.31 32-30000306 RESERVE FOR OPERATING 195,913.00 32-30000307 RESERVE FOR SLUDGE REMOVAL 180,000.00 TOTAL CAPITAL ASSETS 5,525,363.79 OTHER NET ASSETS: 32-30000320 CAPITAL ASSETS NET OF DEBT 6,576,643.92 TOTAL OTHER NET ASSETS 6,576,643.92 REVENUE OVER EXPENDITURES - YTD 208,547.10 BALANCE - CURRENT DATE 12,310,554.81 TOTAL NET ASSETS 12,310,554.81 TOTAL LIABILITIES AND NET ASSETS 12,589,224.96 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:54AM PAGE:37 SEWER - REVENUE MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 1,462.18 2,000.00 537.82 73.1 32-4320-1140 INTEREST INCOME 2,988.93 66,325.42 60,000.00 ( 6,325.42) 110.5 TOTAL MISC LOCAL REVENUE 2,988.93 67,787.60 62,000.00 ( 5,787.60) 109.3 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 108,691.44 1,278,341.28 1,200,000.00 ( 78,341.28) 106.5 32-4320-1706 SEWER PLANT INVESTMENT FEES .00 11,000.00 11,000.00 .00 100.0 TOTAL UTILITIES REVENUE 108,691.44 1,289,341.28 1,211,000.00 ( 78,341.28) 106.5 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 73,807.50 391,282.50 325,000.00 ( 66,282.50) 120.4 TOTAL SEPTIC WASTE DISPOSAL 73,807.50 391,282.50 325,000.00 ( 66,282.50) 120.4 TOTAL SEWER - REVENUE 185,487.87 1,748,411.38 1,598,000.00 ( 150,411.38) 109.4 TOTAL FUND REVENUE 185,487.87 1,748,411.38 1,598,000.00 ( 150,411.38) 109.4 SEWER - ADMINISTRATION DEPRECIATION: 32-5500-1150 DEPRECIATION 67,500.00 270,000.00 270,000.00 .00 100.0 TOTAL DEPRECIATION 67,500.00 270,000.00 270,000.00 .00 100.0 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 285.92 3,180.03 3,500.00 319.97 90.9 TOTAL PROFESSIONAL SERVICES 285.92 3,180.03 3,500.00 319.97 90.9 OPERATING TRANSFERS: 32-5500-4347 MANAGEMENT FEES 35,586.50 142,346.00 142,346.00 .00 100.0 TOTAL OPERATING TRANSFERS 35,586.50 142,346.00 142,346.00 .00 100.0 TOTAL SEWER - ADMINISTRATION 103,372.42 415,526.03 415,846.00 319.97 99.9 SEWER - TREATMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:38 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,507.40 82,642.89 82,939.00 296.11 99.6 32-5501-1002 SALARIES/WAGES - OVERTIME .00 362.98 5,000.00 4,637.02 7.3 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 248.42 249.00 .58 99.8 32-5501-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 32-5501-1007 SALARIES/WAGES - INCENTIVE .00 .00 794.00 794.00 .0 TOTAL PERSONNEL SERVICES 6,532.40 83,554.29 89,282.00 5,727.71 93.6 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 506.69 6,482.40 6,921.00 438.60 93.7 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 2,941.00 35,284.79 35,191.00 ( 93.79) 100.3 32-5501-1025 EMPLOYEE BENEFITS - COMP 135.88 1,715.24 1,778.00 62.76 96.5 32-5501-1026 EMPLOYEE BENEFITS - COMP 61.02 793.26 794.00 .74 99.9 32-5501-1029 EMPLOYEE BENEFITS - WY 1,114.06 14,132.07 15,055.00 922.93 93.9 TOTAL EMPLOYEE BENEFITS 4,758.65 58,407.76 59,739.00 1,331.24 97.8 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 1,217.50 1,570.00 352.50 77.6 TOTAL PURCHASED SERVICES .00 1,217.50 1,570.00 352.50 77.6 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 7,060.53 88,162.56 95,000.00 6,837.44 92.8 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 9,678.71 60,128.98 60,000.00 ( 128.98) 100.2 32-5501-2134 TELECOMMUNICATIONS 248.39 1,583.81 2,000.00 416.19 79.2 TOTAL PROPERTY SERVICES 16,987.63 149,875.35 157,000.00 7,124.65 95.5 PROFESSIONAL SERVICES: 32-5501-2155 REPAIRS/MAINTENANCE 23,833.26 51,531.06 51,000.00 ( 531.06) 101.0 32-5501-2158 MISC CONTRACTUAL SERVICES 589.00 8,580.00 15,000.00 6,420.00 57.2 TOTAL PROFESSIONAL SERVICES 24,422.26 60,111.06 66,000.00 5,888.94 91.1 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 4,072.02 22,419.81 25,000.00 2,580.19 89.7 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,305.55 2,050.00 744.45 63.7 32-5501-3235 FUEL 382.91 1,219.43 2,000.00 780.57 61.0 TOTAL SUPPLIES 4,454.93 24,944.79 29,050.00 4,105.21 85.9 TOTAL SEWER - TREATMENT 57,155.87 378,110.75 417,641.00 39,530.25 90.5 SEWER - COLLECTION ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:39 PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 12,253.78 156,049.34 155,385.00 ( 664.34) 100.4 32-5502-1002 SALARIES/WAGES - OVERTIME 472.82 9,306.20 9,500.00 193.80 98.0 32-5502-1004 SALARIES/WAGES - TEMPORARY 499.20 1,976.00 2,982.00 1,006.00 66.3 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 562.00 563.00 1.00 99.8 32-5502-1006 SALARIES & WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 13,250.80 168,193.54 168,730.00 536.46 99.7 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 1,007.59 12,795.92 12,555.00 ( 240.92) 101.9 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 6,849.43 82,171.90 81,938.00 ( 233.90) 100.3 32-5502-1025 EMPLOYEE BENEFITS - COMP 275.61 3,451.73 3,282.00 ( 169.73) 105.2 32-5502-1029 EMPLOYEE BENEFITS - WY 2,178.78 28,158.87 27,372.00 ( 786.87) 102.9 TOTAL EMPLOYEE BENEFITS 10,311.41 126,578.42 125,147.00 ( 1,431.42) 101.1 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 124.50 1,292.78 1,700.00 407.22 76.1 32-5502-2122 TRAINING/DEVELOPMENT .00 2,036.00 2,625.00 589.00 77.6 32-5502-2123 MEALS/LODGING/TRAVEL .00 .00 750.00 750.00 .0 TOTAL PURCHASED SERVICES 124.50 3,328.78 5,075.00 1,746.22 65.6 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 856.14 13,065.94 15,000.00 1,934.06 87.1 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 41.05 262.26 250.00 ( 12.26) 104.9 32-5502-2133 UTILITY SERVICES - NATURAL GAS 108.48 1,817.66 1,900.00 82.34 95.7 32-5502-2134 TELECOMMUNICATIONS 95.11 947.83 1,200.00 252.17 79.0 TOTAL PROPERTY SERVICES 1,100.78 16,093.69 18,350.00 2,256.31 87.7 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,119.00 2,500.00 1,381.00 44.8 32-5502-2155 REPAIRS/MAINTENANCE .00 1,408.32 5,000.00 3,591.68 28.2 32-5502-2158 MISC CONTRACTUAL SERVICES .00 6,830.59 7,000.00 169.41 97.6 TOTAL PROFESSIONAL SERVICES .00 9,357.91 14,500.00 5,142.09 64.5 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 1,413.03 19,975.52 30,000.00 10,024.48 66.6 32-5502-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 1,772.50 3,500.00 1,727.50 50.6 32-5502-3235 FUEL 2,238.81 9,188.95 8,500.00 ( 688.95) 108.1 TOTAL SUPPLIES 3,651.84 30,936.97 42,000.00 11,063.03 73.7 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 214.01 250.00 35.99 85.6 TOTAL FINANCIAL .00 214.01 250.00 35.99 85.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:40 CAPITALIZED EXPENDITURES: 32-5502-6542 TO BLDG .00 .00 92,000.00 92,000.00 .0 32-5502-6547 EQUIPMENT/FURNITURE .00 61,955.50 65,000.00 3,044.50 95.3 TOTAL CAPITALIZED EXPENDITURES .00 61,955.50 157,000.00 95,044.50 39.5 TOTAL SEWER - COLLECTION 28,439.33 416,658.82 531,052.00 114,393.18 78.5 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY 1,102.50 28,465.74 40,000.00 11,534.26 71.2 TOTAL PROFESSIONAL SERVICES 1,102.50 28,465.74 40,000.00 11,534.26 71.2 TOTAL WASTEWATER PLANT REHAB 1,102.50 28,465.74 40,000.00 11,534.26 71.2 SEWER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY 1,729.00 63,401.09 160,500.00 97,098.91 39.5 TOTAL PROFESSIONAL SERVICES 1,729.00 63,401.09 160,500.00 97,098.91 39.5 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG .00 237,701.85 510,000.00 272,298.15 46.6 TOTAL CAPITALIZED EXPENDITURES .00 237,701.85 510,000.00 272,298.15 46.6 TOTAL SEWER MAIN REPLACEMENTS 1,729.00 301,102.94 670,500.00 369,397.06 44.9 TOTAL FUND EXPENDITURES 191,799.12 1,539,864.28 2,075,039.00 535,174.72 74.2 NET REVENUE OVER EXPENDITURES ( 6,311.25) 208,547.10 ( 477,039.00) ( 685,586.10) 43.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:41 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 207,915.43 TOTAL CASH 207,915.43 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 606,743.03 TOTAL INVESTMENTS 606,743.03 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 25.00 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 604.11) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 49,985.81 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,077.04) 33-10000139 ACCRUED INTEREST RECEIVABLE 3,279.71 33-10000140 DUE FROM OTHER FUNDS 34.66 33-10000156 DUE FROM OTHER FUNDS 569.45 TOTAL ACCOUNTS RECEIVABLE 51,213.48 TOTAL CURRENT ASSETS 865,871.94 FIXED ASSETS: 33-10000183 VEHICLES 559,776.68 33-10000184 ACCUMULATED - VEHICLES ( 364,575.19) 33-10000185 EQUIPMENT 33,437.00 33-10000186 ACCUMULATED - EQUIPMENT ( 33,437.00) TOTAL FIXED ASSETS 195,201.49 OTHER ASSETS: 33-10000190 ACCUMULATED ( 35,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 12,447.83 TOTAL OTHER ASSETS ( 22,552.17) TOTAL NON-CURRENT ASSETS 172,649.32 TOTAL ASSETS 1,038,521.26 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:42 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 9,493.89 33-20000215 WAGES PAYABLE 5,477.86 TOTAL ACCOUNTS PAYABLE 14,971.75 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 92,278.32 33-20005411 DEFERRED INFLOWS OF RESOURCES 4,465.28 TOTAL OTHER PAYABLES 96,743.60 TOTAL CURRENT LIABILITIES 111,715.35 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 33,297.42 TOTAL NON-CURRENT LIABILITIES 33,297.42 TOTAL LIABILITIES 145,012.77 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS 60,730.32 33-30000305 RESERVE FOR REPLACEMENT 636,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 773,474.86 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 195,201.49 TOTAL OTHER NET ASSETS 195,201.49 REVENUE OVER EXPENDITURES - YTD ( 75,167.86) BALANCE - CURRENT DATE 893,508.49 TOTAL NET ASSETS 893,508.49 TOTAL LIABILITIES AND NET ASSETS 1,038,521.26 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:43 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1140 INTEREST INCOME 118.48 10,199.39 10,000.00 ( 199.39) 102.0 TOTAL MISC LOCAL REVENUE 118.48 10,199.39 10,000.00 ( 199.39) 102.0 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 41,785.09 497,327.79 490,000.00 ( 7,327.79) 101.5 33-4330-1709 SANITATION ACTIVATION FEE .00 1,000.00 1,000.00 .00 100.0 TOTAL UTILITIES REVENUE 41,785.09 498,327.79 491,000.00 ( 7,327.79) 101.5 TOTAL SANITATION - REVENUE 41,903.57 508,527.18 501,000.00 ( 7,527.18) 101.5 TOTAL FUND REVENUE 41,903.57 508,527.18 501,000.00 ( 7,527.18) 101.5 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.96 139,996.41 140,010.00 13.59 100.0 33-5600-1002 SALARIES/WAGES - OVERTIME .00 .00 600.00 600.00 .0 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 1,187.77 1,189.00 1.23 99.9 33-5600-1006 SALARIES/WAGES - ALLOWANCES 25.00 325.00 300.00 ( 25.00) 108.3 33-5600-1007 SALARIES/WAGES - INCENTIVE .00 1,476.80 3,584.00 2,107.20 41.2 TOTAL PERSONNEL SERVICES 10,793.96 142,985.98 145,683.00 2,697.02 98.2 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 838.48 11,105.22 11,232.00 126.78 98.9 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 4,901.34 58,816.07 58,652.00 ( 164.07) 100.3 33-5600-1025 EMPLOYEE BENEFITS - COMP 224.52 2,935.41 2,881.00 ( 54.41) 101.9 33-5600-1026 EMPLOYEE BENEFITS - COMP 136.76 1,777.88 756.00 ( 1,021.88) 235.2 33-5600-1029 EMPLOYEE BENEFITS - WY 1,843.64 23,832.67 24,072.00 239.33 99.0 TOTAL EMPLOYEE BENEFITS 7,944.74 98,467.25 97,593.00 ( 874.25) 100.9 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, 2019 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:44 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE 2,024.23 2,024.23 .00 ( 2,024.23) .0 33-5600-2158 MISC CONTRACTUAL SERVICES 193.69 4,984.79 5,000.00 15.21 99.7 33-5600-2175 REFUNDS/REIMBURSEMENTS .00 .00 125.00 125.00 .0 TOTAL PROFESSIONAL SERVICES 2,217.92 7,009.02 5,125.00 ( 1,884.02) 136.8 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 1,463.47 24,638.68 26,000.00 1,361.32 94.8 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 24,965.23 25,000.00 34.77 99.9 33-5600-3235 FUEL 5,812.50 21,620.88 22,000.00 379.12 98.3 TOTAL SUPPLIES 7,275.97 71,224.79 73,000.00 1,775.21 97.6 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 13,692.25 54,769.00 54,769.00 .00 100.0 TOTAL OPERATING TRANSFERS 13,692.25 54,769.00 54,769.00 .00 100.0 CAPITALIZED EXPENDITURES: 33-5600-6547 EQUIPMENT/FURNITURE .00 .00 7,000.00 7,000.00 .0 33-5600-6548 VEHICLES .00 174,239.00 210,000.00 35,761.00 83.0 TOTAL CAPITALIZED EXPENDITURES .00 174,239.00 217,000.00 42,761.00 80.3 TOTAL SANITATION 50,674.84 583,695.04 658,170.00 74,474.96 88.7 TOTAL FUND EXPENDITURES 50,674.84 583,695.04 658,170.00 74,474.96 88.7 NET REVENUE OVER EXPENDITURES ( 8,771.27) ( 75,167.86) ( 157,170.00) ( 82,002.14) ( 47.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:45 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 321,556.13 TOTAL CASH 321,556.13 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 1,623,239.43 TOTAL INVESTMENTS 1,623,239.43 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 36,732.80 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 41,343.31) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY 75,278.73 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,703.27) 34-10000139 ACCRUED INTEREST RECEIVABLE 2,237.49 34-10000140 DUE FROM OTHER FUNDS ( 1,618.91) 34-10000156 DUE FROM OTHER FUNDS 2,600.15 TOTAL ACCOUNTS RECEIVABLE 71,183.68 TOTAL CURRENT ASSETS 2,015,979.24 FIXED ASSETS: 34-10000180 LAND 153,289.58 34-10000181 BUILDINGS 1,689,609.46 34-10000182 ACCUMULATED - BUILDINGS ( 331,630.64) 34-10000183 VEHICLES 49,148.52 34-10000184 ACCUMULATED - VEHICLE ( 24,090.82) 34-10000185 EQUIPMENT 1,107,582.94 34-10000186 ACCUMULATED - EQUIPMENT ( 780,684.55) 34-10000188 IMPROVEMENTS OTHER THAN BLDG 417,030.94 34-10000189 ACCUMULATED OT BLDG ( 33,754.46) TOTAL FIXED ASSETS 2,246,500.97 OTHER ASSETS: 34-10000190 ACCUMULATED ( 40,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 17,726.86 TOTAL OTHER ASSETS ( 22,273.14) TOTAL NON-CURRENT ASSETS 2,224,227.83 TOTAL ASSETS 4,240,207.07 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:46 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 64,855.12 34-20000204 ACCOUNTS PAYABLE- EOY ( 31,676.00) 34-20000205 INTEREST PAYABLE 1,082.80 34-20000215 WAGES PAYABLE 8,897.38 TOTAL ACCOUNTS PAYABLE 43,159.30 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 135,194.85 34-20005411 DEFERRED INFLOWS OF RESOURCES 4,690.28 TOTAL OTHER PAYABLES 139,885.13 TOTAL CURRENT LIABILITIES 183,044.43 NON-CURRENT LIABILITIES: 34-20000260 SLIB NOTES PAYABLE 90,055.78 34-20000265 COMPENSATED ABSENCES PAYABLE 31,568.82 34-20000290 LANDFILL LIABILITY 362,219.31 34-20000295 NOTES PAYABLE 84,742.47 TOTAL NON-CURRENT LIABILITIES 568,586.38 TOTAL LIABILITIES 751,630.81 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS 380,220.54 34-30000305 RESERVE FOR REPLACEMENT 1,086,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,599,391.31 OTHER NET ASSETS: 34-30000320 CAPITAL ASSETS NET OF DEBT 1,794,226.49 TOTAL OTHER NET ASSETS 1,794,226.49 REVENUE OVER EXPENDITURES - YTD 94,958.46 BALANCE - CURRENT DATE 3,488,576.26 TOTAL NET ASSETS 3,488,576.26 TOTAL LIABILITIES AND NET ASSETS 4,240,207.07 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:47 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER .00 3,632.04 15,000.00 11,367.96 24.2 34-4340-1140 INTEREST INCOME 234.53 23,702.56 22,500.00 ( 1,202.56) 105.3 TOTAL MISC LOCAL REVENUE 234.53 27,334.60 37,500.00 10,165.40 72.9 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 104,933.95 1,101,343.34 1,050,000.00 ( 51,343.34) 104.9 TOTAL UTILITIES REVENUE 104,933.95 1,101,343.34 1,050,000.00 ( 51,343.34) 104.9 TOTAL LANDFILL - REVENUE 105,168.48 1,128,677.94 1,087,500.00 ( 41,177.94) 103.8 OPERATING TRANSFERS IN: 34-4895-1905 LOAN PROCEEDS .00 992.32 992.00 ( .32) 100.0 TOTAL OPERATING TRANSFERS IN .00 992.32 992.00 ( .32) 100.0 STATE REVENUE: 34-4895-2276 SLIB .00 3,969.25 3,969.00 ( .25) 100.0 TOTAL STATE REVENUE .00 3,969.25 3,969.00 ( .25) 100.0 .00 4,961.57 4,961.00 ( .57) 100.0 TOTAL FUND REVENUE 105,168.48 1,133,639.51 1,092,461.00 ( 41,178.51) 103.8 LANDFILL PERSONNEL SERVICES: 34-5340-1001 SALARIES/WAGES - REGULAR 14,240.28 200,150.37 240,965.00 40,814.63 83.1 34-5340-1002 SALARIES/WAGES - OVERTIME .00 .00 1,500.00 1,500.00 .0 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,233.51 1,616.00 382.49 76.3 34-5340-1006 SALARIES/WAGES - ALLOWANCES 50.00 600.00 600.00 .00 100.0 34-5340-1007 SALARIES/WAGES - INCENTIVE .00 532.56 1,585.00 1,052.44 33.6 TOTAL PERSONNEL SERVICES 14,290.28 202,516.44 246,266.00 43,749.56 82.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:48 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,141.98 16,150.87 17,500.00 1,349.13 92.3 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 5,871.16 71,080.13 75,000.00 3,919.87 94.8 34-5340-1025 EMPLOYEE BENEFITS - COMP 297.24 4,159.94 5,429.00 1,269.06 76.6 34-5340-1026 EMPLOYEE BENEFITS - COMP 610.13 8,214.11 7,805.00 ( 409.11) 105.2 34-5340-1029 EMPLOYEE BENEFITS - WY 1,827.80 25,497.91 30,000.00 4,502.09 85.0 TOTAL EMPLOYEE BENEFITS 9,748.31 125,102.96 135,734.00 10,631.04 92.2 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 250.00 250.00 .00 100.0 34-5340-2122 TRAINING/DEVELOPMENT .00 840.00 850.00 10.00 98.8 TOTAL PURCHASED SERVICES .00 1,090.00 1,100.00 10.00 99.1 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 770.75 7,548.42 9,000.00 1,451.58 83.9 34-5340-2133 UTILITY SERVICES - NATURAL GAS 496.55 12,308.78 13,500.00 1,191.22 91.2 34-5340-2134 TELECOMMUNICATIONS 18.47 221.97 250.00 28.03 88.8 34-5340-2141 EQUIPMENT - RENT .00 .00 200.00 200.00 .0 TOTAL PROPERTY SERVICES 1,285.77 20,079.17 22,950.00 2,870.83 87.5 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 34-5340-2155 REPAIRS/MAINTENANCE 547.50 13,951.70 20,000.00 6,048.30 69.8 34-5340-2156 MAINTENANCE AGREEMENT 1,235.74 7,466.44 6,500.00 ( 966.44) 114.9 34-5340-2157 INSURANCE .00 .00 1,500.00 1,500.00 .0 34-5340-2158 MISC CONTRACTUAL SERVICES 46,774.68 379,672.78 370,000.00 ( 9,672.78) 102.6 34-5340-2166 COLLECTION FEES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 48,557.92 401,090.92 399,300.00 ( 1,790.92) 100.5 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 3,361.56 37,829.40 40,000.00 2,170.60 94.6 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 4,987.72 7,000.00 2,012.28 71.3 34-5340-3235 FUEL 2,787.87 12,692.58 30,000.00 17,307.42 42.3 TOTAL SUPPLIES 6,149.43 55,509.70 77,000.00 21,490.30 72.1 FINANCIAL: 34-5340-4343 DEBT PAYMENT - PRINCIPAL .00 13,141.02 13,141.00 ( .02) 100.0 TOTAL FINANCIAL .00 13,141.02 13,141.00 ( .02) 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:49 OPERATING TRANSFERS: 34-5340-4347 MANAGEMENT FEES 24,469.50 97,878.00 97,878.00 .00 100.0 TOTAL OPERATING TRANSFERS 24,469.50 97,878.00 97,878.00 .00 100.0 TOTAL LANDFILL 114,501.21 956,408.21 1,033,369.00 76,960.79 92.6 LANDFILL - CAPITAL PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 8,862.00 29,883.93 35,000.00 5,116.07 85.4 34-5895-2158 MISC CONTRACTUAL SERVICES .00 87,200.00 87,200.00 .00 100.0 TOTAL PROFESSIONAL SERVICES 8,862.00 117,083.93 122,200.00 5,116.07 95.8 CAPITALIZED EXPENDITURES: 34-5895-6544 OTHER THAN BLDG .00 ( 34,811.09) .00 34,811.09 .0 TOTAL CAPITALIZED EXPENDITURES .00 ( 34,811.09) .00 34,811.09 .0 TOTAL LANDFILL - CAPITAL 8,862.00 82,272.84 122,200.00 39,927.16 67.3 TOTAL FUND EXPENDITURES 123,363.21 1,038,681.05 1,155,569.00 116,887.95 89.9 NET REVENUE OVER EXPENDITURES ( 18,194.73) 94,958.46 ( 63,108.00) ( 158,066.46) 150.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:50 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 414,665.91 TOTAL CASH 414,665.91 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 406,324.00 TOTAL INVESTMENTS 406,324.00 ACCOUNTS RECEIVABLE: 39-10000139 ACCRUED INTEREST RECEIVABLE 623.01 TOTAL ACCOUNTS RECEIVABLE 623.01 TOTAL CURRENT ASSETS 821,612.92 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 821,612.92 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 39-20000210 IBNR LIABILITY 259,000.00 TOTAL ACCOUNTS PAYABLE 259,000.00 TOTAL CURRENT LIABILITIES 259,000.00 TOTAL LIABILITIES 259,000.00 NET ASSETS CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 488,577.33) 39-30000301 FUND BALANCE RESERVE 800,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 418,422.67 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:51 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 144,190.25 BALANCE - CURRENT DATE 562,612.92 TOTAL NET ASSETS 562,612.92 TOTAL LIABILITIES AND NET ASSETS 821,612.92 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:55AM PAGE:52 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS .00 213.69 50,000.00 49,786.31 .4 39-4390-0111 INSURANCE PREMIUMS 30,656.38 372,562.65 500,000.00 127,437.35 74.5 39-4390-0112 INSURANCE ASSESSMENTS 74,911.50 908,655.79 985,000.00 76,344.21 92.3 39-4390-0120 REFUND 85.53 3,702.20 3,702.00 ( .20) 100.0 TOTAL REVENUE 105,653.41 1,285,134.33 1,538,702.00 253,567.67 83.5 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 398.15 8,046.40 7,500.00 ( 546.40) 107.3 TOTAL MISC LOCAL REVENUE 398.15 8,046.40 7,500.00 ( 546.40) 107.3 TRANSFERS IN: 39-4390-5510 TRANSFER FROM GENERAL FUND .00 .00 100,000.00 100,000.00 .0 TOTAL TRANSFERS IN .00 .00 100,000.00 100,000.00 .0 TOTAL EMPLOYEE HEALTH CARE - REVENUE 106,051.56 1,293,180.73 1,646,202.00 353,021.27 78.6 TOTAL FUND REVENUE 106,051.56 1,293,180.73 1,646,202.00 353,021.27 78.6 EMPLOYEE HEALTH CARE EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM .00 274,560.55 300,000.00 25,439.45 91.5 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 209,233.81 787,425.97 900,000.00 112,574.03 87.5 39-5390-1058 HEALTH CARE - FEE .00 87,003.96 200,000.00 112,996.04 43.5 TOTAL EMPLOYEE BENEFITS 209,233.81 1,148,990.48 1,400,000.00 251,009.52 82.1 TOTAL EMPLOYEE HEALTH CARE 209,233.81 1,148,990.48 1,400,000.00 251,009.52 82.1 TOTAL FUND EXPENDITURES 209,233.81 1,148,990.48 1,400,000.00 251,009.52 82.1 NET REVENUE OVER EXPENDITURES ( 103,182.25) 144,190.25 246,202.00 102,011.75 58.6 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:56AM PAGE:53 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 26,052.55 TOTAL CASH 26,052.55 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 315,011.63 TOTAL INVESTMENTS 315,011.63 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 500.59 TOTAL ACCOUNTS RECEIVABLE 500.59 TOTAL CURRENT ASSETS 341,564.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 341,564.77 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 337,736.21 TOTAL CAPITAL ASSETS 337,736.21 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,828.56 BALANCE - CURRENT DATE 341,564.77 TOTAL NET ASSETS 341,564.77 TOTAL LIABILITIES AND NET ASSETS 341,564.77 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:56AM PAGE:54 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 15.28 3,828.56 3,750.00 ( 78.56) 102.1 TOTAL MISC LOCAL REVENUE 15.28 3,828.56 3,750.00 ( 78.56) 102.1 TOTAL CAPITAL IMP RESERVE - REVENUE 15.28 3,828.56 3,750.00 ( 78.56) 102.1 TOTAL FUND REVENUE 15.28 3,828.56 3,750.00 ( 78.56) 102.1 NET REVENUE OVER EXPENDITURES 15.28 3,828.56 3,750.00 ( 78.56) 102.1 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:56AM PAGE:55 ASSETS CURRENT ASSETS: CASH: 41-10000116 CASH ALLOC FR COMBINED FUND 186,409.13 TOTAL CASH 186,409.13 TOTAL CURRENT ASSETS 186,409.13 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 186,409.13 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 41-30000300 FUND BALANCE/BEGINNING OF YEAR 72,139.99 TOTAL CAPITAL ASSETS 72,139.99 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 114,269.14 BALANCE - CURRENT DATE 186,409.13 TOTAL NET ASSETS 186,409.13 TOTAL LIABILITIES AND NET ASSETS 186,409.13 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:56AM PAGE:56 ECONOMIC DEVELOPMENT MISC LOCAL REVENUE: 41-4410-1140 INTEREST INCOME 90.99 714.64 600.00 ( 114.64) 119.1 TOTAL MISC LOCAL REVENUE 90.99 714.64 600.00 ( 114.64) 119.1 TRANSFERS IN: 41-4410-5510 TRANSFER FROM GENERAL FUND 31,250.00 125,000.00 125,000.00 .00 100.0 TOTAL TRANSFERS IN 31,250.00 125,000.00 125,000.00 .00 100.0 TOTAL ECONOMIC DEVELOPMENT 31,340.99 125,714.64 125,600.00 ( 114.64) 100.1 TOTAL FUND REVENUE 31,340.99 125,714.64 125,600.00 ( 114.64) 100.1 ECONOMIC DEVELOPMENT PROFESSIONAL SERVICES: 41-5410-2158 MISC CONTRACTUAL SERVICES .00 .00 113,500.00 113,500.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 113,500.00 113,500.00 .0 CAPITALIZED EXPENDITURES: 41-5410-6547 EQUIPMENT/FURNITURE .00 11,445.50 11,500.00 54.50 99.5 TOTAL CAPITALIZED EXPENDITURES .00 11,445.50 11,500.00 54.50 99.5 TOTAL ECONOMIC DEVELOPMENT .00 11,445.50 125,000.00 113,554.50 9.2 TOTAL FUND EXPENDITURES .00 11,445.50 125,000.00 113,554.50 9.2 NET REVENUE OVER EXPENDITURES 31,340.99 114,269.14 600.00 ( 113,669.14) 19044.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 BROWNFIELD GRANT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:56AM PAGE:57 ASSETS CURRENT ASSETS: CASH: 42-10000116 CASH ALLOC FR COMBINED FUND ( 24,606.79) TOTAL CASH ( 24,606.79) ACCOUNTS RECEIVABLE: 42-10000131 ACCOUNTS RECEIVABLE - GENERAL 27,776.80 TOTAL ACCOUNTS RECEIVABLE 27,776.80 TOTAL CURRENT ASSETS 3,170.01 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 3,170.01 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 42-20000201 ACCOUNTS PAY ALLOC TO FUNDS 3,171.81 TOTAL ACCOUNTS PAYABLE 3,171.81 TOTAL CURRENT LIABILITIES 3,171.81 TOTAL LIABILITIES 3,171.81 NET ASSETS OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 1.80) BALANCE - CURRENT DATE ( 1.80) TOTAL NET ASSETS ( 1.80) TOTAL LIABILITIES AND NET ASSETS 3,170.01 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:56AM PAGE:58 BROWNFIELD HAZARDOUS - REVENUE FEDERAL REVENUE SOURCES: 42-4870-4281 EPA 17,280.55 17,280.55 195,030.00 177,749.45 8.9 TOTAL FEDERAL REVENUE SOURCES 17,280.55 17,280.55 195,030.00 177,749.45 8.9 TOTAL BROWNFIELD HAZARDOUS - REVENUE 17,280.55 17,280.55 195,030.00 177,749.45 8.9 BROWNFIELD PETROLEUM - REVENUE FEDERAL REVENUE SOURCES: 42-4871-4281 EPA 10,496.25 10,496.25 95,070.00 84,573.75 11.0 TOTAL FEDERAL REVENUE SOURCES 10,496.25 10,496.25 95,070.00 84,573.75 11.0 TOTAL BROWNFIELD PETROLEUM - REVENUE 10,496.25 10,496.25 95,070.00 84,573.75 11.0 TOTAL FUND REVENUE 27,776.80 27,776.80 290,100.00 262,323.20 9.6 BROWNFIELD HAZARDOUS PURCHASED SERVICES: 42-5870-2123 MEALS/LODGING/TRAVEL .00 311.29 400.00 88.71 77.8 TOTAL PURCHASED SERVICES .00 311.29 400.00 88.71 77.8 PROFESSIONAL SERVICES: 42-5870-2158 MISC CONTRACTUAL SERVICES ( 3,452.74) 16,969.26 194,530.00 177,560.74 8.7 TOTAL PROFESSIONAL SERVICES ( 3,452.74) 16,969.26 194,530.00 177,560.74 8.7 TOTAL BROWNFIELD HAZARDOUS ( 3,452.74) 17,280.55 194,930.00 177,649.45 8.9 BROWNFIELD PETROLEUM PURCHASED SERVICES: 42-5871-2123 MEALS/LODGING/TRAVEL .00 313.10 400.00 86.90 78.3 TOTAL PURCHASED SERVICES .00 313.10 400.00 86.90 78.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 BROWNFIELD GRANT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:56AM PAGE:59 PROFESSIONAL SERVICES: 42-5871-2158 MISC CONTRACTUAL SERVICES 6,624.55 10,184.95 94,670.00 84,485.05 10.8 TOTAL PROFESSIONAL SERVICES 6,624.55 10,184.95 94,670.00 84,485.05 10.8 TOTAL BROWNFIELD PETROLEUM 6,624.55 10,498.05 95,070.00 84,571.95 11.0 TOTAL FUND EXPENDITURES 3,171.81 27,778.60 290,000.00 262,221.40 9.6 NET REVENUE OVER EXPENDITURES 24,604.99 ( 1.80) 100.00 101.80 ( 1.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:57AM PAGE:60 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND ( 22,248.58) TOTAL CASH ( 22,248.58) INVESTMENTS: 47-10000122 TIME DEPOSITS - SHORT TERM 101,581.01 TOTAL INVESTMENTS 101,581.01 ACCOUNTS RECEIVABLE: 47-10000139 ACCRUED INTEREST RECEIVABLE 551.30 TOTAL ACCOUNTS RECEIVABLE 551.30 TOTAL CURRENT ASSETS 79,883.73 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 79,883.73 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 47-20000201 ALLOCATION FROM AP FUND 91,816.24 TOTAL ACCOUNTS PAYABLE 91,816.24 TOTAL CURRENT LIABILITIES 91,816.24 TOTAL LIABILITIES 91,816.24 NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR 271,660.57 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS 492,901.44 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:57AM PAGE:61 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 504,833.95) BALANCE - CURRENT DATE ( 11,932.51) TOTAL NET ASSETS ( 11,932.51) TOTAL LIABILITIES AND NET ASSETS 79,883.73 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:57AM PAGE:62 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME 24.10 5,884.42 5,750.00 ( 134.42) 102.3 TOTAL MISC LOCAL REVENUE 24.10 5,884.42 5,750.00 ( 134.42) 102.3 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND .00 250,000.00 250,000.00 .00 100.0 TOTAL TRANSFERS IN .00 250,000.00 250,000.00 .00 100.0 TOTAL GENERAL FUND EQUIP RES-REVENUE 24.10 255,884.42 255,750.00 ( 134.42) 100.1 TOTAL FUND REVENUE 24.10 255,884.42 255,750.00 ( 134.42) 100.1 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE 66,602.24 625,902.37 607,174.00 ( 18,728.37) 103.1 47-5470-6548 VEHICLES 23,980.28 134,816.00 153,800.00 18,984.00 87.7 TOTAL CAPITALIZED EXPENDITURES 90,582.52 760,718.37 760,974.00 255.63 100.0 TOTAL GENERAL FUND EQUIPMENT RESERVE 90,582.52 760,718.37 760,974.00 255.63 100.0 TOTAL FUND EXPENDITURES 90,582.52 760,718.37 760,974.00 255.63 100.0 NET REVENUE OVER EXPENDITURES ( 90,558.42) ( 504,833.95) ( 505,224.00) ( 390.05) ( 99.9) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:58AM PAGE:63 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 116,302.97 TOTAL CASH 116,302.97 TOTAL CURRENT ASSETS 116,302.97 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 116,302.97 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR ( 139,984.24) 50-30000301 RESERVED FUND BALANCE 155,959.63 TOTAL CAPITAL ASSETS 15,975.39 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 100,327.58 BALANCE - CURRENT DATE 116,302.97 TOTAL NET ASSETS 116,302.97 TOTAL LIABILITIES AND NET ASSETS 116,302.97 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:58AM PAGE:64 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1140 INTEREST INCOME 53.54 327.58 500.00 172.42 65.5 TOTAL MISC LOCAL REVENUE 53.54 327.58 500.00 172.42 65.5 TRANSFERS IN: 50-4500-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 FIRE EQUIPMENT - REVENUE 25,053.54 100,327.58 100,500.00 172.42 99.8 TOTAL FUND REVENUE 25,053.54 100,327.58 100,500.00 172.42 99.8 FIRE EQUIPMENT CASH FUND APPROPRIATION: 50-5500-0150 REPLACEMENT RESERVE .00 .00 100,000.00 100,000.00 .0 TOTAL CASH FUND APPROP .00 .00 100,000.00 100,000.00 .0 TOTAL FIRE EQUIPMENT .00 .00 100,000.00 100,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 100,000.00 100,000.00 .0 NET REVENUE OVER EXPENDITURES 25,053.54 100,327.58 500.00 ( 99,827.58) 20065.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:65 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, 2019 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:66 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 52,677.77 TOTAL CASH 52,677.77 TOTAL CURRENT ASSETS 52,677.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 52,677.77 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 57,677.77 TOTAL CAPITAL ASSETS 57,677.77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 5,000.00) BALANCE - CURRENT DATE 52,677.77 TOTAL NET ASSETS 52,677.77 TOTAL LIABILITIES AND NET ASSETS 52,677.77 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:67 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE .00 5,000.00 5,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 5,000.00 5,000.00 .00 100.0 TOTAL TRAIN CAR RESTORATION .00 5,000.00 5,000.00 .00 100.0 TOTAL FUND EXPENDITURES .00 5,000.00 5,000.00 .00 100.0 NET REVENUE OVER EXPENDITURES .00 ( 5,000.00) ( 5,000.00) .00 ( 100.0) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:68 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 127,313.86 TOTAL CASH 127,313.86 INVESTMENTS: 55-10000122 TIME DEPOSITS - SHORT TERM 100,592.33 TOTAL INVESTMENTS 100,592.33 TOTAL CURRENT ASSETS 227,906.19 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 227,906.19 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 183,663.86 TOTAL CAPITAL ASSETS 183,663.86 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 44,242.33 BALANCE - CURRENT DATE 227,906.19 TOTAL NET ASSETS 227,906.19 TOTAL LIABILITIES AND NET ASSETS 227,906.19 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:69 POOL IMPROVEMENTS - REVENUE MISC LOCAL REVENUE: 55-4550-1140 INTEREST INCOME .00 592.33 .00 ( 592.33) .0 TOTAL MISC LOCAL REVENUE .00 592.33 .00 ( 592.33) .0 TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND 37,500.00 50,000.00 50,000.00 .00 100.0 TOTAL TRANSFERS IN 37,500.00 50,000.00 50,000.00 .00 100.0 TOTAL POOL IMPROVEMENTS - REVENUE 37,500.00 50,592.33 50,000.00 ( 592.33) 101.2 TOTAL FUND REVENUE 37,500.00 50,592.33 50,000.00 ( 592.33) 101.2 POOL IMPROVEMENTS CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG .00 6,350.00 32,500.00 26,150.00 19.5 TOTAL CAPITALIZED EXPENDITURES .00 6,350.00 32,500.00 26,150.00 19.5 TOTAL POOL IMPROVEMENTS .00 6,350.00 32,500.00 26,150.00 19.5 TOTAL FUND EXPENDITURES .00 6,350.00 32,500.00 26,150.00 19.5 NET REVENUE OVER EXPENDITURES 37,500.00 44,242.33 17,500.00 ( 26,742.33) 252.8 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:70 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 2,545,256.42 TOTAL CASH 2,545,256.42 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 5,456,224.69 TOTAL INVESTMENTS 5,456,224.69 ACCOUNTS RECEIVABLE: 56-10000139 ACCRUED INTEREST RECEIVABLE 11,086.88 56-10000156 DUE FROM OTHER FUNDS 49,588.59 TOTAL ACCOUNTS RECEIVABLE 60,675.47 TOTAL CURRENT ASSETS 8,062,156.58 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 8,062,156.58 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 22,028.39 56-20000204 ACCOUNTS PAYABLE - EOY 30,022.87 TOTAL ACCOUNTS PAYABLE 52,051.26 TOTAL CURRENT LIABILITIES 52,051.26 TOTAL LIABILITIES 52,051.26 NET ASSETS CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 6,727,134.45 TOTAL CAPITAL ASSETS 6,727,134.45 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:71 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,282,970.87 BALANCE - CURRENT DATE 8,010,105.32 TOTAL NET ASSETS 8,010,105.32 TOTAL LIABILITIES AND NET ASSETS 8,062,156.58 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:72 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1140 INTEREST INCOME 2,400.06 102,419.51 100,000.00 ( 2,419.51) 102.4 TOTAL MISC LOCAL REVENUE 2,400.06 102,419.51 100,000.00 ( 2,419.51) 102.4 FEDERAL REVENUE SOURCES: 56-4560-4289 WYDOT .00 19,444.80 175,000.00 155,555.20 11.1 TOTAL FEDERAL REVENUE SOURCES .00 19,444.80 175,000.00 155,555.20 11.1 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND 500,000.00 2,000,000.00 2,000,000.00 .00 100.0 TOTAL TRANSFERS IN 500,000.00 2,000,000.00 2,000,000.00 .00 100.0 TOTAL STREET IMPROVEMENTS-REVENUE 502,400.06 2,121,864.31 2,275,000.00 153,135.69 93.3 TOTAL FUND REVENUE 502,400.06 2,121,864.31 2,275,000.00 153,135.69 93.3 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY 14,613.69 216,427.98 973,000.00 756,572.02 22.2 56-5560-2158 MISC CONTRACTUAL SERVICES 1,527.50 24,066.74 55,000.00 30,933.26 43.8 TOTAL PROFESSIONAL SERVICES 16,141.19 240,494.72 1,028,000.00 787,505.28 23.4 CAPITALIZED EXPENDITURES: 56-5560-6544 OTHER THAN BLDG 5,887.20 598,398.72 3,980,750.00 3,382,351.28 15.0 TOTAL CAPITALIZED EXPENDITURES 5,887.20 598,398.72 3,980,750.00 3,382,351.28 15.0 TOTAL STREET IMPROVEMENTS 22,028.39 838,893.44 5,008,750.00 4,169,856.56 16.8 TOTAL FUND EXPENDITURES 22,028.39 838,893.44 5,008,750.00 4,169,856.56 16.8 NET REVENUE OVER EXPENDITURES 480,371.67 1,282,970.87 ( 2,733,750.00) ( 4,016,720.87) 46.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 07:59AM PAGE:73 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 393,438.16 TOTAL CASH 393,438.16 INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 1,005,745.21 TOTAL INVESTMENTS 1,005,745.21 TOTAL CURRENT ASSETS 1,399,183.37 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,399,183.37 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 38,084.51 57-20000204 ACCOUNTS PAYABLE - EOY 39.35 TOTAL ACCOUNTS PAYABLE 38,123.86 TOTAL CURRENT LIABILITIES 38,123.86 TOTAL LIABILITIES 38,123.86 NET ASSETS CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 1,564,062.43 57-30000305 FUND BALANCE RESERVE-PW FACILI 200,000.00 TOTAL CAPITAL ASSETS 1,764,062.43 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:00AM PAGE:74 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 403,002.92) BALANCE - CURRENT DATE 1,361,059.51 TOTAL NET ASSETS 1,361,059.51 TOTAL LIABILITIES AND NET ASSETS 1,399,183.37 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:00AM PAGE:75 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME .00 5,745.21 5,000.00 ( 745.21) 114.9 TOTAL MISC LOCAL REVENUE .00 5,745.21 5,000.00 ( 745.21) 114.9 TOTAL CAPITAL IMP - FACILITIES REV .00 5,745.21 5,000.00 ( 745.21) 114.9 TOTAL FUND REVENUE .00 5,745.21 5,000.00 ( 745.21) 114.9 CAPITAL IMP -FACILITIES PROFESSIONAL SERVICES: 57-5570-2153 ARCHITECT/ENGINEERING/SURVEY 15,165.30 74,459.59 65,000.00 ( 9,459.59) 114.6 57-5570-2158 MISC CONTRACTUAL SERVICES .00 3,125.00 3,125.00 .00 100.0 TOTAL PROFESSIONAL SERVICES 15,165.30 77,584.59 68,125.00 ( 9,459.59) 113.9 CAPITALIZED EXPENDITURES: 57-5570-6542 BUILDINGS/IMPROVEMENTS 22,806.48 46,913.26 75,000.00 28,086.74 62.6 57-5570-6544 OTHER THAN BLDG 112.73 284,250.28 300,000.00 15,749.72 94.8 TOTAL CAPITALIZED EXPENDITURES 22,919.21 331,163.54 375,000.00 43,836.46 88.3 TOTAL CAPITAL IMP -FACILITIES 38,084.51 408,748.13 443,125.00 34,376.87 92.2 TOTAL FUND EXPENDITURES 38,084.51 408,748.13 443,125.00 34,376.87 92.2 NET REVENUE OVER EXPENDITURES ( 38,084.51) ( 403,002.92) ( 438,125.00) ( 35,122.08) ( 92.0) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:01AM PAGE:76 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 238,248.03 TOTAL CASH 238,248.03 INVESTMENTS: 65-10000120 INVESTMENT POOL 490,000.00 65-10000122 TIME DEPOSITS - SHORT TERM 816,309.84 TOTAL INVESTMENTS 1,306,309.84 ACCOUNTS RECEIVABLE: 65-10000139 ACCRUED INTEREST RECEIVABLE 2,501.99 TOTAL ACCOUNTS RECEIVABLE 2,501.99 TOTAL CURRENT ASSETS 1,547,059.86 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,547,059.86 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 315,115.43 65-20000210 RETAINAGE PAYABLE 34,729.17 TOTAL ACCOUNTS PAYABLE 349,844.60 DUE TO OTHER FUNDS: 65-20000245 DUE TO OTHER FUND 35,899.59 TOTAL DUE TO OTHER FUNDS 35,899.59 TOTAL CURRENT LIABILITIES 385,744.19 TOTAL LIABILITIES 385,744.19 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:01AM PAGE:77 CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 758,423.51 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 781,339.40 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 379,976.27 BALANCE - CURRENT DATE 1,161,315.67 TOTAL NET ASSETS 1,161,315.67 TOTAL LIABILITIES AND NET ASSETS 1,547,059.86 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:01AM PAGE:78 PARK - REVE MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME .00 18,134.34 18,000.00 ( 134.34) 100.8 TOTAL MISC LOCAL REVENUE .00 18,134.34 18,000.00 ( 134.34) 100.8 TRANSFERS IN: 65-4650-5510 TRANSFER FROM GENERAL FUND 250,000.00 1,000,000.00 1,000,000.00 .00 100.0 65-4650-5540 TRANSFER FROM CAPITAL IMP RSRV .00 .00 1,000,000.00 1,000,000.00 .0 TOTAL TRANSFERS IN 250,000.00 1,000,000.00 2,000,000.00 1,000,000.00 50.0 TOTAL PARK - REVE 250,000.00 1,018,134.34 2,018,000.00 999,865.66 50.5 TOTAL FUND REVENUE 250,000.00 1,018,134.34 2,018,000.00 999,865.66 50.5 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY 20,282.35 108,035.63 100,000.00 ( 8,035.63) 108.0 65-5650-2158 MISC CONTRACTUAL SERVICES .00 1,333.34 1,500.00 166.66 88.9 TOTAL PROFESSIONAL SERVICES 20,282.35 109,368.97 101,500.00 ( 7,868.97) 107.8 CAPITALIZED EXPENDITURES: 65-5650-6544 OTHER THAN BLDG 318,149.82 528,789.10 908,600.00 379,810.90 58.2 TOTAL CAPITALIZED EXPENDITURES 318,149.82 528,789.10 908,600.00 379,810.90 58.2 TOTAL PARK IMPROVEMENTS 338,432.17 638,158.07 1,010,100.00 371,941.93 63.2 TOTAL FUND EXPENDITURES 338,432.17 638,158.07 1,010,100.00 371,941.93 63.2 NET REVENUE OVER EXPENDITURES ( 88,432.17) 379,976.27 1,007,900.00 627,923.73 37.7 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:79 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 35,874.46 TOTAL CASH 35,874.46 INVESTMENTS: 90-10000120 INVESTMENT POOL 107,251.73 90-10000122 TIME DEPOSITS - SHORT TERM 25,246.94 TOTAL INVESTMENTS 132,498.67 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 75.46 TOTAL ACCOUNTS RECEIVABLE 75.46 TOTAL CURRENT ASSETS 168,448.59 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 168,448.59 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 22,838.19 TOTAL CAPITAL ASSETS 22,838.19 RESTRICTED ASSETS: 90-30000315 FUND BALANCE RESTRICTED 141,610.40 TOTAL RESTRICTED ASSETS 141,610.40 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 4,000.00 BALANCE - CURRENT DATE 168,448.59 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:80 TOTAL NET ASSETS 168,448.59 TOTAL LIABILITIES AND NET ASSETS 168,448.59 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:81 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES 300.00 4,000.00 3,500.00 ( 500.00) 114.3 TOTAL REVENUE 300.00 4,000.00 3,500.00 ( 500.00) 114.3 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 273.01 3,033.01 2,500.00 ( 533.01) 121.3 TOTAL MISC LOCAL REVENUE 273.01 3,033.01 2,500.00 ( 533.01) 121.3 TOTAL PERPETUAL CARE - REVENUE 573.01 7,033.01 6,000.00 ( 1,033.01) 117.2 TOTAL FUND REVENUE 573.01 7,033.01 6,000.00 ( 1,033.01) 117.2 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 912.33 3,033.01 2,500.00 ( 533.01) 121.3 TOTAL TRANSFERS TO OTHER FUNDS 912.33 3,033.01 2,500.00 ( 533.01) 121.3 TOTAL PERPETUAL CARE 912.33 3,033.01 2,500.00 ( 533.01) 121.3 TOTAL FUND EXPENDITURES 912.33 3,033.01 2,500.00 ( 533.01) 121.3 NET REVENUE OVER EXPENDITURES ( 339.32) 4,000.00 3,500.00 ( 500.00) 114.3 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:82 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, 2019 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:83 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 14,234.32 TOTAL CASH 14,234.32 TOTAL CURRENT ASSETS 14,234.32 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 14,234.32 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 3,673.48 92-20000406 HISTORIC PRESERVATION 5,069.13 92-20000407 HISTORIC PRESERVATION-KIOSK 16,789.30 92-20000408 HISTORIC PRESERVATION - MOVIE 615.38 TOTAL OTHER PAYABLES 26,147.29 TOTAL CURRENT LIABILITIES 26,147.29 TOTAL LIABILITIES 26,147.29 NET ASSETS CAPITAL ASSETS: 92-30000300 FUND BALANCE/BEGINNING OF YEAR ( 12,350.00) TOTAL CAPITAL ASSETS ( 12,350.00) OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 437.03 BALANCE - CURRENT DATE ( 11,912.97) TOTAL NET ASSETS ( 11,912.97) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:84 TOTAL LIABILITIES AND NET ASSETS 14,234.32 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:85 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 750.00 3,000.00 3,000.00 .00 100.0 TOTAL TRANSFERS IN 750.00 3,000.00 3,000.00 .00 100.0 TOTAL HISTORIC CMSN - REVENU 750.00 3,000.00 3,000.00 .00 100.0 TOTAL FUND REVENUE 750.00 3,000.00 3,000.00 .00 100.0 HISTORIC PRESERVATION PROFESSIONAL SERVICES: 92-5920-2158 MISC CONTRACTUAL SERVICES .00 2,562.97 3,000.00 437.03 85.4 TOTAL PROFESSIONAL SERVICES .00 2,562.97 3,000.00 437.03 85.4 TOTAL HISTORIC PRESERVATION .00 2,562.97 3,000.00 437.03 85.4 TOTAL FUND EXPENDITURES .00 2,562.97 3,000.00 437.03 85.4 NET REVENUE OVER EXPENDITURES 750.00 437.03 .00 ( 437.03) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:86 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 46,856.17 TOTAL CASH 46,856.17 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 40,385.24 TOTAL INVESTMENTS 40,385.24 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 103.20 TOTAL ACCOUNTS RECEIVABLE 103.20 TOTAL CURRENT ASSETS 87,344.61 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 87,344.61 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 435.73 TOTAL ACCOUNTS PAYABLE 435.73 UTILITY DEPOSITS PAYABLE: 96-20000229 UTILITY DEPOSITS 79,716.29 TOTAL UTILITY DEPOSITS PAYABLE 79,716.29 TOTAL CURRENT LIABILITIES 80,152.02 TOTAL LIABILITIES 80,152.02 NET ASSETS CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 7,192.59 TOTAL CAPITAL ASSETS 7,192.59 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:87 TOTAL NET ASSETS 7,192.59 TOTAL LIABILITIES AND NET ASSETS 87,344.61 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2019 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:88 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME .00 930.64 900.00 ( 30.64) 103.4 TOTAL MISC LOCAL REVENUE .00 930.64 900.00 ( 30.64) 103.4 TOTAL UTILITY DEPOSITS - REVENUE .00 930.64 900.00 ( 30.64) 103.4 TOTAL FUND REVENUE .00 930.64 900.00 ( 30.64) 103.4 UTILITY DEPOSIT TRANSFERS TO OTHER FUNDS: 96-5960-5531 TRANSFER TO WATER 339.95 930.64 900.00 ( 30.64) 103.4 TOTAL TRANSFERS TO OTHER FUNDS 339.95 930.64 900.00 ( 30.64) 103.4 TOTAL UTILITY DEPOSIT 339.95 930.64 900.00 ( 30.64) 103.4 TOTAL FUND EXPENDITURES 339.95 930.64 900.00 ( 30.64) 103.4 NET REVENUE OVER EXPENDITURES ( 339.95) .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2019 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 09/19/2019 08:07AM PAGE:89 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