Question: Problem 3 - 1 3 ( Algo ) Historical demand for a product is as follows: a . Using a simple four - month moving

Problem 3-13(Algo)
Historical demand for a product is as follows:
a. Using a simple four-month moving average, calculate a forecast for October.
Note: Round your answer to \(\mathbf{2}\) decimal places.
Answer is complete and correct.
b. Using single exponential smoothing with \(\alpha=0.30\) and a September forecast =55, calculate a forecast for October.
Note: Round your answer to \(\mathbf{2}\) decimal places.
c. Using simple linear regression, calculate the trend line for the historical data. Say the \( X \) axis is April =1, May =2, and so on, while the \( Y \) axis is demand.
Note: Round your Intercept value to the nearest whole number and slope value to \(\mathbf{2}\) decimal places.
Answer is complete but not entirely correct.
d. Calculate a forecast for October using your regression formula.
Note: Round your answer to \(\mathbf{2}\) decimal places.
Answer is complete but not entirely correct. Problem 3-13(Algo)
Historical demand for a product is as follows:
a. Using a simple four-month moving average, calculate a forecast for October.
Note: Round your answer to \(\mathbf{2}\) decimal places.
Answer is complete and correct.
b. Using single exponential smoothing with \(\alpha=0.30\) and a September forecast \(=55\), calculate a forecast for October.
Note: Round your answer to \(\mathbf{2}\) decimal places.
Answer is complete and correct.
c. Using simple linear regression, calculate the trend line for the historical data. Say the \( X \) axis is \(\mathrm{April}=1,\mathrm{May}=2\), and so on, while the \( Y \) axis is demand.
Note: Round your Intercept value to the nearest whole number and slope value to \(\mathbf{2}\) decimal places.
Answer is complete but not entirely correct.
d. Calculate a forecast for October using your regression formula.
Note: Round your answer to \(\mathbf{2}\) decimal places.
Answer is complete but not entirely correct.
 Problem 3-13(Algo) Historical demand for a product is as follows: a.

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!