Opportunity Cost Formula

Opportunity Cost Formula (Table of Contents)

Opportunity Cost Formula
Opportunity Cost Formula Calculator
Opportunity Cost Formula in Excel (With Excel Template)

Opportunity cost can be termed as the next best alternative of a particular option which has been executed or about to execute. It can be a project foreign investment or a particular option taken by a group of people or an individual for personal purpose or for a business purpose. It is a hypothetical assumption and often measured to get the value of the actual decision made.

The Formula for Opportunity Cost is:

Opportunity Cost = Total Revenue – Economic Profit

Opportunity Cost = What One Sacrifice / What One Gain

Examples of Opportunity Cost Formula

Let’s take an example to understand the calculation of Opportunity Cost formula in a better manner.

You can download this Opportunity Cost Formula Excel Template here – Opportunity Cost Formula Excel Template

Opportunity Cost Formula – Example #1

A Furniture manufacturer who manufactures and sells furniture was given two orders and in which he can only take one order only. Now it’s up to the Furniture manufacturer to decide between the two orders as he has time and labor limitations. The manufacturer has to pay wages @ INR 100/hour to the labor.

1st order: One table Selling Price INR 7500, the time required- 16Hours, Raw material costs- INR 1800
2nd Order: Two Chairs Selling Price INR 4000 each, Time required – 11 hours each, Raw material costs – INR 800 each.

Find out the better option and the opportunity costs he misses?

Solution:

As the manufacturer has two different orders with diversified characteristics, so we have to calculate the profit from both of the orders individually

Profit from the First Order

Opportunity Cost = Total Revenue – Economic Profit

First Order = INR 7500 – [(16 * 100) + 1800]
First Order = INR (7500 – 3400)
First Order = INR 4100

Profit from the Second Order

Second Order = INR (4000 * 2) – [(11 * 2 * 100)+ (800 * 2)]
Second Order = INR 8000 – 3800
Second Order = INR 4200

Conclusion – The manufacturer will take order no. 2 as it will give him much more earnings (INR 4200 vs INR 4100)

Popular Course in this category

All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)250+ Online Courses | 1000+ Hours | Verifiable Certificates | Lifetime Access
4.9 (3,296 ratings)

Course Price

View Course

Thus the Opportunity cost is INR 4100 which the manufacturer misses during his course of business. As the manufacturer has time limitations and he can take only one order at a time, so he would opt for the second order.

Opportunity Cost Formula – Example #2

Tata Motors have three bulk orders and it can take the most profitable one first as to strengthen its Cash Flow so has to enhance its working capital to process the rest of the two orders. Find out the most profitable and the least profitable in a descending manner in order to protect its Cash balance. (Assume that all the Sales are made on a Cash basis).

Order 1: 100 Cars of Selling Price of INR 4.5 lakh each, RM costs – INR 80 lakhs, Total Labor expenses – INR 22 lakhs
Order 2: 50 Cars of Selling Price of INR 8 lakh each, RM costs – INR 95 lakhs, Total Labor expenses – INR 45 lakhs
Order 3: 20 Trucks of Selling Price of INR 22 lakh each, RM costs – INR 1.12 Cr, Total Labor expenses – INR 38 lakhs

Solution:

From the above problem, we should calculate the profitability in each case. As we all know the Sales are done in a Cash basis, so more earnings would help the business to generate higher cash flow and there would not be pressure on the Working capital as the company will borrow less short term borrowings.

Profitability from First Order

First Order = INR [(4, 50,000 * 100) – (80,00,000 + 22,00,000)]
First Order = INR 4,50,00,000 – 1,02,00,000
First Order = INR 3,48,00,000

Profitability from Second Order

Second Order = INR [(8,00,000 * 50) – (95,00,000 + 45,00,000)]
Second Order = INR (4,00,00,000 – 1,40,00,000)
Second Order= INR 2,60,00,000

Profitability from Third Order

Third Order = INR [(22,00,000 * 20) – (1,12,00,000 + 38,00,000)]
Third Order = INR 4,40,00,000 – 1,50,00,000
Third Order = INR 2, 90,00,000

Thus Tata Motors will undertake the First order First , then it will take the Third order and lastly it will take the second order in order of profitability so as to strengthen its working capital. Thus the opportunity costs after the First order is done would be = INR (2.9 +2.6) Cr or INR 5.5 Cr (as the company has not executed the other orders and it might choose not to execute) and after the second order the opportunity costs would be INR 2.6 cr.

Opportunity Cost Formula – Example #3

Larsen and Tubro Ltd has two order for execution, But it can undertake only one. Based on the following data choose which one to operate and the opportunity costs.

Order one will derive a Revenue of INR 10,00,000 and Costs 4,00,000.
Order two will derive a Revenue worth INR 12,00,000 and will cost INR 8,00,000.

Solution:

Profitability from First Order

First Order = INR 10,00,000 – 4,00,000
First Order = INR 6,00,000

Profitability from Second Order

Second Order = INR 12,00,000 – 8,00,000
Second Order = INR 4,00,000

Thus L&T will take order one and the Opportunity costs of not taking second order would be INR 400000.

Explanation of Opportunity Cost Formula

The formula calculates the best options and calculates the second best possible option in terms of value which was not chosen during the course of production.

Relevance and Uses of Opportunity Cost Formula

Assessing relative prices of commodities

The concept is very much used for measuring the prices or the value of different communities which are used in a manufacturing concern.

For example, according to the theory of economics, we know that the goods are scarce and human wants are unlimited. So a particular commodity or raw material can be used for one purpose only. So the best possible end product has to decide by the authority which can serve human wants in a better way.

Deciding Salary or remuneration of professionals

Opportunity cost could be used during the fixation of salary for a particular job. When a benchmark is created based upon the remuneration of that particular professional when he or she might be offer for another job. The suspect the capability and the productive names of professionals, one can use opportunity cost as a benchmark of remuneration.

Allocation of resources

Proper allocation of scarce resources

As we all know the resources are scarce so to get optimum value or efficiency one has to decide the best possible use of resources which would give the best satisfaction to the end consumer. In other words, one has to process the raw materials into doors kind of products which would give optimum satisfaction to the user.

For example, if a piece of wood can be used to make one table or three chairs then the best possible outcome should be chosen which would help a number of people.