Grow your commercial planning by bringing people, data, and plans together. Plan and forecast for any revenue or cost type based on product and SKU drivers that matter to your business.
Understanding your drivers of revenue, allocating investments to influence outcomes, evaluating scenarios in real-time, and optimising and automating revenue performance will see a rise in your operational efficiencies, and a reduction in risk and cost.
To find out how Anaplan can help, contact us for a personalised demo.
Transcript
[Music] Hello, my name is Samuel, and welcome to Bedford Consulting Spotlight video on finance for CPG in Anaplan. Anaplan is the connected planning platform, and you can see here on this single report how we can get an overview of all of the key information across the entire organisation. In this report that is viewable on mobile devices, such as tablets or mobile phones, as well as laptops or desktops, we can see a breakdown of product category. Here, we can see that revenue breakdown showing us our food revenue, beverage revenue, clothes revenue, or household revenue, and we can see an annual revenue by region breakdown over here when we look at our North America, Europe, Asia, and South America revenue.
Top down target setting: With a focus on strategic top-down target setting, we can set those targets from our higher levels, in this case, our regions, and we can input an uplift on the basis of the prior year, so a seven percent uplift on the prior year sales. That can be then allocated down to the countries, and we can look at a more granular bottom-up approach as we start to look at our price book and now within those higher product categories that we were looking at before. We can go down to lower levels of granularity, for example, within food, we may look at fruit and veg, meat and fish, dairy, eggs, and chilled, and so on. Again, setting up lifts for the prior year basis and the future year target. We’re able to make our inputs here by percentage growth or by pound override or currency override, depending on where you are to drive our unit sales price.
Demand planning: In terms of our sales volumes, we can look at our demand planning, which is where we start to look at that connected planning approach, in that we combine the SNOP function or supply chain management function with the finance function as we start to leverage Anaplan’s predictive analytics capabilities.
Risks and opportunities: This will drive our baseline statistical forecast as we can see here, and we can then overlay that with our demand planner forecast as we input any risks and opportunities. For example, maybe they’re in relation to COVID and they’re lockdown-related, when restrictions will be lifted, and so on, or maybe they’re in relation to promotions, such as Valentine’s Day, Father’s Day, Mother’s Day, or even Easter promotions that we may see. We can choose which risks and opportunities we want to include in our scenarios, and you’ll notice that as I’m making changes on that which I include, there’s a real-time update in the numbers that we see in the charts that we’re seeing.
Supply planning: On the supply planning side, the key focus on this report is around capacity planning, and we’re able to see very quickly and very clearly where our ending inventory is getting close to or below our safety stock target levels. In that, we can then make decisions on reorder quantities or reorder schedules or any other changes that we may want to make to enable us to meet that demand that we’ve just calculated on the previous pages.
As we bring all of this together from our revenue piece, of course, we have a whole section around OPEX and also capex that we can pull in as well. In doing so, we would bring that together from a reporting perspective in our reporting summary so that we can look at our integrated financial statements.
Integrated financial statements here with our summary income statement, balance sheet, and cash flow, we can look in more detail at any of these. If we choose the income statement, we can look in more detail here at our income statement, seeing the breakdown across each of the versions that we have with a comparison version here in terms of budget versus scenario X. We can break down that revenue and cost of sales, for example, through channels, i.e., stores and online.
Analysis: In terms of analysis, as you’d imagine, we have comprehensive reporting around the comparison of versions or different time frames or even between products or product categories. In this case, we’re comparing actuals and forecasts with a breakdown of the variance that is due to operations and the variance that’s due to FX, for example.
So, as a whistle-stop tour of what Anaplan can do, we’re seeing that connected planning solution that is provided, connecting all of those functions across finance, SNOP, supply chain, and otherwise. If you’d like a more in-depth demo or a more tailored solution, then please don’t hesitate to get in touch. Thanks for watching and stay safe. [Music] you. English (auto-generated)
