0% found this document useful (0 votes)
11 views12 pages

Assignment 1

The document contains sales data for various products across different categories including Clothing, Grocery, and Electronics, with detailed records of quantity sold, selling price per unit, and total sales amount. The sales span from January 25, 2025, to April 13, 2025, with a total sales amount of 1,873,832. The data is organized in a tabular format, listing each sale transaction separately.
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
0% found this document useful (0 votes)
11 views12 pages

Assignment 1

The document contains sales data for various products across different categories including Clothing, Grocery, and Electronics, with detailed records of quantity sold, selling price per unit, and total sales amount. The sales span from January 25, 2025, to April 13, 2025, with a total sales amount of 1,873,832. The data is organized in a tabular format, listing each sale transaction separately.
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
You are on page 1/ 12

Date Of Sale Product Name Category Quantity Sold

25/1/2025 Jeans Clothing 13


27/1/2025 Shirt Clothing 22
31/1/2025 Bread Grocery 42
2/2/2025 Smartphone Electronics 1
5/2/2025 Cooler Electronics 5
7/2/2025 Shoes Clothing 2
10/2/2025 Tablet Electronics 1
11/2/2025 Sugar Grocery 10
13/2/2025 T-Shirt Clothing 35
17/2/2025 Milk Grocery 4
19/2/2025 Curtains Clothing 8
20/2/2025 Laptop Electronics 3
22/2/2025 Jeans Clothing 4
22/2/2025 TV Electronics 22
26/2/2025 Smartphone Electronics 4
28/2/2025 Geyser Electronics 3
3/3/2025 Shampoo Clothing 2
6/3/2025 Kurta Clothing 3
7/3/2025 Cargo Clothing 6
11/3/2025 Peanut Butter Grocery 8
13/3/2025 Fan Electronics 15
17/3/2025 Slipper Clothing 3
19/3/2025 Speaker Electronics 8
23/3/2025 Jeans Clothing 18
25/3/2025 AC Electronics 14
31/3/2025 Refrigerator Electronics 20
3/4/2025 Sugar Grocery 5
6/4/2025 Flour Grocery 30
11/4/2025 Shirt Clothing 8
13/4/2025 Bulb Electronics 52
Selling Price Per Unit Total Sales Amount
1400 18200
600 13200
55 2310
12000 12000
4000 20000
2000 4000
18000 18000
58 580
700 24500
58 232
500 4000
70000 210000
1400 5600
10000 220000
28000 112000
6000 18000
249 498
800 2400
1200 7200
469 3752
1700 25500
300 900
6000 48000
2200 39600
35000 490000
28000 560000
52 260
32 960
549 4392
149 7748
Date Of Sale Product Name Category Quantity Sold
25/1/2025 Jeans Clothing 13
27/1/2025 Shirt Clothing 22
31/1/2025 Bread Grocery 42
2/2/2025 Smartphone Electronics 1
5/2/2025 Cooler Electronics 5
7/2/2025 Shoes Clothing 2
10/2/2025 Tablet Electronics 1
11/2/2025 Sugar Grocery 10
13/2/2025 T-Shirt Clothing 35
17/2/2025 Milk Grocery 4
19/2/2025 Curtains Clothing 8
20/2/2025 Laptop Electronics 3
22/2/2025 Jeans Clothing 4
22/2/2025 TV Electronics 22
26/2/2025 Smartphone Electronics 4
28/2/2025 Geyser Electronics 3
3/3/2025 Shampoo Clothing 2
6/3/2025 Kurta Clothing 3
7/3/2025 Cargo Clothing 6
11/3/2025 Peanut Butter Grocery 8
13/3/2025 Fan Electronics 15
17/3/2025 Slipper Clothing 3
19/3/2025 Speaker Electronics 8
23/3/2025 Jeans Clothing 18
25/3/2025 AC Electronics 14
31/3/2025 Refrigerator Electronics 20
3/4/2025 Sugar Grocery 5
6/4/2025 Flour Grocery 30
11/4/2025 Shirt Clothing 8
13/4/2025 Bulb Electronics 52
Selling Price Per Unit Total Sales Amount
1400 18200
600 13200
55 2310
12000 12000
4000 20000
2000 4000
18000 18000
58 580
700 24500
58 232
500 4000
70000 210000
1400 5600
10000 220000
28000 112000
6000 18000
249 498
800 2400
1200 7200
469 3752
1700 25500
300 900
6000 48000
2200 39600
35000 490000
28000 560000
52 260
32 960
549 4392
149 7748
Date Of Sale Product Name Category Quantity Sold
25/1/2025 Jeans Clothing 13
27/1/2025 Shirt Clothing 22
31/1/2025 Bread Grocery 42
2/2/2025 Smartphone Electronics 1
5/2/2025 Cooler Electronics 5
7/2/2025 Shoes Clothing 2
10/2/2025 Tablet Electronics 1
11/2/2025 Sugar Grocery 10
13/2/2025 T-Shirt Clothing 35
17/2/2025 Milk Grocery 4
19/2/2025 Curtains Clothing 8
20/2/2025 Laptop Electronics 3
22/2/2025 Jeans Clothing 4
22/2/2025 TV Electronics 22
26/2/2025 Smartphone Electronics 4
28/2/2025 Geyser Electronics 3
3/3/2025 Shampoo Clothing 2
6/3/2025 Kurta Clothing 3
7/3/2025 Cargo Clothing 6
11/3/2025 Peanut Butter Grocery 8
13/3/2025 Fan Electronics 15
17/3/2025 Slipper Clothing 3
19/3/2025 Speaker Electronics 8
23/3/2025 Jeans Clothing 18
25/3/2025 AC Electronics 14
31/3/2025 Refrigerator Electronics 20
3/4/2025 Sugar Grocery 5
6/4/2025 Flour Grocery 30
11/4/2025 Shirt Clothing 8
13/4/2025 Bulb Electronics 52
Selling Price Per Unit Total Sales Amount
1400 18200
600 13200
55 2310
12000 12000
4000 20000
2000 4000
18000 18000
58 580
700 24500
58 232
500 4000
70000 210000
1400 5600
10000 220000
28000 112000
6000 18000
249 498
800 2400
1200 7200
469 3752
1700 25500
300 900
6000 48000
2200 39600
35000 490000
28000 560000
52 260
32 960
549 4392
149 7748
1873832
Date Of Sale Product Name Category Quantity Sold
25/1/2025 Jeans Clothing 13
27/1/2025 Shirt Clothing 22
31/1/2025 Bread Grocery 42
2/2/2025 Smartphone Electronics 1
5/2/2025 Cooler Electronics 5
7/2/2025 Shoes Clothing 2
10/2/2025 Tablet Electronics 1
11/2/2025 Sugar Grocery 10
13/2/2025 T-Shirt Clothing 35
17/2/2025 Milk Grocery 4
19/2/2025 Curtains Clothing 8
20/2/2025 Laptop Electronics 3
22/2/2025 Jeans Clothing 4
22/2/2025 TV Electronics 22
26/2/2025 Smartphone Electronics 4
28/2/2025 Geyser Electronics 3
3/3/2025 Shampoo Clothing 2
6/3/2025 Kurta Clothing 3
7/3/2025 Cargo Clothing 6
11/3/2025 Peanut Butter Grocery 8
13/3/2025 Fan Electronics 15
17/3/2025 Slipper Clothing 3
19/3/2025 Speaker Electronics 8
23/3/2025 Jeans Clothing 18
25/3/2025 AC Electronics 14
31/3/2025 Refrigerator Electronics 20
3/4/2025 Sugar Grocery 5
6/4/2025 Flour Grocery 30
11/4/2025 Shirt Clothing 8
13/4/2025 Bulb Electronics 52
Selling Price Per Unit Total Sales Amount
1400 18200
600 13200
55 2310
12000 12000
4000 20000
2000 4000
18000 18000
58 580
700 24500
58 232
500 4000
70000 210000
1400 5600
10000 220000
28000 112000
6000 18000
249 498
800 2400
1200 7200
469 3752
1700 25500
300 900
6000 48000
2200 39600
35000 490000
28000 560000
52 260
32 960
549 4392
149 7748
62461.0666666667
Date Of Sale Product Name Category Quantity Sold
25/1/2025 Jeans Clothing 13
27/1/2025 Shirt Clothing 22
31/1/2025 Bread Grocery 42
2/2/2025 Smartphone Electronics 1
5/2/2025 Cooler Electronics 5
7/2/2025 Shoes Clothing 2
10/2/2025 Tablet Electronics 1
11/2/2025 Sugar Grocery 10
13/2/2025 T-Shirt Clothing 35
17/2/2025 Milk Grocery 4
19/2/2025 Curtains Clothing 8
20/2/2025 Laptop Electronics 3
22/2/2025 Jeans Clothing 4
22/2/2025 TV Electronics 22
26/2/2025 Smartphone Electronics 4
28/2/2025 Geyser Electronics 3
3/3/2025 Shampoo Clothing 2
6/3/2025 Kurta Clothing 3
7/3/2025 Cargo Clothing 6
11/3/2025 Peanut Butter Grocery 8
13/3/2025 Fan Electronics 15
17/3/2025 Slipper Clothing 3
19/3/2025 Speaker Electronics 8
23/3/2025 Jeans Clothing 18
25/3/2025 AC Electronics 14
31/3/2025 Refrigerator Electronics 20
3/4/2025 Sugar Grocery 5
6/4/2025 Flour Grocery 30
11/4/2025 Shirt Clothing 8
13/4/2025 Bulb Electronics 52
Selling Price Per Unit Total Sales Amount
1400 18200
600 13200
55 2310
12000 12000
4000 20000
2000 4000
18000 18000
58 580
700 24500
58 232
500 4000
70000 210000
1400 5600
10000 220000
28000 112000
6000 18000
249 498
800 2400
1200 7200
469 3752
1700 25500
300 900
6000 48000
2200 39600
35000 490000
28000 560000
52 260
32 960
549 4392
149 7748
Date Of Sale Product Name Category Quantity Sold
25/1/2025 Jeans Clothing 13
27/1/2025 Shirt Clothing 22
31/1/2025 Bread Grocery 42
2/2/2025 Smartphone Electronics 1
5/2/2025 Cooler Electronics 5
7/2/2025 Shoes Clothing 2
10/2/2025 Tablet Electronics 1
11/2/2025 Sugar Grocery 10
13/2/2025 T-Shirt Clothing 35
17/2/2025 Milk Grocery 4
19/2/2025 Curtains Clothing 8
20/2/2025 Laptop Electronics 3
22/2/2025 Jeans Clothing 4
22/2/2025 TV Electronics 22
26/2/2025 Smartphone Electronics 4
28/2/2025 Geyser Electronics 3
3/3/2025 Shampoo Clothing 2
6/3/2025 Kurta Clothing 3
7/3/2025 Cargo Clothing 6
11/3/2025 Peanut Butter Grocery 8
13/3/2025 Fan Electronics 15
17/3/2025 Slipper Clothing 3
19/3/2025 Speaker Electronics 8
23/3/2025 Jeans Clothing 18
25/3/2025 AC Electronics 14
31/3/2025 Refrigerator Electronics 20
3/4/2025 Sugar Grocery 5
6/4/2025 Flour Grocery 30
11/4/2025 Shirt Clothing 8
13/4/2025 Bulb Electronics 52
Selling Price Per Unit Total Sales Amount
1400 18200
600 13200
55 2310
12000 12000
4000 20000
2000 4000
18000 18000
58 580
700 24500
58 232
500 4000
70000 210000
1400 5600
10000 220000
28000 112000
6000 18000
249 498
800 2400
1200 7200
469 3752
1700 25500
300 900
6000 48000
2200 39600
35000 490000
28000 560000
52 260
32 960
549 4392
149 7748

You might also like