i need to combine the order data, then show average transit time and average cost per package if:

data mining

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


Related Questions in data mining category