# Failsafe Electronics Corporation: LPP Sensitivity

Not what you're looking for?

Solve this problem with one both a one-way solverTable and one two-way solverTable.

Failsafe Electronics Corporation manufactures four products. Each of the products must pass through the following departments: wiring, drilling, assembly, and inspection. Time requirements in each department (in hours) for each unit produced and unit profit are summarized in the table below:

Department

Product Wiring Drilling Assembly Inspection Unit Profit

XJ201 0.5 3 2 0.5 $9.00

XM897 1.5 0.5 4 1.0 $12.00

TR29 1.5 1 1 0.5 $15.00

BR788 1.0 2 2 0.5 $11.00

Failsafe must produce at least the following:

Product Minimum Production

XJ201 150

XM897 100

TR29 300

BR788 400

Production time available each month are as follows (in hours):

Department Capacity (in hours)

Wining 1,500

Drilling 2,350

Assembly 2,600

Inspection 1,200

?X Find the monthly production plan that maximizes profit. Non-integer answers are acceptable for planning purposes.

?X Create at least one one-way SolverTable and one two-way SolverTable. You will need to analyze the solution to determine which variables to use in these tables. There are not right or wrong variables to choose but you will want to vary things that give you insight to the problem and your recommendation.

Hint: The maximum profit of the optimal solution is $16,400.

Maximum Profit = $16,400

Include at least 1 one-way and 1 two-way SolverTable

##### Purchase this Solution

##### Solution Summary

This posting contains solution to following LPP problem of Failsafe Electronics Corporation using excel solver and solver table.

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

##### Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

##### 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.

##### 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.