Question 1 :
A renowned private company pays to its employees the salary on the basis of Basic pay. The components of salary are computed according to the following terms of contract of service:
Dearness Allowance is paid @ 32% of basic pay rounded to next 10’s.
HRA and TA are computed as:
Category HRA(Rs.) TA
A 20% of basic 3000
B 30% of basic 5000
C 40% of basic 8000
However, the amount of HRA cannot exceed Rs. 11,000 in any case.
Children education allowance is Rs. 500 per month per child up to 2 children.
The contribution towards provident fund is 10% of (basic + DA) rounded to next 100’s.
Income tax is 15% on (gross –PF) rounded to nearest 10.
The basic pay is in the pay scale of 10000-1000-30000. Assume category of employees and generate no. of children between 0 to 5 randomly and fix them before entering them in column. Find out the totals below if basic pay is more than Rs. 15000. Prepare a payroll statement.
Q2Question 2 :
Prepare a spread sheet in MS EXCEL to classify 100 integers (varying between 200 to 500, Generated at Random) according to the following class intervals: (Fix them before grouping)
260 - 320
320 - 380
380 - 420
• Prepare a pie chart for the above frequency distribution.
• Compute mean and standard deviation on the basis of discrete data (Raw data)
• Find out sum of the integers which are more than 400
Q3 Question 3 :
Given below are the particulars of a Plant and M/c purchased this year
COST of Plant & M/c Rs.500,000.00
SALVAGE Value Rs.5,000.00
LIFE of the Plant & M/c (5-20 years) 5
MONTHs in the first (year 1-12) 12
You are required to prepare a generalized depreciation schedule in the given format
PERIOD DB METHOD
(The sheet should automatically sum the depreciation charged with change in its life at the end of the life)
Q4 Question 4 :
An airline company has resized its staff and issuing termination letters to its employees. The information about employee name, gender, address, post, date of termination and compensation due is available in a database. Create a database for at least 5 Employees and write the letter as follows:
<<here give sir or madam>>
SUB: TERMINATION LETTER
You have been terminated from the services from the pos <<post>>due to resizing organization staff with effect from <<date of termination>>. Your compensation of Rs.<<compensation>> has been transferred in the account number 1234567890 of KBI Bank.
DO ALL THE QUESTIONS IN FILE ATTACHED BELOW
26 freelancers are bidding on average ₹1212 for this job
hi there i think that you found the right person for acheive this work its"me" but i can give you a sample before starting the work and you decide if you like or no
hi dear, I am Pankaj Mahindru from Chandigarh. I am an accountant and I have 4 year of experience in accountancy. last but not least, accountancy is my passion.