Hello-
I am stuck on Excel Solver question.
I have 4 decision variables used to determine thresholds for items to stock in warehouse. From a list of of all items, by changing these variables in any combination, I can identify new opportunities to generate incremental revenue. I have a binary 1/0 for if a particular item is picked up or not by changing the variables. The item needs to check all 4 variable thresholds to be considered.
At the same time, I also have SS calculation to determine additional inventory commitment necessary to potentially support adding these items into stock portfolio.
I would like to figure out the following:
If I have extra $x of inventory to invest, what would be optimal combination of these 4 variables (thresholds) that would generate optimal incremental revenue.
I have built the spreadsheet, but I am unable to generate any results. Solver always optimizes to the starting point.
Please help.
I am stuck on Excel Solver question.
I have 4 decision variables used to determine thresholds for items to stock in warehouse. From a list of of all items, by changing these variables in any combination, I can identify new opportunities to generate incremental revenue. I have a binary 1/0 for if a particular item is picked up or not by changing the variables. The item needs to check all 4 variable thresholds to be considered.
At the same time, I also have SS calculation to determine additional inventory commitment necessary to potentially support adding these items into stock portfolio.
I would like to figure out the following:
If I have extra $x of inventory to invest, what would be optimal combination of these 4 variables (thresholds) that would generate optimal incremental revenue.
I have built the spreadsheet, but I am unable to generate any results. Solver always optimizes to the starting point.
Please help.
