Calculating and posting when a qty will go negative.
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
Last edited by Gene Haines : November 5th 07 at 07:03 PM
|