Scribd
Upload
11 views5 pages

2025 Product Sales Data Summary

The document provides a sales report detailing units sold, unit prices, and total sales across various product categories including Kitchen, Electronics, Clothing, and Books for the year 2025. The total sales amount to $276,390, with Kitchen products generating the highest sales at $138,234. It also highlights top-selling products such as the Toaster and Induction Cooktop, along with average unit prices per category.

Uploaded by

the.cj.creations
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
11 views5 pages

2025 Product Sales Data Summary

The document provides a sales report detailing units sold, unit prices, and total sales across various product categories including Kitchen, Electronics, Clothing, and Books for the year 2025. The total sales amount to $276,390, with Kitchen products generating the highest sales at $138,234. It also highlights top-selling products such as the Toaster and Induction Cooktop, along with average unit prices per category.

Uploaded by

the.cj.creations
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

Date Product Category Product Name Units Sold Unit Price Total Sales

2/1/25 Kitchen Induction Cooktop 32 $ 481 $ 15,392


2/1/25 Electronics Smartwatch 21 $ 19 $ 399
2/1/25 Electronics Keyboard 36 $ 62 $ 2,232
7/1/25 Books Deep Work 84 $ 35 $ 2,940
7/1/25 Clothing T-shirt 40 $ 247 $ 9,880
8/1/25 Kitchen Microwave Oven 57 $ 448 $ 25,536
12/1/25 Kitchen Induction Cooktop 44 $ 29 $ 1,276
15/1/2025 Electronics Mouse 15 $ 270 $ 4,050
16/1/2025 Kitchen Toaster 99 $ 498 $ 49,302
19/1/2025 Clothing Pant 80 $ 12 $ 960
21/1/2025 Kitchen Toaster 16 $ 348 $ 5,568
22/1/2025 Electronics Tv 55 $ 184 $ 10,120
22/1/2025 Clothing Saree 56 $ 321 $ 17,976
24/1/2025 Electronics Keyboard 78 $ 291 $ 22,698
26/1/2025 Kitchen Electric Kettle 10 $ 375 $ 3,750
1/2/25 Electronics Tv 38 $ 262 $ 9,956
4/2/25 Clothing Pant 9 $ 254 $ 2,286
6/2/25 Kitchen Toaster 41 $ 54 $ 2,214
8/2/25 Clothing Saree 55 $ 473 $ 26,015
12/2/25 Kitchen Microwave Oven 97 $ 36 $ 3,492
12/2/25 Clothing Saree 25 $ 135 $ 3,375
15/2/2025 Electronics Keyboard 59 $ 73 $ 4,307
15/2/2025 Kitchen Electric Kettle 10 $ 374 $ 3,740
15/2/2025 Books Deep Work 32 $ 30 $ 960
19/2/2025 Kitchen Induction Cooktop 89 $ 201 $ 17,889
19/2/2025 Kitchen Electric Kettle 70 $ 45 $ 3,150
23/2/2025 Clothing T-shirt 37 $ 48 $ 1,776
24/2/2025 Electronics Mouse 11 $ 80 $ 880
25/2/2025 Books Can't Hurt Me 42 $ 413 $ 17,346
25/2/2025 Kitchen Microwave Oven 25 $ 277 $ 6,925
Total Sales by Category (using
SUMIF or Pivot Table) Average of Unit Price per category
Data
Product CategorSum of Total Sales Average of Unit Price
Books $ 21,246 $ 159
Clothing $ 62,268 $ 213
Electronics $ 54,642 $ 155
Kitchen $ 138,234 $ 264
Total Result $ 276,390 $ 213
Top Selling Product
Data
Product Name Sum of Units Sold Sum of Unit Price Sum of Total Sales
Can't Hurt Me 42 $ 413 $ 17,346
Deep Work 116 $ 65 $ 3,900
Electric Kettle 90 $ 794 $ 10,640
Induction Cooktop 165 $ 711 $ 34,557
Keyboard 173 $ 426 $ 29,237
Microwave Oven 179 $ 761 $ 35,953
Mouse 26 $ 350 $ 4,930
Pant 89 $ 266 $ 3,246
Saree 136 $ 929 $ 47,366
Smartwatch 21 $ 19 $ 399
Toaster 156 $ 900 $ 57,084
T-shirt 77 $ 295 $ 11,656
Tv 93 $ 446 $ 20,076
Total Result 1363 $ 6,375 $ 276,390
Max Sale $ 57,084
A Bar Chart for Total Sales by Category
Product CategorSum of Total Sales
Books $ 21,246
Clothing $ 62,268 Total Sales
Electronics $ 54,642
Kitchen $ 138,234 Total Result $276,390
Total Result $ 276,390
Kitchen $138,234

Category
Electronics $54,642

Clothing $62,268

$21,246
Books

$- $100,000 $200,000 $300,000


Axis Title
Sales

Sum of Total Sales

0,000 $300,000

You might also like