Skip to main content

Business Calculus with Excel

Mike May, S.J., Anneke Bart

Section 7.8 Economics Applications of the Integral

Link to worksheets used in this section
 1 
excelcalculus.org/external/Examples/Section-7-8-Examples.xlsx
🔗
We have looked at the definite integral as the signed area under a curve. This lets us compute total profit, or revenue, or cost, from the related marginal functions. We have looked at a number of applications where this was interpreted as an accumulation over time, including total production of an oil well and present value of a revenue stream. For some applications we want to look at the area between two curves. For example, considering profit as the area between the cost and revenue curves.
🔗
In this section we will look at more applications from finance and economics where the concepts can easily be described in terms as of the area between curves.
🔗

Subsection 7.8.1 Consumer and Producer Surplus

When we looked at supply and demand curves we found an equilibrium point where the amount being offered for sale was equal to the amount people wanted to buy.
🔗
However, in that model, there were people who were willing to sell for less than the equilibrium price and people who were willing to buy for more than the equilibrium price. These people got an exceptionally good deal in the transaction. We would like to measure that benefit, since we can think of it as the extra profit the suppliers and buyers make on the transaction. We note that each side will have an incentive to maximize that benefit.
🔗
Focus first on the consumer side. The area under the demand function, from 0 to the quantity sold, measures the consumers’ willingness to spend. The area in the rectangle with that same base and height equal to the sale price measures the actual consumer expenditure. The difference between the two is a quantity we will call consumer surplus.
🔗
In calculus terms:
🔗
\begin{equation*} \text{Willingness To Spend} = \int_0^{q_s} \text{demand function}(q)\, dq \end{equation*}
🔗
\begin{equation*} \text{consumer expenditure} = \int_0^{q_s} p_s \, dq \end{equation*}
🔗
\begin{equation*} \text{consumer surplus}= \int_0^{q_s} (\text{demand function}(q)- p_s )\, dq \end{equation*}
🔗
🔗
As long as the price stays on the demand function curve, a lower price means a greater quantity sold, and a greater consumer surplus.
🔗
In a similar manner, we can focus on the producer side. The area under the supply function, from 0 to the quantity sold, measures the producers’ need for revenue. The area in the rectangle with that same base and height equal to the sale price measures the actual producer revenue. The difference between the two is a quantity we will call producer surplus.
🔗
In calculus terms:
🔗
\begin{equation*} \text{Needed revenue}= \int_0^{q_s} \text{supply function}(q)\, dq \end{equation*}
🔗
\begin{equation*} \text{producer revenue}= \int_0^{q_s} p_s \, dq \end{equation*}
🔗
\begin{equation*} \text{producer surplus}= \int_0^{q_s} ( p_s-\text{supply function}(q)) \, dq \end{equation*}
🔗
🔗
As long as the price stays on the supply function curve, a higher price means a greater quantity sold, and a greater producer surplus. Consider first an example where the supply and demand functions are simple enough that the computations can all be done by hand.
🔗

Example 7.8.1. Producer surplus with linear functions.

I am trying to sell widgets and have determined the supply and demand functions to be:
\begin{align*} \text{supply price}(\quantity) \amp = 4+\quantity\\ \text{demand price}(\quantity) \amp = 106- 2*\quantity\text{.} \end{align*}
🔗
Find the equilibrium price and quantity. Find the producer and consumer surpluses when the shirts are sold at the equilibrium price. If the producers form a cartel, find the price that maximizes producer surplus.
🔗
Solution.
By setting supply price and demand price equal to each other we find an equilibrium quantity of 34 and an equilibrium price of 38. The formulas for the consumer and producer surpluses become:
\begin{equation*} \text{consumer surplus}= \int_0^{34} ((106-2q)-38)\, dq \end{equation*}
\begin{equation*} \text{producer surplus}= \int_0^{34} ( 38-(4+q)) \, dq \end{equation*}
🔗
To evaluate the integrals we can notice that each is a triangle of base 34. One has height of 34 and the other has a height of 68. Using geometry, the consumer surplus is $1,156 and the producer surplus is $578.
🔗
To find the maximum producer surplus, we need to turn the endpoint into a variable. If the producers act as a cartel,
\begin{equation*} \text{producer surplus}= \int_0^x ( (106-2x)-(4+q))\, dq=\int_0^x ( 102-2x-q)\, dq \end{equation*}
\begin{equation*} =\left.\left((102-2x)q-\frac{q^2}{2}\right) \right|_0^x=((102-2x)x-\frac{x^2}{2}=102x-\frac{5x^2}{2} \end{equation*}
🔗
We can find the maximum of this by taking its derivative and setting it equal to 0. The maximum occurs when \(x=\frac{102}{5}=20.4\text{.}\) At that point the producer surplus is $1,040.40.
🔗
🔗
🔗
We now try an example where we need other techniques to evaluate the integrals.
🔗

Example 7.8.2. Producer surplus with numeric integration.

A store trying to sell t-shirts on campus has determined the supply and demand functions to be:
\begin{equation*} \text{supply price}(\quantity)=5+\ln (\quantity+10) \end{equation*}
\begin{equation*} \text{demand price}(\quantity)=10+100/(\quantity+2)\text{.} \end{equation*}
🔗
Find the equilibrium price and quantity. Find the producer and consumer surpluses when the shirts are sold at the equilibrium price.
🔗
Solution.
We load the supply and demand price functions into excel and use Goal Seek to find an equilibrium price. Rounding to the nearest unit for quantity and cent for price, we have an equilibrium price of $10.45 for a quantity of 222 shirts.
🔗
We then substitute these values into the equations for consumer and producer surplus.
\begin{align*} \text{consumer surplus}\amp = \int_0^{q_s} (\text{demand function}(q)- p_s )\, dq\\ \text{consumer surplus}\amp = \int_0^{222} ((10+100/(\quantity+2))- 10.45)\, dq\\ \text{producer surplus}\amp =\int_0^{q_s} ( p_s-\text{supply function}(q)) \, dq\\ \text{producer surplus}\amp =\int_0^{222} ( 10.45-(5+\ln (\quantity+10))) \, dq\text{.} \end{align*}
🔗
To evaluate these integrals we either use a Riemann sum approximation, like the one found on the example worksheet, or use Wolfram Alpha. In either case, rounded to the nearest dollar, we have a consumer surplus of $372 and a producer surplus of $191.
🔗
🔗
🔗
The sum of the consumer surplus and the producer surplus is referred to as the total social gain. As we looked at consumers’ surplus, we assumed that the sales were determined by supply and the price-quantity point was on the supply curve. Similarly, when looking at producers’ surplus we assume price is set by demand and the price-quantity point was on the demand curve. If both sides are made up of many individuals acting independently, the price-quantity point is the equilibrium point, which is on both curves. Selling at that point also maximizes the total social gain.
🔗
If however, either the producers or consumers can organize and act as a unit, they can form a cartel and limit the amount sold. If the producers form a cartel, they can lower production and raise the price.
🔗
As we can see from the picture, this always lowers the total social gain. However for some reduction of quantity the producers’ surplus is increased. In the equation for producer surplus the price \(p_s\) is \(\text{demand function} (q_s)\) rather than \(\text{supply function} (q_s)\text{.}\) If the quantity goes down too far the producer surplus will also go down.
🔗

Example 7.8.3. Computing loss of social gain.

A store trying to sell t-shirts on campus has determined the supply and demand functions to be:
\begin{equation*} \text{supply price}(\quantity)=5+\ln (\quantity+10) \end{equation*}
\begin{equation*} \text{demand price}(\quantity)=10+100/(\quantity+2) \end{equation*}
🔗
The store owner has a monopoly on campus and decides to limit the quantity sold to 200 shirts and charge what the market will bear. Find the price, the producer surplus, and consumer surpluses. Find these numbers if the owner decides to limit sales to 50. How many shirts should the owner sell at what price to maximize producer surplus? If producer surplus is maximized, how much is the total social gain reduced?
🔗
Solution.
The formulas involved for supply and demand are the same ones we used in Example 7.8.2. With a slight modification if the worksheet from that example we can set it to compute the Riemann sums approximating the surpluses. In particular, we use the demand function for finding the height of producer surplus. (See cell D7.)
🔗
If we only want to sell 200 shirts, we can raise the price to from $10.45 to $10.50. The producer surplus rises from $191 to $199. However the consumer surplus falls from $372 to $362.
🔗
If we only want to sell 50 shirts, we can raise the price from$10.45 to $11.92. The producer surplus falls from $191 to $174. The consumer surplus falls from $372 to $230.
🔗
We can use solver to maximize the Producer surplus by varying the quantity. A quantity of 140 maximizes the producer surplus at $210, but is doing that the total social gain is down to $537 from $563.
🔗
🔗
🔗
Similarly, if the consumers form a cartel, they can artificially reduce the demand. Since they will then pay the supply price the total social gain will be decreased, but the consumers’ surplus may be increased. In this case the consumer surplus is the integral of the difference between the demand function and the supply price of the quantity that will be sold.
🔗
In the example we just looked at, both the supply and demand curves have a small slope, so the market is quite elastic from both the producers and consumers point of view. Is such a case there is less incentive to form a cartel. In other markets, like gas and oil, where the market is more inelastic, there is more incentive to engage in monopolistic practices.
🔗
🔗

Subsection 7.8.2 Lorenz Curves and the Gini Index

A question that arises in economics looks at the equity of income or wealth distribution in a country. In standard economic theories either too much or too little equity indicates a lack of opportunity and is a hindrance to growth. However, before being able to address the advantages or disadvantages of a level of inequity we need to be able to quantify the level of equity or inequity. The standard method is to use the Lorenz curve and the Gini index.
🔗
The Lorenz curve is defined by a function \(L(x)\text{,}\) with \(0\leq x\leq 1\text{,}\) that measures the proportion of something is held by the bottom \(x\) proportion of the population. Thus, if \(L(0.2)=.1\text{,}\) for the Lorenz function for income in a country, then the bottom 20% of the population earns 10% of the income in the country. Since, under usual definitions, a person cannot have negative income, the Lorenz functions are nonnegative and increasing. Since the Lorenz functions are measured from the bottom, we also have \(L(x)\leq x\) for all \(x\text{.}\)
🔗
We can make a few more observations. The population as a whole has the entire income of the population. An empty set of the population has none of the population’s income. Any bottom segment will have nonnegative income. In formulas these observations become \(L(1)=1\text{,}\) \(L(0)=0\text{,}\) and \(L(x)\ge 0\text{,}\) for all \(x\text{,}\) respectively.
🔗
If we had perfect equity, our Lorenz function would be \(L(x)=x\text{.}\) Any Lorenz curve we find for a real population will be below this curve. The Gini index (or Gini coefficient) measures the percentage that a real Lorenz curve is below the ideal curve.
🔗
Computationally,
\begin{equation*} G=\frac{\int_0^1 (x-L(x))dx}{\int_0^1 x dx}=2\int_0^1 (x-L(x))dx\text{.} \end{equation*}
🔗
In practice this number is often multiply by 100, reporting the percentage (0 to 100) rather than proportion (0 to 1) of the area under the ideal function and above the measured function.
🔗

Example 7.8.4. Gini index with a formula for income distribution.

The Lorenz curve for income in a certain country is given by \(L(x)=.8x^3+.2x\text{.}\) What proportion of the income is earned by the bottom half of the population? Find the Gini index.
🔗
Solution.
To find the proportion earned by the bottom half of the population we substitute 0.5 in the equation.
\begin{equation*} L(0.5)=(0.8) (0.5)^3+(0.2)(0.5)=0.1+0.1=0.2\text{.} \end{equation*}
🔗
Thus the bottom 50% of the population earns 20.% of the total income. To compute the Gini index, we compute:
\begin{equation*} G=2\int_0^1 (x-0.8x^3-0.2x)dx=(2)(0.4x^2-0.2x^4 ) |_0^1=.4\text{.} \end{equation*}
🔗
So the Gini index in this hypothetical country is 40. To put this number in context, the reported Gini index for the United States in 2009 was 46.8.
🔗
🔗
🔗
In practice, the Gini index is an application where a numeric approximation of an integral is the method most likely to be used. We are unlikely to get a formula for income distribution. Instead we are likely to find data points. Since there is no good model for how the income will be distributed, we can simply connect the points with line segments and find the area using the area formula for a trapezoid.
🔗

Example 7.8.5. Gini index with a chart for income distribution.

We have the following data from the census bureau on income distribution in the US in 2008. Compute the Gini index.
🔗
Population %tile 0 20 40 60 80 90 100
Income %tile 0 3.4 12.0 26.7 50.0 78.5 100
Solution.
We recall that the area of a trapezoid is (width)(average height). We put the data into a spreadsheet.
🔗
Then we evaluate the formulas.
🔗
In percentages, the Gini index is approximated at 45.
🔗
🔗
🔗
🔗

Reading Questions 7.8.3 Reading Check

1. Reading check, Economics Applications of the integral.

This question checks your reading comprehension of the material is section 7.8, Economics Applications of the integral, of Business Calculus with Excel. Based on your reading, select all statements that are correct. There may be more than one correct answer. The statements may appear in what seems to be a random order.
🔗
  1. If we can set up the integral of an application, we can use CAS to evaluate the integral.
    🔗
    🔗
  2. We can accumulate marginal cost over time to find change in cost.
    🔗
    🔗
  3. This section explained how to use calculus to predict the future value of the stock market.
    🔗
    🔗
  4. to find the current value of a revenue stream we take the integral of the revenue stream times a discounting functions that represents how much a future payment is worth today.
    🔗
    🔗
  5. Accumulating a function over time is simply taking a definite integral.
    🔗
    🔗
  6. The example on oil production took the integral of an exponential function.
    🔗
    🔗
  7. None of the above
    🔗
    🔗
🔗
🔗
🔗

Exercises 7.8.4 Exercises Business Applications of the Integral Problems

Exercise Group.

For the following exercises, assume we have a free market and that goods are sold at market equilibrium. Find the consumer surplus, producer surplus, and total social gain.
🔗
1.
\(\Sprice(q)= 50+q/2\) and \(\Dprice(q)= 150-q/5\text{.}\)
🔗
Solution.
The two curves intersect at the point of market equilibrium, \(\left({\frac{1000}{7},\frac{850}{7}}\right)\text{.}\)
🔗
\begin{align*} \text{ProducerSurplus}\amp =\int_0^{1000/7}\left({\frac{850}{7}}\right)-\left({50+\frac{x}{2}}\right)\,dx=5102.04\\ \text{ConsumerSurplus}\amp =\int_0^{1000/7}\left({150-\frac{x}{5}}\right)-\left({\frac{850}{7}}\right)\,dx=2040.82\\ \text{TotalSocialGain}\amp =\text{ProducerSurplus}+\text{ConsumerSurplus}=7142.86\text{.} \end{align*}
🔗
🔗
🔗
2.
\(\Sprice(q)=\ln (q+10)\) and \(\Dprice(q)= 100-q\text{.}\)
🔗
🔗
3.
\(\Sprice(q)= 50(1-(0.99)^q)\) and \(\Dprice(q)= 100(0.99)^q\text{.}\)
🔗
Solution.
The two curves intersect at the point of market equilibrium, \((109.31, 33.33)\text{.}\)
🔗
\begin{align*} \ProducerSurplus\amp =\int_0^{109.31}(33.33)-\left({50(1-(0.99)^q)}\right)\,dx=1494.79\\ \ConsumerSurplus\amp =\int_0^{109.31}\left({100(0.99)^q}\right)-33.33)\,dx=2989.58\\ \TotalSocialGain\amp=\ProducerSurplus+\ConsumerSurplus=4484.37\text{.} \end{align*}
🔗
🔗
🔗
4.
\(\Sprice(q)= 50(1-(0.95)^{q/10}\) and \(\Dprice(q)= 150(0.95)^{q/10}\text{.}\)
🔗
🔗
5.
\begin{equation*} \Sprice(q)=\begin{cases} 5\amp q\le 10\\ q^2/20\amp q \gt 10\\ \end{cases} \end{equation*}
and
\begin{equation*} \Dprice(q)=\begin{cases} 100\amp q\le 10\\ 110-q\amp q\gt 10\\ \end{cases}\text{.} \end{equation*}
🔗
Solution.
The two curve intersect at the point of market equilibrium, \((37.958, 72.042)\text{.}\)
🔗
\begin{equation*} \ProducerSurplus=\int_0^{37.958}(72.042)-(\Sprice(q))\,dx=1789.732\text{.} \end{equation*}
The integral needs to be done in two parts with the break at 10.
\begin{equation*} \ConsumerSurplus=\int_0^{37.958}\Dprice(q)-72.042\,dx=670.405\text{.} \end{equation*}
\begin{equation*} \TotalSocialGain=\ProducerSurplus+\ConsumerSurplus=2460.137\text{.} \end{equation*}
🔗
🔗
🔗
6.
\(\Sprice(q)= q/2\) and
\begin{equation*} \Dprice(q)=\begin{cases} 200\amp q\le 10\\ 250*.8^{q/10}\amp q\gt 10\\ \end{cases}\text{.} \end{equation*}
🔗
🔗
🔗

7.

Assume \(\Sprice(q)= 30+q\) and \(\Dprice(q)= 170-q\text{.}\)
🔗
  1. Find the consumer surplus, producer surplus, and total social gain at market equilibrium.
    🔗
    🔗
  2. If the producers can form a cartel and restrict the available quantity to 50, selling at the supply price for 50, what are the consumer surplus, producer surplus, and total social gain?
    🔗
    🔗
  3. Find the price where a producer cartel will maximize the producer surplus. Find the producer surplus at that price.
    🔗
    🔗
🔗
Solution.
  1. The two curve intersect at the point of market equilibrium, \((70, 100)\text{.}\)
    🔗
    \begin{align*} \ProducerSurplus \amp =\int_0^{70}(100)-(30+q)\,dx=2450\\ \ConsumerSurplus \amp =\int_0^{70}(170-q)-100\,dx=2450\\ \TotalSocialGain \amp =\ProducerSurplus+\ConsumerSurplus=4900\text{.} \end{align*}
    🔗
    🔗
  2. \begin{align*} \Dprice(50) \amp =120\\ \ProducerSurplus \amp = \int_0^{50}(120)-(30+q)\,dx=3250\\ \ConsumerSurplus \amp = \int_0^{50}(170-q)-120\,dx=1250\\ \TotalSocialGain \amp = \ProducerSurplus+\ConsumerSurplus=4500\text{.} \end{align*}
    🔗
    🔗
  3. The formula for the producer surplus at x is
    \begin{equation*} \int_0^x \Dprice(t)-\Sprice(x)\,dx\text{.} \end{equation*}
    🔗
    In our case we get
    \begin{equation*} \int_0^x (170-t)-(30+x) \,dt=\int_0^x(140-t-x) \,dt\text{.} \end{equation*}
    We note that x is a constant for our integration. Thus, thus we get
    \begin{equation*} \left.\left({140t-\frac{t^2}{2}-xt}\right)\right|_0^x=140x-\frac{3x^2}{2}\text{.} \end{equation*}
    🔗
    The Maximum Producer surplus is 3266.67, achieved when q is 46.67
    🔗
    🔗
🔗
🔗
🔗

8.

Assume SupplyPrice(q)= 10+q/2 and DemandPrice(q)= 110-q/3.
🔗
  1. Find the consumer surplus, producer surplus, and total social gain at market equilibrium.
    🔗
    🔗
  2. If the producers can form a cartel and restrict the available quantity to 400, selling at the supply price for 400, what are the consumer surplus, producer surplus, and total social gain?
    🔗
    🔗
  3. Find the price where a producer cartel will maximize the producer surplus. Find the producer surplus at that price.
    🔗
    🔗
🔗
🔗

9.

Assume \(SupplyPrice(q)= 10+q^2\) and \(DemandPrice(q)= 210-q^2\text{.}\)
🔗
  1. Find the consumer surplus, producer surplus, and total social gain at market equilibrium.
    🔗
    🔗
  2. If the producers can form a cartel and restrict the available quantity to 5, selling at the demand price for 5 (for a price of 185), what are the consumer surplus, producer surplus, and total social gain?
    🔗
    🔗
  3. Find the price where a producer cartel will maximize the producer surplus. Find the producer surplus at that price.
    🔗
    🔗
🔗
Solution.
  1. The two curve intersect at the point of market equilibrium, \((10, 110)\text{.}\)
    🔗
    \begin{align*} \ProducerSurplus \amp = \int_0^{10}(110)-(10+q^2)\,dx=\frac{2000}{3}\\ \ConsumerSurplus \amp = \int_0^{10}(210-q^2)-110\,dx=\frac{2000}{3}\\ \TotalSocialGain \amp = \ProducerSurplus+\ConsumerSurplus=\frac{4000}{3}\text{.} \end{align*}
    🔗
    🔗
  2. \begin{align*} \Dprice(5)\amp =185\\ \ProducerSurplus \amp = \int_0^{5}(185)-(10+q^2)\,dx=\frac{2500}{3}\\ \ConsumerSurplus \amp = \int_0^{5}(210-q^2)\,dx=\frac{250}{3}\\ \TotalSocialGain \amp = \ProducerSurplus+\ConsumerSurplus=\frac{2750}{3}\text{.} \end{align*}
    🔗
    🔗
  3. The formula for the producer surplus at \(x\) is
    \begin{equation*} \int_0^x DemandPrice(t)-SupplyPrice(x)\,dx\text{.} \end{equation*}
    🔗
    In our case we get
    \begin{equation*} \int_0^x (210-t^2)-(10+x^2) \,dt=\int_0^x(200-t^2-x^2) \,dt\text{.} \end{equation*}
    We note that \(x\) is a constant for our integration. Thus, thus we get
    \begin{equation*} \left.\left({200t-\frac{t^3}{3}-x^2t}\right)\right|_0^x=200x-\frac{4x^3}{3}\text{.} \end{equation*}
    🔗
    To find the maximum producer surplus, we take the derivative of the function above and see it is zero at \(\sqrt{50}\text{.}\) The maximum producer surplus is 942.81, achieved when q is \(\sqrt{50}\)
    🔗
    🔗
🔗
🔗
🔗

10.

Consider the Lorenz curve \(L(x)=0.2x+0.8x^2\text{.}\) Find the Gini index.
🔗
🔗

11.

Consider the Lorenz curve \(L(x)=.03x+0.7x^4\text{.}\) Find the Gini index.
🔗
Solution.
\begin{equation*} G=\frac{100 \int_0^1(x-(0.3x+0.7x^4))dx}{.5}=200 \int_0^1(-0.7x+0.7x^4)dx=42 \end{equation*}
🔗
🔗
🔗

12.

You research a country and find the following information on income share:
🔗
Population %tile 20 40 60 80
Income %tile 5 15 30 50
Compute an approximation of the Gini index.
🔗
🔗

13.

You research a country and find the following information on income share:
🔗
Population %tile 20 40 60 80 90 95 99
Income %tile 5 15 30 50 65 75 90
Compute an approximation of the Gini index.
🔗
Solution.
We approximate the area by using straight lines between the given point and using trapezoids for the area of section. We then need to multiply by 2, since we want the percentage below the diagonal line, and multiply by 100 to go from percentile to percents.
🔗
The Gini index is approximately 57.
🔗
🔗
🔗
🔗
🔗
PrevTopNext