Project

General

Profile

Actions

Task #18682

open

Task #18880: Sprint Planning for 20/10/2025 - 31/10/2025

Dashboard for CEO/Managers

Added by Redmine Admin 12 months ago. Updated 3 months ago.

Status:
QA
Priority:
High
Assignee:
-
Start date:
08/15/2025
Due date:
08/15/2025 (about 13 months late)
% Done:

0%

Estimated time:
0:00 h
Spent time:
GitLab ID:
3097
GitLab Milestone:
GitLab Ticket Number:
832
GitLab Time Logged:
126000
Lock Timeline Date:
No
gitlab project trace:

Description

CEO/Managers Dashboard

This dashboard loads when a user with ‘management’ authority logs in. This typically refers to CEO, General Managers, and Department Heads who require a strategic overview of revenue, profitability, client distribution, and performance trends.

Each user will see all data for decision-making purposes.

The general filters defined in section 1 above apply.

The default time span selected will be ‘this month’.

Apply predictive analysis where applicable – normally this applies to charts (e.g., revenue forecasts, cost vs sales projections).

All reports should be able to filter by the following where applicable:

  • Transport Mode: Ocean / Air (multi-select)
  • Shipment Type: Import / Export (multi-select)
  • Client(s) (multi-select search)
  • Vessel (search)
  • Custom Date Range (ETA)
  • Custom Date Range (ETD)

Note: Default filter selection = Current Month (based on ETA).

 KPIs
  • Total Revenue (MUR) (period – default current month)
  • Total Profit (MUR)
  • Gross Profit Margin (%)
  • Cost-to-Revenue Ratio (%)
  • Revenue Forecast vs Target (%)
  • Client Concentration Risk (% from top 5 clients)

 1. Revenue / Income

Charts:

  • Bar Chart: Revenue by Vessel/ Import- loading port or Export - destination port /Service.
  • Line Chart: Revenue trend (monthly / quarterly/yearly, etc..).
  • Period Comparison: Quarter-over-Quarter change.
  • Forecast Chart: Predictive quarterly and yearly revenue.
  • Pie Chart: Profit by Service (Total & %)
  • Dual-Axis Time Series: Cost vs Sales trend with forecast line.
  • Growth Trend by Trade Lane – Map or Bar showing changes in key routes (Origin/Destination)
  • Client Concentration – Pie/Bar showing % revenue from top 10 clients
  • Bar Chart: Quotations by Status.
  • Trend Chart: Quotation approval/cancellation/pending trends over time.

Vessel Table:

  • Vessel Name
  • Shipment Type
  • Origin
  • Destination
  • No. of BLs in the vessel
  • Revenue Amount
  • Profit Amount

 Cost and Sales Table

  • Shipment Type
  • Service
  • Vessel
  • Period
  • Total Cost (MUR)
  • Total Sales (MUR)
  • Profit (MUR)
  • Profit Margin %

 Quotation Status Table

  • Quotation Status Overview
  • Approval vs Cancellation Trend
  • Conversion Rate %

Clients Table:

  • Client Name
  • Revenue (MUR)
  • Number of Shipments
  • Last Shipment Date

 


GitLab Sync Log

[{"id": "40782", "author": "Ilhaan Hoolash", "hours": 40.0, "created": "2026-03-24T05:54:34.877Z", "log_date": "2026-03-24", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-24T05:54:34.877Z: 40h-(40.0)h spend at: 2026-03-24", "status": "deleted", "deleted_by": "", "redmine_entry_id": 12719}, {"id": "41052", "author": "Ilhaan Hoolash", "hours": 2.0, "created": "2026-03-26T05:30:51.471Z", "log_date": "2026-03-23", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-26T05:30:51.471Z: 2h-(2.0)h spend at: 2026-03-23", "status": "active", "deleted_by": "", "redmine_entry_id": 12758}, {"id": "41050", "author": "Ilhaan Hoolash", "hours": 2.0, "created": "2026-03-26T05:30:27.376Z", "log_date": "2026-03-22", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-26T05:30:27.376Z: 2h-(2.0)h spend at: 2026-03-22", "status": "active", "deleted_by": "", "redmine_entry_id": 12759}, {"id": "41036", "author": "Ilhaan Hoolash", "hours": 8.0, "created": "2026-03-26T05:22:52.032Z", "log_date": "2026-03-22", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-26T05:22:52.032Z: 8h-(8.0)h spend at: 2026-03-22", "status": "deleted", "deleted_by": "41049", "redmine_entry_id": 12760}, {"id": "41033", "author": "Ilhaan Hoolash", "hours": 6.0, "created": "2026-03-26T05:18:41.363Z", "log_date": "2026-03-19", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-26T05:18:41.363Z: 6h-(6.0)h spend at: 2026-03-19", "status": "active", "deleted_by": "", "redmine_entry_id": 12761}, {"id": "41032", "author": "Ilhaan Hoolash", "hours": 8.0, "created": "2026-03-26T05:18:26.105Z", "log_date": "2026-03-18", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-26T05:18:26.105Z: 8h-(8.0)h spend at: 2026-03-18", "status": "active", "deleted_by": "", "redmine_entry_id": 12762}, {"id": "41031", "author": "Ilhaan Hoolash", "hours": 8.0, "created": "2026-03-26T05:18:15.814Z", "log_date": "2026-03-17", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-26T05:18:15.814Z: 8h-(8.0)h spend at: 2026-03-17", "status": "active", "deleted_by": "", "redmine_entry_id": 12763}, {"id": "41029", "author": "Ilhaan Hoolash", "hours": 8.0, "created": "2026-03-26T05:17:31.496Z", "log_date": "2026-03-16", "comment": "Imported from GitLab by @Ilhaan Hoolash on 2026-03-26T05:17:31.496Z: 8h-(8.0)h spend at: 2026-03-16", "status": "active", "deleted_by": "", "redmine_entry_id": 12764}, {"id": "42252", "author": "Waliyuddin Delba", "hours": 1.0, "created": "2026-04-15T11:42:02.270Z", "log_date": "2026-04-14", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-04-15T11:42:02.270Z: 1h-(1.0)h spend at: 2026-04-14", "status": "active", "deleted_by": "", "redmine_entry_id": 13104}]

Actions #1

Updated by Redmine Admin 12 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 11 months ago

  • Parent task changed from #18664 to #18862
  • gitlab project trace changed from Sprint Planning for 12/08/2025 - 22/08/2025 to Sprint Planning for 06/10/2025 - 17/10/2025
Actions #3

Updated by Redmine Admin 11 months ago

  • Parent task changed from #18862 to #18880
  • gitlab project trace changed from Sprint Planning for 06/10/2025 - 17/10/2025 to Sprint Planning for 20/10/2025 - 31/10/2025
Actions #4

Updated by Redmine Admin 10 months ago

  • gitlab project trace deleted (Sprint Planning for 20/10/2025 - 31/10/2025)
Actions #5

Updated by Redmine Admin 5 months ago

  • GitLab Time Logged changed from 0 to 144000
Actions #6

Updated by Redmine Admin 5 months ago

  • GitLab Sync Log updated (diff)
Actions #7

Updated by Redmine Admin 5 months ago

  • GitLab Time Logged changed from 144000 to 122400
Actions #8

Updated by Redmine Admin 5 months ago

  • GitLab Sync Log updated (diff)
Actions #9

Updated by Redmine Admin 5 months ago

  • GitLab Time Logged changed from 122400 to 126000
Actions #10

Updated by Redmine Admin 5 months ago

  • GitLab Sync Log updated (diff)
Actions #11

Updated by Redmine Admin 4 months ago

  • Status changed from New to QA
Actions

Also available in: Atom PDF