Cost Analysis (QPA)
To open the cost analysis window the action Cost Analysis is selected from the ribbon at the top of the page of a Quote Purchase Agreement.
On the page that opens, a cost analysis appears for every agreement line according to the premise that was entered in Estimated additional cost in an agreement. There are four main areas on the cost analysis page.
General
The general tab displays basic information about the agreement along with main totals; currency, total sales value, estimated contribution margin percentage, total net weight.
Lines
In the fast tab Lines, all the lines in the agreement are visible.
Field | Definition |
---|---|
Purch. Price to Vendor | Estimated purchase price in a receipt agreement linked to the delivery agreement. |
Purch. Price to Vendor (LCY) | Estimated purchase price in a receipt agreement linked to the delivery agreement in the local currency. |
Net Weight (BWU) Â | Net Weight from an agreement line in the base weight unit of the system. |
Estimated Base Unit Price (BWU) | The estimated base value of sold products assuming that the estimated purchase to vendor is realized, calculated in the base weight unit of a system (kg/lb). |
Estimated Base Unit Price (BWU) (LCY) | The estimated base value of sold products assuming that the estimated purchase price to vendor is realized, calculated in the base weight unit of the system (kg/lb). Amount displayed in local currency. |
Estim. Base Value  | The estimated base value of sold products assuming that the estimated purchase to vendor is realized. This is in reality the estimated product use that is posted at the sale. Calculated as = ´Net Weight (BWU) x ´Estimated Base Unit Price (BWU)´. |
Estim. Base Value (LCY) | The estimated base value calculated in local currency. |
Estim. Add. Unit Cost (BWU) | The proportion of a line in the estimated additional cost of a sale in the base weight unit of the system (kg/lb). |
Estim. Add. Unit Cost (BWU) (LCY) | The proportion of a line in the estimated additional cost of a sale in the base weight unit of the system (kg/lb) and in the local currency. |
Total Unit Cost (BWU)  | Total unit cost in the base weight unit of the system (kg/lb). Calculated = ´Estimated Base Unit Price (BWU)´ + ´Estim. Add. Unit Cost (BWU)´. |
Total Unit Cost (BWU) (LCY)  | Total unit cost in the base weight unit of the system (kg/lb). Calculated = ´Estimated Base Unit Price (BWU) (LCY)´ + ´Estim. Add. Unit Cost (BWU) (LCY)´. Amount displayed in the local currency of a company. |
Estim. Add. Cost Amount  | Amount of estimated additional cost in an agreement line. Calculated = ´Net Weight (BWU)´ x ´Estim. Add. Unit Cost (BWU)´. |
Estim. Add. Cost. Amount (LCY)  | Amount of estimated additional cost in an agreement line. Calculated = ´Net Weight (BWU)´ x ´Estim. Add. Unit Cost (BWU) (LCY)´. Amount displayed in the local currency of a company. |
Total Cost Amount  | The total cost amount of an agreement line. Calculated = ´Estim. Base Value´ + ´Estim. Add. Cost Amount´. |
Total Cost Amount (LCY)  | The total cost amount of an agreement line in the local currency. Calculated = ´Estim. Base Value (LCY)´ + ´Estim. Add. Cost Amount (LCY)´. |
Contrib. Margin % | Contribution margin calculated based on premises in agreement lines in addition to estimated cost of a sale. Calculated: (´Total Cost Amount´ / ´Estim. Base Value´) x 100. |
Total Cost
In the tab Total Cost the value and cost of all lines in an agreement are summed up. The summations are displayed both in the currency of an agreement and in the local currency of a company.
Field | Definition |
---|---|
Estim. Base Value  | Total estimated base value of sold products assuming that the estimated purchase to vendor is realized. This is the estimated COGS that is posted at point of sale. Calculated as total of all lines = ´Net Weight (BWU) x ´Estimated Base Unit Price (BWU)´. |
Estim. Add. Cost Amount  | The total amount of estimated additional cost of all agreement lines. Calculated total for all lines of an agreement = ´Net Weight (BWU)´ x ´Estimated Additional Unit Cost (BWU)´. |
Total Cost Amount | Total cost amount from all agreement lines. Calculated for all agreement lines = ´Estim. Base Value´ + ´Estimated Add. Cost Amount´. |
Total Unit Cost (BWU)  | Total unit cost in the base weight unit of the system (kg/lb). Calculated in total for all lines of an agreement = (´Estimated base unit price (BWU)´ + ´Estimated Additional Unit Cost (BWU)´) / Net Weight (BWU). |