You have just landed the job of vice president of operations for The Pitt Stop Restaurants, a
Question:
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.
You may need one component for one question, but two or three components for another question. Failure to use all of the components will result in a deduction of points.
1. PivotTables
2. Pivot Charts
3. Excel formulas VLOOKUP or HLOOKUP
4. Excel formula IF
5. Excel formula Nested IF
6. Conditional Formatting
7. Use Sort where necessary.
Questions are:
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 is The Pitts Stop Restaurants performing compared to the competition?
How are units of like size performing relative to each other?
I know how to use all of those formulas, I am struggling to know which formula to put with each question. I have a master sheet of data to use that includes store attributes, Supply Generator Attributes, Demand Generator Attributes, and Competitive Attributes. If you could help me know where to start I would appreciate it.
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer