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. 



    • Related Articles

    • 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 ...

    • 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 add QR code on my report and worksheet on Measure Square 8

      In this article, you will learn how to add a QR code on your report and worksheet on MeasureSquare 8 which will allow other people to view a 3D model of the diagram on a browser Step 1: make sure you have synced your project to the MeasureSquare ...

    • When I Try to Export my Worksheet to Excel, I Get an Error

      In this article, you will learn how to fix the issue where you get an error message when exporting your Worksheet to Microsoft Excel. This article applies to MeasureSquare 8. When you are in the Worksheet module of MeasureSquare 8 and try exporting ...

    • How to use the worksheet. Worksheet functions explained.

      This article will show you how to select the proper worksheet. By defining each worksheet you will be able to make the best choice for what you For all versions of Desktop MeasureSquare 8 Description of Worksheet functions in MeasureSquare The order ...