Executive Performance Dashboard
Period: 2026-Q1 Cycle: Open for EditsDual governance audit sign-off ensures data provenance and locks reporting against retroactive changes.
1. HOD Input (Maker)
Kwame Mensah (HOD)
Submitted 05 Mar2. QAQC Audit (Checker)
Esi Osei (QAQC Auditor)
Approved 08 Mar3. Period Immutability
Period Locked
Hash: #9B4E8F21Corporate Score
Arithmetic94.8%
Achieved (Green)
42 KPIs
Click to drill down into achieved list →
Attention (Amber)
8 KPIs
Click to drill down into warning list →
Critical (Red)
3 KPIs
Click to drill down into critical CAPAs →
ConShip Tri-ISO Quality, Safety & Environmental Performance
Service Quality, Customs Clearance Turnaround, Demurrage Minimization & Client SLAs
Zero LTIF Incidents, Haulage Driver Fitness, Terminal Safety Audits & Near-Miss Resolution
Fleet Fuel/Carbon Intensity, Zero Bunkering Spills, Paperless Customs & Waste Diversion
Four Strategic Perspectives Matrix
Click any perspective card to filter the 17-desk league table below
DSO, billing turnaround, budget variance (FNA, Commercial)
Clearance turnaround, demurrage reduction (SCF, CFS, MPH)
Fleet availability, PM adherence, IT uptime (LGT, PNA, MNT, ICT)
Zero HSE accidents, training hours, SOP compliance (HSE, HRA, QAQC, Risk)
Departmental Performance League Table
Filter by ISO Tri-Standard or BSC Perspective; click any row to inspect the 14-column ledger
| Department / Desk | Category | Total KPIs | Green | Amber | Red | Avg Achievement | Status | Action |
|---|
Active Risk Escalation Gateway (Power Automate & Email Triggers)
Automated webhook dispatcher alerts Managing Director and Board Risk Committee for indicators under 80% threshold.
CONSHIP Dynamic Report Generator
Generate custom monthly, quarterly, annual, operational vs non-operational, and best vs lagging reports.
CONSOLIDATED SHIPPING AGENCIES LIMITED
Corporate Performance Management System | Official Audit Report
Consolidated Performance Overview (2026 - Quarter 1)
This report compiles institutional KPI metrics across the selected organizational scope. All figures are evaluated according to authentic CONSHIP directional formulas (higher-is-better, lower-is-better, and zero-defect). Amber and Red metrics include documented root-cause challenges and CAPA remediation plans.
Average Corporate Score
94.8%
Above Target Baseline
Top Performing Desk
PNA (111.2%)
Zero Red Indicators
Lagging Desk (Attention)
SCF-Takoradi (88.1%)
1 Critical Demurrage Red
Active CAPA Registry
11 Actions
Under QAQC Oversight
Top 3 Overachieving Departments (Best Performers)
Bottom 3 Lagging Departments (Intervention Required)
Detailed Indicator Ledger & CAPA Status
| Desk | Department Objective | KPI Name | Direction | Target | Actual | Achieve | RAG | Evidence / Comments | Challenges & CAPA Action | Due Date |
|---|
Compiled By:
QAQC & Performance Audit Lead
Signature: _______________________
Reviewed By:
Head of Risk & Legal Compliance
Signature: _______________________
Approved By:
Managing Director / Board Committee
Signature: _______________________
Board of Directors - Quarterly Performance Review
Consolidated Executive Briefing for Consolidated Shipping Agencies Limited (CONSHIP)
1. Executive Summary & Operational Trajectory
During the active quarter, CONSHIP demonstrated solid operational resilience, posting an overall corporate achievement rate of 94.8% across all 17 desks. Operational hubs in Takoradi and Tema recorded substantial improvements in customs clearance speed, supported by ICUMS pre-manifest clearance integration. Marine Ports & Husbandry (MPH) achieved 100% SLA compliance on offshore crew changes.
Non-operational support divisions met governance expectations with zero Lost Time Injuries (LTIF = 0) recorded by HSE. However, supply chain bottlenecks and third-party contractor delays impacted LGT fleet maintenance turnaround times and Takoradi container demurrage, triggering formal CAPA escalations under QAQC oversight.
2. Key Performance Indicators At A Glance
| Desk | KPI Indicator | Target | Actual | RAG | Identified Operational Challenge | Approved Corrective Action Plan (CAPA) | Owner & Due Date |
|---|---|---|---|---|---|---|---|
| SCF-Takoradi | Zero Demurrage Charge on Ocean Shipments | 0 GHS | 1,200 GHS | Red | Shipping line delayed bill of lading surrender at Takoradi port | Enforce mandatory pre-arrival electronic B/L surrender clause in client contracts | Takoradi Lead 2026-04-10 |
| ICT | Quarterly Disaster Recovery Simulation Drill | 100% Pass | 82% | Red | ISP failover fiber latency timed out secondary SQL replication | Install dedicated 100Mbps microwave backup failover circuit in Takoradi Datacenter | IT Infrastructure Lead 2026-04-15 |
| LGT | Fleet Preventative Maintenance Adherence | 98% | 89% | Amber | OEM spare parts backordered from Europe for heavy prime movers | Establish strategic consignment stock agreement with approved local truck parts distributor | PNA & Fleet Lead 2026-04-30 |
Summary Data Master Matrix
Cross-departmental indicator directory across all 17 CONSHIP Operational & Non-Operational desks
| Desk | Department Objective | KPI Name | Direction | Target | Actual | Achieve (%) | RAG | Evidence / Comments | Challenges & CAPA Action | Due Date |
|---|
Procurement & Assets | PNA
OperationalOfficial CONSHIP 14-Column Ledger | Process Owner: Head of Procurement & Assets
| # | Department Objective | KPI Name | Direction | Target | Actual | Achieve | Status | Evidence / Comments | Challenges & CAPA Action | Responsible | Due Date | Actions |
|---|
CONSHIP Performance Management System - User Guide
Operational protocol extracted directly from the "Home & User Guide" sheet of the master workbook.
1. KPI Reporting Cycle & Deadlines
Every Departmental Process Owner (HOD) is strictly mandated to input their monthly and quarterly KPI numbers into the portal no later than the 5th calendar day following the reporting period close.
2. Authentic Directional Scoring Logic
• Higher is better: Achievement = (Actual / Target) * 100.
• Lower is better: Achievement = (Target / Actual) * 100 (e.g. Demurrage, Truck Turnaround, MTTR).
• Zero-Defect: Achievement = Actual == 0 ? 100% : 0% (e.g. Lost Time Injuries, Critical Breaches).
3. ISO 9001 Mandatory CAPA Protocol
Whenever an indicator results in Amber or Red, the user cannot finalize their submission without documenting the root challenge, corrective action, responsible person, and due date.
4. Maker-Checker Verification & Freeze
HOD inputs data -> QAQC and Risk Committee audit evidence -> Administrator freezes the cycle.
Standard Operating Procedures (SOPs) & Knowledge Base
Official corporate repository for operational standards, audit baselines, and institutional lessons learned.
When underperforming indicators (Amber/Red) receive verified CAPA corrective action plans, clicking "Auto-Synthesize from CAPAs" converts the remediation strategies into permanent standard operating procedures across all 17 desks to prevent recurrence.
Institutional Performance Intelligence Copilot
Trained on CONSHIP's 17 operational desks, 136 indicators, and ISO 9001:2015 governance standards. Generates MD executive performance briefings, root-cause diagnostics, automated CAPAs, and risk drift forecasts.
Executive Performance Briefing & Strategic Synthesis
Click "Generate Executive MD Briefing" to run full institutional AI synthesis across all 17 desks.
Ask CSA AI Assistant
Quick Inquiry Prompts:
Predictive Anomaly & Drift Radar (Early Warning System)
Flags operational indicators currently performing between 80% and 88% that are at high risk of slipping into the Red Band without immediate supervisory intervention.
Settings, User Access Governance & Period Control
Manage Role-Based Access Control (RBAC), reporting periods, master Excel exports, and cycle locks.
1. Reporting Period & Cycle Freeze
Cycle freeze prevents accidental changes after QAQC audit:
2. Master Corporate Data Export
Generate a comprehensive multi-tab enterprise workbook containing all 17 desks, executive summaries, and CAPA logs.
Enterprise User Access Management & Desk Linkage
Manage user credentials, roles (Admin, QAQC, HOD, Viewer), and departmental desk ownership.
| User Name | Assigned Role | Linked Department Desk | Status | Permissions Scope | Actions |
|---|
Microsoft Power Automate & SharePoint API Gateway
Configure telemetry endpoints for automated executive escalation alerts and cloud document synchronization.