ANALYSIS OF DATA FOR FORECASTING SALES BY THE MOVING AVERAGE METHOD

Abstract

The paper discusses methods of data analysis for forecasting sales using the example of a BigCar retail store that sells spare parts for trucks. Based on the information on sales for the calen-dar year, using the moving average method in MS Excel, the forecast values were calculated for three periods. Analysis of the calculated data showed that the smallest relative deviation is given by a four-month period.