Full Text
TOWN OF MONUMENT COMBINED CASH INVESTMENT MAY 31, 2018 FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 1 COMBINED CASH ACCOUNTS 99-00-10200 WELLS FARGO OPERATING ACCOUNT 522,576.22 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 975,977.00 TOTAL COMBINED CASH 1,807,028.51 99-00-10100 CASH ALLOCATED TO OTHER FUNDS ( 1,807,028.51) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 778,443.84 2 ALLOCATION TO CAPITAL PROJECTS FUND 38,987.21 4 ALLOCATION TO 2A WATER ASD FUND 599,422.65 5 ALLOCATION TO DEBT SERVICE FUND 2,293.35 31 ALLOCATION TO COMMUNITY DEVELOPMENT FUND ( 14,696.54) 32 ALLOCATION TO TRAFFIC IMPACT FEE FUND 62,675.91 35 ALLOCATION TO STORM DRAINAGE IMPACT FEE FUND 4,484.26 61 ALLOCATION TO WATER FUND 351,230.97 82 ALLOCATION TO CONSERVATION TRUST FUND ( 15,813.14) TOTAL ALLOCATIONS TO OTHER FUNDS 1,807,028.51 ALLOCATION FROM COMBINED CASH FUND - 99-0010100 ( 1,807,028.51) ZERO PROOF IF ALLOCATIONS BALANCE .00 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 2 ASSETS 01-00-10100 CASH IN COMBINED CASH FUND 778,443.84 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 24,608.89 01-00-10420 COLOTRUST BONDS PAYABLE 292,745.96 01-00-10422 SANTA ON PATROL DONATIONS 8,998.86 01-00-10425 WELLS FARGO ESCROW FOR CL#405 94,166.58 01-00-10426 COLOTRUST DOJ SEIZURE PD 88.49 01-00-10750 A/R PAYROLL 687.84 01-00-11700 FRANCHISE FEES RECEIVABLE 9,893.72 01-00-11900 TAXES RECEIVABLE - PROPERTY 893,834.00 01-00-11950 DUE FROM OTHER GOVERNMENTS 971,682.86 01-00-15000 PREPAID EXPENSE 21,058.93 01-00-15001 PREPAID RECORDING FEES 2,540.53 01-00-15002 PREPAID AMERIFLEX PLAN ( 1,850.10) 01-00-16000 ABATEMENTS RECEIVABLE 1,904.73 TOTAL ASSETS 3,100,516.35 LIABILITIES AND EQUITY ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 GENERAL FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 3 LIABILITIES 01-00-20200 ACCOUNTS PAYABLE 64,364.25 01-00-20204 DONATIONS TO PW BUIDLING 10.00 01-00-20205 ACCOUNTS PAYABLE TRI-VIEW 321,863.61 01-00-20214 SANTA ON PATROL DONATIONS 6,605.87 01-00-20215 DOJ PAYMENTS 84.26 01-00-21710 WAGES PAYABLE 151,253.02 01-00-21711 FEDERAL W/H PAYABLE 15,560.55 01-00-21712 STATE W/H PAYABLE 5,005.00 01-00-21713 FICA PAYABLE 20,575.76 01-00-21715 SUTA PAYABLE 2,193.00 01-00-21716 MEDICARE PAYABLE 4,812.07 01-00-21740 RETIREMENT - FPPA PAYABLE 8,853.01 01-00-21742 RETIREMENT-VALIC/ICMA PAYABLE 12,964.22 01-00-21743 LIFE/DISABILITY INSURANCE - ST 5,783.67 01-00-21745 OUTSTANDING JUDGMENT WARRANTS 766.00 01-00-21746 BRAIN TRAUMA STATE FEES PAYABL ( 570.00) 01-00-21751 HEALTH/DENTAL INSURANCE - BENE 41,042.74 01-00-21752 CAFETERIA PLAN PYBLE-AMERIFLEX ( 4,633.18) 01-00-21755 AFLAC PAYABLE 968.48 01-00-21780 OTHER W/H PAYABLE 116.70 01-00-21785 DEPOSITS FOR PARK RESERVATION 625.00 01-00-24243 MVE/TMD BORDER FENCE DEPOSIT 250,000.00 01-00-24244 LEWIS PALMER SD#38 PAYABLE 48,600.00 01-00-24245 PLANNING RETAINER PAYABLE 22,386.47 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,171,999.85 FUND EQUITY 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 154,217.14 BALANCE - CURRENT DATE 154,217.14 TOTAL FUND EQUITY 928,516.50 TOTAL LIABILITIES AND EQUITY 3,100,516.35 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 4 PUBLIC WORKS 01-30-40020 GRAVE OPENING & CLOSING 850.00 1,200.00 3,500.00 2,300.00 34.3 01-30-40030 PLOT SALES 3,100.00 5,500.00 10,000.00 4,500.00 55.0 01-30-40341 PW - PARK RESERVATION FEES 2,362.50 9,162.50 20,000.00 10,837.50 45.8 01-30-40430 HWY USER'S TAX FUND 19,119.95 94,318.88 235,389.00 141,070.12 40.1 01-30-40450 ROAD & BRIDGE .00 10,638.89 21,500.00 10,861.11 49.5 01-30-48020 GRANT REVENUE .00 6,486.96 .00 ( 6,486.96) .0 TOTAL PUBLIC WORKS 25,432.45 127,307.23 290,389.00 163,081.77 43.8 ADMINISTRATIVE AND LEGISLATIVE 01-45-40060 INTEREST & INVESTMENT INCOME 1,278.12 5,582.74 3,505.00 ( 2,077.74) 159.3 01-45-40110 GENERAL PROPERTY TAX 90,790.82 638,192.97 837,620.00 199,427.03 76.2 01-45-40115 SPECIFIC OWNERSHIP TAXES 9,235.25 43,566.05 101,105.00 57,538.95 43.1 01-45-40120 SALES TAX - GENERAL 146,486.94 794,205.69 2,428,364.00 1,634,158.31 32.7 01-45-40124 SALES TAX - AUTO 37,712.77 154,429.53 300,000.00 145,570.47 51.5 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 .00 72,513.79 248,186.00 175,672.21 29.2 01-45-40143 FRANCHISE FEE - BLACK HILLS UT .00 31,110.59 90,846.00 59,735.41 34.3 01-45-40147 FRANCHISE FEE - CENTURY LINK .00 7,116.72 25,000.00 17,883.28 28.5 01-45-40149 ADMINISTRATIVE FEE-WATER FUND 5,803.75 29,018.75 72,195.00 43,176.25 40.2 01-45-40150 FRANCHISE FEE- COMCAST .00 26,239.87 30,000.00 3,760.13 87.5 01-45-40151 PAYMENT IN LIEU OF FF 8,594.47 42,972.35 103,136.00 60,163.65 41.7 01-45-40210 LIQUOR LICENSE 2,128.75 4,530.00 5,700.00 1,170.00 79.5 01-45-40320 SALE OF COPIES & ORDINANCES .00 90.00 100.00 10.00 90.0 01-45-40400 MOTOR VEHICLE REGISTRATION 2,625.00 12,742.00 46,500.00 33,758.00 27.4 01-45-40410 TOBACCO PRODUCTS TAX 1,500.00 8,713.34 7,000.00 ( 1,713.34) 124.5 TOTAL ADMINISTRATIVE AND LEGISLATIVE 306,155.87 1,871,024.39 4,300,657.00 2,429,632.61 43.5 COURT 01-46-40510 COURT COLLECTIONS & FEES 1,745.00 10,704.00 60,000.00 49,296.00 17.8 01-46-40515 COURT BONDS .00 2.00 100.00 98.00 2.0 01-46-40620 TRAFFIC SAFETY INCOME 2,210.00 14,015.00 55,000.00 40,985.00 25.5 TOTAL COURT 3,955.00 24,721.00 115,100.00 90,379.00 21.5 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 5 PLANNING DEPARTMENT 01-49-40130 USE TAX 43,690.72 204,674.38 584,260.00 379,585.62 35.0 01-49-40230 LAND USE PERMITS 3,500.00 15,825.00 40,380.00 24,555.00 39.2 01-49-40240 FENCE PERMITS 419.80 1,045.72 3,000.00 1,954.28 34.9 01-49-40245 LANDSCAPE PERMITS 900.00 4,570.00 7,200.00 2,630.00 63.5 01-49-40250 SIDEWALK PERMITS 15.00 15.00 .00 ( 15.00) .0 01-49-40255 RIGHT OF WAY PERMITS .00 700.00 .00 ( 700.00) .0 01-49-40260 TEMPORARY USE PERMIT .00 250.00 500.00 250.00 50.0 01-49-40265 LAKE USE PERMITS .00 500.00 1,000.00 500.00 50.0 01-49-40270 SIGN PERMITS 75.00 1,525.00 2,000.00 475.00 76.3 01-49-40310 PLANNING FEES 2,575.00 23,803.00 43,830.00 20,027.00 54.3 01-49-40311 ENG REV/INSP FEES 580.00 9,705.00 45,000.00 35,295.00 21.6 01-49-40350 CODE ENFORCEMENT FEES .00 .00 300.00 300.00 .0 01-49-41050 INFRASTSRUCTURE FEE-TRIVIEW 7,000.00 27,500.00 50,000.00 22,500.00 55.0 TOTAL PLANNING DEPARTMENT 58,755.52 290,113.10 777,470.00 487,356.90 37.3 LAW ENFORCEMENT 01-51-40350 FEES FOR SERVICE 1,124.90 5,832.80 10,000.00 4,167.20 58.3 TOTAL LAW ENFORCEMENT 1,124.90 5,832.80 10,000.00 4,167.20 58.3 TOTAL FUND REVENUE 395,423.74 2,318,998.52 5,493,616.00 3,174,617.48 42.2 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 6 PUBLIC WORKS 01-30-60000 SALARIES 53,918.87 291,122.88 766,508.00 475,385.12 38.0 01-30-60010 OVERTIME PAY 550.60 6,773.94 25,000.00 18,226.06 27.1 01-30-60019 LONGEVITY RECOGNITION .00 .00 1,000.00 1,000.00 .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 168.82 933.03 2,300.00 1,366.97 40.6 01-30-60080 HEALTH & DENTAL INSURANCE 9,566.43 63,517.46 166,912.00 103,394.54 38.1 01-30-60085 LIFE & DISABILITY INSURANCE 685.21 4,319.97 9,258.00 4,938.03 46.7 01-30-60092 EMPLOYER'S 457 1,793.21 10,783.68 38,325.00 27,541.32 28.1 01-30-60093 EMPLOYER'S FICA 3,263.09 18,108.17 47,523.00 29,414.83 38.1 01-30-60094 EMPLOYER'S MEDICARE 763.13 4,234.96 11,114.00 6,879.04 38.1 01-30-60095 PAYROLL & BANK FEES 59.16 295.80 625.00 329.20 47.3 01-30-60098 STAFF TUITITION 17.14 276.87 3,500.00 3,223.13 7.9 01-30-60100 WORKMANS COMP INS DEDUCTIBLE 398.48 1,000.00 500.00 ( 500.00) 200.0 01-30-60130 GENERAL INSURANCE DEDUCTIBLE 5,000.00 10,134.00 .00 ( 10,134.00) .0 01-30-60135 DRUG/ALCOHOL TESTING 55.15 321.55 1,000.00 678.45 32.2 01-30-60200 SAFETY EQUIPMENT 1,242.21 4,354.44 6,000.00 1,645.56 72.6 01-30-60210 UNIFORMS 570.90 1,764.39 4,300.00 2,535.61 41.0 01-30-60229 SUPPLIES - SHOP OPERATIONS 832.15 2,371.36 7,500.00 5,128.64 31.6 01-30-60231 SUPPLIES-OPERATIONS 819.06 2,436.21 8,000.00 5,563.79 30.5 01-30-60233 SUMMER YOUTH PROGRAM EXPENSES .00 .00 25,000.00 25,000.00 .0 01-30-60245 STORAGE UNIT #724 .00 .00 1,300.00 1,300.00 .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 6,981.40 17,832.16 32,800.00 14,967.84 54.4 01-30-60342 UTILITIES - GAS 437.47 2,389.32 7,300.00 4,910.68 32.7 01-30-60343 UTILITIES - SANITATION 280.00 735.00 2,000.00 1,265.00 36.8 01-30-60345 UTILITIES - TELEPHONE 974.69 4,642.28 12,000.00 7,357.72 38.7 01-30-60350 UTILITIES - TRASH PICKUP 293.00 1,778.50 4,500.00 2,721.50 39.5 01-30-60385 SMALL TOOLS 178.89 693.41 2,500.00 1,806.59 27.7 01-30-60386 SHOP TOOLS 563.20 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 1,752.57 7,490.54 22,000.00 14,509.46 34.1 01-30-60770 TRAVEL,TRAINING,MEETINGS 230.70 2,734.28 8,000.00 5,265.72 34.2 01-30-61085 PURCHASED SERVICES - PORT-A-LE 685.00 2,425.00 9,000.00 6,575.00 26.9 01-30-62000 REPAIR & MAINTENANCE - PARKS 5,813.82 22,639.44 70,000.00 47,360.56 32.3 01-30-65375 RENTAL MACHINERY & EQUIPMENT 62.49 2,107.04 3,000.00 892.96 70.2 01-30-65387 GPS TRACKING 414.00 2,452.70 .00 ( 2,452.70) .0 01-30-65390 REPAIR & MAINTENANCE - VEHICLE 5,050.18 22,161.86 50,000.00 27,838.14 44.3 01-30-65395 REPAIR & MAINTENANCE - EQUIPME 2,044.99 12,947.31 50,000.00 37,052.69 25.9 01-30-65396 MOSQUITO CONTROL PROGRAM 3,068.00 3,068.00 11,800.00 8,732.00 26.0 01-30-65399 CURB, GUTTER AND SIDEWALKS .00 .00 35,000.00 35,000.00 .0 01-30-65400 REPAIR & MAINT - STREETS 6,589.12 8,214.71 30,000.00 21,785.29 27.4 01-30-65450 REPAIRS & MAINTENANCE - BUILDI 2,487.88 6,187.80 17,500.00 11,312.20 35.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 77.00 2,195.46 2,500.00 304.54 87.8 01-30-65710 PROFESSIONAL SERVICES 1,343.75 2,428.75 6,000.00 3,571.25 40.5 01-30-65730 CEMETERY MEMORIAL DAY EVENT .00 .00 500.00 500.00 .0 01-30-66002 ASPHALT REPAIRS 1,575.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 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM 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 120,606.76 568,485.00 1,879,940.00 1,311,455.00 30.2 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 8 ADMINISTRATIVE AND LEGISLATIVE 01-45-60000 SALARIES 50,319.74 274,762.49 628,199.00 353,436.51 43.7 01-45-60010 OVERTIME PAY 1,033.56 5,537.98 10,000.00 4,462.02 55.4 01-45-60011 TM EMPLOYEE PFP POOL .00 .00 25,800.00 25,800.00 .0 01-45-60020 LONGEVITY RECOGNITION .00 .00 1,500.00 1,500.00 .0 01-45-60071 STATE UNEMPLOYMENT TAXES 154.05 840.69 1,990.00 1,149.31 42.3 01-45-60080 HEALTH & DENTAL INSURANCE 5,820.00 47,849.00 127,708.00 79,859.00 37.5 01-45-60085 LIFE & DISABILITY INSURANCE 662.55 3,862.02 8,472.00 4,609.98 45.6 01-45-60090 STAFF APPRECIATION 119.99 174.18 2,500.00 2,325.82 7.0 01-45-60092 EMPLOYER'S 457 2,237.73 12,444.31 33,160.00 20,715.69 37.5 01-45-60093 EMPLOYER'S FICA 2,959.18 16,142.16 41,118.00 24,975.84 39.3 01-45-60094 EMPLOYER'S MEDICARE 692.06 3,775.25 9,617.00 5,841.75 39.3 01-45-60095 BANK & PAYROLL FEES 438.04 4,697.94 8,000.00 3,302.06 58.7 01-45-60098 STAFF TUITION 21.43 21.43 3,000.00 2,978.57 .7 01-45-60100 WORKERS COMPENSATION INSURANCE 5,579.98 27,899.90 75,000.00 47,100.10 37.2 01-45-60130 GENERAL INSURANCE 6,689.11 33,474.55 100,000.00 66,525.45 33.5 01-45-60133 2018 WAGE STUDY .00 .00 25,000.00 25,000.00 .0 01-45-60145 CONTRACT LABOR-JANITORIAL 901.25 4,506.25 10,000.00 5,493.75 45.1 01-45-60230 SUPPLIES - OFFICE/OPERATIONS 2,297.34 4,618.99 10,000.00 5,381.01 46.2 01-45-60231 FURNITURE, FIXTURES & EQUIP 827.00 827.00 2,500.00 1,673.00 33.1 01-45-60240 POSTAGE ( 203.45) 624.37 5,000.00 4,375.63 12.5 01-45-60245 STORAGE UNIT-ADMINISTRATION 258.00 1,032.00 1,800.00 768.00 57.3 01-45-60254 ELECTION EXPENSE 569.92 2,349.85 15,000.00 12,650.15 15.7 01-45-60260 DUES AND SUBSCRIPTIONS 1,051.58 7,324.47 20,000.00 12,675.53 36.6 01-45-60300 PUBLIC/LEGAL NOTICES 81.41 144.41 1,000.00 855.59 14.4 01-45-60305 LEGAL SERVICES 200.00 873.00 40,000.00 39,127.00 2.2 01-45-60341 UTILITIES - ELECTRIC 1,866.90 4,667.15 10,850.00 6,182.85 43.0 01-45-60342 UTILITIES - GAS 486.57 2,053.92 4,500.00 2,446.08 45.6 01-45-60343 UTILITIES - SANITATION 105.44 281.30 1,000.00 718.70 28.1 01-45-60345 UTILITIES - TELEPHONE 2,177.30 8,016.12 17,000.00 8,983.88 47.2 01-45-60350 UTILITIES - TRASH PICKUP 104.00 234.00 650.00 416.00 36.0 01-45-60360 UTILITIES - WATER SERVICE USED 3,056.27 7,495.13 40,000.00 32,504.87 18.7 01-45-60430 TTM - BOARD OF TRUSTEES 86.66 1,906.28 2,500.00 593.72 76.3 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 2,842.19 11,742.48 30,000.00 18,257.52 39.1 01-45-60772 EMPLOYEE MILEAGE-TM ( 100.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 2,813.20 14,127.76 30,000.00 15,872.24 47.1 01-45-65660 REPAIR & MAINTENANCE - COMPUTE 5,000.00 26,904.00 65,000.00 38,096.00 41.4 01-45-65661 COMPUTER LICENSES & SOFTWARE 6,859.20 12,293.20 25,000.00 12,706.80 49.2 01-45-65662 WEBMASTER MAINTENANCE .00 241.25 8,000.00 7,758.75 3.0 01-45-65665 REPAIR & MAINTENANCE - COPIER 1,727.38 8,111.21 9,000.00 888.79 90.1 01-45-65710 PROFESSIONAL CONSULTING 1,833.00 9,929.50 20,000.00 10,070.50 49.7 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 6,813.75 20,000.00 13,186.25 34.1 01-45-65883 TRI-LAKES CARES .00 .00 5,000.00 5,000.00 .0 01-45-65885 TRI LAKES VIEWS 5,000.00 10,000.00 5,000.00 ( 5,000.00) 200.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 01-45-68355 CAPITAL LEASE PRINCIPAL 241.12 .00 .00 .00 .0 01-45-68356 CAPITAL LEASE INTEREST 38.96 .00 .00 .00 .0 TOTAL ADMINISTRATIVE AND LEGISLATIVE 118,211.41 590,599.29 1,777,179.00 1,186,579.71 33.2 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 9 COURT 01-46-60000 SALARIES 3,280.33 16,401.65 39,634.00 23,232.35 41.4 01-46-60010 OVERTIME PAY 100.00 500.00 1,200.00 700.00 41.7 01-46-60071 STATE UNEMPLOYMENT TAXES 12.92 64.60 155.00 90.40 41.7 01-46-60080 HEALTH & DENTAL INSURANCE 745.83 3,729.15 8,950.00 5,220.85 41.7 01-46-60085 LIFE & DISABILITY INSURANCE 50.00 250.00 600.00 350.00 41.7 01-46-60092 EMPLOYER'S 457 215.17 1,075.85 2,582.00 1,506.15 41.7 01-46-60093 EMPLOYER'S FICA 266.75 1,333.75 3,201.00 1,867.25 41.7 01-46-60094 EMPLOYER'S MEDICARE 62.42 312.10 749.00 436.90 41.7 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-65701 WARRANT/JAIL COST .00 .00 100.00 100.00 .0 01-46-65715 MUNICIPAL COURT JUDGE 500.00 2,500.00 6,000.00 3,500.00 41.7 01-46-65717 PROSECUTING ATTORNEY 1,000.00 5,000.00 12,000.00 7,000.00 41.7 TOTAL COURT 6,233.42 31,245.32 75,371.00 44,125.68 41.5 PLANNING DEPARTMENT 01-49-60000 SALARIES 22,028.84 121,169.30 282,089.00 160,919.70 43.0 01-49-60010 OVERTIME PAY 1,925.52 3,946.02 3,500.00 ( 446.02) 112.7 01-49-60071 STATE UNEMPLOYMENT TAXES 71.86 375.32 846.00 470.68 44.4 01-49-60080 HEALTH & DENTAL INSURANCE 3,616.32 21,885.12 53,529.00 31,643.88 40.9 01-49-60085 LIFE & DISABILITY INSURANCE 296.40 1,754.10 3,535.00 1,780.90 49.6 01-49-60092 EMPLOYER'S 457 1,197.71 6,255.73 14,104.00 7,848.27 44.4 01-49-60093 EMPLOYER'S FICA 1,324.78 6,875.34 17,490.00 10,614.66 39.3 01-49-60094 EMPLOYER'S MEDICARE 309.84 1,607.94 4,090.00 2,482.06 39.3 01-49-60095 PAYROLL & BANK FEES 34.11 170.55 500.00 329.45 34.1 01-49-60098 STAFF TUITITION 569.51 569.51 1,000.00 430.49 57.0 01-49-60099 CODE ENFORCEMENT CONTRACT 2,864.19 6,829.65 19,000.00 12,170.35 36.0 01-49-60230 SUPPLIES - OFFICE/OPERATIONAL 87.14 1,101.01 2,300.00 1,198.99 47.9 01-49-60237 COPIES AND PHOTOS .00 .25 200.00 199.75 .1 01-49-60240 POSTAGE 5.64 38.56 200.00 161.44 19.3 01-49-60245 STORAGE UNIT RENTAL FEES 150.00 600.00 1,800.00 1,200.00 33.3 01-49-60260 DUES AND SUBSCRIPTIONS .00 450.00 1,500.00 1,050.00 30.0 01-49-60300 PUBLIC/LEGAL NOTICES .00 .00 750.00 750.00 .0 01-49-60305 LEGAL SERVICES .00 14.40 10,000.00 9,985.60 .1 01-49-60345 UTILITIES - TELEPHONE 407.65 1,454.62 5,000.00 3,545.38 29.1 01-49-60610 FUEL 168.68 600.51 2,000.00 1,399.49 30.0 01-49-60770 TRAVEL,TRAINING & MEETINGS 2,565.96 5,247.38 9,000.00 3,752.62 58.3 01-49-65710 PROFESSIONAL SERVICES 108.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 954.82 4,487.32 7,200.00 2,712.68 62.3 01-49-68356 CAPITAL LEASE INTEREST 38.97 155.88 2,000.00 1,844.12 7.8 TOTAL PLANNING DEPARTMENT 38,725.94 187,289.92 458,633.00 271,343.08 40.8 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 10 LAW ENFORCEMENT 01-51-60000 SALARIES 99,255.59 489,598.92 1,188,131.00 698,532.08 41.2 01-51-60010 OVERTIME PAY 11,845.66 41,787.80 25,000.00 ( 16,787.80) 167.2 01-51-60020 LONGEVITY RECOGNITION .00 .00 2,000.00 2,000.00 .0 01-51-60071 STATE UNEMPLOYMENT TAXES 330.52 1,586.62 3,564.00 1,977.38 44.5 01-51-60080 HEALTH & DENTAL INSURANCE 12,454.01 79,848.61 208,257.00 128,408.39 38.3 01-51-60084 FPPA FOR D&D .00 .00 25,745.00 25,745.00 .0 01-51-60085 LIFE & DISABILITY INSURANCE 1,099.36 6,578.47 3,496.00 ( 3,082.47) 188.2 01-51-60091 FPPA FOR RETIREMENT 3,669.21 3,669.21 38,023.00 34,353.79 9.7 01-51-60092 EMPLOYER'S 457 1,086.32 21,478.13 16,178.00 ( 5,300.13) 132.8 01-51-60093 EMPLOYER'S FICA 6,429.79 30,561.15 73,664.00 43,102.85 41.5 01-51-60094 EMPLOYER'S MEDICARE 1,503.69 7,147.16 17,228.00 10,080.84 41.5 01-51-60095 PAYROLL & BANK FEES 59.17 295.85 650.00 354.15 45.5 01-51-60098 STAFF TUITITION .00 .00 2,000.00 2,000.00 .0 01-51-60100 WORKERS COMPENSATION INSURANCE .00 1,438.64 1,500.00 61.36 95.9 01-51-60135 DRUG/ALCOHOL TESTING 656.12 1,559.63 3,000.00 1,440.37 52.0 01-51-60145 CONTRACT LABOR JANITORIAL SVC 901.25 4,506.25 10,000.00 5,493.75 45.1 01-51-60147 COLORADO MOUNTED RANGERS .00 .00 1,500.00 1,500.00 .0 01-51-60210 UNIFORMS 784.11 7,106.91 9,500.00 2,393.09 74.8 01-51-60230 SUPPLIES - OFFICE 744.64 2,590.47 7,000.00 4,409.53 37.0 01-51-60231 SUPPLIES-OPERATIONS 678.87 3,775.46 4,900.00 1,124.54 77.1 01-51-60233 EMERGENCY NETWORK FEE 286.00 1,716.00 2,500.00 784.00 68.6 01-51-60234 SUPPLIES-AMMUNITION .00 6,588.16 6,500.00 ( 88.16) 101.4 01-51-60240 POSTAGE 58.13 305.24 400.00 94.76 76.3 01-51-60260 DUES AND SUBSCRIPTIONS 156.25 871.80 3,500.00 2,628.20 24.9 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 1,296.86 3,265.20 7,600.00 4,334.80 43.0 01-51-60342 UTILITIES - GAS 366.47 1,450.39 2,500.00 1,049.61 58.0 01-51-60343 UTILITIES - SANITATION 35.42 106.28 600.00 493.72 17.7 01-51-60345 UTILITIES - TELEPHONE 3,014.23 7,870.03 22,000.00 14,129.97 35.8 01-51-60350 UTILITIES - TRASH PICKUP 104.00 234.00 550.00 316.00 42.6 01-51-60610 FUEL 2,089.82 8,952.80 18,000.00 9,047.20 49.7 01-51-60770 TRAVEL, TRAINING & MEETINGS 2,821.26 4,450.76 12,000.00 7,549.24 37.1 01-51-65380 TACTICAL EQUIPMENT 8,946.93 8,971.93 12,000.00 3,028.07 74.8 01-51-65381 TASER CAMERA CLOUD STORAGE 4,780.50 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 326.77 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 1,003.12 3,849.79 3,000.00 ( 849.79) 128.3 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 12,338.39 .00 ( 12,338.39) .0 01-51-68356 CAPITAL LEASE INTEREST 556.86 556.86 .00 ( 556.86) .0 TOTAL LAW ENFORCEMENT 179,679.32 787,161.85 1,764,347.00 977,185.15 44.6 TOTAL FUND EXPENDITURES 463,456.85 2,164,781.38 5,955,470.00 3,790,688.62 36.4 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 11 NET REVENUE OVER EXPENDITURES ( 68,033.11) 154,217.14 ( 461,854.00) ( 616,071.14) 33.4 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 12 ASSETS 02-00-10100 CASH IN COMBINED CASH FUND 38,987.21 TOTAL ASSETS 38,987.21 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 38,987.21 BALANCE - CURRENT DATE 38,987.21 TOTAL FUND EQUITY 38,987.21 TOTAL LIABILITIES AND EQUITY 38,987.21 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 13 DEPARTMENT 02 02-02-40120 CIP SALES TAX REVENUJE WATER 28,750.00 143,750.00 345,000.00 201,250.00 41.7 02-02-40121 CIP SALES TAX REVENUE GF 32,437.50 162,187.50 389,250.00 227,062.50 41.7 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 305,937.50 2,762,800.00 2,456,862.50 11.1 TOTAL FUND REVENUE 61,187.50 305,937.50 2,762,800.00 2,456,862.50 11.1 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 14 02-02-66045 WELL 4 & 5 TREATMENT PLANT 100,905.94 255,494.67 924,500.00 669,005.33 27.6 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 .00 11,455.62 38,000.00 26,544.38 30.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 100,905.94 266,950.29 2,762,800.00 2,495,849.71 9.7 TOTAL FUND EXPENDITURES 100,905.94 266,950.29 2,762,800.00 2,495,849.71 9.7 NET REVENUE OVER EXPENDITURES ( 39,718.44) 38,987.21 .00 ( 38,987.21) .0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 2A WATER ASD FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 15 ASSETS 04-00-10100 CASH IN COMBINED CASH FUND 599,422.65 04-00-10425 COLOTRUST WATER ASD FUND ACCT 1,368,859.75 TOTAL ASSETS 1,968,282.40 LIABILITIES AND EQUITY FUND EQUITY 04-00-30000 BEGINNING FUND BALANCE - 2A W 1,781,913.29 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 186,369.11 BALANCE - CURRENT DATE 186,369.11 TOTAL FUND EQUITY 1,968,282.40 TOTAL LIABILITIES AND EQUITY 1,968,282.40 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 2A WATER ASD FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 16 04-04-40060 INTEREST INCOME 2A WATER ASD 2,219.06 8,411.59 7,590.00 ( 821.59) 110.8 04-04-40750 SALES TAX - 2A WATER ASD FUND 36,341.26 212,959.86 788,603.00 575,643.14 27.0 TOTAL DEPARTMENT 04 38,560.32 221,371.45 796,193.00 574,821.55 27.8 TOTAL FUND REVENUE 38,560.32 221,371.45 796,193.00 574,821.55 27.8 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 2A WATER ASD FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 17 04-04-60305 LEGAL SERVICES 4,855.30 7,176.34 10,275.00 3,098.66 69.8 04-04-62000 PROFESSIONAL SERVICES - LYTLE 720.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 3,471.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 9,046.30 35,002.34 2,640,123.00 2,605,120.66 1.3 TOTAL FUND EXPENDITURES 9,046.30 35,002.34 2,640,123.00 2,605,120.66 1.3 NET REVENUE OVER EXPENDITURES 29,514.02 186,369.11 ( 1,843,930.00) ( 2,030,299.11) 10.1 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 DEBT SERVICE FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 18 ASSETS 05-00-10100 CASH IN COMBINED CASH FUND 2,293.35 TOTAL ASSETS 2,293.35 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,293.35 BALANCE - CURRENT DATE 2,293.35 TOTAL FUND EQUITY 2,293.35 TOTAL LIABILITIES AND EQUITY 2,293.35 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 DEBT SERVICE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 19 DEBT SERVICE FUND 05-05-40750 SALES TAX WEF - DEBT SVC 12,755.17 63,775.85 153,062.00 89,286.15 41.7 05-05-40751 SALES TAX GENERAL FUND DEBT 12,178.75 60,893.75 146,145.00 85,251.25 41.7 TOTAL DEBT SERVICE FUND 24,933.92 124,669.60 299,207.00 174,537.40 41.7 TOTAL FUND REVENUE 24,933.92 124,669.60 299,207.00 174,537.40 41.7 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 DEBT SERVICE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 20 DEBT SERVICE FUND 05-05-68330 WF CL SERIES 2016 #403-P .00 .00 21,077.00 21,077.00 .0 05-05-68331 WEF CL SERIES 2016 #403-I .00 .00 447.00 447.00 .0 05-05-68332 WEF CL SERIES 2016 #404-P .00 .00 49,247.00 49,247.00 .0 05-05-68333 WEF CL SERIES 2016 #404-I .00 .00 4,816.00 4,816.00 .0 05-05-68349 2018 LOAN PRINCIPAL .00 .00 77,475.00 77,475.00 .0 05-05-68350 GENERAL FUND CL SERIES #403-P 51,576.05 51,576.05 46,914.00 ( 4,662.05) 109.9 05-05-68351 GF CL SERIES 2016 #403-I 2,204.33 2,204.33 995.00 ( 1,209.33) 221.5 05-05-68352 GF CL SERIES #404-P 57,642.80 57,642.80 10,087.00 ( 47,555.80) 571.5 05-05-68353 GF CL SERIES 2016 #404-I 5,631.41 5,631.41 987.00 ( 4,644.41) 570.6 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 560.18 4,815.08 7,790.00 2,974.92 61.8 05-05-68357 GF CL VAR SERVER LEASE -I .00 506.58 .00 ( 506.58) .0 05-05-68358 GF CL SERIES 2018 #406-P .00 .00 29,683.00 29,683.00 .0 TOTAL DEBT SERVICE FUND 117,614.77 122,376.25 299,207.00 176,830.75 40.9 TOTAL FUND EXPENDITURES 117,614.77 122,376.25 299,207.00 176,830.75 40.9 NET REVENUE OVER EXPENDITURES ( 92,680.85) 2,293.35 .00 ( 2,293.35) .0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 COMMUNITY DEVELOPMENT FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 21 ASSETS 31-00-10100 CASH IN COMBINED CASH FUND ( 14,696.54) 31-00-10428 COLOTRUST COMMUNITY DEV FND 31,549.36 TOTAL ASSETS 16,852.82 LIABILITIES AND EQUITY FUND EQUITY 31-00-30000 BEGINNING FUND BALANCE - COMMU 25,451.14 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 8,598.32) BALANCE - CURRENT DATE ( 8,598.32) TOTAL FUND EQUITY 16,852.82 TOTAL LIABILITIES AND EQUITY 16,852.82 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 COMMUNITY DEVELOPMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 22 COMMMUNITY DEVELOPMENT FUND 31-02-40060 INTEREST AND INVESTMENT INCOME 54.79 313.90 450.00 136.10 69.8 31-02-40065 TRANSFER FROM GENERAL FUND .00 .00 20,000.00 20,000.00 .0 31-02-40220 BUSINESS LICENSES-COMMUNITY DE 8,015.00 30,164.45 63,750.00 33,585.55 47.3 31-02-40225 SPONSORSHIP REVENUE 1,500.00 2,000.00 3,000.00 1,000.00 66.7 TOTAL COMMMUNITY DEVELOPMENT FUN 9,569.79 32,478.35 87,200.00 54,721.65 37.3 TOTAL FUND REVENUE 9,569.79 32,478.35 87,200.00 54,721.65 37.3 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 COMMUNITY DEVELOPMENT FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 23 COMMMUNITY DEVELOPMENT FUND 31-02-60230 SUPPLIES - OFFICE/OPERATIONS 104.80 549.50 1,000.00 450.50 55.0 31-02-60260 DUES AND SUBSCRIPTIONS .00 220.00 1,000.00 780.00 22.0 31-02-60770 TRAVEL,TRAINING, MEETINGS 1,942.77 2,842.37 2,000.00 ( 842.37) 142.1 31-02-65371 BROCHURE DEVELOPMENT 4,830.00 4,830.00 5,000.00 170.00 96.6 31-02-65372 BROCHURE DISTRIBUTION 424.90 849.80 10,000.00 9,150.20 8.5 31-02-65373 SOCIAL MEDIA ARCHIVING .00 .00 3,000.00 3,000.00 .0 31-02-65374 ADVERTISING .00 900.00 4,000.00 3,100.00 22.5 31-02-66000 CAPITAL PROJECTS-TBD .00 8,067.00 9,678.00 1,611.00 83.4 31-02-66006 CDF GRANTS - DOWNTOWN .00 .00 5,000.00 5,000.00 .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 .00 .00 5,000.00 5,000.00 .0 31-02-66012 EVENTS, MEETINGS, TRAINING 500.00 500.00 2,000.00 1,500.00 25.0 31-02-66013 TRI LAKES CHAMBER SPONSORSHIP .00 .00 20,000.00 20,000.00 .0 31-02-66015 MOVIE EQUIPMENT PURCHASE 3,677.00 19,022.00 19,775.00 753.00 96.2 31-02-66016 FACADE MURAL GRANT .00 .00 5,000.00 5,000.00 .0 31-02-66018 BINES AND BREWS .00 .00 3,000.00 3,000.00 .0 31-02-66020 FOURTH OF JULY EVENTS .00 .00 8,000.00 8,000.00 .0 31-02-66021 MOVIE NIGHTS 3,046.00 3,046.00 3,600.00 554.00 84.6 31-02-66022 MEMORIAL DAY .00 .00 500.00 500.00 .0 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 14,525.47 41,076.67 112,778.00 71,701.33 36.4 TOTAL FUND EXPENDITURES 14,525.47 41,076.67 112,778.00 71,701.33 36.4 NET REVENUE OVER EXPENDITURES ( 4,955.68) ( 8,598.32) ( 25,578.00) ( 16,979.68) ( 33.6) ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 TRAFFIC IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 24 ASSETS 32-00-10100 CASH IN COMBINED CASH FUND 62,675.91 32-00-10427 COLOTRUST TRAFFIC IMPACT FEE F 144,314.34 TOTAL ASSETS 206,990.25 LIABILITIES AND EQUITY FUND EQUITY 32-00-30000 BEGINNING FUND BALANCE - TRAFF 176,295.33 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 30,694.92 BALANCE - CURRENT DATE 30,694.92 TOTAL FUND EQUITY 206,990.25 TOTAL LIABILITIES AND EQUITY 206,990.25 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 TRAFFIC IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 25 TRAFFIC IMPACT FEE FUND 32-10-40060 INTEREST INCOME 332.56 1,287.29 2,000.00 712.71 64.4 32-10-40460 TRAFFIC IMPACT FEES .00 13,146.63 50,000.00 36,853.37 26.3 32-10-40461 LOR SPECIAL IMPACT FEES PD 4,949.00 16,261.00 95,000.00 78,739.00 17.1 TOTAL TRAFFIC IMPACT FEE FUND 5,281.56 30,694.92 147,000.00 116,305.08 20.9 TOTAL FUND REVENUE 5,281.56 30,694.92 147,000.00 116,305.08 20.9 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 TRAFFIC IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM 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 5,281.56 30,694.92 ( 180,329.00) ( 211,023.92) 17.0 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 STORM DRAINAGE IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 27 ASSETS 35-00-10100 CASH IN COMBINED CASH FUND 4,484.26 35-00-10429 COLOTRUST STORM DRAINAGE IMPAC 37,371.11 TOTAL ASSETS 41,855.37 LIABILITIES AND EQUITY FUND EQUITY 35-00-30000 BEGINNING FUND BALANCE - STORM 8,139.82 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 33,715.55 BALANCE - CURRENT DATE 33,715.55 TOTAL FUND EQUITY 41,855.37 TOTAL LIABILITIES AND EQUITY 41,855.37 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 STORM DRAINAGE IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 28 STORM DRAINAGE IMPACT FEE FUND 35-35-40060 INTEREST INCOME 63.69 164.80 100.00 ( 64.80) 164.8 35-35-41010 STORM DRAINAGE IMPACT FEES .00 26,399.54 40,000.00 13,600.46 66.0 35-35-41011 IMPACT FEES LOR 5,440.30 18,469.32 50,000.00 31,530.68 36.9 TOTAL STORM DRAINAGE IMPACT FEE FUN 5,503.99 45,033.66 90,100.00 45,066.34 50.0 TOTAL FUND REVENUE 5,503.99 45,033.66 90,100.00 45,066.34 50.0 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 STORM DRAINAGE IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 29 STORM DRAINAGE IMPACT FEE FUND 35-35-60770 TRAVEL, TRAINING AND MEETINGS 120.25 299.71 5,000.00 4,700.29 6.0 35-35-66000 STORMWATER DRAINAGE REPAIRS 612.97 11,018.40 112,945.00 101,926.60 9.8 TOTAL STORM DRAINAGE IMPACT FEE FUN 733.22 11,318.11 117,945.00 106,626.89 9.6 TOTAL FUND EXPENDITURES 733.22 11,318.11 117,945.00 106,626.89 9.6 NET REVENUE OVER EXPENDITURES 4,770.77 33,715.55 ( 27,845.00) ( 61,560.55) 121.1 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 30 ASSETS 61-00-10100 CASH IN COMBINED CASH FUND 351,230.97 61-00-10230 WELLS FARGO-WATER DEPOSITS 20,600.00 61-00-10740 COLOTRUST WATER ENTERPRISE FUN 285,115.05 61-00-10745 COLOTRUST MLWS ESCROW 678,010.18 61-00-11750 UTILITY CASH CLEARING 10,514.29 61-00-14010 A/R-WATER 139,544.82 61-00-14500 WATER PAYMENT CONTRACTS REC ( 1,084.50) 61-00-15000 PREPAID EXPENSE ( 2,932.87) 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,603,685.72 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 531,910.70 BALANCE - CURRENT DATE 531,910.70 TOTAL FUND EQUITY 9,370,465.16 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 WATER FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 31 TOTAL LIABILITIES AND EQUITY 9,603,685.72 ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 32 61-15-40060 INTEREST AND INVESTMENT INCOME 1,675.71 6,779.17 9,944.00 3,164.83 68.2 61-15-46100 WATER REVENUE - RESIDENTIAL SA 73,503.01 282,204.41 918,352.00 636,147.59 30.7 61-15-46105 WATER REVENUE - COMMERCIAL SAL 48,226.81 211,315.88 670,479.00 459,163.12 31.5 61-15-46110 WATER REVENUE - BULK SALES 1,999.52 4,389.61 13,325.00 8,935.39 32.9 61-15-46111 LATE FEES 2,052.50 10,602.50 24,447.00 13,844.50 43.4 61-15-46115 SALES TAX-WATER FUND 17,705.03 88,142.55 192,992.00 104,849.45 45.7 61-15-46250 OTHER REVENUES 5.14 5.14 .00 ( 5.14) .0 61-15-48078 LOR WATER TAP IMPACT FEES 74,851.00 280,271.00 225,000.00 ( 55,271.00) 124.6 61-15-48080 WATER REVENUE - IMPACT FEES .00 126,520.00 90,000.00 ( 36,520.00) 140.6 61-15-48081 WATER METER IMPACT FEES 3,290.00 23,277.00 15,050.00 ( 8,227.00) 154.7 TOTAL DEPARTMENT 15 223,308.72 1,033,507.26 2,159,589.00 1,126,081.74 47.9 TOTAL FUND REVENUE 223,308.72 1,033,507.26 2,159,589.00 1,126,081.74 47.9 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 33 61-15-60000 SALARIES 34,634.44 185,380.72 519,792.00 334,411.28 35.7 61-15-60010 OVERTIME PAY 92.26 2,063.54 10,000.00 7,936.46 20.6 61-15-60019 LONGEVITY RECOGNITION .00 .00 500.00 500.00 .0 61-15-60020 ON-CALL/STANDBY PAY 300.00 3,200.00 11,500.00 8,300.00 27.8 61-15-60071 STATE UNEMPLOYMENT TAXES 105.08 571.71 1,559.00 987.29 36.7 61-15-60080 HEALTH & DENTAL INSURANCE 7,319.56 43,139.91 117,362.00 74,222.09 36.8 61-15-60085 LIFE & DISABILITY INSURANCE 469.00 2,689.50 6,389.00 3,699.50 42.1 61-15-60092 EMPLOYER'S 457 1,541.98 8,339.70 25,990.00 17,650.30 32.1 61-15-60093 EMPLOYER'S FICA 1,947.80 10,608.46 32,227.00 21,618.54 32.9 61-15-60094 EMPLOYER'S MEDICARE 455.53 2,480.96 7,537.00 5,056.04 32.9 61-15-60095 BANK FEES FOR PSN PAYMENTS 119.55 1,131.66 .00 ( 1,131.66) .0 61-15-60096 PAYROLL & BANK FEES 59.17 295.85 850.00 554.15 34.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 29,018.75 72,195.00 43,176.25 40.2 61-15-60100 WORKERS COMPENSATION INSURANCE 2,748.35 14,241.75 24,985.00 10,743.25 57.0 61-15-60125 PAYMENT IN LIEU OF 5% FF 8,594.47 42,972.35 103,136.00 60,163.65 41.7 61-15-60130 GENERAL INSURANCE 3,294.64 16,473.20 29,618.00 13,144.80 55.6 61-15-60135 DRUG/ALCOHOL TESTING 190.00 621.40 800.00 178.60 77.7 61-15-60200 SAFETY EQUIPMENT 463.82 2,349.49 3,000.00 650.51 78.3 61-15-60210 UNIFORMS 178.60 755.91 2,700.00 1,944.09 28.0 61-15-60220 SMALL TOOLS 36.92 66.70 500.00 433.30 13.3 61-15-60229 SUPPLIES-SHOP OPERATIONS .00 652.25 1,800.00 1,147.75 36.2 61-15-60231 SUPPLIES-OPERATIONS/OFFICE 493.03 1,197.53 5,000.00 3,802.47 24.0 61-15-60250 WATER BILLING EXPENSE 618.58 3,574.86 9,500.00 5,925.14 37.6 61-15-60260 DUES AND SUBSCRIPTIONS 1,625.00 3,753.88 15,000.00 11,246.12 25.0 61-15-60300 PUBLIC/LEGAL NOTICES .00 .00 1,000.00 1,000.00 .0 61-15-60305 LEGAL SERVICES 3,246.70 7,284.93 40,000.00 32,715.07 18.2 61-15-60341 UTILITIES - ELECTRIC 19,088.16 50,724.99 167,000.00 116,275.01 30.4 61-15-60342 UTILITIES - GAS 332.62 1,904.81 4,500.00 2,595.19 42.3 61-15-60343 UTILITIES - SANITATION 1,653.29 3,637.82 12,000.00 8,362.18 30.3 61-15-60345 UTILITIES - TELEPHONE 1,118.89 3,467.22 12,000.00 8,532.78 28.9 61-15-60355 REPAIR & MAINTENANCE - DAM 140.40 144.64 6,000.00 5,855.36 2.4 61-15-60400 CHEMICALS/GAS-WATER TREATMENT 883.32 3,545.36 60,400.00 56,854.64 5.9 61-15-60610 FUEL 371.68 1,983.45 6,000.00 4,016.55 33.1 61-15-60700 REPAIR & MAINTENANCE TEST: WAT 1,201.21 2,748.86 12,500.00 9,751.14 22.0 61-15-60720 UNCC MEMBERSHIP - LOCATES 111.65 391.50 1,000.00 608.50 39.2 61-15-60750 ACCOUNTING/AUDIT SERVICES .00 .00 6,000.00 6,000.00 .0 61-15-60770 TRAVEL, TRAINING & MEETINGS 698.46 3,210.05 10,000.00 6,789.95 32.1 61-15-60772 EMPLOYEE MILEAGE ( 100.00) .00 .00 .00 .0 61-15-65375 RENTAL MACHINERY & EQUIPMENT 91.40 591.40 1,000.00 408.60 59.1 61-15-65390 REPAIR & MAINTENANCE - VEHICLE 663.67 3,901.25 3,800.00 ( 101.25) 102.7 61-15-65395 REPAIR & MAINTENANCE - EQUIPME .00 .00 2,500.00 2,500.00 .0 61-15-65400 REPAIR & MAINTENANCE - WELL SI 17.16 2,692.03 40,000.00 37,307.97 6.7 61-15-65403 REPAIR & MAINTENANCE - BOOSTE .00 .00 2,000.00 2,000.00 .0 61-15-65410 REPAIR & MAINTENANCE - DISTRIB 1,293.48 5,689.61 20,000.00 14,310.39 28.5 61-15-65420 REPAIR & MAINTENANCE-STORAGE T 323.97 1,923.97 2,750.00 826.03 70.0 61-15-65430 REPAIR & MAINTENANCE-WATER MET 4,731.94 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 .00 7,574.51 70,000.00 62,425.49 10.8 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 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 34 61-15-66039 DISTRIBUTION LINE R&M .00 .00 25,325.00 25,325.00 .0 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 13,757.38 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 120,716.91 501,596.56 1,691,065.00 1,189,468.44 29.7 TOTAL FUND EXPENDITURES 120,716.91 501,596.56 1,691,065.00 1,189,468.44 29.7 NET REVENUE OVER EXPENDITURES 102,591.81 531,910.70 468,524.00 ( 63,386.70) 113.5 ---PAGE BREAK--- TOWN OF MONUMENT BALANCE SHEET MAY 31, 2018 CONSERVATION TRUST FUND FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 35 ASSETS 82-00-10100 CASH IN COMBINED CASH FUND ( 15,813.14) 82-00-10422 COLOTRUST CONSERVATION TRUST F 3,128.04 TOTAL ASSETS ( 12,685.10) LIABILITIES AND EQUITY FUND EQUITY 82-00-30000 BEGINNING FUND BALANCE - CONSE 3,107.75 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 15,792.85) BALANCE - CURRENT DATE ( 15,792.85) TOTAL FUND EQUITY ( 12,685.10) TOTAL LIABILITIES AND EQUITY ( 12,685.10) ---PAGE BREAK--- TOWN OF MONUMENT REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 CONSERVATION TRUST FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 36 CONSERVATION TRUST FUND 82-08-40060 INTEREST INCOME 5.48 20.29 50.00 29.71 40.6 82-08-41020 CTF - LOTTERY - PMT .00 9,641.76 40,000.00 30,358.24 24.1 TOTAL CONSERVATION TRUST FUND 5.48 9,662.05 40,050.00 30,387.95 24.1 TOTAL FUND REVENUE 5.48 9,662.05 40,050.00 30,387.95 24.1 ---PAGE BREAK--- TOWN OF MONUMENT EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2018 CONSERVATION TRUST FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 41 % OF THE FISCAL YEAR HAS ELAPSED 07/19/2018 05:40PM PAGE: 37 CONSERVATION TRUST FUND 82-08-66000 TRAIL REPAIRS & IMPROVEMENTS 10,239.26 10,239.26 .00 ( 10,239.26) .0 82-08-66001 PARKS & OPEN SPACE IMPROVEMENT 2,658.28 15,215.64 43,934.00 28,718.36 34.6 TOTAL CONSERVATION TRUST FUND 12,897.54 25,454.90 43,934.00 18,479.10 57.9 TOTAL FUND EXPENDITURES 12,897.54 25,454.90 43,934.00 18,479.10 57.9 NET REVENUE OVER EXPENDITURES ( 12,892.06) ( 15,792.85) ( 3,884.00) 11,908.85 (406.6)