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
INSIDE ELECT $55
INSIDE GAS $85
OUTSIDE ELECT $67
OUTSIDE GAS $95
ELECTRIC GAS AVAILABLE
PRODUCTION 0.20 0.40 <= 10,000
ASSEMBLY 0.50 0.30 <= 15,000
PACKAGING 0.10 0.10 <= 5,000
INHOUSE 200 400
OUTSIDE 300 500
OBJECTIVE FUNCTION: MINIMIZE COST 1400© BrainMass Inc. brainmass.com December 24, 2021, 4:54 pm ad1c9bdddf
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 ...
The expert trouble shoots linear programming. Objective functions for minimum costs are examined. Excel solver is used for the trouble shooting of linear programming....