Z Roofing Pricing Formula Checker

Verifying formulas from: ZRW Pricing Engine.xlsm

Admin

📐 Roof Measurements

Dashboard C19

Dashboard E19

Dashboard C23

Dashboard G19 / D23

Total Pitched:
Total Flat:

Materials D4+F4

Materials B4

Dashboard H19

Auto-sets Difficulty

Labor mapping F2-F4

Labor mapping A2-A5

Labor mapping L2: $0.75/sqft per layer

Labor mapping W2-W4

🏠 Roofing System

📦 Materials Calculator

Schemas + Parts List

⬤ = Default | Source: ZRW Parts List

⬤ = Default | Source: ZRW Parts List

⚠️ Metal Roofing - Not in Source Excel

Metal pricing requires supplier quote. Enter values below:

Typical ranges: Standing Seam ~100-150 lbs/sq | Corrugated ~50-100 lbs/sq | Stone-coated ~150-200 lbs/sq

💡 Get weight from manufacturer spec sheet. Enter material cost in "Manual Override" below.

📌 Pick-One Options (choose material type)

⬤ = Default | Source: ZRW Parts List

📦 Required Basic Materials

Schemas + Parts List
Basic Materials Subtotal
Basic Materials Subtotal

💡 Edit unit prices above if needed. Add vents, wood, upgrades via Manual Override below.

✓ Auto-calculated from above

⚠️ Source: Materials!SUM(H:H) - Enter actual value from Excel

✓ Typical: Shingle $1.95 | Tile $3.00 | Metal $3.00 (Labor!C6+C7 manual entry)

Auto-Calculated Labor:

H12 (Base): ( + ) × $ =

H14 (Pitch Premium): Base × ( - 1) =

H15 (Access Premium): Base × ( - 1) =

C32 = SUM(H12,H14,H15):

✓ Source: ZRW pricing engine with Macros.xlsm → Labor!H12=(B4+C4)*C12, H14=H12*(C14-1), H15=H12*(C15-1)

Source: ZRW pricing engine with Macros.xlsm → Parts List

🏠 SHINGLES

ProductPriceCoverageRow
GAF 3-Tab Royal$23.25per sq55
GAF Timberline HD$30.33per sq199
GAF Timberline 40yr$84.00per sq223
Owens Corning 3-Tab$23.16per sq254
IKO Cambridge Dim.$24.00per sq235
GAF Seal-a-Ridge$45.0025 LF219
GAF Starter Strip$46.50120 LF229

🧱 TILES

ProductPriceCoverageRow
Barcelona 900 Standard$350.87150.5 sqft127
Barcelona 900 Premium$175.33150.5 sqft125
Altusa S Clay Standard$187.65per sq116
Santa Fe Clay Red$139.50per sq286
Tile Ridge/Hip$2.80-3.05each126-128
Bird Stop 10'$15.9510 LF129

📜 UNDERLAYMENTS

ProductPriceCoverageRow
Polyglass TU Plus$84.002 sq/roll271
Polyglass TU Granule$76.16per roll272
#90 Tamko Tile$36.48per roll10
#90 Self Adhere$64.44per roll9
GAF Storm Guard$68.502 sq/roll220
#30 Felt ASTM$39.952 sq/roll5

🔧 METALS

ProductPriceCoverageRow
16" Valley 26Ga 50'$58.7550 LF36
16" Aluminum Valley 50'$128.0050 LF35
3x3 Drip Eave 10'$7.009.5 LF62
4x4 Drip Eave 10'$11.529.5 LF82
3" Ridge Nailer$17.0010 LF56
4" Ridge Nailer$18.0010 LF73

👷 LABOR MULTIPLIERS (Labor mapping sheet)

Pitch (A1-A5):

Easy (1-3:12): 1.00x
Medium (4-6:12): 1.05x
Hard (7-10:12): 1.30x
Boom Required: 1.30x

Access (F1-F4):

Good: 1.00x
Hard: 1.15x
Hand Carry: 1.30x

Additional Items (✓ Verified in Excel)

Business Rules (✓ Verified)

C26 → C39

⚠️ Below 20% (D26/E26 warning)

C38: =0.12*SUM

C40: =0.03*SUM

All *1.1 formulas

💰

Total Estimate

C42

Per Square

Total Squares

sq

Roof Type

With Waste

+%

📊 Cost Breakdown Dashboard Column C

C30 Materials =SUM(Materials!H:H)
C31 Sales Tax =0.07×C30
C32 Labor =SUM(Labor!H12,H14,H15)
├ H12 Base (+)×$
├ H14 Pitch Premium ×
└ H15 Access Premium ×
C33 Heavy Equipment Boom Req
$2,000.00
C34 Tile Debris
$150.00
C35 Bird Stop LF × $1.595
C36 Dump Fees tons × $/ton
tons × $/ton ( lbs/sq)
C37 Permit =0.25×C19
SUM(C30:C37)
C38 Overhead %

PROFIT & MARGIN

C39 Gross Profit =C26×SUM
C40 Commission %
C41 Net Profit =C39-C40
C42 TOTAL ESTIMATE

Formula Verification

📁 Data Sources

ZRW pricing engine with Macros.xlsm

Dashboard (C30-C43), Materials (H:H), Labor (H12-H15), Labor mapping (multipliers, weights S2-S6, dump rates W2-W4), Parts List (unit prices)

Roof Mat. Weights (Tile & Shingle).xlsx

Reference only - actual weights in Labor mapping S2-S6 (Shingle 286, Tile 1170, Clay 864.5 lbs/sq)

ABC - Tile Pricing [Jan 2024].xlsx

Tile product pricing for ABC supplier

Gulf Eagle 2025 STANDARD PRICE LIST.xlsx

Gulf Eagle tile product pricing

✅ Verified Formulas (Dashboard Worksheet)

Cell
Formula
Description
C30
=SUM(Materials!H:H)
Materials total
C31
=0.07*C30
7% sales tax
C32
=SUM(Labor!H12,H14,H15)
Labor costs
C33
=IF(D15="Boom Req",2000,0)
$2,000 boom lift
C34
=IF(OR(B19="Concrete Tile"...),150,0)
$150 tile debris
C35
=H19*$1.595 (Row 129: $15.95/10LF)
Bird stop (tile)
C36
=MAX(sq/ton,1)×$/ton
Dump fees (weight-based)
C37
=0.25*(C19)
Permit 25¢/sqft pitched
C54
=0.26*(C23)
Permit 26¢/sqft flat
C38
=0.12*SUM(C30:C37)
12% overhead
C39
=C26*SUM(C30:C38)
Profit margin
C40
=0.03*SUM(C30:C39)
3% commission
C41
=C39-C40
Net profit
C42
=SUM(C30:C38)+C40+C41
TOTAL
C43
=C42/SUM(C19,E19,G19)
Price per sq ft
ALL
*1.1
10% waste factor

📝 Manual Entry (from Excel)

Materials Cost
Enter from Materials!SUM(H:H)
Labor Rate
Manual entry Labor!C6+C7 (Shingle ~$1.95, Tile $3.00, Metal $3.00)

📊 Dump Fee Data

County rates: Labor mapping W2-W4 | Weights: Labor mapping S2-S6

County
$/Ton
Material (lbs/sq)
Broward (W2)
$56.00
Shingle Dim (S3): 286
Miami-Dade (W3)
$59.40
Concrete Tile (S4): 1,170
Palm Beach (W4)
$54.00
Clay Tile (S5): 864.5

Calculation Trace

C30 Materials:
C31 Tax (C30×0.07):
C32 Labor:
⚠️ Tear-off Labor: ($0.75/sqft × layers × sqft)
C33 Boom:
C34 Tile Debris:
C35 Bird Stop:
C36 Dump: ( tons × $) (× layers)
C37 Permit: (=$0.25×pitched + $0.26×flat)
SUM(C30:C37):
C38 Overhead (×):
SUM(C30:C38):
C39 PM (×):
C40 Comm ((C30:C39)×):
C41 Net PM (C39-C40):
C42 TOTAL:
Formula check: SUM(C30:C38) + C40 + C41 =