How Do I Read My Worksheet Markup and Margin on MeasureSquare 8?

How Do I Read My Worksheet Markup and Margin on MeasureSquare 8?

This article will show you how to read and understand your worksheet’s markup and profit on columns. 


This article applies to MeasureSquare 8. 


The markup and margin are generated by a simple math equation. All the information is pulled from the current project and product-level settings. 

Terms

Profit:             dollar amount calculated based on your price and quantity

Rounding:      changes your profit to the decimal place you desire. It will also terminate on a divider of your selection


The formula for Markup is = % of (sales price / cost price)

The formula for Margin is = % of (sales price - cost price) / sales price



  1. You can select which materials you want to produce your rounding and profit by left clicking on your desired material row. If you want to select multiple materials, ctrl + left click. 
  2. After you select your materials, click on the Markup under the Item tab and the Items Markup will pop up. You can add however percentage you want for your Markup along with the type of Rounding you want to produce. 
  3. Notice that when you input the Markup percentage, the Margin and Profit changes the value. 


After you click apply, this message window will appear. 

After you click Yes, the amount of items will be updated in your worksheet regarding Sales Price, Markup, Profit Margin, Sales Amount, Tax Amount, and Sales + Tax



    • Related Articles

    • Walk through bids worksheet: base bids, alternate, info, bid preview in MeasureSquare CRM

      In this article, we will cover an overview of each tab in Bid This article applies to MeasureSquare CRM version 1.38 and above. Worksheet: The Worksheet Tab contains all the added Products Information [1] such as, pricing usage markup percentage, and ...
    • How Do I Read My Worksheet Waste Ratio on MeasureSquare 8?

      This article will show you how to read and understand your worksheet’s waste ratio and waste add on columns. This article applies to measuresquare 8. The waste calculations are generated by a simple math equation. All the information is pulled from ...
    • Release Notes for MeasureSquare 8

      For the latest updates visit the weblink below. https://cloud.measuresquare.com/releasehistory 1.0.11.7587 ------------------------- UI Improvement ------------------------- 1. Enhanced the Project Items, it now shows Net Area, Cost Amt, Sales Amt, ...
    • How do I generate a worksheet in MeasureSquare 8?

      In this video we will cover how to create and manipulate worksheets in MeasureSquare 8. This article applies to MeasureSquare 8 versions Step 1: Have area drawn out with products applied. Step 2: Select 'Worksheet' Step 3: Select 'New' and your ...
    • How to mass update products price by adjusting the markup/margin in MeasureSquare 8

      This article will guide you through how to mass update product prices by adjusting the markup or margin in MeasureSquare 8. --- Steps to Mass Update Products Price Step 1:Right-click on the "Product/Services" folder in the left panel, then select ...