You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »



Co$ta - Destination Bridge

>> Back to the Co$ta project home page



Concept


The Destination bridge is a new application inside the Costa Dashboard (a new sheet) that provides insight of the impact in the Ebitda from the Cost at origin , more specifically in the Fixed Cost in EBitda.

The objective is double: being able to quantify the different bridge elements from the cost of origin to the Fixed Cost,  and comparing this bridge with a given reference (by default budget but it can be also with Y-1).

The data, calculations and concepts for the destination bridge for actuals are based on the” BW query destination view”; to know more about it go to Co$ta - BW Destination view .


Scope


The Destination Bridge starts at the cost at origin for Anaplan Scope (see in this link more detail explanations), and from there it explains the portion of this cost that will impact the Fixed Cost of a given GBU (or budget node or site) after some deductions and additions that we can see in the bridge.

This means for instance that a) the cost that is not in Scope  of Costa tool is not considered in the bridge: for instance utilities.b) But also that cost being in the scope of the Costa tool, but that is not part of Anaplan scope, it will not be considered either (such as packaging or transportation), or the cost of certain JV or certain CC groups in ZCBS hierarchy or certain Capex.


Architecture/design


  • The Destination Bridge explains the Cost impact from the cost at origin to the Fixed Cost in P&L (a to b)  
  • After selecting the reference of comparability (either budget or Y-1) the dashboard compares actual data with that reference (c) and shows the gap.
    • If not filters in the background the values are referred to the Year to date of the current year, and the reference will consider the same period of time.
  • The dashboard allows filters by Origin GBU, budget nodes or site (d).
  • You can select to run the report in Euro or local currency
  • Also at the bottom of the dashboard we can find some satellite tables that provides more details:
    • Fixed Cost by P&L heading group.
    • F2G scope and Out of scope of Anaplan (always Anaplan scope) by MacroPackage.
    • Charge In and Charge out additional details


  • No labels