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.

Note: 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:

1. Determines the number of days in the first and last period within the task assignment duration using assignment start and finish dates.

2. Determines the number of days in the other periods within the assignment duration.

3. Determines the total number of days for the duration of the task assignment.

4. Calculates the allocation factor for each period using the following formula:

   period allocation factor = number of days in period / task assignment duration

5. 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