Question: second image is the last 3 on the data set. i Database Convert the accompanying database to an Excel table to find: a. The total


second image is the last 3 on the data set.
i Database 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 $ b. The total quantity of airframe fasteners purchased is airframe fasteners. c. The total cost of all orders placed with Manley Valve Is $7. Supplier Item Description Item Cost Hulkey Fasteners Airframe fasteners S4.25 Alum Sheeting Airframe fasteners S3.75 Manley Valve Hatch Decal 51.05 Fast-Tie Aerospace Shielded Cableift. S1.05 Fast-Tie Aerospace Shielded Cableift. S1.05 Steelpin Inc. Shielded Cablu ft. S1.10 Fast-Tie Aerospace Shielded Cableift. S1.05 Manley Valve Machined Valve S650.00 Steelpin Inc. Bolt-nut package S3.75 Durrable Products Pressure Gauge S80.00 Fast-Tie Aerospace O-Ring $2.45 Fast-Tie Aerospace Shielded Cable ft. $1.05 Steelpin Inc. Shielded Cable/tt. $1.00 Hulkey Fasteners Electrical Connector 51.25 Manley Valve Pressure Gauge S100.50 Hulkey Fasteners Hatch Decal S0.75 Steelpin Inc. Electrical Connector S1.65 Steelpin Inc. Bolt-nut package S3.75 Alum Sheeting Control Panel S255.00 Hulkey Fasteners Electrical Connector S1.25 Steeloin Inc. Electrical Connector S1.10 Quantity Cost per order 19,500 $82,875.00 12,000 $45,000.00 570 $598,50 23,000 $24,150.00 21,500 $22.575.00 17.500 $19,250.00 25,500 $26,775.00 125 $81,250.00 4,250 $15.937.50 100 $8,000.00 1,300 $3,185.00 25,500 $23,625.00 18,200 $18,200.00 5,600 $7,000.00 80 $8,040.00 500 $375.00 4,500 $7,425.00 4,200 $15,750.00 706 $180,030.00 5,500 $6,875.00 4.850 $5.335.00 Print Done Enter your answer in each of the answer boxes. Steelpin Inc. Steelpin Inc. Manley Valve Hulkey Fasteners Electrical Connector Bolt-nut package O-Ring Airframe fasteners $1.10 $3.75 $2.85 $4.25 4,850 4,150 1300 16,500 $5,335.00 $15,562.50 $3,705.00 $70,125.00 i Database 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 $ b. The total quantity of airframe fasteners purchased is airframe fasteners. c. The total cost of all orders placed with Manley Valve Is $7. Supplier Item Description Item Cost Hulkey Fasteners Airframe fasteners S4.25 Alum Sheeting Airframe fasteners S3.75 Manley Valve Hatch Decal 51.05 Fast-Tie Aerospace Shielded Cableift. S1.05 Fast-Tie Aerospace Shielded Cableift. S1.05 Steelpin Inc. Shielded Cablu ft. S1.10 Fast-Tie Aerospace Shielded Cableift. S1.05 Manley Valve Machined Valve S650.00 Steelpin Inc. Bolt-nut package S3.75 Durrable Products Pressure Gauge S80.00 Fast-Tie Aerospace O-Ring $2.45 Fast-Tie Aerospace Shielded Cable ft. $1.05 Steelpin Inc. Shielded Cable/tt. $1.00 Hulkey Fasteners Electrical Connector 51.25 Manley Valve Pressure Gauge S100.50 Hulkey Fasteners Hatch Decal S0.75 Steelpin Inc. Electrical Connector S1.65 Steelpin Inc. Bolt-nut package S3.75 Alum Sheeting Control Panel S255.00 Hulkey Fasteners Electrical Connector S1.25 Steeloin Inc. Electrical Connector S1.10 Quantity Cost per order 19,500 $82,875.00 12,000 $45,000.00 570 $598,50 23,000 $24,150.00 21,500 $22.575.00 17.500 $19,250.00 25,500 $26,775.00 125 $81,250.00 4,250 $15.937.50 100 $8,000.00 1,300 $3,185.00 25,500 $23,625.00 18,200 $18,200.00 5,600 $7,000.00 80 $8,040.00 500 $375.00 4,500 $7,425.00 4,200 $15,750.00 706 $180,030.00 5,500 $6,875.00 4.850 $5.335.00 Print Done Enter your answer in each of the answer boxes. Steelpin Inc. Steelpin Inc. Manley Valve Hulkey Fasteners Electrical Connector Bolt-nut package O-Ring Airframe fasteners $1.10 $3.75 $2.85 $4.25 4,850 4,150 1300 16,500 $5,335.00 $15,562.50 $3,705.00 $70,125.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
