Run Solver and set the objective as minimizing the total costs (cell F10). Use the hours provided for each company (range C4:E4) as the changing variable cells. Adjust the hours provided by each company using the following constraints:
· F4 is equal to 192, the total hours of event services provided.
· F10 is less than or equal to 48,000, the maximum amount Fernanda can pay to the other event services companies.
· C4:E4 is less than or equal to 68, the maximum hours provided by a single event services company.
· C4:E4 should be an Integer.
Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range B14:B21.
