View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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...