Your old vendor quotes should help with your next estimate
A closer look at the historical-pricing workflow we built for a New England metal fabrication company … and why the source matters as much as the price.
A supplier quote can be saved and still be difficult to use.
That was part of the estimating problem at a New England metal fabrication company we work with. The business had collected vendor quotes for raw steel and other materials. Much of that pricing was in PDFs. To use it again, an estimator had to find the right document and locate the relevant information inside it.
When building a new estimate, the team would often ask vendors for pricing again. Sometimes a fresh quote was necessary. But the company also wanted a practical way to look up recent information it already had.
We built that capability into its custom application: searchable historical vendor quotes, with a way to bring a selected material line into an estimate. The purpose was straightforward … make previous pricing accessible at the point where an estimator is doing the work.
Search the material, not just the file
A folder of quotes is organized around documents. An estimator’s question is usually about an item.
The workflow we built lets an estimator search quote lines from inside the estimate. The search can use a description, part number or quote reference, with vendor and date filters available to narrow the results.
The returned information includes the material description, supplier, price and quote date. The estimator can also open the source document to inspect the original quote.
That changes the task. Instead of first identifying a file and then looking through it for a usable number, the estimator can start with the material and review the relevant historical records. The original document remains available when context needs checking.
This is also a shared resource. Useful supplier information can support another estimator’s work instead of remaining buried in the history of the project for which it was first obtained.
A price without its context is not enough
We did not want the system to become a list of numbers detached from their sources.
Before reusing a price, an estimator needs to know what the supplier actually quoted. The material description, pricing unit, date and original document all matter. A number that looks suitable can still be based on a different unit, specification or quantity.
Consider a fictional example: an estimator needs four pieces of material for a new job and finds a previous quote for ten. Finding the previous quote is useful. Copying its quantity into the new estimate would not be. The person preparing the estimate still needs to enter the quantity required for the current work.
The same distinction applies to price. A per-piece price and a per-foot price cannot be treated as interchangeable simply because the material descriptions look similar. The workflow gives the estimator access to the record and its source; it does not remove the need to check the basis of the price.
That is why source access belongs in the workflow, not somewhere separate that people have to remember to visit.
Bring a selected line into the estimate, then review the work
Once the estimator has found a suitable historical line, the application provides an action to add it to the materials worksheet.
The selected description and unit cost are carried into a new line, along with information identifying the supplier and quote. The quantity for the new estimate is left for the estimator to enter. They can then review the line and its extended cost as part of the estimate.
That is a controlled use of existing information. The estimator searches, checks and selects. The software helps carry the chosen information forward rather than asking the person to recreate the entire line.
The quote library also supports bringing information in from uploaded supplier documents, with review and correction where needed. That supports the same goal: turning saved documents into usable records without treating every imported field as automatically correct.
Historical pricing is a reference, not a live supplier commitment
A useful historical-pricing system should make it clear what the information is … and what it is not.
A previous quote records what a supplier offered at a particular time and on particular terms. Its presence in the application does not confirm current availability, extend an expired offer or guarantee that the same price applies to a new order.
The estimator may still need an updated quote because the material requirements have changed, the price is no longer current or the new job needs a supplier commitment. History can provide context for that conversation without replacing it.
The workflow does not place orders or obtain competitive bids automatically. It helps the team use its own records more deliberately. That is a narrower claim than automating purchasing … and a more useful description of what we built.
The opportunity was already in the business
For this client, the starting point was not a lack of supplier information. It was difficulty finding and using information already received.
Once quote records became searchable within estimating, the company had another way to make its past work useful. A document saved for one project could support the next estimator’s research, with the source still available for review.
That is the kind of improvement we look for when working with construction and service businesses. Before adding another tool, we want to understand what people already know, where that information lives and what prevents them from using it.
Contact us about how your team finds previous supplier pricing. We can discuss whether a shared quote workflow would address a real gap in your estimating process.