Stock Image

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

Dinesh Gupta

0 ratings by GoodReads
ISBN 10: 3954892804 / ISBN 13: 9783954892808
Published by Anchor Academic Publishing Mai 2014, 2014
New Condition Neu Taschenbuch
From Agrios-Buch (Bergisch Gladbach, Germany) Quantity Available: 2

Available From More sellers

View all  copies of this book

Neuware - 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 many 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 its 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. 76 pp. Englisch. Bookseller Inventory # 9783954892808

About this title:

Synopsis:

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 many 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 its 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 machine

About the Author: The author Dinesh Gupta is a short service commissioned officer of Indian Air Force and obtained his Bachelor's degree in Mechanical Engineering from MotiLal Nehru National Institute of Technology, Allahabad in 1985. He did his M.Tech degree in Industrial Engineering from Dr. B.R. Ambedkar National Institute of Technology, Jalandhar in 2013. He has wide work experience of over 25 years in maintenance engineering and teaching. Presently, working as an Associate Professor in Department of Mechanical Engineering, Dronacharya College of Engineering, Gurgaon. He has one research paper to his credit published in International Journal.

"About this title" may belong to another edition of this title.

Bibliographic Details

Title: Strategic allocation of resources using ...

Publisher: Anchor Academic Publishing Mai 2014

Publication Date: 2014

Binding: Taschenbuch

Book Condition: Neu

Payment Methods

Payment Methods Accepted by Seller

Visa Mastercard American Express

Check PayPal Invoice Bank/Wire Transfer

Seller Agrios-Buch
Address: Bergisch Gladbach, Germany

AbeBooks Seller Since 11 January 2012
Seller Rating 5-star rating


Terms of Sale:

Allgemeine Geschäftsbedingungen (abebooks.de)

der Firma Agrios Buch- und Medienversand UG e.K. ,Geschäftsführer Ludwig Meier, De-Gasperi-Str. 8, 51469 Bergisch Gladbach nachstehend als Verkäufer bezeichnet.

§ 1 Allgemeines, Begriffsbestimmungen

(1) Der Verkäufer bietet unter dem Nutzernamen Agrios Buch unter der Plattform abebooks.de insbesondere Bücher an. Die folgenden Allgemeinen Geschäftsbedingungen (AGB) gelten für die Geschäftsbeziehung zwischen dem Verkäufer und dem Kunden in ihrer zum Ze...

[More Information]

Shipping Terms:

Der Versand ins Ausland findet IMMER mit DHL statt. Auch nach Österreich verschicken wir nur mit DHL! Daher Standardversand == Luftpost!


Detailed Seller Information

Buy New
Price: £ 44.64 Convert Currency
Shipping: £ 8.57 From Germany to United Kingdom Destination, Rates & Speeds
Add to basket