Question: Forecasting using Exponential Smoothing: The forecasted usage of steel consumption for Tesla Motors was 1 , 5 0 0 tons in January, the company had

Forecasting using Exponential Smoothing: The forecasted usage of steel consumption for Tesla Motors was 1,500 tons in January, the company had a slight downturn in orders for their all-electric cars and the actual usage was 1,100 tons. The Sales manager wants you to calculte the Forecast for February using a smoothing coefficient (\alpha ) of .7,.8,.9 and 1.0 Use the table below to calculate your forecast for February. Create the following formula in row 5 for each of the four different \alpha levels (.7,.8,.9, & 1.0).(possible points -15)

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!