View Single Post
 
Old May 15th, 2006, 03:15 AM
damanka2001 damanka2001 is offline
Registered User
 
Join Date: May 2006
Location: accra, ghana, Ghana.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to prepare a payroll using Access

Am trying to use Access to prepare a payroll as an assignment but the problem is I dont no the commands to use or how to do it.
This is how the calculation of TAX is to be done in the payroll;

CHARGEABLE RATE TAX CUMULATIVE CUMULATIVE
INCOME(MONTHLY) CHARGEABLE INCOME TAX
1.FIRST ¢200,000 FREE NIL ¢200,000 NIL
2.NEXT ¢200,000 5% ¢10,000 ¢400,000 ¢10,000
3.NEXT ¢1,000,000 10% ¢100,000 ¢1,400,000 ¢110,000
4.NEXT ¢6,600,000 17.5% ¢1,155,000 ¢8,000,000 ¢1,265,000
EXCEEDING ¢8,000,000 @25%

TAX COMPUTATION

TAX= 0.0 + 0.5 X (INCOME - 200,000)
TAX= 10,000 + 0.10 X (INCOME - 400,000)
TAX= 110,000 + 0.175 X (INCOME - 1,400,000)
TAX= 1,265,000 + 0.25 X (INCOME - 8,000,000)

CAN SOMEONE PLEASE HELP ME WITH IT?
THE FUNCTIONS AND EXPRESSIONS TO USE FOR SUCH A PROJECT.
THANK YOU




   Topic