Linear Programming using Excel to for two products in two lines
Not what you're looking for?
A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Product 1 requires 10 hours of processing time on line 1 and product 2 requires 14 hours of processing on line 1. , On line 2, product 1 requires 7 hours and product 2 requires 3 hours. The profit for product 1 is $6 per unit, and the profit for product 2 is $4 per unit.
a. Formulate a linear programming model for this problem.
b. Solve the model by using graphical analysis.
Purchase this Solution
Solution Summary
This Linear Programming problem has been solved using EXCEL Solver.
Education
- MSc, Osmania University
- MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
- BSc, Banaras Hindu University
Recent Feedback
- "Very fast turnaround. Excellent communication! Much appreciated!"
- "excellent"
- "excellent"
- "excellent work"
- "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
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
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.