Hi All,
I am trying to calculate an average selling price of a component based on the volume sales, I have an overall selling price and I want to vary the according to volumes sold per customer per year.
<tbody>
</tbody><colgroup><col><col span="13"></colgroup>
Thanks!
I am trying to calculate an average selling price of a component based on the volume sales, I have an overall selling price and I want to vary the according to volumes sold per customer per year.
2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | ||
Sprocket | |||||||||||||
Base Selling Price | 1.19 | 1.05 | 0.94 | 0.87 | 0.80 | 0.76 | Units Shipped | ||||||
Customer 1 | ??? | 0.0 | 0.0 | 0.5 | 1.0 | 1.1 | 1.5 | ||||||
Customer 2 | 0.0 | 0.2 | 0.4 | 0.7 | 0.9 | 1.2 | |||||||
Customer 3 | 0.0 | 0.0 | 0.0 | 0.1 | 0.2 | 0.2 | |||||||
Customer 4 | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | |||||||
Customer 5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
Customer 6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
Customer 7 | 1.0 | 5.0 | 8.0 | 11.7 | 15.2 | 18.7 | |||||||
Customer 8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
Customer 9 | 100.0 | 120.0 | 129.0 | 145.3 | 159.8 | 174.3 |
<tbody>
</tbody><colgroup><col><col span="13"></colgroup>
Thanks!