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.