Forecast by Investment type

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 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 : < 1 MEUR

• Medium : ≥ 1 MEUR and < 10 MEUR

• Major : ≥ 10 MEUR

• Reserve :

• Demolition :

• Preliminary :

• Other : <> Current, Medium, Major

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

• 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

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