Explore BrainMass

Explore BrainMass

    Linear Programming

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Using Excel, please solve the following:

    The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, N.C.. The plant uses three main resources to make furniture- wood, upholstery, and labor. The resource requirements for each piece are as follows:

    (See chart in attached file)

    The furniture is produced weekly and is stored in a warehouse until the end of the week, when it is shipped out. The warehouse has a total capacity of 650 pieces of furniture. Each sofa earns $400 profit, each table $275, and each chair $190. The company wants to know how many pieces of each type of furniture to make each week to maximize profit.

    a) Formulate a linear programming model for this problem.
    b) Solve the model using the computer.

    © BrainMass Inc. brainmass.com December 15, 2022, 5:27 pm ad1c9bdddf
    https://brainmass.com/business/operations-research/linear-programming-84466

    Attachments

    Solution Summary

    Provides solution to linear programming problem using Excel Solver.

    $2.49

    ADVERTISEMENT