Develop a spreadsheet for computing the demand for any values of the input variables in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 function of price is the linear model 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 alge- bra, we can determine that a 20,000 and b 10. Thus, if the price is $80, the predicted demand is Figure 1.5 Graph of Linear Demand Model D-a-bP Number of Units 19,300 19, 200 19, 100 19,000 18,900 10,000 18,700 18,000 $80 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. D=20,000-10P 5:90 $100 Price $110 $120 EXAMPLE 1.8 A Nonlinear Demand Prediction Model An alternative model assumes that price elasticity is con- stant. In this case, the appropriate model is D = ch (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, c20,000. We will also, as in Example 1.7, assume that when the price is $100, D- 19,000. Using these values in equation (1.8), we can deter- mine the value for d as 0.0111382 (we can do this math- ematically using logarithms, but we'll see how t 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)-00111382 If the price is 100, demand is = 19,022 D 20,000(100)-0.011138219,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 increasies from $90 to $100. If the price increases to $110, you would see a smaller decrease in demand. Therefore, we see a nonlinear relation- ship, in contrast to Example 1.7. 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 function of price is the linear model 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 alge- bra, we can determine that a 20,000 and b 10. Thus, if the price is $80, the predicted demand is Figure 1.5 Graph of Linear Demand Model D-a-bP Number of Units 19,300 19, 200 19, 100 19,000 18,900 10,000 18,700 18,000 $80 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. D=20,000-10P 5:90 $100 Price $110 $120 EXAMPLE 1.8 A Nonlinear Demand Prediction Model An alternative model assumes that price elasticity is con- stant. In this case, the appropriate model is D = ch (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, c20,000. We will also, as in Example 1.7, assume that when the price is $100, D- 19,000. Using these values in equation (1.8), we can deter- mine the value for d as 0.0111382 (we can do this math- ematically using logarithms, but we'll see how t 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)-00111382 If the price is 100, demand is = 19,022 D 20,000(100)-0.011138219,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 increasies from $90 to $100. If the price increases to $110, you would see a smaller decrease in demand. Therefore, we see a nonlinear relation- ship, in contrast to Example 1.7.
Expert Answer:
Answer rating: 100% (QA)
Answer 1 Linear demand model Example 17 D a bP Given a 20000 and b 10 D 20000 10b Excel output table ... View the full answer
Related Book For
Hydrology and Floodplain Analysis
ISBN: 978-0132567961
5th edition
Authors: Philip B. Bedient, Wayne C. Huber, Baxter E. Vieux
Posted Date:
Students also viewed these accounting questions
-
Develop a spreadsheet for Problem 9. (a) What would your recommendation be if the weight for the implementation risks went down to 10 and the weight of cultural differences went up to 25? (b) Suppose...
-
Using the data below, develop a spreadsheet for finding the least-cost order quantities when there are quantity discounts (order cost = $60, inventory holding cost = 30 percent of item value, and...
-
Develop a spreadsheet for Muskingum routing using the given inflow hydrograph through the river reach, where K = 2 hr, x = 0.15, and t = 2 hr. Time (hr)Inflow (m3/s) 0..............................60...
-
Hybrid Corporation began operations in 2018 and during that year purchased equity investments. It owns less than 20% of the voting shares for all companies whose stock it purchased. The year-end cost...
-
What are the measurement issues to consider when using return on investment (ROI)?
-
When (1 + ax) n is expanded as a series in ascending powers of x, the coefficients of x and x 2 are 6 and 27 respectively. a. Find the values of a and n. b. Find the coefficient of x 3 . c. State the...
-
A parallel-plate capacitor connected to a battery maintaining a potential difference \(V\) across the capacitor initially stores electric potential energy \(U_{1}^{E}\). If the plate area is doubled...
-
Your client, Cascade Company, is planning to invest some of its excess cash in 5-year revenue bonds issued by the county and in the shares of one of its suppliers, Teton Co. Tetons shares trade on...
-
Microsoft Corporation makes Xbox video game consoles. For Microsoft's financial year YYYY, please make use of the following provided information regarding the inventory of those Xbox consoles:...
-
Aggie Oil Corporation, a new successful efforts company, incurred the following costs and made the other transactions shown below for the years 2018 and 2019. 2018 a. Paid $225,000 for G&G costs...
-
A triangular weir has a 90 notch. What head will produce 1200 gpm? (cw = 2.5 - english) 0.31 m O2.04 m O 0.62 m O 1.02 m
-
Sincere apologies can be effective tools for communicating bad news. By contrast, insincere apologies can alienate your audience. Think of a situation in which you might want to offer someone an...
-
If an interviewees responses can lead to meaningful tangents, why is an interview guide useful?
-
When possible, face-to-face meetings are usually the best medium for sharing bad news, even if they need to be supplemented with an email or memo for documentation. If you are apprehensive about...
-
HealthScape Advisors Arjun Aggarwal (page 300) recommends that professionals develop a short list of trusted sources where you can go to begin your research. What are some strategies you can use to...
-
When you cite a published book or article you find in your research, its important to include the date the information was originally published. When you cite a company website, should you try to...
-
1- The policy of distributing profits to shareholders is one of the most important financing policies in the company due to its direct relationship with shareholders and its reflection on the share...
-
Read the Forecasting Supply Chain Demand Starbucks Corporation case in your text Operations and Supply Chain Management on pages 484-485, then address the four questions associated with the...
-
A catchment is to be simulated using the Clerk model, that is, by routing using a time-area method (to produce hydrograph time delays), followed by routing through a linear reservoir (to produce...
-
The incremental rainfall data in the table were recorded at a rainfall gage on a small urban parking lot of 1 acre. Be careful to use a 0.5-hr time step and record intensity in cm/hr. (a) Plot the...
-
An inflow hydrograph is given for a reservoir that has a weir-spillway outflow structure. The flow through the spillway is governed by the equation Q = 3.75Ly3/2(cfs), Where L is the length of the...
-
Think of some companies that you are familiar with or that youve read about where you think the human resource managers have been successful in adding value. What do the HR managers do to lead you to...
-
Briefly describe what is meant by DEI efforts.
-
Explain each of the four examples of a bona fide occupational qualification.
Study smarter with the SolutionInn App