Patent AU-2015202738-B2 (AU)
Title: Terminal performance analytical computer system
Inventor: CHU KING FUNG
IPC: G06Q50/28
Filed: 2015-05-20
Granted: 2016-09-22
Abstract: A data processing system for analyzing services, resource and activities data for container port terminal performance, including a computing device including a processor and a memory in which is stored instructions, a data integration interface within the computing device that receives services, activities, and resources cost data associated with customers of the container port terminal from a plurality of data collection source systems, positioning sensors on individual containers that capture positioning data and timing of the positioning data for the individual containers, wherein the positioning sensors are in wireless communication with at least one of the plurality of data collection source systems which transmit the positioning data and the timing data to the computing device, wherein the activities and resources cost data include the positioning data and the timing data for the individual containers received from the positioning sensors, a data integration component coupled with the data integration interface to transform, with the processor, the received data, a customization interface within the computing device that provides a data box for selecting vessel operations activities, barge operations activities and cross-terminal activities for each of a plurality of import services, export services and transshipment services offered by the container port terminal to the customers, provides a data box for selecting shipside resources and landside resources consumable by the container port terminal for each of the selected vessel operations activities, the barge operations activities, and the cross-terminal activities, receives a selection of vessel operations activities, barge operations activities and cross-terminal activities for each of the import services, export services and transshipment services offered by the container port terminal to the customers, receives a selection of shipside resources and landside resources consumable by the container port terminal for each of the selected vessel operations activities, barge operations activities and cross-terminal activities, in response to the selection of vessel operations activities, barge operations activities and cross-terminal activities and the selection of shipside resources and landside resources consumable by the container port terminal, generates a plurality of multi-dimensional relationships associating each of the import services, export services and transshipment services offered by the container port terminal to the customers with the selected vessel operations activities, barge operations activities and cross-terminal activities, and a plurality of multi-dimensional relationships associating each of the selected vessel operations activities, barge operations activities and cross-terminal activities with the selected shipside resources and landside resources consumable by the container port terminal, and stores the multi dimensional relationships in a multi-dimensional database, an activity-based cost allocation engine, executable by the processor executing the instructions to receive the transformed data and allocate individual cost items into a terminal performance database by allocating services cost data to the import services, export services and transshipment services offered by the container port terminal to the customers, allocating activities cost data to the selected vessel operations activities, barge operations activities and cross-terminal activities performable by the container port terminal to provide the import services, export services or transshipment services, and allocating resources cost data the selected shipside resources and landside resources consumable by the container port terminal to perform the selected vessel operations activities, the barge operations activities, or the cross-terminal activities, allocation of the services cost data, the activities cost data, and the resources cost data defines a multidimensional relationship between cost data for a service ordered by an individual customer, the ordered service including a plurality of individual container movements and being ordered from the selected import services, export services and transshipment services, cost data for activities performed by the container port terminal to complete an individual container movement of the plurality of individual container movements, and cost data for resources consumed by the container port terminal to complete the activities performed, wherein the allocated individual cost items include direct costs and indirect costs, and wherein the cost allocation engine allocates an indirect resource cost as a fractional average to one or more activities relevant to the resources consumed, a calculation engine, executable by the processor executing the instructions to map cost data of the allocated individual cost items from the terminal performance database into the multidimensional database by calculating a total direct cost for the ordered service by adding direct costs for the selected vessel operations activities, barge operations activities and cross-terminal activities associated with the ordered service, and direct costs for the selected shipside resources and landside resources associated with the selected vessel operations activities, barge operations activities and cross-terminal activities associated with the ordered service, and calculating a total indirect cost for the ordered service from indirect resource costs for the selected vessel operations activities, barge operations activities and cross-terminal activities relevant to the selected shipside resources and landside resources, and a reporting component within the computing device to generate reports in a user interface illustrating costs associated with individual customers and one or more dimensions selected from the group consisting of individual customers, a specific service selected from the import services, export services and transshipment services offered by the container port terminal to the customers, a specific activity selected from the vessel operations activities, barge operations activities and cross-terminal activities performable by the container port terminal, and a specific resource selected from the shipside resources and landside resources consumable by the container port terminal over specified periods of time. Front-end Tools 1 4 142 144 112 KPT e Reports rOete i OLAP Front 136 138 End Tool Tools 133 Analys Engine Back-end 108 OLAP vTPHAS CAicatOi 128 C n 29 Onilne nteCost 12 S Engin 124 r24 124 24 nie ~Q2 ro - A Batch inter'face Source Data Extraction 18 and Transformation