tabs lockMark 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 month Gescollected the data shown in the following tableVescThis 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):c) The estimate for guitar sales if Maroon 5 performed on TV 9 times =d) The correlation coefficient (r) for this modelThe coefficient of determination (2) for this model=The percentage of variation in sales that can be explained by TV appearances =QAN@2WS31/1X**38.0F3EDC$Maroon 5 TV AppearancesDemand for Guitarssales (round your response to two decimal places).(round your response to four decimal places).(round your response to four decimal places).4889RF%5VdEsFSY =TG% (round your response to two decimal places).A6Saks22FGYB35769 74 6 8 6 10 6&7HX44F7UN*008nDIIFII209MDDF9KY0OVAF10L-1-PFR*** 16+11$12NAOVERSIONS ADD WATERdeler

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

The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: YEAR CASES OFMERLOT WINE 2005 321 2006 407 2007 449 2008 507 2009 409 2010 551 2011 461 2012 427 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.
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 Y = 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): + 4 2 X 5 7 5 9 7 6 7 6 10 7
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 4 8 6 7 7 Demand for Guitars 4 6 7 5 10 6 This exercise contains only parts b, c, and d. Part 2 b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = enter your response here + enter your response herex
In January a battery dealer pridicts February demand of 2000 2 charger battery whereas the actual demand was 1756 unit of batteries , using a smoothing constant of alpha 0.34, the dealer wishes to forecast the march demand using the exponential smoothing model ?
Based on the quarterly sales of a department store over the period 2017-2021, the following seasonal regression model was constructed: Y. = 132.15 + 41. 64 t + 304. 22 Q1+ 191. 85 Q2 + 88. 42 Q3. Find the forecasts for the 2022 quarterly sales of the department store. %3D
The 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 30 48 70 90 Part 2 Using the least-squares regression LOADING... method, the trend equation for forecasting is (round your responses to two decimal places): y = enter your response here + enter your response here x Y=?+?x
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 1 215 2 240 3 205 4 190 5 160 6 195 7 150 8 140 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to 1 decimal place.
Using linear regression analysis, what would you estimate demand to be for each month next year? Month Forecast January February March April May June July August September October November December
The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past 8 months: Demand for Soft Shag Month Carpet (1,000 yd.) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Compute the exponentially smoothed forecast (a = .20) for the given data. Compute an adjusted exponentially smoothed forecast (with a = .20 and β = .20) for the given data
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage miles (round your response to the nearest whole number). a) Using a 2-year moving average, the forecast for year 6 = 1 3,050 2 4,000 3 3,450 4 3,750 5 3,750
After using your forecasting model for six months, you decide to test it using a tracking signal. Here are the forecast and actual demands for the six-month period: PERIOD FORECAST ACTUAL May 450 500 June 500 550 July 550 400 August 600 500 September 650 675 October 700 600 Find the tracking signal of each month
After graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to forecast monthly demand for golf balls. Using the following data, you developed a regression model that expresses monthly sales as a function of average temperature for the month: Monthly sales=-202.2+86.5x (average temperature) Click the icon to view the additional data. a. Show how the a and 6 values of -202.2 and 86.5 were calculated. Calculate the slope coefficient, b (enter your responses as whole numbers). (745) 12 12 2 =86.5 More Info March 2017 April May June July August September October November December January 2018 February Monthly Sales 5,300 3,990 5,700 6,520 7,600 7,420 Print 6,710 4,870 3,990 3,900 3,320 2,670 Temperature 51 56 Done 64 80 79 87 83 67 58 41 39 40 X

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