We need to find the optimum monthly Cost(cost effective) by changing order quantity and Re-Order points for a warehouse.
So I created the table on the right hand side and I want write an Excel or VBA function so that
every cell of the table will look at the order quantity value and Re-order point value from the graph, simulate the monthly cost and then print the coresponding monthly cost in each cell of that table.
any help would be appreciated.
Running scenario manager for each case is not practical since I have to set parameters for each case by hand.