KEMBAR78
Lesson 7 Practice Exercises | PDF | Economies | Taxes
Scribd
Upload
17 views10 pages

Lesson 7 Practice Exercises

The document outlines payroll computation for employees at Elite Enterprises, detailing their monthly rates, days worked, overtime hours, and tax codes, along with calculations for gross pay, withholding tax, and net pay. It also includes product inventory information with unit prices and stock levels, as well as sales data showing invoices, salespersons, regions, products sold, and total sales amounts. The total sales across different regions sum up to 73,151.25.

Uploaded by

Reynalyn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
17 views10 pages

Lesson 7 Practice Exercises

The document outlines payroll computation for employees at Elite Enterprises, detailing their monthly rates, days worked, overtime hours, and tax codes, along with calculations for gross pay, withholding tax, and net pay. It also includes product inventory information with unit prices and stock levels, as well as sales data showing invoices, salespersons, regions, products sold, and total sales amounts. The total sales across different regions sum up to 73,151.25.

Uploaded by

Reynalyn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

📄 Worksheet 1: Payroll Computation

Elite Enterprises computes employee salaries based on their daily rate, number of days worked, and overtime hours. Taxe

Employee ID Name Monthly Rate Days Worked Overtime Hours Tax Code

1001 Santos, Maria 25,000.00 22 5Z


1002 Ramos, Leo 28,500.00 20 3 S/M
1003 Dela Cruz, Ana 30,000.00 23 0 ME/S1
1004 Torres, John 20,000.00 21 2Z
1005 Lopez, Carlo 27,000.00 19 4 S/M
s worked, and overtime hours. Taxes are withheld based on the employee’s tax code.

Daily Rate Gross Pay Witholding Tax Net Pay

1,136.36 25,750.00 - 25,750.00


1,295.45 26,359.09 2,635.91 23,723.18
1,363.64 31,363.64 1,568.18 29,795.45
909.09 19,390.91 - 19,390.91
1,227.27 23,918.18 2,391.82 21,526.36
.
Product Inventory
Product ID Product Name Unit Price Stock

P100 Bond Paper A4 120.50 250 Enter Product ID


P101 Stapler Heavy Duty 215.75 80 Product Name
P102 Ballpen Black 15.00 1200 Unit Price
P103 Envelopes (pack) 75.00 500 Stock
P104 Folder Long 20.00 450 Total Inventory Value
P102
Ballpen Black
15.00
1,200.00
18,000.00
Sales Data Table
Invoice No Salesperson Region Product Units Sold Unit Price Status Total Sales

INV001 Maria North Bond Paper 50 120.50 Completed 6,025.00


INV002 John South Ballpen 300 15.00 Completed 4,500.00
INV003 Ana East Envelopes 100 75.00 Pending 7,500.00
INV004 Leo North Stapler 20 215.75 Completed 4,315.00
INV005 Carlo South Folder 150 20.00 Completed 3,000.00
INV006 Maria North Ballpen 200 15.00 Completed 3,000.00
INV007 Ana East Folder 120 20.00 Pending 2,400.00
INV008 John West Bond Paper 75 120.50 Completed 9,037.50
INV009 Carlo West Envelopes 80 75.00 Completed 6,000.00
INV010 Maria South Stapler 10 215.75 Completed 2,157.50
INV011 Leo North Ballpen 400 15.00 Completed 6,000.00
INV012 Ana East Bond Paper 60 120.50 Completed 7,230.00
INV013 Carlo South Envelopes 90 75.00 Completed 6,750.00
INV014 John West Stapler 15 215.75 Pending 3,236.25
INV015 Maria North Folder 100 20.00 Completed 2,000.00
1.00
Total Sales
Region
Amount
North 21,340.00
South 16,407.50
East 17,130.00
West 18,273.75
Total 73,151.25

9000
12
Customer Name
globe telecom inc.
JOLLIBEE FOODS CORPORATION
Ayala corp
meralco
SUN LIFE FINANCIAL

You might also like