Monthly Sales Retained % Gross Profit Expenses Net Profit Bonus % Bonus Pool Hours Worked Bonus         
     
       
    The blue fields calculate bonus based on net profit thresholds from the blue table below. Bonuses start at 75 hours worked, doubling at 130 hours, beginning at $14,000.00 net profit.

The fields in green calculate via an alternative method, using a supplied bonus % of net profit to create a bonus pool, dividing the pool by the total hours worked by all employees, multiplying that by the number of hours worked by the individual employee.

Add, remove, or adjust expenses, change variables in the yellow fields to update results.
  Result    
         
             
           
           
      Result    
                       
    Monthly Expenses Hourly Rate Hours Extension                    
                     
        Thresholds 130+ hours Percentage 75+ hours Percentage     
        $14,000.00 $400.00 $200.00    
        $20,000.00 $800.00 $400.00    
        $25,000.00 $1,000.00 $600.00    
        $30,000.00 $1,500.00 $800.00    
        $35,000.00 $2,000.00 $1,000.00    
        $40,000.00 $2,500.00 $1,250.00    
        $45,000.00 $3,000.00 $1,500.00    
        $50,000.00 $3,500.00 $1,750.00    
        $55,000.00 $4,000.00 $2,000.00    
  Total Monthly Expenses