Part a (worth 60 pts): Formulate a linear programming model(identify and define decision variables, objective function andconstraints) that can be used to determine the amount (in pounds)of Brazilian Natural and Colombian Mild that will maximize thetotal contribution to profit. For “Part a” you do NOT need to solvethis problem using Excel, you just need to do the LP formulation inthe standard mathematical format.
Part b (bonus worth 20 pts): Solve the LP problem that youformulated in “Part a” using Excel. Give the values of eachdecision variable and the objective function. You MUST attach acopy of the solution report.
