Kaho Fertilizer

Chapter 2 Problem 4 The Kalo Fertilizer Company makes a fertilizer using two chemicals that provide nitrogen, phosphate, and potassium. A pound of ingredient 1 contributes 10 ounces of nitrogen and 6 ounces of phosphate, while a pound of ingredient 2 contributes 2 ounces of nitrogen, 6 ounces of phosphate, and 1 ounce of potassium. Ingredient 1 costs $3 per pound, and ingredient 2 costs $5 per pound. The company wants to know how many pounds of each chemical ingredient to put into a bag of fertilizer to meet the minimum requirements of 20 ounces of nitrogen, 36 ounces of phosphate, and 2 ounces of potassium while minimizing cost. a. formulate a linear programming model for this problem. b. Solve this model by using graphical analysis

YouTube Videos for Excel Solver

http://www.youtube.com/watch?v=0KPHmyyghew&feature=related

Excel Solver

http://office.microsoft.com/en-us/excel-help/introduction-to-optimization-with-the-excel-solver-tool-HA001124595.aspx

http://www.vertex42.com/ExcelArticles/excel-solver-examples.html

http://www.utexas.edu/courses/lasdon/design3.htm

http://www.economicsnetwork.ac.uk/cheer/ch9_3/ch9_3p07.htm

http://www.meiss.com/download/Spreadsheet-Optimization-Solver.pdf

http://support.microsoft.com/kb/843304

http://blogs.technet.com/b/office2010/archive/2009/10/12/functions-and-solver-improvements-in-excel-2010.aspx

Must be in correct format or it will not get a passing grade.