Excel Video 334 Changing Constraints in Solver

Some of the real power of Solver comes when Solver can’t find a solution. I’ll show you what I mean in Excel Video 334. In today’s example, the number of patients decreases so much that even after changing the reimbursement and the cost of the equipment, Solver can’t find a solution to pay for the equipment in 6 months. Watch how we use an iterative process to keep changing criteria until we find a solution that works. Solver can provide some reports to track the solution process that may be helpful for you. We’ll walk through those reports next time. I look forward to seeing you then.