Page History

General Description
Capability to have a view of the Forecasts by

the reason of investment for a selected period (Year or/and Quarter)Colmar Capex/Capspend reason by zone : % of each zone of the total Capex/Capspend Forecasts with a split by general reason of investment

approval status and the related yearly authorized amount for a selected period

. Drilldown to the investment reason by clicking into the graph

Colmar Capex/Capspend

reason type by GBU : ranking of GBUs amount and % Capex/Capspend Forecasts for a selected period with a split by the general reason of investmentDetails

by approval status : based on the selected period, capability to see by GBU, Zone, Bundle, Plant :

The authorized amount

The total of

Capex/Capspend Forecasts (amount and %) of the period with a split by general reason and the reason of investment (key and def).

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

General Reason

Approval Status

is the present approval status of the bundle

Image Added

directly updated by the reason of investment according to the Capex 01 procedure

General Reason

Authorized Amount

is

the main reason for investment

Image Removed

the total approved budget of the project (linked to the project)

Image Added

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

Info

icon	false
title	Authorization & Rights

Page tree

Page History

Versions Compared

Old Version 1

New Version Current

Key

François Carette

Performance & Capex Reporting Manager - GEC

Marie-Line Ardito

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

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

General Reason

Approval Status

is the present approval status of the bundle

directly updated by the reason of investment according to the Capex 01 procedure

General Reason

Authorized Amount

is

the total approved budget of the project (linked to the project)

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

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

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