Fuel Station ERP System
GladSystems is a company in the downstream oil and gas sector that operates a retail outlet selling gasoline (petrol), diesel, and motor vehicle lubricants.
- GladSystems
- Oil and Gas
//Information Architecture //Custom CMS Development //Membership Management //Robust Data Structure //Process Automations //Custom Inventory Management //Dashboard & Dynamic Data Visualization
The fuel station needed an ERP that allows their pump attendants to submit their different sales and expense records via their secured portal. The expense records are either recorded at the time of disbursing the funds, or at any convenient time. We also had instances when fuel price changes within a single day, and for this occurrence, total income must be accurately captured. Additionally, we were required to set up a robust inventory management system that handles product procurement, sales and FIFO (First-In-First-Out) batch management in real-time.
The fuel station needed an ERP that allows their pump attendants to submit their different sales and expense records via their secured portal. The expense records are either recorded at the time of disbursing the funds, or at any convenient time. We also had instances when fuel price changes within a single day, and for this occurrence, total income must be accurately captured. Additionally, we were required to set up a robust inventory management system that handles product procurement, sales and FIFO (First-In-First-Out) batch management in real-time.
We built the platform on an easy-to-use CMS, adopting data management and security best practices, and also allowing for ease of use by the admin and other staff members.
We had the assignment of studying their entire system to see how they run manually, how pump attendants take their records, how they handle price changes that sometimes happen in a single day, how they record debts and expenses, how different income channels are captured (Cash, POS, Transfer), and how accounts are balanced on a day-to-day basis.
We ensured full access control, user permissions and privileges, and unique workflows for each user role in ways that align with our client's unique business model and modes of operation.
We set up lots of counters, dynamic forms, dynamic tables, elements with dynamic visibility, all powered by several SQL queries pulling data from the database.
We built dynamic dashboards that help them visualize each pump's data using the pump ID and get records for any desired date range, and for monitoring and tracking lubricant inventory in real time. For low inventory, the system also sends daily email notifications to help the company keep track of low inventory in real-time.