System and method for evaluating inventory

• US 7,950,579 B2
• Filed: 08/31/2005
• Issued: 05/31/2011
• Est. Priority Date: 01/31/2005
• Status: Active Grant

• Current Assignee: Kroger Company
• Original Assignee: Kroger Company
• Inventors: Gray, Jeffrey Scott, Shofner, James Todd
• Primary Examiner(s): Hess; Daniel A
• Assistant Examiner(s): Savusdiphol; Paultep
• Application Number:
  US11/216,883
• Publication Number:
  US 20060169775A1
• Time in Patent Office: 2,099 Days
• Field of Search: 235/375, 235/376, 235/378, 235/385
• US Class Current: 235/385
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 20/20 Point-of-sale [POS] network systems
• CPC Class Codes: G06Q 20/201 Price look-up processing, e.g. updating
• CPC Class Codes: G06Q 30/00 Commerce

Abstract

A computer assisted method for evaluating inventory is provided. The method includes receiving case composition information and case cost information for a case at a store where the case composition information identifies an item of the case and the case cost information identifies cost of the case. An item cost of the item is calculated using the case composition information and case cost information and the item cost is stored in memory. Consumer code information is received for the item and the item cost of the item is retrieved. Inventory cost data is generated using the item cost.

Claims

1. A computer assisted method for evaluating inventory, comprising:

receiving case composition information and case cost information for a cut down case at a store where the case composition information identifies a plurality of items of varying types, where a single component of the case is capable of being divided to create the plurality of items of varying types, and the case cost information identifies cost of the case;

calculating an item cost for each of the items using the case composition information and case cost information, the calculating performed by a computer system

storing the item cost for each of the items in memory of the computer system;

receiving consumer code information for a given item of the plurality of items, the consumer code also used to identify the given item during sale of the given item;

retrieving the item cost of the given item of the plurality of items; and

generating inventory cost data using the item cost, the generating performed by the computer system.

2. The method of claim 1, wherein the calculating includes calculating an average item cost for at least one item for a pre-selected time period.

3. The method of claim 2, wherein the pre-selected time period is about one week or about four weeks.

4. The method of claim 2 further including the step of storing the average item cost in a store cost database.

5. The method of claim 4, wherein the store cost database is an ordered, sequential file.

6. The method of claim 1, wherein the case composition information is received from an item information database of the computer system.

7. The method of claim 1, wherein the item is a perishable food item.

8. The method of claim 7 further comprising separating the perishable food item from the case prior to the step of receiving consumer code information for the item.

9. The method of claim 7 further comprising scanning a barcode associated with the perishable food item.

10. The method of claim 1 further comprising:

receiving consumer code information for multiple items;

calculating an item cost for the multiple items; and

generating inventory cost data using the item costs.

11. The method of claim 1, wherein the identified item is in inventory of the store.

12. The method of claim 1 further comprising receiving case code information where the case code information is a universal product code.

13. The method of claim 1, further including replacing the item cost with an override item cost.

14. The method of claim 1 further including replacing the item cost with a corrected item cost, where the corrected item cost is determined by an operator.

15. A method for evaluating inventory, comprising:

receiving a cut down case at a store, where the cut down case includes a component capable of being divided to produce a plurality of items of varying types;

receiving case code information identifying the nature of component in the cut down case and case cost information;

retrieving case composition information for the received cut down case from a database of a computer system using the case code information, where the case composition information identifies the items of varying types capable of being produced using the component of the cut down case;

calculating an item cost for each of the plurality of items, wherein the step of calculating uses the case composition information and the case cost information associated with the cut down case the step of calculating performed by the computer system;

storing the item cost for each of the plurality of the items in a cost database of the computer system;

receiving item code information for a given item of the plurality of items, the item code information also used to identify the given item during sale of the given item;

retrieving the item cost of the given item from the cost database;

associating the item cost with the given item; and

generating an inventory report using the associated item cost, the generating performed by the computer system.

16. The method of claim 15 further including the step of storing the item cost in a store cost database.

17. The method of claim 16, wherein the store cost database is an ordered, sequential file.

18. The method of claim 15, wherein the case composition information is received from an item information database of the computer system.

19. The method of claim 15, wherein the item is a perishable item.

20. A computer assisted method for evaluating inventory, comprising:

a programmed computer system carries out the steps of;

receiving case composition information and case cost information for multiple cases where the case composition information of each case identifies items of the case and the case cost information of each case identifies cost of the case;

calculating an item cost for each of the items using the case composition information and case cost information;

computing a weighted average item cost for each of the items, where at least one item type is present in both a single component case and a multiple component case, and cost for the at least one item type varies as between the single component case and the multiple component case;

storing the weighted average item costs in a store cost file and/or a division cost file;

performing an inventory analysis for a store, including;

receiving consumer code information for a plurality of items, the consumer codes also used to identify the items during sale of the items;

retrieving weighted average item cost of a multiplicity of the plurality of items from the store cost file and/or division cost file;

identifying one or more items of the plurality of items for which no weighted average item cost was available in the store cost file and/or division cost file and applying a set of default costs for such items; and

generating inventory cost data using the computer and the weighted average item costs for the plurality of items.

21. The method of claim 20 wherein the applying the set of default costs involves:

identifying whether a given item has an associated store default cost or division default cost and, if so, applying such default cost;

if no store default cost or division default cost is identified, identifying whether the given item has an associated store default margin or division default margin and, if so, calculating cost of the given item using the associated default margin.

22. The method of claim 20 wherein the programmed computer system is an enterprise mainframe computer system connected to communicate with multiple different store computers.