Forecasting in table- easily update & pivot capability

Hello all-

I am building a new sales forecasting/goal setting spreadsheet. We have about 50 products (UPC's) we manufacture, we currently sell our products to six (6) distributors, and forecast our sales over 18 months. Our business is growing, which means we will add new products and add additional distributors. Every distributor has different monthly sales forecasts. I want to build the sales forecasting spreadsheet so it is easy to add both product and new distributors. Since all products are available to all distributors, if we add one product, I need that product available for forecasting to all distributors. The most ideal set up is to have all UPC’s, Distributors, and months on one table. This makes it easy for us to sort our data, utilize pivot tables, etc.

Does anyone have any thoughts on how to do this?

Thanks-a-million in advance!

CW

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

A good way to think about titles:

If you are trying to find the solution on Google before posting your own thread, use what you entered into the google search as your title. In other words, use a title that someone with a similar problem might try to google search. The reason the title is Rule 1 on this forum is because if titles were all as the Mod's examples state (plz help, formula help, need help, and so on) the site would be fairly useless to anyone else who has the same problem, because no one would ever find it. "IF function question" however is much more specific, and easily searchable.

The current title is vague in that it can relate to multiple possible solutions, such as matching based on multiple criteria, when the actual problem seems more like a forecasting/design/pivot related question

Hope this makes sense.