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...
-
An analyzer measures the pH of a process stream every 15 minutes. During normal process operation, the mean and standard deviation for the pH measurement are x = 5.75 and s = 0.05, respectively. When...
-
Consider the following data for the assembly division of Fenton Watches Inc.: The assembly division uses the weighted-average method of process costing. Required Compute equivalent units for direct...
-
The accounting firm of Glofry and Tammar (G&T) has been asked to arrange for a $2 million loan for Tang En- terprises by its client Ted Hoover at Hoover Company. Hoover Company is involved in a...
-
In 1997, Bobby Randall was hired at Wal-Mart. At the time, Randall was not a convicted felon but had been previously convicted three times on misdemeanor charges for indecent exposure. At the time of...
-
A confidence interval for the population mean number of jobs a person has before the age of forty was found to be 8.1 to 10.4. Find the midpoint of this confidence interval.
-
Reverend Peter Wilson qualifies as a minister for income tax purposes. He receives a $75,000 annual salary and a $32,000 housing allowance. He pays $24,000 (including utilities) per year for the...
-
P9-5B Viking Voyager specializes in the design and production of replica Viking boats. On January 1, 2024, the company issues $3,000,000 of 9% bonds, due in 10 years, with interest payable...
-
A pharmaceutical company may be valued at $ 2 0 0 million if it gets FDA approval for a key drug being developed, or $ 7 0 million otherwise, and both scenarios are equally probable. The...
-
What role does technology play in contributing to or alleviating stress, and what are the best practices for using technology to manage stress ?
-
The average cruise has 100 passengers on board. Each passenger pays $90 for a day's cruising. The riverboat cruises 120 days each year in meeting current demand. There are 14 crew who are each paid...
-
Q.No.4. The Kuli Khan Company has the following shareholders' equity account: Common stock (Rs. 24 par value) Additional paid-in capital Retained earnings Total shareholders' equity The current...
-
The accountant for Click Photography Ltd has estimated the following cost pools and relevant activity drivers for the coming year: Activity Budgeted Overhead Cost Machine setups $ 300,000 Material...
-
Required information [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master...
-
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...
-
What does a low average reserves per well ratio indicate?
-
Lomax Company reported the following costs on its financial statements (in thousands): REQUIRED: Using the reserve disclosure for Lomax Company in problem 13 and the data presented in this problem,...
-
Lomax Companys Statement No. 69 disclosures included the following information: REQUIRED: Using the information for Lomax Company in problems 13, 14, and 15 and in this problem: a. Compute the value...
Study smarter with the SolutionInn App