SavingsJoe
New Member
- Joined
- Jul 9, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi
I have a sheet with the cost of the goods we purchased, my current stock is 160 apples and 90 oranges how do i calculate the cost of each item which are currently in stock, I dont want the average cost from the first purchase, this should be the calculated using the cost of the latest purchase, so for the apples it would calculate 120 @ £1.65 and 40 at £1.52
thanks
I have a sheet with the cost of the goods we purchased, my current stock is 160 apples and 90 oranges how do i calculate the cost of each item which are currently in stock, I dont want the average cost from the first purchase, this should be the calculated using the cost of the latest purchase, so for the apples it would calculate 120 @ £1.65 and 40 at £1.52
thanks
Date | Item | Qty | Cost |
01/01/20 | Apples | 120 | £1.81 |
01/01/20 | Oranges | 120 | £1.28 |
03/03/20 | Apples | 120 | £1.52 |
03/03/20 | Oranges | 120 | £1.35 |
06/06/20 | Apples | 120 | £1.65 |
06/06/20 | Oranges | 120 | £1.34 |