Blog

Small text message

Powered by Blogger.

About Me

My Photo
Jesus Ventura
View my complete profile

Followers

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

Math 4 Long Test1

Friday, June 24, 2011 - - 0 Comments

CP4 Quiz No. 1

Wednesday, June 22, 2011 - - 0 Comments


Use ARIAL Font.

CP3 Quiz 1

Monday, June 20, 2011 - - 4 Comments

CP3 Activity

Wednesday, June 15, 2011 - - 0 Comments