François Carette
 Performance & Capex Reporting Manager - GEC


Marie-Line Ardito



General Description

Capability to have a view of the Forecasts by approval status and the related yearly authorized amount for a selected period
  • Colmar Capex/Capspend by approval status : based on the selected period, capability to see by GBU, Zone, Bundle, Plant :
The authorized amount
The total of Actuals
The total of Forecasts
split by approval status of the project


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
  
Approval Status
is the present approval status of the bundle

  
Authorized Amount
is the total approved budget of the project (linked to the project)


Sources

Capex/Capspend Actuals

Capex/Capspend Forecasts

Authorized Amount
Core query
BW_QRY_MPR_PS014_0011
BW_COLMAR_MVIPCO17_0001
BW_COLMAR_MVIPCO17_0001
QV query
QVCOLMAR_BW_QRY_MVIPCO17_0002
QVCOLMAR_BW_QRY_MVIPCO17_0003
QVCOLMAR_BW_QRY_MVIPCO17_0004
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