Application of methods of modeling and forecasting for planning of operating results of fish processing enterprises

This article deals with the methodological aspects of planning activities of fish-processing companies depending on environmental temperature based on the example of group of companies “ArtFish”, Vologda. The method of composing the regression model, which describes daily revenue trend dependence from dynamic of daily environmental temperature as a factor defining the demand for fish and fish products is proposed. The sales revenue forecasts taking into account the impact of daily environmental temperature dynamic and the weekly cycle of fluctuation in sales revenue is received. The results of approbation of this method form the basis of its usage in real conditions during the period of digital economy. This allows us making the informed decision for defining the planning volumes of production


Introduction
The production of fish processing enterprises is an important component of human diet [1]. The world practice points to the fact that about 17 % of animal and 7 % of the total consumable protein fall to the share of fish nowadays [2]. However, these products have a definite specificity of storage; it necessitates the planning of production and sales volume [3]. Therefore, a need for search of possible methods of regulation of production volumes of a fish processing enterprise appeared.
Due to the specific peculiarities strategic planning of sectors of agro-industrial complex causes many methodical problems, especially in the conditions of market-oriented economy [4]. Close dependence on accidental natural factors strengthened by the instability of market environment determines the difficulty of production planning of an individual enterprise for the long run [5].
In the sphere of population's consumption of food products the forecasting of consumption volumes and revelation of consumption impact factors play the important role. According to the example of fresh fish processing and selling business we tried to define main factors impacting the population's consumption and sales turnover in this industry not paying attention to inflation fluctuation of prices for above-mentioned goods, trade discounts as well as to consumption increases during holidays and pre-holiday days.
Having the statistic data on daily revenue from company's fish products sales in this field of trading sector we performed the analysis of the dynamic of the revenue indicator during statistically long period of time, starting from July 2016 till June 2019.
According to empirical observations, it was found that during the days with the higher daily average environmental temperature consumer demand for production of fish processing enterprises decreased. This is quite accountably because in the specified weather conditions human heat elimination decreases [6] and incased consumption of products with great number of calories is not needed.
The products of the enterprises under study exactly belong to such products. Therefore, the research was aimed at the study and development of the methods which allowed planning the volumes of production and sales, taking into consideration the forecasting data of daytime environmental temperature on the relevant territory.
As a confirmation, the following hypothesis turns out to be possible in the conditions of the digital economy: While planning daily, weekly, in general, chronologically repeating procurement activities, it is necessary to take into account the weather factor, firstlytemperature regime of environment.
A possible connection between the volume of sales and environmental temperature is especially topical for remote areas, where deliveries are carried out once a week or more rarely, and also for rural areas, where in conditions of spring flood, for example, a possibility of delivery is absent (for example, Shenkursk, Archangelsk region).
It is effective to consider planning weekly, as fish and sea products are not the products of daily consumption. The natural factor can be used for more precise forecasting of income in a retail location. A plan should be realistic and should motivate an employee for a rational increase of labor intensity [7].
The purpose of the research is to define and make a model of the dependence of the volume of consumer demand for production of a fish processing enterprise from a temperature regime of an environment and develop methods of its forecasting. During the research the methods of econometric modeling on the basis of time series were used in complex. The methods included the building of trend models, models with a cyclical component and regression models.
The practical implication of the research is in the possibility to plan volumes of production and sales of the products of a fish processing enterprise depending on the natural and climatic factor.

Results
The research was carried out in several steps because it required studying the character and peculiarities of the dynamics of an index of daily revenue profoundly and preparing the data for modeling.
1. In order to verify the presence of correlation dependence between indexes under study linear correlation coefficients were calculated, thus, the approach considering seasonality (season and month) was taken as a basis of data grouping [8]. The results of the calculations did not prove the presence of statistically important and firm correlation between the indexes in spite of its presence in practice, as it was mentioned above.
2. Further, it was reviewed how the strength of correlation between the time series of the indexes under study changed in dependence to the temperature interval. Since the practical experience of control showed that the biggest elasticity of demand from temperatures could be seen only by its positive values that was why the data for the days when the environmental temperature was above 0 °C (the period from March till November of each year, the exception was 2017 with quite a warm beginning of December and 2019 with positive temperatures in February). As a result, the series of values of correlation coefficients were received and it proved that with the reduction of the range of values of positive temperatures by the transfer to the high values (summer months of the year) dependence between climatic conditions and customer demand for the production was diminishing.
Maximum correlation is achieved only when covering the entire positive temperature range. Inclusion of days when negative temperatures were observed in the processed data (for example, winter moths) leaded to the decrease of correlation coefficient, which proved the fact of the presence of significant correlation between the studied traits only for positive temperatures.
Basing on the results received for the whole data (period of 632 dates) we built the regression model reflecting correlation of sales of sea products daily revenue from the air temperature: (1) where yvolume of daily revenue from sales of fish products, rubles; хdaily air temperature. Testing of this model for statistical significance using Fisher (F=213) and Student (t1=74.9; t2=14.6) criteria showed its reliability with statistical probability not less than 0.95. The residual analysis of the model showed its occasional and normal distribution pattern and feasibility of homoscedasticity requirements. Basing on this model and given its standard error we calculated interval forecasts of daily revenue for certain temperature meanings.
Nevertheless, despite the statistical significance of the model, which is clearly defined by the wide data range used for the model, its approximating qualities were only satisfactory because the value of medium approximation error was 16,7 %, it increases its limit values of 5-7 %. The accuracy of the obtained forecast intervals was insufficient in terms of their practical significance for business planning.
The high value of this error could be explained by the presence of autocorrelation of residues (random deviations) for the given model, since the presence of trends in the time series of the studied characteristics is obvious, which can be eliminated by adding a time factor t into the regression model. However, a residual analysis revealed a lack of autocorrelation (coefficient value was 0.05).
As the main research purpose was to develop practically effective econometric model of daily revenue with the aim of further forecasting using it we decided to reduce sample size to one month period due to the fact that when making decisions based on models, it is necessary to operate with actual information and make forecasts for the nearest future.
3. The studies of economic models of dependence of revenue on temperature by selections of starting data reduced up to the period of one month pointed at their statistic insignificance and low approximate features, at that additional inclusion of time factor into the models did not allow improving statistic characteristics of the received regression equation because of the weak intensity of the trend component in the dynamics series of the dependent variable [9]. These results led to the necessity of more profound study of the structure of time series of values of daily revenue during a month. The hypothesis was formulated that in addition to the trend component, which, as the study showed, has a weak expressiveness (trend almost coincides with the line of average monthly level), the dynamics range has a cyclic component, the presence of which in the processed samples does not allow obtaining statistically significant models with a good approximation of the dependence between the.
4. The analysis of the structure of time series of daily revenue for different months based on the calculation of auto-correlation coefficients of levels depending on a lag (L) showed the presence not only the trend component having linear character but also a weakly cyclical component. As a result, a hypothesis was made that the presence of this cyclical component in the selections used for building of regression models deteriorated their approximate features and required preliminary data correction by means of its exclusion. 5. The method of moving mean was taken as a basis of estimation of the cyclical component values calculated for the period of 7 days. The data for three weeks were included into selections under study with the forecasting of the received econometric model of levels of daily revenue for the perspective forth week. As it was found out in the process of the research, belonging of a selection of a perspective week to one month did not matter, only their chronological order was important.
6. Initially additive models with the cyclical weekly component were built and tested in relation to approximate feature for different three-week periods: where Ylevel of time series of daily revenue; Тtrend componenta part of value of revenue level conditioned by the main (tendency) trend; Scyclical componenta part of value of revenue level conditioned by the cycle of its weekly fluctuations; Erandom componenta part of value of revenue level conditioned by the influence of random factors.
Afterwards, multiplicative models with the cyclical weekly component were studied with the purpose of search of regression models which were the best regarding approximation:

Y=T·S·E.
(2) 7. The approximate features of the receiving models with the cyclical component were studied based on dispersion analysis and calculation of the value of a determination coefficient. In most cases the multiplicative model gave higher determination coefficient than additive one, at the same time the value of this index for both models exceeded 0.7; that fact pointed to their quite high approximate features (table 1).
High approximating quality of the resulting models can be seen graphically (figs 1 and 2), showing the actual and aligned dynamics of daily revenue, including the trend and cyclical components.   The results of the correlation-regression analysis of the dependence between daily environmental temperature and trend of daily revenue according to the selections with periodicity of three weeks formed with the shifting for one date for the period March-April 2019 are presented in the table 2. The received data allows considering the presence of the rigid inverse correlation between the trend of daily revenue and daily average environmental temperature.
10. The forecasting of levels of daily revenue was made in the following sequence: 1) for the each date of forecasted (control) week an expected value of the level of daily average environmental temperature was calculated based on the function of the trend of this index; 2) to receive temperature values according to the regression equation built by using the data of the selection for the previous three weeks, point and interval predictions of the level of the trend component of the value of daily revenue were calculated for each date; 3) a correction of received predicted values of the trend component (Т) was carried out by multiplication of the value of the cyclical component (S) corresponding each predicted date in accordance with the model (2). Thus, the recording of variability of the random component (F) was made in the interval prediction calculated on the basis of the standard of the regression model and considered fluctuation of the factor variable, meaning the environmental temperature for the studied three weeks; 4) the error of calculated predictions was estimated by comparison of actual values of daily revenue with the received prediction interval for the control week. In all cases the actual value of revenue was found within the prediction interval that proved stability of the high approximate character of the received regression models and reliability of the results of applied methods of modelling and forecasting.

Conclusion
Taking into account difficult economic situation in the domestic market of fish and sea products in Russia fish processing enterprises should develop strategies of minimization of expenses during procurement activities to buy as much as they can sell not only during the shelf life of a product but also so as to sell it quickly without losing consumer appeal and finally, to economize operating assets of the enterprise and provide food safety. In fact, in addition to food availability it's necessary to give consideration to the aspects of its physical and economical availability for the population, also to a criterion of food products safety [10]. The suggested methods of forecasting the levels of daily revenue will allow taking decisions reasonably in order to define planned amount of production and procurement volumes for selling during the short-term prospective period. This is a timely question in the condition of rapidly changing market of consumer goods.