Purchase Solution

# 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

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

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