人力资源总监教你做薪酬--操作实务与设计技巧（实用案例版） 下载 网盘 kindle mobi 115盘 pdf pdb rtf

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

篇 薪资操作

章 读懂工资条的科目·························································································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

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

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：人力资源总监教你做薪酬--操作实务与设计技巧（实用案例版）在线阅读

在线听书地址：人力资源总监教你做薪酬--操作实务与设计技巧（实用案例版）在线收听

在线购买地址：人力资源总监教你做薪酬--操作实务与设计技巧（实用案例版）在线购买

暂无原文赏析，正在全力查找中！

编辑推荐

      精通薪酬管理 实现职场完美晋级本书可以帮你解决如下问题：·制作工资表的基本功·避免薪资拖延发放、计算出错·薪酬体系的建立与设计·避免执薪不公、做到同工同酬、·合理分配人力、激励员工·有依据的绩效调薪，做到公平的绩效评核·股权期权的实务操作·薪酬测算的技巧......实战派作者15年的工作总结，快速解决你的薪酬难题

前言

一、本书的源起

薪酬管理，在 HR 的工作中是一个比较特殊的模块，可大可小。

往小了说，就是做工资、发工资而已；往大了说，年终奖、绩效工资、提成、

年薪、股权激励等，不仅使HR 经理绞尽脑汁，而且公司高管、老板都要过问，甚

至头疼，有时不得不请咨询公司出手相助。薪资分配不均衡，导致员工流动量大，

或者公司上市以后高管为了早日实现套现纷纷辞职，影响公司经营业绩或股价波

动，已不鲜见。

公司规模小的时候，经营先于管理，人力资源管理也如此，包括薪资，简单

可操作是主要的做法。当公司规模扩大到几百甚至几千人的时候，就会出现公

平与否的问题。员工对外比薪资水平；对内比纵向职务层级、横向部门、职位之

间的差别，或者叫攀比。原先适用的简单模型，被迫打上各种补丁，或者要做薪

酬体系修订或重新设计。

每个公司，尤其是多元化的集团公司，部门多、复杂，子公司、事业部、一

级部门、分公司、大区等不一而足。大一统的薪酬体系开始不适用了，随之，分

类的薪酬方案设计就出现了。

以上各种情况，对负责薪资的HR 来说，薪酬体系的设计也就成了一项的

技能。职等职级表、薪资曲线、等差、级差、P25 等行业术语，背后的逻辑思路框

架，以及更多的Excel 技巧，就需要熟练掌握。

有些薪酬话题，属于老生常谈。对熟手来说，会者不难；对新手来说，却是

需要不断学习的过程，难者不会。

另外一些薪酬的话题却是新形势催生的，比如拟上市公司催生了薪酬“规范”，

2008 年新《中华人民共和国劳动合同法》的实施力度加大，催生了离职、加班、

年休假等的计算的政策依据和合法性的反复权衡，与外贸业务相关的体系审核等

频繁又琐碎，工作量大，催生了规避与整改的左右为难。

薪资与人事、绩效模块的关系交叉在一起，不分彼此，你中有我，我中有你。

2

人力资源总监教你做薪酬

不管是工作中的需求，还是HR 自身面临的职业规划，都需要熟练掌握薪酬的操作

与设计。

本书主要是指导在薪资、人事、绩效模块摸索的新手来掌握薪资操作过程与

设计的技巧，指导有3~5 年工作经验的熟手拓展领域，触类旁通，将薪酬的设计

作为一门手艺，学精学透，为自己的职业技能再增添一个筹码。

二、本书结构

本书共分为四篇，分别是篇（章~第四章）薪资操作，主要包括薪资

发放的过程、技巧以及薪资计算的依据，公司内部的薪酬制度、人事制度，外部

的劳动政策法规等。第二篇（第五章~第八章）薪酬体系设计，包括薪酬体系的建

立与修订、薪点制、职位分析与岗位评估。第三篇（第九章～第十八章）薪酬方

案设计，包括年薪制、计件工资、销售奖、项目奖、补贴项目设计、股权设计、

工资总额与业绩挂钩、企业年金设计等58 个真实案例。第四篇（第十九章~第二

十二章）薪酬高级专题。主要是拟上市公司的薪酬“规范”，32 个体系审核的薪酬

案例。

三、读者对象

本书适合从事薪资、人事、绩效模块的人力资源专员、主管学以致用，也可

供人力资源部经理、绩效主管、部门经理等参考，或对薪酬感兴趣的其他行业的

读者了解。

本书张巧兰参与并编写了第二、三章的内容，并对Excel 计算公式设置进行了

复核。

张明辉

2018 年3 月

杭州

书籍介绍

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