. . Extract from textbook: pages 72-73 Improving Decision Making: Use a Spreadsheet to select suppliers Software skills: Spreadsheet date functions, data filtering, DAVERAGE function Business skills: Analyzing supplier performance and pricing 2-10 In this exercise, you will learn how to use spreadsheet software to improve management decisions about selecting suppliers. You will filter transactional data about suppliers based on several criteria to select the best suppliers for your company. You run a company that manufactures aircraft components. You have many competitors who are trying to offer lower prices and better service to customers, and you are trying to determine whether you can benefit from better supply chain management. In MyLab MIS, you will find a spreadsheet file that contains a list of all the items your firm has ordered from its suppliers during the past three months. The fields in the spreadsheet file include vendor name, vendor identification number, purchaser's order number, item identification number and item description (for each item ordered from the vendor), cost per item, number of units of the item ordered (quantity), total cost of each order, vendor's accounts payable terms, order date, and actual arrival date for each order. Prepare a recommendation of how you can use the data in this spreadsheet database to improve your decisions about selecting suppliers. Some criteria to consider for identifying preferred suppliers include the supplier's track record for on-time deliveries, suppliers offering the best accounts payable terms, and suppliers offering lower pricing when the same item can be provided by multiple suppliers. Use your spreadsheet software to prepare reports to support your recommendations. G D E F H K 1 2. Orders and Suppliers 3 4 Vendor Name Vendor Ne Order N Item No 2 Item Description Item Co Quantit Cost per orde A/P TernOrder Dar Arrival Dat 5 Spacetime Technologies 2 AD111 6489 O Ring $ 3.00 900 $ 2,700.00 25 10/10/15 10/18/15 6 Steelpin Inc 6 A0125 5319 Shielded Cablert $ 1.10 17,500 $ 19.250.00 30 08/20/15 08/31/15 7 Steelpin Inc 6 A0123 4312 Bolt-nut package $ 3.75 4,250 $ 15,937 50 30 08/25/15 09/01/15 B Steelpin Inc 6 A0204 5319 Shielded Cable/tt $ 1.10 16,500 $ 18.150.00 30 09/15/15 10/05/15 9 Steelpin Inc 6 A0205 5677 Side Panel $ 195.00 120 s 23.400.00 30 12/02/15 12/13/15 10 Steelpin Inc 6 A0207 4312 Bolt-nut package $ 3.75 4,2005 15.750.00 30 09/01/15 09/10/15 11 Alum Sheeting 5 A0223 4224 Bolt-nut package S 3 95 4.500 5 17.775.00 30 10/15/15 10/20/15 12 Alum Sheeting 5 A0433 5417 Control Panel $ 255 00 500 $ 127,500.00 30 10/20/15 10/27/15 13 Alum Shooting 5 A0443 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 30 08/08/15 08/14/15 14 Alum Sheeting 5 A0446 5417 Control Panel 5 255.00 406 $ 103,530.00 30 09/01/15 09/10/15 15 Spacetime Technologies 2. A0533 9752 Gasket $ 4.05 1,500 5 6,075.00 25 09/20/15 09/25/15 16 Spacetime Technologies 2 A0555 6489 O-Ring $ 3.00 1,100 $ 3,300.00 25 10/05/15 10/10/15 17 Spacetime Technologies 2 A0622 9752 Gasket $ 405 1,5505 6,277.50 25 18 Spacetime Technologies 09/25/15 10/05/15 2. A0666 5125 Shielded Cable/ $ 1.15 15.000 17 250.00 25 19 Spacetime Technologies 2 10/01/15 10/15/15 A0777 6489 O-Ring $ 3.00 1,050 $ 3.150.00 25 20 Spacetime Technologies 10/29/15 2 4111 12/10/15 A1222 Bolt nut package 5 3.55 4 2005 21 Durable Products 14,910 00 3 25 09/15/15 10/15/15 A1234 9399 Gasket $ 3.65 1.250 $ 4,562 50 45 22 Durable Products 3 10/01/15 10/06/15 A1235 9399 Gasket $ 3 65 1.4505 5,292 50 45 23 Durable Products 3 5054 10/03/15 A1344 10/08/15 Control Panel $ 22000 550 $ 121,000.00 24 Durable Products 3 9399 45 A1345 10/14/15 Gasket $ 10/09/15 3.65 25 Durable Products 1.470 IS 5.365 50 3 9399 45 10/07/15 A1346 10/1/15 Gasket $ 3.65 1.985 5 26 Spacetime Technologies 45 7245 25 2 10/05/15 10/11/12 A1444 4111 Bolt-nut package $ 3.55 4.250 5 27 Spacetime Technologies 15,087 50 2 A1445 Bolt nut package 25 09/20/15 5 355 10/10/15 4 2005 20 Spacetime Technologies 14.910.00 2 A1449 4111 25 Bolt nut package 09/25/15 10/25/15 $ 3.55 29 Durable Products 4,6005 16,300.00 3 5454 25 A1456 10/05/15 Control Panel $ 22000 10/19/15 30 Durable Products 500 5 110,000 00 3 45 A1457 4569 Boltnut package 10/15/15 10/20/15 $ 350 31 Durable Products 3.900 5 13.650.00 3 45 A1567 1369 Airframe fasteners $ 10/05/15 10/10/15 32 Manley Value 420 15.000 63,000.00 45 7 A2345 6431 0925/15 O-Ring 09/30/15 $ 3) Manley Vahe 285 1.250S 7 7258 3,562 50 A2356 30 Pressure Gauge 10/05/15 5 100 50 10/10/15 95$ 9,547 50 30 10/20/15 10/29/15 Sheet1 CE AutoSave Off Data - Compatibility Mode - Saved O Search File Home Insert Draw Page Layout Formulas Data Review View Help Arial Wrap Text General 10 ' ' a. Av Paste BIU + Merge & Center $% 9 Clipboard 5 Number Font Alignment L20 fx B 7 7 2 2. 7 7 7 7 8 5 6 5 5 5 8 3 3 888888888 88- 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 Steelpin Inc 45 Alum Sheeting 46 Alum Sheeting 47 Alum Sheeting 48 Pylon Accessories 49 Durable Products 50 Durable Products 51 Durable Products 52 Durable Products 53 Durable Products 54 Fast-Tie Aerospace 55 Fast-Tie Aerospace 56 Fast-Tie Aerospace 57 Fast-Tie Aerospace 58 Fast-Tie Aerospace 59 Fast-Tie Aerospace 60 Fast-Tie Aerospace 61 Fast-Tie Aerospace 62 Fast-Tie Aerospace 63 Fast-Tie Aerospace 64 Fast-Tie Aerospace 65 Fast-Tie Aerospace 66 Steelpin Inc 67 Sterlin Inc Sheet1 C A2367 A2378 A3467 A5689 A9821 A9842 A9865 A9876 A9999 B0247 B0445 B0447 B0479 B0567 B1111 B1234 B1345 B1468 B1589 B1666 B2333 B2345 B2356 B2367 B2378 B2498 B2499 B2511 B2519 B2528 B2537 B2566 B3022 B3041 D 9977 6431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5634 1243 9764 7258 7258 1369 5275 1369 6321 6321 6321 6321 6321 5689 7268 7268 5462 5689 5462 5462 5677 E 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/ft Airframe fasteners O-Ring O-Ring O-Ring O-Ring O Ring Side Panel Pressure Gauge Pressure Gauge Shielded Cable/tt Side Panel Shielded Cable/tt Shielded Cable/ Side Panel Flectrical Connector F $ 1.00 $ 2.85 $ 3.55 $ 3.55 S 2.85 $ 100 50 $ 0 85 $ 0.55 $ 2.95 $ 4.25 $ 3.75 $ 185,00 $185.00 $ 425 $ 3.75 $ 90.00 $ 90.00 $ 420 $ 1.00 S 4.20 $ 2.45 $ 245 $ 2.45 $ 2.45 $ 245 $ 175.00 $ 95,00 $ 95.00 $ 1.05 $ 175.00 $ 1.05 $ 1.05 $ 195,00 S 1.65 G 525$ 1,350 $ 4,800 $ 4,585 5 1,300 $ 100 5 550 $ 150 $ 1,500 $ 9,000 $ 4 150 $ 150 S 140 $ 10,500 1,980$ 100$ 1205 14 000 $ 25,000 $ 10,000 $ 1,300 $ 1,200 $ 2.500 5 1.250 5 1500 $ 150 $ 110 $ 1055 22.500 $ 175 $ 21.500 5 23,000 $ 110 5 4500 H 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,062.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 7425.00 15 45 45 45 45 45 30 30 J 12/01/15 10/01/15 09/05/15 09/10/15 09/25/15 10/15/15 12/05/15 12/01/15 10/01/15 09/05/15 09/03/15 10/25/15 10/29/15 10/10/15 09/20/15 08/25/15 09/05/15 09/27/15 10/25/15 09/29/15 08/25/15 09/13/15 09/25/15 10/13/15 10/25/15 12/01/15 12/01/15 12/05/15 08/20/15 12/05/15 08/15/15 08/10/15 12/05/15 OR/PR/15 K 12/07/15 10/07/15 09/20/15 09/30/15 10/01/15 10/24/15 12/12/15 12/06/15 10/10/15 09/13/15 09/13/15 12/03/15 12/04/15 10/17/15 09/29/15 08/28/15 09/09/15 10/03/15 10/30/15 10/04/15 09/04/15 09/23/15 10/04/15 10/21/15 12/02/15 12/09/15 12/12/15 12/16/15 08/26/15 12/15/15 08/22/15 08/15/15 12/17/15 NA/05/15 3 3 4 4 4 4 4 4 4 4 4 4 4 4 6 6 88888888888 30 B 6 6 6 6 6 6 4 A 6 Steelpin Inc 7 Steelpin Inc. 58 Steelpin Inc 59 Steelpin Inc 70 Steelpin Inc 71 Steelpin Inc 72 Fast-Tie Aerospace 73 Fast-Tie Aerospace 74 Fast-Tie Aerospace 75 Steelpin Inc 76 Steelpin Inc 77 Steelpin Inc 78 Manley Valve 79 Hulkey Fasteners 80 Hulkey Fasteners 81 Pylon Accessories B2 Manley Valve B3 Hulkey Fasteners 84 Hulkey Fasteners 85 Hulkey Fasteners 86 Manley Valve B7 Hulkey Fasteners B8 Hulkey Fasteners 89 Hulley Fasteners 90 Hulkey Fasteners 91 Hulkey Fasteners 92 Hulkey Fasteners 93 Hulkey Fasteners 94 Pylon Accessories 95 Hulkey Fasteners 96 Hulkey Fasteners 97 Hulkey Fasteners 98 Pylon Accessories 4 4 6 6 6 7 1 1 8 7 1 1 1 7 1 1 1 1 1 1 1 8 1 1 1 8 B3022 B3041 B3042 B3111 B3222 B3333 C0234 C0423 C0433 C0456 C0467 C0589 C1111 C1212 C1313 C2211 C2222 C2323 C2929 C3232 C3333 C3434 C4545 C5656 C6765 C7875 C8854 C8989 01111 D1212 D2121 D3232 D3333 D 5677 5234 5234 5234 8008 8008 5166 5689 5462 5677 8008 5319 9955 1122 3166 9764 7258 1122 3166 1122 8148 1122 1122 E Side Panel Electrical Connector Electrical Connector Electrical Connector Machined Valve Machined Valve Electrical Connector Side Panel Shielded Cable/ft Side Panel Machined Valve Shielded Cable/tt Door Decal Airframe fasteners Electrical Connector Gasket Pressure Gauge Airframe fasteners Electrical Connector Airframe fasteners Machined Valve Airframe fasteners Airframe fasteners Airframe fasteners Shielded Cable/ Electrical Connector Electrical Connector Hatch Decal Gasket Shielded Cable/ Airframe fasteners Airframe fasteners Gasket F $ 195.00 $ 1.65 $ 165 $ 1.65 $ 645.00 $ 645.00 $ 1.25 $ 175.00 $ 105 $ 195,00 $ 645.00 $ 1.10 $ 0.55 $ 4 25 $ 1.25 $ 3.75 $ 100.50 $ 4.25 $ 1.25 5 4.25 $ 655 50 $ 4.25 S 4.25 $ 4.25 $ 0.95 S 1.25 $ 1.25 $ 0.75 $ 3.75 $ 0.95 $ 4.25 $ 4.25 $ 3.75 G 110$ 4,500 $ 4,750's 4,850 S 150 $ 100 $ 5,650 $ 155 $ 22.500 5 130 S 1205 18,100 125$ 19.500 5 5,600 $ 1,850 $ 90 $ 15,500 $ 5,500 $ 18,000 5 125$ 12.500 5 15,000 $ 14,500 $ 25,000 $ 5,650 $ 5.4255 500 1,800 $ 17.500 5 17.500 5 17.0005 1.7505 H 21.450.00 7.425.00 7,837.50 8,002 50 96,750.00 64,500.00 7,062.50 27,125.00 23,625.00 25,350.00 77,400.00 19.910.00 68.75 82.875 00 7,000.00 6,93750 9,0450 65,875.00 6,875.00 76,500.00 81,937 50 53,125.00 63,750 00 61,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 6,562 50 1 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 15 J 12/05/15 08/28/15 09/05/15 09/02/15 10/15/15 10/10/15 10/01/15 10/25/15 08/25/15 10/28/15 10/28/15 08/25/15 12/05/15 08/05/15 08/25/15 09/25/15 10/10/15 09/04/15 09/01/15 10/01/15 10/10/15 09/05/15 09/08/15 09/28/15 09/05/15 09/05/15 09/10/15 08/25/15 09/28/15 09/15/15 10/25/15 10/13/15 09/20/15 K 12/17/15 09/05/15 09/13/15 09/13/15 10/26/15 10/21/15 10/06/15 12/03/15 09/02/15 12/07/15 12/04/15 09/05/15 12/10/15 08/13/15 08/29/15 10/05/15 10/17/15 09/13/15 09/06/15 10/08/15 10/17/15 09/13/15 09/15/15 10/03/15 09/13/15 09/10/15 09/15/15 08/31/15 10/05/15 09/22/15 12/03/15 10/19/15 09/25/15 1122 5066 3166 3166 9966 9764 5066 1122 1122 9764 Sheet1 + . . Extract from textbook: pages 72-73 Improving Decision Making: Use a Spreadsheet to select suppliers Software skills: Spreadsheet date functions, data filtering, DAVERAGE function Business skills: Analyzing supplier performance and pricing 2-10 In this exercise, you will learn how to use spreadsheet software to improve management decisions about selecting suppliers. You will filter transactional data about suppliers based on several criteria to select the best suppliers for your company. You run a company that manufactures aircraft components. You have many competitors who are trying to offer lower prices and better service to customers, and you are trying to determine whether you can benefit from better supply chain management. In MyLab MIS, you will find a spreadsheet file that contains a list of all the items your firm has ordered from its suppliers during the past three months. The fields in the spreadsheet file include vendor name, vendor identification number, purchaser's order number, item identification number and item description (for each item ordered from the vendor), cost per item, number of units of the item ordered (quantity), total cost of each order, vendor's accounts payable terms, order date, and actual arrival date for each order. Prepare a recommendation of how you can use the data in this spreadsheet database to improve your decisions about selecting suppliers. Some criteria to consider for identifying preferred suppliers include the supplier's track record for on-time deliveries, suppliers offering the best accounts payable terms, and suppliers offering lower pricing when the same item can be provided by multiple suppliers. Use your spreadsheet software to prepare reports to support your recommendations. G D E F H K 1 2. Orders and Suppliers 3 4 Vendor Name Vendor Ne Order N Item No 2 Item Description Item Co Quantit Cost per orde A/P TernOrder Dar Arrival Dat 5 Spacetime Technologies 2 AD111 6489 O Ring $ 3.00 900 $ 2,700.00 25 10/10/15 10/18/15 6 Steelpin Inc 6 A0125 5319 Shielded Cablert $ 1.10 17,500 $ 19.250.00 30 08/20/15 08/31/15 7 Steelpin Inc 6 A0123 4312 Bolt-nut package $ 3.75 4,250 $ 15,937 50 30 08/25/15 09/01/15 B Steelpin Inc 6 A0204 5319 Shielded Cable/tt $ 1.10 16,500 $ 18.150.00 30 09/15/15 10/05/15 9 Steelpin Inc 6 A0205 5677 Side Panel $ 195.00 120 s 23.400.00 30 12/02/15 12/13/15 10 Steelpin Inc 6 A0207 4312 Bolt-nut package $ 3.75 4,2005 15.750.00 30 09/01/15 09/10/15 11 Alum Sheeting 5 A0223 4224 Bolt-nut package S 3 95 4.500 5 17.775.00 30 10/15/15 10/20/15 12 Alum Sheeting 5 A0433 5417 Control Panel $ 255 00 500 $ 127,500.00 30 10/20/15 10/27/15 13 Alum Shooting 5 A0443 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 30 08/08/15 08/14/15 14 Alum Sheeting 5 A0446 5417 Control Panel 5 255.00 406 $ 103,530.00 30 09/01/15 09/10/15 15 Spacetime Technologies 2. A0533 9752 Gasket $ 4.05 1,500 5 6,075.00 25 09/20/15 09/25/15 16 Spacetime Technologies 2 A0555 6489 O-Ring $ 3.00 1,100 $ 3,300.00 25 10/05/15 10/10/15 17 Spacetime Technologies 2 A0622 9752 Gasket $ 405 1,5505 6,277.50 25 18 Spacetime Technologies 09/25/15 10/05/15 2. A0666 5125 Shielded Cable/ $ 1.15 15.000 17 250.00 25 19 Spacetime Technologies 2 10/01/15 10/15/15 A0777 6489 O-Ring $ 3.00 1,050 $ 3.150.00 25 20 Spacetime Technologies 10/29/15 2 4111 12/10/15 A1222 Bolt nut package 5 3.55 4 2005 21 Durable Products 14,910 00 3 25 09/15/15 10/15/15 A1234 9399 Gasket $ 3.65 1.250 $ 4,562 50 45 22 Durable Products 3 10/01/15 10/06/15 A1235 9399 Gasket $ 3 65 1.4505 5,292 50 45 23 Durable Products 3 5054 10/03/15 A1344 10/08/15 Control Panel $ 22000 550 $ 121,000.00 24 Durable Products 3 9399 45 A1345 10/14/15 Gasket $ 10/09/15 3.65 25 Durable Products 1.470 IS 5.365 50 3 9399 45 10/07/15 A1346 10/1/15 Gasket $ 3.65 1.985 5 26 Spacetime Technologies 45 7245 25 2 10/05/15 10/11/12 A1444 4111 Bolt-nut package $ 3.55 4.250 5 27 Spacetime Technologies 15,087 50 2 A1445 Bolt nut package 25 09/20/15 5 355 10/10/15 4 2005 20 Spacetime Technologies 14.910.00 2 A1449 4111 25 Bolt nut package 09/25/15 10/25/15 $ 3.55 29 Durable Products 4,6005 16,300.00 3 5454 25 A1456 10/05/15 Control Panel $ 22000 10/19/15 30 Durable Products 500 5 110,000 00 3 45 A1457 4569 Boltnut package 10/15/15 10/20/15 $ 350 31 Durable Products 3.900 5 13.650.00 3 45 A1567 1369 Airframe fasteners $ 10/05/15 10/10/15 32 Manley Value 420 15.000 63,000.00 45 7 A2345 6431 0925/15 O-Ring 09/30/15 $ 3) Manley Vahe 285 1.250S 7 7258 3,562 50 A2356 30 Pressure Gauge 10/05/15 5 100 50 10/10/15 95$ 9,547 50 30 10/20/15 10/29/15 Sheet1 CE AutoSave Off Data - Compatibility Mode - Saved O Search File Home Insert Draw Page Layout Formulas Data Review View Help Arial Wrap Text General 10 ' ' a. Av Paste BIU + Merge & Center $% 9 Clipboard 5 Number Font Alignment L20 fx B 7 7 2 2. 7 7 7 7 8 5 6 5 5 5 8 3 3 888888888 88- 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 Steelpin Inc 45 Alum Sheeting 46 Alum Sheeting 47 Alum Sheeting 48 Pylon Accessories 49 Durable Products 50 Durable Products 51 Durable Products 52 Durable Products 53 Durable Products 54 Fast-Tie Aerospace 55 Fast-Tie Aerospace 56 Fast-Tie Aerospace 57 Fast-Tie Aerospace 58 Fast-Tie Aerospace 59 Fast-Tie Aerospace 60 Fast-Tie Aerospace 61 Fast-Tie Aerospace 62 Fast-Tie Aerospace 63 Fast-Tie Aerospace 64 Fast-Tie Aerospace 65 Fast-Tie Aerospace 66 Steelpin Inc 67 Sterlin Inc Sheet1 C A2367 A2378 A3467 A5689 A9821 A9842 A9865 A9876 A9999 B0247 B0445 B0447 B0479 B0567 B1111 B1234 B1345 B1468 B1589 B1666 B2333 B2345 B2356 B2367 B2378 B2498 B2499 B2511 B2519 B2528 B2537 B2566 B3022 B3041 D 9977 6431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5634 1243 9764 7258 7258 1369 5275 1369 6321 6321 6321 6321 6321 5689 7268 7268 5462 5689 5462 5462 5677 E 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/ft Airframe fasteners O-Ring O-Ring O-Ring O-Ring O Ring Side Panel Pressure Gauge Pressure Gauge Shielded Cable/tt Side Panel Shielded Cable/tt Shielded Cable/ Side Panel Flectrical Connector F $ 1.00 $ 2.85 $ 3.55 $ 3.55 S 2.85 $ 100 50 $ 0 85 $ 0.55 $ 2.95 $ 4.25 $ 3.75 $ 185,00 $185.00 $ 425 $ 3.75 $ 90.00 $ 90.00 $ 420 $ 1.00 S 4.20 $ 2.45 $ 245 $ 2.45 $ 2.45 $ 245 $ 175.00 $ 95,00 $ 95.00 $ 1.05 $ 175.00 $ 1.05 $ 1.05 $ 195,00 S 1.65 G 525$ 1,350 $ 4,800 $ 4,585 5 1,300 $ 100 5 550 $ 150 $ 1,500 $ 9,000 $ 4 150 $ 150 S 140 $ 10,500 1,980$ 100$ 1205 14 000 $ 25,000 $ 10,000 $ 1,300 $ 1,200 $ 2.500 5 1.250 5 1500 $ 150 $ 110 $ 1055 22.500 $ 175 $ 21.500 5 23,000 $ 110 5 4500 H 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,062.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 7425.00 15 45 45 45 45 45 30 30 J 12/01/15 10/01/15 09/05/15 09/10/15 09/25/15 10/15/15 12/05/15 12/01/15 10/01/15 09/05/15 09/03/15 10/25/15 10/29/15 10/10/15 09/20/15 08/25/15 09/05/15 09/27/15 10/25/15 09/29/15 08/25/15 09/13/15 09/25/15 10/13/15 10/25/15 12/01/15 12/01/15 12/05/15 08/20/15 12/05/15 08/15/15 08/10/15 12/05/15 OR/PR/15 K 12/07/15 10/07/15 09/20/15 09/30/15 10/01/15 10/24/15 12/12/15 12/06/15 10/10/15 09/13/15 09/13/15 12/03/15 12/04/15 10/17/15 09/29/15 08/28/15 09/09/15 10/03/15 10/30/15 10/04/15 09/04/15 09/23/15 10/04/15 10/21/15 12/02/15 12/09/15 12/12/15 12/16/15 08/26/15 12/15/15 08/22/15 08/15/15 12/17/15 NA/05/15 3 3 4 4 4 4 4 4 4 4 4 4 4 4 6 6 88888888888 30 B 6 6 6 6 6 6 4 A 6 Steelpin Inc 7 Steelpin Inc. 58 Steelpin Inc 59 Steelpin Inc 70 Steelpin Inc 71 Steelpin Inc 72 Fast-Tie Aerospace 73 Fast-Tie Aerospace 74 Fast-Tie Aerospace 75 Steelpin Inc 76 Steelpin Inc 77 Steelpin Inc 78 Manley Valve 79 Hulkey Fasteners 80 Hulkey Fasteners 81 Pylon Accessories B2 Manley Valve B3 Hulkey Fasteners 84 Hulkey Fasteners 85 Hulkey Fasteners 86 Manley Valve B7 Hulkey Fasteners B8 Hulkey Fasteners 89 Hulley Fasteners 90 Hulkey Fasteners 91 Hulkey Fasteners 92 Hulkey Fasteners 93 Hulkey Fasteners 94 Pylon Accessories 95 Hulkey Fasteners 96 Hulkey Fasteners 97 Hulkey Fasteners 98 Pylon Accessories 4 4 6 6 6 7 1 1 8 7 1 1 1 7 1 1 1 1 1 1 1 8 1 1 1 8 B3022 B3041 B3042 B3111 B3222 B3333 C0234 C0423 C0433 C0456 C0467 C0589 C1111 C1212 C1313 C2211 C2222 C2323 C2929 C3232 C3333 C3434 C4545 C5656 C6765 C7875 C8854 C8989 01111 D1212 D2121 D3232 D3333 D 5677 5234 5234 5234 8008 8008 5166 5689 5462 5677 8008 5319 9955 1122 3166 9764 7258 1122 3166 1122 8148 1122 1122 E Side Panel Electrical Connector Electrical Connector Electrical Connector Machined Valve Machined Valve Electrical Connector Side Panel Shielded Cable/ft Side Panel Machined Valve Shielded Cable/tt Door Decal Airframe fasteners Electrical Connector Gasket Pressure Gauge Airframe fasteners Electrical Connector Airframe fasteners Machined Valve Airframe fasteners Airframe fasteners Airframe fasteners Shielded Cable/ Electrical Connector Electrical Connector Hatch Decal Gasket Shielded Cable/ Airframe fasteners Airframe fasteners Gasket F $ 195.00 $ 1.65 $ 165 $ 1.65 $ 645.00 $ 645.00 $ 1.25 $ 175.00 $ 105 $ 195,00 $ 645.00 $ 1.10 $ 0.55 $ 4 25 $ 1.25 $ 3.75 $ 100.50 $ 4.25 $ 1.25 5 4.25 $ 655 50 $ 4.25 S 4.25 $ 4.25 $ 0.95 S 1.25 $ 1.25 $ 0.75 $ 3.75 $ 0.95 $ 4.25 $ 4.25 $ 3.75 G 110$ 4,500 $ 4,750's 4,850 S 150 $ 100 $ 5,650 $ 155 $ 22.500 5 130 S 1205 18,100 125$ 19.500 5 5,600 $ 1,850 $ 90 $ 15,500 $ 5,500 $ 18,000 5 125$ 12.500 5 15,000 $ 14,500 $ 25,000 $ 5,650 $ 5.4255 500 1,800 $ 17.500 5 17.500 5 17.0005 1.7505 H 21.450.00 7.425.00 7,837.50 8,002 50 96,750.00 64,500.00 7,062.50 27,125.00 23,625.00 25,350.00 77,400.00 19.910.00 68.75 82.875 00 7,000.00 6,93750 9,0450 65,875.00 6,875.00 76,500.00 81,937 50 53,125.00 63,750 00 61,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 6,562 50 1 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 15 J 12/05/15 08/28/15 09/05/15 09/02/15 10/15/15 10/10/15 10/01/15 10/25/15 08/25/15 10/28/15 10/28/15 08/25/15 12/05/15 08/05/15 08/25/15 09/25/15 10/10/15 09/04/15 09/01/15 10/01/15 10/10/15 09/05/15 09/08/15 09/28/15 09/05/15 09/05/15 09/10/15 08/25/15 09/28/15 09/15/15 10/25/15 10/13/15 09/20/15 K 12/17/15 09/05/15 09/13/15 09/13/15 10/26/15 10/21/15 10/06/15 12/03/15 09/02/15 12/07/15 12/04/15 09/05/15 12/10/15 08/13/15 08/29/15 10/05/15 10/17/15 09/13/15 09/06/15 10/08/15 10/17/15 09/13/15 09/15/15 10/03/15 09/13/15 09/10/15 09/15/15 08/31/15 10/05/15 09/22/15 12/03/15 10/19/15 09/25/15 1122 5066 3166 3166 9966 9764 5066 1122 1122 9764 Sheet1 +