inventory control

ejaz naiyer (C.A. FINAL) (293 Points)

05 February 2010  

The company in which i work is a two wheeler manufacturer. for which i have to maintain at least 100 types of inventory. And i have to maintain it . i want to maintain the inventory in excel. But i am unable to find out any formula for this purpose. i have to maintain opening balance, received, issued and closing balance. can any one tell me how to do it in easy format.