Example 1 parent location

Changing the payroll percent value for a parent location.

Suppose the initial values in the Payroll and Payroll % columns are:

Location Sales Payroll Payroll %
REGION 1000 60 6
STORE1 500 30 6
DEPARTMENT1 300 24 8
DEPARTMENT2 200 6 3
STORE2 500 30 6

If the value in the Payroll % column for REGION is changed to 7, then:

  1. The payroll for REGION changes to 70.
  2. The payroll percent for each child location changes by the same proportion that the parent location changes, which is 7/6, or 16.66666667%.
  3. The payroll is recalculated for each child location based on its new payroll percent value.

The new Payroll and Payroll % values are:

Location Sales Payroll Payroll %
REGION 1000 70 7
STORE1 500 35 7 (calculated as (6*7/6))
DEPARTMENT1 300 28 9.33 (calculated as (8*7/6))
DEPARTMENT2 200 7 3.5 (calculated as (3*7/6))
STORE2 500 35 7 (calculated as (6*7/6))