Instructions This is a data analysis EXCEL assignment Improve Decision Making: Use A Spreadsheet to Select Suppliers) 1. Download the data file. (See the attachment in xlsx format) 2. Read and follow the instructions as listed below: My expectation on this Business Software Assignment#1 are listed below: 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 Days. (Hint: you must find out the "delivery days" from the data set 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 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 each item, identify the supplier who provides the lowest price for the item. The above Objects of your answers for Q1-Q3 should be included in your Business Software Assignment 1 EXCEL file. Your answer for Q4-a summary of Q1-3--can be placed in a seperate worksheet (named it as Q4) of the same EXCEL file above. 3. Turn in your completed assignment (ensue that it is in .xlsx format) to this drop box in a timely manner. data Sheet1 0 F H K D B 0 0 Orders and Suppliers Vendor Name Vendor No Durable Products 3 Hukey Fastonen 1 Alum Sheeting 5 Fastle Aerospace 4 Durable Products 3 10 Fast-Tin Aerospace 4 11 Fast-Tie Aerospace 4 12 Steelpin Inc 6 Durable Products 3 14 Fast-Tie Acrospace 4 15 Fast-Te Aoroso 4 10 Hukey Fasteners 1 17 Hukey Fasteners 1 10 Stepinine 6 19 Stepinine 5 20 Steelpin Inc 5 21 Durable Products 3 22 Alum Sheeting 5 23 Hukey Fasteners 1 24 Steelpin Inc 6 29 steelpin in 0 20 Stein Inc 6 27 Hulkey Fasteners 1 20 Alum Shooting 5 29 Durable Products 3 30 Durable Products 3 31 Hukey Fasteners 1 12 Hukey Fasteners 1 23 Hulkey Fasten 1 34 Spacetime Technologies 2 35 Sleepin Inc 5 30 Durable Products 3 27 Hukey Fasteners 1 Hukey Fasteners 1 0 AVERADE Order No. Item No. B1234 7258 C1212 1122 A0443 1243 B2568 5462 B1345 7258 B2537 5452 82519 5462 A0115 5319 A 1567 1369 B2333 8321 C0433 5452 C1313 3166 C8989 9966 A0123 4312 C0589 5319 33041 5234 B1666 1369 A0446 5417 C2929 3166 A0207 4312 B3111 5234 00445 4312 C2323 1122 B0247 1243 A1346 9399 A1457 4560 C3444 1122 C6765 5066 C7875 3166 A3467 4111 33042 5234 A1345 9399 C4545 1122 CASA 3166 Item Description Pressure Gauge Airframe fasteners Alframe fastoners Shielded Cable Pressure Gauge Shielded Cable Shielded Cable/ Shielded Cable Airframe fasteners O-Ring Shielded Cable Electrical Connector Hatch Decal Boll-nut package Shielded Cable Electrical Connector Airframe fosteners Control Panel Electrical Connector Boll-nut package Electrical Connector Bohnut package Airframe fasteners Airframe fasteners Gasket Bollut package Airframe fasteners Shielded Cable/ Electrical Connector Bollnut package Electrical Connector Gasket Airframe fasteners Electrical Connector Item Cost Quantity Cost per order A/P Terms $ 90.00 100 $ 9,000.00 45 5 4.25 19,500 $ 82,875.00 30 $ 4.25 10,000 $ 42,500.00 30 $1.05 23,000 24,150.00 30 $ 90,00 120$ 10,800.00 45 $ 1.05 21,500 22,575.00 30 1.05 22,500 23,625.00 30 $ 1.10 17,500 5 19,250.00 30 $ 4.20 15,000 $ 63,000.00 45 $ 2.45 1,300 $ 3.185.00 30 $ 1.05 22.500 5 23,625.00 30 $ 125 5,000$ 7,000.00 30 $ 0.75 500$ 375.00 30 $ 3.75 4,250 $ 15,907.50 30 $ 1.10 18.100 19,910.00 30 $ 1.65 4,500S 7425.00 30 $ 4.20 10,000 $ 42,000.00 $ 255 00 400 $ 103,530.00 30 $ 1.25 5,500 5 6,875.00 30 $ 3.75 4,200 15.750.00 30 $ 1.65 4,850 $ 8,002 50 30 $ 4.150 15,502.50 30 $ 4.25 15,500 85,875.00 30 $ 4.25 9.000 38,250.00 30 $ 3.65 1985 7,245.25 45 $ 3.50 3.900 13,650.00 45 $ 4.25 12.500 $ 53.125.00 30 $ 0.95 25,000 $ 23,750,00 30 $ 1.25 5.650S 7.00250 30 $ 3.55 4,800 17,040.00 25 $ 165 4,750 $ 7.637.50 30 $ 14705 5,165.50 45 $ 4.2 15,000 $ 63,750,00 30 $ 1.25 5,425 5.781.25 COUNTA 4 Order Date 07/25709 08/05/09 OR/O/09 08/10/09 08/15/09 08/15/09 08/2009 06/20/09 0825VOD 08/2509 08/25/09 08/25/09 08/25/09 08/2009 08/25709 08/28/09 08/29/09 09/01/09 09/01/09 09/01/09 09/02/09 090309 09/04/09 OSOVO 02/0509 OWOOD OWOWO OWOOD ORDUVOD 09/05/09 09/05/09 09/07/09 OWONDO 09/10/09 Arrival Date 08/28/09 08/13/09 08/14/09 08/15/09 09/09/09 08/22/09 08/26/09 08/31/09 09/30/09 09/04/09 09/02/09 08/29/09 08/31/09 09/01/09 09/05/09 09/05/09 10/04/09 08/10/09 09/06,00 09/10/09 09/11/09 09/11/09 09/12/09 09/12/09 10/11/09 10/10/09 09/11/09 09/12/09 09/10/09 09/20/09 09/13/09 10/12/09 0915/09 0815009 3.75 3.65 SUM MIN D MAX T 125% Zoom Coil Ad Category insan Tabla Shape Media + data Sheet1 D 3165 4111 6321 9399 5454 5068 4111 5319 9399 9784 9784 9752 30 25 30 45 45 30 25 30 45 15 15 25 25 45 30 50 15 4111 Hukey Fasteners 39 Spacetime Technologles 40 Fast The Aerospace 41 Durable Products 42 Durable Products 43 Hukey Fasteners 44 Spacetime Technologies 40 Stepin Inc 40 Durable Products 47 Pylon Accessodes 45 Pylon Accessories 49 Spacetime Technologies 30 Spacetime Technologies 51 Durable Products 62 Fast The Aerospace 53 Manley Valve 54 Pylon Aconssories 55 Spacetime Technologies 56 Spacetime Technologies 67 Durable Products 59 Huikey Fasteners 69 Pylon Accessories 60 Fast The Aerospace 01 Hukey Fasteners 02 Manley Valve 32 Pylon Accessories 04 Spacetime Technologies 06 Manley Valve 00 Spacetime Technologies 07 Spacetime Technologies Alum Sheeting 0 Manley Valve 70 Manley Valve 7 Spacetime Technologies 12 Stein Inc 23 Hukey Fasteners Fast. The Aerospace 1 2 4 3 3 1 2 6 3 8 8 2 2 3 4 7 B 2 2 3 1 B 4 1 7 2 7 2 2 5 7 7 2 C8854 A5589 B2345 A1234 A1456 D1212 A1222 AD204 A1235 B1111 D3333 A0533 A1444 A1344 B2356 A9821 C2211 A0622 A1445 B1468 C5656 01111 C0234 C3232 A2378 A9999 A0656 A2345 A0555 A1449 30567 C2222 C3333 A0111 33333 D3232 82367 Electrical Connector Bolt-nut package O-Ring Gasket Control Panel Shielded Cable/ Bolt-nut package Shielded Cabott Gasket Gasket Gasket Gasket Boll-nut package Control Panel D-Ring O-Ring Gasket Gasket Boll-nut package Airframe fasteners Airframe fasteners Gasket Electrical Connector Airframe fasteners O-Ring O-Ring Shielded Cable O-Ring O-Ring Bott-nut package Airframe fasteners Pressure Gauge Machined Valve O-Ring Machined Valve Airframe fasteners O Ring 5454 6321 8431 9764 9752 4111 1389 1122 9764 5166 1122 5431 5433 5125 5431 6489 4111 1243 7258 8148 6489 B008 1122 6321 F $ 125 $ 3:55 $ 2.45 $ 3.65 $ 220.00 $ 0.95 $ 3.55 $ 1.10 $ 3.65 $ 3.75 $ 3.75 $ 405 $ 3.55 $ 220.00 $ 245 $ 2.85 $ 3.75 $ 4.05 $3.55 $ 4.20 $ $ 3.75 $ 125 $ 425 $ 285 $ 2.95 $ 1.15 $ 285 $ 3.00 $ 3.55 $425 $ 100 50 $ 655 50 $ 3.00 $ 645.00 5 425 $ 245 G H 5,4255 5,781.25 4585 16,276.75 1.2005 2,040.00 1250 $ 4.562.50 500 $ 110,000.00 17,500 $ 16,625.00 4,200 $ 14,910 00 16 500 $ 18,150.00 1,450 $ 5,292.50 1980 7425.00 1,750 $ 6,562.50 1,500 $ 6,075,00 4,250 $ 15,087.50 550 $ 121,000.00 2,500 $ 6,125.00 1,300 $ 3,705 00 1,850 $ 6,837 50 1,550 $ 8,277.50 4,200 $ 14,910.00 14.000 $ 58,800.00 14,500 $ 61,625.00 1,800 $ 6,750 00 5650 $ 7,062 50 18,000 $ 78,500.00 1,350 $ 3,847 50 1.500 5 4,425.00 15,000 $ 17,250.00 1,250 $ 3,502 50 1,100 $ 3,300.00 4,600 S 16,330.00 10,500$ 44,625.00 90 $ 9,045.00 125 S 81,937 900$ 2,700.00 100$ 64,500.00 17.000 72.250.00 1,250 3.062.50 K 09/15.00 09/30/09 09/23/09 10/08/09 10/20/09 09/22/09 10/15/09 10/05/09 10/08/09 09/29/09 09/25/09 09/25/09 10/10/09 10/14/09 10/04/09 10/01/09 10/05/09 10/05/09 10/25/09 10/03/09 10/03/09 10/05/09 10/05/09 10/08/09 10/07/09 10/10/09 10/15/09 10/10/09 10/10/09 10/19/09 10/17/09 10/17/09 10/17/09 10/10/09 10/21/09 10/1900 10/21/09 09 TOV09 09/10/09 09/12/09 09/15709 09/15/09 09/15/09 09/15/09 09/15709 09/18/09 09/20/09 09/2010 09/20/09 09/20709 09/24/09 09/2509 09/2509 09/25/09 09/25709 09/25/09 09/27/09 09/28/09 09/28/09 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 425 25 45 30 15 30 30 50 15 25 50 25 25 30 50 50 25 30 30 30 1 4 SU AVERAGE MIN MAX D COUNTA 4 T Text GO Cellsborato Insert Ad Category Table Chat Shane Media Zoom data Table + Sheets MA IN LE C o O A 1122 30 30 30 1 4 5 7 6 5 7 5 3 4 4 1 7250 13 Hukey Fasteners 14 Fast The Aerospaco 75 Am Sheeting 20 Marley Valve 1 Stoplino TO Alum Sheeting 20 Mary Valve 10 Alim Sheeting 1 Durable Products 02 Fast The Aronce 83 Fast The Aerospace 04 Hukey Fasteners Steelpline Stein Inc 67 Alum Sheeting 6 Spacetime Technologies DD Fast The Aerospace 00 Fanie Aerospace 01 Manley Valve 02 Manley Valve 03 Stein in 04 FastTe Aerospace Font: The Aerospace 0 Marley Valve Marley Valve 100 Stone D www Altrama fasteners 8321 O-Ring 4224 Bolt-nut package 7258 Pressure Gauge B008 Machined Valve 5417 Control Panel Pressure Gauge 5634 Side Panel 5275 Shielded Cable/ 6321 O-Ring 5689 Side Panel 1122 Airtrarne fasteners 5677 Side Panel Boos Machined Valve 5534 Side Panel 5480 O-Ring 5689 Side Panel 7258 Pressure Gauge 907 Panel Decal 9955 Door Decal SAT! Side Panel 7266 Pressure 560 Side Panel 9067 Hatch Decal 1955 Door Decal 77 de Panel 03232 32364 A0223 A3842 B3222 A0433 A2356 B0447 81520 B2378 C0423 02121 00456 C0467 B0479 AD777 12400 B2499 A2357 ADN 70 A0205 82511 62528 ADOS 01111 33022 VO $ 4.25 $ 245 $395 $ 100.50 $ 545 DO 5 25500 $ 100 50 $185.00 $ 1.00 $ 245 $ 175.00 $4.25 $195.00 5.54500 $185.00 $300 $ 175.00 $95.00 S 100 $ 0.55 $19500 S9500 517600 $ 0.85 $055 $ 195.00 17 000 $ 1,250S 4,500 $ 100 $ 150$ 500 5 95$ 150 $ 25,000 5 1,500 155$ 17,500 $ 1305 120 S 140 $ 1,0505 150$ 110$ 525$ 150 $ 120S 105 1753 550S 125S 1105 MV H SMS 72,250.00 3.002.50 17 775.00 10,050.00 96.750.00 127,500.00 9,64750 27,750.00 25,000.00 3,675.00 27.125.00 74,375 00 25,350.00 77 400.00 25,000.00 3,150.00 26,250.00 10.450.00 52500 12.50 23,400.00 9,975.00 0.625.00 46750 6175 21.450.00 Table ET Car 10/11/09 10/12/09 10/10 10/1909 10/15709 10/20/09 10/20/09 10/2500 10/25/09 102509 10/200 10/2509 10/2009 10/2009 10/2009 10/2009 11/01/09 11/01/09 11/01/09 11/01/09 11/02/09 11/05/09 11/05 11/05,00 11/05 11/05 Tre 10/1909 10/21/09 10/20/09 10/24/09 10/26/09 10/27/09 10/2009 11/01/09 10/30000 11/02/09 11/03/09 11/09/09 11/07/09 11/04/09 11/04/08 11/10/09 11/09/09 11/12/09 11/07/09 11/08/09 11/1100 11/1009 11/1509 11/11/09 11/10/09 11/17/09 30 30 50 30 45 30 30 30 30 30 30 25 30 30 50 50 30 30 30 50 30 30 3 5 2 4 4 7 7 Header into Rows Column 4 4 7 7 6 Table Table Instructions This is a data analysis EXCEL assignment Improve Decision Making: Use A Spreadsheet to Select Suppliers) 1. Download the data file. (See the attachment in xlsx format) 2. Read and follow the instructions as listed below: My expectation on this Business Software Assignment#1 are listed below: 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 Days. (Hint: you must find out the "delivery days" from the data set 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 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 each item, identify the supplier who provides the lowest price for the item. The above Objects of your answers for Q1-Q3 should be included in your Business Software Assignment 1 EXCEL file. Your answer for Q4-a summary of Q1-3--can be placed in a seperate worksheet (named it as Q4) of the same EXCEL file above. 3. Turn in your completed assignment (ensue that it is in .xlsx format) to this drop box in a timely manner. data Sheet1 0 F H K D B 0 0 Orders and Suppliers Vendor Name Vendor No Durable Products 3 Hukey Fastonen 1 Alum Sheeting 5 Fastle Aerospace 4 Durable Products 3 10 Fast-Tin Aerospace 4 11 Fast-Tie Aerospace 4 12 Steelpin Inc 6 Durable Products 3 14 Fast-Tie Acrospace 4 15 Fast-Te Aoroso 4 10 Hukey Fasteners 1 17 Hukey Fasteners 1 10 Stepinine 6 19 Stepinine 5 20 Steelpin Inc 5 21 Durable Products 3 22 Alum Sheeting 5 23 Hukey Fasteners 1 24 Steelpin Inc 6 29 steelpin in 0 20 Stein Inc 6 27 Hulkey Fasteners 1 20 Alum Shooting 5 29 Durable Products 3 30 Durable Products 3 31 Hukey Fasteners 1 12 Hukey Fasteners 1 23 Hulkey Fasten 1 34 Spacetime Technologies 2 35 Sleepin Inc 5 30 Durable Products 3 27 Hukey Fasteners 1 Hukey Fasteners 1 0 AVERADE Order No. Item No. B1234 7258 C1212 1122 A0443 1243 B2568 5462 B1345 7258 B2537 5452 82519 5462 A0115 5319 A 1567 1369 B2333 8321 C0433 5452 C1313 3166 C8989 9966 A0123 4312 C0589 5319 33041 5234 B1666 1369 A0446 5417 C2929 3166 A0207 4312 B3111 5234 00445 4312 C2323 1122 B0247 1243 A1346 9399 A1457 4560 C3444 1122 C6765 5066 C7875 3166 A3467 4111 33042 5234 A1345 9399 C4545 1122 CASA 3166 Item Description Pressure Gauge Airframe fasteners Alframe fastoners Shielded Cable Pressure Gauge Shielded Cable Shielded Cable/ Shielded Cable Airframe fasteners O-Ring Shielded Cable Electrical Connector Hatch Decal Boll-nut package Shielded Cable Electrical Connector Airframe fosteners Control Panel Electrical Connector Boll-nut package Electrical Connector Bohnut package Airframe fasteners Airframe fasteners Gasket Bollut package Airframe fasteners Shielded Cable/ Electrical Connector Bollnut package Electrical Connector Gasket Airframe fasteners Electrical Connector Item Cost Quantity Cost per order A/P Terms $ 90.00 100 $ 9,000.00 45 5 4.25 19,500 $ 82,875.00 30 $ 4.25 10,000 $ 42,500.00 30 $1.05 23,000 24,150.00 30 $ 90,00 120$ 10,800.00 45 $ 1.05 21,500 22,575.00 30 1.05 22,500 23,625.00 30 $ 1.10 17,500 5 19,250.00 30 $ 4.20 15,000 $ 63,000.00 45 $ 2.45 1,300 $ 3.185.00 30 $ 1.05 22.500 5 23,625.00 30 $ 125 5,000$ 7,000.00 30 $ 0.75 500$ 375.00 30 $ 3.75 4,250 $ 15,907.50 30 $ 1.10 18.100 19,910.00 30 $ 1.65 4,500S 7425.00 30 $ 4.20 10,000 $ 42,000.00 $ 255 00 400 $ 103,530.00 30 $ 1.25 5,500 5 6,875.00 30 $ 3.75 4,200 15.750.00 30 $ 1.65 4,850 $ 8,002 50 30 $ 4.150 15,502.50 30 $ 4.25 15,500 85,875.00 30 $ 4.25 9.000 38,250.00 30 $ 3.65 1985 7,245.25 45 $ 3.50 3.900 13,650.00 45 $ 4.25 12.500 $ 53.125.00 30 $ 0.95 25,000 $ 23,750,00 30 $ 1.25 5.650S 7.00250 30 $ 3.55 4,800 17,040.00 25 $ 165 4,750 $ 7.637.50 30 $ 14705 5,165.50 45 $ 4.2 15,000 $ 63,750,00 30 $ 1.25 5,425 5.781.25 COUNTA 4 Order Date 07/25709 08/05/09 OR/O/09 08/10/09 08/15/09 08/15/09 08/2009 06/20/09 0825VOD 08/2509 08/25/09 08/25/09 08/25/09 08/2009 08/25709 08/28/09 08/29/09 09/01/09 09/01/09 09/01/09 09/02/09 090309 09/04/09 OSOVO 02/0509 OWOOD OWOWO OWOOD ORDUVOD 09/05/09 09/05/09 09/07/09 OWONDO 09/10/09 Arrival Date 08/28/09 08/13/09 08/14/09 08/15/09 09/09/09 08/22/09 08/26/09 08/31/09 09/30/09 09/04/09 09/02/09 08/29/09 08/31/09 09/01/09 09/05/09 09/05/09 10/04/09 08/10/09 09/06,00 09/10/09 09/11/09 09/11/09 09/12/09 09/12/09 10/11/09 10/10/09 09/11/09 09/12/09 09/10/09 09/20/09 09/13/09 10/12/09 0915/09 0815009 3.75 3.65 SUM MIN D MAX T 125% Zoom Coil Ad Category insan Tabla Shape Media + data Sheet1 D 3165 4111 6321 9399 5454 5068 4111 5319 9399 9784 9784 9752 30 25 30 45 45 30 25 30 45 15 15 25 25 45 30 50 15 4111 Hukey Fasteners 39 Spacetime Technologles 40 Fast The Aerospace 41 Durable Products 42 Durable Products 43 Hukey Fasteners 44 Spacetime Technologies 40 Stepin Inc 40 Durable Products 47 Pylon Accessodes 45 Pylon Accessories 49 Spacetime Technologies 30 Spacetime Technologies 51 Durable Products 62 Fast The Aerospace 53 Manley Valve 54 Pylon Aconssories 55 Spacetime Technologies 56 Spacetime Technologies 67 Durable Products 59 Huikey Fasteners 69 Pylon Accessories 60 Fast The Aerospace 01 Hukey Fasteners 02 Manley Valve 32 Pylon Accessories 04 Spacetime Technologies 06 Manley Valve 00 Spacetime Technologies 07 Spacetime Technologies Alum Sheeting 0 Manley Valve 70 Manley Valve 7 Spacetime Technologies 12 Stein Inc 23 Hukey Fasteners Fast. The Aerospace 1 2 4 3 3 1 2 6 3 8 8 2 2 3 4 7 B 2 2 3 1 B 4 1 7 2 7 2 2 5 7 7 2 C8854 A5589 B2345 A1234 A1456 D1212 A1222 AD204 A1235 B1111 D3333 A0533 A1444 A1344 B2356 A9821 C2211 A0622 A1445 B1468 C5656 01111 C0234 C3232 A2378 A9999 A0656 A2345 A0555 A1449 30567 C2222 C3333 A0111 33333 D3232 82367 Electrical Connector Bolt-nut package O-Ring Gasket Control Panel Shielded Cable/ Bolt-nut package Shielded Cabott Gasket Gasket Gasket Gasket Boll-nut package Control Panel D-Ring O-Ring Gasket Gasket Boll-nut package Airframe fasteners Airframe fasteners Gasket Electrical Connector Airframe fasteners O-Ring O-Ring Shielded Cable O-Ring O-Ring Bott-nut package Airframe fasteners Pressure Gauge Machined Valve O-Ring Machined Valve Airframe fasteners O Ring 5454 6321 8431 9764 9752 4111 1389 1122 9764 5166 1122 5431 5433 5125 5431 6489 4111 1243 7258 8148 6489 B008 1122 6321 F $ 125 $ 3:55 $ 2.45 $ 3.65 $ 220.00 $ 0.95 $ 3.55 $ 1.10 $ 3.65 $ 3.75 $ 3.75 $ 405 $ 3.55 $ 220.00 $ 245 $ 2.85 $ 3.75 $ 4.05 $3.55 $ 4.20 $ $ 3.75 $ 125 $ 425 $ 285 $ 2.95 $ 1.15 $ 285 $ 3.00 $ 3.55 $425 $ 100 50 $ 655 50 $ 3.00 $ 645.00 5 425 $ 245 G H 5,4255 5,781.25 4585 16,276.75 1.2005 2,040.00 1250 $ 4.562.50 500 $ 110,000.00 17,500 $ 16,625.00 4,200 $ 14,910 00 16 500 $ 18,150.00 1,450 $ 5,292.50 1980 7425.00 1,750 $ 6,562.50 1,500 $ 6,075,00 4,250 $ 15,087.50 550 $ 121,000.00 2,500 $ 6,125.00 1,300 $ 3,705 00 1,850 $ 6,837 50 1,550 $ 8,277.50 4,200 $ 14,910.00 14.000 $ 58,800.00 14,500 $ 61,625.00 1,800 $ 6,750 00 5650 $ 7,062 50 18,000 $ 78,500.00 1,350 $ 3,847 50 1.500 5 4,425.00 15,000 $ 17,250.00 1,250 $ 3,502 50 1,100 $ 3,300.00 4,600 S 16,330.00 10,500$ 44,625.00 90 $ 9,045.00 125 S 81,937 900$ 2,700.00 100$ 64,500.00 17.000 72.250.00 1,250 3.062.50 K 09/15.00 09/30/09 09/23/09 10/08/09 10/20/09 09/22/09 10/15/09 10/05/09 10/08/09 09/29/09 09/25/09 09/25/09 10/10/09 10/14/09 10/04/09 10/01/09 10/05/09 10/05/09 10/25/09 10/03/09 10/03/09 10/05/09 10/05/09 10/08/09 10/07/09 10/10/09 10/15/09 10/10/09 10/10/09 10/19/09 10/17/09 10/17/09 10/17/09 10/10/09 10/21/09 10/1900 10/21/09 09 TOV09 09/10/09 09/12/09 09/15709 09/15/09 09/15/09 09/15/09 09/15709 09/18/09 09/20/09 09/2010 09/20/09 09/20709 09/24/09 09/2509 09/2509 09/25/09 09/25709 09/25/09 09/27/09 09/28/09 09/28/09 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 425 25 45 30 15 30 30 50 15 25 50 25 25 30 50 50 25 30 30 30 1 4 SU AVERAGE MIN MAX D COUNTA 4 T Text GO Cellsborato Insert Ad Category Table Chat Shane Media Zoom data Table + Sheets MA IN LE C o O A 1122 30 30 30 1 4 5 7 6 5 7 5 3 4 4 1 7250 13 Hukey Fasteners 14 Fast The Aerospaco 75 Am Sheeting 20 Marley Valve 1 Stoplino TO Alum Sheeting 20 Mary Valve 10 Alim Sheeting 1 Durable Products 02 Fast The Aronce 83 Fast The Aerospace 04 Hukey Fasteners Steelpline Stein Inc 67 Alum Sheeting 6 Spacetime Technologies DD Fast The Aerospace 00 Fanie Aerospace 01 Manley Valve 02 Manley Valve 03 Stein in 04 FastTe Aerospace Font: The Aerospace 0 Marley Valve Marley Valve 100 Stone D www Altrama fasteners 8321 O-Ring 4224 Bolt-nut package 7258 Pressure Gauge B008 Machined Valve 5417 Control Panel Pressure Gauge 5634 Side Panel 5275 Shielded Cable/ 6321 O-Ring 5689 Side Panel 1122 Airtrarne fasteners 5677 Side Panel Boos Machined Valve 5534 Side Panel 5480 O-Ring 5689 Side Panel 7258 Pressure Gauge 907 Panel Decal 9955 Door Decal SAT! Side Panel 7266 Pressure 560 Side Panel 9067 Hatch Decal 1955 Door Decal 77 de Panel 03232 32364 A0223 A3842 B3222 A0433 A2356 B0447 81520 B2378 C0423 02121 00456 C0467 B0479 AD777 12400 B2499 A2357 ADN 70 A0205 82511 62528 ADOS 01111 33022 VO $ 4.25 $ 245 $395 $ 100.50 $ 545 DO 5 25500 $ 100 50 $185.00 $ 1.00 $ 245 $ 175.00 $4.25 $195.00 5.54500 $185.00 $300 $ 175.00 $95.00 S 100 $ 0.55 $19500 S9500 517600 $ 0.85 $055 $ 195.00 17 000 $ 1,250S 4,500 $ 100 $ 150$ 500 5 95$ 150 $ 25,000 5 1,500 155$ 17,500 $ 1305 120 S 140 $ 1,0505 150$ 110$ 525$ 150 $ 120S 105 1753 550S 125S 1105 MV H SMS 72,250.00 3.002.50 17 775.00 10,050.00 96.750.00 127,500.00 9,64750 27,750.00 25,000.00 3,675.00 27.125.00 74,375 00 25,350.00 77 400.00 25,000.00 3,150.00 26,250.00 10.450.00 52500 12.50 23,400.00 9,975.00 0.625.00 46750 6175 21.450.00 Table ET Car 10/11/09 10/12/09 10/10 10/1909 10/15709 10/20/09 10/20/09 10/2500 10/25/09 102509 10/200 10/2509 10/2009 10/2009 10/2009 10/2009 11/01/09 11/01/09 11/01/09 11/01/09 11/02/09 11/05/09 11/05 11/05,00 11/05 11/05 Tre 10/1909 10/21/09 10/20/09 10/24/09 10/26/09 10/27/09 10/2009 11/01/09 10/30000 11/02/09 11/03/09 11/09/09 11/07/09 11/04/09 11/04/08 11/10/09 11/09/09 11/12/09 11/07/09 11/08/09 11/1100 11/1009 11/1509 11/11/09 11/10/09 11/17/09 30 30 50 30 45 30 30 30 30 30 30 25 30 30 50 50 30 30 30 50 30 30 3 5 2 4 4 7 7 Header into Rows Column 4 4 7 7 6 Table Table