Questions tagged [excel]

For questions related to the use of Excel and the Excel solver. The Excel solver is an add-in that allows the solution of linear programming problems, such as product mix problems (whether maximization or minimization), transportation problems and problems for the allocation of scarce resources. The spreadsheet is easy to use and fast to raise the model. It can obtain the reports of the optimal solution and the sensitivity analysis in a matter of seconds.

Filter by
Sorted by
Tagged with
6 votes
1 answer
1k views

Linear Programming: Integer and non-integer decision variables

I am looking for an answer to a question I can't quite get behind. I am given the following mathematical optimization problem: \begin{align}\min&\quad\sum_{t\in T}s_t\cdot z_t+h_t\cdot i_t+p_t\...
coar's user avatar
  • 133