weight+product+manufacture+order Report

I need a report on screen and to excell that can do this >

|Product | manufacturer| From Date | to Date | Total of Kilos of all orders |

This kind of report can help me prepare and request what I need to order to my providers so i can prepare to deliveryrs |

Also make Manufacturer section able to add email.

So once I got the report of the ammount of wieght per product per manufactured m, the sysem can send and email to the manufacture or provider requesting the products

Any help I really appreciate it !