Develop a spreadsheet for computing the demand for any values of the input variables in the linear demand and nonlinear demand prediction models in Examples 1.7 and 1.8 in the chapter.
EXAMPLE 1.7 A Linear Demand Prediction Model
A simple model to predict demand as a
D = a - bP (1.7)
where D is the demand, P is the unit price, a is a constant that estimates the demand when the price is zero, and b is the slope of the demand function. This model is most applicable when we want to predict the effect of small changes around the current price. For example, suppose we know that when the price is $100, demand is 19,000 units and that demand falls by 10 for each dollar of price increase. Using simple algebra, we can determine that a = 20,000 and b = 10. Thus, if the price is $80, the predicted demand is
D = 20,000 - 10(80) = 19,200 units
If the price increases to $90, the model predicts demand as
D = 20,000 - 10(90) = 19,100 units
If the price is $100, demand would be
D = 20,000 - 10(100) = 19,000 units
and so on. A graph of demand as a function of price is shown in Figure 1.5 as price varies between $80 and $120. We see that there is a constant decrease in demand for each $10 increase in price, a characteristic of a linear model.
EXAMPLE 1.8 A Nonlinear Demand Prediction Model
An alternative model assumes that price elasticity is constant. In this case, the appropriate model is
D = cP-d (1.8)
where c is the demand when the price is 0 and d > 0 is the price elasticity. To be consistent with Example 1.7, we assume that when the price is zero, demand is 20,000. Therefore, c = 20,000. We will also, as in Example 1.7,nassume that when the price is $100, D = 19,000.
Using these values in equation (1.8), we can determine the value for d as 0.0111382 (we can do this mathematically using logarithms, but we’ll see how to do this very easily using Excel in Chapter 11). Thus, if the price is $80, then the predicted demand is
D = 20,000(80)- 0.0111382 = 19,047
If the price is 90, the demand would be
D = 20,000(90)-0.0111382 = 19,022
If the price is 100, demand is
D = 20,000(100)- 0.0111382 = 19,000
A graph of demand as a function of price is shown in Figure 1.6. The predicted demand falls in a slight nonlinear fashion as price increases. For example, demand decreases by 25 units when the price increases from $80 to $90, but only by 22 units when the price increases from $90 to $100.
If the price increases to $110, you would see a smaller decrease in demand. Therefore, we see a nonlinear relationship, in contrast to Example 1.7.
Want to see the full answer?
Check out a sample textbook solutionChapter 1 Solutions
Business Analytics
- 23. Consider a simple economy with just two industries: farming and manufacturing. Farming consumes 1/2 of the food and 1/3 of the manufactured goods. Manufacturing consumes 1/2 of the food and 2/3 of the manufactured goods. Assuming the economy is closed and in equilibrium, find the relative outputs of the farming and manufacturing industries.arrow_forwardLater High School Graduates This is a continuation of Exercise 16. The following table shows the number, in millions, graduating from high school in the United States in the given year. Year Number graduating in millions 2001 2.85 2003 2.98 2005 3.11 2007 3.24 a. Find the slope of the linear function modeling high school graduations, and explain in practical terms the meaning of the slope. b. Find a formula for a linear function that models these data. c. Express, using functional notation, the number graduating from high school in 2008, and then calculate the value. d. The actual number graduating from high school in 1994 was about 2.52 million. Compare this with the value given by the formula in part b and with your answer to part of Exercise 16. Which is closer to the actual value? In general terms, what was the trend in high school graduations from 1985 to 2007? 16. High School Graduates The following table shows the number, in millions, graduating from high school in the United States in the given year.16 Year Number graduating in millions 1985 2.83 1987 2.65 1989 2.47 1991 2.29 a. By calculating difference, show that these data can be modeled using a linear function. b. What is the slope for the linear function modeling high school graduations? Explain in practical terms the meaning of the slope. c. Find a formula for a linear function that models these data. d. Express, using functional notation, the number graduating from high school in 1994, and then use your formula from part c to calculate that value.arrow_forward
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageLinear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning