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...
Your problem has no well-defined optimum. For example, if your selling price were 50% higher than the cost price, you could meet your target by selling 4000 spinach bunches and a sack of spuds. Somewhat improbable, but not ruled out by your model.
What is missing is the link between selling price and volume sold. The latter normally falls as the former increases, giving a maximum somewhere along the line.
