Excell Brands - Route Planner

Setup

Stores

Optimize

Results

Rep Setup

⏳ Loading store directory...

Rep Name

District

Zone

Sector

Home Address

If your address is not found, try a nearby landmark - a grocery store, post office, or gas station within a few blocks works fine as a route anchor.

Working Days

Weekly Hours Target

Min hrs/week

–

Max hrs/week

Optimizer targets min hrs; flags days that push total above max. Override fields are always editable.

Min 2nd-Visit Gap

Daily Hard Cap (hrs) - max hours per day

Long Day Flag (hrs) - soft warning threshold

Hard cap blocks placement. Long Day flag is a soft warning only.

Priority Sequencing Threshold - max route distance increase to move high-priority store earlier

% If moving a high-priority store earlier adds more than this % to the day's route distance, it stays in optimal position.

Store List

Store Name

Store Address - Street, City, State ZIP in one field

Store # - Tab or Enter to lookup

Visit Frequency

Account Type

Primary: Target | Auxiliary: B&N, Blains, Fred Meyer, H-E-B, Kroger

Priority

High priority stores claim interior days first and are sequenced earlier within a day.

Pin to specific day(s) (lock this store to one or more working days)

Drop your CSV here, or click to browse

Accepts .csv or .txt files - any column order

Store	#	Freq	Svc	Pri	Pin

⬆ Load Sector JSON 📂 Load Route

How to Use the Route Optimizer

Enter the rep's name and home address in Rep Setup
Configure working days, target hours, and daily caps
Add stores manually or upload via CSV. Each store needs a name, store number, address, visit frequency, and account type
Visit Frequency: Every Other Week, 1x Weekly, 2x Weekly, or 3x Weekly (MVM). MVM stores require a Mon/Wed/Fri or Tue/Thu/Sat pattern and are always scheduled as stop 2 or 3
Account Type sets service time automatically - Primary (Target) = 3.0h, Auxiliary (B&N, Blains, Fred Meyer, H-E-B, Kroger) = 1.0h, Custom = enter manually
Mark stores High Priority to give them better day placement and earlier sequencing within a day
Hit Optimize Route - the planner clusters stores geographically, assigns days, balances the week, and calculates real road distances
Review flags on day cards - High Drive, High Miles, Route Outlier, and Backtrack indicate days that may benefit from manual adjustment
Drag stops between days to adjust. Stat boxes refresh automatically. Use Reset or Restore All to revert to optimizer recommendations
Download Rep or Manager PDF when ready. Switch to Baseline tab to compare against the rep's current route

Baseline
Comparison Tool

Enter the rep's current route to see how it compares against the optimized schedule. Upload a CSV with the same format as the optimizer, plus Day and Stop Order columns. Miles and drive time are calculated using real road distances.

Current Route Setup

Rep Name

Home Address

Schedule Type

Upload Current Route CSV

Upload a CSV of the rep's current route. Required columns: Store Name, Address, Day, Stop Order. Optional: Store #, Service Hours, Week (A or B for biweekly).

Drop CSV here or click to browse

Add Stop Manually ▼

How to use the Baseline Comparison Tool

Run the Route Optimizer for this rep first - results will populate automatically in the comparison view
Enter the rep's name and home address in the setup panel, then upload a current route CSV or add stops manually using the form below the upload zone
One row per visit - a 2x store needs two rows on different days, a 3x MVM store needs three rows, an every-other-week store needs one row with cadence EOW
Use the Week column (A or B) to separate biweekly route halves. Weekly stores repeat in both weeks, so include them in both A and B rows. EOW stores appear in one week only
Required columns: Store #, Store Name, Street, City, State, Day, Stop Order. Visit frequency defaults to 1x Weekly if omitted
Duplicate Store # on the same week, day, and stop order will be flagged before import
Click Calculate to run road-distance calculations, then review the savings summary

Comparison Results

Weekly Miles

Week A - Current -

Week B - Current -

Week A - Optimized -

Week B - Optimized -

Savings - -

Weekly Drive Hours

Week A - Current -

Week B - Current -

Week A - Optimized -

Week B - Optimized -

Savings - -

Weekly Total Hours (door-to-door)

Week A - Current -

Week B - Current -

Week A - Optimized -

Week B - Optimized -

Savings - -

Weekly Service Hours

Week A - Current -

Week B - Current -

Week A - Optimized -

Week B - Optimized -

Difference - -

Day-by-Day Breakdown

Week	Day	Stops	Current Miles	Opt Miles	Current Drive	Opt Drive	Current Total	Opt Total	Miles Saved

Sector
Analysis

Identifies the optimal hiring location for a sector by weighting each store's service requirements, geographic distance and labor market detail.

U.S. Census Bureau labor market data layers in candidate availability, workforce participation, vehicle ownership, and local retail talent supply. Use the weights panel to fine-tune the ranking for your sector's specific profile.

Sector Store List

No stores loaded

⬆ Load Sector JSON ⬆ Upload CSV

Region

District

Zone

Sector #

Max commute miles

Adjust how much each factor influences the recommended hiring location. Changes take effect immediately.

Working-Age PopulationAdults 25–54 in the ZIP code

35%

Labor Force ParticipationShare of adults actively working or seeking work

25%

Vehicle Ownership RateHouseholds with at least one vehicle

20%

Retail & Sales WorkforceExisting retail/CPG workers in the area

20%

Baseline
Comparison Tool

Sector
Analysis

District
Planner

BaselineComparison Tool

SectorAnalysis

DistrictPlanner

Baseline
Comparison Tool

Sector
Analysis

District
Planner