Question: answer a, b, c thanks Convert the accompanying database to an Excel table to find: a. The total cost of all orders. b. The total

answer a, b, c thanks
answer a, b, c thanks 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

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 Supplier Hulkey Fasteners Alum Sheeting Manley Valve Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Fast-Tie Aerospace Manley Valve Steelpin Inc. Durrable Products Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Hulkey Fasteners Manley Valve 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 Item Cost Quantity $4.25 19,500 $3.75 11,000 $1.10 560 $1.05 23,000 $1.05 22,500 $1.10 17,500 $1.05 24,500 $655.50 125 $3.75 4,250 $90.00 100 $2.45 1,300 $1.05 22,500 $1.00 18,200 $1.25 5,600 $110.50 70 Cost per order $82,875.00 $41,250.00 $616.00 $24,150.00 $23,625.00 $19,250.00 $25,725.00 $81,937.50 $15,937.50 $9,000.00 $3,185.00 $23,625.00 $18,200.00 $7,000.00 $7,735.00 Hulkey Fasteners Manley Valve Hulkey Fasteners Steelpin Inc. Steelpin Inc. Alum Sheeting Hulkey Fasteners Steelpin Inc. Steelpin Inc. Manley Valve Hulkey Fasteners Electrical Connector $1.25 Pressure Gauge $110.50 Hatch Decal $0.75 Electrical Connector $1.65 Bolt-nut package $3.75 Control Panel $255.00 Electrical Connector $1.25 Electrical Connector $1.65 Bolt-nut package $3.75 O-Ring $3.75 Airframe fasteners $4.25 5,600 70 500 4,500 4,200 706 5,500 4,850 4,150 00 18,500 $7,000.00 $7,735.00 $375.00 $7,425.00 $15,750.00 $180,030.00 $6,875.00 $8,002.50 $15,562.50 $5,625.00 $78,625.00

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!