Activity 1. Pay Sheet Direction: Indicate the needed formula in solving for the specified cell by completing the statements below. Write your answers on your answer sheet. A B 14 EY EL PI COMPANY 02/14/2020 15 16 17 Name: Bianca U. Guevarra 18 Employee Number : 014344 19 Employment Status: Regular 20 21 GSIS Personal Share 22 PHILHEALTH 23 PAGIBIG Fund 24 BIR Withholding Tax 25 Total Deduction: 26 NET PAY: Pay Slip Month of February 2020 Basic Salary: P50,000.00 P1,500.00 Allowance: Gross Compensation: 1. DEDUCTIONS 9% 2. 1.50% 3. P100.00 to m P5,329.16 4. 5. 1. In F19, press_ then enter to solve for the gross compensation. 2. In press =E21*F17 or =E21*.09, then enter to solve for GSIS share 3. In F23, press_ 4. Press. 5. For net pay, press. to solve for. _to compute for the total deduction. Lon cell in cell

Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter13: Accounting For Payroll And Payroll Taxes
Section13.3: Reporting Withholding And Payroll Taxes
Problem 1WT
icon
Related questions
Question
100%

PLEASE ANSWER THEM ALL CORRECTLY FOR AN UPVOTE AND POSITIVE RATINGS.

 

Activity 1. Pay Sheet
Direction: Indicate the needed formula in solving for the specified cell by completing the
statements below. Write your answers on your answer sheet.
A
B
14
EY EL PI COMPANY
02/14/2020
15
16
17 Name: Bianca U. Guevarra
18 Employee Number : 014344
19 Employment Status: Regular
20
21 GSIS Personal Share
22 PHILHEALTH
23 PAGIBIG Fund
24 BIR Withholding Tax
25 Total Deduction:
26 NET PAY:
Pay Slip
Month of February 2020
Basic Salary:
P50,000.00
P1,500.00
Allowance:
Gross Compensation:
1.
DEDUCTIONS
9%
2.
1.50%
3.
P100.00
to m
P5,329.16
4.
5.
1. In F19, press_
then enter to solve for the gross compensation.
2. In press =E21*F17 or =E21*.09, then enter to solve for GSIS share
3. In F23, press_
4. Press.
5. For net pay, press.
to solve for.
_to compute for the total deduction.
Lon cell
in cell
Transcribed Image Text:Activity 1. Pay Sheet Direction: Indicate the needed formula in solving for the specified cell by completing the statements below. Write your answers on your answer sheet. A B 14 EY EL PI COMPANY 02/14/2020 15 16 17 Name: Bianca U. Guevarra 18 Employee Number : 014344 19 Employment Status: Regular 20 21 GSIS Personal Share 22 PHILHEALTH 23 PAGIBIG Fund 24 BIR Withholding Tax 25 Total Deduction: 26 NET PAY: Pay Slip Month of February 2020 Basic Salary: P50,000.00 P1,500.00 Allowance: Gross Compensation: 1. DEDUCTIONS 9% 2. 1.50% 3. P100.00 to m P5,329.16 4. 5. 1. In F19, press_ then enter to solve for the gross compensation. 2. In press =E21*F17 or =E21*.09, then enter to solve for GSIS share 3. In F23, press_ 4. Press. 5. For net pay, press. to solve for. _to compute for the total deduction. Lon cell in cell
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Bond Credit Rating
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
PAYROLL ACCT., 2019 ED.(LL)-TEXT
PAYROLL ACCT., 2019 ED.(LL)-TEXT
Accounting
ISBN:
9781337619783
Author:
BIEG
Publisher:
CENGAGE L
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
SWFT Comprehensive Vol 2020
SWFT Comprehensive Vol 2020
Accounting
ISBN:
9780357391723
Author:
Maloney
Publisher:
Cengage
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning