Section 2.2 Modeling Revenue, Costs, and Profit
Link to unworked worksheets used in this section^{â€‰1â€‰}
Link to worksheets used in this section.^{â€‰2â€‰}
In the last section we looked at the economic model for supply and demand. We were particularly interested in the point of market equilibrium. In this section we will look at the model for revenue, cost and profit. As with the previous section we will begin with assumptions that make as many things as possible linear.
Subsection 2.2.1 Revenue and a review of demand price
The simple model for revenue is
However, in the previous section we worked with two price functions, the supply price and the demand price. Since we can only make a sale if the consumer is willing to buy, we typically use the demand price in computing revenue. Our model is now
If the demand price is a linear function, then revenue is a quadratic function.
We previously noted that a linear demand price function has a negative slope. We should note the two limiting cases. If the slope of the demand curve is 0, the consumers have a fixed price they will pay for however much of the product is available. In this case the demand curve is a constant, so the revenue curve will be linear. This is referred to as a perfectly elastic market. The other limiting case is where the demand is for a fixed amount no matter what the price. In this case the demand curve is a vertical line and is not a function, so the revenue curve also fails to be a function of quantity.
Obviously, we donâ€™t expect to find the limiting cases in the real world. In real world cases the revenue function has a negative coefficient for the quadratic term and is a downward facing parabola.
Example 2.2.1. Finding Revenue From Linear Demand Price.
We have determined that the demand price function for widgets is
if the quantity is between 2000 and 8000. Find the revenue function and graph it over the region where it is defined.
We set up a chart in Excel with revenue defined as \(\Sprice * \quantity\text{.}\)
When we graph we note that the scales are quite different for price and revenue. Thus we want to use secondary axes to capture the scale of both price and revenue. We can also put different labels on the two vertical axes.
Subsection 2.2.2 Cost
Once again we will start with a simplified model for cost.
For our (simplified) model we will break costs into fixed costs and variable costs.
Fixed costs include the costs of being in business. They might include license fees, rent for a store or plant, and the cost of furnishings and equipment.
Variable costs are tied to the amount you produce or sell. They might include raw material for a manufacturer or the cost of goods for someone in sales.
For our simplified model we assume that variable costs are proportional to quantity. This makes our cost function linear.
For our simplified model variable costs= unit costs*quantity.
Thus costs= fixed costs + unit costs*quantity.
Example 2.2.3. Finding Linear Cost.
We can set up a small gizmo manufacturing shop for $6,000. The raw materials for producing gizmos cost $14 per unit. Find the cost function for gizmo production. Find the cost of producing 2500 gizmos.
The fixed costs are the \(y\) value of the \(y\)intercept of the cost function. The per unit material cost is the slope of the function. We have
If we substitute 2500 for the quantity, our costs are
Subsection 2.2.3 Profit
For the third piece of the model, we look at profit. We have the simple formula
For our simple examples where cost is linear and revenue is quadratic, we expect the profit function to also be quadratic, and facing down. We will obviously be interested in the spots where the profit function either crosses the axis or reaches a maximum.
Example 2.2.5. Finding Profit.
We are interested in selling widgets. The demand price function is
It will cost $10,000 to keep our shop open before we consider the price of inventory. Our variable cost is the cost of buying the widgets from our wholesaler who will sell them to us for $8 a unit. Find a function for profit as a function of how many units we sell. Graph that function for quantities from 1000 to 10000.
Using the methods from the previous examples, we write down the functions for revenues and costs.
Now we find profit as the difference of revenue and cost.
We then use Excel to make a chart of values and a graph.
Subsection 2.2.4 BreakEven Point
The last example illustrates a reality of manufacturing and retail. If a business has a fixed cost or startup expense, it will have a loss if it does not sell enough.
The point at which revenues equal expenses (cost) is called the breakeven point.
This is important in preparing a business proposal, because the bank will want to know if the break even point is a reasonable amount before it lends any money.
Example 2.2.6. Find BreakEven Points.
Find breakeven points for previous example. Explain what those points mean in practical terms.
We look at the chart from the previous example.
We can find breakeven points by using Goal Seek and setting profit to 0 while changing quantity. In this case, we see that we have breakeven points when the quantity is 2000 or 5000, since those numbers were already on our chart.
The first break even point tells us that we need to lower our price to no more than $13.00 to attract enough customers to be able to turn a profit. The second break even point says that is we bring our price down below $10, we will not be able to bring in enough customers to make a profit.
Example 2.2.7. Repeat, Starting With Data.
We have the following data from the gizmo market, with quantity and costs measured in millions.
Quantity  7.81  10.07  11.99  13.84  15.80 
Demand Price  $12.07  $9.05  $7.60  $6.64  $5.64 
Cost  $60.05  $70.09  $79.98  $89.90  $99.83 
Assuming that price and cost are well modeled by linear equations, find the breakeven points and explain what they mean with units included in the explanation.
To find the breakeven point when we are given data instead of an equation, we usually follow this procedure: Find the best fitting equations for price and cost. From those equations, produce formulas for revenue and profit. Use the formulas to find the breakeven points using either algebra or Excel.
We put the data into Excel and ask for best fitting lines.
This produces the desired cost and price functions.
We enter these functions in new columns in the spreadsheet and then compute projective revenues and profit. We then use Goal Seek to find places where the projected profit is 0. The first breakeven point tells us that we expect to break even if we sell 1.83 million units. We can do that by setting the price at $16.05. The second breakeven point is at 14.15 million units. We reach that sales volume by lowering the price to $6.45. While we will have gained market share, we will no longer be making a profit.
Subsection 2.2.5 Technical note
In business situations we often have cases where a change of quantity in the thousands only changes prices by pennies. Then our coefficients are close to zero and Excel may give formulas rounded to zero. In those cases we need to format the trendline to get more digits of accuracy.
Example 2.2.9. Problems with using big numbers.
We want to explore an issue that arises our coefficients are very small. We will have to be concerned with the number of significant digits in our coefficients.
We repeat the previous example, but with quantity and cost measured directly, rather than in millions. We should get the same answers, since we are using the same data.
Quantity  7,810,000  10,070,000  11,990,000  13,840,000  15,800,000 
Demand Price  $12.07  $9.05  $7.60  $6.64  $5.64 
Cost  $60,050,000  $70,090,000  $79,980,000  $89,900,000  $99,830,000 
We face the same tasks. Assuming that price and cost are well modeled by linear equations, find the breakeven points and explain what they mean with units included in the explanation.
To find the breakeven point when we are given data instead of an equation, we usually follow this procedure: Find the best fitting equations for price and cost. From those equations, produce formulas for revenue and profit. Use the formulas to find the breakeven points using either algebra or Excel.
We put the data into Excel and ask for best fitting lines.
As expected, a coefficient of each equation has been shifted by a factor of 1,000,000.
These equations have only one digit of accuracy. In general that will not be accurate enough.
We enter these functions in new columns in the spreadsheet and then compute projective revenues and profit. We then use Goal Seek to find places where the projected profit is 0. The first breakeven point goes from 1.83 million at price of $16.05 to 1.82 million at a price of $1602. The second break even point goes from 14.15 million units at a price to $6.45 to 13.75 million at a price of $6.48.
The solution is to right click (Command click on a mac) on the label and select â€śFormat Trendline Labelâ€ť. Then change category from general to number, and choose 10 decimal places. This gives us the equations:
We then go through the same process at get our original answers back.
Exercises 2.2.6 Exercises: Modeling Revenue, Costs, and Profit
Exercise Group.
For ExerciseÂ 2.2.6.1â€“2.2.6.8, given the equations of the cost and demand price function:
Identify the fixed and variable costs.
Find the revenue and profit functions.
Evaluate cost, demand price, revenue, and profit at \(q_0\text{.}\)
Find all breakeven points.
Graph the profit function over a domain that includes both breakeven points. Add a textbox and label to identify the first breakeven point.
1.
Given \(\Dprice=2 \quantity+20\) and \(\cost=3 \quantity+10\text{,}\) with \(q_0=6\text{.}\)

Identify the fixed and variable costs.
The fixed cost is $10 (the constant/fixed part of the cost function), and the variable cost is $3 per item.

Find the revenue and profit functions
\begin{align*} \revenue\amp=\Dprice*\quantity\\ \amp=(2 q+20)*q=2 q^2 +20 q \end{align*}\begin{align*} \profit= \revenue\cost \amp=2 q^2 +20q(3q+10)\\ \amp=2 q^2+17q10\text{.} \end{align*} 
Evaluate cost, demand price, revenue, and profit at \(q_0\)
\begin{align*} \cost(6)\amp =3 (6)+10=28\\ \Dprice(6)\amp =2 (6)+20=8\\ \revenue(6)\amp =2 6^2 +20 (6)=72+120=48\\ \profit\amp =\revenue\cost =4828=20\text{.} \end{align*} 
Find all breakeven points
Solve \(\profit=2 q^2+17q10=0\text{.}\) We can do this with Excel or with Wolfram. The break even points are \(q = 0.6\) and \(q = 7.9\text{.}\)

Graph the profit function over a domain that includes both breakeven points. Add a textbox and label to identify the first breakeven point.
If we had done the whole problem in Excel it would look like this:
Entries in the cells before quick fill
The table with \(q\) between 0 and 8
Goal Seek gives break even points at \(q = 0.64\) and \(q = 7.86\)
The graph produced in Excel. To create the labels: double click on one of the breakeven points, go to â€śChart Layoutâ€ť, go to â€śData Labelsâ€ť. In this example we chose the â€śxvalueâ€ť. Both breakeven points were labeled to show where they are and what the values are in this problem.
2.
Given \(\Dprice= \quantity/10+50\) and \(\cost=10 \quantity+1000\text{,}\) with \(q_0=300\text{.}\)
3.
Given \(\Dprice =2.35 \quantity+250\) and \(\cost=54.6 \quantity+1234\text{,}\) with \(q_0=59\text{.}\)

Identify the fixed and variable costs.
\(\text{Fixed cost} = \$1234\text{,}\) and the \(\text{variable cost} =\$54.60\) (per unit)

Find the revenue and profit functions.
\begin{equation*} \revenue=q(2.35 q+250)= 2.35 q^2+250 q \end{equation*}\begin{align*} \profit=\revenue\cost \amp=2.35 q^2+250 q(54.6q+1234)\\ \amp=2.35 q^2+195.4 q1234\text{.} \end{align*} 
Evaluate cost, demand price, revenue, and profit at \(q_0\text{.}\)
Entries in the cells before quick fill
Table plus extra column for the value \(q = 59\text{.}\)
At \(q =59\text{,}\) \(\cost = \$4455.40\text{,}\) \(\Dprice = \$111.35\text{,}\) \(\revenue = \$6569.65\text{,}\) and \(\profit = \$2114.25\)

Find all breakeven points.
Table plus extra column for the value \(q = 59\)
The breakeven points are \(q = 6.9\) and \(q = 76.3\)

Graph the profit function over a domain that includes both breakeven points. Add a textbox and label to identify the first breakeven point.
The graph produced in Excel. To create the labels: double click on one of the breakeven points, go to â€śChart Layoutâ€ť, go to â€śData Labelsâ€ť. In this example we chose the â€śxvalueâ€ť. Both breakeven points were labeled to show where they are and what the values are in this problem.
4.
Given \(\Dprice=0.0023 \quantity+9\) and \(\cost=1.39 \quantity+1398.7\text{,}\) with \(q_0=687\text{.}\)
5.
Given demand price and cost are the linear functions that best fit the data below and that \(q_0=75\text{.}\)
Quantity  50  100 
Demand price  10  8 
Cost  300  450 

If the table only has 2 data points, Excel can get confused wether the data is in rows or columns. We duplicated one column to get the data plotted correctly.
Identify the fixed and variable costs.
\(\text{Fixed cost} = \$150\text{,}\) and the \(\text{variable cost} =\$3\) (per unit).

Find the revenue and profit functions.
\begin{equation*} \revenue=q(0.04q+12)= 0.04 q^2+12x \end{equation*}\begin{align*} \profit=\revenue\cost \amp=0.04 q^2+12q(3q+150)\\ \amp=0.04 q^2+9q150\text{.} \end{align*} 
Evaluate cost, demand price, revenue, and profit at \(q_0\text{.}\)
At \(q =75\text{,}\) \(\cost = \$375\text{,}\) \(\Dprice = \$9\text{,}\) \(\revenue = \$675\text{,}\) and \(\profit = \$300\)

Find all breakeven points.
The breakeven points, found with goal seek, are \(q = 18.127\) and \(q = 206.873\)

Graph the profit function over a domain that includes both breakeven points. Add a textbox and label to identify the first breakeven point.
Entries in the cells before quick fill
Table plus extra columns for the brek even points
The graph produced in Excel. To create the labels: double click on one of the breakeven points, go to â€śChart Layoutâ€ť, go to â€śData Labelsâ€ť. In this example we chose the â€śxvalueâ€ť. Both breakeven points were labeled to show where they are and what the values are in this problem.
6.
Given demand price and cost are the linear functions that best fit the data below and that \(q_0=110\text{.}\)
Quantity  60  70  90  100 
Demand Price  19  16  
Cost  460  540 
7.
Given demand price and cost are the linear functions that best fit the data below and that \(q_0=75\text{.}\)
Quantity  4356  4792  6503  7038 
Demand price  $1.10  $.98  
Cost  $1190  $1860 
We plot the data, and find the linear models for demand and cost.
Given the demand price and the cost we create a table using the formulas and we also include a row for the \(\revenue =( \Dprice * \quantity)\) and \(\profit =(\revenue  \cost)\)

Identify the fixed and variable costs.
The fixed cost is  $169.35, and the variable cost is $0.3121 per unit of quantity. (That the fixed costs are negative should make us suspicious that we are outside the useful domain of our cost function.)

Find the revenue and profit functions.
\begin{equation*} \revenue = 5*(10)^{5} x^2+1.356x \end{equation*}\begin{align*} \profit\amp= 5*(10)^{5} x^2+1.356x 0.3121 x+169.35\\ \amp= 5*(10)^{5} x^2+1.0439x+169.35 \text{.} \end{align*} 
Evaluate cost, demand price, revenue, and profit at \(q_0\text{.}\)
At \(q = 75\) we have that \(\cost =  \$146\text{,}\) \(\Dprice = \$1.35\text{,}\) \(\revenue = \$101.42\text{,}\) and \(\profit = \$247\text{.}\)

Find all breakeven points.
Recompute profit for a different range of quantities and we get
Goal Seek using the quantity of 20000 as the basis gives a breakeven point at \(q= 21,039\text{.}\) The other place where the profit is 0 occurs for \(q = 161\text{.}\)

Graph the profit function over a domain that includes both breakeven points. Add a textbox and label to identify the first breakeven point.
The profit function shows the breakeven points close to 0 (161) and near 20,000 (21,039)
8.
Given demand price and cost are the linear functions that best fit the data below and that \(q_0=7500\text{.}\)
Quantity  5378  7984  8352 
Demand price  $12.00  $10.00  
Supply price  $31,100  $45,100 
9.
Mary has been put in charge of a school function. She estimates that there is a fixed cost of $1000 for the site plus a cost of $5 per person that attends. If she charges $15 a ticket she can sell 250 tickets, but if she lowers the price to $10 she can sell 500 tickets. Assuming the demand price is linear, what price should she charge to break even while maximizing attendance?
The description of the cost function states that the fixed cost is $1000, and the variable cost is $5, so the cost function is \(\cost=5 q+1000\text{.}\)
Two points are given for the price function: \((q_1 ,p_1 )=(250,15)\) and \((q_2 ,p_2 )=(500,10)\text{.}\) Hence the slope is \(m= (1510)/(250500)= 5/250= 1/50=0.02\text{.}\)
Then the demand price function is \((pp_0 )= m (qq_0)\) Hence
Entries in the cells before quick fill
Values after quick fill
Identified the breakeven points using Goal Seek
The optimal demand price is $6.48, which allows them to sell 676 tickets and break even.
Exercise Group.
For ExerciseÂ 2.2.6.10â€“2.2.6.12, given the cost and demand data:
Find best fitting equations of the cost and demand curves, assuming they are both linear.
Find the revenue and profit functions and evaluate them at the extra given value.
Find the breakeven points.
10.
Given the cost and demand data:
Quantity  100  120  140  160  180  155 
Cost  1015  1152  1327  1467  1651  
Demand price  21.3  18.1  14.7  12.3  8.6 
11.
Given the cost and demand data:
Quantity  5021  6051  6968  7901  9023  9917  7500 
Cost  80376  103874  128513  140258  
Demand price  19.69  18.78  18.05  17.61 

Find best fitting equations of the cost and demand curves, assuming they are both linear.
Using trendlines we get
\begin{align*} \cost \amp = 12.175x + 19117\\ \text{demand} \amp =  0.0005x + 22.506\text{.} \end{align*} 
Find the revenue and profit functions and evaluate them at the extra given value.
Creating a table with the cost and demand functions we get
We see that when quantity is 7500 the revenue is $140,670, and the profit is $30,240.50.

Find the breakeven points.
Note that these values are not usefull for finding the breakeven points. To find those we will start quantity \(q\) at 0 and go up to 20,000.
So the two breakeven points are \(q = 2054.8\) and \(q = 18,607.2\text{.}\)
12.
Given the cost and demand data:
Quantity  3160  3615  4092  4462  4837  5261  5579  6000 
Cost (Thousands)  90.1  126.70  197.2  234.9  
Demand price  25.31  20.91  17.04  14.37 
external/Examples/Section22Examplesunworked.xlsx
external/Examples/Section22Examples.xlsx