Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Subject: Supply Chain Management Answer the following questions base on the actual sales data, listed below. Keep 2 decimal point for all calculation step. Show

Subject: Supply Chain Management

Answer the following questions base on the actual sales data, listed below. Keep 2 decimal point for all calculation step. Show sufficient calculation step for partial credit.\

Month Sales data
Apr 500
May 480
June 420
July 550
Aug 520
Sept 450
Oct 490
Nov 560

(a) Determine the forecast error using MAPE if, the forecasting method is Weighted Moving Average (N=3) where weights are 9, 2,10. (8 marks)

(b) Determine the forecast error using MAD if, the forecasting method is Linear Regression, where slope = -5 and intercept = 510 (5 marks)

(c) Explain why your solution from part (a) and part (b) cannot be utilized to determine which forecasting model is deem more accurate. Discuss the necessary modification to enable accuracy comparison between forecasting model in part (a) and in part (b) (7 marks)

(d) Based on your conclusion in part (c), determine which forecasting model, part (a) or part (b), is deem more accurate. Justify your conclusion. (5 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Introduction to Management Science

Authors: Bernard W. Taylor

11th Edition

132751917, 978-0132751919

More Books

Students also viewed these General Management questions