Question: a . Set the objective as minimizing ( Min ) the total cost ( cell E 1 0 ) . b . Use the units
a Set the objective as minimizing Min the total cost cell E
b Use the units produced values range B:D 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 as greater than or equal to DIG Technology's minimum production goal.
Set the total cost cell E to be less than or equal to the maximum total cost DIG Technology wants to spend.
Set the total number of virtual assistants produced by a single supplier range B:D to be less than or equal to to balance the production among the suppliers.
Make sure the values in the range B:D are integers since DIG Technology cannot sell a fraction of a product.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
