Future Stock Report?

Morning all,

My company sells mainly from stock in the warehouse (as opposed to drop shipping). We regularly have a situation where stock runs out in the warehouse but we have a series of purchase orders that are due over the next 3 months.

i.e. 30 on PO ETA 1st Sept,  30 on PO ETA 1st Oct etc etc etc


I need a report that shows the following information (for lots of items)

________Qty In_Qty________On______________________<-----Due---->
Item____Stock__Allocated___Order___Balance__________1-Sep____1-Oct

#1______10______5________0________5_______________10_______10

#2______100_____100______150_____-150_____________75_______75




Basically I need a report that my sales office (and directors) can look at and at a glance see if we have stock of an item, if we are oper sold, and if we are over sold WHEN the stock is going to come in.