Preview

excal assignment

Powerful Essays
Open Document
Open Document
1747 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
excal assignment
ASSIGNMENT

MS-EXCEL

A. M/s Alpha Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee consists of Basic Pay, Dearness Pay (D.P) and House Rent Allowance (H.R.A). The components of salary are computed according to the following terms of contract of service:
Dearness Allowance is paid @10% of basic pay subject to a maximum of Rs. 5400
HRA is computed as per the following scale: Basic Pay HRA(Rs.) Up to 10,000 5,000 From 10,001 to. 25,000 7,000 More than 25,000 9,000
Required: Prepare payroll of 10 employees of MIs Alpha Ltd for the month of March 2009 , in the format given below according to above terms of contract .FiII information about Employee Identification (Empld), Name of Employees and their Basic Pay on your own.
Payroll for the Month of March 2006.
EmpId
Name of Employees
Basic
DA
HRA
Gross

Total

B. M/s Beta Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee consists of Basic Pay, Dearness Pay (D.P) and House Rent Allowance (H.R.A). The components of salary are computed according to the following terms of contract of service: Dearness Allowance is paid @ 10% of basic pay subject to a maximum of Rs. 5400. .
HRA is computed as per the following scale:
Category HRA
A 25%
B 30%
C 35%
Required: Prepare payroll of 10 employees of MIs Beta Ltd for the month of April 2009, in the format given below according to above terms of contract .FiII information about Employee Identification (Empld), Name of Employees and their Basic Pay on your own.

Payroll for the Month of April 2009.
EmpId
Name of Employees
Category
Basic
DA
HRA
Gross

Total

C. M/s Gamma Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee

You May Also Find These Documents Helpful

  • Better Essays

    FDPP 1226 Denise Brown

    • 2756 Words
    • 9 Pages

    The report will go on to assess the pay methods and procedures, the appropriateness of methods and procedures against audit requirements, design and distribution of payroll reports and the application of quality standards to the payroll function. This will be based within the payroll team within EC Harris. “EC Harris is the leading global natural and built asset design and consultancy firm, helping clients make the most of their investment and expenditure in built assets” (E C Harris LLP, 2014). The payroll team is based within the financial processing team, the payroll team comprises of two payroll specialists, a senior payroll specialist and they sit under the financial processing managing.…

    • 2756 Words
    • 9 Pages
    Better Essays
  • Good Essays

    Identify the shortcomings in the payroll procedures used in the payroll department of the Galena plant and suggest corrective actions.…

    • 792 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    The next three sections describe how the payroll process flows for specific types of systems—outsourced payroll, in-house computerized payroll, and in-house manual payroll. In this section, we cover the general beginning-to-end processing of payroll, step-by-step, irrespective of the specific payroll system, in order to show the general process flow. Though some of these steps will not apply to each of the processes noted in later sections, it gives a good feel for how a payroll is completed. The steps: 1. Set up new employees. New employees must fill out payroll-specific information as part of the hiring process, such as the W-4 form and medical insurance forms that may require payroll deductions. Copies of this information should be set aside in the payroll department in anticipation of its inclusion in the next payroll. 2. Collect timecard information. Salaried employees require no change in wages paid for each payroll, but an employer must collect and interpret information about hours worked for nonexempt employees. This may involve…

    • 6302 Words
    • 26 Pages
    Powerful Essays
  • Satisfactory Essays

    hr report on sbi

    • 2420 Words
    • 10 Pages

    Officers in JMGS-I who have moved to scale of pay for MMGS-II after reaching maximum shall be eligible for four stagnation increments for every three completed years of service of which first two shall be Rs. 800/- each and next Rs.900/- each.…

    • 2420 Words
    • 10 Pages
    Satisfactory Essays
  • Powerful Essays

    9. A man's basic pay for a 40 hours' week is Rs. 200. Overtimes is paid at 25% above the basic…

    • 629 Words
    • 3 Pages
    Powerful Essays
  • Good Essays

    Social Cost Audit

    • 1690 Words
    • 7 Pages

    The term salary is defined as the remuneration paid to the clerical and managerial personnel employed on monthly or annual basis.…

    • 1690 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Nvq3

    • 257 Words
    • 2 Pages

    understanding employment responsibilities and rights in health, social care or childrens and young peoples settings.…

    • 257 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    In Partial Fulfillment of the Requirements for the Degree of Bachelor of Science Major in Financial Management, Business Administration and Accountancy…

    • 4712 Words
    • 19 Pages
    Powerful Essays
  • Powerful Essays

    Evan TERM paper final

    • 4108 Words
    • 17 Pages

    The Term paper is all about the Establishing pay rates relating to DBL group. The paper mainly covers the compensation management system of DBL group. Within the arena of paper, all the practices of DBL group relating to Pay rates have been examined as to understand the salary rate of DBL group, Establishing pay rates includes many more things and one of them is Job evaluation. Job evaluation is very important to understand the worthiness of job that could the base of establish pay rates. The paper also covers…

    • 4108 Words
    • 17 Pages
    Powerful Essays
  • Satisfactory Essays

    Payroll System

    • 1016 Words
    • 5 Pages

    Payroll consists of the process by which a business pays its employees for work performed during a specific period. A payroll system allows businesses to follow a set series of processes in order to make timely, correct payments in compliance with government regulations. A payroll system may be manual or computerized and handled in-house or outsourced to another provider.…

    • 1016 Words
    • 5 Pages
    Satisfactory Essays
  • Powerful Essays

    This project covers the various aspects of c&b policies of Millat Equipment Ltd. MEL does not follow formal job grades or salary ranges. It is decided on the bases of hierarchy of the job and the salary range for senior manager does not fall within any specific range. Benefits provided include medical allowances, travel allowances, salary advances, car schemes and life insurance. Increments are not performance based but are annual. Bonuses don’t either have criteria and they include WPPF, Eid bonuses and other bonuses as per head office’s discretion. The only difference between temporary and permanent employee is that the permanent employee is offered more chances of career advancement. Employees are retained through flexible organizational culture, annual dinners, equity in c&b, training and development…

    • 1432 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    This Is Great

    • 3046 Words
    • 13 Pages

    COMPENSATION & BENEFITS BASIC SALARY You will be eligible for a basic salary of `9,700/- per month. BOUQUET OF BENEFITS (BoB) Bouquet of Benefits offers you the flexibility to design this part of your compensation within the defined framework, twice in a financial year. All the components will be disbursed on a monthly basis. The components under Bouquet of Benefits are listed below. The amounts given here for each of the components below are as per pre-defined structure. However you may want to re-distribute the BoB amount between the components as per your tax plan, once you join TCSL. To design your Bouquet of Benefits,…

    • 3046 Words
    • 13 Pages
    Good Essays
  • Powerful Essays

    i) There are five employees- Mohan, Sohan, Raksha, Suraksha and Gautam with Basic Pay of Rs.12000, Rs.28000, Rs.18000, Rs.24000 and Rs.15000 respectively.…

    • 760 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    The rate of method of calculation of the employees remuneration and details as to what intervals the payment of remuneration will be made.…

    • 3466 Words
    • 14 Pages
    Good Essays
  • Powerful Essays

    Payroll System

    • 1603 Words
    • 7 Pages

    This Payroll System is also a flexible compensation administration solution. It is designed to help human resource professionals as well as finance and accounting personnel to manage employee compensation, deductions, allowances, and benefits in an organization. The system is integrated with the Employee’s information, offers efficient features and functionalities to manage company's expenses.…

    • 1603 Words
    • 7 Pages
    Powerful Essays