Hoover
Ally_Wilson02
TechProject1Word.docxHoover 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
