Solver is an amazing tool. It's a decision analysis tool that lets you set your goal and set the conditions to adhere to while searching for the best way to…