| | 3PL for the World, Inc. |
| | | Revenue | Cost per Package | Inventory Turns | Service Level | Perfect Order Rate |
| | Sep | $ 850,987 | $ 8.50 | 18.0 | 98% | 80% |
| | Oct | $ 865,254 | $ 7.80 | 21.2 | 96% | 77% |
| | Nov | $ 921,456 | $ 7.70 | 22.4 | 93% | 75% |
| | Dec | $ 930,231 | $ 8.25 | 25.9 | 90% | 62% |
| | Objective | $ 900,000 | $ 7.90 | 24 | 95% | 75% |
| | How good are you at creating graphs? If the data table is formatted well, then the automatic graph-building functions in Excel will make your job much easier! Let's practice: |
| | 1. Create a Line graph usiing one of the performance metrics. |
| | 2. Column (or bar) graph using the same data from #1. |
| | 3. Creat a Radar chart using all the metrics during the most recent period. |
| | 4. Create a Scatter (X,Y) plot -- with data in columns side-by-side |
| | 5. Create a Scatter (X,Y) graphs -- with data in columns that are NOT side-by-side |
Yuzhi Zhao
Week2-Graphingactivity.xlsx
