Payroll system - Plz help

See more:

C#3.0

C#

Hello sir,

I'm given a question to calculate employee salaries, where several grades of employee identified by the letters A-E and their pay rates are defined in a table

Grade NormalHours BasicPayPerHour Overtime
A XX X.XX X.XX
B XX X.XX X.XX
C XX X.XX X.XX
D XX X.XX X.XX
E XX X.XX X.XX

Employees are also associated with one of the following departments

DeptCode Dept Name
M Marketing
S Sales
R Research

You are to calculate:
1. total net pay for each department
2. total net pay for the whole company
3. total tax paid for the whole company.


Also u're required to produce a working C# program to produce a payroll report with the layout below:

Department: Marketing
ID Surname Forename Grade Hrs Gross Pay Tax Net Pay
0001 Crun Henry B 50 179.38 19.91 159.47
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
--------
Total for: Marketing xxxxx.xx

Department: Sales
ID Surname Forename Grade Hrs Gross Pay Tax Net Pay
0001 Crun Henry B 50 179.38 19.91 159.47
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
--------
Total for: Sales xxxxx.xx

Department: Research
ID Surname Forename Grade Hrs Gross Pay Tax Net Pay
0001 Crun Henry B 50 179.38 19.91 159.47
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
xxxx xxxxx xxxxxxx x xx xxx.xx xxx.xx xxx.xx
--------
Total for: Research xxxxx.xx
---------------------------------------------------------------------------
Totals for whole company:
Total Net Pay = xxxxxxx.xx
Total Tax Payable = xxxxxxx.xx


So far, I'v been able to calculate the
total net pay for marketing department only and also
total tax paid for marketing department

My question, how do I calculate for other departments sales and research total net pay and tex
and finally total net pay of the 3 department and total tax paid by the 3 department
thanks.

Thanks