Was developed as a coal forecasting tool for a mining company. This forecasting is generally performed twice monthly.
This application replaced a system which involved an exponentially increasing number of spreadsheet copies and versions which was prone to errors.
Consistent and auditable record of transactions which builds up to produce many financial reports.
Each inventory movement or transaction is tagged with the Pit it relates to. Each Pit is further grouped into Mine and each Mine into Mine Type.
This structure provides the flexibility to report the information either at a highly detailed or summarised level.
Front and centre is the status of the selected budget or forecast model, including information on imported files (date, times, the user who performed the import), and finally a completion date and time.
Once locked down, only certain users are able to unlock the file for editing.
Most data is imported from other systems, however manual entries can be made (again a full audit trail is provided).
Data is also exported for other import into other systems.
Engineering and finance people can complete their part in the process, while also being able to see where the process is up to and therefore who to contact if there are any hold ups.