Back to Hugo Maciel FragaAll case studies

Case study

Fixing Outdated Pricing

Estimated profit on our projects was not matching what accounting reported. I raised it with management, we reviewed what production actually cost, and the gap came down to pricing assumptions that had gone out of date. I then built an Excel calculator that let sales reps price and negotiate within safe margins without waiting on a manager.

The business

Quick Countertop & Cabinets is a countertop and cabinet business in Gaithersburg, Maryland, with about $2 million in annual revenue. Quotes were built from a pricing formula, and any move away from it needed management involvement.

What I noticed

The profit we expected on projects did not line up with the accounting results. Quotes were built on those estimates, so the gap was worth understanding.

There was a second, related problem on the sales side. Because pricing decisions needed a manager, reps had little room to negotiate with a customer on their own.

How we looked into it

I brought the gap to management and we worked through it together. We reviewed what production actually cost the business: fabrication labor, utilities, and overhead. The accounting figures came from accounting; my part was raising the question, analyzing the costs against the pricing, and following it through.

The review showed that some of the pricing assumptions no longer matched current costs.

  • Fabrication labor, utility, and overhead costs, reviewed with management.
  • Material waste and unit costs, for a truer cost per square foot.
  • Minimum acceptable margins, to set where a price could safely go.

What I built

I rebuilt the pricing assumptions from the current cost data and built an Excel pricing calculator on top of them. Instead of one fixed price, it gave reps a practical range: what a job cost, and how far they could negotiate while staying above the minimum margin.

Reps used it to build quotes and check margin, and they could negotiate inside that range without bringing in a manager.

  • Negotiated supplier pricing and purchasing terms.
  • Trained employees to use the project-cost tracking already in QuickBooks more consistently.

Results and limits

What changed: the pricing assumptions were rebuilt from current costs, and reps had a calculator and a range to work within instead of a manager approval for every price change.

What I cannot show: the calculator and the company's financials are private, and I do not have a measured before-and-after margin figure to share. Sales conversion did improve over the same period, but that came from several changes together and is not credited to the pricing work. The monthly reporting case study covers it.

Tools

  • Excel, for the cost analysis and the pricing calculator.
  • QuickBooks, for project-cost tracking.