Scribd
Upload
5 views6 pages

Product Revenue and Stock Analysis

The document presents a summary of revenue generated from various product categories, totaling 236,750. It includes detailed revenue breakdowns for individual products and suppliers, highlighting sales figures and stock levels. Additionally, it provides average unit prices for each product listed.

Uploaded by

roshneekushwaha77
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 views6 pages

Product Revenue and Stock Analysis

The document presents a summary of revenue generated from various product categories, totaling 236,750. It includes detailed revenue breakdowns for individual products and suppliers, highlighting sales figures and stock levels. Additionally, it provides average unit prices for each product listed.

Uploaded by

roshneekushwaha77
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

Row Labels Sum of Revenue

Electronics 195000
Appliances 23000
Furniture 11000
Lighting 7750
Grand Total 236750
Row Labels Sum of Revenue
Phone Y 80000
Laptop X 70000
Tablet Z 45000
Fan E 10500
Microwave G 10000
Desk B 6000
Chair A 5000
Bulb D 4000
Lamp C 3750
Heater F 2500
Grand Total 236750
Data
Product Name Product ID Supplier Sum of Stock LevelSum ofSum of Revenue
Bulb D 500 250 4,000
2007 500 250 4,000
Supplier D 500 250 4,000
Chair A 100 40 5,000
2004 100 40 5,000
Supplier C 100 40 5,000
Desk B 70 35 6,000
2005 70 35 6,000
Supplier C 70 35 6,000
Fan E 60 30 ###
2008 60 30 ###
Supplier E 60 30 ###
Heater F 20 10 2,500
2009 20 10 2,500
Supplier E 20 10 2,500
Lamp C 40 20 3,750
2006 40 20 3,750
Supplier D 40 20 3,750
Laptop X 50 20 ###
2001 50 20 ###
Supplier A 50 20 ###
Microwave G 10 5 ###
2010 10 5 ###
Supplier F 10 5 ###
Phone Y 30 15 ###
2002 30 15 ###
Supplier B 30 15 ###
Tablet Z 25 10 ###
2003 25 10 ###
Supplier A 25 10 ###
Total Result 905 435 ###
Product Product Stock Reorder Units
Category Supplier Unit Price Revenue
ID Name Level Point Sold
Electronic
2001 Laptop X Supplier A 50 20 100 700 70,000
s
Electronic
2002 Phone Y Supplier B 30 15 200 400 80,000
s
Electronic
2003 Tablet Z Supplier A 25 10 150 300 45,000
s

2004 Chair A Furniture Supplier C 100 40 50 100 5,000

2005 Desk B Furniture Supplier C 70 35 30 200 6,000

2006 Lamp C Lighting Supplier D 40 20 75 50 3,750

2007 Bulb D Lighting Supplier D 500 250 400 10 4,000

Appliance
2008 Fan E Supplier E 60 30 70 150 10,500
s
Appliance
2009 Heater F Supplier E 20 10 25 100 2,500
s
Microwav Appliance
2010 Supplier F 10 5 40 250 10,000
eG s
Supplier Sum of Units Sold

Supplier D 475 Category

Supplier A 250 Appliances

Supplier B 200

Supplier E 95

Supplier C 80

Supplier F 40 Electronics

Total Result 1140

(empty) Furniture

Lighting

Total Result
Product Name Average of Unit Price

166.6667

Fan E 150

Heater F 100

Microwave G 250

466.6667

Laptop X 700

Phone Y 400

Tablet Z 300
150
Chair A 100
Desk B 200
30
Bulb D 10
Lamp C 50
226

You might also like