please read all questions and all parts. please answer each part and show work. thank you

1 > of 3 ZOOM + Instructions of this individual take home exercise: Please TYPE unless otherwise noted. Upload your completed assignment as ONE Word document on Canvas by 12pn noon on the due done (10/6, Tel. Please indude your handwritten part as well as the screenshot of Excelfie in ONE Word document To do so, you can take picture and insert picture. Please keep all the texts in this document and just insert your responses below each question 1. (plex type) a) Formulate the LP problem, then the following. Kisume that you want to minimize the cop 549) 105 CHEMICAL CONTRIBUTION Aran Mitroge bug] Phosphate / Groplus (56) Croplas: The farmer's field requires at least 16 lb of nitrogen and 24 lb of phosphate. by Handwritten or Draw the graph. Mark your both and all extreme points clearly. What is the optimal solution Specify how many Gro-plus and Crop fast the former should use and the total COST. [15 (OM470 F20 en LP assignment c) Weseller 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 cal pracht. To se cumple of how to set up in Excel, refer to the sides 2429 11 Set up of constraints and objective function. By "Set up. please type cel numbers and you formulation accordingly. A quick example is 812-C4%B10-04-811. 10.5pts Attach the screenshot of the spreadsheet you use to set up the problem. See slide 2d as an wa shida hari 2 > of 3 ZOOM + Use Excelscher 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 sides 20-29 1 Set up of carstraints and objective function. By Set upp type al number and your formulation accordingly. A quick amples B12-C451004811. 10.Spal Attach the screenshot of the spreadsheet you use to set up the problem. See side 24 as an enample of the screenshot of spreadsheet you should attack here 10.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: QOM470 F20 Cel Pent 3 of 3 ZOOM + (OM40F20 Chen LP d) Attach the shot of LP solution output generated by Excel solver (See slide 26 as an example of what you should insert here) 10 Sets (OMTO 20 Del LP assignment