Excel Project $3.$pdf

Download Excel Project $3.$pdf $(117$ KB$)$

Page

$2$

of $2$

$15.$ Go to the Supplemental Shipment Worksheet

a$.$ Correct any errors in the formulas $($Hint: Look at surrounding cells$).(5$ Points$)$

b$.$ Make $2$ copies of the Worksheet $($You should now have three copies of this worksheet$)(2\mathrm{.}5$ Points$)$

c$.$ Rename the worksheets: "Shipment $1,"$ "Shipment $2,"$ "Shipment $3"(2\mathrm{.}5$ Points$)$

d$.$ Use the solver on Shipment $1$ with Spare$-$Volume in Cubic Feet of $650$ and Spare Weight in Pounds of $800$ to find the Optimal Number to Ship. $(10$ Points$)$

e$.$ Use the solver on Shipment $2$ with Spare Volume in Cubic Feet of $750$ and Spare Weight in Pounds of $950$ to find the Optimal Number to Ship. $(10$ Points$)$

f$.$ Use the solver on Shipment $3$ with Spare Volume in Cubic Feet of $700$ and Spare Weight in Pounds of $1000$ to find the Optimal Number to Ship. $(10$ Point

I am looking for the solver code answers.