Selling Price Based on Volume

PeCoo2

New Member
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!

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Replies
10
Views
121
Replies
17
Views
536
Replies
3
Views
281
Replies
3
Views
434
Replies
2
Views
265