Scribd
Upload
96 views4 pages

Disha Excel Work

The document shows sales data for various products from January to March 2019. It lists 10 products with their purchase amounts, sales amounts, and income generated. The total purchase amount was Rs. 232,250 and total sales and income were Rs. 289,400 and Rs. 57,150 respectively.

Uploaded by

harish
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
96 views4 pages

Disha Excel Work

The document shows sales data for various products from January to March 2019. It lists 10 products with their purchase amounts, sales amounts, and income generated. The total purchase amount was Rs. 232,250 and total sales and income were Rs. 289,400 and Rs. 57,150 respectively.

Uploaded by

harish
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/ 4

Data

PRODUCT _NAMSum - PURCHASE Sum - SALE Sum - INCOME


KEYBOARD 250 400 150
Total Result 250 400 150
PRODUCT_ID PRODUCT _NAME PURCHASE

101 COMPUTER 20,000

102 KEYBOARD 250

103 LAPTOP 35,000

104 AIR CONDITIONER 40,000

105 TELEVISION 35,000

106 REFRIGERATOR 20,000

107 FOOD PROCESSOR 2,000

108 WASHING MACHINE 25,000

109 SMART PHONE 45,000

110 TABLET 10,000

GRAND TOTAL 232,250


SALE INCOME

30,000 10,000

400 150

40,000 5,000

45,000 5,000

50,000 15,000

25,000 5,000

4,000 2,000

30,000 5,000

50,000 5,000

15,000 5,000

289,400 57,150

0
BALANCE SHEET OF SONIA,ROHIT AND UDIT AS ON MARCH,31,2019
LIABILITIES AMOUNT (RS.) ASSETS AMOUNT
(RS.)
Creditors 30,000 Buildings 200,000
Bills Payable 30,000 Machinery 40,000
Bank Loan 120,000 Stock 160,000
Sonia's husband's loan 130,000 Bills Receivable 120,000
General Reserve 80,000 Furniture 80,000
Capitals: Cash at Bank 60,000
Sonia 70,000
Rohit 90,000
Udit 110,000 270,000

660,000 660,000

You might also like