You need to solve this business problem using Excels If and Vlookup Functions as well as applying your practical business decision making process. The European Touring Manager for the Rolling Stones. Has hired your company, Stage Truck Logistics Company to transport all the stage sets, lighting, sound equipment and backgrounds for their European Tour. You are responsible for the transportation of 40, 45foot Megacube semi trailers of stage sets, lighting, sound equipment and backgrounds. Etc. to each city on the tour. Who is Stage Truck Logistics Company?Stage Truck Logistics Company specializes in transporting concert equipment in specialized trailers with air suspension and secure transportation of concert staging equipment. They supply all the Semi Trailers and Drivers. Stage Truck Logistics Company is responsible for organizing the transportation to all the European City Tour A container cargo ship will be delivering all 40, 45-foot MegaCube trailers to Calais, France with all the concert equipment for the tour. The Cargo ship left Portsmouth, England with the stage equipment to land at the port of Calais, France. Start the driving calculations from Calais, France. Figure 1 Stage Truck Semi-Trailers You will need to organize the concert tour using the listed information 1) Calculate the driving distance from the docks at Calais, France to the first city on the tour. 2) Calculate the driving distance from each city to the next city on the Concert Tour. The list below provides the Touring Schedule. You must follow this schedule to determine the distance between each city and then to calculate the Total Driving Distances for the entire tour. 1st Concert: Paris,France 2nd Concert: Pamplona, Spain 3rd Concert: Nice, France 4th Concert: Venice, Italy 5th Concert: Prague, Czech Republic 6th Concert: Copenhagen, Denmark, 7th Concert: Rome, Italy 8th Concert: Ljubljana, Slovenia 9th Concert: Bern, Switzerland, 10th Concert: Gibraltar, Spain 11th Concert: Amsterdam, Netherlands 12th Concert: Berlin, Germany Contract Details:Rolling Stones Touring Manager has hired your Logistics company to transport all the stage sets, lighting, sound equipment and backgrounds on their European Tour. You are responsible for the transportation of 40, 45-foot Megacube semi trailers of stage sets, lighting, sound equipment and backgrounds. Etc. Driver Information: Stage Truck supplies 40 drivers (One driver per Semi trailer). Each driver is paid a day rate of $245.00 per driving day.A drivers day is 7.50 Hours.The average driving speed 75 Kilometers per hour. Calculate the Drivers Total Driving Days.Project Instructions Solve each small problem one at a time. Take the problem in baby steps. Make sure you document EVERYTHING All your calculations must be clearly identified. Make sure they can be easily read by another party. A major portion of this business problem is how you organize your spreadsheet. All of your data must fit onto a landscape, legal size page.You must calculate the driving distance from the Port of Calais, France to the first city on the tour. How many days will it take to drive to the first concert city? You must calculate the driving distance from the first city to the second, third, forth, fifth, and sixth city etc. on the tour. What is the driving distance between each city? Calculate the total number of days it takes to drive to all the cities on the concert tour. You also need to calculate the total mileage for the entire tour. Calculate the total number of driving days for the entire tour.There is Mileage Sur-Charge: Each driver receives .11 cents per kilometer.,Driver Bonus: What is the Total Mileage after the twelve concert City? Apply an Excel If Function to determine if a driver qualifies for Mileage bonus. Mileage Bonus Information: You must demonstrate the use of an Excel IF Function Mileage >= 3000 kilometers: If this value is achieve, each driver will receive a Bonus $2500.00 Calculate the Total Driving distances for each Semi-trailer Driver for all 12 concert cities, Mileage Sur-Charges and Drives Bonuses. You must create and use the VLookup Table Stage Truck insures the clients cargo Trailer Rental & Insurance Rates *Total Rental Days Per Trailer Rental Day Rate 3 $1,600.00 6 $1,400.00 9 $1,200.00 12 $1,000.00 15 $900.00 18 $700.00 20 $650.00 Total Value of Client Equipment Insurance Rate Per Day $100,000 $60.00 $500,300 $90.00 $1,100,700 $100.00 $2,700,000 $120,00 $3,500,000 $135.00 $50,00,000 $140.00 10,500,000 $150.00 20,000,000 $200.00 30,000,000 $275.00 *More than 20 Days Rental is the Maximum Rental Rate#Value of clients transported equipment for insurance purposes. *Maximum Insurance Day Rate for Equipment Value over $10,000,00 Calculate the following information using the appropriate Excel function. You need to demonstrate the use of Formulas and Functions for the project. I need to see formulas and functions in your calculations in a single Workbook NO RAW calculation numbers. Create the necessary look up tables in your Excel workbook for the following instructions 1) Calculate the Trailer Rentals for the entire tour. 2) Calculate the Insurance Costs of the Value of the Equipment for the entire tour. 3) Calculate the total costs and clearly display them on your worksheet. You must demonstrate the use of an Excel VLookup Function to determine Trailer Rentals and Trailer Insurance. Rolling Stones Trailer Equipment Inventory Values: Item Trailer No. Equipment Value 1 1120 $660,500 2 2201 $775,400 3 1202 $339,400 4 1003 $994,000 5 1222 $669,000 6 1304 $890,000 7 2230 $750,000 8 1001 $500,000 9 1440 $400,000 10 1155 $510,000 11 1311 $220,000 12 1009 $567,000 13 1010 $335,000 14 1104 $409,000 15 2209 $653,000 16 1766 $299,000 17 1105 $780,000 18 2005 $190,000 19 2000 $303,000 20 2290 $450,000 21 1120 $260,500 22 2201 $575,400 23 1202 $339,400 24 1003 $994,000 25 1222 $669,000 26 1304 $190,000 27 2230 $750,000 28 1001 $900,000 29 1440 $400,000 30 1155 $110,000 31 1311 $820,000 32 1009 $567,000 33 1010 $335,000 34 1104 $489,000 35 2209 $653,000 36 1766 $199,000 37 1105 $780,000 38 2005 $129,000 39 2000 $303,000 40 2290 $465,000