Avg Ordering Interval

This is the average amount of days between orders

Avg Price

Avg Price

[Ordered Value] / [Ordered Quantity]

Avg Price / MSI

Avg Price / MSI

[Ordered Value] / [Ordered MSI]

Avg Price /SQM

Avg Price /SQM

[Ordered Value] / [Ordered SQM]

Customer Count

See Customer Count.

Diff Order Recency vs Avg Ordering Interval

This is the difference between the Avg Ordering Interval and the Order Recency

Diff Order Recency vs Avg Ordering Interval %

This is the difference in % between the Avg Ordering Interval and the Order Recency

Order Count

Amount of unique Orders

Order Line Count

Amount of unique records in the table (Sales orders, Stock orders, RMA, Call off contracts & Invoice Line Items)

Order Recency

This is the amount of days since the last order

Packing Slip Count

Amount of unique Packing Slips

Ordered Cost

This is the "predicted cost" at the time of creating the sales order. It gives a first indication of the "projected margin" of the intake.

Depending if a job is already created based on the sales order, we take the costs either from the "job", or the "reference calculation".

In case there is a job linked, we first recalculate the total costs within the job to a cost per piece. And afterwards we multiply the ordered quantity with the cost per piece.

In case there is no job linked, we do the same but with the costs from the refer­ence calculation.

Special case: Some orders are not produced, but bought externally. In this case we take the invoiced price, if invoiced, from the linked purchase order. If not invoiced, the ordered price.

Ordered Margin

Ordered Margin

[Ordered Value] - [Ordered Cost]

Ordered Margin %

Ordered Margin %

[Ordered Value] / [Ordered Cost]

Ordered MSI

Total surface of the ordered quantity (msi)

Calculation:

= ([Surface MSI] / 1000) x [Ordered Quantity]

Ordered MSI Avg

Average MSI

Average [Ordered MSI] / [Sales Order Line Count] 

Ordered MSI Avg PY

Average MSI per sales order line of the previous year

Average [Ordered MSI] / [Sales Order Line Count] of the previous year 

Ordered MSI PY

[Ordered MSI] of the previous year

Ordered MSI YoY

Difference between [Ordered MSI] and [Ordered MSI PY]

Ordered MSI YoY %

Difference in % between [Ordered MSI] and [Ordered MSI PY]

Ordered Quantity

Ordered quantity (Note: Take into account the price category (/kg, /m, /1000, ...) when using this measure.)

Ordered Quantity PY

[Ordered Quantity] (Ordered Quantity) of the previous year

Ordered Quantity YoY

Difference between [Ordered Quantity] (Ordered Quantity) and [Ordered Quan­tity PY] (Ordered Quantity previous year)

Ordered Quantity YoY %

Difference in % between [Ordered Quantity] (Ordered Quantity) and [Ordered Quantity PY] (Ordered Quantity previous year)

Ordered SQM

Total surface of the ordered quantity (m²)

Calculation:

= ([Surface SQM] / 1000) x [Ordered Quantity]

Ordered SQM Avg

Average square meters per sales order line

Average [Ordered SQM] / [Sales Order Line Count] 

Ordered SQM Avg PY

Average square meters per sales order line of the previous year

Average [Ordered SQM] / [Sales Order Line Count] of the previous year

Ordered SQM PY

[Ordered SQM] (Ordered SQM) of the previous year

Ordered SQM YoY

Difference between [Ordered SQM](Ordered SQM) and [Ordered SQM PY](Ordered SQM previous year)

Ordered SQM YoY %

Difference in % between [Ordered SQM] and [Ordered SQM PY]

Ordered Value

The value of the ordered quantity. Value in the accountancy currency

Ordered Value Cur

The value of the ordered quantity. Value in the currency of the customer

Ordered Value PY

[Ordered Value] (Ordered Value) of the previous year

Ordered Value Rolling Avg 3

Average [Ordered Value] of the last 3 *Timeperiod* (days, weeks, months, ...)
The biggest benefit of a rolling average is that a trend is a lot more visible.

Peaks are taken out because of using averages over time.

Ordered Value Rolling Avg 7

Average [Ordered Value] of the last 7 *Timeperiod* (days, weeks, months, ...)

The biggest benefit of a rolling average is that a trend is a lot more visible.

Peaks are taken out because of using averages over time.

Ordered Value YoY

Difference between [Ordered Value YTD] and [Ordered Value YTD PY]

Ordered Value YoY %

Difference in % between [Ordered Value YTD] and [Ordered Value YTD PY]

Ordered Value YTD

[Ordered Value] Year-to-date of the current year

Ordered Value YTD PY

[Ordered Value] Year-to-date of the previous year

Ordered Value YTD YoY

Difference between [Ordered Value YTD] and [Ordered Value YTD PY]

Ordered Value YTD YoY %

Difference in % between [Ordered Value YTD] and [Ordered Value YTD PY]

Ordered Net KG

Ordered net weight in kg

Calculation:

= ([Net KG1000 Pcs] / 1000) x [Ordered Quantity]

Ordered Net LBS

Ordered net weight in lbs

Calculation:

= ([Net LBS1000 Pcs] / 1000) x [Ordered Quantity]

Days Confirmed To Real Ship­ment Avg

This measure gives the amount of "working days" the shipment was actually shipped compared to the confirmed shipment date.

Calculation:

= ([Shipment Date Real] - [Shipment Date Confirmed])/[Is Shipped Count]

Days Confirmed To Real Ship­ment Median

Median [Days Confirmed To Real Shipment] (Days Confirmed To Real Shipment) per Shipped Sales Order Line

Days Expected To Real Ship­ment Avg

Days Expected To Real Shipment Avg

[Days Expected To Real Shipment] / [Is Shipped Count]

Days Expected To Real Ship­ment Median

Median [Days Expected To Real Shipment] per Shipped Sales Order Line

Days Order To Confirmed Ship­ment Avg

The number of calendar days between OrderDate and ShipmentDateConfirmed.

[Days Ordered To Confirmed Shipment] / [Sales Order Line Count]

Calculation:

= ([Shipment Date Confirmed] - [Order Date])/[Sales Order Line Count]

Days Order To Expected Ship­ment Avg

[Days Ordered To Expected Shipment] / [Sales Order Line Count

Days Order To Original Ship­ment Avg

[Days Ordered To Original Shipment] / [Sales Order Line Count]

Days Order To Real Shipment Avg

The number of calendar days between OrderDate and ShipmentDateReal.

[Days Ordered To Real Shipment] / [Is Shipped Count]

Calculation:

= ([Shipment Date Real] - [Order Date])/[Is Shipped Count]

Diff Shipped Ordered MSI %

[Shipped MSI] / [Ordered MSI]

Diff Shipped Ordered Quantity

This value shows if there was a difference between the ordered and the shipped quantity.

Calculation:

= [Shipped Quantity] - [Ordered Quantity]

Diff Shipped Ordered Quantity %

Difference in % between [Shipped Quantity] (Shipped Quantity) and [Ordered Quantity] (Ordered Quantity)

Diff Shipped Ordered SQM %

Difference in % between [Shipped SQM] (Shipped SQM) and [Ordered SQM] (Ordered SQM).

Shipped Cost

This is the cost of the sales order, based on the quantity shipped.

Once the order is shipped, we store the "stock value" of the shipped goods.

This stock value is used to calculate the "Shipped Cost".

Shipped Margin

Shipped Margin

[Shipped Value] - [Shipped Cost]

Shipped Margin %

Shipped Margin %

[Shipped Value] / [Shipped Cost]

Shipped MSI

Total surface of the shipped quantity (msi).

Calculation:

= ([Surface MSI] / 1000) x [Shipped Quantity]

Shipped Net KG

Shipped net weight in kg

Shipped Net LBS

Shipped net weight in lbs

Shipped On Time Confirmed

Shipped On Time Confirmed

[Shipped On Time Confirmed] - [Order Line Count]

Shipped On Time Confirmed %

Shipped On Time Confirmed in %

[Shipped On Time Confirmed] / [Order Line Count]

Shipped Quantity

Shipped quantity (Note: Take into account the price category (/kg, /m, /1000, ...) when using this measure.)

Shipped SQM

Total surface of the shipped quantity (m²)

Calculation:

= ([Surface SQM] / 1000) x [Shipped Quantity]

Shipped Value

The value of the shipped quantity. Value in the accountancy currency.

Calculation:

= ([Shipped Quantity]/[Ordered Quantity])x[Ordered Value]

Shipped Value Cur

The value of the shipped quantity. Value in the currency of the customer.

Calculation:

= ([Shipped Quantity]/[Ordered Quantity])x[Ordered Value Cur]