# how to make item first bought, first sell and calculate cost that way

#### remon

##### New Member
i buy and sell 4 items no more, the problem is the items prices changes everytime i buy it.
let's say one of the items is a "sugar" ... i bought it yesterday for 1\$ for 1kilo and i bought 50, then after a week 2\$ for 1 kilo and i bought 50 etc...
when i sell 30, it costs me 30\$ cuz it came from my 1st purchase. then i sold 60 it means 20 for 20\$ from 1st purchase and 40 for 80\$ from the 2nd purchase.
i need to make a sheet that calculate the cost price of every sell process based on 1st bought 1st to sell.
any ideas ???

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Replies
0
Views
127
Replies
1
Views
386
Replies
2
Views
344
Replies
3
Views
389
Replies
5
Views
1K

1,136,909
Messages
5,678,514
Members
419,768
Latest member
eguechi09x

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back