Page 1 of 45
Page 1 of 45
Page 2 of 45
Page 3 of 45
Page 4 of 45
Page 5 of 45
Page 6 of 45
Page 7 of 45
Page 8 of 45
Page 9 of 45
Page 10 of 45
Page 11 of 45
Page 12 of 45
Page 13 of 45
Page 14 of 45
Page 15 of 45
Page 16 of 45
TOWN OF GRAND LAKE COMBINED CASH INVESTMENT SEPTEMBER 30, 2016 COMBINED CASH ACCOUNTS 01-101000 GMB CHECKING - OPERATIONS
2,789.91
01-105000 GMB MONEY MARKET
1,837,302.38
01-106000 RETURNED CHECK CLEARING ACCT
.00
01-107500 UTILITY CASH CLEARING ACCT
(
23.10)
(
1,840,069.19)
TOTAL COMBINED CASH
1,840,069.19
01-100000 CASH ALLOCATED TO OTHER FUNDS
TOTAL UNALLOCATED CASH
.00
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
691,021.14
20 ALLOCATION TO WATER FUND
631,424.18
40 ALLOCATION TO MARINA FUND
440,634.91
50 ALLOCATION TO PAY-AS-YOU-THROW FUND
76,988.96
TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 01-100000
1,840,069.19 (
1,840,069.19)
ZERO PROOF IF ALLOCATIONS BALANCE
.00
75 % OF THE FISCAL YEAR HAS ELAPSED
1
Page 17 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 GENERAL FUND ASSETS 10-100000 CASH IN COMBINED CASH FUND
691,021.14
10-103000 CSAFE
186,201.50
10-106000 ADVANTAGE BANK - CD
100,140.65
10-109100 COLOTRUST
303,237.86
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
437.40
10-129000 UNLEADED GAS INVENTORY
994.79
10-130000 DIESEL INVENTORY
941.35
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,013.00
TOTAL ASSETS
1,737,272.16
LIABILITIES AND EQUITY
LIABILITIES 10-200000 ACCOUNTS PAYABLE GENERAL
82,219.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
52.68
10-219100 FLEX MEDICAL
1,558.37
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
70,117.17
10-228000 DEVELOPER LOC FUNDS
16,427.47
10-228100 GLC CUSTOMER DEPOSITS
200.00
10-228200 GLC PREPAID RENTAL FEES
3,000.00
10-228300 GLC PREPAID MEMBERSHIPS
405.00
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
428,167.38
75 % OF THE FISCAL YEAR HAS ELAPSED
2
Page 18 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 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
(
5,092.43) (
5,092.43)
TOTAL FUND EQUITY
1,309,104.78
TOTAL LIABILITIES AND EQUITY
1,737,272.16
75 % OF THE FISCAL YEAR HAS ELAPSED
3
Page 19 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
GENERAL TAXES 10-311-100 PROPERTY TAXES
4,219.72
239,853.93
241,557.00
1,703.07
10-311-110 SPECIFIC OWNERSHIP
1,457.06
10,001.56
14,000.00
3,998.44
71.4
158.99
480.26
500.00
19.74
96.1
7,928.31)
139.6
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
(
99.3
3,449.11
27,928.31
20,000.00
275,977.42
662,672.96
1,164,718.00
502,045.04
.00
.00
30,000.00
30,000.00
.0
316.55
2,294.07
3,000.00
705.93
76.5
285,578.85
943,231.09
1,473,775.00
530,543.91
64.0
56.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
3,015.00
4,224.00
1,209.00
71.4
10-316-172 ELECTRIC FRANCHISE 10-316-173 NATURAL GAS FRANCHISE TOTAL UTILITY FRANCHISES
.00
16,680.44
30,000.00
13,319.56
55.6
651.60
7,548.89
14,000.00
6,451.11
53.9
1,656.60
27,244.33
64,224.00
36,979.67
42.4
LICENSES & PERMITS 250.00
6,582.50
2,000.00
4,582.50)
329.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
20.00
415.00
400.00
15.00)
103.8
251.00
1,563.50
2,000.00
436.50
78.2
10.00
255.00
350.00
95.00
72.9
10-321-150 GRADING PERMIT
.00
175.00
50.00
(
125.00)
350.0
10-321-160 ANIMAL LICENSE
.00
140.00
100.00
(
40.00)
140.0
100.00
735.00
300.00
(
435.00)
245.0
5,301.00
29,283.50
29,000.00
(
283.50)
101.0
750.00
32,250.00
30,000.00
(
2,250.00)
107.5
6,682.00
71,399.50
64,200.00
(
7,199.50)
111.2
10-321-120 TOWN SALES TAX LICENSE 10-321-130 MOTOR VEHICLE LICENSE 10-321-140 SIGN PERMIT
10-321-170 ENCROACHMENT PERMIT/LICENSE 10-321-175 BUSINESS LICENSE COMMISSION 10-321-180 NIGHTLY RENTAL LICENSE TOTAL LICENSES & PERMITS
(
(
75 % OF THE FISCAL YEAR HAS ELAPSED
4
Page 20 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
4,752.00
6,336.00
1,584.00
75.0
2,869.03
20,627.57
30,063.00
9,435.43
68.6
540.33
1,960.89
2,000.00
39.11
98.0
3,937.70
3,937.70
4,000.00
62.30
98.4
7,347.06
31,278.16
42,399.00
11,120.84
73.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
.00
.00
50.00
10-341-200 CEMETERY
.00
8,700.00
5,000.00
10-341-201 HEADSTONE DEPOSIT 10-341-300 ZONING & SUBDIVISION REVIEW 10-341-400 ATTAINABLE HOUSING FEE
.0 174.0
.00
2,000.00
1,600.00
(
400.00)
125.0
6,672.36
4,000.00
(
2,672.36)
166.8
(
3,593.50)
118.0
.00
23,593.50
20,000.00
75.65
560.85
1,100.00
10-341-700 COPIES/FAXES/SODA
36.55
62.66
50.00
300.00
1,050.00
1,125.56
TOTAL CHARGES FOR SERVICES
50.00 3,700.00)
713.36
10-341-600 FUEL DEPOT SURCHARGE 10-341-850 NIGHTLY RENTAL APPLICATION FEE
(
539.15
51.0
(
12.66)
125.3
300.00
(
750.00)
350.0
42,639.37
32,100.00
(
10,539.37)
132.8
2,695.00
8,520.00
.00
(
8,520.00)
.0
.00
2,214.00
.00
(
2,214.00)
.0 .0
GRAND LAKE CENTER 10-350-100 GL CENTER - RENTAL FEES 10-350-110 GL CENTER - MERCH SALES 10-350-120 GL CENTER - MEMBERSHIPS
135.00
135.00
.00
(
135.00)
1,707.00
10,078.50
.00
(
10,078.50)
.0
10-350-701 DOLA REDI BUS PLAN GRANT
30,000.00
30,000.00
.00
(
30,000.00)
.0
TOTAL GRAND LAKE CENTER
34,537.00
50,947.50
.00
(
50,947.50)
.0
10-350-200 GL CENTER - DONATIONS
75 % OF THE FISCAL YEAR HAS ELAPSED
5
Page 21 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
FINES 10-351-100 ORDINANCE/TRAFFIC FINES TOTAL FINES
.00
100.00
500.00
400.00
20.0
.00
100.00
500.00
400.00
20.0
409.16
4,357.63
4,000.00
357.63)
108.9
.00
.00
.00
60.00
7,215.00
3,000.00
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
(
.00
.0
4,215.00)
240.5
.00
.00
2.00
2.00
.0
625.00
1,875.00
2,500.00
625.00
75.0
.00
.00
1,200.00
396.75
21,163.90
5,000.00
10-360-210 5% BUSINESS LICENSE FEE
.00
.00
10-360-220 5% NIGHTLY RENTAL LICENSE
.00
.00
10-360-230 MEMORIAL BENCHES
.00
2,060.00
.00
10-360-200 MISC. REVENUES - GENERAL
(
1,200.00
.0
16,163.90)
423.3
.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
1,490.91
36,671.53
32,689.00
10-377-100 CAPITAL LEASE PROCEEDS
.00
.00
10-377-150 CDOT OFF-SYSTEM BRIDGE PROGRAM
.00
.00
10-377-151 W. PORTAL BRIDGE FUNDING
.00
.00
10-377-152 STATE HISTORIC FUND-COMM HOUSE
.00
10-377-153 DOLA ADMIN GRANT
.00
10-377-154 FISHING IS FUN 10-377-155 DOLA TIER 1 GRANT 10-377-156 EV CHARGING STATION 10-377-157 DOLA TIER 1 - W. PORTAL BRIDGE
TOTAL MISCELLANEOUS
(
3,982.53)
112.2
.00
.00
.0
694,080.00
694,080.00
.0
100,000.00
100,000.00
.0
.00
.00
.00
.0
.00
.00
.00
.0
.00
.00
24,000.00
24,000.00
.0
.00
.00
22,000.00
22,000.00
.00
9,760.00
8,260.00
.00
.00
73,520.00
73,520.00
.0
.00
9,760.00
921,860.00
912,100.00
1.1
338,417.98
1,213,271.48
2,641,747.00
1,428,475.52
45.9
CAPITAL SPECIFIC REVENUE
TOTAL CAPITAL SPECIFIC REVENUE
TOTAL FUND REVENUE
(
1,500.00)
.0 118.2
75 % OF THE FISCAL YEAR HAS ELAPSED
6
Page 22 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
CEMETERY COMMITTEE 10-410-211 GENERAL SUPPLIES/MISC EXPENSES
.00
30.45
3,500.00
3,469.55
.9
10-410-215 GRAVE MARKERS
.00
2,220.00
2,600.00
380.00
85.4
10-410-242 GENERAL MAINTENANCE
.00
.00
3,000.00
3,000.00
.0
.00
2,250.45
9,100.00
6,849.55
24.7
TOTAL CEMETERY COMMITTEE
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
TOTAL P.O.S.T. COMMITTEE
PC/BOA 10-412-211 GENERAL OFFICE SUPPLIES
50.30
50.30
1,000.00
949.70
5.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
55.00
100.00
45.00
55.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
14.00
106.07
400.00
293.93
26.5
.00
.00
.00
.00
.0
64.30
211.37
3,300.00
3,088.63
6.4
10-412-370 TRAINING/TRAVEL 10-412-380 COMP PLAN UPDATE TOTAL PC/BOA
75 % OF THE FISCAL YEAR HAS ELAPSED
7
Page 23 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
BOARD OF TRUSTEES 10-413-215 ELECTIONS
.00
579.41
3,500.00
2,920.59
16.6
10-413-316 DUES/MEMBERSHIPS
.00
6,590.85
7,117.00
526.15
92.6
261.38
4,617.77
5,600.00
982.23
82.5
.00
3,000.00
3,000.00
.00
100.0 51.9
10-413-370 TRAINING/TRAVEL 10-413-452 HEADWATER TRAILS ALLIANCE 10-413-460 LONG RANGE/MISC
.00
363.58
700.00
336.42
138.72
669.54
3,500.00
2,830.46
19.1
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-461 APPRECIATION PROGRAM
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
.00
.00
3,500.00
3,500.00
.0
10-413-728 MISCELLANEOUS DONATIONS
.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
.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
1,500.00
1,500.00
1,500.00
.00
100.0
10-413-845 GC RURAL HEALTH NETWORK
.00
1,000.00
1,000.00
.00
100.0
10-413-846 HEART OF THE MTNS HOSPICE
.00
.00
2,500.00
2,500.00
.0
10-413-847 SHINING STARS FOUNDATION
.00
1,340.00
1,500.00
160.00
89.3
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
80.00
80.00
.00
100.0
10-413-852 GRAND ANGELS
.00
4,500.00
4,500.00
.00
100.0
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
1,000.00
1,000.00
1,000.00
.00
100.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-856 GRAND ENTERPRISE INITIATIVE
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
2,900.10
52,184.08
148,353.00
96,168.92
35.2
52.7
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
95.86
790.79
1,500.00
709.21
553.57
4,412.35
5,000.00
587.65
88.3
.00
169.60
500.00
330.40
33.9
.00
.00
500.00
500.00
.0
5,541.17
27,705.85
33,247.00
5,541.15
83.3
10-414-726 MISCELLANEOUS SERVICES
.00
.00
200.00
200.00
.0
10-414-870 CONTINGENCY
.00
.00
250.00
250.00
.0
6,190.60
33,078.59
41,197.00
8,118.41
80.3
TOTAL GREENWAYS COMMITTEE
75 % OF THE FISCAL YEAR HAS ELAPSED
8
Page 24 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
ADMINISTRATION 10-415-100 GROSS WAGES - ADMINISTRATION 10-415-131 LONGEVITY BENEFIT
18,093.80
157,814.09
199,070.00
41,255.91
79.3
.00
919.00
1,138.00
219.00
80.8
10-415-132 ICMA TOWN PAID BENEFIT
1,014.22
9,447.62
15,526.00
6,078.38
60.9
10-415-133 HEALTH/DENTAL-EMPLOYEE
2,525.77
25,724.83
37,352.00
11,627.17
68.9
8.56
233.81
20,209.00
19,975.19
1.2
10-415-136 MEDICAL BENEFIT ALLOWANCE
281.25
2,976.65
3,741.00
764.35
79.6
10-415-141 UNEMPLOYMENT INSURANCE
147.57
478.02
646.00
167.98
74.0
.00
376.83
538.00
161.17
70.0 74.3
10-415-135 DEP HEALTH/DENTAL
10-415-142 WORKER'S COMPENSATION 10-415-143 SOCIAL SECURITY MATCH
1,063.30
9,921.65
13,363.00
3,441.35
10-415-144 MEDICARE MATCH
248.66
2,320.26
3,126.00
805.74
74.2
10-415-211 GENERAL OFFICE SUPPLIES
744.20
4,478.28
3,500.00
978.28)
128.0
(
10-415-215 COMPUTER SOFTWARE
15.98
595.81
5,000.00
4,404.19
11.9
10-415-220 COMPUTER HARDWARE
.00
4,653.10
6,000.00
1,346.90
77.6
10-415-224 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
10-415-226 SMALL EQUIPMENT
165.83
1,492.47
2,000.00
507.53
74.6
10-415-231 GAS/FUEL
180.47
1,146.67
2,400.00
.00
827.96
400.00
10-415-232 VEHICLE MAINTENANCE 10-415-233 OFFICE EQUIPMENT MAINTENANCE
1,253.33
47.8
(
427.96)
207.0
383.51
76.0
(
991.06)
199.1
171.49
1,216.49
1,600.00
1,068.19
1,991.06
1,000.00
10-415-238 TOWN HALL FURNISHINGS
.00
235.48
1,750.00
1,514.52
10-415-252 RESALE SUPPLIES
.00
.00
50.00
50.00
.0
10-415-311 POSTAGE/FREIGHT
1,090.30
4,453.57
4,000.00
453.57)
111.3
10-415-312 COMPUTER SERVICES
1,236.25
10,801.25
14,230.00
10-415-314 ADS & LEGAL NOTICES
238.87
1,942.55
1,000.00
10-415-316 DUES & MEMBERSHIPS
.00
1,070.28
1,500.00
429.72
71.4
10-415-317 BANK FEES
.00
60.00
100.00
40.00
60.0
280.00
2,730.00
3,700.00
970.00
73.8
.00
216.75
250.00
33.25
86.7
276.09
3,077.33
4,200.00
1,122.67
73.3
10-415-342 SEWER UTILITY
.00
725.40
1,000.00
274.60
72.5
10-415-343 WATER UTILITY
.00
919.50
1,500.00
580.50
61.3
10-415-344 TELEPHONE UTILITY
325.46
2,961.28
4,500.00
1,538.72
65.8
10-415-345 NATURAL GAS UTILITY
100.57
1,602.29
3,000.00
1,397.71
53.4
10-415-237 BUILDING MAINTENANCE
10-415-318 JANITORIAL SERVICES 10-415-319 MISCELLANEOUS SERVICES 10-415-341 ELECTRIC UTILITY
10-415-346 INTERNET SERVICES 10-415-347 RECYCLING - TOWN HALL 10-415-351 LEGAL SERVICES 10-415-352 AUDIT 10-415-353 JUDGE-MUNICIPAL COURT 10-415-355 PROFESSIONAL SERVICES-OTHER 10-415-370 TRAINING/TRAVEL 10-415-393 DOCUMENT RECORDING
(
(
13.5
3,428.75 (
(
942.55)
75.9 194.3
.00
675.45
600.00
75.45)
112.6
48.17
375.47
454.00
78.53
82.7
1,868.18
13,748.51
30,500.00
16,751.49
45.1
.00
8,820.00
8,820.00
.00
100.0
450.00
1,350.00
1,800.00
450.00
75.0
38.00)
2,211.00
11,550.00
9,339.00
19.1
339.89
5,823.39
6,000.00
176.61
97.1
.00
.00
500.00
500.00
.0
182.18
766.93
1,000.00
233.07
76.7
10-415-513 PROPERTY/CASUALTY INSURANCE
.00
13,555.91
17,968.00
4,412.09
75.4
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
1,276.14
8,000.00
6,723.86
16.0
10-415-394 DEVELOPER REIMBURSEMENT
10-415-560 TREASURER'S FEES
87.57
4,808.06
4,855.00
46.94
99.0
10-415-721 CHAMBER SERVICE AGREEMENT
8,183.00
24,549.00
32,732.00
8,183.00
75.0
10-415-722 BLC FEE REMITTANCE
7,000.00
21,000.00
28,000.00
7,000.00
75.0
.00
.00
10,500.00
10,500.00
.0
7,500.00
22,500.00
30,000.00
7,500.00
75.0
.00
.00
.00
.00
.0
10-415-723 VISITOR CENTER REPAIRS & MAINT 10-415-724 NRL VC OP 10-415-725 95% NRL ADDTL MKTG
75 % OF THE FISCAL YEAR HAS ELAPSED
9
Page 25 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL 10-415-870 CONTINGENCY - GENERAL ADMIN
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
140.00
565.00
1,000.00
435.00
56.5
.00
.00
1,500.00
1,500.00
.0
55,037.82
379,772.14
553,818.00
174,045.86
68.6
1,500.00
20,148.28
31,164.00
11,015.72
64.7
.00
.00
60.00
60.00
.0
60.00
1,497.98
2,493.00
995.02
60.1
10-421-133 HEALTH/DENTAL-EMPLOYEE
.00
5,951.86
10,207.00
4,255.14
58.3
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
14.39
61.65
101.00
39.35
61.0
.00
313.89
448.00
134.11
70.1
10-421-143 SOCIAL SECURITY MATCH
91.55
1,361.73
2,086.00
724.27
65.3
10-421-144 MEDICARE MATCH
21.41
318.44
488.00
169.56
65.3
10-421-314 DISPATCH OPERATIONS
.00
16,661.00
16,661.00
.00
100.0
10-421-319 MISC PURCHASED SERV
.00
.00
.00
.00
.0
10,150.00
91,350.00
121,800.00
30,450.00
75.0
.00
.00
5,000.00
5,000.00
.0
11,837.35
137,664.83
193,840.00
56,175.17
71.0
10-415-875 MARKETING CONTINGENCY TOTAL ADMINISTRATION
SAFETY 10-421-100 GROSS WAGES - PUBLIC SAFETY 10-421-131 LONGEVITY BENEFIT 10-421-132 ICMA TOWN PAID BENEFIT
10-421-141 UNEMPLOYMENT INSURANCE 10-421-142 WORKER'S COMPENSATION
10-421-339 SHERIFF'S CONTRACT 10-421-340 SPECIAL EVENT SECURITY TOTAL SAFETY
75 % OF THE FISCAL YEAR HAS ELAPSED
10
Page 26 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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 10-431-135 DEP HEALTH/DENTAL 10-431-136 MEDICAL BENEFIT ALLOWANCE 10-431-141 UNEMPLOYMENT INSURANCE 10-431-142 WORKER'S COMPENSATION 10-431-143 SOCIAL SECURITY MATCH
16,334.30
132,792.64
215,661.00
82,868.36
61.6
.00
2,760.00
3,300.00
540.00
83.6
764.30
6,803.70
17,081.00
10,277.30
39.8
2,971.71
25,916.47
45,933.00
20,016.53
56.4
406.68
3,660.12
29,714.00
26,053.88
12.3
.00
1,482.10
4,725.00
3,242.90
31.4
137.18
409.38
700.00
290.62
58.5
.00
5,156.19
7,356.00
2,199.81
70.1 60.7
1,086.12
8,759.09
14,428.00
5,668.91
10-431-144 MEDICARE MATCH
254.04
2,048.75
3,373.00
1,324.25
60.7
10-431-222 GENERAL SUPPLIES
459.03
1,921.43
3,500.00
1,578.57
54.9 17.3
10-431-224 SAFETY SUPPLIES
.00
259.90
1,500.00
1,240.10
10-431-227 SMALL TOOLS
.00
1,050.72
1,500.00
449.28
70.1
10-431-231 GAS/FUEL/LIQUIDS
733.48
8,164.45
20,000.00
11,835.55
40.8
10-431-232 VEHICLE MAINTENANCE
132.08
1,107.13
12,000.00
10,892.87
9.2
.00
6,350.79
25,000.00
18,649.21
25.4 26.7
10-431-233 EQUIPMENT MAINTENANCE 10-431-235 TIRES/CHAINS
1,066.56
1,066.56
4,000.00
2,933.44
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
835.52
3,000.00
2,164.48
27.9
10-431-239 MISCELLANEOUS MAINTENANCE
.00
199.11
250.00
50.89
79.6 50.8
10-431-242 ROAD MAINTENANCE
3,480.83
38,128.49
75,000.00
36,871.51
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
.00
1,129.66
2,250.00
1,120.34
50.2
375.09
4,488.73
6,000.00
1,511.27
74.8
10-431-317 UNIFORM ALLOWANCE 10-431-318 TRASH/RECYCLE SERVICES 10-431-319 MISC. PURCHASED SERVICES 10-431-341 ELECTRIC UTILITY 10-431-343 WATER UTILITY 10-431-344 TELEPHONE UTILITY 10-431-345 NATURAL GAS UTILITY 10-431-349 STREET LIGHT ELECTRIC UTILITY 10-431-354 ENGINEERING/SURVEYING SERVICES
(
.00
.0
840.70)
268.1
.00
475.00
600.00
125.00
79.2
262.92
4,061.81
4,200.00
138.19
96.7
.00
365.00
500.00
235.93
2,118.84
1,950.00
(
135.00
73.0
168.84)
108.7
151.35
2,506.70
5,000.00
2,493.30
1,772.23
16,524.53
24,800.00
8,275.47
66.6
71,700.00
71,700.00
23,000.00
48,700.00)
311.7
(
50.1
10-431-355 CAPITAL IMPROVEMENT PLAN
.00
.00
.00
.00
.0
10-431-370 TRAINING/TRAVEL
.00
77.50
1,000.00
922.50
7.8
10-431-399 EQUIP RENTAL 10-431-870 CONTINGENCY- PUBLIC WORKS TOTAL PUBLIC WORKS
.00
.00
3,000.00
3,000.00
.0
36.60
36.60
500.00
463.40
7.3
102,360.43
354,482.19
577,321.00
222,838.81
61.4
75 % OF THE FISCAL YEAR HAS ELAPSED
11
Page 27 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
GRAND LAKE CENTER 10-450-100 GROSS WAGES - GL CENTER 10-450-110 GROSS WAGES-GL CENTER SEASONAL 10-450-141 UNEMPLOYMENT INSURANCE 10-450-142 WORKER'S COMPENSATION 10-450-143 SOCIAL SECURITY MATCH 10-450-144 MEDICARE MATCH 10-450-211 GEN OFFICE SUPPLIES 10-450-213 COMPUTER HARDWARE 10-450-220 OPERATING SUPPLIES 10-450-237 BUILDING MAINTENANCE 10-450-318 TRASH/RECYCLE SERVICES 10-450-320 MARKETING 10-450-341 ELECTRIC UTILITY 10-450-342 SEWER UTILITY 10-450-343 WATER UTILITY 10-450-344 TELEPHONE UTILITY 10-450-345 NATURAL GAS UTILITY 10-450-355 PURCHASED PROFESSIONAL SERV. 10-450-360 SALES TAX 10-450-513 PROPERTY/CASUALTY INSURANCE 10-450-721 DONATIONS - OUT
.00
.00
.00
.00
.0
1,620.00
4,182.00
.00
(
4,182.00)
.0
12.55
12.55
.00
(
12.55)
.0
.00
.00
.00
.00
.0
100.44
259.29
.00
(
259.29)
.0
23.49
60.64
.00
(
60.64)
.0
601.69
2,224.43
.00
(
2,224.43)
.0
.00
1,530.03
.00
(
1,530.03)
.0
1,958.42
1,978.55
.00
(
1,978.55)
.0
146.40
9,705.13
.00
(
9,705.13)
.0
75.00
75.00
.00
(
75.00)
.0 .0
.00
218.81
.00
(
218.81)
444.76
4,772.65
.00
(
4,772.65)
.0
.00
1,660.05
.00
(
1,660.05)
.0
.00
851.80
.00
(
851.80)
.0
207.97
1,234.04
.00
(
1,234.04)
.0
72.78
2,690.33
.00
(
2,690.33)
.0
35,181.00
35,181.00
.00
(
35,181.00)
.0
157.00
157.00
.00
(
157.00)
.0
.00
3,215.25
.00
(
3,215.25)
.0
.00
2,300.00
.00
(
2,300.00)
.0
10-450-755 EXERCISE EQUIPMENT
980.00
4,387.00
.00
(
4,387.00)
.0
10-450-870 CONTINGENCY - GL CENTER
102.69
2,822.25
.00
(
2,822.25)
.0
41,684.19
79,517.80
.00
(
79,517.80)
.0
TOTAL GRAND LAKE CENTER
75 % OF THE FISCAL YEAR HAS ELAPSED
12
Page 28 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS 10-452-100 GROSS WAGES - PARKS 10-452-110 GROSS WAGES-PARKS SEASONAL 10-452-131 LONGEVITY
1,913.58
17,222.22
23,392.00
6,169.78
73.6
.00
1,511.25
8,460.00
6,948.75
17.9
.00
600.00
600.00
.00
100.0
76.54
688.86
1,827.00
1,138.14
37.7
10-452-133 HEALTH/DENTAL-EMPLOYEE
424.69
3,825.31
5,104.00
1,278.69
75.0
10-452-135 DEP. HEALTH/DENTAL
406.67
3,660.03
4,880.00
1,219.97
75.0 29.4
10-452-132 ICMA DEFERRED COMPENSATION
10-452-136 MEDICAL BENEFIT ALLOWANCE
.00
154.29
525.00
370.71
21.12
62.55
101.00
38.45
61.9
.00
655.80
936.00
280.20
70.1
162.54
1,330.57
2,088.00
757.43
63.7
38.01
311.16
489.00
177.84
63.6
1,434.39
11,277.10
14,000.00
2,722.90
80.6
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
442.80
1,600.00
1,157.20
27.7 32.3
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-234 INFORMATION SIGNS 10-452-235 GREENBELT MAINTENANCE 10-452-236 SAND & DREDGE 10-452-237 BUILDING MAINTENANCE 10-452-238 ADA DOCK MAINTENANCE 10-452-239 MISCELLANEOUS MAINTENANCE
.00
2,102.00
6,500.00
4,398.00
1,468.50
1,839.20
5,000.00
3,160.80
.00
877.07
500.00
2,392.63
3,299.24
6,300.00
.00
2,598.92
36.8
(
377.07)
175.4
3,000.76
52.4
1,000.00
(
1,598.92)
259.9
(
4,442.76) 1877.1
.00
4,692.76
250.00
4.29
23.57
1,000.00
976.43
10-452-244 THOMASSON PARK MAINTENANCE
.00
.00
500.00
500.00
.0
10-452-246 ICE RINK/VOLLEYBALL COURT
.00
98.40
1,500.00
1,401.60
6.6
10-452-248 IRRIGATION SYSTEM MAINTENANCE
.00
421.20
2,000.00
1,578.80
21.1
10-452-319 MISCELLANEOUS SERVICES
.00
990.00
.00
461.08
5,005.23
6,700.00
10-452-243 BENCHES/PLANTERS/FENCES
10-452-341 ELECTRIC UTILITY
(
2.4
990.00)
.0
1,694.77
74.7
10-452-342 SEWER UTILITY
.00
320.85
450.00
129.15
71.3
10-452-343 WATER UTILITY
.00
5,660.10
9,500.00
3,839.90
59.6 59.0
174.76
2,063.84
3,500.00
1,436.16
10-452-350 GLE UTILITIES
10-452-345 NATURAL GAS UTILITY
.00
.00
.00
.00
.0
10-452-399 EQUIPMENT RENTAL
.00
1,245.25
1,000.00
245.25)
124.5
10-452-400 GRAND AVENUE GARDENS
.00
180.00
2,000.00
1,820.00
9.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
8,978.80
73,159.57
119,102.00
45,942.43
61.4
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,984.98
7,351.28
12,002.00
4,650.72
61.3
10-815-983 LAND ACQUISITION-INTEREST
3,483.76
12,054.94
13,873.00
1,818.06
86.9
6,468.74
20,731.17
113,961.00
93,229.83
18.2
TOTAL ADMIN DEBT SERVICE
75 % OF THE FISCAL YEAR HAS ELAPSED
13
Page 29 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS DEBT SERVICE 10-831-500 CAPITAL EQUIP LEASE PRINCIPAL
974.32
8,667.82
11,608.00
2,940.18
74.7
10-831-510 EQUIPMENT LEASE INTEREST
362.83
3,366.53
4,438.00
1,071.47
75.9
1,337.15
12,034.35
16,046.00
4,011.65
75.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.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
.00
.00
16,987.00
10-931-910 CAPITAL EQUIPMENT PURCHASE
.00
12,875.68
11,500.00
10-931-911 CAPITALIZED EQUIPMENT REPAIR 10-931-921 PAVING
(
16,987.00
.0
1,375.68)
112.0
.00
.00
.00
.00
.0
25,000.00
25,000.00
25,000.00
.00
100.0 .0
10-931-922 DRAINAGE
.00
.00
20,000.00
20,000.00
10-931-971 LEASE PURCHASE CAPITAL
.00
.00
.00
.00
.0
21,229.01
30,076.05
867,600.00
837,523.95
3.5
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
46,229.01
67,951.73
985,087.00
917,135.27
6.9
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
10-931-972 W PORTAL BRIDGE REHAB
TOTAL PUBLIC WORKS CAPITAL
GL CENTER CAPITAL 10-950-700 PROPERTY/BUILDINGS TOTAL GL CENTER CAPITAL
75 % OF THE FISCAL YEAR HAS ELAPSED
14
Page 30 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS CAPITAL 10-952-500 ADA DOCKS
.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
.00
5,325.64
112,000.00
106,674.36
4.8
283,088.49
1,218,363.91
2,873,125.00
1,654,761.09
42.4
TOTAL PARKS CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
55,329.49
(
5,092.43) (
231,378.00)
(
226,285.57)
(
75 % OF THE FISCAL YEAR HAS ELAPSED
2.2)
15
Page 31 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 WATER FUND ASSETS 20-100000 CASH IN COMBINED CASH FUND
631,424.18
20-102000 CSAFE
62,214.35
20-109100 COLOTRUST
303,668.85
20-116000 PETTY CASH
.00
20-117000 ACCTS RECEIVABLE/WATER SALES
4,609.26
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,241,521.95) 26,934.62
20-135000 DUE FROM GENERAL FUND
.00
20-136000 DUE FROM MARINA FUND
.00
TOTAL ASSETS
2,204,362.90
LIABILITIES AND EQUITY
LIABILITIES 20-200000 ACCOUNTS PAYABLE GENERAL
5,042.08
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
264.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
33,214.87
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
38,523.92
FUND EQUITY 20-275000 UNAPPROP. RETAINED EARNINGS
(
20-281000 CIP RESERVE
846,563.80) 800,400.00
20-285000 RET. ERNGS/DWRF 110% DEBT SRVC
.00
20-287000 CONTRIBUTED CAPITAL EQUITY
2,215,142.08
75 % OF THE FISCAL YEAR HAS ELAPSED
16
Page 32 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 WATER FUND
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
3,139.30) (
3,139.30)
TOTAL FUND EQUITY
2,165,838.98
TOTAL LIABILITIES AND EQUITY
2,204,362.90
75 % OF THE FISCAL YEAR HAS ELAPSED
17
Page 33 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
WATER REVENUES 20-344-100 WATER SALES 20-344-110 TAP FEES - CAPITAL 20-344-120 RESALE METERS 20-344-140 INTEREST REVENUE
155.24
391,678.01
494,774.00
103,095.99
79.2
.00
16,466.68
16,467.00
.32
100.0
.00
1,347.57
1,000.00
(
347.57)
134.8
298.59
2,384.04
1,000.00
(
1,384.04)
238.4
20-344-160 MISC. REVENUES
273.84
983.80
.00
(
983.80)
.0
20-344-190 BULK WATER PERMITS
150.00
839.20
700.00
(
139.20)
119.9
.00
.00
270,000.00
270,000.00
.0
TOTAL WATER REVENUES
877.67
413,699.30
783,941.00
370,241.70
52.8
TOTAL FUND REVENUE
877.67
413,699.30
783,941.00
370,241.70
52.8
20-344-910 HYDRO PROJECT FUNDING
75 % OF THE FISCAL YEAR HAS ELAPSED
18
Page 34 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
14,610.40
132,858.95
189,069.00
56,210.05
.00
.00
.00
.00
70.3 .0
1,400.00
13,650.00
18,200.00
4,550.00
75.0
20-430-119 YEAR END LEAVE EXPENSE
.00
.00
15,000.00
15,000.00
.0
20-430-131 LONGEVITY
.00
214.00
2,450.00
2,236.00
8.7
20-430-132 ICMA DEFERRED COMPENSATION
1,070.80
9,726.74
14,086.00
4,359.26
69.1
20-430-133 HEALTH/DENTAL-EMPLOYEE
2,473.14
23,062.25
31,587.00
8,524.75
73.0
2.36
63.04
26,526.00
26,462.96
.2
20-430-136 MEDICAL BENEFIT ALLOWANCE
715.00
2,278.41
3,174.00
895.59
71.8
20-430-141 UNEMPLOYMENT INSURANCE
119.42
418.41
666.00
247.59
62.8
.00
2,979.96
4,251.00
1,271.04
70.1 71.5
20-430-135 DEP HEALTH/DENTAL
20-430-142 WORKER'S COMPENSATION 20-430-143 SOCIAL SECURITY MATCH
1,122.79
9,828.19
13,740.00
3,911.81
20-430-144 MEDICARE MATCH
262.59
2,298.62
3,214.00
915.38
71.5
20-430-210 OFFICE SUPPLIES
.00
709.98
1,500.00
790.02
47.3
20-430-211 COMPUTER SUPPLIES
.00
85.20
.00
20-430-215 COMPUTER SOFTWARE
.00
.00
5,000.00
5,000.00
101.39
101.39
15,000.00
14,898.61
.7
1,237.56
9,079.49
12,000.00
2,920.51
75.7
20-430-220 COMPUTER HARDWARE 20-430-221 CHEMICALS
(
85.20)
.0 .0
20-430-222 LAB SUPPLIES/EQUIPMENT
.00
189.40
1,000.00
810.60
18.9
20-430-223 WELL/PLANT SUPPLIES
.00
588.79
750.00
161.21
78.5
20-430-225 METER PARTS
.00
23.00
1,000.00
977.00
2.3
17.28
209.55
2,500.00
2,290.45
8.4
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-227 SMALL EQUIPMENT/TOOLS
139.67
1,576.01
5,000.00
3,423.99
31.5
20-430-232 VEHICLE MAINTENANCE
20-430-231 GAS/FUEL/FLUIDS
.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
201.68
5,000.00
4,798.32
4.0
20-430-235 TIRES & CHAINS
.00
.00
800.00
800.00
.0
20-430-237 BUILDING MAINTENANCE
.00
731.12
1,000.00
268.88
73.1 30.7
20-430-238 DISTRIBUTION LINE MAINTENANCE
9.98
4,294.74
14,000.00
9,705.26
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
891.74
1,500.00
608.26
59.5
20-430-251 RESALE PARTS
.00
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 40.0
20-430-310 MISC SERVICE FEES
.00
20.00
50.00
30.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
589.78
688.04
900.00
211.96
76.5
20-430-318 TESTING SERVICES
44.5
120.00
2,135.74
4,800.00
2,664.26
20-430-319 MISCELLANEOUS SERVICES
.00
.00
350.00
350.00
.0
20-430-320 TELEMETRY MAINTENANCE
.00
3,317.68
2,500.00
817.68)
132.7
20-430-321 COMPUTER SYSTEM SUPPORT 20-430-341 ELECTRIC UTILITY 20-430-344 TELEPHONE UTILITY 20-430-345 NATURAL GAS UTILITY
(
467.50
4,207.50
7,690.00
3,482.50
2,575.43
24,853.91
29,500.00
4,646.09
54.7 84.3
170.25
1,685.87
2,500.00
814.13
67.4
41.30
2,272.78
5,000.00
2,727.22
45.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
75 % OF THE FISCAL YEAR HAS ELAPSED
19
Page 35 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
310.00
500.00
190.00
62.0
20-430-370 TRAINING/TRAVEL 20-430-513 PROPERTY/CASUALTY INSURANCE 20-430-514 POSITION BONDS
100.0
96.81
416.98
2,000.00
1,583.02
20.9
.00
6,104.61
8,139.00
2,034.39
75.0
.00
100.0
.00
200.00
200.00
5,983.01
71,580.17
.00
20-430-870 CONTINGENCY-OPERATIONS
.00
.00
TOTAL WATER OPERATIONS
33,326.46
338,664.00
20-830-640 DWRF LOAN - PRINCIPAL
.00
.00
.00
.00
.0
20-830-645 DWRF LOAN - INTEREST
.00
.00
.00
.00
.0
20-830-660 CWRPDA LOAN - PRINCIPAL
.00
.00
13,000.00
13,000.00
.0
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
2,425.00
2,425.00
.00
.00
.00
5,000.00
20-430-700 DEPRECIATION RESERVE
(
71,580.17)
.0
1,000.00
1,000.00
.0
520,692.00
182,028.00
65.0
WATER DEBT SERVICE
TOTAL WATER DEBT SERVICE
WATER CAPITAL 20-930-994 SYSTEM UPGRADES 20-930-995 CAPITAL CONTINGENCY
(
2,425.00)
.0
5,000.00
.0
20-930-997 CAPITAL DIRECT PURCHASE
.00
.00
.00
.00
.0
20-930-998 HYDRO POWER GENERATOR
.00
75,749.60
285,000.00
209,250.40
26.6
2,425.00
78,174.60
290,000.00
211,825.40
27.0
35,751.46
416,838.60
826,692.00
409,853.40
50.4
TOTAL WATER CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
(
34,873.79)
(
3,139.30) (
42,751.00) (
39,611.70) (
75 % OF THE FISCAL YEAR HAS ELAPSED
7.3)
20
Page 36 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 MARINA FUND ASSETS 40-100000 CASH IN COMBINED CASH FUND
440,634.91
40-116000 PETTY CASH
.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
(
127,191.01)
TOTAL ASSETS
526,939.93
LIABILITIES AND EQUITY
LIABILITIES 40-200000 ACCOUNTS PAYABLE GENERAL
4,412.78
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
66.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
4,868.43
FUND EQUITY 40-275000 UNAPPROP. RETAINED EARNINGS
358,948.50
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
163,123.00
BALANCE - CURRENT DATE
163,123.00
TOTAL FUND EQUITY
522,071.50
TOTAL LIABILITIES AND EQUITY
526,939.93
75 % OF THE FISCAL YEAR HAS ELAPSED
21
Page 37 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
MARINA REVENUES 40-344-110 BOAT RENTALS
4,305.00
53,340.00
.00
(
53,340.00)
.0
40-344-113 RENTALS (NON-TAXABLE)
12,330.00
149,310.00
135,000.00
(
14,310.00)
110.6
40-344-115 TOURS
10,975.00
70,441.00
60,000.00
(
10,441.00)
117.4
.00
3,300.00
3,300.00
.00
100.0
40-344-120 BUILDING SPACE RENTAL 40-344-140 SEASONAL SLIP RENTALS 40-344-145 KAYAK SLIP RENTAL 40-344-150 DAILY SLIP RENTAL 40-344-160 MISC REVENUE 40-344-170 INTEREST EARNED
.00
12,250.00
12,250.00
.00
100.0
25.00
2,400.00
2,700.00
300.00
88.9
.00
.00
200.00
200.00
.0
502.00
1,724.00
600.00
1,124.00)
287.3
(
54.13
383.69
400.00
16.31
95.9
40-344-180 BOAT DAMAGE
.00
250.00
300.00
50.00
83.3
40-344-190 WINTER STORAGE
.00
.00
.00
.00
.0
13,000.00
17,000.00
14,000.00
3,000.00)
121.4
.00
1,420.00
1,820.00
400.00
78.0
TOTAL MARINA REVENUES
41,191.13
311,818.69
230,570.00
(
81,248.69)
135.2
TOTAL FUND REVENUE
41,191.13
311,818.69
230,570.00
(
81,248.69)
135.2
40-344-200 SALE OF ASSETS 40-344-210 GF TOUR/RENTAL CONTRIBUTIONS
(
75 % OF THE FISCAL YEAR HAS ELAPSED
22
Page 38 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA OPERATIONS 40-460-100 GROSS WAGES - MARINA
837.32
7,877.17
10,090.00
2,212.83
78.1
12,739.41
81,474.46
85,000.00
3,525.54
95.9
40-460-119 ACCRUED LEAVE EXPENSE
.00
.00
1,000.00
1,000.00
.0
40-460-131 LONGEVITY
.00
47.00
72.00
25.00
65.3
40-460-110 GROSS WAGES - MARINA SEASONAL
40-460-132 ICMA DEFERRED COMPENSATION 40-460-133 HEALTH/DENTAL - EMPLOYEE 40-460-135 DEP HEALTH/DENTAL 40-460-136 MEDICAL BENEFIT ALLOWANCE 40-460-141 UNEMPLOYMENT INSURANCE
46.82
460.06
807.00
346.94
57.0
124.54
1,318.41
1,964.00
645.59
67.1
.59
15.75
1,301.00
1,285.25
1.2
18.75
157.76
185.00
27.24
85.3
188.12
295.62
288.00
.00
3,151.08
4,496.00
1,344.92
70.1
40-460-143 SOCIAL SECURITY MATCH
845.23
5,574.88
5,950.00
375.12
93.7
40-460-144 MEDICARE MATCH
40-460-142 WORKERS COMPENSATION
(
7.62)
102.7
197.65
1,303.64
1,392.00
88.36
93.7
40-460-211 GENERAL OFFICE SUPPLIES
.00
625.79
1,000.00
374.21
62.6
40-460-214 SMALL EQUIP/COMP HRDWARE
.00
217.00
450.00
233.00
48.2
40-460-220 COMPUTER HARDWARE
.00
.00
.00
.00
.0
40-460-222 SHOP SUPPLIES
50.32
450.27
2,000.00
1,549.73
22.5
40-460-223 BOAT SUPPLIES
.00
308.36
2,000.00
1,691.64
15.4
40-460-227 TOOLS
.00
.00
500.00
500.00
.0
71.15
3,140.84
5,000.00
1,859.16
62.8
40-460-231 FUEL 40-460-232 VEHICLE MAINTENANCE 40-460-233 EQUIPMENT MAINTENANCE 40-460-237 BUILDING/FACILITY MAINTENANCE 40-460-312 COMPUTER SERVICES
.00
.00
500.00
500.00
.0
289.67
3,195.40
4,000.00
804.60
79.9
24.47
801.41
10,000.00
9,198.59
8.0
112.66
1,013.94
1,352.00
338.06
75.0
40-460-314 ADS AND LEGAL NOTICES
.00
.00
300.00
300.00
.0
40-460-316 DUES/MEMBERSHIPS
.00
275.00
500.00
225.00
55.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
40-460-320 MARKETING
.00
1,115.83
1,000.00
498.52
5,061.64
4,000.00
57.35
375.62
600.00
40-460-342 SEWER UTILITY
.00
279.00
400.00
121.00
69.8
40-460-343 WATER UTILITY
.00
365.00
500.00
135.00
73.0
195.85)
117.8
40-460-330 BANK/CREDIT CARD FEES 40-460-341 ELECTRIC UTILITY
40-460-344 TELEPHONE UTILITY
(
356.00
28.8
(
115.83)
111.6
(
1,061.64)
126.5
224.38
62.6
160.35
1,295.85
1,100.00
40-460-350 BOAT REGISTRATION
.00
347.25
600.00
40-460-351 LICENSES
.00
170.00
165.00
(
5.00)
3,777.00
3,777.00
.00
(
3,777.00)
.00
11.93
500.00
488.07
40-460-360 SALES TAX 40-460-370 TRAINING/TRAVEL
(
252.75
57.9 103.0 .0 2.4
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
163.48
218.00
54.52
75.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
21,478.50
.00
.00
.00
22,426.42
148,695.69
40-460-700 DEPRECIATION RESERVE 40-460-870 CONTINGENCY TOTAL MARINA OPERATIONS
(
21,478.50)
.0
1,000.00
1,000.00
.0
155,958.00
7,262.31
95.3
75 % OF THE FISCAL YEAR HAS ELAPSED
23
Page 39 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
22,426.42
148,695.69
215,958.00
67,262.31
68.9
NET REVENUE OVER EXPENDITURES
18,764.71
163,123.00
14,612.00
TOTAL MARINA CAPITAL
(
148,511.00) 1116.4
75 % OF THE FISCAL YEAR HAS ELAPSED
24
Page 40 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 PAY-AS-YOU-THROW FUND ASSETS 50-100000 CASH IN COMBINED CASH FUND
76,988.96
50-116000 PETTY CASH
50.00
50-117000 ACCOUNTS RECEIVABLE
.00
50-127000 ASSET - BAG INVENTORY
2,890.46
TOTAL ASSETS
79,929.42
LIABILITIES AND EQUITY
LIABILITIES 50-200000 ACCOUNTS PAYABLE GENERAL
1,274.64
50-231000 DUE TO G.F. FROM PAYT
.00
TOTAL LIABILITIES
1,274.64
FUND EQUITY 50-275000 UNAPPROP. RETAINED EARNINGS
63,085.92
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
15,568.86
BALANCE - CURRENT DATE
15,568.86
TOTAL FUND EQUITY
78,654.78
TOTAL LIABILITIES AND EQUITY
79,929.42
75 % OF THE FISCAL YEAR HAS ELAPSED
25
Page 41 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
PAYT REVENUES 50-344-110 BAGS: DIRECT SALES (T)
103.00
1,043.00
1,060.00
17.00
2,772.20
32,779.20
45,400.00
12,620.80
72.2
9.46
85.34
100.00
14.66
85.3
TOTAL PAYT REVENUES
2,884.66
33,907.54
46,560.00
12,652.46
72.8
TOTAL FUND REVENUE
2,884.66
33,907.54
46,560.00
12,652.46
72.8
50-344-115 BAGS: VENDOR PURCHASE (NT) 50-344-140 INTEREST REVENUE
75 % OF THE FISCAL YEAR HAS ELAPSED
98.4
26
Page 42 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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,362.89
14,400.58
20,000.00
5,599.42
72.0
125.00
1,125.00
1,500.00
375.00
75.0
.00
.00
1.00
1.00
.0
16.09
144.81
193.00
48.19
75.0
50-470-300 DUMPSTER SERVICE 50-470-301 RECYCLING CONTRIBUTION 50-470-310 SITE LEASE 50-470-312 COMPUTER SERVICES 50-470-315 SITE MAINTENANCE
.00
.00
2,000.00
50-470-320 BUSINESS LICENSE
.00
170.00
165.00
50-470-330 COMPUTER HARDWARE
23.7
2,000.00
.0
(
5.00)
103.0
.00
.0
(
9.00)
110.7
.00
.00
.00
93.00
93.00
84.00
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,596.98
18,338.68
38,600.00
20,261.32
47.5
TOTAL FUND EXPENDITURES
2,596.98
18,338.68
38,600.00
20,261.32
47.5
287.68
15,568.86
7,960.00
50-470-350 SALES TAX
NET REVENUE OVER EXPENDITURES
(
7,608.86)
195.6
75 % OF THE FISCAL YEAR HAS ELAPSED
27
Page 43 of 45
CASH AND INVESTMENT ACCOUNT BALANCES AT: Combined Cash Grand Mountain Bank Checking Money Market Utility Cash Clearing Combined Cash Totals
$2,789.91 $1,837,302.38 -$23.10 $1,840,069.19
Developer LOC Checking*
$691,021.14
Water Fund
$631,424.18
Marina Fund
PAYT
$440,634.91
$76,988.96
$16,427.47 *Letter of Credit Funds - Restricted Use Non-Interest Bearing Holding Account
CSAFE General Fund Water Fund ColoTrust
General Fund
September 30, 2016
$186,201.50 $62,214.35 $606,906.71
$303,237.86
Gill & Associates
$100,013.00
Advantage Bank CD
$100,140.65
FlatIrons Bank CD $96,000 Principal Interest paid monthly
$303,668.85
$96,000.00
TOTAL
$1,493,041.62
TOTAL CASH/INVESTMENTS AT:
9/30/2016
$997,307.38
$440,634.91
$76,988.96
$3,007,972.87
Page 44 of 45
TOWN OF GRAND LAKE GRAND LAKE CENTER FINANCIAL REPORT FOR SEPTEMBER 30, 2016
2016 Year‐to‐Date Actual
2016 Final Budget
2016 % of Budget
REVENUES 10‐350‐100 10‐350‐110 10‐350‐120 10‐350‐200 10‐350‐701
GL Center ‐ Rental Fees GL Center ‐ Merch Sales GL Center ‐ Memberships GL Center ‐ Donations DOLA REDI Bus Plan Grant
8,520.00 2,214.00 135.00 10,078.50 30,000.00 50,947.50
4,400 0 0 3,000 0 7,400
194% 0% 0% 336% 0% 688%
EXPENDITURES 10‐450‐100 10‐450‐110 10‐450‐141 10‐450‐142 10‐450‐143 10‐450‐144 10‐450‐211 10‐450‐213 10‐450‐220 10‐450‐226 10‐450‐237 10‐450‐318 10‐450‐320 10‐450‐341 10‐450‐342 10‐450‐343 10‐450‐344 10‐450‐345 10‐450‐350 10‐450‐355 10‐450‐360 10‐450‐513 10‐450‐721 10‐450‐755 10‐450‐870
Gross Wages ‐ GL Center Gross Wages‐GL Center Seasonal Unemployment Insurance Worker's Compensation Social Security Match Medicare Match Gen Office Supplies Computer Hardware Operating Supplies Small Equipment Building Maintenance Trash/Recycle Services Marketing Electric Utility Sewer Utility Water Utility Telephone Utility Natural Gas Utility Maintenance Agreement Purchased Professional Serv. Sales Tax Property/Casualty Insurance Donations ‐ out Exercise Equipment Contingency ‐ GL Center
0.00 4,182.00 12.55 0.00 259.29 60.64 2,224.43 1,530.03 1,978.55 0.00 9,705.13 75.00 218.81 4,772.65 1,660.05 851.80 1,234.04 2,690.33 0.00 35,181.00 157.00 3,215.25 2,300.00 4,387.00 2,822.25 79,517.80
0 0 0 0 0 0 2,500 2,500 5,000 1,000 20,000 0 0 10,400 2,213 941 1,200 7,815 8,000 8,000 0 4,287 3,000 0 1,000 77,856
0% 0% 0% 0% 0% 0% 89% 61% 40% 0% 49% 0% 0% 46% 75% 91% 103% 34% 0% 440% 0% 75% 77% 0% 282% 102%
NET REVENUES OVER EXPENDITURES
‐28,570.30
Z:\treasurer\GL Center\ Revenues‐Expenditures
75% OF THE FISCAL YEAR HAS ELAPSED
Page 45 of 45
Page 2 of 45
Page 3 of 45
Page 4 of 45
Page 5 of 45
Page 6 of 45
Page 7 of 45
Page 8 of 45
Page 9 of 45
Page 10 of 45
Page 11 of 45
Page 12 of 45
Page 13 of 45
Page 14 of 45
Page 15 of 45
Page 16 of 45
TOWN OF GRAND LAKE COMBINED CASH INVESTMENT SEPTEMBER 30, 2016 COMBINED CASH ACCOUNTS 01-101000 GMB CHECKING - OPERATIONS
2,789.91
01-105000 GMB MONEY MARKET
1,837,302.38
01-106000 RETURNED CHECK CLEARING ACCT
.00
01-107500 UTILITY CASH CLEARING ACCT
(
23.10)
(
1,840,069.19)
TOTAL COMBINED CASH
1,840,069.19
01-100000 CASH ALLOCATED TO OTHER FUNDS
TOTAL UNALLOCATED CASH
.00
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
691,021.14
20 ALLOCATION TO WATER FUND
631,424.18
40 ALLOCATION TO MARINA FUND
440,634.91
50 ALLOCATION TO PAY-AS-YOU-THROW FUND
76,988.96
TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 01-100000
1,840,069.19 (
1,840,069.19)
ZERO PROOF IF ALLOCATIONS BALANCE
.00
75 % OF THE FISCAL YEAR HAS ELAPSED
1
Page 17 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 GENERAL FUND ASSETS 10-100000 CASH IN COMBINED CASH FUND
691,021.14
10-103000 CSAFE
186,201.50
10-106000 ADVANTAGE BANK - CD
100,140.65
10-109100 COLOTRUST
303,237.86
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
437.40
10-129000 UNLEADED GAS INVENTORY
994.79
10-130000 DIESEL INVENTORY
941.35
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,013.00
TOTAL ASSETS
1,737,272.16
LIABILITIES AND EQUITY
LIABILITIES 10-200000 ACCOUNTS PAYABLE GENERAL
82,219.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
52.68
10-219100 FLEX MEDICAL
1,558.37
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
70,117.17
10-228000 DEVELOPER LOC FUNDS
16,427.47
10-228100 GLC CUSTOMER DEPOSITS
200.00
10-228200 GLC PREPAID RENTAL FEES
3,000.00
10-228300 GLC PREPAID MEMBERSHIPS
405.00
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
428,167.38
75 % OF THE FISCAL YEAR HAS ELAPSED
2
Page 18 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 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
(
5,092.43) (
5,092.43)
TOTAL FUND EQUITY
1,309,104.78
TOTAL LIABILITIES AND EQUITY
1,737,272.16
75 % OF THE FISCAL YEAR HAS ELAPSED
3
Page 19 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
GENERAL TAXES 10-311-100 PROPERTY TAXES
4,219.72
239,853.93
241,557.00
1,703.07
10-311-110 SPECIFIC OWNERSHIP
1,457.06
10,001.56
14,000.00
3,998.44
71.4
158.99
480.26
500.00
19.74
96.1
7,928.31)
139.6
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
(
99.3
3,449.11
27,928.31
20,000.00
275,977.42
662,672.96
1,164,718.00
502,045.04
.00
.00
30,000.00
30,000.00
.0
316.55
2,294.07
3,000.00
705.93
76.5
285,578.85
943,231.09
1,473,775.00
530,543.91
64.0
56.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
3,015.00
4,224.00
1,209.00
71.4
10-316-172 ELECTRIC FRANCHISE 10-316-173 NATURAL GAS FRANCHISE TOTAL UTILITY FRANCHISES
.00
16,680.44
30,000.00
13,319.56
55.6
651.60
7,548.89
14,000.00
6,451.11
53.9
1,656.60
27,244.33
64,224.00
36,979.67
42.4
LICENSES & PERMITS 250.00
6,582.50
2,000.00
4,582.50)
329.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
20.00
415.00
400.00
15.00)
103.8
251.00
1,563.50
2,000.00
436.50
78.2
10.00
255.00
350.00
95.00
72.9
10-321-150 GRADING PERMIT
.00
175.00
50.00
(
125.00)
350.0
10-321-160 ANIMAL LICENSE
.00
140.00
100.00
(
40.00)
140.0
100.00
735.00
300.00
(
435.00)
245.0
5,301.00
29,283.50
29,000.00
(
283.50)
101.0
750.00
32,250.00
30,000.00
(
2,250.00)
107.5
6,682.00
71,399.50
64,200.00
(
7,199.50)
111.2
10-321-120 TOWN SALES TAX LICENSE 10-321-130 MOTOR VEHICLE LICENSE 10-321-140 SIGN PERMIT
10-321-170 ENCROACHMENT PERMIT/LICENSE 10-321-175 BUSINESS LICENSE COMMISSION 10-321-180 NIGHTLY RENTAL LICENSE TOTAL LICENSES & PERMITS
(
(
75 % OF THE FISCAL YEAR HAS ELAPSED
4
Page 20 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
4,752.00
6,336.00
1,584.00
75.0
2,869.03
20,627.57
30,063.00
9,435.43
68.6
540.33
1,960.89
2,000.00
39.11
98.0
3,937.70
3,937.70
4,000.00
62.30
98.4
7,347.06
31,278.16
42,399.00
11,120.84
73.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
.00
.00
50.00
10-341-200 CEMETERY
.00
8,700.00
5,000.00
10-341-201 HEADSTONE DEPOSIT 10-341-300 ZONING & SUBDIVISION REVIEW 10-341-400 ATTAINABLE HOUSING FEE
.0 174.0
.00
2,000.00
1,600.00
(
400.00)
125.0
6,672.36
4,000.00
(
2,672.36)
166.8
(
3,593.50)
118.0
.00
23,593.50
20,000.00
75.65
560.85
1,100.00
10-341-700 COPIES/FAXES/SODA
36.55
62.66
50.00
300.00
1,050.00
1,125.56
TOTAL CHARGES FOR SERVICES
50.00 3,700.00)
713.36
10-341-600 FUEL DEPOT SURCHARGE 10-341-850 NIGHTLY RENTAL APPLICATION FEE
(
539.15
51.0
(
12.66)
125.3
300.00
(
750.00)
350.0
42,639.37
32,100.00
(
10,539.37)
132.8
2,695.00
8,520.00
.00
(
8,520.00)
.0
.00
2,214.00
.00
(
2,214.00)
.0 .0
GRAND LAKE CENTER 10-350-100 GL CENTER - RENTAL FEES 10-350-110 GL CENTER - MERCH SALES 10-350-120 GL CENTER - MEMBERSHIPS
135.00
135.00
.00
(
135.00)
1,707.00
10,078.50
.00
(
10,078.50)
.0
10-350-701 DOLA REDI BUS PLAN GRANT
30,000.00
30,000.00
.00
(
30,000.00)
.0
TOTAL GRAND LAKE CENTER
34,537.00
50,947.50
.00
(
50,947.50)
.0
10-350-200 GL CENTER - DONATIONS
75 % OF THE FISCAL YEAR HAS ELAPSED
5
Page 21 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
FINES 10-351-100 ORDINANCE/TRAFFIC FINES TOTAL FINES
.00
100.00
500.00
400.00
20.0
.00
100.00
500.00
400.00
20.0
409.16
4,357.63
4,000.00
357.63)
108.9
.00
.00
.00
60.00
7,215.00
3,000.00
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
(
.00
.0
4,215.00)
240.5
.00
.00
2.00
2.00
.0
625.00
1,875.00
2,500.00
625.00
75.0
.00
.00
1,200.00
396.75
21,163.90
5,000.00
10-360-210 5% BUSINESS LICENSE FEE
.00
.00
10-360-220 5% NIGHTLY RENTAL LICENSE
.00
.00
10-360-230 MEMORIAL BENCHES
.00
2,060.00
.00
10-360-200 MISC. REVENUES - GENERAL
(
1,200.00
.0
16,163.90)
423.3
.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
1,490.91
36,671.53
32,689.00
10-377-100 CAPITAL LEASE PROCEEDS
.00
.00
10-377-150 CDOT OFF-SYSTEM BRIDGE PROGRAM
.00
.00
10-377-151 W. PORTAL BRIDGE FUNDING
.00
.00
10-377-152 STATE HISTORIC FUND-COMM HOUSE
.00
10-377-153 DOLA ADMIN GRANT
.00
10-377-154 FISHING IS FUN 10-377-155 DOLA TIER 1 GRANT 10-377-156 EV CHARGING STATION 10-377-157 DOLA TIER 1 - W. PORTAL BRIDGE
TOTAL MISCELLANEOUS
(
3,982.53)
112.2
.00
.00
.0
694,080.00
694,080.00
.0
100,000.00
100,000.00
.0
.00
.00
.00
.0
.00
.00
.00
.0
.00
.00
24,000.00
24,000.00
.0
.00
.00
22,000.00
22,000.00
.00
9,760.00
8,260.00
.00
.00
73,520.00
73,520.00
.0
.00
9,760.00
921,860.00
912,100.00
1.1
338,417.98
1,213,271.48
2,641,747.00
1,428,475.52
45.9
CAPITAL SPECIFIC REVENUE
TOTAL CAPITAL SPECIFIC REVENUE
TOTAL FUND REVENUE
(
1,500.00)
.0 118.2
75 % OF THE FISCAL YEAR HAS ELAPSED
6
Page 22 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
CEMETERY COMMITTEE 10-410-211 GENERAL SUPPLIES/MISC EXPENSES
.00
30.45
3,500.00
3,469.55
.9
10-410-215 GRAVE MARKERS
.00
2,220.00
2,600.00
380.00
85.4
10-410-242 GENERAL MAINTENANCE
.00
.00
3,000.00
3,000.00
.0
.00
2,250.45
9,100.00
6,849.55
24.7
TOTAL CEMETERY COMMITTEE
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
TOTAL P.O.S.T. COMMITTEE
PC/BOA 10-412-211 GENERAL OFFICE SUPPLIES
50.30
50.30
1,000.00
949.70
5.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
55.00
100.00
45.00
55.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
14.00
106.07
400.00
293.93
26.5
.00
.00
.00
.00
.0
64.30
211.37
3,300.00
3,088.63
6.4
10-412-370 TRAINING/TRAVEL 10-412-380 COMP PLAN UPDATE TOTAL PC/BOA
75 % OF THE FISCAL YEAR HAS ELAPSED
7
Page 23 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
BOARD OF TRUSTEES 10-413-215 ELECTIONS
.00
579.41
3,500.00
2,920.59
16.6
10-413-316 DUES/MEMBERSHIPS
.00
6,590.85
7,117.00
526.15
92.6
261.38
4,617.77
5,600.00
982.23
82.5
.00
3,000.00
3,000.00
.00
100.0 51.9
10-413-370 TRAINING/TRAVEL 10-413-452 HEADWATER TRAILS ALLIANCE 10-413-460 LONG RANGE/MISC
.00
363.58
700.00
336.42
138.72
669.54
3,500.00
2,830.46
19.1
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-461 APPRECIATION PROGRAM
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
.00
.00
3,500.00
3,500.00
.0
10-413-728 MISCELLANEOUS DONATIONS
.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
.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
1,500.00
1,500.00
1,500.00
.00
100.0
10-413-845 GC RURAL HEALTH NETWORK
.00
1,000.00
1,000.00
.00
100.0
10-413-846 HEART OF THE MTNS HOSPICE
.00
.00
2,500.00
2,500.00
.0
10-413-847 SHINING STARS FOUNDATION
.00
1,340.00
1,500.00
160.00
89.3
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
80.00
80.00
.00
100.0
10-413-852 GRAND ANGELS
.00
4,500.00
4,500.00
.00
100.0
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
1,000.00
1,000.00
1,000.00
.00
100.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-856 GRAND ENTERPRISE INITIATIVE
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
2,900.10
52,184.08
148,353.00
96,168.92
35.2
52.7
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
95.86
790.79
1,500.00
709.21
553.57
4,412.35
5,000.00
587.65
88.3
.00
169.60
500.00
330.40
33.9
.00
.00
500.00
500.00
.0
5,541.17
27,705.85
33,247.00
5,541.15
83.3
10-414-726 MISCELLANEOUS SERVICES
.00
.00
200.00
200.00
.0
10-414-870 CONTINGENCY
.00
.00
250.00
250.00
.0
6,190.60
33,078.59
41,197.00
8,118.41
80.3
TOTAL GREENWAYS COMMITTEE
75 % OF THE FISCAL YEAR HAS ELAPSED
8
Page 24 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
ADMINISTRATION 10-415-100 GROSS WAGES - ADMINISTRATION 10-415-131 LONGEVITY BENEFIT
18,093.80
157,814.09
199,070.00
41,255.91
79.3
.00
919.00
1,138.00
219.00
80.8
10-415-132 ICMA TOWN PAID BENEFIT
1,014.22
9,447.62
15,526.00
6,078.38
60.9
10-415-133 HEALTH/DENTAL-EMPLOYEE
2,525.77
25,724.83
37,352.00
11,627.17
68.9
8.56
233.81
20,209.00
19,975.19
1.2
10-415-136 MEDICAL BENEFIT ALLOWANCE
281.25
2,976.65
3,741.00
764.35
79.6
10-415-141 UNEMPLOYMENT INSURANCE
147.57
478.02
646.00
167.98
74.0
.00
376.83
538.00
161.17
70.0 74.3
10-415-135 DEP HEALTH/DENTAL
10-415-142 WORKER'S COMPENSATION 10-415-143 SOCIAL SECURITY MATCH
1,063.30
9,921.65
13,363.00
3,441.35
10-415-144 MEDICARE MATCH
248.66
2,320.26
3,126.00
805.74
74.2
10-415-211 GENERAL OFFICE SUPPLIES
744.20
4,478.28
3,500.00
978.28)
128.0
(
10-415-215 COMPUTER SOFTWARE
15.98
595.81
5,000.00
4,404.19
11.9
10-415-220 COMPUTER HARDWARE
.00
4,653.10
6,000.00
1,346.90
77.6
10-415-224 COMPUTER SUPPLIES
.00
.00
.00
.00
.0
10-415-226 SMALL EQUIPMENT
165.83
1,492.47
2,000.00
507.53
74.6
10-415-231 GAS/FUEL
180.47
1,146.67
2,400.00
.00
827.96
400.00
10-415-232 VEHICLE MAINTENANCE 10-415-233 OFFICE EQUIPMENT MAINTENANCE
1,253.33
47.8
(
427.96)
207.0
383.51
76.0
(
991.06)
199.1
171.49
1,216.49
1,600.00
1,068.19
1,991.06
1,000.00
10-415-238 TOWN HALL FURNISHINGS
.00
235.48
1,750.00
1,514.52
10-415-252 RESALE SUPPLIES
.00
.00
50.00
50.00
.0
10-415-311 POSTAGE/FREIGHT
1,090.30
4,453.57
4,000.00
453.57)
111.3
10-415-312 COMPUTER SERVICES
1,236.25
10,801.25
14,230.00
10-415-314 ADS & LEGAL NOTICES
238.87
1,942.55
1,000.00
10-415-316 DUES & MEMBERSHIPS
.00
1,070.28
1,500.00
429.72
71.4
10-415-317 BANK FEES
.00
60.00
100.00
40.00
60.0
280.00
2,730.00
3,700.00
970.00
73.8
.00
216.75
250.00
33.25
86.7
276.09
3,077.33
4,200.00
1,122.67
73.3
10-415-342 SEWER UTILITY
.00
725.40
1,000.00
274.60
72.5
10-415-343 WATER UTILITY
.00
919.50
1,500.00
580.50
61.3
10-415-344 TELEPHONE UTILITY
325.46
2,961.28
4,500.00
1,538.72
65.8
10-415-345 NATURAL GAS UTILITY
100.57
1,602.29
3,000.00
1,397.71
53.4
10-415-237 BUILDING MAINTENANCE
10-415-318 JANITORIAL SERVICES 10-415-319 MISCELLANEOUS SERVICES 10-415-341 ELECTRIC UTILITY
10-415-346 INTERNET SERVICES 10-415-347 RECYCLING - TOWN HALL 10-415-351 LEGAL SERVICES 10-415-352 AUDIT 10-415-353 JUDGE-MUNICIPAL COURT 10-415-355 PROFESSIONAL SERVICES-OTHER 10-415-370 TRAINING/TRAVEL 10-415-393 DOCUMENT RECORDING
(
(
13.5
3,428.75 (
(
942.55)
75.9 194.3
.00
675.45
600.00
75.45)
112.6
48.17
375.47
454.00
78.53
82.7
1,868.18
13,748.51
30,500.00
16,751.49
45.1
.00
8,820.00
8,820.00
.00
100.0
450.00
1,350.00
1,800.00
450.00
75.0
38.00)
2,211.00
11,550.00
9,339.00
19.1
339.89
5,823.39
6,000.00
176.61
97.1
.00
.00
500.00
500.00
.0
182.18
766.93
1,000.00
233.07
76.7
10-415-513 PROPERTY/CASUALTY INSURANCE
.00
13,555.91
17,968.00
4,412.09
75.4
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
1,276.14
8,000.00
6,723.86
16.0
10-415-394 DEVELOPER REIMBURSEMENT
10-415-560 TREASURER'S FEES
87.57
4,808.06
4,855.00
46.94
99.0
10-415-721 CHAMBER SERVICE AGREEMENT
8,183.00
24,549.00
32,732.00
8,183.00
75.0
10-415-722 BLC FEE REMITTANCE
7,000.00
21,000.00
28,000.00
7,000.00
75.0
.00
.00
10,500.00
10,500.00
.0
7,500.00
22,500.00
30,000.00
7,500.00
75.0
.00
.00
.00
.00
.0
10-415-723 VISITOR CENTER REPAIRS & MAINT 10-415-724 NRL VC OP 10-415-725 95% NRL ADDTL MKTG
75 % OF THE FISCAL YEAR HAS ELAPSED
9
Page 25 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL 10-415-870 CONTINGENCY - GENERAL ADMIN
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
140.00
565.00
1,000.00
435.00
56.5
.00
.00
1,500.00
1,500.00
.0
55,037.82
379,772.14
553,818.00
174,045.86
68.6
1,500.00
20,148.28
31,164.00
11,015.72
64.7
.00
.00
60.00
60.00
.0
60.00
1,497.98
2,493.00
995.02
60.1
10-421-133 HEALTH/DENTAL-EMPLOYEE
.00
5,951.86
10,207.00
4,255.14
58.3
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
14.39
61.65
101.00
39.35
61.0
.00
313.89
448.00
134.11
70.1
10-421-143 SOCIAL SECURITY MATCH
91.55
1,361.73
2,086.00
724.27
65.3
10-421-144 MEDICARE MATCH
21.41
318.44
488.00
169.56
65.3
10-421-314 DISPATCH OPERATIONS
.00
16,661.00
16,661.00
.00
100.0
10-421-319 MISC PURCHASED SERV
.00
.00
.00
.00
.0
10,150.00
91,350.00
121,800.00
30,450.00
75.0
.00
.00
5,000.00
5,000.00
.0
11,837.35
137,664.83
193,840.00
56,175.17
71.0
10-415-875 MARKETING CONTINGENCY TOTAL ADMINISTRATION
SAFETY 10-421-100 GROSS WAGES - PUBLIC SAFETY 10-421-131 LONGEVITY BENEFIT 10-421-132 ICMA TOWN PAID BENEFIT
10-421-141 UNEMPLOYMENT INSURANCE 10-421-142 WORKER'S COMPENSATION
10-421-339 SHERIFF'S CONTRACT 10-421-340 SPECIAL EVENT SECURITY TOTAL SAFETY
75 % OF THE FISCAL YEAR HAS ELAPSED
10
Page 26 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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 10-431-135 DEP HEALTH/DENTAL 10-431-136 MEDICAL BENEFIT ALLOWANCE 10-431-141 UNEMPLOYMENT INSURANCE 10-431-142 WORKER'S COMPENSATION 10-431-143 SOCIAL SECURITY MATCH
16,334.30
132,792.64
215,661.00
82,868.36
61.6
.00
2,760.00
3,300.00
540.00
83.6
764.30
6,803.70
17,081.00
10,277.30
39.8
2,971.71
25,916.47
45,933.00
20,016.53
56.4
406.68
3,660.12
29,714.00
26,053.88
12.3
.00
1,482.10
4,725.00
3,242.90
31.4
137.18
409.38
700.00
290.62
58.5
.00
5,156.19
7,356.00
2,199.81
70.1 60.7
1,086.12
8,759.09
14,428.00
5,668.91
10-431-144 MEDICARE MATCH
254.04
2,048.75
3,373.00
1,324.25
60.7
10-431-222 GENERAL SUPPLIES
459.03
1,921.43
3,500.00
1,578.57
54.9 17.3
10-431-224 SAFETY SUPPLIES
.00
259.90
1,500.00
1,240.10
10-431-227 SMALL TOOLS
.00
1,050.72
1,500.00
449.28
70.1
10-431-231 GAS/FUEL/LIQUIDS
733.48
8,164.45
20,000.00
11,835.55
40.8
10-431-232 VEHICLE MAINTENANCE
132.08
1,107.13
12,000.00
10,892.87
9.2
.00
6,350.79
25,000.00
18,649.21
25.4 26.7
10-431-233 EQUIPMENT MAINTENANCE 10-431-235 TIRES/CHAINS
1,066.56
1,066.56
4,000.00
2,933.44
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
835.52
3,000.00
2,164.48
27.9
10-431-239 MISCELLANEOUS MAINTENANCE
.00
199.11
250.00
50.89
79.6 50.8
10-431-242 ROAD MAINTENANCE
3,480.83
38,128.49
75,000.00
36,871.51
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
.00
1,129.66
2,250.00
1,120.34
50.2
375.09
4,488.73
6,000.00
1,511.27
74.8
10-431-317 UNIFORM ALLOWANCE 10-431-318 TRASH/RECYCLE SERVICES 10-431-319 MISC. PURCHASED SERVICES 10-431-341 ELECTRIC UTILITY 10-431-343 WATER UTILITY 10-431-344 TELEPHONE UTILITY 10-431-345 NATURAL GAS UTILITY 10-431-349 STREET LIGHT ELECTRIC UTILITY 10-431-354 ENGINEERING/SURVEYING SERVICES
(
.00
.0
840.70)
268.1
.00
475.00
600.00
125.00
79.2
262.92
4,061.81
4,200.00
138.19
96.7
.00
365.00
500.00
235.93
2,118.84
1,950.00
(
135.00
73.0
168.84)
108.7
151.35
2,506.70
5,000.00
2,493.30
1,772.23
16,524.53
24,800.00
8,275.47
66.6
71,700.00
71,700.00
23,000.00
48,700.00)
311.7
(
50.1
10-431-355 CAPITAL IMPROVEMENT PLAN
.00
.00
.00
.00
.0
10-431-370 TRAINING/TRAVEL
.00
77.50
1,000.00
922.50
7.8
10-431-399 EQUIP RENTAL 10-431-870 CONTINGENCY- PUBLIC WORKS TOTAL PUBLIC WORKS
.00
.00
3,000.00
3,000.00
.0
36.60
36.60
500.00
463.40
7.3
102,360.43
354,482.19
577,321.00
222,838.81
61.4
75 % OF THE FISCAL YEAR HAS ELAPSED
11
Page 27 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
GRAND LAKE CENTER 10-450-100 GROSS WAGES - GL CENTER 10-450-110 GROSS WAGES-GL CENTER SEASONAL 10-450-141 UNEMPLOYMENT INSURANCE 10-450-142 WORKER'S COMPENSATION 10-450-143 SOCIAL SECURITY MATCH 10-450-144 MEDICARE MATCH 10-450-211 GEN OFFICE SUPPLIES 10-450-213 COMPUTER HARDWARE 10-450-220 OPERATING SUPPLIES 10-450-237 BUILDING MAINTENANCE 10-450-318 TRASH/RECYCLE SERVICES 10-450-320 MARKETING 10-450-341 ELECTRIC UTILITY 10-450-342 SEWER UTILITY 10-450-343 WATER UTILITY 10-450-344 TELEPHONE UTILITY 10-450-345 NATURAL GAS UTILITY 10-450-355 PURCHASED PROFESSIONAL SERV. 10-450-360 SALES TAX 10-450-513 PROPERTY/CASUALTY INSURANCE 10-450-721 DONATIONS - OUT
.00
.00
.00
.00
.0
1,620.00
4,182.00
.00
(
4,182.00)
.0
12.55
12.55
.00
(
12.55)
.0
.00
.00
.00
.00
.0
100.44
259.29
.00
(
259.29)
.0
23.49
60.64
.00
(
60.64)
.0
601.69
2,224.43
.00
(
2,224.43)
.0
.00
1,530.03
.00
(
1,530.03)
.0
1,958.42
1,978.55
.00
(
1,978.55)
.0
146.40
9,705.13
.00
(
9,705.13)
.0
75.00
75.00
.00
(
75.00)
.0 .0
.00
218.81
.00
(
218.81)
444.76
4,772.65
.00
(
4,772.65)
.0
.00
1,660.05
.00
(
1,660.05)
.0
.00
851.80
.00
(
851.80)
.0
207.97
1,234.04
.00
(
1,234.04)
.0
72.78
2,690.33
.00
(
2,690.33)
.0
35,181.00
35,181.00
.00
(
35,181.00)
.0
157.00
157.00
.00
(
157.00)
.0
.00
3,215.25
.00
(
3,215.25)
.0
.00
2,300.00
.00
(
2,300.00)
.0
10-450-755 EXERCISE EQUIPMENT
980.00
4,387.00
.00
(
4,387.00)
.0
10-450-870 CONTINGENCY - GL CENTER
102.69
2,822.25
.00
(
2,822.25)
.0
41,684.19
79,517.80
.00
(
79,517.80)
.0
TOTAL GRAND LAKE CENTER
75 % OF THE FISCAL YEAR HAS ELAPSED
12
Page 28 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS 10-452-100 GROSS WAGES - PARKS 10-452-110 GROSS WAGES-PARKS SEASONAL 10-452-131 LONGEVITY
1,913.58
17,222.22
23,392.00
6,169.78
73.6
.00
1,511.25
8,460.00
6,948.75
17.9
.00
600.00
600.00
.00
100.0
76.54
688.86
1,827.00
1,138.14
37.7
10-452-133 HEALTH/DENTAL-EMPLOYEE
424.69
3,825.31
5,104.00
1,278.69
75.0
10-452-135 DEP. HEALTH/DENTAL
406.67
3,660.03
4,880.00
1,219.97
75.0 29.4
10-452-132 ICMA DEFERRED COMPENSATION
10-452-136 MEDICAL BENEFIT ALLOWANCE
.00
154.29
525.00
370.71
21.12
62.55
101.00
38.45
61.9
.00
655.80
936.00
280.20
70.1
162.54
1,330.57
2,088.00
757.43
63.7
38.01
311.16
489.00
177.84
63.6
1,434.39
11,277.10
14,000.00
2,722.90
80.6
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
442.80
1,600.00
1,157.20
27.7 32.3
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-234 INFORMATION SIGNS 10-452-235 GREENBELT MAINTENANCE 10-452-236 SAND & DREDGE 10-452-237 BUILDING MAINTENANCE 10-452-238 ADA DOCK MAINTENANCE 10-452-239 MISCELLANEOUS MAINTENANCE
.00
2,102.00
6,500.00
4,398.00
1,468.50
1,839.20
5,000.00
3,160.80
.00
877.07
500.00
2,392.63
3,299.24
6,300.00
.00
2,598.92
36.8
(
377.07)
175.4
3,000.76
52.4
1,000.00
(
1,598.92)
259.9
(
4,442.76) 1877.1
.00
4,692.76
250.00
4.29
23.57
1,000.00
976.43
10-452-244 THOMASSON PARK MAINTENANCE
.00
.00
500.00
500.00
.0
10-452-246 ICE RINK/VOLLEYBALL COURT
.00
98.40
1,500.00
1,401.60
6.6
10-452-248 IRRIGATION SYSTEM MAINTENANCE
.00
421.20
2,000.00
1,578.80
21.1
10-452-319 MISCELLANEOUS SERVICES
.00
990.00
.00
461.08
5,005.23
6,700.00
10-452-243 BENCHES/PLANTERS/FENCES
10-452-341 ELECTRIC UTILITY
(
2.4
990.00)
.0
1,694.77
74.7
10-452-342 SEWER UTILITY
.00
320.85
450.00
129.15
71.3
10-452-343 WATER UTILITY
.00
5,660.10
9,500.00
3,839.90
59.6 59.0
174.76
2,063.84
3,500.00
1,436.16
10-452-350 GLE UTILITIES
10-452-345 NATURAL GAS UTILITY
.00
.00
.00
.00
.0
10-452-399 EQUIPMENT RENTAL
.00
1,245.25
1,000.00
245.25)
124.5
10-452-400 GRAND AVENUE GARDENS
.00
180.00
2,000.00
1,820.00
9.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
8,978.80
73,159.57
119,102.00
45,942.43
61.4
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,984.98
7,351.28
12,002.00
4,650.72
61.3
10-815-983 LAND ACQUISITION-INTEREST
3,483.76
12,054.94
13,873.00
1,818.06
86.9
6,468.74
20,731.17
113,961.00
93,229.83
18.2
TOTAL ADMIN DEBT SERVICE
75 % OF THE FISCAL YEAR HAS ELAPSED
13
Page 29 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PUBLIC WORKS DEBT SERVICE 10-831-500 CAPITAL EQUIP LEASE PRINCIPAL
974.32
8,667.82
11,608.00
2,940.18
74.7
10-831-510 EQUIPMENT LEASE INTEREST
362.83
3,366.53
4,438.00
1,071.47
75.9
1,337.15
12,034.35
16,046.00
4,011.65
75.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
.00
.00
.00
.00
.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
.00
.00
16,987.00
10-931-910 CAPITAL EQUIPMENT PURCHASE
.00
12,875.68
11,500.00
10-931-911 CAPITALIZED EQUIPMENT REPAIR 10-931-921 PAVING
(
16,987.00
.0
1,375.68)
112.0
.00
.00
.00
.00
.0
25,000.00
25,000.00
25,000.00
.00
100.0 .0
10-931-922 DRAINAGE
.00
.00
20,000.00
20,000.00
10-931-971 LEASE PURCHASE CAPITAL
.00
.00
.00
.00
.0
21,229.01
30,076.05
867,600.00
837,523.95
3.5
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
46,229.01
67,951.73
985,087.00
917,135.27
6.9
.00
.00
.00
.00
.0
.00
.00
.00
.00
.0
10-931-972 W PORTAL BRIDGE REHAB
TOTAL PUBLIC WORKS CAPITAL
GL CENTER CAPITAL 10-950-700 PROPERTY/BUILDINGS TOTAL GL CENTER CAPITAL
75 % OF THE FISCAL YEAR HAS ELAPSED
14
Page 30 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 GENERAL FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
PARKS CAPITAL 10-952-500 ADA DOCKS
.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
.00
5,325.64
112,000.00
106,674.36
4.8
283,088.49
1,218,363.91
2,873,125.00
1,654,761.09
42.4
TOTAL PARKS CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
55,329.49
(
5,092.43) (
231,378.00)
(
226,285.57)
(
75 % OF THE FISCAL YEAR HAS ELAPSED
2.2)
15
Page 31 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 WATER FUND ASSETS 20-100000 CASH IN COMBINED CASH FUND
631,424.18
20-102000 CSAFE
62,214.35
20-109100 COLOTRUST
303,668.85
20-116000 PETTY CASH
.00
20-117000 ACCTS RECEIVABLE/WATER SALES
4,609.26
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,241,521.95) 26,934.62
20-135000 DUE FROM GENERAL FUND
.00
20-136000 DUE FROM MARINA FUND
.00
TOTAL ASSETS
2,204,362.90
LIABILITIES AND EQUITY
LIABILITIES 20-200000 ACCOUNTS PAYABLE GENERAL
5,042.08
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
264.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
33,214.87
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
38,523.92
FUND EQUITY 20-275000 UNAPPROP. RETAINED EARNINGS
(
20-281000 CIP RESERVE
846,563.80) 800,400.00
20-285000 RET. ERNGS/DWRF 110% DEBT SRVC
.00
20-287000 CONTRIBUTED CAPITAL EQUITY
2,215,142.08
75 % OF THE FISCAL YEAR HAS ELAPSED
16
Page 32 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 WATER FUND
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
3,139.30) (
3,139.30)
TOTAL FUND EQUITY
2,165,838.98
TOTAL LIABILITIES AND EQUITY
2,204,362.90
75 % OF THE FISCAL YEAR HAS ELAPSED
17
Page 33 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 WATER FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
WATER REVENUES 20-344-100 WATER SALES 20-344-110 TAP FEES - CAPITAL 20-344-120 RESALE METERS 20-344-140 INTEREST REVENUE
155.24
391,678.01
494,774.00
103,095.99
79.2
.00
16,466.68
16,467.00
.32
100.0
.00
1,347.57
1,000.00
(
347.57)
134.8
298.59
2,384.04
1,000.00
(
1,384.04)
238.4
20-344-160 MISC. REVENUES
273.84
983.80
.00
(
983.80)
.0
20-344-190 BULK WATER PERMITS
150.00
839.20
700.00
(
139.20)
119.9
.00
.00
270,000.00
270,000.00
.0
TOTAL WATER REVENUES
877.67
413,699.30
783,941.00
370,241.70
52.8
TOTAL FUND REVENUE
877.67
413,699.30
783,941.00
370,241.70
52.8
20-344-910 HYDRO PROJECT FUNDING
75 % OF THE FISCAL YEAR HAS ELAPSED
18
Page 34 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
14,610.40
132,858.95
189,069.00
56,210.05
.00
.00
.00
.00
70.3 .0
1,400.00
13,650.00
18,200.00
4,550.00
75.0
20-430-119 YEAR END LEAVE EXPENSE
.00
.00
15,000.00
15,000.00
.0
20-430-131 LONGEVITY
.00
214.00
2,450.00
2,236.00
8.7
20-430-132 ICMA DEFERRED COMPENSATION
1,070.80
9,726.74
14,086.00
4,359.26
69.1
20-430-133 HEALTH/DENTAL-EMPLOYEE
2,473.14
23,062.25
31,587.00
8,524.75
73.0
2.36
63.04
26,526.00
26,462.96
.2
20-430-136 MEDICAL BENEFIT ALLOWANCE
715.00
2,278.41
3,174.00
895.59
71.8
20-430-141 UNEMPLOYMENT INSURANCE
119.42
418.41
666.00
247.59
62.8
.00
2,979.96
4,251.00
1,271.04
70.1 71.5
20-430-135 DEP HEALTH/DENTAL
20-430-142 WORKER'S COMPENSATION 20-430-143 SOCIAL SECURITY MATCH
1,122.79
9,828.19
13,740.00
3,911.81
20-430-144 MEDICARE MATCH
262.59
2,298.62
3,214.00
915.38
71.5
20-430-210 OFFICE SUPPLIES
.00
709.98
1,500.00
790.02
47.3
20-430-211 COMPUTER SUPPLIES
.00
85.20
.00
20-430-215 COMPUTER SOFTWARE
.00
.00
5,000.00
5,000.00
101.39
101.39
15,000.00
14,898.61
.7
1,237.56
9,079.49
12,000.00
2,920.51
75.7
20-430-220 COMPUTER HARDWARE 20-430-221 CHEMICALS
(
85.20)
.0 .0
20-430-222 LAB SUPPLIES/EQUIPMENT
.00
189.40
1,000.00
810.60
18.9
20-430-223 WELL/PLANT SUPPLIES
.00
588.79
750.00
161.21
78.5
20-430-225 METER PARTS
.00
23.00
1,000.00
977.00
2.3
17.28
209.55
2,500.00
2,290.45
8.4
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-227 SMALL EQUIPMENT/TOOLS
139.67
1,576.01
5,000.00
3,423.99
31.5
20-430-232 VEHICLE MAINTENANCE
20-430-231 GAS/FUEL/FLUIDS
.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
201.68
5,000.00
4,798.32
4.0
20-430-235 TIRES & CHAINS
.00
.00
800.00
800.00
.0
20-430-237 BUILDING MAINTENANCE
.00
731.12
1,000.00
268.88
73.1 30.7
20-430-238 DISTRIBUTION LINE MAINTENANCE
9.98
4,294.74
14,000.00
9,705.26
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
891.74
1,500.00
608.26
59.5
20-430-251 RESALE PARTS
.00
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 40.0
20-430-310 MISC SERVICE FEES
.00
20.00
50.00
30.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
589.78
688.04
900.00
211.96
76.5
20-430-318 TESTING SERVICES
44.5
120.00
2,135.74
4,800.00
2,664.26
20-430-319 MISCELLANEOUS SERVICES
.00
.00
350.00
350.00
.0
20-430-320 TELEMETRY MAINTENANCE
.00
3,317.68
2,500.00
817.68)
132.7
20-430-321 COMPUTER SYSTEM SUPPORT 20-430-341 ELECTRIC UTILITY 20-430-344 TELEPHONE UTILITY 20-430-345 NATURAL GAS UTILITY
(
467.50
4,207.50
7,690.00
3,482.50
2,575.43
24,853.91
29,500.00
4,646.09
54.7 84.3
170.25
1,685.87
2,500.00
814.13
67.4
41.30
2,272.78
5,000.00
2,727.22
45.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
75 % OF THE FISCAL YEAR HAS ELAPSED
19
Page 35 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
310.00
500.00
190.00
62.0
20-430-370 TRAINING/TRAVEL 20-430-513 PROPERTY/CASUALTY INSURANCE 20-430-514 POSITION BONDS
100.0
96.81
416.98
2,000.00
1,583.02
20.9
.00
6,104.61
8,139.00
2,034.39
75.0
.00
100.0
.00
200.00
200.00
5,983.01
71,580.17
.00
20-430-870 CONTINGENCY-OPERATIONS
.00
.00
TOTAL WATER OPERATIONS
33,326.46
338,664.00
20-830-640 DWRF LOAN - PRINCIPAL
.00
.00
.00
.00
.0
20-830-645 DWRF LOAN - INTEREST
.00
.00
.00
.00
.0
20-830-660 CWRPDA LOAN - PRINCIPAL
.00
.00
13,000.00
13,000.00
.0
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
2,425.00
2,425.00
.00
.00
.00
5,000.00
20-430-700 DEPRECIATION RESERVE
(
71,580.17)
.0
1,000.00
1,000.00
.0
520,692.00
182,028.00
65.0
WATER DEBT SERVICE
TOTAL WATER DEBT SERVICE
WATER CAPITAL 20-930-994 SYSTEM UPGRADES 20-930-995 CAPITAL CONTINGENCY
(
2,425.00)
.0
5,000.00
.0
20-930-997 CAPITAL DIRECT PURCHASE
.00
.00
.00
.00
.0
20-930-998 HYDRO POWER GENERATOR
.00
75,749.60
285,000.00
209,250.40
26.6
2,425.00
78,174.60
290,000.00
211,825.40
27.0
35,751.46
416,838.60
826,692.00
409,853.40
50.4
TOTAL WATER CAPITAL
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
(
34,873.79)
(
3,139.30) (
42,751.00) (
39,611.70) (
75 % OF THE FISCAL YEAR HAS ELAPSED
7.3)
20
Page 36 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 MARINA FUND ASSETS 40-100000 CASH IN COMBINED CASH FUND
440,634.91
40-116000 PETTY CASH
.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
(
127,191.01)
TOTAL ASSETS
526,939.93
LIABILITIES AND EQUITY
LIABILITIES 40-200000 ACCOUNTS PAYABLE GENERAL
4,412.78
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
66.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
4,868.43
FUND EQUITY 40-275000 UNAPPROP. RETAINED EARNINGS
358,948.50
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
163,123.00
BALANCE - CURRENT DATE
163,123.00
TOTAL FUND EQUITY
522,071.50
TOTAL LIABILITIES AND EQUITY
526,939.93
75 % OF THE FISCAL YEAR HAS ELAPSED
21
Page 37 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
MARINA REVENUES 40-344-110 BOAT RENTALS
4,305.00
53,340.00
.00
(
53,340.00)
.0
40-344-113 RENTALS (NON-TAXABLE)
12,330.00
149,310.00
135,000.00
(
14,310.00)
110.6
40-344-115 TOURS
10,975.00
70,441.00
60,000.00
(
10,441.00)
117.4
.00
3,300.00
3,300.00
.00
100.0
40-344-120 BUILDING SPACE RENTAL 40-344-140 SEASONAL SLIP RENTALS 40-344-145 KAYAK SLIP RENTAL 40-344-150 DAILY SLIP RENTAL 40-344-160 MISC REVENUE 40-344-170 INTEREST EARNED
.00
12,250.00
12,250.00
.00
100.0
25.00
2,400.00
2,700.00
300.00
88.9
.00
.00
200.00
200.00
.0
502.00
1,724.00
600.00
1,124.00)
287.3
(
54.13
383.69
400.00
16.31
95.9
40-344-180 BOAT DAMAGE
.00
250.00
300.00
50.00
83.3
40-344-190 WINTER STORAGE
.00
.00
.00
.00
.0
13,000.00
17,000.00
14,000.00
3,000.00)
121.4
.00
1,420.00
1,820.00
400.00
78.0
TOTAL MARINA REVENUES
41,191.13
311,818.69
230,570.00
(
81,248.69)
135.2
TOTAL FUND REVENUE
41,191.13
311,818.69
230,570.00
(
81,248.69)
135.2
40-344-200 SALE OF ASSETS 40-344-210 GF TOUR/RENTAL CONTRIBUTIONS
(
75 % OF THE FISCAL YEAR HAS ELAPSED
22
Page 38 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 MARINA FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEXPENDED
PCNT
MARINA OPERATIONS 40-460-100 GROSS WAGES - MARINA
837.32
7,877.17
10,090.00
2,212.83
78.1
12,739.41
81,474.46
85,000.00
3,525.54
95.9
40-460-119 ACCRUED LEAVE EXPENSE
.00
.00
1,000.00
1,000.00
.0
40-460-131 LONGEVITY
.00
47.00
72.00
25.00
65.3
40-460-110 GROSS WAGES - MARINA SEASONAL
40-460-132 ICMA DEFERRED COMPENSATION 40-460-133 HEALTH/DENTAL - EMPLOYEE 40-460-135 DEP HEALTH/DENTAL 40-460-136 MEDICAL BENEFIT ALLOWANCE 40-460-141 UNEMPLOYMENT INSURANCE
46.82
460.06
807.00
346.94
57.0
124.54
1,318.41
1,964.00
645.59
67.1
.59
15.75
1,301.00
1,285.25
1.2
18.75
157.76
185.00
27.24
85.3
188.12
295.62
288.00
.00
3,151.08
4,496.00
1,344.92
70.1
40-460-143 SOCIAL SECURITY MATCH
845.23
5,574.88
5,950.00
375.12
93.7
40-460-144 MEDICARE MATCH
40-460-142 WORKERS COMPENSATION
(
7.62)
102.7
197.65
1,303.64
1,392.00
88.36
93.7
40-460-211 GENERAL OFFICE SUPPLIES
.00
625.79
1,000.00
374.21
62.6
40-460-214 SMALL EQUIP/COMP HRDWARE
.00
217.00
450.00
233.00
48.2
40-460-220 COMPUTER HARDWARE
.00
.00
.00
.00
.0
40-460-222 SHOP SUPPLIES
50.32
450.27
2,000.00
1,549.73
22.5
40-460-223 BOAT SUPPLIES
.00
308.36
2,000.00
1,691.64
15.4
40-460-227 TOOLS
.00
.00
500.00
500.00
.0
71.15
3,140.84
5,000.00
1,859.16
62.8
40-460-231 FUEL 40-460-232 VEHICLE MAINTENANCE 40-460-233 EQUIPMENT MAINTENANCE 40-460-237 BUILDING/FACILITY MAINTENANCE 40-460-312 COMPUTER SERVICES
.00
.00
500.00
500.00
.0
289.67
3,195.40
4,000.00
804.60
79.9
24.47
801.41
10,000.00
9,198.59
8.0
112.66
1,013.94
1,352.00
338.06
75.0
40-460-314 ADS AND LEGAL NOTICES
.00
.00
300.00
300.00
.0
40-460-316 DUES/MEMBERSHIPS
.00
275.00
500.00
225.00
55.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
40-460-320 MARKETING
.00
1,115.83
1,000.00
498.52
5,061.64
4,000.00
57.35
375.62
600.00
40-460-342 SEWER UTILITY
.00
279.00
400.00
121.00
69.8
40-460-343 WATER UTILITY
.00
365.00
500.00
135.00
73.0
195.85)
117.8
40-460-330 BANK/CREDIT CARD FEES 40-460-341 ELECTRIC UTILITY
40-460-344 TELEPHONE UTILITY
(
356.00
28.8
(
115.83)
111.6
(
1,061.64)
126.5
224.38
62.6
160.35
1,295.85
1,100.00
40-460-350 BOAT REGISTRATION
.00
347.25
600.00
40-460-351 LICENSES
.00
170.00
165.00
(
5.00)
3,777.00
3,777.00
.00
(
3,777.00)
.00
11.93
500.00
488.07
40-460-360 SALES TAX 40-460-370 TRAINING/TRAVEL
(
252.75
57.9 103.0 .0 2.4
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
163.48
218.00
54.52
75.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
21,478.50
.00
.00
.00
22,426.42
148,695.69
40-460-700 DEPRECIATION RESERVE 40-460-870 CONTINGENCY TOTAL MARINA OPERATIONS
(
21,478.50)
.0
1,000.00
1,000.00
.0
155,958.00
7,262.31
95.3
75 % OF THE FISCAL YEAR HAS ELAPSED
23
Page 39 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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
22,426.42
148,695.69
215,958.00
67,262.31
68.9
NET REVENUE OVER EXPENDITURES
18,764.71
163,123.00
14,612.00
TOTAL MARINA CAPITAL
(
148,511.00) 1116.4
75 % OF THE FISCAL YEAR HAS ELAPSED
24
Page 40 of 45
TOWN OF GRAND LAKE BALANCE SHEET SEPTEMBER 30, 2016 PAY-AS-YOU-THROW FUND ASSETS 50-100000 CASH IN COMBINED CASH FUND
76,988.96
50-116000 PETTY CASH
50.00
50-117000 ACCOUNTS RECEIVABLE
.00
50-127000 ASSET - BAG INVENTORY
2,890.46
TOTAL ASSETS
79,929.42
LIABILITIES AND EQUITY
LIABILITIES 50-200000 ACCOUNTS PAYABLE GENERAL
1,274.64
50-231000 DUE TO G.F. FROM PAYT
.00
TOTAL LIABILITIES
1,274.64
FUND EQUITY 50-275000 UNAPPROP. RETAINED EARNINGS
63,085.92
UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD
15,568.86
BALANCE - CURRENT DATE
15,568.86
TOTAL FUND EQUITY
78,654.78
TOTAL LIABILITIES AND EQUITY
79,929.42
75 % OF THE FISCAL YEAR HAS ELAPSED
25
Page 41 of 45
TOWN OF GRAND LAKE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2016 PAY-AS-YOU-THROW FUND PERIOD ACTUAL
YTD ACTUAL
BUDGET
UNEARNED
PCNT
PAYT REVENUES 50-344-110 BAGS: DIRECT SALES (T)
103.00
1,043.00
1,060.00
17.00
2,772.20
32,779.20
45,400.00
12,620.80
72.2
9.46
85.34
100.00
14.66
85.3
TOTAL PAYT REVENUES
2,884.66
33,907.54
46,560.00
12,652.46
72.8
TOTAL FUND REVENUE
2,884.66
33,907.54
46,560.00
12,652.46
72.8
50-344-115 BAGS: VENDOR PURCHASE (NT) 50-344-140 INTEREST REVENUE
75 % OF THE FISCAL YEAR HAS ELAPSED
98.4
26
Page 42 of 45
TOWN OF GRAND LAKE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING SEPTEMBER 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,362.89
14,400.58
20,000.00
5,599.42
72.0
125.00
1,125.00
1,500.00
375.00
75.0
.00
.00
1.00
1.00
.0
16.09
144.81
193.00
48.19
75.0
50-470-300 DUMPSTER SERVICE 50-470-301 RECYCLING CONTRIBUTION 50-470-310 SITE LEASE 50-470-312 COMPUTER SERVICES 50-470-315 SITE MAINTENANCE
.00
.00
2,000.00
50-470-320 BUSINESS LICENSE
.00
170.00
165.00
50-470-330 COMPUTER HARDWARE
23.7
2,000.00
.0
(
5.00)
103.0
.00
.0
(
9.00)
110.7
.00
.00
.00
93.00
93.00
84.00
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,596.98
18,338.68
38,600.00
20,261.32
47.5
TOTAL FUND EXPENDITURES
2,596.98
18,338.68
38,600.00
20,261.32
47.5
287.68
15,568.86
7,960.00
50-470-350 SALES TAX
NET REVENUE OVER EXPENDITURES
(
7,608.86)
195.6
75 % OF THE FISCAL YEAR HAS ELAPSED
27
Page 43 of 45
CASH AND INVESTMENT ACCOUNT BALANCES AT: Combined Cash Grand Mountain Bank Checking Money Market Utility Cash Clearing Combined Cash Totals
$2,789.91 $1,837,302.38 -$23.10 $1,840,069.19
Developer LOC Checking*
$691,021.14
Water Fund
$631,424.18
Marina Fund
PAYT
$440,634.91
$76,988.96
$16,427.47 *Letter of Credit Funds - Restricted Use Non-Interest Bearing Holding Account
CSAFE General Fund Water Fund ColoTrust
General Fund
September 30, 2016
$186,201.50 $62,214.35 $606,906.71
$303,237.86
Gill & Associates
$100,013.00
Advantage Bank CD
$100,140.65
FlatIrons Bank CD $96,000 Principal Interest paid monthly
$303,668.85
$96,000.00
TOTAL
$1,493,041.62
TOTAL CASH/INVESTMENTS AT:
9/30/2016
$997,307.38
$440,634.91
$76,988.96
$3,007,972.87
Page 44 of 45
TOWN OF GRAND LAKE GRAND LAKE CENTER FINANCIAL REPORT FOR SEPTEMBER 30, 2016
2016 Year‐to‐Date Actual
2016 Final Budget
2016 % of Budget
REVENUES 10‐350‐100 10‐350‐110 10‐350‐120 10‐350‐200 10‐350‐701
GL Center ‐ Rental Fees GL Center ‐ Merch Sales GL Center ‐ Memberships GL Center ‐ Donations DOLA REDI Bus Plan Grant
8,520.00 2,214.00 135.00 10,078.50 30,000.00 50,947.50
4,400 0 0 3,000 0 7,400
194% 0% 0% 336% 0% 688%
EXPENDITURES 10‐450‐100 10‐450‐110 10‐450‐141 10‐450‐142 10‐450‐143 10‐450‐144 10‐450‐211 10‐450‐213 10‐450‐220 10‐450‐226 10‐450‐237 10‐450‐318 10‐450‐320 10‐450‐341 10‐450‐342 10‐450‐343 10‐450‐344 10‐450‐345 10‐450‐350 10‐450‐355 10‐450‐360 10‐450‐513 10‐450‐721 10‐450‐755 10‐450‐870
Gross Wages ‐ GL Center Gross Wages‐GL Center Seasonal Unemployment Insurance Worker's Compensation Social Security Match Medicare Match Gen Office Supplies Computer Hardware Operating Supplies Small Equipment Building Maintenance Trash/Recycle Services Marketing Electric Utility Sewer Utility Water Utility Telephone Utility Natural Gas Utility Maintenance Agreement Purchased Professional Serv. Sales Tax Property/Casualty Insurance Donations ‐ out Exercise Equipment Contingency ‐ GL Center
0.00 4,182.00 12.55 0.00 259.29 60.64 2,224.43 1,530.03 1,978.55 0.00 9,705.13 75.00 218.81 4,772.65 1,660.05 851.80 1,234.04 2,690.33 0.00 35,181.00 157.00 3,215.25 2,300.00 4,387.00 2,822.25 79,517.80
0 0 0 0 0 0 2,500 2,500 5,000 1,000 20,000 0 0 10,400 2,213 941 1,200 7,815 8,000 8,000 0 4,287 3,000 0 1,000 77,856
0% 0% 0% 0% 0% 0% 89% 61% 40% 0% 49% 0% 0% 46% 75% 91% 103% 34% 0% 440% 0% 75% 77% 0% 282% 102%
NET REVENUES OVER EXPENDITURES
‐28,570.30
Z:\treasurer\GL Center\ Revenues‐Expenditures
75% OF THE FISCAL YEAR HAS ELAPSED
Page 45 of 45
