Purchase Solution

Apply excel solver to find the maximal

Not what you're looking for?

Ask Custom Question

The Hansel Corporation, located in Bangalore, India, makes plastics materials that are mixed with various additives and reinforcing materials before being melted, extruded, and cut into small pellets for sale to other manufacturers. Four grades of plastic are made, each of which might include up to four different additives. The table shows the number of pounds of additive per pound of each grade of final product, the weekly availability of the additives, and cost and profitability information.

Because of marketing considerations, the total amount of grades 1 and 2 should not exceed 60% of the total of all grades produced, and at least 30% of the total product mix should be grade 4.

a.) How much of each grade should be produced to maximize profit? Develop and solve a linear optimization model.

b.) A labor strike in India leads to a shortage of 20,000 units of additive C. What should the production manager do?

c.) Management is considering raising the price on grade 2 to $2.00 per pound. How will the solution be changed?

Purchase this Solution

Solution Summary

The solution provides detailed explanation how to apply solver to find the maximal.

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.