Question

Problem A-3 firm has di excess production capacity was created as a result. Management is considering devoting this excess capacity to dne or more of three products. Xi.ぬand X- INE TYPE MACHINE H 210 Unit profits for the three products are s 12 15 - be a. Set up the to nter wereverqu X2+ Ху

Answer 1

a)

Decision Variables X1 X2 X3 4 Objective function Maximize total profit 7 12 A4+15 *B4+8 C4 Constraints 860 600 210 80 11 1*A4+3 B4+3*C4 12 C4 13

1 Decision Variables 2 Number of units of each product X1 X2 X3 4 5Objective function 6 Maximize total profit C) Constraints C) C) C) 0 860 600 210 80 10 12 13

Solver Parameters Set Objective To: ⓔMax OMin。Value Of: By Changing aiable Cells: SAS기 SAS4:SCS4 Subject to the Constraints: SAS4:SC$40 SAS9:SAS12 <= SCS9:SCS12 Add Change Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a SolvingSimplex LP Method: 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 Solver problems that are non-smooth. Help Solve Close

1 Decision Variables Number of units of each product X1 200 X2 X3 4 5Objective function 6 Maximize total profit 7 2400 0 0 Constraints 10 600 11 200 12 13 210 0

b)

Decision for X1 Decision for X2 Decision for X3 Total profit 200 C) C) 2400 Resources used 600 600 200 C) Milling Lathes Grinder Sales

c)

S1	260
S2	0
S3	10
S4	80

d-1)

Milling Lathes Grinder No Yes No

d-2) X3 will not be at maximum sales capacity