(KPI) Key performance indicator

Transport Mode

I have asked Agathe

It’s the transport mode of the freight, if null or no freight, it’s the transport mode of the OP.

Country

Mission

Project Code

Order Type

It shows the order type as in the OP

IsEmergency

It filters for orders that are processed as urgent in MSF Supply

IsTechOrder

How does it work? Should be based on the mission ref. (ending with TEC…)

it’s done this way

IsKC

Keep Cool, what category exactly? all the “KC..” ?

KC1    Keep Cool 2-8 °C

KC1*    Keep Cool 2-8 °C

KC1RT    Keep Cool 2-8 °C - Dangerous goods

KC2    Keep Cool 2-8 °C

KC2*    Keep Cool 2-8 °C 

KC2RT    Keep Cool 2-8 °C - Dangerous goods

KC2SA    Keep Cool 2-8 °C

KC3    Keep Freeze -20°C

KC3*    Keep Freeze -20°C

KC3RT    Keep Freeze -20°C - Dangerous goods

KC4    Keep Freeze -20°C

KCC    Keep Cool 2-8 °C

KPR    Check if import license necessary - Split order

PSA    Import license required - Split order

PSB    Check if import license necessary

PSBPR    Check if import license necessary - Split order

RTR    Dangerous goods - Regulated transport

RTRPR    Dangerous goods - Regulated transport - Check if import license necessary - Split order

RTRTC    Dangerous goods - Regulated transport - Controlled temperature <25 °C

SARV    Controlled temperature <25 °C

SBB    Controlled temperature <25 °C

STP    Import license required - Split order

TC     Controlled temperature <25 °C

All the KCs : KC1/KC2/KC3/KCM/KC1PB/KC1RT/KC2*/KC2RT/KC2SA/KC2PB/KC3*/KC3SA/KC1*/KC4

IsDgr

Dangerous goods (where you retrieve the info? fiche article ?)

Articles with categorie : RTR/KC2RT/RTRPR/KC1RT/KC3RT/RTRTC as dangerous for us is more “transport regulated”

IsArv

Antiretroviral items (where you retrieve the info? fiche article ?)

Articles with categorie : KC3SA/SARV/SBB

IsTc

Controlled temperature items ( <25 °C ) which of the above categories?

Articles with categorie : TC/RTRTC/SBB/PSA/PSB/PSBPR/STP

IsArticleStup

Psychotropic items which of the above categories?

Articles with categorie: STP/PSA/PSBPR

Année/ Trimestre

Year of order creation at MSF Supply, i.e. not order creation in the field nor budgetary year. Can you rename them year / Q1, Q2, …

It’s based on the order confirmation date.

When you are connected in english, should be translated automatically.

Origin Order Count

Number of Portal order (correct?). If so, we can rename it Portal Order Count ?

Done

Order Count

Number of OP (Operations at MSF Supply)

Orderline Count

Number of order lines (OP)

Average Lines per Order

Order Count / Orderline Count (OP)

LOG Orderline Count

MED Orderline Count

Ordered Amount

Goods invoiced amount

yes it’s goods here.

LOG Ordered Amount

MED Ordered Amount

% LOG Amount

% MED Amount

% LOG Orderlines

% MED Orderlines

Transport Mode

I have asked Agathe

idem orders

Dispatch Code

Delivery code defined in MSF Supply, usually associated with the capital

Country

Mission 

Project Code

Shipment Type

REGULATION ,but in Transport Mode we have REGULARISATION

I removed regul from both reports.

IsDgr

Dangerous goods (where you retrieve the info? fiche article ?)

idem orders

IsKc

Keep Cool, what category exactly? all the “KC..” ?

idem orders

Année/ Trimestre

Year ETA ? Can you rename them year / Q1, Q2, …

The report here is based on the Shipment Date

idem orders

Transport File Count

Number of “dossiers”, i.e. freight numbers. Rename it Freight Count

not sure as you have the “shipment count” just aside

Shipment Count

How is it calculated?

It’s for one dispatch code, one trnaport mode, one departure date.

this is the freight for me. To be seen with Agathe ?

Packing Volume m3

Can we rename it Volume m3 ?

done

Packing Weight Kg

Can we rename it Weight Kg ?

done

Packing transport Costs

Can we rename it Transport Cost ?

done

Packing Goods Value

Can we rename it Goods Value ?

done

Total transport €/m3

Transport cost / volume

Total transport €/kg

Transport cost / weight

Shipment Count per Month

Transport Mode

To ask Agathe for an explanation of the sub-transport modes. Can we remove “néant”?

I do not see a “néant” here, I removed it from the other reports.

Dispatch Code

Country

Project Code