A free custom product pricing calculator template for Excel and Google Sheets. Map material costs, modifiers, and margins for any configurable product.
Get access — book a free demoCUSTOM PRODUCT PRICING CALCULATOR BASE PRODUCT SETUP Base cost: [ ] Target margin: [ ]% Base price: =base cost / (1-margin) MATERIAL MODIFIERS Material A: +£[ ] Material B: +£[ ] Material grade upcharge: +[ ]% SIZE/DIMENSION PRICING Base dimensions: L[ ] × W[ ] × H[ ] Cost per unit area: £[ ] per m² ...
The template supports four common custom product pricing models: absolute modifier pricing (each option adds or subtracts a fixed amount), percentage modifier pricing (each option changes the price by a percentage of base), dimension-based pricing (price calculated from dimensions), and combination pricing (multiple modifier types applied together). Most custom product businesses use a combination of these.
A product configurator's pricing engine can only automate pricing rules that are clearly documented and systematic. If your current pricing is based on judgment or ad hoc decisions, those need to be systematized before they can be automated. Using this template to document your pricing rules is the prerequisite step before any configurator implementation.
Yes. A completed pricing calculator template gives a configurator vendor the exact rules they need to build your CPQ engine. It also helps you identify edge cases and exceptions in your pricing before implementation — which is significantly cheaper than discovering them after the configurator is built.
If your pricing genuinely requires per-order judgment, the first step is to analyze whether that judgment can be codified into rules. Many apparent 'judgment calls' turn out to be consistent patterns that can be documented. For the remainder, consider whether those items should stay as quote-only while more standard configurations are automated through the configurator.