Question: Upper management has asked you to join the Demand Planning Project Team. This team has been task with testing four different forecasting algorithm: Simple Exponential

Upper management has asked you to join the Demand Planning Project Team. This team has been task with testing four different forecasting algorithm: Simple Exponential Smoothing (SES), Weighted Moving Average, and Simple Moving Average. 2 4 Month Demand BI 1 10 0.18 3 75 1.66 125 2.9 5 140 3.14 6 55 1.23 7 25 0.59 8 20 0.56 9 15 0.36 10 10 0.31 11 5 5 0.18 12 5 0.13 0.76 Part 1. Calculate a forecast for each of the algorithm using the following parameters. Forecast 7 4 5 6 8 9 9 10 11 12 SES SMA WMA 3 70 70 70 1 Simple Exponential Smoothing Algorithm Parameters: Alpha= 3 F4= F5 = F6 = F7= F8= F9 = F10 = F11 = F12 = * Moving Average periods 3 Simple Moving Average Algorithm Parameters: 14 F5 = F6 17 F8= 19 F10 = F11 = F12 4 Weighted Moving Average Algorithm Parameters: Ml = 60, M2 = 30, & M3 = .10 F4= FS F6 F7 = F8= F9= F10 F11 =1 F12 = 1

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!

Upper management has asked you to join the Demand Planning Project Team. This team has been task with testing three different forecasting algorithm: Simple Exponential Smoothing, Weighted Moving...

Q3. Upper management has asked you to join the Demand Planning Project Team. This team has been task with testing four different forecasting algorithm: Simple Moving Average and Weighted Moving...

help please Final Project Assignment SCM 301 Overview of the Case Analysis We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The...

Final Project Assignment SCM 301 Fall 2015 Overview of the Case Analysis We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The...

Overview of the Case Analysis We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The purpose of this case analysis is to integrate...

Use data in worksheet named Q1-4 to answer questions 1 4. Assume the sample data was published in a business magazine. 1) Which of the following is true about the data? A. Class is qualitative and...

SCM 301 Spring 2016 Overview of the Case Analysis We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The purpose of this case...

x1 = 10, s1 = 2.1, n1 = 15, x2 = 12, s2 = 2.3, n2 = 15 a. Two-tailed test, = 0.05 b. 95% confidence interval We have provided summary statistics for independent simple random samples from two...

Why would someone consider how broadly or narrowly the relevant market is considered to be so critical to the results when HHI values are used to evaluate mergers?

The cost of debt, r d , is normally less than r s , so r d ( 1 - T ) will normally be much less than r 5 . Therefore, as long as the firm is not completely debt financed, the weighted average cost of...

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...