Supplier Purchase Price and Supplier Purchase Price Currency computation
This reference shows the computation behavior for various exchange rates, given input values, and their expected output values. Other components, namely Supplier Purchase Price and Supplier Purchase Price Currency, are also factors in the expected output results.
Analyze the tables of costing values for computation reference.
Note: This reference shows only the nature of the costing computation.
The given numbers and the values provided in the tables for the exchange rates, input
values, and expected values are examples only.
Legend:
- SPP - Supplier Purchase Price
- SPPC - Supplier Purchase Price Currency
Assumption: Value in Style Overview must be consistent with the Value in Style Grid.
Existing Behavior:
- Costing - No request has no value in Request
- When the Costing currency is updated, the values in Costing are also re-calculated based on the effective exchange rate.
| Exchange rates | ||
|---|---|---|
| Base Currency | USD | |
| 1 USD | = | .90 Euro |
| 1 USD | = | .80 GBP |
| 1 USD | = | 8 HKD |
| 1 USD | = | 20 MXN |
| 1 USD | = | 55 PHP |
View this table for input values:
| Source | Source SPP value | Source Currency | Default Currency - Partners |
|---|---|---|---|
| Request | 1,000.00 | PHP | PHP |
| Request | 1,000.00 | PHP | MXN |
| Request | 1,000.00 | PHP | MXN |
| Request | 1,000.00 | PHP | PHP |
| Request | 500 | MXN | MXN |
| Costing - No request | 1,000.00 | PHP | PHP |
| Costing - No request | 1,375.00 | PHP | MXN |
| Costing - No request | 20.00 | USD | MXN |
| Costing - No request | 500.00 | MXN | USD |
| Sourcing | 80.00 | GBP | GBP |
| Sourcing | 80.00 | GBP | USD |
| Sourcing | 135.00 | EUR | PHP |
| Sourcing | 135.00 | EUR | PHP |
View this table for expected values:
| SPP in Sourcing | SPPC in Sourcing | Costing Currency | SPP in Costing | SPP in Style Overview | SPPC in Style Overview | SPP in Style List | SPPC in Style List |
|---|---|---|---|---|---|---|---|
| 1,000.00 | PHP | PHP | 1,000.00 | 1,000.00 | PHP | 1,000.00 | PHP |
| 1,000.00 | PHP | PHP | 1,000.00 | 1,000.00 | PHP | 1,000.00 | PHP |
| 1,000.00 | PHP | USD | 18.00 | 1,000.00 | PHP | 1,000.00 | PHP |
| 1,000.00 | PHP | USD | 18.00 | 1,000.00 | PHP | 1,000.00 | PHP |
| 500 | MXN | PHP | 1,375.00 | 500 | MXN | 500 | MXN |
| 1,000.00 | PHP | PHP | 1,00 | 1,000.00 | PHP | 1,000.00 | PHP |
| 500 | MXN | PHP | 1,375.00 | 500 | MXN | 500 | MXN |
| 400.00 | MXN | USD | 20.00 | 400.00 | MXN | 400.00 | MXN |
| 25.00 | USD | MXN | 500.00 | 25.00 | USD | 25.00 | USD |
| 80.00 | GBP | GBP | 80.00 | 80.00 | GBP | 80.00 | GBP |
| 80.00 | GBP | USD | 100.00 | 80.00 | GBP | 80.00 | GBP |
| 135.00 | EUR | PHP | 8,250.00 | 135.00 | EUR | 135.00 | EUR |
| 135.00 | EUR | USD | 150.00 | 135.00 | EUR | 135.00 | EUR |