System and method for detecting merchandise sliding and under ringing at cash register

• US 6,006,198 A
• Filed: 02/20/1998
• Issued: 12/21/1999
• Est. Priority Date: 02/20/1998
• Status: Expired due to Fees

• Current Assignee: Ross G. Newland Jr
• Original Assignee: Ross G. Newland Jr
• Inventors: Newland, Ross G. Jr.
• Primary Examiner(s): Trammell, James P.
• Assistant Examiner(s): Nguyen, Cuong H.
• Application Number:
  US09/027,392
• Time in Patent Office: 669 Days
• Field of Search: 235/7 R, 705/21-22, 705/28-29, 186/59, 186/61
• US Class Current: 705/21
• 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 20/202 Interconnection or interaction of plural electronic cash registers [ECR] or to host computer, e.g. network details, transfer of information from host to ECR or from ECR to ECR
• CPC Class Codes: G06Q 20/203 Inventory monitoring
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G07G 1/0054 with control of supplementary check-parameters, e.g. weight or number of articles
• CPC Class Codes: G07G 3/003 Anti-theft control theft alarms G08B13/00

Abstract

A system and method for detecting the under ringing and/or sliding of merchandise by a cashier in a retail establishment is disclosed including the use of a system employing many cash registers and cashiers. The cash register system compiles raw cash register data which includes total items sold and dollar sales of the items sold by each cashier on each day a cashier works. A cash register database stores the cash register data in a medium for processing on a central computer. A computer program including instruction for averaging data is embodied in computer-readable forms to determine a daily average price of the items sold by each cashier per cashier day and a store average item price representing the average of all cashier average item prices of all qualifying cashiers during a specified period. A cashier database is generated which includes the daily cashier average item prices. Comparative instructions analyze the daily cashier average item price for each cashier and the store average item price to determine a daily deviation of each cashier from the store average item price, and for calculating a total cashier deviation for each cashier by algebraic summing of the daily deviations of each cashier. Generating a report to identify a cashier deviation which is statistically significantly different from other cashiers.

Claims

1. A computerized method for detecting the under ringing and sliding of merchandise by a cashier in an electronic cash register system employing a plurality of electronic cash registers and a cashier at each cash register, said cash register system compiling raw cash register data which includes the total number of items and dollar amount for all items sold by each cashier for each cashier day the cashier works, said method comprising:

providing a computer;

inputting and storing said cash register data into computer-readable memory;

processing said cash register data on said computer to determine a cashier average item price for each cashier which represents the average price of the items sold by a respective cashier on each day;

indexing said cashier average item price to a respective cashier and storing said cashier average item price for all of said cashiers in a cashier database in a computer-readable medium;

processing said cash register data to determine the store average item price representing the average price of all said items sold by all the cashiers during a specified time period;

comparing said daily cashier average item price and said store average item price to determine the daily deviation of each said cashier from said store average item price;

computing a cashier deviation for each cashier by algebraically summing said daily deviations of each said cashier; and

determining if said cashier deviation of an individual cashier is significantly different from the cashier deviation of the other cashiers so that said individual cashier can be identified for further investigation.

2. The method of claim 1 including determining said daily cashier average item price for each cashier day of said cashiers during said specified time period.

3. The method of claim 2 wherein said specified time period is in a range of about 30 to 90 days.

4. The method of claim 3 wherein said specified period of time is approximately 60 days.

5. The method of claim 1 wherein said specified time period is in a range of about 30 to 90 days.

6. The method of claim 5 wherein said specified period of time is approximately 60 days.

7. The method of claim 1 including computing said store average item price by totaling said cashier average item price for each day for each cashier selected during said specified period and dividing the total by the number of entries in the total.

8. The method of claim 1 including displaying said cashier deviation by generating said report by generating a graph containing a plot of said cashier deviation of said cashiers against said store average item price.

9. The method of claim 8 including generating said graph based on a deviation from said store average item price as a zero base line.

10. The method of claim 8 including printing said graph on a computer associated printer.

11. The method of claim 1 including selecting the said cashier data to be processed on said computer according to predetermined criteria.

12. The method of claim 11 wherein said predetermined criteria includes selecting said cashier data indexed to cashiers who have a minimum number of customers per cashier day.

13. The method of claim 1 including conducting a paper audit of a first cashier whose cashier deviation indicates under ringing.

14. The method of claim 13 including identifying a second cashier whose cashier deviation indicates merchandise sliding but concluding that merchandise sliding is unlikely if said audit trail of said first cashier indicates under ringing.

15. The method of claim 13 including investigating a second cashier whose cashier deviation indicate merchandise sliding in the event said audit trail indicates under ringing is not likely.

16. A computer program for controlling a computer in an electronic cash register system to detect the under ringing and sliding of merchandise by a cashier, said cash register system employing a plurality of electronic cash registers with a cashier at each cash register, a computer for receiving and compiling cash register data from said cash registers which includes the total number of items sold and the total dollar sales of the items sold by each cashier on a cashier day on which the cashier is working, and a cash register database for storing said cash register data in a computer-readable medium;

said computer program embodied in a computer readable medium comprising;

means embodied in computer-readable code for processing said cash register data to calculate a daily cashier average item price for each cashier per cashier day;

means embodied in computer-readable code for creating a cashier database for storing said cashier average item prices indexed to said cashiers in a computer-readable medium;

means embodied in computer-readable code for processing said cash register data to calculate a store average item price representing the average of all qualifying cashier average item prices during a specified time period;

means embodied in computer-readable code for comparing said daily cashier average item price and said store average item price data to calculate a daily deviation of each cashier from said store average item price;

means embodied in computer-readable code for calculating a cashier deviation of each cashier representing the algebraic sum of said daily deviations of each said cashier; and

means embodied in computer-readable code for determining if a cashier deviation of an individual cashier is significantly different from the other cashiers so that said individual cashier can be identified for further investigation.

17. The program of claim 16 including selection instructions embodied in computer-readable code for selecting said cashier data only for cashiers meeting predetermined criteria.

18. The program of claim 17 wherein said means for calculating a store average item price includes instructions embodied in computer-readable code for arriving at a total by adding all of the cashier average item prices for each qualifying cashier for each day in the specified time period and dividing the total by the number of entries in the total.

19. The program of claim 17 wherein said predetermined criteria includes having one of a minimum number of customers during a specified time period.

20. The program of claim 17 wherein said specified time period is in a range of about 30 to 90 days.

21. The program of claim 20 wherein said specified period of time is approximately 60 days.

22. The program of claim 17 including means embodied in computer-readable code for generating a visual report which can be displayed.

23. The program of claim 22 including means embodied in computer-readable media for generating a graph containing a plot of said cashier deviations of said cashiers against said store average item price.

24. A system for detecting the under ringing and sliding of merchandise by a cashier in a retail establishment comprising:

an electronic cash register system employing a plurality of electronic cash registers and a cashier at each cash register, said cash register system compiling raw cash register data which includes the total number of items sold and dollar sales of the items sold by each cashier on each cashier day a cashier works;

a cash register database for storing said cash register data in a computer-readable medium;

a central computer for processing said cash register data;

means embodied in computer-readable code including averaging instructions for processing said cash register data on said computer to determine a daily cashier average item price representing a daily average price of the items sold by each cashier per cashier day and a store average item price representing the average of all qualifying cashier average item prices during a specified time period;

a cashier database including said daily cashier average item prices in computer-readable form indexed to said cashiers stored in a computer-readable medium;

comparative instructions embodied in computer-readable form for comparing said daily cashier average item price for each said cashier and said store average item price to determine a daily deviation of each said cashier from said store average item price, and for calculating a total cashier deviation for each cashier by algebraically summing of said daily deviations of each said cashier; and

means embodied in computer-readable codes for generating a report to identify if a cashier deviation of an individual cashier is significantly different from the other cashiers so that said individual cashier can be identified for further investigation.

25. The system of claim 24 wherein said specified time period is in a range of about 30 to 90 days.

26. The system of claim 25 wherein said specified period of time is approximately 60 days.

27. The system of claim 24 wherein said averaging instructions include means embodied in said computer-readable code for determining said daily cashier average item price sold by each cashier per cashier day by dividing said dollar sales by said number of items.

28. The system of claim 24 wherein said averaging instructions include means embodied in computer-readable code for determining said store average item price by adding all the cashier average item prices of each qualifying cashier and then dividing by the total number of cashier days during said specified time period.

29. The system of claim 28 wherein said specified time period is in a range of about 30 to 90 days.

30. The system of claim 29 wherein said specified period of time is approximately 60 days.

31. The system of claim 25 wherein said averaging instructions include means embodied in computer-readable code for determining said daily cashier average item price for each cashier day of each said cashier during said specified time period.

32. The system of claim 24 includes a visual report generated on said computer for displaying said cashier deviation of said cashiers.

33. The system of claim 32 wherein said report includes a graph containing a plot of said cashier deviation of said cashier against said store average item price as a zero base line.

34. The system of claim 33 wherein said graph is in print form.

35. The system of claim 24 including selection instructions embodied in computer-readable media for selecting said cashier data to be processed on said computer according to predetermined criteria.

36. The system of claim 35 wherein said predetermined criteria includes selecting the cashier data of only cashiers who have worked a minimum number of customers per cashier day during said specified time period.