HomeMy Public PortalAboutSKM_308e21021212330 BUDGET STATUS rev. 1/31/21
FY 2021 FY 2020
%of %of
Expended thru Budget Expended thru I Budget
WAGES January Bud et Balance Spent January Budget Balance I Span
Full-time Maintenance $ 326,621.19 $ 595,164.00 $ 268,542.81 54.9% $ 352,031.23 $ 616,957.00 $ 264,925.77 57.1%
Part-time Maintenance $ 168,938.44 $ 305,271.00 $ 136,332.56 163.31%
66,482.83 $ 301,767.00 $ 135,284.17 55.2%
Full-time Administrative $ 174,962.05 $ 276,534.00 $ 101,571.95 45,398.15 $ 253,962.00 $ 108,563.85 57.3%
Part-time Administrative $ 141,163.10'$ 198,536.00 $ 5737290 27,607.84 $ 209,623.00 $ 82,015.16 60.9%
Overtime $ 38,528.62'$ 47,638.00 $ 9,109.38 30,842.28 $ 47,638.00 $ 16,795.72 64.7%
Longevity $ 6,600.00 $ 18,072.00 $ 11,472.00 6,150.00 $ 17,206.00 $ 11056.00 35.7Contractual Obligations $ 22,351.99. $ 42,208.00 $ 19,856.01 $ $ #DIV/0!
SUBTOTAL $ 879,165.39 J $1,483,423.00: $ 604,257.61 59.3% $ 828,512.33 $1,447,153.00 616640.67 57.3%
GENERAL EXPENSES_
Clothing-Maintenance $ 4,890.10 $ 8,500.00 $ 3,609.90 57.5% $ 5,033.05 $ 8,500.00 $ 3,466.95 59.2%
Cloth! -Administrative $ $ 2,000.00 $ 2,000.00 j 0.0% $ $ 2,000.00 $ 2,000.00 0.0%
Oil/Grease-Maintenance $ $ 3,000.00 $ 3,000.00 0.0% $ 1,228.42 $ 3,000.00 $ 1,771.58 40.9%
Diesel Fuel $ 4,985.07 $ 10,000.00 $ 5,014.93 1 49.9%1 $ 9,514.97 $ 13,500.00 $ 3,985.03 70.5%
Heating-Maintenance $ 580.44 $ 3,000.00 $ 2,419.56 19.3% $ 773.04 $ 3,000.00 $ 2,226.96 25.8%
Heating-Clubhouse $ 3,711.87 $ 11,000.00 $ 7,288.13 33.7% $ 4,748.49 $ 11,000.00 $ _6,251.51 43.2%
Gasoline-Maintenance $ 3,516.97 $ 8,500.00 $ 4,983.03 41.4% $ 7,913,77 $ 11,500.00 $ 3,586.23 68.8%
Electricity-Maintenance $$ 3,237.58 $ 6,000.00_$ 2,762.42 54.0% $ 1,997.77 $ 6,000.00 $ 4,002.23 33.3%
Electricity-Clubhouse $ 23,603.23 $ 36,000.00 $ 12,396.77 65.6% $ 25,702.76 $ 36,000.00 $ 10,297.24 71.4%
Electriciiy_Imigation $ 16,264.14 $ 22,000.00 $ 5,735.86 73.9% $ 14,043.73 $ 22,000.00 $ 7,956.27 63.8%
Electncfty-Drivir Range $ 1,988.34 $ 4,000.00 $ 2,011.66 49.7% $ 2,644.65 $ 4,000.00 $ 1,355.35 66.1%
R&M Equipment $ 53,572.3.5 $ 80,000.00 $ 26,427.65_ 67.0% $ 39,389.34 $ 75,000.00 $ 35,610.66 52.5%
R&M Irrigation $ 8,285.13 $ 35,000.00 $ 26,714.87 23.7% $ 17,698.46_$ 30,OD0.00 $ 12,301.54 59.0%.
Professional/Technical $ 4,815.16 $ 4,500.00 ' 315.16).107.0% $ 1,151.38 $ 4,500.00 $ 3,348.62 25.6%
Phone-Maintenance _ $ 306.84 $ 600.00 $ 293.16 51.1% $ 314.65 $ 600.00 $ 285.35 52.43/
Phone-Clubhouse $ 456.86 $ 850.00 $ 393.14 53.7% $ 460.62 . $ 850.00 $ 389.38. 54.2°%
Alarm-Maintenance $ 963.40 $ 1,100.00 $ 136.60 87.6% $ 963.40 $ 1,100.00 "$ 136.60 87.6%
Alarm-Clubhouse $ 672.00 $ 1,100.00 $ 428.00 61.1% $ 672.00 $ 2,000.00 $ 1,328.00 33.6%
Office Supplies-Admin. $ 4,930.36 $ 9,000.0 4,069.64 54.8% $ 6,880.26 $ 9,000.00 $ 2,119.74 76.4%
Score Cards $ 2,130.60_$ 3,600.00 $ 1,469.40 59.2% $ 1,610.00 $ 3,600.00 $ 1,990.00 _44.7%
Maintenance Supplies $ _12,456.20 $ 8,000.00 $ (4,456.20) 155.7% $ 6,024.03 $ 8,000.00 $ 1,975.97 75.3%
Range Supplies $ 4,777.43 $ 8,000.00 $ 3,222.57 59.7% $ 5,129.01 $ 8,000.00 $ 2,870.99 64.1%
Computer Services $ 3,707.15 $ 7,000.00 $ 3,292.85 53.0% $ 4,154.60 $ 7,000.00 $ 2,845.40 59.4%
Office Supplies Maint. $ 1,525.64 $ 500.00 $ (1,025.64) 305.1% $ 693.10 $ 500.00 $ (193.10) 138.6%
Custodial Supplies/Services $ 16,884.23 $ 20,000.00 $ 3,115.77 84.4% $ 14,009.82 $ 16,000.00. $ 1,990.18 87.6%
Rubbish Removal/Sanit. $ 16,341.25 $ _ 26,000.00 $ 9,658.75 62.9% $ 10,737.01 $ 22,500.00 _$_ 11,762.99 47.7%
Seed&Sod $ 14,347.98 $ 20,000.00 $ 5,652.02 71.7% $ 9,227.92 $ 25,000.00 $ 15,772.08 36.9%
Tee&_Green -T-186 00 $ 8,000.00 $ 7,814.00 _2.3% $ 2,160.51 $ 8,000.00 $ 5,839.49 27.0% _
Landscaping $ 439.02 $ 5,000.00 $ 4,560.98- 8.8% $ - $ 5,000.00 $ 5,000.00 0.0%
Topsoil&Sand $ 24,808.29 $ 30,000.00 $ 5,191.71 82.7% $ 19,575.00 $ 30,000.00 $ 10,425.00 65.3%
Fertilizer _ $ 34,316.55 $ 80,000.00 $ 45,663.45 42.9% $ 38,784.00 $ 80,000.00 $ 41,216.00 48.59;6
Fu!Vicide $ 112,975.52 $ 110,000.00 $ (2,975.521,102.7% $ 12,620.52 $ 135,000.00 $ 122,379.48 9.3%
Insecticides $ - $ 15,000.00 $ 15,000.00 0.0% $ 2,580.32 $ 15,000.00 $ 12,419.68 17.2%
Soil Amendments $ 42,494.20 $ 50,000.00_$ 7,505.80 85.0% $ 62,709.45 $ 50,000.00 $ 12,709.45+ 125.4%
RCart Lease $ 74,000.00 $ 111,000.00 $ 37,000.00 66.7% $ 79,990.4
idi0 $ 126,000.00 $ 46,009.60 63.5%
Clbhse Furnish/Repair $ 24,689.33 $ 40,000.00 $ 15,310.67 61.7%1 $ 16.968.961 $ 30,000.00 $ 13,031.04 56.6%
Credit Card Expense $ 53,985.65 $ 57,000.00 $ 3,014.35 94.7% $ 38,704.05 $ 50,000.00-1 $ 11,295.95 77.4%
In State Travel-Maint. $ - $ 450.00 $ 450.00 0.0% $ 243.91 $ 450.00 $ 206.09 54.2%
Meetings/Travel-Maint. $ $ 2,000.00 $ 2,000.DO 0.0% $ _ $ 2,000.00 $ 2,000.00 0.0%
Meetirgslfravel-Admin. $ - $ 500.00_$ 500.00 0.0% $ � $ 500.00 $ 500.00 o.0% _
Dues Subscript-s aint. $ 1,120.00 $ _ 1,520.00 $ 400.00- 73.7% $ $ 1,520.00 $ 1,520.00 0.0%
Dues Subscripts-Admin.
$ 2,020.00 $ 2,300.00 $ 280.00, 87.8% $ 2,020.00 $ 2,300.00 $ 280.00 87.8%
Adverts/Markt/Promo $ 10,500.62 $ 30,000.00 $ 19,499.38 35.0% $ 13,950.58, $ 35,000.00. $ 21,049.42 39.9% _
OSHA Trainin. t _ $ 2,500.00 $ 2,500.00 0.0% $ $ $ #DIV/01
Environmental Monitoring $ - $ 2,700.00 $ 2,700.00 0.0% $ $ $ #DIV/01
SUBTOTAL 1¢ 590,465.50 $ 887,220.00 $ 296,734.50 1 66.6% $ 483023.95 $ 904,920.00 $ 421,896.05 53.4%
Other Expenses:
Transfer toOPEB $ 17,277.00 $ 17,277.00 0% $ - $ $ - #DIV/O!
Pro Shop Purchases $ 54,583.60 $ 200,000.00 $ 145,416.40 27% $ 82,479.26 $ 230,000.00 $ 147,520.74 36%
Capital $ - $ 110,000.00 $_ 110,000.00 0% $ $ $ #DIV/01
Indirect Costs $ 114,967.00 $ 114,967.00_$ 100M.1 $ $ #DIV/0!
Life Insurance $ 328.65 $ 591.00 $ 262.35 56% $ 341.53 $ 591.00 $ 249.47 58% _
Unem I ment $ $ 54,000.00 $_ 54,000.00 0% $ 4,298.48 $ 54,000.00 $ 49,701.52 8%
Health Insurance $ 137,997.50 $ 282,454.00 $ 144,456.50 49% $ 153,580.75 $ 269,589.00 $ 116,008.25 57%
Medicare $ 10,970.17 $ 22,000.00 $ 11,029.83 50% $ 12,915.18 $ 21,500.00 $ _8,584.82 60%
Workers Compensation $ 11,439.00 $ 16,000.00 $ 4,561.00 711/6 $ $ $ - #DIV/01
General Liabil' .Insurance $ 71,827.21 $ 75,080.00 $ 3,252.79 96% $ $ $ #DIV/0!
Retirement/Penston Exp. $ 240,553.00 $ 240,553.00 $ - 100% $ 216,628.DO. $ 216,628.00 $ - 100%
SUBTOTAL $ 642,666.13 $1,132,922.00 . $ 490,255.87 57% $ 470,243.20 $ 792,308.00 $ 322,064.80 59%
1.
GRAND TOTAL _$2,11 317.02. $3,503,565.00 1 391 247.96 60% $1 781 779.48 13.3.1 381.00 i'1 i6_2,601.52 1 56.7%
CAPTAINS GOLF COURSE COMPARISON REPORT
JANUARY
Jan-16 Jan-17 Jan-18 Jan-19 Jan-20 Jan-21
REVENUE
MEMBERSHIPS:
RESIDENTS-Early $ 15,000.00 $ 7,416.00 $ $ 10,030.00 $ 201,291.02 $ 2,106.00
RESIDENTS-Morning $ 3,750.00 $ 3,092.00 $ $ 1,670.00 $ 77,865.00 $ -
RESIDENTS-Twilight $ - $ - $ - $ 446.00 $ 14,272.00 $
CHARTER NON-RESIDENTS $ - $ - $ - $ - $ - $ -
NON-RESIDENTS $ 10,500.00 $ 12,360.00 $ $ 18,359.00 $ 175,826.00 $ 1,752.00
NON-RESIDENT TWILIGHT $ - $ - $ $ $ 18,742.00 $ 272.00
AFP COLLEGIATE $ $ $ - $ $ 776.00 $ -
AFP JUNIOR $ $ $ - $ $ 776.00 $ -
SUBTOTAL $ 29,250.00 $ 22,868.00 $ - $ 30,505.00 $ 489,548.02 $ 4,130.00
GREEN FEES:
18 HOLE GREEN FEE $ 1,335.00 $ 2,427.00 $ 3,042.00 $ 1,651.00 $ 4,612.00 $ 4,659.00
TWILIGHT GREEN FEES $ 715.00 $ 964.00 $ 646.00 $ 639.00 $ 1,728.00 $ 1,984.00
BACK 9 GREEN FEES $ 50.00 $ 140.00 $ 26.00 $ - $ 42.00 $ 1,253.00
ADVANCED RESERVATIONS $ 300.00 $ 200.00 $ 200.00 $ 200.00 $ 5,206.00 $ 3,822.00
SUBTOTAL $ 2,400.00 $ 3,731.00 $ 3,914.00 $ 2,490.00 $ 11,588.00 $ 11,718.00
CARTS:
18 HOLE CART $ 414.16 $ 1,647.16 $ 694.48 $ 380.24 $ 3,223.97 $ 3,280.07
9 HOLE CART $ 331.29 $ 753.72 $ 158.08 $ 378.33 $ 1,374.83 $ 1,686.83
SUBTOTAL $ 745.45 $ 2,400.88 $ 852.56 $ 758.57 $ 4,598.80 $ 4,966.90
DRIVING RANGE $ 536.00 $ 894.00 $ 800.00 $ 623.00 $ 1,284.00 $ -
PULL CARTS $ 9.42 $ 16.92 $ 31.05 $ 97.89 $ 27.30 $ 126.07
SNACK BAR RENT $ - $ - $ - $ - $ - $ -
GIFT CERTIFICATES $ 986.69 $ 268.31 $ 600.36 $ 104.30 $ (1,288.20) $ 1,473.00
CREDIT BOOK $ (206.52) $ (96.30) $ (154.28) $ (196.60) $ (212.07) $ (15.60)
PRO SHOP SALES $ 2,068.36 $ 1,910.52 $ 880.38 $ 2,249.77 $ 9,526.01 $ 1,340.08
MISC.SALES $ $ - $ - $ - $ - $ -
SUBTOTAL $ 3,393.95 $ 2,993.45 $ 2,157.51 $ 2,878.36 $ 9,337.04 $ 2,923.55
TOTAL REVENUE $ 35,789.40 $ 31,993.33 $ 6,924.07 $ 36,631.93 $ 515,071.86 $ 23,738.45
CAPTAINS GOLF COURSE COMPARISON REPORT
- - - -- - -
FISCAL YEAR THROUGH JANUARY ( 7 months
FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021
REVENUE
MEMBERSHIPS:
RESIDENTS-Early $ 21,031.00 $ 19,995.00 $ 9,986.00 $ 28,010.00 $ 213,962.02 $ 25,218.00
RESIDENTS-Morning $ 7,500.00 $ 8,342.00 $ 3,092.00 $ 875.00 $ 81,205.00 $ (793.00)
RESIDENTS-Twilight $ 4,533.00 $ 4,033.00 $ 3,283.00 $ 4,933.00 $ 19,704.00 $ 6,696.00
CHARTER NON-RESIDENTS $ - $ - $ - $ - $ - $ -
NON-RESIDENTS $ 20,246.00 $ 22,446.00 $ 7,380.00 $ 27,524.00 $ 186,280.00 $ 26,352.00
NON-RESIDENT TWILIGHT $ 1,447.00 $ 747.00 $ 1,981.00 $ 2,154.00 $ 21,850.00 $ 7,036.00
COLLEGIATE $ $ - $ 515.00 $ 740.00 $ 1,721.00 $ 1,221.00
JUNIORS $ 525.00 $ 700.00 $ 720.00 $ 1,085.00 $ 1,164.00 $ 496.00
SUBTOTAL $ 55,282.00 $ 56,263.00 $ 26,957.00 $ 65,321.00 $ 525,886.02 $ 66,226.00
GREEN FEES:
18 HOLE GREEN FEE $1,076,038.32 $1,013,003.47 $ 955,938.55 $ 999,771.34 $ 1,037,259.58 $ 1,320,920.58
TWILIGHT GREEN FEES $ 91,052.59 $ 110,764.40 $ 110,729.00 $ 112,035.20 $ 118,121.00 $ 178,869.88
BACK 9 GREEN FEES $ 27,523.00 $ 40,232.00 $ 48,805.20 $ 57,807.04 $ 67,884.00 $ 85,876.95
ADVANCED RESERVATIONS $ 94,801.45 $ 80.885.40 $ 71,896.28 $ 53,787.00 $ 59,262.40 $ 30,825.80
SUBTOTAL $1,289,415.36 $1,244,885.27 $ 1,187,369.03 $1,223,400.58 $ 1,282,526.98 $ 1,616,493.21
CARTS:
18 HOLE CART $ 371,560.67 $ 370,862.44 $ 351,065.51 $ 359,603.63 $ 359,433.87 $ 465,470.52
9 HOLE CART $ 76,557.21 $ 74,543.13 $ 76,431.31 $ 85,333.39 $ 90,441.97 $ 111,847.30
SUBTOTAL $ 448,117.88 $ 445,405.57 $ 427,496.82 $ 444,937.02 $ 449,875.84 $ 577,317.82
DRIVING RANGE $ 88,105.00 $ 76,258.50 $ 83,963.00 $ 83,105.00 $ 87,381.00 $ 120,366.00
PULL CARTS $ 6,113.44 $ 5,347.39 $ 6,386.45 $ 6,126.10 $ 5,438.49 $ 6,878.15
SNACK BAR RENT $ 36,500.00 $ 36,500.00 $ 34,000.00 $ 26,500.00 $ 28,202.16 $ 10,000.00
GIFT CERTIFICATES $ (4,129.05) $ (1,867.43) $ (2,278.57) $ (3,581.34) $ (247.38) $ 8,106.60
CREDIT BOOK $ 3,701.28 $ 6,789.11 $ 6,158.93 $ (4,784.24) $ 2,336.92 $ 4,994.70
PRO SHOP SALES $ 192,748.70 $ 179,949.93 $ 160,477.00 $ 178,815.28 $ 178,898.18 $ 152,727.17
MISC.SALES $ $ - $ - $ - $ _ $ -
SUBTOTAL $ 323,039.37 $ 302,977.50 $ 288,706.81 $ 286,180.80 $ 302,009.37 $ 303,072.62
TOTAL REVENUE $2,115,854.61 $2,049,531.34 $ 1,930,529.66 $2,019,839.40 $ 2,560,298.21 $ 2,563,109.65
0 0 0 0 0 0 pp co O o 00 o n n o In In o rn O w w 0 w a m m i �o
0 0 0 0 0 0 8 N N O m W n w O to M N m m w N O m n �C 00 01 w. n o N M
0 0 0 0 0 0 ' a N 0 1n O N m O N O N a 01 M n O ' ' n N 01 vl 00 N N 01 ' o N Yf
rP ni od 08 ni 0 Ir CO r, o of I r- .1 o ei n `3 o tc m 1 a6 o ai o od a o rri r; v o p aC
Q N w N C M O W a0 O 01 01 N .-1 N O M Q to w www
0 00 n � rl N to V oo N M 'i N Ill 1l F O O n .i N .�I C 01 N In
Q H m ti M OO N N M
N N N N N N N N N N N N N N N N N N M N N N in N N N N N N N N N N N N N N N V} N
0 0 0 0 0 0 N N O O7 ~ 0 0 0 0 0 0 O O n O O n M
N Q p 0 0 0 0 0 0 O a !� O N N n
O O O O o o ' O N O ow ' ' ' ' ' a In W O O O O O o O 00 O 1-4
' ' '
zt6oco6LKLrF IR a6 r, z � coouivC
i o n6
m N m rl V Q N ''-I-I Ln '-I O N w = m N m .-1 -ifro l0 MI M m M
O
K
a
NNN NNNN Vf ppN in ih iA lA in iM1 in V1 iA Yf 4
86 iA ippA in iA in Vppf VT to 8N in to vl ih ih lh iA iA VYN N
0 0 0 0 0 0 ' ' 0 O O O O ' ' ' ' ' O O W o O o o O O ' O V o O N ' ' ' ' ' 1D M
O V1 O 111 O a .-1 Oi O' f` r ri o l!1 o V1 0 � o n e a N N
N m n N a o in .i �N-1 G ti w n r-I R eNi m In m O a
M .+
O
z
a
N N N in N N N N N N NNN N N N N N N N N N N N N N N in N N N N N in N in N in N N
O O O O O O Q O O O O ' ' ' ' ' Q Q Q O O O cc O 01 O O 00 n m
O O O O O O g O O O O $ g g O O O O O O 01 O O O O 0'
0 0 0 0 0 0 ' ' O O O O W O O O O O ' o V O O N
c 1l1 o (3 o .y V1 o N o rl a1 10 F O u 0 01 o .-i N 0 0 0 a O
O. N a N N M N O V r-I N n W a N V N N a 01 01 C m N M
a o a (ll
z
a
N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N in N N N'
o o 0 0 0 o o O O 8 8 O O O O O O 0) O O oo O D np M
O O O O O O O O ' ' ' O O O W O O O O O ' O oho O O ON ' ' ' ' O O M
C o le N t0 O o N O l0 S O' 00' N t0' O 00 O O V o M t
C O D
O N O n N N Q
N N N N W O N w .i M N N N
O
1
N N N N N N N N N N N N N N N N N N N V! N N N in N N N N H N N N N N N N N N N N
0o00opg oo m m .+ o o o o o p m0 2 o .4 ;
o o o o o b O o o o M p o o o o o $ m O o 0 0 0
0 0 0 0 0 0 o m M o w o o o o o a c N o n n
Wi0 N rl H V1 Ln n M N N !mn co yoj N .-/ N 111 N la0 N M o01 N LK
Lu
_ N
W O IL
d
N N N N N in N N N N N N N N N N N N N N in in in N N N N N N N N N in N N N N N N N
0 0 0 o O OO O o O O oo n O N N m N N
o o 0 o o 0 o O o o m r s a In m . i0 a m
' 0 0 0 0 ' ' O O ' c ' ' ' O O O J N 1%. Ol ' e ' N w a O n N
M H N of oo Oi r, o a tl1 Q 'Cr .• R N N opo rn M N a1'
Qm N 'i M fV M N Q N 01 V N N
G
a
N N N N N N N N N N N N N N N N N N N N N in N N N N N N N N N N N N N N in N N N
O O O O O Q O O o o ' ' ' Q Q v Ln �0 O " to �-I Ol ei n N
00000 g o 0 o o g g mwen Q m orn vv p1
' o O O O O ' ' C O O O J M M 1n N e ' ' ' n ei O N w
W 111 N H O V1 N oG1 N N rn'1` N M yVj � r rn N W N w w N a1
p rl .•1 G .-� N .r
a
N N N N N N N N N N N N N N N N N N N N N N N N N N N N V! N N N N N N N N N N N
O O O O O O O O o o M N w Q1 a1 M n N 01In IH
0 0 0 0 0 O O O O O N N N n .i o1 In O M a1 n
' O o o O O ' ' O O O O O ' ' ' ' ' J ' w rl V N . ' ' Q In N N M ' ' ' ' ' M a1
O
�-1
Lr V1 N W R/ ly V gM I� ff c a O 111 M o0 N O1 ll 01 ll O1 N �11n1
N ti C O� In .-I co v O to M 11 Cei M r4 ~ N
z G z
N N N N N N N N N N N N N N N N N N N N N N N N N N IM-14 in N N N N N N N N N N N
00 0 0 0 o O O O W 1 N W w m n an N N w o0 b to
O O O cc o O O O oo O N n w n m N 00 n 00
0 0 0 0 O O O O O O a1 J a1 (n w M M A -t 01 O N O
ON o o w o 1!1 rr N' 01c; O H N a Cr i n Il i tD r� 1l1 l!1 a o Ill N'
C-4 Vl N N m N N N ? O NW a-I N M em-I Ln N N N
a
N N N N N N N N N N N N N N N N N N N N N N N N N N N N Vf N N N N N N N N N V! in
0 0 cc 0 0 o o o .-I N p� M n Ib w 1n Of N O O1 1-1 M if
0 0 0 0 0 0 o o o m O o1 01 01 N w n n to ri 01 M
O pOp cc O O ' O O C o ' ' ' ' ' O al J a Q o0 V to of 01 N � O ' a1
N N al N N M N M O N N N Imo— 1Wn N N ti N N W N N N N
a
N N N N N N N N N N i n N N N N N N N M N N N N N N N N N i n N N N N N N V f N N N N
O coo O o 0 o c v A ie O .ti w a0 M O M N M a w O O
O O O O O o M O O N N n a 1n .-I
O c O O O ' o O O O �-I ' N OD J m 01 N O ' ' OM1 N .
N N ' ' ' ' Ono aNl
' o o o0 v1 Lr a0 Oi c M a a (p 01 00 00 N 111 oD Do of Ill O M tp
O M at N M M ri N N ri O ' .•i w M V n N a-i rl DD 00 a1
a a N w rI N M M G a In .i n " N M M
a
N N NN N NNNN NN NNNN NNN N N NNNNNNN NN NNNNNin NNN in• Uf
0 0 0 0 0 0 O O O O O n n Q a 6 M M n 01 m 0 n s•1 n tb n n n
0 0 0 0 0 0 O O o n pp n w a1 p1 a m m N 0 0 O O 01 Ol n w tp
0 0 0 0 0 0 ' ' 0 0 0 111 O N 01 Oo Oo O w 0 0 to O ' M n oo c} ' N 01 rn O1
tri o� Iri o L Iri c a of Ln w ri r, o ai o± ¢ ¢ v Ln w r4 o0 LA ti o P-� o v ri ai
J H w m m M C n - co o1 N N N J N N w M m M .-I N w N .-1 M N
In N n .•i .-i N
of
� a
V
N N N N N N N N N N N N N N N N N N N N C N N N N N N N N in N N N N N N N N N N Vl
O
W
O
w d v
N C
W 7 i-• 7 a_
V C •U O M
p o H y N 17 �n 1n m C y C7
z
Q1 C C N W L d O N K N C C N O N L O. O to
Ol w > 7 z X i O Y d z Q N y j J j z X ''�i1 z
H W O W W 7 W d W 47 �,• of O W W O1 L d W
o o � N c s E d a c o a
m � o_ 1w w � o w m ¢ C o mo7� uy IX W 'a ji v woc o v � � N moCa uY W W
o W N y LL c vLi ,,710, u Q W v vLi w m v m -, Q Z a W O c LL c L H a J 2 w m L y m y m ym, Z
N m m .� o O h F G Or `p c w >•a F a v m w > `n o uu, H a y In c a w >,n F Q
w o m wL O k a mo v m mO tj n m m vL O k 0 ao ' mda m mO ru
k In C7 v 0 it ae 1n `� F W O o. 1� 0 5 a u F ¢ p k en C7 u o o_ 1n H W 3 0 k li O S
FY 2021 YTD Projected vs Actual thru December:
PROJECTED ACTUAL VARIANCE
JUL-JAN JUL-JAN ACT vs PROJ
REVENUES:
Season Passes $ 35,000 $ 64,220 $ 29,220
Green Fees $ 1,293,000 $ 1,616,493 $ 323,493
Cart Fees $ 463,000 $ 583,930 $ 120,930
Driving Range $ 83,000 $ 120,366 $ 37,366
Pro Shop Revenues $ 127,000 $ 152,726 $ 25,726
Restaurant Rent $ 28,000 $ 10,000 $ (18,000)
Short Term Loan Proceeds $ - $ - $ _
Miscellaneous $ - $ - $ -
TOTAL REVENUES $ 2,029,000 $ 2,547,736 $ 518,736
EXPENSES:
Wages $ 824,000 $ 879,166 $ 55,166
Operating Expenses $ 453,000 $ 590,486 $ 137,486
Pro Shop Purchases $ 60,000 $ 54,583 $ (5,417)
Fringe Benefits $ 519,873 $ 389,849 $ (130,024)
Liability& Property Insurance $ 91,080 $ 83,266 $ (7,814)
OPEB $ 17,277 $ 17,277 $ -
indirect Costs $ 114,967 $ 114,967 $ -
Payback of Prior Deficit $ - $ - $ -
Capital $ - $ - $ -
TOTAL EXPENSES $ 2,080,197 $ 2,129,594 $ 49,397
SURPLUS/(DEFICIT) $ (51,197) $ 418,142 $ 469,339
MONTH: Jan-21 _ I _
] GUEST PLAY MEMBER PLAY GRAND
DATE DAY d 18 r B-9 1 TWI-LT I PP COMP OTHER TOT-GST 18 Bt-9_ .TOT-MBR TOTALS COMMENTSIWEATHER
1 FRI 19 3 _ 15- `_ 37 79 10 30 119 156 Sunny,Cool,40 deg
2 SAT 16 8 14 _ _ f 38 78 14 25 117 155 Cloudy,Windy,49 deg
3 SUN 7 11 _ _ 18 88 13 _ 101 119 Cloudy,Windy,41
4 MON 5 5 5 Rain,Windy,39 deg
5 TUE 1 _ 1 18 1 181 19 Rain,39 dep
6 i WED 2 1 1 4 48 7 12 67 71 Partly Clou ,39 de
7 THU 9 2 2 1 14 92 4 19 115 129 Sunny,Cold,37 ft
8 FRI 7 4 5 1 17 88 17 21 126 143 Sunny,42 deg
9 SAT 9 1 10 43 11 8 62 72 Cloudy,Flurries,35 deg
10 SUN 1 4 4 30 5 35 39 Pa Cloudy.38 deg
11 MON 1 1 1 3 76 14 15 105 108 Cloudy,38 deg
12 TUE _ 4 3 1 8 57 10 6 73 81 Sun 40 deg
13 WED 3 3 1 1 ? 8 56 11 18 85 93 Sun ,Chilly,39 de
14 THU _ 5 1 6 4 3, 18 100 7 15 122 _ 140 Cloudy,Cool,41 de
15 FRI 11 3 14 2 30 94 26 29 149 179 Sunny,Cool,44 deg
16 SAT
_ _ Closed,Rain,40 d
77, SUN 1 22 1 7 29 77 6 13 _ 96 125 Sunny,Windy,41 deg
18- MON . 121 97-3- 24 109 16! 42 167 191 Partly Sunny.45 deg
19 TUE 2 1 1 4 40 1 11 52 561 Partly Sunny,39 deg
20 WED 11 1 - 1 - 3 1 21 3 4 28 31Sunny.35d
21 THU _ 1 1 1 - 2 21 1 22 241 Cloudy,Cold,30 deg
22 FRI _ 6 1 4 11 105 17 31 153 164 Pa Sunny,Cool,42 d _
23 SAT 2 - 2 14 4 4 22 24; Sunny,Windy,Cold,30 deg
24 SUN 1 _ _ 1 13 2 15 16 Suny,Windy,34 deg
25 MON __ 1 1 32 . 3 7. 42 43. Partly Sunny,35 de _
26 TUE 1 1 33 3 9 45 46 Partly Sunny,37 deg
271 WED - - - - Closed,Snow,32 deg
28_ THU - Closed,Snow,30 deg
29 FRI - - Closed,Snow,18 deg
30 SAT - I Closed,Snow,22 deg
31. SUN Closed,Snow,25 dem
TOTALS 133 49 93 13 288 1,417 184 340 1,941 2,229 6 Days Closed
Jmiary- .. 135 69 f. 32 2 2381 835 59 190 1,084 1,322
January-19. 49 3 30 12 94 497 60 87 644 738'
Janes 84 6 22 _ 4 116 247 34 41 322 438
January-17 74_ 7 43. 11 135 673 11-3-- 64 850 985i
January-16 44 2 261 4 76 317' 33 731 423 499
3
Januaey-15. 49- 7' 13- - _ 1, 70 285 49 i7 351 421
January-14. 45- - 25+ 4 _ 74 264 68 47 379 453
January-131 891 3. 43 _ 11 146 286 56 72 414 560
Januamp12� 159 1 103 _ 33 _ 296 766 154 _ 128 1,0481 1,344
Janus 111 361. 25 3 _ 64- 1 104 17 20 141. 205
f _
Janu 10. 64 l 1 25 1 9 99 309 39 348 447
4anuary-09'
January-08 115- 8 611 16 200 499 f 591 131 689 889
January07 133 18 68 32 7 258 555 115 151 821 1,079
January-06__ 306_ 46.1 113 25 4901 1 1,015 85-1 238 1,338 1,828
Janu -05-
56 10 20 1 87 221 26 52 299 386
..
4ammry-047 17. 26 6 120 175 13 20 208 3281
January 03 44 4 19 1-7 74 139 6 29 1741 248
Janar r 02 148 3 101 4- 19 275 - _657 47 115 819 1094
January-01 561 121 5 9 f0 92 191 1- 4- 196 288
i
J �
- 1
anu -00 243 1 1 71 250 581 -----i-5T—i41 6101 860