Question: IV. Mini Case (spreadsheet tab MiniCase) Crazy Brook Meadow Ski Resort The Crazy Brook Meadow Ski Resort, hereafter CBM, is a small ski resort in
IV.
Mini Case (spreadsheet tab MiniCase)
Crazy Brook Meadow Ski Resort
The Crazy Brook Meadow Ski Resort, hereafter CBM, is a small ski resort in Northern New England. CBM does not have snow making capability and depends, therefore, on Mother Nature to provide the snow for the ski season. The owner is worried that climate change may affect snow fall and the business may suffer under years where snow fall is low. CBM does not have enough cash reserves to go through a truly bad ski season. Average snow fall for the resort is approximately 220 inches a season. The average revenue for a ski season is approximately $30 million. The resort has a breakeven revenue need of $20 million. Your own personal prediction for snowfall for the 2021 ski season (fall/winter 2020 through winter/spring 2021) is 170 inches. The national weather service is predicting 190 inches. An area (Northern New England) snowfall contract is available on a U.S. futures exchange. The contract settles at $500 times the snowfall in inches for the contract area, and trades in points (inches), with the minimum movement being 0.5 inches. The contract is currently at 190. Do a statistical analysis (like a regression) on the data. At 190 inches how much revenue would you predict for CBM? At 170 inches how much revenue would you predict for CBM? Suppose you wanted to hedge against the National Weather Service prediction. How many contracts would you need (in round numbers) to hedge against a drop in snowfall?
| Breakeven Revenue | $ 20,000,000 | |
| Snowfall | Revenue | |
| Average | 220 | $ 30,000,000 |
| Season | ||
| 2004 | 210 | $ 27,515,912.00 |
| 2005 | 296 | $ 48,989,347.00 |
| 2006 | 272 | $ 42,985,009.00 |
| 2007 | 116 | $ 4,004,574.00 |
| 2008 | 321 | $ 55,240,139.00 |
| 2009 | 226 | $ 31,506,324.00 |
| 2010 | 303 | $ 50,749,276.00 |
| 2011 | 242 | $ 35,519,955.00 |
| 2012 | 181 | $ 20,230,138.00 |
| 2013 | 151 | $ 12,755,140.00 |
| 2014 | 346 | $ 61,514,213.00 |
| 2015 | 234 | $ 33,505,697.00 |
| 2016 | 163 | $ 15,759,282.00 |
| 2017 | 122 | $ 5,488,905.00 |
| 2018 | 155 | $ 13,733,320.00 |
| 2019 | 212 | $ 27,986,787.00 |
| 2020 | 198 | $ 24,501,997.00 |
| 2021* | 170 | |
| 2021** | 190 | |
| *predicted by you | ||
| ** National weather service | ||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help