Latest piece rate scheduleTipsHow to make the latest piece rate schedule?
1. Direct piece rate wages. Piece-rate workers are paid based on the quantity of completed qualified products and the piece-rate unit price;
2. Indirect piece rate wages. Wages are calculated and paid based on the work performance of the piece-rate workers they serve or the work performance of the units they serve;
3. Limited piece rate. For workers who are paid on a piece-rate basis, it is stipulated that their excess wages shall not exceed a certain percentage of their standard total wages;
4. Unlimited piece rate wages. There is no limit on excess wages for workers who are paid on a piece-rate basis;
5. Progressive piece rate. The part where the worker completes the quota is calculated based on the same piece-rate unit price, and the part exceeding the quota is calculated based on the progressively increasing unit price;
6. Piece-rate bonus wages. Certain rewards will be given when product quantity or quality reaches a certain level;
7. Contract wages. Products with certain quality requirements, predetermined completion deadlines and salary amounts are contracted to individuals or groups, and wages are paid upon completion as required.
General Tips for the Latest Piece Rate Schedule
1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, sum the corresponding area of the C2:C5 cell.
Recommended by the editor of Huajun Software Park
The latest piece rate salary scheduleIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Compulsory carrier liability insurance coverage statistics table,Survey form on financial investment in education fundsDownload to get the source file, which you can edit, modify, and replace. To download the latest piece rate wage schedule, go to Huajun Software.
it works
it works
it works