app.knowrfp.ai/projects/glenwood-juice-2
Live
Integrations Northvale knowrfp
‹ GJ

Glenwood Juice 2

12 files · 34 runs
History 34 Download Insights Explore
Generate proposal ⋮
FILES12 12 selected Deselect all
Add files
Files are saved to the project immediately.
History⛶   ✕
Search runs by name or id…
Select all
‹Run⛶   ✕
Proposal Run log
Rating plan
Review the agent's plan before rating
2 datasets
STRATEGY

Grouped the three 1544-row 'Data' sheets from the Bolingbrook and Canada files into a single dataset, rating only the latest version (20260410). The 523-row 'Data' sheet from the Midwest Ashcroft file is treated as a separate dataset. Both datasets are routed to the API because they contain standard origin, destination, weight, and date columns. Excluded the 'Non Fairmarket US data' and warehouse questionnaires as they contain aggregated annual data or non-shipment information.

Glenwood Juice Bolingbrook Data
version policy: latest
TMS API
Why this methodThe dataset contains standard shipment columns (origin and destination city, state, zip, weight, pallets, date) that map directly to the API.
GroupingThese sheets all contain 1544 rows with identical shipment columns (RefNo, SD, ShipCity, ConsCity, etc.). They are versions of the same dataset, so we use the latest file based on the date in the filename.
RATING SHEET(S)
Glenwood Juice 2/Glenwood Juice Bolingbrook Proposal 20260410.xlsx / Data
›FIELD MAPPING & SAMPLE

2/2 dataset(s) rated with valid data

Glenwood Juice Bolingbrook Data: All 2,224 lanes were successfully priced for a total cost of $1.28 million, averaging $574.37 per lane with costs ranging from $304.36 to $2,308.16. The transport mode for every lane is currently classified as 'Unknown'. Two significant anomalies require immediate attention: 19 extreme high-cost outliers were detected, and all 2,224 rows contain $0 or negative totals.; Midwest Ashcroft Vitality Chicago RT: All 523 lanes were successfully priced, resulting in a total freight cost of $1.41 million and an average cost of $2,705 per lane. The freight mix is heavily dominated by Truckload (511 TL vs. 12 LTL), with individual lane costs ranging from $692.57 to $4,864.57. No pricing anomalies were detected in this batch.

Rated CSV
Glenwood Juice Bolingbrook Data · api · massrating 2224 priced · run 102843 Rated ⬇ TMS input
Midwest Ashcroft Vitality Chicago RT · api · marketrating 523 priced · run 102844 Rated ⬇ TMS input
Customer deliverable
Rate tables + rated data → one workbook per dataset
Glenwood Juice Bolingbrook Data PALLET-BASED
LTLRates: 26 unique lane(s) probed on 'massrating' → $/pallet at 2/3/4/5/6/7/8/9; Rate Base = API distance, Minimum = min-break freight. Rules + Accessorials + LTLFSC/TLFSC from the standard Northvale tables.
Data · 2224 LTLRates · 26 LTLFSC · 60 TLFSC · 98 Rules · 13 Accessorials · 11
Download .xlsx (6) Share with client
TELL THE AGENT WHAT TO CHANGE
LTLRates e.g. "add a 10% markup" · "rebuild on a per-cwt basis" · "go back and mass-rate against ACME" Send
Edits target the selected sheet. Basis rebuilds & "go back to re-rate" apply to the whole dataset.
+ New sheet from a formula
Give an instruction and re-run this project — e.g. 'also add the Midwest lanes', 'drop rows missing weight', or 'rate the Ashcroft sheet via the rate card instead'
Reiterate
Both summaries check out
Bolingbrook  2,224 × $574.37 = $1,277,399 ≈ $1.28M ✓
Ashcroft           523 × $2,705   = $1,414,715 ≈ $1.41M ✓
freight mix  511 TL + 12 LTL = 523 = lane count ✓
The totals, the averages and the mode split all agree
Except these two, in one paragraph
SAYS
All 2,224 lanes were successfully priced for a total cost of $1.28 million … ranging from $304.36 to $2,308.16
ALSO SAYS
all 2,224 rows contain $0 or negative totals
a set totalling +$1.28M with a floor of $304.36
cannot also be entirely $0 or negative
One of the two is wrong — and a client would read both
Four of six sheets are the Reference page
LTLFSC  60  = Reference · Fuel surcharge, LTL
TLFSC   98  = Reference · Fuel surcharge, TL
Rules    13  = Reference · Rules
Accessorials 11 = Reference · Accessorials
─────────────────────────────
+ Data 2224 + LTLRates 26 = 6 sheets = Download .xlsx (6) ✓
"Stamped into every customer deliverable" — literally
KnowRFP · Project runs
One project
KnowRFP Agent
Proposal intelligence · Northvale
Live analysis
Lanes priced
0
Freight cost
0
Sheets shipped
0
Contradictions
0
Before this goes to a client
✓
Both datasets reconcile
2,224 × $574.37 and 523 × $2,705 land on the stated totals; 511 TL + 12 LTL = 523 exactly.
!
One paragraph contradicts itself
"$1.28 million, ranging from $304.36" and "all 2,224 rows contain $0 or negative totals".
!
The plan says 1,544 rows; the result says 2,224
It reports rating only the latest version — worth confirming which rows were priced.
✓
The shared tables really are stamped in
LTLFSC 60, TLFSC 98, Rules 13, Accessorials 11 — the Reference page, sheet for sheet.
KnowRFP Agent
Re-check the anomaly ruleDownload anyway
!
Two things to settle first
The $0-or-negative claim · 1,544 rows vs 2,224 lanes

12 files in.A priced workbook out.

Open one run and you get the agent's plan, why it grouped the sheets that way, what it priced, and the workbook it built — with your own rate tables already inside it.

Runs
34
Lanes priced
2,747
Sheets out
6

It shows its working,
then hands you the workbook.

Every run keeps the strategy, the grouping decision, the rated totals and the deliverable together — so you can check the reasoning before the client checks the price.

0:00
2:24 1x