Container Terminal Operations are increasingly versatile with many systems and processes to plan, schedule and manage operations. There are added pressures on terminal operators to augment profitability, increase throughput & exceed customer service goals.
Bringing clear visibility into the various terminal operational processes in day to day operations is the first step. The ability to take business decisions improves when you create periodic view of performance (hourly, daily, weekly, monthly and yearly).
Business Intelligence in terminal operations provides immediate visibility to critical data for terminal and port operation managers to analyze the port and terminal performance.
Excel power pivot can be used as a tool for Business Intelligence requirements. PowerPivot empowers users of all levels to access and mashup data from virtually any source . Terminal managers can create their own compelling reports for terminal operations through cubes thus avoiding them from long waits for IT or BI professional development time.
One of the biggest advantage we see here is the end user training, everyone knows excel so the adaptation of BI in the organization is very simple by extending the power of BI in excel to end users.
There are various terminal reports which can be created using excel power pivots, some are:
Terminal management needs to track equipment productivity for all equipment working in the terminal from all angles in simple visual forms. This report will give equipment utilization picture thus enabling the terminal for optimum resource planning.
For terminal operations, one of the key priorities are to service the vessel quickly, efficiently and improve the berth availability for additional vessel operations. This also keeps check on faster turnaround of the vessels and thus increase the throughput for the terminal.
Terminal manager needs to know volumes of all the services for shipping lines operating in the terminal for ascertaining the terminal throughput and total handling. Also volume figures depict the level of business performed by various shipping lines to understand the bigger one among others and take measures for positive growth.
Truck turnaround time:
The primary objective of all terminals is to reduce the truck’s waiting time via smooth gate operations i.e. to help reduce the truck idle time. Truck turnaround time should be kept minimum which will result in effective terminal operations. This report captures the time taken for complete operation of trucks inside the terminal and which is very critical for terminal productivity.
Reports which otherwise created through a Business Intelligence Solution can be effortlessly created in excel using power pivot option and thus saving the terminal from cost incurred on expensive a Business Intelligence Solution
Explore more about our Real-time terminal performance tool
Want real-time insight into terminal assets?
Explore our interactive Enterprise Asset Intelligence tool to get a feel of how you can get an information that enable you to visualize your data.
Click on the image to try the dashboard
Ports and Terminals being asset intensive industry, optimizing TCO (total cost of ownership) on capital assets are critical to manage a profitable business. The business owners needs high visibility on the past and current asset performance to make effective decisions on capital assets and drive maintenance strategies towards planned maintenance for reduction in unplanned asset downtime.
How do we bring intelligence to the Terminal Assets to support the asset owners in a Terminal to get more value.
- How to increase reliability and availability with optimized asset utilization.
- How to reduce revenue loss due to unplanned asset downtime.
- How to improve bottom line by improving maintenance strategy and optimizing cost of labor, material and services
- Helping organization in effective implementation of ” Total Productive Maintenance” (TPM) to increase Overall Equipment Efficiency(OEE).
- Detailed cost breakdown on parameters of Time,Cost type,Equipment type and Downtime type along with real time comparison on basis of Month over Month, Quarter over Quarter and Year over Year Analysis.
A real time visibility and historical comparison of data will be helpful for equipment allocation planning and accurate maintenance forecasting functionality.
Enterprise Asset Intelligence for Ports and Terminals connects day-to-day operational metrics with corporate strategy and performance. Enable the port to maximize the performance of physical assets over their entire lifecycle, ensuring asset availability and reliability while reducing operational costs and risk.
Standard graphical reports were delivered for Enterprise Asset Management gives detailed analysis of Costs KPIs, Inventory Management, Maintenance Effectiveness, Maintenance Organization, Maintenance Performance, Maintenance Productivity and Damages.
These information are then presented in easy-to-read tables and graphs so that critical information can be conveyed clearly to all stakeholders
Want real-time insight into terminal assets ?
Try our interactive Terminal Operations Intelligence tool to get a feel of how you can get an information that enable you to visualize your data, filter on demand and simply click to get deeper into the underlying data.
Click on the image to try the dashboard
Management need to have real time status of all the operations activities.When accessing the operations productivity within the terminal, operators will tend to look up ,one of the issue that is equipment productivity
Equipments moves are the real indicator of Terminal Performance, these dictates the berth utilization. Equipments undoubtedly is the most expensive asset, a terminal has. Focus on keeping equipment productivity is an important step to profit.
To improve the productivity, Operators need to analyse
- Equipment wise moves
- Monthly and weekly equipment moves
- Category wise moves(i.e Import,Export ,Transshipment, Restow)
- Freight kind moves(i.e Full or Empty)
- Container Size wise moves
Operations Intelligence specifically for ports gives a visibility of real-time dynamic, business analytics that delivers visibility and insight into these data. Standards reports are generated to improve the operations performance and to get clear visibility in day to day operations.
Explore more about our Real-time terminal performance tool
For marine terminal operations, one of the key priorities are to service the vessel quickly, efficiently and improve the berth availability for additional vessel operations.
This requires some advanced planning that would enable efficiency in operations thus would improve the vessel productivity by measuring some of the key areas that would support the improvements
Some of the historical information from previous operations of similar vessel calls will be useful to create our own intelligence to reduce vessel waiting time.
- How many vessel arrived and how many discharged in current date?
- How many containers have moved in last one hour?
- No of lifts per vessel hour.
- QC productivity of vessel in shift, day and total vessel
- Line operator wise, freight kind and container size
- Yard Move analysis for the operating vessel
- And many more data points that would require analysis
Terminal Operations Intelligence (TOI) would enable a terminal to easily measure and monitor the key concern of rising vessel turnaround time ,which might be due to following reason:-
- Inefficient crane operations
- Yard delays that waste crane operator time
Following are the examples of how dashboards can provide Vessel Productivity:
Vessel Productivity analysis according to the Crane wise:-
Vessel Productivity according to the Categories:-
TOI allows Terminals to identify where the hold-ups are located and helps to effectively develop strategies to reduce delay and improve efficiencies so that preventive and corrective action can be taken.
Explore more about our Real-time terminal performance tool
The primary objective of all terminals is to reduce the truck’s waiting time via smoothing the gate activities i.e. to prevent the gate from being a bottleneck.The time spent in waiting to enter the terminal is a consequence for the port performance.
Terminal operating systems with an integrated BI solution enable the terminal executive to manage truck and container movements at terminals, which integrate gate, yard and quay operations.
BI Solution designed especially for terminals, with right Dashboards, KPIs and Analytical Cubes will help to analyze collective truck turnaround time which helps in reducing truck idling times.
The gate, yard, quay are the most important activity sectors that take place in container terminals.
BI tool gives an analysis of gate wise truck turnaround time (in time and out time of truck), how many containers have been handled by each gate and also gives an alert if the truck wait time exceeds from the target wait time .
On a Weekly basis, each terminal reports the average in-terminal truck turn time. The average gate turn time is defined as gate in time to gate out time, in other words, how long the trucker is actually in the terminal. This measure does not include any time spent waiting outside of the gate before entry.
The below dashboard shows truck wait time (Real time) analysis:
Below dashboard shows Weekly Average Truck Turnaround Time at Gate:
BI solution helps to give an analysis of the loading and unloading of containers (full or empty) on terminal trucks in the yard, provide information of container tracking.
Below dashboard shows Truck Turnaround Time at Yard:-
An ERP project, whether it’s a pilot, roll-out or an upgrade, will bring in multitude of changes within the organization. It’s important for the management to fully assess the impact of the change due to an ERP implementation decision.
Some of the several challenges a company faces in an ERP implementation are Change Management, Project Management and Cost Management along with its associated escalations, Risk Mitigations to Customizations and Expectations management.
Change in an ERP Implementation could be of various types:
Change in Processes – being brought in global business practices
Change in Roles – being brought in due to segregation of duties
Change in Effort to Input information – being brought in due to the higher level of details required by the new ERP
Address these changes, by listing each of them and working out with the product experts to ensure that only Business driven changes are applied. Super Users or Core Users, who plan for these improvements as a periodical and continuous basis, are better able to manage their user community, than those who just worry about maintaining what is delivered as a package.
The “owner” of the implementation has to be an in-house individual, who is not only familiar with the various departments and the user community, but also has the support and mandate of the Top management, to be able to suggest and manage the expectations.
An ERP implementation does not just bring in the perceived changes, it brings in a sea of opportunities to do additional things under the ERP umbrella:
Don’t just use PCs and Laptops, enable wide screen displays in workshops and control rooms. Get Status reports and Pending Tasks Queries to be displayed at appropriate areas, to drive work completion.
Evaluate tasks performed manually, and if these can be automated to reduce the data entry effort. The thumb rule, is to identify all those interaction points, where a single user interacts with multiple applications, to deliver or manage a feature. Automate these data entry , and get the user to monitor accuracy than just efficiency.
Use the “Ease of Use features – GUI Functionalities” of the product to reduce as much effort and make day to day working
pleasant for the end user.
Share your thoughts on Change Management during ERP Implementations and we will let you know of some of the best practices we have seen.
Senior management understands that inventory is regarded as a ‘black hole’, absorbing cash and resources. With appropriate business intelligence, ‘black holes’ can be effectively addressed, and the company will realize a direct effect on bottom line profit.
Some of the challenges faced:
- To improve visibility of data that can help to identify inventory positions and potential stock out issues.
- To reduce the non-value added labor dedicated to the management of physical inventory.
A flexible, powerful Business Intelligence system is worth, where you need to understand current inventory levels, plan for a seasonal buying frenzy, find out the status of inventory for internal consumption and predict required inventory.
BI reports are very important for Inventory Management, manager:
- Ports and terminals can increase the opportunity cost, inventory accuracy and reduce the non-value-added costs by seeking out an integrated inventory solution that joins business intelligence tool.
The Inventory Manager, can share different BI reports and his analysis with management, other managers, end-users and establish metrics, goals so that every user sees and uses the information and be aware of critical issues like stock shortages.
Inventory Aging Report:
Inventory aging helps to drive down stock level, fast moving items, slow moving items and helps to monitor value of money/capital blocked in inventory.
The fact majority of businesses have their capital tied to their inventory. What this means is that the business will delve into an inventory aging analysis too often, there will be a lot of money that cannot be used. Where there is too little inventory, it might cause delay in container maintenance work, repair of equipment, and might cause delay to attend breakdown maintenance calls, which eventually affects heavy loss due to machine/Crain shut down. If the company is caught in-between an inventory balancing act, the company will only take guesses on the types of inventory it requires.
We have to keep in mind that:-
- If we have too much inventory of a particular part, it would block working capital. Increased expenses associated with interest on loans, taxes, insurance and storage costs. Cash will be tied up and thus profits will be stilled.
- If we have too little inventory stock of item which is regularly used, it would end up with the increased occurrences of insufficient stock of inventory for repair and maintenance work.
It’s recommended that one should consider an inventory aging analysis at regular intervals. BI Inventory aging report helps to identify parts which are in stock for relatively longer period of time.
Port Asset Management is becoming increasingly important, whether as a simple means of recording assets and maintenance works or as part of a larger scheme to fully optimise the management of all Port assets and resources.
Enterprise Asset Management solution contains information regarding work order cost ,work order execution details , work order downtime.“Maintenance” is the core feature, helps to minimize downtime reliably and integrate asset-related data, business processes, and analytics.
Asset Maintenance solution captures details about work order cost, work order execution details, work order downtime.Downtime can be a planned event or an unplanned event.
A strategic alignment between “Higher Productivity ” which is (operation KPI) and “Total Preventive Maintenance” which is (Maintenance Organization KPI) is brought in by:-
- Reducing Unplanned Downtime.
Optimizing planned downtime
A good Business Intelligence tool , should provide :
1. Analytical capability to perform frequent failure mode analysis.
2. Comparative cost between periods for cost of break-down when planned downtime is performed on “TIME” V/S Cost of Break Down when planned downtime is delayed per day.
3. Comparative reason for analyzing what factors caused the delay in performing planned Maintenance.
Weather or such external factors.
Graphical decision tree:
Through Graphical analysis, the reasons for increase or decrease of unplanned maintenance cost can be analyzed by drilling down to core reasons, especially delay in performing maintenance delays. By carrying out preventive maintenance inspection and servicing on time, or within organization permissible limits, we can mitigate the risk of equipment failures and bring cost under control.
As can be seen in the below example of analysis, cost of repair tends to increase when the previous servicing schedules have been postponed ,and tends to be lower when servicing schedules delays are within certain limited delays. 81% of the QC repair Costs are when servicing schedules are delayed for more than 12 days, and this in consideration of the fact that QCs (in below example) contributes to 77.75% of repair costs overall.
The analysis and the number generated by above 3, should definitely be a guiding factor for ports and terminal to:-
Get Operations and Maintenance to agree upon planned downtime schedules.
Execute Planned preventive maintenance ,under agreed schedule and variances.
Improve upon Operational Productivity and Production Efficiency due to reduced breakdown.
In practice, while TPM cannot be 100% implemented , the effort to perform any planned service (Preventive Maintenance) “ON TIME” reduce the cost of break down (unplanned downtime) by a significant margin. For ports, unplanned maintenance equals unscheduled downtime and a significant hit to the bottom line, not only in terms of reduced throughput and revenue, but also in terms of managing relationships with shipping lines.
With intense pressure on Margins and increasing competition, Commercial team needs to keep close watch on their numbers. Numbers need to be accurate and in real time. Numbers need to be available 24×7 and should be accessible from anywhere and on any device. Numbers like Target Verses Actual, Year To Date Performance, Business Mix of Imports, Exports, Domestics and Transshipments are very close to heart to any Commercial Manager.
Commercial organizations in Ports and Terminals have moved beyond the spreadsheets and now rely more on analytic tools to get visibility on facts from historical and real-time processing of online data. Business Intelligence in commercial organization is important as it gives visibility on which direction the business is moving and when and what decisions to be taken.
Business Intelligence for commercials gives insights from multiple source of data in a single screen. While Commercial Dashboards provides a good visual representation of facts and help you stay connected with the numbers on a day to day basis, there are other tools like cubes and reports that helps you analyze data to the last level and assist you to drive change and improvement.
KPI can be driven on facts in real-time basis by linking Commercial BI with KPI Management, adding more consistency and accuracy in performance management.
Feel free to give us your feedback and drop in an email at email@example.com. Connect with us on Linkedin