Hello all,
I have extensive experience with Excel but am fairly new with Excel Solver. I have been trying to make a sheet to come up with an optimal combination of hotel rooms to maximize revenue. The issue I have been running into is that Solver is not coming up with the optimal solution. I do not know if it is an issue with my settings or how I have set up the spreadsheet or simply an issue with Solver. I have gone through numerous blogs and websites to try to find my mistake but have not had any success. I have attached the file. If you guys could take a look and let me know where I am going wrong it would be greatly appreciated!
