Give me some data and I will try my best to analyse it.

I was given, OK! I FOUND someone’s piece work records for a part of a particular month and asked them if I could create a spreadsheet for it … thankfully they said yes and here we are!

I won’t provide any details except to say that my friend is providing a consumer service in an outlet in the centre of a capital city. The basic data she recorded was:

  • number of customers served per day
  • total tips received from all customers that day, received in cash and kept by the employee
  • total earnings that day, as to be paid at the month end as salary

I set to work and the following table contains the following basic and additional columns:

  • Day
  • Customers
  • Tips
  • Earnings
  • Total Pay
  • Cumulative  Tips
  • Cumulative Earnings
  • Cumulative Total Pay
  • Tips per Customer
  • Earnings per Customer

At the bottom of the Cumulative total Pay column I have programmed an annualised taxation warning that shows the employee that at the current rate of earnings they will be liable for income tax during this tax year. This is not a PAYE country!


You can see that the month has not finished yet!

I then prepared a series of graphs from this table: forgive the inconsistent way in which I have presented the six graphs … microscope time:

  • graph one shows the days worked and days off … the days off are shows as gaps in the curve
  • graph two shows daily earnings and cumulative earnings


  • graph three shows daily tips received and cumulative tips received
  • graph four shows earnings  v tips … the potential relationship between them: being able to predict tips from earnings might be an ambition!


  • graph five shows earnings per day and average earnings per customer
  • graph six shows tips per day and average tips per customer


For this individual employee this analysis is neither here nor there. In the grand scheme of things it is not that important. If you take a bigger view, however, and consider this information for every one of the 20 employees in this organisation, their tips v earnings, their taxation positions and so on, there is a whole mine full of data just waiting to be analysed!

Take a look at these, for example and ask yourself,

  • why is the earnings per customer not a constant 100?
  • why has this employee taken more days off than the one day per week?
  • can you see a pattern emerging that would help this employee to predict tips from earnings?

I am sure you can find other questions to ask, apart from why did I bother?!

Finally, this worksheet is now a template and I hope to get the chance to keep it updated for at least six months, maybe more.

Duncan Williamson

15 Responses to “Piece Work Analysis”

  1. MaryJane Says:

    Can you please email me this spreadsheet

  2. MaryJane Says:

    Hi Duncan I work in a factory where we are trying to determine pieces with our textiles… and really want something comprehensive. Thank you so much … MJ

  3. Kali Forquer Says:

    Is there any chance this is still out there? Really hoping for help.

  4. Scott Says:

    Hi Duncan,

    While this example is obviously specific to a certain type of base-earnings-plus-tips type of service work, I think it is an excellent example of solid analysis for piece work type analysis. Thank you Duncan!

    I’m a consultant currently helping a client in the construction industry analyze and determine appropriate piece work rates for various different tasks and activities the crews undertake. I’d like to use your template as a learning tool and starting point for what to be looking at and analyzing and then create something similar for my client’s plans and purposes. Any chance you could share the template with me? Thanks so much in advance! – Scott

    • Thanks Scott and many apologies for the delay. Let me remind myself of what I did and then gt back to you.

      WordPress is not so hot at telling me that someone has commented on a page …


    • If you let me have your email address, I can send you my file.

      Apologies again for the late response to your request.


      • Scott Says:

        Hi Duncan,
        Now it’s my turn to apologize – I only saw your reply to me (back in May of 2019) this morning, when I got an email notification about your reply to Shannon below! Anyway, apologies for MY late response. Can you still send me the file you’re referring to above in your reply to me?

        My email:

        Thanks so much!

      • Already done, Scott


  5. Shannon Says:

    Hi Duncan,

    Can you email me this formulated spreadsheet for tracking piece rate time for payroll? We are a construction subcontractor needing help tracking for projects time and materials.

    Thanks so much,

  6. The file ready, Shannon. Just let me know where to send it.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: