Balanced Scorecard

Inland Transportation & Container Logistics

Performance Dashboard

Real-time overview of key performance indicators across all perspectives

Revenue (Monthly)
฿12.5M
↑ 8.5%
Target: ฿12M
Operating Profit Margin
18.2%
↑ 2.1%
Target: 15%
Fleet Utilization Rate
87%
↑ 5%
Target: 85%
On-Time Delivery Rate
94.5%
↓ 1.5%
Target: 95%
Customer Satisfaction
4.6/5.0
↑ 0.3
Target: 4.5
Customer Retention
92%
↑ 3%
Target: 90%
Driver Training Hours
42 hrs
↑ 12 hrs
Target: 40 hrs/year
Safety Compliance
98.5%
↑ 1.5%
Target: 97%

Fleet Overview

Total Truck Tractors
45 units
40ft Container Trailers
60 units
20ft Container Trailers
35 units
Active Drivers
52 drivers

This Month Performance

Total Trips Completed 1,248 trips
Import Containers Handled 678 TEUs
Export Containers Handled 570 TEUs
Average Trip Distance 85 km
Fuel Efficiency 2.8 km/L

📋 Data Management Table

Edit all KPIs in one convenient location - changes sync across all tabs

💰 Financial Perspective

KPI Name Current Value Target Value Unit Status
Monthly Revenue Million ฿ ↑ 8.5%
Operating Profit Margin % ↑ 2.1%
Revenue per Trip ฿ ↑ 0.2%
Return on Assets (ROA) % ↑ 5%
Cash Flow from Operations Million ฿ ↓ 5%
Cost per Kilometer ฿/km ↑ 6%

⚙️ Internal Business Processes

KPI Name Current Value Target Value Unit Status
Fleet Utilization Rate % ↑ 5%
On-Time Delivery Rate % ↓ 1.5%
Average Turnaround Time hours ↑ 5%
Vehicle Downtime % ↓ 20%
Fuel Efficiency km/L ↑ 7%
Container Damage Rate % ↓ 20%

👥 Customer Perspective

KPI Name Current Value Target Value Unit Status
Customer Satisfaction Score out of 5 ↑ 0.3
Customer Retention Rate % ↑ 3%
Net Promoter Score (NPS) score ↑ 16%
Response Time (Quotes) hours ↑ 5%
Repeat Business Rate % ↑ 4%
Complaint Resolution Time hours ↓ 25%

📚 Learning & Growth

KPI Name Current Value Target Value Unit Status
Driver Training Hours hrs/year ↑ 12 hrs
Safety Compliance Rate % ↑ 1.5%
Employee Satisfaction out of 5 ↑ 5%
Employee Retention Rate % ↓ 2%
Technology Adoption Rate % ↑ 19%
Process Innovation Score out of 10 ↑ 11%

🚛 Fleet & Operations Data

Item Current Value Unit Notes
Total Truck Tractors units Active fleet vehicles
40ft Container Trailers units Standard containers
20ft Container Trailers units Half containers
Active Drivers drivers Licensed operators
Total Trips Completed trips This month
Import Containers (TEUs) TEUs This month
Export Containers (TEUs) TEUs This month
Average Trip Distance km Per trip average
💰

Financial Perspective

Financial outcomes important to organizational success and sustainability

Revenue Growth

฿12.5M
Target: ฿12M 104%

Breakdown:

  • Import Operations: ฿6.8M (54%)
  • Export Operations: ฿4.2M (34%)
  • Special Transport: ฿1.5M (12%)

Operating Profit Margin

18.2%
Target: 15% 121%

Cost Structure:

  • Fuel: 32% of revenue
  • Driver salaries: 28%
  • Maintenance: 12%
  • Insurance & Permits: 10%

Revenue per Trip

฿10,016
Target: ฿10,000 100.2%

By Route Type:

  • Port to Warehouse: ฿8,500
  • Warehouse to Port: ฿8,200
  • Cross-border: ฿15,800

Return on Assets (ROA)

15.8%
Target: 15% 105%

Asset Base:

  • Fleet Value: ฿280M
  • Equipment: ฿45M
  • Facilities: ฿55M

Cash Flow from Operations

฿3.8M
Target: ฿4M 95%

Payment Terms:

  • Average Collection: 35 days
  • Average Payables: 42 days
  • Working Capital Ratio: 1.4

Cost per Kilometer

฿42.50
Target: ฿40 106%

Cost Drivers:

  • Fuel: ฿18/km
  • Driver: ฿12/km
  • Maintenance: ฿6.50/km
  • Others: ฿6/km

Strategic Actions

✓ Achieved

Negotiated bulk fuel discount (8% savings)

→ In Progress

Implementing route optimization software

○ Planned

Fleet expansion: 8 new tractors Q2 2025

⚙️

Internal Business Processes

Critical operations for delivering value and achieving objectives

Fleet Utilization Rate

87%
Target: 85% 102%

Utilization by Unit:

  • Truck Tractors: 89%
  • 40ft Trailers: 91%
  • 20ft Trailers: 82%

On-Time Delivery Rate

94.5%
Target: 95% 99.5%

Delay Analysis:

  • Traffic: 45% of delays
  • Port congestion: 30%
  • Vehicle issues: 15%
  • Other: 10%

Average Turnaround Time

4.2 hrs
Target: 4 hrs 95%

Time Breakdown:

  • Port waiting: 1.5 hrs
  • Loading/Unloading: 2.1 hrs
  • Documentation: 0.6 hrs

Vehicle Downtime

3.2%
Target: 4% 80%

Downtime Causes:

  • Scheduled Maintenance: 60%
  • Repairs: 30%
  • Accidents: 10%

Fuel Efficiency

2.8 km/L
Target: 2.6 km/L 107%

Efficiency Program:

  • Driver training impact: +0.3 km/L
  • Route optimization: +0.2 km/L
  • Fleet modernization: ongoing

Container Damage Rate

0.8%
Target: 1% 80%

Quality Metrics:

  • Minor damages: 0.6%
  • Major damages: 0.2%
  • Claims filed: 8 cases/month

Process Improvements

✓ Completed

Installed GPS tracking on all vehicles

→ In Progress

Digital documentation system rollout

○ Planned

Predictive maintenance AI system

👥

Customer Perspective

Customer satisfaction, retention, and value delivery

Customer Satisfaction Score

4.6/5.0
Target: 4.5 102%

Top Rated Attributes:

  • On-time delivery: 4.8/5
  • Communication: 4.7/5
  • Cargo safety: 4.6/5
  • Pricing: 4.3/5

Customer Retention Rate

92%
Target: 90% 102%

Customer Base:

  • Active clients: 128
  • New clients (YTD): 24
  • Lost clients (YTD): 6
  • Avg. relationship: 3.2 years

Net Promoter Score (NPS)

58
Target: 50 116%

NPS Breakdown:

  • Promoters: 68%
  • Passives: 22%
  • Detractors: 10%

Response Time (Quotes)

2.1 hrs
Target: 2 hrs 95%

Customer Service:

  • Quote requests: 180/month
  • Conversion rate: 68%
  • 24/7 support available

Repeat Business Rate

78%
Target: 75% 104%

Customer Segments:

  • Import/Export Cos: 45%
  • Freight Forwarders: 35%
  • Manufacturers: 15%
  • Others: 5%

Complaint Resolution Time

18 hrs
Target: 24 hrs 75%

Complaint Analysis:

  • Total complaints: 12/month
  • Resolved favorably: 92%
  • Top issue: Delays (40%)

Customer Initiatives

✓ Launched

Customer portal for real-time tracking

→ In Progress

Quarterly customer satisfaction surveys

○ Planned

Loyalty rewards program development

📚

Learning & Growth Perspective

Organizational capability, innovation, and continuous improvement

Driver Training Hours

42 hrs/year
Target: 40 hrs 105%

Training Programs:

  • Safety protocols: 15 hrs
  • Fuel efficiency: 10 hrs
  • Customer service: 8 hrs
  • Technology systems: 9 hrs

Safety Compliance Rate

98.5%
Target: 97% 102%

Safety Metrics:

  • Accident rate: 0.3 per million km
  • Zero fatalities: 1,825 days
  • Safety audits passed: 24/24

Employee Satisfaction

4.2/5.0
Target: 4.0 105%

Top Factors:

  • Competitive salary: 4.5/5
  • Work-life balance: 4.1/5
  • Management: 4.0/5
  • Career growth: 3.9/5

Employee Retention Rate

88%
Target: 90% 98%

Turnover Analysis:

  • Voluntary exits: 8 this year
  • Avg. tenure: 4.5 years
  • Top reason: Better offers (55%)

Technology Adoption Rate

95%
Target: 80% 119%

Digital Systems:

  • GPS tracking: 100%
  • Mobile app usage: 96%
  • Digital logs: 92%
  • E-documentation: 88%

Process Innovation Score

7.8/10
Target: 7.0 111%

Innovation Projects:

  • AI route optimization: Active
  • Predictive maintenance: Testing
  • Green fleet initiative: Planning

Learning Initiatives

✓ Completed

Advanced driver certification program

→ In Progress

Leadership development for supervisors

○ Planned

AI and automation training workshops