Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CLO1- Demonstrate advanced knowledge of operations and supply chain management and its contribution to organization's performance. Chapter 4: Forecasting [Page 137 of test book] Problem:

CLO1- Demonstrate advanced knowledge of operations and supply chain management and its contribution to organization's performance.
Chapter 4: Forecasting [Page 137 of test book]
Problem: Determining Forecast based on methods given below
('000)
Month Actual Sales
Jan 55
Feb 60
Mar 70
Apr 68
May 78
June 85
July 80
Aug 90
Sept 86
Oct 95
Nov 100
Dec 98

Required: 1. Calculate the forecast using 4-months moving average (MA) 2. Calculate the forecast using 4-month weighted moving average (WMA) 3. Calculate the mean absolute diviation based on MA and WMA. Which one give you closest forecast using MAD. 4. Show the graph compare actual and forecast based on MA and WMA. 5. Calculate the Exponentially Smoothed Forecast for each month. Assume an an initial forecast of 50,000 units in Jan. Use smoothing constand a = 0.2, a = 0.5, and a = 0.80. 6. Which smoothing constant give you closest forecast. Using MAD and graph. 7. Calculate the trend projection

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

Principles Of Risk Management And Insurance

Authors: George E. Rejda

10th Edition

0321414934, 9780321414939

More Books

Students also viewed these General Management questions