Quote Follow-Up Cadence Tracker Worksheet
Quotes that go quiet are rarely lost on price alone. They are lost because nobody asked. This tracker keeps every open quote in one place, with a probability-weighted value and an automatic stale flag so follow-up becomes a routine instead of a memory test.
| Quote # | Customer | Buyer / contact | Sent date | Quote value | Days open (days) | Follow-up touches | Win probability (%) | Weighted value | Stale (1 = yes) | Next action | Next action date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
$21,825 | 0 | |||||||||||
$10,440 | 1 | |||||||||||
$18,900 | 1 | |||||||||||
$24,850 | 0 |
Days open is typed in so the sheet works offline without a live clock. Common cadences: first touch within 2 to 3 business days of sending, a second at about day 7, and a decision request by day 14. Adjust the stale rule in your exported copy to match your sales cycle.
Automate stale-quote alerts from your ERP
Optional: ask for a review of how open quotes could be surfaced and nudged automatically.
Optional. The tool and every export work without this. No spam.
How to use the tracker
Add each quote the day you send it. Update days open and touches once a week, adjust win probability after any customer contact, and set a next action with a date. The weighted value column multiplies quote value by win probability, and the totals give you a pipeline view for sales meetings. Sort by the stale flag to build your follow-up call list for the day. Export to Excel to share with the sales team, or PDF for a weekly pipeline review.
The cadence logic
The stale flag follows a simple rule: a quote open more than 14 days with fewer than two follow-ups, or any quote older than 30 days, needs attention. Buyers at manufacturers often compare three to five quotes and decide in batches, so silence at day 10 usually means the file is sitting unread. A short, specific question such as asking whether the lead time works for their build schedule gets more replies than a generic check-in.
- Touch 1 (day 2 to 3): confirm receipt and ask about clarifications.
- Touch 2 (day 7): ask about decision timing and competing lead times.
- Touch 3 (day 14): request a go or no-go and offer a revision.
Reading the totals
In the example, 280,300 dollars sits in open quotes but the weighted value is far lower. A large gap between open and weighted value means most of the pipeline is speculative. If more than a third of quotes are stale, estimating capacity is being spent on quotes that will not convert. Close out stale quotes with a polite final note so the pipeline stays honest and your hit rate stays measurable.
Common mistakes
Leaving dead quotes open inflates the pipeline and deflates hit rate. Setting every probability to 50 percent defeats the weighting. Another trap is following up only on the biggest quotes: small repeat customers often close fastest and fund the shop's cash flow.
Frequently Asked Questions
How often should I follow up on a manufacturing quote?
A reasonable pattern is a first touch within three business days, a second around day seven, and a decision request around day fourteen. After that, monthly touches or a polite close-out. Adjust for programs where buyers have known decision dates.
How do I choose a win probability?
Use stage-based defaults such as 10 percent for no response, 30 percent for acknowledged and in review, 50 percent for price discussion, and 75 percent for verbal intent. Calibrate to your actual hit rates over time.
Should I close out old quotes?
Yes. Mark them lost or no decision with a reason so win/loss analysis stays accurate. Leaving them open pollutes pipeline totals and makes your hit rate look better than it is.
Can I link this to my ERP?
You can paste exported quote lines from most ERP quote or opportunity screens into the sheet. The template does not connect to any system itself, so refresh the data before each weekly review.
If your ERP already stores quotes, we can help build an automatic stale-quote report and reminder feed. This worksheet works independently of any ERP.
Related Tools
Quote Win/Loss Analysis Worksheet
Record outcomes and loss reasons, see price gap versus the winning bid, and compute hit rate by count and by dollar value.
Industry TemplatesRFQ Intake Triage Scoring Worksheet
Log every inbound RFQ, score it on fit, customer, completeness and margin, and see which ones deserve estimating hours first.
MES & Shop FloorQuote Turnaround Time KPI and Queue Calculator
Model how RFQ volume, quoting effort and estimator headcount drive utilization, queue wait and turnaround days.
Industry TemplatesJob Shop Quote Cover Letter Template
A fill-in quote letter for machined parts with quantity price breaks, assumptions, exclusions and standard terms.
More Industry Templates tools
See all- RFQ No-Bid and Decline Letter Template
- Distributor Free Freight Policy Template
- Monthly Operations Review Meeting Pack Template
- OEE Improvement A3 Charter Template
- Sheet Metal Job Traveler Template
- Press Brake Setup Sheet Template
- Sheet Metal Cut List and Material Takeoff Worksheet
- Welding Wire Deposition Rate Calculator
- Shielding Gas Consumption and Cost Calculator
Keep exploring
Free tools
- Job Shop On-Time Delivery Tracker WorksheetAn editable tracker that computes days late per job and the shop on-time delivery rate from promised and actual ship days.
- Standard Costing Process Maturity AssessmentTen questions that score how well your standard cost process holds up: update cadence, BOM and routing accuracy, variance follow-up and governance.
- Contract Manufacturer Job Quote Price CalculatorBuild a quote from material, setup hours, run time, outside processing and one time tooling, and see unit price fall as quantity rises.
ERP fixes and how-tos
- Epicor Kinetic Update Schedule: Release Cadence, Versions and Upgrade PlanningHow Epicor Kinetic releases are numbered and scheduled, how cloud and on-prem updates differ, and how to plan upgrades and regression testing.
- ERP Patching Cadence: How Often Should You Patch?How often to patch an ERP: separate OS, database and ERP layers, set a quarterly baseline with an emergency path, test in a sandbox, and plan rollback.
- How to Create a Quote in E2 Shop SystemHow to build a quote in E2 Shop System, from header setup through routing, material, and outside processing, to converting an accepted quote into a job.
Guides
- How to Follow Up on a Manufacturing Quote Without Being PushyA practical cadence for following up on job shop quotes: timing, what to say, how to learn why you lost, and how to automate reminders without annoying buyers.
- Plating Job Shop Quoting Software: What a Finishing Shop Actually NeedsPlating and metal finishing job shop quoting: how to price from spec, area, rack count and minimum lots, and where AI can draft quotes from customer POs.
- How to Reduce Quote Turnaround Time in a Machine ShopHow machine shops cut quote turnaround: where the delay hides, which steps to standardize, what to automate and what the estimator must own.
AI on your ERP
- AI for Epicor Kinetic Job Shops: Quote History, Job Variance and Schedule RiskPrivate AI for Epicor Kinetic job shops: quote-to-job history, JobHead and JobOper variance, subcontract delays and schedule risk, via REST and BAQs.
- AI for JobBOSS2 quoting and schedulingHow AI helps JobBOSS2 job shops quote from past job actuals and explain scheduling conflicts, with read-only access and private hosting options.
Software
- Cadence AllegroWhat Cadence Allegro is: PCB and package design, constraint management and analysis, how it connects to PLM and ERP, limits and alternatives.
- Altium DesignerWhat Altium Designer is, its schematic, PCB layout and BOM capabilities, ERP and PLM integration paths, limits and alternatives for electronics makers.