I work for processed food factory and I want an excel sheet that has BOM and BOQ of all my products and based on the Products Work Order the excel sheet should inform me about the quantities i will use from my inventory.
The excel sheet should be flexible so that I can change the BOM at any time.
Below is an example:
100 Packs of Product 1
120 Packs of Product 2
20 KG of Material 1
10 KG of Material 2
30 KG of Material 1
5 KG of Material 2
6 KG of Material 3
Based on the Previous I would need the excel sheet to show me that I need to use the following quantities:
Material 1: 5000 KG (100*20)+(100*30)
Material 2: 1800 KG (120*10)+( 120*5)
Material 3: 720 KG (120*6)
28 freelancers are bidding on average $128 for this job
Hello dear, I am a M.Sc. Civil engineer. I am expert in Bill of quantities using Excel so I can help you for sure in your task and I will finish it in the required time. Thanks.