Question: 3.3 only, don't us ms excel QUESTION 3 A restaurant has operated in a popular golf resort in the Eastern Cape. The restaurant is busiest

3.3 only, don't us ms excel QUESTION 3 A

3.3 only, don't us ms excel

QUESTION 3 A restaurant has operated in a popular golf resort in the Eastern Cape. The restaurant is busiest in the holiday months when tourists flock to the area. The following monthly sales data over the past two (2) years is in the table below. Sales data for each month is in thousands of Rands (R'000) Year Months Sales R'000 2020 Aug 210 Sep 278 Nov 322 Dec 450 233 Oct 2021 Jan 438 Feb 434 Mar 338 332 Apr May 254 Jun 264 Jul 231 224 243 Aug Sep Oct Nov 289 With reference to the above data, forecast the monthly sales for November (2021) using each of the following forecasting techniques: (Work to 1 decimal place for all forecasting calculations) 3.1 4-Period moving average (1) 3.2 Weighted moving average (Oct = 0.32, Sep = 0.25, Aug = 0.20, Jul = 0.15, Jun = 0.08) (1) 3.3 Prepare a forecast for Aug (2021) to Nov (2021), using Exponential Smoothing (a = 0.25). Use a 5-period moving average in order to calculate a forecast for Jul (2021). (5) Year Qtr. Calls logged Forecast 2021 July 231 Exponential Smoothing 2021 Aug 224 2021 Sep 243 2021 Oct 289 2021 Nov

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!