A truck and loader operation is an imperative, but high cost component of many, if not all open pit mining operations. Truck and loader systems have been well accepted throughout the mining industry due to their inherent flexibility. The need for accurate and reliable cost reporting for these types of operations is imperative.
Presently, there are a number of programs available that are capable of determining production and costs for a truck and loader operation. These programs are well accepted and widely used throughout the industry, however no such model exists in an Excel format.
The development of a costing model within Excel provides many advantages:
- Easily Accessible: Excel is one of the most widely used spreadsheeting programs throughout the world.
- Small Size: Compared to other programs, which need to be installed via CD-ROM and are very large in size, an Excel file is capable of fitting onto a floppy disk.
- Transparent: An Excel File is totally transparent, with the user able to see how each cell is calculated, and where each cell is linked.
- Formatting: Excel files are easily formatted, allowing changes or additions to be made to the program easily if needed.
The aim of this thesis is to develop a user-friendly Truck/Loader Cost per Tonne Model utilising Excel. This will be done by reviewing and examining all important cost factors on a Truck and Loader operation and incorporating these factors into a spreadsheet.