On-time delivery, tracking and reporting

• US 5,809,479 A
• Filed: 02/03/1997
• Issued: 09/15/1998
• Est. Priority Date: 07/21/1994
• Status: Expired due to Term

• Current Assignee: Round Rock Research LLC
• Original Assignee: Micron Technology, Inc.
• Inventors: Givens, Guy M., Kuttler, Justin D., Martin, Doreen J.
• Primary Examiner(s): Tkacs, Stephen R.
• Application Number:
  US08/794,155
• Time in Patent Office: 589 Days
• Field of Search: 705/1, 705/11, 705/22, 705/24, 705/28, 705/29, 235/375, 235/376, 235/377, 235/385
• US Class Current: 705/7.24
• CPC Class Codes: G06Q 10/06312 Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
• CPC Class Codes: G06Q 10/06314 Calendaring for a resource
• CPC Class Codes: G06Q 10/06315 Needs-based resource requirements planning or analysis
• 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/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 10/1097 Task assignment
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data

Abstract

A computer system is programmed for setting and reporting product delivery dates. The invention includes a step of maintaining a customer preferences database having delivery and reporting preferences for individual customers. The preferences include preferred early and late delivery limits, preferred performance measurement species, and desired advance delivery times. The invention further includes a step of creating a customer order entry for a particular customer. The customer order entry includes a customer-requested delivery date supplied by the customer. A customer-preferred ship date is calculated for the customer order entry based at least in part upon the costumer-requested delivery date and at least in part upon the particular customer'"'"'s specified desired advance delivery time. The customer order entry is then routed to an order scheduler. The computer system shows the order scheduler the calculated customer-preferred ship date and obtains a targeted ship date for the customer order entry from the order scheduler. The system is programmed to then calculate a targeted ship date window based upon the targeted ship date and the particular customer'"'"'s preferred early and late delivery limits. On-time product delivery statistics are generated for individual customers in accordance with the individual customers'"'"' specified preferred performance measurement species.

Claims

1. In a computer system which maintains customer order and delivery information, a method of setting and reporting product delivery dates comprising the following steps performed by the computer system:

maintaining a customer preferences database having delivery and reporting preferences for individual customers, said preferences including preferred early and late delivery limits;

specifying ship/dock flags in the delivery and reporting preferences for individual customers to indicate whether said customers consider delivery dates for particular products to be ship dates or dock dates;

specifying desired advance delivery times in the delivery and reporting preferences for individual customers;

creating a customer order entry for a particular customer, said customer order entry including a customer-requested delivery date supplied by said particular customer;

calculating a customer-preferred ship date for the customer order entry based at least in part upon the customer-requested delivery date and at least in part upon the customer preferences maintained in the customer preferences database for the particular customer;

showing the calculated customer-preferred ship date to an order scheduler;

obtaining a targeted ship date for the customer order entry from the order scheduler;

calculating a customer expected delivery date by adding data representing anticipated shipping delay to the targeted ship date, taking into consideration data from the customer preferences database indicating whether the customer defines delivery dates to be ship dates or dock dates, and by also adding the customer'"'"'s desired advance delivery time to the targeted ship date; and

generating on-time product delivery statistics for individual customers;

said step of generating the on-time product delivery statistics including a further step of determining whether a particular product delivery is on time based upon data in the customer preferences database for the particular customer associated with the particular product delivery.

2. A method of setting and reporting product delivery dates as recited in claim 1 and further comprising the following additional steps:

specifying preferred performance measurement species in the delivery and reporting preferences for individual customers;

generating the on-time product delivery statistics for individual customers in accordance with the individual customers'"'"' specified preferred performance measurement species.

3. A method of setting and reporting product delivery dates as recited in claim 1 and further comprising the following additional steps:

specifying days-in-week variables in the delivery and reporting preferences for individual customers;

determining whether the product delivery is on-time based at least in part upon the customer'"'"'s days-in-week variable.

4. A method of setting and reporting product delivery dates as recited in claim 1 and further comprising the following additional steps:

specifying partial shipment allowed flags in the delivery and reporting preferences for individual customers;

counting a partial delivery which is on time as a fraction of an on-time delivery if a customer'"'"'s partial shipment allowed flag indicates that said customer allows partial on-time shipments to be counted in on-time statistics.

5. A method of setting and reporting product delivery dates as recited in claim 1 and further comprising the following additional steps:

specifying reporting periods in the delivery and reporting preferences for individual customers;

generating the on-time product delivery statistics periodically for a particular customer based upon that customer'"'"'s specified reporting periods.

6. A method of setting and reporting product delivery dates as recited in claim 1 and further comprising the following additional steps:

obtaining actual dock dates for individual product deliveries;

wherein the step of determining whether the particular product delivery is on time is based upon that delivery'"'"'s actual dock date.

7. A method of setting and reporting product delivery dates as recited in claim 1 and further comprising the following additional steps:

obtaining actual dock dates for individual product deliveries through electronic data interchange with carriers;

wherein the step of determining whether the particular product delivery is on time is based upon that delivery'"'"'s actual dock date.

8. A method of setting and reporting product delivery dates comprising:

maintaining a customer preferences database having delivery and reporting preferences for individual customers, said preferences including preferred early and late delivery limits, preferred performance measurement species, desired advance delivery times, and data indicating whether the customer defines delivery dates to be ship dates or dock dates;

creating a customer order entry for a particular customer, said customer order entry including a customer-requested delivery date supplied by said particular customer;

calculating a customer-preferred ship date for the customer order entry based at least in part upon the customer-requested delivery date and at least in part upon the particular customer'"'"'s specified desired advance delivery time;

routing the customer order entry to an order scheduler;

showing the order scheduler the calculated customer-preferred ship date;

obtaining a targeted ship date for the customer order entry from the order scheduler;

calculating a targeted ship date window based upon the targeted ship date and the particular customer'"'"'s preferred early and late delivery limits;

calculating a customer expected delivery date by adding data representing anticipated shipping delay to the targeted ship date, taking into consideration data from the customer preferences database indicating whether the customer defines delivery dates to be ship dates or dock dates, and by also adding the customer'"'"'s desired advance delivery time to the targeted ship date;

generating on-time product delivery statistics for individual customers in accordance with the individual customers'"'"' specified preferred performance measurement species;

said step of generating the on-time product delivery statistics including a further step of determining whether a particular product delivery is on time based upon the individual customers'"'"' preferred early and late delivery limits.

9. A method of setting and reporting product delivery dates as recited in claim 8 and further comprising the following additional steps:

specifying days-in-week variables in the delivery and reporting preferences for individual customers;

determining whether the product delivery is on-time based at least in part upon the customer'"'"'s days-in-week variable.

10. A method of setting and reporting product delivery dates as recited in claim 8 and further comprising the following additional steps:

specifying partial shipment allowed flags in the delivery and reporting preferences for individual customers;

counting a partial delivery which is on time as a fraction of an on-time delivery if a customer'"'"'s partial shipment allowed flag indicates that said customer allows partial on-time shipments to be counted in on-time statistics.

11. A method of setting and reporting product delivery dates as recited in claim 8 and further comprising the following additional steps:

specifying reporting periods in the delivery and reporting preferences for individual customers;

generating the on-time product delivery statistics periodically for a particular customer based upon that customer'"'"'s specified reporting periods.

12. A method of setting and reporting product delivery dates as recited in claim 8 and further comprising the following additional steps:

obtaining actual dock dates for individual product deliveries;

wherein the step of determining whether the particular product delivery is on time is based upon that delivery'"'"'s actual dock date.

13. A method of setting and reporting product delivery dates as recited in claim 8 and further comprising the following additional steps:

obtaining actual dock dates for individual product deliveries through electronic data interchange with carriers;

wherein the step of determining whether the particular product delivery is on time is based upon that delivery'"'"'s actual dock date.

14. An on-time delivery tracking and reporting system comprising:

a customer preferences database having delivery and reporting preferences for individual customers, said preferences including preferred early and late delivery limits, desired advance delivery times, and data for individual customers to indicate whether the customers consider delivery dates for particular products to be ship dates or dock dates;

a data processor connected to access the customer preferences data base and being programmed to;

create a customer order entry for a particular customer, said customer order entry including a customer-requested delivery date supplied by said particular customer;

calculate a customer-preferred ship date for the customer order entry based at least in part upon the customer-requested delivery date and at least in part upon the customer preferences maintained in the customer preferences database for the particular customer;

show the calculated customer-preferred ship date to an order scheduler;

obtain a targeted ship date for the customer order entry from the order scheduler;

calculate a customer expected delivery date by adding data representing anticipated shipping delay to the targeted ship date, taking into consideration data from the customer preferences database indicating whether the customer defines delivery dates to be ship dates or dock dates, and by also adding the customer'"'"'s desired advance delivery time to the targeted ship date; and

generate on-time product delivery statistics for individual customers;

said data processor being further programmed to determine whether a particular product delivery is on time, for purposes of generating the on-time product delivery statistics, based upon the particular customer'"'"'s preferred early and late delivery limits.

15. An on-time delivery tracking and reporting system as recited in claim 14 wherein:

the customer preferences database includes preferred performance measurement species in its delivery and reporting preferences for individual customers;

the data processor is programmed to generate the on-time product delivery statistics for individual customers in accordance with the individual customers'"'"' specified preferred performance measurement species.

16. An on-time delivery tracking and reporting system as recited in claim 14 wherein:

the customer preferences database includes days-in-week variables in the delivery and reporting preferences for individual customers;

the data processor is programmed to determine whether the product delivery is on-time based at least in part upon the customer'"'"'s days-in-week variable.

17. An on-time delivery tracking and reporting system as recited in claim 14 wherein:

the customer preferences database includes partial shipment allowed flags in the delivery and reporting preferences for individual customers;

the data processor is programmed to count a partial delivery which is on time as a fraction of an on-time delivery if a customer'"'"'s partial shipment allowed flag indicates that said customer allows partial on-time shipments to be counted in on-time statistics.

18. An on-time delivery tracking and reporting system as recited in claim 14 wherein:

the customer preferences database includes reporting periods in the delivery and reporting preferences for individual customers;

the data processor is programmed to generate the on-time product delivery statistics periodically for a particular customer based upon that customer'"'"'s specified reporting periods.

19. An on-time delivery tracking and reporting system as recited in claim 14 wherein:

the customer preferences database includes desired advance delivery times in the delivery and reporting preferences for individual customers;

the data processor is programmed to calculate the customer-preferred ship date based at least in part upon the particular customer'"'"'s specified desired advance delivery time.

20. An on-time delivery tracking and reporting system as recited in claim 14 wherein:

the customer preferences database includes actual dock dates for individual product deliveries;

the data processor is programmed to determine whether the particular product delivery is on time based upon that delivery'"'"'s actual dock date.

21. An on-time delivery tracking and reporting system as recited in claim 14 wherein:

the customer order entry includes actual dock dates for individual product deliveries, obtained through electronic data interchange with carriers;

the data processor is programmed to determine whether the particular product delivery is on time is based upon that delivery'"'"'s actual dock date.

22. An on-time delivery tracking and reporting system comprising:

a customer preferences database having delivery and reporting preferences for individual customers, said preferences including preferred early and late delivery limits, preferred performance measurement species, and desired advance delivery times;

a data processor connected to access the customer preferences database and being programmed to;

create a customer order entry for a particular customer, said customer order entry including a customer-requested delivery date supplied by said particular customer;

calculate a customer-preferred ship date for the customer order entry based at least in part upon the customer-requested delivery date and at least in part upon the particular customer'"'"'s specified desired advance delivery time from the customer preferences database;

route the customer order entry to a human order scheduler;

show the order scheduler the calculated customer-preferred ship date;

obtain a targeted ship date for the customer order entry from the order scheduler;

calculate a targeted ship date window based upon the targeted ship date and the particular customer'"'"'s preferred early and late delivery limits;

generate on-time product delivery statistics for individual customers in accordance with the individual customers'"'"' specified preferred performance measurement species;

said data processor being further programmed to determine whether a particular product delivery is on time, for purposes of generating the on-time product delivery statistics, based upon its targeted ship date window.

23. An on-time delivery tracking and reporting system as recited in claim 22 wherein:

the customer preferences data base includes ship/dock flags in the delivery and reporting preferences for individual customers to indicate whether said customers consider delivery dates for particular products to be ship dates or dock dates;

the data processor is programmed to pre-date the customer-preferred ship date if the particular customer'"'"'s ship/dock flag indicates that the particular customer considers a delivery date to be a dock date.

24. An on-time delivery tracking and reporting system as recited in claim 22 wherein:

the customer preferences data base includes days-in-week variables in the delivery and reporting preferences for individual customers;

the data processor is programmed to determine whether the product delivery is on-time based at least in part upon the customer'"'"'s days-in-week variable.

25. An on-time delivery tracking and reporting system as recited in claim 22 wherein:

the customer preferences data base includes partial shipment allowed flags in the delivery and reporting preferences for individual customers;

the data processor is programmed to count a partial delivery which is on time as a fraction of an on-time delivery if a customer'"'"'s partial shipment allowed flag indicates that said customer allows partial on-time shipments to be counted in on-time statistics.

26. An on-time delivery tracking and reporting system as recited in claim 22 wherein:

the customer preferences data base includes reporting periods in the delivery and reporting preferences for individual customers;

the data processor is programmed to generate the on-time product delivery statistics periodically for a particular customer based upon that customer'"'"'s specified reporting periods.

27. An on-time delivery tracking and reporting system as recited in claim 22 wherein:

the customer preferences data base includes actual dock dates for individual product deliveries;

the data processor is programmed to determine whether the particular product delivery is on time is based upon that delivery'"'"'s actual dock date.

28. An on-time delivery tracking and reporting system as recited in claim 22 wherein:

the customer order entry includes actual dock dates for individual product deliveries, obtained through electronic data interchange with carriers;

the data processor is programmed to determine whether the particular product delivery is on time is based upon that delivery'"'"'s actual dock date.

29. A method of setting and reporting product delivery dates comprising:

determining and storing in a database of customer preferences data representing a customer'"'"'s early and late delivery limits for deliveries;

determining and storing in the customer preferences database whether the customer defines delivery date as shipped date or received date for deliveries;

determining and storing in the customer preferences database whether the customer includes weekends and holidays in evaluating whether a delivery is on-time;

determining and storing how performance is measured by the customer, whether by dollars, by units, by line items, by shipments;

determining and storing in the customer preferences database the customer'"'"'s desired advance delivery time;

determining and storing in the customer preferences database whether the customer considers a partial shipment in determining on-time delivery;

determining and storing the customer'"'"'s preferred reporting period;

periodically prompting a user to update the preferences;

receiving an order from the customer for a particular delivery, and receiving a requested delivery date;

accessing the customer preferences database and calculating the customer'"'"'s preferred ship date as being the customer'"'"'s requested delivery date minus the customer'"'"'s desired advance delivery;

sending the customer'"'"'s preferred ship date to a human order scheduler;

receiving a targeted ship date from the human order scheduler;

calculating a customer expected delivery date by adding data representing anticipated shipping delay to the targeted ship date, taking into consideration data from the customer preferences database indicating whether the customer defines delivery dates to be ship dates or dock dates, and by also adding the customer'"'"'s desired advance delivery time to the targeted ship date;

receiving the actual delivery date for the particular delivery;

generating delivery statistics according to the customer'"'"'s reporting period, taking into consideration data from the customer preferences database including how performance is measured by the customer, whether by dollars, by units, by line items, by shipments, including whether the customer defines delivery dates to be ship dates or dock dates, and including whether the customer includes weekends and holidays in evaluating whether a delivery is on-time; and

recording reasons for deliveries which were not on time.

30. A method of setting and reporting product delivery dates comprising the following steps:

maintaining a customer preferences database having delivery and reporting preferences for individual customers, said preferences including preferred early and late delivery limits, preferred performance measurement species, and desired advance delivery times;

specifying reporting periods in the delivery and reporting preferences for individual customers;

creating a customer order entry for a particular customer, said customer order entry including a customer-requested delivery date supplied by said particular customer;

calculating a customer-preferred ship date for the customer order entry based at least in part upon the customer-requested delivery date and at least in part upon the particular customer'"'"'s specified desired advance delivery time;

routing the customer order entry to an order scheduler;

showing the order scheduler the calculated customer-preferred ship date;

obtaining a targeted ship date for the customer order entry from the order scheduler;

specifying ship/dock flags in the delivery and reporting preferences for individual customers to indicate whether said customers consider delivery dates for particular products to be ship dates or dock dates;

calculating a customer expected delivery date by adding data representing anticipated shipping delay to the targeted ship date, taking into consideration whether the particular customer considers a delivery date to be a ship date or dock date, and by also adding the customer'"'"'s desired advance delivery time to the targeted ship date;

specifying days-in-week variables in the delivery and reporting preferences for individual customers;

specifying partial shipment allowed flags in the delivery and reporting preferences for individual customers;

obtaining actual dock dates for individual product deliveries;

generating on-time product delivery statistics for individual customers in accordance with the individual customers'"'"' specified preferred performance measurement species and based upon that customer'"'"'s specified reporting periods;

said step of generating the on-time product delivery statistics including a further step of determining whether a particular product delivery is on time based upon the individual customers'"'"' preferred early and late delivery limits, upon the customer'"'"'s days-in-week variable counting a partial delivery which is on time as a fraction of an on-time delivery if a customer'"'"'s partial shipment allowed flag indicates that said customer allows partial on-time shipments to be counted in on-time statistics, and based upon that delivery'"'"'s actual dock date.