Anyone got a report like this?

My sales Department asked me for a report. They have weekly meetings and
discuss stock levels and market trends for our finished goods. To make
better decisions on what items to put in production they asked for the
following by Part number and filtered by Product group on one report.

1/ Last twelve months sales
2/ Last three months sales
3/ Max / min on all stocked items
4/ Current quantity in production including due dates
5/ Stock on hand
6/ Current sales orders loaded against stocked items

I was hoping some other Vantage user has done a simular report they wouldn't
mind sharing.

Mark Howard
Jaws Buckets and Attachments