Material forecasting report

Does any one have report for material forecast?

I have to show in columns

Material on hand Allocated on order for six
weeks


I am able to get just 2 things at atime

Like material on hand + allocated

or

material on hand + on order

or

material on order + allocated.

what should be the links to create a report like that if no one has
that report

I am using part,partbin,partwhse,podetail and porel tables.

Please advise.