i) Total sales for the first quarter 2018
ABC Sdn Bhd
First Quarter 2018 Sales
Item Ipoh Taiping Kuala Kangsar Tapah Slim River Total
Desktop Computers 56340.00 34670.00 23678.00 20553.00 19652.00 154893.00
Notebooks 23400.00 19000.34 12345.67 25456.56 10560.25 90762.82
Tablets 5980.00 3987.00 2123.00 5560.90 20560.35 38211.25
Smartphones 47398.00 24567.00 12345.54 34675.80 11556.10 130542.44
Computer Accessories 13431.56 10981.98 8999.78 15600.90 12225.30 61239.52
Printers 5754.92 3400.34 2432.56 5678.45 2561.23 19827.50
Scanners 2760.00 1234.00 1342.76 790.00 1456.56 7583.32
Software 4134.00 1000.90 978.90 10789.35 3456.78 20359.93
Total 159198.48 98841.56 64246.21 119104.96 82028.57 523419.78
Minimum Sales : 790.00
Maximum Sales : 56340.00
ii) Plot sales graph for each branch.
Ipoh
60000.00 56340.00
50000.00 47398.00
40000.00
30000.00 23400.00
20000.00 13431.56
10000.00 5980.00 5754.92 4134.00
2760.00
0.00
te
rs ks et
s es ie
s
te
rs
er
s ar
e
oo bl on or nn
pu
e b a h s s ir n ftw
m ot T rtp cc
e P
Sc
a So
Co N a
to
p Sm rA
sk ute
p
De m
Co
Taiping
40000.00
34670.00
35000.00
30000.00
24567.00
25000.00
19000.34
20000.00
15000.00 10981.98
10000.00
3987.00 3400.34
5000.00 1234.00 1000.90
0.00
te
rs ok
s
et
s es ie
s
er
s rs ar
e
pu bo a bl hon s or i nt nne w
te T tp s Pr a ft
m
No ar ce Sc So
Co m Ac
p S r
to te
sk pu
De m
Co
Kuala Kangsar
25000.00 23678.00
20000.00
15000.00 12345.67 12345.54
10000.00 8999.78
5000.00 2432.56
2123.00 1342.76 978.90
0.00
te
rs ks et
s es ie
s
te
rs rs ar
e
oo bl on or ne
pu te
b a h s s rin n ftw
m T rtp e P
Sc
a So
Co No a A cc
op Sm r
kt te
s pu
De m
Co
Tapah
40000.00
34675.80
35000.00
30000.00
25456.56
25000.00 20553.00
20000.00 15600.90
15000.00 10789.35
10000.00 5560.90 5678.45
5000.00 790.00
0.00
rs ks ts s s rs s e
te oo ble o ne orie te ner ar
pu b a h s i n n ftw
m te T tp es Pr a So
Co No ar cc Sc
p S m r A
to te
e sk pu
D m
Co
0.00
te
rs ks et
s es ie
s
te
rs
er
s ar
e
u boo a bl hon s or ir n nn w
p te s oft
m T rtp e P
Sc
a
Co No a cc S
to
p Sm rA
sk ute
p
De m
Co
Slim River
25000.00
20560.35
19652.00
20000.00
15000.00
11556.10 12225.30
10560.25
10000.00
5000.00 3456.78
2561.23
1456.56
0.00
1 2 3 4 5 6 7 8
iii) Plot graph for each items.
Desktop Computers
60000.00 56340.00
50000.00
40000.00 34670.00
30000.00
23678.00
20553.00 19652.00
20000.00
10000.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
Notebooks
30000.00
25456.56
25000.00 23400.00
20000.00 19000.34
15000.00 12345.67
10560.25
10000.00
5000.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
20000.00
15000.00 12345.67
10560.25
10000.00
5000.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
Tablets
25000.00
20560.35
20000.00
15000.00
10000.00
5980.00 5560.90
5000.00 3987.00
2123.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
Smartphones
50000.00 47398.00
45000.00
40000.00
34675.80
35000.00
30000.00
24567.00
25000.00
20000.00
15000.00 12345.54 11556.10
10000.00
5000.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
Computer Accessories
18000.00
15600.90
16000.00
14000.00 13431.56
12225.30
12000.00 10981.98
10000.00 8999.78
8000.00
6000.00
4000.00
2000.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
Printers
7000.00
6000.00 5754.92 5678.45
5000.00
4000.00 3400.34
3000.00 2432.56 2561.23
2000.00
1000.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
Scanners
3000.00
2760.00
2500.00
2000.00
1456.56
1500.00 1342.76
1234.00
1000.00 790.00
500.00
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
Software
12000.00
10789.35
10000.00
8000.00
6000.00
4134.00
4000.00 3456.78
2000.00 1000.90 978.90
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
2000.00 1000.90 978.90
0.00
Slim River
Tapah
Kuala Kangsar
Taiping
Ipoh
