Linear Programming Formulation Problem
Not what you're looking for?
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.
Purchase this Solution
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.
Solution Preview
In the following solution, I have formulated the LP problem stating all the decision ...
Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Probability Quiz
Some questions on probability
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.