LMSEO (Labor, Materials, Sub, Equipment, Other)

In Ediphi, the LMSEO columns—Labor, Materials, Subcontractor, Equipment, and Other—make it easy for users to view the total cost breakdown of each line item, helping them better manage and support their budgets. This feature not only shows how each total is calculated, but also allows users to adjust the values to update the unit cost accordingly. The LMSEO columns are available in both the Detailed Summary and Line Items tabs.

To start, click the arrow above Unit Cost to expand the LMSEO columns.

In this article

• LMSEO Columns
• LMESO Totals Columns
• Understanding the new LMSEO Logic
• LMSEO and Assemblies

LMSEO Columns

Below is a breakdown of how each value is defined and calculated within the LMSEO columns:

Labor UC: Labor Rate x hrs/UoM = Labor UC

• Changing labor rate or hrs/UoM will automatically update Labor UC
• Overriding Labor UC will automatically update the hrs/UoM, while the Labor rate will remain constant

Labor Rate: Cost of labor per hour

hrs/UoM: Total number of hours per unit of measurement (ex. number of hours it takes to install one generator)

Material UC: Cost of materials per unit

Equip. UC: Cost of equipment per unit

Sub UC: Cost of sub per unit

Other UC: Other cost per unit

LMSEO Totals Columns

Here's a breakdown of how the totals in the LMSEO columns are derived:

Total Labor: Labor UC x Qty

Total Material: Material UC x Qty

Total Sub: Sub UC x Qty

Total Equip: Equip. UC x Qty

Total Other: Other UC x Qty

Labor Hours: hrs/UoM x Qty

UoM/hr: Shows unit of measurement per hour (ex. number of square feet painted in an hour)

Understanding the new LMSEO Logic

The Line Item Total will always equal to the sum of its LMSEO components. To ensure this consistency, we've updated the platform: the override logic for LMSEO columns in Estimates has been removed. Here’s how it works:

• When updating line item totals, the following will occur:
  • Partial UC Values: In the case where only some UC columns contain values, the allocation will be distributed across those columns only. Columns with no values will remain unchanged.
    • Example: If 70% is in Labor and 30% in Materials, the auto-allocation will respect those percentages.
  • No UC Values: If no values exist in any columns, Ediphi will place the entire entered amount into the Sub column (it will not spread across other columns).
  • Labor & Production Rate Behavior: If a line item has values in both Labor and Production Rate:
    • Updating the Total will recalculate the Production Rate.
    • The Labor Rate will remain unchanged.
      • Example: Labor Rate: 80 x Production Rate: 12 → Total = 960. If the Total is overridden to 1,200, Production Rate updates to 15, and Labor Rate stats at 80.
  • Clearing a Total: When a Total is cleared by a user, all LMSEO values for that line item will reset to null (-), except Labor Rate which will remain.
  • Labor UC Value Entry: Entering a Labor UC value automatically sets:
    • Production Rate = 1
    • Labor Rate = Entered value
      • Example: If $1,000 is entered, the Production Rate will equal 1, and the Labor Rate will equal $1,000.

LMSEO and Assemblies

Assemblies are unique in that they have their own logic which determines parent line items. Here’s how it works:

• The Total of a parent line item equals the sum of all Assembly line item totals
  • (Parent line item Total = sum of it’s Assembly line item totals).
• The Labor Rate of a parent line item equals the Labor UC divided by Hrs/UoM (back-calculated)
  • (Labor Rate = Labor UC / Hrs/UoM)
• The Quantity of a parent line item equals the quantity of the selected Assembly Quantity line item
  • (Parent line item Quantity = selected Assembly Quantity line item’s Quantity).
• The Unit Cost of a parent line item equals the Total divided by Quantity of the parent line item
  • (Unit Cost = Parent line item Total/Parent line item Quantity).
• The Hrs/UoM of a parent line item is inherited from the selected child
  • (Hrs/UoM = selected Assembly Quantity line item’s Hrs/UoM)
• The Labor UC, Material UC, Equip. UC, Sub UC, and Other UC of a parent line item are distributed proportionally based on children’s LMSEO ratios
  • (sum of Assembly line item Material UC/sum of Assembly line item Unit Costs = percentage carried into parent Material UC)

If you have any questions, feel free to contact our support team and we'll be happy to help!