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 E10).
b. Use the units produced values (range B5:D5) 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 E5) as greater than or equal to 11,000, DIG Technology's minimum production goal.
Set the total cost (cell E10) 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 B5:D5) to be less than or equal to 4000 to balance the production among the suppliers.
Make sure the values in the range B5:D5 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 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!