XLSX · Excel · Wholesale and distribution

Price list for four channels

One purchase price, four channels. Work out the price in the shop, wholesale, on Allegro and in a retail chain, and check that the channels do not undercut each other.

Who it is for: A manufacturer who sells, or plans to sell, in more than one channel.

XLSX · Excel

What is in the file

XLSXPrice list for four channels

The sheet builds the price of each product up from its cost, with the costs of each channel: commission, advertising, chain discounts and logistics. Six tests show where one channel undercuts another and suggest what to change. In the end you see the profit in each channel and in the sales mix.

Parameters
VAT, company cost mark-up, price difference tolerance; costs and target margins of your own shop, wholesale, Allegro and the chains; minimum advertised price (MAP).
Products
Up to 40 products with cost, packaging and their own channel rates (an empty field = the default value).
Price list
Proposed and accepted price in each channel, MAP, the highest wholesale price at the buyer’s margin, the chain’s net-net, the suggested shelf price.
Channel margins
Profit and margin per unit in each channel at the accepted prices.
Channel conflicts
6 tests (Allegro below MAP, wholesale with no buyer margin, Allegro cheaper than the chain’s shelf, shelf dearer than the shop, the chain buys cheaper than wholesale, a loss in a channel), a summary and “where to start”.
Channel mix
Planned monthly sales, revenue and profit of each channel and their shares.