Stability Inventory Calculation |
Content |
|||||||||||||||||||||
|
If the auto-calculation option is selected in the Plan, the system automatically calculates the number of containers:
The Inventory Calculation determines the number of Containers required for any single Sample Pull.
Inventory calculation is controlled by these factors:
Stability supports these inventory models:
Unit Validation is performed throughout Stability and Studies. When calculating inventory, PlanItem WorkItem Units are validated against Container Unit only when TrackItem inventory calculation converts them to Container Unit of the Study before the calculation. See Stability Unit Validation for more details about Unit Validation.
This determines the number of Containers required based on the total quantity.
To derive the total quantity, you must define these factors that contribute to the calculation:
Test | Number of Repeats | Quantity per Repeat | Quantity Units |
A | 1 | 25 | Tablets |
B | 2 | 10 | Tablets |
C | 3 | 30 | Tablets |
Calculation |
To get the total number of Containers required for the raw inventory:
Get the total required inventory per Test. Add all the available Tests (also considering the number of repeats for the Tests).
Test A - 25*1 = 25
Test B - 10*2 = 20
Test C - 30*3 = 90
Total Raw Quantity = 135 Tablets [25 + 20 + 90]
Calculate the number of Containers needed based on the Container size. Divide the total of 135 Tablets by Container Size.
Container Size | Number of Containers Needed |
25 Tablets | 6 |
50 Tablets | 3 |
100 Tablets | 2 |
200 Tablets | 1 |
500 Tablets | 1 |
Multiply Quantity by Sample Count
If the Sample Count is greater than 1, and the "Multiply Quantity by Sample Count" is Yes, the Pull Quantity (Quantity per Repeat) is multiplied by the defined number of Samples.
If, in the above example, the number of Samples is 2, and the "Multiply Quantity by Sample Count" is Yes the total quantity is calculated as follows:
Test A - 25*1 = 25
Test B - 10*2 = 20
Test C - 30*3 = 90
Total Raw Quantity = 135 Tablets [50 + 40 + 180] multiplied by 2 (Number of Samples) = 270 Tablets.
This calculates the number of Containers needed for separate Laboratories (Departments).
To derive the total quantity, you must define these factors that contribute to the calculation:
Test | Laboratory | Number of Repeats | Quantity per Repeat | Quantity Units |
A | Physical | 1 | 25 | Tablets |
B | Physical | 2 | 10 | Tablets |
C | Bio | 3 | 30 | Tablets |
Calculation |
To get the total number of Containers for discreate laboratories:
Get the total required inventory for all the Tests per Laboratoty. Add all the available Tests in each of the laboratory (also considering the number of repeats for the Tests).
Total Raw Quantity:
Physical Lab | Bio Lab |
Test A - 25*1 Test B - 10*2 |
30*3 |
45 tablets [25 + 20] | 90 tablets |
Calculate the number of Containers needed for discreate laboratories based on the Container size. Divide the total of 45 Tablets and 90 Tablets (for each laboratory) by Container Size.
Number of Containers
Needed
|
||
Container Size |
Physical |
Bio |
25 Tablets | 2 | 4 |
50 Tablets | 1 | 2 |
100 Tablets | 1 | 1 |
200 Tablets | 1 | 1 |
500 Tablets | 1 | 1 |
To derive the total quantity, you must define these factors that contribute to the calculation:
Test | Separate Containers per Repeat | Number of Repeats | Quantity per Repeat | Quantity Units |
A | Yes | 1 | 25 | Tablets |
B | Yes | 2 | 10 | Tablets |
C | Yes | 3 | 30 | Tablets |
Calculation |
To get the total number of Containers required for the each repeat:
Get the total required inventory for all the repeats of all Tests. Add all the Tests in each of the repeat.
Total Raw Quantity:
Repeat 1 Test A, B & C | Repeat 2 Test B & C | Repeat 3 Test C |
25+10+30 | 10+30 | 30 |
65 tablets | 40 tablets | 30 tablets |
Calculate the number of Containers needed for each repeat based on the Container size. Divide the total of 65 Tablets, 40 Tablets and 30 Tablets (for each repeat) by Container Size.
Number of Containers
Needed | |||
Container Size | Repeat 1 Test A, B & C | Repeat 2 Test B & C | Repeat 3 Test C |
25 Tablets | 3 | 2 | 2 |
50 Tablets | 2 | 1 | 1 |
100 Tablets | 1 | 1 | 1 |
200 Tablets | 1 | 1 | 1 |
500 Tablets | 1 | 1 | 1 |
Calculate Quantity using Separate Containers : Separate Tests from Separate Container |
| |
This calculates the number of Containers needed for each Test, where execution of each Test requires separate Containers.
To derive the total quantity, you must define these factors that contribute to the calculation:
Test | Separate Containers per Test | Number of Repeats | Quantity per Repeat | Quantity Units |
A | Yes | 1 | 25 | Tablets |
B | Yes | 2 | 10 | Tablets |
C | Yes | 3 | 30 | Tablets |
Calculation |
To get the total number of Containers required for the each Test:
Get the total required inventory for each of the Tests (also considering the number of repeats for the Tests).
Total Raw Quantity:
Test A | Test B | Test C |
25*1 | 10*2 | 30*3 |
25 tablets | 20 tablets | 90 tablets |
Calculate the number of Containers needed for each Test based on the Container size. Divide the total of 25 Tablets, 20 Tablets and 90 Tablets (for each Test) by Container Size.
Number of Containers | |||
Container Size | Test A | Test B | Test C |
25 | 1 | 1 | 4 |
50 | 1 | 1 | 2 |
100 | 1 | 1 | 1 |
200 | 1 | 1 | 1 |
500 | 1 | 1 | 1 |
This calculates the number of Containers needed for Tests that are Destructive or Non-Destructive in nature.
To derive the total quantity, you must define these factors that contribute to the calculation:
Test | Destructive? | Number of Repeats | Quantity per Repeat | Quantity Units |
A | No | 1 | 25 | Tablets |
B | Yes | 2 | 10 | Tablets |
C | Yes | 3 | 30 | Tablets |
Calculation |
To get the total number of Containers required for the each type of Test:
Get the total required inventory per Test. Add all the available Tests (also considering the number of repeats for the Tests).
Test A - 25*1 = 25
Test B - 10*2 = 20
Test C - 30*3 = 90
Total Raw Quantity = max 110 Tablets [25*1, 10*2 + 30*3]
As the Non-Destructive Tests are performed first and it does not consumes material, the same material is used for Destructive Test later. Therefore the quantity of Non-Destructive Test (Test A - 25) is not considered for the final calculation.
Calculation of the number of containers needed based on the container size to get the total of 110 Tablets.
Container Size | Number of Containers |
25 | 5 |
50 | 3 |
100 | 2 |
200 | 1 |
500 | 1 |