Year Quarter Month Country Showroom Customer Name Age Products

2017 1 January United States Amazon Kevin Thomas 26 TV

2017 2 February United Kingdom Wallmart Peter Max 28 AC
2017 3 March Canada Wallgreen Ria Sen 32 Fridge
2017 4 April Norway Ebay Chris Luka 33 Grinder
2017 1 May Singapore Amazon Kate Joseph 35 TV
2017 2 June Malaysia Wallmart Peter Rossario 39 AC
2017 3 July UAE Wallgreen James Cameron 35 Fridge
2017 4 August Finland Ebay Max Fellar 36 Grinder
2017 1 September Switzerland Amazon John Pencil 34 TV
2017 2 October Germany Wallmart Stone Dizuza 32 AC
2017 3 November United States Wallgreen Kerry Wells 30 Fridge
2017 4 December United Kingdom Ebay Maxmilan Stencil 29 Grinder
2016 1 January United States Amazon Kevin Thomas 28 TV
2016 2 February United Kingdom Wallmart Peter Max 39 AC
2016 3 March Canada Wallgreen Ria Sen 26 Fridge
2016 4 April Norway Ebay Chris Luka 24 Grinder
2016 1 May Singapore Amazon Kate Joseph 23 TV
2016 2 June Malaysia Wallmart Peter Rossario 25 AC
2016 3 July UAE Wallgreen James Cameron 39 Fridge
2016 4 August Finland Ebay Max Fellar 42 Grinder
2016 1 September Switzerland Amazon John Pencil 35 TV
2016 2 October Germany Wallmart Stone Dizuza 36 AC
2016 3 November United States Wallgreen Kerry Wells 22 Fridge
2016 4 December United Kingdom Ebay Maxmilan Stencil 20 Grinder
2015 1 January United States Amazon Kevin Thomas 28 TV
2015 2 February United Kingdom Wallmart Peter Max 31 AC
2015 3 March Canada Wallgreen Ria Sen 30 Fridge
2015 4 April Norway Ebay Chris Luka 33 Grinder
2015 1 May Singapore Amazon Kate Joseph 28 TV
2015 2 June Malaysia Wallmart Peter Rossario 29 AC
2015 3 July UAE Wallgreen James Cameron 36 Fridge
2015 4 August Finland Ebay Max Fellar 30 Grinder
2015 1 September Switzerland Amazon John Pencil 24 TV
2015 2 October Germany Wallmart Stone Dizuza 28 AC
2015 3 November United States Wallgreen Kerry Wells 29 Fridge
2015 4 December United Kingdom Ebay Maxmilan Stencil 27 Grinder
Cost of Sales Revenue Profit % Profit Commission % Commission
$900 $1,200 0.33 $300 0.15 $180
$600 $900 0.50 $300 0.18 $162
$800 $1,050 0.31 $250 0.14 $147
$700 $900 0.29 $200 0.16 $144
$950 $1,300 0.37 $350 0.15 $195
$650 $1,000 0.54 $350 0.18 $180
$880 $1,100 0.25 $220 0.14 $154
$770 $1,000 0.30 $230 0.16 $160
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$680 $910 0.34 $230 0.16 $146
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$680 $910 0.34 $230 0.16 $146
$950 $1,300 0.37 $350 0.15 $195
$650 $1,000 0.54 $350 0.18 $180
$900 $1,200 0.33 $300 0.15 $180
$600 $900 0.50 $300 0.18 $162
$800 $1,050 0.31 $250 0.14 $147
$700 $900 0.29 $200 0.16 $144
$950 $1,300 0.37 $350 0.15 $195
$680 $910 0.34 $230 0.16 $146
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$880 $1,100 0.25 $220 0.14 $154
$770 $1,000 0.30 $230 0.16 $160
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$800 $1,050 0.31 $250 0.14 $147
$800 $1,050 0.31 $250 0.14 $147
$700 $900 0.29 $200 0.16 $144
$680 $910 0.34 $230 0.16 $146
 Data Data
Country Sum - Cost of Sales Sum - Revenue Showroom Average - Profit %
Canada $2,300 $2,890 Amazon 0.34
Finland $2,120 $2,820 Ebay 0.32
Germany $2,050 $2,850 Wallgreen 0.32
Malaysia $2,150 $3,150 Wallmart 0.49
Norway $2,260 $2,910 Total Result 0.37
Singapore $2,670 $3,600 Data
Switzerland $2,450 $3,250 Products Sum - Cost of Sales
UAE $2,330 $3,200 AC $5,900
United Kingdom $3,740 $5,430 Fridge $7,030
United States $5,000 $6,620 Grinder $6,420
Total Result $27,070 $36,720 TV $7,720
Total Result $27,070
Data
Year Showroom Sum - Revenue SumYear Quarter
2015 $11,950 ### 2017
Amazon $3,200 ### 1
Ebay $2,930 ### 2
Wallgreen $2,720 ### 3
Wallmart $3,100 ### 4
2016 $12,440 ### Total Result
Amazon $3,500 ###
Ebay $2,720 ###
Wallgreen $3,420 ###
Wallmart $2,800 ###
2017 $12,330 ###
Amazon $3,650 ###
Ebay $2,810 ###
Wallgreen $3,070 ###
Wallmart $2,800 ###
Total Result $36,720 ###
 Country - all -
Average - Commission %
0.1488888889 Year Products Average - Profit %
0.1577777778 2015 0.35
0.1488888889 AC 0.43
0.17 Fridge 0.38
0.1563888889 Grinder 0.27
TV 0.32
Sum - Revenue Total Result 0.35
$8,700
$9,210
$8,460
$10,350
$36,720
Data
Sum - Revenue Sum - Revenue Sum - Revenue
$12,330 ###
$3,650 ###
$2,800 -$850###
$3,070 $270###
$2,810 -$260###
$12,330 ###
 Revenue and Cost of Sales 14000
11950
12000
10000
6620 8000
United States 6000
5000
4000
2000
0
5430 Yea r 2015
United Kingdom
3740
P
60.00%

3200
UAE 50.00%
2330

40.00%
33.92%
3250 30.00%
Swi tzerla nd
2450
20.00%
14.89%

3600 10.00%
Singapore
2670
0.00%
Data Showroom Ama zon
Linear (Data )
Column C
2910
Norway Linear (Column C)
2260 Linear (Column C)
14000

12330
3150
Ma lays ia 12000
2150

10000
2850
Germa ny
2050
8000

2820
Finland 6000
2120

4000
2890
Canada
2300
2000
Finland 6000
2120

4000
2890
Canada
2300
2000

Country 0
Yea r 2017

0 1000 2000 3000 4000 5000 6000 7000

-2000
 Sales in Each Showroom
14000 12440
11950 12330
12000
10000
8000
6000
3200 3100 3500 3420 3650 3070
4000 2930 2720 2720 2800 2810
2000
0
Yea r 2015 2016 2017

Profit % and Commission %

Sale
60.00% 12000

49.30%
50.00% 10000
9210
8700 846
40.00% Data 8000
33.92% Li nea r (Data) 7030
32.38% 31.85% 6420
Col umn G 5900
30.00% 6000
Li nea r (Col umn G)

20.00% 17.00% 4000

14.89% 15.78% 14.89%

10.00% 2000

0.00% 0
Showroom Ama zon Ebay Wal l green Wal l mart Products AC Fri dge Grinde

Quarter Wise Sales Data Profi

14000

Tota l Res ult

12330
12000

10000

8000 Col umn F

Li near (Col umn F)
Data
Exponentia l (Data)
6000
Col umn H

4000 3650
3070
2800 2810

2000
6000
Col umn H

4000 3650
3070
2800 2810

2000

1 2 3 4
0
Yea r 2017 2015

-2000 0.00% 200.00% 4

m
12330
Col umn B
Li nea r (Col umn B)
Data
Li nea r (Data)
3650 3070
2810 2800

2017

Sales and Revenue

10350
9210
8700 8460
7720 Data
7030 Li near (Data )
6420
5900 Col umn G
Li near (Col umn G)

oducts AC Fri dge Grinder TV

Profit % in Each Product Sales

Tota l Res ult

2015

0.00% 200.00% 400.00% 600.00% 800.00% 1000.00%1200.00%