Linear Programming Problem Trouble Shooting
Not what you're looking for?
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
Purchase this Solution
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....
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 ...
Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Introduction to Finance
This quiz test introductory finance topics.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.