Instructions & Answers: Part $2$: Discussion Questons. $(15$ pts$)-$ for simplicity, you can add your answers to these questions right into this worksheet

What are $3$ conclusions can you make about this business and its spending $($beyond data patterns$)$ in each of these $2$ categories? $(3$ per category$)$

Identify $3$ improvement opportunities for this company regarding its spending in each of these $2$ spend categories? $(3$ per category$)$ For each category, what piece of additional data you would want to complete a more thorough analysis? Why? What questions it would help you answer?

Complete a spend analysis for the Freight & Transportation $($F&T$)$ and Packaging Materials $($PM$)$ categories. $($Assignment Total $40$ pts$)$

Prep: Data tab is locked so copy & paste data into new worksheet before working with the information

Part $1$: Please show your work, using formulas, tables, pivots, charts, etc. to answer the following questions. $(25$ pts$)$

What was the annual $\%$ change in spend for each of these categories from $2013$ to $2018($round to $1$ decimal place$)?$

In the Freight & Transporation category, which supplier represented the highest spend over the last $6$ years in each of these account areas?

In the PM category, excluding lumber suppliers, which supplier represented the highest spend in the category? What $\%$ of total PM spend does this suppier represent?

What $\%$ of annual sales do these categories represent $($round to nearest $1$ decimal place$)?$

For the Freight & Transportation spend category, show a distribution of spending across accounts for $2018-$ display in a chart $($bar$,$ pie, combo, etc$)$ and expand the answer space as necessary. PLease solve it using excel by using the necessary formulas