Question: I want the question to be solved using Excel solver: United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at

I want the question to be solved using Excel solver: United Aluminum Company of Cincinnati produces three grades (high, medium, and low)of aluminum at two mills. Each mill has a different production capacity

United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade, as follows: Mill Aluminum Grade 1 2 High 6 2 Medium Low 2 2 4 10 The company has contracted with a manufacturing firm to supply at least 12 tons of high-grade aluminum, 8 tons of medium-grade aluminum, and 5 tons of low-grade aluminum. It costs United $6,000 per day to operate mill 1 and $7,000 per day to operate mill 2. The company wants to know the number of days to operate each mill to meet the contract at the minimum cost. Formulate a linear programming model for this problem.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!