Question

3. Solve the following LP problem using Solver in MS Excel. Minimize cost = 50x1 + 10x2 + 75x3 Subject to: x1 - x2 = 1000 2x2 + 2x3 = 2000 x1 ≤ 1500 x1, x2, x3 ≥ 0

Answer 1

ammîng . psoblem canbe solved s The oouoinsoamming pslem tan be selved usTry Cce The dec?Son and λ3. -vaz?ables are xin, The oeci?ve ^unction X1 S 1500 x1,x2,x3 2

The first step Is the formulatlon of the table. Ipp, opportunity loss table, C Insert Page Layout FormulasData Review View Tell me what you 9- wrap Tent Ger s Cut Calibri Paste ·Format Painter B 1 u.-. 2.4. Merge & Center . Font Alignment H17 Minimize Decision variables Total cost 75 S0 10 Constraints 1000 2000 1500 10 12 13

Formulas used pp opportunity los table, Cosalax- Excedl lFroduct Activation Fa Insert Page LayoutFormulas Dats Review Ve Tel me what you want to do.. Home Cut Copy Format Painter BI U Clpboard Conditional Fonmatting % , Alignnen Decision variables 75 SUMPRODUCTID5F5, D6:F6]

Solver Inputs Solver Parameters Set Objective: SGS6 To: Max Yalue Of By Changing Variable Cells: SDS5:SFS5 Subject to the Constraints: Add SGS11 SIS11 SGS9:SGS10 SI59 S1510 Change Delete Beset All Load/save M) Make unconstrained Variables Non-Negative Select a Solving Method Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear, Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Sover problems that are non-smooth. Help Solve Clgse

Flnal answer Ipp, opportunity loss table, C Review ViewTell me what you Home Insert Page Layout Formulas Show Queries From Table Recent Sources AIl Reapply Advanced Columns Properties Get External Nevw Refresh Sort Filter Text to Quey . LO ha, Data . Edit Links Get & Transform Connections Sort & Filter Minimize Decision variables 1500 500 500 Total cost 10 75 117500 Constraints 10001 = 2000E 15001仁 1000 2000 1500 10 12

Psom the finaanwe we can see that the values the x500 X3 : Soo the totalnumcest15 oo.