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/10/25 23:21] – [Only consider fully stocked months] Mark Gloverreports:purchasing [2025/06/06 05:06] (current) – [mSupply's better algorithm] Nick Pendergrast
Line 55: Line 55:
  
 == Report on purchase orders... == == Report on purchase orders... ==
-In the same way, you can also filter your reports on properties of the purchase orders involved: category, status and both purchase order custom fields.  For more information on purchase order categories see [[purchasing:show_po_categories | here]]+In the same way, you can also filter your reports on properties of the purchase orders involved: category, status and both purchase order custom fields.  For more information on purchase order categories see [[purchasing:show_po_categories | here]]. 
 + 
 +<WRAP info center round 90%> 
 +Please note there is also a //Purchases by suppliers// report that relates stock received to purchase orders made. This is one of the item ledger type reports and details can be foiund on the [[reports:items_and_stock#item_ledger|13.02. Stock and items reports]] page. 
 +</WRAP>
  
 =====  Purchases ===== =====  Purchases =====
Line 112: Line 116:
 We've tried to come up with a better algorithm here by: We've tried to come up with a better algorithm here by:
   * ignoring months that are in stock for < 33% of days. That is, if the item was in stock for less than 10 days in the month, the consumption on those days is too erratic to draw conclusions about what the consumption for the whole month would have been.           * ignoring months that are in stock for < 33% of days. That is, if the item was in stock for less than 10 days in the month, the consumption on those days is too erratic to draw conclusions about what the consumption for the whole month would have been.        
-  * For months with stock >= 33% of days, Multiply the consumption for the month by Square Root(Days in month/Days in stock) to get adjusted AMC. This adjusts the consumption up due to being out of stock, but by a factor up to 1.7 - so not as big an adjustment as the "Adjust by % of days out of stock" method.+  * For months with stock >= 33% of days, Multiply the consumption for the month by √(Days in month/Days in stock) to get adjusted AMC. This adjusts the consumption up due to being out of stock, but by a factor up to 1.7 - so not as big an adjustment as the "Adjust by % of days out of stock" method.
   * We also ignore months where the mean stock on hand is less than "% of typical AMC that stock level is considered compromised:" value you enter. This is a bit complicated, but here's an example:   * We also ignore months where the mean stock on hand is less than "% of typical AMC that stock level is considered compromised:" value you enter. This is a bit complicated, but here's an example:
     * Consider Item A - we have set the "when we calculate consumption there are 3 months that were "fully stocked" - those three months give us an AMC of 1500 per month.     * Consider Item A - we have set the "when we calculate consumption there are 3 months that were "fully stocked" - those three months give us an AMC of 1500 per month.
-    * Now, there's another month that was fully stocked (as in, on all 31 days in the month, there was _some_ stock on hand. +    * Now, there's another month that was fully stocked (as in, on all 31 days in the month, there was //some// stock on hand. 
-    * But it turns out that the average stock on hand was only 50 - clearly they could never have had "normal" consumption, although they did have stock - if the cutoff is set to 100%, we're saying "ignore this month unless the average stock on hand was 1500 - in this case it's 50, so this month isn't used in the AMC calculations+    * But it turns out that the average stock on hand was only 50 - clearly they could never have had "normal" consumption, although they did have stock - if the cut-off is set to 100%, we're saying "ignore this month unless the average stock on hand was 1500 - in this case it's 50, so this month isn't used in the AMC calculations
    
-We then sum the adjusted consumption for all the eligible months & divide by the number eligible months to get the best AMC eva ;-)+We then sum the adjusted consumption for all the eligible months & divide by the number eligible months to get the best forecast AMC eva ;-) 
 + 
 + 
 + 
 + 
 +Here's a diagram: 
 + 
 +<mermaid> 
 +graph TD 
 +    A(Was the Month fully stocked?)-->|Yes|B(Use consumption from these months to calculate typical AMC) 
 +    A-->|NO|C(Ignore these months) 
 +    B-->D(Was there months having <10 days with stock)-->|Yes|E(Ignore these months) 
 +    D-->|No|F(Increase consumption with adjusted AMC to account for days out of stock for these months) 
 +  classDef OR fill:Orange 
 +  class A,B,C,D,E,F OR 
 +</mermaid>   
 + 
 + 
 + 
  
 =============== ===============
Line 315: Line 338:
 \\ \\
 \\ \\
-|  //  Previous:  **[[reports:transactions]]** | | Next: **[[reports:requisitions]]** //  |+|  //  Previous:  **[[reports:transactions]]** | | Next: **[[reports:stocktakes]]** //  |
 ---- struct data ---- ---- struct data ----
 pagestatus.status    : All Good pagestatus.status    : All Good
 ---- ----
  
  • Last modified: 2024/10/25 23:21
  • by Mark Glover