80.2K

Verified Solution

Link Copied!

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 $ Database 0 1,300 Supplier Item Description Item Cost Quantity Cost per order Hulkey Fasteners Airframe fasteners $4.25 19,500 $82,875.00 Alum Sheeting Airframe fasteners $3.75 14,000 $52,500.00 Manley Valve Hatch Decal $1.10 580 $638.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 23,000 $24,150.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 21,500 $22,575.00 Steelpin Inc. Shielded Cable/ft. $1.10 17,500 $19,250.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 24,500 $25,725.00 Manley Valve Machined Valve $650.00 125 $81,250.00 Steelpin Inc. Bolt-nut package $3.75 4,250 $15,937.50 Durrable Products Pressure Gauge $80.00 100 $8,000.00 Fast-Tie Aerospace O-Ring $2.45 $3,185.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 22,500 $23,625.00 Steelpin Inc. Shielded Cable/ft. $1.00 18,300 $18,300.00 Hulkey Fasteners Electrical Connector $1.25 5,600 $7,000.00 Manley Valve Pressure Gauge $100.50 80 $8,040.00 Hulkey Fasteners Hatch Decal $0.75 500 $375.00 Steelpin Inc. Electrical Connector $1.65 4,500 $7.425.00 Steelpin Inc. Bolt-nut package $3.75 4,200 $15.750.00 Alum Sheeting Control Panel $255.00 706 $180,030.00 Hulkey Fasteners Electrical Connector $1.25 5,500 $6,875.00 Steelpin Inc. Electrical Connector $1.65 4,850 $8.002.50 Steelpin Inc. Bolt-nut package $3.75 4,150 $15,562.50 Manley Valve O-Ring $2.45 1400 $3.430.00 Hulkey Fasteners Airframe fasteners $4.25 18,500 $78,625.00 Print Done

Answer & Explanation Solved by verified expert

See Answer