Question

1 Approved Answer

Posted on Sep 09, 2024

1 2 Orders and Suppliers 5 4 Vendor Name Vendor No. Order No. Item No. Item Description 5 Spacetime Technologies 2 A0111 6489 O-Ring 6

1 2 Orders and Suppliers 5 4 Vendor Name Vendor No. Order No. Item No. Item Description 5 Spacetime Technologies 2 A0111 6489 O-Ring 6 Steelpin Inc. 6 A0115 5319 Shielded Cable/tt 7 Steelpin Inc 6 A0123 4312 Bolt-nut package 8 Steelpin Inc 6 A0204 5319 Shielded Cable/ 9 Steelpin Inc 6 A0205 5677 Side Panel 10 Sleelpin Inc 6 A0207 4312 Bolt-nut package 11 Alum Sheeting 5 A0223 4224 Bolt-nut package 12 Alum Sheeting 5 A0433 5417 Control Panel 13 Alum Sheeting A0443 1243 Airframe fasteners 14 Alum Sheeting 5 A0446 5417 Control Panel 15 Spacetime Technologies 2 A0533 9752 Gasket 16 Spacetime Technologies 2 A0555 O-Ring 17 Spacetime Technologies 2 A0622 9752 Gasket 18 Spacetime Technologies 2 A0666 5125 Shielded Cable/ 19 Spacetime Technologies 2 A0777 6489 O-Ring 20 Spacetime Technologies 2 A1222 Bolt nut package 21 Durable Products 3 A1234 Gasket 22 Durable Products 3 A1235 9399 Gasket 23 Durable Products A1344 5454 Control Panel 24 Durable Products 3 A1345 9399 Gasket 25 Durable Products 3 A1346 9399 Gasket 26 Spacetime Technologies 2 A1444 4111 Bolt nut package 27 Spacetime Technologies 2 A1465 4111 Bolt nut package 28 Spacetime Technologies 2 A1449 4111 Bolt-nut package 29 Durable Products A1456 5454 Control Panel 2 D Sheet1 Item Cost Quantity Cost per order A/P Terms Order Date Arrival Date $ 3.00 9005 2,700.00 25 10/10/15 10/18/15 $ 1.10 17,500 5 19,250.00 30 08/20/15 08/31/15 $ 3.75 4,250 $ 15,937 50 30 08/25/15 09/01/15 $ 1.10 16.500 5 18.150.00 30 09/15/15 10/05/15 $ 195,00 120$ 23,400.00 30 11/02/15 11/13/15 $ 3.75 4,200 $ 15,750.00 30 09/01/15 09/10/15 $ 3.95 4,500 $ 17.775.00 30 10/15/15 10/20/15 5 255 00 500 $ 127,500.00 30 10/20/15 10/27/15 $ 425 10,000 $ 42,500.00 30 08/08/15 0B/14/15 $255.00 406 S 103,630.00 30 09/01/15 09/10/15 $ 405 1.500 5 6,075.00 25 09/20/15 09/25/15 $ 3.00 1.100 5 3.300.00 25 10/05/15 10/10/15 $ 405 1.5505 6.277.50 25 09/25/15 10/05/15 $ 115 15.000 17 250.00 25 10/01/15 10/15/15 $ 3.00 1.050 $ 3.150.00 25 10/29/15 11/10/15 $ 3.55 4.2005 14.910.00 25 09/15/15 10/15/15 $365 1.2505 4,562.50 45 10/01/15 10/06/15 $ 3.65 1.450 $ 5,292.50 45 10/03/15 10/08/15 $ 220.00 550 121,000.00 45 10/09/15 10/14/15 $ 3.65 1.470 $ 5.365.50 45 10/07/15 10/13/15 $365 1985 7.245.25 45 10/05/15 10/11/15 $ 355 4250 S 15.087 50 25 09/20/15 10/10/15 $ 3.55 4,200 $ 14.910.00 25 09/25/15 10/25/15 $ 355 4.600 5 16.330.00 25 10/05/15 10/19/15 $ 220.00 500 $ 110,000.00 45 10/15/15 10/20/15 2 C 3 Average 15302 30219 Count: 1046 SU B 3 7 7 7 2 2 7 Durable Products 1 Durable Products 2 Manley Valve 3 Manley Valve 14 Manley Valve 85 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 Sheating 46 Alum Sheeting 47 Alum Sheeting 48 Pylon Accessories 49 Durable Products 50 Durable Products 51 Durrable Products 52 Durable Products 53 Durable Products 54 Fast The Aerospace 55 Fast-Tie Aerospace 56 Fast Tie Aerospace 57 Fast Tie Aerospace 58 Fast-Tie Aerospace 59 Fast-Tin Armare Sheet1 8 5 6 5 5 5 A1457 A 1567 A2345 A2356 A2367 A2378 A3467 A5689 A9821 A9842 A9865 A9876 A9999 B0241 30445 B0447 30479 30567 B1111 B1234 B1345 31466 B1509 B1666 B2333 B2345 B2356 B2357 B2378 2498 4569 1369 6431 7258 9977 6431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5644 1243 9764 7250 7258 1369 5275 1359 6321 6321 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 Shielded Cable/tt Airframe fasteners O-Ring O Ring O-Ring O-Ring O Ring Sir Pan $ 3.50 $ 4.20 $ 2.85 $ 100 50 $ 1.00 $ 295 $ 355 $ 3.55 5 285 $ 100.50 $ 0.85 5055 $ 2.95 $ 425 $ 3.75 $185.00 $ 185 00 $ 425 $ 3.75 $90.00 590.00 S 420 $ 100 $ 4.20 $ 2.45 $ 245 $ 245 $ 245 $ 245 $175.00 3,900 5 15,000 5 1.250 $ 95 S 525 S 1.350 S 4.800 S 4,585 S 13005 100 $ 550 $ 150 S 1.500 5 9,000 $ 4.150 5 1505 140 5 10.500 5 1.900 100 5 1205 14 000 $ 25 000 $ 10.000 1,300 5 1 2005 2.500 5 1.250 $ 1.500S 150 3 13.650.00 63,000.00 3.562.50 9,547.50 525.00 3.847.50 17.040.00 16.276.75 3.705.00 10.050.00 46750 82 50 4,425 00 33.250.00 15,562 50 27.750.00 25,900.00 44 625 00 1.425.00 9.000.00 10,800.00 58,800.00 25,000.00 42,000.00 3.165.00 2.940.00 6.125.00 3,062.50 3,675.00 45 45 30 30 30 30 25 25 30 30 30 30 15 30 30 30 30 30 15 45 45 45 45 45 30 30 30 30 30 30 10/05/15 09/25/15 10/05/15 10/20/15 11/01/15 10/01/15 09/05/15 09/10/15 09/25/15 10/15/15 11/05/15 11/01/15 10/01/15 09/05/15 09/03/15 10/26/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 10/10/15 09/30/15 10/10/15 10/29/15 11/07/15 10/07/15 09/20/15 09/30/15 10/01/15 10/24/15 11/11/15 11/06/15 10/10/15 09/13/15 09/11/15 110115 11/04/15 10/17/15 09/29/15 OB/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 11/02/15 1109 3 3 3 3 4 4 4 4 4 4 6321 6321 6321 PS M 59 Fast-Tie Aerospace 60 Fast Tie Aerospace 61 Fast Tie Aerospace 62 Fast-Tie Aerospace 63 Fast-Te Aerospace 64 Fast-Tie Aerospace 65 Fast-Tie Aerospace 66 Steelpin Inc 67 Stelpin Inc 68 Steelpin Inc 69 Steelpin Inc 70 Steelpin Inc 71 Steelpin Inc 72 Fast Tie Aerospace 73 Fast Tie Aerospace 74 Fast-Tie Aerospace 75 Steelpin Inc 75 Steelpin in 77 Stelpin In 78 Manley Valve 79 Hulkey Fasteners 80 Hulkey Fasteners 81 Pylon Accessories 82 Manley Valve 33 Hulkey Fasteners 84 Hulkey Fasteners 85 Hulkey Fasteners 86 Manley Valve B7 Hulkey Fasteners RR Hulk Fasteners Sheet1 B 4 4 4 4 4 4 4 6 6 6 6 6 6 4 4 4 B2498 B2499 B2511 B2519 B2528 B2537 32566 33022 B3041 83042 B3111 33222 33333 C0234 C0423 C0433 C0456 C0462 C0589 C1111 C1212 C1313 C2211 C2222 C2323 C2929 C3232 C333 C3434 C4545 D 5689 7268 7268 5462 5689 5462 5462 5677 5234 5234 5234 8000 8008 5166 5689 5462 5677 8008 5319 9955 1122 3166 9754 7258 1122 3106 E F Side Panel $ 175.00 Pressure Gauge $95 00 Pressure Gauge $95.00 Shielded Cable $ 1.05 Side Panel $ 175.00 Shielded Cable/ $ 109 Shielded Cable/ $ 105 Side Panel $ 195.00 Electrical Connector 5 1 65 Electrical Connector 5 165 Electrical Connector $1.65 Machined Valve 5645.00 Machined Valve $ 54500 Electrical Connector $ 125 Side Panel $ 175.00 Shielded Cable/ S 10 Side Panel $ 195 00 Machined Valve 5 645 00 Shielded Cabiat 5 1.10 Door Decal 05 Airframe fasteners Electrical Connector 5125 Gasket $ 3.75 Pressure Gauge $ 100.50 Aiframe fasteners $425 Electrical Connectors 12 Airframe steners S25 Machined Valve 5 655 50 Aframe fasteners 54.25 A fasten G H 150 $ 26.250 00 110 $ 10.450.00 1055 9,975.00 22.500 5 23 625.00 175 $ 30.625 00 21.500 5 22 575.00 23,000 $ 24 150 00 110 5 21.450.00 4,500 S 7.425.00 4,7505 7.837.50 4.8505 8.002.50 150 5 96.750.00 100 5 64,500 00 5,650 $ 7,062 50 1555 27.125 00 22.500 5 23.625.00 1305 25,350.00 1205 77.400.00 18.100 19.910.00 125 68.75 19.500 5 12.875.00 56005 7,000.00 1850 S 6.93750 905 9.04500 15.500 5 65.875 00 5.500 6.875 00 18.000 76 500.00 1255 81.937.50 12 500 5 53.125.00 RE 1 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 30 30 11/01/15 11/01/15 11/05/15 08/20/15 11/05/15 OB/15/15 03/10/15 11/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/20/15 0125/15 11/05/15 03/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 11/09/15 11/13/15 11/16/15 08/26/15 11/15/15 08/22/15 08/15/15 11/17/15 09/05/15 09/13/15 09/11/15 10/26/15 10/21/15 10/06/15 11/03/15 09/02/15 11/07/15 11/04/15 09/05/15 11/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/11/15 1915 6 6 7 1 8 1 7 1 1 1122 1 7 1 8143 1122 1122 30 5 1 1 1 1 86 Manley Valve 87 Hulkey Fasteners 88 Hulkey Fasteners 89 Hulkey 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 Accessones 99 C3434 C4545 C5656 C6765 C7875 C8854 C8989 01111 D1212 D2121 D3232 D3333 1122 1122 1122 5066 3166 3166 9966 9764 5066 1122 1122 9764 12.500 5 15 000 $ 14,500 $ 25,000 $ 5.650 $ 5,4255 500 $ 1,800 $ 17.500 5 17.500 5 17,000 $ 1,750 S Airframe fasteners S425 Airframe fasteners $ 425 Airframe fasteners 4.25 Shielded Cable/ $0.95 Electrical Connectors 1.25 Electrical Connectors 1.25 Hatch Decal $ 0.75 Gasket $ 3.75 Shielded Cable/ $0.95 Airframe fasteners $ 425 Airframe fasteners $ 4.25 Gasket $ 3.75 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 15 30 30 30 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/11/15 09/20/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 11/03/15 10/19/15 09/25/15 1 8 1 1 1 Based off of this excel sheet I made up how could I meet these requirements and answer them 1. Data (original plus added column: Delivery days) 2. Delivery Time Table: Vendor No., Name, Average delivery time) 3. AP Terms (Table: Vendor No., Name, Accounts payable terms) 4. Supplier unit cost (Table: Item Description, Cost, Supplier, filter by item description) Please help and as always thank you chegg| IF I I'm sorry I forgot to add this detail it has to be An Excel spreadsheet that includes 4 worksheets: I hope this can help you solve it and thank you very much 1 2 Orders and Suppliers 5 4 Vendor Name Vendor No. Order No. Item No. Item Description 5 Spacetime Technologies 2 A0111 6489 O-Ring 6 Steelpin Inc. 6 A0115 5319 Shielded Cable/tt 7 Steelpin Inc 6 A0123 4312 Bolt-nut package 8 Steelpin Inc 6 A0204 5319 Shielded Cable/ 9 Steelpin Inc 6 A0205 5677 Side Panel 10 Sleelpin Inc 6 A0207 4312 Bolt-nut package 11 Alum Sheeting 5 A0223 4224 Bolt-nut package 12 Alum Sheeting 5 A0433 5417 Control Panel 13 Alum Sheeting A0443 1243 Airframe fasteners 14 Alum Sheeting 5 A0446 5417 Control Panel 15 Spacetime Technologies 2 A0533 9752 Gasket 16 Spacetime Technologies 2 A0555 O-Ring 17 Spacetime Technologies 2 A0622 9752 Gasket 18 Spacetime Technologies 2 A0666 5125 Shielded Cable/ 19 Spacetime Technologies 2 A0777 6489 O-Ring 20 Spacetime Technologies 2 A1222 Bolt nut package 21 Durable Products 3 A1234 Gasket 22 Durable Products 3 A1235 9399 Gasket 23 Durable Products A1344 5454 Control Panel 24 Durable Products 3 A1345 9399 Gasket 25 Durable Products 3 A1346 9399 Gasket 26 Spacetime Technologies 2 A1444 4111 Bolt nut package 27 Spacetime Technologies 2 A1465 4111 Bolt nut package 28 Spacetime Technologies 2 A1449 4111 Bolt-nut package 29 Durable Products A1456 5454 Control Panel 2 D Sheet1 Item Cost Quantity Cost per order A/P Terms Order Date Arrival Date $ 3.00 9005 2,700.00 25 10/10/15 10/18/15 $ 1.10 17,500 5 19,250.00 30 08/20/15 08/31/15 $ 3.75 4,250 $ 15,937 50 30 08/25/15 09/01/15 $ 1.10 16.500 5 18.150.00 30 09/15/15 10/05/15 $ 195,00 120$ 23,400.00 30 11/02/15 11/13/15 $ 3.75 4,200 $ 15,750.00 30 09/01/15 09/10/15 $ 3.95 4,500 $ 17.775.00 30 10/15/15 10/20/15 5 255 00 500 $ 127,500.00 30 10/20/15 10/27/15 $ 425 10,000 $ 42,500.00 30 08/08/15 0B/14/15 $255.00 406 S 103,630.00 30 09/01/15 09/10/15 $ 405 1.500 5 6,075.00 25 09/20/15 09/25/15 $ 3.00 1.100 5 3.300.00 25 10/05/15 10/10/15 $ 405 1.5505 6.277.50 25 09/25/15 10/05/15 $ 115 15.000 17 250.00 25 10/01/15 10/15/15 $ 3.00 1.050 $ 3.150.00 25 10/29/15 11/10/15 $ 3.55 4.2005 14.910.00 25 09/15/15 10/15/15 $365 1.2505 4,562.50 45 10/01/15 10/06/15 $ 3.65 1.450 $ 5,292.50 45 10/03/15 10/08/15 $ 220.00 550 121,000.00 45 10/09/15 10/14/15 $ 3.65 1.470 $ 5.365.50 45 10/07/15 10/13/15 $365 1985 7.245.25 45 10/05/15 10/11/15 $ 355 4250 S 15.087 50 25 09/20/15 10/10/15 $ 3.55 4,200 $ 14.910.00 25 09/25/15 10/25/15 $ 355 4.600 5 16.330.00 25 10/05/15 10/19/15 $ 220.00 500 $ 110,000.00 45 10/15/15 10/20/15 2 C 3 Average 15302 30219 Count: 1046 SU B 3 7 7 7 2 2 7 Durable Products 1 Durable Products 2 Manley Valve 3 Manley Valve 14 Manley Valve 85 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 Sheating 46 Alum Sheeting 47 Alum Sheeting 48 Pylon Accessories 49 Durable Products 50 Durable Products 51 Durrable Products 52 Durable Products 53 Durable Products 54 Fast The Aerospace 55 Fast-Tie Aerospace 56 Fast Tie Aerospace 57 Fast Tie Aerospace 58 Fast-Tie Aerospace 59 Fast-Tin Armare Sheet1 8 5 6 5 5 5 A1457 A 1567 A2345 A2356 A2367 A2378 A3467 A5689 A9821 A9842 A9865 A9876 A9999 B0241 30445 B0447 30479 30567 B1111 B1234 B1345 31466 B1509 B1666 B2333 B2345 B2356 B2357 B2378 2498 4569 1369 6431 7258 9977 6431 4111 4111 6431 7258 9967 9955 6433 1243 4312 5634 5644 1243 9764 7250 7258 1369 5275 1359 6321 6321 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 Shielded Cable/tt Airframe fasteners O-Ring O Ring O-Ring O-Ring O Ring Sir Pan $ 3.50 $ 4.20 $ 2.85 $ 100 50 $ 1.00 $ 295 $ 355 $ 3.55 5 285 $ 100.50 $ 0.85 5055 $ 2.95 $ 425 $ 3.75 $185.00 $ 185 00 $ 425 $ 3.75 $90.00 590.00 S 420 $ 100 $ 4.20 $ 2.45 $ 245 $ 245 $ 245 $ 245 $175.00 3,900 5 15,000 5 1.250 $ 95 S 525 S 1.350 S 4.800 S 4,585 S 13005 100 $ 550 $ 150 S 1.500 5 9,000 $ 4.150 5 1505 140 5 10.500 5 1.900 100 5 1205 14 000 $ 25 000 $ 10.000 1,300 5 1 2005 2.500 5 1.250 $ 1.500S 150 3 13.650.00 63,000.00 3.562.50 9,547.50 525.00 3.847.50 17.040.00 16.276.75 3.705.00 10.050.00 46750 82 50 4,425 00 33.250.00 15,562 50 27.750.00 25,900.00 44 625 00 1.425.00 9.000.00 10,800.00 58,800.00 25,000.00 42,000.00 3.165.00 2.940.00 6.125.00 3,062.50 3,675.00 45 45 30 30 30 30 25 25 30 30 30 30 15 30 30 30 30 30 15 45 45 45 45 45 30 30 30 30 30 30 10/05/15 09/25/15 10/05/15 10/20/15 11/01/15 10/01/15 09/05/15 09/10/15 09/25/15 10/15/15 11/05/15 11/01/15 10/01/15 09/05/15 09/03/15 10/26/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 10/10/15 09/30/15 10/10/15 10/29/15 11/07/15 10/07/15 09/20/15 09/30/15 10/01/15 10/24/15 11/11/15 11/06/15 10/10/15 09/13/15 09/11/15 110115 11/04/15 10/17/15 09/29/15 OB/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 11/02/15 1109 3 3 3 3 4 4 4 4 4 4 6321 6321 6321 PS M 59 Fast-Tie Aerospace 60 Fast Tie Aerospace 61 Fast Tie Aerospace 62 Fast-Tie Aerospace 63 Fast-Te Aerospace 64 Fast-Tie Aerospace 65 Fast-Tie Aerospace 66 Steelpin Inc 67 Stelpin Inc 68 Steelpin Inc 69 Steelpin Inc 70 Steelpin Inc 71 Steelpin Inc 72 Fast Tie Aerospace 73 Fast Tie Aerospace 74 Fast-Tie Aerospace 75 Steelpin Inc 75 Steelpin in 77 Stelpin In 78 Manley Valve 79 Hulkey Fasteners 80 Hulkey Fasteners 81 Pylon Accessories 82 Manley Valve 33 Hulkey Fasteners 84 Hulkey Fasteners 85 Hulkey Fasteners 86 Manley Valve B7 Hulkey Fasteners RR Hulk Fasteners Sheet1 B 4 4 4 4 4 4 4 6 6 6 6 6 6 4 4 4 B2498 B2499 B2511 B2519 B2528 B2537 32566 33022 B3041 83042 B3111 33222 33333 C0234 C0423 C0433 C0456 C0462 C0589 C1111 C1212 C1313 C2211 C2222 C2323 C2929 C3232 C333 C3434 C4545 D 5689 7268 7268 5462 5689 5462 5462 5677 5234 5234 5234 8000 8008 5166 5689 5462 5677 8008 5319 9955 1122 3166 9754 7258 1122 3106 E F Side Panel $ 175.00 Pressure Gauge $95 00 Pressure Gauge $95.00 Shielded Cable $ 1.05 Side Panel $ 175.00 Shielded Cable/ $ 109 Shielded Cable/ $ 105 Side Panel $ 195.00 Electrical Connector 5 1 65 Electrical Connector 5 165 Electrical Connector $1.65 Machined Valve 5645.00 Machined Valve $ 54500 Electrical Connector $ 125 Side Panel $ 175.00 Shielded Cable/ S 10 Side Panel $ 195 00 Machined Valve 5 645 00 Shielded Cabiat 5 1.10 Door Decal 05 Airframe fasteners Electrical Connector 5125 Gasket $ 3.75 Pressure Gauge $ 100.50 Aiframe fasteners $425 Electrical Connectors 12 Airframe steners S25 Machined Valve 5 655 50 Aframe fasteners 54.25 A fasten G H 150 $ 26.250 00 110 $ 10.450.00 1055 9,975.00 22.500 5 23 625.00 175 $ 30.625 00 21.500 5 22 575.00 23,000 $ 24 150 00 110 5 21.450.00 4,500 S 7.425.00 4,7505 7.837.50 4.8505 8.002.50 150 5 96.750.00 100 5 64,500 00 5,650 $ 7,062 50 1555 27.125 00 22.500 5 23.625.00 1305 25,350.00 1205 77.400.00 18.100 19.910.00 125 68.75 19.500 5 12.875.00 56005 7,000.00 1850 S 6.93750 905 9.04500 15.500 5 65.875 00 5.500 6.875 00 18.000 76 500.00 1255 81.937.50 12 500 5 53.125.00 RE 1 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 15 30 30 30 30 30 11/01/15 11/01/15 11/05/15 08/20/15 11/05/15 OB/15/15 03/10/15 11/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/20/15 0125/15 11/05/15 03/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 11/09/15 11/13/15 11/16/15 08/26/15 11/15/15 08/22/15 08/15/15 11/17/15 09/05/15 09/13/15 09/11/15 10/26/15 10/21/15 10/06/15 11/03/15 09/02/15 11/07/15 11/04/15 09/05/15 11/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/11/15 1915 6 6 7 1 8 1 7 1 1 1122 1 7 1 8143 1122 1122 30 5 1 1 1 1 86 Manley Valve 87 Hulkey Fasteners 88 Hulkey Fasteners 89 Hulkey 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 Accessones 99 C3434 C4545 C5656 C6765 C7875 C8854 C8989 01111 D1212 D2121 D3232 D3333 1122 1122 1122 5066 3166 3166 9966 9764 5066 1122 1122 9764 12.500 5 15 000 $ 14,500 $ 25,000 $ 5.650 $ 5,4255 500 $ 1,800 $ 17.500 5 17.500 5 17,000 $ 1,750 S Airframe fasteners S425 Airframe fasteners $ 425 Airframe fasteners 4.25 Shielded Cable/ $0.95 Electrical Connectors 1.25 Electrical Connectors 1.25 Hatch Decal $ 0.75 Gasket $ 3.75 Shielded Cable/ $0.95 Airframe fasteners $ 425 Airframe fasteners $ 4.25 Gasket $ 3.75 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 15 30 30 30 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/11/15 09/20/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 11/03/15 10/19/15 09/25/15 1 8 1 1 1 Based off of this excel sheet I made up how could I meet these requirements and answer them 1. Data (original plus added column: Delivery days) 2. Delivery Time Table: Vendor No., Name, Average delivery time) 3. AP Terms (Table: Vendor No., Name, Accounts payable terms) 4. Supplier unit cost (Table: Item Description, Cost, Supplier, filter by item description) Please help and as always thank you chegg| IF I I'm sorry I forgot to add this detail it has to be An Excel spreadsheet that includes 4 worksheets: I hope this can help you solve it and thank you very much