Automated generation of reports reflecting statistical analyses of supply chain processes

• US 20050055287A1
• Filed: 09/03/2004
• Published: 03/10/2005
• 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
• Granted Patent: US 7,693,739 B2
• Time in Patent Office: Days
• US Class Current: 705/28
• 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

A product supply chain may be viewed not just as a series of discrete, unrelated shipment transactions, but as a “process” (or pipeline) that can be subject to statistical process control. The present invention is directed to novel systems and methods for collecting data concerning one or more aspects of a supply chain, for performing statistical analysis on the collected data to facilitate the identification of anomalies or inefficiencies in the process, and for communicating the results of such statistical analysis to those responsible for the supply chain so that remedial measures may be taken, if appropriate. Among other things, a method for performing statistical analysis on at least one monitored aspect of a product supply chain is disclosed that involves storing, in memory accessible to at least one processor, first data reflecting at least one first determined value of at least one monitored aspect of a first shipment of at least one first item occurring in the supply chain, and storing, in memory accessible to the at least one processor, second data reflecting at least one second determined value of at least one monitored aspect of a second shipment of at least one second item occurring in the supply chain. The at least one processor is used to automatically generate at least one report reflecting a statistical analysis of the first data and the second data.

Claims

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

(a) storing, in memory accessible to at least one processor, first data reflecting at least one first determined value of at least one monitored aspect of a first shipment of at least one first item occurring in the supply chain;

(b) storing, in memory accessible to the at least one processor, second data reflecting at least one second determined value of at least one monitored aspect of a second shipment of at least one second item occurring in the supply chain; and

(c) 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 at least one physical or environmental condition of the at least one first item during the first shipment; and

the at least one monitored aspect of the second shipment comprises at least one physical or environmental condition of the at least one second item during the second shipment.

3. The method of claim 2, further comprising steps of:

physically associating at least one first sensor with the at least one first item to monitor changes in the at least one physical or environmental condition thereof, 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 substantially 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; and

physically associating at least one second sensor with the at least one second item to monitor changes in the at least one physical or environmental condition thereof, 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 substantially 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 first shipment.

4. 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.

5. 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.

6. 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.

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

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

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

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

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

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

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

14. 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.

15. 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.

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

17. 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.

18. The method of claim 17, 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.

19. The method of claim 18, 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.

20. The method of claim 18, 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.

21. The method of claim 18, 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.

22. The method of claim 17, 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.

23. The method of claim 17, 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.

24. The method of claim 17, 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.

25. The method of claim 17, 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.

26. The method of claim 17, 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.

27. The method of claim 17, 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.

28. The method of claim 27, 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.

29. The method of claim 27, 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.

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

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

at least one memory having stored therein first data reflecting at least one first determined value of at least one monitored aspect of a first shipment of at least one first item occurring in the supply chain, and having further stored therein second data reflecting at least one second determined value of at least one monitored aspect of a second shipment of 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.

32. The system of claim 31, wherein:

the at least one monitored aspect of the first shipment comprises at least one physical or environmental condition of the at least one first item during the first shipment; and

the at least one monitored aspect of the second shipment comprises at least one physical or environmental condition of the at least one second item during the second shipment.

33. The system of claim 32, further comprising:

at least one first sensor physically associated with the at least one first item to monitor changes in the at least one physical or environmental condition thereof, 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 substantially 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; and

at least one second sensor physically associated with the at least one second item to monitor changes in the at least one physical or environmental condition thereof, 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 substantially 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.

34. The system of claim 31, 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.

35. The system of claim 31, 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.

36. The system of claim 31, 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.

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

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

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

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

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

42. The system of claim 31, wherein the at least one report comprises a histogram.

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

44. The system of claim 31, 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.

45. The system of claim 31, 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.

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

47. The system of claim 31, 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.

48. The system of claim 47, 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.

49. The system of claim 48, 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.

50. The system of claim 48, 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.

51. The method of claim 48, 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.

52. The system of claim 47, 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.

53. The system of claim 47, 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.

54. The system of claim 47, 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.

55. The system of claim 47, 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.

56. The system of claim 47, 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.

57. The system of claim 47, 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.

58. The system of claim 57, 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.

59. The system of claim 57, 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.

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

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

means for storing first data reflecting at least one first determined value of at least one monitored aspect of a first shipment of at least one first item occurring in the supply chain;

means for storing second data reflecting at least one second determined value of at least one monitored aspect of a second shipment of at least one 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.

62. A computer-readable medium for use with at least one processor included in a system including at least one memory having stored therein first data reflecting at least one first determined value of at least one monitored aspect of a first shipment of at least one first item occurring in a supply chain, and having further stored therein second data reflecting at least one second determined value of at least one monitored aspect of a second shipment of at least one second item occurring in the supply chain, the computer-readable medium having a plurality of instructions stored thereon which, when executed by the at least one processor, cause the at least one processor to perform a step of:

automatically generating at least one report reflecting a statistical analysis of the first data and the second data.

63. The computer-readable medium of claim 62, wherein:

the at least one monitored aspect of the first shipment comprises at least one physical or environmental condition of the at least one first item during the first shipment; and

the at least one monitored aspect of the second shipment comprises at least one physical or environmental condition of the at least one second item during the second shipment.

64. The computer-readable medium of claim 62, 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.

65. The computer-readable medium of claim 62, 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.

66. The computer-readable medium of claim 62, 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.

67. The computer-readable medium of claim 62, wherein the at least one report comprises a control chart.

68. The computer-readable medium of claim 62, wherein the at least one report comprises a histogram.

69. The computer-readable medium of claim 62, wherein the at least one report comprises a box plot.

70. The computer-readable medium of claim 62, 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 step of automatically generating the at least one report 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.

71. The computer-readable medium of claim 62, wherein:

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

the step of automatically generating the at least one report 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.

72. The computer-readable medium of claim 62, having additional instructions stored thereon which, when executed by the processor, cause the processor to automatically generate the at least one report in response to receiving a request from a user including at least one user-selected parameter for the at least one report, the at least one report being generated in accordance with the at least one user-selected parameter.

73. The computer-readable medium of claim 72, having additional instructions stored thereon which, when executed by the processor, cause the processor to 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.

74. The computer-readable medium of claim 73, 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.

75. The computer-readable medium of claim 73, 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.

76. The computer-readable medium of claim 73, 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 single product location.

77. The computer-readable medium of claim 72, 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.

78. The computer-readable medium of claim 72, 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.

79. The computer-readable medium of claim 72, 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.

80. The computer-readable medium of claim 72, 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.

81. The computer-readable medium of claim 72, 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.

82. The computer-readable medium of claim 72, 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.

83. The computer-readable medium of claim 82, 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.

84. The computer-readable medium of claim 82, 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 for monitored shipments, and a product type.

85. The computer-readable medium of claim 72, wherein the at least one user-selected parameter determines a subset of data upon which the at least one report will be based.