Reference no: EM13979139

Problem Set

1. For all the following problems, word-process your solutions within this template. Do not create a new file.

2. Show all steps used in arriving at the final answers. Incomplete solutions will receive partial credit.

3. Word-process formulas using Equation Editor and diagrams using Drawing Tool.

4. Use Solver to obtain computer solutions in an Excel workbook.

5. Submit the Word and the Excel workbook(s) separately as attachments.

Problem 1

Determine the optimum solution for each of the following LPs by enumerating all basic solutions.

Maximize Z = 2x₁ -4x₂ + 5x₃ - 6x₄,

Subject to:

x₁ + 4x₂ - 2x₃ + 8x₄ ≤ 2

-x₁ + 2x₂ + 3x₃ + 4x₄ ≤ 1

x₁, x₂, x₃, x₄ ≥ 0

Minimize Z = x₁ + 2x₂ - 3x₃ - 2x₄,

Subject to:

x₁+ 2x₂ - 3x₃ + x₄ = 4

x₁+ 2x₂ + x₃ + 2x₄ = 4

x₁, x₂, x₃ , x₄ ≥ 0

Source: Operations Research, An Introduction by Taha. Ninth Edition. Chapter 3 Page 75 Pearson. 2011

Write your responses to parts (a) and (b in the space provided below:

Problem 2

Consider the following sets of constraints:

x₁ + 2x₂ + 2x₃+ 4x₄ ≤ 40

2x₁ -x₂ + x₃ + 2x₄ ≤ 8

4x₁ - 2x₂ + x₃ -x₄ ≤ 10

x₁, x₂, x₃ ,x₄ ≥ 0

Use the Simplex iteration method to solve the problem for each of the following objective functions.

Maximize Z = 3x₁-x₂ + 3x₃ + 4x₄.

Minimize Z = 5x₁ - 4x₂ + 6x₃ -8x₄.

Write your responses to parts (a) and (b) in the space provided below:

Problem 3

The Gutuchi Company manufactures purses, shaving bags and backpacks. The construction includes leather and synthetics. Leather being the scarce raw material.

The production process requires two types of skilled labor: sewing and finishing.

The following table gives the availability of the resources, their usage by these products, and the profits per unit. The production manager at Gutuchi wishes to determine the production levels so that the company's total revenue is maximized.

	**                            Resource Required per Unit                          **
Resource:	Purse	Bag	Backpack	Daily Availability
Leather (Sq. ft.)	2	1	3	42
Sewing (Hr.)	2	1	2	40
Finishing (Hr.)	1	0.5	1	45
Selling Price ($)	24	22	45

(a) In this document, describe the components (decision variables, the objective function, and the constraints) in the context of this problem.

(b) In this document, write the mathematical formulation of the problem.

(c) In this document, address the manager's concern by describing the solutions obtained fromthe Solver.

(d) In an Excel workbook, solve the problem by using the Solver.