人力资源总监教你做薪酬--操作实务与设计技巧（实用案例版）

图书标准信息

• 作者 张明辉
• 出版社 中国铁道出版社
• 出版时间 2018-05
• 版次 1
• ISBN 9787113243876
• 定价 59.80元
• 装帧 其他
• 开本 16开
• 纸张 胶版纸
• 页数 368页
• 字数 477千字

【内容简介】

人力资源总监教你做薪酬是一本薪酬实务工具书，由资深HRD 手把手教你做薪酬的操作与设计。全书共22 章，首先介绍了薪资操作的过程，从工资条的科目讲起，为薪酬专员介绍了制作工资需要掌握的技能、工资发放过程中的疑难问题以及如何处理调薪等内容，涉及很多实用的Excel 计算公式；然后介绍了薪酬体系设计，为薪酬主管介绍了薪点制的设计过程、职位分析与岗位评估的操作过程；*后介绍分类薪酬方案的设计与操作案例，包括：年薪制、奖金提成制、计件制、项目奖金制、项目补贴、股权期权、工资总额与业绩挂构、企业年金、职能部门绩效工资、薪酬调查、互联网公司薪等薪级表以及互联网公司股权案例等内容。全书架构合理，逻辑性强，讲解通俗易懂，以表析文，案例丰富，注重案例原创性、与时俱进，行文可读性强。本书可作为薪酬专员、薪酬主管、HR、企业高管、MBA、本科生等的参考用书。

【作者简介】

       绩效管理专家，现任杭州考典信息科技有限公司总经理。毕业于浙江大学心理系、管理学院，管理学硕士。已出版《资深人力资源总监教你做薪酬》、《人力资源管理从入门到精通》等图书7本。曾任职于中国网通、柳桥集团、南都电源、哲达科技等大中型企业、上市公司，历任薪酬与绩效主管、人力资源部经理、人力资源总监。曾获杭州市首届优秀HR经理奖、浙江省首届双十佳HR经理奖、第四届中国人力资源管理大奖成果奖银奖。曾为中国电信、中国联通、中国网通、浙能集团、上海建工、深圳燃气、塔里木油田、华立集团、中粮包装、重庆市国资委、宁夏回族自治区国资委等单位提供过培训，为浙江、上海、贵州、湖北等地企业及园区提供过咨询服务。在《企业管理》《中国高新区》等杂志发表文章20余篇；接受过《都市快报》《中国产经新闻》、新浪微博等访谈。

【目录】

第一篇 薪资操作

第一章 读懂工资条的科目·························································································1

1.1 一级科目和二级科目····································································································2

1.2 二级工资科目的计算····································································································2

1.2.1 基本工资的计算·································································································3

1.2.2 代扣代缴的计算·································································································4

1.3 税后工资、人工成本····································································································6

1.4 月收入、年收入的计算口径························································································7

1.5 工资条涉及的《中华人民共和国劳动合同法》提示···············································7

第二章做工资的基本功·····························································································9

2.1 设计一套Excel月工资表···························································································10

2.2 设置Excel计算公式···································································································12

2.3 录入数据·······················································································································14

2.4 检查数据·······················································································································15

2.5 审核、审批···················································································································15

2.5.1 HR经理审核的内容························································································15

2.5.2 领导审批···········································································································16

2.5.3 后续发放：财务和银行··················································································16

2.6 薪酬专员须知···············································································································16

2.6.1 个人所得税的计算···························································································16

2.6.2 经济补偿金的个人所得税计算······································································17

2.6.3 社会保险、住房公积金代扣代缴的计算······················································19

2.6.4 年终奖的合理避税···························································································21

2.6.5 薪资计算的依据·······························································································23

2.6.6 最低工资标准···································································································24

2.6.7 工时的规定·······································································································24

2.6.8 加班工资的计算·······························································································25

2.6.9 员工离职经济补偿金、赔偿金的计算··························································26

人力资源总监教你做薪酬

2.7 劳动年报申报···············································································································27

2.8 人工成本统计···············································································································29

2.9 Excel特殊函数举例····································································································30

2.9.1 IF函数的运用及技巧······················································································30

2.9.2 多重IF条件函数的运用及技巧·····································································32

2.9.3 SUMIF条件函数的运用及技巧·····································································36