Full Text
TOWN OF MONUMENT COMBINED CASH INVESTMENT JUNE 30, 2018 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 1 COMBINED CASH ACCOUNTS 99-00-10200 WELLS FARGO OPERATING ACCOUNT 426,621.00 99-00-10203 PEOPLES BANK CD #10200 104,368.57 99-00-10204 PEOPLES BANK CD #10224 101,339.13 99-00-10205 FIRST NATIONAL BANK CD 102,767.59 99-00-10421 COLOTRUST GENERAL FUND 98,969.37 TOTAL COMBINED CASH 834,065.66 99-00-10100 CASH ALLOCATED TO OTHER FUNDS ( 834,065.66) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 483,931.13 2 ALLOCATION TO CAPITAL PROJECTS FUND 90,833.92 4 ALLOCATION TO 2A WATER ASD FUND 259,871.71 5 ALLOCATION TO DEBT SERVICE FUND 12,931.57 82 ALLOCATION TO CONSERVATION TRUST FUND ( 13,502.67) TOTAL ALLOCATIONS TO OTHER FUNDS 834,065.66 ALLOCATION FROM COMBINED CASH FUND - 99-0010100 ( 834,065.66) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 2 ASSETS 01-00-10100 CASH IN COMBINED CASH FUND 483,931.13 01-00-10104 PETTY CASH FUNDS - LAW ENFORCE 600.00 01-00-10106 PETTY CASH FUNDS - ADMIN 999.91 01-00-10107 PETTY CASH-PW-SCRAP METAL 111.31 01-00-10202 WELLS FARGO CAFETERIA PLAN ACC 22,315.76 01-00-10420 COLOTRUST BONDS PAYABLE 293,703.04 01-00-10422 SANTA ON PATROL DONATIONS 9,014.70 01-00-10425 WELLS FARGO ESCROW FOR CL#405 94,166.58 01-00-10426 COLOTRUST DOJ SEIZURE PD 88.74 01-00-10750 A/R PAYROLL 687.84 01-00-11700 FRANCHISE FEES RECEIVABLE 84,888.11 01-00-11900 TAXES RECEIVABLE - PROPERTY 893,834.00 01-00-11950 DUE FROM OTHER GOVERNMENTS 1,245,562.44 01-00-15001 PREPAID RECORDING FEES 2,417.53 01-00-16000 ABATEMENTS RECEIVABLE 1,904.73 TOTAL ASSETS 3,134,225.82 LIABILITIES AND EQUITY LIABILITIES 01-00-20200 ACCOUNTS PAYABLE 19,032.99 01-00-20204 DONATIONS TO PW BUIDLING 10.00 01-00-20205 ACCOUNTS PAYABLE TRI-VIEW 362,649.86 01-00-20214 SANTA ON PATROL DONATIONS 6,605.87 01-00-20215 DOJ PAYMENTS 84.26 01-00-21710 WAGES PAYABLE 53,848.33 01-00-21711 FEDERAL W/H PAYABLE 1,301.42 01-00-21712 STATE W/H PAYABLE 103.00 01-00-21713 FICA PAYABLE 3,578.59 01-00-21715 SUTA PAYABLE 3,250.55 01-00-21716 MEDICARE PAYABLE 767.18 01-00-21740 RETIREMENT - FPPA PAYABLE 15,667.77 01-00-21742 RETIREMENT-VALIC/ICMA PAYABLE 1,841.49 01-00-21743 LIFE/DISABILITY INSURANCE - ST 2,521.15 01-00-21745 OUTSTANDING JUDGMENT WARRANTS 766.00 01-00-21746 BRAIN TRAUMA STATE FEES PAYABL ( 285.00) 01-00-21751 HEALTH/DENTAL INSURANCE - BENE ( 4,269.28) 01-00-21780 OTHER W/H PAYABLE 77.80 01-00-21785 DEPOSITS FOR PARK RESERVATION 225.00 01-00-24243 MVE/TMD BORDER FENCE DEPOSIT 250,000.00 01-00-24244 LEWIS PALMER SD#38 PAYABLE 67,386.00 01-00-24245 PLANNING RETAINER PAYABLE 33,376.01 01-00-24247 CASH-IN-LIEU FOR PARKS 7,068.60 01-00-24250 PLANNING BONDS PAYABLE 265,366.75 01-00-24252 ROAD REPAIR BOND VCMD 26,500.00 01-00-24260 DEFERRED REVENUE 893,834.00 TOTAL LIABILITIES 2,011,308.34 FUND EQUITY ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 3 01-00-30000 BEGINNING FUND BALANCE - GENER 674,854.36 01-00-30020 RESERVED GENERAL FUND BALANCE 99,445.00 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 348,618.12 BALANCE - CURRENT DATE 348,618.12 TOTAL FUND EQUITY 1,122,917.48 TOTAL LIABILITIES AND EQUITY 3,134,225.82 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 4 PUBLIC WORKS 01-30-40020 GRAVE OPENING & CLOSING 350.00 1,550.00 3,500.00 1,950.00 44.3 01-30-40030 PLOT SALES 3,200.00 8,700.00 10,000.00 1,300.00 87.0 01-30-40341 PW - PARK RESERVATION FEES 335.00 9,497.50 20,000.00 10,502.50 47.5 01-30-40430 HWY USER'S TAX FUND 17,500.00 111,818.88 235,389.00 123,570.12 47.5 01-30-40450 ROAD & BRIDGE 12,209.83 22,848.72 21,500.00 ( 1,348.72) 106.3 01-30-48020 GRANT REVENUE .00 6,486.96 .00 ( 6,486.96) .0 TOTAL PUBLIC WORKS 33,594.83 160,902.06 290,389.00 129,486.94 55.4 ADMINISTRATIVE AND LEGISLATIVE 01-45-40060 INTEREST & INVESTMENT INCOME 1,648.33 7,231.07 3,505.00 ( 3,726.07) 206.3 01-45-40110 GENERAL PROPERTY TAX 232,517.92 870,710.89 837,620.00 ( 33,090.89) 104.0 01-45-40115 SPECIFIC OWNERSHIP TAXES 8,968.14 52,534.19 101,105.00 48,570.81 52.0 01-45-40120 SALES TAX - GENERAL 246,626.23 1,040,831.92 2,428,364.00 1,387,532.08 42.9 01-45-40124 SALES TAX - AUTO 26,447.04 180,876.57 300,000.00 119,123.43 60.3 01-45-40126 SEVERANCE TAX FUND DIST .00 .00 500.00 500.00 .0 01-45-40127 FEDERAL MINERAL LEASE FUND DIS .00 .00 900.00 900.00 .0 01-45-40141 FRANCHISE FEE-MT VIEW ELEC 48,490.39 121,004.18 248,186.00 127,181.82 48.8 01-45-40143 FRANCHISE FEE - BLACK HILLS UT 16,531.76 47,642.35 90,846.00 43,203.65 52.4 01-45-40147 FRANCHISE FEE - CENTURY LINK 1,679.84 8,796.56 25,000.00 16,203.44 35.2 01-45-40149 ADMINISTRATIVE FEE-WATER FUND 5,803.75 34,822.50 72,195.00 37,372.50 48.2 01-45-40150 FRANCHISE FEE- COMCAST 8,292.40 34,532.27 30,000.00 ( 4,532.27) 115.1 01-45-40151 PAYMENT IN LIEU OF FF 8,594.47 51,566.82 103,136.00 51,569.18 50.0 01-45-40210 LIQUOR LICENSE 708.75 5,238.75 5,700.00 461.25 91.9 01-45-40320 SALE OF COPIES & ORDINANCES .00 90.00 100.00 10.00 90.0 01-45-40400 MOTOR VEHICLE REGISTRATION 2,710.50 15,452.50 46,500.00 31,047.50 33.2 01-45-40410 TOBACCO PRODUCTS TAX 1,800.00 10,513.34 7,000.00 ( 3,513.34) 150.2 TOTAL ADMINISTRATIVE AND LEGISLATIVE 610,819.52 2,481,843.91 4,300,657.00 1,818,813.09 57.7 COURT 01-46-40510 COURT COLLECTIONS & FEES 1,673.00 12,377.00 60,000.00 47,623.00 20.6 01-46-40515 COURT BONDS .00 2.00 100.00 98.00 2.0 01-46-40620 TRAFFIC SAFETY INCOME 1,155.00 15,170.00 55,000.00 39,830.00 27.6 TOTAL COURT 2,828.00 27,549.00 115,100.00 87,551.00 23.9 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 5 PLANNING DEPARTMENT 01-49-40130 USE TAX 39,653.07 244,327.45 584,260.00 339,932.55 41.8 01-49-40230 LAND USE PERMITS 2,950.00 18,775.00 40,380.00 21,605.00 46.5 01-49-40240 FENCE PERMITS 194.20 1,239.92 3,000.00 1,760.08 41.3 01-49-40245 LANDSCAPE PERMITS 600.00 5,170.00 7,200.00 2,030.00 71.8 01-49-40250 SIDEWALK PERMITS .00 15.00 .00 ( 15.00) .0 01-49-40255 RIGHT OF WAY PERMITS 100.00 800.00 .00 ( 800.00) .0 01-49-40260 TEMPORARY USE PERMIT 50.00 300.00 500.00 200.00 60.0 01-49-40265 LAKE USE PERMITS .00 500.00 1,000.00 500.00 50.0 01-49-40270 SIGN PERMITS .00 1,525.00 2,000.00 475.00 76.3 01-49-40310 PLANNING FEES 8,751.16 32,554.16 43,830.00 11,275.84 74.3 01-49-40311 ENG REV/INSP FEES 2,395.00 12,100.00 45,000.00 32,900.00 26.9 01-49-40350 CODE ENFORCEMENT FEES .00 .00 300.00 300.00 .0 01-49-41050 INFRASTSRUCTURE FEE-TRIVIEW 6,500.00 34,000.00 50,000.00 16,000.00 68.0 TOTAL PLANNING DEPARTMENT 61,193.43 351,306.53 777,470.00 426,163.47 45.2 LAW ENFORCEMENT 01-51-40350 FEES FOR SERVICE 1,466.75 7,299.55 10,000.00 2,700.45 73.0 TOTAL LAW ENFORCEMENT 1,466.75 7,299.55 10,000.00 2,700.45 73.0 TOTAL FUND REVENUE 709,902.53 3,028,901.05 5,493,616.00 2,464,714.95 55.1 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 6 PUBLIC WORKS 01-30-60000 SALARIES 36,423.71 327,546.59 766,508.00 438,961.41 42.7 01-30-60010 OVERTIME PAY 1,649.88 8,423.82 25,000.00 16,576.18 33.7 01-30-60019 LONGEVITY RECOGNITION 1,000.00 1,000.00 1,000.00 .00 100.0 01-30-60020 ON-CALL/STANDBY PAY .00 4,550.00 10,000.00 5,450.00 45.5 01-30-60071 STATE UNEMPLOYMENT TAXES 197.65 1,130.68 2,300.00 1,169.32 49.2 01-30-60080 HEALTH & DENTAL INSURANCE .00 63,517.46 166,912.00 103,394.54 38.1 01-30-60085 LIFE & DISABILITY INSURANCE .00 4,319.97 9,258.00 4,938.03 46.7 01-30-60092 EMPLOYER'S 457 1,737.45 12,521.13 38,325.00 25,803.87 32.7 01-30-60093 EMPLOYER'S FICA 3,971.62 22,079.79 47,523.00 25,443.21 46.5 01-30-60094 EMPLOYER'S MEDICARE 928.85 5,163.81 11,114.00 5,950.19 46.5 01-30-60095 PAYROLL & BANK FEES 52.91 348.71 625.00 276.29 55.8 01-30-60098 STAFF TUITITION 251.47 528.34 3,500.00 2,971.66 15.1 01-30-60100 WORKMANS COMP INS DEDUCTIBLE 598.00 1,598.00 500.00 ( 1,098.00) 319.6 01-30-60130 GENERAL INSURANCE DEDUCTIBLE ( 186.02) 9,947.98 .00 ( 9,947.98) .0 01-30-60135 DRUG/ALCOHOL TESTING 714.25 1,035.80 1,000.00 ( 35.80) 103.6 01-30-60200 SAFETY EQUIPMENT 931.40 5,285.84 6,000.00 714.16 88.1 01-30-60210 UNIFORMS .00 1,764.39 4,300.00 2,535.61 41.0 01-30-60229 SUPPLIES - SHOP OPERATIONS 468.30 2,839.66 7,500.00 4,660.34 37.9 01-30-60231 SUPPLIES-OPERATIONS 624.93 3,061.14 8,000.00 4,938.86 38.3 01-30-60233 SUMMER YOUTH PROGRAM EXPENSES 25,000.00 25,000.00 25,000.00 .00 100.0 01-30-60245 STORAGE UNIT #724 650.00 650.00 1,300.00 650.00 50.0 01-30-60260 DUES AND SUBSCRIPTIONS .00 240.00 2,000.00 1,760.00 12.0 01-30-60300 PUBLIC/LEGAL NOTICES .00 .00 500.00 500.00 .0 01-30-60341 UTILITIES - ELECTRIC 3,580.54 21,412.70 32,800.00 11,387.30 65.3 01-30-60342 UTILITIES - GAS 414.94 2,804.26 7,300.00 4,495.74 38.4 01-30-60343 UTILITIES - SANITATION 140.00 875.00 2,000.00 1,125.00 43.8 01-30-60345 UTILITIES - TELEPHONE 1,440.07 6,082.35 12,000.00 5,917.65 50.7 01-30-60350 UTILITIES - TRASH PICKUP 378.00 2,156.50 4,500.00 2,343.50 47.9 01-30-60385 SMALL TOOLS 162.40 855.81 2,500.00 1,644.19 34.2 01-30-60386 SHOP TOOLS .00 636.20 3,000.00 2,363.80 21.2 01-30-60387 SALT/SAND .00 4,161.94 15,000.00 10,838.06 27.8 01-30-60610 FUEL 2,862.68 10,353.22 22,000.00 11,646.78 47.1 01-30-60770 TRAVEL,TRAINING,MEETINGS 1,629.20 4,363.48 8,000.00 3,636.52 54.5 01-30-61085 PURCHASED SERVICES - PORT-A-LE 795.00 3,220.00 9,000.00 5,780.00 35.8 01-30-62000 REPAIR & MAINTENANCE - PARKS 13,396.85 36,036.29 70,000.00 33,963.71 51.5 01-30-65375 RENTAL MACHINERY & EQUIPMENT 41.44 2,148.48 3,000.00 851.52 71.6 01-30-65387 GPS TRACKING 821.04 3,273.74 .00 ( 3,273.74) .0 01-30-65390 REPAIR & MAINTENANCE - VEHICLE ( 7,184.92) 14,976.94 50,000.00 35,023.06 30.0 01-30-65395 REPAIR & MAINTENANCE - EQUIPME 2,683.51 15,630.82 50,000.00 34,369.18 31.3 01-30-65396 MOSQUITO CONTROL PROGRAM 3,068.00 6,136.00 11,800.00 5,664.00 52.0 01-30-65399 CURB, GUTTER AND SIDEWALKS .00 .00 35,000.00 35,000.00 .0 01-30-65400 REPAIR & MAINT - STREETS 1,995.66 10,210.37 30,000.00 19,789.63 34.0 01-30-65450 REPAIRS & MAINTENANCE - BUILDI 1,758.04 7,945.84 17,500.00 9,554.16 45.4 01-30-65451 OLD TOWN HALL ROOF REPAIRS .00 6,402.60 23,000.00 16,597.40 27.8 01-30-65695 REPAIRS & MAINTENANCE - CEMTRY 35.00 2,230.46 2,500.00 269.54 89.2 01-30-65710 PROFESSIONAL SERVICES 160.00 2,588.75 6,000.00 3,411.25 43.2 01-30-65730 CEMETERY MEMORIAL DAY EVENT .00 .00 500.00 500.00 .0 01-30-66002 ASPHALT REPAIRS .00 2,222.83 250,000.00 247,777.17 .9 01-30-66061 DIRTY WOMAN PARK BLEACHERS .00 .00 6,000.00 6,000.00 .0 01-30-66071 PORTABLE TOWER LIGHTS .00 .00 10,000.00 10,000.00 .0 01-30-66072 HEAVY EQUIPMENT TIRES .00 .00 12,000.00 12,000.00 .0 01-30-66073 SHOULDERING ATTACHMENT .00 .00 9,500.00 9,500.00 .0 01-30-66078 LAVALETT 8' 4 SEAT SWING .00 .00 1,500.00 1,500.00 .0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 7 01-30-66079 LIMBACH - 8' 4 SEAT SWING .00 .00 1,500.00 1,500.00 .0 01-30-66080 LIMBACH - 8' MERRY GO ROUND .00 .00 2,800.00 2,800.00 .0 01-30-66081 LIMBACH - 8' SLIDE .00 .00 7,000.00 7,000.00 .0 01-30-66082 WALK BEHIND AERATOR 19" .00 2,399.16 3,100.00 700.84 77.4 01-30-66083 WALK BEHIND SOD CUTTER 18" .00 .00 4,500.00 4,500.00 .0 01-30-66084 BRUSH CUTTER .00 .00 4,975.00 4,975.00 .0 01-30-66085 HEAVY DUTY SHELVES .00 .00 3,500.00 3,500.00 .0 01-30-66086 AIR COMPRESSOR FOR FACILITIES .00 .00 2,000.00 2,000.00 .0 01-30-66087 AC RECOVERY UNIT .00 .00 4,000.00 4,000.00 .0 01-30-68357 CONSERVATION PLAN REBATES .00 .00 2,000.00 2,000.00 .0 TOTAL PUBLIC WORKS 103,191.85 671,676.85 1,879,940.00 1,208,263.15 35.7 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 8 ADMINISTRATIVE AND LEGISLATIVE 01-45-60000 SALARIES 87,233.07 361,995.56 628,199.00 266,203.44 57.6 01-45-60005 COMPENSATED ABSENCES 107,770.92 107,770.92 .00 ( 107,770.92) .0 01-45-60010 OVERTIME PAY 953.36 6,491.34 10,000.00 3,508.66 64.9 01-45-60011 TM EMPLOYEE PFP POOL 25,800.00 25,800.00 25,800.00 .00 100.0 01-45-60020 LONGEVITY RECOGNITION 1,500.00 1,500.00 1,500.00 .00 100.0 01-45-60071 STATE UNEMPLOYMENT TAXES 280.21 1,120.90 1,990.00 869.10 56.3 01-45-60080 HEALTH & DENTAL INSURANCE ( 1,497.34) 46,351.66 127,708.00 81,356.34 36.3 01-45-60085 LIFE & DISABILITY INSURANCE .00 3,862.02 8,472.00 4,609.98 45.6 01-45-60090 STAFF APPRECIATION 1,227.22 1,401.40 2,500.00 1,098.60 56.1 01-45-60092 EMPLOYER'S 457 2,119.73 14,564.04 33,160.00 18,595.96 43.9 01-45-60093 EMPLOYER'S FICA 5,355.84 21,498.00 41,118.00 19,620.00 52.3 01-45-60094 EMPLOYER'S MEDICARE 1,327.52 5,102.77 9,617.00 4,514.23 53.1 01-45-60095 BANK & PAYROLL FEES ( 654.46) 4,043.48 8,000.00 3,956.52 50.5 01-45-60098 STAFF TUITION .00 21.43 3,000.00 2,978.57 .7 01-45-60100 WORKERS COMPENSATION INSURANCE 5,579.98 33,479.88 75,000.00 41,520.12 44.6 01-45-60130 GENERAL INSURANCE ( 12,782.87) 20,691.68 100,000.00 79,308.32 20.7 01-45-60133 2018 WAGE STUDY .00 .00 25,000.00 25,000.00 .0 01-45-60145 CONTRACT LABOR-JANITORIAL 901.25 5,407.50 10,000.00 4,592.50 54.1 01-45-60230 SUPPLIES - OFFICE/OPERATIONS 1,115.08 5,734.07 10,000.00 4,265.93 57.3 01-45-60231 FURNITURE, FIXTURES & EQUIP .00 827.00 2,500.00 1,673.00 33.1 01-45-60240 POSTAGE 1,080.23 1,704.60 5,000.00 3,295.40 34.1 01-45-60245 STORAGE UNIT-ADMINISTRATION ( 392.00) 640.00 1,800.00 1,160.00 35.6 01-45-60254 ELECTION EXPENSE 7,390.77 9,740.62 15,000.00 5,259.38 64.9 01-45-60260 DUES AND SUBSCRIPTIONS 103.00 7,427.47 20,000.00 12,572.53 37.1 01-45-60300 PUBLIC/LEGAL NOTICES 42.00 186.41 1,000.00 813.59 18.6 01-45-60305 LEGAL SERVICES 200.00 1,073.00 40,000.00 38,927.00 2.7 01-45-60341 UTILITIES - ELECTRIC 846.47 5,513.62 10,850.00 5,336.38 50.8 01-45-60342 UTILITIES - GAS 161.44 2,215.36 4,500.00 2,284.64 49.2 01-45-60343 UTILITIES - SANITATION 52.72 334.02 1,000.00 665.98 33.4 01-45-60345 UTILITIES - TELEPHONE 1,289.65 9,305.77 17,000.00 7,694.23 54.7 01-45-60350 UTILITIES - TRASH PICKUP 52.00 286.00 650.00 364.00 44.0 01-45-60360 UTILITIES - WATER SERVICE USED 6,511.97 14,007.10 40,000.00 25,992.90 35.0 01-45-60430 TTM - BOARD OF TRUSTEES 593.72 2,500.00 2,500.00 .00 100.0 01-45-60610 FUEL .00 .00 2,000.00 2,000.00 .0 01-45-60750 ACCOUNTING/AUDIT SERVICES .00 .00 9,000.00 9,000.00 .0 01-45-60770 TRAVEL,TRAINING & MEETINGS 3,676.47 15,418.95 30,000.00 14,581.05 51.4 01-45-60772 EMPLOYEE MILEAGE-TM .00 .00 1,200.00 1,200.00 .0 01-45-63000 TRIVIEW PROPERTY TAX PAYABLE .00 .00 243,115.00 243,115.00 .0 01-45-64000 TAX COLLECTION EXPENSE 3,723.39 17,851.15 30,000.00 12,148.85 59.5 01-45-65660 REPAIR & MAINTENANCE - COMPUTE 7,017.00 33,921.00 65,000.00 31,079.00 52.2 01-45-65661 COMPUTER LICENSES & SOFTWARE 17,191.50 29,484.70 25,000.00 ( 4,484.70) 117.9 01-45-65662 WEBMASTER MAINTENANCE .00 241.25 8,000.00 7,758.75 3.0 01-45-65665 REPAIR & MAINTENANCE - COPIER 1,521.96 9,633.17 9,000.00 ( 633.17) 107.0 01-45-65710 PROFESSIONAL CONSULTING 1,866.00 11,795.50 20,000.00 8,204.50 59.0 01-45-65711 EDC & COMMUNITY DEVELOPMENT .00 .00 5,000.00 5,000.00 .0 01-45-65712 PURCHASED SERVICES - ANIMAL CO 1,362.75 8,176.50 20,000.00 11,823.50 40.9 01-45-65883 TRI-LAKES CARES 5,000.00 5,000.00 5,000.00 .00 100.0 01-45-65885 TRI LAKES VIEWS ( 5,000.00) 5,000.00 5,000.00 .00 100.0 01-45-65996 CONTINGENCY .00 .00 5,000.00 5,000.00 .0 01-45-65998 TRI-LAKES SILVER ALLIANCE .00 12,000.00 12,000.00 .00 100.0 TOTAL ADMINISTRATIVE AND LEGISLATIVE 280,520.55 871,119.84 1,777,179.00 906,059.16 49.0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 9 COURT 01-46-60000 SALARIES 3,280.33 19,681.98 39,634.00 19,952.02 49.7 01-46-60010 OVERTIME PAY 100.00 600.00 1,200.00 600.00 50.0 01-46-60071 STATE UNEMPLOYMENT TAXES 12.92 77.52 155.00 77.48 50.0 01-46-60080 HEALTH & DENTAL INSURANCE 745.83 4,474.98 8,950.00 4,475.02 50.0 01-46-60085 LIFE & DISABILITY INSURANCE 50.00 300.00 600.00 300.00 50.0 01-46-60092 EMPLOYER'S 457 215.17 1,291.02 2,582.00 1,290.98 50.0 01-46-60093 EMPLOYER'S FICA 266.75 1,600.50 3,201.00 1,600.50 50.0 01-46-60094 EMPLOYER'S MEDICARE 62.42 374.52 749.00 374.48 50.0 01-46-60230 SUPPLIES - OFFICE/OPERATIONS .00 78.22 100.00 21.78 78.2 01-46-60240 POSTAGE .00 .00 100.00 100.00 .0 01-46-60260 DUES AND SUBSCRIPTIONS 32.99 32.99 .00 ( 32.99) .0 01-46-65701 WARRANT/JAIL COST .00 .00 100.00 100.00 .0 01-46-65715 MUNICIPAL COURT JUDGE 500.00 3,000.00 6,000.00 3,000.00 50.0 01-46-65717 PROSECUTING ATTORNEY 1,000.00 6,000.00 12,000.00 6,000.00 50.0 TOTAL COURT 6,266.41 37,511.73 75,371.00 37,859.27 49.8 PLANNING DEPARTMENT 01-49-60000 SALARIES 21,875.79 143,045.09 282,089.00 139,043.91 50.7 01-49-60010 OVERTIME PAY 824.62 4,770.64 3,500.00 ( 1,270.64) 136.3 01-49-60071 STATE UNEMPLOYMENT TAXES 68.43 443.75 846.00 402.25 52.5 01-49-60080 HEALTH & DENTAL INSURANCE .00 21,885.12 53,529.00 31,643.88 40.9 01-49-60085 LIFE & DISABILITY INSURANCE .00 1,754.10 3,535.00 1,780.90 49.6 01-49-60092 EMPLOYER'S 457 1,140.61 7,396.34 14,104.00 6,707.66 52.4 01-49-60093 EMPLOYER'S FICA 1,333.46 8,208.80 17,490.00 9,281.20 46.9 01-49-60094 EMPLOYER'S MEDICARE 311.86 1,919.80 4,090.00 2,170.20 46.9 01-49-60095 PAYROLL & BANK FEES 34.11 204.66 500.00 295.34 40.9 01-49-60098 STAFF TUITITION .00 569.51 1,000.00 430.49 57.0 01-49-60099 CODE ENFORCEMENT CONTRACT 1,312.00 8,141.65 19,000.00 10,858.35 42.9 01-49-60230 SUPPLIES - OFFICE/OPERATIONAL 95.63 1,196.64 2,300.00 1,103.36 52.0 01-49-60237 COPIES AND PHOTOS .00 .25 200.00 199.75 .1 01-49-60240 POSTAGE .68 39.24 200.00 160.76 19.6 01-49-60245 STORAGE UNIT RENTAL FEES 150.00 750.00 1,800.00 1,050.00 41.7 01-49-60260 DUES AND SUBSCRIPTIONS .00 450.00 1,500.00 1,050.00 30.0 01-49-60300 PUBLIC/LEGAL NOTICES .02 .02 750.00 749.98 .0 01-49-60305 LEGAL SERVICES ( 14.40) .00 10,000.00 10,000.00 .0 01-49-60345 UTILITIES - TELEPHONE 222.44 1,677.06 5,000.00 3,322.94 33.5 01-49-60610 FUEL 164.67 765.18 2,000.00 1,234.82 38.3 01-49-60770 TRAVEL,TRAINING & MEETINGS 175.42 5,422.80 9,000.00 3,577.20 60.3 01-49-65710 PROFESSIONAL SERVICES .00 258.00 15,000.00 14,742.00 1.7 01-49-65711 GIS SERVICES .00 1,443.41 2,000.00 556.59 72.2 01-49-68355 CAPITAL LEASE FOR PLOTTER ( 563.91) 3,923.41 7,200.00 3,276.59 54.5 01-49-68356 CAPITAL LEASE INTEREST ( 155.88) .00 2,000.00 2,000.00 .0 TOTAL PLANNING DEPARTMENT 26,975.55 214,265.47 458,633.00 244,367.53 46.7 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 10 LAW ENFORCEMENT 01-51-60000 SALARIES 79,803.22 569,402.14 1,188,131.00 618,728.86 47.9 01-51-60010 OVERTIME PAY 7,346.76 49,134.56 25,000.00 ( 24,134.56) 196.5 01-51-60020 LONGEVITY RECOGNITION 2,000.00 2,000.00 2,000.00 .00 100.0 01-51-60071 STATE UNEMPLOYMENT TAXES 264.68 1,851.30 3,564.00 1,712.70 51.9 01-51-60080 HEALTH & DENTAL INSURANCE ( 745.83) 79,102.78 208,257.00 129,154.22 38.0 01-51-60084 FPPA FOR D&D .00 .00 25,745.00 25,745.00 .0 01-51-60085 LIFE & DISABILITY INSURANCE ( 50.00) 6,528.47 3,496.00 ( 3,032.47) 186.7 01-51-60091 FPPA FOR RETIREMENT 2,863.30 6,532.51 38,023.00 31,490.49 17.2 01-51-60092 EMPLOYER'S 457 877.84 22,355.97 16,178.00 ( 6,177.97) 138.2 01-51-60093 EMPLOYER'S FICA 5,285.17 35,846.32 73,664.00 37,817.68 48.7 01-51-60094 EMPLOYER'S MEDICARE 1,236.02 8,383.18 17,228.00 8,844.82 48.7 01-51-60095 PAYROLL & BANK FEES 59.17 355.02 650.00 294.98 54.6 01-51-60098 STAFF TUITITION .00 .00 2,000.00 2,000.00 .0 01-51-60100 WORKERS COMPENSATION INSURANCE 600.00 2,038.64 1,500.00 ( 538.64) 135.9 01-51-60135 DRUG/ALCOHOL TESTING 255.00 1,814.63 3,000.00 1,185.37 60.5 01-51-60145 CONTRACT LABOR JANITORIAL SVC 901.25 5,407.50 10,000.00 4,592.50 54.1 01-51-60147 COLORADO MOUNTED RANGERS .00 .00 1,500.00 1,500.00 .0 01-51-60210 UNIFORMS 1,454.99 8,561.90 9,500.00 938.10 90.1 01-51-60230 SUPPLIES - OFFICE 301.21 2,891.68 7,000.00 4,108.32 41.3 01-51-60231 SUPPLIES-OPERATIONS 45.75 3,821.21 4,900.00 1,078.79 78.0 01-51-60233 EMERGENCY NETWORK FEE 286.00 2,002.00 2,500.00 498.00 80.1 01-51-60234 SUPPLIES-AMMUNITION .00 6,588.16 6,500.00 ( 88.16) 101.4 01-51-60240 POSTAGE 36.69 341.93 400.00 58.07 85.5 01-51-60260 DUES AND SUBSCRIPTIONS 25.00 896.80 3,500.00 2,603.20 25.6 01-51-60270 CIRSA/LEXIPOL POLICY M & T .00 5,108.00 5,200.00 92.00 98.2 01-51-60300 PUBLIC/LEGAL NOTICES .00 .00 200.00 200.00 .0 01-51-60305 LEGAL SERVICES .00 .00 250.00 250.00 .0 01-51-60341 UTILITIES - ELECTRIC 648.82 3,914.02 7,600.00 3,685.98 51.5 01-51-60342 UTILITIES - GAS 67.27 1,517.66 2,500.00 982.34 60.7 01-51-60343 UTILITIES - SANITATION 17.71 123.99 600.00 476.01 20.7 01-51-60345 UTILITIES - TELEPHONE 2,770.66 10,640.69 22,000.00 11,359.31 48.4 01-51-60350 UTILITIES - TRASH PICKUP 52.00 286.00 550.00 264.00 52.0 01-51-60610 FUEL 2,115.77 11,068.57 18,000.00 6,931.43 61.5 01-51-60770 TRAVEL, TRAINING & MEETINGS 2,364.41 6,815.17 12,000.00 5,184.83 56.8 01-51-65380 TACTICAL EQUIPMENT ( 48.08) 8,923.85 12,000.00 3,076.15 74.4 01-51-65381 TASER CAMERA CLOUD STORAGE .00 4,780.50 4,781.00 .50 100.0 01-51-65383 MDC AIRTIME .00 1,312.43 3,300.00 1,987.57 39.8 01-51-65384 INTELLICHOICE ANNUAL LICENSE .00 3,972.52 4,000.00 27.48 99.3 01-51-65385 RADIO U & U MANDATORY .00 880.00 8,630.00 7,750.00 10.2 01-51-65387 GPS TRACKING .00 2,716.01 .00 ( 2,716.01) .0 01-51-65660 REPAIR & MAINTENANCE - COMPUTE .00 1,579.00 .00 ( 1,579.00) .0 01-51-65665 REPAIR & MAINTENANCE - COPIER 607.66 4,457.45 3,000.00 ( 1,457.45) 148.6 01-51-66002 BODY WORN CAMERA EQUIPMENT .00 1,756.48 5,500.00 3,743.52 31.9 01-51-68355 CAPITAL LEASE PRINCIPAL ( 12,338.39) .00 .00 .00 .0 01-51-68356 CAPITAL LEASE INTEREST ( 556.86) .00 .00 .00 .0 TOTAL LAW ENFORCEMENT 98,547.19 885,709.04 1,764,347.00 878,637.96 50.2 TOTAL FUND EXPENDITURES 515,501.55 2,680,282.93 5,955,470.00 3,275,187.07 45.0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 11 NET REVENUE OVER EXPENDITURES 194,400.98 348,618.12 ( 461,854.00) ( 810,472.12) 75.5 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 12 ASSETS 02-00-10100 CASH IN COMBINED CASH FUND 90,833.92 TOTAL ASSETS 90,833.92 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 90,833.92 BALANCE - CURRENT DATE 90,833.92 TOTAL FUND EQUITY 90,833.92 TOTAL LIABILITIES AND EQUITY 90,833.92 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 13 DEPARTMENT 02 02-02-40120 CIP SALES TAX REVENUJE WATER 28,750.00 172,500.00 345,000.00 172,500.00 50.0 02-02-40121 CIP SALES TAX REVENUE GF 32,437.50 194,625.00 389,250.00 194,625.00 50.0 02-02-48085 GRANT GOCO LIMBACH PARK .00 .00 350,000.00 350,000.00 .0 02-02-48086 GRANT-PPACG FOR SIDEWALK .00 .00 40,000.00 40,000.00 .0 02-02-49000 CIP OTHER FINANCING WATER .00 .00 1,549,500.00 1,549,500.00 .0 02-02-49001 CIP OTHER FINANCING GF .00 .00 89,050.00 89,050.00 .0 TOTAL DEPARTMENT 02 61,187.50 367,125.00 2,762,800.00 2,395,675.00 13.3 TOTAL FUND REVENUE 61,187.50 367,125.00 2,762,800.00 2,395,675.00 13.3 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 14 02-02-66045 WELL 4 & 5 TREATMENT PLANT 4,377.04 259,871.71 924,500.00 664,628.29 28.1 02-02-66052 RASP LANE CHLORINE STATIONS .00 .00 20,000.00 20,000.00 .0 02-02-66054 RASP LANE DISTRIBUTION LINE .00 .00 75,000.00 75,000.00 .0 02-02-66055 WTP #7 MOV CHANGE .00 .00 100,000.00 100,000.00 .0 02-02-66056 WELL #4 & #5 BUILDING REHAB .00 .00 150,000.00 150,000.00 .0 02-02-66057 BOOSTER STATION UPGRADE .00 .00 625,000.00 625,000.00 .0 02-02-66076 SOLAR LIGHTS LIMBACH PARK .00 .00 50,000.00 50,000.00 .0 02-02-66077 WATER FOUNTAINS PARKS .00 .00 30,000.00 30,000.00 .0 02-02-66079 SPLASH PARK AT LIMBACH PARK .00 .00 600,000.00 600,000.00 .0 02-02-66080 TURF TRACTOR .00 .00 25,000.00 25,000.00 .0 02-02-66081 BEACON LITE SIDEWALK 4,963.75 16,419.37 38,000.00 21,580.63 43.2 02-02-66082 POUR & PLAY TOT LOT LIMBACH .00 .00 36,250.00 36,250.00 .0 02-02-68355 GENERAL FUND CAPITAL LEASES .00 .00 89,050.00 89,050.00 .0 TOTAL DEPARTMENT 02 9,340.79 276,291.08 2,762,800.00 2,486,508.92 10.0 TOTAL FUND EXPENDITURES 9,340.79 276,291.08 2,762,800.00 2,486,508.92 10.0 NET REVENUE OVER EXPENDITURES 51,846.71 90,833.92 .00 ( 90,833.92) .0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 2A WATER ASD FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 15 ASSETS 04-00-10100 CASH IN COMBINED CASH FUND 259,871.71 04-00-10425 COLOTRUST WATER ASD FUND ACCT 1,772,465.85 TOTAL ASSETS 2,032,337.56 LIABILITIES AND EQUITY FUND EQUITY 04-00-30000 BEGINNING FUND BALANCE - 2A W 1,781,913.29 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 250,424.27 BALANCE - CURRENT DATE 250,424.27 TOTAL FUND EQUITY 2,032,337.56 TOTAL LIABILITIES AND EQUITY 2,032,337.56 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 2A WATER ASD FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 16 04-04-40060 INTEREST INCOME 2A WATER ASD 2,233.25 10,644.84 7,590.00 ( 3,054.84) 140.3 04-04-40750 SALES TAX - 2A WATER ASD FUND 61,821.91 274,781.77 788,603.00 513,821.23 34.8 TOTAL DEPARTMENT 04 64,055.16 285,426.61 796,193.00 510,766.39 35.9 TOTAL FUND REVENUE 64,055.16 285,426.61 796,193.00 510,766.39 35.9 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 2A WATER ASD FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 17 04-04-60305 LEGAL SERVICES .00 7,176.34 10,275.00 3,098.66 69.8 04-04-62000 PROFESSIONAL SERVICES - LYTLE .00 1,750.00 35,591.00 33,841.00 4.9 04-04-62003 PROFESSIONAL SERVICES OTHER .00 .00 20,177.00 20,177.00 .0 04-04-66004 NEW WATER TANK & TRANSMISSION .00 11,737.53 2,250,280.00 2,238,542.47 .5 04-04-66008 RFWM PHASE I-SAMPLING .00 6,942.00 50,300.00 43,358.00 13.8 04-04-66009 CONNECT HUGH'S WELL AT LOR .00 .00 65,000.00 65,000.00 .0 04-04-66010 AREA 3 RESERVIOR (HPR) .00 .00 200,000.00 200,000.00 .0 04-04-66021 TRANSIT LOSS .00 7,396.47 8,500.00 1,103.53 87.0 TOTAL DEPARTMENT 04 .00 35,002.34 2,640,123.00 2,605,120.66 1.3 TOTAL FUND EXPENDITURES .00 35,002.34 2,640,123.00 2,605,120.66 1.3 NET REVENUE OVER EXPENDITURES 64,055.16 250,424.27 ( 1,843,930.00) ( 2,094,354.27) 13.6 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 DEBT SERVICE FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 18 ASSETS 05-00-10100 CASH IN COMBINED CASH FUND 12,931.57 TOTAL ASSETS 12,931.57 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 12,931.57 BALANCE - CURRENT DATE 12,931.57 TOTAL FUND EQUITY 12,931.57 TOTAL LIABILITIES AND EQUITY 12,931.57 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 DEBT SERVICE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 19 DEBT SERVICE FUND 05-05-40750 SALES TAX WEF - DEBT SVC 12,755.17 76,531.02 153,062.00 76,530.98 50.0 05-05-40751 SALES TAX GENERAL FUND DEBT 12,178.75 73,072.50 146,145.00 73,072.50 50.0 TOTAL DEBT SERVICE FUND 24,933.92 149,603.52 299,207.00 149,603.48 50.0 TOTAL FUND REVENUE 24,933.92 149,603.52 299,207.00 149,603.48 50.0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 DEBT SERVICE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 20 DEBT SERVICE FUND 05-05-68330 WF CL SERIES 2016 #403-P 20,135.61 20,135.61 21,077.00 941.39 95.5 05-05-68331 WEF CL SERIES 2016 #403-I 447.00 447.00 447.00 .00 100.0 05-05-68332 WEF CL SERIES 2016 #404-P 47,835.30 47,835.30 49,247.00 1,411.70 97.1 05-05-68333 WEF CL SERIES 2016 #404-I 4,682.00 4,682.00 4,816.00 134.00 97.2 05-05-68349 2018 LOAN PRINCIPAL .00 .00 77,475.00 77,475.00 .0 05-05-68350 GENERAL FUND CL SERIES #403-P ( 6,758.12) 44,817.93 46,914.00 2,096.07 95.5 05-05-68351 GF CL SERIES 2016 #403-I ( 1,209.33) 995.00 995.00 .00 100.0 05-05-68352 GF CL SERIES #404-P ( 47,835.30) 9,807.50 10,087.00 279.50 97.2 05-05-68353 GF CL SERIES 2016 #404-I ( 4,682.30) 949.11 987.00 37.89 96.2 05-05-68354 GF CL SERIES 2017 #405-P .00 .00 44,681.00 44,681.00 .0 05-05-68355 GF CL SERIES 2017 #405-I .00 .00 5,008.00 5,008.00 .0 05-05-68356 GF CL VAR SERVER LEASE-P 2,187.42 7,002.50 7,790.00 787.50 89.9 05-05-68357 GF CL VAR SERVER LEASE -I ( 506.58) .00 .00 .00 .0 05-05-68358 GF CL SERIES 2018 #406-P .00 .00 29,683.00 29,683.00 .0 TOTAL DEBT SERVICE FUND 14,295.70 136,671.95 299,207.00 162,535.05 45.7 TOTAL FUND EXPENDITURES 14,295.70 136,671.95 299,207.00 162,535.05 45.7 NET REVENUE OVER EXPENDITURES 10,638.22 12,931.57 .00 ( 12,931.57) .0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 COMMUNITY DEVELOPMENT FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 21 ASSETS 31-00-10428 COLOTRUST COMMUNITY DEV FND 18,560.34 TOTAL ASSETS 18,560.34 LIABILITIES AND EQUITY FUND EQUITY 31-00-30000 BEGINNING FUND BALANCE - COMMU 25,451.14 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 6,890.80) BALANCE - CURRENT DATE ( 6,890.80) TOTAL FUND EQUITY 18,560.34 TOTAL LIABILITIES AND EQUITY 18,560.34 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 COMMUNITY DEVELOPMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 22 COMMMUNITY DEVELOPMENT FUND 31-02-40060 INTEREST AND INVESTMENT INCOME 55.48 369.38 450.00 80.62 82.1 31-02-40065 TRANSFER FROM GENERAL FUND 20,000.00 20,000.00 20,000.00 .00 100.0 31-02-40220 BUSINESS LICENSES-COMMUNITY DE 3,500.20 33,664.65 63,750.00 30,085.35 52.8 31-02-40225 SPONSORSHIP REVENUE 550.00 2,550.00 3,000.00 450.00 85.0 TOTAL COMMMUNITY DEVELOPMENT FUN 24,105.68 56,584.03 87,200.00 30,615.97 64.9 TOTAL FUND REVENUE 24,105.68 56,584.03 87,200.00 30,615.97 64.9 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 COMMUNITY DEVELOPMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 23 COMMMUNITY DEVELOPMENT FUND 31-02-60230 SUPPLIES - OFFICE/OPERATIONS 36.40 585.90 1,000.00 414.10 58.6 31-02-60260 DUES AND SUBSCRIPTIONS .00 220.00 1,000.00 780.00 22.0 31-02-60770 TRAVEL,TRAINING, MEETINGS .00 2,842.37 2,000.00 ( 842.37) 142.1 31-02-65371 BROCHURE DEVELOPMENT 100.00 4,930.00 5,000.00 70.00 98.6 31-02-65372 BROCHURE DISTRIBUTION 2,679.90 3,529.70 10,000.00 6,470.30 35.3 31-02-65373 SOCIAL MEDIA ARCHIVING .00 .00 3,000.00 3,000.00 .0 31-02-65374 ADVERTISING 1,625.78 2,525.78 4,000.00 1,474.22 63.1 31-02-66000 CAPITAL PROJECTS-TBD .00 8,067.00 9,678.00 1,611.00 83.4 31-02-66006 CDF GRANTS - DOWNTOWN 500.00 500.00 5,000.00 4,500.00 10.0 31-02-66007 CDF GRANTS - HIGHWAY 105 .00 250.00 1,500.00 1,250.00 16.7 31-02-66008 CDF GRANTS - JCP & CIPRIANI .00 .00 1,500.00 1,500.00 .0 31-02-66009 CDF GRANTS - MGMT DISCRETION 810.00 810.00 5,000.00 4,190.00 16.2 31-02-66012 EVENTS, MEETINGS, TRAINING .00 500.00 2,000.00 1,500.00 25.0 31-02-66013 TRI LAKES CHAMBER SPONSORSHIP 10,000.00 10,000.00 20,000.00 10,000.00 50.0 31-02-66015 MOVIE EQUIPMENT PURCHASE .00 19,022.00 19,775.00 753.00 96.2 31-02-66016 FACADE MURAL GRANT 2,946.35 2,946.35 5,000.00 2,053.65 58.9 31-02-66018 BINES AND BREWS .00 .00 3,000.00 3,000.00 .0 31-02-66020 FOURTH OF JULY EVENTS 3,150.00 3,150.00 8,000.00 4,850.00 39.4 31-02-66021 MOVIE NIGHTS 263.83 3,309.83 3,600.00 290.17 91.9 31-02-66022 MEMORIAL DAY 285.90 285.90 500.00 214.10 57.2 31-02-66031 CLEAN UP EVENTS .00 .00 1,000.00 1,000.00 .0 31-02-66032 PICKIN' ON THE DIVIDE .00 .00 1,225.00 1,225.00 .0 TOTAL COMMMUNITY DEVELOPMENT FUN 22,398.16 63,474.83 112,778.00 49,303.17 56.3 TOTAL FUND EXPENDITURES 22,398.16 63,474.83 112,778.00 49,303.17 56.3 NET REVENUE OVER EXPENDITURES 1,707.52 ( 6,890.80) ( 25,578.00) ( 18,687.20) ( 26.9) ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 TRAFFIC IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 24 ASSETS 32-00-10427 COLOTRUST TRAFFIC IMPACT FEE F 210,153.64 TOTAL ASSETS 210,153.64 LIABILITIES AND EQUITY FUND EQUITY 32-00-30000 BEGINNING FUND BALANCE - TRAFF 176,295.33 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 33,858.31 BALANCE - CURRENT DATE 33,858.31 TOTAL FUND EQUITY 210,153.64 TOTAL LIABILITIES AND EQUITY 210,153.64 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 TRAFFIC IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 25 TRAFFIC IMPACT FEE FUND 32-10-40060 INTEREST INCOME 335.39 1,622.68 2,000.00 377.32 81.1 32-10-40460 TRAFFIC IMPACT FEES 2,828.00 15,974.63 50,000.00 34,025.37 32.0 32-10-40461 LOR SPECIAL IMPACT FEES PD .00 16,261.00 95,000.00 78,739.00 17.1 TOTAL TRAFFIC IMPACT FEE FUND 3,163.39 33,858.31 147,000.00 113,141.69 23.0 TOTAL FUND REVENUE 3,163.39 33,858.31 147,000.00 113,141.69 23.0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 TRAFFIC IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 26 TRAFFIC IMPACT FEE FUND 32-10-65999 CAPITAL OUTLAY-TRAFFIC IMPACT .00 .00 327,329.00 327,329.00 .0 TOTAL TRAFFIC IMPACT FEE FUND .00 .00 327,329.00 327,329.00 .0 TOTAL FUND EXPENDITURES .00 .00 327,329.00 327,329.00 .0 NET REVENUE OVER EXPENDITURES 3,163.39 33,858.31 ( 180,329.00) ( 214,187.31) 18.8 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 STORM DRAINAGE IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 27 ASSETS 35-00-10429 COLOTRUST STORM DRAINAGE IMPAC 45,065.54 TOTAL ASSETS 45,065.54 LIABILITIES AND EQUITY FUND EQUITY 35-00-30000 BEGINNING FUND BALANCE - STORM 8,139.82 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 36,925.72 BALANCE - CURRENT DATE 36,925.72 TOTAL FUND EQUITY 45,065.54 TOTAL LIABILITIES AND EQUITY 45,065.54 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 STORM DRAINAGE IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 28 STORM DRAINAGE IMPACT FEE FUND 35-35-40060 INTEREST INCOME 65.73 230.53 100.00 ( 130.53) 230.5 35-35-41010 STORM DRAINAGE IMPACT FEES 3,144.44 29,543.98 40,000.00 10,456.02 73.9 35-35-41011 IMPACT FEES LOR .00 18,469.32 50,000.00 31,530.68 36.9 TOTAL STORM DRAINAGE IMPACT FEE FUN 3,210.17 48,243.83 90,100.00 41,856.17 53.5 TOTAL FUND REVENUE 3,210.17 48,243.83 90,100.00 41,856.17 53.5 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 STORM DRAINAGE IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 29 STORM DRAINAGE IMPACT FEE FUND 35-35-60770 TRAVEL, TRAINING AND MEETINGS .00 299.71 5,000.00 4,700.29 6.0 35-35-66000 STORMWATER DRAINAGE REPAIRS .00 11,018.40 112,945.00 101,926.60 9.8 TOTAL STORM DRAINAGE IMPACT FEE FUN .00 11,318.11 117,945.00 106,626.89 9.6 TOTAL FUND EXPENDITURES .00 11,318.11 117,945.00 106,626.89 9.6 NET REVENUE OVER EXPENDITURES 3,210.17 36,925.72 ( 27,845.00) ( 64,770.72) 132.6 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 30 ASSETS 61-00-10230 WELLS FARGO-WATER DEPOSITS 20,600.00 61-00-10740 COLOTRUST WATER ENTERPRISE FUN 701,838.06 61-00-10745 COLOTRUST MLWS ESCROW 679,202.48 61-00-11750 UTILITY CASH CLEARING 10,545.29 61-00-14010 A/R-WATER 185,596.87 61-00-14500 WATER PAYMENT CONTRACTS REC ( 1,084.50) 61-00-15001 PREPAID LOR WATER LINE LOOP 471,110.00 61-00-17800 WEF WATER RIGHTS 125,000.00 61-00-17801 WEF SOURCE OF SUP. ALLUVIUM WE 420,392.00 61-00-17802 WEF WATER TREATMENT PLANT 1,199,322.08 61-00-17803 WEF IRON TREATMENT PLANT 287,854.00 61-00-17804 WEF EQUIPMENT, F&F 1,222,596.59 61-00-17811 WEF SLABAUGH LINE 191,390.00 61-00-17814 WEF CIP-CONSTRUCTION OF DAM 2,781,510.11 61-00-17815 WELL #8 BOND ISSUANCE (WTR MP) 664,971.10 61-00-17817 WEF CAPITAL IMPROVEMENT-DAM 152,147.00 61-00-17818 WEF WELLS/TREATMENT 7,758,384.86 61-00-17820 WEF WELLS/TREATMENT 49,253.87 61-00-17821 WEF TRANSMISSION & DISTRIBUTIO 2,127,425.67 61-00-17822 WEF VEHICLES 384,291.90 61-00-17823 WEF BUILDINGS 118,897.00 61-00-19807 AD - WATER ENTERPRISE FUND EQU ( 9,831,858.40) TOTAL ASSETS 9,719,385.98 LIABILITIES AND EQUITY LIABILITIES 61-00-20225 WEF ACCRUED INTEREST 2,205.23 61-00-24300 ACCRUED VACATION & SICK LEAVE 33,583.94 61-00-25000 WATER METER DEPOSIT REFUNDS 20,300.00 61-00-28330 CAPITAL DEBT LEASES 177,131.39 TOTAL LIABILITIES 233,220.56 FUND EQUITY 61-00-30000 BEGINNING FUND BALANCE - WATER 3,581,380.20 61-00-30025 CONTRIBUTED CAPITAL-TAP FEE 2,137,183.00 61-00-30040 DEBT SERVICE FUND 2,037,528.26 61-00-30050 GRANTS 956,838.00 61-00-30060 WATER LINES 125,625.00 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 647,610.96 BALANCE - CURRENT DATE 647,610.96 TOTAL FUND EQUITY 9,486,165.42 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 31 TOTAL LIABILITIES AND EQUITY 9,719,385.98 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 32 61-15-40060 INTEREST AND INVESTMENT INCOME 1,693.67 8,472.84 9,944.00 1,471.16 85.2 61-15-46100 WATER REVENUE - RESIDENTIAL SA 103,043.51 385,247.92 918,352.00 533,104.08 42.0 61-15-46105 WATER REVENUE - COMMERCIAL SAL 74,394.53 285,710.41 670,479.00 384,768.59 42.6 61-15-46110 WATER REVENUE - BULK SALES 1,549.27 5,938.88 13,325.00 7,386.12 44.6 61-15-46111 LATE FEES 1,960.00 12,562.50 24,447.00 11,884.50 51.4 61-15-46115 SALES TAX-WATER FUND 22,653.32 110,795.87 192,992.00 82,196.13 57.4 61-15-46250 OTHER REVENUES .00 5.14 .00 ( 5.14) .0 61-15-48078 LOR WATER TAP IMPACT FEES .00 280,271.00 225,000.00 ( 55,271.00) 124.6 61-15-48080 WATER REVENUE - IMPACT FEES 42,772.00 169,292.00 90,000.00 ( 79,292.00) 188.1 61-15-48081 WATER METER IMPACT FEES 1,880.00 25,157.00 15,050.00 ( 10,107.00) 167.2 TOTAL DEPARTMENT 15 249,946.30 1,283,453.56 2,159,589.00 876,135.44 59.4 TOTAL FUND REVENUE 249,946.30 1,283,453.56 2,159,589.00 876,135.44 59.4 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 33 61-15-60000 SALARIES 75,948.58 261,329.30 519,792.00 258,462.70 50.3 61-15-60010 OVERTIME PAY 1,095.17 3,158.71 10,000.00 6,841.29 31.6 61-15-60019 LONGEVITY RECOGNITION 500.00 500.00 500.00 .00 100.0 61-15-60020 ON-CALL/STANDBY PAY 350.00 3,550.00 11,500.00 7,950.00 30.9 61-15-60071 STATE UNEMPLOYMENT TAXES 233.66 805.37 1,559.00 753.63 51.7 61-15-60080 HEALTH & DENTAL INSURANCE .00 43,139.91 117,362.00 74,222.09 36.8 61-15-60085 LIFE & DISABILITY INSURANCE .00 2,689.50 6,389.00 3,699.50 42.1 61-15-60092 EMPLOYER'S 457 1,424.37 9,764.07 25,990.00 16,225.93 37.6 61-15-60093 EMPLOYER'S FICA 4,430.92 15,039.38 32,227.00 17,187.62 46.7 61-15-60094 EMPLOYER'S MEDICARE 1,102.71 3,583.67 7,537.00 3,953.33 47.6 61-15-60095 BANK FEES FOR PSN PAYMENTS 118.75 1,250.41 .00 ( 1,250.41) .0 61-15-60096 PAYROLL & BANK FEES 59.17 355.02 850.00 494.98 41.8 61-15-60098 STAFFTUITION .00 150.00 3,000.00 2,850.00 5.0 61-15-60099 ADMIN FEE TO GENERAL FUND 5,803.75 34,822.50 72,195.00 37,372.50 48.2 61-15-60100 WORKERS COMPENSATION INSURANCE 2,748.35 16,990.10 24,985.00 7,994.90 68.0 61-15-60125 PAYMENT IN LIEU OF 5% FF 8,594.47 51,566.82 103,136.00 51,569.18 50.0 61-15-60130 GENERAL INSURANCE 3,294.64 19,767.84 29,618.00 9,850.16 66.7 61-15-60135 DRUG/ALCOHOL TESTING .00 621.40 800.00 178.60 77.7 61-15-60200 SAFETY EQUIPMENT 100.00 2,449.49 3,000.00 550.51 81.7 61-15-60210 UNIFORMS 52.99 808.90 2,700.00 1,891.10 30.0 61-15-60220 SMALL TOOLS .00 66.70 500.00 433.30 13.3 61-15-60229 SUPPLIES-SHOP OPERATIONS 739.86 1,392.11 1,800.00 407.89 77.3 61-15-60231 SUPPLIES-OPERATIONS/OFFICE 252.78 1,450.31 5,000.00 3,549.69 29.0 61-15-60250 WATER BILLING EXPENSE 862.52 4,437.38 9,500.00 5,062.62 46.7 61-15-60260 DUES AND SUBSCRIPTIONS .00 3,753.88 15,000.00 11,246.12 25.0 61-15-60300 PUBLIC/LEGAL NOTICES 975.84 975.84 1,000.00 24.16 97.6 61-15-60305 LEGAL SERVICES 1,374.70 8,659.63 40,000.00 31,340.37 21.7 61-15-60341 UTILITIES - ELECTRIC 12,914.85 63,639.84 167,000.00 103,360.16 38.1 61-15-60342 UTILITIES - GAS 316.85 2,221.66 4,500.00 2,278.34 49.4 61-15-60343 UTILITIES - SANITATION 1,804.90 5,442.72 12,000.00 6,557.28 45.4 61-15-60345 UTILITIES - TELEPHONE 839.35 4,306.57 12,000.00 7,693.43 35.9 61-15-60355 REPAIR & MAINTENANCE - DAM .00 144.64 6,000.00 5,855.36 2.4 61-15-60400 CHEMICALS/GAS-WATER TREATMENT 1,426.77 4,972.13 60,400.00 55,427.87 8.2 61-15-60610 FUEL 400.41 2,383.86 6,000.00 3,616.14 39.7 61-15-60700 REPAIR & MAINTENANCE TEST: WAT 843.70 3,592.56 12,500.00 8,907.44 28.7 61-15-60720 UNCC MEMBERSHIP - LOCATES 110.20 501.70 1,000.00 498.30 50.2 61-15-60750 ACCOUNTING/AUDIT SERVICES .00 .00 6,000.00 6,000.00 .0 61-15-60770 TRAVEL, TRAINING & MEETINGS 1,026.88 4,236.93 10,000.00 5,763.07 42.4 61-15-65375 RENTAL MACHINERY & EQUIPMENT .00 591.40 1,000.00 408.60 59.1 61-15-65390 REPAIR & MAINTENANCE - VEHICLE 63.90 3,965.15 3,800.00 ( 165.15) 104.4 61-15-65395 REPAIR & MAINTENANCE - EQUIPME .00 .00 2,500.00 2,500.00 .0 61-15-65400 REPAIR & MAINTENANCE - WELL SI 169.42 2,861.45 40,000.00 37,138.55 7.2 61-15-65403 REPAIR & MAINTENANCE - BOOSTE .00 .00 2,000.00 2,000.00 .0 61-15-65410 REPAIR & MAINTENANCE - DISTRIB .00 5,689.61 20,000.00 14,310.39 28.5 61-15-65420 REPAIR & MAINTENANCE-STORAGE T 921.46 2,845.43 2,750.00 ( 95.43) 103.5 61-15-65430 REPAIR & MAINTENANCE-WATER MET .00 8,312.70 15,000.00 6,687.30 55.4 61-15-65440 REPAIR & MAINTENANCE SCADA SYS .00 .00 4,000.00 4,000.00 .0 61-15-65444 BADGER METER BEACON BILLING .00 580.00 7,000.00 6,420.00 8.3 61-15-65660 REPAIR & MAINTENANCE - COMPUTE .00 1,800.00 .00 ( 1,800.00) .0 61-15-65710 PROFESSIONAL SERVICES 3,344.12 10,918.63 70,000.00 59,081.37 15.6 61-15-65996 CONTINGENCY .00 .00 75,000.00 75,000.00 .0 61-15-66024 CHART ANALYSIS-LIFE SPAN WELLS .00 .00 2,000.00 2,000.00 .0 61-15-66025 SCADA SYSTEM SOFTWARE UPGRADE .00 .00 7,250.00 7,250.00 .0 61-15-66039 DISTRIBUTION LINE R&M .00 .00 25,325.00 25,325.00 .0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 34 61-15-66042 SOURCE WATER PROTECTION GRANT .00 .00 5,000.00 5,000.00 .0 61-15-66058 TRUCK REPLACEMENT .00 .00 42,000.00 42,000.00 .0 61-15-66059 WTP FILTER REHAB WELLS 7 & 8 .00 13,757.38 15,600.00 1,842.62 88.2 61-15-66060 LAPTOP FOR METER READING SOFTW .00 .00 7,500.00 7,500.00 .0 TOTAL DEPARTMENT 15 134,246.04 635,842.60 1,691,065.00 1,055,222.40 37.6 TOTAL FUND EXPENDITURES 134,246.04 635,842.60 1,691,065.00 1,055,222.40 37.6 NET REVENUE OVER EXPENDITURES 115,700.26 647,610.96 468,524.00 ( 179,086.96) 138.2 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET JUNE 30, 2018 CONSERVATION TRUST FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 35 ASSETS 82-00-10100 CASH IN COMBINED CASH FUND ( 13,502.67) 82-00-10422 COLOTRUST CONSERVATION TRUST F 3,133.53 TOTAL ASSETS ( 10,369.14) LIABILITIES AND EQUITY FUND EQUITY 82-00-30000 BEGINNING FUND BALANCE - CONSE 3,107.75 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 13,476.89) BALANCE - CURRENT DATE ( 13,476.89) TOTAL FUND EQUITY ( 10,369.14) TOTAL LIABILITIES AND EQUITY ( 10,369.14) ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 CONSERVATION TRUST FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 36 CONSERVATION TRUST FUND 82-08-40060 INTEREST INCOME 5.49 25.78 50.00 24.22 51.6 82-08-41020 CTF - LOTTERY - PMT 12,732.82 22,374.58 40,000.00 17,625.42 55.9 TOTAL CONSERVATION TRUST FUND 12,738.31 22,400.36 40,050.00 17,649.64 55.9 TOTAL FUND REVENUE 12,738.31 22,400.36 40,050.00 17,649.64 55.9 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2018 CONSERVATION TRUST FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 07:00PM PAGE: 37 CONSERVATION TRUST FUND 82-08-66000 TRAIL REPAIRS & IMPROVEMENTS 4,001.65 14,240.91 .00 ( 14,240.91) .0 82-08-66001 PARKS & OPEN SPACE IMPROVEMENT 6,420.70 21,636.34 43,934.00 22,297.66 49.3 TOTAL CONSERVATION TRUST FUND 10,422.35 35,877.25 43,934.00 8,056.75 81.7 TOTAL FUND EXPENDITURES 10,422.35 35,877.25 43,934.00 8,056.75 81.7 NET REVENUE OVER EXPENDITURES 2,315.96 ( 13,476.89) ( 3,884.00) 9,592.89 (347.0)