How to calculate and present information

thirtywinter
thirtywinter used Ask the Experts™
on
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.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Application Developer
Commented:
You could set it up in a column and have conditional formatting to format the cells that are below the percentage you are looking for.  This way, you'll have immediate visual on the products/vendors that need attention.

Author

Commented:
That seems like the best solution.

Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial