Pricing decreases as quantity increases- how to do that
I think the OP was looking for the slope of the line formed by the two
purchases to project a third point.
Jim Thomlinson wrote:
Depends. In inventory management there is FIFO, LIFO and Average Cost.
Assuming your first purcahse was 100lb and the second 127lb
FIFO First In First Out
100 * 3.50 + 85 * 3.02
LIFO Last In First Out
127 * 3.02 + 58 * 3.50
Average Cost
((100 + 127) / ((100 * 3.50) + (127 * 3.02))) * 185
Check with your accountant as to which one they recommend. Regarless which
one you choose it gets a bit messy in a spreadsheet...
|