Business Case Template
Baseline KPIs
| KPI | Current | Source | Notes |
|---|---|---|---|
Financials
Risks & Mitigations
| Risk | Impact | Likelihood | Mitigation |
|---|---|---|---|
A concise, sequential curriculum to understand shipping economics, vessel operations, stakeholders, regulations, and the maritime technology stack. Includes printable templates (business case, integration checklist, KPI tracker) and a sample CSV dataset for hands‑on exercises. Designed for A4/Letter printing.
Tip: Use the Print button for best results (A4 or Letter). Major sections start on new pages.
| Segment | Operational Risks | Tech ROI Hotspots |
|---|---|---|
| Tankers | Contamination, compatibility, SIRE/PSC findings, STS safety, heating/inert gas failures. | Safety/HSQE and compliance suites, voyage optimization, vetting readiness analytics. |
| Dry Bulk | Moisture/TML, cargo damage, hatch integrity, delays driving demurrage. | Laytime/demurrage analytics, port call/JIT tools, hull/prop performance monitoring. |
| Container | Schedule slippage, terminal constraints, reefer failures, equipment imbalances. | Schedule optimization, reefer IoT, equipment tracking, TOS/DCSA data integrations. |
Note: ROI areas vary with charterparty terms, bunker exposure, and network control.
| KPI | Current | Source | Notes |
|---|---|---|---|
| Risk | Impact | Likelihood | Mitigation |
|---|---|---|---|
| Source | Field | Type | Units | Frequency | Destination | API/Protocol |
|---|---|---|---|---|---|---|
Variance is auto‑calculated as Actual − Target. Use per‑row directionality to color results. Summary metrics derive from rows whose KPI includes “Fuel” or “CO2e”.
| Date | Vessel | Voyage | Category | KPI | Baseline | Target | Actual | Variance | Dir. | Data Source | Confidence | Owner | Next Action | Due Date | Notes | Delete |
|---|
Copy the CSV below or use the Download button. Import into Excel/Google Sheets (File → Import → Upload) and use it for the voyage model or to populate KPIs.
date,vessel_name,imo,segment,voyage_id,leg,lat,lon,speed_kn,distance_nm,fuel_type,fuel_consumed_mt,fuel_price_usd_mt,cargo_tonnes,ballast,eca_hours,weather_delay_h,waiting_anchorage_h,co2e_mt,tce_usd_day,cii_rating_est 2025-07-01,MV Ocean Star,9876543,Dry Bulk - Panamax,OS-24A,SEA->CJK,17.8,122.3,12.5,302,IFO380,28.6,520,68000,false,6,2,0,89.0,21850,B 2025-07-02,MV Ocean Star,9876543,Dry Bulk - Panamax,OS-24A,SEA->CJK,19.1,124.7,12.2,295,IFO380,27.9,520,68000,false,4,0,3,86.9,22110,B 2025-07-03,MV Ocean Star,9876543,Dry Bulk - Panamax,OS-24A,SEA->CJK,20.5,127.1,11.8,288,IFO380,27.1,520,68000,false,4,1,0,85.0,21930,B 2025-07-04,MV Ocean Star,9876543,Dry Bulk - Panamax,OS-24A,SEA->CJK,22.0,129.6,11.0,270,IFO380,26.3,520,68000,false,3,0,1,82.1,22400,B 2025-07-05,MV Ocean Star,9876543,Dry Bulk - Panamax,OS-24A,SEA->CJK,23.4,131.9,10.8,265,IFO380,25.9,520,68000,false,2,0,0,81.4,22620,B 2025-07-01,MT Blue Horizon,9765432,Tanker - MR,BH-88Q,SIN->MUM,1.3,103.8,13.0,315,VLSFO,24.2,600,34000,true,8,0,0,76.1,24500,A 2025-07-02,MT Blue Horizon,9765432,Tanker - MR,BH-88Q,SIN->MUM,2.8,101.2,12.7,308,VLSFO,23.9,600,34000,true,6,0,0,75.3,24320,A 2025-07-03,MT Blue Horizon,9765432,Tanker - MR,BH-88Q,SIN->MUM,4.1,99.6,12.4,300,VLSFO,23.3,600,34000,true,4,1,0,73.8,24710,A 2025-07-04,MT Blue Horizon,9765432,Tanker - MR,BH-88Q,SIN->MUM,5.6,98.1,11.9,292,VLSFO,22.7,600,34000,true,4,0,2,72.1,24940,A 2025-07-05,MT Blue Horizon,9765432,Tanker - MR,BH-88Q,SIN->MUM,7.0,96.5,11.5,284,VLSFO,22.1,600,34000,true,3,0,0,70.9,25110,A
Import hints: In Sheets use File → Import → Upload; ensure numeric fields parse as numbers. In Excel use Data → From Text/CSV.
| Term | Definition |
|---|---|
| AIS | Automatic Identification System for vessel tracking and collision avoidance. |
| ECDIS | Electronic Chart Display and Information System used for navigation. |
| VDR | Voyage Data Recorder; records navigational and sensor data. |
| TCE | Time Charter Equivalent; normalized earnings metric for voyage performance. |
| Laytime | Agreed loading/unloading time; exceeding it may incur demurrage. |
| Demurrage | Charge for exceeding allowed laytime under a charterparty. |
| CII | Carbon Intensity Indicator; operational efficiency rating for ships. |
| EEXI | Energy Efficiency Existing Ship Index; design efficiency requirement. |
| MRV | EU Monitoring, Reporting, Verification of CO2 emissions. |
| DCS | IMO Data Collection System for fuel consumption and distance. |
| EU ETS | EU Emissions Trading System; cap-and-trade for shipping emissions. |
| FuelEU | FuelEU Maritime; mandates GHG intensity reductions in marine fuels. |
| Worldscale | Benchmark freight rate system for tanker charters. |
| BDI | Baltic Dry Index; indicator of dry bulk freight market. |
| SCFI | Shanghai Containerized Freight Index; container freight benchmark. |
| FBX | Freightos Baltic Index; container freight rate index. |
| OCIMF | Oil Companies International Marine Forum; tanker vetting standards. |
| SIRE | Ship Inspection Report Programme; tanker inspection regime. |
| PSC | Port State Control; inspections to verify compliance. |
| P&I | Protection & Indemnity insurance; third‑party liability cover. |
| Class | Classification society that sets and verifies technical standards. |
| Flag | Flag state under which a vessel is registered. |
| Port State | Jurisdiction and controls exercised by a port authority. |
| PMS | Planned Maintenance System for equipment upkeep. |
| CMMS | Computerized Maintenance Management System. |
| HSQE | Health, Safety, Quality, Environment management. |
| JIT Arrival | Just‑in‑time arrival to reduce anchorage time and emissions. |
| VSAT | Very Small Aperture Terminal; maritime satellite communications. |
| LEO | Low Earth Orbit satellite connectivity for higher bandwidth/low latency. |
| IACS UR E26/E27 | Unified Requirements for cyber resilience of ships and onboard systems. |
| STS | Ship‑to‑Ship transfer operations, common in tankers. |
| TML | Transportable Moisture Limit; critical for safe carriage of bulk cargoes. |
| ULCV | Ultra Large Container Vessel; largest container ship class. |
| Reefer | Refrigerated container for perishable cargo. |
| EDI/EDIFACT | Electronic data interchange standards for trade messages. |
| DCSA | Digital Container Shipping Association; data and process standards. |
| Noon Report | Daily vessel report including position, speed, consumption. |
| Charterparty | Contract between shipowner and charterer for employment of a vessel. |