$b.$ Change the price $(cellD8)to$ achieve the goal.

$8.$ Tech Togs $is$ designing a new smart watch named Zurich and plans $to$ work with three vendors $to$ manufacture the watch. Akio wants $to$ know how $to$ minimize the total manufacturing cost.

Switch $to$ the Zurich worksheet. Run Solver $to$ solve this problem $as$ follows:

$a.$ Set the objective $to$ minimize the total manufacturing cost $(cellE12).$

$b.$ Use the units produced $by$ each vendor $(the$ range $B11$:$D11)as$ the changing variable cells.

$c.$ Adjust the total manufacturing cost $by$ each vendor using the constraints $in$ Table $2.$

$d.$ Run Solver, keep the solution, and then return $to$ the Solver Parameters dialog box. Make unconstrained variables non$-$negative and use $GRG$ Nonlinear $as$ the solving method. Save the model beginning $in$ cell $D16.$

Max

Min

Value $Of$:

$By$ Changing Variable Cells:

$$B$$$11$:$$D$$$11$

Subject $to$ the Constraints:

$[$ $$B$$$11$:$$D$$$11=$ integer $],[$ $$B$$$11$:$$D$$$11$ $$B$$$16],[E{l}_{N}id{o}_U$nits $$ $$B$$$19],[Gans{u}_U$nits $$B$$$17],[Q_{S}ta{r}_U$nits $$B$$$18],[Tota{l}_U$nits $=$ $$B$$$20]$

Add

Change

Delete

Reset All

Loa$\frac{d}{S}$ave

Make Unconstrained Variables Non$-$Negative

Select a Solving

$GRG$ Nonlinear

Method:

Solving Method

Select the $GRG$ Nonlinear engine for Solver Problems that are smooth nonlinear. Select the $LP$ Simplex engine for

linear Solver Problems, and select the Evolut

PLease tell $me$ what I $am$ doing wrong