Metrics
Metrics
Metrics
The following metrics are used in ZEUS Purchase pivot tables:
| LABEL |
UNIT |
MEANING |
FORMULA |
EXAMPLE OF USE |
| Quantity |
unit of measurement |
Quantity |
|
How many items from category x did we purchase from supplier y this year? |
| Packages |
unit of measurement |
Quantity |
|
How many packages of items from category x did we purchase from supplier y this year? |
| Purchase price |
Currency |
Value |
|
What was the purchase price of individual item? |
| Value w/o costs |
currency |
Value |
quantity x price |
What was the value of items without costs from category x purchased from supplier y this year? |
| Purch. value |
Currency |
Value |
|
What was the tota purchase value from category x purchased from supplier y this year? |
| No. of purchases |
|
number of purchases |
number of invoices |
From which suppliers do we purchase most often? |
| Average value/invoice |
currency |
the average value of purchases |
VALUE (IN CURRENCY) divided by NUMBER OF INVOICES |
From which suppliers did we purchase the greatest value of goods at once? |
| Average waiting time |
days |
the average number of days it takes to deliver a purchase |
TOTAL NUMBER OF DAYS TO WAIT divided by NUMBER OF INVOICES |
For goods from which suppliers do you wait the longest?
|
| Average days overdue |
|
average number of late days |
TOTAL NUMBER OF LATE DAYS divided by NUMBER OF INVOICES |
How many days late were deliveries from supplier x? |
| Change in quantity |
Unit of meaurement |
|
|
Quantity of item stock afther all the purchases and sales on seletedd period |
| Change in value |
Value |
|
|
Value of item stock afther all the purchases and sales on seleted period |
* - purchase value plus costs
** - number of days from day order placed to day goods received
*** - number of days from the Deliver By date to the day the goods were received
Instructions for Use
Related Topics: