Results 1 to 2 of 2

Math Help - How i can get overall low cost

  1. #1
    Newbie
    Joined
    Nov 2009
    Posts
    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.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Dec 2009
    Posts
    9
    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.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Process cost systems,total cost under the FIFO Method.
    Posted in the Business Math Forum
    Replies: 0
    Last Post: December 4th 2009, 11:13 PM
  2. Marginal Cost/Demand and Cost
    Posted in the Calculus Forum
    Replies: 4
    Last Post: November 4th 2009, 06:45 PM
  3. marginal cost/revenue to total cost / revenue
    Posted in the Advanced Math Topics Forum
    Replies: 1
    Last Post: May 9th 2009, 11:41 AM
  4. How much will it cost?
    Posted in the Trigonometry Forum
    Replies: 1
    Last Post: February 17th 2009, 07:09 PM
  5. Cost of a Can
    Posted in the Algebra Forum
    Replies: 1
    Last Post: November 7th 2008, 09:09 AM

Search Tags


/mathhelpforum @mathhelpforum