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.
TermsProfit: 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
- 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.
- 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.
- 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 update my product catalog to enable the sell by: Original UOM in the worksheet for MeasureSquare 8
This article will show you how to set all the products in your existing product database that are set to Sell By Original UOM to use that unit in the worksheet in MeasureSquare 8. This article applied to MeasureSquare 8 Commercial Edition build 10345 ...