Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) |
Minimize Z | = | 4A + 6B. | |
7A + 13B | ≥ | 100 | |
2A + 12B | ≥ | 38 | |
4B | ≥ | 20 |
Decision for A | |
Decision for B | |
Total cost | $ |
Resources Used | |
A | |
B | |
C | |
Using excel solver to solve the LP,we get the following output:
In excel :
F4=4*B3+6*C3
D7=SUMPRODUCT(B3:C3,B7:C7)
D8=SUMPRODUCT(B3:C3,B8:C8)
D9=SUMPRODUCT(B3:C3,B9:C9)
Decision for A=0
Decision for B=7.69
Total cost=z=$ 46.15
Calculations are as shown below:
Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) Minimize Z = 4A + 6B. 7A...
Problem A-2 Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "O" wherever required. Round your answers to 2 decimal places.) Minimize 2 = 7A + 6B. 3A + 9B 2 70 Resource X 2A + 13B 234 Resource Y 4B 2 15 Resource Z Decision for A Decision for B Total cost Resources Used Resource X Resource Y Resource Z
Question: Decision for A: Decision for B: Total Profit: Resources used for: Resource X: Resource Y: Resource Z: Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "o" wherever required. Round your answers to 2 decimal places.) Minimize 2 - 4A + 28. 2A + 168 > 8e Resource X SA - 168 36 Resource Y 38 25 Resource Z
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+ Ху number) whole to the nearest b. Solve these equations using the Excel Solver. (Round your answers Decision for X Decision for X2 Decision for X3...