Bill of Materials purchasing optimization (using Octopart APIs)

Like many people, I periodically need to purchase components for a somewhat lengthy bill of materials for board production. Figuring out where to buy what without mistakes can be a somewhat stressful task. Octopart is a very useful search engine and data source for electronic components purchasing. They provide APIs which can call vendor and quantity specific price, inventory, and minimum order quantity. Almost always more than one vendor is needed to overcome shortages in inventory and fulfill the entire order. The more vendors you use, the lower the potential total purchasing cost for the project. However there are diminishing returns as the number of vendors increases. At some point its not worth dealing with the extra paperwork so identifying the ideal combination and number of vendors is of great interest. I've previously written a spreadsheet to manually select vendors based on on case by case decision making given stock levels and prices. The problem with that approach is that restricting the number of vendors as you go is problematic.

Based on this need I'd like an excel spreadsheet that calls Octopart APIs to optimally populate vendor choice for each part based on availability and lowest cost for a given number of vendors. This will allow me to increment the vendor quantity to get a feel for the most desirable course of action.

For example:

input: max 3 vendors allowed (of variable ~10+ options)


1: vendor list for minimum cost

2: vendor assignment for each part

The challenge is that the minimum cost combination of those 3 vendors must be found. In the example above there are 120 combinations of 3 vendors given a choice of ten. (combinations) Each part has a different number of vendors that stock it and vendors are often out of stock.


Develop an algorithm that handles the intent of these requirement including relevant exceptions, error handling and logic. Programming approaches other than excel are welcome if you believe they are more suited or you are more comfortable with them. The results should be formatted for easy output review and exportable as a CSV for purchasing. Please mention alternate approach if known ahead of time in your quote. Looking forward to working with you. Thanks!

Best regards,


Keahlian: Algoritma, Coding, Excel, Matematika, Programming

Lihat lebih lanjut: software write mq4, software write chip epson, useful software write book, c# programming, excel, software write web specs, full duplex audio player using waveinwaveout apis, twitter apis using aspnet, free software write user guide, software write edid, free software write company profile, access production plans bill materials, software write websites idea, structural steel bill materials, developed bill issuance system using visual basic language, software write book images, using excel sort phone bill, software write books, program using apis, software write protection

Tentang Pemberi kerja:
( 2 ulasan ) Newbury Park, United States

ID Proyek: #11721664

Diberikan kepada:


Solid software engineer with 17+ experience, I write clean, fast and beautiful code. Quick delivery guaranteed. I work in consumer product manufacturing and used to run a small electronics business, so I am well acquai Lebih banyak

$222 USD dalam 3 hari
(1 Ulasan)

17 freelancer menawar dengan rata-rata $189 untuk pekerjaan ini


I can do exactly what you need. I think that a code in Excel VBA will do the trick just fine, I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing Lebih banyak

$300 USD dalam 5 hari
(273 Ulasan)

HI there, i am component engineer as well sourcing specialist, i am not applying for this job but if you have any queries related to components, sourcing please contact me. 1. i own silicon expert tool for bom Lebih banyak

$35 USD dalam 3 hari
(137 Ulasan)

Hello Jim, I represent Automyze Consulting and we take up lot of process automation and optimization projects like yours. Your requirement of optimizing the BOM purchase decision can be accomplished in more than one Lebih banyak

$500 USD dalam 10 hari
(88 Ulasan)
$200 USD dalam 3 hari
(59 Ulasan)

Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$210 USD dalam 3 hari
(93 Ulasan)

Hello Jim!!! A really nice project. I am MBA Finance graduate with undergraduate degree in Production Engineering.I also have couple of years of work experience as a Software Engineer with one of the premi Lebih banyak

$120 USD dalam 7 hari
(10 Ulasan)

Hi, I am ready to start your project..I would use VBA for this purpose & I am sure you would be happy after getting your project files....

$300 USD dalam 3 hari
(3 Ulasan)

Hello, I am an excel master. I have worked on VBA macro building upon the data populating from an API. Here the problem as you mentioned is to decide the scenario. So there are 3 steps of this work. 1. I will Lebih banyak

$250 USD dalam 3 hari
(3 Ulasan)

i have done bill of material work ealier so that im interested in it , i would like to know furture details.

$155 USD dalam 3 hari
(0 Ulasan)

Project plan: 1) Understanding the vendor data and input parameters (in case we have cases where a particular vendor provides multiple parts, or aggregation in a particular vendor will have lower overall costs) 2) Es Lebih banyak

$155 USD dalam 3 hari
(0 Ulasan)

I offer my whole focus and concentration in the fulfillment of the project, do it in the required period of time and quality, exceeding the expectations of my clients. Proven Experience in all the supply chain process Lebih banyak

$184 USD dalam 4 hari
(0 Ulasan)

Hi, i'm an experienced php developer. I can do your project i've built several crm/hr/inventory/sales/expense platforms and REST api using api keys/oauth2 for authentication. Let me know if interested i'm available on Lebih banyak

$194 USD dalam 3 hari
(1 Ulasan)

A proposal has not yet been provided

$133 USD dalam 5 hari
(0 Ulasan)

I believe I am a great fit for this project. I have worked in IT for most of my life. Therefore, I am very confident in my Excel and programming skills.

$66 USD dalam 3 hari
(0 Ulasan)

A proposal has not yet been provided

$35 USD dalam 3 hari
(0 Ulasan)

Hi i have a working bill of materials system that seems to do what you need if you are interested the website is [login to view URL] the username and password are demo. if you would like to have a look and let me kn Lebih banyak

$155 USD dalam 3 hari
(0 Ulasan)