Homework SourseSolve the following problem with Excel Solver Leave no cells
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.)
| 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.) |
Solution
The solution to the problem is given as
Therefore, the answers is
| Objective Function | Minimize 3A+4B | 40.28 | ||
| A | B | |||
| Decisison | 4.89 | 6.4 | ||
| Constraints | 4A+10B>=57 | 83.58 | 0 | 0 |
| 9A+5B>=59 | 76.05 | 0 | 0 | |
| 2B>=12 | 12.80 | 0 | 0 |
![Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter \](/WebImages/43/solve-the-following-problem-with-excel-solver-leave-no-cells-1135738-1761607835-0.webp "Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter \")
