人工成本全年统计分析excel模版

人工成本全年统计分析

March 21, 2020

1月2月3月4月5月6月上半年合计直接人工$10,000$11,000$13,000$15,000$17,000$18,000$84,000附加福利3,0003,3004,0006,0007,0008,000$31,300总计人工成本$13,000$14,300$17,000$21,000$24,000$26,000$115,300标准人工$12,000$14,700$16,500$22,000$25,500$24,400$115,100偏差($1,000)$400($500)$1,000$1,500($1,600)($200)偏差率 %-8.3% 2.7%-3.0% 4.5% 5.9%-6.6%-0.2%

7月8月9月10月11月12月全年累计直接人工$10,000$11,000$13,000$14,000$14,000$14,000$160,000附加福利3,0003,3004,0004,4005,4006,40057,800

总计人工成本$13,000$14,300$17,000$18,400$19,400$20,400$217,800标准人工$12,000$14,700$16,500$17,500$16,500$14,500$206,800偏差($1,000)$400($500)($900)($2,900)($5,900)($11,000)偏差率 %-8.3% 2.7%-3.0%-5.1%-17.6%-40.7%-5.3%