0% found this document useful (0 votes)
58 views3 pages

Stock Sheet: S# Item Brand Quantity Cost Total Cost

The document is a stock sheet that lists 10 items with their corresponding brand, quantity in stock, cost per unit, total cost, selling price per unit, total selling price from selling the quantity in stock, single unit profit, and total profit generated from selling the entire stock of each item. It provides the total costs, total selling prices, and total profits for all items.

Uploaded by

irfanali
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)
58 views3 pages

Stock Sheet: S# Item Brand Quantity Cost Total Cost

The document is a stock sheet that lists 10 items with their corresponding brand, quantity in stock, cost per unit, total cost, selling price per unit, total selling price from selling the quantity in stock, single unit profit, and total profit generated from selling the entire stock of each item. It provides the total costs, total selling prices, and total profits for all items.

Uploaded by

irfanali
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

Stock Sheet

S# Item Brand Quantity Cost Total Cost


1 7up Pepsi 200 30 6000
2 Aquafina Nestle 70 30 2100
3 Collgate Unilever 65 50 3250
4 Dairy Milk Dairy 55 100 5500
5 Dove Cream Tibet 150 350 52500
6 Kitkat Dairy 60 110 6600
7 Lays Pepsico 35 30 1050
8 Shan Masala Shan 5 50 250
9 Sunsilk Unilever 17 200 3400
10 Super LU 110 20 2200
Total 970 82850
ock Sheet
Selling Price Total Selling Price Single unit profit
40 8000 2000
35 2450 350
59 3835 585
120 6600 1100
400 60000 7500
120 7200 600
40 1400 350
60 300 50
250 4250 850
30 3300 1100
1154 97335 14485
Total profit
240000
73500
191750
660000
21000000
792000
42000
15000
850000
66000
23930250

You might also like