Open pipeline
$270,400
Weighted forecast
$89,550
Won
$18,000
Sales Pipeline CRM
Deals by stage with weighted forecast, deal age, overdue follow-ups, win rate and a scorecard for every rep.
SpreadsheetPipeline & OpportunityFree
Set list prices from cost and target margin, add volume-discount tiers and check every tier still clears your margin floor.
Shown with sample data
Set list prices from cost and target margin, add volume-discount tiers and check every tier still clears your margin floor.
A price list that is worked out, not guessed. Enter each product’s unit cost and the margin you want; the sheet sets the list price, calculates markup and three volume-discount tiers from the thresholds on the Settings sheet, and flags any product whose deepest discount falls below your minimum margin. A Quote sheet then prices any order at the right tier automatically.
Price = cost ÷ (1 − margin). A product costing $12 with a 40% target margin sells for $12 ÷ 0.60 = $20. The sheet does this for every row.
Margin is profit as a share of the selling price; markup is profit as a share of cost. A $20 price on a $12 cost is a 40% margin and a 67% markup.
Base the thresholds on real order sizes (look at your order history) and make each tier worth reaching, typically 3–8% per step. Check that the deepest tier still covers your costs and minimum margin, which the Floor check column does for you.
No. Keep cost and margin columns for internal use only. Export a customer version showing SKU, product and the price per tier.
Download a copy
Downloads need a free account.