|
2019 MASTER ANNUAL DASHBOARD
<br />Revenue
<br />Playable Days
<br />Total Rounds
<br />Daily Rental
<br />Green Fees
<br />Golf Cart Fees
<br />Golf Clulb Repair
<br />Golf Lessons
<br />Handicap fees
<br />Pro Shop retail sales
<br />Range Fees
<br />*Annual pass revenue
<br />Sweet Spot lease F&B sales
<br />Sweet Spot utilities
<br />Insurance Recovery
<br />4th of July Reimbursement
<br />Interest earnings
<br />Miscelaneous
<br />Total revenue
<br />Total revenue per round
<br />Reveunue per playable day
<br />Expenditures
<br />Course maintenance
<br />Golf Operations
<br />Clubhouse
<br />Marketing
<br />Total expenditures
<br />Expenese per round
<br />NET INCOME (Rev - Exp)
<br />gross profit (loss) per round
<br />golf course maintenance + golf ops labor/18 hole equiviant
<br />What does it cost to produce a round?
<br />Course Maintenance YTD
<br />Golf Ops Salaries Sum YTD
<br />18 Hole Rds Played YTD
<br />YTD
<br />YTD
<br />Q1
<br />Q2
<br />Q3
<br />Q4
<br />Actual
<br />Budget
<br />Actual
<br />Budget
<br />Actual
<br />Budget
<br />Actual
<br />Budget
<br />Actual
<br />Budget
<br />215
<br />271
<br />18
<br />48
<br />74
<br />79
<br />91
<br />82
<br />32
<br />62
<br />28980
<br />28057
<br />1181
<br />2367
<br />11119
<br />9808
<br />13973
<br />12311
<br />2707
<br />3571
<br />ALL FIGS SHOULD BE HARDKEYED FROM
<br />JIM'S REPORT, AS #S CHANGE
<br />$ 10,694
<br />$ 12,790
<br />$ 329
<br />$ 498
<br />$ 3,072
<br />$ 4,817
<br />$ 6,225
<br />$ 5,298
<br />$ 1,006
<br />$ 2,177
<br />$ 865,694
<br />$ 982,713
<br />$ 25,536
<br />$ 95,495
<br />$ 326,500
<br />$ 347,761
<br />$ 437,795
<br />$ 382,357
<br />$ 80,801
<br />$ 157,100
<br />$ 219,795
<br />$ 249,632
<br />$ 3,260
<br />$ 24,258
<br />$ 84,718
<br />$ 88,339
<br />$ 111,984
<br />$ 97,128
<br />$ 19,068
<br />$ 39,907
<br />$ 10,599
<br />$ 6,718
<br />$ 1,807
<br />$ 652
<br />$ 4,654
<br />$ 2,378
<br />$ 2,198
<br />$ 2,614
<br />$ 1,963
<br />$ 1,074
<br />$ 68,037
<br />$ 45,807
<br />$ 3,925
<br />$ 4,451
<br />$ 31,471
<br />$ 16,210
<br />$ 22,773
<br />$ 17,823
<br />$ 3,460
<br />$ 7,323
<br />$ 6,674
<br />$ 5,221
<br />$ 2,795
<br />$ 507
<br />$ 3,109
<br />$ 1,848
<br />$ 769
<br />$ 2,032
<br />$ -
<br />$ 835
<br />$ 108,697
<br />$ 105,145
<br />$ 10,739
<br />$ 10,217
<br />$ 39,495
<br />$ 37,209
<br />$ 44,872
<br />$ 40,910
<br />$ 13,444
<br />$ 16,809
<br />$ 111,124
<br />$ 125,612
<br />$ 7,834
<br />$ 12,207
<br />$ 48,329
<br />$ 44,451
<br />$ 45,031
<br />$ 48,873
<br />$ 9,979
<br />$ 20,081
<br />$ 176,759
<br />$ 199,834
<br />$ 44,085
<br />$ 19,419
<br />$ 72,662
<br />$ 70,717
<br />$ 58,373
<br />$ 77,752
<br />$ 44,190
<br />$ 31,946
<br />$ 33,488
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 30,000
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 1,913
<br />$ -
<br />$ 44,661
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 8,000
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 8,000
<br />$ 8,000
<br />$ -
<br />$ -
<br />$ 7,725
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 707
<br />$ -
<br />$ 5,794
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 1,677,742 $ 1,733,472
<br />$ 613,730
<br />$ 100,310
<br />$ 167,704
<br />$ 614,010
<br />$ 731,795 $ 677,488
<br />$ 206,530 $ 277,252
<br />$ 57.89 $ 61.78
<br />$ 84.94 $ 70.85
<br />$ 55.22 $ 62.57
<br />$ 52.37 $ 55.03
<br />$ 76.29 $ 77.64
<br />$ 7,803.45 $ 6,396.57
<br />$ 5,572.80
<br />$ 3,493.83
<br />$ 8,297.43
<br />$ 7,768.73
<br />$ 8,041.70
<br />$ 55.03
<br />$ 6,454.05
<br />$ 77.64
<br />Quarter Actual
<br />Quarter Budget
<br />Quarter Actual
<br />Quarter Budget
<br />Quarter Actual
<br />Quarter Budget
<br />Month actual
<br />Month budget
<br />$ 660,499 $ 900,370
<br />$ 90,633
<br />$ 107,853
<br />$ 187,663
<br />$ 210,833
<br />$ 218,746
<br />$ 340,505
<br />$ 163,496
<br />$ 241,179
<br />$ 732,274 $ 706,949
<br />$ 86,204
<br />$ 79,287
<br />$ 248,242
<br />$ 257,183
<br />$ 258,913
<br />$ 246,452
<br />$ 138,915
<br />$ 124,027
<br />$ 92,982 $ 89,990
<br />$ 14,366
<br />$ 15,950
<br />$ 26,445
<br />$ 20,013
<br />$ 28,009
<br />$ 27,112
<br />$ 23,024
<br />$ 26,915
<br />$ 115,032 $ 111,130
<br />$ 26,376
<br />$ 25,097
<br />$ 28,634
<br />$ 33,061
<br />$ 32,578
<br />$ 27,760
<br />$ 27,443
<br />$ 25,212
<br />$ 1,600,786 $ 1,808,439
<br />$ 217,578 $ 228,187
<br />$ 490,984 $ 521,090
<br />$ 538,246 $ 641,829
<br />$ 352,878 $ 417,334
<br />$ 55.24 $ 64.46
<br />$ 184.23 $ 96.40
<br />$ 44.16 $ 53.13
<br />$ 38.52 $ 52.13
<br />$ 130.36 $ 116.87
<br />$ 76,956 $ (74,968)
<br />$ (117,268)
<br />$ (60,483)
<br />$ 123,026
<br />$ 92,640
<br />$ 193,549
<br />$ 35,659
<br />$ (146,348)
<br />$ (140,082)
<br />$ 2.66 $ (2.67)
<br />$ (99.30) $ (25.55)
<br />$ 17.58 $ 10.77
<br />$ 13.85 $ 2.90
<br />$ (1.71) $ (1.70)
<br />$ 38.13 p/Round
<br />$ 660,499
<br />$ 444,612
<br />$ 28,980
<br />*APR from 'APR V2' sheet, calcs have been changed multiple times Annual pass sales are caclulated by allocating sales in 2017, 2018, 2019 to months where services are rendered.
<br />9
<br />
|