Click on ‘Forecast Model’ to deep dive
Access the calculations behind the graphs by clicking here to see the numbers in an editable spreadsheet format.
Change how you want view data
You can view forecasts in daily/weekly/monthly forecast buckets while also
toggling the forecast horizon to 1 week/1 month/3 months/6 months.
Override the automated forecast with manual inputs
You have just received information that AR inflows from EMEA will fall by ~20% between Jun 22 to Jul 26 due to supply chain issues.
Use filters for better visibility
Select region EMEA and also the countries whose forecast you want to change.
Manually add the changes to your forecast
In the ‘Manual Override’ column, change the value by entering an absolute number or a formula as shown here i.e., B7=-(0.2*B6)
-
Apply it over the cells, just like Excel
You can manually copy paste the formula from Jun 22(Col.B) to Jul 26(Col.F)
View the forecast with the changes
Once the values are modified, switch to the previous tab and toggle the ‘Manual Override’ button to see how the forecast has changed.
