A Tree Dies and a Pub Suffers

Author
Steven Cox, Jim Foster, Tim Burson, John Repede
Topic
Accounting & Finance
Length
3 pages
Keywords
accounting, finance, data analytics, marketing
Accounting
finance
Data Analytics
marketing
Revenue
Student Price
$4.00
Target Audience
Undergraduate Students

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.

Learning Outcomes
  • 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.