HW-3 Part 1 (15 points: 3 points for each problem) You don’t need to solve the f

HW-3
Part 1 (15 points: 3 points for each problem)
You don’t need to solve the following questions using either Solver or Analytic Solver.
Define the decision variables, the objective functions, and the constraints for all problems.
Problem #13 (P 116):
(a) Define the decision variables, (b) Define the objective functions, (c) Define the constraints
Problem #15 (P 117)
(a) Define the decision variables, (b) Define the objective functions, (c) Define the constraints
Problem #18 (P 118)
(a) Define the decision variables, (b) Define the objective functions, (c) Define the constraints
Problem #20 (P 119)
(a) Define the decision variables, (b) Define the objective functions, (c) Define the constraints
Problem #21 (P 119)
(a) Define the decision variables, (b) Define the objective functions, (c) Define the constraints
Part 2 (5 points)
Determine an optimal solution using either Solver or Analytic Solver.
1.Let X1 = number of softballs to produce, X2 = number of baseballs to produce (2 points)
MAX6 X1 + 4.5 X2
ST5X1 + 4 X26000
6 X1 + 3 X25400
4 X1 + 2 X24000
2.5 X1 + 2 X23500
1 X1 + 1 X21500
X1, X20
Answer: X1 = , X2 = , Objective function =
2.Let M1 = number of electric trimmers to make(3 points)
M2 = number of gas trimmers to make
B1 = number of electric trimmers to buy
B2 = number of gas trimmers to buy
MIN55M1 + 85M2 + 67B1 + 95B2
STM1 + B1 = 30,000
M2 + B2 = 15,000
0.20M1 + 0.40M2 10,000
0.30M1 + 0.50M2 15,000
0.10M1 + 0.10M2 5,000
M1,M2,B1,B2 0
Answer: M1 = , M2 = ,B1= , B2=
Objective function =