Back to results
US 8,078,484 B2Granted
Loss preporting system and method with viewable performance based reports
AssigneeThe Kroger Co.
InventorsWayne Mark Benson, Joshua Alan Marsh
Life of this patent
Estimating the term…
Abstract
A loss reporting system and method for tracking, monitoring and evaluating loss in an enterprise is provided. The system receives product data from enterprise facilities, stores the product data, calculates performance information from the product data, and compares the performance information to a predetermined performance standard. The system can generate a viewable report using the comparison between the performance information and the predetermined performance standard.
Claims18
A computer-based method for evaluating loss, the method comprising the steps of:
- providing a computer system including at least a server and an associated database;
- receiving at the server product data from multiple facilities of an enterprise;
- storing the product data in the database associated with the server, wherein the database stores the product data in a plurality of database tables linked by foreign key relationships, including an Item table in which an item-id is a primary key, a Store_Daily_Item-Data table in which the item_id is both a primary key and a foreign key, and a Zone_Daily_Item_Data table in which the item_id is both a primary key and a foreign key;
- the computer system performing the steps of:
- calculating performance information for each facility from the product data;
- comparing the performance information for each facility to a predetermined performance standard;
- and
- generating a viewable on-screen report using the comparison between the performance information and the predetermined performance standard, the viewable on-screen report identifying cumulative item loss for the multiple facilities and including at least one selectable link pertaining to a given facility that failed to meet the predetermined performance standard, and user selection of the selectable link provides a viewable on-screen facility level report that shows at least unit loss or dollar loss for the item at the given facility.
5 more elements
A computer-based method for evaluating loss, the method comprising the steps of:
- collecting product data of one or more items at facilities of an enterprise using a scanning device;
- sending the product data from the scanning device to a database remote from the scanning device;
- storing the product data in the database;
- providing at least one computer performing the steps of:
- calculating performance information from the stored product data;
- comparing the performance information to a predetermined enterprise performance standard for loss and markdown;
- and
- generating a viewable on-screen exception-based report using the comparison between the performance information and the predetermined performance standard, the on-screen report including at least one of a visual indicator to flag a loss performance level or text to flag a loss performance level;
- and
- wherein the viewable on-screen exception-based report can be sorted by criteria selected from at least each of multiple groups including organizational level, dollar loss, unit loss, units sold, and percent loss.
7 more elements
A computer-based system for evaluating loss comprising:
- an enterprise database having product data received from multiple enterprise facilities stored in memory, wherein the enterprise database stores the product data in a plurality of database tables linked by foreign key relationships, including an Item table in which an item-id is a primary key, a Store_Daily_Item-Data table in which the item_id is both a primary key and a foreign key, and a Zone_Daily_Item_Data table in which the item_id is both a primary key and a foreign key;
- one or more scanning devices for use in collecting the product data and transmitting the product data from the enterprise facilities to the enterprise database;
- one or more computer terminals remote from the enterprise database;
- and
- a performance calculation application that compares the product data with a predetermined performance loss standard;
- and
- a report-generating application that creates viewable reports displaying results using the comparison from the performance calculation application, whereby employees at the computer terminals can request and view reports from the report-generating application, wherein the report-generating application produces a viewable interface that permits the user to select both an item and group of facilities for which a viewable report should be generated.
4 more elements
Dependencies are inferred from the claim text.