1 / 16

Supply Chain Management Spider Charts also known as Radar Charts

Supply Chain Management Spider Charts also known as Radar Charts. By Collin Ferre BusM 361. Spider Charts. What is a SpiderRadar Chart? How is it used? Exercises Additional Resources. Not actual data. Background.

Faraday
Télécharger la présentation

Supply Chain Management Spider Charts also known as Radar Charts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Supply Chain ManagementSpider Chartsalso known as Radar Charts By Collin Ferre BusM 361

  2. Spider Charts • What is a Spider\Radar Chart? • How is it used? • Exercises • Additional Resources Not actual data

  3. Background Spider charts are most useful when trying to compare different set of data that all relate to a certain point. They are very useful in visual comparisons of data to help choose the optimal solution or identify areas of improvement.

  4. How to use it • Create categories • Standardize performance definitions • Rate each performance category • Construct the chart • Plot the ratings. • Interpret and use the results.

  5. Using Excel – Example One • Suppose that you are looking to buy a computer • Your top three criteria for the computer are hard drive capacity, processor speed, amount of RAM (memory), and CD\DVD drive. • Use a spider chart to help you choose the best option for your computer

  6. Using Excel – Example One • You have chosen three systems

  7. Using Excel – Example One • In this example we will create a 1-10 scale to rate each aspect of the computer • We will assume that the on the scale that • 80 GB hard drive is a 10 – a 20 GB is a 1 • 3.6 MHz processor is a 10 – a 1.6 MHz is a 1 • 1024 MB Ram is a 10 – a 128 MB is 1 • DVD is a 10 - no CD/DVD is a 0

  8. Using Excel – Example One • Input the data from the table into an excel spreadsheet • Now we can use the Chart wizard to create a spider chart.

  9. Using Excel – Example One Step 2: A window like this will appear chose radar and click next Step 1: Select Insert from the menu bar and then choose Chart

  10. Using Excel – Example One Step 4: Click next and add a name to the chart. At this point you can also change font colors or the position attributes of the legend. Step 3: Enter the data range by selecting the fields with the ratings of the different components

  11. Using Excel – Example One Step 5: After you have changed the colors and other attributes that you would like Click Finish You should have a chart that looks similar to the one on the right. Now you have a graphical representation of the choice that you are making. This graph can help you see which option best meets your needs.

  12. Example Two - • Take a look at a more complex situation and this time you are on your own to create the spider chart. • In this example it will not be necessary to rate the different components, simply use the data given in the problem

  13. Example Two Fred is looking for a new place to open a tourist shop. One of the main criteria for the shop is the average temperature during the year. He would like to compare the temperature in 3 cities Create a Spider Chart to help Fred with his decision.

  14. Answer to Example Two One Possible answer to example 2. If Fred is looking for the best temperature year round which city would he choose?

  15. Applying the Principle • Think of your areas of responsibility • How could you use a Spider Chart in your work to help you make a better decision? • How could a Spider Chart help you optimize performance?

  16. Additional Resources… • http://www.crummer.rollins.edu/journal/articles/2003_2_radar.pdf • http://www.mori.com/pubinfo/aiz/statistical-analyses.pdf • http://www.skymark.com/resources/tools/radar_charts.asp • http://www.internet4classrooms.com/excel_radar.htm • http://web2.concordia.ca/Quality/tools/23radar.pdf • http://www.isixsigma.com/dictionary/Radar_Chart-307.htm • http://www.infinitefutures.com/essays/prez/mapping/ • http://office.microsoft.com/en-us/assistance/HA010346071033.aspx • http://www.ve.com/kavachart/alacarte/applets/specialty/SpiderCharts.html

More Related