Question: can I have an answer to this please but without using excel? i need to see the steps and calculations and how they are done

can I have an answer to this please but without
can I have an answer to this please but without using excel? i need to see the steps and calculations and how they are done
1. Following table shows the monthly sales of cars at a dealership: Month Error Error Number cars Sold of Forecast using Naive 3 Forecast using period moving average 79 79 86 93 101 107 102 8 Answer the following questions based on the data given above. Show your calculations. a. What is the expected sales for the 8th month based on 3 period moving average? (15 Points) ANS: b. What is the expected sales for the 8th month based on naive approach? (10 Points) ANS: c. Which of the above two forecasting method is better based on MAD? (25 Points) ANS

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!