Results 1 to 2 of 2

Math Help - Programming Question with Excel and Solver

  1. #1
    Member
    Joined
    Nov 2008
    Posts
    152

    Programming Question with Excel and Solver

    A cabinet shop produces and installs cabinets. Business is good, and the shop has an unlimited number of customers willing to pay $100 for each cabinet installed. However, for the next month, the shop has only 1750 hrs. of labor and 1032 units of wood that it can commit for cabinet production. Each installed cabinet requires 5 hrs. of labor, 3 units of wood, and one frame. The frames can be prepared in the shop before installation, with each frame requiring 2 hr. of the shop's labor and 1 unit of its wood, or they can be bought ready for installation from the local mill for $27 each. The shop pays $6/hr. for labor, $5/unit for wood, and only pays for the labor and wood used. For the next month, how many cabinets should the shop install, and how should the necessary frames be generated so that net income is maximized?

    I need help figuring out how to set up a table that sets up the problem. I can figure out the Excel stuff, I'm just confused as to how to set up the problem.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by Janu42 View Post
    A cabinet shop produces and installs cabinets. Business is good, and the shop has an unlimited number of customers willing to pay $100 for each cabinet installed. However, for the next month, the shop has only 1750 hrs. of labor and 1032 units of wood that it can commit for cabinet production. Each installed cabinet requires 5 hrs. of labor, 3 units of wood, and one frame. The frames can be prepared in the shop before installation, with each frame requiring 2 hr. of the shop's labor and 1 unit of its wood, or they can be bought ready for installation from the local mill for $27 each. The shop pays $6/hr. for labor, $5/unit for wood, and only pays for the labor and wood used. For the next month, how many cabinets should the shop install, and how should the necessary frames be generated so that net income is maximized?

    I need help figuring out how to set up a table that sets up the problem. I can figure out the Excel stuff, I'm just confused as to how to set up the problem.
    1. Identify a suitable set of decision variables, say the number of cabinets to produce and the number of frames to be bought in.

    2. Express the income in terms of these decision variables

    3. Identify the constraints

    CB
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 0
    Last Post: February 7th 2011, 08:19 AM
  2. linear programming question solver excel
    Posted in the Business Math Forum
    Replies: 2
    Last Post: February 3rd 2011, 02:35 AM
  3. Help with linear programming question using excel
    Posted in the Advanced Algebra Forum
    Replies: 0
    Last Post: November 16th 2009, 02:28 AM
  4. linear programming/solver
    Posted in the Advanced Applied Math Forum
    Replies: 1
    Last Post: March 15th 2009, 01:45 AM
  5. Replies: 1
    Last Post: November 17th 2008, 04:18 AM

Search Tags


/mathhelpforum @mathhelpforum