How to read Price traces in the Price Configuration section

Appxite

Introduction

This article explains Price traces in the Price Configuration section of the Offer and Subscription pages. A Price trace shows, step by step, how the Platform calculates a Price: the starting Price, each Price Adjustment, Promotion and currency conversion that was applied, and the result after every step. Use Price traces to understand why a Price has a particular value and to verify it without recalculating it by hand.

This article is intended for Distributor and Seller Platform Users who configure or review pricing on an Offer or a Subscription. It extends How to read the Price Configuration section in Offer and Subscription page.

In this article:

Benefits of Price traces

The Price Configuration section shows the result of a calculation: the Cost, the Price Adjustment and a target Price for each tier. A Price trace shows the calculation behind that result. For Partners, this gives the following benefits:

  • Transparency. You see where every part of a Price comes from: the Vendor retail price, Base Margin, Markups, Growth Margin, Promotions and exchange rates.
  • Quick verification. Each step shows its calculation, and the FORMULA line shows the whole calculation in one line. You can check a Price without recalculating it in a spreadsheet.
  • Faster troubleshooting. When a Price is not what you expect, the trace shows the step where the value changed, for example an unexpected Discount, a different Price Source or an exchange rate.
  • Confident decisions. You can check how a Price is built before you place an Order on the Offer Buy page, and after you change a Price on a Subscription.
  • Clear explanations. Each step has a short description, so you can explain to colleagues how a Price was calculated.
  • Consistent numbers. The final value of a trace equals the value in the Price Configuration field and in the Price table, so all three views confirm each other.
  • Faster support. If you submit a support request about a Price, a screenshot of the trace shows the calculation and helps to find the reason sooner.

Where to find Price traces

Price traces are part of the Price Configuration section. The Price Configuration card is the first card in the Price section on two pages:

  • Offer Buy page, when you purchase a new Subscription.
  • Subscription details page, when you open or edit an existing Subscription.

To display Price traces:

  1. Open the Offer Buy page or the Subscription details page.
  2. In the header of the Price Configuration card, select Detailed.
  3. Scroll through the card. Each Price has its own trace, shown as a collapsed bar.

Figure 1: Switching the Price Configuration card to Detailed view.

NOTE! Price traces are shown only in Detailed view. Switching between Simple and Detailed changes only how much of the calculation is displayed. It does not change any Price.

Available Price traces

The Platform shows one trace for each Price that is built from several steps. Which traces you see depends on your role.

Trace What it explains
Distributor Cost trace What the Distributor pays the Vendor, starting from the Vendor retail price
Seller Target Price trace What the Distributor charges the Seller, including the Distributor Price Adjustment and the conversion into the Seller currency
Customer Target Price trace What the Seller charges the Customer, including the catalog and Subscription Price Adjustments and the conversion into the Customer currency

Each trace header shows the number of steps and the final value, for example 5 steps and FINAL MYR 11.50 → PLN 33.19. The first amount is the value of the matching Price Configuration field. The amount after the arrow is the same Price converted into the next currency in the chain.

How to open and close Price traces

All Price traces are collapsed by default. To open or close one trace, select the chevron on the right side of its header.
 

Figure 2: A collapsed Price trace shows the number of steps and the final value.

To open or close all traces at once, use the Expand all link:

  • Select Expand all to open every trace that your role can see.
  • When all traces are open, the label changes to Collapse all calculation traces. Select it to close them all.
  • If you open or close traces one by one, the label follows the current state: Collapse all when every trace is open, otherwise Expand all.
NOTE! The Expand all link is shown only in Detailed view and only when at least one trace is available.

How to read a Price trace

An expanded trace is a table. It lists only the steps that were actually applied to the Price, so the number of steps changes from one Offer to another.

Figure 3: An expanded Price trace.

The table has the following columns:

Column What it shows
STEP The order in which the Platform applies the steps, starting with 01
ENTITY What is applied in this step, for example Retail Price, Growth Margin or an exchange rate
WHAT HAPPENS A short description of the step and where its value comes from
CALCULATION The calculation with the actual percentage, amount or rate that was used
CHANGE How much the step added to or subtracted from the Price. Currency conversion steps show a dash, because they change the currency and not the value
PRICE The running result after the step, with its currency

The FORMULA line at the bottom of the trace combines all steps in one line, so you can see the complete calculation at a glance. The result of the formula is always the final value shown in the trace header.

Entities you can see in a trace

Entity Appears in What it does
Vendor Retail Price Distributor Cost The published list price before Vendor program deductions. It is the starting Price of the trace
Base Margin Distributor Cost Reduces the Vendor Retail Price to the Cost Price: Vendor Retail Price minus Base Margin equals Cost Price
Cost Price Seller Target Price The starting Price when the Price Source is Cost Price
Retail Price Customer Target Price The starting Price when the Price Source is Retail Price
Distributor Price Adjustment Seller Target Price The commercial adjustment (Markup) applied to the configured Seller Price Source
Growth Margin Distributor Cost, Seller Target Price A Microsoft-specific Vendor growth margin. It is calculated from the Vendor Retail Price, not from the running Price
Promo or Promotion Distributor Cost, Seller Target Price The applied Vendor Promotion, shown with its name or percentage
Catalog Price Adjustment Customer Target Price The Markup configured in Customer Prices. It is applied first
Subscription Price Adjustment Customer Target Price The Subscription-level Markup. It is applied after the catalog adjustment
Currency conversion, for example EUR → MYR Seller Target Price, Customer Target Price The exchange rate that converts the Price into the next currency in the chain

Example: a basic Offer across three tiers

This example follows one Subscription through all three tiers: Distributor, Seller and Customer. All three traces are open in Detailed view. Read the traces from top to bottom, in the same order as the Platform builds the Price.

Tier Currency Configuration in this example
Distributor EUR Vendor Retail Price EUR 2.00, Base Margin −50%, Price Source Cost Price, Distributor Price Adjustment 12%
Distributor charges the Seller EUR → MYR Growth Margin 15% (calculated from the Vendor Retail Price) and Promo 10% reduce the Price. Exchange rate: 1 EUR = 5.0000 MYR
Seller MYR Price Source Retail Price (MYR 10.00), catalog Price Adjustment 15%, Subscription Price Adjustment 0%
Customer PLN Exchange rates: 1 MYR = 0.7000 USD and 1 USD = 4.1235 PLN. Billing Cycle: every 1 month. Quantity: 1

Step 1: Distributor Cost trace

The Distributor Cost trace explains what the Distributor pays the Vendor.

Figure 4: Distributor Cost trace and the DISTRIBUTOR section.

Step Entity What happens Calculation Change Price
01 Vendor Retail Price Published list price before Vendor program deductions EUR 2.00 – EUR 2.00
02 Base Margin Vendor Retail Price − Base Margin = Cost Price EUR 2.00 × (1 − 50%) − EUR 1.00 EUR 1.00

The FORMULA line reads: EUR 2.00 Vendor Retail Price × (1 − 50% Base Margin) = EUR 1.00.

The result, EUR 1.00, is the COST of the Distributor. The same amount is the You Buy For value in the Distributor row of the Price table.

Step 2: Seller Target Price trace

The Seller Target Price trace explains what the Distributor charges the Seller. It starts from the Price Source of the Distributor, which is Cost Price in this example.

Figure 5: Seller Target Price trace with Distributor Price Adjustment, Growth Margin, Promo and a currency conversion.

Step Entity What happens Calculation Change Price
01 Cost Price The starting Price used to calculate the target Price EUR 1.00 – EUR 1.00
02 Distributor Price Adjustment Commercial adjustment applied to the configured Seller Price Source EUR 1.00 × (1 + 12%) + EUR 0.12 EUR 1.12
03 Growth Margin Vendor growth margin calculated from the Vendor Retail Price EUR 2.00 EUR 1.12 − (EUR 2.00 × 15%) − EUR 0.30 EUR 0.82
04 Promo Applied Vendor Promotion EUR 0.82 × (1 − 10%) − EUR 0.08 EUR 0.74
05 EUR → MYR The exchange rate configured in the Platform converts the final Seller Target Price into the amount that the Seller sees EUR 0.74 × 5.0000 – MYR 3.69

The FORMULA line reads: (EUR 1.00 Cost Price × (1 + 12% Distributor Price Adjustment) − 15% × EUR 2.00 Growth Margin) × (1 − 10% Promo) × FX 5.0000 = MYR 3.69.

How to read the result:

  1. Step 01 starts from the Cost Price because the Price Source of the Distributor is Cost Price.
  2. Step 02 applies the Distributor Markup of 12% to EUR 1.00. This is the value in the PRICE ADJUSTMENT field.
  3. Step 03 takes the Growth Margin from the Vendor Retail Price (15% of EUR 2.00 is EUR 0.30). It is not calculated from the running Price of EUR 1.12.
  4. Step 04 takes the Promo from the running Price after the Growth Margin (10% of EUR 0.82 is EUR 0.08).
  5. EUR 0.74 is the SELLER TARGET PRICE in the Distributor section. The field also shows the struck-through EUR 1.12, which is the Price before the Growth Margin and the Promo.
  6. Step 05 converts the result into the Seller currency. MYR 3.69 is the COST in the Seller section.
NOTE! The trace calculates with more precision than it displays. In step 04 the exact result is EUR 0.738, which is displayed as EUR 0.74.

Step 3: Customer Target Price trace

The Customer Target Price trace explains what the Seller charges the Customer. It starts from the Price Source of the Seller, which is Retail Price in this example.

Figure 6: Customer Target Price trace and the SELLER section.

Step Entity What happens Calculation Change Price
01 Retail Price The starting Price used to calculate the Customer Target Price MYR 10.00 – MYR 10.00
02 Catalog Price Adjustment Catalog Price Adjustment, configured in Customer Prices. Applied first MYR 10.00 × (1 + 15%) + MYR 1.50 MYR 11.50
03 Subscription Price Adjustment Subscription-level adjustment applied after the catalog adjustment MYR 11.50 × (1 + 0%) + MYR 0.00 MYR 11.50
04 MYR → USD Platform-defined exchange rate converts the finalized Customer Target Price into the Customer currency MYR 11.50 × 0.7000 – USD 8.05
05 USD → PLN Customer preferred currency exchange rate converts the amount into PLN USD 8.05 × 4.1235 – PLN 33.19

The FORMULA line reads: MYR 10.00 Retail Price × (1 + 15% Catalog Price Adjustment) × (1 + 0% Subscription Price Adjustment) × FX 0.7000 × FX 4.1235 = PLN 33.19.

How to read the result:

  1. Step 01 starts from the Retail Price because the Price Source of the Seller is Retail Price. The Seller Cost of MYR 3.69 is not part of this calculation. For this reason, COST and CUSTOMER TARGET PRICE are not an arithmetic chain: MYR 3.69 × (1 + 15%) does not give MYR 11.50.
  2. Steps 02 and 03 are the two lines of the PRICE ADJUSTMENT BREAKDOWN: Catalog 15% and Subscription 0%. They are multiplied: (1 + 15%) × (1 + 0%) − 1 = 15% Total effective.
  3. MYR 11.50, before the conversion, is the CUSTOMER TARGET PRICE in the Seller section.
  4. Steps 04 and 05 convert the Price into the currency that the Customer pays in. PLN 33.19 is the CUSTOMER PRICE and the GRAND TOTAL.
NOTE! The Markups multiply. If the Subscription Price Adjustment in this example were 10%, step 03 would be MYR 11.50 × (1 + 10%) = MYR 12.65. The total adjustment would be 26.50% and not 25%.

How traces, formulas, fields and the Price table connect

A Price is shown in three places, and all three are generated from the same calculation, so they always agree:

  • the trace: the final value in the header and the result of the FORMULA line,
  • the Price Configuration field,
  • the Price table below the card.

The table below connects the values of the example.

Trace Final value in the trace Price Configuration field Price table cell
Distributor Cost EUR 1.00 COST in the Distributor section: EUR 1.00 Distributor row: You Buy For EUR 1.00 and Unit Cost EUR 1.00
Seller Target Price EUR 0.74, then MYR 3.69 after the conversion SELLER TARGET PRICE in the Distributor section: EUR 0.74. COST in the Seller section: MYR 3.69 Distributor row: You Sell For MYR 3.69 and Unit Price MYR 3.69. Seller row: You Buy For MYR 3.69 and Unit Cost MYR 3.69. The struck-through MYR 5.60 is EUR 1.12 × 5.0000, the Price before the Growth Margin and the Promo
Customer Target Price MYR 11.50, then PLN 33.19 after the conversion CUSTOMER TARGET PRICE in the Seller section: MYR 11.50. CUSTOMER PRICE and GRAND TOTAL: PLN 33.19 Seller row: You Sell For PLN 33.19 and Unit Price PLN 33.19

The percentages and sources in the trace steps are shown in the columns of the Price table.

Value in the trace Where you find it in the Price table
Step 01 of the Seller Target Price trace: Cost Price Price Source of the Distributor row: Cost Price
Step 01 of the Customer Target Price trace: Retail Price Price Source of the Seller row: Retail Price
Distributor Price Adjustment 12% Distributor row: Catalog Adj. (%) 12 and Total Adj. (%) 12.00
Catalog Price Adjustment 15% Seller row: Catalog Adj. (%) 15
Subscription Price Adjustment 0% Seller row: Subscription Adj. (%) 0
Total effective 15% in the PRICE ADJUSTMENT BREAKDOWN Seller row: Total Adj. (%) 15.00
Vendor Retail Price EUR 2.00 Vendor Retail Price column: MYR 10.00 in the Distributor row (EUR 2.00 × 5.0000) and USD 7.00 in the Seller row (MYR 10.00 × 0.7000)
Exchange rates in the conversion steps The sub-lines under COST (0.74 EUR × FX Rate 5.0000 = 3.69 MYR) and under CUSTOMER PRICE (11.50 MYR × FX 0.7000 × 4.1235 = 33.19 PLN)

The Margin columns of the Price table and the margin tiles under the CUSTOMER PRICE panel are calculated from the same values: (You Sell For − You Buy For) ÷ You Sell For, in the cost currency of the tier.

  • Distributor: EUR 0.74 − EUR 1.00 = EUR −0.26, which is −35.50%. The percentage uses the exact value of the Seller Target Price, EUR 0.738. The Distributor sells below the Cost, so the Platform shows the message "This price adjustment may result in selling at a loss." under the PRICE ADJUSTMENT field.
  • Seller: MYR 11.50 − MYR 3.69 = MYR 7.81, which is 67.91%.

Figure 7: The same Price in the CUSTOMER PRICE panel, the margin tiles and the Price table.

How to check a Price from the Price table to the traces

  1. In the Price section header, find the GRAND TOTAL: 33.19 PLN.
  2. Open the Customer Target Price trace. The last step gives PLN 33.19, and the value before the conversion, MYR 11.50, is the CUSTOMER TARGET PRICE.
  3. Check the Seller row of the Price table: the Price Source is Retail Price, so the Customer Target Price is built from the Retail Price and not from the Seller Cost.
  4. Open the Seller Target Price trace to see what the Seller pays. The converted value, MYR 3.69, is the Seller Cost and the You Buy For value of the Seller row.
  5. Open the Distributor Cost trace to see what the Distributor pays the Vendor: EUR 1.00.

Growth Margin and Promotions in traces

Growth Margin and Promotion steps are part of the traces. They can also appear in the Distributor Cost trace. The next example shows a Distributor Cost trace with both steps, using a Vendor Retail Price of EUR 200.00.

Figure 8: Distributor Cost trace with a Growth Margin and a Promotion.

Step Entity Calculation Change Price
01 Vendor Retail Price EUR 200.00 – EUR 200.00
02 Base Margin −15% EUR 200.00 × (1 − 15%) − EUR 30.00 EUR 170.00
03 Growth Margin −7% 7% of the Vendor Retail Price EUR 200.00 − EUR 14.00 EUR 156.00
04 Contoso Promotion −15% EUR 156.00 × (1 − 15%) − EUR 23.40 EUR 132.60

The FORMULA line reads: EUR 200.00 Vendor Retail Price × (1 − 15% Base Margin − 7% Growth Margin) × (1 − 15% Contoso Promotion) = EUR 132.60.

What to remember about these steps:

  • Growth Margin is a Microsoft-specific feature. It is calculated from the Vendor Retail Price and not from the running Price: 7% of EUR 200.00 is EUR 14.00. If it were calculated from EUR 170.00, it would be EUR 11.90.
  • The Promotion is calculated from the running Price after the Base Margin and the Growth Margin: 15% of EUR 156.00 is EUR 23.40.
  • The Vendor configures Promotions for one or more tiers: Distributor, Seller and Customer. A tier gets the Promotion only when it is set for that tier.
  • Without a Growth Margin and a Promotion, the same trace has 2 steps and ends with EUR 170.00.

For the rules and the setup, see Growth Margin — what it is and how it works and How to set up and manage Promotions.

Calculation rules to remember

  • Only applied steps are listed. A step that does not apply is not shown, so the step count in the header changes with the Offer.
  • The first step shows the starting Price, and it follows the Price Source column of the Price table: Cost Price or Retail Price. In the Distributor Cost trace, the starting Price is the Vendor Retail Price.
  • Steps run in the listed order. Each step works on the running Price from the previous step. The exception is the Growth Margin, which is always calculated from the Vendor Retail Price.
  • Markups multiply. The catalog and Subscription Price Adjustments are applied one after the other, so the result is higher than the sum of the percentages.
  • A Promotion is applied after the Markups and after the Growth Margin. It reduces the running Price by its percentage.
  • A −100% adjustment or Promotion gives 0 in the formulas.
  • Currency conversion steps change only the currency. They use the exchange rates shown in the CALCULATION column.
  • The final value of a trace equals the value in the matching Price Configuration field and in the Price table.
NOTE! The Platform displays amounts rounded to two decimal places, but it calculates with more precision. A value that you recalculate by hand from the displayed numbers can differ by one cent.

If a Price is not what you expect, check the trace in this order:

  1. The currency of each step, to make sure that you compare amounts in the same currency.
  2. The first step, to confirm the Price Source.
  3. The Catalog Price Adjustment and the Subscription Price Adjustment, to see where the Markup is configured.
  4. The Promotion and Growth Margin steps, to see whether a reduction was applied.

Summary

Price traces show how the Platform builds a Price from its starting Price, Price Adjustments, Growth Margin, Promotions and currency conversions. There is one trace for the Distributor Cost, one for the Seller Target Price and one for the Customer Target Price. Open them in Detailed view of the Price Configuration section on the Offer Buy page or the Subscription details page. Read each trace from the first step to the last: the PRICE column gives the running result, and the FORMULA line gives the whole calculation in one line. The final value of every trace equals the value in the matching Price Configuration field and in the Price table, so you can follow a Price from the GRAND TOTAL back to the Vendor Retail Price.

Was this article helpful?

0 out of 0 found this helpful

Add comment

Please sign in to leave a comment.