multiple item/product inventoy

**dworsham** · 04-03-2012, 11:35 AM

I am trying to develop a spreadsheet to track orders and keep inventory for my company which has several variations on a 'product'. I have looked around and know it is fairly simple to set up formulas that reflect when orders go out- inventory goes down and so forth, but have not seen anything that can solve my issue.

Basicly we have 5 items that can be combined in any way to make an end 'product', of which any number can be ordered. (same with the 5 items, they can be ordered individually as well.) I know there must be something that can help keep my inventory in order. any help is greatly appreciated! thanks in advance

**Fotis1991** · 04-03-2012, 11:37 AM

Hi

Would you like to share with us a small sample workbook?

**dworsham** · 04-03-2012, 11:54 AM

Ez-2-Go.xlsx

Pretty basic but this is all I have so far

**Fotis1991** · 04-03-2012, 12:28 PM

..I would like to offer you a solution, but i am not able at all(even from your sample) to understand, what are you looking for..

Sorry

**dworsham** · 04-03-2012, 01:10 PM

Ez-2-Go.xlsxSorry for the incomplete question, Ive added some information in the sheet that may be more clear. Thanks for your time.
I want to be able to put in the order information and have it reflect on the inventory totals.