Pulse FirstPage Finance+Operations

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 2

Pulse : Port/Terminal Name

Trend
Monthly Forecast YTD
Category Weight % Actual Forecast Legends
Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul W1 Jul W2 Jul W3 Jul W4 Jul-22 Aug-22 Sep-22 2021-22 2022-23 J---A---S---O---N---D---J---F---M---A---M---J J ---A---S

Finance 20.0% 2.80 2.80 3.20 3.20 2.00 3.20 2.40 3.20 3.20 3.20 3.20 3.20 3.90 3.90 4.00 4.10 4.10 3.20 3.20 2.00 3.72 0 to 1
Operation 30.0% 2.31 2.32 2.37 2.15 2.09 1.25 1.23 2.08 1.80 2.08 2.12 1.36 1.90 1.80 1.60 1.60 1.38 1.40 1.56 3.16 2.81 1to 2
Safety 15.0% 2.55 2.26 3.16 3.30 3.96 2.33 3.72 3.29 3.02 3.86 2.70 2.95 4.90 4.80 4.20 4.20 3.29 3.53 3.53 1.92 3.65 2to 3
Marketing 25.0% 3.02 3.07 2.84 3.03 3.04 2.95 2.24 2.61 2.93 2.56 3.07 3.39 3.30 3.90 3.50 3.00 3.40 2.89 3.21 2.82 2.22 3to 4
HR 5.0% 2.35 2.25 2.25 2.35 2.25 2.55 2.40 2.50 2.60 2.35 2.25 2.25 2.30 2.40 2.40 2.60 2.60 2.60 2.50 2.30 2.05 4 to 5
Techno Comm 2.0% 4.00 3.00 4.00 4.00 3.00 4.00 4.00 4.00 3.00 3.00 2.00 3.00 3.00 3.00 2.00 1.90 2.00 2.00 2.00 3.00 3.00
ESG 2.0% 4.00 3.30 4.00 3.65 4.00 3.30 3.83 3.65 4.00 2.78 3.13 3.53 3.70 3.60 3.20 3.40 3.48 3.48 3.30 2.60 2.60
User Input
IT 1.0% 3.50 4.00 4.00 3.00 3.00 1.50 2.50 2.50 3.50 3.50 4.00 4.00 4.00 3.70 3.40 3.00 3.80 4.10 4.70 2.00 2.00

Overall 2.70 2.64 2.85 2.83 2.66 2.39 2.27 2.71 2.67 2.75 2.70 2.62 3.20 3.30 3.04 2.95 2.85 2.59 2.71 2.59 2.92
APSEZ Digital - Analy tics Hub

Note : All Data used are indicative and for representation purposes only.

Finance

Vital Stats
KPI Weight % YTD'21-22 YTD'22-23 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22
EBITDA% 40.0 1.00 4.00 4.00 4.00 4.00 4.00 5.00 5.00 3.00 4.00 4.00 4.00 4.00 4.00 5.00 5.00 5.00
ROCE % 40.0 4.00 4.00 3.00 3.00 4.00 4.00 0.00 3.00 3.00 4.00 4.00 4.00 4.00 4.00 3.00 3.00 3.00
Revenue Marine 2.6 1.00 4.00 1.00 1.00 0.00 1.00 1.00 0.00 0.00 0.00 2.00 3.00 4.00 5.00 5.00 5.00 5.00
Operational/Handling 4.0 1.00 4.00 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 4.00 4.00 5.00 5.00 5.00 4.00 5.00
Waterfront 0.4 0.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 3.00 4.00 4.00 5.00 5.00 5.00
Royalty Revenue 1.5 4.00 4.00 3.00 4.00 2.00 4.00 2.00 4.00 4.00 2.00 3.00 4.00 4.00 4.00 4.00 3.00 4.00
Railway 0.1 4.00 4.00 3.00 3.00 2.00 4.00 3.00 3.00 3.00 2.00 4.00 3.00 4.00 5.00 5.00 5.00 5.00
SPM 0.9 3.00 3.00 4.00 3.00 2.00 3.00 4.00 5.00 4.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Other Revenue 0.4 4.00 4.00 5.00 4.00 4.00 4.00 4.00 4.00 3.00 4.00 4.00 0.00 4.00 5.00 5.00 5.00 5.00
Total Expenses -
OperatingExpense Handling 3.5 3.00 0.00 3.00 4.00 5.00 4.00 1.00 3.00 1.00 3.00 3.00 1.00 1.00 0.00 1.00 0.00 0.00
Maintenance 0.2 5.00 0.00 0.00 0.00 5.00 5.00 5.00 5.00 5.00 0.00 3.00 0.00 1.00 2.00 1.00 1.00 1.00
Tug Management 0.1 4.00 1.00 4.00 4.00 4.00 4.00 4.00 3.00 3.00 4.00 3.00 3.00 2.00 0.00 2.00 2.00 1.00
Contractual Manpower 0.7 4.00 2.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 3.00 4.00 0.00 4.00 2.00 2.00 2.00
Waterfront Royalty 1.6 5.00 1.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 3.00 4.00 1.00 0.00 1.00 2.00 1.00
R&M 1.1 5.00 5.00 5.00 5.00 3.00 4.00 5.00 2.00 4.00 0.00 3.00 5.00 5.00 5.00 5.00 5.00 5.00
Electricity 0.4 5.00 1.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 3.00 1.00 2.00 0.00 1.00 0.00 1.00
Fuel 0.6 0.00 0.00 0.00 1.00 0.00 0.00 0.00 1.00 2.00 0.00 3.00 1.00 0.00 0.00 0.00 0.00 0.00
Personnel Expense Personnel Expense 0.8 4.00 0.00 4.00 2.00 4.00 1.00 4.00 4.00 4.00 4.00 4.00 5.00 0.00 2.00 0.00 0.00 0.00
Administrative Expense Insurance 0.1 4.00 1.00 5.00 5.00 0.00 5.00 1.00 2.00 5.00 5.00 0.00 5.00 1.00 4.00 3.00 2.00 2.00
Legal and Professional fees 0.1 4.00 4.00 3.00 5.00 5.00 1.00 5.00 5.00 3.00 5.00 0.00 5.00 4.00 5.00 5.00 5.00 5.00
Travelling 0.0 4.00 5.00 5.00 2.00 5.00 3.00 5.00 4.00 4.00 5.00 0.00 5.00 5.00 5.00 2.00 0.00 0.00
Vehicle 0.1 1.00 5.00 0.00 0.00 1.00 2.00 3.00 2.00 0.00 3.00 0.00 2.00 5.00 3.00 3.00 3.00 3.00
Security manpower 0.0 5.00 0.00 4.00 5.00 5.00 5.00 5.00 5.00 4.00 5.00 5.00 5.00 0.00 5.00 5.00 5.00 5.00
IT 0.2 3.00 5.00 0.00 5.00 5.00 0.00 5.00 5.00 4.00 5.00 0.00 5.00 5.00 5.00 5.00 5.00 5.00
Other Administrative 0.4 5.00 4.00 4.00 2.00 5.00 5.00 5.00 5.00 4.00 5.00 0.00 3.00 4.00 5.00 3.00 3.00 3.00
Operations
Vital Stats
Operations Dry 1.39
Liquid 4.00
Container 3.50

VItal Stats
KPI Weight % YTD'21-22 YTD'22-23 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22
Productivity- Variance frombudget -
Dry Fertilizer 2.2 1.00 1.00 4.00 4.00 5.00 5.00 1.00 1.00 1.00 3.00 5.00 1.00 2.00 4.00 2.00 2.00 1.00
Agri 0.7 1.00 1.00 4.00 5.00 5.00 4.00 3.00 1.00 1.00 3.00 4.00 5.00 4.00 2.00 1.00 1.00 1.00
Minerals 1.7 4.00 4.00 4.00 5.00 3.00 4.00 3.00 3.00 1.00 4.00 4.00 2.00 4.00 1.00 1.00 1.00 1.00
Salt 2.0 4.00 3.00 4.00 3.00 4.00 4.00 3.00 3.00 4.00 3.00 4.00 3.00 1.00 4.00 3.00 3.00 3.00
Steel and Projects 0.8 1.00 1.00 4.00 5.00 4.00 5.00 1.00 1.00 1.00 4.00 5.00 1.00 5.00 1.00 2.00 1.00 1.00
Coal 16.5 2.00 1.00 4.00 4.00 4.00 4.00 3.00 1.00 1.00 3.00 4.00 4.00 4.00 2.00 2.00 2.00 2.00
Liquid Chemical 0.9 4.00 4.00 1.00 1.00 2.00 1.00 5.00 4.00 4.00 4.00 1.00 4.00 3.00 3.00 3.00 4.00 4.00
Edible Oil 1.5 4.00 4.00 1.00 1.00 3.00 3.00 4.00 3.00 3.00 3.00 2.00 4.00 4.00 2.00 2.00 3.00 4.00
POL 0.6 4.00 4.00 1.00 1.00 3.00 5.00 1.00 4.00 4.00 3.00 5.00 1.00 3.00 3.00 3.00 4.00 4.00
GCR - Container CT 2 8.3 4.00 3.00 4.00 4.00 4.00 3.00 4.00 2.00 2.00 4.00 2.00 4.00 3.00 3.00 3.00 2.00 4.00
CT 3 8.3 4.00 4.00 4.00 4.00 4.00 2.00 4.00 3.00 3.00 4.00 1.00 4.00 3.00 3.00 2.00 3.00 3.00
CT 4 8.3 4.00 4.00 4.00 4.00 4.00 4.00 4.00 3.00 3.00 3.00 3.00 3.00 4.00 1.00 2.00 2.00 3.00
T2 8.3 4.00 3.00 4.00 4.00 4.00 4.00 4.00 2.00 2.00 4.00 3.00 3.00 4.00 2.00 3.00 3.00 2.00
Dispatch - 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Roadway Truck TAT 10.0 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Railway Rail TAT 7.5 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Loadability 6.8 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Demurrage per ton 0.8 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Rejection 0.0 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Equipment Availability Crane 1.5 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
RTG 3.0 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Other 0.5 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Vessel TAT 5.0 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Dwell Time 5.0 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00

You might also like