François Carette
 Performance & Capex Reporting Manager - GEC


Marie-Line Ardito



General Description

Capability to have a view of the Forecasts by investment type for a selected period (Year or/and Quarter)
  • Capex/Capspend Forecast by Investment type : Amount and % of forecasted budget for a selected period with a split by investment type
  • Capex/Capspend Forecast Investment type by GBU : ranking of GBUs amount and %  forecasted budget for a selected period with a split by investment type
  • Capex/Capspend Investment type bridge : comparison of Y-1 Capex/Capspend Actuals vs Y Capex/Capspend Forecast with the detailed part of the gap for each investment type
  • Details : total of Capex/Capspend Forecasts of the period selected with a split by investment type and the related % of each investment type vs the total of forecasts. Capability to see by GBU, Zone, Bundle, Plant.


Calculation 
Capex Actuals
is the amount paid
If the cost is linked to a purchase order => it's the amount once the invoice has been paid.
If the cost is not related a purchase order => equal to the capspend (GR)
-------------------------------------------------------------
After a project has been approved and created in PS
Capex Actuals are available when Colmar investment project code = the PS project ID
Data are coming from PS
Capex Forecast
is the prevision of capex filled and updated by the GBU into Colmar
  
Capspend Actuals
is the actual costs (received costs)
it can correspond to :
  • Purchase orders, the reception of services/goods (at GR date)
  • Stock issue : value of the material (at stock issue date)
  • Hours : standard cost defined for each hour.
  • Transfers (from Maintenance orders etc...)
  • Manual entries (CO document) and other adjustments.
Capspend Forecast
is the prevision of Capspend filled and updated by the GBU into Colmar
  
Investment Type
is the categorization of the investment
  • Current (capitalized) : < 1 MEUR
  • Medium (capitalized) : ≥ 1 MEUR and < 10 MEUR
  • Major (capitalized) : ≥ 10 MEUR
  • Reserve : amounts (at GBU or plant level) for not yet identified investments but which correspond to expenses which the GBU or the plant forecasts
  • Demolition (non capitalized) : for demolition projects
  • Preliminary :
  • Other : <> Current, Medium, Major


Sources

Capex/Capspend Actuals

Capex/Capspend Forecasts

Core query
BW_QRY_MPR_PS014_0011
BW_COLMAR_MVIPCO17_0001
QV query
QVCOLMAR_BW_QRY_MVIPCO17_0002
QVCOLMAR_BW_QRY_MVIPCO17_0003
Refresh frequency
Daily - full reload
Daily - full reload
Filters
 
Investment type <> training


Specific Dimensions

  • Version : Active version (last version updated in Colmar), Y versions, Y-1 versions
  • Project type : Capitalized, Not Capitalized
  • Planned : Yes, No (Yes = the forecast amounts are taken into account in the GBU totals)
  • Bundle : list of bundles (def + key)
  • Project status : Approved (as soon as there is an authorized amount), Not Approved
  • Project approval status : Present approval status of the project
  • Project approval year : for a bundle, 1rst date of approval of the projects of the bundle


Scope

  • All the projects entered in Colmar with forecasted budget on the available versions



All the accesses must be validated by the
GBU Capex Coordinators
Authorisations' rights per GBU, Zone or Plant
Access form