New Order Bank

Turn the allocation offer into a ranked accept / prioritize / pass list

One vehicle line at a time. Bring your stock & incoming list, your sales history, and the factory's allocation offer — key it in or upload a CSV — and this ranks what to fight for, what to take, and what to pass.

Run settings

One run = one vehicle line, one allocation offer. Target days' supply defaults to 45.

Vehicle line

Run date

Target days' supply

Sales history period

Regional pool note (informational only — shown on the report, not used in the math)

1 & 2 — Stock & incoming

One row per unit (or a row per combo with a Qty). Status: Ground (on the lot), In-Transit, or Allocated. Mark presold units — they're excluded from available supply. Upload a single CSV with a status column to cover current stock and incoming together.

Model code	Trim	Ext color	Int color	Status	Presold	Qty

Upload stock & incoming (CSV)

4 — Sales history

Retail sales for this line over the period set above. One row per combo with a sold-quantity column, or one row per unit sold (each row counts as one).

Model code	Trim	Ext color	Int color	Qty sold

Upload sales history (CSV)

3 — Factory allocation offer

What Toyota is offering this cycle for this line — one row per combo, with a quantity-offered column, or one row per unit offered.

Model code	Trim	Ext color	Int color	Qty offered

Upload allocation offer (CSV)

Ranked result

Ranked by need, then by sales velocity as the tiebreaker. Prioritize = top-quartile seller and short — fight for these. Accept = above-median seller (or otherwise short) — take if offered. Pass = already at or over target, or zero history with no presold. Not Offered = you're short but the offer didn't cover it — flag it.

Model code	Trim	Ext	Int	On hand	Incoming	YTD sold	Supply days	Offered	Rank	Recommendation	Why	Received

Plain-English summary

Saved runs

Browse past runs by vehicle line. Loading a run replaces everything above with that run's saved data.