Systems and Methods for Managing Inventory for Health Care Offices

• US 20170068929A1
• Filed: 10/04/2016
• Published: 03/09/2017
• Est. Priority Date: 04/27/2015
• Status: Abandoned Application

• Current Assignee: Sowingo.Com Corp.
• Original Assignee: Sowingo.Com Corp.
• Inventors: BHATTI, Ravipal Singh
• Application Number:
  US15/285,162
• Publication Number:
  US 20170068929A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06Q 10/0833 Tracking
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/109 Time management, e.g. calendars, reminders, meetings or time accounting
• CPC Class Codes: G16H 40/20 for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
• CPC Class Codes: G16H 40/63 for local operation
• CPC Class Codes: G16Z 99/00 Subject matter not provided for in other main groups of this subclass

Abstract

Systems and methods are provided to manage inventory of products used in health care practices and organizations. The systems include tools to track inventory, purchase inventory and to predict how much inventory will be used. The method includes obtaining a schedule of future health care procedures. The method predicts an amount of a product that will be consumed by comparing each procedure against a corresponding procedure profile obtained from a procedure profile database. Each procedure profile includes product usage information of products expected to be consumed in a given procedure. This information is then used to predict when orders for replacement units of the product should be placed, to prevent insufficient supply of the product for a scheduled procedure. A graphical user interface is presented to order the replacement units by a determined date and for a determined quantity. Vendors interact with the system to sell the products.

Claims

1. A server system for managing inventory comprising:

memory storing databases, including a product database, an order database, and an inventory database;

a communication device able to communicate over Internet with one or more user devices and one or more vendor computing device; and

one or more processors configured to execute instructions to at least;

generate and transmit a graphical user interface (GUI) via the communication device that is displayable on a given user device, the GUI comprising a product listed in the product database;

receive via the communication device a command using the GUI to order the product;

generate an order entry in the order database for the product, the order entry including an ordered quantity of the product, a tracking number and an order status, the order entry accessible to a given vendor computing device;

receive via the communication device a message able to be transmitted by the given vendor computing device, the message comprising a shipped status associated with the tracking number;

access the order database to update the order entry to have a received status;

access and automatically update the inventory database to have an updated quantity of the product in inventory that includes the ordered quantity of the product; and

wherein the inventory database includes a product entry of the product, an associated minimum quantity, and a current quantity of the product in inventory;

the current quantity is equal to or less than the associated minimum quantity; and

in response, the server system generates a minimum level alert associated with the product for display in the GUI.

2. The server system of claim 1 wherein the one or more processors are configured to further update and transmit the GUI showing the updated quantity of product in inventory.

3. The server system of claim 1 wherein the product listed in the GUI is displayed alongside an alert generated by the server system.

4. The server system of claim 1 wherein the memory further comprises a scheduling database and a procedure profile database;

and the one or more processors further configured to;

obtain a schedule of future health care procedures by accessing the scheduling database, the schedule identifying a date for each procedure;

compute an amount of a product that will be consumed by comparing each procedure against a corresponding procedure profile obtained from the procedure profile database, the product usage information of at least one or more of procedure profiles including a product identifier of the product and a corresponding usage quantity of the product;

compute how many days later from a current date that a number of currently available units of the product in an inventory of the health care office will run out based on the computed amount of the product that will be consumed in the future;

determine a date of when to order replacement units of the product and a quantity of replacement units of the product based on at least the predicted number of days later from the current date that the currently available units of the product in the inventory will run out; and

generate a prediction alert to order the replacement units by the determined date and for the determined quantity, the prediction alert for display in the GUI.

5. The server system of claim 1 wherein the inventory database includes a product entry of the product and an associated expiry date of certain units of the product;

the associated expiry date is within one or more days from a current date, or the associated expiry date has passed; and

in response, the server system generates an expiry date alert associated with the product for display in the GUI.

6. The server system of claim 1 wherein responsive to receiving scanned barcode data via the communication device, the server system identifies the product associated with the scanned barcode data by accessing the inventory database and displays the GUI showing the product.

7. The server system of claim 1 wherein responsive to receiving scanned radio frequency identification (RFID) data via the communication device, the server system identifies the product associated with the scanned RFID data by accessing the inventory database and displays the GUI showing the product.

8. The server system of claim 1 wherein responsive to receiving a digital image via the communication device, the server system identifies the product associated with the digital image by accessing the inventory database and displays the GUI showing the product.

9. The server system of claim 1 further comprising an accounting database stored in the memory, and after automatically updating the inventory database to have the updated quantity of the product in inventory, the server system automatically updating the accounting database to have an updated monetary value associated with total current inventory.

10. The server system of claim 9 further generating and transmitting another GUI that includes the updated total monetary value.

11. A server system for managing inventory comprising:

memory storing databases, including a product database, an order database, and an inventory database;

a communication device able to communicate over Internet with one or more user devices and one or more vendor computing device; and

one or more processors configured to execute instructions to at least;

generate and transmit a graphical user interface (GUI) via the communication device that is displayable on a given user device, the GUI comprising a product listed in the product database;

receive via the communication device a command using the GUI to order the product;

generate an order entry in the order database for the product, the order entry including an ordered quantity of the product, a tracking number and an order status, the order entry accessible to a given vendor computing device;

receive via the communication device a message able to be transmitted by the given vendor computing device, the message comprising a shipped status associated with the tracking number;

access the order database to update the order entry to have a received status;

access and automatically update the inventory database to have an updated quantity of the product in inventory that includes the ordered quantity of the product; and

responsive to receiving a digital image via the communication device, the server system identifies the product associated with the digital image by accessing the inventory database and invokes displaying the GUI showing the product.

12. The server system of claim 11 wherein the one or more processors are configured to further update and transmit the GUI showing the updated quantity of product in inventory.

13. The server system of claim 11 wherein the product listed in the GUI is displayed alongside an alert generated by the server system.

14. The server system of claim 11 wherein:

the inventory database includes a product entry of the product, an associated minimum quantity, and a current quantity of the product in inventory;

the current quantity is equal to or less than the associated minimum quantity; and

in response, the server system generates a minimum level alert associated with the product for display in the GUI.

15. The server system of claim 11 wherein the memory further comprises a scheduling database and a procedure profile database;

and the one or more processors further configured to;

obtain a schedule of future health care procedures by accessing the scheduling database, the schedule identifying a date for each procedure;

compute an amount of a product that will be consumed by comparing each procedure against a corresponding procedure profile obtained from the procedure profile database, the product usage information of at least one or more of procedure profiles including a product identifier of the product and a corresponding usage quantity of the product;

compute how many days later from a current date that a number of currently available units of the product in an inventory of the health care office will run out based on the computed amount of the product that will be consumed in the future;

determine a date of when to order replacement units of the product and a quantity of replacement units of the product based on at least the predicted number of days later from the current date that the currently available units of the product in the inventory will run out; and

generate a prediction alert to order the replacement units by the determined date and for the determined quantity, the prediction alert for display in the GUI.

16. The server system of claim 11 wherein the inventory database includes a product entry of the product and an associated expiry date of certain units of the product;

the associated expiry date is within one or more days from a current date, or the associated expiry date has passed;

and in response, the server system generates an expiry date alert associated with the product for display in the GUI.

17. The server system of claim 11 wherein responsive to receiving scanned barcode data via the communication device, the server system identifies the product associated with the scanned barcode data by accessing the inventory database and displays the GUI showing the product.

18. The server system of claim 11 wherein responsive to receiving scanned radio frequency identification (RFID) data via the communication device, the server system identifies the product associated with the scanned RFID data by accessing the inventory database and displays the GUI showing the product.

19. The server system of claim 11 further comprising an accounting database stored in the memory, and after automatically updating the inventory database to have the updated quantity of the product in inventory, the server system automatically updating the accounting database to have an updated monetary value associated with total current inventory.

20. The server system of claim 19 further generating and transmitting another GUI that includes the updated total monetary value.