Table of contents
- When the dollar rises from €0.82 to €0.88, the cost of a heater with imported components grows from €44.00 to €45.93, and the margin of the wholesale price list falls from €16.00 to €14.07 (from 26.7% to 23.5%).
- The dollar price list is recalculated at the new rate with the "Calculate prices" button. The local-currency price lists go up with a bulk price change by a rule, for example +3.2% with an "Effective from" date.
- The "Gross profit" report shows the items where the margin has already dropped, and the "Sales → Prices" section puts the price lists side by side to check the result.
The company is fictional. Every action in Bimp is a real product feature. The rates and figures in the example are invented, and the arithmetic can be checked on a calculator.
Price recalculation when the exchange rate changes keeps the margin from eroding while the price list sits in an old file. For a fictional heater that sells wholesale for €60.00, a rise of the dollar from €0.82 to €0.88 lifts the cost price from €44.00 to €45.93. The margin falls from €16.00 to €14.07, and a price increase of 3.2% brings it back.
The owner of WarmHome Heaters learned about it in the third week. The accountant showed the purchase invoice for components, and it turned out that dealers had been buying at the price list built on €0.82 all that time. On every heater the plant received about €1.93 less, and it has three price lists that were corrected by hand.
Why does the price list lag behind the exchange rate?
WarmHome Heaters (a fictional company) makes electric heaters and employs 150 people. Heating elements, thermostats and part of the electronics are bought for dollars, and these components make up 60% of the cost price. Sales go wholesale to dealers, to a marketplace and under direct contracts, which means three different price lists in Excel.
When the rate changes, somebody has to open every file, recalculate the prices and send the new version to the managers. It takes a day or two, and in the busy season it slips by another week. The rate in purchasing is already fixed by then.
Here is how a rate change hits one model:
| Indicator | At €0.82 per USD | At €0.88 per USD |
|---|---|---|
| Components priced in USD (60% of cost), € | 26.40 | 28.33 |
| Other costs (40%), € | 17.60 | 17.60 |
| Cost price, € | 44.00 | 45.93 |
| Wholesale price, € | 60.00 | 60.00 |
| Margin, € | 16.00 | 14.07 |
| Profitability | 26.7% | 23.5% |
The calculation: 26.40 × 0.88 / 0.82 = 28.33. Adding €17.60 of other costs gives €45.93. The dollar rose by 0.06 / 0.82 = 7.3%, and the components became €1.93 more expensive per unit.
Three weeks of the old price list cost real money. If 1,200 heaters were sold in that time, the margin not received is 1,200 × 1.93 = €2,316.
How do you recalculate prices at the new exchange rate in Bimp?
The recalculation has four steps. A help link sits next to each.
Step 1. Price lists by channel. In the “Customer price lists” catalog you create separate price lists: “Wholesale”, “Dealer”, “Marketplace”. For each you choose a currency and a type. A price list can be tied to a specific counterparty if a large dealer has personal prices. Details: Price lists.
Step 2. A dollar price list and the rate. The plant keeps the dealer price list in a foreign currency. In the price list card you turn on the “Use supplier recommended prices” switch, specify the currency, “Supplier rate” and “Supplier rate date”, and enter the “Supplier price”. The “Price list price” in local currency is the price in the foreign currency multiplied by the rate. When the rate changes, you enter the new one and click Calculate prices: the whole price list is updated. For WarmHome the dealer price of a heater is 70 USD, which is €57.40 at 0.82 and €61.60 at 0.88. The mode is described in Prices by exchange rate.
If a dealer works under a contract in dollars, the rate for them is set in the contract itself: a central bank rate, an interbank rate or a commercial rate with an adjustment percentage. Then the price in the document is calculated at the rate on the day of the operation (Individual exchange rate in a contract).
Step 3. Bulk change of local-currency price lists. “Wholesale” and “Marketplace” are kept in euros. In the “Sales → Prices” section a manager filters the heaters, selects them and clicks Change prices. Then the manager picks the price list, the rule ”+ X%”, types 3.2 and the “Effective from” date. The table shows the “Current price” next to the “New price”, so the result can be checked before saving. This is one operation per price list instead of editing hundreds of rows: Bulk price update.
Step 4. A new batch of components. When the purchase arrives at the new rate, selling prices can be updated right from the “Goods receipt” document with the “Change prices” icon (Updating prices from a receipt). The change is started manually, and Bimp never touches prices on its own.
What does it cost in numbers?
The dollar rose from €0.82 to €0.88. The cost price of a heater grew from €44.00 to €45.93, but the three price lists have stayed old for three weeks.
The dealer price list in dollars is recalculated at the new rate with the “Calculate prices” button. The euro price lists go up with a bulk price change of +3.2% and an “Effective from” date.
Wholesale price 60.00 × 1.032 = €61.92, margin 61.92 − 45.93 = €15.99 against €14.07 (25.8% instead of 23.5%). Dealer price 70 × 0.88 = €61.60, margin €15.67. The “Marketplace” price list at €68.00 goes up to €70.18, margin €24.25.
Let us check all three price lists after the change, based on the new cost price of €45.93.
| Price list | Old price, € | New price, € | Old margin, € | New margin, € | New profitability |
|---|---|---|---|---|---|
| Wholesale | 60.00 | 61.92 | 16.00 | 15.99 | 25.8% |
| Dealer (70 USD) | 57.40 | 61.60 | 13.40 | 15.67 | 25.4% |
| Marketplace | 68.00 | 70.18 | 24.00 | 24.25 | 34.6% |
The calculation row by row. Wholesale: 60.00 × 1.032 = 61.92, margin 61.92 − 45.93 = 15.99, profitability 15.99 / 61.92 = 25.8%. Dealer: 70 × 0.88 = 61.60, margin 61.60 − 45.93 = 15.67, profitability 15.67 / 61.60 = 25.4%. Marketplace: 68.00 × 1.032 = 70.176, rounded to 70.18, margin 70.18 − 45.93 = 24.25, profitability 24.25 / 70.18 = 34.6%.
The wholesale margin returns to almost €16.00, a cent short because of the rounded percentage. If exactly €16.00 is needed, the rule ”+ X” with the value 1.93 goes onto the wholesale price list and the price becomes €61.93. One percentage for all price lists is convenient when a difference of a cent does not matter, and an exact amount is set with a separate rule on the price list that needs it.
How do you check the result after the recalculation?
The “Sales → Prices” section shows the list of products with warehouse balances, and the “Price list” filter lets you choose all three price lists at once. The prices of each appear in a separate column. In a minute the manager sees that the dealer price list has not ended up above the wholesale one and that no model was left with the old price (Comparing prices and stock).
Next, the economist opens the “Gross profit” report, groups it by products and sorts it by profitability. Items where the margin dropped or turned negative stand at the top of the list. These rows are reviewed first: for such a model the price may need to go higher than the average percentage (report).
The general scheme of calculating a price from the cost price is described in Cost-Plus Pricing for Manufacturers. If the purchase invoice for a new batch arrives late, the article Cost Recalculation After a Late Invoice helps.
What does this give the company?
The main change for the plant is that the price decision is made from margin figures. The owner sees how much each model slipped and decides what percentage of increase the dealers will bear.
The owner answers a currency jump on the day the new rate appears. The new price switches on from the needed hour, and an increase for the future is planned with the “Effective from” date. Managers see the current price lists in Bimp itself, so dealers are not sent different versions of a file. The economist does not reconcile three spreadsheets with purchasing and reads the margin in the report.
The order of actions on the day of a currency jump is short. First the economist enters the new rate in the dealer price list and recalculates it. Then the pricing manager applies the percentage to the wholesale and marketplace price lists with the “Effective from” date. At the end of the day the “Gross profit” report shows whether any models remain with a margin below the minimum, and they get a separate rule.
Bimp is a Ukrainian cloud ERP for manufacturers, and price lists, purchasing and cost price live in one database. For a manufacturer of household appliances with imported components this means the exchange rate stops being the reason for late prices.
Scenario limits
Bimp does not change local-currency prices by itself when the rate changes: an employee starts the recalculation with the “Calculate prices” or “Change prices” button. The bulk change rule applies to products already in the chosen price list, and the others are skipped. The percentage of the increase depends on the owner’s decision: to compensate the whole growth of the cost price or to share it with the dealers. Some of the help articles behind the steps carry a verification status, so check the button names against your version.
The rates of €0.82 and €0.88, the prices and the volume of 1,200 heaters are invented. How to set up price recalculation on your own price lists and products is shown on the Bimp for manufacturers page.
FAQ
Does Bimp update prices automatically after the exchange rate changes?
No, a person starts the recalculation. In a price list with the "Use supplier recommended prices" switch you enter the new rate and date and click "Calculate prices". The rate in a customer contract (central bank, interbank or commercial) is applied to documents on its own.
How do you raise prices if the price list is kept in the local currency?
In the "Sales → Prices" section you select the products and click "Change prices". The rule +X%, +X, *X or /X is applied to the chosen price list, and the "Effective from" date lets you schedule the increase for the future.
Can you schedule a price increase for tomorrow?
Yes. In the "Effective from" field you enter a future date and time. Until then the old price applies, and then the new one switches on by itself.
How do you see the products that already sell at a low margin?
The "Gross profit" report is grouped by products and sorted by profitability. Items with a reduced or negative margin are visible at once, and you review them first.
In a Bimp ERP demo a specialist changes the rate with you and recalculates one of your price lists, from the new rate to the margin in the report.
Book a demo