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

Glenwood Juice 2

12 files · 41 runs History 41 Download Insights Explore Generate proposal ⋮
FILES12 12 selectedDeselect all
Add files
Files are saved to the project immediately.
Generate proposal ×
What happens next

Agent maps your files → prices every lane via TMS → gives a rated proposal. Asks if anything's missing; nothing sent until you approve.

Also generate for this run — saved to History
Insights Explore
Add optional instructions — the agent follows them exactly. Leave blank to run as-is.
General instructions(for all files — optional)
e.g. Treat 2025 files as the latest version; exclude anything labelled 'quote'; origin warehouse is Dallas, TX.
Cancel Generate proposal
‹ Run ×
Working… 3s
Run in background
ProposalRun log

Rating plan

Review the agent's plan before rating

 2 datasets
! Midwest Ashcroft Vitality Chicago RT needs your input — 1 required column to fill · 4 optional columns with 1,570 blank cells. Fill below with a value/formula or by hand.
! Glenwood Juice Bolingbrook Data needs your input — 1 optional column with 1,544 blank cells. Fill below with a value/formula or by hand.
STRATEGY

Grouped the three 'Data' sheets from the Bolingbrook and Canada files into a single dataset using the 'latest' policy, as they share identical schemas and row counts. The Midwest Ashcroft Vitality file contains a distinct shipment dataset and is treated as a single version. Both datasets contain standard origin and destination zip codes and weights, so they are routed to the API. All other files and sheets are either rate cards, FSC schedules, rules, or non-shipment aggregates (annual sales, warehouse questionnaires) and are excluded from rating.

Fill columns· 6 columns across 2 datasets
!Midwest Ashcroft Vitality Chicago RT— 5 columns need a value (1 required)
commodityREQUIRED
Not in the source — give a value for every row (a number, a formula over the other columns, or plain English).
Commodity…
Freight All KindsDry Foods & Ingredients Fresh Foods & IngredientsFrozen Foods & Ingredients Ice Cream & Frozen Novelties
palletsoptional · 523 blank cells
Some cells are blank — defaults to 0 if left blank. Fill only those, or leave blank to accept that.
leave blank for 0, or a formula like pieces*2
Assume 0 (blank cells)gross_weight / 1500 pieces / 40 Fill blank cells manually
piecesoptional · 523 blank cells
Some cells are blank — defaults to 0 if left blank. Fill only those, or leave blank to accept that.
leave blank for 0, or a formula like pallets*40
Assume 0 (blank cells)pallets * 40 Fill blank cells manually
gross_weightoptional · 1 blank cell
Apply 6 fills
?How should we rate 'Glenwood Juice Bolingbrook Data' — Market Pricing or Mass Rating?
Recommended: Mass Rating — This data has pallet counts, so Mass Rating against a contract will price it.
Market PricingMass Rating ★
Glenwood Juice Bolingbrook Data
version policy: latest TMS APIRate sheet
Why this methodThe dataset contains standard origin and destination postal codes (ShipZip, ConsZip), weight/cases, and dates, which map perfectly to the API. GroupingThese three sheets share identical columns and row counts (~1544 rows), representing updated versions of the same shipment dataset. The 20260410 file is the most recent.
?How should we rate 'Midwest Ashcroft Vitality Chicago RT' — Market Pricing or Mass Rating?
Recommended: Market Pricing — No pallet counts detected — Market Pricing is recommended (it rates without a pallet-priced contract, which Mass Rating requires).
Market Pricing ★Mass Rating

2/2 dataset(s) rated with valid data

Glenwood Juice Bolingbrook Data: All 1,544 lanes were successfully priced, resulting in a total freight cost of $884,793.31 and an average cost of $573.05 per lane. Lane costs range from a minimum of $304.36 to a maximum of $2,308.16. However, there are 15 extreme outliers in the dataset that should be reviewed for potential pricing anomalies.; Midwest Ashcroft Vitality Chicago RT: All 523 lanes were successfully priced, resulting in a total freight cost of $1.2 million and an average cost of $2,303 per lane. The freight mix is heavily dominated by Truckload shipments, with 519 TL compared to just 4 LTL, and individual lane costs ranging from $692.57 to $4,702.00. No pricing anomalies were detected in this output, indicating a clean and complete rating process.

Glenwood Juice Bolingbrook Data · api · massrating 1544 priced · run 102861 Rated TMS input
Midwest Ashcroft Vitality Chicago RT · api · marketrating 523 priced · run 102862 Rated TMS input
Rated CSV
Customer deliverable
Rate tables + rated data → one workbook per dataset AutoCWTPallet Build deliverable
Glenwood Juice Bolingbrook DataPALLET-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 · 1544 LTLRates · 26 LTLFSC · 60 TLFSC · 98 Rules · 13 Accessorials · 11
Download .xlsx (6) Share with client
Optional instruction for the whole pipeline (one per line) — e.g. 'group the two Bolingbrook files as one dataset' or 'rate the Ashcroft sheet via the rate card, not the API'
Answer questions to continue Iterate
Six columns to fill
Ashcroft · 4 optional columns1,570 blank pallets 523 · pieces 523 · gross_weight 11,047 so the fourth column holds523 — every row Bolingbrook · 1 optional column1,544 — every row commodity is not in the source at all523 to invent
3,114blank cells, and three columns entirely empty
One default, two rating methods
pallets · blank cells523 of 523 the chip you pickAssume 0 (blank cells) two screens later the agent says"No pallet counts detected" Midwest Ashcroft Vitality Chicago RTMarket Pricing ★ Glenwood Juice Bolingbrook — pallets intactMass Rating ★
1dropdown decided how 523 lanes were priced
The same 1,544 rows
this run · massrating$884,793.31 $573.05 / lane Insights · TOTAL SPEND card$663,680 $429.84 / shipment difference$221,113.31 Project Runs · the earlier run rated2,224 lanes this one plans 1,544 and rates 1,544 — the gap is gone✓
1.33×two totals for one dataset, in one product
KnowRFP Agent
Reviewing run 102861 · 102862 LIVE
Lanes priced
0
Datasets
0
Blank cells
0
Sheets out
0
!A default chose the rating methodAssume 0 on 523 pallet cells → "No pallet counts detected" → Market Pricing
~Three columns are 100% empty523, 523 and 1,544 blanks — the blank count equals the row count each time
~15 outliers flagged, then shipped0.97% of Bolingbrook's lanes, still in the deliverable
✓1,544 planned, 1,544 ratedThe earlier run's 2,224 against the same sheet is gone
Agent
Re-rate with palletsShow the 15 outliers
!
Two step names ran twice
At 76s: Mapping to rating input · Planning datasets · Mapping to rating input

12 files in.2,067 lanes priced.

The agent reads the folder, groups it into datasets, tells you what it plans to do, asks what it can't infer — and prices nothing until you've answered. Here is that run, end to end.

Datasets
2
Questions
2
Sheets out
6

It shows you the plan
before it prices.

Every dataset it found, the method it wants to use and why, the columns it can't fill on its own — then one workbook per dataset, with the rate tables already in it.

Chapter
0:00
2:48 1x