In Progress

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)

output:

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.

Summary:

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,

Jim

Skills: Algorithm, Coding, Excel, Mathematics, Programming

See more: software write mq4, software write chip epson, useful software write book, 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, free software write book, software write book, bill quantity electrical design using autocad, bill materials revit, optimization machining parameter using finite element, structural bill materials spreadsheet, monthly bill payment software using vbnet

About the Employer:
( 2 reviews ) Newbury Park, United States

Project ID: #11721664

Awarded to:

wesen

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 More

$222 USD in 3 days
(0 Reviews)
0.0

18 freelancers are bidding on average $187 for this job

cugamelover

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 More

$300 USD in 5 days
(222 Reviews)
7.1
shikhamehta

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 More

$500 USD in 10 days
(87 Reviews)
6.2
Venkylancing

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 More

$35 USD in 3 days
(127 Reviews)
6.3
$200 USD in 3 days
(48 Reviews)
5.6
katilinas

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 in 3 days
(71 Reviews)
5.4
SheikhNawaz

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 in 3 days
(3 Reviews)
3.8
kmande

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 More

$120 USD in 7 days
(7 Reviews)
3.7
sahinbudak

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 More

$250 USD in 3 days
(1 Review)
1.0
weirong626

Hello, Dear friend. I am expert in matlab, physics, math,... I have a lot of experiences in many fields. I can help you well. Please contact me. Best regards.

$155 USD in 3 days
(1 Review)
0.4
AnnuSingh89691

A proposal has not yet been provided

$35 USD in 3 days
(0 Reviews)
0.0
liviaphillips

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 in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
ranabilalraza786

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

$155 USD in 3 days
(0 Reviews)
0.0
widebeamint

A proposal has not yet been provided

$133 USD in 5 days
(0 Reviews)
0.0
tukituko

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 More

$194 USD in 3 days
(1 Review)
0.0
Vacs1980

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 More

$184 USD in 4 days
(0 Reviews)
0.0
swagatsarma

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 More

$155 USD in 3 days
(0 Reviews)
0.0
mdavidson01

Hi i have a working bill of materials system that seems to do what you need if you are interested the website is www.davcomm.co.za:8088 the username and password are demo. if you would like to have a look and let me kn More

$155 USD in 3 days
(0 Reviews)
0.0