Question: Note: You can use help from software such as MS Excel to solve the forecasting method and MS project Management. The knowledge is refered to

Note: You can use help from software such as MS Excel to solve the forecasting method and MS project Management.

The knowledge is refered to Supply Chain Management

Walmart Sales Data Time Period all 1 2 3 4 Year Quarter 2016 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2017 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2019 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2021 Quarter 1 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Sales Data (S) 25409 28366 28777 35386 29819 33521 33509 40785 34717 38170 40432 51394 42985 46112 45676 56556 48565 53269 51754 64211 091919 A. Plot the time chart. Is there any sign of trend, seasonality, irregularity in the time chart? (1 Mark) B. Conduct a 3 Period Moving Average Forecasting Method showing all forecast values up to 2021 Quarter1. (2 Marks) C. Conduct a 3 Period Weighted Moving Average Forecasting Method showing all forecast values up to 2021 Quarter 1. Weights are 0.45, 0.325, and 0.225. (2 Marks) D. Conduct forecast using exponential smoothing with alpha value 0.25 and forecast all values up to 2021 Quarter 1. Start your forecast from 2nd time period (i.e., Quarter 2, year 2016) assuming the first forecast method is a nave method. (2 Marks) E. Calculate MAPE and MSE for each method above. Based on MAPE, which method is a good model? Based on MSE, which forecast method is a good model? (4 Marks)

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!

15 Chapter A4148 23218 6/9/01 7:17 AM Page 417 15Controlling Objectives After reading this chapter, you will be able to: 1. 2. 3. 4. Understand the importance of good project control to keeping...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

With the given information, if the case involves a company's or manager's actions, evaluate what the company or manager did or did not correctly in handling the issue affecting it. How should actions...

Questions for Discussion 1. What are the major issues in this case? What does Walmart's experience tell you about the business and society relationship? 2. Assess Walmart's corporate social...

1. What does each functional area focus in the article "All Fired up"? 2. What is the % perfect order for this restaurant? 3. How can you improve the data gathering for the S&OP process? 4. What is...

A & R Case Study Background A & R is an Australia-based travel agency that specializes in the rental of high-quality self-catering accommodation in Australia. For the summer months, it offers a wide...

Explain in words how Gay-Lussacs law follows from kinetic theory.

Write a paper in which you: assess how Ericsson benefited from Amazon web services (AWS) in terms of cost reduction, automated software updates, remote access, and on-demand availability. Evaluate...

15. A cosmetics manufacturer tested a new cleansing cream on forty rabbits. The rabbits were virtually the same genetically and were the same age. Twenty of the rabbits were randomly placed in the...

What is an example of constructive feedback? provide reference