Calculate Growth

Calculate Future Margin

Tags

Calculate the following:

Growth $\%$ for each customer

Categorize growth $($see the Tags tab$)$

Prepare detailed excel workings & present your findings in PowerPoint:

Sales rep level analysis $($represent as growth & absolute change$)$

Growth category analysis

Why do you think some customers might be de$-$growing, and $2$ suggestions to bring them back to growth

$\backslash$table$[[$Customer Name,Sales Rep Responsible,$2022$ Sales$($million$),2023$ Sales$($million$),$Growth Growth Category,Absolute change$],[$AeroSpaceCraft Engineering,Miranda,$0\mathrm{.}08,0,-100\mathrm{.}00\%$ De$-$Growth,$8\%$