skinny.

Latest / ModeLoop: Financial Modelling in Excel

Goal Seek versus Solver: a target is not a feasible plan | ModeLoop tool verdict

Standalone tool verdict using fictional checked examples. Goal Seek fits a one-input target question; Solver can represent a specified constrained optimisation problem.At £20 price, £12 variable cost and £2,400 fixed cost, algebraic break-even is 300 units. Capacity is only 250, giving a £400 loss. A £21.60 break-even price at that capacity assumes unchanged demand. Whole-unit checks matter too.In a separate two-product example, 120 A plus 120 B use 600 hours and earn £360 profit, subject to stated sales limits and non-negative whole quantities. Larger profits from plans that breach hours or…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.