Questions tagged [excel]
The excel tag has no usage guidance.
7
questions
4
votes
1answer
66 views
How would you linearize this scheduling problem? Or how would you solve this? It is variation of a set coverage problem for OpenSolver
So, it's been about 15 years since I took my OR class in college. I'm not versed in any programming language besides a little bit of VBA.
A client of mine is looking to solve the following problem. I ...
6
votes
2answers
194 views
How can I maximize the sum of norm.dist values using solver?
EDIT #2 5/17/2020: I re-phrased my question once more. My original question is still at the end. Thanks for the feedback.
I want to know if it's possible to maximize the sum of cumulative ...
4
votes
3answers
522 views
Job shop scheduling advice
I changed jobs recently to a manufacturing firm. Job shop scheduling is made 100% manually and intuitively in Excel. Very time consuming and they have no idea if the schedule made is something close ...
3
votes
1answer
90 views
Problem solving a linear program using Excel
The exercise is as follows:
ACI has decided to put an order for golf shoes twice every year and
expects to receive one shipment of $960$ pallets of shoes by the
beginning of January and another ...
3
votes
1answer
98 views
Graphical illustration Excel
I have formulated a linear optimization model and solve it using the Excel Solver.
How can I illustrate the slacks vs usage?
3
votes
1answer
54 views
Iterative calculus with Excel - N° 2
In continuation with the previous post, I propose you another problem.
I have this model:
\begin{align}\min&\quad F\\\text{s.t.}&\quad
F-(1150x_{B_{1}}+1000x_{B_{2}}+1350x_{B_{3}}-S_{1})=430\...
3
votes
1answer
232 views
Iterative calculus with Excel
I have this model:
\begin{align}\max&\quad\small{(0.2(1.07)^{-1}+0.2(1.07)^{-2}+0.9(1.07)^{-3})x_A+0.4(1.07)^{-1}+0.5(1.07)^{-2}+0.3(1.07)^{-3})x_B}\\&\quad 0.2x_{A}+0.4x_{B}\geq300\,000
\\&...
