Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The monthly sales levels (measures in thousands of Saudi riyals) for a leading Saudi company are shown in the following table. Plot the monthly

The monthly sales levels (measures in thousands of Saudi riyals) for a leading Saudi company are shown in the 

The monthly sales levels (measures in thousands of Saudi riyals) for a leading Saudi company are shown in the following table. Plot the monthly sales data using minitab and the demonstrate the following: a) Smooth the data and forecast Jan 2019 sales level using simple exponential smoothing with a smoothing constant of 0.5 and initial smoothed value of 16.8. Plot and show the fits, residuals and forecast in a table. b) Smooth the data and forecast Jan 2019 sales level using Holt's linear smoothing with all smoothing constants equal to 0.5 and initial smoothed value of 16.8. Plot and show the fits, residuals and forecast in a table. c) Smooth the data and forecast Jan 2019 sales level using Winters multiplicative smoothing with all smoothing constants equal to 0.5 and initial smoothed value of 16.8. Plot and show the fits, residuals and forecast in a table. d) Compare and evaluate the previous exponential smoothing methods in parts (a), (b) and (c) using MAPE, MAD and MSE, and explain your preferred method for these date. Show your comparison in a table. Year Month Sales Jan 16.8 Feb 12.7 Mar 26.9 Apr 61.4 May 147.8 Jun 57.9 Jul 51.3 Aug 53.5 Sep 23.0 Oct 41.3 Nor 19.3 Dec 22.7 2016 Year Month Sales Year Month Sales Jan 15.3 27.7 Feb 30.8 36.3 Mar 25.5 51.1 Apr 217.5 May Jun 2017 Jul Aug Sep Oct Nov Dec 103.1 197.6 68.6 39.9 91.3 58.7 59.6 33.4 53.7 2018 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 206.2 110.0 102.8 128.8 104.7 111.0 63.7 82.6

Step by Step Solution

3.56 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

The procedure usually employed for specifying a set of hydrocyclones used in New... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Business Statistics Concepts And Applications

Authors: Mark L. Berenson, David M. Levine, Timothy C. Krehbiel

12th Edition

132168383, 978-0132168380

Students also viewed these Accounting questions