service
216 Points
Joined July 2008
Hi Manish,
Well I am not in oil exploration or oil manufacuring organisation, but I will suggest that most of the companies have there own MIS systems. MIS is nothing but information required by higher management.
In MIS, rather I would prefer you to work on with your seniors and build your management desired customised MIS. Which will be more useful.
At macro level I can comment on like, It should provide you all the process, intermediate product costing with detailed allocation of variable cost and fixed cost. It can be in the form of matrix. One side Rawmaterial name in variable coloum and fixed cost. Horizontallty you can keep product name.
Particular 1st Product 2nd Product 3 Product 4th Product total
Variable cost
Raw material
Fixed cost
Admin
Personal cost
others
Total
In the above matrix, this 1st Product may be your 1st intermediate product which will become raw material for next 2nd Prouct. and so on.
I believe you can make this in excel and with linking details and working with trial balance.
If any query pl contact on this no. 9703508765. I will try to help you out.