Homework Help is Here – Start Your Trial Now!
Math
Advanced Math
WRITTEN WORK # 15 Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Bi- Monthly Salary Name Annual Semi- Salary Monthly weekly Marites P11,538 dut P20,000 Janice Lyn P5,000 Leo P40,000 Flor P96,000 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) F G INCOME DEDUCTIONS SSS PHILHEALTH PAGIBIG TAX Total Basic Monthly Salary Name Deductions 4% 1.50% 2% 12% 3 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Nicdao, Maine 9 Mendoza, Rhoda 0 Mallari, Tes 1 Santos, Paula 2 Urbano, Janeen P20,000.00 P25,000.00 P30,000.00 P40,000.00 P45,000.00 P50,000.00 P55,000.00 P60,000.00 P65,000.00

WRITTEN WORK # 15 Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Bi- Monthly Salary Name Annual Semi- Salary Monthly weekly Marites P11,538 dut P20,000 Janice Lyn P5,000 Leo P40,000 Flor P96,000 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) F G INCOME DEDUCTIONS SSS PHILHEALTH PAGIBIG TAX Total Basic Monthly Salary Name Deductions 4% 1.50% 2% 12% 3 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Nicdao, Maine 9 Mendoza, Rhoda 0 Mallari, Tes 1 Santos, Paula 2 Urbano, Janeen P20,000.00 P25,000.00 P30,000.00 P40,000.00 P45,000.00 P50,000.00 P55,000.00 P60,000.00 P65,000.00

Advanced Engineering Mathematics
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
See similar textbooks
icon
Related questions
Question
100%

PLEASE HELP ME A.S.A.P. FOR AN UPVOTE AND POSITIVE RATINGS

 

WRITTEN WORK # 15 u mco sp he Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Semi- Bi- Monthly Salary Name Annual Salary Monthly weekly Marites P11,538 P20,000 Janice Lyn P5,000 Leo P40,000 shoil Flor P96,000 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) E F H. A INCOME DEDUCTIONS Name Basic Monthly SSS PHILHEALTH PAGIBIG TAX Total Deductions Salary 4% 1.50% 2% 12% 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Niedao, Maine 9 Mendoza, Rhoda 0 Mallari, Tes 1 Santos, Paula 2 Urbano, Janeen P20,000.00 P25,000.00 P30,000.00 P40,000.00 P45,000.00 P50,000.00 P55,000.00 P60,000.00 P65,000.00 23
Transcribed Image Text:WRITTEN WORK # 15 u mco sp he Activity 1. Spread my Salary Direction: The data below shows the partial salary of employees. Complete the table to showtheir annual, monthly, semi/weekly and bi-weekly salary. Use excel. (Show the formula) Weekly Salary Semi- Bi- Monthly Salary Name Annual Salary Monthly weekly Marites P11,538 P20,000 Janice Lyn P5,000 Leo P40,000 shoil Flor P96,000 Activity 2. Spread my Salary Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) E F H. A INCOME DEDUCTIONS Name Basic Monthly SSS PHILHEALTH PAGIBIG TAX Total Deductions Salary 4% 1.50% 2% 12% 4 Magpayo, Lyn 5 Quiambao, Jhaz 6 Cruz, Russel 7 Garcia, Geth 8 Niedao, Maine 9 Mendoza, Rhoda 0 Mallari, Tes 1 Santos, Paula 2 Urbano, Janeen P20,000.00 P25,000.00 P30,000.00 P40,000.00 P45,000.00 P50,000.00 P55,000.00 P60,000.00 P65,000.00 23
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,
SEE MORE TEXTBOOKS