$1$ Problem $1$: Excel Solver Exercise

Instructions: This model corresponds to the problem attached on the right. $1)$ Enter the parameters and formulas into the spreadsheet, $2)$ Solve the LP model using Excel Solver, and $3)$ Provide the answer report and sensitivity report.

$\backslash$table$[[$Aluminum$,$Mill $1,$Mill $2,$Production Quantity,Demand,$8,,],[$High$,6,2,>=,,$United Aluminum Company of Cincinnati produces aluminum at two mills. Each mill has a different pro grade, as follows:$],[$Medium$,2,2,>=,],[$Low$,4,10,>=,],[$Cost per day,,,,,Aluminum Grade,Mill$],[,,,,,1,2],[$Operation days,,,,High,$6,2],[,$Mill $1,$Mill $2,,,$Medium

Low,$2,2],[,,,,,4,10]]$

Total cost

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