The case affords students the opportunity to develop a processing plan. For MBA students, that task will be accomplished using Excel’s Solver tool. In the analysis section, we present a Solver model that is linear and well suited to the task. The resulting optimal solution, however, is not without its shortcomings. Those shortcomings and how to respond to them can be addressed during class.