Posted: June 6th, 2022

Hoover

Review your analysis and determine the top three carriers that you recommend to be retained. Prepare a memo to Mr. Brian Hoover in which you detail your recommendation for the top three carriers with which Hoover should continue to do business. Organize your memo to be succinct but informative. Be sure to support your recommendation with the facts and results of your analysis because there are some biases amongst your co-workers that may distort their view of the carriers. To better make your argument, your report must support your recommendation by presenting the data using visualization techniques. Charts and graphs should be well designed and labeled, and include legends, titles, and values where appropriate.
memo
ATTACHED FILE(S)
Coverage Analysis
Count of Invoice Number Column Labels
Row Labels IN KY MI OH PA VA WV Grand Total
Anytime Delivery 16 41 8 43 14 27 25 174
Count on Us 19 21 8 31 26 105
Express Shipping 30 41 19 32 30 152
Save Time 29 45 26 114 32 246
There Tomorrow 25 40 9 30 37 141
Grand Total 119 188 70 250 139 27 25 818
IN Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 16 19 30 29 25 KY Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 41 21 41 45 40 MI Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 8 8 19 26 9 OH Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 43 31 32 114 30 PA Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 14 26 30 32 37 VA Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 27 WV Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 25
Cost Analysis
Row Labels Average of Shipping Cost per Pound
Anytime Delivery 1.0100937968
Count on Us 0.982408824
Express Shipping 0.9837428825
Save Time 0.9655055047
There Tomorrow 1.0085011035
Grand Total 0.9879598717
Total Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 1.0100937967830121 0.98240882395331053 0.9837428825378205 0.96550550469112095 1.0085011035107174
Reliability Analysis
Row Labels Average of Days Overdue
Anytime Delivery 0.8505747126
Count on Us 0.1523809524
Express Shipping 0.1776315789
Save Time 0.7357723577
There Tomorrow 0.1134751773
Grand Total 0.4743276284
Total Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 0.85057471264367812 0.15238095238095239 0.17763157894736842 0.73577235772357719 0.11347517730496454
Hoover Medical Supplies
Invoice Number Date Carrier Name Destination State Shipping Weight Invoice Amount Shipping Cost per Pound Days Overdue
100101 01/01/16 Express Shipping PA 3257 $3,200 $0.98 0
100102 01/02/16 Anytime Delivery OH 2658 $3,546 $1.33 0
100103 01/03/16 Express Shipping OH 3288 $4,300 $1.31 0
100104 01/04/16 Express Shipping IN 3574 $3,370 $0.94 0
100105 01/05/16 Express Shipping OH 4567 $4,298 $0.94 0
100106 01/06/16 Save Time OH 9657 $9,423 $0.98 0
100107 01/07/16 There Tomorrow OH 2350 $2,200 $0.94 0
100108 01/08/16 Express Shipping IN 5871 $5,900 $1.00 0
100109 01/09/16 Save Time MI 6666 $7,011 $1.05 0
100110 01/10/16 Count on Us PA 6570 $6,600 $1.00 0
100111 01/11/16 Count on Us KY 4790 $4,654 $0.97 0
100112 01/12/16 Save Time OH 4435 $3,643 $0.82 1
100113 01/13/16 Save Time OH 4532 $4,400 $0.97 3
100114 01/14/16 Save Time MI 6567 $6,500 $0.99 4
100115 01/15/16 Count on Us IN 8904 $9,000 $1.01 0
100116 01/16/16 There Tomorrow KY 3010 $3,600 $1.20 0
100117 01/17/16 Anytime Delivery OH 4621 $4,625 $1.00 0
100118 01/18/16 Save Time KY 7574 $7,789 $1.03 1
100119 01/19/16 Express Shipping KY 3333 $3,332 $1.00 0
100120 01/20/16 Save Time OH 3569 $3,701 $1.04 1
100121 01/21/16 Anytime Delivery KY 5623 $6,276 $1.12 0
100122 01/22/16 Save Time MI 9563 $9,700 $1.01 2
100123 01/23/16 There Tomorrow KY 2683 $2,300 $0.86 0
100124 01/24/16 Express Shipping KY 7478 $7,132 $0.95 0
100125 01/25/16 Save Time OH 6498 $6,400 $0.98 3
100126 01/26/16 There Tomorrow OH 1976 $1,975 $1.00 0
100127 01/27/16 Anytime Delivery MI 2783 $3,656 $1.31 0
100128 01/28/16 Anytime Delivery VA 7222 $8,111 $1.12 0
100129 01/29/16 Anytime Delivery KY 1367 $1,300 $0.95 0
100130 01/30/16 Save Time OH 7034 $6,689 $0.95 7
100131 01/31/16 Anytime Delivery VA 4768 $6,520 $1.37 0
100132 02/01/15 Save Time OH 8654 $8,000 $0.92 1
100133 02/02/15 Express Shipping KY 4589 $2,300 $0.50 0
100134 02/03/15 Express Shipping PA 8465 $8,243 $0.97 0
100135 02/04/15 There Tomorrow KY 2243 $2,245 $1.00 0
100136 02/05/15 Anytime Delivery OH 6465 $7,400 $1.14 0
100137 02/06/15 Save Time IN 6575 $6,354 $0.97 3
100138 02/07/15 There Tomorrow KY 3577 $3,500 $0.98 4
100139 02/08/15 Save Time OH 3325 $2,432 $0.73 1
100140 02/09/15 Express Shipping IN 8789 $8,889 $1.01 1
100141 02/10/15 Express Shipping KY 4334 $4,300 $0.99 2
100142 02/11/15 Anytime Delivery OH 4742 $6,591 $1.39 3
100143 02/12/15 There Tomorrow PA 4578 $4,100 $0.90 7
100144 02/13/15 Anytime Delivery VA 6589 $8,200 $1.24 1
100145 02/14/15 There Tomorrow PA 7890 $8,000 $1.01 1
100146 02/15/15 Anytime Delivery VA 5678 $5,123 $0.90 1
100147 02/16/15 Anytime Delivery IN 5456 $5,587 $1.02 1
100148 02/17/15 Anytime Delivery IN 5677 $5,398 $0.95 2
100149 02/18/15 Save Time MI 6547 $6,500 $0.99 2
100150 02/19/15 Save Time KY 8765 $8,398 $0.96 6
100151 02/20/15 Save Time OH 4364 $4,876 $1.12 1
100152 02/21/15 Count on Us KY 3256 $2,999 $0.92 0
100153 02/22/15 There Tomorrow KY 9587 $9,500 $0.99 0
100154 02/23/15 Anytime Delivery VA 4578 $4,987 $1.09 2
100155 02/24/15 Save Time OH 3796 $3,700 $0.97 1
100156 02/25/15 Express Shipping KY 7889 $7,800 $0.99 0
100157 02/26/15 Save Time OH 4454 $4,209 $0.94 1
100158 02/27/15 Anytime Delivery OH 3563 $3,103 $0.87 1
100159 02/28/15 Save Time PA 8797 $9,231 $1.05 2
100160 03/01/15 There Tomorrow IN 4387 $4,100 $0.93 0
100161 03/02/15 Express Shipping MI 5474 $5,777 $1.06 0
100162 03/03/15 Save Time OH 9054 $8,699 $0.96 3
100163 03/04/15 There Tomorrow MI 7611 $7,123 $0.94 1
100164 03/05/15 Anytime Delivery KY 2133 $1,973 $0.92 2
100165 03/06/15 Anytime Delivery OH 3211 $3,000 $0.93 3
100166 03/07/15 Anytime Delivery PA 3577 $3,154 $0.88 1
100167 03/08/15 Save Time IN 7154 $6,589 $0.92 1
100168 03/09/15 Anytime Delivery OH 2684 $2,343 $0.87 1
100169 03/10/15 Save Time OH 6903 $7,013 $1.02 2
100170 03/11/15 Express Shipping KY 2129 $2,450 $1.15 0
100171 03/12/15 Express Shipping PA 5456 $5,211 $0.96 0
100172 03/13/15 Save Time IN 1634 $1,500 $0.92 2
100173 03/14/15 Save Time KY 4356 $4,201 $0.96 2
100174 03/15/15 Save Time OH 5843 $5,632 $0.96 2
100175 03/16/15 Count on Us PA 5709 $5,709 $1.00 0
100176 03/17/15 There Tomorrow PA 5785 $5,600 $0.97 1
100177 03/18/15 Anytime Delivery OH 4564 $4,798 $1.05 2
100178 03/19/15 Save Time KY 1111 $1,000 $0.90 2
100179 03/20/15 Express Shipping IN 6314 $6,000 $0.95 0
100180 03/21/15 Save Time OH 6799 $7,132 $1.05 5
100181 03/22/15 Anytime Delivery WV 9090 $9,000 $0.99 1
100182 03/23/15 Save Time KY 5443 $5,243 $0.96 3
100183 03/24/15 There Tomorrow IN 6394 $6,009 $0.94 1
100184 03/25/15 Express Shipping KY 7120 $3,600 $0.51 0
100185 03/26/15 Save Time MI 7533 $7,219 $0.96 3
100186 03/27/15 There Tomorrow OH 9565 $8,909 $0.93 1
100187 03/28/15 Anytime Delivery KY 1234 $1,234 $1.00 2
100188 01/01/16 Save Time KY 5787 $6,111 $1.06 0
100189 01/02/16 Express Shipping OH 3799 $3,890 $1.02 0
100190 01/03/16 Express Shipping KY 5643 $5,600 $0.99 1
100191 01/04/16 There Tomorrow KY 9076 $9,000 $0.99 0
100192 01/05/16 Anytime Delivery KY 4444 $2,233 $0.50 1
100193 01/06/16 Save Time OH 3456 $3,400 $0.98 0
100194 01/07/16 There Tomorrow IN 4657 $5,132 $1.10 0
100195 01/08/16 Save Time OH 3567 $3,500 $0.98 1
100196 01/09/16 Express Shipping KY 8567 $8,435 $0.98 0
100197 01/10/16 Express Shipping KY 4325 $3,290 $0.76 0
100198 01/11/16 Anytime Delivery WV 6455 $7,500 $1.16 1
100199 01/12/16 There Tomorrow PA 4532 $4,532 $1.00 0 BUAD3050-006
100200 01/13/16 Anytime Delivery WV 2342 $2,342 $1.00 2
100201 01/14/16 There Tomorrow KY 2332 $2,389 $1.02 0
100202 01/15/16 Anytime Delivery KY 6875 $7,000 $1.02 2
100203 01/16/16 Anytime Delivery WV 5555 $6,999 $1.26 2
100204 01/17/16 Anytime Delivery IN 6890 $7,000 $1.02 3
100205 01/18/16 Save Time IN 6900 $7,000 $1.01 1
100206 01/19/16 Save Time IN 5377 $5,488 $1.02 1
100207 01/20/16 Save Time KY 5621 $5,832 $1.04 1
100208 01/21/16 Count on Us OH 8902 $9,000 $1.01 0
100209 01/22/16 There Tomorrow IN 4543 $4,500 $0.99 0
100210 01/23/16 Anytime Delivery VA 3257 $3,609 $1.11 3
100211 01/24/16 Save Time PA 5480 $5,798 $1.06 0
100212 01/25/16 Express Shipping IN 5311 $5,843 $1.10 0
100213 01/26/16 Save Time OH 8461 $8,888 $1.05 4
100214 01/27/16 Anytime Delivery VA 4390 $4,598 $1.05 1
100215 01/28/16 Save Time OH 9088 $9,321 $1.03 2
100216 01/29/16 There Tomorrow KY 5435 $5,821 $1.07 0
100217 01/30/16 Express Shipping IN 5675 $5,600 $0.99 1
100218 01/31/16 Save Time PA 6792 $6,888 $1.01 0
100219 02/01/16 There Tomorrow KY 3782 $4,000 $1.06 0
100220 02/02/16 Anytime Delivery WV 4169 $5,398 $1.29 0
100221 02/03/16 Anytime Delivery VA 4367 $4,389 $1.01 0
100222 02/04/16 Anytime Delivery VA 6445 $6,782 $1.05 0
100223 02/05/16 Save Time MI 4567 $4,387 $0.96 0
100224 02/06/16 Anytime Delivery PA 4278 $5,521 $1.29 0
100225 02/07/16 Save Time OH 9032 $9,000 $1.00 0
100226 02/08/16 Express Shipping MI 2109 $2,000 $0.95 0
100227 02/09/16 Express Shipping MI 3931 $3,876 $0.99 0
100228 02/10/16 Save Time KY 5644 $5,367 $0.95 0
100229 02/11/16 There Tomorrow OH 8544 $7,900 $0.92 0
100230 02/12/16 Count on Us OH 3221 $3,000 $0.93 0
100231 02/13/16 There Tomorrow OH 3675 $3,600 $0.98 0
100232 02/14/16 There Tomorrow OH 8965 $8,876 $0.99 0
100233 02/15/16 Anytime Delivery WV 5655 $6,666 $1.18 0
100234 02/16/16 There Tomorrow KY 3532 $3,211 $0.91 0
100235 02/17/16 Anytime Delivery WV 6378 $6,275 $0.98 0
100236 02/18/16 Count on Us MI 9099 $9,000 $0.99 0
100237 02/19/16 There Tomorrow OH 7237 $7,200 $0.99 0
100238 02/20/16 Save Time PA 1287 $1,100 $0.85 0
100239 02/21/16 There Tomorrow OH 6765 $6,454 $0.95 0
100240 02/22/16 Save Time OH 7901 $8,000 $1.01 0
100241 02/23/16 Express Shipping OH 4565 $4,398 $0.96 0
100242 02/24/16 Express Shipping PA 3469 $3,245 $0.94 1
100243 02/25/16 Express Shipping OH 3568 $3,765 $1.06 0
100244 02/26/16 Save Time KY 1278 $1,354 $1.06 0
100245 02/27/16 Express Shipping KY 9832 $9,543 $0.97 0
100246 02/28/16 Express Shipping KY 4644 $4,555 $0.98 0
100247 02/29/16 Express Shipping KY 8643 $8,676 $1.00 0
100248 03/01/16 Save Time MI 6578 $6,578 $1.00 2
100249 03/02/16 Save Time OH 2584 $2,299 $0.89 3
100250 03/03/16 Count on Us MI 6033 $5,763 $0.96 0
100251 03/04/16 Save Time MI 4533 $5,444 $1.20 2
100252 03/05/16 Anytime Delivery WV 2134 $2,000 $0.94 3
100253 03/06/16 Express Shipping KY 5279 $5,476 $1.04 2
100254 03/07/16 There Tomorrow PA 2453 $3,200 $1.30 0
100255 03/08/16 Count on Us PA 4367 $4,598 $1.05 0
100256 03/09/16 Express Shipping OH 3467 $3,590 $1.04 0
100257 03/10/16 Count on Us PA 4767 $4,465 $0.94 0
100258 03/11/16 Express Shipping KY 3768 $3,576 $0.95 0
100259 03/12/16 Express Shipping OH 6433 $6,476 $1.01 0
100260 03/13/16 There Tomorrow KY 5566 $5,500 $0.99 0
100261 03/14/16 Count on Us OH 4689 $4,489 $0.96 0
100262 03/15/16 Save Time PA 4321 $4,532 $1.05 1
100263 03/16/16 Express Shipping KY 6474 $6,111 $0.94 0
100264 03/17/16 There Tomorrow OH 3453 $3,432 $0.99 0
100265 03/18/16 Count on Us KY 2363 $2,300 $0.97 0
100266 03/19/16 Save Time OH 2322 $2,321 $1.00 2
100267 03/20/16 Count on Us OH 3698 $3,254 $0.88 0
100268 03/21/16 Count on Us KY 2545 $2,456 $0.97 0
100269 03/22/16 Count on Us OH 4768 $4,454 $0.93 1
100270 03/23/16 Save Time OH 4565 $4,400 $0.96 2
100271 03/24/16 Count on Us PA 4563 $4,563 $1.00 0
100272 03/25/16 Count on Us OH 6774 $6,500 $0.96 0
100273 03/26/16 Count on Us OH 4533 $4,432 $0.98 0
100274 03/27/16 Anytime Delivery WV 8560 $9,507 $1.11 1
100275 03/28/16 Save Time KY 3456 $3,456 $1.00 2
100276 03/29/16 Count on Us OH 6478 $6,521 $1.01 0
100277 03/30/16 Save Time PA 4685 $4,700 $1.00 1
100278 03/31/16 Anytime Delivery IN 1267 $1,230 $0.97 3
100279 04/01/16 There Tomorrow MI 3568 $3,219 $0.90 0
100280 04/02/16 Count on Us KY 7425 $7,400 $1.00 0
100281 04/03/16 Save Time IN 4567 $4,765 $1.04 3
100282 04/04/16 Anytime Delivery KY 2343 $1,298 $0.55 1
100283 04/05/16 Anytime Delivery PA 6906 $10,000 $1.45 1
100284 04/06/16 There Tomorrow IN 4565 $4,356 $0.95 0
100285 04/07/16 There Tomorrow PA 5432 $5,500 $1.01 0
100286 04/08/16 Express Shipping OH 6289 $6,601 $1.05 0
100287 04/09/16 Save Time OH 6533 $6,908 $1.06 2
100288 04/10/16 Save Time OH 6555 $6,555 $1.00 2
100289 04/11/16 Save Time MI 3257 $3,100 $0.95 3
100290 04/12/16 Save Time OH 8985 $9,123 $1.02 2
100291 04/13/16 Anytime Delivery IN 3688 $3,200 $0.87 1
100292 04/14/16 Express Shipping MI 3423 $3,333 $0.97 0
100293 04/15/16 Anytime Delivery IN 8566 $8,222 $0.96 1
100294 04/16/16 Save Time OH 8087 $8,088 $1.00 1
100295 04/17/16 Express Shipping IN 8088 $8,089 $1.00 0
100296 04/18/16 There Tomorrow KY 8000 $7,454 $0.93 0
100297 04/19/16 Express Shipping IN 7554 $7,127 $0.94 0
100298 04/20/16 Express Shipping PA 8633 $8,790 $1.02 0
100299 04/21/16 Anytime Delivery OH 9055 $9,000 $0.99 1
100300 04/22/16 Express Shipping MI 6578 $6,456 $0.98 0
100301 04/23/16 Express Shipping OH 5756 $5,476 $0.95 0
100302 04/24/16 Express Shipping KY 4875 $4,987 $1.02 0
100303 04/25/16 Save Time MI 4456 $4,356 $0.98 1
100304 04/26/16 There Tomorrow PA 4356 $4,000 $0.92 0
100305 04/27/16 Express Shipping PA 2312 $2,300 $0.99 0
100306 04/28/16 Save Time MI 3546 $3,788 $1.07 1
100307 04/29/16 Count on Us MI 4367 $4,200 $0.96 0
100308 04/30/16 Count on Us IN 7884 $7,700 $0.98 0
100309 05/01/16 Save Time PA 3324 $3,765 $1.13 1
100310 05/02/16 Save Time MI 7643 $8,000 $1.05 1
100311 05/03/16 Save Time KY 3211 $3,000 $0.93 1
100312 05/04/16 Count on Us KY 5376 $5,467 $1.02 0
100313 05/05/16 There Tomorrow MI 4356 $4,400 $1.01 0
100314 05/06/16 Anytime Delivery MI 2180 $2,432 $1.12 1
100315 05/07/16 Save Time PA 5676 $5,700 $1.00 1
100316 05/08/16 Express Shipping MI 3456 $3,254 $0.94 0
100317 05/09/16 Save Time OH 9558 $9,555 $1.00 2
100318 05/10/16 Anytime Delivery PA 8692 $8,500 $0.98 2
100319 05/11/16 Save Time PA 5444 $4,987 $0.92 3
100320 05/12/16 There Tomorrow KY 5466 $5,389 $0.99 0
100321 05/13/16 Express Shipping KY 3575 $3,289 $0.92 0
100322 05/14/16 Save Time OH 6480 $5,789 $0.89 2
100323 05/15/16 There Tomorrow OH 1000 $1,000 $1.00 0
100324 05/16/16 Anytime Delivery VA 9109 $11,402 $1.25 2
100325 05/17/16 Anytime Delivery VA 5045 $5,000 $0.99 1
100326 05/18/16 Anytime Delivery KY 2300 $2,234 $0.97 1
100327 05/19/16 Save Time OH 4356 $4,300 $0.99 1
100328 05/20/16 Anytime Delivery OH 7532 $7,621 $1.01 1
100329 05/21/16 Save Time OH 5466 $5,899 $1.08 1
100330 05/22/16 Express Shipping KY 3532 $4,132 $1.17 0
100331 05/23/16 Express Shipping OH 4585 $4,789 $1.04 0
100332 05/24/16 There Tomorrow OH 6580 $6,580 $1.00 0
100333 05/25/16 Anytime Delivery WV 9872 $9,888 $1.00 1
100334 05/26/16 Save Time IN 4657 $4,490 $0.96 1
100335 05/27/16 There Tomorrow KY 3452 $3,321 $0.96 0
100336 05/28/16 Save Time IN 6422 $6,587 $1.03 1
100337 05/29/16 Express Shipping KY 3211 $3,200 $1.00 0
100338 05/30/16 Express Shipping KY 1009 $1,000 $0.99 0
100339 05/31/16 Anytime Delivery WV 2546 $2,398 $0.94 1
100340 06/01/16 There Tomorrow KY 4870 $4,376 $0.90 0
100341 06/02/16 Anytime Delivery WV 9832 $9,333 $0.95 1
100342 06/03/16 There Tomorrow OH 6790 $6,457 $0.95 0
100343 06/04/16 Anytime Delivery VA 9045 $9,546 $1.06 1
100344 06/05/16 Anytime Delivery KY 9264 $10,000 $1.08 1
100345 06/06/16 Anytime Delivery VA 4465 $6,585 $1.47 1
100346 06/07/16 Save Time KY 9086 $9,081 $1.00 1
100347 06/08/16 Save Time KY 7834 $6,754 $0.86 1
100348 06/09/16 Save Time KY 7890 $7,689 $0.97 1
100349 06/10/16 Count on Us PA 4768 $5,211 $1.09 1
100350 06/11/16 There Tomorrow KY 4311 $4,123 $0.96 0
100351 06/12/16 Anytime Delivery KY 4674 $4,500 $0.96 1
100352 06/13/16 Save Time OH 2265 $2,211 $0.98 1
100353 06/14/16 Express Shipping OH 2695 $2,432 $0.90 0
100354 06/15/16 Save Time MI 3786 $3,687 $0.97 1
100355 06/16/16 Anytime Delivery VA 9763 $9,999 $1.02 1
100356 06/17/16 Save Time PA 3290 $3,470 $1.05 1
100357 06/18/16 There Tomorrow PA 8765 $9,800 $1.12 0
100358 06/19/16 Express Shipping OH 5355 $5,098 $0.95 0
100359 06/20/16 Save Time MI 7678 $7,700 $1.00 1
100360 06/21/16 There Tomorrow PA 9082 $9,082 $1.00 0
100361 06/22/16 Anytime Delivery KY 1278 $1,543 $1.21 1
100362 06/23/16 Anytime Delivery VA 1297 $1,100 $0.85 1
100363 06/24/16 Anytime Delivery KY 6522 $4,367 $0.67 1
100364 06/25/16 Save Time KY 5742 $6,000 $1.04 1
100365 06/26/16 Anytime Delivery VA 3678 $6,500 $1.77 1
100366 06/27/16 Save Time OH 9011 $9,000 $1.00 1
100367 06/28/16 Express Shipping KY 2145 $2,254 $1.05 0
100368 06/29/16 Express Shipping MI 2133 $2,200 $1.03 0
100369 06/30/16 Save Time KY 4567 $4,478 $0.98 1
100370 07/01/16 Save Time MI 4575 $4,498 $0.98 1
100371 07/02/16 Save Time IN 5323 $5,324 $1.00 1
100372 07/03/16 Count on Us OH 6334 $6,123 $0.97 0
100373 07/04/16 There Tomorrow IN 5322 $5,576 $1.05 0
100374 07/05/16 Anytime Delivery KY 5678 $5,400 $0.95 1
100375 07/06/16 Save Time OH 3465 $3,209 $0.93 1
100376 07/07/16 Express Shipping KY 8932 $8,800 $0.99 0
100377 07/08/16 Save Time IN 4366 $4,578 $1.05 1
100378 07/09/16 Anytime Delivery OH 6890 $6,900 $1.00 1
100379 07/10/16 Save Time IN 3365 $3,198 $0.95 1
100380 07/11/16 There Tomorrow PA 5109 $4,600 $0.90 0
100381 07/12/16 Express Shipping MI 4566 $4,657 $1.02 0
100382 07/13/16 Save Time PA 4790 $4,219 $0.88 1
100383 07/14/16 There Tomorrow OH 4886 $4,321 $0.88 0
100384 07/15/16 Anytime Delivery KY 5789 $5,608 $0.97 1
100385 07/16/16 Anytime Delivery VA 6544 $6,811 $1.04 1
100386 07/17/16 Anytime Delivery KY 4345 $3,289 $0.76 1
100387 07/18/16 Save Time OH 2132 $2,000 $0.94 1
100388 07/19/16 Anytime Delivery PA 6979 $7,932 $1.14 1
100389 07/20/16 Save Time OH 3364 $3,333 $0.99 1
100390 07/21/16 Express Shipping MI 3244 $3,543 $1.09 0
100391 07/22/16 Express Shipping PA 4387 $4,129 $0.94 0
100392 07/23/16 There Tomorrow KY 4367 $4,576 $1.05 0
100393 07/24/16 Anytime Delivery VA 4673 $4,700 $1.01 1
100394 07/25/16 Save Time IN 4532 $4,875 $1.08 1
100395 07/26/16 There Tomorrow PA 4806 $4,509 $0.94 0
100396 07/27/16 Save Time IN 2112 $2,110 $1.00 1
100397 07/28/16 Express Shipping PA 4675 $4,800 $1.03 0
100398 07/29/16 Express Shipping IN 4566 $4,481 $0.98 0
100399 07/30/16 Anytime Delivery KY 4683 $4,576 $0.98 1
100400 07/31/16 There Tomorrow OH 4533 $4,600 $1.01 0
100401 08/01/16 Anytime Delivery KY 1111 $1,234 $1.11 1
100402 08/02/16 There Tomorrow KY 7865 $7,865 $1.00 0
100403 08/03/16 Anytime Delivery PA 4376 $4,000 $0.91 1
100404 08/04/16 Anytime Delivery KY 8954 $8,876 $0.99 1
100405 08/05/16 Anytime Delivery VA 5467 $6,300 $1.15 1
100406 08/06/16 Save Time IN 5368 $5,478 $1.02 1
100407 08/07/16 Save Time OH 4323 $4,500 $1.04 1
100408 08/08/16 Save Time PA 5689 $5,387 $0.95 1
100409 08/09/16 Count on Us OH 7478 $7,321 $0.98 0
100410 08/10/16 There Tomorrow PA 5489 $5,621 $1.02 0
100411 08/11/16 Anytime Delivery MI 3100 $3,000 $0.97 1
100412 08/12/16 Save Time PA 3255 $3,300 $1.01 1
100413 08/13/16 Express Shipping OH 7686 $7,465 $0.97 0
100414 08/14/16 Save Time OH 8066 $8,321 $1.03 1
100415 08/15/16 Anytime Delivery WV 5456 $6,576 $1.21 1
100416 08/16/16 Save Time OH 6932 $6,687 $0.96 1
100417 08/17/16 There Tomorrow OH 4536 $4,487 $0.99 0
100418 08/18/16 Express Shipping OH 2154 $2,354 $1.09 0
100419 08/19/16 Save Time KY 4367 $2,311 $0.53 1
100420 08/20/16 There Tomorrow KY 4578 $4,600 $1.00 0
100421 08/21/16 Anytime Delivery OH 6555 $6,798 $1.04 1
100422 08/22/16 Anytime Delivery WV 5209 $4,765 $0.91 1
100423 08/23/16 Anytime Delivery OH 3646 $3,345 $0.92 0
100424 08/24/16 Save Time OH 4894 $4,654 $0.95 1
100425 08/25/16 Anytime Delivery OH 1636 $1,500 $0.92 1
100426 08/26/16 Save Time KY 2563 $2,578 $1.01 1
100427 08/27/16 Express Shipping PA 3654 $3,476 $0.95 0
100428 08/28/16 Express Shipping OH 3769 $3,456 $0.92 0
100429 08/29/16 Save Time OH 8457 $8,128 $0.96 1
100430 08/30/16 Save Time PA 4367 $4,521 $1.04 0
100431 08/31/16 Save Time OH 3551 $3,212 $0.90 0
100432 09/01/16 Count on Us KY 8442 $8,000 $0.95 0
100433 09/02/16 There Tomorrow KY 2354 $2,000 $0.85 0
100434 09/03/16 Anytime Delivery KY 8964 $8,911 $0.99 1
100435 09/04/16 Save Time OH 6578 $5,999 $0.91 0
100436 09/05/16 Express Shipping OH 4505 $4,309 $0.96 0
100437 09/06/16 Save Time KY 6590 $5,999 $0.91 0
100438 09/07/16 Anytime Delivery WV 5821 $5,232 $0.90 1
100439 09/08/16 Save Time KY 8675 $8,801 $1.01 1
100440 09/09/16 There Tomorrow KY 9865 $9,787 $0.99 0
100441 09/10/16 Express Shipping IN 8556 $8,666 $1.01 1
100442 09/11/16 Save Time PA 4232 $4,000 $0.95 0
100443 09/12/16 There Tomorrow OH 6576 $6,112 $0.93 0
100444 09/13/16 Anytime Delivery OH 4874 $4,356 $0.89 0
100445 09/14/16 Anytime Delivery PA 3576 $4,533 $1.27 1
100446 09/15/16 Anytime Delivery OH 9044 $9,021 $1.00 1
100447 09/16/16 Save Time OH 6755 $6,987 $1.03 0
100448 09/17/16 Anytime Delivery WV 4567 $4,456 $0.98 1
100449 09/18/16 Save Time OH 5487 $5,123 $0.93 0
100450 09/19/16 Express Shipping IN 6098 $6,000 $0.98 0
100451 09/20/16 Express Shipping OH 9234 $8,134 $0.88 0
100452 09/21/16 There Tomorrow IN 5489 $5,245 $0.96 0
100453 09/22/16 Anytime Delivery KY 4380 $4,000 $0.91 1
100454 09/23/16 Save Time OH 8777 $9,101 $1.04 0
100455 09/24/16 There Tomorrow KY 6590 $6,893 $1.05 0
100456 09/25/16 Save Time OH 6456 $5,982 $0.93 0
100457 09/26/16 Express Shipping PA 4365 $3,987 $0.91 0
100458 09/27/16 Express Shipping OH 1098 $1,000 $0.91 0
100459 09/28/16 Anytime Delivery WV 3089 $4,500 $1.46 1
100460 09/29/16 There Tomorrow PA 1278 $1,100 $0.86 0
100461 09/30/16 Anytime Delivery VA 5982 $5,600 $0.94 1
100462 10/01/16 There Tomorrow PA 8011 $8,000 $1.00 0
100463 10/02/16 Anytime Delivery OH 2198 $2,150 $0.98 1
100464 10/03/16 Anytime Delivery OH 4578 $6,572 $1.44 1
100465 10/04/16 Anytime Delivery OH 2176 $2,175 $1.00 1
100466 10/05/16 Save Time OH 3590 $3,400 $0.95 0
100467 10/06/16 Save Time KY 4567 $4,390 $0.96 0
100468 10/07/16 Save Time OH 3100 $2,789 $0.90 0
100469 10/08/16 Count on Us IN 4544 $4,500 $0.99 0
100470 10/09/16 There Tomorrow KY 4732 $4,999 $1.06 0
100471 10/10/16 Anytime Delivery IN 3467 $3,308 $0.95 1
100472 10/11/16 Save Time OH 3478 $3,200 $0.92 0
100473 10/12/16 Express Shipping KY 5467 $5,500 $1.01 0
100474 10/13/16 Save Time MI 9076 $9,099 $1.00 0
100475 10/14/16 Anytime Delivery OH 4675 $4,532 $0.97 1
100476 10/15/16 Save Time OH 5767 $5,800 $1.01 0
100477 10/16/16 There Tomorrow IN 6666 $8,201 $1.23 0
100478 10/17/16 Express Shipping PA 8736 $7,900 $0.90 0
100479 10/18/16 Save Time MI 6666 $6,666 $1.00 0
100480 10/19/16 There Tomorrow PA 3672 $3,981 $1.08 0
100481 10/20/16 Anytime Delivery OH 6788 $6,800 $1.00 1
100482 10/21/16 Anytime Delivery WV 4790 $4,678 $0.98 1
100483 10/22/16 Anytime Delivery OH 5476 $5,210 $0.95 0
100484 10/23/16 Save Time KY 5455 $4,999 $0.92 0
100485 10/24/16 There Tomorrow KY 2176 $2,019 $0.93 0
100486 10/25/16 Count on Us PA 5678 $5,476 $0.96 0
100487 10/26/16 There Tomorrow PA 4974 $4,454 $0.90 0
100488 10/27/16 There Tomorrow IN 3490 $3,000 $0.86 0
100489 10/28/16 Anytime Delivery KY 7878 $7,692 $0.98 1
100490 10/29/16 There Tomorrow IN 2109 $2,001 $0.95 0
100491 10/30/16 Anytime Delivery KY 7035 $6,789 $0.97 0
100492 10/31/16 Count on Us PA 5698 $5,476 $0.96 0
100493 11/01/16 There Tomorrow PA 5762 $5,982 $1.04 0
100494 11/02/16 Save Time IN 1145 $1,000 $0.87 0
100495 11/03/16 There Tomorrow OH 2189 $2,243 $1.02 0
100496 11/04/16 Save Time MI 7832 $7,586 $0.97 0
100497 11/05/16 Express Shipping OH 4327 $4,123 $0.95 0
100498 11/06/16 Express Shipping IN 2879 $2,654 $0.92 0
100499 11/07/16 Express Shipping KY 3678 $3,421 $0.93 0
100500 11/08/16 Save Time OH 5789 $5,298 $0.92 0
100501 11/09/16 Express Shipping IN 9468 $9,200 $0.97 0
100502 11/10/16 Express Shipping PA 9812 $9,999 $1.02 0
100503 11/11/16 Express Shipping IN 4387 $4,490 $1.02 0
100504 11/12/16 Save Time OH 4678 $4,198 $0.90 0
100505 11/13/16 Save Time KY 3421 $3,209 $0.94 0
100506 11/14/16 Count on Us KY 7485 $7,232 $0.97 0
100507 11/15/16 Save Time OH 2564 $2,456 $0.96 0
100508 11/16/16 Anytime Delivery KY 2146 $2,100 $0.98 0
100509 11/17/16 Express Shipping OH 8021 $8,000 $1.00 0
100510 11/18/16 There Tomorrow KY 3685 $3,409 $0.93 0
100511 11/19/16 Count on Us IN 3108 $3,100 $1.00 1
100512 11/20/16 Express Shipping MI 3566 $3,498 $0.98 0
100513 11/21/16 Count on Us PA 9667 $9,487 $0.98 1
100514 11/22/16 Express Shipping KY 3667 $3,245 $0.88 0
100515 11/23/16 Express Shipping KY 8066 $8,019 $0.99 0
100516 11/24/16 There Tomorrow MI 5678 $5,876 $1.03 0
100517 11/25/16 Count on Us MI 5389 $5,790 $1.07 1
100518 11/26/16 Save Time MI 4534 $4,293 $0.95 0
100519 11/27/16 Express Shipping PA 5778 $5,345 $0.93 0
100520 11/28/16 There Tomorrow KY 2500 $3,456 $1.38 0
100521 11/29/16 Count on Us IN 2322 $2,300 $0.99 1
100522 11/30/16 Save Time PA 5244 $4,900 $0.93 0
100523 12/01/16 Count on Us IN 5745 $6,100 $1.06 1
100524 12/02/16 Count on Us KY 8767 $8,690 $0.99 0
100525 12/03/16 Count on Us OH 8564 $8,345 $0.97 0
100526 12/04/16 Save Time OH 2562 $2,299 $0.90 0
100527 12/05/16 Count on Us OH 2222 $2,221 $1.00 0
100528 12/06/16 Count on Us OH 7657 $7,000 $0.91 0
100529 12/07/16 Count on Us OH 3452 $3,452 $1.00 0
100530 12/08/16 Anytime Delivery OH 5873 $5,687 $0.97 0
100531 12/09/16 Save Time OH 5763 $5,490 $0.95 0
100532 12/10/16 Count on Us PA 4769 $4,321 $0.91 0
100533 12/11/16 Save Time OH 4567 $4,109 $0.90 0
100534 12/12/16 Anytime Delivery OH 7556 $7,208 $0.95 0
100535 12/13/16 There Tomorrow OH 2450 $3,500 $1.43 0
100536 12/14/16 Count on Us OH 7687 $7,219 $0.94 1
100537 12/15/16 Save Time PA 6446 $6,200 $0.96 0
100538 12/16/16 Anytime Delivery IN 9043 $9,000 $1.00 0
100539 12/17/16 Anytime Delivery KY 4000 $3,300 $0.83 0
100540 12/18/16 There Tomorrow OH 8754 $8,576 $0.98 0
100541 12/19/16 There Tomorrow PA 8554 $8,321 $0.97 0
100542 12/20/16 Express Shipping KY 5490 $2,675 $0.49 0
100543 12/21/16 Save Time OH 6545 $6,133 $0.94 0
100544 12/22/16 Save Time IN 5798 $5,466 $0.94 0
100545 12/23/16 Save Time OH 4853 $4,678 $0.96 0
100546 12/24/16 Save Time OH 6732 $6,921 $1.03 0
100547 12/25/16 Anytime Delivery WV 9345 $9,300 $1.00 0
100548 12/26/16 Express Shipping PA 3170 $3,000 $0.95 0
100549 12/27/16 Anytime Delivery OH 4563 $4,276 $0.94 0
100550 12/28/16 Save Time OH 5380 $5,000 $0.93 0
100551 12/29/16 Express Shipping KY 9090 $9,900 $1.09 0
100552 12/30/16 There Tomorrow PA 8945 $8,634 $0.97 0
100553 12/31/16 Express Shipping MI 2311 $2,567 $1.11 0
100554 01/01/17 Save Time OH 2437 $2,134 $0.88 0
100555 01/02/17 Save Time OH 4754 $4,654 $0.98 0
100556 01/03/17 Anytime Delivery WV 4356 $3,987 $0.92 0
100557 01/04/17 Count on Us OH 5769 $5,876 $1.02 0
100558 01/05/17 Count on Us MI 4356 $4,675 $1.07 0
100559 01/06/17 There Tomorrow KY 4356 $4,567 $1.05 0
100560 01/07/17 Count on Us PA 5832 $6,100 $1.05 0
100561 01/08/17 Save Time MI 4877 $4,678 $0.96 1
100562 01/09/17 Save Time KY 7457 $7,000 $0.94 1
100563 01/10/17 Save Time PA 8987 $8,675 $0.97 1
100564 01/11/17 Anytime Delivery PA 7687 $7,111 $0.93 0
100565 01/12/17 There Tomorrow PA 9870 $9,999 $1.01 0
100566 01/13/17 Save Time PA 1087 $944 $0.87 1
100567 01/14/17 There Tomorrow KY 4365 $4,765 $1.09 0
100568 01/15/17 Count on Us IN 1256 $1,732 $1.38 0
100569 01/16/17 There Tomorrow OH 2134 $2,765 $1.30 0
100570 01/17/17 There Tomorrow KY 6578 $6,432 $0.98 0
100571 01/18/17 Anytime Delivery OH 9808 $9,100 $0.93 0
100572 01/19/17 There Tomorrow PA 9808 $9,888 $1.01 0
100573 01/20/17 Anytime Delivery OH 2233 $2,000 $0.90 0
100574 01/21/17 Count on Us PA 4365 $6,578 $1.51 0
100575 01/22/17 There Tomorrow PA 6812 $6,999 $1.03 0
100576 01/23/17 Save Time KY 8732 $6,321 $0.72 1
100577 01/24/17 There Tomorrow PA 5430 $5,600 $1.03 0
100578 01/25/17 Save Time PA 1209 $1,100 $0.91 1
100579 01/26/17 Express Shipping OH 5646 $5,600 $0.99 0
100580 01/27/17 Express Shipping OH 7867 $7,800 $0.99 0
100581 01/28/17 Express Shipping PA 3452 $4,500 $1.30 0
100582 01/29/17 Save Time IN 4687 $4,700 $1.00 1
100583 01/30/17 Express Shipping PA 5636 $5,432 $0.96 0
100584 01/31/17 Express Shipping PA 3567 $3,278 $0.92 0
100585 02/01/17 Express Shipping PA 3795 $3,600 $0.95 0
100586 02/02/17 Save Time OH 6907 $6,832 $0.99 1
100587 02/03/17 Save Time KY 9011 $8,999 $1.00 1
100588 02/04/17 Count on Us KY 6789 $5,467 $0.81 0
100589 02/05/17 Save Time OH 5733 $5,676 $0.99 1
100590 02/06/17 Anytime Delivery KY 6536 $6,432 $0.98 1
100591 02/07/17 Express Shipping KY 9865 $9,800 $0.99 0
100592 02/08/17 There Tomorrow PA 9021 $9,345 $1.04 0
100593 02/09/17 Count on Us PA 5369 $5,621 $1.05 0
100594 02/10/17 Express Shipping PA 3657 $3,478 $0.95 0
100595 02/11/17 Count on Us PA 4367 $4,234 $0.97 0
100596 02/12/17 Express Shipping KY 5765 $5,621 $0.98 0
100597 02/13/17 Express Shipping PA 5687 $5,700 $1.00 0
100598 02/14/17 There Tomorrow KY 3287 $3,765 $1.15 0
100599 02/15/17 Count on Us PA 1233 $1,543 $1.25 1
100600 02/16/17 Save Time IN 4356 $4,000 $0.92 1
100601 02/17/17 Express Shipping PA 3664 $3,500 $0.96 1
100602 02/18/17 There Tomorrow PA 5678 $5,777 $1.02 0
100603 02/19/17 Count on Us OH 5435 $5,590 $1.03 0
100604 02/20/17 Save Time IN 4786 $4,576 $0.96 1
100605 02/21/17 Count on Us OH 4322 $4,322 $1.00 0
100606 02/22/17 Count on Us OH 8900 $9,001 $1.01 1
100607 02/23/17 Count on Us KY 9032 $1,277 $0.14 1
100608 02/24/17 Save Time OH 1937 $1,876 $0.97 1
100609 02/25/17 Count on Us PA 5326 $5,500 $1.03 0
100610 02/26/17 Count on Us KY 3421 $2,233 $0.65 0
100611 02/27/17 Count on Us KY 6890 $7,000 $1.02 0
100612 02/28/17 Anytime Delivery OH 3684 $3,500 $0.95 1
100613 03/01/17 Save Time MI 3658 $3,290 $0.90 1
100614 03/02/17 Count on Us IN 1987 $1,876 $0.94 0
100615 03/03/17 Save Time OH 4793 $4,400 $0.92 1
100616 03/04/17 Anytime Delivery KY 8942 $8,300 $0.93 1
100617 03/05/17 There Tomorrow OH 4378 $4,500 $1.03 0
100618 03/06/17 Count on Us IN 6574 $6,698 $1.02 0
100619 03/07/17 Save Time IN 9563 $8,233 $0.86 1
100620 03/08/17 Save Time OH 6389 $6,132 $0.96 1
100621 03/09/17 Save Time IN 4674 $4,219 $0.90 1
100622 03/10/17 Anytime Delivery KY 6789 $5,678 $0.84 1
100623 03/11/17 Count on Us PA 5390 $5,300 $0.98 0
100624 03/12/17 Count on Us PA 4374 $4,109 $0.94 0
100625 03/13/17 There Tomorrow IN 6438 $6,000 $0.93 0
100626 03/14/17 Count on Us OH 1854 $1,800 $0.97 1
100627 03/15/17 Save Time KY 3211 $3,254 $1.01 1
100628 03/16/17 Save Time PA 5789 $6,398 $1.11 1
100629 03/17/17 Save Time PA 3790 $3,600 $0.95 1
100630 03/18/17 Anytime Delivery VA 7874 $7,500 $0.95 1
100631 03/19/17 There Tomorrow IN 9045 $9,000 $1.00 0
100632 03/20/17 Save Time OH 5468 $5,222 $0.96 1
100633 03/21/17 There Tomorrow KY 6109 $6,354 $1.04 0
100634 03/22/17 Count on Us IN 2222 $2,345 $1.06 0
100635 03/23/17 There Tomorrow OH 7800 $7,932 $1.02 0
100636 03/24/17 There Tomorrow IN 9878 $9,888 $1.00 0
100637 03/25/17 Anytime Delivery KY 8932 $6,758 $0.76 1
100638 03/26/17 There Tomorrow IN 5879 $6,578 $1.12 0
100639 03/27/17 Anytime Delivery OH 3266 $4,355 $1.33 1
100640 03/28/17 Count on Us IN 3043 $3,000 $0.99 0
100641 03/29/17 There Tomorrow IN 9045 $9,000 $1.00 0
100642 03/30/17 Save Time KY 1243 $1,500 $1.21 1
100643 03/31/17 There Tomorrow MI 5378 $5,890 $1.10 0
100644 04/01/17 Save Time OH 3200 $3,300 $1.03 2
100645 04/02/17 Express Shipping MI 4769 $4,321 $0.91 0
100646 04/03/17 Express Shipping OH 4368 $4,189 $0.96 1
100647 04/04/17 Express Shipping OH 4879 $4,987 $1.02 0
100648 04/05/17 Save Time PA 4794 $4,298 $0.90 1
100649 04/06/17 Express Shipping OH 3254 $3,121 $0.96 0
100650 04/07/17 Express Shipping OH 1270 $1,360 $1.07 1
100651 04/08/17 Express Shipping MI 2467 $2,111 $0.86 0
100652 04/09/17 Save Time OH 8000 $8,231 $1.03 2
100653 04/10/17 Save Time OH 3693 $3,333 $0.90 2
100654 04/11/17 Count on Us MI 4356 $4,598 $1.06 0
100655 04/12/17 Save Time OH 8126 $7,709 $0.95 0
100656 04/13/17 Anytime Delivery KY 6784 $5,487 $0.81 2
100657 04/14/17 Express Shipping KY 3575 $3,800 $1.06 0
100658 04/15/17 There Tomorrow MI 7465 $7,321 $0.98 0
100659 04/16/17 Count on Us KY 5349 $5,567 $1.04 0
100660 04/17/17 Express Shipping IN 7890 $7,980 $1.01 2
100661 04/18/17 Count on Us OH 5489 $5,643 $1.03 0
100662 04/19/17 Express Shipping OH 3479 $3,200 $0.92 0
100663 04/20/17 Express Shipping MI 4732 $4,689 $0.99 0
100664 04/21/17 There Tomorrow KY 1743 $1,743 $1.00 0
100665 04/22/17 Count on Us IN 8576 $8,398 $0.98 0
100666 04/23/17 Save Time KY 6543 $4,581 $0.70 0
100667 04/24/17 Express Shipping IN 9876 $8,900 $0.90 1
100668 04/25/17 There Tomorrow OH 3453 $3,298 $0.96 0
100669 04/26/17 Count on Us IN 2465 $2,400 $0.97 0
100670 04/27/17 Save Time OH 3564 $3,564 $1.00 0
100671 04/28/17 Count on Us OH 3576 $3,400 $0.95 0
100672 04/29/17 Count on Us IN 7821 $7,765 $0.99 0
100673 04/30/17 Count on Us OH 7045 $6,987 $0.99 0
100674 05/01/17 Save Time OH 5478 $5,478 $1.00 0
100675 05/02/17 Count on Us OH 6587 $6,111 $0.93 0
100676 05/03/17 Count on Us KY 2143 $2,000 $0.93 0
100677 05/04/17 Count on Us IN 3132 $2,543 $0.81 1
100678 05/05/17 Anytime Delivery KY 2689 $2,432 $0.90 2
100679 05/06/17 Save Time OH 5555 $5,252 $0.95 0
100680 05/07/17 Count on Us OH 5467 $5,489 $1.00 0
100681 05/08/17 Save Time OH 1543 $1,542 $1.00 0
100682 05/09/17 Anytime Delivery PA 6778 $6,354 $0.94 2
100683 05/10/17 There Tomorrow OH 7890 $8,001 $1.01 0
100684 05/11/17 Count on Us KY 3290 $3,500 $1.06 0
100685 05/12/17 Save Time OH 2450 $2,200 $0.90 0
100686 05/13/17 Save Time PA 4609 $4,432 $0.96 0
100687 05/14/17 Save Time IN 3576 $3,412 $0.95 0
100688 05/15/17 Anytime Delivery IN 4765 $4,600 $0.97 0
100689 05/16/17 Count on Us OH 9664 $8,400 $0.87 0
100690 05/17/17 Count on Us MI 7490 $7,500 $1.00 0
100691 05/18/17 There Tomorrow IN 4325 $4,500 $1.04 0
100692 05/19/17 Count on Us KY 8091 $7,633 $0.94 0
100693 05/20/17 Save Time IN 6437 $6,466 $1.00 0
100694 05/21/17 Save Time MI 2321 $2,000 $0.86 0
100695 05/22/17 Save Time KY 2574 $2,500 $0.97 0
100696 05/23/17 Anytime Delivery KY 6964 $6,854 $0.98 0
100697 05/24/17 There Tomorrow IN 3657 $4,000 $1.09 0
100698 05/25/17 Save Time OH 4589 $4,300 $0.94 0
100699 05/26/17 There Tomorrow PA 7543 $7,689 $1.02 0
100700 05/27/17 Count on Us PA 4321 $4,300 $1.00 0
100701 05/28/17 There Tomorrow IN 5908 $6,211 $1.05 0
100702 05/29/17 There Tomorrow IN 4368 $4,500 $1.03 0
100703 05/30/17 Anytime Delivery IN 2146 $2,000 $0.93 0
100704 05/31/17 There Tomorrow KY 2547 $2,546 $1.00 0
100705 06/01/17 Anytime Delivery WV 7809 $8,000 $1.02 0
100706 06/02/17 Count on Us IN 4321 $4,432 $1.03 0
100707 06/03/17 There Tomorrow IN 5789 $5,900 $1.02 0
100708 06/04/17 Save Time OH 3675 $3,656 $0.99 0
100709 06/05/17 There Tomorrow IN 3573 $3,573 $1.00 0
100710 06/06/17 Save Time PA 4100 $4,400 $1.07 0
100711 06/07/17 Express Shipping KY 6721 $6,903 $1.03 0
100712 06/08/17 Express Shipping IN 4382 $4,000 $0.91 0
100713 06/09/17 Express Shipping KY 3277 $3,478 $1.06 1
100714 06/10/17 Save Time KY 6554 $6,687 $1.02 0
100715 06/11/17 Express Shipping IN 6292 $6,000 $0.95 0
100716 06/12/17 Express Shipping IN 4365 $4,400 $1.01 0
100717 06/13/17 Express Shipping IN 2462 $2,800 $1.14 0
100718 06/14/17 Save Time OH 9120 $8,000 $0.88 0
100719 06/15/17 Save Time OH 8654 $6,941 $0.80 0
100720 06/16/17 Count on Us KY 2198 $2,398 $1.09 0
100721 06/17/17 Save Time PA 7903 $8,000 $1.01 0
100722 06/18/17 Anytime Delivery OH 2574 $2,400 $0.93 0
100723 06/19/17 Express Shipping OH 7898 $7,900 $1.00 0
100724 06/20/17 There Tomorrow KY 3256 $3,700 $1.14 0
100725 06/21/17 Count on Us IN 3768 $3,654 $0.97 0
100726 06/22/17 Express Shipping IN 1565 $1,400 $0.89 0
100727 06/23/17 Count on Us IN 8490 $8,321 $0.98 0
100728 06/24/17 Express Shipping OH 3265 $3,654 $1.12 1
100729 06/25/17 Express Shipping IN 2368 $2,000 $0.84 0
100730 06/26/17 There Tomorrow IN 8743 $8,888 $1.02 0
100731 06/27/17 Count on Us IN 5032 $5,000 $0.99 0
100732 06/28/17 Save Time OH 1987 $1,765 $0.89 0
100733 06/29/17 Express Shipping PA 3690 $3,200 $0.87 1
100734 06/30/17 There Tomorrow PA 7098 $7,321 $1.03 0
100735 07/01/17 Count on Us PA 5387 $4,900 $0.91 0
100736 07/02/17 Save Time OH 4946 $4,576 $0.93 0
100737 07/03/17 Count on Us PA 1094 $1,000 $0.91 0
100738 07/04/17 Count on Us PA 7598 $7,000 $0.92 2
100739 07/05/17 Count on Us PA 6457 $6,400 $0.99 0
100740 07/06/17 Save Time OH 3567 $3,277 $0.92 0
100741 07/07/17 Count on Us PA 6438 $6,438 $1.00 0
100742 07/08/17 Count on Us PA 2582 $2,400 $0.93 0
100743 07/09/17 Count on Us OH 4700 $4,465 $0.95 0
100744 07/10/17 Anytime Delivery KY 9365 $9,600 $1.03 0
100745 07/11/17 Save Time OH 2568 $2,500 $0.97 0
100746 07/12/17 Count on Us MI 4364 $4,231 $0.97 0
100747 07/13/17 Save Time KY 6954 $7,000 $1.01 0
100748 07/14/17 Anytime Delivery WV 2555 $2,000 $0.78 2
100749 07/15/17 There Tomorrow OH 8654 $8,354 $0.97 0
100750 07/16/17 Count on Us OH 4794 $4,180 $0.87 0
100751 07/17/17 Save Time MI 3468 $3,300 $0.95 0
100752 07/18/17 Anytime Delivery KY 2576 $2,600 $1.01 2
100753 07/19/17 Anytime Delivery IN 3684 $3,600 $0.98 2
100754 07/20/17 There Tomorrow PA 3566 $3,566 $1.00 0
100755 07/21/17 There Tomorrow IN 2210 $2,000 $0.90 0
100756 07/22/17 Express Shipping IN 5333 $5,300 $0.99 0
100757 07/23/17 Save Time OH 8453 $8,200 $0.97 0
100758 07/24/17 Save Time OH 3754 $3,600 $0.96 0
100759 07/25/17 Save Time MI 1594 $1,059 $0.66 0
100760 07/26/17 Save Time KY 2567 $2,400 $0.93 0
100761 07/27/17 Anytime Delivery MI 7946 $7,900 $0.99 3
100762 07/28/17 Express Shipping KY 3563 $3,500 $0.98 2
100763 07/29/17 Anytime Delivery IN 4287 $4,500 $1.05 1
100764 07/30/17 Save Time OH 2745 $2,465 $0.90 0
100765 07/31/17 Express Shipping IN 1643 $2,500 $1.52 1
100766 08/01/17 There Tomorrow KY 4539 $4,200 $0.93 0
100767 08/02/17 Express Shipping KY 3965 $3,876 $0.98 1
100768 08/03/17 Express Shipping PA 7894 $7,800 $0.99 1
100769 08/04/17 Anytime Delivery OH 2694 $2,800 $1.04 1
100770 08/05/17 Express Shipping OH 4673 $4,567 $0.98 0
100771 08/06/17 Express Shipping KY 2344 $2,234 $0.95 0
100772 08/07/17 Express Shipping MI 4564 $4,465 $0.98 0
100773 08/08/17 Save Time PA 4765 $4,321 $0.91 0
100774 08/09/17 There Tomorrow MI 3456 $3,100 $0.90 0
100775 08/10/17 Express Shipping PA 6890 $6,798 $0.99 0
100776 08/11/17 Save Time OH 7577 $7,500 $0.99 0
100777 08/12/17 Count on Us KY 5488 $5,567 $1.01 0
100778 08/13/17 Count on Us PA 3668 $3,700 $1.01 0
100779 08/14/17 Save Time PA 4367 $4,478 $1.03 0
100780 08/15/17 Save Time KY 5432 $5,321 $0.98 0
100781 08/16/17 Save Time KY 5555 $5,600 $1.01 0
100782 08/17/17 Count on Us KY 6537 $6,904 $1.06 0
100783 08/18/17 There Tomorrow PA 5211 $5,690 $1.09 0
100784 08/19/17 Anytime Delivery OH 8076 $8,000 $0.99 1
100785 08/20/17 Save Time OH 4322 $4,576 $1.06 0
100786 08/21/17 Express Shipping KY 1275 $1,100 $0.86 0
100787 08/22/17 Save Time OH 6543 $6,654 $1.02 0
100788 08/23/17 Anytime Delivery OH 4532 $4,721 $1.04 1
100789 08/24/17 Save Time OH 4334 $4,454 $1.03 0
100790 08/25/17 There Tomorrow KY 6180 $6,100 $0.99 0
100791 08/26/17 Express Shipping OH 3547 $3,600 $1.01 0
100792 08/27/17 Save Time PA 5690 $5,798 $1.02 0
100793 08/28/17 There Tomorrow PA 6890 $7,213 $1.05 0
100794 08/29/17 Anytime Delivery OH 3578 $3,690 $1.03 1
100795 08/30/17 Anytime Delivery OH 4567 $4,765 $1.04 1
100796 08/31/17 Anytime Delivery IN 6578 $6,500 $0.99 1
100797 09/01/17 Save Time PA 4369 $4,509 $1.03 0
100798 09/02/17 Anytime Delivery OH 1987 $1,999 $1.01 1
100799 09/03/17 Save Time IN 4367 $4,521 $1.04 0
100800 09/04/17 Express Shipping IN 8905 $9,012 $1.01 0
100801 09/05/17 Express Shipping MI 6577 $6,600 $1.00 0
100802 09/06/17 There Tomorrow PA 6787 $6,989 $1.03 0
100803 09/07/17 Anytime Delivery OH 6234 $6,000 $0.96 1
100804 09/08/17 Save Time OH 3252 $3,200 $0.98 0
100805 09/09/17 There Tomorrow KY 5444 $4,533 $0.83 0
100806 09/10/17 Save Time KY 3244 $1,200 $0.37 0
100807 09/11/17 Express Shipping KY 8590 $8,690 $1.01 0
100808 09/12/17 Express Shipping MI 1209 $1,200 $0.99 0
100809 09/13/17 Anytime Delivery VA 8721 $8,698 $1.00 1
100810 09/14/17 There Tomorrow PA 4532 $5,432 $1.20 0
100811 09/15/17 Anytime Delivery VA 3331 $3,331 $1.00 1
100812 09/16/17 There Tomorrow OH 3672 $3,543 $0.96 0
100813 09/17/17 Anytime Delivery KY 5788 $5,387 $0.93 0
100814 09/18/17 Anytime Delivery MI 5766 $5,433 $0.94 0
100815 09/19/17 Anytime Delivery KY 5498 $5,600 $1.02 0
100816 09/20/17 Save Time IN 7890 $7,888 $1.00 0
100817 09/21/17 Save Time PA 8776 $8,677 $0.99 0
100818 09/22/17 Save Time OH 3211 $3,122 $0.97 0
100819 09/23/17 Count on Us OH 3654 $3,600 $0.99 0
100820 09/24/17 There Tomorrow PA 4387 $4,019 $0.92 0
100821 09/25/17 Anytime Delivery OH 8042 $7,687 $0.96 1
100822 09/26/17 Save Time OH 2156 $2,000 $0.93 0
100823 09/27/17 Express Shipping PA 9032 $8,754 $0.97 1
100824 09/28/17 Save Time OH 2169 $2,200 $1.01 0
100825 09/29/17 Anytime Delivery VA 5480 $4,888 $0.89 0
100826 09/30/17 Save Time OH 9250 $8,790 $0.95 0
100827 10/01/17 There Tomorrow KY 7549 $7,549 $1.00 0
100828 10/02/17 Express Shipping IN 8944 $8,766 $0.98 1
100829 10/03/17 Save Time OH 4673 $4,600 $0.98 0
100830 10/04/17 There Tomorrow MI 8908 $9,000 $1.01 0
100831 10/05/17 Anytime Delivery IN 8099 $9,000 $1.11 1
100832 10/06/17 Anytime Delivery KY 9088 $8,609 $0.95 0
100833 10/07/17 Anytime Delivery PA 3023 $3,456 $1.14 1
100834 10/08/17 Save Time IN 7843 $7,903 $1.01 0
100835 10/09/17 Anytime Delivery OH 9032 $9,988 $1.11 0
100836 10/10/17 Save Time KY 6777 $6,222 $0.92 0
100837 10/11/17 Express Shipping PA 2346 $3,521 $1.50 1
100838 10/12/17 Express Shipping OH 6459 $6,700 $1.04 0
100839 10/13/17 Save Time OH 3674 $3,843 $1.05 0
100840 10/14/17 Save Time PA 2462 $2,400 $0.97 0
100841 10/15/17 Save Time MI 2368 $2,400 $1.01 0
100842 10/16/17 Count on Us OH 7800 $7,980 $1.02 0
100843 10/17/17 There Tomorrow OH 5684 $5,500 $0.97 0
100844 10/18/17 Anytime Delivery MI 4889 $4,900 $1.00 1
100845 10/19/17 Save Time OH 7429 $7,129 $0.96 0
100846 10/20/17 Express Shipping PA 3677 $3,476 $0.95 0
100847 10/21/17 Save Time OH 7589 $7,012 $0.92 0
100848 10/22/17 Anytime Delivery OH 4216 $4,023 $0.95 0
100849 10/23/17 Save Time OH 5432 $4,999 $0.92 0
100850 10/24/17 There Tomorrow PA 3280 $3,500 $1.07 0
100851 10/25/17 Express Shipping IN 8976 $8,800 $0.98 0
100852 10/26/17 Save Time KY 3290 $3,345 $1.02 0
100853 10/27/17 There Tomorrow IN 7888 $7,989 $1.01 0
100854 10/28/17 Anytime Delivery VA 2697 $2,700 $1.00 0
100855 10/29/17 Anytime Delivery KY 6721 $4,389 $0.65 0
100856 10/30/17 Anytime Delivery PA 5387 $5,487 $1.02 0
100857 10/31/17 Save Time IN 4357 $4,000 $0.92 0
100858 11/01/17 Anytime Delivery MI 5333 $5,287 $0.99 0
100859 11/02/17 Save Time OH 5678 $5,476 $0.96 0
100860 11/03/17 Express Shipping MI 8799 $8,500 $0.97 0
100861 11/04/17 Express Shipping PA 9043 $8,765 $0.97 0
100862 11/05/17 There Tomorrow OH 5468 $5,690 $1.04 0
100863 11/06/17 Anytime Delivery WV 5621 $5,432 $0.97 0
100864 11/07/17 Save Time KY 5487 $5,300 $0.97 0
100865 11/08/17 There Tomorrow KY 4532 $4,400 $0.97 0
100866 11/09/17 Save Time OH 5789 $6,324 $1.09 0
100867 11/10/17 Express Shipping KY 1122 $1,000 $0.89 0
100868 11/11/17 Express Shipping MI 3211 $3,000 $0.93 0
100869 11/12/17 Anytime Delivery VA 6478 $6,300 $0.97 0
100870 11/13/17 There Tomorrow OH 2356 $2,200 $0.93 0
100871 11/14/17 Anytime Delivery WV 5489 $5,400 $0.98 0
100872 11/15/17 There Tomorrow OH 3684 $3,543 $0.96 0
100873 11/16/17 Anytime Delivery OH 4743 $4,432 $0.93 0
100874 11/17/17 Anytime Delivery WV 5853 $5,291 $0.90 0
100875 11/18/17 Anytime Delivery KY 6578 $5,643 $0.86 0
100876 11/19/17 Save Time OH 5247 $4,698 $0.90 0
100877 11/20/17 Save Time KY 3567 $3,498 $0.98 0
100878 11/21/17 Save Time KY 3532 $3,500 $0.99 0
100879 11/22/17 Count on Us OH 9687 $9,800 $1.01 0
100880 11/23/17 There Tomorrow MI 2311 $3,111 $1.35 0
100881 11/24/17 Anytime Delivery KY 3553 $3,600 $1.01 0
100882 11/25/17 Save Time OH 3500 $2,600 $0.74 0
100883 11/26/17 Express Shipping PA 4798 $4,698 $0.98 0
100884 11/27/17 Save Time OH 3563 $3,578 $1.00 0
100885 11/28/17 Anytime Delivery IN 5678 $5,000 $0.88 0
100886 11/29/17 Save Time OH 2233 $2,233 $1.00 0
100887 11/30/17 There Tomorrow PA 5693 $5,700 $1.00 0
100888 12/01/17 Express Shipping IN 8664 $8,900 $1.03 0
100889 12/02/17 Save Time OH 4675 $3,890 $0.83 0
100890 12/03/17 There Tomorrow PA 5385 $5,700 $1.06 0
100891 12/04/17 Anytime Delivery KY 1546 $1,500 $0.97 0
100892 12/05/17 Anytime Delivery PA 1200 $1,435 $1.20 0
100893 12/06/17 Anytime Delivery OH 8445 $8,500 $1.01 1
100894 12/07/17 Save Time KY 3465 $3,300 $0.95 0
100895 12/08/17 Anytime Delivery IN 3565 $3,123 $0.88 1
100896 12/09/17 Save Time KY 5389 $5,687 $1.06 0
100897 12/10/17 Express Shipping IN 5475 $5,213 $0.95 0
100898 12/11/17 Express Shipping KY 6578 $6,600 $1.00 0
100899 12/12/17 Save Time IN 3421 $3,333 $0.97 0
100900 12/13/17 Save Time OH 3467 $3,600 $1.04 0
100901 12/14/17 Save Time IN 3254 $2,999 $0.92 0
100902 12/15/17 Count on Us KY 8940 $9,014 $1.01 1
100903 12/16/17 There Tomorrow IN 2657 $2,765 $1.04 0
100904 12/17/17 Anytime Delivery MI 3678 $3,800 $1.03 1
100905 12/18/17 Save Time MI 6567 $6,400 $0.97 0
100906 12/19/17 Express Shipping IN 8953 $9,101 $1.02 0
100907 12/20/17 Save Time OH 8850 $6,753 $0.76 0
100908 12/21/17 Anytime Delivery PA 5673 $5,600 $0.99 1
100909 12/22/17 Save Time KY 2458 $2,654 $1.08 0
100910 12/23/17 There Tomorrow PA 3676 $3,700 $1.01 0
100911 12/24/17 Express Shipping PA 8965 $9,321 $1.04 1
100912 12/25/17 Save Time OH 10215 $9,088 $0.89 0
100913 12/26/17 There Tomorrow KY 7458 $7,643 $1.02 0
100914 12/27/17 Anytime Delivery VA 5785 $5,187 $0.90 1
100915 12/28/17 Anytime Delivery PA 4563 $4,600 $1.01 1
100916 12/29/17 Anytime Delivery KY 3563 $3,565 $1.00 1
100917 12/30/17 Save Time KY 8643 $8,000 $0.93 0
100918 12/31/17 Anytime Delivery OH 3122 $3,333 $1.07 1

Hoover Medical Supply
Memo
To:
Brian Hoover
From:
Ally Wilson
cc:
Euisung Jung
Date:
4/22/2020
Re:
Transportation Carrier Recommendation
1. Introduction
Please state the main purpose of this report. Include description of Hoover medical company; what they are trying to do, what do they expect from this report. What is your task; what tool will you use for analysis?
2. Recommendation
2-1. Coverage Analysis
Describe what make you analyze the transportation coverage? Describe what data have you analyzed for coverage analysis? Describe the table and chart.

Count of Invoice Number

Column Labels

Row Labels

IN

KY

MI

OH

PA

VA

WV

Grand Total

Anytime Delivery

16

41

8

43

14

27

25

174

Count on Us

19

21

8

31

26

105

Express Shipping

30

41

19

32

30

152

Save Time

29

45

26

114

32

246

There Tomorrow

25

40

9

30

37

141

Grand Total

119

188

70

250

139

27

25

818
2.2. Cost Analysis
Describe what make you analyze the cost? Describe what data have you analyzed for cost analysis? Describe the table and chart.

Row Labels

Average of Shipping Cost per Pound

Anytime Delivery

1.010093797

Count on Us

0.982408824

Express Shipping

0.983742883

Save Time

0.965505505

There Tomorrow

1.008501104

Grand Total

0.987959872

2.3. Reliability Analysis
Describe what make you analyze the reliability? Describe what data have you analyzed for reliability analysis? Describe the table and chart.

Row Labels

Average of Days Overdue

Anytime Delivery

0.850574713

Count on Us

0.152380952

Express Shipping

0.177631579

Save Time

0.735772358

There Tomorrow

0.113475177

Grand Total

0.474327628
3. Summary & Conclusion

IN Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 16 19 30 29 25 KY Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 41 21 41 45 40 MI Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 8 8 19 26 9 OH Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 43 31 32 114 30 PA Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 14 26 30 32 37 VA Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 27 WV Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 25
Total Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 1.0100937967830121 0.98240882395331053 0.9837428825378205 0.96550550469112095 1.0085011035107174
Total Anytime Delivery Count on Us Express Shipping Save Time There Tomorrow 0.85057471264367812 0.15238095238095239 0. 17763157894736842 0.73577235772357719 0.11347517730496454
1
2
BUD 6800

Te ch Proje ct #1 – Data Analys iswith Pivot Table s

50 Points Pos s ible

For thisas s ignme nt – you will de mons trateyour ability to us eExce l Pivot table s to analyzedata
and producecharts/graphsto aid you in pre s e nting your analys isand s upporting your
re comme ndations .

Cas eBackground::
Hoover Medical Supplies, Inc, is a large manufacturing company located in Columbus, Ohio.The
company is currently seeking to gain operational efficiencies in its supply chain by reducing the number
of transportation carriers that it is using from five to three.Brian Hoover, the CEO of Hoover Medical
Supplies has hired you to analyze its data and make a clear recommendation about how to reduce
transportation costs while retaining a high level of service from its best carriers. Hoover has customers
in Michigan, West Virginia, Virginia, Pennsylvania, Indiana, Kentucky and Ohio.

Data Available :
The HooverData_2021.xls file contains all the shipping invoices submitted by its current carriers and
paid by Hoover.Shipping is billed by the pound at a rate that considers fuel costs, driver costs and truck
costs.The file also includes data collected by tracking the delivery schedule of the shipments – reflected
in the column of Days Overdue. Late deliveries are not tolerated by Hoover’s customers and need to be
minimized within its carrier pool.

Proje ct Focus :
Carrier selection should be based on the assumptions that all environmental factors are equal and that
historical cost trends will continue.Review the historical data from the past several years to determine
your recommendation for the top three carriers that Hoover should continue to use.Be sure that the
three carriers recommended will provide adequate coverage of all states currently serviced.(Don’t
assume carriers will expand their services to states not currently served.)

1) Analyze the last 24 months of Hoover’s carrier transactions found in the data
file:HooverData_2021.xls. .

2) Apply what you learned about the use of Excel Pivot Tables and do a thorough analysis of the
data to determine which carriers provide the best service at the best price to the states that
Hoover services. Consider whether you should look at totals or averages in your analysis. Slice
and Dice (pivot) the data a number of different ways to help you in your analysis. Look at each
factor – service, price and quality. Spend some time thinking about the problem and how best to
analyze the data.

3) Review your analysis and determine the top three carriers that you recommend to be reta ined.
Prepare a memo to Mr. Brian Hoover in which you detail your recommendation for the top three
carriers with which Hoover should continue to do business. Organize your memo to be succinct
but informative. Be sure to support your recommendation with the facts and results of your
analysis because there are some biases amongst your co-workers that may distort their view of
the carriers. To better make your argument, your report must support your recommendation by
presenting the data using visualization techniques. Charts and graphs should be well designed
and labeled, and include legends, titles, and values where appropriate.

Apply Excel Pivot Tables and do a thorough analysis of the data.

Proje ct De live rable s :

You must demonstrate your ability to create and use pivot tables to complete this assignment.Save each
created Pivot Tables in your Excel workbook under a separate worksheet (tab).Create Charts on the
data elements that you will use to justify your recommendation in the word document.

Write a Me mo in MS-word with your recommendation of which three carriers Hoover should continue
to do business with. Be sure to support your recommendation with facts and numbers from the data
because there are some biases amongst your co-workers that may distort their view of the carriers.

To better make your argument, your report mus t include at least thre echarts and thre etable s
(designed in Excel and copy and pasted into Word) that support your recommendation.

Use a formal and professional writing style and tone in your report. Us ea Me mo template(found in
Micros oft Word).Address the memo to me – use your name in the “From” section. Check your
grammar and spelling.Use complete sentences and bullet lists to succinctly but thoroughly state the
results of your analysis and your recommendation.

Upload your update d Exce l file– (with all your Pivot table sthat you cre ate d to pe rform your
analys is ) and MS-Word re port to theBlackboard as s ignme nt page . Just be sure to analyze the data
from all angles.

I would like to remind you that this homework assignment must be completed and submitted
individua lly.

Point bre akdown: Total 50 point
 15 points for Excel document – demonstrating the correct use of Pivot Tables and a thorough
analysis of the data (file must be posted to Blackboard to receive credit).I define thorough
as 5 or more points of analysis.
 5 points for Prope r Analysis – Proper analysis uses the right variables, in the right form
 15 points for your Word Document – using a Me mo te mplateand a formal, professional tone
with attention to writing and style (also posted to Blackboard)
 10points for the graphics (tables and charts) inserted into your Word Document to illustrate and
support your recommendation
 10 points for clearly and concisely making a recommendation of 3 carriers to keep
 -50 Points for not using given Excel data

BUD 6800

Te ch Proje ct #1 – Data Analys iswith Pivot Table s

50 Points Pos s ible

For thisas s ignme nt – you will de mons trateyour ability to us eExce l Pivot table s to analyzedata
and producecharts/graphsto aid you in pre s e nting your analys isand s upporting your
re comme ndations .

Cas eBackground::
Hoover Medical Supplies, Inc, is a large manufacturing company located in Columbus, Ohio.The
company is currently seeking to gain operational efficiencies in its supply chain by reducing the number
of transportation carriers that it is using from five to three.Brian Hoover, the CEO of Hoover Medical
Supplies has hired you to analyze its data and make a clear recommendation about how to reduce
transportation costs while retaining a high level of service from its best carriers. Hoover has customers
in Michigan, West Virginia, Virginia, Pennsylvania, Indiana, Kentucky and Ohio.

Data Available :
The HooverData_2021.xls file contains all the shipping invoices submitted by its current carriers and
paid by Hoover.Shipping is billed by the pound at a rate that considers fuel costs, driver costs and truck
costs.The file also includes data collected by tracking the delivery schedule of the shipments – reflected
in the column of Days Overdue. Late deliveries are not tolerated by Hoover’s customers and need to be
minimized within its carrier pool.

Proje ct Focus :
Carrier selection should be based on the assumptions that all environmental factors are equal and that
historical cost trends will continue.Review the historical data from the past several years to determine
your recommendation for the top three carriers that Hoover should continue to use.Be sure that the
three carriers recommended will provide adequate coverage of all states currently serviced.(Don’t
assume carriers will expand their services to states not currently served.)

1) Analyze the last 24 months of Hoover’s carrier transactions found in the data
file:HooverData_2021.xls. .

2) Apply what you learned about the use of Excel Pivot Tables and do a thorough analysis of the
data to determine which carriers provide the best service at the best price to the states that
Hoover services. Consider whether you should look at totals or averages in your analysis. Slice
and Dice (pivot) the data a number of different ways to help you in your analysis. Look at each
factor – service, price and quality. Spend some time thinking about the problem and how best to
analyze the data.

3) Review your analysis and determine the top three carriers that you recommend to be reta ined.
Prepare a memo to Mr. Brian Hoover in which you detail your recommendation for the top three
carriers with which Hoover should continue to do business. Organize your memo to be succinct
but informative. Be sure to support your recommendation with the facts and results of your
analysis because there are some biases amongst your co-workers that may distort their view of
the carriers. To better make your argument, your report must support your recommendation by
presenting the data using visualization techniques. Charts and graphs should be well designed
and labeled, and include legends, titles, and values where appropriate.

Apply Excel Pivot Tables and do a thorough analysis of the data.

Proje ct De live rable s :

You must demonstrate your ability to create and use pivot tables to complete this assignment.Save each
created Pivot Tables in your Excel workbook under a separate worksheet (tab).Create Charts on the
data elements that you will use to justify your recommendation in the word document.

Write a Me mo in MS-word with your recommendation of which three carriers Hoover should continue
to do business with. Be sure to support your recommendation with facts and numbers from the data
because there are some biases amongst your co-workers that may distort their view of the carriers.

To better make your argument, your report mus t include at least thre echarts and thre etable s
(designed in Excel and copy and pasted into Word) that support your recommendation.

Use a formal and professional writing style and tone in your report. Us ea Me mo template(found in
Micros oft Word).Address the memo to me – use your name in the “From” section. Check your
grammar and spelling.Use complete sentences and bullet lists to succinctly but thoroughly state the
results of your analysis and your recommendation.

Upload your update d Exce l file– (with all your Pivot table sthat you cre ate d to pe rform your
analys is ) and MS-Word re port to theBlackboard as s ignme nt page . Just be sure to analyze the data
from all angles.

I would like to remind you that this homework assignment must be completed and submitted
individua lly.

Point bre akdown: Total 50 point
 15 points for Excel document – demonstrating the correct use of Pivot Tables and a thorough
analysis of the data (file must be posted to Blackboard to receive credit).I define thorough
as 5 or more points of analysis.
 5 points for Prope r Analysis – Proper analysis uses the right variables, in the right form
 15 points for your Word Document – using a Me mo te mplateand a formal, professional tone
with attention to writing and style (also posted to Blackboard)
 10points for the graphics (tables and charts) inserted into your Word Document to illustrate and
support your recommendation
 10 points for clearly and concisely making a recommendation of 3 carriers to keep
 -50 Points for not using given Excel data

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00