Hi,
I read the description and checked the attached document as well.
I'm an industrial engineer with over 15 years of experience in manufacturing and supply chain management, and have already developed several parts of what you need using Excel throughout my past years of experience, including BOM trees and explosion, rough cut capacity estimates and detailed work order planning.
However, if you need a comprehensive solution to cover all the aggregate planning phase, respecting all the constraints mentioned in the attached document you are seeking a mini ERP, this will take time and hard work. I have already some ideas for that.
I'm an advanced Excel user, mainly in this type of work you need.
If you are interested, let's discuss more over the Chat.
Samer