Strategic allocation of resources using linear programming model with parametric analysis: in MATLAB and Excel Solver

Strategic allocation of resources using linear programming model with parametric analysis: in MATLAB and Excel Solver
Author :
Publisher : diplom.de
Total Pages : 74
Release :
ISBN-10 : 9783954897803
ISBN-13 : 3954897806
Rating : 4/5 (806 Downloads)

Book Synopsis Strategic allocation of resources using linear programming model with parametric analysis: in MATLAB and Excel Solver by : Dinesh Gupta

Download or read book Strategic allocation of resources using linear programming model with parametric analysis: in MATLAB and Excel Solver written by Dinesh Gupta and published by diplom.de. This book was released on 2014-05-01 with total page 74 pages. Available in PDF, EPUB and Kindle. Book excerpt: Since the late 1940s, linear programming models have been used for many different purposes. Airline companies apply these models to optimize their use of planes and staff. NASA has been using them for years to optimize their use of limited resources. Oil companies use them to optimize their refinery operations. Small and medium-sized businesses use linear programming to solve a huge variety of problems, often involving resource allocation. In my study, a typical product-mix problem in a manufacturing system producing two products (each product consists of two sub-assemblies) is solved for ist optimal solution through the use of the latest versions of MATLAB having the command simlp, which is very much like linprog. As analysts, we try to find a good enough solution for the decision maker to make a final decision. Our attempt is to give the mathematical description of the product-mix optimization problem and bring the problem into a form ready to call MATLAB’s simlp command. The objective of this study is to find the best product mix that maximizes profit. The graph obtained using MATLAB commands, give the shaded area enclosed by the constraints called the feasible region, which is the set of points satisfying all the constraints. To find the optimal solution we look at the lines of equal profit to find the corner of the feasible region which yield the highest profit. This corner can be found out at the farthest line of equal profit, which still touches the feasible region. The most critical part is the sensitivity analysis, using Excel Solver, and Parametric Analysis, using computer software, which allows us to study the effect on optimal solution due to discrete and continuous change in parameters of the LP model including to identify bottlenecks. We have examined other options like product outsourcing, one-time cost, cross training of one operator, manufacturing of hypothetical third product on under-utilized machines and optimal sequencing of jobs on machines.


Strategic allocation of resources using linear programming model with parametric analysis: in MATLAB and Excel Solver Related Books

Strategic allocation of resources using linear programming model with parametric analysis: in MATLAB and Excel Solver
Language: en
Pages: 74
Authors: Dinesh Gupta
Categories: Computers
Type: BOOK - Published: 2014-05-01 - Publisher: diplom.de

GET EBOOK

Since the late 1940s, linear programming models have been used for many different purposes. Airline companies apply these models to optimize their use of planes
Strategic Allocation of Resources Using Linear Programming Model with Parametric Analysis: in MATLAB and Excel Solver
Language: en
Pages: 77
Authors: Dinesh Gupta
Categories: Computers
Type: BOOK - Published: 2014-05-27 - Publisher: Anchor Academic Publishing (aap_verlag)

GET EBOOK

Since the late 1940s, linear programming models have been used for many different purposes. Airline companies apply these models to optimize their use of planes
Strategic Allocation of Resources Using Linear Programming Model with Parametric Analysis
Language: en
Pages: 74
Authors: Dinesh Gupta
Categories: Technology & Engineering
Type: BOOK - Published: 2014-03-31 - Publisher: GRIN Verlag

GET EBOOK

Master's Thesis from the year 2013 in the subject Engineering - Industrial Engineering and Management, grade: Good, LMU Munich (Dr. B R Ambedkar National Instit
Optimization Modelling
Language: en
Pages: 504
Authors: Ruhul Amin Sarker
Categories: Business & Economics
Type: BOOK - Published: 2007-10-15 - Publisher: CRC Press

GET EBOOK

Although a useful and important tool, the potential of mathematical modelling for decision making is often neglected. Considered an art by many and weird scienc
Discrete Choice Methods with Simulation
Language: en
Pages: 399
Authors: Kenneth Train
Categories: Business & Economics
Type: BOOK - Published: 2009-07-06 - Publisher: Cambridge University Press

GET EBOOK

This book describes the new generation of discrete choice methods, focusing on the many advances that are made possible by simulation. Researchers use these sta