Please help as soon as possible

1. a) Formulate the LP problem, given the following. Assume that you want to minimize the cost

Brand	Nitrogen (lb/bag)	Phosphate (lb/bag)
Gro-Plus ($6)	2	4
Crop-Fast ($3)	4	3

The farmer's field requires at least 16lb of nitrogen and 24 lb of phosphate

b)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.

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.

1) Set up of constraints and objective function. By Set up, please type cell numbers and your formulation accordingly.

Attach the screenshot of the spreadsheet you use to set up the LP problem.

2) attach the screenshot of the spreadsheet you use to choose objective function and to add constraints, etc.

Attach the snapshot of LP solution output generated by Excel solver