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 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 NovStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
