Primary File Info
A Tree Dies and a Pub Suffers
Steven Cox, Jim Foster, Tim Burson, John Repede
November 1, 2018
Accounting & Finance
accounting, finance, data analytics, marketing, Accounting, finance, Data Analytics, marketing, Revenue
Journal of Case Studies
Jim Foster, the owner of the Selwyn Pub in Charlotte, NC, had just been forced to cut down a signature element of his successful Pub, a 100 plus year-old tree in the middle of his outdoor patio. Replacing the over 100’ tree with another tree of equal or near equal size was impractical. He could pave over the hole left by the tree and simply use umbrellas, construct a non-retractable awning over the space left by the tree, or construct a retractable awning over the space. As a former accountant, Foster had kept careful records of daily revenue and the effect of weather on each day’s revenue. He thought that he could build a model to determine the value of each alternative based on revenue, profit, and weather conditions to help him with his decision.
- Develop an Excel spreadsheet that models the various elements of the decision to determine the best course of action from a financial perspective.
- Identify and evaluate qualitative variables that might impact the decision.
- Using both quantitative and qualitative data decide on the best course of action.