Find Jobs
Hire Freelancers

Excel Formulas to convert Work Orders to BOQ needed from inventory

$30-250 USD

已关闭
已发布将近 5 年前

$30-250 USD

货到付款
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)
项目 ID: 20043432

关于此项目

27提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
27威客以平均价$125 USD来参与此工作竞价
用户头像
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 在7天之内
5.0 (184条评论)
7.6
7.6
用户头像
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 在2天之内
4.9 (320条评论)
7.3
7.3
用户头像
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 在2天之内
4.9 (50条评论)
6.4
6.4
用户头像
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 在1天之内
5.0 (139条评论)
5.9
5.9
用户头像
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 在2天之内
5.0 (120条评论)
5.7
5.7
用户头像
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 在2天之内
4.9 (10条评论)
4.6
4.6
用户头像
$ 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 在1天之内
4.9 (35条评论)
4.1
4.1
用户头像
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 在2天之内
4.5 (9条评论)
3.9
3.9
用户头像
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 在2天之内
5.0 (4条评论)
2.3
2.3
用户头像
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 在7天之内
5.0 (1条评论)
2.1
2.1
用户头像
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 在2天之内
5.0 (1条评论)
2.0
2.0
用户头像
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 在1天之内
5.0 (1条评论)
0.9
0.9
用户头像
i would like to work on your project please provide me the job I will give my 100% hardwork and dedication
$155 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
i have expert crew in spread sheet software as well as preparing boqq. i can complete your job as you want an
$77 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在5天之内
0.0 (0条评论)
0.0
0.0

关于客户

EGYPT的国旗
Cairo, Egypt
0.0
0
会员自6月 19, 2019起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。