2. Enter the formula used to calculate the floating amount in cell C2: = A2 * B2;; ;
3. Click OK to generate data, and then click the drop-down list to fill in the copy formula to generate a batch of floating amount data;
4. Then calculate the floating salary and enter the calculation formula: = A2+C2;
5. Click Enter to generate data, and then click Copy Formula to calculate the floating salary of employees in batch.
First, the so-called wage level refers to the average wage paid by enterprises to different positions. The salary level focuses on the analysis of the salary relationship between organizations, that is, the overall salary payment strength of organizations relative to competitors. The salary paid by the organization will undoubtedly directly affect the ability of enterprises to obtain labor in the labor market, and then affect the competitiveness of enterprises. The so-called external competitiveness of salary actually refers to the salary level of enterprises and the resulting competitiveness of enterprises in the labor market.
Second, the salary level refers to the salary relationship between organizations. The salary level of an organization relative to its competitors reflects the external competitiveness of enterprise salary. Salary level reflects the absolute value of enterprise salary relative to local market salary and competitor salary. It directly affects the attractiveness of employees and the salary competitiveness of enterprises. Its mathematical formula is: wage level = total wages/number of employees in the industry.
Three, the salary card is the original record of salary grade and salary standard. The labor and personnel department should establish a salary card for each employee who enters the factory. Its contents mainly include: employee's name, position (title or type of work), salary grade, salary standard, work department, date of joining the work, date of transferring from the work, etc. The salary card is established from the employee entering the factory to the employee's transfer or retirement. The finance department will issue or stop paying employees' salaries according to the salary card.
Fourth, wages are the wages of employees. It is the salary that employees get in a fixed working relationship, and there are time rules for payment. Refers to the labor remuneration paid by the employer or legal employer to the laborer in the form of money according to laws, industry regulations or agreements with the laborer. It is a major form of labor remuneration. The first component is employees, the second is that the payment is limited, and the third is that wages are generally in the form of money.