Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show decreases and increases | Charts and Charting in Excel | |||
Graph with stepped increases or decreases | Charts and Charting in Excel | |||
Conditional Formatting - Increases/Decreases | Excel Discussion (Misc queries) | |||
Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
How can I increase value in one cell as value in other decreases? | New Users to Excel |