An intelligence system for a car-carrier loading optimization

The route planning and vehicle positioning process for car-carriers in the finished vehicle logistics business is currently a manual and time-consuming task, resulting in suboptimal solutions due to variations in individual planner logic. This research aims to develop and validate a standardized mathematical model for car-carrier route planning to obtain optimal solutions. By addressing the vehicle routing problem specifically for car-carriers, this study aims to derive a tailored mathematical model.Different methods exist for solving vehicle routing problems, including exact and heuristic methods. Due to the exponential increase in computational complexity with the number of cities or nodes, exact methods are time and resources intensive. Hence, a heuristic approach is adopted if it satisfies the problem's constraints and conditions.To ensure a user-friendly experience and leverage existing expertise with MS Excel, an intelligence system will be developed using Visual Basic for Applications (VBA). VBA, a programming language designed for automation within the Microsoft Office suite, enables seamless integration into Excel, facilitating a familiar and intuitive interface for users.The accuracy of the algorithm will be evaluated by comparing the results generated by the intelligent system with historical data manually planned by human planners. This assessment will quantify planning utilization based on the number of trailers used, enabling an evaluation of the algorithm's performance.By automating and optimizing the route planning process, this research aims to reduce the reliance on manual planning and enhance overall efficiency and resource utilization in the finished vehicle logistics business.成品汽车物流业务中，商品车运输车的路径规划与车辆调度流程目前仍以人工方式开展，不仅耗时耗力，且由于不同规划人员的决策逻辑存在差异，易得出次优解。本研究旨在开发并验证一套适用于商品车运输车路径规划的标准化数学模型，以获取最优解；同时针对商品车运输车场景下的车辆路径问题，推导定制化数学模型。车辆路径问题的求解方法可分为精确算法与启发式算法两类。随着城市或节点数量增加，计算复杂度呈指数级增长，精确算法往往耗时且资源消耗巨大。因此，若启发式方法能够满足问题的约束与条件，则可作为优选方案。为保障用户体验友好性，并充分利用现有人员对微软Excel（MS Excel）的操作经验，本研究将采用Visual Basic 应用程序（Visual Basic for Applications, VBA）开发智能系统。VBA是专为微软Office套件自动化设计的编程语言，可与Excel实现无缝集成，为用户提供熟悉且直观的操作界面。本研究将通过对比智能系统生成的规划结果与人工规划人员的历史规划数据，评估算法的准确性；并基于所用拖车数量量化规划资源利用率，以此评价算法的综合性能。本研究旨在通过自动化与优化路径规划流程，降低对人工规划的依赖，提升成品汽车物流业务的整体运营效率与资源利用率。