2. Given the data below, forecastYearMileage3000380035003800370012345a. the 6th year using the weighted moving average w/weights.7.&.3b.The 6th year using Exponential Smoothing with F1 =3000 and alpha = .7c.Calculate the MAD for a and b, tell me which one is the best modeld. Calculate the regression line, the forecast for the 6th and the 12th years,the residual of the 4th year, and tell me if it is s good or a bad model

Forecasting the demand or sales can be done by various methods like weighted moving averages,…

Answered: a. the 6th year using the weighted…

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

If the weights for a moving average forecast with a span of 4 are: 0.4,0.2,0.3,0.1 Problem: Under prediction Problem: Over prediction No problem
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?
Pravinbhai
Grace owns and operates a chain of 12 vegetable protein "hamburger" restaurants in northern Luzon. Sales figures and advertising expenses for the stores are provided in the table below. Sales are given in millions of dollars; advertising expenses are in tens of thousands of dollars. Calculate a regression line for the data. What is your forecast of sales for a store with advertising spending of $240,000? $300,000? Vince Coffee chain sells temperature-controlled smart mugs at $150 each. The monthly sales of mugs for the last twelve months were: Given: Month Sales January 825 February 756 March 808 April 950 May 678 June 875 July 695 August 589 September 690 October 890 November 1030 December 1525 a. Compute a 3-month moving average demand forecast for each month from June through December. b. Compute a 5-month moving average demand forecast for each month from June through December. c. Calculate the MSE…
Dic 2 - Time Series Analysis and F eBook Problem 6-01 (Algorithmic) Consider the following time series data. Thm Week 1 2 3 4 5 6 Value 20 13 15 11 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error. If required, round your answer to one decimal place. c. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places. % d. What is the forecast for week 7? If required, round your answer to two decimal place.
Can you please solve all parts of the question manually. Thank you!
The following data are for calculator sales in units at an electronics store over the past nine weeks: Week 1 2 3 4 5 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE Sales Find the coefficient of determination (²). The coefficient of determination r² = 0. (Enter your response rounded to two decimal places.) 44459 46 51 58 Use trend projection with regression to forecast sales for weeks 10-13. What are the error measures (CFE, MSE, 6, MAD, and MAPE) for this forecasting procedure? How about r²? Obtain the trend projection with regression forecast for weeks 10-13. (Enter your responses rounded to two decimal places.) Forecast, Ft Period 10 11 12 13 Week 6 69809 7 Sales 54 63 53 61 MAD U MAPE %
Hi, I need help with solving for the following values (boxed). Thank you.
Please answer fast please arjent help please
MSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15
14. The demand for Krispee Crunchies is experiencing a decline. The company wants to monitor demand for this product closely as it nears the end of its life cycle. The following table shows the actual sales history for January to October. Generate forecasts for November to December, using the trend projection with regression method. Looking at the accuracy of its forecasts in the Trend Projection Worksheet, as well as the other statistics provided, how confident are you in these forecasts for November to December? Month January February March April May June Sales 890,000 800,000 825,000 840,000 730,000 780,000 Month July August September October November December Sales 710,000 730,000 680,000 670,000
Please do not give solution in image format 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