Manufacturing Process (Raw material to Finished Goods)

Dear Support Team

I have a little scenario and need your advice on it. One of my friends company is a manufacturing concern and they are engaged in the manufacture of the nuts and bolts. In the manufacturing process, they input "Steel Wire Rods" as raw material. There are further four processing departments in which steel wire rods is cut into nuts and bolts and are further processed. Finally the nuts and bolts are sent to packing department for sales in small packets.

I need to incorporate this manufacturing process in FA, on batch to batch basis. Cost is incurred at the time of purchase of raw material, in processing department and then in packing department. Following are my reporting requirements:

1) Datewise Report of Inventory in hand (pieces) in each department, on batch to batch basis
2) Datewise Report of cost incurred on batch to batch basis

Please feel free to ask for further queries.