Stock on hand versus Ordered

Hi all

I would like to write a report in Crystal and below is the information:

I want to write a report which will highlights stock orders versus what is on hand & with back orders so that I can see at a glance across the whole range where there may be serious gaps of items we may need to order or are going to fall short? Highlighted in red would be what should stick out at me! It is similar to the replenishment plan but I want it to cover every product in range?

Looking forward in your assistance.

Regards,

Aubrey