Method and system for electronically managing product inventory using a database

• US 20080120207A1
• Filed: 11/21/2006
• Published: 05/22/2008
• Est. Priority Date: 11/21/2006
• Status: Abandoned Application

• Current Assignee: Ronnie D. Strickland
• Original Assignee: Ronnie D. Strickland
• Inventors: Strickland, Ronnie D.
• Application Number:
  US11/602,670
• Publication Number:
  US 20080120207A1
• Time in Patent Office: Days
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A method, system, and machine-readable medium for providing targeted information in relation to pharmaceutical product inventory management is disclosed. The system is adapted to manage an entity'"'"'s outpatient medication inventory without the need for maintaining a separate inventory in a manner which is quick, easy, and efficient.

Claims

1. A method for electronically managing product inventory using a database, the method comprising the steps of:

populating a database field of the database with the dispensed quantity of at least one product, the database performing the steps of;

calculating the total inventory quantity remaining of the at least one product;

populating the database with the total inventory quantity remaining of the at least one product;

calculating the replenish quantity of the at least one product required to replenish the at least one product inventory to a defined quantity; and

populating the database with the replenish quantity of the at least one product.

2. The method of claim 1, the database further performing the steps of:

calculating the quantity of excess inventory remaining for a defined interval for the at least one product;

adding the quantity of excess inventory of the at least one product to the replenish quantity of the at least one product to generate a carryover quantity; and

populating the database with the carryover quantity.

3. The method of claim 2, wherein the defined interval comprises a calendar month.

4. The method of claim 2, wherein the defined interval comprises a week.

5. The method of claim 2, wherein the defined interval comprises a quarter of a calendar year.

6. The method of claim 1, wherein the defined quantity comprises a value substantially equivalent to a maximum quantity of the at least one product.

7. A computer-readable storage medium having computer-executable instructions executable by a digital processing apparatus for performing a method, the method comprising:

populating a database field of the database with the dispensed quantity of at least one product, the database performing the steps of;

calculating the total inventory quantity remaining of the at least one product;

populating the database with the total inventory quantity remaining of the at least one product;

calculating the replenish quantity of the at least one product required to replenish the at least one product inventory to a defined quantity; and

populating the database with the replenish quantity of the at least one product.

8. The method of claim 7, the database further performing the steps of:

calculating the quantity of excess inventory remaining for a defined interval for the at least one product;

adding the quantity of excess inventory of the at least one product to the replenish quantity of the at least one product to generate a carryover quantity; and

populating the database with the carryover quantity.

9. The method of claim 8, wherein the defined interval comprises a calendar month.

10. The method of claim 8, wherein the defined interval comprises a week.

11. The method of claim 8, wherein the defined interval comprises a quarter of a calendar year.

12. The method of claim 7, wherein the defined quantity comprises a value substantially equivalent to a maximum quantity of the at least one product.

13. A system for managing product inventory comprising:

a storage device;

a printer; and

a processor programmed to;

populate a database field of the database with the dispensed quantity of at least one product, the database performing the steps of;

calculate the total inventory quantity remaining of the at least one product;

populate the database with the total inventory quantity remaining of the at least one product;

calculate the replenish quantity of the at least one product required to replenish the at least one product inventory to a defined quantity; and

populate the database with the replenish quantity of the at least one product.

14. The system of claim 13, wherein the processor is further programmed to:

calculate the quantity of excess inventory remaining for a defined interval for the at least one product;

add the quantity of excess inventory of the at least one product to the replenish quantity of the at least one product to generate a carryover quantity; and

populate the database with the carryover quantity.

15. The system of claim 14, wherein the defined interval comprises a calendar month.

16. The system of claim 14, wherein the defined interval comprises a week.

17. The system of claim 14, wherein the defined interval comprises a quarter of a calendar year.

18. The system of claim 13, wherein the defined quantity comprises a value substantially equivalent to a maximum quantity of the at least one product.