Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
faq:wastage_prediction_due_to_expiry_v7-12 [2024/02/16 09:19] – [Suggested Order reports] Ujwal Khatry | faq:wastage_prediction_due_to_expiry_v7-12 [2024/02/16 11:03] – [Suggested Order reports] Ujwal Khatry | ||
---|---|---|---|
Line 12: | Line 12: | ||
* Report > Purchasing > Suggested Order quantities… | * Report > Purchasing > Suggested Order quantities… | ||
- | {{ : | + | {{ : |
The Suggested ordering report now has a new/updated expiry filter checkbox : //Exclude stock that will expire within 3 months of projected consumption date// | The Suggested ordering report now has a new/updated expiry filter checkbox : //Exclude stock that will expire within 3 months of projected consumption date// | ||
Line 24: | Line 24: | ||
Imagine we have the following batches for an item. | Imagine we have the following batches for an item. | ||
- | Item | ||
- | Batch | ||
- | Stock | ||
- | Expiry | ||
- | Amoxycillin/ | ||
- | b12-2023 | ||
- | 500 | ||
- | 12/2023 | ||
- | Amoxycillin/ | ||
- | b06-2024 | ||
- | 550 | ||
- | 06/2024 | ||
- | Amoxycillin/ | ||
- | b06-2025 | ||
- | 100 | ||
- | 06/2025 | ||
+ | ^Item ^Batch | ||
+ | |Amoxycillin/ | ||
+ | |Amoxycillin/ | ||
+ | |Amoxycillin/ | ||
- | Imagine the current date is 1/1/2024 | ||
- | Imagine the AMC is 50 | ||
- | Imagine you need stock for 12 months. | ||
- | When running the report this is checked : Exclude stock that will expire within 3 months of projected consumption date | ||
- | When the above report is run, mSupply | + | * Imagine the current date is 1/1/2024 |
+ | * Imagine the AMC is 50 | ||
+ | * Imagine you need stock for 12 months. | ||
+ | * When running the report this is checked : **Exclude stock that will expire within 3 months of projected consumption date** | ||
+ | |||
+ | When the above report is run, mSupply | ||
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. | 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. | ||
- | January 2024 | + | * January 2024 |
- | February 2024 | + | |
- | March 2024 | + | |
- | April 2024 | + | |
- | So the stock that can be used from batch `b06-2024` is : 4 * 50 = 200. | + | So the stock that can be used from batch `b06-2024` is : 4 * 50 = 200. |
- | So the wasted quantity for batch `b06-2024` is : 550 - 200 = 350 (This is expiring stock, 350 will need to be thrown away. ) | + | 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** |
For batch `b06-2025` : So from May 2024, mSupply will need to start using this batch for distribution. So this is 8 months remaining | For batch `b06-2025` : So from May 2024, mSupply will need to start using this batch for distribution. So this is 8 months remaining | ||
- | May 2024 | + | * May 2024 |
- | June 2024 | + | |
So for batch `b06-2025` all the stock will be used up and they will be no wastage. | 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 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` | ||
+ | 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. | ||
+ | |||
+ | ===== New Columns on Suggested order reports and changes ===== | ||
+ | |||
+ | Now the suggested ordering reports will have two new column : | ||
+ | * Effective SOH (Stock on Hand) : From above this is the stock quantities that can be used before they expire. | ||
+ | * Expiring stock : This is the stock quantity that can’t be used due to predicted expiry and cut-off date. | ||
+ | |||
+ | The `Effective Month of Stock` is now calculated from the `Effective SOH` and not from the `Stock on Hand`. The `Suggested order` is now calculated from the `Effective SOH` and the `Effective Month of Stock`. | ||
+ | |||
+ | |||
+ | {{ : | ||
+ | |||
+ | ===== Generating a Purchase order and Tender ===== | ||
+ | The same logic is now applied when generating a purchase order or a tender. Like with the reports, we can ask mSupply to calculate potential stock wastage and order an appropriate quantity. | ||
+ | {{ : | ||
---- struct data ---- | ---- struct data ---- | ||
pagestatus.status | pagestatus.status | ||
---- | ---- | ||