OrderDate Region Rep

1-Jun-20 Central Gill

23-Jan-20 Central Andrews
2-Sep-20 East Jones
26-Feb-20 Central Jardine
3/15/2020 East Howard
4-Jan-20 West Thompson
4/18/2020 Central Gill
5-May-20 Central Smith
5/22/2020 Central Andrews
6-Aug-20 Central Andrews
6/25/2020 West Sorvino
7-Dec-20 Central Andrews
7/29/2020 West Sorvino
8/15/2020 West Sorvino
9-Jan-20 East Jones
9/18/2020 Central Jardine
10-May-20 East Jones
10/22/2020 Central Jardine
11-Aug-20 Central Smith
11/25/2020 Central Morgan
12-Dec-20 East Jones
12/29/2020 East Jones
1/15/2021 East Parent
2-Jan-21 East Jones
2/18/2021 Central Gill
3-Jul-21 Central Jardine
3/24/2021 Central Morgan
4-Oct-21 Central Kivell
4/27/2021 East Howard
5/14/2021 East Jones
5/31/2021 Central Gill
6/17/2021 East Jones
7-Apr-21 Central Kivell
7/21/2021 Central Morgan
8-Jul-21 Central Gill
8/24/2021 West Sorvino
9-Oct-21 Central Kivell
9/27/2021 Central Kivell
10/14/2021 West Thompson
10/31/2021 East Parent
11/17/2021 Central Smith
12-Apr-21 East Parent
12/21/2021 Central Jardine
 Item Units UnitCost
Pencil 7 1.29
Pencil 14 1.29
Binder 4 4.99
Binder 11 4.99
Binder 29 1.99
Pencil 32 1.99
Pencil 53 1.29
Pencil 67 1.29
Pencil 66 1.99
Binder 28 4.99
Binder 7 19.99
Pencil 75 1.99
Pen 76 1.99
Pencil 56 2.99
Pencil 35 4.99
Pencil 36 4.99
Pencil 95 1.99
Pen Set 50 4.99
Desk 2 125.00
Binder 28 8.99
Pen Set 16 15.99
Binder 60 4.99
Pen 15 19.99
Pen Set 62 4.99
Binder 46 8.99
Pencil 90 4.99
Pencil 90 4.99
Pen Set 96 4.99
Pen 96 4.99
Binder 60 8.99
Pen 27 19.99
Pen 64 8.99
Desk 5 125.00
Pen Set 55 12.49
Binder 80 8.99
Desk 3 275.00
Binder 50 19.99
Pen Set 42 23.95
Binder 57 19.99
Pen Set 74 15.99
Binder 87 15.00
Binder 81 19.99
Binder 94 19.99
 19627.88
Total UnitCost Total
$9.03 2.5% GetBetter 125 #N/A
$18.06 2.5% GetBetter
$19.96 2.5% GetBetter Morgan 249.5 1619.19
$54.89 2.5% GetBetter 57.71
$57.71 2.5% GetBetter
$63.68 2.5% GetBetter
$68.37 2.5% Good Pencil #N/A
$86.43 2.5% Good
$131.34 2.5% Good
$139.72 2.5% GetBetter 15
$139.93 10% Good
$149.25 2.5% Good
$151.24 2.5% Good
$167.44 2.5% Good OrderDate index offset
$174.65 2.5% GetBetter
$179.64 2.5% GetBetter 1/23/2020 #N/A #N/A
$189.05 2.5% Good 2/26/2020 #N/A #N/A
$249.50 2.5% GetBetter 3/15/2020 Binder Binder
$250.00 10% Good 4/18/2020 Pencil Pencil
$251.72 5% GetBetter 5/22/2020 Pencil Pencil
$255.84 10% Good 6/25/2020 Binder Binder
$299.40 2.5% Good
$299.85 10% Good
$309.38 2.5% Good percentile 299.4
$413.54 5% GetBetter quartile 1879.06
$449.10 2.5% Good Stddev 47.345117694
$449.10 2.5% Good Median 299.40
$479.04 2.5% Good Rank 21
$479.04 2.5% Good
$539.40 5% Good
$539.73 10% Good
$575.36 5% Good
$625.00 10% Good
$686.95 2.5% Good
$719.20 5% Good
$825.00 10% Good
$999.50 10% Good
$1,005.90 10% Good
$1,139.43 10% Good
$1,183.26 10% Good
$1,305.00 2.5% Good
$1,619.19 10% Good
$1,879.06 10% Good
 4
Item match sumifs countifs

Jones #N/A 2363.04 29

Gill #N/A 1749.87 12
Parent 6 3102.3
Kivell 8 3109.44
Andrews 10 438.37
Smith 12 1641.43
 2

Region Data
Central East West
Rep Count of UnitCost Sum of Units Count of UnitCost Sum of Units Count of UnitCost
Andrews 4 183
Gill 5 213
Howard 2 125
Jardine 5 281
Jones 8 396
Kivell 4 193
Morgan 3 173
Parent 3 170
Smith 3 156
Sorvino 4
Thompson 2
Total Result 24 1199 13 691 6
This shape represents a slicer.
Slicers are supported in Excel
2010 or later.

If the shape was modified in

an earlier version of Excel, or
if the workbook was saved in
Excel 2003 or earlier, the
slicer cannot be used.
Central
East

Total Count of UnitCost Total Sum of Units

Sum of Units
4 183
5 213
2 125
5 281
8 396
4 193
3 173
3 170
3 156
142 4 142
89 2 89
231 43 2121
500
450
Region Central
400 Count of UnitCost
350 Data Sum of Units
300 East Count of
250 UnitCost
200 Sum of Units
150 West Count of
100 UnitCost
50 Sum of Units
0
s ll d e s ll n t h o n lt
ew Gi war rdin one ive rga ren mit rvin pso esu
dr Ho Ja
J K o P a S So m l R
An M o
Th Tota
Row Label Central East West Grand Total Central
Andrews 4 40 |||||||||||||||||||||||||||| East
Gill 5 15 ||||||||||||||| West
Howard 2 2 ||
Jardine 5 5 |||||
Jones 8 8 |||||||| ✘ Central
Kivell 4 4 |||| ✘ East
Morgan 3 3 ||| ✘ West
Parent 3 3 |||
Smith 3 3 |||
Sorvino 4 4 ||||
Thompson 2 2 ||

1 TRUE TRUE
Row Label Central East West
Andrews 4 0 0
Gill 5 0 0
Howard 0 2 0
Jardine 5 0 0
Jones 0 8 0
Kivell 4 0 0
Morgan 3 0 0
Parent 0 3 0
Smith 3 0 0
Sorvino 0 0 4
Thompson 0 0 2
✘ Central
✘ East
✘ West
Row Label Central East West Grand TotaTotal Count of UnitCost Total Sum of Units
Andrews 4 4 4 183
Gill 5 5 5 213
Howard 2 2 2 125
Jardine 5 5 5 281
Jones 8 8 8 396
Kivell 4 4 4 193
Morgan 3 3 3 173
Parent 3 3 3 170
Smith 3 3 3 156
Sorvino 4 4 4 142
Thompson 2 2 4 142

1
Row Label Central East West
Andrews 4 0 0
Gill 5 0 0
Howard 0 2 0
Jardine 5 0 0
Jones 0 8 0
Kivell 4 0 0
Morgan 3 0 0
Parent 0 3 0
Smith 3 0 0
Sorvino 0 0 4
Thompson 0 0 2
Row Label English Percentage
Andrews 156 78
Gill 143 71.5
Howard 96 48
Jardine 54 27 Chart Title
Jones 196 98 200
Kivell 128 64 180
Morgan 109 54.5 160
140
Parent 90 45 120
Smith 67 33.5 100
Sorvino 198 99 80
60
Thompson 179 89.5
40
20
0
s ll d e s l l n nt
ew Gi ar in ne ve ga re
dr w a rd Jo Ki or a
A n Ho J M P

English Percentage
 Chart Title
100
90
80
70
60
50
40
30
20
10
0
s l l nt
ne ne ve ga
n ith in
o on
di Jo Ki or a re
Sm rv ps
P o
M S om
Th

English Percentage
 Rep Item Units
Gill Pencil 7
Andrews Pencil 14
Howard Binder 29
Thompson Pencil 32
Gill Pencil 53
Smith Pencil 67
Andrews Pencil 66
Andrews Binder 28
Sorvino Binder 7
Andrews Pencil 75
Sorvino Pen 76
Sorvino Pencil 56
Jones Pencil 35
Jardine Pencil 36
Jones Pencil 95
Jardine Pen Set 50
Smith Desk 2
Morgan Binder 28
Jones Pen Set 16
 Input RangeMax of each bin Bin FrequencyCumulative % Bin Frequency
0 - 29 29 0 - 29 8 42.11% 0 - 29 8
30 - 50 50 30 - 50 4 63.16% 30 - 50 6
51 - 80 80 51 - 80 6 94.74% 51 - 80 4
81 - 100 100 81 - 100 1 100.00% 81 - 100 1
More 0 100.00% More 0

Histogram
10 120.00%
8
6 80.00%
Frequency

4 Frequency
40.00% Cumulative %
2
0 0.00%
0 - 29 30 - 50 51 - 80 81 - More
100
Bin
Cumulative %
42.11%
73.68%
94.74%
100.00%
100.00%
 50 Seater 40 Seater
No of buses 4 5

Cost 800 600 6200

No of employees 50 40 400
No of Drivers 1 1 9
SP(Total Sa 100000
CP 30000
Profit 70000
CP of each 20
Worst Scenario
Selling Pric 5000
Per unit 8
Total Sales 40000
Cost Price 30000
Profit 10000
Scenario Summary
Current Values: Best Scenario Worst Scenario
Changing Cells:
$A$3 Worst Scenario Best Scenario Worst Scenario
$B$4 4000 5000 4000
$B$5 8 15 8
Result Cells:
$A$3 Worst Scenario Best Scenario Worst Scenario
$B$3
$A$4 Selling Price Selling Price Selling Price
$B$4 4000 5000 4000
$A$5 Per unit Per unit Per unit
$B$5 8 15 8
$A$6 Total Sales Total Sales Total Sales
$B$6 32000 75000 32000
$A$7 Cost Price Cost Price Cost Price
$B$7 30000 30000 30000
$A$8 Profit Profit Profit
$B$8 2000 45000 2000
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
No of units 5000
Unit per co 10 Profit For various units and unit per c
Total CP 50000 No of units
CP 30000 20000 5000 5100
Profit 20000 9 15000 15900
9.5 17500 18450
11 25000 26100
11.5 27500 28650
12 30000 31200
12.5 32500 33750
13 35000 36300
13.5 37500 38850
14 40000 41400
various units and unit per cost using data table

5200 5300 5400 5500 5600 5700 5800

16800 17700 18600 19500 20400 21300 22200
19400 20350 21300 22250 23200 24150 25100
27200 28300 29400 30500 31600 32700 33800
29800 30950 32100 33250 34400 35550 36700
32400 33600 34800 36000 37200 38400 39600
35000 36250 37500 38750 40000 41250 42500
37600 38900 40200 41500 42800 44100 45400
40200 41550 42900 44250 45600 46950 48300
42800 44200 45600 47000 48400 49800 51200
Baburao Raju Shyam Baburao Raju
45 39 95
78 88 93 Mean 62.16667 Mean 61.91667
12 15 92 Standard E 8.219372 Standard E 10.59407
36 34 99 Median 71.5 Median 71.5
79 94 99 Mode #N/A Mode 99
98 55 99 Standard D 28.47274 Standard D 36.69892
82 11 99 Sample Var 810.697 Sample Var 1346.811
49 18 89 Kurtosis -1.075215 Kurtosis -1.932242
90 99 92 Skewness -0.511063 Skewness -0.271728
65 99 95 Range 86 Range 88
23 99 95 Minimum 12 Minimum 11
89 92 96 Maximum 98 Maximum 99
Sum 746 Sum 743
Count 12 Count 12
Largest(1) 98 Largest(1) 99
Smallest(1) 12 Smallest(1) 11
 Shyam

Mean 95.25
Standard E 0.96236
Median 95
Mode 99
Standard D 3.333712
Sample Var 11.11364
Kurtosis -0.759692
Skewness -0.332355
Range 10
Minimum 89
Maximum 99
Sum 1143
Count 12
Largest(1) 99
Smallest(1) 89