Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 21 Next »

KPI inställningar finnes i menyn för inställningar. Här kan man kalibrera och sätta upp KPI:er som visas i dashboarden i systemet.

Översikt

KPI (Key Performance Indicators) är indikatorer som hjälper dig att mäta och hålla koll på din verksamhet och ditt system. Under KPI inställningar kan man sätta upp dessa KPI:er.

När man har satt upp en KPI i systemet så kan man sedan hitta denna på dashboarden i systemet. Dashboarden är den sida man välkomnas med när man loggar in i systemet och kan även nås om man klickar på Extend Think Small-ikonen.

Man kan även klicka på en KPI och få mer utförlig information:

Val av KPI

Offer Value

DescriptionA total value of active offers. All offers will be converted to base currency. With active offers, we mean all offers that are not declined, accepted or cancelled. An offer that has expired, will be count as active.
Source / logic

Ones per day the KPI will log to the total sum of all offers that are not accepted, declined or cancelled. If a offer is overdue it will be counted. The values of the offers will be converted to base currency.   

ResultA value without decimals
GroupingThe KPI could be for the whole company or per salesmen
TargetsA higher value will be handled as positive


Offers to Order Conversion Values

DescriptionA ratio of offers value that was accepted compared to decline during the period. will be expressed in % calculated by the value of accepted offers compared to the value of declined offers.
Source / logic

Will include all offer rows that are set to either accepted or declined/cancelled during the last 30 days.

The KPI divides the value of accepted rows with the value of rejected/cancelled.     

ResultA % without decimals
GroupingThe KPI could be for the whole company or per salesmen
TargetsA higher % will be handled as positive


Offers to Order Conversion Quantity

Description

A ratio of number of offers that was accepted compared to decline during the period. will be expressed in % calculated by the number of accepted offers compared to the number of declined offers.

Source / logic

Will include all offer that are set to either accepted or declined/cancelled during the last 30 days.

The KPI divides the number of accepted offers with the number of rejected/cancelled.     

ResultA % without decimals
GroupingThe KPI could be for the whole company or per salesmen
TargetsA higher % will be handled as positive


Offer time to decision 

Description

An average number of days from create date to decision date for offers during the last 30 days. Decision date is the date where the offer either was accepted, declined.

Source / logic

Includes all offers that has either got status of accepted or declined for the period. Will count the total number of days from created to “decision date” and divide that with the number of offers.  

ResultA value without decimals
GroupingThe KPI could be for the whole company or per salesmen
TargetsA lower value will be handled as positive


Revenue vs Forecast 30 days

Description

A running 30 days ratio of invoiced value compared with budget value. Budget is noticed in base currency and the sales are converted to base currency in this KPI.

Source / logic

Will sum all invoiced values the last 30 days and dived with the sum of prognosed values for the same period.
The invoiced value will be converted to base currency. prognosed values are always in base currency 

Result

The result will be logged as a %, no decimals

GroupingThe KPI could be for the whole company
TargetsA higher value will be handled as positive


Revenue vs Forecast 7 days

Description

A running 7 days ratio of invoiced value compared with budget value. Budget is noticed in base currency and the sales are converted to base currency in this KPI.

Source / logic

Will sum all invoiced values the last 7 days and dived with the sum of prognosed values for the same period.
The invoiced value will be converted to base currency. prognosed values are always in base currency 

Result

The result will be logged as a %, no decimals

GroupingThe KPI could be for the whole company
TargetsA higher value will be handled as positive


Orders

Order stock value

Description

A total value of orders that are not delivered. All orders will be converted to base currency if they are made in other currency.

Source / logic

Will sum the value of all rows that are not picked at warehouse or delivered from supplier.

The value will be converted to base currency 

Result

A value without decimals

GroupingThe KPI could be for the whole company or per salesmen
TargetsA higher value will be handled as positive

Back Order Value

Description

Back Orders value. A sum of the value of all backorders. Expressed as a total value in your base currency. (backorders in other currencies will in this calculation be converted to base currency)

Source / logic

Will sum the value of all rows that are typed as backorder.

The value will be converted to base currency 

Will only be applied on warehouse delivered products. (not direct delivery’s, services or other supply mode typed products) 

Result

A value without decimals

GroupingThe KPI could be for the whole company or per salesmen
TargetsA lower value will be handled as positive

Average Gross margin

Description

An 30 days running average of the gross margin on orders. Will be expressed in %

Source / logic

Will calculate an average ratio between gross margin and revenue for the last 30 days orders.

Will use the order and order date as filter, so adjustments / change of orders price/cost in the invoice will not be covered by this KPI

Result

A % without decimals

GroupingThe KPI could be for the whole company or per salesmen
TargetsA higher value will be handled as positive

Average Order Size

Description

A 30 days running average of the order size. Orders in different currencies will be converted to base currency.

Source / logic

Calculate the average size of the orders for the last 30 days. Will use the order and order date as filter, so adjustments / change of orders price/cost in the invoice will not be covered by this KPI

Result

A value without decimals

GroupingThe KPI could be for the whole company or per salesmen
TargetsA higher value will be handled as positive


Canceled Order Value

Description

A sum of cancelled, annulled or deleted order rows the last 30 days. This is a value of orders that we got from customers, but for some reason didn't manage to deliver. All values will be converted to base currency

Source / logic

We sum the value of all order rows that are cancelled. annulled or deleted the last 30 days. The values will be converted to base currency.   

Result

A value without decimals

GroupingThe KPI could be for the whole company or by salesmen
TargetsA lower value will be handled as positive


Warehouse

Inventory Value

Description

A total inventory value

Source / logic

Will include all products stored at a warehouse.

If the KPI is set up to handle all warehouses, the KPI will only include warehouses where the owner type is equal to Client. (not warehouses owned by customers or suppliers

If KPI is set up to handle a specific warehouse it could handle any warehouse.

Result

A value without decimals

GroupingThe Kpi could be for the whole company or per warehouse
TargetsA lower value will be handled as positive

Inventory Turnover

Description

Inventory turn over value. The result will be expressed as how many times the inventory will be consumed on a yearly basis. The calculation will be done on cost of sold gods and average inventory value the last 30 days.

Source / logic

The cost of goods sold for the period will be divided with the average inventory value for the period. 

The values will be calculated for the latest 30 days and then multiplied with 12 to get a yearly value.

(COGS 30 days/Average Inventory 30 days ) x 12 = Inventory turn over

Result

A value with 2 decimals

GroupingThe Kpi could be for the whole company or per warehouse
TargetsA higher value will be handled as positive

Order to shipment

Description

An average number of days between the order date and the ship date

Source / logic

We will look at all orders that has been delivered during the last 30 days. we will sum the days from order to shipment day for all orders and dived that with the number of orders.

Result

A value with 2 decimals

GroupingFor the whole company or for a specific warehouse. direct delivery is also a grouping possibility.
TargetsA lower value will be handled as positive

Promised vs actual fulfillment

Description

A 30 days running average number of days between the first promised date and the actual date the customer got the delivery.

This will measure how accurate the first order confirmations are.

Source / logic

When a order is placed in XTND Backend a expected delivery date is calculated and send to customer in a order confirmation. This date is calculated based on known balances, purchases and leadtimes.

This KPI will log the difference between what we promised the customer in the order confirmation and the real delivery time.


Result

The result will be value with 2 decimals


Grouping

For the whole company or for a specific warehouse. direct delivery is also a grouping possibility.

Targets

A higher value is handled as positive

Production Time

Description

A 30 days average of hours between time when order was released to warehouse for picking, and the when the confirmation of picking was done. 

Source / logic

Counting of hours between when the order was released to warehouse for picking, and when the warehouse confirmed the picking. The hours are summed for the last 30 days and divided with the number of orders. The purpose is to get a trend line/ kpi about how the warehouse is performing.

Could be used on direct delivery also, then the calculation are between when the purchase is made and delivery confirmed by supplier


Result

The result will be value with 2 decimals 

Reference

For the whole company or for a specific warehouse. direct delivery is also a grouping possibility.

Targets

A Lower value is handled as positive


Financial

Orders to invoice 

Description

A average of days from order date to invoice date. Will be calculated as an running average for the last 30 days invoices.

Source / filter

Count the average days from order date to invoice date for the last 30 days

Will use the invoice date as filter in the query. 

Result

The result will be logged as a value without decimals

Reference

Could be handled on the whole company or by salesmen

Targets

A lower value is handled as positive


Accounts receivable outstanding 

Description

A value of all customer invoices (accounts receivable) not paid. Invoices in other currencies will be converted to base currency.

Source / filter

We will sum the value of all unpaid invoices. The values are converted to base currency

We will sum this every night and we will not adjust a value if the pay date is entered as a date in the past.

Result

The result will be logged as a number value with 2 decimals 

Reference

For the whole company and by salesmen

Targets

A lower value is handled as positive


Account receivable, credit invoices ratio

Description

A 30 days running average ratio of the value of credit invoice vs total invoice value.

Source / filter

We will sum all credit invoices created last 30 days. Divide this with total value of all invoices same period

The values converted to base currency  

Result

The result will be logged as a % value with  0 decimals 

Reference

For the whole company and by salesmen

Targets

A lower value is handled as positive

  

Accounts receivable payment days 

Description

A 30 days running average of number of days from invoice date to full payment. 

Source / filter

We will calculate the average days for all fully paid invoices. We include all invoices where fully paid status has occurred the last 30 days.  

Result

The result will be logged as a number value with  2 decimals 

Reference

For the whole company and by salesmen

Targets

A lower value is handled as positive

  

Accounts receivable outstanding, overdue 

Description

A value of all customer invoices (accounts receivable) where the pay date has past. Invoices will be converted to base currency in this KPI

Source / filter

We will sum all unpaid invoices where pay date has past with more than 24hours.  

The values are converted to base currency. We will sum this every night and we will not adjust a value if the pay date is entered as a date in the past.

Result

The result will be logged as a number value with  2 decimals

Reference

For the whole company and by salesmen

Targets

A lower value is handled as positive



Logistics

Orders On Time In Full

Description

A 30 days running ratio of how many orders delivered on time and in full.

See the knowledge base for more details about how this is calculated.

The result will be expressed in %

Source / filter

At order registration a internal picking time are defined on each row. This is calculated based on order stop time and picking lead time. (your service levels that you communicate with your customers)

This date is handled as a timestamp when the warehouse must have confirmed the order as picked. If we don´t meet this date we handle that order as NOT in Time.
We also check if there are any products on the order wasn´t delivered, If there are, we log that as NOT IN FULL. 

We will compare number of rows that are NOT on time and in full, with the total numbers of rows picked during the period.

We will aggregate rows to order level, the value will be on order level.

We will log all rows that are NOT warehouse handled as  delivered on time.

Result

The result will be logged as a %, 2 decimals  

Grouping

For the whole company or by warehouse.

Targets

A higher value is handled as positive


Orders On Time

Description

A 30 days running ratio of how many orders delivered on time.

See the knowledge base for more details about how this is calculated.

The result will be expressed in %

Source / filter

At order registration a internal picking time are defined on each row. This is calculated based on order stop time and picking lead time. This date is handled as a timestamp as when the warehouse must have confirmed the order as picked. If we don´t meet this date we handle that as NOT in Time.

We will compare number of rows that are NOT on time and in full, with the total numbers of rows picked during the period.

 We will aggregate rows to order level, the value will be on order level.

 We will log all rows that are NOT warehouse handled as  delivered on time.


Result

The result will be logged as a %, 2 decimals

Grouping

For the whole company or by warehouse.

Targets

A higher value is handled as positive


Orders In full

Description

A 30 days running ratio of how many orders delivered in full.

See the knowledge base for more details about how this is calculated.

The result will be expressed in %

Source / filter

When a row are confirmed as picked we log if there where any deviation in picked quantity  compared with asked quantity.

We will compare number of rows that are NOT in full  with the total numbers of rows picked during the period.

We will log all rows that are NOT warehouse handled as  delivered in full. 

Result

The result will be logged as a %, 2 decimals 

Reference

For the whole company or by warehouse.

Targets

A higher value is handled as positive


Rows On Time In Full 

Description

A 30 days running ratio of how many order rows delivered on time and in full.

See the knowledge base for more details about how this is calculated.

The result will be expressed in %

Source / filter

Count rows with status of both in full and on time, divide that with total number of rows for the period  

Result

The result will be logged as a 2 decimal % value 

Grouping

For the whole company or by warehouse.

Targets

A higher value is handled as positive


Row On Time 

Description

A 30 days running ratio of how many order rows delivered on time.

See the knowledge base for more details about how this is calculated.

The result will be expressed in %

Source / filter

Count rows with status of on time, divide that with total number of rows for the period 

Result

The result will be logged as a %, 2 decimals 

Grouping

For the whole company or by warehouse.

Targets

A higher value is handled as positive


Row In full 

Description

A 30 days running ratio of how many order rows delivered in full.

See the knowledge base for more details about how this is calculated.

The result will be expressed in %

Source / filter

Count rows with status of in full, divide that with total number of rows for the period 

Result

The result will be logged as a %, 2 decimals 

Reference

For the whole company or by warehouse.

Targets

A higher value is handled as positive

På denna sida:


  • No labels