Build an Appliance Channel Margin Waterfall Before Launch

An appliance price list can look profitable while its promotion sheet tells a different story. The risk appears when the base discount, quarterly rebate, display support and consumer offer are negotiated separately. A margin waterfall puts them into one model before commitments accumulate.

The objective is to explain where each rupee goes from the realised consumer price back to brand contribution. Use a separate view for cash timing, because an earned rebate and a settled rebate are different events.

Define one commercial unit

Choose a specific SKU, territory, route to market and promotion period. Do not blend a refrigerator sold through a distributor with a direct modern-trade sale. The invoicing parties, logistics obligations and deductions may differ.

Use values excluding recoverable tax for a like-for-like commercial comparison, with finance confirming the treatment. Keep the customer-facing tax-inclusive price in a separate field rather than switching bases mid-calculation.

Build the waterfall in order

Start at expected realised retail sales, not the most optimistic MRP. Record retail trading earnings, distributor trading earnings, funded promotions, service obligations, freight and product cost. Reconcile the resulting brand revenue to the invoice and credit-note process.

For example, a hypothetical ₹20,000 brand invoice with a ₹1,000 conditional rebate and ₹500 approved launch support produces ₹18,500 after those two deductions. It does not produce that result if the ₹1,000 rebate is already embedded in the invoice. Label every line as included or incremental to prevent double counting.

Attach conditions to each allowance

For every support item, write down:

• The event that earns it: purchase, verified sell-out, display compliance or payment.
• The calculation base and eligible products.
• The maximum funding and approving owner.
• The evidence, submission deadline and settlement method.
• The treatment of returns and cancelled sales.

A display allowance should not automatically become an unconditional discount on every future order. Equally, a dealer should not have to guess whether compliant activity will be reimbursed.

Stress-test the uncomfortable scenarios

Model a lower selling price, slower sell-out, higher damage cost and late rebate settlement. Check contribution for each participant. If the model works only when every customer pays full price and every claim clears immediately, it is too fragile for a launch.

Review weekly during the pilot. Replace forecast assumptions with actual realised prices and accepted claims. Where contribution deteriorates, identify the responsible line rather than adding another broad discount.

Use the margin versus markup example to align definitions, then connect the waterfall to your distribution network setup. The useful output is a commercial sheet partners can operate from, with a clear approval trail for exceptions.