Procurement Practice#3: NPV Analysis and Opportunity Cost



Financial analysis in procurement negotiation strategies

In our earlier posts, we discussed the applications of the NPV analysis method and opportunity cost in developing strategic procurement insights. We aim to showcase the combined use of financial analysis in procurement to craft your negotiation strategies. 

Base Scenario: Upgrade of a Key Component

This business case presents the opportunity for a financial decision analysis of upgrading a key component in a new product line over three years. The focus is on calculating the Net Present Value (NPV) of such an upgrade and comparing it with alternative investment opportunities.

Scenario Overview (3 Years):

Implementation Costs: $500,000 (one-time)
Original Component Cost: $50/unit
Upgraded Component Cost: $70/unit
Annual Volume: 100,000 units
Sales Increase Due to Upgrade: 5%
Potential price increase: 2%
Supply Chain Risk Impact: 10% probability of $2M impact
Current annual product revenue: 100M
Profit margin: 20%
Discount Rate: 10%

Detailed NPV Calculations (3 Years):

Incremental Cost Per Year = 100,000 * ($70-$50) = $2M
Total NPV of Incremental Costs (3 years) = NPV (10%, 2000000, 2000000, 2000000) = $4.97M (we used the NPV formula in Excel just as presented.)
NPV of Supply Chain Risk (3 years) = NPV (10%, 200000, 200000, 200000) = $0.5M
TOTAL COST = $4.97M + $0.5M +$0.5M (implementation)= $5.97M

NPV of Increased Sales (5% Increase, 3 years) = NPV (10%, 1000000, 1000000, 1000000) = $2.49M
NPV of Price Premium (2% Increase, 3 years) = NPV (10%, 400000, 400000, 400000) = $0.99M
TOTAL BENEFITS = $2.49M + $0.99M = $3.48M
Net NPV Impact: $3.48M - $5.97M = -$2.49M

Alternative Scenarios and Opportunity Cost

Let's go one step further than declaring the negative NPV of the base scenario and hence our recommendation not to pursue it.
Before jumping to conclusions, we will review three alternative scenarios and calculate the opportunity cost.

Alternative Scenario #1 "Marketing Campaign to Boost Sales of Existing Products."

Cost: $2.7M (one-time)
Estimated Revenue Increase: $4M per year
Profit Margin: 20%
NPV of Profits Over 3 Years = NPV (10%, 800000, 800000, 800000) – $2.7M = -$0,71M
Opportunity Cost: $-0.71M - (-$2.49M) = $1.78M

Alternative Scenario #2 "R&D for a New Product"

Cost: $4M (one-time)
Estimated Revenue Increase: $18M (over 3 years, we assume it’s $5M in year 1, $6M in year 2, and $7M in year 3)
Expected Profit Margin: 25%
NPV of Profit After 3 Years = NPV (10%, 1250000, 1500000, 1750000) - $4M = - $0.3M
Opportunity Cost: -$ 0.3M - (-$2.49M) = $2.19M

Alternative Scenario #3 "Cost Reduction Initiative"

Cost: $2M (one-time)
Savings Per Year: $1M
Profit Margin: 20%   
Savings @ 20% profit margin = $1M (profit)
NPV of Profits Over 3 Years = NPV (10%, 1000000, 1000000, 1000000) – $2M = $0,49M
Opportunity Cost: $0.49M - (-$2.49M) = $2.98M

Financial decision analysis

The NPV analysis of upgrading a key component over 3 years shows a net negative NPV impact of (—$2.49M). 
The opportunity cost of not pursuing alternative investments (like the marketing campaign or R&D) ranges from $1.78M to $2.98M.
Given the significant negative NPV impact and the high opportunity costs, the technical upgrade may not be the most financially sound decision. 
Alternative investments with positive NPVs and lower opportunity costs should be considered unless there are strategic reasons to justify the upgrade.

P.S. If you appreciate hundreds of hours invested in researching and writing this blog, you can buy me a coffee or subscribe for the membership by following this link. Thank you!

Buy me a coffee

                                          https://www.buymeacoffee.com/ukrsedo

To keep receiving new insights and research, please subscribe here. 




More information on this and other exciting topics can be found in "The Technology Procurement Handbook." It represents 23 years of experience, billions of dollars worth of successful sourcing projects, and 1000s hours spent on research, analysis, and content creation for the most demanding professional readers.
The Technology Procurement Handbook front page
 





 

Comments

Post a Comment

Popular Posts

The Importance of Supply Chain Collaboration

Image
  Why is supply chain collaboration essential? Once, I was asked what makes the supply chain important to a company. Our profession may not be rocket science. Other peers around the company overlap with us in their functions - Technology tends to manage suppliers , Finance owns the demand planning and budgeting , and Sales and Marketing monopolize the end-customer value chain.  These and other colleagues do not always appreciate us; some believe they are even better at our job.  Shadow procurement, supply chain, and logistics have become standards for many companies.  However, some critical differentiators - like collaboration - justify the very existence of our profession!  The supply chain is the most collaborative function in the business.  We find peers everywhere, even behind enemy lines. We welcome any opportunity to form a cross-functional team with anyone who can bring business value through supply chain strategies, sales  and operations planning,  inventory management,   B
Read more

The Discovery of Procurement Value

Image
Procurement value demystified Unfortunately, " procurement value " became another buzzword—everyone told us to generate, capture, and sustain it.  This post attempts to provide the most comprehensive view on procurement value and practical methods of its realization compared to many other web sources that replicate slogans and mystify logical and straightforward concepts.  The meaning of value Value is not substantive; it is rather adjectival. It characterizes something or results from its application. It doesn't exist in its raw form; it's being created. It's a universal differentiator between good and bad things or actions. This 1914 philosophical article defines value  as the object of proper judgment . How easy is it to explain the value? The value is equally apparent for those who know the truth.  Therefore, we will give different definitions and not pretend to have found the unilateral value formula. Value is paramount to procurement evolution. Th
Read more

Opportunity Cost vs. TCO in IT Outsourcing: An Example from British Airways

Image
When I came across the notion of the opportunity cost, I realized I was barely adding it to my TCO calculations.  The Notion of Opportunity Cost Opportunity cost is a fundamental economic concept representing the potential benefits an individual, investor, or business misses out on when choosing one alternative over another. In simpler terms, it's the value of the best alternative foregone. For instance, if a company decides to invest in a particular project, the opportunity cost is the value of what could have been achieved if those resources had been invested elsewhere. In procurement, failing to consider opportunity cost can lead to suboptimal decisions, as it neglects the potential gains that could have been realized through alternative investments or choices. IT Outsourcing at British Airways (research-based assumptions) In 2016, British Airways outsourced its UK-based IT staff as part of its business strategy.  This outsourcing strategy allegedly resulted in a 2017 global
Read more