Answered step by step
Verified Expert Solution
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
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
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