About this document
Excel Solver for Optimization Problems by Chandrabali Saha is a document available to read on EtoBox.
This document discusses using Excel Solver to solve optimization problems. It provides two examples: a linear investment allocation problem and a nonlinear network flow problem involving hazardous material transportation. For each problem, it formulates the mathematical model, translates it into a spreadsheet, and uses Solver to find the optimal solution. The linear problem involves allocating funds across five bonds to maximize return while meeting constraints. The nonlinear problem involves finding the lo
- Author
- Chandrabali Saha
- Language
- EN