schamskevi
New Member
- Joined
- Mar 3, 2016
- Messages
- 3
Hello,
I am trying to create a formula in MS Excel that will find the average cost per unit using the FIFO costing method based on the units in inventory and a purchase ledger (quantity, price, total etc.). If a purchase is marked as contract I would NOT like it included in the average cost per unit.
Here is the example organized:
Inventory Level 25000
<tbody>
</tbody>
Calculation
2500*1.08= $2,700
$7,475
$11,625
$10,030
+$8,400
$28,605 ÷ 25000 = $1.142
I am trying to create a formula in MS Excel that will find the average cost per unit using the FIFO costing method based on the units in inventory and a purchase ledger (quantity, price, total etc.). If a purchase is marked as contract I would NOT like it included in the average cost per unit.
Here is the example organized:
Inventory Level 25000
Invoice | Contract | Qty | Price | Total |
123456 | 7500 | 1.08 | 8100 | |
123457 | 6500 | 1.15 | 7475 | |
123458 | x | 7500 | 1.55 | 11625 |
123459 | 8500 | 1.18 | 10030 | |
123460 | 7500 | 1.12 | 8400 | |
123461 | x | 6500 | 1.55 | 10075 |
<tbody>
</tbody>
Calculation
2500*1.08= $2,700
$7,475
$11,625
$10,030
+$8,400
$28,605 ÷ 25000 = $1.142