Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please How to do it. for example which Functions used. Thank you Use Excels filtering capability in the Purchase Orders database to extract: b. all

please How to do it. for example which Functions used. Thank you

Use Excels filtering capability in the Purchase Orders database to extract:
b. all orders for quantities of less than 500 units.
Supplier Order No. Item No. Item Description Item Cost Quantity Cost per order A/P Terms (Months) Order Date Arrival Date
Hulkey Fasteners Aug11001 1122 Airframe fasteners $ 4.25 19,500 $ 82,875.00 30 08/05/11 08/13/11
Alum Sheeting Aug11002 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 30 08/08/11 08/14/11
Fast-Tie Aerospace Aug11003 5462 Shielded Cable/ft. $ 1.05 23,000 $ 24,150.00 30 08/10/11 08/15/11
Fast-Tie Aerospace Aug11004 5462 Shielded Cable/ft. $ 1.05 21,500 $ 22,575.00 30 08/15/11 08/22/11
Steelpin Inc. Aug11005 5319 Shielded Cable/ft. $ 1.10 17,500 $ 19,250.00 30 08/20/11 08/31/11
Fast-Tie Aerospace Aug11006 5462 Shielded Cable/ft. $ 1.05 22,500 $ 23,625.00 30 08/20/11 08/26/11
Steelpin Inc. Aug11007 4312 Bolt-nut package $ 3.75 4,250 $ 15,937.50 30 08/25/11 09/01/11
Durrable Products Aug11008 7258 Pressure Gauge $ 90.00 100 $ 9,000.00 45 08/25/11 08/28/11
Fast-Tie Aerospace Aug11009 6321 O-Ring $ 2.45 1,300 $ 3,185.00 30 08/25/11 09/04/11
Fast-Tie Aerospace Aug11010 5462 Shielded Cable/ft. $ 1.05 22,500 $ 23,625.00 30 08/25/11 09/02/11
Steelpin Inc. Aug11011 5319 Shielded Cable/ft. $ 1.10 18,100 $ 19,910.00 30 08/25/11 09/05/11
Hulkey Fasteners Aug11012 3166 Electrical Connector $ 1.25 5,600 $ 7,000.00 30 08/25/11 08/29/11
Hulkey Fasteners Aug11013 9966 Hatch Decal $ 0.75 500 $ 375.00 30 08/25/11 08/31/11
Steelpin Inc. Aug11014 5234 Electrical Connector $ 1.65 4,500 $ 7,425.00 30 08/28/11 09/05/11
Steelpin Inc. Sep11001 4312 Bolt-nut package $ 3.75 4,200 $ 15,750.00 30 09/01/11 09/10/11
Alum Sheeting Sep11002 5417 Control Panel $ 255.00 406 $ 103,530.00 30 09/01/11 09/10/11
Hulkey Fasteners Sep11003 3166 Electrical Connector $ 1.25 5,500 $ 6,875.00 30 09/01/11 09/06/11
Steelpin Inc. Sep11004 5234 Electrical Connector $ 1.65 4,850 $ 8,002.50 30 09/02/11 09/11/11
Steelpin Inc. Sep11005 4312 Bolt-nut package $ 3.75 4,150 $ 15,562.50 30 09/03/11 09/11/11
Hulkey Fasteners Sep11006 1122 Airframe fasteners $ 4.25 15,500 $ 65,875.00 30 09/04/11 09/12/11
Spacetime Technologies Sep11007 4111 Bolt-nut package $ 3.55 4,800 $ 17,040.00 25 09/05/11 09/20/11
Alum Sheeting Sep11008 1243 Airframe fasteners $ 4.25 9,000 $ 38,250.00 30 09/05/11 09/12/11
Durrable Products Sep11009 7258 Pressure Gauge $ 90.00 120 $ 10,800.00 45 09/05/11 09/09/11
Steelpin Inc. Sep11010 5234 Electrical Connector $ 1.65 4,750 $ 7,837.50 30 09/05/11 09/13/11
Hulkey Fasteners Sep11011 1122 Airframe fasteners $ 4.25 12,500 $ 53,125.00 30 09/05/11 09/11/11
Hulkey Fasteners Sep11012 5066 Shielded Cable/ft. $ 0.95 25,000 $ 23,750.00 30 09/05/11 09/12/11
Hulkey Fasteners Sep11013 3166 Electrical Connector $ 1.25 5,650 $ 7,062.50 30 09/05/11 09/10/11
Hulkey Fasteners Sep11014 1122 Airframe fasteners $ 4.25 15,000 $ 63,750.00 30 09/08/11 09/15/11
Spacetime Technologies Sep11015 4111 Bolt-nut package $ 3.55 4,585 $ 16,276.75 25 09/10/11 09/30/11
Hulkey Fasteners Sep11016 3166 Electrical Connector $ 1.25 5,425 $ 6,781.25 30 09/10/11 09/15/11
Fast-Tie Aerospace Sep11017 6321 O-Ring $ 2.45 1,200 $ 2,940.00 30 09/12/11 09/23/11
Steelpin Inc. Sep11018 5319 Shielded Cable/ft. $ 1.10 16,500 $ 18,150.00 30 09/15/11 10/05/11
Spacetime Technologies Sep11019 4111 Bolt-nut package $ 3.55 4,200 $ 14,910.00 25 09/15/11 10/15/11
Hulkey Fasteners Sep11020 5066 Shielded Cable/ft. $ 0.95 17,500 $ 16,625.00 30 09/15/11 09/22/11
Spacetime Technologies Sep11021 9752 Gasket $ 4.05 1,500 $ 6,075.00 25 09/20/11 09/25/11
Spacetime Technologies Sep11022 4111 Bolt-nut package $ 3.55 4,250 $ 15,087.50 25 09/20/11 10/10/11
Pylon Accessories Sep11023 9764 Gasket $ 3.75 1,980 $ 7,425.00 15 09/20/11 09/29/11
Pylon Accessories Sep11024 9764 Gasket $ 3.75 1,750 $ 6,562.50 15 09/20/11 09/25/11

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

15th edition

1337671002, 978-1337395250

More Books

Students also viewed these Finance questions