基于EXCEL解决配载业务的最优经济组合

The Optimal Economic Combination of Solving Stowage Business Based on Excel

近年来,随着我国经济的快速发展和贸易经济的不断繁荣,货物运输的规模也在不断地扩大。据统计,2019年我国货物运输总量达534.1亿吨,货物周转量达19.93万亿吨公里,其中公路货物运量占总运输量的77.91%,在主流的运输方式中居首要地位。探究行业的经营后发现,公路运输的业务方式是多种多样的,不同业务模式的经营特点是不同的。文中从公路运输方式入手,结合配载运输的经营,探讨运用EXCEL解决配载运输在货物搭配中实现最优经济组合,以及经营效益最大化的途径。

In recent years,with the rapid development of China’s economy and the continuous prosperity of trade economy,the scale of cargo transportation is also expanding. According to statistics,in 2019,China’s total cargo transportation reached 53.41 billion tons kilometers,and the cargo turnover reached 19. 93 trillion ton-kilometers. The highway freight volume accounts for77. 91% of the total transportation volume,which occupies the primary position in the mainstream transportation modes. After exploring the operation of the industry,it is found that the business modes of highway transportation are diverse,and the characteristics of different business modes are different. Starting from the mode of highway transportation and combined with the operation of stowage transportation,this paper discusses the way to use Excel to solve the problem of stowage transportation in cargo matching for realizing the optimal economic combination and the maximum operation benefit.