Skip to main content
AnaplanFP&AIInsights

Anaplan Demo – How to FP&AI 003: Saving Time with Scenario Rollforward

By September 25, 2023October 6th, 2023No Comments
Saving Time with Scenario Rollforward

The biggest benefit of FP&A tech is SAVING TIME for both you and your planners.

One of the best ways to do that: automating your scenario roll-forward process.

-> Budget
-> 0+12
-> 3+9
-> 6+6
-> 9+3
..repeat

In this video, we’ll show you how FP&AI helps you do that in seconds, not days.

And how it rolls forward at levels of detail that would be time-prohibitive in Excel or other tools.

Constellaition’s FP&AI solution is an enterprise budgeting and forecasting application built on the Anaplan platform.  Leverage your business data combined with our Anaplan / FP&A experience for a flexible and future-proof foundation – without having to break the bank or reinvent the wheel.  Click the link below to find out more.

Timestamp Captions 00:01 – 00:05 Hi there, I’m Zaf Kamar and I’m back with another episode 00:05 – 00:08 of our series How to FP&AI. In today’s video, I’ll show 00:08 – 00:11 you how easy it is to roll your planning scenarios forward 00:11 – 00:14 into the next plan with our FP&AI solution. This 00:14 – 00:17 functionality is in place to save you and your planners 00:17 – 00:20 time for you in corporate FP&A being able to roll forward a 00:20 – 00:23 plan in seconds rather than days or weeks, and for your 00:23 – 00:26 planners enabling them to start their budget from their 00:26 – 00:30 latest plan rather than from a blank spreadsheet, let’s get 00:30 – 00:31 started. 00:31 – 00:34 We’ll start off here in our FP&AI application in our 00:34 – 00:38 planning home base, a 1.1 so that we can see at the start 00:38 – 00:41 of the planning season Both my next year budget and my 00:41 – 00:43 target are 0. 00:43 – 00:44 There’s nothing in it. 00:44 – 00:47 And will further reinforce that here by going into our 00:47 – 00:50 operating expense planning section where we’ll see for our 00:50 – 00:53 operating expense accounts. We also have that same next 00:53 – 00:55 year budget, next year target zero and I’ll Scroll down 00:55 – 01:00 into our input sections where we can see the same thing. 01:00 – 01:03 Next, we’ll head over into our Budget Administration 01:03 – 01:06 section. Why 3.2 To show you how we roll our plans forward. 01:06 – 01:10 On this screen, app administrators are able to execute a 01:10 – 01:13 scenario launched or scenario roll forward. Basically, this 01:13 – 01:16 means that you precede the budget with either your current 01:16 – 01:19 year forecast or your current year budget. 01:19 – 01:23 I’ll go ahead a year and in my budget seating I will select 01:23 – 01:27 my current year forecast and I’ll set it to. 01:27 – 01:31 Spread according to my current year forecast as well. 01:32 – 01:35 I’ll Scroll down next and I’ll ignore all of the Zero based 01:35 – 01:38 functionality here. That’ll be a topic for the next video, 01:38 – 01:41 and we’ll take a look at these two buttons on the bottom 01:41 – 01:45 here. Roll forward to target, roll forward to budget. 01:45 – 01:49 I’ll go ahead and I’ll click roll forward to target. 01:51 – 01:53 And that process is completed. 01:53 – 01:57 And then I’ll click Rule Forward to Budget. 01:59 – 02:01 Alright, and just a couple of seconds later I will see that 02:01 – 02:03 this process has completed as well. 02:03 – 02:07 Now go back to the planning section of the application. 02:07 – 02:08 A 1.1. 02:08 – 02:11 And what I’ll be able to see here is that now my next year 02:11 – 02:14 budget and next year targets have information in them and 02:14 – 02:17 more than that, they also have information that is 02:17 – 02:20 identical to the current year forecast. 02:20 – 02:23 I’ll save target setting for another video as well. Let’s 02:23 – 02:26 go back into the operating expense planning section to see 02:26 – 02:28 what the system has done. 02:28 – 02:31 Now as I Scroll down here what we can see is that the 02:31 – 02:34 system has automatically preceded values into this amount 02:34 – 02:37 column and into the spread column where there was no 02:37 – 02:41 information before. And what the system has done is it has 02:41 – 02:44 taken my current year actual forecast numbers and it has 02:44 – 02:48 pre loaded it into the amounts here at the account level. 02:48 – 02:51 And that’s going to give me a really great starting point 02:51 – 02:54 for my budget. And now I can take this information and I 02:54 – 02:57 can, you know, increase it by 5 percent, 4%, right. And I 02:57 – 03:00 can go ahead and and start planning. Now what the system 03:00 – 03:03 has also done as I Scroll down here is there’s another 03:03 – 03:07 detailed section in here. And in addition to just preceding 03:07 – 03:10 the information at the department level, the entity level 03:10 – 03:13 and the account level, it’s also gone down to the line item 03:13 – 03:16 level and has preceded all of my vendor level information. 03:16 – 03:19 And I’ll tell you in the solution that FP&AI rolls 03:19 – 03:22 forward at the vendor, project, customer, product, and 03:22 – 03:25 employee levels. In addition to the standard entity, 03:25 – 03:28 department, account functionality at the top, this 03:28 – 03:31 functionality offered by FP&AI is ultimately designed to 03:31 – 03:35 save you and your users time in the planning process. Doing 03:35 – 03:38 this in Excel could take weeks to being otherwise 03:38 – 03:41 practically impossible. Use FP&AI to instead spend your 03:41 – 03:45 time fostering deeper connections with the field, figuring 03:45 – 03:48 out creative ways to cross sell lower expenses, and so much 03:48 – 03:49 more. 03:49 – 03:53 That’s all for today. I’ll see you in the next video.

Leave a Reply