Formulate a linear programming model for this problem

Assignment Help Operation Management

Reference no: EM13759636

The Elixer Drug Company produces a drug from two ingredients. Each ingredient contains the same three antibiotics, in different proportions. One gram of ingredient 1 contributes 3 units, and 1 gram of ingredient 2 contributes 1 unit of antibiotic 1; the drug requires 6 units. At least 4 units of antibiotic 2 are required, and the ingredients contribute 1 unit each per gram. At least 12 units of antibiotic 3 are required; a gram of ingredient 1 contributes 2 units, and a gram of ingredient 2 contributes 6 units. The cost for a gram of ingredient 1 is $80, and the cost for a gram of ingredient 2 is $50. The company wants to formulate a linear programming model to determine the number of grams of each ingredient that must go into the drug in order to meet the antibiotic requirements at the minimum cost. a. Formulate a linear programming model for this problem. Utilize simplex method with excel formulas.

Reference no: EM13759636

Questions Cloud

Brainstorming techniques does this best describe : During a business meeting, Jeff decided to look at all the project options presented to him and try mixing them together to see how different combinations worked. Which of the following brainstorming techniques does this best describe?

Identifies management personnel-nature of the organization : Determine an organization you will analyze and evaluate over the six weeks of this course. The organization can be one in which you work, one in which you have access, or one of such substance that significant internet material is available for your ..

Assuming that coefficient is kept constant at present value : A company produces two products, A and B. The unit revenues are $2 and $3, respectively. Determine the optimality condition for ~ that will keep the optimum unchanged. Determine the optimality ranges for CA and C8, assuming that the other coefficient..

Using qualitative risk analysis matrix : Imagine that you are a member of a project team that has been charged to develop a new product for the residential building industry. Using a qualitative risk analysis matrix, develop a risk assessment for a project based on the following information..

Formulate a linear programming model for this problem : The Elixer Drug Company produces a drug from two ingredients. Each ingredient contains the same three antibiotics, in different proportions. One gram of ingredient 1 contributes 3 units, and 1 gram of ingredient 2 contributes 1 unit of antibiotic 1; ..

Utilize simplex method in excel showing formulas : The Pinewood Furniture Company produces chairs and tables from two resources----labor and wood. The company has 80 hours of labor and 36 board -ft. of wood available each day. Demand for chairs is limited to 6 per day. formulate a linear programming ..

Advantages and disadvantages multiple job evaluations : Advantages/Disadvantages Multiple Job Evaluations. You are the manager of 10 people in a large organization. All of them become very suspicious and upset when they receive a memo from the HR department saying their jobs are going to be evaluated. How..

Determine the walmarts economic order quantity : The demand for spring water at the SLC WalMart is 600 liters per week. The setup cost for placing an order to replenish inventory is $25. The order is delivered by the supplier which charges WalMart $0.10/liter for the cost of transportation from the..

Owns the many species found in nature : Critically assess Merck's deal with INBio. Was it ethically justifiable? Why or why not? Who, if anyone, owns the many species found in nature? Do they belong to the people who own the land or water on or in which they are found?

User Account

All Pages