Use microsoft excel and solver to find out the optimal

Assignment Help Operation Management

Reference no: EM13392537

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

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

Questions Cloud

Trevor price bought 10-year bonds issued by harvest foods : trevor price bought 10-year bonds issued by harvest foods five years ago for 1013.24. the bonds make semiannual coupon

Using the sample marketing plan inmarketing and management : complete the final phase of your new product launch marketing plan. using the sample marketing plan inmarketing and

Use the internet to research the apple corporation its : use the internet to research the apple corporation its current position and reputation regarding ethical and social

Choose an editorial article from the new york times or the : choose an editorial article from the new york times or the wall street journal. browse the library and choose an

Use microsoft excel and solver to find out the optimal : a manufacturing company produces four different models of integrated circuits. each type of circuit requires material

What comparative advantage does abc have when establishing : abc co. has recognized numerous opportunities to expand in foreign countries and has assessed many foreign markets

Explain enterprise resource planning how does enterprise : why is it important for an organization to identify the areas it wishes to measure before the implementation process

Define the type of marketing that will be used for the : conduct environmental scanning to determine the internal and external factors that will affect the organization. in

There are two investment opportunities that nike is : assume that you are a consultant to nike corporation.nbsp as a consultant you are to advise the vice president for

User Account

All Pages