Post Reply 
(19B) Estimating Inventory Availability
11-01-2018, 11:48 PM (This post was last modified: 11-27-2018 01:28 PM by SlideRule.)
Post: #1
(19B) Estimating Inventory Availability
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
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)