As shown, this is an Excel file to analyze the 1st Quarter Vehicle Cost at Prontix Courier Services company. It only provides you with the raw data. Using your understanding of Excel formulas, complete the rows and columns blanks marked with the red numbers from 1 to 8. For example, the column with 1 is to compute the Mileage Cost of each driver by multiplying the Cost per Mile by the Miles Driven. If you find any built-in formula available in Excel, use them instead of your own formula.

Also, add a Pie Chart that shows the percentage of each driver's total cost over the company's total vehicle cost.

My calculations are as follows:

1) Mileage Cost = Cost per mile * Miles driven

2) Maintenance Cost Per Mile = Maintenance Cost / Miles driven

3) Total Cost = Mileage Cost + Maintenance Cost per Mile

4) Total Cost per Mile = Total Cost / Cost per mile

Please correct me if i am wrong. Also, please show how to do the pie chart.

B H DO Total Cost per Mile 3 Driver 4 H. Alban 5 R. Deloti 6 J. Fralte 7 W. Holt 8 0. Jones 9 G. Manetti 10 K. Polter 11 V. Talton 12 T. Yannucci 13 Totals 5 14 Average 6 15 Highest 7 16 Lowest 8 17 Cost per Mile 2.30 1.55 2.42 2.40 1.54 1.63 2.12 1.86 2.30 D E F G Prontix Courier Services 1st Quarter Vehicle Cost Analysis 3 Maintenance Mileage Maintenance Miles Driven Cost Cost Cost per Mile Total Cost 3119 104.29 2556 176.12 2398 161.46 2295 169.32 2046 221.59 2927 230.11 2887 192.90 1926 325.42 2474 184.64