員工超產獎金計算表,,,,,,,,,,,

,,,,,,,,,,日期：,

姓名,工序,等級,基準產能（H/刮）,標準工時（時）,標準刮數（刮/日）,月出勤標準（天）,"單刮

系數

（元）","生產

數量","生產

用時","超產

金額","超產

總金額"

張三,頭色/IR/CD紋理,a,280,10,2800,28,0.08,3000,10.0,16.00,

,,b,330,10,3300,28,0.085,,,,

,,c,380,10,3800,28,0.09,,,,

,蓋底,a,280,10,3000,28,0.07,2600,8.0,25.20,

,,b,350,10,3500,28,0.072,,,,

,,c,400,10,4000,28,0.074,,,,

,代碼,a,290,10,3500,28,0.062,2700,9.0,5.58,

,,b,360,10,4000,28,0.064,,,,

,,c,420,10,4500,28,0.066,,,,

李四,頭色/IR/CD紋理,a,280,10,2800,28,0.08,3600,10.0,68.00,

,,b,330,10,3300,28,0.085,9831/3,3.3,,

,,c,380,10,3800,28,0.09,9662/3,3.3,,

,蓋底,a,280,10,3000,28,0.07,1600,3.0,56.24,

,,b,350,10,3500,28,0.072,9331/3,3.3,,

,,c,400,10,4000,28,0.074,9162/3,3.3,,

,代碼,a,290,10,3500,28,0.062,3900,9.0,85.14,

,,b,360,10,4000,28,0.064,,,,

,,c,420,10,4500,28,0.066,,,,

王五,頭色/IR/CD紋理,a,280,10,2800,28,0.08,4200,10.0,126.00,

,,b,330,10,3300,28,0.085,8662/3,3.3,,

,,c,380,10,3800,28,0.09,850,3.3,,

,蓋底,a,280,10,3000,28,0.07,800,2.0,17.76,

,,b,350,10,3500,28,0.072,8162/3,3.3,,

,,c,400,10,4000,28,0.074,800,3.3,,

,代碼,a,290,10,3500,28,0.062,3200,10.0,18.60,

,,b,360,10,4000,28,0.064,,,,

,,c,420,10,4500,28,0.066,,,,

唐彬,頭色/IR/CD紋理,a,280,10,2800,28,0.08,2600,8.0,28.80,

,,b,330,10,3300,28,0.085,750,3.3,,

,,c,380,10,3800,28,0.09,7331/3,3.3,,

,蓋底,a,280,10,3000,28,0.07,1600,4.0,35.52,

,,b,350,10,3500,28,0.072,700,3.3,,

,,c,400,10,4000,28,0.074,6831/3,3.3,,

,代碼,a,290,10,3500,28,0.062,460