Please go through the attachment. This will help you to develop the format as per your requirement.
Mainly you have to show how many of pending order as on date and its aging. You can given the reasons in remarks column if any delay happened apart from the lead time.
From India, Selam
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
1
MIS Report.xls