LUMENOR PRICING ENGINE PRO — US EDITION

Still pricing jobs by gut feel? Two silent mistakes cost contractors thousands of dollars every year: labor priced at the bare wage instead of the real loaded cost, and overhead guessed instead of measured. This professional Excel workbook does ONE job, and does it completely: price your jobs right, the first time — then produce the quote and the invoice that flow from that price. It is not a business-management system: it is the entry door to LUMENOR Pro, the right-price tool. It builds your TRUE job cost, then the selling price that protects your margin — and it fixes both mistakes, in one place.

NEW — the real cost of labor. For every role (lead carpenter, plumber, electrician, tile setter — all editable), you enter the base wage AND a labor burden % (employer payroll taxes — Social Security/Medicare, FUTA/SUTA — workers' comp, liability insurance, paid time off; the guide explains typical ranges). The loaded rate is computed automatically and used throughout the estimate.

NEW — overhead from YOUR real numbers. An itemized block of your annual fixed costs (insurance, vehicles, fuel & maintenance, rent, software, bookkeeping, admin, phone/internet, marketing, permits & licenses, misc.) produces a SUGGESTED overhead rate — your annual fixed costs ÷ your expected annual direct costs — that feeds straight into your pricing. Prefer your own rate? A manual override field takes priority instantly.

NEW — a real quote document for your client. The Client Quote sheet is a professional quote document: a placeholder for your logo, your business name and contact details (pulled from Setup), a quote number, an automatic issue date (editable), an expiry date computed from your validity period (30 days by default), the scope of work, itemized price and tax, payment terms, exclusions, and a client acceptance block ready to sign. Print layout is set: one clean page, ready for PDF. No costs, no margins anywhere on it — ever.

NEW — the automatic invoice. Quote accepted? The Invoice sheet picks up the contract on its own: amount, taxes and total flow from the quote into the invoice — nothing to retype. Set the percentage billed (30% for the deposit, your progress steps, the final balance) and the invoice computes itself pro rata, taxes in. Invoice number linked to the quote, automatic issue date, Net 30 due date (adjustable terms), the contract payment schedule, total billed to date, paid to date, balance due and contract balance remaining: everything reconciles, every time. One clean page, ready to print or send as a PDF.

The complete pricing engine, in live formulas:

• Full job cost build-up: materials, labor at loaded cost (role picked from a dropdown), subcontractors, equipment, permits, other costs
• - Overhead, contingency, total job cost
• - Selling price computed FROM YOUR TARGET MARGIN (price = cost ÷ (1 − margin)) — not a rough markup; the equivalent markup % is shown, and the classic "margin ≠ markup" mistake is priced out in dollars in front of you
• - "What-if" block: price and profit at margins from 0% (break-even) to 40%
• - Discount simulator: what a 5% or 10% discount REALLY does to your final margin — with a clear on-sheet WARNING if a discount pushes your margin to zero or below
• - Sensitivity table: price and profit if your costs run −10% to +10%
• - Configurable sales tax % (set it to your state/county) — itemized quote total
• - Automatic invoice linked to the quote: percentage billing (deposit, progress, balance), billed/paid cumulative and balances that always reconcile

Protected and stress-tested. Formulas are locked with password-free sheet protection (removable in one click — the guide shows how): no accidental damage to a calculation; only the yellow cells take input. Built-in validation on percentages (0–100%) and amounts (non-negative), divide-by-zero guards everywhere: no error messages, even with empty lines or zero costs. Two fully worked, hand-checkable examples: one pre-filled in the workbook (a complete bathroom remodel in Columbus, OH, with a 7.5% sales tax), a second one in the guide.

US EDITION. Calibrated for the US market: US labor-burden guidance and a configurable state sales-tax rate. Every rate and parameter can be changed on the Setup sheet.

Contents: 1 Excel workbook (.xlsx) — 5 sheets (Setup, Cost & Price, Client Quote, Invoice, complete User Guide). Automatic quote AND invoice, in the same file.

Compatibility: Microsoft Excel 2016 and later, Microsoft 365, LibreOffice 7 and later. Universal functions only — no macros, no subscription. Your data stays on your machine.

GUARANTEE

14-day refund if the product is defective or not as described.

Save time. Save money. Make better decisions.

© 2026 M.V. Lumen — LUMENOR™ · Build • Protect • Pass On