Purchase Solution

Linear Programming Formulation Problem

Not what you're looking for?

Ask Custom Question

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.