Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS

1,877 views
Skip to first unread message

PAR80

unread,
Jan 10, 2010, 1:15:01 AM1/10/10
to
DOES ANY ONY HAVE THE FORMULA FOR CALCULATING MIN MAX LEVELS FOR INVENTORY
CONTROL

Rick Rothstein

unread,
Jan 10, 2010, 2:08:16 AM1/10/10
to
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).

--
Rick (MVP - Excel)


"PAR80" <PA...@discussions.microsoft.com> wrote in message
news:3938D204-0EB2-44A4...@microsoft.com...

cil

unread,
Jan 10, 2010, 9:49:05 AM1/10/10
to
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


"PAR80" <PA...@discussions.microsoft.com> wrote in message
news:3938D204-0EB2-44A4...@microsoft.com...

Herbert Seidenberg

unread,
Jan 10, 2010, 7:52:40 PM1/10/10
to
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
0 new messages