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! |
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 |
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! |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com