You are the manager of a large automobile dealership who wants to learn more about the effective- ness of various discounts offered to customers over the past 14 months. Following are the average negotiated prices for each month and the quantities sold of a basic model (adjusted for various options) over this period of time. 1. Graph this information on a scatter plot. Estimate the demand equation. What do the regression results indicate about the desirability of discounting the price? Explain. Month Price Quantity Jan. 12,500 15 Feb. 12,200 17 Mar. 11,900 16 Apr. 12,000 18 May 11,800 20 June 12,500 18 July 11,700 22 Aug. 12,100 15 Sept. 11,400 22 Oct. 11,400 25 Nov. 11,200 24 Dec. 11,000 30 Jan. 10,800 25 Feb. 10,000 28 2. What other factors besides price might be included in this equation? Do you foresee any difficulty in obtaining these additional data or incorporating them in the regression analysis?

You are the manager of a large automobile dealership who wants to learn more about the effective- ness of various discounts offered to customers over the past 14 months. Following are the average negotiated prices for each month and the quantities sold of a basic model (adjusted for various options) over this period of time. 1. Graph this information on a scatter plot. Estimate the demand equation. What do the regression results indicate about the desirability of discounting the price? Explain. Month Price Quantity Jan. 12,500 15 Feb. 12,200 17 Mar. 11,900 16 Apr. 12,000 18 May 11,800 20 June 12,500 18 July 11,700 22 Aug. 12,100 15 Sept. 11,400 22 Oct. 11,400 25 Nov. 11,200 24 Dec. 11,000 30 Jan. 10,800 25 Feb. 10,000 28 2. What other factors besides price might be included in this equation? Do you foresee any difficulty in obtaining these additional data or incorporating them in the regression analysis?

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

ChapterB: Differential Calculus Techniques In Management

Section: Chapter Questions

Problem 8E

See similar textbooks

Similar questions

The economic analysis division of Mapco Enterprises has estimated the demand function for its line of weed trimmers as QD=18,000+0.4N350PM+90Ps where N=numberofnewhomescompletedintheprimarymarketarea PM=priceoftheMapcotrimmerPS=priceofitscompetitorsSurefiretrimmer In 2010, 15,000 new homes are expected to be completed in the primary market area. Mapco plans to charge $50 for its trimmer. The Surefire trimmer is expected to sell for $55. What sales are forecasted for 2010 under these conditions? If its competitor cuts the price of the Surefire trimmer to $50, what effect will this have on Mapcos sales? What effect would a 30 percent reduction in the number of new homes completed have on Mapcos sales (ignore the impact of the price cut of the Surefire trimmer)?
Metropolitan Hospital has estimated its average monthly bed needs as N=1,000+9X where X=timeperiod(months);January2002=0 N=monthlybedneeds Assume that no new hospital additions are expected in the area in the foreseeable future. The following monthly seasonal adjustment factors have been estimated, using data from the past five years: Forecast Metropolitans bed demand for January, April, July, November, and December 2007. If the following actual and forecast values for June bed demands have been recorded, what seasonal adjustment factor would you recommend be used in making future June forecasts?
Bell Greenhouses has estimated its monthly demand for potting soil to be the following: N=400+4X where N=monthlydemandforbagsofpottingsoil X=timeperiodsinmonths(March2006=0) Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: Forecast Bell Greenhouses demand for potting soil in March, June, August, and December 2007. If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast.
Estimate the double-log (log linear) time trend model for log cruise ship arrivals against log time. Estimate a linear time trend model of cruise ship arrivals against time. Calculate the root mean square error between the predicted and actual value of cruise ship arrivals. Is the root mean square error greater for the double log non-linear time trend model or for the linear time trend model?
The Questor Corporation has experienced the following sales pattern over a 10-year period: Compute the equation of a trend line (similar to Equation 5.4) for these sales data to forecast sales for the next year. (Let 2004=0,2005=1, etc., for the time variable.) What does this equation forecast for sales in the year 2014? Use a first-order exponential smoothing model with a w of 0.9 to forecast sales for the year 2014.
Savings-Mart (a chain of discount department stores) sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during the fall and winter quarters. The company developed the following quarterly sales forecasting model: Y t=8.25+0.125t2.75D1t+3.50D3t where Y t=predictedsales(million)inquartert 8.25=quarterlysales(million)whent=0 t=timeperiod(quarter)wherethefourthquarterof2002=0,firstquarterof2003=1,secondquarterof2003=2,... D1t={1forfirst-quarterobservations0otherwiseD2t={1forsecond-quarterobservations0otherwiseD3t={1forthird-quarterobservations0otherwise Forecast Savings-Marts sales of patio and lawn furniture for each quarter of 2010.
Plot the logarithm of arrivals for each transportation mode against time, all on the same graph. Which now appears to be growing the fastest?
Interpret the coefficients and calculate the price elasticity of soft drink demand.
Furniture Forecasting Futura Furniture Products manufactures upscale office furniture for the Office of the Future. The sales division comprises regionally based sales offices made up of sales representatives and regional managers. Sales representativeswho report to the regional managersconduct direct sales efforts with customers in their regions. As part of the sales process, representatives gather information about likely future orders and convey that information back to the regional managers. Regional managers use that information to create sales forecasts, which are then used as the basis for manufacturing schedules. Sales representatives and regional managers are both compensated on a salary plus commission (percentage of revenue as pricing is centrally controlled). However, a regional managers commission is adjusted based on regional sales that exceed the forecasted budget. Corporate managers are concerned with one of Futuras key products, the DeskPod. They worry that DeskPod forecasts are inaccurate, causing extreme havoc in the manufacturing process. How are the forecasts likely to be inaccurate? What do you think is driving this inaccuracy? How might this problem be solved?
Again, holding the other variables constant, what would be the saving in per-student operating expenditures of an increase in enrollment from 500 to 1,000?
Wonopoly and natural resource prices Suppose that a firm is the sole owner of a stock of a natural resource. a. How should the analysis of the maximization of the discounted profits from selling this resource (Equation 17.63 be modified to take this fact into account? b. Suppose that the demand for the resource in question had a constant elasticity form q(t)=a[p(t)]b . How would this change the price dynamics shown in Equation 17.67? c. How would the answer to Problem 17.7 be changed if the entire crude oil supply were owned by a single firm?
A firm experienced the demand shown in the following table. *Unkown future value to be forecast Fill in the table by preparing forecasts based on a five-year moving average, a three-year moving average, and exponential smoothing (with a w=0.9 and a w=0.3). Note The exponential smoothing forecasts may be begun by assuming Y t+1=Yt. Using the forecasts from 2005 through 2009, compare the accuracy of each of the forecasting methods based on the RMSE criterion. Which forecast would you have used for 2010? Why?