optimum

Hi! I need to find the optimum price for a specific amount of sales in the time of 20 years. These are the amount of sales throughout the 20 years. I have this formula in order to find the optimum price and market share...MS = 44.971* 2.50 / PNB – 24.867. What excel function can I use to find...

When we run solver, we get the final (optimum) solution. While sover is running, it calculates the values for multiple points and settles on the optimum one. Is there a way to save all the values that solver tries to a range in the excel sheet, along with the optimum solution. Thanks.

Hello The Scenario: the company I work for have four main customers who near the end of every month will e-mail a list of the stock they want, the maximum quantity they can accept and the price they can afford to pay per unit. Say for example we have 28 units of one item and the customers have...