Calculating and posting when a qty will go negative.

G

Gene Haines

Hello All: I have column headings for the month's of the year and row
headings are item #'s. In the row/column field I have forcasted qty's
that will be ordered by customers for that particluar item for that
month on out through the next 6 months of the year. The last column is
total item qty available on hand. If the total qty that will ordered
over the 6 months is greater than the total item qty available on hand,
obviously I need to purchase more. However, how can I determine and
display, thru a formula, what month the total item remaining available
qty on hand will run out or go negative.

Thanks for any help

Regards

Gene
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Basing math on duplicate entries in a formula 1
Add values based on text color with the criteria of a date 7
Check Date Range and Multiply Stock Qty 2
calculating value in a query 1
Subtotals in a Pivot Table 1
IF Then statement or another function to look for a value 2
Data Entry Confusion 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1

Top