Question: Question a) Use the excel solver on the simplex method to solve the above problem (show the answer and the sensitivity report) 10Marks b) From

Question a) Use the excel solver on the simplex method to solve the above problem (show the answer and the sensitivity report) 10Marks b) From the sensitivity analysis report, what will be the optimal solution to the model? (5Marks) c) Are all constraints binding? Give reason for your answer (10Marks)

Non negativity constraints x1, x2, greater or equal to zero

Question a) Use the excel solver on the simplex

Question Maximize 60x1 + 50x2 Subject to: Machine 4x1 +10x2 S 100hrs Labour 2x1 + 1x2 s 22hrs Storage 3x1 + 3x2 s 39 cubic feet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question Maximize 60x1 + 50x2 Subject to: Machine 4x1 + 10x2 5 100hrs Labour 2x1 + 1x2 s 22hrs Storage 3x1 + 3x2 5 39 cubic feet a) Use the excel solver on the simplex method to solve the above...

production: Type 1 and Type 2 Non-negativity constraint: x1, x2 >=0 a) Use the excel solver on the simplex method to solve the above problem (show the answer and the sensitivity report) 10Marks b)...

Course Title: Operations Research Question 4 A company manufactures two models of a product, which we call the regular model and the enhanced model. Two resources, A and B, are needed for the...

Question 4 A firm that assembles computers and computer equipment is about to start production of two types of microcomputers. Each type will require assembly time, inspection time and storage space....

please answer all clearly Question 4 A firm that assembles computers and computer equipment is about to start production of two types of microcomputers. Each type will require assembly time,...

operations research Question 4 A firm that assembles computers and computer equipment is about to start production of two types of microcomputers. Each type will require assembly time, inspection...

Question 3 A firm that assembles computers and computer equipment is about to start production of four types of microcomputers. Each type will require assembly time, inspection time, packaging time...

A food company has plants in cities 1, 2, and 3. The company produces and ships its product to four distribution centers A, B, C and D across the nation. Each week the company can produce 400 units...

Question Completion Status: sensivity analysis result - YouTube QUESTION 1 Spley Library echnology Support Grades Consider the following LP problem for all questions: 2 po Classroom ursEval Max...

DETERMINE THE VOLUME GENERATED BY ROTATING THE AREA SHOWN 180 ABOUT THE y -AXIS, (USING THEOREM OF PAPPUS )

A group of students on spring break manages to reach a deserted island in their wrecked sailboat. They splash ashore with fuel, a European gasoline-powered 240-V generator, a box of North American...

3. Write a CALL statement that calls a procedure named MyProc in an external link library.

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...