Question: please answer part d,e,f and show how Question I: Forecasting 1. Monthly sales for consumer electronic goods at Best Buy for a 4-month period were

please answer part d,e,f and show how Question I:please answer part d,e,f and show how Question I:please answer part d,e,f and show how

Question I: Forecasting 1. Monthly sales for consumer electronic goods at Best Buy for a 4-month period were as follows: Month Feb Mar Apr May Sales (in hundreds) | 120 | 194 275 360 Forecast June Sales volume using each of the following techniques (Note: round off all values to two decimal places): a) Nave approach (the most appropriate one) b) A three-month moving average c) A weighted moving average using 0.4 for the most recent month, 0.3, 0.2 and 0.1 for the next most recent months. d) Exponential smoothing with a smoothing constant equal to 0.5 e) Linear Trend Equation f) Compare the forecast accuracy for a MAD metric using Exponential smoothing, and Linear Trend. Which among the two is a better technique for this data? A. In naive approach, the forecast for the month is equal to the actual demand of previous month. Forecast for June = 360 (Actual demand of May) B. 3 month moving average, the forecast for the month is equal to the average of previous 3 months June = (March + April + May) / 3 = (194 + 275 + 360)/ 3 = 276.333333 C. In weighted moving average, we multiply the given weight to the corresponding months June = (Feb * 0.1) +(March * 0.2) + (April * 0.3) + (May * 0.4) =(120 * 0.1) + (194 * 0.2) + (275 * 0.3) + (360 * 0.4) = 277.3

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!