Question: Database Convert the accompanying database to an Excel table to find: The total cost of all orders. b. The total quantity of airframe fasteners purchased.

Database Convert the accompanying database to an

Database Convert the accompanying database to an Excel table to find: 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. BE! Click the icon to view the database. a. The total cost of all orders is $ $609.00 Supplier Item Description Hulkey Fasteners Airframe fasteners Alum Sheeting Airframe fasteners Manley Valve Hatch Decal Fast-Tie Aerospace Shielded Cable/ft. Fast-Tie Aerospace Shielded Cable/ft. Steelpin Inc. Shielded Cable/ft. Fast-Tie Aerospace Shielded Cable/ft. Manley Valve Machined Valve Steelpin Inc. Bolt-nut package Durrable Products Pressure Gauge Fast-Tie Aerospace O-Ring Fast-Tie Aerospace Shielded Cable/ft. Steelpin Inc. Shielded Cable/ft. Hulkey Fasteners Electrical Connector Manley Valve Pressure Gauge Hulkey Fasteners Hatch Decal Steelpin Inc. Electrical Connector Steelpin Inc. Bolt-nut package Alum Sheeting Control Panel Hulkey Fasteners Electrical Connector Steelpin Inc. Electrical Connector Steelpin Inc. Bolt-nut package Manley Valve O-Ring Hulkey Fasteners Airframe fasteners Item Cost $4.25 $3.75 $1.05 $1.05 $1.05 $1.10 $1.05 $655.50 $3.75 $80.00 $2.45 $1.05 $1.00 $1.25 $110.50 $0.75 $1.65 $3.75 $255.00 $1.25 $1.10 $3.75 $3.75 $4.25 Quantity Cost per order 19.500 $82,875.00 14,000 $52,500.00 580 23.000 $24,150.00 21.500 $22,575.00 17,500 $19,250.00 24,500 $25,725.00 125 $81,937.50 4,250 $15,937.50 100 $8,000.00 1,300 $3,185.00 22,500 $23,625.00 18,100 $18,100.00 5,600 $7,000.00 70 $7,735.00 600 $450.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 4,150 $15,562.50 1500 $5,625.00 18,500 $78,625.00 Enter your answer in the answer box and then click Check Answe Print Done o parts

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!