Spread Factors

This screen allows you to create and maintain Spread Factors that can be applied to an Annual Budget and 'spread' the value as defined by factors in this record

Entry and Display fields

Spread Factor:  Enter the Name of the Spread Factor.  Duplicates not allowed.

Month 1 Factor: Enter the Factor to be used against Month 1.  See below for example of how this Factor is used

Month 2 Factor: Enter the Factor to be used against Month 2.  See below for example of how this Factor is used

Month 3 Factor: Enter the Factor to be used against Month 3.  See below for example of how this Factor is used

Month 4 Factor: Enter the Factor to be used against Month 4.  See below for example of how this Factor is used

Month 5 Factor: Enter the Factor to be used against Month 5.  See below for example of how this Factor is used

Month 6 Factor: Enter the Factor to be used against Month 6.  See below for example of how this Factor is used

Month 7 Factor: Enter the Factor to be used against Month 7.  See below for example of how this Factor is used

Month 8 Factor: Enter the Factor to be used against Month 8.  See below for example of how this Factor is used

Month 9 Factor: Enter the Factor to be used against Month 9.  See below for example of how this Factor is used

Month 10 Factor: Enter the Factor to be used against Month 10.  See below for example of how this Factor is used

Month 11 Factor: Enter the Factor to be used against Month 11.  See below for example of how this Factor is used

Month 12 Factor: Enter the Factor to be used against Month 12.  See below for example of how this Factor is used

Total Spread Factor: Display only field showing the sum of the values entered into the Month Factor fields

Buttons

Close: This will close the Spread Factors screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will send the cursor to a new line for entry of a new Spread Factor record.

Save: This will save the current data without exiting the screen

Cancel: Any changes made since the line was actioned or the last time the ‘Save’ Button was pressed will be lost.

Delete: This removes the current highlighted Spread Factor record

Example of using Spread Factor

Assuming that there is a Spread Factor record containing the following:

Spread Factor:                 Example of Spread Factor

Month 1 Factor:                0

Month 2 Factor:                3

Month 3 Factor:                2

Month 4 Factor:                10

Month 5 Factor:                0

Month 6 Factor:                6

Month 7 Factor:                1

Month 8 Factor:                0

Month 9 Factor:                0

Month 10 Factor:                4

Month 11 Factor:                2

Month 12 Factor:                2

Total Spread Factor:        30 (System calculated from the sum of the above)

If you now create a Budget Line with an Annual Amount of (say) $45,000 then Ostendo will populate the 12 Monthly Amount fields as follows

Annual Amount = $45,000

Number of Factors = 30

Amount per Factor = $45,000 / 30 = $1,500

Month 1 Factor:                0                Amount = $0

Month 2 Factor:                3                Amount = $4,500

Month 3 Factor:                2                Amount = $3,000

Month 4 Factor:                10                Amount = $15,000

Month 5 Factor:                0                Amount = $0

Month 6 Factor:                6                Amount = $9,000

Month 7 Factor:                1                Amount = $1,500

Month 8 Factor:                0                Amount = $0

Month 9 Factor:                0                Amount = $0

Month 10 Factor:                4                Amount = $6,000

Month 11 Factor:                2                Amount = $3,000

Month 12 Factor:                2                Amount = $3,000

                                       Total     = $45,000