Scenario Planning in Planning Maestro

Follow

You can use Planning Maestro to plan for different scenarios for your company.

Example.png Example: You could create scenarios in which you hire 10 more employees, gain 2% revenue and eliminate 3% of expenses, or add a new office.

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.

Example.png Example:

  • Budgeting for a 2% decrease in expenses involves your Account Number Dimension (specific expense GL Accounts).
  • Budgeting for a new office involves your Office Dimension and Account Number Dimension.
  • Hiring 10 more employees may involve a Personnel Dimension (if you have one) and Account Number Dimension (GL Accounts for wages, benefits, and taxes).

Creating Versions

After determining what scenarios you want to run and which Dimensions involve those scenarios, create Versions to represent those scenarios.

Warning.png Please Note: You cannot delete or rename a Version from a Plan after creating it.

Step 1: To create new Versions, click on the icon in the top left and select Data Modeler.

DA1a.png

Step 2: The Data Modeler landing page opens. Under Connect, click on the dropdown menu and select a Profile. Click Connect.

Select a Profile:

D1b.png

Click Connect:

D1c.png

Step 3: A confirmation message appears. Under Model, select Manage Dimensions.

D1d.png

Step 4: The Dimensions page opens. Select the Version Dimension.

S1c.png

Step 5: Your Version Dimension opens in a panel on the right with the Members tab open. Select New Member.

S1d.png

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.

S1d1.png

Repeat steps 5 and 6 to add all necessary Versions.

Step 7: Click Save & Exit.

S1e.png

Step 8: To add these new Versions to your Plan, redeploy your Plan. Click the Deploy icon ( Deploy_data.png ) on the left.

S1g.png

Step 9: On the Deploy Data page, click Deploy to redeploy the Plan with the new Version(s).

S2a.png

Step 10: A confirmation message appears. Click Confirm.

S2b.png

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.

DA1c.png

Step 2: On the Planning page, select Copy Data/What If?.

S2e.png

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.

Info.png Please Note: You can copy data from your Actuals for this year to your current budget to make a Version that includes Actual and budgetary data. For example, you can create a Version that uses Actual data for Periods 1-3 and budgetary data for Periods 4-12.

S2f.png

Step 4: In the Account Number Dimension, select the first set of account numbers involved in this scenario.

Info.png Please Note: A best practice is to collapse account groups (such as Assets or Liabilities) you do not want to choose from to make the list shorter and easier to scroll.

S2g.png

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.

S2h.png

Step 6: Click on the dropdown menu next to Destination Version and select the first scenario you want to plan for.

S2i.png

Step 7: To copy data only from certain periods, click Select Periods.

Example.png Example: It is Period 6 of your fiscal year. You want to replace your budgeted data for Periods 1-5 with Actual data. You can copy Periods 1-5 from your Actuals Version to your working budget Version.

S6a.png

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.

Example.png Example: In these screenshots, data from Periods 1-3 of the Actuals Version is copied to the Plan Basis Version.

S5a.png

Confirmation messages appear.

S6b.png

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.

Info.png Please Note: Changing values is most useful when you are creating new scenarios based on your original budget. If you are copying data from your Actuals, you most likely do not have to change any values within that data.

S6c.png

Warning.png Please Note: The Change Values tool is useful for global changes to multiple records, but not as useful for smaller, specific changes. If your scenario requires many detailed changes to your records, copy your data without using Change Values and use the Planning applications to make the changes.

Step 8: In the Change Values pane, decide how you want to shape the data for this Version:

S2k.png

  • 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.

S2l.png

Step 10: On the preview pane, scroll right to see the original and changed values for every record in the copy.

S2m.png

Step 11: Click Copy Data/What If?.

S2n.png

A confirmation message appears. Click Confirm.

S2o.png

Your data is copied.

S2p.png

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.

DA1d.png

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).

S3b.png

Step 3: On the Report page, click on the Expand icon ( Expand_report.png ) to widen the page.

S3c.png

Step 4: Drag the Version Dimension to the column section, to the right of the Time Dimension.

S3d.png

Step 5: Click on the filter for the Version Dimension to select the Versions you want to compare.

S3e.png

Step 6: On the Select Subsets popup, click Manage Subsets.

S3e1.png

Step 7: A list of available Versions appears. Select the Versions you want to compare and click Save As.

S3f.png

Step 8: A Save Subset As popup appears. Name this view and click Save Subset.

S3g.png

Step 9: On the report page, click the Rerun Report button ( Rerun_report_-_highlighted.png ).

S3i.png

The Versions you want to compare appear below under the Calendar view.

S3h.png

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).

S3j.png

2 out of 2 found this helpful

Comments

1 comment
  • Very helpful in describing how to create a new version and bring source data over to it.

    0
    Comment actions Permalink

Please sign in to leave a comment.