各部門人均薪酬成本及實發(fā)工資對比分析

上傳人：加*** IP屬地：山東上傳時間：2024-04-19 格式：XLSX 頁數(shù)：17 大小：62.91KB 積分：50 舉報 版權(quán)申訴

已閱讀5頁，還剩12頁未讀，繼續(xù)免費閱讀

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進行舉報或認(rèn)領(lǐng)

文檔簡介

,,,,,,,,,,,,,,,,,,,,,,,,,,,,

員工薪酬數(shù)據(jù)明細(xì)表（含個稅自動計算）,,,,,,,,,,,,,,,,,,,,,,,,,,,

說明：此為（月度）薪酬數(shù)據(jù)明細(xì)表，包括薪酬成本項目明細(xì)（藍(lán)色部分）、需要扣款部分明細(xì)（紫色部分，包括考勤、社保公司部分、社保個人代繳、其他應(yīng)扣等）、個人所得稅（自動計算）以及最終的實發(fā)工資金額，本明細(xì)表適合一般中小企業(yè)，所列項目相對簡單實用易懂。提示：也可以直接填入各項目對應(yīng)數(shù)據(jù)，而不需要設(shè)置的公式。注：該明細(xì)表并非等同于工資表，其中社保、公積金公司部分的列出是為了方便進行薪酬成本的統(tǒng)計分析，實際工資發(fā)放的表格中，該金額一般不會體現(xiàn)。關(guān)于數(shù)據(jù)修改：1、一般不建議隨意增減工資欄中的項目數(shù)量，但是可以直接修改名稱，與此同時，其他分析表的對應(yīng)名稱也要隨之改變，否則會影響數(shù)據(jù)分析。2、如果增加名單（即增加行），可直接在表格下方添加數(shù)據(jù)，但需要為新增單元格設(shè)置函數(shù)公式；3、如果修改個人基本信息，包括增減部門、職級等，可以直接修改，但是注意其他統(tǒng)計分析表要同步進行調(diào)整，詳見各表格相關(guān)操作說明。,,,,,,,,,,,,,,,,,,,,,,,,,,,

序號,員工編號,姓名,性別,學(xué)歷,部門,職務(wù),職級,工資等級,基本工資,績效工資,固定補貼,加班費,獎金/提成,社保（公司部分）,公積金（公司部分）,其它補貼,薪酬成本合計,考勤扣款,社保（公司部分）扣款,社保（個人部分）代繳扣款,公積金（公司部分）扣款,公積金個人代繳扣款,其他應(yīng)扣,扣款后稅前應(yīng)發(fā),個人所得稅,稅后實發(fā)工資,備注

1,20160106,何小虎,男,本科,總經(jīng)辦,,高層,,"7,000.00","2,000.00","1,200.00",200.00,"3,000.00","1,100.00",600.00,300.00,"15,400.00",200.00,"1,100.00",300.00,600.00,600.00,100.00,"12,500.00","1,245.00","11,255.00",

2,20160107,黃小馬,男,本科,總經(jīng)辦,,高層,,"6,000.00","4,000.00","1,000.00",200.00,500.00,"1,100.00",600.00,300.00,"13,700.00",200.00,"1,100.00",300.00,600.00,600.00,101.00,"10,799.00",904.80,"9,894.20",

3,20160108,何大馬,女,大專,總經(jīng)辦,,中層,,"5,000.00","2,000.00","1,000.00",200.00,600.00,"1,100.00",600.00,100.00,"10,600.00",200.00,"1,100.00",300.00,600.00,600.00,102.00,"7,698.00",314.80,"7,383.20",

4,20160109,張三,男,本科,人資部,,中層,,"4,500.00","3,000.00",800.00,200.00,500.00,"1,100.00",600.00,300.00,"11,000.00",0.00,"1,100.00",300.00,600.00,600.00,103.00,"8,297.00",404.40,"7,892.60",

5,20160110,李四,女,大專,人資部,,基層,,"4,000.00","1,000.00",500.00,200.00,200.00,"1,100.00",300.00,100.00,"7,400.00",50.00,"1,100.00",300.00,300.00,300.00,104.00,"5,246.00",69.60,"5,176.40",

6,20160111,王五,男,本科,人資部,,基層,,"4,500.00","1,000.00",500.00,200.00,500.00,"1,100.00",300.00,300.00,"8,400.00",0.00,"1,100.00",300.00,300.00,300.00,300.00,"6,100.00",155.00,"5,945.00",

7,20160112,趙六,男,碩士,營銷部,,基層,,"4,000.00","1,000.00",500.00,200.00,500.00,"1,100.00",300.00,100.00,"7,700.00",0.00,"1,100.00",300.00,300.00,300.00,0.00,"5,700.00",115.00,"5,585.00",

8,20160113,圓圓1,男,本科,營銷部,,中層,,"5,500.00","2,000.00",500.00,200.00,500.00,"1,100.00",600.00,300.00,"10,700.00",200.00,"1,100.00",300.00,600.00,600.00,107.00,"7,793.00",324.30,"7,468.70",

9,20160114,黃小小,女,大專,營銷部,,中層,,"5,000.00","2,000.00",500.00,200.00,500.00,"1,100.00",600.00,300.00,"10,200.00",0.00,"1,100.00",300.00,600.00,600.00,500.00,"7,100.00",255.00,"6,845.00",

10,20160115,何大大,女,博士,營銷部,,基層,,"4,000.00","2,000.00",500.00,200.00,500.00,"1,100.00",300.00,300.00,"8,900.00",200.00,"1,100.00",300.00,300.00,300.00,109.00,"6,591.00",204.10,"6,386.90",

11,20160127,小魚兒,男,本科,營銷部,,基層,,"4,000.00","2,000.00",500.00,200.00,"4,000.00","1,100.00",300.00,100.00,"12,200.00",50.00,"1,100.00",300.00,300.00,300.00,300.00,"9,850.00",715.00,"9,135.00",

12,20160116,圓圓2,女,碩士,生產(chǎn)部,,一般人員,,"6,000.00","2,000.00",500.00,200.00,500.00,"1,100.00",300.00,300.00,"10,900.00",200.00,"1,100.00",300.00,300.00,300.00,110.00,"8,590.00",463.00,"8,127.00",

13,20160117,滿滿,男,本科,生產(chǎn)部,,基層,,"5,000.00","2,000.00",500.00,200.00,500.00,"1,100.00",300.00,300.00,"9,900.00",200.00,"1,100.00",300.00,300.00,300.00,0.00,"7,700.00",315.00,"7,385.00",

14,魚MRY001,美人魚S,女,大專,生產(chǎn)部,,基層,,"5,000.00","1,000.00",500.00,200.00,500.00,"1,100.00",300.00,300.00,"8,900.00",100.00,"1,100.00",300.00,300.00,300.00,101.00,"6,699.00",214.90,"6,484.10",

15,20160119,美人魚2,男,本科,生產(chǎn)部,,基層,,"5,000.00","1,000.00",500.00,200.00,"3,000.00","1,100.00",300.00,100.00,"11,200.00",200.00,"1,100.00",300.00,300.00,300.00,0.00,"9,000.00",545.00,"8,455.00",

16,20160120,美人魚3,女,本科,財務(wù)部,,基層,,"5,000.00","1,000.00",500.00,200.00,800.00,"1,100.00",300.00,500.00,"9,400.00",50.00,"1,100.00",300.00,300.00,300.00,103.00,"7,247.00",269.70,"6,977.30",

17,20160121,美人魚4,男,博士,財務(wù)部,,中層,,"6,000.00","2,000.00",500.00,200.00,600.00,"1,100.00",300.00,500.00,"11,200.00",200.00,"1,100.00",300.00,300.00,300.00,104.00,"8,896.00",524.20,"8,371.80",

18,20160122,美人魚,女,大專,財務(wù)部,,一般人員,,"4,000.00","1,000.00",500.00,200.00,500.00,"1,100.00",300.00,200.00,"7,800.00",200.00,"1,100.00",300.00,300.00,300.00,105.00,"5,495.00",94.50,"5,400.50",

19,20160123,美人魚6,男,中專,行政部,,一般人員,,"4,000.00","1,000.00",500.00,200.00,800.00,"1,100.00",300.00,400.00,"8,300.00",200.00,"1,100.00",300.00,300.00,300.00,106.00,"5,994.00",144.40,"5,849.60",

20,20160124,美人魚7,女,中專,行政部,,一般人員,,"4,000.00","1,000.00",500.00,200.00,800.00,"1,100.00",300.00,100.00,"8,000.00",200.00,"1,100.00",300.00,300.00,300.00,107.00,"5,693.00",114.30,"5,578.70",

21,20160125,美RY8,男,本科,營銷部,,一般人員,,"4,000.00","1,000.00",500.00,200.00,"1,200.00","1,100.00",300.00,200.00,"8,500.00",200.00,"1,100.00",300.00,300.00,300.00,50.00,"6,250.00",170.00,"6,080.00",

22,美RY2016,美人魚,男,本科,營銷部,,一般人員,,"4,000.00","1,000.00",500.00,200.00,500.00,"1,100.00",300.00,200.00,"7,800.00",100.00,"1,100.00",300.00,300.00,300.00,105.00,"5,595.00",104.50,"5,490.50",

,,,,,,,,,,,,,,,,,,,,,,,,,,,,

人人文庫> 全部分類> 應(yīng)用文書 > 辦公表格

溫馨提示

1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

各部門人均薪酬成本及實發(fā)工資對比分析

文檔簡介

溫馨提示

最新文檔

評論

各部門人均薪酬成本及實發(fā)工資對比分析

文檔簡介

溫馨提示

最新文檔

評論

相關(guān)文檔