Differences

This shows you the differences between two versions of the page.

--- tender_management:creating_purchase_orders [2023/04/11 02:31] – Chris Petty
+++ tender_management:creating_purchase_orders [2023/05/03 11:02] – [Field Descriptions and Formulae] Gary Willetts
@@ Line 201: / Line 201: @@
-==== Field Descriptions and Formulae ====
+===== Field Descriptions and Formulae =====
-^ Column name   ^ Description    ^ Formula
+^ Column name   ^ Description    ^ Formula ^
-| **Adjust Cost** | The cost adjusted by currency, freight factor and pack size for direct comparison | Net Cost * (Default packsize/Quote packsize)|
+| **Price** | The price per pack offered by the supplier | |
+| **Net Cost** | The cost in local currency (i.e. datafile default currency) of the offered pack size, multiplied by freight factor | Offered price * currency rate * freight factor |
+| **Local Cost** | Alternative name for Net Cost |  |
+| **Total Cost** | The Total cost of the offered number of packs in Local Cost | Net Cost * Offered Number of Packs |
+| **Adjusted Cost** | The cost adjusted by currency, freight factor and item's default pack size for direct comparison between quotes | Net Cost * (Default packsize/Offered packsize)|