Creating an inventory worksheet

[Guest]

I am creating an inventory worksheet that will fluctuate evey day. I
manufacture kits and out of these kits are a given number of parts and labels
per type of kit. How can I make the worksheet show the losses and gains?
example kit 2901 takes 1 pail label, 1 part 1,2 and 3 label 1 bottle and 2
bladders as well as 2.5 gal of fluid in 1 bladder and 2.5 gal in another and
4 oz of fluid in the bottle. Ea. day i make more kits and put them on the
shelves also each day i shipp some. What besides entering ea Item seperately
can i do? Can this be done in excel?

 

[Guest]

Take a look at:

http://office.microsoft.com/en-us/templates/TC060878721033.aspx