Selling Price Based on Volume

[PeCoo2]

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.

	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!