Manufacturing Process Optimization

Problem: Customizable lights systems is the main line of business, yet figuring out invoices for customer requests has unexpected exceptions and is a labor intensive process prone to errors. Additionally, because of manufacturing formula complexity, managing pre-assembled components stock proves to be impossible.
Input: Real-time user input from e-commerce website in a form of CSV options list. Inventory list of partially-assembled components. HyperC project with manufacturing process formula allowing disassembly and reassembly of components.