Forecast Worksheet for Crescent Ridge Calculate the average percent of change for the last 5 years using the Linear Trend Analysis formula (see Exhibit CR-2, CR-3, SV-2 and SV-3) in the Case Study Manual 2 Calculate the Average Numerical Change: Year 5 * Average % of Change This is Year 5 + the Average Numerical Change Based on your SWOT, your objectives and strategies, and your assumptions determine your revised forecast for the coming year. These numbers will transfer into the Annual column of your Operating Budget These columns contain locked and hidden formulas. You cannot enter any data. The cells will populate based on data from other cells. Dollars per Average % of Average Trend Forecast Revised % Change from Numerical Year 5 Numerical Forecast for Dollars per Round Yr 5 Change Yr 55 Change 2 for Year 6 3 Change from Year 6 4 Year 5 Round Yr 65 Total Rounds 26250 100.0% -26250 Round Type Weekday 12058 100.0% -12058 Weekend/Holiday 13242 100.0% 13242 Tournament 950 100.0% 950 Demographic Breakdown Men 21524 100.0% 21524 Women 3938 100.0% 3938 Juniors 788 100.0% -788 Golf Operations Revenues Green Fees $ 1,089,884 $41.52 100.0% $1,089,884 #DIV/O! Tournament Fees 10,924 $43.0 100.0% $40,924 #DIV/0! Golf Car Rental Fees 356,475 $13.58 100.0% $356,475 #DIV/0 Range 20,270 $0.77 100.0% $20,270 #DIV/O! Golf Equipment Rental 14,289 $0.54 100.0% $14,289 #DIV/O! Instruction 4,231 $0.16 100.0% $4,231 #DIV/O Player Development 1,437 $0.05 100.0% $1,437 #DIV/O! Merchandise Total Revenue 69,410 $2.64 100.0% $69,410 #DIV/O! Cost of Goods Sold $59,480) 85.69% 100.0% $59,480 #DIV/O! Merchandise Gross Margin S ,930 -100.0% $9,930 Total Golf Operations Revenues $ 1,537,440 $58.57 SO -100.0% -$1,537,440 #DIV/O! Golf Operations Expenses Labor and Benefits 253,543 $9.66 100.0% $253,543 #DIV/O! Instruction Fees paid to Employee 2,750 100.0% $2,750 Player Dev. Fees paid to Employee S 934 100.0% -$934 Utilities 65,803 100.0% $55,803 Marketing/Promotion 6,100 $0.23 100.0% $6,100 #DIV/O! Fixtures 2,990 100.0% $2,990 Education and Travel 9,525 100.0% $9,525 Golf Car Lease 74,880 -100.0% $74,880 Golf Car Maintenance 30,389 -100.0% $30,389