I for got to add last part please read and show all steps of the answers.

Page 1 > of 3 ZOOM 1. (please type) a) Formulate the LP problem, given the following. Assume that you want to minimize the cost (p.649) (0.5pts) CHEMICAL CONTRIBUTION Brand Nitrogen (bag) Phosphate (bag) Gro-plus (86) Crop-fast (53) 4 The farmer's field requires at least 16 lb of nitrogen and 24 lb of phosphate. b) (Handwritten okay) Draw the graph. Mark your both axes and all extreme points clearly. What is the optimal solution? Specify how many Gro-plus and Crop-fast the farmer should use and the total cost. (1.5pts) Page 2 > of 3 ZOOM + c) Use Excel solver to solve for the problem. First, please show how you formulate and set up them in the Excel file, along with the screenshot of the excel spreadsheet. To see examples of how to set up in Excel, refer to the slides 24-29. 1) Set up of constraints and objective function. By "Set up, please type cell numbers and your formulation accordingly. A quick example is 012-C4*B10+04-811. (0.5pts) Attach the screenshot of the spreadsheet you use to set up the LP problem. See slide 24 as an example of the screenshot of spreadsheet you should attach here (0.5pts): 21 attach the screenshot of the spreadsheet you use to choose objective function and to add constraints, etc. See slide 25 as an example of the screenshot of spreadsheet you should attach here (0.5pts) d) Attach the snapshot of LP solution output generated by Excel solver (See slide 26 as an example of what you should insert here) (0.5pts) Page 1 > of 3 ZOOM 1. (please type) a) Formulate the LP problem, given the following. Assume that you want to minimize the cost (p.649) (0.5pts) CHEMICAL CONTRIBUTION Brand Nitrogen (bag) Phosphate (bag) Gro-plus (86) Crop-fast (53) 4 The farmer's field requires at least 16 lb of nitrogen and 24 lb of phosphate. b) (Handwritten okay) Draw the graph. Mark your both axes and all extreme points clearly. What is the optimal solution? Specify how many Gro-plus and Crop-fast the farmer should use and the total cost. (1.5pts) Page 2 > of 3 ZOOM + c) Use Excel solver to solve for the problem. First, please show how you formulate and set up them in the Excel file, along with the screenshot of the excel spreadsheet. To see examples of how to set up in Excel, refer to the slides 24-29. 1) Set up of constraints and objective function. By "Set up, please type cell numbers and your formulation accordingly. A quick example is 012-C4*B10+04-811. (0.5pts) Attach the screenshot of the spreadsheet you use to set up the LP problem. See slide 24 as an example of the screenshot of spreadsheet you should attach here (0.5pts): 21 attach the screenshot of the spreadsheet you use to choose objective function and to add constraints, etc. See slide 25 as an example of the screenshot of spreadsheet you should attach here (0.5pts) d) Attach the snapshot of LP solution output generated by Excel solver (See slide 26 as an example of what you should insert here) (0.5pts)