Analysis of Sales and Profit in Information System

Running head: INFORMATION SYSTEM
INFORMATION SYSTEM
Name of the Student
Name of the Organization
Author Note
Answer to Question 1
As per the chart and the table, it can be said
there are all total eight regions showing
Data
Region
Sum of
Sales
Sum of
Profit
Atlantic
2014248.2
04
238960.6
129
Northwest
Territories
800847.32
95
100653.0
519
Nunavut
116376.48
35 2841.117
Ontario
3063212.4
8
346868.5
812
Prarie
2837304.6
02
321160.1
804
Quebec
1510195.0
8
140426.5
947
West
3597549.2
76
297008.5
76
Yukon
975867.37
1
73849.24
54
Grand Total
14915600.
82
1521767.
96

INFORMATION SYSTEM1
several sum of profits as well as sum of sales. It can be noticed that the West region is possessing
with the highest sum of sales and all the Northwest Territories are possessing with the lowest
sum of sales. As per the sum of profit will be considered, it can be said that the particular region
of Ontario has the highest sum of profit and the region of Yukon the lowest. The grand total sum
of sales comprising of all the regions is 14915600.82 and the total sum of profit is 1521767.96.
After the West region, the region of Ontario is the particular region having the second highest
sum of sales. On the other hand, after the region of Ontario, the region of Prarie is having the
second highest sum of profit.
Answer to Question 2
Count of Customer
Name
Customer Segment Region
Tot
al
Consumer Atlantic 276
Northwest
Territories 33
Nunavut 12
Ontario 326
Prarie 332
Quebec 161
West 405

INFORMATION SYSTEM2
Yukon 104
Consumer Total
164
9
Corporate Atlantic 382
Northwest
Territories 191
Nunavut 35
Ontario 635
Prarie 690
Quebec 232
West 691
Yukon 220
Corporate Total
307
6
Home Office Atlantic 193
Northwest
Territories 88
Nunavut 23
Ontario 520