Question
Convert the accompanying database to an Excel table to find a The total cost of all orders b The total quantity of airframe fasteners purchased
Convert the accompanying database to an Excel table to find a The total cost of all orders b The total quantity of airframe fasteners purchased c The total cost of all orders placed with Manley Valve Click the icon to view the database a The total cost of all orders is 652 440 5 b The total quantity of airframe fasteners purchased is airframe fasteners 1 2 Hulkey Fasteners 3 Alum Sheeting 4 Manley Valve 5 Fast hyphen Tie Aerospace 6 Fast hyphen Tie Aerospace 7 Steelpin Inc 8 Fast hyphen Tie Aerospace 9 Manley Valve 10 Steelpin Inc 11 Durrable Products 12 Fast hyphen Tie Aerospace 13 Fast hyphen Tie Aerospace 14 Steelpin Inc Supplier 15 Hulkey Fasteners 16 Manley Valve 17 Hulkey Fasteners 18 Steelpin Inc 19 Steelpin Inc 20 Alum Sheeting 21 Hulkey Fasteners B Item Description Airframe fasteners Airframe fasteners Hatch Decal Shielded Cable ft Shielded Cable ft Shielded Cable ft Shielded Cable ft Machined Valve Bolt nut package Pressure Gauge O Ring Shielded Cable ft Shielded Cable ft Electrical Connector Pressure Gauge Hatch Decal Electrical Connector Bolt nut package Control Panel Electrical Ca Item Cost 4 25 3 75 1 05 1 05 1 05 1 1 1 05 655 5 3 75 90 2 45 1 05 1 1 25 100 5 0 75 1 65 3 75 255 D E Quantity Cost per order 82875 45000 588 24150 24675 19250 24675 81937 5 15937 5 19500 12000 560 23000 23500 17500 23500 125 4250 100 1300 22500 18200 5600 80 600 4500 4200 506 9000 3185 23625 18200 7000 8040 450 7425 15750 129030
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started