Question: Time Month Sales 1 Jan - 1 6 2 , 0 7 5 2 Feb - 1 6 2 , 1 5 0 3 Mar

Time Month Sales
1 Jan-162,075
2 Feb-162,150
3 Mar-162,250
4 Apr-162,250
5 May-162,250
6 Jun-162,250
to download Tesla's monthly sales data for the United States automotive market from 2016-2020.
(i) What is the predicted value of sales for January 2021 using the following methods:
a. Nave
24,675
b. Four-period moving average
[ Select ]
c. Three-period weighted moving average with weights (0.5,0.3,0.2)
[ Select ]
d. Exponential smoothing with alpha =0.3
[ Select ]
e. Exponential smoothing with alpha =0.7
[ Select ]
(ii) What is the linear trend line to predict the expected total sales?
[ Select ]
(iii) Using the trend line in part (ii), predict the expected total sales for January and February of 2021.
January:
[ Select ]
February:
[ Select ]

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!