PART - III
by N. R. Jayaraman )
Thus once the data base has been created for all the items in the above manner the first part of ERP is ready for further programming. Once the data entry is completed suitable software programme can be incorporated to generate the following information in respect of each item/ store (item). If more information other than the below is required it can be incorporated. Remember this is only in respect of the items which are procured and its accounted.
Data required per item:1.
List of Vendors 2.
The firms which supplied the said item against the last S.O 3.
Firms which supplied the particular item during last five years 4.
List of tenders floated 5.
Status of the tenders recently floated 6.
Tender due dates and opening dates 7.
How many responses were received against each8.
The lowest offer10.
Order on whom placed11.
Quantity on order 12.
Date of issue of last supply order 13.
The supply order pending 14.
Whether supplies have been completed 15.
If Part supplied, then the position against supply order 16.
The status of inspection 17.
Has the item been accepted or rejected 18.
Reasons for rejection if any 19.
Date of issue of rejection letter 20.
Stock level 21.
Unit for which it was procured 22.
The list of suppliers who failed to supply against supply order 23.
Pending payments against supply orders 24.
Re Order level 25.
The data should appear something like the following on the Monitor screen. The ERP expert will work out suitable model based on the requirement to be generated.
See below how the details are shown
In addition to the information per item as stated above, data may be required in the following manner for few or all the items for administrative and analysis purposes. Similar Index with required data will be prepared and used to get the following data.
1. All the Items purchased in a particular year
2. Entire Supply orders with due dates of supply.
3. Entire supply order position –part, full or failed
4. Tenders under process
5. Tenders already floated with due dates
6. Tenders finalized for S.O
7. Total cost of items group wise i.e A, B, C, D etc
8. Pending payments against supply orders
9. The consolidated position of rejected stores
10. The list of suppliers who failed to supply
11. The list of material under repeat or optional order
12. List of stores rejected as on date
13. Complete list of Vendors
14. The status of inspection of items
15. As on date which are the items that have reached the order level.
It is not an easy task for the ERP consultant to re module the programme if readily available. However they can work out a tailor made program and give you once the requirements are clearly defined and given. What has been suggested above are all illustrative model to guide the organization and it is for the individual user Organization to work out their requirement after getting the Organizational structure and working well studied by some experienced person. But once done the working will be a very smooth affair and with a click of button the entire data will be available at a single point source and help the organization cut down wasteful expenditures.
In order to get the above data enter only the Code of the item to get the required information. What inputs will be required to be fed in the data bank to get the formation as above and how will they be linked ?
...........To be continued