Rachel Rosecrantz, the manager of the assembly plant of Automobile Alliance, must make
decisions in several different situations regarding the number of Family Thrillseeker and Classy
Cruiser car models that must be assembled to maximize the company’s profit. In this report we
apply linear programming using Microsoft Excel to each of these situations to aid in Rachel’s
decisions.