The Excel implementation relied on the use of OpenSolver (instead of the standard MS Excel Solver) and VBA macros that aided in the passage of information between pages and in the call of OpenSolver.
Mathematical model
The mathematical model used was as follows
Pages
Frontend: page that receives user input and where the user sees the result
Backend: page responsible for the first part of the optimization process
Backend_: page responsible for the second part of the optimization process
