How are crew earnings split by LPC?

For each worker the hours worked are multiplied by the LPC. The crew's earnings are divided in proportion to these products within the same crew.

Can I calculate individual piecework?

Yes, set up a crew of one person: all earnings from that crew's work orders go to them, and the LPC can be left blank.

How do I include a regional coefficient or bonus?

Set a single supplement percentage on the "Reference lists" sheet. It is applied to piecework earnings; 0 means no supplement.

Where do I get the income tax rate and the rates?

Rates are approved in your organization; the income tax rate is a parameter in the reference lists and should be checked against the rules that apply to you.

← All templates

Piecework Pay in Excel: Work Orders, Rates, Crews, LPC — Excel Template

Piecework pay calculation from work orders and rates: crew output, earnings split by hours and LPC, supplement, income tax and a net pay sheet.

≈ $6.09

490 ₽

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Piecework pay is often calculated by hand from work order books, and splitting crew earnings by labour participation coefficient (LPC) causes disputes. Here a work order is entered as a row, the rate is filled in automatically, and the crew's earnings are split among workers by hours and LPC, with gross pay, income tax and net pay visible straight away.

What is inside

"Reference lists": pay period, operation rates, crews, workers, supplement and income tax rate.
"Work orders": up to 1,000 orders — date, number, crew, operation from the list and quantity; the rate, amount and "in period" flag are calculated automatically.
"Payroll sheet": workers' hours and LPC, share in the crew, earnings, supplement, income tax, net pay, output per hour and a signature column.
"Summary": totals by crew and operation, a control check "work orders = payroll sheet" and two charts.

Who it is for

Accountants, work-rate setters and timekeepers, foremen and crew leaders in construction, installation, manufacturing and repair organizations where people are paid for output rather than hours.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The sample rates are fictional; use the rates and norms approved in your organization and check the tax rate and supplement against the rules that apply to you. The file is in English.

📘 How to Calculate Piecework Pay in Excel: Work Orders, Rates and Crew Split

Questions and answers

How are crew earnings split by LPC?: For each worker the hours worked are multiplied by the LPC. The crew's earnings are divided in proportion to these products within the same crew.
Can I calculate individual piecework?: Yes, set up a crew of one person: all earnings from that crew's work orders go to them, and the LPC can be left blank.
How do I include a regional coefficient or bonus?: Set a single supplement percentage on the "Reference lists" sheet. It is applied to piecework earnings; 0 means no supplement.
Where do I get the income tax rate and the rates?: Rates are approved in your organization; the income tax rate is a parameter in the reference lists and should be checked against the rules that apply to you.