Speedi-Boot - Cost Calculator

  ABCDEFG
1 REGISTER BOOT INSTALLATION COST CALCULATOR
2 LABOR BURDEN $   VENT BOOTS PER
3 TASKSPEEDI-BOOTREGISTER BOOT
4 MINUTESLABOR $COSTS$MATERIAL $COSTS$MINUTESLABOR $COSTS$MATERIAL $COSTS$
5 ROUGH-IN           
6 SPEEDI-BOOT COST$
7 SPEEDI-BOOT INSTALL$
8 REGISTER BOOT COST$$$$
9 TOOL SET UP$$$$
10 SOURCE BOOT SUPPORT MATERIAL$$$$
11 INSTALL REGISTER BOOT MUD-RING$$$$
12 INSTALL REGISTER BOOT SUPPORT$$$$
13 INSTALL REGISTER BOOT$$$$
14 MASTIC SEAL REGISTER BOOT$$$$
15 INSTALL DUST & DEBRIS COVER$$$$
16 SEAL REGISTER BOOT TO SUBFLOOR / DRYWALL$$$$
17 CALL BACKS$$$$
18 Sub Total$$$$
19 Rough-In Total$$
20 TRIM-OUT           
21 PROTECT FLOOR & OR CLEAN$$$$
22 REFORM BOOT$$$$
23 CLEAN VENT BOOT$$$$
24 SEAL BOOT to BUILDING ENVELOPE$$$$
25 INSTALL TRIM$$$$
26 CLEAN DUCT SYSTEM$$$$
27 CLEAN FURNACE COILS$$$$
28 CALL BACKS$$$$
29 Sub Total$$$$
30 Trim-Out Total$$
31 Rough-In & Trim-Out TOTAL$$
32 ADMINISTRATIVE           
33 SCHEDULE - TESTING$$
34 INSPECTOR - RED TAGS$$
35 CALL BACK SCHEDULING$$
36 Administrative Total$$
37 Rough-Trim-Admin Total$$
38 TOTAL PROJECT COST$$
39 SAVINGS PER PROJECT$
40 TOTAL MAN HOURS SAVED$
41 ACTUAL PROJECT SAVINGS$

Instructions:

  1. Enter the Labor Burden in the yellow field in cell B2.
  2. Enter the # of Register Boots for each project in the yellow field in cell G2.
  3. Enter the # of Labor Minutes in the yellow fields for each task.
  4. Enter the Material Costs in the yellow fileds for each task.
  5. The Labor Costs based upon the Labor Burden will be calculated.
  6. The Labor Minutes and Material Costs totals will be calculated.
  7. The Total Project Cost will be provided based on the sum of each installation phase total.
  8. The Total Man Hours Saved is the difference in Speedi-Boot - Register Boot labor minutes divided by 60.
  9. The Actual Project Savings equals the Savings per Project plus the Man Hours Saved.