Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Sixth International Congress On Accounting 1952

Authors: Various

1st Edition

0367512807, 9780367512804

More Books

Students also viewed these Accounting questions

Question

what is Leveling used for in project management ___

Answered: 1 week ago

Question

How do you add two harmonic motions having different frequencies?

Answered: 1 week ago

Question

2 What participation techniques are used?

Answered: 1 week ago