Question: changing variable cells. Adjust the number of units produced by each supplier using the following constraints: a . Set the total number of virtual assistants

changing variable cells. Adjust the number of units produced by each supplier using the
following constraints:
a. Set the total number of virtual assistants produced as greater than or equal to
11,000, DIG Technology's minimum production goal.
b. Set the total cost to be less than or equal to 925,000, the maximum total cost
DIG Technology wants to spend.
c. Set the number of virtual assistant units produced by each supplier to be less than
or equal to 4000 to balance the production among the suppliers. Also, make sure
that this same range contains 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 A14:A21.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!