FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS

[PAR80]

DOES ANY ONY HAVE THE FORMULA FOR CALCULATING MIN MAX LEVELS FOR INVENTORY
CONTROL

 

[Rick Rothstein]

Not a lot of detail to go on in your question. Excel has a MIN and MAX
function that you can probably use... check it out in the help files (click
the fx button to the left of the Formula Bar, select All in the category
drop down box, select either MIN or MAX in the list that gets displayed and
then click the "Help on this function" link at the bottom of the dialog
box).

 

[cil]

If you are looking to set levels Kanban levels, there are several models on
some of the "Lean/Sigma" sites. A Lot of variables goes into these
calculations.

cil

 

[Herbert Seidenberg]

Excel 2007
Using Kanban controls to minimize manufacturing buffer inventory.
With Monte Carlo method, regression, sensitivity analysis.
With macros and charts.
Ditto Cil.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_15_09a.xlsm