# Thread: How i can get overall low cost

1. ## How i can get overall low cost

Dear Experts

I have a problem in developing a business software.

I have three database tables (1.Material 2. Suppliers 3. OFFERS ) OFFERS table contains different offers of suppliers for different materials like given below.

OfferID Quantity UnitPrice DelTime Supplier Material
1........ 1.......... 99........ 5......... A ........Chair
2........ 3 ......... 90........ 5......... A ........Chair
3 ........5.......... 80........ 5......... A ........Chair
4 ........1.......... 95........ 5......... B ........Chair
5 ........1.......... 90........ 5......... C ........Chair
6 ........3.......... 85........ 5......... C ........Chair
7 ........10........ 80........ 5......... C ........Chair

I want to get the supplier with overall lowest price for 14 Chairs.

i.e the Demand is:
Material: Chairs
order Quanity: 14

The paper work for overall lowest price which differents suppliers offer are given as

1)
Cost for Supplier A:
10 x 80= 800 (As by offer 3)
3 x 90= 270 (As by offer 2)
1 x 99= 99 (By offer 1)
Overall Cost for supplier A is: 1169

2)
Cost for Supplier B:
14 x 95= 1330 (By offer 4)
Overall Cost for supplier B is: 1330

3)
Cost for Supplier c:
10 x 80= 800 (by offer 5)
3 x 85= 255 (by offer 6)
1 x 90= 90 ( offer 1)
Overall Cost for supplier C is: 1145

In this example Supplier C offers minimum cost for 14 chairs.

Please tell me that how mathematics help me in this regard and to which mathematic topic this problem belongs to.

Best Ragards.

2. Dear,

Before we can give you a reasonable answer, we might want a bit more background on your problem:

What is the purpose of your question? Do you want to write a piece of software which you give as input the quantity and the product type, and as a result you want to obtain the best offers?

If you want to solve the problem you describe, you should look into the subject of Linear programming. Note however that I would categorize this as computer science and not as math. Have a look at this topic: http://www.mathhelpforum.com/math-he...g-problem.html
In this topic, a very similar question is asked.

But than again, it all depends on what you want to learn/achieve.