Project Properties – Spreading

The Spreading section of the Project Properties provides you with the ability to customise various properties associated with the spread calculation.

These options include rounding options for Sell Rates and Totals, misclose thresholds, and a range of options for determining how spread pools manage specific spread allocations.

To change the information in this section, click the Edit button  in the ribbon menu.

Project Properties window – Spreading

CALCULATION TYPE

Calculation Type allows you to set the type of spread calculation that will be used within the project. There are two options available:

OPTION

DESCRIPTION

Item Sell Rates are determined based on an item’s contributing value

The amount of markup applied to an item is distributed proportionately based on each item’s estimated total.

Item Sell rates are determined based on an item’s Resource Type Content

The amount of markup applied to an item is distributed proportionately based on each item’s total for each resource type.

Example: All labour values are proportionately spread based on the labour value of each item.

Genesis edition only.

SELL RATE ROUNDING

The Sell Rate Rounding options are determined by customisable rules based upon the quantities of the schedule items. These rules are applied during a spread calculation and round each item based on the rules specified. Click the Add Rule button to create a new rule in the Sell Rate Rounding section.

OPTION

DESCRIPTION

For schedule quantities up to (x) round Sell Rates to (y) decimals places

This option allows for specific Sell Rate decimal rounding rules based on quantities.

The (x) represents the quantity and the (y) represents the number of decimal places to round the Sell Rate.

Round Sell Rates to (x) decimal places

This option applies to all Sell Rate decimal places that are not set by any other rules.

The (x) represents the number of decimal places to round the Sell Rate to.

Always Roundup Sell Rates

When a calculation needs to determine the decimal amount to round to, it will always round up, regardless of any determined midpoint.

SELL TOTAL ROUNDING

OPTION

DESCRIPTION

Round Sell Totals to (x) places

Specifies the number of decimal places that the sell totals for each item will be rounded to during the spread calculation.

The (x) represents the number of decimal places to round the Sell Total to.

MISCLOSE THRESHOLD

OPTION

DESCRIPTION

Do not display a project message if a misclose value is less than (x)

When a Spread Calculation has been performed and the combined sell total for all contributing items is different to the estimated sell total, the deficit is known as a misclose.

The misclose threshold is the limit at which a project message will be raised.

The (x) represents an amount that will be tolerated as a difference between the Project Total in the Project Summary and the combined Sell Totals of all contributing Schedule Items after the Spread Calculation.

By default, the misclose threshold value is set to 1, any misclose value greater than 1 results in a project message being raised.

SPECIFIC ALLOCATIONS

The Specific Allocations options allow you to control how the proportional spread of the application is controlled while Hidden / Overhead Items are specifically allocated through the Spread Allocations window.

OPTION

DESCRIPTION

Item with specific allocations will also receive a normal spread of the allocated pool

This option will allow items with specific allocation to also be given a spread amount as well. By default, items with specific allocations will not incur regular spread.

Specific Allocations should be processed before Spread Pool

Includes the Specific Allocation value as part of the factor in determining the amount to apply to an item. When calculating a line amount the remaining specific allocations from a pool will be included in the factor along with remaining pool value.

When this option is off, the amount of spread an item receives is based on the estimated cost and not including the allocation that has been applied.

Genesis edition only.

ZERO-VALUE TARGETS

The Zero-value targets section allows you to configure how the application distributes allocated value from Overhead or Hidden items with a weighting of Item Value, to items with a combined Estimated Total of $0.

OPTION

DESCRIPTION

Calculate the weighting of allocated value based on the Quantities of the target items

The allocation value will be proportionally spread amongst all items that the Overhead / Hidden item is currently allocated to based on the quantity of the item.

Distribute the allocated value evenly between the items

The allocation value will be evenly spread amongst all items that the Overhead / Hidden item is allocated to regardless of their quantity.