a. To be investigated

ERROR € 

It is a technical destination type that we apply when as result of the algorithm, the difference between Origin and Destination is >150%. In that case we do not apply the algorithm, we apply a single rule Origin = Destination . This means that we do not know the real destination type (P&L, Capex, ...)

Non ERP €

It is the value that has been upload manually for the origin view of Non ERP entities  as in the destination view, Destination = Origin. There is no assignment to destination type (PL, Capex or other destination).

We created this technical destination type (NERP) to have it under control. Next step would be to create a new manual upload method that provide also the destination information for NERP.

b. Currency

c. Scope

3 scopes are available in Costa:

• ALL : it includes all indirect spend (all costs except raw materials and utilities) / all CAPEX/OPEX/Capital leases
• Anaplan Scope : It is the Budget scope and it is a subset of Co$ta perimeter. We want to focus the budget on fixed costs that are managed on a recurring basis: we exclude variable costs and non recurring costs
• F2G Scope : Full for Growth scope is a subset of Anaplan scope. We exclude Internal Labor, Commission on sales and Warehouse & Log Rental

You can find here further info

When you select %_Conso_Applied to display the results of operations of the concerned legal entities after applying the consolidation (integration) rate relevant for these entities.

So for instance, for a JV integrated at 50%, the costs are 50% of the original company's figures

e. Need Help?

If you click on the “Need Help” button, you will be directed to freshdesk platform to open a ticket. Don't hesitate to use it, should you require assistance or should you wish to report an issue such as some inaccuracies in the data.

f. Documentation

From Qlik Sense dashboard, you can access directly to this wiki.

In this view, it is the YTD of the current year at destination (2.63 BEUR) compared with the YTD of the previous year (2.739 BEUR), and the % of the variation (-3.6%) for total costs

The currency is Euro

• When the number is green preceded by a down arrow ↓ costs are decreasing
• When the number is red preceded by an up arrow  ↑   costs are increasing

View 2 - PL IMPACT €

In this view, it is the YTD of the current year of P&L destination costs (2.07 BEUR) compared with the YTD of the previous year (1.989 BEUR), and the % of the variation (+4.5%) for P&L costs. 

The currency is Euro

• When the number is green preceded by a down arrow ↓ costs are decreasing
• When the number is red preceded by an up arrow  ↑   costs are increasing

View 3 - CAPEX €

You see here the YTD of the current year of the CAPEX destination costs (196.27 MEUR) compared with the YTD of the previous year (205.19 MEUR), and the % of the variation (-4.3%) for Capex costs.  The costs are capitalized via projects WBS.

The currency is Euro

• When the number is green preceded by a down arrow ↓   costs are decreasing
• When the number is red preceded by an up arrow   ↑   costs are increasing

View 4 - REINVOICING €

You see here the YTD of the current year (139.51 MEUR) compared with the YTD of the previous year (186.57 MEUR), and the % of the variation (-25.2%) of the invoicing flows (net between In and out) of the perimeter selected to other companies (Interco or external).

The currency is Euro

• When the number is green preceded by a down arrow ↓  costs are decreasing
• When the number is red preceded by an up arrow   ↑   costs are increasing

View 5 - CAPITAL LEASE €

You see here the YTD of the current year (45.94 MEUR) compared with the YTD of the previous year (47.05 MEUR), and the % of the variation (-2.4%) for capital lease expenses (IFR16) in balance sheet

The currency is Euro

• When the number is green preceded by a down arrow ↓   costs are decreasing
• When the number is red preceded by an up arrow   ↑   costs are increasing

You see here the YTD of the current year (54.73 MEUR) compared with the YTD of the previous year (44.71 MEUR), and the % of the variation (22.4%) for stocks. It is cost that is allocated to production variable costs in inventory.

The currency is Euro

• When the number is green preceded by a down arrow ↓   costs are decreasing
• When the number is red preceded by an up arrow   ↑   costs are increasing

You see here the YTD of the current year (84.81 MEUR) compared with the YTD of the previous year (68.09 MEUR), and the % of the variation (24.5%) for costs that are settle in Balance Sheet account (GL account)

The currency is Euro

• When the number is green preceded by a down arrow ↓   costs are decreasing
• When the number is red preceded by an up arrow   ↑   costs are increasing

You have in this bridge the variation between the current period vs the previous period declined by delta of:

• macro packages 
• assignment type : Reinvoicing, Capex, Capital Lease, Stock, Balance sheet, Non ERP, Error

You can see it for one month, one quarter, YTD. It depends of the selection/ filter you do.

You can see in the graph the cost repartition (blue bars) vs previous period (yellow strait).

You have different dimensions available in the axis of the graph.

In vertical axis, you can select different dimensions:

• Macro package
• Country of Company
• Plant
• Package
• BFC Activity 1
• 3-Sub Function Grouping
• Origin GBU
• Destination GBU
• Budget owner hierarchy (L1 to L5)
• Legal entity
• Site

In horizontal axis, you can select the destination type :

• Total costs
• PL Impact
• Capex
• Reinvoicing
• Capital Lease
• Stock
• Balance Sheet
• Non ERP
• Error

You can see in the graph the evolution month after month (or quarter) of the current period (blue bars) vs previous period (yellow bars). Or if you prefer you can see the variation between the current and the previous periods.

In vertical axis, you can select the destination type :

• Total costs
• PL Impact
• Capex
• Reinvoicing
• Capital Lease
• Stock
• Balance Sheet
• Non ERP
• Error

In horizontal axis, you can select the evolution by month or by quarter.

View 11 - Table : Macro Package by destination type and BFC headings