Supply Chain Management Spider Charts also known as Radar Charts

1
Supply Chain Management Spider
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 1 Select Insert from the menu bar and then
choose Chart

• Step 2 A window like this will appear chose
  radar and click next

10
Using Excel Example One
Step 3 Enter the data range by selecting the
fields with the ratings of the different
components

• 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.

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/20
  03_2_radar.pdf
• http//www.mori.com/pubinfo/aiz/statistical-analys
  es.pdf
• http//www.skymark.com/resources/tools/radar_chart
  s.asp
• http//www.internet4classrooms.com/excel_radar.htm
  
• http//web2.concordia.ca/Quality/tools/23radar.pdf
  
• http//www.isixsigma.com/dictionary/Radar_Chart-30
  7.htm
• http//www.infinitefutures.com/essays/prez/mapping
  /
• http//office.microsoft.com/en-us/assistance/HA010
  346071033.aspx
• http//www.ve.com/kavachart/alacarte/applets/speci
  alty/SpiderCharts.html