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/08/02 07:07] – [Report output] Louisa Wong | reports:purchasing [2024/08/12 01:41] (current) – [Report output] Louisa Wong | ||
---|---|---|---|
Line 270: | Line 270: | ||
* Number of months in stock : Calculated by (' | * Number of months in stock : Calculated by (' | ||
- | * Ordered Quantity used : Calculated by ('Stock on order' | + | * 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 | ||
+ | * 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", | ||
+ | * If the value is a positive value and there is "Stock on order", | ||
* Suggested Order calculated by: | * Suggested Order calculated by: | ||
Line 277: | Line 284: | ||
* Usage per day = Adjusted AMC/30.4375 (which is from 365.25/12 which is days in the full year) | * Usage per day = Adjusted AMC/30.4375 (which is from 365.25/12 which is days in the full year) | ||
- | * Suggested order quantity = Usage per day x Days needed (which is ' | + | * Suggested order quantity = Usage per day x Days needed (which is ' |
* 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 " | * 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 " |