Question: Weighted Moving and Exponential Smooth Forecasts Calculate the forecasts based on the following data table 1. Calculate the 3-month Weighted Moving Average forecast for April

Weighted Moving and Exponential Smooth Forecasts Calculate the forecasts based on the following data table 1. Calculate the 3-month Weighted Moving Average forecast for April through July using weights of 1=.5,2=3,1=2 2. Calculate the Exponential Smooth Forecast for February through July with =35. The forecast for January is given to allow you to get started. Using the 3-month Weighted Moving Average forecast (WMA3). What is the forecast for April? 49.8 50.7 52.7 55.4 Question 2 25 pts Using the 3-month Weighted Moving Average forecast (WMA3), what is the forecast for June? 52.7 49.8 50.7 55.4 Using the Exponential Smooth forecast, what is the forecast for April? 49.25 49.86 51.31 53.65 Question 4 25 pts Using the Exponential Smooth forecast, what is the forecast for June? 51.31 49.25 49.86 53.65

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Weighted Moving and Exponential Smooth Forecasts Calculate the forecasts based on the following data table 1. Calculate the 3-month Weighted Moving Average forecast for April through July using...

You are the manager of an office supply company, and you are working to prepare monthly forecasts for the upcoming year. The attached spreadsheet contains a full year of demand data, and you are...

Question 1 2 pts Cell D17. Enter mean monthly forecast F1 for the period from April 2020 through January 2021, must be a whole number. Question 2 2 pts Cell E17. Enter cumulative F1 forecast error...

Cell 117. Enter mean absolute deviation (MAD) for F2 forecast for the period from April 2020 through January 2021, must be a whole number. 2 pts Question 5 Cell J17. Enter mean absolute percent error...

Question 9 1 pts Cell G7. Enter F1 absolute % error for April 2020, must be a number with two decimals, e.g., 15.23. Do not enter the % sign. Question 10 1 pts Cell G9. Enter F1 absolute % error for...

Question 6 Cell E11. Enter F1 error for August 2020, must be a whole number. Question 7 Cell F10. Enter F1 absolute error for July 2020, must be a whole number. Question 8 Cell F17. Enter F1 MAD,...

Question 15 1 pts Cell 110. Enter F2 absolute error for July 2020, must be a whole number. Question 16 1 pts Cell 18. Enter F2 absolute % error for May 2020, must be a number with two decimals, e.g....

Question 7 When compared to forecasting model F1 based on MAD, the forecasting model F2 ... O provides a more accurate forecast for this dataset, O provides a less accurate forecast for this dataset....

Historical demand for a product is a. Using a weighted moving average with weights of 0.60 (June), 0.20 (May), and 0.20 (April), find the answer to 1 decimal place.) forecast. (Round your b. Using a...

I need to check my calculations, I am pretty confident that I calculated correctly, but I want to be sure. Also, I am struggling with question 6. Please, please make sure to answer question 6. Thank...

1. R4 8975 5422 2309 7567 8247 1410 5761 4359

DNA replication is fast, virtually error-free, and coordinated with cell division. Discuss which of these three features you think is the most important.

How do overinsurance provisions ( Other Insurance in This Insurer, Insurance with Other Insurer, and Other Insurance with Other Insurers ) protect insurers? a . If several insurers cover the same...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...