Linear programming for integrated circuitsa manufacturing

Assignment Help Business Management

Reference no: EM13366838

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: EM13366838

Questions Cloud

Single-sourcing strategieswho would you characterize : single-sourcing strategieswho would you characterize single-sourcing strategies with? what are some advantages and

Benchmarking logistics systemwhat type of methodology ie : benchmarking logistics systemwhat type of methodology i.e. comparing unit productivity within the same organization

Discrimination against womenare there circumstances under : discrimination against womenare there circumstances under which either public or private organizations should be

Role of an emplyeebriefly describe your role as an employee : role of an emplyeebriefly describe your role as an employee of an organization in the is field. give examples of what

Linear programming for integrated circuitsa manufacturing : linear programming for integrated circuitsa manufacturing company produces four different models of integrated

Future invention and personality inventoriesproponents of : future invention and personality inventoriesproponents of career aids such as future invention and personality

Organizational culture communication processes and : organizational culture communication processes and tacticsorganizational cultures do not change very much because they

Determining different types of costscenario smitheford : determining different types of costscenario smitheford pharmaceuticals is facing other issues. the company had not kept

Change management planquestion you have just been hired to : change management planquestion you have just been hired to manage a new project that will involve not only the

User Account

All Pages