Using the Lab2.xls file continue to update this spreadsheet to create the following worksheet:
You will use Microsoft Excel spreadsheet software to sort the Lab 2 data by criteria such as item description, item cost, vendor number, vendor name, or A/P terms. A/P Terms is expressed as the number of days that the customer has to pay the vendor for a purchase. In other words, 30 designates net 30 days. The vendor that allows customers the longest time to pay for an order would offer the most favorable payment terms. You need to complete the following tasks:
Create a Product Costs worksheet to determine the vendor with the lowest price for the same item when it is supplied by multiple vendors. You can filter the data using the Item Description column. This filters list can be sorted by Item Cost and Vendor Number. Include the following columns in the solution:
Order Number
Item Number
Item Description
Item Cost
Quantity
Cost Per Order
A/P Terms
Order Date
Arrival Date
Delivery Days (Delivery Days is Arrival Date - Order Date
K3 B c D E F G H 1 2 Orders and Suppliers Vendor No 2 6 0 0 1243 6489 4 Vendor Name 5 Spacetime Technologies 6 Staelin in 7Stalpin Inc Stolin in 9 Stein in 10 Stepin inc 11 Alum Sheeting 12 Alum Sheeting 13 Alum Sheeting 16 Alum Sheeting 15 Spacetime Technologies 10 Spacetime Technologies 17 Spacetime Technologies 16 Spacetime Technologies 19 Sprottime Technologies 20 Spacetime Technologies 21 Durable Products 22 Durable Products 23 Durable Products 24 Durable Products 25 Diable Products 16 Spacetime Technologies 27 Spacetime Technologies 20 Spacetime Technologies 29 Durable Products 00 Durable Products 31 Durable Products 32 Manley Valve 33 Manley Valve 34 Manley Valve 5 5 5 5 2 2 2 2 2 2 3 3 3 3 3 2 2 2 3 3 3 7 7 7 Order No. Item No. Item Description AD111 6489 O-Ring A0125 5319 Shielded Cable A0125 4312 Bot-nut package A0204 5319 Shielded Cable A0205 5677 Side Panel A0207 4312 Bollnut package A0223 4224 Boll-out package A0433 5417 Control Panel A0443 Airframe fasteners A0446 5417 Control Panel A0533 9752 Gasket A0555 O-Ring A0622 9752 Gasket A0666 5125 Shielded Cablett A0777 5489 O-Ring A1222 4111 Bont package A1234 9399 Gasket A1235 0309 Gasket A1344 5454 Control Panel A1345 9390 Gasket A1346 0399 Gasket A1444 4111 Boltnut package A1446 4111 Bout package A1440 Bollut package A1456 5454 Control Panel A1457 4569 Botnut package A1567 1369 Airframe fasteners A2345 6431 O-Ring A2350 7250 Pressure Gauge A2367 9977 Para Decor 1970 O. Hem Cost Quantity Cost per order $ 3.00 9005 2,700.00 $ 1.10 17,500 $ 19.250.00 $ 3.75 4.250 $ 15,937,50 $ 1.10 16,500 $ 18,150.00 $ 195,00 120$ 23.400.00 $ 3.75 4.2005 15,750.00 $3.05 4,500 $ 17.775.00 $255.00 500 $ 127,500.00 $ 4.25 10,000 $ 42.600.00 $255.00 400 $ 103,530,00 $ 4.05 1.500 5 8.075.00 $ 3.00 1,100 $ 3,300.00 $ 4.05 1,550 $ 0.277 50 $ 1.15 15,000 5 17,250.00 $ 3.00 1,050 $ 3.150.00 5355 4.2005 14,910.00 $ 3.05 1.2503 4.002.50 $3.65 1,450 $ 5,202.50 $ 220.00 5505 121,000.00 $ 3.05 1.470 S 5,505 50 $ 3.05 1.0055 7.245.25 $ 3.55 4.250 15,007 50 $ 3.85 4.2005 14,910.00 $ 3.55 4.500 5 16,330.00 $220.00 500 5 110,000.00 $ 3.50 3.000 5 13.650.00 $ 420 15,000 $ 63,000.00 $ 2.85 1250 $ 3,562.00 $100.50953 9,547,50 $ 1.00525 $ 525.00 AJP Terms Order Date Arrival Date 25 10/10/19 10/18/19 30 OB/20/19 08/31/19 30 08/25/10 09/01/19 30 09/15/19 10/05/19 30 12/02/19 12/13/19 30 09/01/19 09/10/19 30 10/15/19 10/20/19 30 10/20/19 10/27/19 30 08/08/19 08/14/19 30 09/01/19 09/10/10 25 09/20/19 09/25/10 25 10/05/19 10/10/19 25 09/25/10 10/05/10 25 10/01/10 10/15/19 25 10/29/10 12/10/19 25 09/18/19 10/15/10 45 10/01/19 10/06/10 45 10/03/10 10/08/10 45 10/09/19 10/14/19 45 10/07/1 10/13/10 45 10/06/19 10/11/10 25 OW20/10 10/10/19 25 09/25/19 10/25/10 25 10/05/19 10/1910 46 10/18/19 10/20/10 45 10/05/19 10/10/19 45 09/2010 09/30/10 30 10/06/19 10/10/10 30 10/20/19 10/29/19 30 12/01/10 12/07/10 30 CORO Data vale K68 Xfx 9/13/2019 H E F 1 B A L 34 Manley Valve 35 Manley Valve 36 Spacetime Technologies 37 Spacetime Technologies 38 Manley Valve 39 Manley Valve 40 Manley Valve 41 Manley Valve 42 Pylon Accessories 43. Alum Sheeting 44 Stepinino 45 Alum Shooting 46 Alum Shooting 47 Alum Sheeting 48 Pylon Accessories 49 Durable Products 50. Durable Products 51 Durable Products 52 Durable Products 53 Durable Products 54 Fast The Arospace 15 FastTe Aerospace 50 Fast The Aerospace 57 Fast The Aerospace 56 Fast The Aerospace 89 Fast Tie Aerospace 00 Fast The Aerospace 61 Fast Tie Arospace 62 Fast The Aerospace 63 Fast The Aerospace 64 Fast-Tie Aerospace 65. Fast Tie Aerospace 0 Stein Inc 67 Stoepining 68 Data 7 7 2 2 7 7 2 7 B 5 6 5 5 5 B 3 3 3 3 3 4 4 4 A2367 A2378 A3467 A5689 A9821 A9842 A9885 A9876 A9999 B0247 B0445 B0447 30479 B0567 B1111 B1234 B1345 31468 B1580 B1600 B2333 B2345 82356 82307 82378 B2498 B2499 B2511 82519 82528 B2537 B2566 B3022 B3041 8304 D 9977 8431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5634 1243 9784 7258 7258 1369 5275 1360 6321 6321 0321 6321 6321 5689 7268 7268 5462 5600 5462 5402 5677 5234 5254 Panel Decal O-Ring Bolt-nut package Bolt-nut package O-Ring Pressure Gauge Hatch Decal Door Decal O-Ring Airframe fasteners Bolt-nut package Side Panel Side Panel Airframe fasteners Gasket Pressure Gauge Pressure Gauge Airframe fasteners Shielded Cable/ Airframe fasteners O-Ring O Ring O-Ring O-Ring O-Ring Side Panel Pressure Gauge Pressure Gaugo Shielded Cable/ Side Panel Shielded Cable Shielded Cable Side Panel Electrical Connector Enconto $ 1.00 $ 2.85 $ 355 53.55 $ 2.85 $ 100.50 $ 0.85 S 0.55 $ 2.95 $ 4 25 $ 3.75 $185.00 $185.00 $ 4.25 $ 3.75 $ 90.00 5. 90.00 $ 4.20 $ 1.00 $ 4.20 $ 2.45 $ 2.45 $ 2.45 $2.45 $ 2.45 $ 175,00 $95.00 $95.00 $ 1.05 $ 175,00 $ 1.05 $1.05 $ 195.00 $ 1.65 1165 G 525 $ 1,350 $ 4,800 $ 4,585 $ 1,300 $ 100 $ 550 $ 150 $ 1,500 $ 9,000 $ 4,150 $ 150 $ 140$ 10,500 $ 1,9805 100 $ 120 $ 14,000 $ 25,000 $ 10,000 $ 1,300 $ 1,200 $ 2,500 5 1,250 $ 1.500 5 150 $ 110 $ 105 $ 22,500 $ 175 $ 21,500 $ 23,000 $ 110 $ 4,500 $ 2.750 $ 525.00 3,847.50 17.040.00 16.276.75 3.705.00 10.050.00 467.50 82.50 4.425.00 38,250.00 15,562,50 27,750.00 25,900.00 44,625.00 7,425.00 9,000.00 10,800.00 58,800.00 25,000.00 42,000.00 3.185.00 2.940,00 6,125,00 3.002.50 3,675,00 26,250.00 10,450.00 9,975.00 23,625.00 30.625.00 22.575.00 24.150.00 21,450.00 7.425,00 8888888888888888888888888888 12/01/19 10/01/19 09/05/19 09/10/19 09/25/19 10/15/19 12/05/19 12/01/19 10/01/19 09/05/19 09/03/19 10/25/19 10/29/19 10/10/19 09/20/10 08/25/19 09/05/19 09/27/19 10/25/10 09/29/19 08/25/19 09/13/10 09/25/10 10/13/19 10/25/10 12/01/19 12/01/19 12/05/19 08/20/19 12/05/19 08/15/19 08/10/19 12/05/19 08/28/19 09/0STD 12/07/19 10/07/19 09/20/19 09/30/19 10/01/19 10/24/19 12/12/19 12/06/19 10/10/19 09/13/19 09/13/19 12/03/19 12/04/19 10/17/19 09/29/19 08/28/10 09/09/10 10/03/19 10/30/10 10/04/19 09/04/19 09/23/10 10/04/10 10/21/19 12/02/10 12/09/19 12/12/19 12/18/19 08/26/19 12/15/19 08/22/19 08/15/19 12/17/19 09/05/119 09/13719 4 4 4 4 4 4 4 4 4 5 6 30 + System Preferenc Avis yu ve duy K89 * fx 10/3/2019 A B D G H 1 - K 6 5 30 30 30 30 30 30 30 30 30 30 30 30 67 Steelpin Inc 68 Steelpin Inc 69 Steelpin Inc 70 Steeloin Ina 71 Steelpin Inc 72 Fast-Tie Aerospace 73 Fast-Tie Aerospace 76 Fastie Aerospan 75 Stepina Inc 76 Steelpin Inc 77 Steelpin Inc 78 Manley Valve 79 Hulkey Fasteners 80 Hulkey Fasteners BT Pylon Accessories 82 Manley Valve 33 Hulkey Fasteners 34 Hulkey Fasteners 35. Hulley Fastener 36. Manley Valve 87 Hukey Fasteners 88 Hulkey Fasteners 89 Hulkey Fasteners 90 Hulkey Fasteners 91 Hulkey Fasteners 02 Hukey Fastenen 93 Hulkey Fastener 24 Pylon Assories 95 Hulkey Fasteners 90. Hulley Fasteners 97 Huay Fasteners 9 Pron Accessories 99 100 100 Data 6 6 4 4 4 6 6 6 7 1 1 7 1 1 1 7 1 1 1 1 1 1 1 3 1 1 1 8 B3041 83042 83111 B3222 83333 C0234 C0422 C0433 00456 00467 C0589 C1111 C1212 C1313 C2211 C2222 C2323 C2829 03232 C3333 C3434 C4545 C5656 C6765 07875 C8654 C8989 01111 D1212 02121 03232 03333 5234 5234 5234 800B 8000 5166 5689 5482 5677 8008 5319 9955 1122 3166 9764 7258 1122 3166 1122 8148 1122 1122 1122 5066 3106 3166 9966 9764 5066 1122 1122 9764 Electrical Connector Electrical Connector Electrical Connector Machined Valve Machined Valve Electrical Connector Side Panel Shielded Cable/ Side Panel Machined Valve Shielded Cable/ft Door Decal Airframe fasteners Electrical Connector Gasket Pressure Gauge Airframe fasteners Electrical Connector Altrame fasteners Machined Valve Airframe fastenen Airframe fasteners Airtrame fasteners Shielded Cable Electrical Connector Electrical Connector Hatch Decal Gasket Shielded Cablett Airframe fasteners Airframe fasteners Gasket $ 1 65 $ 1.65 $ 165 $ 645.00 $ 145.00 $ 1.25 $ 175.00 $ 1.05 $ 195,00 $ 645.00 $ 1.10 $ 0.55 $ 4.25 $ 1.25 $ 3.75 $ 100.50 $4.25 $ 1.25 $ 4.25 $ 655.50 $ 4.25 $ 4.25 $ 4 25 $ 0.95 $ 1.25 $ 1.25 $0.75 $ 3.75 $ 0.95 $ 4.25 $ 4.25 $ 3.75 4,500 $ 4,750 $ 4,850 $ 150 S 100 $ 5,650 $ 1555 22.500 $ 130$ 120$ 18,100 $ 125 $ 19,500 $ 5.600 $ 1,850 $ 90$ 15,500 5 5,500 5 18,000 $ 125$ 12,500 15,000 $ 14,500 5 25,000 $ 5,6505 5,4255 500$ 1,800 $ 17.500 $ 17 500 $ 17.000$ 1.750 7,425.00 7,837 50 8.002.50 96.750.00 64,500.00 7.062.50 27.125,00 23,825.00 25,350.00 77,400.00 19,910.00 68.75 82.875.00 7,000.00 6,937.50 9,045.00 65,875,00 6,875.00 78,000.00 81,937.50 63.125.00 63.750.00 81,625.00 23,750.00 7,062 50 6,781,25 375.00 6.750.00 16,625.00 74,375.00 72,250,00 8,562,50 30 15 30 30 30 30 30 30 30 30 30 30 OB/28/19 09/05/19 09/02/19 10/15/19 10/10/19 10/01/19 10/25/19 08/25/19 10/28/19 10/28/10 08/25/19 12/05/19 08/05/19 08/25/19 09/25/19 10/10/19 09/04/19 09/01/19 10/01/19 10/10/19 O9/05/19 09/08/19 09/28/19 09/05/19 09/05/19 09/10/19 08/25/19 09/28/19 09/15/19 10/26/19 10/13/10 0920/19 09/05/19 09/13/19 09/1310 10/26/19 10/21/19 10/06/19 12/03/19 09/02/19 12/07/19 12/04/19 09/05/19 12/10/19 08/13/19 08/20/19 10/05/19 10/17/19 09/13/19 09/06/19 10/02/19 10/17/19 09/12/19 09/15/19 10/03/19 09/13 19 09/10/19 09/15/19 08/3119 10/05/19 09/22/19 12/03/19 10/10/19 09/25/19 + K3 B c D E F G H 1 2 Orders and Suppliers Vendor No 2 6 0 0 1243 6489 4 Vendor Name 5 Spacetime Technologies 6 Staelin in 7Stalpin Inc Stolin in 9 Stein in 10 Stepin inc 11 Alum Sheeting 12 Alum Sheeting 13 Alum Sheeting 16 Alum Sheeting 15 Spacetime Technologies 10 Spacetime Technologies 17 Spacetime Technologies 16 Spacetime Technologies 19 Sprottime Technologies 20 Spacetime Technologies 21 Durable Products 22 Durable Products 23 Durable Products 24 Durable Products 25 Diable Products 16 Spacetime Technologies 27 Spacetime Technologies 20 Spacetime Technologies 29 Durable Products 00 Durable Products 31 Durable Products 32 Manley Valve 33 Manley Valve 34 Manley Valve 5 5 5 5 2 2 2 2 2 2 3 3 3 3 3 2 2 2 3 3 3 7 7 7 Order No. Item No. Item Description AD111 6489 O-Ring A0125 5319 Shielded Cable A0125 4312 Bot-nut package A0204 5319 Shielded Cable A0205 5677 Side Panel A0207 4312 Bollnut package A0223 4224 Boll-out package A0433 5417 Control Panel A0443 Airframe fasteners A0446 5417 Control Panel A0533 9752 Gasket A0555 O-Ring A0622 9752 Gasket A0666 5125 Shielded Cablett A0777 5489 O-Ring A1222 4111 Bont package A1234 9399 Gasket A1235 0309 Gasket A1344 5454 Control Panel A1345 9390 Gasket A1346 0399 Gasket A1444 4111 Boltnut package A1446 4111 Bout package A1440 Bollut package A1456 5454 Control Panel A1457 4569 Botnut package A1567 1369 Airframe fasteners A2345 6431 O-Ring A2350 7250 Pressure Gauge A2367 9977 Para Decor 1970 O. Hem Cost Quantity Cost per order $ 3.00 9005 2,700.00 $ 1.10 17,500 $ 19.250.00 $ 3.75 4.250 $ 15,937,50 $ 1.10 16,500 $ 18,150.00 $ 195,00 120$ 23.400.00 $ 3.75 4.2005 15,750.00 $3.05 4,500 $ 17.775.00 $255.00 500 $ 127,500.00 $ 4.25 10,000 $ 42.600.00 $255.00 400 $ 103,530,00 $ 4.05 1.500 5 8.075.00 $ 3.00 1,100 $ 3,300.00 $ 4.05 1,550 $ 0.277 50 $ 1.15 15,000 5 17,250.00 $ 3.00 1,050 $ 3.150.00 5355 4.2005 14,910.00 $ 3.05 1.2503 4.002.50 $3.65 1,450 $ 5,202.50 $ 220.00 5505 121,000.00 $ 3.05 1.470 S 5,505 50 $ 3.05 1.0055 7.245.25 $ 3.55 4.250 15,007 50 $ 3.85 4.2005 14,910.00 $ 3.55 4.500 5 16,330.00 $220.00 500 5 110,000.00 $ 3.50 3.000 5 13.650.00 $ 420 15,000 $ 63,000.00 $ 2.85 1250 $ 3,562.00 $100.50953 9,547,50 $ 1.00525 $ 525.00 AJP Terms Order Date Arrival Date 25 10/10/19 10/18/19 30 OB/20/19 08/31/19 30 08/25/10 09/01/19 30 09/15/19 10/05/19 30 12/02/19 12/13/19 30 09/01/19 09/10/19 30 10/15/19 10/20/19 30 10/20/19 10/27/19 30 08/08/19 08/14/19 30 09/01/19 09/10/10 25 09/20/19 09/25/10 25 10/05/19 10/10/19 25 09/25/10 10/05/10 25 10/01/10 10/15/19 25 10/29/10 12/10/19 25 09/18/19 10/15/10 45 10/01/19 10/06/10 45 10/03/10 10/08/10 45 10/09/19 10/14/19 45 10/07/1 10/13/10 45 10/06/19 10/11/10 25 OW20/10 10/10/19 25 09/25/19 10/25/10 25 10/05/19 10/1910 46 10/18/19 10/20/10 45 10/05/19 10/10/19 45 09/2010 09/30/10 30 10/06/19 10/10/10 30 10/20/19 10/29/19 30 12/01/10 12/07/10 30 CORO Data vale K68 Xfx 9/13/2019 H E F 1 B A L 34 Manley Valve 35 Manley Valve 36 Spacetime Technologies 37 Spacetime Technologies 38 Manley Valve 39 Manley Valve 40 Manley Valve 41 Manley Valve 42 Pylon Accessories 43. Alum Sheeting 44 Stepinino 45 Alum Shooting 46 Alum Shooting 47 Alum Sheeting 48 Pylon Accessories 49 Durable Products 50. Durable Products 51 Durable Products 52 Durable Products 53 Durable Products 54 Fast The Arospace 15 FastTe Aerospace 50 Fast The Aerospace 57 Fast The Aerospace 56 Fast The Aerospace 89 Fast Tie Aerospace 00 Fast The Aerospace 61 Fast Tie Arospace 62 Fast The Aerospace 63 Fast The Aerospace 64 Fast-Tie Aerospace 65. Fast Tie Aerospace 0 Stein Inc 67 Stoepining 68 Data 7 7 2 2 7 7 2 7 B 5 6 5 5 5 B 3 3 3 3 3 4 4 4 A2367 A2378 A3467 A5689 A9821 A9842 A9885 A9876 A9999 B0247 B0445 B0447 30479 B0567 B1111 B1234 B1345 31468 B1580 B1600 B2333 B2345 82356 82307 82378 B2498 B2499 B2511 82519 82528 B2537 B2566 B3022 B3041 8304 D 9977 8431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5634 1243 9784 7258 7258 1369 5275 1360 6321 6321 0321 6321 6321 5689 7268 7268 5462 5600 5462 5402 5677 5234 5254 Panel Decal O-Ring Bolt-nut package Bolt-nut package O-Ring Pressure Gauge Hatch Decal Door Decal O-Ring Airframe fasteners Bolt-nut package Side Panel Side Panel Airframe fasteners Gasket Pressure Gauge Pressure Gauge Airframe fasteners Shielded Cable/ Airframe fasteners O-Ring O Ring O-Ring O-Ring O-Ring Side Panel Pressure Gauge Pressure Gaugo Shielded Cable/ Side Panel Shielded Cable Shielded Cable Side Panel Electrical Connector Enconto $ 1.00 $ 2.85 $ 355 53.55 $ 2.85 $ 100.50 $ 0.85 S 0.55 $ 2.95 $ 4 25 $ 3.75 $185.00 $185.00 $ 4.25 $ 3.75 $ 90.00 5. 90.00 $ 4.20 $ 1.00 $ 4.20 $ 2.45 $ 2.45 $ 2.45 $2.45 $ 2.45 $ 175,00 $95.00 $95.00 $ 1.05 $ 175,00 $ 1.05 $1.05 $ 195.00 $ 1.65 1165 G 525 $ 1,350 $ 4,800 $ 4,585 $ 1,300 $ 100 $ 550 $ 150 $ 1,500 $ 9,000 $ 4,150 $ 150 $ 140$ 10,500 $ 1,9805 100 $ 120 $ 14,000 $ 25,000 $ 10,000 $ 1,300 $ 1,200 $ 2,500 5 1,250 $ 1.500 5 150 $ 110 $ 105 $ 22,500 $ 175 $ 21,500 $ 23,000 $ 110 $ 4,500 $ 2.750 $ 525.00 3,847.50 17.040.00 16.276.75 3.705.00 10.050.00 467.50 82.50 4.425.00 38,250.00 15,562,50 27,750.00 25,900.00 44,625.00 7,425.00 9,000.00 10,800.00 58,800.00 25,000.00 42,000.00 3.185.00 2.940,00 6,125,00 3.002.50 3,675,00 26,250.00 10,450.00 9,975.00 23,625.00 30.625.00 22.575.00 24.150.00 21,450.00 7.425,00 8888888888888888888888888888 12/01/19 10/01/19 09/05/19 09/10/19 09/25/19 10/15/19 12/05/19 12/01/19 10/01/19 09/05/19 09/03/19 10/25/19 10/29/19 10/10/19 09/20/10 08/25/19 09/05/19 09/27/19 10/25/10 09/29/19 08/25/19 09/13/10 09/25/10 10/13/19 10/25/10 12/01/19 12/01/19 12/05/19 08/20/19 12/05/19 08/15/19 08/10/19 12/05/19 08/28/19 09/0STD 12/07/19 10/07/19 09/20/19 09/30/19 10/01/19 10/24/19 12/12/19 12/06/19 10/10/19 09/13/19 09/13/19 12/03/19 12/04/19 10/17/19 09/29/19 08/28/10 09/09/10 10/03/19 10/30/10 10/04/19 09/04/19 09/23/10 10/04/10 10/21/19 12/02/10 12/09/19 12/12/19 12/18/19 08/26/19 12/15/19 08/22/19 08/15/19 12/17/19 09/05/119 09/13719 4 4 4 4 4 4 4 4 4 5 6 30 + System Preferenc Avis yu ve duy K89 * fx 10/3/2019 A B D G H 1 - K 6 5 30 30 30 30 30 30 30 30 30 30 30 30 67 Steelpin Inc 68 Steelpin Inc 69 Steelpin Inc 70 Steeloin Ina 71 Steelpin Inc 72 Fast-Tie Aerospace 73 Fast-Tie Aerospace 76 Fastie Aerospan 75 Stepina Inc 76 Steelpin Inc 77 Steelpin Inc 78 Manley Valve 79 Hulkey Fasteners 80 Hulkey Fasteners BT Pylon Accessories 82 Manley Valve 33 Hulkey Fasteners 34 Hulkey Fasteners 35. Hulley Fastener 36. Manley Valve 87 Hukey Fasteners 88 Hulkey Fasteners 89 Hulkey Fasteners 90 Hulkey Fasteners 91 Hulkey Fasteners 02 Hukey Fastenen 93 Hulkey Fastener 24 Pylon Assories 95 Hulkey Fasteners 90. Hulley Fasteners 97 Huay Fasteners 9 Pron Accessories 99 100 100 Data 6 6 4 4 4 6 6 6 7 1 1 7 1 1 1 7 1 1 1 1 1 1 1 3 1 1 1 8 B3041 83042 83111 B3222 83333 C0234 C0422 C0433 00456 00467 C0589 C1111 C1212 C1313 C2211 C2222 C2323 C2829 03232 C3333 C3434 C4545 C5656 C6765 07875 C8654 C8989 01111 D1212 02121 03232 03333 5234 5234 5234 800B 8000 5166 5689 5482 5677 8008 5319 9955 1122 3166 9764 7258 1122 3166 1122 8148 1122 1122 1122 5066 3106 3166 9966 9764 5066 1122 1122 9764 Electrical Connector Electrical Connector Electrical Connector Machined Valve Machined Valve Electrical Connector Side Panel Shielded Cable/ Side Panel Machined Valve Shielded Cable/ft Door Decal Airframe fasteners Electrical Connector Gasket Pressure Gauge Airframe fasteners Electrical Connector Altrame fasteners Machined Valve Airframe fastenen Airframe fasteners Airtrame fasteners Shielded Cable Electrical Connector Electrical Connector Hatch Decal Gasket Shielded Cablett Airframe fasteners Airframe fasteners Gasket $ 1 65 $ 1.65 $ 165 $ 645.00 $ 145.00 $ 1.25 $ 175.00 $ 1.05 $ 195,00 $ 645.00 $ 1.10 $ 0.55 $ 4.25 $ 1.25 $ 3.75 $ 100.50 $4.25 $ 1.25 $ 4.25 $ 655.50 $ 4.25 $ 4.25 $ 4 25 $ 0.95 $ 1.25 $ 1.25 $0.75 $ 3.75 $ 0.95 $ 4.25 $ 4.25 $ 3.75 4,500 $ 4,750 $ 4,850 $ 150 S 100 $ 5,650 $ 1555 22.500 $ 130$ 120$ 18,100 $ 125 $ 19,500 $ 5.600 $ 1,850 $ 90$ 15,500 5 5,500 5 18,000 $ 125$ 12,500 15,000 $ 14,500 5 25,000 $ 5,6505 5,4255 500$ 1,800 $ 17.500 $ 17 500 $ 17.000$ 1.750 7,425.00 7,837 50 8.002.50 96.750.00 64,500.00 7.062.50 27.125,00 23,825.00 25,350.00 77,400.00 19,910.00 68.75 82.875.00 7,000.00 6,937.50 9,045.00 65,875,00 6,875.00 78,000.00 81,937.50 63.125.00 63.750.00 81,625.00 23,750.00 7,062 50 6,781,25 375.00 6.750.00 16,625.00 74,375.00 72,250,00 8,562,50 30 15 30 30 30 30 30 30 30 30 30 30 OB/28/19 09/05/19 09/02/19 10/15/19 10/10/19 10/01/19 10/25/19 08/25/19 10/28/19 10/28/10 08/25/19 12/05/19 08/05/19 08/25/19 09/25/19 10/10/19 09/04/19 09/01/19 10/01/19 10/10/19 O9/05/19 09/08/19 09/28/19 09/05/19 09/05/19 09/10/19 08/25/19 09/28/19 09/15/19 10/26/19 10/13/10 0920/19 09/05/19 09/13/19 09/1310 10/26/19 10/21/19 10/06/19 12/03/19 09/02/19 12/07/19 12/04/19 09/05/19 12/10/19 08/13/19 08/20/19 10/05/19 10/17/19 09/13/19 09/06/19 10/02/19 10/17/19 09/12/19 09/15/19 10/03/19 09/13 19 09/10/19 09/15/19 08/3119 10/05/19 09/22/19 12/03/19 10/10/19 09/25/19 +