System, method and computer program product for landed cost reporting in a supply chain management framework

• US 7,120,596 B2
• Filed: 03/23/2001
• Issued: 10/10/2006
• Est. Priority Date: 03/23/2001
• Status: Active Grant

• Current Assignee: Restaurant Services Incorporated
• Original Assignee: Restaurant Services Incorporated
• Inventors: Menninger, Anthony Frank, Hoffman, George Harry, Burk, Michael James
• Primary Examiner(s): ZEENDER, FLORIAN M
• Application Number:
  US09/816,491
• Publication Number:
  US 20030069859A1
• Time in Patent Office: 2,027 Days
• Field of Search: 705/7, 705/8, 705/9, 705/10, 705/1, 705/28, 705/700, 705/80, 705/29, 705/34, 705/26
• 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/0631 Resource planning, allocation, distributing or scheduling for enterprises or organisations
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/103 Workflow collaboration or project management
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

A system, method and computer program product are disclosed for cost reporting using a network-based supply chain management framework. Data is received utilizing a network. This data relates to goods required by a plurality of stores including a product identifier parameter, and a first cost parameter. A second cost parameter associated with a franchise mark-up is also received so that a total cost can be calculated based on the first cost parameter and the second cost parameter. The total cost is displayed utilizing the network with TCP/IP protocol.

Claims

1. A method for managing an independent supply chain, comprising:

in a supply chain comprising independent suppliers, independent distributors, independent stores, and an independent supply chain manager with an independent supply chain manager computer connected together by a network, the independent supply chain manager negotiating on behalf of the independent stores and/or the independent distributors supplier master contracts with the independent suppliers, wherein each different supplier master contract is to supply at least one item to a set of the independent distributors and/or independent stores, and negotiating on behalf of the independent stores distributor master contracts with the independent distributors, wherein each of the distributor master contracts requires the distributor to receive items from at least one of the independent suppliers and to distribute the items to a set of the independent stores, wherein each of a plurality of the supplier master contracts includes a term assigning a particular set of the independent distributors to the independent supplier to which to supply the at least one item, wherein each of a plurality of the supplier master contracts sets at least one contract price for at least one item to be supplied to the particular set of independent distributors, wherein each of a plurality of the distributor master contracts includes a term assigning a particular set of the independent stores to the independent distributor to which to distribute the at least one item, and wherein the independent supply chain manager negotiates a mark-up on the at least one item to be distributed to the independent stores;

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

registering each of a plurality of the independent suppliers, the independent distributors and the independent stores as one of at least three types comprising suppliers, distributors and stores, assigning to each of the plurality a unique identifier based on their user type, and maintaining a list of registered users in the independent supply chain manager computer;

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

receiving data from the independent suppliers and/or the independent distributors utilizing the network, the data relating to the sales of the items from the independent suppliers to the independent distributors;

receiving distributor sales data from a plurality of the independent distributors and/or independent stores relating to the sales of the items from the distributors to the independent stores utilizing the network;

electronically translating the sales data of individual goods to items that are components of the goods based on a formula or recipe;

electronically determining an actual landed cost for one of the items based at least in part on the distributor sales data;

electronically determining if the actual landed cost for the one item complies with the mark-up negotiated in the master contract by the independent supply chain manager with the independent distributor;

generating an alert if there is non-compliance with the negotiated mark-up;

electronically determining if the price for one of the items supplied to one of the independent distributors matches the contract price in the supplier master contract with the independent supplier for that item;

generating an alert if there is not a match with the contract price for the item in the supplier master contract;

providing an interface on the network to allow access by a registered user on the list to different data in the supply chain electronic database depending on the user type, wherein each of a plurality of the registered users that are independent suppliers or independent distributors has access to the sales data for the stores that they supply either directly or indirectly under at least one of the supplier and distributor master contracts.

2. The method as defined in claim 1, further comprising

electronically calculating an actual cost of the individual goods to the independent stores based at least in part on the distributor sales data to an individual store and an ideal cost determined at least in part from a cost of the items used in the formula or recipe to create the goods;

and

electronically making this actual cost and ideal cost available to selected supply chain participants based on the unique identifier.

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

electronically receiving a request from a user for access to the supply chain electronic database utilizing a first web-page, wherein the request includes the unique identifier, and wherein the supply chain electronic database is updated to reflect current information on at least a weekly basis;

electronically identifying the user as a registered user and determining whether the registered user is one of the independent stores, independent distributors or independent suppliers using the unique identifier;

electronically providing a second web-page if the user is identified as one of the independent stores, a third web-page if the user is identified as one of the independent distributors, and a fourth web-page if the user is identified as one of the independent suppliers, wherein each of the second web page, the third web page, and the fourth web page will extract and display at least some different data from the supply chain electronic database based on the unique identifier that will not be made available on the other web pages.

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

allowing electronic access to the store sales data via the network to a plurality of independent equipment suppliers that sell equipment used in the production of the goods;

and

allowing each of the independent equipment suppliers to make an unsolicited offer to sell equipment to one of the independent stores based on the sales data for that independent store, wherein the offer is not made in response to an auction.

5. The method as defined in claim 4, further comprising determining a charge for access to the independent store sales data by each of the independent equipment suppliers.

6. The method as defined in claim 1, further comprising:

for a goods promotion to independent store customers, the supply chain manager computer automatically obtaining in mid-promotion store sales data from a set of the independent stores;

the supply chain manager computer using sampling to determine based on this mid-promotion store sales data predicted sales for the remainder of the promotion for a group of the independent stores that include at least one independent store that did not supply store sales data; and

generating a communication or making accessible via the network to at least one of the supply chain participants data based on the predicted sales for the group of the independent stores.

7. The method as defined in claim 6, further comprising

automatically generating an electronic order form based on the predicted sales for ordering items from one of the independent distributors or one of the independent suppliers;

and

automatically electronically communicating the electronic order form.

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

grouping data from independent stores by a store characteristic other than a region 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 supply chain participants.

9. The method as defined in claim 1, further comprising providing via the interface on the network a usage estimator for determining for one of the independent distributors or independent suppliers usage of items by the independent stores that it is assigned directly or indirectly under at least one of the supplier and distributor master contracts.

10. The method as defined in claim 9, wherein the usage indicator includes an interface to input a growth amount, and calculates usage based in part on an independent store coverage factor and this growth amount.

11. The method as defined in claim 1, further comprising

the supply chain manager computer determining an aspect of supplier performance by receiving an inventory level for an item at one of the independent suppliers that is to be provided to one of the independent distributors under one of the supplier and distributor master contracts;

and

electronically comparing the inventory level of the one independent supplier for the item to an inventory level of the item at least at one other of the independent suppliers.

12. The method as defined in claim 1, further comprising

the supply chain manager computer electronically facilitating the provision utilizing the network of an electronic catalog for the sale of items to the independent stores that includes an electronic order form, wherein the electronic catalog displays items from a plurality of sellers.

13. The method as defined in claim 1, further comprising

electronically identifying at least one item to be distributed to at least one of the independent stores;

associating a cost model with the item;

determining a time frame during which the cost model is to be valid; and

electronically performing the cost model for use to identify a supplier of the item.

14. The method as defined in claim 12, wherein a plurality of cost models are performed to identify the supplier of the item.

15. The method as defined in claim 1, comprising

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

and

the supply chain manager computer providing electronic access utilizing the network to the aggregated future sales of the grouping of the independent stores to at least one independent distributor or at least one independent supplier aligned directly or indirectly with that grouping of independent stores under at least one of the master contracts.

16. The method as defined in claim 15, wherein the forecasting aggregated future sales of a grouping step comprises the supply chain manager computer parsing the store sales data based on the set of independent stores assigned to a particular one of the independent distributors.

17. The method as defined in claim 15, wherein the forecasting aggregated future sales of a grouping step comprises the supply chain manager computer parsing the store sales data based on the set of the independent distributors assigned to a particular one of the independent suppliers.

18. The method as defined in claim 15, further comprising

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

and

electronically communicating the electronic order form.

19. The method as defined in claim 18, further comprising including in the electronic order form a request to a recipient of the electronic order form to send a confirmation of receipt to a sender of the electronic order form before providing fulfillment of the electronic order form;

and

generating an alert if the confirmation is not received by the supply chain manager computer.

20. The method as defined in claim 18, wherein the generating an electronic order form step comprises electronically associating the electronic order form with an item utilizing a web page;

and

electronically preventing the item from being associated with more than one electronic order form.

21. The method as defined in claim 3, further comprising

allowing entry of a growth value into a field in one of the web pages;

and

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

22. The method as defined in claim 1, further comprising

electronically linking each of a plurality of the supply chain participants to at least one group based on the unique identifier of the supply chain participant and a characteristic of the supply chain participant;

and

automatically providing to different groups electronic access to different data.

23. The method as defined in claim 22, wherein one of the groups comprises peers, and members in the one group of peers may access to aggregated data from their peer group.

24. The method as defined in claim 1, further comprising

electronically performing at least one least cost analysis algorithm that includes parameters of a supplier minimum capacity requirement and a supplier maximum capacity;

and

selecting at least one supplier based in part on results of the performing the least cost analysis for negotiation of one of the master supply contracts.

25. The method as defined in claim 24, wherein one of the independent suppliers is excluded from one performance of the least cost algorithm step.

26. The method as defined in claim 24, wherein freight cost is one of the parameters of the least cost algorithm;

and wherein the least cost algorithm is utilized to determine an optimal product routing.

27. The method as defined in claim 1, wherein the independent stores are electronics and appliances independent stores, the independent distributors are electronics and appliances independent distributors and the independent suppliers are electronics and appliances independent suppliers.

28. The method as defined in claim 1, wherein the independent stores are health and personal care outlets, the independent distributors are health and personal care products independent distributors and the independent suppliers are health and personal care products independent suppliers.

29. The method as defined in claim 1, wherein the independent stores are transportation equipment outlets, the independent distributors are transportation equipment independent distributors and the independent suppliers are transportation equipment independent suppliers.

30. The method as defined in claim 1, wherein the independent stores are home products outlets, the independent distributors are home products independent distributors and the independent suppliers are home products independent suppliers.

31. The method as defined in claim 1, wherein the independent stores are food and beverage outlets, the independent distributors are food and beverage independent distributors and the independent suppliers are food and beverage independent suppliers.

32. The method as defined in claim 1, wherein the independent stores are machinery outlets, the independent distributors are machinery independent distributors and the independent suppliers are machinery independent suppliers.

33. The method as defined in claim 1, wherein the independent stores are sporting goods outlets, the independent distributors are sporting goods independent distributors and the independent suppliers are sporting goods independent suppliers.

34. The method as defined in claim 1, wherein the independent stores are chemicals outlets, the independent distributors are chemicals independent distributors and the independent suppliers are chemicals independent suppliers.

35. The method as defined in claim 1, wherein the independent stores are department store outlets, the independent distributors are department store independent distributors and the independent suppliers are department store independent suppliers.

36. The method as defined in claim 1, wherein the independent stores are office products outlets, the independent distributors are office products independent distributors and the independent suppliers are office products independent suppliers.

37. The method as defined in claim 1, wherein the independent stores are gas station outlets, the independent distributors are gas station independent distributors and the independent suppliers are gas station independent suppliers.

38. The method as defined in claim 1, wherein the independent stores are convenience store outlets, the independent distributors are convenience store independent distributors and the independent suppliers are convenience store independent suppliers.

39. The method as defined in claim 1, wherein the independent stores are entertainment media outlets, the independent distributors are entertainment media independent distributors and the independent suppliers are entertainment media independent suppliers.

40. The method as defined in claim 1, wherein the independent stores are accommodation outlets, the independent distributors are accommodation independent distributors and the independent suppliers are accommodation independent suppliers.

41. A system for managing an independent supply chain, comprising independent suppliers, independent distributors, independent stores, and an independent supply chain manager with an independent supply chain manager computer connected together by a network, comprising:

a storage medium including a supply chain electronic database accessible via the network storing supplier master contracts with the independent suppliers, the supplier master contracts negotiated by the independent supply chain manager on behalf of the independent stores and/or the independent distributors, wherein each different supplier master contract is to supply at least one item to a set of the independent distributors and/or independent stores, and storing distributor master contracts with the independent distributors, the distributor master contracts negotiated by the independent supply chain manager on behalf of the independent stores, wherein each of the distributor master contracts requires the distributor to receive items from at least one of the independent suppliers and to distribute the items to a set of the independent stores, wherein each of a plurality of the supplier master contracts includes a term assigning a particular set of the independent distributors to the independent supplier to which to supply the at least one item, wherein each of a plurality of the supplier master contracts sets at least one contract price for at least one item to be supplied to the particular set of independent distributors, wherein each of a plurality of the distributor master contracts includes a term assigning a particular set of the independent stores to the independent distributor to which to distribute the at least one item, and wherein the independent supply chain manager negotiates a mark-up on the at least one item to be distributed to the independent stores;

a set of processors for implementing the independent supply chain computer that use the storage medium and include among them the following logic elements

logic for accessing a plurality of terms of the supplier and distributor master contracts in the supply chain electronic database via the network;

logic for registering each of a plurality of the independent suppliers, the independent distributors and the independent stores as one of at least three types comprising suppliers, distributors and stores, assigning to each of the plurality a unique identifier based on their user type, and maintaining a list of registered users in the independent supply chain manager computer;

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

logic for receiving data from the independent suppliers and/or the independent distributors utilizing the network, the data relating to the sales of the items from the independent suppliers to the independent distributors;

logic for receiving distributor sales data from a plurality of the independent distributors and/or independent stores relating to the sales of the items from the distributors to the independent stores utilizing the network;

logic for electronically translating the sales data of individual goods to items that are components of the goods based on a formula or recipe;

logic for electronically determining an actual landed cost for one of the items based at least in part on the distributor sales data;

logic for electronically determining if the actual landed cost for the one item complies with the mark-up negotiated in the master contract by the independent supply chain manager with the independent distributor;

logic for generating an alert if there is non-compliance with the negotiated mark-up;

logic for electronically determining if the price for one of the items supplied to one of the independent distributors matches the contract price in the supplier master contract with the independent supplier for that item;

logic for generating an alert if there is not a match with the contract price for the item in the supplier master contract;

logic for providing an interface on the network to allow access by a registered user on the list to different data in the supply chain electronic database depending on the user type, wherein each of a plurality of the registered users that are independent suppliers or independent distributors has access to the sales data for the stores that they supply either directly or indirectly under at least one of the supplier and distributor master contracts.

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

a set of computer usable media having computer readable program code embodied among them to be executed by a computer, the computer readable program code comprising

computer code for electronically accessing in a supply chain electronic database via the network stored supplier master contracts with the independent suppliers, the supplier master contracts negotiated by the independent supply chain manager on behalf of the independent stores and/or the independent distributors, wherein each different supplier master contract is to supply at least one item to a set of the independent distributors and/or independent stores, and computer code for electronically accessing in the supply chain electronic database via the network stored distributor master contracts with the independent distributors, the distributor master contracts negotiated by the supply chain manager on behalf of the independent stores, wherein each of the distributor master contracts requires the distributor to receive items from at least one of the independent suppliers and to distribute the items to a set of the independent stores, wherein each of a plurality of the supplier master contracts includes a term assigning a particular set of the independent distributors to the independent supplier to which to supply the at least one item, wherein each of a plurality of supplier master contracts sets at least one contract price for at least one item to be supplied to the particular set of independent distributors, wherein each of a plurality of the distributor master contracts includes a term assigning a particular set of the independent stores to the independent distributor to which to distribute the at least one item, and wherein the independent supply chain manager negotiates a mark-up on the at least one item to be distributed to the independent stores;

computer code for registering each of a plurality of the independent suppliers, the independent distributors and the independent stores as one of at least three types comprising suppliers, distributors and stores, assigning to each of the plurality a unique identifier based on their user type, and maintaining a list of registered users in the independent supply chain manager computer;

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

computer code for receiving data from the independent suppliers and/or the independent distributors utilizing the network, the data relating to the sales of the items from the independent suppliers to the independent distributors;

computer code for receiving distributor sales data from a plurality of the independent distributors and/or independent stores relating to the sales of the items from the distributors to the independent stores utilizing the network;

computer code for electronically translating the sales data of individual goods to items that are components of the goods based on a formula or recipe;

computer code for electronically determining an actual landed cost for one of the items based at least in part on the distributor sales data;

computer code for electronically determining if the actual landed cost for the one item complies with the mark-up negotiated in the master contract by the independent supply chain manager with the independent distributor;

computer code for generating an alert if there is non-compliance with the negotiated mark-up;

computer code for electronically determining if the price for one of the items supplied to one of the independent distributors matches the contract price in the supplier master contract with the independent supplier for that item;

computer code for generating an alert if there is not a match with the contract price for the item in the supplier master contract;

computer code for providing an interface on the network to allow access by a registered user on the list to different data in the supply chain electronic database depending on the user type, wherein each of a plurality of the registered users that are independent suppliers or independent distributors has access to the sales data for the stores that they supply either directly or indirectly under at least one of the supplier and distributor master contracts.