Trucking Optimization

From UG

Revision as of 19:59, 5 May 2010

Trucking Optimization Report Version 1

see April_21_NATP_Changes#Trucking_Optimization_Report

See new version at April_21_NATP_Changes#Figure_2.a and April_21_NATP_Changes#Figure_2.b

This spreadsheet is changed from grouping by pick up State to grouping by pick up zone.

Zoning

• Client Zones based on historical data
• Client Zones based on incoming data
• Client Pick Up zones
• Client Delivery To zones
• Trucker Pick Up zones
• Trucker Delivery To zones
• required Business Objects (BO)
• required CRUD for BO and required logic
• Trucking Optimization Report Version 2

See Create Zone at Zoning

Alerts

It is an alert notification that system tells users that shipments in a particular zone location are ready to pick up. System will send an alert via email as well as show on the dashboard when there is enough shipments to fit on at least one truck. System will consider delivery location zone and pick up location zone; it is a pairing of Delivery Location zone and Pick up Location zone.

• Each time shipment is created with the weight, cbm, and/or pallets information, these info will be added to a table and calculated.
  • Each table is a combination of delivery location and pick up location zone
• The calculation result meets the minimum space to fit in one truck
• System should be able to calculate and provide information about:
  • what size of truck to send
  • how many trucks to send
  • require Haz driver or not

NOTE: It should be automatically alert real time when there is enough shipments (pallets) that need to be pick up.

Dashboard

• Create a dashboard that indicates a pair of delivery and pick-up zones, showing weight, cbm, pallets with a traffic light
• Traffic light indicates whether shipments are ready to pick up
• Dashboard will indicate the zone that needs to be pick up and delivery regarding due date
• Zones should be sorted by the earliest due date to latest due date
• Dashboard should be able to view information

• Table of information with traffic light
• bar and or pie charts
• custom maps indicates locations, zones, number of pallets that need to be pick up and number of pallets that need to be deliver at particular location. This can be indicated by color to differentiate the locations and zone, etc

Visualization