(19B) Estimating Inventory Availability - Printable Version +- HP Forums (https://www.hpmuseum.org/forum) +-- Forum: HP Software Libraries (/forum-10.html) +--- Forum: General Software Library (/forum-13.html) +--- Thread: (19B) Estimating Inventory Availability (/thread-11721.html) |
(19B) Estimating Inventory Availability - SlideRule - 11-01-2018 11:48 PM From the Working with your Business Consultant Professional Calculator series, Manufacturing Consultant booklet, Estimating Inventory Availability; formula AVAIL = (INVE÷USAGE)×4.33 where AVAIL = availability in *weeks INVE = inventory on hand USAGE = forecast or usage per month "Availability estimates tell you approximately how long your inventory will last, based on forecast rates or usage rates. The formula above can be applied to finished goods or production parts. This formula calculates availability in weeks, based on inventory on hand and us- age per month." *weeks: formula assumes 4.33 weeks/month, a weekly availability, replace 4.33 with 1 for monthly availability, etc. SlideRule |