MGT608 American International College Week 2 Graphic Activity Question

User Generated

qqnjfba40612

Business Finance

MGT608

American International College

Description

  • 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 using one of the performance metrics.
    2. Column (or bar) graph using the same data from #1.
    3. Create 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

Unformatted Attachment Preview

3PL for the World, Inc. Revenue Sep Oct Nov Dec Objective Cost per Package Inventory Turns Service Level Perfect Order Rate $ $ $ $ 850,987 865,254 921,456 930,231 $ $ $ $ 8.50 7.80 7.70 8.25 18.0 21.2 22.4 25.9 98% 96% 93% 90% 80% 77% 75% 62% $ 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 func 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 omatic graph-building functions in Excel will make your job much easier! Let's practice: 1. Create a Line graph using one of the performance metrics. Revenue Sep Oct Nov Dec $ $ $ $ 850,987 865,254 921,456 930,231 Cost per Inventory Package Turns Service Level Perfect Order Rate $ $ $ $ 8.50 7.80 7.70 8.25 18.0 21.2 22.4 25.9 98% 96% 93% 90% 80% 77% 75% 62% Objective $ 900,000 $ 7.90 24 95% 75% Select Revenue, Cost per Package, Inventory Turns, Service Level, or Perfect Order Rate as the performance metric. Months will be on the horizontal axis, metric will be on the vertical axis. Use Select Data to ADD a new line to the graph. Steps: (Go to Insert, then Line Graph, Right Cick on pop-up to open Select Data). Need to add the target (objective) series on a secondary axis. Click the chart, which displays Chart Tools, adding the Design an Then, on Format tab, in the Current Selection group, click the arrow in the Chart Elements box, then click the data series (Targ to plot along a secondary axis. Select Data may also be used to add the Secondary line. Chart Tools, adding the Design and Format tabs. x, then click the data series (Target) that you want 2. Column (or bar) graph using the same data from #1. One way is to Change Chart Type after you have done the Line Graph. Right click on the Line Graph and Select Change Chart T Another way is Insert a Column Chart and build it from the data provided. Revenue Sep Oct Nov Dec $ $ $ $ 850,987 865,254 921,456 930,231 Cost per Inventory Package Turns Service Level Perfect Order Rate $ $ $ $ 8.50 7.80 7.70 8.25 18.0 21.2 22.4 25.9 98% 96% 93% 90% 80% 77% 75% 62% Objective $ 900,000 $ 7.90 24 95% 75% Graph and Select Change Chart Type. 3. Creat a Radar chart using all the metrics during the most recent period. Convert each metric to a percentage to be on the same scale as each other. Some Radar charts can accept unique scales on each axis (here there are 5 metrics so 5 axes.) If the category labels (metrics) do not automatically transfer in, use the Select Data menu to edit the range for the "Horizonta Revenue Sep Oct Nov Dec Dec % $ $ $ $ 850,987 865,254 921,456 930,231 103% Cost per Inventory Package Turns $ $ $ $ 8.50 7.80 7.70 8.25 104% 18.0 21.2 22.4 25.9 108% Service Level Perfect Order Rate 98% 96% 93% 90% 94% 80% 77% 75% 62% 83% Objective $ 900,000 $ 7.90 24 95% Steps: Go to Insert, then Radar Chart, right click for Select Data. Series name will be December Results. Series value will be the December %s. Axis (cateogry) labels will be the column headings. 75% 4. Create a Scatter (X,Y) plot -- with data in columns side-by-side $940,000 Revenue Sep-17 Oct-17 Nov-17 Dec-17 $ $ $ $ 850,987 865,254 921,456 930,231 Cost per Inventory Package Turns $ $ $ $ 8.50 7.80 7.70 8.25 18.0 21.2 22.4 25.9 $930,000 Service Level Perfect Order Rate 98% 96% 93% 90% 80% 77% 75% 62% $900,000 $920,000 $910,000 $890,000 $880,000 $870,000 $860,000 Objective $ 900,000 $ 7.90 24 Use Change Chart Type to select "Secondary Axis" 95% 75% $850,000 $840,000 Aug-17 Note -- X,Y needs quantitative values for X and Y. With time-series data like this (in order), the difference betwee Steps: Go to Insert, Scatter Chart, right click for Select Data. Edit Series 1 for one of the metrics you select (i.e. Revenue). Add values to Y for first metric. Edit Series 2 for another of the metrics you select (i.e. Cost per Package). Add values to Y for second metric. Horizontal axis will be labels of Sep-17 to Dec-17. Click on chart to display Chart Tools, Design and Format tabs. Select Format tab. Then, on Format tab, in the Current Selection group, click the arrow in the Chart Elements box, then click the data series (i.e. to format on a secondary axis. Then Format the Data Series to add a solid line for each of the axes. Illustration provided. 4th Quarter Metrics $8.60 $8.50 $8.40 $8.30 $8.20 $8.10 Revenue $8.00 Cost per Package $7.90 $7.80 $7.70 $7.60 Aug-17 Sep-17 Sep-17 Oct-17 Nov-17 Nov-17 Dec-17 5. Create a Scatter (X,Y) graphs -- with data in columns that are NOT side-by-side I just copied the #4 chart and then clicked on a line to highlight it's data, then moved the data blocks to the new data. Or, you may need to start the graph from scratch and Select Data manually. Revenue Sep-17 Oct-17 Nov-17 Dec-17 $ $ $ $ 850,987 865,254 921,456 930,231 Cost per Inventory Package Turns $ $ $ $ 8.50 7.80 7.70 8.25 18.0 21.2 22.4 25.9 Service Level Perfect Order Rate 98% 96% 93% 90% 80% 77% 75% 62% Objective $ 900,000 $ 7.90 24 95% 75% Steps: Copy Chart #4. Right click to Select Data. Edit first series to new selection (i.e. Inventory Turns). Change Y Values to those for Inventory Turns. Edit second series to new selection (i.e. Service Level). Change Y Values to those for Service Level. Illustration provided. 4th Quarter Metrics 30.0 99% 98% 25.0 97% 96% 20.0 95% 15.0 94% 93% 10.0 92% 91% 5.0 90% 0.0 Aug-17 Sep-17 Sep-17 Oct-17 Nov-17 Nov-17 89% Dec-17 Inventory Turns Service Level
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

3PL for the World, Inc.
Month
Sep
Oct
Nov
Dec
Objective

Revenue

Cost per
Package

Inventory
Turns

Service
Level

Perfect Order
Rate

$
$
$
$

850.987
865.254
921.456
930.231

$
$
$
$

8,50
7,80
7,70
8,25

18,0
21,2
22,4
25,9

98%
96%
93%
90%

80%
77%
75%
62%

$

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 func
1. Create a Line graph usiing one of the performance metrics.
2. Column (or bar) graph using the same data from...


Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags