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

can you make an operations management analysis for this forecasting
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?
please answer within 30 minutes.
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?
A large cement manufacturer uses exponential smoothing to forecast demand for a piece of pollution-control equipment. It appears that an increasing trend is present.Month At1 700 2 685 3 648 4 717 5 713 6 728 7 754 8 762 If the initial forecast for month 1 was 650 units and the trend over that period was 0 units, calculate FIT for the 9-month period. Use smoothing constants, Alpha = 0.1 andAlpha = 0.2.
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…
A company sells wielding generators. The demand for periods 1 to 9 is 44,52,50,,54,55,55,60, 56 and 62. Develop a regression forecasting equation and forecast sales for period 15
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

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