$\backslash$table$[[1,],[,2024$ Data,$2025$ Data,$2026$ Data,$],[$Basis$,2023,2024,2025,],[\backslash$table$[[$Revenue$],[$change$]],6\mathrm{.}0\%,3\mathrm{.}0\%,4\mathrm{.}0\%,],[$Profit change,$4\%,2\%,2\%,],[,]]$

A company sells its products in $4$ regions Mid West, North East, South and West.

The company has a list of Retailer types and customers with data on Revenues and Profits for $2023.$

The company wants you to estimate Revenue and profits for $2024,2025$ and $2026.$

There are different conditions for the estimation:

a$)$ The company wants to be able to change Revenue and Profit based on a previous year's data

b$)$ The rate of change will be an input. The company wants a situation where the changes can be altered and the new results reflect immediately

Questions:

Using appropriate function, write a formula that is dynamic such that the change reflects immediately on the data. Calculate the data for $2024,2025$ and $2026.$ This calculation should be done in the DATA tab.

Plot dynamic tables and charts as indicated in the dashboard tab for $2023,2024,2025$ and $2026.$ The data required is in the. DATA tab

Create a PowerPoint slide deck and put all the tables and chards plotted in $2$ above, each set of table and chart in one slide