Find Jobs
Hire Freelancers

Excel Formulas to convert Work Orders to BOQ needed from inventory

$30-250 USD

Geschlossen
Veröffentlicht vor fast 5 Jahren

$30-250 USD

Bezahlt bei Lieferung
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)
Projekt-ID: 20043432

Über das Projekt

27 Vorschläge
Remote Projekt
Aktiv vor 5 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
27 Freelancer bieten im Durchschnitt $125 USD für diesen Auftrag
Avatar des Nutzers
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 Tagen
5,0 (184 Bewertungen)
7,6
7,6
Avatar des Nutzers
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 Tagen
4,9 (320 Bewertungen)
7,3
7,3
Avatar des Nutzers
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 Tagen
4,9 (50 Bewertungen)
6,4
6,4
Avatar des Nutzers
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 Tag
5,0 (139 Bewertungen)
5,9
5,9
Avatar des Nutzers
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 Tagen
5,0 (120 Bewertungen)
5,7
5,7
Avatar des Nutzers
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 Tagen
4,9 (10 Bewertungen)
4,6
4,6
Avatar des Nutzers
$ 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 Tag
4,9 (35 Bewertungen)
4,1
4,1
Avatar des Nutzers
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 Tagen
4,5 (9 Bewertungen)
3,9
3,9
Avatar des Nutzers
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 Tagen
5,0 (4 Bewertungen)
2,3
2,3
Avatar des Nutzers
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 Tagen
5,0 (1 Bewertung)
2,1
2,1
Avatar des Nutzers
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 Tagen
5,0 (1 Bewertung)
2,0
2,0
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
0,9
0,9
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von EGYPT
Cairo, Egypt
0,0
0
Mitglied seit Juni 19, 2019

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.