Example 5: Basis and Target Time Span—Multiple Members; Basis Time Span Option—Combine

In this example, multiple time periods are specified for the basis and target time spans; however, because the basis time span option is set to combine, the basis and target time spans need not contain the same member set. (For an example of setting the basis time span option to split, see Example 4: Basis and Target Time Span—Multiple Members; Basis Time Span Option—Split.)

Assume the amount is 1000. As shown in Table 229, the basis to be used for each department is the sum of the basis values across the basis time span (Dept_1 = 10); the basis for the range is the sum of all department basis values (113):

Table 229. Example 5: Basis Values

 RangeTotal
Members in Basis Time SpanDept_1Dept_2Dept_3Dept_4Dept_5Dept_6 
Dec 07123456 
Jan 08234567 
Feb 08345678 
Mar 08456089 
Total

10[1]

1418152630

113[2]

1 Basis for each range member summed across the basis time span periods

2 Total basis for the range

The setting for target time span option determines how the allocation is calculated.