INVENTORY MANAGEMENT AND ORDERING SYSTEM

• US 20090037283A1
• Filed: 08/04/2008
• Published: 02/05/2009
• Est. Priority Date: 08/04/2007
• Status: Abandoned Application

• Current Assignee: Rob Anderson
• Original Assignee: Rob Anderson
• Inventors: Anderson, Rob
• Application Number:
  US12/185,756
• Publication Number:
  US 20090037283A1
• Time in Patent Office: Days
• US Class Current: 705/15
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 50/12 Hotels or restaurants

Abstract

In some embodiments, systems, methods and graphical user interfaces for managing inventory and ordering supplies are provided. A scanner can be provided for scanning inventory bar codes and for receiving inventory quantities associated with the bar codes. The inventory quantities can be loaded onto a computer in association with corresponding bar codes, and a computer can be used to calculate ordering requirements for each inventory item based on a difference between a par value for each inventory item and its corresponding inventory level. The system can also calculate par values for ingredient items and notify a user of required ingredients to match the calculated par value.

Claims

1. A computer implemented method for managing inventory comprising:

receiving assessed inventory quantities for a plurality of items and associated bar codes from a scanner device into a memory of a computer;

calculating a plurality of item orders, each based on a difference between the assessed quantity for an inventory item and a corresponding par value for the inventory item;

displaying the calculated item orders in a graphical user interface;

allowing a user to adjust the calculated item orders in the graphical user interface; and

when a users selects a send orders option within the graphical user interface, transmitting the item orders and adjusted item orders to a plurality of vendors, each vendor being associated with at least one of the items to be ordered, the transmission method for each vendor being pre-associated with the vendor.

2. The computer implemented method of claim 1 wherein the calculated item orders are displayed in a table and a user can select or unselect a field in the table corresponding to a calculated item order to exclude the item order from being transmitted to a vendor when the send orders option is selected.

3. The computer implemented method of claim 1 wherein transmitting the item orders automatically comprises sending the orders out to vendors by use of pre-assigned transmission methods assigned according to each distributor'"'"'s preference.

4. The computer implemented method of claim 3 wherein each distributor can be assigned a primary transmission method and one or more alternative transmission methods.

5. The computer implemented method of claim 1 further comprising collecting price information from vendors and automatically selecting the vendor with the lowest price for each item when the items orders are transmitted.

6. The computer implemented method of claim 1 further comprising displaying order status after item orders are transmitted.

7. The computer implemented method of claim 1 further comprising displaying an order price comparison report showing prices for an inventory item over a range of time selected by a user.

8. The computer implemented method of claim 1 further comprising displaying an inventory value report for the value of inventory held by a user'"'"'s facility, and displaying an inventory value for one or more categories of product.

9. A method for managing ingredient preparation comprising:

(a) tracking food item sales in a computer and using the computer to calculate ingredient consumption data for in-house prepared ingredient items for a given period of time for each food item based on the number of food items sold and a ratio for each prepared ingredient item;

(b) using the ingredient consumption data for a given period of time to calculate a par value for each prepared ingredient item;

(c) using a scanner device to read a bar code associated with at least one of the prepared ingredient items;

(d) assessing a quantity of inventory for the prepared ingredient item remaining in stock and entering the quantity into the scanner device in association with the corresponding bar code;

(e) transmitting the quantity of prepared ingredient item to the computer;

(f) repeating steps (c) through (e) above a plurality of times, once for each prepared ingredient item;

(g) using the computer to calculate and display a quantity of each prepared ingredient item that needs to be prepared to raise the prepared ingredient item inventory levels up to the prepared ingredient item par values.

10. A system for managing inventory comprising:

a scanner device operable for reading a bar code associated with an inventory item, the scanner having input members for use in entering quantities of inventory into a memory of the scanner device; and

a computer operable to communicate with the scanner to receive and read data from the scanner, the data being reflective of inventory levels for a plurality of inventory items, the computer also being operable to calculate differences between the quantities for the inventory items and corresponding par values for each inventory item and to transmit orders to vendors as a function of the calculated differences.

11. The system of claim 10 wherein the computer is further operable to track food item sales and calculate ingredient consumption for a given period of time for each food item based on the number of food items sold and a ratio for each prepared ingredient item and for using the ingredient consumption for a given period of time to calculate a par value for each prepared ingredient item.

12. The system of claim 11 wherein a plurality of par values can be calculated by the system for any given prepared ingredient item, with each of the plurality of par values being applicable for a particular time frame.

13. The system of claim 11 wherein the computer is further operable to display a prepared ingredient requirement to bring an prepared ingredient inventory level up to a corresponding par value of the prepared ingredient item.

14. The system of claim 10 wherein the computer includes and associated display device and is further operable to display data representing each order to be placed to a vendor prior to placing such orders, and wherein a user can selectively block any of the orders from being transmitted by selecting or unselecting a graphical field corresponding to the order.

15. The system of claim 14 wherein a list of inventory items to be ordered can be displayed in a graphical user interface with the graphical user interface providing fields in which to edit the quantities of each of inventory items to be ordered.

16. The system of claim 15 wherein the graphical user interface can also display a status of each order after it is placed.

17. The system of claim 10 wherein when the computer transmits orders to vendors, the orders are transmitted by a preferred transmission method in accordance with at least one pre-programmed transmission method associated with each vendor.

18. The system of claim 10 wherein the computer includes a display device and is operable to display an order price comparison report showing prices for inventory items ordered over a given time frame.

19. The system of claim 18 wherein the computer is operable to display an inventory value for a given day including an inventory value for a particular category of product or for a particular set of inventory items purchase from a given vendor.

20. The system of claim 18 wherein the computer is operable to display a history of orders transmitted by the computer for a selected date range.

21. The system of claim 20 wherein the computer is operable to display adjustments made to calculated differences for each inventory item in the history of orders displayed.

22. The system of claim 10 wherein the computer includes an associated display device and the computer is operable to display a table of inventory items with associated, vendors, vendor prices for the inventory items, and lot sizes for the inventory items, and wherein the user can use the table to selectively change selected vendors to utilize for any particular inventory item, whereby if a change is made in the table, when orders are transmitted, any particular order for the inventory item for which a vendor change was selected, will be transmitted to the newly selected vendor.

23. The system of claim 10 wherein the computer is operable to automatically receive updated price data for products from vendors via a connection to a computer network.

24. The system of claim 10 wherein the updated price data can be used by the computer to automatically select vendors to which order will be sent for one or more inventory items.

25. The system of claim 10 wherein the computer is operable to instruct a printer to print a bar code for any particular inventory item.

26. A computer readable medium containing instructions for instructing a computer to carry out a method for managing inventory, the method comprising:

receiving assessed inventory quantities for a plurality of items and associated bar codes from a scanner device into a memory of a computer;

calculating a plurality of item orders, each based on a difference between the assessed quantity for an inventory item and a corresponding par value for the inventory item;

displaying the calculated item orders in a graphical user interface;

allowing a user to adjust the calculated item orders in the graphical user interface; and

when a users selects a send orders option within the graphical user interface, transmitting the item orders and adjusted item orders to a plurality of vendors, each vendor being associated with at least one of the items to be ordered, the transmission method for each vendor being pre-associated with the vendor.

27. The computer readable medium of claim 26 further comprising calculating an ingredient consumption for a given period of time in a facility based on number of food items sold by the facility and a ratio for each in-house prepared ingredient item and using the ingredient consumption for a given period of time to calculate a par value for each in-house prepared ingredient item.