Solving a linear programming problem using solver tool in MS Excel

This tutorial demonstrates the use of solver tool in MS Excel to solve a linear programming problem. The problem requires us to find the number of each cake type that a bakery needs to produce and sell in order to maximise its profit, given certain constraints.