|
CURRENT MONTH
<br />DESCRIPTION
<br />YEAR TO -DATE
<br />CURRENT
<br />FORECAST
<br />ANNUAL
<br />BUDGET
<br />ACTUAL
<br />PCT
<br />BUDGET
<br />PCT
<br />VARIANCE
<br />LAST YEAR
<br />VARIANCE
<br />ACTUAL
<br />PCT
<br />BUDGET
<br />PCT
<br />VARIANCE
<br />LAST YEAR
<br />VARIANCE
<br />5.728
<br />5150
<br />578
<br />4.783
<br />945
<br />TOTAL FACILITY ROUNDS
<br />15.836
<br />14.650
<br />1.186
<br />13.098
<br />2.738
<br />36.186
<br />35.000
<br />4,958
<br />4538
<br />420
<br />4.209
<br />749
<br />TOTAL GREEN FEE ROUNDS
<br />12.133
<br />11,935
<br />198
<br />11.060
<br />1073
<br />28.826
<br />28,628
<br />3.345
<br />3250
<br />95
<br />2,844
<br />501
<br />TOTAL RESTAURANT COVERS
<br />7,806
<br />7550
<br />256
<br />7,388
<br />418
<br />18.256
<br />18,000
<br />446
<br />325
<br />121
<br />572
<br />11261
<br />TOTAL BANQUET COVERS
<br />721
<br />600
<br />121
<br />656
<br />65
<br />1521
<br />1.400
<br />Revenues
<br />26,069
<br />9%
<br />11,280
<br />4%
<br />14,789
<br />8,383
<br />17,686
<br />LOYALTY PASS INITIATION FEES
<br />69,290
<br />9%
<br />46,060
<br />6%
<br />23,230
<br />37,467
<br />31,823
<br />103,130
<br />79,900
<br />11,103
<br />4%
<br />3,625
<br />1%
<br />7478
<br />1,020
<br />10,083
<br />ANNUAL PASS INITIATION FEES
<br />57,468
<br />8%
<br />41,815
<br />5%
<br />15,653
<br />30,675
<br />26,793
<br />87,578
<br />71,925
<br />132,830
<br />45%
<br />143,169
<br />52%
<br />(10,339)
<br />123,731
<br />9,099
<br />GREEN FEES
<br />333,123
<br />44%
<br />372,035
<br />48%
<br />(38,912)
<br />328,746
<br />4,377
<br />852,813
<br />891,725
<br />20,988
<br />7%
<br />21,888
<br />8%
<br />(900)
<br />18,956
<br />2,032
<br />DRIVING RANGE
<br />63,480
<br />8%
<br />62,265
<br />8%
<br />1,215
<br />58,523
<br />4,957
<br />149,969
<br />148,754
<br />40,194
<br />14%
<br />31,415
<br />12%
<br />8,779
<br />32,657
<br />7,537
<br />GOLF CART RENTALS
<br />91,188
<br />12%
<br />89,365
<br />12%
<br />1,823
<br />73,172
<br />18,016
<br />215,324
<br />213,501
<br />2,204
<br />1%
<br />1,288
<br />0%
<br />916
<br />2,070
<br />134
<br />OTHER MISCELLANEOUS GOLF
<br />2,724
<br />0%
<br />6,665
<br />1%
<br />(3941)
<br />5,658
<br />(2,924)
<br />17,813
<br />21,754
<br />20,446
<br />7%
<br />21,888
<br />8%
<br />(1442)
<br />23,982
<br />(3,536)
<br />GOLF SHOP MERCHANDISE
<br />49,700
<br />7%
<br />62,263
<br />8%
<br />(12,563)
<br />54,002
<br />(4,302)
<br />136,189
<br />148,752
<br />13,086
<br />4%
<br />9,785
<br />4%
<br />3,301
<br />11,275
<br />1,811
<br />F&B ON- COURSE
<br />28,095
<br />4%
<br />27,837
<br />4%
<br />258
<br />22,361
<br />5,734
<br />66,761
<br />66,503
<br />22,439
<br />8%
<br />21,938
<br />8%
<br />501
<br />18,876
<br />3,563
<br />F &B RESTAURANT
<br />49,389
<br />7%
<br />50,963
<br />7%
<br />(1,574)
<br />49,249
<br />140
<br />119,928
<br />121,502
<br />7,742
<br />3%
<br />6,501
<br />2%
<br />1,241
<br />10,001
<br />(2,259)
<br />F813 BANQUET
<br />11,612
<br />2%
<br />12,002
<br />2%
<br />(3911)
<br />13,177
<br />(1,565)
<br />27,612
<br />28,002
<br />24
<br />0%
<br />0
<br />0%
<br />24
<br />959
<br />(935)
<br />OTHER P88 (ROOM EQUIPMENT. ETC.)
<br />(292)
<br />0%
<br />0
<br />0%
<br />(292)
<br />1,963
<br />(2,255)
<br />(292)
<br />0
<br />297,124
<br />100%
<br />272.777
<br />100%
<br />24,347
<br />251,910
<br />45,214
<br />TOTAL REVENUES
<br />755.777
<br />100%
<br />771.270
<br />100%
<br />(15.4931
<br />674.993
<br />80,784
<br />1.776.825
<br />1.792,318
<br />Less: Cost of Sales
<br />14,636
<br />72%
<br />16,328
<br />75%
<br />1,692
<br />17,606
<br />2,970
<br />GOLF SHOP MERCHANDISE
<br />37,452
<br />75%
<br />46,448
<br />75%
<br />8,996
<br />42,550
<br />5,098
<br />101,972
<br />110,968
<br />14,417
<br />33%
<br />14,341
<br />38%
<br />(76)
<br />11,964
<br />(2453)
<br />FOOD BEVERAGE
<br />31,494
<br />35%
<br />34,015
<br />37%
<br />2,521
<br />29,967
<br />(1.527)
<br />78,391
<br />80,912
<br />29,053
<br />30.669
<br />1.616
<br />29,570
<br />517
<br />TOTAL COST OF SALES
<br />68.946
<br />80.463
<br />11.517
<br />72,517
<br />3571
<br />180,363
<br />191.880
<br />268.071
<br />242.108
<br />25.963
<br />222.340
<br />45.731
<br />GROSS PROFIT
<br />686,831
<br />690,807
<br />13.9761
<br />602.476
<br />84.355
<br />1596.462
<br />1,600.438
<br />Payroll and Benefits
<br />21,268
<br />7%
<br />20,291
<br />7%
<br />(977)
<br />22,380
<br />1,112
<br />GOLF OPERATIONS
<br />78,174
<br />10%
<br />84,061
<br />11%
<br />5,887
<br />75,585
<br />(2,589)
<br />175,301
<br />181,188
<br />33,088
<br />11%
<br />36,363
<br />13%
<br />3,275
<br />37,100
<br />4012
<br />GOLF COURSE MAINTENANCE
<br />108,776
<br />14%
<br />129,158
<br />17%
<br />20,382
<br />152,754
<br />43,978
<br />280,880
<br />301,262
<br />12,789
<br />4%
<br />10,221
<br />4%
<br />(2,568)
<br />14,321
<br />1,532
<br />FOOD BEVERAGE
<br />33,257
<br />4%
<br />36,022
<br />5%
<br />2,765
<br />57,218
<br />23,961
<br />76,027
<br />78,792
<br />10,684
<br />4%
<br />14,312
<br />5%
<br />3,628
<br />13,268
<br />2,584
<br />GENERAL ADMINISTRATIVE
<br />65,585
<br />9%
<br />85,871
<br />11%
<br />20,286
<br />84,270
<br />18,685
<br />151,455
<br />171,741
<br />0
<br />0%
<br />0
<br />0%
<br />0
<br />0
<br />0
<br />MARKETING
<br />0
<br />0%
<br />0
<br />0%
<br />0
<br />5421
<br />5,421
<br />0
<br />0
<br />77,829
<br />26%
<br />81.187
<br />30%
<br />3,358
<br />87069
<br />9.240
<br />TOTAL PAYROLL AND BENEFITS
<br />285.792
<br />38%
<br />335.112
<br />43%
<br />49.320
<br />375,248
<br />89.456
<br />683.663
<br />732.983
<br />Operating Expenses
<br />2,520
<br />1%
<br />1,475
<br />1%
<br />(1,045)
<br />1,628
<br />(892)
<br />GOLF OPERATIONS
<br />18,787
<br />2%
<br />13,000
<br />2%
<br />(5,787)
<br />9,346
<br />(9441)
<br />27,812
<br />22,025
<br />0
<br />0%
<br />0
<br />0%
<br />0
<br />0
<br />0
<br />GOLF SHOP MERCHANDISE
<br />5
<br />0%
<br />0
<br />0%
<br />(5)
<br />0
<br />(5)
<br />5
<br />0
<br />14,794
<br />5%
<br />16,625
<br />6%
<br />1,831
<br />13,955
<br />(839)
<br />GOLF COURSE MAINTENANCE
<br />65,681
<br />9%
<br />73,970
<br />10%
<br />8,289
<br />66,293
<br />612
<br />134,856
<br />143,145
<br />3,106
<br />1%
<br />3,000
<br />1%
<br />(106)
<br />670
<br />(2,436)
<br />COURSE ELECTRIC 8 WATER PUMPING
<br />7,211
<br />1%
<br />11,000
<br />1%
<br />3,789
<br />3,204
<br />(4,007)
<br />21,211
<br />25,000
<br />3,951
<br />1%
<br />2,575
<br />1%
<br />(1,376)
<br />3,421
<br />(530)
<br />FOOD BEVERAGE
<br />13,640
<br />2%
<br />13,455
<br />2%
<br />(185)
<br />7,349
<br />(6,291)
<br />22,860
<br />22,675
<br />9445
<br />3%
<br />8,865
<br />3%
<br />(580)
<br />14,291
<br />4,846
<br />GENERAL ADMINISTRATIVE
<br />33,394
<br />4%
<br />32,506
<br />4%
<br />(088)
<br />33,781
<br />387
<br />72,438
<br />71,550
<br />2,966
<br />1%
<br />10,050
<br />4%
<br />7,084
<br />9,158
<br />6,192
<br />MARKETING
<br />18,437
<br />2%
<br />33,775
<br />4%
<br />15,338
<br />21,515
<br />3,078
<br />39,962
<br />55,300
<br />6,638
<br />2%
<br />6,757
<br />2%
<br />119
<br />4892
<br />(1,746)
<br />CLUBHOUSE
<br />31,330
<br />4%
<br />32,967
<br />4%
<br />1,637
<br />28,024
<br />(3,306)
<br />67,897
<br />69,534
<br />43.420
<br />15%
<br />49,347
<br />18%
<br />5527
<br />48.015
<br />4.595
<br />TOTAL OPERATING EXPENSES
<br />188.485
<br />25%
<br />210.673
<br />27%
<br />22.188
<br />169.512
<br />(18.973)
<br />387.041
<br />409,229
<br />121,248
<br />41%
<br />130,534
<br />48%
<br />9,285
<br />135.084
<br />13.836
<br />TOTAL PAYROLL AND OPERATING EXPENSES
<br />474,276
<br />63%
<br />545,785
<br />71%
<br />71,508
<br />544,760
<br />70,484
<br />1,070,704
<br />1,142,212
<br />146,823
<br />49°%
<br />111.574
<br />41%
<br />35.249
<br />87,256
<br />59.567
<br />NET OPERATING INC OWE
<br />212.554
<br />145.022
<br />67,532
<br />57716
<br />154,838
<br />525,758
<br />458,226
<br />123,364
<br />42%
<br />87,299
<br />32%
<br />(36,065)
<br />0
<br />(123,364)
<br />MANAGEMENT FEE
<br />128433
<br />17%
<br />59,062
<br />8%
<br />(69,370)
<br />0
<br />(128,433)
<br />141,816
<br />72,446
<br />12,379
<br />4%
<br />11,665
<br />4%
<br />(714)
<br />5473
<br />(6,906)
<br />MAINTENANCE EQUIPMENT LEASES
<br />36,101
<br />5%
<br />36,130
<br />5%
<br />29
<br />16,419
<br />(19682)
<br />106,091
<br />106,120
<br />8,610
<br />3%
<br />8,610
<br />3%
<br />0
<br />8,610
<br />0
<br />GOLF CART LEASES
<br />25,829
<br />3%
<br />25,830
<br />3%
<br />1
<br />25,830
<br />1
<br />51,659
<br />51,660
<br />2,391
<br />1%
<br />4,000
<br />1%
<br />1,609
<br />3,998
<br />1,607
<br />INSURANCE (NON WORKERS' COMP)
<br />20,774
<br />3%
<br />24,000
<br />3%
<br />3,226
<br />23,988
<br />3,214
<br />44,774
<br />48,000
<br />78
<br />0%
<br />0
<br />0%
<br />(78)
<br />0
<br />(78)
<br />INTEREST AND DEPRECIATION (DEBT SERVICE
<br />1,417
<br />0%
<br />0
<br />0%
<br />(1,417)
<br />0
<br />(1.417)
<br />181,417
<br />180,000
<br />148 823
<br />111,574
<br />41%
<br />(35.249)
<br />18081
<br />(128,7421
<br />TOTAL FIXED: &MISC ;EXPENSES
<br />212,554
<br />28%
<br />145.022
<br />19%
<br />(67,5321
<br />66,237
<br />(146,3171
<br />525,758
<br />456726
<br />0
<br />0°%
<br />0
<br />0°%
<br />0
<br />69,175
<br />469.1751
<br />NET INCOME
<br />0
<br />0%
<br />0
<br />0%
<br />0
<br />48.5211
<br />8521
<br />0
<br />0
<br />0%
<br />0%
<br />0%
<br />0%
<br />0
<br />0%
<br />0%
<br />NET INCOME
<br />0°%
<br />0%
<br />0%
<br />0%
<br />0%
<br />0%
<br />0%
<br />0%
<br />0%
<br />$26.79
<br />$31.55
<br />($4.76)
<br />$29.40
<br />($2.61)
<br />Avg. Green Fee per Green Fee Round
<br />$27.46
<br />$31.17
<br />($3.72)
<br />$29.72
<br />($2.27)
<br />$29.58
<br />$31.15
<br />$3.66
<br />$4.25
<br />($0.59)
<br />$3.96
<br />($0.30)
<br />Avg.$ Driving Range per Facility Round
<br />$4.01
<br />$4.25
<br />($0.24)
<br />$447
<br />($0 46)
<br />$4.14
<br />$4.25
<br />$7.02
<br />$6.10
<br />$0.92
<br />$6.83
<br />$0.19
<br />Avg.$ Cart Fee per Facility Round
<br />$5.76
<br />$6.10
<br />($0.34)
<br />$5.59
<br />$0.17
<br />$5.95
<br />$6.10
<br />$0.38
<br />$0.25
<br />$0.13
<br />$0.43
<br />($0.05)
<br />Avg. Other Golf Revenue per Facility Round
<br />$0.17
<br />$0.45
<br />($0.28)
<br />$0.43
<br />($0.26)
<br />$049
<br />$0.62
<br />$3.57
<br />$4.25
<br />($0.68)
<br />$5.01
<br />($1.44)
<br />Avg.$ Merchandise per Facility Round
<br />$3.14
<br />$4.25
<br />($1.11)
<br />$4.12
<br />($0.98)
<br />$3.76
<br />$4.25
<br />$2.28
<br />$1.90
<br />$0.38
<br />$2.36
<br />($0.07)
<br />Avg.$ F&B On Course per Facility Round
<br />$1.77
<br />$120
<br />($0.13)
<br />$1.71
<br />$0.07
<br />$1.84
<br />$120
<br />$6.71
<br />$6.75
<br />($0.04)
<br />$6.64
<br />$0.07
<br />Avg. F813 Restaurant per Restaurant Cover
<br />$6.33
<br />$6.75
<br />($0.42)
<br />$6.67
<br />($0.34)
<br />$6.57
<br />$6.75
<br />$1741
<br />$20.00
<br />($2.59)
<br />$19.16
<br />($1.75)
<br />Avg. F &B Banquets per Banquet Cover
<br />$15.70
<br />$20.00
<br />($4.30)
<br />$23.08
<br />($7.38)
<br />$17.96
<br />$20.00
<br />191
<br />172
<br />19
<br />159
<br />32
<br />Average Rounds per Day
<br />87
<br />81
<br />7
<br />72
<br />15
<br />99
<br />96
<br />COAL CREEK GOLF COURSE
<br />CONSOLIDATED INCOME STATEMENT
<br />FOR THE PERIOD ENDED
<br />June 2011
<br />
|