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;
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.

Find all posts by this user
Quote this message in a reply
Post Reply 

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