A company pays to its employees the salary on the basis of basic pay. The gross...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company pays to its employees the salary on the basis of basic pay. The gross salary of an employee consists of Dearness Pay (D.P.) and House Rent Allowance (H.R.A). Prepare a payroll statement by using the following instructions in spreadsheet software (e.g. MS Excel) 1. Use the following sample format for the preparation of payroll statement TITLE Emp ID Name of Employee Basic DA HRA Gross Total 2. Title of the payroll should include the following in two lines a. Company Name b. Payroll for July 2050 3. Assume Emp Id, names of the employees of 20 employees on your own 4. Assume basic salaries of the employees on your own such that there is at least one example of each category of HRA 5. DA is paid @ 10% of basic pay subject to a maximum of GH 5400/- 6. HRA is paid as per the following rules Basic salary HRA Up to 10,000 cedis 5,000 Between 10,001-25,000 cedis 7,000 More than 25,000 cedis 9,000 25 marks A company pays to its employees the salary on the basis of basic pay. The gross salary of an employee consists of Dearness Pay (D.P.) and House Rent Allowance (H.R.A). Prepare a payroll statement by using the following instructions in spreadsheet software (e.g. MS Excel) 1. Use the following sample format for the preparation of payroll statement TITLE Emp ID Name of Employee Basic DA HRA Gross Total 2. Title of the payroll should include the following in two lines a. Company Name b. Payroll for July 2050 3. Assume Emp Id, names of the employees of 20 employees on your own 4. Assume basic salaries of the employees on your own such that there is at least one example of each category of HRA 5. DA is paid @ 10% of basic pay subject to a maximum of GH 5400/- 6. HRA is paid as per the following rules Basic salary HRA Up to 10,000 cedis 5,000 Between 10,001-25,000 cedis 7,000 More than 25,000 cedis 9,000 25 marks
Expert Answer:
Answer rating: 100% (QA)
To compute the gross salary of an employee we need to calculate the Dearness Allowance DA and House ... View the full answer
Related Book For
College Accounting A Practical Approach
ISBN: 978-0132564441
11th Canadian Edition
Authors: Jeffrey Slater, Brian Zwicker
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Below are three independent and unrelated errors. a. On December 31, 2020, Wolfe-Bache Corporation failed to accrue salaries expense of $1,800. In January 2021, when it paid employees for the...
-
During the year, Financial Services Inc. purchased $1 million of 10-year bonds for $980,000 to earn interest. Financial Services reported interest revenue of $27,300 on its investment in the bonds in...
-
The 235U isotope undergoes fission when bombarded with neutrons. However, its natural abundance is only 0.72 percent. To separate it from the more abundant 238 U isotope, uranium is first converted...
-
Mrs. Palsgraf was waiting for a train on a platform of a railroad. When a different train came into the station, two men ran to get on that train before it left the station. While one of the men...
-
On March 20, Dodys petty cash fund of $100 is replenished when the fund contains $9 in cash and receipts for postage $52, freight-out $26, and travel expense $10. Give the journal entry to record the...
-
Scenario 17:Accountant 17 is the former manager of the audit dept. She says: when covid hit I decidedto retire. I was a cpa for 30 years but im no longer practicing, can I still call myself a cpa? Do...
-
Presented below are the factory overhead costs for Wagner Co. for the last six months of the year. Wagner Co. uses the high-low method. Month Overhead Cost Units July $24,450 8,200 August $20,120...
-
The Focus box "Can a Budget Deficit Reduction Lead to an Output Expansion? Ireland in the 1980s" provides an example of fiscal consolidation. Ireland had a large budget deficit in 1981 and 1982. a....
-
Refer to the previous problem. a. Draw a box plot using the information provided in the graph in that problem. b. Label three features of this box plot. Data from previous problem The following graph...
-
What is the payback period of the Chaotic Industries project from Activity 4.2?
-
The Stolen Valor Act of 2005 made it a federal crime for an individual to falsely claim they had received military decoration or honors. The penalty for false claims about the Congressional Medal of...
-
An investor is looking for arbitrage opportunities in the Treasury bond futures market. What complications are created by the fact that the party with a short position can choose to deliver any bond...
-
Linen Ltd commenced business operations on 1 July 2018 and sells electronic products with a two (2) year warranty that is effective from the date of sale. Linen Ltd's management accountant recently...
-
Evaluate the line integral, where C is the given curve. C x 2 dx + y 2 dy, C consists of the arc of the circle x 2 + y 2 = 4 from (2, 0) to (0, 2) followed by the line segment from (0, 2) to (4, 3)
-
Using the information provided on the partial worksheet for Jays Supplies of Sarnia shown on page 602, your task is to: a. Complete the worksheet. b. Prepare the income statement, statement of owners...
-
In March, Etta Stand forth opened a financial planning centre in down town Calgary. Please assist her by journalizing the following business transactions: 2012 The chart of accounts for the company...
-
Abby Jay is having a difficult time understanding the relationships among sales, cost of goods sold, gross profit, and net income for a merchandising company. As the accounting lab tutor, you have...
-
Repeat problem 41 for the new configuration with element 5 added, as shown in figure (b) Data From Problem 41: Use the finite element method to determine the nodal displacements in the plane truss...
-
Repeat problem 42 with an external force added to node 3, as shown in figure (c). Data From Problem 42: Repeat problem 41 for the new configuration with element 5 added, as shown in figure (b) Data...
-
The properties of the members of the truss in the left side of the figure are given in the table. Calculate the nodal displacement and element forces. Show that force equilibrium is satisfied as node...
Study smarter with the SolutionInn App