Automated generation of reports reflecting statistical analyses of supply chain processes

• US 7,693,739 B2
• Filed: 09/03/2004
• Issued: 04/06/2010
• Est. Priority Date: 09/05/2003
• Status: Active Grant

• Current Assignee: Sensitech Incorporated (Carrier Global Corporation)
• Original Assignee: Sensitech Incorporated (Carrier Global Corporation)
• Inventors: Schmidtberg, Rupert A., Leshuk, Jeffrey Allen
• Primary Examiner(s): Jeanty; Romain
• Application Number:
  US10/934,568
• Publication Number:
  US 20050055287A1
• Time in Patent Office: 2,041 Days
• Field of Search: 705/7
• US Class Current: 705/7.38
• CPC Class Codes: G01K 2215/00 Details concerning sensor power supply
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/083 Shipping
• CPC Class Codes: G06Q 10/0833 Tracking
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G08B 25/00 Alarm systems in which the location of the alarm condition is signalled to a central station, e.g. fire or police telegraphic systems

Abstract

The present invention is directed to systems and methods for collecting data concerning a supply chain, for performing statistical analysis on the collected data to facilitate identification of anomalies or inefficiencies in the process, and for communicating results of such statistical analysis to those responsible for the supply chain. A method for performing statistical analysis on monitored aspect of a product supply chain involves storing, in memory accessible to processor, first data reflecting first monitored aspect of a first shipment of first item occurring in the supply chain, and storing, in memory accessible to the processor, second data reflecting second monitored aspect of a second shipment of second item occurring in the supply chain. The processor is used to automatically generate report reflecting statistical analysis of the first and second data.

Claims

1. A method for performing statistical analysis on at least one monitored aspect of a product supply chain, comprising steps of:

physically associating at least one first sensor with at least one first item to monitor changes in at least one aspect of a first shipment comprising at least one physical or environmental condition of the at least one first item, the at least one first sensor being physically associated with the at least one first item such that the at least one first sensor remains physically associated with the at least one first item in the same way before and after the at least one first item is loaded onto or removed from a vehicle carrying the at least one first item during the first shipment;

storing, in memory accessible to at least one processor, first data reflecting the at least one physical or environmental condition of the first shipment of the at least one the first item occurring in the supply chain;

physically associating at least one second sensor with at least one second item to monitor changes in at least one monitored aspect of a second shipment comprising a physical or environmental condition of the at least one second item, the at least one second sensor being physically associated with the at least one second item such that the at least one second sensor remains physically associated with the at least one second item in the same way before and after the at least one second item is loaded onto or removed from a vehicle carrying the at least one second item during the second shipment;

storing, in memory accessible to the at least one processor, second data reflecting the at least one physical or environmental condition of the second shipment of the at least one second item occurring in the supply chain; and

using the at least one processor to automatically generate at least one report reflecting a statistical analysis of the first data and the second data.

2. The method of claim 1, wherein:

the at least one monitored aspect of the first shipment comprises a temperature of an environment in which the at least one first item was disposed during the first shipment; and

the at least one monitored aspect of the second shipment comprises a temperature of an environment in which the at least one second item was disposed during the second shipment.

3. The method of claim 1, wherein:

the at least one monitored aspect of the first shipment comprises a trip time of the first shipment; and

the at least one monitored aspect of the second shipment comprises a trip time of the second shipment.

4. The method of claim 1, wherein:

the at least one monitored aspect of the first shipment comprises a trip distance of the first shipment; and

the at least one monitored aspect of the second shipment comprises a trip distance of the second shipment.

5. The method of claim 1, wherein the first and second shipments originated at different locations.

6. The method of claim 1, wherein the first and second shipments originated at the same location.

7. The method of claim 1, wherein the first and second shipments arrived at different locations.

8. The method of claim 1, wherein the first and second shipments arrived at the same location.

9. The method of claim 1, wherein the at least one report comprises a control chart.

10. The method of claim 1, wherein the at least one report comprises a histogram.

11. The method of claim 1, wherein the at least one report comprises a box plot.

12. The method of claim 1, wherein:

the method further comprises steps of storing, in memory accessible to the at least one processor, an electronic copy of a first advanced shipping notification (ASN) that was transmitted from a shipping location for the first shipment to a receiving location for the first shipment in advance of sending the first shipment, and storing, in memory accessible to the at least one processor, an electronic copy of a second ASN that was transmitted from a shipping location for the second shipment to a receiving location for the second shipment in advance of sending the second shipment; and

the step (c) further comprises using at least some information from the first ASN stored in memory and at least some information from the second ASN stored in memory to automatically generate the at least one report reflecting the statistical analysis of the first data and the second data.

13. The method of claim 1, wherein:

the method further comprises steps of storing, in memory accessible to the at least one processor, first location event information concerning the first shipment, and storing, in memory accessible to the at least one processor, second location event information concerning the second shipment; and

the step (c) further comprises using at least some of the first location event information stored in memory and at least some of the second location event information stored in memory to automatically generate the at least one report reflecting the statistical analysis of the first data and the second data.

14. The method of claim 1 wherein the first and second items are transported during the first and second shipments, respectively, on different vehicles.

15. The method of claim 1, wherein:

the method further comprises a step of receiving, at the at least one processor, a request from a user for the at least one report reflecting the statistical analysis of the first data and the second data, the request including at least one user-selected parameter for the at least one report; and

the step (c) further comprises automatically generating the at least one report with the at least one processor in response to receiving the request, the at least one report being generated in accordance with the at least one user-selected parameter.

16. The method of claim 15, wherein the step (c) further comprises:

in response to receiving the request, combining first summary information extracted from the first data with second summary information extracted from the second data to yield at least one parameter for the at least one report.

17. The method of claim 16, wherein each of the first summary information and the second summary information comprises at least one of a mean temperature, a minimum temperature, a maximum temperature, degree-minutes above a threshold temperature, degree-minutes below a threshold temperature, time above a threshold temperature, and time below a threshold temperature.

18. The method of claim 16, wherein the first summary information and the second summary information reflect at least one physical or environmental condition of the at least one first item and the at least one second item, respectively, at only a single product location.

19. The method of claim 16, wherein each of the first summary information and the second summary information comprises at least one of trip time, trip distance, and time spent at a particular product location.

20. The method of claim 15, wherein the at least one user-selected parameter comprises at least one date range for data, such that the at least one report is generated using data only within the at least one date range.

21. The method of claim 15, wherein the at least one user-selected parameter comprises a list of one or more originating locations of monitored shipments, such that the at least one report is generated using data corresponding only to shipments that originated at the one or more originating locations on the list.

22. The method of claim 15, wherein the at least one user-selected parameter comprises a list of one or more receiving locations of monitored shipments, such that the at least one report is generated using data corresponding only to shipments that arrived at the one or more receiving locations on the list.

23. The method of claim 15, wherein the at least one user-selected parameter comprises a list of one or more distribution centers for monitored shipments, such that the at least one report is generated using data corresponding only to shipments that went to, from or through the one or more distribution centers on the list.

24. The method of claim 15, wherein the at least one user-selected parameter comprises a list of one or more carriers responsible for transporting monitored shipments, such that the at least one report is generated using data corresponding only to shipments that were transported by the one or more carriers on the list.

25. The method of claim 15, wherein the at least one user-selected parameter comprises at least one first criterion upon which groups of data are to be segregated in the at least one report.

26. The method of claim 25, wherein the at least one user-selected parameter further comprises at least one second criterion upon which the segregated groups of data are to be sorted in the at least one report.

27. The method of claim 25, wherein the at least one first criterion comprises at least one of a carrier responsible for transporting monitored shipments, a shipping location at which monitored shipments originated, a receiving location at which monitored shipments arrived, a distribution center, and a product type.

28. The method of claim 15, wherein the at least one user-selected parameter determines a subset of data upon which the at least one report will be based.

29. A system for performing statistical analysis on at least one monitored aspect of a product supply chain, comprising:

at least one first sensor physically associated with at least one first item to monitor changes in at least one aspect of a first shipment comprising a physical or environmental condition of the first item, the at least one first sensor being physically associated with the at least one first item such that the at least one first sensor remains physically associated with the at least one first item in the same way before and after the at least one first item is loaded onto or removed from a vehicle carrying the at least one first item during the first shipment;

at least one second sensor physically associated with at least one second item to monitor changes in at least one aspect of a second shipment comprising a physical or environmental condition of the second item, the at least one second sensor being physically associated with the at least one second item such that the at least one second sensor remains physically associated with the at least one second item in the same way before and after the at least one second item is loaded onto or removed from a vehicle carrying the at least one second item during the second shipment;

at least one memory having stored therein;

first data reflecting the at least one physical or environmental condition of the first shipment of the at least one first item occurring in the supply chain; and

second data reflecting the at least one physical or environmental condition of the second shipment of the at least one second item occurring in the supply chain; and

at least one processor, coupled to the at least one memory, configured to automatically generate at least one report reflecting a statistical analysis of the first data and the second data.

30. The system of claim 29, wherein:

the at least one monitored aspect of the first shipment comprises a temperature of an environment in which the at least one first item was disposed during the first shipment; and

the at least one monitored aspect of the second shipment comprises a temperature of an environment in which the at least one second item was disposed during the second shipment.

31. The system of claim 29, wherein:

the at least one monitored aspect of the first shipment comprises a trip time of the first shipment; and

the at least one monitored aspect of the second shipment comprises a trip time of the second shipment.

32. The system of claim 29, wherein:

the at least one monitored aspect of the first shipment comprises a trip distance of the first shipment; and

the at least one monitored aspect of the second shipment comprises a trip distance of the second shipment.

33. The system of claim 29, wherein the first and second shipments originated from different locations.

34. The system of claim 29, wherein the first and second shipments originated at the same location.

35. The system of claim 29, wherein the first and second shipments arrived at different locations.

36. The system of claim 29, wherein the first and second shipments arrived at the same location.

37. The system of claim 29, wherein the at least one report comprises a control chart.

38. The system of claim 29, wherein the at least one report comprises a histogram.

39. The system of claim 29, wherein the at least one report comprises a box plot.

40. The system of claim 29, wherein:

the at least one memory has stored therein an electronic copy of a first advanced shipping notification (ASN) that was transmitted from a shipping location for the first shipment to a receiving location for the first shipment in advance of sending the first shipment, and has further stored therein an electronic copy of a second ASN that was transmitted from a shipping location for the second shipment to a receiving location for the second shipment in advance of sending the second shipment; and

the at least one processor is further configured to use at least some information from the first ASN stored in memory and at least some information from the second ASN stored in memory to automatically generate the at least one report reflecting the statistical analysis of the first data and the second data.

41. The system of claim 29, wherein:

the at least one memory has stored therein first location event information concerning the first shipment, and has further stored therein second location event information concerning the second shipment; and

the at least one processor is further configured to use at least some of the first location event information stored in memory and at least some of the second location event information stored in memory to automatically generate the at least one report reflecting the statistical analysis of the first data and the second data.

42. The system of claim 29, wherein the first and second items are transported during the first and second shipments, respectively, on different vehicles.

43. The system of claim 29, wherein:

the system further comprises at least one user input device configured to receive at least one command from a user requesting the at least one report reflecting the statistical analysis of the first data and the second data, the at least one command including at least one user-selected parameter for the report; and

the at least one processor is further configured to automatically generate the at least one report in response to the user input device receiving the at least one command, the report being generated in accordance with the at least one user-selected parameter.

44. The system of claim 43, wherein the at least one processor is further configured to, in response to the user input device receiving the at least one command, combine first summary information extracted from the first data with second summary information extracted from the second data to yield at least one parameter for the at least one report.

45. The system of claim 44, wherein each of the first summary information and the second summary information comprises at least one of a mean temperature, a minimum temperature, a maximum temperature, degree-minutes above a threshold temperature, degree-minutes below a threshold temperature, time above a threshold temperature, and time below a threshold temperature.

46. The system of claim 44, wherein the first summary information and the second summary information reflect at least one physical or environmental condition of the at least one first item and the at least one second item, respectively, at only a single product location.

47. The method of claim 44, wherein each of the first summary information and the second summary information comprises at least one of trip time, trip distance, and time spent at a particular product location.

48. The system of claim 43, wherein the at least one user-selected parameter comprises at least one date range for data, such that the at least one report is generated using data only within the at least one date range.

49. The system of claim 43, wherein the at least one user-selected parameter comprises a list of one or more originating locations of monitored shipments, such that the at least one report is generated using data corresponding only to shipments that originated at the one or more originating locations on the list.

50. The system of claim 43, wherein the at least one user-selected parameter comprises a list of one or more receiving locations of monitored shipments, such that the at least one report is generated using data corresponding only to shipments that arrived at the one or more receiving locations on the list.

51. The system of claim 43, wherein the at least one user-selected parameter comprises a list of one or more distribution centers for monitored shipments, such that the at least one report is generated using data corresponding only to shipments that went to, from or through the one or more distribution centers on the list.

52. The system of claim 43, wherein the at least one user-selected parameter comprises a list of one or more carriers responsible for transporting monitored shipments, such that the at least one report is generated using data corresponding only to shipments that were transported by the one or more carriers on the list.

53. The system of claim 43, wherein the at least one user-selected parameter comprises at least one first criterion upon which groups of data are to be segregated in the at least one report.

54. The system of claim 53, wherein the at least one user-selected parameter further comprises at least one second criterion upon which the segregated groups of data are to be sorted in the at least one report.

55. The system of claim 53, wherein the at least one first criterion comprises at least one of a carrier responsible for transporting monitored shipments, a shipping location at which monitored shipments originated, a receiving location at which monitored shipments arrived, a distribution center to, for monitored shipments, and a product type.

56. The system of claim 43, wherein the at least one user-selected parameter determines a subset of data upon which the at least one report will be based.

57. A system for performing statistical analysis on at least one monitored aspect of a product supply chain, comprising:

first sensor means for monitoring changes in a physical or environmental condition of a first shipment of a first item, the first means being physically associated with the first item such that the first means remains physically associated with the first item in the same way before and after the first item is loaded onto or removed from a vehicle carrying the first item during the first shipment;

second means for monitoring changes in a physical or environmental condition of a second shipment of a second item, the second means being physically associated with the second item such that the second means remains physically associated with the second item in the same way before and after the second item is loaded onto or removed from a vehicle carrying the second item during the second shipment;

means for storing first data reflecting the physical or environmental condition of the first shipment of the first item occurring in the supply chain;

means for storing second data reflecting the physical or environmental condition of the second shipment of the second item occurring in the supply chain; and

means, coupled to the means for storing first data and the means for storing second data, for automatically generating at least one report reflecting a statistical analysis of the first data and the second data.