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 leps-than- truckload (LTL) carriers forA this assignment. The spreadsheet contains two tabs: You will use the Additional Data spreadsheet to complete The first tab contains four summary reports showing shipment volume and quality statistics for A The second tab contains a carrier scorecard template. three largest carriers. 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 KPls, 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. Mode LTL LTL Total Delivery Cost Shipment Weight 3.236 474 1,776973 1,349,594 Average Transit Time Count of Shipments Freight Rate ($/CWT) Carrier Namne AVERITT EXPRESS INC YELLOW FREIGHT SYSTEMS OVERNITE TRANSPORTATION 3,078 S 1,131 749 $ 6.0 4.7 17.88 S 578,581 13.15 11.17 233 678 56 LTL S 150,688 Percent of On-Time Shipments 2053 850 504 Count of On Time Shipments Number of Shipments Mode Carrier Name AVERITT EPRESS INC YELLOW FREIGHT SYSTEMS OVERNITE TRANSPORTATION 66.% 75.2% 67.3% 3.078 LTL LTL LTL 1,131 749 Percent of Problema Shipments 388 123 76 Count of Problem Shipments 3,078 Number of Shipments Mode LTL LTL LTL Carrier Name AVERITT EXPRESS INC YELLOW FREIGHT SYSTEMS OVERNITE TRANSPORTATION 12.6% 10.9% 1,131| 749 10.1 % Shipment Problems include paperwork inaccuracies, incorrect quantity and delays Percent of Shipments Average Damge with Damge Claims Count of Damage Claims 3,078 1,131 745 Number of Shipments Claim Amount 400.00 3.2% $ 32 % S 2.4% $ Mode 99 Carrier Name AVERITT EXPRESS INC YELLOW FREIGHT SYSTEMS OVERNITE TRANSPORTATION 300.00 LTL LTL LTL 36 200.00 18 Key Performance Indicaton Performance Geel& Weight Factor Peential Score Canier Evaluation Camer Seoe Evaluations (Weight Factor s Evahuation Yellow Freight Averitt Espres Overmight Yeboe o Ovemight Avet Epess 3 days-5 30-399 daysa 40-5 49 d-t Average Transit Tme $10.00-5 $10 01 to14 00-4 $14.01 to $18.00-3 $18 01 to $22 00-2 $22 00-1 Freight Rates (SCwr 95%-S Oe Sme Deivery 90 1-95 % -4 s0 1-90 % -3 (Percent of total shipments received on time 70-80% -2 70%- fi 29% -5 20-40% -4 414 0% -3 618%-2 Problem shipments (Percent of total shipments received with problems 8%-1 Additional Criterion Possible Must 5001 Maste 200 Conclusions
Rather than being the cheapest, this online essay writing service is cost-effective. We are confident in our writers’ ability to do a good job because we hire the best experts and perform quarterly reviews of satisfaction metrics.
+1 (940) 905-5542