Description
i need to combine the order data, then show average transit time and average cost per package if:
- Shipping from 2 nodes LAX and NJ
- Shipping from single node LAX
- Shipping from single node NJ
- Shipping from single node OH
Also attached are zones with average transits from each zip to destination zips, with DHLeC.
Assumptions:
- 30-pack products weight 12oz - shipped via Parcel Expedited
- 5-packs are 2oz - shipped via Parcel Expedited
- 10-pack are 4oz - shipped via Parcel Expedited
- 60-packs are 24oz - shipped via Parcel Plus Expedited
- 120-packs are 48oz - shipped via Parcel Plus Expedited
- T-shirts, hats, tote bags, and bottles - 8oz shipped via Parcel Expedited
- Multi-unit orders should calculate total weight of the order based on the above. Anything under 1lbs should ship Parcel Expedited. Anything over 1lbs should ship Parcel Plus Expedited