An Excel Solver Model for a Blending Type Optimization Problem in Mining with Quadratic Programming

An Excel Solver Model for a Blending Type Optimization Problem in Mining with Quadratic Programming

ÇETIN, Necmettin
GÖKTAS, Ünal

A Stochastic non-linear optimization model using Quadratic Programming (QP) is presented for a hypothetical blending type problem in mining industry. Microsoft Excel 10.0 Solver is used to develop the model for a three-seam coal mine and data are hypothetically generated for a case study problem. Optimum quantities of each run of mine (r.o.m) coal with variability in calorific values to be fed to a nearby power plant are determined with given specifications. QPs arise directly in such applications as least-squares regression with bounds or linear constraints, robust data fitting, Markowitz portfolio optimization, data mining, support vector machines and tribology. They also arise as sub problems in optimization algorithms for nonlinear programming and in stochastic optimization.

Conference or Workshop Item
PeerReviewed

2009-06

508