Product Forecast by Manufacturer

In D-tools you can see in which projects products are used filtered by time. We want to have a same functionality, but then filtered by manufacturer. In this way we can give our manufacturers a forecast for their supply chain. e.g. we can see which formats displays our distributor and vendor needs to order for quick lead times.