Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
reports:purchasing [2024/07/26 04:38] – [mSupply's better algorithm] Louisa Wong | reports:purchasing [2024/09/09 05:38] (current) – Louisa Wong | ||
---|---|---|---|
Line 155: | Line 155: | ||
Step 5: | Step 5: | ||
We can now calculate the Adjusted AMC with the formula: | We can now calculate the Adjusted AMC with the formula: | ||
- | Square root[(Days in stock)/(Days in the month)] * Consumption | + | Square root[(Days in month)/(Days in the stock)] * Consumption |
We check this individually for each month that has not been excluded. | We check this individually for each month that has not been excluded. | ||
So, if the "Days in month" = "Days in Stock", | So, if the "Days in month" = "Days in Stock", | ||
Line 167: | Line 167: | ||
For the Adjusted AMC = 267.87/8.8 months = 30.34 units per month. | For the Adjusted AMC = 267.87/8.8 months = 30.34 units per month. | ||
- | =============================== | + | **Steps Summarised:** |
- | Steps Summarised: | + | |
- | =============================== | + | |
Step 1: Adjusting by % Days in Stock | Step 1: Adjusting by % Days in Stock | ||
* Set threshold for fully stocked (e.g., 90%) | * Set threshold for fully stocked (e.g., 90%) | ||
Line 186: | Line 185: | ||
Step 5: Calculate Adjusted AMC | Step 5: Calculate Adjusted AMC | ||
- | * Apply formula to each included month = Square root[(Days in stock)/(Days in the month)] * Consumption | + | * Apply formula to each included month = Square root[(Days in month)/(Days in stock)] * Consumption |
* Sum the results | * Sum the results | ||
Line 271: | Line 270: | ||
* Number of months in stock : Calculated by (' | * Number of months in stock : Calculated by (' | ||
- | * Ordered Quantity used : Calculated | + | * Ordered Quantity used : This is how much of the stock you have ordered that you will actually need to use, based on how much you use each day and how much stock you already have (Note: forecast calculation will affect this). This is determined |
+ | * Calculate the "usage per day of stock" = AMC / 30.4375 | ||
+ | * Multiply "usage per day of stock" with the "total number of days in your months stock required" | ||
+ | * Calculate your " | ||
+ | * Subtract "Total usage required" | ||
+ | * This value ("Net stock difference to be used") now determines the " | ||
+ | * If the value is a negative value and there is "Stock on order", add the "Net stock difference to be used" with "Stock on order" = "Net stock difference to be used" + "Stock on order" | ||
+ | * If the value is a positive value and there is "Stock on order", | ||
+ | |||
+ | * Suggested Order calculated by: | ||
+ | * If expected delivery date has not been adjusted: (' | ||
+ | * If expected delivery date has been adjusted, this will be accounted for as it will only look at the stock required from date of expected delivery to the end of months stock required: | ||
+ | |||
+ | * Usage per day = Adjusted AMC/30.4375 (which | ||
+ | * Suggested order quantity = Usage per day x Days needed (which is ' | ||
+ | |||
+ | * This determines | ||
+ | * Note: if you are using the " | ||
+ | * Note: if you are using forecasting this can affect suggested order quantity. Please check forecasting settings on mSupply if it is indicated as being used in the spreadsheet. | ||
+ | * Note: The " | ||
- | * Suggested Order : Calculated by (' | ||
{{: | {{: | ||
{{: | {{: |