target 2015 setting.xlsx

Upload: romuloblc

Post on 02-Jun-2018

216 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/10/2019 Target 2015 setting.xlsx

    1/314

    Q3 RQF and 2015 Target Setting TimelinesDeliverable DeadlineAssumptions will be shared with terminals 4-Sep

    RQF Entity sign off (RoY 2014, FY 2015, Q1 2016) 11-Sep

    Regions will submit RQF to the Hague 16-Sep

    Entities will submit current state analysis to the PMO 23-Sep

    Entities will provide AOP and 2015 target proposals to Regional

    Finance by submission of Target Setting Template

    30-Sep

    Entities will present their target proposals in Hermes4cast (same

    chart of accounts as Forecast, hence more detail than last year) -

    Hermes4cast target open for input 16th September

    30-Sep

    Regions will submit 2015 Target proposal to the Hague (SR, EP) 10-Oct

    Final 2015 Targets are communicated to Regions 23-Oct

    Entities will sign off agreed Targets in Hermes4cast 6-Nov

    Regions will sign off agreed Targets in Hermes4cast 20-Nov

    Introduction:

    To leverage target discussion and create mutual commitment between functions

    and terminals, mature markets terminals and functions will produce an Annual

    Operating Plan (AOP), consolidated into one mature market AOP. The AOP is

    integrated to the target setting process and supports its purpose.

  • 8/10/2019 Target 2015 setting.xlsx

    2/314

    Throughout the file following colour coding is used to identify input and automatic cells

    Input cells

    Automatic cells

    Throughout the file following colours are used for the tab to identify the Owners of the Tab Sheets

    OPS (incl. TAM)

    PROC

    FIN

    COM

    BPM

    HSSE

    IT

    BPM

    ALL

    This Operating & Target Plan 2015 file is intended to track and measure all initiatives that are contemplated by entities for 2015. It is also

    understanding the difference between the actual/forecasted 2014 result and what is targeted for 2015 (tab 2014RQF_2015Target). The follo

    of how to record different initiatives:

    a) Initiative is in the pipeline but it is far from certain and it has not been included in either the 2015 forecast nor the 2015 target. Then record the initiative but indicate bridge category: Contingency initiatives

    If an RQF initiative doesn't materialize, then you should have a Plan B initiative (e.g. if I don't land this customer, I'll close the gate early every d

    Then record the initiative but indicate bridge category: Contingency (Plan B) initiatives

    b) Initiative is in the pipeline and there is a reasonable chance of success (30-40%) and can be considered to be a fair stretch and is excluded in

    Then record the initiative as stretched initiative incl. in target, but not in RQF.

    c) An initiative commenced in 2014 and will continue throughout 2015.

    Then record the initiative as carry over (because it is certain) and indicate the start month as being January and the end month being the m

    in 2014 (in this way we capture only the difference between 2015 and 2014). E.g initiative saves 100k each month, was started in September 2

    record as the difference in 2015 vs. 2014 as being the 100k we expect to save per month Jan Aug 2015 which is 800k.

    d) An initiative is expected to commence in 2015 and included in the RQF figures

    Include the initiative as RQF 2015 initiative.

    e) Cost avoidance is appreciated, but shouldn't be included in the Financial Initiatives file.

    InstructionsA3

    For instructions on the A3, pls refer to tab 'Instructions A3'. Main purpose is to get an overview incl. resource planning.

    IT

    An overview of all IT projects with a short description, scope and objectives including budget, expected start and finish date, approval (current

    2015 / to run into 2015 - lists produced from the IT tool Daptiv which includes resource planning - unless there are IT projects not captured in

    the IT sheet).

    Patrick Mast - Global IT will present at the Mature Markets Regional Finance Manager's Meeting to ensure the CFOs are aware of the Global IT

    they get addressed properly in their AOP

    HSSE

    The global HSSE strategy with our top 5 safety risks. From here a terminal specific HSSE AOP is to be derived. More detailed instructions are in

    2014RQF_2015Target

    Summary Bridge from FYE 2014 to FY Forecast 2015 to FY Target 2015

    Smartview Retrieve

    P&L of 2015 FYE and 2015 Target directly retrieved via Smartview from the financial system HFM.

    Financial Initiatives list Tab:

    Initiatives from the various input sheets: Commercial, Operational and Procurement plans etc. are automatically linked to the consolidated Fin

    Pivot table displays the summary of all initiatives -> Pls refresh the pivot table after you have finalized your input.

    HFM Entity Code (Column H)

    Name (Column I)

    Region (Column J)

    Initiative (Column K) A description of your initiative

    Initiative Type (Column L) Commercial, OPS, TAM, Procurement, OtherTCO, ETC or productivity (Column M)

    Category(Column N) If your initiative does not fit in the pre-described categories here, use "Other". Some examples of Other are Bad Debt

  • 8/10/2019 Target 2015 setting.xlsx

    3/314

    Entity Algeciras

    HFM Code ES002E

    Actuals July

    Latest Forecast June

  • 8/10/2019 Target 2015 setting.xlsx

    4/314

  • 8/10/2019 Target 2015 setting.xlsx

    5/314

    A3 Owner

    Fun ct ion Ob jec t ive In i t ia

    Th is Year 's Operat ing Plan and Mile

    Select the strategic objectivefrom the dropdown

    This section should contain the strategic

    What specific actions do weour strategy, and deliver the

    for

    Focus on actions that are ametric and t

    Use actionable statementsthe target value for each ac

    are much better than just

    Person responsible for owning and driving thestrategy (deployment leader) - COOs

    Selection a functionalarea from the drop

    down

  • 8/10/2019 Target 2015 setting.xlsx

    6/314

  • 8/10/2019 Target 2015 setting.xlsx

    7/314

    Current IT projects scheduled for 2015 / to run into 2015 - lists produced from t

    Full list of IT projects for Mature Markets:

    Mature Markets ITProject Portfolio -

    20140725 -

  • 8/10/2019 Target 2015 setting.xlsx

    8/314

    he IT tool Daptiv which includes resource planning - unless there are IT projects not

  • 8/10/2019 Target 2015 setting.xlsx

    9/314

    aptured in Daptiv, below information should be complete:

  • 8/10/2019 Target 2015 setting.xlsx

    10/314

    HFM Entity Code ES002E

    Entity Name Algeciras

    Currency EUR

    EBITDA Local Currency '000

    FYE 2014 (Financial Baseline) 15,150

    Carry over Effect 2014 2,500

    Organic Growth 250

    Labor increase per master contract (750)

    CPI 5% (500)

    Adjusted Baseline 16,650

    Increase in market share 550

    New business 400

    Fuel savings 300

    Equipment rental savings 200Utility Savings 150

    Legal Fee savings 100

    2015 Full Year Forecast 18,350

    CHECK 2,647

    Secure CMA 2,500

    Crane OCR (eliminate 2 clerks on vessel OPS) 100

    Solid tires for reachstackers 50

    No back fill of various BC positions 25

    Reefer volume increase 250

    Fuel savings 150Equipment rental savings 125

    Insurance savings 75

    2015 Full Year Target EBITDA 21,625

    CHECK (21,625)

    Change in depreciation

    Sale of Fixed Assets

    Segment Tax

    2015 Full Year Target SR 21,625

    CHECK (21,625)

  • 8/10/2019 Target 2015 setting.xlsx

    11/314

    USD '000

    20,303

    3,250

    325

    (975)

    (650)

    22,253

    715

    520

    390

    260 195

    130

    24,463

    2,834

    3,250

    130

    65

    33

    325

    195163

    98

    28,720

    (28,720)

    -

    -

    -

    28,720

    (28,720)

    Commen

  • 8/10/2019 Target 2015 setting.xlsx

    12/314

  • 8/10/2019 Target 2015 setting.xlsx

    13/314

    Row Labels

    Carryover Effect

    Contingency Initiative

    GMPHbridgeRQF 2015 Initiative

    Stretched Target Initiative

    Grand Total

  • 8/10/2019 Target 2015 setting.xlsx

    14/314

    (Multiple Items)

    Sum of FY 2015 EBITDA Impact USD '000

    15,470

    15,470

    9,100

    0

    0

    1,365

    5,005

    0

    18,624

    10,675

    534

    632

    9,509

    368

    130

    238

    0

    6220

    12

    31

    0

    41

    41

    7,477

    7,477

    34,094

  • 8/10/2019 Target 2015 setting.xlsx

    15/314

    Sum of FY 2015 EBITDA Impact USD '000

    0

    9,360

    6,060

    07,370

    17,365

    40,155

  • 8/10/2019 Target 2015 setting.xlsx

    16/314

    Sum of FY 2015 Segment Result Impact USD '000

    10,829

    10,829

    6,370

    0

    0

    956

    3,504

    0

    13,037

    7,472

    374

    442

    6,656

    258

    91

    167

    0

    4414

    8

    22

    0

    29

    29

    5,234

    5,234

    23,866

  • 8/10/2019 Target 2015 setting.xlsx

    17/314

    Sum of FY 2015 Segment Result Impact USD '000

    0

    6,552

    4,242

    05,159

    12,155

    28,108

  • 8/10/2019 Target 2015 setting.xlsx

    18/314

    APM Terminals Mature Markets COO Fin

    Item Entity

    HFM

    Code

    Entity

    Name

    Region

    1 ES002E Algeciras Mature Markets

    2 ES002E Algeciras Mature Markets

    3 ES002E Algeciras Mature Markets

    4 ES002E Algeciras Mature Markets

    5 ES002E Algeciras Mature Markets

    6 ES002E Algeciras Mature Markets

    7 ES002E Algeciras Mature Markets

    8 ES002E Algeciras Mature Markets

    9 ES002E Algeciras Mature Markets

    10 ES002E Algeciras Mature Markets

    11 ES002E Algeciras Mature Markets

    12 ES002E Algeciras Mature Markets

    13 ES002E Algeciras Mature Markets

    14 ES002E Algeciras Mature Markets

    15 ES002E Algeciras Mature Markets

    16 ES002E Algeciras Mature Markets

    17 ES002E Algeciras Mature Markets

    18 ES002E Algeciras Mature Markets19 ES002E Algeciras Mature Markets

    20 ES002E Algeciras Mature Markets

    21 ES002E Algeciras Mature Markets

    22 ES002E Algeciras Mature Markets

    23 ES002E Algeciras Mature Markets

    24 ES002E Algeciras Mature Markets

    25 ES002E Algeciras Mature Markets

    26 ES002E Algeciras Mature Markets

    27 ES002E Algeciras Mature Markets

    28 ES002E Algeciras Mature Markets

    29 ES002E Algeciras Mature Markets

    30 ES002E Algeciras Mature Markets

    31 ES002E Algeciras Mature Markets32 ES002E Algeciras Mature Markets

    33 ES002E Algeciras Mature Markets

    34 ES002E Algeciras Mature Markets

    35 ES002E Algeciras Mature Markets

    36 ES002E Algeciras Mature Markets

    37 ES002E Algeciras Mature Markets

    38 ES002E Algeciras Mature Markets

    39 ES002E Algeciras Mature Markets

    40 ES002E Algeciras Mature Markets

  • 8/10/2019 Target 2015 setting.xlsx

    19/314

    41 ES002E Algeciras Mature Markets

    42 ES002E Algeciras Mature Markets

    43 ES002E Algeciras Mature Markets

    44 ES002E Algeciras Mature Markets

    45 ES002E Algeciras Mature Markets

    46 ES002E Algeciras Mature Markets

    47 ES002E Algeciras Mature Markets

    48 ES002E Algeciras Mature Markets

    49 ES002E Algeciras Mature Markets50 ES002E Algeciras Mature Markets

    51 ES002E Algeciras Mature Markets

    52 ES002E Algeciras Mature Markets

    53 ES002E Algeciras Mature Markets

    54 ES002E Algeciras Mature Markets

    55 ES002E Algeciras Mature Markets

    56 ES002E Algeciras Mature Markets

    57 ES002E Algeciras Mature Markets

    58 ES002E Algeciras Mature Markets

    59 ES002E Algeciras Mature Markets

    60 ES002E Algeciras Mature Markets

    61 ES002E Algeciras Mature Markets

    62 ES002E Algeciras Mature Markets

    63 ES002E Algeciras Mature Markets

    64 ES002E Algeciras Mature Markets

    65

    66

    67

  • 8/10/2019 Target 2015 setting.xlsx

    20/314

    ancial Initiatives 2015

    Initiative Initiative

    Type

    TCO,

    Productivity

    or ETC

    CHE Operations TCO

    CHE Operations TCO

    CHE Operations TCO

    CHE Operations TCO

    Fuel Operations TCO

    Fuel Operations TCO

    Fuel Operations TCO

    Fuel Operations TCO

    ManHrs Operations TCO

    ManHrs Operations TCO

    ManHrs Operations TCO

    ManHrs Operations TCO

    Vertical Tandem Lifts Operations Productivity

    Discharge Back Reach Operations Productivity

    Pooling of UTR's "PrimeRoute" Operations Productivity

    Coning Stations Operations Productivity

    Secure Cosco/EVG Commercial ETC

    MOL Commercial ETCSecure 2M volume and negotiate MSC rates Commercial ETC

    APL Commercial ETC

    Secure MSC rate increase Commercial ETC

    Secure CMA rate increase Commercial ETC

    Secure Zim rate increase Commercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETCCommercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETC

    Commercial ETC

    Renegotiate concession agreement OtherInitiatives TCO

    Reconfigure Maersk.net connection OtherInitiatives TCO

    Evaluate and renegotiate contracts (Legal, Consultants) OtherInitiatives TCO

    OtherInitiatives TCO

  • 8/10/2019 Target 2015 setting.xlsx

    21/314

    OtherInitiatives TCO

    OtherInitiatives TCO

    OtherInitiatives TCO

    OtherInitiatives TCO

    OtherInitiatives TCO

    OtherInitiatives TCO

    Renegotiating legal contract Procurement TCO

    Salt for winter days Procurement TCO

    Potential rental of 2 reachstackers Procurement TCOProcurement TCO

    Procurement TCO

    Procurement TCO

    Procurement TCO

    Procurement TCO

    Procurement TCO

    Procurement TCO

    Availability TAMavailability TCO

    Availability TAMavailability TCO

    Availability TAMavailability TCO

    Availability TAMavailability TCO

    Availability TAMreliability TCO

    Availability TAMreliability TCO

    Availability TAMreliability TCO

    Availability TAMreliability TCO

  • 8/10/2019 Target 2015 setting.xlsx

    22/314

    Category Bridge Category Savings

    Start

    Month

    Savings

    End

    Month

    Number

    of

    months

    Currency

    Variable Cost Carryover Effect 31-Dec-15 EUR

    Variable Cost RQF 2015 Initiative 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost Stretched Target Initiative 1-Jul-15 31-Dec-15 6 EUR

    Variable Cost Contingency Initiative 1-Jul-15 31-Dec-15 6 EUR

    Variable Cost Carryover Effect 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost RQF 2015 Initiative 1-Feb-15 31-Dec-15 11 EUR

    Variable Cost Stretched Target Initiative 31-Dec-15 EUR

    Variable Cost Contingency Initiative 1-Jul-15 31-Dec-15 6 EUR

    Variable Cost Carryover Effect 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost RQF 2015 Initiative 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost Stretched Target Initiative 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost Contingency Initiative 31-Dec-15 EUR

    GMPHbridge 1-Oct-15 31-Dec-15 GPMH

    GMPHbridge 1-Jun-15 31-Dec-15 GPMH

    GMPHbridge 1-Aug-15 31-Dec-15 GPMH

    GMPHbridge 1-May-15 31-Dec-15 GPMH

    Volume Stretched Target Initiative 1-Jan-15 31-Dec-15 12 EUR

    Volume Stretched Target Initiative 1-Feb-15 31-Dec-15 11 EURVolume Stretched Target Initiative 1-Apr-15 31-Dec-15 9 EUR

    Volume Stretched Target Initiative 1-Jun-15 31-Dec-15 7 EUR

    Tariff Stretched Target Initiative 1-Feb-15 31-Dec-15 11 EUR

    Volume Contingency Initiative 1-Feb-15 31-Dec-15 11 EUR

    Volume Contingency Initiative 1-Feb-15 31-Dec-15 11 EUR

    EUR

    EUR

    EUR

    EUR

    EUR

    EUR

    EUR

    EUREUR

    EUR

    EUR

    EUR

    EUR

    Variable Cost RQF 2015 Initiative 1-Feb-15 31-Jan-16 12 EUR

    Variable Cost Stretched Target Initiative 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost Contingency Initiative 1-Jul-15 30-Jun-16 12 EUR

    EUR

  • 8/10/2019 Target 2015 setting.xlsx

    23/314

    EUR

    EUR

    EUR

    EUR

    EUR

    EUR

    RQF 2015 Initiative 1-Jan-15 30-Sep-15 9 EUR

    RQF 2015 Initiative 1-Jan-15 31-Dec-15 12 EUR

    RQF 2015 Initiative 1-Mar-15 31-Dec-15 10 EUREUR

    EUR

    EUR

    EUR

    EUR

    EUR

    EUR

    Variable Cost Carryover Effect 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost RQF 2015 Initiative 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost Stretched Target Initiative 31-Dec-15 EUR

    Variable Cost Contingency Initiative 31-Dec-15 EUR

    Variable Cost Carryover Effect 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost RQF 2015 Initiative 1-Jan-15 31-Dec-15 12 EUR

    Variable Cost Stretched Target Initiative 31-Dec-15 EUR

    Variable Cost Contingency Initiative 31-Dec-15 EUR

    1

    1

    1

  • 8/10/2019 Target 2015 setting.xlsx

    24/314

    1-Jan-15

    FY 2015 EBITDA

    Impact (Local

    Currency '000) /

    GMPH impact forproductivity.

    Impact should be

    cost difference

    with your FY 2014

    figure

    FY 2015

    EBITDA

    Impact USD

    '000

    Entity

    Tax Rate

    FY 2015

    Segment

    Result Impact

    (LocalCurrency '000)

    FY 2015

    Segment

    Result

    Impact USD'000

    January

    2015

    Target

    EBITDASavings

    Local

    Currency

    '000

    - - 30% - - -

    303 395 30% 212 276 8

    107 139 30% 75 98 -

    105 137 30% 74 96 -

    65 84 30% 45 59 14

    421 548 30% 295 383 -

    - - 30% - - -

    92 119 30% 64 84 -

    4,376 5,689 30% 3,063 3,982 188

    1,688 2,194 30% 1,182 1,536 188

    1,313 1,707 30% 919 1,195 63

    - - 30% - - -

    30% -

    30% -

    30% -

    30% -

    1,050 1,365 30% 735 956 -

    - - 30% - - -- - 30% - - -

    7,000 9,100 30% 4,900 6,370 -

    3,850 5,005 30% 2,695 3,504 -

    3,080 4,004 30% 2,156 2,803 -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -- - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    183 238 30% 128 167

    100 130 30% 70 91 8

    43 55 30% 30 39

    - - 30% - -

  • 8/10/2019 Target 2015 setting.xlsx

    25/314

    - - 30% - -

    - - 30% - -

    - - 30% - -

    - - 30% - -

    - - 30% - -

    - - 30% - -

    9 12 30% 6 8 1

    24 31 30% 17 22 2

    15 20 30% 11 14 -- - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    - - 30% - - -

    8 10 30% 6 7 0

    24 31 30% 17 22 1

    - - 30% - - -

    - - 30% - - -

    2,751 3,576 30% 1,926 2,503 125

    3,001 3,901 30% 2,101 2,731 188

    - - 30% - - -

    - - 30% - - -

    -

    -

    -

  • 8/10/2019 Target 2015 setting.xlsx

    26/314

    1-Feb-15 1-Mar-15 1-Apr-15 1-May-15 1-Jun-15 1-Jul-15

    February

    2015

    Target

    EBITDASavings

    Local

    Currency

    '000

    March

    2015

    Target

    EBITDASavings

    Local

    Currency

    '000

    April Target

    2015

    EBITDA

    SavingsLocal

    Currency

    '000

    May Target

    2015

    EBITDA

    SavingsLocal

    Currency

    '000

    June Target

    2015

    EBITDA

    SavingsLocal

    Currency

    '000

    July Target

    2015

    EBITDA

    SavingsLocal

    Currency

    '000

    - - - - - -

    8 8 20 20 24 32

    - - - - - 6

    - - - - - 2

    14 14 14 11 - -

    14 14 24 32 41 41

    - - - - - -

    - - - - - 5

    188 250 375 375 375 500

    188 - 63 63 125 125

    63 63 63 63 63 63

    - - - - - -

    - - - - 150 150

    - - - - - -- - - - - -

    - - - - 1,000 1,000

    350 350 350 350 350 350

    280 280 280 280 280 280

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -- - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    17 17 17 17 17 17

    8 8 8 8 8 8

    7

  • 8/10/2019 Target 2015 setting.xlsx

    27/314

    1 1 1 1 1 1

    2 2 2 2 2 2

    - 2 2 2 2 2- - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    0 1 1 1 1 1

    1 1 1 1 2 2

    - - - - - -

    - - - - - -

    125 250 250 250 250 250

    188 188 188 188 250 250

    - - - - - -

    - - - - - -

  • 8/10/2019 Target 2015 setting.xlsx

    28/314

    1-Aug-15 1-Sep-15 1-Oct-15 1-Nov-15 1-Dec-15

    August

    Target

    2015

    EBITDASavings

    Local

    Currency

    '000

    September

    Target 2015

    EBITDA

    SavingsLocal

    Currency

    '000

    October

    Target

    2015

    EBITDASavings

    Local

    Currency

    '000

    November

    Target

    2015

    EBITDASavings

    Local

    Currency

    '000

    December

    Target

    2015

    EBITDASavings

    Local

    Currency

    '000

    Included

    in 2015

    Target?

    - - - - - Y

    36 36 36 36 36 Y

    12 22 22 22 22 Y

    4 17 27 27 27 N

    - - - - - Y

    51 51 51 51 51 Y

    - - - - - Y

    11 19 19 19 19 N

    500 500 375 375 375 Y

    188 188 188 188 188 Y

    125 188 188 188 188 Y

    - - - - - N

    Y

    Y

    Y

    Y

    150 150 150 150 150 Y

    - - - - - Y- - - - - Y

    1,000 1,000 1,000 1,000 1,000 Y

    350 350 350 350 350 Y

    280 280 280 280 280 N

    - - - - - N

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -- - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    17 17 17 17 17 Y

    8 8 8 8 8 Y

    7 7 7 7 7 N

  • 8/10/2019 Target 2015 setting.xlsx

    29/314

    1 1 - - - Y

    2 2 2 2 2 Y

    2 2 2 2 2 Y- - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    1 1 - - - Y

    2 2 2 2 2 Y

    - - - - - Y

    - - - - - N

    250 250 250 250 250 Y

    313 313 313 313 313 Y

    - - - - - Y

    - - - - - N

  • 8/10/2019 Target 2015 setting.xlsx

    30/314

    Included

    in this

    Forecast?

    Status Responsible

    Person

    Y

    Y

    N

    N

    Y

    Y

    N

    N

    Y

    Y

    N

    N

    N

    N

    N

    N

    N In progress JRG

    N In progress JRGN In progress TD/GF

    N In progress JRG

    N Not Started ABC

    N Not Started BCD

    N Not Started DEF

    Y

    N

    N

  • 8/10/2019 Target 2015 setting.xlsx

    31/314

    Y

    Y

    Y

    Y

    Y

    N

    N

    Y

    Y

    N

    N

  • 8/10/2019 Target 2015 setting.xlsx

    32/314

    Comments

  • 8/10/2019 Target 2015 setting.xlsx

    33/314

  • 8/10/2019 Target 2015 setting.xlsx

    34/314

  • 8/10/2019 Target 2015 setting.xlsx

    35/314

    11560Tat Total Port Equipment Repair & Maintenance Costs (ER (25,733)

    11570at Port Variable Labour Costs -

    11590Tat Total Port Services Variable Costs (35,241)

    11490Tat Total Inland Services Variable Costs -

    11600Tat Total Variable Costs (35,241)

    11810at Fixed Concession Fees, Land Lease etc -

    11820at IFRIC 12 Construction Cost -11830at Civil Works Repair & Maintenance Costs -

    11841at White Collar Fixed Labour Costs (15,165)

    11845Tat Fixed Blue Collar Labour Cost (128,181)

    11850Tat Total Fixed Labour Costs (143,346)

    11851at Other Fixed Costs Internal (2,458)

    11852at Other Fixed operating lease expenses, external (3,083)

    11855at Management fee expenses, external -

    11860Tat Total Other Fixed Costs (5,541)

    11880Tat Total Fixed Administrative and Overhead Costs (4,184)

    11900Tat Total Fixed Costs (153,070)13100at Integration and restructuring cost -

    14900Tat Profit before depreciation, etc. (EBITDA) 18,729

    15100Cat Depreciation, amortisation & impairment (12,438)

    15200Cat Associates - share of profit/loss after tax -

    16500at Gains/losses on sale of assets & businesses 784

    16900Tat Profit before financial items (EBIT) 7,076

    17110at Financial items, extrernal 265

    17119at Financial items, intrernal (1,794)17800Tat Financial items, net (1,530)

    18010at Current income tax (2,216)

    18310at Other income tax 552

    18800Tat Tax expenses/income (1,664)

    18900Tat Profit/loss for period 3,882

    ETR (Total EBT) -30%

    ETR on EBIT -30%

    70130 Tax related to financial items 45970110C Tax on EBIT (2,123)

    50100T Segment result 4,953

  • 8/10/2019 Target 2015 setting.xlsx

    36/314

    APM Terminals

    Algeciras S.A.

    APM Terminals

    Algeciras S.A.

    APM Terminals

    Algeciras S.A.

    APM Terminals

    Algeciras S.A.

    APM Terminals

    Algeciras S.A.

    Local Currency

    '000

    Local Currency

    '000

    Local Currency

    '000

    USD '000 USD '000

    FYE 2015 Target 2015 FYE 2014 FYE 2015 Target 2015

    - - - - -

    217,153 - 276,053 282,299 -

    - - - - -

    217,153 - 276,053 282,299 -

    - - - - -

    - - - - -

    - - - - -- - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    217,153 - 276,053 282,299 -

    - - - - -

    351 - 273 457 -

    - - - - -

    - - - - -

    351 - 273 457 -

    217,504 - 276,326 282,756 -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    (5,924) - (7,593) (7,701) -

    (4,164) - (5,096) (5,414) -

    (10,088) - (12,689) (13,115) -

    - - - - -

    (25,855) - (34,342) (33,611) -

  • 8/10/2019 Target 2015 setting.xlsx

    37/314

    (25,855) - (34,342) (33,611) -

    - - - - -

    (35,943) - (47,031) (46,726) -

    - - - - -

    (35,943) - (47,031) (46,726) -

    - - - - -

    - - - - -- - - - -

    (16,053) - (20,240) (20,869) -

    (135,348) - (171,143) (175,952) -

    (151,401) - (191,382) (196,821) -

    (2,504) - (3,372) (3,255) -

    (3,915) - (4,088) (5,090) -

    - - - - -

    (6,419) - (7,460) (8,345) -

    (2,743) - (5,631) (3,566) -

    (160,564) - (204,474) (208,733) -- - - - -

    20,998 - 24,821 27,297 -

    (14,232) - (16,583) (18,501) -

    - - - - -

    - - 1,075 - -

    6,766 - 9,312 8,795 -

    (862) - 367 (1,121) -

    (1,786) - (2,462) (2,322) -(2,648) - (2,094) (3,443) -

    (1,235) - (2,970) (1,606) -

    - - 757 - -

    (1,235) - (2,212) (1,606) -

    2,882 - 5,006 3,747 -

    -30% #DIV/0! -31% -30% #DIV/0!

    -30% #DIV/0! -30% -30% #DIV/0!

    794 - 609 1,033 -(2,030) - (2,821) (2,639) -

    4,736 - 6,491 6,157 -

  • 8/10/2019 Target 2015 setting.xlsx

    38/314

    Y/N

    N

    Y

    N

    Y

    N

    N

    NN

    N

    N

    N

    N

    N

    N

    N

    Y

    N

    Y

    N

    N

    Y

    Y

    N

    N

    N

    N

    N

    N

    N

    N

    Y

    Y

    Y

    N

    Y

  • 8/10/2019 Target 2015 setting.xlsx

    39/314

    Y

    N

    Y

    N

    Y

    N

    NN

    Y

    Y

    Y

    Y

    Y

    N

    Y

    Y

    YN

    Y

    N

    Y

    N

    Y

    Y

    N

    Y

    YY

    Y

    Y

    Y

    Y

    YY

    Y

  • 8/10/2019 Target 2015 setting.xlsx

    40/314

    Local currency '000

    Upsides

    Effects from P3 ( higher third party volumes / not affecting total volume)

    Lower Inactivity expenses due to 100 k moves over expectations

    TOTAL

    Downsides

    2012 TTIA CLAIM.

    TTIA Volume Reduction(100 k) / Higher fixed expenses from Stevedoring company

    Higher Inactivity expenses if TTIA Volume Reduction (100 k)

    Lease of Land cost reduction

    Subsidy Triple E subsidy (depreciation)

    Claim & Litigios expenses reduction project

    Other operational initiatives

  • 8/10/2019 Target 2015 setting.xlsx

    41/314

    Total

    Net Impact

  • 8/10/2019 Target 2015 setting.xlsx

    42/314

    Entity Name Group Category

    ES002E Algeciras Mature Markets Revenue - Other

    ES002E Algeciras Mature Markets Fixed Cost

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature MarketsES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature MarketsES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    Entity Name Group Category

    ES002E Algeciras Mature Markets Fixed Cost

    ES002E Algeciras Mature Markets Fixed Cost

    ES002E Algeciras Mature Markets Fixed Cost

    ES002E Algeciras Mature Markets Fixed Cost

    ES002E Algeciras Mature Markets Other

    ES002E Algeciras Mature Markets Fixed Cost

    ES002E Algeciras Mature Markets Variable Cost

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

  • 8/10/2019 Target 2015 setting.xlsx

    43/314

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E Algeciras Mature Markets

    ES002E

    150 12,981

  • 8/10/2019 Target 2015 setting.xlsx

    44/314

    Volume (TEU's) EBITDA Entity Tax Rate Segment

    - 7,972 30% 5,580

    150 500 30% 350

    30% -

    30% -

    30% -30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    150 8,472 8,472

    Volume (TEU's) EBITDA Entity Tax Rate Segment

    1,300 30% 910

    990 30% 693

    500 30% 350

    307 30% 215

    150 30% 105

    262 30% 183

    1,000 30% 700

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

    30% -

  • 8/10/2019 Target 2015 setting.xlsx

    45/314

    30% -

    30% -

    30% -

    30% -

    30% -

    - 4,509 0 3,156

    11,628 - 38 3,245

  • 8/10/2019 Target 2015 setting.xlsx

    46/314

    Probability

    (25/50/75%)

    Volume (TEU's)

    Impact

    EBITDA

    Impact

    Segment

    Impact

    25% - 1,993 1,395

    25% 38 125 88

    - - -

    - - -

    - - --

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -- - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    38 2,118 1,483

    Probability

    (25/50/75%)

    Volume (TEU's)

    Impact

    EBITDA

    Impact

    Segment

    Impact

    25% - 325 228

    25% - 248 173

    25% - 125 88

    25% - 77 54

    25% - 38 26

    25% - 66 46

    25% - 250 175

    - - -

    -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

  • 8/10/2019 Target 2015 setting.xlsx

    47/314

    - - -

    - - -

    - - -

    - - -

    - - -

    - - 1,127 789

    2,272

  • 8/10/2019 Target 2015 setting.xlsx

    48/314

    Excess Assets

    USD

    1,000Asset Type Asset Description

    4 20 Tractors20 Kalmar Tractors and 10 Fabrisem Trailers

    replacement

    12 Forklift Kalmar Forklift-T34108.0579

    14 Forklifts 4 Forklift trucks, not operational

    16 Terminal tractor Terminal Tractor-306148

    17 Terminal tractor Terminal Tractor-310982

    18 Terminal tractor Terminal Tractor-310983

    19 Terminal tractor Terminal Tractor-310991

    20 Terminal tractor Terminal Tractor-311004

    21 Terminal tractor Terminal Tractor-311006

    22 Terminal tractor Terminal Tractor-311009

    28 Pick Up Trucks 20 Used Pick Up Trucks, used on terminal

    31 Tire Jack Operation supporting equipment

    32 Manlift 1 man lift, not safe to operate

    34 Toploader 1 Toploader, not operational

    35 STS Crane Quay Crane K5

    Add new assets to the list which you are no

    review assets below and update when they

  • 8/10/2019 Target 2015 setting.xlsx

    49/314

    16

    17

    18

    19

    20

    21

    22

    2324

    25

    26

    27

    28

    29

    30

    31

    32

    33

    34

    35

    36

    37

    38

    39

    40

    41

    42

    43

    44

    45

    4647

    48

    49

    50

    51

    52

    53

    54

    55

    56

  • 8/10/2019 Target 2015 setting.xlsx

    50/314

    # of assets

    Asset

    Depreciation

    %

    Is asset

    operational?

    Entity

    Code

    30 90% Partially MA010L

    1 100% Yes US005UT

    4 100% No US002UP

    1 100% No US005UT

    1 100% No US005UT

    1 100% No US005UT

    1 100% No US005UT

    1 100% No US005UT

    1 100% No US005UT

    1 100% No US005UT

    20 100% US002UP

    1 100% US005UL

    1 100% US002UP

    1 100% No US002UP

    1 100% No SE031L

    t using anymore and which should be scrapped or so

    will be sold.

  • 8/10/2019 Target 2015 setting.xlsx

    51/314

  • 8/10/2019 Target 2015 setting.xlsx

    52/314

    Entity DescriptionActivity

    Type

    APM Terminals Tangier S.A. Port

    APM Terminals Pacific Ltd. Tacoma Port

    Universal Maritime Serv Corp Port

    ElizabethPort

    APM Terminals Pacific Ltd. Tacoma Port

    APM Terminals Pacific Ltd. Tacoma Port

    APM Terminals Pacific Ltd. Tacoma Port

    APM Terminals Pacific Ltd. Tacoma Port

    APM Terminals Pacific Ltd. Tacoma Port

    APM Terminals Pacific Ltd. Tacoma Port

    APM Terminals Pacific Ltd. Tacoma Port

    Universal Maritime Serv Corp Port

    ElizabethPort

    APM Terminals Pacific Ltd. Los Angeles Port

    Universal Maritime Serv Corp Port

    ElizabethPort

    Universal Maritime Serv Corp Port

    ElizabethPort

    APM Terminals Gothenburg AB Port

    ld, so that available funds can be re-inv

  • 8/10/2019 Target 2015 setting.xlsx

    53/314

  • 8/10/2019 Target 2015 setting.xlsx

    54/314

    Location Region

    APMT

    Ownership

    share

    Morocco COO_AT 90

    Tacoma COO_AT 100

    Elizabeth COO_AT 100

    Tacoma COO_AT 100

    Tacoma COO_AT 100

    Tacoma COO_AT 100

    Tacoma COO_AT 100

    Tacoma COO_AT 100

    Tacoma COO_AT 100

    Tacoma COO_AT 100

    Elizabeth COO_AT 100

    LSA COO_AT 100

    Elizabeth COO_AT 100

    Elizabeth COO_AT 100

    Sweden COO_AT 100

  • 8/10/2019 Target 2015 setting.xlsx

    55/314

  • 8/10/2019 Target 2015 setting.xlsx

    56/314

    Company

    Type1Company Type

    Size (m2)

    (For land)

    Cost Price

    (100%)

    Estimated

    Book Values

    (100%)

    (USD '000)

    3 Subsidiary 1,960 17.7

    3 Subsidiary 94 0.0

    3 Subsidiary 328 0.0

    3 Subsidiary 64 0.0

    3 Subsidiary 69 0.0

    3 Subsidiary 69 0.0

    3 Subsidiary 69 0.0

    3 Subsidiary 69 0.0

    3 Subsidiary 69 0.0

    3 Subsidiary 69 0.0

    3 Subsidiary 99 0

    3 Subsidiary 0

    3 Subsidiary 36 0

    3 Subsidiary

    3 Subsidiary

  • 8/10/2019 Target 2015 setting.xlsx

    57/314

  • 8/10/2019 Target 2015 setting.xlsx

    58/314

    Estimated

    Market Value

    (100%)

    (USD '000)

    Estimated

    time to conclude

    Estimated

    probability

    for success

    Responsible

    person

    Unknown 31-Dec-14 25% Jan Binderup

    60.0 30-Mar-14 100% Jason W Anderson

    25.0 30-Mar-14 75% Frank Rosenbaum

    15.0 30-Mar-15 100% Jason W Anderson

    15.0 30-Mar-15 100% Jason W Anderson

    15.0 30-Mar-15 100% Jason W Anderson

    15.0 30-Mar-15 100% Jason W Anderson

    15.0 30-Mar-15 100% Jason W Anderson

    15.0 30-Mar-15 100% Jason W Anderson

    15.0 30-Mar-15 100% Jason W Anderson

    2 30-Jun-14 75% Frank Rosenbaum

    1 31-Oct-13 50% M. Darling

    0 30-Sep-14 100% Frank Rosenbaum

    30-Jun-14 Frank Rosenbaum

    154 31-Oct-14 50%Kristina Lindstrom-

    Spjuth

  • 8/10/2019 Target 2015 setting.xlsx

    59/314

  • 8/10/2019 Target 2015 setting.xlsx

    60/314

    Status

    (traffic light)

    Realised sales

    proceeds

    included in

    forecast (USD

    '000)

  • 8/10/2019 Target 2015 setting.xlsx

    61/314

  • 8/10/2019 Target 2015 setting.xlsx

    62/314

    Process Status/Next Steps Commen

    t

    Terminal

    We have promoted the trucks for sale through Group

    Procurement and there has been one brief interest with no

    success so far. The information we get is that there are

    several terminal trying to sell used Trucks but currently no

    interested parties. In July 30 items were sold out of the 60.

    This line now is the remaining trucks and trailers

    Regarding the scrap

    Identify buyer

    requires costly major repair, beyond technical lifetime

    Glenn Eddy, advised that this equipment is not for sale at

    this time (e-mail 14 May 2014)

    Glenn Eddy, advised that this equipment is not for sale at

    this time (e-mail 14 May 2014)

    Glenn Eddy, advised that this equipment is not for sale at

    this time (e-mail 14 May 2014)

    Glenn Eddy, advised that this equipment is not for sale at

    this time (e-mail 14 May 2014)

    Glenn Eddy, advised that this equipment is not for sale at

    this time (e-mail 14 May 2014)

    Glenn Eddy, advised that this equipment is not for sale at

    this time (e-mail 14 May 2014)

    Glenn Eddy, advised that this equipment is not for sale at

    this time (e-mail 14 May 2014)

    GT initiative, Pick up trucks are to be withdrawn from

    operation and are likely to be scrapped. All units have been

    bought for less than 5,000USD each and have been

    immediately expensed. "Cost Price" is an estimate

    2 units scrapped in

    searching for buyers

    unsafe to operate Target scrapping for

    Unit is beyond technical lifetime.Requires costly reparirs

    which will not be carried out. No decision on way of

    disposing of unit yet.

  • 8/10/2019 Target 2015 setting.xlsx

    63/314

  • 8/10/2019 Target 2015 setting.xlsx

    64/314

  • 8/10/2019 Target 2015 setting.xlsx

    65/314

  • 8/10/2019 Target 2015 setting.xlsx

    66/314

    preciated by end 2014.

  • 8/10/2019 Target 2015 setting.xlsx

    67/314

    Asset Desciption Quantity Entity Code Name Region

    1 ALIMENTACION POWER SUPLY 1 ES002E Algeciras Mature Market2 OCR SYSTEM IN STS 19 ES002E Algeciras Mature Market

    3 OPERATION BUILDING IMPROVEMENTS 1 ES002E Algeciras Mature Market

    4 EXPERT DECKING VESSELS 1 ES002E Algeciras Mature Market

    5 EXPRESS BILLING MODULE 1 ES002E Algeciras Mature Market

    6 LAYOUT (Navis N4 and other implications, ) 1 ES002E Algeciras Mature Market

    7 SOLAR ENERGY PROJECT 1 ES002E Algeciras Mature Market

    8 SAFETY 1 ES002E Algeciras Mature Market

    9 SECURITY 1 ES002E Algeciras Mature Market

    10 IT 1 ES002E Algeciras Mature Market

    11 EQUIPMENT&MACHINERY 1 ES002E Algeciras Mature Market

    12 TRIPLE E INVESTMENT PROJECT 1 ES002E Algeciras Mature Market

    13 ES002E Algeciras Mature Market

    14 ES002E Algeciras Mature Market

    15 ES002E Algeciras Mature Market16 ES002E Algeciras Mature Market

    17 ES002E Algeciras Mature Market

    18 ES002E Algeciras Mature Market

    19 ES002E Algeciras Mature Market

    20 ES002E Algeciras Mature Market

    21 ES002E Algeciras Mature Market

    22 ES002E Algeciras Mature Market

    23 ES002E Algeciras Mature Market

    24 ES002E Algeciras Mature Market

    25 ES002E Algeciras Mature Market

    26 ES002E Algeciras Mature Market

    27 ES002E Algeciras Mature Market

    28 ES002E Algeciras Mature Market

    29 ES002E Algeciras Mature Market30 ES002E Algeciras Mature Market

    31 ES002E Algeciras Mature Market

    32 ES002E Algeciras Mature Market

    33 ES002E Algeciras Mature Market

    34 ES002E Algeciras Mature Market

    35 ES002E Algeciras Mature Market

    36 ES002E Algeciras Mature Market

    37 ES002E Algeciras Mature Market

    38 ES002E Algeciras Mature Market

    39 ES002E Algeciras Mature Market

    40 ES002E Algeciras Mature Market

    41 ES002E Algeciras Mature Market

    42 ES002E Algeciras Mature Market

    43 ES002E Algeciras Mature Market44 ES002E Algeciras Mature Market

    45 ES002E Algeciras Mature Market

    46 ES002E Algeciras Mature Market

    47 ES002E Algeciras Mature Market

    48 ES002E Algeciras Mature Market

    49 ES002E Algeciras Mature Market

    50 ES002E Algeciras Mature Market

    APM Terminals T15 2014 Asset Investments

  • 8/10/2019 Target 2015 setting.xlsx

    68/314

  • 8/10/2019 Target 2015 setting.xlsx

    69/314

    Status Responsible Person

    ISMAEL BIENVENIDO

    JESUS CACERES

    JESUS CACERES

    JESUS CACERES

    MAR REYES

    JESUS CACERES

    ISMAEL BIENVENIDO

    FCO CAERO

    FCO CAERO

    JESUS CACERES

    ISMAEL BIENVENIDO

    CARLOS GARCIA

  • 8/10/2019 Target 2015 setting.xlsx

    70/314

    Instruction:Free format, pls use your existing risk register and update where

    # Strategic Risks Mitigation Actions

    Offer differentiated value-based propositionsto K-Line and NYK

    Prepare network solution for MSCs ASI-WAF

    trade

    # Strategic Risks Mitigation Actions

    Workshop with customer stowage planners

    Rapid Stack Plan facilitating fast turnaround

    of terminal tractors in all shifts

    # Strategic Risks Mitigation Actions

    E-auctions for consumables

    Evaluate feasibility of servicing of trolley

    motors to increase usage life.

    # Strategic Risks Mitigation Actions

    # Strategic Risks Mitigation Actions

    1Customer Diversification:

    Achieve OVC revenue growth vs. 2014 Actual

    1.a

    Insufficient leverage in

    pricing strategy vs.

    competition

    2.b

    1.b

    2Berth Productivity:

    Average berth productivity for key customers

    2.aInefficient vessel stowage

    from Horizon Line

    3Cost per Move:

    Reduce operational cost per move vs. 2014

    3.a Increasing cost ofconsumables

    4.b

    3.b

    4Other objectives:

    Description comes here

    4.a

    5Other objectives:

    Description comes here

    5.a

  • 8/10/2019 Target 2015 setting.xlsx

    71/314

    .

  • 8/10/2019 Target 2015 setting.xlsx

    72/314

  • 8/10/2019 Target 2015 setting.xlsx

    73/314

  • 8/10/2019 Target 2015 setting.xlsx

    74/314

    # Terminal Name Initiative Type Initiative

    1 Algeciras Volume Secure Cosco/EVG

    2 Algeciras Volume MOL

    3 Algeciras Volume Secure 2M volume and

    negotiate MSC rates

    4 Algeciras Volume APL

    5 Algeciras Tariff Secure MSC rate increase

    6 Algeciras Volume Secure CMA rate increase

    7 Algeciras Volume Secure Zim rate increase

    8 Algeciras

    9 Algeciras

    10 Algeciras

    11 Algeciras

    12 Algeciras

    13 Algeciras

    14 Algeciras

    15 Algeciras16 Algeciras

    17 Algeciras

    18 Algeciras

    19 Algeciras

    20 Algeciras

    21 Algeciras

    22 Algeciras

    23 Algeciras

    24 Algeciras

    25 Algeciras

    26 Algeciras

  • 8/10/2019 Target 2015 setting.xlsx

    75/314

    27 Algeciras

    28 Algeciras

    29 Algeciras

    30 Algeciras

    31 Algeciras

    32 Algeciras

    33 Algeciras

    34 Algeciras35 Algeciras

    36 Algeciras

    37 Algeciras

    38 Algeciras

    39 Algeciras

    40 Algeciras

    41 Algeciras

    42 Algeciras

    43 Algeciras

    44 Algeciras

    45 Algeciras

    46 Algeciras47 Algeciras

    48 Algeciras

    49 Algeciras

    50 Algeciras

    51 Algeciras

    52 Algeciras

    53 Algeciras

  • 8/10/2019 Target 2015 setting.xlsx

    76/314

  • 8/10/2019 Target 2015 setting.xlsx

    77/314

  • 8/10/2019 Target 2015 setting.xlsx

    78/314

  • 8/10/2019 Target 2015 setting.xlsx

    79/314

  • 8/10/2019 Target 2015 setting.xlsx

    80/314

    Status Tax rate Currency Initiative Start

    In progress 30% EUR 01 January 2015

    In progress 30% EUR 01 February 2015

    In progress 30% EUR 01 April 2015

    In progress 30% EUR 01 June 2015

    Not Started 30% EUR 01 February 2015

    Not Started 30% EUR 01 February 2015

    Not Started 30% EUR 01 February 2015

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

  • 8/10/2019 Target 2015 setting.xlsx

    81/314

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

    30% EUR

  • 8/10/2019 Target 2015 setting.xlsx

    82/314

  • 8/10/2019 Target 2015 setting.xlsx

    83/314

  • 8/10/2019 Target 2015 setting.xlsx

    84/314

  • 8/10/2019 Target 2015 setting.xlsx

    85/314

  • 8/10/2019 Target 2015 setting.xlsx

    86/314

    Initiative End

    Number ofmonths

    effective

    until end

    2015

    Included in

    Target

    2015?

    Jan 2015

    Volume '000

    Moves

    Feb 2015

    Volume '000

    Moves

    Mar 2015

    Volume '000

    Moves

    31 December 2015 12 Y 5,000 5,000 5,000

    31 December 2015 11 Y 2,000 2,000

    31 December 2015 9 Y

    31 December 2015 7 Y

    31 December 2015 11 Y

    31 December 2015 11 N

    31 December 2015 11 N

    1

    1

    1

    1

    1

    1

    1

    11

    1

    1

    1

    1

    1

    1

    1

    1

    1

    1

  • 8/10/2019 Target 2015 setting.xlsx

    87/314

    1

    1

    1

    1

    1

    1

    1

    11

    1

    1

    1

    1

    1

    1

    1

    1

    1

    1

    11

    1

    1

    1

    1

    1

    1

  • 8/10/2019 Target 2015 setting.xlsx

    88/314

  • 8/10/2019 Target 2015 setting.xlsx

    89/314

  • 8/10/2019 Target 2015 setting.xlsx

    90/314

  • 8/10/2019 Target 2015 setting.xlsx

    91/314

  • 8/10/2019 Target 2015 setting.xlsx

    92/314

    Apr 2015

    Volume '000

    Moves

    May 2015

    Volume '000

    Moves

    Jun 2015

    Volume '000

    Moves

    Jul 2015

    Volume '000

    Moves

    Aug 2015

    Volume '000

    Moves

    Sep 2015

    Volume '000

    Moves

    Oct 2015

    Volume '000

    Moves

    5,000 5,000 5,000 5,000 5,000 5,000 5,000

    2,000 2,000 2,000 2,000 2,000 2,000 2,000

    10,000 10,000 10,000 10,000 10,000 10,000 10,000

    8,500 8,500 8,500 8,500 8,500

    Volume

  • 8/10/2019 Target 2015 setting.xlsx

    93/314

  • 8/10/2019 Target 2015 setting.xlsx

    94/314

  • 8/10/2019 Target 2015 setting.xlsx

    95/314

  • 8/10/2019 Target 2015 setting.xlsx

    96/314

  • 8/10/2019 Target 2015 setting.xlsx

    97/314

  • 8/10/2019 Target 2015 setting.xlsx

    98/314

    Nov 2015

    Volume '000

    Moves

    Dec 2015

    Volume '000

    Moves

    FY 2015

    Volume '000

    Moves

    Volume

    annualised

    '000 Moves

    2015

    revenue '000

    Local

    Currency

    2015revenue per

    move '000

    Local

    Currency

    2015

    variable costs

    '000 Local

    Currency

    5,000 5,000 60,000 -

    2,000 2,000 22,000 -

    10,000 10,000 90,000 -

    8,500 8,500 59,500 -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -- -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    Target Revenue Target VarTarget Volume

  • 8/10/2019 Target 2015 setting.xlsx

    99/314

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -- -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -

    - -- -

    - -

    - -

    - -

    - -

    - -

    - -

  • 8/10/2019 Target 2015 setting.xlsx

    100/314

  • 8/10/2019 Target 2015 setting.xlsx

    101/314

  • 8/10/2019 Target 2015 setting.xlsx

    102/314

  • 8/10/2019 Target 2015 setting.xlsx

    103/314

  • 8/10/2019 Target 2015 setting.xlsx

    104/314

    2015variable costs

    per move

    '000 Local

    Currency

    2015 CM

    '000 Local

    Currency

    2015 CM per

    move USD

    Target 2015

    SR

    '000 local

    currency

    Target 2015

    CM

    '000 USD

    Target 2015

    SR

    '000 USD

    - 1,050 17.50 735 1,365 956

    - - - - - -

    - - - - - -

    - 7,000 117.65 4,900 9,100 6,370

    - 3,850 - 2,695 5,005 3,504

    - 3,080 - 2,156 4,004 2,803

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -- - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    Target 2015

    iable Costs Target CM

  • 8/10/2019 Target 2015 setting.xlsx

    105/314

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -- - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -- - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

    - - - - - -

  • 8/10/2019 Target 2015 setting.xlsx

    106/314

  • 8/10/2019 Target 2015 setting.xlsx

    107/314

  • 8/10/2019 Target 2015 setting.xlsx

    108/314

  • 8/10/2019 Target 2015 setting.xlsx

    109/314

  • 8/10/2019 Target 2015 setting.xlsx

    110/314

    January

    2015 Target

    EBITDA

    Savings

    February

    2015 Target

    EBITDA

    Savings

    March 2015

    Target

    EBITDA

    Savings

    April Target

    2015

    EBITDA

    Savings

    May Target

    2015

    EBITDA

    Savings

    June Target

    2015

    EBITDA

    Savings

    150

    1,000

    350 350 350 350 350

    280 280 280 280 280

  • 8/10/2019 Target 2015 setting.xlsx

    111/314

  • 8/10/2019 Target 2015 setting.xlsx

    112/314

  • 8/10/2019 Target 2015 setting.xlsx

    113/314

  • 8/10/2019 Target 2015 setting.xlsx

    114/314

  • 8/10/2019 Target 2015 setting.xlsx

    115/314

  • 8/10/2019 Target 2015 setting.xlsx

    116/314

    July Target

    2015

    EBITDA

    Savings

    August

    Target 2015

    EBITDA

    Savings

    September

    Target 2015

    EBITDA

    Savings

    October

    Target 2015

    EBITDA

    Savings

    November

    Target 2015

    EBITDA

    Savings

    December

    Target 2015

    EBITDA

    Savings

    150 150 150 150 150 150

    1,000 1,000 1,000 1,000 1,000 1,000

    350 350 350 350 350 350

    280 280 280 280 280 280

  • 8/10/2019 Target 2015 setting.xlsx

    117/314

  • 8/10/2019 Target 2015 setting.xlsx

    118/314

  • 8/10/2019 Target 2015 setting.xlsx

    119/314

  • 8/10/2019 Target 2015 setting.xlsx

    120/314

  • 8/10/2019 Target 2015 setting.xlsx

    121/314

  • 8/10/2019 Target 2015 setting.xlsx

    122/314

    Included in

    this Forecast?Target Category Owner

    N Stretched Target Initiative JRG

    N Stretched Target Initiative JRG

    N Stretched Target Initiative TD/GF

    N Stretched Target Initiative JRG

    N Stretched Target Initiative ABC

    N Contingency Initiative BCD

    N Contingency Initiative DEF

  • 8/10/2019 Target 2015 setting.xlsx

    123/314

  • 8/10/2019 Target 2015 setting.xlsx

    124/314

  • 8/10/2019 Target 2015 setting.xlsx

    125/314

  • 8/10/2019 Target 2015 setting.xlsx

    126/314

  • 8/10/2019 Target 2015 setting.xlsx

    127/314

  • 8/10/2019 Target 2015 setting.xlsx

    128/314

    12/1/2015

  • 8/10/2019 Target 2015 setting.xlsx

    129/314

  • 8/10/2019 Target 2015 setting.xlsx

    130/314

  • 8/10/2019 Target 2015 setting.xlsx

    131/314

  • 8/10/2019 Target 2015 setting.xlsx

    132/314

  • 8/10/2019 Target 2015 setting.xlsx

    133/314

  • 8/10/2019 Target 2015 setting.xlsx

    134/314

  • 8/10/2019 Target 2015 setting.xlsx

    135/314

  • 8/10/2019 Target 2015 setting.xlsx

    136/314

  • 8/10/2019 Target 2015 setting.xlsx

    137/314

  • 8/10/2019 Target 2015 setting.xlsx

    138/314

  • 8/10/2019 Target 2015 setting.xlsx

    139/314

  • 8/10/2019 Target 2015 setting.xlsx

    140/314

  • 8/10/2019 Target 2015 setting.xlsx

    141/314

  • 8/10/2019 Target 2015 setting.xlsx

    142/314

  • 8/10/2019 Target 2015 setting.xlsx

    143/314

  • 8/10/2019 Target 2015 setting.xlsx

    144/314

  • 8/10/2019 Target 2015 setting.xlsx

    145/314

  • 8/10/2019 Target 2015 setting.xlsx

    146/314

  • 8/10/2019 Target 2015 setting.xlsx

    147/314

  • 8/10/2019 Target 2015 setting.xlsx

    148/314

  • 8/10/2019 Target 2015 setting.xlsx

    149/314

  • 8/10/2019 Target 2015 setting.xlsx

    150/314

  • 8/10/2019 Target 2015 setting.xlsx

    151/314

  • 8/10/2019 Target 2015 setting.xlsx

    152/314

  • 8/10/2019 Target 2015 setting.xlsx

    153/314

  • 8/10/2019 Target 2015 setting.xlsx

    154/314

  • 8/10/2019 Target 2015 setting.xlsx

    155/314

  • 8/10/2019 Target 2015 setting.xlsx

    156/314

  • 8/10/2019 Target 2015 setting.xlsx

    157/314

  • 8/10/2019 Target 2015 setting.xlsx

    158/314

  • 8/10/2019 Target 2015 setting.xlsx

    159/314

  • 8/10/2019 Target 2015 setting.xlsx

    160/314

  • 8/10/2019 Target 2015 setting.xlsx

    161/314

  • 8/10/2019 Target 2015 setting.xlsx

    162/314

  • 8/10/2019 Target 2015 setting.xlsx

    163/314

  • 8/10/2019 Target 2015 setting.xlsx

    164/314

  • 8/10/2019 Target 2015 setting.xlsx

    165/314

  • 8/10/2019 Target 2015 setting.xlsx

    166/314

  • 8/10/2019 Target 2015 setting.xlsx

    167/314

  • 8/10/2019 Target 2015 setting.xlsx

    168/314

  • 8/10/2019 Target 2015 setting.xlsx

    169/314

  • 8/10/2019 Target 2015 setting.xlsx

    170/314

  • 8/10/2019 Target 2015 setting.xlsx

    171/314

  • 8/10/2019 Target 2015 setting.xlsx

    172/314

  • 8/10/2019 Target 2015 setting.xlsx

    173/314

  • 8/10/2019 Target 2015 setting.xlsx

    174/314

  • 8/10/2019 Target 2015 setting.xlsx

    175/314

  • 8/10/2019 Target 2015 setting.xlsx

    176/314

  • 8/10/2019 Target 2015 setting.xlsx

    177/314

  • 8/10/2019 Target 2015 setting.xlsx

    178/314

  • 8/10/2019 Target 2015 setting.xlsx

    179/314

  • 8/10/2019 Target 2015 setting.xlsx

    180/314

  • 8/10/2019 Target 2015 setting.xlsx

    181/314

  • 8/10/2019 Target 2015 setting.xlsx

    182/314

  • 8/10/2019 Target 2015 setting.xlsx

    183/314

  • 8/10/2019 Target 2015 setting.xlsx

    184/314

  • 8/10/2019 Target 2015 setting.xlsx

    185/314

  • 8/10/2019 Target 2015 setting.xlsx

    186/314

  • 8/10/2019 Target 2015 setting.xlsx

    187/314

  • 8/10/2019 Target 2015 setting.xlsx

    188/314

  • 8/10/2019 Target 2015 setting.xlsx

    189/314

  • 8/10/2019 Target 2015 setting.xlsx

    190/314

  • 8/10/2019 Target 2015 setting.xlsx

    191/314

  • 8/10/2019 Target 2015 setting.xlsx

    192/314

  • 8/10/2019 Target 2015 setting.xlsx

    193/314

  • 8/10/2019 Target 2015 setting.xlsx

    194/314

  • 8/10/2019 Target 2015 setting.xlsx

    195/314

  • 8/10/2019 Target 2015 setting.xlsx

    196/314

  • 8/10/2019 Target 2015 setting.xlsx

    197/314

  • 8/10/2019 Target 2015 setting.xlsx

    198/314

  • 8/10/2019 Target 2015 setting.xlsx

    199/314

  • 8/10/2019 Target 2015 setting.xlsx

    200/314

  • 8/10/2019 Target 2015 setting.xlsx

    201/314

  • 8/10/2019 Target 2015 setting.xlsx

    202/314

  • 8/10/2019 Target 2015 setting.xlsx

    203/314

  • 8/10/2019 Target 2015 setting.xlsx

    204/314

  • 8/10/2019 Target 2015 setting.xlsx

    205/314

  • 8/10/2019 Target 2015 setting.xlsx

    206/314

  • 8/10/2019 Target 2015 setting.xlsx

    207/314

  • 8/10/2019 Target 2015 setting.xlsx

    208/314

  • 8/10/2019 Target 2015 setting.xlsx

    209/314

  • 8/10/2019 Target 2015 setting.xlsx

    210/314

  • 8/10/2019 Target 2015 setting.xlsx

    211/314

  • 8/10/2019 Target 2015 setting.xlsx

    212/314

  • 8/10/2019 Target 2015 setting.xlsx

    213/314

  • 8/10/2019 Target 2015 setting.xlsx

    214/314

  • 8/10/2019 Target 2015 setting.xlsx

    215/314

  • 8/10/2019 Target 2015 setting.xlsx

    216/314

  • 8/10/2019 Target 2015 setting.xlsx

    217/314

  • 8/10/2019 Target 2015 setting.xlsx

    218/314

  • 8/10/2019 Target 2015 setting.xlsx

    219/314

  • 8/10/2019 Target 2015 setting.xlsx

    220/314

  • 8/10/2019 Target 2015 setting.xlsx

    221/314

  • 8/10/2019 Target 2015 setting.xlsx

    222/314

  • 8/10/2019 Target 2015 setting.xlsx

    223/314

  • 8/10/2019 Target 2015 setting.xlsx

    224/314

  • 8/10/2019 Target 2015 setting.xlsx

    225/314

  • 8/10/2019 Target 2015 setting.xlsx

    226/314

  • 8/10/2019 Target 2015 setting.xlsx

    227/314

  • 8/10/2019 Target 2015 setting.xlsx

    228/314

  • 8/10/2019 Target 2015 setting.xlsx

    229/314

  • 8/10/2019 Target 2015 setting.xlsx

    230/314

  • 8/10/2019 Target 2015 setting.xlsx

    231/314

  • 8/10/2019 Target 2015 setting.xlsx

    232/314

  • 8/10/2019 Target 2015 setting.xlsx

    233/314

  • 8/10/2019 Target 2015 setting.xlsx

    234/314

  • 8/10/2019 Target 2015 setting.xlsx

    235/314

  • 8/10/2019 Target 2015 setting.xlsx

    236/314

  • 8/10/2019 Target 2015 setting.xlsx

    237/314

  • 8/10/2019 Target 2015 setting.xlsx

    238/314

  • 8/10/2019 Target 2015 setting.xlsx

    239/314

    Instruction: Pls complete any Other (sundry) Initiativ

    Entity

    HFM

    Code

    Entity

    Name

    Region

    1 ES002E Algeciras Mature Markets

    2 ES002E Algeciras Mature Markets

    3 ES002E Algeciras Mature Markets

    4 ES002E Algeciras Mature Markets

    5 ES002E Algeciras Mature Markets

    6 ES002E Algeciras Mature Markets

    7 ES002E Algeciras Mature Markets8 ES002E Algeciras Mature Markets

    9 ES002E Algeciras Mature Markets

    10 ES002E Algeciras Mature Markets

  • 8/10/2019 Target 2015 setting.xlsx

    240/314

    s 2015 not yet captured under the various functional intiatives

    Initiative Initiative Type Function

    Renegotiate concession agreement OtherInitiatives Finance

    Reconfigure Maersk.net connection OtherInitiatives IT

    Evaluate and renegotiate contracts (Legal,

    Consultants)

    OtherInitiatives Legal

    OtherInitiatives

    OtherInitiatives

    OtherInitiatives

    OtherInitiativesOtherInitiatives

    OtherInitiatives

    OtherInitiatives

  • 8/10/2019 Target 2015 setting.xlsx

    241/314

    TCO or

    Productivity

    Category Bridge Category Savings Start

    Month

    Savings End

    Month

    TCO Variable Cost RQF 2015 Initiative 1-Feb-2015 31-Jan-2016

    TCO Variable Cost Stretched Target Initiative 1-Jan-2015 31-Dec-2015

    TCO Variable Cost Contingency Initiative 1-Jul-2015 30-Jun-2016

    TCO

    TCO

    TCO

    TCOTCO

    TCO

    TCO

  • 8/10/2019 Target 2015 setting.xlsx

    242/314

    1/1/2015 2/1/2015

    Number

    of

    months

    FY EBITDA Impact

    Local Currency

    '000

    Entity

    Tax Rate

    FY 2015

    Segment Result

    Impact

    January 2015

    Target EBITDA

    Savings

    Local Currency

    '000

    February 2015

    Target EBITDA

    Savings

    Local Currency

    '000

    12 200 30% 140 17

    12 100 30% 70 8 8

    12 85 30% 60

    1 30% -

    1 30% -

    1 30% -

    1 30% -1 30% -

    1 30% -

    1 30% -

  • 8/10/2019 Target 2015 setting.xlsx

    243/314

    3/1/2015 4/1/2015 5/1/2015 6/1/2015 7/1/2015

    March 2015

    Target EBITDA

    Savings

    Local Currency

    '000

    April Target

    2015 EBITDA

    Savings

    Local Currency

    '000

    May Target

    2015 EBITDA

    Savings

    Local Currency

    '000

    June Target

    2015 EBITDA

    Savings

    Local Currency

    '000

    July Target

    2015 EBITDA

    Savings

    Local Currency

    '000

    17 17 17 17 17

    8 8 8 8 8

    7

  • 8/10/2019 Target 2015 setting.xlsx

    244/314

  • 8/10/2019 Target 2015 setting.xlsx

    245/314

    Included

    in 2015

    Target?

    Included in

    this Forecast?

    Status Responsible Person Comments

    Y RQF September In Progress ISMAEL BIENVENIDO

    Y RQF September Not Started

    N

    Y

    Y

    Y

    YY

    Y

    Y

  • 8/10/2019 Target 2015 setting.xlsx

    246/314

  • 8/10/2019 Target 2015 setting.xlsx

    247/314

  • 8/10/2019 Target 2015 setting.xlsx

    248/314

  • 8/10/2019 Target 2015 setting.xlsx

    249/314

  • 8/10/2019 Target 2015 setting.xlsx

    250/314

  • 8/10/2019 Target 2015 setting.xlsx

    251/314

  • 8/10/2019 Target 2015 setting.xlsx

    252/314

  • 8/10/2019 Target 2015 setting.xlsx

    253/314

    Update : 10/14/2014 6:51

    Terminal: Algeciras

    Report currency: EUR

    Opex target: Amount Local Currency '000

    capex target: Amount Local Currency '000

    Number Category / Taxonomy

    1 Legal

    2 Facility Management

    3 Civil Engineering & Infrastructure

    4

    56

    7

    8

    9

    10

    11

    12

    13

    14

    15

    16

    1718

    19

    20

    21

    22

    23

    24

    25

    26

    27

    28

    29

    30

    31

    32

    33

  • 8/10/2019 Target 2015 setting.xlsx

    254/314

  • 8/10/2019 Target 2015 setting.xlsx

    255/314

    Project name Responsible Project

    status

    Project

    type

    budget /

    baseline spend

    Local Currency

    '000

    Renegotiating legal contract closed Opex 170

    Salt for winter days planned Opex 150

    Potential rental of 2 reachstackers unknown Opex 900

    Project Characteristics

  • 8/10/2019 Target 2015 setting.xlsx

    256/314

  • 8/10/2019 Target 2015 setting.xlsx

    257/314

    GPRO

    involved

    Bridge Category Estimated

    Project Start

    Date

    Estimated

    Project End

    Date

    Estimated

    Savings %

    Included in this

    forecast

    Y RQF 2015 Initiative 1/1/2015 9/30/2015 10% RQF September

    Y RQF 2015 Initiative 1/1/2015 12/31/2015 5% RQF September

    Y RQF 2015 Initiative 3/1/2015 12/31/2015 RQF September

    Forecasting

  • 8/10/2019 Target 2015 setting.xlsx

    258/314

  • 8/10/2019 Target 2015 setting.xlsx

    259/314

    New Cost

    Local

    Currency

    '000

    Baseline type Baseline

    Cost

    Contract

    start date

    Total

    annualised

    Savings

    Generated

    January

    2014

    Local

    Currency

    '000

    156 Previous Price Paid 7/1/2014 14

    24

    15

  • 8/10/2019 Target 2015 setting.xlsx

    260/314

  • 8/10/2019 Target 2015 setting.xlsx

    261/314

    February

    2014

    Local

    Currency

    '000

    March

    2014

    Local

    Currency

    '000

    April

    2014

    Local

    Currency

    '000

    May

    2014

    Local

    Currency

    '000

    June

    2014

    Local

    Currency

    '000

    July

    2014

    Local

    Currency

    '000

  • 8/10/2019 Target 2015 setting.xlsx

    262/314

  • 8/10/2019 Target 2015 setting.xlsx

    263/314

    August

    2014

    Local

    Currency

    '000

    September

    2014

    Local

    Currency

    '000

    October

    2014

    Local

    Currency

    '000

    November

    2014

    Local

    Currency

    '000

    December

    2014

    Local

    Currency

    '000

    P&L impact

    2014

    Local

    Currency

    '000

    1 1 1 1 1 5

    -

    -

    -

    --

    -

    -

    -

    -

    -

    -

    -

    -

    -

    -

    --

    -

    -

    -

    -

    -

    -

    -

    -

    -

    -

    -

    -

    -

    -

    -

    Closing out projects

  • 8/10/2019 Target 2015 setting.xlsx

    264/314

  • 8/10/2019 Target 2015 setting.xlsx

    265/314

    January

    2015

    Local

    Currency

    '000

    February

    2015

    Local

    Currency

    '000

    March

    2015

    Local

    Currency

    '000

    April

    2015

    Local

    Currency

    '000

    May

    2015

    Local

    Currency

    '000

    June

    2015

    Local

    Currency

    '000

    July

    2015

    Local

    Currency

    '000

    1 1 1 1 1 1 1

    2 2 2 2 2 2 2

    - - 2 2 2 2 2

  • 8/10/2019 Target 2015 setting.xlsx

    266/314

  • 8/10/2019 Target 2015 setting.xlsx

    267/314

    August

    2015

    Local

    Currency

    '000

    September

    2015

    Local

    Currency

    '000

    October

    2015

    Local

    Currency

    '000

    November

    2015

    Local

    Currency

    '000

    December

    2015

    Local

    Currency

    '000

    P&L

    impact

    2015

    Local

    Currency

    P&L

    impact

    2016

    1 1 - - - 9 0

    2 2 2 2 2 24

    2 2 2 2 2 15

    0

    00

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    00

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

  • 8/10/2019 Target 2015 setting.xlsx

    268/314

  • 8/10/2019 Target 2015 setting.xlsx

    269/314

    eRFx eAuction

    Y N

  • 8/10/2019 Target 2015 setting.xlsx

    270/314

  • 8/10/2019 Target 2015 setting.xlsx

    271/314

  • 8/10/2019 Target 2015 setting.xlsx

    272/314

    abour Costs

    Risk Jan Feb Mar Apr May Jun

    Low (0.01) (0.01) (0.01) (0.01) (0.01) (0.01)

    (0.01) (0.01) (0.01) (0.01)

    Medium (0.03) (0.03) (0.03) (0.03) (0.03) (0.03)

    - - - - - (0.01)

    - - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    - - - - -

    (0.04) (0.04) (0.05) (0.05) (0.05) (0.06)

    0.25 0.25 0.24 0.24 0.24 0.23

    2 2 2 2 2 3

    0 0 1 1 1 1

    1 1 1 1 1 2

    - - - - - -

    - - - - - -

    Month-

  • 8/10/2019 Target 2015 setting.xlsx

    273/314

    FY impact

    Jul Aug Sep Oct Nov Dec FY 2015

    (0.01) (0.01) (0.01) (0.09)

    (0.01) (0.01) (0.01) (0.07)

    -

    (0.03) (0.03) (0.03) (0.03) (0.03) (0.03) (0.36)

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.07)

    - (0.01) (0.01) (0.01) (0.01) (0.01) (0.05)

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    (0.06) (0.07) (0.07) (0.05) (0.05) (0.05) (0.48)

    0.23 0.22 0.22 0.24 0.24 0.24

    3 3 3 2 2 2 32

    1 1 1 - - -

    2 2 2 2 2 2

    - - - - - -

    - - - - - -

    2015

    n-Month impact

  • 8/10/2019 Target 2015 setting.xlsx

    274/314

    check

    -

  • 8/10/2019 Target 2015 setting.xlsx

    275/314

  • 8/10/2019 Target 2015 setting.xlsx

    276/314

  • 8/10/2019 Target 2015 setting.xlsx

    277/314

  • 8/10/2019 Target 2015 setting.xlsx

    278/314

    CHS SFCT

  • 8/10/2019 Target 2015 setting.xlsx

    279/314

    HOU CNC

  • 8/10/2019 Target 2015 setting.xlsx

    280/314

  • 8/10/2019 Target 2015 setting.xlsx

    281/314

    75,022 Fixed + Variable BC Labour Costs

    1,369 excludes EMR, Inland Services and WC man hours

    1,299

    1.05

    Input Category Risk Jan Feb Mar

  • 8/10/2019 Target 2015 setting.xlsx

    282/314

    Apr May Jun Jul Aug Sep Oct

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01)

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01)

    - - - - - - -

    (0.03) (0.03) (0.03) (0.03) (0.03) (0.03) (0.03)

    - - (0.01) (0.01) (0.01) (0.01) (0.01)

    - - - - (0.01) (0.01) (0.01)

    - - - - - - -

    - - - - - - -

    - - - - - - -

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01)

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01)

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    - - - - - - -

    (0.07) (0.07) (0.08) (0.08) (0.09) (0.09) (0.09)

    0.98 0.98 0.97 0.97 0.96 0.96 0.96

    438 438 500 500 563 563 563

    250 250 250 250 250 250 250

    188 188 250 250 313 313 313

    - - - - - - -

    - - - - - - -

    2015

    Month-on-Month impact

  • 8/10/2019 Target 2015 setting.xlsx

    283/314

    FY impact

    Nov Dec FY 2015

    (0.01) (0.01) (0.12)

    (0.01) (0.01) (0.10)

    - - -

    (0.03) (0.03) (0.36)

    (0.01) (0.01) (0.07)

    (0.01) (0.01) (0.05)

    - - -

    - - -

    - - -

    (0.01) (0.01) (0.11)

    (0.01) (0.01) (0.10)

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    - - -

    (0.09) (0.09) (0.91)

    0.96 0.96

    check

    563 563 5,752 -

    250 250

    313 313

    - -

    - -

  • 8/10/2019 Target 2015 setting.xlsx

    284/314

  • 8/10/2019 Target 2015 setting.xlsx

    285/314

  • 8/10/2019 Target 2015 setting.xlsx

    286/314

    MOB JAX

  • 8/10/2019 Target 2015 setting.xlsx

    287/314

    CHS SFCT

  • 8/10/2019 Target 2015 setting.xlsx

    288/314

    HOU CNC

  • 8/10/2019 Target 2015 setting.xlsx

    289/314

    Algeciras

    Pls include a comment in case the

    79900T 2014 GMPH Baseline (August YTD): 29.6

    78618 Crane Hours 43,933

    Vertical Tandem Lifts 10% of total moves

    15% of total moves

    20% of total moves

    Discharge Back Reach 10% of total TP6 & TP5 Moves

    20% of total TP6 & TP5 Moves

    30% of total TP6 & TP5 Moves

    Pooling of UTR's "PrimeRoute" 10% of total moves

    25% of toal moves

    50% of total moves

    Coning Stations 20% of total moves50% of toal moves75% of total moves

    Total:

    Monthly GMPH

  • 8/10/2019 Target 2015 setting.xlsx

    290/314

    baseline is adjusted

    Jan Feb Mar Apr May Jun Jul Aug

    - - - - - - - -

    - - - - - - - -

    - - - - - - - -

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

    - - - - - 0.3 0.3 0.3

    - - - - - - 0.4 0.4

    - - - - - - - 0.4

    0.0 0.0 0.0 0.0 0.0 0.3 0.6 1.0

    - - - - - - - 0.2

    - - - - - - - -

    - - - - - - - -

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.2

    - - - - 0.2 0.2 0.2 0.2- - - - - 0.2 0.2 0.2

    - - - - - - 0.2 0.2

    0.0 0.0 0.0 0.0 0.2 0.3 0.5 0.5

    - - - - 0.2 0.6 1.1 1.7

    29.6 29.6 29.6 29.6 29.7 30.1 30.7 31.3

    2015

    MoM impact - GMPH

  • 8/10/2019 Target 2015 setting.xlsx

    291/314

    FY impact GMPH

    Sep Oct Nov Dec FY 2014

    - 0.4 0.4 0.4 0.09

    - - 0.5 0.5 0.08

    - - - 0.5 0.04

    0.0 0.4 0.8 1.3 0.2

    0.3 0.3 0.3 0.3 0.15

    0.4 0.4 0.4 0.4 0.18

    0.4 0.4 0.4 0.4 0.17

    1.0 1.0 1.0 1.0 0.5

    0.2 0.2 0.2 0.2 0.08

    0.2 0.2 0.2 0.2 0.05

    0.3 0.3 0.3 0.3 0.08

    0.6 0.6 0.6 0.6 0.2

    0.2 0.2 0.2 0.2 0.100.2 0.2 0.2 0.2 0.11

    0.2 0.2 0.2 0.2 0.10

    0.5 0.5 0.5 0.5 0.3

    2.2 2.5 2.9 3.4 1.21

    31.7 32.0 32.5 33.0

  • 8/10/2019 Target 2015 setting.xlsx

    292/314

    Operational Base-line is August YTD Actuals which is automatically retrieved in the blue cells

    Local Currency '000

    Algeciras

    Pls include a comment in case the baselin

    118 Total Ops BC cost Base-line 75,022 Fixed + Variable BC

    115 Variable BC Labour Costs -

    789 Total hrs BC ops Base-line 1,369 excludes EMR, Inlan799 number of moves 1,299

    Base-line man hrs/ move 1.05

    Input Category

    Yard clerks reduction 2 clerks for 3 RTGs Carryover

    1 clerks for 3 RTGs Carryover

    Carryover

    Reduce QC waiting time for UTRS 25% effect RQF

    50% effect RQF

    Full Effect RQF

    Shift change 30 min Carryover

    25 min Carryover

    20 min Carryover

    30% effect Stretched

    60% effect Stretched

    Full Effect Stretched

    Total:

    Monthly Man hrs/ move

    Financial benefits - total - local currency '000

    Carryover

    RQF

    Stretched

    Contingency

  • 8/10/2019 Target 2015 setting.xlsx

    293/314

    .

    is adjusted

    abour Costs

    d Services and WC man hours

    Risk Jan Feb Mar Apr May Jun

    Low (0.01) (0.01) (0.01) (0.01) (0.01) (0.01)

    (0.01) (0.01) (0.01) (0.01)

    Medium (0.03) (0.03) (0.01) (0.01) (0.01)

    - - - - - (0.01)

    - - - - - -

    Medium (0.02) (0.02) (0.02) (0.02) (0.02) (0.02)

    (0.02) (0.02) (0.02)

    - -

    Medium (0.01) (0.01) (0.01) (0.01) (0.01) (0.01)

    - - - - - -

    - - - - - -

    - - - - -

    - - - - -

    - - - - -

    (0.07) (0.07) (0.05) (0.08) (0.08) (0.09)

    0.98 0.98 1.00 0.97 0.97 0.96

    438 438 313 500 500 563

    188 188 250 375 375 375

    188 188 - 63 63 125.04

    63 62.52 62.52 63 62.52 62.52

    - - - - - -

    Month-

  • 8/10/2019 Target 2015 setting.xlsx

    294/314

    FY impact

    Jul Aug Sep Oct Nov Dec FY 2015

    (0.01) (0.01) (0.01) (0.09)

    (0.01) (0.01) (0.01) (0.07)

    -

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.15)

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.07)

    - (0.01) (0.01) (0.01) (0.01) (0.01) (0.05)

    (0.02) (0.02) (0.02) (0.02) (0.02) (0.02) (0.24)

    (0.02) (0.02) (0.02) (0.02) (0.02) (0.02) (0.18)

    (0.02) (0.02) (0.02) (0.02) (0.02) (0.02) (0.12)

    (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.12)

    - (0.01) (0.01) (0.01) (0.01) (0.01) (0.05)

    - - (0.01) (0.01) (0.01) (0.01) (0.04)

    - - - - - - -

    - - - - - - -

    - - - - - - -

    (0.11) (0.13) (0.14) (0.12) (0.12) (0.12) (1.02)

    0.94 0.92 0.91 0.93 0.93 0.93

    688 813 875 750 750 750 7,377

    500 500 500 375 375 375

    125.04 188 188 188 188 188

    62.52 125 188 188 188 188

    - - - - - -

    2015

    n-Month impact

  • 8/10/2019 Target 2015 setting.xlsx

    295/314

    check

    -

  • 8/10/2019 Target 2015 setting.xlsx

    296/314

  • 8/10/2019 Target 2015 setting.xlsx

    297/314

  • 8/10/2019 Target 2015 setting.xlsx

    298/314

    MOB JAX

  • 8/10/2019 Target 2015 setting.xlsx

    299/314

    CHS SFCT

  • 8/10/2019 Target 2015 setting.xlsx

    300/314

    HOU CNC

  • 8/10/2019 Target 2015 setting.xlsx

    301/314

    Operational Base-line is August YTD Actuals which is automatically retrieved in the blue cell

    Local Currency '000

    Algeciras

    Pls include a comment in case the ba

    115 Total fuel cost 3,241

    789 Total litres consumed 4,747

    Fuel cost/ liter 0.7

    799 Total moves Base-line 1,299

    Base-line fuel (litres)/ move: 3.7

    Input

    Efficient RTG deployment Deployment most energy efficient

    RTGs

    Yard strategy adherence 80% adherence

    90% adherence

    100% adherence

    Dual cycle 10% of total moves

    15% of total moves

    20% of total moves

    Idling automatic switch-off Idling % time 35%

    Idling % time 30%

    Idling % time 25%

    Total:

    Fuel (litres)/ move

    Financial benefits - total - local currency '000

    Carryover

    RQF

    Stretched

    Contingency

  • 8/10/2019 Target 2015 setting.xlsx

    302/314

    .

    eline is adjusted

    excl. genset and RMG's

    Category Risk Jan Feb Mar Apr

    Carryover Low (0.05) (0.05) (0.05) (0.05)

    Carryover - - - -

    Carryover - - - -

    RQF Medium - (0.05) (0.05) (0.05)

    RQF - - - -

    RQF - - - -

    RQF Medium (0.04)

    RQF

    RQF

    Contingency Medium - - -

    Contingency - - - -

    Contingency - - - -

    - - -

    - - -

    - - -

    (0.05) (0.10) (0.10) (0.14)

    3.71 3.76 3.76 3.80

    14 27 27 38

    14 14 14 14

    - 14 13.50 24

    - - - -

    - - - -

  • 8/10/2019 Target 2015 setting.xlsx

    303/314

    May Jun Jul Aug Sep Oct Nov

    (0.04) - - - - - -

    - - - - - - -

    - - - - - - -

    (0.05) (0.05) (0.05) (0.05) (0.05) (0.05) (0.05)

    - (0.03) (0.03) (0.03) (0.03) (0.03) (0.03)

    - - - (0.02) (0.02) (0.02) (0.02)

    (0.04) (0.04) (0.04) (0.04) (0.04) (0.04) (0.04)

    (0.03) (0.03) (0.03) (0.03) (0.03) (0.03) (0.03)

    (0.02) (0.02) (0.02) (0.02)

    - - (0.02) (0.02) (0.02) (0.02) (0.02)

    - - - (0.02) (0.02) (0.02) (0.02)

    - - - - (0.03) (0.03) (0.03)

    - - - - - - -

    - - - - - - -

    - - - - - - -

    (0.16) (0.15) (0.17) (0.23) (0.26) (0.26) (0.26)

    3.82 3.81 3.83 3.89 3.92 3.92 3.92

    43 41 46 62 70 70 70

    11 - - - - - -

    32 40.51 40.51 51 51 51 51

    - - - - - - -

    - - 5.40 11 19 19 19

    2015

    Month-on-Month impact in litres

  • 8/10/2019 Target 2015 setting.xlsx

    304/314

    FY impact in litres

    Dec FY 2015

    - (0.24)

    - -

    - -

    (0.05) (0.55)

    (0.03) (0.21)

    (0.02) (0.10)

    (0.04) (0.36)

    (0.03) (0.24)

    (0.02) (0.10)

    (0.02) (0.12)

    (0.02) (0.10)

    (0.03) (0.12)

    - -

    - -

    - -

    (0.26) (2.14)

    3.92

    check

    70 578 -

    -

    51

    -

    19

  • 8/10/2019 Target 2015 setting.xlsx

    305/314

  • 8/10/2019 Target 2015 setting.xlsx

    306/314

  • 8/10/2019 Target 2015 setting.xlsx

    307/314

    MOB J

  • 8/10/2019 Target 2015 setting.xlsx

    308/314

    X CHS SF

  • 8/10/2019 Target 2015 setting.xlsx

    309/314

    CCT HOU

  • 8/10/2019 Target 2015 setting.xlsx

    310/314

    C

  • 8/10/2019 Target 2015 setting.xlsx

    311/314

    Operational Base-line is August YTD Actuals which is automatically retrieved in the blue cells.

    Local Currency '000

    Algeciras

    Pls include a comment in case the baselin

    115 M&R costs 14,664

    784 Supporting CHE hrs (RTGs, truck, TL, EH/ SC, TL) 531 excludes operating h

    ### QC hrs 44

    Base-line average cost of supporting CHE hrs (USD) 27.6

    Supporting CHE hrs/ QC hrs 12.1

    Input KPI Category

    Reduce QC waiting time for UTRs 25% effect RQF

    50% effect RQF

    Full Effect RQF

    Shift change 30 min RQF

    25 min RQF

    20 min RQF

    RTG deployment efficiency 30% effect Stretched

    60% effect Stretched

    Full Effect Stretched

    Trucks deployment efficiency 7.5 truck per QC Contingency

    7 truck per QC Contingency

    Contingency

    Contingency

    Contingency

    Contingency

    Total:

    Monthly supporting CHE hrs/ QC hrs

    Financial benefits - total - local currency '000

    Carry over

    RQF

    Stretched

    Contingency

  • 8/10/2019 Target 2015 setting.xlsx

    312/314

    is adjusted

    ours RMGC

    Risk Jan Feb Mar Apr May Jun

    Low - - (0.04) (0.04) (0.04)

    - - - - - (0.04)

    - - - - - -

    Low (0.08) (0.08) (0.08) (0.08) (0.08) (0.08)

    (0.08) (0.08) (0.08)

    - -

    High

    Medium

    - - -

    - - - -

    (0.08) (0.08) (0.08) (0.20) (0.20) (0.24)

    12.0 12.0 12.0 11.9 11.9 11.8

    8 8 8 20 20 24

    - - - - - -

    8 8 8 20 20 24

    - - - - - -

    - - - - - -

    20

    Month-on-Mont

  • 8/10/2019 Target 2015 setting.xlsx

    313/314

    FY impact

    in Hours

    Jul Aug Sep Oct Nov Dec FY 2015

    (0.04) (0.04) (0.04) (0.04) (0.04) (0.04) (0.36)

    (0.04) (0.04) (0.04) (0.04) (0.04) (0.04) (0.28)

    - (0.04) (0.04) (0.04) (0.04) (0.04) (0.20)

    (0.08) (0.08) (0.08) (0.08) (0.08) (0.08) (0.96)

    (0.08) (0.08) (0.08) (0.08) (0.08) (0.08) (0.72)

    (0.08) (0.08) (0.08) (0.08) (0.08) (0.08) (0.48)

    (0.06) (0.06) (0.06) (0.06) (0.06) (0.06) (0.36)

    (0.06) (0.06) (0.06) (0.06) (0.06) (0.30)

    (0.10) (0.10) (0.10) (0.10) (0.40)

    (0.10) (0.10) (0.10) (0.10) (0.40)

    (0.10) (0.10) (0.10) (0.30)

    -

    (0.02) (0.02) (0.02) (0.02) (0.02) (0.02) (0.12)

    (0.02) (0.02) (0.02) (0.02) (0.02) (0.10)

    (0.03) (0.03) (0.03) (0.03) (0.12)

    (0.40) (0.52) (0.75) (0.85) (0.85) (0.85) (4.76)

    11.7 11.6 11.3 11.2 11.2 11.2

    check

    40 53 76 86 86 86 516 -

    - - - - - -

    32 36 36 36 36 36

    6 12 22 22 22 22

    2 4 17 27 27 27

    15

    impact in Hours

  • 8/10/2019 Target 2015 setting.xlsx

    314/314