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 MAY 31, 2016 COMBINED CASH ACCOUNTS 01-101000 GMB CHECKING - OPERATIONS
9,790.74
01-105000 GMB MONEY MARKET
1,505,843.37
01-106000 RETURNED CHECK CLEARING ACCT
.00
01-107500 UTILITY CASH CLEARING ACCT
1,460.27
TOTAL COMBINED CASH
1,517,094.38
01-100000 CASH ALLOCATED TO OTHER FUNDS
(
1,517,094.38)
TOTAL UNALLOCATED CASH
.00
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
556,253.04
20 ALLOCATION TO WATER FUND
649,519.61
40 ALLOCATION TO MARINA FUND
246,293.91
50 ALLOCATION TO PAY-AS-YOU-THROW FUND
65,027.82
TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 01-100000
1,517,094.38 (
1,517,094.38)
ZERO PROOF IF ALLOCATIONS BALANCE
.00
42 % OF THE FISCAL YEAR HAS ELAPSED
1
Page 19 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 GENERAL FUND ASSETS 10-100000 CASH IN COMBINED CASH FUND
556,253.04
10-103000 CSAFE
185,590.77
10-106000 ADVANTAGE BANK - CD
100,140.65
10-109100 COLOTRUST
302,558.23
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
.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
451.67
10-129000 UNLEADED GAS INVENTORY
635.26
10-130000 DIESEL INVENTORY
1,082.14
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
99,832.00
TOTAL ASSETS
1,600,778.23
LIABILITIES AND EQUITY
LIABILITIES 10-200000 ACCOUNTS PAYABLE GENERAL
41,432.58
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
11.62) 1,512.50
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
57,767.77
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
371,315.48
42 % OF THE FISCAL YEAR HAS ELAPSED
2
Page 20 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 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
(
84,734.46) (
84,734.46)
TOTAL FUND EQUITY
1,229,462.75
TOTAL LIABILITIES AND EQUITY
1,600,778.23
42 % OF THE FISCAL YEAR HAS ELAPSED
3
Page 21 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
53,688.86
155,512.14
241,557.00
86,044.86
64.4
1,242.26
4,734.34
14,000.00
9,265.66
33.8
500.00
565.38
2,216.48
.00
(
11,854.99
65.38)
20,000.00
8,145.01
( 13.1) 59.3
39,568.22
134,292.16
1,164,718.00
1,030,425.84
11.5
.00
.00
30,000.00
30,000.00
.0
239.15
1,053.81
3,000.00
1,946.19
35.1
96,954.97
307,382.06
1,473,775.00
1,166,392.94
20.9
UTILITY FRANCHISES 10-316-170 CABLE FRANCHISE FEES
.00
.00
16,000.00
16,000.00
.0
10-316-171 TELEPHONE FRANCHISE
.00
1,005.00
4,224.00
3,219.00
23.8
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
1,215.70
4,459.32
14,000.00
9,540.68
31.9
1,215.70
14,838.20
64,224.00
49,385.80
23.1
LICENSES & PERMITS 650.00
4,261.25
2,000.00
2,261.25)
213.1
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
10.00
30.00
400.00
370.00
7.5
10-321-130 MOTOR VEHICLE LICENSE
154.00
549.50
2,000.00
1,450.50
27.5
10-321-140 SIGN PERMIT
40.00
50.00
350.00
300.00
14.3
10-321-150 GRADING PERMIT
35.00
35.00
50.00
10-321-160 ANIMAL LICENSE
15.00
130.00
100.00
10-321-170 ENCROACHMENT PERMIT/LICENSE 10-321-175 BUSINESS LICENSE COMMISSION 10-321-180 NIGHTLY RENTAL LICENSE TOTAL LICENSES & PERMITS
(
15.00
70.0
30.00)
130.0
20.00
20.00
300.00
280.00
574.50
1,129.50
29,000.00
27,870.50
3.9
.00
30,000.00
30,000.00
.00
100.0
1,498.50
36,205.25
64,200.00
27,994.75
56.4
42 % OF THE FISCAL YEAR HAS ELAPSED
6.7
4
Page 22 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
10-335-200 HIGHWAY USER TAX FUND
2,703.34
10,101.58
30,063.00
19,961.42
33.6
10-335-800 CONSERVATION TRUST FUND
.00
546.57
2,000.00
1,453.43
27.3
10-335-900 OTHER INTERGOVERNMENTAL
.00
.00
4,000.00
4,000.00
.0
2,703.34
13,816.15
42,399.00
28,582.85
32.6
TOTAL INTERGOVERNMENTAL REVENUES
CHARGES FOR SERVICES 10-341-100 COURT FEES 10-341-200 CEMETERY
.00
.00
50.00
50.00
.0
1,900.00
3,650.00
5,000.00
1,350.00
73.0
10-341-201 HEADSTONE DEPOSIT
800.00
1,200.00
1,600.00
400.00
75.0
10-341-300 ZONING & SUBDIVISION REVIEW
135.00
3,824.00
4,000.00
176.00
95.6
10-341-400 ATTAINABLE HOUSING FEE
109.00
19,049.50
20,000.00
950.50
95.3
71.28
308.56
1,100.00
791.44
28.1
10-341-600 FUEL DEPOT SURCHARGE 10-341-700 COPIES/FAXES/SODA 10-341-850 NIGHTLY RENTAL APPLICATION FEE TOTAL CHARGES FOR SERVICES
4.25
4.25
50.00
45.75
8.5
150.00
150.00
300.00
150.00
50.0
3,169.53
28,186.31
32,100.00
3,913.69
87.8
GRAND LAKE CENTER 10-350-100 GL CENTER - RENTS
2,080.00
4,720.00
.00
(
4,720.00)
.0
10-350-110 GL CENTER - MERCH SALES
1,878.00
1,878.00
.00
(
1,878.00)
.0
10-350-200 GL CENTER - DONATIONS
1,176.50
5,376.50
.00
(
5,376.50)
.0
5,134.50
11,974.50
.00
(
11,974.50)
.0
TOTAL GRAND LAKE CENTER
42 % OF THE FISCAL YEAR HAS ELAPSED
5
Page 23 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
FINES 10-351-100 ORDINANCE/TRAFFIC FINES TOTAL FINES
.00
.00
500.00
500.00
.0
.00
.00
500.00
500.00
.0
246.28
2,493.36
4,000.00
1,506.64
62.3
.00
.00
.00
.00
.0
1,275.00
3,245.00
3,000.00
245.00)
108.2
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
.00
.00
2.00
2.00
.0
10-360-180 RENT - VISITORS CENTER
.00
625.00
2,500.00
1,875.00
25.0
10-360-190 GIFTS - DONATIONS
.00
.00
1,200.00
520.56
14,824.53
5,000.00
10-360-210 5% BUSINESS LICENSE FEE
.00
.00
10-360-220 5% NIGHTLY RENTAL LICENSE
.00
.00
630.00
2,060.00
.00
10-360-200 MISC. REVENUES - GENERAL
10-360-230 MEMORIAL BENCHES
1,200.00
.0
9,824.53)
296.5
.00
.00
.0
.00
.00
.0
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
2,671.84
23,247.89
32,689.00
9,441.11
71.1
.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
10-377-156 EV CHARGING STATION
.00
.00
8,260.00
8,260.00
.0
10-377-157 DOLA TIER 1 - W. PORTAL BRIDGE
.00
.00
73,520.00
73,520.00
.0
.00
.00
921,860.00
921,860.00
.0
113,348.38
435,650.36
2,641,747.00
2,206,096.64
16.5
TOTAL CAPITAL SPECIFIC REVENUE
TOTAL FUND REVENUE
42 % OF THE FISCAL YEAR HAS ELAPSED
6
Page 24 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
CEMETERY COMMITTEE 10-410-211 GENERAL SUPPLIES/MISC EXPENSES
.00
.00
3,500.00
3,500.00
10-410-215 GRAVE MARKERS
.00
.00
2,600.00
2,600.00
.0
10-410-242 GENERAL MAINTENANCE
.00
.00
3,000.00
3,000.00
.0
.00
.00
9,100.00
9,100.00
.0
TOTAL CEMETERY COMMITTEE
.0
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
38.00
64.00
400.00
336.00
16.0
.00
.00
.00
.00
.0
38.00
64.00
3,300.00
3,236.00
1.9
TOTAL P.O.S.T. COMMITTEE
PC/BOA
10-412-370 TRAINING/TRAVEL 10-412-380 COMP PLAN UPDATE TOTAL PC/BOA
42 % OF THE FISCAL YEAR HAS ELAPSED
7
Page 25 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
184.67
1,433.38
5,600.00
4,166.62
25.6
.00
3,000.00
3,000.00
.00
100.0 44.8
10-413-370 TRAINING/TRAVEL 10-413-452 HEADWATER TRAILS ALLIANCE 10-413-460 LONG RANGE/MISC
309.21
313.59
700.00
386.41
10-413-461 APPRECIATION PROGRAM
263.50
313.77
3,500.00
3,186.23
9.0
10-413-462 COMPUTER EQUIPMENT
2,992.93
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-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 10-413-731 GRND CNTY COUNCIL ON AGING 10-413-782 ADVOCATES
.00
.00
3,500.00
3,500.00
.0
700.00
1,200.00
2,500.00
1,300.00
48.0
3,500.00
3,500.00
3,500.00
.00
100.0
.00
1,500.00
1,500.00
.00
100.0
10-413-793 GL FIREWORKS
.00
.00
11,000.00
11,000.00
.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
4,000.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
11,950.31
26,995.08
148,353.00
121,357.92
18.2
10-414-211 GENERAL SUPPLIES
40.03
279.06
1,500.00
1,220.94
18.6
10-414-238 TREES/SHRUBS/PLANTINGS
16.99
16.99
5,000.00
4,983.01
.3
10-414-241 ARBOR DAY SUPPLIES
33.60
169.60
500.00
330.40
33.9
TOTAL BOARD OF TRUSTEES
GREENWAYS COMMITTEE
10-414-245 GRND GARDENS 10-414-319 CONTRACT LABOR
.00
.00
500.00
500.00
.0
5,541.17
5,541.17
33,247.00
27,705.83
16.7
10-414-726 MISCELLANEOUS SERVICES
.00
.00
200.00
200.00
.0
10-414-870 CONTINGENCY
.00
.00
250.00
250.00
.0
5,631.79
6,006.82
41,197.00
35,190.18
14.6
TOTAL GREENWAYS COMMITTEE
42 % OF THE FISCAL YEAR HAS ELAPSED
8
Page 26 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
ADMINISTRATION 10-415-100 GROSS WAGES - ADMINISTRATION
16,185.74
85,928.66
199,070.00
113,141.34
765.00
765.00
1,138.00
373.00
67.2
10-415-132 ICMA TOWN PAID BENEFIT
1,111.58
5,297.06
15,526.00
10,228.94
34.1
10-415-133 HEALTH/DENTAL-EMPLOYEE
41.8
10-415-131 LONGEVITY BENEFIT
43.2
3,119.08
15,595.71
37,352.00
21,756.29
10-415-135 DEP HEALTH/DENTAL
41.60
199.57
20,209.00
20,009.43
1.0
10-415-136 MEDICAL BENEFIT ALLOWANCE
51.15
942.71
3,741.00
2,798.29
25.2
10-415-141 UNEMPLOYMENT INSURANCE
19.00
168.21
646.00
477.79
26.0
.00
251.22
538.00
286.78
46.7 40.1
10-415-142 WORKER'S COMPENSATION 10-415-143 SOCIAL SECURITY MATCH
1,061.28
5,363.04
13,363.00
7,999.96
10-415-144 MEDICARE MATCH
248.18
1,254.17
3,126.00
1,871.83
40.1
10-415-211 GENERAL OFFICE SUPPLIES
691.55
1,666.21
3,500.00
1,833.79
47.6
10-415-215 COMPUTER SOFTWARE
44.97
104.94
5,000.00
4,895.06
2.1
10-415-220 COMPUTER HARDWARE
.00
.00
6,000.00
6,000.00
.0
10-415-224 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
10-415-226 SMALL EQUIPMENT
165.83
829.15
2,000.00
1,170.85
41.5
10-415-231 GAS/FUEL
113.21
652.45
2,400.00
1,747.55
27.2
.00
27.19
400.00
372.81
6.8
10-415-233 OFFICE EQUIPMENT MAINTENANCE
109.95
594.12
1,600.00
1,005.88
37.1
10-415-237 BUILDING MAINTENANCE
10-415-232 VEHICLE MAINTENANCE
245.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
521.20
1,674.87
4,000.00
2,325.13
41.9
10-415-312 COMPUTER SERVICES
2,137.50
7,007.50
14,230.00
7,222.50
49.2
10-415-314 ADS & LEGAL NOTICES
24.84
865.33
1,000.00
134.67
86.5
10-415-316 DUES & MEMBERSHIPS
.00
1,070.28
1,500.00
429.72
71.4
10-415-317 BANK FEES
.00
55.00
100.00
45.00
55.0
350.00
1,540.00
3,700.00
2,160.00
41.6
.00
75.00
250.00
175.00
30.0
10-415-311 POSTAGE/FREIGHT
10-415-318 JANITORIAL SERVICES 10-415-319 MISCELLANEOUS SERVICES
276.09
1,927.55
4,200.00
2,272.45
45.9
10-415-342 SEWER UTILITY
10-415-341 ELECTRIC UTILITY
.00
483.60
1,000.00
516.40
48.4
10-415-343 WATER UTILITY
310.00
602.50
1,500.00
897.50
40.2
10-415-344 TELEPHONE UTILITY
325.36
1,659.55
4,500.00
2,840.45
36.9
10-415-345 NATURAL GAS UTILITY
149.97
1,303.92
3,000.00
1,696.08
43.5
.00
87.45
600.00
512.55
14.6
10-415-346 INTERNET SERVICES 10-415-347 RECYCLING - TOWN HALL
38.81
192.17
454.00
261.83
42.3
1,616.56
7,588.10
30,500.00
22,911.90
24.9
10-415-352 AUDIT
.00
8,820.00
8,820.00
.00
100.0
10-415-353 JUDGE-MUNICIPAL COURT
.00
450.00
1,800.00
1,350.00
25.0
1,008.00
1,855.00
11,550.00
9,695.00
16.1
180.00
1,682.03
6,000.00
4,317.97
28.0
.00
.00
500.00
500.00
.0
335.15
384.75
1,000.00
615.25
38.5
10-415-351 LEGAL SERVICES
10-415-355 PROFESSIONAL SERVICES-OTHER 10-415-370 TRAINING/TRAVEL 10-415-393 DOCUMENT RECORDING 10-415-394 DEVELOPER REIMBURSEMENT 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
10-415-540 GRANTS TO NEIGHBORHOODS
.00
.00
8,000.00
8,000.00
.0
1,073.78
3,110.29
4,855.00
1,744.71
64.1
10-415-560 TREASURER'S FEES 10-415-721 CHAMBER SERVICE AGREEMENT
.00
8,183.00
32,732.00
24,549.00
25.0
10-415-722 BLC FEE REMITTANCE
.00
7,000.00
28,000.00
21,000.00
25.0
10-415-723 VISITOR CENTER REPAIRS & MAINT
.00
.00
10,500.00
10,500.00
.0
10-415-724 NRL VC OP
.00
7,500.00
30,000.00
22,500.00
25.0
10-415-725 95% NRL ADDTL MKTG
.00
.00
.00
.00
.0
42 % OF THE FISCAL YEAR HAS ELAPSED
9
Page 27 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
10-415-870 CONTINGENCY - GENERAL ADMIN
.00
.00
1,000.00
1,000.00
.0
10-415-875 MARKETING CONTINGENCY
.00
.00
1,500.00
1,500.00
.0
32,320.38
195,096.18
553,818.00
358,721.82
35.2
2,569.13
12,730.95
31,164.00
18,433.05
40.9
.00
.00
60.00
60.00
.0
10-421-132 ICMA TOWN PAID BENEFIT
205.53
1,018.46
2,493.00
1,474.54
40.9
10-421-133 HEALTH/DENTAL-EMPLOYEE
TOTAL ADMINISTRATION
SAFETY 10-421-100 GROSS WAGES - PUBLIC SAFETY 10-421-131 LONGEVITY BENEFIT
850.62
4,253.10
10,207.00
5,953.90
41.7
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
10-421-141 UNEMPLOYMENT INSURANCE
.00
24.61
101.00
76.39
24.4
.00
209.26
448.00
238.74
46.7
172.03
877.28
2,086.00
1,208.72
42.1
10-421-142 WORKER'S COMPENSATION 10-421-143 SOCIAL SECURITY MATCH 10-421-144 MEDICARE MATCH
40.23
205.15
488.00
282.85
42.0
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
50,750.00
121,800.00
71,050.00
41.7
.00
.00
5,000.00
5,000.00
.0
13,987.54
78,399.31
193,840.00
115,440.69
40.5
10-421-339 SHERIFF'S CONTRACT 10-421-340 SPECIAL EVENT SECURITY TOTAL SAFETY
42 % OF THE FISCAL YEAR HAS ELAPSED
10
Page 28 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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 10-431-135 DEP HEALTH/DENTAL 10-431-136 MEDICAL BENEFIT ALLOWANCE
14,218.92
73,801.58
215,661.00
141,859.42
.00
2,160.00
3,300.00
1,140.00
34.2 65.5
764.30
3,746.50
17,081.00
13,334.50
21.9
2,976.05
14,029.63
45,933.00
31,903.37
30.5
406.68
2,033.40
29,714.00
27,680.60
6.8
54.30
1,011.98
4,725.00
3,713.02
21.4 20.4
10-431-141 UNEMPLOYMENT INSURANCE
.00
142.86
700.00
557.14
10-431-142 WORKER'S COMPENSATION
.00
3,437.46
7,356.00
3,918.54
46.7
10-431-143 SOCIAL SECURITY MATCH
926.13
4,898.92
14,428.00
9,529.08
34.0
10-431-144 MEDICARE MATCH
216.62
1,145.85
3,373.00
2,227.15
34.0
90.16
1,221.71
3,500.00
2,278.29
34.9
259.90
259.90
1,500.00
1,240.10
17.3
4.29
127.26
1,500.00
1,372.74
8.5
695.07
5,637.52
20,000.00
14,362.48
28.2
10-431-222 GENERAL SUPPLIES 10-431-224 SAFETY SUPPLIES 10-431-227 SMALL TOOLS 10-431-231 GAS/FUEL/LIQUIDS 10-431-232 VEHICLE MAINTENANCE
.00
210.56
12,000.00
11,789.44
1.8
795.52
4,696.25
25,000.00
20,303.75
18.8
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-233 EQUIPMENT MAINTENANCE
10-431-237 BUILDING MAINTENANCE 10-431-238 STREET LIGHT MAINTENANCE 10-431-239 MISCELLANEOUS MAINTENANCE 10-431-242 ROAD MAINTENANCE
.00
784.58
1,500.00
715.42
52.3
75.00
790.04
3,000.00
2,209.96
26.3
.00
.00
250.00
250.00
.0
2,799.43
4,158.32
75,000.00
70,841.68
5.5
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 10-431-314 ADS/BID NOTICES 10-431-317 UNIFORM ALLOWANCE
.00
.00
.00
575.00
1,340.70
500.00
(
.00
.0
840.70)
268.1
.00
587.83
2,250.00
1,662.17
26.1
371.53
1,046.26
6,000.00
4,953.74
17.4
.00
225.00
600.00
375.00
37.5
10-431-341 ELECTRIC UTILITY
551.50
2,691.73
4,200.00
1,508.27
64.1
10-431-343 WATER UTILITY
124.00
241.00
500.00
259.00
48.2
10-431-344 TELEPHONE UTILITY
218.76
1,244.87
1,950.00
705.13
63.8
10-431-345 NATURAL GAS UTILITY
219.05
2,018.18
5,000.00
2,981.82
40.4
1,788.03
9,370.01
24,800.00
15,429.99
37.8
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
10-431-370 TRAINING/TRAVEL
.00
37.08
1,000.00
962.92
3.7
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
28,130.24
143,096.98
577,321.00
434,224.02
24.8
10-431-318 TRASH/RECYCLE SERVICES 10-431-319 MISC. PURCHASED SERVICES
10-431-349 STREET LIGHT ELECTRIC UTILITY
TOTAL PUBLIC WORKS
42 % OF THE FISCAL YEAR HAS ELAPSED
11
Page 29 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
GRAND LAKE CENTER 10-450-211 GENERAL SUPPLIES
.00
193.85
.00
(
193.85)
.0
10-450-237 BUILDING MAINTENANCE
.00
160.00
.00
(
160.00)
.0
609.10
3,010.91
.00
(
3,010.91)
.0
.00
1,106.70
.00
(
1,106.70)
.0
10-450-341 ELECTRIC UTILITY 10-450-342 SEWER UTILITY 10-450-343 WATER UTILITY
248.00
482.00
.00
(
482.00)
.0
10-450-344 TELEPHONE UTILITY
251.61
471.49
.00
(
471.49)
.0
10-450-345 NATURAL GAS UTILITY
(
2,395.02)
.0
.00
.0 .0
258.66
2,395.02
.00
10-450-355 PURCHASED PROFESSIONAL SERV.
.00
.00
.00
10-450-513 PROPERTY/CASUALTY INSURANCE
.00
2,143.50
.00
(
2,143.50)
10-450-721 DONATIONS - OUT
.00
1,200.00
.00
(
1,200.00)
.0
2,684.00
2,719.56
.00
(
2,719.56)
.0
4,051.37
13,883.03
.00
(
13,883.03)
.0
10-450-870 CONTINGENCY - GL CENTER TOTAL GRAND LAKE CENTER
42 % OF THE FISCAL YEAR HAS ELAPSED
12
Page 30 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS 10-452-100 GROSS WAGES - PARKS
1,913.58
9,567.90
23,392.00
13,824.10
40.9
303.75
303.75
8,460.00
8,156.25
3.6
.00
.00
600.00
600.00
.0
76.54
382.70
1,827.00
1,444.30
21.0
10-452-133 HEALTH/DENTAL-EMPLOYEE
425.31
2,126.55
5,104.00
2,977.45
41.7
10-452-135 DEP. HEALTH/DENTAL
406.67
2,033.35
4,880.00
2,846.65
41.7
54.29
54.29
525.00
470.71
10.3
.00
19.34
101.00
81.66
19.2
.00
437.20
936.00
498.80
46.7
152.54
696.37
2,088.00
1,391.63
33.4
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
35.67
162.85
489.00
326.15
33.3
1,925.38
2,990.95
14,000.00
11,009.05
21.4
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
364.15
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-220 OPERATING SUPPLIES
10-452-233 EQUIPMENT MAINTENANCE
10-452-236 SAND & DREDGE 10-452-237 BUILDING MAINTENANCE
.00
.00
500.00
500.00
.0
52.00
188.86
6,300.00
6,111.14
3.0
1,000.00
.0
10-452-238 ADA DOCK MAINTENANCE
.00
.00
1,000.00
10-452-239 MISCELLANEOUS MAINTENANCE
.00
4,498.88
250.00
10-452-243 BENCHES/PLANTERS/FENCES
.00
.00
1,000.00
1,000.00
10-452-244 THOMASSON PARK MAINTENANCE
.00
.00
500.00
500.00
.0
10-452-246 ICE RINK/VOLLEYBALL COURT
.00
.00
1,500.00
1,500.00
.0
17.26
17.26
2,000.00
1,982.74
.9
.00
.00
.00
.00
.0 45.7
10-452-248 IRRIGATION SYSTEM MAINTENANCE 10-452-319 MISCELLANEOUS SERVICES 10-452-341 ELECTRIC UTILITY
(
4,248.88) 1799.6 .0
505.50
3,063.06
6,700.00
3,636.94
10-452-342 SEWER UTILITY
.00
213.90
450.00
236.10
47.5
10-452-343 WATER UTILITY
1,426.00
2,887.50
9,500.00
6,612.50
30.4 40.4
10-452-345 NATURAL GAS UTILITY
198.08
1,414.63
3,500.00
2,085.37
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
7,856.72
31,828.74
119,102.00
87,273.26
26.7
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
.00
1,418.33
12,002.00
10,583.67
11.8
10-815-983 LAND ACQUISITION-INTEREST
.00
5,050.41
13,873.00
8,822.59
36.4
.00
7,793.69
113,961.00
106,167.31
6.8
TOTAL ADMIN DEBT SERVICE
42 % OF THE FISCAL YEAR HAS ELAPSED
13
Page 31 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS DEBT SERVICE 10-831-500 CAPITAL EQUIP LEASE PRINCIPAL
963.06
4,787.47
11,608.00
6,820.53
41.2
10-831-510 EQUIPMENT LEASE INTEREST
374.09
1,898.28
4,438.00
2,539.72
42.8
1,337.15
6,685.75
16,046.00
9,360.25
41.7
.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
16,987.00
.0
6,723.60
6,723.60
11,500.00
4,776.40
58.5 .0
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 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,723.60
6,723.60
985,087.00
978,363.40
.7
.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
42 % OF THE FISCAL YEAR HAS ELAPSED
14
Page 32 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS CAPITAL 10-952-500 ADA DOCKS
.00
3,811.64
80,000.00
76,188.36
4.8
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
.00
3,811.64
112,000.00
108,188.36
3.4
112,027.10
520,384.82
2,873,125.00
2,352,740.18
18.1
TOTAL PARKS CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
1,321.28
(
84,734.46) (
231,378.00)
(
146,643.54)
( 36.6)
42 % OF THE FISCAL YEAR HAS ELAPSED
15
Page 33 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 WATER FUND ASSETS 20-100000 CASH IN COMBINED CASH FUND
649,519.61
20-102000 CSAFE
62,093.79
20-109100 COLOTRUST
302,989.20
20-116000 PETTY CASH
.00
20-117000 ACCTS RECEIVABLE/WATER SALES
11,959.22
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,210,951.13) 26,934.62
20-135000 DUE FROM GENERAL FUND
.00
20-136000 DUE FROM MARINA FUND
.00
TOTAL ASSETS
2,259,578.90
LIABILITIES AND EQUITY
LIABILITIES 20-200000 ACCOUNTS PAYABLE GENERAL
5,832.16
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 20-218100 HEALTH/DENTAL/VISION
.00 (
20-219100 FLEX MEDICAL
14.06) 120.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
42,321.60
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
42 % OF THE FISCAL YEAR HAS ELAPSED
16
Page 34 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 WATER FUND
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
51,447.65
BALANCE - CURRENT DATE
51,447.65
TOTAL FUND EQUITY
2,217,257.30
TOTAL LIABILITIES AND EQUITY
2,259,578.90
42 % OF THE FISCAL YEAR HAS ELAPSED
17
Page 35 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
WATER REVENUES 20-344-100 WATER SALES 20-344-110 TAP FEES - CAPITAL
336.14
251,411.46
494,774.00
243,362.54
50.8
.00
9,966.68
16,467.00
6,500.32
60.5
20-344-120 RESALE METERS
449.19
898.38
1,000.00
101.62
89.8
20-344-140 INTEREST REVENUE
252.81
1,264.20
1,000.00
(
264.20)
126.4
20-344-160 MISC. REVENUES
156.84
190.84
.00
(
190.84)
50.00
150.00
700.00
550.00
21.4
.00
.00
270,000.00
270,000.00
.0
TOTAL WATER REVENUES
1,244.98
263,881.56
783,941.00
520,059.44
33.7
TOTAL FUND REVENUE
1,244.98
263,881.56
783,941.00
520,059.44
33.7
20-344-190 BULK WATER PERMITS 20-344-910 HYDRO PROJECT FUNDING
42 % OF THE FISCAL YEAR HAS ELAPSED
.0
18
Page 36 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
14,634.92
73,174.62
189,069.00
115,894.38
.00
.00
.00
.00
38.7 .0
1,750.00
7,700.00
18,200.00
10,500.00
42.3
.00
.00
15,000.00
15,000.00
.0
204.00
204.00
2,450.00
2,246.00
8.3
20-430-132 ICMA DEFERRED COMPENSATION
1,096.76
5,418.56
14,086.00
8,667.44
38.5
20-430-133 HEALTH/DENTAL-EMPLOYEE
2,634.00
13,169.69
31,587.00
18,417.31
41.7
20-430-135 DEP HEALTH/DENTAL
11.17
53.60
26,526.00
26,472.40
.2
20-430-136 MEDICAL BENEFIT ALLOWANCE
13.64
487.31
3,174.00
2,686.69
15.4 22.4
20-430-141 UNEMPLOYMENT INSURANCE
.00
149.21
666.00
516.79
20-430-142 WORKER'S COMPENSATION
.00
1,986.64
4,251.00
2,264.36
46.7
1,081.94
5,419.90
13,740.00
8,320.10
39.5
20-430-144 MEDICARE MATCH
253.05
1,267.61
3,214.00
1,946.39
39.4
20-430-210 OFFICE SUPPLIES
.00
709.98
1,500.00
790.02
47.3
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
20-430-220 COMPUTER HARDWARE 20-430-221 CHEMICALS 20-430-222 LAB SUPPLIES/EQUIPMENT 20-430-223 WELL/PLANT SUPPLIES
.00
.00
15,000.00
15,000.00
.0
80.00
2,948.77
12,000.00
9,051.23
24.6
189.40
189.40
1,000.00
810.60
18.9
.00
566.80
750.00
183.20
75.6
20-430-225 METER PARTS
.00
.00
1,000.00
1,000.00
.0
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
235.26
905.96
5,000.00
4,094.04
18.1
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
331.95
358.02
1,000.00
641.98
35.8 9.7
20-430-237 BUILDING MAINTENANCE 20-430-238 DISTRIBUTION LINE MAINTENANCE
1,302.52
1,357.87
14,000.00
12,642.13
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
20-430-251 RESALE PARTS
.00
.00
500.00
500.00
.0
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-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
.00
275.00
700.00
425.00
39.3
20-430-317 UNIFORM ALLOWANCE
.00
.00
900.00
900.00
.0
20-430-318 TESTING SERVICES
.00
60.00
4,800.00
4,740.00
1.3
20-430-319 MISCELLANEOUS SERVICES
.00
.00
350.00
350.00
.0
20-430-320 TELEMETRY MAINTENANCE
.00
.00
2,500.00
2,500.00
.0
20-430-321 COMPUTER SYSTEM SUPPORT 20-430-341 ELECTRIC UTILITY
725.00
2,595.00
7,690.00
5,095.00
33.8
2,213.67
12,658.31
29,500.00
16,841.69
42.9 39.9
20-430-344 TELEPHONE UTILITY
166.86
997.71
2,500.00
1,502.29
20-430-345 NATURAL GAS UTILITY
180.04
2,039.94
5,000.00
2,960.06
40.8
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
42 % OF THE FISCAL YEAR HAS ELAPSED
19
Page 37 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
65.00
243.10
2,000.00
1,756.90
12.2
.00
4,069.74
8,139.00
4,069.26
50.0
.00
100.0
.00
200.00
200.00
8,201.87
41,009.35
.00
20-430-870 CONTINGENCY-OPERATIONS
.00
.00
TOTAL WATER OPERATIONS
35,371.05
20-830-640 DWRF LOAN - PRINCIPAL 20-830-645 DWRF LOAN - INTEREST
20-430-700 DEPRECIATION RESERVE
100.0
(
41,009.35)
.0
1,000.00
1,000.00
.0
184,694.79
520,692.00
335,997.21
35.5
.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
1,897.07
27,739.12
285,000.00
257,260.88
9.7
1,897.07
27,739.12
290,000.00
262,260.88
9.6
37,268.12
212,433.91
826,692.00
614,258.09
25.7
TOTAL WATER CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
(
36,023.14)
51,447.65
(
42,751.00)
(
94,198.65)
42 % OF THE FISCAL YEAR HAS ELAPSED
120.3
20
Page 38 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 MARINA FUND ASSETS 40-100000 CASH IN COMBINED CASH FUND
246,293.91
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
(
117,645.01)
TOTAL ASSETS
342,669.93
LIABILITIES AND EQUITY
LIABILITIES 40-200000 ACCOUNTS PAYABLE GENERAL
1,048.16
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
.07
40-219100 FLEX MEDICAL
30.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
1,463.56
FUND EQUITY 40-275000 UNAPPROP. RETAINED EARNINGS
358,948.50
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
17,742.13) (
17,742.13)
TOTAL FUND EQUITY
341,206.37
TOTAL LIABILITIES AND EQUITY
342,669.93
42 % OF THE FISCAL YEAR HAS ELAPSED
21
Page 39 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
MARINA REVENUES 40-344-110 BOAT RENTALS
2,310.00
2,310.00
.00
40-344-113 RENTALS (NON-TAXABLE)
4,263.00
4,263.00
135,000.00
(
130,737.00
2,310.00)
3.2
.0
40-344-115 TOURS
3.8
2,300.00
2,300.00
60,000.00
57,700.00
40-344-120 BUILDING SPACE RENTAL
.00
.00
3,300.00
3,300.00
.0
40-344-140 SEASONAL SLIP RENTALS
5,500.00
12,250.00
12,250.00
.00
100.0
40-344-145 KAYAK SLIP RENTAL
1,500.00
1,950.00
2,700.00
750.00
72.2
.00
.00
200.00
200.00
922.00
922.00
600.00
40-344-150 DAILY SLIP RENTAL 40-344-160 MISC REVENUE 40-344-170 INTEREST EARNED
(
.0
322.00)
153.7 48.7
30.19
194.76
400.00
205.24
40-344-180 BOAT DAMAGE
.00
.00
300.00
300.00
.0
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
16,825.19
24,189.76
230,570.00
206,380.24
10.5
TOTAL FUND REVENUE
16,825.19
24,189.76
230,570.00
206,380.24
10.5
42 % OF THE FISCAL YEAR HAS ELAPSED
22
Page 40 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA OPERATIONS 40-460-100 GROSS WAGES - MARINA 40-460-110 GROSS WAGES - MARINA SEASONAL 40-460-119 ACCRUED LEAVE EXPENSE 40-460-131 LONGEVITY 40-460-132 ICMA DEFERRED COMPENSATION
843.44
4,217.22
10,090.00
5,872.78
41.8
9,986.66
14,493.32
85,000.00
70,506.68
17.1
.00
.00
1,000.00
1,000.00
.0
51.00
51.00
72.00
21.00
70.8
53.30
266.54
807.00
540.46
33.0
164.05
820.25
1,964.00
1,143.75
41.8
40-460-135 DEP HEALTH/DENTAL
2.79
13.39
1,301.00
1,287.61
1.0
40-460-136 MEDICAL BENEFIT ALLOWANCE
3.41
62.46
185.00
122.54
33.8
40-460-133 HEALTH/DENTAL - EMPLOYEE
40-460-141 UNEMPLOYMENT INSURANCE
.00
7.85
288.00
280.15
2.7
40-460-142 WORKERS COMPENSATION
.00
2,100.72
4,496.00
2,395.28
46.7
40-460-143 SOCIAL SECURITY MATCH
674.43
1,180.13
5,950.00
4,769.87
19.8
40-460-144 MEDICARE MATCH
157.71
275.88
1,392.00
1,116.12
19.8
40-460-211 GENERAL OFFICE SUPPLIES
.00
49.99
1,000.00
950.01
5.0
40-460-214 SMALL EQUIP/COMP HRDWARE
.00
.00
450.00
450.00
.0
40-460-220 COMPUTER HARDWARE
.00
.00
.00
.00
.0
101.13
101.13
2,000.00
1,898.87
5.1
40-460-222 SHOP SUPPLIES 40-460-223 BOAT SUPPLIES
.00
.00
2,000.00
2,000.00
.0
40-460-227 TOOLS
.00
.00
500.00
500.00
.0
19.14
44.02
5,000.00
4,955.98
.9
.00
.00
500.00
500.00
.0
589.84
589.84
4,000.00
3,410.16
14.8
40-460-231 FUEL 40-460-232 VEHICLE MAINTENANCE 40-460-233 EQUIPMENT MAINTENANCE 40-460-237 BUILDING/FACILITY MAINTENANCE
144.17
144.17
10,000.00
9,855.83
1.4
40-460-312 COMPUTER SERVICES
225.32
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
792.00
1,179.75
1,000.00
179.75)
118.0
40-460-318 MISCELLANEOUS SERVICES
144.00
144.00
500.00
356.00
28.8
.00
515.83
1,000.00
484.17
51.6
159.93
159.93
4,000.00
3,840.07
4.0
31.73
158.21
600.00
441.79
26.4
40-460-320 MARKETING 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
124.00
241.00
500.00
259.00
48.2
97.19
637.56
1,100.00
462.44
58.0
.00
347.25
600.00
252.75
57.9
40-460-344 TELEPHONE UTILITY 40-460-350 BOAT REGISTRATION 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
11,932.50
.00
.00
.00
16,751.74
41,931.89
40-460-700 DEPRECIATION RESERVE 40-460-870 CONTINGENCY TOTAL MARINA OPERATIONS
(
11,932.50)
.0
1,000.00
1,000.00
.0
155,958.00
114,026.11
26.9
42 % OF THE FISCAL YEAR HAS ELAPSED
23
Page 41 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
16,751.74
41,931.89
215,958.00
174,026.11
19.4
17,742.13)
14,612.00
32,354.13
(121.4)
TOTAL MARINA CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
73.45
(
42 % OF THE FISCAL YEAR HAS ELAPSED
24
Page 42 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 PAY-AS-YOU-THROW FUND ASSETS 50-100000 CASH IN COMBINED CASH FUND
65,027.82
50-116000 PETTY CASH
50.00
50-117000 ACCOUNTS RECEIVABLE
.00
50-127000 ASSET - BAG INVENTORY
2,890.46
TOTAL ASSETS
67,968.28
LIABILITIES AND EQUITY
LIABILITIES 50-200000 ACCOUNTS PAYABLE GENERAL
1,416.95
50-231000 DUE TO G.F. FROM PAYT
.00
TOTAL LIABILITIES
1,416.95
FUND EQUITY 50-275000 UNAPPROP. RETAINED EARNINGS
63,085.92
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
3,465.41
BALANCE - CURRENT DATE
3,465.41
TOTAL FUND EQUITY
66,551.33
TOTAL LIABILITIES AND EQUITY
67,968.28
42 % OF THE FISCAL YEAR HAS ELAPSED
25
Page 43 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
PAYT REVENUES 50-344-110 BAGS: DIRECT SALES (T)
125.00
253.00
1,060.00
807.00
2,624.00
8,349.00
45,400.00
37,051.00
18.4
7.70
47.55
100.00
52.45
47.6
TOTAL PAYT REVENUES
2,756.70
8,649.55
46,560.00
37,910.45
18.6
TOTAL FUND REVENUE
2,756.70
8,649.55
46,560.00
37,910.45
18.6
50-344-115 BAGS: VENDOR PURCHASE (NT) 50-344-140 INTEREST REVENUE
42 % OF THE FISCAL YEAR HAS ELAPSED
23.9
26
Page 44 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
1,275.86
2,057.31
20,000.00
17,942.69
10.3
125.00
625.00
1,500.00
875.00
41.7
.00
.00
1.00
1.00
.0
32.18
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
1,433.04
5,184.14
38,600.00
33,415.86
13.4
TOTAL FUND EXPENDITURES
1,433.04
5,184.14
38,600.00
33,415.86
13.4
NET REVENUE OVER EXPENDITURES
1,323.66
3,465.41
7,960.00
4,494.59
43.5
50-470-300 DUMPSTER SERVICE 50-470-301 RECYCLING CONTRIBUTION 50-470-310 SITE LEASE 50-470-312 COMPUTER SERVICES
42 % OF THE FISCAL YEAR HAS ELAPSED
23.7
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
$9,790.74 $1,505,843.37 $1,460.27 $1,517,094.38
Developer LOC Checking*
$556,253.04
Water Fund
$649,519.61
Marina Fund
PAYT
$246,293.91
$65,027.82
$16,427.47 *Letter of Credit Funds - Restricted Use Non-Interest Bearing Holding Account
CSAFE General Fund Water Fund ColoTrust
General Fund
May 31, 2016
$185,590.77 $62,093.79 $605,547.43
Gill & Associates Advantage Bank CD
FlatIrons Bank CD $96,000 Principal Interest paid monthly
$302,558.23
$302,989.20
$99,832.00 $100,140.65
$96,000.00
TOTAL
$1,356,802.16
TOTAL CASH/INVESTMENTS AT:
5/31/2016
$1,014,602.60
$246,293.91
$65,027.82
$2,682,726.49
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 MAY 31, 2016 COMBINED CASH ACCOUNTS 01-101000 GMB CHECKING - OPERATIONS
9,790.74
01-105000 GMB MONEY MARKET
1,505,843.37
01-106000 RETURNED CHECK CLEARING ACCT
.00
01-107500 UTILITY CASH CLEARING ACCT
1,460.27
TOTAL COMBINED CASH
1,517,094.38
01-100000 CASH ALLOCATED TO OTHER FUNDS
(
1,517,094.38)
TOTAL UNALLOCATED CASH
.00
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
556,253.04
20 ALLOCATION TO WATER FUND
649,519.61
40 ALLOCATION TO MARINA FUND
246,293.91
50 ALLOCATION TO PAY-AS-YOU-THROW FUND
65,027.82
TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 01-100000
1,517,094.38 (
1,517,094.38)
ZERO PROOF IF ALLOCATIONS BALANCE
.00
42 % OF THE FISCAL YEAR HAS ELAPSED
1
Page 19 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 GENERAL FUND ASSETS 10-100000 CASH IN COMBINED CASH FUND
556,253.04
10-103000 CSAFE
185,590.77
10-106000 ADVANTAGE BANK - CD
100,140.65
10-109100 COLOTRUST
302,558.23
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
.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
451.67
10-129000 UNLEADED GAS INVENTORY
635.26
10-130000 DIESEL INVENTORY
1,082.14
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
99,832.00
TOTAL ASSETS
1,600,778.23
LIABILITIES AND EQUITY
LIABILITIES 10-200000 ACCOUNTS PAYABLE GENERAL
41,432.58
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
11.62) 1,512.50
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
57,767.77
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
371,315.48
42 % OF THE FISCAL YEAR HAS ELAPSED
2
Page 20 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 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
(
84,734.46) (
84,734.46)
TOTAL FUND EQUITY
1,229,462.75
TOTAL LIABILITIES AND EQUITY
1,600,778.23
42 % OF THE FISCAL YEAR HAS ELAPSED
3
Page 21 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
53,688.86
155,512.14
241,557.00
86,044.86
64.4
1,242.26
4,734.34
14,000.00
9,265.66
33.8
500.00
565.38
2,216.48
.00
(
11,854.99
65.38)
20,000.00
8,145.01
( 13.1) 59.3
39,568.22
134,292.16
1,164,718.00
1,030,425.84
11.5
.00
.00
30,000.00
30,000.00
.0
239.15
1,053.81
3,000.00
1,946.19
35.1
96,954.97
307,382.06
1,473,775.00
1,166,392.94
20.9
UTILITY FRANCHISES 10-316-170 CABLE FRANCHISE FEES
.00
.00
16,000.00
16,000.00
.0
10-316-171 TELEPHONE FRANCHISE
.00
1,005.00
4,224.00
3,219.00
23.8
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
1,215.70
4,459.32
14,000.00
9,540.68
31.9
1,215.70
14,838.20
64,224.00
49,385.80
23.1
LICENSES & PERMITS 650.00
4,261.25
2,000.00
2,261.25)
213.1
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
10.00
30.00
400.00
370.00
7.5
10-321-130 MOTOR VEHICLE LICENSE
154.00
549.50
2,000.00
1,450.50
27.5
10-321-140 SIGN PERMIT
40.00
50.00
350.00
300.00
14.3
10-321-150 GRADING PERMIT
35.00
35.00
50.00
10-321-160 ANIMAL LICENSE
15.00
130.00
100.00
10-321-170 ENCROACHMENT PERMIT/LICENSE 10-321-175 BUSINESS LICENSE COMMISSION 10-321-180 NIGHTLY RENTAL LICENSE TOTAL LICENSES & PERMITS
(
15.00
70.0
30.00)
130.0
20.00
20.00
300.00
280.00
574.50
1,129.50
29,000.00
27,870.50
3.9
.00
30,000.00
30,000.00
.00
100.0
1,498.50
36,205.25
64,200.00
27,994.75
56.4
42 % OF THE FISCAL YEAR HAS ELAPSED
6.7
4
Page 22 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
10-335-200 HIGHWAY USER TAX FUND
2,703.34
10,101.58
30,063.00
19,961.42
33.6
10-335-800 CONSERVATION TRUST FUND
.00
546.57
2,000.00
1,453.43
27.3
10-335-900 OTHER INTERGOVERNMENTAL
.00
.00
4,000.00
4,000.00
.0
2,703.34
13,816.15
42,399.00
28,582.85
32.6
TOTAL INTERGOVERNMENTAL REVENUES
CHARGES FOR SERVICES 10-341-100 COURT FEES 10-341-200 CEMETERY
.00
.00
50.00
50.00
.0
1,900.00
3,650.00
5,000.00
1,350.00
73.0
10-341-201 HEADSTONE DEPOSIT
800.00
1,200.00
1,600.00
400.00
75.0
10-341-300 ZONING & SUBDIVISION REVIEW
135.00
3,824.00
4,000.00
176.00
95.6
10-341-400 ATTAINABLE HOUSING FEE
109.00
19,049.50
20,000.00
950.50
95.3
71.28
308.56
1,100.00
791.44
28.1
10-341-600 FUEL DEPOT SURCHARGE 10-341-700 COPIES/FAXES/SODA 10-341-850 NIGHTLY RENTAL APPLICATION FEE TOTAL CHARGES FOR SERVICES
4.25
4.25
50.00
45.75
8.5
150.00
150.00
300.00
150.00
50.0
3,169.53
28,186.31
32,100.00
3,913.69
87.8
GRAND LAKE CENTER 10-350-100 GL CENTER - RENTS
2,080.00
4,720.00
.00
(
4,720.00)
.0
10-350-110 GL CENTER - MERCH SALES
1,878.00
1,878.00
.00
(
1,878.00)
.0
10-350-200 GL CENTER - DONATIONS
1,176.50
5,376.50
.00
(
5,376.50)
.0
5,134.50
11,974.50
.00
(
11,974.50)
.0
TOTAL GRAND LAKE CENTER
42 % OF THE FISCAL YEAR HAS ELAPSED
5
Page 23 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
FINES 10-351-100 ORDINANCE/TRAFFIC FINES TOTAL FINES
.00
.00
500.00
500.00
.0
.00
.00
500.00
500.00
.0
246.28
2,493.36
4,000.00
1,506.64
62.3
.00
.00
.00
.00
.0
1,275.00
3,245.00
3,000.00
245.00)
108.2
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
.00
.00
2.00
2.00
.0
10-360-180 RENT - VISITORS CENTER
.00
625.00
2,500.00
1,875.00
25.0
10-360-190 GIFTS - DONATIONS
.00
.00
1,200.00
520.56
14,824.53
5,000.00
10-360-210 5% BUSINESS LICENSE FEE
.00
.00
10-360-220 5% NIGHTLY RENTAL LICENSE
.00
.00
630.00
2,060.00
.00
10-360-200 MISC. REVENUES - GENERAL
10-360-230 MEMORIAL BENCHES
1,200.00
.0
9,824.53)
296.5
.00
.00
.0
.00
.00
.0
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
2,671.84
23,247.89
32,689.00
9,441.11
71.1
.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
10-377-156 EV CHARGING STATION
.00
.00
8,260.00
8,260.00
.0
10-377-157 DOLA TIER 1 - W. PORTAL BRIDGE
.00
.00
73,520.00
73,520.00
.0
.00
.00
921,860.00
921,860.00
.0
113,348.38
435,650.36
2,641,747.00
2,206,096.64
16.5
TOTAL CAPITAL SPECIFIC REVENUE
TOTAL FUND REVENUE
42 % OF THE FISCAL YEAR HAS ELAPSED
6
Page 24 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
CEMETERY COMMITTEE 10-410-211 GENERAL SUPPLIES/MISC EXPENSES
.00
.00
3,500.00
3,500.00
10-410-215 GRAVE MARKERS
.00
.00
2,600.00
2,600.00
.0
10-410-242 GENERAL MAINTENANCE
.00
.00
3,000.00
3,000.00
.0
.00
.00
9,100.00
9,100.00
.0
TOTAL CEMETERY COMMITTEE
.0
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
38.00
64.00
400.00
336.00
16.0
.00
.00
.00
.00
.0
38.00
64.00
3,300.00
3,236.00
1.9
TOTAL P.O.S.T. COMMITTEE
PC/BOA
10-412-370 TRAINING/TRAVEL 10-412-380 COMP PLAN UPDATE TOTAL PC/BOA
42 % OF THE FISCAL YEAR HAS ELAPSED
7
Page 25 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
184.67
1,433.38
5,600.00
4,166.62
25.6
.00
3,000.00
3,000.00
.00
100.0 44.8
10-413-370 TRAINING/TRAVEL 10-413-452 HEADWATER TRAILS ALLIANCE 10-413-460 LONG RANGE/MISC
309.21
313.59
700.00
386.41
10-413-461 APPRECIATION PROGRAM
263.50
313.77
3,500.00
3,186.23
9.0
10-413-462 COMPUTER EQUIPMENT
2,992.93
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-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 10-413-731 GRND CNTY COUNCIL ON AGING 10-413-782 ADVOCATES
.00
.00
3,500.00
3,500.00
.0
700.00
1,200.00
2,500.00
1,300.00
48.0
3,500.00
3,500.00
3,500.00
.00
100.0
.00
1,500.00
1,500.00
.00
100.0
10-413-793 GL FIREWORKS
.00
.00
11,000.00
11,000.00
.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
4,000.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
11,950.31
26,995.08
148,353.00
121,357.92
18.2
10-414-211 GENERAL SUPPLIES
40.03
279.06
1,500.00
1,220.94
18.6
10-414-238 TREES/SHRUBS/PLANTINGS
16.99
16.99
5,000.00
4,983.01
.3
10-414-241 ARBOR DAY SUPPLIES
33.60
169.60
500.00
330.40
33.9
TOTAL BOARD OF TRUSTEES
GREENWAYS COMMITTEE
10-414-245 GRND GARDENS 10-414-319 CONTRACT LABOR
.00
.00
500.00
500.00
.0
5,541.17
5,541.17
33,247.00
27,705.83
16.7
10-414-726 MISCELLANEOUS SERVICES
.00
.00
200.00
200.00
.0
10-414-870 CONTINGENCY
.00
.00
250.00
250.00
.0
5,631.79
6,006.82
41,197.00
35,190.18
14.6
TOTAL GREENWAYS COMMITTEE
42 % OF THE FISCAL YEAR HAS ELAPSED
8
Page 26 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
ADMINISTRATION 10-415-100 GROSS WAGES - ADMINISTRATION
16,185.74
85,928.66
199,070.00
113,141.34
765.00
765.00
1,138.00
373.00
67.2
10-415-132 ICMA TOWN PAID BENEFIT
1,111.58
5,297.06
15,526.00
10,228.94
34.1
10-415-133 HEALTH/DENTAL-EMPLOYEE
41.8
10-415-131 LONGEVITY BENEFIT
43.2
3,119.08
15,595.71
37,352.00
21,756.29
10-415-135 DEP HEALTH/DENTAL
41.60
199.57
20,209.00
20,009.43
1.0
10-415-136 MEDICAL BENEFIT ALLOWANCE
51.15
942.71
3,741.00
2,798.29
25.2
10-415-141 UNEMPLOYMENT INSURANCE
19.00
168.21
646.00
477.79
26.0
.00
251.22
538.00
286.78
46.7 40.1
10-415-142 WORKER'S COMPENSATION 10-415-143 SOCIAL SECURITY MATCH
1,061.28
5,363.04
13,363.00
7,999.96
10-415-144 MEDICARE MATCH
248.18
1,254.17
3,126.00
1,871.83
40.1
10-415-211 GENERAL OFFICE SUPPLIES
691.55
1,666.21
3,500.00
1,833.79
47.6
10-415-215 COMPUTER SOFTWARE
44.97
104.94
5,000.00
4,895.06
2.1
10-415-220 COMPUTER HARDWARE
.00
.00
6,000.00
6,000.00
.0
10-415-224 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
10-415-226 SMALL EQUIPMENT
165.83
829.15
2,000.00
1,170.85
41.5
10-415-231 GAS/FUEL
113.21
652.45
2,400.00
1,747.55
27.2
.00
27.19
400.00
372.81
6.8
10-415-233 OFFICE EQUIPMENT MAINTENANCE
109.95
594.12
1,600.00
1,005.88
37.1
10-415-237 BUILDING MAINTENANCE
10-415-232 VEHICLE MAINTENANCE
245.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
521.20
1,674.87
4,000.00
2,325.13
41.9
10-415-312 COMPUTER SERVICES
2,137.50
7,007.50
14,230.00
7,222.50
49.2
10-415-314 ADS & LEGAL NOTICES
24.84
865.33
1,000.00
134.67
86.5
10-415-316 DUES & MEMBERSHIPS
.00
1,070.28
1,500.00
429.72
71.4
10-415-317 BANK FEES
.00
55.00
100.00
45.00
55.0
350.00
1,540.00
3,700.00
2,160.00
41.6
.00
75.00
250.00
175.00
30.0
10-415-311 POSTAGE/FREIGHT
10-415-318 JANITORIAL SERVICES 10-415-319 MISCELLANEOUS SERVICES
276.09
1,927.55
4,200.00
2,272.45
45.9
10-415-342 SEWER UTILITY
10-415-341 ELECTRIC UTILITY
.00
483.60
1,000.00
516.40
48.4
10-415-343 WATER UTILITY
310.00
602.50
1,500.00
897.50
40.2
10-415-344 TELEPHONE UTILITY
325.36
1,659.55
4,500.00
2,840.45
36.9
10-415-345 NATURAL GAS UTILITY
149.97
1,303.92
3,000.00
1,696.08
43.5
.00
87.45
600.00
512.55
14.6
10-415-346 INTERNET SERVICES 10-415-347 RECYCLING - TOWN HALL
38.81
192.17
454.00
261.83
42.3
1,616.56
7,588.10
30,500.00
22,911.90
24.9
10-415-352 AUDIT
.00
8,820.00
8,820.00
.00
100.0
10-415-353 JUDGE-MUNICIPAL COURT
.00
450.00
1,800.00
1,350.00
25.0
1,008.00
1,855.00
11,550.00
9,695.00
16.1
180.00
1,682.03
6,000.00
4,317.97
28.0
.00
.00
500.00
500.00
.0
335.15
384.75
1,000.00
615.25
38.5
10-415-351 LEGAL SERVICES
10-415-355 PROFESSIONAL SERVICES-OTHER 10-415-370 TRAINING/TRAVEL 10-415-393 DOCUMENT RECORDING 10-415-394 DEVELOPER REIMBURSEMENT 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
10-415-540 GRANTS TO NEIGHBORHOODS
.00
.00
8,000.00
8,000.00
.0
1,073.78
3,110.29
4,855.00
1,744.71
64.1
10-415-560 TREASURER'S FEES 10-415-721 CHAMBER SERVICE AGREEMENT
.00
8,183.00
32,732.00
24,549.00
25.0
10-415-722 BLC FEE REMITTANCE
.00
7,000.00
28,000.00
21,000.00
25.0
10-415-723 VISITOR CENTER REPAIRS & MAINT
.00
.00
10,500.00
10,500.00
.0
10-415-724 NRL VC OP
.00
7,500.00
30,000.00
22,500.00
25.0
10-415-725 95% NRL ADDTL MKTG
.00
.00
.00
.00
.0
42 % OF THE FISCAL YEAR HAS ELAPSED
9
Page 27 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
10-415-870 CONTINGENCY - GENERAL ADMIN
.00
.00
1,000.00
1,000.00
.0
10-415-875 MARKETING CONTINGENCY
.00
.00
1,500.00
1,500.00
.0
32,320.38
195,096.18
553,818.00
358,721.82
35.2
2,569.13
12,730.95
31,164.00
18,433.05
40.9
.00
.00
60.00
60.00
.0
10-421-132 ICMA TOWN PAID BENEFIT
205.53
1,018.46
2,493.00
1,474.54
40.9
10-421-133 HEALTH/DENTAL-EMPLOYEE
TOTAL ADMINISTRATION
SAFETY 10-421-100 GROSS WAGES - PUBLIC SAFETY 10-421-131 LONGEVITY BENEFIT
850.62
4,253.10
10,207.00
5,953.90
41.7
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
10-421-141 UNEMPLOYMENT INSURANCE
.00
24.61
101.00
76.39
24.4
.00
209.26
448.00
238.74
46.7
172.03
877.28
2,086.00
1,208.72
42.1
10-421-142 WORKER'S COMPENSATION 10-421-143 SOCIAL SECURITY MATCH 10-421-144 MEDICARE MATCH
40.23
205.15
488.00
282.85
42.0
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
50,750.00
121,800.00
71,050.00
41.7
.00
.00
5,000.00
5,000.00
.0
13,987.54
78,399.31
193,840.00
115,440.69
40.5
10-421-339 SHERIFF'S CONTRACT 10-421-340 SPECIAL EVENT SECURITY TOTAL SAFETY
42 % OF THE FISCAL YEAR HAS ELAPSED
10
Page 28 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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 10-431-135 DEP HEALTH/DENTAL 10-431-136 MEDICAL BENEFIT ALLOWANCE
14,218.92
73,801.58
215,661.00
141,859.42
.00
2,160.00
3,300.00
1,140.00
34.2 65.5
764.30
3,746.50
17,081.00
13,334.50
21.9
2,976.05
14,029.63
45,933.00
31,903.37
30.5
406.68
2,033.40
29,714.00
27,680.60
6.8
54.30
1,011.98
4,725.00
3,713.02
21.4 20.4
10-431-141 UNEMPLOYMENT INSURANCE
.00
142.86
700.00
557.14
10-431-142 WORKER'S COMPENSATION
.00
3,437.46
7,356.00
3,918.54
46.7
10-431-143 SOCIAL SECURITY MATCH
926.13
4,898.92
14,428.00
9,529.08
34.0
10-431-144 MEDICARE MATCH
216.62
1,145.85
3,373.00
2,227.15
34.0
90.16
1,221.71
3,500.00
2,278.29
34.9
259.90
259.90
1,500.00
1,240.10
17.3
4.29
127.26
1,500.00
1,372.74
8.5
695.07
5,637.52
20,000.00
14,362.48
28.2
10-431-222 GENERAL SUPPLIES 10-431-224 SAFETY SUPPLIES 10-431-227 SMALL TOOLS 10-431-231 GAS/FUEL/LIQUIDS 10-431-232 VEHICLE MAINTENANCE
.00
210.56
12,000.00
11,789.44
1.8
795.52
4,696.25
25,000.00
20,303.75
18.8
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-233 EQUIPMENT MAINTENANCE
10-431-237 BUILDING MAINTENANCE 10-431-238 STREET LIGHT MAINTENANCE 10-431-239 MISCELLANEOUS MAINTENANCE 10-431-242 ROAD MAINTENANCE
.00
784.58
1,500.00
715.42
52.3
75.00
790.04
3,000.00
2,209.96
26.3
.00
.00
250.00
250.00
.0
2,799.43
4,158.32
75,000.00
70,841.68
5.5
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 10-431-314 ADS/BID NOTICES 10-431-317 UNIFORM ALLOWANCE
.00
.00
.00
575.00
1,340.70
500.00
(
.00
.0
840.70)
268.1
.00
587.83
2,250.00
1,662.17
26.1
371.53
1,046.26
6,000.00
4,953.74
17.4
.00
225.00
600.00
375.00
37.5
10-431-341 ELECTRIC UTILITY
551.50
2,691.73
4,200.00
1,508.27
64.1
10-431-343 WATER UTILITY
124.00
241.00
500.00
259.00
48.2
10-431-344 TELEPHONE UTILITY
218.76
1,244.87
1,950.00
705.13
63.8
10-431-345 NATURAL GAS UTILITY
219.05
2,018.18
5,000.00
2,981.82
40.4
1,788.03
9,370.01
24,800.00
15,429.99
37.8
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
10-431-370 TRAINING/TRAVEL
.00
37.08
1,000.00
962.92
3.7
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
28,130.24
143,096.98
577,321.00
434,224.02
24.8
10-431-318 TRASH/RECYCLE SERVICES 10-431-319 MISC. PURCHASED SERVICES
10-431-349 STREET LIGHT ELECTRIC UTILITY
TOTAL PUBLIC WORKS
42 % OF THE FISCAL YEAR HAS ELAPSED
11
Page 29 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
GRAND LAKE CENTER 10-450-211 GENERAL SUPPLIES
.00
193.85
.00
(
193.85)
.0
10-450-237 BUILDING MAINTENANCE
.00
160.00
.00
(
160.00)
.0
609.10
3,010.91
.00
(
3,010.91)
.0
.00
1,106.70
.00
(
1,106.70)
.0
10-450-341 ELECTRIC UTILITY 10-450-342 SEWER UTILITY 10-450-343 WATER UTILITY
248.00
482.00
.00
(
482.00)
.0
10-450-344 TELEPHONE UTILITY
251.61
471.49
.00
(
471.49)
.0
10-450-345 NATURAL GAS UTILITY
(
2,395.02)
.0
.00
.0 .0
258.66
2,395.02
.00
10-450-355 PURCHASED PROFESSIONAL SERV.
.00
.00
.00
10-450-513 PROPERTY/CASUALTY INSURANCE
.00
2,143.50
.00
(
2,143.50)
10-450-721 DONATIONS - OUT
.00
1,200.00
.00
(
1,200.00)
.0
2,684.00
2,719.56
.00
(
2,719.56)
.0
4,051.37
13,883.03
.00
(
13,883.03)
.0
10-450-870 CONTINGENCY - GL CENTER TOTAL GRAND LAKE CENTER
42 % OF THE FISCAL YEAR HAS ELAPSED
12
Page 30 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS 10-452-100 GROSS WAGES - PARKS
1,913.58
9,567.90
23,392.00
13,824.10
40.9
303.75
303.75
8,460.00
8,156.25
3.6
.00
.00
600.00
600.00
.0
76.54
382.70
1,827.00
1,444.30
21.0
10-452-133 HEALTH/DENTAL-EMPLOYEE
425.31
2,126.55
5,104.00
2,977.45
41.7
10-452-135 DEP. HEALTH/DENTAL
406.67
2,033.35
4,880.00
2,846.65
41.7
54.29
54.29
525.00
470.71
10.3
.00
19.34
101.00
81.66
19.2
.00
437.20
936.00
498.80
46.7
152.54
696.37
2,088.00
1,391.63
33.4
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
35.67
162.85
489.00
326.15
33.3
1,925.38
2,990.95
14,000.00
11,009.05
21.4
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
364.15
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-220 OPERATING SUPPLIES
10-452-233 EQUIPMENT MAINTENANCE
10-452-236 SAND & DREDGE 10-452-237 BUILDING MAINTENANCE
.00
.00
500.00
500.00
.0
52.00
188.86
6,300.00
6,111.14
3.0
1,000.00
.0
10-452-238 ADA DOCK MAINTENANCE
.00
.00
1,000.00
10-452-239 MISCELLANEOUS MAINTENANCE
.00
4,498.88
250.00
10-452-243 BENCHES/PLANTERS/FENCES
.00
.00
1,000.00
1,000.00
10-452-244 THOMASSON PARK MAINTENANCE
.00
.00
500.00
500.00
.0
10-452-246 ICE RINK/VOLLEYBALL COURT
.00
.00
1,500.00
1,500.00
.0
17.26
17.26
2,000.00
1,982.74
.9
.00
.00
.00
.00
.0 45.7
10-452-248 IRRIGATION SYSTEM MAINTENANCE 10-452-319 MISCELLANEOUS SERVICES 10-452-341 ELECTRIC UTILITY
(
4,248.88) 1799.6 .0
505.50
3,063.06
6,700.00
3,636.94
10-452-342 SEWER UTILITY
.00
213.90
450.00
236.10
47.5
10-452-343 WATER UTILITY
1,426.00
2,887.50
9,500.00
6,612.50
30.4 40.4
10-452-345 NATURAL GAS UTILITY
198.08
1,414.63
3,500.00
2,085.37
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
7,856.72
31,828.74
119,102.00
87,273.26
26.7
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
.00
1,418.33
12,002.00
10,583.67
11.8
10-815-983 LAND ACQUISITION-INTEREST
.00
5,050.41
13,873.00
8,822.59
36.4
.00
7,793.69
113,961.00
106,167.31
6.8
TOTAL ADMIN DEBT SERVICE
42 % OF THE FISCAL YEAR HAS ELAPSED
13
Page 31 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS DEBT SERVICE 10-831-500 CAPITAL EQUIP LEASE PRINCIPAL
963.06
4,787.47
11,608.00
6,820.53
41.2
10-831-510 EQUIPMENT LEASE INTEREST
374.09
1,898.28
4,438.00
2,539.72
42.8
1,337.15
6,685.75
16,046.00
9,360.25
41.7
.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
16,987.00
.0
6,723.60
6,723.60
11,500.00
4,776.40
58.5 .0
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 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,723.60
6,723.60
985,087.00
978,363.40
.7
.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
42 % OF THE FISCAL YEAR HAS ELAPSED
14
Page 32 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS CAPITAL 10-952-500 ADA DOCKS
.00
3,811.64
80,000.00
76,188.36
4.8
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
.00
3,811.64
112,000.00
108,188.36
3.4
112,027.10
520,384.82
2,873,125.00
2,352,740.18
18.1
TOTAL PARKS CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
1,321.28
(
84,734.46) (
231,378.00)
(
146,643.54)
( 36.6)
42 % OF THE FISCAL YEAR HAS ELAPSED
15
Page 33 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 WATER FUND ASSETS 20-100000 CASH IN COMBINED CASH FUND
649,519.61
20-102000 CSAFE
62,093.79
20-109100 COLOTRUST
302,989.20
20-116000 PETTY CASH
.00
20-117000 ACCTS RECEIVABLE/WATER SALES
11,959.22
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,210,951.13) 26,934.62
20-135000 DUE FROM GENERAL FUND
.00
20-136000 DUE FROM MARINA FUND
.00
TOTAL ASSETS
2,259,578.90
LIABILITIES AND EQUITY
LIABILITIES 20-200000 ACCOUNTS PAYABLE GENERAL
5,832.16
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 20-218100 HEALTH/DENTAL/VISION
.00 (
20-219100 FLEX MEDICAL
14.06) 120.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
42,321.60
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
42 % OF THE FISCAL YEAR HAS ELAPSED
16
Page 34 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 WATER FUND
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
51,447.65
BALANCE - CURRENT DATE
51,447.65
TOTAL FUND EQUITY
2,217,257.30
TOTAL LIABILITIES AND EQUITY
2,259,578.90
42 % OF THE FISCAL YEAR HAS ELAPSED
17
Page 35 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
WATER REVENUES 20-344-100 WATER SALES 20-344-110 TAP FEES - CAPITAL
336.14
251,411.46
494,774.00
243,362.54
50.8
.00
9,966.68
16,467.00
6,500.32
60.5
20-344-120 RESALE METERS
449.19
898.38
1,000.00
101.62
89.8
20-344-140 INTEREST REVENUE
252.81
1,264.20
1,000.00
(
264.20)
126.4
20-344-160 MISC. REVENUES
156.84
190.84
.00
(
190.84)
50.00
150.00
700.00
550.00
21.4
.00
.00
270,000.00
270,000.00
.0
TOTAL WATER REVENUES
1,244.98
263,881.56
783,941.00
520,059.44
33.7
TOTAL FUND REVENUE
1,244.98
263,881.56
783,941.00
520,059.44
33.7
20-344-190 BULK WATER PERMITS 20-344-910 HYDRO PROJECT FUNDING
42 % OF THE FISCAL YEAR HAS ELAPSED
.0
18
Page 36 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
14,634.92
73,174.62
189,069.00
115,894.38
.00
.00
.00
.00
38.7 .0
1,750.00
7,700.00
18,200.00
10,500.00
42.3
.00
.00
15,000.00
15,000.00
.0
204.00
204.00
2,450.00
2,246.00
8.3
20-430-132 ICMA DEFERRED COMPENSATION
1,096.76
5,418.56
14,086.00
8,667.44
38.5
20-430-133 HEALTH/DENTAL-EMPLOYEE
2,634.00
13,169.69
31,587.00
18,417.31
41.7
20-430-135 DEP HEALTH/DENTAL
11.17
53.60
26,526.00
26,472.40
.2
20-430-136 MEDICAL BENEFIT ALLOWANCE
13.64
487.31
3,174.00
2,686.69
15.4 22.4
20-430-141 UNEMPLOYMENT INSURANCE
.00
149.21
666.00
516.79
20-430-142 WORKER'S COMPENSATION
.00
1,986.64
4,251.00
2,264.36
46.7
1,081.94
5,419.90
13,740.00
8,320.10
39.5
20-430-144 MEDICARE MATCH
253.05
1,267.61
3,214.00
1,946.39
39.4
20-430-210 OFFICE SUPPLIES
.00
709.98
1,500.00
790.02
47.3
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
20-430-220 COMPUTER HARDWARE 20-430-221 CHEMICALS 20-430-222 LAB SUPPLIES/EQUIPMENT 20-430-223 WELL/PLANT SUPPLIES
.00
.00
15,000.00
15,000.00
.0
80.00
2,948.77
12,000.00
9,051.23
24.6
189.40
189.40
1,000.00
810.60
18.9
.00
566.80
750.00
183.20
75.6
20-430-225 METER PARTS
.00
.00
1,000.00
1,000.00
.0
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
235.26
905.96
5,000.00
4,094.04
18.1
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
331.95
358.02
1,000.00
641.98
35.8 9.7
20-430-237 BUILDING MAINTENANCE 20-430-238 DISTRIBUTION LINE MAINTENANCE
1,302.52
1,357.87
14,000.00
12,642.13
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
20-430-251 RESALE PARTS
.00
.00
500.00
500.00
.0
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-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
.00
275.00
700.00
425.00
39.3
20-430-317 UNIFORM ALLOWANCE
.00
.00
900.00
900.00
.0
20-430-318 TESTING SERVICES
.00
60.00
4,800.00
4,740.00
1.3
20-430-319 MISCELLANEOUS SERVICES
.00
.00
350.00
350.00
.0
20-430-320 TELEMETRY MAINTENANCE
.00
.00
2,500.00
2,500.00
.0
20-430-321 COMPUTER SYSTEM SUPPORT 20-430-341 ELECTRIC UTILITY
725.00
2,595.00
7,690.00
5,095.00
33.8
2,213.67
12,658.31
29,500.00
16,841.69
42.9 39.9
20-430-344 TELEPHONE UTILITY
166.86
997.71
2,500.00
1,502.29
20-430-345 NATURAL GAS UTILITY
180.04
2,039.94
5,000.00
2,960.06
40.8
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
42 % OF THE FISCAL YEAR HAS ELAPSED
19
Page 37 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
65.00
243.10
2,000.00
1,756.90
12.2
.00
4,069.74
8,139.00
4,069.26
50.0
.00
100.0
.00
200.00
200.00
8,201.87
41,009.35
.00
20-430-870 CONTINGENCY-OPERATIONS
.00
.00
TOTAL WATER OPERATIONS
35,371.05
20-830-640 DWRF LOAN - PRINCIPAL 20-830-645 DWRF LOAN - INTEREST
20-430-700 DEPRECIATION RESERVE
100.0
(
41,009.35)
.0
1,000.00
1,000.00
.0
184,694.79
520,692.00
335,997.21
35.5
.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
1,897.07
27,739.12
285,000.00
257,260.88
9.7
1,897.07
27,739.12
290,000.00
262,260.88
9.6
37,268.12
212,433.91
826,692.00
614,258.09
25.7
TOTAL WATER CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
(
36,023.14)
51,447.65
(
42,751.00)
(
94,198.65)
42 % OF THE FISCAL YEAR HAS ELAPSED
120.3
20
Page 38 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 MARINA FUND ASSETS 40-100000 CASH IN COMBINED CASH FUND
246,293.91
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
(
117,645.01)
TOTAL ASSETS
342,669.93
LIABILITIES AND EQUITY
LIABILITIES 40-200000 ACCOUNTS PAYABLE GENERAL
1,048.16
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
.07
40-219100 FLEX MEDICAL
30.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
1,463.56
FUND EQUITY 40-275000 UNAPPROP. RETAINED EARNINGS
358,948.50
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
17,742.13) (
17,742.13)
TOTAL FUND EQUITY
341,206.37
TOTAL LIABILITIES AND EQUITY
342,669.93
42 % OF THE FISCAL YEAR HAS ELAPSED
21
Page 39 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
MARINA REVENUES 40-344-110 BOAT RENTALS
2,310.00
2,310.00
.00
40-344-113 RENTALS (NON-TAXABLE)
4,263.00
4,263.00
135,000.00
(
130,737.00
2,310.00)
3.2
.0
40-344-115 TOURS
3.8
2,300.00
2,300.00
60,000.00
57,700.00
40-344-120 BUILDING SPACE RENTAL
.00
.00
3,300.00
3,300.00
.0
40-344-140 SEASONAL SLIP RENTALS
5,500.00
12,250.00
12,250.00
.00
100.0
40-344-145 KAYAK SLIP RENTAL
1,500.00
1,950.00
2,700.00
750.00
72.2
.00
.00
200.00
200.00
922.00
922.00
600.00
40-344-150 DAILY SLIP RENTAL 40-344-160 MISC REVENUE 40-344-170 INTEREST EARNED
(
.0
322.00)
153.7 48.7
30.19
194.76
400.00
205.24
40-344-180 BOAT DAMAGE
.00
.00
300.00
300.00
.0
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
16,825.19
24,189.76
230,570.00
206,380.24
10.5
TOTAL FUND REVENUE
16,825.19
24,189.76
230,570.00
206,380.24
10.5
42 % OF THE FISCAL YEAR HAS ELAPSED
22
Page 40 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA OPERATIONS 40-460-100 GROSS WAGES - MARINA 40-460-110 GROSS WAGES - MARINA SEASONAL 40-460-119 ACCRUED LEAVE EXPENSE 40-460-131 LONGEVITY 40-460-132 ICMA DEFERRED COMPENSATION
843.44
4,217.22
10,090.00
5,872.78
41.8
9,986.66
14,493.32
85,000.00
70,506.68
17.1
.00
.00
1,000.00
1,000.00
.0
51.00
51.00
72.00
21.00
70.8
53.30
266.54
807.00
540.46
33.0
164.05
820.25
1,964.00
1,143.75
41.8
40-460-135 DEP HEALTH/DENTAL
2.79
13.39
1,301.00
1,287.61
1.0
40-460-136 MEDICAL BENEFIT ALLOWANCE
3.41
62.46
185.00
122.54
33.8
40-460-133 HEALTH/DENTAL - EMPLOYEE
40-460-141 UNEMPLOYMENT INSURANCE
.00
7.85
288.00
280.15
2.7
40-460-142 WORKERS COMPENSATION
.00
2,100.72
4,496.00
2,395.28
46.7
40-460-143 SOCIAL SECURITY MATCH
674.43
1,180.13
5,950.00
4,769.87
19.8
40-460-144 MEDICARE MATCH
157.71
275.88
1,392.00
1,116.12
19.8
40-460-211 GENERAL OFFICE SUPPLIES
.00
49.99
1,000.00
950.01
5.0
40-460-214 SMALL EQUIP/COMP HRDWARE
.00
.00
450.00
450.00
.0
40-460-220 COMPUTER HARDWARE
.00
.00
.00
.00
.0
101.13
101.13
2,000.00
1,898.87
5.1
40-460-222 SHOP SUPPLIES 40-460-223 BOAT SUPPLIES
.00
.00
2,000.00
2,000.00
.0
40-460-227 TOOLS
.00
.00
500.00
500.00
.0
19.14
44.02
5,000.00
4,955.98
.9
.00
.00
500.00
500.00
.0
589.84
589.84
4,000.00
3,410.16
14.8
40-460-231 FUEL 40-460-232 VEHICLE MAINTENANCE 40-460-233 EQUIPMENT MAINTENANCE 40-460-237 BUILDING/FACILITY MAINTENANCE
144.17
144.17
10,000.00
9,855.83
1.4
40-460-312 COMPUTER SERVICES
225.32
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
792.00
1,179.75
1,000.00
179.75)
118.0
40-460-318 MISCELLANEOUS SERVICES
144.00
144.00
500.00
356.00
28.8
.00
515.83
1,000.00
484.17
51.6
159.93
159.93
4,000.00
3,840.07
4.0
31.73
158.21
600.00
441.79
26.4
40-460-320 MARKETING 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
124.00
241.00
500.00
259.00
48.2
97.19
637.56
1,100.00
462.44
58.0
.00
347.25
600.00
252.75
57.9
40-460-344 TELEPHONE UTILITY 40-460-350 BOAT REGISTRATION 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
11,932.50
.00
.00
.00
16,751.74
41,931.89
40-460-700 DEPRECIATION RESERVE 40-460-870 CONTINGENCY TOTAL MARINA OPERATIONS
(
11,932.50)
.0
1,000.00
1,000.00
.0
155,958.00
114,026.11
26.9
42 % OF THE FISCAL YEAR HAS ELAPSED
23
Page 41 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
16,751.74
41,931.89
215,958.00
174,026.11
19.4
17,742.13)
14,612.00
32,354.13
(121.4)
TOTAL MARINA CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
73.45
(
42 % OF THE FISCAL YEAR HAS ELAPSED
24
Page 42 of 46
TOWN OF GRAND LAKE BALANCE SHEET MAY 31, 2016 PAY-AS-YOU-THROW FUND ASSETS 50-100000 CASH IN COMBINED CASH FUND
65,027.82
50-116000 PETTY CASH
50.00
50-117000 ACCOUNTS RECEIVABLE
.00
50-127000 ASSET - BAG INVENTORY
2,890.46
TOTAL ASSETS
67,968.28
LIABILITIES AND EQUITY
LIABILITIES 50-200000 ACCOUNTS PAYABLE GENERAL
1,416.95
50-231000 DUE TO G.F. FROM PAYT
.00
TOTAL LIABILITIES
1,416.95
FUND EQUITY 50-275000 UNAPPROP. RETAINED EARNINGS
63,085.92
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
3,465.41
BALANCE - CURRENT DATE
3,465.41
TOTAL FUND EQUITY
66,551.33
TOTAL LIABILITIES AND EQUITY
67,968.28
42 % OF THE FISCAL YEAR HAS ELAPSED
25
Page 43 of 46
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
PAYT REVENUES 50-344-110 BAGS: DIRECT SALES (T)
125.00
253.00
1,060.00
807.00
2,624.00
8,349.00
45,400.00
37,051.00
18.4
7.70
47.55
100.00
52.45
47.6
TOTAL PAYT REVENUES
2,756.70
8,649.55
46,560.00
37,910.45
18.6
TOTAL FUND REVENUE
2,756.70
8,649.55
46,560.00
37,910.45
18.6
50-344-115 BAGS: VENDOR PURCHASE (NT) 50-344-140 INTEREST REVENUE
42 % OF THE FISCAL YEAR HAS ELAPSED
23.9
26
Page 44 of 46
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 5 MONTHS ENDING MAY 31, 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
1,275.86
2,057.31
20,000.00
17,942.69
10.3
125.00
625.00
1,500.00
875.00
41.7
.00
.00
1.00
1.00
.0
32.18
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
1,433.04
5,184.14
38,600.00
33,415.86
13.4
TOTAL FUND EXPENDITURES
1,433.04
5,184.14
38,600.00
33,415.86
13.4
NET REVENUE OVER EXPENDITURES
1,323.66
3,465.41
7,960.00
4,494.59
43.5
50-470-300 DUMPSTER SERVICE 50-470-301 RECYCLING CONTRIBUTION 50-470-310 SITE LEASE 50-470-312 COMPUTER SERVICES
42 % OF THE FISCAL YEAR HAS ELAPSED
23.7
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
$9,790.74 $1,505,843.37 $1,460.27 $1,517,094.38
Developer LOC Checking*
$556,253.04
Water Fund
$649,519.61
Marina Fund
PAYT
$246,293.91
$65,027.82
$16,427.47 *Letter of Credit Funds - Restricted Use Non-Interest Bearing Holding Account
CSAFE General Fund Water Fund ColoTrust
General Fund
May 31, 2016
$185,590.77 $62,093.79 $605,547.43
Gill & Associates Advantage Bank CD
FlatIrons Bank CD $96,000 Principal Interest paid monthly
$302,558.23
$302,989.20
$99,832.00 $100,140.65
$96,000.00
TOTAL
$1,356,802.16
TOTAL CASH/INVESTMENTS AT:
5/31/2016
$1,014,602.60
$246,293.91
$65,027.82
$2,682,726.49
Page 46 of 46
