Here is my situation. I have to buy a certain amount of specific products from one vendor and a certain amount of the same products from a different vendor based upon the sales we had in the previous month. The amount is percentage based btw.
So in any given month I have so far "eyeballed" it, but to be frank it's getting tedious and hard to keep an eye on as there are so many different products.
What I would like is a solution where the given percentages would be keyed in and then the spreadsheet would indicate to me which vendor I need to next buy product from and how much to stay within reasonable range of the set goals for that month.
I am not sure on what would be the best way to present this information though. Would it simply be by having a column that gives you how much you should purchase or having a more visually presentable solution via a graph or something like that?
So in a nutshell that's my question. What would be the best way to present the information.