[quote='joeu2004[_2_];1601597']<tippytoe wrote:
USG - stands for usage I assume
Columns I need explained a
M (Usg% Inc/Dec) what is being calculated in the formula
=IF((F2=0),((((H2*12)/I2)-F2)/1),(((H2*2)-F2)/F2))
N (New Inv Min) how and what is being calculated to come up with this #
=SUM((((K2/365)*12)*J2))*L2
O (New Inv Max) how and what is being calculated to come up with this #
=ROUNDUP(((N2*2)+0.1),0)

Since you are just learning Excel yourself, I would like to point that these
are good examples of how __not__ to write formulas.
1. Needless use of parentheses makes the formulas difficult to read.
2. SUM in this context is completely useless and unnecessary.
3. Division by 1 is just plain silly.
4. Subtract F2 from H2*12/I2 is also silly since we know F2 is zero.

This is probably the best excel lesson I've ever had. Your information was not only informative but easy to read and understand. Thank you very much for your response and patience with my ignorance towards excel. i appreciate the time you took to explain this information as well as the thoroughness.

If there is anyone else that has input who may have inventory or forcasting skills or experience, please advise on this subject as well.

Thank you tremedously.