Document Douglas_doc_6c6aab1a52

CITY OF DOUGLAS COMBINED CASH INVESTMENT JUNE 30, 2016 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:1 COMBINED CASH ACCOUNTS 01-10000102 CASH - CONVERSE COUNTY BANK 5,528,784.00 01-10000104 CASH - EMPLOYEE HLTH CARE BNFT 115,998.28 01-10000112 PETTY CASH 200.00 01-10000113 CASH ON HAND 350.00 TOTAL COMBINED CASH 5,645,332.28 01-11900000 TOTAL ALLOC TO OTHER FUNDS ( 5,645,332.28) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND 2,345,565.39 11 ALLOCATION TO IMPACT ASSISTANCE FUND 770.03 13 ALLOCATION TO POLICE SPECIAL PROJECTS FUND 46,578.54 31 ALLOCATION TO WATER FUND 686,235.58 32 ALLOCATION TO SEWER FUND 335,804.38 33 ALLOCATION TO SANITATION FUND 128,298.53 34 ALLOCATION TO LANDFILL FUND 314,508.01 39 ALLOCATION TO EMPLOYEE HEALTH CARE FUND 394,373.62 40 ALLOCATION TO CAPITAL IMP RESERVE FUND 21,219.90 47 ALLOCATION TO GENERAL FUND EQUIPMENT RESERVE 488,289.52 50 ALLOCATION TO CAPITAL PROJ FIRE EQUIP FUND 38,982.17 53 ALLOCATION TO CPTL PROJ - CLG PROJECTS 2,811.66 54 ALLOCATION TO TRAIN CAR RESTORATION 57,677.77 55 ALLOCATION TO POOL IMPROVEMENTS FUND 186,656.86 56 ALLOCATION TO STREET IMPROVEMENT FUND 226,779.06 57 ALLOCATION TO CAPITAL IMP -PUBLIC FACILITIES 27,709.87 65 ALLOCATION TO CAPTL PROJ-PARK FUND 251,009.15 90 ALLOCATION TO PERPETUAL CARE FUND 11,956.59 91 ALLOCATION TO VISABLE MEMORIES MEMORIAL FUND 2.75 92 ALLOCATION TO HISTORIC CMSN FUND 58,693.05 96 ALLOCATION TO UTILITY DEPOSIT FUND 21,409.85 TOTAL ALLOCATIONS TO OTHER FUNDS 5,645,332.28 ALLOCATION FROM COMBINED CASH FUND - 01-11900000 ( 5,645,332.28) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:2 ASSETS CURRENT ASSETS: CASH: 10-10000116 CASH ALLOC FR COMBINED FUND 2,345,565.39 TOTAL CASH 2,345,565.39 INVESTMENTS: 10-10000120 INVESTMENT POOL 388,941.35 10-10000122 TIME DEPOSITS - SHORT TERM 14,265,649.30 TOTAL INVESTMENTS 14,654,590.65 ACCOUNTS RECEIVABLE: 10-10000130 ACCOUNTS RECEIVABLE - EOY 55,866.30 10-10000131 ACCOUNTS RECEIVABLE - GENERAL ( 17,942.35) 10-10000132 ACCOUNTS REC - PROPERTY TAX 46,046.39 10-10000133 ACCOUNTS CRT 11,362.65 10-10000134 ACCOUNTS RECEIVABLE - SALES TX 1,576,225.72 10-10000135 ACCOUNTS RECEIVABLE - PEST CNT 512.13 10-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 18,351.74) 10-10000139 ACCRUED INTEREST RECEIVABLE 6,516.73 TOTAL ACCOUNTS RECEIVABLE 1,660,235.83 TOTAL CURRENT ASSETS 18,660,391.87 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 18,660,391.87 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 10-20000201 ALLOCATION FROM AP FUND 324,781.33 10-20000204 ACCOUNTS PAYABLE - EOY ( 9,719.39) 10-20000207 SALES TAX PAYABLE 37.89 10-20000215 WAGES PAYABLE 96,502.91 TOTAL ACCOUNTS PAYABLE 411,602.74 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:3 PAYROLL DEDUCTIONS PAYABLE: 10-20000223 FICA PAYABLE .32 10-20000224 DEFERRED COMPENSATION PAYABLE 52,450.91 10-20000227 WORKERS COMP INS PAYABLE 53,190.74 TOTAL PAYROLL DEDUCTIONS PAYABLE 105,641.97 UTILITY DEPOSITS PAYABLE: 10-20000229 UNCLAIMED PROPERTY 1,660.67 TOTAL UTILITY DEPOSITS PAYABLE 1,660.67 DUE TO OTHER FUNDS: 10-20000245 DUE TO OTHER FUNDS 71,021.29 TOTAL DUE TO OTHER FUNDS 71,021.29 TOTAL CURRENT LIABILITIES 589,926.67 TOTAL LIABILITIES 589,926.67 NET ASSETS CAPITAL ASSETS: 10-30000300 FUND BALANCE/BEGINNING OF YEAR 23,620,266.18 10-30000301 FUND BALANCE RESERVE 1,670,000.00 TOTAL CAPITAL ASSETS 25,290,266.18 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 7,219,800.98) BALANCE - CURRENT DATE 18,070,465.20 TOTAL NET ASSETS 18,070,465.20 TOTAL LIABILITIES AND NET ASSETS 18,660,391.87 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:4 GENERAL - REVENUE MISC LOCAL REVENUE: 10-4100-1107 OTHER 480.50 75,035.59 4,000.00 ( 71,035.59) 1875.9 10-4100-1108 COPY FEES/VIN CHECKS 222.00 2,029.56 1,300.00 ( 729.56) 156.1 10-4100-1109 REIMBURSEMENTS 8,535.97 77,524.14 80,000.00 2,475.86 96.9 10-4100-1112 CONTRIBUTIONS .00 12,035.95 12,000.00 ( 35.95) 100.3 10-4100-1115 LEASES/RENT .00 8,960.00 9,300.00 340.00 96.3 10-4100-1120 FINES/FORFEITS 3,375.00 28,823.00 20,000.00 ( 8,823.00) 144.1 10-4100-1122 TECHNOLOGY SURCHARGE 845.00 2,905.00 1,300.00 ( 1,605.00) 223.5 10-4100-1130 CASH LONG/SHORT .00 .01 50.00 49.99 .0 10-4100-1140 INTEREST INCOME 4,286.93 107,404.29 120,000.00 12,595.71 89.5 10-4100-1155 SIDEWALK/TREE REHAB PARTICIPTI .00 3,766.41 12,500.00 8,733.59 30.1 TOTAL MISC LOCAL REVENUE 17,745.40 318,483.95 260,450.00 ( 58,033.95) 122.3 LIQUOR LICENSES: 10-4100-1211 LICENSES - LIQUOR 150.00 23,170.99 22,850.00 ( 320.99) 101.4 TOTAL LIQUOR LICENSES 150.00 23,170.99 22,850.00 ( 320.99) 101.4 OTHER LICENSES/PERMITS: 10-4100-1230 LICENSES - TRANSIENT MERCHANT .00 .00 500.00 500.00 .0 TOTAL OTHER LICENSES/PERMITS .00 .00 500.00 500.00 .0 CONTRACTORS LICENSES: 10-4100-1241 LICENSES - CONTRACTORS 298.00 14,348.00 12,750.00 ( 1,598.00) 112.5 TOTAL CONTRACTORS LICENSES 298.00 14,348.00 12,750.00 ( 1,598.00) 112.5 BUILDING PERMITS: 10-4100-1250 BUILDING PERMITS 1,806.58 16,858.98 12,000.00 ( 4,858.98) 140.5 TOTAL BUILDING PERMITS 1,806.58 16,858.98 12,000.00 ( 4,858.98) 140.5 ZONING/CONDITIONAL USE: 10-4100-1261 PLANNING FEES 237.00 3,414.00 2,000.00 ( 1,414.00) 170.7 TOTAL ZONING/CONDITIONAL USE 237.00 3,414.00 2,000.00 ( 1,414.00) 170.7 PROPERTY TAXES: 10-4100-1320 PROPERTY TAX - CURRENT 109,901.19 424,493.23 315,000.00 ( 109,493.23) 134.8 10-4100-1321 PROPERTY TAX - PRIOR YEARS 150.24 601.10 1,500.00 898.90 40.1 10-4100-1322 PROPERTY TAX - AUTO 14,456.60 179,031.79 145,000.00 ( 34,031.79) 123.5 10-4100-1323 PROPERTY TAX - INTEREST 195.27 1,318.86 500.00 ( 818.86) 263.8 10-4100-1324 PROPERTY TAX - HANDLING FEES ( 623.49) ( 3,026.67) ( 2,000.00) 1,026.67 ( 151.3) TOTAL PROPERTY TAXES 124,079.81 602,418.31 460,000.00 ( 142,418.31) 131.0 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:5 FRANCHISE FEES: 10-4100-1330 FRANCHISE FEES - RMP 16,970.96 233,771.59 210,000.00 ( 23,771.59) 111.3 10-4100-1331 FRANCHISE FEES - CABLE TV .00 18,227.91 14,000.00 ( 4,227.91) 130.2 10-4100-1332 FRANCHISE FEES - SOURCE GAS .00 30,806.44 30,000.00 ( 806.44) 102.7 10-4100-1333 FRANCHISE FEES - TELEPHONE .00 8,771.64 10,000.00 1,228.36 87.7 TOTAL FRANCHISE FEES 16,970.96 291,577.58 264,000.00 ( 27,577.58) 110.5 MANAGEMENT FEES: 10-4100-1420 MANAGEMENT FEES - LANDFILL 21,850.75 87,403.00 87,403.00 .00 100.0 10-4100-1421 MANAGEMENT FEES - WATER 73,694.00 276,776.00 270,776.00 ( 6,000.00) 102.2 10-4100-1422 MANAGEMENT FEES - SEWER 45,522.50 182,090.00 182,090.00 .00 100.0 10-4100-1423 MANAGEMENT FEES - SANITATION 12,090.75 48,363.00 48,363.00 .00 100.0 TOTAL MANAGEMENT FEES 153,158.00 594,632.00 588,632.00 ( 6,000.00) 101.0 WEED ABATEMENT: 10-4100-1430 WEED MOWING CHARGES 227.76 432.98 .00 ( 432.98) .0 10-4100-1431 PEST CONTROL .00 14,324.10 14,250.00 ( 74.10) 100.5 10-4100-1432 PROPERTY TAX - WEED CONTROL .00 .00 20,000.00 20,000.00 .0 TOTAL WEED ABATEMENT 227.76 14,757.08 34,250.00 19,492.92 43.1 BURIAL FEES: 10-4100-1510 CEMETERY - BURIALS 1,000.00 7,750.00 7,500.00 ( 250.00) 103.3 TOTAL BURIAL FEES 1,000.00 7,750.00 7,500.00 ( 250.00) 103.3 LOT SALES: 10-4100-1522 CEMETERY - LOT SALES 4,000.00 6,200.00 2,500.00 ( 3,700.00) 248.0 TOTAL LOT SALES 4,000.00 6,200.00 2,500.00 ( 3,700.00) 248.0 POOL: 10-4100-1650 POOL - USER FEES 14,265.00 14,265.00 .00 ( 14,265.00) .0 TOTAL POOL 14,265.00 14,265.00 .00 ( 14,265.00) .0 MINERAL EXTRACTION: 10-4100-3110 STATE SUPPLEMENTAL DISTR .00 509,878.71 509,879.00 .29 100.0 10-4100-3111 SEVERENCE TAX - 2% 56,773.54 227,094.16 227,000.00 ( 94.16) 100.0 10-4100-3112 MINERAL ROYALTIES 75,154.79 316,505.34 323,000.00 6,494.66 98.0 TOTAL MINERAL EXTRACTION 131,928.33 1,053,478.21 1,059,879.00 6,400.79 99.4 SALES TAX: 10-4100-3241 SALES TAX - STATE 341,488.59 4,163,682.53 4,000,000.00 ( 163,682.53) 104.1 10-4100-3245 SALES TAX - LOCAL OPTION 279,894.61 3,422,821.80 3,300,000.00 ( 122,821.80) 103.7 TOTAL SALES TAX 621,383.20 7,586,504.33 7,300,000.00 ( 286,504.33) 103.9 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:6 GAS TAX: 10-4100-3250 LOTTERY .00 20,128.21 .00 ( 20,128.21) .0 10-4100-3257 GAS TAX 22,064.72 220,924.28 150,000.00 ( 70,924.28) 147.3 10-4100-3258 SPECIAL FUELS 5,082.18 61,538.28 40,000.00 ( 21,538.28) 153.9 TOTAL GAS TAX 27,146.90 302,590.77 190,000.00 ( 112,590.77) 159.3 OTHER: 10-4100-3262 CIGARETTE TAX 3,276.50 53,333.60 55,000.00 1,666.40 97.0 TOTAL OTHER 3,276.50 53,333.60 55,000.00 1,666.40 97.0 TOTAL GENERAL - REVENUE 1,117,673.44 10,903,782.80 10,272,311.00 ( 631,471.80) 106.2 OPERATING TRANSFERS - IN OPERATING TRANSFERS IN: 10-4998-1854 OPERATING - CARE 198.73 569.60 500.00 ( 69.60) 113.9 TOTAL OPERATING TRANSFERS IN 198.73 569.60 500.00 ( 69.60) 113.9 TOTAL OPERATING TRANSFERS - IN 198.73 569.60 500.00 ( 69.60) 113.9 TOTAL FUND REVENUE 1,117,872.17 10,904,352.40 10,272,811.00 ( 631,541.40) 106.2 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 6.84 138.28 150.00 11.72 92.2 10-5100-1023 EMPLOYEE BENEFITS - HEALTH INS .00 14,889.60 20,025.00 5,135.40 74.4 10-5100-1025 EMPLOYEE BENEFITS - COMP .00 36.92 .00 ( 36.92) .0 10-5100-1032 EMPLOYEE BENEFITS - MDCL SRVC 2,360.00 22,965.00 22,000.00 ( 965.00) 104.4 TOTAL EMPLOYEE BENEFITS 2,366.84 38,029.80 42,175.00 4,145.20 90.2 PURCHASED SERVICES: 10-5100-2101 POSTAGE/FREIGHT 410.89 5,968.26 6,000.00 31.74 99.5 10-5100-2115 PUBLISHING/ADVERTISING 10,610.00 74,849.50 90,000.00 15,150.50 83.2 10-5100-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 269.61 269.61 2,000.00 1,730.39 13.5 TOTAL PURCHASED SERVICES 11,290.50 81,087.37 98,000.00 16,912.63 82.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:7 PROPERTY SERVICES: 10-5100-2131 UTILITY SERVICES - ELECTRICITY 7,450.74 89,145.67 97,000.00 7,854.33 91.9 10-5100-2132 UTILITY SERVICES - WTR/SWR/GRB 636.99 4,349.10 5,000.00 650.90 87.0 10-5100-2133 UTILITY SERVICES - NATURAL GAS 158.36 3,038.87 5,000.00 1,961.13 60.8 10-5100-2134 TELECOMMUNICATIONS 941.40 8,842.86 9,500.00 657.14 93.1 10-5100-2141 EQUIPMENT - RENT .00 180.96 250.00 69.04 72.4 TOTAL PROPERTY SERVICES 9,187.49 105,557.46 116,750.00 11,192.54 90.4 PROFESSIONAL SERVICES: 10-5100-2151 LEGAL 5,305.15 63,706.69 75,000.00 11,293.31 84.9 10-5100-2152 ACCOUNTING/AUDITING .00 33,000.00 33,000.00 .00 100.0 10-5100-2153 ARCHITECHT/ENGINEERING/SURVEY .00 6,227.64 5,000.00 ( 1,227.64) 124.6 10-5100-2155 REPAIRS/MAINTENANCE 1,279.34 5,482.62 7,500.00 2,017.38 73.1 10-5100-2156 MAINTENANCE AGREEMENT 319.99 9,148.82 11,000.00 1,851.18 83.2 10-5100-2157 INSURANCE 175.00 98,391.00 100,000.00 1,609.00 98.4 10-5100-2158 MISC CONTRACTUAL SERVICES 1,063.10 63,013.04 53,400.00 ( 9,613.04) 118.0 10-5100-2166 COLLECTION FEES .00 154.00 100.00 ( 54.00) 154.0 10-5100-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 .00 500.00 500.00 .0 TOTAL PROFESSIONAL SERVICES 8,142.58 279,123.81 285,500.00 6,376.19 97.8 SUPPLIES: 10-5100-3201 OFFICE SUPPLIES 1,103.18 14,636.73 15,000.00 363.27 97.6 10-5100-3210 OPERATING SUPPLIES 525.88 6,038.44 7,500.00 1,461.56 80.5 10-5100-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 2,148.10 3,000.00 851.90 71.6 10-5100-3230 REFRESHMENT SUPPLIES 179.92 1,447.74 1,500.00 52.26 96.5 10-5100-3235 FUEL 9,254.87 61,577.20 100,000.00 38,422.80 61.6 TOTAL SUPPLIES 11,063.85 85,848.21 127,000.00 41,151.79 67.6 FINANCIAL: 10-5100-4344 DEBT PAYMENT - CAPITAL LEASE .00 3,900.00 5,000.00 1,100.00 78.0 TOTAL FINANCIAL .00 3,900.00 5,000.00 1,100.00 78.0 CLAIMS & CONTINGENCY: 10-5100-7601 CLAIMS AGAINST CITY .00 5,378.74 5,500.00 121.26 97.8 10-5100-7606 UNEMPLOYMENT CLAIMS .00 1,532.46 6,000.00 4,467.54 25.5 TOTAL CLAIMS & CONTINGENCY .00 6,911.20 11,500.00 4,588.80 60.1 TOTAL GENERAL GOVT - NON DEPARTMENTL 42,051.26 600,457.85 985,925.00 385,467.15 60.9 GENERAL GOVT - CITY COUNCIL PERSONNEL SERVICES: 10-5101-1001 SALARIES/WAGES - REGULAR 750.00 9,000.00 9,000.00 .00 100.0 TOTAL PERSONNEL SERVICES 750.00 9,000.00 9,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:8 EMPLOYEE BENEFITS: 10-5101-1021 EMPLOYEE BENEFITS - SCL 57.37 688.44 689.00 .56 99.9 10-5101-1025 EMPLOYEE BENEFITS - COMP 61.55 738.60 613.00 ( 125.60) 120.5 TOTAL EMPLOYEE BENEFITS 118.92 1,427.04 1,302.00 ( 125.04) 109.6 PURCHASED SERVICES: 10-5101-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 8,987.00 12,000.00 3,013.00 74.9 10-5101-2122 TRAINING/DEVELOPMENT 5,450.00 8,597.00 15,000.00 6,403.00 57.3 10-5101-2123 MEALS/LODGING/TRAVEL 931.52 11,349.01 35,000.00 23,650.99 32.4 TOTAL PURCHASED SERVICES 6,381.52 28,933.01 62,000.00 33,066.99 46.7 SUPPLIES: 10-5101-3210 OPERATING SUPPLIES .00 343.80 4,500.00 4,156.20 7.6 TOTAL SUPPLIES .00 343.80 4,500.00 4,156.20 7.6 TOTAL GENERAL GOVT - CITY COUNCIL 7,250.44 39,703.85 76,802.00 37,098.15 51.7 GENERAL GOVT - ADMIN SERVICES PERSONNEL SERVICES: 10-5102-1001 SALARIES/WAGES - REGULAR 27,069.36 350,649.70 349,781.00 ( 868.70) 100.3 10-5102-1002 SALARIES/WAGES - OVERTIME .00 65.37 1,500.00 1,434.63 4.4 10-5102-1005 SALARIES/WAGES - LONGEVITY .00 1,410.37 1,411.00 .63 100.0 10-5102-1006 SALARIES/WAGES - ALLOWANCES 525.00 6,300.00 6,300.00 .00 100.0 10-5102-1007 SALARIES/WAGES - INCENTIVE .00 416.00 974.00 558.00 42.7 TOTAL PERSONNEL SERVICES 27,594.36 358,841.44 359,966.00 1,124.56 99.7 EMPLOYEE BENEFITS: 10-5102-1021 EMPLOYEE BENEFITS - SCL 2,228.49 28,762.88 29,242.00 479.12 98.4 10-5102-1023 EMPLOYEE BENEFITS - HEALTH INS 10,241.03 122,887.74 122,453.00 ( 434.74) 100.4 10-5102-1025 EMPLOYEE BENEFITS - COMP 1,258.30 16,363.15 16,370.00 6.85 100.0 10-5102-1026 EMPLOYEE BENEFITS - COMP 1,789.06 23,218.59 22,284.00 ( 934.59) 104.2 10-5102-1028 EMPLOYEE BENEFITS - HLTH 338.38 4,049.22 4,036.00 ( 13.22) 100.3 10-5102-1029 EMPLOYEE BENEFITS - WY 3,176.28 41,025.80 41,189.00 163.20 99.6 TOTAL EMPLOYEE BENEFITS 19,031.54 236,307.38 235,574.00 ( 733.38) 100.3 PURCHASED SERVICES: 10-5102-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 180.00 1,826.00 3,000.00 1,174.00 60.9 10-5102-2122 TRAINING/DEVELOPMENT 450.00 6,229.58 15,600.00 9,370.42 39.9 10-5102-2123 MEALS/LODGING/TRAVEL 662.36 3,646.85 6,500.00 2,853.15 56.1 TOTAL PURCHASED SERVICES 1,292.36 11,702.43 25,100.00 13,397.57 46.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:9 SUPPLIES: 10-5102-3210 OPERATING SUPPLIES .00 194.70 800.00 605.30 24.3 10-5102-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 .00 3,850.00 3,850.00 .0 TOTAL SUPPLIES .00 194.70 4,650.00 4,455.30 4.2 TOTAL GENERAL GOVT - ADMIN SERVICES 47,918.26 607,045.95 625,290.00 18,244.05 97.1 GENERAL GOVT - IT PERSONNEL SERVICES: 10-5103-1001 SALARIES/WAGES - REGULAR 6,102.26 79,254.97 79,337.00 82.03 99.9 10-5103-1005 SALARIES/WAGES - LONGEVITY .00 317.44 318.00 .56 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 540.80 1,587.00 1,046.20 34.1 TOTAL PERSONNEL SERVICES 6,552.26 85,513.21 86,642.00 1,128.79 98.7 EMPLOYEE BENEFITS: 10-5103-1021 EMPLOYEE BENEFITS - SCL 501.26 6,541.90 6,628.00 86.10 98.7 10-5103-1023 EMPLOYEE BENEFITS - HEALTH INS 1,706.89 20,482.68 20,393.00 ( 89.68) 100.4 10-5103-1025 EMPLOYEE BENEFITS - COMP 298.79 3,899.49 3,879.00 ( 20.49) 100.5 10-5103-1028 EMPLOYEE BENEFITS - HLTH 76.28 915.36 915.00 ( .36) 100.0 10-5103-1029 EMPLOYEE BENEFITS - WY 1,014.20 13,149.91 13,186.00 36.09 99.7 TOTAL EMPLOYEE BENEFITS 3,597.42 44,989.34 45,001.00 11.66 100.0 PURCHASED SERVICES: 10-5103-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 718.93 1,800.00 1,081.07 39.9 10-5103-2122 TRAINING/DEVELOPMENT .00 .00 3,000.00 3,000.00 .0 10-5103-2123 MEALS/LODGING/TRAVEL .00 .00 1,000.00 1,000.00 .0 TOTAL PURCHASED SERVICES .00 718.93 5,800.00 5,081.07 12.4 PROFESSIONAL SERVICES: 10-5103-2155 REPAIRS/MAINTENANCE .00 .00 800.00 800.00 .0 10-5103-2156 MAINTENANCE AGREEMENT .00 15,664.63 27,000.00 11,335.37 58.0 10-5103-2158 MISC CONTRACTUAL SERVICES 9,351.07 25,032.69 23,000.00 ( 2,032.69) 108.8 TOTAL PROFESSIONAL SERVICES 9,351.07 40,697.32 50,800.00 10,102.68 80.1 SUPPLIES: 10-5103-3210 OPERATING SUPPLIES .00 56.82 1,000.00 943.18 5.7 10-5103-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,820.00 37,353.12 38,700.00 1,346.88 96.5 TOTAL SUPPLIES 1,820.00 37,409.94 39,700.00 2,290.06 94.2 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:10 CAPITALIZED EXPENDITURES: 10-5103-6547 EQUIPMENT/FURNITURE .00 26,747.50 28,000.00 1,252.50 95.5 TOTAL CAPITALIZED EXPENDITURES .00 26,747.50 28,000.00 1,252.50 95.5 TOTAL GENERAL GOVT - IT 21,320.75 236,076.24 255,943.00 19,866.76 92.2 GENERAL GOVT - MUNICIPAL COURT PERSONNEL SERVICES: 10-5105-1001 SALARIES/WAGES - REGULAR 1,000.00 12,000.00 12,000.00 .00 100.0 TOTAL PERSONNEL SERVICES 1,000.00 12,000.00 12,000.00 .00 100.0 EMPLOYEE BENEFITS: 10-5105-1021 EMPLOYEE BENEFITS - SCL 76.50 918.00 918.00 .00 100.0 10-5105-1025 EMPLOYEE BENEFITS - COMP 45.60 547.20 547.00 ( .20) 100.0 TOTAL EMPLOYEE BENEFITS 122.10 1,465.20 1,465.00 ( .20) 100.0 PURCHASED SERVICES: 10-5105-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 100.00 100.00 .0 10-5105-2123 MEALS/LODGING/TRAVEL .00 .00 500.00 500.00 .0 TOTAL PURCHASED SERVICES .00 .00 600.00 600.00 .0 PROFESSIONAL SERVICES: 10-5105-2151 LEGAL 1,151.26 9,450.04 9,600.00 149.96 98.4 10-5105-2162 COURT SURCHARGES 440.00 2,500.00 4,000.00 1,500.00 62.5 10-5105-2166 COLLECTION FEES .00 .00 500.00 500.00 .0 10-5105-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 .00 500.00 500.00 .0 TOTAL PROFESSIONAL SERVICES 1,591.26 11,950.04 14,600.00 2,649.96 81.9 SUPPLIES: 10-5105-3210 OPERATING SUPPLIES .00 24.00 450.00 426.00 5.3 10-5105-3233 UNIFORMS/CARE .00 .00 50.00 50.00 .0 TOTAL SUPPLIES .00 24.00 500.00 476.00 4.8 TOTAL GENERAL GOVT - MUNICIPAL COURT 2,713.36 25,439.24 29,165.00 3,725.76 87.2 GENERAL GOVT - ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:11 PERSONNEL SERVICES: 10-5106-1001 SALARIES/WAGES - REGULAR 20,925.20 255,094.07 261,180.00 6,085.93 97.7 10-5106-1005 SALARIES/WAGES - LONGEVITY .00 372.98 373.00 .02 100.0 10-5106-1006 SALARIES/WAGES - ALLOWANCES 450.00 5,400.00 5,400.00 .00 100.0 TOTAL PERSONNEL SERVICES 21,375.20 260,867.05 266,953.00 6,085.95 97.7 EMPLOYEE BENEFITS: 10-5106-1021 EMPLOYEE BENEFITS - SCL 1,663.48 20,329.47 20,422.00 92.53 99.6 10-5106-1023 EMPLOYEE BENEFITS - HEALTH INS 3,718.30 44,613.92 50,000.00 5,386.08 89.2 10-5106-1025 EMPLOYEE BENEFITS - COMP 974.72 11,895.61 12,173.00 277.39 97.7 10-5106-1026 EMPLOYEE BENEFITS - COMP 413.45 5,402.17 5,500.00 97.83 98.2 10-5106-1028 EMPLOYEE BENEFITS - HLTH 214.31 2,556.83 3,014.00 457.17 84.8 10-5106-1029 EMPLOYEE BENEFITS - WY 3,012.54 36,872.14 43,408.00 6,535.86 84.9 TOTAL EMPLOYEE BENEFITS 9,996.80 121,670.14 134,517.00 12,846.86 90.5 PURCHASED SERVICES: 10-5106-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS ( 50.00) 1,629.25 1,920.00 290.75 84.9 10-5106-2122 TRAINING/DEVELOPMENT ( 250.00) 4,464.76 7,795.00 3,330.24 57.3 10-5106-2123 MEALS/LODGING/TRAVEL .00 3,772.74 10,525.00 6,752.26 35.9 TOTAL PURCHASED SERVICES ( 300.00) 9,866.75 20,240.00 10,373.25 48.8 PROPERTY SERVICES: 10-5106-2134 TELECOMMUNICATIONS 83.16 996.18 1,000.00 3.82 99.6 TOTAL PROPERTY SERVICES 83.16 996.18 1,000.00 3.82 99.6 PROFESSIONAL SERVICES: 10-5106-2153 ARCHITECT/ENGINEERING/SURVEY .00 3,784.50 10,000.00 6,215.50 37.9 10-5106-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 10-5106-2156 MAINTENANCE AGREEMENT 108.53 2,947.18 3,200.00 252.82 92.1 10-5106-2158 MISC CONTRACTUAL SERVICES 3,124.50 43,629.55 48,000.00 4,370.45 90.9 10-5106-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 300.00 750.00 450.00 40.0 TOTAL PROFESSIONAL SERVICES 3,233.03 50,661.23 62,950.00 12,288.77 80.5 SUPPLIES: 10-5106-3210 OPERATING SUPPLIES 545.70 3,823.32 5,500.00 1,676.68 69.5 10-5106-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 738.78 2,300.00 1,561.22 32.1 10-5106-3235 FUEL 177.01 1,009.66 2,000.00 990.34 50.5 TOTAL SUPPLIES 722.71 5,571.76 9,800.00 4,228.24 56.9 TOTAL GENERAL GOVT - 35,110.90 449,633.11 495,460.00 45,826.89 90.8 COMMUNITY SERVICE CONTRACTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:12 GOVERNMENTAL ASSISTANCE: 10-5110-8701 COMM CITIZEN 11,666.63 140,000.00 140,000.00 .00 100.0 10-5110-8702 COMM CLUB/GEN 5,416.67 65,000.00 65,000.00 .00 100.0 10-5110-8703 COMM RCREATN 20,000.00 20,000.00 20,000.00 .00 100.0 10-5110-8704 COMM 2,916.16 34,993.92 35,000.00 6.08 100.0 10-5110-8705 COMM FOR LIF 1,250.00 15,000.00 15,000.00 .00 100.0 10-5110-8706 COMM 875.00 10,500.00 10,500.00 .00 100.0 10-5110-8707 COMM DVL 791.69 7,000.00 7,000.00 .00 100.0 10-5110-8709 COMM 1,416.63 16,999.89 17,000.00 .11 100.0 10-5110-8711 COMM WAVE SWIM .00 2,249.28 3,296.00 1,046.72 68.2 10-5110-8714 COMM ENTERPRIS 2,916.67 35,000.04 35,000.00 ( .04) 100.0 10-5110-8717 COMM FAIR .00 3,500.00 3,500.00 .00 100.0 10-5110-8723 COMM HOCKEY .00 22,000.00 22,000.00 .00 100.0 10-5110-8725 COMM COUNCIL .00 416.00 5,000.00 4,584.00 8.3 10-5110-8734 COMM PEAK 13,333.33 104,999.96 105,000.00 .04 100.0 10-5110-8740 COMM SPRT .00 .00 5,000.00 5,000.00 .0 10-5110-8742 COMM IND LIVING 2,500.00 2,500.00 2,600.00 100.00 96.2 10-5110-8744 COMM 55,266.66 326,384.97 331,600.00 5,215.03 98.4 10-5110-8746 COMM & GIRLS 4,166.66 29,999.96 30,000.00 .04 100.0 10-5110-8748 COMM ST-DOUGL 1,041.63 12,500.00 12,500.00 .00 100.0 10-5110-8750 COMM ADVOC 500.00 2,000.00 2,000.00 .00 100.0 10-5110-8753 COMM SRVC BLK 1,250.00 5,000.00 5,000.00 .00 100.0 10-5110-8754 COMM 5,000.00 5,000.00 5,000.00 .00 100.0 10-5110-8757 COMM SERV-KINGS PORTION 2,916.63 35,000.00 35,000.00 .00 100.0 TOTAL GOVERNMENTAL ASSISTANCE 133,224.36 896,044.02 911,996.00 15,951.98 98.3 TOTAL COMMUNITY SERVICE CONTRACTS 133,224.36 896,044.02 911,996.00 15,951.98 98.3 POLICE DEPT - ADMINISTRATION PERSONNEL SERVICES: 10-5201-1001 SALARIES/WAGES - REGULAR 11,462.43 148,803.28 149,019.00 215.72 99.9 10-5201-1002 SALARIES/WAGES - OVERTIME .00 .00 100.00 100.00 .0 10-5201-1005 SALARIES/WAGES - LONGEVITY .00 1,420.46 1,421.00 .54 100.0 10-5201-1006 SALARIES/WAGES - ALLOWANCES 75.00 900.00 900.00 .00 100.0 10-5201-1007 SALARIES/WAGES - INCENTIVE .00 1,040.00 1,073.00 33.00 96.9 TOTAL PERSONNEL SERVICES 11,537.43 152,163.74 152,513.00 349.26 99.8 EMPLOYEE BENEFITS: 10-5201-1021 EMPLOYEE BENEFITS - SCL 925.69 12,197.64 12,241.00 43.36 99.7 10-5201-1023 EMPLOYEE BENEFITS - HEALTH INS 3,399.95 40,799.40 40,690.00 ( 109.40) 100.3 10-5201-1025 EMPLOYEE BENEFITS - COMP 526.10 6,938.60 6,906.00 ( 32.60) 100.5 10-5201-1026 EMPLOYEE BENEFITS - COMP 562.64 7,277.43 7,505.00 227.57 97.0 10-5201-1028 EMPLOYEE BENEFITS - HLTH 143.28 1,719.36 1,719.00 ( .36) 100.0 10-5201-1029 EMPLOYEE BENEFITS - WY 1,947.60 25,268.17 25,337.00 68.83 99.7 TOTAL EMPLOYEE BENEFITS 7,505.26 94,200.60 94,398.00 197.40 99.8 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:13 PURCHASED SERVICES: 10-5201-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 550.00 600.00 50.00 91.7 10-5201-2122 TRAINING/DEVELOPMENT .00 264.00 500.00 236.00 52.8 10-5201-2123 MEALS/LODGING/TRAVEL 1.12 315.53 600.00 284.47 52.6 TOTAL PURCHASED SERVICES 1.12 1,129.53 1,700.00 570.47 66.4 PROPERTY SERVICES: 10-5201-2134 TELECOMMUNICATIONS 40.01 183.50 168.00 ( 15.50) 109.2 TOTAL PROPERTY SERVICES 40.01 183.50 168.00 ( 15.50) 109.2 PROFESSIONAL SERVICES: 10-5201-2155 REPAIRS/MAINTENANCE .00 98.80 500.00 401.20 19.8 10-5201-2158 MISC CONTRACTUAL SERVICES 35.00 1,930.00 3,000.00 1,070.00 64.3 10-5201-2161 INCARCERATION CONTRACT 592.50 1,507.50 2,500.00 992.50 60.3 TOTAL PROFESSIONAL SERVICES 627.50 3,536.30 6,000.00 2,463.70 58.9 SUPPLIES: 10-5201-3210 OPERATING SUPPLIES 547.77 3,255.91 3,200.00 ( 55.91) 101.8 10-5201-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 234.45 350.00 115.55 67.0 10-5201-3233 UNIFORMS/CARE 18.00 374.74 600.00 225.26 62.5 10-5201-3235 FUEL 109.86 420.43 600.00 179.57 70.1 TOTAL SUPPLIES 675.63 4,285.53 4,750.00 464.47 90.2 TOTAL POLICE DEPT - ADMINISTRATION 20,386.95 255,499.20 259,529.00 4,029.80 98.5 POLICE DEPT - PATROL PERSONNEL SERVICES: 10-5202-1001 SALARIES/WAGES - REGULAR 68,937.10 852,693.24 877,756.00 25,062.76 97.1 10-5202-1002 SALARIES/WAGES - OVERTIME 3,300.62 38,302.86 50,000.00 11,697.14 76.6 10-5202-1005 SALARIES/WAGES - LONGEVITY .00 1,567.48 1,567.00 ( .48) 100.0 10-5202-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,842.00 1,842.00 .0 TOTAL PERSONNEL SERVICES 72,237.72 892,563.58 931,165.00 38,601.42 95.9 EMPLOYEE BENEFITS: 10-5202-1021 EMPLOYEE BENEFITS - SCL 5,575.20 68,916.32 70,327.00 1,410.68 98.0 10-5202-1023 EMPLOYEE BENEFITS - HEALTH INS 19,935.69 232,562.16 261,470.00 28,907.84 88.9 10-5202-1025 EMPLOYEE BENEFITS - COMP 3,294.04 40,700.85 41,086.00 385.15 99.1 10-5202-1026 EMPLOYEE BENEFITS - COMP 665.44 8,616.76 8,860.00 243.24 97.3 10-5202-1028 EMPLOYEE BENEFITS - HLTH 790.74 9,364.47 9,482.00 117.53 98.8 10-5202-1029 EMPLOYEE BENEFITS - WY 11,529.04 146,190.18 150,000.00 3,809.82 97.5 TOTAL EMPLOYEE BENEFITS 41,790.15 506,350.74 541,225.00 34,874.26 93.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:14 PURCHASED SERVICES: 10-5202-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 380.00 430.00 50.00 88.4 10-5202-2122 TRAINING/DEVELOPMENT .00 6,063.00 7,000.00 937.00 86.6 10-5202-2123 MEALS/LODGING/TRAVEL 100.93 4,484.91 6,000.00 1,515.09 74.8 TOTAL PURCHASED SERVICES 100.93 10,927.91 13,430.00 2,502.09 81.4 PROPERTY SERVICES: 10-5202-2134 TELECOMMUNICATIONS 1,303.24 10,702.98 11,040.00 337.02 97.0 TOTAL PROPERTY SERVICES 1,303.24 10,702.98 11,040.00 337.02 97.0 PROFESSIONAL SERVICES: 10-5202-2155 REPAIRS/MAINTENANCE 477.42 1,705.31 3,500.00 1,794.69 48.7 10-5202-2158 MISC CONTRACTUAL SERVICES 2,090.00 7,803.45 10,200.00 2,396.55 76.5 TOTAL PROFESSIONAL SERVICES 2,567.42 9,508.76 13,700.00 4,191.24 69.4 SUPPLIES: 10-5202-3201 OFFICE SUPPLIES .00 161.43 300.00 138.57 53.8 10-5202-3210 OPERATING SUPPLIES 3,898.64 34,535.15 31,163.00 ( 3,372.15) 110.8 10-5202-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 280.27 22,196.91 24,500.00 2,303.09 90.6 10-5202-3233 UNIFORMS/CARE 428.00 14,800.37 20,400.00 5,599.63 72.6 10-5202-3235 FUEL 3,544.22 26,400.93 30,000.00 3,599.07 88.0 TOTAL SUPPLIES 8,151.13 98,094.79 106,363.00 8,268.21 92.2 TOTAL POLICE DEPT - PATROL 126,150.59 1,528,148.76 1,616,923.00 88,774.24 94.5 POLICE DEPT - COMMUNICATIONS PERSONNEL SERVICES: 10-5203-1001 SALARIES/WAGES - REGULAR 25,469.71 320,883.42 323,059.00 2,175.58 99.3 10-5203-1002 SALARIES/WAGES - OVERTIME 2,195.58 22,185.42 27,000.00 4,814.58 82.2 10-5203-1005 SALARIES/WAGES - LONGEVITY .00 858.43 859.00 .57 99.9 10-5203-1007 SALARIES/WAGES - INCENTIVE .00 .00 1,040.00 1,040.00 .0 TOTAL PERSONNEL SERVICES 27,665.29 343,927.27 351,958.00 8,030.73 97.7 EMPLOYEE BENEFITS: 10-5203-1021 EMPLOYEE BENEFITS - SCL 2,134.36 26,533.24 27,531.00 997.76 96.4 10-5203-1023 EMPLOYEE BENEFITS - HEALTH INS 8,665.98 103,344.09 115,812.00 12,467.91 89.2 10-5203-1025 EMPLOYEE BENEFITS - COMP 1,261.53 15,955.95 16,720.00 764.05 95.4 10-5203-1026 EMPLOYEE BENEFITS - COMP 235.13 2,914.80 2,923.00 8.20 99.7 10-5203-1028 EMPLOYEE BENEFITS - HLTH 310.03 3,627.58 3,728.00 100.42 97.3 10-5203-1029 EMPLOYEE BENEFITS - WY 4,543.44 55,960.84 57,650.00 1,689.16 97.1 TOTAL EMPLOYEE BENEFITS 17,150.47 208,336.50 224,364.00 16,027.50 92.9 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:06AM PAGE:15 PURCHASED SERVICES: 10-5203-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 728.00 812.00 84.00 89.7 10-5203-2122 TRAINING/DEVELOPMENT .00 1,729.00 2,500.00 771.00 69.2 10-5203-2123 MEALS/LODGING/TRAVEL .00 .00 500.00 500.00 .0 TOTAL PURCHASED SERVICES .00 2,457.00 3,812.00 1,355.00 64.5 PROPERTY SERVICES: 10-5203-2131 UTILITY SERVICES - ELECTRICITY 340.94 2,041.00 2,500.00 459.00 81.6 10-5203-2134 TELECOMMUNICATIONS 737.52 7,285.25 7,100.00 ( 185.25) 102.6 TOTAL PROPERTY SERVICES 1,078.46 9,326.25 9,600.00 273.75 97.2 PROFESSIONAL SERVICES: 10-5203-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 10-5203-2156 MAINTENANCE AGREEMENT 98.96 606.62 1,000.00 393.38 60.7 10-5203-2158 MISC CONTRACTUAL SERVICES 75.00 75.00 500.00 425.00 15.0 TOTAL PROFESSIONAL SERVICES 173.96 681.62 3,000.00 2,318.38 22.7 SUPPLIES: 10-5203-3210 OPERATING SUPPLIES 50.00 421.72 1,000.00 578.28 42.2 10-5203-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 938.00 1,000.00 62.00 93.8 10-5203-3233 UNIFORMS/CARE 69.00 2,269.45 3,500.00 1,230.55 64.8 TOTAL SUPPLIES 119.00 3,629.17 5,500.00 1,870.83 66.0 TOTAL POLICE DEPT - COMMUNICATIONS 46,187.18 568,357.81 598,234.00 29,876.19 95.0 PUBLIC WORKS - ADMINISTRATION PERSONNEL SERVICES: 10-5301-1001 SALARIES/WAGES - REGULAR 9,777.18 138,347.17 137,989.00 ( 358.17) 100.3 10-5301-1005 SALARIES/WAGES - LONGEVITY .00 1,018.49 426.00 ( 592.49) 239.1 10-5301-1006 SALARIES/WAGES - ALLOWANCES 450.00 5,400.00 5,400.00 .00 100.0 TOTAL PERSONNEL SERVICES 10,227.18 144,765.66 143,815.00 ( 950.66) 100.7 EMPLOYEE BENEFITS: 10-5301-1021 EMPLOYEE BENEFITS - SCL 780.55 11,057.18 11,002.00 ( 55.18) 100.5 10-5301-1023 EMPLOYEE BENEFITS - HEALTH INS 2,393.28 30,424.33 28,665.00 ( 1,759.33) 106.1 10-5301-1025 EMPLOYEE BENEFITS - COMP 466.36 6,601.36 6,558.00 ( 43.36) 100.7 10-5301-1028 EMPLOYEE BENEFITS - HLTH 122.21 1,459.42 1,592.00 132.58 91.7 10-5301-1029 EMPLOYEE BENEFITS - WY 1,624.96 21,419.83 22,934.00 1,514.17 93.4 TOTAL EMPLOYEE BENEFITS 5,387.36 70,962.12 70,751.00 ( 211.12) 100.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:07AM PAGE:16 PURCHASED SERVICES: 10-5301-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 50.00 350.00 300.00 14.3 10-5301-2122 TRAINING/DEVELOPMENT .00 1,073.00 2,130.00 1,057.00 50.4 10-5301-2123 MEALS/LODGING/TRAVEL .00 233.00 295.00 62.00 79.0 TOTAL PURCHASED SERVICES .00 1,356.00 2,775.00 1,419.00 48.9 PROPERTY SERVICES: 10-5301-2131 UTILITY SERVICES - ELECTRICITY 923.82 10,788.64 10,750.00 ( 38.64) 100.4 10-5301-2132 UTILITY SERVICES - WTR/SWR/GRB 765.43 3,766.77 3,266.00 ( 500.77) 115.3 10-5301-2133 UTILITY SERVICES - NATURAL GAS 545.12 8,458.12 10,000.00 1,541.88 84.6 10-5301-2134 TELECOMMUNICATIONS 80.40 503.90 500.00 ( 3.90) 100.8 TOTAL PROPERTY SERVICES 2,314.77 23,517.43 24,516.00 998.57 95.9 PROFESSIONAL SERVICES: 10-5301-2155 REPAIRS/MAINTENANCE .00 .00 1,880.00 1,880.00 .0 10-5301-2156 MAINTENANCE AGREEMENT 105.71 530.15 550.00 19.85 96.4 TOTAL PROFESSIONAL SERVICES 105.71 530.15 2,430.00 1,899.85 21.8 SUPPLIES: 10-5301-3210 OPERATING SUPPLIES 79.51 2,170.37 2,500.00 329.63 86.8 10-5301-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 407.84 475.00 67.16 85.9 10-5301-3230 REFRESHMENT SUPPLIES 16.81 546.25 625.00 78.75 87.4 TOTAL SUPPLIES 96.32 3,124.46 3,600.00 475.54 86.8 TOTAL PUBLIC WORKS - ADMINISTRATION 18,131.34 244,255.82 247,887.00 3,631.18 98.5 PUBLIC WORKS - SHOP PERSONNEL SERVICES: 10-5302-1001 SALARIES/WAGES - REGULAR 16,804.79 216,609.40 216,810.00 200.60 99.9 10-5302-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 10-5302-1005 SALARIES/WAGES - LONGEVITY .00 1,857.64 1,858.00 .36 100.0 10-5302-1007 SALARIES/WAGES - INCENTIVE .00 2,787.20 2,916.00 128.80 95.6 TOTAL PERSONNEL SERVICES 16,804.79 221,254.24 222,084.00 829.76 99.6 EMPLOYEE BENEFITS: 10-5302-1021 EMPLOYEE BENEFITS - SCL 1,334.66 17,567.52 17,676.00 108.48 99.4 10-5302-1023 EMPLOYEE BENEFITS - HEALTH INS 5,761.92 69,126.98 68,811.00 ( 315.98) 100.5 10-5302-1025 EMPLOYEE BENEFITS - COMP 766.32 10,089.44 10,111.00 21.56 99.8 10-5302-1026 EMPLOYEE BENEFITS - COMP 630.84 8,193.23 8,200.00 6.77 99.9 10-5302-1028 EMPLOYEE BENEFITS - HLTH 210.06 2,501.86 2,502.00 .14 100.0 10-5302-1029 EMPLOYEE BENEFITS - WY 2,792.94 35,939.68 36,117.00 177.32 99.5 TOTAL EMPLOYEE BENEFITS 11,496.74 143,418.71 143,417.00 ( 1.71) 100.0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:07AM PAGE:17 PURCHASED SERVICES: 10-5302-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 1,500.00 1,500.00 .00 100.0 10-5302-2122 TRAINING/DEVELOPMENT .00 .00 200.00 200.00 .0 TOTAL PURCHASED SERVICES .00 1,500.00 1,700.00 200.00 88.2 PROFESSIONAL SERVICES: 10-5302-2155 REPAIRS/MAINTENANCE .00 435.00 600.00 165.00 72.5 10-5302-2158 MISC CONTRACTUAL SERVICES 42.00 65.00 100.00 35.00 65.0 TOTAL PROFESSIONAL SERVICES 42.00 500.00 700.00 200.00 71.4 SUPPLIES: 10-5302-3210 OPERATING SUPPLIES 987.83 13,607.66 13,900.00 292.34 97.9 10-5302-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 1,271.58 5,888.90 6,150.00 261.10 95.8 10-5302-3235 FUEL 434.79 1,798.36 2,200.00 401.64 81.7 10-5302-3237 OIL/LUBE/FLUIDS 1,307.99 11,106.49 12,500.00 1,393.51 88.9 TOTAL SUPPLIES 4,002.19 32,401.41 34,750.00 2,348.59 93.2 TOTAL PUBLIC WORKS - SHOP 32,345.72 399,074.36 402,651.00 3,576.64 99.1 PUBLIC WORKS - PARKS PERSONNEL SERVICES: 10-5304-1001 SALARIES/WAGES - REGULAR 17,064.85 216,083.17 218,919.00 2,835.83 98.7 10-5304-1002 SALARIES/WAGES - OVERTIME .00 690.84 400.00 ( 290.84) 172.7 10-5304-1004 SALARIES/WAGES - TEMPORARY 11,610.40 37,537.65 47,712.00 10,174.35 78.7 10-5304-1005 SALARIES/WAGES - LONGEVITY .00 352.49 352.00 ( .49) 100.1 10-5304-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 28,700.25 254,964.15 267,683.00 12,718.85 95.3 EMPLOYEE BENEFITS: 10-5304-1021 EMPLOYEE BENEFITS - SCL 2,197.81 19,534.67 20,508.00 973.33 95.3 10-5304-1023 EMPLOYEE BENEFITS - HEALTH INS 7,248.95 85,279.90 86,000.00 720.10 99.2 10-5304-1025 EMPLOYEE BENEFITS - COMP 1,308.75 11,626.43 12,224.00 597.57 95.1 10-5304-1028 EMPLOYEE BENEFITS - HLTH 213.30 2,518.40 2,526.00 7.60 99.7 10-5304-1029 EMPLOYEE BENEFITS - WY 2,836.14 35,868.38 36,451.00 582.62 98.4 TOTAL EMPLOYEE BENEFITS 13,804.95 154,827.78 157,709.00 2,881.22 98.2 PURCHASED SERVICES: 10-5304-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 300.00 500.00 200.00 60.0 10-5304-2122 TRAINING/DEVELOPMENT .00 1,010.00 1,200.00 190.00 84.2 10-5304-2123 MEALS/LODGING/TRAVEL .00 .00 1,170.00 1,170.00 .0 TOTAL PURCHASED SERVICES .00 1,310.00 2,870.00 1,560.00 45.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:07AM PAGE:18 PROPERTY SERVICES: 10-5304-2131 UTILITY SERVICES - ELECTRICITY 1,040.62 14,758.40 17,000.00 2,241.60 86.8 10-5304-2132 UTILITY SERVICES - WTR/SWR/GRB 19,246.88 83,985.83 75,000.00 ( 8,985.83) 112.0 10-5304-2141 EQUIPMENT - RENT .00 .00 1,000.00 1,000.00 .0 TOTAL PROPERTY SERVICES 20,287.50 98,744.23 93,000.00 ( 5,744.23) 106.2 PROFESSIONAL SERVICES: 10-5304-2155 REPAIRS/MAINTENANCE 368.50 3,073.64 5,000.00 1,926.36 61.5 10-5304-2156 MAINTENANCE AGREEMENT .00 498.01 500.00 1.99 99.6 10-5304-2158 MISC CONTRACTUAL SERVICES .00 30,650.00 35,000.00 4,350.00 87.6 TOTAL PROFESSIONAL SERVICES 368.50 34,221.65 40,500.00 6,278.35 84.5 SUPPLIES: 10-5304-3210 OPERATING SUPPLIES 5,379.38 31,659.38 33,000.00 1,340.62 95.9 10-5304-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 4,507.86 5,000.00 492.14 90.2 10-5304-3235 FUEL 1,758.40 8,511.04 12,500.00 3,988.96 68.1 TOTAL SUPPLIES 7,137.78 44,678.28 50,500.00 5,821.72 88.5 TOTAL PUBLIC WORKS - PARKS 70,298.98 588,746.09 612,262.00 23,515.91 96.2 PUBLIC WORKS - STREETS/ALLEYS PERSONNEL SERVICES: 10-5305-1001 SALARIES/WAGES - REGULAR 20,513.72 252,138.63 262,589.00 10,450.37 96.0 10-5305-1002 SALARIES/WAGES - OVERTIME .00 1,068.28 4,000.00 2,931.72 26.7 10-5305-1004 SALARIES/WAGES - TEMPORARY 3,190.40 8,281.10 11,928.00 3,646.90 69.4 10-5305-1005 SALARIES/WAGES - LONGEVITY .00 634.72 635.00 .28 100.0 10-5305-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 23,729.12 262,422.73 279,452.00 17,029.27 93.9 EMPLOYEE BENEFITS: 10-5305-1021 EMPLOYEE BENEFITS - SCL 1,821.72 20,158.47 21,461.00 1,302.53 93.9 10-5305-1023 EMPLOYEE BENEFITS - HEALTH INS 9,972.23 112,889.51 119,184.00 6,294.49 94.7 10-5305-1025 EMPLOYEE BENEFITS - COMP 1,082.07 11,966.73 12,761.00 794.27 93.8 10-5305-1026 EMPLOYEE BENEFITS - COMP 54.26 694.62 695.00 .38 100.0 10-5305-1028 EMPLOYEE BENEFITS - HLTH 256.43 2,920.40 3,030.00 109.60 96.4 10-5305-1029 EMPLOYEE BENEFITS - WY 3,409.36 42,045.69 44,307.00 2,261.31 94.9 TOTAL EMPLOYEE BENEFITS 16,596.07 190,675.42 201,438.00 10,762.58 94.7 PURCHASED SERVICES: 10-5305-2122 TRAINING/DEVELOPMENT .00 .00 575.00 575.00 .0 TOTAL PURCHASED SERVICES .00 .00 575.00 575.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:07AM PAGE:19 PROFESSIONAL SERVICES: 10-5305-2155 REPAIRS/MAINTENANCE .00 4,511.36 3,000.00 ( 1,511.36) 150.4 10-5305-2158 MISC CONTRACTUAL SERVICES .00 40,414.80 50,000.00 9,585.20 80.8 TOTAL PROFESSIONAL SERVICES .00 44,926.16 53,000.00 8,073.84 84.8 SUPPLIES: 10-5305-3210 OPERATING SUPPLIES 5,684.10 96,509.07 80,000.00 ( 16,509.07) 120.6 10-5305-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 491.28 800.00 308.72 61.4 10-5305-3235 FUEL 3,695.41 25,178.43 28,500.00 3,321.57 88.4 TOTAL SUPPLIES 9,379.51 122,178.78 109,300.00 ( 12,878.78) 111.8 TOTAL PUBLIC WORKS - STREETS/ALLEYS 49,704.70 620,203.09 643,765.00 23,561.91 96.3 PUBLIC WORKS - CEMETERY PERSONNEL SERVICES: 10-5306-1001 SALARIES/WAGES - REGULAR 10,169.31 131,146.00 131,289.00 143.00 99.9 10-5306-1002 SALARIES/WAGES - OVERTIME 351.03 834.79 1,500.00 665.21 55.7 10-5306-1004 SALARIES/WAGES - TEMPORARY 1,107.60 4,352.40 11,928.00 7,575.60 36.5 10-5306-1005 SALARIES/WAGES - LONGEVITY .00 1,039.63 1,040.00 .37 100.0 10-5306-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 10-5306-1007 SALARIES/WAGES - INCENTIVE .00 1,705.60 2,047.00 341.40 83.3 TOTAL PERSONNEL SERVICES 11,652.94 139,378.42 148,104.00 8,725.58 94.1 EMPLOYEE BENEFITS: 10-5306-1021 EMPLOYEE BENEFITS - SCL 897.88 10,748.04 11,442.00 693.96 93.9 10-5306-1023 EMPLOYEE BENEFITS - HEALTH INS 4,242.89 50,910.51 50,715.00 ( 195.51) 100.4 10-5306-1025 EMPLOYEE BENEFITS - COMP 531.38 6,355.68 6,678.00 322.32 95.2 10-5306-1026 EMPLOYEE BENEFITS - COMP 82.56 1,072.27 1,073.00 .73 99.9 10-5306-1028 EMPLOYEE BENEFITS - HLTH 127.11 1,514.65 1,515.00 .35 100.0 10-5306-1029 EMPLOYEE BENEFITS - WY 1,748.49 21,898.16 22,070.00 171.84 99.2 TOTAL EMPLOYEE BENEFITS 7,630.31 92,499.31 93,493.00 993.69 98.9 PURCHASED SERVICES: 10-5306-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 100.00 100.00 .00 100.0 10-5306-2122 TRAINING/DEVELOPMENT .00 280.00 280.00 .00 100.0 TOTAL PURCHASED SERVICES .00 380.00 380.00 .00 100.0 PROPERTY SERVICES: 10-5306-2131 UTILITY SERVICES - ELECTRICITY 237.99 2,596.80 3,000.00 403.20 86.6 10-5306-2132 UTILITY SERVICES - WTR/SWR/GRB 12,504.12 45,148.49 45,000.00 ( 148.49) 100.3 10-5306-2133 UTILITY SERVICES - NATURAL GAS 51.92 958.29 1,500.00 541.71 63.9 10-5306-2134 TELECOMMUNICATIONS 50.00 525.77 500.00 ( 25.77) 105.2 TOTAL PROPERTY SERVICES 12,844.03 49,229.35 50,000.00 770.65 98.5 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:07AM PAGE:20 PROFESSIONAL SERVICES: 10-5306-2155 REPAIRS/MAINTENANCE .00 3,976.56 3,977.00 .44 100.0 10-5306-2156 MAINTENANCE AGREEMENT .00 500.00 500.00 .00 100.0 10-5306-2158 MISC CONTRACTUAL SERVICES .00 10,000.00 10,000.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 14,476.56 14,477.00 .44 100.0 SUPPLIES: 10-5306-3210 OPERATING SUPPLIES 2,787.82 9,194.72 10,448.00 1,253.28 88.0 10-5306-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 275.00 275.00 .00 100.0 10-5306-3235 FUEL 473.83 1,902.84 3,500.00 1,597.16 54.4 TOTAL SUPPLIES 3,261.65 11,372.56 14,223.00 2,850.44 80.0 CAPITALIZED EXPENDITURES: 10-5306-6540 LAND .00 1,500.00 1,000.00 ( 500.00) 150.0 TOTAL CAPITALIZED EXPENDITURES .00 1,500.00 1,000.00 ( 500.00) 150.0 TOTAL PUBLIC WORKS - CEMETERY 35,388.93 308,836.20 321,677.00 12,840.80 96.0 PUBLIC WORKS - SWIM POOL PROPERTY SERVICES: 10-5307-2131 UTILITY SERVICES - ELECTRICITY 1,107.66 6,054.00 9,000.00 2,946.00 67.3 10-5307-2132 UTILITY SERVICES - WTR/SWR/GRB 5,459.89 12,339.81 10,000.00 ( 2,339.81) 123.4 10-5307-2133 UTILITY SERVICES - NATURAL GAS 5,998.61 8,656.34 12,000.00 3,343.66 72.1 10-5307-2134 TELECOMMUNICATIONS 280.91 1,042.89 2,000.00 957.11 52.1 TOTAL PROPERTY SERVICES 12,847.07 28,093.04 33,000.00 4,906.96 85.1 PROFESSIONAL SERVICES: 10-5307-2155 REPAIRS/MAINTENANCE .00 79.50 1,500.00 1,420.50 5.3 10-5307-2158 MISC CONTRACTUAL SERVICES 30,505.95 73,053.95 86,000.00 12,946.05 85.0 TOTAL PROFESSIONAL SERVICES 30,505.95 73,133.45 87,500.00 14,366.55 83.6 SUPPLIES: 10-5307-3210 OPERATING SUPPLIES 2,430.91 9,139.23 8,000.00 ( 1,139.23) 114.2 10-5307-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 940.75 1,409.55 2,500.00 1,090.45 56.4 TOTAL SUPPLIES 3,371.66 10,548.78 10,500.00 ( 48.78) 100.5 TOTAL PUBLIC WORKS - SWIM POOL 46,724.68 111,775.27 131,000.00 19,224.73 85.3 OPERATING TRANSFERS - OUT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:07AM PAGE:21 OPERATING TRANSFERS: 10-5998-4308 TRANSFER TO GF EQUIP RESERVE 187,500.00 750,000.00 750,000.00 .00 100.0 10-5998-4313 TRANSFER TO POLICE SPECIAL PRJ 67,630.27 164,856.52 195,809.00 30,952.48 84.2 10-5998-4350 TRANSFER TO FIRE EQUIPMENT 15,000.00 60,000.00 60,000.00 .00 100.0 10-5998-4354 TRANSFER TO TRAIN CAR RESTORAT 5,000.00 20,000.00 20,000.00 .00 100.0 10-5998-4355 TRANSFER TO POOL IMPROVEMENT 12,500.00 50,000.00 50,000.00 .00 100.0 10-5998-4356 TRANSFER TO STREET IMPROVEMENT 750,000.00 3,000,000.00 3,000,000.00 .00 100.0 10-5998-4357 TRANSFER TO PUBLIC FACILITIES 1,325,000.00 5,300,000.00 5,300,000.00 .00 100.0 10-5998-4365 TRANSFER TO PARK IMPROVEMENTS 275,000.00 1,250,000.00 1,250,000.00 .00 100.0 10-5998-4382 TRANSFER TO HISTORIC PRESERVTN 50,000.00 50,000.00 50,000.00 .00 100.0 TOTAL OPERATING TRANSFERS 2,687,630.27 10,644,856.52 10,675,809.00 30,952.48 99.7 TOTAL OPERATING TRANSFERS - OUT 2,687,630.27 10,644,856.52 10,675,809.00 30,952.48 99.7 TOTAL FUND EXPENDITURES 3,422,538.67 18,124,153.38 18,890,318.00 766,164.62 95.9 NET REVENUE OVER EXPENDITURES ( 2,304,666.50) ( 7,219,800.98) ( 8,617,507.00) ( 1,397,706.02) ( 83.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 IMPACT ASSISTANCE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:07AM PAGE:22 ASSETS CURRENT ASSETS: CASH: 11-10000116 CASH ALLOC FR COMBINED FUND 770.03 TOTAL CASH 770.03 TOTAL CURRENT ASSETS 770.03 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 770.03 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 11-30000300 FUND BALANCE/BEGINNING OF YEAR 770.03 TOTAL CAPITAL ASSETS 770.03 TOTAL NET ASSETS 770.03 TOTAL LIABILITIES AND NET ASSETS 770.03 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:15AM PAGE:23 ASSETS CURRENT ASSETS: CASH: 13-10000116 CASH ALLOC FR COMBINED FUND 46,578.54 TOTAL CASH 46,578.54 ACCOUNTS RECEIVABLE: 13-10000131 ACCOUNTS RECEIVABLE - GENERAL 4,834.00 TOTAL ACCOUNTS RECEIVABLE 4,834.00 TOTAL CURRENT ASSETS 51,412.54 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 51,412.54 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 13-20000201 ALLOCATION FROM AP FUND 59,533.91 13-20000215 WAGES PAYABLE - CLEARING 4,114.40 TOTAL ACCOUNTS PAYABLE 63,648.31 TOTAL CURRENT LIABILITIES 63,648.31 TOTAL LIABILITIES 63,648.31 NET ASSETS CAPITAL ASSETS: 13-30000300 FUND BALANCE/BEGINNING OF YEAR 22,247.68 TOTAL CAPITAL ASSETS 22,247.68 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:15AM PAGE:24 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 34,483.45) BALANCE - CURRENT DATE ( 12,235.77) TOTAL NET ASSETS ( 12,235.77) TOTAL LIABILITIES AND NET ASSETS 51,412.54 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:15AM PAGE:25 HIGHWAY SAFETY TRAFFIC - REVEN FEDERAL REVENUE SOURCES: 13-4821-4289 DOT/WDOT 3,612.85 12,748.75 20,896.00 8,147.25 61.0 TOTAL FEDERAL REVENUE SOURCES 3,612.85 12,748.75 20,896.00 8,147.25 61.0 TOTAL HIGHWAY SAFETY TRAFFIC - REVEN 3,612.85 12,748.75 20,896.00 8,147.25 61.0 SRO PROGRAM - REVENUE MISC LOCAL REVENUE: 13-4830-1001 REIMBURSEMENT-CCSD#1-SRO .00 57,664.96 57,665.00 .04 100.0 TOTAL MISC LOCAL REVENUE .00 57,664.96 57,665.00 .04 100.0 TRANSFERS IN: 13-4830-5510 TRANSFER FROM GENERAL FUND 11,989.72 57,447.22 60,610.00 3,162.78 94.8 TOTAL TRANSFERS IN 11,989.72 57,447.22 60,610.00 3,162.78 94.8 TOTAL SRO PROGRAM - REVENUE 11,989.72 115,112.18 118,275.00 3,162.82 97.3 OJJDP-UNDERAGE ENFRC - REVENUE STATE REVENUE: 13-4831-3270 WY DEPARTMENT OF HEALTH 1,195.84 9,371.68 5,924.00 ( 3,447.68) 158.2 TOTAL STATE REVENUE 1,195.84 9,371.68 5,924.00 ( 3,447.68) 158.2 TRANSFERS IN: 13-4831-5510 TRANSFER FROM GENERAL FUND ( 1,989.00) .00 2,652.00 2,652.00 .0 TOTAL TRANSFERS IN ( 1,989.00) .00 2,652.00 2,652.00 .0 TOTAL OJJDP-UNDERAGE ENFRC - REVENUE ( 793.16) 9,371.68 8,576.00 ( 795.68) 109.3 SRO - GRANT - REVENUE MISC LOCAL REVENUE: 13-4834-1001 REIMBURSEMENT-CCSD #1-SRO GRNT .00 33,754.00 33,754.00 .00 100.0 TOTAL MISC LOCAL REVENUE .00 33,754.00 33,754.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:15AM PAGE:26 FEDERAL REVENUE SOURCES: 13-4834-4283 FED BUREAU JUSTICE ADMIN - SRO .00 33,750.00 42,500.00 8,750.00 79.4 TOTAL FEDERAL REVENUE SOURCES .00 33,750.00 42,500.00 8,750.00 79.4 TRANSFERS IN: 13-4834-5510 TRANSFER FROM GENERAL FUND 9,017.34 37,056.09 37,385.00 328.91 99.1 TOTAL TRANSFERS IN 9,017.34 37,056.09 37,385.00 328.91 99.1 TOTAL SRO - GRANT - REVENUE 9,017.34 104,560.09 113,639.00 9,078.91 92.0 JUVENILE DIVERSION OFFICER-REV TRANSFERS IN: 13-4835-5510 TRANSFER FROM GENERAL FUND ( 16,775.79) 3,309.21 20,780.00 17,470.79 15.9 TOTAL TRANSFERS IN ( 16,775.79) 3,309.21 20,780.00 17,470.79 15.9 TOTAL JUVENILE DIVERSION OFFICER-REV ( 16,775.79) 3,309.21 20,780.00 17,470.79 15.9 BULLET PROOF VEST - REVENUE FEDERAL REVENUE SOURCES: 13-4838-4281 FED BUREAU JUSTICE ADMIN - BJA .00 865.00 2,208.00 1,343.00 39.2 TOTAL FEDERAL REVENUE SOURCES .00 865.00 2,208.00 1,343.00 39.2 TRANSFERS IN: 13-4838-5510 TRANSFER FROM GENERAL FUND ( 786.00) 870.00 2,208.00 1,338.00 39.4 TOTAL TRANSFERS IN ( 786.00) 870.00 2,208.00 1,338.00 39.4 TOTAL BULLET PROOF VEST - REVENUE ( 786.00) 1,735.00 4,416.00 2,681.00 39.3 HOMELAND SECURITY 2014 FEDERAL REVENUE SOURCES: 13-4893-4891 US DOJ DOMESTIC PREPARDNESS .00 3,045.03 3,045.00 ( .03) 100.0 TOTAL FEDERAL REVENUE SOURCES .00 3,045.03 3,045.00 ( .03) 100.0 TOTAL HOMELAND SECURITY 2014 .00 3,045.03 3,045.00 ( .03) 100.0 E CITATION ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:16AM PAGE:27 STATE REVENUE: 13-4895-3272 WY SUPREME COURT .00 34,448.73 66,174.00 31,725.27 52.1 TOTAL STATE REVENUE .00 34,448.73 66,174.00 31,725.27 52.1 TRANSFERS IN: 13-4895-5510 TRANSFER FROM GENERAL FUND 66,174.00 66,174.00 66,174.00 .00 100.0 TOTAL TRANSFERS IN 66,174.00 66,174.00 66,174.00 .00 100.0 TOTAL E CITATION 66,174.00 100,622.73 132,348.00 31,725.27 76.0 TOTAL FUND REVENUE 72,438.96 350,504.67 421,975.00 71,470.33 83.1 HIGHWAY SAFETY TRAFFIC ENFORCE PERSONNEL SERVICES: 13-5821-1001 SALARIES/WAGES - REGULAR 1,306.31 10,081.19 14,652.00 4,570.81 68.8 TOTAL PERSONNEL SERVICES 1,306.31 10,081.19 14,652.00 4,570.81 68.8 EMPLOYEE BENEFITS: 13-5821-1021 EMPLOYEE BENEFITS - SCL 99.85 770.66 1,121.00 350.34 68.8 13-5821-1023 EMPLOYEE BENEFITS - HEALTH INS 744.14 2,203.11 2,020.00 ( 183.11) 109.1 13-5821-1025 EMPLOYEE BENEFITS - COMP 59.57 459.71 668.00 208.29 68.8 13-5821-1029 EMPLOYEE BENEFITS - WY 217.10 1,672.31 2,435.00 762.69 68.7 TOTAL EMPLOYEE BENEFITS 1,120.66 5,105.79 6,244.00 1,138.21 81.8 TOTAL HIGHWAY SAFETY TRAFFIC ENFORCE 2,426.97 15,186.98 20,896.00 5,709.02 72.7 SCHOOL RESOURCE OFFICER PERSONNEL SERVICES: 13-5830-1001 SALARIES/WAGES - REGULAR 5,581.10 72,486.80 72,652.00 165.20 99.8 13-5830-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 13-5830-1005 SALARIES/WAGES - LONGEVITY .00 228.66 229.00 .34 99.9 TOTAL PERSONNEL SERVICES 5,581.10 72,715.46 73,381.00 665.54 99.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:16AM PAGE:28 EMPLOYEE BENEFITS: 13-5830-1021 EMPLOYEE BENEFITS - SCL 426.94 5,562.56 5,614.00 51.44 99.1 13-5830-1023 EMPLOYEE BENEFITS - HEALTH INS 1,677.67 20,132.04 20,076.00 ( 56.04) 100.3 13-5830-1025 EMPLOYEE BENEFITS - COMP 254.50 3,315.85 3,346.00 30.15 99.1 13-5830-1028 EMPLOYEE BENEFITS - HLTH 69.76 837.12 838.00 .88 99.9 13-5830-1029 EMPLOYEE BENEFITS - WY 927.58 12,026.90 12,075.00 48.10 99.6 TOTAL EMPLOYEE BENEFITS 3,356.45 41,874.47 41,949.00 74.53 99.8 PURCHASED SERVICES: 13-5830-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 10.00 50.00 40.00 20.0 13-5830-2122 TRAINING/DEVELOPMENT .00 215.00 500.00 285.00 43.0 13-5830-2123 MEALS/LODGING/TRAVEL 64.66 64.66 1,000.00 935.34 6.5 TOTAL PURCHASED SERVICES 64.66 289.66 1,550.00 1,260.34 18.7 PROPERTY SERVICES: 13-5830-2134 TELECOMMUNICATIONS 40.01 176.61 495.00 318.39 35.7 TOTAL PROPERTY SERVICES 40.01 176.61 495.00 318.39 35.7 SUPPLIES: 13-5830-3233 UNIFORMS/CARE .00 55.98 900.00 844.02 6.2 TOTAL SUPPLIES .00 55.98 900.00 844.02 6.2 TOTAL SCHOOL RESOURCE OFFICER 9,042.22 115,112.18 118,275.00 3,162.82 97.3 OJJDP-UNDERAGE ENFORCEMENT PERSONNEL SERVICES: 13-5831-1001 SALARIES/WAGES - REGULAR 399.78 2,453.47 2,912.00 458.53 84.3 TOTAL PERSONNEL SERVICES 399.78 2,453.47 2,912.00 458.53 84.3 EMPLOYEE BENEFITS: 13-5831-1021 EMPLOYEE BENEFITS - SCL 30.51 187.52 223.00 35.48 84.1 13-5831-1023 EMPLOYEE BENEFITS - HEALTH INS .00 618.42 267.00 ( 351.42) 231.6 13-5831-1025 EMPLOYEE BENEFITS - COMP 18.23 111.93 133.00 21.07 84.2 13-5831-1029 EMPLOYEE BENEFITS - WY 66.41 407.98 484.00 76.02 84.3 TOTAL EMPLOYEE BENEFITS 115.15 1,325.85 1,107.00 ( 218.85) 119.8 PROFESSIONAL SERVICES: 13-5831-2158 MISC CONTRACTUAL SERVICES 80.00 680.00 1,180.00 500.00 57.6 TOTAL PROFESSIONAL SERVICES 80.00 680.00 1,180.00 500.00 57.6 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:16AM PAGE:29 SUPPLIES: 13-5831-3210 OPERATING SUPPLIES 70.00 809.88 786.00 ( 23.88) 103.0 TOTAL SUPPLIES 70.00 809.88 786.00 ( 23.88) 103.0 TOTAL OJJDP-UNDERAGE ENFORCEMENT 664.93 5,269.20 5,985.00 715.80 88.0 SRO - GRANT PERSONNEL SERVICES: 13-5834-1001 SALARIES/WAGES - REGULAR 5,534.94 69,830.03 70,204.00 373.97 99.5 13-5834-1002 SALARIES/WAGES - OVERTIME .00 .00 500.00 500.00 .0 13-5834-1005 SALARIES/WAGES - LONGEVITY .00 550.62 551.00 .38 99.9 TOTAL PERSONNEL SERVICES 5,534.94 70,380.65 71,255.00 874.35 98.8 EMPLOYEE BENEFITS: 13-5834-1021 EMPLOYEE BENEFITS - SCL 423.42 5,384.08 5,451.00 66.92 98.8 13-5834-1023 EMPLOYEE BENEFITS - HEALTH INS 1,677.67 20,132.04 20,076.00 ( 56.04) 100.3 13-5834-1025 EMPLOYEE BENEFITS - COMP 252.40 3,209.40 3,249.00 39.60 98.8 13-5834-1028 EMPLOYEE BENEFITS - HLTH 69.19 806.88 810.00 3.12 99.6 13-5834-1029 EMPLOYEE BENEFITS - WY 919.90 11,586.20 11,668.00 81.80 99.3 TOTAL EMPLOYEE BENEFITS 3,342.58 41,118.60 41,254.00 135.40 99.7 PURCHASED SERVICES: 13-5834-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 100.00 100.00 .0 13-5834-2122 TRAINING/DEVELOPMENT .00 215.00 500.00 285.00 43.0 13-5834-2123 MEALS/LODGING/TRAVEL 64.67 64.67 1,000.00 935.33 6.5 TOTAL PURCHASED SERVICES 64.67 279.67 1,600.00 1,320.33 17.5 PROPERTY SERVICES: 13-5834-2134 TELECOMMUNICATIONS 91.60 794.70 1,107.00 312.30 71.8 TOTAL PROPERTY SERVICES 91.60 794.70 1,107.00 312.30 71.8 SUPPLIES: 13-5834-3233 UNIFORMS/CARE .00 736.47 924.00 187.53 79.7 TOTAL SUPPLIES .00 736.47 924.00 187.53 79.7 TOTAL SRO - GRANT 9,033.79 113,310.09 116,140.00 2,829.91 97.6 JUVENILE DIVERSION OFFICER ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:16AM PAGE:30 PERSONNEL SERVICES: 13-5835-1001 SALARIES/WAGES - REGULAR 300.00 2,145.00 2,470.00 325.00 86.8 13-5835-1006 SALARIES/WAGES - ALLOWANCES .00 550.00 600.00 50.00 91.7 TOTAL PERSONNEL SERVICES 300.00 2,695.00 3,070.00 375.00 87.8 EMPLOYEE BENEFITS: 13-5835-1021 EMPLOYEE BENEFITS - SCL 22.95 206.19 189.00 ( 17.19) 109.1 13-5835-1025 EMPLOYEE BENEFITS - COMP 13.68 408.02 955.00 546.98 42.7 TOTAL EMPLOYEE BENEFITS 36.63 614.21 1,144.00 529.79 53.7 PROFESSIONAL SERVICES: 13-5835-2158 MISC CONTRACTUAL SERVICES .00 .00 1,000.00 1,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 1,000.00 1,000.00 .0 SUPPLIES: 13-5835-3210 OPERATING SUPPLIES .00 .00 1,000.00 1,000.00 .0 TOTAL SUPPLIES .00 .00 1,000.00 1,000.00 .0 TOTAL JUVENILE DIVERSION OFFICER 336.63 3,309.21 6,214.00 2,904.79 53.3 BULLET PROOF VEST PROTECTION SUPPLIES: 13-5838-3233 UNIFORMS/CARE .00 1,735.00 4,416.00 2,681.00 39.3 TOTAL SUPPLIES .00 1,735.00 4,416.00 2,681.00 39.3 TOTAL BULLET PROOF VEST PROTECTION .00 1,735.00 4,416.00 2,681.00 39.3 HOMELAND SECURITY 2014 CAPITALIZED EXPENDITURES: 13-5893-6547 EQUIPMENT .00 3,045.03 3,045.00 ( .03) 100.0 TOTAL CAPITALIZED EXPENDITURES .00 3,045.03 3,045.00 ( .03) 100.0 TOTAL HOMELAND SECURITY 2014 .00 3,045.03 3,045.00 ( .03) 100.0 E CITATION ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POLICE SPECIAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:16AM PAGE:31 PROFESSIONAL SERVICES: 13-5895-2158 MISC CONTRACTUAL 10,931.97 10,931.97 9,625.00 ( 1,306.97) 113.6 TOTAL PROFESSIONAL SERVICES 10,931.97 10,931.97 9,625.00 ( 1,306.97) 113.6 CAPITALIZED EXPENDITURES: 13-5895-6547 EQUIPMENT 48,191.00 117,088.46 122,724.00 5,635.54 95.4 TOTAL CAPITALIZED EXPENDITURES 48,191.00 117,088.46 122,724.00 5,635.54 95.4 TOTAL E CITATION 59,122.97 128,020.43 132,349.00 4,328.57 96.7 TOTAL FUND EXPENDITURES 80,627.51 384,988.12 407,320.00 22,331.88 94.5 NET REVENUE OVER EXPENDITURES ( 8,188.55) ( 34,483.45) 14,655.00 49,138.45 ( 235.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:28AM PAGE:32 ASSETS CURRENT ASSETS: CASH: 31-10000116 CASH ALLOC FR COMBINED FUND 686,235.58 31-10000118 MONEY MARKET ACCOUNT 119,764.01 TOTAL CASH 805,999.59 INVESTMENTS: 31-10000122 TIME DEPOSITS - SHORT TERM 6,040,143.26 TOTAL INVESTMENTS 6,040,143.26 ACCOUNTS RECEIVABLE: 31-10000131 ACCOUNTS RECEIVABLE - GENERAL 184,628.88 31-10000132 ACCOUNTS RECEIVABLE - EOY 258,460.14 31-10000136 ACCOUNTS RECEIVABLE - UTILITY 291,650.89 31-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 4,305.89) 31-10000139 ACCRUED INTEREST RECEIVABLE 3,047.82 31-10000156 DUE FROM OTHER FUNDS 13,945.48 TOTAL ACCOUNTS RECEIVABLE 747,427.32 TOTAL CURRENT ASSETS 7,593,570.17 FIXED ASSETS: 31-10000181 BUILDINGS 13,275,982.48 31-10000182 ACCUMULATED - BUILDINGS ( 5,081,341.69) 31-10000183 VEHICLES 358,905.06 31-10000184 ACCUMULATED - VEHICLES ( 319,709.70) 31-10000185 EQUIPMENT 452,170.55 31-10000186 ACCUMULATED - EQUIPMENT ( 353,424.04) 31-10000188 IMPROVEMENTS OTHER THAN BLDG 9,670,586.18 31-10000189 ACCUMULATED OT BLDG ( 5,521,492.43) TOTAL FIXED ASSETS 12,481,676.41 OTHER ASSETS: 31-10000190 ACCUMULATED ( 550,000.00) 31-10000195 CONSTRUCTION IN PROGRESS 1,789,042.50 31-10006100 DEFERRED OUTFLOW OF RESOURCES 35,359.28 TOTAL OTHER ASSETS 1,274,401.78 TOTAL NON-CURRENT ASSETS 13,756,078.19 TOTAL ASSETS 21,349,648.36 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:28AM PAGE:33 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 31-20000201 ALLOCATION FROM AP FUND 75,592.17 31-20000204 ACCOUNTS PAYABLE - EOY 41,416.37 31-20000215 WAGES PAYABLE 9,011.48 TOTAL ACCOUNTS PAYABLE 126,020.02 DUE TO OTHER FUNDS: 31-20000245 DUE TO OTHER FUNDS 9,039.24 TOTAL DUE TO OTHER FUNDS 9,039.24 OTHER PAYABLES: 31-20005410 UNFUNDED PENSION LIABILITY 215,951.97 31-20005411 DEFERRED INFLOSE OF RESOURCES 11,757.39 TOTAL OTHER PAYABLES 227,709.36 TOTAL CURRENT LIABILITIES 362,768.62 NON-CURRENT LIABILITIES: 31-20000250 LEASES PAYABLE 1,824.00 31-20000265 COMPENSATED ABSENCES PAYABLE 49,883.45 TOTAL NON-CURRENT LIABILITIES 51,707.45 TOTAL LIABILITIES 414,476.07 NET ASSETS CAPITAL ASSETS: 31-30000300 RETAINED EARNINGS 1,282,607.44 31-30000305 RESERVE FOR REPLACEMENT 4,357,815.69 31-30000306 RESERVE FOR OPERATING 575,425.00 31-30000308 RESERVE FOR SAND FILTERS 334,000.00 31-30000309 REPLACEMENT RESERVE - SMW REHA 30,000.00 TOTAL CAPITAL ASSETS 6,579,848.13 OTHER NET ASSETS: 31-30000320 CAPITAL ASSETS NET OF DEBT 14,268,894.72 TOTAL OTHER NET ASSETS 14,268,894.72 REVENUE OVER EXPENDITURES - YTD 86,429.44 BALANCE - CURRENT DATE 20,935,172.29 TOTAL NET ASSETS 20,935,172.29 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:28AM PAGE:34 TOTAL LIABILITIES AND NET ASSETS 21,349,648.36 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:28AM PAGE:35 WATER - REVENUE MISC LOCAL REVENUE: 31-4310-1107 OTHER .00 1,833.72 500.00 ( 1,333.72) 366.7 31-4310-1109 REIMBURSEMENTS .00 2,157.19 1,800.00 ( 357.19) 119.8 31-4310-1140 INTEREST INCOME 2,475.20 28,852.37 29,000.00 147.63 99.5 TOTAL MISC LOCAL REVENUE 2,475.20 32,843.28 31,300.00 ( 1,543.28) 104.9 UTILITIES REVENUE: 31-4310-1704 USER CHARGES 269,901.92 2,235,045.22 2,100,000.00 ( 135,045.22) 106.4 31-4310-1705 UTILITY SERVICE FEES 1,070.00 19,800.00 12,000.00 ( 7,800.00) 165.0 31-4310-1706 WATER PLANT INVESTMENT FEES 150.00 46,250.00 35,000.00 ( 11,250.00) 132.1 31-4310-1707 UTILITY LATE FEES 1,685.00 24,080.00 22,000.00 ( 2,080.00) 109.5 31-4310-1710 BULK WATER 6,983.84 41,480.74 40,000.00 ( 1,480.74) 103.7 TOTAL UTILITIES REVENUE 279,790.76 2,366,655.96 2,209,000.00 ( 157,655.96) 107.1 TRANSFERS IN: 31-4310-5596 TRANSFER FROM UTILITY DEPOSIT 44.53 240.44 200.00 ( 40.44) 120.2 TOTAL TRANSFERS IN 44.53 240.44 200.00 ( 40.44) 120.2 TOTAL WATER - REVENUE 282,310.49 2,399,739.68 2,240,500.00 ( 159,239.68) 107.1 LITTLE BOX ELDER SPRING - REVE STATE REVENUE: 31-4855-3235 WWDC GRANT 176,872.54 511,055.42 334,183.00 ( 176,872.42) 152.9 TOTAL STATE REVENUE 176,872.54 511,055.42 334,183.00 ( 176,872.42) 152.9 TOTAL LITTLE BOX ELDER SPRING - REVE 176,872.54 511,055.42 334,183.00 ( 176,872.42) 152.9 TOTAL FUND REVENUE 459,183.03 2,910,795.10 2,574,683.00 ( 336,112.10) 113.1 WATER - ADMINISTRATION CASH FUND APPROPRIATION: 31-5400-0150 REPLACEMENT RESERVE .00 .00 1,000,000.00 1,000,000.00 .0 TOTAL CASH FUND APPROP .00 .00 1,000,000.00 1,000,000.00 .0 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:36 DEPRECIATION: 31-5400-1150 DEPRECIATION 137,500.00 550,000.00 550,000.00 .00 100.0 TOTAL DEPRECIATION 137,500.00 550,000.00 550,000.00 .00 100.0 PROFESSIONAL SERVICES: 31-5400-2158 MISC CONTRACTUAL SERVICES 431.08 5,287.53 5,000.00 ( 287.53) 105.8 31-5400-2166 COLLECTION FEES 67.11 442.33 250.00 ( 192.33) 176.9 31-5400-2175 REFUNDS/REIMBURSEMENT EXPENSE .00 7,678.07 8,000.00 321.93 96.0 TOTAL PROFESSIONAL SERVICES 498.19 13,407.93 13,250.00 ( 157.93) 101.2 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 73,694.00 276,776.00 276,776.00 .00 100.0 TOTAL OPERATING TRANSFERS 73,694.00 276,776.00 276,776.00 .00 100.0 TOTAL WATER - ADMINISTRATION 211,692.19 840,567.93 1,840,410.00 999,842.07 45.7 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,318.74 93,017.14 93,106.00 88.86 99.9 31-5401-1002 SALARIES/WAGES - OVERTIME 469.35 4,616.18 7,500.00 2,883.82 61.6 31-5401-1005 SALARIES/WAGES - LONGEVITY .00 391.25 392.00 .75 99.8 31-5401-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 7,813.09 98,324.57 101,298.00 2,973.43 97.1 EMPLOYEE BENEFITS: 31-5401-1021 EMPLOYEE BENEFITS - SCL 599.99 7,551.66 7,779.00 227.34 97.1 31-5401-1023 EMPLOYEE BENEFITS - HEALTH INS 2,551.55 30,608.63 30,486.00 ( 122.63) 100.4 31-5401-1025 EMPLOYEE BENEFITS - COMP 356.27 4,483.53 4,637.00 153.47 96.7 31-5401-1028 EMPLOYEE BENEFITS - HLTH 91.48 1,075.45 1,074.00 ( 1.45) 100.1 31-5401-1029 EMPLOYEE BENEFITS - WY 1,294.39 16,195.99 16,721.00 525.01 96.9 TOTAL EMPLOYEE BENEFITS 4,893.68 59,915.26 60,697.00 781.74 98.7 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:37 PURCHASED SERVICES: 31-5401-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 300.00 300.00 .0 31-5401-2122 TRAINING/DEVELOPMENT .00 1,087.50 1,500.00 412.50 72.5 TOTAL PURCHASED SERVICES .00 1,087.50 1,800.00 712.50 60.4 PROPERTY SERVICES: 31-5401-2131 UTILITY SERVICES - ELECTRICITY 5,949.80 48,174.03 60,000.00 11,825.97 80.3 31-5401-2132 UTILITY SERVICES - WTR/SWR/GRB 1,032.22 6,115.12 9,000.00 2,884.88 68.0 31-5401-2133 UTILITY SERVICES - NATURAL GAS 372.34 4,267.91 6,500.00 2,232.09 65.7 31-5401-2134 TELECOMMUNICATIONS 14.83 178.02 225.00 46.98 79.1 31-5401-2140 RENT - LAND/BUILDINGS .00 193.50 225.00 31.50 86.0 TOTAL PROPERTY SERVICES 7,369.19 58,928.58 75,950.00 17,021.42 77.6 PROFESSIONAL SERVICES: 31-5401-2153 ARCHITECT, ENG, SURVEY .00 3,175.50 2,500.00 ( 675.50) 127.0 31-5401-2155 REPAIRS/MAINTENANCE .00 11,696.59 16,000.00 4,303.41 73.1 31-5401-2156 MAINTENANCE AGREEMENT .00 5,533.00 5,800.00 267.00 95.4 31-5401-2158 MISC CONTRACTUAL SERVICES 3,777.16 17,812.87 31,200.00 13,387.13 57.1 TOTAL PROFESSIONAL SERVICES 3,777.16 38,217.96 55,500.00 17,282.04 68.9 SUPPLIES: 31-5401-3210 OPERATING SUPPLIES 3,580.55 24,305.57 25,000.00 694.43 97.2 31-5401-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 11,764.12 14,500.00 2,735.88 81.1 31-5401-3235 FUEL 217.33 1,271.24 2,200.00 928.76 57.8 TOTAL SUPPLIES 3,797.88 37,340.93 41,700.00 4,359.07 89.6 CAPITALIZED EXPENDITURES: 31-5401-6544 OTHER THAN BLDG .00 1,200.00 10,000.00 8,800.00 12.0 TOTAL CAPITALIZED EXPENDITURES .00 1,200.00 10,000.00 8,800.00 12.0 TOTAL WATER - TREATMENT 27,651.00 295,014.80 411,945.00 116,930.20 71.6 WATER - DISTRIBUTION/MAINTNCE PERSONNEL SERVICES: 31-5402-1001 SALARIES/WAGES - REGULAR 12,473.39 156,189.51 171,128.00 14,938.49 91.3 31-5402-1002 SALARIES/WAGES - OVERTIME 1,055.40 6,288.58 7,000.00 711.42 89.8 31-5402-1004 SALARIES/WAGES - TEMPORARY 572.00 1,820.00 2,982.00 1,162.00 61.0 31-5402-1005 SALARIES/WAGES - LONGEVITY .00 383.93 791.00 407.07 48.5 31-5402-1007 SALARIES/WAGES - INCENTIVE .00 .00 793.00 793.00 .0 TOTAL PERSONNEL SERVICES 14,100.79 164,682.02 182,694.00 18,011.98 90.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:38 EMPLOYEE BENEFITS: 31-5402-1021 EMPLOYEE BENEFITS - SCL 1,081.02 12,624.67 14,006.00 1,381.33 90.1 31-5402-1023 EMPLOYEE BENEFITS - HEALTH INS 4,901.46 57,108.76 70,951.00 13,842.24 80.5 31-5402-1025 EMPLOYEE BENEFITS - COMP 643.01 7,509.50 8,312.00 802.50 90.4 31-5402-1028 EMPLOYEE BENEFITS - HLTH 155.60 1,810.19 1,975.00 164.81 91.7 31-5402-1029 EMPLOYEE BENEFITS - WY 2,244.34 26,904.31 29,605.00 2,700.69 90.9 TOTAL EMPLOYEE BENEFITS 9,025.43 105,957.43 124,849.00 18,891.57 84.9 PURCHASED SERVICES: 31-5402-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 91.50 1,165.11 1,500.00 334.89 77.7 31-5402-2122 TRAINING/DEVELOPMENT .00 2,134.50 2,480.00 345.50 86.1 31-5402-2123 MEALS/LODGING/TRAVEL .00 208.50 350.00 141.50 59.6 TOTAL PURCHASED SERVICES 91.50 3,508.11 4,330.00 821.89 81.0 PROPERTY SERVICES: 31-5402-2131 UTILITY SERVICES - ELECTRICITY 1,030.66 12,682.79 13,500.00 817.21 94.0 31-5402-2132 UTILITY SERVICES - WTR/SWR/GRB 2,246.72 11,831.40 32,000.00 20,168.60 37.0 31-5402-2133 UTILITY SERVICES - NATURAL GAS 36.44 868.38 1,500.00 631.62 57.9 31-5402-2134 TELECOMMUNICATIONS 63.22 378.50 600.00 221.50 63.1 31-5402-2141 EQUIPMENT - RENT .00 .00 400.00 400.00 .0 TOTAL PROPERTY SERVICES 3,377.04 25,761.07 48,000.00 22,238.93 53.7 PROFESSIONAL SERVICES: 31-5402-2153 ARCHITECT/ENGINEERING/SURVEY .00 2,477.47 3,000.00 522.53 82.6 31-5402-2155 REPAIRS/MAINTENANCE .00 695.06 3,000.00 2,304.94 23.2 31-5402-2156 MAINTENANCE AGREEMENT .00 795.00 800.00 5.00 99.4 31-5402-2158 MISC CONTRACTUAL SERVICES .00 .00 5,000.00 5,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 3,967.53 11,800.00 7,832.47 33.6 SUPPLIES: 31-5402-3210 OPERATING SUPPLIES 5,125.00 30,384.69 40,000.00 9,615.31 76.0 31-5402-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 3,450.70 3,500.70 50.00 98.6 31-5402-3235 FUEL 1,010.20 6,919.96 10,000.00 3,080.04 69.2 TOTAL SUPPLIES 6,135.20 40,755.35 53,500.70 12,745.35 76.2 FINANCIAL: 31-5402-4310 LEASE PAYMENTS - OPERATING .00 337.64 350.00 12.36 96.5 TOTAL FINANCIAL .00 337.64 350.00 12.36 96.5 TOTAL WATER - DISTRIBUTION/MAINTNCE 32,729.96 344,969.15 425,523.70 80,554.55 81.1 WATER - CUSTOMER SERVICES ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:39 PERSONNEL SERVICES: 31-5403-1001 SALARIES/WAGES - REGULAR 7,488.67 97,261.42 97,379.00 117.58 99.9 31-5403-1005 SALARIES/WAGES - LONGEVITY .00 1,060.32 1,061.00 .68 99.9 31-5403-1007 SALARIES/WAGES - INCENTIVE .00 1,788.80 2,139.00 350.20 83.6 TOTAL PERSONNEL SERVICES 7,488.67 100,110.54 100,579.00 468.46 99.5 EMPLOYEE BENEFITS: 31-5403-1021 EMPLOYEE BENEFITS - SCL 579.86 7,764.80 7,992.00 227.20 97.2 31-5403-1023 EMPLOYEE BENEFITS - HEALTH INS 688.24 8,258.88 7,962.00 ( 296.88) 103.7 31-5403-1025 EMPLOYEE BENEFITS - COMP 341.48 4,564.99 4,542.00 ( 22.99) 100.5 31-5403-1026 EMPLOYEE BENEFITS - COMP 299.54 3,890.37 3,895.00 4.63 99.9 31-5403-1028 EMPLOYEE BENEFITS - HLTH 93.60 1,123.20 1,124.00 .80 99.9 31-5403-1029 EMPLOYEE BENEFITS - WY 1,244.60 16,137.24 16,184.00 46.76 99.7 TOTAL EMPLOYEE BENEFITS 3,247.32 41,739.48 41,699.00 ( 40.48) 100.1 PURCHASED SERVICES: 31-5403-2122 TRAINING/DEVELOPMENT .00 .00 610.00 610.00 .0 TOTAL PURCHASED SERVICES .00 .00 610.00 610.00 .0 PROPERTY SERVICES: 31-5403-2134 TELECOMMUNICATIONS 15.92 191.07 300.00 108.93 63.7 TOTAL PROPERTY SERVICES 15.92 191.07 300.00 108.93 63.7 PROFESSIONAL SERVICES: 31-5403-2155 REPAIRS/MAINTENANCE .00 .00 1,500.00 1,500.00 .0 31-5403-2156 MAINTENANCE AGREEMENT .00 1,838.00 1,838.00 .00 100.0 TOTAL PROFESSIONAL SERVICES .00 1,838.00 3,338.00 1,500.00 55.1 SUPPLIES: 31-5403-3210 OPERATING SUPPLIES 196.57 2,867.11 4,000.00 1,132.89 71.7 31-5403-3220 EQUIPMENT/TOOLS-NON CAPITALIZE 4,619.31 15,402.28 24,236.00 8,833.72 63.6 31-5403-3235 FUEL 180.66 1,433.38 2,500.00 1,066.62 57.3 TOTAL SUPPLIES 4,996.54 19,702.77 30,736.00 11,033.23 64.1 CAPITALIZED EXPENDITURES: 31-5403-6547 EQUIPMENT .00 108,688.00 120,000.00 11,312.00 90.6 TOTAL CAPITALIZED EXPENDITURES .00 108,688.00 120,000.00 11,312.00 90.6 TOTAL WATER - CUSTOMER SERVICES 15,748.45 272,269.86 297,262.00 24,992.14 91.6 WATER MAIN REPLACEMENTS ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:40 PROFESSIONAL SERVICES: 31-5840-2153 ARCHITECT/ENGINEERING/SURVEY 25,972.48 358,463.35 434,000.00 75,536.65 82.6 31-5840-2158 MISC CONTRACTUAL SERVICES .00 25.65 .00 ( 25.65) .0 TOTAL PROFESSIONAL SERVICES 25,972.48 358,489.00 434,000.00 75,511.00 82.6 CAPITALIZED EXPENDITURES: 31-5840-6544 OTHER THAN BLDG 13,858.67 671,998.34 756,000.00 84,001.66 88.9 TOTAL CAPITALIZED EXPENDITURES 13,858.67 671,998.34 756,000.00 84,001.66 88.9 TOTAL WATER MAIN REPLACEMENTS 39,831.15 1,030,487.34 1,190,000.00 159,512.66 86.6 LITTLE BOX ELDER SPRING REHAB PROFESSIONAL SERVICES: 31-5855-2153 ARCHITECT/ENGINEERING/SURVEY .00 20,358.95 20,359.00 .05 100.0 31-5855-2158 MISC CONTRACTUAL SERVICES 5,702.40 12,764.55 7,062.00 ( 5,702.55) 180.8 TOTAL PROFESSIONAL SERVICES 5,702.40 33,123.50 27,421.00 ( 5,702.50) 120.8 TOTAL LITTLE BOX ELDER SPRING REHAB 5,702.40 33,123.50 27,421.00 ( 5,702.50) 120.8 WATER IMPROVEMENTS PROFESSIONAL SERVICES: 31-5856-2153 ARCHITECT/ENGINEERING/SURVEY .00 3,148.60 8,000.00 4,851.40 39.4 31-5856-2158 MISC CONTRACTUAL .00 4,784.48 30,000.00 25,215.52 16.0 TOTAL PROFESSIONAL SERVICES .00 7,933.08 38,000.00 30,066.92 20.9 TOTAL WATER IMPROVEMENTS .00 7,933.08 38,000.00 30,066.92 20.9 TOTAL FUND EXPENDITURES 333,355.15 2,824,365.66 4,230,561.70 1,406,196.04 66.8 NET REVENUE OVER EXPENDITURES 125,827.88 86,429.44 ( 1,655,878.70) ( 1,742,308.14) 5.2 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:41 ASSETS CURRENT ASSETS: CASH: 32-10000116 CASH ALLOC FR COMBINED FUND 335,804.38 32-10000118 MONEY MARKET ACCOUNT 119,764.00 TOTAL CASH 455,568.38 INVESTMENTS: 32-10000120 INVESTMENT POOL 221,859.78 32-10000122 TIME DEPOSITS - SHORT TERM 3,960,310.42 TOTAL INVESTMENTS 4,182,170.20 ACCOUNTS RECEIVABLE: 32-10000131 ACCOUNTS RECEIVABLE - GENERAL 8,812.50 32-10000132 ACCOUNTS RECEIVABLE - EOY ( 3,245.79) 32-10000136 ACCOUNTS RECEIVABLE - UTILITY 124,567.40 32-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 2,368.76) 32-10000139 ACCRUED INTEREST RECEIVABLE 1,343.60 32-10000156 DUE FROM OTHER FUNDS 8,273.48 TOTAL ACCOUNTS RECEIVABLE 137,382.43 TOTAL CURRENT ASSETS 4,775,121.01 FIXED ASSETS: 32-10000181 BUILDINGS 2,278,172.45 32-10000182 ACCUMULATED - BUILDINGS ( 1,704,851.43) 32-10000183 VEHICLES 505,362.91 32-10000184 ACCUMULATED - VEHICLES ( 466,167.55) 32-10000185 MACHINERY/EQUIPMENT 467,701.47 32-10000186 ACCUMULATED - EQUIPMENT ( 282,766.02) 32-10000188 IMPROVEMENTS OTHER THAN BLDG 6,489,067.92 32-10000189 ACCUMULATED OT BLDG ( 2,342,473.05) TOTAL FIXED ASSETS 4,944,046.70 OTHER ASSETS: 32-10000190 ACCUMULATED ( 190,000.00) 32-10000195 CONSTRUCTION IN PROGRESS 119,127.30 32-10006100 DEFERRED OUTFLOWS OF RESOURCES 21,889.06 TOTAL OTHER ASSETS ( 48,983.64) TOTAL NON-CURRENT ASSETS 4,895,063.06 TOTAL ASSETS 9,670,184.07 LIABILITIES AND EQUITY LIABILITIES ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:42 CURRENT LIABILITIES: ACCOUNTS PAYABLE: 32-20000201 ALLOCATION FROM AP FUND 41,948.28 32-20000204 ACCOUNTS PAYABLE - EOY ( 2,783.43) 32-20000215 WAGES PAYABLE 4,931.79 TOTAL ACCOUNTS PAYABLE 44,096.64 DUE TO OTHER FUNDS: 32-20000245 DUE TO OTHER FUNDS 2,783.43 TOTAL DUE TO OTHER FUNDS 2,783.43 OTHER PAYABLES: 32-20005410 UNFUNDED PENSION LIABILITY 133,684.55 32-20005411 DEFERRED INFLOWS OF RESOURCES 7,278.38 TOTAL OTHER PAYABLES 140,962.93 TOTAL CURRENT LIABILITIES 187,843.00 NON-CURRENT LIABILITIES: 32-20000250 LEASES PAYABLE .16 32-20000265 COMPENSATED ABSENCES PAYABLE 31,916.13 TOTAL NON-CURRENT LIABILITIES 31,916.29 TOTAL LIABILITIES 219,759.29 NET ASSETS CAPITAL ASSETS: 32-30000300 RETAINED EARNINGS 340,408.17 32-30000305 RESERVE FOR REPLACEMENT 3,800,882.31 32-30000306 RESERVE FOR OPERATING 195,913.00 32-30000307 RESERVE FOR SLUDGE REMOVAL 165,000.00 TOTAL CAPITAL ASSETS 4,502,203.48 OTHER NET ASSETS: 32-30000320 CAPITAL ASSETS NET OF DEBT 5,063,173.94 TOTAL OTHER NET ASSETS 5,063,173.94 REVENUE OVER EXPENDITURES - YTD ( 114,952.64) BALANCE - CURRENT DATE 9,450,424.78 TOTAL NET ASSETS 9,450,424.78 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 SEWER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:43 TOTAL LIABILITIES AND NET ASSETS 9,670,184.07 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:29AM PAGE:44 SEWER - REVENUE MISC LOCAL REVENUE: 32-4320-1107 OTHER .00 1,652.24 500.00 ( 1,152.24) 330.5 32-4320-1109 REIMBURSEMENTS .00 2,845.82 840.00 ( 2,005.82) 338.8 32-4320-1140 INTEREST INCOME 1,434.85 19,913.72 17,500.00 ( 2,413.72) 113.8 TOTAL MISC LOCAL REVENUE 1,434.85 24,411.78 18,840.00 ( 5,571.78) 129.6 UTILITIES REVENUE: 32-4320-1704 USER CHARGES 105,792.15 1,285,757.72 1,250,000.00 ( 35,757.72) 102.9 32-4320-1706 SEWER PLANT INVESTMENT FEES .00 14,000.00 13,000.00 ( 1,000.00) 107.7 TOTAL UTILITIES REVENUE 105,792.15 1,299,757.72 1,263,000.00 ( 36,757.72) 102.9 SEPTIC WASTE DISPOSAL: 32-4320-1751 SEPTIC WASTE DISP FEES 9,225.00 94,440.00 90,000.00 ( 4,440.00) 104.9 TOTAL SEPTIC WASTE DISPOSAL 9,225.00 94,440.00 90,000.00 ( 4,440.00) 104.9 TOTAL SEWER - REVENUE 116,452.00 1,418,609.50 1,371,840.00 ( 46,769.50) 103.4 TOTAL FUND REVENUE 116,452.00 1,418,609.50 1,371,840.00 ( 46,769.50) 103.4 SEWER - ADMINISTRATION CASH FUND APPROPRIATION: 32-5500-0150 REPLACEMENT RESERVE .00 .00 700,000.00 700,000.00 .0 TOTAL CASH FUND APPROP .00 .00 700,000.00 700,000.00 .0 DEPRECIATION: 32-5500-1150 DEPRECIATION 47,500.00 190,000.00 190,000.00 .00 100.0 TOTAL DEPRECIATION 47,500.00 190,000.00 190,000.00 .00 100.0 PROFESSIONAL SERVICES: 32-5500-2158 MISC CONTRACTUAL SERVICES 278.41 3,415.13 4,500.00 1,084.87 75.9 TOTAL PROFESSIONAL SERVICES 278.41 3,415.13 4,500.00 1,084.87 75.9 OPERATING TRANSFERS: 32-5500-4347 MANAGEMENT FEES 45,522.50 182,090.00 182,090.00 .00 100.0 TOTAL OPERATING TRANSFERS 45,522.50 182,090.00 182,090.00 .00 100.0 TOTAL SEWER - ADMINISTRATION 93,300.91 375,505.13 1,076,590.00 701,084.87 34.9 SEWER - TREATMENT ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:30AM PAGE:45 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,872.44 88,258.62 88,352.00 93.38 99.9 32-5501-1002 SALARIES/WAGES - OVERTIME .00 3,108.86 6,000.00 2,891.14 51.8 32-5501-1005 SALARIES/WAGES - LONGEVITY .00 360.03 361.00 .97 99.7 32-5501-1006 SALARIES/WAGES - ALLOWANCES 25.00 300.00 300.00 .00 100.0 TOTAL PERSONNEL SERVICES 6,897.44 92,027.51 95,013.00 2,985.49 96.9 EMPLOYEE BENEFITS: 32-5501-1021 EMPLOYEE BENEFITS - SCL 528.86 7,056.79 7,298.00 241.21 96.7 32-5501-1023 EMPLOYEE BENEFITS - HEALTH INS 2,549.44 30,588.01 30,467.00 ( 121.01) 100.4 32-5501-1025 EMPLOYEE BENEFITS - COMP 314.51 4,196.31 4,350.00 153.69 96.5 32-5501-1028 EMPLOYEE BENEFITS - HLTH 85.90 1,018.59 1,019.00 .41 100.0 32-5501-1029 EMPLOYEE BENEFITS - WY 1,142.18 15,160.87 15,681.00 520.13 96.7 TOTAL EMPLOYEE BENEFITS 4,620.89 58,020.57 58,815.00 794.43 98.7 PURCHASED SERVICES: 32-5501-2122 TRAINING/DEVELOPMENT .00 862.50 1,500.00 637.50 57.5 TOTAL PURCHASED SERVICES .00 862.50 1,500.00 637.50 57.5 PROPERTY SERVICES: 32-5501-2131 UTILITY SERVICES - ELECTRICITY 8,006.41 92,857.34 95,000.00 2,142.66 97.7 32-5501-2132 UTILITY SERVICES - WTR/SWR/GRB 8,986.32 52,514.71 54,000.00 1,485.29 97.3 32-5501-2134 TELECOMMUNICATIONS 242.11 1,614.57 2,000.00 385.43 80.7 TOTAL PROPERTY SERVICES 17,234.84 146,986.62 151,000.00 4,013.38 97.3 PROFESSIONAL SERVICES: 32-5501-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 32-5501-2155 REPAIRS/MAINTENANCE .00 8,114.93 12,000.00 3,885.07 67.6 32-5501-2158 MISC CONTRACTUAL SERVICES 104.00 6,425.00 11,000.00 4,575.00 58.4 TOTAL PROFESSIONAL SERVICES 104.00 14,539.93 24,000.00 9,460.07 60.6 SUPPLIES: 32-5501-3210 OPERATING SUPPLIES 1,992.64 18,387.68 24,000.00 5,612.32 76.6 32-5501-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 419.99 450.00 30.01 93.3 32-5501-3235 FUEL 217.31 1,271.12 2,200.00 928.88 57.8 TOTAL SUPPLIES 2,209.95 20,078.79 26,650.00 6,571.21 75.3 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:30AM PAGE:46 CAPITALIZED EXPENDITURES: 32-5501-6544 OTHER THAN BLDG .00 41,220.06 42,000.00 779.94 98.1 TOTAL CAPITALIZED EXPENDITURES .00 41,220.06 42,000.00 779.94 98.1 TOTAL SEWER - TREATMENT 31,067.12 373,735.98 413,978.00 40,242.02 90.3 SEWER - COLLECTION PERSONNEL SERVICES: 32-5502-1001 SALARIES/WAGES - REGULAR 10,770.75 130,168.14 150,000.00 19,831.86 86.8 32-5502-1002 SALARIES/WAGES - OVERTIME .00 2,548.02 4,000.00 1,451.98 63.7 32-5502-1004 SALARIES/WAGES - TEMPORARY 572.00 1,820.00 2,982.00 1,162.00 61.0 32-5502-1005 SALARIES/WAGES - LONGEVITY .00 245.38 909.00 663.62 27.0 32-5502-1007 SALARIES/WAGES - INCENTIVE .00 .00 793.00 793.00 .0 TOTAL PERSONNEL SERVICES 11,342.75 134,781.54 158,684.00 23,902.46 84.9 EMPLOYEE BENEFITS: 32-5502-1021 EMPLOYEE BENEFITS - SCL 861.61 10,236.35 10,500.00 263.65 97.5 32-5502-1023 EMPLOYEE BENEFITS - HEALTH INS 5,925.10 62,641.63 65,000.00 2,358.37 96.4 32-5502-1025 EMPLOYEE BENEFITS - COMP 517.23 6,146.01 6,250.00 103.99 98.3 32-5502-1028 EMPLOYEE BENEFITS - HLTH 139.01 1,522.83 1,600.00 77.17 95.2 32-5502-1029 EMPLOYEE BENEFITS - WY 1,785.92 21,967.40 23,000.00 1,032.60 95.5 TOTAL EMPLOYEE BENEFITS 9,228.87 102,514.22 106,350.00 3,835.78 96.4 PURCHASED SERVICES: 32-5502-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS 91.50 1,045.14 1,300.00 254.86 80.4 32-5502-2122 TRAINING/DEVELOPMENT 98.00 1,940.50 2,480.00 539.50 78.3 32-5502-2123 MEALS/LODGING/TRAVEL .00 208.50 350.00 141.50 59.6 TOTAL PURCHASED SERVICES 189.50 3,194.14 4,130.00 935.86 77.3 PROPERTY SERVICES: 32-5502-2131 UTILITY SERVICES - ELECTRICITY 1,455.11 12,891.67 12,000.00 ( 891.67) 107.4 32-5502-2132 UTILITY SERVICES - WTR/SWR/GRB 47.11 450.95 450.00 ( .95) 100.2 32-5502-2133 UTILITY SERVICES - NATURAL GAS 138.72 1,384.99 1,800.00 415.01 76.9 32-5502-2134 TELECOMMUNICATIONS 125.94 1,131.42 1,200.00 68.58 94.3 TOTAL PROPERTY SERVICES 1,766.88 15,859.03 15,450.00 ( 409.03) 102.7 PROFESSIONAL SERVICES: 32-5502-2153 ARCHITECT/ENGINEERING/SURVEY .00 1,285.63 3,000.00 1,714.37 42.9 32-5502-2155 REPAIRS/MAINTENANCE .00 535.73 4,900.00 4,364.27 10.9 32-5502-2158 MISC CONTRACTUAL SERVICES .00 .00 5,000.00 5,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 1,821.36 12,900.00 11,078.64 14.1 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 SEWER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:30AM PAGE:47 SUPPLIES: 32-5502-3210 OPERATING SUPPLIES 4,620.91 26,047.89 35,000.00 8,952.11 74.4 32-5502-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 3,500.70 3,500.70 .00 100.0 32-5502-3235 FUEL 1,010.09 6,919.33 10,500.00 3,580.67 65.9 TOTAL SUPPLIES 5,631.00 36,467.92 49,000.70 12,532.78 74.4 FINANCIAL: 32-5502-4310 LEASE PAYMENTS - OPERATING .00 .00 150.00 150.00 .0 TOTAL FINANCIAL .00 .00 150.00 150.00 .0 CAPITALIZED EXPENDITURES: 32-5502-6547 EQUIPMENT/FURNITURE 12,214.94 43,640.94 45,000.00 1,359.06 97.0 TOTAL CAPITALIZED EXPENDITURES 12,214.94 43,640.94 45,000.00 1,359.06 97.0 TOTAL SEWER - COLLECTION 40,373.94 338,279.15 391,664.70 53,385.55 86.4 WASTEWATER PLANT REHAB PROFESSIONAL SERVICES: 32-5850-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 25,000.00 25,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL WASTEWATER PLANT REHAB .00 .00 25,000.00 25,000.00 .0 SEWER MAIN REPLACEMENTS PROFESSIONAL SERVICES: 32-5852-2153 ARCHITECT/ENGINEERING/SURVEY .00 61,175.93 84,500.00 23,324.07 72.4 TOTAL PROFESSIONAL SERVICES .00 61,175.93 84,500.00 23,324.07 72.4 CAPITALIZED EXPENDITURES: 32-5852-6544 OTHER THAN BLDG 2,318.76 384,865.95 702,000.00 317,134.05 54.8 TOTAL CAPITALIZED EXPENDITURES 2,318.76 384,865.95 702,000.00 317,134.05 54.8 TOTAL SEWER MAIN REPLACEMENTS 2,318.76 446,041.88 786,500.00 340,458.12 56.7 TOTAL FUND EXPENDITURES 167,060.73 1,533,562.14 2,693,732.70 1,160,170.56 56.9 NET REVENUE OVER EXPENDITURES ( 50,608.73) ( 114,952.64) ( 1,321,892.70) ( 1,206,940.06) ( 8.7) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:30AM PAGE:48 ASSETS CURRENT ASSETS: CASH: 33-10000116 CASH ALLOC FR COMBINED FUND 128,298.53 TOTAL CASH 128,298.53 INVESTMENTS: 33-10000122 TIME DEPOSITS - SHORT TERM 440,883.21 TOTAL INVESTMENTS 440,883.21 ACCOUNTS RECEIVABLE: 33-10000131 ACCOUNTS RECEIVABLE - GENERAL 546.29 33-10000132 ACCOUNTS RECEIVABLE - EOY ( 453.40) 33-10000136 ACCOUNTS RECEIVABLE - UTILITY 38,220.46 33-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 781.51) 33-10000139 ACCRUED INTEREST RECEIVABLE 252.20 33-10000156 DUE FROM OTHER FUNDS 453.40 TOTAL ACCOUNTS RECEIVABLE 38,237.44 TOTAL CURRENT ASSETS 607,419.18 FIXED ASSETS: 33-10000183 VEHICLES 559,776.68 33-10000184 ACCUMULATED - VEHICLES ( 258,765.19) 33-10000185 EQUIPMENT 33,437.00 33-10000186 ACCUMULATED - EQUIPMENT ( 33,437.00) TOTAL FIXED ASSETS 301,011.49 OTHER ASSETS: 33-10000190 ACCUMULATED ( 35,000.00) 33-10006100 DEFERRED OUTFLOWS OF RESOURCES 10,944.54 TOTAL OTHER ASSETS ( 24,055.46) TOTAL NON-CURRENT ASSETS 276,956.03 TOTAL ASSETS 884,375.21 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 SANITATION FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:30AM PAGE:49 ACCOUNTS PAYABLE: 33-20000201 ALLOCATION FROM AP FUND 3,056.19 33-20000215 WAGES PAYABLE 3,055.68 TOTAL ACCOUNTS PAYABLE 6,111.87 OTHER PAYABLES: 33-20005410 UNFUNDED PENSION LIABILITY 66,842.28 33-20005411 DEFERRED INFLOWS OF RESOURCES 3,639.19 TOTAL OTHER PAYABLES 70,481.47 TOTAL CURRENT LIABILITIES 76,593.34 NON-CURRENT LIABILITIES: 33-20000265 COMPENSATED ABSENCES PAYABLE 17,030.99 TOTAL NON-CURRENT LIABILITIES 17,030.99 TOTAL LIABILITIES 93,624.33 NET ASSETS CAPITAL ASSETS: 33-30000300 RETAINED EARNINGS ( 204,806.46) 33-30000305 RESERVE FOR REPLACEMENT 606,984.54 33-30000306 RESERVE FOR OPERATING 75,760.00 TOTAL CAPITAL ASSETS 477,938.08 OTHER NET ASSETS: 33-30000320 CAPITAL ASSETS NET OF DEBT 301,010.29 TOTAL OTHER NET ASSETS 301,010.29 REVENUE OVER EXPENDITURES - YTD 11,802.51 BALANCE - CURRENT DATE 790,750.88 TOTAL NET ASSETS 790,750.88 TOTAL LIABILITIES AND NET ASSETS 884,375.21 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:30AM PAGE:50 SANITATION - REVENUE MISC LOCAL REVENUE: 33-4330-1140 INTEREST INCOME 79.11 2,130.60 2,000.00 ( 130.60) 106.5 TOTAL MISC LOCAL REVENUE 79.11 2,130.60 2,000.00 ( 130.60) 106.5 UTILITIES REVENUE: 33-4330-1704 USER CHARGES 33,690.78 403,333.67 350,000.00 ( 53,333.67) 115.2 33-4330-1709 SANITATION ACTIVATION FEE .00 3,125.00 3,500.00 375.00 89.3 TOTAL UTILITIES REVENUE 33,690.78 406,458.67 353,500.00 ( 52,958.67) 115.0 TOTAL SANITATION - REVENUE 33,769.89 408,589.27 355,500.00 ( 53,089.27) 114.9 TOTAL FUND REVENUE 33,769.89 408,589.27 355,500.00 ( 53,089.27) 114.9 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,442.78 129,927.04 134,028.00 4,100.96 96.9 33-5600-1002 SALARIES/WAGES - OVERTIME .00 .00 600.00 600.00 .0 33-5600-1005 SALARIES/WAGES - LONGEVITY .00 1,008.10 1,009.00 .90 99.9 33-5600-1006 SALARIES/WAGES - ALLOWANCES 25.00 262.50 300.00 37.50 87.5 33-5600-1007 SALARIES/WAGES - INCENTIVE .00 582.40 1,022.00 439.60 57.0 TOTAL PERSONNEL SERVICES 10,467.78 131,780.04 136,959.00 5,178.96 96.2 EMPLOYEE BENEFITS: 33-5600-1021 EMPLOYEE BENEFITS - SCL 807.23 10,154.61 10,560.00 405.39 96.2 33-5600-1023 EMPLOYEE BENEFITS - HEALTH INS 4,244.20 49,646.22 50,726.00 1,079.78 97.9 33-5600-1025 EMPLOYEE BENEFITS - COMP 477.34 6,009.26 6,216.00 206.74 96.7 33-5600-1026 EMPLOYEE BENEFITS - COMP 54.24 616.19 695.00 78.81 88.7 33-5600-1028 EMPLOYEE BENEFITS - HLTH 130.52 1,497.00 1,546.00 49.00 96.8 33-5600-1029 EMPLOYEE BENEFITS - WY 1,735.58 21,561.20 22,375.00 813.80 96.4 TOTAL EMPLOYEE BENEFITS 7,449.11 89,484.48 92,118.00 2,633.52 97.1 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, 2016 SANITATION FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:33AM PAGE:51 PURCHASED SERVICES: 33-5600-2122 TRAINING/DEVELOPMENT .00 255.00 250.00 ( 5.00) 102.0 33-5600-2123 MEALS/LODGING/TRAVEL .00 .00 145.00 145.00 .0 TOTAL PURCHASED SERVICES .00 255.00 395.00 140.00 64.6 PROFESSIONAL SERVICES: 33-5600-2155 REPAIRS/MAINTENANCE .00 .00 1,000.00 1,000.00 .0 33-5600-2158 MISC CONTRACTUAL SERVICES 188.60 2,313.45 3,000.00 686.55 77.1 33-5600-2175 REFUNDS/REIMBURSEMENTS .00 .00 125.00 125.00 .0 TOTAL PROFESSIONAL SERVICES 188.60 2,313.45 4,125.00 1,811.55 56.1 SUPPLIES: 33-5600-3210 OPERATING SUPPLIES 75.23 33,010.03 32,500.00 ( 510.03) 101.6 33-5600-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 38,832.00 39,000.00 168.00 99.6 33-5600-3235 FUEL 2,792.36 17,748.76 32,000.00 14,251.24 55.5 TOTAL SUPPLIES 2,867.59 89,590.79 103,500.00 13,909.21 86.6 OPERATING TRANSFERS: 33-5600-4347 MANAGEMENT FEES 12,090.75 48,363.00 48,363.00 .00 100.0 TOTAL OPERATING TRANSFERS 12,090.75 48,363.00 48,363.00 .00 100.0 TOTAL SANITATION 41,813.83 396,786.76 450,460.00 53,673.24 88.1 TOTAL FUND EXPENDITURES 41,813.83 396,786.76 450,460.00 53,673.24 88.1 NET REVENUE OVER EXPENDITURES ( 8,043.94) 11,802.51 ( 94,960.00) ( 106,762.51) 12.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:33AM PAGE:52 ASSETS CURRENT ASSETS: CASH: 34-10000116 CASH ALLOC FR COMBINED FUND 314,508.01 TOTAL CASH 314,508.01 INVESTMENTS: 34-10000122 TIME DEPOSITS - SHORT TERM 2,064,468.36 TOTAL INVESTMENTS 2,064,468.36 ACCOUNTS RECEIVABLE: 34-10000131 ACCOUNTS RECEIVABLE - GENERAL 20,204.05 34-10000132 ACCOUNTS RECEIVABLE - EOY ( 857.96) 34-10000136 ACCOUNTS RECEIVABLE - UTILITY 36,558.61 34-10000137 ALLOWANCE FOR UNCOLLECTIBLE ( 716.57) 34-10000139 ACCRUED INTEREST RECEIVABLE 1,237.12 34-10000156 DUE FROM OTHER FUNDS 857.96 TOTAL ACCOUNTS RECEIVABLE 57,283.21 TOTAL CURRENT ASSETS 2,436,259.58 FIXED ASSETS: 34-10000180 LAND 153,289.58 34-10000181 BUILDINGS 1,689,609.46 34-10000182 ACCUMULATED - BUILDINGS ( 205,589.81) 34-10000185 EQUIPMENT 1,002,285.94 34-10000186 ACCUMULATED - EQUIPMENT ( 558,494.91) 34-10000188 IMPROVEMENTS OTHER THAN BLDG 417,030.94 34-10000189 ACCUMULATED OT BLDG ( 2,477.12) TOTAL FIXED ASSETS 2,495,654.08 OTHER ASSETS: 34-10000190 ACCUMULATED ( 40,000.00) 34-10006100 DEFERRED OUTFLOWS OF RESOURCES 15,995.86 TOTAL OTHER ASSETS ( 24,004.14) TOTAL NON-CURRENT ASSETS 2,471,649.94 TOTAL ASSETS 4,907,909.52 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 LANDFILL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:33AM PAGE:53 ACCOUNTS PAYABLE: 34-20000201 ALLOCATION FROM AP FUND 77,508.31 34-20000205 INTEREST PAYABLE 3,425.54 34-20000210 RETAINAGE PAYABLE .01 34-20000215 WAGES PAYABLE 5,878.63 TOTAL ACCOUNTS PAYABLE 86,812.49 OTHER PAYABLES: 34-20005410 UNFUNDED PENSION LIABLITY 97,692.56 34-20005411 DEFERRED INFLOWS OF RESOURCES 5,318.82 TOTAL OTHER PAYABLES 103,011.38 TOTAL CURRENT LIABILITIES 189,823.87 NON-CURRENT LIABILITIES: 34-20000250 LEASES PAYABLE 166,426.75 34-20000265 COMPENSATED ABSENCES PAYABLE 43,342.85 34-20000290 LANDFILL LIABILITY 665,060.00 34-20000295 NOTES PAYABLE 324,907.58 TOTAL NON-CURRENT LIABILITIES 1,199,737.18 TOTAL LIABILITIES 1,389,561.05 NET ASSETS CAPITAL ASSETS: 34-30000300 RETAINED EARNINGS 704,483.27 34-30000305 RESERVE FOR REPLACEMENT 1,006,520.77 34-30000306 RESERVE FOR OPERATING 132,650.00 TOTAL CAPITAL ASSETS 1,843,654.04 OTHER NET ASSETS: 34-30000320 CAPITAL ASSETS NET OF DEBT 2,004,319.95 TOTAL OTHER NET ASSETS 2,004,319.95 REVENUE OVER EXPENDITURES - YTD ( 329,625.52) BALANCE - CURRENT DATE 3,518,348.47 TOTAL NET ASSETS 3,518,348.47 TOTAL LIABILITIES AND NET ASSETS 4,907,909.52 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:33AM PAGE:54 LANDFILL - REVENUE MISC LOCAL REVENUE: 34-4340-1107 OTHER 1,004.10 12,060.81 10,500.00 ( 1,560.81) 114.9 34-4340-1140 INTEREST INCOME 233.73 10,278.59 10,000.00 ( 278.59) 102.8 TOTAL MISC LOCAL REVENUE 1,237.83 22,339.40 20,500.00 ( 1,839.40) 109.0 UTILITIES REVENUE: 34-4340-1704 USER CHARGES 62,145.38 676,698.93 700,000.00 23,301.07 96.7 TOTAL UTILITIES REVENUE 62,145.38 676,698.93 700,000.00 23,301.07 96.7 TOTAL LANDFILL - REVENUE 63,383.21 699,038.33 720,500.00 21,461.67 97.0 TOTAL FUND REVENUE 63,383.21 699,038.33 720,500.00 21,461.67 97.0 LANDFILL CASH FUND APPROPRIATION: 34-5340-0150 EQUIPMENT RESERVE .00 .00 80,000.00 80,000.00 .0 34-5340-0153 POST CLOSURE RESERVE .00 .00 500,000.00 500,000.00 .0 TOTAL CASH FUND APPROP .00 .00 580,000.00 580,000.00 .0 PERSONNEL SERVICES: 34-5340-1001 SALARIES/WAGES - REGULAR 19,733.29 227,381.70 230,000.00 2,618.30 98.9 34-5340-1002 SALARIES/WAGES - OVERTIME .00 894.71 1,500.00 605.29 59.7 34-5340-1005 SALARIES/WAGES - LONGEVITY .00 1,794.10 1,795.00 .90 100.0 34-5340-1006 SALARIES/WAGES - ALLOWANCES 50.00 437.50 600.00 162.50 72.9 34-5340-1007 SALARIES/WAGES - INCENTIVE .00 2,912.08 2,912.00 ( .08) 100.0 TOTAL PERSONNEL SERVICES 19,783.29 233,420.09 236,807.00 3,386.91 98.6 EMPLOYEE BENEFITS: 34-5340-1021 EMPLOYEE BENEFITS - SCL 1,558.41 18,462.61 20,000.00 1,537.39 92.3 34-5340-1023 EMPLOYEE BENEFITS - HEALTH INS 8,466.70 84,269.75 85,000.00 730.25 99.1 34-5340-1025 EMPLOYEE BENEFITS - COMP 902.13 10,644.09 11,000.00 355.91 96.8 34-5340-1026 EMPLOYEE BENEFITS - COMP 560.28 7,665.29 7,246.00 ( 419.29) 105.8 34-5340-1028 EMPLOYEE BENEFITS - HLTH 204.72 2,108.06 2,150.00 41.94 98.1 34-5340-1029 EMPLOYEE BENEFITS - WY 2,719.40 30,167.48 31,000.00 832.52 97.3 TOTAL EMPLOYEE BENEFITS 14,411.64 153,317.28 156,396.00 3,078.72 98.0 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 ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:34AM PAGE:55 PURCHASED SERVICES: 34-5340-2120 DUES/MEMBERSHIPS/SUBSCRIPTIONS .00 .00 250.00 250.00 .0 34-5340-2122 TRAINING/DEVELOPMENT .00 775.00 775.00 .00 100.0 34-5340-2123 MEALS/LODGING/TRAVEL .00 446.00 710.00 264.00 62.8 TOTAL PURCHASED SERVICES .00 1,221.00 1,735.00 514.00 70.4 PROPERTY SERVICES: 34-5340-2131 UTILITY SERVICES - ELECTRICITY 578.78 7,971.47 8,500.00 528.53 93.8 34-5340-2133 UTILITY SERVICES - NATURAL GAS 207.97 6,427.75 6,000.00 ( 427.75) 107.1 34-5340-2134 TELECOMMUNICATIONS 17.91 214.35 250.00 35.65 85.7 34-5340-2141 EQUIPMENT - RENT .00 .00 100.00 100.00 .0 TOTAL PROPERTY SERVICES 804.66 14,613.57 14,850.00 236.43 98.4 PROFESSIONAL SERVICES: 34-5340-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 1,000.00 1,000.00 .0 34-5340-2155 REPAIRS/MAINTENANCE 666.67 5,796.35 11,000.00 5,203.65 52.7 34-5340-2156 MAINTENANCE AGREEMENT .00 3,452.16 5,000.00 1,547.84 69.0 34-5340-2157 INSURANCE .00 .00 1,500.00 1,500.00 .0 34-5340-2158 MISC CONTRACTUAL SERVICES 10,770.37 155,248.34 196,938.04 41,689.70 78.8 34-5340-2166 COLLECTION FEES .00 .00 300.00 300.00 .0 TOTAL PROFESSIONAL SERVICES 11,437.04 164,496.85 215,738.04 51,241.19 76.3 SUPPLIES: 34-5340-3210 OPERATING SUPPLIES 1,117.05 33,457.58 33,500.00 42.42 99.9 34-5340-3220 EQUIPMENT/TOOLS-NON CAPITALIZE .00 349.99 1,000.00 650.01 35.0 34-5340-3235 FUEL 2,133.28 15,763.54 19,000.00 3,236.46 83.0 TOTAL SUPPLIES 3,250.33 49,571.11 53,500.00 3,928.89 92.7 FINANCIAL: 34-5340-4344 DEBT PAYMENT - CAPITAL LEASE .00 58,675.06 58,865.00 189.94 99.7 TOTAL FINANCIAL .00 58,675.06 58,865.00 189.94 99.7 OPERATING TRANSFERS: 34-5340-4347 MANAGEMENT FEES 21,850.75 87,403.00 87,403.00 .00 100.0 TOTAL OPERATING TRANSFERS 21,850.75 87,403.00 87,403.00 .00 100.0 TOTAL LANDFILL 81,537.71 802,717.96 1,445,294.04 642,576.08 55.5 LANDFILL - CAPITAL ---PAGE BREAK--- CITY OF DOUGLAS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 LANDFILL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:34AM PAGE:56 PROFESSIONAL SERVICES: 34-5895-2153 ARCHITECT/ENGINEERING/SURVEY 62,016.28 88,448.23 70,000.00 ( 18,448.23) 126.4 34-5895-2158 MISC CONTRACTUAL SERVICES .00 87,910.64 88,661.96 751.32 99.2 TOTAL PROFESSIONAL SERVICES 62,016.28 176,358.87 158,661.96 ( 17,696.91) 111.2 CAPITALIZED EXPENDITURES: 34-5895-6542 BUILDINGS/IMPROVEMENTS .00 438.50 500.00 61.50 87.7 34-5895-6548 VEHICLES .00 49,148.52 49,500.00 351.48 99.3 TOTAL CAPITALIZED EXPENDITURES .00 49,587.02 50,000.00 412.98 99.2 TOTAL LANDFILL - CAPITAL 62,016.28 225,945.89 208,661.96 ( 17,283.93) 108.3 TOTAL FUND EXPENDITURES 143,553.99 1,028,663.85 1,653,956.00 625,292.15 62.2 NET REVENUE OVER EXPENDITURES ( 80,170.78) ( 329,625.52) ( 933,456.00) ( 603,830.48) ( 35.3) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:34AM PAGE:57 ASSETS CURRENT ASSETS: CASH: 39-10000116 CASH ALLOC FR COMBINED FUND 394,373.62 TOTAL CASH 394,373.62 INVESTMENTS: 39-10000122 TIME DEPOSITS - SHORT TERM 400,746.08 TOTAL INVESTMENTS 400,746.08 ACCOUNTS RECEIVABLE: 39-10000131 ACCOUNTS RECEIVABLE - GENERAL 14,636.65 39-10000132 ACCOUNTS REC - EOY 4,644.78 39-10000139 ACCRUED INTEREST RECEIVABLE 392.05 39-10000156 DUE FROM OTHER FUNDS 55,699.51 TOTAL ACCOUNTS RECEIVABLE 75,372.99 TOTAL CURRENT ASSETS 870,492.69 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 870,492.69 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 39-20000210 IBNR LIABILITY 222,000.00 TOTAL ACCOUNTS PAYABLE 222,000.00 TOTAL CURRENT LIABILITIES 222,000.00 TOTAL LIABILITIES 222,000.00 NET ASSETS CAPITAL ASSETS: 39-30000300 FUND BALANCE/BEGINNING OF YEAR ( 244,648.61) 39-30000301 FUND BALANCE RESERVE 800,000.00 39-30000309 FUND BALANCE RESERVE - OPEB 107,000.00 TOTAL CAPITAL ASSETS 662,351.39 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 EMPLOYEE HEALTH CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:34AM PAGE:58 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD ( 13,858.70) BALANCE - CURRENT DATE 648,492.69 TOTAL NET ASSETS 648,492.69 TOTAL LIABILITIES AND NET ASSETS 870,492.69 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 EMPLOYEE HEALTH CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:34AM PAGE:59 EMPLOYEE HEALTH CARE - REVENUE REVENUE: 39-4390-0110 STOP LOSS REIMBURSEMENTS 24,282.25 362,260.57 275,000.00 ( 87,260.57) 131.7 39-4390-0111 INSURANCE PREMIUMS 32,609.22 381,656.79 480,000.00 98,343.21 79.5 39-4390-0112 INSURANCE ASSESSMENTS 78,104.06 912,761.52 940,000.00 27,238.48 97.1 39-4390-0113 COBRA PAYMENTS 1,358.17 14,835.43 8,250.00 ( 6,585.43) 179.8 39-4390-0120 REFUND .00 4,159.15 4,000.00 ( 159.15) 104.0 TOTAL REVENUE 136,353.70 1,675,673.46 1,707,250.00 31,576.54 98.2 MISC LOCAL REVENUE: 39-4390-1140 INTEREST INCOME 71.28 2,640.02 3,000.00 359.98 88.0 TOTAL MISC LOCAL REVENUE 71.28 2,640.02 3,000.00 359.98 88.0 TOTAL EMPLOYEE HEALTH CARE - REVENUE 136,424.98 1,678,313.48 1,710,250.00 31,936.52 98.1 TOTAL FUND REVENUE 136,424.98 1,678,313.48 1,710,250.00 31,936.52 98.1 EMPLOYEE HEALTH CARE EMPLOYEE BENEFITS: 39-5390-1023 EMPLOYEE - HLTH INS PREM .00 260,795.06 278,400.00 17,604.94 93.7 39-5390-1032 EMPLOYEE BENEFITS - CLAIMS 114,463.87 1,312,938.26 1,200,000.00 ( 112,938.26) 109.4 39-5390-1058 HEALTH CARE - FEE .00 118,438.86 201,600.00 83,161.14 58.8 TOTAL EMPLOYEE BENEFITS 114,463.87 1,692,172.18 1,680,000.00 ( 12,172.18) 100.7 TOTAL EMPLOYEE HEALTH CARE 114,463.87 1,692,172.18 1,680,000.00 ( 12,172.18) 100.7 TOTAL FUND EXPENDITURES 114,463.87 1,692,172.18 1,680,000.00 ( 12,172.18) 100.7 NET REVENUE OVER EXPENDITURES 21,961.11 ( 13,858.70) 30,250.00 44,108.70 ( 45.8) ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 CAPITAL IMP RESERVE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:37AM PAGE:60 ASSETS CURRENT ASSETS: CASH: 40-10000116 CASH ALLOC FR COMBINED FUND 21,219.90 TOTAL CASH 21,219.90 INVESTMENTS: 40-10000122 TIME DEPOSITS - SHORT TERM 310,484.95 TOTAL INVESTMENTS 310,484.95 ACCOUNTS RECEIVABLE: 40-10000139 ACCRUED INTEREST RECEIVABLE 277.86 TOTAL ACCOUNTS RECEIVABLE 277.86 TOTAL CURRENT ASSETS 331,982.71 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 331,982.71 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 40-30000300 FUND BALANCE/BEGINNING OF YEAR 330,643.50 TOTAL CAPITAL ASSETS 330,643.50 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 1,339.21 BALANCE - CURRENT DATE 331,982.71 TOTAL NET ASSETS 331,982.71 TOTAL LIABILITIES AND NET ASSETS 331,982.71 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 CAPITAL IMP RESERVE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:37AM PAGE:61 CAPITAL IMP RESERVE - REVENUE MISC LOCAL REVENUE: 40-4400-1140 INTEREST INCOME 4.78 1,339.21 1,750.00 410.79 76.5 TOTAL MISC LOCAL REVENUE 4.78 1,339.21 1,750.00 410.79 76.5 TOTAL CAPITAL IMP RESERVE - REVENUE 4.78 1,339.21 1,750.00 410.79 76.5 TOTAL FUND REVENUE 4.78 1,339.21 1,750.00 410.79 76.5 NET REVENUE OVER EXPENDITURES 4.78 1,339.21 1,750.00 410.79 76.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:47AM PAGE:62 ASSETS CURRENT ASSETS: CASH: 47-10000116 CASH ALLOC FR COMBINED FUND 488,289.52 TOTAL CASH 488,289.52 INVESTMENTS: 47-10000122 TIME DEPOSITS - SHORT TERM 350,186.52 TOTAL INVESTMENTS 350,186.52 ACCOUNTS RECEIVABLE: 47-10000139 ACCRUED INTEREST RECEIVABLE 98.01 TOTAL ACCOUNTS RECEIVABLE 98.01 TOTAL CURRENT ASSETS 838,574.05 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 838,574.05 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 47-20000201 ALLOCATION FROM AP FUND 28,568.26 TOTAL ACCOUNTS PAYABLE 28,568.26 TOTAL CURRENT LIABILITIES 28,568.26 TOTAL LIABILITIES 28,568.26 NET ASSETS CAPITAL ASSETS: 47-30000300 FUND BALANCE/BEGINNING OF YEAR 285,946.25 47-30000301 FUND BALANCE RESERVE 120,863.87 47-30000306 RESERVE FOR 100,377.00 TOTAL CAPITAL ASSETS 507,187.12 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 GENERAL FUND EQUIPMENT RESERVE FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:47AM PAGE:63 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 302,818.67 BALANCE - CURRENT DATE 810,005.79 TOTAL NET ASSETS 810,005.79 TOTAL LIABILITIES AND NET ASSETS 838,574.05 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 GENERAL FUND EQUIPMENT RESERVE PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:47AM PAGE:64 GENERAL FUND EQUIP RES-REVENUE MISC LOCAL REVENUE: 47-4470-1140 INTEREST INCOME 77.56 1,675.91 1,750.00 74.09 95.8 TOTAL MISC LOCAL REVENUE 77.56 1,675.91 1,750.00 74.09 95.8 TRANSFERS IN: 47-4470-5510 TRANSFER FROM GENERAL FUND 187,500.00 750,000.00 750,000.00 .00 100.0 TOTAL TRANSFERS IN 187,500.00 750,000.00 750,000.00 .00 100.0 TOTAL GENERAL FUND EQUIP RES-REVENUE 187,577.56 751,675.91 751,750.00 74.09 100.0 TOTAL FUND REVENUE 187,577.56 751,675.91 751,750.00 74.09 100.0 GENERAL FUND EQUIPMENT RESERVE CAPITALIZED EXPENDITURES: 47-5470-6547 EQUIPMENT/FURNITURE .00 160,305.56 223,308.00 63,002.44 71.8 47-5470-6548 VEHICLES 28,568.26 288,551.68 383,487.00 94,935.32 75.2 TOTAL CAPITALIZED EXPENDITURES 28,568.26 448,857.24 606,795.00 157,937.76 74.0 TOTAL GENERAL FUND EQUIPMENT RESERVE 28,568.26 448,857.24 606,795.00 157,937.76 74.0 TOTAL FUND EXPENDITURES 28,568.26 448,857.24 606,795.00 157,937.76 74.0 NET REVENUE OVER EXPENDITURES 159,009.30 302,818.67 144,955.00 ( 157,863.67) 208.9 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 CAPITAL PROJ FIRE EQUIP FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:55AM PAGE:65 ASSETS CURRENT ASSETS: CASH: 50-10000116 CASH ALLOC FR COMBINED FUND 38,982.17 TOTAL CASH 38,982.17 INVESTMENTS: 50-10000122 TIME DEPOSITS - SHORT TERM 150,200.38 TOTAL INVESTMENTS 150,200.38 TOTAL CURRENT ASSETS 189,182.55 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 189,182.55 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 50-30000300 FUND BALANCE/BEGINNING OF YEAR ( 27,263.22) 50-30000301 RESERVED FUND BALANCE 155,959.63 TOTAL CAPITAL ASSETS 128,696.41 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 60,486.14 BALANCE - CURRENT DATE 189,182.55 TOTAL NET ASSETS 189,182.55 TOTAL LIABILITIES AND NET ASSETS 189,182.55 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 CAPITAL PROJ FIRE EQUIP FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 08:55AM PAGE:66 FIRE EQUIPMENT - REVENUE MISC LOCAL REVENUE: 50-4500-1140 INTEREST INCOME 205.78 486.14 450.00 ( 36.14) 108.0 TOTAL MISC LOCAL REVENUE 205.78 486.14 450.00 ( 36.14) 108.0 TRANSFERS IN: 50-4500-5510 TRANSFER FROM GENERAL FUND 15,000.00 60,000.00 60,000.00 .00 100.0 TOTAL TRANSFERS IN 15,000.00 60,000.00 60,000.00 .00 100.0 TOTAL FIRE EQUIPMENT - REVENUE 15,205.78 60,486.14 60,450.00 ( 36.14) 100.1 TOTAL FUND REVENUE 15,205.78 60,486.14 60,450.00 ( 36.14) 100.1 FIRE EQUIPMENT CASH FUND APPROPRIATION: 50-5500-0150 REPLACEMENT RESERVE .00 .00 60,000.00 60,000.00 .0 TOTAL CASH FUND APPROP .00 .00 60,000.00 60,000.00 .0 TOTAL FIRE EQUIPMENT .00 .00 60,000.00 60,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 60,000.00 60,000.00 .0 NET REVENUE OVER EXPENDITURES 15,205.78 60,486.14 450.00 ( 60,036.14) 13441.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 CPTL PROJ - CLG PROJECTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:02AM PAGE:67 ASSETS CURRENT ASSETS: CASH: 53-10000116 CASH ALLOC FR COMBINED FUND 2,811.66 TOTAL CASH 2,811.66 TOTAL CURRENT ASSETS 2,811.66 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 2,811.66 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 53-30000300 FUND BALANCE/BEGINNING OF YEAR 2,811.66 TOTAL CAPITAL ASSETS 2,811.66 TOTAL NET ASSETS 2,811.66 TOTAL LIABILITIES AND NET ASSETS 2,811.66 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 TRAIN CAR RESTORATION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:03AM PAGE:68 ASSETS CURRENT ASSETS: CASH: 54-10000116 CASH ALLOC FR COMBINED FUND 57,677.77 TOTAL CASH 57,677.77 TOTAL CURRENT ASSETS 57,677.77 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 57,677.77 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 54-30000300 FUND BALANCE/BEGINNING OF YEAR 37,677.77 TOTAL CAPITAL ASSETS 37,677.77 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 20,000.00 BALANCE - CURRENT DATE 57,677.77 TOTAL NET ASSETS 57,677.77 TOTAL LIABILITIES AND NET ASSETS 57,677.77 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 TRAIN CAR RESTORATION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:03AM PAGE:69 TRAIN CAR RESTORATION TRANSFERS IN: 54-4540-5510 TRANSFER FROM GENERAL FUND 5,000.00 20,000.00 20,000.00 .00 100.0 TOTAL TRANSFERS IN 5,000.00 20,000.00 20,000.00 .00 100.0 TOTAL TRAIN CAR RESTORATION 5,000.00 20,000.00 20,000.00 .00 100.0 TOTAL FUND REVENUE 5,000.00 20,000.00 20,000.00 .00 100.0 TRAIN CAR RESTORATION PROFESSIONAL SERVICES: 54-5540-2155 REPAIRS/MAINTENANCE .00 .00 20,000.00 20,000.00 .0 TOTAL PROFESSIONAL SERVICES .00 .00 20,000.00 20,000.00 .0 TOTAL TRAIN CAR RESTORATION .00 .00 20,000.00 20,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 20,000.00 20,000.00 .0 NET REVENUE OVER EXPENDITURES 5,000.00 20,000.00 .00 ( 20,000.00) .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 POOL IMPROVEMENTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:03AM PAGE:70 ASSETS CURRENT ASSETS: CASH: 55-10000116 CASH ALLOC FR COMBINED FUND 186,656.86 TOTAL CASH 186,656.86 TOTAL CURRENT ASSETS 186,656.86 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 186,656.86 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 55-30000300 FUND BALANCE/BEGINNING OF YEAR 168,584.43 TOTAL CAPITAL ASSETS 168,584.43 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 18,072.43 BALANCE - CURRENT DATE 186,656.86 TOTAL NET ASSETS 186,656.86 TOTAL LIABILITIES AND NET ASSETS 186,656.86 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 POOL IMPROVEMENTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:04AM PAGE:71 POOL IMPROVEMENTS - REVENUE TRANSFERS IN: 55-4550-5510 TRANSFER FROM GENERAL FUND 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL TRANSFERS IN 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL POOL IMPROVEMENTS - REVENUE 12,500.00 50,000.00 50,000.00 .00 100.0 TOTAL FUND REVENUE 12,500.00 50,000.00 50,000.00 .00 100.0 POOL IMPROVEMENTS CAPITALIZED EXPENDITURES: 55-5550-6544 OTHER THAN BLDG .00 31,927.57 35,000.00 3,072.43 91.2 TOTAL CAPITALIZED EXPENDITURES .00 31,927.57 35,000.00 3,072.43 91.2 TOTAL POOL IMPROVEMENTS .00 31,927.57 35,000.00 3,072.43 91.2 TOTAL FUND EXPENDITURES .00 31,927.57 35,000.00 3,072.43 91.2 NET REVENUE OVER EXPENDITURES 12,500.00 18,072.43 15,000.00 ( 3,072.43) 120.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:06AM PAGE:72 ASSETS CURRENT ASSETS: CASH: 56-10000116 CASH ALLOC FR COMBINED FUND 226,779.06 TOTAL CASH 226,779.06 INVESTMENTS: 56-10000122 TIME DEPOSITS - SHORT TERM 7,354,917.76 TOTAL INVESTMENTS 7,354,917.76 ACCOUNTS RECEIVABLE: 56-10000139 ACCRUED INTEREST RECEIVABLE 1,087.80 56-10000156 DUE FROM OTHER FUNDS 14,202.72 TOTAL ACCOUNTS RECEIVABLE 15,290.52 TOTAL CURRENT ASSETS 7,596,987.34 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 7,596,987.34 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 56-20000201 ACCOUNTS PAY ALLOC TO FUNDS 319,750.50 56-20000210 RETAINAGE PAYABLE 10,000.00 TOTAL ACCOUNTS PAYABLE 329,750.50 TOTAL CURRENT LIABILITIES 329,750.50 TOTAL LIABILITIES 329,750.50 NET ASSETS CAPITAL ASSETS: 56-30000300 FUND BALANCE/BEGINNING OF YEAR 4,798,224.95 TOTAL CAPITAL ASSETS 4,798,224.95 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 STREET IMPROVEMENT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:06AM PAGE:73 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,469,011.89 BALANCE - CURRENT DATE 7,267,236.84 TOTAL NET ASSETS 7,267,236.84 TOTAL LIABILITIES AND NET ASSETS 7,596,987.34 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 STREET IMPROVEMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:06AM PAGE:74 STREET IMPROVEMENTS-REVENUE MISC LOCAL REVENUE: 56-4560-1140 INTEREST INCOME 2,052.91 6,862.42 10,000.00 3,137.58 68.6 TOTAL MISC LOCAL REVENUE 2,052.91 6,862.42 10,000.00 3,137.58 68.6 TRANSFERS IN: 56-4560-5510 TRANSFER FROM GENERAL FUND 750,000.00 3,000,000.00 3,000,000.00 .00 100.0 TOTAL TRANSFERS IN 750,000.00 3,000,000.00 3,000,000.00 .00 100.0 TOTAL STREET IMPROVEMENTS-REVENUE 752,052.91 3,006,862.42 3,010,000.00 3,137.58 99.9 TOTAL FUND REVENUE 752,052.91 3,006,862.42 3,010,000.00 3,137.58 99.9 STREET IMPROVEMENTS PROFESSIONAL SERVICES: 56-5560-2153 ARCHITECT/ENGINEERING/SURVEY .00 4,096.04 5,000.00 903.96 81.9 56-5560-2158 MISC CONTRACTUAL SERVICES 116,522.77 153,925.90 165,000.00 11,074.10 93.3 TOTAL PROFESSIONAL SERVICES 116,522.77 158,021.94 170,000.00 11,978.06 93.0 CAPITALIZED EXPENDITURES: 56-5560-6544 OTHER THAN BLDG 213,227.73 379,828.59 1,704,914.00 1,325,085.41 22.3 TOTAL CAPITALIZED EXPENDITURES 213,227.73 379,828.59 1,704,914.00 1,325,085.41 22.3 TOTAL STREET IMPROVEMENTS 329,750.50 537,850.53 1,874,914.00 1,337,063.47 28.7 TOTAL FUND EXPENDITURES 329,750.50 537,850.53 1,874,914.00 1,337,063.47 28.7 NET REVENUE OVER EXPENDITURES 422,302.41 2,469,011.89 1,135,086.00 ( 1,333,925.89) 217.5 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:08AM PAGE:75 ASSETS CURRENT ASSETS: CASH: 57-10000116 CASH ALLOC FR COMBINED FUND 27,709.87 TOTAL CASH 27,709.87 INVESTMENTS: 57-10000122 TIME DEPOSITS - SHORT TERM 5,355,696.55 TOTAL INVESTMENTS 5,355,696.55 ACCOUNTS RECEIVABLE: 57-10000139 ACCRUED INTEREST RECEIVABLE 275.49 TOTAL ACCOUNTS RECEIVABLE 275.49 TOTAL CURRENT ASSETS 5,383,681.91 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 5,383,681.91 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 57-20000201 ALLOCATION FROM AP FUND 1,056,508.04 TOTAL ACCOUNTS PAYABLE 1,056,508.04 TOTAL CURRENT LIABILITIES 1,056,508.04 TOTAL LIABILITIES 1,056,508.04 NET ASSETS CAPITAL ASSETS: 57-30000300 FUND BALANCE/BEGINNING OF YEAR 179,629.01 57-30000305 FUND BALANCE RESERVE-PW FACILI 200,000.00 TOTAL CAPITAL ASSETS 379,629.01 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 CAPITAL IMP -PUBLIC FACILITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:08AM PAGE:76 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 3,947,544.86 BALANCE - CURRENT DATE 4,327,173.87 TOTAL NET ASSETS 4,327,173.87 TOTAL LIABILITIES AND NET ASSETS 5,383,681.91 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 CAPITAL IMP -PUBLIC FACILITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:08AM PAGE:77 CAPITAL IMP - FACILITIES REV MISC LOCAL REVENUE: 57-4570-1140 INTEREST INCOME 4,982.91 6,116.49 5,700.00 ( 416.49) 107.3 TOTAL MISC LOCAL REVENUE 4,982.91 6,116.49 5,700.00 ( 416.49) 107.3 TRANSFERS IN: 57-4570-5510 TRANSFER FROM GENERAL FUND 1,325,000.00 5,300,000.00 5,300,000.00 .00 100.0 TOTAL TRANSFERS IN 1,325,000.00 5,300,000.00 5,300,000.00 .00 100.0 TOTAL CAPITAL IMP - FACILITIES REV 1,329,982.91 5,306,116.49 5,305,700.00 ( 416.49) 100.0 TOTAL FUND REVENUE 1,329,982.91 5,306,116.49 5,305,700.00 ( 416.49) 100.0 CAPITAL IMP -FACILITIES PROFESSIONAL SERVICES: 57-5570-2153 ARCHITECT/ENGINEERING/SURVEY .00 .00 9,000.00 9,000.00 .0 57-5570-2158 MISC CONTRACTUAL SERVICES 1,056,508.04 1,309,665.15 2,000,000.00 690,334.85 65.5 TOTAL PROFESSIONAL SERVICES 1,056,508.04 1,309,665.15 2,009,000.00 699,334.85 65.2 CAPITALIZED EXPENDITURES: 57-5570-6542 BUILDINGS/IMPROVEMENTS .00 44,434.29 59,000.00 14,565.71 75.3 57-5570-6544 OTHER THAN BLDG .00 4,472.19 4,500.00 27.81 99.4 TOTAL CAPITALIZED EXPENDITURES .00 48,906.48 63,500.00 14,593.52 77.0 TOTAL CAPITAL IMP -FACILITIES 1,056,508.04 1,358,571.63 2,072,500.00 713,928.37 65.6 TOTAL FUND EXPENDITURES 1,056,508.04 1,358,571.63 2,072,500.00 713,928.37 65.6 NET REVENUE OVER EXPENDITURES 273,474.87 3,947,544.86 3,233,200.00 ( 714,344.86) 122.1 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:20AM PAGE:78 ASSETS CURRENT ASSETS: CASH: 65-10000116 CASH ALLOC FR COMBINED FUND 251,009.15 TOTAL CASH 251,009.15 INVESTMENTS: 65-10000122 TIME DEPOSITS - SHORT TERM 1,150,560.82 TOTAL INVESTMENTS 1,150,560.82 ACCOUNTS RECEIVABLE: 65-10000139 ACCRUED INTEREST RECEIVABLE 49.01 TOTAL ACCOUNTS RECEIVABLE 49.01 TOTAL CURRENT ASSETS 1,401,618.98 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 1,401,618.98 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 65-20000201 ACCOUNTS PAY ALLOC TO FUNDS 35,817.72 65-20000210 RETAINAGE PAYABLE 27,807.70 TOTAL ACCOUNTS PAYABLE 63,625.42 DUE TO OTHER FUNDS: 65-20000245 DUE TO OTHER FUND 10,588.59 TOTAL DUE TO OTHER FUNDS 10,588.59 TOTAL CURRENT LIABILITIES 74,214.01 TOTAL LIABILITIES 74,214.01 NET ASSETS ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 CAPTL PROJ-PARK FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:20AM PAGE:79 CAPITAL ASSETS: 65-30000300 FUND BALANCE/BEGINNING OF YEAR 494,225.83 65-30000305 FUND BALANCE RESERVE-PICNIC SH 22,915.89 TOTAL CAPITAL ASSETS 517,141.72 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 810,263.25 BALANCE - CURRENT DATE 1,327,404.97 TOTAL NET ASSETS 1,327,404.97 TOTAL LIABILITIES AND NET ASSETS 1,401,618.98 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 CAPTL PROJ-PARK FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:20AM PAGE:80 PARK - REVE MISC LOCAL REVENUE: 65-4650-1140 INTEREST INCOME 467.56 666.39 2,000.00 1,333.61 33.3 TOTAL MISC LOCAL REVENUE 467.56 666.39 2,000.00 1,333.61 33.3 TRANSFERS IN: 65-4650-5510 TRANSFER FROM GENERAL FUND 275,000.00 1,250,000.00 1,250,000.00 .00 100.0 TOTAL TRANSFERS IN 275,000.00 1,250,000.00 1,250,000.00 .00 100.0 TOTAL PARK - REVE 275,467.56 1,250,666.39 1,252,000.00 1,333.61 99.9 TOTAL FUND REVENUE 275,467.56 1,250,666.39 1,252,000.00 1,333.61 99.9 PARK IMPROVEMENTS PROFESSIONAL SERVICES: 65-5650-2153 ARCHITECT, ENG, SURVEY 6,200.00 51,500.00 33,500.00 ( 18,000.00) 153.7 TOTAL PROFESSIONAL SERVICES 6,200.00 51,500.00 33,500.00 ( 18,000.00) 153.7 CAPITALIZED EXPENDITURES: 65-5650-6542 BUILDINGS/IMPROVEMENTS .00 59,689.00 65,000.00 5,311.00 91.8 65-5650-6544 OTHER THAN BLDG 32,878.30 329,214.14 370,000.00 40,785.86 89.0 TOTAL CAPITALIZED EXPENDITURES 32,878.30 388,903.14 435,000.00 46,096.86 89.4 TOTAL PARK IMPROVEMENTS 39,078.30 440,403.14 468,500.00 28,096.86 94.0 TOTAL FUND EXPENDITURES 39,078.30 440,403.14 468,500.00 28,096.86 94.0 NET REVENUE OVER EXPENDITURES 236,389.26 810,263.25 783,500.00 ( 26,763.25) 103.4 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:27AM PAGE:81 ASSETS CURRENT ASSETS: CASH: 90-10000116 CASH ALLOC FR COMBINED FUND 11,956.59 TOTAL CASH 11,956.59 INVESTMENTS: 90-10000120 INVESTMENT POOL 107,047.89 90-10000122 TIME DEPOSITS - SHORT TERM 40,018.65 TOTAL INVESTMENTS 147,066.54 ACCOUNTS RECEIVABLE: 90-10000139 ACCRUED INTEREST RECEIVABLE 27.92 TOTAL ACCOUNTS RECEIVABLE 27.92 TOTAL CURRENT ASSETS 159,051.05 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 159,051.05 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 90-30000300 FUND BALANCE/BEGINNING OF YEAR 14,740.65 TOTAL CAPITAL ASSETS 14,740.65 RESTRICTED ASSETS: 90-30000315 FUND BALANCE RESTRICTED 141,610.40 TOTAL RESTRICTED ASSETS 141,610.40 OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 2,700.00 BALANCE - CURRENT DATE 159,051.05 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 PERPETUAL CARE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:27AM PAGE:82 TOTAL NET ASSETS 159,051.05 TOTAL LIABILITIES AND NET ASSETS 159,051.05 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 PERPETUAL CARE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:27AM PAGE:83 PERPETUAL CARE - REVENUE REVENUE: 90-4900-0156 PROCEEDS FROM LOT SALES 2,000.00 2,700.00 500.00 ( 2,200.00) 540.0 TOTAL REVENUE 2,000.00 2,700.00 500.00 ( 2,200.00) 540.0 MISC LOCAL REVENUE: 90-4900-1140 INTEREST INCOME 50.17 569.60 500.00 ( 69.60) 113.9 TOTAL MISC LOCAL REVENUE 50.17 569.60 500.00 ( 69.60) 113.9 TOTAL PERPETUAL CARE - REVENUE 2,050.17 3,269.60 1,000.00 ( 2,269.60) 327.0 TOTAL FUND REVENUE 2,050.17 3,269.60 1,000.00 ( 2,269.60) 327.0 PERPETUAL CARE TRANSFERS TO OTHER FUNDS: 90-5900-5510 TRANSFER TO GENERAL FUND 198.73 569.60 500.00 ( 69.60) 113.9 TOTAL TRANSFERS TO OTHER FUNDS 198.73 569.60 500.00 ( 69.60) 113.9 TOTAL PERPETUAL CARE 198.73 569.60 500.00 ( 69.60) 113.9 TOTAL FUND EXPENDITURES 198.73 569.60 500.00 ( 69.60) 113.9 NET REVENUE OVER EXPENDITURES 1,851.44 2,700.00 500.00 ( 2,200.00) 540.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 VISABLE MEMORIES MEMORIAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:27AM PAGE:84 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, 2016 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:28AM PAGE:85 ASSETS CURRENT ASSETS: CASH: 92-10000116 CASH ALLOC FR COMBINED FUND 58,693.05 TOTAL CASH 58,693.05 TOTAL CURRENT ASSETS 58,693.05 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 58,693.05 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 92-20000201 ACCOUNTS PAY ALLOC TO FUNDS 1,920.25 TOTAL ACCOUNTS PAYABLE 1,920.25 OTHER PAYABLES: 92-20000405 HISTORIC PRESERVATION-ODD FELL 1,671.98 92-20000406 HISTORIC PRESERVATION 5,100.82 TOTAL OTHER PAYABLES 6,772.80 TOTAL CURRENT LIABILITIES 8,693.05 TOTAL LIABILITIES 8,693.05 NET ASSETS OTHER NET ASSETS: TOTAL OTHER NET ASSETS REVENUE OVER EXPENDITURES - YTD 50,000.00 BALANCE - CURRENT DATE 50,000.00 TOTAL NET ASSETS 50,000.00 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 HISTORIC CMSN FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:28AM PAGE:86 TOTAL LIABILITIES AND NET ASSETS 58,693.05 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 HISTORIC CMSN FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:28AM PAGE:87 HISTORIC CMSN - REVENU TRANSFERS IN: 92-4920-5510 TRANSFER FROM GENERAL FUND 50,000.00 50,000.00 50,000.00 .00 100.0 TOTAL TRANSFERS IN 50,000.00 50,000.00 50,000.00 .00 100.0 TOTAL HISTORIC CMSN - REVENU 50,000.00 50,000.00 50,000.00 .00 100.0 TOTAL FUND REVENUE 50,000.00 50,000.00 50,000.00 .00 100.0 NET REVENUE OVER EXPENDITURES 50,000.00 50,000.00 50,000.00 .00 100.0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:29AM PAGE:88 ASSETS CURRENT ASSETS: CASH: 96-10000116 CASH ALLOC FR COMBINED FUND 21,409.85 TOTAL CASH 21,409.85 INVESTMENTS: 96-10000122 TIME DEPOSITS - SHORT TERM 55,027.98 TOTAL INVESTMENTS 55,027.98 ACCOUNTS RECEIVABLE: 96-10000139 ACCRUED INTEREST RECEIVABLE 38.86 TOTAL ACCOUNTS RECEIVABLE 38.86 TOTAL CURRENT ASSETS 76,476.69 TOTAL NON-CURRENT ASSETS .00 TOTAL ASSETS 76,476.69 LIABILITIES AND EQUITY LIABILITIES CURRENT LIABILITIES: ACCOUNTS PAYABLE: 96-20000201 ALLOCATION FROM AP FUND 209.89 TOTAL ACCOUNTS PAYABLE 209.89 UTILITY DEPOSITS PAYABLE: 96-20000229 UTILITY DEPOSITS 69,138.55 TOTAL UTILITY DEPOSITS PAYABLE 69,138.55 TOTAL CURRENT LIABILITIES 69,348.44 TOTAL LIABILITIES 69,348.44 NET ASSETS CAPITAL ASSETS: 96-30000300 FUND BALANCE/BEGINNING OF YEAR 7,128.25 TOTAL CAPITAL ASSETS 7,128.25 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 UTILITY DEPOSIT FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:29AM PAGE:89 TOTAL NET ASSETS 7,128.25 TOTAL LIABILITIES AND NET ASSETS 76,476.69 ---PAGE BREAK--- CITY OF DOUGLAS REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING JUNE 30, 2016 UTILITY DEPOSIT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:29AM PAGE:90 UTILITY DEPOSITS - REVENUE MISC LOCAL REVENUE: 96-4960-1140 INTEREST INCOME .00 240.44 200.00 ( 40.44) 120.2 TOTAL MISC LOCAL REVENUE .00 240.44 200.00 ( 40.44) 120.2 TOTAL UTILITY DEPOSITS - REVENUE .00 240.44 200.00 ( 40.44) 120.2 TOTAL FUND REVENUE .00 240.44 200.00 ( 40.44) 120.2 UTILITY DEPOSIT TRANSFERS TO OTHER FUNDS: 96-5960-5531 TRANSFER TO WATER 44.53 240.44 200.00 ( 40.44) 120.2 TOTAL TRANSFERS TO OTHER FUNDS 44.53 240.44 200.00 ( 40.44) 120.2 TOTAL UTILITY DEPOSIT 44.53 240.44 200.00 ( 40.44) 120.2 TOTAL FUND EXPENDITURES 44.53 240.44 200.00 ( 40.44) 120.2 NET REVENUE OVER EXPENDITURES ( 44.53) .00 .00 .00 .0 ---PAGE BREAK--- CITY OF DOUGLAS BALANCE SHEET JUNE 30, 2016 DEFERRED COMP TRUST FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 08/18/2016 09:29AM PAGE:91 ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS: INVESTMENTS: 97-10000173 SECURITIES - LONG TERM 4,080,434.15 97-10000174 INVESTMENTS - RHSA 363,434.36 TOTAL INVESTMENTS 4,443,868.51 TOTAL NON-CURRENT ASSETS 4,443,868.51 TOTAL ASSETS 4,443,868.51 LIABILITIES AND EQUITY LIABILITIES NET ASSETS CAPITAL ASSETS: 97-30000300 FUND BALANCE/BEGINNING OF YEAR 4,443,868.51 TOTAL CAPITAL ASSETS 4,443,868.51 TOTAL NET ASSETS 4,443,868.51 TOTAL LIABILITIES AND NET ASSETS 4,443,868.51