Question: Question 3. a) Using nave method, what will be the forecasted sale for the month of June? b) Using 3-months moving average (n=3), what will

Question 3. a) Using nave method, what will be

Question 3. a) Using nave method, what will be the forecasted sale for the month of June? b) Using 3-months moving average (n=3), what will be the forecasted sale for the month of June? Forecast Month January February March April May June Sales 125,000 93,000 80,000 75,000 84.000 June sales? Question 4. Using Single or Simple exponential smoothing (SES) technique, what will be the forecasted sale for the month of June? Please see the example in the excel sheet. F., = F + a(A -F) 1 t F:+1 = Forecast value for time t+1 = Actual value at time t = Smoothing constant ac Considering the smoothing constant a = 0.5, Initial forecast = 124,000 Forecast Month January February March April May June Actual Sales USD 125.000 93,000 80,000 75,000 84,000 June sales

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!