Forecasting

Now that you calculated different opportunities based on the NRM pillars, it is time to wrap up and present the numbers to your management. You would like to present a waterfall graph to show how your initiatives will have an impact on the company's net sales of 2024.

Let's start by making a forecast for the net sales in 2024 without our NRM initiatives. We'll base ourselves on the market sales until 2022, extrapolate the current trend until 2024 and calculate what it represents in net sales. You will create the waterfall graph in the next exercise.

If you lost progress, close any open reports and load 3_3_forecasting.xlsx from the Workbooks folder.