Jennie Garcia could not believe that her career had moved so far so fast. When she left graduate school with a master’s degree in anthropology, she intended to work at a local coffee shop until something else came along that was more related to her academic background. But after a few months, she came to enjoy the business, and in a little more than a year, she was promoted to store manager. When the company for which she worked continued to grow, Jennie was given oversight of a few stores.
Now, eight years after she started as a barista, Jennie was in charge of operations and planning for the company’s southern region. As a part of her responsibilities, Jennie tracks store revenues and forecasts coffee demand. Historically, Sapphire Coffee would base its demand forecast on the number of stores, believing that each store sold approximately the same amount of coffee. This approach seemed to work well when the company had shops of similar size and layout, but as the company grew, stores became more varied. Now, some stores had drive-thru windows, a feature that top management added to some stores believing that it would increase coffee sales for customers who wanted a cup of coffee on their way to work but who were too rushed to park and enter the store to place an order.
Required Tasks:
1. Identify the major issue(s) of the case.
2. Develop a scatter plot of the variables Store Size and Weekly Sales. Identify the dependent variable. Briefly describe the relationship between the two variables.
3. Fit a linear regression equation to the data. Does the variable Store Size explain a significant amount of the variation in Weekly Sales?
4. Based on the estimated regression equation does it appear the $5.00 per square foot weekly sales expectation the company currently uses is a valid one?
5. Summarize your analysis and findings in a report to the company’s vice president of finance.