Question: help pleasee Problem 3-13 (Algo) Historical demand for a product is as follows: April May June July August September DEMAND 75 60 90 75 95
help pleasee
Problem 3-13 (Algo) Historical demand for a product is as follows: April May June July August September DEMAND 75 60 90 75 95 88 Ook rences a. Using a simple four-month moving average, calculate a forecast for October (Round your answer to 2 decimal places.) Forecast for October 87.00 b. Using single exponential smoothing with a=0.10 and a September forecast = 80, calculate a forecast for October (Round your answer to 2 decimal places.) Forecast for October 80.80 b. Using single exponential smoothing with 0.10 and a September forecast 80, calculate a forecast for October (Round your answer to 2 decimal places.) Forecast for Odobe 30.00 Book 0 c. Using simple linear regression, calculate the trendline for the historical data. Say the X axis is April May 2, and so on, while the Yakiss demand (Round your intercept value to the nearest whole number and slope value to 2 decimal places.) Y d. Calculate a forecast for October using your regression formula (Round your answer to 2 decimal places.) Forecast for Odober

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
