In window and door manufacturing, quote turnaround often determines who wins the sale. Yet with PVC joinery, aluminium joinery and timber-aluminium systems, an error on one item can turn a signed job into a loss. The customer wants an answer now, while you still need to verify profiles, glazing, hardware, measurements, installation, removal and accessories.

Two approaches dominate: formula-based calculation and table-based, or matrix, pricing. Neither is wrong. The real challenge is keeping the quote accurate and profitable when the specification changes in front of the customer.

Formula-based pricing: cost built from every detail

A formula-based model calculates the material composition of each item. Price per linear metre of profile, cutting lists, waste optimisation, reinforcement, subframes and other components are calculated from the dimensions and construction.

Hardware is calculated by opening configuration: single-sash, double-sash and tilt windows do not have the same components or cost. Glazing is calculated by square metre, with different inputs for double glazing, triple glazing and low-emissivity glass. This is why advanced manufacturers often rely on complex tables and Excel formulas.

Benefits and limits of formula-based calculation

Benefit: high accuracy for purchasing, production and cost control.
Benefit: strong fit for non-standard dimensions, special constructions and complex sliding systems.
Limit: when calculated manually, it is too slow for a quick customer response.
Limit: a small error in a formula, allowance or entry can change the price and profit margin.

Matrix pricing: speed through a width x height table

A matrix is simpler: for a standard item, the price is selected from a matrix price list by width x height, for example 120 x 140. A fixed matrix for standard items is especially useful for catalogue-based joinery sales, sales representatives and joinery dealers who need a fast estimate during site measurements.

Benefits and limits of matrix pricing

Benefit: rapid pricing and easy use during on-site measurements.
Benefit: simple to explain to a customer and to train a sales team.
Limit: difficulties arise with non-standard dimensions, arched windows and complex systems.
Limit: when PVC or aluminium material prices change, the whole matrix can become inaccurate unless updated.

Where both approaches usually break down

A quote rarely remains just a window. The customer adds external roller shutters, roller or pleated insect screens, requests a sliding system, subframe, installation or removal. You need to react quickly while automatically checking that each addition follows the dimensions, item type and actual cost.

This is where expensive mistakes happen: an incorrect area, an omitted accessory or a price that looks acceptable to the customer but no longer protects your margin.

One system for formulas and matrices

Digitalising PVC and aluminium production does not mean abandoning the way you work. Good joinery software should let you enter your own formulas where detailed calculation is needed, while also loading matrix tables for standard, fast sales.

With Okvir.io, you can create a quote in front of the customer and automatically calculate accessories such as roller shutters, insect screens and subframes. Production stays based on accurate data, while sales gets a professional quote in one click.

A fast quote does not have to be risky

Formulas provide control, matrices provide speed, and modern software connects both in one process. When every item is priced consistently, you can protect margin more easily and leave a professional impression.

Try Okvir.io for free and see how joinery software can produce accurate quotes in just a few clicks.