员工计件工资表.xlsx

序号姓名员工工号基本工资产品（工序）类别奖罚金额代扣社保税前应发个税扣除实发工资备注产品（工序）价格设置A产品B产品C产品D产品E产品F产品计件工资1稻小壳YG-100110001094981341362820800302003020A产品2.78元/件B产品4.23元/件2稻小壳1YG-100215004802801165005893.042008006793.0453.796739.25C产品3.50元/件D产品1.50元/件3稻小壳2YG-10031000275544491922813505665.168005865.1625.955839.21E产品1.54元/件F产品6.80元/件4稻小壳3YG-10045003062847006604.688006304.6839.146265.545稻小壳4YG-10058002831453723454304.09-1008004204.0904204.09数据查询6稻小壳5YG-10061000913643541352285006985.328007185.3265.567119.76员工姓名稻小壳5员工工号YG-10067稻小壳6YG-10071500121118363491923468.128004168.1204168.12基本工资1000奖罚金额08稻小壳7YG-10081000834802472611264373.94-508004523.9404523.94代扣社保800税前应发7185.329稻小壳8YG-100950070850414400505367.18005067.12.015065.09个税扣除65.56实发工资7119.7610稻小壳9YG-10108001554422162262963.348002963.3402963.34备注11稻小壳10YG-101110003118003052075541.885008006241.8837.266204.6212稻小壳11YG-10121500381622391512634178.888004878.8804878.88产品数据13稻小壳12YG-10131000468420398574473007284.528007484.5274.547409.98产品名称产品数量金额备注0000A产品91252.980000B产品3641539.720000C产品35412390000D产品135202.50000E产品228351.120000F产品500340000000000