@FRANK_TRIES
If we were sitting down together and trying to work this out, I'd have to ask a few more questions. I'm pretty sure anybody else would too. So bear with me/us. It will also help if you can post a copy of whatever workbook/spreadsheet you already have as a starter, so we don't have to create something from scratch that has no bearing on your reality.
That said, here are some questions:
- Does only one employee work each day, or are there some days when two of them, or even all three are present and working?
- Do the number of hours worked in any given day matter?
- Is it only the profits for each day they work that are shared with whoever worked that day, or are the profits for the week tallied first, and then shared based on hours/days worked by each of the three? (Asked another way, if somebody was present all day but no sales (therefore no profit) that day, do they get zero?)
- Is there a minimum or maximum applied or is it a straight percentage regardless?
- Does seniority matter in any way; length of service with you?
- Are there any other factors that you're taking for granted, but would be helpful for anybody wanting to help you out here? Like, for instance, do you take any withholding tax out (Federal or State)?
You get the idea....
