Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assessment DIRECTIONS: Complete and create your own MS Excel Spreadsheet for the data given below. To submit take a picture or screenshot of your activity

image text in transcribed

Assessment 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. Do Additional Activities DIRECTIONS: Fill in the missing words. Write your answer in a separate sheet of paper. Most of the large companies would just buy a payroll program that they will use for their companies, However, this complicated payroll program is not really necessary for small businesses. Aside from its orhitant price, some of the other functions are not really important for personal or small business use. muter with a (2) Program Assessment 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. Do Additional Activities DIRECTIONS: Fill in the missing words. Write your answer in a separate sheet of paper. Most of the large companies would just buy a payroll program that they will use for their companies, However, this complicated payroll program is not really necessary for small businesses. Aside from its orhitant price, some of the other functions are not really important for personal or small business use. muter with a (2) Program

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

Step: 3

blur-text-image

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

Study Guide With Working Papers, Chapters 1-9 For Heintz/Parrys College Accounting

Authors: James A. Heintz, Robert W. Parry

21st Edition

1285059379, 9781285059372

More Books

Students also viewed these Accounting questions

Question

What are the pros and cons when 2 major restaurant chains merge?

Answered: 1 week ago