Spreadsheet: 886523d1736538026-auto-populate-cell-after-selecting-multiple-drop-down-lists-field-quote-
Sheet: AluminumProducts

Unit Percentage Price Increase: |  | 0.03 | Enter Decimal Value
Aluminum Panel | Part Number | Unit Cost | [NAME] Cost | [NAME] Cost/TAX | Adjusted Unit Cost
200 SERIES 54 X 6 POOL BLK | FAFENCEDY-DYBL-2054 | 58.34
300 SERIES 54 X 6 POOL BLK | FAFENCEDY-DYBL-3054 | 58.34
400 SERIES 48 X 6 POOL BLK | FAFENCEDY-DYBL-4048 | 51.05
Aluminum Gates | Part Number | Unit Cost | [NAME] Cost | [NAME] Cost/TAX | Adjusted Unit Cost
200 54" X 4' FLAT TOP GATE BLK | FAGATE-20BL-0545 | 140.51
200 54" X 4' ARCH TOP GATE BLK | FAGATE-20BL-0645 | 155.3
200 54" X 5' FLAT TOP GATE BLK | FAGATE-20BL-0955 | 155.3
200 54" X 5' ARCH TOP GATE BLK | FAGATE-20BL-1055 | 170.09
200 54" X 5' SWOOP GATE BL | FAGATE-20BL-1155 | 170.09
300 54" X 4' FLAT TOP GATE BLK | FAGATE-30BL-0545 | 140.51
300 54" X 4' ARCH TOP GATE BLK | FAGATE-30BL-0645 | 155.3
300 54" X 5' FLAT TOP GATE BLK | FAGATE-30BL-0955 | 155.3
300 54" X 5' ARCH TOP GATE BLK | FAGATE-30BL-1055 | 170.09
300 54" X 5' SWOOP TOP GATE BL | FAGATE-30BL-1155 | 170.09
400 4' X 4' FLAT TOP GATE BLK | FAGATE-40BL-0144 | 125.72
400 4' X 5' FLAT TOP GATE BLK | FAGATE-40BL-0145 | 140.51
400 4' X 4' ARCH TOP GATE BLK | FAGATE-40BL-0244 | 140.51
400 4' X 5' ARCH TOP GATE BLK | FAGATE-40BL-0245 | 155.3
Aluminum Posts | Part Number | Unit Cost | [NAME] Cost | [NAME] Cost/TAX | Adjusted Unit Cost
200P BLANK GATE POST 79" BLK | FAPOSTDY-2PBL-79BL | 15.77
200P CORNER POST 2" X 79" BLK | FAPOSTDY-2PBL-79CR | 15.77
200P END POST 2" X 79" BLK | FAPOSTDY-2PBL-79EN | 15.77
200P END GATE POST 2.5" BLK | FAPOSTDY-2PBL-79GL | 57.83
200P END GATE POST 2"  BLK | FAPOSTDY-2PBL-79GT | 26.16
200P LINE POST 2" X 79" BLK | FAPOSTDY-2PBL-79LN | 15.77
300P BLANK GATE  POST 79" BLK | FAPOSTDY-3PBL-79BL | 15.77
300P CORNER POST 2" X 79" BLK | FAPOSTDY-3PBL-79CR | 15.77
300P END POST 2" X 79" BLK | FAPOSTDY-3PBL-79EN | 15.77
300P END GATE POST 2.5" BLK | FAPOSTDY-3PBL-79GL | 57.83
300P END GATE POST 2" BLK | FAPOSTDY-3PBL-79GT | 26.16
300P LINE POST 2" X 79" BLK | FAPOSTDY-3PBL-79LN | 15.77
400 BLANK GATE  POST 72" BLK | FAPOSTDY-40BL-72BL | 14.98
400 CORNER POST 2" X 72" BLK | FAPOSTDY-40BL-72CR | 14.98
400 END POST 2" X 72" BLK | FAPOSTDY-40BL-72EN | 14.98
400 END GATE POST 2.5" BLK | FAPOSTDY-40BL-72GL | 55.08
400 END GATE POST 2" BLK | FAPOSTDY-40BL-72GT | 24.97
400 LINE POST 2" X 72" BLK | FAPOSTDY-40BL-72LN | 14.98
[NAME] | Part Number | Unit Cost | [NAME] Cost | [NAME] Cost/TAX | Adjusted Unit Cost
Hinge Set
4" SELF CLOSING HINGE BLACK | FAZHINGE-1BLK-14SH | 21.77
5" SELF CLOSING HINGE BLACK | FAZHINGE-1BLK-25SH | 21.77
5" SELF CLOSING HINGE WHITE | FAZHINGE-2WH-25SH | 21.77
[NAME] | Part Number | Unit Cost | [NAME] Cost | [NAME] Cost/TAX | Adjusted Unit Cost
2" STD GRAVITY LATCH BLACK | FAZLATCH-1ABL-12GL | 7.25
BRASS LATCH | FAZLATCH-3BRS-13BL | 32.69
[NAME]. | Part Number | Unit Cost | [NAME] Cost | [NAME] Cost/TAX | Adjusted Unit Cost
2" BALL CAP BLK | FAZMISC-BLK-2BLC | 4.96
2" FLAT CAP BLK | FAZMISC-BLK-2FLC | 1.48
2 PIECE FLOOR MOUNT BLK | FAZMISC-BLK-2FLM | 9.61
2" QUAD FINIAL BLK | FAZMISC-BLK-2QFI | 1.48
2" TRI FINIAL BLK | FAZMISC-BLK-2TRF | 1.48
DECORATIVE SCROLL BLK | FAZMISC-BLK-DECO | 3.25
TOUCH UP PAINT BLK | FAZMISC-BLK-PANT | 5.25
SWIVEL WALL MOUNT BLK | FAZMISC-BLK-SWVL | 3.25
WALL MOUNT BLK | FAZMISC-BLK-WALM | 2.5
2" BALL CAP WH | FAZMISC-WH-2BLC | 4.96
2" FLAT CAP WH | FAZMISC-WH-2FLC | 1.48
2 PIECE FLOOR MOUNT WH | FAZMISC-WH-2FLM | 9.61
2" QUAD FINIAL WH | FAZMISC-WH-2QFI | 1.48
2" TRI FINIAL WH | FAZMISC-WH-2TRF | 1.48
DECROTIVE SCROLL WH | FAZMISC-WH-DECO | 3.25
TOUCH UP PAINT WH | FAZMISC-WH-PANT | 5.25
SWIVEL WALL MOUNT WH | FAZMISC-WH-SWVL | 3.25
WALL MOUNT WH | FAZMISC-WH-WALM | 2.5