Apparatus and program product for generating an allocation table in a computerized procurement system
AssigneeSap SE
InventorsThomas Gabelmann, Berthold M. Simon
Life of this patent
Estimating the term…
Abstract
A method, apparatus and program product are provided for generating an allocation table in a computerized procurement system. The method comprises creating an allocation table listing a plurality of articles to be allocated and a plurality of stores to receive the articles, and determining an allocation quantity of each article for each store based on a fixed quantity of the article and a variable quantity of the article. The fixed quantity of the article is the same for each store, and the variable quantity of the article is individually computed for each store. The method further comprises computing the variable quantity of the article for each store by applying predefined rules to historical data.
Claims24
One or more computer-readable hardware storage media storing a program product for generating an allocation table, the program product comprising machine-readable program code for causing, when executed, one or more machines to perform:
- creating an allocation table listing a plurality of different articles to be allocated and a plurality of stores to receive the plurality of different articles;
- allocating a fixed quantity of each article for each store and a variable quantity of each article, wherein the fixed quantity of each article is the same for each store, and wherein the variable quantity of each article is individually computed for each store;
- and
- computing the variable quantity of each article for each store by applying predefined rules to historical data, determining a total current allocation quantity by adding the variable quantity of each article and the fixed quantity of each article;
- performing a maximum variance check by receiving a maximum variance percentage;
- calculating a variance percentage between the total current allocation quantity and an original stock quantity;
- and
- wherein if the variance percentage is higher than the maximum variance percentage, then allocate a remainder of an unallocated plurality of items to stores with lowest variance percentage;
- wherein if the variance percentage is lower than the maximum variance, then allow the maximum variance check to pass.
An apparatus for generating an allocation table in a computerized procurement system, comprising:
- a central processing unit (CPU);
- and
- a storage device coupled to the CPU and having information stored therein for configuring the CPU to:
- create an allocation table listing a plurality of different articles to be allocated and a plurality of stores to receive the plurality of different articles;
- allocating a fixed quantity of each article for each store and a variable quantity of each article, wherein the fixed quantity of each article is the same for each store, and wherein the variable quantity of each article is individually computed for each store;
- and
- compute the variable quantity of each article for each store by applying predefined rules to historical data, determine a total current allocation quantity by adding the variable quantity of each article and the fixed quantity of each article;
- perform a maximum variance check by receiving a maximum variance percentage;
- calculate a variance percentage between the total current allocation quantity and an original stock quantity;
- and
- wherein if the variance percentage is higher than the maximum variance percentage, then allocate a remainder of an unallocated plurality of items to stores with lowest variance percentage;
- wherein if the variance percentage is lower than the maximum variance, then allow the maximum variance check to pass.
A program product stored on computer-readable hardware storage media for generating an allocation table in a computerized procurement system, the program product comprising machine readable program code for causing, when executed, one or more machines to perform the following method steps:
- creating an allocation table listing a plurality of different articles to be allocated and a plurality of stores to receive the plurality of different articles, corresponding to the purchase order request;
- allocating a fixed quantity of each article for each store and a variable quantity of each article, wherein the fixed quantity of each article is equal for each store, and wherein the variable quantity of the each article is individually computed for each store;
- and
- computing the variable quantity of each article for each store by applying predefined rules to historical data, determining a total current allocation quantity by adding the variable quantity of each article and the fixed quantity of each article;
- performing a maximum variance check by receiving a maximum variance percentage;
- calculating a variance percentage between the total current allocation quantity and an original stock quantity;
- and
- wherein if the variance percentage is higher than the maximum variance percentage, then allocate a remainder of an unallocated plurality of items to stores with lowest variance percentage;
- wherein if the variance percentage is lower than the maximum variance, then allow the maximum variance check to pass.
Dependencies are inferred from the claim text.