Weekly Task: Simple Payroll
Sunday, June 26, 2011 - - 0 Comments
This is a payroll system. This will be your weekly task #1. Here are the details:
1. Civil Status Combo must contain: SINGLE, MARRIED, WIDOWED
2. Department Combo must contain: ADMIN, IT, FINANCE, MANAGEMENT
3. Employee Status combo must contain|: REGULAR, PROBATIONARY, CONTRACTUAL
4. Rate per hour details|: REGULAR: 350.25, PROBATIONARY: 199.75, CONTRACTUAL: 185.00
Formulas:
1. Gross Income: No. of days worked * (rate per hour * 8)
2. total deduction: sum of all deductions
3. netpay = gross-total deductions
Deductions:
1. SSS and Pag ibig
if |Gross is 1000 - 1999.99 = SSS: 150.00, Pag Ibig: 125.oo
if |Gross is 2000 - 2999.99 = SSS: 180.00, Pag Ibig: 155.00
if |Gross is 3000 - 3999.99 = SSS: 210.00, Pag Ibig: 185.00
if |Gross is 4000 - 4999.99 = SSS: 240.00, Pag Ibig: 215.00
if |Gross more than 5000.00 = SSS: 300.00, Pag Ibig: 250.00
2. Witholding tax:
if Single or Married with no dependents = tax = 20% of gross
if Single or Married with 1 dependent = tax = 10% of gross
if Married with 2 dependents = tax = 5% of gross
if Married with 3 dependents or more = tax = 2.5% of gross
if uniform loan is checked|: Uniform Loan = 500.00
This entry was posted on 5:27 PM
You can follow any responses to this entry through
the RSS 2.0 feed.
You can leave a response,
or trackback from your own site.
0 comments:
Post a Comment