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 the optimum price..thanks!
<colgroup><col></colgroup><tbody>
</tbody>
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 the optimum price..thanks!
10900000 |
11990000 |
13189000 |
14507900 |
15958690 |
17554559 |
19310014.9 |
21241016.39 |
23365118.03 |
25701629.83 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
28271792.82 |
<colgroup><col></colgroup><tbody>
</tbody>