How to Create a Scenario Based on Actual Data

Written by Matthew Cawthra

About

When creating Scenarios, FUTRLI allows you to use previous months data to create an accurate Forecast. There is no need to create a Formula to calculate this, it can be done using a monthly Growth Rate method (which can be copied to other Accounts) in the Scenario’s Forecast Methods.

Step One

Once in the Scenarios section of FUTRLI, select the Scenario that requires the Forecast, then add an Account Line to any Account Group by clicking the green cross:

Screen Shot 2017-01-18 at 16.17.58

Step Two

This will bring up the Forecast Method builder. Name your Forecast and select ‘Set Monthly Growth Rate’ as the Method type. You then enter the Forecast details. You will need to enter a Increase/Decrease amount, you cannot enter zero. 0.01% is the smallest number you can go forward with. You then select ‘An average of the last 3 months data for the account’ to base calculations on. There is also an option for 6 and 12 months. Then complete the rest of the Forecast details as you like:

Screen Shot 2017-01-18 at 16.19.46

Step Three

Once you save changes, the Forecast will appear in the Account Group. Click on the green cog to open the options, which will include the option to copy this Forecast Method to other Accounts:

Screen Shot 2017-01-18 at 16.21.11

Step Four

By clicking on the green cog, you will be able to copy this Forecast to other Account Lines that are searched for in the search engine adjacent to Copy to:

Screen Shot 2016-10-27 at 11.02.48