Create a spread sheet and show and explain steps so i can follow.

Software skills: Spreadsheet date functions, Business skills: Analyzing supplier performance and pricing 1. 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. Attached, 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. Create three additional sheets from the Master Excel spreadsheet I provided you. They will be: 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 Create One Chart on anything that you have done. 2 Orders and Suppliers 3 4 Vendor No. Order No. Item No. Item Description Item Cost Quantity Cost per order A/P Terms Order Date Arrival Date 5 A0111 6489 O-Ring $ 3.00 900 $ 2,700.00 25 10/10/15 10/18/15 6 A0125 5319 Shielded Cable/ft. $ 1.10 17,500 $ 19,250.00 30 08/20/15 08/31/15 7 A0123 4312 Bolt-nut package $ 3.75 4,250 $ 15,937.50 30 08/25/15 09/01/15 8 A0204 5319 Shielded Cable/ft. $ 1.10 16,500 $ 18,150.00 30 09/15/15 10/05/15 9 A0205 5677 Side Panel $ 195.00 120$ 23,400.00 30 12/02/15 12/13/15 10 6 A0207 4312 Bolt-nut package $ 3.75 4,200 $ 15,750.00 30 09/01/15 09/10/15 11 5 A0223 4224 Bolt-nut package $ 3.95 4,500 $ 17,775.00 30 10/15/15 10/20/15 12 5 A0433 5417 Control Panel $ 255.00 500 $ 127,500.00 30 10/20/15 10/27/15 13 5 A0443 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 30 08/08/15 08/14/15 14 5 A0446 5417 Control Panel $ 255.00 406 $ 103,530.00 30 09/01/15 09/10/15 15 2 A0533 9752 Gasket $ 4.05 1,500 $ 6,075.00 25 09/20/15 09/25/15 16 2 A0555 6489 O-Ring $ 3.00 1,100 $ 3,300.00 25 10/05/15 10/10/15 17 A0622 9752 Gasket $ 4.05 1,550 $ 6,277.50 25 09/25/15 10/05/15 18 A0666 5125 Shielded Cable/ft. $ 1.15 15,000 $ 17,250.00 25 10/01/15 10/15/15 19 2 A0777 6489 O-Ring $ 3.00 1,050 $ 3,150.00 25 10/29/15 12/10/15 20 2 A1222 4111 Bolt-nut package $ 3.55 4,200 $ 14,910.00 25 09/15/15 10/15/15 21 3 A1234 9399 Gasket $ 3.65 1,250 $ 4,562.50 45 10/01/15 10/06/15 22 3 A1235 9399 Gasket $ 3.65 1,450 $ 5,292.50 45 10/03/15 10/08/15 23 3 A1344 5454 Control Panel $ 220.00 550 $ 121,000.00 45 10/09/15 10/14/15 24 3 A1345 9399 Gasket $ 3.65 1,470$ 5,365.50 45 10/07/15 10/13/15 25 A1346 9399 Gasket $ 3.65 1,985 $ 7,245.25 45 10/05/15 10/11/12 26 2 A1444 4111 Bolt-nut package $ 3.55 4,250 $ 15,087.50 09/20/15 10/10/15 NWw wWwNNNNNNU U U U O O O O ON 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 2 2 3 3 3 7 7 7 7 2 2 7 7 7 7 8 5 6 5 5 5 8 3 3 A1445 A1449 A1456 A1457 A1567 A2345 A2356 A2367 A2378 A3467 A5689 A9821 A9842 A9865 A9876 A9999 B0247 B0445 B0447 B0479 B0567 B1111 B1234 B1345 B1468 4111 4111 5454 4569 1369 6431 7258 9977 6431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5634 1243 9764 7258 7258 1369 Bolt-nut package Bolt-nut package Control Panel Bolt-nut package Airframe fasteners O-Ring Pressure Gauge 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 $ 3.55 $ 3.55 $ 220.00 $ 3.50 $ 4.20 $ 2.85 $ 100.50 $ 1.00 $ 2.85 $ 3.55 $ 3.55 $ 2.85 $ 100.50 0.85 $ 0.55 $ 2.95 $ 4.25 $ 3.75 $ 185.00 $ 185.00 $ 4.25 $ 3.75 $ 90.00 $ 90.00 $ 4.20 4,200 $ 14,910.00 4,600 $ 16,330.00 500 $ 110,000.00 3,900 $ 13,650.00 15,000 $ 63,000.00 1,250 $ 3,562.50 95 $ 9,547.50 525 $ 525.00 1,350 $ 3,847.50 4,800 $ 17,040.00 4,585 $ 16,276.75 1,300 $ 3,705.00 100 $ 10,050.00 550 $ 467.50 150 $ 82.50 1,500$ 4,425.00 9,000 $ 38,250.00 4,150 $ 15,562.50 150 $ 27,750.00 140 $ 25,900.00 10,500 $ 44,625.00 1,980 $ 7,425.00 100 $ 9,000.00 120$ 10,800.00 14,000 $ 58,800.00 25 25 45 45 45 30 30 30 30 25 25 30 30 30 30 15 30 30 30 30 30 15 45 45 45 09/25/15 10/05/15 10/15/15 10/05/15 09/25/15 10/05/15 10/20/15 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 10/19/15 10/20/15 10/10/15 09/30/15 10/10/15 10/29/15 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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 3 3 4 4 4 4 4 4 4 4 4 4 4 4 6 6 6 6 6 6 4 4 4 6 6 6 B1589 B1666 B2333 B2345 B2356 B2367 B2378 B2498 B2499 B2511 B2519 B2528 B2537 B2566 B3022 B3041 B3042 B3111 B3222 B3333 C0234 C0423 C0433 C0456 C0467 C0589 5275 1369 6321 6321 6321 6321 6321 5689 7268 7268 5462 5689 5462 5462 5677 5234 5234 5234 8008 8008 5166 5689 5462 5677 8008 5319 Shielded Cable/ft. $ 1.00 Airframe fasteners $ 4.20 O-Ring $ 2.45 O-Ring $ 2.45 O-Ring $ 2.45 O-Ring $ 2.45 O-Ring $ 2.45 Side Panel $ 175.00 Pressure Gauge $ 95.00 Pressure Gauge $ 95.00 Shielded Cable/ft. $ 1.05 Side Panel $ 175.00 Shielded Cable/ft. $ 1.05 Shielded Cable/ft. $ 1.05 Side Panel $ 195.00 Electrical Connector $ 1.65 Electrical Connector $ 1.65 Electrical Connector $ 1.65 Machined Valve $ 645.00 Machined Valve $ 645.00 Electrical Connector $ 1.25 Side Panel $ 175.00 Shielded Cable/ft. $ 1.05 Side Panel $ 195.00 Machined Valve $ 645.00 Shielded Cable/ft. $ 1.10 25,000 $ 10,000 $ 1,300 $ 1,200 $ 2,500 $ 1,250 $ 1,500$ 150 $ 110$ 105 $ 22,500 $ 175 $ 21,500 $ 23,000 $ 110 $ 4,500 $ 4,750 $ 4,850 $ 150 $ 100 $ 5,650 $ 155$ 22,500 $ 130$ 120$ 18,100 $ 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 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 45 45 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 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 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 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 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 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 7 1 1 8 7 1 1 1 7 1 1 1 1 C1111 C1212 C1313 C2211 C2222 C2323 C2929 C3232 C3333 C3434 C4545 C5656 C6765 C7875 C8854 C8989 D1111 D1212 D2121 D3232 D3333 9955 1122 3166 9764 7258 1122 3166 1122 8148 1122 1122 1122 5066 3166 3166 9966 9764 5066 1122 1122 9764 Door Decal $ 0.55 Airframe fasteners $ 4.25 Electrical Connector $ 1.25 Gasket $ 3.75 Pressure Gauge $ 100.50 Airframe fasteners $ 4.25 Electrical Connector $ 1.25 Airframe fasteners $ 4.25 Machined Valve $ 655.50 Airframe fasteners $ 4.25 Airframe fasteners $ 4.25 Airframe fasteners $ 4.25 Shielded Cable/ft. $ 0.95 Electrical Connector $ 1.25 Electrical Connector $ 1.25 Hatch Decal $ 0.75 Gasket $ 3.75 Shielded Cable/ft. $ 0.95 Airframe fasteners $ 4.25 Airframe fasteners $ 4.25 Gasket $ 3.75 125 $ 19,500 $ 5,600 $ 1,850 $ 90$ 15,500 $ 5,500 $ 18,000 $ 125 $ 12,500 $ 15,000 $ 14,500 $ 25,000 $ 5,650 5,425 $ 500 $ 1,800 $ 17,500 $ 17,500 $ 17,000 $ 1,750 $ 68.75 82,875.00 7,000.00 6,937.50 9,045.00 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 30 30 30 15 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 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/0 09/10/15 08/25/15 09/28/15 09/15/15 10/25/15 10/13/15 09/20/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 1 1 8 1 1 1 8 Software skills: Spreadsheet date functions, Business skills: Analyzing supplier performance and pricing 1. 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. Attached, 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. Create three additional sheets from the Master Excel spreadsheet I provided you. They will be: 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 Create One Chart on anything that you have done. 2 Orders and Suppliers 3 4 Vendor No. Order No. Item No. Item Description Item Cost Quantity Cost per order A/P Terms Order Date Arrival Date 5 A0111 6489 O-Ring $ 3.00 900 $ 2,700.00 25 10/10/15 10/18/15 6 A0125 5319 Shielded Cable/ft. $ 1.10 17,500 $ 19,250.00 30 08/20/15 08/31/15 7 A0123 4312 Bolt-nut package $ 3.75 4,250 $ 15,937.50 30 08/25/15 09/01/15 8 A0204 5319 Shielded Cable/ft. $ 1.10 16,500 $ 18,150.00 30 09/15/15 10/05/15 9 A0205 5677 Side Panel $ 195.00 120$ 23,400.00 30 12/02/15 12/13/15 10 6 A0207 4312 Bolt-nut package $ 3.75 4,200 $ 15,750.00 30 09/01/15 09/10/15 11 5 A0223 4224 Bolt-nut package $ 3.95 4,500 $ 17,775.00 30 10/15/15 10/20/15 12 5 A0433 5417 Control Panel $ 255.00 500 $ 127,500.00 30 10/20/15 10/27/15 13 5 A0443 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 30 08/08/15 08/14/15 14 5 A0446 5417 Control Panel $ 255.00 406 $ 103,530.00 30 09/01/15 09/10/15 15 2 A0533 9752 Gasket $ 4.05 1,500 $ 6,075.00 25 09/20/15 09/25/15 16 2 A0555 6489 O-Ring $ 3.00 1,100 $ 3,300.00 25 10/05/15 10/10/15 17 A0622 9752 Gasket $ 4.05 1,550 $ 6,277.50 25 09/25/15 10/05/15 18 A0666 5125 Shielded Cable/ft. $ 1.15 15,000 $ 17,250.00 25 10/01/15 10/15/15 19 2 A0777 6489 O-Ring $ 3.00 1,050 $ 3,150.00 25 10/29/15 12/10/15 20 2 A1222 4111 Bolt-nut package $ 3.55 4,200 $ 14,910.00 25 09/15/15 10/15/15 21 3 A1234 9399 Gasket $ 3.65 1,250 $ 4,562.50 45 10/01/15 10/06/15 22 3 A1235 9399 Gasket $ 3.65 1,450 $ 5,292.50 45 10/03/15 10/08/15 23 3 A1344 5454 Control Panel $ 220.00 550 $ 121,000.00 45 10/09/15 10/14/15 24 3 A1345 9399 Gasket $ 3.65 1,470$ 5,365.50 45 10/07/15 10/13/15 25 A1346 9399 Gasket $ 3.65 1,985 $ 7,245.25 45 10/05/15 10/11/12 26 2 A1444 4111 Bolt-nut package $ 3.55 4,250 $ 15,087.50 09/20/15 10/10/15 NWw wWwNNNNNNU U U U O O O O ON 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 2 2 3 3 3 7 7 7 7 2 2 7 7 7 7 8 5 6 5 5 5 8 3 3 A1445 A1449 A1456 A1457 A1567 A2345 A2356 A2367 A2378 A3467 A5689 A9821 A9842 A9865 A9876 A9999 B0247 B0445 B0447 B0479 B0567 B1111 B1234 B1345 B1468 4111 4111 5454 4569 1369 6431 7258 9977 6431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5634 1243 9764 7258 7258 1369 Bolt-nut package Bolt-nut package Control Panel Bolt-nut package Airframe fasteners O-Ring Pressure Gauge 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 $ 3.55 $ 3.55 $ 220.00 $ 3.50 $ 4.20 $ 2.85 $ 100.50 $ 1.00 $ 2.85 $ 3.55 $ 3.55 $ 2.85 $ 100.50 0.85 $ 0.55 $ 2.95 $ 4.25 $ 3.75 $ 185.00 $ 185.00 $ 4.25 $ 3.75 $ 90.00 $ 90.00 $ 4.20 4,200 $ 14,910.00 4,600 $ 16,330.00 500 $ 110,000.00 3,900 $ 13,650.00 15,000 $ 63,000.00 1,250 $ 3,562.50 95 $ 9,547.50 525 $ 525.00 1,350 $ 3,847.50 4,800 $ 17,040.00 4,585 $ 16,276.75 1,300 $ 3,705.00 100 $ 10,050.00 550 $ 467.50 150 $ 82.50 1,500$ 4,425.00 9,000 $ 38,250.00 4,150 $ 15,562.50 150 $ 27,750.00 140 $ 25,900.00 10,500 $ 44,625.00 1,980 $ 7,425.00 100 $ 9,000.00 120$ 10,800.00 14,000 $ 58,800.00 25 25 45 45 45 30 30 30 30 25 25 30 30 30 30 15 30 30 30 30 30 15 45 45 45 09/25/15 10/05/15 10/15/15 10/05/15 09/25/15 10/05/15 10/20/15 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 10/19/15 10/20/15 10/10/15 09/30/15 10/10/15 10/29/15 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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 3 3 4 4 4 4 4 4 4 4 4 4 4 4 6 6 6 6 6 6 4 4 4 6 6 6 B1589 B1666 B2333 B2345 B2356 B2367 B2378 B2498 B2499 B2511 B2519 B2528 B2537 B2566 B3022 B3041 B3042 B3111 B3222 B3333 C0234 C0423 C0433 C0456 C0467 C0589 5275 1369 6321 6321 6321 6321 6321 5689 7268 7268 5462 5689 5462 5462 5677 5234 5234 5234 8008 8008 5166 5689 5462 5677 8008 5319 Shielded Cable/ft. $ 1.00 Airframe fasteners $ 4.20 O-Ring $ 2.45 O-Ring $ 2.45 O-Ring $ 2.45 O-Ring $ 2.45 O-Ring $ 2.45 Side Panel $ 175.00 Pressure Gauge $ 95.00 Pressure Gauge $ 95.00 Shielded Cable/ft. $ 1.05 Side Panel $ 175.00 Shielded Cable/ft. $ 1.05 Shielded Cable/ft. $ 1.05 Side Panel $ 195.00 Electrical Connector $ 1.65 Electrical Connector $ 1.65 Electrical Connector $ 1.65 Machined Valve $ 645.00 Machined Valve $ 645.00 Electrical Connector $ 1.25 Side Panel $ 175.00 Shielded Cable/ft. $ 1.05 Side Panel $ 195.00 Machined Valve $ 645.00 Shielded Cable/ft. $ 1.10 25,000 $ 10,000 $ 1,300 $ 1,200 $ 2,500 $ 1,250 $ 1,500$ 150 $ 110$ 105 $ 22,500 $ 175 $ 21,500 $ 23,000 $ 110 $ 4,500 $ 4,750 $ 4,850 $ 150 $ 100 $ 5,650 $ 155$ 22,500 $ 130$ 120$ 18,100 $ 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 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 45 45 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 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 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 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 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 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 7 1 1 8 7 1 1 1 7 1 1 1 1 C1111 C1212 C1313 C2211 C2222 C2323 C2929 C3232 C3333 C3434 C4545 C5656 C6765 C7875 C8854 C8989 D1111 D1212 D2121 D3232 D3333 9955 1122 3166 9764 7258 1122 3166 1122 8148 1122 1122 1122 5066 3166 3166 9966 9764 5066 1122 1122 9764 Door Decal $ 0.55 Airframe fasteners $ 4.25 Electrical Connector $ 1.25 Gasket $ 3.75 Pressure Gauge $ 100.50 Airframe fasteners $ 4.25 Electrical Connector $ 1.25 Airframe fasteners $ 4.25 Machined Valve $ 655.50 Airframe fasteners $ 4.25 Airframe fasteners $ 4.25 Airframe fasteners $ 4.25 Shielded Cable/ft. $ 0.95 Electrical Connector $ 1.25 Electrical Connector $ 1.25 Hatch Decal $ 0.75 Gasket $ 3.75 Shielded Cable/ft. $ 0.95 Airframe fasteners $ 4.25 Airframe fasteners $ 4.25 Gasket $ 3.75 125 $ 19,500 $ 5,600 $ 1,850 $ 90$ 15,500 $ 5,500 $ 18,000 $ 125 $ 12,500 $ 15,000 $ 14,500 $ 25,000 $ 5,650 5,425 $ 500 $ 1,800 $ 17,500 $ 17,500 $ 17,000 $ 1,750 $ 68.75 82,875.00 7,000.00 6,937.50 9,045.00 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 30 30 30 15 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 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/0 09/10/15 08/25/15 09/28/15 09/15/15 10/25/15 10/13/15 09/20/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 1 1 8 1 1 1 8