Explore BrainMass

# Linear Programming Problem Trouble Shooting

Not what you're looking for? Search our solutions OR ask your own Custom question.

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

I seem to be missing something. Please review the attached file, explain what I am missing, and respond with a corrected Excel spreadsheet so I can solve with Solver and use for future problems.

MOBILE CHAIR COMPANY PROBLEM

INPUT COST
INSIDE ELECT \$55
INSIDE GAS \$85
OUTSIDE ELECT \$67
OUTSIDE GAS \$95

HOURS
ELECTRIC GAS AVAILABLE
PRODUCTION 0.20 0.40 <= 10,000
ASSEMBLY 0.50 0.30 <= 15,000
PACKAGING 0.10 0.10 <= 5,000

PRODUCTION PLAN

ELECTRIC GAS
INHOUSE 200 400
OUTSIDE 300 500

OBJECTIVE FUNCTION: MINIMIZE COST 1400

#### Solution Preview

I worked out an EXCEL table , which should be more accessible for the solver.
However, there's still some points to be clarified:

1. the relation between ELECTRIC,GAS and PRODUCTION, ASSEMBLY, PACKAGING is not ...

#### Solution Summary

The expert trouble shoots linear programming. Objective functions for minimum costs are examined. Excel solver is used for the trouble shooting of linear programming....

\$2.49