| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
work out for First-in-first-out cost
I'd like to set a worksheet to work out the costa for goods sold of numbers
of goods which are with two different costs. For example, Item A, 100 pcs are with cost of $100 and 50 pcs with cost of $120. In January, 85 pcs Item A sold, the cost of goods sold is expected - 85*$100; In February, 35 pcs Item A sold, the cost of goods sold is expected - 15*$100+20*$120. There are numbers of goods like this. How can I set a worksheet with the formula working out the costs of goods sold? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
work out for First-in-first-out cost
Should anyone has the idea to set the worksheet ?
"yclhk" wrote: I'd like to set a worksheet to work out the costa for goods sold of numbers of goods which are with two different costs. For example, Item A, 100 pcs are with cost of $100 and 50 pcs with cost of $120. In January, 85 pcs Item A sold, the cost of goods sold is expected - 85*$100; In February, 35 pcs Item A sold, the cost of goods sold is expected - 15*$100+20*$120. There are numbers of goods like this. How can I set a worksheet with the formula working out the costs of goods sold? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Current Cost versus Original Cost | New Users to Excel | |||
| our cost to customers cost | Excel Worksheet Functions | |||
| our cost to customers cost | Excel Worksheet Functions | |||
| Confusion on adding percentage of cost to that cost. | Excel Worksheet Functions | |||
| What Bus. templete do I use for daily cost w/ daily & cum cost ? | Excel Discussion (Misc queries) | |||
Linear Mode
