Help Desk & Filling Stations Asset Management System for Ceylon Petroleum Corporation

Abstract

The Ceylon Petroleum Corporation (CPC) was set up as a state enterprise by Act. No. 28 of 1961 in parliament and further amendments carried out subsequently. CPC handles imports, refine and distribution of petroleum products. Also CPC maintain filling stations & consumer points to distribute major products island wide. CPC has more than 1,100 filling stations under two (2) Major Categories. Those filling stations service, repair & maintenance work handle by CPC. When problem / issue, service or maintenance work are required in filling station, dealer has to inform to relevant regional office. Regional office logged the problem manually and prepare M & R work order related to complain. After that regional office staff allocate M & R team & issue required spare items from Regional Office store to do the maintenance. When completing assign job team has handed over remaining items & list of used items with quantities. Then generate invoices & collect payments from dealer. Finally, all payment related details send to head office finance department. Also filling station has many items belongs to CPC (CPC assets) as well as dealer own items. Currently those items recorded in manual inventory book.One of major drawback of this manual system is difficult to track / trace the status of problem and only regional office can handle the problem. (De-centralized operation) Also CPC management or required officers difficult to identify CPC related assets and dealer own items separately. Those issued describe in Introduction Chapter 1)Therefore, Here I proposed computerized error log and asset management system for avoid drawbacks in manual system. Filling station operator have to request, required service via Regional Office, Marketing Function or Customer Care Unit and get the reference number. Based on system reference number any time users can check status of the required service. Items issued for the service, used items, return items, allocated team details, invoice details and payment details also attached with this reference number in different stages. System provide asset registry details, dealer own items and filing station allocated item list in single click.Using deferent fact finding methods I gathered requirements for this system. (This will elaborate in section 3.2.1) This system requirement is clear (There are no uncertain requirements) therefore I used iterative waterfall methodology for this development. I used Dot Net frame work & VB dot net as a programming language. Visual studio 2012 used as Programming Language & Development environment and Microsoft SQL Server usedas system database. Existing CPC communication network used for the connectivity with database & client applications.