Simple Moving Average for a Product Term Paper Example | Topics and Well Written Essays - 250 words

Simple Moving Average for a Product - Term Paper Example The strategy of the product is mainly based on the product name, store, product store id, sales, promotion, date, three weekly and corresponding four weekly. Moreover, selection of product is based on the long time duration. The forecasting accuracy of the technique relies on the valuable information of the product classes. Step 1 entails observing the 3 and 4 weekly sales volume of the products and make the decision on whether to subject the pattern to the pattern of seasonal alteration or selected necessary historical data2. Step 2: smooth the sales trend with a moving average by 3 weeks and taking the average and 4 weeks. Moreover, the moving average is performed to get the precise centered moving average of the week 3 and 4. Step 3 entails dividing the sales by the CMA in order to attain the ratio that reflects the seasonal influence factor. For instance, the annual ratios of 8a product for 3 weeks are 7.66 and 4 week is 6.0. Product 8b had the forecasting accuracy of 13.67 and 15.5 while that of 8c1 is 4.67 and 3.5 correspondingly. Moreover, product 8d1 had a prediction accuracy of 20.33 and 22.5 while 8e1 was 4.667 and 5.75 respectively. Â