Scribd
Upload
5 views9 pages

Cell Phone Sales Data by Region

Uploaded by

sohan9908053588
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views9 pages

Cell Phone Sales Data by Region

Uploaded by

sohan9908053588
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

OrderDate Region Manager SalesMan Item Units Unit_price

10/22/18 East Martha Alexander Cell Phone 64 225.00


11/8/18 East Douglas Karen Cell Phone 15 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
2/26/18 Central Timothy David Cell Phone 27 225.00
10/22/18 East Martha Alexander Cell Phone 64 225.00
11/8/18 East Douglas Karen Cell Phone 15 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
2/26/18 Central Timothy David Cell Phone 27 225.00
10/22/18 East Martha Alexander Cell Phone 64 225.00
11/8/18 East Douglas Karen Cell Phone 15 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
2/26/18 Central Timothy David Cell Phone 27 225.00
10/22/18 East Martha Alexander Cell Phone 64 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
2/26/18 Central Timothy David Cell Phone 27 225.00
10/22/18 East Martha Alexander Cell Phone 64 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
2/26/18 Central Timothy David Cell Phone 27 225.00
10/22/18 East Martha Alexander Cell Phone 64 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
2/26/18 Central Timothy David Cell Phone 27 225.00
10/22/18 East Martha Alexander Cell Phone 64 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
Sale_amt
14,400.00
3,375.00
21,600.00
17,100.00
6,075.00
14,400.00
3,375.00
21,600.00
17,100.00
6,075.00
14,400.00
3,375.00
21,600.00
17,100.00
6,075.00
14,400.00
21,600.00
17,100.00
6,075.00
14,400.00
21,600.00
17,100.00
6,075.00
14,400.00
21,600.00
17,100.00
6,075.00
14,400.00
21,600.00
17,100.00
OrderDate 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
Region 10/22/18 East East East West Central East
2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
Manager Martha Douglas Martha Timothy Timothy Martha
2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
Alexande Karen Diana Stephen David Alexande
4/27/19
SalesMan r r
2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
Item 9/27/19 Cell PhoneCell PhoneCell PhoneCell Phone Cell PhoneCell Phone
2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
Units 27 64 15 96 76 27 64
2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
Unit_price 225.00 225.00 225.00 225.00 225.00 225.00 225.00
2/26/18 10/22/18 11/8/18 4/27/19 9/27/19 2/26/18 10/22/18
Sale_amt 6,075.00 ### 3,375.00 ### ### 6,075.00 ###
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
East East West Central East East East West
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
Douglas Martha Timothy Timothy Martha Douglas Martha Timothy
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
Karen Diana Stephen David Alexande Karen Diana Stephen
r
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
Cell PhoneCell PhoneCell Phone Cell PhoneCell PhoneCell PhoneCell PhoneCell Phone
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
15 96 76 27 64 15 96 76
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
225.00 225.00 225.00 225.00 225.00 225.00 225.00 225.00
11/8/18 4/27/19 9/27/19 2/26/18 10/22/18 11/8/18 4/27/19 9/27/19
3,375.00 ### ### 6,075.00 ### 3,375.00 ### ###
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
Central East East West Central East East West
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
Timothy Martha Martha Timothy Timothy Martha Martha Timothy
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
David Alexande Diana Stephen David Alexande Diana Stephen
r r
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
Cell PhoneCell Phone Cell PhoneCell PhoneCell PhoneCell Phone Cell PhoneCell Phone
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
27 64 96 76 27 64 96 76
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
225.00 225.00 225.00 225.00 225.00 225.00 225.00 225.00
2/26/18 10/22/18 4/27/19 9/27/19 2/26/18 10/22/18 4/27/19 9/27/19
6,075.00 ### ### ### 6,075.00 ### ### ###
2/26/18 10/22/18 4/27/19 9/27/19
2/26/18 10/22/18 4/27/19 9/27/19
Central East East West
2/26/18 10/22/18 4/27/19 9/27/19
Timothy Martha Martha Timothy
2/26/18 10/22/18 4/27/19 9/27/19
David Alexande Diana Stephen
r
2/26/18 10/22/18 4/27/19 9/27/19
Cell Phone Cell PhoneCell Phone Cell PhoneCell Phone
2/26/18 10/22/18 4/27/19 9/27/19
27 64 96 76
2/26/18 10/22/18 4/27/19 9/27/19
225.00 225.00 225.00 225.00
2/26/18 10/22/18 4/27/19 9/27/19
6,075.00 ### ### ###
2/26/18 10/22/18 4/27/19 9/27/19
2/26/18 10/22/18 4/27/19 9/27/19
Central East East West
2/26/18 10/22/18 4/27/19 9/27/19
Timothy Martha Martha Timothy
2/26/18 10/22/18 4/27/19 9/27/19
David Alexande Diana Stephen
r
2/26/18 10/22/18 4/27/19 9/27/19
Cell PhoneCell Phone Cell PhoneCell Phone
2/26/18 10/22/18 4/27/19 9/27/19
27 64 96 76
2/26/18 10/22/18 4/27/19 9/27/19
225.00 225.00 225.00 225.00
2/26/18 10/22/18 4/27/19 9/27/19
6,075.00 ### ### ###
OrderDate Region Manager SalesMan Item Units Unit_price
1/6/18 East Martha Alexander Television 95 1,198.00
1/23/18 Central Hermann Shelli Home Theater 50 500.00
2/9/18 Central Hermann Luis Television 36 1,198.00
2/26/18 Central Timothy David Cell Phone 27 225.00
3/15/18 West Timothy Stephen Television 56 1,198.00
4/1/18 East Martha Alexander Home Theater 60 500.00
4/18/18 Central Martha Steven Television 75 1,198.00
5/5/18 Central Hermann Luis Television 90 1,198.00
5/22/18 West Douglas Michael Television 32 1,198.00
6/8/18 East Martha Alexander Home Theater 60 500.00
6/25/18 Central Hermann Sigal Television 90 1,198.00
7/12/18 East Martha Diana Home Theater 29 500.00
7/29/18 East Douglas Karen Home Theater 81 500.00
8/15/18 East Martha Alexander Television 35 1,198.00
9/1/18 Central Douglas John Desk 2 125.00
9/18/18 East Martha Alexander Video Games 16 58.50
10/5/18 Central Hermann Sigal Home Theater 28 500.00
10/22/18 East Martha Alexander Cell Phone 64 225.00
11/8/18 East Douglas Karen Cell Phone 15 225.00
11/25/18 Central Hermann Shelli Video Games 96 58.50
12/12/18 Central Douglas John Television 67 1,198.00
12/29/18 East Douglas Karen Video Games 74 58.50
1/15/19 Central Timothy David Home Theater 46 500.00
2/1/19 Central Douglas John Home Theater 87 500.00
2/18/19 East Martha Alexander Home Theater 4 500.00
3/7/19 West Timothy Stephen Home Theater 7 500.00
3/24/19 Central Hermann Luis Video Games 50 58.50
4/10/19 Central Martha Steven Television 66 1,198.00
4/27/19 East Martha Diana Cell Phone 96 225.00
5/14/19 Central Timothy David Television 53 1,198.00
5/31/19 Central Timothy David Home Theater 80 500.00
6/17/19 Central Hermann Shelli Desk 5 125.00
7/4/19 East Martha Alexander Video Games 62 58.50
7/21/19 Central Hermann Sigal Video Games 55 58.50
8/7/19 Central Hermann Shelli Video Games 42 58.50
8/24/19 West Timothy Stephen Desk 3 125.00
9/10/19 Central Timothy David Television 7 1,198.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
10/14/19 West Douglas Michael Home Theater 57 500.00
10/31/19 Central Martha Steven Television 14 1,198.00
11/17/19 Central Hermann Luis Home Theater 11 500.00
12/4/19 Central Hermann Luis Home Theater 94 500.00
12/21/19 Central Martha Steven Home Theater 28 500.00
Sale_amt
113,810.00
25,000.00
43,128.00
6,075.00
67,088.00
30,000.00
89,850.00
107,820.00
38,336.00
30,000.00
107,820.00
14,500.00
40,500.00
41,930.00
250.00
936.00
14,000.00
14,400.00
3,375.00
5,616.00
80,266.00
4,329.00
23,000.00
43,500.00
2,000.00
3,500.00
2,925.00
79,068.00
21,600.00
63,494.00
40,000.00
625.00
3,627.00
3,217.50
2,457.00
375.00
8,386.00
17,100.00
28,500.00
16,772.00
5,500.00
47,000.00
14,000.00

Common questions

Powered by AI

The selection of sales items influences sales performance significantly. Karen's sales of cell phones and home theaters show variability, with only 15 units of cell phones sold on November 8, 2018. The mix of low and high-value items could affect motivation and commission-based sales performance .

The low sales of desks, with a maximum of 5 units sold on June 17 in the Central region and only 3 on August 24 in the West region, could be attributed to a lack of demand, possibly because desks were not a primary line of business or were overshadowed by the popularity of tech items like cell phones and home theaters .

Hermann's sales strategy in the Central region for home theaters in 2018 appears effective. Sales included 50 units on January 23 and 28 on October 5. Despite some fluctuation, consistent sales suggest a stable strategy, with a focus on maintaining steady sales throughout the year .

Discrepancies in sale amounts might be due to incorrect data entry or copying errors in the dataset, as identical transactions like those on October 22, 2018, for cell phone sales in the East show repeated inconsistencies in their entry without clear explanation .

Martha achieved the highest sales for cell phones in the East region during 2019 with a total sale amount of $21,600.00 on April 27, 2019 .

In 2019, the Central region's sales of home theaters displayed a significant variation. Sales commenced with 46 units in January, followed by fluctuating sales numbers with a peak of 94 units on December 4. This indicates an inconsistency in sales, but a notable increase towards the end of the year .

The overall sales volume for cell phones in 2018, with multiple transactions like 64 units on October 22 in the East region, suggests a strong demand. However, fewer sales like 15 units in other instances highlight disparities, potentially due to market saturation or better competitors .

The Central region sold more television units compared to the East region in 2018. In the Central region, television sales included 36 units on February 9, 75 units on April 18, 90 units on May 5, and 90 units on June 25. In contrast, the East region sold 95 units on January 6 and 35 units on August 15 .

Timothy was the primary manager overseeing cell phone sales in the West region. His management resulted in significant sales on September 27, 2019, contributing $17,100.00 to overall revenue, indicating a strong managerial impact on sales performance .

Item price plays a critical role in determining sales amount. High-priced items like televisions often bring large sale amounts, such as $107,820.00 for 90 units, starkly contrasting with lower-priced items like video games with smaller sales value. Regional differences also contribute, with variations in consumer purchasing power influencing purchase decisions across categories .

You might also like