Purchasing salary needs to be accounted for in two parts:
A. Field assistance:
is "I. Purchasing sales commission" in the table of the total commission calculated
B. Performance pay - the month actually paid (consisting of 1 + 2)
1. Calculated by me these three "II. Reduce procurement costs accounted for 20% of the performance appraisal. ;Three. Payment cycle assessment accounted for 20% of the total performance appraisal income, the assessment base on the basis of the previous year's payment cycle. ;iv. Inventory turnover 20%"
2, Purchasing Manager Wang provided 40% performance appraisal schedule
A. Calculation instructions
A. Purchasing and sales commission
1, each month, Purchasing Wang Juan provides "procurement transfer table", received the table, totaled out each person. After receiving the table, total out each person's "total sales, total gross profit";
2, in the "September 2014 Purchasing Department performance appraisal data" table, enter each person's "amount, total gross profit ", based on the formula, automatically calculated for each person's "gross profit commission, sales commission, commission subtotal, employee commission, manager commission, commission to be allocated total". Which "to be allocated commission total" formula has been calculated an amount, send this table to the purchasing manager, the need for purchasing manager to allocate this total amount to the employees, after which, calculate each person's "commission total", employee commission total = employee commission + to be allocated commission; manager's commission = employee commission + to be allocated commission; manager's commission = employee commission + to be allocated commission; manager's commission = employee commission + to be allocated commission; employee commission = employee commission + to be allocated commission; manager's commission = to be allocated commission Distribution of commission; manager commission = employee commission + manager commission + commission to be distributed.
3, this table will be calculated in the "commission total", pasted to the "Purchasing payroll filing" table in the "field assistance" column, the table password is 820621
B calculation instructions
Second, reduce procurement costs accounted for 20% of the performance appraisal.
1, in the UFIDA - General Ledger system - Balance Sheet - month selection "2014-1 to 2014-9", "including unrecorded vouchers" check box, OK;
2, Cost rate = main operating costs / main operating income (are the cumulative amount of January-September), calculated after the cost rate, against the "decomposition table, the second item", to see which cost rate belongs to the interval, to determine its percentage, with the full 20% * this percentage = this commission;
Third, the payment cycle assessment of total Payment cycle assessment of 20% of the total performance appraisal income, the assessment base on the basis of last year's payment cycle.
1, in UFIDA - General Ledger System - Balance Sheet - month selection "2014-1 to 2014-9", "including unrecorded vouchers" tick, OK;
2, Accounts payable turnover = cost of doing business (January to September cumulative incurred) / (accounts payable opening balance + accounts payable closing balance) /2
3, accounts payable turnover days = (30 * month) / accounts payable turnover rate
4, accounts payable turnover days compared with the data in 2013, calculated accounts payable payable payback cycle extension rate, against the "Breakdown table item 3", see which interval this belongs to, determine its percentage, with the full 20% * this percentage = this commission;
4, inventory turnover 20%
1, in UFIDA - General Ledger System - Balance Sheet - Month Selection "2014-1 to 2014-9", "including unrecorded vouchers" check box, OK;
2, inventory turnover = cost of doing business (cumulative incurred from January to September) / (opening balance of inventory + closing balance of inventory ) /2;
3, inventory turnover days = (30 * month) / inventory turnover rate
4, inventory turnover days compared with the data in 2013, calculate the inventory turnover days to shorten the rate, against the "decomposition
1
Table IV". Look at this belongs to which interval, determine its percentage, with the full 20% * this percentage = this commission; Summary
1, the above "two, three, four" calculated percentage + 40% of the data provided by the purchasing manager, one by one and each of the percentage of each person scoring, the resulting data for the "Performance Completion Percentage". "Percentage of performance completion", using the "2014 performance statistics table" in the fixed data "performance pay" * "percentage of performance completion "= need to fill in the" procurement payroll filing "in the" performance pay - the month issued ".
2, "Procurement payroll archive" to fill in the monthly change in the data is "field allowance" and "performance pay - the month paid", the rest of the data is basically unchanged, sent to the human resources commissioner. This table to the human resources commissioner, you can let the human resources commissioner to check the fixed data can be;
3, "2014 performance statistics", "September Purchasing Department transfer table" sent to the Commissioner for Human Resources.
2