So it pays to consult books like the ones listed below! There are many 'classic' optimization problems, for transporting goods, blending materials, scheduling personnel, etc. There's a lot you can learn from textbooks in the fields of operations research and management science, where the optimization methods used by the Solver were first developed and applied.
