XLSX · Excel · Retail chains

Retail chain onboarding sheet

Work out the net-net price after discounts and back-margin terms. Check supplier readiness and logistics data before you talk to the buyer.

Who it is for: Manufacturers before their first talk with a buyer from a DIY, home and garden or retail chain.

XLSX · Excel

What is in the file

XLSXRetail chain onboarding sheet

The sheet works out what you get per unit after the front discount, bonuses, promotional budgets, logistics fees and the listing fee. It gives the lowest list price at which entering the chain makes sense. It includes the chain’s list of requirements, a product card with palletisation and a schedule to the first delivery.

Supplier readiness
33 requirements in 8 areas (company documents, insurance, quality and GPSR compliance, product and packaging, EDI and GS1, logistics, finance, marketing) with status and progress.
Product card
Data for 5 products, automatic count of cartons and units per pallet, pallet height and weight, a check against the chain’s height limit, volume.
Chain price
3 variants side by side: invoice price, back-margin terms, listing fee per unit, net-net price, manufacturer’s costs (transport to the DC, penalties), manufacturer’s margin (PLN, %, per year), the chain’s front margin and total margin, the minimum list price at the target margin, a comparison with wholesale and Allegro.
DC logistics
26 distribution centres of 10 chains (locations to be confirmed) with fields for distance and time, and 9 typical logistics requirements.
Chain marketplaces
Castorama, Leroy Merlin, Black Red White as a first step before a listing.
Schedule
7 stages from preparing the offer to the first promotion, with the date of the first delivery.