Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems. Load the Solver Add-in To load the solver add-in, execute the following steps. 1. On the File tab, click Options. 2. Under Add-ins, select Solver Add-in and click on the Go button. 3. Check Solver Add-in and click OK. 4.…