Help identifying inventory

[brian60629]

Take this file and use a formula to determine which parts we have over 2 months QOH. In the next column, identify the parts that have over 2 months QOH if all the QOO arrived today.

I am a little rusty and need to figure out formulas to accomplish the above mentioned tasks.

[humdingaling]

i took sold YTD as your monthly sales

Please Login or Register  to view this content.

if SOLD YTD is not...you will need to work out monthly sales somehow to determine if you have 2 months stock coverage