Process

1. Figure out everyones job contribution %

2. Figure out who has extra % (bonus)

3. Figure out who has less % (loss/divided up among others)

Job info list

1. Job Total Hours

2. Job Total Cost

3. Expected Hours/Crew Member

Formulas

-Full Cut Amount=Job Cost x Percentage rate

-Bonus/loss % = Actual Hours - (Job total hours/number of guys)

Divided by Job total hours

-Job Contribution % = 1/number of guys

Employee Info list

1. %

2. Hours Worked

3. Full Cut Amount

4. Actual Cut Amount

5. Bonus/loss Amount

6. Ideal Job Contribution

7. Real Job Contribution

8. Bonus/loss %