Computer-implemented methods and computer systems for managing and valuating inventory

摘要

Methods and computer systems are provided managing and valuating inventory. In one embodiment, a computer system may assign every item of goods which is entering a working process to an identifier. The computer system may then track the goods in the working process. Further, the computer system may update a given identifier when the goods assigned to this identifier enter another stage in the working process, assign at least one price to each stage in the working process, determine the content of one or more identifiers, and calculate a price for goods in the working process.

主权项

1. A computer-implemented method for managing and valuating inventory using an inventory database including an inventory balance indicating a quantity of goods, the method comprising:
assigning, by a processor, upon entering a first stage of a multistage working process, one or more items of goods to one or more identifiers, wherein the one or more identifiers are stored in the inventory database; tracking, by the processor, the one or more items of goods in the working process; setting, by the processor, a cycle count indicator for tracking the one or more items of goods; periodically counting, by the processor, a first item of goods among the one or more items of goods based on a first frequency associated with the cycle count indicator, the first frequency being set based on a pace with which the first item of goods passes through the working process; periodically counting, by the processor, a second item of goods among the one or more items of goods based on a second frequency associated with the cycle count indicator, the second frequency being set based on a pace with which the second item of goods passes through the working process, wherein the second item of goods moves through the working process at a faster pace than the first item of goods and the second frequency is greater than the first frequency; balancing, by the processor, the inventory based on the periodic counting of the first item of goods and the second item of goods; updating, by the processor, the one or more identifiers when the one or more items of goods enter a second stage of the multistage working process; determining, by the processor, whether one of the one or more items of goods in the second stage is a rejected item of goods or an accepted item of goods; selecting, by the processor, one or more valuation rules from a plurality of valuation rules based on the determination; assigning, by the processor, a price per good to the one of the one or more items of goods in the second stage based on the selected one or more valuation rules and the updated one or more identifiers, wherein assigning the at least one price per good includes:
assigning, by the processor, a rejected price based on a first selected valuation rule when the one of the one or more items of goods is determined to be a rejected item of goods; andassigning, by the processor, an accepted price based on a second selected valuation rule when the one of the one or more items of goods is determined to be an accepted item of goods; calculating, by the processor, a price for the one or more items of goods in the second stage based on multiplying a number of the one or more items of goods in the second stage and the assigned price per good in the second stage; calculating, by the processor, a price for the one or more items of goods in the working process; extracting, by the processor, a sample of data from the inventory balance to generate a verification result by comparing the sample of data with a received number indicating a physical count of selected goods in the working process; accepting, by the processor, the quantity of goods indicated in the inventory balance to be accurate when the verification result is less than or equal to a threshold.