Question: 4 Question 3 A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 3825 2 3800 3 3780

4 Question 3 A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 3825 2 3800 3 3780 3880 5 3850 6 3820 7 3876 8 3825 9 3780 10 3780 11 3770 12 3800 13 3750 14 3757 15 3750 He thinks that two methods could be used to forecast future sales: linear regression and weighted moving average. (1 mark) 3.1 Using Excel, please run linear regression on this data. Based on the results you obtain; do you think that linear regression is appropriate in this case? Why? 3.2 For the weighted moving average, the analyst wants to calculate a four-period weighted moving average with weights 0.4, 0.3, 0.2 and 0.1. Please apply the weighted moving average methods to calculate the sales forecast in weeks 5-15

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!

Question 3 A supply chain analyst is analyzing past sales data. He obtained the following numbers: Week Demand 1 3825 2 3800 3 3780 4 3880 5 3850 6 3820 7 3876 8 3825 9 3780 10 3780 11 3770 12 3800...

ASSIGNMENT 1 (Demand forecasting on Excel) Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month 1 2 3 4 5 6 7...

Question 2 Use the data provided in Question 1, the Analyst would like to establish a Linear regression model for the demand, Using Excel, please run linear regression on this data (1 mark) 2.1 2.2...

Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month 1 2 3 4 5 6 7 8 9 10 11 12 13 Demand (000s) 3600 3400 3450...

Hello This is regarding BUS5440. I need help with the following discussion questions and I need the answer in next 2 hrs as I have a deadline today, *********************************** Share your...

Key issue/problem statement - what is the key problem/s or issue/s addressed in the case? What is the main decision that manager/s need to make? Maximum = 2 issues. Options with pros and cons...

Please help solve problem 21-37 in chapter 21. What is the working capital of , 12/31/x1 ? and please help solve problem 21-38 ? thank you 21 Chapter Twenty-One Analyzing Financial Statements After...

Make an essay in brief on the below case study, Mention the issue face and the Recommendation on the below case study HALF CENTURY OF SUPPLY CHAIN MANAGEMENT AT WAL- MART 1 INTRODUCTION James...

Analyze and executive brief for below Case Study. The brief should demonstrate clear understanding of the issues and provide practical recommendations where appropriate. There is a specific format...

There is no one best communication medium on which managers should rely. In choosing a communication medium for any message, managers need to consider three factors. The first and most important is...

Prepare journal entries for April, 2014 to record the following transactions for Holden Corp. Assume a perpetual inventory system. Enter the transaction letter as the description when entering the...

The Golfing Emporium had a set of 1 0 1 0 golf clubs that were marked on sale for $ 7 3 0 $ 7 3 0 . This was a discount of 2 0 % 2 0 % off the original selling price. If the golf clubs cost The...

What is an example of constructive feedback? provide reference