Operational Analysis
Includes reports with a more operacional overview of the business, in which will be listed the quantities of the cargo by port and cargo type.
Financial Analysis
Global overview in terms of billing and financial results.
Information is extracted from transactional (TPS), operational (Maeil Transporter) and financial (Dynamics NAV) systems, presented to the user in a format easily understandable and offering several possibilities for filtering, grouping, drill-down, handling of information subscription.
Here are some maps available OLAP designed model:
1. Monthly reports (for the previous month)
a) TEU's listings per customer, traffic and global (all traffic)
b) Listing of results (invoicing) per customer, traffic and global (all traffic)
c) Listing of profitability per customer, traffic and global (all traffic)
2. Monthly reports (for the current month)
a) Ranking (top 10+) of each of the three above listings.
b) Maps of the results based on the management.
3. Monthly reports (- 2 months)
a) BLs with negative results.
4. Monthly and total TEUs listings, compared with homologous period, per line and type of service (import/export).
5. Monthly and total TEUs listings, per year, including TEUs total results (import + export), with accumulated values.
6. Cost maps of representation, cars and mobile phones per employee and the possibility to filter by month and by year.
aity to filter by month and year (additional financial maps).
7. Financial Map (executive budget) with results for costs and expenses, by type of cost and accumulated amount. Lists with programmed budget for the year in question (additional financial maps).
8. Map of profitability per customer and traffic + homologous periods.
9. Map of profitability per customer and traffic + homologous periods with monthly statistics.
10. Average TEU's map by BL, by number of BL's, by ship and by travel, with a monthly graphic, and with comparison with homologous periods.
11. BL's map, by trade, of import and export.
12. Maps of scales, per service, for homologous periods.
13. Movement map of containers (loaded and discharged).
14. Operation's map (number of hours, medium, full and empty, transshipment) by ship and travel.
15. Volume Movement's map in parks with comparison with homologous periods.
16. Maps by trade (month / year) with information on BL, POL, POD, Date, TEU's and final result.
17. Map of processes for import and export, monthly.
18. Map of cross-bookings (annual, in comparison with homologous periods).
19. Map of land transport (by month / year).
20. Weekly report (with information on the annual budget, for import and export) and comparison with homologous periods.
21. Maps of costs by department.
22. Map of demurrage and storage.
23. Map of estimated / real revenue (export, import, port charges and feeders) by type of service (which may be monthly or annual results).