Define and solve a problem by using Solver Excel Solver is a Microsoft Excel add-in program you can use for what-if …