Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of televisionappearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table:Maroon 5 TV AppearancesDemand for GuitarsThis exercise contains only part a.a) Graph these data using the point drawing tool.The plotted graph shows a pattern that can be described by:O A. CyclesOC. Seasonality3 4 76 853 6 7 5 10 7B. Random variationsO D. Trend12-11-10-9-8-7-6-5-4-3-2-1-0-Guitar Demand234TV Appearances910 11

The data is given below:Maroon 5 TV AppearancesDemand for Guitars3346776581057

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 following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May June July August September October For the given forecast, the tracking signal = = MADS (round your response to two decimal places). November December Actual Demand 100 80 1/10 115 105 110 125 120 Forecast Demand 100 104 99 101 104 104 105 109
Month Demand Forecast Error 1 20 2 18 3 21 4 25 5 24 6 27 7 22 8 30 9 23 10 20 11 29 12 22 Mean Abs Error Problem 6: The demand manager of Maverick Jeans is responsible for ensuring sufficient warehouse space for the finished jeans that come from the production plants. It has occasionally been necessary to rent public warehouse space, something that Maverick would like to avoid. In order to estimate the space requirements the demand manager is evaluating moving-average forecasts. The demand (in 1,000 case units) for the last fiscal year is shown below. Bias MAD (mean error) Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 20 18 21 25 24 27 22 30 23 20 29 22 Use a three-month moving average to estimate the month-in- advance forecast of demand for months 4-12. Calculate the Bias and MAD. (Note: Adjust all cell values to two decimal points.)
Below is the number of complaints received in a department store for the first six months of operation: Month Complaints January February March April May June 37 48 84 96 114 148 If a three-month moving average is used to smooth this series, what would have been the forecast for July, rounded to the nearest whole number?
In October a bike dealer pridicted November demand for 150 hero bikes, actual demand was 161 bikes. Now using a smoothing constant chosen by the organisation of alpha 0.21, the dealer wants to forecast decemdemand using the exponential smoothing model ?
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 Pints Used 350 370 410 381 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376.67 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.35, and 0.45, using 0.45 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal 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.)
I 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 Pints Used 345 389 412 383 366 371 a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order recent period and smallest weight applies to oldest period.) the largest weight applies to most
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…
September 14 September 21 September 28 October 5 412 381 371 378 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.35, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal 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.)
a) Using the trend-projection (regression) method, develop a forecastfor the sales of Volkswagen Beetles in Nevada through year 6.b) What is the MAD?~c) What is the MSE?
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows: Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using a five-month moving average approach.
The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months. Compute an exponentially smoothed forecast with an a value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of January would be (type number only, two decimals) Month October November December January February March April May June July 733.25 Gasoline Demanded (gal.) 800 725 630 500 645 690 730 810 1,200 980
Please do not give solution in image formate thanku.

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