Explore BrainMass
Share

Explore BrainMass

    Linear Programming Formulation Problem

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

    The demands of circuit boards in 4 warehouses have to be met from 3 production plants. Each plant has their own capacity and production cost per unit, each warehouse has their own demand and the transportation cost is different from different plants to different warehouses. Each circuit board is sold at the same unit price regardless of where they are made and where they are stored.

    Formulate a linear programming problem stating all the variables and constraints to maximize the profit. Then show how to set the problem up in Excel Solver, showing the process step by step. Finally, solve the problem in Excel Solver and give the value of the objective function and the decision variables.

    © BrainMass Inc. brainmass.com October 10, 2019, 7:04 am ad1c9bdddf
    https://brainmass.com/math/linear-programming/linear-programming-formulation-problem-566930

    Attachments

    Solution Preview

    In the following solution, I have formulated the LP problem stating all the decision ...

    Solution Summary

    This solution shows how to formulate a linear programming problem, including an explanation of how to set up the problem in Excel and how to solve the problem to find the values of objective function and decision variables.

    $2.19