$1$ Problem $3$: Sensitivity Analysis Exercise $-$ Model

Instructions: This is the model for the problem attached on the right side. The sensitivity report for this

model is on the next worksheet. Based on this model and the sensitivity report, answer the questions on

$2$ worksheet "Problem $3-$Questions".

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:

Operation days

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\mathrm{.}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 in order to meet the contract at the minimum cost.