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.

Page $2$ of $2$

Answer the following questions:

a$.$ Should underperforming restaurants be closed or sold?

b$.$ Should high$-$performing restaurants be expanded to accommodate more seats?

c$.$ Should the company spend more $($or less$)$ on advertising?

d$.$ In which markets should the advertising budget be adjusted?

e$.$ How is The Pitts Stop Restaurants performing compared to the competition?

f$.$ How are units of like size performing relative to each other?

Considering your expertise, your CEO has given you the freedom to consider other hypothetical

questions and answer them in your analysis.