6. Planning, budgeting & forecasting
Lumel EPM provides various enterprise-grade features for planning, budgeting, and forecasting. There are numerous customization options available, allowing business users to quickly generate plan and forecast workflows in a user-friendly interface without having to write any code.
This section covers all of them in detail.
What-if analysis & simulations - With Lumel EPM, you can create what-if scenarios and quick forecasts on the fly using a graphical slider to simulate and roll up or spread down changes in hierarchies. To learn more, refer to what-if analysis & simulations.
Scenarios - Lumel EPM offers the ability to create new scenarios in edit and read modes based on an existing series for ad hoc analysis. To learn more, refer to scenarios.
Budgeting & allocations - Lumel EPM provides a great way to create quick sales forecasts, business plans, or financial budgets. While using hierarchies, you can spread data entered on a parent cell to its descendants (rows & columns), based on weights from other measures. To learn more, refer to budgeting & allocations.
Forecasting - Lumel EPM allows you to perform rolling forecasts and re-forecasts with methods such as period range, average of period range, and so on. You can use the integrated time intelligence and time extension features to generate half-yearly or fiscal period forecasts. Once you obtain the actuals, you can automatically close the forecast, update it, distribute deficits, and extend projections. For further information, see Forecasting.
Set version - 'Set version' can be used to compare two or more measures in the report and calculate absolute and percentage variances automatically. Lumel EPM also provides a one-click variance analysis of different business scenarios. To learn more, refer to the set version.
Last updated