Cairo Consulting wants to determine whether reselling process consulting services provided by third parties would businesses the
Fantastic news! We've Found the answer you've been seeking!
Question:
- Set the objective as minimizing the value in cell E10 (Total Costs).
- Use the range B4:D4 as the changing variable cells.
Adjust the hours provided by each company using the following constraints: - E4=5500, the total hours of process consulting signed
- E10 is less than or equal to 1350000, the maximum third-party fees
- B4:D4 is less than or equal to 5000, the maximum hours provided by a single third-party provider
- B4:D4 should be an Integer
- 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.
Related Book For
Statistics for Business and Economics
ISBN: 978-0134506593
13th edition
Authors: James T. McClave, P. George Benson, Terry Sincich
Posted Date: