Hi
I am working as a consultant for production planning and detailed scheduling for couple of MNC factories.
Creating production efficiency report, analysis report, raw material inventory inputs and finished product out calculation templates and integrating the same in a master sheet, i something i do for my living.
I have made many such excel based templates for many big production houses. My rates will be bit high than normal, as i am sure you will get more than what you need.
If you can trust me let me know the details.