Load your HR FTE and part-time into the model.
Highlight the cells you want to change, and use the Power Planner Calculate function to give % increase to employees.
it supports any type of arithmetic function, with audit trail.
Add new members on the fly.
In the Power Planner Ribbon, you can open any SQL table, edit the members, add new products on the fly, and reprocess the model.
Select the table to edit. New members are automatically added to the Budget model.
Click Insert Row, and Save the table and the model is regenerated.
Any Pivot Table you can now turn into a Budgeting, Forecasting or Planning solution!
– Multi User Budgeting and Forecasting Features
– Goal Seeking on any number
– Even and Seasonal Allocations
– Revenue Forecasting
– HR Budgeting
– Capital Expenditure
– Driver based planning
– Collaboration and commenting
Go to our website for more information.
With Power Planner, you can take advantage of the Goal Seeking Feature. In this example we want seek a new amount for the number of units sold in order to read our targeted Gross Profit:
Set the Number of Units as the Target for the Goal Seeking:
Go to the P&L and adjust your Gross Profit to $13MM.
Your number of units have now been adjusted to meet the new Gross Profit Target!
You are now empowered to budget and forecast.
Excel Pivot Tables are still by far the preferred analytics tool for corporate America. A lot of companies have invested heavily in SQL and Pivot Tables.
With Power Pivot you can make your Pivot Solution into a budgeting solution with the click of a button: Here is how to get started:
Voila – you can now use your Excel Pivot Tables as a Budgeting System from inside Excel for everybody in your organization.
We provide pre-built solutions for Microsoft Dynamics GP/AX/NAV, MAS 500, Salesforce Data.