You can use Planning Maestro to plan for different scenarios for your company.
|
To run different scenarios in Planning Maestro, use your Dimensions (the building blocks of your budget, such as departments and account numbers) and Versions (scenarios of data).
This document shows you, a Planning Maestro Administrator, how to run different scenarios in Planning Maestro.
Creating Scenarios
When you scenario-plan with Planning Maestro, first determine how the various scenarios you want to test work with your Dimensions.
Your Planning Maestro Dimensions are the building blocks of your company: your account numbers, departments, offices, cost centers, etc.
When you map out your scenarios, determine which Dimensions you want to use when you run scenarios.
|
Creating Versions
After determining what scenarios you want to run and which Dimensions involve those scenarios, create Versions to represent those scenarios.
|
Step 1: To create new Versions, click on the icon in the top left and select Data Modeler.
Step 2: The Data Modeler landing page opens. Under Connect, click on the dropdown menu and select a Profile. Click Connect.
Select a Profile:
Click Connect:
Step 3: A confirmation message appears. Under Model, select Manage Dimensions.
Step 4: The Dimensions page opens. Select the Version Dimension.
Step 5: Your Version Dimension opens in a panel on the right with the Members tab open. Select New Member.
Step 6: A new row appears in the table. Give the new Version a clear name that will help you remember which scenario it represents.
Repeat steps 5 and 6 to add all necessary Versions.
Step 7: Click Save & Exit.
Step 8: To add these new Versions to your Plan, redeploy your Plan. Click the Deploy icon ( ) on the left.
Step 9: On the Deploy Data page, click Deploy to redeploy the Plan with the new Version(s).
Step 10: A confirmation message appears. Click Confirm.
A confirmation message appears. The new Version(s) are now a part of your Plan.
Now, use the Copy Data/What If? tool to add data to these Versions.
Adding Data to Versions
To compare scenarios, add data to your newly-created Versions. Use the Copy Data/What If? tool to take a standard set of data and manipulate it.
Step 1: Click on the icon in the top left and select Planning.
Step 2: On the Planning page, select Copy Data/What If?.
Step 3: On the Copy Data/What If? page, select the master Version you want to use data from (usually your Actuals or Plan Basis, your original budget for the year). This should be the Version that is your baseline, the data you want to manipulate to create other scenarios.
Step 4: In the Account Number Dimension, select the first set of account numbers involved in this scenario.
|
Step 5: Select other Dimension Members linked to line items you want to copy (for example, if you want to copy line items linked to one of the offices in your Office Dimension, select it here).
Then, click Add to Preview.
Step 6: Click on the dropdown menu next to Destination Version and select the first scenario you want to plan for.
Step 7: To copy data only from certain periods, click Select Periods.
|
A Select Data popup appears.
- Under Source, enter the starting and ending periods from the Version you are copying from (Actuals or another Version).
- Under Destination, enter the date range you want this data to have in your Destination Version.
- Click Apply.
|
Confirmation messages appear.
To make a global change to all these records as you copy them (for example, add $10,000 or 5% to each record), select all records in this Preview and click Change Values.
|
|
Step 8: In the Change Values pane, decide how you want to shape the data for this Version:
- Inc/Dec (% or Value) – To increase or decrease these records, enter a number or a number with a percent sign. Add a negative sign (-) before numbers or percentages that should decrease these records.
- Start (optional) – Enter a start date for the increase or decrease. Leave this field blank to simply use the record’s original start date.
- End (optional) – Enter an end date for the increase or decrease. Leave this field blank to simply use the record’s original end date.
- Input Type – Click on this dropdown menu and select which information within the records you want to change (usually just the Amount). For example, you could change the Headcount of a Personnel record.
Step 9: Then, click Apply.
Step 10: On the preview pane, scroll right to see the original and changed values for every record in the copy.
Step 11: Click Copy Data/What If?.
A confirmation message appears. Click Confirm.
Your data is copied.
To view the copied records for this Version, open one of the Planning applications and filter for this scenario’s Version.
Repeat steps 1-11 to copy data to the other scenarios you have planned.
After copying the data to your scenarios, you can compare your scenarios with each other in the Planning applications and in reports. To run reports that compare your scenarios, use the Reports modules.
Reporting with Different Versions
In Planning Maestro, you can run Ad Hoc and Income Statement reports to compare your scenarios.
Step 1: To run a report, click on the icon in the top left and select Reports.
Step 2: On the Reports page, click on the dropdown menu and select Ad Hoc or Income Statement (this document uses an Income Statement report as an example).
Step 3: On the Report page, click on the Expand icon ( ) to widen the page.
Step 4: Drag the Version Dimension to the column section, to the right of the Time Dimension.
Step 5: Click on the filter for the Version Dimension to select the Versions you want to compare.
Step 6: On the Select Subsets popup, click Manage Subsets.
Step 7: A list of available Versions appears. Select the Versions you want to compare and click Save As.
Step 8: A Save Subset As popup appears. Name this view and click Save Subset.
Step 9: On the report page, click the Rerun Report button ( ).
The Versions you want to compare appear below under the Calendar view.
The Versions you selected appear side by side in the table, allowing you to compare the numbers for the year, quarters, and periods (however you set up your Calendar view).
Comments
Very helpful in describing how to create a new version and bring source data over to it.
Please sign in to leave a comment.