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:             a 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.