Find Jobs
Hire Freelancers

Create/Re-design RFQ Request Database

$30-250 USD

Imefungwa
Imechapishwa almost 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
I'm not familiar with SQL so I don't know if SQL or Excel would be the best for what I need so please suggest one or the other or a combo of the two. Whatever you think my best option is. I am trying to recreate a excel workbook created to select the best supplier based on price for up to 150 items but enhance it to also expedite the initial quoting process. I've detailed out generally how I want the flow to go below. 1) Enter product description/Product Material/Quantity/Unit of Measurement (UOM)on "Bid Details Sheet" 2) That data auto fills into "US Suppliers Sheet", "Sterling Suppliers Sheet", & "Euro Suppliers Sheet (Need to add this sheet still)" 3) In some way/shape/form, I need a list of suppliers from the sourcing workbook/sheet to contact based on Product/Material for each item. This would be presented on the Summary Sheet and contacts should be sorted based on Product / Material that they supply. (That info is found on sourcing tab) 4) An additional desire is that I would like to use this workbook to mail merge my emails to the listed contacts. The best way I can think to say it is that I would like to have the data display what item #'s (Bid Details Sheet Column A) to send to what suppliers. However this needs to work. 5) Fast forward - emails sent out and suppliers have submitted quotes. I add prices to US/Sterling Sheet based on where they are located and it updates Bid Details Sheet. 6) On bid details sheet, cheapest option is presented in blue columns. It shows cheapest "per unit" pricing with "item" and Supplier column filling with matching information respectively. I would also like to have a "markup" column added between columns S and T on Bid details sheet and two additional columns added to the right of that detailing the "unit" and "Item" cost with markup. 7) The summary page should detail and highlight overall job/product cost, the overall marked up cost, the profit margin %, and the profit. The most important detail is that I would like this work book / database to allow be to submit requests for quotes to suppliers much faster and allow me to accurately forecast the financials. It is important to note that the attached "Sourcing Tool" is a work in progress supplier wise so this project should allow for additional suppliers to be added to that list and the products they offer be updated without causing errors. I've uploaded my current work-in-progress so please look it over and let me know what you can do for me.
Kitambulisho cha mradi: 19642881

Kuhusu mradi

10 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
10 wafanyakazi huru wana zabuni kwa wastani $202 USD kwa kazi hii
Picha ya Mtumiaji
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD ndani ya siku 7
4.9 (388 hakiki)
8.1
8.1
Picha ya Mtumiaji
Hi, nice to meet you. I have read your post and check 2 excel files too. I think it need to convert excel into relational database. This is main key to solve issues and let it easy. Then don't worry to query database because i am sql expert. Please contact with me for more detail. Thank you.
$250 USD ndani ya siku 7
4.7 (84 hakiki)
6.7
6.7
Picha ya Mtumiaji
I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, financial analysis, advanced excel, VBA/Macro automation and data processing. I have previously worked for many reputed companies like E&Y, EXL Services, and CRISIL Ratings, I have successfully completed similar projects. Please have a look at my portfolio for more details. I have developed financial models and tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you Please feel free to contact me in case of any query
$250 USD ndani ya siku 3
4.9 (42 hakiki)
5.7
5.7
Picha ya Mtumiaji
Hi, How are you? I am interested in taking up your project. I recommend sql. I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I never give up, constantly learn, easy communication. I deliver fast, clean and quality work that meets your expectation and is well within your budget. Willing to work within specified deadlines and time. Thanks. Regards from A.G
$140 USD ndani ya siku 3
4.0 (22 hakiki)
5.4
5.4
Picha ya Mtumiaji
Hi, I read your project requirement carefully and I understand your project but I want to ask a few questions before mover further so that I can deliver you exact work with one shoot. I always deliver quality with one shoot and you can check my profile and I had 6-year experience. Please come over chat for further detailed discussion to start working on it. Thanks
$555 USD ndani ya siku 3
5.0 (1 hakiki)
4.0
4.0
Picha ya Mtumiaji
Hi There, I am interested to your project. I am an Excel expert and have a great eperiences in excel automation with formulas and vba since my first career 15 years ago. I assured that you will get high quality / high accuracy / high turn around service with best price. I have read your project desc and check the excel file attached and understand your need. I can linkup and automate the entire processes thru excel formulas and vba. Please contact me to discuss further details. Thank you. Best Regards,
$200 USD ndani ya siku 5
4.9 (28 hakiki)
4.1
4.1
Picha ya Mtumiaji
Dear sir, i'm oracle certified OCA&OCB as i have a good experience in oracle database projects and SQL and database tools thanks Asmaa
$50 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Sugar Land, United States
0.0
0
Mwanachama tangu Mei 17, 2019

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.