Spreadsheet: 774460d1648486345-lookup-i-cant-figure-out-strategic-resources-diaphragms-quotes-1
Sheet: Teflon Diaphragm Pricing

Customer | Part Number | Revision | Date | Quantity | Rolled Up Cost | % Mark Up | G & A Marked Up Price | Vendor | CDI | Blank | Pieces | $ / Ea | Total | % Mark Up | Material Price Each | Scrap % | Scrap Value | Lot/Tooling/Set Up | Price | % Mark Up | Sub-Total | Lot/Tooling/Set Up | Price | % Mark Up | Sub-Total | Lot/Tooling/Set Up | Price | % Mark Up | Sub-Total | Lot/Tooling/Set Up | Price | % Mark Up | Sub-Total | Lot/Tooling/Set Up | Price | % Mark Up | Sub-Total | Lot/Tooling/Set Up | Price | % Mark Up | Sub-Total | [NAME] R/T | [NAME] | Sub-Total | Lathe R/T | [NAME] | Sub-Total | [NAME] R/T | [NAME] | Sub-Total | Inspection/Assembly | [NAME] | Sub-Total | Lathe Setup Quantity | Price | Price/Part | [NAME] Quantity | Price | Price/Part | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | Parts/OP | Qty. Per | Price Ea. | % Mark Up | Sub-Total | 12 Month FOH | Current Sell Price |  | Notes
[NAME] | WIL-00-1044-55 | C | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 02-075 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | 75 |  | 30 | 71 |  | 15 | 71 |  |  |  |  |  |  |  |  |  |  | Box Price $0.68 / 60 Pcs. | 1 | 0.01 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.09
[NAME] | WIL-01-1010-55 | K | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 01-055 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 288 Pcs. | 1 | 0.01 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.56
[NAME] | WIL-01-1044-55 | F | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 02-093 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | 75 |  | 39 | 71 |  | 30 | 71 |  |  |  |  |  |  |  |  |  |  | Box Price $0.68 / 60 Pcs. | 1 | 0.01 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.99
[NAME] | WIL-02-1010-55 | R | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 02-075 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 120 Pcs. | 1 | 0.01 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.81
[NAME] | WIL-02-1011-55 | B | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 02-075 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.68 / 24 Pcs. | 1 | 0.03 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.45
[NAME] | WIL-02-1040-55 | E | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 02-075 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 120 Pcs. | 1 | 0.01 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.95
[NAME] | WIL-04-1010-55 | M | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 04-093 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 28 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.52
[NAME] | WIL-04-1010-55-42 | C | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 04-093 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 2 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24.02
[NAME] | WIL-04-1040-55 | G | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 04-075 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.35
[NAME] | WIL-04-1040-55-42 | C | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 04-075 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 2 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.61
[NAME] | WIL-08-1010-55 | N | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 08-108 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39.4
[NAME] | WIL-08-1010-55-42 | C | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 08-108 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 2 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.9
[NAME] | WIL-08-1011-55 | D | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 08-108 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 2 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44.75
[NAME] | WIL-08-1040-55 | G | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 08-108 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.47
[NAME] | WIL-08-1040-55-42 | B | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 08-108 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $0.82 / 48 Pcs. | 1 | 0.02 | 15 |  | Bag Price $0.058 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 2 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.75
[NAME] | WIL-15-1010-55 | R | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 15-140 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $1.18 / 24 Pcs. | 1 | 0.05 | 15 |  | Bag Price $0.122 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93.54
[NAME] | WIL-15-1010-55-42 | R | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 15-140 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $1.18 / 24 Pcs. | 1 | 0.05 | 15 |  | Bag Price $0.122 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 2 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95.04
[NAME] | WIL-15-1040-55 | F | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 15-108 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $1.18 / 24 Pcs. | 1 | 0.05 | 15 |  | Bag Price $0.122 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69.47
[NAME] | WIL-15-1040-55-42 | E | 2022-03-09 00:00:00 | 1 |  |  |  |  |  | 15-108 | 1 |  |  | 15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box Price $1.18 / 24 Pcs. | 1 | 0.05 | 15 |  | Bag Price $0.122 / 12 Pcs. | 1 | 0.01 | 15 |  | Trim | 1 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69.75
 |  |  |  | 1 |  |  |  |  |  |  | 1
 |  |  |  | 1 |  |  |  |  |  |  | 1