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.

Review the Final Project template and determine how best to analyze and interpret the data.

Students must use all the Excel functions we have used this semester to manipulate the data

provided. You must use everything listed below at least ONCE in your analysis. You determine

where and how to use the Excel components. I repeat...EACH component must be used at least

once. For example: 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.$ PivotCharts

$3.$ Excel formulas VLOOKUP or HLOOKUP

$4.$ Excel formula IF

$5.$ Excel formula Nested IF

$6.$ Conditional Formatting

$7.$ Use Sort where necessary