Keywords

1 Introduction

With the rapid development of science and technology, electronic products have entered millions of households and become necessities for people’s daily work and life. The rapid replacement of electronic products often makes product output and sales volume not match in time, resulting in product backlog or Deficit affects earnings. For this reason, the electronics industry urgently needs an effective product sales forecasting method to provide scientific decision support for its production plan. Orders and sales volume are important basis for forecasting production volume. Therefore, this article will build a sales forecast model and order forecast model for electronic products, and predict the sales volume of the latest generation of products sold by sellers to customers in the next 20 weeks based on the existing sales data of a certain brand of electronic products. Order volume for the next 20 weeks in different sales regions.

2 BP Neural Network Algorithm

Among the neural networks, the most representative and widely used is the BP (Bake-Propagation) neural network (multi-layer feed forward error) proposed by Rumel Hart and McClelland of the University of California in 1985. Back Propagation Neural Network). This model is a supervised learning model with a strong self-organizing and adaptive ability. It can grasp the essential characteristics of the research system after learning and training on a representative sample, and has a simple structure and strong operability. Can simulate arbitrary non-linear input-output relationships. The specific implementation steps of the BP neural network algorithm are as follows:

The first step is to select the structure of the BP neural network based on the data signs. The BP neural network model used in this article The number of network layers is 2 and the number of hidden layer neurons is 10. The hidden layer and output layer neuron functions are selected as tansig function and purelin function, the network training method uses gradient descent method, gradient descent method with momentum and adaptive should lr the gradient descent method; The second step is to normalize the input data and output data; The third step is to construct a neural network using the function newff(); In the fourth step, before training the neural network, first set related parameters, such as the maximum number of training times, the accuracy required for training, and the learning rate; The fifth step is to train the BP neural network; The sixth step is to repeat the training until the requirements are met; The seventh step is to save the trained neural network and use the trained neural network to make predictions; In the eighth step, the predicted value is compared with the actual output value to analyze the stability of the model.

3 Sales Forecast

This section uses MATLAB software to fit the original data using the BP neural network algorithm, and finally completes the forecast of the sales volume of the latest series of each product. The specific program code is as follows:

figure a

Enter the original data into the above code, and obtain the fitting curve of the sales volume of the a-3 generation products (see Fig. 1).

Fig. 1.
figure 1

Actual value and forecast value of sales of a-3 generation product sellers to customers.

After error analysis, the model is suitable for forecasting the sales volume of the product, and the original program is further improved to predict the sales volume of the a-3 generation products to the customers in the next 20 weeks(see Table 1).

Table 1. Sales value of a-3 generation product sellers to customers next 20 weeks.

The same processing method can predict the sales volume of the b-2 and c-1 products from the seller to the customer in the next 20 weeks. The fitting graphs of the actual and predicted values (see Fig. 2 and 3). Sales forecast values (see Table 2 and 3).

Fig. 2.
figure 2

The actual and predicted sales volume of the b2 generation product sellers to customers.

Fig. 3.
figure 3

Actual and predicted sales volume of c1 generation product sellers to customers.

Table 2. The sales value of the b-2 generation product sellers to customers next 20 weeks.
Table 3. Sales volume of c1 generation products sold to customers next 20 weeks.

Through the above analysis, it is found that the BP neural network algorithm has a good fitting degree, the relative error between the predicted value and the actual value is small, the prediction result is more accurate, and it can be used for short-term and medium-term prediction.

4 Order Volume Forecast

This paper first uses EXCEL software to screen the d-3, e-2, and f-generation products by sales area and order type. According to the analysis of the characteristics of the filtered data, it is found that the prediction of the order volume can still use the BP neural network algorithm. The difference between the algorithm in this part and the second part lies in the selection of parameters and hidden layer neurons. The accuracy and training times of this part are higher than the second part. Another 30 hidden layer neurons are selected, which achieves a better simulation results. The effect. The results of fitting and prediction using MATLAB software are as follows: First of all, we carried out the order volume of the a-3, b-2, c-1 three-generation products that are not divided into sales areas in the next twenty weeks. Manufacturers received orders (type B + C) and sellers placed orders (type A + B). The specific prediction results are as follows (Fig. 4 and Table 4):

Fig. 4.
figure 4

A-3 generation product sellers’ order quantity (A + B) actual data and forecast data.

Table 4. The forecast value of orders placed by a-3 generation product sellers next 20 weeks.

The forecast results show that in the next 20 weeks, the order volume of a-3 generation product sellers will first increase significantly, and will fall after reaching a certain number (Fig. 5 and Table 5).

Fig. 5.
figure 5

Order data received by a-3 generation product manufacturers (B + C) actual data and forecast data.

Table 5. The forecast value of orders received by a-3 generation product manufacturers next 20 weeks

The forecast results show that the order volume of a-3 generation product manufacturers will have two peak periods in the next 20 weeks, and manufacturers can appropriately adjust their production strategies based on the forecast results (Fig. 6).

Fig. 6.
figure 6

B-2 generation product sellers’ orders (A + B) actual data and forecast data.

It can be seen from the above figure that the fitting effect of the BP neural network model is better. After further error checking, it was found that the error was small, so the program was further improved for prediction. The predicted value.(see Table 6).

Table 6. B-2 generation product sellers’ order volume forecast values for the next 20 weeks

The forecast results show that the order quantity of b-2 generation product sellers will pick up in the next 20 weeks, but the range is not large, and it will decline rapidly after the 17th week (Table 7 and Fig. 7).

Table 7. The forecast value of orders received by b-2 generation product manufacturers next 20 weeks.
Fig. 7.
figure 7

The actual and forecast data of orders received by b-2 generation product manufacturers (type B + C).

The fitting and forecasting results show that the number of the two types of orders in the previous period of the product basically match, and the trend in the next 20 weeks is similar, but the number is different (Fig. 8 and Table 8).

Fig. 8.
figure 8

The actual and forecast data of orders received by c-1 generation product manufacturers (type B + C).

Table 8. The forecast value of orders for c-1 generation product sellers in the next 20 weeks.

The forecast results show that the order volume of c-1 generation product sellers will fluctuate greatly in the next 20 weeks (Fig. 9 and Table 9).

Fig. 9.
figure 9

The actual and forecast data of orders received by c-1 generation product manufacturers (type B + C).

Table 9. The forecast value of orders received by c-1 generation product manufacturers next 20 weeks.

The forecast results show that the orders received by c-1 generation product manufacturers in the next 20 weeks will remain high.

Secondly, according to the filtered data, predict the order volume of d-3, e-2, f products in different sales regions in the next 1 to 20 weeks. The specific fitting chart is as follows. The forecast results of the order volume in the next 20 weeks are not listed here. Now, readers can make their own predictions based on the program codes listed above, and the operation is simple and easy (Fig. 10).

Fig. 10.
figure 10

(Left) Actual and predicted order quantities of sellers of d-3 products in the sales area a (Right) Actual and predicted orders for d-3 products in the sales area of the manufacturer.

The fitting and prediction results show that the two orders of d-3 products in the a sales region will enter a stable recession in the next 20 weeks, which indicates that these products will soon exit the market (Fig. 11).

Fig. 11.
figure 11

(Left) Actual and predicted orders for d-3 products in c sales area; (Right) Actual value and forecast value of order quantity of sellers of d-3 products in b sales area.

The fitting and forecasting results show that the orders of manufacturers of d-3 products in the c sales region will gradually rise in the next 20 weeks. The orders of sellers of d-3 products in the b sales region will be smaller and should be increased in Product promotion in the region. The forecast results of the order quantity of the e-2 products in the sales region of a and the order quantity of the manufacturer show that the former has a certain degree of rebound after entering a long trough period. The main reason for the trough period is In the previous stage, the sellers in this sales area placed large orders; the latter placed large fluctuations in order quantities, which was mainly affected by changes in the order volume of C products (Figs. 12 and 13).

Fig. 12.
figure 12

(Left) Actual and predicted order quantities of sellers of e-2 products in sales area a (Right) Actual and predicted order quantities of manufacturers of e-2 products in a sales area.

Fig. 13.
figure 13

(Left) Actual and predicted order quantities of sellers of product f in sales area a;(Right) Actual and predicted order quantities of producers of product f in sales region a.

The forecast results show that the order quantity of product f in sales area a has soared in a short period of time, but it has declined rapidly in the later period and continues to rise, indicating that the demand for product f in area a in the future is not high (Fig. 14).

Fig. 14.
figure 14

(Left) Actual and predicted order quantities for manufacturers of product f in sales area c; (Right) Actual and predicted order quantities of sellers of product f in c sales area.

The fitting and forecasting results show that the two orders of f products in the c sales area have similar trends, indicating that sales of f products in this area are relatively stable.