Linear programming for integrated circuits

Assignment Help Business Management

Reference no: EM1359267

Linear Programming for Integrated Circuits

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 = 12x1 + 10x2 + 15x3 + 11x4 (objective function for profit)

Subject to the following constraints:

Material: 5x1 + 3x2 + 4x3 + 2x4 = 240 pounds
Machine time: 6x1 + 8x2 + 2x3 + 3x4 = 240 hours
Labor: 2x1 + 3x2 + 3x3 + 2x4 = 180 hours

Nonnegativity: x1, x2, x3, x4 = 0

Where: x1 = quantity of Product 1 produced

x2 = quantity of Product 2 produced

x3 = quantity of Product 3 produced

x4 = 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).

Reference no: EM1359267

Questions Cloud

Create a program to store assignment grades for student : The elementary school for which you are doing development work has asked you to create a program to store assignment grades for one student.

Calculate the expected eps : Morton Industries is planning opening a new subsidiary in Boston, to be operated as a separate corporation. The corporation's financial analysts expect the new facility's average EBIT level to be $6 million per year.

Find the normal force exerted on the crate by the elevator : Find out the normal force exerted on the crate by the elevator.

Cognitive-social learning model : What are the advantages of cognitive-social learning model when dealing with relapse prevention?

Linear programming for 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.

Develop a break-even chart for the textbook : East Publishing Corporation is doing an analysis of a proposed new finance textbook. Using the following information

Design and write a payroll program : Design and write a payroll program that will prompt the user to enter an employee's hourly pay rate and the number of hours worked.

Find the recoil speed of the rifle : Find the recoil speed of the rifle. A 650-N force acts in a northwesterly direction. A second 650-N force must be exerted in what direction so that the reultant of the two forces points westward? Illustrate your answer with a vector diagram.

Identification and treatment concerns for women : What role does gender play in the identification and treatment concerns for women?

User Account

All Pages