- Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below:610Week1Demand 202 323 274 537 267 8 930 35 22 24 29a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places):Week1Demand 20Forecast 20.02 323 274375266307358229241029

Given, Week Demand 1 20 2 23 3 27 4 37 5 26 6 30 7 35 8 22 9 24 10 29…

Answered: Sales of tablet computers at Ted…

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

A security company had to deploy guards for emergencies multiple times in the last four evenings. The numbers of emergencies for Monday, Tuesday, Wednesday, and Thursday were 7, 4, 8, and 11, respectively. What would be the security company's forecast for the number of emergencies on Friday using an exponential smoothing forecasting approach? (Use \alpha= 0.2 and a forecast for Monday of 10 emergencies)
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 concert promoter is forecasting this year's attendance for one of his concerts based on the following historical data: Year Attendance Four Years ago 10,000 Three Years ago 12,000 Two Years ago 18,000 Last Year 20,000 What is this year's forecast using exponential smoothing with alpha = 0.2, if last year's smoothed forecast was 15,000?
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week of Pints used Aug 31 360 Sep 7 370 Sep 14 412 Sep 21 383 Sep 28 371 Oct 5 371 A) The forecasted demand for the week of October 12 using a 3-week moving average = 375 B) Using the 3-week weighted moving average, with weights of 0.10, 0.35, 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- the largest weight applies to most recent period and smallest weight applies to oldest period.)
Income at the law firm of Smith and Jones for the period February to July was as follows: Month February March April May June July Income (in $ thousand) 90.0 91.5 96.0 85.4 92.2 96.0 Assume that the initial forecast for February is $85,000 and the initial trend adjustment is 0. The smoothing constants selected are a = 0.1 and ß = 0.2. Using trend-adjusted exponential smoothing, the forecast for the law firm's August income =O thousand dollars (round your response to two decimal places).
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
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
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: Week 1 2 4 6. 7 8 10 11 12 Actual Passenger Miles (in thousands) 17 21 19 23 19 17 21 19 23 21 13 24 a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use a = 0.25 (round your responses to two decimal places). Week 1 2 3 4 6. 7 8. 10 11 12 Forecasted Passenger Miles (in thousands) 17.00 17.00 18.00 18.25 19.44 19.33 18.75 19.31 19.23 20.17 b) The MAD for this model = thousand (round your response to two decimal places). c) Compute the Cumulative Forecast Errors, cumulative MAD in thousands, and tracking signals (round your responses to two decimal places). Cumulative Cumulative Tracking Signal Forecast Tracking Signal Forecast Week Errors MAD Week Errors MAD 1 0.00 0.00 9.23 2.11 4.37 2 4.00 2.00 2.00 8. 8.92 1.89 4.73 3 5.00 1.67 3.00 9. 12.69 2.09 6.06 9.75 2.44 4.00 10 13.52 1.97 6.87 9.31…
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
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 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 7 6 8 5 Demand for Guitars 3 6 7 5 10 7 b) Using the least-squares regression method, the equation for forecasting is (round your response to four decimal places): Y= _____+_____X C) The estimate for guitar sales if Maroon 5 performed on Tv 9 times =___ (round your response to 2 decimal places

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