Question
DIRECTIONS: Complete and create your own MS Excel Spreadsheet for the data given below. To submit take a picture or screenshot of your activity and
DIRECTIONS: Complete and create your own MS Excel Spreadsheet for the data given below. To submit take a picture or screenshot of your activity and send it to your subject teacher.
1. Corona V. Sama worked for 13 days, 15 hours of overtime with a regular rate of Php550.00.
2. Quira N. Tino worked for 12 days, 20 hours overtime with a daily rate of Php525.00.
3. Cobe S. Alot worked for 13 days, 26 hours of overtime with a daily rate of Php 475.00.
4. Sonny T. Aizer worked for 13 days, 30 hours overtime with a daily rate of Php 475.00.
5. Locke D. Dawn worked for 11 days, 33 hours of overtime with a daily rate of Php550.00.
YOUR TASK: Complete the payroll assuming that they all have an SSS deduction of Php375.00, Pag-ibig of Php100.00 and Philheath of Php200.00.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started