华东国际联运港集装箱台账统计数据

集装箱台账用于内部运营管理，通过记录月份、委托编号、班列信息等信息，追踪和管理货物的运输过程，实现费用的精细化管理和货物运输收益的有效分析预测，从而帮助企业提高运输效率和客户服务水平。1、数据采集：利用智慧联运管理平台，对“集装箱台账数据”进行实时采集
2、数据处理：以箱号作为唯一标识，通过筛选数据库中的记录，提取出每个集装箱的班列类型、去回程、委托类型、箱属性、货物类型、应付总费用、应收总费用、预计收益、发站、口岸、目的站、发车时间、调度日等信息；
3、数据加工：计算每个集装箱的预计收益 ，预计收益CNY=应收总费用CNY-应付总费用CNY；计算每笔委托的收益率（（应收总费用CNY - 应付总费用CNY）/ 应付总费用CNY）；计算预计收益占应收总费用的百分比（预计收益CNY / 应收总费用CNY）
4、数据应用：了解运输业务的整体状况、市场分布、收益情况以及不同因素对业务的影响，通过这些分析，可以为运输业务的优化、市场策略制定、资源分配等提供数据支持。

The container ledger is used for internal operational management. It tracks and oversees the entire cargo transportation process by recording information such as month, entrustment number, block train details, etc., enabling refined cost management and effective analysis and forecasting of cargo transportation revenue, thereby helping enterprises enhance transportation efficiency and customer service standards.
1. Data Collection: Real-time collection of "container ledger data" is conducted through the intelligent intermodal transportation management platform.
2. Data Preprocessing: Taking the container number as the unique identifier, filter the records in the database to extract information of each container including block train type, outbound/return trip, entrustment type, container attribute, cargo type, total payable cost, total receivable cost, estimated revenue, departure station, port of entry, destination station, departure time, scheduling date, etc.
3. Data Calculation & Enrichment: Calculate the estimated revenue for each container, with the formula: Estimated Revenue (CNY) = Total Receivable Cost (CNY) - Total Payable Cost (CNY); Calculate the profit margin of each entrustment using the formula: (Total Receivable Cost (CNY) - Total Payable Cost (CNY)) / Total Payable Cost (CNY); Calculate the percentage of estimated revenue in total receivable cost using the formula: Estimated Revenue (CNY) / Total Receivable Cost (CNY).
4. Data Application: Gain insights into the overall operational status, market distribution, revenue performance and the impact of different factors on the transportation business. Such analysis can provide data support for transportation business optimization, market strategy formulation, resource allocation and other related work.

搜集汇总

数据集介绍

特点

该数据集记录了华东国际联运港集装箱的运输台账信息，包含985条每日更新的数据，涵盖班列类型、费用、收益等关键字段，用于内部运营管理和收益分析。