Zone Rate Cards: Price by Zone and Weight Band
This lesson is part of the course
In this lesson
You read each parcel's rate from a zone × weight-band rate card with a two-way INDEX/MATCH that uses an approximate match for the weight, compare shipping with the order value, work out the cost per billable kg by zone and flag the parcels that eat more than 15% of the order.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Actual vs Dimensional Weight: Billable Weight per Parcel Locked
- Zone Rate Cards: Price by Zone and Weight Band Locked
- Box Selection: Smallest Fitting Box and Dim-Weight Savings Locked
- Packaging Cost per Order: Box, Filler, Tape, Label & Insert Locked
- Surcharges: Residential, Remote Area & Fuel → All-in Cost per Parcel Locked
- Shipping-Charge Strategy: Flat Fee, Pass-Through or Free Above a Threshold Locked
- Carrier Mix: Cheapest Carrier per Parcel, On-Time Trade-Off & Routing Savings Locked
- Shipping Dashboard: Cost % of Revenue, Cost per Parcel by Zone and the Trend Locked