“I'm not sure I'm pricing jobs right”
If this sounds like your week
Your pricing spreadsheet works — until someone asks how you got the number, or you try to quote a variation you have not priced before.
Labour rates, material markups, waste factors, and shop overhead live in cells and tabs only you navigate. Changing one assumption means hunting formulas you wrote years ago.
You suspect some jobs subsidize others, but the sheet shows a total, not whether margin held on that specific order.
Every new product line or price change starts with “let me open the spreadsheet” — not a model the team can reuse or sanity-check.
What is actually going wrong
Spreadsheets are flexible, but they were never built to be a shared pricing engine — logic hides in cells, versions multiply, and nobody else can safely edit them.
Overhead, setup time, and exception handling get averaged or guessed because the sheet was built for speed, not for every job shape you sell today.
Pricing stays separate from orders and production, so you cannot easily compare what you quoted against what the job actually consumed.
When only the owner understands the model, quoting speed depends on you — and confidence depends on memory, not structure.
This is not a spreadsheet skill problem. It is a pricing-model gap — the business has no durable, shareable way to turn labour, materials, and overhead into a price you can defend job by job.
Count yours
- Pick one job you quoted last month: write down labour hours, material cost, and what you charged. If you cannot reconstruct the math in five minutes, you cannot audit margin on that job.
- Count how many quotes this week required you personally — multiply by your loaded hourly rate. That is the tax of a model only you can run.
- One mis-keyed cell or outdated material cost, repeated across similar jobs, can erase more margin than a slow month — without a line item that says “spreadsheet drift.”
What it looks like when this stops
CoreXBiz Price Calculator lets you build visual cost models — labour, materials, overhead categories, and measurement types — so pricing rules live in structure, not buried formulas.
Server-verified quotes apply your configured model when customers configure variable-spec work online or your team runs the calculator — fewer “only I know which cell to change” moments, though you still define the rules.
Multiple calculators can cover different product families or customer tiers instead of one monolithic sheet with tabs nobody else trusts.
When paired with Estimate and Workflow in CoreXBiz, approved prices can attach to orders and jobs — so quoting is not a number that dies in a cell while production works from a different story.
Where CoreXBiz connects
This problem maps to connected modules inside CoreXBiz — not a single feature bolted on.
- Price Calculator Available
- Estimate Available
- CoreX Products Available
- Quoting & Invoicing Available
Realistic scenario
Composite example for illustration — not a named customer account.
A custom fabrication shop kept pricing in a shared Excel file — three tabs, nested IFs, and a “shop rate” cell updated once a year. Quotes for new sizes required the owner. After moving repeat families into Price Calculator cost models, a sales lead can generate a server-checked quote from configured rules; the owner reviews exceptions instead of rebuilding math from scratch each time.
Composite illustration — not a named customer account. Migration from legacy spreadsheets still takes configuration time.
Common questions
- Can I move my existing spreadsheet formulas into Price Calculator?
- You rebuild the logic as structured cost categories and rules — not a one-click import of every Excel formula. Many shops start with their best-selling product family, validate quotes against the old sheet, then expand. The goal is a model others can run without opening your file.
- Does Price Calculator include overhead and markup?
- Yes — you configure cost categories (including overhead-style lines), measurement types, and how they combine into a price. You still decide rates, markups, and minimums; the platform applies them consistently once configured.
- We only sell online through WooCommerce — does this help?
- Price Calculator integrates with WooCommerce for configurable products — customers see prices from your model instead of a static SKU. You configure products and calculators; complex one-offs may still need Estimate or manual review.
- Is this different from quoting a job wrong after the fact?
- Yes. The quoted-wrong problem is about locking a price before the job is defined. This page is about where your pricing rules live — if they only exist in a spreadsheet you trust alone, you cannot price confidently or hand quoting off, even when scope is clear.