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