51 NO Spac... Heading 1 Heading 2 Title Subtitle Subtle Em Paragraph s Styles Project 20: Operational Efficiencies Hoover Transportation, Inc., is a large distribution company located in Denver, Colorado. The com- pany is currently seeking to gain operational efficiencies in its supply chain by reducing the number of transportation carriers It is using to outsource. Operational efficiencies for Hoover Transportation, Inc., suggest that reducing the number of carriers from the Denver distribution center to warehouses in the selected states will lead to reduced costs. Brian Hoover, the CEO of Hoover Transportation, requests the number of carriers transporting products from its Denver distribution center to wholesal- ers in Arizona, Arkansas, lowa, Missouri, Montana, Oklahoma, Oregon, and Washington be reduced from the current five carriers to two carriers. Carrier selection should be based on the assumptions that all environmental factors are equal and historical cost trends will continue. Review the historical data from the past several years to determine your recommendation for the top two carriers that Hoover Transportation should continue to use. 1. Analyze the last 24 months of Hoover's Transportation carrier transactions found in the AYK20_ Data.xlsx data file. 2. Create a report detailing your recommendation for the top two carriers with which Hoover Transportation should continue to do business. Be sure to use PivotTables and PivotCharts in your report. A few questions to get you started include: What is the average cost per carrier? What are the total shipping costs per state? - What are the total shipping weights per state? What are the average shipping costs per pound? What is the average cost per carrier? Use the attached data file, AYK20_Data.xlsx and analyze the data using Pivot Tables and Pivot Charts to answer the questions in the image. 58 to ALI | cDa T No Spac... Heading 1 Heading 2 Subtitle A v 1 Normal Title Subtle Paragraph Styles DO NOT prepare a separate report. Perform your analysis and type in your detailed recommendations in the Recommendations text box in the Solution tab of your Excel submission file. Submission Instructions 1. Enter your full name in the first worksheet of the workbook. 2. Name your file as your LastName FirstName_Excel-6.xlsx and submit on Blackboard. I F Home Insert Draw Page Layout Formulas Data Review View Help B Date Carrier Name D Destination State Involce Amount Shipping Weight 237 4754 Shipping Cost per Pound 30 Sure Shop Testime 26 sovel 24 Count on Us 24 Seven OH CO OR A NY RA 5700 03.lt 03-11 Olan 11 05 J 0 Jan 11 01 Jan 11 0 Jan 11 09-Jan 11 10-11 T11 12-1 13-Jan- 30.12 $100 5107 136 47 NY PA PA CO PA NY Invoice Number 1 2 10001 3 TO 4 10003 5 10004 6 10000 7 1000 B 10007 9 1000 10 DO 11 10010 12 1011 13 10012 14 10013 15 10014 16 10015 17 10010 18 10017 19 10010 20 10010 21 72 10071 23 100 24 TO 25 104 28 10024 27 28 102 20 30 10023 31 32 33 1002 34 35 HOM 36 AYK 20 $2131 5406 37 55.870 5607 34,587 100 545 $7.000 58975 57 111 $9099 $944 $4. 517 $2,705 50412 30.100 2007 TOT 9870 100/ 305 1210 21M 057 9800 15 Jan 11 16-11 51.05 SO 30M 30.01 30 11 01 SOS 51.00 $138 $130 100 097 $t01 300 5051 $2.000 Surs Shoping Sushigi Testing Count ons Suresh Count on US 24 Seven Count On US Cound on Us Testing Time Court on us Testing Tone 24 Sevin Contanus Sur Suppo Count on Us Sir Shining Thor Tomorrow Theron Thore long Bopping THI TEACHHU H Tom The Tom San 18-Jan-11 10.11 20-Jan-11 21-an-11 22-11 23-11 2411 25 Jan 10 2011 27-11 2233 4365 1612 8732 30.72 OR NY OH CO OH CO WA NY WA CH CH WA TX WA WA CO WA NY NY 101 1200 5046 7807 3652 4087 5030 3411 3795 $0.990 21 15000 $1,100 35.600 57 000 S4309 $4.700 55.42 $1.00 OF 011 24 Operational Efficiencies Solution LIB X f 100 1003 10038 E 573 OS MS D CO NY MY PA WA CON NY WA NYI G 30.90 SO $0.00 31 DE $1.05 37 3B 39 40 41 42 43 44 45 AR 47 48 49 50 51 52 53 54 3095 51.00 $1.15 $125 CO 10040 10041 10042 T0043 10014 10045 10000 10047 10000 10049 10050 10051 1005 10003 10050 1005 100 10051 100 10059 TOOD 30001 10002 TORS 10:04 TE 10000 07 B 06 Fob 11 06 Fob-11 07-Feb-11 B-Feb 00- to ob 11 11-Fob 31 1 Fob 11 13-Feb. 11 14 Fo-11 15 F11 16-Feb-11 Feb 11 18 Feb 11 19 Feb 18 20 Feb 11 21. Feb 11 22 Feb 11 11 24 F-11 25 Feb 11 20 Feb 11 27-Feb 11 28-06-11 01-Mar-11 12 Mar 11 03 Mar 11 Mart M11 05 M11 O Mar 11 O.M. Sure Shining Togo Thermo Count 34 SINO Thor Tom 24 Sevin There Tom There Tomor Count on us 20 Sovet Sure Shigong are Tomorrow Can Us 24 SO Sure Shipping 24 sovun 24 SUV 24 Seven Sure Shipping 24 Seven 745 24 Sevin Testing The Sure Shopping 94 SVO Sun Shipping Tosing Time Court on US 24 Son 3057 361 5705 5087 3287 1223 450 3004 1678 5435 4700 4322 2000 9042 1937 5220 3421 8890 3 3053 1981 4793 2942 1378 3574 960 $6,070 $0,012 $300 $9.345 $5621 $3.478 54234 $5,021 35,700 $3.765 51543 $4.000 $2,500 $5,777 35,590 $450 $4329 $9.001 $1,277 $1876 $5,500 $2233 $7,000 23.500 $3,250 $17 $4400 a 300 $4.500 S. $0.90 51.00 31 SMS $100 $1.00 TX WA WA OR TX OR OH NY CO PA NY NY OH AZ TX OA NY OR TX TX OH IX NY CO WA TX 5097 510 58 57 58 59 30 61 62 83 114 0.90 $0 090 05 stu Suresh 88 89 70 71 72 16/4 710 3 112 $4211 $5 1000 10070 1071 10012 YY 20 OM Techno 24 min 12 M 2 Com ational Efficiende Saly F100 AutoSave 10 AYK20 Data (1) - Search File Home Insert Draw Page Layout Formulas Data Review View Help L13 1 E G 1954 SO $1.09 A 10072 10073 10014 10075 OCTO 10077 10078 1007 TOVIO 1000 10082 73 74 75 76 77 78 79 80 81 82 B3 84 5789 3700 F 8000 $1,500 $325 $6,98 $3,000 $7,500 $0 000 55.222 T4 3005 $1.04 5100 D TX OH NY PA PA WA WA WA WY WA OR CO NY CO OR WA CO NY AZ OH AZ OH OR $2,145 3702 $9 10,70 9005 5-666 3100 2222 7000 STO X2 17 3208 3043 9045 1243 1370 1900 4750 4388 4879 $100 100 5112 SID B 13 Mar 11 Count on Us 14. Mar 11 24 Seven 15 Mar 11 Sure Shipping 16-Mar-11 Sur Shipping 17 Mar 11 Sure Shipping 18-Mat.11 Testing Time 19. Mar 11 Count ons 20 Mart Sureshing 21 Mar 11 Count on Us 22 Mir. 11 24 Seven 23-Mar 11 Count on Us 24-Mar Count on 25 Mar 11 Testing Time 26-M 11 Count of us 27-Mar-11 Testing Time 28 Mar 11 24 S 29. Mar 11 Count on Us 30 Mar 11 Sure Shipping 31 Mar 11 Count ons 01. Apr.10 Sure Shiping 02.0111 There Tomorrow 03-Apr-11 There Tomorrow 04-Apr-11 There Tomorrow 05 An:11 Sure Shipping 00-Apr-11 There Tomorrow 07 Apr 10 The Tomon GB Apr 11 Thor Tomorrow Or 11 Sare Shipping 10. Ant. 11 Store Shipping 24 Savo 12 April 13-Apr 11 Testing Time 14. April The Tomorrow 15 A 11 Count ons 24 SIM Thor Tomorrow 16-11 nal Efficiencies Solution $3.000 59.000 51100 51.00 $121 3110 00 B7 BB 319 SO 91 52 93 94 95 90 97 98 99 100 101 102 103 104 105 105 107 108 WA 100BA 10085 10006 10007 1OOSE 10089 100 10001 10092 10083 10094 10095 10000 10007 10000 10099 10100 10101 T01 10103 10104 1010 10100 0107 1010 $1300 54321 34 100 $4907 H120 $3121 510 $2111 $8.231 5000 30 3107 3254 1270 2467 B000 110 OH OH AZ CH WA AZ WA NY NY SAR ST 45 3120 674 3575 7 5340 MO SLO 10 NY IX OR MV 20 Hop ILA A 1 D 2 G 4 5 6 7 Average Invoice Cost Per Carrier 24 Seven Count on Us Sur Shipping Testing Time Thore Tomorrow Total Shipping Weights Per State PA N OR TX CO TOH WA NY Total Shipping Costs Per State PA 9 10 11 12 13 14 15 10 12 18 19 20 21 22 23 24 25 OR TX CO OH WA NY 2528 Average Shipping Costs Per Pound 24 Seven Count on Us Sure Shipping Testing Time There Tomorrow 2 20 Recommendations: 28 29 30 AVK 20 Operational Licencias Solution 35 9011 A B C F Date Carrier Name Invoice Amount D Destination State OH OH CO OR AZ NY PA AZ NY PA PA CO PA NY TX OR NY G Shipping Cost per Pound $0 88 $0.98 $0.92 $102 51.07 $1.05 $1.05 Invoice Number 1 2 10001 3 10002 4 10003 5 10004 6 10005 7 10006 8 10007 9 10008 10 10009 11 10010 12 10011 13 10012 14 10013 15 10014 16 10015 17 10016 18 10017 19 10018 20 10019 21 10020 22 10021 23 10022 24 10023 25 10024 26 10025 27 10025 28 10027 29 10028 30 10029 31 10030 32 10001 33 34 10033 10034 36 10035 AYK 20 01-Jan-11 Sure Shipping 02 Jun-11 Sure Shipping 03-Jan-11 Testing Time 04-Jan-11 24 Seven 05-Jan-11 24 Seven 08-Jan-11 Count on Us 07-Jan-11 24 Seven 08-Jan-11 Sure Shipping 09-Jan-11 Sure Shipping 10-Jan-11 Sure Shipping 11-Jan-11 Testing Time 12 Jan 11 Count on US 13 Jan 11 Sure Shipping 14 Jan-11 Count on US 15-Jan-11 24 Seven 16-Jan 11 Count on Us 17-Jan-11 Count on Us 18 Jan 11 Testing Time 19-Jan-11 Count on Us 20-Jun 11 Testing Time 21-Jan-11 24 Sover 22-Jan-11 Count on Us 23-Jan-11 Sure Shipping 24 Jan 11 Count on US 29 Jan-11 Sure Shipping 26 Jan 11 There Tomorrow 27-Jan-11 There Tomorrow 28-Jan-11 There Tomorrow 29-Jan-11 Sure Shipping 30-Jan-11 There Tomorrow 31 jan 11 Thoro Tomorrow 01-Feb-11 There Tomorrow 02 Fo6-11 Sure Shipping 03-Feb-11 Suro Shipping 04 F-11 24 Seven Operational Efficiencies Solution E Shipping Weight 2437 4754 4356 5789 4356 4356 5832 4877 7457 8987 7587 9870 1087 4385 1256 2134 8578 9808 9808 2233 4305 6812 OH $2,134 $4,654 $3.987 $5 876 $4,875 $4,567 $6,100 $4.678 $7.000 $8.875 $7 111 $9,999 $944 $4,785 51.732 $2,765 $6,432 $9.100 $9,888 $2,000 $6,578 $8.999 $8.321 $5,500 $1.100 $5,600 $7 800 54500 $4,700 $5.432 $3, 278 $3,000 $6.32 $8.999 $5,467 8732 CO CO WA NY WA OH OH WA TX WA WA CO WA NY NY + $0.97 $0.93 $1.01 $0:37 $1.09 $1238 $1:30 50.98 $0.93 $1:01 $0.90 1:51 $1.03 $0.72 $1.03 529 $0.99 $0.99 $130 $100 $0.90 $0.92 $0.95 $0.99 $1.00 SO 01 5430 1209 5846 7867 3452 1687 5636 3507 3795 6907 907 0789 E35 - 9011 F $6 832 $8.999 $5.467 $5 676 $6,432 $9,800 $9,345 $5,621 G 30.09 $1.00 50 81 $0.99 $0.98 $0.99 $104 $1.05 34 35 38 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 519 00 61 02 63 554 65 DO 67 68 69 70 A 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10000 10001 10062 10003 10084 10005 100 10067 10000 10009 AYK 20 B 012-Feb-11 Sure Shipping 03-Feb-11 Sure Shipping 04 Feb 11 24 Seven 05-Feb-11 Sure Shipping 06-Feb-11 Testing Time 07-Feb-11 There Tomorrow 08 Feb-11 Count on US 09 Feb 11 24 Seven 10-Feb-11 There Tomorrow 11-Feb-11 24 Seven 12-Feb-11 There Tomorrow 13-Feb-11 There Tomorrow 14-Feb-11 Count on Us 15-Feb-11 24 Seven 16-Feb-11 Sure Shipping 17-Feb-11 There Tomorrow 18-Feb-11 Count on Us 19-Feb-11 24 Seven 20-Feb-11 Sure Shipping 21-Feb-11 24 Seven 22-Feb-11 24 Seven 23-Feb-11 24 Seven 24-Feb. 11 Sure Shipping 25 Feb 11 24 Son 26-Feb-11 24 Seven 27-Feb-11 24 Seven 28-06-11 Testing Time 01-Mar-11 Sure Shipping 02 Mart 1 24 Savon 03-Mar-11 Sure Shipping 04 Mar 11 Testing Time 05 Mar 11 Count on Us 08 Mar 11 24 Seven 07-Mar-11 Sure Shipping 08-Mar-11 Sure Shipping 09 Mar 11 Suro Shippin 10 Mar 11 Totting Time Operational Efficiencies Solution D WA NY NY CO NY NY CO WA CO NY WA NY CO TX WA WA OR TX OR NY CO PA NY NY OH AZ TX OR NY OR TX EX OU TX NY E 8907 9011 6789 5733 8536 9865 9021 5369 3657 4367 5765 5687 3287 1233 4356 3864 5678 5435 4786 $322 8900 1032 1937 5326 321 890 36844 358 1987 54,204 $5,621 $5.700 $3,765 $1.543 $4.000 $3,500 $5,777 $5,590 $4,578 $4,322 $9.001 $1,277 $1,076 $5,500 $0.98 $1.00 $1.15 $120 50.92 $0.98 $15.02 $1.00 $0.96 $1.00 5101 $0.14 $0.97 $1.03 $0.65 $1.02 $0.95 $0.90 $0 M $0:02 $0.93 $7,000 $3.500 $3,200 $1870 $4,400 $300 $4,500 $5.500 58,233 58.132 $4.219 3942 4378 857 9583 8389 1674 0200 5102 $0.90 500 50.84 E35 Xfx 9011 D NY CO WA TX OH NY PA PA WA WA WA G $0.84 $0.98 $0.94 $0.93 $0.97 51 01 NY 70 71 72 73 74 75 76 77 78 79 80 81 82 83 85 06 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 100 10069 10070 10071 10072 10073 30074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10000 10091 10092 10093 10094 10095 100196 10097 10098 10099 10100 10101 10102 10103 10104 10105 AYK 20 B C 10 Mar 11 Testing Time 11 Mar-11 24 Seven 12 Mar 11 24 Savon 13 Mar 11 Count on Us 14-Mar-11 24 Seven 15 Mar-11 Sure Shipping 16 Mar 11 Sure Shipping 17-Mar-11 Sure Shipping 18 Mar 11 Testing Time 19 Mar 11 Count on Us 20 Mar 11 Sure Shipping 21 Mar 11 Count On US 22 Mar 11 24 Seven 23 Mar 11 Count on Us 24-Mar-11 Court on Us 25 Mar 11 Tonting Time 26 Mar 11 Count on US 27-Mar-11 Testing Time 28 Mar 11 24 Seven 29 Mar 11 Count on US 30-Mar-11 Sure Shipping 31-Mor-11 Count on Us 01 Apr 11 Sure Shipping 02 Apr 11 There Tomorrow 03-Apr 11 There Tomorrow 04 Apr 11 Thor Tomorrow 05-Apr-11 Sure Shipping 06 Apr 11 Thor Tomorrow 07-Apr-11 There Tomorrow 08 Apr.11 The Tomorrow 09-Apr-11 Sure Shipping 10-A-11 Sure Shipping 11 Apr 11 24 Seven 12 Apr 11 Sure Shipping 13-Apr 11 Testing Time 14 Apr 11 There Tomorrow 15 Apr 11 Count on Us Operational Efficiencies Solution WA OR CO NY OR WA CO NY AZ CH AZ OH OR WA AZ OH WA E 6789 5390 4374 3438 1854 3211 5789 3790 7874 9045 5488 8109 2222 7800 5878 9932 5879 3266 3043 9045 1243 5378 3200 4780 4358 1879 4794 3254 1270 2467 Bio 3693 4356 8126 578 F $9,878 $5,300 $4109 $6,000 $1,800 $3,254 $8 $3,000 $7,500 $9.000 $5 222 $6354 $2,345 $7.932 $9,888 $8,750 $6,578 $4,355 $3.000 $9.000 $1,500 $5 890 $3,300 54321 $4.189 $4,987 $4,298 $3,121 $1.360 $2.111 $8,231 $3,333 $4,598 $7709 SONGS $0.95 $1.00 $0.98 $1.04 $1.08 $1,02 $1.00 $0.76 $112 $133 $0.99 $1.00 $1.21 $1.10 $1.03 $0.91 $0 $1.02 $0.90 $0.90 $1.07 $0.88 $1.03 30.90 $1.00 $0.05 30.81 $1.00 + AZ WA NY NY N 7465 $3000 $1321 118 f A 8 D E F H Average Invoice Cost Per Carrier 24 Seven Count on Us Sure Shipping Testing Time There Tomorrow Total Shipping Weights Per State PA AZ OR TX CO OH WA NY 1 2 3 4 5 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Total Shipping Costs Per State PA AZ OR TX CO OH WA Average Shipping Costs Per Pound 24 Seven Count on Us Suro Shipping Testing Time There Tomorrow INY Recommendations: 20 27 28 29 30 31 32 33 3-4 35 AYK 20 Operational Efficiencies Solution 51 NO Spac... Heading 1 Heading 2 Title Subtitle Subtle Em Paragraph s Styles Project 20: Operational Efficiencies Hoover Transportation, Inc., is a large distribution company located in Denver, Colorado. The com- pany is currently seeking to gain operational efficiencies in its supply chain by reducing the number of transportation carriers It is using to outsource. Operational efficiencies for Hoover Transportation, Inc., suggest that reducing the number of carriers from the Denver distribution center to warehouses in the selected states will lead to reduced costs. Brian Hoover, the CEO of Hoover Transportation, requests the number of carriers transporting products from its Denver distribution center to wholesal- ers in Arizona, Arkansas, lowa, Missouri, Montana, Oklahoma, Oregon, and Washington be reduced from the current five carriers to two carriers. Carrier selection should be based on the assumptions that all environmental factors are equal and historical cost trends will continue. Review the historical data from the past several years to determine your recommendation for the top two carriers that Hoover Transportation should continue to use. 1. Analyze the last 24 months of Hoover's Transportation carrier transactions found in the AYK20_ Data.xlsx data file. 2. Create a report detailing your recommendation for the top two carriers with which Hoover Transportation should continue to do business. Be sure to use PivotTables and PivotCharts in your report. A few questions to get you started include: What is the average cost per carrier? What are the total shipping costs per state? - What are the total shipping weights per state? What are the average shipping costs per pound? What is the average cost per carrier? Use the attached data file, AYK20_Data.xlsx and analyze the data using Pivot Tables and Pivot Charts to answer the questions in the image. 58 to ALI | cDa T No Spac... Heading 1 Heading 2 Subtitle A v 1 Normal Title Subtle Paragraph Styles DO NOT prepare a separate report. Perform your analysis and type in your detailed recommendations in the Recommendations text box in the Solution tab of your Excel submission file. Submission Instructions 1. Enter your full name in the first worksheet of the workbook. 2. Name your file as your LastName FirstName_Excel-6.xlsx and submit on Blackboard. I F Home Insert Draw Page Layout Formulas Data Review View Help B Date Carrier Name D Destination State Involce Amount Shipping Weight 237 4754 Shipping Cost per Pound 30 Sure Shop Testime 26 sovel 24 Count on Us 24 Seven OH CO OR A NY RA 5700 03.lt 03-11 Olan 11 05 J 0 Jan 11 01 Jan 11 0 Jan 11 09-Jan 11 10-11 T11 12-1 13-Jan- 30.12 $100 5107 136 47 NY PA PA CO PA NY Invoice Number 1 2 10001 3 TO 4 10003 5 10004 6 10000 7 1000 B 10007 9 1000 10 DO 11 10010 12 1011 13 10012 14 10013 15 10014 16 10015 17 10010 18 10017 19 10010 20 10010 21 72 10071 23 100 24 TO 25 104 28 10024 27 28 102 20 30 10023 31 32 33 1002 34 35 HOM 36 AYK 20 $2131 5406 37 55.870 5607 34,587 100 545 $7.000 58975 57 111 $9099 $944 $4. 517 $2,705 50412 30.100 2007 TOT 9870 100/ 305 1210 21M 057 9800 15 Jan 11 16-11 51.05 SO 30M 30.01 30 11 01 SOS 51.00 $138 $130 100 097 $t01 300 5051 $2.000 Surs Shoping Sushigi Testing Count ons Suresh Count on US 24 Seven Count On US Cound on Us Testing Time Court on us Testing Tone 24 Sevin Contanus Sur Suppo Count on Us Sir Shining Thor Tomorrow Theron Thore long Bopping THI TEACHHU H Tom The Tom San 18-Jan-11 10.11 20-Jan-11 21-an-11 22-11 23-11 2411 25 Jan 10 2011 27-11 2233 4365 1612 8732 30.72 OR NY OH CO OH CO WA NY WA CH CH WA TX WA WA CO WA NY NY 101 1200 5046 7807 3652 4087 5030 3411 3795 $0.990 21 15000 $1,100 35.600 57 000 S4309 $4.700 55.42 $1.00 OF 011 24 Operational Efficiencies Solution LIB X f 100 1003 10038 E 573 OS MS D CO NY MY PA WA CON NY WA NYI G 30.90 SO $0.00 31 DE $1.05 37 3B 39 40 41 42 43 44 45 AR 47 48 49 50 51 52 53 54 3095 51.00 $1.15 $125 CO 10040 10041 10042 T0043 10014 10045 10000 10047 10000 10049 10050 10051 1005 10003 10050 1005 100 10051 100 10059 TOOD 30001 10002 TORS 10:04 TE 10000 07 B 06 Fob 11 06 Fob-11 07-Feb-11 B-Feb 00- to ob 11 11-Fob 31 1 Fob 11 13-Feb. 11 14 Fo-11 15 F11 16-Feb-11 Feb 11 18 Feb 11 19 Feb 18 20 Feb 11 21. Feb 11 22 Feb 11 11 24 F-11 25 Feb 11 20 Feb 11 27-Feb 11 28-06-11 01-Mar-11 12 Mar 11 03 Mar 11 Mart M11 05 M11 O Mar 11 O.M. Sure Shining Togo Thermo Count 34 SINO Thor Tom 24 Sevin There Tom There Tomor Count on us 20 Sovet Sure Shigong are Tomorrow Can Us 24 SO Sure Shipping 24 sovun 24 SUV 24 Seven Sure Shipping 24 Seven 745 24 Sevin Testing The Sure Shopping 94 SVO Sun Shipping Tosing Time Court on US 24 Son 3057 361 5705 5087 3287 1223 450 3004 1678 5435 4700 4322 2000 9042 1937 5220 3421 8890 3 3053 1981 4793 2942 1378 3574 960 $6,070 $0,012 $300 $9.345 $5621 $3.478 54234 $5,021 35,700 $3.765 51543 $4.000 $2,500 $5,777 35,590 $450 $4329 $9.001 $1,277 $1876 $5,500 $2233 $7,000 23.500 $3,250 $17 $4400 a 300 $4.500 S. $0.90 51.00 31 SMS $100 $1.00 TX WA WA OR TX OR OH NY CO PA NY NY OH AZ TX OA NY OR TX TX OH IX NY CO WA TX 5097 510 58 57 58 59 30 61 62 83 114 0.90 $0 090 05 stu Suresh 88 89 70 71 72 16/4 710 3 112 $4211 $5 1000 10070 1071 10012 YY 20 OM Techno 24 min 12 M 2 Com ational Efficiende Saly F100 AutoSave 10 AYK20 Data (1) - Search File Home Insert Draw Page Layout Formulas Data Review View Help L13 1 E G 1954 SO $1.09 A 10072 10073 10014 10075 OCTO 10077 10078 1007 TOVIO 1000 10082 73 74 75 76 77 78 79 80 81 82 B3 84 5789 3700 F 8000 $1,500 $325 $6,98 $3,000 $7,500 $0 000 55.222 T4 3005 $1.04 5100 D TX OH NY PA PA WA WA WA WY WA OR CO NY CO OR WA CO NY AZ OH AZ OH OR $2,145 3702 $9 10,70 9005 5-666 3100 2222 7000 STO X2 17 3208 3043 9045 1243 1370 1900 4750 4388 4879 $100 100 5112 SID B 13 Mar 11 Count on Us 14. Mar 11 24 Seven 15 Mar 11 Sure Shipping 16-Mar-11 Sur Shipping 17 Mar 11 Sure Shipping 18-Mat.11 Testing Time 19. Mar 11 Count ons 20 Mart Sureshing 21 Mar 11 Count on Us 22 Mir. 11 24 Seven 23-Mar 11 Count on Us 24-Mar Count on 25 Mar 11 Testing Time 26-M 11 Count of us 27-Mar-11 Testing Time 28 Mar 11 24 S 29. Mar 11 Count on Us 30 Mar 11 Sure Shipping 31 Mar 11 Count ons 01. Apr.10 Sure Shiping 02.0111 There Tomorrow 03-Apr-11 There Tomorrow 04-Apr-11 There Tomorrow 05 An:11 Sure Shipping 00-Apr-11 There Tomorrow 07 Apr 10 The Tomon GB Apr 11 Thor Tomorrow Or 11 Sare Shipping 10. Ant. 11 Store Shipping 24 Savo 12 April 13-Apr 11 Testing Time 14. April The Tomorrow 15 A 11 Count ons 24 SIM Thor Tomorrow 16-11 nal Efficiencies Solution $3.000 59.000 51100 51.00 $121 3110 00 B7 BB 319 SO 91 52 93 94 95 90 97 98 99 100 101 102 103 104 105 105 107 108 WA 100BA 10085 10006 10007 1OOSE 10089 100 10001 10092 10083 10094 10095 10000 10007 10000 10099 10100 10101 T01 10103 10104 1010 10100 0107 1010 $1300 54321 34 100 $4907 H120 $3121 510 $2111 $8.231 5000 30 3107 3254 1270 2467 B000 110 OH OH AZ CH WA AZ WA NY NY SAR ST 45 3120 674 3575 7 5340 MO SLO 10 NY IX OR MV 20 Hop ILA A 1 D 2 G 4 5 6 7 Average Invoice Cost Per Carrier 24 Seven Count on Us Sur Shipping Testing Time Thore Tomorrow Total Shipping Weights Per State PA N OR TX CO TOH WA NY Total Shipping Costs Per State PA 9 10 11 12 13 14 15 10 12 18 19 20 21 22 23 24 25 OR TX CO OH WA NY 2528 Average Shipping Costs Per Pound 24 Seven Count on Us Sure Shipping Testing Time There Tomorrow 2 20 Recommendations: 28 29 30 AVK 20 Operational Licencias Solution 35 9011 A B C F Date Carrier Name Invoice Amount D Destination State OH OH CO OR AZ NY PA AZ NY PA PA CO PA NY TX OR NY G Shipping Cost per Pound $0 88 $0.98 $0.92 $102 51.07 $1.05 $1.05 Invoice Number 1 2 10001 3 10002 4 10003 5 10004 6 10005 7 10006 8 10007 9 10008 10 10009 11 10010 12 10011 13 10012 14 10013 15 10014 16 10015 17 10016 18 10017 19 10018 20 10019 21 10020 22 10021 23 10022 24 10023 25 10024 26 10025 27 10025 28 10027 29 10028 30 10029 31 10030 32 10001 33 34 10033 10034 36 10035 AYK 20 01-Jan-11 Sure Shipping 02 Jun-11 Sure Shipping 03-Jan-11 Testing Time 04-Jan-11 24 Seven 05-Jan-11 24 Seven 08-Jan-11 Count on Us 07-Jan-11 24 Seven 08-Jan-11 Sure Shipping 09-Jan-11 Sure Shipping 10-Jan-11 Sure Shipping 11-Jan-11 Testing Time 12 Jan 11 Count on US 13 Jan 11 Sure Shipping 14 Jan-11 Count on US 15-Jan-11 24 Seven 16-Jan 11 Count on Us 17-Jan-11 Count on Us 18 Jan 11 Testing Time 19-Jan-11 Count on Us 20-Jun 11 Testing Time 21-Jan-11 24 Sover 22-Jan-11 Count on Us 23-Jan-11 Sure Shipping 24 Jan 11 Count on US 29 Jan-11 Sure Shipping 26 Jan 11 There Tomorrow 27-Jan-11 There Tomorrow 28-Jan-11 There Tomorrow 29-Jan-11 Sure Shipping 30-Jan-11 There Tomorrow 31 jan 11 Thoro Tomorrow 01-Feb-11 There Tomorrow 02 Fo6-11 Sure Shipping 03-Feb-11 Suro Shipping 04 F-11 24 Seven Operational Efficiencies Solution E Shipping Weight 2437 4754 4356 5789 4356 4356 5832 4877 7457 8987 7587 9870 1087 4385 1256 2134 8578 9808 9808 2233 4305 6812 OH $2,134 $4,654 $3.987 $5 876 $4,875 $4,567 $6,100 $4.678 $7.000 $8.875 $7 111 $9,999 $944 $4,785 51.732 $2,765 $6,432 $9.100 $9,888 $2,000 $6,578 $8.999 $8.321 $5,500 $1.100 $5,600 $7 800 54500 $4,700 $5.432 $3, 278 $3,000 $6.32 $8.999 $5,467 8732 CO CO WA NY WA OH OH WA TX WA WA CO WA NY NY + $0.97 $0.93 $1.01 $0:37 $1.09 $1238 $1:30 50.98 $0.93 $1:01 $0.90 1:51 $1.03 $0.72 $1.03 529 $0.99 $0.99 $130 $100 $0.90 $0.92 $0.95 $0.99 $1.00 SO 01 5430 1209 5846 7867 3452 1687 5636 3507 3795 6907 907 0789 E35 - 9011 F $6 832 $8.999 $5.467 $5 676 $6,432 $9,800 $9,345 $5,621 G 30.09 $1.00 50 81 $0.99 $0.98 $0.99 $104 $1.05 34 35 38 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 519 00 61 02 63 554 65 DO 67 68 69 70 A 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10000 10001 10062 10003 10084 10005 100 10067 10000 10009 AYK 20 B 012-Feb-11 Sure Shipping 03-Feb-11 Sure Shipping 04 Feb 11 24 Seven 05-Feb-11 Sure Shipping 06-Feb-11 Testing Time 07-Feb-11 There Tomorrow 08 Feb-11 Count on US 09 Feb 11 24 Seven 10-Feb-11 There Tomorrow 11-Feb-11 24 Seven 12-Feb-11 There Tomorrow 13-Feb-11 There Tomorrow 14-Feb-11 Count on Us 15-Feb-11 24 Seven 16-Feb-11 Sure Shipping 17-Feb-11 There Tomorrow 18-Feb-11 Count on Us 19-Feb-11 24 Seven 20-Feb-11 Sure Shipping 21-Feb-11 24 Seven 22-Feb-11 24 Seven 23-Feb-11 24 Seven 24-Feb. 11 Sure Shipping 25 Feb 11 24 Son 26-Feb-11 24 Seven 27-Feb-11 24 Seven 28-06-11 Testing Time 01-Mar-11 Sure Shipping 02 Mart 1 24 Savon 03-Mar-11 Sure Shipping 04 Mar 11 Testing Time 05 Mar 11 Count on Us 08 Mar 11 24 Seven 07-Mar-11 Sure Shipping 08-Mar-11 Sure Shipping 09 Mar 11 Suro Shippin 10 Mar 11 Totting Time Operational Efficiencies Solution D WA NY NY CO NY NY CO WA CO NY WA NY CO TX WA WA OR TX OR NY CO PA NY NY OH AZ TX OR NY OR TX EX OU TX NY E 8907 9011 6789 5733 8536 9865 9021 5369 3657 4367 5765 5687 3287 1233 4356 3864 5678 5435 4786 $322 8900 1032 1937 5326 321 890 36844 358 1987 54,204 $5,621 $5.700 $3,765 $1.543 $4.000 $3,500 $5,777 $5,590 $4,578 $4,322 $9.001 $1,277 $1,076 $5,500 $0.98 $1.00 $1.15 $120 50.92 $0.98 $15.02 $1.00 $0.96 $1.00 5101 $0.14 $0.97 $1.03 $0.65 $1.02 $0.95 $0.90 $0 M $0:02 $0.93 $7,000 $3.500 $3,200 $1870 $4,400 $300 $4,500 $5.500 58,233 58.132 $4.219 3942 4378 857 9583 8389 1674 0200 5102 $0.90 500 50.84 E35 Xfx 9011 D NY CO WA TX OH NY PA PA WA WA WA G $0.84 $0.98 $0.94 $0.93 $0.97 51 01 NY 70 71 72 73 74 75 76 77 78 79 80 81 82 83 85 06 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 100 10069 10070 10071 10072 10073 30074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10000 10091 10092 10093 10094 10095 100196 10097 10098 10099 10100 10101 10102 10103 10104 10105 AYK 20 B C 10 Mar 11 Testing Time 11 Mar-11 24 Seven 12 Mar 11 24 Savon 13 Mar 11 Count on Us 14-Mar-11 24 Seven 15 Mar-11 Sure Shipping 16 Mar 11 Sure Shipping 17-Mar-11 Sure Shipping 18 Mar 11 Testing Time 19 Mar 11 Count on Us 20 Mar 11 Sure Shipping 21 Mar 11 Count On US 22 Mar 11 24 Seven 23 Mar 11 Count on Us 24-Mar-11 Court on Us 25 Mar 11 Tonting Time 26 Mar 11 Count on US 27-Mar-11 Testing Time 28 Mar 11 24 Seven 29 Mar 11 Count on US 30-Mar-11 Sure Shipping 31-Mor-11 Count on Us 01 Apr 11 Sure Shipping 02 Apr 11 There Tomorrow 03-Apr 11 There Tomorrow 04 Apr 11 Thor Tomorrow 05-Apr-11 Sure Shipping 06 Apr 11 Thor Tomorrow 07-Apr-11 There Tomorrow 08 Apr.11 The Tomorrow 09-Apr-11 Sure Shipping 10-A-11 Sure Shipping 11 Apr 11 24 Seven 12 Apr 11 Sure Shipping 13-Apr 11 Testing Time 14 Apr 11 There Tomorrow 15 Apr 11 Count on Us Operational Efficiencies Solution WA OR CO NY OR WA CO NY AZ CH AZ OH OR WA AZ OH WA E 6789 5390 4374 3438 1854 3211 5789 3790 7874 9045 5488 8109 2222 7800 5878 9932 5879 3266 3043 9045 1243 5378 3200 4780 4358 1879 4794 3254 1270 2467 Bio 3693 4356 8126 578 F $9,878 $5,300 $4109 $6,000 $1,800 $3,254 $8 $3,000 $7,500 $9.000 $5 222 $6354 $2,345 $7.932 $9,888 $8,750 $6,578 $4,355 $3.000 $9.000 $1,500 $5 890 $3,300 54321 $4.189 $4,987 $4,298 $3,121 $1.360 $2.111 $8,231 $3,333 $4,598 $7709 SONGS $0.95 $1.00 $0.98 $1.04 $1.08 $1,02 $1.00 $0.76 $112 $133 $0.99 $1.00 $1.21 $1.10 $1.03 $0.91 $0 $1.02 $0.90 $0.90 $1.07 $0.88 $1.03 30.90 $1.00 $0.05 30.81 $1.00 + AZ WA NY NY N 7465 $3000 $1321 118 f A 8 D E F H Average Invoice Cost Per Carrier 24 Seven Count on Us Sure Shipping Testing Time There Tomorrow Total Shipping Weights Per State PA AZ OR TX CO OH WA NY 1 2 3 4 5 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Total Shipping Costs Per State PA AZ OR TX CO OH WA Average Shipping Costs Per Pound 24 Seven Count on Us Suro Shipping Testing Time There Tomorrow INY Recommendations: 20 27 28 29 30 31 32 33 3-4 35 AYK 20 Operational Efficiencies Solution