A manufacturer of plastics is planning to blend a new product from four chemical compounds. These...

Transcribed Image Text:

A manufacturer of plastics is planning to blend a new product from four chemical compounds. These compounds are mainly composed of three elements: A, B, and C. The composition and unit cost of these chemicals are shown in the following table: CHEMICAL COMPOUND Percentage A Percentage B Percentage C Cost/kilogram 1 35 20 40 20 2 15 65 15 30 3 35 35 25 20 4 25 40 30 15 The new product consists of 25 percent element A, at least 35 percent element B, and at least 20 percent element C. Owing to side effects of compounds 1 and 2, they must not exceed 25 percent and 30 percent, respectively, of the content of the new product. A) Formulate he problem of finding the least costly way of blending as a linear program. B) Calculate the optimum value for objective function and optimal value for each one of the decision variables used in your model, by using M.S EXCEL solver. A manufacturer of plastics is planning to blend a new product from four chemical compounds. These compounds are mainly composed of three elements: A, B, and C. The composition and unit cost of these chemicals are shown in the following table: CHEMICAL COMPOUND Percentage A Percentage B Percentage C Cost/kilogram 1 35 20 40 20 2 15 65 15 30 3 35 35 25 20 4 25 40 30 15 The new product consists of 25 percent element A, at least 35 percent element B, and at least 20 percent element C. Owing to side effects of compounds 1 and 2, they must not exceed 25 percent and 30 percent, respectively, of the content of the new product. A) Formulate he problem of finding the least costly way of blending as a linear program. B) Calculate the optimum value for objective function and optimal value for each one of the decision variables used in your model, by using M.S EXCEL solver.

Answer rating: 100% (QA)

A The problem can be formulated as a linear program as follows Maxi... View the full answer