HP Forums

Full Version: (19B) Estimating Inventory Availability
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
Reference URL's