|
|
|
<p>每个人进公司的时间不一样,因此年休假也不一样,所以建议楼主按3楼建议的方式去计算还方便些;你可以先按1月实际上班的时间算工资,即没有上班就不算工资,有上班就算工资,法定节假日有上班就算三倍加班费,然后再加上每个人实际应得到的年休假工资即可,以下格式供参考!</p><p><table style="WIDTH: 405pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=543 border=0 x:str><colgroup><col style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1133" span=3 width=31><col style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1206" span=2 width=33><col style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1133" span=7 width=31><col style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1133" span=2 width=31><col style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1206" span=2 width=33><col style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1426" width=39><tbody><tr style="HEIGHT: 12.75pt" height=17><td class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 36.75pt; BACKGROUND-COLOR: transparent" width=31 height=49 rowSpan=2><font face=宋体 size=2>姓名</font></td><td class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=宋体 size=2>部门</font></td><td class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=宋体 size=2>基本底薪</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 25pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=33 rowSpan=2><font face=Arial size=2>基本<br />小时</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 25pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=33 rowSpan=2><font face=Arial size=2>基本<br />工资</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=Arial size=2>1.5×<br />工时</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=Arial size=2>1.5×<br />工资</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=Arial size=2>2.0×<br />工时</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=Arial size=2>2.0×<br />工资</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=Arial size=2>3.0×<br />工时</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=Arial size=2>3.0×<br />工资</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31 rowSpan=2><font face=Arial size=2>效益<br />工资</font></td><td class=xl19 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=62 colSpan=2><font face=Arial size=2>其他</font></td><td class=xl19 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=66 colSpan=2><font face=Arial size=2>代收费用</font></td><td class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 29pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=39 rowSpan=2><font face=Arial size=2>工资合计</font></td></tr><tr style="HEIGHT: 24pt" height=32><td class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" width=31 height=32><font face=宋体 size=2>年假工资</font></td><td class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=31><font face=宋体 size=2>年终奖金</font></td><td class=xl19 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><font face=Arial size=2>保险</font></td><td class=xl20 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><font face=宋体 size=2>伙食</font></td></tr><tr style="HEIGHT: 12.75pt" height=17><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: yellow" height=17><font face=Arial size=2> </font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow"><font face=Arial size=2> </font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>770</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>88</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>471</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow"><font face=Arial size=2> </font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow"><font face=Arial size=2> </font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>24</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>257</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow"><font face=Arial size=2> </font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow"><font face=Arial size=2> </font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>35</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>214</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>500</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>80</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>100</font></td><td class=xl21 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:num><font face=Arial size=2>1297</font></td></tr></tbody></table></p> |
|
|小黑屋|手机版|Archiver|企业社会责任论坛
( 粤ICP备07511431 ) 
发表于 2009-2-26 14:59:28
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
微信
收藏
淘帖
支持
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
IP卡
狗仔卡
发表于 2009-2-26 16:31:23
楼主