Buyer Quotation Generator

How to read this sheet

The commercial terms are single figures applied across the whole quotation, and that is the sheet's largest simplification: a style shipped by air, a style with a nominated trim supplier, and a style with a longer payment window do not carry the same freight, finance or commission, and forcing them to share one number moves margin between styles inside the blend the tool is trying to expose. Split the quotation when the terms genuinely differ. Costs are taken per garment as given - there is no consumption, efficiency or wastage model here, so an optimistic cut-and-make figure produces a confident and wrong quotation; price each style properly first. Capacity is not modelled at all, which matters because the below-floor styles are often the long-running basics that fill the line, and dropping them can cost more in idle capacity than they lose in margin - the tool tells you which styles are underwater, not whether you can afford to refuse them. Minimum order quantities, fabric booking minimums, size-ratio penalties, quota, duty and any destination charges beyond the quoted delivery term are outside the sheet. The currency break-even assumes every cost is incurred in the local currency and every receipt in the quoted one; imported fabric bought in the quoting currency is naturally hedged and the exposure shown is then overstated. Annualising that move is a comparison device for reading it against observed volatility, not a forecast - it assumes steady drift, and currencies do not move that way. Finally, the cherry-pick figure is a stress test on your own floor, not a prediction: a buyer may place the whole range, or none of it.