Managing a supply chain

• US 10,515,332 B2
• Filed: 10/22/2014
• Issued: 12/24/2019
• Est. Priority Date: 10/22/2014
• Status: Active Grant

• Current Assignee: Landmark Graphics Corporation (Halliburton Company)
• Original Assignee: Landmark Graphics Corporation (Halliburton Company)
• Inventors: Bielefeldt, James Alan, Diwan, Dhirendra, Horvath, Timothy L., Vogt, John Joseph
• Primary Examiner(s): Wilder, A. Hunter
• Assistant Examiner(s): Mutschler, Joseph M
• Application Number:
  US15/510,062
• Publication Number:
  US 20170300851A1
• Time in Patent Office: 1,889 Days
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/0833 Tracking
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 30/00 Commerce
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

Logistics data includes a plurality of shipments, each including deliveries tied to a purchase order line item (POLI). Each of the deliveries has a delivery quantity and a post goods issue (PGI) date. The logistics data further includes a plurality of logistics services for the plurality of shipments including deliveries tied to the POLI. A multi-mode shipment has a plurality of sequential logistics services. The logistics data includes a plurality of deliveries tied to the POLI, wherein a goods received (GR) quantity and a GR date is determined for each of the deliveries. The processor provides a display of the PGI date and the GR date for the multi-mode shipment. The processor calculates the goods received (GR) date for a purchase order line item (POLI) based on multiple shipments tied to the POLI and multiple GRs tied to the POLI entered at a field location.

Claims

1. A method comprising:

identifying multiple deliveries tied to a purchase order line item (POLI), where each of the multiple deliveries has a delivery quantity and a post goods issue (PGI) date, each PGI date being the date goods for the respective delivery were physically moved from a warehouse or a plant, the PGI dates having an order;

identifying multiple shipments each tied to a delivery, where each of the multiple shipments has a shipment quantity;

identifying multiple goods received (GR) events for the multiple deliveries tied to the POLI, where each of the multiple GR events has a GR quantity and a GR date, and where the GR dates have an order;

identifying a required quantity for the POLI;

a processor calculating a GR_Date_1 array by;

matching the delivery quantities tied to the POLI to the GR quantities of the multiple GR events tied to the POLI,

where the matching is ambiguous because at least some of the delivery quantities tied to the POLI are equal and at least some of the GR quantities tied to the POLI are equal,

resolving the ambiguity by giving preference to aligning the order of the PGI dates to the order of GR dates,

for each delivery, saving the delivery quantity, PGI date for the delivery quantity, GR quantity, and GR date for each match in the GR_Date_1 array

the processor calculating a GR_Date_2 array by;

summing the delivery quantities of deliveries tied to the same shipment,

matching the summed delivery quantities to the GR quantities, and

for each delivery, saving the delivery quantity, PGI date for the delivery quantity, GR quantity, and GR date in the GR_Date_2 array;

the processor calculating a GR_Date_3 array by;

summing the GR quantities of a group of GR events so that the sum matches a delivery quantity of one of the multiple deliveries,

determining a maximum of the GR dates from the group of GR events and saving it as a maximum GR_date_3,

changing the GR dates of the GR events in the group to the maximum_GR_date_3, and

for each delivery, saving the delivery quantity, PGI date for the delivery quantity, summed GR quantity, and changed GR date in the GR_Date_3 array;

the processor calculating a GR_Date_4 array by;

summing the GR quantities of the multiple GR events to produce summed_GR_quantities,

determining that the summed_GR_quantities equals the required quantity for the POLI,

determining a maximum of the GR dates from the multiple GR events and saving it as maximum GR_date_4,

changing the GR dates of the multiple GR events to the maximum_GR_date_4, and

for each delivery, saving the delivery quantity, PGI date for the delivery quantity,

summed GR quantity, and changed GR date in the GR_Date_4 array;

for each shipment, determining an ATA_Date as the actual time of arrival of the shipment;

determining that the following condition is not true for at least one of the deliveries;

(GR date from GR_Date_1>

ATA_Date and GR date from GR_Date_1>

PGI_Date);

determining that the following condition is not true for at least one of the deliveries;

(GR date from GR_Date_2>

ATA_Date and GR date from GR_Date_2>

PGI_Date);

determining that the following condition is not true for at least one of the deliveries;

(GR date from GR_Date_3>

ATA_Date and GR date from GR_Date_3>

PGI_Date);

determining that the following condition is not true for at least one of the deliveries;

(GR date from GR_Date_4>

ATA_Date and GR date from GR_Date_4>

PGI_Date); and

determining, as a result, that the purchase order is still open;

analyzing using the GR_Date_1 array, the GR_Date_2 array, the GR_Date_3 array, and the GR_Date_4 array to produce an analysis of a performance of a freight forwarder involved in deliveries tied to the POLI; and

hiring the freight forwarder for additional work at least in part as a result of the analysis.

2. A method comprising:

identifying multiple deliveries tied to a purchase order line item (POLI), where each of the multiple deliveries has a delivery quantity and post goods issue (PGI) date, each PGI date being the date goods for the respective delivery were physically moved from a warehouse or a plant, the PGI dates having an order;

identifying multiple shipments each tied to a delivery, where each of the multiple shipments has a shipment quantity;

identifying multiple goods received (GR) events for the multiple deliveries tied to the POLI, where each of the multiple GR events has a GR quantity and a GR date, and where the GR dates have an order;

identifying a required quantity for the POLI;

a processor calculating a GR_Date_1 array by;

matching the delivery quantities tied to the POLI to the GR quantities of the multiple GR events tied to the POLI,

where the matching is ambiguous because at least some of the delivery quantities tied to the POLI are equal and at least some of the GR quantities tied to the POLI are equal,

resolving the ambiguity by giving preference to aligning the order of the PGI dates to the order of GR dates,

for each delivery, saving the delivery quantity, PGI date for the delivery quantity, GR quantity, and GR date for each match in the GR_Date_1 array

the processor calculating a GR_Date_2 array by;

summing the delivery quantities of deliveries tied to the same shipment,

matching the summed delivery quantities to the GR quantities, and

for each delivery, saving the delivery quantity, PGI date for the delivery quantity, GR quantity, and GR date in the GR_Date__2 array;

the processor calculating a GR_Date_3 array by;

summing the GR quantities of a group of GR events so that the sum matches a delivery quantity of one of the multiple deliveries,

determining a maximum of the GR dates from the group of GR events and saving it as a maximum GR_date_3,

changing the GR dates of the GR events in the group to the maximum_GR_date_3, and

for each delivery, saving the delivery quantity, PGI date for the delivery quantity, summed GR quantity, and changed GR date in the GR_Date_3 array;

the processor calculating a GR_Date_4 array by;

summing the GR quantities of the multiple GR events to produce summed_GR_quantities,

determining that the summed_GR_quantities equals the required quantity for the POLI,

determining a maximum of the GR dates from the multiple GR events and saving it as maximum_GR_date_4,

changing the GR dates of the multiple GR events to the maximum_GR_date_4, and

for each delivery, saving the delivery quantity, PGI date for the delivery quantity, summed GR quantity, and changed GR date in the GR_Date_4 array;

for each shipment, determining an ATA_date as the actual time of arrival of the shipment;

determining that the following GRDATE1 condition is true for at least one of the deliveries;

(GR date from GR_Date_1>

ATA_Date and GR date from GR_Date_1>

PGI_Date); and

setting the GR date for each of the at least one deliveries for which the GRDATE1 condition is true to the respective GR date for the delivery in the GR_Date_1 array;

analyzing using the GR_Date_1 array, the GR_Date_2 array, the GR_Date_3 array, and the GR_Date_4 array to produce an analysis of a performance of a freight forwarder involved in deliveries tied to the POLI; and

hiring the freight forwarder for additional work at least in part as a result of the analysis.