Excel Solver is an advanced tool that helps users solve optimization problems by finding the optimal value (maximum or minimum) for a formula in a single cell, known as the…