We sell sound system kits. Every kit has a master unit, speaker, wire and mounting bracket. The only difference between kits is the quantity of each component. For example, a system that will cover 250 sq/ft will have 1 master, 1 speaker, 1 wire, and 1 bracket. A system that will cover 500 sq/ft will have 1 master, 2 speakers, 2 wires, and 2 brackets. We sell systems that cover over 10,000 sq ft.

I want to make a composite item for every kit we sell. This way my sales guys can just enter the appropriate composite item.

This will require hundreds of composite items. Other than cloning the first composite item and then changing quantities by hand (which will take hundreds of hours) is there a way to automate this or make a macro that will create these composite items?