Em Andamento

Quoting project - using API tools -- 2

Material Availability and Analysis: Create utility using SQL DB with the below activities:

• Available API interface from Suppliers, about 4 different APIs – Digikey, Arrow, Future, TTI

• Quoting Interface: Assign an auto quote number for a product number. This product number is to be kept for keeping up with the quote history and date quoted

• Perform Material quote and Labor quote

• Import the BOM file containing: MFG Part number, QEMS Part number, qty per BOM, Quantity1, Quantity2, other quantities, Item Number, and some other columns for record tracking

o Material quote: Utility to read each part number listed in the BOM file and return the below information from each supplier

• Price matched with the qty listed. QEMS has special pricing provided by each supplier with our login info. Need the special pricing to be listed

• Any minimum order requirement from Suppliers

• Lead time

• Link to datasheet

• Status: Obsolete, End of Life, Active….

• Packaging: Cut tape, Reel, Digikey reel, Arrow reel

• On order information

• Technical specs: Size, temp range….

• Utility to present the matrix for user to select which supplier for each part number

• Provide calculation of BOM cost: Qty per BOM*Unit price

o Labor quote: Read each part number (as above), primarily on Packaging, Size and assign identified process, tooling cost, time – QEMS to provide the detailed list

• User will review the Material cost, Labor cost and assign the Final cost

• Using built in Quote Submission template to plug in the Final cost and export to submit to customer

• Report:

o Be able to view history quote by product number: showing submitted date, Final cost, qty, material quote cost, Labor cost

o Be able to view changes and cost by product number: if the import of the same product number having changes in component part numbers or qty, identify the changes and provide changes in Material quote cost and Labor quote cost (hours)

Habilidades: SQL, API

Sobre o Cliente:
( 0 comentários ) Rock Hill, United States

ID do Projeto: #28575110

Concedido a:

(40 Comentários)
6.6

5 freelancers estão ofertando em média $960 nesse trabalho

Zohaib748

Hello Dear...! Alert: I will give you 20% discount on my bid rate also give on my All Services. So grabs this special offer is limited. Let’s get to the point. I came to know that your Looking a developer which hav Mais

$900 USD em 1 dia
(25 Comentários)
5.7
vut4l1

Hello Sir,I am professional SQL developer with having more than 4 year's experience in this field also I have read your project description and I am interested in it Can we discuss more ? when do you need it until? - Mais

$950 USD in 7 dias
(2 Comentários)
2.6
FabioFelgueiras

Hi, im a full stack developer ready to start working on your project. If i understand correctly you want a web interface for this correct?

$1000 USD in 20 dias
(1 Comentário)
1.1
saadtariq329

Hi There, I just have visual your project and after reviewing your description I’m confident that I can do it and will set standard for you to come back in future. For now, I need your Collaboration in chat box for bri Mais

$950 USD in 7 dias
(0 Comentários)
0.0