# Quote Follow-Up Cadence Tracker Worksheet

> Source: https://netray.co/tools/quote-follow-up-cadence-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A tracker for open manufacturing quotes with probability-weighted pipeline value and automatic stale-quote flags.

## Category

industry-templates

## Industry

Job Shops & Contract Manufacturing

## Audience

- Estimator
- Sales engineer
- Inside sales

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Quote #

**Key:** quote

**Type:** text

#### Customer

**Key:** customer

**Type:** text

#### Buyer / contact

**Key:** contact

**Type:** text

#### Sent date

**Key:** sent

**Type:** date

#### Quote value

**Key:** value

**Type:** number

**Format:** currency

#### Days open

**Key:** days

**Type:** number

**Unit:** days

**Help:** Calendar days since the quote was sent. Update weekly.

#### Follow-up touches

**Key:** touches

**Type:** number

**Help:** Calls, emails or visits since sending.

#### Win probability

**Key:** prob

**Type:** number

**Unit:** %

**Help:** Your current estimate, revise after each customer contact.

#### Weighted value

**Key:** weighted

**Type:** number

**Expr:** value * prob / 100

**Format:** currency

#### Stale (1 = yes)

**Key:** stale

**Type:** number

**Expr:** if(and(gt(days, 14), lt(touches, 2)), 1, if(gt(days, 30), 1, 0))

**Format:** integer

**Help:** Flags quotes open over 14 days with fewer than 2 touches, or any quote open over 30 days.

#### Next action

**Key:** next

**Type:** select

**Options:**

- Call buyer
- Email revision
- Send samples
- Schedule visit
- Close out

#### Next action date

**Key:** due

**Type:** date

**Rows:**

**Quote:** Q-26-2201

**Customer:** Northline Hydraulics

**Contact:** R. Alvarez

**Sent:** 2026-10-01

**Value:** 48500

**Days:** 19

**Touches:** 2

**Prob:** 45

**Next:** Call buyer

**Due:** 2026-10-21

**Quote:** Q-26-2204

**Customer:** Brightwell Controls

**Contact:** S. Okafor

**Sent:** 2026-10-05

**Value:** 34800

**Days:** 15

**Touches:** 1

**Prob:** 30

**Next:** Email revision

**Due:** 2026-10-20

**Quote:** Q-26-2207

**Customer:** Calder Aerospace Fittings

**Contact:** T. Marsh

**Sent:** 2026-09-12

**Value:** 126000

**Days:** 38

**Touches:** 3

**Prob:** 15

**Next:** Close out

**Due:** 2026-10-22

**Quote:** Q-26-2210

**Customer:** Ridgeway Pump Co

**Contact:** J. Lindqvist

**Sent:** 2026-10-14

**Value:** 71000

**Days:** 6

**Touches:** 1

**Prob:** 35

**Next:** Schedule visit

**Due:** 2026-10-27

**Totals:**

#### Open quote value

**Key:** value

**Agg:** sum

**Format:** currency

#### Probability-weighted value

**Key:** weighted

**Agg:** sum

**Format:** currency

#### Stale quotes

**Key:** stale

**Agg:** sum

**Format:** integer

#### Average touches per quote

**Key:** touches

**Agg:** avg

**Format:** decimal

**Summary:**

#### Share of quotes stale

**Key:** stale_share

**Expr:** sum_stale / max(count, 1) * 100

**Format:** percent

#### Weighted value as share of open value

**Key:** weighted_ratio

**Expr:** sum_weighted / max(sum_value, 1) * 100

**Format:** percent

**Description:** A rough pipeline quality indicator.

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use the tracker

**Body:** 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

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### How often should I follow up on a manufacturing quote?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

quote follow up tracker, quote follow up template, open quotes tracker excel, manufacturing quote pipeline, job shop quote follow up cadence, stale quotes, quote pipeline weighted value, quote status log

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json