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

Compare with Current View Page History

« Previous Version 2 Next »

General Description

Capability to have a view of the Forecasts by investment type for a selected period (Year or/and Quarter) :
  1. Colmar Capex/Capspend by Investment type : Amount and % of forecasted budget for a selected period with a split by investment type
  2. Colmar Capex/Capspend Investment type by GBU : ranking of GBUs amount and %  forecasted budget for a selected period with a split by investment type
  3. Colmar Capex/Capspend Investment type bridge : comparison of Y-1 Capex/Capspend actuals vs Y Capex/Capspend forecasted budget with the detailed part of the gap for each investment type
  4. Details : based on the selected period, capability to see by GBU, Zone, Bundle, Plant :
      • The total of Forecasts of the period with a split by investment type and the related % of each investment type vs the total of forecasts
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)

Capex Forecastis 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 Forecastis the prevision of Capspend filled and updated by the GBU into Colmar
  
Investment Type

is the categorization of the investment

  • Current : < 1 MEUR
  • Medium : ≥ 1 MEUR and < 10 MEUR
  • Major : ≥ 10 MEUR
  • Reserve :
  • Demolition :
  • Preliminary :
  • Other : <> Current, Medium, Major
SourcesCapex/Capspend ActualsCapex/Capspend Forecasts
Core queryBW_QRY_MPR_PS014_0011BW_COLMAR_MVIPCO17_0001
QV queryQVCOLMAR_BW_QRY_MVIPCO17_0002QVCOLMAR_BW_QRY_MVIPCO17_0003
Refresh frequencyDaily - full reloadDaily - 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
  • 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

 

KPI Owner

François Carette
Performance & Capex Reporting Manager - GEC

D&PS Expert

  • Marie-Line Ardito

Authorization & Rights

 

 

 

 

 

 

 

 

 

 

 

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels