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
47398.00
50000.00
40000.00
30000.00 23400.00
20000.00 13431.56
10000.00 5980.00 5754.92 4134.00
2760.00
0.00
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
Kuala Kangsar
23678.00
25000.00
20000.00
15000.00 12345.67 12345.54
8999.78
10000.00
5000.00 2123.00 2432.56 1342.76 978.90
0.00
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
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
Ipoh Taiping Kuala Kangsar Tapah Slim River
Notebooks
30000.00
25456.56
25000.00 23400.00
19000.34
20000.00
15000.00 12345.67
10560.25
10000.00
5000.00
0.00
Ipoh Taiping Kuala Kangsar Tapah Slim River
Tablets
25000.00
20560.35
20000.00
15000.00
10000.00
5980.00 5560.90
5000.00 3987.00
2123.00
0.00
Ipoh Taiping Kuala Kangsar Tapah Slim River
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
Ipoh Taiping Kuala Kangsar Tapah Slim River
Computer Accessories
18000.00
15600.90
16000.00
13431.56
14000.00
12225.30
12000.00 10981.98
10000.00 8999.78
8000.00
6000.00
4000.00
2000.00
0.00
Ipoh Taiping Kuala Kangsar Tapah Slim River
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
Ipoh Taiping Kuala Kangsar Tapah Slim River
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
Ipoh Taiping Kuala Kangsar Tapah Slim River
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
Ipoh Taiping Kuala Kangsar Tapah Slim River
