Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate unit cost
I have different lot of products imported with different unit costs, how can
I calculate the unit cost of inventory held based on First in First out basis. Please help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate unit cost
Hi,
Since the answer depends a lot on the exact structure of your own spreadsheet, for inspiration purposes, just take a look at a previous post ... http://groups.google.com/group/micro...10e848fa cf4e HTH |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate unit cost
Isn't that an accounting issue. There are software packages designed to
handle inventory that will do the job. It becomes complicated to take each sales and match it against the first In. It can be done. I had a similar problem where a person owned a gas station and was trying to figure the value of his gas inventory on a daily bases. If you have a column in your spreadsheet for the remaining quantity and the purchase price then the problem is simply a worksheet probelm. You multiply the quantity times the price to get the total. Then have a grand total the sums all the individual totals. "Kelvin" wrote: I have different lot of products imported with different unit costs, how can I calculate the unit cost of inventory held based on First in First out basis. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a total cost chart where a component cost is a step cost | Charts and Charting in Excel | |||
calculate the diffrence in cost | Excel Worksheet Functions | |||
Calculate X1-5 and Y? If total cost is given. | Excel Discussion (Misc queries) | |||
Conditional Formula - calculate only if net unit is zero | Excel Worksheet Functions | |||
Calculate time and cost | Excel Worksheet Functions |