Answered step by step
Verified Expert Solution
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 MAD-EXPODental/
Period Actual Sales Maive Method (a) MAD-Malve 3 Period moving MAD -3 Period Exponentia averagi moving average smotthing Methed Alpha 1162 (b) =03 MAD-EXPODental/ Smoothing methed Alpha=0.3 (c) 102 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started