Jericho Agricultural Supply is mixing a fertilizer to sell to farmers. The agricultural supplier creates two fertilizer blends out of pure ingredients. Blend A uses 10 lbs of nitrogen and 10 lbs of phosphate in each 20 lb bag. Blend B uses 16 lbs of phosphate and 4 lbs of nitrogen in each 20 lb bag. A bag of Blend A sells for $16, while a bag of Blend B sells for $18. The supplier has 200 lbs of phosphate and 240 lbs of nitrogen to work with. How many bags of each kind of fertilizer should the agricultural supplier mix to generate the maximum gross income? Formulate a linear programming model and solve it graphically. Display your graph and calculate the maximum gross income. Create your graph using Microsoft Word or Excel and submit it to your instructor.
I need help with setting up the solution within excel.