Dear seniors,
Greetings of the day,
This is the third time i m posting my question to my seniors.
I am working the leather chemicals manufacturing company in kanpur.I want to prepare mis format for reporting on daily basis to directors.
I want to report daily regarding followings
raw material inward (there are 300 items)
raw material issued to particular prodution division (as per production chart, three are 4-5 different division)
raw material received back from prodution division
total raw material issued to production unit
total finished goods received to checking /packing department from manufacturing unit
total finished goods packed
total finished goods dispatched to distributor
i want everything on one excel sheet where there should have automatic calculation of raw material stock as per item like i will insert opening stock plus inward less issue
than finished goods received from production unit (model wise/colour wise)
less totla dispatched finished goods.
expecting help from all of you.
Thanks
regards
Priya
Greetings of the day,
This is the third time i m posting my question to my seniors.
I am working the leather chemicals manufacturing company in kanpur.I want to prepare mis format for reporting on daily basis to directors.
I want to report daily regarding followings
raw material inward (there are 300 items)
raw material issued to particular prodution division (as per production chart, three are 4-5 different division)
raw material received back from prodution division
total raw material issued to production unit
total finished goods received to checking /packing department from manufacturing unit
total finished goods packed
total finished goods dispatched to distributor
i want everything on one excel sheet where there should have automatic calculation of raw material stock as per item like i will insert opening stock plus inward less issue
than finished goods received from production unit (model wise/colour wise)
less totla dispatched finished goods.
expecting help from all of you.
Thanks
regards
Priya