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.

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

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 Accounting Questions!