Scribd
Upload
22 views3 pages

Dataset 5

The document provides a detailed breakdown of various products including their IDs, names, profit margins, categories, sales quantities, and profits per month across different regions. Key products include dishwashers, cooking stoves, mobile devices, laptops, tables, and chairs, each with varying margins and sales performance. The data is organized into sections highlighting profit margins, product categories, and monthly sales figures.

Uploaded by

tarun26chauhan
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
22 views3 pages

Dataset 5

The document provides a detailed breakdown of various products including their IDs, names, profit margins, categories, sales quantities, and profits per month across different regions. Key products include dishwashers, cooking stoves, mobile devices, laptops, tables, and chairs, each with varying margins and sales performance. The data is organized into sections highlighting profit margins, product categories, and monthly sales figures.

Uploaded by

tarun26chauhan
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/ 3

Profit

Product_ID Product_Name Margin (%


of Sales)
A001 Dishwasher 12.25%
A002 Cooking Stove 11.75%
B001 Mobile Devices 9.75%
B002 Laptops 14.15%
C001 Tables 15.50%
C002 Chairs 8.25%
Product_ID Product_Name Product_Category
A001 Dishwasher Appliances
A002 Cooking Stove Appliances
B001 Mobile Devices Electronics
B002 Laptops Electronics
C001 Tables Furniture
C002 Chairs Furniture
Price per Profit
Product_ID Product_Name Qty Sold Month Region
unit Margin
A001 Dishwasher 250 14500 February East 12.25%
A001 Dishwasher 540 12900 February West 12.25%
A001 Dishwasher 800 13500 June South 12.25%
A001 Dishwasher 520 14750 March North 12.25%
A002 Cooking Stove 690 7250 May North 11.75%
A002 Cooking Stove 1200 8050 June West 11.75%
A002 Cooking Stove 770 9990 March South 11.75%
A002 Cooking Stove 850 6900 May East 11.75%
B001 Mobile Devices 490 45000 April West 9.75%
B001 Mobile Devices 690 36500 January South 9.75%
B001 Mobile Devices 1270 21900 June East 9.75%
B001 Mobile Devices 1100 22900 March North 9.75%
B002 Laptops 220 33500 April West 14.15%
B002 Laptops 370 28900 January North 14.15%
B002 Laptops 460 36900 March East 14.15%
B002 Laptops 375 25700 May South 14.15%
C001 Tables 270 6575 April East 15.50%
C001 Tables 455 7500 April West 15.50%
C001 Tables 350 7740 February South 15.50%
C001 Tables 475 4590 March North 15.50%
C002 Chairs 1275 10300 January East 8.25%
C002 Chairs 800 7700 June North 8.25%
C002 Chairs 740 8500 March South 8.25%
C002 Chairs 1300 9200 March West 8.25%

You might also like