Page 1 of 46
Page 1 of 46
Page 2 of 46
Page 3 of 46
Page 4 of 46
Page 5 of 46
Page 6 of 46
Page 7 of 46
Page 8 of 46
Page 9 of 46
Page 10 of 46
Page 11 of 46
Page 12 of 46
Page 13 of 46
Page 14 of 46
Page 15 of 46
Page 16 of 46
Page 17 of 46
Page 18 of 46
TOWN OF GRAND LAKE COMBINED CASH INVESTMENT JUNE 30, 2016 COMBINED CASH ACCOUNTS 01-101000 GMB CHECKING - OPERATIONS
5,754.94
01-105000 GMB MONEY MARKET
1,487,315.08
01-106000 RETURNED CHECK CLEARING ACCT
.00
01-107500 UTILITY CASH CLEARING ACCT
870.87
TOTAL COMBINED CASH
1,493,940.89
01-100000 CASH ALLOCATED TO OTHER FUNDS
(
1,493,940.89)
TOTAL UNALLOCATED CASH
.00
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
501,257.35
20 ALLOCATION TO WATER FUND
632,526.61
40 ALLOCATION TO MARINA FUND
288,581.87
50 ALLOCATION TO PAY-AS-YOU-THROW FUND
71,575.06
TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 01-100000
1,493,940.89 (
1,493,940.89)
ZERO PROOF IF ALLOCATIONS BALANCE
.00
50 % OF THE FISCAL YEAR HAS ELAPSED
1
Page 19 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 GENERAL FUND ASSETS 10-100000 CASH IN COMBINED CASH FUND
501,257.35
10-103000 CSAFE
185,924.67
10-106000 ADVANTAGE BANK - CD
100,140.65
10-109100 COLOTRUST
302,707.84
10-109200 DEVELOPER LOC CHECKING
16,427.47
10-110000 FLATIRONS BANK - CD
96,000.00
10-116000 PETTY CASH
250.00
10-116500 GLC PETTY CASH
50.00
10-117000 ACCOUNTS RECEIVABLE
.00
10-117100 PROPERTY TAXES RECEIVABLE
241,557.00
10-118000 ACCRUED INT RECEIVABLE-MARINA
.00
10-123000 DUE TO G.L. FROM CUSTOMERS
1,058.23
10-129000 UNLEADED GAS INVENTORY
1,973.24
10-130000 DIESEL INVENTORY
1,917.93
10-131000 DUE FROM WATER FUND
.00
10-131001 DUE FROM MARINA FUND
.00
10-131002 DUE FROM PAYT
.00
10-132000 MARINA LOAN PRINCIPAL
.00
10-132001 MARINA LOAN PRINCIPAL-CURRENT
.00
10-150100 GILL CAPITAL PARTNERS: BONDS
100,000.11
TOTAL ASSETS
1,549,264.49
LIABILITIES AND EQUITY
LIABILITIES 10-200000 ACCOUNTS PAYABLE GENERAL
83,635.91
10-217000 WAGES PAYABLE
.00
10-217100 SOCIAL SECURITY WITHHOLDING
.00
10-217200 FEDERAL W/H PAYABLE
.00
10-217300 STATE W/H PAYABLE
.00
10-217400 MEDICARE WITHHOLDING
.00
10-218100 HEALTH/DENTAL/VISION
(
10-219100 FLEX MEDICAL
787.85) 619.74
10-220000 ICMA W/H PAYABLE
.00
10-221000 ICMA EMP LOAN PAYABLE
.00
10-221001 ICMA/ROTH IRA
.00
10-221100 GARNISHMENT
.00
10-222000 DEFERRED REVENUE-PROPERTY TAX 10-223180 PREPAID NRL
241,557.00 .00
10-226000 USE TAX DEFERRED REVENUE
64,200.03
10-228000 DEVELOPER LOC FUNDS
16,427.47
10-232000 DUE TO WATER FROM GF
.00
10-233000 DUE TO MARINA FROM GF
.00
10-241355 DEF REV PARK AVE BOARDWALK
12,629.78
TOTAL LIABILITIES
418,282.08
50 % OF THE FISCAL YEAR HAS ELAPSED
2
Page 20 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 GENERAL FUND FUND EQUITY 10-270000 PARKING FEE-IN-LIEU
.00
10-275000 FUND BALANCE
908,005.29
10-281000 CEMETERY DESIGNATED FUND BALAN
50,501.07
10-284000 ATTAIN HOUSING DESG FUND BALAN
352,791.68
10-285000 FUND BAL RESVD - INV & PRE PDS
2,899.17
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
183,214.80) (
183,214.80)
TOTAL FUND EQUITY
1,130,982.41
TOTAL LIABILITIES AND EQUITY
1,549,264.49
50 % OF THE FISCAL YEAR HAS ELAPSED
3
Page 21 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
GENERAL TAXES 10-311-100 PROPERTY TAXES 10-311-110 SPECIFIC OWNERSHIP 10-311-120 INTEREST & PENALTY-PROP TAXES 10-311-130 MOTOR VEHICLE USE TAX 10-311-140 SALES TAX 10-311-150 BUILDING USE TAX 10-311-160 CIGARETTES-SELECT SALES TAX TOTAL GENERAL TAXES
31,305.54
186,817.68
241,557.00
54,739.32
77.3
1,284.53
6,018.87
14,000.00
7,981.13
43.0
34.50
500.00
530.88
.00
(
11,854.99
30.88)
20,000.00
8,145.01
(
59.3
6.2)
26,769.10
161,061.26
1,164,718.00
1,003,656.74
13.8
.00
.00
30,000.00
30,000.00
.0
320.58
1,374.39
3,000.00
1,625.61
45.8
59,714.25
367,096.31
1,473,775.00
1,106,678.69
24.9
UTILITY FRANCHISES 10-316-170 CABLE FRANCHISE FEES
.00
.00
16,000.00
16,000.00
.0
10-316-171 TELEPHONE FRANCHISE
1,005.00
2,010.00
4,224.00
2,214.00
47.6
10-316-172 ELECTRIC FRANCHISE 10-316-173 NATURAL GAS FRANCHISE TOTAL UTILITY FRANCHISES
.00
9,373.88
30,000.00
20,626.12
31.3
968.15
5,427.47
14,000.00
8,572.53
38.8
1,973.15
16,811.35
64,224.00
47,412.65
26.2
LICENSES & PERMITS 648.75
4,910.00
2,000.00
2,910.00)
245.5
10-321-110 BUSINESS LICENSE - 95%
10-321-100 LIQUOR LICENSE
.00
.00
.00
(
.00
.0
10-321-115 NIGHTLY RENTAL LICENSE - 95%
.00
.00
.00
.00
.0
10-321-120 TOWN SALES TAX LICENSE
115.00
145.00
400.00
255.00
36.3
10-321-130 MOTOR VEHICLE LICENSE
218.00
767.50
2,000.00
1,232.50
38.4
10-321-140 SIGN PERMIT
25.00
75.00
350.00
275.00
21.4
10-321-150 GRADING PERMIT
70.00
105.00
50.00
(
55.00)
210.0
5.00
135.00
100.00
(
35.00)
135.0
515.00
535.00
300.00
(
235.00)
178.3
8,641.50
9,771.00
29,000.00
19,229.00
33.7
.00
30,000.00
30,000.00
.00
100.0
10,238.25
46,443.50
64,200.00
17,756.50
72.3
10-321-160 ANIMAL LICENSE 10-321-170 ENCROACHMENT PERMIT/LICENSE 10-321-175 BUSINESS LICENSE COMMISSION 10-321-180 NIGHTLY RENTAL LICENSE TOTAL LICENSES & PERMITS
50 % OF THE FISCAL YEAR HAS ELAPSED
4
Page 22 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
GRANTS 10-334-201 GRAND LAKE HISTORICAL ASSOC
.00
.00
.00
.00
10-334-202 CO STATE HISTORICAL FUND
.00
.00
.00
.00
.0 .0
10-334-203 DOLA CCRA
.00
.00
.00
.00
.0
10-334-204 GOCO SNOWMOBILE BRIDGE
.00
.00
.00
.00
.0
10-334-205 PARKS & WILDLIFE GRANT
.00
.00
.00
.00
.0
10-334-206 GOCO PLANNING GRANT
.00
.00
.00
.00
.0
10-334-207 DOLA ADMIN GRANT
.00
.00
.00
.00
.0
10-334-208 NWCCOG TECH. ASSIST. GRANT
.00
.00
.00
.00
.0
10-334-209 DOLA ADMIN GRANT - MP PATH
.00
.00
10,000.00
10,000.00
.0
.00
.00
10,000.00
10,000.00
.0
TOTAL GRANTS
INTERGOVERNMENTAL REVENUES 10-335-100 FUEL DEPOT CLEAN-UP
.00
.00
.00
.00
.0
10-335-130 GRAND CNTY ROAD & BRIDGE
.00
3,168.00
6,336.00
3,168.00
50.0
2,598.52
12,700.10
30,063.00
17,362.90
42.2
873.99
1,420.56
2,000.00
579.44
71.0
.00
.00
4,000.00
4,000.00
.0
3,472.51
17,288.66
42,399.00
25,110.34
40.8
10-335-200 HIGHWAY USER TAX FUND 10-335-800 CONSERVATION TRUST FUND 10-335-900 OTHER INTERGOVERNMENTAL TOTAL INTERGOVERNMENTAL REVENUES
CHARGES FOR SERVICES 10-341-100 COURT FEES 10-341-200 CEMETERY 10-341-201 HEADSTONE DEPOSIT
.00
.00
50.00
2,800.00
6,450.00
5,000.00
50.00
.0
(
1,450.00)
129.0
400.00
1,600.00
1,600.00
.00
100.0
10-341-300 ZONING & SUBDIVISION REVIEW
1,135.00
4,959.00
4,000.00
(
959.00)
124.0
10-341-400 ATTAINABLE HOUSING FEE
1,874.00
20,923.50
20,000.00
(
923.50)
104.6
.00
308.56
1,100.00
791.44
28.1
3.00
7.25
50.00
42.75
14.5
150.00
300.00
300.00
.00
100.0
6,362.00
34,548.31
32,100.00
(
2,448.31)
107.6
10-341-600 FUEL DEPOT SURCHARGE 10-341-700 COPIES/FAXES/SODA 10-341-850 NIGHTLY RENTAL APPLICATION FEE TOTAL CHARGES FOR SERVICES
GRAND LAKE CENTER 10-350-100 GL CENTER - RENTS
385.00
5,105.00
.00
(
5,105.00)
.0
10-350-110 GL CENTER - MERCH SALES
280.00
2,158.00
.00
(
2,158.00)
.0
.00
5,376.50
.00
(
5,376.50)
.0
665.00
12,639.50
.00
(
12,639.50)
.0
10-350-200 GL CENTER - DONATIONS TOTAL GRAND LAKE CENTER
50 % OF THE FISCAL YEAR HAS ELAPSED
5
Page 23 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
FINES 10-351-100 ORDINANCE/TRAFFIC FINES TOTAL FINES
100.00
100.00
500.00
400.00
20.0
100.00
100.00
500.00
400.00
20.0
745.88
3,239.24
4,000.00
760.76
81.0
.00
.00
.00
.00
.0
945.00
4,190.00
3,000.00
1,190.00)
139.7
MISCELLANEOUS 10-360-100 INTEREST REVENUE 10-360-110 SALE OF ASSETS 10-360-140 RENT - LAND, BUILDINGS 10-360-160 RENT - ENTERPRISE FUND SITES 10-360-180 RENT - VISITORS CENTER 10-360-190 GIFTS - DONATIONS 10-360-200 MISC. REVENUES - GENERAL
(
.00
.00
2.00
2.00
.0
625.00
1,250.00
2,500.00
1,250.00
50.0
.00
.00
1,200.00
4,584.25
19,408.78
5,000.00
(
1,200.00
.0
14,408.78)
388.2 .0
10-360-210 5% BUSINESS LICENSE FEE
.00
.00
.00
.00
10-360-220 5% NIGHTLY RENTAL LICENSE
.00
.00
.00
.00
.0
10-360-230 MEMORIAL BENCHES
.00
2,060.00
.00
2,060.00)
.0
(
10-360-300 MARINA LOAN PRINCIPAL PAYMENT
.00
.00
.00
.00
.0
10-360-320 DPA LOAN REPAYMENT
.00
.00
.00
.00
.0
10-360-350 DEVELOPER LETTER OF CREDIT
.00
.00
16,987.00
16,987.00
.0
6,900.13
30,148.02
32,689.00
2,540.98
92.2
.0
TOTAL MISCELLANEOUS
CAPITAL SPECIFIC REVENUE 10-377-100 CAPITAL LEASE PROCEEDS
.00
.00
.00
.00
10-377-150 CDOT OFF-SYSTEM BRIDGE PROGRAM
.00
.00
694,080.00
694,080.00
.0
10-377-151 W. PORTAL BRIDGE FUNDING
.00
.00
100,000.00
100,000.00
.0
10-377-152 STATE HISTORIC FUND-COMM HOUSE
.00
.00
.00
.00
.0
10-377-153 DOLA ADMIN GRANT
.00
.00
.00
.00
.0
10-377-154 FISHING IS FUN
.00
.00
24,000.00
24,000.00
.0
10-377-155 DOLA TIER 1 GRANT
.00
.00
22,000.00
22,000.00
.0
3,000.00
3,000.00
8,260.00
5,260.00
36.3
.00
.00
73,520.00
73,520.00
.0
3,000.00
3,000.00
921,860.00
918,860.00
.3
92,425.29
528,075.65
2,641,747.00
2,113,671.35
20.0
10-377-156 EV CHARGING STATION 10-377-157 DOLA TIER 1 - W. PORTAL BRIDGE TOTAL CAPITAL SPECIFIC REVENUE
TOTAL FUND REVENUE
50 % OF THE FISCAL YEAR HAS ELAPSED
6
Page 24 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
CEMETERY COMMITTEE 10-410-211 GENERAL SUPPLIES/MISC EXPENSES 10-410-215 GRAVE MARKERS 10-410-242 GENERAL MAINTENANCE TOTAL CEMETERY COMMITTEE
7.47
7.47
3,500.00
3,492.53
.2
600.00
600.00
2,600.00
2,000.00
23.1
.00
.00
3,000.00
3,000.00
.0
607.47
607.47
9,100.00
8,492.53
6.7
P.O.S.T. COMMITTEE 10-411-319 POST COMMITTEE-MISC EXP
.00
.00
.00
.00
.0
10-411-320 POST PLAN
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
10-412-211 GENERAL OFFICE SUPPLIES
.00
.00
1,000.00
1,000.00
.0
10-412-215 COMPUTER SOFTWARE
.00
.00
.00
.00
.0
10-412-311 POSTAGE/ADS/LEGAL NOTICES
.00
.00
800.00
800.00
.0
10-412-314 PURCHASED SERVICES
.00
.00
.00
.00
.0
10-412-319 MISC.-PLANNING COMMISSION/BOA
.00
.00
100.00
100.00
.0
10-412-320 COMPUTER HARDWARE
.00
.00
.00
.00
.0
10-412-351 PLANNING LEGAL SERVICES
.00
.00
1,000.00
1,000.00
.0
10-412-360 STATE HISTORICAL FUND SURVEY
.00
.00
.00
.00
.0
10-412-361 DOWNTOWN DEVELOPMENT STUDY
.00
.00
.00
.00
.0
10-412-365 FEDERAL LANDS LIVABILITY INITI
.00
.00
.00
.00
.0
10-412-370 TRAINING/TRAVEL
.00
64.00
400.00
336.00
16.0
10-412-380 COMP PLAN UPDATE
.00
.00
.00
.00
.0
.00
64.00
3,300.00
3,236.00
1.9
TOTAL P.O.S.T. COMMITTEE
PC/BOA
TOTAL PC/BOA
50 % OF THE FISCAL YEAR HAS ELAPSED
7
Page 25 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
BOARD OF TRUSTEES 10-413-215 ELECTIONS
.00
554.41
3,500.00
2,945.59
15.8
10-413-316 DUES/MEMBERSHIPS
.00
4,687.00
7,117.00
2,430.00
65.9
2,992.41
4,425.79
5,600.00
1,174.21
79.0
.00
3,000.00
3,000.00
.00
100.0
10-413-460 LONG RANGE/MISC
49.99
363.58
700.00
336.42
51.9
10-413-461 APPRECIATION PROGRAM
80.54
394.31
3,500.00
3,105.69
11.3
10-413-462 COMPUTER EQUIPMENT
.00
2,992.93
3,000.00
7.07
99.8
10-413-463 WATER QUALITY ISSUES
.00
.00
1,500.00
1,500.00
.0
10-413-465 COMPUTER SOFTWARE
.00
.00
300.00
300.00
.0
10-413-470 SECURITY CAMERAS
.00
.00
.00
.00
.0
10-413-370 TRAINING/TRAVEL 10-413-452 HEADWATER TRAILS ALLIANCE
10-413-480 RMNP CENTENNIAL
.00
.00
.00
.00
.0
10-413-722 GRAND LAKE TRAILGROOMING
.00
.00
20,000.00
20,000.00
.0
10-413-723 GRAND LAKE HISTORICAL SOCIETY 10-413-728 MISCELLANEOUS DONATIONS
.00
.00
3,500.00
3,500.00
.0
250.00
1,450.00
2,500.00
1,050.00
58.0
10-413-731 GRND CNTY COUNCIL ON AGING
.00
3,500.00
3,500.00
.00
100.0
10-413-782 ADVOCATES
.00
1,500.00
1,500.00
.00
100.0
10-413-793 GL FIREWORKS
11,000.00
11,000.00
11,000.00
.00
100.0
10-413-796 MOUNTAIN FAMILY CENTER
.00
2,500.00
2,500.00
.00
100.0
10-413-843 ROCKY MTN REP THEATRE
.00
.00
1,500.00
1,500.00
.0
10-413-845 GC RURAL HEALTH NETWORK
.00
1,000.00
1,000.00
.00
100.0 .0
10-413-846 HEART OF THE MTNS HOSPICE
.00
.00
2,500.00
2,500.00
10-413-847 SHINING STARS FOUNDATION
.00
.00
1,500.00
1,500.00
.0
10-413-848 GRAND COUNTY LIBRARY DISTRICT
.00
.00
.00
.00
.0
10-413-850 GRAND LAKE YACHT CLUB SAILING
.00
.00
250.00
250.00
.0
10-413-851 EXPERIMENTAL AIRCRAFT ASSOC.
.00
.00
80.00
80.00
.0 .0
10-413-852 GRAND ANGELS
.00
.00
4,500.00
4,500.00
10-413-853 MISC FUNDRAISER TOUR CERTS
.00
.00
240.00
240.00
.0
10-413-854 GC SEARCH & RESCUE
.00
.00
1,000.00
1,000.00
.0
10-413-855 GL US CONSTITUTION WEEK
.00
4,000.00
4,000.00
.00
100.0
10-413-856 GRAND ENTERPRISE INITIATIVE
.00
.00
1,000.00
1,000.00
.0
10-413-857 FRIENDS OF TRAIL RIVER RANCH
.00
.00
.00
.00
.0
10-413-858 WARRIOR BONFIRE PROJECT
.00
.00
.00
.00
.0
10-413-870 BOARD CONTINGENCY
.00
.00
500.00
500.00
.0
10-413-999 TABOR REQ'D EMERGENCY RESERVE
.00
.00
57,566.00
57,566.00
.0
14,372.94
41,368.02
148,353.00
106,984.98
27.9
24.1
TOTAL BOARD OF TRUSTEES
GREENWAYS COMMITTEE 10-414-211 GENERAL SUPPLIES 10-414-238 TREES/SHRUBS/PLANTINGS 10-414-241 ARBOR DAY SUPPLIES 10-414-245 GRND GARDENS 10-414-319 CONTRACT LABOR
82.16
361.22
1,500.00
1,138.78
1,781.98
1,798.97
5,000.00
3,201.03
36.0
.00
169.60
500.00
330.40
33.9
.00
.00
500.00
500.00
.0
5,541.17
11,082.34
33,247.00
22,164.66
33.3
10-414-726 MISCELLANEOUS SERVICES
.00
.00
200.00
200.00
.0
10-414-870 CONTINGENCY
.00
.00
250.00
250.00
.0
7,405.31
13,412.13
41,197.00
27,784.87
32.6
TOTAL GREENWAYS COMMITTEE
50 % OF THE FISCAL YEAR HAS ELAPSED
8
Page 26 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
ADMINISTRATION 10-415-100 GROSS WAGES - ADMINISTRATION
21,604.03
107,532.69
199,070.00
91,537.31
192.00
957.00
1,138.00
181.00
84.1
10-415-132 ICMA TOWN PAID BENEFIT
1,107.90
6,404.96
15,526.00
9,121.04
41.3
10-415-133 HEALTH/DENTAL-EMPLOYEE
2,525.77
18,121.48
37,352.00
19,230.52
48.5
8.56
208.13
20,209.00
20,000.87
1.0
1,322.63
2,265.34
3,741.00
1,475.66
60.6
162.24
330.45
646.00
315.55
51.2
.00
251.22
538.00
286.78
46.7 50.6
10-415-131 LONGEVITY BENEFIT
10-415-135 DEP HEALTH/DENTAL 10-415-136 MEDICAL BENEFIT ALLOWANCE 10-415-141 UNEMPLOYMENT INSURANCE 10-415-142 WORKER'S COMPENSATION 10-415-143 SOCIAL SECURITY MATCH
54.0
1,403.59
6,766.63
13,363.00
6,596.37
10-415-144 MEDICARE MATCH
328.27
1,582.44
3,126.00
1,543.56
50.6
10-415-211 GENERAL OFFICE SUPPLIES
685.36
2,351.57
3,500.00
1,148.43
67.2
10-415-215 COMPUTER SOFTWARE
382.97
487.91
5,000.00
4,512.09
9.8
10-415-220 COMPUTER HARDWARE
4,234.11
4,234.11
6,000.00
1,765.89
70.6
10-415-224 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
165.83
994.98
2,000.00
1,005.02
49.8
66.41
718.86
2,400.00
1,681.14
30.0
.00
27.19
400.00
372.81
6.8
178.52
772.64
1,600.00
827.36
48.3
10-415-237 BUILDING MAINTENANCE
.00
729.13
1,000.00
270.87
72.9
10-415-238 TOWN HALL FURNISHINGS
.00
235.48
1,750.00
1,514.52
13.5
10-415-252 RESALE SUPPLIES
.00
.00
50.00
50.00
.0
10-415-311 POSTAGE/FREIGHT
556.99
2,231.86
4,000.00
1,768.14
55.8
10-415-312 COMPUTER SERVICES
210.00
7,217.50
14,230.00
7,012.50
50.7
10-415-314 ADS & LEGAL NOTICES
59.26
924.59
1,000.00
75.41
92.5
10-415-226 SMALL EQUIPMENT 10-415-231 GAS/FUEL 10-415-232 VEHICLE MAINTENANCE 10-415-233 OFFICE EQUIPMENT MAINTENANCE
10-415-316 DUES & MEMBERSHIPS 10-415-317 BANK FEES 10-415-318 JANITORIAL SERVICES 10-415-319 MISCELLANEOUS SERVICES 10-415-341 ELECTRIC UTILITY 10-415-342 SEWER UTILITY 10-415-343 WATER UTILITY 10-415-344 TELEPHONE UTILITY 10-415-345 NATURAL GAS UTILITY 10-415-346 INTERNET SERVICES 10-415-347 RECYCLING - TOWN HALL 10-415-351 LEGAL SERVICES 10-415-352 AUDIT
.00
1,070.28
1,500.00
429.72
71.4
5.00
60.00
100.00
40.00
60.0
280.00
1,820.00
3,700.00
1,880.00
49.2
.00
75.00
250.00
175.00
30.0
284.74
2,212.29
4,200.00
1,987.71
52.7
.00
483.60
1,000.00
516.40
48.4
.00
602.50
1,500.00
897.50
40.2
325.41
1,984.96
4,500.00
2,515.04
44.1
84.27
1,388.19
3,000.00
1,611.81
46.3
.00
87.45
600.00
512.55
14.6 50.9
38.77
230.94
454.00
223.06
866.38
8,454.48
30,500.00
22,045.52
27.7
.00
8,820.00
8,820.00
.00
100.0
10-415-353 JUDGE-MUNICIPAL COURT
450.00
900.00
1,800.00
900.00
50.0
10-415-355 PROFESSIONAL SERVICES-OTHER
106.00
1,961.00
11,550.00
9,589.00
17.0
10-415-370 TRAINING/TRAVEL
809.81
2,491.84
6,000.00
3,508.16
41.5
.00
.00
500.00
500.00
.0
200.00
584.75
1,000.00
415.25
58.5
10-415-513 PROPERTY/CASUALTY INSURANCE
.00
9,037.27
17,968.00
8,930.73
50.3
10-415-514 POSITION BONDS
.00
337.00
350.00
13.00
96.3
10-415-530 COMMUNITY ENGAGEMENT
.00
.00
300.00
300.00
.0
991.15
991.15
8,000.00
7,008.85
12.4 77.0
10-415-393 DOCUMENT RECORDING 10-415-394 DEVELOPER REIMBURSEMENT
10-415-540 GRANTS TO NEIGHBORHOODS 10-415-560 TREASURER'S FEES
626.81
3,737.10
4,855.00
1,117.90
10-415-721 CHAMBER SERVICE AGREEMENT
8,183.00
16,366.00
32,732.00
16,366.00
50.0
10-415-722 BLC FEE REMITTANCE
7,000.00
14,000.00
28,000.00
14,000.00
50.0
10-415-723 VISITOR CENTER REPAIRS & MAINT 10-415-724 NRL VC OP 10-415-725 95% NRL ADDTL MKTG
.00
.00
10,500.00
10,500.00
.0
7,500.00
15,000.00
30,000.00
15,000.00
50.0
.00
.00
.00
.00
.0
50 % OF THE FISCAL YEAR HAS ELAPSED
9
Page 27 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL 10-415-870 CONTINGENCY - GENERAL ADMIN
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
205.00
205.00
1,000.00
795.00
20.5
.00
.00
1,500.00
1,500.00
.0
63,150.78
258,246.96
553,818.00
295,571.04
46.6
2,622.08
15,353.03
31,164.00
15,810.97
49.3
.00
.00
60.00
60.00
.0
10-421-132 ICMA TOWN PAID BENEFIT
209.76
1,228.22
2,493.00
1,264.78
49.3
10-421-133 HEALTH/DENTAL-EMPLOYEE
10-415-875 MARKETING CONTINGENCY TOTAL ADMINISTRATION
SAFETY 10-421-100 GROSS WAGES - PUBLIC SAFETY 10-421-131 LONGEVITY BENEFIT
849.38
5,102.48
10,207.00
5,104.52
50.0
10-421-135 DEP HEALTH/DENTAL
.00
.00
2,282.00
2,282.00
.0
10-421-136 MEDICAL BENEFIT
.00
.00
1,050.00
1,050.00
.0
22.65
47.26
101.00
53.74
46.8
10-421-141 UNEMPLOYMENT INSURANCE 10-421-142 WORKER'S COMPENSATION 10-421-143 SOCIAL SECURITY MATCH 10-421-144 MEDICARE MATCH
.00
209.26
448.00
238.74
46.7
175.58
1,052.86
2,086.00
1,033.14
50.5
41.06
246.21
488.00
241.79
50.5
10-421-314 DISPATCH OPERATIONS
.00
8,330.50
16,661.00
8,330.50
50.0
10-421-319 MISC PURCHASED SERV
.00
.00
.00
.00
.0
10,150.00
60,900.00
121,800.00
60,900.00
50.0
.00
.00
5,000.00
5,000.00
.0
14,070.51
92,469.82
193,840.00
101,370.18
47.7
10-421-339 SHERIFF'S CONTRACT 10-421-340 SPECIAL EVENT SECURITY TOTAL SAFETY
50 % OF THE FISCAL YEAR HAS ELAPSED
10
Page 28 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS 10-431-100 GROSS WAGES - PUBLIC WORKS 10-431-131 LONGEVITY 10-431-132 ICMA DEFERRED COMPENSATION 10-431-133 HEALTH/DENTAL-EMPLOYEE
14,218.92
88,020.50
215,661.00
127,640.50
.00
2,160.00
3,300.00
1,140.00
40.8 65.5
764.30
4,510.80
17,081.00
12,570.20
26.4 37.0
2,971.71
17,001.34
45,933.00
28,931.66
10-431-135 DEP HEALTH/DENTAL
406.68
2,440.08
29,714.00
27,273.92
8.2
10-431-136 MEDICAL BENEFIT ALLOWANCE
310.12
1,322.10
4,725.00
3,402.90
28.0
10-431-141 UNEMPLOYMENT INSURANCE
129.34
272.20
700.00
427.80
38.9
.00
3,437.46
7,356.00
3,918.54
46.7
923.96
5,822.88
14,428.00
8,605.12
40.4
10-431-144 MEDICARE MATCH
216.12
1,361.97
3,373.00
2,011.03
40.4
10-431-222 GENERAL SUPPLIES
166.97
1,388.68
3,500.00
2,111.32
39.7
.00
259.90
1,500.00
1,240.10
17.3
55.49
182.75
1,500.00
1,317.25
12.2
10-431-231 GAS/FUEL/LIQUIDS
436.12
6,073.64
20,000.00
13,926.36
30.4
10-431-232 VEHICLE MAINTENANCE
145.55
356.11
12,000.00
11,643.89
3.0
10-431-233 EQUIPMENT MAINTENANCE
547.54
5,243.79
25,000.00
19,756.21
21.0
10-431-235 TIRES/CHAINS
.00
.00
4,000.00
4,000.00
.0
10-431-236 MISC. BRIDGE WORK
.00
.00
14,000.00
14,000.00
.0
10-431-237 BUILDING MAINTENANCE
.00
784.58
1,500.00
715.42
52.3
10-431-238 STREET LIGHT MAINTENANCE
.00
790.04
3,000.00
2,209.96
26.3
10-431-142 WORKER'S COMPENSATION 10-431-143 SOCIAL SECURITY MATCH
10-431-224 SAFETY SUPPLIES 10-431-227 SMALL TOOLS
10-431-239 MISCELLANEOUS MAINTENANCE 10-431-242 ROAD MAINTENANCE
199.11
199.11
250.00
50.89
79.6
26,743.95
30,902.27
75,000.00
44,097.73
41.2
10-431-253 TREE REMOVAL
.00
.00
500.00
500.00
.0
10-431-255 STORMWATER FILTER MAINTENANCE
.00
.00
.00
.00
.0
10-431-313 FUEL DEPOT CLEAN UP
.00
.00
.00
10-431-314 ADS/BID NOTICES
.00
1,340.70
500.00
10-431-317 UNIFORM ALLOWANCE 10-431-318 TRASH/RECYCLE SERVICES
(
.00
.0
840.70)
268.1
.00
587.83
2,250.00
1,662.17
26.1
1,387.41
2,433.67
6,000.00
3,566.33
40.6
10-431-319 MISC. PURCHASED SERVICES
250.00
475.00
600.00
125.00
79.2
10-431-341 ELECTRIC UTILITY
426.17
3,117.90
4,200.00
1,082.10
74.2
.00
241.00
500.00
259.00
48.2
10-431-344 TELEPHONE UTILITY
10-431-343 WATER UTILITY
344.27
1,589.14
1,950.00
360.86
81.5
10-431-345 NATURAL GAS UTILITY
132.85
2,151.03
5,000.00
2,848.97
43.0
1,801.78
11,171.79
24,800.00
13,628.21
45.1
10-431-354 ENGINEERING/SURVEYING SERVICES
.00
.00
23,000.00
23,000.00
.0
10-431-355 CAPITAL IMPROVEMENT PLAN
.00
.00
.00
.00
.0
140.42
177.50
1,000.00
822.50
17.8
10-431-399 EQUIP RENTAL
.00
.00
3,000.00
3,000.00
.0
10-431-870 CONTINGENCY- PUBLIC WORKS
.00
.00
500.00
500.00
.0
52,718.78
195,815.76
577,321.00
381,505.24
33.9
10-431-349 STREET LIGHT ELECTRIC UTILITY
10-431-370 TRAINING/TRAVEL
TOTAL PUBLIC WORKS
50 % OF THE FISCAL YEAR HAS ELAPSED
11
Page 29 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
GRAND LAKE CENTER 10-450-100 GROSS WAGES - GL CENTER
.00
.00
.00
.00
.0
10-450-110 GROSS WAGES-GL CENTER SEASONAL
.00
.00
.00
.00
.0
10-450-141 UNEMPLOYMENT INSURANCE
.00
.00
.00
.00
.0
10-450-142 WORKER'S COMPENSATION
.00
.00
.00
.00
.0
10-450-143 SOCIAL SECURITY MATCH
.00
.00
.00
.00
.0
.00
.0
10-450-144 MEDICARE MATCH
.00
.00
.00
372.95
566.80
.00
(
566.80)
.0
10-450-220 COMPUTER HARDWARE
1,450.08
1,450.08
.00
(
1,450.08)
.0
10-450-237 BUILDING MAINTENANCE
10-450-211 GENERAL SUPPLIES
8,988.24
9,148.24
.00
(
9,148.24)
.0
10-450-320 MARKETING
218.81
218.81
.00
(
218.81)
.0
10-450-341 ELECTRIC UTILITY
513.96
3,524.87
.00
(
3,524.87)
.0
.00
1,106.70
.00
(
1,106.70)
.0
10-450-342 SEWER UTILITY 10-450-343 WATER UTILITY
.00
482.00
.00
(
482.00)
.0
133.99
605.48
.00
(
605.48)
.0
10-450-345 NATURAL GAS UTILITY
.00
2,395.02
.00
(
2,395.02)
.0
10-450-355 PURCHASED PROFESSIONAL SERV.
.00
.00
.00
.00
.0
10-450-513 PROPERTY/CASUALTY INSURANCE
.00
2,143.50
.00
(
2,143.50)
.0
10-450-721 DONATIONS - OUT
.00
1,200.00
.00
(
1,200.00)
.0
1,571.50
1,571.50
.00
(
1,571.50)
.0
.00
2,719.56
.00
(
2,719.56)
.0
13,249.53
27,132.56
.00
(
27,132.56)
.0
10-450-344 TELEPHONE UTILITY
10-450-755 EXERCISE EQUIPMENT 10-450-870 CONTINGENCY - GL CENTER TOTAL GRAND LAKE CENTER
50 % OF THE FISCAL YEAR HAS ELAPSED
12
Page 30 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS 10-452-100 GROSS WAGES - PARKS
1,913.58
11,481.48
23,392.00
11,910.52
49.1
862.50
1,166.25
8,460.00
7,293.75
13.8
.00
.00
600.00
600.00
.0
76.54
459.24
1,827.00
1,367.76
25.1
10-452-133 HEALTH/DENTAL-EMPLOYEE
424.69
2,551.24
5,104.00
2,552.76
50.0
10-452-135 DEP. HEALTH/DENTAL
406.67
2,440.02
4,880.00
2,439.98
50.0
.00
54.29
525.00
470.71
10.3
22.09
41.43
101.00
59.57
41.0
.00
437.20
936.00
498.80
46.7
185.02
881.39
2,088.00
1,206.61
42.2
43.27
206.12
489.00
282.88
42.2
2,613.17
5,604.12
14,000.00
8,395.88
40.0
10-452-226 SMALL EQUIPMENT
.00
.00
900.00
900.00
.0
10-452-232 BEAR PROOF CANS MAINTENANCE
.00
.00
1,500.00
1,500.00
.0
10-452-233 EQUIPMENT MAINTENANCE
.00
364.15
1,600.00
1,235.85
22.8
10-452-234 INFORMATION SIGNS
.00
.00
6,500.00
6,500.00
.0
10-452-235 GREENBELT MAINTENANCE
.00
.00
5,000.00
5,000.00
.0
10-452-110 GROSS WAGES-PARKS SEASONAL 10-452-131 LONGEVITY 10-452-132 ICMA DEFERRED COMPENSATION
10-452-136 MEDICAL BENEFIT ALLOWANCE 10-452-141 UNEMPLOYMENT INSURANCE 10-452-142 WORKERS COMPENSATION 10-452-143 SOCIAL SECURITY MATCH 10-452-144 MEDICARE MATCH 10-452-220 OPERATING SUPPLIES
10-452-236 SAND & DREDGE
877.07
877.07
500.00
10-452-237 BUILDING MAINTENANCE
421.56
610.42
6,300.00
5,689.58
9.7
10-452-238 ADA DOCK MAINTENANCE
12.57
12.57
1,000.00
987.43
1.3
10-452-239 MISCELLANEOUS MAINTENANCE
(
175.4
.00
4,498.88
250.00
7.49
7.49
1,000.00
992.51
.00
.00
500.00
500.00
.0
98.40
98.40
1,500.00
1,401.60
6.6
10-452-248 IRRIGATION SYSTEM MAINTENANCE
196.79
214.05
2,000.00
1,785.95
10.7
10-452-319 MISCELLANEOUS SERVICES
990.00
990.00
.00
10-452-341 ELECTRIC UTILITY
484.20
3,547.26
6,700.00
10-452-243 BENCHES/PLANTERS/FENCES 10-452-244 THOMASSON PARK MAINTENANCE 10-452-246 ICE RINK/VOLLEYBALL COURT
(
377.07)
(
4,248.88) 1799.6
990.00) 3,152.74
.8
.0 52.9
10-452-342 SEWER UTILITY
.00
213.90
450.00
236.10
47.5
10-452-343 WATER UTILITY
60.00
2,947.50
9,500.00
6,552.50
31.0 45.1
10-452-345 NATURAL GAS UTILITY
162.73
1,577.36
3,500.00
1,922.64
10-452-350 GLE UTILITIES
.00
.00
.00
.00
.0
10-452-399 EQUIPMENT RENTAL
.00
405.25
1,000.00
594.75
40.5
10-452-400 GRAND AVENUE GARDENS
.00
.00
2,000.00
2,000.00
.0
10-452-450 PARK IMPROVEMENTS
.00
.00
3,000.00
3,000.00
.0
10-452-870 CONTINGENCY - PARKS
.00
.00
500.00
500.00
.0
10-452-961 MEMORIAL BENCHES
.00
.00
1,500.00
1,500.00
.0
9,858.34
41,687.08
119,102.00
77,414.92
35.0
TOTAL PARKS
ADMIN DEBT SERVICE 10-815-100 SALES TAX BONDS PRINCIPAL
.00
.00
85,000.00
85,000.00
.0
10-815-110 SALES TAX BONDS INTEREST
.00
1,324.95
3,086.00
1,761.05
42.9
10-815-982 LAND ACQUISITION - PRINCIPAL
2,947.97
4,366.30
12,002.00
7,635.70
36.4
10-815-983 LAND ACQUISITION-INTEREST
3,520.77
8,571.18
13,873.00
5,301.82
61.8
6,468.74
14,262.43
113,961.00
99,698.57
12.5
TOTAL ADMIN DEBT SERVICE
50 % OF THE FISCAL YEAR HAS ELAPSED
13
Page 31 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS DEBT SERVICE 10-831-500 CAPITAL EQUIP LEASE PRINCIPAL
965.87
5,753.34
11,608.00
5,854.66
49.6
10-831-510 EQUIPMENT LEASE INTEREST
371.28
2,269.56
4,438.00
2,168.44
51.1
1,337.15
8,022.90
16,046.00
8,023.10
50.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
16,987.00
6,152.08
12,875.68
11,500.00
TOTAL PUBLIC WORKS DEBT SERVICE
ADMIN CAPITAL 10-915-923 TOWN HALL CAPITAL OUTLAY TOTAL ADMIN CAPITAL
POLICE 10-921-993 VEHICLE-BIANNUAL REPLACEMENT TOTAL POLICE
PUBLIC WORKS CAPITAL 10-931-900 DEVELOPMENT REMEDIATION 10-931-910 CAPITAL EQUIPMENT PURCHASE
(
16,987.00
.0
1,375.68)
112.0 .0
10-931-911 CAPITALIZED EQUIPMENT REPAIR
.00
.00
.00
.00
10-931-921 PAVING
.00
.00
25,000.00
25,000.00
.0
10-931-922 DRAINAGE
.00
.00
20,000.00
20,000.00
.0
10-931-971 LEASE PURCHASE CAPITAL
.00
.00
.00
.00
.0
10-931-972 W PORTAL BRIDGE REHAB
.00
.00
867,600.00
867,600.00
.0
10-931-973 PUBLIC WAY FINDING SIGNS
.00
.00
16,000.00
16,000.00
.0
10-931-974 STREETSCAPE
.00
.00
28,000.00
28,000.00
.0
10-931-975 PROJECT PLANNING
.00
.00
.00
.00
.0
6,152.08
12,875.68
985,087.00
972,211.32
1.3
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
TOTAL PUBLIC WORKS CAPITAL
GL CENTER CAPITAL 10-950-700 PROPERTY/BUILDINGS TOTAL GL CENTER CAPITAL
50 % OF THE FISCAL YEAR HAS ELAPSED
14
Page 32 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS CAPITAL 10-952-500 ADA DOCKS
1,514.00
5,325.64
80,000.00
74,674.36
6.7
10-952-971 PARK IMPROVEMENTS
.00
.00
2,000.00
2,000.00
.0
10-952-972 BOARDWALKS
.00
.00
.00
.00
.0
10-952-974 CAPITAL IMPROVEMENTS (PARKS)
.00
.00
.00
.00
.0
10-952-975 PROJECT PLANNING
.00
.00
.00
.00
.0
10-952-980 WATER FOUNTAINS
.00
.00
8,000.00
8,000.00
.0
10-952-995 LAKEFRONT IMPROVEMENTS
.00
.00
22,000.00
22,000.00
.0
1,514.00
5,325.64
112,000.00
106,674.36
4.8
190,905.63
711,290.45
2,873,125.00
2,161,834.55
24.8
TOTAL PARKS CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
(
98,480.34) (
183,214.80)
(
231,378.00)
(
48,163.20) ( 79.2)
50 % OF THE FISCAL YEAR HAS ELAPSED
15
Page 33 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 WATER FUND ASSETS 20-100000 CASH IN COMBINED CASH FUND
632,526.61
20-102000 CSAFE
62,121.84
20-109100 COLOTRUST
303,138.81
20-116000 PETTY CASH
.00
20-117000 ACCTS RECEIVABLE/WATER SALES
3,647.65
20-118000 ASSET - LAND
2,270.00
20-119000 ASSET - DISTRIBUTION SYSTEM
2,661,517.28
20-122000 ASSET-TREATMENT FACILITY
176,814.12
20-124000 ASSET - WELLS
123,640.53
20-125000 ASSET-TANK RESERVOIR
214,067.22
20-126000 ASSET-EQUIPMENT
219,992.78
20-127000 ASSET-METERS/INSTL IN PROGRESS
4,870.80
20-128000 ASSET-CONSTRUCTION IN PROGRESS 20-129000 ACCUM. DEPRECIATION/ALL PRPRTY
13,860.86 (
20-133000 ASSET/BLDG-TOWN HALL
2,219,153.00) 26,934.62
20-135000 DUE FROM GENERAL FUND
.00
20-136000 DUE FROM MARINA FUND
.00
TOTAL ASSETS
2,226,250.12
LIABILITIES AND EQUITY
LIABILITIES 20-200000 ACCOUNTS PAYABLE GENERAL
35,127.78
20-201000 DWRF PAYABLE-CURRENT
.00
20-201001 DWRF PAYABLE-PRINCIPAL
.00
20-201002 DWRF PAYABLE-ACCRUED INTEREST
.00
20-217000 WAGES PAYABLE
.00
20-217100 SOCIAL SECURITY PAYABLE
.00
20-217200 FEDERAL W/H PAYABLE
.00
20-217300 STATE TAX W/H PAYABLE
.00
20-217400 MEDICARE WITHHOLDING
.00
20-218100 HEALTH/DENTAL/VISION
2.97
20-219100 FLEX MEDICAL
144.00
20-220000 ICMA W/H PAYABLE
.00
20-221000 ICMA LOAN PAYABLE
.00
20-221001 ICMA/ROTH IRA
.00
20-223000 ACCRUED VACATION PAYABLE
36,383.50
20-231000 DUE TO G.F. FROM WATER FUND
.00
20-240001 CAP LEASE PRINCIPAL-CURRENT
.00
20-240002 CAP LEASE-ACCRUED INTEREST
.00
TOTAL LIABILITIES
71,658.25
FUND EQUITY 20-275000 UNAPPROP. RETAINED EARNINGS
(
20-281000 CIP RESERVE
849,732.43) 800,400.00
20-285000 RET. ERNGS/DWRF 110% DEBT SRVC
.00
20-287000 CONTRIBUTED CAPITAL EQUITY
2,215,142.08
50 % OF THE FISCAL YEAR HAS ELAPSED
16
Page 34 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 WATER FUND
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
11,217.78) (
11,217.78)
TOTAL FUND EQUITY
2,154,591.87
TOTAL LIABILITIES AND EQUITY
2,226,250.12
50 % OF THE FISCAL YEAR HAS ELAPSED
17
Page 35 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
WATER REVENUES 20-344-100 WATER SALES 20-344-110 TAP FEES - CAPITAL
145.96
251,557.42
494,774.00
243,216.58
50.8
6,500.00
16,466.68
16,467.00
.32
100.0
20-344-120 RESALE METERS
449.19
1,347.57
1,000.00
(
347.57)
134.8
20-344-140 INTEREST REVENUE
260.68
1,524.88
1,000.00
(
524.88)
152.5
.00
190.84
.00
(
190.84)
110.00
260.00
700.00
440.00
37.1
.00
.00
270,000.00
270,000.00
.0
TOTAL WATER REVENUES
7,465.83
271,347.39
783,941.00
512,593.61
34.6
TOTAL FUND REVENUE
7,465.83
271,347.39
783,941.00
512,593.61
34.6
20-344-160 MISC. REVENUES 20-344-190 BULK WATER PERMITS 20-344-910 HYDRO PROJECT FUNDING
50 % OF THE FISCAL YEAR HAS ELAPSED
.0
18
Page 36 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
WATER OPERATIONS 20-430-100 GROSS WAGES - WATER 20-430-110 GROSS WAGES -WATER SEASONAL 20-430-111 ON CALL PAY 20-430-119 YEAR END LEAVE EXPENSE 20-430-131 LONGEVITY
15,853.13
89,027.75
189,069.00
100,041.25
.00
.00
.00
.00
47.1 .0
1,400.00
9,100.00
18,200.00
9,100.00
50.0
.00
.00
15,000.00
15,000.00
.0
48.00
252.00
2,450.00
2,198.00
10.3
20-430-132 ICMA DEFERRED COMPENSATION
1,095.78
6,514.34
14,086.00
7,571.66
46.3
20-430-133 HEALTH/DENTAL-EMPLOYEE
2,473.14
15,642.83
31,587.00
15,944.17
49.5
2.36
55.96
26,526.00
26,470.04
.2
20-430-136 MEDICAL BENEFIT ALLOWANCE
897.26
1,384.57
3,174.00
1,789.43
43.6
20-430-141 UNEMPLOYMENT INSURANCE
149.78
298.99
666.00
367.01
44.9
.00
1,986.64
4,251.00
2,264.36
46.7
1,151.52
6,571.42
13,740.00
7,168.58
47.8
20-430-144 MEDICARE MATCH
269.32
1,536.93
3,214.00
1,677.07
47.8
20-430-210 OFFICE SUPPLIES
.00
709.98
1,500.00
790.02
47.3
20-430-135 DEP HEALTH/DENTAL
20-430-142 WORKER'S COMPENSATION 20-430-143 SOCIAL SECURITY MATCH
20-430-211 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
20-430-215 COMPUTER SOFTWARE
.00
.00
5,000.00
5,000.00
.0
.00
.00
15,000.00
15,000.00
.0
2,418.04
5,366.81
12,000.00
6,633.19
44.7
20-430-220 COMPUTER HARDWARE 20-430-221 CHEMICALS 20-430-222 LAB SUPPLIES/EQUIPMENT
.00
189.40
1,000.00
810.60
18.9
20-430-223 WELL/PLANT SUPPLIES
.00
566.80
750.00
183.20
75.6
20-430-225 METER PARTS
23.00
23.00
1,000.00
977.00
2.3
20-430-227 SMALL EQUIPMENT/TOOLS
.00
.00
2,500.00
2,500.00
.0
20-430-228 SAFETY EQUIPMENT
.00
.00
250.00
250.00
.0
20-430-229 MISC OPERATING SUPPLIES
.00
.00
100.00
100.00
.0
20-430-231 GAS/FUEL/FLUIDS
218.38
1,124.34
5,000.00
3,875.66
22.5
20-430-232 VEHICLE MAINTENANCE
.00
32.68
1,000.00
967.32
3.3
20-430-233 EQUIPMENT MAINTENANCE
.00
.00
1,500.00
1,500.00
.0
20-430-234 WELL/PLANT MAINTENANCE
.00
.00
5,000.00
5,000.00
.0
20-430-235 TIRES & CHAINS
.00
.00
800.00
800.00
.0
255.32
613.34
1,000.00
386.66
61.3 10.2
20-430-237 BUILDING MAINTENANCE 20-430-238 DISTRIBUTION LINE MAINTENANCE
66.71
1,424.58
14,000.00
12,575.42
20-430-239 MISC. MAINTENANCE
.00
.00
300.00
300.00
.0
20-430-240 ROAD MATERIALS
.00
.00
5,000.00
5,000.00
.0
20-430-241 MOTORS & PUMPS
.00
207.48
1,500.00
1,292.52
13.8
273.84
273.84
500.00
226.16
54.8
20-430-252 RESALE METERS
.00
.00
6,000.00
6,000.00
.0
20-430-253 COGS-METER
.00
.00
2,000.00
2,000.00
.0
20-430-255 WRITE-OFF EXPENSE
.00
.00
.00
.00
.0 20.0
20-430-251 RESALE PARTS
20-430-310 MISC SERVICE FEES
.00
10.00
50.00
40.00
20-430-311 POSTAGE/FREIGHT
.00
1,296.55
2,000.00
703.45
64.8
20-430-314 LEGAL NOTICES/ADS
.00
231.99
500.00
268.01
46.4
20-430-316 MEMBERSHIPS 20-430-317 UNIFORM ALLOWANCE 20-430-318 TESTING SERVICES 20-430-319 MISCELLANEOUS SERVICES 20-430-320 TELEMETRY MAINTENANCE 20-430-321 COMPUTER SYSTEM SUPPORT 20-430-341 ELECTRIC UTILITY 20-430-344 TELEPHONE UTILITY
.00
275.00
700.00
425.00
39.3
98.26
98.26
900.00
801.74
10.9
933.97
993.97
4,800.00
3,806.03
20.7
.00
.00
350.00
350.00
.0
3,317.68
3,317.68
2,500.00
817.68)
132.7
(
210.00
2,805.00
7,690.00
4,885.00
36.5
2,583.46
15,241.77
29,500.00
14,258.23
51.7 46.8
171.53
1,169.24
2,500.00
1,330.76
83.47
2,123.41
5,000.00
2,876.59
42.5
20-430-347 INTERNET SERVICE
.00
180.00
180.00
.00
100.0
20-430-351 LEGAL SERVICES
.00
.00
10,000.00
10,000.00
.0
20-430-345 NATURAL GAS UTILITY
50 % OF THE FISCAL YEAR HAS ELAPSED
19
Page 37 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
20-430-352 AUDIT
.00
2,520.00
2,520.00
.00
20-430-354 SYSTEM ANALYSIS/ENG & SURVEY
.00
.00
35,000.00
35,000.00
.0
20-430-355 STATE FEES
.00
.00
500.00
500.00
.0
20-430-370 TRAINING/TRAVEL 20-430-513 PROPERTY/CASUALTY INSURANCE 20-430-514 POSITION BONDS
8.68
251.78
2,000.00
1,748.22
12.6
.00
4,069.74
8,139.00
4,069.26
50.0
.00
100.0
.00
200.00
200.00
8,201.87
49,211.22
.00
20-430-870 CONTINGENCY-OPERATIONS
.00
.00
TOTAL WATER OPERATIONS
42,204.50
20-830-640 DWRF LOAN - PRINCIPAL 20-830-645 DWRF LOAN - INTEREST
20-430-700 DEPRECIATION RESERVE
100.0
(
49,211.22)
.0
1,000.00
1,000.00
.0
226,899.29
520,692.00
293,792.71
43.6
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0 .0
WATER DEBT SERVICE
20-830-660 CWRPDA LOAN - PRINCIPAL
.00
.00
13,000.00
13,000.00
20-830-661 CWRPDA LOAN - INTEREST
.00
.00
3,000.00
3,000.00
.0
20-830-970 LEASE PURCHASE PRINCIPAL
.00
.00
.00
.00
.0
20-830-975 LEASE PURCHASE INTEREST
.00
.00
.00
.00
.0
.00
.00
16,000.00
16,000.00
.0
TOTAL WATER DEBT SERVICE
WATER CAPITAL 20-930-994 SYSTEM UPGRADES
.00
.00
.00
.00
.0
20-930-995 CAPITAL CONTINGENCY
.00
.00
5,000.00
5,000.00
.0
20-930-997 CAPITAL DIRECT PURCHASE
.00
.00
.00
.00
.0
20-930-998 HYDRO POWER GENERATOR
27,926.76
55,665.88
285,000.00
229,334.12
19.5
TOTAL WATER CAPITAL
27,926.76
55,665.88
290,000.00
234,334.12
19.2
TOTAL FUND EXPENDITURES
70,131.26
282,565.17
826,692.00
544,126.83
34.2
NET REVENUE OVER EXPENDITURES
(
62,665.43) (
11,217.78) (
42,751.00)
(
31,533.22) ( 26.2)
50 % OF THE FISCAL YEAR HAS ELAPSED
20
Page 38 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 MARINA FUND ASSETS 40-100000 CASH IN COMBINED CASH FUND
288,581.87
40-116000 PETTY CASH
525.00
40-117000 ACCOUNTS RECEIVABLE
.00
40-118000 ASSET - BOATS
206,015.34
40-119000 ASSET - OTHER
7,480.69
40-123000 DUE TO MARINA FROM GF
.00
40-129000 ACCUM DEPRECIATION/ALL PROP
(
120,031.51)
TOTAL ASSETS
382,571.39
LIABILITIES AND EQUITY
LIABILITIES 40-200000 ACCOUNTS PAYABLE GENERAL
1,588.51
40-201000 GF PAYABLE-CURRENT
.00
40-201001 GF PAYABLE - PRINCIPAL
.00
40-201002 GF LOAN ACCRUED INTEREST
.00
40-217000 WAGES PAYABLE
.00
40-217100 SOCIAL SECURITY PAYABLE
.00
40-217200 FEDERAL W/H PAYABLE
.00
40-217300 STATE TAX W/H PAYABLE
.00
40-217400 MEDICARE WITHHOLDING
.00
40-218100 HEALTH/DENTAL/VISION
4.32
40-219100 FLEX MEDICAL
36.00
40-220000 ICMA W/H PAYABLE
.00
40-221000 ICMA LOAN PAYABLE
.00
40-221001 ICMA/ROTH IRA
.00
40-223000 ACCRUED VACATION PAYABLE
385.33
40-231000 DUE TO GF FROM MARINA
.00
40-232000 DUE TO WATER FROM MARINA
.00
TOTAL LIABILITIES
2,014.16
FUND EQUITY 40-275000 UNAPPROP. RETAINED EARNINGS
358,948.50
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
21,608.73
BALANCE - CURRENT DATE
21,608.73
TOTAL FUND EQUITY
380,557.23
TOTAL LIABILITIES AND EQUITY
382,571.39
50 % OF THE FISCAL YEAR HAS ELAPSED
21
Page 39 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
MARINA REVENUES 40-344-110 BOAT RENTALS
11,970.00
14,280.00
.00
40-344-113 RENTALS (NON-TAXABLE)
34,313.00
38,576.00
135,000.00
(
14,280.00) 96,424.00
28.6
.0
40-344-115 TOURS
29.1
15,166.00
17,466.00
60,000.00
42,534.00
40-344-120 BUILDING SPACE RENTAL
1,100.00
1,100.00
3,300.00
2,200.00
33.3
40-344-140 SEASONAL SLIP RENTALS
.00
12,250.00
12,250.00
.00
100.0 85.2
350.00
2,300.00
2,700.00
400.00
40-344-150 DAILY SLIP RENTAL
40-344-145 KAYAK SLIP RENTAL
.00
.00
200.00
200.00
40-344-160 MISC REVENUE
.00
922.00
600.00
40-344-170 INTEREST EARNED
(
.0
322.00)
153.7
37.93
232.69
400.00
167.31
58.2
250.00
250.00
300.00
50.00
83.3
40-344-190 WINTER STORAGE
.00
.00
.00
.00
.0
40-344-200 SALE OF ASSETS
.00
.00
14,000.00
14,000.00
.0
40-344-210 GF TOUR/RENTAL CONTRIBUTIONS
.00
.00
1,820.00
1,820.00
.0
TOTAL MARINA REVENUES
63,186.93
87,376.69
230,570.00
143,193.31
37.9
TOTAL FUND REVENUE
63,186.93
87,376.69
230,570.00
143,193.31
37.9
40-344-180 BOAT DAMAGE
50 % OF THE FISCAL YEAR HAS ELAPSED
22
Page 40 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA OPERATIONS 40-460-100 GROSS WAGES - MARINA
1,147.99
5,365.21
10,090.00
4,724.79
53.2
15,824.66
30,317.98
85,000.00
54,682.02
35.7
40-460-119 ACCRUED LEAVE EXPENSE
.00
.00
1,000.00
1,000.00
.0
40-460-131 LONGEVITY
.00
51.00
72.00
21.00
70.8
40-460-110 GROSS WAGES - MARINA SEASONAL
40-460-132 ICMA DEFERRED COMPENSATION
53.06
319.60
807.00
487.40
39.6
124.54
944.79
1,964.00
1,019.21
48.1
.59
13.98
1,301.00
1,287.02
1.1
40-460-136 MEDICAL BENEFIT ALLOWANCE
42.12
104.58
185.00
80.42
56.5
40-460-141 UNEMPLOYMENT INSURANCE
99.65
107.50
288.00
180.50
37.3
.00
2,100.72
4,496.00
2,395.28
46.7
1,059.22
2,239.35
5,950.00
3,710.65
37.6
40-460-133 HEALTH/DENTAL - EMPLOYEE 40-460-135 DEP HEALTH/DENTAL
40-460-142 WORKERS COMPENSATION 40-460-143 SOCIAL SECURITY MATCH 40-460-144 MEDICARE MATCH
247.69
523.57
1,392.00
868.43
37.6
54.82
104.81
1,000.00
895.19
10.5
40-460-214 SMALL EQUIP/COMP HRDWARE
.00
.00
450.00
450.00
.0
40-460-220 COMPUTER HARDWARE
.00
.00
.00
.00
.0
40-460-222 SHOP SUPPLIES
107.42
208.55
2,000.00
1,791.45
10.4
40-460-223 BOAT SUPPLIES
8.58
8.58
2,000.00
1,991.42
.4
.00
.00
500.00
500.00
.0 15.0
40-460-211 GENERAL OFFICE SUPPLIES
40-460-227 TOOLS
703.47
747.49
5,000.00
4,252.51
40-460-232 VEHICLE MAINTENANCE
40-460-231 FUEL
.00
.00
500.00
500.00
.0
40-460-233 EQUIPMENT MAINTENANCE
.00
589.84
4,000.00
3,410.16
14.8
625.45
769.62
10,000.00
9,230.38
7.7
40-460-312 COMPUTER SERVICES
40-460-237 BUILDING/FACILITY MAINTENANCE
.00
675.96
1,352.00
676.04
50.0
40-460-314 ADS AND LEGAL NOTICES
.00
.00
300.00
300.00
.0
40-460-316 DUES/MEMBERSHIPS
.00
.00
500.00
500.00
.0
40-460-317 UNIFORMS
.00
1,179.75
1,000.00
179.75)
118.0
(
40-460-318 MISCELLANEOUS SERVICES
.00
144.00
500.00
356.00
28.8
40-460-320 MARKETING
.00
515.83
1,000.00
484.17
51.6
1,124.32
1,284.25
4,000.00
2,715.75
32.1
46.43
204.64
600.00
395.36
34.1
40-460-330 BANK/CREDIT CARD FEES 40-460-341 ELECTRIC UTILITY 40-460-342 SEWER UTILITY
.00
186.00
400.00
214.00
46.5
40-460-343 WATER UTILITY
.00
241.00
500.00
259.00
48.2
179.56
817.12
1,100.00
282.88
74.3
.00
347.25
600.00
252.75
57.9
40-460-351 LICENSES
.00
.00
165.00
165.00
.0
40-460-360 SALES TAX
.00
.00
.00
.00
.0
40-460-370 TRAINING/TRAVEL
.00
.00
500.00
500.00
.0
40-460-510 LEGAL
.00
.00
2,000.00
2,000.00
.0
40-460-512 AUDIT
.00
1,103.00
1,103.00
.00
100.0
40-460-513 PROPERTY/CASUALTY INSURANCE
.00
108.99
218.00
109.01
50.0
40-460-514 POSITION BONDS
.00
124.00
124.00
.00
100.0
40-460-515 ENGINEERING/SURVEY
.00
.00
1,000.00
1,000.00
.0
40-460-516 SITE LEASE
.00
.00
1.00
1.00
.0
2,386.50
14,319.00
.00
.00
.00
23,836.07
65,767.96
40-460-344 TELEPHONE UTILITY 40-460-350 BOAT REGISTRATION
40-460-700 DEPRECIATION RESERVE 40-460-870 CONTINGENCY TOTAL MARINA OPERATIONS
(
14,319.00)
.0
1,000.00
1,000.00
.0
155,958.00
90,190.04
42.2
50 % OF THE FISCAL YEAR HAS ELAPSED
23
Page 41 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA CAPITAL 40-960-610 CAPITAL EQUIPMENT
.00
.00
50,000.00
50,000.00
.0
40-960-995 LAKEFRONT IMPROVEMENTS
.00
.00
10,000.00
10,000.00
.0
.00
.00
60,000.00
60,000.00
.0
TOTAL FUND EXPENDITURES
23,836.07
65,767.96
215,958.00
150,190.04
30.5
NET REVENUE OVER EXPENDITURES
39,350.86
21,608.73
14,612.00
TOTAL MARINA CAPITAL
(
6,996.73)
50 % OF THE FISCAL YEAR HAS ELAPSED
147.9
24
Page 42 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 PAY-AS-YOU-THROW FUND ASSETS 50-100000 CASH IN COMBINED CASH FUND
71,575.06
50-116000 PETTY CASH
50.00
50-117000 ACCOUNTS RECEIVABLE
.00
50-127000 ASSET - BAG INVENTORY
2,890.46
TOTAL ASSETS
74,515.52
LIABILITIES AND EQUITY
LIABILITIES 50-200000 ACCOUNTS PAYABLE GENERAL
1,549.93
50-231000 DUE TO G.F. FROM PAYT
.00
TOTAL LIABILITIES
1,549.93
FUND EQUITY 50-275000 UNAPPROP. RETAINED EARNINGS
63,085.92
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
9,879.67
BALANCE - CURRENT DATE
9,879.67
TOTAL FUND EQUITY
72,965.59
TOTAL LIABILITIES AND EQUITY
74,515.52
50 % OF THE FISCAL YEAR HAS ELAPSED
25
Page 43 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
PAYT REVENUES 50-344-110 BAGS: DIRECT SALES (T)
176.00
429.00
1,060.00
631.00
9,134.00
17,483.00
45,400.00
27,917.00
38.5
9.57
57.12
100.00
42.88
57.1
TOTAL PAYT REVENUES
9,319.57
17,969.12
46,560.00
28,590.88
38.6
TOTAL FUND REVENUE
9,319.57
17,969.12
46,560.00
28,590.88
38.6
50-344-115 BAGS: VENDOR PURCHASE (NT) 50-344-140 INTEREST REVENUE
50 % OF THE FISCAL YEAR HAS ELAPSED
40.5
26
Page 44 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PAYT OPERATIONS 50-470-200 BAGS FOR RESALE
.00
2,248.29
9,500.00
7,251.71
50-470-250 COGS - BAGS
.00
.00
4,000.00
4,000.00
.0
2,780.31
4,837.62
20,000.00
15,162.38
24.2 50.0
50-470-300 DUMPSTER SERVICE 50-470-301 RECYCLING CONTRIBUTION
23.7
125.00
750.00
1,500.00
750.00
50-470-310 SITE LEASE
.00
.00
1.00
1.00
.0
50-470-312 COMPUTER SERVICES
.00
96.54
193.00
96.46
50.0
50-470-315 SITE MAINTENANCE
.00
.00
2,000.00
2,000.00
.0
50-470-320 BUSINESS LICENSE
.00
.00
165.00
165.00
.0
50-470-330 COMPUTER HARDWARE
.00
.00
.00
.00
.0
50-470-350 SALES TAX
.00
.00
84.00
84.00
.0
50-470-512 AUDIT
.00
157.00
157.00
.00
100.0
50-470-870 CONTINGENCY
.00
.00
1,000.00
1,000.00
.0
TOTAL PAYT OPERATIONS
2,905.31
8,089.45
38,600.00
30,510.55
21.0
TOTAL FUND EXPENDITURES
2,905.31
8,089.45
38,600.00
30,510.55
21.0
NET REVENUE OVER EXPENDITURES
6,414.26
9,879.67
7,960.00
1,919.67)
124.1
(
50 % OF THE FISCAL YEAR HAS ELAPSED
27
Page 45 of 46
CASH AND INVESTMENT ACCOUNT BALANCES AT: Combined Cash Grand Mountain Bank Checking Money Market Utility Cash Clearing Combined Cash Totals
$5,754.94 $1,487,315.08 $870.87 $1,493,940.89
Developer LOC Checking*
$501,257.35
Water Fund
$632,526.61
Marina Fund
PAYT
$288,581.87
$71,575.06
$16,427.47 *Letter of Credit Funds - Restricted Use Non-Interest Bearing Holding Account
CSAFE General Fund Water Fund ColoTrust
General Fund
June 30, 2016
$185,924.67 $62,121.84 $605,846.65
$302,707.84
Gill & Associates
$100,000.11
Advantage Bank CD
$100,140.65
FlatIrons Bank CD $96,000 Principal Interest paid monthly
$303,138.81
$96,000.00
TOTAL
$1,302,458.09
TOTAL CASH/INVESTMENTS AT:
6/30/2016
$997,787.26
$288,581.87
$71,575.06
$2,660,402.28
Page 46 of 46
Page 2 of 46
Page 3 of 46
Page 4 of 46
Page 5 of 46
Page 6 of 46
Page 7 of 46
Page 8 of 46
Page 9 of 46
Page 10 of 46
Page 11 of 46
Page 12 of 46
Page 13 of 46
Page 14 of 46
Page 15 of 46
Page 16 of 46
Page 17 of 46
Page 18 of 46
TOWN OF GRAND LAKE COMBINED CASH INVESTMENT JUNE 30, 2016 COMBINED CASH ACCOUNTS 01-101000 GMB CHECKING - OPERATIONS
5,754.94
01-105000 GMB MONEY MARKET
1,487,315.08
01-106000 RETURNED CHECK CLEARING ACCT
.00
01-107500 UTILITY CASH CLEARING ACCT
870.87
TOTAL COMBINED CASH
1,493,940.89
01-100000 CASH ALLOCATED TO OTHER FUNDS
(
1,493,940.89)
TOTAL UNALLOCATED CASH
.00
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
501,257.35
20 ALLOCATION TO WATER FUND
632,526.61
40 ALLOCATION TO MARINA FUND
288,581.87
50 ALLOCATION TO PAY-AS-YOU-THROW FUND
71,575.06
TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 01-100000
1,493,940.89 (
1,493,940.89)
ZERO PROOF IF ALLOCATIONS BALANCE
.00
50 % OF THE FISCAL YEAR HAS ELAPSED
1
Page 19 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 GENERAL FUND ASSETS 10-100000 CASH IN COMBINED CASH FUND
501,257.35
10-103000 CSAFE
185,924.67
10-106000 ADVANTAGE BANK - CD
100,140.65
10-109100 COLOTRUST
302,707.84
10-109200 DEVELOPER LOC CHECKING
16,427.47
10-110000 FLATIRONS BANK - CD
96,000.00
10-116000 PETTY CASH
250.00
10-116500 GLC PETTY CASH
50.00
10-117000 ACCOUNTS RECEIVABLE
.00
10-117100 PROPERTY TAXES RECEIVABLE
241,557.00
10-118000 ACCRUED INT RECEIVABLE-MARINA
.00
10-123000 DUE TO G.L. FROM CUSTOMERS
1,058.23
10-129000 UNLEADED GAS INVENTORY
1,973.24
10-130000 DIESEL INVENTORY
1,917.93
10-131000 DUE FROM WATER FUND
.00
10-131001 DUE FROM MARINA FUND
.00
10-131002 DUE FROM PAYT
.00
10-132000 MARINA LOAN PRINCIPAL
.00
10-132001 MARINA LOAN PRINCIPAL-CURRENT
.00
10-150100 GILL CAPITAL PARTNERS: BONDS
100,000.11
TOTAL ASSETS
1,549,264.49
LIABILITIES AND EQUITY
LIABILITIES 10-200000 ACCOUNTS PAYABLE GENERAL
83,635.91
10-217000 WAGES PAYABLE
.00
10-217100 SOCIAL SECURITY WITHHOLDING
.00
10-217200 FEDERAL W/H PAYABLE
.00
10-217300 STATE W/H PAYABLE
.00
10-217400 MEDICARE WITHHOLDING
.00
10-218100 HEALTH/DENTAL/VISION
(
10-219100 FLEX MEDICAL
787.85) 619.74
10-220000 ICMA W/H PAYABLE
.00
10-221000 ICMA EMP LOAN PAYABLE
.00
10-221001 ICMA/ROTH IRA
.00
10-221100 GARNISHMENT
.00
10-222000 DEFERRED REVENUE-PROPERTY TAX 10-223180 PREPAID NRL
241,557.00 .00
10-226000 USE TAX DEFERRED REVENUE
64,200.03
10-228000 DEVELOPER LOC FUNDS
16,427.47
10-232000 DUE TO WATER FROM GF
.00
10-233000 DUE TO MARINA FROM GF
.00
10-241355 DEF REV PARK AVE BOARDWALK
12,629.78
TOTAL LIABILITIES
418,282.08
50 % OF THE FISCAL YEAR HAS ELAPSED
2
Page 20 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 GENERAL FUND FUND EQUITY 10-270000 PARKING FEE-IN-LIEU
.00
10-275000 FUND BALANCE
908,005.29
10-281000 CEMETERY DESIGNATED FUND BALAN
50,501.07
10-284000 ATTAIN HOUSING DESG FUND BALAN
352,791.68
10-285000 FUND BAL RESVD - INV & PRE PDS
2,899.17
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
183,214.80) (
183,214.80)
TOTAL FUND EQUITY
1,130,982.41
TOTAL LIABILITIES AND EQUITY
1,549,264.49
50 % OF THE FISCAL YEAR HAS ELAPSED
3
Page 21 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
GENERAL TAXES 10-311-100 PROPERTY TAXES 10-311-110 SPECIFIC OWNERSHIP 10-311-120 INTEREST & PENALTY-PROP TAXES 10-311-130 MOTOR VEHICLE USE TAX 10-311-140 SALES TAX 10-311-150 BUILDING USE TAX 10-311-160 CIGARETTES-SELECT SALES TAX TOTAL GENERAL TAXES
31,305.54
186,817.68
241,557.00
54,739.32
77.3
1,284.53
6,018.87
14,000.00
7,981.13
43.0
34.50
500.00
530.88
.00
(
11,854.99
30.88)
20,000.00
8,145.01
(
59.3
6.2)
26,769.10
161,061.26
1,164,718.00
1,003,656.74
13.8
.00
.00
30,000.00
30,000.00
.0
320.58
1,374.39
3,000.00
1,625.61
45.8
59,714.25
367,096.31
1,473,775.00
1,106,678.69
24.9
UTILITY FRANCHISES 10-316-170 CABLE FRANCHISE FEES
.00
.00
16,000.00
16,000.00
.0
10-316-171 TELEPHONE FRANCHISE
1,005.00
2,010.00
4,224.00
2,214.00
47.6
10-316-172 ELECTRIC FRANCHISE 10-316-173 NATURAL GAS FRANCHISE TOTAL UTILITY FRANCHISES
.00
9,373.88
30,000.00
20,626.12
31.3
968.15
5,427.47
14,000.00
8,572.53
38.8
1,973.15
16,811.35
64,224.00
47,412.65
26.2
LICENSES & PERMITS 648.75
4,910.00
2,000.00
2,910.00)
245.5
10-321-110 BUSINESS LICENSE - 95%
10-321-100 LIQUOR LICENSE
.00
.00
.00
(
.00
.0
10-321-115 NIGHTLY RENTAL LICENSE - 95%
.00
.00
.00
.00
.0
10-321-120 TOWN SALES TAX LICENSE
115.00
145.00
400.00
255.00
36.3
10-321-130 MOTOR VEHICLE LICENSE
218.00
767.50
2,000.00
1,232.50
38.4
10-321-140 SIGN PERMIT
25.00
75.00
350.00
275.00
21.4
10-321-150 GRADING PERMIT
70.00
105.00
50.00
(
55.00)
210.0
5.00
135.00
100.00
(
35.00)
135.0
515.00
535.00
300.00
(
235.00)
178.3
8,641.50
9,771.00
29,000.00
19,229.00
33.7
.00
30,000.00
30,000.00
.00
100.0
10,238.25
46,443.50
64,200.00
17,756.50
72.3
10-321-160 ANIMAL LICENSE 10-321-170 ENCROACHMENT PERMIT/LICENSE 10-321-175 BUSINESS LICENSE COMMISSION 10-321-180 NIGHTLY RENTAL LICENSE TOTAL LICENSES & PERMITS
50 % OF THE FISCAL YEAR HAS ELAPSED
4
Page 22 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
GRANTS 10-334-201 GRAND LAKE HISTORICAL ASSOC
.00
.00
.00
.00
10-334-202 CO STATE HISTORICAL FUND
.00
.00
.00
.00
.0 .0
10-334-203 DOLA CCRA
.00
.00
.00
.00
.0
10-334-204 GOCO SNOWMOBILE BRIDGE
.00
.00
.00
.00
.0
10-334-205 PARKS & WILDLIFE GRANT
.00
.00
.00
.00
.0
10-334-206 GOCO PLANNING GRANT
.00
.00
.00
.00
.0
10-334-207 DOLA ADMIN GRANT
.00
.00
.00
.00
.0
10-334-208 NWCCOG TECH. ASSIST. GRANT
.00
.00
.00
.00
.0
10-334-209 DOLA ADMIN GRANT - MP PATH
.00
.00
10,000.00
10,000.00
.0
.00
.00
10,000.00
10,000.00
.0
TOTAL GRANTS
INTERGOVERNMENTAL REVENUES 10-335-100 FUEL DEPOT CLEAN-UP
.00
.00
.00
.00
.0
10-335-130 GRAND CNTY ROAD & BRIDGE
.00
3,168.00
6,336.00
3,168.00
50.0
2,598.52
12,700.10
30,063.00
17,362.90
42.2
873.99
1,420.56
2,000.00
579.44
71.0
.00
.00
4,000.00
4,000.00
.0
3,472.51
17,288.66
42,399.00
25,110.34
40.8
10-335-200 HIGHWAY USER TAX FUND 10-335-800 CONSERVATION TRUST FUND 10-335-900 OTHER INTERGOVERNMENTAL TOTAL INTERGOVERNMENTAL REVENUES
CHARGES FOR SERVICES 10-341-100 COURT FEES 10-341-200 CEMETERY 10-341-201 HEADSTONE DEPOSIT
.00
.00
50.00
2,800.00
6,450.00
5,000.00
50.00
.0
(
1,450.00)
129.0
400.00
1,600.00
1,600.00
.00
100.0
10-341-300 ZONING & SUBDIVISION REVIEW
1,135.00
4,959.00
4,000.00
(
959.00)
124.0
10-341-400 ATTAINABLE HOUSING FEE
1,874.00
20,923.50
20,000.00
(
923.50)
104.6
.00
308.56
1,100.00
791.44
28.1
3.00
7.25
50.00
42.75
14.5
150.00
300.00
300.00
.00
100.0
6,362.00
34,548.31
32,100.00
(
2,448.31)
107.6
10-341-600 FUEL DEPOT SURCHARGE 10-341-700 COPIES/FAXES/SODA 10-341-850 NIGHTLY RENTAL APPLICATION FEE TOTAL CHARGES FOR SERVICES
GRAND LAKE CENTER 10-350-100 GL CENTER - RENTS
385.00
5,105.00
.00
(
5,105.00)
.0
10-350-110 GL CENTER - MERCH SALES
280.00
2,158.00
.00
(
2,158.00)
.0
.00
5,376.50
.00
(
5,376.50)
.0
665.00
12,639.50
.00
(
12,639.50)
.0
10-350-200 GL CENTER - DONATIONS TOTAL GRAND LAKE CENTER
50 % OF THE FISCAL YEAR HAS ELAPSED
5
Page 23 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
FINES 10-351-100 ORDINANCE/TRAFFIC FINES TOTAL FINES
100.00
100.00
500.00
400.00
20.0
100.00
100.00
500.00
400.00
20.0
745.88
3,239.24
4,000.00
760.76
81.0
.00
.00
.00
.00
.0
945.00
4,190.00
3,000.00
1,190.00)
139.7
MISCELLANEOUS 10-360-100 INTEREST REVENUE 10-360-110 SALE OF ASSETS 10-360-140 RENT - LAND, BUILDINGS 10-360-160 RENT - ENTERPRISE FUND SITES 10-360-180 RENT - VISITORS CENTER 10-360-190 GIFTS - DONATIONS 10-360-200 MISC. REVENUES - GENERAL
(
.00
.00
2.00
2.00
.0
625.00
1,250.00
2,500.00
1,250.00
50.0
.00
.00
1,200.00
4,584.25
19,408.78
5,000.00
(
1,200.00
.0
14,408.78)
388.2 .0
10-360-210 5% BUSINESS LICENSE FEE
.00
.00
.00
.00
10-360-220 5% NIGHTLY RENTAL LICENSE
.00
.00
.00
.00
.0
10-360-230 MEMORIAL BENCHES
.00
2,060.00
.00
2,060.00)
.0
(
10-360-300 MARINA LOAN PRINCIPAL PAYMENT
.00
.00
.00
.00
.0
10-360-320 DPA LOAN REPAYMENT
.00
.00
.00
.00
.0
10-360-350 DEVELOPER LETTER OF CREDIT
.00
.00
16,987.00
16,987.00
.0
6,900.13
30,148.02
32,689.00
2,540.98
92.2
.0
TOTAL MISCELLANEOUS
CAPITAL SPECIFIC REVENUE 10-377-100 CAPITAL LEASE PROCEEDS
.00
.00
.00
.00
10-377-150 CDOT OFF-SYSTEM BRIDGE PROGRAM
.00
.00
694,080.00
694,080.00
.0
10-377-151 W. PORTAL BRIDGE FUNDING
.00
.00
100,000.00
100,000.00
.0
10-377-152 STATE HISTORIC FUND-COMM HOUSE
.00
.00
.00
.00
.0
10-377-153 DOLA ADMIN GRANT
.00
.00
.00
.00
.0
10-377-154 FISHING IS FUN
.00
.00
24,000.00
24,000.00
.0
10-377-155 DOLA TIER 1 GRANT
.00
.00
22,000.00
22,000.00
.0
3,000.00
3,000.00
8,260.00
5,260.00
36.3
.00
.00
73,520.00
73,520.00
.0
3,000.00
3,000.00
921,860.00
918,860.00
.3
92,425.29
528,075.65
2,641,747.00
2,113,671.35
20.0
10-377-156 EV CHARGING STATION 10-377-157 DOLA TIER 1 - W. PORTAL BRIDGE TOTAL CAPITAL SPECIFIC REVENUE
TOTAL FUND REVENUE
50 % OF THE FISCAL YEAR HAS ELAPSED
6
Page 24 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
CEMETERY COMMITTEE 10-410-211 GENERAL SUPPLIES/MISC EXPENSES 10-410-215 GRAVE MARKERS 10-410-242 GENERAL MAINTENANCE TOTAL CEMETERY COMMITTEE
7.47
7.47
3,500.00
3,492.53
.2
600.00
600.00
2,600.00
2,000.00
23.1
.00
.00
3,000.00
3,000.00
.0
607.47
607.47
9,100.00
8,492.53
6.7
P.O.S.T. COMMITTEE 10-411-319 POST COMMITTEE-MISC EXP
.00
.00
.00
.00
.0
10-411-320 POST PLAN
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
10-412-211 GENERAL OFFICE SUPPLIES
.00
.00
1,000.00
1,000.00
.0
10-412-215 COMPUTER SOFTWARE
.00
.00
.00
.00
.0
10-412-311 POSTAGE/ADS/LEGAL NOTICES
.00
.00
800.00
800.00
.0
10-412-314 PURCHASED SERVICES
.00
.00
.00
.00
.0
10-412-319 MISC.-PLANNING COMMISSION/BOA
.00
.00
100.00
100.00
.0
10-412-320 COMPUTER HARDWARE
.00
.00
.00
.00
.0
10-412-351 PLANNING LEGAL SERVICES
.00
.00
1,000.00
1,000.00
.0
10-412-360 STATE HISTORICAL FUND SURVEY
.00
.00
.00
.00
.0
10-412-361 DOWNTOWN DEVELOPMENT STUDY
.00
.00
.00
.00
.0
10-412-365 FEDERAL LANDS LIVABILITY INITI
.00
.00
.00
.00
.0
10-412-370 TRAINING/TRAVEL
.00
64.00
400.00
336.00
16.0
10-412-380 COMP PLAN UPDATE
.00
.00
.00
.00
.0
.00
64.00
3,300.00
3,236.00
1.9
TOTAL P.O.S.T. COMMITTEE
PC/BOA
TOTAL PC/BOA
50 % OF THE FISCAL YEAR HAS ELAPSED
7
Page 25 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
BOARD OF TRUSTEES 10-413-215 ELECTIONS
.00
554.41
3,500.00
2,945.59
15.8
10-413-316 DUES/MEMBERSHIPS
.00
4,687.00
7,117.00
2,430.00
65.9
2,992.41
4,425.79
5,600.00
1,174.21
79.0
.00
3,000.00
3,000.00
.00
100.0
10-413-460 LONG RANGE/MISC
49.99
363.58
700.00
336.42
51.9
10-413-461 APPRECIATION PROGRAM
80.54
394.31
3,500.00
3,105.69
11.3
10-413-462 COMPUTER EQUIPMENT
.00
2,992.93
3,000.00
7.07
99.8
10-413-463 WATER QUALITY ISSUES
.00
.00
1,500.00
1,500.00
.0
10-413-465 COMPUTER SOFTWARE
.00
.00
300.00
300.00
.0
10-413-470 SECURITY CAMERAS
.00
.00
.00
.00
.0
10-413-370 TRAINING/TRAVEL 10-413-452 HEADWATER TRAILS ALLIANCE
10-413-480 RMNP CENTENNIAL
.00
.00
.00
.00
.0
10-413-722 GRAND LAKE TRAILGROOMING
.00
.00
20,000.00
20,000.00
.0
10-413-723 GRAND LAKE HISTORICAL SOCIETY 10-413-728 MISCELLANEOUS DONATIONS
.00
.00
3,500.00
3,500.00
.0
250.00
1,450.00
2,500.00
1,050.00
58.0
10-413-731 GRND CNTY COUNCIL ON AGING
.00
3,500.00
3,500.00
.00
100.0
10-413-782 ADVOCATES
.00
1,500.00
1,500.00
.00
100.0
10-413-793 GL FIREWORKS
11,000.00
11,000.00
11,000.00
.00
100.0
10-413-796 MOUNTAIN FAMILY CENTER
.00
2,500.00
2,500.00
.00
100.0
10-413-843 ROCKY MTN REP THEATRE
.00
.00
1,500.00
1,500.00
.0
10-413-845 GC RURAL HEALTH NETWORK
.00
1,000.00
1,000.00
.00
100.0 .0
10-413-846 HEART OF THE MTNS HOSPICE
.00
.00
2,500.00
2,500.00
10-413-847 SHINING STARS FOUNDATION
.00
.00
1,500.00
1,500.00
.0
10-413-848 GRAND COUNTY LIBRARY DISTRICT
.00
.00
.00
.00
.0
10-413-850 GRAND LAKE YACHT CLUB SAILING
.00
.00
250.00
250.00
.0
10-413-851 EXPERIMENTAL AIRCRAFT ASSOC.
.00
.00
80.00
80.00
.0 .0
10-413-852 GRAND ANGELS
.00
.00
4,500.00
4,500.00
10-413-853 MISC FUNDRAISER TOUR CERTS
.00
.00
240.00
240.00
.0
10-413-854 GC SEARCH & RESCUE
.00
.00
1,000.00
1,000.00
.0
10-413-855 GL US CONSTITUTION WEEK
.00
4,000.00
4,000.00
.00
100.0
10-413-856 GRAND ENTERPRISE INITIATIVE
.00
.00
1,000.00
1,000.00
.0
10-413-857 FRIENDS OF TRAIL RIVER RANCH
.00
.00
.00
.00
.0
10-413-858 WARRIOR BONFIRE PROJECT
.00
.00
.00
.00
.0
10-413-870 BOARD CONTINGENCY
.00
.00
500.00
500.00
.0
10-413-999 TABOR REQ'D EMERGENCY RESERVE
.00
.00
57,566.00
57,566.00
.0
14,372.94
41,368.02
148,353.00
106,984.98
27.9
24.1
TOTAL BOARD OF TRUSTEES
GREENWAYS COMMITTEE 10-414-211 GENERAL SUPPLIES 10-414-238 TREES/SHRUBS/PLANTINGS 10-414-241 ARBOR DAY SUPPLIES 10-414-245 GRND GARDENS 10-414-319 CONTRACT LABOR
82.16
361.22
1,500.00
1,138.78
1,781.98
1,798.97
5,000.00
3,201.03
36.0
.00
169.60
500.00
330.40
33.9
.00
.00
500.00
500.00
.0
5,541.17
11,082.34
33,247.00
22,164.66
33.3
10-414-726 MISCELLANEOUS SERVICES
.00
.00
200.00
200.00
.0
10-414-870 CONTINGENCY
.00
.00
250.00
250.00
.0
7,405.31
13,412.13
41,197.00
27,784.87
32.6
TOTAL GREENWAYS COMMITTEE
50 % OF THE FISCAL YEAR HAS ELAPSED
8
Page 26 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
ADMINISTRATION 10-415-100 GROSS WAGES - ADMINISTRATION
21,604.03
107,532.69
199,070.00
91,537.31
192.00
957.00
1,138.00
181.00
84.1
10-415-132 ICMA TOWN PAID BENEFIT
1,107.90
6,404.96
15,526.00
9,121.04
41.3
10-415-133 HEALTH/DENTAL-EMPLOYEE
2,525.77
18,121.48
37,352.00
19,230.52
48.5
8.56
208.13
20,209.00
20,000.87
1.0
1,322.63
2,265.34
3,741.00
1,475.66
60.6
162.24
330.45
646.00
315.55
51.2
.00
251.22
538.00
286.78
46.7 50.6
10-415-131 LONGEVITY BENEFIT
10-415-135 DEP HEALTH/DENTAL 10-415-136 MEDICAL BENEFIT ALLOWANCE 10-415-141 UNEMPLOYMENT INSURANCE 10-415-142 WORKER'S COMPENSATION 10-415-143 SOCIAL SECURITY MATCH
54.0
1,403.59
6,766.63
13,363.00
6,596.37
10-415-144 MEDICARE MATCH
328.27
1,582.44
3,126.00
1,543.56
50.6
10-415-211 GENERAL OFFICE SUPPLIES
685.36
2,351.57
3,500.00
1,148.43
67.2
10-415-215 COMPUTER SOFTWARE
382.97
487.91
5,000.00
4,512.09
9.8
10-415-220 COMPUTER HARDWARE
4,234.11
4,234.11
6,000.00
1,765.89
70.6
10-415-224 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
165.83
994.98
2,000.00
1,005.02
49.8
66.41
718.86
2,400.00
1,681.14
30.0
.00
27.19
400.00
372.81
6.8
178.52
772.64
1,600.00
827.36
48.3
10-415-237 BUILDING MAINTENANCE
.00
729.13
1,000.00
270.87
72.9
10-415-238 TOWN HALL FURNISHINGS
.00
235.48
1,750.00
1,514.52
13.5
10-415-252 RESALE SUPPLIES
.00
.00
50.00
50.00
.0
10-415-311 POSTAGE/FREIGHT
556.99
2,231.86
4,000.00
1,768.14
55.8
10-415-312 COMPUTER SERVICES
210.00
7,217.50
14,230.00
7,012.50
50.7
10-415-314 ADS & LEGAL NOTICES
59.26
924.59
1,000.00
75.41
92.5
10-415-226 SMALL EQUIPMENT 10-415-231 GAS/FUEL 10-415-232 VEHICLE MAINTENANCE 10-415-233 OFFICE EQUIPMENT MAINTENANCE
10-415-316 DUES & MEMBERSHIPS 10-415-317 BANK FEES 10-415-318 JANITORIAL SERVICES 10-415-319 MISCELLANEOUS SERVICES 10-415-341 ELECTRIC UTILITY 10-415-342 SEWER UTILITY 10-415-343 WATER UTILITY 10-415-344 TELEPHONE UTILITY 10-415-345 NATURAL GAS UTILITY 10-415-346 INTERNET SERVICES 10-415-347 RECYCLING - TOWN HALL 10-415-351 LEGAL SERVICES 10-415-352 AUDIT
.00
1,070.28
1,500.00
429.72
71.4
5.00
60.00
100.00
40.00
60.0
280.00
1,820.00
3,700.00
1,880.00
49.2
.00
75.00
250.00
175.00
30.0
284.74
2,212.29
4,200.00
1,987.71
52.7
.00
483.60
1,000.00
516.40
48.4
.00
602.50
1,500.00
897.50
40.2
325.41
1,984.96
4,500.00
2,515.04
44.1
84.27
1,388.19
3,000.00
1,611.81
46.3
.00
87.45
600.00
512.55
14.6 50.9
38.77
230.94
454.00
223.06
866.38
8,454.48
30,500.00
22,045.52
27.7
.00
8,820.00
8,820.00
.00
100.0
10-415-353 JUDGE-MUNICIPAL COURT
450.00
900.00
1,800.00
900.00
50.0
10-415-355 PROFESSIONAL SERVICES-OTHER
106.00
1,961.00
11,550.00
9,589.00
17.0
10-415-370 TRAINING/TRAVEL
809.81
2,491.84
6,000.00
3,508.16
41.5
.00
.00
500.00
500.00
.0
200.00
584.75
1,000.00
415.25
58.5
10-415-513 PROPERTY/CASUALTY INSURANCE
.00
9,037.27
17,968.00
8,930.73
50.3
10-415-514 POSITION BONDS
.00
337.00
350.00
13.00
96.3
10-415-530 COMMUNITY ENGAGEMENT
.00
.00
300.00
300.00
.0
991.15
991.15
8,000.00
7,008.85
12.4 77.0
10-415-393 DOCUMENT RECORDING 10-415-394 DEVELOPER REIMBURSEMENT
10-415-540 GRANTS TO NEIGHBORHOODS 10-415-560 TREASURER'S FEES
626.81
3,737.10
4,855.00
1,117.90
10-415-721 CHAMBER SERVICE AGREEMENT
8,183.00
16,366.00
32,732.00
16,366.00
50.0
10-415-722 BLC FEE REMITTANCE
7,000.00
14,000.00
28,000.00
14,000.00
50.0
10-415-723 VISITOR CENTER REPAIRS & MAINT 10-415-724 NRL VC OP 10-415-725 95% NRL ADDTL MKTG
.00
.00
10,500.00
10,500.00
.0
7,500.00
15,000.00
30,000.00
15,000.00
50.0
.00
.00
.00
.00
.0
50 % OF THE FISCAL YEAR HAS ELAPSED
9
Page 27 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL 10-415-870 CONTINGENCY - GENERAL ADMIN
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
205.00
205.00
1,000.00
795.00
20.5
.00
.00
1,500.00
1,500.00
.0
63,150.78
258,246.96
553,818.00
295,571.04
46.6
2,622.08
15,353.03
31,164.00
15,810.97
49.3
.00
.00
60.00
60.00
.0
10-421-132 ICMA TOWN PAID BENEFIT
209.76
1,228.22
2,493.00
1,264.78
49.3
10-421-133 HEALTH/DENTAL-EMPLOYEE
10-415-875 MARKETING CONTINGENCY TOTAL ADMINISTRATION
SAFETY 10-421-100 GROSS WAGES - PUBLIC SAFETY 10-421-131 LONGEVITY BENEFIT
849.38
5,102.48
10,207.00
5,104.52
50.0
10-421-135 DEP HEALTH/DENTAL
.00
.00
2,282.00
2,282.00
.0
10-421-136 MEDICAL BENEFIT
.00
.00
1,050.00
1,050.00
.0
22.65
47.26
101.00
53.74
46.8
10-421-141 UNEMPLOYMENT INSURANCE 10-421-142 WORKER'S COMPENSATION 10-421-143 SOCIAL SECURITY MATCH 10-421-144 MEDICARE MATCH
.00
209.26
448.00
238.74
46.7
175.58
1,052.86
2,086.00
1,033.14
50.5
41.06
246.21
488.00
241.79
50.5
10-421-314 DISPATCH OPERATIONS
.00
8,330.50
16,661.00
8,330.50
50.0
10-421-319 MISC PURCHASED SERV
.00
.00
.00
.00
.0
10,150.00
60,900.00
121,800.00
60,900.00
50.0
.00
.00
5,000.00
5,000.00
.0
14,070.51
92,469.82
193,840.00
101,370.18
47.7
10-421-339 SHERIFF'S CONTRACT 10-421-340 SPECIAL EVENT SECURITY TOTAL SAFETY
50 % OF THE FISCAL YEAR HAS ELAPSED
10
Page 28 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS 10-431-100 GROSS WAGES - PUBLIC WORKS 10-431-131 LONGEVITY 10-431-132 ICMA DEFERRED COMPENSATION 10-431-133 HEALTH/DENTAL-EMPLOYEE
14,218.92
88,020.50
215,661.00
127,640.50
.00
2,160.00
3,300.00
1,140.00
40.8 65.5
764.30
4,510.80
17,081.00
12,570.20
26.4 37.0
2,971.71
17,001.34
45,933.00
28,931.66
10-431-135 DEP HEALTH/DENTAL
406.68
2,440.08
29,714.00
27,273.92
8.2
10-431-136 MEDICAL BENEFIT ALLOWANCE
310.12
1,322.10
4,725.00
3,402.90
28.0
10-431-141 UNEMPLOYMENT INSURANCE
129.34
272.20
700.00
427.80
38.9
.00
3,437.46
7,356.00
3,918.54
46.7
923.96
5,822.88
14,428.00
8,605.12
40.4
10-431-144 MEDICARE MATCH
216.12
1,361.97
3,373.00
2,011.03
40.4
10-431-222 GENERAL SUPPLIES
166.97
1,388.68
3,500.00
2,111.32
39.7
.00
259.90
1,500.00
1,240.10
17.3
55.49
182.75
1,500.00
1,317.25
12.2
10-431-231 GAS/FUEL/LIQUIDS
436.12
6,073.64
20,000.00
13,926.36
30.4
10-431-232 VEHICLE MAINTENANCE
145.55
356.11
12,000.00
11,643.89
3.0
10-431-233 EQUIPMENT MAINTENANCE
547.54
5,243.79
25,000.00
19,756.21
21.0
10-431-235 TIRES/CHAINS
.00
.00
4,000.00
4,000.00
.0
10-431-236 MISC. BRIDGE WORK
.00
.00
14,000.00
14,000.00
.0
10-431-237 BUILDING MAINTENANCE
.00
784.58
1,500.00
715.42
52.3
10-431-238 STREET LIGHT MAINTENANCE
.00
790.04
3,000.00
2,209.96
26.3
10-431-142 WORKER'S COMPENSATION 10-431-143 SOCIAL SECURITY MATCH
10-431-224 SAFETY SUPPLIES 10-431-227 SMALL TOOLS
10-431-239 MISCELLANEOUS MAINTENANCE 10-431-242 ROAD MAINTENANCE
199.11
199.11
250.00
50.89
79.6
26,743.95
30,902.27
75,000.00
44,097.73
41.2
10-431-253 TREE REMOVAL
.00
.00
500.00
500.00
.0
10-431-255 STORMWATER FILTER MAINTENANCE
.00
.00
.00
.00
.0
10-431-313 FUEL DEPOT CLEAN UP
.00
.00
.00
10-431-314 ADS/BID NOTICES
.00
1,340.70
500.00
10-431-317 UNIFORM ALLOWANCE 10-431-318 TRASH/RECYCLE SERVICES
(
.00
.0
840.70)
268.1
.00
587.83
2,250.00
1,662.17
26.1
1,387.41
2,433.67
6,000.00
3,566.33
40.6
10-431-319 MISC. PURCHASED SERVICES
250.00
475.00
600.00
125.00
79.2
10-431-341 ELECTRIC UTILITY
426.17
3,117.90
4,200.00
1,082.10
74.2
.00
241.00
500.00
259.00
48.2
10-431-344 TELEPHONE UTILITY
10-431-343 WATER UTILITY
344.27
1,589.14
1,950.00
360.86
81.5
10-431-345 NATURAL GAS UTILITY
132.85
2,151.03
5,000.00
2,848.97
43.0
1,801.78
11,171.79
24,800.00
13,628.21
45.1
10-431-354 ENGINEERING/SURVEYING SERVICES
.00
.00
23,000.00
23,000.00
.0
10-431-355 CAPITAL IMPROVEMENT PLAN
.00
.00
.00
.00
.0
140.42
177.50
1,000.00
822.50
17.8
10-431-399 EQUIP RENTAL
.00
.00
3,000.00
3,000.00
.0
10-431-870 CONTINGENCY- PUBLIC WORKS
.00
.00
500.00
500.00
.0
52,718.78
195,815.76
577,321.00
381,505.24
33.9
10-431-349 STREET LIGHT ELECTRIC UTILITY
10-431-370 TRAINING/TRAVEL
TOTAL PUBLIC WORKS
50 % OF THE FISCAL YEAR HAS ELAPSED
11
Page 29 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
GRAND LAKE CENTER 10-450-100 GROSS WAGES - GL CENTER
.00
.00
.00
.00
.0
10-450-110 GROSS WAGES-GL CENTER SEASONAL
.00
.00
.00
.00
.0
10-450-141 UNEMPLOYMENT INSURANCE
.00
.00
.00
.00
.0
10-450-142 WORKER'S COMPENSATION
.00
.00
.00
.00
.0
10-450-143 SOCIAL SECURITY MATCH
.00
.00
.00
.00
.0
.00
.0
10-450-144 MEDICARE MATCH
.00
.00
.00
372.95
566.80
.00
(
566.80)
.0
10-450-220 COMPUTER HARDWARE
1,450.08
1,450.08
.00
(
1,450.08)
.0
10-450-237 BUILDING MAINTENANCE
10-450-211 GENERAL SUPPLIES
8,988.24
9,148.24
.00
(
9,148.24)
.0
10-450-320 MARKETING
218.81
218.81
.00
(
218.81)
.0
10-450-341 ELECTRIC UTILITY
513.96
3,524.87
.00
(
3,524.87)
.0
.00
1,106.70
.00
(
1,106.70)
.0
10-450-342 SEWER UTILITY 10-450-343 WATER UTILITY
.00
482.00
.00
(
482.00)
.0
133.99
605.48
.00
(
605.48)
.0
10-450-345 NATURAL GAS UTILITY
.00
2,395.02
.00
(
2,395.02)
.0
10-450-355 PURCHASED PROFESSIONAL SERV.
.00
.00
.00
.00
.0
10-450-513 PROPERTY/CASUALTY INSURANCE
.00
2,143.50
.00
(
2,143.50)
.0
10-450-721 DONATIONS - OUT
.00
1,200.00
.00
(
1,200.00)
.0
1,571.50
1,571.50
.00
(
1,571.50)
.0
.00
2,719.56
.00
(
2,719.56)
.0
13,249.53
27,132.56
.00
(
27,132.56)
.0
10-450-344 TELEPHONE UTILITY
10-450-755 EXERCISE EQUIPMENT 10-450-870 CONTINGENCY - GL CENTER TOTAL GRAND LAKE CENTER
50 % OF THE FISCAL YEAR HAS ELAPSED
12
Page 30 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS 10-452-100 GROSS WAGES - PARKS
1,913.58
11,481.48
23,392.00
11,910.52
49.1
862.50
1,166.25
8,460.00
7,293.75
13.8
.00
.00
600.00
600.00
.0
76.54
459.24
1,827.00
1,367.76
25.1
10-452-133 HEALTH/DENTAL-EMPLOYEE
424.69
2,551.24
5,104.00
2,552.76
50.0
10-452-135 DEP. HEALTH/DENTAL
406.67
2,440.02
4,880.00
2,439.98
50.0
.00
54.29
525.00
470.71
10.3
22.09
41.43
101.00
59.57
41.0
.00
437.20
936.00
498.80
46.7
185.02
881.39
2,088.00
1,206.61
42.2
43.27
206.12
489.00
282.88
42.2
2,613.17
5,604.12
14,000.00
8,395.88
40.0
10-452-226 SMALL EQUIPMENT
.00
.00
900.00
900.00
.0
10-452-232 BEAR PROOF CANS MAINTENANCE
.00
.00
1,500.00
1,500.00
.0
10-452-233 EQUIPMENT MAINTENANCE
.00
364.15
1,600.00
1,235.85
22.8
10-452-234 INFORMATION SIGNS
.00
.00
6,500.00
6,500.00
.0
10-452-235 GREENBELT MAINTENANCE
.00
.00
5,000.00
5,000.00
.0
10-452-110 GROSS WAGES-PARKS SEASONAL 10-452-131 LONGEVITY 10-452-132 ICMA DEFERRED COMPENSATION
10-452-136 MEDICAL BENEFIT ALLOWANCE 10-452-141 UNEMPLOYMENT INSURANCE 10-452-142 WORKERS COMPENSATION 10-452-143 SOCIAL SECURITY MATCH 10-452-144 MEDICARE MATCH 10-452-220 OPERATING SUPPLIES
10-452-236 SAND & DREDGE
877.07
877.07
500.00
10-452-237 BUILDING MAINTENANCE
421.56
610.42
6,300.00
5,689.58
9.7
10-452-238 ADA DOCK MAINTENANCE
12.57
12.57
1,000.00
987.43
1.3
10-452-239 MISCELLANEOUS MAINTENANCE
(
175.4
.00
4,498.88
250.00
7.49
7.49
1,000.00
992.51
.00
.00
500.00
500.00
.0
98.40
98.40
1,500.00
1,401.60
6.6
10-452-248 IRRIGATION SYSTEM MAINTENANCE
196.79
214.05
2,000.00
1,785.95
10.7
10-452-319 MISCELLANEOUS SERVICES
990.00
990.00
.00
10-452-341 ELECTRIC UTILITY
484.20
3,547.26
6,700.00
10-452-243 BENCHES/PLANTERS/FENCES 10-452-244 THOMASSON PARK MAINTENANCE 10-452-246 ICE RINK/VOLLEYBALL COURT
(
377.07)
(
4,248.88) 1799.6
990.00) 3,152.74
.8
.0 52.9
10-452-342 SEWER UTILITY
.00
213.90
450.00
236.10
47.5
10-452-343 WATER UTILITY
60.00
2,947.50
9,500.00
6,552.50
31.0 45.1
10-452-345 NATURAL GAS UTILITY
162.73
1,577.36
3,500.00
1,922.64
10-452-350 GLE UTILITIES
.00
.00
.00
.00
.0
10-452-399 EQUIPMENT RENTAL
.00
405.25
1,000.00
594.75
40.5
10-452-400 GRAND AVENUE GARDENS
.00
.00
2,000.00
2,000.00
.0
10-452-450 PARK IMPROVEMENTS
.00
.00
3,000.00
3,000.00
.0
10-452-870 CONTINGENCY - PARKS
.00
.00
500.00
500.00
.0
10-452-961 MEMORIAL BENCHES
.00
.00
1,500.00
1,500.00
.0
9,858.34
41,687.08
119,102.00
77,414.92
35.0
TOTAL PARKS
ADMIN DEBT SERVICE 10-815-100 SALES TAX BONDS PRINCIPAL
.00
.00
85,000.00
85,000.00
.0
10-815-110 SALES TAX BONDS INTEREST
.00
1,324.95
3,086.00
1,761.05
42.9
10-815-982 LAND ACQUISITION - PRINCIPAL
2,947.97
4,366.30
12,002.00
7,635.70
36.4
10-815-983 LAND ACQUISITION-INTEREST
3,520.77
8,571.18
13,873.00
5,301.82
61.8
6,468.74
14,262.43
113,961.00
99,698.57
12.5
TOTAL ADMIN DEBT SERVICE
50 % OF THE FISCAL YEAR HAS ELAPSED
13
Page 31 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS DEBT SERVICE 10-831-500 CAPITAL EQUIP LEASE PRINCIPAL
965.87
5,753.34
11,608.00
5,854.66
49.6
10-831-510 EQUIPMENT LEASE INTEREST
371.28
2,269.56
4,438.00
2,168.44
51.1
1,337.15
8,022.90
16,046.00
8,023.10
50.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
16,987.00
6,152.08
12,875.68
11,500.00
TOTAL PUBLIC WORKS DEBT SERVICE
ADMIN CAPITAL 10-915-923 TOWN HALL CAPITAL OUTLAY TOTAL ADMIN CAPITAL
POLICE 10-921-993 VEHICLE-BIANNUAL REPLACEMENT TOTAL POLICE
PUBLIC WORKS CAPITAL 10-931-900 DEVELOPMENT REMEDIATION 10-931-910 CAPITAL EQUIPMENT PURCHASE
(
16,987.00
.0
1,375.68)
112.0 .0
10-931-911 CAPITALIZED EQUIPMENT REPAIR
.00
.00
.00
.00
10-931-921 PAVING
.00
.00
25,000.00
25,000.00
.0
10-931-922 DRAINAGE
.00
.00
20,000.00
20,000.00
.0
10-931-971 LEASE PURCHASE CAPITAL
.00
.00
.00
.00
.0
10-931-972 W PORTAL BRIDGE REHAB
.00
.00
867,600.00
867,600.00
.0
10-931-973 PUBLIC WAY FINDING SIGNS
.00
.00
16,000.00
16,000.00
.0
10-931-974 STREETSCAPE
.00
.00
28,000.00
28,000.00
.0
10-931-975 PROJECT PLANNING
.00
.00
.00
.00
.0
6,152.08
12,875.68
985,087.00
972,211.32
1.3
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
TOTAL PUBLIC WORKS CAPITAL
GL CENTER CAPITAL 10-950-700 PROPERTY/BUILDINGS TOTAL GL CENTER CAPITAL
50 % OF THE FISCAL YEAR HAS ELAPSED
14
Page 32 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS CAPITAL 10-952-500 ADA DOCKS
1,514.00
5,325.64
80,000.00
74,674.36
6.7
10-952-971 PARK IMPROVEMENTS
.00
.00
2,000.00
2,000.00
.0
10-952-972 BOARDWALKS
.00
.00
.00
.00
.0
10-952-974 CAPITAL IMPROVEMENTS (PARKS)
.00
.00
.00
.00
.0
10-952-975 PROJECT PLANNING
.00
.00
.00
.00
.0
10-952-980 WATER FOUNTAINS
.00
.00
8,000.00
8,000.00
.0
10-952-995 LAKEFRONT IMPROVEMENTS
.00
.00
22,000.00
22,000.00
.0
1,514.00
5,325.64
112,000.00
106,674.36
4.8
190,905.63
711,290.45
2,873,125.00
2,161,834.55
24.8
TOTAL PARKS CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
(
98,480.34) (
183,214.80)
(
231,378.00)
(
48,163.20) ( 79.2)
50 % OF THE FISCAL YEAR HAS ELAPSED
15
Page 33 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 WATER FUND ASSETS 20-100000 CASH IN COMBINED CASH FUND
632,526.61
20-102000 CSAFE
62,121.84
20-109100 COLOTRUST
303,138.81
20-116000 PETTY CASH
.00
20-117000 ACCTS RECEIVABLE/WATER SALES
3,647.65
20-118000 ASSET - LAND
2,270.00
20-119000 ASSET - DISTRIBUTION SYSTEM
2,661,517.28
20-122000 ASSET-TREATMENT FACILITY
176,814.12
20-124000 ASSET - WELLS
123,640.53
20-125000 ASSET-TANK RESERVOIR
214,067.22
20-126000 ASSET-EQUIPMENT
219,992.78
20-127000 ASSET-METERS/INSTL IN PROGRESS
4,870.80
20-128000 ASSET-CONSTRUCTION IN PROGRESS 20-129000 ACCUM. DEPRECIATION/ALL PRPRTY
13,860.86 (
20-133000 ASSET/BLDG-TOWN HALL
2,219,153.00) 26,934.62
20-135000 DUE FROM GENERAL FUND
.00
20-136000 DUE FROM MARINA FUND
.00
TOTAL ASSETS
2,226,250.12
LIABILITIES AND EQUITY
LIABILITIES 20-200000 ACCOUNTS PAYABLE GENERAL
35,127.78
20-201000 DWRF PAYABLE-CURRENT
.00
20-201001 DWRF PAYABLE-PRINCIPAL
.00
20-201002 DWRF PAYABLE-ACCRUED INTEREST
.00
20-217000 WAGES PAYABLE
.00
20-217100 SOCIAL SECURITY PAYABLE
.00
20-217200 FEDERAL W/H PAYABLE
.00
20-217300 STATE TAX W/H PAYABLE
.00
20-217400 MEDICARE WITHHOLDING
.00
20-218100 HEALTH/DENTAL/VISION
2.97
20-219100 FLEX MEDICAL
144.00
20-220000 ICMA W/H PAYABLE
.00
20-221000 ICMA LOAN PAYABLE
.00
20-221001 ICMA/ROTH IRA
.00
20-223000 ACCRUED VACATION PAYABLE
36,383.50
20-231000 DUE TO G.F. FROM WATER FUND
.00
20-240001 CAP LEASE PRINCIPAL-CURRENT
.00
20-240002 CAP LEASE-ACCRUED INTEREST
.00
TOTAL LIABILITIES
71,658.25
FUND EQUITY 20-275000 UNAPPROP. RETAINED EARNINGS
(
20-281000 CIP RESERVE
849,732.43) 800,400.00
20-285000 RET. ERNGS/DWRF 110% DEBT SRVC
.00
20-287000 CONTRIBUTED CAPITAL EQUITY
2,215,142.08
50 % OF THE FISCAL YEAR HAS ELAPSED
16
Page 34 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 WATER FUND
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
11,217.78) (
11,217.78)
TOTAL FUND EQUITY
2,154,591.87
TOTAL LIABILITIES AND EQUITY
2,226,250.12
50 % OF THE FISCAL YEAR HAS ELAPSED
17
Page 35 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
WATER REVENUES 20-344-100 WATER SALES 20-344-110 TAP FEES - CAPITAL
145.96
251,557.42
494,774.00
243,216.58
50.8
6,500.00
16,466.68
16,467.00
.32
100.0
20-344-120 RESALE METERS
449.19
1,347.57
1,000.00
(
347.57)
134.8
20-344-140 INTEREST REVENUE
260.68
1,524.88
1,000.00
(
524.88)
152.5
.00
190.84
.00
(
190.84)
110.00
260.00
700.00
440.00
37.1
.00
.00
270,000.00
270,000.00
.0
TOTAL WATER REVENUES
7,465.83
271,347.39
783,941.00
512,593.61
34.6
TOTAL FUND REVENUE
7,465.83
271,347.39
783,941.00
512,593.61
34.6
20-344-160 MISC. REVENUES 20-344-190 BULK WATER PERMITS 20-344-910 HYDRO PROJECT FUNDING
50 % OF THE FISCAL YEAR HAS ELAPSED
.0
18
Page 36 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
WATER OPERATIONS 20-430-100 GROSS WAGES - WATER 20-430-110 GROSS WAGES -WATER SEASONAL 20-430-111 ON CALL PAY 20-430-119 YEAR END LEAVE EXPENSE 20-430-131 LONGEVITY
15,853.13
89,027.75
189,069.00
100,041.25
.00
.00
.00
.00
47.1 .0
1,400.00
9,100.00
18,200.00
9,100.00
50.0
.00
.00
15,000.00
15,000.00
.0
48.00
252.00
2,450.00
2,198.00
10.3
20-430-132 ICMA DEFERRED COMPENSATION
1,095.78
6,514.34
14,086.00
7,571.66
46.3
20-430-133 HEALTH/DENTAL-EMPLOYEE
2,473.14
15,642.83
31,587.00
15,944.17
49.5
2.36
55.96
26,526.00
26,470.04
.2
20-430-136 MEDICAL BENEFIT ALLOWANCE
897.26
1,384.57
3,174.00
1,789.43
43.6
20-430-141 UNEMPLOYMENT INSURANCE
149.78
298.99
666.00
367.01
44.9
.00
1,986.64
4,251.00
2,264.36
46.7
1,151.52
6,571.42
13,740.00
7,168.58
47.8
20-430-144 MEDICARE MATCH
269.32
1,536.93
3,214.00
1,677.07
47.8
20-430-210 OFFICE SUPPLIES
.00
709.98
1,500.00
790.02
47.3
20-430-135 DEP HEALTH/DENTAL
20-430-142 WORKER'S COMPENSATION 20-430-143 SOCIAL SECURITY MATCH
20-430-211 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
20-430-215 COMPUTER SOFTWARE
.00
.00
5,000.00
5,000.00
.0
.00
.00
15,000.00
15,000.00
.0
2,418.04
5,366.81
12,000.00
6,633.19
44.7
20-430-220 COMPUTER HARDWARE 20-430-221 CHEMICALS 20-430-222 LAB SUPPLIES/EQUIPMENT
.00
189.40
1,000.00
810.60
18.9
20-430-223 WELL/PLANT SUPPLIES
.00
566.80
750.00
183.20
75.6
20-430-225 METER PARTS
23.00
23.00
1,000.00
977.00
2.3
20-430-227 SMALL EQUIPMENT/TOOLS
.00
.00
2,500.00
2,500.00
.0
20-430-228 SAFETY EQUIPMENT
.00
.00
250.00
250.00
.0
20-430-229 MISC OPERATING SUPPLIES
.00
.00
100.00
100.00
.0
20-430-231 GAS/FUEL/FLUIDS
218.38
1,124.34
5,000.00
3,875.66
22.5
20-430-232 VEHICLE MAINTENANCE
.00
32.68
1,000.00
967.32
3.3
20-430-233 EQUIPMENT MAINTENANCE
.00
.00
1,500.00
1,500.00
.0
20-430-234 WELL/PLANT MAINTENANCE
.00
.00
5,000.00
5,000.00
.0
20-430-235 TIRES & CHAINS
.00
.00
800.00
800.00
.0
255.32
613.34
1,000.00
386.66
61.3 10.2
20-430-237 BUILDING MAINTENANCE 20-430-238 DISTRIBUTION LINE MAINTENANCE
66.71
1,424.58
14,000.00
12,575.42
20-430-239 MISC. MAINTENANCE
.00
.00
300.00
300.00
.0
20-430-240 ROAD MATERIALS
.00
.00
5,000.00
5,000.00
.0
20-430-241 MOTORS & PUMPS
.00
207.48
1,500.00
1,292.52
13.8
273.84
273.84
500.00
226.16
54.8
20-430-252 RESALE METERS
.00
.00
6,000.00
6,000.00
.0
20-430-253 COGS-METER
.00
.00
2,000.00
2,000.00
.0
20-430-255 WRITE-OFF EXPENSE
.00
.00
.00
.00
.0 20.0
20-430-251 RESALE PARTS
20-430-310 MISC SERVICE FEES
.00
10.00
50.00
40.00
20-430-311 POSTAGE/FREIGHT
.00
1,296.55
2,000.00
703.45
64.8
20-430-314 LEGAL NOTICES/ADS
.00
231.99
500.00
268.01
46.4
20-430-316 MEMBERSHIPS 20-430-317 UNIFORM ALLOWANCE 20-430-318 TESTING SERVICES 20-430-319 MISCELLANEOUS SERVICES 20-430-320 TELEMETRY MAINTENANCE 20-430-321 COMPUTER SYSTEM SUPPORT 20-430-341 ELECTRIC UTILITY 20-430-344 TELEPHONE UTILITY
.00
275.00
700.00
425.00
39.3
98.26
98.26
900.00
801.74
10.9
933.97
993.97
4,800.00
3,806.03
20.7
.00
.00
350.00
350.00
.0
3,317.68
3,317.68
2,500.00
817.68)
132.7
(
210.00
2,805.00
7,690.00
4,885.00
36.5
2,583.46
15,241.77
29,500.00
14,258.23
51.7 46.8
171.53
1,169.24
2,500.00
1,330.76
83.47
2,123.41
5,000.00
2,876.59
42.5
20-430-347 INTERNET SERVICE
.00
180.00
180.00
.00
100.0
20-430-351 LEGAL SERVICES
.00
.00
10,000.00
10,000.00
.0
20-430-345 NATURAL GAS UTILITY
50 % OF THE FISCAL YEAR HAS ELAPSED
19
Page 37 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
20-430-352 AUDIT
.00
2,520.00
2,520.00
.00
20-430-354 SYSTEM ANALYSIS/ENG & SURVEY
.00
.00
35,000.00
35,000.00
.0
20-430-355 STATE FEES
.00
.00
500.00
500.00
.0
20-430-370 TRAINING/TRAVEL 20-430-513 PROPERTY/CASUALTY INSURANCE 20-430-514 POSITION BONDS
8.68
251.78
2,000.00
1,748.22
12.6
.00
4,069.74
8,139.00
4,069.26
50.0
.00
100.0
.00
200.00
200.00
8,201.87
49,211.22
.00
20-430-870 CONTINGENCY-OPERATIONS
.00
.00
TOTAL WATER OPERATIONS
42,204.50
20-830-640 DWRF LOAN - PRINCIPAL 20-830-645 DWRF LOAN - INTEREST
20-430-700 DEPRECIATION RESERVE
100.0
(
49,211.22)
.0
1,000.00
1,000.00
.0
226,899.29
520,692.00
293,792.71
43.6
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0 .0
WATER DEBT SERVICE
20-830-660 CWRPDA LOAN - PRINCIPAL
.00
.00
13,000.00
13,000.00
20-830-661 CWRPDA LOAN - INTEREST
.00
.00
3,000.00
3,000.00
.0
20-830-970 LEASE PURCHASE PRINCIPAL
.00
.00
.00
.00
.0
20-830-975 LEASE PURCHASE INTEREST
.00
.00
.00
.00
.0
.00
.00
16,000.00
16,000.00
.0
TOTAL WATER DEBT SERVICE
WATER CAPITAL 20-930-994 SYSTEM UPGRADES
.00
.00
.00
.00
.0
20-930-995 CAPITAL CONTINGENCY
.00
.00
5,000.00
5,000.00
.0
20-930-997 CAPITAL DIRECT PURCHASE
.00
.00
.00
.00
.0
20-930-998 HYDRO POWER GENERATOR
27,926.76
55,665.88
285,000.00
229,334.12
19.5
TOTAL WATER CAPITAL
27,926.76
55,665.88
290,000.00
234,334.12
19.2
TOTAL FUND EXPENDITURES
70,131.26
282,565.17
826,692.00
544,126.83
34.2
NET REVENUE OVER EXPENDITURES
(
62,665.43) (
11,217.78) (
42,751.00)
(
31,533.22) ( 26.2)
50 % OF THE FISCAL YEAR HAS ELAPSED
20
Page 38 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 MARINA FUND ASSETS 40-100000 CASH IN COMBINED CASH FUND
288,581.87
40-116000 PETTY CASH
525.00
40-117000 ACCOUNTS RECEIVABLE
.00
40-118000 ASSET - BOATS
206,015.34
40-119000 ASSET - OTHER
7,480.69
40-123000 DUE TO MARINA FROM GF
.00
40-129000 ACCUM DEPRECIATION/ALL PROP
(
120,031.51)
TOTAL ASSETS
382,571.39
LIABILITIES AND EQUITY
LIABILITIES 40-200000 ACCOUNTS PAYABLE GENERAL
1,588.51
40-201000 GF PAYABLE-CURRENT
.00
40-201001 GF PAYABLE - PRINCIPAL
.00
40-201002 GF LOAN ACCRUED INTEREST
.00
40-217000 WAGES PAYABLE
.00
40-217100 SOCIAL SECURITY PAYABLE
.00
40-217200 FEDERAL W/H PAYABLE
.00
40-217300 STATE TAX W/H PAYABLE
.00
40-217400 MEDICARE WITHHOLDING
.00
40-218100 HEALTH/DENTAL/VISION
4.32
40-219100 FLEX MEDICAL
36.00
40-220000 ICMA W/H PAYABLE
.00
40-221000 ICMA LOAN PAYABLE
.00
40-221001 ICMA/ROTH IRA
.00
40-223000 ACCRUED VACATION PAYABLE
385.33
40-231000 DUE TO GF FROM MARINA
.00
40-232000 DUE TO WATER FROM MARINA
.00
TOTAL LIABILITIES
2,014.16
FUND EQUITY 40-275000 UNAPPROP. RETAINED EARNINGS
358,948.50
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
21,608.73
BALANCE - CURRENT DATE
21,608.73
TOTAL FUND EQUITY
380,557.23
TOTAL LIABILITIES AND EQUITY
382,571.39
50 % OF THE FISCAL YEAR HAS ELAPSED
21
Page 39 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
MARINA REVENUES 40-344-110 BOAT RENTALS
11,970.00
14,280.00
.00
40-344-113 RENTALS (NON-TAXABLE)
34,313.00
38,576.00
135,000.00
(
14,280.00) 96,424.00
28.6
.0
40-344-115 TOURS
29.1
15,166.00
17,466.00
60,000.00
42,534.00
40-344-120 BUILDING SPACE RENTAL
1,100.00
1,100.00
3,300.00
2,200.00
33.3
40-344-140 SEASONAL SLIP RENTALS
.00
12,250.00
12,250.00
.00
100.0 85.2
350.00
2,300.00
2,700.00
400.00
40-344-150 DAILY SLIP RENTAL
40-344-145 KAYAK SLIP RENTAL
.00
.00
200.00
200.00
40-344-160 MISC REVENUE
.00
922.00
600.00
40-344-170 INTEREST EARNED
(
.0
322.00)
153.7
37.93
232.69
400.00
167.31
58.2
250.00
250.00
300.00
50.00
83.3
40-344-190 WINTER STORAGE
.00
.00
.00
.00
.0
40-344-200 SALE OF ASSETS
.00
.00
14,000.00
14,000.00
.0
40-344-210 GF TOUR/RENTAL CONTRIBUTIONS
.00
.00
1,820.00
1,820.00
.0
TOTAL MARINA REVENUES
63,186.93
87,376.69
230,570.00
143,193.31
37.9
TOTAL FUND REVENUE
63,186.93
87,376.69
230,570.00
143,193.31
37.9
40-344-180 BOAT DAMAGE
50 % OF THE FISCAL YEAR HAS ELAPSED
22
Page 40 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA OPERATIONS 40-460-100 GROSS WAGES - MARINA
1,147.99
5,365.21
10,090.00
4,724.79
53.2
15,824.66
30,317.98
85,000.00
54,682.02
35.7
40-460-119 ACCRUED LEAVE EXPENSE
.00
.00
1,000.00
1,000.00
.0
40-460-131 LONGEVITY
.00
51.00
72.00
21.00
70.8
40-460-110 GROSS WAGES - MARINA SEASONAL
40-460-132 ICMA DEFERRED COMPENSATION
53.06
319.60
807.00
487.40
39.6
124.54
944.79
1,964.00
1,019.21
48.1
.59
13.98
1,301.00
1,287.02
1.1
40-460-136 MEDICAL BENEFIT ALLOWANCE
42.12
104.58
185.00
80.42
56.5
40-460-141 UNEMPLOYMENT INSURANCE
99.65
107.50
288.00
180.50
37.3
.00
2,100.72
4,496.00
2,395.28
46.7
1,059.22
2,239.35
5,950.00
3,710.65
37.6
40-460-133 HEALTH/DENTAL - EMPLOYEE 40-460-135 DEP HEALTH/DENTAL
40-460-142 WORKERS COMPENSATION 40-460-143 SOCIAL SECURITY MATCH 40-460-144 MEDICARE MATCH
247.69
523.57
1,392.00
868.43
37.6
54.82
104.81
1,000.00
895.19
10.5
40-460-214 SMALL EQUIP/COMP HRDWARE
.00
.00
450.00
450.00
.0
40-460-220 COMPUTER HARDWARE
.00
.00
.00
.00
.0
40-460-222 SHOP SUPPLIES
107.42
208.55
2,000.00
1,791.45
10.4
40-460-223 BOAT SUPPLIES
8.58
8.58
2,000.00
1,991.42
.4
.00
.00
500.00
500.00
.0 15.0
40-460-211 GENERAL OFFICE SUPPLIES
40-460-227 TOOLS
703.47
747.49
5,000.00
4,252.51
40-460-232 VEHICLE MAINTENANCE
40-460-231 FUEL
.00
.00
500.00
500.00
.0
40-460-233 EQUIPMENT MAINTENANCE
.00
589.84
4,000.00
3,410.16
14.8
625.45
769.62
10,000.00
9,230.38
7.7
40-460-312 COMPUTER SERVICES
40-460-237 BUILDING/FACILITY MAINTENANCE
.00
675.96
1,352.00
676.04
50.0
40-460-314 ADS AND LEGAL NOTICES
.00
.00
300.00
300.00
.0
40-460-316 DUES/MEMBERSHIPS
.00
.00
500.00
500.00
.0
40-460-317 UNIFORMS
.00
1,179.75
1,000.00
179.75)
118.0
(
40-460-318 MISCELLANEOUS SERVICES
.00
144.00
500.00
356.00
28.8
40-460-320 MARKETING
.00
515.83
1,000.00
484.17
51.6
1,124.32
1,284.25
4,000.00
2,715.75
32.1
46.43
204.64
600.00
395.36
34.1
40-460-330 BANK/CREDIT CARD FEES 40-460-341 ELECTRIC UTILITY 40-460-342 SEWER UTILITY
.00
186.00
400.00
214.00
46.5
40-460-343 WATER UTILITY
.00
241.00
500.00
259.00
48.2
179.56
817.12
1,100.00
282.88
74.3
.00
347.25
600.00
252.75
57.9
40-460-351 LICENSES
.00
.00
165.00
165.00
.0
40-460-360 SALES TAX
.00
.00
.00
.00
.0
40-460-370 TRAINING/TRAVEL
.00
.00
500.00
500.00
.0
40-460-510 LEGAL
.00
.00
2,000.00
2,000.00
.0
40-460-512 AUDIT
.00
1,103.00
1,103.00
.00
100.0
40-460-513 PROPERTY/CASUALTY INSURANCE
.00
108.99
218.00
109.01
50.0
40-460-514 POSITION BONDS
.00
124.00
124.00
.00
100.0
40-460-515 ENGINEERING/SURVEY
.00
.00
1,000.00
1,000.00
.0
40-460-516 SITE LEASE
.00
.00
1.00
1.00
.0
2,386.50
14,319.00
.00
.00
.00
23,836.07
65,767.96
40-460-344 TELEPHONE UTILITY 40-460-350 BOAT REGISTRATION
40-460-700 DEPRECIATION RESERVE 40-460-870 CONTINGENCY TOTAL MARINA OPERATIONS
(
14,319.00)
.0
1,000.00
1,000.00
.0
155,958.00
90,190.04
42.2
50 % OF THE FISCAL YEAR HAS ELAPSED
23
Page 41 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA CAPITAL 40-960-610 CAPITAL EQUIPMENT
.00
.00
50,000.00
50,000.00
.0
40-960-995 LAKEFRONT IMPROVEMENTS
.00
.00
10,000.00
10,000.00
.0
.00
.00
60,000.00
60,000.00
.0
TOTAL FUND EXPENDITURES
23,836.07
65,767.96
215,958.00
150,190.04
30.5
NET REVENUE OVER EXPENDITURES
39,350.86
21,608.73
14,612.00
TOTAL MARINA CAPITAL
(
6,996.73)
50 % OF THE FISCAL YEAR HAS ELAPSED
147.9
24
Page 42 of 46
TOWN OF GRAND LAKE BALANCE SHEET JUNE 30, 2016 PAY-AS-YOU-THROW FUND ASSETS 50-100000 CASH IN COMBINED CASH FUND
71,575.06
50-116000 PETTY CASH
50.00
50-117000 ACCOUNTS RECEIVABLE
.00
50-127000 ASSET - BAG INVENTORY
2,890.46
TOTAL ASSETS
74,515.52
LIABILITIES AND EQUITY
LIABILITIES 50-200000 ACCOUNTS PAYABLE GENERAL
1,549.93
50-231000 DUE TO G.F. FROM PAYT
.00
TOTAL LIABILITIES
1,549.93
FUND EQUITY 50-275000 UNAPPROP. RETAINED EARNINGS
63,085.92
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
9,879.67
BALANCE - CURRENT DATE
9,879.67
TOTAL FUND EQUITY
72,965.59
TOTAL LIABILITIES AND EQUITY
74,515.52
50 % OF THE FISCAL YEAR HAS ELAPSED
25
Page 43 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
PAYT REVENUES 50-344-110 BAGS: DIRECT SALES (T)
176.00
429.00
1,060.00
631.00
9,134.00
17,483.00
45,400.00
27,917.00
38.5
9.57
57.12
100.00
42.88
57.1
TOTAL PAYT REVENUES
9,319.57
17,969.12
46,560.00
28,590.88
38.6
TOTAL FUND REVENUE
9,319.57
17,969.12
46,560.00
28,590.88
38.6
50-344-115 BAGS: VENDOR PURCHASE (NT) 50-344-140 INTEREST REVENUE
50 % OF THE FISCAL YEAR HAS ELAPSED
40.5
26
Page 44 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING JUNE 30, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PAYT OPERATIONS 50-470-200 BAGS FOR RESALE
.00
2,248.29
9,500.00
7,251.71
50-470-250 COGS - BAGS
.00
.00
4,000.00
4,000.00
.0
2,780.31
4,837.62
20,000.00
15,162.38
24.2 50.0
50-470-300 DUMPSTER SERVICE 50-470-301 RECYCLING CONTRIBUTION
23.7
125.00
750.00
1,500.00
750.00
50-470-310 SITE LEASE
.00
.00
1.00
1.00
.0
50-470-312 COMPUTER SERVICES
.00
96.54
193.00
96.46
50.0
50-470-315 SITE MAINTENANCE
.00
.00
2,000.00
2,000.00
.0
50-470-320 BUSINESS LICENSE
.00
.00
165.00
165.00
.0
50-470-330 COMPUTER HARDWARE
.00
.00
.00
.00
.0
50-470-350 SALES TAX
.00
.00
84.00
84.00
.0
50-470-512 AUDIT
.00
157.00
157.00
.00
100.0
50-470-870 CONTINGENCY
.00
.00
1,000.00
1,000.00
.0
TOTAL PAYT OPERATIONS
2,905.31
8,089.45
38,600.00
30,510.55
21.0
TOTAL FUND EXPENDITURES
2,905.31
8,089.45
38,600.00
30,510.55
21.0
NET REVENUE OVER EXPENDITURES
6,414.26
9,879.67
7,960.00
1,919.67)
124.1
(
50 % OF THE FISCAL YEAR HAS ELAPSED
27
Page 45 of 46
CASH AND INVESTMENT ACCOUNT BALANCES AT: Combined Cash Grand Mountain Bank Checking Money Market Utility Cash Clearing Combined Cash Totals
$5,754.94 $1,487,315.08 $870.87 $1,493,940.89
Developer LOC Checking*
$501,257.35
Water Fund
$632,526.61
Marina Fund
PAYT
$288,581.87
$71,575.06
$16,427.47 *Letter of Credit Funds - Restricted Use Non-Interest Bearing Holding Account
CSAFE General Fund Water Fund ColoTrust
General Fund
June 30, 2016
$185,924.67 $62,121.84 $605,846.65
$302,707.84
Gill & Associates
$100,000.11
Advantage Bank CD
$100,140.65
FlatIrons Bank CD $96,000 Principal Interest paid monthly
$303,138.81
$96,000.00
TOTAL
$1,302,458.09
TOTAL CASH/INVESTMENTS AT:
6/30/2016
$997,787.26
$288,581.87
$71,575.06
$2,660,402.28
Page 46 of 46
