Question: Please show formulas if needed on an excel sheet Problem 3. A fertilizer company blends silicon and nitrogen to produce two types of fertilizers. Fertilizer

Please show formulas if needed on an excel sheet

Please show formulas if needed on an excel sheet

Problem 3. A fertilizer company blends silicon and nitrogen to produce two types of fertilizers. Fertilizer 1 must be at least 50% nitrogen and sells for $77.00 per pound. Fertilizer 2 must be at least 70% silicon and sells for $55.00 per pound. The company can purchase up to 8,000 pounds of nitrogen at $22.00 per pound and up to 10,000 pounds of silicon at $16.00 per pound. Assuming that all fertilizer produced can be sold, create a linear programming model to determine how the company can maximize its profit. Purchase costs Nitrogen Silicon Fertilizer 1 Fertilizer 2 Selling prices Minimum nitrogen in fertilizer 1 (%) Minimum silicon in fertilizer 2 (%) Available Blending plan (pounds of inputs into pounds of outputs) Fertilizer 1 Fertilizer 2 Nitrogen Silicon Total 0 0 Nitrogen constraint Actual Silicon constraint Actual >= Required Required Total cost Total revenue Profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!