Question: Please write the formulas in excel and the steps Use the data provided below to answer the questions Sales (in thousands) Nave Method Moving Average

Please write the formulas in excel and the stepsPlease write the formulas in excel and the stepsPlease write the formulas in excel and the stepsPlease write the formulas in excel and the stepsPlease write the formulas in excel and the stepsPlease write the formulas in excel and the stepsPlease write the formulas in excel and the steps

Use the data provided below to answer the questions Sales (in thousands) Nave Method Moving Average Weighted Average Exponential smoothening Jan-20 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 18.6 November 21 19 December 23 19.6 Jan-21 23 ? ? What is the forecast for January 2021 using the Naive Method What is the forecast for January 2021 using 4-month moving average? Forecast for January 2021, using a 5-month weighted average using 0.1, 0.1, 0.2, 0.2, and 0.3 with the heaviest weights applied to the most recent months. Forecast for January 2021, using Exponential smoothening using a = 0.3. (round up to 1 decimal point.) With only the data and the methods mentioned in the table, which method allows you to forecast next March's sales? Explain your rationale? Be specific

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!