Posted 20 August 2012 - 02:35 AM
saltech,
Are you a student? Because this seems like some homework assignment given to you. If yes, then you should not be posting your query in the industrial professionals forum; it should be posted in the students forum.
We here would like to know what efforts you have put out to solve this problem? Or are you expecting somebody else to do your work and provide you a readymade answer? Aren't you doing an injustice to yourself? How do you expect to be a professional engineer if you want sombeody else to do your work without making an attempt to solve it yourself?
Why don't you prepare an Excel sheet yourself and post it here for review? There will be plenty of people who will be ready to provide corrections or suggestions to the solution generated by you. I can tell you that expecting your work to be done in the first place by somebody else is not going to generate much sympathy to your cause.
Come back with your own solution, post it, and I can assure you plenty of people will help in corrections and suggestions.
Regards,
Ankur.