Question: a . Set the objective as minimizing the value in cell E 1 0 ( Total Costs ) . b . Use the range B

a. Set the objective as minimizing the value in cell E10(Total Costs).
b. Use the range B4:D4 as the changing variable cells.
Adjust the hours provided by each company using the following constraints:
c. E4=5500, the total hours of process consulting signed
d. E10 is less than or equal to 1350000, the maximum third-party fees
e. B4:D4 is less than or equal to 5000, the maximum hours provided by a single third-party provider
f. B4:D4 should be an Integer
g. Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range A14:A21, and then close the Solver Parameters dialog box.

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 Databases Questions!