The Excel Solver solution outputs are as shown in Table 2-1 and…

Question Answered step-by-step The Excel Solver solution outputs are as shown in Table 2-1 and… Image transcription textA company blends nitrogen andphosphorous to produce two types offertilizers. Fertilizer 1 must… Show more… Show moreImage transcription textThe LP model is as shown: Let Z be thenet profit = Revenue – Cost, MAX Z =$35N1 + $25N2 + $43Pl +… Show more… Show moreThe Excel Solver solution outputs are as shown in Table 2-1 and Table 2-2. Image transcription textTable 2-1: The Answer Report ObjectiveCell (Max) Cell Name Original ValueFinal Value $C$8 Objectiv… Show more… Show moreImage transcription textTable 2-2: The Sensitivity ReportVariable Cells Final Reduced ObjectiveAllowable Allowable Cell … Show more… Show more(a) Interpret the Excel Solver solution and advise the management on the optimal blend for the fertilizers, the amount of nitrogen and phosphorous to purchase and the expected profit.  (b) Suppose the company could acquire 1,000 pounds more of either nitrogen or phosphorous. Which should it choose? What would be the resulting impact on profit?  (c) Suppose the sales team update you that the selling price for Fertilizer 1 is $40 instead of $55. How would this change affect your decision?  Math Statistics and Probability BUS 107 Share QuestionEmailCopy link Comments (0)