please show formulas

please show formula for each

Bob Custom Bacturer of outdoor grills , cises three primary overs from its Texas Facy to home improvement retailers in the United Canada The owner , Bob Flambea was to evaluate the performance of the Bob asked his transportation manager to develop a scorecard to help comput 160 Chapter 11 11 CASE 11.2 Bob's Custom BBQs and collected data for the following metrics over a three-month period, ALLIED TRANSPORT BESTWAY FREIGHT 98.7% 1.6% CERINT PERFORMANCE CRITERIA Onome delivery Lands wihdam com Customer satisfaction ang 4.2 4.6 TransportationManaging the flow of the Supply Chain 99.3% 99.6% 1.3% 2.1% Los repected carriers on these five metrics. The manager came up with the following chart: PERFORMANCE EVALUATION PERFORMANCE CRITERIA On-time delivery WEIGHT FACTOR POTENTIAL SCORE ACTUAL 50 CASE QUESTIONS 3. If Bob decides to keep all three carriers, what should each of them work to improve? 2. Which carrier would you recommend that Bob consider for elimination? Why? 1. Calculate the performance score for each of the three carriers. 150 >98.5% = 5 96.01-98.5% -4 93-95% -2 93% 0 Loads with 30 150 damage claims 0.5% = 5 0.5-1% = 4 1.01-2% = 2 >2% 0 20 Customer satis faction ratings 100 >>4.55 4.01-4.5 - 4 3-4-2 99% -5 97.01-99% -4 95-97% = 2 95% 0 Loads rejected 10 50 3% 0 Total Score 500