Altair SLC minimizes cost when purchasing interchangeable parts from multiple companies lp programming
Too long to post on a list,see github
https://github.com/rogerjdeangelis/utl-altair-slc-minimize-cost-purchasing-interchangeable-parts-from-mutiple-companies-lp-programming
related repo (classic cattle feed problem)
https://github.com/rogerjdeangelis/utl-minimize-cost-of-cattle-feed-with-nutritional-requirements-and-multiple-food-sources-lp-program
PROBLEM
WHAT I NEED
I need to minimize the cost when purchasing the following
1,800 batteries
2,500 switches
2,000 motors
SUPPLIER COSTS
I have three suppliers who sell package deals of batteries, switches and motors
companies
wesco graybar ced
battery 11 20 33
switch 23 30 20
motor 32 20 15
==== ==== ====
Package Cost $200 $300 $400
Wesco sells a package with 11 batteries and 23 switches, and 32 motors for $200;
SOLUTION (Identify how I can purchase parts from multiple companies to reduce my overall cost)
Lowest cost 19 packages from Wesco, 62 packages from graybar, and 11 from ced for $26,800. (save over $3,000)
