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 Gershecollected the data shown in the following table17on 18ne solve this Calculator Ask my instructor!1QThis 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):Y=0+0xF1@2WF2#3C80F3$544888F4do 5%Maroon 5 TV AppearancesDemand for Guitars14FOA6MacBook AirF6&178:F700 *8358 57 7368 4 9 6DIIFB(9DDF9)0OAF10Clear all?CF11+ 11=Check answerF12delete

By using least-squares regression method:Y= b+ mx where,Y = is the dependent variableX = is the…

Answered: Mark Gershon, owner of a musical…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Demand for oil changes at Garcia's Garage has been as follows: Month January February March April May June July August Number of Oil Changes 38 55 56 60 58 01 70 52 a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For January, let X=1; for February, let X 2; and so on. The forecasting model is given by the equation Y=X (Enter your responses rounded to two decimal places)
Use regression or simple exponential smoothing with the following data. For exponential smoothing, assume the forecast for year 1 was the same as the actual and use an alpha of 0.7. (use excel to show formauls used) Year Sales 1 290 2 340 3 400 4 410 5 400 1. What is the tracking signal for the forecast?
Consider the following time series data. Choose the correct time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Compare the three-week moving average forecast with the exponential smoothing forecast using Use trial and error to find a value of the exponential smoothing coefficient that results in a smaller MSE than what you calculated for = 0.2. Find a value of for the smallest MSE. Round your answer to three decimal places.
The Yummy Ice Cream Company projects the demand for ice cream by using first-order exponential smoothing. Last week the forecast was 100,000 gallons of ice cream, and 90,000 gallons was actually sold. Using alpha=.1, prepare a forecast for next week. Calculate the forecast using Alpha=.2 and Alpha=.3 for this problem. Which values of Alpha gave the best forecast, assuming actual demand for next week ends up being 95,000 gallons?
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 3 3 8 5 8 6 Demand for Guitars 2 5 6 4 11 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): Y = + c) The estimate for guitar sales if Maroon 5 performed on TV 11times = sales (round your response to two decimal places). d) The correlation coefficient (r)for this model = (round your response to four decimal places). The coefficient of determination (r2) for this model = (round your response to…
Hi, I need help with solving for the following values (boxed). Thank you.
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Jan Feb Mar AprMonth 1 2 3 4Number of Accidents 25 40 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = ? + ?x
If month one has 240,000 demands, month two 250,080 demands, month three 325,00 demands, month four 370,000 demands, month five 420,000 demands and month six 509,00 demands. Use a forecast for the first month of 240,000, an initial trend forecast of 50,000, and smoothing parameters of 0.35 for both demand smoothing and trend smoothing. Compute the forecasts and trends using double exponential smoothing
Which of the following are common metrics for measuring the relative quality of different forecasting methods? OAbsolutely Mean Mean Squared Accuracy O Mean Absolute Percent Error Mean Squared Response OMean Squared Error Mean Absolute Error (a.k.a. Mean Absolute Deviation)
The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: CASES OF MERLOT WINE 276 362 YEAR 2005 2006 2007 2008 2009 2010 2011 2012 404 462 364 506 416 382 Using an exponential smoothing model with an alpha value of 0.30, estimate the smoothed value calculated as of the end of 2012. Use the average demand for 2005 through 2007 as your initial forecast for 2008, and then smooth the forecast forward to 2012. (Round your intermediate calculations and final answer to the nearest whole number.) Answer is complete but not entirely correct. Forecast for 2012 372
Forecasting with Linear Regression The company VID-CO-19 has manufactured swim suits for men, women, and children for 10 years. The company is located in Boston, Massachusetts. Swim suits have always had a higher demand during the months of April, May, June, July, August, and September. The demand has always been lower during the months of October, November, December, January, February, and March. TETT The real demand, based on sales of year 20X1 is the following (it starts with December of the previous year): Period Bimester Demand Season Average December-January February-March 1 100 90 2 200 180 3 April-May June-July August-September 900 910 4 3,000 2,100 4,000 4,900 October-November 300 350 VID-CO-19 has hired you as an Operations Management expert to help them to forecast demand for year 20X2 using the Linear Regression Method. What is the TOTAL "seasonalized" or "deseasonalized' forecasted demand for Quito-Ecuador in year 20X2? (write your answer rounded to two decimals)
In a retail store, the actual sales of a particular product (in thousands of units) over the past few months are as follows: Month Sales 1 16 2 22 3 18 4 20 5 23 Using exponential smoothing method with α (smoothing constant) of 0.75 and the given forecast for month 1 equal to 10, what is the forecast for month 6?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS