Calculate Project and Financial Plan Period Amounts Using Daily Spread Basis
Assign the Daily Spread Basis spread curve to a resource class or planning resource to proportionately distribute amounts across periods based on the ratio of the days in each period to the duration of the task assignment.
Settings That Affect Amount Distribution
You can't define spread points for the Daily Spread Basis spread curve. Therefore, distribution factors aren't calculated. Task assignment start and finish dates determine the number of days in each period, including the first and last periods, and consequently the allocation factor for each period.
Assignment start and finish dates are included in the number of days in the period.
How Daily Spread Basis Amounts Are Calculated
When calculating period amounts, Oracle Fusion Cloud Project Management performs the following steps:
-
Determines the number of days in the first and last period within the task assignment duration using assignment start and finish dates.
-
Determines the number of days in the other periods within the assignment duration.
-
Determines the total number of days for the duration of the task assignment.
-
Calculates the allocation factor for each period using the following formula:
period allocation factor = number of days in period / task assignment duration
-
Calculates the periodic amount using the following formula:
amount = period allocation factor * total resource cost or revenue
Example: Standard Accounting Calendar
In this example, a company uses an accounting calendar with periods that are identical to calendar months. A resource is assigned to a task for 121 days, from February 21 until June 21.
The following table shows how the task assignment days are determined, and the resulting allocation factors.
Month |
Period Dates |
Days in Period |
Task Assignment Days |
Period Allocation Factor |
---|---|---|---|---|
January |
January 1 through January 31 |
31 |
0 |
0 |
February |
February 1 through February 28 |
28 |
8 |
8 / 121 = 0.0661 |
March |
March 1 through March 31 |
31 |
31 |
31 / 121 = 0.2561 |
April |
April 1 through April 30 |
30 |
30 |
30 / 121 = 0.2479 |
May |
May 1 through May 31 |
31 |
31 |
31 / 121 = 0.2561 |
June |
June 1 through June 30 |
30 |
21 |
21 / 121 = 0.1735 |
121 |
121 / 121 = 1 |
Example: 4-4-5 Accounting Calendar
In this example, a company uses a 4-4-5 accounting calendar, with four weeks in the first and second months of the quarter, and five weeks in the third month of the quarter. A resource is assigned to a task from February 21 until June 21.
The following table shows how the task assignment days are determined, and the resulting allocation factors.
Month |
Weeks in Period |
Week Number |
Ledger Start Date |
Ledger End Date |
Days in Period |
Days in Ledger |
Task Assignment Days |
Period Allocation Factor |
---|---|---|---|---|---|---|---|---|
January |
4 |
1 |
1 |
7 |
7 |
|||
2 |
8 |
14 |
7 |
|||||
3 |
15 |
21 |
7 |
|||||
4 |
22 |
28 |
7 |
28 |
0 |
0 |
||
February |
4 |
1 |
29 |
4 |
7 |
|||
2 |
5 |
11 |
7 |
|||||
3 |
12 |
18 |
7 |
|||||
4 |
19 |
25 |
7 |
28 |
5 |
5 / 121 = 0.0413 |
||
March |
5 |
1 |
26 |
4 |
7 |
|||
2 |
5 |
11 |
7 |
|||||
3 |
12 |
18 |
7 |
|||||
4 |
19 |
25 |
7 |
|||||
5 |
26 |
1 |
7 |
35 |
35 |
35 / 121 = 0.2892 |
||
April |
4 |
1 |
2 |
8 |
7 |
|||
2 |
9 |
15 |
7 |
|||||
3 |
16 |
22 |
7 |
|||||
4 |
23 |
29 |
7 |
28 |
28 |
28 / 121 = 0.2314 |
||
May |
4 |
1 |
30 |
6 |
7 |
|||
2 |
7 |
13 |
7 |
|||||
3 |
14 |
20 |
7 |
|||||
4 |
21 |
27 |
7 |
28 |
28 |
28 / 121 = 0.2314 |
||
June |
5 |
1 |
28 |
3 |
7 |
|||
2 |
4 |
10 |
7 |
|||||
3 |
11 |
17 |
7 |
|||||
4 |
18 |
24 |
7 |
|||||
5 |
25 |
1 |
7 |
35 |
25 |
25 / 121 = 0.2066 |
||
121 |
121/121 = 1 |