KPI Model

This interactive report uses:

•  employee data (salary, productive hours etc)
•  plus overheads
•  plus required profit margin

to calculate recommended charge out rates.

Step 1    Enter employee’s employment information

Step 2    Click on “Reports / KPI Model

Step 3    Click on to create a new KPI plan. The following screen appears:

  Give the plan a name and date range

Step 4    Load Employees

  Check list of employees and their information - remove employees who have left

Step 5    Edit Payroll add ons - eg superannuation, payroll tax, worker’s compensation

Click on and review / edit mark ups for employee information.

Step 6 Calculate overheads and overhead recover per hour

Click on and review the list of overhead expenses. Edit the list of overheads - i.e.     delete some overheads and add new overheads. There are three sections in the following screen.

Section 1    This is a listing of existing overhead costs. You can either delete the overhead costs or add add existing         kinds to this list. Enter the overhead expenses in the “Amount Column”.

Section 2    Add additional overheads - this will be amounts which are not in the existing accounts.

  In the example below click on{{ jobbag_help:reports_menu:kpi_model_pict12.png?29 }} and added $50000 for new signs which have not been budgeted.

Section 3    The is the non chargeable element of employees’s costs. JobBag calculates this value eg if 90% of employee’s time is chargeable, then 10% is non chargeable. This value is calculated:

  Total Remuneration:    $100000.00
  Non chargeable %:    10%
  Non chargeable value $10,000.00

  Total Overheads $506436.00

  The total “Net Overheads” is used to calculate “Overhead Recovery per Hour”

Step 7    Add Profit target

  This figure is used to calculate to calculate profit recovery for each employee.

Step 7    Edit Employee’s Net Available Hours

Click on each employee’s “Net Available Hours” and edit the hours to reflect annual leave, personal leave and     public holidays.

  Edit the following - add annual leave, public holidays plus an estimate of hours for personal leave.

  Info after adding annual leave and public holidays:

  The above changes increase the:
*     salary recovery per hour for an employee
* overhead recovery for an employee
* total cost for an employee
* and the charge out rate for an employee

Step 8    Based on the above the recommended charge rates are calculated

Step 9    Review impact of changing Charge out rates by entering different rates in the green columns on the rtight habd     side.