Results 1 to 10 of 10

Math Help - linear programming help! please!

  1. #1
    Newbie
    Joined
    May 2014
    From
    United States
    Posts
    6

    linear programming help! please!

    o I'm working on this problem for my Econ class, but it's so difficult. Hopefully someone can give me a few pointers as too where to start.

    A manager of an automobile dealership must decide how many cars to order for the new model year in order to maximize his profit. There are two types of cars: midsize cars and compact cars. The selling price and costs are listed in the following table:

    Car type -- Selling price -- Cost

    Midsize -- $25,000 -- $18,178

    Compact -- $18,000 -- $12,000



    No more than $740,000 can be invested. The manager wants at least 10 of each type, but no more than 50 of the midsize cars and no more than 60 of the compact cars. (The manager assumes that as long as he meets these quantity limits, he will be able to sell all the cars that he orders.)

    1.Formulate a linear programming model for this problem. That is, write out an algebraic statement of the model.
    2.Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution and resulting profit?
    3.The selling price of the midsize car might be as low as $22,000 or as high as $27,000. How does your solution found in #2 change with these prices?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Prove It's Avatar
    Joined
    Aug 2008
    Posts
    11,548
    Thanks
    1418

    Re: linear programming help! please!

    Can you at least set up the objective function?
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    May 2014
    From
    United States
    Posts
    6

    Re: linear programming help! please!

    18178x + 12000y <= 790000
    x>=10
    x<=50
    y>=10
    Y<=60
    x,y>=0

    I don't know how to set up the formula for the excel.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    MHF Contributor
    Prove It's Avatar
    Joined
    Aug 2008
    Posts
    11,548
    Thanks
    1418

    Re: linear programming help! please!

    I agree with your constraints. But what is the objective function?
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    May 2014
    From
    United States
    Posts
    6

    Re: linear programming help! please!

    max: z = (25000 - 18178)x + (18000 - 12000)y
    = 6822x+6000y
    Follow Math Help Forum on Facebook and Google+

  6. #6
    MHF Contributor
    Prove It's Avatar
    Joined
    Aug 2008
    Posts
    11,548
    Thanks
    1418

    Re: linear programming help! please!

    OK great. I also just saw a mistake in one of your constraints. Remember that you can only invest $740 000, not 790 000.
    Follow Math Help Forum on Facebook and Google+

  7. #7
    Newbie
    Joined
    May 2014
    From
    United States
    Posts
    6

    Re: linear programming help! please!

    linear programming help! please!-qq-20140512221006.jpg I don't know how to do the Constraints in the Excel. Can you teach me to set up the formula and the equation?
    Follow Math Help Forum on Facebook and Google+

  8. #8
    Newbie
    Joined
    May 2014
    From
    United States
    Posts
    6

    Re: linear programming help! please!

    sorry, my bad. Wrong typing.
    Follow Math Help Forum on Facebook and Google+

  9. #9
    MHF Contributor
    Prove It's Avatar
    Joined
    Aug 2008
    Posts
    11,548
    Thanks
    1418
    Follow Math Help Forum on Facebook and Google+

  10. #10
    Newbie
    Joined
    May 2014
    From
    United States
    Posts
    6

    Re: linear programming help! please!

    I know those, but I spent a whole day to figure out the equations and those equations didn't work.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Linear Algebra- Geometric Linear Programming
    Posted in the Advanced Algebra Forum
    Replies: 3
    Last Post: April 25th 2013, 03:56 PM
  2. Linear Programming
    Posted in the Algebra Forum
    Replies: 1
    Last Post: November 6th 2010, 12:35 PM
  3. Replies: 1
    Last Post: November 17th 2008, 03:18 AM
  4. Linear programming!!
    Posted in the Pre-Calculus Forum
    Replies: 0
    Last Post: October 31st 2007, 04:43 AM
  5. Linear Programming Help Please?
    Posted in the Pre-Calculus Forum
    Replies: 3
    Last Post: September 9th 2007, 06:47 AM

Search Tags


/mathhelpforum @mathhelpforum