Calculate Growth

Calculate Future Margin

$\backslash$table$[[\backslash$table$[[$The company is has accepted a contract from a customer, where it will$],[$make AED $5m$@$15\%$ margin. The country manager wants to you to$],[$provide him with a simulation for the impact this deal will have on the FY$],[$P&L$]],,$Actuals,$],[$Assumptions:$,$in kAED,YTD Jun,Deal$],[1.$ H$2$ sales and margin will be in line with YTD Jun actuals,Sales,$25,000,5,000],[2.$ The deal will be $100\%$ revenue for $2024,$Margin $\%,22\%,15\%$

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,,-100\mathrm{.}00\%,$De$-$Growth,$8\%$