System, method and computer program product for normalizing data in a supply chain management framework

• US 7,171,379 B2
• Filed: 03/23/2001
• Issued: 01/30/2007
• Est. Priority Date: 03/23/2001
• Status: Active Grant

• Current Assignee: Restaurant Services Incorporated
• Original Assignee: Restaurant Services Incorporated
• Inventors: Menninger, Anthony Frank, Rueff, Mark Patrick, Sechrist, Daniel
• Primary Examiner(s): GORT, ELAINE L
• Application Number:
  US09/816,454
• Publication Number:
  US 20030046121A1
• Time in Patent Office: 2,139 Days
• Field of Search: 705/22, 705/24, 705/7, 705/28, 705/15, 705/10, 705/8
• US Class Current: 705/28
• 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/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 50/12 Hotels or restaurants

Abstract

A system, method and computer program product are disclosed for normalizing data in a supply chain management framework. A plurality of data types are defined with each data type including parameters. Data is received utilizing a network from a plurality of point of sale outlets of a supply chain that relates to an amount of goods sold by the point of sale outlets. A format of the data is verified against the parameters of the defined data types and any discrepancies between the format of the data and the parameters of the defined data types are corrected for facilitating an analysis of the data.

Claims

1. A system for managing an independent supply chain comprising at least independent suppliers and independent stores and an independent supply chain manager connected together by a network, comprising:

a memory connected to the network and storing supplier master contracts with the independent suppliers negotiated by the independent supply chain manager on behalf of the independent stores and/or independent distributors, wherein each of a plurality of the supplier master contracts includes a term assigning directly or indirectly a different first set of the independent stores to the independent supplier to which to supply directly or indirectly at least one item;

an independent supply chain manager computer system connected to the network and operatively connected to the memory and comprising one or more processors and including the following components

a component for storing a plurality of terms of the supplier master contracts in a supply chain electronic database accessible via the network;

a component for defining a plurality of data types for store sales data, each of the data types including a set of parameters;

a component for receiving store sales data from a plurality of the independent stores utilizing the network, the store sales data comprising sales of goods by the independent stores, wherein the sales of the goods are made manually;

a component for verifying a format of the store sales data against the parameters of the defined data types;

a component for automatically correcting discrepancies between the format of the data and the parameters of the defined data types by translating the format of the store sales data in accordance with the parameters of the defined data types;

a component for providing an electronic communication of or providing electronic access for one of the respective independent stores to an indication that changes have been made to the independent store sales data for the respective independent store;

a component for the independent supply chain manager computer receiving data from the independent suppliers and/or independent stores and/or distributors utilizing the network, the data relating to the supply of the at least one item from the independent suppliers directly or indirectly to the independent stores;

a component for automatically comparing at least one contract term in one of the supplier master contracts for the at least one item to received data relating to the supply of the at least one item; and

a component for sending a communication to at least one of the independent stores or to one of the independent suppliers if there is a discrepancy between the at least one contract term and the received data.

2. The system as defined in claim 1, further comprising:

a component for the independent supply chain manager computer automatically obtaining store sales data from a second set of the independent stores, wherein the second set of independent stores is determined, in part, by the supplier master contract associated directly or indirectly with the second set of independent stores;

a component for registering at least each of a plurality of the independent suppliers, and the independent stores as one of at least two types comprising suppliers and stores, and maintaining a list of registered users accessible by the independent supply chain manager computer;

wherein the store sales data is obtained in mid-promotion from the second set of the independent stores associated with one of the supplier master contracts, wherein the second set of independent stores is less than the first set of the independent stores associated with the supplier master contract;

a component in the supply chain manager computer using sampling to determine based on this mid-promotion store sales data from the second set of the independent stores predicted sales for the remainder of the promotion for the first set of the independent stores assigned by the supplier master contract to the one of the independent suppliers; and

a component for generating a communication or making accessible via the network to at least one of the registered users data based on the predicted sales for the first set of the independent stores.

3. The system as defined in claim 1, further comprising:

a component for the independent supply chain manager computer automatically obtaining store sales data from a second set of the independent stores, wherein the second set of independent stores is determined, in part, by the supplier master contract associated directly or indirectly with the second set of independent stores;

registering each of a plurality of the independent suppliers, and the independent stores as one of at least two types comprising suppliers and stores, and maintaining a list of registered users accessible by the independent supply chain manager computer;

wherein the store sales data from the second set of the independent stores associated with one of the supplier master contracts is less than the first set of the independent stores associated with the supplier master contract;

a component in the supply chain manager computer using sampling to determine based on the store sales data from the second set of the independent stores associated with one of the supplier master contracts predicted sales for the first set of the independent stores assigned by the supplier master contract to one of the independent suppliers; and

a component for generating a communication or making accessible via the network to at least one of the registered users data based on the predicted sales for the first set of the independent stores.

4. The system as defined in claim 1, further comprising

a component in the supply chain manager computer forecasting aggregated future sales of a one of the different first sets of independent stores utilizing the store sales data for selected ones of the independent stores;

and

a component in the supply chain manager computer generating a communication or providing electronic access utilizing the network to the forecast of aggregated future sales of the first set of the independent stores to the independent supplier for that first set.

5. The system as defined in claim 4, further comprising a component in the supply chain manager computer converting the store sales data for the sales of goods into items supplied by the independent supplier and aggregating the items supplied based on the first set of independent stores assigned directly or indirectly to one of the independent suppliers.

6. The system as defined in claim 4, further comprising

a component for automatically generating an electronic order form based on the forecast of aggregated future sales for ordering items from one of the independent suppliers;

and

a component for automatically electronically communicating the electronic order form.

7. The system as defined in claim 1, further comprising

a component for allowing entry of a growth value into a field in a web page associated with the independent supply chain manager;

and

a component for electronically calculating a projected parameter associated with one of the supply chain participants based at least in part on the growth value.

8. The system as defined in claim 1, further comprising

a component for registering at least each of a plurality of the independent suppliers, and the independent stores as one of at least two types comprising suppliers and stores, and maintaining a list of registered users accessible by the independent supply chain manager computer;

wherein the group comprises independent stores grouped by a store characteristic other than a region or direct or indirect assignment by master supplier contract and determining benchmark data for independent stores with that characteristic;

a component for electronically comparing the benchmark data to the data for one of the independent stores having that characteristic to obtain comparison data; and

a component for generating a communication or providing electronic access via the network to the comparison data to one of the registered users.

9. The system as defined in claim 1, further comprising a component for determining a charge for access to the independent store sales data to one of the independent suppliers based on a number of accesses to the supply chain electronic database by the independent supplier.

10. The system as defined in claim 1, further comprising a component for determining a charge for electronic advertising on the network.

11. The system defined in claim 1, further comprising:

a component for electronically associating each of a plurality of the independent stores to at least one group based on a characteristic of the independent store, wherein the group comprises less than all of the independent stores; and

a component for providing an interface accessible on the network to allow access by each of the plurality of the independent stores to data relating to at least one supplier master contract associated directly or indirectly with that independent store and to data relating to independent stores in the group.

12. The system as defined in claim 1, wherein the component for providing an electronic communication of or providing electronic access for one of the respective independent stores to an indication that changes have been made to the independent store sales data for the respective independent store comprises a component for automatically logging the discrepancies in an electronic log and providing electronic access to the electronic log or providing an electronic communication that includes information from the electronic log.

13. A program product for managing an independent supply chain comprising at least independent suppliers and independent stores and an independent supply chain manager with an independent supply chain manager computer connected together by a network, comprising:

a computer useable medium having computer-readable program code embodied thereon which, when executed by a computer, causes the computer to perform the following method

storing a plurality of terms of supplier master contracts with independent suppliers in a supply chain electronic database accessible via the network, wherein the terms of the master supplier contracts were negotiated by the independent supply chain manager on behalf of the independent stores and/or independent distributors, wherein each of a plurality of the supplier master contracts includes a term assigning directly or indirectly a different first set of the independent stores to the independent supplier to which to supply directly or indirectly at least one item;

defining a plurality of data types for store sales data, each of the data types including a set of parameters;

receiving store sales data from a plurality of the independent stores utilizing the network, the store sales data comprising sales of goods by the independent stores, wherein the sales of the goods are made manually;

verifying a format of the store sales data against the parameters of the defined data types;

automatically correcting discrepancies between the format of the data and the parameters of the defined data types by translating the format of the store sales data in accordance with the parameters of the defined data types;

providing an electronic communication of or providing electronic access for one of the respective independent stores to an indication that changes have been made to the independent store sales data for the respective independent store data;

the independent supply chain manager computer receiving data from the independent suppliers and/or independent stores and/or distributors utilizing the network, the data relating to the supply of the at least one item from the independent suppliers directly or indirectly to the independent stores;

automatically comparing at least one contract term in one of the supplier master contracts for the at least one item to received data relating to the supply of the at least one item; and

sending a communication to at least one of the independent stores or to one of the independent suppliers if there is a discrepancy between the at least one contract term and the received data.

14. The program product as defined in claim 13, further comprising program code for:

the independent supply chain manager computer automatically obtaining store sales data from a second set of the independent stores, wherein the second set of independent stores is determined, in part, by the supplier master contract associated directly or indirectly with the second set of independent stores;

registering each of a plurality of the independent suppliers, and the independent stores as one of at least two types comprising suppliers and stores, and maintaining a list of registered users accessible by the independent supply chain manager computer;

wherein the store sales data is obtained in mid-promotion from the second set of the independent stores associated with one of the supplier master contracts,

wherein the second set of independent stores is less than the first set of the independent stores associated with the supplier master contract;

the supply chain manager computer using sampling to determine based on this mid-promotion store sales data from the second set of the independent stores predicted sales for the remainder of the promotion for the first set of the independent stores assigned by the supplier master contract to the one of the independent suppliers; and

generating a communication or making accessible via the network to at least one of the registered users data based on the predicted sales for the first set of the independent stores.

15. The program product as defined in claim 13, further comprising program code for:

the independent supply chain manager computer automatically obtaining store sales data from a second set of the independent stores, wherein the second set of independent stores is determined, in part, by the supplier master contract associated directly or indirectly with the second set of independent stores;

registering each of a plurality of the independent suppliers, and the independent stores as one of at least two types comprising suppliers and stores, and maintaining a list of registered users accessible by the independent supply chain manager computer;

wherein the store sales data from the second set of the independent stores associated with one of the supplier master contracts is less than the first set of the independent stores associated with the supplier master contract;

the supply chain manager computer using sampling to determine based on the store sales data from the second set of the independent stores associated with one of the supplier master contracts predicted sales for the first set of the independent stores assigned by the supplier master contract to one of the independent suppliers; and

generating a communication or making accessible via the network to at least one of the registered users data based on the predicted sales for the first set of the independent stores.

16. The program product as defined in claim 13, further comprising

the supply chain manager computer forecasting aggregated future sales of a one of the different first sets of independent stores utilizing the store sales data for selected ones of the independent stores;

and

the supply chain manager computer generating a communication or providing electronic access utilizing the network to the forecast of aggregated future sales of the first set of the independent stores to the independent supplier for that first set.

17. The program product as defined in claim 16, further comprising the supply chain manager computer converting the store sales data for the sales of goods into items supplied by the independent supplier and aggregating the items supplied based on the first set of independent stores assigned directly or indirectly to one of the independent suppliers.

18. The program product as defined in claim 16, further comprising

automatically generating an electronic order form based on the forecast of aggregated future sales for ordering items from one of the independent suppliers;

and

automatically electronically communicating the electronic order form.

19. The program product as defined in claim 13, further comprising

allowing entry of a growth value into a field in a web page associated with the independent supply chain manager;

and

electronically calculating a projected parameter associated with one of the supply chain participants based at least in part on the growth value.

20. The program product as defined in claim 13, further comprising program code for

registering at least each of a plurality of the independent suppliers, and the independent stores as one of at least two types comprising suppliers and stores, and maintaining a list of registered users accessible by the independent supply chain manager computer;

wherein the group comprises independent stores grouped by a store characteristic other than a region or direct or indirect assignment by master supplier contract and determining benchmark data for independent stores with that characteristic;

electronically comparing the benchmark data to the data for one of the independent stores having that characteristic to obtain comparison data; and

generating a communication or providing electronic access via the network to the comparison data to one of the registered users.

21. The program product as defined in claim 13, further comprising determining a charge for access to the independent store sales data to one of the independent suppliers based on a number of accesses to the supply chain electronic database by the independent supplier.

22. The program product as defined in claim 13, further comprising determining a charge for electronic advertising on the network.

23. The program product as defined in claim 13, further comprising code for performing the following:

electronically associating each of a plurality of the independent stores to at least one group based on a characteristic of the independent store, wherein the group comprises less than all of the independent stores; and

providing an interface accessible on the network to allow access by each of the plurality of the independent stores to data relating to at least one supplier master contract associated directly or indirectly with that independent store and to data relating to independent stores in the group.

24. The program product as defined in claim 13, wherein the program code for providing an electronic communication of or providing electronic access for one of the respective independent stores to an indication that changes have been made to the independent store sales data for the respective independent store comprises program code for automatically logging the discrepancies in an electronic log and providing electronic access to the electronic log or providing an electronic communication that includes information from the electronic log.