What If Scenarios/Flexing Tips
How to Amend Later Years Data
Do You Know How To Do What If?'s In WinForecast?
Return to List of Topics
How to Amend Later Years Data
When a forecast covers more than one year, you can amend some of the later years' data based on earlier
data. You can do this for the whole forecast, or for the section, sub-section or record highlighted in
the main list of Records.
How to Do It
- From the main screen's menu select Wizards>Amend Later Years Data.
- Select whether to Amend forecast or to Amend [the named section, sub-section or record].
- Specify From when To when the amending is to apply and select to Amend With Data From...- the base data used for amending comes from either the previous year, half-year or quarter as selected.
- Specify the changes to the various types of data that you wish to apply in the Amend (100% no change) boxes.
Back to the top
Do You Know How To Do What If?'s In WinForecast?
In WinForecast you can Flex your data, allowing you to investigate various what if? type scenarios, while keeping your underlying data unchanged.
You can apply a flex up to 999% or down to 1% from 100% which is "unchanged", to a section of records, a sub-section (ie subtotal inc sub items), a single record or different flexed amounts at all 3 levels.
Flexing can only be applied to P&L records/sections, ie Income, Costs, Overheads and Other Income.
How to do it
- From the list of records select the appropriate record or section of records and go to DATA>FLEX then choose the period that you would like to Flex From / To.
- In the Flex section on your main screen, enter the amount of the flex you wish to apply.
- You have now put your Forecast into a temporary mode.
- When you view your reports, the figures showing will be the flexed amount.
- If you are happy with the results you can then go into DATA>FLEX>FLEX DATA AS or in the case when you are not happy with the results you can go into DATA>FLEX>UNFLEX.
- By using File>Save As, you can create a range of budgets showing, good vs bad case situations.
NOTE: While you are in flex mode, you can not extend your forecast or set for actuals.
Back to the top
|
