Piecework Tracking - Technology - Contractor Talk

Piecework Tracking

Thread Tools Search this Thread Display Modes
Old 07-11-2019, 04:02 PM   #1
Registered User
Windowguy75's Avatar
Trade: Windows and Doors
Join Date: Jul 2019
Posts: 3
Rewards Points: 12

Piecework Tracking

I need some help!!

We have a small construction company and we specialize in window and door installations in new construction. We pay our guys based on what type of window or door they install and how many. Each one pays a different amount depending on size and type. Right now we are just using a Excel spread sheet which was fine in the beginning but we have since grown to 15 employees and it is very time consuming and a bit of a pain to keep track of everything as we are growing.

So my question is this, does anyone know of any type of software that is available that would work for this type piece work detail or does anyone else deal with this in your line of work or business? There has got to be an easier way!! Thank you in advance for your help.
Windowguy75 is offline  

Warning: The topics covered on this site include activities in which there exists the potential for serious injury or death. ContractorTalk.com DOES NOT guarantee the accuracy or completeness of any information contained on this site. Always use proper safety precaution and reference reliable outside sources before attempting any construction or remodeling task!




Old 07-11-2019, 05:18 PM   #2
Capra aegagrus

Tinstaafl's Avatar
Trade: Remodeler
Join Date: Jan 2008
Location: Central Pennsylvania
Posts: 23,164
Rewards Points: 1,335

Re: Piecework Tracking

I'd stick with the spreadsheet, or its kissing cousin, a database application. No matter what software you use, the choke point is data entry, and that's going to be there regardless.

You can make the data entry a bit less painful if you find a spreadsheet/database guru to customize the interface for you. Done well, you'd never suspect the backend was Excel, Access or whatever.

I'm not aware of a general-purpose product that would fit your situation well.


Tinstaafl is offline  
The Following User Says Thank You to Tinstaafl For This Useful Post:
hdavis (07-12-2019)
Old 07-12-2019, 08:41 AM   #3
Fishindude's Avatar
Trade: Industrial
Join Date: Aug 2017
Location: Indiana
Posts: 405
Rewards Points: 862

Re: Piecework Tracking

Sounds like you are skating on the edge of illegal paying your men this way. If they are truly independent contractors then they need to set the price for their jobs, not you, and they need to carry all the appropriate insurances, licenses, etc.
Fishindude is offline  
The Following User Says Thank You to Fishindude For This Useful Post:
Defenestrate (07-12-2019)
Sponsored Links
Old 07-12-2019, 09:22 AM   #4
Registered User
Windowguy75's Avatar
Trade: Windows and Doors
Join Date: Jul 2019
Posts: 3
Rewards Points: 12

Re: Piecework Tracking

They are not independent contractors. They are actual employees of the company. As long as you keep track of the hours worked and make sure they meet the minimum wage requirements then it is perfectly legal.
Windowguy75 is offline  
Old 07-12-2019, 10:50 AM   #5
Repair/Remodeling Tech.
jproffer's Avatar
Trade: Repair and Remodeling Services
Join Date: Feb 2005
Location: Chester, IL
Posts: 1,546
Rewards Points: 66

Re: Piecework Tracking

Are you saying the pay varies based on size? For instance a 30" door pays X, a 32" door pays Y, and a 36" door pays Z? I wouldn't think it would be worth trying to track that so specifically. Each size/pay has to be looked up, etc.

In excel, you can just have a cell/column for number of doors (of any size, all together) and a cell/column for number of windows (all together), and then multiply and add into one cell/column. Seems like it would be a lot less data entry. Granted some doors and windows are a bigger PITA to install than other types, but if you find a happy place and just use one window price and one door price, it seems like it would be better for everyone.

But maybe I'm misunderstanding how you pay.
Jim P.
jproffer is offline  
Old 07-12-2019, 11:01 AM   #6
Registered User
Windowguy75's Avatar
Trade: Windows and Doors
Join Date: Jul 2019
Posts: 3
Rewards Points: 12

Re: Piecework Tracking

Yes to a certain extent it is like that. A single door pays X a double door pays X and so on. A single window pays X, A twin pays X ..... Basically the bigger and heavier the window or door is the more it pays. I have thought about just doing as your saying and have one price for a door and a window no matter the size but I cant really figure out a price that would be beneficial to our guys and for the company to make the profit it needs to. I don't know, maybe there is a middle ground somewhere. Just haven't really figured out where it is yet.
Windowguy75 is offline  
Old 07-12-2019, 07:56 PM   #7
VinylHanger's Avatar
Trade: I'll do that for 500 bucks.
Join Date: Jul 2011
Location: Oregon
Posts: 9,653
Rewards Points: 10,272

Re: Piecework Tracking

IIRC, we always broke it at a 4 x 4 window, then it went to the next level. If it was a crazy 10x5 triple ***, it was more because of the hassle. Same for second story work, etc.

Single doors one price, sliders one and French doors another.

I think you are over thinking it.

Sent from my SM-N950U using Tapatalk
Your emergency does not constitute a problem with my Constitution.
VinylHanger is offline  
Old 07-12-2019, 09:55 PM   #8
Bubble stick operator
Defenestrate's Avatar
Trade: Carpentry
Join Date: Aug 2015
Location: California
Posts: 537
Rewards Points: 130

Re: Piecework Tracking

Have you looked at old numbers? I'd think you could take 3,456 installed windows, divide that by the money you've paid out and see if that would be an acceptable price for a basic window. Pay double for a complicated window and pay for that with time saved on paperwork.

Side question, if you don't mind... do you get adequate quality when you pay by the unit?


Defenestrate is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Join Now... It's Fast and FREE!

I am a professional contractor
I am a DIY Homeowner
Drywall Talk is for

At DrywallTalk.com we cater exlusivly to professional contractors who make their living as a contractor. Knowing that many homeowners and DIYers are looking for a community to call home, we've created www.DIYChatroom.com DIY Chatroom is full of helpful advices and perfect for DIY homeowners.

Redirecing in 10 seconds
No Thanks
terms of service

Already Have an Account?