From Invoice History to Pricing Engine — Built for a 40-Year Field Service Contractor

The Problem

Rappahannock Petroleum Services has been operating for over 40 years. In that time they've completed thousands of jobs — tank top remodels, dispenser replacements, STP repairs, site upgrades — and generated thousands of invoices and bids. Every one of those documents contains real cost data: what materials cost, what labor cost, what the job actually took to complete.

None of that data was working. It sat in filing systems and spreadsheets, disconnected from the next bid being built. Every quote started from scratch — from memory, from experience, from gut feel. In a tight-margin industry where a single miscalculated bid can cost tens of thousands of dollars, that's a problem that compounds over time.

The contractors who get ahead in this environment aren't the ones with the most experience. They're the ones who turn their experience into structured data — and let that data do the heavy lifting every time a new quote hits their desk. RPS had all the raw material. They needed a tool to unlock it.

The Solution

CostIQ — marketed internally as RPS Intelligence — is a purpose-built cost-intelligence platform for Rappahannock Petroleum Services. The concept is straightforward: upload an invoice or bid (Excel or PDF), and the system extracts the key data automatically — job type, site configuration, materials, labor, and total cost. Over time, that data builds into a pricing engine trained entirely on RPS's own job history.

Once the data is in, anyone on the team can ask plain-language questions and get immediate answers. No spreadsheet formulas. No filtering pivot tables. No digging through folders. The system returns exact figures — averages, trends, variances — drawn from real RPS jobs, not industry benchmarks or national averages that don't reflect how RPS operates.

Every new invoice uploaded makes the next bid sharper. Ten jobs gives you a reference point. A hundred jobs gives you a pricing engine that outperforms gut feel every time. The system is built to compound in value as the data grows — which means it becomes more valuable every month it's in use.

Built-In Intelligence — From Day One

CostIQ ships with a full suite of pre-built reports covering every question a contractor needs answered before writing a bid. No configuration required. Every report draws directly from the uploaded invoice history.

The Result

CostIQ is the difference between a company that has experience and one that has intelligence. RPS has both — decades of field experience and now a system that extracts the pricing signal from all of it. Every future bid is backed by real numbers from real jobs, not a best guess refined over 40 years.

The compounding effect is the real value. The first 50 invoices uploaded give you a starting reference. The next 500 give you a pricing engine. The system becomes more accurate, more specific, and more valuable every month it's in use — which means it's a competitive asset that gets harder to replicate over time.

What This Means for Your Business

CostIQ is not just a tool built for one company. It's a demonstration of what's possible when years of operational data get a system built around them. If your business has a history of completed jobs — any industry, any trade — that history is a pricing asset sitting unused.

PrestigeSite Studio can build you the same intelligence. A custom platform trained on your data, answering your questions, built to your operation. The result is faster bids, tighter margins, and a clearer picture of where your business makes its money.

That's not a feature set. It's a competitive advantage — and once your competition builds one, you'll wish you'd done it first.

Capabilities Demonstrated