Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • AI / ML FP&A Committee
    • FP&A Trends Digest
    • FP&A Talks Series
    • FP&A Trends E-Books
    • Our Authors
  • FP&A Board
    • Amsterdam
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • New York
    • Paris
    • Perth
    • San Francisco
    • Seattle
    • Shanghai
    • Singapore
    • Stockholm
    • Sydney
    • Tokyo
    • Toronto
    • Washington D.C.
    • Zurich
  • Webinars
    • FP&A Board Connect
  • FP&A Videos
  • About Us
    • Privacy Policy
    • Company Policy
    • Editorial Guidelines
    • Our Sponsors & Partners
  • Contact Us
This block is broken or missing. You may be missing content or you might need to enable the original module.
FP&A Empowerment Survey 2021

FP&A Empowerment Survey 2021

Click here to view details and register

 

P&L Management: Resource Allocation Story
March 31, 2021

By Alexander Antonov, Freelance Project Manager/ Associate Professor

FP&A Tags
Financial Planning and Analysis

p&l This article is part of the series ‘P&L Management: from Bean Counting to Value Creating’ that focuses on demonstrating how finance can shed light on important business drivers, revitalize figures and make them tell a story, creating value for the company. Using P&L as a map for the journey (see image 1 below), the first four articles explored five initial steps focusing on the pre-P&L analysis, price management, gross-to-net (GTN) and marginality. 

In this article, we will move to the bottom line of P&L considering how finance can guide management in resource allocation and drive business profitability.

P&L Map​

Image 1. The P&L Map for value-creating journey

Approach to resource allocation

An objective of resource allocation is to distribute a company’s limited resources in a meaningful way to achieve its strategic goals and do it most efficiently. Usually, the process is done in four stages, starting with the Strategy of figuring out how to create and offer the most value to customers at the least cost, proceeding with its Execution on the Strategy, followed by Measuring outcome and closing the loop with Evaluating results, learning and making necessary adjustments (see image 2 below). Although each stage is important, this article will focus on performance measurement. 

process​

Image 2. Process of Resource Allocation

As shown in Image 2, the resources of an FMCG company usually consist of spends on advertisement and promotion (A&P), Field Force (FF), and Gross-To-Net (GTN). Due to the task complexity, it is worth considering a system for measuring the effectiveness and efficiency of utilization of each resource separately. This article presents how such a system can be built on the example of the promo-actions, which, according to Simon-Kucher and Partners, are of raising significance in the FMCG world due to three factors:

  • Shoppers more hooked on promotions than ever 
  • FMCG manufacturers invest 2-3 times more in promotion than in advertisement
  • …but with poor return: 6 out of 10 FMCG promotions in Europe don’t break even.

In addition, the effect from promotions is difficult to estimate due to stockpiling and cross-channel cannibalization (materials of the 2nd SKP European Strategy Forum, 2015). 

Approach to increase effectiveness of promo activities

The following approach to boost effectiveness and efficiency of promo actions was successfully applied first in an FMCG company and then in a pharmaceutical one:

  1. Implement a procedure requiring pre- and post-evaluation of promotions with documentation of lessons learned
  2. Understand the effectiveness of each promotional method and find out performance drivers
  3. Integrate learnings into rules and guidelines to design more effective promotional activities.

profitable​

Image 3. Classification of promo actions

In order to classify promo actions as presented in image 3, it is critical to design a tool to measure both Sales uplift and ROI. In the tool shown in image 4, the measurement is based on a difference in volume between historic trend (projection of the market and company dynamics from the previous periods), and actual performance versus the market. The volume difference between projection and actual performance vs. market is used to calculate incremental Sales and Profit as a result of a marketing activity. In this case, volume data should be taken from an external source (e.g., Nielsen or IMS), while internal data are used for a price, discounts, product margin and campaign cost.
 

tool​

Image 4. Tool for evaluation of effectiveness of promo actions

Example of the tool application

Let’s assume that a company sells goods priced at €10, sales volume is 1 million pieces per quarter and margin is 50%. During a promo-campaign, a company gives a 10% discount and additionally invest €1 million in the promo action. In order to reach a break-even for sales, the company should sell by ca. 11% more goods, while to achieve a break-even for profit, it requires a 50% volume growth (see the table below). Knowing these data is instrumental for setting a goal for a promo-action as for its post-evaluation.

tool​

The volume change is estimated as follows: let’s assume that in the previous period the market grew 5% in volume terms while company sales (in pieces) increased only by 2% (or -3% vs. market). In the period when the promo activity was performed the market growth slowed down to 4%, while the sales volume of the company’s products increased to 5%. So, incremental volume can be calculated as a difference between the actual 5% volume surge and the projected 1% increment (calculated as 4% of the market growth minus 3% taken from the historical trend). 

It is critical to use external data for volume changes, which allow to reduce effects of stockpiling of distributors and compare it with total market dynamics that neutralize external factors influencing the whole industry.

The next step is to gather and analyze data to understand the influence of each factor and their interplay on the action success. These factors can include, e.g., price position, deepness of discounts, price bundling, shelf stoppers, flyers, displays as well as actions of competitors. Finding their right combinations allows a company to not only weed out the value destroying promos, but also to integrate learnings into rules and guidelines to help account managers design more effective promo activities.

Building a similar approach for Field Force, GTN and advertisement, a company creates a strong fundament for a system where resources are allocated based on facts and not on subjective preferences and opinions of those who shout louder to receive better pieces.

Resource Allocation utilizing ROI

Profit, and especially Return on Sales (ROS), can be also used for Resource Allocation as they allow looking at the company performance from a somewhat unfamiliar side. Image 5 shows the contribution of product groups to the company profit: Sales of each group are presented on axis X and ROS on axis Y, hence the rectangle’s area is equal to the profit contribution of the product group. The sales growth marker at the top of each bar adds insight into dynamics, which helps to understand in what direction company profitability is moving. For example, in the presented case product groups with above-average profitability are declining, while growth is coming from the products with lower margin, which is leading to the deterioration of the total company’s profitability.

resource​

Image 5. Resource allocation tool based on product profitability

Resume

This article closes the series on P&L Management, which is built on the idea of synergy: to achieve a better outcome, business tools and techniques should be interconnected and leverage each other.

Finance, which often struggles to create a positive and creative image as it concentrates its attention on constraints and limitations, can use this approach to take initiative and drive results. Instead of focusing on constraints, Finance executives can look at opportunities, storytelling, taking P&L as a core of its narrative. 

It makes sense to start this story with an exploration of the business environment and then to analyze a company’s market performance using Evolution Index to create a context for the following P&L deep-dive.

A search for new ways to foster a company’s top-line growth starts with strategy and pricing while often ends up with the business model revision, i.e. reviewing the value proposition, value creation and value capturing. Such a model overhaul should lead to focus the whole organization on value creation for the customer.

Each industry and market require the development of its own and specific approach to the business model revision. Having understood price and value drivers, a B2B division of a pharmaceutical company developed pricing tools and procedures which helped steadily improve business profitability over years.

This overarching P&L Management approach is further specified in the review of P&L lines to examine how utilization of each resource contributes to increasing the effectiveness and efficiency of a company’s business model. E.g., GTN can be used to enhance the value proposition, while improving the accuracy of the sales forecast and reducing write-offs can increase the efficiency of the value creation.

Finally, Finance can further advance the business model by establishing a system for effective fact-based resource allocation to avoid their distribution hinged on opinions and internal politics. This contributes to the creation of corporate governance, a system of checks and balances ensuring that an organization is stronger than individuals who happen to be leading it at any time.

A regular journey along P&L, done in a systematic way, offers managers new insights into their business. A regular application of the tools makes them interconnected and amplify their effect. This allows the company to constantly and consistently improve effectiveness and efficiency of its business model, and ultimately build an edge versus the competition. And Finance can rigorously steer the whole process skillfully applying its P&L-connected toolkit!
 

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Related articles

sales
P&L Management: Driving Net Sales and Improving Marginality
February 25, 2021

Using P&L as a map for the journey (see image 1 below), the first three articles...

Read more
Pricing
P&L Management: Pricing in B2B and Commodity Markets
January 13, 2021

In this article, we will stay with the price and look at another example how it...

Read more
value
P&L Management: Value-Based Pricing
November 18, 2020

Price is a strong lever of the company performance, which is often underestimated. Having mastered price...

Read more
Creating Value
P&L Management: from Bean Counting to Creating Value
October 14, 2020

This series of articles focuses on blowing up this stereotype by demonstrating how Finance in general...

Read more
Dynamic FP&A: The Nuts and Bolts of Your P&L
August 17, 2018

P&L management focuses on the items included into P&L (profit and loss) report. It has become...

Read more
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

The FP&A Trends Webinar: Magnifying Revenue Planning for Better FP&A Insights

The FP&A Trends Webinar: Magnifying Revenue Planning for Better FP&A Insights

Click here to view details and register

Pagination

  • ‹‹ Previous
  • April 2021
  • Next ››
Su Mo Tu We Th Fr Sa
28
29
30
31
1
2
3
 
 
 
 
4
5
6
7
8
9
10
The Digital Pan-Asian FP&A Board: The Art and Science of xP&A Business Partnering
 
11
12
13
14
15
16
17
The Digital North American FP&A Board: From Traditional to Better and Beyond Budgeting
 
18
19
20
21
22
23
24
The FP&A Trends Webinar: Embracing FP&A Transformation. Key Steps to Consider
 
The Digital London FP&A Circle: Empowering FP&A to Close the "Strategy - Execution" Gap
 
25
26
27
28
29
30
1
The FP&A Trends Webinar: The Combined Power of Human and Artificial Intelligence in FP&A: Roche Case Study
 
The FP&A Trends Webinar. Dynamic and Immediate Revenue Planning in Uncertain Environment: Insights from Microsoft and Emirates Airline
 
 
All events for the year

Future Meetings

FP&A Transformation
The FP&A Trends Webinar: Embracing FP&A Transformation. Key Steps to Consider
April 20, 2021
Digital London FP&A Circle
The Digital London FP&A Circle: Empowering FP&A to Close the "Strategy - Execution" Gap
April 22, 2021
The Combined Power of Human Intelligence and AI in FP&A
The FP&A Trends Webinar: The Combined Power of Human and Artificial Intelligence in FP&A: Roche Case Study
April 27, 2021
Revenue Planning
The FP&A Trends Webinar. Dynamic and Immediate Revenue Planning in Uncertain Environment: Insights from Microsoft and Emirates Airline
April 28, 2021
The Digital Swiss FP&A Board
The Digital Swiss FP&A Board: Building Winning FP&A Teams
May 6, 2021
The Digital Benelux FP&A Board
The Digital Benelux FP&A Board: The Art and Science of FP&A Storytelling
May 11, 2021
FP&A Predictive Analytics
The FP&A Trends Webinar: How to Manage Uncertainty with FP&A Predictive Analytics
May 12, 2021
xP&A Business Partnering
The Digital Pan-Australian FP&A Board: The Art and Science of xP&A Business Partnering
May 13, 2021
FP&A Scenario Planning
The Digital Middle Eastern FP&A Board: The Power of FP&A Scenario Planning
May 24, 2021
The Digital Nordic FP&A Board
The Digital Nordic FP&A Board: The Art and Science of Digitised FP&A Business Partnering
May 25, 2021
Advanced AnalyticsArtificial Intelligence (AI)Behavioural FinanceBetter BudgetingBeyond BudgetingBig DataBrexitCash PlanningCollaborative PlanningCorporate Performance Management (CPM)Cost PlanningCOVID-19DashboardsData ManagementData QualityData VisualisationDriver Based PlanningExtended Planning & Analysis (xP&A)Financial Planning and AnalysisForecasting QualityFP&A AnalyticsFP&A Business EnvironmentFP&A Business PartneringFP&A Case StudiesFP&A DigitalisationFP&A Maturity ModelsFP&A PeopleFP&A SkillsFP&A StorytellingFP&A Talks SeriesFP&A TechnologyFP&A TransformationFP&A Trends E-BooksFP&A Trends InitiativesIntegrated FP&AKey Performance Indictators (KPI)Machine Learning (ML)Management AccountingModelling and ForecastingPlanning and BudgetingPredictive AnalyticsProfitability AnalysisRisk ManagementRobotic Process Automation (RPA)Rolling ForecastScenario PlanningStrategic FinanceStrategic PlanningTeam BuildingWhat is FP&AZero-Based Budgeting (ZBB)

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • Webinars
  • FP&A Videos

Footer countries

  • Amsterdam
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2021 fpa-trends.com. All rights reserved.

0