Inventory for my business

[diegocassullo]

Hello everybody!

My name is Diego, from Argentina. First of all, sorry for my english...

I need your help...


I am running an small business using an Excel Administration that I made some years ago for another "services" business.

But the newest has inventories because it is a "productive" business.


I have raw material, labor, work in process, diferent stores, finished product, etc.

I need to know the amount of goods, and the value/cost of them. I think, I will use FIFO method.


I made some sheets but I am not sure if I am ok, or if I am in the right way....

I am sure that there is other ways to do it easier. It's unfriendly.


I would like some expert, help me, looking my model.... and give to me some advise!


Thank you very much


Regards,


Diego,


PD: how can I send you my model???

 

[Luke M]

Posting a workbook info:

http://chandoo.org/forums/topic/posting-a-sample-workbook


As you can probably guess, we'll be able to give better advice once we know more about your specific needs. But, there's plenty of "inventory template" available on the web. Here's one to give you some starter ideas:

http://www.contextures.com/xluserform01.html

 

[blueskysinger]

Yeah, I also sell someting by myslef and I suggest you to use a bacode generator so as to make barcode for your own and put it on your products.http://www.keepautomation.com/products/excel_barcode/barcodes/code_128.html

Saving you both time and money.

 

[blueskysinger]

Yeah, I also sell someting by myslef and I suggest you to use a bacode generator so as to make barcode for your own and put it on your products.http://www.keepautomation.com/products/excel_barcode/barcodes/code_128.html

Saving you both time and money.