# ITE 009 Excel Activities

Document Sample

```					                                                                 PAYROLL REPORT
Name              Rate/hour       Hours worked       Gross pay    ITW       SSS
Belicano, Ricky                  115.50             558        64449.00   4511.43     750
Cruz, Steve                      116.00             445        51620.00   3613.40     750
Lagman, Ronnie                   100.50             885        88942.50   6225.98     750
Mayari, Carol                    105.50             788        83134.00   5819.38     750
Orly, Steve                      113.50             455        51642.50   3614.98     750

Total                                                      3131       339788.00

ITW = Gross Pay * 7%
Net Pay = Gross Pay - Total Deductions
Total Deductions    Net Pay
5261.43    59187.57
4363.40    47256.60
6975.98    81966.53
6569.38    76564.62
4364.98    47277.53

27535.16   312252.84
Instructions:
1. Copy and do the layout as shown.
2. Compute for the following:
Gross Pay = Rate/Hour * Hours Worked
ITW = Gross Pay * 7%
Others = Gross Pay * 2%
Total deductions = ITW + SSS + Others
Net Pay = Gross Pay - Total Deductions
3. Rename the Sheet as Activity 8
4. Save the workbook.

TAMBIS-GARANGAN COMPUTER INSTITUTE
PAYROLL REPORT - SEPTEMBER 2010

Employee Number       Family Name        First Name   Rate/Hour    Hours Worked    Gross Pay   ITW   SSS
JS-010                Lagman             Ronnie             100.50             160                         750.00
JS-020                Mayari             Carol              105.50             145                         750.00
JS-030                Belicano           Ricky              110.50             155                         750.00
JS-040                orly               Steve              115.50             149                         750.00
JS-050                Tolentino          Richard            120.50             152                         750.00
JS-060                Manuel             Jenny              110.25             163                         750.00
JS-070                Cruz               Jenny              113.75             160                         750.00
JS-080                Domingo            Alvin              117.25             155                         750.00
JS-090                Priest             Neil               120.75             150                         750.00
JS-100                Laurel             Cecille            124.25             151                         750.00
JS-110                De Mesa            Reizelle           135.50             145                         750.00
JS-120                Bathan             Nhick              132.75             150                         750.00
JS-130                Balingit           Archie             130.00             155                         750.00
JS-140                Suarez             Dinah              127.25             145                         750.00
JS-150                Vega               Abelle             124.50             155                         750.00
Others   Total Deductions   Net Pay

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 5 posted: 2/23/2012 language: English pages: 4