Forum Discussion
Using Solver to solve selling price and quantities to achieve the target amount
Hello guys, Am trying to solve a task I was issued by a client yesterday. Am basically trying to solve for what is the best selling price for each unit and how much quantity can one sell in order to...
To illustrate the idea, I have assumed a volume of sales at cost and applied an exponential drop-off in volume as the price increases. I am not an economist so how good these assumptions may be is out of my area. I have allowed non-integer sales volumes to avoid unnecessary discontinuities that will upset Solver.