How many of each product will be produced

Assignment Help Operation Management

Reference no: EM131593861

Linear Programming: Production Problem

A manufacturing company produces four different models of integrated circuits. Each type of circuit requires material, labor, and machine time.

The optimal combination of the four types of circuits is limited by the constraints of availability for these three resources. The formulation of the linear programming production problem is:

Maximize Z = 12x₁ + 10x₂ + 15x₃+ 11x₄ (objective function for profit)

Subject to the following constraints:

Material:	5x₁+ 3x₂ + 4x₃ + 2x₄ <= 240 pounds
Machine time:	6x₁ + 8x₂ + 2x₃ + 3x₄ <= 240 hours
Labor:	2x₁ + 3x₂ + 3x₃ + 2x₄<= 180 hours

Nonnegativity: x₁, x₂, x₃, x₄ >= 0

Where: x₁ = quantity of Product 1 produced

x₂ = quantity of Product 2 produced

x₃ = quantity of Product 3 produced

x₄ = quantity of Product 4 produced

Use Microsoft Excel and Solver to find the optimal solution for the production problem. Be sure that values selected by the computer are integers (as it doesn't make any sense to discuss producing part of a unit of a product).

Include your interpretation of the results by stating:

How many of each product will be produced?

What is the profit for the optimal solution?

What resource(s) is limiting the production?

Reference no: EM131593861

Questions Cloud

Find ab and ap in terms of a and b : Let a and b be two arbitrary skew (nonparallel) vectors, and set a = ab + ap, where ab is parallel to b and ap is perpendicular to b and lies in the plane.

How critical are writing skills in the legal profession : How critical are writing skills in the legal profession. What are some consequences of poor writing skills in the legal profession

Find the direction cosines and corresponding angles : Find the direction cosines and corresponding angles for the following vectors: i + j + k.

Key features of keynesian economic systems : What are key features of Keynesian Economic Systems as a distinct macroeconomic transformation from Classical form of Market Capitalism?

How many of each product will be produced : How many of each product will be produced?What is the profit for the optimal solution? What resource(s) is limiting the production?

A forward is the same as a short call and a long put : An increase in the spot rate will cause an increase in the price of a put option. A forward is the same as a short call and a long put.

Price per unit above marginal cost : Two part tariffs always involve setting the price per unit above marginal cost.

Compare the magnitude of a with the result : Given that a = 3i + 6j + 9k and b = i + 2j + 3k, find the projection of a onto the line of b.

What is the current price of preferred stock : What is the current price of this preferred stock given a required rate of return of 14.75 percent?

User Account

All Pages