Find Jobs
Hire Freelancers

Excel Formulas to convert Work Orders to BOQ needed from inventory

$30-250 USD

Closed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
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)
Project ID: 20043432

About the project

27 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
27 freelancers are bidding on average $125 USD for this job
User Avatar
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 job for you. Please message me, I am an expert. Please let me know if you feel any concerns. Please do check my previous reviews once!! Thanks an Regards, Ash
$150 USD in 7 days
5.0 (184 reviews)
7.6
7.6
User Avatar
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.
$100 USD in 2 days
4.9 (320 reviews)
7.3
7.3
User Avatar
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 project? You can consider it professionally done in less than 24 hrs. Before you award this project, I can complete a part of this project as a proof of concept. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
$150 USD in 2 days
4.9 (50 reviews)
6.4
6.4
User Avatar
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 this task for you in 20 mins. Please contact and I will start right now. Thanks.
$30 USD in 1 day
5.0 (139 reviews)
5.9
5.9
User Avatar
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 excel sheet for you which will maintain all your orders and provide the required quantities of materials as per the formula provided by you. The spreadsheet will be completely dynamic so you can easily change any calculation or anything as needed. I look forward to a positive and prompt response from your side. Regards Sourabh
$59 USD in 2 days
5.0 (120 reviews)
5.7
5.7
User Avatar
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 expert in excel advance formulas and I can create complex formulas in excel. Can you share further details with me in the inbox? If you need a sample inbox me i wil send you a sample as well I am waiting for your response Thankyou
$75 USD in 2 days
4.9 (10 reviews)
4.6
4.6
User Avatar
$ 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 CHEAP rate. Please CONTACT me before closing the project, I will send you a draft project file to ensure my expertise. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
$30 USD in 1 day
4.9 (35 reviews)
4.1
4.1
User Avatar
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.
$50 USD in 2 days
4.5 (9 reviews)
3.9
3.9
User Avatar
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 the requirements you give me. Looking forward to work with you. Cheers.
$30 USD in 2 days
5.0 (4 reviews)
2.3
2.3
User Avatar
Hi, I am senior full stack developer. Test me in chat. “Heart B has more than 4 years experiment in office. If you award him, you will be happy with his wonderful coding technology. Actually he will satisfy your requirement.” This is a message given by my first freelancing employer. Give me your message.
$100 USD in 7 days
5.0 (1 review)
2.1
2.1
User Avatar
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 this data in currently? How many different products are there initially? I'd be more than happy to sort this for you, just drop me a message with some more details and we can discuss! Kind regards Samm
$100 USD in 2 days
5.0 (1 review)
2.0
2.0
User Avatar
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 you a correct timeframe and price.
$100 USD in 1 day
5.0 (1 review)
0.9
0.9
User Avatar
i would like to work on your project please provide me the job I will give my 100% hardwork and dedication
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 forward to hear from you soon. Thanks & Regards
$187 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have much experience in doing projects related to data entry, excel, word and many other tools. I can do your project within timeline according to your satisfaction. I appreciate you if you give me a chance to work with you.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have expert crew in spread sheet software as well as preparing boqq. i can complete your job as you want an
$77 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, I am both a CPA and an automation lover. I could deliver this quickly within 1 day after your confirmation. Also, if you hire my expertise, I am willing to work with you for another automation project -- at NO COST. It's a bonus :) Warmly, Adrian
$200 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm very good at Excel and I'll be able to write a code that will make to do the task in a efficient way .I can deliver it as soon I could.
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
For my great experience in cost accounting and warehouse inventory of the nature of my work as a legal accountant and currently a financial manager I can make it easier for you this process in the best time and very well like you For my great experience in cost accounting and warehouse inventory of the nature of my work as a legal accountant and currently a financial manager I can make it easier for you this process in the best time and very well like youFor my great experience in cost accounting and warehouse inventory of the nature of my work as a legal accountant and currently a financial manager I can make it easier for you this process in the best time and very well like youFor my great experience in cost accounting and warehouse inventory of the nature of my work as a legal accountant and currently a financial manager I can make it easier for you this process in the best time and very well like youFor my great experience in cost accounting and warehouse inventory of the nature of my work as a legal accountant and currently a financial manager I can make it easier for you this process in the best time and very well like youFor my great experience in cost accounting and warehouse inventory of the nature of my work as a legal accountant and currently a financial manager I can make it easier for you this process in the best time and very well like youFor my great experience in cost accounting and warehouse inventory of the nature of my work as a legal accountant and current
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i can do it. 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.
$140 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of EGYPT
Cairo, Egypt
0.0
0
Member since Jun 19, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.