A lot of our LMN users bid on projects that ask for Unit Pricing and while it is not actually built into our Estimating system, there is a way to make it work!
First, you want to build your estimate in LMN to your bid form. Use Standard estimates to build unit pricing.
For example, lets look at a Planting bid form:
In LMN, we are going to setup each tree as a work area.
WorkArea Name: Katsura Tree
- add equipment
- add labor
- add material item
Once you have completed setting up each work area for each tree with the associated labor, material and equipment costs click the print tab at the top right of the screen.
Choose Report: Customer Proposal
Output as: Microsoft Excel
Open your excel file
1. Highlight the pricing column
2. Click "Find & Select"
- Choose Go to special...
- Choose blanks and click ok
3. Now, keeping that pricing column highlighted click Delete
- Choose Sheet Rows
4. Delete all any footers
5. Add quantity for each line item in a new column beside the pricing
Then beside the Quantity Column Enter the equals sign (=) the Pricing column Letter and row # divided by the Quantity Column Letter and row #:
(Total Price divided by the Quantity)
=(A12/AJ2) - press enter and this will give you your unit rate
Once you have your unit rate, we need to make sure that it is rounding the numbers so that you are not losing any money when bidding. LMN is set up so that it only rounds to the nearest 100th so it won't give you the correct unit pricing - it might be off by a couple of cents.
To add the rounding factor:
In the column beside the Quantity Enter:
=roundup(select the unit price, and then the total price) and hit enter
This will round your unit pricing up.
Take the first example:
If you were to take the total price from LMN 945.99 and divide that by the quantity LMN would have produced 189.19 as the unit price.
It doesn't take into account that third number 189.198 - it should really be rounded to 189.20.
So you would be losing 1 cent.