# RFQ Intake Triage Scoring Worksheet for Job Shops

> Source: https://netray.co/tools/rfq-intake-triage-scoring-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Log every inbound RFQ, score it on fit, customer, completeness and margin, and see which ones deserve estimating hours first.

## Category

industry-templates

## Industry

Job Shops & Contract Manufacturing

## Audience

- Estimator
- Sales engineer
- Operations manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### RFQ #

**Key:** rfq

**Type:** text

#### Customer

**Key:** customer

**Type:** text

#### Received

**Key:** received

**Type:** date

#### Part family

**Key:** family

**Type:** select

**Options:**

- Turned
- Milled
- Sheet metal
- Weldment
- Assembly
- Other

#### Est. order value

**Key:** value

**Type:** number

**Format:** currency

**Help:** Total expected PO value if won, not annual run rate unless it is a blanket order.

#### Process fit (1-5)

**Key:** fit

**Type:** number

**Help:** 5 = runs on our core equipment and materials, 1 = needs outside processes or new capability.

#### Customer score (1-5)

**Key:** cust

**Type:** number

**Help:** 5 = repeat buyer, pays on terms, 1 = unknown or slow payer.

#### Package complete (1-5)

**Key:** complete

**Type:** number

**Help:** 5 = print, model, spec, qty and due date all present.

#### Margin potential (1-5)

**Key:** margin

**Type:** number

#### Est. quoting hours

**Key:** hours

**Type:** number

**Unit:** h

#### Triage score

**Key:** score

**Type:** number

**Expr:** (fit * 30 + cust * 20 + complete * 20 + margin * 30) / 5

**Format:** percent

#### Score per quoting hour

**Key:** per_hour

**Type:** number

**Expr:** (fit * 30 + cust * 20 + complete * 20 + margin * 30) / 5 / max(hours, 0.25)

**Format:** decimal

#### Action

**Key:** action

**Type:** select

**Options:**

- Quote now
- Quote this week
- Request missing info
- Decline

**Rows:**

**Rfq:** RFQ-26-0412

**Customer:** Northline Hydraulics

**Received:** 2026-10-12

**Family:** Milled

**Value:** 48500

**Fit:** 5

**Cust:** 5

**Complete:** 4

**Margin:** 4

**Hours:** 3

**Action:** Quote now

**Rfq:** RFQ-26-0413

**Customer:** Calder Aerospace Fittings

**Received:** 2026-10-12

**Family:** Turned

**Value:** 126000

**Fit:** 4

**Cust:** 3

**Complete:** 3

**Margin:** 4

**Hours:** 8

**Action:** Request missing info

**Rfq:** RFQ-26-0414

**Customer:** Unknown (web form)

**Received:** 2026-10-13

**Family:** Weldment

**Value:** 22000

**Fit:** 2

**Cust:** 1

**Complete:** 2

**Margin:** 3

**Hours:** 6

**Action:** Decline

**Rfq:** RFQ-26-0415

**Customer:** Brightwell Controls

**Received:** 2026-10-14

**Family:** Sheet metal

**Value:** 34800

**Fit:** 5

**Cust:** 4

**Complete:** 5

**Margin:** 3

**Hours:** 2

**Action:** Quote now

**Rfq:** RFQ-26-0416

**Customer:** Ridgeway Pump Co

**Received:** 2026-10-15

**Family:** Assembly

**Value:** 71000

**Fit:** 3

**Cust:** 4

**Complete:** 3

**Margin:** 5

**Hours:** 10

**Action:** Quote this week

**Totals:**

#### Total RFQ value in queue

**Key:** value

**Agg:** sum

**Format:** currency

#### Total quoting hours needed

**Key:** hours

**Agg:** sum

**Format:** number

#### Average triage score

**Key:** score

**Agg:** avg

**Format:** percent

**Summary:**

#### Queue value per quoting hour

**Key:** value_per_hour

**Expr:** sum_value / max(sum_hours, 1)

**Format:** currency

**Description:** Rough indicator of how much order value each estimating hour is chasing.

#### RFQs in queue

**Key:** rfq_count

**Expr:** count

**Format:** integer

**Notes:** Triage score weights: process fit 30%, margin potential 30%, customer 20%, package completeness 20%, each rated 1-5 and scaled to a percentage. Change the weights in your exported copy to match your shop. Score per quoting hour favors quick wins, so do not let it bury a large strategic RFQ.

## Content

**Intro:** Most job shops receive more RFQs than the estimating desk can price in a week, and the default order of work is whoever emailed last or shouted loudest. This worksheet gives you a repeatable way to rank the queue before anyone opens a print.

**Sections:**

#### How to use the triage worksheet

**Body:** Add one row per inbound RFQ the moment it arrives. Rate process fit, customer quality, package completeness and margin potential from 1 to 5 using the cell hints, enter your best guess of quoting hours, and the sheet computes a triage score and a score per quoting hour. Sort by score per hour to find quick wins, then by score to protect large strategic quotes. Set the action column so the whole team can see what happens next. Export to Excel for a shared log or PDF for the Monday sales meeting.

**Bullets:**

- Rate within five minutes of receipt, not after a deep read of the print.
- Use the same person for ratings so scores stay comparable.
- Review the Request missing info rows daily so they do not stall.

#### The scoring method

**Body:** The triage score is a simple weighted average: (fit x 30 + customer x 20 + completeness x 20 + margin x 30) divided by 5, giving a 0 to 100 percent scale where 100 means every factor is rated 5. Score per quoting hour divides that by estimated hours, floored at 0.25 hours to avoid division blow-ups. It is not a probability of winning. It is an ordering tool, similar to a weighted decision matrix used in bid screening.

#### Reading the results

**Body:** A score above 75 percent with a low hours estimate is a quote-now job. A mid score with a large value, like the aerospace fittings row in the example, usually needs a call to the buyer to fix completeness before you spend eight hours. A score below 45 percent with a weak customer is a decline candidate. Watch queue value per quoting hour: if it falls week over week you are spending estimating time on lower value work.

#### Common mistakes

**Body:** Do not score margin potential from the customer's target price alone, use your own rough cost. Do not rate completeness as 5 just because a PDF is attached: check for tolerances, material callout, quantity breaks and a due date. Finally, record declines too. A log of declined RFQs is the cheapest market intelligence a shop has.

**Cta:** If your RFQs arrive as email attachments and your ERP holds the real cost history, we can help automate scoring against past quotes and capacity. This worksheet works fine without us.

**Faq:**

#### How many RFQs should a triage log track?

**Answer:** Every one, including those you decline. A complete log lets you compute true hit rate, see which customers send unquotable packages, and measure how much estimating time goes to low-value requests. Without declines in the data, your win rate looks better than reality.

#### Can I change the scoring weights?

**Answer:** Yes. Export to Excel and edit the formula. Shops with tight capacity often weight process fit higher, while shops chasing growth weight customer and margin. Keep the weights summing to 100 so the score stays on a clean percent scale.

#### Should estimating hours be a guess or a standard?

**Answer:** Start with a guess by part family, then replace it with real averages after a month of time tracking. Simple parts from repeat customers might take 30 minutes, while assemblies with outside processing can take a full day.

#### Is a high triage score the same as likely to win?

**Answer:** No. It ranks where to spend estimating effort. Win probability depends on price, lead time and relationships. Use the bid/no-bid scorecard calculator when you need an expected-value view for a specific large quote.

## Search terms

rfq triage, rfq intake log excel, rfq prioritization worksheet, job shop rfq log, quote request tracker template, estimator queue prioritization, rfq scoring template, which rfq to quote first

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