Question

1 Approved Answer

Posted on Jul 27, 2024

for Q1-Identify the Suppliers who provide On-Time Delivery a Pivot table named as On-Time Delivery in which contains Vendor Names and Average Delivery Days and

for Q1-Identify the Suppliers who provide On-Time Delivery a Pivot table named as On-Time Delivery in which contains Vendor Names and Average Delivery Days and is sorted ascending by Average Delivery Time. (Hint: you must find out the "delivery days" from the data provided before creating the pivot table to solve this problem) Identify the best supplier who provides on-time delivery. for Q2- Identify suppliers who provide The Best Accounts Payable Terms a Pivot table named as Accts-Payable-Terms in which contains Vendor Names and Maximum A/P Terms and is sorted descending by Maximum A/P Terms. Identify the best supplier who provides the best Accounts Payable Terms. for Q3- Identify suppliers who offer lower pricing items when the same item can be provided by multiple suppliers a Pivot table named as Low-Pricing-Items in which contains Item description(column label), Vendor Names (row lable) and Minimum Item Cost. For cach item, identify the supplier who provides the lowest price for the item. The above Objects of your answers for Q1-Q3 should be ineluded in your Business Software ssignment I EXCEL file. Your answer for Q4 a summary of Q1-3-can be posted on a Separate worksheet of the same EXCEL file of Q1-3. 7 Hulkey Fasteners 8 Alum Sheeting 9 Durrable Products 10 Durrable Products 1 Hulkey Fasteners 2 Hulkey Fasteners 83 Hulkey Fasteners 34 Spacetime Technologies 35 Steelpin Inc. 36 Durrable Products 37 Hulkey Fasteners 38 Hulkey Fasteners 39 Spacetime Technologies 10 Fast-Tie Aerospace 41 Durrable Products 12 Durrable Products 43 Hulkey Fasteners 14 Spacetime Technologies 45 Steelpin Inc. 46 Durrable Products 47 Pylon Accessories 48 Pylon Accessories 49 Spacetime Technologies 50 Spacetime Technologies 51 Durrable Products 52 Fast-Tie Aerospace 53 Manlev Valve. C2323 B0247 1122 Airframe fasteners Airframe fasteners Gasket Bolt-nut package Airframe fasteners $ 4.25 $ 4.25 $ 3.65 $ 3.50 $ 4.25 $ 0.95 Electrical Connector $ 1.25 $ 3.55 Electrical Connector $ 1.65 $ 3.65 $ 4 25 Electrical Connector $ 1.25 $ 3.55 $ 2.45 $ 3.65 $ 220.00 $ 0.95 $ 3.55 $ 1.10 $ 3.65 $ 3.75 $ 3.75 $ 4.05 $ 3.55 $ 220 00 $ 2 45 S 2 85 15,500 S 65,875.00 38,250.00 7.245 25 13,650.00 53,125.00 23,750.00 7,062 50 17,040.00 7,837.50 5,365.50 63,750.00 6,781.25 16,276.75 2,940.00 4,562.50 1243 30 09/04/09 09/12/09 09/12/09 10/11/09 10/10/09 09/11/09 09/12/09 9,000 S 1,985 S 3,900 S 12,500 $ 25,000 S 5,650 S 4,800 S 4,750 S 1,470 $ 15,000 S 5,425 $ 4,585 $ 1,200 S 1,250 $ 500 S 110,000.00 17,500 $ 4,200 $ 16,500 S 1,450 S 1,980 S 1,750 $ 1,500 S 4,250 S 550 $ 121,000.00 2,500 S 1.300S A1346 A1457 C3434 C6765 C7875 A3467 B3042 30 9399 4569 1122 5066 3166 4111 5234 9399 1122 3166 09/05/09 09/05/09 09/05/09 45 45 30 09/05/09 Shielded Cable/t. 30 09/05/09 09/05/09 09/05/09 09/05/09 09/07/09 09/08/09 09/10/09 30 Bolt-nut package 09/10/09 25 30 09/20/09 09/13/09 10/12/09 09/15/09 A1345 C4545 Gasket Airframe fasteners 45 30 C8854 30 25 09/15/09 A5689 B2345 Bolt-nut package ORing Gasket Control Panel 4111 09/10/09 09/30/09 6321 9399 09/12/09 09/15/09 30 09/23/09 A1234 45 10/06/09 A1456 D1212 5454 45 10/20/09 09/22/09 10/15/09 10/05/09 09/15/09 09/15/09 5066 Shielded Cable/t 16,625. 00 30 Bolt-nut package Shielded Cable/A. A1222 4111 5319 9399 9764 9764 9752 4111 5454 6321 6431 09/15/09 09/15/09 09/18/09 14,910 00 25 6. A0204 18,150.00 5,292 60 7,425.00 6,562.50 6.075.00 15,087.50 30 10/08/09 09/29/09 09/25/09 09/25/09 A1235 B1111 D3333 Gasket 45 09/20/09 15 Gasket 15 09/20/09 Gasket 09/20/09 09/20/09 09/24/09 09/25/09 09/25/09 25 Gasket A0533 10/10/09 10/14/09 25 Bolt-nut package Control Panel O-Ring A1444 45 A1344 10/04/09 1001/09 6, 125.00 3.705. 00 30 50 B2356 A9821 O Rinn 7. Sheet1 On Time Delivery data 4 Vendor Name 5 Durrable Products 6 Hulkey Fasteners 7 Alum Sheeting 8 Fast-Tie Aerospace 9 Durrable Products 10 Fast-Tie Aerospace 11 Fast-Tie Aerospace 12 Steelpin Inc. 13 Durrable Products 14 Fast-Tie Aerospace 15 Fast-Tie Aerospace 16 Hulkey Fasteners 17 Hulkey Fasteners 18 Steelpin Inc. 19 Steelpin Inc. 20 Steelpin Inc. 21 Durrable Products 22 Alum Sheeting 23 Hulkey Fasteners 24 Steelpin Inc. 25 Steelpin Inc. 26 Steelpin Inc. 27 Hulkey Fasteners 28 Alum Sheeting 29 Durrable Products 30 Durrable Products Vendor No. Order No. Item No. Item Description Item Cost Quantity $ 90 00 $ 4 25 $ 4.25 $ 1.05 $ 90.00 $ 1.05 $ 1.05 $ 1.10 $ 4.20 $ 2 45 $ 1.05 S Cost per order AP Terms Order Date Arrival Date 9,000.00 82,875.00 42,500.00 24,150 00 10,800 00 22,575.00 23,625 00 19,250.00 63,000.00 3,185.00 23,625.00 7,000.00 375.00 15,937.50 19,910.00 7.425.00 B1234 7258 1122 1243 Pressure Gauge Airframe fasteners 100 $ 19,500 S 10,000 S 23,000 S 120 S 21,500 S 22,500 $ 17,500 S 15,000 $ 1,300 $ 22,500 S 5,600 $ 07/25/09 08/05/09 C1212 A0443 B2566 45 30 08/28/09 08/13/09 08/14/09 08/15/09 09/09/09 08/22/09 Airframe fasteners Shielded Cable/. Pressure Gauge Shielded Cable/ft 30 08/08/09 08/10/09 08/15/09 08/15/09 08/20/09 O8/20/09 08/25/09 08/25/09 08/25/09 08/25/09 08/25/09 08/25/09 08/25/09 5462 30 B1345 B2537 82519 7258 45 5462 5462 5319 30 Shielded Cable/ft Shielded Cable/ft. Airframe fasteners O-Ring Shielded Cable/t Electrical Connector Hatch Decal Bolt-nut package Shielded Cable/ft Electrical Connector Airframe fasteners Control Panel Electrical Connector Bolt-nut package 30 A0115 08/26/09 30 08/31/09 3. A1567 1369 6321 5462 3166 9966 4312 5319 45 09/30/09 09/04/09 09/02/09 08/29/09 08/31/09 09/01/09 09/05/09 09/05/09 B2333 30 C0433 C1313 C8989 A0123 C0589 B3041 B1666 A0446 C2929 A0207 B3111 30 1.25 S 0 75 $ 3.75 $ 110 $ 1.65 $ 4.20 $ 255.00 1 25 3.75 1.65 30 500 S 30 4,250 S 18, 100 $ 4,500 S 30 30 5234 30 08/28/09 3. 1369 08/29/09 09/01/09 10,000 S 406 S 103,530.00 42,000.00 45 10/04/09 5417 30 09/10/09 09/06/09 09/10/09 09/11/09 09/11/09 1. 3166 5,500 $ 09/01/09 6,875.00 15.750.00 30 6. 4312 4.200 S 30 09/01/09 8,002.50 15,562.50 65,876 00 38,250 00 7,245 25 5234 Electrical Connector 4.850 $ 30 09/02/09 09/03/09 $ 375 $ 4 25 $ 4 25 $ 3 65 4312 1122 1243 9399 4569 Sheet Bolt nut package Airframe fasteners 4.150 $ 15,500 S 9,000 S 1,905 S 3.900S 30 30 B0445 09/04/09 09/1209 C2323 B0247 A1346 A1457 09/05/09 09/05/09 0s0/09 09/12/09 10/11/09 30 45 45 Airframe fasteners Gasket Bolt-nut nackane 3. 101009 13.650.00 3.50 3. On Time Delivery data 54 Pylon Accessories 55 Spacetime Technologies 56 Spacetime Technologies 57 Durrable Products 58 Hulkey Fasteners 59 Pylon Accessories 60 Fast-Tie Aerospace 61 Hulkey Fasteners 62 Manley Valve 63 Pylon Accessories 64 Spacetime Technologies 65 Manley Valve 66 Spacetime Technologies 67 Spacetime Technologies 68 Alum Sheeting 69 Manley Valve 70 Manley Valve 71 Spacetime Technologies 72 Steelpin Inc. 73 Hulkey Fasteners 74 Fast-Tie Aerospace 75 Alum Sheeting 76 Manley Valve 77 Steelpin Inc. 78 Alum Sheeting 79 Manley Valve B0 Alum Sheatina $ 3.75 $ 4.05 $ 3.55 $ 4.20 $ 4.25 $ 3.75 8. 2 C2211 Gasket Gasket Bolt-nut package Airframe fasteners Airframe fasteners 9764 1,850 S 1,550 S 4,200 $ 6,937.50 15 25 25 09/25/09 09/25/09 10/05/09 A0622 A1445 B1468 9752 6,277.50 14,910.00 58,800.00 61,625.00 10/05/09 4111 09/25/09 09/27/09 10/25/09 1369 14,000 $ 14,500 S 1,800 $ 45 10/03/09 10/03/09 10/05/09 C5656 1122 30 15 09/28/09 8. D1111 9764 Gasket Electrical Connector Airframe fasteners O Ring O-Ring Shielded Cable/t. O-Ring O-Ring Bolt-nut package 6,750.00 7,062.50 76,500.00 3,847.50 09/28/09 C0234 5166 S 1.25 10/01/09 10/01/09 10/01/09 10/01/09 10/01/09 10/05/09 10/05/09 10/05/09 10/10/09 10/10/09 10/10/09 10/10/09 10/10/09 10/11/09 10/12/09 10/15/09 10/15/09 10/15/09 5,650 $ 18,000 S 1,350 S 30 10/06/09 C3232 A2378 1122 6431 4.25 $ 2.85 $ 2.95 $ 1.15 $ 2.85 $ 3.00 30 10/08/09 50 10/07/09 A9999 A0666 A2345 6433 1,500 S 15,000 $ 1,250 $ 1,100 S 4,600 $ 10,500 $ 90 S 125 S 900 $ 100 S 17,000 $ 1,250 $ 4,500 S 100 $ 150 $ 500 $ 127,500.00 95 $ 150 S 4,425.00 17,250.00 3,562.50 3,300.00 16,330.00 44,625 00 9,045.00 81,937.50 2,700.00 15 10/10/09 10/15/09 5125 25 50 25 25 30 50 50 25 30 30 6431 6489 10/10/09 10/10/09 A0555 A1449 B0567 4111 3.55 $ 4.25 $ 100.50 $ 655.50 $ 3.00 $ 645.00 $ 4.25 $ 2 45 $ 3.95 $ 100.50 S 645.00 $ 255.00 $ 100.50 5.185.00 10/19/09 10/17/09 10/17/09 10/17/09 10/18/09 10/21/09 10/19/09 10/21/09 10/20/09 1243 7258 8148 6489 8008 Airframe fasteners Pressure Gauge Machined Valve C2222 C3333 A0111 B3333 D3232 B2367 A0223 A9842 O-Ring 6. 64,500.00 Machined Valve 72,250.00 3,062.50 17,775.00 10,050.00 96,750.00 Airframe fasteners 1122 30 6321 4224 7258 8008 O-Ring Bolt-nut package Pressure Gauge Machined Valve 30 50 30 30 50 10/24/09 10/26/09 10/27/09 10/29/09 11/03/09 6. B3222 10/20/09 A0433 A2356 5417 Control Panel 9,547.50 27.750.00 10/20/09 Pressure Gauge 7258 30 10/25/09 R0447 5634 Side Panel 5. On Time Delivery data Sheet1 Formatting Table Styles Clipboard Font Alignment Number Styles Durrable Products A29 H. 25,000.00 3,675.00 27,125.00 74,375.00 25,350.00 77,400.00 25,900.00 3,150.00 26,250.00 10,450.00 525 00 82.50 23,400.00 9,975 00 30,625.00 467 50 $ 1.00 $ 2.45 $ 175.00 $ 4.25 $ 195.00 $ 645.00 $ 185.00 $ 3.00 $ 175.00 $ 95.00 $ 100 $ 0.55 $ 195.00 $ 95.00 $ 175.00 81 Durrable Products 82 Fast-Tie Aerospace 83 Fast-Tie Aerospace 84 Hulkey Fasteners 85 Steelpin Inc. 86 Steelpin Inc 87 Alum Sheeting 88 Spacetime Technologies 89 Fast-Tie Aerospace 90 Fast-Tie Aerospace 91 Manley Valve 92 Manley Valve 93 Steelpin Inc. 94 Fast-Tie Aerospace 95 Fast-Tie Aerospace 96 Manley Valve 97 Manley Valve 98 Steelpin Inc. 99 100 101 102 103 104 105 106 B1589 B2378 C0423 5275 6321 Shielded Cable/t. O-Ring 25,000 S 1,500 $ 155 S 45 10/25/09 10/25/09 10/25/09 10/25/09 10/28/09 10/30/09 11/02/09 11/03/09 11/03/09 30 30 30 30 4. 5689 1122 5677 8008 Side Panel Airframe fasteners Side Panel Machined Valve Side Panel 17,500 S 130 S 120 S 140 $ 1,050 S 150 S 110 S 525 $ 150 S 120 S D2121 C0456 11/07/09 11/04/09 11/04/09 30 10/28/09 C0467 30 25 30 10/29/09 10/29/09 B0479 5634 11/10/09 6489 A0777 O-Ring 11/09/09 11/12/09 11/07/09 11/06/09 11/13/09 11/16/09 11/15/09 11/11/09 11/10/09 11/17/09 11/01/09 4. B2498 5689 Side Panel 11/01/09 30 Pressure Gauge Panel Decal Door Decal Side Panel Pressure Gauge B2499 7268 50 50 11/01/09 9977 9955 5677 7268 5689 A2367 11/01/09 11/02/09 A9876 A0205 30 6. 30 11/05/09 105 175 $ 550 S 125 $ 110 S B2511 11/05/09 11/05/09 11/05/09 11/05/09 30 82528 Side Panel 50 Hatch Decal 0.85 A9865 9967 50 30 68 75 $ 0 55 $ 195.00 Door Decal Side Panel C1111 B3022 9955 5677 21,450 00 for Q1-Identify the Suppliers who provide On-Time Delivery a Pivot table named as On-Time Delivery in which contains Vendor Names and Average Delivery Days and is sorted ascending by Average Delivery Time. (Hint: you must find out the "delivery days" from the data provided before creating the pivot table to solve this problem) Identify the best supplier who provides on-time delivery. for Q2- Identify suppliers who provide The Best Accounts Payable Terms a Pivot table named as Accts-Payable-Terms in which contains Vendor Names and Maximum A/P Terms and is sorted descending by Maximum A/P Terms. Identify the best supplier who provides the best Accounts Payable Terms. for Q3- Identify suppliers who offer lower pricing items when the same item can be provided by multiple suppliers a Pivot table named as Low-Pricing-Items in which contains Item description(column label), Vendor Names (row lable) and Minimum Item Cost. For cach item, identify the supplier who provides the lowest price for the item. The above Objects of your answers for Q1-Q3 should be ineluded in your Business Software ssignment I EXCEL file. Your answer for Q4 a summary of Q1-3-can be posted on a Separate worksheet of the same EXCEL file of Q1-3. 7 Hulkey Fasteners 8 Alum Sheeting 9 Durrable Products 10 Durrable Products 1 Hulkey Fasteners 2 Hulkey Fasteners 83 Hulkey Fasteners 34 Spacetime Technologies 35 Steelpin Inc. 36 Durrable Products 37 Hulkey Fasteners 38 Hulkey Fasteners 39 Spacetime Technologies 10 Fast-Tie Aerospace 41 Durrable Products 12 Durrable Products 43 Hulkey Fasteners 14 Spacetime Technologies 45 Steelpin Inc. 46 Durrable Products 47 Pylon Accessories 48 Pylon Accessories 49 Spacetime Technologies 50 Spacetime Technologies 51 Durrable Products 52 Fast-Tie Aerospace 53 Manlev Valve. C2323 B0247 1122 Airframe fasteners Airframe fasteners Gasket Bolt-nut package Airframe fasteners $ 4.25 $ 4.25 $ 3.65 $ 3.50 $ 4.25 $ 0.95 Electrical Connector $ 1.25 $ 3.55 Electrical Connector $ 1.65 $ 3.65 $ 4 25 Electrical Connector $ 1.25 $ 3.55 $ 2.45 $ 3.65 $ 220.00 $ 0.95 $ 3.55 $ 1.10 $ 3.65 $ 3.75 $ 3.75 $ 4.05 $ 3.55 $ 220 00 $ 2 45 S 2 85 15,500 S 65,875.00 38,250.00 7.245 25 13,650.00 53,125.00 23,750.00 7,062 50 17,040.00 7,837.50 5,365.50 63,750.00 6,781.25 16,276.75 2,940.00 4,562.50 1243 30 09/04/09 09/12/09 09/12/09 10/11/09 10/10/09 09/11/09 09/12/09 9,000 S 1,985 S 3,900 S 12,500 $ 25,000 S 5,650 S 4,800 S 4,750 S 1,470 $ 15,000 S 5,425 $ 4,585 $ 1,200 S 1,250 $ 500 S 110,000.00 17,500 $ 4,200 $ 16,500 S 1,450 S 1,980 S 1,750 $ 1,500 S 4,250 S 550 $ 121,000.00 2,500 S 1.300S A1346 A1457 C3434 C6765 C7875 A3467 B3042 30 9399 4569 1122 5066 3166 4111 5234 9399 1122 3166 09/05/09 09/05/09 09/05/09 45 45 30 09/05/09 Shielded Cable/t. 30 09/05/09 09/05/09 09/05/09 09/05/09 09/07/09 09/08/09 09/10/09 30 Bolt-nut package 09/10/09 25 30 09/20/09 09/13/09 10/12/09 09/15/09 A1345 C4545 Gasket Airframe fasteners 45 30 C8854 30 25 09/15/09 A5689 B2345 Bolt-nut package ORing Gasket Control Panel 4111 09/10/09 09/30/09 6321 9399 09/12/09 09/15/09 30 09/23/09 A1234 45 10/06/09 A1456 D1212 5454 45 10/20/09 09/22/09 10/15/09 10/05/09 09/15/09 09/15/09 5066 Shielded Cable/t 16,625. 00 30 Bolt-nut package Shielded Cable/A. A1222 4111 5319 9399 9764 9764 9752 4111 5454 6321 6431 09/15/09 09/15/09 09/18/09 14,910 00 25 6. A0204 18,150.00 5,292 60 7,425.00 6,562.50 6.075.00 15,087.50 30 10/08/09 09/29/09 09/25/09 09/25/09 A1235 B1111 D3333 Gasket 45 09/20/09 15 Gasket 15 09/20/09 Gasket 09/20/09 09/20/09 09/24/09 09/25/09 09/25/09 25 Gasket A0533 10/10/09 10/14/09 25 Bolt-nut package Control Panel O-Ring A1444 45 A1344 10/04/09 1001/09 6, 125.00 3.705. 00 30 50 B2356 A9821 O Rinn 7. Sheet1 On Time Delivery data 4 Vendor Name 5 Durrable Products 6 Hulkey Fasteners 7 Alum Sheeting 8 Fast-Tie Aerospace 9 Durrable Products 10 Fast-Tie Aerospace 11 Fast-Tie Aerospace 12 Steelpin Inc. 13 Durrable Products 14 Fast-Tie Aerospace 15 Fast-Tie Aerospace 16 Hulkey Fasteners 17 Hulkey Fasteners 18 Steelpin Inc. 19 Steelpin Inc. 20 Steelpin Inc. 21 Durrable Products 22 Alum Sheeting 23 Hulkey Fasteners 24 Steelpin Inc. 25 Steelpin Inc. 26 Steelpin Inc. 27 Hulkey Fasteners 28 Alum Sheeting 29 Durrable Products 30 Durrable Products Vendor No. Order No. Item No. Item Description Item Cost Quantity $ 90 00 $ 4 25 $ 4.25 $ 1.05 $ 90.00 $ 1.05 $ 1.05 $ 1.10 $ 4.20 $ 2 45 $ 1.05 S Cost per order AP Terms Order Date Arrival Date 9,000.00 82,875.00 42,500.00 24,150 00 10,800 00 22,575.00 23,625 00 19,250.00 63,000.00 3,185.00 23,625.00 7,000.00 375.00 15,937.50 19,910.00 7.425.00 B1234 7258 1122 1243 Pressure Gauge Airframe fasteners 100 $ 19,500 S 10,000 S 23,000 S 120 S 21,500 S 22,500 $ 17,500 S 15,000 $ 1,300 $ 22,500 S 5,600 $ 07/25/09 08/05/09 C1212 A0443 B2566 45 30 08/28/09 08/13/09 08/14/09 08/15/09 09/09/09 08/22/09 Airframe fasteners Shielded Cable/. Pressure Gauge Shielded Cable/ft 30 08/08/09 08/10/09 08/15/09 08/15/09 08/20/09 O8/20/09 08/25/09 08/25/09 08/25/09 08/25/09 08/25/09 08/25/09 08/25/09 5462 30 B1345 B2537 82519 7258 45 5462 5462 5319 30 Shielded Cable/ft Shielded Cable/ft. Airframe fasteners O-Ring Shielded Cable/t Electrical Connector Hatch Decal Bolt-nut package Shielded Cable/ft Electrical Connector Airframe fasteners Control Panel Electrical Connector Bolt-nut package 30 A0115 08/26/09 30 08/31/09 3. A1567 1369 6321 5462 3166 9966 4312 5319 45 09/30/09 09/04/09 09/02/09 08/29/09 08/31/09 09/01/09 09/05/09 09/05/09 B2333 30 C0433 C1313 C8989 A0123 C0589 B3041 B1666 A0446 C2929 A0207 B3111 30 1.25 S 0 75 $ 3.75 $ 110 $ 1.65 $ 4.20 $ 255.00 1 25 3.75 1.65 30 500 S 30 4,250 S 18, 100 $ 4,500 S 30 30 5234 30 08/28/09 3. 1369 08/29/09 09/01/09 10,000 S 406 S 103,530.00 42,000.00 45 10/04/09 5417 30 09/10/09 09/06/09 09/10/09 09/11/09 09/11/09 1. 3166 5,500 $ 09/01/09 6,875.00 15.750.00 30 6. 4312 4.200 S 30 09/01/09 8,002.50 15,562.50 65,876 00 38,250 00 7,245 25 5234 Electrical Connector 4.850 $ 30 09/02/09 09/03/09 $ 375 $ 4 25 $ 4 25 $ 3 65 4312 1122 1243 9399 4569 Sheet Bolt nut package Airframe fasteners 4.150 $ 15,500 S 9,000 S 1,905 S 3.900S 30 30 B0445 09/04/09 09/1209 C2323 B0247 A1346 A1457 09/05/09 09/05/09 0s0/09 09/12/09 10/11/09 30 45 45 Airframe fasteners Gasket Bolt-nut nackane 3. 101009 13.650.00 3.50 3. On Time Delivery data 54 Pylon Accessories 55 Spacetime Technologies 56 Spacetime Technologies 57 Durrable Products 58 Hulkey Fasteners 59 Pylon Accessories 60 Fast-Tie Aerospace 61 Hulkey Fasteners 62 Manley Valve 63 Pylon Accessories 64 Spacetime Technologies 65 Manley Valve 66 Spacetime Technologies 67 Spacetime Technologies 68 Alum Sheeting 69 Manley Valve 70 Manley Valve 71 Spacetime Technologies 72 Steelpin Inc. 73 Hulkey Fasteners 74 Fast-Tie Aerospace 75 Alum Sheeting 76 Manley Valve 77 Steelpin Inc. 78 Alum Sheeting 79 Manley Valve B0 Alum Sheatina $ 3.75 $ 4.05 $ 3.55 $ 4.20 $ 4.25 $ 3.75 8. 2 C2211 Gasket Gasket Bolt-nut package Airframe fasteners Airframe fasteners 9764 1,850 S 1,550 S 4,200 $ 6,937.50 15 25 25 09/25/09 09/25/09 10/05/09 A0622 A1445 B1468 9752 6,277.50 14,910.00 58,800.00 61,625.00 10/05/09 4111 09/25/09 09/27/09 10/25/09 1369 14,000 $ 14,500 S 1,800 $ 45 10/03/09 10/03/09 10/05/09 C5656 1122 30 15 09/28/09 8. D1111 9764 Gasket Electrical Connector Airframe fasteners O Ring O-Ring Shielded Cable/t. O-Ring O-Ring Bolt-nut package 6,750.00 7,062.50 76,500.00 3,847.50 09/28/09 C0234 5166 S 1.25 10/01/09 10/01/09 10/01/09 10/01/09 10/01/09 10/05/09 10/05/09 10/05/09 10/10/09 10/10/09 10/10/09 10/10/09 10/10/09 10/11/09 10/12/09 10/15/09 10/15/09 10/15/09 5,650 $ 18,000 S 1,350 S 30 10/06/09 C3232 A2378 1122 6431 4.25 $ 2.85 $ 2.95 $ 1.15 $ 2.85 $ 3.00 30 10/08/09 50 10/07/09 A9999 A0666 A2345 6433 1,500 S 15,000 $ 1,250 $ 1,100 S 4,600 $ 10,500 $ 90 S 125 S 900 $ 100 S 17,000 $ 1,250 $ 4,500 S 100 $ 150 $ 500 $ 127,500.00 95 $ 150 S 4,425.00 17,250.00 3,562.50 3,300.00 16,330.00 44,625 00 9,045.00 81,937.50 2,700.00 15 10/10/09 10/15/09 5125 25 50 25 25 30 50 50 25 30 30 6431 6489 10/10/09 10/10/09 A0555 A1449 B0567 4111 3.55 $ 4.25 $ 100.50 $ 655.50 $ 3.00 $ 645.00 $ 4.25 $ 2 45 $ 3.95 $ 100.50 S 645.00 $ 255.00 $ 100.50 5.185.00 10/19/09 10/17/09 10/17/09 10/17/09 10/18/09 10/21/09 10/19/09 10/21/09 10/20/09 1243 7258 8148 6489 8008 Airframe fasteners Pressure Gauge Machined Valve C2222 C3333 A0111 B3333 D3232 B2367 A0223 A9842 O-Ring 6. 64,500.00 Machined Valve 72,250.00 3,062.50 17,775.00 10,050.00 96,750.00 Airframe fasteners 1122 30 6321 4224 7258 8008 O-Ring Bolt-nut package Pressure Gauge Machined Valve 30 50 30 30 50 10/24/09 10/26/09 10/27/09 10/29/09 11/03/09 6. B3222 10/20/09 A0433 A2356 5417 Control Panel 9,547.50 27.750.00 10/20/09 Pressure Gauge 7258 30 10/25/09 R0447 5634 Side Panel 5. On Time Delivery data Sheet1 Formatting Table Styles Clipboard Font Alignment Number Styles Durrable Products A29 H. 25,000.00 3,675.00 27,125.00 74,375.00 25,350.00 77,400.00 25,900.00 3,150.00 26,250.00 10,450.00 525 00 82.50 23,400.00 9,975 00 30,625.00 467 50 $ 1.00 $ 2.45 $ 175.00 $ 4.25 $ 195.00 $ 645.00 $ 185.00 $ 3.00 $ 175.00 $ 95.00 $ 100 $ 0.55 $ 195.00 $ 95.00 $ 175.00 81 Durrable Products 82 Fast-Tie Aerospace 83 Fast-Tie Aerospace 84 Hulkey Fasteners 85 Steelpin Inc. 86 Steelpin Inc 87 Alum Sheeting 88 Spacetime Technologies 89 Fast-Tie Aerospace 90 Fast-Tie Aerospace 91 Manley Valve 92 Manley Valve 93 Steelpin Inc. 94 Fast-Tie Aerospace 95 Fast-Tie Aerospace 96 Manley Valve 97 Manley Valve 98 Steelpin Inc. 99 100 101 102 103 104 105 106 B1589 B2378 C0423 5275 6321 Shielded Cable/t. O-Ring 25,000 S 1,500 $ 155 S 45 10/25/09 10/25/09 10/25/09 10/25/09 10/28/09 10/30/09 11/02/09 11/03/09 11/03/09 30 30 30 30 4. 5689 1122 5677 8008 Side Panel Airframe fasteners Side Panel Machined Valve Side Panel 17,500 S 130 S 120 S 140 $ 1,050 S 150 S 110 S 525 $ 150 S 120 S D2121 C0456 11/07/09 11/04/09 11/04/09 30 10/28/09 C0467 30 25 30 10/29/09 10/29/09 B0479 5634 11/10/09 6489 A0777 O-Ring 11/09/09 11/12/09 11/07/09 11/06/09 11/13/09 11/16/09 11/15/09 11/11/09 11/10/09 11/17/09 11/01/09 4. B2498 5689 Side Panel 11/01/09 30 Pressure Gauge Panel Decal Door Decal Side Panel Pressure Gauge B2499 7268 50 50 11/01/09 9977 9955 5677 7268 5689 A2367 11/01/09 11/02/09 A9876 A0205 30 6. 30 11/05/09 105 175 $ 550 S 125 $ 110 S B2511 11/05/09 11/05/09 11/05/09 11/05/09 30 82528 Side Panel 50 Hatch Decal 0.85 A9865 9967 50 30 68 75 $ 0 55 $ 195.00 Door Decal Side Panel C1111 B3022 9955 5677 21,450 00