Seeding the Plan

In the ordinary course of business the forecast would be completed with due diligence using the planning drivers and phasing that represent the behaviour of the account over the financial year. Using the [Set Planning Drivers] function the planning drivers and phasing can be quickly populated. In this walk-through we are using the Previous Year Estimate plus % to calculate a 5% increase on last year’s revenue. The full year estimate is going to be spread over the forecast months using last year’s monthly phasing.

A similar process can seed the drivers for Year 2 of the Forecast.

Why filter the seeding of the drivers by Version and Year? Apliqo FPM will evaluate any account that has a Driver Method. Even if the full year estimate is zero. The more business segments and accounts that have a Driver Methods the more processing time required to get a result. As the Previous Year Estimate plus X% driver method only has a non-zero result when the previous year has a non-result result. I can use the previous year’s actual/forecast to identify which accounts will have a non-zero result in the current year and only process those accounts.

Exercise

Seed the Expenses using the same drivers.