The demand data for Double T Computer Services appears below. The company wants you to forecast the demand for period 4. What is your forecast using the least squares method?Period Demand137240340O 44.6O 40O 46.0O 43.3O 42.0

Answered: The demand data for Double T Computer…

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

Please do fast ASAP fast
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 2 6 7 10 3 4 5 6 7 8 9 a. Calculate the single exponential smoothing forecast for these data using an a of 30 and an initial forecast (F of 31. (Round your answers to 2 decimal places) Month 50 Month 31 4 5 6 7 b. Calculate the exponential smoothing with trend forecast for these data using and of 0:30, a 5 of 0.30, an initial trend forecast (Tof 1, and an initial exponentially smoothed forecast (F3 of 30. (Round your answers to 2 decimal places) B 9 Exponential Smoothing 10 31 34 33 35 FITI 37 36 38 40 40 41 e-2. Which is best? c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts (Round your answers to 2 decimal places) MAD Single exponential smoothing forecast Exponential amoothing with trend forecast Single exponential smoothing forecast O Exponential smoothing with trend forecast
The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 7 11 7 13 12 10 13 8 This exercise contains only parts b, c, and d. Part 2 b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Part 3 c) Using the 3-year weighted moving average with weights 0.10, 0.30, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). Part 4 d) Mean absolute deviation for the forecast developed…
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.
If a 2-year moving average is used to make the forecast, the Mean Absolute Deviation based on this how many miles?
The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 9 13 8 11 14 9 13 7 Part 2 Using exponential smoothing with α = 0.40 and a forecast for year 1 of 5.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). Year 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 5.0 5.45.4 6.46.4 5.55.5 6.96.9 9.39.3 8.88.8 9.79.7 11.411.4 10.410.4 11.511.5 9.79.7 Part 3 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers). Year 2 3 4 5 6 7 8 9 10 11 12 Forecast enter your response here enter your response here enter your response here enter your…
The actual monthly demand of special pizza in the past 6 months were: 411, 272, 302, 396, 400, 308 If a four-month moving average forecasting model is used to generate forecasts, what is the value of the Mean Absolute Percent Error (in percent)? Use at least 4 decimals.
The following table shows predicted product demand using your particular forecasting method along with the actual demand that occurred: FORECAST ACTUAL 1,515 1,585 1,415 1,515 1,715 1,615 1,755 1,680 1,805 1,730 Compute the tracking signal of each period using the mean absolute deviation and running sum of forecast errors.
Elna inc is a microwave manufacturing and distribution company based in Jakarta. The company needs to estimate production demand using the historical sales data of the last 24 months (periods).A logistics manager of the company then uses the moving average, exponential smoothing, and simple linear regression methods to determine sales forecasts for the next 12 months (Graphically illustrate the results). Provide an analysis and the results of bias, MAPE, MSE, and MAD for the forecasting decisions.Moving average is 4 month, and alfa is 0.05
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?…
Practice examples. Please show solution. Thank you.
Given the following demand data, compute a simple exponential smoothing forecast for alpha values of 0.3 and 0.5. Use the actual value in Period 1 as your starting forecast in Period 2. (Round all your calculations to two decimal points.) Period Actual Demand 34 35 36 37 37 38 35 36 33 30 10 11 Answer is complete but not entirely correct. a- 0.3 a = 0.5 Period Forecast Forocast 1. 59.00 O 51.50 8 46.55 8 2 59.00 8 59.00 8 55.25 Answer is complete but not entirely correct. a = 0.3 a = 0.5 Period Forecast Forecast 1 2 59.00 59.00 X 3 51.50 X 59.00 X 4 46.55 X 55.25 X 42.78 50.90 X 40.75 8 46.84 X 39.62 43.79 X 8 38.84 X 41.71 X 38.58 40.27 X 10 37.51 X 39.43 X 11 37.06 X 38.47 X 12 35.84 37.76 8 S462 785 63

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

The demand data for Double T Computer Services appears below. The company wants you to forecast the demand for period 4. What is your forecast using the least squares method? Period Demand 1 37 40 3 40 O 44.6 O 40 O 46.0 O 43.3 O 42.0