Please also provide .xls file with speadsheet workings

Table 1: Production torget (tonnes) set for the different periods and Average truck cycle time (in minutes) i.e lood, travel, dump, and return ( 1 cycle). Figure 1 Mining locations, Dump site and Mill focations for typical Iron ore site which operotes under a loader-truck system Case study 2: (1) Assuming average operating hours of the mine around 20 hours for each period, the capacity of each 730E-8 truck around 181 tonne, and the loader cycle time constant at 1.65 minutes. Determine the number of trucks required in each period and in each route (refer to Mine operations in Figure 1, Table 1 provides the Truck cycle time and Production requirements). (2) Add a two-dimensional combo chart including the number of 730E8 trucks and production target in each period, to comment as a Site Manager on existing mining operations to purchase or hire the equipment based on consistent or fluctuating demand (consider the percent and annual interest rate of 19%. Each truck can cost up to $500,000 plus maintenance costs. Equipment hire can cost up to $295 per hour. Table 1: Production torget (tonnes) set for the different periods and Average truck cycle time (in minutes) i.e lood, travel, dump, and return ( 1 cycle). Figure 1 Mining locations, Dump site and Mill focations for typical Iron ore site which operotes under a loader-truck system Case study 2: (1) Assuming average operating hours of the mine around 20 hours for each period, the capacity of each 730E-8 truck around 181 tonne, and the loader cycle time constant at 1.65 minutes. Determine the number of trucks required in each period and in each route (refer to Mine operations in Figure 1, Table 1 provides the Truck cycle time and Production requirements). (2) Add a two-dimensional combo chart including the number of 730E8 trucks and production target in each period, to comment as a Site Manager on existing mining operations to purchase or hire the equipment based on consistent or fluctuating demand (consider the percent and annual interest rate of 19%. Each truck can cost up to $500,000 plus maintenance costs. Equipment hire can cost up to $295 per hour