HP Forums
(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