Abstract
A well-functioning system of transport delivery of various goods is very important for the economy of the state and business entities. When delivering goods by the pendulum method, the mileage utilization factor does not exceed 50%, since return mileage without cargo increases transportation costs. The organization of cargo delivery in modern conditions should ensure not only the receipt of calculated data on routes, but also the possibility of optimizing the performance of vehicles on the route using digital technologies. This article discusses the implementation of digital cargo delivery planning based on EXCEL spreadsheets and software blocks developed at the Department of Transport Engineering and Logistics Systems based on the built-in VBA editor. The criteria for optimizing the plan are the load capacity of the car, the use of a trailer, the time spent in the outfit, the variability of the means used for loading and unloading and other indicators. The VBA program blocks ensure that suppliers are assigned to consumers with minimal transport work (the "Solution Search" function), automatically determine ring and pendulum routes; indicators for each route are calculated and optimized.