AlfredoSalvatori is a SME of 20 men. Our business is to work marble and stones and is a very peculiar one! Nobody can predict how the stone will behave when cut and worked, so that there is no conventional BOM but it has to be calculated taking stock of all the past operations, creating a BOM tree.
Your duty will be to create a DataBase (Access, PHP...) that will get data (Items, consignement note etc) from ERP and will have a mask to read data input from the shopfloor men. With these data you have to create the BOM tree managing the costs at each node. Also for each item the DB will get care of the stock.
It is important that you have ability in creating and programming a DataBase and better if you have notions of BOM and supply chain management in general.
Eventually the entire SOW of the project will be given to you in a second time.