TMS Monthly Stats Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Business Requirements & Current Business Process)
(Business Requirements & Current Business Process)
Line 47: Line 47:
=== Separate FTL ===
=== Separate FTL ===
 +
 +
FTL =
 +
 +
=== Separate Exceptional FTL ===
=== Separate Tri-State ===
=== Separate Tri-State ===
Line 53: Line 57:
=== Separate Northbound ===
=== Separate Northbound ===
 +
 +
=== Separate LTL Northbound Savings ===
=== Separate LTL ===
=== Separate LTL ===
-
=== Separate Small Package ===
+
=== Separate LTL Savings===
-
=== ===
+
=== Separate Small Package ===
=== Figures ===
=== Figures ===

Revision as of 18:29, 9 August 2011


Contents

Info

Mantis: 0003003: [TMS optimization] TMS Monthly Stats (make it art of CT2) 3003

Summary

Elizabeth Arden's supply chain management requires a monthly statistical report of their domestic trucking activities. In addition to their actual figures and numbers, they also require an idea of how or where they can save money within their supply chain. The concept here is to add functionality, which is currently a manual process, into CT2, to automate these high level reports of the monthly domestic trucking statistics.

Business Requirements & Current Business Process

Generate report from the TMS

This report is called "Supplier Detail Previous Month". It was built by Descartes according to Marc's/Elizabeth Arden's requirements. The report contains the number of lanes (Origin to destination) covered per month with the totals of their loads, broken down per carrier. These are the report columns set from the TM:

  • Supplier
  • Origin State
  • Origin Zip
  • Consignee
  • Destination State
  • Destination Zip
  • Carrier
  • Load Count
  • Total Charge
  • Total Weight
  • Total Pallets
  • Total Loose Package
  • Avg Weight Per Load
  • Avg Pallet Per Load
  • Avg Loose Package Per Load
  • Lowest Weight Per Load
  • Highest Weight Per Load
  • Lowest Pallet Per Load
  • Highest Pallet Per Load
  • Lowest Loose Package Per Load
  • Highest Loose Package Per Load
  • Cost Per Lb

These columns and their values are used to make up the entire report (workbook) that is given to Elizabeth Arden monthly.

Clean Up Results

1. As this report contains ALL lanes and their totals of loads, it will contain some moves that have total charges of $ 1.00. These need to be removed from the results as ALL $ 1.00 charges are for lanes that the business team does not have rates for when they tender a load to a carrier, as the TM will not allow a load to be tendered unless it is rated.

2. As ALL lanes must be unique, we double check the Supplier Names & Origin Zip with the Consignees Name & Destination Zip AND the carrier. If necessary I will combine lanes as the TMS considers the suppliers/consignee's companies name to determine if it is a separate lane or not; it does not look at the street address, city name &/or state to determine this, so it is possible to have duplicate lanes on the report.

Separate FTL

FTL =

Separate Exceptional FTL

Separate Tri-State

Separate Tri-State Potential Savings

Separate Northbound

Separate LTL Northbound Savings

Separate LTL

Separate LTL Savings

Separate Small Package

Figures

TMS Report Menu

File:TMS Reports Menu.JPG


TMS Run Supplier Detail Report

File:Run Supplier Report.JPG


Supplier Detail Report Results

File:Results.JPG


Results in HTML (excel ss)

File:Results in HTML.JPG

Personal tools