The application of grey forecasting model based on excel modeling and solving in logistics demand forecast

Abstract

Logistics demand forecast has an important role to resource optimization and enterprise competitiveness. Grey forecasting model has features such as low sample requirements, high forecast accuracy, it is suitable for forecasting the logistics demand. However, the complexity of the calculation process hindered its promotion and application. This paper briefly introduced the theory of gray model and the processing procedure of GM (1,1) model, then put forward to use the general software Excel to model and solve grey steps forecasting model, further made a detailed description on and methods combined with a case. The analysis of forecast results indicates that this solving method is accurate and efficient.