Differences

This shows you the differences between two versions of the page.

--- faq:wastage_prediction_due_to_expiry_v7-12 [2024/02/19 06:49] – [The problem] Ujwal Khatry
+++ faq:wastage_prediction_due_to_expiry_v7-12 [2024/03/11 08:13] (current) – [Suggested Order reports] Ujwal Khatry
@@ Line 40: / Line 40: @@
 When the above report is run, mSupply will immediately ignore the batch `b12-2023` as it has already expired as the current date is `1/1/2024`.
-For batch `b06-2024` :  mSupply works out that you can only dispense this batch till the end of April 2024, due to the set 3 months cutt-off date for expiry.  So the months that this stock cane be dispensed are :
+For batch `b06-2024` :  mSupply works out that you can only dispense this batch till the end of March 2024, due to the set 3 months cutt-off date for expiry.  So the months that this stock can be dispensed are :
   * January 2024
   * February 2024
   * March 2024
-  * April 2024
-So the stock that can be used from batch `b06-2024` is :  4 * 50 = 200.   ( In the reports that you will see in the future, this is known as **effective stock**)
+So the stock that can be used from batch `b06-2024` is :  3 * 50 = 150.   ( In the reports that you will see in the future, this is known as **effective stock**)
-So the wasted quantity for  batch `b06-2024` is :  550  - 200 = 350   (This is expiring stock, 350 will need to be thrown away. In the reports that you will see in the future, this is shown as **Expiring stock** )
+So the wasted quantity for  batch `b06-2024` is :  550  - 150 = 300   (This is expiring stock, 300 will need to be thrown away. In the reports that you will see in the future, this is shown as **Expiring stock** )
-For batch `b06-2025` : So from May 2024, mSupply will need to start using this batch for distribution. So this is 8 months remaining  from May 2024 - to December 2024.  However with a stock of just `100` this item will be used up during the following two months :
+For batch `b06-2025` : So from April 2024, mSupply will need to start using this batch for distribution. So this is 9 months remaining  from April 2024 - to December 2024.  However with a stock of just `100` this item will be used up during the following two months :
+  * April 2024
   * May 2024
-  * June 2024
 So for batch `b06-2025` all the stock will be used up and they will be no wastage.
-However we now have 6 months starting from July 2024 till the end of December 2024 where we don’t have any stock, so mSupply will suggest a immediate order of :   6 * 50 =300 to cope with the 12 months starting from `1/1/2024`
+However we now have 7 months starting from June 2024 till the end of December 2024 where we don’t have any stock, so mSupply will suggest a immediate order of :   7 * 50 =350 to cope with the 12 months starting from `1/1/2024`
 mSupply has effectively time travelled into the future to work out the **Effective Stock on hand (SOH)** and the order will be carried out based on this and not the current stock on hand.