Description
Sum foreign price×quantity and convert plus fees.
Food affordability calculations combine prices, basket quantities, currency factors and available resources. Fixed-basket arithmetic does not by itself account for substitution, actual benefit rights or an individual household's circumstances.
Sum foreign price×quantity and convert plus fees.
When to use this tool
Use Market Basket Local Currency Exchange Term when you need a supplied food-cost or purchasing-power calculation.
How to use the tool and how it works
- Enter foreignPrices, quantities, localPerForeign, localFees. Keep parallel arrays aligned. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read foreignCost, localCost. Use the output convention below.
Require aligned nonnegative prices/quantities, positive localPerForeign and nonnegative localFees. Sum foreign price×quantity and convert plus fees.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| foreignPrices | Foreign Prices | Required. Array of finite number; maximum items 256. |
| quantities | Quantities | Required. Array of finite number; maximum items 256. |
| localPerForeign | Local Per Foreign | Required. Finite number; strictly above 0. |
| localFees | Local Fees | Required. Finite number; minimum 0. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| foreignCost | Foreign Cost | Required. Finite number. |
| localCost | Local Cost | Required. Finite number. |
{
"input": {
"foreignPrices": [
10,
20
],
"quantities": [
2,
3
],
"localPerForeign": 2,
"localFees": 5
},
"output": {
"foreignCost": 80,
"localCost": 165
}
}Limitations and assumptions
- Exchange factor is local units per foreign unit; no current rate or basket specification is selected. Units, price date and fee scope must be consistent.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Align basket contents, currency, price date and household scope before comparison. Verify actual assistance rules and seek the appropriate financial or service guidance for consequential decisions.
References
Similar or alternative tools
- Household Food Budget Price Shock Term
Sum baseline cost, then cost with each price×(1+change), and subtract shocked cost from budget.
- Food Voucher Purchasing Power Price Factor
Divide value by each price and return old/new price ratio.