Go to the Suppliers worksheet, where Benicio wants to determine whether subcontracting could reduce the cost

$\frac{3}{5}$

of the new virtual assistant product.

Run Solver to solve this problem as follows:

a$.$ Set the objective as minimizing $($Min$)$ the total cost $($cell E$10).$

b$.$ Use the units produced values $($range B$5$:D$5)$ as the changing variable cells.

c$.$ Adjust the number of units produced by each supplier using the following constraints:

Set the total number of virtual assistants produced $($cell E$5)$ as greater than or equal to $11,000,$ DIG Technology's minimum production goal.

Set the total cost $($cell E$10)$ to be less than or equal to $925,000,$ the maximum total cost DIG Technology wants to spend.

Set the total number of virtual assistants produced by a single supplier $($range B$5$:D$5)$ to be less than or equal to $4000$ to balance the production among the suppliers.

Make sure the values in the range B$5$:D$5$ are integers since DIG Technology cannot sell a fraction of a product.

d$.$ Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model in the range A$14$:A$21.$

Set the objective cell in a Solver model.

Define the changing cells in a Solver model.

Define a constraint in a Solver model.

In the Suppliers worksheet, the Solver model should contain a constraint that limits the values in cell E$5$ to $11000.$

Define a constraint in a Solver model.

Define a constraint in a Solver model.

Define a constraint in a Solver model.

In the Suppliers worksheet, the Solver model should contain a constraint that limits the values in the range B$5$:D$5$ to integers.

Define the solving method in a Solver model.

Save a Solver model in a worksheet.

In the Suppliers worksheet, the Solver model should be saved in the range A$14$:A$21.$

Run Solver again, create an Answer report, and then close the Solver Parameters dialog box.

Create an Answer report.

$\frac{0}{5}$

The Answer Report I worksheet should contain an Answer report.