duction to Mining Drilling Analysis 1. Please show all your work using Microsoft Excel. Your company has decided to drive a 5,000 meter tunnel to connect two remote sections of a mine for purposes of improving ventilation and providing access to new potential exploration targets. Given the length of this development, your superiors have decided to purchase a new drill jumbo. As a project engineer, you've been instructed to evaluate the economic differences between air powered and hydraulic/electric drill jumbos. Using data collected from other operations owned by your company, the following table has been created. Characteristic Penetration Rate Capital Cost Air Drill Hydraulic Drill 1.2 meters/minute 2.3 meters/minute Drill & Compressor $105,000 Drill $270,000 Expected Drill Life 28,000 Drilling Hours 40,000 Drilling Hours Utility Cost 4 inch air line $3.60/meter advance 3 PH power cable $1.50/meter advance Maintenance Cost $5/hour of Drilling $7/hour of Drilling Power Cost $10/hour of Drilling $3.50/hour of Drilling Consumables/Supply Cost $12/hour of Drilling $18/hour of Drilling From experience, each round has been designed with 30 drill holes, each being 3.5 meters deep. It is assumed, however, that each round will only result in 3.4 meters of tunnel advance for every round drilled. In addition, assume that all other costs such as labor, unit operations other than drilling, power installation, drill setup & queuing, and overhead are equal for both drills. Remember, you're not calculating the total cost per meter of drilling for either system but doing a comparative analysis between them. Please determine the following: (a) Excluding the common costs, what are the operating and capital costs on a per meter of advance basis for each of the two drilling systems, Note: Amortize the capital costs on a per hour or per meter basis (b) Plot these costs relative to total dollars (vertical axis) and meters driven (horizontal axis) in the following manner: Graph #1: Operating Costs for Air & Hydraulic Drills Graph #2: Capital Costs for Air & Hydraulic Drills Graph #3: Combined Costs for Air & Hydraulic Drills (c) Which system would you recommend buying