问题描述
先生您好，
我被问到一个计算员工薪水的问题，其中在表中定义了字母A-E标识的几个级别的员工及其薪资水平
成绩NormalHours BasicPayPerHour加班
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
员工还与以下部门之一相关
DeptCode部门名称
M Marketing
S销售
R Research
您将要计算:
1.每个部门的总净工资
2.整个公司的总净工资
3.支付给整个公司的总税金.
另外，您还需要生成一个可运行的C#程序，以生成具有以下布局的工资报告:
部门:市场营销
身份证姓氏姓名小时毛薪税净薪金
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
--------
总计:行销xxxxx.xx
部门:销售部
身份证姓氏姓名小时毛薪税净薪金
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
--------
总计:销售xxxxx.xx
部门:研究部
身份证姓氏姓名小时毛薪税净薪金
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
--------
总计:研究xxxxx.xx
-------------------------------------------------- -------------------------
整个公司总计:
总净工资= xxxxxxx.xx
应纳税总额= xxxxxxx.xx
到目前为止，我已经能够计算出
营销部门的净工资总额也仅
支付给营销部门的总税金
我的问题是，如何计算其他部门的销售和研究总净工资和tex
最后是3个部门的总净工资和3个部门的总税金
谢谢.
感谢
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
推荐答案
这篇关于工资系统-Plz帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！