Sites Financials

The Sites Financials section allows users to view & set financial data for the selected site across various stages. This includes information related to Costs, Sales, Retentions, Purchases, Work Submissions, and Consumables, providing a comprehensive overview of the Site’s financial activity.

When the Site is in Tender or Completed, the Sales section will not be visible within the Site’s Financials page.

Base Costs

The Base Costs section displays a breakdown of the Base Costs for the selected Site. This includes the Base Material, Labour, and Consumables Costs that were configured for the Site.

The Base Material and Base Labour Cost figures represent the total cost of all Material and Labour items on the site before the site is made Active. The Base Cost Labour figure includes Labour Item Uplift. Once the site is made Active, these Base Cost figures are retained as they were at the time the site was set to Active.

The Base Consumables figure represents the total cost of the Consumables Amount that has been set for the selected Site before it is made Active. The figure is derived from Consumables Amount set within the Site’s Financials section. As the Consumables Amount is defined for a Build Stage, this figure is calculated by multiplying that amount by the total number of Plots containing the relevant Build Stage. Once the site is made Active, these Base Cost figures are retained as they were at the time the site was set to Active.

These values will only change if the Site is set back to Baseline and the Material, Labour or Consumables costs are modified. This may occur through a Cost Update, Quantity Change, or the Addition or Removal of a Material or Labour item on the Site.

The Total Cost figure represents the Total Baseline Cost for the selected Site, this includes Materials, Labour & Consumables.

Current Costs

The Current Costs section within the Site’s Financials page allows users to view the Current Costs for Materials, Labour, and Consumables. It also displays the Base Mark Up applied to the Site.

The Current Materials & Labour figures represent the Current Actual Cost of all Materials & Labour Items on the Site. The Current Cost represents the genuine cost of items based on what has already been submitted on the site. If a Cost is updated after some items have already been submitted or ordered, the new cost will only apply to items that have not yet been submitted. Any items that were previously submitted will retain the cost that was in place at the time of submission.

The Current Consumables figures both represent the Consumables Cost for the selected site.

The figure shown in brackets represents the Actual Cost, which is the Cost of the Consumables that have been ordered for the Site through the Consumables area.

The figure shown next to the bracketed value represents the Consumables Amount. This value is derived from the Consumables Amount set within the Site’s Financials section. As the Consumables Amount is defined per Build Stage, this figure is calculated by multiplying the Consumables Amount by the total number of plots that contain the relevant Build Stage.

The Base Mark Up is calculated by subtracting the Base Total Cost from the Base Agreed Sales Price, dividing the result by the Base Agreed Sales Price, and then multiplying the value by 100 to express it as a percentage.

The Total Costs figure includes the Current Material & Labour Costs, along with the Actual Consumables Cost, which is the bracketed value.

Variation Costs

The Variation Costs section allows users to view financial information related to Variations on the selected Site. This includes details such as Material and Labour Costs associated with those Variations.

The Variation Materials figure represents the Total Material Costs across all Client Approved Variations on the selected Site.

The Variations Labour figure represents the Total Labour Costs across all Client Approved Variations on the selected Site.

If Material or Labour costs are changed after a Variation has become Client Approved, those changes will not affect the Variation. Each Client Approved Variation retains the Material and Labour values that were in place at the time the Variation became Client Approved.

If a Client Approved Variation is Revoked, the Material & Labour Cost will be deducted from the Variations Costs within the Financials page.

Total Costs

The Total Costs section allows users to view the Total Actual Costs for the selected Site, such as Total Material, Labour & Consumables Cost.

The Total Materials figure combines both the Current Materials Cost and the Variation Materials Cost for the Site.

Similarly, Total Labour combines the Current Labour Cost with the Variation Labour Cost.

The Total Consumables figures display both the Total Actual Consumables Cost and the Total Consumables Amount. The figure shown in brackets represents the Actual Cost, which is the Cost of the Consumables that have actually been ordered for the Site through the Consumables area.

The figure shown next to the bracketed value represents the Consumables Amount. This value is derived from the Consumables Amount set within the Site’s Financials section. As the Consumables Amount is defined for a Build Stage, this figure is calculated by multiplying the Consumables Amount by the total number of plots that contain the relevant Build Stage.

The Total Cost figure represents the combined value of Total Materials, Total Labour, and the Actual Consumables Cost for the Site.

Sales

The Sales section provides an overview of key sales-related information for the selected Site. Each component is described below:

• Plot Prices – This figure represents the Sales Price for all of the Plots on the selected Site.
• Base Mark Up – The Base Mark Up percentage is calculated by dividing the Plot Prices by the Base Total Cost.
• Sales Extras Prices – This figure represents the price of all Sales Extras on the selected Site.
• Total Sales Price – This figure represents the Plot Prices and Sales Extra Prices combined for the Site.
• Current Mark Up – The Current Mark Up percentage is calculated by dividing the Total Sales Price by the Total Current Cost.
• Variations Sales Price – This figure represents the Variation Sales Price for all Client Approved Variations on the Site.
• Total Project Sales – This figure represents the Total Sales Price and the Variations Sales Price combined for the Site.
• Gross Profit – This Gross Profit is calculated by subtracting the Total Project Costs from the Total Project Sales.
• Gross Profit Margin – The Gross Profit Margin percentage is calculated by dividing the Gross Profit by the Total Project Sales.

Settings

The Settings section allows users to configure key financial factors for the selected Site. This includes setting Retentions, defining Payment Terms, and specifying a Consumables Amount.

The Retention Cap field allows users to enter a numeric value which decides how much can be retained in a Sales Application Document. Once the Retention Cap has been reached, the system will no longer automatically apply Retention within the Sales Application Document.

The Retention field allows users to enter a numeric percentage value. This percentage is automatically applied to the Retention field within each Sales Application Document. The resulting Retention value is calculated based on the entered percentage and the value of the Sales Application Document.

The Payment Terms field allows users to enter a numeric value and select a time unit from the dropdown, which includes Days, Weeks, Months, or Years. This setting determines how the Due Date is calculated for each Sales Application Document. The system calculates the Due Date by taking the End Date defined in the Sales Application Details page and adding the specified Payment Term value.

The Consumables Amount field allows users to enter a numeric value. This value is only editable while the site is in the Tender stage. Once the site becomes Active or Completed, the Consumables Amount can no longer be modified.

The Amount is defined for a Build Stage. Once set, this amount is automatically applied to each Plotthat includes the specified Build Stage, contributing to the overall Consumables Cost for the Site. The overall Consumable Cost for the Site then populates the Consumables column on the Sites list page and is included in the downloaded data from the Sites List page.

The Consumables Amount is also displayed on the Tender page. It is included in the Total Costs, Tender Value, and is used in the calculation of the Margin.

The Consumables Build Stage dropdown lists all non-deleted Build Stages within the system.

The selected Build Stage determines where the Consumables Amount will be applied, with the value being assigned to all plots that include that Build Stage.

Report

The Report section allows users to view Consumables Cost, Materials Cost, Labour Items Cost and Total Cost for the selected site. A Date Range filter is also provided, which updates the table to the right to display Purchases, Work Submissions, or Consumables within the selected time period.

The displayed Cost figures are dependent on the selected Date Range. Only costs that fall within the chosen date range will be shown.

These figures represent the Cost of Purchases,Work Submissions,and Consumables. Each item in the table is described below:

Purchases:

The Purchases table lists all Purchase Orders for that Site with a Delivery Requested For date that falls within the selected Date Range. Only Purchase Orders that have been sent and assigned a PO Number will be displayed in the table.

Credit Orders are also displayed in this table when their Delivery Requested For date falls within the selected Date Range. These will only appear once they have been sent and assigned a PO Number. As the materials are being credited, they are shown as a negative value in the Cost column.

The user can select a Purchase Order row from the table, and the system will navigate directly to the corresponding Purchase Order record.

Work Submissions:

The Work Submissions table lists all Accepted Work Submissions for that Site with a Submission Date that falls within the selected Date Range. Only Work Submissions that have been Accepted will appear within the table.

The Cost column shows the cost of the Labour Items submitted within each Work Submission.

The Cost with Uplift column includes the same Cost but also applies the Labour Item Uplift as defined on the System Settings Details page.

Users can select a Work Submission row from the table, and the system will navigate directly to the corresponding Work Submission record.

Consumables:

The Consumables table lists all Consumable Orders for the site with a Requested For date within the selected Date Range. Only Consumable Orders that have been sent and assigned a Consumables Order Number will appear in the table.

The Cost column displays the total cost of the Consumable Items included in each Consumable Order.

The user can select a Consumable row from the table, and the system will navigate directly to the corresponding Consumable Order record.