Answer Happy

Background: Companies must routinely evaluate the performance of their carriers to ensure their customers are being provided the level of customer service they require (and deserve!). An example of a carrier scorecard is presented on page 451 of the textbook. Your assignment is to create a carrier scorecard to evaluate the three largest less-than- truckload (LTL) carriers for AubieCo. You will use the Additional Data spreadsheet to complete this assignment. The spreadsheet contains two tabs: ● The first tab contains four summary reports showing shipment volume and quality statistics for AubieCo's three largest carriers. The second tab contains a carrier scorecard template. Assignment: Use the summary reports as input to create your own carrier scorecard that compares the performance of the Top 3 carriers. You will need to enter values in the green shaded areas of the template. Scores for each carrier, for each criterion, will be calculated automatically. The total of the weights entered in the Weight Factor column must equal 100. Four criteria exist in the template. You will need to develop your own 5th criterion to complete the scorecard. The 5th evaluation element must be different from the first four criteria, and it must be based on summary report data from the first tab. You may develop additional calculations from the summary report data to create your own KPIs, but make sure the new KPI(s) make sense and are actually useful in evaluating the performance of each carrier. Once you have completed your scorecard develop three conclusions from the scorecard results. Enter these in the area below the scorecard. When you have competed the assignment, rename the assignment with your name and submit the assignment through Canvas.

1 Carrier Name 2 AVERITT EXPRESS INC 3 YELLOW FREIGHT SYSTEMS 4 OVERNITE TRANSPORTATION 5 6 7 Carrier Name 7890mm A 11 12 10 OVERNITE TRANSPORTATION AVERITT EXPRESS INC 17 18 19 YELLOW FREIGHT SYSTEMS 13 Carrier Name 14 AVERITT EXPRESS INC 15 YELLOW FREIGHT SYSTEMS 16 OVERNITE TRANSPORTATION 20 Carrier Name 21 AVERITT EXPRESS INC 22 YELLOW FREIGHT SYSTEMS 23 OVERNITE TRANSPORTATION Mode LTL LTL LTL Mode LTL LTL LTL Mode LTL LTL LTL B Mode LTL LTL LTL C Total Delivery Cost 578,581 233,678 $ $ $ 150,688 3,078 1,131 749 Number of Shipments Shipments Number of Shipments 3,078 1,131 749 D Shipment Weight 3,236,474 1,776,973 1,349,594 Count of On-Time Number of Shipments 3,078 1,131 749 2,053 850 504 Count of Problem Shipments* 388 123 76 Count of Damage Claims Shipment Problems include paperwork inaccuracies, incorrect quantity and delays. E F Average Transit Time Count of Shipments 6.0 4.7 5.6 99 36 18 Percent of On-Time Shipments 66.7% 75.2% 67.3% Percent of Problem Shipments 12.6% 10.9% 10.1% Percent of Shipments | Average Damge with Damge Claims Claim Amount 3.2% $ 3.2% $ 2.4% $ G Freight Rate ($/CWT) 3,078 $ 1,131 $ 17.88 13.15 749 $ 11.17 400.00 300.00 200.00 H