I believe this is a linear algebra problem, but if not please let me know:
Say you have 4 suppliers. You want to order 4 different items. The 4 suppliers each have a different price for each item and charge shipping but only for orders under a given amount. How do you decide what to order from each supplier to get the lowest total cost including shipping?
Here is a Table of Sample Data. I need to buy all 4 items. I don't have to buy all the supplies from a single supplier.
Supplier A Supplier B Supplier C Supplier D Item 1 $30 $40 $50 $60 Item 2 $40 $50 $60 $35 Item 3 $45 $60 $60 $65 Item 4 $90 $55 $35 $45 Shipping $25 $20 $15 $10 Each Supplier offers free shipping for orders over $100
I tried each option and found a solution, but I'd like a way for a computer to answer the question so I can scale this to many items and many suppliers.