Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Period Actual Sales Maive Method (a) MAD-Malve 3 Period moving MAD -3 Period Exponentia averagi moving average smotthing Methed Alpha 1162 (b) =03 102

image text in transcribed

Period Actual Sales Maive Method (a) MAD-Malve 3 Period moving MAD -3 Period Exponentia averagi moving average smotthing Methed Alpha 1162 (b) =03 102 MAD-EXPODental/ Smoothing methed Alpha=0.3 (c) 26 96 100 390 10060 90 4 # 99.22 110 90 29 20 96,00 14.60 99-22 13.55 515 96.45 115 110 6105 5 98.67 16-33 10052 14.48 105 115 7 10 123 105 18 22 105.00 0.00 104.86 0.14 110.00 13:00 104-90 18.10 Average MAD 13.250 10.83 1154 Formula Used. Maine Approach = Actual Sules of the previous periul or considered as a forecast of the current period. 3 Perica Moving Averest = Sum of previous 3 Period Sales 13. Exponential Smoothing Fericast FCE+) =A+a+ (1-a) ft F(z+1)=fercast for perica (t+1) At = ketual demand for the perica t a = Exponential Constant = 0.3 It = forecast for the period & = Intial Forecast = low MAD = Ditterance of Actuall and forecast. Average MAD = Average of Sum of MAD. (9) MAS using the nain approuch =13.25 B) MAD Using 3 period moving average =10.83

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

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

Operations Management Creating Value Along the Supply Chain

Authors: Roberta S. Russell, Bernard W. Taylor

7th Edition

9781118139523, 0470525908, 1118139526, 978-0470525906

More Books

Students also viewed these General Management questions