Explore BrainMass

Explore BrainMass

    Linear Programming Problem Trouble Shooting

    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

    © BrainMass Inc. brainmass.com February 24, 2021, 2:20 pm ad1c9bdddf
    https://brainmass.com/business/operations-research/linear-programming-problem-trouble-shooting-14351

    Attachments

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

    ADVERTISEMENT