Spreadsheet: 267390d1380061128-need-a-little-help-with-min-formula-and-formulas-in-range-option-coast-analysis-blank-130924
Sheet: Data Entry

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | PRECISION BUILDING SYSTEMS LLC | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | FOUNTAIN VALLEY ELECTRICAL | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | BMC  WEST CORPORATION | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | STEEL T HEATING | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME] / INSULATIONS,   INC | x
1 | Model |  | bla0700-701 | Cypress (bla0700-701) |  |  | [NAME] | 2090 |  | 11 | Model |  | tra0800-703 | Augusta (tra0800-703) |  |  | [NAME] | 2764 |  | 21 |  |  |  |  |  |  |  |  |  |  | 6 | JUST DETAILS PAINTING | x
 | Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | ARLUN   INC | x
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  |  |  |  |  |  |  |  |  |  | 8 | EL PASO  DRYWALL | x
 | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | M & M  DRYWALL  GROUP      32 | x
1 |  | 020 | Building Permits |  | 32728 | PIKES PEAK REGIONAL |  | 0 | 0 | 1 |  | 020 | Building Permits |  | 58746 | TOWN OF JOHNSTOWN |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 10 | HORIZON  DRYWALL   INC  68 | x
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1411483253588517 | 295 | 2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.05861070911722142 | 162 | 2 |  |  |  |  |  |  |  |  |  |  | 11 | PIKES PEAK REGIONAL | x
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1688995215311005 | 353 | 3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1360347322720695 | 376 | 3 |  |  |  |  |  |  |  |  |  |  | 12 | CUSTOM QUALITY PAINTING | x
4 |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 4 |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  |  | 13 | ILLUSIONS  PAINTING | x
5 |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 5 |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 5 |  |  |  |  |  |  |  |  |  |  | 14 | Pikes Peak Regional | x
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.138755980861244 | 290 | 6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1356729377713459 | 375 | 6 |  |  |  |  |  |  |  |  |  |  | 15 | COLORADO SYSTEMS CO | x
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.05263157894736842 | 110 | 7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.04703328509406658 | 130 | 7 |  |  |  |  |  |  |  |  |  |  | 16 | EASTSIDE HEATING | x
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1674641148325359 | 350 | 8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350 | 8 |  |  |  |  |  |  |  |  |  |  | 17 | BUILDERS INSULATION OF COLORADO  LLC | x
9 |  | 631 | Plumbing |  | 9781M | C + T  PLUMBING    LLC |  | 0.8851674641148326 | 1850 | 9 |  | 631 | Plumbing |  | 9846D | SPECTRUM  PLUMBING,  INC |  | 0 | 0 | 9 |  |  |  |  |  |  |  |  |  |  | 18 | WEST BROTHERS CONSTRUTION      15 | x
10 |  | 633 | Electrical |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.2392344497607655 | 500 | 10 |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1175832127351664 | 325 | 10 |  |  |  |  |  |  |  |  |  |  | 19 | DEER CREEK ELECTRIC | x
11 |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.2248803827751196 | 470 | 11 |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1447178002894356 | 400 | 11 |  |  |  |  |  |  |  |  |  |  | 20 | TOWN OF JOHNSTOWN | x
12 |  | 636 | Light Fixtures |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.0131578947368421 | 27.5 | 12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.03654124457308249 | 101 | 12 |  |  |  |  |  |  |  |  |  |  | 21 | ATRIUM DOOR & WINDOW | x
13 |  | 641 | Insulation |  | 83884 | [NAME] / INSULATIONS,   INC |  | 0 | 0 | 13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 13 |  |  |  |  |  |  |  |  |  |  | 22 | I.M.S.S | x
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.0861244019138756 | 180 | 14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05788712011577424 | 160 | 14 |  |  |  |  |  |  |  |  |  |  | 23 | R & M  DETAILING,  INC | x
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.05023923444976076 | 105 | 15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.07778581765557163 | 215 | 15 |  |  |  |  |  |  |  |  |  |  | 24 | MILGARD MFG COMPANY | x
16 |  | 646 | Paint |  | 6470S | JUST DETAILS PAINTING |  | 0.09569377990430623 | 200 | 16 |  | 646 | Paint |  | 4570S | ILLUSIONS  PAINTING |  | 0.1083574529667149 | 299.5 | 16 |  |  |  |  |  |  |  |  |  |  | 25 | TOWN OF CASTLE ROCK | x
17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.3660287081339713 | 765 | 17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2445730824891461 | 676 | 17 |  |  |  |  |  |  |  |  |  |  | 26 | C + T  PLUMBING    LLC
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.07894736842105263 | 165 | 18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05065123010130246 | 140 | 18 |  |  |  |  |  |  |  |  |  |  | 27 | THE  TOP  SHOP  INC
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 19 |  |  |  |  |  |  |  |  |  |  | 28 | MASCO  CABINETRY   LLC
20 |  | 743 | Drywall |  | 5738W | EL PASO  DRYWALL |  | 0.2751196172248804 | 575 | 20 |  | 743 | Drywall |  | 3443C | HORIZON  DRYWALL   INC  68 |  | 0.2677279305354559 | 740 | 20 |  |  |  |  |  |  |  |  |  |  | 29 | PREMIER  GLASS  SOLUTIONS,  INC
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5497607655502393 | 1149 | 21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5586107091172214 | 1544 | 21 |  |  |  |  |  |  |  |  |  |  | 30 | SPECTRUM  PLUMBING,  INC
22 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  | 31 | [NAME]
23 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  | 32 | ALSIDE  SUPPLY  CENTER
24 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  | 33 | PARAGON  PLUMBING & HEATING  LLC   143
25 |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | Total: | 7384.5 |  |  |  |  |  |  |  |  | Total: | 5993.5 |  |  |  |  |  |  |  |  | Total: | 0 |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
2 | Model |  | gva0700-701 | Cypress (gva0700-701) |  |  | [NAME] | 2090 |  | 12 | Model |  | mda0800-706 | Pinehurst (mda0800-706) |  |  | [NAME] | 2588 |  | 22 |  |  |  |  |  |  |  |  |  |  | 37
 | Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  |  |  |  |  |  |  |  |  |  | 39
 | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
1 |  | 020 | Building Permits |  | 64051 | MANAGER OF FINANCE |  | 0 | 0 | 1 |  | 020 | Building Permits |  | 73322 | TOWN OF CASTLE ROCK |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 41
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.07751196172248805 | 162 | 2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 42
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1354066985645933 | 283 | 3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0 | 2 |  |  |  |  |  |  |  |  |  |  | 43
4 |  | 502 | Windows |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 | 4 |  | 502 | Windows |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 | 3 |  |  |  |  |  |  |  |  |  |  | 44
5 |  | 504 | Window Install |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 | 5 |  | 504 | Window Install |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  |  | 45
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.138755980861244 | 290 | 6 |  | 538 | Trim & Doors - Material |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.1242503863987635 | 321.56 | 5 |  |  |  |  |  |  |  |  |  |  | 46
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.05263157894736842 | 110 | 7 |  | 588 | Hardware |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.06659582689335394 | 172.35 | 6 |  |  |  |  |  |  |  |  |  |  | 47
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1674641148325359 | 350 | 8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1352395672333848 | 350 | 7 |  |  |  |  |  |  |  |  |  |  | 48
9 |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.5741626794258373 | 1200 | 9 |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.7148377125193199 | 1850 | 8 |  |  |  |  |  |  |  |  |  |  | 49
10 |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.2129186602870813 | 445 | 10 |  | 633 | Electrical |  | 9797C | DEER CREEK ELECTRIC |  | 0.06761978361669242 | 175 | 9 |  |  |  |  |  |  |  |  |  |  | 50
11 |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1913875598086125 | 400 | 11 |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1816074188562597 | 470 | 10 |  |  |  |  |  |  |  |  |  |  | 51
12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.1119617224880383 | 234 | 12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.09582689335394128 | 248 | 11 |  |  |  |  |  |  |  |  |  |  | 52
13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 12 |  |  |  |  |  |  |  |  |  |  | 53
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.06985645933014355 | 146 | 14 |  | 643 | Countertops - Laminate |  | 38800 | COLORADO COUNTERTOPS |  | 0 | 0 | 13 |  |  |  |  |  |  |  |  |  |  | 54
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.05023923444976076 | 105 | 15 |  | 644 | Finish Carpentry |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.06027820710973725 | 156 | 14 |  |  |  |  |  |  |  |  |  |  | 55
16 |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1435406698564593 | 300 | 16 |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1738794435857805 | 450 | 15 |  |  |  |  |  |  |  |  |  |  | 56
17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.3665071770334928 | 766 | 17 |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.3330757341576507 | 862 | 16 |  |  |  |  |  |  |  |  |  |  | 57
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.0736842105263158 | 154 | 18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.0463678516228748 | 120 | 17 |  |  |  |  |  |  |  |  |  |  | 58
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18 |  |  |  |  |  |  |  |  |  |  | 59
20 |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.2277511961722488 | 476 | 20 |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.03863987635239567 | 100 | 19 |  |  |  |  |  |  |  |  |  |  | 60
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.8468899521531101 | 1770 | 21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0 | 0 | 20 |  |  |  |  |  |  |  |  |  |  | 61
22 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  | 62
23 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  | 63
24 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  | 64
25 |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  | Total: | 7191 |  |  |  |  |  |  |  |  | Total: | 5274.91 |  |  |  |  |  |  |  |  | Total: | 0 |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
3 | Model |  | mda0800-702 | Riviera (mda0800-702) |  |  | [NAME] | 2481 |  | 13 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  | 68
 | Option ID |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
1 |  | 020 | Building Permits |  | 73322 | TOWN OF CASTLE ROCK |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 72
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1213220475614672 | 301 | 1 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 73
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1805723498589279 | 448 | 2 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 74
4 |  | 502 | Windows |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 | 3 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 75
5 |  | 504 | Window Install |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 76
6 |  | 538 | Trim & Doors - Material |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.1558242644095123 | 386.6 | 5 |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  | 77
7 |  | 588 | Hardware |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.061515517936316 | 152.62 | 6 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  | 78
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1410721483272874 | 350 | 7 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 79
9 |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.7456670697299477 | 1850 | 8 |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  | 80
10 |  | 633 | Electrical |  | 9797C | DEER CREEK ELECTRIC |  | 0.1068117694478033 | 265 | 9 |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  | 81
11 |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1894397420395002 | 470 | 10 |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  | 82
12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.04917372027408303 | 122 | 11 |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  | 83
13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 12 |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  | 84
14 |  | 643 | Countertops - Laminate |  | 38800 | COLORADO COUNTERTOPS |  | 0 | 0 | 13 |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  | 85
15 |  | 644 | Finish Carpentry |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.06529625151148731 | 162 | 14 |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  | 86
16 |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.120918984280532 | 300 | 15 |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  | 87
17 |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.1596130592503023 | 396 | 16 |  |  |  |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  | 88
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.04836759371221282 | 120 | 17 |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  | 89
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18 |  |  |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  |  |  | 90
20 |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.1918581217251109 | 476 | 19 |  |  |  |  |  |  |  |  |  | 20
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4885126964933494 | 1212 | 20 |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | Total: | 7011.219999999999 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0
4 | Model |  | tra0800-701 | Cypress (tra0800-701) |  |  | [NAME] | 2090 |  | 14 |  |  |  |  |  |  |  |  |  | 25
 | Option ID |  | Description
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 | gms1 |  | Guest Master Suite #1
1 |  | 020 | Building Permits |  | 58746 | TOWN OF JOHNSTOWN |  | 0 | 0
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.07751196172248805 | 162 | 1 |  |  |  |  |  |  |  |  |  | 1
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1688995215311005 | 353 | 2 |  |  |  |  |  |  |  |  |  | 2
4 |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 3 |  |  |  |  |  |  |  |  |  | 3
5 |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  | 4
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.138755980861244 | 290 | 5 |  |  |  |  |  |  |  |  |  | 5
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.05263157894736842 | 110 | 6 |  |  |  |  |  |  |  |  |  | 6
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1674641148325359 | 350 | 7 |  |  |  |  |  |  |  |  |  | 7
9 |  | 631 | Plumbing |  | 9846D | SPECTRUM  PLUMBING,  INC |  | 0 | 0 | 8 |  |  |  |  |  |  |  |  |  | 8
10 |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1555023923444976 | 325 | 9 |  |  |  |  |  |  |  |  |  | 9
11 |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1913875598086125 | 400 | 10 |  |  |  |  |  |  |  |  |  | 10
12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.05167464114832536 | 108 | 11 |  |  |  |  |  |  |  |  |  | 11
13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 12 |  |  |  |  |  |  |  |  |  | 12
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.07655502392344497 | 160 | 13 |  |  |  |  |  |  |  |  |  | 13
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.05023923444976076 | 105 | 14 |  |  |  |  |  |  |  |  |  | 14
16 |  | 646 | Paint |  | 4570S | ILLUSIONS  PAINTING |  | 0.3004210526315789 | 627.88 | 15 |  |  |  |  |  |  |  |  |  | 15
17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.323444976076555 | 676 | 16 |  |  |  |  |  |  |  |  |  | 16
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.06698564593301436 | 140 | 17 |  |  |  |  |  |  |  |  |  | 17
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18 |  |  |  |  |  |  |  |  |  | 18
20 |  | 743 | Drywall |  | 3443C | HORIZON  DRYWALL   INC  68 |  | 0.2842105263157895 | 594 | 19 |  |  |  |  |  |  |  |  |  | 19
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5799043062200957 | 1212 | 20 |  |  |  |  |  |  |  |  |  | 20
22 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  | 21
23 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22
24 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 23
25 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | Total: | 5612.88 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0
5 | Model |  | bla0700-702 | Riviera (bla0700-702) |  |  | [NAME] | 2485 |  | 15 |  |  |  |  |  |  |  |  |  | 25
 | Option ID |  | Description
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 | gms1 |  | Guest Master Suite #1
1 |  | 020 | Building Permits |  | 32728 | PIKES PEAK REGIONAL |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  | 1
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1211267605633803 | 301 | 2 |  |  |  |  |  |  |  |  |  | 2
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1802816901408451 | 448 | 3 |  |  |  |  |  |  |  |  |  | 3
4 |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  | 4
5 |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 5 |  |  |  |  |  |  |  |  |  | 5
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1167002012072435 | 290 | 6 |  |  |  |  |  |  |  |  |  | 6
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.03822937625754527 | 95 | 7 |  |  |  |  |  |  |  |  |  | 7
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1408450704225352 | 350 | 8 |  |  |  |  |  |  |  |  |  | 8
9 |  | 631 | Plumbing |  | 9781M | C + T  PLUMBING    LLC |  | 0.744466800804829 | 1850 | 9 |  |  |  |  |  |  |  |  |  | 9
10 |  | 633 | Electrical |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.2012072434607646 | 500 | 10 |  |  |  |  |  |  |  |  |  | 10
11 |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1891348088531187 | 470 | 11 |  |  |  |  |  |  |  |  |  | 11
12 |  | 636 | Light Fixtures |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.01509054325955735 | 37.5 | 12 |  |  |  |  |  |  |  |  |  | 12
13 |  | 641 | Insulation |  | 83884 | [NAME] / INSULATIONS,   INC |  | 0 | 0 | 13 |  |  |  |  |  |  |  |  |  | 13
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05955734406438631 | 148 | 14 |  |  |  |  |  |  |  |  |  | 14
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.04225352112676056 | 105 | 15 |  |  |  |  |  |  |  |  |  | 15
16 |  | 646 | Paint |  | 6470S | JUST DETAILS PAINTING |  | 0.08048289738430585 | 200 | 16 |  |  |  |  |  |  |  |  |  | 16
17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2981891348088531 | 741 | 17 |  |  |  |  |  |  |  |  |  | 17
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.06639839034205232 | 165 | 18 |  |  |  |  |  |  |  |  |  | 18
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 19 |  |  |  |  |  |  |  |  |  | 19
20 |  | 743 | Drywall |  | 5738W | EL PASO  DRYWALL |  | 0.3018108651911469 | 750 | 20 |  |  |  |  |  |  |  |  |  | 20
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4812877263581489 | 1196 | 21 |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | Total: | 7646.5 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0
6 | Model |  | gva0700-702 | Riviera (gva0700-702) |  |  | [NAME] | 2485 |  | 16 |  |  |  |  |  |  |  |  |  | 26
 | Option ID |  | Description
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 | gms1 |  | Guest Master Suite #1
1 |  | 020 | Building Permits |  | 64051 | MANAGER OF FINANCE |  | 0 | 0
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  | 1
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1553319919517103 | 386 | 2 |  |  |  |  |  |  |  |  |  | 2
4 |  | 502 | Windows |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 | 3 |  |  |  |  |  |  |  |  |  | 3
5 |  | 504 | Window Install |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  | 4
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1167002012072435 | 290 | 5 |  |  |  |  |  |  |  |  |  | 5
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.03822937625754527 | 95 | 6 |  |  |  |  |  |  |  |  |  | 6
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1408450704225352 | 350 | 7 |  |  |  |  |  |  |  |  |  | 7
9 |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.482897384305835 | 1200 | 8 |  |  |  |  |  |  |  |  |  | 8
10 |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1790744466800805 | 445 | 9 |  |  |  |  |  |  |  |  |  | 9
11 |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1609657947686117 | 400 | 10 |  |  |  |  |  |  |  |  |  | 10
12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.07887323943661972 | 196 | 11 |  |  |  |  |  |  |  |  |  | 11
13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 12 |  |  |  |  |  |  |  |  |  | 12
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05150905432595573 | 128 | 13 |  |  |  |  |  |  |  |  |  | 13
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.04225352112676056 | 105 | 14 |  |  |  |  |  |  |  |  |  | 14
16 |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1207243460764588 | 300 | 15 |  |  |  |  |  |  |  |  |  | 15
17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.3082494969818914 | 766 | 16 |  |  |  |  |  |  |  |  |  | 16
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05754527162977868 | 143 | 17 |  |  |  |  |  |  |  |  |  | 17
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18 |  |  |  |  |  |  |  |  |  | 18
20 |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.1915492957746479 | 476 | 19 |  |  |  |  |  |  |  |  |  | 19
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.7122736418511066 | 1770 | 20 |  |  |  |  |  |  |  |  |  | 20
22 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  | 21
23 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22
24 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 23
25 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | Total: | 7050 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0
7 | Model |  | tra0800-702 | Riviera (tra0800-702) |  |  | [NAME] | 2485 |  | 17 |  |  |  |  |  |  |  |  |  | 27
 | Option ID |  | Description
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 | gms1 |  | Guest Master Suite #1
1 |  | 020 | Building Permits |  | 58746 | TOWN OF JOHNSTOWN |  | 0 | 0
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.06519114688128773 | 162 | 1 |  |  |  |  |  |  |  |  |  | 1
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1802816901408451 | 448 | 2 |  |  |  |  |  |  |  |  |  | 2
4 |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 3 |  |  |  |  |  |  |  |  |  | 3
5 |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  | 4
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1167002012072435 | 290 | 5 |  |  |  |  |  |  |  |  |  | 5
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.03822937625754527 | 95 | 6 |  |  |  |  |  |  |  |  |  | 6
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1408450704225352 | 350 | 7 |  |  |  |  |  |  |  |  |  | 7
9 |  | 631 | Plumbing |  | 9846D | SPECTRUM  PLUMBING,  INC |  | 0 | 0 | 8 |  |  |  |  |  |  |  |  |  | 8
10 |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.130784708249497 | 325 | 9 |  |  |  |  |  |  |  |  |  | 9
11 |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1609657947686117 | 400 | 10 |  |  |  |  |  |  |  |  |  | 10
12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.0744466800804829 | 185 | 11 |  |  |  |  |  |  |  |  |  | 11
13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 12 |  |  |  |  |  |  |  |  |  | 12
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05150905432595573 | 128 | 13 |  |  |  |  |  |  |  |  |  | 13
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.04225352112676056 | 105 | 14 |  |  |  |  |  |  |  |  |  | 14
16 |  | 646 | Paint |  | 4570S | ILLUSIONS  PAINTING |  | 0.3266237424547284 | 811.66 | 15 |  |  |  |  |  |  |  |  |  | 15
17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2643863179074447 | 657 | 16 |  |  |  |  |  |  |  |  |  | 16
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.03822937625754527 | 95 | 17 |  |  |  |  |  |  |  |  |  | 17
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18 |  |  |  |  |  |  |  |  |  | 18
20 |  | 743 | Drywall |  | 3443C | HORIZON  DRYWALL   INC  68 |  | 0.2531187122736419 | 629 | 19 |  |  |  |  |  |  |  |  |  | 19
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4877263581488934 | 1212 | 20 |  |  |  |  |  |  |  |  |  | 20
22 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  | 21
23 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22
24 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 23
25 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | Total: | 5892.66 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0
8 | Model |  | bla0700-703 | Augusta (bla0700-703) |  |  | [NAME] | 2764 |  | 18 |  |  |  |  |  |  |  |  |  | 28
 | Option ID |  | Description
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 | gms1 |  | Guest Master Suite #1
1 |  | 020 | Building Permits |  | 32728 | PIKES PEAK REGIONAL |  | 0 | 0
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1132416787264834 | 313 | 1 |  |  |  |  |  |  |  |  |  | 1
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1360347322720695 | 376 | 2 |  |  |  |  |  |  |  |  |  | 2
4 |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 3 |  |  |  |  |  |  |  |  |  | 3
5 |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  | 4
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1356729377713459 | 375 | 5 |  |  |  |  |  |  |  |  |  | 5
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.04703328509406658 | 130 | 6 |  |  |  |  |  |  |  |  |  | 6
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350 | 7 |  |  |  |  |  |  |  |  |  | 7
9 |  | 631 | Plumbing |  | 9781M | C + T  PLUMBING    LLC |  | 0.6693198263386397 | 1850 | 8 |  |  |  |  |  |  |  |  |  | 8
10 |  | 633 | Electrical |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.1808972503617945 | 500 | 9 |  |  |  |  |  |  |  |  |  | 9
11 |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1700434153400869 | 470 | 10 |  |  |  |  |  |  |  |  |  | 10
12 |  | 636 | Light Fixtures |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.01356729377713459 | 37.5 | 11 |  |  |  |  |  |  |  |  |  | 11
13 |  | 641 | Insulation |  | 83884 | [NAME] / INSULATIONS,   INC |  | 0 | 0 | 12 |  |  |  |  |  |  |  |  |  | 12
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.06512301013024602 | 180 | 13 |  |  |  |  |  |  |  |  |  | 13
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.07778581765557163 | 215 | 14 |  |  |  |  |  |  |  |  |  | 14
16 |  | 646 | Paint |  | 6470S | JUST DETAILS PAINTING |  | 0.07235890014471781 | 200 | 15 |  |  |  |  |  |  |  |  |  | 15
17 |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2767727930535456 | 765 | 16 |  |  |  |  |  |  |  |  |  | 16
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05969609261939219 | 165 | 17 |  |  |  |  |  |  |  |  |  | 17
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18 |  |  |  |  |  |  |  |  |  | 18
20 |  | 743 | Drywall |  | 5738W | EL PASO  DRYWALL |  | 0.1628075253256151 | 450 | 19 |  |  |  |  |  |  |  |  |  | 19
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4822720694645442 | 1333 | 20 |  |  |  |  |  |  |  |  |  | 20
22 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  | 21
23 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22
24 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 23
25 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | Total: | 7709.5 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0
9 | Model |  | gva0700-703 | Augusta (gva0700-703) |  |  | [NAME] | 2764 |  | 19 |  |  |  |  |  |  |  |  |  | 29
 | Option ID |  | Description
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 | gms1 |  | Guest Master Suite #1
1 |  | 020 | Building Permits |  | 64051 | MANAGER OF FINANCE |  | 0 | 0
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  | 1
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1465267727930535 | 405 | 2 |  |  |  |  |  |  |  |  |  | 2
4 |  | 502 | Windows |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 | 3 |  |  |  |  |  |  |  |  |  | 3
5 |  | 504 | Window Install |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  | 4
6 |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1356729377713459 | 375 | 5 |  |  |  |  |  |  |  |  |  | 5
7 |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.04703328509406658 | 130 | 6 |  |  |  |  |  |  |  |  |  | 6
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350 | 7 |  |  |  |  |  |  |  |  |  | 7
9 |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.4341534008683068 | 1200 | 8 |  |  |  |  |  |  |  |  |  | 8
10 |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1609985528219971 | 445 | 9 |  |  |  |  |  |  |  |  |  | 9
11 |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1447178002894356 | 400 | 10 |  |  |  |  |  |  |  |  |  | 10
12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.07091172214182344 | 196 | 11 |  |  |  |  |  |  |  |  |  | 11
13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 12 |  |  |  |  |  |  |  |  |  | 12
14 |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.052821997105644 | 146 | 13 |  |  |  |  |  |  |  |  |  | 13
15 |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.07778581765557163 | 215 | 14 |  |  |  |  |  |  |  |  |  | 14
16 |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1085383502170767 | 300 | 15 |  |  |  |  |  |  |  |  |  | 15
17 |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.178726483357453 | 494 | 16 |  |  |  |  |  |  |  |  |  | 16
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05571635311143271 | 154 | 17 |  |  |  |  |  |  |  |  |  | 17
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18 |  |  |  |  |  |  |  |  |  | 18
20 |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.2329956584659914 | 644 | 19 |  |  |  |  |  |  |  |  |  | 19
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.6403762662807525 | 1770 | 20 |  |  |  |  |  |  |  |  |  | 20
22 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  | 21
23 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  | 22
24 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 23
25 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | Total: | 7224 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0
10 | Model |  | mda0800-703 | Augusta (mda0800-703) |  |  | [NAME] | 2764 |  | 20
 | Option ID |  | Description
 |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 | gms1 |  | Guest Master Suite #1
1 |  | 020 | Building Permits |  | 73322 | TOWN OF CASTLE ROCK |  | 0 | 0
2 |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1132416787264834 | 313 | 1
3 |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1360347322720695 | 376 | 2
4 |  | 502 | Windows |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 | 3
5 |  | 504 | Window Install |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 | 4
6 |  | 538 | Trim & Doors - Material |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.1720369030390738 | 475.51 | 5
7 |  | 588 | Hardware |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.07146888567293777 | 197.54 | 6
8 |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350 | 7
9 |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.6693198263386397 | 1850 | 8
10 |  | 633 | Electrical |  | 9797C | DEER CREEK ELECTRIC |  | 0.09587554269175108 | 265 | 9
11 |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0 | 0 | 10
12 |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.03654124457308249 | 101 | 11
13 |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 | 12
14 |  | 643 | Countertops - Laminate |  | 38800 | COLORADO COUNTERTOPS |  | 0 | 0 | 13
15 |  | 644 | Finish Carpentry |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.0658465991316932 | 182 | 14
16 |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1085383502170767 | 300 | 15
17 |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.1534008683068017 | 424 | 16
18 |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.04920405209840811 | 136 | 17
19 |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 | 18
20 |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.2329956584659914 | 644 | 19
21 |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5586107091172214 | 1544 | 20
22 |  |  |  |  |  |  |  |  |  | 21
23 |  |  |  |  |  |  |  |  |  | 22
24 |  |  |  |  |  |  |  |  |  | 23
25 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | Total: | 7158.05 |  |  |  |  |  |  |  |  | Total: | 0 |  |  |  |  |  |  |  |  | Total: | 0