Business Driven Technology 6th Edition by Paige Baltzan

Exercise 90

Too Much Information
You have just landed the job of vice president of operations for The Pitt Stop Restaurants, a national chain of full-service, casual-themed restaurants. During your first week on the job, Suzanne Graham, your boss and CEO of the company, has asked you to provide an analysis of how well the company's restaurants are performing. Specifically, she would like to know which units and regions are performing extremely well, which are performing moderately well, and which are underperforming. Her goal is to identify where to spend time and focus efforts to improve the overall health of the company.
Project Focus
Review the data file AYK21_Data.xlsx and determine how best to analyze and interpret the data. Create a formal presentation of your findings. A few things to consider include:
Should underperforming restaurants be closed or sold
Should high-performing restaurants be expanded to accommodate more seats
Should the company spend more or less on advertising
In which markets should the advertising budget be adjusted
How are The Pitt Stop Restaurants performing compared to the competition
How are units of like size performing relative to each other
Data File: AYK21_Data.xlsx