NHMS - Formulas

Here are a few formulas to help you check pricing and better understand the program.

Standard Pricing:  Builder contract pricing for Standard Areas.

P Area = (Net SF Qty / Sum (All Related P Area’s Net SF Qty)) * Related W Area Standard Price

RSA Area is a Whole Area = Sum (Related Standard Areas)

RSA Area is a Partial Area = (SF Takeoff Qty / Sum (All Related RSA Area’s SF Takeoff Qty)) * Related Whole Area Standard Price

All Other Areas = (Takeoff * Sell) + Standard Trim + Standard Underlayment + Standard SC

Standard Deduct:  Home Buyer Credit applied when an upgrade product/color is installed in a Standard Area.

Percentage Deduct Method

            P Area = Standard Price * Deduct %

            RSA Area = Standard Price * Deduct %

            All Other Areas = Standard Price

Manual Qty Deduct Method

            All Areas = (Manual Deduct Qty * Sell) + Standard Trim + Standard

Underlayment Based on Manual Deduct Qty + Standard SC

            Manual $ Deduct Method  

            All Areas = $ Amount entered into the Flooring Standards screen.

Additional Deducts:  Home Buyer Credit applied when the W Area is upgraded and a P Area does not have the same product/color installed.

Percentage Deduct Method

                        P Area = Deduct % * Upgrade Price

Manual Qty Deduct Method

                        P Area = (Manual Deduct Qty * Sell) + Upgrade Trim + Upgrade

Underlayment Based on Manual Deduct Qty + Upgrade SC – \          Standard Deduct

Distribute W Method

Builder = ((P Area CPTLF12 Takeoff * 12/9) / (Sum of all P Area CPTLF12 Takeoffs * 12/9)) * W Area Specification Sell Price

W Area Specification Sell Price = (W Takeoff * Upgrade Sell for Specification) - (W Takeoff * Standard Sell for Specification)

Calculate W Area Ordering Qty:  Used to calculate actual quantity to be ordered for the W Area and the W Area underlayment.

Percentage Deduct Method

            Qty Ordered = W Area Takeoff Qty - (Sum (Related P Area’s Takeoff Qty

With different product/color than the W Area) * Deduct %)                 

Manual Qty Deduct Method

            Qty Ordered = W Area Takeoff Qty - (Sum (Related P Area’s Manual

Deduct Qty with different product/color than the W Area) * Deduct %)

Based on Partial Takeoffs

Qty Ordered = Sum (All Related P Area’s Takeoff Qty with same product/color as W Area)

Qty’s will be converted to SF/SY as needed based on the unit of the Sell price.

 SF Takeoff Qty and Takeoff Qty are based on Category Type field on the Product Category screen.