Please help me with this!

Hi All,   I am a manufacturer of 50+ products and each product requires multiple/different raw materials to manufacture. I need to automate the below: 1. When a new order is received and entered i...