Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Letz Products has two decisions to make, with the second decision dependent on the outcomeof the first. The company intends to build a new plant. Letz has the option of conducting itsown marketing research survey for which the results will either be positive or negative. Theinformation from this survey could help it decide whether to build a large plant, to build a smallplant, or not to build at all. Letz recognizes that although such a survey will not provide it withperfect information, it may be extremely helpful.
Using the image explain to your client (Letz) what the above decision tree shows. You arerequired to show all working.
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular
group Maroon 5 during the previous month. Gershon has collected the data shown in the following table:
Maroon 5 TV Appearances
Demand for Guitars
4
Y =
3
4
5
D
5
6 7 7
7 4 10 6
This exercise contains only parts b, c, and d.
b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places):
= 0+0x
Regression and Utility Rates; Sustainability For several years, many utilities haveemployed regression analysis to forecast monthly utility usage by residential customers usingweather forecasts, the number of holidays, the number of days in the month, and other factors.For example, the Connecticut Department of Public Utility Control (CDPUC) has determinedthat regression, properly used, can accurately predict natural gas usage. Most public gas utilities serving Connecticut have reported levels of accuracy from 4% to 10% using regression.One company, Dominion Natural Gas Company of Ohio, uses this approach not to forecast, butto explain to customers why their natural gas bills have gone up or down compared to the priormonth and to the same month of the prior year. The bill shows total MCF (thousand cubic feetof natural gas) used by the customer for that month and why the total MCF usage has changed,based on three factors:1. Change in temperature. Each degree increase in temperature…
Knowledge Booster
Similar questions
- The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?arrow_forwardc) If the forecasted demand for the week of August 31 is 345 and α = 0.20, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places).arrow_forwardCalculate a regression line for the data and indicate the forecast of sales for a store with advertising spending of R240,000? and R300,000? Store Advertising Sales 1 14 6 2 11 3 3 15 5 4 16 5 5 24 15 6 28 18 7 22 17 8 21 12 9 26 15 10 43 20 11 34 14 12 9 5arrow_forward
- The manager of the Salem police department motor poolwants to develop a forecast model for annual maintenanceon police cars based on mileage in the past year and age ofthe cars. The following data have been collected for eightdifferent cars: a. Using Excel develop a multiple regression equationfor these data.b. What is the coefficient of determination for thisregression equation?c. Forecast the annual maintenance cost for a police carthat is four years old and will be driven 10,000 miles inone year.arrow_forwardThe following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of Accidents 25 45 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = - 5 + 25.5 x Using least-squares regression, the forecast for the number of accidents that will occur in the month of May = 122.5 accidents (enter your response as a whole number).arrow_forward4arrow_forward
- Scenario 3: Kohl’s Department Store has experienced steady growth in every department over the past decade. Sales and market share continue to grow but Kohl’s wants to know the level of customer satisfaction among its existing target market. In addition, the company would like to know how to continue to expand sales over the upcoming decade and would like to know how they could better serve customers within their stores and online. Using any form of a Likert scale, create a questionnaire with a minimum of 10 questions that Kohl’s current customers could answer:arrow_forwardWhat forecasting technique makes use of written surveys or telephone interviews? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting? 2 Which qualitative forecasting technique was developed to ensure that the input from every participant in the process is weighted equally? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting? 3 When forecasting demand for new products, sometimes firms will use demand data from similar existing products to help forecast demand for the new product. What technique is this an example of? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecastingarrow_forwardUse this data to illustrate how the manager might make the decision if he uses each of the following heuristics: elimination by aspects (EBA)arrow_forward
- The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average = 375 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.25, and 0.60, using 0.60 for the most recent week, the forecasted demand for the week of October 12 = 375.45 pints (round your response to two deamal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 360 and a = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). Week Of Pints Used 360 389 410 381 366…arrow_forwardThe following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.30, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) Week Of c) If the forecasted demand for the week of August 31 is 360 and α = 0.20, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7 September 14 September 21 September 28 October 5 October 12 Pints Used 360…arrow_forwardThe following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.30, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 345 and x = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). Week Of August 31 September 7 September 14 September 21 September 28 October 5 October 12 Pints Used 345 370 408 383 371 374 Pints Used 345 370 408 383 371…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing