Linear Programming Using Excel
Subject: Linear Programming using Excel Application: Microsoft Excel 2007 Task: Solving a Linear Program Using Excel Tutorial Date: 25th February, 2010 by Nathan Smith

Install the Solver Add-In

1. In the Microsoft Office button, go to excel options to click Add-ins 2. In the Add-Ins box, select Solver Add-In and click Go...

Linear Programming Using Excel - 1

Install the Solver Add-In (continue)

3. In the Add-Ins available box, check the Analysis ToolPak and then OK

Linear Programming Using Excel - 2

Setting Up the Problem on the Spreadsheet

Example Min Z = 6X + 7Y s.t 2X + 6Y â‰¥ 10 5X + 3Y â‰¥ 10 X,Y â‰¥ 0

Linear Programming Using Excel - 3

(continued)

1. Enter the coefficients of the objective function Z i.e., (6, 7) in cells E5 and F5. 2. Enter the coefficients of the Constraint-1 i.e., (2,6) and RHS value 10 in cells E9, F9 and H9 respectively 3. Enter the coefficients of the Constraint-2 i.e., (5,3) and RHS value 10 in cells E10, F10 and H10 respectively

Linear Programming Using Excel - 4

(continued)

1. For the Objective function value, enter the formula for computing Z = SUMPRODUCT(E5:F5,E6:F6). This formula uses the coefficient values and also the solution values for variables X and Y, which are supposed to be solved. 2. Similarly enter the formula for LHS of the Constraints 1 & 2 i.e., SUMPRODUCT(E9:F9,$E$6:$F$6) & SUMPRODUCT(E10:F10,$E$6:$F$6) respectively

Linear Programming Using Excel - 5

Now Excel Solver will be used, in the Data tab click Solver. The solver box appears as follows.

(continued)

1. Set the Target Cell for the Objective Function Z value i.e., $E$7 2. Check the Equal to Min i.e., Minimum Option. 3. For Changing Cell, select the solution values of the variables X & 7 i.e., $E$6:$F$6 Linear Programming Using Excel - 6

4. For subject to the constraints, LHS >=RHS i.e., click on the Add option and select $E$13:$E$14 >= $E$13:$E$14 5. Also all the...

...The development of linearprogramming has been ranked among the most important scientific advances of the mid 20th century. Its impact since the 1950’s has been extraordinary. Today it is a standard tool used by some companies (around 56%) of even moderate size. Linearprogramming uses a mathematical model to describe the problem of concern. Linearprogramming involves the planning of activities to obtain an...

...RESEARCH PAPER ON
LINEARPROGRAMMING
Vikas Vasam
ID: 100-11-5919
Faculty: Prof. Dr Goran Trajkovski
CMP 561: Algorithm Analysis
VIRGINIA INTERNATIONAL UNIVERSITY
Introduction:
One of the section of mathematical programming is linearprogramming.
Methods and linearprogramming models are widely used in the...

...TOPIC – LINEARPROGRAMMINGLinearProgramming is a mathematical procedure for determining optimal allocation of scarce resources.
Requirements of LinearProgramming
• all problems seek to maximize or minimize some quantity
• The presence of restrictions or constraints
• There must be alternative courses of action
• The objective and constraints in...

... LINEARPROGRAMMING
DATE;
5 JUNE, 14
UNIVERSITY OF CENTRAL PUNJAB
INTRODUCTION TO LINEARPROGRAMMINGLinearprogramming (LP; also called linear optimization) is a method to achieve the best outcome (such as maximum profit or lowest cost) in a mathematical model whose requirements are represented by...

...LINEARPROGRAMMING
INTRODUCTION:
The term ‛programming′ means planning and it refers to a particular plan of action amongst several alternatives for maximizing profit or minimizing cost etc. Programming problems deal with determining optimal allocation of limited resources to meet the given objectives, such as cost, maximum profit, highest margin or least time, when resources have alternative uses.
The term...

...EXCELSOLVER TUTORIAL
Many firms face the problem of how to best use multiple scarce resources. Linearprogramming is designed to help find the product mix that maximizes profits in the short run when multiple constraints exist. While linearprogramming can be solved as a mathematical problem using pencil and paper, it is much more efficient to use ExcelSolver. The key to...

...Spreadsheet Modeling and ExcelSolver A mathematical model implemented in a spreadsheet is called a spreadsheet model. Major spreadsheet packages come with a built-in optimization tool called Solver. Now we demonstrate how to use Excel spreadsheet modeling and Solver to find the optimal solution of optimization problems. If the model has two variables, the graphical method can be used to solve the model. Very few real...

...LinearProgramming History of linearprogramming goes back as far as 1940s. Main motivation for the need of linearprogramming goes back to the war time when they needed ways to solve many complex planning problems. The simplex method which is used to solve linearprogramming was developed by George B. Dantzig, in 1947. Dantzig, was one in who did a lot of work on...

372 Words |
2 Pages

Share this Document

{"hostname":"studymode.com","essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_1.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":false,"site_id":1,"autoComplete":false,"isPremiumCountry":false,"userCountryCode":"US","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":35061874,"categoryName":"Software Development","categoryParentId":"5","currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":3,"pageRange":"1-3","totalPages":3}},"access":"premium","title":"Excel Solver for Linear Programming","additionalIds":[3,17,52,27],"additional":["Business \u0026 Economy","Literature","Business \u0026 Economy\/Organizations","Sports \u0026 Recreation"],"loadedPages":{"html":[],"text":[1,2,3]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/Excel-Solver-For-Linear-Programming-766264.html","pagesPerLoad":50,"userType":"member_guest","ct":10,"ndocs":"1,500,000","pdocs":"6,000","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.studymode.com\/signup\/","joinUrl":"https:\/\/www.studymode.com\/join","payPlanUrl":"\/checkout\/pay","upgradeUrl":"\/checkout\/upgrade","freeTrialUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fcheckout%2Fpay%2Ffree-trial\u0026bypassPaymentPage=1","showModal":"get-access","showModalUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fjoin","joinFreeUrl":"\/essays\/?newuser=1","siteId":1,"facebook":{"clientId":"306058689489023","version":"v2.8","language":"en_US"},"analytics":{"googleId":"UA-32718321-1"}}