Find Jobs
Hire Freelancers

Create/Re-design RFQ Request Database

$30-250 USD

Zavřený
Zveřejněno skoro před 5 roky

$30-250 USD

Zaplaceno při doručení
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.
IČ projektu: 19642881

O projektu

10 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
10 freelanceři nabízejí v průměru $202 USD za tuto práci
Avatar uživatele
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 v 7 dnech
4,9 (388 recenze)
8,1
8,1
Avatar uživatele
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 v 7 dnech
4,7 (84 recenze)
6,7
6,7
Avatar uživatele
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 v 3 dnech
4,9 (42 recenze)
5,7
5,7
Avatar uživatele
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 v 3 dnech
4,0 (22 recenze)
5,4
5,4
Avatar uživatele
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 v 3 dnech
5,0 (1 recenze)
4,0
4,0
Avatar uživatele
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 v 5 dnech
4,9 (28 recenze)
4,1
4,1
Avatar uživatele
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 v 2 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED STATES
Sugar Land, United States
0,0
0
Členem od kvě 17, 2019

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.