Home > SI 2017 Documentation > Knowledge Base > Using the Mix and Margin Analysis Custom Report

Using the Mix and Margin Analysis Custom Report

Overview

The D-Tools Professional Services Group worked closely with the Bravas Group to develop the Mix and Margin Analysis custom report.  The report follows a Bravas prescription for dividing all project costs into three groups and then analyzing proposed margins vs. actual margins as well as comparing the proposed vs. actual mix of those groups.

 

The project cost breakdown used in this report works as follows:

  1. Labor - All labor associated with the project
  2. Materials - Miscellaneous Parts Adjustment plus all items in the following categories:
    • Wire and Cable (standard SI category)
    • Interconnects (standard SI category)
    • Install Parts* (custom SI category)
  3. Equipment - All non-labor items not included in Materials

*Install Parts can be defined as project items other than wire and interconnects that are non-inventory items (e.g. wire hangers, brackets, etc.)

 

Target margins are hard coded in the report as follows:

  • Equipment - 35%
  • Materials - 60%
  • Labor - 100% (labor cost is not included in the calculations per Bravas Group)

 

Mix targets are configurable using Report Definitions. The default values are:

  • Equipment - 56%
  • Materials - 10%
  • Labor - 34%

 

MixAndMarginSample.jpg

Using the Solution

Download and Install the Report

  1. Download the report here: Mix-and-Margin-Analysis.dtr
  2. In SI 2017, navigate to Start - Reports - Manage Reports.
  3. From the Report Explorer, click Import - File.
  4. Browse to the downloaded file and select it. Click Open. The report will be imported and can be found in Management Reports.

Adjusting the Mix Targets

Perform the following steps to set your own mix targets and have those targets be the default when you run this report.

  1. From any SI interface where the Reports menu is available, navigate to Management Reports.
  2. Find the Mix and Margin Analysis report, right-click on it and select New - Report Definition.
  3. The Report Definition window opens. Type a description for the Report Definition.
  4. Click the Parameters tab.
  5. Type a percentage for each parameter and make sure the values add up to 100%. The report will not run otherwise.
  6. At the bottom of the window, check the Default Report Criteria box.
  7. Click Save. Now the report will use your mix targets by default.

 

Last modified

Tags

Classifications

This page has no classifications.