a) Formulate and solve a linear programming model to help Fruit minimize the weighted penalty associated with meeting the annual chip requirements. Solve it using Excel.

b) Use preemptive goal programming (linear programming model) to determine a purchasing strategy for Fruit Computer Company. Let the budget constraint have the highest priority, followed in order by the restrictions on excellent and then good chips. Solve it using Excel.