A ship management company typically is engaged by ship owners to operate their tanker ships within a strict yearly budget. This company approached us to improve their Excel expense tracking tool for a fleet of 20 ships. We found the following problems: –
- Contained lots of worksheets which confuse the user.
- Manual entries caused frequent errors.
- A long vendor list which made it frustrating to update accurately.
We worked closely with the Technical Director to create an Excel based application that makes it easier for the admin staff to enter expense data to reduce errors and time. In addition, a reporting module was created for the director to create separate expense reports for each vessel. Overall, we manage to reduce Excel worktime from 3days to less than 2hours on a weekly basis.
About Aeternus Consulting
Aeternus Consulting is a Microsoft Office consultancy and & digital creative agency. We specialise in Microsoft Office training, VBA application development, Business modeling in Excel, infographic designs, data visualizations and web UX UI.
Related Link: Aeternus Consulting Singapore