ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Solver Priority (https://www.excelbanter.com/excel-worksheet-functions/246297-solver-priority.html)

KSA

Solver Priority
 
I have a total of montly requirements for a year that I need to distribute
into 5 different subcategories by month. I can not exceed my monthly
capacity nor the maximum order for each subcategory. I want to fill one
subcategory before moving to the next. I can get a valid anwer using solver
but I can not get it to fill the first subcategory before the second and so
on. Solver starts filling the third bucket first. Is there a way I can
prioritize or sequence this such that the first category get filled before
moving to the second?


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com