0% found this document useful (0 votes)
26 views5 pages

Story 1

The document provides a general overview of a company's products, shipping and orders, customers, and locations. It discusses the company's products and shipping, as well as their customers. The document also focuses on orders and provides information about all locations. It includes a profit by category chart that shows the most and least profitable products and sub-categories.

Uploaded by

angela krleska
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
26 views5 pages

Story 1

The document provides a general overview of a company's products, shipping and orders, customers, and locations. It discusses the company's products and shipping, as well as their customers. The document also focuses on orders and provides information about all locations. It includes a profit by category chart that shows the most and least profitable products and sub-categories.

Uploaded by

angela krleska
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

St

ory
Generalover
view ofpr
oduct
s,shi
ppi
ng,or
der
s,cust
omer
sandl
ocat
ion
Company'
s Shi
pping,shi
ppi
ng Ourc
ust
omer
s Foc
usonor
der
s Al
laboutl
ocat
ion
produc
ts andsomemor es.
.

Leastpr
ofit
abl
e
Pr
ofi
tby cat
egor
y Topmostandl
eastpr
ofi
tabl
e 9

Cat
egor
Fur
nit
y
ure
Sub-
Cat
Bookc
egor
y
ases
product
s Mostpr
ofit
abl
e
10
Chairs ProductName
Furnishings Canoni mageCLASS2. . 25.
200 Sub-CategoryPar
a..
Tables CiscoSmar tPhone,.
. 17.
239 Accessories
Offic
eSuppl
ies Appliances Mot orolaSmar tPho.
.
Art HooverSt ove,Red 11.
808 di
ffer
enc
e
Binder s SauderCl assicBook.
.
Envelopes Har bourCr eationsE.
. 10.
427 -
193.
710 128.
941
Fastener s -
50K 0K 50K N ok i
a Sma rtPhone,.
.
Pr
ofit
CiscoSmar tPhone,.
. 9.
787
Pr
ofit -
10K 0K 10K 20K 30K -
8.880 25.
200
Pr
ofit
8.
955
Sal
es
-
2.783

How muchmor
e/l
esspr
ofi
tdoesonesub-
cat
egor
y-2ma
893 k
. e 73.
404$ 2M

Sub-
Categor y
Copiers -
3.650
Phones
Bookc ases -
4.447
Appli
anc es
-
8.880
Chairs
Accessor i
es
Stor age
Binders
-
50K 0K 50K 100K 150K 200K 250K -
200K -
150K -
100K -
50K 0K 50K 100K
Pr
ofit di
ffer
enc
e

Sal
essub-
cat
egor
y
Sub-
Cat
egor
y

502$
824$
es

436$
ngSum ofSal

682$

642.
572$
20.
000.
000$

706.
086$

509.
064$

501.

12.
1.
466.
060$
042$

127.

1.
237$

011.
912$

1.
578$
092$
292$
074$

1.
904$

10.
000.
000$
779.

1.
404$

242$

757.
Runni

749.

1.
461.
ngs 385.
t 372.
Paper 244.
es 243.
opes 170.
s 73.

s 83.

0$

al
s

es

es

nes

es

ases

Phones
age
Label

Ar
ener

nder

er
Chai

andTot
i

Tabl

anc
Suppl

essor

Copi
hi
shi

or
Envel

Bookc
Bi

i
Mac
Fast

St
Appl
ni
Fur

Gr
Ac
St
ory
Generalover
view ofpr
oduct
s,shi
ppi
ng,or
der
s,cust
omer
sandl
ocat
ion
Company'
s Shi
pping,shi
ppi
ng Ourc
ust
omer
s Foc
usonor
der
s Al
laboutl
ocat
ion
produc
ts andsomemor es.
.

Or
derPr ior
ity
Runni
ngt
otalofshi
ppi
ngcost Aver
ageshi
ppi
ngcost Crit
ical
High
Shi
pMode
Medi um
SameDay Fi
rstCl
ass Sec
ondCl
ass St
andar
dCl
ass
Shi
pModeOr
derPr
ior
ity Low
SameDay Cr
iti
cal $63
Avg.Shi
ppi
ngC.
.
$1.
100.
000 Hi
gh $40
$0 $296
Medi
um $27
Fi
rstCl
assCr
iti
cal $61 Hi
ghli
ghtCoun.
.
$1.
000.
000 Noit
emshighli
..
Hi
gh $39
Hi
ghli
ghtCat
eg..
Medi
um $29
Noit
emshighli
..
$900.
000 Second Cr
iti
cal $57
Class Hi
gh $32 Avg.Shi
ppi
ngt
..

Medi
um $22 2,
000 5,
500
$800.
000 $29
St
andar
d Hi
gh
Cl
ass $16
Medi
um
ngCost

Low $27
$700.
000
$0 $10 $20 $30 $40 $50 $60 $70
ppi

Avg.Shi
ppi
ngCost
ngSum ofShi

$600.
000

Shippi
ngcostby Averageti
mef
or
countr
y shi
pping
Runni

$500.
000

$400.
000

$300.
000

$200.
000

$100.
000

$0
2018 2020 2018 2020 2018 2020 2018 2020
Mont
hofShi
pDat
e Mont
hofShi
pDat
e Mont
hofShi
pDat
e Mont
hofShi
pDat
e
©Mapbox©OSM ©Mapbox©OSM
St
ory
Generalover
view ofpr
oduct
s,shi
ppi
ng,or
der
s,cust
omer
sandl
ocat
ion
Company'
s Shi
pping,shi
ppi
ng Ourc
ust
omer
s Foc
usonor
der
s Al
laboutl
ocat
ion
produc
ts andsomemor es.
.

Topbypr
ofit
Di
scountef
fectoncust
omer
s TopN cust
omer
sbypr
ofi
t 10
Numberofor
der
s
Pr
ofit
120
CustomerName
110 6.
3128.
673
110 Tom Ashbr ook
AdrianBar ton
MikeGoc kenbach
100 SusanPi stek
HarryMar ie Pi
ckadime.
.
Bil
lEpl ett Sub-
cat
ego.
.
90
Hunt erLopez
Avg.Di
scou.
.
SanjitChand
0,1775to0.
.
D

80
omerI

RaymondBuc h
Tamar aChand
ountofCust

70 0K 1K 2K 3K 4K 5K 6K 7K 8K 9K
Pr
ofit
60
tc

50
st
Di nc
i

40

30

21
20

10
10 7
4
0
1 5 11 13 14

Aver
agesal
espercust
omer
Di
mensi
on 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 5500 6000 6500 7000 7500 8000 8500
Phones
Copi
ers
Bookc
ases
Chai
rs
Appl
ianc
es
Tabl
es
St
orage
Mac
hines
Ac
cessor
ies
Bi
nder
s
0$ 1.
000$ 2.
000$ 3.
000$ 4.
000$ 5.
000$ 6.
000$ 7.
000$ 8.
000$
St
ory
Generalover
view ofpr
oduct
s,shi
ppi
ng,or
der
s,cust
omer
sandl
ocat
ion
Company'
s Shi
pping,shi
ppi
ng Ourc
ust
omer
s Foc
usonor
der
s Al
laboutl
ocat
ion
produc
ts andsomemor es.
.

c
hoosemont
hs
Latestyeart
opr
ior Pr
ofi
trat
iobyor
derdat
e Highly,medium and 4

yearsales 60K
unprofit
abledaysofever
y Pr
ofit
hi
abi
ghl
l
it
ypr
y
ofitabl
e
500.
000$
Regi
Afr
ic
on
a
Or
Cr
derPr
it
ical
i
..
50K
mont h profit
unpr
abl
ofit
e
abl
e
High 400.
000$ 2017 2018 2019 2020 hi
ghpr
ofit
abi
li
ty.
.

.
.Number.
Low 40K

ofit
20 500

es
Medi um
Sal
300.
000$ hi
ghl
y

Pr
Canada Cr it
ical 10 Segment
30K pr
ofitabl
e
High Consumer

.Number.
Low 200.
000$ 20
20K Corpor
ate
Medi um pr
ofit
abl
e
10 HomeOffic e
Cari
bbean Crit
ical
100.
000$ 10K
High MeasureNames

Number.
Low 20 Profit
0$ 0K
Medi um unpr
ofit
.. Sales
2018 2020 10
Central Cr it
ical
Or
derPr ior
ity
High Mont
hofOr
derDat
e 2 5 8 11 2 5 8 11 2 5 8 11 2 5 8 11 Crit
ical
Low
High
Medi um
Central Cr it
ical Salesofproduct
sby Averageofunprof
itabl
eorder
s Medi
Low
um
Asia High
Low orderpr
ior
ity percustomerforeachsegment
Medi um
East Crit
ical ProductName Segment
High AppleSmar tPhone,..
Low Ci
scoSmar tPhone,..
Consumer 24,
8%
Medi um Mot orolaSmar tPho..
EMEA Crit
ical NokiaSmar tPhone,..
High CanonimageCL ASS2..
Low HonExec uti
veL eath.
. Cor
por
ate 24,
3%
Medi um Offic eSt arExec ut
iv.
.
North Crit
ical HarbourCr eationsE..
High SamsungSmar tPho..
Low NokiaSmar tPhone,.. HomeOffic
e 24,
2%
Medi um SamsungSmar tPho..
North Crit
ical Ci
scoSmar tPhone,..
Asia 0K 200K 400K 0$ 50.
000$ 0,
0% 5,
0% 10,
0% 15,
0% 20,
0% 25,
0%
l
atestsal
es Sal
es Tot
alunpr
ofit
abl
eor
der
sperc
ust
omerandsegment
St
ory
Generalover
view ofpr
oduct
s,shi
ppi
ng,or
der
s,cust
omer
sandl
ocat
ion
Company'
s Shi
pping,shi
ppi
ng Ourc
ust
omer
s Foc
usonor
der
s Al
laboutl
ocat
ion
produc
ts andsomemor es.
.

Mar
ket
Top5countri
es Top7mostsel ledpr
oduct
sin Pr
ofi
tbymar
ket APAC
EU
andci
tiesbysal
es eachregion Mar
ket US
LATAM
Country Cit
y bysub-categor
y 400K Afri
ca
UnitedStat
es New Yor kCity 256.
368$ EMEA
LosAngel es 175.
851$ Region Sub-Cat ego..
Canada
Seat t
le 119.
541$ Afr
ica Phones
SanFr ancisco 112.
669$ Storage 300K
Copiers Hi
ghli
ghtMarket
Philadelphia 109.
077$

ofit
Bookc ases Noit
emshighli
ghted
Austral
ia Sydney 101.
946$
Mac hines

Pr
Brisbane 75.
729$ 200K
Applianc es TOPN
Mel bourne 73.
844$
Chairs 6
GoldCoast 72.
627$
Canada Storage
Perth 64.
292$ Phones BOTTOM N
100K
Germany Ber l
in 61.
918$ Applianc es 20
Hambur g 40.
430$ Copiers
Muni ch 22.
749$ Bookc ases Pr
ofit
0K 21.
937
Cologne 20.
011$ Accessor ies

Canada
APAC

US

EMEA
EU

LATAM

c
Bremen 19.
337$ Mac hines 100.
000

ri
0$ 100.
000$ 200.
000$ 300.
000$

Af
France Paris 63.
316$ 200.
000
Mar seil
le 31.
048$ Sal
es 286.
397
Lyon 17.
801$
Sal
es

Diff
erencetoglobalaver
agesal
esper TopandBut
tom count
riesbypr
ofi
t 16K 256K

regionandshi
pmode i
ndex
1to7

Region Sal
esDi
sti
nctcount.
. Sal
esperor
derAvg.Sal
esper.
. avgsal
esper.
. avgsal
esper.
.
Afri
ca 783.
773$ 2.232 351 365 365 498 -
26,7% Regi
on
Canada 66.
928$ 201 333 332 332 498 -
33,2% Afri
ca
Cari
bbean 324.
281$ 855 379 387 387 498 -
22,2% Canada
Central 2.
822.
303$ 5.249 538 501 501 498 0,7% Cari
bbean
CentralA.
. 752.
827$ 1.026 734 675 675 498 35,6% Central
East 678.
781$ 1.401 484 500 500 498 0,5% CentralAsi
a
EMEA 806.
161$ 2.462 327 334 334 498 -
32,9% East
North 1.
248.
166$ 2.356 530 514 514 498 3,3% EMEA
NorthAs.. 848.
310$ 1.150 738 714 714 498 43,6% North
Oceania 1.
100.
185$ 1.744 631 601 601 498 20,8% NorthAsia
South 1.
600.
907$ 3.270 490 498 498 498 0,1% Oceania
Southea.. 884.
423$ 1.517 583 575 575 498 15,5% South
West 725.
458$ 1.611 450 473 473 498 -
5,0% SoutheastAsi
a
GrandTo.. 12.
642.
502$ 25.035 505 498 6.
469 498 0,0% West

©2022Mapbox©OpenSt
reet
Map

You might also like