Question

Krunal Mehta's image
Krunal Mehta
Oct. 10, 2016, 8:08 p.m.
Item Quantity Rate Amount Vat 5% Total Amount Commission (Rs 2 per Quantity) Net Amount
P 10000 6 60000 3000 63000 1260 61740
Q 20000 7 140000 7000 147000 2940 144060
R 15000 8 120000 6000 126000 2520 123480
S 30000 9 270000 13500 283500 5670 277830
T 250000 4 1000000 50000 1050000 21000 1029000
Total 325000 34 1590000 79500 1669500 33390

1636110

 

Is the solution right Example solved - not able to track the answer when clicking on view answer.

Answer
Krunal Mehta's image
Krunal Mehta
Oct. 10, 2016, 12:46 p.m.
Employee Name Basic Salary DA            (20% of Basic) Special Pay 1/2*(basic+da) Incentive      Double of (Basic + Special) Gross Salary PF              (12% OF Basic+DA) Net Salary (Gross Salary-PF)
P 50000            
Q 40000            
R 10000            
S 90000            
T 8000            
Total 198000            

how to solve this sum/example in basic excel with formula?

Answer
Praveen Jha's image
Praveen Jha
Oct. 10, 2016, 11:20 a.m.
when I should service tax deposit 12000. but I deposite service tax 15000. than refund.
Answer
Praveen Jha's image
Praveen Jha
Oct. 10, 2016, 11:18 a.m.
when service tax over amount deposite than refund prosidure.
Answer
Praveen Jha's image
Praveen Jha
Oct. 9, 2016, 7:41 p.m.
when rent rs 80000 service tax rs 12000 and less tds 8000 = 84000. how much amount service tax deposite.
Answer
Praveen Jha's image
Praveen Jha
Oct. 9, 2016, 6:34 p.m.
when rent rs 80000. service tax 12000. And tds 10000. total rent with service tax = 92000-tds 10000=84000 rent received. than service tax how much amount deposite. pls give me answer.
Answer
Chaitali Jiwankar's image
Chaitali Jiwankar
Oct. 9, 2016, 1:08 a.m.
In company final account after sales we show goods destroyed by fire and goods distributed freely for advertisement by company,in trading account on credit side , why it is so??
Answer
Praveen Jha's image
Praveen Jha
Oct. 8, 2016, 3:54 p.m.
when rent 112514 than tds and s.tax include and calculation
Answer
Accounts Tax GST
shouryasharma11's image
shouryasharma11
Oct. 8, 2016, 1:55 p.m.

sir, what the deffination of TDS, SERVICE TAX , ND EXCISE DUTY

Answer
Vijesh Malviya's image
Vijesh Malviya
Oct. 8, 2016, 1:15 p.m.

Pension Received comes under which head

Answer
Arun Kumar's image
Arun Kumar
Oct. 8, 2016, 11:47 a.m.

√7-√5 is irrational

Answer
reshma gavhane's image
reshma gavhane
Oct. 8, 2016, 11:08 a.m.

HOW TO PREPARE  EMPLOYEE INCENTIVE LEDGER UNDER WHICH HEADING

Answer
Maths
SURAJ JHA's image
SURAJ JHA
Oct. 7, 2016, 11:59 p.m.
Why do we multiply by 7 only? 

Answer
Manjula V's image
Manjula V
Oct. 7, 2016, 5:26 p.m.
How to prepare the company reports on excel formats
Example: Cash flow, MIS, Expenses report, 

Answer
Praveen Jha's image
Praveen Jha
Oct. 7, 2016, 4:37 p.m.
when monthly rent rs 192514 than service tax paid
Answer
Praveen Jha's image
Praveen Jha
Oct. 7, 2016, 3:49 p.m.
when rent rs 192514 than service charges of june
Answer