Linear Programming Problem Trouble Shooting
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
© BrainMass Inc. brainmass.com March 6, 2023, 12:46 pm ad1c9bdddfhttps://brainmass.com/business/operations-research/linear-programming-problem-trouble-shooting-14351
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....