# Excel Formulas to convert Work Orders to BOQ needed from inventory

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:

Work Order

100 Packs of Product 1

120 Packs of Product 2

BOQ:

Product 1

20 KG of Material 1

10 KG of Material 2

Product 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)

Aptitudini: Procesare date, Excel, Matematică, Visual Basic

Despre angajator:
( 0 recenzii ) Cairo, Egypt

ID Proiect: #20043432

## 29 freelanceri licitează în medie 124\$ pentru acest proiect

asin1987

Dear Employer, I perfectly understand your job. On the basis of material to be used for every product you want to calculate the total quantity of each material. I have dine many such automation and will do a perfect j Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(164 recenzii)
7.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(302 recenzii)
7.2
dvcontact

Hi, Would you like to see a quick demo of your project on developing Excel spreadsheet that will inform you of what quantity to use for your inventory based on the products Work Order completed before you award the pro Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(49 recenzii)
6.3
wsh2

To do BOM/BOQ processing capably and efficiently, you really need a backend database, such as MsACCESS, to do so. The nice thing about MsACCESS is that it integrates seamlessly which then allows you to do 'ad hoc' MsEX Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(52 recenzii)
6.3
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(85 recenzii)
6.6
nvchien94

Hello there, I am an Excel expert with skill in advance formula and VBA script. I can create macro or formula depend on you. I also working in cost controller that I have experience in BOM, BOQ, Routing,.. so I can do Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(97 recenzii)
5.4
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I would like to provide my services for this project. I can develop an ex Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(106 recenzii)
5.5
imfarrukh47

hi there, I read your project description and I can do this for 75 USD in 2 days (i will try to do it in 1 day). I am an accounting student and I studied cost accounting and I know how costing works. I am also an exper Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(5 recenzii)
3.7

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(9 recenzii)
3.9
idicesolutions01

Hi, I have gone through your project post and definitely can provide solution as desired. Since we have developed various POS and ERP applications having similar functionality, hence I can provide you a quick solution Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(1 părere)
2.3
SammFletcher

Hi there! Nothing I love doing more than sinking my teeth into a good spreadsheet! Could you message me some more details; such as, do you already have a list of all the materials, in all the products? What format is Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(1 părere)
2.0
habalghost22

Hi , I am an MBA professional have 4yrs of experience in Analytics, advanced excel, vba and other programming languages. I would be happy to help you with your work. I will deliver the project at the earliest based on Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(2 recenzii)
1.8
AnowarRatul

\$ 30 ONLY !!!!! Sir, I understand your requirements very well. I have expertise in Excel, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will deliver your project within very short time and for VERY CHEA Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(4 recenzii)
1.3
xixdia

Hi, I am a logistic engineer from Denmark, with more than 15 years of experience with Excel. With my knowledge within logistic/supply chain I can deliver a professional result, . Let me have a look at it, so I can give Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)
0.9
venusbear

Hello, How are you? I've read carefully your job description. I have more than 3 years experience in VB, Excel, Mathematics parts. Your satisfaction with the project is my top priority! If you give me a chance to wor Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(1 părere)
1.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
Zulaykhaafam

I knw I have the potential to work under any organization & I'm diligent,self motivated & I'm ready to take any task to my experience. I will keep my punctuality & I will give my best performance Relevant Skills and E Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
deepakbri88

Hi I am new to freelancer. I am good in Excel and mathematics. Not to point out, but there is a mistake in the example quoted in the case of material 1. The quantity required should be 5600. This may prove my effi Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
halaidesigns

Hi to [contry] . LETS OPEN CHAT? I have 5 + years experience in this field. Please visit My profile and see the previous project's reviews, I am interested and ready to start, lets discuss with details. looking for Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)
0.0