Parts Freight Calculator

Rate Administration

Edit rates, surcharges, and part categories. Changes take effect immediately for all users.

Base Freight Rates by Invoice Amount & Zone ($ per shipment)

Select a service to edit its rate table. Zones 1–10 across 12 invoice amount brackets.

Edit Service

✓ Saved.

Oversize / Heavy Items — Flat Freight Charge

These replace the base rate lookup entirely. When selected, the flat charge is the freight cost before address/fuel surcharges.

Item	Flat Charge ($)

✓ Saved.

Pricing Markup

Applied to the total freight charge before presenting to the customer. Not visible to salespeople.

Standard Markup (%)

Odd Dimension Markup (%)

✓ Saved.

Delivery Surcharges

Business Address Surcharge ($)

Residential Address Surcharge ($)

✓ Saved.

Rate Version Info

Version Label

Effective Date

✓ Saved.

Import Rate Tables from FedEx Spreadsheet

Upload your FedEx Excel file (.xlsx). The importer will scan all sheets for rate tables matching the standard FedEx format (12 invoice rows × up to 10 zones) and load them automatically.

📄

Click to select your FedEx .xlsx file

Supports the standard FedEx Tables sheet format

Expected Spreadsheet Format

Your FedEx spreadsheet should have a sheet named Tables or Tables (2) with this layout:

Row	Col A	Col B	Col C	Col D (index)	Col E–N (Zone 1–10)
1	Service Name	—	Invoice Amount	—	Zone headers
2–13	—	—	$1 to $25 … $701+	1–12	Rate values ($)

Each service block repeats this pattern. The importer detects blocks by looking for the service name in column A.