reports:purchasing

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
reports:purchasing [2024/08/12 00:13] – [Report output] Louisa Wongreports:purchasing [2024/09/09 05:38] (current) – Louisa Wong
Line 270: Line 270:
   * Number of months in stock : Calculated by ('Effective SOH') / ('Adjusted AMC'). This gives the number of months the current stock will last based on adjusted consumption rates.   * Number of months in stock : Calculated by ('Effective SOH') / ('Adjusted AMC'). This gives the number of months the current stock will last based on adjusted consumption rates.
  
-  * Ordered Quantity used : This is the quantity of the "stock on order" that will be used. This is determined by:+  * 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 by:
          * Calculate the "usage per day of stock" = AMC / 30.4375          * 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" to get "Total usage required" = Usage per day of stock x Total number of days in your months stock required          * Multiply "usage per day of stock" with the "total number of days in your months stock required" to get "Total usage required" = Usage per day of stock x Total number of days in your months stock required
Line 286: Line 286:
          * Suggested order quantity = Usage per day x Days needed (which is 'Expected delivery date' - End date of the 'Months stock required', or days needed in total - days of lead time) - ('Effective SOH' - 'Stock on order') + 'Backorder'          * Suggested order quantity = Usage per day x Days needed (which is 'Expected delivery date' - End date of the 'Months stock required', or days needed in total - days of lead time) - ('Effective SOH' - 'Stock on order') + 'Backorder'
  
-  * This determines the quantity of stock that needs to be ordered to maintain the desired inventory levels after considering current stock, back orders, and stock already on order. Note: if you are using the "Minimum stock" function, the suggested order will also take this into account to ensure that there is enough stock to meet this value. This will be calculated by taking the minimum pack size to cover the minimum stock.+  * This determines the quantity of stock that needs to be ordered to maintain the desired inventory levels after considering current stock, back orders, and stock already on order.  
 +  * Note: if you are using the "Minimum stock" function, the suggested order will also take this into account to ensure that there is enough stock to meet this value. This will be calculated by taking the minimum pack size to cover the minimum stock. 
 +  * 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 "maximum" quantity field is only a UI feature and does not have any other functionality apart from allowing users to see their recorded maximum quantity. Anything in this field will not be accounted for in the SOQ report.  
 {{:reports:pasted:20240724-234648.png?350}} {{:reports:pasted:20240724-234648.png?350}}
 {{:reports:pasted:20240724-234725.png?350}} {{:reports:pasted:20240724-234725.png?350}}
  • Last modified: 2024/08/12 00:13
  • by Louisa Wong